Cost per pound analysis

From UG

Revision as of 18:21, 16 November 2010 (edit) Alex (Talk | contribs) (→Cost per pound weekly change plot) ← Older edit		Revision as of 18:27, 16 November 2010 (edit) (undo) Alex (Talk | contribs) Newer edit →
Line 1:		Line 1:
	[[Category:Projects]]		[[Category:Projects]]
-	==== Core Need ====	+	== Parent mantis ==
		+	TBD
-	This report would allow Arden to compare their actual costs vs. their cost per pound rates for their budgeting purposes.  As well as assist them in shaping their vendor decisions.	+	== Requirements ==
-	===== Functionality & Summary =====	+	== Detailed Design ==
-	The concept for this is report is layered, to start at a top level and be able to drill down to more finite details.
-
-	* '''Top Level or First Layer''':
-	** The average number for the cost per lb, with filters
-	** Shippers - [[CT_bo#Pick_Up]]
-	** Consignees - [[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]]
-	** Carriers - [[CT_bo#Pick_Up_Trucker]]
-
-	== Detailed Design ==
	=== Formulas ===		=== Formulas ===

---

Revision as of 18:27, 16 November 2010

Contents 1 Parent mantis 2 Requirements 3 Detailed Design 3.1 Formulas 3.2 Daily change for all carriers report on a dashboard 3.3 Daily change per company plot 3.4 Cost per pound change for current week plot 3.4.1 Figure: Cost per pound per Carrier 3.4.2 Figure: Cost per pound per month 3.4.3 Figure: Cost per pound per Load

Parent mantis

TBD

Requirements

Detailed Design

Formulas

Cost per pond for load = (cost of load) / (weight of load in pounds) 

Average Estimated Cost Per Pound of Arden Domestic Trucking Operation in November 
   = Cost of all loads handled in November / 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

Daily change for all carriers report on a dashboard

Daily change per company plot

Cost per pound change for current week plot

Figure: Cost per pound per Carrier

Figure: Cost per pound per month

Figure: Cost per pound per Load