Full Sail Partners Blog | Project Management

Posts about Project Management:

Effectively Manage Your Professional Services Firm Using Project Accounting

Posted by Rhiannon Schaumburg on September 19, 2024

09-12-24 DVP Effectively Manage Your Professional Services Firm Using Project Accounting - Banner

When thinking about standard business accounting – what automatically comes to mind? Income statements, balance sheets, departmental budgets, and the various aspects that make up those statements – right? These figures are, of course, very important to know and understand. But that is only part of the whole picture of the health of your professional services firm. How does your firm go about determining how those figures came to be, which projects were profitable, which weren’t, and why? These questions, and many more, can be answered by implementing project accounting for your firm.  

First, What is Project Accounting?

Let’s start by comparing it to standard accounting, which most of us know. Standard accounting manages the financials using a company’s organizational structure – how divisions or departments track things like their G&A, labor, etc. compared to their budgeted amounts on a periodic basis. Project accounting goes deeper and looks closely at the different projects a professional services firm has undertaken, most of which regularly cross departments and might last months or even years.

Let’s say, for example, company X wants to undergo a new green initiative in its office. Standard accounting will keep track of costs for things like the smart electronics to manage lighting and HVAC or the newly hired “Green Officer.” However, what standard accounting doesn’t do is manage the costs for the actual project, i.e. how much did it cost you to achieve your final goal. 

But let’s take this a step further.  Let’s say you need to provide this service to a customer – you’re going to implement that same green initiative at a client site. 

Using Project Accounting, you could also manage, discover, and analyze things like:

  • The amount of time dedicated by project staff and management to build and maintain the project plan, including the phases of work and project hierarchies
  • Tracking of the contract budget/contract status/change orders and add-on services
  • Whether you are effectively utilizing your internal resources
  • Maintaining up-to-date project deadlines and the associated costs of meeting or not meeting those deadlines
  • How percentage of completion is managed and tracked to budget
  • If the project was budgeted correctly, and how what was learned from this project can be used to better manage projects going forward

Outgrowing Your Basic Accounting Solution?

Small professional services firms often rely on simpler accounting software solutions to manage their day-to-day business. One common example is QuickBooks. This product can often serve a company’s needs…for a while. However, these firms will soon find that they are outgrowing the software’s limited capabilities.

J. Carlton Collins, CPA details those limitations in his piece “Practical Advice for Companies That Have Outgrown QuickBooks”.

At a glance, those basic limitations can be summarized as:

  • Limited accounting system features
  • Limited database performance 

For various reasons, the limited accounting functionality and database performance provided by these simpler software products can actually be appealing to these smaller companies initially. But at some point, growing firms will discover that they need accounting software that can grow along with their business. They will need more than limited features and performance.

Need Help While Gaining Growth?

Growth can be defined by many different metrics – for example, an increase in revenues, an increase in number of employees or customers, higher profits, and greater market share, just to name a few. Professional services firms experiencing this sort of growth will eventually need to take that step up to an accounting software solution that will provide them with both standard accounting, as well as project accounting capability.

Take, for example, this advice from Lindsay Diven, Marketing Manager at Full Sail Partners, in her article about “The Importance of Benchmarking in Measuring Business Growth”. She tells us that “by rigorously examining internal operations against recognized standards, firms can pinpoint critical deficiencies and implement strategic changes, ensuring survival and fostering growth in an ever-evolving marketplace.”

As Lindsay says, by utilizing some of the capabilities of a robust project accounting software system, you can start to:

  • Identify Efficiency Gaps
  • Enhance Competitive Advantage
  • Drive Strategic Planning
  • Improve Financial Performance

So, if your firm is expanding, and the sort of growth that we’ve identified above is important to the future of your firm, you should look to us here at Full Sail Partners to help you navigate the next step to support your firm’s growth.

Achieve Success Through Project Accounting

In the end, we are all working toward success for our professional services firm. And to most of us, success means growth – in whichever metric resonates the most with the ongoing health of your firm. So, to achieve that healthy firm growth means managing every minute, as well as every dollar, spent, through project accounting, to obtain that success.

New call-to-action 

 

The Unknown Features of Timesheets in Deltek Vantagepoint

Posted by Amanda McClain on August 15, 2024

08-15-24 DVP Timesheets - BannerThe necessity to turn in timesheets every two weeks is never at the forefront of your employees' minds. They are focused on their day-to-day tasks. Some employees stay ahead of the game and create their timesheets as they go. Others are swamped with their workload and struggle to keep them current and completed on time. However, it is essential in nearly every industry to keep the circle of business moving and income coming in. So features are needed to make the timesheet process seamless and most efficient.

Poor timesheet management inherently leads to inefficient processes later. Miscoding timesheets may cause imprecise reports and incorrect invoices. It could also require additional time to correct and transfer time to the proper projects. Most importantly, incorrect timesheet entry affects the cash flow of your company, due to delaying the processing of client invoices.

In Deltek Vantagepoint, the process has been simplified and made more user-friendly for the end user. To start, timesheets should be entered daily and submitted on time. Secondly, project managers must always ensure they are reviewing the timesheets. Timesheets should then be corrected before they are posted to the project.

Features of Timesheets in Deltek Vantagepoint to Improve Efficiency

Accurate and efficient timesheet management policies and procedures are necessary and should be incorporated into your culture. This, along with daily entries and strict deadlines for timesheet submissions. Fortunately, Deltek Vantagepoint has a variety of tools to help assist project managers in this process.

  • Floor Checks can help you ensure that your employees complete their timesheet entries on time. You can do a floor check to review the status of time entries for your employees for a specific period or day. This will show the employees’ expected hours versus the actual hours that were entered. Additionally, there is email functionality available, so you can email your employees directly and let them know to complete their timesheets. You can enable notifications within the system or create email templates for the reminders.
  • Unposted Labor Report is a standard project report that shows all timesheet data in unposted transaction entry files and all timesheets that are in progress, submitted, or approved but not posted. This enables project managers to see what has been charged to their projects before they are posted. It is preferred to correct the timesheets before they are charged to the projects.
  • Project Reports with Unposted Time can be included in project reports by using the unposted time option. Project managers can then see the labor that is charged to their projects throughout the time period.
  • Line-item Approval allows project managers to have control over their project labor costs to make sure labor is posted to the correct project. It allows project managers to only see their projects when in the approval stage. Vantagepoint will let you know if only part of the line items subject to line-item approval have been approved, yet others have not been approved or have been rejected.
  • Timesheet Audit Trail allows you to see if there has been a change made to the timesheet after it has been saved or submitted. You can make timesheet comments required, or just track the change without additional explanation. Audit trails can be used to track billing transfers. You may find the timesheet audit trail in employee reporting.
  • Copy from Prior Timesheet option allows you to copy projects you have previously or frequently charge time to. You can select this option once in your current timesheet. This option saves you from having to create your project list repeatedly for frequent projects. Timesheet comments are also saved in a drop-down box to select from. So, if you have used the same comment previously, you may select that option versus having to write the same thing repeatedly.
  • Deltek Time & Expense for Vantagepoint app is now available to access your timesheets when you are on the go. Not in front of your computer? No problem. You can capture expenses from anywhere and upload receipts immediately. Approvers may also approve timesheets and send reminders to employees via the mobile app. Keeping up with your timesheets has never been easier!

