Stock Cutting
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
Stock Cutting
2
3
Instructions: The objective is to build an optimal cut list from standard raw materials. This is requires an iterative approach in which the custom cut list is used to indentify potential patterns, and the model rerun until no new patterns emerge. Attempt to find the minimum cost solution, and the minimum waste solution. This spreadsheet uses the OpenSolver Add-on. The Green cells denote user input, yellow are decision variable determined by the solver, and the red cell is the problem objective.
4
5
PartsPart APart BPart CPart D
6
Size24272357
7
Qty Req'd300300300100
8
Custom Cuts
9
Raw MaterialUnit CostSizeQtyCostComputed PatternsAmount AvailableAmount CutWaste
11
2x4 - 92 5/8"2.5492.6800.0000000.000.000.00
12
2x4 - 8'2.3696.0000.0000000.000.000.00
13
2x4 - 8'2.3696.0000.0000000.000.000.00
14
2x4 - 8'2.3696.0012.36030096.0081.0015.00
15
2x4 - 104 5/8"3.24104.6800.0000000.000.000.00
16
2x4 - 12'3.99144.0000.0000000.000.000.00
17
2x4 - 16'6.04192.0000.0000000.000.000.00
18
2.36030096.0081.0015.00
19
15.63%
20
Pattern Cuts
21
Raw MaterialUnit CostSizeQtyCostPatternsAmount AvailableAmount CutWaste
22
2x4 - 92 5/8"2.5492.6800.0030000.000.000.00
23
2x4 - 92 5/8"2.5492.6800.0003000.000.000.00
24
2x4 - 92 5/8"2.5492.6800.0000400.000.000.00
25
2x4 - 92 5/8"2.5492.6800.0000010.000.000.00
26
2x4 - 8'2.3696.0075177.0040007200.007200.000.00
27
2x4 - 8'2.3696.002968.4403002784.002349.00435.00
28
2x4 - 8'2.3696.00100236.0001309600.009600.000.00
29
2x4 - 8'2.3696.00100236.0001019600.008400.001200.00
30
2x4 - 104 5/8"3.24104.6800.0010000.000.000.00
31
2x4 - 104 5/8"3.24104.6800.0003000.000.000.00
32
2x4 - 104 5/8"3.24104.6800.0000210.000.000.00
33
2x4 - 104 5/8"3.24104.6800.0000010.000.000.00
34
2x4 - 12'3.99144.0000.0010000.000.000.00
35
2x4 - 12'3.99144.0027.980500288.00270.0018.00
36
2x4 - 12'3.99144.0000.0001500.000.000.00
37
2x4 - 12'3.99144.0000.0001020.000.000.00
38
2x4 - 16'6.04192.0000.0010000.000.000.00
39
2x4 - 16'6.04192.0000.0007000.000.000.00
40
2x4 - 16'6.04192.0000.0000100.000.000.00
41
2x4 - 16'6.04192.0000.0002120.000.000.00
42
725.4230029730010029472.0027819.001653.00
43
5.61%
44
Total Cuts
45
$727.7830030030010029568.0027900.001668.00
46
5.64%
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
Loading...
 
 
 
Sheet1
__OpenSolver__