This calculator converts supplier quotations and shipment costs into SKU-level landed costs and minimum selling prices.
The tool does not hardcode a statutory duty rate.
Import costing workspace
Calculate shipment costs, SKU allocations, variances, landed cost per unit, and margin-based minimum prices.
Nigerian naira is the reporting currency. Foreign-currency values use the rates entered below.
Enter actual/forecast and budget/base naira costs. Customs and levies are entered per SKU.
| Cost category | Actual / Forecast (₦) | Budget / Base (₦) | Variance (₦) | Allocation basis |
|---|---|---|---|---|
| International freight | — | Selected method | ||
| Marine insurance | — | Selected method | ||
| Inspection charges | — | Selected method | ||
| Port and terminal charges | — | Selected method | ||
| Clearing-agent fees | — | Selected method | ||
| Demurrage / contingency | — | Selected method | ||
| Inland transportation | — | Selected method | ||
| Banking and transfer charges | — | Supplier value (actual) | ||
| Other import costs | — | Selected method | ||
| Total shipment costs | — | — | — |
Add up to 100 SKUs. Yellow cells are editable; grey cells are calculated.
| # | SKU | Description | Category | HS Code | Qty | Supplier Value (FCY) | Weight kg | Volume m³ | Manual % | Actual Customs & Levies | Budget Customs & Levies | Warranty | Target Margin % | Indicative Wholesale | Allocation % | Actual Supplier ₦ | Budget Supplier ₦ | Allocated Shipment | Allocated Inspection | Allocated Inland | Allocated Banking | Other Allocated | Total Landed | Landed / Unit | Budget Landed | FX Variance | Import Variance | Minimum Selling Price |
|---|
Actual/forecast performance compared with the budget/base case.
| SKU | Description | Qty | Allocation | Landed / Unit | Minimum Price | FX Variance | Import Variance |
|---|
