Chapter 4 Lecture Assignment (part 1) eBook Calculator 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, 2019. In addition, the data for year-end adjustments are as follows: a. Fees earned, but not yet biled, $13. b. Supplies on hand, $4. c. Insurance premiums expired, $10. d. Depreciation expense, $3. e. Wages accrued, but not paid, $1. Enter the adjustment data, and place the balances in the Adjusted Trial Balance columns. If a 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, 2019 Account Title Unadjusted Trial Balance Unadjusted Trial Balance Adjustments Adjustments Adjusted Trial Balance Adjusted Trial Balance Debit Credit Debit Credit Debit Credit Cash 12 Accounts Receivable 90 Supplies 8 Prepaid Insurance 12 190 Land 50 Equipment Accum. Depr.- Equipment Accounts Payable 4 36