Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental Accounting Principles

Authors: John Wild, Ken Shaw, Barbara Chiappetta

22nd edition

9781259566905, 978-0-07-76328, 77862279, 1259566900, 0-07-763289-3, 978-0077862275

More Books

Students also viewed these Accounting questions

Question

Cardiovascular issues (e.g., hypertension and stroke)

Answered: 1 week ago