Using FORMULATOR for Food & Beverage Manufacturing Operations

 

Using standard Accounting software you would 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 do all batch tickets, inventory control, quality control, cost analysis, physical inventory and packaging fill tickets in FORMULATOR.  This will create bulk recipes, 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.

 

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 systems.  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 aids in compliance with the Bioterrorism Act requirements and helps in identifying which lots of a given raw material went into which batch of product. To assure an audit trail identifying which customers received a given batch of raw materials, the Shipping Invoice number will have to be entered as a reference by the user when relieving inventory in FORMULATOR. This reference then becomes a searchable identity for future use.

 

The capability to do Cost Analysis and Pricing including raw materials (with losses), packaging, labor and overhead are provided in the basic FORMULATOR software.  The Nutritional Version of FORMULATOR also calculates user selectable Nutritional values, creates the Nutritional Facts sheet and aids in creating product labels, also as part of the basic program.

 

The Quality Manager tools are a necessary part of Inventory Manager. It provides multiple 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 further meeting the Bioterrorism Act requirements.

 

Thus, with a standard accounting package and FORMULATOR with the Quality Manger and Inventory Manager modules the small Food, Confectionery, Nutritional Supplement, Feed or Beverage firm has all of the software to control recipes, do nutritional and product labeling, assure production control, do inventory control, and meet the requirements of the Bioterrorism Act.  All at a reasonable cost with software that can be implemented with a minimum of support and training.