Part 2 (12 marks) Month Forecast Requirement Actual Requirement 1 450 500 2 420 548 3 410
Question:
Part 2 (12 marks) Month Forecast Requirement Actual Requirement 1 450 500 2 420 548 3 410 556 4 478 604 5 532 635 6 495 607 7 545 631 8 519 668 In the above data table, the manager of DBS Pizzas & Caf has provided you historical data on their monthly requirement of takeaway containers over the last eight months of operations along with corresponding forecast requirements for those months that they had calculated on their own using some unknown forecasting method. Q4. Calculate the forecast requirement of takeaway containers for the next (i.e., ninth) month using a two-month, a three-month, a four-month and a five-month simple moving average. Compute the MSE for each of those different moving averages and compare your results. (4 marks) Q5. Using the same data on actual monthly requirement, find the best single exponential smoothing model by evaluating the MSE, starting with an alpha of 0.10 and changing alpha in increments of 0.10. How does the best single exponential smoothing model compare with the best simple moving average model you found in Q4? (4 marks) Q6. Suppose that DBS Pizzas & Caf was thinking about opening a brand-new outlet in Melbourne CBD where they have no presence as yet. How could they go about forecasting demand and sales for the proposed new outlet? (4 marks)