{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Context Inputs","Results (ROI)","Calculations","backend"],"not_rendered":{"charts":5,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Context Inputs","index":0,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,5,23,5],[0,0,23,0],[24,0,25,5],[0,2,1,4],[4,1,5,4],[10,1,10,2],[11,1,11,2],[12,1,12,2],[16,1,16,2],[16,4,18,4],[17,1,17,2],[18,1,18,2]]}
[null,null,"The economic impact of Zycus AP Automation solution"]
[]
[]
[null,"About Zycus AP RoI Calculator:"]
[null,"The tool provides estimates for savings associated with the digital transformation of the accounts payable (AP automation) function in any organization, subject to the accuracy and availability of inputs."]
[]
[]
[null,"Organization-specific parameters :"]
[null,"Please input the baseline estimates for your organization to gauge the overall size and volume of AP operations and finances involved."]
[]
[null,"Business metrics",null,"Inputs ","Definitions"]
[null,"1. Number of invoices processed per year",null,200000,"Total number of invoices processed annually "]
[null,"2. Number of accounts payable FTE's per month",null,22,"Total number of full time equivalent (FTE) employees required at present"]
[]
[]
[null,"3. % Split of invoice processing",null,"Inputs"]
[null,"3.a). % paper and PDF invoices",null,0.8,"The % split of invoices received on an annual basis. The total of \n(3.a., 3.b., 3.c.) should be equal to 100%."]
[null,"3.b) % scanned & image invoices",null,0.1]
[null,"3.c). % electronic (XML/EDI) invoices",null,0.1]
[]
[]
[]
[]
[]
["©Zycus. All rights reserved. Unauthorized reproduction prohibited. "]

