Question

1 Approved Answer

Posted on Jul 16, 2024

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.

image text in transcribed

+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 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 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 +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 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 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