- 27
- 625 343
AbcSupplyChain
United States
Приєднався 17 тра 2021
🎯 The Online School for Supply Chain Experts & Leaders
🚀 Boost your skills & careers in less than 4 weeks 🚀
🌍 +130K professionals use our tools & methods 🌍
👨👩👧👦 Thousands of members part of the AbcSupplyChain family 👨👩👧👦
🎯 Keep it simple with real-life examples and 20/80 approach 🎯
😌 Reinventing more efficient and regenerative supply chains ⚖️
► Your challenges
-How to optimize your Supply Chain ?
-How to improve your inventory management ?
-How to increase your service rate ?
-How to improve your forecast accuracy ?
-What tools & software to use ?
-How to boost your career and get your dream job ?
► For the last 15 years, no matter which countries, size of the company or industry, I got these same questions while I was working as :
-Warehouse worker
-Demand Planner
-Supply Chain & Logistics Project Manager
-Supply Chain Manager
-S&OP Manager
-Supply Chain Director
-Supply Chain Consultant
-Entrepreneur
-UA-camr 🫣
Enjoy 😃
Edouard Thieuleux - Founder of AbcSupplyChain
🚀 Boost your skills & careers in less than 4 weeks 🚀
🌍 +130K professionals use our tools & methods 🌍
👨👩👧👦 Thousands of members part of the AbcSupplyChain family 👨👩👧👦
🎯 Keep it simple with real-life examples and 20/80 approach 🎯
😌 Reinventing more efficient and regenerative supply chains ⚖️
► Your challenges
-How to optimize your Supply Chain ?
-How to improve your inventory management ?
-How to increase your service rate ?
-How to improve your forecast accuracy ?
-What tools & software to use ?
-How to boost your career and get your dream job ?
► For the last 15 years, no matter which countries, size of the company or industry, I got these same questions while I was working as :
-Warehouse worker
-Demand Planner
-Supply Chain & Logistics Project Manager
-Supply Chain Manager
-S&OP Manager
-Supply Chain Director
-Supply Chain Consultant
-Entrepreneur
-UA-camr 🫣
Enjoy 😃
Edouard Thieuleux - Founder of AbcSupplyChain
Value Chain Analysis Explained: Definition, Evolution, Examples, Models
Download my free 56-slide presentation on value chain analysis 🙌
👉 abcsupplychain.com/download-value-chain/
What is your value chain?
How will you bring more value to your company and your customers? 🚀💰😁
Our value chains have come a long way since Michael Porter's introduction in 1948.
It's no longer just about producing the cheapest manufactured goods.
Chapters :
00:00 - Introduction
00:00 - Porter's value chain
02:11 - Value chain definition
04:32 - Value chain optimization
05:48 - History of the value chain
08:37 - The role of the Supply Chain in the value chain
09:54 - Measuring the value of the Supply Chain
12:50 - Our KPI tutorials and training courses
13:20 - The future of the value chain
16:47 - How to contribute to this value chain?
17:12 - Our strategic skills assessments
OUR FREE ASSESSMENTS: 🎯
- 💪🏻 Supply Chain Skills Assessment: assessment.abcsupplychain.com/supply-chain-assessment
- 🚀 Supply Chain Performance Assessment: assessment.abcsupplychain.com/performance-assessment
- 💰 Supply Chain Salary Calculator : abcsupplychain.com/supply-chain-salary-calculator/
OUR FREE 5 MINI COURSES: 👨🏫
- 🎁 abcsupplychain.com/free-supply-chain-management-courses/
OUR CERTIFIED TRAININGS :
- 📦 Inventory Management : abcsupplychain.com/inventory-management-course/
- 📈 Forecasting : abcsupplychain.com/demand-forecasting-course/
- 🛠️ Excel Expertise : abcsupplychain.com/excel-course/
- 📊 Data Analytics : abcsupplychain.com/supply-chain-analytics-course/
FIND US HERE:
🌍 Our Website / Blog - abcsupplychain.com/
✉️ E-Mail : contact@abcsupplychain.com
👨💻 Linkedin - www.linkedin.com/in/edouardthieuleux/
👉 abcsupplychain.com/download-value-chain/
What is your value chain?
How will you bring more value to your company and your customers? 🚀💰😁
Our value chains have come a long way since Michael Porter's introduction in 1948.
It's no longer just about producing the cheapest manufactured goods.
Chapters :
00:00 - Introduction
00:00 - Porter's value chain
02:11 - Value chain definition
04:32 - Value chain optimization
05:48 - History of the value chain
08:37 - The role of the Supply Chain in the value chain
09:54 - Measuring the value of the Supply Chain
12:50 - Our KPI tutorials and training courses
13:20 - The future of the value chain
16:47 - How to contribute to this value chain?
17:12 - Our strategic skills assessments
OUR FREE ASSESSMENTS: 🎯
- 💪🏻 Supply Chain Skills Assessment: assessment.abcsupplychain.com/supply-chain-assessment
- 🚀 Supply Chain Performance Assessment: assessment.abcsupplychain.com/performance-assessment
- 💰 Supply Chain Salary Calculator : abcsupplychain.com/supply-chain-salary-calculator/
OUR FREE 5 MINI COURSES: 👨🏫
- 🎁 abcsupplychain.com/free-supply-chain-management-courses/
OUR CERTIFIED TRAININGS :
- 📦 Inventory Management : abcsupplychain.com/inventory-management-course/
- 📈 Forecasting : abcsupplychain.com/demand-forecasting-course/
- 🛠️ Excel Expertise : abcsupplychain.com/excel-course/
- 📊 Data Analytics : abcsupplychain.com/supply-chain-analytics-course/
FIND US HERE:
🌍 Our Website / Blog - abcsupplychain.com/
✉️ E-Mail : contact@abcsupplychain.com
👨💻 Linkedin - www.linkedin.com/in/edouardthieuleux/
Переглядів: 849
Відео
The Supply Chain Problem of Louis Vuitton
Переглядів 1,1 тис.Місяць тому
@louisvuitton BIG inventory problem 📦 and here is what we can learn ➗ Over the past 2 years, LV's revenue hasn’t kept pace with inventory growth-a major issue in the luxury world. LV's issue isn’t just supply chain-it's a Product Range Strategy problem. They’ve shifted from iconic handbags to fast fashion (think surf shorts and flip-flops), targeting a broader market, but unlike Zara, they can’...
The 10 Best Supply Chain & Logistics KPIS in Excel (Key Performance Indicator)
Переглядів 2,7 тис.Місяць тому
What are the 10 most important KPIs for your supply chain & logistics? Download the Excel with the 10 Supply Chain KPIS: abcsupplychain.com/excel-10-best-kpis/ 00:00 - Introduction KPIs 00:35 - 3 Pillars of supply chain KPIs 01:28 - Availability Rate 02:53 - Fill Rate / (Delivery In Full) 04:24 - Inventory Turnover (Stock Turn) 06:20 - SLOB: Slow Moving & Obsolete (Excess Inventory) 08:03 - Inv...
How to become a Supply Chain Manager, Expert & Leader : Complete Strategy in 7 Pillars
Переглядів 2,3 тис.4 місяці тому
🎯 Free Supply Chain Skills Assessment (less than 10min): assessment.abcsupplychain.com/supply-chain-assessment 🛠️ Our Certified AbcSupplyChain Training: abcsupplychain.com/courses-supply-chain-logistics/ Chapters: 00:55 Intro 07:58 1st Pillar: Know what you want and why 18:02 2nd Pillar: Diplomas & Certifications 28:10 3rd Pillar: Experience 37:43 4th Pillar: Hard Skills 45:10 5th Pillar: Soft ...
How to Generate More Accurate Sales Forecasts Masterclass: Process, Formulas, Tools, Excel, S&OP
Переглядів 3 тис.5 місяців тому
We are co-hosting this MasterClass with my good Friend Mario Vitofrancesco, the world Forecasting & Machine Learning Expert from Amazon. Summary tab: 1. How we became Forecasting Experts 👨🏫 04:30 2. How to deal with demand uncertainty 🎢 09:25 3. Who owns the forecasting process 👨👩👦👦 24:25 4. How to forecast sales with inaccurate data 🤹 30:58 5. How to choose the best forecasting model 📊 36:...
Supply Chain Salary & Jobs 2024 Guide: Demand Planning, Logistics, Procurement, Consulting
Переглядів 6 тис.5 місяців тому
Use our free Salary & Career Path simulator here : abcsupplychain.com/supply-chain-salary-simulator/ How much are you worth? Are you paid enough?💰 I remember being confused about which job to choose next to fast-track my career🚀 After 12 months of research & data crunching, we created THE guide I wish I had as an employee, manager, director, consultant, and recruiter. We just published our ulti...
Presentation AbcSupplyChain
Переглядів 2,8 тис.7 місяців тому
Discover our SCM Expert Methods & Download our free EXCEL : abcsupplychain.com/ #supplychain #logistics
Forecasting Sales for New Products: Step-by-Step Guide (Fashion, Innovations, Financial...)
Переглядів 4,6 тис.9 місяців тому
How to forecast the Demand for New Products accurately like Apple or Zara? 👗🎯📱 Doing it wrong can have a painful impact on sales, overstock & stress 😮💨 First of all, there are 3 different types of new products: 1)Similar stable product with variation: new red bike last year vs blue bike this year 2)Fast Fashion product: Zara's new collection every 4 weeks 3)Innovative product, disruptive for t...
Seasonality in Time Series: Integrate it into Demand Forecasting (Full Excel Tutorial)
Переглядів 11 тис.Рік тому
Download the seasonal time series and forecasts here: abcsupplychain.com/download-seasonality-forecast/ Join my Demand Forecasting WORKSHOP (free): abcsupplychain.com/demand-forecasting-webinar/? How do you deal with monthly, quarterly, or yearly cycles in your business? 🔄 🤷♂️ Integrating them into your forecasts is essential to allocate the right resources (time, money, people) at the right t...
How to Use Chat GPT for Sales Forecasting in Excel: Full Tutorial
Переглядів 13 тис.Рік тому
Download the ChatGPT forecast and Native Excel forecast sheets here: abcsupplychain.com/download-excel-chat-gpt/ Join my Demand Forecasting WORKSHOP (free): abcsupplychain.com/demand-forecasting-webinar/? I uploaded my forecasting Excel file to ChatGPT. Here is what happened 🤯 -Straight after, ChatGPT was able to understand my time series (over 10 years of sales history from Amazon) -Only 1 pr...
Forecast Accuracy Formula: 4 Easy Calculations in Excel
Переглядів 24 тис.Рік тому
Download the Forecast Accuracy Calculation in Excel here: abcsupplychain.com/forecast-accuracy-formula-excel/ Join my Demand Forecasting WORKSHOP (free): abcsupplychain.com/demand-forecasting-webinar/? How to Track & Improve Forecast Accuracy? 🎯 In my new UA-cam Video, I released a step-by-step tutorial with 4 straightforward forecast accuracy formulas in Excel. No matter if you forecast sales,...
Inventory Target 📦🎯: Step-By-Step Forecasting Tutorial with examples (inventory budget)
Переглядів 19 тис.Рік тому
How to define your perfect inventory target to ensure the right service level & cashflow for your company. Forecast Tutorial & real business examples. ► Free SCM WORKSHOP: abcsupplychain.com/free-supply-chain-course/ -Why I have never reached the perfect level of inventory -Why inventory turnover makes more sense than inventory value -Forecast Top Down vs Forecast Bottom up -How to calculate th...
Inventory Costs: 12 parameters to consider with examples (inventory valuation methods)
Переглядів 8 тис.Рік тому
Join my Inventory Management WORKSHOP (free): abcsupplychain.com/inventory-management-workshop/ How much does your inventory really cost? 🤷♂️💰📦 3% a year? 10%? 15%? Inventory costs are not only the costs of money & storage ❌ And by underestimating these costs, we tend to focus too much on our customer service levels: "Customer First !" A few months after, we pay the real price of having undere...
Inventory Control: How to Track Inventory Accuracy? (Stocktake, Excel Calculation Tutorial)
Переглядів 10 тис.Рік тому
Download the Inventory Control Accuracy KPi Calculation in Excel here: abcsupplychain.com/download-inventory-accuracy/ Join my Inventory Management WORKSHOP (free): abcsupplychain.com/inventory-management-workshop/ How bad is your inventory accuracy? 📦🎯📦 On average, 35% of our inventory is inaccurate. And most of the time, we have less than expected 😢 Here are the 8 reasons why stock discrepanc...
Supply Chain Lead Time: How to Track & Optimize (calculation & example in Excel)
Переглядів 22 тис.Рік тому
Download the Lead Time Calculation in Excel here: abcsupplychain.com/download-excel-lead-time/ Join my Inventory Management WORKSHOP (free): abcsupplychain.com/inventory-management-workshop/ How efficient is your supply chain lead time? 🚀⏱️ Here are the 8 classic mistakes most of us end up making 🙅♂️❌: We don't even track our lead time We trust our transporter/supplier contract lead time We on...
SLOB: Slow Moving & Obsolete Inventory Calculation in Excel (step-by-step tutorial)
Переглядів 24 тис.2 роки тому
SLOB: Slow Moving & Obsolete Inventory Calculation in Excel (step-by-step tutorial)
How to optimize Inventory: 11 proven inventory reduction strategies
Переглядів 28 тис.2 роки тому
How to optimize Inventory: 11 proven inventory reduction strategies
ABC XYZ Analysis for Inventory Management: Example in Excel (Full Tutorial)
Переглядів 60 тис.2 роки тому
ABC XYZ Analysis for Inventory Management: Example in Excel (Full Tutorial)
6 Best Safety Stock Formulas: Calculation & Examples in Excel (Full TUTORIAL)
Переглядів 96 тис.2 роки тому
6 Best Safety Stock Formulas: Calculation & Examples in Excel (Full TUTORIAL)
EOQ Formula with examples in Excel (Economic Order Quantity for Inventory Management)
Переглядів 22 тис.2 роки тому
EOQ Formula with examples in Excel (Economic Order Quantity for Inventory Management)
What is Supply Chain Management (SCM)? Simple definition with examples
Переглядів 14 тис.2 роки тому
What is Supply Chain Management (SCM)? Simple definition with examples
Supply Chain Crisis: Inflation, Shortages. How to get through it ?
Переглядів 3,9 тис.2 роки тому
Supply Chain Crisis: Inflation, Shortages. How to get through it ?
Inventory Turnover Ratio Formula & Calculation : Step-by-Step tutorial in Excel
Переглядів 36 тис.2 роки тому
Inventory Turnover Ratio Formula & Calculation : Step-by-Step tutorial in Excel
Blockchain in Supply Chain : Why & How to Start using it today
Переглядів 11 тис.2 роки тому
Blockchain in Supply Chain : Why & How to Start using it today
Supply Chain KPI Service: OTIF, DIFOT, Fill Rate: Calculation & Formulas in Excel
Переглядів 60 тис.3 роки тому
Supply Chain KPI Service: OTIF, DIFOT, Fill Rate: Calculation & Formulas in Excel
ABC Analysis : Step-by-Step Tutorial in Excel with 500 products
Переглядів 106 тис.3 роки тому
ABC Analysis : Step-by-Step Tutorial in Excel with 500 products
How to Forecast with Excel in less than 5 minutes : Tutorial & Forecasting Models
Переглядів 35 тис.3 роки тому
How to Forecast with Excel in less than 5 minutes : Tutorial & Forecasting Models
great..👍
Hi @AbcSupplyChain, have you used Demand and sales interchangeably ?
Competitive advantage in 1948 you mean 1984 😅😅😅
great stuff , always like the simplicity you use
Thanks for the feedback Sylvester 😊 I hope you're doing well
Thanks for the insights! Always great to hop on YT and see a new video from ABCSupplyChain!
Download my free 56-slide presentation on value chain analysis 🙌 👉 abcsupplychain.com/download-value-chain/
😂 I see now that I’m not the only one who speaks softly and nicely to ChatGPT ensuring my place in the future just in case of some Terminator type judgment day. Thanks so much for this tutorial.
😂 See you on the other side of judgement day Andrezia ! 🤖
Amazing, what a great sharing! Really appreciated. Looking forward more video
Thanks a lot sir It was helpful for me
Excelent content!
76861 Bernadine Junction
Thank you for sharing your massive supply chain knowledge Edouard
Magnifique !! Thanks for doing content like that!!
Glad you liked it! I'm going to try to release this format more frequently 😊
Nice Info ..
can we have the tutorials for seasonality as well,please
Thanks for the content idea 👍🏼
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. :)
Wonderful video, very informative. Thank you so much.
How to calculate Average stock COGS for each product, sir?
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.
Ondricka Pine
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 :)
I'm glad Eric, best of luck on your supply chain adventures 🚀
Thank you so much Eduard for your great work and sharing with us.
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.
I'm glad the channel will be useful! Best of luck for your studies 👍🏼
Very Helpful Much thanks @AbcSupplyChain
Enjoy the video Jacob 👍🏼
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
Hey Byron, Seems like you have a very specific projet on your hands 😉 Best of luck 🚀
@@abcsc ohh yes and it would be of great appreciation if you help me
Thanks Eduard, great video and a lot of value in it :)
Thanks Florian! I'm glad you enjoyed it 👍🏼
Download the Excel with the 10 Supply Chain KPIs: abcsupplychain.com/excel-10-best-kpis/
Hi Eduard, I tried the link but it is not working?
@@zoeaustralia7229 Just checked and everything seems to be working 😊 Check Spam folder or maybe a small mistake in the e-mail adress you provided 👍🏼
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
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.
Hey man, great content! What would be the best method for intermittent demand like spare parts?
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
Great work!
I'm glad you enjoyed it 😊
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?
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.
good video, but this is not works for retail replenishment.
Hi! Thank you for your positive feedback. What do you mean by it doesn't work for retail replenishment?
Great Great Great, more videos pls
Many coming out soon 😊
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)
Big thanks from Iraq for your efforts 🙏
You're welcome 😊
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?
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
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 🙌
Hey Ravi, check out the webinar I did a few weeks ago on how to become an expert & leader in supply chain 🚀: ua-cam.com/video/y-cSTDPTEsQ/v-deo.html
@@abcsc ohh oke thank u Ed 🤍
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!
That's awesome ! I hope your new job is going well 🚀
Just an update! I became a supply planner instead, change of work roles due to reshuffling!
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?
Hi! Well, just sum up the sales of that item and use one row :)
Kindly make video to create a Dashboard for forecast accuracy, and KPIs
Check our website we have tons of tools on the topic 😊
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
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)
Extremely helpful and well explained ! Bravo mon ami.
Extremely helpful and well explained ! Bravo mon ami.
Thank you very much 😊
This is an amazing video. Thanks so much for doing so!
I'm glad you ejoyed it 😊
🎉🎉🎉 You are great and thanks for your efforts ❤
Much appreciated 😊
Thank you.
😊
My Dream job was to be an aeronautic engineer.😂
This is awesome, such a great insight. I really wish if there was any scholarship available for your courses. Thank you Edouard and team :)
Great video! Thank you again for the great content!
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
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
Thank you for the wonderful session, Edouard!
My pleasure, thank you for your feedback, let me know how it helps your career!