Requirement 1

Complete Myers Home Supply Companys worksheet. In the first worksheet tab, at the bottom of the Excel workbook, is the beginning of a worksheet. You are given the trial balance portion. You need to enter the adjustments below in the adjustment columns and then complete the remainder of the worksheet through the adjusting trial balance columns.

Adjustments:

1. After doing the year-end count of office supplies, Myers found that $380 of office supplies remained.

2. After doing the year-end count of inventory, Myers determined that there was $56,600 in ending inventory.

3. $1,500 of the prepaid insurance has expired at year end.

4. Depreciation of the office equipment for the year was $10,000.

5. Depreciation of the store equipment for the year was $15,000.

6. The $34,000 in unearned revenue was for orders that were paid for in advance. At year end, 1/2 of the prepaid orders were fulfilled.

7. Wages that have accrued for the year but have not been paid yet totaled $18,000. This should be split evenly between Sales Salaries and Office Salaries.