{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Problem 3 (a)

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

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

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

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

View Full Document
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
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

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online