AN ORIGINAL KPIs for OpsTruck (concepts and requirements)
From UG
(Difference between revisions)
(→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 | ||
- | |||
== 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