Suppose there is a fourth drug, drug D, that Repco can produce and sell. Each unit of drug D requires four labor hours, one unit of drug A, and one unit of drug C to produce, and it sells for $150 per unit. Modify the current model to incorporate drug D and then run Solver. If drug D isn’t produced in the optimal solution, use sensitivity analysis to see how much higher its selling price would have to be before Repco would produce it. If drug D is produced in the optimal solution, use sensitivity analysis to see how much lower its selling price would have to be before Repco would stop producing it.
