Question: Answer only if you're absolutely sure, please. Historical demand for a product is: DEMAND January 14 February 11 March 15 April 14 May 16 June
Answer only if you're absolutely sure, please.
Historical demand for a product is:
| DEMAND | |
| January | 14 |
| February | 11 |
| March | 15 |
| April | 14 |
| May | 16 |
| June | 15 |
a. Using a weighted moving average with weights of 0.50 (June), 0.30 (May), and 0.20 (April), find the July forecast. (Round your answer to 1 decimal place.)
July forecast
b. Using a simple three-month moving average, find the July forecast. (Round your answer to 1 decimal place.)
July forecast
c. Using single exponential smoothing with = 0.40 and a June forecast = 13, find the July forecast. (Round your answer to 1 decimal place.)
July forecast
d. Using simple linear regression analysis, calculate the regression equation for the preceding demand data. (Do not round intermediate calculations. Round your intercept value to 1 decimal place and slope value to 2 decimal places.)
Y = + t
e. Using the regression equation in d, calculate the forecast for July. (Do not round intermediate calculations. Round your answer to 1 decimal place.)
July forecast
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
