How to Calculate Overhead-Cost-Per-Hour By Department
Originally published: 06.01.11 by Ruth King
This departmentalization method is the fairest way I know to allocate overhead to different departments. I have consistently used this methodology for the past 18 years with hundreds of contractors. It works.
There are two causes of overhead: people and space. Let's take a deeper look at both.
Five expenses alone comprise space-related overhead cost: rent, utilities, building maintenance, building taxes, and building insurance.
Determine the total amount of productive space used by each department. Productive space is the space occupied by people or other assets related to a revenue-producing department. Common areas or areas used by overhead personnel are not counted in this equation. For example, your bookkeeping space doesn't count; your reception space doesn't count.
The space that is used by the finance department or other people who are not directly bringing in revenues does not count in this equation. The only spaces that count are those related to service, new construction, replacement, or whatever departments you have.
For example, if you have a 5,000-square-foot-building, and of that 5,000 square feet:
- 1,000 is being used by service and replacement employees/other assets; and,
- 3,000 is being used by new-construction employees/assets;
- There is a total of 4,000 productive square feet.
- 25 percent of
- 75 percent of the space related overhead costs are assigned to new construction (3,000/4,000).
If total company rent is $1,000 per month, then the service and replacement departments' share of the rent is $250; and the new construction department's is $750 each month.
Every overhead item not listed under space is related to people. For example, more employees mean more office supplies. More people mean more telephone expenses.
If you know the exact percentage of time that somebody spends in a particular department, then take that percentage rather than the overall estimate in this calculation. For example, if you know that your service bookkeeper spends 100 percent of her time in the service department, then obviously the service department will get 100 percent of her salary. If your bookkeeper splits her time among service, new construction, and electrical, you may need to determine how much time she is spending in each one of these departments on their tasks, and then allocate her salary appropriately.
If supplies are bought for only one department, then that department gets 100 percent of that expense. For example: service tickets. The new construction department is not going to use service tickets, so the service department will pay for the service tickets. Another example is phone-directory advertising. It's very unlikely that the new construction department would use this. It is a service-and-replacement-expense. Split the cost 50/50 between those two departments.
For other overhead items that are split, determine the total amount of productive payroll, i.e., revenue-producing, field-personnel payroll. Then, if the total productive payroll is $100,000, and the service productive payroll is $50,000, new construction's productive payroll is $20,000 and replacement is $30,000, the service department's share is 50 percent (50,000/100,000), new construction's share is 20 percent (20,000/100,000), and replacement's share is 30 percent (30,000/100,000).
Once you know the total amount of overhead for each department, then it is time to calculate the cost-per-hour.
Remember to use only productive payroll — or the number of revenue-generating hours — for each department. These are the hours that you can bill for. Your company has to cover all of its costs through billable hours. Training hours don't count. Travel hours don't count, unless you bill them to the customer. Running to the supply house hours don't count, unless you can bill them to the customer.
The overhead-cost-per-hour is the total overhead cost divided by the total number of productive hours in that department.
Getting Started on Overhead-Cost-Per-Hour Calculations
First, take your company's year-end payroll, which lists the total payroll and payroll hours for each employee. Separate the employees into the different departments. Total the payroll for each department. Remember that you are only interested in productive payroll. If you have sales people, include their salaries in the department they sell for.
Also, if some of the field employees work in two departments, estimate the amount of time that a tech spends in each of the departments and allocate his payroll accordingly. For example, assume a service technician worked 2,000 hours and earned $50,000 last year. He spent 20 percent of his time in replacement, and 80 percent of his time in service.
Then 1,600 hours and $40,000 would go in service department labor, and 400 hours and $10,000 would go into replacement labor.
Once all of the departments' productive payroll and payroll hours are calculated, then add all the departments together to determine the total productive payroll and payroll hours. Each department gets a percentage based on its payroll divided by the total payroll.
Estimate the space requirements for each department. Each department receives its percentage based on the total productive space.
Then, get your latest fiscal year end's financial statements showing the total overhead for the year. Using the spreadsheet titled "Overhead Cost per Hour" enter the totals of each overhead expense in the yellow areas. Remember to include the proper percentages for space and for labor overhead expenses.
Here's what to watch out for when you complete the spreadsheet:
- Put the amount of square footage that each department occupies in the yellow boxes.
- Put the numbers from your year-end W-2s in the yellow boxes. The top box is for dollar figures. Remember to use only productive payroll. The lower box is for the total hours for each department.
- se your last fiscal year-end profit-and-loss statement to enter the numbers in the yellow boxes under overhead expenses. In some cases, you might know exact numbers and do not need to rely on percentages. If you know exact numbers, put those numbers under each department.
For example, if you, as the owner, know that you spend 90 percent of your time in the replacement department, 10 percent of your time in service, and 0 percent of your time in maintenance agreements, then enter 90 percent of your salary in the replacement box under salaries — officers; 10 percent in the service box under salaries — officers; and 0 in the maintenance agreement box under salaries — officers.
Ruth King is president of HVAC Channel TV and holds a Class II (unrestricted) contractors license in Georgia. She has more than 25 years of experience in the HVACR industry, working with contractors, distributors and manufacturers to help grow their companies and make them profitable. Contact her at email@example.com or call 770-729-0258.
Articles by Ruth King
Increase Your Office Productivity
Are you staffing for the busy times or the slower times? If you hire office personnel to cover all of the busy times, they will not be productive in the slower times of the year.
Increase Warehouse and Inventory Profitability
Inventory is a bet. You’re betting your hard earned dollars that you will be able to sell parts and equipment that you buy and store in a warehouse or on trucks.
Six Easy Ways to Increase Marketing Profitability
If you want to waste marketing dollars, then just burn the leads that marketing generates. You invest thousands of marketing dollars to produce those leads. Keep them productive. Keep them profitable.
Three Ways to Increase Sales Profitability
Selling profitably, riding with your salespeople and tracking results will improve your company’s sales profitability.
Increase Installation Profitability
At the end of the day or the job, these are the wasted materials that get left on job sites or damaged, rolling around in trucks. Returning materials at the end of a job is one of the quickest ways to increase your bottom line.