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.