This template can help you estimate how the customer demand may change for product/s that you have test-marketed at various prices.

You may change the variables in the demand function on the basis of the data you have collected/or you are aware of. The series of data will be automatically generated by the demand function.

The data then feeds into the chart and all other calculations price elasticity slope of quantity ratio of price to quantity etc are done automatically.

This unprotected excel template works with all excel versions from excel 2000 onwards however the design of the template is best suited for excel 2007.

Click the button below to download Price Elasticity of Demand Calculator...