1. Business
  2. Operations Management
  3. historical demand for a product is demand january 12 february...

Question: historical demand for a product is demand january 12 february...

Question details

Historical demand for a product is:


DEMAND
January 12
February 9
March 13
April 12
May 14
June 13

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 α = 0.10 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 forecast            

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution