2-1 - $4,040.00 Adjustable Cells Cell Name Original Value...

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

View Full Document Right Arrow Icon
Flair Furn T C Number of units Profit $7 $5 $0.00 Constraints: Carpentry 3 4 0.0 <=### Painting h 2 1 0.0 <=### Maximum cha 1 0.0 <=### Minimum 1 0.0 >=### LHS SignRHS s s
Background image of page 1

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

View Full DocumentRight Arrow Icon
Flair Furniture T C Tables Chairs Number of units 320.0 360.0 Profit $7 $5 $4,040.00 Constraints: Carpentry hours 3 4 2400.0 <= 2400 Painting hours 2 1 1000.0 <= 1000 Maximum chairs 1 360.0 <= 450 Minimum tables 1 320.0 >= 100 LHS Sign RHS
Background image of page 2
Microsoft Excel 10.0 Answer Report Worksheet: [2-1.xls]Flair Furniture Target Cell (Max) Cell Name Original Value Final Value $D$6 Profit $0.00
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $4,040.00 Adjustable Cells Cell Name Original Value Final Value $B$5 Number of units Tables 0.0 320.0 $C$5 Number of units Chairs 0.0 360.0 Constraints Cell Name Cell Value Formula Status Slack $D$8 Carpentry hours 2400.0 $D$8&lt;=$F$8 Binding 0.0 $D$9 Painting hours 1000.0 $D$9&lt;=$F$9 Binding 0.0 $D$10 Maximum chairs 360.0 $D$10&lt;=$F$10 Not Binding 90.0 $D$11 Minimum tables 320.0 $D$11&gt;=$F$11 Not Binding 220.0...
View Full Document

Page1 / 3

2-1 - $4,040.00 Adjustable Cells Cell Name Original Value...

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