White Friday: up to 30% off your subscription 0days 0hrs 0min
Intagya
Pricing Blog Try free
← All articles

How do I split a purchase between suppliers by landed cost?

| Intagya ERP Expert Team

How do I split a purchase between suppliers by landed cost?
The short answer

Compare vendors by what the goods cost when they reach your warehouse and when they really arrive, not by the list price. In Intagya ERP the Supplier split works out for each product needed the price plus import costs, adds safety days for vendors who are often late, then splits the quantity: what you need first to whoever arrives in time, the rest to the cheapest, with no vendor above 70%.

A spare parts importer compares two offers for the same item. The local vendor asks 105 a piece, the foreign one 80. Easy call. Then the shipment arrives two weeks late, with a freight bill and a customs bill, after the warehouse has been empty for ten days and customers have been waiting.

The price was not wrong. It was incomplete.

Why is comparing vendor prices not enough?

Because the vendor price is not what you pay. What you pay is the landed cost: the price plus freight, customs and everything spent until the goods reach your warehouse. And there is a cost no invoice shows: the empty shelf while a late vendor is still on the way.

So my rule is: do not ask who is cheapest. Ask who is cheapest among the vendors who arrive in time.

How is the landed cost of each vendor worked out?

Intagya ERP takes the price from the vendor prices on the product, then adds the import cost share from the import costs app, in this order:

  1. An estimate written for that vendor, when there is one.
  2. Otherwise what you really recorded on its last 3 shipments.
  3. Otherwise the cost types estimate, for a foreign vendor with no shipment yet.
  4. A local vendor has no import costs.

Without the import costs app, the landed cost is the price alone, and the page says so plainly. That alone is a good reason to record freight and customs on every receipt.

How do I account for a vendor who is often late?

With safety days added to its lead time, in proportion to how late it has been. The late rate comes from the vendor score when there is one, otherwise from its receipts of the last 12 months: how many arrived after the promised day. Safety days are the lead time times the late rate, rounded up. A vendor who delivers in 6 days and was late on 22% of receipts gets 2 days added.

A new vendor with no receipts is not penalised, but it is marked New so you know its figure has not been tested yet.

How does the system split the quantity?

It starts with what you need first. If your stock will run out before the request date, at the use of the last 90 days, what is used from that day is the first batch, and it goes to the cheapest vendor that arrives by then, or to the fastest when none can. The rest goes to the cheapest landed cost among the vendors that arrive by the request date. No vendor gets more than 70% of the quantity while another one can take the rest.

A made-up example: you need 1,000 pieces within 20 days, and your stock runs out in 8 days, so 300 of them are needed before that. The local vendor costs 105 landed and arrives in 5 days. The foreign vendor costs 80 plus 20% import costs, so 96, takes 12 days and was late on a quarter of its shipments, so 3 days are added and it arrives on day 15. The first 300 go to the local vendor, the only one there by day 8. The other 700 go to the foreign vendor, the cheapest that arrives by day 20, and 700 is exactly the 70% cap. If the local vendor is your usual one, buying it all there costs 105,000; the split costs 98,700.

The 70% cap protects you from depending on one vendor. Raise it if you have one trusted vendor for a sensitive item; lower it if your market is unsteady. It is in the Purchase settings, Highest share of one vendor.

Where do the needs it splits come from?

From two places: lines of approved purchase requests with no request for quotation yet, and products below the minimum of their reordering rule that have a vendor and no open purchase request. It runs every night, and when a purchase request is approved. You find it in Purchase: Overview, then Decisions, then Supplier split.

What happens once I accept the split?

If you do not like the split, press Adjust split and change any vendor's quantity or the first batch date, then save or ask for a new suggestion. When you are ready, press Create purchase orders: one request for quotation per vendor with its quantities, linked to the purchase request. The system confirms nothing and sends nothing to the vendor; you review the requests and send them.

Tomorrow morning open your five most bought items and check that each has more than one vendor on it, with a real lead time. Then record freight and customs on the next receipt that comes in. After one night you will see the split with your own figures.

FAQ

Do I need the import costs app?

No, but without it the landed cost is the vendor price alone. With it, freight and customs are part of the comparison.

Does the system send the orders to the vendors?

No. It creates one request for quotation per vendor, and you review, send and confirm it.

What if the product has only one vendor?

That vendor takes the whole quantity; the 70% cap applies only when another vendor can take the rest.

Does it use AI?

No. It is a calculation inside the system from vendor prices, receipts and import costs, and it uses none of the AI assistant questions.

Want to see IntagyaERP on your own workflow?

Book a demo, tell us how your business runs, and watch the system handle a real scenario from your company.

Book a demo