LM.91 XYZ Company is rethinking the way it ships to its 74 customers in another city 222 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 $126. 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 (222 miles) = $740 • Average weight per customer order = 500 lbs. • Warehouse break-bulk fee (per 100 lbs., a.k.a. per "hundred weight") = $13 • Local LTL delivery fee (per customer order) = $38 What is the total cost of delivering to all customers via LTL carrier (current method)? (Display your answer as a whole number.) Number How much money would XYZ company save by using the alternate shipping/delivery method for delivery to all customers? (Display your answer as a whole number.) Number At what number of customers would the cost of these two methods be the same? (Display your answer as a whole number.) Number
LM.91 XYZ Company is rethinking the way it ships to its 74 customers in another city 222 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 $126. 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 (222 miles) = $740 • Average weight per customer order = 500 lbs. • Warehouse break-bulk fee (per 100 lbs., a.k.a. per "hundred weight") = $13 • Local LTL delivery fee (per customer order) = $38 What is the total cost of delivering to all customers via LTL carrier (current method)? (Display your answer as a whole number.) Number How much money would XYZ company save by using the alternate shipping/delivery method for delivery to all customers? (Display your answer as a whole number.) Number At what number of customers would the cost of these two methods be the same? (Display your answer as a whole number.) Number
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...
Related questions
Question
Transcribed Image Text:LM.91 XYZ Company is rethinking the way it ships to its 74 customers in another city 222 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 $126.
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 (222 miles) = $740
Average weight per customer order = 500 Ibs.
• Warehouse break-bulk fee (per 100 lbs., a.k.a. per "hundred weight") = $13
• Local LTL delivery fee (per customer order) = $38
What is the total cost of delivering to all customers via LTL carrier (current method)? (Display your answer as a whole number.)
Number
How much money would XYZ company save by using the alternate shipping/delivery method for delivery to all customers? (Display your answer as a whole
number.)
Number
At what number of customers would the cost of these two methods be the same? (Display your answer as a whole number.)
Number
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
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…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.