Document Sales Commission Calculations for Reports

Document the Sales Commission Calculations for the following Sales Reports and attached files. Provide the business rules as a functional specification and illustrate calculations. This request is only for the Reports section of the attached Functional Specification draft. The other sections are still in process and are provided for reference. An Excel Model of the calculations is attached in the following file, [login to view URL] Components of the Project: 1) Include multiple criteria (sales volume, gross margin dollars, VA business percentage and new account). 2) Sales reports. Data sources, requirements: 1) Sales Volume dollars, Gross margin dollars, GP percentage??"Dimensions 2) Percent Value Add Sales??"combination, Dimensions plus custom report that was created by Rosalind. 3) Percent current, DSO calculations??"combination dimensions, Custom report. 4) New accounts??"combination Dimensions, Custom report. Calculations 1) Sales run rate??"YTD sales/number of months completed X time twelve. This calculates annual sales run rate. 2) GM Dollars run rate??"TYD gross margin dollars /number of months completed X time twelve. This calculates annual sales run rate. 3) VA Product Sales Percentage??"calculated on sales of VA products (Millwork, trusses, doors, windows, panels, closet system) as a percentage of total sales. 4) New account totals??"data is actually pulled from Report taken from Dimensions for new accounts opened. Point totals 1) Point totals are figured by plotting the run-rates on the scale and extending the earned points to the point total column. 2) The total points for each category are carried down and the total is calculated. Style Guides to Follow Microsoft Manual of Style for Technical Publications Chicago Manual of Syle ## Deliverables 1) Documentation as described above. ## Platform VS2005