Orange Garden is a garden care service. The company originally specialized in serving residential clients, but recently has started contracting for work with larger commercial clients. Wayne Dyer, the owner, is considering reducing residential services and increasing commercial lawn care.

The company has five field employees who worked a total of 12,000 hours last year - 4,100 on commercial jobs and 7,900 on residential jobs. Wages paid to employees were $11 per hour for all work done. Direct materials were minimal and were included in overhead. All overhead is allocated based on labor hours worked. Customer charges (billings) are based on labor hours worked. Because of greater competition for commercial accounts, Mr. Dyer can charge $23 per hour for residential work but only $18 per hour for commercial work.

(a)If overhead for the year was $62,000, create an income statement to calculate the profits of each of the two services, commercial and residential, using labor hours as the allocation base for overhead. The income statement should have three columns, one for commercial services, one for residential services, and one for the totals. Please show all calculations.

(b) A more detailed analysis of overhead revealed that it consists of three components: office supplies, garden supplies, and depreciation and maintenance of equipment. These costs can be traced to the following activities:

Activity Level

ActivityCost DriverCostCommercial Residential

Office SuppliesNumber of clients served$8,0002634

Equipment Deprec.

and maintenanceEquipment Hours18,0003,5002,500

Garden SuppliesArea Covered

(square yards)36,00064,00036,000

Total Overhead$62,000

Create income statement to recalculate the profits of each of the two services, commercial and residential, using activity-based costing to allocate overhead costs. The income statement should have three columns, one for commercial services, one for residential services, and one for the totals. Please show all calculations.

(c) As noted above, the owner is considering a strategy of reducing residential services and increasing commercial lawn care. Based on your ABC analysis in part B of this problem, what recommendations do you have as to this strategy?