EOQ Calculator in Excel
Calculate Economic Order Quantity (EOQ)
To calculate EOQ you need to know:
- Demand Per Year
- Fixed Cost Per Order
- Holding Cost Per Item (sometimes expressed as a percent of unit cost)
EOQ Template for Excel
This economic order quantity calculator is just one of more than 140 templates in QI Macros add-in for Excel. QI Macros also draws spc charts like control charts, histograms and Pareto charts.
To calculate EOQ, simply input your data into the yellow shaded input areas. QI Macros does the rest.
The Economic Order Quantity Calculator is just one of more than 140 templates in QI Macros add in for Excel.