Skip to main content
Go Search
MPUG Home
Membership
Resources
User Group Chapters
Knowledge Library
About MPUG
MySite
  

 

The Missing Link in Microsoft Project 2010: Project Financial Intelligence 

News Archive
Ask the Teacher: Earned Value Doesn’t Want to Calculate
Setting Recurring Non-working Time in Microsoft Office Project Standard 2007
Back to the Future
Ask the Teacher: Substituting Resources, Plus Changing the Current Date
4 Formulas for EPM Disaster
Ask the Experts: Define Critical
Oracle on Track to Buy Primavera
Ask the Experts: Why Self-Taught with Microsoft Project Isn't Such a Great Idea
Laying the Foundation for Leading a Project Management Office
Mail: Another Perspective on Defining "Critical"
Certification Insider: Creating a Project from an Existing One
A Rational Approach to Padding
Ask the Expert: Accounting for Material Resources
Chapter Spotlight: 3 Questions with London's Dharmesh Patel
Olympian Stephanie Trafton Connects Winning the Gold with Project Management
5 Compelling Reasons to Upgrade to Project 2007: Visual Reports
Ask the Experts: Displaying Availability Exceptions in Resource Usage Sheet
Certification Insider: How Calendars Control Schedules
Chapter Spotlight: 4 Questions with Houston's Vicki Eaker
The 30-second Report
Ask the Expert: Separating Time Completed from Work Completed
Certification Insider: Defining Working Times with Project 2007 Calendars
Columns I'd Like to See in Project
PMI Releases Updates to Four Standards
How to Reduce Your Project Costs
Ask the Expert: Custom Reports in Microsoft Project
The Work Breakdown Structure
The Strategies of Microsoft Project and Project Server
Certification Insider: Ready! Set! Start Creating Tasks!
Track Project Progress with Physical % Complete
Putting Project Portfolio Management to Work in a Bad Economy
Chapter Spotlight: 4 Questions with Twin Cities' Larry Christofaro
11 Reasons You Should Attend the Microsoft Project Conference
The Case of the Broken Task in Microsoft Project
Ask the Expert: Importing Data from Excel into Project
Certification Insider: Arranging Tasks
Ask the Expert: When Scheduling, Start at the Beginning
Chapter Spotlight: 3 Questions with Baltimore-Washington Metro's Gerald Leonard
Ask the Expert: Tips for Getting Project Server Buy-in from Users
Migrating to Microsoft Project Server 2007: Lessons from the Field
How Gantt Chart-Literate Are You?
Develop Your Project Management Skills: Scenes in the Negotiation Play
Ask the Expert: Optimize Microsoft Project Performance
Ask the Expert: Creating a Limited Resource Availability Schedule
Scheduling Master: Finish to Start Successors
How Gantt Chart-Literate Are You: The Puzzler Solution
The Power of Local Resources in Microsoft Project Server
Certification Insider: How To Influence Tasks and Win Friends (in Microsoft Project)
Ask the Experts: When % Complete Won't Calculate
Ask the Experts: Making Interim Plans Work for You
Project Budgeting: Money Changes Everything
Ask the Experts: How Resource Sharing Works in a Master Project
5 Principles of Program Management for the London Olympics
Certification Insider: Resourcing Project Plans
How to Replace Generic Resources with Named Resources
Ask the Experts: Building What-if Slack Time into Your Schedule
Automated Governance for Portfolio Management
Earn Your PMI-SP, Part 1: Explore the Credential
Creating Microsoft Project Custom Toolbars in 4 Steps
Certification Insider: Assigning Resources in Microsoft Project
Ask the Experts: When Linking Summary Tasks Makes Sense
Earn Your PMI-SP, Part 2: The Application Process and Getting Through the Exam
Working the Numbers: How to Inject Financial Savvy into Project Management
MPUG Thanks Community Leaders in Award Ceremony
Tips and Tricks for Microsoft Project 2007: Creating Useful Custom Views
Ask the Experts: Applying Two Constraints on One Task
Earn Your PMI-SP, Part 3: What You Need to Study
Best Practices for Microsoft Project, Part 1
Best Practices for Microsoft Project, Part 2
Certification Insider: Mastering Duration, Work, and Units
Creating Milestone Reports in Microsoft Project
Ask the Experts: Managing That Schedule with Drop-dead Deadlines
The Project 2010 Interview: Microsoft's Chris Capossela Talks to the Microsoft Project Community
How to Restore an Abandoned Project Schedule
Certification Insider: Modifying Resource Assignments
Why MPUG: Five Perspectives, One Member
The Purpose of Project Charters
Forecasting Schedule Issues with a Deadline Dashboard
Ask the Experts: Printing Notes in a Project
How to Achieve a More Realistic Schedule in Your Project Planning
Is Microsoft Project a Project Management Tool?
The New Year's Resolution of a Project Manager
Certification Insider: Understand Critical Path
Project Programming: Integrating Project Server's Timesheet with an Access Control System
Ask the Experts: What's Going on This Week?
Critical Path 2.0
Certification Insider: Exchanging Data between Programs
ProjecTalk Goes On the Air!
Ask the Experts: Making Sense of Current Activity Reports
Three Rules for a Happy Life with Project 2007
Project Date Numbering
Sign Up for MPUG Chapter Alerts!
MPUG Members: Tell Us What You're Going to Love about Microsoft Project 2010 -- and Get a Free Copy of the Software!
Microsoft Project 2010: Preparing for Launch
Certification Insider: Saving and Modifying Baselines
Ask the Experts: Creating a Report with Task and Resource Data
Microsoft Project 2010 Licensing
Microsoft Project 2010 Upgrade Path
Project Server 2010: Things to Note, and Avoid, as You Start the 2010 Journey
5 Tips for Formatting Text on a Gantt Chart
Microsoft Project 2010 Feature Rally: Sync to SharePoint
Microsoft Project 2010 Feature Rally: Manually Scheduled Tasks
Microsoft Project 2010 Feature Rally: Departmental Fields
Microsoft Project 2010 Feature Rally: Inactive Tasks
Microsoft Project 2010 Feature Rally: Team Planner
Microsoft Project 2010 Feature Rally: Reporting
Microsoft Project 2010 Feature Rally: The Ribbon
Microsoft Project 2010 Feature Rally: Synching with SharePoint
Microsoft Project 2010 Feature Rally: Project Timeline
Microsoft Project 2010 Feature Rally: Integrated Portfolio Management
Microsoft Project 2010 Feature Rally: No More ActiveX!
Microsoft Project 2010 Feature Rally: ROG, the Red Over-allocation Guy
Certification Insider: Making Resource Assignments Realistic
Ask the Experts: Exporting Only Tasks to Excel
The Great Demo! Top 10 List
The Great Demo! Top 10 List
Microsoft Project View Mastery
EPK Cost Tackles Cost Management for Microsoft Project Server
Lock Down Microsoft Project Progress Data
Certification Insider: Resource Overallocations
Don't Touch That Dial! What to Do Before Using Microsoft Project
Ask the Experts: Managing a Large Number of Resources
10 Easy Ways to Earn PDUs
The Awful Demo: Top 10 List of What NOT to Do
Microsoft Project Certification 2010 - How To Guide
Microsoft Project Certification 2010 Frequently Asked Questions
Ask the Experts: Quick Project Status Report
Schedule Tasks Your Way
Start Your Project Management Career
Calendar Exceptions in Microsoft Project 2010
Social Networking in Project Management, Part 1: Using Twitter
Ask the Experts: Updating the Baseline
Keeping Your Project Schedules Updated by the Team without Microsoft Project
Social Networking in Project Management, Part 2: Using Facebook, Blogging, and More
PMI Keynoters Clinton and Kundra Highly Value PMers
Laser Construction Wins PMI's Project of the Year Award
MPUG Mega-Guide for Learning Project 2010
Ask the Experts: Reports on Over-allocated Resources
Get To Your Control Documents Easily!
Three Reporting Questions
Certification Insider: Tracking Project Progress
The All-Time, Number-One Mistake Made by Schedulers
5 Reasons Not to Attend a PMP Exam Boot Camp
Ask the Experts: Bothersome Behavior of the New Version of My Old Friend
A Microsoft Project Beta Exam Experience
Certification Insider: Managing Multiple Projects
Focus: Getting Your Project People on the Same Page
A Call to Action: What is a Project "Schedule"?
Focus on Analytics: Stopping Project Derailments
Task Types: Don't Get Frustrated!
Ask the Experts: Configuring the Project Server 2010 Enterprise Global Template
Response to "What is a Project Schedule?"
Focusing on Deliverables, Not Just the Schedule
Certification Insider: Microsoft Project Budgets and Costs
Ask the Experts: Is Microsoft Project Overkill? And the Task Inspector Equivalent
The Basics of Estimation with Microsoft Project
How to Sell Project Management to Senior Executives Who Don't Want It
The Model Project Management Office
The Project Communication Plan
A Master at Project Management
Ask the Experts: Working Offline in Project Server 2010
10 Trends Ruling Project Management That Will Affect Your Future
Chapter Spotlight: 4 Questions with Madison's Wendy Anderson
How to Get Certified in Microsoft Project 2010
Certification Insider: Project Reporting
10 Key Business Analysis Trends to Guide Your IT Organization to Greater Results in 2011
Ask the Experts: 15 Microsoft Project Tips for New Users
Creating a High Performance Project Team
Tips for Taking the Microsoft Project 2010 Certification Exam
The Missing Link in Microsoft Project 2010: Project Financial Intelligence
Arpan Shah, Head of Microsoft Project Product Management, Discusses Service Pack 1
The Seven Deadly Sins of Project Schedules
Ask the Experts: Hammock Tasks
Project Management Advice: The Price of Right
Certification Insider: Analyzing Variance with Microsoft Project
How To Display Lag between Tasks in Your Gantt Chart
Tips on Handling a Problem Team Member on your Project
The Art and Science of Estimating Task Lengths
High-flying Jumpstart: Cloud-based Project Management
How to Use Free Analyst Reports to Build Your Case for Microsoft Project
Ask the Experts: Combining Resources across Projects
When Did You Revise the Estimates?
What's the Status of the Program? Dynamic Program Reporting
When Are You Working? Updating a Resource Calendar
Cost Decisions in Project Management Accounting
Ask the Experts: The Case of the Calendar Changes
Project Directions: Microsoft's Arpan Shah Fields Questions
What You Need to Know about Project Server 2010 Service Pack 1, Part 1
pmi2011
Is Project Management a Profession?
Project Pearls: Eliminate Over-Allocations
Microsoft Project on the Go
Ask the Experts: Selling your Message with the Project 2010 Timeline View
Quick Access Toolbar for Easy Navigation in Microsoft Project
Using Project Management for Social Change
Change Management during a Project Server Implementation
The Most-Read MPUG Microsoft Project Articles of 2011
The Most Viewed MPUG Forums Threads of 2011
Three Common Principles for Project Initiation
Ask the Experts: Over-allocation with 2.5 Hours of Work?
Group Resources for Effective Reports!
Too Tired to Care? Regain Your Perspective with 5 Proven Practices
Ask the Experts: Tying Tasks and Assignments across Projects
Manage Scheduling Contingency
Project Portfolio Management: Align Project Resources with Business Strategy
Team Players: Exchanging Project Data with Your Development Team
Ask the Experts: A Successful EPM Implementation Has More than Technology
Dealing With Uncertainty in Project Schedules
Microsoft Project Options you want to know about
Performance Tuning Your Scheduling Practices
Project Options You Want to Know About
Microsoft Community Leader Award Winners
8 Important Lessons I Learned During EPM Implementations
Insights for Scheduling
Creating an Agile Schedule with MS Project
Ask the Experts: Similar Task Names
Habits: Why Trader Joe’s Serves Free Coffee Every Day of the Year
Toolbar and Menu Commands for Microsoft Project 2007
 
 

