Пікірлер

• 
  @marlolitgonzales51887 күн бұрын

  Good Day, may I ask the starting date is the manuf date and the end date is expiry date? And the 90 days is the safety stocks cover?

• 
  @Ravix_4213 күн бұрын

  Hii Ed!! Im Ravi from india i have completed ma bachelor degree in commerce filed and i have a plan to pursue my masters in logistics and supply chain in abroad? What skills require to get job and PG diploma is better thaan masters? Give me answer Ed 🙌

• 
  @abcsc13 күн бұрын

  Hey Ravi, check out the webinar I did a few weeks ago on how to become an expert & leader in supply chain 🚀: kzread.info/dash/bejne/q2GXtbZ9gLero7Q.html

• 
  @Ravix_4213 күн бұрын

  @@abcsc ohh oke thank u Ed 🤍

• 
  @papicoco506918 күн бұрын

  I've just came across your channel and what are the odds! I came from an inventory planning and allocation analyst level position (presently), and I'll start my new job as demand planner in August. Wish me luck! I'll be binge watching your videos during these days!

• 
  @AbcSupplyChainFR13 күн бұрын

  That's awesome ! I hope your new job is going well 🚀

• 
  @lavendela940329 күн бұрын

  Iam struggling with this because I have more than one item of the same item ( e.g. I have 27 of item 1. And 24 of item 2!! This misleads the ABC grouping. Should I separate these by creating the same row 27 times?

• 
  @ajaykatiyar815Ай бұрын

  Kindly make video to create a Dashboard for forecast accuracy, and KPIs

• 
  @ElaphAlhadiАй бұрын

  Thank you sir for your amazing video, it's so helpful and well-explained! My question is: The factory I work at uses a weekly production plan, so can I use the unit 'sales/month' unit? if not, then how can I calculate safety stock for sales/week unit? thank you

• 
  @Nace_Ай бұрын

  Extremely helpful and well explained ! Bravo mon ami.

• 
  @Nace_Ай бұрын

  Extremely helpful and well explained ! Bravo mon ami.

• 
  @GoMango392Ай бұрын

  This is an amazing video. Thanks so much for doing so!

• 
  @kabirhussain1725Ай бұрын

  🎉🎉🎉 You are great and thanks for your efforts ❤

• 
  @NS_KatАй бұрын

  Thank you.

• 
  @johnanya6098Ай бұрын

  My Dream job was to be an aeronautic engineer.😂

• 
  @Nezukochan-ed9fuАй бұрын

  This is awesome, such a great insight. I really wish if there was any scholarship available for your courses. Thank you Edouard and team :)

• 
  @j.b.1342Ай бұрын

  Great video! Thank you again for the great content!

• 
  @KiyoshiNagata-rd6hvАй бұрын

  question y must have a category of Seasonality ABC -> Consumes XYZ -> Variation of Consumes What other element do you consider relevant apart from consumption and variability of consumption? Example i think something like Seasonility (but is nearly similar to Variation of Consumes) DEF -> Seasonality

• 
  @abcscАй бұрын

  XYZ is used to assess the uncertainty of your products. There is no such thing as adding a category for seasonality. If you want to be more precise, you can use forecast accuracy instead of the coefficient of variation in the XYZ classification. Thus, the uncertainty is assessed with the level of accuracy of your forecast

• 
  @kaushalsoneji26Ай бұрын

  Thank you for the wonderful session, Edouard!

• 
  @abcscАй бұрын

  My pleasure, thank you for your feedback, let me know how it helps your career!

• 
  @peteradel557Ай бұрын

  Great 🤩

• 
  @audreyarcos62282 ай бұрын

  amazing explanations! you definitely brought clarity to this complex network , merci beaucoup!

• 
  @AbcSupplyChainFR13 күн бұрын

  I'm glad the video helped Audrey 😊

• 
  @KiyoshiNagata-rd6hv2 ай бұрын

  I love the Method 3, but i have a question about a HIGH Level of Demand Standard Deviation Or when my consume "Sales" have some period without it cause of some factors like Stock Break, change of another product, Etc

• 
  @abcscАй бұрын

  Thank you for the feedback. If you have high level of demand standard deviation, then the formula remains the same, you will just have higher safety stock. If you have stockouts as you say, you may want to clean your past sales (get rid of the 0, =stockout correction) before calculating your safety stock, to capture unconstrained demand

• 
  @crissanee93922 ай бұрын

  very helpful videos... thank you.

• 
  @bharatrasve35662 ай бұрын

  Use match insted row

• 
  @mannymany44232 ай бұрын

  I was waiting for someone to mention Microsoft Power BI for forecasting.

• 
  @abcsc2 ай бұрын

  Power BI is primarily a Business Intelligence (BI) tool, designed to visualize data rather than to calculate it. While it does offer some basic automatic forecasting features, they are relatively simple and not highly customizable. This is somewhat akin to the basic forecasting options available in Excel. However, unlike Excel, where you have more flexibility to tweak and tailor your forecasts, Power BI’s capabilities in this area are more limited.

