Welcome to the MIE Solutions Job Shop Estimating  blog. MIE Solutions ERP system provides a comprehensive job shop software to deal with the many problems issues a job shop encounters.  Estimating has become a critical factor in many job shops in order to determine the best price for custom and made to order manufactured parts.

 

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. Work Center Overhead Absorption Rate
  3. Percentage Overhead Absorption Rate

 

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

Company Overhead Absorption Rate

 

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.

 

Budgeted Costs

 

Below you will find an example of a ficticious company and its associated budgeted costs.

Direct Materials……………………………..……..$1,500,000

Direct Labor………………………………………….$400,000

Indirect Costs

Rent (Factory uses 80% of floorspace)….....…….$620,000

Utilities………………………………………………….$75,000

Salary For Production Supers………………......….$300,000

Indirect Materials…………………………......………..$45,000

Total Indirect Costs……………………............…..$1,040,000

Sales Commissions…………………..…………….$200,000

Advertising……………………………….....…………..$20,000

 

Machine Hours

 

Assuming an 8 hour day, 5 days a week with working 52 weeks a year you would get

Hours per Day……………………………........…………..8

Hours per Week………………………….………....……40

Hours per Year………………………...…..………….2080

Hours Per Year for 10 Machines………….   ……20,800

 

There are a lot of assumptions that are being made here which will be discussed in much more detail in future blogs but this is the simple case.

What is your budgeted overhead rate?  $1,040,000/20800 = $50

Is this what you want to use for your quoting hourly shop rate?  The answer is No

 

 


 
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