Arvuta an economic order quantity estimate from annual demand, order cost, and holding cost.
Supports MOQ, lot rounding, batch paste, shareable URLs, and CSV export.
Nõudlus 12,000 / order cost 5,000 / holding rate 25% / unit cost 800 / MOQ 500 / lot 50
Theoretical EOQ about 774.6 / recommended quantity 800 / 15.0 orders per year / annual EOQ-related cost about 155,000
Nõudlus 6,000 / order cost 3,000 / holding cost per unit per year 150 / no MOQ
Theoretical EOQ and recommended quantity match, even when you do not know the rate
annual_demand, order_cost, holding_rate, unit_cost, moq, lot
List theoretical EOQ, recommended quantity, order frequency, and notes for each SKU
The result updates automatically without a calculate button.
Empty input shows a clear placeholder instead of misleading zeroes.
See the practical quantity after MOQ and lot constraints next to the theoretical EOQ.
Kleebi directly from Excel or a spreadsheet.
CSV and TSV are detected automatically.
Fix wrong guesses through column mapping when needed.
Missing values and warnings are reported in row-level notes while the other rows still calculate.
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.
Kui are unsure, start around 20% and test how sensitive the result is.
Kui do not know the rate at all, enter holding cost per unit per year directly.
The economic order quantity that balances ordering cost against holding cost.
The minimum order quantity required by a supplier or ordering condition.
An annual estimate of carrying cost relative to inventory value, including storage, capital cost, insurance, and obsolescence.
The order increment used for packaging, case packs, inner cartons, or supplier rules.
A common starting range is about 10% to 30% per year. Kui are unsure, start around 20% and adjust after checking how sensitive the result is.
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.
Yes. Kleebi an Excel or spreadsheet table into the Partii tab and the tool will calculate multiple SKUs at once.
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.
Yes. Change the quantity unit label in Seaded to cases, packs, kg, or another unit. The EOQ calculation itself is unit-agnostic.