Cost per pound analysis

From UG

Revision as of 21:03, 15 November 2010 (edit) Alex (Talk | contribs) (Created page with 'Category:Projects') ← Older edit		Revision as of 21:08, 15 November 2010 (edit) (undo) Alex (Talk | contribs) Newer edit →
Line 1:		Line 1:
	[[Category:Projects]]		[[Category:Projects]]
		+
		+	==== 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.
		+
		+	===== 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

---

Revision as of 21:08, 15 November 2010

Contents 1 Core Need 1.1 Functionality & Summary 2 Detailed Design 2.1 Formulas

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.

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