#### Question Details

##### (Solved) (Latest ver. Aug 2020) - Minimizing costs for Bunker Manufacturing firm

Brief item decscription

Item details:

Question:

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
EmployeeABCDEF
1\$12\$7\$20\$14\$8\$10
210141320911
35369710
4911716910
51061481012

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.

STATUS
QUALITY
Approved