Question

HYV Score: 60%, 18 of 30 pt 44 of 22 (17 complete)> Score: 0 of 2 pts Show Work Question Help Problem 2 Develop a two-period weighted moving average forecast for periods 12 through 15. Use weights of 0.9 and 0.1, with the most recent observation weighted higher. Demand 210 347 458 241 403 Period 10 12 13 14 Calculate the forecasts for periods 12-15 by using a two-period weighted moving average model (enter your responses rounded to the nearest whole number). Forecast Demand 210 347 458 Period 12

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Ans:

Period

Demand

Forecast

10

210

11

347

12

458

333

13

241

447

14

403

263

15

387

Calculation

Period

Demand

Forecast

10

210

11

347

12

458

347*.90+210.10=333.3

13

241

458*.90+347.10=446.9

14

403

241*.90+458.10=262.70

15

403*.90+241.10=386.80

Formulas

1 Period Demand Forecast 210 347 458 B3*.90+B2.10 241 B4*.90+B3.10 403 B5 .90+B4.10 10 4 12 13 14 15 5 B6*.90+B5.10

Add a comment
Know the answer?
Add Answer to:
HYV Score: 60%, 18 of 30 pt 44 of 22 (17 complete)> Score: 0 of 2...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Develop a two-period weighted moving average forecast for periods 12 through 15. Use weights of 0.9...

    Develop a two-period weighted moving average forecast for periods 12 through 15. Use weights of 0.9 and 0.1, with the most recent observation weighted higher Demand 229 389 461 330 406 Period 10 12 13 Calculate the forecasts for periods 12-15 by using a two-period weighted moving average model (enter your responses rounded to the nearest whole number) Demand 229 389 461 330 Forecast Period 10 12 13 14 406

  • Please help with questions 7 - 10. PART IV Planning and Controling Operations and Supply Chains...

    Please help with questions 7 - 10. PART IV Planning and Controling Operations and Supply Chains 290 period 1 was 250. Plot the results. Which model appears to work better? Why? 10. After graduating from college, you and your friends start selling birdhouses made from recycled plast has caught on, as shown by the following sales figures For problems 4 through 6, use the following time series data: The idea DEMAND MONTH January 2012 February March April May June 119...

  • Prin. of Supply Chain and Ops Management Section 002 Fall 2020 Homework: Homework 2 - Chapters...

    Prin. of Supply Chain and Ops Management Section 002 Fall 2020 Homework: Homework 2 - Chapters 9 and 10 with 5 extra credit Score: 0 of 2 pts 8 of 24 (10 complete) Problem 3 Develop an exponential smoothing forecast (a=0.70) for periods 11 through 15 Assume that your forecast for period 10 was 236 Period 10 11 12 13 14 Demand 207 396 470 326 420 Calculate the forecasts for periods 11 through 15 (enter your responses rounded to...

  • The following table gives the number of pints of type A blood used at Damascus Hospital...

    The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6​ weeks: The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6​ weeks: The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6​ weeks: ​a) The forecasted demand for the week of October 12 using a​ 3-week moving average​ =_________ pints...

  • Homework: Homework #2 Score: 0 of 1 pt 4 of 15 (3 Problem 4.13 can see Heart Transplants 45.0 50.0 55.0 56.0 58.0...

    Homework: Homework #2 Score: 0 of 1 pt 4 of 15 (3 Problem 4.13 can see Heart Transplants 45.0 50.0 55.0 56.0 58.0 a) Using exponential smoothing with a of 0.60 and the given forecast for year 1, the forecasts for years 2 through 6 are (round your responses to ane decimal place) 56.6 Forecast 41.0 43.4 474 2 ound yo response to one decimal place For the forecast made us ng exponential smoothing with α-Ο 60 and the given...

  • Week Sales (100s of gallons) 1 18 2 22 3 19 4 24 5 17 6...

    Week Sales (100s of gallons) 1 18 2 22 3 19 4 24 5 17 6 16 7 21 8 19 9 23 10 21 11 15 12 21 a. using a weight of 1/2 for the most recent observation, 1/3 for the second most recent observation, and 1/6 for the third most recent observation, compute a three-week weighted moving average for the time series (to 2 decimals). Enter negative values as negative numbers. b. compute the MSE for the...

  • Pints Used 360 Week Of August 31 September 7 September 14 September 21 September 28 October...

    Pints Used 360 Week Of August 31 September 7 September 14 September 21 September 28 October 5 370 408 381 368 371 a) The forecasted demand for the week of October 12 using a 3-week moving average = 373.33 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.20, 0.30, and 0.50, using 0.50 for the most recent week, the forecasted demand for the week of October 12 = 372.10 pints...

  • the following table gives the number of pints of type A blood used at Damascus Hospital...

    the following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks Week Of August 31 September 7 September 14 September 21 September 28 October 5 Pints Used 345 370 410 383 371 374 a) The forecasted demand for the week of October 12 using a 3-week moving average = 376 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.10.0 25,...

  • The following table gives the number of pints of type A blood used at Damascus Hospital...

    The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6​ weeks:                                                          Week Of Pints Used August 31 345 September 7 389 September 14 410 September 21 381 September 28 371 October 5 378 ​a) The forecasted demand for the week of October 12 using a​ 3-week moving average = 376.67 pints (round your response to two decimal places.) b) Using a 3-week weighted moving average, with weights of 0.15,...

  • Week Of Pints Used September 14 410 September 28 October 5 371 378 The forecasted demand...

    Week Of Pints Used September 14 410 September 28 October 5 371 378 The forecasted demand for the week of October 12 using a 3-week movingrage 377.33 pints (round your response to two b)Using a 3-week weighted moving average. with weights of 0.10,025, and 065,using 0 65 for the most c) it the forecasted demand for the week of August 31 is 345 and 025 exponential to two decimal places). recent week, the forecasted demand for the week of October...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT