A. The following data is the analysis of Culture Supplies. Customer A Cut Above Beauty Box Bush Wacker Curl & Swirl Cut Loose Hair Affair $ $ $ $ Total Not Yet Due 1-30 Days Due 31-60 Days Due 61-90 Days Due Over 90 Days Due 1,925 $ 1,300 $ 475 $ 150 3,880 $ 2,930 $ 950 5,640 $ 2,300 $ 1,100 $ 1,240 $ 1,000 1,970 $ 1,970 400 $ 400 1,735 $ 480 $ 325 $ 700 $ 230 $ $ Based on past experience, the company estimates the percentage for these uncollectible accounts. Not Yet Due 1% 1-30 Days Due 5% 31-60 Days Due 7% 15% 61-90 Days Due Over 90 Days Due 30% Require: (a) Prepare a aging schedule for the company and determine the amount of uncollectible account as of October 31. (b)Use the spaces provided below, write the formulas where requested in the file. (Formula1 has been done for you as an example.) L Culture Supplies Aging Schedule As of October 31, 2004 Customer Not Yet Due 1-30 Days Due 31-60 Days Due 61-90 Days Due Over 90 Days Due Totals A Cut Above Beauty Box Bush Wacker Curl & Swirl Cut Loose Hair Affair Totals stimate Percentage Estimate Amount Formula6 Formula1 1% Formula7 Formula2 5% Formula Formula3 7% Formula Formula4 15% Formula10 Formula5 30% Formula11 Formula12 Formula 1 SUM(B26:B31) Formula 7 Formula 2 Formula 8 Formula 3 Formula 9 Formula 4 ????? ?????? Formula 10 Formula 5 Formula 11 Formula 6 Formula 12