MGT2251_Quiz6_092911

# MGT2251_Quiz6_092911 - Last Name First Name T-Square ID...

This preview shows page 1. Sign up to view the full content.

Last Name, First Name: T-Square ID QUIZ # 6 B DATE: 9/29/2011 TODAY's QUESTION: grams milligrams grams Price Description Calories Fat Cholesterol Protein 3.00 \$ McD Quarter Pounder Cheeseburger 513 28 95 29 2.50 \$ Taco Bell Baja Beef Chalupa 430 27 30 14 3.25 \$ Wendy's Single Cheeseburger 522 27 90 35 5.00 \$ Subway Footlong Cold Cut Combo 410 16 60 21 2.75 \$ Chik-Fil-A Sandwich 410 16 60 28 Microsoft Excel 14.0 Answer Report Objective Cel (Min) Cell Name Original Value Final Value \$H\$4 Minimize Cost ---> Total Cost 16.50 \$ 9.44 \$ Variable Cel s Cell Name Original Value Final Value Integer \$C\$13 McD Quarter Pounder Cheeseburger 1 0.51 Contin \$D\$13 Taco Bel Baja Beef Chalupa 1 0 Contin \$E\$13 Wendy's Single Cheeseburger 1 2.44 Contin \$F\$13 Subway Footlong Cold Cut Combo 1 0 Contin \$G\$13 Chik-Fil-A Sandwich 1 0 Contin Constraints Cell Name Cell Value Formula Status Slack \$H\$6 Calorie constraint RHS 1532.28 \$H\$6>=\$J\$6 Not Binding 32.28 \$H\$7 Protein constraint (grams) RHS 100 \$H\$7>=\$J\$7 Binding 0 \$H\$8 Cholesterol constraint (mil igrams) RHS 267.51 \$H\$8>=\$J\$8 Not Binding 117.51 \$H\$9 Fat constraint (minimum) (grams) RHS 80 \$H\$9>=\$J\$9
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 01/30/2012 for the course MGT 2251 taught by Professor Chang during the Fall '08 term at Georgia Tech.

Ask a homework question - tutors are online