G14 then drag down:

=IF(C14="Standard",$D$3*$F$3,SUMPRODUCT(($B$3:$B$6=C14)*$D$3:$D$6*$F$3:$F$6))+SUM(Addons))/$D$2