Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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 & 9 10 11 12 13 14 15 16 17 18 19 20 Demand 499 538 489 535 547 SII 489 533 SOZ 552 512 530 SIS SO2 499 STI 502 $35 $12 528 . ( points) Forecast demand for week 21 using 5-week simple moving average. Show Me 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 (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 leg.. Generating a graph of data to support your answer) d. (2 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 demand data from week 20, 19, and 18. respectively. Manually calculate the weights Show we calculations 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 wock 4 using simple exponential mooling method within alpha value of 0 8. Initialize the method by using actual demand front week las forecast for week 1 Scale

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

Recommended Textbook for

Survey Of Accounting

Authors: Carl S. Warren

4th Edition

0538478144, 9780538478144

More Books

Students also viewed these Accounting questions

Question

Define Administration?

Answered: 1 week ago

Question

What other blunt questions do you think would be appropriate?

Answered: 1 week ago