Question

In: Accounting

Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business...

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: Fees earned, but not yet billed, $34. Supplies on hand, $8. Insurance premiums expired, $42. Depreciation expense, $17. Wages accrued, but not paid, $17. 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 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 126 Accounts Receivable 336 Supplies 34 Prepaid Insurance 50 Land 420 Equipment 168 Accum. Depr.-Equipment 17 Accounts Payable 151 Wages Payable 0 Brenda Schultz, Capital 789 Brenda Schultz, Drawing 34 Fees Earned 378 Wages Expense 84 Rent Expense 50 Insurance Expense 0 Utilities Expense 25 Supplies Expense 0 Depreciation Expense 0 Miscellaneous Expense 8 Totals 1,335 1,335

Solutions

Expert Solution

Alert Security Services Co.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended October 31, 2019
Unadjusted Trial Balance Adjustments Adjusted Trial Balance
Account Title Dr. Cr. Dr. Cr. Dr. Cr.
Cash 126 126
Accounts Receivable 336 34 370
Supplies 34 26 8
Prepaid Insurance 50 42 8
Land 420 420
Equipment 168 168
Accum. Depr.-Equipment 17 17 34
Accounts Payable 151 151
Wages Payable 0 17 17
Brenda Schultz, Capital 789 789
Brenda Schultz, Drawing 34 34
Fees Earned 378 34 412
Wages Expense 84 17 101
Rent Expense 50 50
Insurance Expense 0 42 42
Utilities Expense 25 25
Supplies Expense 0 26 26
Depreciation Expense 0 17 17
Miscellaneous Expense 8 8
Totals 1335 1335 136 136 1403 1403

Related Solutions

Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business...
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: Fees earned, but not yet billed, $34. Supplies on hand, $8. Insurance premiums expired, $42. Depreciation expense, $17. Wages accrued, but not paid, $17. Enter the adjustment data, and place...
Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business...
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: Fees earned but not yet billed, $18. Supplies on hand, $4. Insurance premiums expired, $22. Depreciation expense, $9. Wages accrued but not paid, $9. Enter the adjustment data and place...
Appendix: Completing an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. Alert...
Appendix: Completing an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2016 Adjusted Trial Balance Income Statement Balance Sheet Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 12 Accounts Receivable 103 Supplies 4 Prepaid Insurance 2 Land 190 Equipment 50 Accum. Depr. - Equipment 7 Accounts Payable 36 Wages Payable 1 Common Stock 50 Retained Earnings 210 Dividends 8 Fees Earned 213 Wages...
Appendix: Financial Statements From an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business...
Appendix: Financial Statements From an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2016 Adjusted Trial Balance Income Statement Balance Sheet Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 12 Accounts Receivable 103 Supplies 4 Prepaid Insurance 2 Land 190 Equipment 50 Accum. Depr. - Equipment 7 Accounts Payable 36 Wages Payable 1 Common Stock 50 Retained Earnings 210 Dividends 8 Fees Earned...
Appendix: Completing an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. Complete...
Appendix: Completing an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. Complete the following end-of-period spreadsheet for Alert Security Services Co. 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 Adjusted Trial Balance Income Statement Balance Sheet Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 250 Accounts Receivable 1,830 Supplies 83 Prepaid Insurance 62 Land 2,080 Equipment 832...
Appendix 1: Financial Statements From an End-of-Period Spreadsheet Alert Security Services Co. offers security services to...
Appendix 1: Financial Statements From an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 20Y3 Adjusted Trial Balance Income Statement Balance Sheet Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 223 Accounts Receivable 1,637 Supplies 74 Prepaid Insurance 56 Land 1,860 Equipment 744 Accum. Depr.-Equipment 149 Accounts Payable 670 Wages Payable 74 Common Stock 40 Retained Earnings 3,195 Dividends 149 Fees Earned 1,823...
Alert Security Services Co. offers security services to business clients. Based on the end-of-period spreadsheet, prepare...
Alert Security Services Co. offers security services to business clients. Based on the end-of-period spreadsheet, prepare the closing entries for Alert Security Services Co. Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2018 1 Adjusted Adjusted 2 Trial Balance Trial Balance Income Statement Income Statement Balance Sheet Balance Sheet 3 Debit Credit Debit Credit Debit Credit 4 Cash 13.00 5 Accounts Receivable 108.00 6 Supplies 8.00 7 Prepaid Insurance 2.00 8 Land 184.00 9 Equipment 50.00...
Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security...
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, 2016: Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2016 1 Unadjusted Unadjusted Adjusted Adjusted 2 Trial Balance Trial Balance Adjustments Adjustments Trial Balance Trial Balance 3 Debit Credit Debit Credit Debit Credit 4 Cash 18.00 5 Accounts Receivable 90.00 6 Supplies 14.00 7...
Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security...
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, 2016: Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2016 1 Unadjusted Unadjusted Adjusted Adjusted 2 Trial Balance Trial Balance Adjustments Adjustments Trial Balance Trial Balance 3 Debit Credit Debit Credit Debit Credit 4 Cash 12.00 5 Accounts Receivable 90.00 6 Supplies 8.00 7...
Discussion Question: Super Security Co. offers a range of security services for athletes and entertainers. Each...
Discussion Question: Super Security Co. offers a range of security services for athletes and entertainers. Each type of service is considered within a separate department. Marc Pincus, the overall manager, is compensated partly on the basis of departmental performance by staying within the quarterly cost budget. He often revises operations to make sure departments stay within the budget. Says Pincus, “I will not go over budget even if it means slightly compromising the level and quality of service. These are...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT