Applied Decision Making Problem Solution With Data
LillyWarsteiner
Fig3-17.xlsModule1
| ------- Slip Ring ------- | |||||
| Number to | Model 1 | Model 2 | Model 3 | ||
| Make | 0 | 0 | 0 | ||
| Buy | 0 | 0 | 0 | ||
| Cost to | |||||
| Make | $50 | $83 | $130 | Total Cost | |
| Buy | $61 | $97 | $145 | $0 | |
| # Available | 0 | 0 | 0 | ||
| # Needed | 3,000 | 2,000 | 900 | ||
| Hours Required | Used | Available | |||
| Wiring | 2.0 | 1.5 | 3.0 | 0 | 10,000 |
| Harnessing | 1.0 | 2.0 | 1.0 | 0 | 5,000 |
&A
Page &P
Variable cell
Variable cell
Variable cell
Variable cell
Variable cell
Variable cell
Set cell
Constraint cell
Constraint cell
Constraint cell
Constraint cell
Constraint cell
Electro-Poly Corporation
Minimize: E11
By changing: B6:D7
Subject to: B13:D13>=B14:D14
E17:E18<=F17:F18
B6:D7>=0
