Калькулятор EOQ (Economic Order Quantity, Simple)

Рассчитать an economic order quantity оценить from годовой спрос, стоимость заказа, and стоимость хранения.

Supports MOQ, lot rounding, пакет paste, обменable URLs, and CSV export.

Calculation, обмен-link generation, and CSV export all stay inside the browser. Your input is not sent to a server.
See теоретический EOQ and adjusted quantity side by side Apply MOQ, размер партии, and rounding rules Рассчитать multiple SKUs from a pasted table Обмен across Japanese and English pages

Как пользоваться

  1. Открыть the Одна позиция tab and enter годовой спрос, стоимость заказа, and стоимость хранения.
  2. Add MOQ, размер партии, and a rounding method when you need practical constraints.
  3. Review the рекомендуемое количество, теоретический EOQ, частота заказов, and cost breakdown.
  4. Paste multiple SKUs into the Пакет tab, then export as CSV or скопировать as TSV.

Примеры

Quick оценить for one SKU

Ввод

Спрос 12,000 / стоимость заказа 5,000 / ставка хранения 25% / себестоимость единицы 800 / MOQ 500 / lot 50

Результат

Теоретический EOQ about 774.6 / рекомендуемое количество 800 / 15.0 orders per year / annual EOQ-related cost about 155,000

Enter стоимость хранения directly

Ввод

Спрос 6,000 / стоимость заказа 3,000 / стоимость хранения per unit per year 150 / no MOQ

Результат

Теоретический EOQ and рекомендуемое количество match, even when you do not know the rate

Пакет оценить from a pasted table

Ввод

annual_demand, order_cost, holding_rate, unit_cost, moq, lot

Результат

List теоретический EOQ, рекомендуемое количество, частота заказов, and notes for each SKU

Fast EOQ calculation

The result updates automatically without a рассчитать button.

Empty input shows a clear placeholder instead of misлидing zeroes.

See the practical quantity after MOQ and lot constraints next to the теоретический EOQ.

Пакет calculation from pasted tables

Paste 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 рассчитать.

If you do not know your стоимость хранения rate

A стоимость хранения rate is an annual оценить 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 результат is.

If you do not know the rate at all, enter стоимость хранения per unit per year directly.

Глоссарий

EOQ

The economic order quantity that balances ordering cost against стоимость хранения.

MOQ

The минимальный объем заказа required by a supplier or ordering condition.

Стоимость хранения rate

An annual оценить of carrying cost relative to inventory value, including storage, capital cost, insurance, and obsolescence.

Размер партии

The заказ increment used for packaging, case packs, inner cartons, or поставщик rules.

Formulas and assumptions

  • EOQ = √(2DS / H)
  • Заказs per year = D / Q
  • Annual заказing cost = (D / Q) × S
  • Annual стоимость хранения = (Q / 2) × H
  • When using a rate, H = себестоимость единицы × (ставка хранения / 100)

Часто задаваемые вопросы

I do not know my стоимость хранения 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 результат is.

What is the размер партии used for?

It rounds the EOQ to the поставщик or packaging increment. In most practical cases, rounding up is the safest default because it avoids short заказing.

Can I рассчитать multiple products at once?

Yes. Paste an Excel or spreadsheet table into the Пакет tab and the tool will рассчитать multiple SKUs at once.

Will following this результат prevent складские запасыouts?

No. EOQ optimizes order quantity, not reorder timing. Точка повторного заказаs and страховой запас still need to be designed separately when спрос and срок поставки vary.

Can I use units other than pieces?

Yes. Change the quantity unit метка in Настройки to cases, packs, kg, or another unit. The EOQ calculation itself is unit-agnostic.

Important notes

  • This tool gives an оценить under assumptions such as stable спрос, constant стоимость заказа, and average inventory approximated as Q/2.
  • Срок поставки, stockout cost, страховой запас, 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.