Vlookup & addition

Thanks,

I have attached the spreadsheet. You will find the data I'm working with in the purple color cells. There are a bank of ranges to the right. I am working in column L. The ranges are a bill of materials for different given ways to manufacture our equipment. I want to be able to do a mock build of equipment and find the amount of parts needed to achieve this build. You will find the ranges each have their own calculations. Thanks for the help.