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.
Is Providing A Company Car A Good Idea? Comparing Company Owned Vehicles vs. Mileage Reimbursements (Plus 2 Real Company Fleet Models That Worked)
Photo above: RAM Pavement, a Charlotte-based paving company renews at least one truck in its fleet with a brand-new vehicle approximately every …
Expenses That Can Be Included In COGS (That Might Surprise You)
Some Cost of Goods Sold (“COGS”) expenditures are obvious (eg. raw materials or subcontractors working on a customer’s job), while others that …
How To Be Prepared For A Business Personal Property Tax Audit: Tips From Bookkeepers & CFOs
By: Jeff Heybruck As a fractional CFO and bookkeeping firm, we’ve gone through our fair share of business personal property audits with …