Question: just question e please! HRTM 310 Ch. 9 Demand Forecasting Method: Homework 2. You are a manager of Harris Grill with 110 seats. You have

just question e please! just question e please! HRTM 310 Ch. 9 Demand Forecasting Method: Homework

HRTM 310 Ch. 9 Demand Forecasting Method: Homework 2. You are a manager of Harris Grill with 110 seats. You have tracked the total number of meals served on a weekly basis for the past 20 weeks and the number of meals is as shown in the table below. Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Demand 499 538 489 535 547 511 489 533 502 552 512 530 515 502 499 511 502 535 512 528 1. (l points) Forecast demand for week 21 using 5-week simple moving average. Show your calculations b. (2 points) Forecast demand for week 21 using 3-week weighted moving average by appropriately choosing and assigning weights from 25%, 65% and 10%. Show your calculations c. (3 points) If you were to use the exponential smoothing method to forecast demand for week 21, would you use a high or a low alpha value? Explain why. Explain your answer with supporting material (c.g. Generating a graph of data to support your answer). d. (points) You decided to use exponential smoothing method to forecast for the week 21 and also decided to use an alpha value of 0.8. Then, how much weight will be placed on the actual de lata from week 20 19 and 18, respectively? Manually calonlate the weights. Show your color 4. (3 points) Assume that the current period is the end of week 3 and you want to forecast demand for week 4. Manually calculate demand forecast for week 4 using simple exponential smoothing method with an alpha value of 0.8. Initialize the method by using actual demand from week 1 as forecast for week 1. Show your calculation

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 Accounting Questions!