This is a Inventory and Warehousing Balanced Scorecard Report, it is one of reports that Balanced Scorecard Designer can generate for Inventory and Warehousing scorecard. With this software you can also design your own KPIs, Balanced Scorecards and metrics.


Inventory Balanced Scorecard

Report includes: 1 month(s) 49 day(s), from 05.04.2008 to 24.05.2008

  Name Start value End value Dynamic Contains
Root Inventory Balanced Scorecard 41,9 % 38,73 % -3,17 %
Process Perspective(19,5%, -35,06%Down)
Financial Perspective(38,7%, 8,33%Up)
Storage efficiency(63,6%, 41,02%Up)
Customer Perspective(22,9%, -25,4%Down)
Non-conformance analysis(49%, -4,74%Down)

Graph for Inventory Balanced Scorecard

Graph for Inventory Balanced Scorecard

Data for Inventory Balanced Scorecard

DatesValue
05.04.200841,9
12.04.200848,76
19.04.200842,77
26.04.200837,56
03.05.200857,28
10.05.200849,7
17.05.200840,46
24.05.200838,73

Process Perspective

  Name Start value End value Dynamic Parent Contains
Root Process Perspective 54,54 % 19,48 % -35,06% 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
05.04.200854,542
12.04.200841,742
19.04.200843,432
26.04.200843,372
03.05.200852,172
10.05.200844,152
17.05.200858,42
24.05.200819,482

Part Count Accuracy

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Part Count Accuracy 84,15 69,8 -14,35 % 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
05.04.200826011084,15
12.04.200826011097,05
19.04.200826011079,3
26.04.200826011082,85
03.05.200826011089,8
10.05.200826011077,2
17.05.200826011068,6
24.05.200826011069,8

Days of Supply

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Days of Supply 18,05 57,45 + 39,4 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
05.04.20083106018,05
12.04.20083106040,2
19.04.20083106016,65
26.04.20083106045,65
03.05.20083106029,2
10.05.20083106027
17.05.20083106011,65
24.05.20083106057,45

Lead time

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Lead time 60,22 58,78 -1,44 % Maximize Process Perspective
Description Lead time (time between placing an order and the point at which it is actually delivered) divided by industry's benchamrking value, multiplied by 100

Graph for Lead time

Graph for Lead time

Data for Lead time

DatesWeightMinMaxValue
05.04.200834010060,22
12.04.200834010068,68
19.04.200834010046,6
26.04.200834010090,64
03.05.200834010053,98
10.05.200834010062,74
17.05.200834010062,98
24.05.200834010058,78

Financial Perspective

  Name Start value End value Dynamic Parent Contains
Root Financial Perspective 30,34 % 38,67 % + 8,33% 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
05.04.200830,342
12.04.200828,112
19.04.200840,42
26.04.200831,562
03.05.200844,172
10.05.200829,462
17.05.200827,642
24.05.200838,672

Insurance

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Insurance 12,215 19,79 + 7,575 % 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
05.04.2008352012,215
12.04.2008352014,375
19.04.2008352019,235
26.04.2008352010,73
03.05.2008352016,475
10.05.2008352017,72
17.05.2008352017,15
24.05.2008352019,79

Gross margin ROI

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Gross margin ROI 1,696 2,857 + 1,161 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
05.04.20084141,696
12.04.20084141,456
19.04.20084143,328
26.04.20084141,339
03.05.20084142,635
10.05.20084141,498
17.05.20084142,02
24.05.20084142,857

Avg. cost per order

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Avg. cost per order 40,4 37,32 -3,08 % Minimize Financial Perspective
Description Total Inventory Budget divided by the number of orders placed
Target description USD

Graph for Avg. cost per order

Graph for Avg. cost per order

Data for Avg. cost per order

DatesWeightMinMaxValue
05.04.20082105040,4
12.04.20082105040,76
19.04.20082105035,4
26.04.20082105038,8
03.05.20082105024,28
10.05.20082105017,64
17.05.20082105037,92
24.05.20082105037,32

Storage efficiency

  Name Start value End value Dynamic Parent Contains
Root Storage efficiency 22,61 % 63,63 % + 41,02% Inventory Balanced Scorecard
Indicators
Inventory turnover rate
Inventory Levels
Space Utilization

Graph for Storage efficiency

Graph for Storage efficiency

Data for Storage efficiency

DatesValueWeight
05.04.200822,612
12.04.200891,062
19.04.200832,032
26.04.200853,392
03.05.200846,522
10.05.200877,452
17.05.200850,722
24.05.200863,632

Inventory turnover rate

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Inventory turnover rate 18,73 13,032 -5,698 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
05.04.2008332518,73
12.04.2008332524,516
19.04.200833259,798
26.04.2008332514,924
03.05.2008332510,876
10.05.2008332519,522
17.05.2008332520,864
24.05.2008332513,032

Inventory Levels

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Inventory Levels 20,96 119,48 + 98,52 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
05.04.200832014020,96
12.04.2008320140108,32
19.04.200832014038,24
26.04.2008320140127,4
03.05.200832014046,16
10.05.200832014085,76
17.05.200832014066,56
24.05.2008320140119,48

Space Utilization

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Space Utilization 41,265 74,485 + 33,22 % Maximize Storage efficiency
Description Amount of utilized space divided by the total storage space, multiplied by 100

Graph for Space Utilization

Graph for Space Utilization

Data for Space Utilization

DatesWeightMinMaxValue
05.04.20084409541,265
12.04.20084409594,505
19.04.20084409565,025
26.04.20084409554,135
03.05.20084409580,205
10.05.20084409592,91
17.05.20084409560,24
24.05.20084409574,485

Customer Perspective

  Name Start value End value Dynamic Parent Contains
Root Customer Perspective 48,28 % 22,88 % -25,4% Inventory Balanced Scorecard
Indicators
Return rate
Cancellation rate

Graph for Customer Perspective

Graph for Customer Perspective

Data for Customer Perspective

DatesValueWeight
05.04.200848,282
12.04.200825,342
19.04.200834,92
26.04.200823,462
03.05.200872,642
10.05.200849,482
17.05.20081,622
24.05.200822,882

Return rate

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Return rate 5,598 19,392 + 13,79 % 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
05.04.200861205,598
12.04.2008612019,563
19.04.2008612010,975
26.04.2008612016,561
03.05.200861203,356
10.05.2008612010,196
17.05.2008612019,791
24.05.2008612019,392

Cancellation rate

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Cancellation rate 14,02 7,664 -6,356 % 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
05.04.2008411514,02
12.04.200841156,614
19.04.2008411512,76
26.04.2008411510,59
03.05.200841157,972
10.05.200841158,518
17.05.2008411514,664
24.05.200841157,664

Non-conformance analysis

  Name Start value End value Dynamic Parent Contains
Root Non-conformance analysis 53,74 % 49 % -4,74% 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
05.04.200853,742
12.04.200857,562
19.04.200863,082
26.04.200836,042
03.05.200870,882
10.05.200847,982
17.05.200863,92
24.05.2008492

Pilferage and spoilage

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Pilferage and spoilage 3,898 4,024 + 0,126 % 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
05.04.200821153,898
12.04.2008211512,508
19.04.2008211514,328
26.04.200821156,474
03.05.200821157,09
10.05.200821158,294
17.05.2008211511,22
24.05.200821154,024

Price of Non-Conformance (PONC)

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Price of Non-Conformance (PONC) 7,228 9,352 + 2,124 % 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
05.04.200821107,228
12.04.200821108,614
19.04.200821105,068
26.04.200821107,696
03.05.200821102,548
10.05.200821106,886
17.05.200821106,175
24.05.200821109,352

Target PONC improvement

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Target PONC improvement 105,05 99,1 -5,95 % Minimize Non-conformance analysis
Description Current PONC level divided by the previous PONC level, multiplied by 100

Graph for Target PONC improvement

Graph for Target PONC improvement

Data for Target PONC improvement

DatesWeightMinMaxValue
05.04.2008470120105,05
12.04.200847012076,45
19.04.200847012070,2
26.04.2008470120118,1
03.05.200847012086,3
10.05.2008470120102,05
17.05.200847012073,3
24.05.200847012099,1
Created by: AKS-Labs
Report created with Balanced Scorecard Designer at 28.04.2008 23:52:55

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