Most techniques used to created demand curves depend on the product’s price elasticity. But what if you don’t have or can’t obtain the price elasticity figures for a particular product? If you can make reasonable estimates of demand for a product at a high, median, and low price point, then you can still construct a reasonable estimate of the demand curve over the range of those prices. This presentation shows how to use Excel’s line fitting and Solver functionality to construct a demand curve without knowing the product’s price elasticity, and determine the optimal price for the product that maximizes profit margin.