Need to deduct raw material quantity once the sale is happened for finished good.
Example a cake of 1 kg will have different ingredients like sugar 20gm, baking powder 20gm, etc. So if I sell 1 kg cake automatically the ingredient should be deducted from stock.
So if I have sugar say 100gm in stock it should be no 0.8 gm after sale of 1 kg cake. Please help with the formula in excel
Example a cake of 1 kg will have different ingredients like sugar 20gm, baking powder 20gm, etc. So if I sell 1 kg cake automatically the ingredient should be deducted from stock.
So if I have sugar say 100gm in stock it should be no 0.8 gm after sale of 1 kg cake. Please help with the formula in excel