Deck 6: Integer Linear Programming

ملء الشاشة (f)
exit full mode
سؤال
In the B & B algorithm,B & B stands for

A)Brooks and Baker
B)Best Bound
C)Best Branch
D)Branch and Bound
استخدم زر المسافة أو
up arrow
down arrow
لقلب البطاقة.
سؤال
Which of the following is not a benefit of using binary variables?

A)With only 2 values,Solver can work faster.
B)Binary variables are useful in selection problems.
C)Binary variables can replace some IF)conditions.
D)Binary variables can enforce logical conditions.
سؤال
One approach to solving integer programming problems is to ignore the integrality conditions and solve the problem with continuous decision variables.This is referred to as

A)quickest solution method.
B)LP satisficing.
C)LP relaxation.
D)LP approximation.
سؤال
The LP relaxation of an ILP problem

A)always encompasses all the feasible integer solutions to the original ILP problem.
B)encompasses at least 90% of the feasible integer solutions to the original ILP problem.
C)encompasses different set of feasible integer solutions to the original ILP problem.
D)will not contain the feasible integer solutions to the original ILP problem.
سؤال
Variables,which are not required to assume strictly integer values are referred to as

A)strictly non-integer.
B)continuous.
C)discrete.
D)infinite.
سؤال
What does the Analytic Solver Platform default integer tolerance factor of 0 accomplish?

A)Stops B & B after 100% of all solutions are examined.
B)Stops B & B when any feasible ILP solution is 0% from the current ILP solution.
C)Stops B & B when the true optimal integer solution has been found.
D)Stops B & B when no more than 0% of the changing cells have integer values.
سؤال
Which of the following are potential pitfalls of using a non-zero integer tolerance factor in the Analytic Solver Platform?

A)No assurance the returned solution is optimal.
B)No assurance the returned solution is integer.
C)The true optimal solution may be worse than the returned solution.
D)There are no pitfalls to consider since the Solver will obtain solutions quicker.
سؤال
For maximization problems,the optimal objective function value to the LP relaxation provides what for the optimal objective function value of the ILP problem?

A)An upper bound.
B)A lower bound.
C)An alternative optimal solution.
D)An additional constraint for the ILP problem.
سؤال
How is an LP problem changed into an ILP problem?

A)by adding constraints that the decision variables be non-negative.
B)by adding integrality conditions.
C)by adding discontinuity constraints.
D)by making the RHS values integer.
سؤال
How are general integrality requirements indicated in the Analytic Solver Platform?

A)Specifying the INT option for the appropriate changing cells.
B)Specifying the INT option for the constraint rows.
C)Adding additional RHS values to constraints.
D)Choosing the BIN setting in the Value field in the Solver Parameters dialog box.
سؤال
An ILP problem has 5 binary decision variables.How many possible integer solutions are there to this problem?

A)5
B)10
C)25
D)32
سؤال
For minimization problems,the optimal objective function value to the LP relaxation provides what for the optimal objective function value of the ILP problem?

A)An upper bound.
B)A lower bound.
C)An alternative optimal solution.
D)An additional constraint for the ILP problem.
سؤال
How is the integer tolerance factor set in the Analytic Solver Platform ASP)?

A)By adding a constraint for the decision variables who's RHS is the desired suboptimality level.
B)By choosing the optimal option in the ASP Options dialog box.
C)By choosing the 100% Precision field in the ASP Options dialog box.
D)By entering the desired tolerance factor value in the Integer Tolerance field of ASP.
سؤال
A company wants to select no more than 2 projects from a set of 4 possible projects.Which of the following constraints ensures that no more than 2 will be selected?

A)X1 + X2 + X3 + X4 = 2
B)X1 + X2 + X3 + X4 ≤ 2
C)X1 + X2 + X3 + X4 ≥ 2
D)X1 + X2 + X3 + X4 ≥ 0
سؤال
What are binary integer variables?

A)Variables with any two values,a and b.
B)Variables with values 0 and 1.
C)Variables whose sum of digits is 2.
D)Variables with values between 0 and 1.
سؤال
The objective function value for the ILP problem can never

A)be as good as the optimal solution to its LP relaxation.
B)be as poor as the optimal solution to its LP relaxation.
C)be worse than the optimal solution to its LP relaxation.
D)be better than the optimal solution to its LP relaxation.
سؤال
An integrality condition indicates that some or all)of the

A)RHS values for constraints must be integer
B)objective function coefficients must be integer
C)constraint coefficients must be integer
D)decision variables must be integer
سؤال
How are binary variables specified in the Analytic Solver Platform ASP)?

A)By replacing RHS values in constraints with 0 or 1.
B)By specifying changing cells as INTEGER and as non-negative.
C)By specifying changing cells as BINARY in the Variable Type/Bound area of ASP.
D)By selecting Assume Binary Model in the ASP Options dialog box.
سؤال
Consider the constraint
X3 + X4 + X5 + X6 + X7 ≥ 27
Representing Air Express' Monday minimum worker requirement.Why was a "≥" used versus an "="?

A)The "≥" is needed to accommodate workers held over from Sunday.
B)Solver only accepts "≥" constraints.
C)The "≥" is less restrictive.
D)The "=" will always produce an infeasible constraint.
سؤال
The B & B algorithm solves ILP problems

A)by solving for each variable separately.
B)by solving for the integer variables first.
C)by solving a series of LP problems.
D)by solving smaller ILP problems.
سؤال
A company is developing its weekly production plan.The company produces two products,A and B,which are processed in two departments.Setting up each batch of A requires $60 of labor while setting up a batch of B costs $80.Each unit of A generates a profit of $17 while a unit of B earns a profit of $21.The company can sell all the units it produces.The data for the problem are summarized below.
Hours required by
 Operation  A  B  Hours  Cutting 3448 Welding 2136\begin{array} { r c c c } \text { Operation } & \text { A } & \text { B } & \text { Hours } \\\hline \text { Cutting } & 3 & 4 & 48 \\\text { Welding } & 2 & 1 & 36\end{array}
The decision variables are defined as
Xi = the amount of product i produced Yi = 1 if Xi > 0 and 0 if Xi = 0
Which of the following constraints creates the link between setting up to produce A's and making some A's for this problem?

A)X1 ? 16Y1 b.X1 ? Y1 = 0
B)X1 ? 18Y1 > 0
C)= ifX1 > 0,Y1 = 1,Y1 = 0)
سؤال
A company will be able to obtain a quantity discount on component parts for its three products,X1,X2 and X3 if it produces beyond certain limits.To get the X1 discount it must produce more than 50 X1's.It must produce more than 60 X2's for the X2 discount and 70 X3's for the X3 discount.How many decision variables are required in the formulation of this problem?

A)3
B)6
C)9
D)12
سؤال
A company will be able to obtain a quantity discount on component parts for its three products,X1,X2 and X3 if it produces beyond certain limits.To get the X1 discount it must produce more than 50 X1's.It must produce more than 60 X2's for the X2 discount and 70 X3's for the X3 discount.Which of the following pair of constraints enforces the quantity discount relationship on X3?

A)X31 ≤ M3Y3,X32 ≥ 50Y3 b.X31 ≤ M3Y3,X31 ≥ 50
C)X32 ≥ 1/50)X31,X31 ≤ 50
D)X32 ≤ M3Y3,X31 ≥ 50Y3
سؤال
A manufacturing company has costs associated with production preparation and with per unit production.The per unit production costs are referred to as

A)decision variables.
B)production cost constraint coefficients.
C)variable costs.
D)marginal costs.
سؤال
A company will be able to obtain a quantity discount on component parts for its three products,X1,X2 and X3 if it produces beyond certain limits.To get the X1 discount it must produce more than 50 X1's.It must produce more than 60 X2's for the X2 discount and 70 X3's for the X3 discount.How many binary variables are required in the formulation of this problem?

A)3
B)6
C)9
D)12
سؤال
If a company produces Product 1,then it must produce at least 150 units of Product 1.Which of the following constraints enforces this condition?

A)X1 ≤ 150Y1
B)X1 − 150Y1 ≥ 0
C)X1Y1 ≤ 150
D)X1 ≥ 150 + Y1
سؤال
A company wants to select 1 project from a set of 4 possible projects.Which of the following constraints ensures that only 1 will be selected?

A)X1 + X2 + X3 + X4 = 1
B)X1 + X2 + X3 + X4 ≤ 1
C)X1 + X2 + X3 + X4 ≥ 1
D)X1 + X2 + X3 + X4 ≥ 0
سؤال
If a company selects either of Project 1 or Project 2 or both),then either Project 3 or Project 4 or both)must also be selected.Which of the following constraints enforce this condition?

A)X1 + X2 ≤ 2X3 + X4)
B)X1 + X2 ≤ X3 + X4
C)X1 − X3 = X2 − X4
D)X1 + X2 + X3 + X4 ≤ 2
سؤال
A company is developing its weekly production plan.The company produces two products,A and B,which are processed in two departments.Setting up each batch of A requires $60 of labor while setting up a batch of B costs
$80)Each unit of A generates a profit of $17 while a unit of B earns a profit of $21.The company can sell all the units it produces.The data for the problem are summarized below.
Hours required by
 Operation  A  B  Hours  Cutting 3448 Welding 2136\begin{array} { r c c c } \text { Operation } & \text { A } & \text { B } & \text { Hours } \\\hline \text { Cutting } & 3 & 4 & 48 \\\text { Welding } & 2 & 1 & 36\end{array}
The decision variables are defined as
Xi = the amount of product i produced Yi = 1 if Xi > 0 and 0 if Xi = 0
What is the objective function for this problem?

A)MAX: 17 X1 + 21 X2
B)MAX: 17 X1 + 21 X2 ? 60 Y1 ? 80 Y2
C)MIN: 17 X1 + 21 X2 ? 60 Y1 ? 80 Y2 d.MIN: 60 Y1 + 80 Y2
سؤال
The setup cost incurred in preparing a machine to produce a batch of product is an example of a

A)fixed charge.
B)random charge.
C)sunk cost.
D)variable cost.
سؤال
The branch-and-bound algorithm starts by

A)relaxing all the integrality conditions in an ILP and solving the resulting LP problem.
B)relaxing all the RHS values in an ILP and solving the resulting LP problem.
C)solving two LP problems in which X1 is set at 0 and 1 respectively.
D)determining the most likely RHS values and solving for them.
سؤال
A company is developing its weekly production plan.The company produces two products,A and B,which are processed in two departments.Setting up each batch of A requires $60 of labor while setting up a batch of B costs $80.Each unit of A generates a profit of $17 while a unit of B earns a profit of $21.The company can sell all the units it produces.The data for the problem are summarized below.
Hours required by
 Operation  A  B  Hours  Cutting 3448 Welding 2136\begin{array} { r c c c } \text { Operation } & \text { A } & \text { B } & \text { Hours } \\\hline \text { Cutting } & 3 & 4 & 48 \\\text { Welding } & 2 & 1 & 36\end{array}
What is the appropriate formula to use in cell B15 of the following Excel implementation of the ILP model for this problem?
 <strong>A company is developing its weekly production plan.The company produces two products,A and B,which are processed in two departments.Setting up each batch of A requires $60 of labor while setting up a batch of B costs $80.Each unit of A generates a profit of $17 while a unit of B earns a profit of $21.The company can sell all the units it produces.The data for the problem are summarized below. Hours required by  \begin{array} { r c c c } \text { Operation } & \text { A } & \text { B } & \text { Hours } \\ \hline \text { Cutting } & 3 & 4 & 48 \\ \text { Welding } & 2 & 1 & 36 \end{array}  What is the appropriate formula to use in cell B15 of the following Excel implementation of the ILP model for this problem?  </strong> A)=B5 ? MIN$E$11/B11,$E$11/C11)*B14 B)=B5 ? MIN$E$11/B11,$E$12/B12) C)=B5 ? $E$12/B12*B14 D)=B5 ? MIN$E$11/B11,$E$12/B12)*B14 <div style=padding-top: 35px>

A)=B5 ? MIN$E$11/B11,$E$11/C11)*B14
B)=B5 ? MIN$E$11/B11,$E$12/B12)
C)=B5 ? $E$12/B12*B14
D)=B5 ? MIN$E$11/B11,$E$12/B12)*B14
سؤال
A company is developing its weekly production plan.The company produces two products,A and B,which are processed in two departments.Setting up each batch of A requires $60 of labor while setting up a batch of B costs $80.Each unit of A generates a profit of $17 while a unit of B earns a profit of $21.The company can sell all the units it produces.The data for the problem are summarized below.
Hours required by
 Operation  A  B  Hours  Cutting 3448 Welding 2136\begin{array} { r c c c } \text { Operation } & \text { A } & \text { B } & \text { Hours } \\\hline \text { Cutting } & 3 & 4 & 48 \\\text { Welding } & 2 & 1 & 36\end{array}
The decision variables are defined as
Xi = the amount of product i produced Yi = 1 if Xi > 0 and 0 if Xi = 0
Using the approach discussed in the text,what is the appropriate value for M1 in the linking constraint for product A?

A)2
B)3
C)16
D)12
سؤال
A company is planning next month's production.It has to pay a setup cost to produce a batch of X4's so if it does produce a batch it wants to produce at least 100 units.Which of the following pairs of constraints show the relationships)between the setup variable Y4 and the production quantity variable X4?

A)X4 ≤ M4Y4,X4 ≥ 100
B)X4 ≤ M4Y4,X4 = 100 Y4 c.X4 ≤ M4Y4,X4 ≥ 100 Y4 d.X4 ≤ M4Y4,X4 ≤ 100 Y4
سؤال
If a company selects Project 1 then it must also select either Project 2 or Project 3.Which of the following constraints enforces this condition?

A)X1 − X2 − X3 ≥ 0
B)X1 + X2 − X3)≤ 0
C)X1 + X2 + X3 ≤ 2
D)X1 − X2 − X3 ≤ 0
سؤال
Any integer variable in an ILP that assumes a fractional value in the optimal solution to the relaxed LP problem can be designated

A)a diverging variable.
B)a branching variable.
C)a bifurcating variable.
D)a splitting variable.
سؤال
A production company wants to ensure that if Product 1 is produced,production of Product 1 not exceed production of Product 2.Which of the following constraints enforce this condition?

A)X1 ≥ M2Y2
B)X1 ≤ M2X2
C)X1 ≤ M1Y1,X1 ≤ Y1X2
D)X1 ≤ X2
سؤال
A wedding caterer has several wine shops from which it can order champagne.The caterer needs 100 bottles of champagne on a particular weekend for 2 weddings.The first supplier can supply either 40 bottles or 90 bottles.
The relevant decision variable is defined as
X1 = the number of bottles supplied by supplier 1
Which set of constraints reflects the fact that supplier 1 can supply only 40 or 90 bottles?

A)X1 ≤ 40 Y11,X1 ≤ 901 − Y11)
B)X1 = 40Y11 + 90Y12,Y11 + Y12 ≤ 1
C)X1 = 40Y1 + 901 − Y1),Y1 = 0 OR 1
D)X1 = 40Y11 + 90Y12,Y11 + Y12 = 1
سؤال
A company is developing its weekly production plan.The company produces two products,A and B,which are processed in two departments.Setting up each batch of A requires $60 of labor while setting up a batch of B costs $80.Each unit of A generates a profit of $17 while a unit of B earns a profit of $21.The company can sell all the units it produces.The data for the problem are summarized below.
Hours required by
 Operation  A  B  Hours  Cutting 3448 Welding 2136\begin{array} { r c c c } \text { Operation } & \text { A } & \text { B } & \text { Hours } \\\hline \text { Cutting } & 3 & 4 & 48 \\\text { Welding } & 2 & 1 & 36\end{array}
What is the appropriate formula to use in cell E8 of the following Excel implementation of the ILP model for this problem?
 <strong>A company is developing its weekly production plan.The company produces two products,A and B,which are processed in two departments.Setting up each batch of A requires $60 of labor while setting up a batch of B costs $80.Each unit of A generates a profit of $17 while a unit of B earns a profit of $21.The company can sell all the units it produces.The data for the problem are summarized below. Hours required by  \begin{array} { r c c c } \text { Operation } & \text { A } & \text { B } & \text { Hours } \\ \hline \text { Cutting } & 3 & 4 & 48 \\ \text { Welding } & 2 & 1 & 36 \end{array}  What is the appropriate formula to use in cell E8 of the following Excel implementation of the ILP model for this problem?  </strong> A)=SUMPRODUCTB5:C5,B7:C7)? SUMPRODUCTB8:C8,B14:C14) B)=SUMPRODUCTB8:C8,B14:C14)? SUMPRODUCTB5:C5,B7:C7) C)=SUMPRODUCTB5:C5,B7:C7)? B8:C8 D)=SUMPRODUCTB5:C5,B7:C7)? SUMPRODUCTB8:C8,B15:C15) <div style=padding-top: 35px>

A)=SUMPRODUCTB5:C5,B7:C7)? SUMPRODUCTB8:C8,B14:C14)
B)=SUMPRODUCTB8:C8,B14:C14)? SUMPRODUCTB5:C5,B7:C7)
C)=SUMPRODUCTB5:C5,B7:C7)? B8:C8
D)=SUMPRODUCTB5:C5,B7:C7)? SUMPRODUCTB8:C8,B15:C15)
سؤال
A company must invest in project 1 in order to invest in project 2.Which of the following constraints ensures that project 1 will be chosen if project 2 is invested in?

A)X1 + X2 = 0
B)X1 + X2 = 1
C)X1 − X2 ≥ 0
D)X1 − X2 ≤ 0
سؤال
A city wants to locate 2 new fire fighting ladder trucks to maximize the number of tall buildings which they can cover within a 3 minute response time.The city is divided into 4 zones.The fire chief wants to locate no more than one of the trucks in either Zone 1 or Zone 2.The number of tall buildings in each zone and the travel time between zones is listed below.
 To zone  No. tall buildings  Fram zone 12345010216902204560314017046510\begin{array}{c}\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\text { To zone }\\\begin{array} { c c c c c c } \text { No. tall buildings } & \text { Fram zone } & 1 & 2 & 3 & 4 \\\hline 50 & 1 & 0 & 2 & 1 & 6 \\90 & 2 & 2 & 0 & 4 & 5 \\60 & 3 & 1 & 4 & 0 & 1 \\70 & 4 & 6 & 5 & 1 & 0\end{array}\end{array}
Based on this ILP formulation of the problem what values should go in cells B5:G24 of the following Excel spreadsheet?
Let Xi = 1 if truck located in zone i,0 otherwise
 Zone  Covers these zones  With the many building 11,2,320021,214031,3,418043,4130\begin{array} { c c c } \text { Zone } & \text { Covers these zones } & \text { With the many building } \\\hline 1 & 1,2,3 & 200 \\2 & 1,2 & 140 \\3 & 1,3,4 & 180 \\4 & 3,4 & 130\end{array}
MAX: 200 X1 + 140 X2 + 180 X3 + 130 X4
Subject to: X1 + X2 + X3 + X4 = 2
X1 + X2 ? 1
Xi = 0,1
 A city wants to locate 2 new fire fighting ladder trucks to maximize the number of tall buildings which they can cover within a 3 minute response time.The city is divided into 4 zones.The fire chief wants to locate no more than one of the trucks in either Zone 1 or Zone 2.The number of tall buildings in each zone and the travel time between zones is listed below.  \begin{array}{c} \quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\text { To zone }\\ \begin{array} { c c c c c c } \text { No. tall buildings } & \text { Fram zone } & 1 & 2 & 3 & 4 \\ \hline 50 & 1 & 0 & 2 & 1 & 6 \\ 90 & 2 & 2 & 0 & 4 & 5 \\ 60 & 3 & 1 & 4 & 0 & 1 \\ 70 & 4 & 6 & 5 & 1 & 0 \end{array} \end{array}  Based on this ILP formulation of the problem what values should go in cells B5:G24 of the following Excel spreadsheet? Let X<sub>i </sub>= 1 if truck located in zone i,0 otherwise  \begin{array} { c c c } \text { Zone } & \text { Covers these zones } & \text { With the many building } \\ \hline 1 & 1,2,3 & 200 \\ 2 & 1,2 & 140 \\ 3 & 1,3,4 & 180 \\ 4 & 3,4 & 130 \end{array}  MAX: <sup>200 X</sup><sub>1 </sub><sup>+ 140 X</sup><sub>2 </sub><sup>+ 180 X</sup><sub>3 </sub><sup>+ 130 X</sup><sub>4</sub> Subject to: <sup>X</sup><sub>1 </sub><sup>+ X</sup><sub>2 </sub><sup>+ X</sup><sub>3 </sub><sup>+ X</sup><sub>4 </sub><sup>= 2</sup> X<sub>1 </sub>+ X<sub>2 </sub>? 1 X<sub>i </sub>= 0,1  <div style=padding-top: 35px>
