Joe fix plans the repair schedules each day for the freeway


Joe Fix plans the repair schedules each day for the Freeway Airline. Joe has 3 planes in need of repair and 5 repair personnel at his disposal. Each plane requires a single repairperson, except plane 3, which needs 2 personnel. Anyone not assigned to maintaining an airplane works in the maintenance shop for the day (not modeled). Each repairperson has different likes and dislikes regarding the types of repairs they prefer. For each plane, Joe has pulled the expected maintenance and determined the total preference matrix for his repair personnel. The preference matrix is: Plane 1 Plane 2 Plane 3 Repair Person 1 11 9 21 Repair Person 2 17 7 13 Repair Person 3 9 12 17 Repair Person 4 14 8 28 Repair Person 5 12 5 12 develop the model assuming Joe would like to minimize the total cost in his worker-to-aircraft schedule Implement a spreadsheet model and use Excel Solver to obtain a solution to the problem. Submit your Excel Solver file.

Request for Solution File

Ask an Expert for Answer!!
Financial Management: Joe fix plans the repair schedules each day for the freeway
Reference No:- TGS02837985

Expected delivery within 24 Hours