Excel Spreadsheet Ratio Calculator

Hi,

I run a soap business and we require a ratio calculator creating in Microsoft Excel.

When we make bath bombs, we have a recipe that when mixed together comes to a total of 611 grams.

Bicarbonate Soda 420g
Citric Acid 160g
Corn Starch 5g
Kaolin Clay 10g
Carrier Oil 10g
FO/EO 3g
Witch Hazel 3g

However, due to the mould we use, each one of our bath bombs weighs 170g. This means the mix we use produces a total of 3 bath bombs and at the end, we have to throw away 101g of bath bomb mix.

I need an excel calculator where I can type in the number of bath bombs required ie 5, and the recipe adjusts to create the right amount of ingredients without any waste.

For your reference, I have attached the ratiocalculator.xlsx file outlining the weights.

Any help appreciated.

Matt.