A growing number of managers rely on project and portfolio management to help them oversee their investment portfolio. As a consequence of this reliance, many have also discovered that their organizations' current financial management practices fall short of intended goals. Results of a survey UMT conducted in September 2010 with leading U.S. companies indicated that almost 80 percent of those polled felt some level of dissatisfaction with their current financial management methods. Primary obstacles, according to the respondents, include knowledge deficiencies, lack of management support, and use of ineffective software.

Many managers fail to fully understand the impact of poor financial management. They believe that the majority of investments don't require financial evaluation -- that intangible benefits provide an acceptable metric for success. This can prove to be a costly mistake, resulting in a poor track record of project selection and mismanagement of company investments.

Further complicating matters are CEOs, CFOs, and corporate trustees, who face a litany of economic challenges and expanding compliance requirements, finding themselves under extreme scrutiny as to how they should allocate their resources. As a result, they're increasingly demanding credible evidence of strong and achievable return on investment (ROI) before assigning dollars to projects.

Managers and executives alike would best be served by establishing strong project financial management (PFM). But what type of PFM offers the most benefits? We believe it's project financial intelligence or PFI.

This article defines PFI and its importance in project selection and investment management. I also explore the cost of PFI illiteracy and the benefits that can be derived from the use of PFI. With a more detailed understanding of PFI, managers can better address their needs to finance the right opportunities and wisely manage their investments. I conclude with recommendations on how to move forward.

