Pack size conundrum, ee question 29062784 SOLVED
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAH
1
pack size (g)pack priceQuantity neededMinCostQuantity for min wasteMin wasteSelected pack for MinCostQuantity prior to selectionMinCost pack selectionsCost array for MinCostMinCost flagPrevious costs
2
1000.4https://www.experts-exchange.com/questions/29062784/Optimum-pack-size-purchases.html00.0000000.00
3
2500.75500.40100501000100,00.400.751.001.000.000.000.000.000.00
4
50011000.4010001000100,00.400.751.001.000.000.000.000.000.00
5
1500.75200502500250,00.800.751.000.001.000.000.400.000.00
6
2000.7520002500250,00.800.751.000.001.000.000.400.000.00
7
2500.7525002500250,01.150.751.000.001.000.000.750.000.00
8
3001.0030005000500,01.151.151.000.000.001.000.750.400.00
9
3501.0035005000500,01.151.151.000.000.001.000.750.400.00
10
4001.0040005000500,01.401.501.000.000.001.001.000.750.00
11
4501.0045005000500,01.401.501.000.000.001.001.000.750.00
12
5001.0050005000500,01.401.501.000.000.001.001.000.750.00
13
5501.405500100450100,500,01.401.751.401.000.001.001.001.000.40
14
6001.406000100500100,500,01.401.751.401.000.001.001.001.000.40
15
6501.756500250400250,500,01.801.751.750.001.001.001.401.000.75
16
7001.757000250450250,500,01.801.751.750.001.001.001.401.000.75
17
7501.757500250500250,500,02.151.751.750.001.001.001.751.000.75
18
8002.008000500300500,500,02.152.152.000.000.001.001.751.401.00
19
8502.008500500350500,500,02.152.152.000.000.001.001.751.401.00
20
9002.009000500400500,500,02.402.502.000.000.001.002.001.751.00
21
9502.009500500450500,500,02.402.502.000.000.001.002.001.751.00
22
10002.0010000500500500,500,02.402.502.000.000.001.002.001.751.00
23
10502.4010500100950100,500,500,02.402.752.401.000.001.002.002.001.40
24
11002.40110001001000100,500,500,02.402.752.401.000.001.002.002.001.40
25
11502.7511500250900250,500,500,02.802.752.750.001.001.002.402.001.75
26
12002.7512000250950250,500,500,02.802.752.750.001.001.002.402.001.75
27
12502.75125002501000250,500,500,03.152.752.750.001.001.002.752.001.75
28
13003.0013000500800500,500,500,03.153.153.000.000.001.002.752.402.00
29
13503.0013500500850500,500,500,03.153.153.000.000.001.002.752.402.00
30
14003.0014000500900500,500,500,03.403.503.000.000.001.003.002.752.00
31
14503.0014500500950500,500,500,03.403.503.000.000.001.003.002.752.00
32
15003.00150005001000500,500,500,03.403.503.000.000.001.003.002.752.00
33
15503.40155001001450100,500,500,500,03.403.753.401.000.001.003.003.002.40
34
16003.40160001001500100,500,500,500,03.403.753.401.000.001.003.003.002.40
35
16503.75165002501400250,500,500,500,03.803.753.750.001.001.003.403.002.75
36
17003.75170002501450250,500,500,500,03.803.753.750.001.001.003.403.002.75
37
17503.75175002501500250,500,500,500,04.153.753.750.001.001.003.753.002.75
38
18004.00180005001300500,500,500,500,04.154.154.000.000.001.003.753.403.00
39
18504.00185005001350500,500,500,500,04.154.154.000.000.001.003.753.403.00
40
19004.00190005001400500,500,500,500,04.404.504.000.000.001.004.003.753.00
41
19504.00195005001450500,500,500,500,04.404.504.000.000.001.004.003.753.00
42
20004.00200005001500500,500,500,500,04.404.504.000.000.001.004.003.753.00
43
20504.40205001001950100,500,500,500,500,04.404.754.401.000.001.004.004.003.40
44
21004.40210001002000100,500,500,500,500,04.404.754.401.000.001.004.004.003.40
45
21504.75215002501900250,500,500,500,500,04.804.754.750.001.001.004.404.003.75
46
22004.75220002501950250,500,500,500,500,04.804.754.750.001.001.004.404.003.75
47
22504.75225002502000250,500,500,500,500,05.154.754.750.001.001.004.754.003.75
48
23005.00230005001800500,500,500,500,500,05.155.155.000.000.001.004.754.404.00
49
23505.00235005001850500,500,500,500,500,05.155.155.000.000.001.004.754.404.00
50
24005.00240005001900500,500,500,500,500,05.405.505.000.000.001.005.004.754.00
51
24505.00245005001950500,500,500,500,500,05.405.505.000.000.001.005.004.754.00
52
25005.00250005002000500,500,500,500,500,05.405.505.000.000.001.005.004.754.00
53
25505.40255001002450
100,500,500,500,500,500,0
5.405.755.401.000.001.005.005.004.40
54
26005.40260001002500
100,500,500,500,500,500,0
5.405.755.401.000.001.005.005.004.40
55
26505.75265002502400
250,500,500,500,500,500,0
5.805.755.750.001.001.005.405.004.75
56
27005.75270002502450
250,500,500,500,500,500,0
5.805.755.750.001.001.005.405.004.75
57
27505.75275002502500
250,500,500,500,500,500,0
6.155.755.750.001.001.005.755.004.75
58
28006.00280005002300
500,500,500,500,500,500,0
6.156.156.000.000.001.005.755.405.00
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
Loading...