KPI v2

From UG

Contents 1 Info 2 Overview 2.1 Internal App Components 2.2 Client App Components 3 KPI Admin 3.1 KPI Settings Panel 3.2 Edit KPI Panel 4 KPIs core logic 4.1 Association between WQMY and record 4.2 Exclusion logic 4.2.1 Exclusion if shipment is deleted or alike 4.2.2 Exclusion if parameter in KPI formula is undefined 4.2.3 Exclusion if need to divide by zero 5 KPIs UI 5.1 KPIs link 5.2 KPIs Homepage 5.3 WMQY selector 5.4 Filters 5.5 KPI class Tab 5.6 Individual KPi selector 5.7 Summary Panel 5.8 Settings Panel 5.9 Left Panel 5.10 Top Right Panel 5.11 Bottom Right Panel 6 Drilldowns 6.1 xls 6.1.1 header 7 KPI classes 7.1 Volumes class 7.1.1 CT count 7.1.2 Total Spend 7.1.3 Gross KG 7.1.4 CWT KG 7.1.5 CBM 7.1.6 TEU 7.2 CPU class 7.3 Lead Times class 7.4 LO class 7.4.1 Shipments Per Lane KPI 7.5 EU class

Info

Overview

KPI module consists of the following components:

Internal App Components

• #KPI Admin

Client App Components

• [[]]

KPI Admin

Consists of:

• #KPI Settings Panel

• #Edit KPI Panel

KPI Settings Panel

Edit KPI Panel

KPIs core logic

Association between WQMY and record

We formulate it in terms of CT and not Shipment#Shipment.

For every KPI we need to decide what criteria to use to associate CT with a particular week/month/Quarter/Year.

Same association criteria for all classes of KPIs now:

Air/Ocean: CT#Destination Port Actual Arrival Date
or 
Truck modes: CT#Destination Door Actual Delivery Date

Exclusion logic

Exclusion if shipment is deleted or alike

Exclude CTs that are:

• canceled or
• deleted or
• rejected (from ASN)

Exclusion if parameter in KPI formula is undefined

Examples:

• If KPI is a time frame then exclude shipments that have only one out of two dates/times that define the interval present in the system.

• In CPUs if cost is undefined or unit is undefined

Exclusion if need to divide by zero

KPIs UI

KPIs link

KPIs Homepage

WMQY selector

Radio type control that has 4 values:

• Wk
• Mo
• Qtr
• Yr

Selection will affect what is displayed on all panels.

Filters

KPI class Tab

Individual KPi selector

Summary Panel

Settings Panel

Left Panel

Top Right Panel

Bottom Right Panel

Drilldowns

xls

header

Consists of lines:

FlashLight	
<date generated>	
<class name>	
KPI name: <KPI name>
Number of matches: <number of CTs included into output OR numb of records in output including commode lines ? >
Client Company: 	<Filter value>
Mode of Transport: <Filter value>	
TimeFrame: 	<WMQY value>
Currency: 	<value set in ???>
Additional filters: 																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																															
Shipper:	<Filter value>	
<more filters>																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																											

Example:
-------
FlashLight	 
26-Sep-2013	
Volumes KPI	
KPI name:	CT Count
Number of shipments: 	13
Client Company: 	Elizabeth Arden
Mode of Transport: 	Air
TimeFrame: 	Week 30 (22–28 Jul 2013)
Currency: 	USD
Additional filters: 																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																															
Shipper:	ELIZABETH ARDEN - Roanoke - 1751 blue hills

KPI classes

Volumes class

CT count

Left and Top Right panels:

• Number of CTs that satisfy Association, Inclusion, Filters and WMQY criterias.

Total Spend

Gross KG

• Commodity#Grand_Total:_Gross_Kg

CWT KG

• Air only
• CT#Chargeable_Weight

CBM

• (LCL only)

TEU

• (FCL only)

CPU class

Lead Times class

LO class

Shipments Per Lane KPI

• Definitions:
  • Shipment#Shipment
  • Shipment#Lane

• label: "Weekly/ Monthly Avg Shipments per Lane"

• definition: This shows how many shipments there are on average per lane per week or month

Weekly: Weekly Average   
Monthly: Month Average   
Quarter: Total Quarter Count - divided by 3 month (average per month)   
Annual: Total annual count - divided by 12 month (average per month)

• hint label:

If "period" is 3 weeks or less, show the "average shipment for this week"   
If "period" is 1 month or more: Show  'average shpt count per month for this period'  

Formula 1 
---------
Average shipments per lane = number of Shipments / number of Lanes
. 
Note: above is for specific timeframe, for specific filters applied

Example 1.
=======
Shnt#  Shipper  Consignee
---------------------- 
CT1     A           X
CT2     A           X
GRP1    B           Y
GRP2    A           X
GRP3    B           Y
GRP4    B           Y
unique lanes: AX, BY
number of shipments = 6
number of lanes = 2
average shipments per lane = number of shipments / number of lanes = 6/2 = 3

Left panel and Top Right Panel

• one KPi value per week/month/quarter/year
• for data for 2011, 2012, 2013 (partial), ordered, latest at the top

Bottom Right Panel:

EU class