Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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! image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

Consider some type of redress for the customer, such as a coupon.

Answered: 1 week ago

Question

Sell the quality of your brand or products.

Answered: 1 week ago