Minimizing costs for Bunker Manufacturing firm
Not what you're looking for?
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.
Purchase this Solution
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.
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. ...
Purchase this Solution
Free BrainMass Quizzes
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Motivation
This tests some key elements of major motivation theories.
Basics of corporate finance
These questions will test you on your knowledge of finance.
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.