Build To Database
This spreadsheet has been designed to help you keep track of your RU inventory.
Instructions
- Your own Local Chapter Director needs to go through each tab to determine how many of each item he wants to keep in stock. He would enter this number under the "Build To" heading.
- Next your RU Local Chapter Director needs to decide the number that he wants you to reorder at. This info you would enter under "Reorder At."
(e.g. Perhaps he wants you to build your inventory to 15 “It’s Personal” Daily Journals, but never wants you to have any fewer than 5 on hand. In this case, under “Reorder At,” you would enter the number “5.” When you see that the number you have in inventory matches this number, it is time for you to purchase more.)
- When the time comes for the Local Chapter Secretary to take inventory, all they need to do is enter in the quantity that they have of each item under "In Stock."
- As you record how many items you have on hand, you will see the number under the heading "Order" changes automatically. For your own convenience we have input a formula that does the math for you. When the time comes to reorder, all you need to do to determine how many of each item you need is to look at that number under, "Order." It is generated by the spreadsheet, based on the data your director entered under "Reorder At," and the data that you input under, In Stock."
PLEASE NOTE: Directors, you do not need to keep in stock each and every item found under each tab; they are merely recommended. We leave it up to you to decide what it is that your own local chapter is in need of. Call our office with any questions: 815-986-0460