AN ORIGINAL KPIs for OpsTruck (concepts and requirements)

From UG

(Difference between revisions)
Jump to: navigation, search
(Requirements)
Line 10: Line 10:
The concept is to make them layered: to start at a top level and be able to drill down to more finite details.
The concept is to make them layered: to start at a top level and be able to drill down to more finite details.
 +
 +
== Design Ideas ==
=== Cost per pound analysis ===
=== Cost per pound analysis ===
Line 19: Line 21:
See [[Total cost analysis]]
See [[Total cost analysis]]
-
===== Functionality & Summary =====
+
=== Average times ===
-
 
+
-
The concept for this is report is very similar to the cost per pound report; in that it is layered, starting at a top level and being able to drill down.
+
-
 
+
-
* '''Top Level or First Layer''':
+
-
** The average number for the total costs
+
-
** Shipper [[CT_bo#Pick_Up]]
+
-
** Consignee [[CT_bo#Export_Delivery_To]]
+
-
** Lanes: Origin Company's Name, City, State & Zip, [[CT_bo#Pick_Up]] & the Destination Company's Name, City, State & Zip [[CT_bo#Export_Delivery_To]]
+
-
** Carrier [[CT_bo#Pick_Up_Trucker]]
+
-
** Utilization [[Commodity#Plts]] or [[Commodity#Loose_Pkgs]]
+
-
 
+
-
== Design Ideas ==
+
-
 
+
-
=== Cost per pound DESIGN ===
+
-
=== Total cost DESIGN ===
+
-
 
+
-
== Detailed Design ==
+
-
 
+
-
Denise with help of Alex or Andrei
+
-
 
+
-
OR
+
-
 
+
-
Alex or Andrei
+
-
 
+
-
== 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
+
 +
See [[Average times]]
== History ==
== History ==

Revision as of 19:15, 16 November 2010


Contents

Parent Mantis

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

Requirements

There are number of reports required. See below.

The concept is to make them layered: to start at a top level and be able to drill down to more finite details.

Design Ideas

Cost per pound analysis

See Cost per pound analysis

Total cost analysis

See Total cost analysis

Average times

See Average times

History

Original ver

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