Openning&Closing Inventory and Shortage Qty Calculation

Hello,

I'm new to Power BI, and I'd like to consult a problem I haven't been able to solve.

As you can see in the image below, I have columns for each month, such as demand, production, transfer, and starting inventory.

I want to calculate opening inventory and closing inventory for each month. However, it's crucial that my inventory never goes negative at the closing. In cases where it goes negative, I also want it to be recorded as 'out of stock.' I've tried various approaches and looked at all the suggested solutions, but I couldn't find a suitable solution. Can you help?