AN ORIGINAL KPIs for OpsTruck (concepts and requirements)
From UG
Contents |
Parent Mantis
0002489: [BI / KPI] (BA) create proposal for Arden
Requirements
Design Ideas
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