Closed

sales reportin system

This project received 10 bids from talented freelancers with an average bid price of $618 USD.

Get free quotes for a project like this
Employer working
Project Budget
$250 - $750 USD
Total Bids
10
Project Description

I need someone to develop a sales reporting system (srs) on web for an alliance of companies.
I want this system to be made in [url removed, login to view] with Visual Basic (at least 2010) with Microsoft SQL Server 2008 database (at least 2008). Use of CSS is a must. We also prefer that the Membership API, Roles API and Profiles is used if they can solve the issues.

The companies in the alliance have level structures for Regions, Departments and Teams. Each level has its own leader and the leader is able to se all reports in his level and the one level below.
Each Team leader shall maintain a budget for each of the products for each of his persons in the team for each year. The budget for a person can be devided into periods of the year. Ex Tom should sell 200 kg of oranges in the period Jan 1. - Mar 31. and 1000 kg in the period Apr 1. - jun 15. In the rest of the year he should sell 4000 kg of oranges.
Every leader is also a person who can registrer sales.
The company administrator shall maintain the persons' data.

The persons register sales in an external system. A text file (.csv) with the sales details is copied every morning to the web site. The srs must read these details to a table in the database.
The company administrator shall be able to see every person's, team's, department's, region's and the company's sales amounts in chosen periods and with so far or not choice.
The company administrator maintains the hierarchy of the company. The top level is alliance. The alliance administrator can register and activate companies. The companies in the same alliance have the same productids and productgroupids.
The alliance administrator shall administer the products and the productgroups. The company administrator choose which products to use in his company. The company administrator define the sales contribution for each product in his company.

After the person has logged in he will immediately see the sales report according to his role in the company and the default choice he has for period and so far or not. If it is a leader he will se his levels numbers.
The top of the page will be like this:
Line 1: An image for my company, place for more images with links to come later, name of the person logged in, button for personal settings for the person and finally a log out button.
Line 2: The Alliance name, the company name, the Region name, the Department name and the team name, with dark background color. Symbols must mark the type of each level. The team is a small house, the department is more houses togheter, the region is a tower, the company is hotel? and the alliance is the earth.
Line 3: A line with shortcuts to the periods to choose from: The last 4 weeks, this and last month, this and last quarter, this year and a select button for so far or not.
If the person is a team leader there must be a link to his own sales numbers and the budget change possibility at the rightmost.
The person will see a report like this in the rest of the page:
Headings: Product % Result Budget Sales contribution vertical line % Result Budget Sales contribution
Grouping is Productgroups
Product name, with products %, result, budget and sales contribution on each line.

The productgroups and products shall be shown in the order set in the product table and productgroup table and defined by the alliance administrator.
&% (percent) is a decimal with 1 decimal and is calculated by Result / Budget * 100 for that product.
If the Percent is under 80 the cell with the percent number is background light red. If it is between 80 and [url removed, login to view] the color is yellow and if it is at least 100 the color is light green.
The sales contribution is result times sales contribution for the product and set by the company administrator. The numbers in Result, Budget and sales contribution is shown with 2 decimals if the number is under a fixed number set by the alliance administrator.
This is a system with many details. But ist not so big. It's not possible to write more.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online