|
Excel Sales Aids
7 Excel Functions for Sales Management Efficiency
| Function |
Computes |
| Sales Force Size |
Number of sales people needed to cover accounts needing different call
frequencies and with a given number of calls that each sales person can
make. |
| Sales Force Size Breakdown |
Number of sales people needed based on expected sales and sales per person. |
| Expected Sales |
Expected sales for a month, week, or other series of numbers based on the
potential revenue and probability of success. |
| Sales Expense to Close |
The cost of closing a sale based on calls to close and cost per call. |
| Account Contribution |
Contribution to overhead for each account. |
| ROAM (Return on Assets Managed) |
Return on assets managed (as a percentage) for an account, territory
manager, regional sales force, etc. |
| Commission Lookup |
Looks-up the commission for a given quantity in a table. |
You may also be interested in our
Financial Evaluations,
Forecasting,
Pricing, and
General
Utilities formulas.
Buy today for only $39.95
$29.95. That's less than
$1.00
40¢
per
solution.
Click
here to start today.
You can try Exel-lent Marketing Formulas for 30 days.
Click here
for a fully functional trial version. When prompted, Save to your computer, then
Run (or Open). |
