Previous Topic: Stock Queries Used in Xcelsius Dashboards

Next Topic: Portfolio Portlet

Resource Planning Portlet

Description

The Resource portlet is an interactive portlet that contains Xcelsius visualizations with multiple components. The visualizations help you identify resource forecasted utilization and also the capacity and demand of the roles in the next six months. The gauge component measures the forecasted resource utilization. The column graph gives a comparison between demand and capacity by month. The pie chart shows capacity by role and demand by role. This same information is displayed in the list, except it displays incremental cost information. The grid component displays the capacity and demand for a role for the next six months. Incremental cost in the grid displays the increase or decrease in cost when the FTE/hours slider is increased or decreased respectively.

Prerequisites
Information Displayed

Average Forecasted Utilization

Displays the utilization of roles in an organization.

Role Capacity/Demand

Displays the total capacity in percentage. Each pie segment represents the total capacity and demand for a role.

Capacity and Demand

Displays the total capacity and demand for all roles.

Capacity and Demand by Role

Displays the total capacity and demand for each role for six months starting with the current month. You can replace a role with resources that can complete the work.

The following columns display on the Capacity and Demand by Role chart:

Role

Displays the roles associated for this project.

Incremental Cost

Displays the increase or decrease in cost when FTE or hours are increased or decreased respectively. The values are taken from the cost matrix.

Capacity

Displays the total number of available hours for the associated resource.

Demand

Displays the total number of assigned or allocated hours for the associated resource.

Remaining Capacity

Displays the difference between the total demand and the total capacity for six months for all investments.