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, 20YS. In addition, the data for year-end adjustments are as follows: a. Fees earned but not yet billed, $24. b. Supplies on hand, $6. c. Insurance premiums expired, $30 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, 2015 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Cr. Dr. Cr. Cr. Dr. Dr. Account Title Cash 90 240 Accounts Receivable Supplies 24 36 Prepaid Insurance 300 Land Prepaid Insurance 36 Land 300 Equipment 120 Accumulated Depreciation 12 Accounts Payable 108 Wages Payable 0 Brenda Schultz, Capital 564 Brenda Schultz, Drawing 24 Fees Earned 270 Wages Expense 60 Rent Expense 36 Insurance Expense 0 Utilities Expense 18 Supplies Expense 0 Depreciation Expense 0 Miscellaneous Expense 6 954 954 Totals