Pricing Tests and Price Elasticity for several products

ModelSheet: Custom spreadsheets in minutes

Set prices of related products to maximize your profits 

This model clarifies the interactions between prices and sales for a large number of interacting products. Products can be yours or competitors.

Answers questions such as:

  • How do prices for Product A affect sales of Product B?
  • What prices optimize total revenue?
  • What prices optimizes total profit?

The model has these features:

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

Estimate price elasticity from test data:

  • Price cross-elasticity = % change units (A) / % change price (B)
  • Elasticity can change over price range
  • Returns statistics for fit of model & data

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 product lines, 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

 
StandardProPower Pro
  • Test markets & test prices
  • Revenue & sales units in test markets
  • Price elasticity for each product
  • Price cross-elasticity for pairs of products
  • Predicted sales for a range of prices
All features in Standard version plus:
  • Non-constant price elasticity
  • Estimate prices to optimize revenue
  • Estimate prices to optimize profit
  • Larger models with more of everything
All features in Pro version plus:
  • Larger models with more of everything
7 day free trial or $497 day free trial or $69$99
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 One Product
 

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.