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


Supply Chain 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 Supply Chain Balanced Scorecard 54,89 % 48,87 % -6,02 %
Manufacturing(62,6%, -13,56%Down)
Warehousing(55,5%, 33,48%Up)
Transportation(47,4%, -34,36%Down)
Customer satisfaction(32,4%, -8,48%Down)
Financial performance(65,6%, 24,23%Up)

Graph for Supply Chain Balanced Scorecard

Graph for Supply Chain Balanced Scorecard

Data for Supply Chain Balanced Scorecard

DatesValue
05.04.200854,89
12.04.200840,75
19.04.200835,31
26.04.200850,88
03.05.200856,2
10.05.200842,71
17.05.200843,04
24.05.200848,87

Manufacturing

  Name Start value End value Dynamic Parent Contains
Root Manufacturing 76,18 % 62,62 % -13,56% Supply Chain Balanced Scorecard
Indicators
Manufacturing Cycle Time
Defects Per Million Opportunities

Graph for Manufacturing

Graph for Manufacturing

Data for Manufacturing

DatesValueWeight
05.04.200876,181
12.04.200872,021
19.04.20087,261
26.04.200836,241
03.05.200852,121
10.05.20085,821
17.05.200816,41
24.05.200862,621

Manufacturing Cycle Time

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Manufacturing Cycle Time 6,399 8,313 + 1,914 Score Minimize Manufacturing
Description The time period from the firm planned order until the final production is reported.

Target description [days]

Graph for Manufacturing Cycle Time

Graph for Manufacturing Cycle Time

Data for Manufacturing Cycle Time

DatesWeightMinMaxValue
05.04.200863146,399
12.04.200863145,057
19.04.2008631413,175
26.04.2008631411,492
03.05.200863146,19
10.05.2008631413,285
17.05.2008631412,482
24.05.200863148,313

Defects Per Million Opportunities

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Defects Per Million Opportunities 262,2 328,5 + 66,3 Score Minimize Manufacturing
Description The total number of defects divided by the total number of opportunities for a defect, multiplied by 1 Million (Six Sigma calculation).

Graph for Defects Per Million Opportunities

Graph for Defects Per Million Opportunities

Data for Defects Per Million Opportunities

DatesWeightMinMaxValue
05.04.200841501000262,2
12.04.200841501000506,15
19.04.200841501000941,35
26.04.200841501000520,6
03.05.200841501000797,7
10.05.200841501000959,2
17.05.200841501000827,45
24.05.200841501000328,5

Warehousing

  Name Start value End value Dynamic Parent Contains
Root Warehousing 22 % 55,48 % + 33,48% Supply Chain Balanced Scorecard
Indicators
Inventory Months of Supply
Number of Inventory Turns

Graph for Warehousing

Graph for Warehousing

Data for Warehousing

DatesValueWeight
05.04.2008221
12.04.200823,421
19.04.200815,081
26.04.200871,741
03.05.200819,241
10.05.200837,021
17.05.200821,581
24.05.200855,481

Inventory Months of Supply

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Inventory Months of Supply 3,23 42,56 + 39,33 % Maximize Warehousing
Description The total inventory units on hand divided by the average monthly usage.

Graph for Inventory Months of Supply

Graph for Inventory Months of Supply

Data for Inventory Months of Supply

DatesWeightMinMaxValue
05.04.200860953,23
12.04.2008609533,345
19.04.200860953,04
26.04.2008609582,745
03.05.2008609510,26
10.05.2008609526,125
17.05.200860951,615
24.05.2008609542,56

Number of Inventory Turns

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Number of Inventory Turns 27,525 22,125 -5,4 % Minimize Warehousing
Description The annual cost of sales divided by the average inventory cost level.

Graph for Number of Inventory Turns

Graph for Number of Inventory Turns

Data for Number of Inventory Turns

DatesWeightMinMaxValue
05.04.20084154027,525
12.04.20084154038,525
19.04.20084154031,775
26.04.20084154027,825
03.05.20084154032,025
10.05.20084154027,175
17.05.20084154027,15
24.05.20084154022,125

Transportation

  Name Start value End value Dynamic Parent Contains
Root Transportation 81,8 % 47,44 % -34,36% Supply Chain Balanced Scorecard
Indicators
Freight cost per unit shipped
Claims percentage for freight costs
Truckload capacity utilized
On time pickups *
* - Information for this metric is limited in sample report

Graph for Transportation

Graph for Transportation

Data for Transportation

DatesValueWeight
05.04.200881,83
12.04.200839,783
19.04.200849,513
26.04.200837,723
03.05.200851,023
10.05.200836,563
17.05.200853,933
24.05.200847,443

Freight cost per unit shipped

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Freight cost per unit shipped 117,89 91,44 -26,45 Score Minimize Transportation
Description Total freight costs divided by the number of units shipped per period.

Target description [$US]

Graph for Freight cost per unit shipped

Graph for Freight cost per unit shipped

Data for Freight cost per unit shipped

DatesWeightMinMaxValue
05.04.2008385200117,89
12.04.2008385200148,25
19.04.2008385200154,345
26.04.2008385200193,56
03.05.2008385200126,515
10.05.2008385200183,095
17.05.2008385200189,19
24.05.200838520091,44

Claims percentage for freight costs

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Claims percentage for freight costs 23,05 91,26 + 68,21 % Minimize Transportation
Description Total loss and damage claims divided by total freight costs, multiplied by 100.

Graph for Claims percentage for freight costs

Graph for Claims percentage for freight costs

Data for Claims percentage for freight costs

