Hello,

I have been trying to solve this question for a long time and have not been able to solve it. I do not know how to set up the equations and what information to for the equations. It would be very helpful if you can show me how to solve this problem step by step.

a. Aged accounts receivable according to your senior's instructions. Assume there are no receivables still outstanding prior to January 1, 2017. Note that the data set includes all orders received between January 1, 2017, and March 31, 2017. This includes 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, 2017?

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 that 30 days past due?