Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / Poly Products sells packaging tape to industrial customers

Poly Products sells packaging tape to industrial customers

Operations Management

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.

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

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