Analyze and review the following items and determine the appropriate journal entry. Record the journal entry
a. Calculate bad debt 01] December 31, after many attempts at collecting the outstanding balance of Copper Galleijr, the controller decided to write oil that balance. Aylmer calculates bad debt on trade receivables only, not on project receivables. Bad debt is estimated to be: 0.30 days 1% 31 50 days 5% 61 90 days 7.5% 91 120 days 10% Over 120 days15% In the excel spreadsheet, see the tab labelled \"Trade Accounts Receivable Detail" to perform an}.r necessary calculations. Customer Name Total Due 0-30 Days 31-60 days 61-90 days 91-120 days Over 120 4210119 Ont Ltd 261,181 155,894 50,199 50,094 4,994 43rd Street Place 6,625 6,494 131 6 Star Services 65,675 31,310 30,699 3,666 9900 International Corp 140,792 90,981 49,811 A1 Distributions 130,734 65,944 62,902 944 944 Aylmer Enterprises 137,818 134,586 3,232 Booktime Services 99,797 99,643 Box Top Inc 49,049 13,031 13,031 13,031 9,956 Briar Forest Corp 2,942 1,443 1,499 Cavhill Industries 122,223 61,999 60,113 111 Colborne Corp 1,313 1,313 Copper Gallery 12,036 12,036 Dairy Ashford Corp 16,499 16,499 Demilo Inc 83,336 36,785 39,941 6,610 Dustin Enterprises 190,811 64,452 64,161 60,644 1,554 Greenway Place 104,873 71,548 31,661 1,664 Grosvenor Limited 42,877 35,844 7,033 Houston Consultants 48,464 1,319 10,699 36,446 Jesse Blackstone 22,680 9,846 9,846 1,494 1,494 Joseph Company 101,407 31,599 36,510 32,649 649 Lawrence Brothers 58,561 18,846 19,844 19,460 411 Mapleton Express 19,048 18,936 112 OKC Limited 23,376 9,856 9,856 3,664 Oxford Distributing 20,535 9,884 10,651 Paper Brands 105,790 12,636 9,664 36,944 46,546 Plaid Corp 38,631 12,500 12,500 12,500 131 1,000 Quality Logistics 24,565 2,131 2,236 2,066 1,691 16,441 TC Jester 100,665 49,666 49,666 1,333 Wellington Limited 138,144 65,478 72,666 Westella Drive LTD 14,410 6,944 6,411 1,055 Woodplank Inc. 1,065 1,065 Yellow Street Ltd 1,328 664 664 Zephyr Limited 636 318 318 TOTAL 2,187,886 1,138,389 662,712 283,942 70,747 32,096