Question: I only need help with part B . Please use excel i f possible :) Starbucks has a large, global supply chain that must efficiently
I only need help with part Please use excel possible :)
Starbucks has a large, global supply chain that must efficiently supply over stores. Although the stores might appear very similar, they are actually very different. Depending the location the store, its size, and the profile the customers served, Starbucks management configures the store offerings take maximum advantage the space available and customer preferences.
Starbucks actual distribution system much more complex, but for the purpose our exercise let focus a single item that currently distributed through five distribution centers the United States. Our item a branded coffeemaker that sold some the larger retail stores. The coffeemaker has been a steady seller over the years due its reliability and rugged construction. Starbucks does not consider this a seasonal product, but there some variability demand. Demand for the product over the past weeks shown the following table. the week before week the table, two weeks before week etc.
Management would like you experiment with some forecasting models determine what should used a new system implemented. The new system programmed use one two forecasting models: simple moving average exponential smoothing.
Part : Evaluate the forecasts that would have been made over the weeks using the overall the end the weeks mean deviation, mean percent error, and tracking signal criteria. values should indicated a minus sign. Round all answers decimal places. Enter "MAPE" answers a percentage rounded decimal places.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
