Chapter 07 Exercise 81 LO 7-6, 7-7 (IDEA Required) You have been instructed to create an aging schedule for EL.M's accounts receivable using IDEA. For the purposes of this exercise, assume the aging begins on the date that the customer is invoiced and should only include valid accounts receivable (e.g. amounts not yet fully paid by the customer). You can assume that rounding differences on discounts taken by customers are considered to be fully paid. Your senior has instructed you to create a schedule with the following tranches Current 0-30 days delinquent, 31-60 days delinquent, 60+ days delinquent. Required: Using the information above, complete all of the related steps shown below using IDEA. After completing each step. answer each question by supplying the required information (Enter your answers exactly as they appear in IDEA. Dollar amounts should be entered to 2 decimal places.) 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? 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 post due 30 days after invoice date. d. What is the total amount of accounts receivable that are more than 30 days post due? a Total number of accounts that are in accounts receivable as of 3/31/2020 Total dollar amount of accounts receivable c. Total number of accounts receivable that are less than 30 days past due Total dollar amount of accounts receivable that are loss than 30 days past due Total number of accounts receivable that are more than 30 days past due Total dollar amount of accounts receivable that are more than 30 days past due