Remaining Time: 1 hour, 05 minutes, 52 seconds. Question Completion Status: Forecasting Problem (8 marks) Note:...

Transcribed Image Text:

Remaining Time: 1 hour, 05 minutes, 52 seconds. Question Completion Status: Forecasting Problem (8 marks) Note: Show your detalled calculation steps and round to 2 decimal places The supply chain manager of the company MoAng Coffee represented the demand in the past 7 months with the graph below: 690 680 670 660 650 Demand 640 630 620 610 600 590 580 1 3 S Month 7 1. Based on the graph, can you say which forecasting method would be more appropriate among linear regression, simple moving average and weighted moving average? Why? (1 mark) 2. The data below represents the actual demand and forecast values using 4 month simple moving average, 4 month weighted moving average (weights are 0.4, 0.4, 0.1, 0.1) and linear regress reported by the company. Month Demand SMA Abs. Dev WMA Abs. Dev LR Abs. Dev 1 680 2 662 3 647 4 650 5 626 659.75 6 596 646.25 33.75 50.25 653 641.3 27 45.30 623.75 609.93 2.25 13.93 7 602 The outout of linear regression using Excel is as follows Remaining Time: 1 hour, 05 minutes, 52 seconds. Question Completion Status: Forecasting Problem (8 marks) Note: Show your detalled calculation steps and round to 2 decimal places The supply chain manager of the company MoAng Coffee represented the demand in the past 7 months with the graph below: 690 680 670 660 650 Demand 640 630 620 610 600 590 580 1 3 S Month 7 1. Based on the graph, can you say which forecasting method would be more appropriate among linear regression, simple moving average and weighted moving average? Why? (1 mark) 2. The data below represents the actual demand and forecast values using 4 month simple moving average, 4 month weighted moving average (weights are 0.4, 0.4, 0.1, 0.1) and linear regress reported by the company. Month Demand SMA Abs. Dev WMA Abs. Dev LR Abs. Dev 1 680 2 662 3 647 4 650 5 626 659.75 6 596 646.25 33.75 50.25 653 641.3 27 45.30 623.75 609.93 2.25 13.93 7 602 The outout of linear regression using Excel is as follows