Question

In: Accounting

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

Prepaid Insurance

14.00

8

Land

198.00

9

Equipment

53.00

10

Accumulated Depreciation-Equipment

7.00

11

Accounts Payable

37.00

12

Wages Payable

0.00

13

Common Stock

50.00

14

Retained Earnings

231.00

15

Dividends

5.00

16

Fees Earned

203.00

17

Wages Expense

108.00

18

Rent Expense

20.00

19

Insurance Expense

0.00

20

Utilities Expense

6.00

21

Supplies Expense

0.00

22

Depreciation Expense

0.00

23

Miscellaneous Expense

2.00

24

Totals

$528.00

$528.00

The data for year-end adjustments are as follows:

Fees earned, but not yet billed, $13.
Supplies on hand, $7.
Insurance premiums expired, $7.
Depreciation expense, $4.
Wages accrued, but not paid, $2.

Enter the adjustment data, and place the balances in the Adjusted Trial Balance columns. Leave cells blank that do not require an entry.

Solutions

Expert Solution


Related Solutions

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...
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...
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: 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: 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 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...
Post-Closing Trial Balance An accountant prepared the following post-closing trial balance: Security Services Co. Post-Closing Trial...
Post-Closing Trial Balance An accountant prepared the following post-closing trial balance: Security Services Co. Post-Closing Trial Balance July 31, 2018 Debit Balances Credit Balances Cash 41,100 Accounts Receivable 317,400 Supplies 5,000 Equipment 162,750 Accumulated Depreciation - Equipment 73,300 Accounts Payable 82,500 Salaries Payable 5,500 Unearned Rent 12,000 Common Stock 65,000 Retained Earnings 287,950 879,250 173,250 Prepare a corrected post-closing trial balance. Assume that all accounts have normal balances and that the amounts shown are correct. If an amount box does...
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...
Chapter 22 Lead Question Discussion Post Super Security Co. offers a range of security services for...
Chapter 22 Lead Question Discussion Post 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 budget. Says Pincus, “I will not go over budget even it means slightly compromising the level and quality of service....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT