Insert Friend's Email Address Above to Inform Them







Search for:




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).


Formula Categories     Trial     Purchase     About     Support     Search     Email     InfoTech Marketing    Total Customer Analytics     The Sales and Marketing Source    Site Map

Copyright 1998-2014 InfoTech Marketing. All rights reserved.

InfoTech Marketing, 8601 W. Cross Dr. F5, Suite 139, Littleton, CO 80123  Phone:  720-732-4588
Revised: January 18, 2014