Formula Management and Recipe Control

Start des Workflows/Prozesses.

Fetch all active recipes from the Recipe Data Model to check for existing formulations.

Fetch current stock levels and specifications from the Ingredient Data Model.

Calculate the total cost of the formula by multiplying ingredient quantities by their unit prices.

Calculate the multiplier needed to scale the base formula to a target production volume.

Update the 'Reserved Quantity' field in the Ingredient Data Model to account for the new formula requirement.

Create a task for the Quality Control specialist to perform chemical stability testing on the new formula.

Create a task for the regulatory compliance officer to review the calculated nutritional values.

Generate a new record in the Formula Data Model with the finalized composition and version number.

Sum the weights of all ingredients in the current formula to ensure the total mass is correct.

Count the number of unique allergen-tagged ingredients present in the recipe.

Change the status of the Recipe entry from 'Draft' to 'Under Review'.

Send an email to the Production Manager stating that a new recipe is ready for pilot testing.

Create a detailed report comparing the cost of the new formula against the previous version's cost.

Delete the temporary draft entry from the formulation workspace after the final version is saved.

Send an SMS to the Warehouse Lead if the formula requires an immediate restock of critical ingredients.

Ende des Arbeitsablaufs/Prozesses.