Busi. 410 Lab Pre-Practice 1

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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full Document Right Arrow Icon
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
Background image of page 2
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
Background image of page 3

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

View Full Document Right Arrow Icon
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
Background image of page 4
Image of page 5
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 Right Arrow Icon
Ask a homework question - tutors are online