Pricing Tests and Price Elasticity for one product

ModelSheet: Custom spreadsheets in minutes

Set the price of one product to maximize your profits 

This model brings more certainty to pricing decisions with methods that answer 3 basic questions.

  1. 1. How do prices affect revenue & units sold?
  2. 2. What price optimizes revenue?
  3. 3. What price optimizes profit?

The model has these features:

  • Test markets and test prices
  • Sales results in test markets

Estimate price elasticity from test data

  • Elasticity = % change units / % change price
  • Elasticity can change over price range
  • Returns statistics for fit of model & data

if you want to take account of price interactions among several products, including competitors, see our "Price Elasticity for Several Products".

Fully Customizable

Using our automated modelling technology you can create a report that exactly suits your needs. Turn on and off major features, specify time line, "dimensions" such as test markets, currency symbols, and date formats in a simple online form.

Easy to Use

Once downloaded, your data is presented, in a logical and intuitive format in Excel. Your Price Elasticity spreadsheet contains:
  • A carefully arranged layout
  • Comments on every variable table
  • Collapsible groups hide detail until needed
  • Easy to understand symbolic formulas
  • Easy modifiable data and preferences

The model contains everything you need to use pricing tests to optimize prices.

 
StandardPro
  • Test markets & test prices
  • Revenue & sales units in test markets
  • Price elasticity
  • Predicted sales for a range of prices
All Standard features plus:
  • Non-constant price elasticity
  • Estimates price to optimize revenue
  • Estimates price to optimize profit
  • Larger models with more of everything
7 day free trial or $297 day free trial or $39
Microsoft Office Marketplace logo
Works with Microsoft® Excel® 2003 - 2010
 

Customize spreadsheets by filling in a simple form

Step 11. Choose
The model you want
Step 22. Customize
Online form does the work
Step 33. Download
And it's ready to use

Each spreadsheet offers:

  • Carefully organized layout
  • Comments on every variable table
  • Collapsible groups hide details until wanted
  • Easy-to-read symbolic formulas show what the model does
  • Easily change input data, start date, label text...
Meet your exact needs better than any static template.
 
Learn more about ModelSheet spreadsheet customization solutions

Related spreadsheet models

Pricing for Several Products
 

Can't find your solution
Need to know more?

Find out how our consulting services can help you create and manage your ideal custom spreadsheet models.
Go to Consulting Services
 
 

Copyright © 2010, 2011 by ModelSheet Software LLC | All Rights Reserved | Privacy

Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.