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


Transportation Balanced Scorecard

Report includes: 1 month(s) 49 day(s), from 06.04.2008 to 25.05.2008

  Name Start value End value Dynamic Contains
Root Transportation Balanced Scorecard 41,01 % 50,45 % + 9,44 %
Quality Metrics(41%, 1,12%Up)
Warehouse Utilization(60%, 0,72%Up)
Financial perspective(44%, 27,54%Up)
Customer perspective(58,5%, -13,42%Down)
Process management(59,9%, -1,73%Down)
Asset management(55,1%, 49,7%Up)

Graph for Transportation Balanced Scorecard

Graph for Transportation Balanced Scorecard

Data for Transportation Balanced Scorecard

DatesValue
06.04.200841,01
13.04.200834,92
20.04.200868,99
27.04.200853,51
04.05.200843,33
11.05.200862,36
18.05.200848,13
25.05.200850,45

Quality Metrics

  Name Start value End value Dynamic Parent Contains
Root Quality Metrics 39,92 % 41,04 % + 1,12% Transportation Balanced Scorecard
Indicators
Frequency of damage
Time spent picking back orders or stock-outs

Graph for Quality Metrics

Graph for Quality Metrics

Data for Quality Metrics

DatesValueWeight
06.04.200839,923
13.04.200824,263
20.04.200888,983
27.04.200840,943
04.05.200847,183
11.05.200867,763
18.05.200815,343
25.05.200841,043

Frequency of damage

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Frequency of damage 61,982 44,734 -17,25 % Minimize Quality Metrics
Description Number of incidents during the given period divided by the total number of processed orders, multiplied by 100

Graph for Frequency of damage

Graph for Frequency of damage

Data for Frequency of damage

DatesWeightMinMaxValue
06.04.2008638061,982
13.04.2008638054,513
20.04.2008638016,937
27.04.2008638072,685
04.05.2008638039,729
11.05.200863804,078
18.05.2008638076,381
25.05.2008638044,734

Time spent picking back orders or stock-outs

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Time spent picking back orders or stock-outs 20,885 34,745 + 13,86 % Minimize Quality Metrics
Description Number of hours spent on picking back orders or stock-outs, divided by the total number of working hours, multilpied by 100

Graph for Time spent picking back orders or stock-outs

Graph for Time spent picking back orders or stock-outs

Data for Time spent picking back orders or stock-outs

DatesWeightMinMaxValue
06.04.2008455020,885
13.04.2008455045,05
20.04.200845505,18
27.04.2008455010,355
04.05.2008455032,225
11.05.2008455040,325
18.05.2008455035,915
25.05.2008455034,745

Warehouse Utilization

  Name Start value End value Dynamic Parent Contains
Root Warehouse Utilization 59,26 % 59,98 % + 0,72% Transportation Balanced Scorecard
Indicators
Storage utilization
Fill rate
Rate of stock-outs

Graph for Warehouse Utilization

Graph for Warehouse Utilization

Data for Warehouse Utilization

DatesValueWeight
06.04.200859,262
13.04.200837,122
20.04.200852,72
27.04.200846,642
04.05.200842,922
11.05.200833,982
18.05.200874,162
25.05.200859,982

Storage utilization

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Storage utilization 45,6 72,975 + 27,37 % Maximize Warehouse Utilization
Description Utilized storage space divided by the overall storage capacity, multiplied by 100

Graph for Storage utilization

Graph for Storage utilization

Data for Storage utilization

DatesWeightMinMaxValue
06.04.20084159045,6
13.04.20084159059,4
20.04.20084159035,325
27.04.20084159039,15
04.05.20084159040,875
11.05.20084159015,15
18.05.20084159081
25.05.20084159072,975

Fill rate

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Fill rate 80,56 34,8 -45,76 % Maximize Warehouse Utilization
Description Number of items delivered as ordered divided by the total number of items, multiplied by 100

Graph for Fill rate

Graph for Fill rate

Data for Fill rate

