Create Reports for Sales Commission Sytem.
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.
continued below
## Deliverables
The examples of calculations and reports are included in the files attached and start in the Reports section of the Functional Specification. The calculations are modeled in excel in the attached file,
RAC_Sales_Tracking_Calculation_Illustration.xls.
The rest of the document is there for reference just so you can see how the reports will fit in with the rest of the application when it's finished.
1. Document the objects on the reports like data elements, report headings, and selection criteria and show the calculations for summaries and commission reporting
2. Map the report objects to the data elements in the detail data model file.
3. Provide a Gap Analysis of data elements that need to be added to the data model.
4. Create the MS Access. Create a menu with a Reports Section on the Menu of the Application and attach the Reports to the Submenu. Add an Admin section to the menu and add any report settings that need to be stored and updated by a sales manager or application administrator.
The database and create sql for Sql Server is in the attached file- [login to view URL]
The ms access database the attached file- [login to view URL]
You should have the ability to complete this request based on the examples provided and the files attached and knowledge of what typical sales applications and content management systems do in the subject matter area or be willing to research the subject matter as a part of this request. Specific technical specifications are not available.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition in a software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Platform:
MS Access
Windows