Share
Explore BrainMass

Printer Rent Forecast

The owner of a computer store rents printers to some of her preferred customers. She is interested in arriving at a forecast of rentals so that she can order the correct quantities of supplies that go with the printers. The data is shown blow.

a. Prepare a forecast for weeks 4 - 10 by using the three week moving average. What is the forecast for week 11.

Week Rentals
1 25
2 28
3 30
4 26
5 27
6 22
7 26
8 24
9 20
10 23

Attachments

Solution Summary

Excel file attached shows how to prepare a forecast for upcoming weeks using a three week moving average.

$2.19