Calculate a forecast of the above demand using a 3 - 95141

Solution Posted by
Solution Detail
Price: $15.00
Request Description
Day Demand 1 200 2 134 3 157 4 165 5 177 6 125 7 146 8 150 9 182 10 197 11 136 Develop a spreadsheet to answer the following questions. 12 163 • Calculate a forecast of the above demand using a 3- and 5-period moving average. 13 157 • Graph these forecasts and the original data using Excel. What does the graph show? 14 169 • Which of the above forecasts is best? Why?
Solution Description
<
Attachments
The_graph_shows_that_vertical_displacements_(from_the_actual_demand)_are_lesser_for_5-_period_moving
The_graph_shows...