Question: could someone help me with d and e Historical demand for a product is a. Using a weighted moving average with weights of 0.60 (June),
could someone help me with d and e
Historical demand for a product is a. Using a weighted moving average with weights of 0.60 (June), 0.30 (May), and 0.10 (Apri), find the July forecast. (Round your answer to 1 decimal place.) Pt=.6(Pt1)+.3(Pt2)+.1(Ft3)= (.60x15)(.30x16)+(.10x12)9+4.8+1.2=15 b. Using a simple three-month moving average, find the July forecast. (Round your answer to 1 decimal place.) T=((Tt1+2t2+2t3)/3= (12+16+15)/3=43/3=14.33 c. Using single exponential smoothing with =0.2 and a June forecast =13, find the July forecast. (Round your answer to 1 decimal place.) a=21t=(axAt1)(1a)t1= (215)+((12)13)13.4 d. Using simple linear regression analysis, calculate the regression equation for the preceding demand data. (Round your intercept value to 1 decimal place and slope value to 2 decimal places.) 1 e. Using the regression equation in d, calculate the forecast for July. (Round your answer to 1 decimal place.)
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
