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. Foes earned but not yet billed, $12. b. Supplies on hand $3. C. Insurance premiums expired, $15. d. Depreciation expense, $6. e. Wages accrued but not paid, $6. 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 Dr. Cr. Adjusted Trial Balance Dr. Cr. Account Title Dr. Cr. Cash 45 Accounts Receivable 120 Supplies 12 18 Prepaid Insurance Land 150 Equipment 60 120 Accounts Receivable Supplies 12 Prepaid Insurance 18 Land 150 60 Equipment Accumulated Depreciation Accounts Payable 54 Wages Payable 0 Brenda Schultz, Capital 282 Brenda Schultz, Drawing 12 Fees Earned 135 30 Wages Expense Rent Expense 18 Insurance Expense 0 9 Utilities Expense Supplies Expense Depreciation Expense 0 0 Miscellaneous Expense 3 Totals 477 477