Idea Assignment week 2

profilemaiezymq12
ReynoldsCompany_AP.xlsx

AP

Inv. Amt Inv. Date Inv. # Product # Quantity Unit cost Vendor #
2549.13 2/14/12 14775063 10891211 93 27.41 79738100
27574.46 2/14/12 56199930 10899801 1006 27.41 76930400
32727.54 2/14/12 16266612 10950627 1194 27.41 10325300
20036.71 2/14/12 14780349 10950688 731 27.41 95638100
43307.8 2/14/12 14551610 10950991 1580 27.41 11316100
23628.78 1/27/12 12237848 10951657 126 187.53 11471500
9049.32 1/27/12 16267299 10951702 126 71.82 95515000
1104 1/27/12 30429400 10951708 24 46 88268800
947.72 1/27/12 16267124 10960673 19 49.88 82461200
59.4 1/27/12 12236414 10960824 6 9.9 10621500
5012.98 8/28/11 14610870 10962589 854 5.87 10838400
652.58 8/28/11 14503868 10971023 134 4.87 81030400
9169.92 8/28/11 20889358 11348398 576 15.92 94076500
17779.74 8/28/11 14505021 12224279 474 37.51 82468800
4309.2 9/26/11 16272743 12224436 216 19.95 89576500
2185.7 9/26/11 13419246 12244038 110 19.87 83684200
4823.6 12/27/11 17157875 12262648 310 15.56 94215000
2959.2 12/27/11 73328600 12263423 180 16.44 80368800
3628.69 12/27/11 17555000 12350736 103 35.23 84238100
10648.26 2/9/12 14353640 12374210 189 56.34 86015000
31940.58 2/9/12 54695800 12476177 791 40.38 10286800
8479.8 2/9/12 57441300 12477278 210 40.38 10316100
77648.72 2/9/12 18485700 12477508 472 164.51 86515000
631.67 1/27/12 11158482 12767121 113 5.59 89715000
2142.63 1/27/12 14678520 12863679 179 11.97 96738100
4708.5 1/27/12 14787423 12863740 645 7.3 91053500
4038.3 1/27/12 24386800 15766978 210 19.23 10348400
1515.19 1/27/12 21622061 21794781 277 5.47 82976500
126.39 1/27/12 14779544 28923492 11 11.49 10338400
183.87 1/30/12 57344000 28975110 9 20.43 91707300
5577.52 1/30/12 12238477 29007381 173 32.24 82507300
10808.18 1/30/12 21622219 29161378 439 24.62 77115000
208 1/18/12 71692700 29166218 32 6.5 81968800
12625.74 1/18/12 16269458 29197992 618 20.43 11106100
11323.8 1/18/12 58672600 29201066 486 23.3 81222700
29125.32 1/18/12 21618705 29208640 42 693.46 97199600
16494.6 1/18/12 54669420 29209439 30 549.82 10999100
1366.24 8/27/11 16275707 29215223 16 85.39 87961200
1005.48 6/3/11 24373140 29268003 28 35.91 10713800
1864.92 7/7/11 17308500 29276267 3 621.64 10104500
225.91 12/28/11 65519440 36336691 19 11.89 79738100
5937.12 12/28/11 23502438 36665787 186 31.92 76930400
1676.88 12/28/11 12236548 36666513 136 12.33 10325300
321.62 12/28/11 12828760 36667045 26 12.37 95638100
535.35 12/28/11 58671400 36674341 43 12.45 11316100
1982.14 12/28/11 57811800 36689212 46 43.09 11471500
3489.4 12/28/11 56956200 36689236 146 23.9 95515000
7510.79 12/28/11 19272200 36689987 287 26.17 88268800
3610.88 12/28/11 30649200 36693012 64 56.42 82461200
2878.83 12/28/11 54601100 36693108 29 99.27 10621500
201.12 1/12/12 11151413 36799189 6 33.52 10838400
1148.98 12/28/11 59086100 36799431 29 39.62 81030400
1209.59 12/28/11 14755290 36799613 43 28.13 94076500
2210.2 12/28/11 72551800 36801282 172 12.85 82468800
63512.84 12/28/11 14542920 48691990 404 157.21 89576500
24556.76 12/28/11 72299400 48692522 223 110.12 83684200
5234.88 5/12/11 21630210 48694301 32 163.59 94215000
1145.13 5/12/11 29900100 48698911 7 163.59 80368800
10052.68 2/28/12 21624808 48727092 268 37.51 84238100
9979.2 2/28/12 14676270 48727128 315 31.68 86015000
1636.14 2/28/12 13418714 48734025 67 24.42 10286800
2316.93 5/13/11 17521200 48735356 119 19.47 10316100
2220.25 5/13/11 65470310 63167463 107 20.75 86515000
7187.73 5/13/11 21618386 63506130 253 28.41 89715000
379.17 5/13/11 65529000 63506142 33 11.49 96738100
68460.6 4/9/11 24274070 63506154 4355 15.72 91053500
233532.52 4/29/11 58770200 63506166 3484 67.03 10348400
19187.91 4/29/11 12237804 63529846 687 27.93 82976500
9455.4 4/29/11 14432280 63561488 1030 9.18 10338400
83896.02 11/11/11 21620900 63791569 8721 9.62 91707300
3125.64 11/11/11 72790400 63791944 244 12.81 82507300
3972.69 2/11/12 57352200 63851718 333 11.93 77115000
4736.21 2/11/12 59128800 72721370 397 11.93 81968800
2214.87 4/29/11 13418060 72721382 199 11.13 11106100
769.68 4/29/11 65550440 72721407 72 10.69 81222700
3227.7 4/29/11 30155700 72721431 290 11.13 97199600
198.24 4/29/11 12782400 72723500 12 16.52 10999100
84.27 10/28/11 72528800 72723548 1 84.27 87961200
1941.72 10/28/11 11154644 72723560 11 176.52 10713800
5459.04 10/28/11 17158941 72735854 34 160.56 10104500
5196.96 10/28/11 13807468 72735878 36 144.36 10664500
1987.63 2/4/12 91318540 72735951 47 42.29 93307300
1857.83 2/4/12 88582030 72842370 461 4.03 10664500
2479.54 2/4/12 14221356 72862650 178 13.93 93307300
3328.66 2/4/12 19124810 72868010 298 11.17 11229900
1243.2 2/4/12 91165670 96924180 37 33.6 77953500
3247.75 6/7/11 10804627 96924531 55 59.05 94530400
1496.77 6/7/11 15005000 96928524 121 12.37 97699600
2583.36 6/7/11 13824926 96949360 23 112.32 86253500
434.52 12/6/11 16798500 96949965 9 48.28 84684200
1353.6 12/6/11 13518592 96950001 64 21.15 94530400
696.52 3/8/12 26323193 96950667 11 63.32 77699600
487.54 3/8/12 27151663 96952470 19 25.66 82461200
781.75 3/8/12 14212938 84826635 59 13.25 10621500
1070.25 3/8/12 88521020 84826659 25 42.81 10838400
2825.46 4/17/11 26306987 10962589 66 42.81 81030400
5403.6 4/17/11 24294424 10971023 228 23.7 94076500
1760.01 4/17/11 14222991 11348398 87 20.23 82468800
5359.13 4/17/11 16232591 12224279 49 109.37 89576500
3844.62 6/5/11 13569281 12224436 186 20.67 83684200
45550.95 1/12/12 13631713 12244038 295 154.41 94215000
7595.1 1/12/12 16232946 29168880 135 56.26 80368800