Deck 6: Integer Linear Programming

Full screen (f)
exit full mode
Question
In the B & B algorithm,B & B stands for

A)Brooks and Baker
B)Best Bound
C)Best Branch
D)Branch and Bound
Use Space or
up arrow
down arrow
to flip the card.
Question
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.
Question
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.
Question
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.
Question
Variables,which are not required to assume strictly integer values are referred to as

A)strictly non-integer.
B)continuous.
C)discrete.
D)infinite.
Question
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.
Question
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.
Question
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.
Question
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.
Question
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.
Question
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
Question
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.
Question
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.
Question
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
Question
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.
Question
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.
Question
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
Question
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.
Question
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.
Question
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.
Question
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)
Question
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
Question
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
Question
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.
Question
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
Question
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
Question
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
Question
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
Question
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
Question
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.
Question
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.
Question
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
Question
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
Question
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
Question
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
Question
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.
Question
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
Question
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
Question
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)
Question
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
Question
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>
Question
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?
Question
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
Question
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}
Question
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:
Question
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}
Question
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
Question
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
Question
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
Question
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.
Question
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.
Question
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
Question
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
Question
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>
Question
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.
Question
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>
Question
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.
Question
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}
Question
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>
Question
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>
Question
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.
Question
Binary decision variables:

A)are either 0 or 1
B)must be integers
C)may be continuous
D)may be negative
Question
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
Question
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
Question
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
Question
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.
Question
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
Question
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>
Question
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?
Question
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
Question
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
Question
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?
Question
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.
Question
Binary variables are useful for modeling

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

A)production problems
B)personnel scheduling problems
C)investment allocation problems
D)all of the above
Question
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>
Question
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>
Question
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
Question
A popular solution technique to IP problems is called:

A)a branch-and-bound algorithm
B)branching
C)bounding
D)LP relaxation
Question
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
Sign up to unlock the cards in this deck!
Unlock Deck
Unlock Deck
1/88
auto play flashcards
Play
simple tutorial
Full screen (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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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)
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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)
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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?
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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}
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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:
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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}
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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  )
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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}
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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?
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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?
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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?
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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?
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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.
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
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
Unlock Deck
Unlock for access to all 88 flashcards in this deck.
Unlock Deck
k this deck
locked card icon
Unlock Deck
Unlock for access to all 88 flashcards in this deck.