Multi-SKU batch simulator

Multi-SKU Lot Simulator: the P&L of the entire order, reference by reference

Up to 40 references on the same sheet. Distributes freight by billable weight and fixed shipping costs by value, units, or weight, and tells you what margin the entire lot leaves and which reference is dragging it down. Free, no registration, and no AI.

An order of twelve references is not the same calculator repeated twelve times. Freight and customs are for the shipment, not the product, and depending on how you distribute them, one reference may seem more profitable than another.

The lot simulator of Temu's import cost and resale margin calculator at AiToolsForApps (https://aitoolsforapps.com/import-cost-and-resale-margin-calculator-247) works with the entire order: one line per reference, with its units, purchase price, selling price, weight, dimensions, and tariff category. Up to 40 references in the same lot.

What sets it apart is the distribution. Freight is allocated by BILLABLE WEIGHT, which is what the carrier actually charges you: for each reference, it takes the greater of its actual weight and its volumetric weight (length x width x height divided by the carrier's divisor) and multiplies it by the units. The fixed shipping costs (customs clearance and management) are fixed per shipment, so you choose the distribution: by merchandise value, by units, or by weight. Changing this basis alters which reference appears profitable, and that’s why it’s your decision and not our assumption.

With its piece of freight and its piece of clearance, each line is calculated as an independent mini-shipment. Thus, the tariff and import VAT of each reference come out with the rate of ITS category, not an average of the lot (and if you know the exact rate, you can write it manually on that line). For each reference, you see the landed cost per unit, the margin per unit and as a percentage, the freight and clearance assigned to it, its billable weight, its tariff, its import VAT, and its minimum selling price.

Above is the P&L of the entire lot: what you spend, the net income, the margin in money and percentage, and the return on your investment. Below, the ranking of which reference pulls the margin and which drags it down, with the complete table sorted, and the references sold at a loss marked in red with a warning of how many there are. All calculations are deterministic, instantaneous, and free: saving the lot and exporting it in PDF or CSV is the only thing that requires an account.

No sign-up

Try Multi-SKU batch simulator right here

Loading the tool…

Use it free without an account. If you want to save your result, you can sign up afterwards.

Save / Sign up

Benefits of Multi-SKU batch simulator

Up to 40 references in a single lot

the actual order, not a sample product. Each line with its units, purchase price, selling price, weight, dimensions, and category.

Freight is distributed by billable weight, not equally

for each reference, it takes the greater of actual weight and volumetric weight and multiplies it by its units. This is the criterion used by the carrier, so the distribution resembles the invoice.

You choose how to allocate the fixed shipping costs

by value, by units, or by weight. The dispatch and management are fixed per shipment, and there is no universal 'correct' allocation; changing the basis changes the ranking, and the simulator lets you see it with a touch.

Ventaja 4

Each line is calculated as a mini-shipment with its portion, so the tariff is based on the type of its category and not on an average of the batch. You can inherit the category from the batch or assign one to each reference, and manually enter the tariff if you know it.

P&L of the entire batch on one screen

outlay, net income, margin in money, margin in percentage, and return on what you invest. The figure that truly decides if the order is worth it.

Ranking of which reference contributes and which reference drags down

the one that adds the most to the batch margin, the one that weighs the most down, and the complete table with the landed per unit, margin per unit, and margin of each line sorted.

References that are sold at a loss appear in red, with a warning of how many there are and what to do with them

raise the price, lower the weight, or remove them from the order. It is the mistake that eats up the most margin in a large order.

Calculating is free, no registration and no AI

deterministic numbers, same data and same result every time. You only need an account to save the batch and download it in PDF or CSV sheet.

Enter your references and see the P&L of the entire batch

One line per reference with its units, weight, and price. It returns the batch margin, return on investment, and which reference is dragging it down. Free, no registration, and no AI.

Calculate the margin of a batch with multiple references