We need an excel spreadsheet that calculates the potential commission on projects. It needs to have drop down selections, easy to use, visually appealing and have a macro to print into pdf for the final calculation.
It also needs to capture the customer name, opportunity name/ID and salesperson.
We have partnered with a telco that offers commissions based on engagements.
There are 3 tiers to partnership, an upfront payment if it's a renewal or new business and different pay percentages based on those tiers of partnership.
The other variable is the contract length (5 options)
There are variables in the % of what product is being proposed as part of a solution (there are 12 product categories).
The other function this calculator needs to provide is a breakdown of payments over the term as there is a combination of once off upfront, and monthly recurring. This needs to be calculated over the term with a visual representation on a graph that can also be a macro to click the button and print to PDF in landscape for this item.
One of the pages needs to be easily modified (if the partner was to change the % paid on a product as an example) or SPIFF - there needs to be a field available for manual entry. The data for the 'backend' of the spreadsheet needs to be easily accessible, readable, but have the ability to lock down and hide with password for this page only.
hello! I can help you with your excel commission calculation project. You can be assured of a high quality and accurate output. I hope you will consider me, thanks!
10 freelancers are bidding on average $26 for this job
Greetings I have experience of more than two decades as Manager Accounts in Listed Companies. I have experience of VBA and Advance Excel. I can start your project now. Thanks