Sales Plan
ModelSheet: Custom spreadsheets in minutes
Combine data and judgment in a sales plan that optimizes your sales execution
This model is offered in a number of fully customizable versions. Compare these below and choose
the one that suits your business size and needs. Once selected, customizing your spreadsheet is quick and
easy. Your business could be using powerful, professional Excel analysis in minutes.
Each version is free to customize and preview.
| Standard | Pro | Power Pro |
|---|
- Enter products and locations
- Calculate effect of seasonality
- Suitable for small-medium businesses
| All Standard features plus:
- Channels and industry segmentation
- Historical database
- Suitable for advanced sales models
| All Pro features plus:
- Largest modeling capacity
- Maximum time periods, products and segments
- Suitable for more complex businesses
| | 7 day free trial or $29 | 7 day free trial or $59 | $89 |
|
|
|
|
|
Compare Versions
| | Standard | Pro | Power Pro |
| Product Market Segments | | | |
|---|
| Product line (by products and product families) |  | | |
|
| Selling locations | | | |
|
| Sales channels (e.g. direct, indirect) | | | |
|
| Euro zone report (reports $ and €) | | | |
|
| Industry or additional segmentation | | | |
| Information used for Forecasting | | | |
|---|
| Historical sales data | | | |
|
| Historical price data | | | |
|
| Databases for input of historical price data | | | |
|
| Managers’ inputs (high-level sales targets) | | | |
|
| Seasonality | | | |
|
| Recently introduced products | | | |
|
| New products | | | |
|
| Capacity and utlization for each product | | | |
|
| Cumulative progress toward revenue plan | | | |
|
| Time interval of forecast (can be multiple time periods) | | | |
|
| Trailing year reports (remove impact of seasonality and atypical orders) | | | |
|
| Sales commissions | | | |
| Plan/Target Comparison | | | |
|---|
| Adjust main segments (alter product, location, channel and industry to achieve targets – the model suggests changes to assist this) | | | |
|
| Adjust two-factor segments (combine two factors to achieve targets. E.g. product and location) | | | |
|
| Compare plan and actual sales (sales units and revenue) | | | |
| Adjustment for Market Conditions | | | |
|---|
| Include macroeconomic indicator to adjust entire sales plan as the economic outlook changes over plan time | | | |
|
| Include economic indicator for market conditions for each product and/or selling location and/or customer industry, to adjust sales plan as the economic outlook changes over plan time | | | |
| Profit and Margin % | | | |
|---|
| Variable costs (by product, location, including cost of goods, selling, logistics and other) | | | |
|
| Contribution margin ($ and % for each segment, by time) | | | |
| Pivot tables | | | |
|---|
| Pivot table reports for history, plan and actual sales | | | |
| Custom Model Size Limits | | | |
|---|
| Time periods in history and plan | 16 | 24 | 36 |
|
| Products | 30 | 50 | 100 |
|
| New products | 0 | 20 | 30 |
|
| Selling locations | 8 | 12 | 16 |
|
| Sales channels | 0 | 2 | 2 |
|
| Industry (or other) segments | 8 | 12 | 16 |
|
| Two-factor segments | 1 | 6 | 6 |
|
| Total segments | 100 | 500 | 2000 |
Works with Microsoft® Excel® 2003 - 2010
Customize spreadsheets by filling in a simple form
 | 1. Choose
The model you want |
 | 2. Customize
Online form does the work |
 | 3. 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.
Watch our video on how easy it is to customize our models
Learn more about ModelSheet spreadsheet customization solutions
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