From the course: Excel: Business Process Analysis
Unlock the full course today
Join today to access over 23,400 courses taught by industry experts.
Calculate an economic order quantity (EOQ)
From the course: Excel: Business Process Analysis
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
(Locked)
Calculate an economic order quantity (EOQ)2m 53s
-
(Locked)
Calculate orders per year and time between orders2m 47s
-
(Locked)
Calculate effects of lead time3m 34s
-
(Locked)
Determine increased cost of constrained purchases5m 40s
-
(Locked)
Examine impact of quantity discounts8m 48s
-
(Locked)
Calculate production order quantities4m 8s
-
(Locked)
-