Projecting Inventory to Expire based on forecast

Hi everyone!

Posting this question for my inventory tracking project. 

Summary: I would like to build a tracker/dashboard to track my inventory expiration risks based on forecasted usage.

Inputs:

1. I have one table for forecasted usage on a weekly basis for all SKUs. Similar to the table below.

2. On a separate table, I have an inventory balance of all of these SKUs, with different batch codes and different expiration dates similar to the table below. 

That being said, my desired outputs are: 

1. Flag expired items automatically (can be easily done). 

2. Be flagged if there is an expiration risk meaning, total usage over X weeks will not be enough to deplete the remaining inventory by its expiration date. Need to keep in mind that First to Expire, First to consume. I need to deplete first those to expire first before consuming the next batch. 

3. Quantify the risk: How much will not be consumed/will expire based on forecast usage. Keeping in min the First to Expire, First to Consume concept. 

Sample output table:

Hope I made the problem clear. 

I'm really stuck at this project and don't know where to start so I would very much appreciate any help.

Thank you!!!