In Part 1 of this series, I gave an overview of the different categories of overhead rates.  In Part 2, I’ll show you not only how to calculate overhead rates, but some of the strange lingo that’s part of the process.

The two factors that determine overhead rates are the base, sometimes called the burdenable base or prime dollars, and the expense, or overhead.  The overhead rate is merely the ratio between your expenses and your base.

The Base

The base, or prime dollars, is comprised of several categories, or “pools“:

• Direct Labor - employees’ wages/salaries that work directly on specific contracts.  This can be further broken down into separate pools for Engineering, Manufacturing, Field Service, etc.
• Direct Material - raw material or parts purchased for specific contracts
• Subcontract Material - larger assemblies that exceed a certain dollar threshold
• Travel - travel and lodging directly related to specific contracts
• Other Direct Cost - items that don’t fit into any of the other categories

Overhead Expense

Sometimes referred to as “burdens“, overhead includes expenses not directly related to specific contracts, such as employee medical benefits, rent, electricity, etc.  Expenses are categorized by pool.  For instance, the maintenance expense for a drill press would be allocated to the Manufacturing pool, while the calibration expense for an oscilloscope would be classified as an Engineering expense.

The Calculation

The purpose of calculating the overhead rate is to see what the ratio is between your direct costs and your expenses.  This makes it easier to spot trends, as both sides of the ratio vary year to year.

Here’s an example.  Company A projects direct Engineering labor of $10 million, and Engineering-related expenses of $15 million for 2009.  This works out to an Engineering overhead rate of 150%:

15,000,000 / 10,000,000 = 1.5 x 100 = 150%

Company B, on the other hand, has direct Engineering labor of $8 million, and Engineering overhead expense of $11 million:

11,000,000 / 8,000,000 = 1.375 x 100 = 137.5%

Company B has done a better job of controlling its overhead expense, and is better positioned to win future contracts from the government.  Of course, this is a simplistic view, and the other overhead pools (material, travel, etc.) would have to be taken into account.

How can we apply this to personal finance?  You could use your wages as the base, and calculate a year-to-year overhead rate using your expenses.  You’d be able to spot trends over time.  Expenses can be measured as a percentage of your income.

• Overhead Rates, Part 1 If you've ever worked for a defense contractor, you're probably well acquainted with overhead rates.  For those of you who haven't had the pleasure of dealing with Uncle Sam on a daily basis, let me give you a brief rundown.  They come in many flavors, such as: Actual Rates These are, as......
• Excel How-to: The GETPIVOTDATA Function In a previous post, we created a simple pivot table from a list of Excel data.  Today, we'll link the pivot table data to a spreadsheet using the GETPIVOTDATA function. Note: You can follow along with the how-to by clicking on the following Excel file link: The GETPIVOTDATA Function.xls (In......
• Pay Cash or Put it on the Plastic? Photo by Andres Rueda Whew!  Now that Christmas is over, so is Christmas spending.  Unlike most personal finance bloggers, we don't stick to a strict budget.  We try to estimate our gift expenses based on the prior year, and factor it up by the amount of people we have......

• PPC Basics: Affordable PPC search engine advertising PPC search engine advertising is by far the most affordable form of advertising available.  PPC search engine advertising is about producing leads. Creating leads will help potential buyers find the specific website that will provide them with the product or service they need. However, PPC search engine advertising does not......
• Sinking Fund Eases Strain Of Annual Expenses If you listen to personal financial advice very long you are bound to hear the term "sinking fund" tossed around.  Unfortunately, it is usually mentioned in passing as if everyone knows that a sinking fund is, and how to use one to improve the management of your personal finances. A......
• Hardware Maintenance - Independent Multi-Platform Provider vs Original Equipment Manufacturer-Vendor The days of all your business applications being based on a single mid-range or mainframe system are past. Today, few organisations are single-vendor shops, having acquired systems to meet specific purposes from several sources, as well as running key applications and file-serving on Intel-based servers.Given that you now operate a......