Ch2.7 - Value Cost Coefficient Increase Decrease $C$4 Daily...

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

View Full Document Right Arrow Icon
Microsoft Excel 9.0 Answer Report Worksheet: [Book3]Sheet1 Report Created: 7/6/2001 4:18:39 PM Target Cell (Max) Cell Name Original Value Final Value $E$6 Profit Total 0 5520 Adjustable Cells Cell Name Original Value Final Value $C$4 Daily Baseballs 0 360 $D$4 Daily Softballs 0 300 Constraints Cell Name Cell Value Formula Status Slack $E$7 Cowhide Total 3600 $E$7<=$G$7 Binding 0 $E$8 Minutes Total 960 $E$8<=$G$8 Binding 0 $E$9 Max Baseballs Total 360 $E$9<=$G$9 Not Binding 140 $E$10 Max Softballs Total 300 $E$10<=$G$10 Not Binding 200
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 9.0 Sensitivity Report Worksheet: [Book3]Sheet1 Report Created: 7/6/2001 4:18:39 PM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name
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: Value Cost Coefficient Increase Decrease $C$4 Daily Baseballs 360 7 1.33 2 $D$4 Daily Softballs 300 10 4 1.6 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$7 Cowhide Total 3600 1 3600 280 720 $E$8 Minutes Total 960 2 960 160 93.33 $E$9 Max Baseballs Total 360 500 1.00E+030 140 $E$10 Max Softballs Total 300 500 1.00E+030 200 WILSON MANUFACTURING Baseballs Softballs Daily 360 300 Total Profit 7 10 5520 Cowhide 5 6 3600 &lt;= 3600 Minutes 1 2 960 &lt;= 960 Max Baseballs 1 360 &lt;= 500 Max Softballs 1 300 &lt;= 500...
View Full Document

This note was uploaded on 10/15/2009 for the course MGT mgt taught by Professor Tannous during the Spring '09 term at University of Houston - Downtown.

Page1 / 3

Ch2.7 - Value Cost Coefficient Increase Decrease $C$4 Daily...

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