A. The following data is the analysis of Culture Supplies. Customer A Cut Above Beauty Box...

 

 

Transcribed Image Text:

A. The following data is the analysis of Culture Supplies. Customer A Cut Above Beauty Box Bush Wacker Carl & Swirl Cut Loose Hair Affair Not Yet Due 1-30 Days Due 31-60 Days Due 61-90 Days Due Over 90 Days Due 1.925 S 1,300 $ 475 $ 150 3.880 S 2,930 S 950 5.640 S 2.300 S 1.100 S 1.970 Total S $ $ $ 1.970 S $ 400 $ 1.735 Not Yet Due 1-30 Days Due 31-60 Days Due 61-90 Days Duc Over 90 Days Due Customer A Cut Above Beauty Box Bush Wacker Curl & Swirl Cut Loose Hair Affair Totals 1% 5% 7% 15% 30% Based on past experience, the company estimates the percentage for these uncollectible accounts. Formulal Estimate Percentage Estimate Amount Formula7 480 S Required: (a)Prepare an aging schedule for the company by EXCEL (use SUM formula), determine the amo uncollectible account as of October 31. 14 (b)Use the spaces provided below, write the formulas where requested in the file. (Formulal has t done for you as an example.) Formula2 Formulas 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 5% 1,240 S 325 S Formula3 7% Formula9 1.000 S 700 S Formula 15% Formula 10 400 230 Formula5 Formulall 30% Formula6 Formula12 Formula 1 Formula 2 Formula 3 Formula 4 Formula 5 Formula 6 SUM(B8:B13) Formula 7 Formula 8 Formula 9 at at at at of ? ? ? ? Formula 10 Formula 11. Formula 12 at at af at a 2 2 ? ? ? 2 A. The following data is the analysis of Culture Supplies. Customer A Cut Above Beauty Box Bush Wacker Carl & Swirl Cut Loose Hair Affair Not Yet Due 1-30 Days Due 31-60 Days Due 61-90 Days Due Over 90 Days Due 1.925 S 1,300 $ 475 $ 150 3.880 S 2,930 S 950 5.640 S 2.300 S 1.100 S 1.970 Total S $ $ $ 1.970 S $ 400 $ 1.735 Not Yet Due 1-30 Days Due 31-60 Days Due 61-90 Days Duc Over 90 Days Due Customer A Cut Above Beauty Box Bush Wacker Curl & Swirl Cut Loose Hair Affair Totals 1% 5% 7% 15% 30% Based on past experience, the company estimates the percentage for these uncollectible accounts. Formulal Estimate Percentage Estimate Amount Formula7 480 S Required: (a)Prepare an aging schedule for the company by EXCEL (use SUM formula), determine the amo uncollectible account as of October 31. 14 (b)Use the spaces provided below, write the formulas where requested in the file. (Formulal has t done for you as an example.) Formula2 Formulas 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 5% 1,240 S 325 S Formula3 7% Formula9 1.000 S 700 S Formula 15% Formula 10 400 230 Formula5 Formulall 30% Formula6 Formula12 Formula 1 Formula 2 Formula 3 Formula 4 Formula 5 Formula 6 SUM(B8:B13) Formula 7 Formula 8 Formula 9 at at at at of ? ? ? ? Formula 10 Formula 11. Formula 12 at at af at a 2 2 ? ? ? 2

Answer rating: 100% (QA)

Set ANo instructions Set B Formula Please kindly refer to the attached excel document to get the res... View the full answer