Question
Historical demand for a product is DEMAND January 19 February 18 March 22 April 19 May 23 June 22 a. Using a weighted moving average
Historical demand for a product is |
DEMAND | |
January | 19 |
February | 18 |
March | 22 |
April | 19 |
May | 23 |
June | 22 |
a. | Using a weighted moving average with weights of 0.50 (June), 0.30 (May), and 0.20 (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.30 and a June forecast = 14, 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 |
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