Sales Growth Ramp Model

Trying to write a sales growth model, where quota is 200 units once fully ramped in month 3. Month 1 and 2 are sold at 50% of quota (eg, 100 units). So, in month 1 sales would be 100, month 2 sales would be 100 plus month 1 of 100, month 3 sales would be 100+100+200, etc...

I have attached table that shows how I am getting to the number, BUT what I'd like to do is avoid having to use the waterfall look in my sheet and rather have the formula working on single row instead. Appreciate any help.

Try this in cell C13 and copy over.

Formula:

Please Login or Register  to view this content.

P/S: Your explanation above does not seem to tie up with the numbers you have written in your spreadsheet. Can you double check that the numbers are indeed what you are looking for?

Appreciate the quick response, totals should look like this below, where if you sell 50% of 200 in Month 1 then you return 100, in Month 2 sold another 50%*200=100, plus you still have the sales of 100 from Month 1. In Month 3, you sell 100%*200=200, so you get 200+100 from M1 +100 from M2, then ongoing months should increase by 200 each time. Is there a way to modify your formula to fit? Thanks again, that was awesome learned something new about columns.

100 200 400 600 800 1000

Ah, I was right to suspect something was amiss. See attached for my solution.
Basically I've added a row of 200s to represent full quota. Using that and your ramp-up percentage, I used a SUMPRODUCT to calculate ongoing sales.

excellent, many thanks down under!!