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

 
 
 
 
 
 
 
 
 
 
 
 
 
 

Transcribed Image Text:

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

Answer rating: 100% (QA)

StepbyStep Instructions for Calculating Accounts Receivable Step 1 Understanding the Data Open the attached Excel Workbook and familiarize yourself wi... View the full answer