EOQ kalkulator (ekonomska količina narudžbe, jednostavno)

Izračunajte procjenu ekonomske količine narudžbe na temelju godišnje potražnje, troška narudžbe i troška držanja.

Podržava MOQ, zaokruživanje lota, grupno lijepljenje, dijeljive URL-ove i izvoz u CSV.

Izračun, dijeljenje URL-a i izvoz CSV-a ostaju unutar preglednika. Vaši se unosi ne šalju na poslužitelj.
Vidite teorijski EOQ i prilagođenu količinu usporedno Primijenite MOQ, veličinu lota i pravila zaokruživanja Izračunajte više SKU-ova iz zalijepljene tablice Dijelite između japanskih i engleskih stranica

How to use

  1. Open the Single item tab and enter annual demand, order cost, and holding cost.
  2. Add MOQ, lot size, and a rounding method when you need practical constraints.
  3. Review the recommended quantity, theoretical EOQ, order frequency, and cost breakdown.
  4. Paste multiple SKUs into the Batch tab, then export as CSV or copy as TSV.

Primjeri

Brza procjena za jedan SKU

Ulaz

Demand 12,000 / order cost 5,000 / holding rate 25% / unit cost 800 / MOQ 500 / lot 50

Izlaz

Theoretical EOQ about 774.6 / recommended quantity 800 / 15.0 orders per year / annual EOQ-related cost about 155,000

Izravni unos troška držanja

Ulaz

Demand 6,000 / order cost 3,000 / holding cost per unit per year 150 / no MOQ

Izlaz

Theoretical EOQ and recommended quantity match, even when you do not know the rate

Grupna procjena iz zalijepljene tablice

Ulaz

annual_demand, order_cost, holding_rate, unit_cost, moq, lot

Izlaz

List theoretical EOQ, recommended quantity, order frequency, and notes for each SKU

Jedan SKU

Rezultat se automatski ažurira bez gumba za izračun.

Prazan unos prikazuje jasan predložak umjesto zavaravajućih nula.

Prikazujte praktičnu količinu nakon MOQ-a i ograničenja lota uz teorijski EOQ.

Grupni izračun iz zalijepljenih tablica

Zalijepi izravno iz Excela ili proračunske tablice.

CSV i TSV se otkrivaju automatski.

Po potrebi ispravite pogrešne pretpostavke kroz mapiranje stupaca.

Nedostajuće vrijednosti i upozorenja prikazuju se u bilješkama po retku, dok se ostali redci i dalje računaju.

If you do not know your holding cost rate

A holding cost rate is an annual estimate of storage, insurance, interest, obsolescence, and related costs relative to inventory value.

A common starting range is about 10% to 30% per year, but the right number varies widely by product and storage conditions.

If you are unsure, start around 20% and test how sensitive the result is.

If you do not know the rate at all, enter holding cost per unit per year directly.

Glossary

EOQ

The economic order quantity that balances ordering cost against holding cost.

MOQ

The minimum order quantity required by a supplier or ordering condition.

Holding cost rate

An annual estimate of carrying cost relative to inventory value, including storage, capital cost, insurance, and obsolescence.

Lot size

The order increment used for packaging, case packs, inner cartons, or supplier rules.

Formule i pretpostavke

  • EOQ = √(2DS / H)
  • Orders per year = D / Q
  • Annual ordering cost = (D / Q) × S
  • Annual holding cost = (Q / 2) × H
  • When using a rate, H = unit cost × (holding rate / 100)

Česta pitanja

I do not know my holding cost rate.

A common starting range is about 10% to 30% per year. If you are unsure, start around 20% and adjust after checking how sensitive the result is.

What is the lot size used for?

It rounds the EOQ to the supplier or packaging increment. In most practical cases, rounding up is the safest default because it avoids short ordering.

Can I calculate multiple products at once?

Yes. Paste an Excel or spreadsheet table into the Batch tab and the tool will calculate multiple SKUs at once.

Will following this result prevent stockouts?

No. EOQ optimizes order quantity, not reorder timing. Reorder points and safety stock still need to be designed separately when demand and lead time vary.

Can I use units other than pieces?

Yes. Change the quantity unit label in Settings to cases, packs, kg, or another unit. The EOQ calculation itself is unit-agnostic.

Važne napomene

  • This tool gives an estimate under assumptions such as stable demand, constant order cost, and average inventory approximated as Q/2.
  • Lead time, stockout cost, safety stock, quantity discounts, and tiered pricing are outside the scope of this page.
  • Inputs are not saved by default. Values are stored only if you explicitly enable previous-value save in this browser.