From the course: Excel: Business Process Analysis

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Calculate an economic order quantity (EOQ)

Calculate an economic order quantity (EOQ)

From the course: Excel: Business Process Analysis

Start my 1-month free trial

Calculate an economic order quantity (EOQ)

“

- [Lecturer] Placing an order with a supplier costs money, and even though you might think your employee's wages and shipping costs are essentially free, given the value of the merchandise, they do have a significant impact on the cost of your orders. In this movie, I will show you how to calculate the economic order quantity which is the order quantity that minimizes the total of inventory and order costs over the course of a year. To calculate the economic order quantity, or EOQ, you need to know three things. The first is the order cost which is also called the setup cost in the literature and that is, as the name implies, exactly how much it costs you to place the order. You can also include shipping costs, if they're predicable. Next, we have the flow rate and that is the minimum of supply, demand, and inputs. As before, we will most likely go with demand because you are buying products to sell to your customers. So, demand is the most likely driver. And finally, you need to know…

Contents