Monthly Comission Reports

We have an excel spreadsheet we get each month from our source accounting system. Attached is a sample (monthlysales) From this report we need to create commission reports for each of our sales people. We have 15 different store locations and probably 65 sales people. Some salespeople have multiple salesperson numbers so they will need to be combined. The figures from the excel spreadsheet will need to be totaled, certain transaction types excluded and then the proper commission calculation created by person. There are two different commission plans, but we need it to be flexible enough to define a new plan if needed. These sheets will then be emailed to the salespeople. They can be either excel or PDF. We will handle the mailing, however, we don't want to have to save them into multiple files ourselves, it would be good if the macro / report did that for us. This work can either be done in excel (where we simply load the raw data and a macro creates the sheets) or it could be done in access and reports created. Having the historical data would be nice, so that might make access an better option. Please provide a cost and time estimate to complete this. We will obviously provide the formulas, exclusions, calculations. Let me know what else you need to complete the estimate.