Repetitive construction projects are common in India. Several approaches have been practised for modelling repetitive construction projects towards optimizing scheduling and resource allocation. This paper presents the model that uses Program Evaluation Review Technique (PERT) method and the spread sheet to prepare optimum scheduling for an effective utilization of the man power on the basis of data obtained from Mass Housing Project (MHP) for repetitive activities in order to minimize the overall project duration in the construction projects. The data presented in this paper has been collected from small scale building construction promoters in Chennai. The model presented in this paper is a formulation that can be easily modified and implemented for any type of repetitive project problem. Thus the result of this model can be used to predict the overall duration of the project and plan for effective utilization of the resource.