Manufacturing Capacity Planner

Hi,

We have an ERP system however, the resource planning module in this is very basic and not suiting to our needs, this would meet our requirments until perhaps a more sophisticated ERP system one day. I have been sucessfull in Power Query to allocate capacity, looking out 10 days forward. To do so, in a nutshell, I sum grouped the total hours by date in  "Assembly_102 Capacity Req", then merged it into "Assembly_102 Calculations" by date, there after the applied step " Merge Assembly_102 Capacity Required" (see below snip), I simply minused the required hours column from the available hours column, then used a comination fo an index column to offsetthe results (balance of hours) column. Then repeated this 9 more times. This gave me a 10 day period to allocate ordes against available capacity. 

However I`ve been unsucessfull at establishing the order (Product ID) completion date. I have not been successfull at making the connection between the Product ID`s specific hours required and the Prodct ID itself in this process. Whats happening is, the Prodcut ID is seperated before the merge, due to 2 or more orders on the same start date which lead me to group as outlined above.