Get Your Timesheets Done with Deltek Vantagepoint

With all of these amazing features in Deltek Vantagepoint at your fingertips, timesheet management is within your grasp. Keep the circle of business moving, and that income coming in. Start with daily timesheet reminders, and eventually, you will develop a plan that makes timesheet management best practices part of your firm’s culture.

 

The Importance of Benchmarking in Measuring Business Growth

Posted by Lindsay Diven on May 02, 2024

05-02-24 The Importance of Benchmarking_Banner rev 2

For project-based firms like those in engineering, architecture, and consulting, failing to measure and understand business performance against industry standards can lead your business towards stagnation or decline. Benchmarking, the critical practice of comparing business processes and performance metrics to industry bests and best practices from other companies, is not just beneficial—it's essential. Without it, firms remain blind to their operational inefficiencies and market position, risking obsolescence.  

By rigorously examining internal operations against recognized standards, firms can pinpoint critical deficiencies and implement strategic changes, ensuring survival and fostering growth in an ever-evolving marketplace. This article will guide you through the importance of benchmarking, how to get started, identify key performance indicators, and effectively integrate these practices to drive business success. 

Why Benchmarking Matters for Project-Based Firms 

For project-based businesses, every project represents a complex interplay of resources, time, and client requirements. Benchmarking provides a structured approach to analyzing these elements by focusing on Key Performance Indicators (KPIs) that drive business success. It allows leaders to make informed decisions based on data-driven insights, rather than intuition alone. 

The importance of benchmarking in this sector cannot be overstated. It helps firms: 

  • Identify Efficiency Gaps: Benchmarking can highlight discrepancies between a firm’s current practices and the industry's best, allowing for targeted improvements. 
  • Enhance Competitive Advantage: Understanding where you stand in the market can help you leverage your strengths and address weaknesses, setting you apart from competitors. 
  • Drive Strategic Planning: With a clearer picture of how well you perform against benchmarks, you can prioritize initiatives that drive growth and enhance profitability. 
  • Improve Financial Performance: By aligning operations more closely with successful benchmarks, firms can improve profitability through better resource management and cost control. 

Getting Started with Benchmarking 

Implementing a successful benchmarking process involves several steps, from choosing relevant KPIs to analyzing external data. Here’s how to get started: 

Step 1: Define Relevant KPIs 

Selecting the right Key Performance Indicators (KPIs) is crucial as these metrics will guide your benchmarking efforts and influence strategic decisions. For project-based firms, understanding both financial and operational performance is essential. Consider the following essential metrics: 

  • Utilization Rate: This measures how effectively the firm uses its billable staff. A high utilization rate often correlates with higher profitability and is a clear indicator of workforce efficiency. 
  • Net Labor Multiplier: A critical profitability metric that assesses how much revenue is generated per salary dollar paid. It highlights the financial effectiveness of human resource investment. 
  • Operating Profit: Looks at the firm’s earnings before interest and taxes, providing insight into operational efficiency and overall financial health. 
  • Current Ratio: This financial ratio measures a company's ability to pay off its short-term liabilities with its short-term assets. A strong current ratio indicates good liquidity health, crucial for maintaining smooth operations and responding to unforeseen challenges. 
  • Employee Turnover: An important metric for understanding employee retention and satisfaction. High turnover can indicate underlying issues in workplace culture or compensation, affecting project continuity and increasing recruitment and training costs. 

Beyond these metrics, firms should also tailor additional KPIs based on their strategic goals and industry specifics. For instance: 

  • Client Satisfaction Scores: Measure the satisfaction levels of your clients through surveys and feedback mechanisms. High satisfaction scores are often indicative of repeat business and client referrals. 
  • Project Completion Rate: Tracks the percentage of projects completed on time and within budget, crucial for maintaining client trust and operational efficiency. 
  • Billable Efficiency: Compares billable hours to total hours worked to assess how much of the workforce’s time is generating revenue. 

By defining these KPIs, firms can not only gauge their current performance but also set benchmarks that align with both industry standards and internal aspirations. This holistic view enables leaders to make informed, strategic decisions that drive growth and improve efficiency. 

Step 2: Gather Internal Data 

Once KPIs are defined, the next step is to compile data from your operations. This involves tracking these metrics over a significant period to establish an internal baseline. Utilize your existing ERP, such as Deltek Vantagepoint, to extract historical data, ensuring it’s accurate and comprehensive. 

Step 3: Find External Data for Comparison 

Once you've gathered and analyzed your internal data across selected KPIs, the crucial next step is to seek external benchmarks for meaningful comparison. This process, while challenging, is essential for gaining real insights and is entirely achievable with some diligent effort. 

A straightforward approach might involve hiring a consultant to dive deep into the metrics and performance of your competitors. However, a more cost-effective method is to leverage existing third-party studies and industry reports available online. These resources provide a wealth of comparative data and are often underutilized. 

Take, for example, Deltek's annual performance study specifically tailored for the architecture and engineering sectors. This comprehensive analysis reviews critical KPIs and distinguishes high-performing firms from their peers. Interestingly, recent findings suggest that while overhead and utilization rates are consistent across the board, top performers often share distinctive traits. These include enhanced efficiencies throughout their project lifecycle and a robust set of standardized company practices. 

In addition to industry-specific reports like Deltek's, broader marketing and business studies can also offer valuable insights. For instance, the marketing research firm Hinge regularly publishes analyses on high-growth firms across various professional services industries. These reports not only highlight what successful firms do differently but also challenge common misconceptions, such as the idea that high growth in certain smaller firms is merely an anomaly. 

The key takeaway is that valuable data is out there; you just need to know where to look. By comparing your internal metrics against these rich data sources, you can identify where you stand relative to the industry's best and learn from the strategies that set top performers apart. This process doesn't just measure your current performance—it provides a roadmap for where you need to go to achieve similar success. 

Step 4: Analyze the Data 

