Sarah has been custom manufacturing sweaters now for 7 years. Her annual sales are shown below.YearSales1178221532334301533763307361 What are her forecasted sales for year 8 using a 3 year moving average?What are her forecasted sales for year 8 using a 5 year weighted average where w1=.4, w2=.3, w3=.15, w4=.1, w5=.05?What are her forecasted sales for year 8 using exponential smoothing? Assume year 7 forecast was 323. Select your own alpha.Which forecast method is the best for Sarah to use based on MAD? Why?

Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…

Answered: What are her forecasted sales for year…

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

Related questions

Question

Sarah has been custom manufacturing sweaters now for 7 years. Her annual sales are shown below.

What are her forecasted sales for year 8 using a 3 year moving average?
What are her forecasted sales for year 8 using a 5 year weighted average where w₁=.4, w₂=.3, w₃=.15, w₄=.1, w₅=.05?
What are her forecasted sales for year 8 using exponential smoothing? Assume year 7 forecast was 323. Select your own alpha.
Which forecast method is the best for Sarah to use based on MAD? Why?

Expert Solution