Transcribed Image Text
Given the following demand numbers, create a forecast for Aprilthrough January of the following year. The forecast demand for atime period is the average of the previous three time periods. Thisis called a three-period moving average. For example, the AprilForecast of 101 is the average of the Demand for January throughMarch. The following table contains the demand numbers and theforecast. Use Excel to calculate the values in the Forecast column.A spreadsheet without formulas will not receive any credit. MonthDemand Forecast January 119 February 72 March 113 April 82 101 May82 89 June 131 92 July 111 98 August 116 108 September 89 119October 95 105 November 88 100 December 90 91 January 91
Other questions asked by students
Civil Engineering
Advance Math
Accounting
Geometry
Accounting
Accounting
Accounting