Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Foundations Of Business Analysis

Authors: M Douglas Berg

1st Edition

1465222030, 9781465222039

More Books

Students also viewed these Finance questions