KPI Table
This table provides a summary of all the performance metrics for the plan. Below are the available metrics and their formulas:
SIMCEL standard terms | Formula | Notes |
Administration (CUR) | Sumif ( CostMaster, Group Level 2 = Administration) | |
Average Inventory Value (CUR) | Sum (month End inventory Volume * COGS)/ # months | This KPI can be converted. Conversion rate set per month and year |
COGS (CUR) | COGS | |
COGS as % of Primary NSV (%) | COGS/ Net Sales In | |
Constrained Distributor Closing Stock Value (CUR) | see SIT - Calculation Logic | This KPI can be converted. Conversion rate set per month and year |
Constrained Distributor Closing Stock Volume (UNIT) | see SIT - Calculation Logic | |
Constrained SIT (DAYS) | see SIT - Calculation Logic | |
Customer Delivery (CUR) | ||
Distribution Cost (CUR) | ||
Distributor Secondary Demand Volume (Unit) | Sum ( UnconstrainedSalesOut, Origin = Distributor) | |
Distributor Secondary Gross Demand Value (CUR) | Distributor Secondary Demand Volume * Listed Price | |
Distributor Secondary Gross Sales Value (CUR) | Sumif ( ConstrainedSalesOutGSV, Origin = Distributor) | |
Distributor Secondary Sales Volume (Unit) | Sum ( ConstrainedSalesOut, Origin = Distributor) | |
D-P-M (CUR) | Local Supply Chain Cost + Promotion + Medical Affaire Cost | |
D-P-M as % of Primary NSV (%) | D-P-M / Net Sales In Value | |
D-P-M-A (CUR) | D-P-M + Administration | |
D-P-M-A as % of Primary NSV (%) | D-P-M-A / Net Sales In Value | |
EBIT (CUR) | Gross Profit - Transport - Storage and Handling - Promotion - Medical Affairs - Administration | |
EBIT as % of Primary NSV (%) | EBIT / FIE Net Sales Value | |
Gross Margin (%) | Gross profit / Net FIE Sales | |
Gross Profit (CUR) | ConstrainedSalesInGSV - TradeExpenses - COGS | |
Inbound CO2 Emission (KG) | see CO2 Computation | |
Medical Affairs (CUR) | ||
Outbound CO2 Emission (KG) | see CO2 Computation | |
Primary Demand Value (VND) | Sumif ( DemandValue, Facility Type = Distributor) | |
Primary Demand Volume (UNIT) | Sumif ( OrderQuantity, Facility Type = Distributor) | |
Primary Gross Sales Value (VND) | Sumif ( ConstrainedSalesInGSV, Facility Type = Distributor) | |
Primary Net Sales Value (VND) | Sumif ( ConstrainedSalesInGSV, Facility Type = Distributor) - Sumif (Trade Expense, Facility Type = Distributor) | |
Primary Sales Volume (UNIT) | Sumif ( DispatchQuantity, Facility Type = Distributor) | |
Primary Case Fill Rate (%) | Primary Sales Volume / Primary Demand Volume | |
Primary Trade Expenses (CUR) | Sumif ( Trade Expense, Facility Type = Distributor) | |
Profit Before Marketing (CUR) | ||
Promotion (CUR) | Sumif ( CostMaster, Group Level 2 = Promotion) | |
Secondary Case Fill Rate (%) | Local Sales Volume / Local Demand Volume | |
Secondary Demand Value (CUR) | Secondary Demand Volume * Listed Price | |
Secondary Demand Volume (UNIT) | Sumif ( UnconstrainedSalesOut, Facility Type = Customer) | |
Secondary Gross Sales (CUR) | Sumif ( ConstrainedSalesOutGSV, Facility Type = Customer) | |
Secondary Net Sales (CUR) | Local Gross Sales Value - Local Trade Expenses | |
Secondary Sales Volume (UNIT) | Sumif ( ConstrainedSalesOut, Facility Type = Customer) | |
Secondary Trade Expenses (CUR) | Sumif ( Trade Expense, Facility Type = Customer) | |
Stock Transfer (CUR) | ||
Storage (CUR) | ||
Storage And Distribution (CUR) | ||
Storage and Handling (CUR) | Sumif ( CostMaster, Group Level 2 = Storage & Handling) | |
Storage CO2 Emission (KG) | see CO2 Computation | |
Supply Chain Cost (CUR) | Transport + Storage and Handling | |
Total CO2 Emission (KG) | Inbound CO2 Emission + Storage CO2 Emission + Outbound CO2 Emission | |
Transport (CUR) | Sumif ( CostMaster, Group Level 2 = Transport) | |
Unconstrained Distributor Closing Stock GSV (CUR) | see SIT - Calculation Logic | |
Unconstrained Distributor Closing Stock Volume (UNIT) | see SIT - Calculation Logic | |
Unconstrained SIT (DAYS) | see SIT - Calculation Logic |