IF formula impacted by previously entered data

Maybe try this formula in AK10:

=MIN(D10,MAX($AJ$3-SUM($C10:C10),0))*U10*$AK$3+
MAX(MIN(D10,MAX(SUM($C10:D10)-$AJ$3,0),$AJ$4-$AJ$3,$AJ$4-SUM($C10:C10)),0)*U10*$AK$4+
MAX(MIN(D10,SUM($C10:D10)-$AJ$4),0)*U10*$AK$5

=MIN(D10,MAX($AJ$3-SUM($C10:C10),0))*U10*$AK$3+
  MAX(MIN(D10,MAX(SUM($C10:D10)-$AJ$3,0),$AJ$4-$AJ$3,$AJ$4-SUM($C10:C10)),0)*U10*$AK$4+
  MAX(MIN(D10,SUM($C10:D10)-$AJ$4),0)*U10*$AK$5

And then drag across.