Starbucks has a large, global supply chain that must efficiently supply over 17,000 stores. Although the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. (week -1 is the week before week 1 in the table, -2 is two weeks before week 1, etc.). 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. -5 -4 -3 322 WEEK -2 -1 1 2 3 4 7 8 9 10 11 12 13 32 33 57 45 36 25 56 40 Atlanta 47 Boston 34 35 46 35 34 54 33 21 43 46 33 36 60 21 33 47 66 42 35 49 Chicago 54 26 67 35 40 48 47 49 23 44 34 27 48 43 28 28 43 48 66 64 32 26 90 34 44 46 Dallas. 35 28 35 54 35 38 46 55 65 60 45 40 34 38 42 LA 40 42 46 36 37 38. 42 45 46 47 65 43 35 39 42 45 50 50 Total 236 149 224 228 190 181 183. 189 206 243 266 242 206 221 250 173. 229 227 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.) 3-week MA Im لیا لیا wor 27 10 VA 564 NW ∞ WNA W w 5775 3443 00 00 5 5010 44 885 63 3465 246 45 53 6 1030 56 96 4624 1233 15 DA WAASH SOFT9N 14 41 ليا - Week 1 2 3 4 5 6 7 8 9 10 11 12 13 ATL 37.33 X 40.67 X 41.33 X 42.00 38.33 38.67 38.33 41.00 X 40.33 36.00 X 36.67 X 40.67 X 45.67 BOS 41.33 36.67 X 40.67 38.33 34.00 X 38.67 40.00 45.00 X 45.00 48.00 39.67 46.00 X 43.67 Answer is complete but not entirely correct. CHI DAL LA Total 49.00 X 42.67 42.67 X 41.33 X 48.33 X 39.67 X 40.67 X 37.00 X 40.33 X 39.00 X 35.00 X 41.67 X 36.33 X 44.33 41.00 X 46.00 54.00 52.67 59.33 X 51.67 X 54.00 X 47.67 X 40.67 X 39.00 X 49.33 38.67 X 32.67 39.00 X 44.00 X 41.67 X 33.00 x 30.33 X 33.67 39.67 46.33 55.33 X 60.00x 56.67 X 48.33 203.00 200.33 X 214.00 199.67 X 184.67 X 184.33 192.67 212.67 238.33 X 250.33 X 238.00 X 223.00 X 225.67 Week 1 2 3 4 5 6 7 8 9 10 11 12 13 ATL 40.60 38.20 41.00 41.40 36.80 40.80 40.40 35.40 39.60 41.80 38.20 36.60 43.60 BOS 40.60 35.80 39.20 39.00 37.80 40.80 43.00 46.20 41.40 46.60 45.40 43.00 41.40 CHI 45.00 43.00 44.60 36.60 39.20 40.20 44.60 50.60 51.60 47.20 55.60 49.20 45.20 DAL 39.00 37.60 37.60 37.60 34.40 35.00 40.40 47.80 52.80 54.20 53.00 48.80 43.40 LA 40.20 39.80 39.80 39.60 41.60 43.60 49.00 49.20 47.20 45.80 44.80 40.80 42.20 Total 205.40 194.40 201.20 194.20 189.80 200.40 217.40 229.20 232.60 235.60 237.00 218.40 215.80 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. Round all answers to 2 decimal places. Enter "MAPE" answers as a percentage rounded to 2 decimal places.) Answer is complete but not entirely correct. Avg of ATL BOS CHI DAL LA DCS 3-week MA MAD MAPE TS 5-week MA MAD MAPE TS 10.51 0.30 0.25 10.71 0.29 0.15 9.13 0.24 X 1.10 8.62 0.22 X 1.95 16.92 0.39 X (0.12) 15.97 0.37 0.65 10.97 0.27 (1.09) 11.17 0.26 X (0.68) 7.33 0.16 3.00 7.09 0.15 3.30 10.97 0.63 10.71 0.26 X 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. (week -1 is the week before week 1 in the table, -2 is two weeks before week 1, etc.). 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. -5 -4 -3 322 WEEK -2 -1 1 2 3 4 7 8 9 10 11 12 13 32 33 57 45 36 25 56 40 Atlanta 47 Boston 34 35 46 35 34 54 33 21 43 46 33 36 60 21 33 47 66 42 35 49 Chicago 54 26 67 35 40 48 47 49 23 44 34 27 48 43 28 28 43 48 66 64 32 26 90 34 44 46 Dallas. 35 28 35 54 35 38 46 55 65 60 45 40 34 38 42 LA 40 42 46 36 37 38. 42 45 46 47 65 43 35 39 42 45 50 50 Total 236 149 224 228 190 181 183. 189 206 243 266 242 206 221 250 173. 229 227 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.) 3-week MA Im لیا لیا wor 27 10 VA 564 NW ∞ WNA W w 5775 3443 00 00 5 5010 44 885 63 3465 246 45 53 6 1030 56 96 4624 1233 15 DA WAASH SOFT9N 14 41 ليا - Week 1 2 3 4 5 6 7 8 9 10 11 12 13 ATL 37.33 X 40.67 X 41.33 X 42.00 38.33 38.67 38.33 41.00 X 40.33 36.00 X 36.67 X 40.67 X 45.67 BOS 41.33 36.67 X 40.67 38.33 34.00 X 38.67 40.00 45.00 X 45.00 48.00 39.67 46.00 X 43.67 Answer is complete but not entirely correct. CHI DAL LA Total 49.00 X 42.67 42.67 X 41.33 X 48.33 X 39.67 X 40.67 X 37.00 X 40.33 X 39.00 X 35.00 X 41.67 X 36.33 X 44.33 41.00 X 46.00 54.00 52.67 59.33 X 51.67 X 54.00 X 47.67 X 40.67 X 39.00 X 49.33 38.67 X 32.67 39.00 X 44.00 X 41.67 X 33.00 x 30.33 X 33.67 39.67 46.33 55.33 X 60.00x 56.67 X 48.33 203.00 200.33 X 214.00 199.67 X 184.67 X 184.33 192.67 212.67 238.33 X 250.33 X 238.00 X 223.00 X 225.67 Week 1 2 3 4 5 6 7 8 9 10 11 12 13 ATL 40.60 38.20 41.00 41.40 36.80 40.80 40.40 35.40 39.60 41.80 38.20 36.60 43.60 BOS 40.60 35.80 39.20 39.00 37.80 40.80 43.00 46.20 41.40 46.60 45.40 43.00 41.40 CHI 45.00 43.00 44.60 36.60 39.20 40.20 44.60 50.60 51.60 47.20 55.60 49.20 45.20 DAL 39.00 37.60 37.60 37.60 34.40 35.00 40.40 47.80 52.80 54.20 53.00 48.80 43.40 LA 40.20 39.80 39.80 39.60 41.60 43.60 49.00 49.20 47.20 45.80 44.80 40.80 42.20 Total 205.40 194.40 201.20 194.20 189.80 200.40 217.40 229.20 232.60 235.60 237.00 218.40 215.80 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. Round all answers to 2 decimal places. Enter "MAPE" answers as a percentage rounded to 2 decimal places.) Answer is complete but not entirely correct. Avg of ATL BOS CHI DAL LA DCS 3-week MA MAD MAPE TS 5-week MA MAD MAPE TS 10.51 0.30 0.25 10.71 0.29 0.15 9.13 0.24 X 1.10 8.62 0.22 X 1.95 16.92 0.39 X (0.12) 15.97 0.37 0.65 10.97 0.27 (1.09) 11.17 0.26 X (0.68) 7.33 0.16 3.00 7.09 0.15 3.30 10.97 0.63 10.71 0.26 X
Expert Answer:
Answer rating: 100% (QA)
To evaluate the forecasts using the overall mean absolute deviation MAD mean absolu... View the full answer
Related Book For
Operations and Supply Chain Management
ISBN: 978-0078024023
14th edition
Authors: F. Robert Jacobs, Richard Chase
Posted Date:
Students also viewed these accounting questions
-
The number of telemarketing centers in the United States has decreased in the past few years. Why has this occurred?
-
The transfer of real property is much more complex than the transfer of personal property. What could be done to simplify real property transactions?
-
a. Explain how a hedge fund manager might appear to be able to beat the market for several years, and yet have no privileged information whatsoever. b. The M ratio for a portfolio P is positive....
-
Given the following information, prepare a production report with materials added at the beginning and ending work in process inventory being 20% complete with regard to conversion costs. Costs to...
-
Discuss the strengths and weaknesses of the following methods for establishing home-based pay, headquarters-based pay, and host country-based pay. a. Discuss your reaction to the following statement:...
-
A zookeeper has collected a male and a female lizard that look like they belong to the same species. They mate with each other and produce phenotypically normal offspring. However, the offspring are...
-
Visit the Information Systems Audit and Control Associations (ISACA) Web site (www.isaca.org) to review the COBIT framework (version 4.1). Complete the following matrix to show how the 34 high-level...
-
Crosstown Health Center runs two programs: drug addict rehabilitation and aftercare (counseling and support of patients after release from a mental hospital). The centers budget for 2014 follows. Kim...
-
La funci n de ingreso marginal para el producto de un fabricante es I = 2 0 0 0 2 0 Q 3 Q 2 . Encontrar la funci n de demanda. ( La demanda es igual a: D = I / Q )
-
A company wishes to create a trust fund through a savings plan with either annual or monthly deposits under an APR of 5% over 30 years. During that time, the company has the following cash flows: a...
-
The exercise of power by leaders is best described as both multi-dimensional and multi-focused. In the context of followership, discuss what does this mean and how is such power exercised? give...
-
Compare and contrast exportlimport operations to local presence. What are the logistics ramifications of each stage of international development?
-
_____ exists when individuals in similar situations are intentionally treated differently and the different treatment is based on an individuals membership in a protected class.
-
How can smaller firms remain competitive in the exchange or logistics information?
-
_____ occurs when different groups of people have different scores designated as passing grades on a test for employment.
-
_____ consists of monetary damages awarded by the court that compensate the person who was injured for their losses.
-
MACRO ECONOMICS2 1. What is the value of autonomous consumption: (b) 50 2. What is the marginal propensity to consume: (a) 0.55 3. What is the value of an autonomous investment (c) 10; 4. What is the...
-
Do public and private companies follow the same set of accounting rules? Explain.
-
RentR Cars is a multisite car rental company in the city. It is trying out a new return the car to the location most convenient for you policy to improve customer service. But this means that the...
-
Following are the process flow sequences for three products: A, B, and C. There are two bottleneck operations on the first leg and fourth leg marked with an X. Boxes represent processes, which may be...
-
Why would subcontractors for a government project want their activities on the critical path? Under what conditions would they try to avoid being on the critical path?
-
Chauncer Manufacturing Corporation produces a dandruff shampoo in three consecutive processes. The costs of Department 1 for June 2019 were as follows: Department 1 handled the following units during...
-
Sweet Fragrances Company uses process costing to account for the manufacture of its perfume. The factory consists of three departments: Blending, Bottling, and Packaging. The production manager of...
-
(a) Consider the directed network below, whose edge capacities are indicated. For each of the vertex sets \(\{1,2\},\{1,2,3\}\), and \(\{1,4\}\), list the edges in the cut corresponding to the set...
Study smarter with the SolutionInn App