• 
  @HudaEbrahim-dt2yo2 ай бұрын

  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?

• 
  @abcsc2 ай бұрын

  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

• 
  @gabasnavas2 ай бұрын

  Amazing content!

• 
  @abcsc2 ай бұрын

  Thanks, Appreciate it !

• 
  @pokpikchan2 ай бұрын

  very nice explanation

• 
  @crissanee93922 ай бұрын

  Amazing....

• 
  @emilytran842 ай бұрын

  Thank you for your great work and tutorial. have just downloaded the file !!!!

• 
  @prasvasu42173 ай бұрын

  ❤❤❤ You're the best supply chain educator!

• 
  @user-vp7ud6ns9g3 ай бұрын

  What if over forecast. Say actually need 10 pc and I forecast 40 pc. The error is 30. error% is 300%. And accuracy is 200%???

• 
  @abcsc2 ай бұрын

  Then accuracy is -200% not 200%. Apply the formula as it is in the file abcsupplychain.com/forecast-accuracy-formula-excel/

• 
  @tameralnahhas46463 ай бұрын

  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)

• 
  @abcsc3 ай бұрын

  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.

• 
  @RonnyMendezCaiche3 ай бұрын

  Sos un capo explicando y eso que no sé Inglés, trataré de ver eso en nuestro ORACLE a ver si implemento.

• 
  @anaskhawli90ak3 ай бұрын

  very interesting videos but I am not receiving the excel files after trying to download them,

• 
  @anaskhawli90ak3 ай бұрын

  great videos , very interesting

• 
  @GoldenMouse-10013 ай бұрын

  Awsome!

• 
  @abcsc3 ай бұрын

  I'm glad you enjoyed the video ! 👍🏼

• 
  @GoldenMouse-10013 ай бұрын

  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...)

• 
  @abcsc3 ай бұрын

  Hey, I'm glad you enjoyed them ! Thanks for the content idea, we are currently working on some topics you will enjoy 😜

• 
  @GoldenMouse-10013 ай бұрын

  ​​​@@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

• 
  @abcsc3 ай бұрын

  @@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 😉

• 
  @TamilTop53 ай бұрын

  Hi Edouard I moved to US from India recently I have procurement and sourcing experience in manufacturing Finding hard even to get a entry level job Can you guide me ?? I can share my Resume for a review .. I Need help !!

• 
  @abcsc3 ай бұрын

  Hi Tamil ! You're facing a common issue that many of my students have faced before. What I always recommend is to identify the key skills recruiters are searching for. Then you need to prove your expertise. Optimize your LinkedIn, put forward the certifications and skills you have and your past results (with numbers!) from your previous missions.

• 
  @TamilTop53 ай бұрын

  @@abcsc Thanks for the reply . I did CSCP certification also .. I will try other methods & never stop the hunting ..

• 
  @Nezukochan-ed9fu3 ай бұрын

  Awesome insight. thank you for sharing. I am currently preparing myself for change from warehousing to supply chain.

• 
  @abcsc3 ай бұрын

  Thanks for your comment ! Best of luck with your career change. We just recorded you a video with my team : www.loom.com/share/536d7aeea0d649d28b104ca2bebc60fa?sid=edbbb506-cfdd-4636-b20c-c4898a14f9b1

• 
  @Nezukochan-ed9fu3 ай бұрын

  @@abcsc this is great. ❤

• 
  @merci243Ай бұрын

  Will be the best decision you’ve ever made! I did this 5 years ago , doubled my salary and never looked back! Just remember corporate culture is the opposite of warehouse bluntness.. so keep that in mind

• 
  @designeraddress3 ай бұрын

  Hi Edouard, I have some questions for the future of supply chain. how can i contact you? i am having 13 years of experience in Healthcare Supply Chain

• 
  @abcsc3 ай бұрын

  Hey, thanks for the comment! Let me know what is your question ?

• 
  @designeraddress3 ай бұрын

  @@abcsc I have 13 years of experience in Healthcare Purchasing now I feel like this job is stagnant. I just wanted to shift to other industry but not able to move. I feel struck. I just wanted to how can I move to other industry

• 
  @abcsc3 ай бұрын

  @@designeraddress To unblock yourself, you need to have the strategic skills companies are looking for such as Inventory Management, Forecasting and Data Analysis. If you are unsure of your level on these topics, we built free assessments you can check out here : abcsupplychain.com/courses-supply-chain-logistics/#Assessment . Also make sure that your LinkedIn profile reflects these skills

• 
  @designeraddress3 ай бұрын

  @@abcsc definitely will do. Can I get ur email I'd?

• 
  @mohamedhossam58303 ай бұрын

  Thank You Very much👏

