Required Build Qty vs. Actual Build Qty - multiple tables

[new_2_prog]

I started this thread here because this is the end product I need, this may need to be in queries and/or tables forum as well but I will start here.

I have data from multiple tables that with 1 query gives me:
Dept,ShiftDate,Shift,Machine,Process,Family,Ratio,GoodPcs,Scrap,Reject,Capacity

Then I have a table tbl_BuildPlan that contains:
ID,BuildDate,Family,Ratio,BuildQty

I need to marry these to each other. Problems:
1) Query doesn't always contain all Family/Ratio that needs to be run, Build Plan does though.
2a) Need to group by Process in query first then compare what we built vs req build.
2b) Not only do we not always run Family/Ratio but parts are not always ran in each Process like they should.

I have attached an Excel spreadsheet that contains query data and table data, I have 2 additional tabs,"WouldLike" and "CanUse".

If I should store the data in the tables in a different way to help I am open to that, if I should write my queries different open to that too, just need some help and direction, have lost 2 days messing with this.

Or if I need to export to Excel in a template I have done that before but not so complicated.

Thanks!!