Question

In: Operations Management

1.     What is true regarding integer programming/ A)    Optimal decision variables will be 0 or 1 B)    Excel solver...

1.     What is true regarding integer programming/

A)    Optimal decision variables will be 0 or 1

B)    Excel solver does not provide sensitivity report

C)    Solving an integer programming problem by solving a linear programming problem and rounding gives you the optimal solution

D)    All

E)    None

Solutions

Expert Solution

The correct option is E) None

Explanations:

The optimal decision variables not necessarily required to the 0 or 1 to be part of integer programming. In fact, the optimal decision values are either 0 or 1, it is called the integer programming, while in other cases where optimal decision variables do not contain discrete integer values are called mixed-integer programming which is also a type of integer programming. Therefore Option A is false.

The Excel provides the sensitivity report of the output of integer programming solver. Therefore Option B is false.

The Linear programming model does not guarantee integer values as the optimum value output. Therefore, deviating by rounding off the values will also deviate from the optimum output and hence does not guarantee the solution we require. Therefore Option C is false.

Since all of the above options are false therefore Option D is also false.

The remaining option is Option E None which suits our situation and hence Option E is true.


Related Solutions

using Solver of excel please dont miss this part Solver of excel 11-34 OPTIMAL PRODUCTION MIX....
using Solver of excel please dont miss this part Solver of excel 11-34 OPTIMAL PRODUCTION MIX. Della Simpson Inc. sells two popular brands of cookies, Della’s Delight and Bonnie’s Bourbon. Della’s Delight goes through the Mixing and Baking Departments, and Bonnie’s Bourbon, a filled cookie, goes through the Mixing, Filling, and Baking departments. LO 2, 3, 5                                                                              Maximize $300D + $250 B where D = Della’s Delight and B = Bonnie’s Bourbon                                                    Michael Shirra, vice-president of sales, believes that...
1. Solve the following integer optimization model by using Excel Solver: Maximize Z = 5x1 +...
1. Solve the following integer optimization model by using Excel Solver: Maximize Z = 5x1 + 6x2 Subject to 3x1 + 4x2 < 10 4x1 + 2x2 < 15      x1, x2 > 0 and integer Please show how to use the excel solver as well as steps. :)
For goal programming models, what is not true? A) Always minimization. B) Only deviational variables appear...
For goal programming models, what is not true? A) Always minimization. B) Only deviational variables appear in the objective function. C) All deviational variables must be >= 0. D) Only deviational variables appear in the constraints.
This assignment requires using the Excel add-in called Solver... 1. Can a linear programming problem have...
This assignment requires using the Excel add-in called Solver... 1. Can a linear programming problem have no solution? More than one solution? Explain. 2. To find the optimal solution to a linear optimization problem, do you have to examine all the points in the feasible region? Explain.
How do you find the optimal weights of a portfolio in excel using solver given a...
How do you find the optimal weights of a portfolio in excel using solver given a predefined risk (target standard deviation)?
Solve the following linear programming problem using Solver. Be sure to write in your optimal solution...
Solve the following linear programming problem using Solver. Be sure to write in your optimal solution below the problem. Max Z = 20X1 + 30X2 + 25X3 + 32X4 s.t. 4X1 + 8X2 + 5X3 + 6X4 ≤ 40 X1 + X2 ≥ 3 (X1 + X2) ≤ (X3 + X4) ?1 ?2 ≥ 3 2 X1 = __________ X2 = ___________ X3 = ___________ X4 = ___________ Z = ____________
Solve the following linear programming problem using Solver. Be sure to write in your optimal solution...
Solve the following linear programming problem using Solver. Be sure to write in your optimal solution below the problem. Max Z = 20X1 + 30X2 + 25X3 + 32X4 s.t. 4X1 + 8X2 + 5X3 + 6X4 ≤ 40 X1 + X2 ≥ 3 (X1 + X2) ≤ (X3 + X4) x1/x2 ≥ 3/2 X1 = __________X2 = ___________X3 = ___________X4 = ___________Z = ____________
Use the branch and bound method to find the optimal solution to the following integer programming...
Use the branch and bound method to find the optimal solution to the following integer programming problem: maximize 7x1 + 3x2 subject to: 2 x1 + x2 < 9 3 x1 + 2x2 <13 x1, x2 > 0; x1, x2 integer Instead of using EXCEL Solver to solve this problem directly as an integer programming problem, use EXCEL Solver to solve the LP problems at each branch, with the appropriate constraints added, according to the branch and bound algorithm. Be...
You are a manager that uses Excel to find the optimal solution to a linear programming...
You are a manager that uses Excel to find the optimal solution to a linear programming problem. Before implementing the solution, what should you do?
SOLVE THE FOLLOWING 2 LINEAR PROGRAMMING PROBLEMS USING EXCEL AND THE SOLVER ADD-IN. PLEASE SHOW ME...
SOLVE THE FOLLOWING 2 LINEAR PROGRAMMING PROBLEMS USING EXCEL AND THE SOLVER ADD-IN. PLEASE SHOW ME ALL THE EXCEL STEPS. PROBLEM #1:   Maximize Z = $60X + $90Y                             Subject to:   60X + 30Y >= 1,500                                                     100X + 100Y <= 6,000                                                                              Y >= 30                                                                           X, Y >= 0 PROBLEM #2: Minimize Z = $3,000X + $1,000Y                              Subject to:   60X + 20Y >= 1,200                                                         10X + 10Y >= 400                                                     ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT