Question

In: Accounting

ProWorks is a website design and consulting firm based in Michigan. The firm uses a job...

ProWorks is a website design and consulting firm based in Michigan. The firm uses a job cost system in which each client is a different job. Proworks traces direct labor, software licensing costs, and travel costs directly to each job (client). It divides overhead into two cost pools, "Indirect Labor" and "Office Overhead." It allocates Indirect Labor (support staff salaries) to jobs based on software licensing costs. It allocates Office Overhead (all other overheads) to jobs based on direct labor hours. At the beginning of 2016, managing partner Mark Milici prepared the following estimates:

Direct labor hours $14,000 hours

Direct labor costs $1,400,000

Software licensing costs $50,000

Travel costs $80,000

Support staff salaries $200,000

Computer leases $50,000

Office supplies $30,000

Office rent $60,000

In January, 2016, ProWorks served three clients. Records for the clients appear here:

.Dining Corp .Hut Shuttle .Lucidyne

Direct Labor Hours: 600 hours 50 hours 300 hours

Software licensing costs: $5,000 $500 $2,000

Travel costs: $9,000 $2,000 $0

1) Write a business memo about cost allocation issues. In your analysis, explain the reasons why ProWork managers should assign all costs to jobs. Managers also want to know the factors they should consider when setting prices. If managers want to earn profits equal to 20% of sales revenue, what price should the company charge each client?

Solutions

Expert Solution

If the managers want to earn a profit of 20% on sales , the price to be charged from each client ca be calculated as follows:

Dining corp Hut shuttle Lucidyne
Direct costs:
Software licensing cost $5,000 $500 $2,000
Travel costs $9,000 $2,000 $0
Direct labour $60,000 $5,000 $30,000
Total direct costs $74,000 $7,500 $32,000
Indirect costs:
Support staff salaries $20,000 $2,000 $8,000
Other overheads $6,000 $500 $3,000
Total indirect costs $26,000 $2,500 $11,000
Total costs $1,00,000 $10,000 $43,000
Price $1,25,000 $12,500 $53,750

Working notes:

Direct labour cost per hour = total direct labour cost / total number of hours

= 1400000 / 14000

= $100

Support staff salaries rate = total support staff salaries cost / software licencing cost

= 200000 / 50000

=$4

Other overheads rate = total other overheads cost / total direct labour hours

= 140000 / 14000

= $10

Memo

In order to charge the correct prices from the clients, it is important that accurate allocation of costs is done to the various clients/jobs. The direct costs can be directly be traced, however the complexity airses with the indirect costs like support staff salaries, office rent, office supplies and office lease. The basis of allocaiton of these costs is divided into two cost pools depending upon the usage of these indirect costs by the clients. Thus, the indirect costs are allocated basis the cost pools.This leads to an accurate allocation of the overheads which further leads to a more accurate pricing.

The issues with the allocation arises if the cost pools are not traced properly.


Related Solutions

