ERP Project Activities Skorkovský, ESF MU, Department of Business Economics , version 20140917 Countries from where you probably came nFrance nGreece nUruguay nGermany nUkraine nKazakhstan n n n Teacher nDepartment of corporate economy (V. Floor) nExternal free lance consultant on contract – www.navertica.com nTraining manager – Navertica South Africa n1730@mail.muni.cz; miki@econ.muni.cz; jaromir.skorkovsky@navertica.com Your main task (not organised set of processes) Input check Put-away Cross-docking Transfer to Production Consumption registration Production Output registration Inventory value calculation Output check Delivery Load-despatch Production Planning Sales Order Component replenishment Purchase Order Invoicing Payment Finished goods to Inventory Picking from Inventory Reporting Statistics Your main task (organised set of processes) Input check Put-away Cross-docking Transfer to Production Consumption registration Production Output registration Inventory value calculation Output check Shipment Load-despatch Production Planning Sales Order Component replenishment Purchase Order Invoicing Payment from Customer Finished goods to Inventory Picking from Inventory Reporting Statistics Inventory value calculation Inventory value calculation Payment to Vendor Your main task (possible problems, bottlenecks,..) Input check Put-away Cross-docking Transfer to Production Consumption registration Production Output registration Inventory value calculation Output check Shipment Load-despatch Production Planning Sales Order Component replenishment Purchase Order Invoicing Payment from Customer Finished goods to Inventory Picking from Inventory Reporting Statistics Inventory value calculation Inventory value calculation Payment to Vendor Your main task (Search problems - HOW ??? Measure impacts –HOW ??? and Destroy – HOW ???) Some events and some undesirable effects nThe car is in the swimming pool nThe fuel is not getting to the engine nHandbrake is faulty nThere is water in the fuel line nCar´s engine did not start nEngine need fuel in order to run nThe car handbrake stops the car from rolling into the swimming pool n Your main task – model problem n n Car´s engine did not start The car handbrake stops the car from rolling into the swimming pool Engine need fuel in order to run The car is in the swimming pool Handbrake is faulty There is water in the fuel line The fuel is not getting to engine Methods (not sorted so far !!!!!!!!! ) nTheory of Constraints – how to control efficiently nCritical Chain – project management issue nIshikawa Fishbone Diagram – quality management nPareto Analysis - – quality management nOLAP (On-Line Analytic Processing)- data management nKepner –Tregoe method –decision making nMaxMax and MaxMin (Hurwitz) - decision making nSWOT – marketing, analysis nERP Statistics and reporting – mail tool nBalanced Scorecard – company strategy nLittle´s law – production planning nAnd many, many more….. n n n n 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 Purchase Sales Processes ERP Quotes->Net change calculation-> ->Order->Vendor batch tracking -> ->Input Quality check->Receive, Put-away-> ->Invoicing ->Payment Orders->Sub-Load and Load-> ->Batch tracking ->Output Quality check->Picking ->Shipment -> Invoicing -> Applying payments Main problem (one of many) momentus 33e68905-3e3e-4556-bc5b-c5e41f6527fa_Pakistan_Musharraf We have a huge data quantity 33e68905-3e3e-4556-bc5b-c5e41f6527fa_Pakistan_Musharraf ..and at the same time a minimum information which could be used for making decision Main problem II (need of reliable data) Wee need finite capacity scheduling (APS) Op1 Op2 Op3 Zobrazit obrázek v plné velikosti press Zobrazit obrázek v plné velikosti T1 T2 T1+T2=X Opt=Min(X) Op1 Op2 Op3 T1 = 0 T2 = 0 Why we cannot manage it ? Unclear priorities, bad = SOP ,… (SOP = Standard Operation Procedures) SOUTH AFRICAN project Level production Level production strategy Period Sales Forecast (kg) Production plan (kg) Inventory (kg) Spring 80 000,00 100 000,00 20 000,00 Summer 50 000,00 100 000,00 70 000,00 Fall 120 000,00 100 000,00 50 000,00 Winter 150 000,00 100 000,00 0,00 400 000,00 140 000,00 Hiring cost/worker 100,00 Firing cost/worker 500,00 Production cost/kg 2,00 Inventory carrying cost /kg 0,50 Production cost/kg/worker/quarter Production capapcity of one worker 1000,00 Beginning work force (workers) 100,00 Russell & Taylor Operations Management Sixth Edition , p.586-595 Chase demand Chase demand strategy Period Sales Forecast (kg) Workers needed Workers hired Workers fired Spring 80 000,00 80,00 0,00 20 Summer 50 000,00 50,00 0,00 30 Fall 120 000,00 120,00 70,00 0 Winter 150 000,00 150,00 30,00 100,00 50,00 Chase demand without optimization (Chase demand strategy) Chase demand Cost 835000 Workers start 100 Products/worker/Quarter 1 000 Production cost 2,00 Firing cost 500 Inventory start 0 Inventory cost 0,50 Hiring cost 100 Demand/1000 QUARTER Demand Production Need for workers Hired Fired Spring 80000,00 80000,00 80 0 20 Summer 50000,00 50000,00 50 0 30 Autumn 120000,00 120000,00 120 70 0 Winter 150000,00 150000,00 150 30 0 Total 400000,00 400000,00 100,00 50,00 Chase demand with optimization (step one) Page 594 Ruseel and Taylor Chase demand Cost 0 Workers start 100 Product/worker/Q 1 000 Production cost 2,00 Firing cost 500 Inventory start 0 Inventory cost 0,50 Hiring cost 100 Q Demand (P) Production (V) Inventory(I) Workerd needed (PD) Hired (H) Fired (F) Demand constraints (OP) Production constraints (OV) Workforce constrtaints (OD) 1 80000,00 0,00 0,00 0 0 0 0 0 100 2 50000,00 0,00 0,00 0 0 0 0 0 0 3 120000,00 0,00 0,00 0 0 0 0 0 0 4 150000,00 0,00 0,00 0 0 0 0 0 0 Celkem 400000,00 0,00 0,00 0,00 0,00 Solver will put solution here These cells contain constraint formulas : Example 14.3. Chase demand with optimization (step two) – constraints formulas Demand Demand constraints V1-I1 80000 I1+V2-I2 50000 I2+V3-I3 120000 I3+V4-I4 150000 Workers needed =PDi Production constraints 1000*PD1 1000* PD1 1000*PD2 1000* PD2 1000*PD3 1000* PD3 1000*PD4 1000* PD4 H=hired, F= fired Workforce constraints 100+H1-F1=PD1 PD1+H2-F2=PD2 PD2+H3-F3=PD3 PD3+H4-F4=PD4 Chase demand with optimization (step three) – setup of the objective function Minimize : 100*(H1+H2+H3+H4) + 500 *(F1+F2+F3+F4) + 0,50* (I1+I2+I3+I4) + 2*(V1+V2+V3+V4) This formula is necessary to put to excel (cell cost) Chase demand with optimization (step four) – setup of the solver Chase demand with optimization (step five) – solution created by Solver Page 594 Ruseel and Taylor Chase demand Cost 832000 Workers start 100 Product/worker/Q 1 000 Production cost 2,00 Firing cost 500 Inventory start 0 Inventory cost 0,50 Hiring cost 100 Q Demand (P) Production (V) Inventory(I) Workerd needed (PD) Hired (H) Fired (F) Demand constraints (OP) Production constraints (OV) Workforce constrtaints (OD) 1 80000,00 80000,00 0,00 80 0 20 80000 80000 80 2 50000,00 80000,00 30000,00 80 0 0 50000 80000 80 3 120000,00 90000,00 0,00 90 10 0 120000 90000 90 4 150000,00 150000,00 0,00 150 60 0 150000 150000 150 Celkem 400000,00 400000,00 30000,00 70,00 20,00 Solver will put solution here These cells contain constraint formulas : Example 14.3. A simple business case….(example) nPrinting Company in Upper Lower Corner village somewhere in backwoods has a small problem : nThey use for managing printing procedures : na very basic economic system Sunshine written by Six grade student (a son of the owner) – written in Pascal nanother different systems for quotes calculation, logistics, production planning and control written in : n v obsolete FOX PRO n n n by 3 different programmers from 3 different companies n MS Office n Visual%2520FOXPRO%2520c1 Solution fully integrated to standard ERP package ERP MS Dynamics NAV Aplikace PrintVis Accounting Controlling Logistic Purchase Sales One database Actual situation (example) Accounting foxbase_mac_21 Business leftmenu progresssoftware Production negro-caricature china_worker2 enlarge_nofagr 60070-Stanley,%2520wheelbarrow iowaCityArticle1 Supplier John Brown Software Supplier Chinese SW Kings ESKIMO Virtual Manufacturing causes what ???? Effects ndifficult upgrades of applications ndifficult communication between different applications nreduplicated data (redundant data) nnon actual data->bad decisions netc. n n A simple business case (printing industry)….example - benefits n Competitive market could requires for instance : nfast reaction to quotes nvariable quotes and their immediate costing (calculation) –> price variability nshortening of delivery times nshortening lead times and cycle times -> fast reaction nreduction of inventory values (paper, colors)->higher liquidity nquality improvement ->8D reports should be used nprocesses driven by flexible workflow -> flexible op management nexact evaluation of finished jobs (production orders) in order to know real costs -> better cost control nfeed backs to external and internal signals such as : nreasons of quotes dismissals (why ???????) nreason of unexpected costs (why ???????) n PrintVis Workflow (in order to find easily e.g. Flexo order) Case card Quote Estimator Case card Requesting Johny Request Case card Salesman Mbeki Order Case card Planner Paul Plan Case card Production manager Jim Production A simple business case…. nCompetitive markets also requires : nModern and efficient SW tools to control these processes : nprepress: desktop publishing, computer to plate, … npurchase of material (paper, colors,..) nimposition (how to put locate texts on the paper ) nprinting using different technologies (sheets, rotary press,..) nproduction planning and shop floor control nfinishing operations such as ncutting ngathering nstitching n flexible invoicing n on-line accounting and so on and so on special printing operations Printing machine pantone_colours A simple business case…. n Bottlenecks (TOC) – Threats (SWOT) : nobsolete information system, which requires all time some changes, patches,… nall parts of information system form an heterogeneous is IT tools heterogeneous hydra : finance management, costing, production, inventory, HR,… ,which never provides user with real picture of the business !!!!!! ninaccurate data from one application is inherited by another one, so the picture of the business always late nCosting depends on human failing factors none author of every single subsystem nthese authors never meet each other to coordinate their efforts… A simple business case…. n Bottlenecks (TOC) – Threats (SWOT) : ninternet auctions favour competitors which are cheaper and faster n nthe size of paper and colour purchase orders are based on inexact assessment of purchasers (if we have a lot of orders, types of papers, various machines and so on, the optimum assignment of the purchase batches sizes is beyond ability of n human being with paper and pencil) checkpoint%2520bottleneck Gaza gate A simple business case…. n Messiah arrives and says : “ I have for you this :“ nmodern and flexible and standard ERP system nbackground of IT company with tradition and experience nbackground of global IT vendor n On the other hand an arriving messiah did not offer: nthe knowledge of printing industry nprinting application fully integrated with standard ERP n Arriving applicant must : nunderstand processes in printing industry (or any other base on chosen branch) nbe able to write printing application using development tools (languages) of standard ERP system nimplement the solution nOR instead of these three blue marked points to find already existing vertical solution for printing industry, which is used all over the globe n ivanov-messiah-det A simple business case…. n Finding a vertical is right ! nLet say, that we have found a foreign company having already Print SOLUTION developed (NovaVision),which was implemented 200-times and in different languages Print ERP Accounting Logistics Purchase and Payables Sales and Receivables Standard production CRM One database only Other standard ERP modules : Service Management Human Resources Business Analytics.. A simple business case….project management – introduction nLive Meeting: napplication setup nbasic functions and a „sweet points“ nbusiness case workflow (all the stages) nCustomer was happy and awaited consequential actions nVendor signs a contract about localisation and selling in pre-determined geographical areas ceskoslovensko-4 A simple main form of printing application PRINT integrated to ERP Navision Another form of printing application PRINT integrated to ERP Navision (imposition and colours) A simple business case…. nSome reasons which persuaded ERP vendor to sign a contract with vendor of vertical solution PRINT: n nlocal market analysis (SWOT, GAP Analysis, BPM,BSC, Pareto, Ishikawa Fishbone diagram, TOC, CCPM....) nexpectation of repetitive sales – promising market segment ->CRM application (pains and benefits) nanalysis of the competitors-> CRM npossible co-operation with other PRINT n experts abroad (sales of services) ar115895040883871 Project entries.. nActivities nacquire necessary printing industry knowledge nintroduction training provided by supplier of PRINT application (vertical solution) nteam building nbudget (costs „business plan“- revenues) nlanguage localization ENG->CZE nmodification ERP and a Print for Czech conditions (market specifications and legislation) ncope with inner application n n Project entries.. nActivities ntranslation of marketing material (fact sheet) and its printing in compliance with predefined templates ncreation of PWP presentation for selling nprospect prediction – segments of market nnaming of benefits „selling against“ npresentation to chosen prospects and reaction to questions- use of feedbacks to improve knowledge of printing industry nPrint price list generation n Project entries.. nActivities n „Kick-Off“ meeting nwhen, who, what and why (Kick-Off) nPWP presentation ninvitation, graphic design nselling invitation and follow-up nKick-Off nmapping of interests, business strategy modification and resource planning 2005-mess-kick-off-1--10 Project entries…(will be part of Critical Chain theory, which will be show to students later) nGantt n gantt_chart_thumb Project entries… nActivities nContract signature with pilot customer nSystem implementation (only some important activities are mentioned here.. ) nfeasibility study, analysis, target solution draft …… nintroduction training nsystem customization – will be shown in Dynamics NAV ntests of introduced modifications ndata transfers and setup of technological „master data“ ngeneration and selling licences and HW tools such as servers, … nchange management Project entries… nActivities n System implementation (only some important activities are mentioned here.. ) n ntraining with real data in the ERP system nstock taking and transfer of balances on accounts nsharp start nsupport and surveillance n n Kevin%2520100m%2520Start_jpg Necessary knowledge for project management Project successful ? (from Snapshot 0 ->Snapshot 1) MAX – Maximum which could be attainable 100%-Planned value 80%-Threshold value CRM 20% INVENTORY 10% PRODUCTION 20% SALES 20% PURCHASE 15% FINANCE 15% Snapshot 0 Snapshot 1 Another possible project... nHotel chain Rocco Forte * * * * * nWhere? (Great Britain 2x, Scotland 1x, Germany 2x, Prague 1x, Rome, Florence, CH, Russia ….) nSW choice (chosen company for delivery standard accounting package of ERP and cooperation with author of hotel vertical solution : Serenissima Informatica, Padova) nChoice of local partner (CZ MS Dynamics NAV partner X : requirements -> stability, knowledge of international business, languages, references- testimonial abroad, ..) nMilano (server farm for all hotels ) nAll hotels using same chart of account (USoA=Uniform System of Accounts) – simple consolidation (IFRS) nChoice of hotel SW and accounting SW n Another possible project... Another possible project Basic Concept (survey) protel hotelsoftware Dataport 847 Czech strings VAT report Translation of text strings used for communication Protel<->Dynamics NAV to Czech language (necessary knowledge of terminology and language) 847 Czech strings Balance sheet (generation using accounting schemes –will be introduced to students ) Accounting scheme Income Statement Uniform System of Accounts Accrued Revenues (revenues generated in the future periods) General Ledger Customer Income (still not created) Accrued and Deferrals Deferrals : It means when You receive an Invoice for Service; Service provided partially in one Fiscal Year, and Partially for the following Fiscal Year. Ex. : In November You receive an Invoice for IT Service provided from November 2007 until June 2008. You have to charge 2 Months for 2007 and 6 Months for 2008 Fiscal Year. In other words Deferred Costs happens when You receive in advance an Invoice for Services provided in the future. It’s possible to have the same also for Revenues Accrued : Ex. : In May 2008 You receive an invoice for Services provided from November 2007 until May 2008. Normally You have to charge in advance, Cost for Services for November and December 2007 without any Invoice, and You balance this Cost with special Accounts. This happens very often in Hotel management because, for management control, they have to produce every month Profit & loss report. It’s more or less like a Year close done on every Month. In other words Accrued Costs happens when You receive an Invoice for Services after the Service was provided. The same can happens also for revenues. Another possible project –Automotive, Appliances, packaging industry Stock Delivery Suppliers Slitting Levelling Shearing Combi Pressing Polishing Stock Dispatch Customer Packaging Receipts Subloads Loads Quarantine of the def. items Decision :Quality Management Input of the defective Items Batch generations : AAAAAA, AAAAAB, AAAAAC,…. Dispatch Management Allocations Packaging and batches Call-Offs Register of work spent in Production Moulds Reservations Bar Codes Reservations Bar Codes Planning Mapping prinicples Knowledge of methods, which are necessary for project management and process management nTheory of Constraint (will be introduced-72 slides)-seminar work!!!! nCritical chain methodology nThinking tools nThroughput Accounting ->go to wikipedia nBalanced Scorecard (will be introduced) nSWOT a Gap Analysis (You should know it,I guess.. ) nQuality management (Ishikawa and Pareto- will be introduced) nERP system and its logic (will be introduced- 28 hours) nLogistics (warerhouse management) nFinance Management and Controlling nProduction Management (MRP, MRP-II, JIT and DBR) nDecision making tools (Kepner Tregoe-will be introduced) n n Knowledge of methods, which are necessary for project management and process management n nLegal aspects of contracts nCost management nForeign languages nBasic knowledge of IT architecture will be introduced nMethods used for project management nBusiness Analytics nMethods supporting decision making nRisk management nBasics of marketing n n n Will be shown later nThe data is not all in the ERP nThe tools are rigid and hard to learn nThe tools don’t reflect how we work today nThey don’t span the continuum of needs Other ERP Business Analytics – some reason why to discuss Scorecards Slide decks Meetings Analytic applications Presentations Financial reports Dashboards Webcasts Charts and graphs Internet Project plans Documents Spreadsheets Intranet Blogs Portals RSS feeds Business books Television reports Magazines Newspapers IM/chat Email n n VP, Operations VP, Sales and Marketing CFO CEO “I need to have the right demographic information so I can better target my opportunity prospecting.” Sales Rep Customer Support Rep “I need better access to information to make better decisions on cross-sell and up-sell opportunities.” “I need to know that the people in my organization have the right goals in place to understand and execute on the strategic initiatives of the company.” “I need better visibility into our pipeline performance so I can focus on deals that help me grow business with my most profitable customers.” “I need better visibility into my cost of operations so I can target specific cost reduction opportunities that won’t have a negative impact.” “I need to improve our analytics capabilities so we can understand our current business performance and do a better job of planning for the future." Source: “Creating the Office of Strategy Management” by Robert Kaplan and David P. Norton, Harvard Business School, April 2005 Untitled-1 Managing Through the profit valley nInitially, most partners business are run by one or two founders, who manage every part of the business : sales and marketing, project management, service delivery management, accounting, sub-load and load, collection, HR and many many more…. IMG_0441 Those guys are responsible for performing all day-to-day functions of their business Machine%2520Shop,%2520via%2520Yamhill%2520County%2520Oregon%2520online inventory Managing Through the profit valley nAs their business grows over 10 employees, it is impossible to perform all their role properly. nCash flow becomes erratic (chaos) nProjects go offside, nFilling pipeline is a struggle nRevenue stays still strong but profitability drops nCompany is trapped in the „Profit Valley“ http://pixdaus.com/single.php?id=6720 Profit Employees 10 50 100 Managing Through the profit valley nHow to escape the profit valley? nHow to avoid it ? nFirst key nMaintain revenue velocity and the momentum of the new customer adds. You cannot afford to take the foot of the gas if you want to climb out of the valley nThe portfolio of the customers must be some smaller and some larger nSecond key nMaintain high level of service quality to avoid discounting and efficiency factor nSure Step methodology of project Management nHelp desk nRight tools and right people Zobrazit obrázek v plné velikosti Zobrazit obrázek v plné velikosti Managing Through the profit valley nThird key nFinancial management control and cash flow is the king nInvoice quickly and pay consistently (but not early !!! ) nTo maintaining Cash- to-Cash cycle as short as possible nFourth key nSoftware package handling all aspects of financial customer relationship and project management nCash-to-Cash Cycle will be shown during TOC and Critical chain chapters n n n Zobrazit obrázek v plné velikosti Zobrazit obrázek v plné velikosti Managing Through the profit valley Business control needs Driving Business Objectives Personnel required Processes required Systems required Financials General Management Project Max cash flow, Collecting early, paying not early Maintaining revenue velocity, good Marketing machine Reduce scope creep Efficiency factor Utilisation Full time CFO with excellent knowledge Key staff (no job hopping) Mixed team (juniors and seniors) Rigorous FM driven by Key business objective above Continuous Recruiting and training Application of the Good project Methodology (Sure Step) Dynamics NAV Dynamics CRM Project Management Software Thanks for Your Attention Will be placed on IS.MUNI.CZ in the study materials If everyone pulls at the different end of the rope, than your project results will be a mess… (see rule 99 %)