Most Manufacturers continue to use spreadsheets even after buying an ERP that was expected to do most of the activities for them. Here are 7 things that your ERP will not do for you due to limited capabilties leading you to either use a spreadsheet or a third party software:
- Capacity and Resource Optimization: ERP Production Planning modules are fundamentally designed to serve the finance function for costing & inventory management. These systems also have limited capabilitieis to incorporate factory constraints that operations teams account for on a daily basis for capacity and efficiency gains. Most ERP’s do not have flexible production scheduling modules to marry the tribal knowledge and constraints available with the operations teams to optimize production. Manufacturing ERP’s have very good capabilities to link a Sales Order or Forecast to Production Orders but have limited capabilty to accuratley estimate the start and end time in detail to give a plan for the production floor to follow accurately. Complex manufacturing facilities like food companies may have additional business logics around Koshers, Allergins etc to be accounted for optimal sequencing or an automotive plant which may have mold constraints to be adhered along with setup time or changeover reductions on machines for capacity optimization. Except for focused third party software’s, such complex business logics are not handled easily or out of the box by the ERP’s or even spreadsheets.
- Capable to Promise (CTP) / Available to Promise (ATP): ERP’s today do have CTP and ATP features with limitations on how manufacturing operations data at the backend is utilized for these estimations. For Example, a manufacturing ERP would use plant level or department level rough cut capacity numbers to come out with promise date but this works often when production lead times are shorter. If you could produce items in less than a day, sales teams could always create some inventory or buffer additional time before commiting to customers to ensure 100% On-time delivery. However, the momement you have multiple product variants and if you are a make-to-order (MTO), make-to-stock (MTS), engineer-to-order (ETO) or a hybrid environment, rough-cut is only going to give you dates which may not be always accurate leaning sales team then to turn on the spreadsheet magic using an average lead time based strategy for commiting dates to customers. This works sometimes but often leads to customer confidence being affected. Best in class manufacturers have also seen effects of such practices create unnecessary raw material or work in progress inventory and if the manufacturer can afford even finished good inventories increasing the costs to remain 100% On-time.
- What – If Analysis: Customer Priorities are often changing today due to the increase in product and production complexity. In such environment, sales teams are always expecting to help customers on their rush order requirements. This requires effective collaboration between priorities managed by sales teams and what is actually being done on the production floor. ERP’s provide an opportunity enter the customer priorities and giving visibility to operations on the changes the sales team is dealing with but have limited capability to do something about it and provide a quick response. What is needed is a quick what – if analysis by sales and operations team on whether the rush order can be met with the existing capacity or is it delaying other customer orders. This quick response to demand also enables the manufacturers to charge a higher price for the rush order service provided or deny the rush order if the impact on other customers is large.
- Multi-Site Capacity Planning: Many Companies have multiple plants which would have the capability to make similar items in different locations. while many Demand Planners would use the forecasting capabilities of the ERP, limitation occurs when you want to play with options before creating the final master production schedule (MPS). A Master production schedule is the key input for the MRP run in the ERP to generate the correct planned and production orders. Multiple sites may come with constraints related to material availability from specific locations, location selection constraints, distribution centre stock levels leading to multiple combinations possible. Not Chosing the right strategy can many times lead to inventory turns reducing and affecting work in capital and cash flow.
- Plan vs. Actuals: Almost all ERP softwares have some sort of production confirmation mechanism to upate and ensure inventory levels in the system are an accurate showcase of the reality. However, most ERP’s have limited functionality to to capture details of the actuals. Whether it is capturing how much percentage of work was completed in one shift or how many actual labor hours were spent on a particular customer order, such information is not easy to capture in the ERP and operations teams often end up maintining spreadsheets or building a homegrown shopfloor data collection system enabled with Barcodes.
- Simulation and Digital Twin: ERP is the system of record and hence the master data is always difficult to easily change even if it is to be done temporarily. Manufacturers working on continuous improvement projects always find it hard to use the ERP to simulate outcomes based on changes in master data. For Example, let us take a low cost automation project being done on an existing machine that will bring down the cycle time and make the machine faster. There is a need to understand the imapct on the entire production system of this change. ERP makes it very hard and time consuming to try such experiements even for the purpose of financial justification before a continuous improvement project is taken up leading operational excellence teams to use standalone tools for carrying out such activities. Simulating scenarios or creating a digital twin of operations also becomes difficult when master data is difficult to modify for the purpose of experimentation.
- Trace and Geneology: Traceability and Genealogy are two ways to overcome problems linked to the recording of material lots used during production operations. This aims at following all production steps and guaranteeing products quality, by having the possibility to manage any noncompliance. ERP’s create production orders at a high level but do not recommend creating one piece production order in the ERP because the software user interfaces (UI’s) are not generally designed to update each and every unit of the production order but are more designed to be batch based. Material lots are hence either created in barcode softwares plugged withs spreadsheets or homegrown shop floor data collection software’s widely known as Manufacturing Execution Systems (MES) today.
To learn more, attend our upcoming Lunch and Learn session Oct 11 in Detroit. More details on the link below: