Given the following demand numbers, create a forecast for April through January of the following year....

50.1K

Verified Solution

Question

Finance

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

Answer & Explanation Solved by verified expert

4.2 Ratings (903 Votes)

See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

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