I have a file which I have attached and I have been (for a week) trying to see how to calculate (1) price sensitivity and price elasticity when a price is increased by a certain percentage.
What I have historical data (2010 and 2011relating to
1. number fo students in a program per month/quater and year
2. The price per program per month/qauter and year.
I want to increase the school fees by say 4% in 2012. By increasing the price, will it have a positive/negative effect on the number of student that might enrol for 2012 by month/quater/year?
How can I show this using a chart and pv table?
I will really appreciate your assisatnce.
What I have historical data (2010 and 2011relating to
1. number fo students in a program per month/quater and year
2. The price per program per month/qauter and year.
I want to increase the school fees by say 4% in 2012. By increasing the price, will it have a positive/negative effect on the number of student that might enrol for 2012 by month/quater/year?
How can I show this using a chart and pv table?
I will really appreciate your assisatnce.