Question: Solve using excel please Pls describe the Exponential Smoothing forecasting methods (5 marks) and solve below forecasting problem with using Exponential Smoothing technique It has
Solve using excel please
Pls describe the Exponential Smoothing forecasting methods (5 marks) and solve below forecasting problem with using Exponential Smoothing technique It has been almost 1 year that Costa coffee had opened a new branch at City Mall of Muscat, and sales performance of coffee shop is going well. The head office has been curious about progress of store, and they asked the store manager to forecast expected sales of period 12, where below table shows the monthly sales in OMR in Thousand. What will be the projected sales of Costa Coffee at: a) a value is at 0.2 (2.5 marks) b) value is at 0.4 (2.5 marks) c) a value is at 0.7 (5marks) d) and visualize all forecast on graph (5 marks) 12 Period Actual 1 80 90 2 120 3 70 5 190 6 150 7 175 3 210 9 350 10 290 sa 11 320 210
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