DatesWeightMinMaxValue
05.04.20083510023,05
12.04.20083510084,23
19.04.20083510041,48
26.04.20083510033,5
03.05.20083510063,045
10.05.20083510064,945
17.05.20083510026,755
24.05.20083510091,26

Truckload capacity utilized

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Truckload capacity utilized 81,09 16,92 -64,17 % Maximize Transportation
Description Total pounds shipped divided by the theoretical maximum for each traffic lane, multiplied by 100.

Graph for Truckload capacity utilized

Graph for Truckload capacity utilized

Data for Truckload capacity utilized

DatesWeightMinMaxValue
05.04.2008209081,09
12.04.2008209086,13
19.04.2008209037,26
26.04.2008209044,46
03.05.2008209054,36
10.05.2008209060,84
17.05.2008209066,06
24.05.2008209016,92

Customer satisfaction

  Name Start value End value Dynamic Parent Contains
Root Customer satisfaction 40,87 % 32,39 % -8,48% Supply Chain Balanced Scorecard
Indicators
Order Fill Rate
Transit time
Backorder
On Time Line Count *
Customer Order Promised Cycle Time *
* - Information for this metric is limited in sample report

Graph for Customer satisfaction

Graph for Customer satisfaction

Data for Customer satisfaction

DatesValueWeight
05.04.200840,873
12.04.200826,353
19.04.200833,413
26.04.200868,473
03.05.200867,983
10.05.200857,073
17.05.200846,073
24.05.200832,393

Order Fill Rate

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Order Fill Rate 41,515 34,58 -6,935 % Maximize Customer satisfaction
Description The amount of order lines shipped on the initial order (the first shipment out of the primary warehouse) divided by the amount total amount of lines ordered, multiplied by 100.

Graph for Order Fill Rate

Graph for Order Fill Rate

Data for Order Fill Rate

DatesWeightMinMaxValue
05.04.2008209541,515
12.04.2008209532,395
19.04.2008209522,61
26.04.2008209593,765
03.05.2008209520,995
10.05.2008209585,025
17.05.2008209541,135
24.05.2008209534,58

Transit time

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Transit time 10,272 11,872 + 1,6 Score Minimize Customer satisfaction
Description The number of days (hours) from the time a shipment leaves the facility to the time it arrives at the customer's location vs. standard transit time quoted by the carrier for each traffic lane.

Target description [days]

Graph for Transit time

Graph for Transit time

Data for Transit time

DatesWeightMinMaxValue
05.04.2008161410,272
12.04.2008161411,72
19.04.200816148,608
26.04.200816149,264
03.05.2008161411,696
10.05.2008161411,688
17.05.200816149,032
24.05.2008161411,872

Backorder

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Backorder 17,844 93,468 + 75,62 % Minimize Customer satisfaction
Description The amount of order lines that are not confirmed and past the requested delivery date divided by the total amount of lines ordered, multiplied by 100.

Graph for Backorder

Graph for Backorder

Data for Backorder

DatesWeightMinMaxValue
05.04.20081810017,844
12.04.20081810077,736
19.04.20081810033,484
26.04.20081810012,14
03.05.20081810041,304
10.05.20081810053,632
17.05.20081810017,2
24.05.20081810093,468

Financial performance

  Name Start value End value Dynamic Parent Contains
Root Financial performance 41,35 % 65,58 % + 24,23% Supply Chain Balanced Scorecard
Indicators
Cash to Cash Cycle Time
Material Value Add
COGS percentage
Year over Year change in COGS *
EBIT percentage *
SG&A percentage *
* - Information for this metric is limited in sample report

Graph for Financial performance

Graph for Financial performance

Data for Financial performance

DatesValueWeight
05.04.200841,352
12.04.200856,822
19.04.200841,022
26.04.200841,122
03.05.200866,842
10.05.200851,712
17.05.200846,212
24.05.200865,582

Cash to Cash Cycle Time

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Cash to Cash Cycle Time 11,536 6,056 -5,48 % Minimize Financial performance
Description The number of inventory days of supply plus days of sales outstanding minus average payment period for material.

Graph for Cash to Cash Cycle Time

Graph for Cash to Cash Cycle Time

Data for Cash to Cash Cycle Time

DatesWeightMinMaxValue
05.04.2008261411,536
12.04.2008261410,576
19.04.2008261411,48
26.04.200826148,304
03.05.200826146,624
10.05.200826147,088
17.05.200826148,672
24.05.200826146,056

Material Value Add

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Material Value Add 80,6 110,76 + 30,16 % Maximize Financial performance
Description The unit “sell price” minus material cost divided by material cost.

Graph for Material Value Add

Graph for Material Value Add

Data for Material Value Add

DatesWeightMinMaxValue
05.04.20081013080,6
12.04.20081013061,49
19.04.20081013076,05
26.04.20081013029,64
03.05.20081013035,62
10.05.2008101309,49
17.05.20081013022,75
24.05.200810130110,76

COGS percentage

  Name Start value End value Dynamic Measure units Optimization method Parent
Root COGS percentage 30,88 6,96 -23,92 % Maximize Financial performance
Description The cost of goods sold divided by total revenue, multiplied by 100.

Graph for COGS percentage

Graph for COGS percentage

Data for COGS percentage

DatesWeightMinMaxValue
05.04.2008208030,88
12.04.2008208050,08
19.04.200820809,84
26.04.2008208043,6
03.05.2008208069,12
10.05.2008208026,08
17.05.2008208033,2
24.05.200820806,96
Created by: AKS-Labs
Report created with Balanced Scorecard Designer at 28.04.2008 23:59:37

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