Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Joel Backer Cakes Shoppe is trying not only to get accurate forecasts for three types of his cakes that he sells, but also to
Joel Backer 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 that will be suited for each of the cakes. His past sixteen months of sales data (in hundreds) are shown in the table below. 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. For Cinnamon Buns: Suppose you have restricted your forecasting method to a choice of Moving Averages (3 months only), Exponential Smoothing (a=0.7, initial forecast F1=204), or Exponential Smoothing with Trend (use optimal a and , initial trend forecast T1=2, initial exponentially | smoothed forecast F1=205). . Develop your forecasts using each method. Using MAD measurement, which method would you recommend and state why? Past Blueberry Cinnamon Past Cupcakes Months Muffins Buns Months Blueberry Cinnamon Muffins Cupcakes Buns 1 104 204 154 9 100 232 155 2 102 204 155 10 104 230 155 3 104 210 153 11 101 234 153 4 102 217 150 12 100 241 150 5 100 220 152 13 100 242 153 6 105 220 154 14 104 247 153 7 101 225 155 15 105 249 152 00 8 103 225 150 16 103 250 154
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