In the optimal solution to the Great Threads model, no pants are produced. Suppose Great Threads has an order for 300 pairs of pants that must be produced. Modify the model appropriately and use...

In the optimal solution to the Great Threads model, no pants are produced. Suppose Great Threads has an order for 300 pairs of pants that must be produced. Modify the model appropriately and use Solver to find the new optimal solution. (Is it enough to put a lower bound of 300 on the production quantity in cell D16? Will this automatically force the binary value in cell D14 to be 1? Explain.) How much profit does the company lose because of having to produce pants?

=RISKSIMTABLE (D16:M16)

in cell B16. As with all uses of this function, the spreadsheet shows the simulated values for the first bid, $10,500. However, when you run the simulation, you see outputs for all of the bids.

Finally, calculate profit and designate it as an output cell for @RISK in cell J14 with the formula

=RISKOUTPUT("Profit")+F14+I14-D14