Inventory Management - Google Sheet
Vložit
- čas přidán 13. 09. 2024
- This video is one of my university projects. In this video, you will learn how to do Inventory Management. This inventory management will help you if you would like to start your own business. It will help you to keep track of your orders, sales, and deliveries. This is to avoid product overstock and outages.
Reference: • Google Sheets - Invent...
I do like your video, as others have said, it is clearly laid out with the details on the formulas. I want to point out an error in your calculations; at least, I am assuming you are not selling your items for the same price as it cost you to buy them. You need to add a column that differentiates your cost and your retail price. Additionally, I recommend having a columns that autopopulate information on your suppliers (because it makes it easier to remember who you last purchased from when you need to restock) and, possibly, establish a column that calculates your retail formula automatically, because your costs are likely to change over time (ideally, your inventory would track changes in prices; you may choose to update your inventory value based on FIFO, or first in - first out). Best to you!
Well described. Good teacher.
What a presentor machine!!
Unbelievable skill from this kid🔥🔥!!
What a comment!
thank you for the compliment!! This comment just made my dayy
Very help full, and I love the way you are making it easy
THIS VIDEO REALLY HELPS A LOT SPECIALLY FOR US WHO STARTS SMALL BUSINESS, THIS WAY WE CAN TRACK OUR SALES AND INVENTORY EASILY. KEEP IT UP AND MORE VIDEOS!
Thank you for sharing! :)
Thanks for this wonderful presentation... It is very helpful for me..
It's very confident and useful presentation . It's so interesting.
So nice of you! Thank you for your kind compliment.
Wowww idolaaaa. Saya support ika !!
Terima kasih kerana menyokong saya! hehe
great video thanks, your explanation is good keep it up
I really appreciate you very much for this video, just what I was looking for
Very nice presentation. I just started my business and this will be really helpfull for me.
thank youu!! goodluck in your business, really hope this video help you in managing your orders!
Very useful, thank you!
This was exactly what I was looking for 😃❤️
interesting presentation!!! thanks for the info
My pleasure! Grateful that you find this video interesting.
very clear explanation. it helped me a lot!!
Glad to hear that!!
what an interesting presentation this help a lot!
Thank you for your kind comment!!😁
thankyou somuch
Thank you for the explaination. Really help a lot
I am glad the video help youu! your welcomee😁
Exxellent!
its super help
such a good presentation🤩
Glad you think so!!
thank you for the tutorial !! Very helpful !!
You're welcome! I am glad that you find this video helpful!!
Awesome< can you do something like 2 tshirt designs, but like a few sizes???
Good presentation
So nice of you. Glad you think so!
Nice work
thank you! hopefully the video help you😊
mantap ika!! vv clear explaination 😌🤚🏼
thank youuuu nurinn💫 glad to hear that!
와.. 대박!! 그것은 나를 많이 돕는다 very helpful!!
제 영상을 사랑 해주셔서 감사합니다. hehe glad it helps you!! ^-^
thank you a lot ..... you really helped me out with some parts. like how I can Update my inventory after-sales. also how can I make a limitation to not go by minus in my items? if you know please help me out
veryyy good presentation!! 🤩😇
I am grateful for your kind words😊
good information! 👍🏼👍🏼
Thank youu! 👍
Good info!!👍
Glad you think so!
great tutorial ! thank you for making a clear explanation on this ^^
You're very welcome. I am glad that you find this video helpful!!
@@ikasyakirahkamarudinassalamu alaikum. please o want us to discuss something important regarding tutorial. How will I get in touch
Thanks for the video!!!!
No problem!!
Why don't you created criteria for Sales return of the specific sales? It would be appreciable if you do one.
AMAZING!!!
Thank You!!🙏🏼
very very helpful 👍🏼
Glad you think so!
Ayyeee thank you sis for making this video!!!
No problem!! Glad the video is helpful for you.
very helpful 😄👍🏻
Glad you think so!
This is really helpful!
Glad you think so!!
niceeeee so great!!!
big thanks! glad you like it.
Nicely done sis
Thank you for the visit! Glad you like it
Thank you! I really need this help😭
Your welcome!! hopefully the video is helpfull for you.
Cool 😎
thank you for the compliment!!
Alhamdulillah, great video 💪👍
It is better use the word 'share', instead of 'teach'
thank you! will surely take note of the word usage😁
aaaa very helpfulll thank youuuu
No problem!! I'm so glad you find it helpful
Can you kindly take your time and explain the formulas again please.
Can someone help me to design very simple inventory management for a hotel, where items use in rooms like shops blankets sheets coffee bags ( Items do not sell)need to track what we have now, receive and used and what to order as per parlavel
훌륭한 프리젠 테이션. 이제 제대로하는 방법을 알고 있습니다.
우산이 없다고 말하지 마세요.
제 영상을 사랑 해주셔서 감사합니다.
what will you do if you there is an additional item but you already finished doin the spreadsheet?
hai, you can always update your item in the "Items" sheet. Just add the item and it will show up at your dropdown list. hope this help!
@@ikasyakirahkamarudin thank you so much!
Thanks for the video! I just have one question, how do i calculate cost if purchase price changes often on the items?
hai, great to hear that it helps. If the cost for your item (exp : Carson Bag) changes, in ITEM sheet, you can always add another name for the items, add initial (exp: Carson Bag 1) and enter the new price. hope it helps! 😀
Type in youtube search : super inventory using google sheets, you'll find the answer of your question
🥵😍😍😍😍😍😍
😊😊😊😊💫
can u share me the file please
sound quality is not good
hi
Terema Kasi Sister.
your welcome, sir.
wow very2 interesting 👏🏼👏🏼👏🏼
thank you for the compliment!