PKRxl/_rels/workbook.xml.rels PK0kxl/theme/theme1.xml PKUZZ xl/styles.xml PK>tKKxl/worksheets/sheet1.xml KRA and KPI TemplatePrepared by Dr. Babu Balakrishnan - drbabu.inHOW TO USE THIS TEMPLATE1A KRA (Key Result Area) is an area the role is accountable for.A KPI is the measure that tells you how well that area is being handled.Line output is a KRA. Units per shift, rejection rate and downtime are its KPIs.2Fill one sheet per role. Do not use one sheet for the whole company.Two people with the same designation may need different result areas.3Aim for 4 to 6 result areas per role. If you exceed 8, the role is not yet defined.4Only use measures the role can actually influence.If someone can have an excellent month and still score badly because of a decisionmade three departments away, the measure is wrong.5Only use measures you can source from records you ALREADY keep.A measure that needs a new register will stop being collected by month three.6Set measures in pairs. Output without a quality counterweight produces rework.Quality without a throughput counterweight produces missed dispatches.7Concentrate weightage. Eight items at 5 percent each changes nobody behaviour.8Do not link to pay in the first cycle. Run one cycle, correct what the dataexposes, then connect outcomes to reward.CHECKLIST BEFORE YOU FINALISE ANY ROLECan the role actually move this measure?Does the data already exist somewhere?Would two different managers score it the same way?What behaviour does this measure invite?Can I trace this result area back to a business goal?More detail: https://drbabu.in/kra-kpi-design/PKllxl/worksheets/sheet2.xml Production Supervisor - KRA and KPI SheetRole holder:Reporting manager:Period:#Key Result AreaWhy it mattersKey Performance IndicatorSource of data (existing record)Target / StandardWeightage %1Line outputDelivery commitments depend on itUnits per shift against planShift production sheet2Line qualityOutput without a quality counterweight creates reworkIn-process rejection rate percentInspection log3Equipment availabilityDowntime is the hidden cost of outputUnplanned downtime hoursDowntime book4Manning and capabilityAbsence and skill gaps stop the lineShift manning vs roster; skill matrix coverageAttendance; skill matrix5SafetyNon negotiable and individually attributableReportable incidents; PPE observationsSafety register6Cost disciplineScrap and consumables are controllableScrap and consumable cost vs standardStores issue registerTOTAL100PKt  xl/worksheets/sheet3.xml Welder - KRA and KPI SheetRole holder:Reporting manager:Period:#Key Result AreaWhy it mattersKey Performance IndicatorSource of data (existing record)Target / StandardWeightage %1Workmanship qualityDirectly controlled by the roleWeld rejections as percent of joints presentedInspection log2ReworkShows quality cost, not just quality rateRework hours as percent of hours bookedJob cards3Throughput to standardBalances the quality measuresJob cards closed within standard timeJob cards4Material disciplineConsumables are individually controllableConsumable usage vs issued quantityStores issue register5Safe practiceHot work carries real riskPPE and hot work permit complianceSafety observation registerTOTAL100PKI[w xl/worksheets/sheet4.xml Quality Inspector - KRA and KPI SheetRole holder:Reporting manager:Period:#Key Result AreaWhy it mattersKey Performance IndicatorSource of data (existing record)Target / StandardWeightage %1Detection reliabilityMeasure escapes, not defects foundEscapes found at next stage or by customerCustomer complaints; next stage log2DocumentationRecords are the deliverableInspection records completed within shiftInspection log3Escalation disciplineSpeed of escalation limits damageNCRs raised and closed within standardNCR register4Instrument reliabilityBad gauges invalidate everythingCalibration schedule adherenceCalibration registerTOTAL100PK] xl/worksheets/sheet5.xml Field Sales Executive - KRA and KPI SheetRole holder:Reporting manager:Period:#Key Result AreaWhy it mattersKey Performance IndicatorSource of data (existing record)Target / StandardWeightage %1RevenuePrimary outcome measureValue achieved against targetSales MIS2CoverageActivity that leads the outcomeProductive calls as percent of planned callsBeat plan / DSR3CollectionsRevenue is not revenue until collectedOutstanding beyond agreed credit daysReceivables ageing4New businessPrevents living off the existing baseNew accounts activated and repeat orderingSales MIS5Market informationCheap and genuinely usefulCompetitor and price feedback submittedCRM / DSRTOTAL100PKϪ xl/worksheets/sheet6.xml Accounts and Collections - KRA and KPI SheetRole holder:Reporting manager:Period:#Key Result AreaWhy it mattersKey Performance IndicatorSource of data (existing record)Target / StandardWeightage %1Ledger accuracyEverything downstream depends on itReconciliations closed by working day standardClosing checklist2Receivables healthWorking capital impactDays sales outstandingReceivables ageing3Statutory timelinessPenalties are avoidableFilings completed on due dateCompliance calendar4Audit readinessReduces year end firefightingAudit observations closed within cycleAudit trackerTOTAL100PK8N xl/worksheets/sheet7.xml HR and Admin Manager - KRA and KPI SheetRole holder:Reporting manager:Period:#Key Result AreaWhy it mattersKey Performance IndicatorSource of data (existing record)Target / StandardWeightage %1Staffing continuityVacancies stop workTime to fill vs agreed standardRecruitment tracker2RetentionEarly attrition signals selection or induction gapsFirst year attrition percentHRIS / payroll3Capability buildingTraining happens or it does notTraining days delivered vs planTraining calendar4Statutory complianceRegisters must be currentRegisters current; returns filed on dateCompliance calendar5Internal serviceHR is a service functionResponse time to employee queriesQuery log / helpdeskTOTAL100PK6 xl/worksheets/sheet8.xml Blank Template - KRA and KPI SheetRole holder:Reporting manager:Period:#Key Result AreaWhy it mattersKey Performance IndicatorSource of data (existing record)Target / StandardWeightage %123456TOTAL100PK`xl/metadata.xml PKxl/workbook.xml PKJjLL _rels/.rels PK2H$DDdocProps/app.xml SheetJSWorksheets8Start HereProduction SupervisorWelderQuality InspectorField Sales ExecutiveAccounts and CollectionsHR and Admin ManagerBlank TemplatePK֒|ZZdocProps/core.xml PKyX [Content_Types].xml PKRxl/_rels/workbook.xml.relsPK0kxl/theme/theme1.xmlPKUZZ $xl/styles.xmlPK>tKK^)xl/worksheets/sheet1.xmlPKll:xl/worksheets/sheet2.xmlPKt  Ixl/worksheets/sheet3.xmlPKI[w Vxl/worksheets/sheet4.xmlPK] bxl/worksheets/sheet5.xmlPKϪ oxl/worksheets/sheet6.xmlPK8N {xl/worksheets/sheet7.xmlPK6 ވxl/worksheets/sheet8.xmlPK`xl/metadata.xmlPKxl/workbook.xmlPKJjLL _rels/.relsPK2H$DD%docProps/app.xmlPK֒|ZZdocProps/core.xmlPKyX  [Content_Types].xmlPKe