Question: (I cannot put in the demand data table because the table is an image, but you can come up with demand data for periods 1-9).

(I cannot put in the demand data table because the table is an image, but you can come up with demand data for periods 1-9). 1. The following data points represent monthly sales for take-out meals at the UTRGV student union. You are tasked to evaluate the forecast for periods 6, 7 and 8 by following the instructions bellow. 1. Prepare data for the forecast i. Fill in values for the intercept (St) for period 4 That is, fill in S4 by using a MA(3) of the previously observed data. ii. Fill in values for the slope (G+) for period 4 1. Fill in G4 by using 20% of S4. 2. Calculate the forecast for periods 6, 7 and 8 with double exponential smoothing by using Holt's method with a (-step-ahead forecast with a = 0.2 and = 0.1. Show the equations and calculations for credit or equations in your spreadsheet. 3. Calculate the mean absolute deviation (MAD) for your forecasts, and comment on the forecast.
 (I cannot put in the demand data table because the table

(1) cannot put in the demand data table because the table is an image, but you can come up with demand data for periods. 1-9). 1. The following data points represent monthly sales for take-out meals at the UTRGV student union. You are tasked to ovaluate the forecast for periods 6,7 and 8 by following the instructionis bellow: 1. Prepare data for the forecast 1. Fill in values for the intercept (st) for period 4 1. That is, fill in S4 by using a MA(3) of the previously observed data 1.. Fill in values for the slope (Gy) for perfod 4 1. Fill in G4 by using 2096 of $4. 2. Calculate the forecast for periods 6,7 and 8 with double exponenthal smoothing by using Holt's method with a (-step-ahead forecast with =0.2 and =0.1. Mis. Show the equations and calculations for credit or equations in your spreadtheet. 3. Calculate the mean sbsolute deviation (MAD) for your forecasts, and comment on the forecast

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!