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


Supply Chain Balanced Scorecard

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

  Name Start value End value Dynamic Contains
Root Supply Chain Balanced Scorecard 49,17 % 49,17 % 0 %
Manufacturing(53,1%, 0%)
Warehousing(44,9%, 0%)
Transportation(44,7%, 0%)
Customer satisfaction(55,5%, 0%)
Financial performance(46,5%, 0%)

Graph for Supply Chain Balanced Scorecard

Graph for Supply Chain Balanced Scorecard

Data for Supply Chain Balanced Scorecard

DatesValue
28.10.200849,17

Manufacturing

  Name Start value End value Dynamic Parent Contains
Root Manufacturing 53,08 % 53,08 % 0% Supply Chain Balanced Scorecard
Indicators
Manufacturing Cycle Time
Defects Per Million Opportunities

Graph for Manufacturing

Graph for Manufacturing

Data for Manufacturing

DatesValueWeight
28.10.200853,081

Manufacturing Cycle Time

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Manufacturing Cycle Time 10,524 10,524 0 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
28.10.2008631410,524

Defects Per Million Opportunities

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Defects Per Million Opportunities 274,95 274,95 0 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
28.10.200841501000274,95

Warehousing

  Name Start value End value Dynamic Parent Contains
Root Warehousing 44,86 % 44,86 % 0% Supply Chain Balanced Scorecard
Indicators
Inventory Months of Supply
Number of Inventory Turns

Graph for Warehousing

Graph for Warehousing

Data for Warehousing

DatesValueWeight
28.10.200844,861

Inventory Months of Supply

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Inventory Months of Supply 64,885 64,885 0 % 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
28.10.2008609564,885

Number of Inventory Turns

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Number of Inventory Turns 37,575 37,575 0 % 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
28.10.20084154037,575

Transportation

  Name Start value End value Dynamic Parent Contains
Root Transportation 44,7 % 44,7 % 0% 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
28.10.200844,73

Freight cost per unit shipped

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Freight cost per unit shipped 150,32 150,32 0 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
28.10.2008385200150,32

Claims percentage for freight costs

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Claims percentage for freight costs 95,82 95,82 0 % 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
28.10.20083510095,82

Customer satisfaction

  Name Start value End value Dynamic Parent Contains
Root Customer satisfaction 55,54 % 55,54 % 0% 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
28.10.200855,543

Order Fill Rate

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Order Fill Rate 39,805 39,805 0 % 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
28.10.2008209539,805

Transit time

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Transit time 6,848 6,848 0 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
28.10.200816146,848

Financial performance

  Name Start value End value Dynamic Parent Contains
Root Financial performance 46,53 % 46,53 % 0% 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
28.10.200846,532

Cash to Cash Cycle Time

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Cash to Cash Cycle Time 10,832 10,832 0 % 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
28.10.2008261410,832

Material Value Add

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Material Value Add 38,61 38,61 0 % 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
28.10.20081013038,61
Created by: AKS-Labs
Report created with Balanced Scorecard Designer at 20.11.2008 17:31:55

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