MGT2251_Quiz6_092911

MGT2251_Quiz6_092911 - Last Name, First Name: T-Square ID...

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

View Full Document Right Arrow Icon
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
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.
Ask a homework question - tutors are online