|
|
Line 10: |
Line 10: |
| | | |
| The concept is to make them layered: to start at a top level and be able to drill down to more finite details. | | The concept is to make them layered: to start at a top level and be able to drill down to more finite details. |
| + | |
| + | == Design Ideas == |
| | | |
| === Cost per pound analysis === | | === Cost per pound analysis === |
Line 19: |
Line 21: |
| See [[Total cost analysis]] | | See [[Total cost analysis]] |
| | | |
- | ===== Functionality & Summary ===== | + | === Average times === |
- | | + | |
- | The concept for this is report is very similar to the cost per pound report; in that it is layered, starting at a top level and being able to drill down.
| + | |
- | | + | |
- | * '''Top Level or First Layer''':
| + | |
- | ** The average number for the total costs
| + | |
- | ** Shipper [[CT_bo#Pick_Up]]
| + | |
- | ** Consignee [[CT_bo#Export_Delivery_To]]
| + | |
- | ** Lanes: Origin Company's Name, City, State & Zip, [[CT_bo#Pick_Up]] & the Destination Company's Name, City, State & Zip [[CT_bo#Export_Delivery_To]]
| + | |
- | ** Carrier [[CT_bo#Pick_Up_Trucker]]
| + | |
- | ** Utilization [[Commodity#Plts]] or [[Commodity#Loose_Pkgs]]
| + | |
- | | + | |
- | == Design Ideas ==
| + | |
- | | + | |
- | === Cost per pound DESIGN ===
| + | |
- | === Total cost DESIGN ===
| + | |
- | | + | |
- | == 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
| + | |
| | | |
| + | See [[Average times]] |
| | | |
| == History == | | == History == |
There are number of reports required. See below.
The concept is to make them layered: to start at a top level and be able to drill down to more finite details.