Fill in D2 and copy down


=IF(AND(B2<7,OR(B2="M",B2="E",B2="C")),A2*14,0) + IF(AND(B2>7,OR(B2="M",B2="E",B2="C")),A2*10,0)+ IF(AND(A2>30,B2<>""),A2*10,0)