Using FORMULATOR for Cosmetics & Drug Manufacturing Operations

 

 

Using standard Accounting software you continue doing Purchasing, Invoicing and Accounting in your accounting software.

 

When you order raw materials and container components you receive them into FORMULATOR's Inventory Manager module (we selectively handle lot tracking), use the PO number as a reference and print out the receiving record to enter into your Accounting Software for payment purposes.  Cost of the product is by lot if lot tracking or FIFO if not, based on the current raw material cost.

 

You can do all batch tickets, inventory control, cost analysis, physical inventory and packaging fill tickets in FORMULATOR.  This will create bulk formulas, allow sales of bulk materials, create fill tickets for packaging and output multiple SKU records in the FORMULATOR inventory.  FORMULATOR complies with the FDA CFR11 requirements, all data is logged.

 

When you sell or sample a product you invoice the customer in your Accounting Software and relieve inventory of bulk or packaged product in FORMULATOR using the Shipping Transaction Editor tools.   Integration with order processing is possible with some accounting software.  Cost of Goods Sold is based on lot cost or FIFO.  Integration with package line discreet manufacturing software can be accomplished passing FORMULATOR bulk materials in one predefined unit of measure to the inventory records of the other.

 

The FORMULATOR Inventory Manager provides user selectable lot tracking and an audit trail to which lots were used in which batches of product produced. This identifies which lots of a given raw material went into which batch of product. Physical Inventory count support is provided. To assure an audit trail identifying which customers received a given batch of raw materials, the Shipping Invoice number can be entered as a reference by the user when relieving inventory in FORMULATOR. This reference then becomes a searchable identity for future reference.

 

The capability to do Cost Analysis and Pricing including raw materials (with losses), packaging, labor and overhead is provided in the basic FORMULATOR module.  The Cosmetic and Drug Version of FORMULATOR also aids in creating product labels using the INCI names or defined names, as part of the Lab-book Basic program.

 

The FORMULATOR Quality & Production Manager tools are needed for Inventory Manager.  It provides specifications by raw material or product specifications to meet specific customer requirements and provides multiple batch sheet functions, logging multiple test results at critical control points and will output a Certificate of Analysis sheet when desired.

 

Thus, with a standard accounting package and FORMULATOR with Quality & Production Manager and Inventory Manager modules, the small Cosmetics & Drug operation has all of the software to control formulas, develop product labeling, assure production control, and do inventory control.  All at a reasonable cost with software that can be implemented with a minimum of support and training.