--- title: "FMCG/Pharma KPI Scorecard: How accurate are your calculations?" description: FMCG/Pharma KPI Scorecards; Validate and verify. image: https://supplychain.enchange.com/hs-fs/file-339059445-jpg/blog_images/kpi_dashboard_data_verification-resized-600.jpg --- [Login](https://www.enchange.com/login/) - - - - [![Enchange](https://supplychain.enchange.com/hubfs/Enchange_October2019/Image/logo.png)](https://www.enchange.com/) # Route to Market & Supply Chain Blog # FMCG/Pharma KPI Scorecard: How accurate are your calculations? Posted by Dave Jordan on Thu, Oct 31, 2013 - [Tweet](https://twitter.com/share) Well I find it strange anyway.  Whenever I go to see my doctor she always greets me with a cheery “good morning, how are you?” I always feel like replying “well I‘m in your clinic so there is a fair chance I need some medical advice or assistance”. My dentist never asks me if my teeth are ok and my solicitor never thinks I have just popped into his office for a timed and expensive chat about football. If you go into a barbershop there is every chance you have a hair cut in mind and you are not there to buy cheese. ![KPI Dashboard data verification resized 600](https://supplychain.enchange.com/hs-fs/file-339059445-jpg/blog_images/kpi_dashboard_data_verification-resized-600.jpg?width=213&height=213&name=kpi_dashboard_data_verification-resized-600.jpg)On this occasion I was in the clinic to receive the results of my recent annual check-up from the neck-down. Blood and effluent had been collected and analysed for a whole raft of potential bodily malfunctions and anomalies. On this occasion despite a badly timed Indian take away the night before the blood letting, I was passed fit. In fact the doctor actually said I was in the best condition for a man of my age that she had ever seen. With a spring in my step I walked by the unhealthy people in the waiting room and left the clinic beaming before I took a look at the detailed analytical results. Oh very good, a doctor with a sense of humour. In the box showing my age was the number 450! While I found this very funny I also wondered if the error was one of data input or data manipulation. Was it simply someone with a fat finger typing my details into the form while dreamily thinking about the performance of Dave the Hairy Biker on Strictly Come Dancing? Or, did the error occur outside of obvious human control inside[ a slick piece of IT software](https://supplychain.enchange.com/bid/32120/Do-Spreadsheets-Undermine-Your-ERP-in-FMCG)? Even so, although we are making huge technological advances whatever happens inside a piece of software has ultimately been designed and built by a human who may or may not be a follower of pink lycra. How confident are you that [the KPI Dashboard numbers](https://supplychain.enchange.com/bid/52070/balanced-scorecard-performance-measurement-del-boy-style) on which you and your senior FMCG/Pharma colleagues rely are 100% accurate? Has anyone double checked that the logic behind the KPI generation is actually right and still valid for the current situation? Are the KPIs actually incorrect and guiding your business down a route you really shouldn’t be taking? As ever in business, trust is good but check is much, much better! As part of your standard operating procedures on at least an annual basis you should: 1. Review the principles behind KPI selection and adjust as per current business needs, e.g. are the top 20 SKUs still the top 20? 2. Review the calculation steps and logic behind each KPI. 3. Test the IT software by calculating manually or in another IT package – painful but well worth it if this reveals any serious error or bias. 4. Challenge the IT system by inserting dummy numbers to force out-of-specification limits notifications. Simply, a little [validation and verification ](http://en.wikipedia.org/wiki/Verification_and_validation)is what you need. Humans do indeed make mistakes but only humans will spot errors in data insertion or data manipulation. Just because an ERP or Finance IT package is expensive with a sexy name it does not mean it is always 100% correct or infallible. *Image courtesy of Grant Cochrane at[ freedigitalphotos.net](http://www.freedigitalphotos.net/images/Business_People_g201-Businessman_Cartoon_p58615.html)* Tags: [FMCG](https://supplychain.enchange.com/topic/fmcg), [Dave Jordan](https://supplychain.enchange.com/topic/dave-jordan), [CEO](https://supplychain.enchange.com/topic/ceo), [Performance Improvement](https://supplychain.enchange.com/topic/performance-improvement), [Pharma](https://supplychain.enchange.com/topic/pharma), [KPI](https://supplychain.enchange.com/topic/kpi), [Supply Chain](https://supplychain.enchange.com/topic/supply-chain) ### Subscribe Here! ## Implementation Guide - 20 Steps to RtM Excellence [![cta-20-steps-implementation-guide-1](https://supplychain.enchange.com/hs-fs/hubfs/cta-20-steps-implementation-guide-1.png?width=336&name=cta-20-steps-implementation-guide-1.png)](https://supplychain.enchange.com/implementation-guide-to-20-steps-to-route-to-market-excellence) ## RtM Distributor Assessment Tool [![rtm-distributin-assessment-tool-enchange](https://supplychain.enchange.com/hs-fs/hubfs/rtm-distributin-assessment-tool-enchange.png?width=336&name=rtm-distributin-assessment-tool-enchange.png)](https://supplychain.enchange.com/analyse-the-performance-of-your-distributors---free-route-to-market-assessment-form) ## Distributor Assessment Guide [![distributor assessment guide-2](https://supplychain.enchange.com/hubfs/Enchange_October2019/Image/distributor%20assessment%20guide-2.webp)](https://supplychain.enchange.com/distributor-assessment-guide) ## 3rd Degree Partnership Guide [![3rd degree partnership download](https://supplychain.enchange.com/hubfs/Enchange_October2019/Image/3rd%20degree%20partnership%20download.webp)](https://supplychain.enchange.com/implementing-third-degree-partnerships-guide) ## Indirect Distribution: FMCG  Distributors vs. Wholesalers [![cta_ditributor-wholesale-download_sidebar](https://supplychain.enchange.com/hs-fs/hubfs/cta_ditributor-wholesale-download_sidebar.png?width=336&name=cta_ditributor-wholesale-download_sidebar.png)](https://supplychain.enchange.com/indirect-distribution-fmcg-distributors-vs.-wholesalers) ## 8 Steps to Drive Distributor Excellence ![cta-8-steps-distributor-excellence](https://supplychain.enchange.com/hs-fs/hubfs/cta-8-steps-distributor-excellence.png?width=336&name=cta-8-steps-distributor-excellence.png)   [![awrad](https://supplychain.enchange.com/hubfs/Enchange_October2019/Image/Supply-Chain-transparent_216px.png)](http://blog.feedspot.com/supply_chain_blogs/) ### Connect with Enchange Online ### Posts by Topics - [Dave Jordan (432)](https://supplychain.enchange.com/topic/dave-jordan) - [FMCG (386)](https://supplychain.enchange.com/topic/fmcg) - [Supply Chain (249)](https://supplychain.enchange.com/topic/supply-chain) - [S&OP (226)](https://supplychain.enchange.com/topic/sop) - [Route to Market (202)](https://supplychain.enchange.com/topic/route-to-market) - [Forecasting & Demand Planning (177)](https://supplychain.enchange.com/topic/forecasting-demand-planning) - [Performance Improvement (175)](https://supplychain.enchange.com/topic/performance-improvement) - [Distribution (141)](https://supplychain.enchange.com/topic/distribution) - [Traditional Trade (114)](https://supplychain.enchange.com/topic/traditional-trade) - [Sales (112)](https://supplychain.enchange.com/topic/sales) - [CEO (111)](https://supplychain.enchange.com/topic/ceo) - [Inventory Management & Stock Control (105)](https://supplychain.enchange.com/topic/inventory-management-stock-control) - [Humour (94)](https://supplychain.enchange.com/topic/humour) - [Brewing & Beverages (88)](https://supplychain.enchange.com/topic/brewing-beverages) - [Michael Thompson (88)](https://supplychain.enchange.com/topic/michael-thompson) - [Pharma (84)](https://supplychain.enchange.com/topic/pharma) - [RTM Assessment Tool (83)](https://supplychain.enchange.com/topic/rtm-assessment-tool) - [RTM (77)](https://supplychain.enchange.com/topic/rtm) - [RtM Strategy (74)](https://supplychain.enchange.com/topic/rtm-strategy) - [Logistics Management (71)](https://supplychain.enchange.com/topic/logistics-management) - [CEE (67)](https://supplychain.enchange.com/topic/cee) - [Ross Marie (64)](https://supplychain.enchange.com/topic/ross-marie) - [20 Steps to RtM Excellence (63)](https://supplychain.enchange.com/topic/20-steps-to-rtm-excellence) - [Customer service (63)](https://supplychain.enchange.com/topic/customer-service) - [KPI (61)](https://supplychain.enchange.com/topic/kpi) - [SKU (57)](https://supplychain.enchange.com/topic/sku) - [Logistics Service Provider (48)](https://supplychain.enchange.com/topic/logistics-service-provider) - [Cost Reduction (37)](https://supplychain.enchange.com/topic/cost-reduction) - [Retail (37)](https://supplychain.enchange.com/topic/retail) - [Supply Chain House (36)](https://supplychain.enchange.com/topic/supply-chain-house) - [supply chain excellence (35)](https://supplychain.enchange.com/topic/supply-chain-excellence) - [Doing Business in Africa (31)](https://supplychain.enchange.com/topic/doing-business-in-africa) - [ERP/SAP (30)](https://supplychain.enchange.com/topic/erp-sap) - [Supply Chain Analytics (30)](https://supplychain.enchange.com/topic/supply-chain-analytics) - [Christmas (28)](https://supplychain.enchange.com/topic/christmas) - [Integrated Business Planning (28)](https://supplychain.enchange.com/topic/integrated-business-planning) - [The ABC of RtM (27)](https://supplychain.enchange.com/topic/the-abc-of-rtm) - [Interim Management (22)](https://supplychain.enchange.com/topic/interim-management) - [Promotions (22)](https://supplychain.enchange.com/topic/promotions) - [Manufacturing Footprint (18)](https://supplychain.enchange.com/topic/manufacturing-footprint) - [IT (12)](https://supplychain.enchange.com/topic/it) - [3PL (10)](https://supplychain.enchange.com/topic/3pl) - [Information (10)](https://supplychain.enchange.com/topic/information) - [Order to Cash (10)](https://supplychain.enchange.com/topic/order-to-cash) - [Logistica Management (9)](https://supplychain.enchange.com/topic/logistica-management) - [Mergers & Acquisitions (9)](https://supplychain.enchange.com/topic/mergers-acquisitions) - [Telecoms (9)](https://supplychain.enchange.com/topic/telecoms) - [4PL (6)](https://supplychain.enchange.com/topic/4pl) - [Compliance (6)](https://supplychain.enchange.com/topic/compliance) - [ERP (6)](https://supplychain.enchange.com/topic/erp) - [Transportation (6)](https://supplychain.enchange.com/topic/transportation) - [3PLP (5)](https://supplychain.enchange.com/topic/3plp) - [Communication (5)](https://supplychain.enchange.com/topic/communication) - [Sourcing (5)](https://supplychain.enchange.com/topic/sourcing) - [Keith Marshall (4)](https://supplychain.enchange.com/topic/keith-marshall) - [Outsourcing (4)](https://supplychain.enchange.com/topic/outsourcing) - [Spare Parts (4)](https://supplychain.enchange.com/topic/spare-parts) - [Stefan Cucu (4)](https://supplychain.enchange.com/topic/stefan-cucu) - [Vietnam (4)](https://supplychain.enchange.com/topic/vietnam) - [covid19 (4)](https://supplychain.enchange.com/topic/covid19) - [Balanced Scorecard (3)](https://supplychain.enchange.com/topic/balanced-scorecard) - [DIY (3)](https://supplychain.enchange.com/topic/diy) - [DRS (3)](https://supplychain.enchange.com/topic/drs) - [Digital (3)](https://supplychain.enchange.com/topic/digital) - [Production Planning (3)](https://supplychain.enchange.com/topic/production-planning) - [Ratib Ratib (3)](https://supplychain.enchange.com/topic/ratib-ratib) - [Recovery (3)](https://supplychain.enchange.com/topic/recovery) - [SUPPLY PLANNING (3)](https://supplychain.enchange.com/topic/supply-planning) - [Andy Dixon (2)](https://supplychain.enchange.com/topic/andy-dixon) - [IBP (2)](https://supplychain.enchange.com/topic/ibp) - [Low Carbon (2)](https://supplychain.enchange.com/topic/low-carbon) - [Planning (2)](https://supplychain.enchange.com/topic/planning) - [Private Equity (2)](https://supplychain.enchange.com/topic/private-equity) - [Supply Chain Strategy (2)](https://supplychain.enchange.com/topic/supply-chain-strategy) - [WMS (2)](https://supplychain.enchange.com/topic/wms) - [Warehousing (2)](https://supplychain.enchange.com/topic/warehousing) - [Wholesale (2)](https://supplychain.enchange.com/topic/wholesale) - [Agrochemicals (1)](https://supplychain.enchange.com/topic/agrochemicals) - [Aristide Kouame (1)](https://supplychain.enchange.com/topic/aristide-kouame) - [CONSULTING (1)](https://supplychain.enchange.com/topic/consulting) - [Deposit Recovery Scheme (1)](https://supplychain.enchange.com/topic/deposit-recovery-scheme) - [Dianna Vorpagel (1)](https://supplychain.enchange.com/topic/dianna-vorpagel) - [Dumisani Siziba (1)](https://supplychain.enchange.com/topic/dumisani-siziba) - [Food (1)](https://supplychain.enchange.com/topic/food) - [HR (1)](https://supplychain.enchange.com/topic/hr) - [INNOVATION (1)](https://supplychain.enchange.com/topic/innovation) - [Make (1)](https://supplychain.enchange.com/topic/make) - [Manufacturing (1)](https://supplychain.enchange.com/topic/manufacturing) - [Refillable PET (1)](https://supplychain.enchange.com/topic/refillable-pet) - [Scheduling (1)](https://supplychain.enchange.com/topic/scheduling) - [WASTE (1)](https://supplychain.enchange.com/topic/waste) - [finance (1)](https://supplychain.enchange.com/topic/finance) - [procurement (1)](https://supplychain.enchange.com/topic/procurement) [See all](https://supplychain.enchange.com/bid/71383/FMCG-Pharma-KPI-Scorecard-How-accurate-are-your-calculations#) Enchange Registered office: 2 Piries Place, Horsham, West Sussex, RH12 1EH, UK.   Enchange Limited is a company registered in England and Wales with company number 2862912.  Enchange VAT number: 528 7834 08                                                                                   ©2019 Enchange Ltd. All rights reserved [Privacy Policy](https://www.enchange.com/privacy-policy) [Cookies](https://www.enchange.com/cookie-policy/)