diarrheaplanet
New Member
- Joined
- Jun 26, 2016
- Messages
- 15
Hi guys!
I'm trying to create a forecast of recurrent purchases from clients.
I want my input to be that the clients at end of month repurchase x months afterwards, and be able to drag this into the future in my model
So, if we have:
Repurchase input: Every 2 months
January February
2 purchases 4 purchases
My model looks like:
January February March April
2 purchases. 4 purchases 2 purchases (this are the january guys repurchasing). 4 purchases (these are the february guys repurchasing)
NOTE: For easyness, I'm doing this in two lines, so there is one line that is new purchases (which has its own formulas to determine that), and then a line that is purchases from recurrent customers (which is what I'm trying to figure out now), so I can more easily separate the formulas in
Appreciate any help!
I'm trying to create a forecast of recurrent purchases from clients.
I want my input to be that the clients at end of month repurchase x months afterwards, and be able to drag this into the future in my model
So, if we have:
Repurchase input: Every 2 months
January February
2 purchases 4 purchases
My model looks like:
January February March April
2 purchases. 4 purchases 2 purchases (this are the january guys repurchasing). 4 purchases (these are the february guys repurchasing)
NOTE: For easyness, I'm doing this in two lines, so there is one line that is new purchases (which has its own formulas to determine that), and then a line that is purchases from recurrent customers (which is what I'm trying to figure out now), so I can more easily separate the formulas in
Appreciate any help!