Question

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
Unadjusted Trial Balance Adjustments Adjusted Trial Balance
Account Title Debit Credit Debit Credit Debit Credit
Cash 12
Accounts Receivable 90
Supplies 8
Prepaid Insurance 12
Land 190
Equipment 50
Accum. Depr.—Equipment 4
Accounts Payable 36
Wages Payable 0
Brenda Schultz, Capital 260
Brenda Schultz, Drawing 8
Fees Earned 200
Wages Expense 110
Rent Expense 12
Insurance Expense 0
Utilities Expense 6
Supplies Expense 0
Depreciation Expense 0
Miscellaneous Expense 2
500 500
The data for year-end adjustments are as follows:

• Fees earned, but not yet billed, $13.
• Supplies on hand, $4.
• Insurance premiums expired, $10.
• Depreciation expense, $3.
• Wages accrued, but not paid, $1.
Enter the adjustment data, and place the balances in the Adjusted Trial Balance columns. Leave cells blank that do not require an entry.

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

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

Prepaid Insurance

12.00

8

Land

190.00

9

Equipment

50.00

10

Accumulated Depreciation-Equipment

4.00

11

Accounts Payable

36.00

12

Wages Payable

0.00

13

Brenda Schultz, Capital

260.00

14

Brenda Schultz, Drawing

8.00

15

Fees Earned

200.00

16

Wages Expense

110.00

17

Rent Expense

12.00

18

Insurance Expense

0.00

19

Utilities Expense

6.00

20

Supplies Expense

0.00

21

Depreciation Expense

0.00

22

Miscellaneous Expense

2.00

23

Totals

$500.00

$500.00

Answer 1

Answer:

attached file with the solution to give a better format

Explanation:

The fees earned will increase fees and account receivables is we don't colelct the amount

the supplied on hand will be compared against the book value

8 - 4 = 4 supplies expense

the premium expired will decrease the prepaid insurance

wages accrued will generate both, a wages payable and wages expense