OPERATIONAL ANALYTICS & STRATEGIC KPI FR...

by Unattributed

Audio version created with Paper2Audio.

Listen on Paper2Audio

Audio by Paper2Audio

Operational Analytics & Strategic K.P.I Frameworks: the Master sin-de-sis

Domain 1: Sales Performance & Profitability

K.P.I's: Total Revenue, Total Profit, Profit Margin %, Revenue per Unit, Target Achievement %, Target Gap, Revenue Growth %, Segment Revenue Share %

Total Revenue

- Definition: The sum of all sales values generated from transactions over a given period.

- Intuitive Explanation and How It Can Be Used: It establishes the top-line scale of the business. However, sales volume can mask margin erosion. Comparing overall revenue trends with margin trajectories helps avoid chasing empty volume.

- Formula: Total Revenue = Σ Revenue

Total Profit

- Definition: The total financial contribution remaining after all relevant product and operational costs have been subtracted.

- Intuitive Explanation and How It Can Be Used: It is the ultimate indicator of raw value creation. A salesperson or product might dominate revenue generation but contribute very little to net profit; tracking Total Profit helps prioritize high-value segments.

- Formula: Total Profit = Σ Profit

Profit Margin %

- Definition: The percentage of sales revenue that is converted into profit.

- Intuitive Explanation and How It Can Be Used: This acts as an efficiency ratio for sales and pricing. High revenue with low profit margins signals high cost structures or aggressive discounting. It is used to evaluate the commercial health of products and territories.

- Formula: Profit Margin % = Profit ÷ Revenue × 100

Revenue per Unit

- Definition: The average revenue generated for each physical unit of product sold.

- Intuitive Explanation and How It Can Be Used: Indicates pricing power and product mix. Shifts in this metric can signal that customer demand is migrating toward lower-tier or higher-tier products, or that discounting is increasing.

- Formula: Revenue per Unit = Revenue ÷ Units Sold

Target Achievement %

- Definition: The ratio of actual revenue generated compared to the established sales target or quota.

- Intuitive Explanation and How It Can Be Used: Measures individual and regional effectiveness against strategic goals. It helps identify underperforming regions or unrealistic targets.

- Formula: Target Achievement % = Actual Revenue ÷ Target × 100

Target Gap

- Definition: The absolute difference between the actual revenue generated and the set target.

- Intuitive Explanation and How It Can Be Used: It quantifies the shortfall or surplus in raw currency, highlighting exactly how much ground the sales organization needs to make up or how far they exceeded goals.

- Formula: Target Gap = Actual Revenue − Target

Revenue Growth %

- Definition: The percentage change in net sales value between a current period and a baseline comparison period.

- Intuitive Explanation and How It Can Be Used: Reflects commercial momentum. If expense growth outpaces revenue growth, overall profitability deteriorates, making it vital to evaluate this alongside cost trends.

- Formula: Revenue Growth % = (Current Revenue − Previous Revenue) ÷ Previous Revenue × 100

Segment Revenue Share %

- Definition: The percentage contribution of a specific region, product, or salesperson to the company's total revenue.

- Intuitive Explanation and How It Can Be Used: Reveals sales concentration and portfolio dependency. Identifying which segments drive the business helps allocate resources efficiently and highlights potential over-reliance risks.

- Formula: Segment Revenue Share % = Segment Revenue ÷ Total Revenue × 100

Domain 2: Customer Churn, Risk & Retention

K.P.I's: Churn Rate %, Segment Churn %, Churn Growth %, Average Usage, Average Complaints, Risk Score, Retention Rate %

Churn Rate %

- Definition: The percentage of a customer population that terminates their subscription or relationship during a given period.

- Intuitive Explanation and How It Can Be Used: Reflects product-market fit and customer satisfaction. Churn is lagging; tracking it helps trigger reactive win-back campaigns and highlights systemic service or product flaws.

- Formula: Churn Rate % = Churned Customers ÷ Total Customers × 100

Segment Churn %

- Definition: The churn rate calculated specifically for a targeted subgroup of customers.

- Intuitive Explanation and How It Can Be Used: Since churn is rarely uniform, segmenting it by tenure, demographics, or usage patterns reveals high-risk cohorts and helps H.R/Marketing deploy targeted, high-priority retention strategies.

- Formula: Segment Churn % = Segment Churned Customers ÷ Segment Customers × 100

Churn Growth %

- Definition: The rate at which the absolute volume or rate of customer churn is increasing or decreasing over time.

- Intuitive Explanation and How It Can Be Used: Serves as an early warning indicator. Rapid acceleration in churn growth suggests a degrading competitive position, customer service bottleneck, or price sensitivity.

- Formula: Churn Growth % = (Current Churn − Previous Churn) ÷ Previous Churn × 100

Average Usage

- Definition: The average amount of product or service utilization per customer.

- Intuitive Explanation and How It Can Be Used: Measures customer engagement. Drops in product usage often precede formal churn, allowing teams to proactively target low-usage groups before they cancel.

- Formula: Average Usage = Total Usage ÷ Number of Customers

Average Complaints

- Definition: The average number of formal customer complaints registered per customer.

- Intuitive Explanation and How It Can Be Used: Quantifies customer friction. Slower complaint resolution days and higher average complaints are strong forward-looking indicators of customer attrition.

- Formula: Average Complaints = Total Complaints ÷ Number of Customers

Risk Score

- Definition: A composite index scoring the probability of a customer churning based on multiple predictive behavioral indicators.

- Intuitive Explanation and How It Can Be Used: Combines indicators like short tenure, dropping usage, and high complaints to build a single score. It allows customer success teams to prioritize high-risk, high-value accounts.

- Formula: Risk Score = Σ Risk Indicators (e.g., Short Tenure + Low Usage + High Complaints)

Retention Rate %

- Definition: The percentage of starting customers who remain active at the end of a given period.

- Intuitive Explanation and How It Can Be Used: It measures customer loyalty and relationship durability. Retaining existing customers is far more cost-effective than acquiring new ones; keeping this high stabilizes the business's revenue floor.

- Formula: Retention Rate % = Retained Customers ÷ Total Customers at Start × 100

Domain 3: Marketing Campaign Performance & R.O.I

K.P.I's: Conversion Rate %, Cost per Lead (C.P.L), Cost per Acquired Customer (C.A.C), R.O.A.S, R.O.I %, Campaign Revenue Share %

Conversion Rate %

- Definition: The percentage of prospective leads or website visitors who complete a desired target action (e.g., purchasing, signing up).

- Intuitive Explanation and How It Can Be Used: Measures the effectiveness of sales funnels and message relevance. Low conversion rates suggest high friction in the checkout process or poor campaign targeting.

- Formula: Conversion Rate % = Customers ÷ Leads × 100

Cost per Lead (C.P.L)

- Definition: The average marketing expenditure required to generate a single prospective customer lead.

- Intuitive Explanation and How It Can Be Used: Evaluates upstream marketing efficiency across different channels (Search, Social, Email). It helps identify channels that generate raw interest cheaply but requires pairing with conversion rates to determine true value.

- Formula: C.P.L = Campaign Spend ÷ Leads

Cost per Acquired Customer (C.A.C)

- Definition: The total marketing spend divided by the number of actual customers acquired from that spend.

- Intuitive Explanation and How It Can Be Used: Measures the direct cost of commercial expansion. C.A.C must always be compared to Customer Lifetime Value (C.L.V); an unsustainable C.A.C relative to C.L.V indicates a failing business model.

- Formula: C.A.C = Campaign Spend ÷ Customers

R.O.A.S (Return on Ad Spend)

- Definition: The gross revenue generated per unit of currency spent on advertising.

- Intuitive Explanation and How It Can Be Used: Measures immediate campaign efficiency. While valuable, it ignores cost of goods sold, meaning campaigns with high R.O.A.S can still result in negative net margins if product costs are high.

- Formula: R.O.A.S = Revenue ÷ Campaign Spend

R.O.I %

- Definition: The net financial return generated by a campaign relative to the investment made.

- Intuitive Explanation and How It Can Be Used: The ultimate arbiter of marketing efficiency. High revenue campaigns can require massive budgets, resulting in a low R.O.I; this metric ensures we invest capital where it generates the strongest return.

- Formula: R.O.I % = (Revenue − Campaign Spend) ÷ Campaign Spend × 100

Campaign Revenue Share %

- Definition: The proportion of total company revenue that can be directly attributed to a specific marketing campaign or channel.

- Intuitive Explanation and How It Can Be Used: Reveals the business's reliance on specific marketing channels. It indicates where the organization's growth is being driven and highlights risks of channel dependency.

- Formula: Campaign Revenue Share % = Campaign Revenue ÷ Total Revenue × 100

Domain 4: Enterprise Financial Performance & Control

K.P.I's: Net Cash Flow, Profit Margin %, Budget Variance, Budget Variance %, Revenue Growth %

Net Cash Flow

- Definition: The net difference between cash inflows (cash received) and cash outflows (cash paid) over a given period.

- Intuitive Explanation and How It Can Be Used: It is the ultimate metric for solvency. A business can report record accounting profits and revenues but go bankrupt if cash is trapped in unpaid accounts receivable or excess inventory.

- Formula: Net Cash Flow = Cash Inflows − Cash Outflows

Budget Variance

- Definition: The absolute financial difference between the actual result and the planned budget.

- Intuitive Explanation and How It Can Be Used: Highlights operational deviations. Unfavorable cost variances trigger deep-dive root cause analyses (e.g., assessing volume, price, or mix changes) to bring expenses back in line.

- Formula: Budget Variance = Actual − Budget

Budget Variance %

- Definition: The percentage deviation of actual financial outcomes relative to the budgeted target.

- Intuitive Explanation and How It Can Be Used: Standardizes performance variance across different department sizes, allowing executives to immediately pinpoint which business areas are wildly off-course.

- Formula: Budget Variance % = (Actual − Budget) ÷ Budget × 100

Domain 5: Inventory, Stockouts & Supply Efficiency

K.P.I's: Stockout Rate %, Inventory Turnover, Average Inventory, Days of Inventory, Reorder Point

Stockout Rate %

- Definition: The percentage of orders or demand requests that cannot be fulfilled due to lack of available stock.

- Intuitive Explanation and How It Can Be Used: Quantifies lost sales and customer dissatisfaction. High stockout rates indicate a breakdown in replenishment policies or supplier lead time management.

- Formula: Stockout Rate % = Stockout Events ÷ Total Demand/Orders × 100

Inventory Turnover

- Definition: The ratio of Cost of Goods Sold (C.O.G.S) to the average inventory held during the period.

- Intuitive Explanation and How It Can Be Used: Measures how efficiently capital is deployed. High turnover indicates strong demand and efficient asset utilization, whereas very low turnover reveals excess, stagnant stock tying up working capital.

- Formula: Inventory Turnover = Cost of Goods Sold ÷ Average Inventory

Average Inventory

- Definition: The mean value or volume of stock held by the business over a specific timeframe.

- Intuitive Explanation and How It Can Be Used: Serves as the baseline asset metric for calculating carrying costs and asset efficiency. Keeping this optimized reduces storage and obsolescence expenses.

- Formula: Average Inventory = (Opening Inventory + Closing Inventory) ÷ 2

Days of Inventory

- Definition: The average number of days required to fully sell out the current inventory balance.

- Intuitive Explanation and How It Can Be Used: Translates stock levels into a clear timeline. It helps operational teams understand how long they can survive on current stock without ordering more.

- Formula: Days of Inventory = Average Inventory ÷ Cost of Goods Sold × Number of Days

Reorder Point

- Definition: The specific stock level that triggers a replenishment purchase order.

- Intuitive Explanation and How It Can Be Used: Balances expected customer demand during lead times with safety stock buffers. It ensures that replenishment arrives before stockout occurs, preventing lost commercial value.

- Formula: Reorder Point = Demand During Lead Time + Safety Stock

Domain 6: Employee Attrition, Retention & Engagement

K.P.I's: Attrition Rate %, Attrition Change %, Department Attrition Rate %, Average Tenure, H.R Retention Rate %

Attrition Rate %

- Definition: The percentage of employees who exit the company relative to the average headcount.

- Intuitive Explanation and How It Can Be Used: Measures workforce stability and workplace health. High attrition increases recruitment and training costs while eroding operational consistency.

- Formula: Attrition Rate % = Employees Who Left ÷ Average Employee Headcount × 100

Attrition Change %

- Definition: The percentage change in attrition rates between the current period and a historical baseline.

- Intuitive Explanation and How It Can Be Used: Identifies whether retention efforts are working or if cultural/management issues are actively worsening across the enterprise.

- Formula: Attrition Change % = (Current Attrition − Previous Attrition) ÷ Previous Attrition × 100

Department Attrition Rate %

- Definition: The attrition rate calculated for a specific department or team.

- Intuitive Explanation and How It Can Be Used: Helps H.R pinpoint localized management, workload, or salary disparities. If attrition is concentrated in one team, it indicates a department-specific issue rather than a company-wide crisis.

- Formula: Department Attrition Rate % = Department Attrition ÷ Department Headcount × 100

Average Tenure

- Definition: The average length of time employees remain employed with the company.

- Intuitive Explanation and How It Can Be Used: Measures experience depth. A higher average tenure signals stable, skilled operations and strong employee satisfaction, while short tenure can highlight early-career friction.

- Formula: Average Tenure = Total Employee Tenure ÷ Employee Count

H.R Retention Rate %

- Definition: The percentage of employees active at the start of a period who remain with the firm at the end.

- Intuitive Explanation and How It Can Be Used: Focuses strictly on preserving the existing workforce. It evaluates H.R's ability to maintain core organizational knowledge.

- Formula: H.R Retention Rate % = Employees Retained ÷ Employees at Start × 100

Domain 7: Supply Chain, Supplier & Delivery Performance

K.P.I's: O.T.I.F %, On-Time Delivery %, Average Lead Time, Cost per Shipment, Delay Rate %

O.T.I.F % (On-Time and In-Full)

- Definition: The percentage of orders delivered to the customer both on time (relative to the commitment date) and in full (no missing items).

- Intuitive Explanation and How It Can Be Used: The gold standard for supply chain reliability. It ensures customer service is maintained. Evaluating suppliers on cost alone can mask poor O.T.I.F, leading to operational chaos.

- Formula: O.T.I.F % = Orders Delivered On Time and In Full ÷ Total Orders × 100

On-Time Delivery %

- Definition: The percentage of deliveries arrived on or before the committed schedule, regardless of item completeness.

- Intuitive Explanation and How It Can Be Used: Evaluates transportation and route efficiency. It helps isolate logistical delays from warehouse picking/packing errors.

- Formula: On-Time Delivery % = On-Time Deliveries ÷ Total Deliveries × 100

Average Lead Time

- Definition: The average duration of time elapsed between placing an order and receiving the goods.

- Intuitive Explanation and How It Can Be Used: Measures supplier speed. Long or volatile lead times force the business to carry excess safety stock, increasing overall carrying costs.

- Formula: Average Lead Time = Total Lead Time ÷ Number of Orders

Cost per Shipment

- Definition: The average logistics and distribution expenditure incurred for each individual shipment.

- Intuitive Explanation and How It Can Be Used: Measures transport cost efficiency. Consolidating shipments or re-optimizing routes can lower this metric, directly boosting operating margins.

- Formula: Cost per Shipment = Total Logistics Cost ÷ Number of Shipments

Delay Rate %

- Definition: The percentage of shipments that experience delays past the expected delivery date.

- Intuitive Explanation and How It Can Be Used: Spotlights systemic bottlenecks. A high delay rate indicates issues with custom clearances, supplier capacity, or carrier reliability.

- Formula: Delay Rate % = Delayed Deliveries ÷ Total Deliveries × 100

Domain 8: Store Performance & Operational Efficiency

K.P.I's: Store Profit Margin %, Store Conversion Rate %, Revenue per Employee, Store Revenue Share %

Store Profit Margin %

- Definition: The percentage of store sales revenue that is converted into operating profit.

- Intuitive Explanation and How It Can Be Used: Identifies physical asset profitability. High sales do not always mean strong performance; high-sales stores can have thin margins due to excessive rent, theft, or localized pricing discounts.

- Formula: Store Profit Margin % = Store Profit ÷ Store Revenue × 100

Store Conversion Rate %

- Definition: The percentage of store visitors who complete a transaction.

- Intuitive Explanation and How It Can Be Used: Measures retail sales team effectiveness and product placement. It isolates foot-traffic trends from salesperson performance, highlighting whether poor store sales are caused by low foot traffic or poor sales closing.

- Formula: Store Conversion Rate % = Transactions ÷ Visitors × 100

Revenue per Employee

- Definition: The average revenue generated per store staff member.

- Intuitive Explanation and How It Can Be Used: Measures labor productivity and staffing efficiency. It helps store managers optimize shift scheduling and avoid over-staffing during low-traffic periods.

- Formula: Revenue per Employee = Store Revenue ÷ Number of Employees

Store Revenue Share %

- Definition: The percentage contribution of a specific store to total company sales.

- Intuitive Explanation and How It Can Be Used: Helps executives map and monitor geographic sales concentrations, prioritizing high-contribution brick-and-mortar hubs for inventory allocation and capital upgrades.

- Formula: Store Revenue Share % = Store Revenue ÷ Total Revenue × 100

Domain 9: Enterprise Performance & Executive Control

K.P.I's: K.P.I Achievement %, K.P.I Variance, K.P.I Variance %, K.P.I Growth %

K.P.I Achievement %

- Definition: The ratio of actual measured performance to the target K.P.I value.

- Intuitive Explanation and How It Can Be Used: Offers a high-priority executive view across diverse departments. It allows leadership to immediately identify underperforming business functions.

- Formula: K.P.I Achievement % = Actual K.P.I ÷ Target K.P.I × 100

K.P.I Variance

- Definition: The absolute difference between the actual performance and the expected target.

- Intuitive Explanation and How It Can Be Used: Quantifies deviations in raw operational terms. This helps leadership prioritize intervention based on the absolute scale of the gap.

- Formula: K.P.I Variance = Actual − Target

K.P.I Variance %

- Definition: The percentage deviation of actual K.P.I metrics relative to their targets.

- Intuitive Explanation and How It Can Be Used: Standardizes cross-department performance, showing relative execution issues across the entire organization.

- Formula: K.P.I Variance % = (Actual − Target) ÷ Target × 100

K.P.I Growth %

- Definition: The rate of change in a K.P.I metric compared to a prior historical period.

- Intuitive Explanation and How It Can Be Used: Evaluates strategic trajectory and progress. It isolates seasonal spikes to determine whether the department's baseline execution is structurally improving.

- Formula: K.P.I Growth % = (Current Value − Previous Value) ÷ Previous Value × 100

Domain 10: E-commerce Funnel & Customer Value

K.P.I's: Conversion Rate %, Cart Abandonment %, Average Order Value (A.O.V), Repeat Purchase Rate %, Customer Lifetime Value (C.L.V)

Conversion Rate % (E-Commerce)

- Definition: The percentage of e-commerce website visitors who complete a purchase.

- Intuitive Explanation and How It Can Be Used: Measures digital storefront performance. A high drop-off rate between adding products to cart and purchasing signals website friction or unexpected shipping costs.

- Formula: Conversion Rate % = Purchases ÷ Visitors × 100

Cart Abandonment %

- Definition: The percentage of online shopping carts created that do not result in a completed transaction.

- Intuitive Explanation and How It Can Be Used: Measures transaction intent versus friction. High cart abandonment rates highlight pricing surprises, payment platform failures, or poor checkout U.X.

- Formula: Cart Abandonment % = (Carts − Purchases) ÷ Carts × 100

Average Order Value (A.O.V)

- Definition: The average revenue generated per transaction or order completed on the platform.

- Intuitive Explanation and How It Can Be Used: A key lever for scaling revenue. Instead of spending capital to acquire new traffic, raising A.O.V via product bundles or cross-selling is highly cost-effective.

- Formula: A.O.V = Total Revenue ÷ Number of Orders

Repeat Purchase Rate %

- Definition: The percentage of customers who complete more than one purchase over their lifecycle.

- Intuitive Explanation and How It Can Be Used: Evaluates customer retention and post-purchase satisfaction. High repeat rates reduce overall dependency on expensive customer acquisition channels.

- Formula: Repeat Purchase Rate % = Customers with Repeat Purchases ÷ Total Customers × 100

Customer Lifetime Value (C.L.V)

- Definition: The total net financial contribution expected from a customer over their entire relationship with the brand.

- Intuitive Explanation and How It Can Be Used: The foundational metric for subscription and e-commerce business health. It tells marketing teams exactly how much they can afford to spend to acquire a single customer.

- Formula: C.L.V = Average Customer Value × Purchase Frequency × Customer Lifespan

Domain 11: Credit Risk & Loan Portfolio Health

K.P.I's: Default Rate %, N.P.A Rate %, Repayment Rate %, Collection Efficiency %, Risk Exposure

Default Rate %

- Definition: The percentage of loans that fail to make contractual payments and default relative to total active loans.

- Intuitive Explanation and How It Can Be Used: Measures underlying loan underwriting quality and credit risk. High default rates signal that credit screening criteria are too lax.

- Formula: Default Rate % = Defaulted Loans ÷ Total Loans × 100

N.P.A Rate % (Non-Performing Asset Rate)

- Definition: The percentage of the total loan portfolio value that is classified as non-performing or in default.

- Intuitive Explanation and How It Can Be Used: Monitors systemic balance sheet risk for financial institutions. Rising N.P.A rates degrade liquidity and require institutions to hold larger loss reserves.

- Formula: N.P.A Rate % = N.P.A Amount ÷ Total Loan Portfolio × 100

Repayment Rate %

- Definition: The percentage of the total contractual loan payment amount due that is successfully repaid.

- Intuitive Explanation and How It Can Be Used: Measures cash flow coming back into the institution. It helps finance teams forecast liquidity and evaluate credit collection policies.

- Formula: Repayment Rate % = Amount Repaid ÷ Amount Due × 100

Collection Efficiency %

- Definition: The percentage of total outstanding overdue loan payments that collections successfully recovers.

- Intuitive Explanation and How It Can Be Used: Evaluates collections team productivity and recovery effectiveness. High efficiency helps stabilize cash flows and mitigates default losses.

- Formula: Collection Efficiency % = Amount Collected ÷ Amount Due × 100

Risk Exposure

- Definition: The total financial volume at risk within a customer or loan segment multiplied by its associated risk probability.

- Intuitive Explanation and How It Can Be Used: Prioritizes risk based on financial scale. A segment with high default rate but tiny exposure is far less threatening than a moderately risky segment with massive credit exposure.

- Formula: Risk Exposure = Customer/Segment Exposure × Risk Rate

Domain 12: Receivables, Collections & Working Capital

K.P.I's: Overdue %, Days Sales Outstanding (D.S.O), Collection Rate %, Average Payment Days

Overdue %

- Definition: The percentage of total accounts receivable that are past their contractual due date.

- Intuitive Explanation and How It Can Be Used: Measures working capital blockages. It prompts credit managers to audit late-paying customer segments and tighten payment terms before cash flow freezes.

- Formula: Overdue % = Overdue Receivables ÷ Total Receivables × 100

Days Sales Outstanding (D.S.O)

- Definition: The average number of days it takes for a company to collect cash after making a credit sale.

- Intuitive Explanation and How It Can Be Used: Measures credit and collections efficiency. A rising D.S.O indicates late payments, which locks up valuable capital that could be used for operating expenses.

- Formula: D.S.O = Average Accounts Receivable ÷ Credit Sales × Number of Days

Collection Rate %

- Definition: The percentage of invoice payments successfully collected relative to the outstanding balance due.

- Intuitive Explanation and How It Can Be Used: Indicates debt-recovery capability. It focuses collections teams on recovering past-due balances before they turn into bad debt.

- Formula: Collection Rate % = Amount Collected ÷ Amount Due × 100

Average Payment Days

- Definition: The average duration in days that customers take to pay off their invoices.

- Intuitive Explanation and How It Can Be Used: Tracks customer payment behavior. It allows accounts receivable to identify chronically late customers and apply penalties or negotiate upfront payments.

- Formula: Average Payment Days = Total Payment Days ÷ Number of Payments

Domain 13: Procurement Spend & Supplier Savings

K.P.I's: Spend Share %, Average Purchase Price, Price Variance, Price Variance %, Savings Potential

Spend Share %

- Definition: The percentage of total procurement spending allocated to a specific vendor or category.

- Intuitive Explanation and How It Can Be Used: Spotlights buyer dependency. Identifying high spend share categories helps purchasing managers target vendor consolidation and volume discount negotiations.

- Formula: Spend Share % = Supplier/Category Spend ÷ Total Spend × 100

Average Purchase Price

- Definition: The total procurement value spent on an item category divided by the volume purchased.

- Intuitive Explanation and How It Can Be Used: Sets a baseline price metric. It is used to track cost inflation and spot inconsistencies where the company pays different prices for the same item.

- Formula: Average Purchase Price = Total Purchase Value ÷ Units Purchased

Price Variance

- Definition: The absolute difference between the actual price paid for an item and a benchmark baseline or reference price.

- Intuitive Explanation and How It Can Be Used: Measures price discipline. Positive variance indicates overpaying, while negative variance measures purchasing team negotiation success.

- Formula: Price Variance = Actual Purchase Price − Benchmark/Reference Price

Price Variance %

- Definition: The percentage deviation of actual purchase prices from standard benchmark prices.

- Intuitive Explanation and How It Can Be Used: Standardizes price compliance tracking, allowing corporate procurement to easily monitor pricing performance across multiple departments.

- Formula: Price Variance % = (Actual Price − Benchmark Price) ÷ Benchmark Price × 100

Savings Potential

- Definition: The financial difference between current spend levels and a realistically expected or optimized cost target.

- Intuitive Explanation and How It Can Be Used: Drives strategic negotiation. Procurement should target high-spend categories with even a 2% variance over low-spend categories with a 20% variance to achieve maximum dollar savings.

- Formula: Savings Potential = Current Cost − Expected Cost

Domain 14: Manufacturing Quality, Defects & Yield

K.P.I's: Defect Rate %, Yield %, Defect Contribution %, Defect Reduction %, Cost per Good Unit

Defect Rate %

- Definition: The percentage of produced units that fail to meet quality standards.

- Intuitive Explanation and How It Can Be Used: Measures process capability and quality control. High defect rates indicate issues with machinery, raw materials, or employee execution.

- Formula: Defect Rate % = Defective Units ÷ Total Units Produced × 100

Yield %

- Definition: The percentage of total manufactured units that are acceptable and standard.

- Intuitive Explanation and How It Can Be Used: Evaluates raw material usage efficiency. Keeping this metric high minimizes waste and reduces raw material re-purchasing needs.

- Formula: Yield % = Good Units ÷ Total Units Produced × 100

Defect Contribution %

- Definition: The proportion of total defects caused by a specific type of defect or production machine.

- Intuitive Explanation and How It Can Be Used: Guides engineering interventions. It ensures technical teams focus repairs on root-cause defects that cause 80% of failures (Pareto Principle).

- Formula: Defect Contribution % = Specific Defects ÷ Total Defects × 100

Defect Reduction %

- Definition: The percentage reduction in defects between a current period and a baseline comparison period.

- Intuitive Explanation and How It Can Be Used: Tracks the effectiveness of quality assurance initiatives and machinery upgrades.

- Formula: Defect Reduction % = (Previous Defects − Current Defects) ÷ Previous Defects × 100

Cost per Good Unit

- Definition: The total production expenditure incurred divided by the volume of defect-free units produced.

- Intuitive Explanation and How It Can Be Used: The true measure of manufacturing cost efficiency. High defect counts force up the cost per good unit, directly eroding overall gross profit margin.

- Formula: Cost per Good Unit = Total Production Cost ÷ Good Units

Domain 15: Warehouse Productivity & Bottleneck Throughput

K.P.I's: Picking Productivity, Packing Productivity, Inventory Accuracy %, Dock Utilization %, Throughput, Productivity Change %

Picking Productivity

- Definition: The volume of orders or inventory units picked divided by the labor hours spent on picking.

- Intuitive Explanation and How It Can Be Used: Tracks order fulfillment speed and workforce efficiency. Low picking productivity signals layout issues or picking process bottlenecks.

- Formula: Picking Productivity = Orders/Units Picked ÷ Picking Hours

Packing Productivity

- Definition: The volume of inventory units packed divided by the labor hours spent on packing.

- Intuitive Explanation and How It Can Be Used: Measures packing line efficiency. Slow packing performance can delay shipments, harming customer fulfillment scores.

- Formula: Packing Productivity = Orders/Units Packed ÷ Packing Hours

Inventory Accuracy %

- Definition: The percentage of inventory records that match the actual physical stock held in the warehouse.

- Intuitive Explanation and How It Can Be Used: Critical for warehouse execution. Inaccurate inventory leads to picking delays, stockouts, and emergency vendor ordering.

- Formula: Inventory Accuracy % = Correct Inventory Records ÷ Total Inventory Records × 100

Dock Utilization %

- Definition: The percentage of available dock operating hours during which docks are actively occupied.

- Intuitive Explanation and How It Can Be Used: Identifies shipping and receiving bottlenecks. Very high dock utilization can lead to carrier waiting fees and delivery delays.

- Formula: Dock Utilization % = Dock Usage Time ÷ Available Dock Time × 100

Throughput

- Definition: The volume of orders successfully processed by the warehouse per unit of time.

- Intuitive Explanation and How It Can Be Used: Measures total warehouse capacity. Improving individual speeds is useless if the system's main bottleneck is left unaddressed.

- Formula: Throughput = Orders Processed ÷ Time

Productivity Change %

- Definition: The percentage difference in labor productivity between the current and a prior period.

- Intuitive Explanation and How It Can Be Used: Evaluates fulfillment center optimization success.

- Formula: Productivity Change % = (Current Productivity − Previous Productivity) ÷ Previous Productivity × 100

Domain 16: Customer Support, S.L.A & Satisfaction

K.P.I's: S.L.A Achievement %, First Contact Resolution (F.C.R) %, S.L.A Failure Rate %, Average Resolution Time, C.S.A.T %

S.L.A Achievement %

- Definition: The percentage of support tickets resolved within the contractually agreed-upon S.L.A timeframe.

- Intuitive Explanation and How It Can Be Used: Measures customer support performance and compliance. Low achievement rates lead to customer frustration and higher churn risk.

- Formula: S.L.A Achievement % = Tickets Resolved Within S.L.A ÷ Total Tickets × 100

First Contact Resolution (F.C.R) %

- Definition: The percentage of customer support tickets resolved during the very first interaction.

- Intuitive Explanation and How It Can Be Used: The ultimate driver of customer satisfaction and support team efficiency. High F.C.R reduces ticket backlog and customer frustration.

- Formula: F.C.R % = Tickets Resolved at First Contact ÷ Total Tickets × 100

S.L.A Failure Rate %

- Definition: The percentage of support tickets that breached S.L.A commitments.

- Intuitive Explanation and How It Can Be Used: Pinpoints service failures. If failures are concentrated around a specific issue type, the company should fix the underlying product defect rather than adding support staff.

- Formula: S.L.A Failure Rate % = S.L.A-Breached Tickets ÷ Total Tickets × 100

Average Resolution Time

- Definition: The average time elapsed from ticket submission to final customer resolution.

- Intuitive Explanation and How It Can Be Used: Tracks support process efficiency and agent productivity.

- Formula: Average Resolution Time = Total Resolution Time ÷ Resolved Tickets

C.S.A.T % (Customer Satisfaction)

- Definition: The percentage of surveyed customers who report satisfaction with their support experience.

- Intuitive Explanation and How It Can Be Used: Connects operational support metrics to customer sentiment. It acts as a qualitative check on support execution quality.

- Formula: C.S.A.T % = Satisfied Responses ÷ Total Responses × 100

Domain 17: Telecom Network Reliability & Outage Quality

K.P.I's: Network Availability %, Outage Rate, Average Outage Duration, Network Utilization %, Complaint Rate

Network Availability %

- Definition: The percentage of time a telecommunications network is fully operational and accessible.

- Intuitive Explanation and How It Can Be Used: Measures service uptime. Drops in availability directly generate customer complaints, and a single prolonged outage can cause serious subscriber churn.

- Formula: Network Availability % = (Total Time − Downtime) ÷ Total Time × 100

Outage Rate

- Definition: The number of network service interruptions experienced over a defined observation period.

- Intuitive Explanation and How It Can Be Used: Tracks network failure frequency, helping engineering teams identify unstable nodes and schedule preventive maintenance before widespread failure.

- Formula: Outage Rate = Number of Outages ÷ Observation Period

Average Outage Duration

- Definition: The mean duration in minutes of network service interruptions.

- Intuitive Explanation and How It Can Be Used: Measures maintenance team response speed and backup systems capability.

- Formula: Average Outage Duration = Total Outage Duration ÷ Number of Outages

Network Utilization %

- Definition: The ratio of actual network bandwidth or capacity used compared to the available capacity.

- Intuitive Explanation and How It Can Be Used: Tracks congestion. Extreme utilization at specific times indicates bottlenecks, guiding infrastructure investment.

- Formula: Network Utilization % = Actual Network Usage ÷ Available Capacity × 100

Complaint Rate (Telecom)

- Definition: The number of network-related customer complaints relative to the total subscriber base.

- Intuitive Explanation and How It Can Be Used: Connects technical performance with customer sentiment. It indicates whether network anomalies are disrupting user experience.

- Formula: Complaint Rate = Network-Related Complaints ÷ Customers × 100

Domain 18: Healthcare Patient Flow & Hospital Efficiency

K.P.I's: Average Patient Waiting Time, Bed Utilization %, Average Length of Stay (A.L.O.S), Readmission Rate %, Doctor Utilization %

Average Patient Waiting Time

- Definition: The average time patients spend waiting before receiving medical attention.

- Intuitive Explanation and How It Can Be Used: Measures clinical flow and capacity constraints. Prolonged waiting times signal staffing shortages or check-in bottleneck issues.

- Formula: Average Patient Waiting Time = Total Waiting Time ÷ Number of Patients

Bed Utilization %

- Definition: The percentage of available hospital bed capacity that is actively occupied by patients.

- Intuitive Explanation and How It Can Be Used: Measures facility utilization. Over-utilization causes delays, while under-utilization signals empty, non-revenue generating resources.

- Formula: Bed Utilization % = Occupied Bed Days ÷ Available Bed Days × 100

Average Length of Stay (A.L.O.S)

- Definition: The mean number of days inpatients remain hospitalized before discharge.

- Intuitive Explanation and How It Can Be Used: Evaluates care quality and clinical efficiency. A high A.L.O.S can block beds for emergency arrivals.

- Formula: A.L.O.S = Total Inpatient Days ÷ Number of Discharges

Readmission Rate %

- Definition: The percentage of discharged patients who are readmitted within a short timeframe (e.g., 30 days).

- Intuitive Explanation and How It Can Be Used: Measures treatment quality. High readmission rates can suggest patients are being discharged prematurely.

- Formula: Readmission Rate % = Readmitted Patients ÷ Discharged Patients × 100

Doctor Utilization %

- Definition: The percentage of available doctor shift time spent providing direct patient care.

- Intuitive Explanation and How It Can Be Used: Evaluates labor deployment. It helps medical administrators balance clinical schedules and manage burnout.

- Formula: Doctor Utilization % = Patient-Service Time ÷ Available Doctor Time × 100

Domain 19: Education Retention & Attendance

K.P.I's: Student Attendance Rate %, Pass Rate %, Student Dropout Rate %, Student Retention Rate %, Average Grade

Student Attendance Rate %

- Definition: The percentage of scheduled classes attended by students.

- Intuitive Explanation and How It Can Be Used: Tracks student commitment and serves as an early indicator for academic struggles and dropout risks.

- Formula: Student Attendance Rate % = Classes Attended ÷ Classes Scheduled × 100

Pass Rate %

- Definition: The percentage of assessed students who meet the academic passing criteria.

- Intuitive Explanation and How It Can Be Used: Evaluates teaching effectiveness and course difficulty. Low pass rates suggest teaching gaps or unbalanced exams.

- Formula: Pass Rate % = Students Passing ÷ Students Assessed × 100

Student Dropout Rate %

- Definition: The percentage of students who formally withdraw from an academic program.

- Intuitive Explanation and How It Can Be Used: Monitors student attrition. High dropout rates cause significant revenue loss and damage institutional reputation.

- Formula: Student Dropout Rate % = Students Who Dropped Out ÷ Total Students × 100

Student Retention Rate %

- Definition: The percentage of enrolled students who continue their studies from the start of the year.

- Intuitive Explanation and How It Can Be Used: Measures university engagement and program sustainability.

- Formula: Student Retention Rate % = Students Retained ÷ Students at Start × 100

Average Grade

- Definition: The arithmetic mean of all numeric grades awarded to students.

- Intuitive Explanation and How It Can Be Used: Provides a baseline academic score, allowing educational departments to compare the performance of different courses or semesters.

- Formula: Average Grade = Total Grades ÷ Number of Students

Domain 20: Hotel Revenue, Occupancy & Pricing

K.P.I's: Occupancy Rate %, Average Daily Rate (A.D.R), RevPAR, Cancellation Rate %, Revenue Loss from Cancellations

Occupancy Rate %

- Definition: The percentage of available hotel rooms actively sold during a specific period.

- Intuitive Explanation and How It Can Be Used: Tracks raw property utilization. High occupancy with very low pricing can generate less profit than moderate occupancy with premium pricing.

- Formula: Occupancy Rate % = Rooms Sold ÷ Rooms Available × 100

Average Daily Rate (A.D.R)

- Definition: The average revenue generated per individual occupied room sold.

- Intuitive Explanation and How It Can Be Used: Measures pricing power. A.D.R must be paired with occupancy to evaluate total room revenue performance.

- Formula: A.D.R = Room Revenue ÷ Rooms Sold

RevPAR (Revenue per Available Room)

- Definition: The total room revenue divided by the total available rooms, or A.D.R multiplied by the occupancy rate.

- Intuitive Explanation and How It Can Be Used: The primary financial benchmark for the hospitality industry, indicating how effectively the hotel yields revenue from its entire inventory.

- Formula: RevPAR = Room Revenue ÷ Rooms Available [Or: RevPAR = A.D.R × (Occupancy Rate % ÷ 100)]

Cancellation Rate %

- Definition: The percentage of total room reservations cancelled prior to check-in.

- Intuitive Explanation and How It Can Be Used: Measures booking stability. High cancellation rates indicate the need for stricter deposit policies or flexible pricing adjustments.

- Formula: Cancellation Rate % = Cancelled Bookings ÷ Total Bookings × 100

Revenue Loss from Cancellations

- Definition: The total expected revenue lost due to cancelled bookings.

- Intuitive Explanation and How It Can Be Used: Quantifies cancellation leakages. It prompts revenue managers to implement overbooking algorithms or promotion policies.

- Formula: Revenue Loss from Cancellations = Cancelled Room Nights × Expected Room Rate

Domain 21: Insurance Claims & Fraud Risk

K.P.I's: Claim Frequency, Average Claim Cost, Loss Ratio %, Average Settlement Time, Investigation Rate %

Claim Frequency

- Definition: The average number of insurance claims filed per active policy.

- Intuitive Explanation and How It Can Be Used: Measures portfolio claim volume, helping actuaries adjust premium pricing according to risk.

- Formula: Claim Frequency = Number of Claims ÷ Number of Policies

Average Claim Cost

- Definition: The average payout amount paid per insurance claim.

- Intuitive Explanation and How It Can Be Used: Tracks claim severity. Extreme claim severity in a segment requires policy coverage redesign or underwriting adjustments.

- Formula: Average Claim Cost = Total Claim Cost ÷ Number of Claims

Loss Ratio %

- Definition: The total claims incurred divided by the premium earned over the period.

- Intuitive Explanation and How It Can Be Used: The core underwriting profitability metric. A loss ratio near or above 100% means the firm is paying more in claims than it earns in premium.

- Formula: Loss Ratio % = Claims Incurred ÷ Premium Earned × 100

Average Settlement Time

- Definition: The average number of days required to settle an insurance claim.

- Intuitive Explanation and How It Can Be Used: Measures claim processing speed. Slow processing irritates customers, while overly rapid processing can compromise fraud checks.

- Formula: Average Settlement Time = Total Settlement Days ÷ Settled Claims

Investigation Rate %

- Definition: The percentage of claims referred to and investigated for potential fraud.

- Intuitive Explanation and How It Can Be Used: Reflects claim auditing intensity. It must be balanced to ensure real fraud is detected without creating customer friction.

- Formula: Investigation Rate % = Claims Investigated ÷ Total Claims × 100

Domain 22: Fraud Detection & Transaction Risk

K.P.I's: Suspicious Transaction Rate %, False Positive Rate %, Alert Rate %, Investigation Rate %

Suspicious Transaction Rate %

- Definition: The percentage of transactions flagged as potentially fraudulent relative to total transactions.

- Intuitive Explanation and How It Can Be Used: Monitors baseline security risk exposure on a payment platform.

- Formula: Suspicious Transaction Rate % = Suspicious Transactions ÷ Total Transactions × 100

False Positive Rate %

- Definition: The percentage of generated risk alerts that are found to be legitimate, non-fraudulent events.

- Intuitive Explanation and How It Can Be Used: Measures alert system quality. An overly sensitive system creates massive false positives, overwhelming compliance investigators and degrading user experience.

- Formula: False Positive Rate % = False Positive Alerts ÷ Total Alerts × 100

Alert Rate %

- Definition: The percentage of transactions triggering a system security alert.

- Intuitive Explanation and How It Can Be Used: Tracks security alert volume. It is used to balance system rules with investigative resource capacity.

- Formula: Alert Rate % = Alerts ÷ Total Transactions × 100

Investigation Rate % (Fraud)

- Definition: The percentage of suspicious transactions actively investigated by security analysts.

- Intuitive Explanation and How It Can Be Used: Tracks security audit coverage, helping risk managers evaluate if compliance teams have sufficient headcount to manage the alert load.

- Formula: Investigation Rate % (Fraud) = Investigated Transactions ÷ Suspicious Transactions × 100

Domain 23: saas Revenue, Churn & Expansion Growth

K.P.I's: M.R.R Growth %, A.R.R, Churn Rate %, Retention Rate %, Expansion Revenue, Net Revenue Retention (N.R.R) %

M.R.R Growth %

- Definition: The percentage change in Monthly Recurring Revenue between the current and previous month.

- Intuitive Explanation and How It Can Be Used: Evaluates recurring revenue velocity. It must be decomposed into new, expansion, contraction, and churn elements to understand SaaS health.

- Formula: M.R.R Growth % = (Current M.R.R − Previous M.R.R) ÷ Previous M.R.R × 100

A.R.R (Annual Recurring Revenue)

- Definition: Monthly Recurring Revenue projected over an entire year.

- Intuitive Explanation and How It Can Be Used: Measures the annualized baseline scale of the recurring revenue model.

- Formula: A.R.R = M.R.R × 12

Churn Rate % (SaaS)

- Definition: The percentage of subscribers lost at the start of the period who cancel during the period.

- Intuitive Explanation and How It Can Be Used: The primary health metric for SaaS. High customer churn rapidly undermines expensive sales efforts.

- Formula: Churn Rate % (SaaS) = Churned Customers ÷ Customers at Start × 100

Retention Rate % (SaaS)

- Definition: The percentage of customers remaining subscribed over the period.

- Intuitive Explanation and How It Can Be Used: Measures customer subscription stability and customer loyalty.

- Formula: Retention Rate % (SaaS) = Retained Customers ÷ Customers at Start × 100

Expansion Revenue

- Definition: The additional recurring revenue generated from existing customers via upsells or cross-sells.

- Intuitive Explanation and How It Can Be Used: The primary engine for negative churn. Generating expansion revenue is significantly cheaper than acquiring new logos.

- Formula: Expansion Revenue = Upsell Revenue + Cross-sell Revenue

Net Revenue Retention (N.R.R) %

- Definition: The percentage of recurring revenue retained from existing customers after accounting for upgrades, downgrades, and churn.

- Intuitive Explanation and How It Can Be Used: Indicates whether the customer base is expanding in value on its own. An N.R.R above 100% means the business grows even without acquiring new customers.

- Formula: N.R.R % = (Beginning Revenue − Churned Revenue − Contraction Revenue + Expansion Revenue) ÷ Beginning Revenue × 100

Domain 24: Product Pricing, Elasticity & Discounts

K.P.I's: Profit Margin %, Discount %, Price Elasticity, Revenue, Profit

Profit Margin % (Pricing)

- Definition: The percentage of selling price that remains as profit after accounting for product costs.

- Intuitive Explanation and How It Can Be Used: Tracks pricing profitability. High volume is useless if aggressive discounting destroys the product's margin.

- Formula: Profit Margin % = Profit ÷ Revenue × 100

Discount %

- Definition: The percentage reduction applied to a product's original list price.

- Intuitive Explanation and How It Can Be Used: Measures discounting intensity. It is used to monitor margin erosion and identify product categories with high promotional dependency.

- Formula: Discount % = (List Price − Selling Price) ÷ List Price × 100

Price Elasticity

- Definition: The ratio of the percentage change in quantity demanded to the percentage change in selling price.

- Intuitive Explanation and How It Can Be Used: Determines pricing sensitivity. If demand is highly elastic, raising prices can cause a massive sales drop, reducing overall revenue.

- Formula: Price Elasticity = % Change in Quantity Demanded ÷ % Change in Price

Revenue

- Definition: The total financial volume generated by product sales.

- Intuitive Explanation and How It Can Be Used: Tracks product market share and scale.

- Formula: Revenue = Price × Quantity Sold

Profit

- Definition: The net financial contribution of product sales.

- Intuitive Explanation and How It Can Be Used: Indicates if the pricing strategy is economically viable after product costs are subtracted.

- Formula: Profit = Revenue − Total Cost

Domain 25: Demand Forecasting & Seasonal Planning

K.P.I's: Forecast Error, Absolute Error, Forecast Accuracy %, Demand Growth %, Promotional Uplift %

Forecast Error

- Definition: The difference between actual observed demand and forecast demand.

- Intuitive Explanation and How It Can Be Used: Measures forecasting biases. Consistently positive forecast error leads to excess stock, while negative errors lead to stockouts.

- Formula: Forecast Error = Actual Demand − Forecast Demand

Absolute Error

- Definition: The absolute difference between the actual observed demand and the predicted forecast demand.

- Intuitive Explanation and How It Can Be Used: Measures the absolute scale of forecasting errors, ignoring bias direction, to determine total planning volatility.

- Formula: Absolute Error = |Actual − Forecast|

Forecast Accuracy %

- Definition: The standardized percentage accuracy of forecasting models.

- Intuitive Explanation and How It Can Be Used: Critical for replenishment planning. Unstable demand products require safety-stock planning to compensate for low accuracy.

- Formula: Forecast Accuracy % = (1 − Absolute Error ÷ Actual Demand) × 100

Demand Growth %

- Definition: The percentage change in customer demand compared to a previous baseline.

- Intuitive Explanation and How It Can Be Used: Tracks product adoption trends, helping supply chain teams adapt overall capacity.

- Formula: Demand Growth % = (Current Demand − Previous Demand) ÷ Previous Demand × 100

Promotional Uplift %

- Definition: The percentage increase in demand during a promotional period compared to baseline demand.

- Intuitive Explanation and How It Can Be Used: Measures marketing campaign effectiveness and helps warehouse managers plan extra shipping capacity during sales.

- Formula: Promotional Uplift % = (Promotional Demand − Baseline Demand) ÷ Baseline Demand × 100

Domain 26: Fleet Performance & Vehicle Utilization

K.P.I's: Vehicle Utilization %, Fuel Efficiency, Fuel Cost per Kilometer, Idle Rate %, Maintenance Cost per Vehicle, Energy Consumption

Vehicle Utilization %

- Definition: The percentage of available time a fleet vehicle is actively operating.

- Intuitive Explanation and How It Can Be Used: Tracks fleet usage. Low utilization suggests that the fleet is oversized or route scheduling is inefficient.

- Formula: Vehicle Utilization % = Actual Operating Time ÷ Available Time × 100

Fuel Efficiency

- Definition: The distance travelled by a vehicle per unit of fuel consumed.

- Intuitive Explanation and How It Can Be Used: Measures fuel usage efficiency. Tracking this helps spot poorly maintained vehicles or inefficient driver behaviors.

- Formula: Fuel Efficiency = Distance ÷ Fuel Consumed

Fuel Cost per Kilometer

- Definition: The average fuel cost incurred per kilometer travelled.

- Intuitive Explanation and How It Can Be Used: Integrates fuel efficiency with fuel prices to calculate transport cost efficiency.

- Formula: Fuel Cost per Km = Fuel Cost ÷ Distance

Idle Rate %

- Definition: The percentage of available vehicle operating time spent idling without moving.

- Intuitive Explanation and How It Can Be Used: Identifies fuel waste. High idle rates signal traffic delays or inefficient driver loading/unloading behaviors.

- Formula: Idle Rate % = Idle Time ÷ Available Operating Time × 100

Maintenance Cost per Vehicle

- Definition: The average maintenance expenditure incurred per fleet vehicle.

- Intuitive Explanation and How It Can Be Used: Measures fleet maintenance costs. Rising costs per vehicle can signal that a vehicle should be decommissioned or replaced.

- Formula: Maintenance Cost per Vehicle = Total Maintenance Cost ÷ Number of Vehicles

Energy Consumption (Fleet)

- Definition: The total energy used by a fleet relative to the distance travelled or work completed.

- Intuitive Explanation and How It Can Be Used: Evaluates aggregate fleet energy efficiency.

- Formula: Energy Consumption (Fleet) = Total Energy Used ÷ Output/Distance

Domain 27: Energy Consumption, Intensity & Reduction

K.P.I's: Energy Efficiency, Energy Intensity, Energy Cost per Unit, Energy Growth %

Energy Efficiency

- Definition: The operational output produced per unit of energy consumed.

- Intuitive Explanation and How It Can Be Used: Measures how efficiently utility inputs are transformed into operational results. Higher efficiency reduces utility expenses.

- Formula: Energy Efficiency = Output ÷ Energy Consumed

Energy Intensity

- Definition: The total amount of energy consumed per unit of operational output.

- Intuitive Explanation and How It Can Be Used: Critical for tracking resource waste. A large facility might consume the most energy simply because it produces the most; tracking intensity highlights actual process inefficiency.

- Formula: Energy Intensity = Energy Consumed ÷ Output

Energy Cost per Unit

- Definition: The energy-related cost incurred per unit of operational output.

- Intuitive Explanation and How It Can Be Used: Measures direct utility expenses associated with production.

- Formula: Energy Cost per Unit = Energy Cost ÷ Output

Energy Growth %

- Definition: The percentage change in total energy consumption compared to a historical baseline.

- Intuitive Explanation and How It Can Be Used: Monitors expansion of energy footprint.

- Formula: Energy Growth % = (Current Consumption − Previous Consumption) ÷ Previous Consumption × 100

Domain 28: Pharmaceutical Demand & Availability

K.P.I's: Demand Growth %, Profit Margin %, Stockout Rate %, Availability Rate %, Revenue per Unit

Demand Growth % (Pharma)

- Definition: The percentage change in medicine demand over time.

- Intuitive Explanation and How It Can Be Used: Tracks medicine demand growth, prompting procurement teams to secure sufficient inventory.

- Formula: Demand Growth % (Pharma) = (Current Demand − Previous Demand) ÷ Previous Demand × 100

Profit Margin % (Pharma)

- Definition: The operating profit margin achieved on medicine sales.

- Intuitive Explanation and How It Can Be Used: Determines product commercial value. High-demand medicines can have thin margins, necessitating volume optimization.

- Formula: Profit Margin % (Pharma) = Profit ÷ Revenue × 100

Stockout Rate % (Pharma)

- Definition: The percentage of medicine orders that go unfulfilled due to zero stock.

- Intuitive Explanation and How It Can Be Used: Measures shortages. Shortages are critical; tracking stockouts prompts emergency purchasing to protect patient care.

- Formula: Stockout Rate % (Pharma) = Stockout Events ÷ Total Demand/Orders × 100

Availability Rate %

- Definition: The percentage of total medicine demand successfully fulfilled.

- Intuitive Explanation and How It Can Be Used: Indicates supply network completeness, ensuring high-priority medications remain available.

- Formula: Availability Rate % = Available Demand Fulfilled ÷ Total Demand × 100

Revenue per Unit (Pharma)

- Definition: The average revenue generated per individual unit of medicine sold.

- Intuitive Explanation and How It Can Be Used: Evaluates medicine pricing and helps track therapeutic pricing structures.

- Formula: Revenue per Unit (Pharma) = Revenue ÷ Units Sold

Domain 29: Property Portfolio Performance

K.P.I's: Occupancy Rate %, Vacancy Rate %, R.O.I %, Maintenance Cost per Property, Tenant Churn %, Rental Income per Occupied Unit

Occupancy Rate % (Property)

- Definition: The percentage of available property units currently leased to tenants.

- Intuitive Explanation and How It Can Be Used: Measures property utilization. High occupancy provides stable rental inflows.

- Formula: Occupancy Rate % = Occupied Units ÷ Available Units × 100

Vacancy Rate %

- Definition: The percentage of total available property units that are currently empty.

- Intuitive Explanation and How It Can Be Used: Indicates lease leakages. It prompts leasing managers to re-evaluate pricing or run promotions.

- Formula: Vacancy Rate % = Vacant Units ÷ Available Units × 100

R.O.I % (Property)

- Definition: The net return generated by a property relative to its initial investment cost.

- Intuitive Explanation and How It Can Be Used: The primary benchmark for evaluating asset success, ensuring capital is deployed into high-yield real estate investments.

- Formula: R.O.I % = (Return − Investment Cost) ÷ Investment Cost × 100

Maintenance Cost per Property

- Definition: The average maintenance and repair expenditure incurred per property asset.

- Intuitive Explanation and How It Can Be Used: Measures structural depreciation and cost control. Rising maintenance costs can ruin profit margins despite high occupancy.

- Formula: Maintenance Cost per Property = Total Maintenance Cost ÷ Number of Properties

Tenant Churn %

- Definition: The percentage of tenants who leave relative to the starting tenant count.

- Intuitive Explanation and How It Can Be Used: Measures lease stability. High tenant churn increases vacancy periods and refurbishment costs.

- Formula: Tenant Churn % = Tenants Leaving ÷ Tenants at Start × 100

Rental Income per Occupied Unit

- Definition: The average rental revenue generated per occupied unit.

- Intuitive Explanation and How It Can Be Used: Measures unit yield. Improving this helps developers boost cash flows without requiring physical expansion.

- Formula: Rental Income per Occupied Unit = Rental Income ÷ Occupied Units

Domain 30: Territory Performance & Resource Allocation

K.P.I's: Revenue per Salesperson, Revenue Density, Allocation Ratio, Opportunity Gap, Revenue Share %

Revenue per Salesperson

- Definition: The total revenue generated in a sales territory divided by the headcount of assigned salespeople.

- Intuitive Explanation and How It Can Be Used: Measures sales team productivity. Low revenue in a region can be caused by low headcount rather than poor performance.

- Formula: Revenue per Salesperson = Territory Revenue ÷ Salespeople

Revenue Density

- Definition: The total revenue generated in a territory divided by the geographic size or market size of that territory.

- Intuitive Explanation and How It Can Be Used: Evaluates geographical efficiency, helping managers identify densely lucrative regions for hub expansion.

- Formula: Revenue Density = Territory Revenue ÷ Territory Size

Allocation Ratio

- Definition: The actual sales resources allocated to a territory divided by the required or expected allocation.

- Intuitive Explanation and How It Can Be Used: Highlights resource imbalances. It identifies territories that are over-resourced or under-resourced relative to their market potential.

- Formula: Allocation Ratio = Actual Resource Allocation ÷ Required/Expected Allocation

Opportunity Gap

- Definition: The difference between the total estimated sales potential of a market and its current actual sales revenue.

- Intuitive Explanation and How It Can Be Used: Pinpoints uncaptured market opportunities, helping commercial teams prioritize rebalancing efforts.

- Formula: Opportunity Gap = Sales Potential − Current Revenue

Revenue Share % (Territory)

- Definition: The percentage contribution of a specific sales territory to total company revenue.

- Intuitive Explanation and How It Can Be Used: Identifies regional commercial dependency.

- Formula: Revenue Share % (Territory) = Territory Revenue ÷ Total Revenue × 100

Domain 31: Customer Lifetime Value & Cost of Acquisition

K.P.I's: C.L.V, C.A.C, C.L.V:C.A.C Ratio, Average Customer Value, Purchase Frequency

C.L.V (Customer Lifetime Value)

- Definition: The total net financial contribution expected from a customer over their relationship.

- Intuitive Explanation and How It Can Be Used: Dictates long-term commercial sustainability. Raising customer lifetime value stabilizes the revenue baseline.

- Formula: C.L.V = Average Customer Value × Purchase Frequency × Customer Lifespan

C.A.C (Customer Acquisition Cost)

- Definition: The total acquisition marketing expenditure divided by the volume of new customers acquired.

- Intuitive Explanation and How It Can Be Used: Tracks customer acquisition efficiency.

- Formula: C.A.C = Acquisition Spend ÷ New Customers Acquired

C.L.V:C.A.C Ratio

- Definition: The ratio of Customer Lifetime Value to Customer Acquisition Cost.

- Intuitive Explanation and How It Can Be Used: The ultimate health indicator for subscription and growth models. A ratio below 3:1 indicates a business model with poor unit economics.

- Formula: C.L.V:C.A.C = C.L.V ÷ C.A.C

Average Customer Value

- Definition: The average revenue generated per customer.

- Intuitive Explanation and How It Can Be Used: Serves as the revenue baseline, allowing sales teams to track account size.

- Formula: Average Customer Value = Customer Revenue ÷ Number of Customers

Purchase Frequency

- Definition: The average number of transactions completed per customer.

- Intuitive Explanation and How It Can Be Used: Measures repeat purchasing behaviors, helping marketing teams evaluate brand loyalty.

- Formula: Purchase Frequency = Total Purchases ÷ Number of Customers

Domain 32: Product Revenue, Profitability & Product Mix

K.P.I's: Profit, Profit Margin %, Revenue per Unit, Profit per Unit, Product Mix %, Profit Contribution %

Profit (Product)

- Definition: The revenue remaining after product-specific costs are deducted.

- Intuitive Explanation and How It Can Be Used: Measures a product's absolute contribution, preventing management from chasing high-volume, loss-making products.

- Formula: Profit = Revenue − Product Cost

Profit Margin % (Product)

- Definition: The percentage of product sales revenue converted into product profit.

- Intuitive Explanation and How It Can Be Used: Evaluates product margin efficiency, pointing out opportunities for pricing or repricing actions.

- Formula: Profit Margin % = Profit ÷ Revenue × 100

Revenue per Unit (Product)

- Definition: The average selling price generated per unit sold.

- Intuitive Explanation and How It Can Be Used: Monitors pricing and discount effects on product categories.

- Formula: Revenue per Unit = Revenue ÷ Units Sold

Profit per Unit

- Definition: The average profit contribution generated per unit sold.

- Intuitive Explanation and How It Can Be Used: Guides sales prioritization, directing sales teams to push high-margin individual units.

- Formula: Profit per Unit = Profit ÷ Units Sold

Product Mix %

- Definition: The percentage contribution of a specific product's revenue to total portfolio revenue.

- Intuitive Explanation and How It Can Be Used: Monitors portfolio balance. An over-reliance on a single product can increase market disruption risks.

- Formula: Product Mix % = Product Revenue ÷ Total Revenue × 100

Profit Contribution %

- Definition: The percentage contribution of a specific product's profit to total portfolio profit.

- Intuitive Explanation and How It Can Be Used: Identifies core value drivers, allowing managers to allocate promotional efforts.

- Formula: Profit Contribution % = Product Profit ÷ Total Profit × 100

Domain 33: Procurement Spend & Cycle-time Bottlenecks

K.P.I's: O.T.I.F %, Average Lead Time, Supplier Defect Rate %, P.O Cycle Time, Average Processing Time, Delay Rate %

O.T.I.F % (Procurement)

- Definition: The percentage of vendor purchase orders delivered on time and in full.

- Intuitive Explanation and How It Can Be Used: Evaluates vendor reliability. High-cost vendors with high O.T.I.F are often cheaper than cheap vendors who cause downstream stockouts.

- Formula: O.T.I.F % = Orders Delivered On Time and In Full ÷ Total Orders × 100

Average Lead Time (Procurement)

- Definition: The average duration elapsed between purchase order creation and receiving stock.

- Intuitive Explanation and How It Can Be Used: Governs safety-stock levels. Long lead times require higher cash investment in inventory.

- Formula: Average Lead Time = Total Lead Time ÷ Number of Orders

Supplier Defect Rate %

- Definition: The percentage of deliveries from a supplier that contain defective items.

- Intuitive Explanation and How It Can Be Used: Measures incoming quality control, triggering corrective actions before defective parts reach production lines.

- Formula: Supplier Defect Rate % = Defective Deliveries ÷ Total Deliveries × 100

P.O Cycle Time

- Definition: The duration elapsed from purchase order creation to P.O completion.

- Intuitive Explanation and How It Can Be Used: Identifies internal procurement delays, indicating bottlenecks in corporate approval or processing stages.

- Formula: P.O Cycle Time = P.O Completion Date − P.O Creation Date

Average Processing Time

- Definition: The average time spent actively processing a purchase order.

- Intuitive Explanation and How It Can Be Used: Monitors internal procurement efficiency.

- Formula: Average Processing Time = Total Processing Time ÷ Number of P.O's

Delay Rate % (Procurement)

- Definition: The percentage of purchase orders that exceed their expected delivery schedules.

- Intuitive Explanation and How It Can Be Used: Tracks vendor delays, signaling potential operational disruption risks.

- Formula: Delay Rate % = Delayed P.O's ÷ Total P.O's × 100

Domain 34: Sales Pipeline, Conversion & Forecast Accuracy

K.P.I's: Lead-to-Opportunity Conversion %, Win Rate %, Average Deal Size, Sales Cycle, Pipeline Coverage, Forecast Accuracy %

Lead-to-Opportunity Conversion %

- Definition: The percentage of leads that qualify as opportunities.

- Intuitive Explanation and How It Can Be Used: Measures sales team screening effectiveness and marketing lead relevance.

- Formula: Conversion % = Qualified Opportunities ÷ Leads × 100

Win Rate %

- Definition: The percentage of closed opportunities that are successfully won.

- Intuitive Explanation and How It Can Be Used: Evaluates sales closing effectiveness and product competitiveness.

- Formula: Win Rate % = Won Deals ÷ Total Closed Opportunities × 100

Average Deal Size

- Definition: The average revenue generated per won deal.

- Intuitive Explanation and How It Can Be Used: Evaluates sales size and deal scope, helping managers track account values.

- Formula: Average Deal Size = Total Won Revenue ÷ Won Deals

Sales Cycle

- Definition: The average number of days required to close a won opportunity.

- Intuitive Explanation and How It Can Be Used: Measures sales velocity, indicating where complex closing steps drag out conversions.

- Formula: Average Sales Cycle = Total Days to Close ÷ Won Deals

Pipeline Coverage

- Definition: The ratio of total pipeline value to the company's sales target.

- Intuitive Explanation and How It Can Be Used: Determines target feasibility. A pipeline coverage of 3x or 4x is typically required to confidently hit revenue targets.

- Formula: Pipeline Coverage = Pipeline Value ÷ Sales Target

Forecast Accuracy % (Sales)

- Definition: The percentage accuracy of sales forecast projections.

- Intuitive Explanation and How It Can Be Used: Critical for budget and strategic planning. Low accuracy ruins inventory and staffing planning.

- Formula: Forecast Accuracy % = 1 − |Actual Revenue − Forecast Revenue| ÷ Actual Revenue

Domain 35: app Engagement & Cohort Retention

K.P.I's: Activation Rate %, D.A.U/M.A.U %, Feature Adoption %, Retention Rate %, Churn Rate %

Activation Rate %

- Definition: The percentage of new app users who reach a defined activation milestone.

- Intuitive Explanation and How It Can Be Used: Measures onboarding success. Acquiring users is useless if they never activate; low activation highlights early product friction.

- Formula: Activation Rate % = Activated Users ÷ New Users × 100

D.A.U/M.A.U %

- Definition: The ratio of Daily Active Users to Monthly Active Users.

- Intuitive Explanation and How It Can Be Used: Tracks product stickiness and daily usage habits, which is crucial for ad-driven and engagement-heavy software.

- Formula: D.A.U/M.A.U % = Daily Active Users ÷ Monthly Active Users × 100

Feature Adoption %

- Definition: The percentage of active users who actively use a specific app feature.

- Intuitive Explanation and How It Can Be Used: Helps product teams prioritize feature improvements or sunset complex, unused features.

- Formula: Feature Adoption % = Users Using Feature ÷ Active Users × 100

Retention Rate % (Cohort)

- Definition: The percentage of users in an acquisition cohort who return to the app after a specific time.

- Intuitive Explanation and How It Can Be Used: Measures long-term engagement quality.

- Formula: Retention % = Users Returning After Period ÷ Users in Original Cohort × 100

Churn Rate % (App)

- Definition: The percentage of users who stop interacting with the app.

- Intuitive Explanation and How It Can Be Used: Highlights early loss of users.

- Formula: Churn % = Users Who Left ÷ Users at Start × 100

Domain 36: Project Portfolio Delivery & Resource Usage

K.P.I's: Project Completion %, Schedule Variance, Budget Variance, Budget Variance %, Resource Utilization %, On-Time Delivery %

Project Completion %

- Definition: The percentage of planned project work that has been completed.

- Intuitive Explanation and How It Can Be Used: Evaluates project progress and delivery milestones.

- Formula: Completion % = Completed Work ÷ Total Planned Work × 100

Schedule Variance

- Definition: The difference between the actual project completion date and the planned schedule.

- Intuitive Explanation and How It Can Be Used: Measures timeline slippage, helping project managers adjust resource allocation before deadlines are breached.

- Formula: Schedule Variance = Actual Completion − Planned Completion

Budget Variance (Project)

- Definition: The absolute difference between the actual project cost incurred and the budgeted cost.

- Intuitive Explanation and How It Can Be Used: Measures project cost containment, alerting P.M.O's to scope changes or cost overruns.

- Formula: Budget Variance = Actual Cost − Budgeted Cost

Budget Variance % (Project)

- Definition: The percentage deviation of actual project costs relative to the budget.

- Intuitive Explanation and How It Can Be Used: Standardizes cost variances across diverse project sizes.

- Formula: Budget Variance % = (Actual Cost − Budget) ÷ Budget × 100

Resource Utilization %

- Definition: The percentage of available project resource capacity actively consumed by work.

- Intuitive Explanation and How It Can Be Used: Measures labor or hardware efficiency. Extreme utilization causes employee burnout, while under-utilization wastes capital.

- Formula: Resource Utilization % = Actual Resource Usage ÷ Available Resource Capacity × 100

On-Time Delivery % (Project)

- Definition: The percentage of projects delivered on or before scheduled dates.

- Intuitive Explanation and How It Can Be Used: Evaluates P.M.O execution and organizational delivery consistency.

- Formula: On-Time % = Projects Delivered On Time ÷ Completed Projects × 100

Domain 37: Budgeting & Forecast Variance Analysis

K.P.I's: Budget Variance, Budget Variance %, Forecast Variance, Revenue Growth %, Forecast Accuracy %

Budget Variance (Finance)

- Definition: The difference between actual financial outcomes and the set budget.

- Intuitive Explanation and How It Can Be Used: Tracks budget execution across departments.

- Formula: Variance = Actual − Budget

Budget Variance % (Finance)

- Definition: The percentage difference of actual performance relative to the budget.

- Intuitive Explanation and How It Can Be Used: Standardizes budget oversight for corporate finance teams.

- Formula: Variance % = (Actual − Budget) ÷ Budget × 100

Forecast Variance

- Definition: The difference between the updated forecast and the original budget.

- Intuitive Explanation and How It Can Be Used: Monitors updates in financial trajectories, indicating whether year-end targets are realistic.

- Formula: Forecast Variance = Forecast − Budget

Revenue Growth % (Finance)

- Definition: The percentage growth of financial revenues over a prior baseline.

- Intuitive Explanation and How It Can Be Used: Tracks revenue expansion.

- Formula: Growth % = (Current Revenue − Previous Revenue) ÷ Previous Revenue × 100

Forecast Accuracy % (Finance)

- Definition: The percentage accuracy of updated financial forecasts.

- Intuitive Explanation and How It Can Be Used: Evaluates modeling capabilities and business planning quality.

- Formula: Forecast Accuracy % = (1 − |Actual − Forecast| ÷ Actual) × 100

Domain 38: Subscription Pricing Plans & Upgrade Behavior

K.P.I's: arpu, Upgrade Rate %, Downgrade Rate %, Plan Churn %, Net Plan Movement, Plan Revenue Growth %

arpu (Average Revenue per User)

- Definition: The average subscription revenue generated per subscriber.

- Intuitive Explanation and How It Can Be Used: The primary pricing yield metric. It tells product teams if users are adopting higher-tier plans.

- Formula: arpu = Subscription Revenue ÷ Average Subscribers

Upgrade Rate %

- Definition: The percentage of starting subscribers who upgrade to a more valuable plan.

- Intuitive Explanation and How It Can Be Used: Measures customer expansion and pricing tier success.

- Formula: Upgrade Rate % = Customers Upgrading ÷ Customers at Start × 100

Downgrade Rate %

- Definition: The percentage of starting subscribers who downgrade to a lower-tier plan.

- Intuitive Explanation and How It Can Be Used: Measures product contraction or price sensitivity, prompting product managers to review features on premium tiers.

- Formula: Downgrade Rate % = Customers Downgrading ÷ Customers at Start × 100

Plan Churn %

- Definition: The percentage of subscribers on a specific pricing plan who cancel.

- Intuitive Explanation and How It Can Be Used: Highlights plan-specific failures, indicating which plans are uncompetitive.

- Formula: Plan Churn % = Customers Leaving Plan ÷ Customers at Start of Plan × 100

Net Plan Movement

- Definition: The absolute net movement of subscribers between plans.

- Intuitive Explanation and How It Can Be Used: Tracks whether customer cohorts are migrating upward or downward in value over time.

- Formula: Net Movement = Upgrades − Downgrades

Plan Revenue Growth %

- Definition: The percentage growth of recurring revenue within a specific plan tier.

- Intuitive Explanation and How It Can Be Used: Monitors pricing tier performance over time.

- Formula: Growth % = (Current Plan Revenue − Previous Plan Revenue) ÷ Previous Plan Revenue × 100

Domain 39: Website Digital Funnel & Acquisition Costs

K.P.I's: C.T.R %, Lead Conversion %, Customer Conversion %, C.P.L, C.A.C, Channel R.O.I %

C.T.R % (Click-Through Rate)

- Definition: The percentage of ad impressions that result in user clicks.

- Intuitive Explanation and How It Can Be Used: Measures ad creative and message relevance.

- Formula: C.T.R % = Clicks ÷ Impressions × 100

Lead Conversion %

- Definition: The percentage of website visitors who are successfully converted into leads.

- Intuitive Explanation and How It Can Be Used: Measures website landing page effectiveness.

- Formula: Lead Conversion % = Leads ÷ Visitors × 100

Customer Conversion %

- Definition: The percentage of leads who successfully purchase and become customers.

- Intuitive Explanation and How It Can Be Used: Measures sales follow-up and checkout funnel effectiveness.

- Formula: Customer Conversion % = Customers ÷ Leads × 100

C.P.L (Cost per Lead)

- Definition: The marketing spend divided by generated leads.

- Intuitive Explanation and How It Can Be Used: Measures lead generation cost efficiency.

- Formula: C.P.L = Marketing Spend ÷ Leads

C.A.C (Customer Acquisition Cost)

- Definition: The marketing spend divided by new customer volume.

- Intuitive Explanation and How It Can Be Used: Evaluates client acquisition cost efficiency.

- Formula: C.A.C = Marketing Spend ÷ Customers Acquired

Channel R.O.I %

- Definition: The percentage financial return achieved on a marketing channel relative to its spend.

- Intuitive Explanation and How It Can Be Used: Dictates campaign budget reallocation, ensuring resources are shifted to high-yield channels.

- Formula: R.O.I % = (Attributed Revenue − Marketing Spend) ÷ Marketing Spend × 100

Domain 40: E-commerce Discounting & Sentiment

K.P.I's: Average Discount, Total Discount, Positive Feedback %, Negative Feedback %, Neutral Feedback %, Sentiment Share %

Average Discount

- Definition: The average discount amount applied to transactions.

- Intuitive Explanation and How It Can Be Used: Measures discounting trends across products or categories. Extremely high discounts on popular categories can indicate over-promotional risks.

- Formula: Average Discount = Total Discount for Category ÷ Number of Transactions

Total Discount

- Definition: The total financial value of discounts granted.

- Intuitive Explanation and How It Can Be Used: Quantifies total revenue sacrificed to drive volume, allowing finance teams to calculate promotional costs.

- Formula: Total Discount = Σ Discount

Positive Feedback %

- Definition: The percentage of customer reviews classified as positive.

- Intuitive Explanation and How It Can Be Used: Measures customer satisfaction and brand loyalty.

- Formula: Positive Feedback % = Positive Feedback ÷ Total Feedback × 100

Negative Feedback %

- Definition: The percentage of customer reviews classified as negative.

- Intuitive Explanation and How It Can Be Used: Highlights operational failure rates and points out areas for immediate quality improvement.

- Formula: Negative Feedback % = Negative Feedback ÷ Total Feedback × 100

Neutral Feedback %

- Definition: The percentage of customer reviews classified as neutral.

- Intuitive Explanation and How It Can Be Used: Identifies indifferent customer segments.

- Formula: Neutral Feedback % = Neutral Feedback ÷ Total Feedback × 100

Sentiment Share %

- Definition: The proportion of total customer feedback that falls within a specific sentiment category.

- Intuitive Explanation and How It Can Be Used: Tracks brand perception over time.

- Formula: Sentiment Share % = Feedback in Sentiment Category ÷ Total Feedback × 100

Domain 41: E-commerce Revenue & Product Sales

K.P.I's: Revenue per Transaction, Total Revenue, Product Revenue, Category Revenue, Sales Volume

Revenue per Transaction

- Definition: The net revenue generated per online checkout transaction.

- Intuitive Explanation and How It Can Be Used: Represents individual cart values after discount deductions.

- Formula: Revenue = (Price × Quantity) − Discount

Total Revenue (E-Commerce)

- Definition: The aggregate net revenue generated across all online transactions.

- Intuitive Explanation and How It Can Be Used: Measures top-line e-commerce scale.

- Formula: Total Revenue = Σ Revenue

Product Revenue

- Definition: The sum of net transaction revenue generated by a specific product.

- Intuitive Explanation and How It Can Be Used: Identifies top-performing products, helping supply chain teams prioritize inventory.

- Formula: Product Revenue = Σ Revenue for Product

Category Revenue

- Definition: The sum of net transaction revenue generated within a product category.

- Intuitive Explanation and How It Can Be Used: Identifies high-performing categories, guiding marketing spend.

- Formula: Category Revenue = Σ Revenue for Category

Sales Volume

- Definition: The total physical quantity of products sold.

- Intuitive Explanation and How It Can Be Used: Tracks physical demand volumes, separate from price distortions.

- Formula: Sales Volume = Σ Quantity

Domain 42: Pricing Discount Strategy

K.P.I's: Discount Percentage, Profit, Profit Margin %, Win Rate %

Discount Percentage

- Definition: The discount amount divided by the original list price.

- Intuitive Explanation and How It Can Be Used: Measures pricing markdown levels, tracking if heavy discounting is eroding core product margins.

- Formula: Discount % = Discount Amount ÷ List Price × 100

Profit (Pricing)

- Definition: The revenue generated minus product costs.

- Intuitive Explanation and How It Can Be Used: Tracks absolute profit contribution across discount levels.

- Formula: Profit = Revenue − Cost

Profit Margin % (Pricing)

- Definition: The profit margin efficiency ratio under pricing adjustments.

- Intuitive Explanation and How It Can Be Used: Helps identify discount levels that optimize absolute profitability.

- Formula: Profit Margin % = Profit ÷ Revenue × 100

Win Rate % (Pricing)

- Definition: The percentage of commercial deals successfully won.

- Intuitive Explanation and How It Can Be Used: Measures if higher discounts are driving higher win rates.

- Formula: Win Rate % = Won Deals ÷ Total Closed Deals × 100

Domain 43: Telecom Customer Churn & Segment Retention

K.P.I's: Churn Rate %, Retention Rate %, Segment Churn %

Churn Rate % (Telecom)

- Definition: The percentage of subscribers lost over total active customers.

- Intuitive Explanation and How It Can Be Used: Tracks customer loss velocity, allowing retention teams to launch targeted re-engagement campaigns.

- Formula: Churn Rate % = Churned Customers ÷ Total Customers × 100

Retention Rate % (Telecom)

- Definition: The percentage of telecom subscribers who remain with the network.

- Intuitive Explanation and How It Can Be Used: Measures subscriber loyalty and customer relationship value.

- Formula: Retention Rate % = Retained Customers ÷ Total Customers × 100

Segment Churn % (Telecom)

- Definition: Churn rate calculated for specific telecom pricing plans or customer cohorts.

- Intuitive Explanation and How It Can Be Used: Pinpoints uncompetitive telecom plans or regions with weak service quality.

- Formula: Segment Churn % = Churned Customers in Segment ÷ Total Customers in Segment × 100

Domain 44: Manufacturing Capacity Planning

K.P.I's: Capacity Utilization %, Capacity Gap, Capacity Shortfall, Underutilization %

Capacity Utilization %

- Definition: The percentage of available production capacity actively used.

- Intuitive Explanation and How It Can Be Used: Tracks manufacturing asset efficiency. Under-utilization signals wasted capital, while extreme utilization can cause bottlenecks.

- Formula: Capacity Utilization % = Actual Production ÷ Available Capacity × 100

Capacity Gap

- Definition: The difference between available production capacity and actual customer demand.

- Intuitive Explanation and How It Can Be Used: Evaluates planning alignment.

- Formula: Capacity Gap = Available Capacity − Demand

Capacity Shortfall

- Definition: The volume of demand that exceeds available capacity.

- Intuitive Explanation and How It Can Be Used: Measures potential lost sales due to capacity constraints, signaling the need for shift additions or plant expansions.

- Formula: Capacity Shortfall = Demand − Available Capacity

Underutilization %

- Definition: The percentage of production capacity that remains unused.

- Intuitive Explanation and How It Can Be Used: Measures manufacturing slack.

- Formula: Underutilization % = 100 − Capacity Utilization %

Domain 45: Enterprise Risk Monitoring

K.P.I's: Total Risk Exposure, Risk Score, High-Risk Rate %

Total Risk Exposure

- Definition: The risk exposure probability multiplied by financial consequence, integrated across risk categories.

- Intuitive Explanation and How It Can Be Used: Prioritizes risk based on financial scale.

- Formula: Risk Exposure = Probability × Impact

Risk Score

- Definition: A combined risk index of threat likelihood and business impact.

- Intuitive Explanation and How It Can Be Used: Helps risk teams classify risk priorities.

- Formula: Risk Score = Likelihood × Impact

High-Risk Rate %

- Definition: The percentage of corporate risks classified as high-severity.

- Intuitive Explanation and How It Can Be Used: Provides an executive view of company risk posture.

- Formula: High-Risk Rate % = High-Risk Items ÷ Total Risk Items × 100

Domain 46: Complaint S.L.A & Resolution Efficiency

K.P.I's: S.L.A Compliance %, Complaint Rate, Average Resolution Time, Recurring Complaint Rate %

S.L.A Compliance %

- Definition: The percentage of customer complaints resolved within contractual S.L.A targets.

- Intuitive Explanation and How It Can Be Used: Tracks complaint management speed and service compliance.

- Formula: S.L.A Compliance % = Complaints Resolved Within S.L.A ÷ Total Resolved Complaints × 100

Complaint Rate

- Definition: The number of customer complaints divided by total transactions or customers.

- Intuitive Explanation and How It Can Be Used: Monitors transaction friction trends.

- Formula: Complaint Rate = Complaints ÷ Total Transactions/Customers × 100

Average Resolution Time (Complaints)

- Definition: The average time spent resolving a complaint.

- Intuitive Explanation and How It Can Be Used: Measures customer support efficiency.

- Formula: Average Resolution Time = Total Resolution Time ÷ Resolved Complaints

Recurring Complaint Rate %

- Definition: The percentage of complaints that represent recurring issues.

- Intuitive Explanation and How It Can Be Used: Tracks problem recurrence. A high rate indicates failure to address the root-cause process failure.

- Formula: Recurring Complaint Rate % = Recurring Complaints ÷ Total Complaints × 100

Domain 47: Retail Loyalty Program Adoption

K.P.I's: Loyalty Adoption Rate %, Average Order Value (A.O.V), Purchase Frequency, Loyalty Customer Revenue Share %

Loyalty Adoption Rate %

- Definition: The percentage of eligible customers who enroll in the loyalty program.

- Intuitive Explanation and How It Can Be Used: Measures loyalty program adoption. Low adoption rates indicate weak loyalty offers.

- Formula: Adoption % = Loyalty Members ÷ Total Eligible Customers × 100

Average Order Value (A.O.V - Loyalty)

- Definition: The average revenue generated per order.

- Intuitive Explanation and How It Can Be Used: Helps compare cart sizes between loyalty and non-loyalty customers.

- Formula: A.O.V = Total Revenue ÷ Number of Orders

Purchase Frequency (Loyalty)

- Definition: The average number of purchases completed per customer.

- Intuitive Explanation and How It Can Be Used: Measures repeat transactions.

- Formula: Purchase Frequency = Total Orders ÷ Number of Customers

Loyalty Customer Revenue Share %

- Definition: The percentage of total company revenue generated by loyalty program members.

- Intuitive Explanation and How It Can Be Used: Evaluates loyalty program commercial impact.

- Formula: Revenue Share % = Loyalty Customer Revenue ÷ Total Revenue × 100

Domain 48: Market Basket Analysis

K.P.I's: Basket Value

Basket Value

- Definition: The average financial value of items purchased together in a single checkout basket.

- Intuitive Explanation and How It Can Be Used: Tracks retail cross-selling and bundling success. High product affinities help managers design high-value product bundles.

- Formula: Basket Value = Sum of Basket Transaction Values ÷ Number of Transactions