for Function 12 Pivot Table Table Pictures To Shapes V Link u New Comment Al Text Box Add-ins TextBox 2 B D F G H 1 K L M N o O R S T U V W 2019-2020 SALES FOR CURRENT LOCATION 1 2 3 4 Average Pizza Price: $25.00 CASE NOTES: The spreadsheet contains the sales data for two years from Isabella's current location. 5 6 For the analysis complete the following: 7 8 9 10 2019 SALES 2020 SALES DOLLARS (000) DOLLARS (000) $ 3,500.00 $ 4,080.00 $ 15,400.00 $ 17,680.00 $ 19,600.00 $ 20,400.00 $ 30,800.00 $ 30,600.00 $ 21,700.00 $ 23,120.00 $ 35,700.00 $ 30,600.00 $ 17,500.00 $ 15,300.00 $ 21,000.00 $ 23,120.00 $ 49,700.00 $ 57,120.00 $ 63,000.00 $ 62,560.00 $ 30,800.00 $ 27,608.00 $ 50,400.00 $ 51,340.00 MONTH January February March April May June July August Sept Oct Nov Dec 11 -Graph 2019 & 2020 on the same graph to look for seasonality. Hint: How often does the data appear to repeat & in what timeframes? -Determine how many seasons there are? -Complete a forecast analysis for 2021's new location. Include the following: -2019-2020 Average Seasonal Sales -2019-2020 Overall Average Sales (24 months of data!) asonal Index for each season -2021 Sales Projection - She expect 2020 sales with a 4% increase at the new location. -Breakdown of 2021 Sales Projections by Season 12 13 14 15 16 17 18 19 20 21 22 23 24 = Unit Sales +