Busi. 410 Lab Pre-Practice 1

# Busi. 410 Lab Pre-Practice 1 - Microsoft Excel 12.0 Answer...

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

Microsoft Excel 12.0 Answer Report Worksheet: [Book1]Lab Practice 1 Report Created: 9/2/2010 11:26:23 AM Target Cell (Max) Cell Name Original Value Final Value \$E\$5 Contribution 2150 33500 Adjustable Cells Cell Name Original Value Final Value \$B\$11 b 1 10 \$C\$11 r 1 20 Constraints Cell Name Cell Value Formula Status Slack \$E\$7 Production capacity 70 \$E\$7<=\$G\$7 Binding 0 \$E\$8 Loading capacity 30 \$E\$8<=\$G\$8 Binding 0 \$E\$9 Resource limit 50 \$E\$9<=\$G\$9 Not Binding 15

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

View Full Document
b r Max. 950 1200 Contribution 33500 Subject to 1.4 2.8 Production capacity 70 <= 70 1 1 Loading capacity 30 <= 30 3 1 Resource limit 50 <= 65 Actual used Total available 10 20 Solution
Microsoft Excel 12.0 Answer Report Worksheet: [Busi. 410 Lab Pre-Practice 1.xls]Sheet2 Report Created: 9/2/2010 12:55:45 PM Target Cell (Max) Cell Name Original Value Final Value \$G\$5 Contribution 15 9200 Adjustable Cells Cell Name Original Value Final Value \$B\$15 F1 1 1000 \$C\$15 F2 1 800 \$D\$15 F3 1 400 \$E\$15 F4 1 0 Constraints Cell Name Cell Value Formula Status Slack \$G\$7 F1 limit 1000 \$G\$7<=\$I\$7 Binding 0 \$G\$8 F2 limit 800 \$G\$8<=\$I\$8 Not Binding 1200 \$G\$9 F3 limit 400 \$G\$9<=\$I\$9 Not Binding 100 \$G\$10 F4 limit 0 \$G\$10<=\$I\$10 Not Binding 1000 \$G\$11 Labor hours 4000 \$G\$11<=\$I\$11 Binding 0 \$G\$12 Metal ounces 6000 \$G\$12<=\$I\$12 Binding 0 \$G\$13 Glass ounces 8000 \$G\$13<=\$I\$13 Not Binding 2000

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

View Full Document
Microsoft Excel 12.0 Sensitivity Report Worksheet: [Busi. 410 Lab Pre-Practice 1.xls]Sheet2 Report Created: 9/2/2010 12:55:45 PM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$B\$15 F1 1000 0 6 1.00E+030 2 \$C\$15 F2 800 0 2 1 0.25 \$D\$15 F3 400 0 4 2 0.5 \$E\$15 F4 0 -0.2 3 0.2 1.00E+030 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease \$G\$7 F1 limit 1000 2 1000 400 600 \$G\$8 F2 limit 800 0 2000 1.00E+030 1200 \$G\$9 F3 limit 400
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 15

Busi. 410 Lab Pre-Practice 1 - Microsoft Excel 12.0 Answer...

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

View Full Document
Ask a homework question - tutors are online