With both internal and external data at hand, perform a thorough analysis to identify trends, gaps, and opportunities. Look for patterns where your firm excels or underperforms compared to industry benchmarks. This analysis should go beyond mere numbers; it should help understand the underlying causes of discrepancies and what they mean for your business operations. 

Step 5: Incorporate Benchmarking into Management Practices 

Effective benchmarking should be an ongoing process, not a one-time event. Integrate these practices into your regular management routines. Regularly update your benchmarks and internal assessments to keep them relevant. Use benchmarking insights to set realistic performance goals, inform strategic decisions, and drive continuous improvement across your organization. 

Harnessing Benchmarking for Strategic Advantage 

Benchmarking transcends being merely a tool for measuring success; it is a comprehensive strategy that cultivates a culture of continuous improvement and strategic agility. For leaders of project-based firms, embedding benchmarking into daily business operations is crucial for illuminating the pathway to enhanced performance and enduring growth. 

By adopting benchmarking, your firm not only aligns with industry standards but also positions itself to proactively respond to evolving market conditions and capitalize on emerging opportunities. In a business landscape that is constantly changing, the firms that will flourish are those committed to measuring, comparing, and adapting based on solid data. 

To further explore how benchmarking can be seamlessly integrated into your strategic planning, I invite you to learn more about our Navigational Analysis Process. This tailored approach will guide you through identifying, analyzing, and leveraging critical data to not just meet but exceed industry benchmarks, ensuring your firm's competitive edge. Let's navigate your path to success together—click the image below to begin your journey. 

 

 New Call-to-action

Simplifying Project Budgeting in Deltek Vantagepoint: A Comprehensive Overview

Posted by Terri Agnew, CPA on April 18, 2024

04-18-24 Simplifying Project Budgeting in Deltek Vantagepoint - Banner

In today’s world of project management, monitoring project costs incurred & projected, as well as forecasting project profitability, are crucial for the success of any project. Deltek Vantagepoint, a leading project management software, offers a robust solution for this by integrating contract management, project budgeting, and project planning tools. This article provides a comprehensive overview to help project managers and consultants effectively leverage this robust project management tool.

Contract Management, Project Budget, and Planning Integration

Deltek Vantagepoint stands out by allowing users to view and manage contract values, budget, and planning information simultaneously. This seamless integration is visible in the Project Review form, where important data such as contractual fees, budgeted estimated costs at completion (EAC), planned costs (ETC), and projected profits are displayed comprehensively. Users can drill down to the details in the work breakdown structure (WBS), allowing budget management from a high-level overview or down to any of the specific phases or tasks.

04-18-24 - 01 Screenshot

Detailed Budgeting Process

The project budget tool in Deltek Vantagepoint enables detailed budget entries at the lowest WBS levels, facilitating accurate labor, expense, and consultant budgeting. This granularity ensures that every aspect of a project, from concept design to completion, is budgeted for. Users can switch between cost and billing views for reporting, accommodating different project management needs. Budgets are entered at the labor code level for labor hours. For expenses, budgets are entered into GL accounts for the expense and can be detailed out to the vendor, such as a subconsultant.

04-18-24  - 02 Screenshot

04-18-24  - 03 Screenshot

Planning Tool and Baseline Budgets

Vantagepoint's project planning tool allows for establishing baseline plans reflective of the original contract. Project managers can update estimates to complete (ETC) based on real-time project developments, such as changes to the schedule, staff availability, and scope changes, ensuring that the resource plan reflects current project realities. This dynamic approach to project management allows for timely adjustments and re-forecasting, essential for maintaining project profitability.

04-18-24  - 04 Screenshot

Analyzing Project Performance

The integration of budget and planning tools within the Project Review view facilitates a comprehensive analysis of project performance. At the bottom of the Project Review form, there are several key performance indicators (KPIs) such as effective multiplier, % expended, % earned, and profit margins which are automatically updated based on the latest budget and planning data. This real-time feedback enables project managers to identify deviations from the budget early and take corrective actions, such as requesting additional services or revising estimates.

Comprehensive Project Overview

By returning to the project review screen, users can evaluate the overall financial health, including profit margins, effective multipliers, % expended, % earned, and overhead. The system provides insights into how actual spending and planning adjustments impact project profitability, offering a complete picture of the project's financial status. This holistic view and real-time feedback enable project managers to identify deviations from the budget early and take corrective actions quickly to avoid major budget overruns, ensuring the project remains on track financially.

04-18-24  - 05 Screenshot

 

04-18-24  - 06 Screenshot

Mastering Project Finances with Deltek Vantagepoint

Vantagepoint offers a powerful suite of tools for simplifying project budgeting and planning. By integrating these processes, project managers can maintain tight control over budgets, adjust plans in real-time, assist in decision-making, and ensure project success. For project managers and consultants looking to optimize their budgeting and planning processes, Deltek Vantagepoint provides a comprehensive solution. Click the image below to see how these tools are used effectively to manage project finances efficiently in a 15-minute demo.

New call-to-action

Understanding the Impact of the Organizational and Work Breakdown Structures in Deltek Vantagepoint

Posted by Jenny Labranche on April 11, 2024

05-25-23 Organizational Structures_banner

Welcome to the matrix, you have the power to build a solid structure and allow your data to flow.  However, it is beneficial for one to understand the difference between Work Breakdown Structure (WBS) and Organizational Breakdown Structure (OBS) before you lay that foundation. During both the implementation of Deltek Vantagepoint and throughout a firm’s growth, professional services firms should understand the connection between the Organizational Breakdown Structure and the Work Breakdown Structure.  

A typical first step is to consider whether the firm needs to re-organize these structures. Whether it be the uniqueness of each, or the relationship between the two, the attention paid to these early stages of development is instrumental to the flow and reporting of information in your Deltek Vantagepoint database. In the following, we’ll explore some areas to consider when designing these structures in your database.  

Organizational Breakdown Structure (OBS)

When it comes to designing the Organizational Breakdown Structure (OBS) in Deltek Vantagepoint, it's important to consider the specific needs of your professional services firm. The OBS can range from simple to complex, depending on the size and requirements of your organization. Here are some examples of different OBS approaches.  

  • Location Approach: With this approach, the OBS is organized based on the physical locations of your offices or project sites. Each location represents a hierarchical level in the structure, allowing you to track and manage projects and resources across different geographic areas.  
  • Discipline/Department Approach: In the discipline or department approach, the OBS is structured around different functional areas or departments within your organization. This allows for efficient resource allocation, project assignment, and collaboration within specific areas of expertise.  
  • Market Sector or Business Development Driven: This approach focuses on organizing the OBS according to your firm's market sectors or business development strategies. Each market sector or business development unit can be assigned a hierarchical level, enabling you to analyze performance and profitability based on these segments.  