Project Financial Intelligence (PFI) Explained

PFI integrates three disciplines: project management, financial management, and business intelligence (BI). This integration provides valuable insight into project financials that can significantly improve decision making and visibility throughout the project lifecycle. PFI focuses on the details of cost and benefits, with information that's thorough, logical, and defensible. PFI also provides insight into decisions. In addition, PFI integrates project and business domains and helps to improve governance.

The Importance of PFI

Management expert Gary Hamel points out that over the course of the past century, management innovation, more than any other kind of innovation, has enabled companies to cross new performance thresholds. If you look closely at some of America's leading companies -- GE, DuPont, Procter & Gamble, and Visa -- you would find management innovation at the core of their success. Interestingly, according to Hamel, almost all of the 20th century's most significant management innovations -- strategic planning, capital budgeting, project management, cost accounting and variance analysis, and ROI analysis -- all fall within the PFI classification.

PFI affects most key economic organizational transactions, including capital appropriation, capital spending, tracking, investment justification, cash flow management, funding, resource allocation, and chargeback. Considering that capital spending in the United States equals about $1.38 trillion, companies could use PFI to better manage their business investments in projects and create a durable advantage that can impact the competitive position.

The Price of PFI illiteracy

The Standish Group's "CHAOS Summary 2009" report revealed that about a third of all projects have successful resolutions. They're delivered on time, on budget, and with required features and functions. What that means is that IT organizations within American companies and public entities spent $136 billion out of a total of $200 billion on failed projects or projects with unforeseen challenges.

