Excel Practice Exercise #2 Aging of Accounts Receivable Schedule Data: The details of Accounts Receivable balance for PITA Furniture are as follows: 0-30 days 31-60 days 61-90 days 91-120 days $3,400 Customer Name Jones, Marilyn Davis, Edward Cohen, Frank - King, Allie Hayes, Fred Williams, David $3,700 Total Balance $12,000 $8,700 $6,000 $3,500 $1,800 $4,500 $8,600 $5,000 $6,000 3,500 1,800 4,500 Based on past experience, PITA Furniture has determined that the percentage of receivables expected to become delinquent are as follows: 31-60 days old 61-90 days old 10% 91-120 days old 25% Output: 1) Set up an Excel Worksheet formatted as shown above and calculate the estimated Allowance for Doubtful Account balance for December 31, 2014. 2) Format worksheet as follows: (a) Add total column for each column. (b) Insert the estimated percentage uncollectible under totals for each column. (c) Calculate the dollar amount expected to be uncollectible in each column and total uncollectible. 3) Include your name, course & section number, instructor name. 187 words B 1 E Ex- Type here to search