AN ORIGINAL KPIs for OpsTruck (concepts and requirements)
From UG
Contents |
Parent Mantis
2488: [Arden KPI]......... <proj>
Requirements
Glossary
- KPI (Key Performance Indicator) - see http://en.wikipedia.org/wiki/KPI
- Arden Trucking Project - this is an evolving project of supporting Transportation and Supply Chain needs for Arden. Some components that have been added to CT2 for this project:
Core need
It is to provide a number of KPIs for Arden management for Arden Trucking Project
Phase 1
We agreed to provide the following KPIs for Phase 1:
- Cost:
- Cost per pound
- Total cost
- Time:
- Created to Approved
- Created to Hold
- Approved to Routed
- Routed to Pick Up
- Pick up to Delivery
- On hold
Design
Drill down. Should have several levels. Start at a top level (on a dashboard level with a minimal info) and be able to drill down to more finite details (down to the load / CT).
Standardization. For every KPI approach to UI design should be similar in principle and as standard as possible.
Report types. For every KPI provide the following report types:
- dashboard version
- KPI as a function of time
- KPI as a function of various variables such as CT fields (examples: Carrier, Shipper, Origin State, etc)
- bar layout
- pie layout
- map layout
Filters. Provide set of standard filters. Ideally every CT field should be represented by a multiselect filter.
Fields on CT/Load version. On this type of report ideally:
- list columns should cover all CT fields
- user should be able to manage order of columns and what columns are included and what are excluded
Personalization. Some settings should be configured in a user or / and Client profile. Example: some users might want to see year-to-date cost on a dashboard and some month-to-date cost.
Design Ideas
Level 1: Dashboard
If user clicks on any number on dashboard system will take it to the Level 2
Level 2: Axis X is time
If user clicks on any specific area of the plot then system will take user to the Level 3 and display information related to that area.
Level 2: Axis X is Selected Carriers and Report type is Bar Chart
If user clicks on any specific area of the plot then system will take user to the Level 3 and display information related to that area. For example if user clicks on UPS bar then on Level 3 we will see only UPS loads.
Level 2: Cost per pound Axis X is Selected Shippers and Report type is Map
Level 3: Load and CT level
SA Notes
Formulas and mapping for Cost KPIs
Total cost:
Total cost for day X = Cost of all loads delivered on day X
Cost per pound:
Cost per pond for load = (cost of load) / (weight of load in pounds)
Cost Per Pound for day X = Cost of all loads delivered on day X / total weight of these loads
Average Estimated Cost Per Pound of YRC in November = Cost of all loads handled in November by YRC / total weight of these loads
Formulas and mapping for Time KPIs
All numbers below should have 2 decimals.
KPIs below are measures in time elapsed (in days) between 2 dates in the system.
For dates that may be set and re-set use earliest or lates date - whichever is available in the system. Example: for Created to Hold - measure from created to first/last time on hold.
- Created to Approved
- Created to Hold - from created to first time on hold
- Approved to Routed
- Routed to Pick Up
- Pick up to Delivery
On hold - time elapsed (in days) during which CT has "On hold" status.
Mapping:
- Created - CT#Created On Date
- Approved - CT#Approved On
- Hold
- Routed - timestamp when CT#Pick Up Trucker or CT#Delivery Trucker is set
- Pick Up - CT#Actual Export Pick Up Date
- Delivery - CT#Actual Delivery Date
Note about Maps
Maps are desirable but not required for all types of reports
History
Original ver
Rewrite based on feedback from Simon and Marc
Links to old designs:
See Average times
See Maps