AN ORIGINAL KPIs for OpsTruck (concepts and requirements)

From UG

(Difference between revisions)
Jump to: navigation, search
(Core needs)
Line 1: Line 1:
[[Category:OpsTruck]]
[[Category:OpsTruck]]
 +
== Parent Mantis ==
 +
 +
0002489: [BI / KPI] (BA) create proposal for Arden
== Core needs ==
== Core needs ==

Revision as of 14:43, 28 October 2010


Contents

Parent Mantis

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

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

Detailed Requirements

Personal tools