The CHAOS report also shows a direct correlation between budget and success. For example, whereas projects costing between $1 million and $3 million succeeded 38 percent of the time, projects that cost more than $10 million had only a two percent success rate. This correlation between rising cost and lower success rate provides a clear example of how flawed financial management contributes to the failure of so many projects. With the proper use of PFI, organizations have a much better chance of selecting optimum projects and realizing their anticipated benefits.

The Benefits of PFI

PFI offers a valuable tool for many different aspects of strategic and operations management: project selection and management, operations budgeting and tracking, and governance. The following sections illustrate how managers can best use PFI in these scenarios.

Improving Project and Portfolio Decisions

A leadership team receives hundreds of project proposals to fill certain strategic or tactical gaps. Because of limited budget and resources, the team can only choose a select few. How does it create the optimal portfolio from the available options? The first step is to incorporate PFI into the process. Effective PFI drives action to approve, reject, or delay a project. To best utilize PFI, the team should consider the following course of action:

1. Develop project estimates top down or bottom up.
2. Assign cost and benefits to cost and profit centers.
3. Create financial metrics such as net present value or ROI.
4. Link strategic benefits to financials.
5. Optimize investments based on financial and strategic benefits.

Once managers receive approval on a project, they can move their project into the execution phase. During this stage, businesses need to introduce performance controls to ensure the timeliness of a project's completion, to deliver the project within budget, and to maintain financial and other data about the project's benefits.

