follow the instructions on the files

profileaboznada007
receivables.xlsx
Home>Computer Science homework help>follow the instructions on the files

Documentation

Ward Consulting
Author
Date
Purpose To age Accounts Receivable and prepare summary reports
Data Definition Table
Field Description Data Type Notes
Invoice Nbr Invoice number Number
Company Name of company Text
Sales Rep Name of sales representative Text
Sales Rep Commission Commission for sales rep Number Lookup up commission rate using sales rep name
Invoice Date Date of invoice Date Enter dates using mm/dd/yyyy
Invoice Amount Amount of invoice Number Accounting format with two decimal places
Days Past Due Number of days invoice past due Number Invoice past due if (current date - invoice date) - 30 is greater than 30 days. Enter 0 if invoice not overdue
Current Invoice amount is current Number Accounting format with two decimal places
1-30 days Invoice amount is overdue 1-30 days Number Accounting format with two decimal places
31-60 days Invoice amount is overdue 31-60 days Number Accounting format with two decimal places
61-90 days Invoice amount is overdue 61-90 days Number Accounting format with two decimal places
Over 90 days Invoice amount is overdue over 90 days Number Accounting format with two decimal places

Invoices

Current
Invoice Nbr Company Sales Rep Sales Rep Commission Invoice Date Invoice Amount Days Past Due Current 1-30 days 31-60 days 61-90 days Over 90 days
10269 Coalescent Technologies Corporation Bright $ 50.70 6/2/16 $ 676.00
10273 Consortium for Ocean Leadership Hamilton $ 128.54 5/28/16 $ 2,142.40
10274 Grow Smart Delaware Hamilton ERROR:#N/A 6/5/16 $ 538.60
10282 MRSI Group, Inc Bright ERROR:#N/A 6/9/16 $ 155.40
10283 Natural Environment Research Co Newton ERROR:#N/A 6/12/16 $ 1,414.80
10291 Normandeau & Associates Bright ERROR:#N/A 5/17/16 $ 552.80
10321 Alpharma,Inc Newton ERROR:#N/A 5/5/16 $ 144.00
10322 Alternatives Res & Dev Fdtn Bright ERROR:#N/A 5/7/16 $ 112.00
10323 Cardio Tech International Inc. Bright ERROR:#N/A 5/8/16 $ 164.40
10327 Citizens for the Protection of Waverly Bay Roberts ERROR:#N/A 6/10/16 $ 2,262.50
10329 Image Acoustics, Inc. Newton ERROR:#N/A 6/27/16 $ 4,819.40
10356 New Mexico Regional Turf Foundation Bright ERROR:#N/A 5/29/16 $ 1,106.40
10358 Ocean Dynamics Inc. Bright ERROR:#N/A 6/2/16 $ 452.00
10368 Synergy Innovations, Inc. Bright ERROR:#N/A 6/6/16 $ 1,834.20
10370 Materials Sciences Corporation Hamilton ERROR:#N/A 5/5/16 $ 1,174.00
10395 Ekloff Marine Corp. Hamilton ERROR:#N/A 1/26/16 $ 2,333.20
10400 Hazen Research Inc. Bright ERROR:#N/A 6/1/16 $ 3,063.00
10401 I. M. A. Dynamite Group, Inc. Bright ERROR:#N/A 6/1/16 $ 3,868.60
10406 Mikel, Inc. Hamilton ERROR:#N/A 2/7/16 $ 2,018.20
10407 Marine BioConversion, LLC Roberts ERROR:#N/A 2/7/16 $ 1,194.00
10410 New Medical Center Bright ERROR:#N/A 5/10/16 $ 802.00
10413 Advanced Scientific Concepts, Inc. Newton ERROR:#N/A 6/16/16 $ 2,123.20
10418 American Heart Association Newton ERROR:#N/A 5/17/16 $ 1,814.80
10430 Foster Corporation Bright ERROR:#N/A 5/2/16 $ 5,796.00
10432 Jet Propulsion Laboratory Bright ERROR:#N/A 5/5/16 $ 485.00
10436 Lyme Disease Assoc of NJ Bright ERROR:#N/A 5/8/16 $ 2,210.80
10439 Institute for Research & Evaluation Bright ERROR:#N/A 5/10/16 $ 1,078.00
10443 Lincoln Institute of Policy Newton ERROR:#N/A 6/15/16 $ 537.60
10463 Pro Change Behavior Systems Hamilton ERROR:#N/A 6/6/16 $ 713.30
10471 American Psychology Foundation Newton ERROR:#N/A 6/11/16 $ 1,328.00
10473 Boston Medical Center Roberts ERROR:#N/A 6/15/16 $ 230.40
10476 CSCS Corp. Roberts ERROR:#N/A 6/17/16 $ 182.40
10480 Promire Gas Company Newton ERROR:#N/A 5/20/16 $ 756.00
10482 Shire Development Inc. Newton ERROR:#N/A 6/21/16 $ 147.00
10483 Global Environment & Technology Foundation Newton ERROR:#N/A 5/26/16 $ 704.00
10484 Argonne National Laboratories Newton ERROR:#N/A 6/26/16 $ 386.20
10496 Lake Simco Conservation Authority Newton ERROR:#N/A 5/5/16 $ 200.00
10500 Perry Institute for Marine Science Bright ERROR:#N/A 5/10/16 $ 550.80
10502 Save the Lions Hamilton ERROR:#N/A 5/11/16 $ 816.30
10520 Army Corp Hamilton ERROR:#N/A 4/30/16 $ 200.00
10527 Cape Cod National Seashore NPS Hamilton ERROR:#N/A 6/5/16 $ 1,670.00
10539 Emitech Newton ERROR:#N/A 6/16/16 $ 355.50
10551 Genix Therapeutics, Inc. Newton ERROR:#N/A 6/28/16 $ 1,836.00
10559 Nationa Park and Recreation Bright ERROR:#N/A 6/6/16 $ 547.80
10566 NM State Agricultural Experiment Station Newton ERROR:#N/A 6/15/16 $ 2,040.00
10567 Northeast Fisheries Science Center Newton ERROR:#N/A 6/15/16 $ 3,109.00
10571 SAECT Newton ERROR:#N/A 6/18/16 $ 647.75
10575 Environ Protection Agcy Roberts ERROR:#N/A 6/21/16 $ 2,147.40
10577 Altuna International Research Co. Newton ERROR:#N/A 6/26/16 $ 569.00
10578 Bigelow Laboratory for Mining Newton ERROR:#N/A 6/25/16 $ 477.00
10586 BoBell Flavors, Inc Hamilton ERROR:#N/A 5/20/16 $ 28.00
10588 Brossman Engineering Bright ERROR:#N/A 5/28/16 $ 3,900.00
10589 Cadmus Group Hamilton ERROR:#N/A 5/29/16 $ 72.00
10590 Catalyst Foundation Newton ERROR:#N/A 5/30/16 $ 1,140.00
10622 Evans Hamilton Inc. Newton ERROR:#N/A 6/2/16 $ 605.00
10623 Intervet International B.V. Hamilton ERROR:#N/A 6/5/16 $ 1,429.75
10625 Laser Fare Advanced Technology Group Newton ERROR:#N/A 6/6/16 $ 479.75
10629 Medical Tech International, Inc Newton ERROR:#N/A 6/5/16 $ 2,775.05
10640 NOMAD Limited Bright ERROR:#N/A 6/15/16 $ 945.00
10667 Northeast Regional Aquaculture Center Hamilton ERROR:#N/A 5/25/16 $ 1,921.00
10671 Sensor Tech, Inc. Bright ERROR:#N/A 6/8/16 $ 920.10
10676 Sino Development Corporation Ltd. Bright ERROR:#N/A 6/15/16 $ 534.85
10678 SORICO Bright ERROR:#N/A 6/18/16 $ 5,256.50
10686 Swedish Board of Fisheries SBF Bright ERROR:#N/A 6/16/16 $ 1,638.45
10687 St Jeremy Hospital Roberts ERROR:#N/A 6/19/16 $ 6,201.90
10689 Acquisition Center Bright ERROR:#N/A 5/6/16 $ 630.00
10702 FM Global Research Bright ERROR:#N/A 6/25/16 $ 330.00
10707 Lamont-Doherty Earth Observatory Roberts ERROR:#N/A 6/29/16 $ 1,704.00
10741 Lemelson Foundation - NCIIA Newton ERROR:#N/A 6/30/16 $ 285.00
10760 Conrad Hamilton ERROR:#N/A 5/21/16 $ 3,304.00
10763 Nalas Engineering Services, Inc. Newton ERROR:#N/A 6/5/16 $ 616.00
10768 Tetra Tech Newton ERROR:#N/A 1/8/16 $ 1,477.00
10776 Chemo International Inc. Bright ERROR:#N/A 6/15/16 $ 6,984.50
10787 Child Wilfare Institute Bright ERROR:#N/A 1/19/16 $ 2,760.80
10790 Ecochlor Roberts ERROR:#N/A 5/22/16 $ 850.00
10807 Emitech, Inc Hamilton ERROR:#N/A 5/31/16 $ 18.40
10815 Kent Electric Newton ERROR:#N/A 5/5/16 $ 40.00
10831 American Cancer Society Bright ERROR:#N/A 6/16/16 $ 2,684.40
10840 DHS Medical Assistance Bright ERROR:#N/A 6/19/16 $ 264.00
10858 EA Engineering, Science & Technology, Inc. Hamilton ERROR:#N/A 2/29/16 $ 649.00
10864 KM Scientific Company Hamilton ERROR:#N/A 5/6/16 $ 282.00
10881 Russell Wisdom Foundation Bright ERROR:#N/A 5/15/16 $ 150.00
10887 Eknor Apex Company Roberts ERROR:#N/A 5/15/16 $ 70.00
10907 Maxwell Technologies Bright ERROR:#N/A 5/27/16 $ 108.50
10926 Memory Pharmaceuticals, Inc Hamilton ERROR:#N/A 6/5/16 $ 514.40
10935 Alaska Department of Fish & Game Bright ERROR:#N/A 6/8/16 $ 700.00
10946 Ardane Therapeutics Hamilton ERROR:#N/A 6/11/16 $ 1,407.50
10957 Frontier Technology. Inc. Newton ERROR:#N/A 4/17/16 $ 1,762.70
10960 Institute of Technology Hamilton ERROR:#N/A 6/18/16 $ 276.60
10962 Merck Sharp & Dohme Corp. Bright ERROR:#N/A 4/18/16 $ 3,584.00
10963 GreenFins LLC Bright ERROR:#N/A 6/18/16 $ 68.00
10966 Pam Roddick Housing Authority Newton ERROR:#N/A 6/19/16 $ 1,255.60
10967 The Armore Corporation Bright ERROR:#N/A 6/22/16 $ 910.40
10982 Hudson River group Hamilton ERROR:#N/A 6/26/16 $ 1,014.00
10996 IODP Management International, Inc Newton ERROR:#N/A 5/2/16 $ 560.00
10998 IUCN-Washington Office Newton ERROR:#N/A 3/5/16 $ 686.00
11007 Optodot Corporation Bright ERROR:#N/A 5/8/16 $ 2,633.90
11026 Adaptive Methods, Inc. Hamilton ERROR:#N/A 3/15/16 $ 1,030.00
11037 Advanced Fuel Research Hamilton ERROR:#N/A 5/21/16 $ 60.00
11064 BAE Systems Roberts ERROR:#N/A 5/31/16 $ 4,722.30
11068 Baylor Research Institute Bright ERROR:#N/A 6/5/16 $ 2,384.80
11069 CACI Technologies, Inc. Bright ERROR:#N/A 3/5/16 $ 360.00

Invoice Reports

Sales Rep Analysis Accounts Receivable Aging
Reps Nbr Invoices Commission Total Amount Age Nbr Invoices $ Amount
Hamilton 0 Current
Newton 0 1-30 days
Bright 0 31-60 days
Roberts 0 61-90 days
Total 0 Over 90 days
Totals
Above
# of Invoices
Total Value
Average Value

Commission

Commission Rates
Bright 7.50%
Hamilton 6%
Newton 4%
Roberts 5.50%