Monday, April 1, 2013

Microsoft Project Evaluation



Mr. Spacely,

I’ve prepared the requested evaluation of Microsoft Project as a potential tool for our large innovative packaging solutions company.  As you may know, Microsoft Project is a popular project management software program that assists in developing plans, allocating resources, controlling budgets, and managing progress and workloads.   I’ve considered Microsoft Project on the basis of adoption and assimilation, applicability with our business needs and structure, and cost-benefit comparison.  The results of this analysis indicate Microsoft Project would be a worthwhile investment for our company

                According to ValleySpeak Project Server, “Microsoft Project is undoubtedly the most popular project management software around” (1).   A main reason for why Project is a top seller has to do with the fact it integrates and shares features with the Microsoft cornerstone applications including Word, Excel and PowerPoint.  For example, the 2010 and 2013 editions now include the well know ‘Ribbons’ that has become a helpful and familiar feature for Microsoft users.  I call attention to this point because as you also know, our company currently operates on the Microsoft Office software platform.  Our 1500 SG&A and R&D employees have established a sound foundation with the Microsoft Office 2010 applications.  This would create a learning curve benefit that translates to meaningful productivity savings in the event we chose to implement Microsoft Project.  In the words of Bright Hub Project Management,  “Many project managers like Microsoft Project because it’s relatively easy to learn, as long as you’ve already used Microsoft Windows and other Microsoft products” (2).  I estimate users would require approximately 8 hours of focused self-practice in order to reach an adequate level of comfort and proficiency with Microsoft Project.   For 1500 employees at an average wage of $45 per hour times 8 hours this equates to a total of $540,000 in productivity losses related to assimilation with Microsoft Office.  While this is significant, a comparable product like Oracle’s Primavera P6 might potentially take three times as long to attain proficiency.  That equates to a cost of $1,620,000.  This means there is an estimated productivity savings discount of $1,080,000 that we can realize by choosing Microsoft Project versus a competitive alternative.

                I evaluated Microsoft Project in terms of compatibility with our business operations to see whether it’s a sensible fit for us.   An online resource by the name of Project Assistants explained there are critical criteria “that would indicate whether or not there is favorable ROI for implementing Microsoft Project”, which hinges on the organization’s “number of projects, complexity of projects, and how much the organization has to invest” (3).  According to Project Assistants, “Your organization needs to run at least ten simultaneous projects for there to be enough complexity to necessitate software such as Microsoft Project Server 2010” (3).  Last year we deployed 75 high potential R&D projects as well as 50 other major projects across our SG&A departments.   Projects spanning wider geographic areas or those which are less predictable or repeatable are better candidates for Microsoft Project (3).  Our company’s operations span the globe and most of our projects are highly specific initiatives or large and complex collaborations.   “The more your organization invests in projects, the more value there is in reducing risk in your projects.  Your organization needs to measure budgets in the millions for there to be enough at stake to be worth implementing technology into the project management process” (3).  Our SG&A and R&D budgets are in the hundreds of millions.  Last year we invested nearly $500 million in R&D and another $700 million in SG&A.  Nearly one third of this spending was related to projects alone.  Our company is of adequate size and our projects are of scope and complexity that would warrant Microsoft Project.

                In evaluating the potential benefits it is important to focus on additional efficiency savings that could be generated through Microsoft Project software.  I estimate that we should be able to generate an average 3% savings across all companywide projects through the use of Microsoft Project.  This is largely attributed to more tightly controlling budgets and more efficiently assigning resources to project tasks.   Considering our $400 million projects budget a 3% savings amounts to $12 million per year.   There is a likelihood that the savings could eventually reach 5% or $20 million per year over time as experience becomes a greater factor.  The initial incurred costs to implement would be comprised of software licenses as well the productivity losses as discussed earlier.   Individual licenses for Microsoft Project Standard cost $589.99 (4).  By purchasing larger quantities of licenses we could attain a 75% discount on this price.  If we were to purchase a license for all SG&A and R&D employees the cost would come to $663,739.  When we add on top the learning curve related productivity costs of $540,000 the total implementation costs amount to $1,203,139.  Even if we only attain 2% project efficiency savings (as opposed to the 3%) we would still realize a net benefit of approximately $6,800,000 in the first year.

                In conclusion, it is evident that Microsoft Project is smart choice for our company for the following three reasons.  Our existing experience with Microsoft Office gives us a learning curve advantage with Microsoft Project that equates to productivity cost savings of roughly $1 million versus adopting a competitive product.  Our company is a prime candidate for benefiting from project management software due to number, complexity and amount of money we invest in projects.  Finally, when we consider the payoff versus the investment we notice that we would realize a minimum return of $6.8 million in the first year. 

                Please feel free to contact me if you have any further questions or concerns that I could assist with on this topic.

Regards,
Bobby


No comments:

Post a Comment