For the eternal question: Do we have it in stock? Your profit and customer goodwill hinge on that question. Proper inventory management and control is important in any business, but in food distribution it is absolutely vital. Accutech's Inventory Management Module was designed to handle weights and broken units as well as provide meaningful and accurate "to the second" information.
· Handles multiple warehouse locations
· Tracking of multiple costs
· Automated lot tracking
· LIFO (last in, first out) reporting
· Weight and broken case quantities handled with the same product number
· Case and weight tracking
· Automatic main / sub allocations for product
· Powerful online inquiries
· Flexible reporting
HANDLES MULTIPLE WAREHOUSE LOCATIONS
The system handles multiple warehouse locations and associated inventories allowing information to be displayed or printed by individual warehouse or all locations combined. With one system you can invoice and ship by warehouse location. If you use 'public' warehousing in various locations you can maintain your inventory balances with their associated lot numbers.
TRACKING OF MULTIPLE COSTS
Last cost, and average cost are maintained by warehouse location and are available for displays and reporting. The purchasing system allows you to establish formulas for which cost elements are to be used for the inventory cost and, also a cost which allows markups for ongoing pricing. When a receipt is processed the last cost is updated and a new weighted average cost is calculated. The pricing system allows you to use a pricing based cost and a market cost. You can maintain costs at either 2, 3 or 4 decimal positions.
WEIGHT AND BROKEN CASE QUANTITIES HANDLED WITH THE SAME PRODUCT NUMBER
Quantities maintained in inventory also keep a broken case quantity within the same product number. All quantities displayed or printed always show whole and broken case. Extended cost values include broken case quantities. All our systems were designed for the food industry with weight, full and broken case capability.
QUANTITY AND WEIGHT TRACKING
FMS tracks both quantity and weight throughout the system for products which are sold by the pound or kilogram. The inventory system retains the actual weight not just the average weight, thus allowing inventory to be tracked and reported and allows displays of weighted products by weight and case quantities.
AUTOMATIC MAIN/SUB ALLOCATIONS
The system allows you to inventory and purchase under a 'main' product number and set up one or more 'sub' products sold by another unit of measure. The 'sub' products will automatically draw inventory from the 'main' using your established conversion factors, for example, if you bring lettuce in by the case of 24's and sell 24's. You also repack to 12's and 6's with different pricing structures. Another example would be for turnips, cabbage, etc. where you bring them in and sell by standard case weights, or for smaller quantities you can set up a sub where it is sold by the pound even though you purchase by the case (e.g. Bananas).
WAREHOUSING PUTAWAY, LETDOWN AND PICKING OPERATIONS
The new warehousing features of inventory control provide full stock locater options and lot control.
The purchasing system will produce a receiving document awaiting the receipt of the products from the supplier. This document shows the normal home slot picking location and overflow zone areas. These can be changed at receipt time after putaway if the home slot or zones were moved. For a simple operation this form is used for putaway and the inventory balance for an item is kept as one total regardless of how many slots it is located in. Picking documents can show the same home slot picking slot with the overflow zones. The pickers if they run out of product can refer to overflow zones on the pick document and ask for the home slot to be replenished.
Additional feature options
· At receiving time you can request pallet labels be printed based on order quantity or actual quantity received. The system will determine the number of labels based on the TI / HI of the pallet.
· For a more sophisticated approach at receiving time you can call the original purchase order up on the screen and you can confirm the quantities received in whole or by item. Based on existing inventory by slot balances maintained you can request a putaway listing and/or pallet labels which can do the following:
· If you have an each pick area the number of cases required can be directed there to top it off.
· The home slot case pick area can be replenished directly. (in both above situations the system will check first if you have any existing stock so FIFO movement is guaranteed).
· The labels and / or listing will direct the putaway operator to zones. Zones are either a "ready reserve" area above or close to the home picking slot or a bulk area again as close to the home picking slot as possible. Zones are defined and attached to ranges of slot locations and items are assigned zones.
· The putaway operators will record the slots where they placed the product and then it is returned to be updated on the computer.
· When quantities are received you have the option to enter the following:
· A best before date and/or a sell before date. The best before date will default to the receipt date if not entered. You might only want to control certain dated products. FIFO movement is based on best before date.
· An internal lot number / license plate number.
· A supplier's or external warehouse lot number.
· The slot location and quantity for each pallet.
· A temporary slot number for later putaway or for dock to dock situations.
LETDOWN / REPLENISHMENT
If you are using the full stock locater system you can choose to use the following:
· Based on quantities ready to be picked you can choose to produce listings or labels to replenish the pick slots before hand. This can be for each pick and / or case pick areas.
· This can be for a whole shift or for selected routes or "waves".
· The setup you have established knows the capacity of the "home" slot whether it be case or each pick. Case and each pick can be combined to the same "home" slot location.
· When you select a replenishment listing an "image" is kept of the suggested movements. Changes can be made to this "image" and after the actual transfer the system can automatically update the from / to slot movement of quantities.
This function maintains a LIFO (last in, first out) cost and yearend reporting of LIFO based on the unit cost from the last fiscal yearend.
POWERFUL ONLINE INQUIRIES
All inventory quantities are up to date the second they are effected. The online inquiries allow immediate access to all inventory information without running a report. Access to all inquiries can be done by product number or by alpha search using any part of the product brand, pack size, or description.
Some of the inquiries include:
· Period to date displays allow you to scan through all transactions relating to the inventory balance of a product in the sequence they happened. The new quantity on hand for each transaction is displayed. Reference to purchase order number and supplier name is given for receipts, and customer number, name and invoice number are shown for all shipments.
· Summary browsing allows you to scan through groups of products by brand, size or parts of a product description showing available quantity on hand.
· Summary screens by product show a complete picture for a product. Quantity on order, allocated, on hand, costs and extended inventory values. Week, period, and year to date quantity summaries of receipts, adjustments, returns and shipments. Past 6 weeks and average movements.
· Last 52 weeks of shipment quantities and weights by product.
Reports are available on demand, daily, weekly and periodically. Some of the reports available are:
· A one line per product "inventory activity" report lists the opening balance along with total receipts, adjustments, returns, requisitions, shipments as well as closing balance and percentage of inventory turns. Selections can be made for weekly, period, and year to date.
· An inventory flow of material tracking report will give an opening balance and all the transactions which effected the quantity on hand. Receipts refer to purchase order numbers, and shipments show the invoice number, customer number and name. Details print in the sequence they occurred with the quantity on hand balance at the time. This audit report will aid in tracking down any inventory discrepancy.
· Inventory transaction reporting by type of transaction showing costs and extended cost values.
· Flexible selection of inventory movement reporting allows analysis of overstocked and understocked products and calculates the number of weeks supply based on past weeks shipment activity.
· Minimum/maximum quantity reporting of those products over or under selected quantities.
· Inventory valuation reporting in summary or detail showing all extended values based on average, last and landed cost.
· Quantity on hand reference listings by product or slot.
· Optional pre picking list of product picking slots which might require replenishment.
· Spoilage reporting of product quantities returned and not replaced into inventory. Totals of week, period and year to date.
· Net inventory reporting takes all orders in the system including advance orders and provides a 14 day spread sheet window of the effect on the inventory balance.
· Volumetric Reporting shows from/to, date selection detail movement by product by high/low activity. Information such as the number of times the product was picked is printed.
· Item Movement Analysis Reporting by product group shows week, period or year-to-date, the weight and cube movement in an out of your warehouse(s).
· Additional inventory listings provide more information for the buyer for selected products they wish to specifically track and report on. You can also for "same" products specify to your salesreps your preferred products to sell in a ranking sequence.
· Additional reports include; Excessive Inventory Report, Inventory Velocity Report, Supplier Short Shipment Report, Potential Inventory Shortage Report, and Inventory 14 Day Movement.
· All reporting is available by all products or selections of various categories of products.
· Single or combined warehouse selections.
· Reporting is produced in sequence by product grouping and categories.
With this system you have the ability to take an 'image' of inventory balances and costs prior to a physical inventory and continue regular processing of orders. Counts can be entered after and variances updated.
Other features are:
· Counts sheets produced by product grouping or by slotting sequence before a count
· Cycle counting set up capability
· Automatic inventory adjustments made anytime
· Noninventory miscellaneous products can be entered and costed
· Missing sheet number report
· Costed inventory variance reporting by group and category
· Proof report by sheet sequence
· Recount reporting selections