Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Joel Sims Cakes Shoppe is trying not only to get accurate forecasts for three types of his cakes that he sells, but also to determine
Joel Sims Cakes Shoppe is trying not only to get accurate forecasts for three types of his cakes that he sells, but also to determine which forecasting method should be used from now that will be suited for each of the cakes. His past sixteen months of sales data (in hundreds) are shown in the table below. Past Months Blueberry Muffins Cinnamon buns Cupcakes 1 30 18 43 2 34 17 29 3 32 19 26 4 34 19 23 5 35 22 49 6 30 23 32 7 34 23 20 8 36 25 14 9 29 24 52 10 31 26 30 11 35 27 24 12 31 28 22 13 37 29 55 14 35 31 35 15 34 33 28 16 32 30 26 a) By plotting the historical sales data of all the three cake types on same graph, please suggest the possible forecasting method(s) you may want to consider for each cake type. Please state your reasons. b) Cupcakes: Suppose you have restricted your forecasting method to a choice between only Moving Averages (3 months only) or Seasonal Forecast with trend: i. Determine your forecasts using each method. ii. Using MAD, which method would you recommend and state why
Step 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