Waterloo Information Systems Limited

33 Dupont Street East

Waterloo, Ontario

N2J 2G8

Waterloo Information Systems Limited 1999

The information contained herein is proprietary and considered a trade secret of Waterloo Information Systems Limited and shall not be reproduced in whole or in part without the written authorization of Waterloo Information Systems Limited.

I. Introduction

Central to WISL Process Analysis is the maintenance capability for product formulations and donage requirements for the development of a bill of materials for production batches. A calculation process is performed on batch production transactions that are received from the foreman certification module of wisl Process Management which generates transactions that reduce the raw materials inventory. Facilities are also included to maintain inventory from raw materials purchasing, receiving and manual adjustments. These latter facilities are based on RF technology. RF based facilities are also included to provide for financial and cycle inventory counts. Interfaces are supported to the corporate financial and preventive maintenance systems.

A maintenance routines designed to run on a traditional workstation provide for creation and maintenance of the following records :

1. Raw Materials

2. Donage

3. Raw Materials/Finished Product Formulations

4. Donage/Finished Product Profile

1. A maintenance routine designed to run on a traditional workstation provides for maintenance of the inventory to accommodate miscellaneous adjustments to inventory. The maintenance of this data base satisfies the requirements to maintain a perpetual inventory. This facility also provides for the maintenance of inventory committment by raw material sku.

2. RF based facilities provide for maintenance of inventory upon receipt of raw materials and donage.

3. An automatic procedure is invoked to use the raw material formulations and donage profiles to determine the reduction in inventory upon receipt of each production batch transaction from the foreman certification module of WISL Process Management.

4. The raw material and donage file maintenance facilities provide for the update of certain attributes that relate specifically to inventory control and analysis.

5. A routine to maintain the warehouse location grid allows for ongoing adjustments in storage planning.

The warehouse ID is prompted. The current audit ID is prompted. A control routine provides for the storage of inventory counts on the perpetual inventory file as of the date of the count to be used in comparison with those taken in the audit. Such a count may be stored for each calendar day to facilitate the calculation of warehouse capacity/utilization statistics.

1. The grid section of the warehouse is prompted.

2. The product ID is scanned from the shipping unit container or the item.

3. The number of units is prompted.

4. The process is continued until "x" or "\4" is entered to return to the previous step.

5. The letter "D" entered at the product prompt initiates a display of all scans since the last change in the location. Striking the enter key advances the list. The list may be terminated by entering "x" 0r "\4".

The warehouse ID is prompted. The current audit ID is prompted. A control routine provides for the storage of inventory counts on the perpetual inventory file as of the date of the count to be used in comparison with those taken in the audit. Such a count may be stored for each calendar day to facilitate the calculation of warehouse capacity/utilization statistics.

1. The grid section of the warehouse is prompted.

2. The product ID is scanned from the shipping unit container or the item.

3. The process is continued until "x" or "\4" is entered to return to the previous step.

4. The letter "D" entered at the product prompt initiates a display of all scans since the last change in the location. Striking the enter key advances the list. The list may be terminated by entering "x" 0r "\4".

1. The grid section of the warehouse is prompted.

2. The product ID is scanned from the shipping unit container or the item.

3. The inventory count is displayed and may be overridden or accepted with a null return.

1. Inventory status queries provided within warehouse by product or grid section from the perpetual inventory data base.

2. A summarized audit trail is available providing total activity upon any change in date, clerk, sku or transaction type(receipt, production batch update or adjustment).

1. Inventory Audit Control Reports

2. Stock Level Reports

3. Inventory Movement Analysis

4. Warehouse Grid Section Labels

1. A transactional interface is available to provide production activity information to the corporate preventive maintenance system.

2. A transactional interface is available to provide inventory updates to the corporate financial information system. Included in this interface is batch control and inquiry of transferred batches and transactions.