سؤال
Exhibit 6.1
The following questions pertain to the problem,formulation,and spreadsheet implementation below.
A research director must pick a subset of research projects to fund over the next five years.He has five candidate projects,not all of which cover the entire five-year period.Although the director has limited funds in each of the next five years,he can carry over unspent research funds into the next year.Additionally,up to $30K can be carried out of the five-year planning period.The following table summarizes the projects and budget available to the research director.
Project Funds Required in $000s)Benefit
 Project 12345 in $000s)1$70$40$30$15$15$1602$82$35$20$20$10$1903$55$10$10$5$1254$69$17$15$12$8$1395$75$20$25$30$45$174\begin{array}{ccccccc}\text { Project } & 1 & 2 & 3 & 4 & 5 & \text { in } \$ 000 s) \\\hline 1 & \$ 70 & \$ 40 & \$ 30 & \$ 15 & \$ 15 & \$ 160 \\2 & \$ 82 & \$ 35 & \$ 20 & \$ 20 & \$ 10 & \$ 190 \\3 & \$ 55 & \$ 10 & \$ 10 & \$ 5 & & \$ 125 \\4 & \$ 69 & \$ 17 & \$ 15 & \$ 12 & \$ 8 & \$ 139 \\5 & \$ 75 & \$ 20 & \$ 25 & \$ 30 & \$ 45 & \$ 174 \\\hline\end{array}
Budget $225K $60K $60K $50K $50K The following is the ILP formulation and a spreadsheet model for the problem.
Let Xi = 0 if project i not selected,1 if project i selected for i = 1,2,3,4,5
Cj = amount carried out of year j,j = 1,2,3,4,5
MAX 160X1 + 190X2 + 125X3 +139X4 + 174X5 Subject to: 70X1 + 82X2 + 55X3 + 69X4 + 75X5 + C1 = 225
40X1 + 35X2 + 10X3 + 17X4 + 20X5 + C2 = 60 + C1
30X1 + 20X2 + 10X3 + 15X4 + 25X5 + C3 = 60 + C2
15X1 + 20X2 + 5X3 + 12X4 + 30X5 + C4 = 50 + C3
15X1 + 10X2 + 8X4 + 45X5 + C5 = 50 + C4 C5 ? 30
Xi binary,C1,C2,C3,C4,C5 ? 0
 Exhibit 6.1 The following questions pertain to the problem,formulation,and spreadsheet implementation below. A research director must pick a subset of research projects to fund over the next five years.He has five candidate projects,not all of which cover the entire five-year period.Although the director has limited funds in each of the next five years,he can carry over unspent research funds into the next year.Additionally,up to $30K can be carried out of the five-year planning period.The following table summarizes the projects and budget available to the research director. Project Funds Required in $000s)Benefit  \begin{array}{ccccccc} \text { Project } & 1 & 2 & 3 & 4 & 5 & \text { in } \$ 000 s) \\ \hline 1 & \$ 70 & \$ 40 & \$ 30 & \$ 15 & \$ 15 & \$ 160 \\ 2 & \$ 82 & \$ 35 & \$ 20 & \$ 20 & \$ 10 & \$ 190 \\ 3 & \$ 55 & \$ 10 & \$ 10 & \$ 5 & & \$ 125 \\ 4 & \$ 69 & \$ 17 & \$ 15 & \$ 12 & \$ 8 & \$ 139 \\ 5 & \$ 75 & \$ 20 & \$ 25 & \$ 30 & \$ 45 & \$ 174 \\ \hline \end{array}  Budget $225K $60K $60K $50K $50K The following is the ILP formulation and a spreadsheet model for the problem. Let <sup>X</sup><sub>i </sub><sup>= 0 if project i not selected,1 if project i selected for i = 1,2,3,4,5</sup> C<sub>j </sub>= amount carried out of year j,j = 1,2,3,4,5 MAX <sup>160X</sup><sub>1 </sub><sup>+ 190X</sup><sub>2 </sub><sup>+ 125X</sup><sub>3 </sub><sup>+139X</sup><sub>4 </sub><sup>+ 174X</sup><sub>5 </sub>Subject to: <sup>70X</sup><sub>1 </sub><sup>+ 82X</sup><sub>2 </sub><sup>+ 55X</sup><sub>3 </sub><sup>+ 69X</sup><sub>4 </sub><sup>+ 75X</sup><sub>5 </sub><sup>+ C</sup><sub>1 </sub><sup>= 225</sup> 40X<sub>1 </sub>+ 35X<sub>2 </sub>+ 10X<sub>3 </sub>+ 17X<sub>4 </sub>+ 20X<sub>5 </sub>+ C<sub>2 </sub>= 60 + C<sub>1</sub> 30X<sub>1 </sub>+ 20X<sub>2 </sub>+ 10X<sub>3 </sub>+ 15X<sub>4 </sub>+ 25X<sub>5 </sub>+ C<sub>3 </sub>= 60 + C<sub>2</sub> 15X<sub>1 </sub>+ 20X<sub>2 </sub>+ 5X<sub>3 </sub>+ 12X<sub>4 </sub>+ 30X<sub>5 </sub>+ C<sub>4 </sub>= 50 + C<sub>3</sub> 15X<sub>1 </sub>+ 10X<sub>2 </sub>+ 8X<sub>4 </sub>+ 45X<sub>5 </sub>+ C<sub>5 </sub>= 50 + C<sub>4 </sub>C<sub>5 </sub>? 30 X<sub>i </sub>binary,C<sub>1</sub>,C<sub>2</sub>,C<sub>3</sub>,C<sub>4</sub>,C<sub>5 </sub>? 0    -Refer to Exhibit 6.1.What formula should go in cell D15 of the above Excel spreadsheet?<div style=padding-top: 35px>

-Refer to Exhibit 6.1.What formula should go in cell D15 of the above Excel spreadsheet?
سؤال
An investor has $500,000 to invest and wants to maximize the money they will receive at the end of one year.They can invest in condos,apartments and houses.The profit after one year,the cost and the number of units available are shown below.
 Profit Cost  Number  Variable  Investment $1,000)$1,000) Available X1 Condos 65010X2 Apartments 12905X3 Houses 91007\begin{array}{rrrrr}&&\text { Profit}&\text { Cost }&\text { Number }\\\text { Variable } & \text { Investment } & \$ 1,000) & \$ 1,000) & \text { Available } \\\hline \mathrm{X}_{1} & \text { Condos } & 6 & 50 & 10 \\\mathrm{X}_{2} & \text { Apartments } & 12 & 90 & 5 \\\mathrm{X}_{3} & \text { Houses } & 9 & 100 & 7\end{array}
Based on this ILP formulation of the problem and the indicated optimal integer solution values what values should go in cells B5:F12 of the following Excel spreadsheet?
MAX: 6 X1 + 12 X2 + 9 X3
Subject to: 50 X1 + 90 X2 + 100 X3 ? 500
X1 ? 10
X2 ? 5
X3 ? 7
Xi ? 0 and integer
سؤال
A city wants to locate 2 new fire fighting ladder trucks to maximize the number of tall buildings which they can cover within a 3 minute response time.The city is divided into 4 zones.The fire chief wants to locate no more than one of the trucks in either Zone 1 or Zone 2.The number of tall buildings in each zone and the travel time between zones is listed below.
Formulate the ILP for this problem.
 To zone  No. tall buildings  Fram zone 12345010216902204560314017046510\begin{array}{c}\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad \text { To zone }\\\begin{array} { c c c c c c } \text { No. tall buildings } & \text { Fram zone } & 1 & 2 & 3 & 4 \\\hline 50 & 1 & 0 & 2 & 1 & 6 \\90 & 2 & 2 & 0 & 4 & 5 \\60 & 3 & 1 & 4 & 0 & 1 \\70 & 4 & 6 & 5 & 1 & 0\end{array}\end{array}
سؤال
Exhibit 6.1
The following questions pertain to the problem,formulation,and spreadsheet implementation below.
A research director must pick a subset of research projects to fund over the next five years.He has five candidate projects,not all of which cover the entire five-year period.Although the director has limited funds in each of the next five years,he can carry over unspent research funds into the next year.Additionally,up to $30K can be carried out of the five-year planning period.The following table summarizes the projects and budget available to the research director.
Project Funds Required in $000s)Benefit
 Project 12345 in $000s)1$70$40$30$15$15$1602$82$35$20$20$10$1903$55$10$10$5$1254$69$17$15$12$8$1395$75$20$25$30$45$174\begin{array}{ccccccc}\text { Project } & 1 & 2 & 3 & 4 & 5 & \text { in } \$ 000 s) \\\hline 1 & \$ 70 & \$ 40 & \$ 30 & \$ 15 & \$ 15 & \$ 160 \\2 & \$ 82 & \$ 35 & \$ 20 & \$ 20 & \$ 10 & \$ 190 \\3 & \$ 55 & \$ 10 & \$ 10 & \$ 5 & & \$ 125 \\4 & \$ 69 & \$ 17 & \$ 15 & \$ 12 & \$ 8 & \$ 139 \\5 & \$ 75 & \$ 20 & \$ 25 & \$ 30 & \$ 45 & \$ 174 \\\hline\end{array}
Budget $225K $60K $60K $50K $50K The following is the ILP formulation and a spreadsheet model for the problem.
 Exhibit 6.1 The following questions pertain to the problem,formulation,and spreadsheet implementation below. A research director must pick a subset of research projects to fund over the next five years.He has five candidate projects,not all of which cover the entire five-year period.Although the director has limited funds in each of the next five years,he can carry over unspent research funds into the next year.Additionally,up to $30K can be carried out of the five-year planning period.The following table summarizes the projects and budget available to the research director. Project Funds Required in $000s)Benefit  \begin{array}{ccccccc} \text { Project } & 1 & 2 & 3 & 4 & 5 & \text { in } \$ 000 s) \\ \hline 1 & \$ 70 & \$ 40 & \$ 30 & \$ 15 & \$ 15 & \$ 160 \\ 2 & \$ 82 & \$ 35 & \$ 20 & \$ 20 & \$ 10 & \$ 190 \\ 3 & \$ 55 & \$ 10 & \$ 10 & \$ 5 & & \$ 125 \\ 4 & \$ 69 & \$ 17 & \$ 15 & \$ 12 & \$ 8 & \$ 139 \\ 5 & \$ 75 & \$ 20 & \$ 25 & \$ 30 & \$ 45 & \$ 174 \\ \hline \end{array}  Budget $225K $60K $60K $50K $50K The following is the ILP formulation and a spreadsheet model for the problem.      -Refer to Exhibit 6.1.What values would you enter in the Analytic Solver Platform task pane for the above Excel spreadsheet? Objective Cell: Variables Cells: Constraints Cells: <div style=padding-top: 35px>
 Exhibit 6.1 The following questions pertain to the problem,formulation,and spreadsheet implementation below. A research director must pick a subset of research projects to fund over the next five years.He has five candidate projects,not all of which cover the entire five-year period.Although the director has limited funds in each of the next five years,he can carry over unspent research funds into the next year.Additionally,up to $30K can be carried out of the five-year planning period.The following table summarizes the projects and budget available to the research director. Project Funds Required in $000s)Benefit  \begin{array}{ccccccc} \text { Project } & 1 & 2 & 3 & 4 & 5 & \text { in } \$ 000 s) \\ \hline 1 & \$ 70 & \$ 40 & \$ 30 & \$ 15 & \$ 15 & \$ 160 \\ 2 & \$ 82 & \$ 35 & \$ 20 & \$ 20 & \$ 10 & \$ 190 \\ 3 & \$ 55 & \$ 10 & \$ 10 & \$ 5 & & \$ 125 \\ 4 & \$ 69 & \$ 17 & \$ 15 & \$ 12 & \$ 8 & \$ 139 \\ 5 & \$ 75 & \$ 20 & \$ 25 & \$ 30 & \$ 45 & \$ 174 \\ \hline \end{array}  Budget $225K $60K $60K $50K $50K The following is the ILP formulation and a spreadsheet model for the problem.      -Refer to Exhibit 6.1.What values would you enter in the Analytic Solver Platform task pane for the above Excel spreadsheet? Objective Cell: Variables Cells: Constraints Cells: <div style=padding-top: 35px>

-Refer to Exhibit 6.1.What values would you enter in the Analytic Solver Platform task pane for the above Excel spreadsheet?
Objective Cell: Variables Cells: Constraints Cells:
سؤال
A small town wants to build some new recreational facilities.The proposed facilities include a swimming pool,recreation center,basketball court and baseball field.The town council wants to provide the facilities which will be used by the most people,but faces budget and land limitations.The town has $400,000 and 14 acres of land.The pool requires locker facilities which would be in the recreation center,so if the swimming pool is built the recreation center must also be built.Also the council has only enough flat land to build the basketball court or the baseball field.The daily usage and cost of the facilities in $1,000)are shown below.
Formulate the ILP for this problem.
 Variable  Facilty  Usage  Cost $1,000)  Land x1 Swimruine pool 4001002x2 Recreation center 5002003x3 Basketball court 3001504x4 Baseball field 2001005\begin{array} { r r r r r } \text { Variable } & \text { Facilty } & \text { Usage } & \text { Cost \$1,000) } & \text { Land } \\\hline \mathbf { x } _ { 1 } & \text { Swimruine pool } & 400 & 100 & 2 \\\mathbf { x } _ { 2 } & \text { Recreation center } & 500 & 200 & 3 \\\mathbf { x } _ { 3 } & \text { Basketball court } & 300 & 150 & 4 \\\mathbf { x } _ { 4 } & \text { Baseball field } & 200 & 100 & 5\end{array}
سؤال
A company wants to build a new factory in either Atlanta or Columbia.It is also considering building a warehouse in whichever city is selected for the new factory.The following table shows the net present value NPV)and cost of each facility.The company wants to maximize the net present value of its facilities,but it only has $16 million to invest.
Variable Decision
NPV
$million)
Cost $million)
X1 Factory in Columbia 3 10
X2 Factory in Atlanta 4 8
X3 Warehouse in Columbia 2 6
X4 Warehouse in Atlanta 1 5
Based on this ILP formulation of the problem and the indicated optimal solution what formulas should go in cells F6:F14 of the following Excel spreadsheet?
MAX: 3 X1 + 4 X2 + 2 X3 + X4
Subject to: 10 X1 + 8 X2 + 6 X3 + 5 X4 ≤ 15
X1 + X2 = 1 X3 + X4 ≤ 1 X3 − X1 ≤ 0 X4 − X2 ≤ 0 Xi = 0,1
سؤال
The optimal relaxed solution for an ILP has X1 = 3.6 and X2 = 2.9.If we branch on X1,what constraints must be added to the two resulting LP problems?

A)X1 ≥ 3,X1 ≥ 4
B)X1 = 4
C)3 ≤ X1,X1 ≤ 4
D)X1 ≤ 3,X1 ≥ 4
سؤال
A company wants to build a new factory in either Atlanta or Columbia.It is also considering building a warehouse in whichever city is selected for the new factory.The following table shows the net present value NPV)and cost of each facility.The company wants to maximize the net present value of its facilities,but it only has $15 million to invest.
Formulate the ILP for this problem.
Variable Decision
NPV
$million)
Cost $million)
X1 Factory in Columbia 3 10
X2 Factory in Atlanta 4 8
X3 Warehouse in Columbia 2 6
X4 Warehouse in Atlanta 1 5
سؤال
A sub-problem in a B & B is solved and found infeasible.Should the B & B algorithm continue further analysis on this candidate problem?

A)Yes,a feasible solution may be found when additional constraints are added.
B)Yes,removing a constraint in further analysis may restore feasibility.
C)No,adding more constraints will not restore problem feasibility.
D)No,the result cannot occur so re-examine the formulation and start over.
سؤال
A company has four projects,numbered 1 through 4.If any project is selected for implementation,each lower- numbered project must also be selected for implementation.Formulate the constraints to enforce these conditions.
سؤال
A company wants to build a new factory in either Atlanta or Columbia.It is also considering building a warehouse in whichever city is selected for the new factory.The following table shows the net present value NPV)and cost of each facility.The company wants to maximize the net present value of its facilities,but it only has $15 million to invest.
Variable Decision
NPV
$million)
Cost $million)
X1 Factory in Columbia 3 10
X2 Factory in Atlanta 4 8
X3 Warehouse in Columbia 2 6
X4 Warehouse in Atlanta 1 5
Based on this ILP formulation of the problem and the indicated optimal solution what values should go in cells B6:G14 of the following Excel spreadsheet?
MAX: 3 X1 + 4 X2 + 2 X3 + X4
Subject to: 10 X1 + 8 X2 + 6 X3 + 5 X4 ≤ 15
X1 + X2 = 1 X3 + X4 ≤ 1 X3 − X1 ≤ 0 X4 − X2 ≤ 0
Xi = 0,1
سؤال
A company wants to build a new factory in either Atlanta or Columbia.It is also considering building a warehouse in whichever city is selected for the new factory.The following table shows the net present value NPV)and cost of each facility.The company wants to maximize the net present value of its facilities,but it only has $16 million to invest.
Variable Decision
NPV
$million)
Cost $million)
X1 Factory in Columbia 3 10
X2 Factory in Atlanta 4 8
X3 Warehouse in Columbia 2 6
X4 Warehouse in Atlanta 1 5
Based on this ILP formulation of the problem what is the optimal solution to the problem?
MAX: 3 X1 + 4 X2 + 2 X3 + X4
Subject to: 10 X1 + 8 X2 + 6 X3 + 5 X4 ≤ 15
X1 + X2 = 1 X3 + X4 ≤ 1 X3 − X1 ≤ 0 X4 − X2 ≤ 0 Xi = 0,1
سؤال
An investor has $500,000 to invest and wants to maximize the money they will receive at the end of one year.They can invest in condos,apartments and houses.The profit after one year,the cost and the number of units available are shown below.
 Profit  Cost  Number  Variable  Investment $1,000)$1,000) Available X1 Condos 65010X2 Apartments 12905X3 Houses 91nn7\begin{array}{rrrrr}&&\text { Profit } & \text { Cost } & \text { Number } \\\text { Variable } & \text { Investment } &\$ 1,000)&\$ 1,000) & \text { Available }\\\hline \mathrm{X} 1 & \text { Condos } & 6 & 50 & 10 \\\mathrm{X} 2 & \text { Apartments } & 12 & 90 & 5 \\\mathrm{X} 3 & \text { Houses } & 9 & 1 \mathrm{nn} & 7\end{array}
Based on this ILP formulation of the problem what formulas should go in cells E5:E12 of the following Excel spreadsheet?
MAX: 6 X1 + 12 X2 + 9 X3
Subject to: 50 X1 + 90 X2 + 100 X3 ? 500
X1 ? 10
X2 ? 5
X3 ? 7
Xi ? 0 and integer
 An investor has $500,000 to invest and wants to maximize the money they will receive at the end of one year.They can invest in condos,apartments and houses.The profit after one year,the cost and the number of units available are shown below.  \begin{array}{rrrrr} &&\text { Profit } &  \text { Cost } & \text { Number } \\ \text { Variable } & \text { Investment } &\$ 1,000)&\$ 1,000)   & \text { Available }\\ \hline \mathrm{X} 1 & \text { Condos } & 6 & 50 & 10 \\ \mathrm{X} 2 & \text { Apartments } & 12 & 90 & 5 \\ \mathrm{X} 3 & \text { Houses } & 9 & 1 \mathrm{nn} & 7 \end{array}  Based on this ILP formulation of the problem what formulas should go in cells E5:E12 of the following Excel spreadsheet? MAX: <sup>6 X</sup><sub>1 </sub><sup>+ 12 X</sup><sub>2 </sub><sup>+ 9 X</sup><sub>3</sub> Subject to: <sup>50 X</sup><sub>1 </sub><sup>+ 90 X</sup><sub>2 </sub><sup>+ 100 X</sup><sub>3 </sub><sup>? 500</sup> X<sub>1 </sub>? 10 X<sub>2 </sub>? 5 X<sub>3 </sub>? 7 Xi ? 0 and integer  <div style=padding-top: 35px>
سؤال
A company needs to hire workers to cover a 7 day work week.Employees work 5 consecutive days with 2 days off.The demand for workers by day of the week and the wages per shift are:
 Days af Week  Workers Required  Shift  Days off  Wage  Sunday 541 Sun a Man 900 Munday 502 Man a Tue 1000 Tuesday 363 Tue d Wed 1000 Wednestay 384 Wed a Thur 1000 Thursday 425 Thur a Fri 1000 Friday 406 Fri a Sat 900 Saturday 487 Sat a Sun 850\begin{array} { l c r r r } \text { Days af Week } & \text { Workers Required } & \text { Shift } & \text { Days off } & \text { Wage } \\\hline \text { Sunday } & 54 & 1 & \text { Sun a Man } & 900 \\\text { Munday } & 50 & 2 & \text { Man a Tue } & 1000 \\\text { Tuesday } & 36 & 3 & \text { Tue d Wed } & 1000 \\\text { Wednestay } & 38 & 4 & \text { Wed a Thur } & 1000 \\\text { Thursday } & 42 & 5 & \text { Thur a Fri } & 1000 \\\text { Friday } & 40 & 6 & \text { Fri a Sat } & 900 \\\text { Saturday } & 48 & 7 & \text { Sat a Sun } & 850\end{array}
Formulate the ILP for this problem.
سؤال
A small town wants to build some new recreational facilities.The proposed facilities include a swimming pool,recreation center,basketball court and baseball field.The town council wants to provide the facilities which will be used by the most people,but faces budget and land limitations.The town has $400,000 and 14 acres of land.The pool requires locker facilities which would be in the recreation center,so if the swimming pool is built the recreation center must also be built.Also the council has only enough flat land to build the basketball court or the baseball field.The daily usage and cost of the facilities in $1,000)are shown below.
 Variable  Facilty  Usage  Cost $1,000)  Land x1 Swimming pool 4001002x2 Recreation center 5002003x3 Basketball court 3001504x4 Baseball field 2001005\begin{array} { r r r r r } \text { Variable } & \text { Facilty } & \text { Usage } & \text { Cost \$1,000) } & \text { Land } \\\hline \mathbf { x } _ { 1 } & \text { Swimming pool } & 400 & 100 & 2 \\\mathbf { x } _ { 2 } & \text { Recreation center } & 500 & 200 & 3 \\\mathbf { x } _ { 3 } & \text { Basketball court } & 300 & 150 & 4 \\\mathbf { x } _ { 4 } & \text { Baseball field } & 200 & 100 & 5\end{array}
Based on this ILP formulation of the problem and the indicated optimal solution what values should go in cells
B5:G12 of the following Excel spreadsheet?
 MAX: 400x1+500x2+300x3+200x4 Subject ta: 100x1+200x2+150x3+100x4400 budget 2x1+3x2+4x3+5x414 land x1x20 pool and recreation center x3+x41 basketball and baseball x1=0.1\begin{array} { l l l } \text { MAX: } & 400 \mathbf { x } _ { 1 } + 500 \mathbf { x } _ { 2 } + 300 \mathbf { x } _ { 3 } + 200 \mathbf { x } _ { 4 } & \\\text { Subject ta: } & 100 \mathbf { x } _ { 1 } + 200 \mathbf { x } _ { 2 } + 150 \mathbf { x } _ { 3 } + 100 \mathbf { x } _ { 4 } \leq 400 & \text { budget } \\& 2 \mathbf { x } _ { 1 } + 3 \mathbf { x } _ { 2 } + 4 \mathbf { x } _ { 3 } + 5 \mathbf { x } _ { 4 } \leq 14 & \text { land } \\& \mathbf { x } _ { 1 } - \mathbf { x } _ { 2 } \leq 0 & \text { pool and recreation center } \\& \mathbf { x } _ { 3 } + \mathbf { x } _ { 4 } \leq 1 & \text { basketball and baseball } \\& \mathbf { x } _ { 1 } = 0.1 &\end{array}
Solution: x1,x2,x3,X4)=1,1,0,1\left. \mathbf { x } _ { 1 } , \mathbf { x } _ { 2 } , \mathbf { x } _ { 3 } , \mathbf { X } _ { 4 } \right) = 1,1,0,1 )
 A small town wants to build some new recreational facilities.The proposed facilities include a swimming pool,recreation center,basketball court and baseball field.The town council wants to provide the facilities which will be used by the most people,but faces budget and land limitations.The town has $400,000 and 14 acres of land.The pool requires locker facilities which would be in the recreation center,so if the swimming pool is built the recreation center must also be built.Also the council has only enough flat land to build the basketball court or the baseball field.The daily usage and cost of the facilities in $1,000)are shown below.  \begin{array} { r r r r r } \text { Variable } & \text { Facilty } & \text { Usage } & \text { Cost \$1,000) } & \text { Land } \\ \hline \mathbf { x } _ { 1 } & \text { Swimming pool } & 400 & 100 & 2 \\ \mathbf { x } _ { 2 } & \text { Recreation center } & 500 & 200 & 3 \\ \mathbf { x } _ { 3 } & \text { Basketball court } & 300 & 150 & 4 \\ \mathbf { x } _ { 4 } & \text { Baseball field } & 200 & 100 & 5 \end{array}  Based on this ILP formulation of the problem and the indicated optimal solution what values should go in cells B5:G12 of the following Excel spreadsheet?  \begin{array} { l l l } \text { MAX: } & 400 \mathbf { x } _ { 1 } + 500 \mathbf { x } _ { 2 } + 300 \mathbf { x } _ { 3 } + 200 \mathbf { x } _ { 4 } & \\ \text { Subject ta: } & 100 \mathbf { x } _ { 1 } + 200 \mathbf { x } _ { 2 } + 150 \mathbf { x } _ { 3 } + 100 \mathbf { x } _ { 4 } \leq 400 & \text { budget } \\ & 2 \mathbf { x } _ { 1 } + 3 \mathbf { x } _ { 2 } + 4 \mathbf { x } _ { 3 } + 5 \mathbf { x } _ { 4 } \leq 14 & \text { land } \\ & \mathbf { x } _ { 1 } - \mathbf { x } _ { 2 } \leq 0 & \text { pool and recreation center } \\ & \mathbf { x } _ { 3 } + \mathbf { x } _ { 4 } \leq 1 & \text { basketball and baseball } \\ & \mathbf { x } _ { 1 } = 0.1 & \end{array}  Solution:  \left. \mathbf { x } _ { 1 } , \mathbf { x } _ { 2 } , \mathbf { x } _ { 3 } , \mathbf { X } _ { 4 } \right) = 1,1,0,1  )  <div style=padding-top: 35px>
سؤال
A cellular phone company wants to locate two new communications towers to cover 4 regions.The company wants to minimize the cost of installing the two towers.The regions that can be covered by each tower site are indicated by a 1 in the following table:
Tower Sites
 Region 1234 A 11 B 111 C 111 D 11 COST $000 s) 200150190250\begin{array}{rrrrr}\text { Region } & 1 & 2 & 3 & 4 \\\hline \text { A } & & 1 & & 1 \\\text { B } & 1 & & 1 & 1 \\\text { C } & 1 & 1 & 1 & \\\text { D } & 1 & & &1 \\\hline \text { COST } \$ 000 \text { s) } & 200 & 150 & 190 & 250\end{array}

Formulate the ILP for this problem.
سؤال
An investor has $500,000 to invest and wants to maximize the money they will receive at the end of one year.They can invest in condos,apartments and houses.The profit after one year,the cost and the number of units available are shown below.
Formulate the ILP for this problem.
 Profit Cost  Number  Variable  Investment $1,000)$1,000) Available X1 Condos 65010X2 Apartments 12905X3 Houses 91007\begin{array}{rrrrr}&&\text { Profit}&\text { Cost }&\text { Number }\\\text { Variable } & \text { Investment } & \$ 1,000) & \$ 1,000) & \text { Available } \\\hline \mathrm{X}_{1} & \text { Condos } & 6 & 50 & 10 \\\mathrm{X}_{2} & \text { Apartments } & 12 & 90 & 5 \\\mathrm{X}_{3} & \text { Houses } & 9 & 100 & 7\end{array}
سؤال
A cellular phone company wants to locate two new communications towers to cover 4 regions.The company wants to minimize the cost of installing the two towers.The regions that can be covered by each tower site are indicated by a 1 in the following table:
Tower Sites
 Region 1234 A 11 B 111 C 111 D 11 COST $000 s) 200150190250\begin{array}{rrrrr}\text { Region } & 1 & 2 & 3 & 4 \\\hline \text { A } & & 1 & & 1 \\\text { B } & 1 & & 1 & 1 \\\text { C } & 1 & 1 & 1 & \\\text { D } & 1 & & & 1\\\hline \text { COST } \$ 000 \text { s) } & 200 & 150 & 190 & 250\end{array}
MIN: 200 X1 + 150 X2 + 190 X3 + 250 X4
Subject to: X2 + X4 ? 1
X1 + X3 + X4 ? 1 X1 + X2 + X3 ? 1 X1 + X4 ? 1
X1 + X2 + X3 + X4 = 2 Xi = 0,1
Based on this ILP formulation of the problem and the solution X1,X2,X3,X4)= 1,1,0,0)what values should go in cells B6:G14 of the following Excel spreadsheet?
 A cellular phone company wants to locate two new communications towers to cover 4 regions.The company wants to minimize the cost of installing the two towers.The regions that can be covered by each tower site are indicated by a 1 in the following table: Tower Sites  \begin{array}{rrrrr} \text { Region } & 1 & 2 & 3 & 4 \\ \hline \text { A } & & 1 & & 1 \\ \text { B } & 1 & & 1 & 1 \\ \text { C } & 1 & 1 & 1 &  \\ \text { D } & 1 & & & 1\\ \hline \text { COST } \$ 000 \text { s) } & 200 & 150 & 190 & 250 \end{array}  MIN: <sup>200 X</sup><sub>1 </sub><sup>+ 150 X</sup><sub>2 </sub><sup>+ 190 X</sup><sub>3 </sub><sup>+ 250 X</sup><sub>4</sub> Subject to: <sup>X</sup><sub>2 </sub><sup>+ X</sup><sub>4 </sub><sup>? 1</sup> X<sub>1 </sub>+ X<sub>3 </sub>+ X<sub>4 </sub>? 1 X<sub>1 </sub>+ X<sub>2 </sub>+ X<sub>3 </sub>? 1 X<sub>1 </sub>+ X<sub>4 </sub>? 1 X<sub>1 </sub>+ X<sub>2 </sub>+ X<sub>3 </sub>+ X<sub>4 </sub>= 2 X<sub>i </sub>= 0,1 Based on this ILP formulation of the problem and the solution X<sub>1</sub>,X<sub>2</sub>,X<sub>3</sub>,X<sub>4</sub>)= 1,1,0,0)what values should go in cells B6:G14 of the following Excel spreadsheet?  <div style=padding-top: 35px>
سؤال
A cellular phone company wants to locate two new communications towers to cover 4 regions.The company wants to minimize the cost of installing the two towers.The regions that can be covered by each tower site are indicated by a 1 in the following table:
Tower Sites
 Region 1234 A 11 B 111 C 111 D 11 COST $000 s) 200150190250\begin{array}{rrrrr}\text { Region } & 1 & 2 & 3 & 4 \\\hline \text { A } & & 1 & & 1 \\\text { B } & 1 & & 1 & 1 \\\text { C } & 1 & 1 & 1 &\\\text { D } & 1 & & & 1 \\\hline \text { COST } \$ 000 \text { s) } & 200 & 150 & 190 & 250\end{array}
MIN: 200 X1 + 150 X2 + 190 X3 + 250 X4
Subject to: X2 + X4 ? 1
X1 + X3 + X4 ? 1 X1 + X2 + X3 ? 1 X1 + X4 ? 1
X1 + X2 + X3 + X4 = 2 Xi = 0,1
Based on this ILP formulation of the problem what formulas should go in cells F6:F14 of the following Excel spreadsheet?
 A cellular phone company wants to locate two new communications towers to cover 4 regions.The company wants to minimize the cost of installing the two towers.The regions that can be covered by each tower site are indicated by a 1 in the following table: Tower Sites  \begin{array}{rrrrr} \text { Region } & 1 & 2 & 3 & 4 \\ \hline \text { A } & & 1 & & 1 \\ \text { B } & 1 & & 1 & 1 \\ \text { C } & 1 & 1 & 1 &\\ \text { D } & 1 & & & 1 \\ \hline \text { COST } \$ 000 \text { s) } & 200 & 150 & 190 & 250 \end{array}  MIN: <sup>200 X</sup><sub>1 </sub><sup>+ 150 X</sup><sub>2 </sub><sup>+ 190 X</sup><sub>3 </sub><sup>+ 250 X</sup><sub>4</sub> Subject to: <sup>X</sup><sub>2 </sub><sup>+ X</sup><sub>4 </sub><sup>? 1</sup> X<sub>1 </sub>+ X<sub>3 </sub>+ X<sub>4 </sub>? 1 X<sub>1 </sub>+ X<sub>2 </sub>+ X<sub>3 </sub>? 1 X<sub>1 </sub>+ X<sub>4 </sub>? 1 X<sub>1 </sub>+ X<sub>2 </sub>+ X<sub>3 </sub>+ X<sub>4 </sub>= 2 X<sub>i </sub>= 0,1 Based on this ILP formulation of the problem what formulas should go in cells F6:F14 of the following Excel spreadsheet?  <div style=padding-top: 35px>
سؤال
A certain military deployment requires supplies delivered to four locations.These deliveries come from one of three ports.Logistics planners wish to deliver the supplies in an efficient manner,in this case by minimizing total ton-miles.The port-destination data,along with destination demand is provided in the following table.
 Destination  Port  D1  D2  D3  D4 A758810356 B 1057610185C43809562 Demand 500600450700\begin{array}{c}\text { Destination }\\\begin{array} { c r r r r } \text { Port } & \text { D1 } & \text { D2 } & \text { D3 } & \text { D4 } \\\hline \text {A}& 75 & 88 & 103 & 56 \\\text { B } & 105 & 76 & 101 & 85 \\\mathrm { C } & 43 & 80 & 95 & 62 \\\hline \text { Demand } & 500 & 600 & 450 & 700\end{array}\end{array}
The ports are supplied by one of two supply ships.These ships travel to a particular port where their supplies are off-loaded and shipped to the requesting destinations.Ship S1 carries 1200 tones of supplies while Ship S2 carries 1120 tons of supplies.These ships can only go to a single port and each port can only accommodate one ship.
Assume the costs for a ship to travel to a port are not part of the objective function.
Formulate the ILP for this problem capturing the ship choice of ports and the supply-to-demand transportation from the ports to the destinations.
سؤال
Binary decision variables:

A)are either 0 or 1
B)must be integers
C)may be continuous
D)may be negative
سؤال
Suppose you want to minimize an objective function z=2x1+3x2.Both decision variables must be integer.The optimal solution to the LP relaxation will:

A)be smaller than the optimal IP solution
B)be larger than the optimal IP solution
C)can be either smaller or larger than the optimal IP solution
D)will be within 5% of the optimal IP solution value
سؤال
Suppose you want to maximize an objective function z=2x1+3x2.Both decision variables must be integer.The optimal solution to the LP relaxation will:

A)be smaller than the optimal IP solution
B)be larger than the optimal IP solution
C)can be either smaller or larger than the optimal IP solution
D)will be within 5% of the optimal IP solution value
سؤال
The concept of a lower bound in IP is associated with:

A)LP relaxation of a minimization problem
B)LP relaxation of a maximization problem
C)a cutting plane technique
D)explicit enumeration of corner point solutions
سؤال
Project 6.2 ? Dayton Electronics Manufacturing Inc.DEMI)
The Dayton Electronic Manufacturing,Inc DEMI)company manufactures two styles of remote keyless entry systems the X30 and the X40)that various auto dealers supply to customers when a new or used)automobile is purchased.DEMI currently operates four production facilities located in Springfield OH,Hartford,New Orleans,and Orlando.The manufactured items are shipped from the plants to regional distribution centers located in Trenton,Chicago and Seattle.It is from these regional locations that the product is distributed nationwide.
As more automobile manufactures include keyless entry as a standard option,and DEMI finds itself locked out of the manufacturer market,demand for DEMI's products have decreased.As a result,management is contemplating closing one or more of its production facilities.Distribution facilities are not currently being considered for closing.
Each production facility carries a fixed operating cost and a variable cost associated with building each of the products.Data has been compiled on production costs,resource availability,and resource usage at each of the production plants.That information is summarized in the table below.
 Plant  Fixed Cost Per  Month $1000 )  Production  Cost per 100 )  X 30X40 Production  Time hr/100 ) X30X40 Available  Hours  per Month  Springfield 531100130066720 Hartford 381100125078780 New Orleans 251000100055530 Orlando 281200150059680\begin{array}{ccccc}\text { Plant } & \begin{array}{l}\text { Fixed Cost Per } \\\text { Month } \$ 1000 \text { ) }\end{array} & \begin{array}{c}\text { Production } \\\text { Cost per } 100 \text { ) } \\\text { X } 30-\mathrm{X} 40\end{array} & \begin{array}{c}\text { Production } \\\text { Time } \mathrm{hr} / 100 \text { ) } \\\mathrm{X} 30-\mathrm{X} 40\end{array} & \begin{array}{c}\text { Available } \\\text { Hours } \\\text { per Month }\end{array} \\\hline \text { Springfield } & 53 & 1100 \quad 1300 & 6\quad6 & 720 \\ \text { Hartford } & 38 & 1100 \quad 1250 & 7\quad8 & 780 \\\text { New Orleans } & 25 & 10001000 & 5\quad5 & 530 \\ \text { Orlando } & 28 & 1200 \quad 1500 & 5\quad9 & 680 \\\end{array}
The entry systems are sold nationwide at the same prices: $24 for the X30 and $30 for the X40.
Current monthly demand projections at each distribution center for both products are given in the following table.
 Demand  Trenton  Chicago  Seattle X30220031004000X40450058006000\begin{array}{c}\text { Demand }\\\begin{array} { c c c c } & \text { Trenton } & \text { Chicago } & \text { Seattle } \\\hline X 30 & 2200 & 3100 & 4000 \\X 40 & 4500 & 5800 & 6000\end{array}\end{array}
The transportation costs between each plant and each distribution center,which are the same for either product,are shown in the following table:
Cost per 100\text {Cost per 100} \quad \quad To\text {To}

 From  Trenton  Chicago  Seattle  Springfield $200$270$450 Hartford $100$200$700 New Orleans $250$240$300 Orlando $180$220$350\begin{array}{lccc}\text { From } & \text { Trenton } & \text { Chicago } & \text { Seattle } \\\hline \text { Springfield } & \$ 200 & \$ 270 & \$ 450 \\\text { Hartford } & \$ 100 & \$ 200 & \$ 700 \\\text { New Orleans } & \$ 250 & \$ 240 & \$ 300 \\\text { Orlando } & \$ 180 & \$ 220 & \$ 350\end{array}
• Determine which of the plants to close and which to keep open.
• Determine the number of X30 and X40 to be produced at each plant.
• Determine a shipping pattern from the plants to the distribution centers.
• Maximize the net total monthly profit.If any plants were closed,what was the impact of the closing on profits?
• Do not exceed the production capacities at any plant.
Formulate DEMI's problem as a fixed charge,integer program.Implement your model in Excel and solve the model to answer DEMI's questions.
سؤال
A practical way of dealing with the complexity of IP problems is to:

A)stop searching for a better solution when the current best solution is within specified suboptimality tolerances
B)continue searching for the optimal solution until no further objective function improvement can be achieved
C)use a B&B technique
D)use LP relaxation and round the values of the decision variables to the nearest integers
سؤال
A company produces three products which must be painted,assembled,and inspected.The machinery must be cleaned and adjusted before each batch is produced.They want to maximize their profits for the amount of operating time they have.The unit profit and setup cost per batch are:
 Product  Profit per unit  Setup cost per batch 19500210600312650\begin{array} { r r r } \text { Product } & \text { Profit per unit } & \text { Setup cost per batch } \\\hline 1 & 9 & 500 \\2 & 10 & 600 \\3 & 12 & 650\end{array}
