Manpower loading in msp 3k

i have asked for preparing a master schedule of all my firm’s current projects (activities/tasks as projects) and also to monitor the manpower loading in a particular day for the use of accepting new projects with the existing manpower. I have prepared the initial part in msp, pls let me know any valuable suggestions for the later part, suggestions are welcome in the form of excel tips. pls suggest about the datas to be callected from the department managers and site supervisors over this.

thanx & regards

Harris Famil Parol