fill the excel blank

B D E F G H M O N 1 2 The trial balance of Ortiz Company as of January 31, 20X1, after the company completed the first month of operations, is shown in the partial worksheet below. 3 4 Required: 5 Complete the worksheet by making the following adjustments: supplies on hand at the end of the month, $8,200; expired insurance, 6 $7,500; depreciation expense on equipment for the period, $3,600. 7 8 9 10 11 Ortiz Company Worksheet January 31, 20X1 Adjustments Debit Credit Adjusted Trial Balance Debit Credit Income Statement Debit Credit Balance Sheet Debit Credit 12 13 Account Name 14 Cash 15 Accounts Receivable 16 Supplies 17 Prepaid Insurance 18 Equipment 19 Accumulated Depreciation - Equipment 20 Accounts Payable 21 Frank Ortiz, Owner's Equity 22 Frank Ortiz, Owner's Draw 23 Fees Income Trial Balance Debit Credit $ 103,000 $ 19,800 $ 37,400 $ 54,000 $ 107,000 $ 23,800 $ 251,000 $ 13,400 $ 92,200 B D E K M N o 10 11 F G H Worksheet January 31, 20X1 Adjustments Debit Credit Adjusted Trial Balance Debit Credit Income Statement Debit Credit Balance Sheet Debit Credit Trial Balance Debit Credit $ 103,000 $ 19,800 $ 37,400 $ 54,000 $ 107,000 12 13 Account Name 14 Cash 15 Accounts Receivable 16 Supplies 17 Prepaid Insurance 18 Equipment 19 Accumulated Depreciation - Equipment 20 Accounts Payable 21 Frank Ortiz, Owner's Equity 22 Frank Ortiz, Owner's Draw 23 Fees Income 24 Supplies Expense 25 Insurance Expense 26 Salaries Expense 27 Depreciation Expense - Equipment 28 Utilities Expense 29 30 Totals $ 23,800 $ 251,000 $ 13,400 $ 92,200 $ 30,200 $ 2,200 $ 367,000 $ 367,000