Inventory Control Records

Inventory Control Records

Inventory control records are essential to making buy-and- sell decisions. Some companies control their stock by taking physical inventories at regular intervals, monthly or quarterly. Others use a dollar inventory record that gives a rough idea of what the inventory may be from day to day in terms of dollars. If your stock is made up of thousands of items, as it is for a convenience type store, dollar control may be more practical than physical control. However, even with this method, an inventory count must be taken periodically to verify the levels of inventory by item.

Perpetual inventory control records are most practical for big- ticket items. With such items it is quite suitable to hand count the starting inventory, maintain a card for each item or group of items, and reduce the item count each time a unit is sold or transferred out of inventory. Periodic physical counts are taken to verify the accuracy of the inventory card.

Out-of-stock sheets, sometimes called want sheets, notify the buyer that it is time to reorder an item. Experience with the rate of turnover of an item will help indicate the level of inventory at which the unit should be reordered to make sure that the new merchandise arrives before the stock is totally exhausted.

Open- to-buy records help to prevent ordering more than is needed to meet demand or to stay within a budget. These records adjust your order rate to the sales rate. They provide a running account of the dollar amount that may be bought without departing significantly from the pre- established inventory levels. An open-to-buy record is related to the inventory budget. It is the difference between what has been budgeted and what has been spent. Each time a sale is made, open-to-buy is increased (inventory is reduced). Each time merchandise is purchased; open-to-buy is reduced (inventory is increased). The net effect is to help maintain a balance among product lies within the business, and to keep the business from getting overloaded in one particular area.

Purchase order files keep track of what has been ordered and the status or expected receipt date of materials. It is convenient to maintain these files by using a copy of each purchase order that is written. Notations can be added or merchandise needs updated directly on the copy of the purchase order with respect to changes in price or delivery dates.

Supplier files are valuable references on suppliers and can be very helpful in negotiating price, delivery and terms. Extra copies of purchase orders can be used to create these files, organized alphabetically by supplier, and can provide a fast way to determine how much business is done with each vendor. Purchase order copies also serve to document ordering habits and procedures and so may be used to help reveal and/or resolve future potential problems.

Returned goods files provide a continuous record of merchandise that has been returned to suppliers. They should indicate amounts, dates and reasons for the returns. This information is useful in controlling debits, credits and quality Issues.

Price books, maintained in alphabetical order according to supplier, provide a record of purchase prices, selling prices, markdowns, and markups. It is important to keep this record completely up to date in order to be able to access the latest price and profit information on materials purchased for resale.

Inventory Control Systems

The Eyeball System

This is the standard inventory control system for the vast majority of small retail and many small manufacturing operations and is very simple in application. The key manager stands in the middle of the store or manufacturing area and looks around. If he or she happens to notice that some items are out of stock, they are reordered. In retailing, the difficulty with the eyeball system is that a particularly good item may be out of stock for sometime before anyone notices. Throughout the time it is out of stock, sales are being lost on it. Similarly, in a small manufacturing operation, low stocks of some particularly critical item may not be noticed until there are none left. Then production suffers until the supply of that part can be replenished. Such unsystematic but simple retailers and manufacturers to their inherent disadvantage.

Reserve Stock (or Brown Bag) System

This approach is much more systematic than the eyeball system. It involves keeping a reserve stock of items aside, often literally in a brown bag placed at the rear of the stock bin or storage area. When the last unit of open inventory is used, the brown bag of reserve stock is opened and the new supplies it contains are placed in the bin as open stock. At this time, a reorder is immediately placed. If the reserve stock quantity has been calculated properly, the new shipment should arrive just as the last of the reserve stock is being used.

In order to calculate the proper reserve stock quantity, it is necessary to know the rate of product usage and the order cycle delivery time. Thus, if the rate of product units sold is 100 units per week and the order cycle delivery time is two weeks, the appropriate reserve stock would consist of 200 units (I00u x 2w). This is fine as long as the two-week cycle holds. If the order cycle is extended, the reserve stock quantities must be increased. When the new order arrives, the reserve stock amount is packaged again and placed at the rear of the storage area.

This is a very simple system to operate and one that is highly effective for virtually any type of organization. The variations on the reserve stock system merely involve the management of the reserve stock itself. Larger items may remain in inventory but be cordoned off in some way to indicate that it is the reserve stock and should trigger a reorder.

 

Perpetual Inventory Systems

Various types of perpetual inventory systems include manual, card-oriented, and computer- operated systems. In computer- operated systems, a programmed instruction referred to commonly as a trigger, automatically transmits an order to the appropriate vendor once supplies fall below a prescribed level. The purpose of each of the three types of perpetual inventory approaches is to tally either the unit use or the dollar use (or both) of different items and product lines. This information will serve to help avoid stock- outs and to maintain a constant evaluation of the sales of different product lines to see where the emphasis should be placed for both selling and buying.