business analytics help

STAR Co provides paper to smaller companies whose volumes are not large enough to warrant dealing directly with the paper mill. STAR receives 100-feet-wide paper rolls from the mil and cuts the rolls into smaller rolls of widths 12, 15, and 30 feet. The demands for these widths vary from week to weak. The following cutting patterns have been established Number of: Pattern 12ft. 15ft. 3oft. Trim Loss 1 0 4 1 10 It 2. 4 3 0 7 ft. 3 8 0 0 4 ft. 4 2 1 2 1 t. 5 2 3 1 11t Trim loss is the leftover paper from a pattern (eg, for pattern 4, 2(12) + 1(15) + 2(30) 99 feet used resulting in 100-99 - 1 foot of trim loss). Orders in hand for the coming week are 5,670 12-foot rolls, 1,680 15-foot rolls, and 3,350 30-foot rolls. Any of the three types of rolls produced in excess of the orders in hand will be sold on the open market at the selling price No inventory is held Optimal Solution: (a) Formulate an integer programming model that will determine how many 100-foot rolls to cut into each of the five patterns in order to minimize trim loss. If your answer is zero enter "O" and if the constant is "1" it must be entered in the box. Min x2 + Xy+ X4 + Xs s.t. 22+ MS Select your answer 12-foot rolls X + X2+ X + + 45 Select your answer 15-foot rolls X2 X + X+ Select your answer 30-foot rolls *). 2, X3, X, Xs are integers (b) Solve the model formulated in part a: What is the minimal amount of trim loss? Thim Loss feet How many of each pattern should be used and how many of each type of roll will be sold on the open market? If your answer is zero entorno Pattern Number Rolls Used 1 2 3 4 5