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
-
Give an example of signaling in each of the following situations: a. Choosing a doctor b. Applying to graduate school c. Filling out a form for a dating service
-
Give the stereochemical relationships between each pair of structures. Examples are same compound, structural isomers, enantiomers, diastereomers. Which pairs could you (theoretically) separate by...
-
A 10-year annuity pays \($900\) per year, with payments made at the end of each year. The first \($900\) will be paid 5 years from now. If the APR is 8% and interest is compounded quarterly, what is...
-
Tang Company accumulates the following data concerning raw materials in making one gallon of finished product: (1) Pricenet purchase price $2.30, freight-in $0.20, and receiving and handling $0.10....
-
just dis needed. please show all work and explain. thanks 3.2.1. For each of the following, use definitions (rather than limit theorems) to prove that the limit exists. Identify the limit in each...
-
Establishing rapport is a crucial step at the enquiry and interview stage. In preparing for your interview and meeting this client for the first time, list 10 ways you will aim to both establish...
-
How can i resize the images in the dataset to then flatten into 1D array?. def get imlist (path) : Returns a list of filenames for all pom images in a directory. return [os. path. join(path, f) for f...
-
1. Pacsun's current stock price is 80 dollars. The board has declared that 8,000,000 dollars in cash dividends will be disbursed in 1 month. keeping everything else constant and ignoring taxes, what...
-
Some airlines hedge jet fuel prices and some do not. When oil prices declined, some airlines that had hedged jet fuel prices were worse off than those that did not hedge. Using a numerical example,...
-
Question1: A company has a unit load AS/RS system that aisle length is 250 ft and aisle height is 60 ft. The horizontal and vertical speeds of the S/R machine are 250 ft/min and 30 ft/min,...
-
(1)(a)How would you evaluate the informational role of financial market during the recent COVID-19 pandemic around the globe? (1)(b) Can you transfer/defer your today's consumption into the future?...
-
Jason is saving for a new TV. He currently has $1,200 in his account that earns 3%, compounded monthly, and the new TV costs $4,500. Assuming Jason deposits $100 in his account each month, how many...
-
Adding Functisns Eimp What is the rum of f[x] and g(x) ? f(x)=2x^(2)-3x-6 g(x)-7z+9 2 answers
-
Making use of the tables of atomic masses, find the velocity with which the products of the reaction B10 (n, ) Li7 come apart; the reaction proceeds via interaction of very slow neutrons with...
-
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...
-
List three different types of profit figure that you are likely to see in a published profit and loss account.
-
In what ways does a US balance sheet differ from that presented using the UK method of preparation?
-
Repeat the above, reconciling the operating profit and cash statement for the year ended 31 December, year 2.
Study smarter with the SolutionInn App