Exam 2: Introduction to Management Science Models

When running Excel, what does "The Set Cell values do not converge" mean?

The objective function coefficients for X₁, X₂, and X₃ are 15, 32, and 48 respectively.Excel prints that their ranges of optimality are from 10 to 20, from 30 to 40, and from - $\infty$ to 50 respectively.If the objective function coefficients are changed to 14, 31, and 45, the optimal solution:

"Allowable Decrease" and "Allowable Increase" refer to what range?

An over-constrained linear programming problem results in what type of solution?

The complementary slackness principle states that either there is zero slack on a constraint or the reduced cost is zero.

Which of the following is not a necessary linear programming assumption?

Dean Air uses a linear programming model to schedule flights, assign crews and meet passenger demand.The objective function is to minimize downtime.Constraints include a limit on pilot hours, meeting passenger demand, and scheduled downtime.Which of the following cannot be accomplished with sensitivity analysis?

Excel Solver reports "Solver could not find a feasible solution." What is your best logical alternative?

Binary linear programming allows for the possibility of mutually exclusive constraints.

In a model with two decision variables, the restriction 3X₁ + 2X₂ $\le$ 6 represents:

In solving an integer linear programming problem, lifting the integer requirements and first solving the underlying standard linear programming problem:

Explain the different interpretations of shadow costs when the objective function is based on sunk costs versus included costs.

If the points (5, 5, 5) and (7, 9, 5) are both optimal solutions to a linear programming problem, what other point is also optimal?

How do you designate variables as integers when using Excel Solver?

The Hawaii Surfboard Company produces three different styles of surfboards (the Oahu, the Kauai, and the Maui) made from combinations of three different materials, A, B, and C.The Oahu model nets a $35 profit and requires 1 unit of A, 1 unit of B, and 1 unit of C.The Kauai model nets a $75 profit and requires 4 units of A and 1 unit of B.The Maui model nets a $100 profit and requires 1 unit of A, 4 units of B, and 1 unit of C.There are 200 units of A, 200 units of B, and 100 units of C available weekly. A.Formulate a linear programming model to determine the optimal weekly profit. B.How would the model change if Hawaii Surfboard wanted to produce an equal number of each model?

Consider the following sensitivity report from Excel for the model in question 3, which has a profit of $5,400. A.If Jungle Figures eliminates its policy of not producing more than twice the number of large giraffes as small giraffes, how will this affect the optimal solution? B.Suppose 50 pounds of extra stuffing could be purchased for $200.Should Jungle do this? Would the optimal solution change? C.Jungle is considering diverting 10 hours of machine time from the production of other products to produce giraffes.It figures it will lose $225 in gross profits from those products by this action.Should Jungle do this? Would the optimal solution change? D.Suppose that demand is such that Jungle could effectively raise its prices to $15 on each giraffe (large or small).Would the optimal production schedule change? E.Suppose demand for small giraffes waned, and Jungle cut its process so that its profit on small giraffes was reduced by 50% to $4.50.Would the optimal solution change?

A farmer has three possible cereal grain crops to grow in the coming planting season: barley, oats, and wheat.He has 240 acres of arable land: 160 are considered high grade and the remainder is low grade.He has $42,000 in available capital and can hire virtually unlimited hours of field labor, locally, for $6 per hour.Relevant crop factors are:Formulate this as a linear programming model.

What is the major difference between a product mix problem and a diet problem?

What clue does Excel give to the possible existence of alternate optimal solutions?

Ira Wax solved an integer linear programming problem by setting up a linear programming model without the integer constraints and rounding the solution.List the possible problems with this approach.