Managing inventory for manufacturing and WIP goods

Hello,

I am using Monday as a manufacturing company. We take raw materials (parts) and turn them into finished goods (products, sometimes we have subassemblies along the way that can also be produced (WIP goods). I am trying to build a system in Monday where when I enter and item (in another board) to indicate that a certain product as complete, it automatically adjusts the inventory for the quantities I specify, so that we can accurately keep track of parts being depleted in our production.

Is there a way to do this? I do not want to make a separate automation for each part, I’d rather be able to tell Monday to just subtract a quantity from the stock of each part whenever a new product is made. Does anyone have any experience or advice for this use case?

I understand there are MRP softwares that could be used, but with all the functionality Monday brags about, I would honestly like to keep a lot of our business processes on there and have one subscription. Thanks!