KPI v2

From UG

Revision as of 02:49, 26 September 2013 (edit) Alex (Talk | contribs) (→Shipments Per Lane KPI) ← Older edit		Revision as of 17:20, 26 September 2013 (edit) (undo) Alex (Talk | contribs) Newer edit →
Line 25:		Line 25:
	==== Edit KPI Panel ====		==== Edit KPI Panel ====
-	== KPIs link ==	+	== KPIs core logic ==
-	== KPIs Homepage ==	+	=== 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 ===		=== WMQY selector ===
Line 55:		Line 91:
	=== Bottom Right Panel ===		=== Bottom Right Panel ===
-	== Volumes class ==	+	== KPI classes ==
		+
		+	=== Volumes class ===
-	== CPU class ==	+	=== CPU class ===
-	== Lead Times class ==	+	=== Lead Times class ===
-	== LO class ==	+	=== LO class ===
-	=== Shipments Per Lane KPI ===	+	==== Shipments Per Lane KPI ====
	* Definitions:		* Definitions:
Line 111:		Line 149:
	'''Bottom Right Panel:'''		'''Bottom Right Panel:'''
-	== EU class ==	+	=== EU class ===

---

Revision as of 17:20, 26 September 2013

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 KPI classes 6.1 Volumes class 6.2 CPU class 6.3 Lead Times class 6.4 LO class 6.4.1 Shipments Per Lane KPI 6.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

KPI classes

Volumes class

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