Question: please use excel for the answer X= 6 provide explination QUESTIONS: Quarterly demands for a washing machine are as shown. 1. Construct a static forecasting
please use excel for the answer
X= 6
QUESTIONS: Quarterly demands for a washing machine are as shown. 1. Construct a static forecasting model including level, trend, and seasonal components of demand. Estimate the demand of the first quarter of year III. 2. Construct an exponential-smoothing adaptive forecasting model including only level component of demand where smoothing factor =(x+1)/100 and x is the last two digits of your student number. Estimate the demand of the first quarter of year III. 3. Compare two results with respect to MAPE and interpret. 4. Conduct tracking signal analysis for both forecasting models and interpret
provide explination
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
