Cost allocation theory and practice PART 2

Cost allocation theory and practice PART 2

In our last month’s article, we went through the basics of job costing, how it can give management a better perspective into the operations of the business and the difference between direct and indirect costs. In this installment, we are going to discuss some of the methodologies an accounting manager may consider implementing to allocate indirect costs:

Full Absorption
100% of the actual indirect costs are allocated each period. For example, the company purchased $2,000 in small tools that were charged to indirect Cost of Sales. A journal entry is made at the end of the period to allocate the expense based on a factor such as job revenue.

The journal Entry would be:

Debit Credit
Project A Indirect Cost $480
Project B Indirect Cost $1520
Tool Allocation (Overhead Exp) $2000

Normally we don’t recommend full allocation since it can “cheat” a job with too much cost in a month that happens to be slow. It also assumes that the indirect costs are pro-rata based on revenue which is usually not the case. For example, a job that is farther from the shop would consume more fuel as the crew drives to and from the jobsite than a job closer to the shop.

A better methodology might be a budget-based approached.

Budget/Job Estimate
With this method an accounting manager would analyze previous financial statements for cost trends. For example, in the previous year the financial statements showed:

Total Revenue $2,1000,000
Direct Labor Cost $400,000
General Liability Insurance $10,000
Worker’s Comp Insurance $80,000
Vacation/Sick Pay (Field Employees) $10,000
Health Insurance $20,000
Unemployment Insurance $8,500
Tool Expenses $2,000
Project Management Salaries and Benefits $95,000

We would then develop a percentage that would be used for our job estimate AND actual cost allocation each period, so that in theory our costs would be perfectly allocated. This also helps estimators determine the true costs of performing the work; resulting in a more accurate bid and hopefully, higher margins.

Cost Item Budgeted Cost Factor Of % to Use
General Liability Insurance $10,000 Tot Rev .48%
Worker’s Comp Insurance $80,000 Direct Lab 20.00%
Health Insurance $20,000 Direct Lab 5.00%
Unemployment Insurance $8,500 Direct Lab 2.13%
Tool Expenses $2,000 Direct Lab .50%
Project Management Salaries and Benefits $95,000 Tot Rev 4.52%

With this method we will have some months where the allocation is higher than actual expenses and some months that are lower. For example, unemployment expense generally occurs at the beginning of the year. Jobs will be under allocated in the early months and over allocated in later months, but it will even out by year-end.

Projected Cost
Taking this concept a step further, the accounting manager may decide that it’s appropriate to adjust the allocation factors mid-year to account for unforeseen changes. For example, health insurance costs increase by $10,000 so the allocation factor is adjusted from 5% to 7.5%.

Note that it’s normal and acceptable to have an over/under allocation when costs are not fully absorbed. A common reason for variances is timing rather than cost overruns, so an accounting manager should be careful when adjusting allocation factors.

A final word of caution. Other factors should be considered when choosing allocation calculations. Take a look at the following example:

Project A Project B
Contract Amount $2,000,000 $2,000,000
Material Cost $1,850,000 $50,000
Labor/Eqpt Cost $50,000 $1,750,000
Gross Margin $100,000 $200,000
Job Duration 1 Month 1 Year

Suppose this company typically performed work similar to Project B and had a 5% overhead allocation rate based upon total cost. Would it be fair or proper to use that allocation rate if they had the opportunity to bid Project A? Is the risk similar? What are the overhead costs allocated and do the jobs justify a similar allocation? For this reason we recommend occasionally revisiting the allocation methodology to ensure a fair and accurate apportionment.

These are some of the questions that must be considered when developing an allocation methodology. Your Lucrum representative will be able to help you determine which questions and methods make the most sense for your business.

Questions? Contact Us Below.
Recent Articles
QuickBooks Online Disaster Stories

QuickBooks Online Migrations Gone Wrong: 3 Cautionary Tales

by: Lucrum Staff With the approaching end of QuickBooks Desktop, more and more organizations are considering Intuit’s cloud-based QuickBooks Online. Our team …

QuickBooks Enterprise vs Online

I’m On QuickBooks Desktop Pro or Premier…Should I Migrate to QuickBooks Online or Upgrade to QuickBooks Enterprise?

by Debbi Silva If you’re on QuickBooks Desktop Pro or Premier, you’ve likely already heard about Intuit’s plan to phase out the …

Understanding Cash Flow Projections in QuickBooks

Cash Flow Forecasting 101 (and Tips for Organizations Using QuickBooks)

By: Jeff Heybruck Forecasting cash flow is one of the most difficult but impactful planning exercises a business owner can undertake. There …