Exam 7: Goal Programming and Multiple Objective Optimization

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

Suppose that X1 equals 4. What are the values for d1+ and d1-in the following constraint? X1 + d1-d1+ = 8

Free
(Multiple Choice)
4.8/5
(37)
Correct Answer:
Verified

A

The di+ variable indicates the amount by which each goal's target value is

Free
(Multiple Choice)
4.8/5
(39)
Correct Answer:
Verified

C

Exhibit 7.2 The following questions are based on the problem below. An investor has $150,000 to invest in investments A and B. Investment A requires a $10,000 minimum investment, pays a return of 12% and has a risk factor of .50. Investment B requires a $15,000 minimum investment, pays a return of 10% and has a risk factor of .20. The investor wants to maximize the return while minimizing the risk of the portfolio. The following multi-objective linear programming (MOLP) has been solved in Excel. A 1 Problem data 2 Expected retun 12\% 10\% 3 Risk rating 0.50 0.20 4 5 Variables Tatal 6 Amount invested 0 0 0 7 Minimum required \ 10,000 \ 15,000 \ 150,000 8 9 Objectives: 10 Average return 0 11 Average risk 0 -Refer to Exhibit 7.2. What formula goes in cell B10?

Free
(Multiple Choice)
4.7/5
(24)
Correct Answer:
Verified

A

Exhibit 7.4 The following questions are based on the problem below. Robert Gardner runs a small, local-only delivery service. His fleet consists of three smaller panel trucks. He recently accepted a contract to deliver 12 shipping boxes of goods for delivery to 12 different customers. The box weights are: 210, 160, 320, 90, 110, 70, 410, 260, 170, 240, 80 and 180 for boxes 1 through 12, respectively. Since each truck differs each truck has different load capacities as given below: Truck Weight Capacity Box Capacity Cast per pound 1 800 pounds 5 \ 0.34 2 900 pounds 6 \ 0.42 3 700 pounds 4 \ 0.25 Robert would like each truck equally loaded, both in terms of number of boxes and in terms of total weight, while minimizing his shipping costs. Assume a cost of $50 per item for trucks carrying extra boxes and $0.10 per pound cost for trucks carrying less weight. The following integer goal programming formulation applies to his problem. Y1 = weight loaded in truck 1; Y2 = weight loaded in truck 2; Y3 = weight loaded in truck 3; Xi,j = 0 if truck i not loaded with box j; 1 if truck i loaded with box j.  Exhibit 7.4 The following questions are based on the problem below. Robert Gardner runs a small, local-only delivery service. His fleet consists of three smaller panel trucks. He recently accepted a contract to deliver 12 shipping boxes of goods for delivery to 12 different customers. The box weights are: 210, 160, 320, 90, 110, 70, 410, 260, 170, 240, 80 and 180 for boxes 1 through 12, respectively. Since each truck differs each truck has different load capacities as given below:   \begin{array} { c c c c }  \text { Truck } & \text { Weight Capacity } & \text { Box Capacity } & \text { Cast per pound } \\ \hline 1 & \text { 800 pounds } & 5 & \$ 0.34 \\ 2 & 900 \text { pounds } & 6 & \$ 0.42 \\ 3 & 700 \text { pounds } & 4 & \$ 0.25 \end{array}  Robert would like each truck equally loaded, both in terms of number of boxes and in terms of total weight, while minimizing his shipping costs. Assume a cost of $50 per item for trucks carrying extra boxes and $0.10 per pound cost for trucks carrying less weight. The following integer goal programming formulation applies to his problem. Y<sub>1</sub> = weight loaded in truck 1; Y<sub>2</sub> = weight loaded in truck 2; Y<sub>3</sub> = weight loaded in truck 3; X<sub>i,j</sub> = 0 if truck i not loaded with box j; 1 if truck i loaded with box j.    Given the following spreadsheet solution of this integer goal programming formulation, answer the following questions.    -Refer to Exhibit 7.4. What formulas should go in cell E26 of the spreadsheet? Given the following spreadsheet solution of this integer goal programming formulation, answer the following questions.  Exhibit 7.4 The following questions are based on the problem below. Robert Gardner runs a small, local-only delivery service. His fleet consists of three smaller panel trucks. He recently accepted a contract to deliver 12 shipping boxes of goods for delivery to 12 different customers. The box weights are: 210, 160, 320, 90, 110, 70, 410, 260, 170, 240, 80 and 180 for boxes 1 through 12, respectively. Since each truck differs each truck has different load capacities as given below:   \begin{array} { c c c c }  \text { Truck } & \text { Weight Capacity } & \text { Box Capacity } & \text { Cast per pound } \\ \hline 1 & \text { 800 pounds } & 5 & \$ 0.34 \\ 2 & 900 \text { pounds } & 6 & \$ 0.42 \\ 3 & 700 \text { pounds } & 4 & \$ 0.25 \end{array}  Robert would like each truck equally loaded, both in terms of number of boxes and in terms of total weight, while minimizing his shipping costs. Assume a cost of $50 per item for trucks carrying extra boxes and $0.10 per pound cost for trucks carrying less weight. The following integer goal programming formulation applies to his problem. Y<sub>1</sub> = weight loaded in truck 1; Y<sub>2</sub> = weight loaded in truck 2; Y<sub>3</sub> = weight loaded in truck 3; X<sub>i,j</sub> = 0 if truck i not loaded with box j; 1 if truck i loaded with box j.    Given the following spreadsheet solution of this integer goal programming formulation, answer the following questions.    -Refer to Exhibit 7.4. What formulas should go in cell E26 of the spreadsheet? -Refer to Exhibit 7.4. What formulas should go in cell E26 of the spreadsheet?

