This is a Inventory and Warehousing Metric Dashboard (Diamond) Report, it is one of reports that Balanced Scorecard Designer can generate for Inventory and Warehousing KPI. With this software you can also design your own scorecards, KPIs and metrics.


Inventory Balanced Scorecard

Report includes: 1 day(s), from 28.10.2008 to 28.10.2008

  Name Start value End value Dynamic Contains
Root Inventory Balanced Scorecard 47,93 % 47,93 % 0 %
Process Perspective(54,4%, 0%)
Financial Perspective(54,4%, 0%)
Storage efficiency(57,6%, 0%)
Customer Perspective(38%, 0%)
Non-conformance analysis(35,2%, 0%)

Graph for Inventory Balanced Scorecard

Graph for Inventory Balanced Scorecard

Data for Inventory Balanced Scorecard

DatesValue
28.10.200847,93

Process Perspective

  Name Start value End value Dynamic Parent Contains
Root Process Perspective 54,4 % 54,4 % 0% Inventory Balanced Scorecard
Indicators
Part Count Accuracy
Days of Supply
Lead time *
Obsolescence and Deterioration *
* - Information for this metric is limited in sample report

Graph for Process Perspective

Graph for Process Perspective

Data for Process Perspective

DatesValueWeight
28.10.200854,42

Part Count Accuracy

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Part Count Accuracy 101,5 101,5 0 % Maximize Process Perspective
Description The accuracy with which the suppliers deliver the parts divided by industry's benchamrking value, multiplied by 100

Graph for Part Count Accuracy

Graph for Part Count Accuracy

Data for Part Count Accuracy

DatesWeightMinMaxValue
28.10.2008260110101,5

Days of Supply

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Days of Supply 55,65 55,65 0 Score Minimize Process Perspective
Description Average Inventory Level divided by the Cost of one Day's Sales
Target description Number of Days of Supply

Graph for Days of Supply

Graph for Days of Supply

Data for Days of Supply

DatesWeightMinMaxValue
28.10.20083106055,65

Financial Perspective

  Name Start value End value Dynamic Parent Contains
Root Financial Perspective 54,44 % 54,44 % 0% Inventory Balanced Scorecard
Indicators
Insurance
Gross margin ROI
Avg. cost per order *
Lost Sales Analysis *
* - Information for this metric is limited in sample report

Graph for Financial Perspective

Graph for Financial Perspective

Data for Financial Perspective

DatesValueWeight
28.10.200854,442

Insurance

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Insurance 5,075 5,075 0 % Minimize Financial Perspective
Description Insurance costs divided by the total inventory costs, multiplied by 100

Graph for Insurance

Graph for Insurance

Data for Insurance

DatesWeightMinMaxValue
28.10.200835205,075

Gross margin ROI

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Gross margin ROI 1,591 1,591 0 Score Maximize Financial Perspective
Description Maintained margin (decimal) multiplied by turnover
Target description Gross margin ROI level

Graph for Gross margin ROI

Graph for Gross margin ROI

Data for Gross margin ROI

DatesWeightMinMaxValue
28.10.20084141,591

Storage efficiency

  Name Start value End value Dynamic Parent Contains
Root Storage efficiency 57,61 % 57,61 % 0% Inventory Balanced Scorecard
Indicators
Inventory turnover rate
Inventory Levels
Space Utilization *
* - Information for this metric is limited in sample report

Graph for Storage efficiency

Graph for Storage efficiency

Data for Storage efficiency

DatesValueWeight
28.10.200857,612

Inventory turnover rate

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Inventory turnover rate 18,532 18,532 0 Score Maximize Storage efficiency
Description Cost of Sales divided by the Average Inventory Level
Target description Number of inventory turns

Graph for Inventory turnover rate

Graph for Inventory turnover rate

Data for Inventory turnover rate

DatesWeightMinMaxValue
28.10.2008332518,532

Inventory Levels

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Inventory Levels 46,04 46,04 0 Score Maximize Storage efficiency
Description Order quantity plus Safety stock, divided by 2
Target description Stock quantity

Graph for Inventory Levels

Graph for Inventory Levels

Data for Inventory Levels

DatesWeightMinMaxValue
28.10.200832014046,04

Customer Perspective

  Name Start value End value Dynamic Parent Contains
Root Customer Perspective 37,98 % 37,98 % 0% Inventory Balanced Scorecard
Indicators
Return rate
Cancellation rate

Graph for Customer Perspective

Graph for Customer Perspective

Data for Customer Perspective

DatesValueWeight
28.10.200837,982

Return rate

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Return rate 9,455 9,455 0 % Minimize Customer Perspective
Description Number of units returned by the customer divided by the total number of shipped units, multiplied by 100

Graph for Return rate

Graph for Return rate

Data for Return rate

DatesWeightMinMaxValue
28.10.200861209,455

Cancellation rate

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Cancellation rate 13,362 13,362 0 % Minimize Customer Perspective
Description Number of orders cancelled by the customer divided by the total number of orders, multiplied by 100

Graph for Cancellation rate

Graph for Cancellation rate

Data for Cancellation rate

DatesWeightMinMaxValue
28.10.2008411513,362

Non-conformance analysis

  Name Start value End value Dynamic Parent Contains
Root Non-conformance analysis 35,22 % 35,22 % 0% Inventory Balanced Scorecard
Indicators
Pilferage and spoilage
Price of Non-Conformance (PONC)
Target PONC improvement *
Quality-Percentage Defect *
* - Information for this metric is limited in sample report

Graph for Non-conformance analysis

Graph for Non-conformance analysis

Data for Non-conformance analysis

DatesValueWeight
28.10.200835,222

Pilferage and spoilage

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Pilferage and spoilage 6,502 6,502 0 % Minimize Non-conformance analysis
Description Pilferage costs divided by the total inventory costs, multiplied by 100

Graph for Pilferage and spoilage

Graph for Pilferage and spoilage

Data for Pilferage and spoilage

DatesWeightMinMaxValue
28.10.200821156,502

Price of Non-Conformance (PONC)

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Price of Non-Conformance (PONC) 9,577 9,577 0 % Minimize Non-conformance analysis
Description The price paid by the system for delivering faulty goods divided by the total inventory costs, multiplied by 100

Graph for Price of Non-Conformance (PONC)

Graph for Price of Non-Conformance (PONC)

Data for Price of Non-Conformance (PONC)

DatesWeightMinMaxValue
28.10.200821109,577
Created by: AKS-Labs
Report created with Balanced Scorecard Designer at 20.11.2008 17:18:30

Copyright © 2000-2012 AKS-Labs. All rights reserved.