In: Operations Management
Sara’s Ice Cream Shop is closed for six months out of the year
but has had the monthly sales amounts listed below for the last
four years.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Asssuming that there is both seasonality and a trend, estimate monthly sales for each month of the coming year.
2021 | |
MAY | |
JUNE | |
JULY | |
AUGUST | |
SEPTEMBER | |
OCTOBER | |
Monthly Sales will be as follows:
2021 | May | 698587 |
June | 804999 | |
July | 1488059 | |
August | 1698693 | |
September | 921247 | |
October | 504484 |
Fianl Outcome will be as follows: Follow Step by Step
STEP 1- Finding Intercept (Follow the excel formula)
STEP 2- Finding Slope (Follow the excel formula)
STEP- 3 Finding LT Forecast (Follow the excel formula) Drag till the last i.e. 2021 October
STEP-4 Finding Seasonality Index (Follow the excel formula)
STEP 5 Finding Seasonal Forecast with Trend (Follow the excel formula) Drag till the last i.e. 2021 October