Exam 6: Integer Linear Programming
Exam 1: Introduction to Modeling and Decision Analysis78 Questions
Exam 2: Introduction to Optimization and Linear Programming76 Questions
Exam 3: Modeling and Solving Lp Problems in a Spreadsheet93 Questions
Exam 4: Sensitivity Analysis and the Simplex Method76 Questions
Exam 5: Network Modeling92 Questions
Exam 6: Integer Linear Programming102 Questions
Exam 7: Goal Programming and Multiple Objective Optimization81 Questions
Exam 8: Nonlinear Programming Evolutionary Optimization87 Questions
Exam 9: Regression Analysis93 Questions
Exam 10: Data Mining125 Questions
Exam 11: Time Series Forecasting125 Questions
Exam 12: Introduction to Simulation Using Analytic Solver Platform85 Questions
Exam 13: Queuing Theory97 Questions
Exam 14: Decision Analysis125 Questions
Exam 15: Project Management Online82 Questions
Select questions type
One way of solving an ILP problem is to solve its LP relaxation and round the solution up or down to the nearest integer.
(True/False)
4.9/5
(35)
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.
Define the ILP formulation for this capital budgeting problem.

(Essay)
4.9/5
(30)
A vendor offers 5 different prices per unit depending on the quantity purchased. How many binary variables are needed to model this discounting scheme?
(Multiple Choice)
4.8/5
(38)
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. 

(Essay)
4.9/5
(22)
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.
The following is the ILP formulation and a spreadsheet model for the problem.
-Refer to Exhibit 6.1. What formulas should go in cells D8:H8 and D11:H11 of the above Excel spreadsheet?



(Essay)
4.8/5
(41)
The setup cost incurred in preparing a machine to produce a batch of product is an example of a
(Multiple Choice)
4.9/5
(33)
One useful feature of Analytic Solver Platform (ASP) is its ability to generate graphs of the optimization results.
(True/False)
4.8/5
(34)
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.
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.
-Refer to Exhibit 6.2. What formula would go into cell E14?



(Short Answer)
4.8/5
(39)
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?
(Multiple Choice)
4.8/5
(29)
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.
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?




(Essay)
4.9/5
(26)
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.
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?




(Essay)
4.8/5
(34)
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.
Based on this ILP formulation of the problem what is the optimal solution to the problem? 


(Essay)
4.7/5
(39)
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.
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:



(Essay)
4.8/5
(31)
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.
(Essay)
4.9/5
(23)
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?
(Multiple Choice)
4.8/5
(29)
For minimization problems, the optimal objective function value to the LP relaxation provides what for the optimal objective function value of the ILP problem?
(Multiple Choice)
4.8/5
(37)
Showing 21 - 40 of 102
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)