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.

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

ANSWER:

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.

 







About this question:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 16, 2020

PRICE: $11.5

Solution~00011010.zip (18.37 KB)

Buy this answer for only: $11.5

Pay using PayPal (No PayPal account Required) or your credit card. All your purchases are securely protected by PayPal.
SiteLock

Need a similar solution fast, written anew from scratch? Place your own custom order

We have top-notch tutors who can help you with your essay at a reasonable cost and then you can simply use that essay as a template to build your own arguments. This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student. New solution orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

Order Now