The operation time per unit and total operating hours available are:
 Operating Time per Unit  Operation  Product 1  Product 2  Product 3  Operating Hours Available  Paint 122400 Assemble 232600 Inspection 243540\begin{array}{c}\text { Operating Time per Unit }\\\begin{array} { l c c c c } \text { Operation } & \text { Product 1 } & \text { Product 2 } & \text { Product 3 } & \text { Operating Hours Available } \\\hline \text { Paint } & 1 & 2 & 2 & 400 \\\text { Assemble } & 2 & 3 & 2 & 600 \\\text { Inspection } & 2 & 4 & 3 & 540\end{array}\end{array}
Based on this ILP formulation of the problem and the optimal solution X1,X2,X3)= 270,0,0),what values should appear in the shaded cells in the following Excel spreadsheet?
Xi = amount of product i produced
Yi = 1 if product i produced,0 otherwise
MAX: 9 X1 + 10 X2 + 12 X3 ? 500 Y1 ? 600 Y2 ? 650 Y3
Subject to: 1 X1 + 2 X2 + 2 X3 ? 400
2 X1 + 3 X2 + 2 X3 ? 600
2 X1 + 4 X2 + 3 X3 ? 540 X1 ? M1 Y1 OR 270 Y1 X2 ? M2 Y2 OR 135 Y2 X3 ? M3 Y3 OR 180 Y3 Yi = 0,1
Xi ? 0 and integer
 A company produces three products which must be painted,assembled,and inspected.The machinery must be cleaned and adjusted before each batch is produced.They want to maximize their profits for the amount of operating time they have.The unit profit and setup cost per batch are:  \begin{array} { r r r } \text { Product } & \text { Profit per unit } & \text { Setup cost per batch } \\ \hline 1 & 9 & 500 \\ 2 & 10 & 600 \\ 3 & 12 & 650 \end{array}  The operation time per unit and total operating hours available are:  \begin{array}{c} \text { Operating Time per Unit }\\ \begin{array} { l c c c c } \text { Operation } & \text { Product 1 } & \text { Product 2 } & \text { Product 3 } & \text { Operating Hours Available } \\ \hline \text { Paint } & 1 & 2 & 2 & 400 \\ \text { Assemble } & 2 & 3 & 2 & 600 \\ \text { Inspection } & 2 & 4 & 3 & 540 \end{array} \end{array}  Based on this ILP formulation of the problem and the optimal solution X<sub>1</sub>,X<sub>2</sub>,X<sub>3</sub>)= 270,0,0),what values should appear in the shaded cells in the following Excel spreadsheet? X<sub>i </sub>= amount of product i produced Y<sub>i </sub>= 1 if product i produced,0 otherwise MAX: <sup>9 X</sup><sub>1 </sub><sup>+ 10 X</sup><sub>2 </sub><sup>+ 12 X</sup><sub>3 </sub><sup>? 500 Y</sup><sub>1 </sub><sup>? 600 Y</sup><sub>2 </sub><sup>? 650 Y</sup><sub>3</sub> Subject to: <sup>1 X</sup><sub>1 </sub><sup>+ 2 X</sup><sub>2 </sub><sup>+ 2 X</sup><sub>3 </sub><sup>? 400</sup> 2 X<sub>1 </sub>+ 3 X<sub>2 </sub>+ 2 X<sub>3 </sub>? 600 2 X<sub>1 </sub>+ 4 X<sub>2 </sub>+ 3 X<sub>3 </sub>? 540 X<sub>1 </sub>? M<sub>1 </sub>Y<sub>1 </sub>OR 270 Y<sub>1 </sub>X<sub>2 </sub>? M<sub>2 </sub>Y<sub>2 </sub>OR 135 Y<sub>2 </sub>X<sub>3 </sub>? M<sub>3 </sub>Y<sub>3 </sub>OR 180 Y<sub>3 </sub>Y<sub>i </sub>= 0,1 X<sub>i </sub>? 0 and integer  <div style=padding-top: 35px>
سؤال
Exhibit 6.2
The following questions pertain to the problem,formulation,and spreadsheet implementation below.
A certain military deployment requires supplies delivered to four locations.These deliveries come from one of three ports.Logistics planners wish to deliver the supplies in an efficient manner,in this case by minimizing total ton-miles.The port-destination data,along with destination demand is provided in the following table.
Destination
 Port  D1  D2  D3  D4  A 758810356 B1057610185C43809582 Demand 500600450700\begin{array} { r r r r r } \text { Port } & \text { D1 } & \text { D2 } & \text { D3 } & \text { D4 } \\\hline \text { A } & 75 & 88 & 103 & 56 \\\mathrm {~B} & 105 & 76 & 101 & 85 \\\mathrm { C } & 43 & 80 & 95 & 82 \\\hline \text { Demand } & 500 & 600 & 450 & 700\end{array} The ports are supplied by one of two supply ships.These ships travel to a particular port where their supplies are off-loaded and shipped to the requesting destinations.Ship S1 carries 1200 tones of supplies while Ship S2 carries 1120 tons of supplies.These ships can only go to a single port and each port can only accommodate one ship.
Assume the costs for a ship to travel to a port are not part of the objective function.The following is the ILP formulation and a spreadsheet model for the problem.
Let Yij be 1 if ship i travels to port j,for i = S1,S2 and j = A,B,C
Xjk be the tons shipped from port j = A,B,C to Destination k = D1,D2,D3,D4
Minimize 75X11 + 88X12 + 103X13 + 56X14 + 105X21 + 76X22 + 101X23 + 85X24
+ 43X31 + 80X32 + 95X33 + 62X34
Subject to: Y11 + Y21 ? 1
Y12 + Y22 ? 1 Y13 + Y23 ? 1
Y11 + Y12 + Y13 = 1 Y21 + Y22 + Y23 = 1
X14 + X15 + X16 + X17 ? 1200Y11 + 1120Y21 X24 + X25 + X26 + X27 ? 1200Y12 + 1120Y22 X34 + X35 + X36 + X37 ? 1200Y13 + 1120Y23 X14 + X24 + X34 ? 500
X15 + X25 + X35 ? 600 X16 + X26 + X36 ? 450 X17 + X27 + X37 ? 700
Yij.Xjk ? 0
 Exhibit 6.2 The following questions pertain to the problem,formulation,and spreadsheet implementation below. A certain military deployment requires supplies delivered to four locations.These deliveries come from one of three ports.Logistics planners wish to deliver the supplies in an efficient manner,in this case by minimizing total ton-miles.The port-destination data,along with destination demand is provided in the following table. Destination  \begin{array} { r r r r r } \text { Port } & \text { D1 } & \text { D2 } & \text { D3 } & \text { D4 } \\ \hline \text { A } & 75 & 88 & 103 & 56 \\ \mathrm {~B} & 105 & 76 & 101 & 85 \\ \mathrm { C } & 43 & 80 & 95 & 82 \\ \hline \text { Demand } & 500 & 600 & 450 & 700 \end{array}  The ports are supplied by one of two supply ships.These ships travel to a particular port where their supplies are off-loaded and shipped to the requesting destinations.Ship S1 carries 1200 tones of supplies while Ship S2 carries 1120 tons of supplies.These ships can only go to a single port and each port can only accommodate one ship. Assume the costs for a ship to travel to a port are not part of the objective function.The following is the ILP formulation and a spreadsheet model for the problem. Let <sup>Y</sup><sub>ij </sub><sup>be 1 if ship i travels to port j,for i = S1,S2 and j = A,B,C</sup> X<sub>jk </sub>be the tons shipped from port j = A,B,C to Destination k = D1,D2,D3,D4 Minimize <sup>75X</sup><sub>11 </sub><sup>+ 88X</sup><sub>12 </sub><sup>+ 103X</sup><sub>13 </sub><sup>+ 56X</sup><sub>14 </sub><sup>+ 105X</sup><sub>21 </sub><sup>+ 76X</sup><sub>22 </sub><sup>+ 101X</sup><sub>23 </sub><sup>+ 85X</sup><sub>24</sub> + 43X<sub>31 </sub>+ 80X<sub>32 </sub>+ 95X<sub>33 </sub>+ 62X<sub>34</sub> Subject to: <sup>Y</sup><sub>11 </sub><sup>+ Y</sup><sub>21 </sub><sup>? 1</sup> Y<sub>12 </sub>+ Y<sub>22 </sub>? 1 Y<sub>13 </sub>+ Y<sub>23 </sub>? 1 Y<sub>11 </sub>+ Y<sub>12 </sub>+ Y<sub>13 </sub>= 1 Y<sub>21 </sub>+ Y<sub>22 </sub>+ Y<sub>23 </sub>= 1 X<sub>14 </sub>+ X<sub>15 </sub>+ X<sub>16 </sub>+ X<sub>17 </sub>? 1200Y<sub>11 </sub>+ 1120Y<sub>21 </sub>X<sub>24 </sub>+ X<sub>25 </sub>+ X<sub>26 </sub>+ X<sub>27 </sub>? 1200Y<sub>12 </sub>+ 1120Y<sub>22 </sub>X<sub>34 </sub>+ X<sub>35 </sub>+ X<sub>36 </sub>+ X<sub>37 </sub>? 1200Y<sub>13 </sub>+ 1120Y<sub>23 </sub>X<sub>14 </sub>+ X<sub>24 </sub>+ X<sub>34 </sub>? 500 X<sub>15 </sub>+ X<sub>25 </sub>+ X<sub>35 </sub>? 600 X<sub>16 </sub>+ X<sub>26 </sub>+ X<sub>36 </sub>? 450 X<sub>17 </sub>+ X<sub>27 </sub>+ X<sub>37 </sub>? 700 Y<sub>ij</sub>.X<sub>jk </sub>? 0    -Refer to Exhibit 6.2.What formula would go into cells B11:E11 and cells F8:F10?<div style=padding-top: 35px>

-Refer to Exhibit 6.2.What formula would go into cells B11:E11 and cells F8:F10?
سؤال
The concept of an upper bound in IP is associated with:

A)LP relaxation of a minimization problem
B)LP relaxation of a maximization problem
C)a cutting plane technique
D)explicit enumeration of corner point solutions
سؤال
Pure IP formulation requires that:

A)all decision variables must be integer
B)the optimal objective function value must be integer
C)some decision variables must be integer
D)some decision variables and the optimal value of the objective function must be integer
سؤال
Exhibit 6.2
The following questions pertain to the problem,formulation,and spreadsheet implementation below.
A certain military deployment requires supplies delivered to four locations.These deliveries come from one of three ports.Logistics planners wish to deliver the supplies in an efficient manner,in this case by minimizing total ton-miles.The port-destination data,along with destination demand is provided in the following table.
Destination
 Port  D1  D2  D3  D4  A 758810356 B1057610185C43809582 Demand 500600450700\begin{array} { r r r r r } \text { Port } & \text { D1 } & \text { D2 } & \text { D3 } & \text { D4 } \\\hline \text { A } & 75 & 88 & 103 & 56 \\\mathrm {~B} & 105 & 76 & 101 & 85 \\\mathrm { C } & 43 & 80 & 95 & 82 \\\hline \text { Demand } & 500 & 600 & 450 & 700\end{array} The ports are supplied by one of two supply ships.These ships travel to a particular port where their supplies are off-loaded and shipped to the requesting destinations.Ship S1 carries 1200 tones of supplies while Ship S2 carries 1120 tons of supplies.These ships can only go to a single port and each port can only accommodate one ship.
Assume the costs for a ship to travel to a port are not part of the objective function.The following is the ILP formulation and a spreadsheet model for the problem.
Let Yij be 1 if ship i travels to port j,for i = S1,S2 and j = A,B,C
Xjk be the tons shipped from port j = A,B,C to Destination k = D1,D2,D3,D4
Minimize 75X11 + 88X12 + 103X13 + 56X14 + 105X21 + 76X22 + 101X23 + 85X24
+ 43X31 + 80X32 + 95X33 + 62X34
Subject to: Y11 + Y21 ? 1
Y12 + Y22 ? 1 Y13 + Y23 ? 1
Y11 + Y12 + Y13 = 1 Y21 + Y22 + Y23 = 1
X14 + X15 + X16 + X17 ? 1200Y11 + 1120Y21 X24 + X25 + X26 + X27 ? 1200Y12 + 1120Y22 X34 + X35 + X36 + X37 ? 1200Y13 + 1120Y23 X14 + X24 + X34 ? 500
X15 + X25 + X35 ? 600 X16 + X26 + X36 ? 450 X17 + X27 + X37 ? 700
Yij.Xjk ? 0
 Exhibit 6.2 The following questions pertain to the problem,formulation,and spreadsheet implementation below. A certain military deployment requires supplies delivered to four locations.These deliveries come from one of three ports.Logistics planners wish to deliver the supplies in an efficient manner,in this case by minimizing total ton-miles.The port-destination data,along with destination demand is provided in the following table. Destination  \begin{array} { r r r r r } \text { Port } & \text { D1 } & \text { D2 } & \text { D3 } & \text { D4 } \\ \hline \text { A } & 75 & 88 & 103 & 56 \\ \mathrm {~B} & 105 & 76 & 101 & 85 \\ \mathrm { C } & 43 & 80 & 95 & 82 \\ \hline \text { Demand } & 500 & 600 & 450 & 700 \end{array}  The ports are supplied by one of two supply ships.These ships travel to a particular port where their supplies are off-loaded and shipped to the requesting destinations.Ship S1 carries 1200 tones of supplies while Ship S2 carries 1120 tons of supplies.These ships can only go to a single port and each port can only accommodate one ship. Assume the costs for a ship to travel to a port are not part of the objective function.The following is the ILP formulation and a spreadsheet model for the problem. Let <sup>Y</sup><sub>ij </sub><sup>be 1 if ship i travels to port j,for i = S1,S2 and j = A,B,C</sup> X<sub>jk </sub>be the tons shipped from port j = A,B,C to Destination k = D1,D2,D3,D4 Minimize <sup>75X</sup><sub>11 </sub><sup>+ 88X</sup><sub>12 </sub><sup>+ 103X</sup><sub>13 </sub><sup>+ 56X</sup><sub>14 </sub><sup>+ 105X</sup><sub>21 </sub><sup>+ 76X</sup><sub>22 </sub><sup>+ 101X</sup><sub>23 </sub><sup>+ 85X</sup><sub>24</sub> + 43X<sub>31 </sub>+ 80X<sub>32 </sub>+ 95X<sub>33 </sub>+ 62X<sub>34</sub> Subject to: <sup>Y</sup><sub>11 </sub><sup>+ Y</sup><sub>21 </sub><sup>? 1</sup> Y<sub>12 </sub>+ Y<sub>22 </sub>? 1 Y<sub>13 </sub>+ Y<sub>23 </sub>? 1 Y<sub>11 </sub>+ Y<sub>12 </sub>+ Y<sub>13 </sub>= 1 Y<sub>21 </sub>+ Y<sub>22 </sub>+ Y<sub>23 </sub>= 1 X<sub>14 </sub>+ X<sub>15 </sub>+ X<sub>16 </sub>+ X<sub>17 </sub>? 1200Y<sub>11 </sub>+ 1120Y<sub>21 </sub>X<sub>24 </sub>+ X<sub>25 </sub>+ X<sub>26 </sub>+ X<sub>27 </sub>? 1200Y<sub>12 </sub>+ 1120Y<sub>22 </sub>X<sub>34 </sub>+ X<sub>35 </sub>+ X<sub>36 </sub>+ X<sub>37 </sub>? 1200Y<sub>13 </sub>+ 1120Y<sub>23 </sub>X<sub>14 </sub>+ X<sub>24 </sub>+ X<sub>34 </sub>? 500 X<sub>15 </sub>+ X<sub>25 </sub>+ X<sub>35 </sub>? 600 X<sub>16 </sub>+ X<sub>26 </sub>+ X<sub>36 </sub>? 450 X<sub>17 </sub>+ X<sub>27 </sub>+ X<sub>37 </sub>? 700 Y<sub>ij</sub>.X<sub>jk </sub>? 0    -Refer to Exhibit 6.2.What formula would go into cell E14?<div style=padding-top: 35px>

-Refer to Exhibit 6.2.What formula would go into cell E14?
سؤال
A company produces three products which must be painted,assembled,and inspected.The machinery must be cleaned and adjusted before each batch is produced.They want to maximize their profits for the amount of operating time they have.The unit profit and setup cost per batch are:
 Product  Profit per unit  Setup cost per batch 19500210600312650\begin{array} { r r r } \text { Product } & \text { Profit per unit } & \text { Setup cost per batch } \\\hline 1 & 9 & 500 \\2 & 10 & 600 \\3 & 12 & 650\end{array}
The operation time per unit and total operating hours available are:
 Operating Time per Unit  Operation  Product 1  Product 2  Product 3  Operating Hours Available  Paint 122400 Assemble 232600 Inspection 243540\begin{array}{c}\text { Operating Time per Unit }\\\begin{array} { l c c c c } \text { Operation } & \text { Product 1 } & \text { Product 2 } & \text { Product 3 } & \text { Operating Hours Available } \\\hline \text { Paint } & 1 & 2 & 2 & 400 \\\text { Assemble } & 2 & 3 & 2 & 600 \\\text { Inspection } & 2 & 4 & 3 & 540\end{array}\end{array}
Formulate the ILP for this problem.
سؤال
Binary variables are useful for modeling

A)the fixed-charge problem
B)the assignment problem
C)the transportation problem
D)the shortest route problem
سؤال
ILP formulations can be used to model:

A)production problems
B)personnel scheduling problems
C)investment allocation problems
D)all of the above
سؤال
The following ILP is being solved by the branch and bound method.You have been given the initial relaxed IP solution.Complete the entries for the 3 nodes and label the arcs when you branch on X2.
MAX: 50 X1 + 40 X2
Subject to: 2 X1 + 4 X2 ≤ 40
3 X1 + 2 X2 ≤ 30
X1,X2 ≥ 0 and integer
Initial solution X1 = 5.0
X2 = 7.5
Obj = 550 The following ILP is being solved by the branch and bound method.You have been given the initial relaxed IP solution.Complete the entries for the 3 nodes and label the arcs when you branch on X2. MAX: <sup>50 X</sup><sub>1 </sub><sup>+ 40 X</sup><sub>2</sub> Subject to: <sup>2 X</sup><sub>1 </sub><sup>+ 4 X</sup><sub>2 </sub><sup>≤ 40</sup> 3 X<sub>1 </sub>+ 2 X<sub>2 </sub>≤ 30 X<sub>1</sub>,X<sub>2 </sub>≥ 0 and integer Initial solution X<sub>1 </sub>= 5.0 X<sub>2 </sub>= 7.5 Obj = 550  <div style=padding-top: 35px>
سؤال
The following ILP is being solved by the branch and bound method.You have been given the initial relaxed IP solution.Complete the entries for the 3 nodes and label the arcs when you branch on X1.
MAX: 35 X1 + 45 X2
Subject to: 35 X1 + 55 X2 ≤ 250
65 X1 + 25 X2 ≤ 340
X1,X2 ≥ 0 and integer
Initial solution
X1 = 4.6X2 = 1.6 Obj = 233.9 The following ILP is being solved by the branch and bound method.You have been given the initial relaxed IP solution.Complete the entries for the 3 nodes and label the arcs when you branch on X<sub>1</sub>. MAX: <sup>35 X</sup><sub>1 </sub><sup>+ 45 X</sup><sub>2</sub> Subject to: <sup>35 X</sup><sub>1 </sub><sup>+ 55 X</sup><sub>2 </sub><sup>≤ 250</sup> 65 X<sub>1 </sub>+ 25 X<sub>2 </sub>≤ 340 X<sub>1</sub>,X<sub>2 </sub>≥ 0 and integer Initial solution X<sub>1 </sub>= 4.6X<sub>2 </sub>= 1.6 Obj = 233.9  <div style=padding-top: 35px>
سؤال
One way to find an optimal solution to the IP problem is to:

A)use a B&B technique
B)use LP relaxation and round the values of the decision variables up to the nearest integer value
C)use LP relaxation and round the values of the decision variables down to the nearest integer value
D)use LP relaxation and round 50 percent of the decision variable values down to the nearest integer value and the remaining 50 percent up to the nearest integer value
سؤال
A popular solution technique to IP problems is called:

