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

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!