A company makes 2 products, A and B, from 2 resources. The products have the following...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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? О А. =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 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? О А. =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 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? О А. =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 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? О А. =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
Expert Answer:
Answer rating: 100% (QA)
The detailed answer for the above question is provided below Answer Goal Programming For... View the full answer
Related Book For
Posted Date:
Students also viewed these programming questions
-
On January 1, Year 1, Twisted Pretzel, Inc., purchased equipment for $32,000 with an estimated useful life of 8 years and $0 salvage value. On January 1, Year 5, Twisted Pretzel, sold the equipment...
-
Fez Corporation, a foreign to the US corporation, bought inventory in the United States and sold the inventory to customers in Morocco. Gross profit from the sale of the inventory was $200,000. Title...
-
Last year Maya's salary was $42,302. This year she received a promotion and her salary increased to $48,589. What is the percentage increase in her salary?
-
What characteristics do you think Jamie Oliver has that have helped make his various enterprises a success?
-
Which has the greater number of protons: U-235 or U-238? Which has the greater number of neutrons?
-
Distinguish leading stock market indices and their types.
-
Draw up a consolidated balance sheet as at 31 December \(19 \times 9\) from the following information. Investment in subsidiary: 30,000 shares bought 31.12.19X8 Fixed assets Current assets Share...
-
Cederholm Company has gathered the following information. Units in beginning work in process ............ _0_ Units started into production ............... 36,000 Units in ending work in process...
-
Casey Inc. uses the accrual method of accounting for financialreporting purposes and the instalment method of accounting forincome tax purposes. Instalment income of $930,000 will becollected in th 2...
-
As part of Dubai Development Plan, Roads and Transport Authority (RTA) plans to connect malls and recreational places through public transport. It has identified 10 such places whose locations are...
-
Simpson Ltd ('Simpson') is a company which manufactures printed circuit boards for use in electrical equipment. The company has a storeroom in which all raw materials and finished goods are held....
-
Simulate random numbers from log normal distribution. X 1 ~log normal ( 1 0 , 3 ) with sample size, n = 3 0 . X 2 ~log normal ( 1 0 , 3 ) with sample size, n = 1 0 0 . X 3 ~log normal ( 1 0 , 3 )...
-
In the beginning of October, an investor has a stock portfolio worth $3,460,000. The content of the portfolio replicates very closely that of the Shanghai SE A share index. The investor wants to...
-
Suppose you are offered the opportunity to invest with a very popular and active-trading hedge fund. Before investing with that manager, what factors might you consider before exploiting this...
-
Part A A 300-kg chandelier is suspended from vertical steel cable. The cable is 5.7 m long. Assume a safety factor of 7.5. The elastic modulus for steel is 2.0 10 N/m, and tensile strength for steel...
-
Identify the four primary layers in the functional view of OS X ? What is Darwin ? Identify Darwin's two basic layers ? Explain how OS/X thread manages memory ? What is QuickTime ? What does...
-
Assume the following: Beggining finished goods inventory $10,000 Ending finished goods inventory $9,000 Cost of goods manufactured $52,000 What is the unadjusted cost of goods sold
-
In July 2013, cnet.com listed the battery life (in hours) and luminous intensity (i. e., screen brightness, in cd/m2) for a sample of tablet computers. We want to know if screen brightness is...
-
Data: The Eastern Division of Countryside Communications plc assembles a single product, the Beta. The Eastern Division has a fixed price contract with the supplier of the materials used in the Beta....
-
(a) The total costs incurred at various output levels, for a process operation in a factory, have been measured as follows: Output (units) Total cost () 11 500 ............ 102 476 12 000...
-
A ticket agent has an arrangement with a concert hall that holds pop concerts on 60 nights a year whereby he receives discounts as follows per concert: For purchase of: He receives a discount of: 200...
-
\(\frac{-4}{5-\sqrt{10}}\) Rationalize the denominator of the fraction, and then simplify the fraction.
-
\(\frac{6}{5+\sqrt{7}}\) Rationalize the denominator of the fraction, and then simplify the fraction.
-
\(\frac{4}{1+\sqrt{3}}\) Rationalize the denominator of the fraction, and then simplify the fraction.
Study smarter with the SolutionInn App