p6 Aging Accounts Receivable (AGING) pag 50 , 51 book excel application for accounting principles

LEAANDYO OBJECTIVES - Propare an acounts recanable aging schedule - Apply the alowance method of accounting for uncolect bie acocunts. - interpret changes in colection pattems. - Aler the tle to include one adsisonal curtonse. - Creatio a chant showing epti-ated uncollecticis balances by age category. PROELEM DATA On Qetsber 31, 2012. Easy Broety Beauty Supples had the folloning amounts due from to cuttomera- estmating uncollocibile eccounts: REQUIFEMENT 1. You haw been asked to eshimate the totai amourt of urootect bio accour: October 31 by comploting the file callod AGiNG: 2. Open the fite Moinc trom the website for this book at cergagebrain com. Enfer all fomulas anere inscated on the worksheet (hint. FORMULA1 is =C17. Enter your name in cell A1. Sove your completed tile as Aclingz. Print the worksheet. Ase print your formulas. Chech 3. in the spaois provided below, record the journal entry tor the provision for uncollectible acpounts under each of the following independent absumptions: a. The Alowance for Doubthut Acoourts belore adjustrient has a crudit baiance of $500. Allaw wh. Hise Aice 2. The Alowance for Doubtul Accourts belore asfustment has a debit balance of $250. c. Assume that October's credin sales were $70.000. Uncollectible accounts expense is WHATAF ANALYSIS 4. Erase the aging information for October and enter the toliowing information for November 30.2012 : Save the results as AGING4. Print the worksheet. Has the estirated tctal uncollectible scoounts increased or decreased in November? Explain