You are here: Manufacturing Control > Formulation (MCS200)

Formulation (MCS200)

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

Buyers Control Center FML, which is used to create formulation tickets using the Build Formulation activity.

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).

FMLTicketReview (MCE245), which is used to display, place or release BOM production tickets from service hold. Documents may be displayed by warehouse,hold status,order type, order status, origin, priority, and cutoff date.

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.