AN ORIGINAL KPIs for OpsTruck (concepts and requirements)

From UG

Revision as of 21:02, 26 October 2010 (edit) Alex (Talk | contribs) ← Older edit		Revision as of 23:07, 26 October 2010 (edit) (undo) Alex (Talk | contribs) (→Reports) Newer edit →
Line 22:		Line 22:
	== Reports ==		== Reports ==
-	* Exception reports	+	=== Exceptions report ===
-	* Measure Hold Bucket Report	+	* High delta from create to approved
-	** average time in hold bucket	+	* ... Unusually high charge
-	** include value of shipments	+	* Spike / acceleration of monthly cost on trade line
		+	* ...
-	* Time frames Report:	+	=== Hold Bucket Measure Report ===
-	** Created to approved	+
-	** approved to dispatch	+	* average time in hold bucket
-	** dispatch to pick up	+	* include value of shipments
-	** pick up to delivery	+
		+	=== Time frames Report ===
		+
		+	* Created to approved
		+	* approved to dispatch
		+	* dispatch to pick up
		+	* pick up to delivery
		+
		+	=== Cost per pound Report ===
	* Look at cost per LB before dispatching?		* Look at cost per LB before dispatching?
	** Include cost per LB in calibration?		** Include cost per LB in calibration?
-	* retroactive analysis?	+
		+	=== retroactive analysis ===
		+
		+	=== Misc ===
	* columns on Marc's spreadsheet (output/filters)		* columns on Marc's spreadsheet (output/filters)
Line 47:		Line 59:
	** Dates		** Dates
	** ultilisation		** ultilisation
-
	== Detailed Requirements ==		== Detailed Requirements ==

---

Revision as of 23:07, 26 October 2010

Contents 1 Core needs 2 Reports 2.1 Exceptions report 2.2 Hold Bucket Measure Report 2.3 Time frames Report 2.4 Cost per pound Report 2.5 retroactive analysis 2.6 Misc 3 Detailed Requirements

Core needs

• domestic KPI dashboard/reporting tool)

• Shape our vendor decisions (Babushak)
  • example: can we find supplier closer to EM (consumer) who can fulfill supply needs (this reduces transp cost, transit time)

• What is it costing us?

• time frames

• separation of exceptions between usual .... day to day

• Simon: desirable output for this report would be a graphical view of origin/destination pairs and “hot spotting” of the main points, with the ability to drill-down to a granular level of detail.
  • need main points (major supplier). On the map.
  • Cluster analysis
  • frequency of ship froms

Reports

Exceptions report

• High delta from create to approved
• ... Unusually high charge
• Spike / acceleration of monthly cost on trade line
• ...

Hold Bucket Measure Report

• average time in hold bucket
• include value of shipments

Time frames Report

• Created to approved
• approved to dispatch
• dispatch to pick up
• pick up to delivery

Cost per pound Report

• Look at cost per LB before dispatching?
  • Include cost per LB in calibration?

retroactive analysis

Misc

• columns on Marc's spreadsheet (output/filters)
  • Cost per LB
  • shipper
  • consignee
  • Lanes
  • carrier
  • Dates
  • ultilisation

Detailed Requirements