Explore BrainMass

Explore BrainMass

    Minimizing costs for Bunker Manufacturing firm

    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.

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

    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.

    © BrainMass Inc. brainmass.com June 3, 2020, 8:31 pm ad1c9bdddf
    https://brainmass.com/business/accounting/minimizing-costs-bunker-manufacturing-firm-142055

    Attachments

    Solution Preview

    Please see the attached file.

    The textbook answer is 1-B, 2-E, 3-A, 4-C, 5-D, 6-F, Z=36

    This is pretty straight forward. You know that 3 cannot be on E and 4 cannot be on B so we mark those with RED. ...

    Solution Summary

    Uses a colored MS Word table (but can easily done in Excel) to show the Bunker Manufacturing firm's five employees and six machines, and how it wants to assign the employees to the Machines to minimize cost. Takes into consideration union rules regarding departmental transfers, employee 3 cannot be assigned to machine E, and employee 4 cannot be assigned to machine B. Also shows computed minimum cost.

    $2.19

    ADVERTISEMENT