A company makes 2 products, A and B, from 2 resources. The products have the following resource requirements and produce the accompanying profits. The available quantity of resources is also shown in the table. Product Labor (hr/unit) Material (ounces/unit) Profit (S/unit) Let X1 Number of product A X2 = Number of product B Management has developed the following set of goals: Goal 1: Produce approximately 40 units of product A. Produce approximately 70 units of product B. Goal 2: Goal 3: Achieve a profit over $400. Goal 4: Consume less than 150 hours of labor. Goal 5: Consume less than 200 ounces of material. The GP (Goal Programming) formulation of the problem and the associated spreadsheet are given as follows: MIN: Subject to: 11 2 3 4 S 6 7 8 9 10 11 12 13 14 X1+d1-d1=40 X2+d2-d2=70 di+d1 +d2+d2 +d3 +d4+ +d5t B A 3 2 1 2 7 6 7X1+6X2+d3"-d3=400 3 X1 +2X2 +d4-d4-150 1X1+2 X2+d5-d5=200 X, d, di 20 for all i A Problem data Labor Material Profit Goal constraints Actual amount + Under -Over -Goal Target value Weights Under Over B A 3 1 7 A a a 0 d 40 B 2 d B d d d Available Resources 150 200 d 70 Labor a O 0 150 product A product B profit labor material Material a 0 0 200 Profit d of 400 What formula goes in cell C9 of the above spreadsheet? . =C6+C7+C8 O B. -C6-C7+C8 OC. =C6+C7-C8 O D. = C10-C8 Question 15 What formula goes in cell F6 of the above spreadsheet? . =B4C4+B6 C6 O B. = SUMPRODUCT(B4:C4,B6:C6) OC = SUMPRODUCT(B2:B4,B6:B8) O D. = SUMPRODUCT(B4:C4,B10:C10) Which cells in the above spreadsheet are the variable cells in this model? OA $B$9:$E$9 OB. $B$9:$F$9 OC $B$6:$E$8 D. $B$6:$C$6, $B$7:$E$8 OE $B$6:$C$6, $B$7:$F$8 Question 17 If the company is less concerned about not reaching the profit target, which cell value in the above spreadsheet should change and how should it change? OA F13, increase O B. F13, decrease OC F14, increase 5 pts D A company makes 2 products, A and B, from 2 resources. The products have the following resource requirements and produce the accompanying profits. The available quantity of resources is also shown in the table. Product Labor (hr/unit) Material (ounces/unit) Profit (S/unit) Let X1 Number of product A X2 = Number of product B Management has developed the following set of goals: Goal 1: Produce approximately 40 units of product A. Produce approximately 70 units of product B. Goal 2: Goal 3: Achieve a profit over $400. Goal 4: Consume less than 150 hours of labor. Goal 5: Consume less than 200 ounces of material. The GP (Goal Programming) formulation of the problem and the associated spreadsheet are given as follows: MIN: Subject to: 11 2 3 4 S 6 7 8 9 10 11 12 13 14 X1+d1-d1=40 X2+d2-d2=70 di+d1 +d2+d2+d3 +d4*+d5t B A 3 2 1 2 7 6 7X1+6X2+d3"-d3=400 3 X1 +2X2 +d4-d4-150 1X1+2 X2+d5-d5=200 X, di, dit 20 for all i A Problem data Labor Material Profit Goal constraints Actual amount + Under -Over -Goal Target value Weights Under Over B A 3 1 7 A a a 0 d 40 B 2 d B d d d Available Resources 150 200 d 70 Labor a O 0 150 product A product B profit labor material Material a 0 0 200 Profit d of 400 What formula goes in cell C9 of the above spreadsheet? . =C6+C7+C8 O B. -C6-C7+C8 OC. =C6+C7-C8 O D. = C10-C8 Question 15 What formula goes in cell F6 of the above spreadsheet? . =B4 C4+B6 C6 O B. = SUMPRODUCT(B4:C4,B6:C6) OC = SUMPRODUCT(B2:B4,B6:B8) O D. = SUMPRODUCT(B4:C4,B10:C10) Which cells in the above spreadsheet are the variable cells in this model? OA $B$9:$E$9 OB. $B$9:$F$9 OC $B$6:$E$8 D. $B$6:$C$6, $B$7:$E$8 OE $B$6:$C$6, $B$7:$F$8 Question 17 If the company is less concerned about not reaching the profit target, which cell value in the above spreadsheet should change and how should it change? OA F13, increase O B. F13, decrease OC F14, increase 5 pts D A company makes 2 products, A and B, from 2 resources. The products have the following resource requirements and produce the accompanying profits. The available quantity of resources is also shown in the table. Product Labor (hr./unit) Material (ounces/unit) Profit (S/unit) Let X1 Number of product A X2= Number of product B Management has developed the following set of goals: Goal 1: Produce approximately 40 units of product A. Produce approximately 70 units of product B. Goal 2: Goal 3: Achieve a profit over $400. Goal 4: Consume less than 150 hours of labor. Goal 5: Consume less than 200 ounces of material. The GP (Goal Programming) formulation of the problem and the associated spreadsheet are given as follows: MIN: Subject to: 11 2 3 4 S 6 7 8 9 10 11 12 13 14 X1+d1-d1=40 X2+d2-d2=70 di+d1 +d2+d2+d3 +d4*+d5t B A 3 2 1 2 7 6 7 X1 +6X2+d3"-d3=400 3 X1 +2X2 +d4-d4-150 1X1+2 X2+d5-d5=200 X, di, di* 20 for all i A Problem data Labor Material Profit Goal constraints Actual amount + Under -Over -Goal Target value Weights Under Over B A 3 1 7 A a a 0 d 40 B 2 d B d d d Available Resources 150 200 d 70 Labor a O 0 150 product A product B profit labor material Material a 0 0 200 Profit d of 400 What formula goes in cell C9 of the above spreadsheet? . =C6+C7+C8 O B. -C6-C7+C8 OC. =C6+C7-C8 O D. = C10-C8 Question 15 What formula goes in cell F6 of the above spreadsheet? . =B4C4+B6 C6 O B. = SUMPRODUCT(B4:C4,B6:C6) OC = SUMPRODUCT(B2:B4,B6:B8) O D. = SUMPRODUCT(B4:C4,B10:C10) Which cells in the above spreadsheet are the variable cells in this model? OA $B$9:$E$9 OB. $B$9:$F$9 OC $B$6:$E$8 D. $B$6:$C$6, $B$7:$E$8 OE $B$6:$C$6, $B$7:$F$8 Question 17 If the company is less concerned about not reaching the profit target, which cell value in the above spreadsheet should change and how should it change? OA F13, increase O B. F13, decrease OC F14, increase 5 pts D