Hi thanks that was awesome. I need to forecast by part number because my SKUs are kits. Do you have a template or advice for that situation? Each SKU has 3-8 components. Thanks!
We don't have content with specific advice for complicated situations like this, but we may be able to help you set up a tool to track all of this. ledgergurus.com/ecommerce-accounting-services/inventory-management-for-ecommerce/?RUclips&
@@mei-meiyu8849 We don't have anything like that yet, but that will probably change in the next few months. We've just brought on several new members of our inventory team, and we will cranking out inventory related content soon. This is a good idea for that. Thank you. I'm sorry we don't have more to help you right now.
I don't understand the percentages... Do they always stay at 30%? I am concerned because this affects they whole formula. Is there a better explanation?
This is merely a template. You'll have to decide what percentages work best for your business. This is just what we're using for our business. You can change the formulas for the cells if you need to.
![How to keep Inventory using an Excel Spreadsheet - [create your own Template]](http://i.ytimg.com/vi/msQoTuCsKJ4/mqdefault.jpg)
Really easy and effective! It saved my day, thanks for that
We are so glad it was helpful!
Awesome!!! Thankyou for this
You are so welcome! We're glad to help. :)
Nice stuff!
Thanks!
Hi thanks that was awesome. I need to forecast by part number because my SKUs are kits. Do you have a template or advice for that situation? Each SKU has 3-8 components. Thanks!
We don't have content with specific advice for complicated situations like this, but we may be able to help you set up a tool to track all of this. ledgergurus.com/ecommerce-accounting-services/inventory-management-for-ecommerce/?RUclips&
Hi! do you have tutorial for inventory analysis. thank you
Can you be more specific about what you're looking for?
@@LedgerGurus I'm creating a report regarding a food chain supply for the forecasting
@@mei-meiyu8849 We don't have anything like that yet, but that will probably change in the next few months. We've just brought on several new members of our inventory team, and we will cranking out inventory related content soon. This is a good idea for that. Thank you. I'm sorry we don't have more to help you right now.
I don't understand the percentages... Do they always stay at 30%? I am concerned because this affects they whole formula. Is there a better explanation?
This is merely a template. You'll have to decide what percentages work best for your business. This is just what we're using for our business. You can change the formulas for the cells if you need to.