OpenKPIs
Leaderboard
Sign in
← Back to KPIs

Supply Chain Cost Efficiency

Also known as: Supply Chain Cost Ratio, Cost Efficiency in Supply Chain

EfficiencykpiLogistics & Supply Chain

Measures the effectiveness of cost management in the supply chain by comparing total supply chain costs to the value of goods delivered.

Business Use Case

Executives use this KPI to identify cost-saving opportunities and optimize supply chain operations.

Business Criticality

High

Journey / Navigation Area

Generic

Owning Function

Data Architecture Team

Scope

Global

Formula

(Total Supply Chain Costs / Value of Goods Delivered) × 100

Calculation Notes

Exclude non-operational costs; consider currency fluctuations in international operations.

Technical Details

Measure Typepercentage
Aggregation WindowTime based - Monthly

Events

SQL Queries

Google Analytics 4 (BigQuery)
-- ==========================================
-- 1. GOOGLE BIGQUERY SQL
-- ==========================================
SELECT 
    SUM(cost) / SUM(revenue) AS supply_chain_cost_efficiency
FROM 
    `your-project.erp.supply_chain_data`
WHERE 
    date BETWEEN '2023-01-01' AND '2023-12-31';
Adobe Experience Platform (AEP Query Service)
-- ==========================================
-- 2. ADOBE AEP QUERY SERVICE SQL
-- ==========================================
SELECT 
    SUM(cost) / SUM(revenue) AS supply_chain_cost_efficiency
FROM 
    aep_backend_dataset.supply_chain_data
WHERE 
    date BETWEEN '2023-01-01' AND '2023-12-31';

Source Data

ERP

Dependencies

[ "Total Supply Chain Costs", "Value of Goods Delivered" ]

Report Attributes

Region Product Category Time Period

Recommended Reporting Views

Views
Supply Chain Performance DashboardExecutive Summary Dashboard

Segment Eligibility

true

Governance

Data Sensitivityinternal

Governance

Created bydevyendarm
Created on8/28/2026
Last modified bydevyendarm
StatusPUBLISHED

GitHub

View File on GitHubcatalog/kpis/supply-chain-cost-efficiency.yml

Community Discussion