Spreadsheet analysis

Spreadsheet analysis

Closed - This job posting has been filled and work has been completed.

Job Description

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,

---
Skills: analysis