Welcome to the MIE Solutions Job Shop Estimating  blog.   Fabrication software as in sheet metal software and manufacturing software deals with shop rates extensively for costing.

There are basically 3 ways to calculate overhead absorption rates which is used to provide your shop sell rate during quoting and estimating.

  1. Company Overhead Absorption Rate
  2. Percentage Overhead Absorption Rate
  3. Work Center Overhead Absorption Rate

Each of these three ways of calculating your overhead absorption has both positive’s and negatives.

Percentage Overhead Absorption Rate

What does an overhead percentage mean?   An example would be a 150% overhead percentage which  means that for every $1.00 of direct labor billed to the customer, the business must collect an additional $1.50 ($1.00 x 150%) for that custom just to cover costs.   There are potentially large variations between total direct labor wage and direct labor cost.    The question is how do we figure the overhead absorption rate.

Definitions

Business Expenses

 

All expenses found on the company’s income statement (also known as the
profit and loss statement).

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.

How To Calculate Overhead Percentage

Step 1 Determine the “average” hourly wage paid to direct labor employees.

Step 2 Estimate direct labor workdays available in the calendar year.

Step 3 Estimate billable direct labor hours for work year.

Step 4 Estimate billable direct labor dollars for work year.

Step 5 Estimate non-billable direct labor dollars for work year.

Step 6 Estimate all overhead expenses for work year to include non-billable direct labor.

Step 7 Calculate the annual overhead percentage.

 

 

Example

Would your shop rate be Avg Direct Labor Rate +Overhead Rate (Average Direct Labor Rate x Overhead %)

is  Direct Labor Costs

Is this your sell rate?   No

Referencing http://www.missouribusiness.net/docs/calculate_overhead.pdf

 

A machine shop rate for a job shop manufacturer is not that difficult to compute once you have your income sheet calculations available.   Its important to calculate your shop rate for estimating accurately because if you are off by much you will be losing money continuously.   A sheet metal software package needs to be able to handle calculating overhead rates based on percentage if its applicable to the specific industry.

http://www.mie-solutions.com

The mission of MIE Solutions is to apply advanced technology to improve manufacturing productivity and quality in the field of fabrication. At MIE Solutions, we do not compromise product quality or service. We strive to satisfy our customer’s every reasonable requirement with speed, courtesy and honesty. Our pricing reflects the cost of providing high quality products and excellent service but remains fair. Our goal is to be known throughout the world for the development and production of innovative products. We endeavor to be regarded as the leading supplier of high technology in the sheet metal fabrication. We want our customers to be proud to own MIE products.

 
MIE Products & Solutions
Material Requirements Planning (MRP)
Supplier Relationship Management (SRM)
Procurement Reporting and Supplier Performance Software
Purchasing Software
Quality Management Software
Document Management Software
Bill of Materials/Product Structure Software
Product Data Management Software
Product Configuration Software
Project Costing Software
Project Estimating Software
Enterprise Asset Management(EAM)/CMMS Software
Asset Management Software
Materials Management Software
Procurement Software
Work Order Management Software
Supply Chain Management (SCM) Software
Advanced Production Scheduling Software(APS)
Real-time Advanced Manufacturing Planning Software
Capacity Requirements Planning (CRP) Software
Demand Planning Software
Enterprisewide Planning Software
Inventory Management Software
Master Production Scheduling Software
Material Requirements Planning (MRP) Software
Warranty & Returns Management Software
Work Management Software
Financial Modules for ERP Software
General Ledger Software
Accounts Payable Software
Accounts Receivable Software
Cash Management Software
Cost Accounting & Management
Financial Reporting Software
Sales analysis Software
Sales Opportunity Analysis Software
Replenishment Planning & Scheduling Software
Material Requirements Planning (MRP) Software
Service & Parts Planning Software
Supply Chain Planning Software
Supply Chain Reporting Software
Manufacturing Flow Management Software
Kitting & Kit Processing Software
Time & Attendance and Labor Reporting Software
Lean Manufacturing Software
Kanban Planning & Execution Software
Material & Kanban Replenishment Software
Lot & Serial Reporting Software
Materials Management Software
Plant Floor Data Collection Software
Production Order Management Software
WIP Management Software
Work Orders and Process Routers Software
Work/Production Orders Software
Production Reporting Software
Quality Reporting Software
Production Scheduling Software
Floor Scheduling Software
Supply Chain Execution Software(SCE)
Supply Chain Manangement Sofware(SCM)
Warehouse Inventory Management Software
Data Collection Inventory Tracking Software
Capacity Requirements Planning Software(CRP)
Demand Planning Software
Enterprisewide Planning Software
Inventory Management Software
Inventory Optimization Software
Master Production Scheduling Software
Human Resources Software
Supply Chain Management Software (SCMS)
Advanced Production Scheduling Software
Finite Production Scheduling Software
Production Schedule Reporting Software
Manufacturing Scheduling System Software
Fixed Assets Software
General Ledger Software
MIE Trak PRO ERP Software System
MIE Accounting Software
MIE Kiosk Data Collection and Scheduling Software
MIE QuoteIT PRO Estimating Software
MIE CRM Software
MIE Fixed Asset Sofware
MIE Docs DMS Software System
MIE Purchasing Software
MIE Inventory Software
MIE IN/OUT Board Software
MIE Calendar Software
MIE Maintenance CMMS Software
MIE Journal Software
MIE Exchange B2B Portal
MIE Task Project Management Software
MIE Chat Sofware
MIE Quote Foxpro Estimating Software
MIE Trak Foxpro Manufacturing Software
MIE Dashboard Software
MIE QuoteIT CadSolid Software
Fabricators Software
Contract Manufacturing Software
Steel Fabrication Software
Industrial Manufacturing Software
Aerospace Industry Software
Automotive Industry Software
Machine Shop Industry Software
Fabrication Shops Software
Mold and Die Software
Repair Shop Software
Captive Shop Software
Screw Machine Software
Plastic Shop Software