"Data are simply raw facts that describe the characteristics of an event ..... information is defined as being data organized in a meaningful way to be useful to the user" (Richardson et. al. p. 6).

Attached is a data file for your review. These data reflect purchases made by your customers. Management wants you to prepare instructions for the summer interns from the local high school (who have never taken an accounting class) that will allow them to calculate the accounts receivable amount for each customer as of 8/31/2015.

You should assume that the interns do not know how to use Excel and that they will manually calculate accounts receivable using a handheld calculator that does not have a memory key and an MS word document for recording their results. In your instructions, you should reference them to a printout of the Excel Workbook in its entirety. Be sure to provide step by step instructions; your instructions will be used by a classmate to do the actual calculations. Please provide your instructions in an MS Word file.

this is all the info i was given

+40ly 5656 B D E F G 1 Cash DisNumber CashDisbDate CashDibsAmt CheckNumber AcctNum CashierEm VendorID 2 CD01 1/4/2015 300.00 4545 E16 3 CDO2 1/5/2015 6,547.48 5656 E16 S1212 4 CD03 1/15/2015 300.00 4545 E16 5 CD04 1/15/2015 400.00 5656 E16 6 CD05 1/15/2015 480.00 4545 E16 7 CD06 1/15/2015 500.00 4545 E16 8 CDO7 7/30/2015 264.37 E16 S1212 9 CD08 7/30/2015 450.00 5656 E16 10 CD09 7/31/2015 5,874.63 5656 E16 S2323 71 CD10 7/31/2015 300.00 5656 E16 12 CD11 8/1/2015 749.15 5656 E16 S3434 13 CD12 8/15/2015 2,361.51 5656 E16 S5656 74 CD13 8/15/2015 300.00 5656 E16 15 CD14 8/15/2015 300.00 5656 E16 16 CD15 8/17/2015 1,278.58 5656 E16 S7878 17 CD16 8/17/2015 400.00 5656 E16 18 CD17 8/17/2015 480.00 5656 E16 19 CD18 8/17/2015 500.00 4545 E16 20 CD19 8/18/2015 501.71 5656 E16 S2323 21 CD20 8/20/2015 300.00 4545 E16 22 CD21 8/22/2015 300.00 4545 E16 23 CD22 8/22/2015 400.00 4545 E16 24 CD23 8/30/2015 480.00 4545 E16 25 CD24 8/31/2015 250.00 4545 E16 26 CD25 9/1/2015 450.00 4545 E16 YSB cash receipt table A B D E F CashReceiptNum ReceiptDate ReceiptAmount Cashierld Customerld AcctNumber - CR1 1/5/2015 275,000.00 E16 4545 CR10 3/10/2015 211.69 E16 C16 4545 - CR11 3/15/2015 150.00 E16 C16 4545 : CR12 4/5/2015 300.00 E16 C14 4545 . CR13 4/15/2015 1,376.49 E16 C9 4545 CR14 4/30/2015 34.85 E16 C1 4545 CR15 4/30/2015 19.47 E16 C3 4545 CR16 7/31/2015 250.00 E16 C10 4545 0 CR17 8/15/2015 753.31 E16 C15 4545 1 CR18 9/1/2015 149.76 E16 C2 4545 2 CR19 9/30/2015 1,750.99 E16 C12 4545 3 CR2 1/6/2015 125,000.00 E16 5656 4 CR3 1/11/2015 50,000.00 E16 6767 5 CR4 2/1/2015 8.22 E16 C4 4545 5 CR5 2/15/2015 75.09 E16 C5 5656 7 CR6 2/15/2015 37.28 E16 C12 '5656 3 CR7 2/15/2015 327.70 E16 5656 9 CR8 2/15/2015 267.77 E16 4545 CR9 2/15/2015 85.97 E16 C11 4545 C1 Cash Resourse D BankAcctNum A B 1 CashAcctNum AcctType BankName 2 2323 Petty Office 350E 3 3434 Onhand Office 406G 4 4545 Checking US Quest Bank Checking US S&L 6 6767 Savings SunBank 7 5 5656 table customer D CreditRating 1 CustomerlD CustFirstName B CustLastName Alesi Bodden H Zip Code 07108 89420 2 C1 Eric PhoneNum 8882302304 9897787878 A1 3 C10 Amanda A1 Bordac Emily A1 7787887878 92507 C11 4. 5 C12 6 C13 7 C14 8 C15 A2 A3 Burmaster Caplinger Cobb Cortez Miriam Hailey Lauren Karen 7084551212 9795758989 9987898877 7899871212 32765 07108 92509 32765 A1 E F Address1 Address2 222 Main Suite 209 78 Riverside DR 24 Waterford Lakes 2524 Main ST 790 Broadway Apt. 899 12 Old Farm Rd 125 Central Ave 785 Westbourne 765 Margu 9876 Apple 122 Accord 2393 South 23 Apontis Suite 899 1 Seminole Suite385 34 Mountain 667 Alafaya Suite 203 C16 DePante Michael A1 4071121112 32765 9 A2 B1 B1 A3 10 C2 11 C3 12 C4 13 C5 14 C6 15 C7 16 C8 17 C9 10. Diaz Fay Gamez GreenLaw Gunderman Guy Dan Kasim Brandon Lance Nancy Jodie Arionna Kortney Jimar Saddiq 8095555555 7177777777 9899899989 7471234765 4567891234 4073334455 7878877788 4078899988 32811 92507 92507 89420 92509 89420 32765 32765 A1 A1 B2 A1 employee A B 1 JobCode Description 2 -1 A/P-Payroll Clerk 3 -2 Cashier 4 -3 Purchasing Agent 5 S-1 President/Supervisor 6 S-2 Salesperson PayRateHourly 17.00 21.00 16.00 27.00 13.00 7 employee Table 1 EmplD 2 E15 3 E16 4 E17 5 E18 6 E19 7 E20 8 E21 9 E22 10 E23 11 E24 12 E25 13 E26 14 E27 15 E28 B C D E F G H EmplastName EmpFirstName EmpStreetAddress PhoneNum BirthYear JobCode ZipCode Jimenez Elizabeth 18 Crystal 4079991212 1977 C-1 07108 Larose Susan 212 Ekana 4076966900 1962 C-2 32765 Marshall Davis 343 Firestone 4074506344 1956 S-1 89420 Miller Ashley 8765 Riviera 4077755434 1957 C-3 07108 Norris Curt 876 Deer Run 4073272906 1949 S-2 32765 Owada Hanen 343 Second 4079994831 1952 S-2 32811 Mascaro Catherine 9889 North 4078840711 1970 S-2 89420 Shilling Abby 526 Main St. 4407771234 1985 S-1 32811 Simpson Stevie 578 Broadway 9912224444 1947 S-2 32811 Southworth Jessica 98 Riverside RD 9908997777 1965 C-1 92507 Spencer Brien 568 Kaley Ave 7768881212 1975 C-2 92507 Trees Ohara 453 Main St. 9199992323 1972 C-3 07108 Turek Sarah 598 Carillon Av 4071234567 1987 C-2 32860 Wood Zachary 987 Central Ave 8789998888 1989 C-3 89420 Ihr. Sale tab. I A D 3 5 5 25 10 5 5 25 10 10 31 S25 32 S25 33 S25 34 S26 35 S26 36 S26 37 S26 38 S26 39 526 40 S26 41 S27 42 528 43 S28 44 S28 45 S28 46 S29 47 S29 48 S29 49 S29 50 S30 51 54 52 S5 53 S6 54 S7 55 58 56 59 57 B 1211 3133 4144 2222 3333 4144 4444 6266 7177 8188 3133 1111 2122 2222 3133 4144 4444 7177 8188 1211 7277 6366 5555 6266 4 2 2 1 2 99.99 34.99 19.95 13.96 28.00 19.95 15.99 22.17 15.95 34.95 34.99 194.95 2.50 13.96 34.99 19.95 15.99 15.95 34.95 99.99 9.57 65.00 29.50 22.17 2 N N 5 5 4 1 3 10 15 1 3 3 7277 9.57 6366 59.95 I hv. sale table 3233 1 2 2 3 A B 1 InvoiceNumber SKU 2 S1 2222 3 S1 8188 4 S10 4444 5 S10 8388 6 S11 3233 7 S11 5155 8 S12 2322 9 S12 10 S14 8488 11 S14 9399 12 S16 7477 13 S17 6466 14 S18 1111 15 S19 1211 16 S2 3133 17 S21 1111 18 S21 2122 19 S21 3433 20 S22 4444 21 S22 5155 22 S22 6166 23 S22 6666 24 S23 1211 25 S23 2122 26 S23 2222 27 S23 3133 28 S23 4144 29 S24 3133 C D QuantityInSale ActualUnitSalesPrice 2 13.96 1 34.95 50 15.95 4 7.50 1 20.99 50 24.99 1 8.38 1 20.99 1 13.95 2 9.99 2 79.99 3 39.00 2 194.95 114.95 2 29.95 2 179.99 2 2.50 10 24.95 5 15.99 10 24.99 5 35.95 2 35.00 1 99.99 1 2.50 1 13.96 34.99 1 19.95 4 34.99 N I Ihr. recering table 1 SKU 2 1111 3 1211 4 1411 5 1511 6 2322 7 2422 8 2522 9 3133 10 3233 11 3533 12 4144 13 4244 14 4344 15 4444 16 4544 17 5155 18 5255 19 5355 20 5455 21 5555 22 6266 23 6366 24 6466 25 7177 26 7277 27 8188 28 1311 29 2222 30 3133 31 3333 32 3433 33 4444 34 6266 35 8188 36 3233 37 4444 38 5155 39 7177 40 7777 41 8188 B C D E Receiving RptNum Quantity Received Condition CostPerUnitReceived R1 59 148.33 R1 59 44.50 R1 209 17.16 R1 15 9 4.99 R1 10 9 4.19 R1 109 19.80 R1 109 5.94 R1 20 9 23.09 R1 59 6.93 R1 209 5.15 R1 10 9 14.95 R1 5 9 16.50 R1 25 9 18.45 R1 709 5.00 R1 129 31.50 R1 60 9 16.49 R1 409 4.95 R1 129 16.59 R1 5 9 4.98 R1 10 9 3.95 R1 2009 7.32 R1 10 9 40.95 R1 15 9 12.29 R1 159 10.85 R1 109 3.00 R1 2009 23.07 R2 35 8 23.10 R2 30 8 13.96 R2 48 23.09 R2 108 17.50 R2 10 8 17.16 R2 30 8 5.54 R2 258 7.32 R2 15 8 23.07 R3 1 10 6.93 R3 50-10 5.54 R3 50 10 16.49 R3 2'10 10.85 R3 2 10 19.11 R3 2 10 23.07 thr. reciring tab. (2) 2'10 2'10 19.11 23.07 7.99 5'10 2 10 R3 R3 R3 R3 R4 R4 R5 R5 R5 R5 R5 R6 R6 R6 R6 R6 R6 57 5 7 28 28 28 58 28 25 9 45 9 66 9 249 509 50 9 R6 13 9 40 7777 41 8188 42 8388 43 8888 44 1111 45 2122 46 1211 47 2122 48 2222 49 3133 50 4144 51 7477 52 7777 53 8288 54 8488 55 8888 56 9199 57 9299 58 9399 59 9499 60 9599 61 9699 62 2222 63 3133 64 3333 65 4144 66 4444 67 5155 68 6166 69 6666 70 1211 71 3133 72 1111 73 1211 74 3133 75 4144 76 R6 R6 R6 R6 R7 259 50 9 30 9 100 9 29 29 29 29 59 10 9 12.07 148.33 1.50 44.50 1.50 13.96 23.09 14.50 33.26 19.11 6.92 10.87 12.07 3.62 15.61 9.99 3.00 14.28 16.50 13.96 23.09 18.48 14.95 5.54 16.49 24.39 23.10 44.50 23.09 148.33 44.50 23.09 14.95 R7 R7 R7 R7 R7 59 R7 R7 R8 R8 R9 R9 R9 R9 29 58 59 5.10 5'10 5'10 5'10 Purchase ordet tauble 1 PO. 2 PO1 3 PO10 4 P011 5 PO12 6 PO13 7 PO14 8 PO15 9 PO16 10 PO17 11 PO18 12 PO2 13 PO3 14 PO4 15 PO5 16 PO6 17 PO7 18 PO8 19 PO9 B D E Date TotalPO Amount VendorID BuyerEmplD 1/3/2015 6,547.48 S1212 E26 8/12/2015 441.65 S3434 E28 8/14/2015 92.36 S1212 E28 9/1/2015 299.66 S3434 E28 9/4/2015 390.64 $7878 E26 9/5/2015 1,124.80 54545 E18 9/30/2015 946.40 S7878 E18 10/1/2015 39.50 S1212 E18 10/15/2015 109.80 S2323 E18 10/30/2015 21,508.00 S3434 E26 1/4/2015 5,874.63 S2323 E26 1/12/2015 2,361.51 S5656 E26 3/1/2015 1,278.58 S7878 E18 7/22/2015 749.15 S3434 E18 7/25/2015 501.71 $2323 E26 7/27/2015 264.37 S1212 E26 7/30/2015 337.95 $4545 E26 8/10/2015 1,154.35 55656 E28 sule cash receipt . B 1 CashReceiptiD Invoice. AmountApplied 2 CR10 S5 112.42 3 CR10 S9 99.27 4 CR11 S5 100.00 5 CR11 S9 50.00 6 CR12 S10 300.00 7 CR13 S11 1,376.49 8 CR14 S12 34.85 9 CR15 S15 19.47 10 CR16 S21 250.00 11 CR17 S22 420.17 12 CR17 S23 333.14 13 CR18 S24 149.76 14 CR19 S26 1,750.99 15 CR4 S3 8.22 16 CR5 S2 75.09 17 CR6 S4 13.13 18 CR6 S8 24.15 19 CR7 S6 327.70 20 CR8 S7 267.77 21 CR9 S1 85.97 22 save ordet table wer A B D E F 1 SalesOrder. SalesOrderDate TotalSales CustomerNumber EmployeeNumber Invoice. 2 S01 1/12/2015 67.27 C11 E20 S1 3 S010 7/22/2015 423.60 C10 E21 S21 4 S011 7/25/2015 629.70 C15 E21 S22 5 SO12 7/27/2015 354.02 15 E21 S23 6 S013 7/30/2015 500.63 C7 E21 7 S014 7/30/2015 149.76 C2 E20 S24 8 SO15 8/10/2015 1,097.51 C8 E21 S25 9 S016 8/12/2015 752.00 C12 E20 S26 10 S017 8/14/2015 149.76 C3 E21 S27 11 S018 9/1/2015 423.60 C5 E20 S28 12 S019 9/4/2015 355.26 C11 E21 S29 13 SO2 1/12/2015 89.82 C5 E20 S28 14 SO3 1/12/2015 538.32 04 E20 15 SO30 9/4/2015 583.24 C3 E21 16 S031 9/5/2015 1,225.76 C10 E21 17 SO32 9/30/2015 1,251.63 C8 E21 18 S033 10/1/2015 373.97 C2 E20 19 SO34 10/15/2015 355.83 C15 E20 20 SO35 10/29/2015 0.00 C16 E20 21 SO4 1/12/2015 1,266.08 C12 E20 S26 22 S05 1/12/2015 523.55 C16 E20 23 S06 1/12/2015 1,310.75 C3 E20 24 S07 1/12/2015 278.20 C10 E20 S21 25 S08 3/1/2015 931.39 C14 E21 S10 26 S09 3/1/2015 1,359.43 C9 E21 sale tab A B 1 Invoice. InvoiceDate CustID 2 S1 2/1/2015 011 3 S10 4/1/2015 C14 4 S11 4/1/2015 C9 5 S12 4/1/2015 C1 6 S13 4/1/2015 C16 7 S14 4/15/2015 C15 8 S15 4/21/2015 C3 9 S16 5/1/2015 04 10 S17 5/20/2015 C4 11 S18 5/29/2015 08 12 S19 6/9/2015 C9 13 S2 2/1/2015 C5 14 S20 6/15/2015 C15 15 S21 7/25/2015 C10 16 S22 7/27/2015 C15 17 S23 7/30/2015 C15 18 S24 8/1/2015 C2 19 S25 8/14/2015 C8 20 S26 8/14/2015 C12 21 S27 8/15/2015 C3 22 S28 8/24/2015 C5 23 S29 8/30/2015 C11 24 S3 2/1/2015 C4 25 S30 10/1/2015 C7 26 S4 2/1/2015 C12 27 S5 2/1/2015 016 28 S6 2/1/2015 C3 29 S7 2/1/2015 C1 30 S8 2/15/2015 C12 31 59 3/1/2015 C16 D E SalespersonlD InvoiceAmount E23 85.97 E23 897.79 E23 1,376.49 E19 34.85 E19 3.65 E23 36.31 E23 19.47 E19 171.18 E19 125.19 E23 424.73 E19 254.62 E23 75.09 E23 67.15 E19 657.49 E19 620.17 E19 333.14 E19 149.76 E19 1,000.08 E19 2,002.99 E19 149.76 E23 512.36 E23 349.23 E23 8.22 E23 427.96 E23 13.13 E23 212.42 E23 327.70 E23 367.77 E19 24.15 E19 199.27 +40ly 5656 B D E F G 1 Cash DisNumber CashDisbDate CashDibsAmt CheckNumber AcctNum CashierEm VendorID 2 CD01 1/4/2015 300.00 4545 E16 3 CDO2 1/5/2015 6,547.48 5656 E16 S1212 4 CD03 1/15/2015 300.00 4545 E16 5 CD04 1/15/2015 400.00 5656 E16 6 CD05 1/15/2015 480.00 4545 E16 7 CD06 1/15/2015 500.00 4545 E16 8 CDO7 7/30/2015 264.37 E16 S1212 9 CD08 7/30/2015 450.00 5656 E16 10 CD09 7/31/2015 5,874.63 5656 E16 S2323 71 CD10 7/31/2015 300.00 5656 E16 12 CD11 8/1/2015 749.15 5656 E16 S3434 13 CD12 8/15/2015 2,361.51 5656 E16 S5656 74 CD13 8/15/2015 300.00 5656 E16 15 CD14 8/15/2015 300.00 5656 E16 16 CD15 8/17/2015 1,278.58 5656 E16 S7878 17 CD16 8/17/2015 400.00 5656 E16 18 CD17 8/17/2015 480.00 5656 E16 19 CD18 8/17/2015 500.00 4545 E16 20 CD19 8/18/2015 501.71 5656 E16 S2323 21 CD20 8/20/2015 300.00 4545 E16 22 CD21 8/22/2015 300.00 4545 E16 23 CD22 8/22/2015 400.00 4545 E16 24 CD23 8/30/2015 480.00 4545 E16 25 CD24 8/31/2015 250.00 4545 E16 26 CD25 9/1/2015 450.00 4545 E16 YSB cash receipt table A B D E F CashReceiptNum ReceiptDate ReceiptAmount Cashierld Customerld AcctNumber - CR1 1/5/2015 275,000.00 E16 4545 CR10 3/10/2015 211.69 E16 C16 4545 - CR11 3/15/2015 150.00 E16 C16 4545 : CR12 4/5/2015 300.00 E16 C14 4545 . CR13 4/15/2015 1,376.49 E16 C9 4545 CR14 4/30/2015 34.85 E16 C1 4545 CR15 4/30/2015 19.47 E16 C3 4545 CR16 7/31/2015 250.00 E16 C10 4545 0 CR17 8/15/2015 753.31 E16 C15 4545 1 CR18 9/1/2015 149.76 E16 C2 4545 2 CR19 9/30/2015 1,750.99 E16 C12 4545 3 CR2 1/6/2015 125,000.00 E16 5656 4 CR3 1/11/2015 50,000.00 E16 6767 5 CR4 2/1/2015 8.22 E16 C4 4545 5 CR5 2/15/2015 75.09 E16 C5 5656 7 CR6 2/15/2015 37.28 E16 C12 '5656 3 CR7 2/15/2015 327.70 E16 5656 9 CR8 2/15/2015 267.77 E16 4545 CR9 2/15/2015 85.97 E16 C11 4545 C1 Cash Resourse D BankAcctNum A B 1 CashAcctNum AcctType BankName 2 2323 Petty Office 350E 3 3434 Onhand Office 406G 4 4545 Checking US Quest Bank Checking US S&L 6 6767 Savings SunBank 7 5 5656 table customer D CreditRating 1 CustomerlD CustFirstName B CustLastName Alesi Bodden H Zip Code 07108 89420 2 C1 Eric PhoneNum 8882302304 9897787878 A1 3 C10 Amanda A1 Bordac Emily A1 7787887878 92507 C11 4. 5 C12 6 C13 7 C14 8 C15 A2 A3 Burmaster Caplinger Cobb Cortez Miriam Hailey Lauren Karen 7084551212 9795758989 9987898877 7899871212 32765 07108 92509 32765 A1 E F Address1 Address2 222 Main Suite 209 78 Riverside DR 24 Waterford Lakes 2524 Main ST 790 Broadway Apt. 899 12 Old Farm Rd 125 Central Ave 785 Westbourne 765 Margu 9876 Apple 122 Accord 2393 South 23 Apontis Suite 899 1 Seminole Suite385 34 Mountain 667 Alafaya Suite 203 C16 DePante Michael A1 4071121112 32765 9 A2 B1 B1 A3 10 C2 11 C3 12 C4 13 C5 14 C6 15 C7 16 C8 17 C9 10. Diaz Fay Gamez GreenLaw Gunderman Guy Dan Kasim Brandon Lance Nancy Jodie Arionna Kortney Jimar Saddiq 8095555555 7177777777 9899899989 7471234765 4567891234 4073334455 7878877788 4078899988 32811 92507 92507 89420 92509 89420 32765 32765 A1 A1 B2 A1 employee A B 1 JobCode Description 2 -1 A/P-Payroll Clerk 3 -2 Cashier 4 -3 Purchasing Agent 5 S-1 President/Supervisor 6 S-2 Salesperson PayRateHourly 17.00 21.00 16.00 27.00 13.00 7 employee Table 1 EmplD 2 E15 3 E16 4 E17 5 E18 6 E19 7 E20 8 E21 9 E22 10 E23 11 E24 12 E25 13 E26 14 E27 15 E28 B C D E F G H EmplastName EmpFirstName EmpStreetAddress PhoneNum BirthYear JobCode ZipCode Jimenez Elizabeth 18 Crystal 4079991212 1977 C-1 07108 Larose Susan 212 Ekana 4076966900 1962 C-2 32765 Marshall Davis 343 Firestone 4074506344 1956 S-1 89420 Miller Ashley 8765 Riviera 4077755434 1957 C-3 07108 Norris Curt 876 Deer Run 4073272906 1949 S-2 32765 Owada Hanen 343 Second 4079994831 1952 S-2 32811 Mascaro Catherine 9889 North 4078840711 1970 S-2 89420 Shilling Abby 526 Main St. 4407771234 1985 S-1 32811 Simpson Stevie 578 Broadway 9912224444 1947 S-2 32811 Southworth Jessica 98 Riverside RD 9908997777 1965 C-1 92507 Spencer Brien 568 Kaley Ave 7768881212 1975 C-2 92507 Trees Ohara 453 Main St. 9199992323 1972 C-3 07108 Turek Sarah 598 Carillon Av 4071234567 1987 C-2 32860 Wood Zachary 987 Central Ave 8789998888 1989 C-3 89420 Ihr. Sale tab. I A D 3 5 5 25 10 5 5 25 10 10 31 S25 32 S25 33 S25 34 S26 35 S26 36 S26 37 S26 38 S26 39 526 40 S26 41 S27 42 528 43 S28 44 S28 45 S28 46 S29 47 S29 48 S29 49 S29 50 S30 51 54 52 S5 53 S6 54 S7 55 58 56 59 57 B 1211 3133 4144 2222 3333 4144 4444 6266 7177 8188 3133 1111 2122 2222 3133 4144 4444 7177 8188 1211 7277 6366 5555 6266 4 2 2 1 2 99.99 34.99 19.95 13.96 28.00 19.95 15.99 22.17 15.95 34.95 34.99 194.95 2.50 13.96 34.99 19.95 15.99 15.95 34.95 99.99 9.57 65.00 29.50 22.17 2 N N 5 5 4 1 3 10 15 1 3 3 7277 9.57 6366 59.95 I hv. sale table 3233 1 2 2 3 A B 1 InvoiceNumber SKU 2 S1 2222 3 S1 8188 4 S10 4444 5 S10 8388 6 S11 3233 7 S11 5155 8 S12 2322 9 S12 10 S14 8488 11 S14 9399 12 S16 7477 13 S17 6466 14 S18 1111 15 S19 1211 16 S2 3133 17 S21 1111 18 S21 2122 19 S21 3433 20 S22 4444 21 S22 5155 22 S22 6166 23 S22 6666 24 S23 1211 25 S23 2122 26 S23 2222 27 S23 3133 28 S23 4144 29 S24 3133 C D QuantityInSale ActualUnitSalesPrice 2 13.96 1 34.95 50 15.95 4 7.50 1 20.99 50 24.99 1 8.38 1 20.99 1 13.95 2 9.99 2 79.99 3 39.00 2 194.95 114.95 2 29.95 2 179.99 2 2.50 10 24.95 5 15.99 10 24.99 5 35.95 2 35.00 1 99.99 1 2.50 1 13.96 34.99 1 19.95 4 34.99 N I Ihr. recering table 1 SKU 2 1111 3 1211 4 1411 5 1511 6 2322 7 2422 8 2522 9 3133 10 3233 11 3533 12 4144 13 4244 14 4344 15 4444 16 4544 17 5155 18 5255 19 5355 20 5455 21 5555 22 6266 23 6366 24 6466 25 7177 26 7277 27 8188 28 1311 29 2222 30 3133 31 3333 32 3433 33 4444 34 6266 35 8188 36 3233 37 4444 38 5155 39 7177 40 7777 41 8188 B C D E Receiving RptNum Quantity Received Condition CostPerUnitReceived R1 59 148.33 R1 59 44.50 R1 209 17.16 R1 15 9 4.99 R1 10 9 4.19 R1 109 19.80 R1 109 5.94 R1 20 9 23.09 R1 59 6.93 R1 209 5.15 R1 10 9 14.95 R1 5 9 16.50 R1 25 9 18.45 R1 709 5.00 R1 129 31.50 R1 60 9 16.49 R1 409 4.95 R1 129 16.59 R1 5 9 4.98 R1 10 9 3.95 R1 2009 7.32 R1 10 9 40.95 R1 15 9 12.29 R1 159 10.85 R1 109 3.00 R1 2009 23.07 R2 35 8 23.10 R2 30 8 13.96 R2 48 23.09 R2 108 17.50 R2 10 8 17.16 R2 30 8 5.54 R2 258 7.32 R2 15 8 23.07 R3 1 10 6.93 R3 50-10 5.54 R3 50 10 16.49 R3 2'10 10.85 R3 2 10 19.11 R3 2 10 23.07 thr. reciring tab. (2) 2'10 2'10 19.11 23.07 7.99 5'10 2 10 R3 R3 R3 R3 R4 R4 R5 R5 R5 R5 R5 R6 R6 R6 R6 R6 R6 57 5 7 28 28 28 58 28 25 9 45 9 66 9 249 509 50 9 R6 13 9 40 7777 41 8188 42 8388 43 8888 44 1111 45 2122 46 1211 47 2122 48 2222 49 3133 50 4144 51 7477 52 7777 53 8288 54 8488 55 8888 56 9199 57 9299 58 9399 59 9499 60 9599 61 9699 62 2222 63 3133 64 3333 65 4144 66 4444 67 5155 68 6166 69 6666 70 1211 71 3133 72 1111 73 1211 74 3133 75 4144 76 R6 R6 R6 R6 R7 259 50 9 30 9 100 9 29 29 29 29 59 10 9 12.07 148.33 1.50 44.50 1.50 13.96 23.09 14.50 33.26 19.11 6.92 10.87 12.07 3.62 15.61 9.99 3.00 14.28 16.50 13.96 23.09 18.48 14.95 5.54 16.49 24.39 23.10 44.50 23.09 148.33 44.50 23.09 14.95 R7 R7 R7 R7 R7 59 R7 R7 R8 R8 R9 R9 R9 R9 29 58 59 5.10 5'10 5'10 5'10 Purchase ordet tauble 1 PO. 2 PO1 3 PO10 4 P011 5 PO12 6 PO13 7 PO14 8 PO15 9 PO16 10 PO17 11 PO18 12 PO2 13 PO3 14 PO4 15 PO5 16 PO6 17 PO7 18 PO8 19 PO9 B D E Date TotalPO Amount VendorID BuyerEmplD 1/3/2015 6,547.48 S1212 E26 8/12/2015 441.65 S3434 E28 8/14/2015 92.36 S1212 E28 9/1/2015 299.66 S3434 E28 9/4/2015 390.64 $7878 E26 9/5/2015 1,124.80 54545 E18 9/30/2015 946.40 S7878 E18 10/1/2015 39.50 S1212 E18 10/15/2015 109.80 S2323 E18 10/30/2015 21,508.00 S3434 E26 1/4/2015 5,874.63 S2323 E26 1/12/2015 2,361.51 S5656 E26 3/1/2015 1,278.58 S7878 E18 7/22/2015 749.15 S3434 E18 7/25/2015 501.71 $2323 E26 7/27/2015 264.37 S1212 E26 7/30/2015 337.95 $4545 E26 8/10/2015 1,154.35 55656 E28 sule cash receipt . B 1 CashReceiptiD Invoice. AmountApplied 2 CR10 S5 112.42 3 CR10 S9 99.27 4 CR11 S5 100.00 5 CR11 S9 50.00 6 CR12 S10 300.00 7 CR13 S11 1,376.49 8 CR14 S12 34.85 9 CR15 S15 19.47 10 CR16 S21 250.00 11 CR17 S22 420.17 12 CR17 S23 333.14 13 CR18 S24 149.76 14 CR19 S26 1,750.99 15 CR4 S3 8.22 16 CR5 S2 75.09 17 CR6 S4 13.13 18 CR6 S8 24.15 19 CR7 S6 327.70 20 CR8 S7 267.77 21 CR9 S1 85.97 22 save ordet table wer A B D E F 1 SalesOrder. SalesOrderDate TotalSales CustomerNumber EmployeeNumber Invoice. 2 S01 1/12/2015 67.27 C11 E20 S1 3 S010 7/22/2015 423.60 C10 E21 S21 4 S011 7/25/2015 629.70 C15 E21 S22 5 SO12 7/27/2015 354.02 15 E21 S23 6 S013 7/30/2015 500.63 C7 E21 7 S014 7/30/2015 149.76 C2 E20 S24 8 SO15 8/10/2015 1,097.51 C8 E21 S25 9 S016 8/12/2015 752.00 C12 E20 S26 10 S017 8/14/2015 149.76 C3 E21 S27 11 S018 9/1/2015 423.60 C5 E20 S28 12 S019 9/4/2015 355.26 C11 E21 S29 13 SO2 1/12/2015 89.82 C5 E20 S28 14 SO3 1/12/2015 538.32 04 E20 15 SO30 9/4/2015 583.24 C3 E21 16 S031 9/5/2015 1,225.76 C10 E21 17 SO32 9/30/2015 1,251.63 C8 E21 18 S033 10/1/2015 373.97 C2 E20 19 SO34 10/15/2015 355.83 C15 E20 20 SO35 10/29/2015 0.00 C16 E20 21 SO4 1/12/2015 1,266.08 C12 E20 S26 22 S05 1/12/2015 523.55 C16 E20 23 S06 1/12/2015 1,310.75 C3 E20 24 S07 1/12/2015 278.20 C10 E20 S21 25 S08 3/1/2015 931.39 C14 E21 S10 26 S09 3/1/2015 1,359.43 C9 E21 sale tab A B 1 Invoice. InvoiceDate CustID 2 S1 2/1/2015 011 3 S10 4/1/2015 C14 4 S11 4/1/2015 C9 5 S12 4/1/2015 C1 6 S13 4/1/2015 C16 7 S14 4/15/2015 C15 8 S15 4/21/2015 C3 9 S16 5/1/2015 04 10 S17 5/20/2015 C4 11 S18 5/29/2015 08 12 S19 6/9/2015 C9 13 S2 2/1/2015 C5 14 S20 6/15/2015 C15 15 S21 7/25/2015 C10 16 S22 7/27/2015 C15 17 S23 7/30/2015 C15 18 S24 8/1/2015 C2 19 S25 8/14/2015 C8 20 S26 8/14/2015 C12 21 S27 8/15/2015 C3 22 S28 8/24/2015 C5 23 S29 8/30/2015 C11 24 S3 2/1/2015 C4 25 S30 10/1/2015 C7 26 S4 2/1/2015 C12 27 S5 2/1/2015 016 28 S6 2/1/2015 C3 29 S7 2/1/2015 C1 30 S8 2/15/2015 C12 31 59 3/1/2015 C16 D E SalespersonlD InvoiceAmount E23 85.97 E23 897.79 E23 1,376.49 E19 34.85 E19 3.65 E23 36.31 E23 19.47 E19 171.18 E19 125.19 E23 424.73 E19 254.62 E23 75.09 E23 67.15 E19 657.49 E19 620.17 E19 333.14 E19 149.76 E19 1,000.08 E19 2,002.99 E19 149.76 E23 512.36 E23 349.23 E23 8.22 E23 427.96 E23 13.13 E23 212.42 E23 327.70 E23 367.77 E19 24.15 E19 199.27