MENU OPTION: Files/Formulation/Code

Shows formulation on file in order of formulation code.

MENU OPTION: Files/Formulation/Name

Shows formulation on file in order of formulation name

If you have any formulations stored you will be presented with the following screen:



This screen shows a list of formulations on the database.



INSERT: Add a new formulation

CHANGE: Change a formulation

DELETE: Delete a formulation

PRINT: Print a formulation

CLOSE: Leave screen


If you are entering your first formulation the program will jump straight to the formulation entry screen:



Insert (Or press <insert> key): Add a newline to the formulation

Delete (Or press <delete> key): Delete a line from the formulation

Copy (or press F6 key): Copy the entire formulation to a new code

Save: Save the formulation

Cancel: Exit without saving changes

Up/Down Movement Arrows: moves the highlighted raw material or manufacturing instruction up or down within the formulation.


Instructions: Add manufacturing instructions to formulation.

Quality Control: Opens window to add quality control tests to the formulation.

Finished Goods: Opens the window to enter finished goods bill of packaging for any number of finished goods items based on the formulation.

Overheads: Opens a window to allow addition of costing overheads to the formulation.


Scale: Allows re-scaling of the formulation to an input mass or volume.

Intermediate Allocation: Allows formulation to be allocated as an intermediate. This copies the formulation code, technical data etc. to the raw material master file, allowing the formulation to be used within another formulation. Once a formulation has been allocated as an intermediate the cost of the intermediate will automatically be updated within all formulations containing it. This cost update is recursive and is unaffected by the number of levels deep within the formulation that the intermediate is stored

Notes: Allows a note to be stored either generally or for the formulation



The formulation header:

The formulation code, name, colour and date of creation are entered here. The code must be unique.

The formulation items:

Press <insert> to add a new raw material

Formulation items are either raw materials with corresponding masses/volumes or inline manufacturing instructions.

Masses and volumes are dynamically interconverted depending on whichever is entered.


A raw material entry requires a raw material code and the corresponding mass.

If the raw material code is known type it in directly. The raw material name will be displayed.

If the code is not know then press enter. A window will open allowing selection of the raw material by name, code or type.


A manufacturing instruction has a code prefixed by the asterisk character. If you know the code you can type it directly. However it is easier to click on 'Instructions' from the pulldown menu and select the instruction text from the instruction list. The mass field has no significance for instruction entry.

When editing the formulation it is possible to move the line up and down by clicking the small arrow keys at the bottom of the screen.


Costing mass loss% and Production loss%

The final cost of the formulation is calculated by dividing the total extended cost of all the raw materials in the formulation by the total formulation yield.

Entering a costing mass loss reduces the expected formulation yield by the entered percentage. For instance if the total mass of the formulation is 100 kilograms and you enter a mass loss of 5% the formulation will be costed as if the total mass of the formulation was only 95 kilos.

The production loss is used to increase the required yield of the formulation when you are scheduling production.

For instance if you typically loose 5% of your original expected yield by evaporation,for instance,in a certain formulation, you could enter a production mass loss of 5%. Whenever you schedule production for this formulation your scheduled yield will be increased by this percentage.

If you schedule 100 kilos in the production module this will automatically be increased yield to 105 kilos. The production loss % was has no effect on theoretical costing it is only used to increase the batch size in production scheduling.


Theoretical and costing SG..

The theoretical SG of the total formulation is calculated from the entered SG of the individual raw materials in the formulation.



If you wish to make changes to a formulation to be used in the future in production

You can do this by clicking the Block Prod(uction) button after making the change to the formulation.


The formulation can now be saved but will not be available in the production module.


Later when you're ready to release the formulation to production, simply click the Rel(ease) for production button