Manufacturing Scorecard Summary
The following table contains a summary of the KPIs that are delivered with Manufacturing Scorecard. It lists the KPI description, dimension or object type, perspective type, and KPI calculation definition.
KPI Name |
Dimension (Object Type) |
Perspective |
KPI Calculation |
---|---|---|---|
Total Product Revenue |
Business Unit |
Financial |
Calculates the total revenue of all products sold . |
Inventory Cost |
Business Unit |
Internal |
Total of all inventory costs. |
Supply Chain Cost |
Business Unit |
Internal |
sum of all supply chain related costs / (total product revenue – total product profit) |
Supply Chain Adaptation Time |
Business Unit |
Internal |
# days to identify environmental change & devise response + # days to achieve supply of material for new demand level + days to achieve sustained production rate for new demand level + # days to achieve sustained delivery rate at required service levels |
Return on Supply Chain Assets |
Business Unit |
Internal |
Supply Chain Revenue Contribution / Supply Chain Fixed Asset Value |
Perfect Order Fulfillment |
Business Unit |
Internal |
[total orders shipped on time and in full - orders with faulty documentation - orders with shipping damage] / [total orders] |
Order Fulfillment Lead Time (average) |
Business Unit |
Internal |
[actual lead times for orders shipped] / [total number of orders shipped] |
Total # of Purchase Orders |
Business Unit |
Internal |
Total number of purchase orders for a period. |
Total # of Shipments |
Business Unit |
Internal |
Total # of shipments made for a period. |
# Shipments On-Time & Qty Correct |
Business Unit |
Internal |
# shipments made by the commit date with the quantity requested. |
Sum of Shipment Lead Times |
Business Unit |
Internal |
Sum difference between shift date and request date. |
# of On-Time Shipments |
Business Unit |
Internal |
# shipments made on or before the scheduled date. |
# Shipments With Backorder Qty |
Business Unit |
Internal |
# shipments made having a backorder amount. |
# Shipments Made In-Full |
Business Unit |
Internal |
# shipments made with the correct requested quantity. |
Total # of Orders Received |
Business Unit |
Internal |
Total number of orders received in a period. |
# of Orders Invoiced Correctly |
Business Unit |
Internal |
# Orders received with correct invoice amount. |
Purchase Qty Accepted |
Business Unit |
Internal |
Sum of QTY_SH_ACCPT_SUOM for all orders received |
# Orders Received On-Time |
Business Unit |
Internal |
# of orders received by the promised date |
# Orders Received Qty Correct |
Business Unit |
Internal |
# orders received with the correct order quantity |
Total Order Qty Received |
Business Unit |
Internal |
Sum of QTY_SH_RECVD_SUOM for all orders received |
Total purchase amount |
Business Unit |
Internal |
Sum of MERCH_AMT_BSE for all orders |
Purchase amount under contract |
Business Unit |
Internal |
Sum of MERCH_AMT_BSE where CNTRCT_ID is not NULL' |
Customer Satisfaction Score |
Business Unit |
Internal |
Average of customer satisfaction scores. |
Cost Of Goods Sold |
Business Unit |
Financial |
Resolved using customer-specific PeopleSoft tree structure defining list of General Ledger account groups. |
% PO Invoiced Correct |
Business Unit |
Supplier |
(# of purchase orders invoiced correctly / total # purchase orders) * 100 |
% Orders Returned |
Business Unit |
Internal |
# orders returned within a period / # orders shipped within same period |
% Orders Received On Time |
Business Unit |
Internal |
% of orders received on time. |
% Ordered Quantity Correct |
Business Unit |
Internal |
(quantity received correct / total receipt quantity) - (received qty correct / receipts qty shipped) * 100 |
% Ordered ($) Under Contract |
Business Unit |
Internal |
(purchased amount under contract / purchased amount closed) * 100 |
% On Time Delivery |
Business Unit |
Internal |
# shipments made per commit date / total # shipments made |
% Returned |
Business Unit |
Internal |
(# orders returned within a period / # orders shipped within same period) * 100 |
Days Payable Outstanding |
Business Unit |
Internal |
Resolved using customer-specific PeopleSoft tree structure defining list of General Ledger account groups. |
Days of Inventory Supply |
Business Unit |
Internal |
Current days of inventory supply |
Days Sales Outstanding |
Business Unit |
Internal |
Resolved using customer-specific PeopleSoft tree structure defining list of General Ledger account groups. |
% Perfect Order Fulfillment |
Business Unit |
Internal |
( (# shipments made on time per a requested date - # shipments having errors ) / total # shipments) * 100 |
Sum of Supply Chain Costs |
Business Unit |
Internal |
MFG_CST011 + MFG_CST012 + MFG_CST013 + MFG_CST014 + MFG_CST015 + MFG_CST016 + MFG_CST017 |
Cash to Cash Cycle Time |
Business Unit |
Internal |
(total inventory days of supply + days of sales outstanding) - days of payables outstanding |
# Shipments Having Errors |
Business Unit |
Internal |
# of instances of product returns for a period |
# Returned Orders |
Business Unit |
Internal |
# of instances of product returns for a period |
% Receipts Qty Correct |
Business Unit |
Internal |
( MFG_RCV003 / MFG_RCV001 ) * 100 |
% Backorders |
Business Unit |
Internal |
# shipments having a backorder qty / total # of shipments made |
# of Orders Shipped |
Business Unit |
Internal |
Total # of shipments. |
# of Orders Shipped On Time |
Business Unit |
Internal |
# of on-time shipments. |
Delivery Performance |
Business Unit |
Internal |
Percent on time delivery. |
Average Item Cost (Unit Cost Per Item) |
Business Unit |
Internal |
Sum of (std_cost) / sum of (items) |
Average Item Inventory |
Business Unit |
Internal |
Sum of (qty_onhand) / sum of (items) |
Average Item Use Per Month |
Business Unit |
Internal |
use_per_year / 12 |
Inventory Dollar Days |
Business Unit |
Internal |
unit cost * (average inventory / average use per month) |
Investment |
Business Unit |
Internal |
material costs + cost of work in progress + finished goods costs + facilities costs + equipment costs |
Raw Material Costs |
Business Unit |
Financial |
Resolved using customer-specific PeopleSoft tree structure defining list of General Ledger account groups. |
Work in Progress Cost |
Business Unit |
Internal |
Resolved using customer-specific PeopleSoft tree structure defining list of General Ledger account groups. |
Facilities Costs |
Business Unit |
Financial |
Resolved using customer-specific PeopleSoft tree structure defining list of General Ledger account groups. |
Equipment Costs |
Business Unit |
Financial |
Resolved using customer-specific PeopleSoft tree structure defining list of General Ledger account groups. |
Inventory Turns |
Business Unit |
Internal |
throughput / inventory |
Net Profit |
Business Unit |
Internal |
throughput – operating expense |
Operating Expense |
Business Unit |
Internal |
throughput – operating expense |
Cost of Salary and Wages |
Business Unit |
Internal |
wage costs + cost of benefits + utilities costs + insurance costs + lease expenses + interest + taxes |
Cost of Benefits |
Business Unit |
Financial |
Resolved using customer-specific PeopleSoft tree structure defining list of General Ledger account groups. |
Cost of Utilities |
Business Unit |
Financial |
Resolved using customer-specific PeopleSoft tree structure defining list of General Ledger account groups. |
Insurance Costs |
Business Unit |
Financial |
Resolved using customer-specific PeopleSoft tree structure defining list of General Ledger account groups. |
Lease Costs |
Business Unit |
Financial |
Resolved using customer-specific PeopleSoft tree structure defining list of General Ledger account groups. |
Interest Costs |
Business Unit |
Financial |
Resolved using customer-specific PeopleSoft tree structure defining list of General Ledger account groups. |
Taxes |
Business Unit |
Financial |
Resolved using customer-specific PeopleSoft tree structure defining list of General Ledger account groups. |
Productivity |
Business Unit |
Internal |
throughput / operating expense |
Return on Investment |
Business Unit |
Internal |
net profit / inventory |
Throughput |
Business Unit |
Internal |
total sales – total variable expense |
Shipment Days Late |
Business Unit |
Internal |
Sum of (ship_date – request_date) |
Shipment Value |
Business Unit |
Internal |
Sum of (unit_price * ship_qty) |
Throughput Dollar Days |
Business Unit |
Internal |
shipment days late * shipment value |
Total Variable Expense |
Business Unit |
Internal |
material cost + sales commissions + shipping costs + packaging costs |
Material Costs |
Business Unit |
Financial |
Resolved using customer-specific PeopleSoft tree structure defining list of General Ledger account groups. |
Sales Commissions |
Business Unit |
Financial |
Resolved using customer-specific PeopleSoft tree structure defining list of General Ledger account groups. |
Shipping Costs |
Business Unit |
Financial |
Resolved using customer-specific PeopleSoft tree structure defining list of General Ledger account groups. |
Packaging Costs |
Business Unit |
Financial |
Resolved using customer-specific PeopleSoft tree structure defining list of General Ledger account groups. |
Respond To Environment Change |
Business Unit |
Internal |
#days to identify environmental change and devise response + # days to achieve supply of material for new demand level + days to achieve sustained make rate for new demand level + # days to achieve sustained delivery rate at required service levels. |
Achieve New Material Supply |
Business Unit |
Internal |
# days required to achieve a new material supply schedule. |
Achieve New Production Rate |
Business Unit |
Internal |
# days required to implement a new production rate. |
Achieve New Delivery Rate |
Business Unit |
Internal |
# days required to achieve a new delivery rate. |
Order Management Costs |
Business Unit |
Internal |
Costs associated with order processing. |
Procurement Costs |
Business Unit |
Internal |
Costs associated with purchasing and procurement. |
Planning Costs |
Business Unit |
Internal |
Costs associated with planning activities. |
MIS Costs |
Business Unit |
Internal |
Costs associated with operating MIS operations. |
Warranty Costs |
Business Unit |
Internal |
Costs associated with warranty replacements. |
Returned Product Costs |
Business Unit |
Internal |
Costs associated with processing returned goods. |
Total Product Profit |
Business Unit |
Internal |
Resolved using customer-specific PeopleSoft tree structure defining list of General Ledger account groups. |
Supply Chain Fixed Asset Value |
Business Unit |
Internal |
(Supply chain revenue contribution / supply chain fixed asset value) * 100. |