Business Dashboard + simplified customer management system

Dear all, (This is filed under PHP/MySQL but in truth we have no specific platform requirements other than having a web app, the platform choice is yours - see below) As a management consultant, my current client is a small pharma lab which I'm helping on management matters. As part of my recommandations, I have advised that they make a better use of IT to boost their business, and the company asked me to follow up on this issue. So we are looking for a developer (or group of developers) to build the following applications : (1) a business dashboard that will provide our different categories of users with standard data and charts to follow their part of the business (2) an Electronic Territory Management System, which is a simplified Customer Management System adapted for the specific needs of our sector : in the pharma sector, you never sell directly to your final customer, but you do it through prescriptors (for instance, I sell medicine to an hospital, but the hospital decides to buy my medicine only because some doctor in there decided my medicine was best for his patients), so you don't do leads management and contract management - the only objective is to monitor how sales reps follow up their meetings with the prescriptors in their assigned territory, hence the name "Territory Management System" (3) a small HR module to manage training of the sales reps by tracking their skills, the training they got, how they were rated during training sessions, and organizing feedback from training (4) a portal to enable easy access to all of this and dispatch internal communications The main constraints are : (a) All of the data is inter-related, as we want to be able to cross-analyse data from the ETMS (such as the number of visits from one sales rep to a prescriptor) with sales data, and we want to be able to display sales data and objectives in the ETMS. (b) (That goes without saying) ACLs should be implemented so that people only access the data they are allowed to. (c) The source code should be transfered to us at completion. (d) We need an interface to bulk-import sales data from Excel or text files, the layout of which can vary depending on the source. However, there are no more than 10 different layouts. (e) Browser-based seems better as the data is centralized and most people on the move, but do propose otherwise with the pros and cons of your approach vs a web-based approach. If you see fit, your proposal should include the cost of buying third-party modules to speed up development (a charting API for instance, or even a fully fledged dashboard API if gains are properly demonstrated). This will be regarded as part of the package. If you decide to use a platform that requires licensing, please state the additional cost. This will be also be regarded as part of the package. Finally, I would like to know what would be the additional cost of allowing asynchronous/offline use of the ETMS - I really consider this an addition to the project, so you should price the project without even considering this option, and then state the option price. Thank you very much for taking the time to respond to this. I'll answer any questions. Best Regards, R. Turba