Calculating Value Based on Multiple Criteria

I have a sheet that contains a master product price list. I'm trying to design another sheet within the same workbook utilizing a formula that will reference data in the price list to calculate per-u...