A)a branch-and-bound algorithm
B)branching
C)bounding
D)LP relaxation
سؤال
A vendor offers 5 different prices per unit depending on the quantity purchased.How many binary variables are needed to model this discounting scheme?

A)4
B)2
C)3
D)5
فتح الحزمة
قم بالتسجيل لفتح البطاقات في هذه المجموعة!
Unlock Deck
Unlock Deck
1/88
auto play flashcards
العب
simple tutorial
ملء الشاشة (f)
exit full mode
Deck 6: Integer Linear Programming
1
In the B & B algorithm,B & B stands for

A)Brooks and Baker
B)Best Bound
C)Best Branch
D)Branch and Bound
D
2
Which of the following is not a benefit of using binary variables?

A)With only 2 values,Solver can work faster.
B)Binary variables are useful in selection problems.
C)Binary variables can replace some IF)conditions.
D)Binary variables can enforce logical conditions.
A
3
One approach to solving integer programming problems is to ignore the integrality conditions and solve the problem with continuous decision variables.This is referred to as

A)quickest solution method.
B)LP satisficing.
C)LP relaxation.
D)LP approximation.
C
4
The LP relaxation of an ILP problem

A)always encompasses all the feasible integer solutions to the original ILP problem.
B)encompasses at least 90% of the feasible integer solutions to the original ILP problem.
C)encompasses different set of feasible integer solutions to the original ILP problem.
D)will not contain the feasible integer solutions to the original ILP problem.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
5
Variables,which are not required to assume strictly integer values are referred to as

A)strictly non-integer.
B)continuous.
C)discrete.
D)infinite.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
6
What does the Analytic Solver Platform default integer tolerance factor of 0 accomplish?

A)Stops B & B after 100% of all solutions are examined.
B)Stops B & B when any feasible ILP solution is 0% from the current ILP solution.
C)Stops B & B when the true optimal integer solution has been found.
D)Stops B & B when no more than 0% of the changing cells have integer values.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
7
Which of the following are potential pitfalls of using a non-zero integer tolerance factor in the Analytic Solver Platform?

A)No assurance the returned solution is optimal.
B)No assurance the returned solution is integer.
C)The true optimal solution may be worse than the returned solution.
D)There are no pitfalls to consider since the Solver will obtain solutions quicker.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
8
For maximization problems,the optimal objective function value to the LP relaxation provides what for the optimal objective function value of the ILP problem?

A)An upper bound.
B)A lower bound.
C)An alternative optimal solution.
D)An additional constraint for the ILP problem.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
9
How is an LP problem changed into an ILP problem?

A)by adding constraints that the decision variables be non-negative.
B)by adding integrality conditions.
C)by adding discontinuity constraints.
D)by making the RHS values integer.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
10
How are general integrality requirements indicated in the Analytic Solver Platform?

A)Specifying the INT option for the appropriate changing cells.
B)Specifying the INT option for the constraint rows.
C)Adding additional RHS values to constraints.
D)Choosing the BIN setting in the Value field in the Solver Parameters dialog box.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
11
An ILP problem has 5 binary decision variables.How many possible integer solutions are there to this problem?

A)5
B)10
C)25
D)32
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
12
For minimization problems,the optimal objective function value to the LP relaxation provides what for the optimal objective function value of the ILP problem?

A)An upper bound.
B)A lower bound.
C)An alternative optimal solution.
D)An additional constraint for the ILP problem.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
13
How is the integer tolerance factor set in the Analytic Solver Platform ASP)?

A)By adding a constraint for the decision variables who's RHS is the desired suboptimality level.
B)By choosing the optimal option in the ASP Options dialog box.
C)By choosing the 100% Precision field in the ASP Options dialog box.
D)By entering the desired tolerance factor value in the Integer Tolerance field of ASP.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
14
A company wants to select no more than 2 projects from a set of 4 possible projects.Which of the following constraints ensures that no more than 2 will be selected?

A)X1 + X2 + X3 + X4 = 2
B)X1 + X2 + X3 + X4 ≤ 2
C)X1 + X2 + X3 + X4 ≥ 2
D)X1 + X2 + X3 + X4 ≥ 0
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
15
What are binary integer variables?

A)Variables with any two values,a and b.
B)Variables with values 0 and 1.
C)Variables whose sum of digits is 2.
D)Variables with values between 0 and 1.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
16
The objective function value for the ILP problem can never

A)be as good as the optimal solution to its LP relaxation.
B)be as poor as the optimal solution to its LP relaxation.
C)be worse than the optimal solution to its LP relaxation.
D)be better than the optimal solution to its LP relaxation.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
17
An integrality condition indicates that some or all)of the

A)RHS values for constraints must be integer
B)objective function coefficients must be integer
C)constraint coefficients must be integer
D)decision variables must be integer
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
18
How are binary variables specified in the Analytic Solver Platform ASP)?

A)By replacing RHS values in constraints with 0 or 1.
B)By specifying changing cells as INTEGER and as non-negative.
C)By specifying changing cells as BINARY in the Variable Type/Bound area of ASP.
D)By selecting Assume Binary Model in the ASP Options dialog box.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
19
Consider the constraint
X3 + X4 + X5 + X6 + X7 ≥ 27
Representing Air Express' Monday minimum worker requirement.Why was a "≥" used versus an "="?

A)The "≥" is needed to accommodate workers held over from Sunday.
B)Solver only accepts "≥" constraints.
C)The "≥" is less restrictive.
D)The "=" will always produce an infeasible constraint.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
20
The B & B algorithm solves ILP problems

A)by solving for each variable separately.
B)by solving for the integer variables first.
C)by solving a series of LP problems.
D)by solving smaller ILP problems.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
21
A company is developing its weekly production plan.The company produces two products,A and B,which are processed in two departments.Setting up each batch of A requires $60 of labor while setting up a batch of B costs $80.Each unit of A generates a profit of $17 while a unit of B earns a profit of $21.The company can sell all the units it produces.The data for the problem are summarized below.
Hours required by
 Operation  A  B  Hours  Cutting 3448 Welding 2136\begin{array} { r c c c } \text { Operation } & \text { A } & \text { B } & \text { Hours } \\\hline \text { Cutting } & 3 & 4 & 48 \\\text { Welding } & 2 & 1 & 36\end{array}
The decision variables are defined as
Xi = the amount of product i produced Yi = 1 if Xi > 0 and 0 if Xi = 0
Which of the following constraints creates the link between setting up to produce A's and making some A's for this problem?

A)X1 ? 16Y1 b.X1 ? Y1 = 0
B)X1 ? 18Y1 > 0
C)= ifX1 > 0,Y1 = 1,Y1 = 0)
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
22
A company will be able to obtain a quantity discount on component parts for its three products,X1,X2 and X3 if it produces beyond certain limits.To get the X1 discount it must produce more than 50 X1's.It must produce more than 60 X2's for the X2 discount and 70 X3's for the X3 discount.How many decision variables are required in the formulation of this problem?

A)3
B)6
C)9
D)12
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
23
A company will be able to obtain a quantity discount on component parts for its three products,X1,X2 and X3 if it produces beyond certain limits.To get the X1 discount it must produce more than 50 X1's.It must produce more than 60 X2's for the X2 discount and 70 X3's for the X3 discount.Which of the following pair of constraints enforces the quantity discount relationship on X3?

A)X31 ≤ M3Y3,X32 ≥ 50Y3 b.X31 ≤ M3Y3,X31 ≥ 50
C)X32 ≥ 1/50)X31,X31 ≤ 50
D)X32 ≤ M3Y3,X31 ≥ 50Y3
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
24
A manufacturing company has costs associated with production preparation and with per unit production.The per unit production costs are referred to as

A)decision variables.
B)production cost constraint coefficients.
C)variable costs.
D)marginal costs.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
25
A company will be able to obtain a quantity discount on component parts for its three products,X1,X2 and X3 if it produces beyond certain limits.To get the X1 discount it must produce more than 50 X1's.It must produce more than 60 X2's for the X2 discount and 70 X3's for the X3 discount.How many binary variables are required in the formulation of this problem?

A)3
B)6
C)9
D)12
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
26
If a company produces Product 1,then it must produce at least 150 units of Product 1.Which of the following constraints enforces this condition?

A)X1 ≤ 150Y1
B)X1 − 150Y1 ≥ 0
C)X1Y1 ≤ 150
D)X1 ≥ 150 + Y1
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
27
A company wants to select 1 project from a set of 4 possible projects.Which of the following constraints ensures that only 1 will be selected?

A)X1 + X2 + X3 + X4 = 1
B)X1 + X2 + X3 + X4 ≤ 1
C)X1 + X2 + X3 + X4 ≥ 1
D)X1 + X2 + X3 + X4 ≥ 0
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
28
If a company selects either of Project 1 or Project 2 or both),then either Project 3 or Project 4 or both)must also be selected.Which of the following constraints enforce this condition?

A)X1 + X2 ≤ 2X3 + X4)
B)X1 + X2 ≤ X3 + X4
C)X1 − X3 = X2 − X4
D)X1 + X2 + X3 + X4 ≤ 2
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
29
A company is developing its weekly production plan.The company produces two products,A and B,which are processed in two departments.Setting up each batch of A requires $60 of labor while setting up a batch of B costs
$80)Each unit of A generates a profit of $17 while a unit of B earns a profit of $21.The company can sell all the units it produces.The data for the problem are summarized below.
Hours required by
 Operation  A  B  Hours  Cutting 3448 Welding 2136\begin{array} { r c c c } \text { Operation } & \text { A } & \text { B } & \text { Hours } \\\hline \text { Cutting } & 3 & 4 & 48 \\\text { Welding } & 2 & 1 & 36\end{array}
The decision variables are defined as
Xi = the amount of product i produced Yi = 1 if Xi > 0 and 0 if Xi = 0
What is the objective function for this problem?

A)MAX: 17 X1 + 21 X2
B)MAX: 17 X1 + 21 X2 ? 60 Y1 ? 80 Y2
C)MIN: 17 X1 + 21 X2 ? 60 Y1 ? 80 Y2 d.MIN: 60 Y1 + 80 Y2
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
30
The setup cost incurred in preparing a machine to produce a batch of product is an example of a

A)fixed charge.
B)random charge.
C)sunk cost.
D)variable cost.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
31
The branch-and-bound algorithm starts by

A)relaxing all the integrality conditions in an ILP and solving the resulting LP problem.
B)relaxing all the RHS values in an ILP and solving the resulting LP problem.
C)solving two LP problems in which X1 is set at 0 and 1 respectively.
D)determining the most likely RHS values and solving for them.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
32
A company is developing its weekly production plan.The company produces two products,A and B,which are processed in two departments.Setting up each batch of A requires $60 of labor while setting up a batch of B costs $80.Each unit of A generates a profit of $17 while a unit of B earns a profit of $21.The company can sell all the units it produces.The data for the problem are summarized below.
Hours required by
 Operation  A  B  Hours  Cutting 3448 Welding 2136\begin{array} { r c c c } \text { Operation } & \text { A } & \text { B } & \text { Hours } \\\hline \text { Cutting } & 3 & 4 & 48 \\\text { Welding } & 2 & 1 & 36\end{array}
What is the appropriate formula to use in cell B15 of the following Excel implementation of the ILP model for this problem?
 <strong>A company is developing its weekly production plan.The company produces two products,A and B,which are processed in two departments.Setting up each batch of A requires $60 of labor while setting up a batch of B costs $80.Each unit of A generates a profit of $17 while a unit of B earns a profit of $21.The company can sell all the units it produces.The data for the problem are summarized below. Hours required by  \begin{array} { r c c c } \text { Operation } & \text { A } & \text { B } & \text { Hours } \\ \hline \text { Cutting } & 3 & 4 & 48 \\ \text { Welding } & 2 & 1 & 36 \end{array}  What is the appropriate formula to use in cell B15 of the following Excel implementation of the ILP model for this problem?  </strong> A)=B5 ? MIN$E$11/B11,$E$11/C11)*B14 B)=B5 ? MIN$E$11/B11,$E$12/B12) C)=B5 ? $E$12/B12*B14 D)=B5 ? MIN$E$11/B11,$E$12/B12)*B14

A)=B5 ? MIN$E$11/B11,$E$11/C11)*B14
B)=B5 ? MIN$E$11/B11,$E$12/B12)
C)=B5 ? $E$12/B12*B14
D)=B5 ? MIN$E$11/B11,$E$12/B12)*B14
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
33
A company is developing its weekly production plan.The company produces two products,A and B,which are processed in two departments.Setting up each batch of A requires $60 of labor while setting up a batch of B costs $80.Each unit of A generates a profit of $17 while a unit of B earns a profit of $21.The company can sell all the units it produces.The data for the problem are summarized below.
Hours required by
 Operation  A  B  Hours  Cutting 3448 Welding 2136\begin{array} { r c c c } \text { Operation } & \text { A } & \text { B } & \text { Hours } \\\hline \text { Cutting } & 3 & 4 & 48 \\\text { Welding } & 2 & 1 & 36\end{array}
The decision variables are defined as
Xi = the amount of product i produced Yi = 1 if Xi > 0 and 0 if Xi = 0
Using the approach discussed in the text,what is the appropriate value for M1 in the linking constraint for product A?

A)2
B)3
C)16
D)12
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
34
A company is planning next month's production.It has to pay a setup cost to produce a batch of X4's so if it does produce a batch it wants to produce at least 100 units.Which of the following pairs of constraints show the relationships)between the setup variable Y4 and the production quantity variable X4?

A)X4 ≤ M4Y4,X4 ≥ 100
B)X4 ≤ M4Y4,X4 = 100 Y4 c.X4 ≤ M4Y4,X4 ≥ 100 Y4 d.X4 ≤ M4Y4,X4 ≤ 100 Y4
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
35
If a company selects Project 1 then it must also select either Project 2 or Project 3.Which of the following constraints enforces this condition?

A)X1 − X2 − X3 ≥ 0
B)X1 + X2 − X3)≤ 0
C)X1 + X2 + X3 ≤ 2
D)X1 − X2 − X3 ≤ 0
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
36
Any integer variable in an ILP that assumes a fractional value in the optimal solution to the relaxed LP problem can be designated

A)a diverging variable.
B)a branching variable.
C)a bifurcating variable.
D)a splitting variable.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
37
A production company wants to ensure that if Product 1 is produced,production of Product 1 not exceed production of Product 2.Which of the following constraints enforce this condition?

A)X1 ≥ M2Y2
B)X1 ≤ M2X2
C)X1 ≤ M1Y1,X1 ≤ Y1X2
D)X1 ≤ X2
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
38
A wedding caterer has several wine shops from which it can order champagne.The caterer needs 100 bottles of champagne on a particular weekend for 2 weddings.The first supplier can supply either 40 bottles or 90 bottles.
The relevant decision variable is defined as
X1 = the number of bottles supplied by supplier 1
Which set of constraints reflects the fact that supplier 1 can supply only 40 or 90 bottles?

A)X1 ≤ 40 Y11,X1 ≤ 901 − Y11)
B)X1 = 40Y11 + 90Y12,Y11 + Y12 ≤ 1
C)X1 = 40Y1 + 901 − Y1),Y1 = 0 OR 1
D)X1 = 40Y11 + 90Y12,Y11 + Y12 = 1
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
39
A company is developing its weekly production plan.The company produces two products,A and B,which are processed in two departments.Setting up each batch of A requires $60 of labor while setting up a batch of B costs $80.Each unit of A generates a profit of $17 while a unit of B earns a profit of $21.The company can sell all the units it produces.The data for the problem are summarized below.
Hours required by
 Operation  A  B  Hours  Cutting 3448 Welding 2136\begin{array} { r c c c } \text { Operation } & \text { A } & \text { B } & \text { Hours } \\\hline \text { Cutting } & 3 & 4 & 48 \\\text { Welding } & 2 & 1 & 36\end{array}
What is the appropriate formula to use in cell E8 of the following Excel implementation of the ILP model for this problem?
 <strong>A company is developing its weekly production plan.The company produces two products,A and B,which are processed in two departments.Setting up each batch of A requires $60 of labor while setting up a batch of B costs $80.Each unit of A generates a profit of $17 while a unit of B earns a profit of $21.The company can sell all the units it produces.The data for the problem are summarized below. Hours required by  \begin{array} { r c c c } \text { Operation } & \text { A } & \text { B } & \text { Hours } \\ \hline \text { Cutting } & 3 & 4 & 48 \\ \text { Welding } & 2 & 1 & 36 \end{array}  What is the appropriate formula to use in cell E8 of the following Excel implementation of the ILP model for this problem?  </strong> A)=SUMPRODUCTB5:C5,B7:C7)? SUMPRODUCTB8:C8,B14:C14) B)=SUMPRODUCTB8:C8,B14:C14)? SUMPRODUCTB5:C5,B7:C7) C)=SUMPRODUCTB5:C5,B7:C7)? B8:C8 D)=SUMPRODUCTB5:C5,B7:C7)? SUMPRODUCTB8:C8,B15:C15)

A)=SUMPRODUCTB5:C5,B7:C7)? SUMPRODUCTB8:C8,B14:C14)
B)=SUMPRODUCTB8:C8,B14:C14)? SUMPRODUCTB5:C5,B7:C7)
C)=SUMPRODUCTB5:C5,B7:C7)? B8:C8
D)=SUMPRODUCTB5:C5,B7:C7)? SUMPRODUCTB8:C8,B15:C15)
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
40
A company must invest in project 1 in order to invest in project 2.Which of the following constraints ensures that project 1 will be chosen if project 2 is invested in?

A)X1 + X2 = 0
B)X1 + X2 = 1
C)X1 − X2 ≥ 0
D)X1 − X2 ≤ 0
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
41
A city wants to locate 2 new fire fighting ladder trucks to maximize the number of tall buildings which they can cover within a 3 minute response time.The city is divided into 4 zones.The fire chief wants to locate no more than one of the trucks in either Zone 1 or Zone 2.The number of tall buildings in each zone and the travel time between zones is listed below.
 To zone  No. tall buildings  Fram zone 12345010216902204560314017046510\begin{array}{c}\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\text { To zone }\\\begin{array} { c c c c c c } \text { No. tall buildings } & \text { Fram zone } & 1 & 2 & 3 & 4 \\\hline 50 & 1 & 0 & 2 & 1 & 6 \\90 & 2 & 2 & 0 & 4 & 5 \\60 & 3 & 1 & 4 & 0 & 1 \\70 & 4 & 6 & 5 & 1 & 0\end{array}\end{array}
Based on this ILP formulation of the problem what values should go in cells B5:G24 of the following Excel spreadsheet?
Let Xi = 1 if truck located in zone i,0 otherwise
 Zone  Covers these zones  With the many building 11,2,320021,214031,3,418043,4130\begin{array} { c c c } \text { Zone } & \text { Covers these zones } & \text { With the many building } \\\hline 1 & 1,2,3 & 200 \\2 & 1,2 & 140 \\3 & 1,3,4 & 180 \\4 & 3,4 & 130\end{array}