(Essay)
4.8/5
(41)

An optimization technique useful for solving problems with more than one objective function is

(Multiple Choice)
5.0/5
(26)

Decision-making problems which can be stated as a collection of desired objectives are known as what type of problem?

(Multiple Choice)
5.0/5
(42)

The decision maker has expressed concern with Goal 1, budget, achievement. He indicated that future candidate solutions should stay under budget. How can you modify your goal programming model to accommodate this change?

(Multiple Choice)
4.8/5
(31)

Consider the following MOLP: MAX: 3+4 MAX: 2+ Subject to: 6+13\leq78 12+9\leq108 8+10\leq80 \geq0 Graph the feasible region for this problem and compute the value of each objective at each extreme point. What are the solutions to each of the component LPs?  Consider the following MOLP:   \begin{array}{ll} \text { MAX: } & 3 \mathrm{X}_{1}+4 \mathrm{X}_{2} \\ \text { MAX: } & 2 \mathrm{X}_{1}+\mathrm{X}_{2} \\ \text { Subject to: } & 6 \mathrm{X}_{1}+13 \mathrm{X}_{2} \leq 78 \\ & 12 \mathrm{X}_{1}+9 \mathrm{X}_{2} \leq 108 \\ & 8 \mathrm{X}_{1}+10 \mathrm{X}_{2} \leq 80 \\ & \mathrm{X}_{1} \mathrm{X}_{2} \geq 0 \end{array}   Graph the feasible region for this problem and compute the value of each objective at each extreme point. What are the solutions to each of the component LPs?

(Essay)
5.0/5
(34)

The RHS value of a goal constraint is referred to as the

(Multiple Choice)
4.9/5
(40)

MINIMAX solutions to multi-objective linear programming (MOLP) problems are

(Multiple Choice)
4.8/5
(37)

Suppose that the first goal in a GP problem is to make 3 X1 + 4 X2 approximately equal to 36. Using the deviational variables d1-and d1+, the following constraint can be used to express this goal. 3 X1 + 4 X2 + d1- - d1+ = 36 If we obtain a solution where X1 = 6 and X2 = 2, what values do the deviational variables assume?

(Multiple Choice)
4.9/5
(35)

An investor wants to invest $50,000 in two mutual funds, A and B. The rates of return, risks and minimum investment requirements for each fund are: Fund Rate of return Risk Minumum investment 12\% 0.5 \ 20,000 9\% 0.3 \ 10.000 Note that a low Risk rating means a less risky investment. The investor can invest to maximize the expected rate of return or minimize risk. Any money beyond the minimum investment requirements can be invested in either fund. The following is the MOLP formulation for this problem: Let = dollars in investment = dollars in investment MAX: MiN: 0.12/50000+0.09/50000 Subject ta: 0.5/50000+0.3/50000 +=50000 \geq20000 \geq10000 \geq0 far all i The solution for the second LP is (X1, X2) = (20,000, 30,000). What formulas should go in cells B2:D11 of the spreadsheet? NOTE: Formulas are not required in all of these cells. A 1 Problem data 2 Expected retum 12\% 9\% 3 Risk rating 0.50 0.20 4 5 Variables Total 6 Amount invested \ 20,000 \ 30,000 \ 50,000 7 Minimum required \ 20,000 \ 10,000 \ 50,000 8 9 Objectives: 10 Average return 10.2\% 11 Average risk 0.32

