{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

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

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

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

View Full Document
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
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 <= 3600 Minutes 1 2 960 <= 960 Max Baseballs 1 360 <= 500 Max Softballs 1 300 <= 500...
View Full Document

{[ snackBarMessage ]}

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