Part -1:
CASE STUDY - Managing Growth at SportStuff.com
In December 2008, Sanjay Gupta and his management team were busy evaluating the performance at sport Stuff.com over the previous year. Demand had grown by growth, however, was a mixed blessing.
The venture capitalists supporting the company were very pleased with the growth in sales and the resulting increase in revenue. Sanjay and his team, however, could dearly see that costs would grow faster than revenues if demand continued to grow and the supply chain network was not redesigned. They decided to analyze the performance of the current network to see how it could be redesigned to best cope with the rapid growth anticipated over the next three years.
SportStuff.com
Sanjay Gupta founded SportStuff.com in 2004 with a mission of supplying parents with more affordable sports equipment for their children. Parents complained about having to discard expensive skates, skis, jackets, and shoes because children outgrew them rapidly. Sanjay's initial plan was for the company to purchase used equipment and jackets from families and surplus equipment from manufacturers and retailers and sell these over the Internet. The idea was well received in the marketplace, demand grew rapidly, and, by the end of 2004, the company had sales of $0.8 million. By this time, a variety of new and used products were being sold, and the company received significant venture capital support.
In June 2004, Sanjay leased part of a warehouse in the outskirts of St. Louis to manage the large amount of product being sold. Suppliers sent their product to the warehouse. Customer orders were packed and shipped by UPS from there. As demand grew, SportStuff.com leased more space within the warehouse. By 2007, SportStuff.com leased the entire warehouse and orders were being shipped to customers all over the United States. Management divided the United States into six customer zones for planning purposes. Demand from each customer zone in 2007 was as shown in Table 5-15. Sanjay estimated that the next three years would sec a growth rate of about 80 percent per year. after which demand would level off.
The network Options
Sanjay and his management team could sec that they needed more warehouse space to cope with the antici-pated growth. One option was to lease more warehouse space in St. Louis itself. Other options included leasing warehouses all over the country. Leasing a warehouse involved fixed costs based on the size of the warehouse and variable costs that depended on the quantity shipped through the warehouse. Four potential locations for warehouses were identified in Denver, Seattle, Atlanta. and Philadelphia. Leased warehouses could be either small (about 100.000 sq. ft.) or large (200,(X00 sq. ft.). Small warehouses could handle a flow of up to 2 million units per year, whereas large warehouses could handle a flow of up to 4 million units per year. The current ware-house in St. Louis was small. The fixed and variable costs of small and large warehouses in different loca-tions are shown in Table 5-16.
Sanjay estimated that the inventory holding costs at a warehouse (excluding warehouse expense) was about $600 rootF, where F is the number of units flowing through the warehouse per year. This relationship is based on the theoretical observation that the inventory held at a facility (not across the network) is proportional to the square root of the throughput through the facility. As a result, aggregating throughput through a few facili¬ties reduces the inventory held as compared with disag¬gregating throughput through many facilities. Thus, a warehouse handling I million units per ycar incurred an inventory holding cost of $600,000 in the course of the year. If your version of Excel has problems solving thenonlinear objective function, use the following inventory costs:
Table 5-15 Regional Demand at SportStuff.com for 2007 |
Zone |
Demand in 2007 |
Zone |
Demand in 2007 |
Northwest |
320,000 |
Lower Midwest |
220,000 |
Southwest |
200,000 |
Northeast |
350,000 |
Upper midwest |
160,000 |
Southeast |
175,000 |
If you can handle only a single linear inventory cost. you should use $475,000Y + 0.165F. For each facility, Y = 1 if the facility is used, 0 otherwise.
Table 5-16 Fixed and variable costs of Potential Warehouses |
|
|
Small Warehouse |
Large Warehouse |
Location |
Fixed Cost($/year) |
Variable Cost($/Unit Flow) |
Fixed Cost($/year) |
Variable Cost($/Unit Flow) |
Seattle |
300,000 |
0.2 |
500,000 |
0.2 |
Denver |
250,000 |
0.2 |
420,000 |
0.2 |
St. Louis |
220,000 |
0.2 |
375,000 |
0.2 |
Atlanta |
220,000 |
0.2 |
375,000 |
0.2 |
Philadelphia |
240,000 |
0.2 |
400,000 |
0.2 |
SportStuff.com charged a flat fee of $3 per shipment sent to a customer. An average customer order contained four units. SportStuff.com, in turn, contracted with UPS to handle all its outbound shipments. UPS charges were based on both the origin and the destination of the shipment and are shown in Table 5-17. Management estimated that inbound transportation costs for shipments from suppliers were likely to remain unchanged, no matter what warehouse configuration was selected.
Study Questions
1. What is the cost SportStuff.com incurs it all warehouses leased are in St. Louis?
2. What supply chain network configuration do you recommend for SportStuff.com? Why?
3. How would your recommendation change if transportion costs were twice those shown in Table 5-17
Table 5 -17 UPS Charges per Shipment (Four Units) |
|
|
|
|
Northwest |
Southwest |
Upper midwest |
Lower Midwest |
Northeast |
Southeast |
Seattle |
$2.00 |
$2.50 |
$3.50 |
$4.00 |
$5.00 |
$5.50 |
Denver |
$2.50 |
$2.50 |
$2.50 |
$3.00 |
$4.00 |
$4.50 |
St. Louis |
$3.50 |
$3.50 |
$2.50 |
$2.50 |
$3.00 |
$3.50 |
Atlanta |
$4.00 |
$4.00 |
$3.00 |
$2.50 |
$3.00 |
$2.50 |
Philadelphia |
$4.50 |
$5.00 |
$3.00 |
$3.50 |
$2.50 |
$4.00 |
Part -2:
Alphacap, a manufacturer of electronic components, is trying to select a single supplier for the raw materials that go into their main product, the doublecap, a new capacitor that is used by cellular phone manufacturers to protect microprocessors from power spikes. Two companies can provide the necessary materials-MultiChem and Mixemat. MultiChem has a very solid reputation for its products and charges a higher price due to their reliability of supply and delivery.
MultiChem dedicates plant capacity to each customer and therefore supply is assured. This allows MultiChem to charge $1.20 for the raw materials used in each double cap. Mixemat is a small raw materials supplier that has limited capacity.
They charge only $.90 for a unit's worth of raw materials but their reliability of supply is in question. They do not have enough capacity to supply all their customers all the time. This means that orders to Mixemat are not guaranteed. In a year of high demand for raw materials, Mixemat will have 90,000 units available for Alphacap.
In low demand years, all product will be delivered. If Alphacap does not get raw materials from their suppliers, they need to buy them on the spot market to supply their customers. Alphacap relies on one major cell phone manufacturer for the majority of its business and failing to deliver could cause them to lose this contract, essentially putting the firm at risk.
Therefore, Alphacap will buy raw material on the spot market to make up for any shortfall. Spot prices for single-lot purchases (such as Alphacap would need) are $2.00 when raw materials demand is low and $4.00 when demand is high.
Demand in the raw materials market has a 75 percent chance of being high in the market each of the next two years. Alphacap sold 100,000 doublecaps last year and expects to sell 110,000 this year.
However, there is a 25 percent chance they will only sell 100,000. Next year, the demand has a 75 percent chance of rising 20 percent over this year and a 25 percent chance of falling 10 percent.
Alphacap uses a discount rate of 20 percent. Assume all costs are incurred at the beginning of each year (Year l's costs are incurred now and Year 2 costs are incurred in a year) and that Alphacap must make a decision with a two-year horizon. Only one supplier can be chosen as these two suppliers refuse to supply someone who works with their competitor.
Which supplier should Alphacap choose? What other information would you like to have to make this decision?
Part -3:
Designing the Distribution network for Michael‘s hardware.
Questions
1. What is the annual distribution cost of the current distribution network? Include transportation and inventory costs.
2. How should Ellen structure distribution from suppliers to the store in Illinois? What annual saving can she expect ?
3. How should Ellen structure distribution from suppliers to the store in Arizona? What annual savings can she expect ?
4. What changes in the distribution network (if any ) would you suggest as both markets grow?