Deltek Vantagepoint provides flexibility in designing your OBS, offering up to five hierarchical levels to accommodate your specific requirements. It also allows for the allocation of overhead requirements within the structure of the database. If you plan to utilize the multi-company functionality in your database, it's important to reserve level one for different companies within your enterprise.   

Financial accountability is a crucial aspect of any professional services organization. When building your OBS, it's essential to consider the financial implications. For example, if you use a two-level OBS structure, such as office and department, each combination will generate an income statement. This means that someone within your organization should be responsible for reviewing and managing these statements.  

Deltek Vantagepoint also enables the extraction of various cross-sections for combined financial reporting. For instance, if you have a mechanical department in three offices, you can create a mechanical income statement that provides accountability at different levels:  

  • Office Accountability: You can track the financial performance of each individual office separately, gaining insights into the profitability and expenses associated with specific locations.  
  • Office/Department Accountability: This level of accountability allows you to analyze the financial performance of different departments within each office. It helps in evaluating the contribution of each department to overall profitability.  
  • Overall Department Accountability: By consolidating the financial data of the mechanical department across all offices, you can assess the department's overall performance and make informed decisions regarding resource allocation and strategic planning.  

The OBS in Deltek Vantagepoint offers the flexibility to design a structure that aligns with your professional services firm's needs. By carefully considering the OBS approach, financial accountability, and the ability to generate cross-sectional reports, you can effectively manage projects, resources, and profitability within your organization.  

Projects and the Work Breakdown Structure (WBS)

The Work Breakdown Structure (WBS) is a critical component that determines how a project is organized and how revenue and costs flow within a professional services firm. Most firms find it effective to build their WBS based on project budgets, aligning with the fee and scope defined in the client contract using a bottom-up approach. The best practice is to build your WBS to mirror your contract for smooth management of resources, budgets, and billing.    

Deltek Vantagepoint provides the flexibility to define up to three levels in the WBS, commonly referred to as Project, Phase, and Task. However, these labels can be customized to match your firm's preferences. Furthermore, the WBS allows for the assignment of accountability within a project. You can designate a project manager, as well as phase and task managers, based on their scope and budget responsibilities.  

It's important to note that project builds and WBS structures do not have to be identical across all projects. While each professional services firm may have its own unique requirements, it is generally recommended to have at least one WBS level 2 for every project, indicating another variation in the WBS. Additionally, projects can be built with no WBS level 3 or only certain portions of the WBS level 2 extending into the WBS level 3.  

The OBS and WBS structures function both individually and in tandem to support overall financial and operational accountability within your organization. At the lowest level, the WBS drives how revenue and costs are allocated within the OBS. Here are some additional factors to consider when working with the OBS and WBS structures:  

  • "Mirroring" the OBS in WBS for Overhead Projects: For projects involving overhead costs, it can be beneficial to mirror the OBS structure within the WBS. This helps ensure that the appropriate overhead costs are accurately assigned to specific projects, allowing for better cost tracking and financial reporting.  
  • Combinations of Cross-Charge, Intercompany Billing, and High Accountability in WBS: Consider how cross-charges, intercompany billing, and high levels of accountability will be incorporated into your WBS. Deltek Vantagepoint offers capabilities to support these requirements, allowing you to accurately allocate costs between different departments, offices, or business units within your professional services firm.  

By carefully considering these aspects of the OBS and WBS structures, you can establish a robust framework for financial and operational accountability within your professional services organization. Deltek Vantagepoint empowers you to customize and tailor the OBS and WBS to meet your firm's specific needs, ensuring accurate project tracking, cost allocation, and financial reporting.  

Is it Time to Update Your OBS and WBS Structures? 

In the ever-evolving landscape of professional services firms, it's crucial to regularly assess and update your Organizational Breakdown Structure (OBS) and Work Breakdown Structure (WBS) in Deltek Vantagepoint. As your business needs change and evolve, it becomes imperative to optimize your system to ensure it aligns with your current requirements. This is where Full Sail Partners can help. There is no one size fits all, and with the guidance of our consultants, we can help you develop a solution.   
 
By combining project attributes, you can create a powerful framework that enables efficient project management, resource allocation, and financial reporting. However, implementing such changes requires expertise and guidance from both functional and data consultants to ensure a smooth transition. We specialize in Deltek Vantagepoint consulting services, including OBS and WBS optimization.  

Our experienced consultants can work closely with your team to analyze your current structures, identify areas for improvement, and design a new and more productive system tailored to your unique needs. Timing and cutover planning are critical to the success of any system update. Our consultants will guide you through the entire process, ensuring that the implementation is seamless, minimizing disruption to your operations, and maximizing the benefits of the new OBS and WBS structures.  
 
Now is the perfect time to get creative and strive to get the most out of your Deltek Vantagepoint system. Don't let outdated structures hold your firm back. Explore the possibilities of a Navigational Analysis and let us help you unlock the full potential of Deltek Vantagepoint and drive efficiency, profitability, and growth within your organization. Learn more about how a Navigational Analysis can help your firm by clicking the image below.  

New Call-to-action

When to Consider Utilizing Revenue Generation in Deltek Vantagepoint

Posted by Terri Agnew, CPA on February 22, 2024

02-22-24 - Revenue Generation - Banner

Revenue Generation is a feature in Deltek Vantagepoint that allows a professional services firm to define how a project should calculate revenue. This process is not turned on “out of the box” as firms can choose if and how they would like to utilize this feature. Vantagepoint’s default revenue method is “B,” meaning revenue is recognized only when a project is billed. Although this method works well for projects invoiced monthly for time & materials incurred, it doesn’t always align with all project types.

Additionally, utilizing the “B” method can restrict a firm from invoicing throughout the month as generally all costs should be posted and then invoiced to properly match revenue and expenses. Billing all at the end of the month can create a backlog and delay month-end closing processes. Therefore, if your projects are not billed monthly, the billing doesn’t match how the project should recognize revenue, or you don’t want to hold up your close process until all invoicing is completed, your firm should consider utilizing Revenue Generation.

Pursue Revenue Generation Methods

After deciding that revenue generation is right for your professional services firm, the next step is to decide on the revenue method(s) to be utilized for your projects. Revenue generation is flexible in the fact that methods can be different on different levels of a project’s work breakdown structure. Furthermore, your firm can create custom revenue methods if you feel one of Deltek Vantagepoint’s predefined methods doesn’t suit your needs.

Deltek Vantagepoint’s Standard Predefined Methods

The three most popular predefined methods are the Work In Progress (W), the Percent Complete Method (P), and the Multiplier (M) methods. See below the formulas and a brief discussion of when firms may choose to utilize these methods.

