A company makes standard $160-$inch$-$wide rolls of thin sheet metal and slits them into smaller rolls to meet customer orders for widths of $10,14,$ and $25$ inches. Suppose that the company has proposed the following cutting patterns:

A B C D E

$1$ Cutting$-$Stock Problem

$2$

$3$ Data $101425$

$4$ Pattern $10-$in rolls $14$ in$.$ rolls $25-$in$.$ rolls Scrap

$515424$

$622626$

$738222$

$840631$

$957606$

$106100210$

Demand $950725640$

Demands for the coming week are $95010-$inch rolls, $72514-$inch roles, and $64025-$inch rolls. Develop a model using the Excel Solver that will determine how many $160-$inch rolls to cut into each of the six patterns in order to meet demand and minimize scrap.

Total scrap is:

Total cut using pattern $1$ is:

Total cut using pattern $4$ is: