Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security Services Co. has been prepared on the following end-of-period spreadsheet for the year ended October 31, 2075. In addition, the data for year-end adjustments are as follows: a. Fees earned but not yet billed, $31. b. Supplies on hand, $8 c Insurance premiums expired, $39. d. Depreciation expense, $16. e. Wages accrued but not paid, $16. Enter the adjustment data and place the balances in the Adjusted Trial Balance columns. If an amount box does not require an entry, leave it blank Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 2045 Adjusted Trial Balance Unadjusted Trial Balance Acount Title Dr. Cr. Test 2 Chapter 3 & 4 Content Area Adjustments Dr. Cr. Dr. Cr. Cash 312 Accounts Receivable Supplies Prepaid Insurance 31 47 Land 390 Equipment 156 Accumulated Depreciation 16 Accounts Payable 140 Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 2045 Adjustments Adjusted Trial Balance Unadjusted Trial Balance Dr. Cr. Dr. Cr. Dr. Cr. Account Title Cash 117 312 Accounts Receivable Supplies Prepaid Insurance 31 47 Land 390 156 Equipment Accumulated Depreciation 16 140 0 Accounts Payable Wages Payable Brenda Schultz, Capital Brenda Schultz, Drawing 733 31 Fees Earned 351 Wages Expense 78 Rent Expense 47 Insurance Expense 0 Utilities Expense 23 Cash 117 Accounts Receivable 312 31 47 390 156 16 140 0 733 Supplies Prepaid Insurance Land I Equipment Accumulated Depreciation Accounts Payable Wages Payable Brenda Schultz, Capital Brenda Schultz, Drawing Fees Earned Wages Expense Rent Expense Insurance Expense Utilities Expense Supplies Expense Depreciation Expense Miscellaneous Expense 31 351 78 47 0 23 0 0 8 Totals 1,240 1,240 Appendix: Completing an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. Complete the following end-of-perlod spreadsheet for Alert Security Services Co. If an amount box does not require an entry, leave it blank Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 2017 Balance Sheet Adjusted Trial Balance Cr. Income Statement Dr. Account Title Dr. Cr. Dr. Cr. Cash 456 Accounts Receivable 3,344 152 Supplies Prepaid Insurance 114 Land 3,800 Equipment 1,520 304 1,368 Accumulated Depreciation Accounts Payable Wages Payable Brenda Schultz, Capital Brenda Schultz, Drawing 152 6,612 304 Fees Earned 3,724 Wanau Evnene 012 Dr. Cr. Dr. Dr. Cr. Account Title 456 Cash 3,344 Accounts Receivable Supplies 152 114 Prepaid Insurance Land 3,800 Equipment 1,520 304 Accumulated Depreciation Accounts Payable 1,368 152 Wages Payable 6,612 Brenda Schultz, Capital Brenda Schultz, Drawing 304 Fees Earned 3,724 912 Wages Expense Rent Expense 456 380 Insurance Expense Utilities Expense 266 Supplies Expense 228 152 Depreciation Expense Miscellaneous Expense 76 Totals 12,160 12,160