Data are simply raw facts that describe the characteristics of an event ..... information is defined as being data organized in a meaningful way to

"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.

+40ly 5656 А B С D E F G 1 Cash DisNumber CashDisbDate CashDibsAmt CheckNumber AcctNum CashierEm VendorID 2 CD01 1/4/2015 300 cash receipt table A B с D E F CashReceiptNum ReceiptDate ReceiptAmount Cashierld Customerld AcctNumber - CR1 1/5/2015 275,00 Cash Resourse D BankAcctNum A B с 1 CashAcctNum AcctType BankName 2 2323 Petty Office 350E 3 3434 Onhand Office 406G 4 4545 C customer D CreditRating 1 CustomerlD CustFirstName B CustLastName Alesi Bodden H Zip Code 07108 89420 2 C1 Eric PhoneNum 8882 employee туре мы A B 1 JobCode Description 2 с-1 A/P-Payroll Clerk 3 С-2 Cashier 4 С-3 Purchasing Agent 5 S-1 President/Super 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 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 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 2 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 1 thr. reciring tab. (2) 210 210 19.11 23.07 7.99 510 2 10 R3 R3 R3 R3 R4 R4 R5 R5 R5 R5 R5 R6 R6 R6 R6 R6 R6 57 5 7 28 28 2 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 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 5 save ordet table wer A B с D E F 1 SalesOrder. SalesOrderDate TotalSales CustomerNumber EmployeeNumber Invoice. 2 S01 1/12/20 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

A 1 CashDisNumber 2 CD01 3 CD02 4 CD03 5 CD04 6 CD05 7 CD06 8 CD07 9 CD08 10 CD09 11 CD10 12 CD11 13 CD12 14 CD13 15 CD14 16 CD15 17 CD16 18 CD17 19 CD18 20 CD19 21 CD20 22 CD21 23 CD22 24 CD23 25 CD24 26 CD25 B D E F G CashDisbDate Cash Dibs Amt CheckNumber AcctNum CashierEm VendorID 1/4/2015 1/5/2015 300.00 6,547.48 300.00 400.00 480.00 500.00 264.37 450.00 5,874.63 300.00 749.15 1/15/2015 1/15/2015 1/15/2015 1/15/2015 7/30/2015 7/30/2015 7/31/2015 7/31/2015 8/1/2015 8/15/2015 8/15/2015 8/15/2015 8/17/2015 1,278.58 8/17/2015 400.00 8/17/2015 480.00 8/17/2015 500.00 8/18/2015 501.71 8/20/2015 300.00 300.00 400.00 480.00 250.00 450.00 8/22/2015 8/22/2015 8/30/2015 8/31/2015 9/1/2015 2,361.51 300.00 300.00 ly ash 4545 5656 4545 5656 4545 4545 5656 5656 5656 5656 5656 5656 5656 5656 5656 5656 5656 4545 5656 4545 4545 4545 4545 4545 4545 E16 E16 E16 E16 E16 E16 E16 E16 E16 E16 E16 E16 E16 E16 E16 E16 E16 E16 E16 E16 E16 E16 E16 E16 E16 S1212 S1212 S2323 $3434 S5656 S7878 S2323

Step by Step Solution

★★★★★

3.49 Rating (162 Votes )

There are 3 Steps involved in it

Step: 1

StepbyStep Instructions for Calculating Accounts Receivable Step 1 Understanding the Data Open the attached Excel Workbook and familiarize yourself wi... blur-text-image