Closed Thread
Results 1 to 2 of 2

Price Sensitivity calculation

  1. #1
    Registered User
    Join Date
    02-23-2012
    Location
    Amsterdam
    MS-Off Ver
    Excel 2003
    Posts
    3

    Price Sensitivity calculation

    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.

    Desperate kay

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Price Sensitivity calculation

    Closing thread at request OP

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1