I pay $X,XXX a year for manufacturing software, and I just had to write software like OP for my own company.
The software I buy can turn product demand into ingredients and orders. But it can’t do it into the future. So I had to write custom software to take a sales forecast, turn it into a production forecast, and then turn this into a purchasing forecast. Seems like something that should be a solved problem, but not really.