Spreadsheet: 48459d1247669541-last-transaction-value-test
Sheet: Sheet2

Month | Item Code | Qty | Wt. Avg Cost | Total Cost
Jan-09 | 30100 | 1164500 | 0.8531000429368828 | 993435
Jan-09 | 30101 | 142500 | 0.9868421052631579 | 140625
Jan-09 | 30301 | 14320 | 19.91340782122905 | 285160
Jan-09 | 30405 | 485000 | 0.4928865979381443 | 239050
Jan-09 | 30406 | 50000 | 0.53 | 26500
Jan-09 | 30408 | 283500 | 0.4880776014109348 | 138370
Jan-09 | 30450 | 205000 | 0.4782926829268292 | 98050
Jan-09 | 30451 | 33000 | 0.48 | 15840
Jan-09 | 30483 | 80000 | 0.4125 | 33000
Jan-09 | 30488 | 80000 | 0.4125 | 33000
Jan-09 | 30489 | 100000 | 0.42 | 42000
Jan-09 | 30518 | 14289 | 8.873000000000001 | 126786.297
Jan-09 | 30702 | 48 | 85 | 4080
Jan-09 | 30911 | 10882 | 8.31 | 90429.42
Jan-09 | 30915 | 480 | 48 | 23040
Jan-09 | 30926 | 120 | 200 | 24000
Jan-09 | 30927 | 120 | 67 | 8040
Jan-09 | 30929 | 48 | 150 | 7200
Jan-09 | 33010 | 20730 | 1.559 | 32318.07
Jan-09 | 34023 | 53565 | 1.18 | 63206.7
Jan-09 | 34030 | 75000 | 1.213 | 90975
Jan-09 | 34040 | 80930 | 1.417 | 114677.81
Jan-09 | 39010 | 114 | 127 | 14478
Jan-09 | 39025 | 4140 | 29.64734299516908 | 122740
Jan-09 | 39030 | 11322 | 14 | 158508
Jan-09 | 90100 | 25 | 115 | 2875
Jan-09 | 90301 | 4000 | 0.11 | 440
Jan-09 | 90310 | 4000 | 0.11 | 440
Feb-09 | 90315 | 6000 | 0.11 | 660
Feb-09 | 30100 | 386500 | 0.8821086675291073 | 340935
Feb-09 | 30101 | 955000 | 0.9546544502617801 | 911695
Feb-09 | 30301 | 18000 | 20.7208 | 372974.4
Feb-09 | 30405 | 435500 | 0.4915729047072331 | 214080
Feb-09 | 30406 | 84500 | 0.48 | 40560
Feb-09 | 30450 | 424700 | 0.4733906286790676 | 201049
Feb-09 | 30451 | 500000 | 0.536 | 268000
Feb-09 | 30483 | 17000 | 0.4 | 6800
Feb-09 | 30484 | 50000 | 0.42 | 21000
Feb-09 | 30489 | 43000 | 0.42 | 18060
Feb-09 | 30516 | 10026 | 5.891 | 59063.166
Feb-09 | 30517 | 9957 | 8.873 | 88348.461
Feb-09 | 30700 | 8 | 310.375 | 2483
Feb-09 | 30909 | 400 | 5.4 | 2160
Feb-09 | 30915 | 384 | 48 | 18432
Feb-09 | 30950 | 420 | 110 | 46200
Feb-09 | 33010 | 10500 | 1.559 | 16369.5
Feb-09 | 34019 | 41770 | 1.222 | 51042.94
Feb-09 | 34023 | 39900 | 1.18 | 47082
Feb-09 | 34030 | 63890 | 1.213 | 77498.57
Feb-09 | 34040 | 89300 | 1.417 | 126538.1
Feb-09 | 39025 | 1920 | 30 | 57600
Feb-09 | 90100 | 25 | 115 | 2875
Feb-09 | 90280 | 18 | 115 | 2070
Feb-09 | 90300 | 20000 | 0.11 | 2200
[NAME] | 30100 | 900000 | 0.9112666666666667 | 820140
[NAME] | 30300 | 3000 | 23.5 | 70500
[NAME] | 30301 | 45680 | 19.87180385288967 | 907744
[NAME] | 30405 | 1347000 | 0.5052115812917595 | 680520
[NAME] | 30406 | 333000 | 0.505945945945946 | 168480
[NAME] | 30408 | 114000 | 0.47 | 53580
[NAME] | 30450 | 315000 | 0.4738095238095238 | 149250
[NAME] | 30451 | 232000 | 0.49 | 113680
[NAME] | 30483 | 114000 | 0.41 | 46740
[NAME] | 30484 | 27000 | 0.42 | 11340
[NAME] | 30485 | 2492 | 6.29 | 15674.68
[NAME] | 30486 | 2439 | 6.29 | 15341.31
[NAME] | 30488 | 46000 | 0.41 | 18860
[NAME] | 30489 | 25000 | 0.42 | 10500
[NAME] | 30516 | 39576 | 6.29 | 248933.04
[NAME] | 30517 | 6146 | 6.290000000000001 | 38658.34
[NAME] | 30701 | 72 | 200.9 | 14464.8
[NAME] | 30702 | 96 | 83.3 | 7996.8
[NAME] | 30703 | 100 | 28.42 | 2842
[NAME] | 30720 | 20000 | 3.95 | 79000
[NAME] | 30911 | 20678 | 6.29 | 130064.62
[NAME] | 30915 | 1200 | 48 | 57600
[NAME] | 30926 | 300 | 195 | 58500
[NAME] | 30927 | 300 | 65 | 19500
[NAME] | 30929 | 144 | 146.25 | 21060
[NAME] | 30931 | 15 | 438.75 | 6581.25
[NAME] | 33010 | 82100 | 1.559 | 127993.9
[NAME] | 34020 | 20860 | 1.18 | 24614.8
[NAME] | 34023 | 153140 | 1.18 | 180705.2
[NAME] | 34030 | 247120 | 1.213 | 299756.56
[NAME] | 34040 | 185600 | 1.417 | 262995.2
[NAME] | 39025 | 1100 | 28 | 30800
[NAME] | 39030 | 35762 | 14 | 500668
[NAME] | 90600 | 10800 | 2.22 | 23976
Apr-09 | 30100 | 726500 | 0.91762560220234 | 666655
Apr-09 | 30103 | 11500 | 1.25 | 14375
Apr-09 | 30300 | 3000 | 23.5 | 70500
Apr-09 | 30301 | 9360 | 20.37358974358975 | 190696.8
Apr-09 | 30305 | 1000 | 20.18 | 20180
Apr-09 | 30405 | 660000 | 0.5075757575757576 | 335000
Apr-09 | 30419 | 1005 | 6.4 | 6432
Apr-09 | 30450 | 550000 | 0.5 | 275000
Apr-09 | 30451 | 650000 | 0.53 | 344500
Apr-09 | 30516 | 15959 | 6.4 | 102137.6
Apr-09 | 30518 | 8050 | 6.4 | 51520
Apr-09 | 30700 | 8 | 311.625 | 2493
Apr-09 | 30720 | 9000 | 3.95 | 35550
Apr-09 | 30911 | 15618 | 6.399999999999999 | 99955.2
Apr-09 | 30915 | 600 | 48 | 28800
Apr-09 | 30926 | 120 | 195 | 23400
Apr-09 | 30927 | 180 | 65 | 11700
Apr-09 | 30929 | 48 | 146.25 | 7020
Apr-09 | 30935 | 162 | 180.04326 | 29167.00812
Apr-09 | 30940 | 300 | 22 | 6600
Apr-09 | 33010 | 16080 | 1.559 | 25068.72
Apr-09 | 34023 | 92000 | 1.18 | 108560
Apr-09 | 34030 | 102290 | 1.213 | 124077.77
Apr-09 | 34040 | 130800 | 1.417 | 185343.6
Apr-09 | 39025 | 6576 | 28.99513381995134 | 190672
Apr-09 | 39030 | 24225 | 14 | 339150
Apr-09 | 90100 | 55 | 115 | 6325
Apr-09 | 90200 | 30 | 115 | 3450
Apr-09 | 90280 | 2 | 115 | 230
Apr-09 | 90300 | 51000 | 0.11 | 5610
Apr-09 | 90316 | 6000 | 0.11 | 660
Apr-09 | 90600 | 3600 | 2.22 | 7992
May-09 | 30100 | 893500 | 0.95217683268047 | 850770
May-09 | 30300 | 3000 | 24.25 | 72750
May-09 | 30301 | 8640 | 21.15166666666667 | 182750.4
May-09 | 30405 | 517000 | 0.51 | 263670
May-09 | 30406 | 280000 | 0.51 | 142800
May-09 | 30418 | 67500 | 1.85 | 124875
May-09 | 30419 | 1200 | 6.4 | 7680
May-09 | 30450 | 192000 | 0.49 | 94080
May-09 | 30517 | 10623 | 6.399999999999999 | 67987.2
May-09 | 30518 | 6128 | 6.4 | 39219.2
May-09 | 30702 | 96 | 83.3 | 7996.8
May-09 | 30703 | 50 | 28.42 | 1421
May-09 | 30929 | 48 | 146.25 | 7020
May-09 | 30931 | 4 | 438.75 | 1755
May-09 | 30935 | 162 | 231.16666 | 37448.99892
May-09 | 33010 | 37150 | 1.559 | 57916.85
May-09 | 34023 | 72100 | 1.18 | 85078
May-09 | 34030 | 97355 | 1.213 | 118091.615
May-09 | 34056 | 64800 | 2.335 | 151308
May-09 | 39025 | 3462 | 28 | 96936
May-09 | 90200 | 35 | 100 | 3500
May-09 | 90300 | 31500 | 0.11 | 3465
May-09 | 90301 | 4000 | 0.11 | 440
May-09 | 90310 | 14000 | 0.11 | 1540
May-09 | 90315 | 7000 | 0.11 | 770
May-09 | 90316 | 3000 | 0.11 | 330
Jun-09 | 30100 | 1098000 | 1.035009107468124 | 1136440
Jun-09 | 30101 | 55000 | 0.94 | 51700
Jun-09 | 30300 | 6000 | 24.25 | 145500
Jun-09 | 30301 | 19040 | 24.18336134453781 | 460451.2
Jun-09 | 30405 | 624000 | 0.5158974358974359 | 321920
Jun-09 | 30406 | 358000 | 0.5275977653631285 | 188880
Jun-09 | 30407 | 228000 | 0.5033333333333333 | 114760
Jun-09 | 30408 | 433000 | 0.4944572748267899 | 214100
Jun-09 | 30450 | 267000 | 0.4982022471910112 | 133020
Jun-09 | 30451 | 862000 | 0.5114385150812065 | 440860
Jun-09 | 30483 | 40000 | 0.43 | 17200
Jun-09 | 30484 | 25000 | 0.45 | 11250
Jun-09 | 30516 | 41668 | 6.693254007871747 | 278894.508
Jun-09 | 30517 | 8917 | 6.895674778512953 | 61488.732
Jun-09 | 30518 | 13847 | 6.892 | 95433.524
Jun-09 | 30702 | 48 | 83.3 | 3998.4
Jun-09 | 30703 | 50 | 28.42 | 1421
Jun-09 | 30911 | 5321 | 6.1525 | 32737.4525
Jun-09 | 30915 | 800 | 47.25 | 37800
Jun-09 | 30926 | 120 | 195 | 23400
Jun-09 | 30927 | 120 | 65 | 7800
Jun-09 | 30931 | 4 | 438.75 | 1755
Jun-09 | 30940 | 360 | 21.6 | 7776
Jun-09 | 30950 | 1200 | 69.5 | 83400
Jun-09 | 33010 | 37450 | 1.559 | 58384.55
Jun-09 | 34023 | 53485 | 1.18 | 63112.3
Jun-09 | 34030 | 100185 | 1.213 | 121524.405
Jun-09 | 34040 | 147025 | 1.417 | 208334.425
Jun-09 | 34058 | 140000 | 0.51 | 71400
Jun-09 | 34059 | 26125 | 1.762 | 46032.25
Jun-09 | 39030 | 25473 | 13.5 | 343885.5
Jun-09 | 90600 | 3600 | 2.25 | 8100