Question: Historical demand for a product is: a. Using a weighted moving average with weights of 0.50 (June), 0.40 (May), and 0.10 (April), find the July

Historical demand for a product is: a. Using a weighted moving average with weights of 0.50 (June), 0.40 (May), and 0.10 (April), find the July forecast. Note: Round your answer to 1 decimal place. b. Using a simple three-month moving average, find the July forecast. Note: Round your answer to 1 decimal place. c. Using single exponential smoothing with a=0.20 and a June forecast =15, find the July forecast. Note: Round your answer to 1 decimal place. d. Using simple linear regression analysis, calculate the regression equation for the preceding demand data: Note: 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. Note: Do not round intermediate calculations. Round your answer to 1 decimal place
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
