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, 20Y5. In addition, the data for year-end adjustments are as follows: a. Fees earned but not yet billed, $29. b. Supplies on hand, $7. c. Insurance premiums expired, $36. d. Depreciation expense, $14. e. Wages accrued but not paid, $14. 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, 20Y5 Unadjusted Trial Balance Account Title Dr. Cr. Cash 108 Accounts Receivable 288 Supplies 29 Prepaid Insurance 43 Land 360 Equipment 144 Accumulated Depreciation 14 Accounts Payable Wages Payable Brenda Schultz, Capital Brenda Schultz, Drawing 29 Fees Earned 324 130 0 677 Wages Expense Rent Expense 72 43 Insurance Expense 0 Utilities Expense 22 Supplies Expense 0 Depreciation Expense 0 Miscellaneous Expense 7 Totals 1,145 1,145 Adjusted Trial Balance Cr. Adjustments Dr. Cr. Dr