Appendix: Adjustment Data on an End-of-Period Spreadsheet 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, 2045. In addition, the data for year-end adjustments are as follows: : a. Fees earned but not yet billed, $23. b. Supplies on hand, $6. c. Insurance premiums expired, $29. d. Depreciation expense, $12. e. Wages accrued but not paid, $12. 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 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 87 Accounts Receivable 232 Supplies 23 Prepaid Insurance 35 Land 290 Equipment 116 Accumulated Depreciation 12 Accounts Payable 104 Wages Payable 0 Brenda Schultz, Capital 545 Brenda Schultz, Drawing 23 Fees Earned 261 Wages Expense 58 Rent Expense 35 Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 2015 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 87 Accounts Receivable 232 Supplies 23 Prepaid Insurance 35 Land 290 Equipment 116 Accumulated Depreciation 12 Accounts Payable 104 Wages Payable 0 Brenda Schultz, Capital 545 Brenda Schultz, Drawing 23 Fees Earned 261 Wages Expense 58 Rent Expense 35 Insurance Expense 0 Utilities Expense 17 Supplies Expense 0 Depreciation Expense 0 Miscellaneous Expense 6 Totals 922 922