in H12 you can put
=SUM(VLOOKUP(C$15,$B$6:$C$7,2)*C12,VLOOKUP(D$15,$B$6:$C$7,2)*D12,VLOOKUP(E$15,$B$6:$C$7,2)*E12)
you can then drag that formula down

there is probably a way to do this as an array formula but I'm not sure how....