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.

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.

The BunkerManufacturingFirm 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
_______________________________________________
Emp A B C D E F
1 $10 $12 $ 7 $20 $14 $

A firm uses two variable inputs, labor, L, and raw materials, M, with typically shaped isoquants. It pays $20 per hour for L and $5 per unit for M. At the current mix of L and M, the marginal products of L and M are:
MPL = 20
MPM = 4
Is the firmminimizingcosts? If not, what steps should it take to lower costs and sti

A surfboard manufacturing company has determined that the cost function c(x), in hundreds of dollars, for producing x hundreds of boards is c(x) = .2x^2 -.84x + 3.625.
How many surfboards should the company make to minimize production costs?

For each of the following graphs, identify the firm's profit-maximizing (or loss-minimizing) output. Is each firm making a profit? If not, should the firm continue to produce in the short run?
(See Attachment for Graphs)

An electronic firm uses 600 cases of transistors each year. Each case costs $1000. The cost of storing one case for a year is 90 cents and the ordering fee is $30 per shipment. How many cases should the firm order each time to keep total cost at minimum. (Assume that transistors are use at a constant rate throughout the year and

Please help with the following problem regarding upgrading manufacturing facilities.
You are considering upgrading some manufacturing facilities by purchasing one of three different machines, each with the same production capacity. Machine a costs $30,000, has a life of 40 years, annual maintenance costs of $1500, and salvag

Jake's Bunker (Bob's Country Bunker), a chain of economically priced motels in the Midwestern United States has reviewed its current target structure of 40% debt and 60% equity. It can issue debt at a rate of 9%. The last dividend paid on its stock was $1.25. The company is doing very well and expects to maintain its current

Callaway Golf Company has determined that the daily cost C of manufacturing x Big-Bertha-type gold clubs may be expressed by the quadratic equation
C(x) = 5 x 2 - 620 x + 20,000,
a) How many clubs should be manufactured to minimize the cost?
b) At this level of production, what is the cost per club?
c) What are the fi

Bunker Company negotiated a lease with Gilbreth Company that begins on January 1, 2011. The lease term is three years, and the asset's c=economic life is four years. The annual lease payments are $7,500, payable at the end of the year. The cost and fair value of the asset are $23,000. The lessee's cost of borrowing is 9%.
1.