Fun With Excel Part 2: Economic Order Quantity

I was having more fun with Excel today (total nerd, right?) and I decided to make a real simple EOQ program.  It is such a simple thing I even hesitate to call it a program.  Anyways, what it does is calculate how much of your product you need to order and when you should reorder.  Remember to keep consistent units and don’t mess with the green boxes!  See what kind of results you get.  Are they accurate?

Also an important note: If your holding cost is nothing, factor in depreciation or potential cost.  The equation is designed assuming you have product stored in a warehouse.  Enjoy. :P

EOQ Calculator