AN ORIGINAL KPIs for OpsTruck (concepts and requirements)

From UG

Revision as of 21:36, 11 November 2010 (edit) Denise (Talk | contribs) (→Requirements) ← Older edit		Revision as of 22:40, 11 November 2010 (edit) (undo) Denise (Talk | contribs) (→Functionality & Summary) Newer edit →
Line 17:		Line 17:
	===== Functionality & Summary =====		===== Functionality & Summary =====
-	The concept for this is report is tree structured.  To start with a top level based upon the total number of shipments and their total costs according to specific variables.	+	The concept for this is report is to start at a top level and be able to drill down to a finite level.
-	* At the top level, list the average for the cost per lb	+	* The top level, would list the average cost per lb
-	** This would be the average number based upon the total number of shipments and their total costs	+	** This is the average number based upon the total number of records and their total costs
-	* The second level would list the [[CT_bo#Pick_Up]]	+	* The next level would list the Shipper
-	* Consignee	+	** This is the Pickup Company's Name [[CT_bo#Pick_Up]]
-	* Lanes	+	* The next level would list the Consignee
		+	** This is the Delivery to Company's Name [[CT_bo#Export_Delivery_To]]
		+	* The next level would list the Lanes
		+	** This is both the Pickup Company's & the Delivery To Company's State & Zip - which is an attribute of the [[CT_bo#Export_Delivery_To]] object
	* Carrier		* Carrier
		+	** This is the Delivery Trucker's Name [[CT_bo#Pick_Up_Trucker]]
	* Utilization		* Utilization
		+	** This is the average weight per truck
		+	*** It is based upon the average number of pallets [[Commodity#Plts]] per truck, or the average number of loose packages [[Commodity#Loose_Pkgs]] per truck load
	=== Total cost REQ ===		=== Total cost REQ ===

---

Revision as of 22:40, 11 November 2010

Contents 1 Parent Mantis 2 Requirements 2.1 Cost per pound REQ 2.1.1 Core Need 2.1.1.1 Functionality & Summary 2.2 Total cost REQ 3 Design Ideas 3.1 Cost per pound DESIGN 3.2 Total cost DESIGN 4 Detailed Design 5 APPENDIX Old version of this wiki 5.1 Core needs 5.2 Reports 5.2.1 Exceptions report 5.2.2 Hold Bucket Measure Report 5.2.3 Time frames Report 5.2.4 Cost per pound Report 5.2.5 retroactive analysis 5.3 Types of output 5.3.1 Graphical Pie Chart Bar Etc report 5.3.2 Interactive maps 5.3.3 Excel files 5.3.4 Dashboard 5.3.5 Misc 6 History 6.1 Original ver

Parent Mantis

2489 0002489: [BI / KPI] (BA) create proposal for Arden

Requirements

There are number of reports required. See below.

Cost per pound REQ

Core Need

This report that would allow Arden to compare the actual costs vs. the cost per pound for budgeting purposes. As well as assist them in shaping their vendor decisions.

Functionality & Summary

The concept for this is report is to start at a top level and be able to drill down to a finite level.

• The top level, would list the average cost per lb
  • This is the average number based upon the total number of records and their total costs
• The next level would list the Shipper
  • This is the Pickup Company's Name CT_bo#Pick_Up
• The next level would list the Consignee
  • This is the Delivery to Company's Name CT_bo#Export_Delivery_To
• The next level would list the Lanes
  • This is both the Pickup Company's & the Delivery To Company's State & Zip - which is an attribute of the CT_bo#Export_Delivery_To object
• Carrier
  • This is the Delivery Trucker's Name CT_bo#Pick_Up_Trucker
• Utilization
  • This is the average weight per truck
    • It is based upon the average number of pallets Commodity#Plts per truck, or the average number of loose packages Commodity#Loose_Pkgs per truck load

Total cost REQ

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

History

Original ver

http://mantis.jaguarfreight.com/mediawiki-1.15.0/index.php?title=BI_and_KPIs_for_OpsTruck&oldid=16496