| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | Sales Commission Calculator | |||||
2 | ||||||
3 | You can get your own custom version of this template in minutes. Visit our website, select the model, fill-in the simple online form, and export the generated spreadsheet to your Google Docs account. | |||||
4 | Get yours now! | |||||
5 | ||||||
6 | Need more? Let us build spreadsheet solutions for you. | |||||
7 | Our deep experience and powerful, proprietory tools help us build customizable models that are realistic and reliable, taking a fraction of the time and cost required by conventional approaches. | |||||
8 | Learn more about consulting services. | |||||
9 | ||||||
10 | ||||||
11 | ||||||
12 | Description of Sales Commission Calculator | |||||
13 | ||||||
14 | This model computes planned and actual sales commissions over time. The commission can be based on revenue and gross margin, and can exclude selected indirect expenses as not commissionable. All major variables are segmented by sales representative (or sales team) and product (or product family). | |||||
15 | ||||||
16 | The model tracks the following quantities. Not all features are available in the Standard Version. | |||||
17 | • Sales are measured in terms of revenue, and optionally in terms of sales units or gross margin. If sales units are tracked, the model tracks list prices, average selling prices and price discount percentages. | |||||
18 | • Cost of goods can be specified as a percentage of revenue, as an amount per unit sold or a combination of both. | |||||
19 | • Indirect expense can be specified as a percentage of revenue and as an amount per unit sold. Contribution margin is gross margin less tracked indirect expenses. | |||||
20 | • Commission can be specified as a percentage of revenue, a percentage of gross margin, a percentage of contribution margin, an amount per unit sold, and any combination of these together. | |||||
21 | ||||||
22 | As you explore the model, we suggest that you | |||||
23 | • Read some of the Excel comments that are attached to Analysis Variables throughout the workbook. These comments also appear in ModelSheet in convenient places. | |||||
24 | • View worksheet "Formulas" which shows the named variables and symbolic formulas of the model in a compact and readable form. The symbolic formulas are not active in this Excel workbook, but they give you some idea how the model works, and how it looks in ModelSheet. | |||||
25 | ||||||
26 | ||||||
27 | This workbook was generated by ModelSheet on March 18, 2011, except for this worksheet of comments. | |||||
28 | ||||||
29 | Copyright © 2011 ModelSheet Software, LLC | |||||
30 | ModelSheet and the ModelSheet logo are registered trademarks of ModelSheet Software, LLC. |