Shipping Cost per Weight for Microsoft Dynamics 365 Business Central
Freight budgets built on cost per shipment break down when shipments get heavier or lighter, because carriers charge by weight. Dynamic Ship Analysis gauges the average cost per unit of shipment weight, shown as average spend per pound. This is a completely free app from Insight Works for Business Central.
The figure is calculated from the shipments and weights Dynamic Ship records in Business Central, next to average spend per shipment and per package.
How Shipping cost per weight works in Dynamic Ship Analysis
- Dynamic Ship records shipments, packages, carriers, and freight costs in Business Central as your team ships.
- An administrator installs the Business Central extension that supplies the report data, then installs the Dynamic Ship Analysis Power BI app from Microsoft Marketplace and connects it to the same Business Central environment.
- A finance or logistics user opens the Shipping Overview page and sets filters for the period and slice they are budgeting.
- They read average spend per pound, per shipment, and per package, and use them in the freight budget.
Key capabilities
Average spend per pound
The summary statistics show average shipping spend per pound for the filtered shipments.
Three averages together
Average spend per shipment, per package, and per pound appear side by side, so a change in one can be explained by the others.
Narrowed by filters
Filter by location, customer, shipping agent, or service level to see the cost per pound for that slice. See Shipping Spend by Carrier for the carrier view.
Totals for context
Total spend, total shipments, and total packages sit with the averages.
See Shipping cost per weight on screen
Real screens from Dynamic Ship Analysis, shown with demo data.
Details that matter on the floor
Weight explains cost changes
When cost per shipment rises but cost per pound holds steady, heavier shipments are the reason; when cost per pound rises, rates or service choices are worth a look.
Who uses Shipping cost per weight
Financial analysts and controllers
Budget freight on cost per pound as well as cost per shipment.
Logistics managers
Compare cost per pound between carriers, service levels, and locations.
Questions about Shipping cost per weight
Can I see shipping cost per pound in Business Central?
Yes, with Dynamic Ship Analysis and Dynamic Ship. The Shipping Overview page shows average spend per pound in its summary statistics.
Is cost per weight shown by carrier?
Filter the report by shipping agent to see the summary statistics, including average spend per pound, for one carrier.
Where does the weight come from?
From the shipments Dynamic Ship records in Business Central.
Related Dynamic Ship Analysis features
All Dynamic Ship Analysis features →Part of Dynamic Ship Analysis
Analyze your Dynamic Ship shipping costs and trends in Power BI.
Have a question about Shipping cost per weight?
Send us a note and the Dynamic Ship Analysis team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
