Formulation (MCS200)
Formulation (MCS200)
The programs on this menu allow the user 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.
Use this program to enter the ingredient items and number of units used to produce a formula.
Use this program to enter the packaging items and number of units used to produce a finished item.
Use this program at any time to enter production planned for the current or any future date. Production Planning does not update any warehouse/item information
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)
Use the this program to print production tickets that tell employees how to create the formula and in what quantities. Two production tickets are then printed: 1) telling the warehouse staff how much of a formula to produce and the ingredients and number of each used to produce the formula; and 2) telling 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)
Use this program when formula production is complete.
The Production Register is printed to provide an audit trail of production and to update all appropriate inventory and manufacturing files.