ProWorks is a website design and consulting firm based in Michigan. The firm uses a job...
ProWorks is a website design and consulting firm based in Michigan. The firm uses a job cost system in which each client is a different job. Proworks traces direct labor, software licensing costs, and travel costs directly to each job (client). It divides overhead into two cost pools, "Indirect Labor" and "Office Overhead." It allocates Indirect Labor (support staff salaries) to jobs based on software licensing costs. It allocates Office Overhead (all other overheads) to jobs based on direct labor...
ProWorks is a website design and consulting firm based in Michigan. The firm uses a job...
ProWorks is a website design and consulting firm based in Michigan. The firm uses a job cost system in which each client is a different job. Proworks traces direct labor, software licensing costs, and travel costs directly to each job (client). It divides overhead into two cost pools, "Indirect Labor" and "Office Overhead." It allocates Indirect Labor (support staff salaries) to jobs based on software licensing costs. It allocates Office Overhead (all other overheads) to jobs based on direct labor...
ProWorks is a website design and consulting firm based in Corvallis. The firm uses a job...
ProWorks is a website design and consulting firm based in Corvallis. The firm uses a job cost system in which each client is a different job. Proworks traces direct labor, software licensing costs, and travel costs directly to each job (client). It divides overhead into two cost pools, "Indirect Labor" and "Office Overhead." It allocates Indirect Labor (support staff salaries) to jobs based on software licensing costs. It allocates Office Overhead (all other overheads) to jobs based on direct labor...
Vista Design is an interior design firm. The firm uses a job cost system in which...
Vista Design is an interior design firm. The firm uses a job cost system in which each client is a different​ "job."Vista Design traces direct​ labor, licensing​ costs, and travel costs directly to each job​ (client). It allocates indirect costs to jobs based on a predetermined indirect cost allocation rate computed as a percentage of direct labor costs At the beginning of the current​ year, managing partner Brenna Gladstone prepared the following​ budget: Direct labor hours (professional). . . ....
Job-Order Costing in a Consulting Firm JLR Enterprises provides consulting services throughout California and uses a...
Job-Order Costing in a Consulting Firm JLR Enterprises provides consulting services throughout California and uses a job-order costing system to accumulate the cost of client projects. Traceable costs are charged directly to individual clients; in contrast, other costs incurred by JLR, but not identifiable with specific clients, are charged to jobs by using a predetermined overhead application rate. Clients are billed for directly chargeable costs, overhead, and a markup. JLR’s director of cost management, Brent Dean, anticipates the following costs...
Job Costs Using Activity-Based Costing Heitger Company is a job-order costing firm that uses activity-based costing...
Job Costs Using Activity-Based Costing Heitger Company is a job-order costing firm that uses activity-based costing to apply overhead to jobs. Heitger identified three overhead activities and related drivers. Budgeted information for the year is as follows: Activity Cost Driver Amount of Driver Materials handling $101,200 Number of moves 4,000 Engineering 142,400 Number of change orders 8,000 Other overhead 358,800 Direct labor hours 52,000 Heitger worked on four jobs in July. Data are as follows: Job 13-43 Job 13-44 Job...
Job Costs Using Activity-Based Costing Heitger Company is a job-order costing firm that uses activity-based costing...
Job Costs Using Activity-Based Costing Heitger Company is a job-order costing firm that uses activity-based costing to apply overhead to jobs. Heitger identified three overhead activities and related drivers. Budgeted information for the year is as follows: Activity Cost Driver Amount of Driver Materials handling $54,250 Number of moves 2,500 Engineering 120,700 Number of change orders 8,500 Other overhead 148,500 Direct labor hours 45,000 Heitger worked on four jobs in July. Data are as follows: Job 13-43 Job 13-44 Job...
Job Costs Using Activity-Based Costing Heitger Company is a job-order costing firm that uses activity-based costing...
Job Costs Using Activity-Based Costing Heitger Company is a job-order costing firm that uses activity-based costing to apply overhead to jobs. Heitger identified three overhead activities and related drivers. Budgeted information for the year is as follows: Activity Cost Driver Amount of Driver Materials handling $108,000 Number of moves 4,500 Engineering 165,000 Number of change orders 10,000 Other overhead 263,200 Direct labor hours 47,000 Heitger worked on four jobs in July. Data are as follows: Job 13-43 Job 13-44 Job...
Heitger Company is a job-order costing firm that uses activity-based costing to apply overhead to jobs....
Heitger Company is a job-order costing firm that uses activity-based costing to apply overhead to jobs. Heitger identified three overhead activities and related drivers. Budgeted information for the year is as follows: Activity Cost Driver Amount of Driver Materials handling $81,900 Number of moves 3,500 Engineering 135,150 Number of change orders 8,500 Other overhead 240,000 Direct labor hours 48,000 Heitger worked on four jobs in July. Data are as follows: Job 13-43 Job 13-44 Job 13-45 Job 13-46 Beginning balance...
Heitger Company is a job-order costing firm that uses activity-based costing to apply overhead to jobs....
Heitger Company is a job-order costing firm that uses activity-based costing to apply overhead to jobs. Heitger identified three overhead activities and related drivers. Budgeted information for the year is as follows: Activity Cost    Driver Amount of Driver Materials handling $ 72,000      Number of moves 3,000   Engineering 165,000      Number of change orders 10,000   Other overhead 280,000      Direct labor hours 50,000   Heitger worked on four jobs in July. Data are as follows: Job 13-43 Job 13-44 Job 13-45 Job 13-46 Beginning...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT