MAT500 Assignment 3 Solution

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

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

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

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

View Full Document
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
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

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