• 
  @alamRizvi-sj3bj4 ай бұрын

  really helpful videos. thank you for educating

• 
  @malindusandanuwan95554 ай бұрын

  superb

• 
  @malindusandanuwan95554 ай бұрын

  this is very help full thank you

• 
  @TomasHernandez-en6dt4 ай бұрын

  Thank you so much for your video Eduardo, very impressive and easy to understand. I am familiar with six sigma and normal distribution, so this is an excellent example of its application in inventory control. Just one comment, considering your example, could you kindly explain why is the reorder point so big (1,345)? Should it be a complement for the annual (12,000) or monthly demands (1,000) or the EOQ value? Thanks for your great work!

• 
  @abcsc3 ай бұрын

  Hi Tomas, thank you very much for your positive feedback. The Reorder point is "big" because the lead time is "big" too. You need to cover the average demand, which is 1000/month. The lead time is 35 days or 1.15 months. 1000*1.15=1,150. Which is the minimum value you need without safety stock. With safety stock, it is 1,345

• 
  @ARIZABEST4 ай бұрын

  What "Quality issues" exactly measures?

• 
  @abcsc3 ай бұрын

  Hi! This is just the count of items delivered that do not meet the quality specifications agreed upon with the supplier, without any categorization of the defects.

• 
  @TheShirgo914 ай бұрын

  Hi Eduard! Is there any differences between inventory (sales field) and MRO inventory in terms of KPI calculation?

• 
  @abcsc3 ай бұрын

  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 :)

• 
  @sandraecheverrydegomez8894 ай бұрын

  Ohh man, this video is excellent! It is the best tutorial about ABC analysis, thank you so much!!!!

• 
  @sebastienschoonjans97274 ай бұрын

  Bonjour, j'ai une question concernant l'augmentation des prix d'achat qui se répercutent automatiquement sur les prix de vente et donc les revenus. Comment appréhender ce paramètre ?

• 
  @abcsc3 ай бұрын

  Hi Sebastien (just answering you in English for my English channel 😉). Consider two scenarios regarding how price changes affect demand: -If changing the price impacts demand (which it usually does), I recommend checking out my Forecasting Expert course. In this course, I cover how to manage price elasticity effectively. You can find more details at: abcsupplychain.com/demand-forecasting-course/ -If changing the price does not significantly alter demand, it's advisable to normalize the sales data if the product price fluctuates frequently within the year. However, if the cost price only changes annually, no further adjustments are necessary.

• 
  @sorkfebern4 ай бұрын

  But doesn't situations appear where the company wants the same service level, lets say 98% for all categories a,b and c? How do you handle that situation ?

• 
  @abcsc4 ай бұрын

  I talk more about setting service level targets in my ABC XYZ video: kzread.info/dash/bejne/X3uju6twZJnRdbw.html Targeting high service levels, no matter the category, assumes you focus exclusively on service levels and not on inventory costs. This kind of supply chain strategy typically prioritizes customer satisfaction, responsiveness, and flexibility above cost minimization. E.g.: High-end Luxury Goods where the cost of not meeting customer demand can be very high in terms of lost sales and diminished brand loyalty. Or Spare Parts and Maintenance where the cost of machinery downtime can be significantly higher than the cost of carrying extra inventory. But for most companies, you need to find the right balance between service levels and inventory levels. Again, Check my ABC XYZ video where I talk about it: kzread.info/dash/bejne/X3uju6twZJnRdbw.html

• 
  @ruliajipriambudi47364 ай бұрын

  Quick question, I have a strange data set. There's no similar seasonality within 3 years of historical data. And the sales history sometimes just fluctuates whether its increasing or decreasing. I've tried SES, Holt Method and Holt Winter Methods, but the error is so high. Can you help me?

• 
  @abcsc4 ай бұрын

  Hi! I would advise you to focus on 1. removing outliers to get cleaner data 2. segmenting your data more to better identify patterns 3. considering the impact of external factors to identify other demand drivers If you want to go further, check my complete Forecasting Expert course: abcsupplychain.com/demand-forecasting-course/

• 
  @ruliajipriambudi47364 ай бұрын

  @@abcscTHANKS! But, lets say I remove January 2021. I cannot use the seasonality in Holt Winters bcs I cannot find the reference of the same month in 2022. What are you suggesting? Using a different approach? I was thinking about using ARIMA or SARIMA, but I cannot code it in phyton.

• 
  @ruliajipriambudi47364 ай бұрын

  Ive found it, its either Croston Method or Syntesos-Boylan Approximation, both works great at minimum error

• 
  @superuser86364 ай бұрын

  @@ruliajipriambudi4736I was about to say ARIMA but you can’t code in Python 😂

• 
  @abcsc3 ай бұрын

  @@ruliajipriambudi4736 Great, those techniques are good for intermittent demand or "slow-movers" where demand occurrences are irregular and sparse.