hw1solexcel - 3.4-9 Grams of ingredient per serving Steak...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 3.4-9 Grams of ingredient per serving Steak Potatoes 5 15 20 5 15 2 $4 $2 S 1.27 0 $10.91 P 2.91 0 Ingredient Carbohydrates Protein Fat Cost per serving Decision X At least Target: Min C = 4S+2P = Daily Req. >= 50 >=40 <=60 50 40 60 3.4-12 Unit Shipping Cost Customer 2 Customer 3 800 700 900 600 200 400 From/ to Factory 1 Factory 2 Order Size Customer 1 600 400 300 Output 400 500 Decision X = number of units shipped from Factory i to Customer j From /to Factory 1 Factory 2 Xij at least >= Customer 1 0 300 0 540000 Customer 2 Customer 3 200 200 0 200 Min C = 600X11+800X12+700X13+400X21+900X22+600X23 = 3.4-14 Property % of tin % of zinc % of lead Cost($/lb) 1 60 10 30 77 Alloy 2 25 15 60 70 3 45 45 10 88 4 20 50 30 84 5 REQ. amount 50 40 40 35 10 25 94 Decision X = amount of Ally I used X1 X2 X3 At least >=0 0.04 0.28 Min C= 77X1+70X2+88X3+84X4+94X5 = X4 0.67 0 82.43 X5 0 total 1 3.4-17 Food item Bread Peanut butter Strawberry jelly Graham cracker Milk juice Calories from Fat Total Calories Vitamin C (mg) Protein (g) 10 70 0 3 75 100 0 4 0 50 3 0 20 60 0 1 70 150 2 8 0 100 120 1 Decision variable B P S G M J Constraints: Total calories Calories from fat Vitamin C Protein at least 1 cup of liquid 2 0.57 0.29 1.04 0.52 0.48 400 120 60 13.95 1 Min C =5B+4P+7S+8G+15M+35J = 47.31 Cost ($) 5 4 7 8 15 35 ...
View Full Document

Page1 / 5

hw1solexcel - 3.4-9 Grams of ingredient per serving Steak...

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