Do: Chapter 13 AssignmentTrim loss is the leftover paper from a pattern (e.g., for pattern 4, 2(12)+1(15) + 2(30) = 99 feet used resulting in 100-99 = 1 foot of trim loss). Orders 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 onthe open market at the selling price. No inventory is held.(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 "0" and if the constant is "1" it must be entered in the box.Let x j = number of 100-foot-wide rolls using cutting pattern j, j = 1, 2, 3, 4, 5.Optimal Solution:Pattern10160(b) Solve the model formulated in part a. What is the minimal amount of trim loss?Total Trim Loss: 2007 feetType of Roll12-foot rolls15-foot rollsIcon Key30-foot rollsHide Feedbackhere to searchPartially Correct0How 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 enter "0".Number of Rolls Usedfor Each Pattern1675332X102007Number of Rolls Soldon the Open Market56743350M0x×EtS~+40XCx5 2x 1, X 2, x3, x4, x 5 are integers and nonnegativex5 2HHx5 299+SS56701680335012-foot rolls15-foot rolls✔30-foot rollsHRD74°F HazeHint(s) Check My Work10:42 AM2/23/2023XA-Zبشه#O Problem 13-03 Algo (Solving Integer Optimization Problems with Excel Solver)Number of:Pattern 12ft. 15ft. 30ft. Trim Loss10110 ft.2403845STAR 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 mill and cuts the rolls into smaller rolls of widths 12, 15, and 30 feet. The demands for these widths vary from week to week. The following cutting patternshave been established:22Mins.t.43013Trim loss is the leftover paper from a pattern (e.g., 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 typesthe open market at the selling price. No inventory is held.Pattern(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 "0" and if the constant is "1" it must be entered in the box.Let x j = number of 100-foot-wide rolls using cutting pattern j, j = 1, 2, 3, 4, 5.Optimal Solution:1Search0201~7 ft.4 ft.1 ft.1 ft.010(b) Solve the model formulated in part a. What is the minimal amount of trim loss?Total Trim Loss:2007 feet1675332XHow 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 enter "0".Number of Rolls Usedfor Each PatternX4S.1001 x4 +X1, X2, x3, x4, x 5 are integers and nonnegativeCXx5 2H99+S56701680335012-foot rolls15-foot rolls30-foot rollsARDQuestion 1 of 5 ►74°F HazeHint(s) Check My WorkFrolls produced in excess of the orders in hand will be sold on<10:41 AM2/23/2023A-Zc.WA+O

Decision Variables: Suppose-x1 be the no. of foot rolls used for pattern 1x2 be the no. of foot…

Trim m loss is the leftover paper from a pattern (e.g. for patter 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. (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"0" and if the constant is "1" it must be entered in the box. Letx number of 100-foot-wide rolls using cutting pattern. 1, 2, 3, 4, 5. Optimal Solution Min s.t. 10x₁ Pattern 1 •₁- 3 15-foot roll 30-foot rolls Hide Feedback 10x₂. • Partially Correct 0° 1675 Number of Rolls Sold Type of Roll on the Open Market 12-foot rolls 5674 2007 3350 0 (b) Solve the model formulated in part a. What is the minimal amount of trim loss? Total Trim Loss 2007 fe 332 3 x2 x2 4 8 0 0 x3 2x₁. 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 enter"0" Number of Rolls Used for Each Pattern 1 2 K 7 MS xs 2 XLX2X1Xxs are integers and nonegative 2 5670 1680 ✓ 3350 @L^ 12-foot rolle 15-foot rolle 30-foot rolls Hint(s) Check My Work

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...