{"sheet":"Results (ROI)","index":1,"n_rows":86,"n_cols":14,"rows_kept":86,"cut":false,"hidden":false,"merged":[[0,0,86,0],[47,6,48,18],[49,6,50,18],[81,8,81,14],[0,19,86,19],[0,1,1,18],[2,4,3,18],[7,5,7,6],[7,2,7,4],[10,2,10,4],[9,2,9,4],[8,2,8,4],[51,4,53,5],[51,2,53,3],[5,2,5,9],[24,1,25,18],[42,6,43,18],[44,6,46,18],[16,2,16,3],[14,2,14,8],[17,2,18,3],[11,2,11,4],[11,5,11,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[47,2,48,3],[49,1,50,1],[49,2,50,3],[44,4,46,5],[47,4,48,5],[49,4,50,5],[54,1,54,18],[85,1,86,18],[41,1,41,5],[5,13,5,17],[14,13,14,17],[51,1,53,1],[36,2,37,5],[38,2,39,5],[27,2,34,7],[42,1,43,1],[42,2,43,3],[42,4,43,5],[51,6,53,18],[44,1,46,1],[44,2,46,3],[47,1,48,1]]}
[]
[]
[null,null,null,null,"Estimated savings via Zycus AP automation solution"]
[]
[]
[null,null,"Industry Benchmarks",null,null,null,null,null,null,null,null,null,null,"Total savings over a 3-year period :"]
[]
[null,null,"Nature of invoice",null,null,"Process costs per invoice"]
[null,null,"% Electronic (XML/EDI) invoice",null,null,2.13]
[null,null,"% Scanned/imaged invoice",null,null,3.93]
[null,null,"% Paper and PDF invoice",null,null,6.39]
[]
[]
[]
[null,null,"Average no. of invoices processed per FTE/year",null,null,null,null,null,null,null,null,null,null,"Process & FTE Savings after Smart e-invoicing solution (in 3 years)"]
[]
[null,null,"Avg. number of invoices processed per FTE per year increased by:"]
[null,null,{"$f":"Calculations!E67","v":1.6533100000000003}]
[]
[]
[]
[]
[]
[]
[null,"E-invoicing Maturity Model"]
[]
[]
[null,null,"The E-invoicing Maturity model helps define the current stage of process maturity of the AP function with regards to its invoice processing and management.\n\nFor AP function, based on the maturity of invoice processing and management, the below four maturity stages can be defined:"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Current Maturity Model Classification"]
[]
[null,null,{"$f":"IF('Context Inputs'!$D$19<0.2,backend!Q4,IF('Context Inputs'!$D$19<0.5,backend!Q5,IF('Context Inputs'!$D$19<0.9,backend!Q6,backend!Q7)))","v":"Stage 1: Nascent Stage"}]
[]
[]
[null,"E-invoicing Maturity Model Stages"]
[null,"% of invoices in \nE- invoicing format","Stage",null,"Stage Name"]
[]
[null,"0-20","Stage 1: Lower tier",null,"Nascent Stage",null,"At this stage, all invoices are received and stored in the form of paper. AP processes including invoice capture, invoice matching, invoice workflow and approval, exception handling, payment, discount management, and supplier management are disconnected and completely manual."]
[]
[]
[null,"20-50","Stage 2: Mid tier",null,"Evolving Stage",null,"At this stage, invoice capture is through OCR engines. The paper invoices are scanned and converted into an image or pdf format. Data is extracted using OCR engines and fed into an ERP system. "]
[]
[null,"50-90","Stage 3: Top tier",null,"Mainstream",null,"At this stage, there may be fragmented, but integrated software products working in tandem or a single software product enabling invoice capture, workflow management, invoice matching and payment integrated tightly with an ERP system."]
[]
[null,"90+","Stage 4: Elite tier",null,"Best in Class",null,"At this stage, AP processes are automated and efficient. Suppliers are active participants in the process and most of the invoices submitted are in electronic format. Data across procurement, suppliers, and Account Payables is tightly integrated and centralized enabling insightful reporting and analystics for strategic decisioning to capture financial gains."]
[]
[]
[null,"Source: Case study: E-invocing maturity Models for AP process - Improvement Evalution of the current AP process state to plan efficient change management strategies"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"For more information "]
[]
[null,null,null,null,null,null,null,null,"Website:","www.zycus.com"]
[null,null,null,null,null,null,null,null,"Email:","jessica.lim@procurementdiaries.com"]
[null,"©Zycus. All rights reserved. Unauthorized reproduction prohibited. "]

{"sheet":"Calculations","index":2,"n_rows":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":true,"merged":[[0,6,1048575,6],[0,0,6,5],[79,3,79,4],[80,3,80,4],[81,0,81,5],[82,0,82,5],[9,2,27,2],[75,0,75,5],[76,0,76,1],[76,3,76,5],[77,3,77,4],[78,3,78,4],[59,0,59,4],[60,0,60,5],[61,0,61,5],[68,0,68,5],[69,0,69,5],[49,0,49,5],[50,0,50,5],[56,0,56,5],[57,0,57,4],[58,0,58,5],[39,0,39,4],[40,0,40,5],[41,0,41,5],[47,0,47,5],[48,0,48,4],[29,0,29,5],[30,0,30,5],[31,0,31,5],[32,0,32,5],[38,0,38,5],[21,3,21,5],[22,3,22,5],[23,3,23,5],[24,3,24,5],[28,0,28,5],[10,3,10,5],[17,3,17,5],[18,3,18,4],[19,3,19,4],[20,3,20,4],[7,0,7,1],[7,2,7,5],[8,0,8,5],[9,0,9,1],[9,3,9,5]]}
["ROI Calculator"]
[]
[]
[]
[]
[]
[]
[]
[]
["Customer Input",null,null,"Baseline ( not to be shown to the customer)"]
["1. Number of invoices per year ",{"$f":"'Context Inputs'!D12","v":200000}]
["2. Number of Accounts Payable FTEs",{"$f":"'Context Inputs'!D13","v":22},null,"Invoice Formats","Number per Year"," "]
["3. Avg. annual cost per FTE (C&B)",20000,null,"Paper and email/PDFs:",{"$f":"B11*B16","v":160000}," "]
["Total annual FTE cost:",{"$f":"B12*B13","v":440000},null,"Scanned/imaged:",{"$f":"B11*B17","v":20000}," "]
["4. Annual AP systems/outsourcing cost",0,null,"Electronic (XML/EDI/Portal)",{"$f":"B11*B18","v":20000}," "]
["5a. % Paper and PDF invoices",{"$f":"'Context Inputs'!D17","v":0.8}]
["5b. % Scanned/imaged invoices",{"$f":"'Context Inputs'!D18","v":0.1},null,"Totals",{"$f":"SUM(E13:E16)","v":200000}," "]
["5d. % Electronic (XML/EDI)",{"$f":"'Context Inputs'!D19","v":0.1},null,"Annual Invoice Process Cost Calculations (three versions)"]
["Total invoice formats (should be 100%):",{"$f":"SUM(B16:B18)","v":1},null,"A. Best in class process cost ($2.18)",null,{"$f":"B11*2.18","v":436000.00000000006}]
[null," ",null,"B. Per calculated process cost (#6 alternative)",null,{"$f":"B11*B21","v":440000.00000000006}]
["6.    Avg. process cost using AP annual costs",{"$f":"(B14+B15)/B11","v":2.2000000000000002},null,"C. Per industry avg. process cost of $4.57/invoice1",null,{"$f":"B11*4.57","v":914000}]
[null,null,null,"(Best-in-Class invoice process cost is $2.18)1"]
[]
[null,null,null,"IMPACT OF EINVOICING2"]
[null,null,null,"Average Process Cost Savings per Invoice when Transitioned to E-Invoicing"]
[null,null,null,"Paper and eMail PDFs: ",{"$f":"6.39-2.13","v":4.26}]
[null,null,null,"Invoice Scan Capture",{"$f":"(3.93-2.13)","v":1.8000000000000003}]
[]
[" "]
["1The Hackett Group 2019 Purchase-to-Pay (P2P) Performance Study \n2 The Hackett Group 2019 Purchase-to-Pay (P2P) Performance Study"]
[]
[]
["E-INVOICING YEAR 1 POTENTIAL PROCESS SAVINGS"]
["TYPE OF INVOICES","% of Invoices",null,"Number per Year","# Moved to Electronic","Process Savings"]
["Paper and email/PDFs:",{"$f":"0.2*B16","v":0.16000000000000003},null,{"$f":"B35*B11","v":32000.000000000007},{"$f":"E13-D35","v":128000},{"$f":"E35*E26","v":545280}]
["Scanned/imaged:",{"$f":"0.5*B17","v":0.05},null,{"$f":"B36*B11","v":10000},{"$f":"E14-D36","v":10000},{"$f":"E36*E27","v":18000.000000000004}]
["Electronic (XML/EDI):",{"$f":"1-B36-B35","v":0.78999999999999992},null,{"$f":"B37*B11","v":157999.99999999997},"N/A","N/A"]
["Totals:",{"$f":"SUM(B35:B37)","v":1},null,{"$f":"SUM(D35:D37)","v":199999.99999999997},{"$f":"SUM(E35:E36)","v":138000},{"$f":"SUM(F35:F36)","v":563280}]
[]
["Year 1 invoice process cost, based on version B (your original calculated process cost):",null,null,null,null,{"$f":"(F20-F38)/D38","v":-0.61639999999999984}]
[]
["E-INVOICING YEAR 2 POTENTIAL PROCESS SAVINGS"]
["TYPE OF INVOICES","% of Invoices",null,"Number per Year","# Moved to Electronic","Process Savings"]
["Paper and email/PDFs:",{"$f":"0.8*B35","v":0.12800000000000003},null,{"$f":"B44*B11","v":25600.000000000007},{"$f":"E13-D44","v":134400},{"$f":"E44*E26","v":572544}]
["Scanned/imaged:",{"$f":"0.3*B36","v":1.4999999999999999E-2},null,{"$f":"B45*B11","v":3000},{"$f":"E14-D45","v":17000},{"$f":"E45*E27","v":30600.000000000004}]
["Electronic (XML/EDI):",{"$f":"1-B45-B44","v":0.85699999999999998},null,{"$f":"B46*B11","v":171400},"N/A","N/A"]
["Totals:",{"$f":"SUM(B44:B46)","v":1},null,{"$f":"SUM(D44:D46)","v":200000},{"$f":"SUM(E44:E45)","v":151400},{"$f":"SUM(F44:F45)","v":603144}]
[]
["Year 2 invoice process cost, based on version B (your original calculated process cost):",null,null,null,null,{"$f":"(F20-F47)/D47","v":-0.81571999999999967}]
[]
["E-INVOICING YEAR 3 POTENTIAL PROCESS SAVINGS"]
["TYPE OF INVOICES","% of Invoices",null,"Number per Year","# Moved to Electronic","Process Savings"]
["Paper and email/PDFs:",{"$f":"0.85*B44","v":0.10880000000000002},null,{"$f":"B53*B11","v":21760.000000000004},{"$f":"E13-D53","v":138240},{"$f":"E53*E26","v":588902.40000000002}]
["Scanned/imaged:",0,null,{"$f":"B54*B11","v":0},{"$f":"E14-D54","v":20000},{"$f":"E54*E27","v":36000.000000000007}]
["Electronic (XML/EDI):",{"$f":"1-B54-B53","v":0.89119999999999999},null,{"$f":"B55*B11","v":178240},"N/A","N/A"]
["Totals:",{"$f":"SUM(B53:B55)","v":1},null,{"$f":"SUM(D53:D55)","v":200000},{"$f":"SUM(E53:E54)","v":158240},{"$f":"SUM(F53:F54)","v":624902.40000000002}]
[]
["Year 3 invoice process cost, based on version B (your original calculated process cost):",null,null,null,null,{"$f":"(F20-F56)/D56","v":-0.92451199999999978}]
[]
["Process savings grand total after three years (based on different %s of invoice formats):",null,null,null,null,{"$f":"SUM(F56,F47,F38)","v":1791326.4}]
[]
["Potential Impact on AP FTEs"]
[null,"Today"," ","World-Class Average1","Difference/Savings"]
["Number of AP FTEs:",{"$f":"B12","v":22},null,{"$f":"B11/D67","v":8.2915302018987607},{"$f":"B64-D64","v":13.708469798101239},"FTEs that could be eliminated or redirected"]
["Average annual cost per AP FTE:",{"$f":"B13","v":20000}," ",{"$f":"B13","v":20000},"N/A"]
["Total annual AP FTE cost:",{"$f":"B14","v":440000},null,{"$f":"D64*D65","v":165830.60403797522},{"$f":"B66-D66","v":274169.39596202481},"Savings if FTEs eliminated"]
["Avg. # invoices processed per FTE:",{"$f":"B11/B12","v":9090.9090909090901},null,24121,{"$f":"SUM(D67-B67)/B67","v":1.6533100000000003}," "]

{"sheet":"backend","index":3,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":true,"merged":[[14,2,14,3],[14,4,14,6],[14,7,14,9],[14,10,14,12],[1,1,1,2],[1,5,1,7]]}
[]
[null,"SAVINGS",null,null,null,"FTE invoice processed ",null,null,null,"Savings "]
[null,"Process Saving",{"$f":"Calculations!F60","v":1791326.4},null,null,"Currently",{"$f":"Calculations!B67","v":9090.9090909090901},null,null,"Year 1",{"$f":"Calculations!F38","v":563280},null,null,null,"% of invoices in E- invoicing form","Stage","Stage Name"]
[null,"FTE Savings",{"$f":"Calculations!E66","v":274169.39596202481},null,null,"with smart invoicing module (Industry benchmark)",{"$f":"Calculations!D67","v":24121},null,null,"Year 2",{"$f":"Calculations!F47","v":603144},null,null,null,"0-20","Stage 1: Lower tier","Stage 1: Nascent Stage"]
[null,null,null,null,null,null,null,null,null,"Year 3",{"$f":"Calculations!F56","v":624902.40000000002},null,null,null,"20-50","Stage 2: Mid tier","Stage 2: Evolving Stage"]
[null,"Total Savings",{"$f":"C4+C3","v":2065495.7959620247},null,null,null,null,null,null,null,null,null,null,null,"50-90","Stage 3: Top tier","Stage 3: Mainstream"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90+","Stage 4: Elite tier","Stage 4: Best in Class"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,0.8,null,null,0.2,null,null,0.15]
[null,null,"Present",null,"Year 1",null,null,"Year 2",null,null,"Year 3"]
[null,null,"% split","Invoice count","% split","Invoice count","Savings","% split","Invoice count","Savings","% split","Invoice count","Savings"]
[null,"3.a. % paper and pdf invoices",{"$f":"Calculations!B16","v":0.8},400000,{"$f":"C17*0.2","v":0.16000000000000003},100000,1278000,{"$f":"E17*0.8","v":0.12800000000000003},50000,1491000,{"$f":"H17*0.85","v":0.10880000000000002},25000,1597500]
[null,"4.a. % scanned, image invoices",{"$f":"Calculations!B17","v":0.1},50000,{"$f":"C18*0.5","v":0.05},25000,45000.000000000007,{"$f":"E18*0.3","v":1.4999999999999999E-2},0,90000.000000000015,0,0,90000.000000000015]
[null,"5.a. % electronic (XML/EDI)",{"$f":"Calculations!B18","v":0.1},50000,{"$f":"1-E18-E17","v":0.78999999999999992},375000,null,0.9,450000,null,0.95,475000]
[]
[]
[]
[null,null,null,"%electronic",null,"%scanned/image invoices",null,"%paper & pdf invoices"]
[null,null,"Present split",{"$f":"C19","v":0.1},null,{"$f":"C18","v":0.1},null,{"$f":"C17","v":0.8}]
[null,null,"shifted to electronic in year-1",{"$f":"D24+E18","v":0.15000000000000002},null,{"$f":"C18-E18","v":0.05},{"$f":"E17","v":0.16000000000000003},{"$f":"H24-E17","v":0.64}]
[null,null,"Year-1 split",{"$f":"E19","v":0.78999999999999992},null,{"$f":"E18","v":0.05},null,{"$f":"E17","v":0.16000000000000003}]
[null,null,"shifted to electronic in year-2",null,{"$f":"D26","v":0.78999999999999992},{"$f":"E18-H18","v":3.5000000000000003E-2},{"$f":"E17-H27","v":0.12800000000000003},{"$f":"H26-H17","v":3.2000000000000001E-2}]
[null,null,"Year-2 split",{"$f":"D26+F27+H27","v":0.85699999999999998},null,{"$f":"H18","v":1.4999999999999999E-2},null,{"$f":"H17","v":0.12800000000000003}]
[null,null,"Reduced Y3",{"$f":"D28","v":0.85699999999999998},{"$f":"F28-F29","v":0},{"$f":"H18-K18","v":1.4999999999999999E-2},{"$f":"H28-H29","v":0.10880000000000002},{"$f":"H17-K17","v":1.9200000000000009E-2}]
[null,null,"Final split in Year-3",{"$f":"D29+H29+F29","v":0.89119999999999999},null,{"$f":"K18","v":0},null,{"$f":"K17","v":0.10880000000000002}]