Economic order quantity
Quick help
Estimate an economical order size with steady annual demand, fixed order cost and annual holding cost per unit. Does not handle quantity discounts, shortages or variable demand.
- Enter your numbers or replace the example rows.
- Prepare and review the result and formula.
- Download, print or export a draft before closing.
What it does not do: No cloud sync, automatic orders, certification or professional advice.
Estimate an economical order size with steady annual demand, fixed order cost and annual holding cost per unit. Does not handle quantity discounts, shortages or variable demand.
One currency per worksheet. CSV has a header and up to 10,000 rows; previews show 100, downloads include all. CSV downloads prefix potential spreadsheet formulas with an apostrophe. Calculated values display up to six decimal places; totals use unrounded intermediate values. Examples are fictional inputs, not recommended rates.
Import is kept in this page's memory. The original profile file is unchanged.
Preview / results
Enter your details on the left to prepare your result.