Pains and benefits Ing.Jaromír Skorkovský, CSc. Department of Business Economics ESF MU Czech Republic Reasons for purchasing (buying) •Pain •Pain and vision distinction (difference) •Searching for the pains depends on : –market segment –size of the company –ownership –position in SCM –position of the person – Reasons for purchasing (buying) •dormant (latent) pain : it exists, but it is not presumed • nothing_to_see_here Example : collecting money late, paying to early ->crippled cash-flow Reasons for purchasing (buying) •real pain –a real pain (lack, deficiency, shortage), which are wittingly admitted by the customer • Examples : high value of the stock(inventory), due date performance is low, laborious and not exact calculation of production cost… Zobrazit obrázek v plné velikosti wpe22011 Reasons for purchasing (buying) •vision –particular (tangible) idea of the pain killer • Example : use of a good algorithm for replenishment planning replenishment … We must produce 5 bicycles, so we need 5 seats (Gross Requirement). But we have in our stock 3 of them. And another department has to assembly another 2 bicycles and we do have issued Purchase order for 4 seats. Safety Stock supposed to be 2. So finally we need : 2 (Net |Requirement)= 5-3+2-4+2 Requisition worksheet (tool for automatic replenishment suggestion) •Impacts of using RW tool • –Lower inventory level –It balances supply and demand across locations –Lower inventory and handling cost –Higher liquidity –Sufficient service level is maintained-Service level represents the expected probability of not hitting a stock-out. This percentage is required to compute the Safety Stock. Intuitively, the service level represents a trade-off between the cost of inventory and the cost of stock-outs (which incur missed sales, lost opportunities and client frustration among others). – – – – – – Purchase process •Net Requirement=Gross Requirement –Stock level – Purchase Orders + Sales Orders +Safety Stock Sales Order Reason for purchase Item Cardí Time Minium=5 Inventory level for today at lower than Safety Stock Replenishment suggestions Purchase Order Requisition worksheet 10 ks Minimum=Safety Stock Stock Availability •Reasons for reordering (replenishment) –Sales Order (CR) –Production Order –Transfer Order –Both of above Sales Order Production Order Transfer Order Components Item Card Availability Gross Requirement (hrubý požadavek) Creation of the pain chain •General pain : difficult analysis reports from existing data •CEO view : owners push me hard every week to supply results !!!!! •Inventory manager : I cannot optimise manipulation movement !!!! Do it immediately !!!!!! •IT manager : to get right data in right time I must transfer and modified a lot heterogeneous data in takes time and I am overloaded !!! Creation of the vision Reason diagnosis Leverage extension Creation of the vision Opening What is the reason of redundant stock levels? Who else is influenced by redundant stock level? Do you have any idea how to solve it? Check The reason is, that manufacturing does no generate requirement to purchase raw materials Problems in financial management? What about you of requisition worksheet where all the replenishment is planned automatically? Confirmation Late requirement form production to purchase department So CFO is also not satisfied with redundant stock levels? So the final solution could be a use of netting based on safety levels and production requirements to replenish stock optimally Pains in the information processing •Manual /batch processing •BAR code reader •Heterogeneous databases (a lot of different application from different suppliers and different technologies) •Homogeneous databases, XML ports,… •Uncertain and late presented information •On-line data processing, automatic data integrity checking • • Pains in the information processing •Complicated way of system usage •Standard commands for every application –unique user environment • (see NAV shorthand (F3,F5,Ctrl-F5,…) •Too much IT managers (high salary costs) •Modern ERP requires less of standard IT guys and more IT guys understanding methods used to control enterprise processes • Pains in the financial management (accountancy) •Late access to information, difficulties in finding the reason why any entry (transaction) was created •Navigation functions, dimensions, Business Analytics, … •Comparing actual and expected data is a foolish dream only •Budget functionality, On-line data…. • Zobrazit obrázek v plné velikosti Pains in the financial management (accountancy) •Difficult analysis of the customer or vendor balances •Flow field (calculated fields) •OLAP (Business Intelligence tools) • • • Zobrazit obrázek v plné velikosti Pains in the CRM, workflow and financial management (accounting) •Out-of-date information for salesman •CRM directly connected of Sales, Purchase and Inventory •Processes such are Sales, Inventory, Manufacturing, Purchase and Accounting are not connected •All above mentioned processes are connected • •Rigidity of sales processes- not connected to business plans •Tracking of the business opportunities, tasks and activities and follow up procedures •Businnes plans a prognosis estimations are incorrect •Boston matrix, Magic quadrant • Zobrazit obrázek v plné velikosti Pains in the manufacturing processes • •Difficult planning/ changes in production •MPS (Master Production Schedule), MRP-II, JIT and direct link to sales and production orders for direct planning from sales orders (netting), manual MRP, automatic suggestion of replenishment and automatic issuing of purchase orders, DBR, CONWIP •difficulties in subcontracting management •Constrained capacities of resources in production •Graphical planning tools, TOC application •A lot of errors when entering data in shop-floor •Use of Touch Screens • • • Touch Screen application Graphical planning Simplified diagram of ERP usage ERP Transaction = Entries DB ERP Partners Reports Forms sample2002-Graphs Information Information (trends) Knowledge of methods for process management and used metrics Decision Enterprise keys Key knowledge keys Key decision Others •Inter-company posting (more than one company in one database) •Business Notification •Responsibility centres •OLAP + Business Analytics • • Thanks a lot for your attention Ing.Jaromir Skorkovský,CSc.; KPH ESF MU Brno Czech Republic