System and method for analysis of project variances
View Patent ↗Disclosed herein is a variance tracking report that provides a new and useful view of an enterprise's financial status. The variance tracking report may indicate variances from a planned work schedule and be used to explain any variances between projected and actual earnings as well as variances in project milestone dates. Further, the variance tracking report may show how current and past changes to the enterprise will impact future projections so the enterprise can give a clear indication of how any variances are being corrected. The plurality of views of the variance tracking report may also be analyzed in order to determine where variances are occurring on an enterprise level, a business unit level, an organization level, and a project level. Targeted action may then be taken on specific projects or enterprise methodologies in order to reduce and/or eliminate the variances.
1. A variance monitoring system that comprises:
memory that stores variance monitoring software; and
a processor coupled to the memory to execute the variance monitoring software,
wherein the variance monitoring software configures the processor to:
gather baseline effort data and revised effort data associated with specific projects, wherein the revised effort data is actual effort data for past times and forecast effort data for future times;
determine for each of the specific projects a variance between the baseline effort data and the revised effort data, wherein the variance is determined at each period for a plurality of periods of time;
categorize the specific projects into a hierarchy having a plurality of levels, at least some of the plurality of levels comprising a placeholder category and a work-in-progress category, wherein the at least some of the plurality of levels comprise an enterprise level and a business unit level, wherein the placeholder category comprises the specific projects that are being modeled and are waiting to be worked on, and wherein the work-in-progress category comprises the specific projects that are currently being worked on; and
present a total variance of the specific projects for each period for the plurality of periods of time for each of the placeholder category and the work-in-progress category at one of the enterprise level and the business unit level, wherein the total variance indicates actual variances for past months and forecast variances for future months.
2. The system of claim 1 , wherein:
the plurality of periods of time comprise a plurality of months, one or more quarters, and a year.
3. The system of claim 1 , wherein:
the categories further comprise subcategories of added projects, unplanned projects, early projects, on-schedule projects, delayed projects, canceled projects, and on hold projects.
4. The system of claim 1 , wherein the software further causes the processor to:
display a project level view listing the variances of each project for a selected category at one of the enterprise level and the business unit level a.
5. The system of claim 1 , wherein:
the baseline effort, revised effort, variance, and total variance are all measured in man-hours.
6. The system of claim 1 , wherein:
the plurality of levels further comprises a project level.
7. The system of claim 1 , wherein:
the baseline effort data is determined over each of a plurality of units of time over the course of a project based on a resource budget.
8. The system of claim 7 , wherein:
the baseline effort data is further based on a definition of a duration of project phases as a percentage of a total project duration, a project start date, a project end date and an estimate of a percentage of resources to be expended during each project phase.
9. A computer-implemented method comprising:
projecting, by an analyzer component stored on a non-transitory computer readable medium and executed by a processor, for each of a plurality of projects a resource expenditure over each of a plurality of units of time over the course of a project based on a resource budget, the resource expenditure further based on a definition of a duration of project phases as a percentage of a total project duration, a project start date, a project end date and an estimate of a percentage of resources to be expended during each project phase;
determining for each of the plurality of projects a variance between the resource expenditure and an actual or forecast resource expenditure at each period for a plurality of periods of time;
categorizing the plurality of projects into a hierarchy having a plurality of levels, at least some of the plurality of levels comprising a placeholder category and a work-in-progress category, wherein the at least some of the plurality of levels comprise an enterprise level and a business unit level, wherein the placeholder category comprises projects of the plurality of projects that are being modeled and are waiting to be worked on; and wherein the work-in-progress category comprises projects of the plurality of projects that are currently being worked on; and
generating, by a computer, a variance tracking report at one of the enterprise level and the business unit level comprising a total variance of the plurality of projects for each period for the plurality of periods of time for each of the placeholder category and the work-in-progress category, wherein the total variance indicates actual variances for past months and forecast variances for future months.
10. The computer-implemented method of claim 9 , wherein:
the plurality of levels further comprises a project level.
11. The computer implemented method of claim 10 , wherein:
the variance tracking report at the project level comprises a listing of the variances of all of the plurality of projects for a selected category at one of the enterprise level and the business unit level.
12. The computer-implemented method of claim 11 , wherein:
the categories comprise categories of placeholder projects and started projects, wherein the categories further comprise subcategories of added projects, unplanned projects, early projects, on-schedule projects, delayed projects, canceled projects, and on hold projects.
13. The computer-implemented method of claim 9 , wherein:
the plurality of periods of time comprise a plurality of months, one or more quarters, and a year.
14. The computer-implemented method of claim 9 , wherein:
the resource expenditure, actual resource expenditure, forecast resource expenditure, variance, and total variance are measured in man-hours.
15. The computer-implemented method of claim 9 , further comprising:
correlating variance values between the placeholder category and the work-in-progress category.
16. The computer-implemented method of claim 15 , further comprising:
when the correlating variance values between the placeholder category and the work-in-progress category shows a pattern of variance, initiating a corrective action that includes modifying project planning methodology.
17. The computer-implemented method of claim 9 , further comprising:
when categories show variance for one or a few projects, initiating a corrective action that comprises one or more of working more hours, working less hours, increasing productivity, hiring more employees, and adapting management techniques.