asked 184k views
5 votes
Please write the objective + constraint also use excel to

solve it using solver. but make sure the length is 12 18 30 45
60
Appendix A. Model A: Cutting Stock Problem (CSP) Decora Accessories manufactures a varicty of bathroom accessories, including decorative towel rods and shower curtain rods. Each of the accessories inc

asked
User YUSMLE
by
8.3k points

1 Answer

5 votes
The objective of the Cutting Stock Problem (CSP) is to minimize waste when cutting materials into smaller pieces. In this case, Decora Accessories wants to manufacture bathroom accessories, such as towel rods and shower curtain rods, from longer rods of length 12, 18, 30, 45, and 60. The constraint in this problem is that the total length of the rods used should be equal to or less than the available length of the longer rods. To solve this problem using Excel Solver, you can set up a spreadsheet with the lengths of the longer rods and the number of shorter rods required for each length. Assign a decision variable for the number of longer rods to be cut. Then, use the Solver tool in Excel to minimize the waste by adjusting the decision variable. The Solver will find the optimal solution by minimizing waste while fulfilling the constraint. The output will show the number of longer rods to cut, as well as the resulting waste. By using Solver in Excel, Decora Accessories can optimize the cutting process and minimize material waste, ultimately improving efficiency and reducing costs. Note: The specific steps and formulas required to set up and solve the CSP using Excel Solver may vary depending on the exact requirements and constraints of the problem.
answered
User JiteshW
by
8.2k points