Question: Saved Help Save Problem 3-15 (Static) Historical demand for a product is January February March April DEMAND 12 11 15 12 16 15 May US

Saved Help Save Problem 3-15 (Static) Historical
Saved Help Save Problem 3-15 (Static) Historical
Saved Help Save Problem 3-15 (Static) Historical
Saved Help Save Problem 3-15 (Static) Historical demand for a product is January February March April DEMAND 12 11 15 12 16 15 May US ON June a. Using a weighted moving average with weights of 0.60 (June). O.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 14.3 c. Using single exponential smoothing with a = 0.2 and a June forecast = 13, 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 (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 (Round your answer to 1 decimal place.) July forecast

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!