Pricing Analytics PPT: Find the optimal price of your product

Estimating Demand Curves Without Price Elasticity to determine the optimal price that maximizes your profit margin.

demand curvedownloadexcelmaximizing priceoptimal pricepptprice elasticitypricingpricing analyticssolver

The most common way of constructing demand curves depends on the product’s price elasticity. But what if that input is not available, or the figures cannot be obtained for a given product?

Another way to do this is by making reasonable estimates of the demand for a product at its high, median and low price points, which then allows you to construct an estimate of the demand curve over the range of those given prices.

The following downloadable presentation shows how you can use Excel’s line fitting and solver functionality to construct an estimate of the demand curve, without having to know the price elasticity of the product at hand.

This will allow you to determine the optimal price for the product, which will maximize your profit margin.

- Michael Lamont

This business tool includes
1 powerpoint, 1 video

Michael Lamont offers you this business tool for free!

Download for free

Ask a question


  • No review yet!

Any questions on Pricing Analytics PPT: Find The Optimal Price Of Your Product?

The user community and author are here to help. Go ahead!

please wait...