No video

Inventory ABC Analysis

  Рет қаралды 301,627

Cary Countryman

Cary Countryman

Күн бұрын

Пікірлер: 126
@aissatatraore3467
@aissatatraore3467 5 жыл бұрын
because of that resource, I was able to understand and do my homework. Thank you, professor. nice, simple and very good procedure. always use him. I love it
@Govansossion
@Govansossion 5 жыл бұрын
Aissata Traore me too 😂
@lincolntrent8805
@lincolntrent8805 3 жыл бұрын
I dont mean to be so offtopic but does anyone know a tool to log back into an Instagram account? I was stupid lost my login password. I appreciate any assistance you can give me
@lucianoxavier9006
@lucianoxavier9006 3 жыл бұрын
@Lincoln Trent instablaster ;)
@lincolntrent8805
@lincolntrent8805 3 жыл бұрын
@Luciano Xavier thanks so much for your reply. I got to the site on google and Im in the hacking process atm. I see it takes a while so I will get back to you later when my account password hopefully is recovered.
@lincolntrent8805
@lincolntrent8805 3 жыл бұрын
@Luciano Xavier It did the trick and I finally got access to my account again. I am so happy:D Thanks so much, you saved my account!
@nellierachidi4801
@nellierachidi4801 6 жыл бұрын
I completed my assignment with ease after watching the video. Thank you Sir, it has been super helpful!
@carycountryman
@carycountryman 6 жыл бұрын
Glad it was helpful.
@montanaboy00
@montanaboy00 5 жыл бұрын
Here's a tip. When creating an anchor to a cell, just highlight the cell name in the formula (F15) and hit F4. You can hit F4 to tab through options of anchoring on the column, row, both or none. Also, when summing, select the cell where you want the total and click Alt=. This will auto sum the data you selected.
@teshiabrowne583
@teshiabrowne583 9 ай бұрын
Omg thank you a million times over for this video…helped me tremendously
@katherinesharp6869
@katherinesharp6869 3 жыл бұрын
Thank you so much for the excellent explanation. I now know how to do an ABC Analysis!!!
@hksecs
@hksecs 9 жыл бұрын
thank you sir! you're a gift from heaven!!
@raphthalia329
@raphthalia329 4 жыл бұрын
Clear, concise and easy to understand. Thank you. You just cleared up so much.
@carycountryman
@carycountryman 4 жыл бұрын
Thank you. I am glad you found it useful.
@ameypachade2005
@ameypachade2005 4 жыл бұрын
because of that resource, I was able to understand and do my homework. Thank you, professor. nice, simple and very good procedure
@ezfox2825
@ezfox2825 Жыл бұрын
Thank you sir, because of this video I will be able to implement an ABC cycle counting schedule at work.
@keithayers555
@keithayers555 Жыл бұрын
Perfect, explained to where anyone can understand it and do it.
@braaax4720
@braaax4720 2 ай бұрын
Very good video, thanks for that!
@pusitegasupovci8600
@pusitegasupovci8600 3 жыл бұрын
Thank you from Bosnia. Whery nice explained.
@BrandonKellyYT
@BrandonKellyYT Жыл бұрын
thank you so much for this, super helpful
@sound-engineer
@sound-engineer Жыл бұрын
Straight. No BS. Thank you.
@WrestlingVirality
@WrestlingVirality 5 жыл бұрын
This guy is JUST thrilled.
@carycountryman
@carycountryman 5 жыл бұрын
Thank you for the positive feedback
@mr.cuttingschool2665
@mr.cuttingschool2665 9 жыл бұрын
thanks alot Cary. I really gained alot. Great video. Keep up the good work
@abhiram3754
@abhiram3754 7 жыл бұрын
thankyou sir good explanation I like your explanation its more simplified and help me to clear my exam doubt
@Sathisharun06
@Sathisharun06 8 жыл бұрын
Thanks a lot sir. It was a clear explanation. To make it better add some enthusiastic flavor to your voice that could create a lot more difference, but still a wonderful job..!!!
@kavithaparmar7266
@kavithaparmar7266 Жыл бұрын
thank u so much,really helped me to prep for my university semester testttt
@PiyushKumar-gu1gu
@PiyushKumar-gu1gu 6 ай бұрын
Thank you, it was so helpful. 🙂
@khalilchettour325
@khalilchettour325 3 жыл бұрын
To apply this method , i need to extract the annual demand , the only data i have is ( On hand stock , average monthly consumption (APU ) , APU trend , demand variability ( COV ) ) .
@carycountryman
@carycountryman 3 жыл бұрын
This is a method to evaluate your inventory (categorize it based on value). While the example uses annual demand, you could just use stock on hand. We assume that this is the amount of inventory that you have on hand at any one time (this is your par level). Given the data that you have, this looks more like economic order quantity and safety stock. If you are trying to evaluate your inventory for an entire year, then you could multiple average monthly consumption by 12. If it is forward thinking (what might the inventory value look like in the future, then you could make adjustments based on trend and demand variability. You have to go back and determine what the question is asking. This method just categorizes your data based on value (high value items, medium value items, and low value items).
@orangerivertour465
@orangerivertour465 2 жыл бұрын
amazing simple explanation...THANKS!!
@trendtradertrender4328
@trendtradertrender4328 Жыл бұрын
such a great video, thanks for that Cary
@potassiumcyanide3857
@potassiumcyanide3857 Жыл бұрын
Best and simplest explanation
@tinikomindo6697
@tinikomindo6697 3 жыл бұрын
Great video thanks man appreciate it a lot now I'm ready for my finals
@0801rambo0
@0801rambo0 4 жыл бұрын
man i am new at this thank you very much Cary...cheers
@carycountryman
@carycountryman 4 жыл бұрын
I am glad that you found it useful.
@geoffreychikwale9532
@geoffreychikwale9532 3 жыл бұрын
@@carycountryman how do you find the percentage quantity?
@carycountryman
@carycountryman 3 жыл бұрын
@@geoffreychikwale9532 Percentage quantity is the value of the inventory item compared to the entire value of the inventory (value of inventory item divided by the sum total of the entire inventory value). As for the breakdown of categories (A,B,C), it is somewhat flexible but the A category should be around 80% of your inventory value. B category is 12-15 % and the C category is everything that is left (the remaining 5-8%).
@geoffreychikwale9532
@geoffreychikwale9532 3 жыл бұрын
@@carycountryman Thank You very much! I got it
@garthak1380
@garthak1380 3 жыл бұрын
Thanks so much! Whew! Was going over my head here for a bit lol.
@geoffreychikwale9532
@geoffreychikwale9532 3 жыл бұрын
How do you calculate Quantity Percentage?
@garthak1380
@garthak1380 3 жыл бұрын
@@geoffreychikwale9532 not going to lie, I have no clue. I am knee deep in my last four classes. I am an Aeronautics Major, this was just a class I had to take as a part of my minors in management. I am sure there is a video somewhere explaining quantity percentage. Sorry I can’t really be of no help man. Wish I knew.
@geoffreychikwale9532
@geoffreychikwale9532 3 жыл бұрын
@@garthak1380 alright I understand. I thought you have an idea
@GracieSulla1529
@GracieSulla1529 2 жыл бұрын
Thank you so much for this
@user-lp9bl5uv1h
@user-lp9bl5uv1h 10 ай бұрын
Thank you
@carycountryman
@carycountryman 10 ай бұрын
I am glad that you found it helpful. These videos were created some time ago but it appears that people still find them useful.
@bengeorge92
@bengeorge92 9 жыл бұрын
That was a great video. Thanks for making it!
@warbladz
@warbladz 2 жыл бұрын
This helped me a lot Thank You!
@longle3928
@longle3928 9 жыл бұрын
Thank you sir, very good explanation
@Mothly1
@Mothly1 9 жыл бұрын
Thank you so much! Super comprehensive I completely understand now :)
@aricroods4891
@aricroods4891 3 жыл бұрын
That was so helpful, thank you so much❤
@carycountryman
@carycountryman 3 жыл бұрын
I am glad you found it helpful
@janekarla2894
@janekarla2894 9 жыл бұрын
Thank you sir! a great help to my research :)
@eduardoramosvillarreal1778
@eduardoramosvillarreal1778 2 жыл бұрын
Super helpful sir ,thank you so much!
@engr.muhammadimrankhan2135
@engr.muhammadimrankhan2135 9 жыл бұрын
Hello Sir. Sir you teach very well but one problem in the question that what we learn from the book that class B contain 20-25% of the total inventory and C almost 55% but the question you solved contain large amount of B than C.
@carycountryman
@carycountryman 9 жыл бұрын
Engineer Muhammad Imran This is true if you are looking at the number of items instead of the value. You will find that the ABC method is very similar to Pareto in that 20% of your inventory items may constitute 80% of the value of the inventory. ABC looks at the value of the inventory and not the number of inventory items.
@rishirohan7857
@rishirohan7857 9 жыл бұрын
Very good explanation. Thank You Sir. I was having a doubt whether it is the cost of an item or the percentage of an item in total inventory that is classifying criteria.
@mohammedshamaz6174
@mohammedshamaz6174 6 жыл бұрын
here the percentage of the item is the inventory value
@saraseifi4540
@saraseifi4540 9 жыл бұрын
Thank you , it was really useful for me the get the final meaning of ABC analysis
@phahlengmampane928
@phahlengmampane928 9 жыл бұрын
You are welcome Seifi....
@MyLe-up6gm
@MyLe-up6gm 10 жыл бұрын
Thank you for your video. It is really helpful :)
@SharedDestiny
@SharedDestiny 2 жыл бұрын
Thank you for sharing Sir..
@kylepalmieri2377
@kylepalmieri2377 4 жыл бұрын
Very helpful, thank you!
@carycountryman
@carycountryman 4 жыл бұрын
Glad it was helpful!
@Checkerhola
@Checkerhola 7 жыл бұрын
Great video. Extremely helpful!
@adityadeshmukh6154
@adityadeshmukh6154 Жыл бұрын
You should add the headings of column such as item, annual demand
@carycountryman
@carycountryman Жыл бұрын
I do have those headings. The additional columns are just calculations to determine where the cutoffs are for the various groups.
@senthilkumarpatchai7309
@senthilkumarpatchai7309 4 жыл бұрын
Splendid !
@carycountryman
@carycountryman 4 жыл бұрын
I am glad that you find these videos helpful and thanks for the feedback
@Sniper1st
@Sniper1st 6 жыл бұрын
Thank you so much, well explained
@carycountryman
@carycountryman 6 жыл бұрын
Thank you. I am glad that you found it useful.
@ayazzafar4602
@ayazzafar4602 3 жыл бұрын
Good explanation What if we have hundreds of products
@carycountryman
@carycountryman 3 жыл бұрын
The categories are still a certain percentage of the total inventory value, no matter how large the inventory. A larger number of total products would mean that there will be a larger number of products in each category.
@markvanson6199
@markvanson6199 5 жыл бұрын
Thats clear, thanks.
@brddks7629
@brddks7629 3 жыл бұрын
Good
@justme8410
@justme8410 4 жыл бұрын
“...THOUSAND dollars...” LOL dude
@makethingseasy6707
@makethingseasy6707 5 жыл бұрын
Its a nice video, same video is available in my channel, explained in a very easy way
@gokulgoku7675
@gokulgoku7675 3 жыл бұрын
Thnk u
@Kiuma1907
@Kiuma1907 9 жыл бұрын
Thanks a lot!!
@mycalabar4298
@mycalabar4298 8 жыл бұрын
Hi Cary, using the data from this example in your video, in determining the EOQ for the class A items would you use the class A item with the highest percentage or would you calculate the EOQ for each class A item? Your video on EOQ doesn't answer the query that is why I ask the question here. I am working with data that gives me a similar statistic and I'm tuck with calculating the EOQ, thus the question. Thank you.
@carycountryman
@carycountryman 8 жыл бұрын
+mycalabar I responded to your question posted in the comments to EOQ video. ABC analysis is a separate technique that has to do with classifying or categorizing your inventory. Economic Order Quantity has to do with ordering inventory. Therefore, you would calculate the economic order quantity for each inventory item. EOQ balances the ordering costs with the holding costs but does not necessarily evaluate the inventory from a value standpoint like ABC analysis.
@shaikumair6161
@shaikumair6161 4 жыл бұрын
WHAT IS VALUE , IS IT A INVESTMENT? IF INVESTMENT THEN WHAT KIND OF INVESTMENT ,LIKE THE AMOUNT SPENT BY THE COMPANY TO MAKE THE PRODUCT OR THE INVESTMENT DONE BY CUSTOMER TO PURCHASE THE PRODUCT ?
@carycountryman
@carycountryman 4 жыл бұрын
This is the value of your inventory. Most companies track it by the cost but wholesalers/retailers may want to base the value on the price to the customer. This method is a way to identify elements of your inventory that are of high value and therefore would have stricter inventory control measures.
@connordecker1163
@connordecker1163 7 жыл бұрын
Thank you so much!
@carycountryman
@carycountryman 6 жыл бұрын
Your welcome. Glad to be of assistance.
@fredrickmesiack1112
@fredrickmesiack1112 8 жыл бұрын
NICE EXPLANATION
@carycountryman
@carycountryman 6 жыл бұрын
Thank you. The videos are not of the highest quality. One of the days when I have more time, I need to redo some of them but I am happy that people find them useful.
@Geekygal5839
@Geekygal5839 9 жыл бұрын
Disappointed....was expecting a formula to automatically group AB&C. I have thousand and thousand of rows of this kind of data. It's too time consuming to do it this way. But your explanations were very good.
@carycountryman
@carycountryman 9 жыл бұрын
Christine Weiler The grouping is designed to be somewhat flexible. The most important part of this technique is simply sorting your inventory from the highest value to the lowest value. You probably want to have tighter controls and monitor inventory items at the top of the list versus those at the bottom of the list. You can easily calculate the percentage of inventory value for each item and sort the list very quickly with lots of data (thousands and thousands of rows). I wouldn't worry about the categories. This is simply an extra step to group your inventory into three categories based on inventory value. The most important element of this technique is the sorting of your inventory. Not all inventory items are of equal value and you need to know which ones are most important.
@kkbhokal1514
@kkbhokal1514 6 жыл бұрын
Nice
@waqi1980
@waqi1980 2 жыл бұрын
can you plz tel how to do the analysis of suppliers when only purchase price is available
@carycountryman
@carycountryman 2 жыл бұрын
Purchase price is just another term for cost. Purchase price is the cost to the company to purchase that inventory.
@mansoorahmad1291
@mansoorahmad1291 9 жыл бұрын
Very Good Video Sir but I have little confusion, In ABC Analysis, I have problem in data that some items having low unit price but too much quantity which result in high percentage individual value and some items with high unit price but low quantity which result in low percentage individual value in overall.I want to clarify that I arrange this data according to unit price or percentage value ( Largest to smallest)? Can u help me?
@carycountryman
@carycountryman 9 жыл бұрын
Mansoor Ahmad If you have an inventory with high unit prices, you may want to use just the unit prices to sort the data. This is an acceptable variation to ABC Analysis. Another variation is inventory items that are difficult to acquire and therefore, you have to manage these inventory items very carefully as compared to more common inventory items. ABC Analysis is all about managing your inventory strategically and not treating all inventory items as the same (same value to the company). For example, most small companies don't track the inventory of pencils, pens, and writing pads. They simply order more when they need more. However, other items like computers or electronic devices may be monitored much more closely. In fact, these inventory items are usually checked out to individuals and checked back in on a regular basis.
@mansoorahmad1291
@mansoorahmad1291 9 жыл бұрын
Cary Countryman Thank you alot sir
@shorouqahmad6782
@shorouqahmad6782 6 жыл бұрын
Hello Cary :) Can I replace the annual demand with the current number of units at my inventory?
@carycountryman
@carycountryman 6 жыл бұрын
You could do that if the current amount of your inventory is the typical or average amount that you carry of each item. You are just trying to categorize your inventory to realize that not all inventory items are of equal value. Category A are your high valued items and they require tighter controls than Category C items.
@rizadauel7771
@rizadauel7771 7 жыл бұрын
thanks a lot sir
@carycountryman
@carycountryman 6 жыл бұрын
Your welcome. I am glad that you found it helpful
@tokaahontaas2273
@tokaahontaas2273 8 жыл бұрын
thank you!
@richyrich4684
@richyrich4684 9 жыл бұрын
Thank You.
@jasonblando5196
@jasonblando5196 5 жыл бұрын
what if the given data is USAGE PER WEEK instead of ANNUAL DEMAND?? how am i going to solve that? thankyou
@carycountryman
@carycountryman 5 жыл бұрын
As long as all of the units are listed as usage per week (all units are recorded using the same time period), you can multiple the unit price by the usage per week.
@abhisekhsatapathy
@abhisekhsatapathy 8 жыл бұрын
thanx buddy
@altamashkhan5009
@altamashkhan5009 8 жыл бұрын
sir in abc analysis some items having low unit price but too much quantity which result in high percentage individual value and they not follow 10% of items covering 70% of total value and finally how to do graph
@carycountryman
@carycountryman 8 жыл бұрын
+Altamash khan The traditional way is to multiple unit price by quantity but some ABC analysis uses just the unit price. In defense of the traditional way, one may have an inventory item with low unit cost but a lot of it and therefore it does add up to a large percentage of your inventory value which could mean significant financial losses if something were to happen to it. If it is really necessary to have this amount or quantity (the assumption is made that they are following Just-In-Time inventory and they have just what they need), having large quantities does create some vulnerability or exposure (i.e. stolen, damaged, obsolete, etc.) and if it does constitute a large value of your inventory, one may want to keep a watchful eye on it. I usually do not worry about graphing this but you could do a column chart.
@altamashkhan5009
@altamashkhan5009 8 жыл бұрын
can you please tell me how to draw column chart
@carycountryman
@carycountryman 8 жыл бұрын
+Altamash khan It depends on what version of Excel you are using. On a PC, you would use the menu and Insert a Chart. On a Mac, you would use the Chart Tab. You want to highlight the inventory item name and the percentage (after the list is sorted from highest to lowest) and select a Column Chart. You can then edit the chart to identify all of the A items, B items, and C items. You can just add a text box or change the color of the column: each classification using a different color.
@carycountryman
@carycountryman 8 жыл бұрын
+First Name Yes, that is correct ABC Analysis includes all of your inventory to help you know what inventory items need to be tracked and to what degree. Inventory items categorized as A items would have the strongest controls, this type of item is often assigned to someone, usually has an inventory tracking sticker, and has to be signed out (issued). While C items, are usually keep in a common storage place and are used as part of the ongoing process. These may include things like pencils, markers, pads of paper, etc.
@sethfrimpong4829
@sethfrimpong4829 7 жыл бұрын
Al
@LetCode96666
@LetCode96666 7 жыл бұрын
Helpful :)
@dr.ramdaskendre2694
@dr.ramdaskendre2694 7 жыл бұрын
sir thank you
@camillelau2781
@camillelau2781 7 жыл бұрын
thank you
@Wishmaster19911
@Wishmaster19911 7 жыл бұрын
Thanks
@liyakathali4832
@liyakathali4832 9 жыл бұрын
Thank you for ur valuable class sir
@abjohnson1740
@abjohnson1740 2 жыл бұрын
I'm having a question please
@carycountryman
@carycountryman 2 жыл бұрын
What is your question?
@abjohnson1740
@abjohnson1740 2 жыл бұрын
I was given a question in class! and to calculate the percentages, my lecturer took each Annual Usage (Demande) ÷ By the Total to get the percentage, But from your solution i saw you took The Annual Value(annual demande × cost) of each to divide with the Total Annual Value
@abjohnson1740
@abjohnson1740 2 жыл бұрын
I'm lose 😔
@carycountryman
@carycountryman 2 жыл бұрын
@@abjohnson1740 You can do ABC Analysis just using the demand. This would categorize your inventory by the usage or demand with the highest demand or usage being in Category A. However, this doesn't account for items that may be very few but each item is worth a lot of money. I prefer to do ABC analysis based on the value of the inventory item (demand x cost). You could also do ABC analysis just using cost with the A category being those inventory items with the highest cost. If your lecturer just wants you to do ABC analysis based on demand, then just calculate the percentage of each inventory item based on the total number of items demanded. Category A would be those inventory items that constituted 75-80% of the total demand of the inventory.
@abjohnson1740
@abjohnson1740 2 жыл бұрын
Thanks very Much!!!! Stay blessed!
ABC Analysis : Step-by-Step Tutorial in Excel with 500 products
21:57
AbcSupplyChain
Рет қаралды 101 М.
Inventory Analysis
15:48
Chris Harper
Рет қаралды 17 М.
Violet Beauregarde Doll🫐
00:58
PIRANKA
Рет қаралды 32 МЛН
Kind Waiter's Gesture to Homeless Boy #shorts
00:32
I migliori trucchetti di Fabiosa
Рет қаралды 15 МЛН
КТО ЛЮБИТ ГРИБЫ?? #shorts
00:24
Паша Осадчий
Рет қаралды 3,7 МЛН
拉了好大一坨#斗罗大陆#唐三小舞#小丑
00:11
超凡蜘蛛
Рет қаралды 14 МЛН
ABC Analysis - Example 1
7:06
maxus knowledge
Рет қаралды 38 М.
Inventory Economic Order Quantity EOQ
15:02
Cary Countryman
Рет қаралды 47 М.
Calculating Safety Stock: Protecting Against Stock Outs
6:17
Ian Johnson
Рет қаралды 296 М.
This is how I ACTUALLY analyze data using Excel
24:05
Mo Chen
Рет қаралды 167 М.
Is Excel Dead? Meet the ChatGPT Data Analyst.
9:33
Kevin Stratvert
Рет қаралды 470 М.
Make Impressive McKinsey Visuals in Excel!
16:47
Kenji Explains
Рет қаралды 295 М.
Using ABC XYZ for demand planning
46:11
Nicolas Vandeput
Рет қаралды 10 М.
Violet Beauregarde Doll🫐
00:58
PIRANKA
Рет қаралды 32 МЛН