Ex 04.24 Appendix: Adjustment Data on an End-of-Period SpreadsheetAlert Security Services Co. offers security services to business clients. The trial balance for Alert Security ServicesCo. has been prepared on the following end-of-period spreadsheet for the year ended October 31, 20Y5. Inaddition, the data for year-end adjustments are as follows:a. Fees earned but not yet billed, $25.b. Supplies on hand, $6.c. Insurance premiums expired, $31.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 doesnot require an entry, leave it blank.

not require an entry, leave Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 20Y5 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 93 Accounts Receivable 248 Supplies 25 Prepaid Insurance 37 Land 310 Equipment 124 ulated D 12 Accounts Payable 112 Wages Payable Brenda Schultz, Capital 583 Brenda Schultz, Drawing 25 10000000 00200800 Fees Earned 279 Wages Expense 62 Rent Expense 37 Insurance Expense 0 Utilities Expense 19 Supplies Expense 0OOOO Depreciation Expense Miscellaneous Expense 986 986 Totals Check My Work All work saved