Optimize your leads management for inventory with airSlate SignNow

How to create outlook signature

hi this is Alex and I am going to walk you through how to um update the spreadsheet right here uh the spreadsheet is for inventory and it calculates um basically your reorder point for any inventory that you need or any um raw materials things like that so you want to start over at the helper tab over here is where you enter in your skew and then your skew number and then whatever the description is over here um don't touch those so we're going to enterance CU 1 2 3 4 5 just to be you know crazy like that and we're just going to call it a widget next you're going to go to your purchase history select from the dropdown on all of these tabs you have instructions um but I'm just going to do a walkr to you as well for you as well um you can see that automatically populated your vendor and your PO these two are completely optional fill them in if you want don't if you don't we're going to say this is from Z YX Co and our purchase order date and I'm going to make one for 51524 and I can even type this in if I don't want to select from the dropdown so I can go one or I can just go over here I'm just going to leave those two blank it's not OP it's optional like I said and I don't need them for any reason order placed and we're going to say this one came on 51 15 not 15 there we go so you can see here I have four different dates this one was the shortest coming in 12 days this one um came in 59 days if you go back over here your average lead time based on those four um purchases is 35 days and your maximum lead time is 59 days which is what we just talked about we're going to go over here to forecast sales select it from your dropdown automatically populates this is where you um enter in the date that you want your 12 months to start with I wanted it to be 25 i' enter in that if I want it to be four um see it automatically updates and then in here you go and you enter in your sales by month um this will automatically populate in a bit we just haven't filled in everything yet um historical sales works the exact same way forecast sales is looking forward historical sales is looking back you can see this goes through March goes through May once again this will get filled out just not there yet this is where the fun happens let's go ahead and select our skew anything in green you can probably tell that throughout the spreadsheet um you're going to want to fill in if it's white leave it alone so right here quantity how many do you have on hand I'm going to say I have 125 do I have any committed do I have any already sold 15 on order I have 25 that I've already ordered you can see now that we've filled out that these cells have gone ahead and populated here is where you decide if you want to reorder based on historical or forecast you know if you have pretty um if your sales are basically the same year over year month over month it's pretty easy to order based on historical but if you have any significant growth um or any significant decline um you might want to use forecast this is telling me right now I actually don't need to reorder based on history or based on forecast let's say I only had 10 on hand now it's automatically telling me I need 72 but if I wanted to do it based on forast it would tell me to order 74 so see you can kind of play around with [Music] that so that's how it works and um kind of walk through the whole thing here you can see if you don't need to order anything it's going to be white but if you do need to order something if it's going to be red just to kind of make sure those pop out for you um comment if you have questions thank you