This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
Overview
Overview
Program Advisor Calculator
Overview
This calculator is intended to demonstrate how time savings achieved using Program Advisor can impact an organization's financial position. The cells shaded yellow can be changed to reflect the circumstances of a specific situation. Typical default values have been provided, but values that are realistic for a particular organization will provide more meaningful insights. Cells shaded green reflect the results of the calculations.
Instructions
Fill in the yellow-shaded boxes with values that reflect your organization's current performance levels and future targets.
Key
Editable Cell
Intermediate Calculation
Opportunity Calculation Result
Abbreviations
AVG - Average
TTL - Total
MGRS - Managers
EST - Estimate
Programs Manpower Current Cost:
AVG # of HRS
EST Cost / HR
TTL Cost / Program / MGR - Sales Coordinator
# of MGRS
TTL Cost / PROG
AVG # of PROGS / YR
TTL Annual Cost
Work Flow
Division Manager gives Goal Criteria to Sales Coordinator
Sales coordinator runs sales data and provides to division manager
Division manager then divides the quotas amongst the district managers and provides to district manager
District managers adjust the quotas by rep and provide to sales coordinator
Sales coordinator sets up quota – either in current system or by spreadsheet tracking system
Sales Coodinator updates
Sales coordinator or finance calculates payouts
Sales coordinator or finance calculates chargebacks
Total Cost
Total Cost Company Wide
DI Sales Advisor Manpower Cost:
Division Manager gives Goal Criteria to Sales Coordinator
Sales coordinator runs sales data and provides to division manager
Division manager then divides the quotas amongst the district managers and provides to district manager
District managers adjust the quotas by rep and provide to sales coordinator
Sales coordinator sets up quota – either in current system or by spreadsheet tracking system
Sales Coodinator updates
Sales coordinator or finance calculates payouts
Sales coordinator or finance calculates chargebacks
Total Cost
Estimated Savings
Total Cost Company Wide
Estimated Annual Savings Company Wide
Print All Information
Please host the converted page in server to use Print All.
Update
Reset
Print All
Submit