Work in Progress Method (W)

Job-to-Date Revenue = Job-to-Date Billings + Work-in-Progress @ Billing

Deltek Vantagepoint recognizes revenue as job-to-date billed plus work-in-progress at billing rates. This method works well for projects normally termed “hourly” or “time and materials.” One of the great features of this method is you can invoice anytime during the month and expenses posted after the invoice will still be recognized for that month and this method will match revenue and expenses. One disadvantage of this method is the formula has no limit set so if your project is “hourly to a max,” this method will not stop at the “max.”

Percent Complete Method (P)

Job-to-Date Revenue = (Percent Complete*Fee) + Job-to-Date Reimbursable Expenses

This method recognizes revenue based on a percent complete entered on the project times the compensation on the project, plus reimbursable expenses. This method does require the percent complete field to be entered, usually at the lowest level of the project where the revenue is to be recognized. The good news is there are several places to update this field – in Dashboards, in the Revenue Generation action bar, and the Project Review area. The bad news is that it does require updates regularly.

In general, this method works well when projects have milestone billings, often called “lump sum contracts” or “fixed fee” projects. On these types of projects, you may have a billing schedule that does not match your level of effort in a month. For example, if your milestones state that you can’t invoice until you have hit 25% complete, but this month you have completed 15%, you may want to recognize 15% now and not wait until you hit 25%. In this case, the percent complete field would need to be entered as 15%. In summary, this method produces revenue based on the percent completed, not invoiced, but that percent does need to be entered into the system with some “manual intervention.”

Multiplier Method (M)

Job-to-Date Revenue = (Job-to-Date Direct Labor x Multiplier) + Job-to-Date Reimbursable Expenses

The Multiplier Method recognizes revenue based on labor incurred times a multiplier identified on the project in the “Multiplier/Amount” field. This method can be used on projects that are billed hourly or percent completion-based. Usually, when using this method, the multiplier is set once and reviewed periodically but does not need to be updated as frequently as the P method. The pro of this method is that it requires less maintenance than the P method, but the con is that it may not be as accurate. The multiplier is project-specific, which allows flexibility.

User Defined Revenue Methods

If the above methods don’t meet your professional services firm’s needs, Deltek Vantagepoint has the flexibility to create as many revenue methods as needed.

For example, if you would like to use an hourly method, like W, but would like to add a maximum amount to the calculation, there is a “Subject to Max” option that can be utilized in a formula. Likewise, if you would like to compare two formulas and have the system recognize revenue based on the “lessor of” the two calculations, that is also an option. There are many fields available to create a User Defined Calculation from project fields such as budget or compensation fields, from billing terms such as rates or Add-Ons, or even from User Defined Fields on a project.

Choosing the Best Revenue Generation Method(s) for Your Professional Services Firm

As you consider the possibilities of revenue generation within Deltek Vantagepoint, it's crucial to refine your approach to ensure it aligns with your firm's unique project management and financial tracking needs. The flexibility offered by Vantagepoint enables a tailored revenue recognition process that can significantly enhance your financial accuracy and project oversight. To effectively implement and benefit from this feature, consider the following:

  • Assess Project Requirements: Evaluate the specific needs of each project or project phase to select the most appropriate revenue generation method. This assessment should consider the billing schedule, project duration, and the nature of the work (e.g., hourly, fixed fee, or a combination).
  • Implement a Hybrid Approach: Don’t hesitate to employ multiple revenue generation methods within a single project where necessary. This flexibility can accommodate diverse billing arrangements and project work phases, ensuring revenue is recognized in the most accurate manner across your portfolio.
  • Create Your Own Calculations: Leverage the capability to create custom revenue calculations to address any specific challenges or goals your firm has. This customization can help in situations where predefined methods fall short, ensuring your revenue recognition practices precisely match your operational and financial strategies.
  • Document and Standardize: Establish clear documentation of your chosen revenue recognition methods and the rationale behind them. This documentation will serve as a valuable reference for your team and ensure consistency in application across projects.
  • Engage in Thorough Testing: Before fully integrating a new revenue generation method into your operations, conduct comprehensive testing. This testing should simulate various project scenarios to uncover any potential issues and ensure the method performs as expected under different conditions.
  • Review and Refine Regularly: Adopt an iterative approach to your revenue generation strategies. Regular reviews allow you to adjust methods as your firm evolves and as projects present new challenges or opportunities for financial management optimization.

By thoughtfully selecting and applying revenue generation methods, your professional services firm can achieve a higher level of financial clarity and project management efficiency. Deltek Vantagepoint’s flexibility not only accommodates a wide range of project types but also empowers your firm to adapt and thrive in the dynamic professional services landscape. Embrace the opportunity to fine-tune your revenue recognition processes, ensuring they fully support your firm's strategic goals and project delivery success.

Strategize and Optimize: Revenue Solutions in Deltek

Maximize your Deltek Vantagepoint's Revenue Generation capabilities with Full Sail Partners' Navigational Analysis. Our service streamlines your processes, ensuring your ERP system aligns perfectly with your business objectives. From an initial assessment to a customized action plan, we guide your firm through optimizing system functionality to enhance operational efficiency and financial performance. Elevate your firm's potential—discover how our Navigational Analysis can transform your Deltek setup for optimal success by clicking the image below.

 New Call-to-action

Improve Project Planning with Deltek Vantagepoint

Posted by Rana Blair on February 08, 2024

02-08-24 Improve Project Planning with DVP-Banner

For professional services firms, having a reliable project planning tool is critical to ensuring projects are profitable. In a competitive landscape, successful project execution hinges on the effectiveness of project planning, driving the need for firms to invest in tools that not only meet but exceed expectations. Therefore, a project planning tool needs to be intuitive for users and must improve project scheduling and resource planning.

With Deltek Vantagepoint, project planning has been taken to the next level with a focus on the features and functionality that project managers need. This advanced tool is carefully crafted to specifically cater to the distinct needs of project managers, making sure it not only meets, but also anticipates their requirements. Here are some key features of Vantagepoint that will assist project managers with delivering successful and profitable projects.

Start Early with Templates

Getting a project off to a good start needs a bit of an early boost. Luckily, Deltek Vantagepoint helps out by offering practical ways to help plan things out early. Here’s what you need to know to get a head start.

  • Successful Delivery: This starts long before contracts are signed so consider creating the plan when the project is first entered in a Pursuit Stage. Vantagepoint offers a variety of methods that can be used to efficiently create a preliminary plan.
  • Project Templates: Firms can create multiple templates for use in creating new project records or when adding structure to a project. Using Project Templates allows users to quickly add the phases of work that are typical for the projects.
  • Projects Used as Templates: Firms can create Project records that can serve as templates for creating new records. These records can hold typical Work Breakdown Structure (WBS) elements like Project Templates but can do much more. The records can serve as a plan template that will allow the user to instantly create a plan with Schedule Durations, Generic Resources, and Planned Hours.

