Calculating overhead and price
- Published: Saturday, Jan. 12, 2019
Alan Hauff, former pricing expert and small business specialist for University Extension at the University of Missouri-St. Louis, has devised a seven-step process for calculating the all-important overhead percentage, shown in section 2 below. After the overhead percentage is determined, important pricing decisions can be made.
To calculate overhead percentage, several terms must be defined. These are found in section 1.
For instance, an overhead percentage of 220 percent means that for every $1.00 of direct labor billed to the customer, the business must collect an additional $2.20 ($1.00 x 220 percent) from that customer just to cover its cost of doing business. Thus, if a job required a direct labor wage of $8.50 per man-hour, overhead of $18.70 ($8.50 x 220 percent) must be added, with a direct labor cost of $27.20 per man-hour. It is at this point that many business owners are shocked to discover the large difference between the total direct labor wage and the direct labor cost.
Section 1: Pricing terms
- Business expenses All expenses found on the company’s income statement (also known as the profit and loss statement).
- Overhead expenses All costs found on the income statement except for direct labor, direct materials, and costs attributable to outside subcontractors that can be billed directly to a customer’s account.
Overhead expenses are absorbed by the business and factored into the selling price as a percentage of the direct labor cost. They include indirect costs such as accounting, advertising, depreciation, indirect labor, insurance, interest, legal fees, rent, repairs, supplies, taxes, telephone, travel and utilities.
- Direct labor Labor used to produce products and services purchased by customers. These man-hours are directly attributable to customer activity.
- Indirect labor Labor used to provide supporting services to the business such as accounting, clerical, custodial, customer services, management, purchasing, sales and warehousing. These man-hours support business functions that are not directly chargeable to the customer.
- Direct materials Materials used in the final product or service purchased by customers. These materials are charged directly to the customer’s account.
- Overhead percentage Ratio between direct labor and overhead expenses. This percentage is used to allocate overhead expenses proportionately to direct labor dollars billed to customers.
Section 2: Process for calculating overhead percentage
- Classify each employee’s contribution or portion thereof as either direct or indirect labor. Determine the hourly wage rate paid to each direct labor employee and include the business owner, if applicable. Total the hourly wage rates and divide by the number of people counted.
- Calculate the number of direct labor workdays in a calendar year by subtracting the average number of days that direct labor employees will not be present for work because of weekends, holidays, vacations and miscellaneous (injury, personal illness, etc.). Count only direct labor employees. Do not include any indirect labor employees in the estimate.
- Multiply available direct labor workdays by the scheduled eight-hour workday minus the average number of daily non-billable direct labor hours. Non-billable direct labor hours include lunches, breaks, company meetings, training, cleanup, etc., that a customer will not be charged for directly.
- Multiply billable direct labor hours by average direct labor wage.
- Subtract billable hours from the total man-hours available in a work year, which is 2088 hours. The remainder equals the non-billable direct labor hours. Multiply this number by the average direct labor rate to arrive at the non-billable direct labor dollars. Non-billable direct labor dollars are absorbed by the company and must be passed on to the customer through the overhead percentage.
- Refer to the actual or pro forma income statement and total all the business expenses shown for the year. Deduct the cost of billable direct labor, direct materials and costs attributable to outside subcontractors billed directly to a customer’s account. Do not deduct the cost of non-billable direct labor. Adjust the overhead expenses for yearly inflation and projected price changes by multiplying the total by the anticipated percentage increase.
- Divide the yearly overhead expenses (step 6) by the yearly billable direct labor dollars (step 4), and convert this ratio to a percentage.
Job shop owners are often shocked to learn the magnitude of their overhead, but including overhead in the prices firm charges for its products and services is essential for the firm’s survival and profitability. After the overhead percentage has been calculated, a business owner can examine the possibilities for making changes in the business that will yield desired results, such as lowering overhead in targeted areas, raising prices, decreasing production times, etc.
To calculate the price for a job shop service, the firm must set the desired percentage gross margin on selling price. (Gross margin on selling price is the preferred method for adding profit to a product or service because it matches the reporting done in income statements where sales revenue is recorded.) The price a shop should sell its services for is calculated by:
Avg. direct labor rate (in $/man-hour; from Step 1)+ Overhead rate (Avg. direct labor rate x overhead percent [Step 7]; in $/man-hour) direct labor cost (in $/man-hour)
For a desired gross margin on selling price of X percent , convert that percentage to a decimal and calculate the price:
Direct labor cost ÷ (100 – x) = Charging rate per man-hour
Smith’s Welding Shop has determined its average direct labor rate to be $15.00/man-hour. It has calculated that its overhead percentage is 200 percent. It now wants to make a 15 percent gross margin on selling price. The price Smith’s Welding Shop must charge for their service is found by:
$15.00/man-hour Avg. direct labor rate + $30.00/man-hour Avg. direct labor rate x overhead percentage $45.00/man-hour Direct labor cost
For a 15 percent gross margin on selling price,
$45.00 ÷ (.85) = $52.95/man-hour
Smith’s Welding Shop must ask $52.95 per man-hour for its services to make the desired profit margin.
A similar method to pricing services is used to establish product prices. Calculate the cost of producing one item or unit and use the gross margin on selling price method shown in the service example above to find selling price.
$45.00/man-hour ÷ 60 minutes = $0.75/minute $0.75/minute x 10 minutes/widget = $7.50 Direct labor cost per widget +$0.84 Direct material costs per widget $8.34 Cost to produce one widget
For a 15 percent gross margin on selling price,
$8.34 ÷ (.85) = $9.82 selling price for each widget