Cost per pound analysis

From UG

Revision as of 18:27, 16 November 2010 (edit) Alex (Talk | contribs) ← Older edit		Revision as of 18:30, 16 November 2010 (edit) (undo) Alex (Talk | contribs) Newer edit →
Line 27:		Line 27:
	[[File:Cost per pound plot of weekly change.JPG]]		[[File:Cost per pound plot of weekly change.JPG]]
-	==== Figure: Cost per pound per Carrier ====	+	=== Cost per pound per Carrier ===
	[[File:Cost per pound per Carrier.JPG]]		[[File:Cost per pound per Carrier.JPG]]
-	==== Figure: Cost per pound per month ====	+	=== Figure: Cost per pound per month ===
-		+
	[[File:Cost per pound per Month.JPG]]		[[File:Cost per pound per Month.JPG]]
-	==== Figure: Cost per pound per Load ====	+	=== Figure: Cost per pound per Load ===
-		+
	[[File:Cost per pound per Load.JPG]]		[[File:Cost per pound per Load.JPG]]

---

Revision as of 18:30, 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.5 Cost per pound per Carrier 3.6 Figure: Cost per pound per month 3.7 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

Cost per pound per Carrier

Figure: Cost per pound per month

Figure: Cost per pound per Load