Question: Note - can you do it on paper if possible. 6. Starbucks in Saint-Catherine Street is going to forecast the sales of pastry materials for

Note - can you do it on paper if possible.
Note - can you do it on paper if possible. 6.
6. Starbucks in Saint-Catherine Street is going to forecast the sales of pastry materials for baking blueberry muffin in second half of current year 2020. The bakery manager analyzed sales data of this kind of muffin collecting from POS (Point of Sale) of previous year, 2019. She used to forecast the demand based on monthly sales quantity every year to avoid wasting materials leading to increase the profit by decreasing the production costs. Assume that following monthly data from January to December 2019 has been collected in following table. As a consultant please help the manager to forecast the demands of second half of 2020 based on each below mentioned methods. Please advise her which method is most accurate and optimal method for forecasting demand by sorting in order all methods respectively. Please note that you must complete whole table, but analyze ONLY July to December. For each method, writing the formula and calculations are mandatory. Competency; Code: 00N9 Establish a management strategy for supplies and stocks Anticipate the request /15 Marks Months Jan. Feb. Mar. Apr. May. Jun. Jul. Aug. Sep. Oct. Nov. Dec. 2019 Blueberry muffin 770 574 835 470 650 375 730 425 540 655 Moving Average K = 3 weighted moving average at K = 3 at 60%, 30%, 10% exponential smoothing a= 0.1 950 945 Sep. Oct. Nov. Dec. Average ADD: Absolute Average of Deviation Months Jul. Aug. Previous year AAD moving average at K = 3 AAD weighted moving average at K = 3 at 60%, 30%, 10% AAD exponential smoothing a= 0.1

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!