Help Save & Ex Here are the data for the past 21 months for actual sales of a pa

Question

Help Save & Ex Here are the data for the past 21 months for actual sales of a particular product 279 350 320 400 475 475 440 445 450 310 September 370 550 605 510 February March April May June uly August 450 380 365 360 265 370 October November Develop a forecast for the fourth quarter using a three-quarter, weighted moving average. Weight the most recent quarter 0.50, the second most recent 0.25, and the third 0.25. Do the problem using quarters, as opposed to forecasting separate months. (Round you answer to 2 decimal places.) Prev 1 of 5 Next > search

Explanation / Answer

Sales of the third most recent quarter = 279+350+355 =984

Sales of the second most recent quarter =450+380+365=1195

Sales of the first most recent quarter =360+265+370=995

Weighted moving average forecast= 0.5*995 + 0.25*1195 + 0.25*984 =497.5+298.75+246

Weighted moving average forecast=1042.25

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.