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