-
The Timesheet Smoothing Process Workflow kicks-off when an individual timesheet is Submitted. It splits each transaction on the timesheet when total timesheet actuals exceed total weekly availability for the resource. Total weekly availability is determined by multiplying resource availability rate by the number of workdays in the week. Non-workdays include weekends, holidays, PTO, and other scheduled days off, as set on the resource calendar. If timesheet actuals <= total weekly availability, then the timesheet remains unchanged. But if timesheet actuals > total weekly availability, then the following occurs. Each timesheet transaction is reduced by a calculated percentage that will reduce the total regular hours to equal the total weekly availability. Then the remaining transaction hours are placed in a “Split” row for that task on that day, with an Input Type Code set based on a process parameter (which parameter can be set within the script action on the process). Note: If a single day has overtime hours, but the total timesheet actuals <= total weekly availability, no splitting occurs. -
The Timesheet Smoothing Process Workflow kicks-off when an individual timesheet is Submitted. It splits each transaction on the timesheet when total timesheet actuals exceed total weekly availability for the resource. Total weekly availability is determined by multiplying resource availability rate by the number of workdays in the week. Non-workdays include weekends, holidays, PTO, and other scheduled days off, as set on the resource calendar. If timesheet actuals <= total weekly availability, then the timesheet remains unchanged. But if timesheet actuals > total weekly availability, then the following occurs. Each timesheet transaction is reduced by a calculated percentage that will reduce the total regular hours to equal the total weekly availability. Then the remaining transaction hours are placed in a “Split” row for that task on that day, with an Input Type Code set based on a process parameter (which parameter can be set within the script action on the process). Note: If a single day has overtime hours, but the total timesheet actuals <= total weekly availability, no splitting occurs.
-
Course description: “Does your organization struggle with resource management? Have you considered creating a Resource Management Office (RMO)? This session will review how some organizations are using RMOs to drive adoption and effectively manage resources, including real world examples of RMO setup and execution.” Download file is the presentation slide deck. -
Course description: “Is there a way to simplify time tracking? Time is a function 90% of companies use. What are ways to have time be less of a burden to users? How can you minimize the negative perception? This session will discuss options within CA PPM or outside CA PPM to make time tracking less of a burden for all.” Download file is the presentation slide deck. -
Allocation Compliance Pie Chart provides the resource manager a single place to view the Allocation compliance information in the form of a Pie chart. Allocation Compliance is calculated based on the value of 'Availability to Allocation Hours %'. Allocation Compliance is 'Under Allocated (Less Than 80%)' WHEN 'Availability to Allocation Hours %’ is less than 80. Allocation Compliance is 'Appropriately Allocated (Between 80-120%)' WHEN 'Availability to Allocation Hours %' is between 80 and 120. Allocation Compliance is 'Over Allocated (Over 120%)' WHEN 'Availability to Allocation Hours %' is greater than 120. User can further narrow their search by Resource Is Active?, OBS Type, OBS Path, Allocation Start Date, Investment Name and Resource Manager. User can use exact dates or relative dates for Allocation Start Date filter parameter. -
Allocation Compliance for PM report gives a view of resource Allocation percentage for active resources on the team of an investment for a selected Investment Manager. It allows the PM to see resources on their project over the coming months and whether they are over or under allocated. Allocation Percentage is calculated as (‘Allocated Hours’ / ‘Available Hours’) * 100. User can further narrow their search Month Start Date and Investment Manager. User can use exact dates or relative dates for Month Start Date filter parameter. -
Resource Availability – 4 Weeks displays all resources with their total allocated hours by week, and an average availability percent (4 Wk Avail %) for next four weeks. This report also displays Resource Primary Role and Employment Type. User can further narrow their search by Resource Name, Resource Type & Week Start Date. User can use exact dates or relative dates for Week Start Date filter parameters. -
Late Tasks with Assignments report displays the list of all Tasks (with their Total ETC Hours) that are not closed but are past their finish date or past their baseline finish date. The report provides Project Manager the ability to view and track late tasks across multiple projects without going into each project individually. This report displays Project Name, Project Manager, Task Name, Task Status, Task Start Date, Task Finish Date, Days Old (Elapsed days between Task Finish Date and Today's Date), Days Late (Elapsed days between Task Finish date and Task Baseline Finish date). User can further narrow their search by Task Name, Task Status, Project ID, Project Name, Project Manager, Is Milestone?, Is late?, Task Start Date, Task Finish Date and Is Template?. User can use exact dates or relative dates for Task Start Date and Task Finish Date filter parameters. -
Allocation Compliance Area Chart provides the resource manager a single place to view the Monthly Resource Allocation compliance for all resources in the form of an Area chart. Allocation Compliance is calculated based on the value of 'Availability to Allocation Hours %' Allocation Compliance is 'Under Allocated (Less Than 80%)' WHEN 'Availability to Allocation Hours %’ is less than 80 Allocation Compliance is 'Appropriately Allocated (Between 80-120%)' WHEN 'Availability to Allocation Hours %' is between 80 and 120 Allocation Compliance is 'Over Allocated (Over 120%)' WHEN 'Availability to Allocation Hours %' is greater than 120 User can further narrow their search by Resource Is Active?, OBS Type, OBS Path and Month Start Date. User can use exact dates or relative dates for Month Start Date filter parameter. -
Assignments by Task Over Time report display all assignments by task for all resources. Information can be drilled down to yearly, quarterly or monthly level. This report helps in determining the tasks a user is assigned to or how many hours a user is assigned to a task. You can further narrow your search by OBS Type & Path, Project ID, Project Name, Task Name, Assignment Resource, Is project Active?, Is Template? And Month End date. -
Capacity Graph report provides the Resource Managers & PMO a single place to view Monthly Availability, Allocations, Actuals and Assignments for one or more active resources. Information is displayed in the form of a line chart. Legend displays the color associated with each metric. Mouse over the line chart displays hours associated with that corresponding metric. This report provides Managers a simple means to analyze: Allocations vs. Availability, Allocations vs. Actuals, Allocations vs. ETC and ETC vs. Availability and helps in determining the areas of improvement. User can further narrow their search by OBS Type & Path, Month Start Date, Resource Name, Resource Manager, Primary Role & Employment Type. -
All Assignments report provides the Managers a single place to view all the assignments associated with a project(s). User can view only the investments that he has access to. This report also displays ETC, Actuals, Total Effort, Days Old (Elapsed days between Task Finish Date and Today's Date), Days Late (Elapsed days between Task Finish date and Task Baseline Finish date) associated with the task. You can further narrow your search by OBS Type & Path, Resource Name , Project Manager, Project Name, Project ID, Is project Active?, Assignment Start Date, Assignment Finish Date, Assignment Status and Task Status. -
Project Manager- Resource/Compliance report provides project managers a single place to view Compliance status for various critical KPIs. All the KPIs are depicted in various visualizations.- Unfilled Demand: Donut chart that gives you the count of roles (within projects) that are not filled by resources.
- # Of New team members: Scorecard that displays the count of new team members added to the projects.
- Resource Constraints: Donut chart that gives you the count of Over utilized and underutilized resources
- Unsubmitted Time: Dial gauge that displays the count of resources that did not submit time.
- Stale Tasks: Dial gauge that displays the count of tasks that are past their due date
- Status Report Compliance: Dial gauge that displays the compliance of status reports for various projects.
-
All Assignments report provides project managers a single place to view KPIs related to Task Assignments. All the KPIs are depicted in various visualizations. Total Actuals: Scorecard that displays the sum of actuals associated with assignments for the selected criteria. Remaining ETC: Scorecard that displays the sum of current ETC associated with assignments for the selected criteria. Top 5 Roles (Total Effort): Column chart that displays Effort (Actuals + ETC) by Roles. X axis displays various Roles. Data labels indicate sum of effort associated with that Role. Actuals by OBS level 2: Column chart that displays Actuals by OBS level 2. X axis displays various OBS level 2. Data labels indicate sum of actuals associated with that OBS. Grid: Displays Assignment details such as Project ID, Project Name, Task Name, Task Status, Assigned Resource, Assignment Status, Assignment Start, Assignment Finish, Actuals, ETC, Total Effort, Days Late and Days Old. You can further narrow your search by OBS Type, OBS Path, Project(s) and Project Manager. -
Assignments by Task Over Time report display all assignments by task for all resources. Information is displayed on monthly basis. This report displays Investment Name, Task Name, Resource Name and its monthly assignments. You can further narrow your search by OBS Type & Path, Investment Manager, Investment Name, and Year -
Actuals & ETC by Resource Assignment report provides project managers a single place to view Actuals and ETC associated with resources across multiple Tasks and Projects. It displays the following: Actual and ETC Hours by Start Date: Stacked Column chart that displays the total Actual hours and ETC hours per month of fiscal period. Grey color indicates Actuals and Purple indicates ETC hours during that month. Grid: Displays Investment name, Task, Assigned resource ETC and Actual hours per month of fiscal period. It also displays aggregated column and row totals for Actuals and ETC hours. You can further narrow your search by OBS Type, OBS Path & Start Date range. -
Allocation Compliance by PM report provides project managers a single place to view Available hours, Allocation Hours and Allocation Percentage of Investment Team Resources. It considers the investments of selected project manager and it displays the following: Allocation Details Grid: Displays Resource and its Allocated hours, Available hours and Allocation percentage (Allocated hours/Available Hours) Allocation Percent by Resource: Column chart that displays Allocation Percentage for various resources during the selected Time frame. You can further narrow your search by Project Manager & Month Start Date range. -
Allocation Compliance by RM report provides resource managers a single place to view Available hours, Allocation Hours and Allocation Percentage of Resources. It considers the resources of selected resource manager and it displays the following: Allocation Details Grid: Displays Resource and its Allocated hours, Available hours and Allocation percentage (Allocated hours/Available Hours) Allocation Percent by Resource: Bar chart that displays Allocation Percentage (top 10) for various resources during the selected Time frame. You can further narrow your search by Resource Manager & Month Start Date range. -
Allocation Compliance Column Chart report provides resource managers a single place to view Allocation compliance for various resources. It displays the following: Allocated Hours by OBS chart: Stacked Column chart that displays percentage of resources that are fully allocated (80 -120 %) and under allocated (less than 80%) for a particular OBS and selected period range. Grid: Displays Resource Name, Resource Id, Primary Role, Booking Manager, Period, Allocated hours and Actual hours during that period. You can further narrow your search by OBS Type, OBS Path & Period Start Date range. -
Allocation Compliance Pie Chart report provides resource managers a single place to view Allocation compliance for various resources. It displays the following: Allocated Hours by OBS chart: Pie chart that displays percentage of resources that are fully allocated (80 -120 %) and under allocated (less than 80%) for a particular OBS and selected period range. Grid: Displays Resource Name, Resource Id, Primary Role, Booking Manager, Period, Allocated hours and Actual hours during that period. You can further narrow your search by OBS Type, OBS Path & Period Date range. -
Capacity Graph report displays Availability, Allocations, Actuals and Assignments for one or more active resource(s) in a single view. Report contains the following components: KPIs: Displays Available hours, Allocation + ETC for filtered criteria. Bar graph: Displays Allocation + ETC by primary role Line chart: Displays Availability, Allocations, Actuals and Assignments by time period. This portlet provides Resource Managers, PMOs and Executives with a simple way to analyze: Allocations vs. Availability, Allocations vs. Actuals, Allocations vs. ETC and ETC vs. Availability. User can further narrow their search by OBS Type & Path, Resource Manager, Primary Role, Start and End Date. -
RM Dashboard shows various KPIs like Actuals posted by the resources in last month, Allocation in current month, count of missed timesheets etc. Team Details – Grid report providing list of all the resources managed by a resource manager. Allocation by Investment type – Tree graph displaying distribution pattern of allocation hours across different investment types. Actuals by Employment Type - Area graph, displaying actual hours posted by Employees Vs Contractors. Demand by Month – Area graph, displaying Allocation Vs Availability for next 6 months. Utilization by Month - Area graph, displaying Baseline Vs Actuals hours over last 6 months. -
Timesheet compliance is a dashboard containing multiple visualizations that shows timesheet compliance data under various scenarios. Dashboard shows count of timesheets grouped by Status and total available timesheets. % Time Compliance – Gauge graph that shows percentage of completed timesheets against overall timesheets. Compliance by Resource Manager – Grid section that shows percent timesheet compliance by resource manager. Timesheet count by Employment type and Timesheet Status – Stacked column chart, each column represents Employment type and sections of the column represent count of timesheets by Status. Count of Timesheets by Months – Stacked column chart, each column represents a month and sections of the column represent count of timesheets by Status. Dashboard also const of two grid sections displaying number of Open timesheets by Organization and Vendor. -
Many times Roles are spread out geographically or by function and these Roles will have different rates. For example, a developer in India may charge $25/hour vs a Developer in US may charge $50/hour. When the project team has a requirement of several developers, the PM will have to add a region specific role (Developer-US, Developer-India) so that the right rates can be applied when a cost plan is created. This creates a challenge in terms of Resource Management. As the Demand and Capacity can be spread between different region specific roles. Proper configuration on the Rate Matrix can allow you to have one Role name but different rates based on Location or Department. This allows greater flexibility and takes away the redundancy of Role Names. You can do so with the Project Team Member Properties.
Copyright 2023 • Rego Consulting Corporation • Privacy Policy