CASE NOTES:

The spreadsheet contains the sales data for two years from Isabella's current location.

For the analysis complete the following:

-Graph 2020 & 2021 sales 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 2022's new location. Include the following:

-2020-2021 Average Seasonal Sales

-2020-2021 Overall Average Sales (24 months of data!)

-Seasonal Index for each season

-2022 Aggregate Sales Projection - She expect 2021 sales with a 4% increase at the new location.

-Breakdown of 2022 Sales Projections by Season

2020 - 2021 SALES FOR CURRENT LOCATION Average Pizza Price: $38.00 MONTH January February March April |May June July August Sept Oct 2020 SALES 2021 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 Nov Dec