That's a tall project for starting with Power BI. In addition to that you need to know that Power BI has no memory. It cannot do any manipulations on existing datasets. It always reloads everything. That means you need to do the logging and history keeping outside of Power BI.
In addition, some of your tables are in a format that Power BI does not like (especially Consumption breakout). You would have to unpivot them and bring them into usable shape before attempting any logic implementation. However they don't seem to be required so I didn't load them.
Here's the data model I would propose:
Did you know you have quite a few "Next Delivery Date" values in the past?
Anyway - next you would do the material planning to see how far you can stretch the parts. Are you assuming that item 1 has higher priority than item 2 etc ? If not then you would need to specify the priority somewhere.
Frankly speaking - Power BI is a reporting tool. It is not the right tool for material allocation, production planning and inventory management. That's what ERP systems are for.