Question: Please Label each part(a-e) in your solution. If you plan on writing you solution please make it legible. TY in advance! Historical demand for a

Please Label each part(a-e) in your solution. If you plan on writing you solution please make it legible. TY in advance!
Historical demand for a product is: January February March April May June DEMAND 16 15 19 16 20 19 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 a = 0.30 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 forecastStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
