RegoXchange
  • The Allocation Compliance by Person (Project Manager) portlet gives a view of resource allocation compliance for active resources on the team of an investment the logged in user is the manager for.  It allows the PM to see resources on their project over the coming months and whether they are over or under allocated.   This portlet leverages the daily allocation and daily availability slices as well as only active investments.  The portlet provides filters for specific dates, filtering by resource ID, and resource name may also be added.
  • This view depicts Allocation Compliance for resources grouped by OBS.  Using the daily Resource Availability and Daily Resource Allocation Time Slices this column chart groups aggregate Allocation vs Availability by OBS Unit.  The chart allows quick analysis to see if resources are adequately allocated (between 80% to 120% of their capacity) or if they are significantly under or over allocated. NOTE:  The grouping of OBS unit is limited to 1 level below the selected OBS in the portlet filter.
  • The Investment Allocations and Assignments report provides visibility into team member allocation, task assignment, and variance amounts by investment across time periods. A chart highlights allocation compared to assignment amounts by period. Results can be displayed by week, month, or in total, and viewed in either hours or FTEs for each team member and investment. Interactive visuals make it easy to compare planned effort against actual assignments at the team member and investment level. Content Type: Business Intelligence, PowerBI Report
  • Allocation Compliance Column Chart provides the resource manager a single place to view the Allocation compliance information in the form of a stacked column 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 & Path, Associated Project OBS?, Allocation Start Date, Investment Name and Resource Manager. User can use exact dates or relative dates for Allocation Start Date filter parameter.
  • 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.
  • A process creating a new Cost Plan. Cost Plan properties:
    Name Cost Plan created on: yyyy/mm/dd hh:mm:ss
    Grouping attributes Charge Code, Transaction Type
    Start Period The earliest fiscal period with Actuals (from PPA_WIP table) or current period, if there are no actuals
    Finish Period The latest fiscal period with a non-zero allocation (from PRJ_BLB_SLICES table, SLICE_REQUEST_ID = 6
    Period Type Monthly
    Plan of Record True
    Planned Cost For periods in the past – from Actuals (Charge Code, Transaction Type, Quantity (Units), Cost (Amount) taken from Transactions (PPA_WIP & PPA_WIP_DETAILS); For current and future periods – from Allocations (Charge Code taken from the Project, Transaction Class from the Resource, Quantity from allocation slices, Cost from the Rate Matrix (NBI_PROJ_RES_RATES_AND_COSTS table)
    Pre-conditions:
    • the Project must be financially enabled.
    • if a new Team Member is added, Rate Matrix job must be run, so the rates are populated in the NBI table.
    • if the Allocation changes, allow the timeslice job to finish before running the process.
    • the Project should have the Charge Code set.
  • Process sends an email to RM, for resources assigned, that indicates the allocation percentage for each resource for the next 6 weeks.  Email has links to each resource so that allocation modifications can be made as required.
  • Based on the pre-determined schedule frequency, this job will send an email to Resource Managers that have a Resource meeting the criteria of: Average allocations are less than 100% where Resource(s) and Project(s) are active over the next two weeks. This serves as a reminder to Resource Managers to monitor and manage allocations. The contents of the email include a message indicating the Resource Manager has at least one Resource meeting this criteria and a table indicating the Resource and that resource’s average, next 90 days allocations.
  • This portlet displays the % allocation of resources to projects. The portlet shows if the resource is allocated to the projects as an individual resource or as part of an Agile team, in which case it will display the resource % allocation to the team and what that will represent in terms of % allocation to the project. The Total Allocation % display the allocation of the resource to all investments is allocated to. Remaining Capacity and Over/Under columns will help identify the resources that still have availability and the ones that are over allocated.
  • The My Allocations portlet will display the allocations for the logged in user - pulling data from the timeslices.  It is used as a quick reference for the users to view their allocations across all of the projects where their allocation is greater than 0 for the specified date range the user wants.  This will display both active and inactive projects.
  • The Capacity Graph - Investment portlet displays Availability, Allocations, Assignments and Actuals for active resources in a single project. This portlet pulls from timeslices and allows the user to filter on weekly, monthly, or quarterly data. This portlet provides a Project Manager with a simple way to analyse:  Allocations vs. Actuals and Allocations vs. ETC.  Depending on metric goals, the graph allows the user to determine where areas of improvement may exist.
  • Capture and present allocation data by Team for the Investments included in your Roadmap to enable the ability to compare to Targets or Limits. Allocation data can be presented in Hours or FTE, for Teams Only.
Go to Top