DL-066 · Case study
Cross-border landed-cost analytics for an apparel importer
A Canadian apparel company needed to understand true profitability by product after allocating international freight, duties and other import-related costs.
- Client
- Name withheld
- Location
- Canada
- Industry
- Apparel import and distribution
- Capabilities
- 01Audit03Build
01
Challenge
- Product margin reports used purchase cost without reliably allocating import expenses.
- Freight invoices and customs charges were handled separately from item profitability.
- Commercial teams lacked a consistent view of landed cost by shipment and SKU.
02
Environment
- Oracle NetSuite.
- Freight forwarder documents, customs broker files and purchasing records.
- Shopify and Amazon Canada sales data.
03
Intervention
- Designed a landed-cost allocation model across purchase orders and shipment lines.
- Integrated available freight, customs and invoice records.
- Created reconciliation and approval workflows for unmatched shipment expenses.
- Built product profitability models distinguishing landed cost from downstream selling costs.
04
Outcome
- More accurate SKU-level cost visibility.
- Better financial traceability for international purchasing.
- Commercial pricing decisions supported by more complete margin data.
- 01PURCHASE ORDERSLines→FREIGHT / CUSTOMSInvoices
- 02FREIGHT / CUSTOMSInvoices→ALLOCATIONLanded cost
- 03ALLOCATIONLanded cost→NETSUITEERP
- 04NETSUITEERP→SKU MARGINProfitability
Stack and services.
Stack02
Services used01
Tell us what has to work.
A senior engineer reads every brief. Describe the system, what it runs on today and what happens when it fails.
Discuss a project→