Question: Case Study 1: The AusCandy Demand (10 marks) The following table shows the historical demand data for product A in AusCandy Co. Answer the following

Case Study 1: The AusCandy Demand (10 marks) The
Case Study 1: The AusCandy Demand (10 marks) The following table shows the historical demand data for product A in AusCandy Co. Answer the following questions. Actual Actual Period demand Period demand 25 13 24 21 14 26 11 15 38 DAWN- 12 16 30 14 17 23 18 18 40 32 19 41 23 20 32 25 21 44 10 20 22 41 26 23 28 12 29 a. Forecast for period 24 using the following three methods: Exponential smoothing with alpha = 0.25; Moving average with n= 5; and Linear trend (2.5 marks) b. Using MAPE, what is the best forecast method in Part a? (2.5 marks) c. Based on your answer in Part b, use a tracking signal to see whether there is any bias in error over time. In case of any bias in error what would be your recommendation? (5 marks) For tracking signal please . Calculate tracking signal from period 15 onwards. . Use limits of + 5 and a = 0.20 Important note: Use MAPE for error calculations Brief explanation is required for each

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!