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

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: Flex AI - Your personal assistant for all your inquiries!

Become a Member

	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.)