Historical demand for a product is
DEMAND
January
15
February
12
March
16
April
15
May
17
June
16
a. Using a weighted moving average with weights
of 0.60 (June),...
70.2K
Verified Solution
Link Copied!
Question
General Management
Historical demand for a product is
DEMAND
January
15
February
12
March
16
April
15
May
17
June
16
a. Using a weighted moving average with weightsof 0.60 (June), 0.20 (May), and 0.20 (April), find the Julyforecast. (Round your answer to 1 decimalplace.)
b. Using a simple three-month moving average,find the July forecast. (Round your answer to 1 decimalplace.)
c. Using single exponential smoothing with? = 0.30 and a June forecast = 11, 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 yourintercept value to 1 decimal place and slope value to 2 decimalplaces.)
e. Using the regression equation in d,calculate the forecast for July. (Do not round intermediatecalculations. Round your answer to 1 decimal place.)
Answer & Explanation
Solved by verified expert
4.1 Ratings (759 Votes)
Answer to Question a Forecast for July 060 x Demand for June 02 x demand for May 02 x demand for April 060 x 16 02 x 17 02 x 15 96 34 3 16 Answer to question b Forecast for July using a 3 month simple moving average Demand for April Demand for May demand for June 3 15 17
See Answer
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
