AN ORIGINAL KPIs for OpsTruck (concepts and requirements)
From UG
(Difference between revisions)
(→Detailed Requirements) |
(→Original ver) |
||
| Line 76: | Line 76: | ||
=== Original ver === | === Original ver === | ||
| + | |||
| + | http://mantis.jaguarfreight.com/mediawiki-1.15.0/index.php?title=BI_and_KPIs_for_OpsTruck&oldid=16496 | ||
Revision as of 21:22, 9 November 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
