I have a facility where I provide football training to kids with a football coach. Since the facility is mine we decided on Profit sharing 70% me 30% for the coach, for each student fees. I collect the fees from students and would pay the coach at the end of each month. The problem is kids enroll in on any date of the month. (For eg. One kid joins on 1st, 2nd kids join in 11th, 3rd kid on 24th and if the fees let's say 100 I can't pay him 30x3=90. Cos not all kids got same days off training, right? So I need an excel sheet which could automatically calculate how much do I need to pay him at the end of each month. Please reddit help me out.
Submitted December 28, 2017 at 12:50PM by mythanol http://ift.tt/2pNkORx