please help me solve question a and b

A. The following data is the analysis of Culture Supplies. Customer A Cu Abwe Beauty Box S Bush Wacker Cal & Swirl $ Cut Loose $ Hair Affair $ Total Not Yet Due 1-30 Days Du 31-60 Days Duc 61-90 Days Dut Over 90 Days Due 1.9255 1.30 475 150 3.880 S 2.930 S 980 5600 S 2300 S 1.100 $ 1.240 S 1.60 1970 S 1.970 400 $ 400 1.735 $ 480 325 2005 230 Based on past experience, the company estimates the percentage for these uncollectible accounts Not Yet Due 1-30 Days Due 31-60 Days Due 61-90 Days Due Over 90 Days Due 1% 5% 7% 15% 30% Required: (a)Prepare an aging schedule for the company by EXCEL (use SUM formula), determine the amo uncollectible account as of October 31. (b)Use the spaces provided below, write the formulas where requested in the file. (Formulal has done for you as an example.) Culture Supplies Aging Schedule As of October 31.2004 Not Yet Due 1-30 Days Duc 31-60 Days Due 61-90 Days Due Over 90 Days Due Totals Customer A Cut Above Beauty Box Bush Wacker Curl & Swirl Cut Loose Hr Affair Totals Estimate Percentage Estimate Amount Formula Formula! 15 Formula7 Formula2 59 Formula Formula3 75 Formula Formula 155 Formula 10 Formulas 305 Formulall Formula12 Formula 1 Formula 2 Formula 3 Formula 4 Formula 5 Formula 6 SUM(B8:B13) Formula 7 ? Formula 8 ? Formula 9 ? Formula 10 Formula 11 ? Formula 12