What is the cost of direct shipping for Illinois, when small trucks are used?

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

Designing the Distribution Network for Michael’s Hardware Ellen Lin, vice president of supply chain at Michael’s Hardware, was looking at the financial results from the past quarter and thought that the company could significantly improve its distribution costs, especially given the recent expansion into Arizona. Transportation costs had been very high, and Ellen believed that moving away from LTL shipping to Arizona would help lower transportation costs without significantly raising inventories. Michael’s had 32 stores each in Illinois and Arizona and sourced its products from eight suppliers located in the Midwest. The company began in Illinois and its stores in the state enjoyed strong sales. Each Illinois store sold, on average, 50,000 units a year of product from each supplier (for annual sales of 400,000 units per store). The Arizona operation was started about five years ago and still had plenty of room to grow. Each Arizona store sold 10,000 units a year from each supplier (for annual sales of 80,000 units per store). Given the large sales at its Illinois stores, Michael’s followed a direct-ship model and shipped small truckloads (with a capacity of 10,000 units) from each supplier to each of its Illinois stores. Each small truck cost $450 per delivery from a supplier to an Illinois store and could carry up to 10,000 units. In Arizona, however, the company wanted to keep inventories low and used LTL shipping that required a minimum shipment of only 500 units per store but cost $0.50 per unit. Holding costs for Michael’s were $1 per unit per year. Ellen asked her staff to propose different distribution alternatives for both Illinois and Arizona. Distribution Alternatives for Illinois Ellen’s staff proposed two alternative distribution strategies for the stores in Illinois: Use direct shipping with even larger trucks that had a capacity of 40,000 units. These trucks charged only $1,150 per delivery to an Illinois store. Using larger trucks would lower transportation costs but increase inventories because of the larger batch sizes. Run milk runs from each supplier to multiple stores in Illinois to lower inventory cost even if the cost of transportation increased. Large trucks (capacity of 40,000 units) would charge $1,000 per shipment and a charge of $150 per delivery. Small trucks (capacity of 10,000 units) would charge $400 per shipment and a charge of $50 per delivery. Distribution Alternatives for Arizona Ellen’s staff had three distribution alternatives for the stores in Arizona: Use direct shipping with small trucks (capacity of 10,000 units) as was currently being done in Illinois. Each small truck charged $2,050 for a shipment of up to 10,000 units from a supplier to a store in Arizona. This was a significantly lower transportation cost than was currently being charged by the LTL carrier. This alternative, however, would increase inventory costs in Arizona given the larger batch sizes. Run milk runs using small trucks (capacity of 10,000 units) from each supplier to multiple stores in Arizona. The small truck carrier charged $2,000 per shipment and $50 per delivery. Thus, a milk run from a supplier to four stores would cost $2,200. Milk runs would incur higher transportation costs than direct shipping but would keep inventory costs lower. Use a third-party cross-docking facility in Arizona that charged $0.10 per unit for this cross-docking service. This would allow all suppliers to ship product (destined for all 32 Arizona stores) using a large truck to the cross-dock facility, where it would be cross-docked and sent to stores in smaller trucks (each smaller truck would now contain product from all eight suppliers). Large trucks (capacity of 40,000 units) charge $4,150 from each supplier to the cross-dock facility. Small trucks (capacity of 10,000 units) charge $250 from the cross-dock facility to each retail store in Arizona. Ellen wondered how best to structure the distribution network and whether the savings would be worth the effort. If she used milk runs in either region, she also had to decide on how many stores to include in each milk run.

What is the cost of direct shipping for Illinois, when small trucks are used?

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.