Just to share on of the main questions from my LinkedIn post : Yes, one the reasons Apple has only 9 days of stock is because they ship most of their products from Foxcom in China to their consumers and stores by Plane without any storage in between. (Their revenue per number of SKUs is also incredibly high). Reducing the lead time is key to improving the cash flow even at a high price like paying air freight. The aim of this video was to focus on the calculation of inventory turnover. This Kpi gives the end result of how efficient your cash is invested with inventory. I will definitely go more into details for my next videos, just want to keep it short and simple 😁 Let me know which company you want me to reveal their supply chain secrets in the comment 👇
Thank you for our great videos. All of them are so informative, educative, easy to understand. I am waiting for more supply chain analysis (IKea vs Home Depot, Walmart vs Target...)
@@abcsc in many literatures Inventory/stock turn and Inventory turnover are used interchangeably meanwhile inventory days refer to the average amount of time in which a company’s inventory is held on hand until it is sold. And I am not meet the case that inventory cycle is used as inventory turnover. In your video you used inventory cycle and stock turn in days/in weeks instead- it's a little confusing as you have mentioned. Especially the formula at 3.30 may be wrongly understood by students
@@GoldenMouse-1001@GoldenMouse-1001, indeed, there are many ways to say the same thing. Sometimes, it emphasizes different aspects of the measurement. In the end, the main difference is whether you calculate the ratio or the count of days. I like "Stock Turn" because it's short and concise. In my courses, I always tell my students I prefer using days because ratio is not intuitive. So I don't need to specify "stock turn IN DAYS" each time. I just don't like jargon and endless theory , keep it simple 😉
You have super good videos, please share more with us. It would be nice to see something about, DDMRP and how do design supply chain based on business environment you operate (manufacturing, FMCG, automotive, health industry etc..)
Thanks for your feedback @Lazar 😁 I will do my best to share more strategy and tools to improve you supply chain with real examples. I will keep you posted in this channel 🚀
As you wish. It depends on the context and your audience. Days of Coverage might be more understood by people not familiar with inventory management jargon. It intuitively suggests how many days the current inventory will last under normal operation conditions. Stock Turn in Days refers to how many days, on average, it takes to sell the entire inventory. In the end, it is the same.
Hello Edouard, Thank you so much for these videos. I had a doubt regarding calculating average inventory value. I have the exact quantity of materials procured in a particular month. Can I use this value in place of average inventory value?
Hi, yes you can use Qty as I say in the video. But I recommend to work in Value whenever possible, so if you have the purchase price of those items then use it and COGS to calculate Inventory turnover
Hi! Can I do this by having only the information below? 1. Current inventory for January 2023 2. Quantity sold monthly from Jan-Dec 2022 How do I get my average inventory? Thank you!
Hi! Regarding the inventory turnover, you obviously don't use sales price for MRO inventory. So you can either use the cost price, or value the cost of having a stockout. In sales field, the cost of having a stockout is just the sales price value (and customer dissatisfaction). In MRO, you would need a deeper analysis to assess the cascading effect of missing a critical part. But keep it easy, use the item cost price :)
This video is very helpful! I work with both purchased and donated inventory. With donated inventory, we have storage and shipping cost. Would it make more sense for donated inventory to use units rather than COGS and Sales?
Can't understand what prices should I use. For inventory value - is it how much it cost to me make that product? or how much should sale it for distributors?
Hello ! They are many reports a Supply planner can make according to his needs and missions. I always recommend to start with the foundations. In the supply side, it is important to start tracking the most important KPIs, that will drive the most important decisions. Those KPIs are related to 3 Pillars : Service, Cost, Inventory. The KPI introduced in this video is related to the Inventory, in this article I talk about others related to the Service : abcsupplychain.com/otif-fill-rate-difot/
Very interesting Edouard! But i still don't get a thing, why you are not using the COGS/Average Inventory Value formula for the Inventory Turnover Ratio?
Hi Eduard, thanks alot , super clear ! Any difference for a derived demand ?(meaning in manufacturing the Sales is for ther End product, but the stock is for the components)
Hi Edouard! Thanks for your simple tutorial. Can you please help me to calculate the average stock? I have weekly stock amount. The average stock is calculated by (Stock End - Stock Begin)/2 in period or Average of weekly stock. Thank you! :)
What is your thoughts on utilizing a weighted average to measure the true health of inventory? In my experience, having too much of the wrong inventory, and not enough of the right inventory can be hidden in the overall coverage metric.
Good point. I don’t have access to COGS . Is there a reason we cannot measure turns or days of supply using inventory units vs demand? Seems like most videos refer to COGS
How do i calculate the average inventory value? Why do i use value not quantity It will go to the point directly, for example i have 5 pcs and 200 pcs sold last year so turnover is 9 Regardless of cost variations. Kindly clarify as I'm trying my best to learn.
You have used the term Sales Forecast. That assumes a perfect match of Orders received with Sales which is not necessarily true for all products. A better method would be to track orders received and corresponding enquiries to capture intrinsic market demand, and analyze on the basis of average error and mean error of forecasts vs actual orders received, the corresponding suitability of the algorithm used in forecasting.
Hi, from what I understood, you have a concern that "orders received" don't directly equate with "sales" due to the possibility that not all orders lead to completed sales transactions. However, the practice of sales forecasting itself doesn't inherently assume a 1:1 match between orders received and final sales. Instead, sales forecasting attempts to estimate future sales based on a variety of data, including past sales, market trends, and possibly orders received, among other factors. It's an estimation process that acknowledges uncertainties and attempts to predict future outcomes as accurately as possible. And yes, best way to forecast is always to capture unconstrained demand first
Lets start with Sales. Converting orders to sales is the order processing process not all of which is based on manufacturing against orders received only. Usually a combination of a production plan based on forecasted orders and actual orders. Forecasted orders in a multiproduct, multi model product mix is not necessarily aligned throughout the Organization, where authority levels are not necessarily in sync with reality. Considering the context of the Organization and the needs and expectations of interested parties, including the impact of failure modes in forecasting as well as variations in customer demand, my opinion is that the starting point is to compare annual orders received, with corresponding sales of each and every item in the product mix, and based on categorization of the product mix in terms of runners, repeaters, and strangers , apply techniques of Short term demand forecasting considering a combination of algorithms such as exponential smoothing, exponential smoothing corrected for trend and seasonality, and based on forecasting effectiveness, continue the exercise every month with corresponding dispatch planning and desired inventory levels. I had carried out the above for a product mix combination of over 100 items in an assignment years ago, and hence the learning.
Great videos, I like your idea of popularizing SC concepts like you do. Yet if I may, I think you might have inverted 2 concepts : What you are calling stock turnover (rotation du stock in French) is I think called the Stock cover (taux de couverture en français) and it can be calculated by dividing the level of stock by the total annual / sales and multiplying by 365 On the other hand, what you are calling the inventory turn is called by others inventory turnover, it can be calculated by dividing the total number of units sold by the average number of units in stock. I have checked this on different sources and the definitions I wrote are an extract from Gwynn Richard's book : Warehouse Management_A Complete Guide to Improving Efficiency and Minimizing Costs in the Modern Warehouse, excellent logistics bible by the way Am I wrong ?
Hi! Revenue is your sales: Sales qty * Sales price. COGS is the cost of the products you sold. You can also estimate your sales in cogs value : Sales qty * COGS
Nice video. The only suggestion I have is to stop using the term COGS for the stock value. Cost of Goods Sold is self-explanatory. It is related to sales, and has nothing to do with stock. It is inherently wrong to say Stock COGS. Products that are in stock have not been sold yet, hence they do not have cost of good sold. You can have stock value either at purchase price or sales price. If we are talking about retail businesses, most of the companies track their stock at retail price. Wholesale, on the other hand, based on purchase price. If someone from finance or someone with accounting background was watching your video, they would be very confused with the terminology.
Hi! I am glad you liked the video. You are right. I put "COGS" to get a short terminology and to show it could include labor and overhead costs associated with production, but COGS is indeed a financial measure for items already sold, as the name suggests. So I should have put "Purchase price" or "Acquisition & production costs" for inventory (but still COGS when talking about sales). And yes, some retail businesses use sale price for inventory valuation; in this case, we must also use sales price and not COGS in the Stock Turn calculation to be coherent, as I say in the video. I will edit the Excel file, thanks :)
It is nice presentation, but is it the same concept when I have an inventory for internal end user, I mean I want to optimize the inventory value based on the consumption of items by our own end users?
This is good the Dashboard too is very helpful
Happy it’s helping you 😁
Your videos are such amazing piece of knowledge, really thankful for sharing this. Cannot wait for more to come!
Thanks Zuzanna, I try to keep it simple with examples. More tutorials to come very soon :-)
Hey Edouard,
Simple "measures" that lead to big gain. Love the ''cash is king'' flow. Thank you for sharing.
Thanks J DO 😁 Let’s keep it simple first 🎯
Just to share on of the main questions from my LinkedIn post : Yes, one the reasons Apple has only 9 days of stock is because they ship most of their products from Foxcom in China to their consumers and stores by Plane without any storage in between. (Their revenue per number of SKUs is also incredibly high).
Reducing the lead time is key to improving the cash flow even at a high price like paying air freight.
The aim of this video was to focus on the calculation of inventory turnover. This Kpi gives the end result of how efficient your cash is invested with inventory.
I will definitely go more into details for my next videos, just want to keep it short and simple 😁
Let me know which company you want me to reveal their supply chain secrets in the comment 👇
Nice presentation with easily understandable
Thank you for your feedback!
Hi, great video, very helpful, just one question when you say average inventory COGS value, do you mean inventory value or COGS value please ?
excellent Tutorial ! what do you mean with Sales COGS ? is it the product revenue excluding the service revenue ? please if you could elaborate more
Thanks for sharing Edouard ! Always quality presentations :)
Thank you very much Alexandre ! I try to share my experience while keeping it simple 🙌
Hi, Nice presentation and easy to understand. How to manage the shortages in machinery manufacturing setup?
Thanks KG ! Improving manufacturing shortage will be the focus of one my new video. Subscribe to get notified 🚀
Thank you for our great videos. All of them are so informative, educative, easy to understand. I am waiting for more supply chain analysis (IKea vs Home Depot, Walmart vs Target...)
Hey, I'm glad you enjoyed them ! Thanks for the content idea, we are currently working on some topics you will enjoy 😜
@@abcsc in many literatures Inventory/stock turn and Inventory turnover are used interchangeably meanwhile inventory days refer to the average amount of time in which a company’s inventory is held on hand until it is sold. And I am not meet the case that inventory cycle is used as inventory turnover. In your video you used inventory cycle and stock turn in days/in weeks instead- it's a little confusing as you have mentioned. Especially the formula at 3.30 may be wrongly understood by students
@@GoldenMouse-1001@GoldenMouse-1001, indeed, there are many ways to say the same thing. Sometimes, it emphasizes different aspects of the measurement. In the end, the main difference is whether you calculate the ratio or the count of days. I like "Stock Turn" because it's short and concise. In my courses, I always tell my students I prefer using days because ratio is not intuitive. So I don't need to specify "stock turn IN DAYS" each time.
I just don't like jargon and endless theory , keep it simple 😉
Very educative and practically explained.
Thank you!
Thanks for sharing the knowledge...its very useful and easy to implement in our supply chain system..
Glad It helped Nadeem!
Very informative video... Please explain to me how to calculate the average stock COGS and the sales COGS
Hi, thank you very much for your feedback!
Well, you should easily find out those figures talking to your Finance Department ;)
@@abcsc Oh okay but what if there's no finance department available in the company, like a Sole proprietorship firm or a SME?
Regarding average inventory. Do you get this by taking inventory value for each day and sum it up and divide by the number of days?
Excellent comme dab, OUI des exemples sur les amazone, Apple, zara... MERCI
Avec plaisir Youcef!
Nice video use full my dear...I am working in Pharma industry
You have super good videos, please share more with us. It would be nice to see something about, DDMRP and how do design supply chain based on business environment you operate (manufacturing, FMCG, automotive, health industry etc..)
Thanks for your feedback @Lazar 😁 I will do my best to share more strategy and tools to improve you supply chain with real examples. I will keep you posted in this channel 🚀
Hi Ed,
Nice video, but does it work with volume (Cases.. etc) or just value.
Thanks.
Thank you so much Edward. Do you think, it would be better if we rename the store turn in days and instead to call it stock days of coverage (DOC)
As you wish. It depends on the context and your audience. Days of Coverage might be more understood by people not familiar with inventory management jargon. It intuitively suggests how many days the current inventory will last under normal operation conditions. Stock Turn in Days refers to how many days, on average, it takes to sell the entire inventory. In the end, it is the same.
Sos un capo explicando y eso que no sé Inglés, trataré de ver eso en nuestro ORACLE a ver si implemento.
Hi are you calculating inventory as beginning value - ending value of given period? Or value of inventory purchased over given period of time
Hi! I use the average Inventory purchased value per month as shown in the formula part of the video
Hello Edouard, Thank you so much for these videos. I had a doubt regarding calculating average inventory value. I have the exact quantity of materials procured in a particular month. Can I use this value in place of average inventory value?
Hi, yes you can use Qty as I say in the video. But I recommend to work in Value whenever possible, so if you have the purchase price of those items then use it and COGS to calculate Inventory turnover
Hi! Can I do this by having only the information below?
1. Current inventory for January 2023
2. Quantity sold monthly from Jan-Dec 2022
How do I get my average inventory?
Thank you!
THANK YOU! GREAT VIDEO
You are welcome, Glad you liked it :)
Hi Eduard! Is there any differences between inventory (sales field) and MRO inventory in terms of KPI calculation?
Hi! Regarding the inventory turnover, you obviously don't use sales price for MRO inventory. So you can either use the cost price, or value the cost of having a stockout. In sales field, the cost of having a stockout is just the sales price value (and customer dissatisfaction). In MRO, you would need a deeper analysis to assess the cascading effect of missing a critical part. But keep it easy, use the item cost price :)
This video is very helpful! I work with both purchased and donated inventory. With donated inventory, we have storage and shipping cost. Would it make more sense for donated inventory to use units rather than COGS and Sales?
Can't understand what prices should I use. For inventory value - is it how much it cost to me make that product? or how much should sale it for distributors?
Hi Ed can you tell me what are essentiall reports for the supply planner to do whether they are regular or not.. thanks in advance
Hello ! They are many reports a Supply planner can make according to his needs and missions. I always recommend to start with the foundations. In the supply side, it is important to start tracking the most important KPIs, that will drive the most important decisions. Those KPIs are related to 3 Pillars : Service, Cost, Inventory. The KPI introduced in this video is related to the Inventory, in this article I talk about others related to the Service : abcsupplychain.com/otif-fill-rate-difot/
@@abcsc thanks alot Ed waiting for more vids about kpi...👍👏
@@doomexter1 You're welcome. And yes, more to come soon! 🙌
Very interesting Edouard! But i still don't get a thing, why you are not using the COGS/Average Inventory Value formula for the Inventory Turnover Ratio?
Hi Elias, yes I use it in the formula look at 3:10
Hi Eduard, thanks alot , super clear ! Any difference for a derived demand ?(meaning in manufacturing the Sales is for ther End product, but the stock is for the components)
Hi Max, thank you for your feedback. No difference, except that you must have a clear bill of materials and beware of the lead time of the assembly
Very welcome Mohammad!
Hi Edouard! Thanks for your simple tutorial.
Can you please help me to calculate the average stock?
I have weekly stock amount. The average stock is calculated by (Stock End - Stock Begin)/2 in period or Average of weekly stock.
Thank you! :)
Hi! It is better to use the average of weekly stock
very interesting videos but I am not receiving the excel files after trying to download them,
Can we use quantity of items on hand instead of using cost?
Hi, yes. As I say in the video, you can use on hand quantities only if you use sales quantities as well in the calculation.
thank you
You're welcome
excellent
My pleasure Muhammad Muawiyah :-)
Interested in ZARA and Amazon supply chain.
What is your thoughts on utilizing a weighted average to measure the true health of inventory? In my experience, having too much of the wrong inventory, and not enough of the right inventory can be hidden in the overall coverage metric.
Hi Joe! You're right, that's why you need at least to know the ABC category of your product
Good point. I don’t have access to COGS . Is there a reason we cannot measure turns or days of supply using inventory units vs demand? Seems like most videos refer to COGS
How do i calculate the average inventory value?
Why do i use value not quantity
It will go to the point directly, for example i have 5 pcs and 200 pcs sold last year so turnover is 9
Regardless of cost variations.
Kindly clarify as I'm trying my best to learn.
do make a video on apple's supply chain
I will ;)
You have used the term Sales Forecast. That assumes a perfect match of Orders received with Sales which is not necessarily true for all products. A better method would be to track orders received and corresponding enquiries to capture intrinsic market demand, and analyze on the basis of average error and mean error of forecasts vs actual orders received, the corresponding suitability of the algorithm used in forecasting.
Hi, from what I understood, you have a concern that "orders received" don't directly equate with "sales" due to the possibility that not all orders lead to completed sales transactions. However, the practice of sales forecasting itself doesn't inherently assume a 1:1 match between orders received and final sales. Instead, sales forecasting attempts to estimate future sales based on a variety of data, including past sales, market trends, and possibly orders received, among other factors. It's an estimation process that acknowledges uncertainties and attempts to predict future outcomes as accurately as possible. And yes, best way to forecast is always to capture unconstrained demand first
Lets start with Sales. Converting orders to sales is the order processing process not all of which is based on manufacturing against orders received only. Usually a combination of a production plan based on forecasted orders and actual orders. Forecasted orders in a multiproduct, multi model product mix is not necessarily aligned throughout the Organization, where authority levels are not necessarily in sync with reality. Considering the context of the Organization and the needs and expectations of interested parties, including the impact of failure modes in forecasting as well as variations in customer demand, my opinion is that the starting point is to compare annual orders received, with corresponding sales of each and every item in the product mix, and based on categorization of the product mix in terms of runners, repeaters, and strangers , apply techniques of Short term demand forecasting considering a combination of algorithms such as exponential smoothing, exponential smoothing corrected for trend and seasonality, and based on forecasting effectiveness, continue the exercise every month with corresponding dispatch planning and desired inventory levels. I had carried out the above for a product mix combination of over 100 items in an assignment years ago, and hence the learning.
Devotion!
Great videos, I like your idea of popularizing SC concepts like you do.
Yet if I may, I think you might have inverted 2 concepts :
What you are calling stock turnover (rotation du stock in French) is I think called the Stock cover (taux de couverture en français) and it can be calculated by dividing the level of stock by the total annual / sales and multiplying by 365
On the other hand, what you are calling the inventory turn is called by others inventory turnover, it can be calculated by dividing the total number of units sold by the average number of units in stock.
I have checked this on different sources and the definitions I wrote are an extract from Gwynn Richard's book : Warehouse Management_A Complete Guide to Improving Efficiency and Minimizing Costs in the Modern Warehouse, excellent logistics bible by the way
Am I wrong ?
How to calculate Average inventory if either opening stock or closing stock is 0
You need to have historical data of your stock, for example weekly or monthly stock
Can anyone explain,How sales COGS is different from revenue?
Hi! Revenue is your sales: Sales qty * Sales price. COGS is the cost of the products you sold. You can also estimate your sales in cogs value : Sales qty * COGS
more walmart analysis please!!! :)
There will be ;)
Nice video. The only suggestion I have is to stop using the term COGS for the stock value. Cost of Goods Sold is self-explanatory. It is related to sales, and has nothing to do with stock. It is inherently wrong to say Stock COGS. Products that are in stock have not been sold yet, hence they do not have cost of good sold. You can have stock value either at purchase price or sales price. If we are talking about retail businesses, most of the companies track their stock at retail price. Wholesale, on the other hand, based on purchase price. If someone from finance or someone with accounting background was watching your video, they would be very confused with the terminology.
Hi! I am glad you liked the video. You are right. I put "COGS" to get a short terminology and to show it could include labor and overhead costs associated with production, but COGS is indeed a financial measure for items already sold, as the name suggests. So I should have put "Purchase price" or "Acquisition & production costs" for inventory (but still COGS when talking about sales). And yes, some retail businesses use sale price for inventory valuation; in this case, we must also use sales price and not COGS in the Stock Turn calculation to be coherent, as I say in the video. I will edit the Excel file, thanks :)
ABCQ
It is nice presentation, but is it the same concept when I have an inventory for internal end user, I mean I want to optimize the inventory value based on the consumption of items by our own end users?