We have many different products that use many of the same materials. The goal is to have a sheet that we could input our base materials and have the sheet calculate out of those materials how many of each final product could be built. Showing us what product would be most productive to build with the current materials on hand. (For instance Tables, and Chairs use the same type of legs but only chairs use arm rests)

Cell A2 is a final finished product quantity of 2 (can only construct 2 at a time)

To construct the product in A2 the required materials are 100 parts located in E2, 100 Parts listed in H2, and 80 parts located in K2.

A different Product in A3 may use one of the products that A2 uses along with products listed in F2, G2 etc....

Any help with this one would be fantastic. I have been beating my head on the desk trying to figure this one out.

Thank you!