Aside from the ease of creating a project plan, planning the project in advance allows professional services firms to proactively manage pricing and resourcing.

Keep the Schedule Updated

Keeping the project schedule updated is a pivotal aspect of effective project management, and Deltek Vantagepoint equips users with powerful tools for this purpose. The plan Gantt charts are a great tool for managing the dates in a plan. The Schedule Tab allows planners to visually manage dates, durations, and dependencies for project delivery phases. Users can also adjust the project schedule from any level of the project by simply dragging and dropping the timeline bars and reviewing the Critical Path on demand, ensuring a clear understanding of key project dependencies.

Beyond the convenience of schedule management, the real-world impact of keeping the schedule updated becomes evident in staffing discussions. Maintaining an accurate and current schedule is a crucial reference point for conversations surrounding short- and long-term staffing availability. By staying on top of the schedule, project managers can better address staffing needs, optimize resource allocation, and enhance overall project efficiency.

Anticipate Resource Usage Curve

The keystone of true resource planning is predicting resource demands as they will likely occur. All project delivery phases have a ‘curve’ that should be reflected in the resource plan. Deltek Vantagepoint’s Project Planning allows users to plan the hours differently in specific time frames. With the Distribute Hours feature, users can take a more precise approach to planning resource hours over specific date ranges by using hours or percentages per day.

This level of granularity in resource planning is not just about meeting requirements; it's a strategic move to decrease the chance of resource clashes. Understanding the intensity of resource usage during different phases of a project becomes a proactive measure to minimize conflicts and optimize resource allocation. By anticipating resource usage, project managers can navigate the intricacies of resource planning with precision, ensuring easy and efficient workflows that align with project objectives.

Review Performance Against the Baseline

The Baseline serves as the bedrock, outlining the assumptions upon which the scope, schedule, and budget of the entire plan are built. Saving the Baseline at the right time allows users to review the deviations and project the final outcomes.

Deltek Vantagepoint not only facilitates this review but also enhances it by allowing users to compare Baseline values with Estimate at Completion (EAC) values. This comparative analysis can be conducted seamlessly across various platforms, including the Plan, Dashboards, and the Project Review feature. This multi-faceted approach to reviewing performance against the Baseline ensures a complete understanding of how the project is progressing in relation to its initial assumptions.

Take Control of Your Project with Deltek Vantagepoint 

Deltek Vantagepoint Planning and Resource Management allows professional services firms to collaborate and analyze project performance from the pursuit through closeout. Maintaining the plan throughout the life of the project improves financial performance and enhances communication around schedules and resource needs. Furthermore, by using this advanced tool, project managers can proactively minimize resource clashes by anticipating resource usage and ensuring project objectives are met. Take control of your projects today!

New call-to-action

What is the Difference Between Project Backlog and Project Forecasting?

Posted by Scott Seal on December 07, 2023

12-06-23 Backlog and Forecasting_BannerIf you're neck-deep in the world of professional services consulting, you know that staying on top of your financial game isn't just about counting beans; it's about smart planning and even smarter execution. That's where getting cozy with project backlog and project forecasting comes into play. They're like the dynamic duo of the project management world, and if you're in charge of the purse strings or the big decisions at your professional services firm, you'll want to give these two the attention they deserve.

So first off, let’s break each of them down:

  • Project Backlog: This is your bread and butter—it's all the work you've already won but haven't done yet. Think of it as your safety net; it's work that you can bank on in the short term. And it's a gold star for your marketing or business development team, too, because it means they've been doing something right. But here's the kicker: it's not just about having a backlog; it's what you do with it. Manage it well, and you're looking at a smooth road to profit town. Mismanage it, and well, it's a bumpy ride.
  • Project Forecasting: Forecasting, on the other hand, is your crystal ball. It's a bit more elusive, a cocktail of educated guesses and wishful thinking. The business development and marketing folks have their ear on the ground, listening for the rumble of potential projects. They're not sure bets like your backlog, but with a savvy mix of hope and pragmatism, they plot out what could be coming down the pipeline.

Now, when you put backlog and forecasting together, you get a killer combo that gives you the full picture: cash flow in the immediate future and what your workload might look like down the line.

Leveraging Project Backlog and Project Forecasting for Optimal Performance

Mastering your backlog and forecasting is crucial for various roles within your professional services firm:

  • For Project Managers: Clear visibility into the project backlog means you can allocate resources effectively, prevent scheduling conflicts, and maintain optimal workflow. Deltek Vantagepoint, for instance, can provide the granular insight you need to ensure that projects are adequately staffed and that timelines are met, minimizing the risk of underutilization or bottlenecks.
  • For Business Developers: Your backlog is your success story in numbers—it's proof of performance that you can showcase to potential clients. Knowing what's in the pipeline helps you strategize new business pitches and align offerings with market demand. When it comes to forecasting, having a robust prediction tool allows you to prioritize pursuits based on the likelihood of project acquisition and future revenue potential. Deltek Vantagepoint's pipeline management tools ensure you're targeting the right opportunities at the right time.
  • For Marketing Teams: Backlog data informs you when to double down on lead generation efforts or refine targeting strategies. It's a barometer for market engagement, guiding you on when to accelerate awareness campaigns or capitalize on high demand. With Vantagepoint Marketing Campaigns, you can gauge campaign impacts on your forecast and backlog, enabling data-driven marketing decisions.
  • For Financial Controllers: Backlog and forecast reports are not just numbers; they're predictors of your firm's financial health. They validate if revenue projections are on track and highlight discrepancies that need attention. The accurate and detailed reports from Deltek Vantagepoint can assist in adjusting financial strategies, whether it’s scaling operations or tightening budget controls.

By integrating tools like Deltek Vantagepoint to manage backlog and forecast, every role from project management to business development can benefit from increased visibility, better decision-making capabilities, and a stronger strategy for sustainable growth.

How to Implement a Backlog and Forecast Strategy

It is not complicated. The project backlog and project forecasting process needs only to provide a standard tool for company-wide project planning and review. Use the following three steps to initiate a project backlog and project forecasting process.

Step 1: Begin with a Detailed ‘Bottom-up’ Forecast

Project managers, your weekly routine should include a thorough review of your project backlog. Prioritize the projects with more than a 60% likelihood of commencement. Allocate your team members, estimate the required hours, and plan out the next eight weeks. It’s a practical exercise in resource allocation and workload management.

