menu_logo

menu_view_template done edit menu_subscribe menu_add menu_publish iOS Create Account Login
menu_clear
  • menu_insert_row
  • menu_delete_row
  • menu_insert
  • menu_share_template
  • menu_share_results
  • menu_duplicate
  • menu_view_source
  • menu_view_calc_log
  • menu_settings
  • menu_tags
  • help
  • menu_profile
  • menu_log_out
menu_preview_only
details_tap
details_type
details_title

Economic Order Quantity Calculator

Unit Sales =
Fixed Costs =
Carry Cost =
Price/Unit =
EOQ =

Help

EOQ (Economic Order Quantity) calculates the optimum quantity of units to order.

Rows

- Unit Sales: annual unit sales
- Fixed Costs: fixed cost of placing and receiving an order
- Carry Cost: carrying cost as a percentage of inventory (includes warehousing costs, interest on funds tied up in inventory, insurance and obsolescence)
- Price/Unit: purchase price per unit of inventory
- EOQ: economic order quantity

Examples

Traditionally your company has sold 10,000 units per year. It costs $300 for shipping and handling and $19.99 per unit. If the carry cost for inventory is 20%, what is the ideal order size?
- Sales: 10,000
- Fixed Costs: 300.00
- Carry Cost: 20.000%
- Price/Unit: 19.99
Select "=" on EOQ row. The optimal order quantity is 1,225 units.

Keywords

Unit Sales
Fixed Costs
Carry Cost
Price/Unit
EOQ
-------------