Required a). Consider using a simple moving average model. Experiment with models using five weeks and three
Fantastic news! We've Found the answer you've been seeking!
Question:
Required
a). Consider using a simple moving average model. Experiment with models using five weeks and three weeks past data. (Round your answers to 2 decimal places.)rn
b). Evaluate the forecasts that would have been made over the 13 weeks using the overall (at the end of the 13 weeks) mean absolute deviation, mean absolute percent error, and tracking signal as criteria.(Negative values should be indicated by a minus sign. Enter "MAPE" answers in percentage rounded to 2 decimal places. Round your answers to 2 decimal places.)rn
Transcribed Image Text:
As we discussed at the beginning of the chapter, Starbucks has a large, global supply chain that must efficiently supply over 17,000 stores. Although the stores might appear to be very similar, they are actually very different. Depending on the location of the store, its size, and the profile of the customers served, Starbucks management configures the store offerings to take maximum advantage of the space available and customer preferences. Starbucks' actual distribution system is much more complex, but for the purpose of our exercise let's focus on a single item that is currently distributed through five distribution centers in the United States. Our item is a logo-branded coffeemaker that is sold at some of the larger retail stores. The coffeemaker has been a steady seller over the years due to its reliability and rugged construction. Starbucks does not consider this a seasonal product, but there is some variability in demand. Demand for the product over the past 13 weeks is shown in the following table. The demand at the distribution centers (DCs) varies between about 40 units, on average, per week in Atlanta and 48 units in Dallas. The current quarter's data are pretty close to the demand shown in the table. Management would like you to experiment with some forecasting models to determine what should be used in a new system to be implemented. The new system is programmed to use one of two forecasting models: simple moving average or exponential smoothing. Wook 3 4 5 6. 7 8 9 10 11 12 13 Average Atlanta 33 45 37 38 55 30 18 58 47 37 23 55 40 40 Boston 26 35 41 40 46 48 55 18 62 44 30 45 50 42 Chicago 44 34 22 55 48 72 62 28 27 95 35 45 47 47 Dallas 27 42 35 40 51 64 70 65 55 43 38 47 42 48 LA 32 43 54 40 46 74 40 35 45 38 48 56 50 46 Total 162 199 189 213 246 288 245 204 236 257 174 248 229 222 Starbucks is considering simplifying the supply chain for their coffeemaker. Instead of stocking the coffeemaker in all five distribution centers, they are considering only supplying it from a single location. Evaluate this option by analyzing how accurate the forecast would be based on the demand aggregated across all regions. Use the model that you think is best from your analysis of parts 1 and 2. Evaluate your new forecast using mean absolute deviation, mean absolute percent error, and the tracking signal. As we discussed at the beginning of the chapter, Starbucks has a large, global supply chain that must efficiently supply over 17,000 stores. Although the stores might appear to be very similar, they are actually very different. Depending on the location of the store, its size, and the profile of the customers served, Starbucks management configures the store offerings to take maximum advantage of the space available and customer preferences. Starbucks' actual distribution system is much more complex, but for the purpose of our exercise let's focus on a single item that is currently distributed through five distribution centers in the United States. Our item is a logo-branded coffeemaker that is sold at some of the larger retail stores. The coffeemaker has been a steady seller over the years due to its reliability and rugged construction. Starbucks does not consider this a seasonal product, but there is some variability in demand. Demand for the product over the past 13 weeks is shown in the following table. The demand at the distribution centers (DCs) varies between about 40 units, on average, per week in Atlanta and 48 units in Dallas. The current quarter's data are pretty close to the demand shown in the table. Management would like you to experiment with some forecasting models to determine what should be used in a new system to be implemented. The new system is programmed to use one of two forecasting models: simple moving average or exponential smoothing. Wook 3 4 5 6. 7 8 9 10 11 12 13 Average Atlanta 33 45 37 38 55 30 18 58 47 37 23 55 40 40 Boston 26 35 41 40 46 48 55 18 62 44 30 45 50 42 Chicago 44 34 22 55 48 72 62 28 27 95 35 45 47 47 Dallas 27 42 35 40 51 64 70 65 55 43 38 47 42 48 LA 32 43 54 40 46 74 40 35 45 38 48 56 50 46 Total 162 199 189 213 246 288 245 204 236 257 174 248 229 222 Starbucks is considering simplifying the supply chain for their coffeemaker. Instead of stocking the coffeemaker in all five distribution centers, they are considering only supplying it from a single location. Evaluate this option by analyzing how accurate the forecast would be based on the demand aggregated across all regions. Use the model that you think is best from your analysis of parts 1 and 2. Evaluate your new forecast using mean absolute deviation, mean absolute percent error, and the tracking signal.
Expert Answer:
Related Book For
Statistics Data Analysis and Decision Modeling
ISBN: 978-0132744287
5th edition
Authors: James R. Evans
Posted Date:
Students also viewed these general management questions
-
Consider using a simple moving average model Experiment with models using five weeks and three weeks past data The past data in each region are given below (week 21 is the week before week 1 in the...
-
Evaluate each expression using your calculator. Round your answers to the nearest thousandth. a. b. c. d. -30+30-45) 25) 30 V30 45(3) 2(5) 2 8
-
In E2-13, prepare any journal entries that would have been different if the only trigger points had been the purchase of materials and the sale of finished goods.
-
What is Norway's global health issues and how can they be combated? explain
-
In the summer of 2010, an explosion on the Deepwater Horizon oil drilling rig caused a leak in one of British Petroleum (BP) Oil Company's wells in the Gulf of Mexico. Crude oil rushed unabated for 3...
-
Lauridsen Design Inc. (LDI) is an architectural and design firm located in Calgary, Alberta. LDI has an information technology services group (IT Services) and a finance and accounting services group...
-
When creating association rules, why is it common to only consider rules with a confidence measure above a minimum threshold? a. A minimum confidence threshold is not necessary if item granularity is...
-
The adjusted trial balance columns of the worksheet for Porter Company are as follows. Instructions (a) Complete the worksheet by extending the balances to the financial statement columns. (b)...
-
Switching from a business-to-consumer model to a business-to-business model would have a lot of moving parts. Our simulation is selling fully-built road and mountain bikes for casual and serious bike...
-
Let's say that professor Sanford dies (this is not going to happen for another 20 years), and the estate of decedent- Sanford comes into existence. Also, assume that you are the adopted child of...
-
Johannsen Steel Company (JSC) was established by three Johannsen brothers in 1928 in Pittsfield, Rhode Island. The brothers began JSC by concentrating on high-quality, high-carbon, and high-margin...
-
In Problems 23-26, apportion the indicated number of representatives to two states, A, and B, using Hamilton's plan. Next, recalculate the apportionment using Hamilton's plan for the three states,...
-
Use this information to answer the questions in Problems 12-17. a. What does the notation \((\mathrm{ACB})\) mean? b. What does the " 4 " under (ACB) mean? In voting among three candidates, the...
-
Consider the populations given in Problems 29-32. a. Find the standard divisor. b. Find the standard quota for each precinct. c. Total, rounding the standard quotas down. d. Find a modified divisor...
-
Determine the winner, if any, using the voting methods in Problems 29-34. Hare method In voting among three candidates, the outcomes are reported as: (CBA) (ACB) (BAC) (BCA) (CAB) 3 0 4 2 5 (ABC) 8
-
a. If there are 10 voters and 5 candidates, how many total points would there be in a Borda count? b. If there are 20 voters and 4 candidates, how many total points would there be in a Borda count?...
-
A 3 MeV fast neutron hits an alpha-iron target (threshold energy 40 eV, atomic wt. 55.85) creating a PKA. Find out the number of displaced atoms per PKA using : a) simple K-P model, b) Snyder-Neufeld...
-
Draw a Feynman diagram for the reaction n + v p + .
-
What is a curvilinear regression model? How do you know when to use one?
-
A young entrepreneur has invented a new air-adjustable basketball shoe with pump, similar to those advertised widely by more expensive brand names. He contacted a supplier of Victor basketball shoes,...
-
A national homebuilder builds singlefamily homes and condominiumstyle townhouses. The Excel file House Sales provides information on the selling price, lot cost, type of home, and region of the...
-
What are a manager's resources?
-
What are the three levels of management?
-
Joe Maddon has been the manager of the Chicago Cubs since 2015. In his first year, he exceeded the expectations of most analysts and fans by leading the team to an appearance in the National League...
Study smarter with the SolutionInn App