Cost per pound analysis

From UG

Revision as of 18:05, 16 November 2010 (edit) Alex (Talk | contribs) (→Figure: Cost per pound per month) ← Older edit		Current revision as of 15:21, 15 April 2011 (edit) (undo) Alex (Talk | contribs) (Replaced content with 'Category:XArc See KPIs_for_OpsTruck_phase_1')
(7 intermediate revisions not shown)
Line 1:		Line 1:
-	[[Category:Projects]]	+	[[Category:XArc]]
-	==== Core Need ====
-	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.	+	See [[KPIs_for_OpsTruck_phase_1]]
-		+
-	===== Functionality & Summary =====	+
-		+
-	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 ===	+
-		+
-	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 ===	+
-	[[File:Home.JPG]]	+
-		+
-	=== Daily change per company plot ===	+
-	[[File:Daily change per company.JPG]]	+
-		+
-	=== Cost per pound weekly change plot ===	+
-	[[File:Cost per pound plot of weekly change.JPG]]	+
-		+
-	==== Figure: Cost per pound per Carrier ====	+
-	[[File:Cost per pound per Carrier.JPG]]	+
-		+
-	==== Figure: Cost per pound per month ====	+
-		+
-	[[File:Cost per pound per Month.JPG]]	+
-		+
-	==== Figure: Cost per pound per Load ====	+

---

Current revision as of 15:21, 15 April 2011

See KPIs_for_OpsTruck_phase_1