MAX: 200 X1 + 140 X2 + 180 X3 + 130 X4
Subject to: X1 + X2 + X3 + X4 = 2
X1 + X2 ? 1
Xi = 0,1
 A city wants to locate 2 new fire fighting ladder trucks to maximize the number of tall buildings which they can cover within a 3 minute response time.The city is divided into 4 zones.The fire chief wants to locate no more than one of the trucks in either Zone 1 or Zone 2.The number of tall buildings in each zone and the travel time between zones is listed below.  \begin{array}{c} \quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\text { To zone }\\ \begin{array} { c c c c c c } \text { No. tall buildings } & \text { Fram zone } & 1 & 2 & 3 & 4 \\ \hline 50 & 1 & 0 & 2 & 1 & 6 \\ 90 & 2 & 2 & 0 & 4 & 5 \\ 60 & 3 & 1 & 4 & 0 & 1 \\ 70 & 4 & 6 & 5 & 1 & 0 \end{array} \end{array}  Based on this ILP formulation of the problem what values should go in cells B5:G24 of the following Excel spreadsheet? Let X<sub>i </sub>= 1 if truck located in zone i,0 otherwise  \begin{array} { c c c } \text { Zone } & \text { Covers these zones } & \text { With the many building } \\ \hline 1 & 1,2,3 & 200 \\ 2 & 1,2 & 140 \\ 3 & 1,3,4 & 180 \\ 4 & 3,4 & 130 \end{array}  MAX: <sup>200 X</sup><sub>1 </sub><sup>+ 140 X</sup><sub>2 </sub><sup>+ 180 X</sup><sub>3 </sub><sup>+ 130 X</sup><sub>4</sub> Subject to: <sup>X</sup><sub>1 </sub><sup>+ X</sup><sub>2 </sub><sup>+ X</sup><sub>3 </sub><sup>+ X</sup><sub>4 </sub><sup>= 2</sup> X<sub>1 </sub>+ X<sub>2 </sub>? 1 X<sub>i </sub>= 0,1
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
42
Exhibit 6.1
The following questions pertain to the problem,formulation,and spreadsheet implementation below.
A research director must pick a subset of research projects to fund over the next five years.He has five candidate projects,not all of which cover the entire five-year period.Although the director has limited funds in each of the next five years,he can carry over unspent research funds into the next year.Additionally,up to $30K can be carried out of the five-year planning period.The following table summarizes the projects and budget available to the research director.
Project Funds Required in $000s)Benefit
 Project 12345 in $000s)1$70$40$30$15$15$1602$82$35$20$20$10$1903$55$10$10$5$1254$69$17$15$12$8$1395$75$20$25$30$45$174\begin{array}{ccccccc}\text { Project } & 1 & 2 & 3 & 4 & 5 & \text { in } \$ 000 s) \\\hline 1 & \$ 70 & \$ 40 & \$ 30 & \$ 15 & \$ 15 & \$ 160 \\2 & \$ 82 & \$ 35 & \$ 20 & \$ 20 & \$ 10 & \$ 190 \\3 & \$ 55 & \$ 10 & \$ 10 & \$ 5 & & \$ 125 \\4 & \$ 69 & \$ 17 & \$ 15 & \$ 12 & \$ 8 & \$ 139 \\5 & \$ 75 & \$ 20 & \$ 25 & \$ 30 & \$ 45 & \$ 174 \\\hline\end{array}
Budget $225K $60K $60K $50K $50K The following is the ILP formulation and a spreadsheet model for the problem.
Let Xi = 0 if project i not selected,1 if project i selected for i = 1,2,3,4,5
Cj = amount carried out of year j,j = 1,2,3,4,5
MAX 160X1 + 190X2 + 125X3 +139X4 + 174X5 Subject to: 70X1 + 82X2 + 55X3 + 69X4 + 75X5 + C1 = 225
40X1 + 35X2 + 10X3 + 17X4 + 20X5 + C2 = 60 + C1
30X1 + 20X2 + 10X3 + 15X4 + 25X5 + C3 = 60 + C2
15X1 + 20X2 + 5X3 + 12X4 + 30X5 + C4 = 50 + C3
15X1 + 10X2 + 8X4 + 45X5 + C5 = 50 + C4 C5 ? 30
Xi binary,C1,C2,C3,C4,C5 ? 0
 Exhibit 6.1 The following questions pertain to the problem,formulation,and spreadsheet implementation below. A research director must pick a subset of research projects to fund over the next five years.He has five candidate projects,not all of which cover the entire five-year period.Although the director has limited funds in each of the next five years,he can carry over unspent research funds into the next year.Additionally,up to $30K can be carried out of the five-year planning period.The following table summarizes the projects and budget available to the research director. Project Funds Required in $000s)Benefit  \begin{array}{ccccccc} \text { Project } & 1 & 2 & 3 & 4 & 5 & \text { in } \$ 000 s) \\ \hline 1 & \$ 70 & \$ 40 & \$ 30 & \$ 15 & \$ 15 & \$ 160 \\ 2 & \$ 82 & \$ 35 & \$ 20 & \$ 20 & \$ 10 & \$ 190 \\ 3 & \$ 55 & \$ 10 & \$ 10 & \$ 5 & & \$ 125 \\ 4 & \$ 69 & \$ 17 & \$ 15 & \$ 12 & \$ 8 & \$ 139 \\ 5 & \$ 75 & \$ 20 & \$ 25 & \$ 30 & \$ 45 & \$ 174 \\ \hline \end{array}  Budget $225K $60K $60K $50K $50K The following is the ILP formulation and a spreadsheet model for the problem. Let <sup>X</sup><sub>i </sub><sup>= 0 if project i not selected,1 if project i selected for i = 1,2,3,4,5</sup> C<sub>j </sub>= amount carried out of year j,j = 1,2,3,4,5 MAX <sup>160X</sup><sub>1 </sub><sup>+ 190X</sup><sub>2 </sub><sup>+ 125X</sup><sub>3 </sub><sup>+139X</sup><sub>4 </sub><sup>+ 174X</sup><sub>5 </sub>Subject to: <sup>70X</sup><sub>1 </sub><sup>+ 82X</sup><sub>2 </sub><sup>+ 55X</sup><sub>3 </sub><sup>+ 69X</sup><sub>4 </sub><sup>+ 75X</sup><sub>5 </sub><sup>+ C</sup><sub>1 </sub><sup>= 225</sup> 40X<sub>1 </sub>+ 35X<sub>2 </sub>+ 10X<sub>3 </sub>+ 17X<sub>4 </sub>+ 20X<sub>5 </sub>+ C<sub>2 </sub>= 60 + C<sub>1</sub> 30X<sub>1 </sub>+ 20X<sub>2 </sub>+ 10X<sub>3 </sub>+ 15X<sub>4 </sub>+ 25X<sub>5 </sub>+ C<sub>3 </sub>= 60 + C<sub>2</sub> 15X<sub>1 </sub>+ 20X<sub>2 </sub>+ 5X<sub>3 </sub>+ 12X<sub>4 </sub>+ 30X<sub>5 </sub>+ C<sub>4 </sub>= 50 + C<sub>3</sub> 15X<sub>1 </sub>+ 10X<sub>2 </sub>+ 8X<sub>4 </sub>+ 45X<sub>5 </sub>+ C<sub>5 </sub>= 50 + C<sub>4 </sub>C<sub>5 </sub>? 30 X<sub>i </sub>binary,C<sub>1</sub>,C<sub>2</sub>,C<sub>3</sub>,C<sub>4</sub>,C<sub>5 </sub>? 0    -Refer to Exhibit 6.1.What formula should go in cell D15 of the above Excel spreadsheet?

-Refer to Exhibit 6.1.What formula should go in cell D15 of the above Excel spreadsheet?
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
43
An investor has $500,000 to invest and wants to maximize the money they will receive at the end of one year.They can invest in condos,apartments and houses.The profit after one year,the cost and the number of units available are shown below.
 Profit Cost  Number  Variable  Investment $1,000)$1,000) Available X1 Condos 65010X2 Apartments 12905X3 Houses 91007\begin{array}{rrrrr}&&\text { Profit}&\text { Cost }&\text { Number }\\\text { Variable } & \text { Investment } & \$ 1,000) & \$ 1,000) & \text { Available } \\\hline \mathrm{X}_{1} & \text { Condos } & 6 & 50 & 10 \\\mathrm{X}_{2} & \text { Apartments } & 12 & 90 & 5 \\\mathrm{X}_{3} & \text { Houses } & 9 & 100 & 7\end{array}
Based on this ILP formulation of the problem and the indicated optimal integer solution values what values should go in cells B5:F12 of the following Excel spreadsheet?
MAX: 6 X1 + 12 X2 + 9 X3
Subject to: 50 X1 + 90 X2 + 100 X3 ? 500
X1 ? 10
X2 ? 5
X3 ? 7
Xi ? 0 and integer
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
44
A city wants to locate 2 new fire fighting ladder trucks to maximize the number of tall buildings which they can cover within a 3 minute response time.The city is divided into 4 zones.The fire chief wants to locate no more than one of the trucks in either Zone 1 or Zone 2.The number of tall buildings in each zone and the travel time between zones is listed below.
Formulate the ILP for this problem.
 To zone  No. tall buildings  Fram zone 12345010216902204560314017046510\begin{array}{c}\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad \text { To zone }\\\begin{array} { c c c c c c } \text { No. tall buildings } & \text { Fram zone } & 1 & 2 & 3 & 4 \\\hline 50 & 1 & 0 & 2 & 1 & 6 \\90 & 2 & 2 & 0 & 4 & 5 \\60 & 3 & 1 & 4 & 0 & 1 \\70 & 4 & 6 & 5 & 1 & 0\end{array}\end{array}
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
45
Exhibit 6.1
The following questions pertain to the problem,formulation,and spreadsheet implementation below.
A research director must pick a subset of research projects to fund over the next five years.He has five candidate projects,not all of which cover the entire five-year period.Although the director has limited funds in each of the next five years,he can carry over unspent research funds into the next year.Additionally,up to $30K can be carried out of the five-year planning period.The following table summarizes the projects and budget available to the research director.
Project Funds Required in $000s)Benefit
 Project 12345 in $000s)1$70$40$30$15$15$1602$82$35$20$20$10$1903$55$10$10$5$1254$69$17$15$12$8$1395$75$20$25$30$45$174\begin{array}{ccccccc}\text { Project } & 1 & 2 & 3 & 4 & 5 & \text { in } \$ 000 s) \\\hline 1 & \$ 70 & \$ 40 & \$ 30 & \$ 15 & \$ 15 & \$ 160 \\2 & \$ 82 & \$ 35 & \$ 20 & \$ 20 & \$ 10 & \$ 190 \\3 & \$ 55 & \$ 10 & \$ 10 & \$ 5 & & \$ 125 \\4 & \$ 69 & \$ 17 & \$ 15 & \$ 12 & \$ 8 & \$ 139 \\5 & \$ 75 & \$ 20 & \$ 25 & \$ 30 & \$ 45 & \$ 174 \\\hline\end{array}
Budget $225K $60K $60K $50K $50K The following is the ILP formulation and a spreadsheet model for the problem.
 Exhibit 6.1 The following questions pertain to the problem,formulation,and spreadsheet implementation below. A research director must pick a subset of research projects to fund over the next five years.He has five candidate projects,not all of which cover the entire five-year period.Although the director has limited funds in each of the next five years,he can carry over unspent research funds into the next year.Additionally,up to $30K can be carried out of the five-year planning period.The following table summarizes the projects and budget available to the research director. Project Funds Required in $000s)Benefit  \begin{array}{ccccccc} \text { Project } & 1 & 2 & 3 & 4 & 5 & \text { in } \$ 000 s) \\ \hline 1 & \$ 70 & \$ 40 & \$ 30 & \$ 15 & \$ 15 & \$ 160 \\ 2 & \$ 82 & \$ 35 & \$ 20 & \$ 20 & \$ 10 & \$ 190 \\ 3 & \$ 55 & \$ 10 & \$ 10 & \$ 5 & & \$ 125 \\ 4 & \$ 69 & \$ 17 & \$ 15 & \$ 12 & \$ 8 & \$ 139 \\ 5 & \$ 75 & \$ 20 & \$ 25 & \$ 30 & \$ 45 & \$ 174 \\ \hline \end{array}  Budget $225K $60K $60K $50K $50K The following is the ILP formulation and a spreadsheet model for the problem.      -Refer to Exhibit 6.1.What values would you enter in the Analytic Solver Platform task pane for the above Excel spreadsheet? Objective Cell: Variables Cells: Constraints Cells:
 Exhibit 6.1 The following questions pertain to the problem,formulation,and spreadsheet implementation below. A research director must pick a subset of research projects to fund over the next five years.He has five candidate projects,not all of which cover the entire five-year period.Although the director has limited funds in each of the next five years,he can carry over unspent research funds into the next year.Additionally,up to $30K can be carried out of the five-year planning period.The following table summarizes the projects and budget available to the research director. Project Funds Required in $000s)Benefit  \begin{array}{ccccccc} \text { Project } & 1 & 2 & 3 & 4 & 5 & \text { in } \$ 000 s) \\ \hline 1 & \$ 70 & \$ 40 & \$ 30 & \$ 15 & \$ 15 & \$ 160 \\ 2 & \$ 82 & \$ 35 & \$ 20 & \$ 20 & \$ 10 & \$ 190 \\ 3 & \$ 55 & \$ 10 & \$ 10 & \$ 5 & & \$ 125 \\ 4 & \$ 69 & \$ 17 & \$ 15 & \$ 12 & \$ 8 & \$ 139 \\ 5 & \$ 75 & \$ 20 & \$ 25 & \$ 30 & \$ 45 & \$ 174 \\ \hline \end{array}  Budget $225K $60K $60K $50K $50K The following is the ILP formulation and a spreadsheet model for the problem.      -Refer to Exhibit 6.1.What values would you enter in the Analytic Solver Platform task pane for the above Excel spreadsheet? Objective Cell: Variables Cells: Constraints Cells:

-Refer to Exhibit 6.1.What values would you enter in the Analytic Solver Platform task pane for the above Excel spreadsheet?
Objective Cell: Variables Cells: Constraints Cells:
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
46
A small town wants to build some new recreational facilities.The proposed facilities include a swimming pool,recreation center,basketball court and baseball field.The town council wants to provide the facilities which will be used by the most people,but faces budget and land limitations.The town has $400,000 and 14 acres of land.The pool requires locker facilities which would be in the recreation center,so if the swimming pool is built the recreation center must also be built.Also the council has only enough flat land to build the basketball court or the baseball field.The daily usage and cost of the facilities in $1,000)are shown below.
Formulate the ILP for this problem.
 Variable  Facilty  Usage  Cost $1,000)  Land x1 Swimruine pool 4001002x2 Recreation center 5002003x3 Basketball court 3001504x4 Baseball field 2001005\begin{array} { r r r r r } \text { Variable } & \text { Facilty } & \text { Usage } & \text { Cost \$1,000) } & \text { Land } \\\hline \mathbf { x } _ { 1 } & \text { Swimruine pool } & 400 & 100 & 2 \\\mathbf { x } _ { 2 } & \text { Recreation center } & 500 & 200 & 3 \\\mathbf { x } _ { 3 } & \text { Basketball court } & 300 & 150 & 4 \\\mathbf { x } _ { 4 } & \text { Baseball field } & 200 & 100 & 5\end{array}
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
47
A company wants to build a new factory in either Atlanta or Columbia.It is also considering building a warehouse in whichever city is selected for the new factory.The following table shows the net present value NPV)and cost of each facility.The company wants to maximize the net present value of its facilities,but it only has $16 million to invest.
Variable Decision
NPV
$million)
Cost $million)
X1 Factory in Columbia 3 10
X2 Factory in Atlanta 4 8
X3 Warehouse in Columbia 2 6
X4 Warehouse in Atlanta 1 5
Based on this ILP formulation of the problem and the indicated optimal solution what formulas should go in cells F6:F14 of the following Excel spreadsheet?
MAX: 3 X1 + 4 X2 + 2 X3 + X4
Subject to: 10 X1 + 8 X2 + 6 X3 + 5 X4 ≤ 15
X1 + X2 = 1 X3 + X4 ≤ 1 X3 − X1 ≤ 0 X4 − X2 ≤ 0 Xi = 0,1
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
48
The optimal relaxed solution for an ILP has X1 = 3.6 and X2 = 2.9.If we branch on X1,what constraints must be added to the two resulting LP problems?

A)X1 ≥ 3,X1 ≥ 4
B)X1 = 4
C)3 ≤ X1,X1 ≤ 4
D)X1 ≤ 3,X1 ≥ 4
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
49
A company wants to build a new factory in either Atlanta or Columbia.It is also considering building a warehouse in whichever city is selected for the new factory.The following table shows the net present value NPV)and cost of each facility.The company wants to maximize the net present value of its facilities,but it only has $15 million to invest.
Formulate the ILP for this problem.
Variable Decision
NPV
$million)
Cost $million)
X1 Factory in Columbia 3 10
X2 Factory in Atlanta 4 8
X3 Warehouse in Columbia 2 6
X4 Warehouse in Atlanta 1 5
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
50
A sub-problem in a B & B is solved and found infeasible.Should the B & B algorithm continue further analysis on this candidate problem?

A)Yes,a feasible solution may be found when additional constraints are added.
B)Yes,removing a constraint in further analysis may restore feasibility.
C)No,adding more constraints will not restore problem feasibility.
D)No,the result cannot occur so re-examine the formulation and start over.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
51
A company has four projects,numbered 1 through 4.If any project is selected for implementation,each lower- numbered project must also be selected for implementation.Formulate the constraints to enforce these conditions.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
52
A company wants to build a new factory in either Atlanta or Columbia.It is also considering building a warehouse in whichever city is selected for the new factory.The following table shows the net present value NPV)and cost of each facility.The company wants to maximize the net present value of its facilities,but it only has $15 million to invest.
Variable Decision
NPV
$million)
Cost $million)
X1 Factory in Columbia 3 10
X2 Factory in Atlanta 4 8
X3 Warehouse in Columbia 2 6
X4 Warehouse in Atlanta 1 5
Based on this ILP formulation of the problem and the indicated optimal solution what values should go in cells B6:G14 of the following Excel spreadsheet?
MAX: 3 X1 + 4 X2 + 2 X3 + X4
Subject to: 10 X1 + 8 X2 + 6 X3 + 5 X4 ≤ 15
X1 + X2 = 1 X3 + X4 ≤ 1 X3 − X1 ≤ 0 X4 − X2 ≤ 0
Xi = 0,1
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
53
A company wants to build a new factory in either Atlanta or Columbia.It is also considering building a warehouse in whichever city is selected for the new factory.The following table shows the net present value NPV)and cost of each facility.The company wants to maximize the net present value of its facilities,but it only has $16 million to invest.
Variable Decision
NPV
$million)
Cost $million)
X1 Factory in Columbia 3 10
X2 Factory in Atlanta 4 8
X3 Warehouse in Columbia 2 6
X4 Warehouse in Atlanta 1 5
Based on this ILP formulation of the problem what is the optimal solution to the problem?
MAX: 3 X1 + 4 X2 + 2 X3 + X4
Subject to: 10 X1 + 8 X2 + 6 X3 + 5 X4 ≤ 15
X1 + X2 = 1 X3 + X4 ≤ 1 X3 − X1 ≤ 0 X4 − X2 ≤ 0 Xi = 0,1
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
54
An investor has $500,000 to invest and wants to maximize the money they will receive at the end of one year.They can invest in condos,apartments and houses.The profit after one year,the cost and the number of units available are shown below.
 Profit  Cost  Number  Variable  Investment $1,000)$1,000) Available X1 Condos 65010X2 Apartments 12905X3 Houses 91nn7\begin{array}{rrrrr}&&\text { Profit } & \text { Cost } & \text { Number } \\\text { Variable } & \text { Investment } &\$ 1,000)&\$ 1,000) & \text { Available }\\\hline \mathrm{X} 1 & \text { Condos } & 6 & 50 & 10 \\\mathrm{X} 2 & \text { Apartments } & 12 & 90 & 5 \\\mathrm{X} 3 & \text { Houses } & 9 & 1 \mathrm{nn} & 7\end{array}
