Problem 3 (a)

Problem 3 (a) - 1.875 $G$14 Units TM 0 1.1538461538 6.5...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Microsoft Excel 8.0e Answer Report Assig 2 Problem 3 (a) Target Cell (Min) Cell Name Original Value Final Value $K$5 Min Solution 0 368076.92308 Adjustable Cells Cell Name Original Value Final Value $C$14 Units FM 0 5000 $D$14 Units FP 0 0 $E$14 Units SM 0 2692.3076923 $F$14 Units SP 0 7307.6923077 $G$14 Units TM 0 0 $H$14 Units TP 0 5000 Constraints Cell Name Cell Value Formula Status Slack $I$7 Constrain1 LHS 21000 $I$7<=$J$7 Binding 0 $I$8 Constrain2 LHS 15576.92307692 $I$8<=$J$8 Not Binding 9623.076923 $I$9 Constrain3 LHS 22500 $I$9<=$J$9 Not Binding 18300 $I$10 Constrain4 LHS 5000 $I$10>=$J$10 Binding 0 $I$11 Constrain5 LHS 10000 $I$11>=$J$11 Binding 0 $I$12 Constain6 LHS 5000 $I$12>=$J$12 Binding 0
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Microsoft Excel 8.0e Sensitivity Report Assig 2, Problem 3 (a) Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$14 Units FM 5000 0 38 3.5769230769 47.42307692 $D$14 Units FP 0 3.5769230769 51 1.0000E+030 3.5769230769 $E$14 Units SM 2692.307692 0 11.5 1.875 1.3285714286 $F$14 Units SP 7307.692308 0 15 1.3285714286
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1.875 $G$14 Units TM 0 1.1538461538 6.5 1.0000E+030 1.1538461538 $H$14 Units TP 5000 7.5 1.1538461538 7.5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $I$7 Constrain1 LHS 21000 -2.6923076923 21000 7358.823529 3500 $I$8 Constrain2 LHS 15576.92308 25200 1.0000E+030 9623.076923 $I$9 Constrain3 LHS 22500 40800 1.0000E+030 18300 $I$10 Constrain4 LHS 5000 47.423076923 5000 1000 2714.285714 $I$11 Constrain5 LHS 10000 15 10000 1.0000E+030 7307.692308 $I$12 Constain6 LHS 5000 7.5 5000 1.0000E+030 5000 Assig2, Problem 3 a FM FP SM SP TM TP LHS RHS Solution Min 38 51 11.5 15 6.5 7.5 368076.92 Constr 1 3.5 1.3 0.8 21000 21000 Constr 2 2.2 1.7 15576.923 25200 Constr 3 3.1 2.6 1.7 22500 40800 Constr 4 1 1 5000 5000 Constr 5 1 1 10000 10000 Constr 6 1 1 5000 5000 Units 5000 2692 7308 5000...
View Full Document

This note was uploaded on 02/15/2012 for the course GERM 200 taught by Professor Kuhmar during the Spring '10 term at SUNY Albany.

Page1 / 3

Problem 3 (a) - 1.875 $G$14 Units TM 0 1.1538461538 6.5...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online