MAT500 Assignment 3 Solution

MAT500 Assignment 3 Solution - Microsoft Excel 12.0 Answer...

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

View Full Document Right Arrow Icon
Microsoft Excel 12.0 Answer Report Worksheet: [7 Assignment 3 Solution by Mei-Lin Chen.xls]Julia's Food Booth Report Created: 8/9/2011 11:23:56 PM Target Cell (Max) Cell Name Original Value Final Value $B$15 Profit ($) = 2250 2250 Adjustable Cells Cell Name Original Value Final Value $B$12 Pizza slices (X1)= 1250 1250 $B$13 Hot dogs (X2)= 1250 1250 $B$14 Barbecue sandwiches (X3)= 0 0 Constraints Cell Name Cell Value Formula Status Slack $F$6 budget Usage 1500.00 $F$6<=$H$6 Binding 0 $F$7 in-square of oven space Usage 50625.00 $F$7<=$H$7 Not Binding 4671 $F$8 at least as many x1 as x2 and x3 combined Usage 0.00 $F$8>=$H$8 Binding 0.00 $F$9 at least twice as many x2 as x3 Usage 1250.00 $F$9>=$H$9 Not Binding 1250.00
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 12.0 Sensitivity Report Worksheet: [7 Assignment 3 Solution by Mei-Lin Chen.xls]Julia's Food Booth Report Created: 8/9/2011 11:24:10 PM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$12 Pizza slices (X1)= 1250 0 0.75 1 1.00000001 $B$13 Hot dogs (X2)= 1250 0 1.05 1.0000E+030 0.2727272795 $B$14 Barbecue sandwiches (X3)= 0 -0.3750000114 1.350000002 0.375000011 1.0000E+030 Constraints Final Shadow Constraint
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

MAT500 Assignment 3 Solution - Microsoft Excel 12.0 Answer...

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