this is all teacher gave

Receivables and Revenue Evaluate collectibility using the allowance for uncollectible accounts The following data is given for Autumn Corporation for the end of the current year before adjusting entries). Accounts Receivable $ 76,000 Allowance for Uncollectible Accounts (credit balance) $ 11,000 Service revenue for the year (all on credit) $ 490,000 Estimated uncollectible-account expense rate (Requirement 2% of credit sales 1 assumption) Estimated Allowance for Uncollectible Accounts credit 21,000 balance (Requirement 2 assumption) Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong a. Requirements 1 Using the percent-of-sales method, calculate the amount of Uncollectible Account Expense using Autumn Corporation's estimated uncollectible-account expense rate identified in the data table. What is the ending balance of the Allowance for Uncollectible: Accounts under this scenario? Enter all amounts as positive values. 2 Now assume that Autumn Corporation uses the aging of receivables method. Using the estimated credit balance in its Allowance for Uncollectible Accounts Identified in the data table, calculate the amount of its Uncollectible Account Expense. What is the ending balance of the Allowance for Uncollectible Accounts under this scenario? Enter all amounts as positive values. Consider this situation independently from the previous one. a. b. 1. Using the percent-of-sales method, calculate the amount of Uncollectible-Account Expense using Autumn Corporation's estimated uncollectible-account expense rate identified in the data table. What is the ending balance of the Allowance for Uncollectible-Accounts under this scenario? (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.) Uncollectible-Account Expense Allowance for uncollectible- accounts, ending balance 2. Now assume that Autumn Corporation uses the aging-of-receivables method. Using the estimated credit balance in its Allowance for Uncollectible Accounts identified in the data table, calculate the amount of its Uncollectible-Account Expense. What is the ending balance of the Allowance for Uncollectible Accounts under this scenario? (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.) Uncollectible-Account Expense Allowance for uncollectible- accounts, ending balance