1. The approximate travel time for officiating crews for college basketball for four games scheduled for a weekend are shown in the following table: Game Site Crew Syracuse Buffalo Rochester Ithaca A 1.2 1.4 0.2 1.5 B 1.0 2.0 0.5 1.0 C 1.2 3.4 2.4 0.5 D 2.1 3.1 1.1 0.8 NOTE: Time in hours Use Excel to answer the following questions: What set of crew assignments will minimize travel time What is the total time required for the optimal assignment
1. The approximate travel time for officiating crews for college basketball for four games scheduled for a weekend are shown in the following table: Game Site Crew Syracuse Buffalo Rochester Ithaca A 1.2 1.4 0.2 1.5 B 1.0 2.0 0.5 1.0 C 1.2 3.4 2.4 0.5 D 2.1 3.1 1.1 0.8 NOTE: Time in hours Use Excel to answer the following questions: What set of crew assignments will minimize travel time What is the total time required for the optimal assignment
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter6: Optimization Models With Integer Variables
Section: Chapter Questions
Problem 100P
Related questions
Question
100%
1. The approximate travel time for officiating crews for college basketball for four games scheduled for a weekend are shown in the following table:
Game Site
Crew Syracuse Buffalo Rochester Ithaca
A 1.2 1.4 0.2 1.5
B 1.0 2.0 0.5 1.0
C 1.2 3.4 2.4 0.5
D 2.1 3.1 1.1 0.8
NOTE: Time in hours
Use Excel to answer the following questions:
What set of crew assignments will minimize travel time
What is the total time required for the optimal assignment
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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 1 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,