Based on this ILP formulation of the problem what formulas should go in cells E5:E12 of the following Excel spreadsheet?
MAX: 6 X1 + 12 X2 + 9 X3
Subject to: 50 X1 + 90 X2 + 100 X3 ? 500
X1 ? 10
X2 ? 5
X3 ? 7
Xi ? 0 and integer
 An investor has $500,000 to invest and wants to maximize the money they will receive at the end of one year.They can invest in condos,apartments and houses.The profit after one year,the cost and the number of units available are shown below.  \begin{array}{rrrrr} &&\text { Profit } &  \text { Cost } & \text { Number } \\ \text { Variable } & \text { Investment } &\$ 1,000)&\$ 1,000)   & \text { Available }\\ \hline \mathrm{X} 1 & \text { Condos } & 6 & 50 & 10 \\ \mathrm{X} 2 & \text { Apartments } & 12 & 90 & 5 \\ \mathrm{X} 3 & \text { Houses } & 9 & 1 \mathrm{nn} & 7 \end{array}  Based on this ILP formulation of the problem what formulas should go in cells E5:E12 of the following Excel spreadsheet? MAX: <sup>6 X</sup><sub>1 </sub><sup>+ 12 X</sup><sub>2 </sub><sup>+ 9 X</sup><sub>3</sub> Subject to: <sup>50 X</sup><sub>1 </sub><sup>+ 90 X</sup><sub>2 </sub><sup>+ 100 X</sup><sub>3 </sub><sup>? 500</sup> X<sub>1 </sub>? 10 X<sub>2 </sub>? 5 X<sub>3 </sub>? 7 Xi ? 0 and integer
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
55
A company needs to hire workers to cover a 7 day work week.Employees work 5 consecutive days with 2 days off.The demand for workers by day of the week and the wages per shift are:
 Days af Week  Workers Required  Shift  Days off  Wage  Sunday 541 Sun a Man 900 Munday 502 Man a Tue 1000 Tuesday 363 Tue d Wed 1000 Wednestay 384 Wed a Thur 1000 Thursday 425 Thur a Fri 1000 Friday 406 Fri a Sat 900 Saturday 487 Sat a Sun 850\begin{array} { l c r r r } \text { Days af Week } & \text { Workers Required } & \text { Shift } & \text { Days off } & \text { Wage } \\\hline \text { Sunday } & 54 & 1 & \text { Sun a Man } & 900 \\\text { Munday } & 50 & 2 & \text { Man a Tue } & 1000 \\\text { Tuesday } & 36 & 3 & \text { Tue d Wed } & 1000 \\\text { Wednestay } & 38 & 4 & \text { Wed a Thur } & 1000 \\\text { Thursday } & 42 & 5 & \text { Thur a Fri } & 1000 \\\text { Friday } & 40 & 6 & \text { Fri a Sat } & 900 \\\text { Saturday } & 48 & 7 & \text { Sat a Sun } & 850\end{array}
Formulate the ILP for this problem.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
56
A small town wants to build some new recreational facilities.The proposed facilities include a swimming pool,recreation center,basketball court and baseball field.The town council wants to provide the facilities which will be used by the most people,but faces budget and land limitations.The town has $400,000 and 14 acres of land.The pool requires locker facilities which would be in the recreation center,so if the swimming pool is built the recreation center must also be built.Also the council has only enough flat land to build the basketball court or the baseball field.The daily usage and cost of the facilities in $1,000)are shown below.
 Variable  Facilty  Usage  Cost $1,000)  Land x1 Swimming pool 4001002x2 Recreation center 5002003x3 Basketball court 3001504x4 Baseball field 2001005\begin{array} { r r r r r } \text { Variable } & \text { Facilty } & \text { Usage } & \text { Cost \$1,000) } & \text { Land } \\\hline \mathbf { x } _ { 1 } & \text { Swimming pool } & 400 & 100 & 2 \\\mathbf { x } _ { 2 } & \text { Recreation center } & 500 & 200 & 3 \\\mathbf { x } _ { 3 } & \text { Basketball court } & 300 & 150 & 4 \\\mathbf { x } _ { 4 } & \text { Baseball field } & 200 & 100 & 5\end{array}
Based on this ILP formulation of the problem and the indicated optimal solution what values should go in cells
B5:G12 of the following Excel spreadsheet?
 MAX: 400x1+500x2+300x3+200x4 Subject ta: 100x1+200x2+150x3+100x4400 budget 2x1+3x2+4x3+5x414 land x1x20 pool and recreation center x3+x41 basketball and baseball x1=0.1\begin{array} { l l l } \text { MAX: } & 400 \mathbf { x } _ { 1 } + 500 \mathbf { x } _ { 2 } + 300 \mathbf { x } _ { 3 } + 200 \mathbf { x } _ { 4 } & \\\text { Subject ta: } & 100 \mathbf { x } _ { 1 } + 200 \mathbf { x } _ { 2 } + 150 \mathbf { x } _ { 3 } + 100 \mathbf { x } _ { 4 } \leq 400 & \text { budget } \\& 2 \mathbf { x } _ { 1 } + 3 \mathbf { x } _ { 2 } + 4 \mathbf { x } _ { 3 } + 5 \mathbf { x } _ { 4 } \leq 14 & \text { land } \\& \mathbf { x } _ { 1 } - \mathbf { x } _ { 2 } \leq 0 & \text { pool and recreation center } \\& \mathbf { x } _ { 3 } + \mathbf { x } _ { 4 } \leq 1 & \text { basketball and baseball } \\& \mathbf { x } _ { 1 } = 0.1 &\end{array}
Solution: x1,x2,x3,X4)=1,1,0,1\left. \mathbf { x } _ { 1 } , \mathbf { x } _ { 2 } , \mathbf { x } _ { 3 } , \mathbf { X } _ { 4 } \right) = 1,1,0,1 )
 A small town wants to build some new recreational facilities.The proposed facilities include a swimming pool,recreation center,basketball court and baseball field.The town council wants to provide the facilities which will be used by the most people,but faces budget and land limitations.The town has $400,000 and 14 acres of land.The pool requires locker facilities which would be in the recreation center,so if the swimming pool is built the recreation center must also be built.Also the council has only enough flat land to build the basketball court or the baseball field.The daily usage and cost of the facilities in $1,000)are shown below.  \begin{array} { r r r r r } \text { Variable } & \text { Facilty } & \text { Usage } & \text { Cost \$1,000) } & \text { Land } \\ \hline \mathbf { x } _ { 1 } & \text { Swimming pool } & 400 & 100 & 2 \\ \mathbf { x } _ { 2 } & \text { Recreation center } & 500 & 200 & 3 \\ \mathbf { x } _ { 3 } & \text { Basketball court } & 300 & 150 & 4 \\ \mathbf { x } _ { 4 } & \text { Baseball field } & 200 & 100 & 5 \end{array}  Based on this ILP formulation of the problem and the indicated optimal solution what values should go in cells B5:G12 of the following Excel spreadsheet?  \begin{array} { l l l } \text { MAX: } & 400 \mathbf { x } _ { 1 } + 500 \mathbf { x } _ { 2 } + 300 \mathbf { x } _ { 3 } + 200 \mathbf { x } _ { 4 } & \\ \text { Subject ta: } & 100 \mathbf { x } _ { 1 } + 200 \mathbf { x } _ { 2 } + 150 \mathbf { x } _ { 3 } + 100 \mathbf { x } _ { 4 } \leq 400 & \text { budget } \\ & 2 \mathbf { x } _ { 1 } + 3 \mathbf { x } _ { 2 } + 4 \mathbf { x } _ { 3 } + 5 \mathbf { x } _ { 4 } \leq 14 & \text { land } \\ & \mathbf { x } _ { 1 } - \mathbf { x } _ { 2 } \leq 0 & \text { pool and recreation center } \\ & \mathbf { x } _ { 3 } + \mathbf { x } _ { 4 } \leq 1 & \text { basketball and baseball } \\ & \mathbf { x } _ { 1 } = 0.1 & \end{array}  Solution:  \left. \mathbf { x } _ { 1 } , \mathbf { x } _ { 2 } , \mathbf { x } _ { 3 } , \mathbf { X } _ { 4 } \right) = 1,1,0,1  )
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
57
A cellular phone company wants to locate two new communications towers to cover 4 regions.The company wants to minimize the cost of installing the two towers.The regions that can be covered by each tower site are indicated by a 1 in the following table:
Tower Sites
 Region 1234 A 11 B 111 C 111 D 11 COST $000 s) 200150190250\begin{array}{rrrrr}\text { Region } & 1 & 2 & 3 & 4 \\\hline \text { A } & & 1 & & 1 \\\text { B } & 1 & & 1 & 1 \\\text { C } & 1 & 1 & 1 & \\\text { D } & 1 & & &1 \\\hline \text { COST } \$ 000 \text { s) } & 200 & 150 & 190 & 250\end{array}

Formulate the ILP for this problem.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
58
An investor has $500,000 to invest and wants to maximize the money they will receive at the end of one year.They can invest in condos,apartments and houses.The profit after one year,the cost and the number of units available are shown below.
Formulate the ILP for this problem.
 Profit Cost  Number  Variable  Investment $1,000)$1,000) Available X1 Condos 65010X2 Apartments 12905X3 Houses 91007\begin{array}{rrrrr}&&\text { Profit}&\text { Cost }&\text { Number }\\\text { Variable } & \text { Investment } & \$ 1,000) & \$ 1,000) & \text { Available } \\\hline \mathrm{X}_{1} & \text { Condos } & 6 & 50 & 10 \\\mathrm{X}_{2} & \text { Apartments } & 12 & 90 & 5 \\\mathrm{X}_{3} & \text { Houses } & 9 & 100 & 7\end{array}
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
59
A cellular phone company wants to locate two new communications towers to cover 4 regions.The company wants to minimize the cost of installing the two towers.The regions that can be covered by each tower site are indicated by a 1 in the following table:
Tower Sites
 Region 1234 A 11 B 111 C 111 D 11 COST $000 s) 200150190250\begin{array}{rrrrr}\text { Region } & 1 & 2 & 3 & 4 \\\hline \text { A } & & 1 & & 1 \\\text { B } & 1 & & 1 & 1 \\\text { C } & 1 & 1 & 1 & \\\text { D } & 1 & & & 1\\\hline \text { COST } \$ 000 \text { s) } & 200 & 150 & 190 & 250\end{array}
MIN: 200 X1 + 150 X2 + 190 X3 + 250 X4
Subject to: X2 + X4 ? 1
X1 + X3 + X4 ? 1 X1 + X2 + X3 ? 1 X1 + X4 ? 1
X1 + X2 + X3 + X4 = 2 Xi = 0,1
Based on this ILP formulation of the problem and the solution X1,X2,X3,X4)= 1,1,0,0)what values should go in cells B6:G14 of the following Excel spreadsheet?
 A cellular phone company wants to locate two new communications towers to cover 4 regions.The company wants to minimize the cost of installing the two towers.The regions that can be covered by each tower site are indicated by a 1 in the following table: Tower Sites  \begin{array}{rrrrr} \text { Region } & 1 & 2 & 3 & 4 \\ \hline \text { A } & & 1 & & 1 \\ \text { B } & 1 & & 1 & 1 \\ \text { C } & 1 & 1 & 1 &  \\ \text { D } & 1 & & & 1\\ \hline \text { COST } \$ 000 \text { s) } & 200 & 150 & 190 & 250 \end{array}  MIN: <sup>200 X</sup><sub>1 </sub><sup>+ 150 X</sup><sub>2 </sub><sup>+ 190 X</sup><sub>3 </sub><sup>+ 250 X</sup><sub>4</sub> Subject to: <sup>X</sup><sub>2 </sub><sup>+ X</sup><sub>4 </sub><sup>? 1</sup> X<sub>1 </sub>+ X<sub>3 </sub>+ X<sub>4 </sub>? 1 X<sub>1 </sub>+ X<sub>2 </sub>+ X<sub>3 </sub>? 1 X<sub>1 </sub>+ X<sub>4 </sub>? 1 X<sub>1 </sub>+ X<sub>2 </sub>+ X<sub>3 </sub>+ X<sub>4 </sub>= 2 X<sub>i </sub>= 0,1 Based on this ILP formulation of the problem and the solution X<sub>1</sub>,X<sub>2</sub>,X<sub>3</sub>,X<sub>4</sub>)= 1,1,0,0)what values should go in cells B6:G14 of the following Excel spreadsheet?
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
60
A cellular phone company wants to locate two new communications towers to cover 4 regions.The company wants to minimize the cost of installing the two towers.The regions that can be covered by each tower site are indicated by a 1 in the following table:
Tower Sites
 Region 1234 A 11 B 111 C 111 D 11 COST $000 s) 200150190250\begin{array}{rrrrr}\text { Region } & 1 & 2 & 3 & 4 \\\hline \text { A } & & 1 & & 1 \\\text { B } & 1 & & 1 & 1 \\\text { C } & 1 & 1 & 1 &\\\text { D } & 1 & & & 1 \\\hline \text { COST } \$ 000 \text { s) } & 200 & 150 & 190 & 250\end{array}
MIN: 200 X1 + 150 X2 + 190 X3 + 250 X4
Subject to: X2 + X4 ? 1
X1 + X3 + X4 ? 1 X1 + X2 + X3 ? 1 X1 + X4 ? 1
X1 + X2 + X3 + X4 = 2 Xi = 0,1
Based on this ILP formulation of the problem what formulas should go in cells F6:F14 of the following Excel spreadsheet?
 A cellular phone company wants to locate two new communications towers to cover 4 regions.The company wants to minimize the cost of installing the two towers.The regions that can be covered by each tower site are indicated by a 1 in the following table: Tower Sites  \begin{array}{rrrrr} \text { Region } & 1 & 2 & 3 & 4 \\ \hline \text { A } & & 1 & & 1 \\ \text { B } & 1 & & 1 & 1 \\ \text { C } & 1 & 1 & 1 &\\ \text { D } & 1 & & & 1 \\ \hline \text { COST } \$ 000 \text { s) } & 200 & 150 & 190 & 250 \end{array}  MIN: <sup>200 X</sup><sub>1 </sub><sup>+ 150 X</sup><sub>2 </sub><sup>+ 190 X</sup><sub>3 </sub><sup>+ 250 X</sup><sub>4</sub> Subject to: <sup>X</sup><sub>2 </sub><sup>+ X</sup><sub>4 </sub><sup>? 1</sup> X<sub>1 </sub>+ X<sub>3 </sub>+ X<sub>4 </sub>? 1 X<sub>1 </sub>+ X<sub>2 </sub>+ X<sub>3 </sub>? 1 X<sub>1 </sub>+ X<sub>4 </sub>? 1 X<sub>1 </sub>+ X<sub>2 </sub>+ X<sub>3 </sub>+ X<sub>4 </sub>= 2 X<sub>i </sub>= 0,1 Based on this ILP formulation of the problem what formulas should go in cells F6:F14 of the following Excel spreadsheet?
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
61
A certain military deployment requires supplies delivered to four locations.These deliveries come from one of three ports.Logistics planners wish to deliver the supplies in an efficient manner,in this case by minimizing total ton-miles.The port-destination data,along with destination demand is provided in the following table.
 Destination  Port  D1  D2  D3  D4 A758810356 B 1057610185C43809562 Demand 500600450700\begin{array}{c}\text { Destination }\\\begin{array} { c r r r r } \text { Port } & \text { D1 } & \text { D2 } & \text { D3 } & \text { D4 } \\\hline \text {A}& 75 & 88 & 103 & 56 \\\text { B } & 105 & 76 & 101 & 85 \\\mathrm { C } & 43 & 80 & 95 & 62 \\\hline \text { Demand } & 500 & 600 & 450 & 700\end{array}\end{array}
The ports are supplied by one of two supply ships.These ships travel to a particular port where their supplies are off-loaded and shipped to the requesting destinations.Ship S1 carries 1200 tones of supplies while Ship S2 carries 1120 tons of supplies.These ships can only go to a single port and each port can only accommodate one ship.
Assume the costs for a ship to travel to a port are not part of the objective function.
Formulate the ILP for this problem capturing the ship choice of ports and the supply-to-demand transportation from the ports to the destinations.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
62
Binary decision variables:

A)are either 0 or 1
B)must be integers
C)may be continuous
D)may be negative
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
63
Suppose you want to minimize an objective function z=2x1+3x2.Both decision variables must be integer.The optimal solution to the LP relaxation will:

A)be smaller than the optimal IP solution
B)be larger than the optimal IP solution
C)can be either smaller or larger than the optimal IP solution
D)will be within 5% of the optimal IP solution value
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
64
Suppose you want to maximize an objective function z=2x1+3x2.Both decision variables must be integer.The optimal solution to the LP relaxation will:

A)be smaller than the optimal IP solution
B)be larger than the optimal IP solution
C)can be either smaller or larger than the optimal IP solution
D)will be within 5% of the optimal IP solution value
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
65
The concept of a lower bound in IP is associated with:

A)LP relaxation of a minimization problem
B)LP relaxation of a maximization problem
C)a cutting plane technique
D)explicit enumeration of corner point solutions
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
66
Project 6.2 ? Dayton Electronics Manufacturing Inc.DEMI)
The Dayton Electronic Manufacturing,Inc DEMI)company manufactures two styles of remote keyless entry systems the X30 and the X40)that various auto dealers supply to customers when a new or used)automobile is purchased.DEMI currently operates four production facilities located in Springfield OH,Hartford,New Orleans,and Orlando.The manufactured items are shipped from the plants to regional distribution centers located in Trenton,Chicago and Seattle.It is from these regional locations that the product is distributed nationwide.
As more automobile manufactures include keyless entry as a standard option,and DEMI finds itself locked out of the manufacturer market,demand for DEMI's products have decreased.As a result,management is contemplating closing one or more of its production facilities.Distribution facilities are not currently being considered for closing.
Each production facility carries a fixed operating cost and a variable cost associated with building each of the products.Data has been compiled on production costs,resource availability,and resource usage at each of the production plants.That information is summarized in the table below.
 Plant  Fixed Cost Per  Month $1000 )  Production  Cost per 100 )  X 30X40 Production  Time hr/100 ) X30X40 Available  Hours  per Month  Springfield 531100130066720 Hartford 381100125078780 New Orleans 251000100055530 Orlando 281200150059680\begin{array}{ccccc}\text { Plant } & \begin{array}{l}\text { Fixed Cost Per } \\\text { Month } \$ 1000 \text { ) }\end{array} & \begin{array}{c}\text { Production } \\\text { Cost per } 100 \text { ) } \\\text { X } 30-\mathrm{X} 40\end{array} & \begin{array}{c}\text { Production } \\\text { Time } \mathrm{hr} / 100 \text { ) } \\\mathrm{X} 30-\mathrm{X} 40\end{array} & \begin{array}{c}\text { Available } \\\text { Hours } \\\text { per Month }\end{array} \\\hline \text { Springfield } & 53 & 1100 \quad 1300 & 6\quad6 & 720 \\ \text { Hartford } & 38 & 1100 \quad 1250 & 7\quad8 & 780 \\\text { New Orleans } & 25 & 10001000 & 5\quad5 & 530 \\ \text { Orlando } & 28 & 1200 \quad 1500 & 5\quad9 & 680 \\\end{array}
The entry systems are sold nationwide at the same prices: $24 for the X30 and $30 for the X40.
Current monthly demand projections at each distribution center for both products are given in the following table.
 Demand  Trenton  Chicago  Seattle X30220031004000X40450058006000\begin{array}{c}\text { Demand }\\\begin{array} { c c c c } & \text { Trenton } & \text { Chicago } & \text { Seattle } \\\hline X 30 & 2200 & 3100 & 4000 \\X 40 & 4500 & 5800 & 6000\end{array}\end{array}
The transportation costs between each plant and each distribution center,which are the same for either product,are shown in the following table:
Cost per 100\text {Cost per 100} \quad \quad To\text {To}

 From  Trenton  Chicago  Seattle  Springfield $200$270$450 Hartford $100$200$700 New Orleans $250$240$300 Orlando $180$220$350\begin{array}{lccc}\text { From } & \text { Trenton } & \text { Chicago } & \text { Seattle } \\\hline \text { Springfield } & \$ 200 & \$ 270 & \$ 450 \\\text { Hartford } & \$ 100 & \$ 200 & \$ 700 \\\text { New Orleans } & \$ 250 & \$ 240 & \$ 300 \\\text { Orlando } & \$ 180 & \$ 220 & \$ 350\end{array}
• Determine which of the plants to close and which to keep open.
• Determine the number of X30 and X40 to be produced at each plant.
• Determine a shipping pattern from the plants to the distribution centers.
• Maximize the net total monthly profit.If any plants were closed,what was the impact of the closing on profits?
• Do not exceed the production capacities at any plant.
Formulate DEMI's problem as a fixed charge,integer program.Implement your model in Excel and solve the model to answer DEMI's questions.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
67
A practical way of dealing with the complexity of IP problems is to:

A)stop searching for a better solution when the current best solution is within specified suboptimality tolerances
B)continue searching for the optimal solution until no further objective function improvement can be achieved
C)use a B&B technique
D)use LP relaxation and round the values of the decision variables to the nearest integers
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
68
A company produces three products which must be painted,assembled,and inspected.The machinery must be cleaned and adjusted before each batch is produced.They want to maximize their profits for the amount of operating time they have.The unit profit and setup cost per batch are:
 Product  Profit per unit  Setup cost per batch 19500210600312650\begin{array} { r r r } \text { Product } & \text { Profit per unit } & \text { Setup cost per batch } \\\hline 1 & 9 & 500 \\2 & 10 & 600 \\3 & 12 & 650\end{array}
