AN ORIGINAL KPIs for OpsTruck (concepts and requirements)

From UG

(Difference between revisions)
Jump to: navigation, search
(Original ver)
Line 5: Line 5:
0002489: [BI / KPI] (BA) create proposal for Arden  
0002489: [BI / KPI] (BA) create proposal for Arden  
-
== Core needs ==
+
== Requirements ==
 +
 
 +
 
 +
== APPENDIX Old version of this wiki ==
 +
=== Core needs ===
* domestic KPI dashboard/reporting tool)
* domestic KPI dashboard/reporting tool)
Line 25: Line 29:
* data analysis
* data analysis
-
== Reports ==
+
=== Reports ===
-
=== Exceptions report ===
+
==== Exceptions report ====
* High delta from create to approved
* High delta from create to approved
Line 34: Line 38:
* ...
* ...
-
=== Hold Bucket Measure Report ===
+
==== Hold Bucket Measure Report ====
* average time in hold bucket
* average time in hold bucket
* include value of shipments
* include value of shipments
-
=== Time frames Report ===
+
==== Time frames Report ====
* Created to approved
* Created to approved
Line 46: Line 50:
* pick up to delivery
* pick up to delivery
-
=== Cost per pound Report ===
+
==== Cost per pound Report ====
* Look at cost per LB before dispatching?
* Look at cost per LB before dispatching?
Line 52: Line 56:
-
=== retroactive analysis ===
+
==== retroactive analysis ====
-
== Types of output ==
+
=== Types of output ===
-
=== Graphical Pie Chart Bar Etc report ===
+
==== Graphical Pie Chart Bar Etc report ====
-
=== Interactive maps ===
+
==== Interactive maps ====
-
=== Excel files ===
+
==== Excel files ====
-
=== Dashboard ===
+
==== Dashboard ====
-
=== Misc ===
+
==== Misc ====
* columns on Marc's spreadsheet (output/filters)
* columns on Marc's spreadsheet (output/filters)
Line 71: Line 75:
** ultilisation
** ultilisation
-
== Detailed Requirements ==
 
== History ==
== History ==

Revision as of 21:24, 9 November 2010


Contents

Parent Mantis

0002489: [BI / KPI] (BA) create proposal for Arden

Requirements

APPENDIX Old version of this wiki

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
  • data analysis

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

Types of output

Graphical Pie Chart Bar Etc report

Interactive maps

Excel files

Dashboard

Misc

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


History

Original ver

http://mantis.jaguarfreight.com/mediawiki-1.15.0/index.php?title=BI_and_KPIs_for_OpsTruck&oldid=16496

Personal tools