Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Speedy delivery provides two-day delivery service of large parcels across the US. Each morning, the dispatcher organizes trucks to ensure all deliveries are met. The

Speedy delivery provides two-day delivery service of large parcels across the US. Each morning, the dispatcher organizes trucks to ensure all deliveries are met. The company has three drivers available today that need to be allocated into three of the possible 'attractive' routes you pre-determined. The table with the routes in in the Excel file. The '1's mark the delivery locations each route visits. Find which three routes should be allocated to the three drivers so that each delivery location is visited at least once and that minimizes the total travel time. Which routes should be used? (list your answer in numerical order separate by commas with no spaces, e.g., 1,2,3 or 3,4,8)

What would be the total travel time of all three drivers summed if taking the 3 optimal routes?

Show me step by step in Excel Please.

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

Supply Chain Management A Logistics Perspective

Authors: John coyle, John Langley, Robert Novack, Brain Gibson

9th edition

9780538479189, 9781285400945, 538479191, 538479183, 1285400941, 978-0538479196

More Books

Students also viewed these General Management questions

Question

Graph. y > x - 3

Answered: 1 week ago