(Essay)
4.9/5
(39)

A company needs to supply customers in 3 cities from its 3 warehouses. The supplies, demands and shipping costs are shown below. Destination Warehouse 1 2 3 Supply 1 34 60 36 400 2 70 40 50 300 3 56 40 32 200 Demand 500 300 200 The company has identified the following goals: Goal 1: The company would like to come as close as possible to satisfying its customers demand. Goal 2:It would also like to ensure that the cost is approximately $290.000 \$ 290.000 Formulate a goal programming model of this problem.

(Essay)
4.8/5
(43)

Exhibit 7.1 The following questions are based on the problem below. A company wants to advertise on TV and radio. The company wants to produce about 6 TV ads and 12 radio ads. Each TV ad costs $20,000 and is viewed by 10 million people. Radio ads cost $10,000 and are heard by 7 million people. The company wants to reach about 140 million people, and spend about $200,000 for all the ads. The problem has been set up in the following Excel spreadsheet. Exhibit 7.1 The following questions are based on the problem below. A company wants to advertise on TV and radio. The company wants to produce about 6 TV ads and 12 radio ads. Each TV ad costs $20,000 and is viewed by 10 million people. Radio ads cost $10,000 and are heard by 7 million people. The company wants to reach about 140 million people, and spend about $200,000 for all the ads. The problem has been set up in the following Excel spreadsheet.    -Refer to Exhibit 7.1. What formula goes in cell B9? -Refer to Exhibit 7.1. What formula goes in cell B9?

(Multiple Choice)
4.8/5
(27)

A manager wants to ensure that he does not exceed his budget by more than $1000 in a goal programming problem. If the budget constraint is the third constraint in the goal programming problem which of the following formulas will best ensure that the manager's objective is met?

(Multiple Choice)
4.8/5
(41)

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 1 2 Available resaurces Labor (hr/unit) 3 2 150 Material (aunces/unit) 1 2 200 Profit( /unit) 7 6 Management has developed the following set of goals Goal 1: Produce approximately 40 urits of product 1 Goal 2: Produce approxinately 70 urits of product 2 Goal 3: Achieve a profit aver $400. Goal 4: Consume less than 150 hours of labor Goal 5:Consume lesse than 200 \text ounces of material Based on the following GP formulation of the problem, and the associated optimal solution, what formulas should go in cells D6:F6, B9:F9, and B16 of the following Excel spreadsheet? NOTE: Formulas are not required in all of these cells.  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.   \begin{array} { l l l c }  \text { Product } & 1 & 2 & \text { Available resaurces } \\ \hline \text { Labor (hr/unit) } & 3 & 2 & 150 \\ \text { Material (aunces/unit) } & 1 & 2 & 200 \\ \text { Profit( /unit) } & 7 & 6 & \end{array}  Management has developed the following set of goals  Goal 1: Produce approximately 40 urits of product 1 Goal 2: Produce approxinately 70 urits of product 2 Goal 3: Achieve a profit aver $400. Goal 4: Consume less than 150 hours of labor Goal 5:Consume lesse than 200 \text ounces of material   Based on the following GP formulation of the problem, and the associated optimal solution, what formulas should go in cells D6:F6, B9:F9, and B16 of the following Excel spreadsheet? NOTE: Formulas are not required in all of these cells.     \begin{array}{|c|l|c|c|c|c|c|}  \hline & {\text { A }} & \text { B } & \text { C } & \text { D } & \text { E } & \text { F } \\ \hline 1 & \text { Problem Data } & \mathrm{A} & \mathrm{B} & & & \\ \hline 2 & \text { Labor } & 3 & 2 & & & \\ \hline 3 & \text { Material } & 1 & 2 & & & \\ \hline 4 & \text { Profit } & 7 & 6 & & & \\ \hline 5 & \text { Goal Constraints } & \mathrm{A} & \mathrm{B} & \text { Labor } & \text { Material } & \text { Profit } \\ \hline 6 & \text { Actual Amount } & 4 & 69 & 150 & 142 & 442 \\ \hline 7 & + \text { Under } & 36 & 1 & 0 & 58 & 0 \\ \hline 8 & - \text { Over } & 0 & 0 & 0 & 0 & 42 \\ \hline 9 & =\text { Goal } & 40 & 70 & 150 & 200 & 400 \\ \hline 10 & \text { Target Value } & 40 & 70 & 150 & 200 & 400 \\ \hline 11 & & & & & & \\ \hline 12 & \text { Weights } & & & & & \\ \hline 13 & \text { Under } & 1 & 1 & 0 & 0 & 1 \\ \hline 14 & \text { Over } & 1 & 1 & 1 & 1 & 0 \\ \hline 15 & & & & & & \\ \hline 16 & \text { Objective } & 37 & & & & \\ \hline \end{array}   A B C D E F 1 Problem Data 2 Labor 3 2 3 Material 1 2 4 Profit 7 6 5 Goal Constraints Labor Material Profit 6 Actual Amount 4 69 150 142 442 7 + Under 36 1 0 58 0 8 - Over 0 0 0 0 42 9 = Goal 40 70 150 200 400 10 Target Value 40 70 150 200 400 11 12 Weights 13 Under 1 1 0 0 1 14 Over 1 1 1 1 0 15 16 Objective 37

