Question
Historical demand for a product is DEMAND January 15 February 13 March 17 April 15 May 18 June 17 a. Using a weighted moving average
Historical demand for a product is
DEMAND | |
January | 15 |
February | 13 |
March | 17 |
April | 15 |
May | 18 |
June | 17 |
a. Using a weighted moving average with weights of 0.40 (June), 0.30 (May), and 0.30 (April), find the July forecast. (Round your answer to 1 decimal place.)
b. Using a simple three-month moving average, find the July forecast. (Round your answer to 1 decimal place.)
c. Using single exponential smoothing with = 0.10 and a June forecast = 13, find the July forecast. (Round your answer to 1 decimal place.)
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.)
e. Using the regression equation in d, calculate the forecast for July. (Do not round intermediate calculations. Round your answer to 1 decimal place.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started