The operation time per unit and total operating hours available are:
 Operating Time per Unit  Operation  Product 1  Product 2  Product 3  Operating Hours Available  Paint 122400 Assemble 232600 Inspection 243540\begin{array}{c}\text { Operating Time per Unit }\\\begin{array} { l c c c c } \text { Operation } & \text { Product 1 } & \text { Product 2 } & \text { Product 3 } & \text { Operating Hours Available } \\\hline \text { Paint } & 1 & 2 & 2 & 400 \\\text { Assemble } & 2 & 3 & 2 & 600 \\\text { Inspection } & 2 & 4 & 3 & 540\end{array}\end{array}
Based on this ILP formulation of the problem and the optimal solution X1,X2,X3)= 270,0,0),what values should appear in the shaded cells in the following Excel spreadsheet?
Xi = amount of product i produced
Yi = 1 if product i produced,0 otherwise
MAX: 9 X1 + 10 X2 + 12 X3 ? 500 Y1 ? 600 Y2 ? 650 Y3
Subject to: 1 X1 + 2 X2 + 2 X3 ? 400
2 X1 + 3 X2 + 2 X3 ? 600
2 X1 + 4 X2 + 3 X3 ? 540 X1 ? M1 Y1 OR 270 Y1 X2 ? M2 Y2 OR 135 Y2 X3 ? M3 Y3 OR 180 Y3 Yi = 0,1
Xi ? 0 and integer
 A company produces three products which must be painted,assembled,and inspected.The machinery must be cleaned and adjusted before each batch is produced.They want to maximize their profits for the amount of operating time they have.The unit profit and setup cost per batch are:  \begin{array} { r r r } \text { Product } & \text { Profit per unit } & \text { Setup cost per batch } \\ \hline 1 & 9 & 500 \\ 2 & 10 & 600 \\ 3 & 12 & 650 \end{array}  The operation time per unit and total operating hours available are:  \begin{array}{c} \text { Operating Time per Unit }\\ \begin{array} { l c c c c } \text { Operation } & \text { Product 1 } & \text { Product 2 } & \text { Product 3 } & \text { Operating Hours Available } \\ \hline \text { Paint } & 1 & 2 & 2 & 400 \\ \text { Assemble } & 2 & 3 & 2 & 600 \\ \text { Inspection } & 2 & 4 & 3 & 540 \end{array} \end{array}  Based on this ILP formulation of the problem and the optimal solution X<sub>1</sub>,X<sub>2</sub>,X<sub>3</sub>)= 270,0,0),what values should appear in the shaded cells in the following Excel spreadsheet? X<sub>i </sub>= amount of product i produced Y<sub>i </sub>= 1 if product i produced,0 otherwise MAX: <sup>9 X</sup><sub>1 </sub><sup>+ 10 X</sup><sub>2 </sub><sup>+ 12 X</sup><sub>3 </sub><sup>? 500 Y</sup><sub>1 </sub><sup>? 600 Y</sup><sub>2 </sub><sup>? 650 Y</sup><sub>3</sub> Subject to: <sup>1 X</sup><sub>1 </sub><sup>+ 2 X</sup><sub>2 </sub><sup>+ 2 X</sup><sub>3 </sub><sup>? 400</sup> 2 X<sub>1 </sub>+ 3 X<sub>2 </sub>+ 2 X<sub>3 </sub>? 600 2 X<sub>1 </sub>+ 4 X<sub>2 </sub>+ 3 X<sub>3 </sub>? 540 X<sub>1 </sub>? M<sub>1 </sub>Y<sub>1 </sub>OR 270 Y<sub>1 </sub>X<sub>2 </sub>? M<sub>2 </sub>Y<sub>2 </sub>OR 135 Y<sub>2 </sub>X<sub>3 </sub>? M<sub>3 </sub>Y<sub>3 </sub>OR 180 Y<sub>3 </sub>Y<sub>i </sub>= 0,1 X<sub>i </sub>? 0 and integer
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
69
Exhibit 6.2
The following questions pertain to the problem,formulation,and spreadsheet implementation below.
A certain military deployment requires supplies delivered to four locations.These deliveries come from one of three ports.Logistics planners wish to deliver the supplies in an efficient manner,in this case by minimizing total ton-miles.The port-destination data,along with destination demand is provided in the following table.
Destination
 Port  D1  D2  D3  D4  A 758810356 B1057610185C43809582 Demand 500600450700\begin{array} { r r r r r } \text { Port } & \text { D1 } & \text { D2 } & \text { D3 } & \text { D4 } \\\hline \text { A } & 75 & 88 & 103 & 56 \\\mathrm {~B} & 105 & 76 & 101 & 85 \\\mathrm { C } & 43 & 80 & 95 & 82 \\\hline \text { Demand } & 500 & 600 & 450 & 700\end{array} The ports are supplied by one of two supply ships.These ships travel to a particular port where their supplies are off-loaded and shipped to the requesting destinations.Ship S1 carries 1200 tones of supplies while Ship S2 carries 1120 tons of supplies.These ships can only go to a single port and each port can only accommodate one ship.
Assume the costs for a ship to travel to a port are not part of the objective function.The following is the ILP formulation and a spreadsheet model for the problem.
Let Yij be 1 if ship i travels to port j,for i = S1,S2 and j = A,B,C
Xjk be the tons shipped from port j = A,B,C to Destination k = D1,D2,D3,D4
Minimize 75X11 + 88X12 + 103X13 + 56X14 + 105X21 + 76X22 + 101X23 + 85X24
+ 43X31 + 80X32 + 95X33 + 62X34
Subject to: Y11 + Y21 ? 1
Y12 + Y22 ? 1 Y13 + Y23 ? 1
Y11 + Y12 + Y13 = 1 Y21 + Y22 + Y23 = 1
X14 + X15 + X16 + X17 ? 1200Y11 + 1120Y21 X24 + X25 + X26 + X27 ? 1200Y12 + 1120Y22 X34 + X35 + X36 + X37 ? 1200Y13 + 1120Y23 X14 + X24 + X34 ? 500
X15 + X25 + X35 ? 600 X16 + X26 + X36 ? 450 X17 + X27 + X37 ? 700
Yij.Xjk ? 0
 Exhibit 6.2 The following questions pertain to the problem,formulation,and spreadsheet implementation below. A certain military deployment requires supplies delivered to four locations.These deliveries come from one of three ports.Logistics planners wish to deliver the supplies in an efficient manner,in this case by minimizing total ton-miles.The port-destination data,along with destination demand is provided in the following table. Destination  \begin{array} { r r r r r } \text { Port } & \text { D1 } & \text { D2 } & \text { D3 } & \text { D4 } \\ \hline \text { A } & 75 & 88 & 103 & 56 \\ \mathrm {~B} & 105 & 76 & 101 & 85 \\ \mathrm { C } & 43 & 80 & 95 & 82 \\ \hline \text { Demand } & 500 & 600 & 450 & 700 \end{array}  The ports are supplied by one of two supply ships.These ships travel to a particular port where their supplies are off-loaded and shipped to the requesting destinations.Ship S1 carries 1200 tones of supplies while Ship S2 carries 1120 tons of supplies.These ships can only go to a single port and each port can only accommodate one ship. Assume the costs for a ship to travel to a port are not part of the objective function.The following is the ILP formulation and a spreadsheet model for the problem. Let <sup>Y</sup><sub>ij </sub><sup>be 1 if ship i travels to port j,for i = S1,S2 and j = A,B,C</sup> X<sub>jk </sub>be the tons shipped from port j = A,B,C to Destination k = D1,D2,D3,D4 Minimize <sup>75X</sup><sub>11 </sub><sup>+ 88X</sup><sub>12 </sub><sup>+ 103X</sup><sub>13 </sub><sup>+ 56X</sup><sub>14 </sub><sup>+ 105X</sup><sub>21 </sub><sup>+ 76X</sup><sub>22 </sub><sup>+ 101X</sup><sub>23 </sub><sup>+ 85X</sup><sub>24</sub> + 43X<sub>31 </sub>+ 80X<sub>32 </sub>+ 95X<sub>33 </sub>+ 62X<sub>34</sub> Subject to: <sup>Y</sup><sub>11 </sub><sup>+ Y</sup><sub>21 </sub><sup>? 1</sup> Y<sub>12 </sub>+ Y<sub>22 </sub>? 1 Y<sub>13 </sub>+ Y<sub>23 </sub>? 1 Y<sub>11 </sub>+ Y<sub>12 </sub>+ Y<sub>13 </sub>= 1 Y<sub>21 </sub>+ Y<sub>22 </sub>+ Y<sub>23 </sub>= 1 X<sub>14 </sub>+ X<sub>15 </sub>+ X<sub>16 </sub>+ X<sub>17 </sub>? 1200Y<sub>11 </sub>+ 1120Y<sub>21 </sub>X<sub>24 </sub>+ X<sub>25 </sub>+ X<sub>26 </sub>+ X<sub>27 </sub>? 1200Y<sub>12 </sub>+ 1120Y<sub>22 </sub>X<sub>34 </sub>+ X<sub>35 </sub>+ X<sub>36 </sub>+ X<sub>37 </sub>? 1200Y<sub>13 </sub>+ 1120Y<sub>23 </sub>X<sub>14 </sub>+ X<sub>24 </sub>+ X<sub>34 </sub>? 500 X<sub>15 </sub>+ X<sub>25 </sub>+ X<sub>35 </sub>? 600 X<sub>16 </sub>+ X<sub>26 </sub>+ X<sub>36 </sub>? 450 X<sub>17 </sub>+ X<sub>27 </sub>+ X<sub>37 </sub>? 700 Y<sub>ij</sub>.X<sub>jk </sub>? 0    -Refer to Exhibit 6.2.What formula would go into cells B11:E11 and cells F8:F10?

-Refer to Exhibit 6.2.What formula would go into cells B11:E11 and cells F8:F10?
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
70
The concept of an upper bound in IP is associated with:

A)LP relaxation of a minimization problem
B)LP relaxation of a maximization problem
C)a cutting plane technique
D)explicit enumeration of corner point solutions
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
71
Pure IP formulation requires that:

A)all decision variables must be integer
B)the optimal objective function value must be integer
C)some decision variables must be integer
D)some decision variables and the optimal value of the objective function must be integer
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
72
Exhibit 6.2
The following questions pertain to the problem,formulation,and spreadsheet implementation below.
A certain military deployment requires supplies delivered to four locations.These deliveries come from one of three ports.Logistics planners wish to deliver the supplies in an efficient manner,in this case by minimizing total ton-miles.The port-destination data,along with destination demand is provided in the following table.
Destination
 Port  D1  D2  D3  D4  A 758810356 B1057610185C43809582 Demand 500600450700\begin{array} { r r r r r } \text { Port } & \text { D1 } & \text { D2 } & \text { D3 } & \text { D4 } \\\hline \text { A } & 75 & 88 & 103 & 56 \\\mathrm {~B} & 105 & 76 & 101 & 85 \\\mathrm { C } & 43 & 80 & 95 & 82 \\\hline \text { Demand } & 500 & 600 & 450 & 700\end{array} The ports are supplied by one of two supply ships.These ships travel to a particular port where their supplies are off-loaded and shipped to the requesting destinations.Ship S1 carries 1200 tones of supplies while Ship S2 carries 1120 tons of supplies.These ships can only go to a single port and each port can only accommodate one ship.
Assume the costs for a ship to travel to a port are not part of the objective function.The following is the ILP formulation and a spreadsheet model for the problem.
Let Yij be 1 if ship i travels to port j,for i = S1,S2 and j = A,B,C
Xjk be the tons shipped from port j = A,B,C to Destination k = D1,D2,D3,D4
Minimize 75X11 + 88X12 + 103X13 + 56X14 + 105X21 + 76X22 + 101X23 + 85X24
+ 43X31 + 80X32 + 95X33 + 62X34
Subject to: Y11 + Y21 ? 1
Y12 + Y22 ? 1 Y13 + Y23 ? 1
Y11 + Y12 + Y13 = 1 Y21 + Y22 + Y23 = 1
X14 + X15 + X16 + X17 ? 1200Y11 + 1120Y21 X24 + X25 + X26 + X27 ? 1200Y12 + 1120Y22 X34 + X35 + X36 + X37 ? 1200Y13 + 1120Y23 X14 + X24 + X34 ? 500
X15 + X25 + X35 ? 600 X16 + X26 + X36 ? 450 X17 + X27 + X37 ? 700
Yij.Xjk ? 0
 Exhibit 6.2 The following questions pertain to the problem,formulation,and spreadsheet implementation below. A certain military deployment requires supplies delivered to four locations.These deliveries come from one of three ports.Logistics planners wish to deliver the supplies in an efficient manner,in this case by minimizing total ton-miles.The port-destination data,along with destination demand is provided in the following table. Destination  \begin{array} { r r r r r } \text { Port } & \text { D1 } & \text { D2 } & \text { D3 } & \text { D4 } \\ \hline \text { A } & 75 & 88 & 103 & 56 \\ \mathrm {~B} & 105 & 76 & 101 & 85 \\ \mathrm { C } & 43 & 80 & 95 & 82 \\ \hline \text { Demand } & 500 & 600 & 450 & 700 \end{array}  The ports are supplied by one of two supply ships.These ships travel to a particular port where their supplies are off-loaded and shipped to the requesting destinations.Ship S1 carries 1200 tones of supplies while Ship S2 carries 1120 tons of supplies.These ships can only go to a single port and each port can only accommodate one ship. Assume the costs for a ship to travel to a port are not part of the objective function.The following is the ILP formulation and a spreadsheet model for the problem. Let <sup>Y</sup><sub>ij </sub><sup>be 1 if ship i travels to port j,for i = S1,S2 and j = A,B,C</sup> X<sub>jk </sub>be the tons shipped from port j = A,B,C to Destination k = D1,D2,D3,D4 Minimize <sup>75X</sup><sub>11 </sub><sup>+ 88X</sup><sub>12 </sub><sup>+ 103X</sup><sub>13 </sub><sup>+ 56X</sup><sub>14 </sub><sup>+ 105X</sup><sub>21 </sub><sup>+ 76X</sup><sub>22 </sub><sup>+ 101X</sup><sub>23 </sub><sup>+ 85X</sup><sub>24</sub> + 43X<sub>31 </sub>+ 80X<sub>32 </sub>+ 95X<sub>33 </sub>+ 62X<sub>34</sub> Subject to: <sup>Y</sup><sub>11 </sub><sup>+ Y</sup><sub>21 </sub><sup>? 1</sup> Y<sub>12 </sub>+ Y<sub>22 </sub>? 1 Y<sub>13 </sub>+ Y<sub>23 </sub>? 1 Y<sub>11 </sub>+ Y<sub>12 </sub>+ Y<sub>13 </sub>= 1 Y<sub>21 </sub>+ Y<sub>22 </sub>+ Y<sub>23 </sub>= 1 X<sub>14 </sub>+ X<sub>15 </sub>+ X<sub>16 </sub>+ X<sub>17 </sub>? 1200Y<sub>11 </sub>+ 1120Y<sub>21 </sub>X<sub>24 </sub>+ X<sub>25 </sub>+ X<sub>26 </sub>+ X<sub>27 </sub>? 1200Y<sub>12 </sub>+ 1120Y<sub>22 </sub>X<sub>34 </sub>+ X<sub>35 </sub>+ X<sub>36 </sub>+ X<sub>37 </sub>? 1200Y<sub>13 </sub>+ 1120Y<sub>23 </sub>X<sub>14 </sub>+ X<sub>24 </sub>+ X<sub>34 </sub>? 500 X<sub>15 </sub>+ X<sub>25 </sub>+ X<sub>35 </sub>? 600 X<sub>16 </sub>+ X<sub>26 </sub>+ X<sub>36 </sub>? 450 X<sub>17 </sub>+ X<sub>27 </sub>+ X<sub>37 </sub>? 700 Y<sub>ij</sub>.X<sub>jk </sub>? 0    -Refer to Exhibit 6.2.What formula would go into cell E14?

-Refer to Exhibit 6.2.What formula would go into cell E14?
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
73
A company produces three products which must be painted,assembled,and inspected.The machinery must be cleaned and adjusted before each batch is produced.They want to maximize their profits for the amount of operating time they have.The unit profit and setup cost per batch are:
 Product  Profit per unit  Setup cost per batch 19500210600312650\begin{array} { r r r } \text { Product } & \text { Profit per unit } & \text { Setup cost per batch } \\\hline 1 & 9 & 500 \\2 & 10 & 600 \\3 & 12 & 650\end{array}
The operation time per unit and total operating hours available are:
 Operating Time per Unit  Operation  Product 1  Product 2  Product 3  Operating Hours Available  Paint 122400 Assemble 232600 Inspection 243540\begin{array}{c}\text { Operating Time per Unit }\\\begin{array} { l c c c c } \text { Operation } & \text { Product 1 } & \text { Product 2 } & \text { Product 3 } & \text { Operating Hours Available } \\\hline \text { Paint } & 1 & 2 & 2 & 400 \\\text { Assemble } & 2 & 3 & 2 & 600 \\\text { Inspection } & 2 & 4 & 3 & 540\end{array}\end{array}
Formulate the ILP for this problem.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
74
Binary variables are useful for modeling

A)the fixed-charge problem
B)the assignment problem
C)the transportation problem
D)the shortest route problem
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
75
ILP formulations can be used to model:

A)production problems
B)personnel scheduling problems
C)investment allocation problems
D)all of the above
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
76
The following ILP is being solved by the branch and bound method.You have been given the initial relaxed IP solution.Complete the entries for the 3 nodes and label the arcs when you branch on X2.
MAX: 50 X1 + 40 X2
Subject to: 2 X1 + 4 X2 ≤ 40
3 X1 + 2 X2 ≤ 30
X1,X2 ≥ 0 and integer
Initial solution X1 = 5.0
X2 = 7.5
Obj = 550 The following ILP is being solved by the branch and bound method.You have been given the initial relaxed IP solution.Complete the entries for the 3 nodes and label the arcs when you branch on X2. MAX: <sup>50 X</sup><sub>1 </sub><sup>+ 40 X</sup><sub>2</sub> Subject to: <sup>2 X</sup><sub>1 </sub><sup>+ 4 X</sup><sub>2 </sub><sup>≤ 40</sup> 3 X<sub>1 </sub>+ 2 X<sub>2 </sub>≤ 30 X<sub>1</sub>,X<sub>2 </sub>≥ 0 and integer Initial solution X<sub>1 </sub>= 5.0 X<sub>2 </sub>= 7.5 Obj = 550
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
77
The following ILP is being solved by the branch and bound method.You have been given the initial relaxed IP solution.Complete the entries for the 3 nodes and label the arcs when you branch on X1.
MAX: 35 X1 + 45 X2
Subject to: 35 X1 + 55 X2 ≤ 250
65 X1 + 25 X2 ≤ 340
X1,X2 ≥ 0 and integer
Initial solution
X1 = 4.6X2 = 1.6 Obj = 233.9 The following ILP is being solved by the branch and bound method.You have been given the initial relaxed IP solution.Complete the entries for the 3 nodes and label the arcs when you branch on X<sub>1</sub>. MAX: <sup>35 X</sup><sub>1 </sub><sup>+ 45 X</sup><sub>2</sub> Subject to: <sup>35 X</sup><sub>1 </sub><sup>+ 55 X</sup><sub>2 </sub><sup>≤ 250</sup> 65 X<sub>1 </sub>+ 25 X<sub>2 </sub>≤ 340 X<sub>1</sub>,X<sub>2 </sub>≥ 0 and integer Initial solution X<sub>1 </sub>= 4.6X<sub>2 </sub>= 1.6 Obj = 233.9
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
78
One way to find an optimal solution to the IP problem is to:

A)use a B&B technique
B)use LP relaxation and round the values of the decision variables up to the nearest integer value
C)use LP relaxation and round the values of the decision variables down to the nearest integer value
D)use LP relaxation and round 50 percent of the decision variable values down to the nearest integer value and the remaining 50 percent up to the nearest integer value
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
79
A popular solution technique to IP problems is called:

A)a branch-and-bound algorithm
B)branching
C)bounding
D)LP relaxation
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
80
A vendor offers 5 different prices per unit depending on the quantity purchased.How many binary variables are needed to model this discounting scheme?

A)4
B)2
C)3
D)5
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.
فتح الحزمة
k this deck
locked card icon
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 88 في هذه المجموعة.