KPI v2

From UG

Revision as of 02:25, 26 September 2013 (edit) Alex (Talk | contribs) (→Shipments Per Lane KPI) ← Older edit		Revision as of 02:49, 26 September 2013 (edit) (undo) Alex (Talk | contribs) (→Shipments Per Lane KPI) Newer edit →
Line 82:		Line 82:
	If "period" is 3 weeks or less, show the "average shipment for this week"		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'		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.		Example 1.
Line 93:		Line 99:
	GRP3    B          Y		GRP3    B          Y
	GRP4    B          Y		GRP4    B          Y
-
	unique lanes: AX, BY		unique lanes: AX, BY
	number of shipments = 6		number of shipments = 6
	number of lanes = 2		number of lanes = 2
-	average shipments per lane = 6/2 = 3	+	average shipments per lane = number of shipments / number of lanes = 6/2 = 3
-	Left panel:	+	'''Left panel''' and '''Top Right Panel'''
-		+
-	* one KPi value per week	+
-	* for all weeks for 2011, 2012, 2013 (partial)	+
-	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:	+	'''Bottom Right Panel:'''
	== EU class ==		== EU class ==

---

Revision as of 02:49, 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 link 5 KPIs Homepage 5.1 WMQY selector 5.2 Filters 5.3 KPI class Tab 5.4 Individual KPi selector 5.5 Summary Panel 5.6 Settings Panel 5.7 Left Panel 5.8 Top Right Panel 5.9 Bottom Right Panel 6 Volumes class 7 CPU class 8 Lead Times class 9 LO class 9.1 Shipments Per Lane KPI 10 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 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

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