HomeworkLib
Question





Based on the following data determine the sixth forecast using Weighted Moving Average with (45 %, 35%, 15%, 5%) Period Actua
business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

F6 = w4 A r-4 + w3 A r-3 +w2 A r-2 ​​​​​​​+w1 A r-1

F6 = 0.05*37 + 0.15*54 + 0.35*94 + 0.45*62

F6 = 70.75

​​​​​​​Please leave a like. Thanks a lot.

0 0
Add a comment
Know the answer?
Add Answer to:
Based on the following data determine the sixth forecast using Weighted Moving Average with (45 %,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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

  • "The MAD for the forecast developed using a weighted​ 2-year moving average with weights of 0.45...

    "The MAD for the forecast developed using a weighted​ 2-year moving average with weights of 0.45 and 0.55 = __ miles ​(round your response to one decimal​ place).  ​(Hint: You will have only 3 years of matched​ data.)" Score: 0 of 1 pt 3 of 5 (1 complete) HW Score: 0%, 0 of 5 pts Problem 4.5 Question Help The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to...

  • If you made a forecast for Week 19, based on a 3 week weighted moving average,...

    If you made a forecast for Week 19, based on a 3 week weighted moving average, with oldest data to most recent data weighted 0.20, 0.30, and 0.50, respectively, how much would your forecast be different from the actual jobless claims? Week Jobless claims (in thousands) 1 400 2 393 3 392 4 396 5 404 6 385 7 368 8 366 9 387 10 375 11 402 12 355 13 379 14 373 15 361 16 351 17 353...

  • Using the data below, what is the weighted moving average forecast for the 4th week? The...

    Using the data below, what is the weighted moving average forecast for the 4th week? The weights are 20,30.50 (oldest period to most recent period) Week Time Series Value 17.00 17.00 7.00 20.00 Submit Answer format: Number: Round to: 1 decimal places. Using the data below and the SES forecast 00.3, what is the error for the 3rd week? Week Time Series Value 6.00 19.00 17.00 23.00 Submit

  • Use a three-period simple moving average and weighted-moving average and Naive methods to forecast the 8th...

    Use a three-period simple moving average and weighted-moving average and Naive methods to forecast the 8th month. Calculate and compare the MAD for methods. Month Sales MA AD WMA AD Naive AD 1 20 --- --- --- --- --- --- 2 25 --- --- --- --- --- --- 3 22 --- --- --- --- --- --- 4 26 5 22 6 24 7 26 8 ---- ? ? AD: Absolute Deviation MA: Moving Average WMA: Weighted Moving Average

  • The actual values for 12 periods (shown in order) are: Period Data 1 45 2 52...

    The actual values for 12 periods (shown in order) are: Period Data 1 45 2 52 3 48 4 59 5 55 6 55 7 64 8 58 9 73 10 66 11 69 12 74 In Excel, create forecasts for periods 6-13 using each of the following methods: -------- -5 period simple moving average; Using a 5 period simple moving average, the forecast for period 13 will be: 68 -4 period weighted moving average (0.63, 0.26, 0.08, 0.03); Using...

  • In Excel, create a forecast for periods 6-13 using the following method: 5 period simple moving...

    In Excel, create a forecast for periods 6-13 using the following method: 5 period simple moving average. Using a 5 period simple moving average, the forecast for period 13 will be: Period Data 1 45 2 52 3 48 4 59 5 55 6 55 7 64 8 58 9 73 10 66 11 69 12 74

  • 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

  • Calculate the following forecasts using the data below. For periods 4 through 10, develop the exponentially...

    Calculate the following forecasts using the data below. For periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3 (F3) of 45.0 and an alpha of 0.4. Calculate the three-period moving-average forecast for periods 4 through 10. Calculate the weighted moving average for periods 4 through 10, using weights of .70, .20, and .10, with 0.70 applied to the most recent data Calculate the mean absolute deviation (MAD) for each forecasting procedure. Which forecasting procedure...

  • VORE Senty Editor Use a three period simple moving average and weighted-moving average and Naive methods...

    VORE Senty Editor Use a three period simple moving average and weighted-moving average and Naive methods to forecast the 8th month Calculate and compare the MAD for methods AD WMA AD Naive AD Month Sales MA 1 20 2 25 3 22 4 26 5 22 6 24 7 26 8 ? AD: Absolute Deviation MA: Moving Average WMA: Weighted Moving Average

  • Prepare weekly forecasts for week 15 for each product using Moving Average forecasting technique using a...

    Prepare weekly forecasts for week 15 for each product using Moving Average forecasting technique using a 2 -6 period moving average. Then use error analysis or forecast accuracy techniques for the 2 - 6 period moving averages. Week Product 1 Product 2 1 50 40 2 54 38 3 57 41 4 60 46 5 64 42 6 67 41 7 90 41 8 76 47 9 79 42 10 82 43 11 85 42 12 87 49 13 92...

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