Question: CASE NOTES: The spreadsheet contains the sales data for two years from Isabella's current location. For the analysis complete the following : -Graph 2019 &
CASE NOTES:
The spreadsheet contains the sales data for two years from Isabella's current location.
For the analysis complete the following:
-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!)
-Seasonal 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
| MONTH | 2019 SALES DOLLARS (000) | 2020 SALES DOLLARS (000) |
| January | $ 3,500.00 | $ 4,080.00 |
| February | $ 15,400.00 | $ 17,680.00 |
| March | $ 19,600.00 | $ 20,400.00 |
| April | $ 30,800.00 | $ 30,600.00 |
| May | $ 21,700.00 | $ 23,120.00 |
| June | $ 35,700.00 | $ 30,600.00 |
| July | $ 17,500.00 | $ 15,300.00 |
| August | $ 21,000.00 | $ 23,120.00 |
| Sept | $ 49,700.00 | $ 57,120.00 |
| Oct | $ 63,000.00 | $ 62,560.00 |
| Nov | $ 30,800.00 | $ 27,608.00 |
| Dec | $ 50,400.00 | $ 51,340.00 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help