Performance controls continue to the project's conclusion. At each review phase, occurring monthly, quarterly, or in stages, the leadership team can analyze performance. This analysis helps identify at-risk projects and their root causes and evaluates trends and predictions that assess business impact. Based on this information, plans can be revised and action taken to rectify any issues.

Aligning Project and Business Accounting

More and more organizations today follow a philosophy that encourages resource sharing. For example, a company may seek to share IT or marketing and capital investments. Sharing resources however, creates two large challenges: resource allocation and chargeback.

For resource allocation, organizations need to find a way of transferring the cost of shared resources from the unit that formally manages them to the one that consumes their services. The chargeback mechanism acts as a horizontal link between different organizational budgets in the company, keeping profit plans accurate and driving accountability.

PFI serves as the key enabler of the chargeback process. Benefits include:

  • Providing input for fair resource allocation.
  • Enabling the business unit that consumes the services to choose between internal or external sources.
  • Offering insight into the resources consumed on a periodic basis.
  • Providing the cost basis for enabling the business unit that supplies the services to charge the business unit that consumes the services.

Finally, with PFI, the organization that consumes the resources can use the chargeback bill to decide whether it still values the project benefits, if it wants to move faster and invest more, or if it should shop around to find other providers. In this way, the "consumer" can choose to get the level of investment most valued. Meanwhile, the provider aligns its services with what those consumers most want.

Enabling Better Governance

A flood of corporate scandals combined with the recent harsh economic downturn have served to undermine the confidence in current management systems and controls. Despite the fact that information assets represent more than half of capital spending, most companies lack effective financial governance.

Governance strives to promote individual creativity within defined limits of freedom by using structural and control safeguards. Structural safeguards ensure clear definition of authority for individuals handling budgets, processes, and workflows and effective standards for managing cost and benefits. In recent years, auditing has been added to this category as well.

Control safeguards measure and ensure compliance and process effectiveness. Financial compliance measures the deviation from agreed rules, practices, and standards. PFI uses the project information to drive three groups of measurements: exceptions from rules, project commitment deviations, and process effectiveness.

A Wake-Up Call

This article is meant to serve as a wakeup call to managers that perform project and portfolio management. As such, managers will need to approach PFI implementation systematically with an action plan, a methodology, and the understanding of the required information technology.

Management teams need to:

  • Take the time to assess their current situation.
  • Identify the processes that use PFI and assess their criticality and capabilities.
  • Determine the gaps between current realities and needs.
  • Consider the order in which to close them.
  • When ready to move forward, create a timeline for action.

Equally important is the project financial software that can significantly affect the analytical and collaboration capabilities. Companies can use this software to take complex data and transform it into intuitive information and visuals. When properly deployed, this software can create useful collaborative environments to define workflows, deploy rules, and ensure that those rules are followed. Over time the companies that master PFI and the tools will come out ahead.

While PFI isn't perfect, it's a huge improvement over unreliable alternatives. The combination of people and computational power presents unlimited opportunities. The quality of the project financials depends upon the sum of all project and portfolio financial decisions made by decision makers. The good news is that the quality of these decisions depends not only on the intelligence of the decision makers, but on project financial processes and methodology that can be improved and successfully deployed in your organization.

Mike Gruia
Mike Gruia is the chairman and a founding partner of UMT, a software and consulting firm in the enterprise project and portfolio management space. The company is the developer of UMT Project Financial Server 2010, which extends Microsoft Project Server 2010 to provide organizations with cost and benefit management capabilities across the project life cycle. UMT Consulting Group helps Global 2000 organizations and governmental agencies deploy essential process and governance solutions. Learn more about PFI and Project Financial Server 2010 at
http://www.projectfinancialserver.com.

© Copyright 1997- MPUG.com. All Rights Reserved. Privacy Policy - Contact Us