On January 1, 2018, the general ledger of 3D Family Fireworks includes the following account balances:

During January 2018, the following transactions occur: January 2 Provide services to customers for cash, $49,100. January 6 Provide services to customers on account, $86,400 January 15 Write off accounts receivable as uncollectible, $3,300 January 20 Pay cash for salaries, 532,800 January 22 Receive cash on accounts receivable, $84,000. January 25 Pay cash on accounts payable, $,900 January 30 Pay cash for utilities during January, $15,100. The following information is available on January 31, 2018. a The company estimates future uncollectible accounts. The company determines S4.300 of accounts receivable on January 31 are past due and 20% of these accounts are estimated to be uncollectible. The remaining accounts receivable on January 31 are not past due, and 5% of these accounts are estimated to be uncollectible. (Hint: Use the January 31 accounts receivable balance calculated in the general ledger) b. Supplies at the end of Januarytotal S950 c. Accrued interest revenue on notes receivable for January. Interest is expected to be received each December 31 d. Unpaid salaries at the end of January are S34,900 General Ledger General RequirementJournal Trial BalanceStatement Balance Sheet Analysis 1. Record each of the transactions listed above in the 'General Journal tab (these are shown as items 1 -7). Review the General Ledger' and the 'Trial Balance tabs to see the effect of the transactions on the account balances. 2. Record the adjusting entries in the 'General Journal tab (these are shown as items 8-11). 3. Review the adjusted 'Trial Balance' as of January 31, 2018, in the Trial Balance' tab. 4. Prepare an income statement for the period ended January 31, 2018, in the Income Statement tab. 5. Prepare a classified balance sheet as of January 31, 2018 in the 'Balance Sheet tab. 6. Record the closing entries in the 'General Journal tab (these are shown as items 12 and 13). 7. Using the information from the requirements above, complete the Analysis' tab. General Journal> If no entry is required for a transaction/event, select "No journal entry required" in the first account field. View transaction list Journal entry worksheet 23 45 6 78 13 Provide services to customers for cash, $49,100. Note: Enter debits berore credits. Date General Journal Debit Credit Jan 02 Record entry Clear entry View general journal General Ledger> Unadjusted General Ledger Account Cash Accounts receivable Date Debit Date Debit Dec 31 26,700 Dec 31 15,000 Allowance for uncollectible accounts Note receivable Date Debit Date Debit Dec 31 3,600 Dec 31 18.000 Date Debit Date Debit Credit Dec 31 3.900 Dec 31 80,300 Accounts payable Common stock Date Debit Date Debit Dec 31 8,500 Dec 31 8,000 Retained earnings Date Debit Dec 31 33.800 General Journal Trial Balance> you choose will be the values used to populate the income stat ement and balance sheet tabs. Unadjusted 3D Family Fireworks Trial Balance January 30, 2013 Account Title Debit Credit Cash Accounts receivable Allowance for uncollectible accounts Note receivable Supplies Land Accounts payable Common stock Retained earnings 26,700 5,000 3,600 18,000 3,900 80,300 8,500 98,000 33,800 143,900 Total 143,900 S General Ledger Income Statement> Choose the appropriate accounts to complete the company's balance sheet. Make sure to select 'adjusted' from the dropdown, which will then populate the balances in those accounts from the adjusted trial balance. Unadjusted 3D Family Fireworks Balance Sheet January 31, 2018 Assets Liabilities Current Assets: Current Liabilities: Total Current Liabilities Total Liabilities Noncurrent Assets Stockholders Equity: Total Assets Total Liabilities & Stockholders' Equity Income Statement Analysis Unadjusted 3D Family Fireworks Income Statement For Month Ended January 31, 2018 Revenue Total Revenue Expenses Total Expenses Trial Balance Balance Sheet > Enter your Accounts Receivable turnover value in one decimal place and Ratio of Allowance for Uncollectible Accounts in Whole number Analyze how well 3D Family Fireworks manages its receivables Calculate the receivables turnover ratio for the month of January (Hint For the numerator, use total services provided to customers on account). If the industry average of the receivables turnover ratios for the month of January is 4.7 times, is the company collecting cash from customers more or less efficiently than other companies in the same industry ccounts Receivable turnover: e company is g more efficiently. (true or false) (b) Calculate the ratio of Allowance for Uncollectible Accounts to Accounts Receivable at the end of January. Based on a comparison of this ratio to the same ratio at the beginning of January, does the company expect an improvement or worsening in cash collections from customers on credit sales? Ratio of Allowance for Uncollectitile to Accounts Receivable Should the company expect improving or worsening conditions?