OOMMMP18-5 - Solution - Sessions 02&03

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 6

Slot 1 8 8 x1 6 Variable Cells

Slot 2 7 7 x2 2
Slot 3 6 6 x3 5 Cell Name
Slot 4 6 6 x4 1 $E$1 x1
Slot 5 5 5 x5 5 $E$2 x2
Slot 6 4 6 x6 0 $E$3 x3
$E$4 x4
19 $E$5 x5
$E$6 x6

Constraints

Cell Name
$C$1 Slot 1
$C$2 Slot 2
$C$3 Slot 3
$C$4 Slot 4
$C$5 Slot 5
$C$6 Slot 6
Final Reduced Objective Allowable Allowable
Value Cost Coefficient Increase Decrease
6 0 1 0 1
2 0 1 1 0
5 0 1 0 1
1 0 1 1 0
5 0 1 0 1
0 0 1 1E+030 0
Alternative optimal

Final Shadow Constraint Allowable Allowable


Value Price R.H. Side Increase Decrease
8 1 8 1E+030 2
7 0 7 2 2
6 1 6 2 2
6 0 6 2 1
5 1 5 1 2
6 0 4 2 1E+030
Project 1 2 3 4 5 6 7 8
Year 1 outflow 12 54 6 6 30 6 48 36
Year 2 outflow 3 7 6 2 35 6 4 3
NPV 14 17 17 15 40 12 14 10

Fraction of project 1 0 1 1 0 0.969697 0.045455 0


9 Total
18 50 50
3 20 20
12 70.27273

1
Options return rateInvestment Return fraction
Bonds 0.1 125000 12500 0.25
Home loans 0.16 125000 20000 0.25
Auto loans 0.13 125000 16250 0.25
Personal loans 0.2 125000 25000 0.25 125000

Total 500000 73750


Max 500,000
Type Alloy 1 Alloy 2 Combined Min Max
Cost per ton 190 200 193.75
Percent silicon 2 2.5 2.1875 1.8 2.5
Percent nickel 1 1.5 1.1875 0.9 1.2
Percent carbon 3 4 3.375 3.2 3.5
Tensile strength (psi) 42,000 50,000 45000 45000
Percentage 62.500% 37.500% 100.000%

You might also like