Supply Chain Efficiency Index
Also known as: Supply Chain Performance Index, SC Efficiency
Measures the effectiveness of the supply chain in converting inputs into outputs with minimal waste and delays. It evaluates the balance between supply chain costs and service levels.
Business Use Case
Executives use this index to identify inefficiencies in the supply chain and make strategic decisions to optimize operations and reduce costs.
Business Criticality
High
Journey / Navigation Area
Generic
Owning Function
Data Architecture Team
Scope
Global
Formula
(Total Output Value / Total Input Cost) × 100Calculation Notes
1️⃣ Exclude returns from total output value. 2️⃣ Exclude defective items from total output value. 3️⃣ Include only direct supply chain costs in total input cost. 4️⃣ Calculate total output value after exclusions. 5️⃣ Calculate total input cost based on direct costs only.
Technical Details
Events
SQL Queries
Google Analytics 4 (BigQuery)
-- ==========================================
-- 1. GOOGLE BIGQUERY SQL
-- ==========================================
SELECT
warehouse_id,
SUM(CASE WHEN status = 'delivered' THEN 1 ELSE 0 END) / COUNT(*) AS efficiency_index
FROM
`your-project.erp.warehouse_logs`
WHERE
event_date BETWEEN '2023-01-01' AND '2023-12-31'
GROUP BY
warehouse_idAdobe Experience Platform (AEP Query Service)
-- ==========================================
-- 2. ADOBE AEP QUERY SERVICE SQL
-- ==========================================
SELECT
warehouse_id,
SUM(CASE WHEN status = 'delivered' THEN 1 ELSE 0 END) / COUNT(*) AS efficiency_index
FROM
aep_backend_dataset.warehouse_logs
WHERE
event_date BETWEEN '2023-01-01' AND '2023-12-31'
GROUP BY
warehouse_idSource Data
ERP
Dependencies
[ "Total Output Value", "Total Input Cost" ]
Report Attributes
Region Product Line Time Period
Recommended Reporting Views
Segment Eligibility
true
Governance
Governance
GitHub
catalog/kpis/supply-chain-efficiency-index.yml