Explore BrainMass

# Minimizing costs for Bunker Manufacturing firm

Not what you're looking for? Search our solutions OR ask your own Custom question.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

PROBLEM:

The Bunker Manufacturing firm has five employees and six machines and wants to assign the employees to the machines to minimize cost. A cost table showing the cost incurred by each employee on each machine follows:

Machine
Employee A B C D E F
1 \$12 \$7 \$20 \$14 \$8 \$10
2 10 14 13 20 9 11
3 5 3 6 9 7 10
4 9 11 7 16 9 10
5 10 6 14 8 10 12

Because of union rules regarding departmental transfers, employee 3 cannot be assigned to machine E, and employee 4 cannot be assigned to machine B. Using Excel, solve this problem, indicate the optimal assignment, and compute total minimum cost.

-----------------------------------------------------------------------------------------------

The answer is: 1-B, 2-E, 3-A, 4-C, 5-D, 6-F, Z=36. I need to know step-by-step how did the book come up with the above answer. Please do the solution on Excel.