Question

Gaermont Paper manufactures and sells paper to wholesale customers. The company manufactures a "standard" 190-inch-wide roll of paper. However, not all orders are necessarily for this width. Often the company receives orders for narrower rolls. To satisfy those orders, the narrower rolls are cut from the standard rolls. For the next month, the company has committed orders for the next number of rolls

Roll width	Orders
80 in	3800
70 in.	6800
60 in	7200
50 in	5600

Gaermont wants to minimize the number of standard rolls that will be required to meet this demand. What is this amount of rolls?

Remember that you can place fractional amounts as a solution

Answer 1

Using excel solver ,we find the optimal solution for the number of standard rolls to be manufactured.

Amount of rolls =7852.632

Calculations are as shown in the excel snapshot:

In excel ,C7=80*3800+70*6800+60*7200+50*5600

E7=190*C3