Question: can you please answer my question? Forecasting Case/Problem Joel Sims Cakes Shoppe is trying not only to get accurate forecasts for three types of his

can you please answer my question?

can you please answer my question? Forecasting
Forecasting Case/Problem 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 Blueberry Cinnamon Months Muffins buns Cupcakes 30 18 43 34 17 29 32 19 26 IUAWNH 34 19 23 35 22 49 30 23 32 34 23 20 36 25 14 29 24 52 10 31 26 30 35 27 24 12 31 28 22 37 13 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: 1. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!