2. [20 points] Javier Mendez is the head coach of the renowned AKA mixed martial arts...

Transcribed Image Text:

2. [20 points] Javier Mendez is the head coach of the renowned AKA mixed martial arts gym. AKA has three full-time coaches already, each with years of experience in various martial arts. Their experience in martial arts in a scale of 1-5=, 1 being beginner and 5 being expert, is given in the following table: Coach Derek Yuen Wayne Phillips Ron Kelsar Boxing 5 2 2 Coach Daniel Cormier Cain Velasquez Luke Rockhold Wrestling 3 4 2 Boxing 4 4 3 Martial Art Jui Jitsu 2 5 2 5 5 3 Muay Thai 2 2 4 With the help of an MBA student, who is also a student at AKA, coach Mendez has developed a linear program to assign coaches to each martial arts class to maximize the overall teaching rating. The LPSolve model is given in 'Q2 Model.mod' file and Excel Solver Model is given in 'Q2 Model.xlsx'. In this model, the class rating is maximized (higher experience coach in a class is related to higher rating), while each coach will be teaching 2 classes or less and each class will have exactly one coach. After developing the LP, coach Mendez hired three former champions as coaches to help with the increasing presence of athletes. The new coaches are also very experienced. Their rating is given in the table below: Wrestling Jui Jitsu 3 3 2 Taekwondo Martial Art Muay Thai 2 2 5 2 2 5 MMA 4 4 4 Taekwondo 2 2 4 MMA 4 5 4 Coach Mendez wants to reduce the workload of coaches by assigning one coach to only one class. a. Develop a linear programming model stating the decision variables, objective function, and constraints to represent the problem. b. Solve the model for the previous situation (2 classes to 1 coach). Which coach should be assigned to what class? What is the total rating? (Hint: *.mod files can be opened with Notepad or similar text editor software in addition to LP Solve). C. Solve the model with the current situation (1 class to 1 coach). Modify the Linear Programming model and find the best assignment of 6 coaches to 6 classes to maximize the overall rating. Which coach should be assigned to what class? What is the total rating? d. If a coach can teach a maximum of 2 classes, would the solution change? Explain. 2. [20 points] Javier Mendez is the head coach of the renowned AKA mixed martial arts gym. AKA has three full-time coaches already, each with years of experience in various martial arts. Their experience in martial arts in a scale of 1-5=, 1 being beginner and 5 being expert, is given in the following table: Coach Derek Yuen Wayne Phillips Ron Kelsar Boxing 5 2 2 Coach Daniel Cormier Cain Velasquez Luke Rockhold Wrestling 3 4 2 Boxing 4 4 3 Martial Art Jui Jitsu 2 5 2 5 5 3 Muay Thai 2 2 4 With the help of an MBA student, who is also a student at AKA, coach Mendez has developed a linear program to assign coaches to each martial arts class to maximize the overall teaching rating. The LPSolve model is given in 'Q2 Model.mod' file and Excel Solver Model is given in 'Q2 Model.xlsx'. In this model, the class rating is maximized (higher experience coach in a class is related to higher rating), while each coach will be teaching 2 classes or less and each class will have exactly one coach. After developing the LP, coach Mendez hired three former champions as coaches to help with the increasing presence of athletes. The new coaches are also very experienced. Their rating is given in the table below: Wrestling Jui Jitsu 3 3 2 Taekwondo Martial Art Muay Thai 2 2 5 2 2 5 MMA 4 4 4 Taekwondo 2 2 4 MMA 4 5 4 Coach Mendez wants to reduce the workload of coaches by assigning one coach to only one class. a. Develop a linear programming model stating the decision variables, objective function, and constraints to represent the problem. b. Solve the model for the previous situation (2 classes to 1 coach). Which coach should be assigned to what class? What is the total rating? (Hint: *.mod files can be opened with Notepad or similar text editor software in addition to LP Solve). C. Solve the model with the current situation (1 class to 1 coach). Modify the Linear Programming model and find the best assignment of 6 coaches to 6 classes to maximize the overall rating. Which coach should be assigned to what class? What is the total rating? d. If a coach can teach a maximum of 2 classes, would the solution change? Explain.