The programs on this menu allow you to produce formulas and finished items using the formulas. Formulas are not inventory items, however, a formula is made up of ingredients which are items maintained in a warehouse. A finished item is an item produced which consists of (part of) a formula and packaging items. Packaging items are maintained in the same warehouse.
Following is an example of how formulation might be used:
Formula: F300 Cough Syrup
Standard Production Amount 800 ounces
Ingredients: hydrobromide 400 ounces
glycerin 300 ounces
camphon 75 ounces
sugar 25 ounces
Finished Item: 1 case cough syrup
Uses: 800 ounces of formula (#300)
Packaging items: 100 8-ounce bottles
100 bottle caps
100 labels
1 crate
In the example, the finished item is a case of cough syrup which consists of 100 8-ounce bottles of cough syrup. Packaging items are used to produce the finished item along with the formula of 800 ounces of cough syrup. The formula is produced using the ingredients.
When a one case cough syrup item is produced, its on hand quantity is increased by one. The ingredients: hydrobromide on hand quantity is decreased by 400, glycerin on hand quantity is decreased by 300, camphon on hand quantity is decreased by 75 and sugar on hand quantity is decreased by 25.
The packaging items: 8-ounce bottle on hand quantity is decreased by 100, bottle cap on hand quantity is decreased by 100, label on hand quantity is decreased by 100 and crate on hand quantity is decreased by 1.
These programs are on the Formulation menu.
Formula Entry (MCE210), which is used to enter the ingredient items and number of units used to produce a formula.
Finished Item Entry (MCE220), which is used to enter the packaging items and number of units used to produce a finished item.
Production Planning (MCE230), which is used to enter production planned for the current or any future date. Production Planning does not update any warehouse/item information
Production Entry (MCE240), which is used when a finished item is to be produced, it is entered on a formula production ticket through this program. Only one formula (with multiple finished items as needed) is entered per production ticket
Production Ticket Print (MCP210), which is used to print production tickets to indicate how to create the formula and in what quantities. Two production tickets are then printed: 1) indicating to the warehouse staff how much of a formula to produce and the ingredients and number of each used to produce the formula; and 2) indicating to the warehouse staff how much of the finished item(s) to produce and the packaging items and number of each used to produce the finished item(s).
Production Confirmation (MCE250), which is used when formula production is complete.
Production Register (MCR210), which is used to provide an audit trail of production and to update all appropriate inventory and manufacturing files.