AI Blocks › Track your numbers
Landed cost allocator
Paste freight, duty and supplier invoices. Get the true landed cost per unit for each product.
Landed cost allocator is a free AI skill for the job "Track your numbers". Give the instructions to an AI assistant that supports the required files and tools, then review its output.
Free · No account · Made by AI Blocks
What it does
One container or shipment usually holds several products, but the freight and duty come as single lumps on a few invoices. Split them evenly and a small, cheap item carries the cost of a big, heavy one. Your margin per product is then wrong, and so are your prices and your ad budget for each. This skill starts with the purchase price per unit and adds every cost to get stock to your shelf. Each lump cost is spread on a basis that fits it. Duty is a percentage of goods value, so by default it follows value. Freight is driven by weight or volume, so it follows those. This split is the skill's suggestion, not an accounting rule, and it states the basis it used. Landed cost per unit is each product's total divided by units received. For one product and a quote check, use the landed cost calculator.…
You give it
- Purchase order lines: product, units, unit price, and weight or volume per unit
- Freight, container, duty, tariff and insurance invoices for the shipment
- Retail packaging cost per unit
- Selling price per product, and the lowest margin you accept (optional)
- Document (optional)
You get
- Landed cost per unit for each product, with each layer shown
- The basis used for each lump cost, and why
- Margin per unit, and products below your floor
- A checklist of costs that often arrive late
Use it when
- A shipment with several products arrived and you need a cost per unit for each one.
- Freight, duty or exchange rates changed and your cost per unit is out of date.
- You want margin per product after the true cost of getting it to your shelf.
How to use it
- Start a chat with the skill. Open it if you added it to your AI, or copy it and paste it in.
- Paste the order lines with units, price and weight or volume. Paste each freight and duty invoice with its amount and currency.
- Say your selling prices and the margin floor below which you would not sell.
- Check the basis it chose for each lump, and change it if your invoice says otherwise.
- Rerun it when prices, currency or tariffs change.
Workflows that use it
- Build a monthly P&L and know your real margin
- Plan the cash for your next stock order
- Monthly profit close