The Patricia Garcia company is currently producing seven new medical products. Each of Garcia's eight plants can add one more product to its current line of medical devices. The unit manufacturing costs for producing the different parts at the eight plants are shown below.
How should Garcia assign the new products to the plants in order to minimize manufacturing costs?
Please show each and every step in excel solver. Please show how to calculate each formula on each step in solver.
You need to know the table is ready for solver and then each step when preparing solver for the solution.
|
P1 |
P2 |
P3 |
P4 |
P5 |
P6 |
P7 |
P8 |
|
| C53 |
.1 |
.12 |
.13 |
.11 |
.1 |
.06 |
.16 |
.12 |
|
| C81 |
.05 |
.06 |
.04 |
.08 |
.04 |
.09 |
.06 |
.06 |
|
| D5 |
.32 |
.4 |
.31 |
.3 |
.42 |
.35 |
.36 |
.49 |
|
| D44 |
.17 |
.14 |
.19 |
.15 |
.1 |
.16 |
.19 |
.12 |
|
| E2 |
.06 |
.07 |
.1 |
.05 |
.08 |
.1 |
.11 |
.05 |
|
| E35 |
.08 |
.1 |
.12 |
.08 |
.09 |
.1 |
.09 |
.06 |
|
| G99 |
.55 |
.62 |
.61 |
.7 |
.62 |
.63 |
.65 |
.59 |
|
|
|
|
|
|
|
|
|
|
|