Here are the data for the past 21 months for actual sales of a particular product: January February March April May June July August September October November December LAST YEAR 330 450 455 455 410 435 400 310 355 480 555 540 THIS YEAR 285 385 355 410 440 350 Forecast for the fourth quarter 390 300 395 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. Solve the problem using quarters, as opposed to forecasting separate months. Note: Round your answer to 2 decimal places.

Here are the data for the past 21 months for actual sales of a particular product: January February March April May June July August September October November December LAST YEAR 330 450 455 455 410 435 400 310 355 480 555 540 THIS YEAR 285 385 355 410 440 350 Forecast for the fourth quarter 390 300 395 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. Solve the problem using quarters, as opposed to forecasting separate months. Note: Round your answer to 2 decimal places.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

How to communicate requirement for a project
Question 9
QUESTION 7 Which process domain is the MOST suitable for managing the Capacity and Availability of systems? O a. Build, Acquire and Implement (BAI) O b. Monitor, Evaluate and Assess (MEA) OC. Deliver, Service and Support (DSS) O d. Align, Plan and Organize (APO)
Q: Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 consider Cake (C) 0 -0.5 4.5 0.5 1E+30 $C$5 consider Dozen Cookies (D) 10 0 10 1E+30 1 what does the value minus .5 for the reduced cost of C mean (other than it is the change in thevalue of the coefficient in the objective function so that the solution includes a positive amountof C)?