Problem 3: (5 Points) The Saki motorcycle dealer in the Minneapolis-St. Paul are
ID: 428541 • Letter: P
Question
Problem 3: (5 Points) The Saki motorcycle dealer in the Minneapolis-St. Paul area wants to make an accurate forecast of demand for the Saki Super TXII motorcycle during the next month. Because the manufacturer is in Japan, it is difficult to send motorcycles back or reorder if the proper number is not ordered a month ahead. From sales records, the dealer has accumulated the following data for the past year: Month Motorcycle Sales January February March April May June July 10 12 a. Compute a 3-month moving average forecast of demand for April through August (of the next year). b. Compute a 5-month moving average forecast for June through August.Explanation / Answer
3 month moving avg 5 month moving avg Jan 9 Feb 7 March 10 April 8 (9+7+10)/3 =8.67 May 7 (7+10+8)/3=8.33 June 12 (10+8+7)/3=8.33 9+7+10+8+7)/5=8.2 July 7 (8+7+12)/3=9 (7+10+8+7+12)/5=8.8 August (7+12+7)/3=8.67 (10+8+7+12+7)/5=8.8
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.