FORMULATOR Inventory Manager 

The Inventory Manager module is designed to aid the Laboratory, Pilot Plant  or Production batching operation control incoming raw materials and batched products (including intermediates or new product samples). It also provides the tools to control package component inventories associated with Bills of Materials and Batch Filling requirements. The module requires the basic FORMULATOR module.  The Production Manager Module is highly recommended.  The inventory module manages lot tracking and selective lot costing.  Once Inventory Manager module is purchased User Licenses for the basic FORMULATOR system provides users the rights to operate the Inventory Manager module linked to Formula Maintenance, Production and QC modules and is the main link with Accounting software data files.

 

  What is included in Inventory Manager?

  • Inventory levels for raw materials, formulas (bulk & filled) and packaging entered in an associated FORMULATOR database.

  • Optionally process records by raw material lot (entered manually in Quality Manager), formulas by batched product, or by batch ticket lot number, includes lot recording data archive.

  • Inventory count entered manually for raw materials, package components or purchased or transferred products.

  • FORMULATOR batch ticket management console: relieves raw material / intermediates / packaging components, using Quality Manager adjustments or stock batch ticket output. Posts finished formulas and packaged formulas to inventory.

  • Materials inventory is relieved manually, or with optional ODBC transaction interface (INTEGRATOR).

  • Inventory status report on demand, with current value based on FORMULATOR raw material or formula raw material cost (less loss and yield values). Package materials from Bills of Materials costing.

  • Physical inventory count management console: sheet output, control, and count input functions to control inventory actual amounts vs system inventory amount.

invmenu

  Inventory Main Menu


Why Consider
Inventory Manager?

  • Documents and archives inventories, help control stock in the Lab and in the warehouse. 
  • Identifies lots used for test and production batch runs.
  • Provides the data to identify lots uses in samples and batch output.
  • Fully ANSI SQL compatible ODBC data connectivity allows data sharing as you build your inventory database. 
  • Integrates with FORMULATOR Cost Analysis Bills of Materials packaging items.
  • Integrates with Material Planning Production Manager, identifies short materials, identifies batches and packaging tickets effected.
  • Flows inventory from receipt of raw materials to batches to packaging to shipments.
  • Traces lots from receipt of raw materials to all batches where used to all finished goods filled to shipping reference.
  • Identifies location by lot, status, shelf life, cost by lot by all associated transactions.

rminv

Raw Materials Inventory Records


forminv

Bulk Formula Inventory

 

pkginv

Packaging Component Inventory

 

pckinv2

Finished Goods Inventory

 

dataent

Inventory Manager Data Entry

Formulator™, Regulator™, & Integrator™ are registered trademarks of Formulator Software LLC. All other manufacturers’ trademarks acknowledged.
 CAS® is a registered trademark of the American Chemical Society. Copyright © 2011 Formulator Software LLC.  All rights reserved.

28 Center Street · Clinton, NJ 08809 
 (908) 735-2248   · (908) 236-7865 FAX
EMAIL: sales@formulatorus.com

WWW.COLOR-TEC.COM
Color Instruments & Software
Batch Manufacturing Software
Learn About Color