Homework Help is Here – Start Your Trial Now!
Business
Operations Management
A contractor has one crane available at four different building sites at which work has just been completed. The contractor wants to move the four cranes to four new sites. The transportation time (in hours) between the old and the new sites is presented in the table below. New Sites Old Sites I II III IV A 3.50 4.00 8.50 5.00 B 4.25 5.50 9.25 5.50 с 6 5.50 7.50 6.50 D 4.00 7.00 7.50 3.75 a) Develop a mathematical model that can be used to find the optimal way to move the cranes between old and new sites optimally. b) Solve the problem using Microsoft Excel (Please, submit your Excel file along with your

A contractor has one crane available at four different building sites at which work has just been completed. The contractor wants to move the four cranes to four new sites. The transportation time (in hours) between the old and the new sites is presented in the table below. New Sites Old Sites I II III IV A 3.50 4.00 8.50 5.00 B 4.25 5.50 9.25 5.50 с 6 5.50 7.50 6.50 D 4.00 7.00 7.50 3.75 a) Develop a mathematical model that can be used to find the optimal way to move the cranes between old and new sites optimally. b) Solve the problem using Microsoft Excel (Please, submit your Excel file along with your

Practical Management Science
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
See similar textbooks
icon
Related questions
Question
100%
A contractor has one crane available at four different building sites at which work has just been completed. The contractor wants to move the four cranes to four new sites. The transportation time (in hours) between the old and the new sites is presented in the table below. New Sites Old Sites I II III IV A 3.50 4.00 8.50 5.00 B 4.25 5.50 9.25 5.50 C 6 5.50 7.50 6.50 D 4.00 7.00 7.50 3.75 a) Develop a mathematical model that can be used to find the optimal way to move the cranes between old and new sites optimally. b) Solve the problem using Microsoft Excel (Please, submit your Excel file along with your answer)
Transcribed Image Text:A contractor has one crane available at four different building sites at which work has just been completed. The contractor wants to move the four cranes to four new sites. The transportation time (in hours) between the old and the new sites is presented in the table below. New Sites Old Sites I II III IV A 3.50 4.00 8.50 5.00 B 4.25 5.50 9.25 5.50 C 6 5.50 7.50 6.50 D 4.00 7.00 7.50 3.75 a) Develop a mathematical model that can be used to find the optimal way to move the cranes between old and new sites optimally. b) Solve the problem using Microsoft Excel (Please, submit your Excel file along with your answer)
Expert Solution
steps

Step by step

Solved in 2 steps with 4 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
SEE MORE TEXTBOOKS