Southern Cross Precision Manufacturing / Command Centre

KPI Dictionary

Interactive demonstration using synthetic manufacturing data. No real company or production information is used.

KPI catalogue

16 governed metrics

Revenue

FinanceOwner: Finance Controller · Daily

Total invoiced sales value, net of discounts.

Calculation

Σ InvoiceLine.amount

Source

Sage Accounting

Target / Warning

≥ Budget / < 95% of forecast

Drill-down path

Revenue → Customer → Sales Order → Invoice → Invoice Line

Gross Margin %

FinanceOwner: Finance Controller · Daily

Gross profit as a percentage of revenue.

Calculation

(Revenue − COGS) / Revenue × 100

Source

Sage Accounting

Target / Warning

≥ 38% / < 34%

Drill-down path

Gross Margin → Product → Invoice Line

Net Profit

FinanceOwner: CFO · Monthly

Gross profit less operating expenses.

Calculation

Gross Profit − (Labour + Scrap + Overhead)

Source

Sage Accounting

Target / Warning

≥ Budget / < 90% of budget

Drill-down path

Net Profit → Cost Category

Inventory Turns

InventoryOwner: Supply Chain Lead · Daily

How many times inventory is sold and replaced per year.

Calculation

Annualised COGS / Ending Inventory Value

Source

MISys Manufacturing

Target / Warning

≥ 6.0 / < 4.5

Drill-down path

Inventory Value → Warehouse → Item → Transaction

Inventory Accuracy

InventoryOwner: Warehouse Manager · Weekly

Agreement between recorded and physical stock (cycle-count based).

Calculation

1 − |counted − system| / system

Source

MISys Manufacturing

Target / Warning

≥ 98% / < 95%

Drill-down path

Accuracy → Warehouse → Location → Item

Capacity Utilization

ManufacturingOwner: Production Manager · Daily

Scheduled load against available machine hours.

Calculation

(Run Hours + Downtime) / Available Hours × 100

Source

MISys Manufacturing

Target / Warning

75–90% / > 95% or < 60%

Drill-down path

Capacity → Line → Machine → Operation

Machine Utilization

ManufacturingOwner: Production Manager · Daily

Productive run time against available machine hours.

Calculation

Run Hours / Available Hours × 100

Source

MISys Manufacturing

Target / Warning

≥ 80% / < 70%

Drill-down path

Utilization → Machine → Operation

Labour Efficiency

ManufacturingOwner: Production Manager · Daily

Standard hours earned against actual hours worked.

Calculation

Planned Hours / Actual Hours × 100

Source

MISys Manufacturing

Target / Warning

≥ 95% / < 85%

Drill-down path

Efficiency → MO → Operation → Labour

Production Efficiency

ManufacturingOwner: Production Manager · Daily

Produced units against planned units.

Calculation

Produced Qty / Planned Qty × 100

Source

MISys Manufacturing

Target / Warning

≥ 95% / < 90%

Drill-down path

Production → MO → Work Order → Operation

Yield

ManufacturingOwner: Quality Manager · Daily

Good units as a share of total units started.

Calculation

Produced / (Produced + Scrap) × 100

Source

MISys Manufacturing

Target / Warning

≥ 96% / < 93%

Drill-down path

Yield → Line → MO → Scrap

Scrap Rate

ManufacturingOwner: Quality Manager · Daily

Scrapped units as a share of total units started.

Calculation

Scrap / (Produced + Scrap) × 100

Source

MISys Manufacturing

Target / Warning

≤ 4% / > 6%

Drill-down path

Scrap → Line → MO → Reason

On-Time Delivery

SalesOwner: Customer Service Lead · Daily

Orders shipped on or before the promised date.

Calculation

On-time shipments / Total shipments × 100

Source

Sage Accounting

Target / Warning

≥ 95% / < 90%

Drill-down path

OTD → Customer → Sales Order

Quote Conversion Rate

SalesOwner: Sales Manager · Weekly

Quotations that convert to sales orders.

Calculation

Converted quotes / Total quotes × 100

Source

Microsoft Excel

Target / Warning

≥ 45% / < 35%

Drill-down path

Conversion → Customer → Quote

Forecast Accuracy

SalesOwner: Demand Planner · Monthly

Closeness of forecast to actual revenue (1 − MAPE).

Calculation

(1 − mean(|Actual − Forecast| / Actual)) × 100

Source

Microsoft Excel

Target / Warning

≥ 85% / < 75%

Drill-down path

Accuracy → Month → Product

Supplier On-Time Performance

PurchasingOwner: Procurement Lead · Daily

Purchase orders received on or before the promised date.

Calculation

On-time receipts / Total receipts × 100

Source

Sage Accounting

Target / Warning

≥ 90% / < 85%

Drill-down path

Supplier OTD → Supplier → PO

Purchase Price Variance

PurchasingOwner: Procurement Lead · Daily

Difference between actual and standard purchase cost.

Calculation

Σ (Actual Cost − Standard Cost) × Qty

Source

Sage Accounting

Target / Warning

≤ 0 (favourable) / > 2% of spend

Drill-down path

PPV → Supplier → PO Line