7 ай бұрын
Пікірлер
@pyleong4050 Күн бұрын
Amazing, what a great sharing! Really appreciated. Looking forward more video
@aliatarod-j8k 3 күн бұрын
Thanks a lot sir It was helpful for me
@angelcrmmlozanoiturria3975 6 күн бұрын
Excelent content!
@RobbinsMerlin 10 күн бұрын
76861 Bernadine Junction
@menadzukic 11 күн бұрын
Thank you for sharing your massive supply chain knowledge Edouard
@danielaricaurte8989 16 күн бұрын
Magnifique !! Thanks for doing content like that!!
@abcsc 16 күн бұрын
Glad you liked it! I'm going to try to release this format more frequently 😊
@YAlife721 17 күн бұрын
Nice Info ..
@BowenAubrey-v9b 18 күн бұрын
Moore Michael Thomas Anthony Jones Sharon
@pokebaula1 19 күн бұрын
can we have the tutorials for seasonality as well,please
@abcsc 19 күн бұрын
Thanks for the content idea 👍🏼
@JessicaChan-m5s 21 күн бұрын
Hello :) Thanks for this video, it's really helpful. May I check at the 12:00 of the video, is the objective of the 2023 forecast to spread out $70m of revenue by month? If so, should we use Base Rate of the respective month *$70m / 12 mths instead? In that way, the sum of the 12 mths spread = $70m. Thank you for your advice. :)
@mohammadabid4945 22 күн бұрын
Wonderful video, very informative. Thank you so much.
@baothai8528 24 күн бұрын
How to calculate Average stock COGS for each product, sir?
@abcsc 2 күн бұрын
Suppose you have the following data for a product over a month: Opening Stock: $10,000 Closing Stock: $8,000 Purchases during the period: $12,000 Average Stock=210,000+8,000=9,000 COGS=10,000+12,000−8,000=14,000 Inventory Turnover Ratio=9,00014,000≈1.56 This means the inventory turned over about 1.56 times during the period.
@JasonWalker-l6g 25 күн бұрын
Ondricka Pine
@ericdanielmanik 28 күн бұрын
Very comprehensive guide with good visuals and explanations. As an aspiring supply chain professional striving to do well, the video gave me clear directions on the many exciting paths in the supply chain industry! Thank you :)
@AbcSupplyChainFR 26 күн бұрын
I'm glad Eric, best of luck on your supply chain adventures 🚀
@mohammadabid4945 29 күн бұрын
Thank you so much Eduard for your great work and sharing with us.
@Casikan Ай бұрын
I will be going back to college this fall to study supply chain management, and really think this channel will be a useful tool for me. Thank you.
@abcsc Ай бұрын
I'm glad the channel will be useful! Best of luck for your studies 👍🏼
@ocanjacob2046 Ай бұрын
Very Helpful Much thanks @AbcSupplyChain
@abcsc Ай бұрын
Enjoy the video Jacob 👍🏼
@ByronHaji Ай бұрын
great wrk. i have a suggestion of an excel form you can prepare for B2B LOgictic report. with inclusion of 25 depots carrying stocks of a single product. what best can you suprise us with on this one. from dasboards to kpi
@abcsc Ай бұрын
Hey Byron, Seems like you have a very specific projet on your hands 😉 Best of luck 🚀
@ByronHaji Ай бұрын
@@abcsc ohh yes and it would be of great appreciation if you help me
@florian4200 Ай бұрын
Thanks Eduard, great video and a lot of value in it :)
@abcsc Ай бұрын
Thanks Florian! I'm glad you enjoyed it 👍🏼
@abcsc Ай бұрын
Download the Excel with the 10 Supply Chain KPIs: abcsupplychain.com/excel-10-best-kpis/
@zoeaustralia7229 Ай бұрын
Hi Eduard, I tried the link but it is not working?
@abcsc Ай бұрын
@@zoeaustralia7229 Just checked and everything seems to be working 😊 Check Spam folder or maybe a small mistake in the e-mail adress you provided 👍🏼
@nishedhdhungana439 Ай бұрын
On 16:47 min on Column K3, I can see 80% being mentioned which has 113 counts, but that should be for >40% to 80% isn't it ? What I think is that, if you mention as 80% the total count for that should be 152 and not 113. Please correct me if I am wrong. And if I am right, can you write down how to put the figure for K3 ? Thank you
@abcsc Ай бұрын
Hi. 113 is the count of B codes. 80% is just the upper limit range for B codes. So yes, B codes are in between 40% and 80%, I just put the upper limits in the K column.
@hectorpalacios5527 Ай бұрын
Hey man, great content! What would be the best method for intermittent demand like spare parts?
@abcsc Ай бұрын
Hi, if the demand sill have clear demand patterns, you can still use regular forecasting methods. If the demand is really intermittent, unpredictable with lots of "0" then you may want to try croston's method. Safety stock is always relevant regardless of the demand pattern because it's about preparing for uncertainties
@cediesalazar2391 Ай бұрын
Great work!
@abcsc Ай бұрын
I'm glad you enjoyed it 😊
@JonasDeman Ай бұрын
Hello Edouard, thank you for explaining these fundamentals. This video, in combination with your other lessons, really help to have a holistic image of supply chain. However, I'm not a big fan of all those Excel tabs and data entry. I would like to have this combined with Power Query and later Power Bi. for automatic data- and report generation. Is this something you could do a course on as well?
@abcsc Ай бұрын
Hi Jonas, Power BI should be one of the next courses I release. I'm also waiting to dive deep in microsoft excel copilot to see the value there.
@obolivei Ай бұрын
good video, but this is not works for retail replenishment.
@abcsc Ай бұрын
Hi! Thank you for your positive feedback. What do you mean by it doesn't work for retail replenishment?
@victorcerdascastillo5280 Ай бұрын
Great Great Great, more videos pls
@abcsc Ай бұрын
Many coming out soon 😊
@adrianegr89 Ай бұрын
If I’m in Manufacturing and want to apply EOQ variation to decide how much to produce. What LT should I use? The cycle of production? (If I run X stock once a week for instance)
@yousifmohammed8529 Ай бұрын
Big thanks from Iraq for your efforts 🙏
@abcsc Ай бұрын
You're welcome 😊
@marlolitgonzales5188 Ай бұрын
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?
@abcsc Ай бұрын
Hi! Mmmh not really, slow moving KPI period should be taken according to your general inventory turnover. For example 3 months if your business has a quick turnover, or 12 if it is longer. And it is calculated on active products (not expired products or product not yet launched). So that period is not related to manufacturing date or expiry date
@Ravix_42 2 ай бұрын
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 🙌
@abcsc 2 ай бұрын
Hey Ravi, check out the webinar I did a few weeks ago on how to become an expert & leader in supply chain 🚀: kzbin.info/www/bejne/r17GhId6hbl4qbM
@Ravix_42 2 ай бұрын
@@abcsc ohh oke thank u Ed 🤍
@papicoco5069 2 ай бұрын
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!
@AbcSupplyChainFR 2 ай бұрын
That's awesome ! I hope your new job is going well 🚀
@papicoco5069 23 күн бұрын
Just an update! I became a supply planner instead, change of work roles due to reshuffling!
@lavendela9403 2 ай бұрын
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?
@abcsc Ай бұрын
Hi! Well, just sum up the sales of that item and use one row :)
@ajaykatiyar815 2 ай бұрын
Kindly make video to create a Dashboard for forecast accuracy, and KPIs
@abcsc Ай бұрын
Check our website we have tons of tools on the topic 😊
@ElaphAlhadi 2 ай бұрын
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
@abcsc Ай бұрын
Hi! well if you use a week period instead of a month period, then it is fine. At the end you just need to use an average/day (which can be an average over a week period)
@Nace_ 2 ай бұрын
Extremely helpful and well explained ! Bravo mon ami.
@Nace_ 2 ай бұрын
Extremely helpful and well explained ! Bravo mon ami.
@abcsc Ай бұрын
Thank you very much 😊
@GoMango392 3 ай бұрын
This is an amazing video. Thanks so much for doing so!
@abcsc Ай бұрын
I'm glad you ejoyed it 😊
@kabirhussain1725 3 ай бұрын
🎉🎉🎉 You are great and thanks for your efforts ❤
@abcsc Ай бұрын
Much appreciated 😊
@NS_Kat 3 ай бұрын
Thank you.
@abcsc Ай бұрын
😊
@johnanya6098 3 ай бұрын
My Dream job was to be an aeronautic engineer.😂
@Nezukochan-ed9fu 3 ай бұрын
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 3 ай бұрын
Great video! Thank you again for the great content!
@KiyoshiNagata-rd6hv 3 ай бұрын
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 2 ай бұрын
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 3 ай бұрын
Thank you for the wonderful session, Edouard!
@abcsc 3 ай бұрын
My pleasure, thank you for your feedback, let me know how it helps your career!
@peteradel557 3 ай бұрын
Great 🤩
@audreyarcos6228 3 ай бұрын
amazing explanations! you definitely brought clarity to this complex network , merci beaucoup!
@AbcSupplyChainFR 2 ай бұрын
I'm glad the video helped Audrey 😊
@KiyoshiNagata-rd6hv 3 ай бұрын
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 2 ай бұрын
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
@crissanee9392 3 ай бұрын
very helpful videos... thank you.
@bharatrasve3566 4 ай бұрын
Use match insted row