Productivity Model/Algorithm

We are a global sourcing company. There are certain measurements to our productivity which I would like to be built into a model, then into a tool that can be utilized by our staff to determine if and how they are maximizing their work potential. Ultimately each project worked on should have a score, then a manager can aggregate the scores for each project and break it out (using the same tool) to determine a category score, a score for the respective company divisions, a total company score, etc.. Once the work is done in creating the model I would like to ideally have this be built into a locked Excel file as we currently use Microsoft Office at our company.