Question: Historical demand for a product is a . Using a weighted moving average with weights of 0 . 5 0 ( June ) , 0

Historical demand for a product is
a. Using a weighted moving average with weights of 0.50(June),0.20(May), and 0.30(April), find the July forecast. Note: Round your answer to 1 decimal place.
July forecast
b. Using a simple three-month moving average, find the July forecast.
Note: Round your answer to 1 decimal place.
July forecast
c. Using single exponential smoothing with alpha=0.20 and a June forecast =12, find the July forecast.
Note: Round your answer to 1 decimal place.
July forecast
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.
Y= 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.
July forecast
 Historical demand for a product is a. Using a weighted moving

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!