DatesWeightMinMaxValue
06.04.200822010080,56
13.04.200822010057,28
20.04.200822010036,72
27.04.200822010057,6
04.05.200822010064,8
11.05.200822010055,12
18.05.200822010075,68
25.05.200822010034,8

Rate of stock-outs

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Rate of stock-outs 28,3 31,96 + 3,66 % Minimize Warehouse Utilization
Description Number of stock-out items divided by the total number of items, multiplied by 100

Graph for Rate of stock-outs

Graph for Rate of stock-outs

Data for Rate of stock-outs

DatesWeightMinMaxValue
06.04.20084107028,3
13.04.20084107063,82
20.04.20084107013,48
27.04.20084107033,46
04.05.20084107043,12
11.05.20084107032,32
18.05.20084107032,44
25.05.20084107031,96

Financial perspective

  Name Start value End value Dynamic Parent Contains
Root Financial perspective 16,41 % 43,95 % + 27,54% Transportation Balanced Scorecard
Indicators
Cost per order
Dollar value per order
Return on investment
Distribution cost efficiency *
* - Information for this metric is limited in sample report

Graph for Financial perspective

Graph for Financial perspective

Data for Financial perspective

DatesValueWeight
06.04.200816,412
13.04.200817,332
20.04.200879,122
27.04.200863,322
04.05.200853,952
11.05.200862,972
18.05.200842,732
25.05.200843,952

Cost per order

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Cost per order 258,25 192,75 -65,5 Score Minimize Financial perspective
Description The cost of a single order
Target description USD

Graph for Cost per order

Graph for Cost per order

Data for Cost per order

DatesWeightMinMaxValue
06.04.2008550300258,25
13.04.2008550300292,5
20.04.200855030084,5
27.04.200855030082,75
04.05.2008550300242
11.05.200855030081
18.05.2008550300286
25.05.2008550300192,75

Dollar value per order

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Dollar value per order 88,08 186,48 + 98,4 Score Maximize Financial perspective
Description The dollar value of a single order
Target description USD

Graph for Dollar value per order

Graph for Dollar value per order

Data for Dollar value per order

DatesWeightMinMaxValue
06.04.200836030088,08
13.04.200836030072,48
20.04.2008360300235,68
27.04.2008360300145,68
04.05.2008360300258
11.05.2008360300100,56
18.05.2008360300244,32
25.05.2008360300186,48

Return on investment

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Return on investment 41,12 30,92 -10,2 % Maximize Financial perspective
Description The amount of money gained an investment divided by the amount of money invested, multiplied by 100

Graph for Return on investment

Graph for Return on investment

Data for Return on investment

DatesWeightMinMaxValue
06.04.20081208041,12
13.04.20081208075,56
20.04.20081208066,56
27.04.20081208069,56
04.05.20081208070,34
11.05.20081208068,6
18.05.20081208073,58
25.05.20081208030,92

Customer perspective

  Name Start value End value Dynamic Parent Contains
Root Customer perspective 71,94 % 58,52 % -13,42% Transportation Balanced Scorecard
Indicators
Rate of customer returns
Rate of on-time delivery

Graph for Customer perspective

Graph for Customer perspective

Data for Customer perspective

DatesValueWeight
06.04.200871,941
13.04.200860,521
20.04.200859,621
27.04.200853,061
04.05.20089,41
11.05.200869,91
18.05.200868,21
25.05.200858,521

Rate of customer returns

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Rate of customer returns 22,765 27 + 4,235 % Minimize Customer perspective
Description Number of items returned by customers divided by the total number of items, multiplied by 100

Graph for Rate of customer returns

Graph for Rate of customer returns

Data for Rate of customer returns

DatesWeightMinMaxValue
06.04.2008656022,765
13.04.200865608,08
20.04.2008656010,005
27.04.2008656015,395
04.05.2008656055,49
11.05.2008656013,195
18.05.2008656027,55
25.05.2008656027

Rate of on-time delivery

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Rate of on-time delivery 82,64 65,04 -17,6 % Maximize Customer perspective
Description Number of items delivered on-time divided by the total number of items, multiplied by 100

Graph for Rate of on-time delivery

Graph for Rate of on-time delivery

Data for Rate of on-time delivery

DatesWeightMinMaxValue
06.04.200842010082,64
13.04.200842010027,76
20.04.200842010030,16
27.04.200842010028,8
04.05.200842010028,96
11.05.200842010057,68
18.05.200842010085,6
25.05.200842010065,04

Process management

  Name Start value End value Dynamic Parent Contains
Root Process management 61,66 % 59,93 % -1,73% Transportation Balanced Scorecard
Indicators
Orders picked per hour
Units processed per hour
Back orders

Graph for Process management

Graph for Process management

Data for Process management

DatesValueWeight
06.04.200861,661
13.04.200866,391
20.04.200829,161
27.04.200855,771
04.05.200836,251
11.05.200879,171
18.05.200887,811
25.05.200859,931

Orders picked per hour

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Orders picked per hour 28,94 24,565 -4,375 % Maximize Process management
Description Number of orders picked per hour
Target description Amount

Graph for Orders picked per hour

Graph for Orders picked per hour

Data for Orders picked per hour

DatesWeightMinMaxValue
06.04.2008654028,94
13.04.2008654030,06
20.04.2008654012,665
27.04.2008654029,395
04.05.2008654018,16
11.05.2008654036,885
18.05.2008654038,355
25.05.2008654024,565

Units processed per hour

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Units processed per hour 44,1 52,05 + 7,95 % Maximize Process management
Description Number of units processed per hour

Graph for Units processed per hour

Graph for Units processed per hour

Data for Units processed per hour

DatesWeightMinMaxValue
06.04.20083106044,1
13.04.20083106037,9
20.04.20083106030,9
27.04.20083106026,7
04.05.20083106024,35
11.05.20083106041,2
18.05.20083106057
25.05.20083106052,05

Back orders

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Back orders 59,12 53,62 -5,5 % Minimize Process management
Description Number of unfilled customer orders divided by the total number of orders, multiplied by 100

Graph for Back orders

Graph for Back orders

Data for Back orders

DatesWeightMinMaxValue
06.04.2008156059,12
13.04.2008156023,205
20.04.2008156040,86
27.04.2008156038,385
04.05.2008156032,06
11.05.2008156028,155
18.05.2008156046,635
25.05.2008156053,62

Asset management

  Name Start value End value Dynamic Parent Contains
Root Asset management 5,42 % 55,12 % + 49,7% Transportation Balanced Scorecard
Indicators
Equipment downtime
Inventory turns

Graph for Asset management

Graph for Asset management

Data for Asset management

DatesValueWeight
06.04.20085,421
13.04.200840,561
20.04.200870,561
27.04.200883,51
04.05.200852,341
11.05.200877,321
18.05.200845,521
25.05.200855,121

Equipment downtime

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Equipment downtime 38,44 14,8 -23,64 % Minimize Asset management
Description The number of hours the equipment was out of operation, divided by the overall operating time, multiplied by 100

Graph for Equipment downtime

Graph for Equipment downtime

Data for Equipment downtime

DatesWeightMinMaxValue
06.04.2008604038,44
13.04.2008604035,28
20.04.200860404,32
27.04.200860408,36
04.05.200860409
11.05.2008604015,04
18.05.2008604010,32
25.05.2008604014,8

Inventory turns

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Inventory turns 6,925 15,825 + 8,9 % Maximize Asset management
Description The number of times that a company's inventory cycles (turns) over a year
Target description Amount

Graph for Inventory turns

Graph for Inventory turns

Data for Inventory turns

DatesWeightMinMaxValue
06.04.200845306,925
13.04.2008453025,925
20.04.2008453015,65
27.04.2008453027,525
04.05.200845308,65
11.05.2008453029,925
18.05.200845305,625
25.05.2008453015,825
Created by: AKS-Labs
Report created with Balanced Scorecard Designer at 29.04.2008 0:00:25

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