Sales Budget Reporting


Development of a “Sales to budget” report and a weekly “Sales to budget Flash” report for our company web portal.

Please reference this list of Data tables to read data from:

 General Ledger Actual Summarization Table

o On a nightly basis general ledger actual data for the days sales will be compiled in to summary totals.

 General Ledger Budget Table

o This table will contain sales budgets to be matched to actual

 Countries Table

o Lists all countries our company currently does business in.

 Regions Table

o Containing the company’s sales regions

 Territories Table

o Containing our company’s sales territories

 Sales Representatives Table

o Containing the company’s sales representatives

 Region’s Territories Link Table

o Linking Territories to a Region

 Region’s Sales Representatives Link Table

o Linking Regions to a Sales Representative as Regional Manager of the assigned regions

 Territory’s Sales Representatives Link Table

o Linking Territories to a Sales Representative as Territory Manager of the assigned territories

 Manager’s Sales Representatives Link Table

o Linking Regional Manager to a Sales Representative as District Manager of the assigned Regional Managers

Developed reports must adhere to restrictions compiled by our company’s CIO.

When sales representative accesses the company web portal

Territory Managers are only allowed to see their sales data.

Regional Managers are only allowed to see their Territory Managers sales data

District Managers are only allowed to see their Regional Managers sales data

Upper Management and Administrators are allowed to see all sales data

Note: Administrators, Upper Management, District and Regional Managers will be given the

option to see a Detailed or Summary result.

Summarized results can be selected to show totaling up to the requester’s title.

Before bidding on this job, consultant must possess the following skills:

Database Knowledge (MySQL and/or MSSQL),

PHP 5 or better, JavaScript,

Familiarity of Ajax and PHP Frameworks

(Yii would be an example of a PHP Framework and/or If you know the internal working of Morfik

then you would have a good understanding of a PHP Framework)

If you meet the above requirements please submit your bid in order to be considered for the job. Candidates will be considered anonymously via email. Once bid is accepted, consultant will be contacted and engaged for above job. Please do not respond if you do not possess the above-mentioned skills or plan to engage other resource to conduct job.

Skills: Graphic Design, HTML, PHP, Website Design

See more: budget sales reporting, sales budget, yii - design, yii design, web development consultant, territory sales manager, territory manager, sales representative job, sales representative company, sales management sales representative regional sales manager, sales management consultant, sales job title, sales job requirements, sales consultant job, regional sales representative, regional sales manager, regional sales consultant job, regional manager, list of ajax frameworks, job of a general manager, javascript ajax frameworks, graphic design manager job, graphic design job candidates, general manager job, frameworks ajax

Project ID: #5118190

23 freelancers are bidding on average $1658 for this job


Kindly ignore the bid amount & time-line, as we still need to analyze your requirements more in depth & discuss with you. -------- Dear Sir, I have read your Project Description and understand the initial concept, More

$1546 USD in 45 days
(46 Reviews)

Dear Sir, We have build many complex websites using PHP and MySQL earlier. Waiting for reply, Manpreet Singh

$2000 USD in 30 days
(224 Reviews)

Hi there, Thanks for posting the project. Let me first introducing ourselves, We are ISO 9001:2008 & BBB accredited WEBSITE & APPS Design - Development Company with 10+ YEARS of field experience. I have initially revie More

$1480 USD in 30 days
(139 Reviews)

**********************.. YOUR SEARCH ENDS HERE .. ********************** GET IT DONE RIGHT THE FIRST TIME! Hello Sir/Ma'am, I look forward to talking to you further and getting started. I've been working in simple and More

$1649 USD in 10 days
(128 Reviews)

1. Invoicing App We already designed and developed a complete online invoicing application in which currently we are handling these modules 1. Place New Order (phone order page from sample) 2. Pending Orders 3. Shi More

$1427 USD in 22 days
(82 Reviews)

Hi, We have read your requirements and would like to discuss things further. We have 5 PHP experts in our company and have strong hands in Core PHP, Yii and other frameworks and have completed over 80 medium sized More

$1546 USD in 20 days
(51 Reviews)

Hi, I have gone through your project description and could assure you the best of the solution. I am taking it as an opportunity and ready to deliver my best. we have done several complex business software like More

$1500 USD in 45 days
(147 Reviews)

Hello We went through project description a very well .Please provide more details about the project .We are professional website design and development company operating in UK and India. We have 8 years of experienc More

$2577 USD in 38 days
(101 Reviews)

Let's discuss in detail for the proper estimation of cost and time. see my recent work for the technical expertise along with reviews & feedback on my profile page. let's discuss and get started.

$1546 USD in 15 days
(63 Reviews)

Hello Sir, I am from Confianza Technologies. I have gone through your requirements. We have developers who have vast experience in required technologies. We are interested in your project, but before finalizing budget More

$1546 USD in 25 days
(40 Reviews)

Hi, I have understood your requirement I have good experience in handling HTML5/PHP/Java/J2EE/iOS and Android apps/Drupal/Ruby & Ruby on Rails/Javascript/MySQL/ I can handle this task for sure.I Hope we can wo More

$4639 USD in 50 days
(48 Reviews)

Hello, We have gone through your requirement and are confident that we can successfully execute the project within the timeline. We are an established Web Design and Development Company having a defined and qualitat More

$1546 USD in 35 days
(45 Reviews)

Dear Valuable Client, If you look at my ratings, you can see that I can complete medium to large projects successfully with great satisfaction. I specialize in advance scripting and can do even the most complex of pro More

$1546 USD in 30 days
(5 Reviews)

Hi there, I have analysed your project description, needs and requirements and will incorporate every feature that you require. I am confident about delivering the exact solutions that you are looking for. Technical More

$1473 USD in 30 days
(44 Reviews)

Hello Sir, We are an Indian based company, we are having experts to handle this project and can finish in desired time frame,so it will be great if we can discuss more about the work We can also Send our portfolio o More

$1394 USD in 45 days
(22 Reviews)

Hello Hiring manager, Greetings from Evidcomm!!! We have gone through your requirements and would be pleased to work on. We have already done this kind of work in past and surely we will get finished this project More

$1000 USD in 25 days
(31 Reviews)

Hello, Thanks, for giving us a chance to bid on your project. Please check private message box for more details. We are WebGloabalIt is an (ISO 9001:2008) (ISO 27001:2005) certified company which have throught More

$1159 USD in 22 days
(18 Reviews)

Hello We are well reputed IT company in India and we are working legally under the reorganization of Indian government.we are having more than 500+ satisfied client all over the globe we are mainly focus on ASP.N More

$2000 USD in 30 days
(3 Reviews)

PHP expert... check pm pls! PHP expert... check pm pls! PHP expert... check pm pls! PHP expert... check pm pls!

$1250 USD in 3 days
(75 Reviews)

Hello, Thank you for reading our project proposal, i had assumed the project scope and here i am briefing the full scope with work and the time line- ------MY WORK PORTFOLIO---- Microsoft,, C# More

$2000 USD in 35 days
(2 Reviews)