Using a weighted moving average with weights of 0.40 (June), 0.20 (May), and 0.40 (April), find the July forecast. (Round your answer to 1 decimal place.) b. Using a simple three-month moving average, find the July forecast. (Round your answer to 1 decimal place.) c. Using single exponential smoothing with α = 0.20 and a June forecast = 12, find the July forecast. (Round your answer to 1 decimal place.)
Historical demand for a product is:
DEMAND
January 13
February 10
March 14
April 13
May 15
June 14
a. Using a weighted moving average with weights of 0.40 (June), 0.20 (May), and 0.40 (April), find the July
b. Using a simple three-month moving average, find the July forecast. (Round your answer to 1 decimal place.)
c. Using single exponential smoothing with α = 0.20 and a June forecast = 12, find the July forecast. (Round your answer to 1 decimal place.)
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.)
e. Using the regression equation in d, calculate the forecast for July. (Do not round intermediate calculations. Round your answer to 1 decimal place.)
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 6 images
