Exam 7: Goal Programming and Multiple Objective Optimization
Exam 1: Introduction to Modeling and Decision Analysis52 Questions
Exam 2: Introduction to Optimization and Linear Programming62 Questions
Exam 3: Modeling and Solving Lp Problems in a Spreadsheet88 Questions
Exam 4: Sensitivity Analysis and the Simplex Method72 Questions
Exam 5: Network Modeling72 Questions
Exam 6: Integer Linear Programming72 Questions
Exam 7: Goal Programming and Multiple Objective Optimization59 Questions
Exam 8: Nonlinear Programming and Evolutionary Optimization68 Questions
Exam 9: Regression Analysis76 Questions
Exam 10: Discriminant Analysis57 Questions
Exam 11: Time Series Forecasting111 Questions
Exam 12: Introduction to Simulation Using Risk Solver Platform65 Questions
Exam 13: Queuing Theory79 Questions
Exam 14: Decision Analysis102 Questions
Exam 15: Project Management Online61 Questions
Select questions type
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:
A
The di+ variable indicates the amount by which each goal's target value is
Free
(Multiple Choice)
4.8/5
(39)
Correct Answer:
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:
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.
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?


(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?

(Essay)
5.0/5
(34)
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
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.
-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 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.
-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.
-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
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)