Again continuing problem 2, suppose that you want to force the optimal solution to be integers. Do this in Solver by adding a new constraint. Select the changing cells for the left side of the constraint, and in the middle dropdown list, select the “int” option. How does the optimal integer solution compare to the optimal non-integer solution in problem 2? Are the changing cell values rounded versions of those in problem 2? Is the objective value more or less than in problem 2?
Answer to relevant QuestionsIf all of the inputs in PC Tech’s product mix problem are nonnegative, are there any input values such that the resulting model has no feasible solutions? Modify PC Tech’s product mix model so that there is no maximum sales constraint. Does this make the problem unbounded? Does it change the optimal solution at all? Explain its effect. In Solver’s sensitivity report for the product mix model, the allowable decrease for available assembling hours is 2375. This means that something happens when assembling hours fall to 20,000 - 2375 =17,625. See what this ...A chemical company manufactures three chemicals: A, B, and C. These chemicals are produced via two production processes: 1 and 2. Running process 1 for an hour costs $400 and yields 300 units of A, 100 units of B, and 100 ...There are three factories on the Momiss River. Each emits two types of pollutants, labeled P1 and P2, into the river. If the waste from each factory is processed, the pollution in the river can be reduced. It costs $1500 to ...
Post your question