In the cutting stock example, we minimized the total number of rolls cut. Do you get the same solution if you minimize the total inches of waste? For example, given the solution in Figure 6.29, this...

In the cutting stock example, we minimized the total number of rolls cut. Do you get the same solution if you minimize the total inches of waste? For example, given the solution in Figure 6.29, this waste includes 2 inches from pattern 6, 12 inches from the extra 12-inch roll produced (in cell B40), and a couple of others. Solve the problem with this objective.

=$B$15*B40

Then copy the range B51:B52 to the range C51:E52 for the other months. Make sure the totals in row 53 and column F are updated to include the shortage costs.