Question: PLEASE SOLVE IT WITH EXCEL WITH FOURMELA IWILL GIVE UP VOTE this is all the information that i have 1. Monthly demand for an electronics

PLEASE SOLVE IT WITH EXCEL WITH FOURMELA IWILL GIVE UP VOTE
this is all the information that i have
1. Monthly demand for an electronics shop for flat-screen TV are as follows: Month 1 2 3 4 5 6 7 8 9 10 11 12 Demand (units) 1,000 1,113 1,271 1,445 | 1,558 1,648 1,724 1,850 1,864 2,076 2,167 2,191 Given that the forecast of first month used to be 1,937 units, Estimate the demand forecast using exponential smoothing with a = 0.3. Evaluate the MAD, MSE, MAPE? Analyze the data and give your suggestions for further improvements
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
