Question: Help! Must make these changes to the problem below! Problem 6.2026 206 Howie's Carnet World Cutting Stock MinCosts Howie's Carpet World Logic - 25 points

Problem 6.2026 206 Howie's Carnet World Cutting Stock MinCosts Howie's Carpet World Logic - 25 points In Problem 6-20 (b) from the previous homework, the solution (link above) that minimizes cost involved three (3) different cutting patterns. To avoid additional setup time in switching patterns, Howie's Carpet World margement wants to ensure that they still use no more than three different potters. They also feel that if using a cutting cutter they should use it at least 60 times. In addition, experience tells them that the cutting blades become duarter too much use, so they also want to limit use of a pattern to at most 90 carpets. Model the necessary changes to Problem - 20 (b) to incorporate these new constraints. On a separate Worksheet add an additional requirement to use pattern using pattern 3. How does the solution change? B D E H F Roll Length (yds) 100 Howie's Carpet World Cost per Roll Waste Cutting Pattern 1 2 3 4 5 6 7 Roll Width (ft) 14 14 14 18 18 18 18 Produced (rolls) Produced (yds) Required (yds) Width of Carpet Sections Cut (ft) 4 9 12 3 0 0 1 1 0 0 0 1 4 0 0 2 1 0 1 0 1 0 2 0 40 200 90 4000 20000 9000 4000 20000 9000 $1,000 $1,000 $1,000 $1,400 $1,400 $1,400 $1,400 $242,000 TC ONNNN Number of Rolls Cut 0 40 90 0 0 0 80 220 + Problem 6.2026 206 Howie's Carnet World Cutting Stock MinCosts Howie's Carpet World Logic - 25 points In Problem 6-20 (b) from the previous homework, the solution (link above) that minimizes cost involved three (3) different cutting patterns. To avoid additional setup time in switching patterns, Howie's Carpet World margement wants to ensure that they still use no more than three different potters. They also feel that if using a cutting cutter they should use it at least 60 times. In addition, experience tells them that the cutting blades become duarter too much use, so they also want to limit use of a pattern to at most 90 carpets. Model the necessary changes to Problem - 20 (b) to incorporate these new constraints. On a separate Worksheet add an additional requirement to use pattern using pattern 3. How does the solution change? B D E H F Roll Length (yds) 100 Howie's Carpet World Cost per Roll Waste Cutting Pattern 1 2 3 4 5 6 7 Roll Width (ft) 14 14 14 18 18 18 18 Produced (rolls) Produced (yds) Required (yds) Width of Carpet Sections Cut (ft) 4 9 12 3 0 0 1 1 0 0 0 1 4 0 0 2 1 0 1 0 1 0 2 0 40 200 90 4000 20000 9000 4000 20000 9000 $1,000 $1,000 $1,000 $1,400 $1,400 $1,400 $1,400 $242,000 TC ONNNN Number of Rolls Cut 0 40 90 0 0 0 80 220 +
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