The benefits?

  • You'll balance team capacity against project demands, considering downtime for vacations or training.
  • You’ll monitor project progress and ensure you're on track with milestones.
  • You’ll forecast potential revenue by aligning upcoming work hours with billing rates.

Step 2: Consolidate Insights at a Management Level

Once project managers provide their data, it's time for leadership to analyze it. This aggregation step allows for spotting trends, potential resource sharing, future revenue projections, and early detection of budgetary issues or hiring needs.

Step 3: Validate Your Forecast

Compare your projected outcomes with the actual data. This step verifies the accuracy of your forecasting and provides a basis for adjustment and improvement.

With Deltek Vantagepoint, you can streamline these processes, enabling your leadership, project management, finance, business development, and/or marketing teams to detect trends, identify efficiency opportunities, and enhance decision-making with data-driven dashboards.

This approach is about more than just numbers; it's about using data to tell the story of your professional services firm’s trajectory, making informed decisions, and navigating your firm's path forward with confidence. Let’s get started on making backlog and forecasting integral parts of your strategic toolkit.

Ready to Navigate Your Firm's Future with Clarity?

Chart a course for success with Full Sail Partners. Our expertise in working with professional services firms and Deltek Vantagepoint positions your firm to master both project backlog and forecasting, transforming data into actionable insights. Connect with us to see how we can help you optimize your operations and elevate your project management strategy.

New Call-to-action

Project Management Trends from the 44th Annual Deltek A&E Clarity Study

Posted by Evan Creech-Pritchett on October 05, 2023

10-05-23 Deltek Clarity Recap-PM Trends_Banner2

Full Sail Partners has been closely following the annual Deltek Clarity Architecture and Engineering Industry Study, and in our previous blogs, we've delved into various aspects of this comprehensive report. As we continue our exploration of this year's 44th Annual Deltek Clarity study, we shift our focus to the critical realm of project management within the architecture and engineering (A&E) industry. This sector struggles with numerous challenges daily, and the study offers valuable insights into the current trends and issues affecting project managers. In this blog, we will dissect key findings from the study, particularly homing in on project management challenges and the strategic initiatives poised to address them. 

Project Management Challenges 

In the ever-evolving realm of architecture and engineering, project management is the linchpin of success. However, it's not without its formidable challenges. In this section, we'll delve into these critical challenges, from gaining better visibility into KPIs to grappling with staffing shortages. Furthermore, we will discuss strategies for overcoming them to achieve project management excellence. 

Visibility into Project Management KPIs: Project managers grapple with obtaining clear insights into key performance indicators (KPIs) and the tools required to manage them effectively. This issue affects project performance and client satisfaction. 

Projects on or Ahead of Schedule: 59.76% of projects are on track for schedule and budget. Despite this, staffing challenges continue to persist and impact project outcomes. 

Competing Priorities: A&E firms with well-defined roles, responsibilities, and efficient tools are better equipped to manage project resources. Quality control hubs, such as Centers of Excellence (CoEs) and Project Management Offices (PMOs), are instrumental in driving best practices. 

Staff Shortages: The industry continues to struggle with hiring and retaining skilled staff, with 62% of firms identifying it in their top 3 concerns. Offering tools, training, and attractive work cultures can help attract and retain next-generation project managers. 

Project Management Solutions 

Navigating the intricate landscape of project management in the architecture and engineering industry demands not just an understanding of the challenges but also the strategies to overcome them. In this section, we'll explore proactive solutions that address the industry's top project management challenges. From upskilling and training to streamline project management to harnessing collaborative platforms for improved effectiveness, and investing in technology for seamless connectivity, we'll unravel the keys to project management success.  

Addressing Top Project Management Challenges: To overcome these challenges, A&E firms are reducing their reliance on new project manager hires. Instead, they are focusing on upskilling, training, promotion, and formal career development planning to maintain productivity and deliverable quality. 

Project Management Effectiveness: Staffing issues, strong pipelines, and backlogs combined with increased staffing costs and skill gaps can hinder project management effectiveness. Collaborative platforms and regular training can help bridge these gaps. 

Connecting Teams and Using Systems: A common challenge is connecting all relevant teams on the same platform and ensuring employees use these systems correctly. This requires investment in technology and proper training. 

Project Management KPIs 

Effective project management necessitates careful planning and monitoring through various KPIs. While financial KPIs such as net revenue, profitability, and multipliers are well-tracked, there's room for improvement in non-financial KPIs like client satisfaction, schedule variance, and earned value.  

Balancing Financial and Non-Financial KPIs: Top financial KPIs like net revenue, profitability, and multipliers continue to be tracked by most firms at 94%, 93% and 83% respectively. However, firms showed less reliance this year on the non-financial KPIs like client satisfaction and earned value, at only 36% and 18% of firms tracking these statistics. Achieving a balance between financial and non-financial KPIs is essential for successful project management. Focusing solely on financial metrics can lead to oversight of critical project aspects. 

Project Reporting Accuracy: While A&E firms are gaining confidence in reporting project costs accurately, there's still room for improvement in reporting project schedules. Accurate schedule reporting is crucial for project success. 

Project Management Initiatives 

As the architecture and engineering industry continues to evolve, it's imperative to not only identify challenges but also to proactively address them through strategic initiatives. In this section, we will explore how A&E firms are taking forward-looking steps to enhance project management. These initiatives encompass investing in internal project management expertise, defining roles more clearly, and harnessing the power of technology and software tools to pave the way for a more efficient future in project management.  

Investing in Internal Project Management: A key priority for A&E firms is investing in internal project management, replacing the focus on hiring more qualified staff. Developing best practices and clearly defining roles for project management are also top priorities. 

Leveraging Technology: While technology can provide substantial support in project management, only a small percentage of firms are prioritizing investments in better software tools. Maximizing the value of existing tools and technology is crucial. 

Facing Challenges with Project Management Head on  

The A&E industry faces ongoing challenges in project management, including visibility into KPIs, staffing shortages, and maintaining project schedules and budgets. However, A&E firms are proactively addressing these challenges by investing in training, upskilling, and improved project management processes. Balancing financial and non-financial KPIs, accurate reporting, and leveraging technology will be essential for future success in the industry. By nurturing a culture of continuous improvement and transparency, A&E firms can enhance project management effectiveness and, ultimately, client satisfaction. 

New call-to-action

 

The How-To Guide for Understanding Capacity Calculations in Deltek Vantagepoint Resource Management

Posted by Terri Agnew, CPA on September 28, 2023

9-28-23_ResourceMgmt Views - Banner

