Answered step by step
Verified Expert Solution
Question
1 Approved Answer
CleLRY WOIR Historical demand for a product is: January February March April May June DEMAND 16 14 18 16 a. Using a weighted moving average
CleLRY WOIR Historical demand for a product is: January February March April May June DEMAND 16 14 18 16 a. Using a weighted moving average with weights of 0.50 (June), 0.20 (May), and 0.30 (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 a = 0.20 and a June forecast = 12, find the July forecast. (Round your answer to 1 decimal place.) July forecast CHERMy Work 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.) 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