Hi, it's very easy to teach technical aspects of any business manya times, but very difficult to explain techno-commercial aspect to understand most of the businesses, which is the main cause of many business failures, thanks a ton buddy
Very good video just should be more clear and explain where the 141 units come. I figured out that is the square room of 20,000 but should be more clear at the end.
SEE path 2016, because the square root of 20,000 is 141.421356, and I believe you are not going to buy 0.421356 unit. So the optimal units per order are 141.
This video was very helpful, however I have a question I’m needing help with. How do u work out the total cost, frequency of orders and time between orders?
All depending what is the Lead time from dock to dock. Part X takes 4 weeks of fabrication, so that information comes from your supplier information for said part.
Thanks for this. Just one question because I may have missed it... in the first part of the formula it's 2 (A) x CP or 2 x (3,000) x CP... Where did the 2 come from? or is it something constant where the A or Annual usage will always be multiplied by 2?
Hello Ian. I've just started a course in Logistics and just started on this subject. What is the final part of the equation to get at 141 units? Thank you.
Thank you very much for this viseo. Ihave a question about managing inventory for buying groceries at the store or the market. I think in that case calculating purchasing and holding cost might be more difficult than the classic formula. In addition i find myself troubled calaculating the periodic rate of damand for example the weekly demand for bottle of milk. It is difficult more when i do not care the capacity of the refrigerator. for right now i am mapping the list of products that being purchased and their prices as well and by writing down in EXCEL spreadsheet the dates of buying groceries as well as purchase quntity and inventory for each product. is that a simple and practical method for reducing the toal cost for buying groceries?
Where did you use the 3000 units? I understand this is the demand, right? I believe the top part of the equation should be 2AD. A bit confused...Thanks!
Great explanation!! However, I worked for a big retailer! They buy stuff at different prices all the time, and there are hundreds of products with different shipping costs and as you said: the lead time varies all the time!! So, I am not sure how can we really relay on concepts of EQO!!!
hi, how do I work out the squared number of 20,000. I know its 141 because you told me in the video, but how to you get to 141? anyone who knows, please reply. pleeease
@@ismailnassar4103 ordering cost involves data processing and clerical cost as well as transportation cost that is all costs before inventory reaches to spot /location... please correct. ...
Hello , Thank you for nice explanation .Sir, I have one question about demand . If i have monthly demand e.g 1000 Units and Annual ordering cost ( 50) and Annual Holding Cost ( 10 ) . EOQ will be Sqrt( 2* 12000* 50 / 10) = 346 Units ? What will be EOQ for Monthly order ? Thank You
If you have to order monthly, then you might be forced to order a quantity that is not your EOQ. In this case, you will be simply ordering a quantity of “20 days supply”. Basically take your daily demand, multiply by 20 and that is your approximate order quantity. You can compare this to EOQ, but will likely be different. Calculate both numbers and compare. If EOQ is larger, you might be spending too much time managing this part. If EOQ is lower, you might be holding too much inventory.
I think the holding cost is not correct here. Normally it is considered that in average holding cost is between 20 and 30% per year. The average per mount is 2-3% which you use. However, the formula requires usage of the annual holding costs!!!
Hi Ian First of all, thank you for sharing this video. However, what I am curious about is that the question asked by Philippe Van Reybrouck. Couple of weeks ago I had Supply Chain Management class and asked my professor to explain the purpose of using square root and multiplication by 2, but he could not give reasonable response. So it would be nice if you could explain it.Thanks in Advance
Bob Robinson it’s because the derivation of EOQ is when you set ordering cost = to carrying cost, with qty as your variable. Solve for X, then take the derivative to find the local minimum (EOQ). You might have to investigate the carrying cost formula and ordering cost formula, but once you have them, set them equal to each other and go from there.
hi, nice video easy to understand and helpful,i have one question" how we can measure cost per unit which is lying in our warehouse" can you please give me formula for this.please keep continue to upload these sample. thanks
+Abaid Aramex Hi Abaid. The solution involves going to my website wwww.driveyoursuccess.com - the following post includes and excel sheet that allows you to define the cost of inventory in your warehouse: www.driveyoursuccess.com/2011/04/sample-excel-sheet-calculating-inventory-holding-costs.html
Hi ian, great video. i've been looking into the EOQ recently and I don't think it is a great tool in deciding the no of purchases and the amount to purchase in the practical sense. I see it more as a rule of thumb benchmark. As you mention, the variables change very often. Furthermore, its basically a formula saying that you shouldn't buy more stock when your holding costs are high. I think we have an intuitive sense to adjusts our stock without this formula. what do you think Ian?
Sam fisher Hi Sam. It's true - a lot of it is based on intuition to some extent. We all want to be able to capture opportunistic sales and don't want to encounter a stock out. However, EOQ is still applicable to those instances where companies purchase extremely high volumes of raw materials, spares and or consumables.
Just as an addition to the comment, this formula also involves the Setup Cost, so ideally it is trying to make an equilibrium between holding and purchasing costs. So shouldn´t buy more (qty) when HC is high considering Setup costs are low. There can be some other cases by mixing this idea (buy more qty when setup cost is high and HC low) and so on... so when used along with the other formulas (TC, reorder point, etc) the outcome can be better than using only intuition.
+Noor Mohamed Hello! if this question is not yet answered, it comes from the Total Cost original formula... TC = (D/Q)Co + (Q/2)Cs , if find the optimal TC by first derivative you will get the EOQ formula
+kyaw kyaw tun Hi. I am not certain where I used that line, but anytime you purchase product, you cover a cost of freight to get that part into your warehouse. This is a per-unit cost of freight. You always pay for freight - even if it is hidden in the cost of the product and your customer is telling you they'll give you a delivered price. However, on the opposite end, if you're late to your customer and have to cover freight again, then that's another cost. Sometimes when you do these videos, you use a phrase you probably should not have. I believe the best phrase is incoming freight cost.
Uhhh - this formula doesnt really seem to make sense when you are trying to minimize COGS here. if I sell 20K units a year at $5.5/unit and say 3% for HoldCost and say $2/unit for Cost to purchase. This means = 686 units is ideal Quantity, and then 20K/686 means 29 orders a year???? Yeah --- ok... I would be ordering nonstop.
This clip is very simple, easy and straight to the point for student understanding.
+nasiru mohammed Hello Nasiru. Thank you very much for your feedback. Take care.
That's an accurately drawn square root
Hi, it's very easy to teach technical aspects of any business manya times, but very difficult to explain techno-commercial aspect to understand most of the businesses, which is the main cause of many business failures, thanks a ton buddy
Thank you for helping me in something I overlooked while studying for finals. You may have just saved my grade. Thank you, kind Sir.
No problem.
hi Ian i get lost when it comes to getting the 141 units all above is clear but from 20000 what do you do
Very good video just should be more clear and explain where the 141 units come. I figured out that is the square room of 20,000 but should be more clear at the end.
Thank you i have been wondering where the 141 comes from. Now that you have explain I understand thanks
+Ian Johnson- I believe the units should be 1414 not 141. You are missing the last digit. If not can you explain why the EOQ would be 141 please?
SEE path 2016, because the square root of 20,000 is 141.421356, and I believe you are not going to buy 0.421356 unit. So the optimal units per order are 141.
It's 141. Maybe you thought the same thing as I did. Its not $200, is $2.00..
Not really,do your maths well and try again!
Oh,your correct.It's 1414!
Correct!
This video was very helpful, however I have a question I’m needing help with. How do u work out the total cost, frequency of orders and time between orders?
All depending what is the Lead time from dock to dock. Part X takes 4 weeks of fabrication, so that information comes from your supplier information for said part.
Thanks for this. Just one question because I may have missed it... in the first part of the formula it's 2 (A) x CP or 2 x (3,000) x CP... Where did the 2 come from? or is it something constant where the A or Annual usage will always be multiplied by 2?
I also cant get that part
How did you get 141 units? I think you forgot to mention
He did. It is the square root of 20'000. Check back the video.
Do we include obscelence costs ?
Thank you Ian, very helpful!
Good stuff. Thank you Ian.
Hi Ian
Does purchasing cost include transportation?
Hello Ian. I've just started a course in Logistics and just started on this subject. What is the final part of the equation to get at 141 units? Thank you.
down to earth Square root of 20,000.
yea, but how did he get 20,000
the equation says 6000 x 200, but he calculated 6000 x 2, not 200.
Dear Sir
thank you very Much for your Teaching Mechanism .you are wonderful Teacher.
Thank you very much for this viseo. Ihave a question about managing inventory for buying groceries at the store or the market. I think in that case calculating purchasing and holding cost might be more difficult than the classic formula. In addition i find myself troubled calaculating the periodic rate of damand for example the weekly demand for bottle of milk. It is difficult more when i do not care the capacity of the refrigerator. for right now i am mapping the list of products that being purchased and their prices as well and by writing down in EXCEL spreadsheet the dates of buying groceries as well as purchase quntity and inventory for each product. is that a simple and practical method for reducing the toal cost for buying groceries?
Where did you use the 3000 units? I understand this is the demand, right? I believe the top part of the equation should be 2AD. A bit confused...Thanks!
Great explanation!!
However, I worked for a big retailer! They buy stuff at different prices all the time, and there are hundreds of products with different shipping costs and as you said: the lead time varies all the time!! So, I am not sure how can we really relay on concepts of EQO!!!
Thank you 👍very helpful video 💯❤from india sir
hi, how do I work out the squared number of 20,000. I know its 141 because you told me in the video, but how to you get to 141? anyone who knows, please reply. pleeease
thanks sir this help full lecture have like a magic to understand EOQ..........
Very helpful thanks. But one question, is the shipping cost is part of ordering cost ?
Yes... please refer edutech guru engineering learning videos
@@edutechguruengineeringlear4280 Thanks for ur answer. After my analysis ..in my case .. I think answer is No...
@@ismailnassar4103 ordering cost involves data processing and clerical cost as well as transportation cost that is all costs before inventory reaches to spot /location... please correct. ...
@@edutechguruengineeringlear4280 I will share the example with you & the logic
hi, how can I calculate the unit sales double,what is the percentage increase in the EOQ
actually got it. thanks :) great video
Hello ,
Thank you for nice explanation .Sir, I have one question about demand . If i have monthly demand e.g 1000 Units and Annual ordering cost ( 50) and Annual Holding Cost ( 10 ) . EOQ will be Sqrt( 2* 12000* 50 / 10) = 346 Units ?
What will be EOQ for Monthly order ?
Thank You
If you have to order monthly, then you might be forced to order a quantity that is not your EOQ. In this case, you will be simply ordering a quantity of “20 days supply”.
Basically take your daily demand, multiply by 20 and that is your approximate order quantity. You can compare this to EOQ, but will likely be different.
Calculate both numbers and compare. If EOQ is larger, you might be spending too much time managing this part. If EOQ is lower, you might be holding too much inventory.
I think the holding cost is not correct here. Normally it is considered that in average holding cost is between 20 and 30% per year. The average per mount is 2-3% which you use. However, the formula requires usage of the annual holding costs!!!
+Dimitar Georgiev It does, but that conversion back is simple.
Thank you Ian so much 🌺🌺🌺
Hi Ian First of all, thank you for sharing this video. However, what I am curious about is that the question asked by Philippe Van Reybrouck. Couple of weeks ago I had Supply Chain Management class and asked my professor to explain the purpose of using square root and multiplication by 2, but he could not give reasonable response. So it would be nice if you could explain it.Thanks in Advance
Bob Robinson it’s because the derivation of EOQ is when you set ordering cost = to carrying cost, with qty as your variable. Solve for X, then take the derivative to find the local minimum (EOQ).
You might have to investigate the carrying cost formula and ordering cost formula, but once you have them, set them equal to each other and go from there.
i need help with a question please
bro do you know how to calculate inventory days and how to reduce the inventory day
hi, nice video easy to understand and helpful,i have one question" how we can measure cost per unit which is lying in our warehouse" can you please give me formula for this.please keep continue to upload these sample. thanks
+Abaid Aramex Hi Abaid. The solution involves going to my website wwww.driveyoursuccess.com - the following post includes and excel sheet that allows you to define the cost of inventory in your warehouse: www.driveyoursuccess.com/2011/04/sample-excel-sheet-calculating-inventory-holding-costs.html
How do you calculate in-transit carrying costs per unit?
very helpful. Thank you!
Hi, How can I express the profit as a function of T and Q?
Good one sir, thank you..!
Hi ian, great video. i've been looking into the EOQ recently and I don't think it is a great tool in deciding the no of purchases and the amount to purchase in the practical sense. I see it more as a rule of thumb benchmark. As you mention, the variables change very often.
Furthermore, its basically a formula saying that you shouldn't buy more stock when your holding costs are high. I think we have an intuitive sense to adjusts our stock without this formula.
what do you think Ian?
Sam fisher Hi Sam. It's true - a lot of it is based on intuition to some extent. We all want to be able to capture opportunistic sales and don't want to encounter a stock out. However, EOQ is still applicable to those instances where companies purchase extremely high volumes of raw materials, spares and or consumables.
Just as an addition to the comment, this formula also involves the Setup Cost, so ideally it is trying to make an equilibrium between holding and purchasing costs. So shouldn´t buy more (qty) when HC is high considering Setup costs are low. There can be some other cases by mixing this idea (buy more qty when setup cost is high and HC low) and so on... so when used along with the other formulas (TC, reorder point, etc) the outcome can be better than using only intuition.
Thank you very much, I have a doubt that why do we have to multiply 2 with annual usage quantity while calculating.
+Noor Mohamed Hello! if this question is not yet answered, it comes from the Total Cost original formula... TC = (D/Q)Co + (Q/2)Cs , if find the optimal TC by first derivative you will get the EOQ formula
Correct EOQ should be 1414???
Big thanks.
This helped.
Thank you very much sir, I'm so grateful
This helps man thank you
How can you solve that without knowing the cost?
where dose the 3% come from?
it's just an example
Very useful, thank you! :)
Thank you Nicholas. Let me know if you need anything else or another topic covered.
is 2 a constant in the formula?
Yes
thanks kaka from Bangladesh.
Dear Ian, please i have EOQ question to solve and wants to see if you can be of help. If the i will send the question to you asap.
Thanks
Absolutely! please email me at ijamesjohnson@yahoo.ca
He jumps from EOQ = 20 000 to EOQ = 141 Units. How exactly did he get to 141 units?
Sorry - might have missed a step there.
But here we are using a different formula ie 2cd/ip and finding the root after!
Thank you so much Sir
Thank you, was struggling to understand this
great tips...
Thank you Janice. Let me know if anything else interests you.
very helpful
can i ask what is in-transit inventory cost is?
+kyaw kyaw tun Hi. I am not certain where I used that line, but anytime you purchase product, you cover a cost of freight to get that part into your warehouse. This is a per-unit cost of freight. You always pay for freight - even if it is hidden in the cost of the product and your customer is telling you they'll give you a delivered price. However, on the opposite end, if you're late to your customer and have to cover freight again, then that's another cost. Sometimes when you do these videos, you use a phrase you probably should not have. I believe the best phrase is incoming freight cost.
Cost of freight in transit to your location becomes part of the price you pay. In this case, it's part of the $20 or added to it.
I'm a little bit confused on 141?
141 is the square root of 20,000
141 = sqrt(20,000)
How to gets the units
Please refer edutech guru engg leaning videos
hi ian
some of eoq formula's also holds unit price
like eoq = Sqrt(2.D.S/H.Unitprice)
please clarify it
Thanks Sir
why holding costs inventory is $20*3%?
It is an example. Holding cost could be 2% of $20 or 5% of $20. it is usually some percentage of the unit cost.
Make sure is the first
Please refer edutech guru engg learning videos
Uhhh - this formula doesnt really seem to make sense when you are trying to minimize COGS here. if I sell 20K units a year at $5.5/unit and say 3% for HoldCost and say $2/unit for Cost to purchase. This means = 686 units is ideal Quantity, and then 20K/686 means 29 orders a year???? Yeah --- ok... I would be ordering nonstop.
Sorry. I wonder why 6,000 x 200 not equal to 1,200,000 but equal to 12,000?
its actually 2.00.
and not 200.
dunno why it can be written the way it is, it can be confusing sometimes!
it is not 200 but 2 only
61542 Grant Divide
6000x200 is not 12,000, that's the error
360 Hintz Knolls
7631 Tyrell Highway
EOQQ
5732 Parker Crossroad
Martinez Daniel Davis Brian Williams Michael
Why is he using 2
It is a formula.. 2A*CP/HC
im getting 182??
No.
Divide 12000 by 0.6 gives 20000
Square root 20000 is 141,421
Guido Gardens
Jones Mary Martin Elizabeth Jones Jose
43906 Hirthe Rapid
Davis William Jones Charles Miller Jason
HADIR
10945 Okuneva Turnpike
3984 Mante Fort
Anderson Daniel Moore Jennifer Moore Linda
Thank you very much sir, I'm so grateful