Question: 12.28 Develop an exponential smoothing forecast with = .20 for the demand data in Problem 12.1. Compare this forecast with the three-month moving average computed

12.28 Develop an exponential smoothing forecast with = .20 for the demand data in Problem 12.1. Compare this forecast with the three-month moving average computed in 12.1a. using MAD and indicate which forecast seems to be most accurate.

12.1 The Hartley-Davis motorcycle dealer in the MinneapolisSt. Paul area wants to be able to forecast accurately the demand for the Roadhog Super motorcycle during the next month. From sales records, the dealer has accumulated the data in the following table for the past year.

MONTH	MOTORCYCLE SALES
January	9
February	7
March	10
April	8
May	7
June	12
July	10
August	11
September	12
October	10
November	14
December	16

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Develop an exponential smoothing forecast with = 0.20 for the demand data in Problem 12-1. Compare this forecast with the three-month moving average computed in 12-1(a) using MAD and indicate which...

Problem 6-11 For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83. Choose the correct time...

5. Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23 13 21 13 19 21 17 (a) Choose the correct time series plot. (1) 30 25 20 Value 15 10 5 0 1 2 5 7 4 Month (11) 30 25 20 Value 10...

20 Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize. a....

Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize.MONTHACTUAL...

Maverick Jeans' demand manager decided to evaluate exponential smoothing. To maintain comparability, she used the data from problem 6. a. Use a starting forecast of 20 for month 4 to develop...

Question 5 (20 Points) I would recommend using Excel for this question. Your Instructor is trying to determine what forecasting method to use. Based upon the following historical data, calculate the...

PLEASE SOLVE THE FOLLOWING QUESTION ON EXCEL Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and specify...

PLEASE SHOW YOUR WORK IN EXCEL WHERE POSSIBLE Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and...

Consider the demand for some product over the last 12 periods. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop the...

For the matrix A, find (if possible) a nonsingular matrix P such that P-AP is diagonal. (If not possible, enter IMPOSSIBLE.) 8-4 P = A = X 189 0 0 -2 1 P-AP = Verify that P-AP is a diagonal matrix...

The following information was taken from the books of Orlando Pirates Traders for April and May 2020. Table of items appearing on the bank reconciliation statement of Orlando Pirates Traders for...

Which item does not increase the taxpayer's at - risk amount?Multiple ChoiceA taxpayer's share of recourse liabilitiesA taxpayer's share of qualified nonrecourse liabilitiesA taxpayer's share of...

a. Suppose an economy was originally operating at potential output. Unfortunately, a pandemic outbreak caused the stock market to crash. In face of such stock, describe how activist monetary policy...