Question: (This data will be used for Forecasting 1 Questions 7-11) A local restaurant has recorded the demand for bottled water in each of the last

(This data will be used for Forecasting 1(This data will be used for Forecasting 1(This data will be used for Forecasting 1

(This data will be used for Forecasting 1 Questions 7-11) A local restaurant has recorded the demand for bottled water in each of the last 15 months of business. Use the recorded demand data below to develop three-period and four-period moving average forecasts for bottles of water. Round off all calculations to two decimal places. Maintaining two decimal places is required for all calculations. Period Demand Period Demand Period Demand 1 890 6 890 11 870 2 910 7 960 12 860 3 905 8 895 13 900 4 850 9 910 14 940 5 860 10 905 15 925 What is the forecast for period 16 using the three period weighted method? (Weights are t=0.5t-1-0.4 and t-2-0.1) Less than or equal to 910 Greater than 910 but less than or equal to 920 Greater than 920 but less than or equal to 930 Greater than 930 Question 8 3 pts What is the forecast for period 16 using the four-period weighted method? Weights are t=0.3.t-1-0.2,t-2-0,3 and t-3-0.2) Less than or equal to 910. Greater than 910 but less than or equal to 920 Greater than 920 but less than or equal to 930 Greater than 930 Question 9 3 pts What is the MAD for the three-period weighted moving-average forecast as of period 15? Less than or equal to 20 Greater than 20 but less than or equal to 30 Greater than 30 but less than or equal to 40 Greater than 40 What is the MAPE for the four-period weighted moving average forecast as of period 15? Less than or equal to 3.00% Greater than 3.00% but less than or equal to 3.50% Greater than 3.50% but less than or equal to 4.00% Greater than 4.00% Question 11 3 pts Which forecast is the best (the three-period or four-period weighted method)? The 3-period moving average is the best forecast because the MAD and MAPE are less than the 4-period moving average MAD and MAPE. The 3-period moving average is the best forecast because the MAD and MAPE are greater than the 4-period moving average MAD and MAPE. The 4-period moving average is the best forecast because the MAD and MAPE are less than the 3-period moving average MAD and MAPE. The 4-period moving average is the best forecast because the MAD and MAPE are greater than the 3 period moving average MAD and MAPE

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!