Question: Please solve in excel with excel solver. Dont solve any other way please DO NOT ANSWER UNLESS SHOWING THE EXCEL WORKBOOK WITH THE EXCEL SOLVER
Please solve in excel with excel solver. Dont solve any other way please
DO NOT ANSWER UNLESS SHOWING THE EXCEL WORKBOOK WITH THE EXCEL SOLVER SCREENSHOTS SHOWING FORMULAS
Colonel Cutlass, having just taken command of the brigade, has decided to assign men to his staff based on previous experience. His list of major staff positions to be filled is adjutant (personnel officer), intelligence officer, operations officer, supply officer, and training officer. He has five men he feels could occupy these five positions. Below are their years of experience in the several fields.
| Adjutant | Intelligence | Operations | Supply | Training | |
| Major Muddle | 3 | 5 | 6 | 2 | 2 |
| Major Whiteside | 2 | 3 | 5 | 3 | 2 |
| Captain Kid | 3 | 0 | 4 | 2 | 2 |
| Captain Klutch | 3 | 0 | 3 | 2 | 2 |
| Lt. Whiz | 0 | 3 | 0 | 1 | 0 |
Who, based on experience, should be placed in which positions to give the greatest total years of experience for all jobs? What is the maximum total years Col. Cutlass can get with the five men.
Hint: Colonel Cutlass is trying to make an one-to-one assignment of positions with personnel.
Difficulty Level: Easy
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