(Essay)
4.9/5
(37)

An investor wants to invest $50,000 in two mutual funds, A and B. The rates of return, risks and minimum investment requirements for each fund are: Fund Rate of return Risk Minimum investment 12\% 0.5 \ 20,000 9\% 0.3 \ 10.000 Note that a low Risk rating means a less risky investment. The investor can invest to maximize the expected rate of return or minimize risk. Any money beyond the minimum investment requirements can be invested in either fund. Formulate the MOLP for this investor.

(Essay)
4.9/5
(32)

Exhibit 7.1 The following questions are based on the problem below. A company wants to advertise on TV and radio. The company wants to produce about 6 TV ads and 12 radio ads. Each TV ad costs $20,000 and is viewed by 10 million people. Radio ads cost $10,000 and are heard by 7 million people. The company wants to reach about 140 million people, and spend about $200,000 for all the ads. The problem has been set up in the following Excel spreadsheet. Exhibit 7.1 The following questions are based on the problem below. A company wants to advertise on TV and radio. The company wants to produce about 6 TV ads and 12 radio ads. Each TV ad costs $20,000 and is viewed by 10 million people. Radio ads cost $10,000 and are heard by 7 million people. The company wants to reach about 140 million people, and spend about $200,000 for all the ads. The problem has been set up in the following Excel spreadsheet.    -Refer to Exhibit 7.1. Which cell(s) is(are) the objective cell(s) in this model? -Refer to Exhibit 7.1. Which cell(s) is(are) the objective cell(s) in this model?

(Multiple Choice)
4.7/5
(33)

Given the following goal constraints 5 X1 + 6 X2 + 7 X3 + d1 d1+ = 87 3 X1 + X2 + 4 X3 + d2 d2+ = 37 7 X1 + 3 X2 + 2 X3 + d3 d3+ = 72 and solution (X1, X2, X3) = (7, 2, 5), what values do the deviational variables assume?

(Essay)
4.7/5
(38)

Exhibit 7.1 The following questions are based on the problem below. A company wants to advertise on TV and radio. The company wants to produce about 6 TV ads and 12 radio ads. Each TV ad costs $20,000 and is viewed by 10 million people. Radio ads cost $10,000 and are heard by 7 million people. The company wants to reach about 140 million people, and spend about $200,000 for all the ads. The problem has been set up in the following Excel spreadsheet. Exhibit 7.1 The following questions are based on the problem below. A company wants to advertise on TV and radio. The company wants to produce about 6 TV ads and 12 radio ads. Each TV ad costs $20,000 and is viewed by 10 million people. Radio ads cost $10,000 and are heard by 7 million people. The company wants to reach about 140 million people, and spend about $200,000 for all the ads. The problem has been set up in the following Excel spreadsheet.    -Refer to Exhibit 7.1. Which cells are the variable cells in this model? -Refer to Exhibit 7.1. Which cells are the variable cells in this model?

(Multiple Choice)
4.9/5
(31)
Showing 1 - 20 of 59
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)