lp_class (2) - Allowable Cell Name Value Price R.H. Side...

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

View Full Document Right Arrow Icon
Microsoft Excel 12.0 Answer Report Worksheet: [lp_class.xls]Sheet1 Report Created: 08.10.2009 17:19:58 Target Cell (Max) Cell Name Original Value Final Value $B$11 total revenue Table 0 520000 Adjustable Cells Cell Name Original Value Final Value $B$9 production qty Table 0 200 $C$9 production qty Chair 0 200 Constraints Cell Name Cell Value Formula Status Slack $F$4 Large Piece material used 600 $F$4<=$D$4 Binding 0 $F$5 Small Piece material used 800 $F$5<=$D$5 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 12.0 Sensitivity Report Worksheet: [lp_class.xls]Sheet1 Report Created: 08.10.2009 17:19:59 Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$9 production qty Table 200 0 1600 400 600 $C$9 production qty Chair 200 0 1000 600 200 Constraints Final Shadow Constraint Allowable
Background image of page 2
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Allowable Cell Name Value Price R.H. Side Increase Decrease $F$4 Large Piece material used 600 600 600 200 200 $F$5 Small Piece material used 800 200 800 400 200 Microsoft Excel 12.0 Limits Report Worksheet: [lp_class.xls]Limits Report 1 Report Created: 08.10.2009 17:19:59 Target Cell Name Value $B$11 total revenue Table 520000 Adjustable Lower Target Upper Target Cell Name Value Limit Result Limit Result $B$9 production qty Table 200 0 200000 200 520000 $C$9 production qty Chair 200 0 320000 200 520000 Table Chair Availability material used Large Piece 2 1 600 600 Small Piece 2 2 800 800 Selling Price 1600 1000 production qty 200 200 total revenue 520000...
View Full Document

This note was uploaded on 12/30/2009 for the course ORG 301 taught by Professor Duygu during the Spring '09 term at Sabancı University.

Page1 / 4

lp_class (2) - Allowable Cell Name Value Price R.H. Side...

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

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