Question
LM.91 XYZ Company is rethinking the way it ships to its 47 customers in another city 230 miles away. Current Shipping/Delivery Method They currently hire
LM.91 XYZ Company is rethinking the way it ships to its 47 customers in another city 230 miles away. Current Shipping/Delivery Method They currently hire an LTL (less-than-truckload) carrier to pick up and deliver these shipments. Each customer order shipped via LTL carrier costs $146. Alternate Shipping/Delivery Method A 3PL (third-party logistics provider) has approached XYZ Company and suggested that they make full truckload (TL) shipments from their facility to the 3PL's warehouse in the customers' city. The 3PL would then break the bulk shipment (TL or truckload shipment) into individual customer orders to be shipped locally by an LTL carrier. The relative data for this alternate shipping method are as follows: Full TL shipment cost (230 miles) = $810 Average weight per customer order = 890 lbs. Warehouse break-bulk fee (per 100 lbs., a.k.a. per "hundred weight") = $10 Local LTL delivery fee (per customer order) = $29
At what number of customers would the cost of these two methods be the same? (Display your answer as a whole number.)
Please show answer in Excel!!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started