D F Use the following table for your calculations Minimum Days 1 31 Maximum Day 30 60 90 365 %Uncollectible 1% 29 5% SON 61 91 Requirement 1 Calculate the number of days each receivable is outstanding. (See hints below.) (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 Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) DATA Days Outstanding Uncollectibles 3 3 Customer Name Bonneville Chinook Duwamish Foss Nequally Warden $ s $ $ $ 5 Amount 900 1,100 500 350 3,245 250 Today's Date 7/31/18 7/31/18 231/18 7/31/18 7/31/18 7/21/18 Invoice Date 6/28/2018 7/28/2018 5/15/2018 6/5/2018 7/15/2018 4/12/2018 3 2 3 1 5 Requirement 2 Complete the Schedule of Accounts Receivable. (See hints below. Use #SUM() for totals Complete all blue highlighted cells.) (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. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values 7 Schedule of Accounts Receivable 1-30 Days 31-60 Days 61-90 Day 91-365 Days Total Balance 1 2 4 5 6 7 Customer Name Bonneville Chinook Duwamish Fou Niiqually Worden Totals Estimated uncollectible Latimated total uncollectible 19 30 Instructions ENTERANSWERS + 3 C H Balances on July 31, 2018 41 42 43 44 45 Allowance for Bad Debts Accounts Receivable 5,345 65 (65 46 48 49 50 51 Requirement Journaline the adjusting entry for Bad Debts Expense (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. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) 52 sa 54 Account / Explanation Debit Credit HINTS 56 57 50 59 50 61 Cell. Hint F16.G21 Use the functions -DAYSand WVLOOKUPO to calculate the days outstanding and corresponding uncollectible values. Do not enter any value for the RANGE_LOOKUP argument of the VLOOKUP function 416 621 Use absolutecell references for the TABLE ARRAY argument of the VLOOKUP O function(Absolutecell reference ses, example $A$1. Use the key to lock in the absolutecell reference C10:35 Use the functions fl) and AND) to calculate the amounts of accounts receivable for each customer for each period, if any. Follow the examples provided in cells C11158 in the instructions tab, Different logic will not be graded as correct one G30:36, C36:G36 Use the function SUMI) to calculate the Totals and Total Balance values in the Schedule of 55 Accounts Receivable 66 C7:37 Refer to the data table in cells for the corresponding values of the Estimated uncollectible 67 G37 Leave this collblank. 68 When entering account names, click the arrow on the right side of the cell to select the appropriate account 69 90 71 72 74 75 70 77 Instructions ENTERANSWERS