Answered step by step
Verified Expert Solution
Question
1 Approved Answer
need help please answer all of them thanks you Chapter 13 Forecasting problems. Print the assignment below, work on it and submit by class time.
need help please answer all of them thanks you
Chapter 13 Forecasting problems. Print the assignment below, work on it and submit by class time. Problem Assignment 2.docx Note: Use at least 4 decimal points for Absolute \% Error values. Some answers to check with your solutions for PA2: Moving average MAD is 17.125,MSE:507.88,MAPE:%1.35 ES, MAD: 20.39 Regression, MAD: 17.38 Week 22 forecasts: 1287,1281,1269 Forecasting Methods: Moving Average, Exponential Smoothing, Linear Trend and Regression Forecast Error = Demand (Actual) - Forecast MAD (mean absolute deviation) = Average of absolute (positive) forecast errors, on average how much we are off MSE (mean squared error) = Average of squared errors MAPE (mean absolute \% error) = average of (absolute error/demand) You have been given the demand data for the past 10 weeks for swim rings for children. You decide to run three different types of forecasting methods on the data to see which gives you best forecast. Use 2 week moving average; weighted moving average with weights 0.7 and 0.3; exponential smoothing with alpha =.3, and Regression equation. Then calculate MAD, MSE, and MAPE for MA, ES and Regression Forecasts. Which forecasts are more accurate? Explain. What will be the forecasts for Week 22? 1. MOVING AVERAGE, MAn=Di where Di= demand in period i,n: number of periods in the moving average a. Calculate 2 weeks MA forecasts MSE: MAPE: SCM 3005 Yazici, H. MSE: MAPE: 2. EXPONENTIAL SMOOTHING, Ft+1=Dt+(1)Ft F1=D1 a. Calculate Exponential Smnnthina b. MAD: MSE: MAPEStep 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