Question
5. Solve the following Prediction problems by the different methods required: to. A. Calculate the prediction using the Exponential Smoothing method where alpha = .3
5. Solve the following Prediction problems by the different methods required: to.
A. Calculate the prediction using the Exponential Smoothing method where alpha = .3 Week Demand Forecast 1 820 820 2 775 3 680 4 655 5 750 6 802 7 798 8 689 9 775 10
B. Determine with the moving average method in the third period with the following data: Year Production (in year 000 tonnes) Year Production (in 000 tonnes) 1995 21 2000 22 1996 22 2001 25 1997 23 2002 26 1998 25 2003 27 1999 24 2004 26
C. Using linear regression, determine the parameters a and b where the sum of the least squares is minimized. Additionally, calculate the projection of the 12 periods. Quarter Sales Quarter Sales 1 600 7 2,600 2 1,550 8 2,900 3 1,550 9 3,800 4 1,500 10 4,500 5 2,400 11 4,000 6 3,100 12 4,900
Note: Be sure to calculate the value of a and b.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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