Need excel spreadsheet set up to do historic comparison and modeling for company commission plan.
Need to work a three year history for department. be able to assign value based on managed revenue and return corresponding commission rates. Do this for hourly income (Based on tenure) + Growth and managed revenue commission rates.
Also, will need to blend in a 12 month rolling history to further capture qualification rates,
Want an easy to navigate front page to bear results of data crunching on other tabs,