Paper trim problem: The Oblivion Paper Companyproduces rolls of paper for use in adding machines, deskcalculators, and cash registers. The rolls, which are 200 feetlong, are produced in widths of 1½, 2½, and 3½ inches. Theproduction process provides 200-foot rolls in 10-inch widths only.The firm must therefore cut the rolls to the desired final productsizes. The five cutting alternatives and the amount of wastegenerated by each are as follows:
Cutting Alternative | | Waste
(inches) |
1 6 0 0 1
2 0 1 2 0.5
3 1 3 0 1
4 1 2 1 0
5 4 0 1 0.5
The minimum product requirements for the three products are asfollows:
Roll Width (inches) | Units |
1 ½ | 2000 |
2 ½ | 1000 |
3 ½ | 4500 |
With the goal of minimizing the number of units of the 10-inchrolls will be processed on each cutting alternative, find each ofthe following:
Total Number of 10-inch Rolls Processed =
Note: Value is between 2485 and 2535
Number of 1½ inch rolls produced =
Number of 2½ inch rolls produced =
Number of 3½ inch rolls produced =
Number of Rolls Cut Using Alternative 1 =
Number of Rolls Cut Using Alternative 4 =
Number of Rolls Cut Using Alternative 5 =
*******Complete in Excel and showFormulas*******
