The following data summarizes the historical demand for a product: Month Actual
ID: 3318894 • Letter: T
Question
The following data summarizes the historical demand for a product:
Month Actual Demand
March 20
April 25
May 40
June 35
July 30
August 45
Use a four-period moving average to determine the forecasted demand for July, August, and September. Select correct answer and show all your calculations with details.
A) July forecast = 32.5; August forecast = 33.5; September forecast = 37.5
B) July forecast = 31.33; August forecast = 34.5; September forecast = 37.5
C) July forecast = 30; August forecast = 33.5; September forecast = 40.5
D) July forecast = 30; August forecast = 32.5; September forecast = 37.5
If the forecasted demand for June, July, and August is 32, 38 and 42, respectively, what is MSE? Select correct answer and show all your calculations with details.
A) MSE = 15.13
B) MSE = 17.32
C) MSE = 27.33
D) Non of these alternatives is correct
Explanation / Answer
Actual Demand Moving average 4-period Mar 20 Apr 25 May 40 June 35 July 30 30 Average of Mar- June Aug 45 32.5 Average of Apr- July 37.5 Average of May- June Hence, d is the answer forecast Actual Error Squared Error June 32 35 3 9 July 38 30 -8 64 Aug 42 45 3 9 MSE 27.33333333 Hence c is the answer
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.