Submitted by: Submitted by niths14
Views: 10
Words: 899
Pages: 4
Category: Science and Technology
Date Submitted: 09/14/2016 07:38 PM
CHAPTER 5
Case Questions (see corresponding Chapter 5 case Excel spreadsheet)
1. What is the cost SportStuff.com incurs if all warehouses leased are in St. Louis?
Demand in 2007 is as shown in Table 5-15
| |Demand 2007 |
|Northwest |320,000 |
|Southwest |200,000 |
|Upper Midwest |160,000 |
|Lower Midwest |220,000 |
|Northeast |350,000 |
|Southeast |175,000 |
|Total Demand |1,425,000 |
The capacity of the current warehouse in St. Louis is 2,000,000 units per year, more than enough to accommodate 2007’s demand.
Costs are calculated as:
Fixed Warehouse Cost = $220,000
Variable Warehouse Cost = ($0.20/unit)(1,425,000 units) = $285,000
Holding Cost = $475,000+0.165*1,425,000 = $710,125
Shipping Cost = $1,068,750
Shipping Recouped from Customer = (1,425,000/4)*$3 = $1,068,750
Total Network Costs = $1,254,500
Note that the spreadsheet used for these calculations employed the linear holding cost function of $475,000+0.165F, which results in a holding cost of $710,125 and a total plan cost of $1,254,500.
Subsequent holding costs will use the single linear function to determine holding costs.
If demand increases by 80% per year for 2008, 2009, and 2010 and SportStuff.com wishes to use St. Louis as their only warehouse center, the following demands and costs are realized. The optimal solution for 2008 calls for one large warehouse rather than two small ones.
| |Demand 2008 |
|Northwest |576000 |
|Southwest |360000 |
|Upper Midwest |288000 |
|Lower Midwest |396000...