a. Create an aged accounts receivable according to your senior's instructions. Assume there are no receivables...

Transcribed Image Text:

a. Create an aged accounts receivable according to your senior's instructions. Assume there are no receivables still outstanding prior to January 1, 2020. Note that the data set includes all orders received between January 1, 2020, and March 31, 2020. This includes orders that have already been paid for, orders received at the end of March that were shipped but have not been invoiced, and orders that have been received that have not shipped. These orders would not be considered a receivable as of March 31; therefore, these items need to be excluded from the data for this schedule and in other requirements within this assignment. b. What is the total amount of accounts receivable as of March 31, 2020? c. What is the total amount of accounts receivable that are past due less than 30 days? Recall that invoices are due n/30, thus they become past due 30 days after invoice date. d. What is the total amount of accounts receivable that are more than 30 days past due? a. Create an aged accounts receivable according to your senior's instructions. Assume there are no receivables still outstanding prior to January 1, 2020. Note that the data set includes all orders received between January 1, 2020, and March 31, 2020. This includes orders that have already been paid for, orders received at the end of March that were shipped but have not been invoiced, and orders that have been received that have not shipped. These orders would not be considered a receivable as of March 31; therefore, these items need to be excluded from the data for this schedule and in other requirements within this assignment. b. What is the total amount of accounts receivable as of March 31, 2020? c. What is the total amount of accounts receivable that are past due less than 30 days? Recall that invoices are due n/30, thus they become past due 30 days after invoice date. d. What is the total amount of accounts receivable that are more than 30 days past due?

Answer rating: 100% (QA)

To calculate the aged accounts receivable as of March 31 2020 and the amounts past due we need to fo... View the full answer