- Business
- Operations Management
- historical demand for a product is demand january 12 february...
Question: historical demand for a product is demand january 12 february...
Question details
Historical demand for a product is:
DEMAND | |
January | 12 |
February | 9 |
March | 13 |
April | 12 |
May | 14 |
June | 13 |
a. Using a weighted moving average with weights of 0.60 (June), 0.30 (May), and 0.10 (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.10 and a June forecast = 11, 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
Solution by an expert tutor
