Question: Please help!!! will give thumbs up!! Problem 2 Decisin Variables (2 pts): Solver solution (1.5 pts) (create the excel tables below this box) The Indiana

Please help!!! will give thumbs up!!

Please help!!! will give thumbs up!! Problem 2

Problem 2 Decisin Variables (2 pts): Solver solution (1.5 pts) (create the excel tables below this box) The Indiana Department of Transportation, is seeking to optimize track inspection on the railroad network. You are asked to formulate a simpler version of this track inspection planning problem. Suppose that there 5 rail tracks that may be inspected. Each track has different inspection importance and a unique amount of time required to complete the inspection. The table Objective Fucntion (2 pts): below gives the importance lovel and inspection time for each track. Constraints (3.5 pts) Subject to, As the insper maximize the total importance level of the inspections. However, you have one day (i.e., 24 hours] available to complete the inspections. That is, total inspection time cannot exceed 24 hours. * You have been asked to also include the following restrictions in your model: -If you inspect track 1 , then you must inspect track 2 . -You can either inspect track 3 or track 4 , but not both. -If you inspect both track 1 and track 2 , then you must inspect track 4. -You cannot inspect track 3 unless you inspect track 4. - Formulate a binary linear programming model for the above inspection planning problem by defining decision variables, the objectlve function, and constraints accordingly. Interpretation of results (1 pts): - Formulate and solve this problem using solver

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!