Identify whether the running total reached to target amount

Seeking help to create formula for the below

I have 3 columns

1 Category
2 Date
3 Amount

Column "Remarks" is my expected results

If Category number total in amount column reaches target amount (Rs.50) from that date to upcoming all dates are marked as " Applicable"
for Remaining days which is not reached to the target amount marked as not applicable.

Example for 10192 total reaches Rs.50 on 2nd Jan'21, hence its marked from 2nd jan to remaining days as "Applicable"


Category Date Amount Remarks

10192 1-Jan-01 10 Not applicable
10192 2-Jan-01 12 Applicable
10192 1-Jan-01 29 Not applicable
11080 3-Jan-01 5 Not applicable
11080 4-Jan-01 7 Not applicable
11080 5-Jan-01 9 Not applicable
10192 5-Jan-01 12 Applicable
11080 6-Jan-01 22 Not applicable
12120 6-Jan-01 31 Not applicable
11080 7-Jan-01 42 Applicable
10192 8-Jan-01 63 Applicable
12120 8-Jan-01 42 Applicable
12120 7-Jan-01 13 Applicable
11080 1-Jun-01 15 Applicable


attached sample file.

Formula for cell F6=IF(SUMIFS($E$6:$E$19,$C$6:$C$19,C6,$D$6:$D$19,"<="&D6)>=$G$2,"Applicable","Not Applicable")

thank you so much. this is working as expected