Question

1. For the data below: Automobile Battery Sales 20 21 15 14 13 16 Automobile Battery Sales 17 18 20 20 21 23 Month Month anuary ebruary March pril May uly ugust eptember tober November une ecember a. Develop a three-month moving average b. Compute MAD Q.2 Usesimple exponential smoothing with a 0.33 to forecast the tire sales for February through May. Assume that the forecast for January was for 22 sets of tires Solve these both Qs Displaying 1 to 6 of 6 items

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution:

a. Develop a three-month moving average.

Month Automobile Battery Sales 20 21 15 Three-month moving average Janua Februa March 20+ 21+15 - 18.67 14 13 16 17 18 20 20 21 23 Ma 16.67 14.00 14.33 15.33 17.00 18.33 19.33 20.33 une August September October November December

b. Compute the MAD

Answer:

Month Automobile Battery Sales 20 21 15 14 13 16 17 18 20 20 21 23 Three-month moving average Error Janua Februa March 18.67 16.67 14.00 14.33 15.33 17.00 18.33 19.33 20.33 4.67 3.67 2.00 2.67 2.67 3.00 1.67 1.67 2.67 Ma une August September October November December Error-24.67 MAD-I Emor 1-24.67

Q2:

MonthAutomobile Battery Sales Exponentially Smoothed Forecast+0.33(Forcasting error) Janua 20 21 15 14 13 16 17 18 20 20 21 23 22.00 22 +0.33(20-22) 21.34 21.23 19.17 17.47 15.99 15.99 16.33 16.88 17.91 18.60 19.39 Februa March Ma June August September October November December

Add a comment
Know the answer?
Add Answer to:
1. For the data below: Automobile Battery Sales 20 21 15 14 13 16 Automobile Battery...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT