Have been crunching the numbers for you @toesen. If you say it...

Have been crunching the numbers for you @toesen.
If you say it takes 2 months to bring a subscriber on board, in the last 2 months half costs will be for subscribers counted in the current quarter and half for the next quarter, therefore you can say 1/3 of costs from last quarter can be allocated to the subscriber increase this quarter.
So costs this quarter (calcs done for June quarter) = Costs - 1/3 costs for next quarter (as subscriber growth numbers are increasing this could go more in our favour) + 1/3 costs from last quarter due to ground work from last quarter to bring subscribers on this quarter.
Here are the numbers for 100% costs associated with bringing new customers on board.


If it costs 90% per subscriber to bring them onboard and 10% for the ongoing you can work out the split based on June figures in the attached.

66% of costs per quarter associated with onboarding subscribers (680) and 34% for ongoing subscribers (3,120).
Recalculate and you get the following


here is the excel formula for the $4,686
=(0.66*(D9-((1/3)*D9)+((1/3)*D8))/(C9-C8))+0.34*(D9-((1/3)*D9)+((1/3)*D8))/C9-(C9-C8).

If as some people have suggested there is a more even split between onboarding and ongoing I have adjusted the numbers to 50% (note this is not 50% onboarding to 50% ongoing, it is the split of total costs for the month).


Any mistakes let me know.
All in all it looks very good based on my assumptions.