Need to create Formulas for Product Life cycle

[mimz]

I have monthly sales for a product. Based on the month sales data for 5 yrs I need to create 3 formulas that will ascertain

1. When did the prod go from Intro to growth stage

2. When did it enter Maturity

3. When did Decline start


Can anyone please help.

 

[sgmpatnaik]

@mimz


Hi


Welcome to Chandoo.org Forums, Glad you are here


i would like to advise some points about the chandoo.org, before you are going to post please read the 4Green Sticky Key rules and it is better to give the more details with sample file which is better to under stand the Ninja's or Forum readers who will try to solve your problem


upload for a sample workbook link


http://chandoo.org/forums/topic/posting-a-sample-workbook


i think u understand


Thanks


SP

 

[Hui]

Mimz


Firstly, Welcome to the Chandoo.org forums


you may want to consider simpl;y plotting a chart of the sales vs date

That should clearly show you ther various phases.


Beyond a Chart your company must/should have some criteria which define the various stages. Have you asked your supervisors or peers what they do to ascertain these points


Sales are sort of like Distance/speed/Acceleration

You can woork out the change in sales on a month by month basis (Speed)

then the Change in Change in Sales (Acceleration)


You probably want when the Acceleration is 0(Flat), changes to Positive(Growth) changes back to Negative(Decline)


beyond that you may want to consider uploading some data for us to assist you further

 

[mimz]

http://www51.zippyshare.com/v/39381811/file.html


Appreciate if you can help me with the formula for PLC