Need help on this Formula

I been using PowerBI for awhile and I got stuck on this logic.

So basically i have two tables.

Table 1

Table 2

The goal is to sum Table 2 - which is 674 (sum of qty)

Then distribute those to Table 1 base on requirements from top to bottom.

so you see that item A got 200, Item B got 150 and so on, but on Item D it should only use 174 because the total QTY of table two is 674.

here's the desired outcome. the sum from answer column is 674 which should match the table 2 sum.