I am representing a construction developer firm and I am looking for a tool to easily manage my contractors' progress and their payment. Currently I am using Microsoft Project and Microsoft Excel to keep track of all the work progress, claims and whatnot. It is a very tedious progress for me.
Note that I am not talking about software project management tools.
I am looking at the Microsoft Project Server. I am interested to configure it so that it should have the following standard project management features and functionality:
- Our construction developer firm will be the "superuser" who can see all the progress of all projects, made by our users--consists of contractors and sub-con ("normal users"). Our users can only see the projects that are related to them, they can't see other users' progress, of course. Only the superuser gets to see the whole project progress, in the form of Gantt chart, project baselines and whatnot.
- Progress indication and % of completion and all the things that a real project management has, like start date, due date and so on. The progress indication can be updated by the "normal users".
- Cost and projection. The user can specify the actual cost spent,the progress, and the estimated remaining cost for a task. At the end of the day, the program will take all these information, compute a new budget and compare this against the initial budget to check whether the project is over-budget or not.
- It should be easy for our users to attach photo, provide description in conjunction with their progress of completion.
My question is, can Microsoft Project Server be extended or configured or customized to support the above needs? Or is there any other tools ( open source or not) that can be supported to do this?