sign in · new user? sign up
 · feedback
 

Customizable Spreadsheet Template: Sales Planning

Available Versions

These are not rigid spreadsheet templates. You can customize them in dozens of ways to get the features you want while reducing unneeded complexity.

VersionDescription Download
Price
LightThe Light version has the same features as the Standard version, only it is smaller. It lets you try the customization process and download a customized working template for free. Free
StandardProvides a sales plan with products, sales channels, historical trends, seasonality for modest-sized analyses. $89 $49
AdvancedIncludes all features in the Standard version, plus optional customer industry segments, new products, product profit margins, foreign currency zone, and a larger model. $149 $89
Advanced Extra-LargeIncludes all features of the Advanced version, and a larger model with more products, channels, customer industries, and longer historical and plan time ranges. $199 $119
* Customization and preview is always free. If applicable, you'll be asked to buy before downloading a working spreadsheet.
  We offer a money-back guarantee.

Customizable Feature Comparison

These are not rigid spreadsheet templates. You can customize them in dozens of ways to get the features you want while reducing unneeded complexity.


Feature Standard & Light
Version
Advanced & Extra-Large
Version
Comments
Product Market Segments
Product line Check Check Several products, optionally organized in product families
Selling locations Check Check Many selling locations
Sales channels   Check Several sales channels (such as direct, indirect)
Euro zone report   Check Optionally reports Euro zone in $ and €
Industry or additional segmentation   Check Choose one other segmentation, such as customer industries, customer groups
Information that Shapes the Forecast
Historical sales data Check Check Revenue and sales units by product-market segment and numerous time periods
Historical price data Check Check List prices, historical price discounts, average selling prices by product-market segments
  • Databases for historical data
  Check Optional Excel databases for easier input of historical sales and price data
Managers' inputs Check Check Managers’ sales targets for high-level product-market segments
Seasonality Check Check Extracts seasonality from historical data and applies it to the plan
Recently-introduced products Check Check Products recently introduced are forecast with regressions that exclude zero sales history before introduction.
New products   Check Sales plans for new products (that start selling during the plan time range) are specified without using historical sales data.
Time interval of forecast Check Check Forecast can be for multiple time periods
Trailing-year reports   Check Includes trailing-year reports that remove seasonality and decrease impact of random large orders on trends.
Match Plan to Managers’ Targets
Adjust main segments Check Check Adjust segments for products, locations, channels and customer industries to better match targets. The model suggests adjustments that bring the plan closer to targets.
Adjust 2-factor segments (1) Check(6) Adjust segments for up to six 2-factor segments (such as product-location) to better match targets.
Profit and Profit Margin %
Variable costs   Check Variable cost of sales by product and selling location, including cost of goods, selling costs, logistics costs, other costs
Contribution margin   Check Margin $ and % for each product-market segment, by time

Version Size Limits

Feature Standard Advanced Advanced Extra Large Comments
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  
Total segments 100 500 2000 (# products * (# locations) * (# channels) * (# other segments)≤ limit
 

Copyright © 2010 by ModelSheet Software LLC | All Rights Reserved | Corporate Home | Privacy

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