We collect administrative fees from our customers based on many complex business rules albeit based on few variables. I have the history of fees colected through time (about 500 records for each customer, for over 10k customers) as well as the the variables used in the calculation, such as his number of customers, total revenue, and date of the payment.
I am attempting to build a model that, for a given payment date and other variables, would estimate the amout to be collected in administrative fees at that point in time.
As payments are space and varies in dates I imagined something more sofisticated than a LM would berequired. I am trying to adapt this script to my data, though would require me to generate one model for each customer and I wouldnt feel confident It can be trained with such little data.
Would you please advise on how to better model the use case? Went with Transformers and Time Embeding experimenting. Please feel free to point out other algorithms that would eventualy do a better job.