Fill This Form To Receive Instant Help
Homework answers / question archive / Poly Products sells packaging tape to industrial customers
Poly Products sells packaging tape to industrial customers. All tape is sold in 100-foot rolls that are cut in various widths from a master roll, which is 15 inches wide. The product line consists of the following widths: 2?, 3?, 5?, 7?, and 11?. These can be cut in different combinations from a 15-inch master roll. For example, one combination might consist of three cuts of 5? each. Another combination might consist of two 2? cuts and an 11? cut. Both of these combinations use the entire 15-inch roll without any waste, but other combinations are also possible. For example, another combination might consist of two 7? cuts. This combination creates one inch of waste for every roll cut this way.
Each week, Poly Products collects demands from its customers and distributors and must figure out how to configure the cuts in its master rolls. To do so, the production manager lists all possible combinations of cuts and tries to fit them together so that waste is minimized while demand is met. (In particular, demand must be met exactly, because Poly Products does not keep inventories of its tape.) This week’s demands are shown below.
Size |
2? |
3? |
5? |
7? |
11? |
Demand |
20 |
30 |
40 |
50 |
60 |
A) How many combinations can be cut from a 15-inch master roll so that there is less than two inches of waste (i.e., the smallest quantity that can be sold) left on the roll?
B) Find a set of combinations that meets demand exactly and generates the minimum amount of waste. (Stated another way, the requirement is to meet or exceed demand for each size, but any excess must be counted as waste.) What is the optimal set of combinations and the minimum amount of waste?
C) Find as many alternate optima as you can. Show all work and formulas in excel including sensitiviy reoprts, and solver setup.
Answer:
A) Following patterns can be cut from 15-inch master roll
Roll width (inches) | |||||||
Pattern # | 2" | 3" | 5" | 7" | 11" | Total (inch) | Waste (inch) |
1 | 3 | 15" | 0 | ||||
2 | 2 | 2 | 14 | 1 | |||
3 | 1 | 1 | 2 | 15 | 0 | ||
4 | 1 | 1 | 1 | 14 | 1 | ||
5 | 3 | 1 | 14 | 1 | |||
6 | 5 | 1 | 15 | 0 | |||
7 | 1 | 1 | 1 | 15 | 0 | ||
8 | 2 | 2 | 1 | 15 | 0 | ||
9 | 3 | 1 | 1 | 14 | 1 | ||
10 | 2 | 1 | 1 | 14 | 1 | ||
11 | 1 | 2 | 1 | 15 | 0 | ||
12 | 4 | 1 | 15 | 0 | |||
13 | 1 | 1 | 14 | 1 | |||
14 | 2 | 1 | 15 | 0 | |||
15 | 6 | 1 | 15 | 0 | |||
16 | 4 | 2 | 14 | 1 | |||
17 | 3 | 3 | 15 | 0 | |||
18 | 1 | 4 | 14 | 1 | |||
19 | 5 | 15 | 0 | ||||
20 | 7 | 14 | 1 |
B) Formulas:
B29 =SUMPRODUCT(B3:B27,$I$3:$I$27) copy to B29:F29, H29
Sensitivity report
Optimal solution:
45 nos. 15-inch master rolls should be cut in pattern # 7 (1x3" + 1x5" + 1x7")
5 nos. 15-inch master rolls should be cut in pattern # 12 (4x2" + 1x7")
60 nos. 15-inch master rolls should be cut in pattern # 13 (1x3" + 1x11")
Total waste from trim loss and excess rolls produced = 310 inch.
please use this google drive link to download the answer file.
https://drive.google.com/file/d/1WsmqJ2qYM-_1SlcRM3xl4MhFu6uZAQAI/view?usp=sharing
note: if you have any trouble in viewing/downloading the answer from the given link, please use this below guide to understand the whole process.
https://helpinhomework.org/blog/how-to-obtain-answer-through-google-drive-link