Hi Bills39
Reading your problem I think you are after the constant % increase from Z to X over Y weeks.
If so consider
Solve for
hello. i am not a mathematician. i'm just a guy who's been up for too many hours today...
i want to sell a cumulative total of X widgets over Y number of weeks. i know that my first week’s sales will be Z. i want to increase my sales at the same rate each week from Z in the first week through to the last week (and ending at my cumulative goal of X).
how do I calculate the rate of increase? can i?
p.s., i'm not a salesman either. just could not think of another way to explain what i'm trying to do...
thanks...
i think this equation will help if wanted to know the constant % increase necessary to sell X in the last week... but i am actually looking for the constant % increase in order to end with a cumulative total of X sales (accross all weeks)...