Idea week 2 assignment

maiezymq12
Ames_AR.xlsx
Home>Business & Finance homework help>Accounting homework help>Idea week 2 assignment

Ames Receivables

Customer_Number Invoice_Number Amount
795401 206300 225.87
795401 207137 180.92
516372 211206 1,610.87
784647 212297 737.36
501657 212824 1,524.32
230575 213052 8.85
836004 213184 1,469.77
836004 213194 2,151.72
812465 213227 3,582.98
836004 213240 475.99
65003 213248 874.97
478604 213256 251.81
262001 213264 892.80
65003 213277 1,280.20
262001 213290 1,666.32
262001 213293 998.19
262001 213294 810.12
262001 213295 3,567.34
65003 213296 945.40
641464 213297 665.28
262001 213299 1,215.54
925007 213304 614.78
376005 213309 931.55
925007 213317 2,180.04
925007 213318 1,418.09
501657 213325 4,426.14
501657 213326 945.40
501657 213327 3,633.40
501657 213328 1,030.43
925007 213342 662.11
641464 213350 1,234.30
641464 213351 1,849.65
65003 213354 1,189.11
376005 213355 374.71
925007 213357 2,972.78
925007 213358 2,363.49
925007 213369 2,906.72
925007 213370 945.40
376005 213377 886.84
65003 213385 540.19
65003 213386 418.27
65003 213387 1,189.11
501657 213390 5,549.19
501657 213391 1,382.46
501657 213392 1,465.30
501657 213398 473.04
65003 213406 615.64
65003 213409 3,152.46
65003 213411 1,465.42
65003 213412 1,771.46
230575 213418 206.69
376005 213420 25.62
501657 213423 146.80
501657 213424 146.80
501657 213425 92.18
641464 213430 924.82
376005 213432 518.01
376005 213433 683.06
262001 213436 1,189.11
925007 213438 1,189.11
262001 213439 1,189.11
262001 213440 348.56
925007 213442 741.39
65003 213444 2,576.41
65003 213446 615.64
641464 213448 1,255.17
65003 213449 1,755.52
65003 213450 1,189.11
925007 213457 1,189.11
65003 213474 1,783.67
297397 213476 3,303.09
501657 213508 431.79
65003 213510 209.13
65003 213511 4,954.64
65003 213512 2,801.20
65003 213514 2,069.13
65003 213515 2,378.22
925007 213517 784.21
376005 213522 531.40
812465 213531 1,189.11
812465 213532 945.40
376005 213537 592.42
925007 213542 945.40
925007 213558 1,189.11
176437 213562 1,519.32
176437 213564 1,519.32
258024 213565 810.26
258024 213566 303.99
51593 213567 1,189.11
925007 213569 1,189.11
501657 213572 54.66
869033 213580 699.91
65003 213591 1,124.77
65003 213593 2,397.31
925007 213594 621.00
376005 213595 516.30
376005 213596 483.61
65003 213597 1,981.62
65003 213598 1,397.12
811002 213607 1,189.11
811002 213608 452.56
641464 213611 614.78
938010 213622 1,332.47
230575 213633 51.39
925007 213644 1,189.11
262001 213646 865.10
262001 213647 1,192.80
376005 213650 435.20
376005 213651 392.24
811002 213655 32.09
925007 213656 698.58
277097 213661 461.08
376005 213662 636.17
301037 213666 1,321.24
516372 213672 24.46
516372 213672 58.35
562270 213673 54.54
56016 213674 1,070.92
56016 213675 736.74
501657 213676 1,449.53
811002 213680 191.22
811002 213681 843.45
65003 213685 1,919.58
65003 213690 1,321.24
65003 213691 1,685.10
516372 213695 253.70
516372 213697 466.48
516372 213698 1,260.52
878035 213699 378.45
878035 213700 742.75
812465 213702 1,321.24
641464 213704 614.78
65003 213707 1,189.11
478604 213711 836.74
478604 213712 147.37
516372 213714 1,959.28
516372 213715 1,260.52
811002 213716 1,479.17
811002 213717 1,189.11
811002 213718 318.82
811002 213719 979.59
925007 213721 1,189.11
925007 213722 1,431.74
176437 213727 945.40
516372 213728 10.90
925007 213730 1,189.11
925007 213731 997.91
376005 213734 316.16
262001 213736 1,255.17
262001 213737 892.87
516372 213738 1,783.67
516372 213739 1,102.97
938010 213746 503.26
938010 213747 924.87
938010 213748 682.79
516372 213753 128.41
501657 213755 18.58
516372 213765 628.44
516372 213766 1,897.33
516372 213767 332.01
925007 213771 3,030.71
811002 213776 1,189.11
811002 213777 755.27
176437 213778 574.95
811002 213783 458.56
811002 213786 55.02
811002 213787 1,453.36
516372 213791 250.70
501657 213799 4.64
641464 213804 2,047.92
641464 213805 840.36
925007 213808 1,189.11
811002 213814 1,176.85
811002 213815 1,189.11
518008 213816 1,156.64
513574 213818 40.24
516372 213820 47.34
778088 213823 580.87
641464 213825 1,189.11
641464 213826 693.03
516372 213829 1,260.39
811002 213832 617.41
811002 213833 1,050.44
262001 213837 590.96
518008 213839 610.38
262001 213840 2,044.82
518008 213841 525.97
262001 213846 612.15
262001 213847 1,387.30
262001 213848 717.27
202028 213849 513.94
516372 213850 313.27
513574 213851 51.36
329169 213852 608.90
65003 213853 619.94
516372 213854 1,020.14
836004 213855 376.22
836004 213856 435.49
518008 213857 664.66
376005 213858 754.35
501657 213859 396.37
516372 213862 548.05
811002 213863 1,831.65
518008 213865 362.31
262001 213867 384.01
262001 213868 722.44
65003 213870 519.20
65003 213871 1,313.05
176437 213872 1,203.07
501657 213875 339.33
501657 213876 924.82
501657 213881 60.94
501657 213882 109.96
501657 213883 36.70
836004 213885 382.17
376005 213888 1,235.80
501657 213891 1,189.03
501657 213892 2,133.37
222006 213893 810.33
113236 213894 681.93
65003 213896 1,149.50
65003 213897 1,494.13
222006 213899 676.19
516372 213900 361.33
262001 213901 1,759.73
65003 213904 1,253.86
262001 213905 504.64
262001 213906 886.02
262001 213907 476.02
925007 213908 1,135.76
262001 213909 1,475.34
262001 213914 18.58
230575 213920 24.86
262001 213922 220.21
176437 213923 575.94
65003 213925 1,108.74
262001 213926 307.99
262001 213927 450.67
925007 213929 1,189.11
925007 213930 945.40
925007 213933 1,189.11
262001 213934 226.56
262001 213935 1,189.11
501657 213936 256.80
501657 213937 1,189.11
501657 213938 810.12
811002 213939 448.43
797352 213940 920.05
925007 213941 693.03
535189 213943 599.50
811002 213946 734.02
262001 213947 810.30
262001 213948 498.04
836004 213950 993.78
97627 213955 1,301.83
516372 213956 1,163.57
222006 213959 858.72
811002 213960 1,237.07
516372 213961 32.09
516372 213964 851.90
797352 213965 160.63
925007 213967 2,105.37
65003 213968 1,954.88
376005 213969 407.58
202028 213970 385.23
262001 213971 146.80
376005 213973 871.33
518008 213974 333.16
925007 213975 717.88
925007 213976 665.76
359310 213977 600.98
925007 213981 528.30
925007 213982 1,159.72
811002 213983 1,382.76
925007 213984 481.94
925007 213985 1,974.31
65003 213986 156.26
65003 213987 633.80
65003 213988 1,321.24
65003 213989 734.96
65003 213990 278.84
65003 213991 1,189.11
262001 213992 1,064.55
176437 213993 3,085.20
925007 213994 637.76
925007 213995 945.40
262001 213996 974.49
516372 213997 1,098.29
516372 213998 522.26
516372 213999 712.92
516372 214000 467.58
811002 214001 1,010.14
811002 214002 753.06
516372 214003 520.87
811002 214004 587.09
925007 214005 663.03
925007 214006 1,431.26
65003 214007 1,731.31
65003 214008 2,888.41
297397 214009 699.95
297397 214010 220.21
516372 214011 1,885.82
516372 214013 48.92
925007 214016 661.46
925007 214017 8.92
264629 214018 97.84
297397 214019 436.30
262001 214020 377.37
914508 214021 546.02
65003 214022 3,303.09
65003 214023 1,529.14
65003 214024 1,578.54
65003 214025 638.74
297397 214026 3,038.84
65003 214028 738.10
65003 214029 414.27
641464 214030 665.28
641464 214031 357.77
262001 214032 487.98
262001 214033 1,189.11
262001 214034 1,143.27
262001 214035 209.13
262001 214036 1,717.61
262001 214037 128.38
516372 214038 1,057.82
297397 214039 580.01
207275 214040 1,546.15
262001 214041 739.48
262001 214042 331.83
811002 214043 565.42
222006 214044 390.50
516372 214045 1,122.34
222006 214046 325.98
376005 214047 315.37
65003 214048 407.77
376005 214049 897.45
925007 214052 23.67
925007 214053 26.91
65003 214054 1,926.94
444413 214055 880.18
262001 214056 32.09
925007 214057 334.61
925007 214058 297.78
564291 214059 982.00
512328 214060 1,753.75
65003 214061 2,625.01
516372 214062 762.31
65003 214063 663.68
925007 214064 517.85
222006 214065 446.08
376005 214066 611.28
65003 214067 810.37
264629 214068 146.76
65003 214070 437.18
262001 214072 410.71
297397 214073 729.45
65003 214074 816.60
262001 214075 343.33
836004 214076 462.00
925007 214077 26.91
503458 214078 475.73
778088 214079 348.37
262001 214080 652.08
518008 214081 550.52
65003 214082 685.41
519311 214084 434.44
811002 214085 97.84
925007 214086 692.01
65003 214088 13.08
262001 214091 32.09
516372 214092 140.56
297397 214093 48.92
262001 214094 36.70
925007 214095 3,393.87
641464 214096 2,548.03
641464 214097 991.13
812465 214098 575.54
262001 214099 674.58
262001 214100 380.87
65003 214101 2,430.80
297397 214102 1,648.46
262001 214103 658.08
815062 214104 331.90
262001 214105 1,719.64
81559 214106 1,779.07
65003 214107 332.99
419449 214108 1,468.61
516372 214109 324.70
516372 214110 660.63
820025 214111 454.93
376005 214112 654.36
641464 214113 1,652.83
65003 214114 9.76
65003 214121 29.40
641464 214123 1,587.12
65003 214124 862.84
262001 214125 792.55
262001 214126 128.36
641464 214127 767.77
925007 214128 2,035.20
65003 214129 116.72
641464 214132 27.86
641464 214133 55.73
549479 214134 2,192.94
561669 214135 384.88
925007 214136 357.87
516372 214137 1,020.48
516372 214138 810.32
297397 214139 48.92
65003 214140 703.03
222006 214141 2,487.30
516372 214143 264.19
516372 214144 1,170.01
811002 214145 1,173.90
516372 214146 73.01
516372 214147 1,056.10
297397 214148 1,128.84
262001 214149 903.51
262001 214151 418.49
925007 214152 1,723.45
262001 214153 510.17
518008 214154 624.38
811002 214155 3,409.82
504356 214156 1,641.41
962353 214157 1,915.57
241370 214158 822.08
262001 214159 401.58
561669 214160 137.16
262001 214161 622.27
516372 214162 906.15
516372 214163 152.86
262001 214164 364.40
284354 214165 1,296.71
297397 214166 932.24
925007 214167 397.78
811002 214168 644.27
811002 214169 702.04
811002 214170 997.91
501657 214171 1,379.87
516372 214172 1,040.07
501657 214173 803.05
559491 214174 3,856.88
176437 214175 2,031.66
811002 214176 1,114.98
811002 214177 945.40
262001 214178 366.65
65003 214180 648.74
65003 214185 9.17
812465 214186 611.53
264629 214187 146.76
516372 214188 935.34
516372 214189 1,415.67
518008 214191 415.89
376005 214192 324.91
376005 214193 526.05
65003 214194 1,621.97
65003 214196 2,180.62
65003 214197 343.67
811002 214198 13.74
925007 214199 655.10
962353 214200 24.46
641464 214201 525.22
925007 214202 870.96
176437 214207 586.98
262001 214208 682.09
811002 214209 603.64
516372 214210 312.50
516372 214211 308.57
65003 214212 367.01
811002 214213 624.53
641464 214214 1,208.18
811002 214215 797.43
262001 214216 906.38
176437 214217 880.82
925007 214218 933.80
925007 214219 1,495.75
925007 214220 672.48
811002 214221 466.38
513574 214229 15.64
65003 214233 298.74
925007 214234 623.77
925007 214235 918.98
516372 214236 1,379.43
518008 214237 446.09
516372 214238 439.33
925007 214239 339.55
376005 214240 453.85
65003 214241 1,197.67
65003 214242 908.77
925007 214243 1,088.53
202028 214244 868.57
262001 214245 114.92
65003 214246 938.15
262001 214247 1,088.38
811002 214248 1,229.18
297397 214251 769.27
176437 214252 775.57
176437 214253 463.63
641464 214254 629.33
641464 214255 840.27
231494 214256 1,518.91
925007 214257 2,432.30
925007 214258 1,866.17
65003 214259 894.50
938010 214261 1,215.66
65003 214262 1,430.00
65003 214263 1,303.05
516372 214264 1,462.04
562270 214267 51.42
562270 214269 31.60
562270 214271 60.00
65003 214277 1,316.03
65003 214278 508.46
516372 214279 668.92
925007 214280 1,089.40
811002 214281 220.21
262001 214282 392.41
925007 214283 647.91
518008 214284 1,030.31
925007 214285 568.14
925007 214286 1,839.33
925007 214287 604.56
925007 214288 584.97
262001 214289 607.42
262001 214290 639.85
65003 214291 579.36
994403 214292 573.75
250402 214293 573.74
250402 214294 27.86
620304 214295 573.75
620304 214296 440.24
784647 214298 648.36
784647 214299 18.32
641464 214300 658.15
641464 214301 1,226.17
739622 214302 579.36
90398 214303 579.36
90398 214304 55.02
65003 214305 293.16
262001 214306 571.38
836004 214307 871.55
65003 214308 620.79
516372 214309 718.66
516372 214310 685.30
262001 214311 372.30
925007 214312 959.91
925007 214313 546.01
444413 214314 579.36
925007 214315 735.05
925007 214316 341.03
176437 214317 663.76
925007 214318 696.89
925007 214319 146.80
65003 214320 573.75
564291 214321 584.97
564291 214322 65.42
925007 214323 494.16
641464 214324 1,191.15
925007 214325 440.87
820025 214326 407.77
65003 214327 540.24
869033 214328 362.92
778088 214329 213.60
778088 214330 640.61
925007 214331 882.84
65003 214332 691.94
512328 214333 1,101.89
65003 214334 590.58
925007 214335 720.02
812465 214337 554.02
641464 214338 605.75
501657 214339 594.36
501657 214340 607.54
925007 214341 579.36
516372 214349 66.06
376005 214358 1,006.08
376005 214359 514.62
811002 214360 347.90
811002 214361 573.74
812465 214363 652.48
297397 214364 579.36
811002 214365 834.50
297397 214366 280.91
297397 214367 539.96
925007 214368 18.94
501657 214369 433.93
501657 214370 495.08
242605 214371 539.96
242605 214372 997.09
65003 214373 570.93
65003 214374 73.40
264629 214376 97.84
925007 214377 561.90
925007 214378 111.96
207275 214379 1,654.41
207275 214380 478.12
65003 214381 486.56
262001 214382 821.23
262001 214383 184.77
262001 214384 839.29
463451 214385 335.55
925007 214386 808.20
516372 214387 737.74
516372 214388 6.66
641464 214392 46.77
262001 214393 605.34
516372 13065X 303.81
516372 13452X 66.06
222006 43614X 539.97