Appendix Adjustment Data on an End-of. Period Spreadsheet Alert Security Services Co. offers security services to business dents. The trial balance for Alert Security Services Co. has been prepared on the followi for the year ended October 31, 2015. In addition, the data for year-end adjustments are as follows: a. Fees earned but not yet billed, $13. b. Supplies on hand, 34. c Insurance premiums expired, $10. d. Depreciation expense, 53. e. Wages accrued but not paid, $1. Enter the adjustment data and place the balances in the Adjusted Triat 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 Adjustments Unadjusted Trial Balance Dr. Cr. Adjusted Trial Balance Account Title Dr. Cr. Dr. Cash Cr. 12 12 90 Accounts Receivable Supplies 13 0 103 8 4 Prepaid Insurance 12 Land 190 Equipment 50 Accumulated Depredation Accounts Payable 36 Wages Payable 0 Brenda Schultz, Capital 250 Brenda Schultz, Drawing Fees Earned 200 13 Fees Earned 200 13 Wages Expense 110 1 Rent Expense 12 0 10 Insurance Expense Utilities Expense 6 Supplies Expense 0 Depreciation Expense 0 3 Miscellaneous Expense 2 Totals 500 500 Feedback Check My Work Adjustments affect both an income statement account and a balance sheet account. Remember that the total debit adjustm debit and credit column totals must remain equal. As you prepare the adjusted trial balance, remember you will add a begin the adjusted amount. However, if the unadjusted trial balance amount is a debit and the adjustment is a credit, you will subtr between a credit unadjusted amount and a debit adjustment to obtain the adjusted amount