Cost per pound analysis
From UG
(Difference between revisions)
(→Figure: Cost per pound per Load) |
(→Cost per pound weekly change plot) |
||
| Line 33: | Line 33: | ||
[[File:Daily change per company.JPG]] | [[File:Daily change per company.JPG]] | ||
| - | === Cost per pound | + | === Cost per pound change for current week plot === |
[[File:Cost per pound plot of weekly change.JPG]] | [[File:Cost per pound plot of weekly change.JPG]] | ||
Revision as of 18:21, 16 November 2010
Contents |
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
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
