Pricing Tests and Price Elasticity for several products

ModelSheet: Custom spreadsheets in minutes

Set prices of related products to maximize your profits 

Estimate optimal prices for several related products, including competitors.

This model goes beyond texbook "straight-line" relationships between prices and sales to estimate optimal prices.

An optimal price is one that yields a maximum of either revenue or profit, by taking into account impact of your other products, competitors' products, cost of goods and other per-unit expenses you choose to include.

This model helps you:

  1. 1. Model price changes before making them
  2. 2. Explore price effects across products
  3. 3. Set prices to maximize revenue
  4. 4. Set prices to maximize profit

The model helps you to focus on improving your pricing, not on building spreadsheets.

Try our customizing process now for free. It's easy - and fast. If you like what you see, buy it and start using it.

Your purchase entitles you to customize and download your workbook three times, so you can to edit your model, correct any errors, and include features you may have declined.

 
StandardProPower Pro
  • Test markets & test prices
  • Price elasticity for each product
  • Price cross-elasticity for pairs of products
  • Predicted revenue & sales units
  • standard errors of (cross) elasticities
All features in Standard version plus:
  • Non-constant price elasticity
  • Estimate prices for max revenue
  • Estimate prices for max profit
  • Larger models with more of everything
All features in Pro version plus:
  • Market segmentation
  • t-statistics for elastiticies
  • F statistics for R-squared
  • Larger models with more of everything
7 day free trial or $197 day free trial or $39$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 - 2012 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.