Inventory management and ordering can be a minefield. OCC's database for Plus Design has proved that it need not be!

• The software uses an optimization algorithm, together with suppliers' price information, to optimise stock purchases
• The application allows stock requirements to build up in order to support bulk buying
• The ordering process can be initiated at any time. It constructs orders based on the accumulated parts requirements
• The software is Web-enabled, allowing remote stock management
• The system uses MS Access to generate a wide range of reports

The application is estimated to be saving the Plus Design company an average of 20% on all stock purchases carried out.

An example of what is possible for Plus Design using OCC's database is the case where a 40% reduction in unit cost was possible on the purchase of 39 electrical motors by ordering 6 additional motors from one supplier's catalogue. The components' supplier was offering significant discounts on bulk purchase for a limited period only.

The trick was to spot the savings opportunity when it presented itself. The OCC-designed database enabled our client to do so. Maximizing resources is a common theme of OCC's database development work.