For this you have to create a excel calculator which will give the detailed quantities you need.
Then copy those values excel to production order, this will create 24 pink lemonade and 24 strawberry cordials by reducing inventory of 48 Bottles, 24 Pink Lemonade labels, 24 Strawberry labels, 48 caps, 5kg Xylitol, 30grams Stevia, 3 litres lemon juice, 300 ml strawberry flavour, etc
You will need to create a separate spreadsheet calculator for each product and create separate Production Orders for each product
Currently Manager doesn’t have a Bill of Materials process where a product recipe is stored so currently you need to maintain that in a spreadsheet, however once you have created a production order once, say for 24 Strawberry, then you can click on view and “Clone” it
How do I plug the spreadsheet calculator in and what does this spreadsheet look like - is there a template I can use? Is there someone that can help me with this.
I have to change my software that I use, but don’t want to change unless I am absolutely sure this will work for us
Sorry, I should have been clearer, you don’t actually plug in the spreadsheet calculator but you manually enter the information into the production order from the spreadsheet calculations.