Patent ID: 7739137
Filing Date: 2010-06-15
Classification: G06Q

Abstract:
1. A computer program product comprising computer readable code stored on a storage medium, which when executed by a computer processor, performs the following steps: for each project of a plurality of projects and for each of a plurality of staff members assigned to the plurality of projects, performing the following steps: a) inputting the available fees for each project, wherein the available fees are an independent fixed constraint; b) dividing each project into phases; c) determining the direct labor derived from available fees, profitability, overhead, and expenses; wherein the direct labor is a dependent variable constraint; and wherein the direct labor is determined according to the formula d) inputting the percentage of fees assigned to each phase of each project; e) determining the labor amount for each phase by multiplying the direct labor by the percentage of fees assigned to each phase; f) inputting the staff members assigned to each phase; g) inputting the percentage of each project's phase assigned to each staff member; h) inputting the hourly billing rate for each staff member; i) determining the labor rate for each staff member for each phase by multiplying the staff member's hourly billing rate by the phase percentage assigned to that staff member; j) determining the total labor rate for all staff members for each project phase by adding all the labor rates for the staff members assigned to each project phase; and k) calculating the total number of staff hours per phase by dividing the labor amount for each phase by the corresponding total labor rate for each phase; l) calculating the hours per each project's phase assigned to each staff member by multiplying the staff member's phase percentage by the total staff hours per phase; m) calculating the scheduled hours per day that a staff member is assigned to each project's phases by determining the net working days available for each phase from the start date and the end date of each phase by: n) determining a scheduled hours per month for each staff member based on the scheduled hours per day determined in step m) and determining an available hours per month for each staff member; o) generating a report showing each staff member's net availability for the plurality of projects including a calculated amount each staff member's available hours per month is above or below the scheduled hours per month for the plurality of projects to provide an indication of a staff member being respectively under-scheduled or over-scheduled.