Portfolio Pages and Portlets › Financials Tab › Capital vs Expense Budget and Forecast Portlet

Capital vs Expense Budget and Forecast Portlet

The Capital vs Expense Budget and Forecast portlet displays budget, actual, forecast, and variance for each investment included in a portfolio. Use this portlet to compare budget to forecast capital and expense cost of the portfolio investments.

To view this portlet, open the portfolio and click Financials. If the page is maximized to display only one portlet at a time, select Capital vs Expense Budget and Forecast from the portlet drop-down.

To view data in the portlet, do the following:

• Group cost plans for an investment by charge code of Capital or Expense to view budget and planned cost.
• Use charge codes of Capital or Expense on financial transactions and timesheets to view actual cost.
• Post transactions to WIP to view actual cost.

The As of Date filter in the portlet is required to calculate Actual and Forecast amounts. Enter the As of Date so that it is the last day of a fiscal period. If you enter a date other than the last day of a fiscal period in the filter, then the portlet treats it as if it was entered as the last day of the next fiscal period end. For example, if fiscal periods end 10/31 and 11/30 and you enter 11/01 in the As of Date filter, then the portlet treats it as if you entered 11/30 (which is the fiscal period end date of the next fiscal period).

Note: This portlet honors the planning horizon of the portfolio; therefore, the amounts in the portlet are within the portfolio start and finish dates. Also, this portlet does not display aggregate hierarchical cost amounts. The portlet only displays the cost amounts of the investments directly included in the portfolio and does not calculate the aggregate cost amount of any child investments. The portlet displays the home currency of the investment as determined by the department entity. It does not use the portfolio currency to do a currency conversion from the investment home currency.

This portlet displays the following fields:

Investment

Displays the name of the investment. To view the detailed properties for an investment, click the investment name.

Budget (Capital)

Displays the budget cost for the current approved budget where the charge code is Capital.

Budget (Expense)

Displays the budget cost for the current approved budget where the charge code is Expense.

Budget (Total)

Displays the budget cost for the current approved budget that is the total of the Budget (Capital) and Budget (Expense) amounts.

Actual (Capital)

Displays the actual cost for financial and timesheet transactions that have a charge code of Capital. Includes capital transactions posted to WIP with a transaction date on or before the as-of date specified using the As of Date filter.

Actual (Expense)

Displays the actual cost for financial and timesheet transactions that have a charge code of Expense. Includes expense transactions posted to WIP with a transaction date on or before the as-of date specified using the As of Date filter.

Actual (Total)

Displays the actual cost that is the total of the Actual (Capital) and Actual (Expense) amounts. Includes capital and expense transactions posted to WIP with a transaction date on or before the as-of date specified using the As of Date filter.

Forecast (Capital)

Displays the calculated forecast cost for the cost plan of record where the charge code is Capital. Includes capital transactions posted to WIP with a transaction date on or before the as-of date specified using the As of Date filter plus planned cost for fiscal periods after the as-of date specified using the As of Date filter.

Forecast (Expense)

Displays the calculated forecast cost for the cost plan of record where the charge code is Expense. Includes expense transactions posted to WIP with a transaction date on or before the as-of date specified using the As of Date filter plus planned cost for fiscal periods after the as-of date specified using the As of Date filter.

Forecast (Total)

Displays the calculated forecast cost that is the total of the Forecast (Capital) and Forecast (Expense) amounts. Includes capital and expense transactions posted to WIP with a transaction date on or before the as-of date specified using the As of Date filter plus planned cost for fiscal periods after the as-of date specified using the As of Date filter.

Budget to Forecast Var (Capital)

Displays a stoplight that shows whether the capital forecast cost exceeds the budget

Stoplights:

• Green: Indicates that the forecast does not exceed the budget.
• Red: Indicates that the forecast exceeds the budget.

Budget to Forecast Var (Expense)

Displays a stoplight that shows whether the expense forecast cost exceeds the budget.

Stoplights:

• Green: Indicates that the forecast does not exceed the budget.
• Red: Indicates that the forecast exceeds the budget.

Budget to Forecast Var (Total)

Displays a stoplight that shows whether the capital and expense forecast cost exceeds the budget:

Stoplights:

• Green: Indicates that the forecast does not exceed the budget.
• Red: Indicates that the forecast exceeds the budget.

The following fields are available for this portlet and you can add them using the configure option:

See the Personalizing CA Clarity User Guide for more information.

Budget to Actual Var (Capital)

Displays a stoplight that shows whether the capital actual cost exceeds the budget.

Stoplights:

• Green: Indicates that actual cost does not exceed the budget.
• Red: Indicates that actual cost exceeds the budget.

Budget to Actual Var (Expense)

Displays a stoplight that shows whether the expense actual cost exceeds the budget.

Stoplights:

• Green: Indicates that actual cost does not exceed the budget.
• Red: Indicates that actual cost exceeds the budget.

Budget to Actual Var (Total)

Displays a stoplight that shows whether the capital and expense actual cost exceeds the budget.

Stoplights:

• Green: Indicates that actual cost does not exceed the budget.
• Red: Indicates that actual cost exceeds the budget.

Planned Cost Remaining (Capital)

Displays the planned cost remaining for the cost plan of record where the charge code is Capital. Includes planned cost for fiscal periods after the as-of date specified using the As of Date filter.

Planned Cost Remaining (Expense)

Displays the planned cost remaining for the cost plan of record where the charge code is Expense. Includes planned cost for fiscal periods after the as-of date specified using the As of Date filter.

Planned Cost Remaining (Total)

Displays the planned cost remaining that is the total of the Planned Cost Remaining (Capital) and Planned Cost Remaining (Expense) amounts. Includes planned cost for fiscal periods after the as-of date specified using the As of Date filter.