Get the SCOUTStrong Healthy Unit Tracking Sheet

Hello everyone this is Rick Grantham of small business champion bundle this week we're going to walk through an inventory excel template this template will help you with do anything from figuring out when you need to reorder - how many SKUs you have so that is coming up next hello everyone this is Rick Grantham of small business champion bundle welcome back to the explanation portion of tutorial for inventory lists for the small business now in the inventory template that we're about to show you about in about a minute or so there's a number of things that you need to consider whenever you're figuring out what your inventory solution is going to be first off just a listing of your inventory items quite honestly just isn't good enough you need to be able to factor in things like what your reorder strategy is going to be being able to highlight things that have been discontinued and so being able to bring all that together into one template or into one solution in addition to that in the template that I'm about to show you it also gives you the opportunity to see summary statistics about your inventory summary statistics such as your inventory value the number of SKUs you have what is the average unit price what is the count or the number of discontinued items that you have and the count of the SKUs and things you have in stock so it also highlights for you the items that need to be reordered based on the strategies you put in place so stay tuned for the next Pro tutorial will bring up the template well show you how to input your own business on numbers so that you can use the inventory list immediately that's coming up in the next part of the tutorial hello everyone this is Rick Grantham welcome back to the template portion of the tutorial whenever you first bring up the template the first thing you'll be met with is this title screen on the title screen there are plenty of opportunities over here on the left-hand side to join the conversation you know you can download the free small business ebook Hepp it's free why not question-and-answer period you have any questions on or any concerns or anything to see in the template of course opportunities to join other professionals on LinkedIn and Facebook these are groups are specifically designed for these templates and so feel free to join on there you'll see on the right hand side some other text here to join the conversation let's get past that and get directly to the templates so to get to the template the first thing you do is come down to the bottom and on the bottom you'll see is a tab here for inventory lists as we click on inventory list the inventory lists of the inventory template is brought up for you so regarding the template over on the right-hand side over on the right-hand side you'll see there are opportunities to join the conversation again so other links that are right here on the template you'll also see the instructions but I'm going to walk you through all of the instructions but...