Using the Resource View in Deltek Vantagepoint is a quick and easy tool for project-based firms to determine which employees are properly scheduled or utilized, and/or those who may not have enough or too many hours planned. This view has a lot of valuable information on one screen and can sometimes seem a bit overwhelming. So, the content provided here in this blog, which is utilized with Resource Planning licensing, will assist you with the questions like “What do the blue/red/grey colors mean?” or “How is the utilization % calculated” and help make this form one of the most important tools in your firm’s resource management toolbox.  

Three Show Capacity Views 

There are three different options to monitor your resources: Planned Hours, Scheduled %, and Utilization %. Below you will find illustrations showing how these three views are calculated for you to better understand the information Resource View is displaying. 

Planned Hours 

Planned Hours is the simplest of the calculations as it is what it says it is – all planned hours! Use this view to simply check each selected resource's total planned hours for the time period shown in the Forecast Range. Planned hours will be shown for all published plans for ALL types of projects – overhead, promotional, and regular projects. Planned hours will show even if the project is showing a capacity calculation of excluded from scheduled and utilized % on the project’s summary pane. 

ResourceMgmt_01

Scheduled %

When you change the view from Planned Hours to Scheduled %, you will notice the “heat map” will appear. This “heat map” is used to visually draw a user’s attention to which resources are properly scheduled (grey), under scheduled (blue), or over scheduled (red) based on the firm’s chosen thresholds (Settings > Resource Planning > Resource Settings). 

ResourceMgmt_02

The Scheduled % is a calculation of Planned Hours divided by Available Hours for the resource. This view is great to use to get an understanding of if a resource is too busy (red) or has availability to be assigned to more projects (blue) or if they are appropriately scheduled during the timeframe (grey). 

  • Planned Hours - this calculation will include all types of projects (regular, promotional, & overhead). However, if a project shows as “Excluded from Scheduled and Utilization” on the Project’s Summary tab, those planned hours will not be used in this calculation. Note that excluded hours will still show the hours when the details are expanded for the resource. 
  • Available Hours - these are calculated using the employee’s standard hours from their employee hub, less any non-workdays as indicated in Settings > Resource Planning > non-Workdays. 

In the example shown below, I will break down the calculation for the week of 9/4 – 9/10 where Amy Allen is showing over scheduled at 138%. 

Planned Hours / Available Hours = Scheduled %      =     44 / 32 = 138% 

Planned Hours = 59 total hours planned less 15 hours for Greenhouse Café Remodel as that project is currently set to “Exclude from Scheduled and Utilization” in the project. The numerator is 59 -15 = 44 hours. 

*Note when you click on the blue link of each project, a small summary box for the project will appear where you can easily see if a project is “included” or “excluded” from Scheduled and Utilization. 

ResourceMgmt_03

Available Hours – Amy Allen’s standard hours are set as 8 hours per day in her employee hub, which is typical for a full-time 40-hour/week employee. The week of 9/4 – 9/10 contains a Labor Day Holiday in the company’s non-workday settings. As discussed earlier, holiday hours are excluded from available hours. Therefore, the denominator is 40 – 8 = 32.  

 *Note that when you click on a resource’s name, the Employee Card will appear. On that employee card, you will find the Hours/Day in the bottom right of the Profile Tab. 

Now, the shading!  What is this heat map telling you?   

Understandably, being scheduled at 138% would seem to be over scheduled just because it is a relatively large number, but the system is compared to the firm’s Resource Planning Settings. In my demo database shown here, the blue shading indicates under scheduled as under 90%, and the red shading for over schedule when over 105%. Grey is “just right” of 90 – 105%, which this firm has indicated as appropriately scheduled.    

In summary, in my database, a full-time, 40-hour/week employee would show as properly scheduled (grey) if the scheduled hours are between 36 (90% x 40) and 42 hours, under-scheduled would be less than 36 hours (blue) and over scheduled as over 42 hours (red). 

Utilization %

The Utilization % will show the percentage of the planned hours for billable projects (regular/won projects) and those In Pursuit projects marked as “included in scheduled and utilization”. Use this view to show how an employee is tracking against their Target Utilization. Even if an employee is well scheduled, in the example above, if several of the projects are either overhead or In Pursuit and not included in scheduled and utilization, the employee may be shown as under-utilized.  

ResourceMgmt_04

Utilization % is a calculation of Total Billable Planned Hours divided by Available Hours (same calculation as above). 

Total Billable Planned Hours only includes regular projects, no promotional projects nor overhead projects. Regular projects will be all those in the Stage Step of Won and any In Pursuit that are “Included in Scheduled & Utilization” Capacity calculations. 

For this example, I will be showing the calculation for the week of 9/11 – 9/17 from the picture above. In this view, I am also showing a few additional columns in the middle grid that help demonstrate if a project is “billable” or not.   

As you can see, I have one project that is a Lead Stage – Greenhouse Café Remodel, and as discussed above, that project is Excluded from Scheduled and Utilization so those hours will not be included in the numerator. Additionally, there is one project that is overhead (no stage listed), which is PTO.   

Total Billable Planned Hours / Available Hours = Utilization %      =     22 / 40 = 55% 

Total Billable Planned Hours = 53 total hours planned less 15 hours for Greenhouse Café Remodel as that project is currently set to “Exclude from Scheduled and Utilization” in the project, less the PTO hours of 16. The numerator is 53 -31 = 22 hours. 

Available Hours (as stated above) are calculated using the employee’s standard hours from the employee hub, less any non-workdays. This week does not have a holiday and this employee’s standard hours are 8 hours/day so the Available Hours = 40. 

Shading for Utilization %: 

To understand the heat map for the Utilization %, the formula considers each employee’s Utilization Target, which is set in the Employee Hub. This employee, Amy Allen, has a Utilization Target of 75%. 

The threshold calculation is the Utilization % divided by the employee’s Utilization Target. 

For the week ending 9/17, Amy’s planned Utilization % is 55% divided by the target of 75% equals 73%. In my demo database shown here, the blue shading will be under-utilized if the utilization % is under 90%, red shading over 105%, and “just right” or grey is between 90 – 105%. Therefore, since Amy’s threshold calculation is 73%, she is showing blue as that is under-utilized in my database. 

Capacity Calculations Made Easy with Resource View 

So, in summary, the Resource View in Deltek Vantagepoint has a lot of valuable information on one screen. You can use it to navigate to three different views to understand (1) how many hours an employee has planned in total (Planned Hours), (2) if the employee is over/under scheduled (Scheduled %), and (3) if the employee is over/under utilized by simply navigating between the three options in “Show Capacity”. Project based firms should be making the most of the resource management tools available within Deltek Vantagepoint! To learn more about this feature and other Resource Management tools, please visit our webinars located here: Webinars for Project Manager Rockstars! 

 

 New call-to-action

Latest Posts