Use the Summary tab to review Billing, Compensation, Cost, Revenue, and Multiplier summaries for the current plan.
Contents
Multiplier Summary Grid
Use the Multiplier Summary grid to view Multipliers that are calculated from data entered in General, Labor, Expenses, and Consultant tabs. This includes the target multiplier, the actual or effective multiplier or realization ration, the estimate at completion multiplier, and the planned multiplier or planned ration for evaluation purposes.
To change the columns that display on this grid, use the Multiplier tab of the Summary Grid Configuration dialog box.
| Field | Description |
|---|
| Multiplier Summary Drop-down
|
Click the drop-down arrow on a grid header to complete any of the following actions:
- To print grid data, click
Print. On the Print Preview form, click
to send the grid data to your default printer.
- To export grid data to an Excel spreadsheet, click
Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally.
- To turn on grouping for a grid, click
Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display.
Not all options are available on all grids.
|
| Planned Multiplier - Cost
|
This field displays the
Planned Multiplier from the Cost Analysis tab of Project Planning.
|
| Effective Multiplier - Cost
|
This field displays the
Effective Multiplier for Cost, which is calculated as follows:
(Job to Date Revenue - Job to Date Expense Cost - Job to Date Consultant Cost) / Job to Date Labor Cost
You can also display the
Effective Multiplier for Cost on several of the project control reports when you use cost rates to generate them.
|
| Estimate at Completion Multiplier - Cost
|
This field displays the
Estimate at Completion Multiplier for Cost, which is calculated as follows:
((Compensation + Consultant Fee + Reimbursable Allowance) - (Estimate at Completion Expense Cost + Estimate at Completion Consultant Consultant Cost)) / Estimate at Completion Labor Cost
|
| Target Multiplier - Cost
|
This field displays the
Target Multiplier - Cost from the General tab.
|
| Budget Multiplier - Cost
|
This field displays the
Budget Multiplier for Cost, which is calculated as follows:
Cost Budget Multiplier = Compensation Fee / Estimate at Completion Cost
|
| Planned Multiplier - Billing (Planned Ratio)
|
This field displays the
Planned Ratio from the Billing Analysis tab of Project Planning.
|
| Effective Multiplier - Billing (Realization Ratio)
|
This field displays the
Effective Multiplier for Billing, which is calculated as follows:
(Job to Date Revenue - Job to Date Expense Bill - Job to Date Consultant Bill) / Job to Date Labor Bill
You can also display the
Effective Multiplier for Billing on several of the project control reports when you use billing rates to generate them.
|
| Estimate at Completion Multiplier- Billing
|
This field displays the
Estimate at Completion Multiplier for Billing, which is calculated as follows:
((Compensation + Consultant Fee + Reimbursable Allowance) - (Estimate at Completion Expense Bill + Estimate at Completion Consultant Bill)) / Estimate at Completion Labor Bill
|
| Target Multiplier - Billing
|
This field displays the
Target Multiplier - Bill from the General tab.
|
| Budget Multiplier - Billing
|
This field displays the
Budget Multiplier for Billing, which is calculated as follows:
Billing Budget Multiplier = Compensation Fee / Estimate at Completion Bill
|
The Billing and Cost rows that display depend on the
Budget Type that you select on the Rates tab of Project Planning. When you update a project plan, these grids calculate and display the budget and cost numbers based on your entries in the Planning grids. The Revenue and Multiplier grids display data from the General, Rates, Cost Analysis, and Billing Analysis tabs.
This field displays the total compensation and depends on the following:
-
If you select the
Plan Compensation Values by Row & Period option, the compensation amount is the sum of all compensation rows on the Labor Planning grid of Project Planning.
-
If you do not select the
Plan Compensation Values by Row & Period option, the compensation amount comes from the compensation fields on the Cost Analysis tab and the Billing Analysis tab of Project Planning.
Revenue Summary Grid
Use the Revenue Summary grid to view the summary of Planned Revenue that Vision calculates from information entered on the Labor, Expenses, and Consultant Tabs. These values are based on the Planned Revenue settings on the General tab of the plan.
To change the columns displayed on this grid, use the Revenue tab of the Summary Grid Configuration dialog box.
| Field | Description |
|---|
| Revenue Summary Drop-down
|
Click the drop-down arrow on a grid header to complete any of the following actions:
- To print grid data, click
Print. On the Print Preview form, click
to send the grid data to your default printer.
- To export grid data to an Excel spreadsheet, click
Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally.
- To turn on grouping for a grid, click
Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display.
Not all options are available on all grids.
|
| Labor
|
This field displays the summary of planned labor revenue, which Vision calculates as follows:
When Labor Multiplier is User Entered (Cost) or Planned Multiplier:
Planned Labor Revenue = Planned Labor Cost * Multiplier (from General Tab)
When Labor Multiplier is User Entered (Billing) or Planned Ratio:
Planned Labor Revenue = Planned Labor Billing * Multiplier (from General Tab)
|
| Expenses
|
This field displays the summary of planned expense revenue, which Vision calculates as follows:
When the Reimbursable Method is Cost:
Planned Expense Revenue = Planned Reimbursable Expenses @ Cost
When the Reimbursable Method is Billing:
Planned Expense Revenue = Planned Reimbursable Expenses @ Billing
|
| Consultants
|
This field displays the summary of planned consultant revenue, which is calculated as follows:
When the Reimbursable Method is Cost:
Planned Consultant Revenue = Planned Reimbursable Consultants @ Cost
When the Reimbursable Method is Billing:
Planned Consultant Revenue = Planned Reimbursable Consultants @ Billing
|
| Units
|
This field displays the summary of planned unit revenue.
|
| Total
|
This field displays the total summary of planned labor, expense, and consultant revenue.
|
| Planned
|
This field displays the amount budgeted for the plan. You can also think of this as the current forecast for the full plan.
|
| Job to Date
|
This field displays the summary of the Job to Date total amount. Job to Date costs are the actual cost amounts reported from the beginning of the plan.
This amount includes any historical actual data.
|
Compensation Summary Grid
Use the Compensation Summary grid to view compensation summary information. When you update a project plan, these grids calculate and display the billing and cost numbers based on your entries in the Planning grids.
The information that displays on the Compensation grid depends on the following:
-
If you select the
Plan Compensation Values by Row & Period option, data comes from the sum of all compensation rows on the Labor Planning grid of Project Planning; if you do not select this option, Vision pulls data from the compensation fields on the Cost Analysis and Billing Analysis tabs of Project Planning.
-
If the
Project Fee Entering Method option on the General tab of
is set to
At all levels of work breakdown structure, all WBS level fees in the project are updated with the plan's corresponding fees.
-
If the
Project Fee Entering Method option on the General tab of
is set to
At lowest level only, all compensation will be summed to update the project's fees.
-
When the
Plan Compensation Values by Row & Period,
Synchronize fees from Plan to Project, and
Include in Utilization and Project Reports options are all selected, Vision synchronizes fees only for those of the project's WBS levels that match.
To change the columns displayed on this grid, use the Compensation Tab of the Planning Summary Grid Configuration dialog box.
| Field | Description |
|---|
| Compensation Drop-down
|
Click the drop-down arrow on a grid header to complete any of the following actions:
- To print grid data, click
Print. On the Print Preview form, click
to send the grid data to your default printer.
- To export grid data to an Excel spreadsheet, click
Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally.
- To turn on grouping for a grid, click
Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display.
Not all options are available on all grids.
|
| Compensation
|
This field displays the total compensation that is based on the amounts entered for the fee direct labor and fee direct expenses.
|
| Fee Direct Labor
|
This field displays the total direct labor fees.
|
| Fee Direct Expense
|
This field displays the total direct expense fees.
|
| Fee Direct Consultant
|
This field displays the direct consultant fees that your company expects to receive for the project. The direct consultant fee amount should include fees for consultant work that are not reimbursable.
|
| Reimbursable Allowance
|
This field displays the sum of fee reimbursable consultant and fee reimbursable expense amounts.
|
| Fee Reimbursable Expense
|
This field displays the sum of the expense fees that will be reimbursed by the client.
|
| Fee Reimbursable Consultant
|
This field displays the sum of the consultant fees that will be reimbursed by the client.
|
| Total
|
This field displays the sum of the
Compensation,
Fee Direct Consultant, and
Reimbursable Allowance amounts for each grid row.
|
Cost Summary Grid
Use the Cost Summary grid to view budget and cost numbers based on your entries on the Planning grids. As you assign, budget, or forecast costs associated with employees, expenses, and consultants, the results display in these grids. To change the columns displayed on these grids, use the Cost tab of the Summary Grid Configuration dialog box.
| Field | Description |
|---|
| Cost Drop-down
|
Click the drop-down arrow on a grid header to complete any of the following actions:
- To print grid data, click
Print. On the Print Preview form, click
to send the grid data to your default printer.
- To export grid data to an Excel spreadsheet, click
Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally.
- To turn on grouping for a grid, click
Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display.
Not all options are available on all grids.
|
| Labor
|
This field displays the total hours multiplied by the hourly cost.
|
| Expenses
|
This field displays the summary of all expense cost amounts for all Work Breakdown Structure (WBS) elements.
|
| Consultants
|
This field displays the summary of all consultant cost amounts for all WBS elements.
|
| Units
|
This field displays the summary of all unit cost amounts for all WBS elements.
|
| Total Amount
|
This field displays the summary of all costs (Labor + Expenses + Consultants + Units) for all WBS elements.
|
| Total Hours
|
This field displays the summary of all hours for all WBS elements. For example, this field may display all hours summarized from all tasks and phases.
|
| Baseline
|
This field displays the total hours or amount estimated in the baseline version of the plan.
|
| Planned
|
This field displays the revised total hours or amount budgeted for the plan. You can also consider this the current forecast for the full plan.
|
| Job to Date
|
This field displays the Job to Date total hours or amount. Job to Date hours are the actual hours reported as worked since the plan began. Job to Date costs are the actual cost amounts reported since the plan began.
This amount includes any historical actual data, which has a date of 1/1/1990.
|
| Estimate to Complete
|
This option displays the Estimate to Complete hours or amount. This is the estimate of the remaining planned hours or amount relative to tomorrow forward, including non-working days set up in your holiday calendar. The ETC is calculated based on the application, Vision or iAccess for Vision, in which the plan was created. See the How Planning Calculates ETC online help topic for additional information.
You must consider the calendar period, or scale, within which the current date falls because the Estimate to Complete may require proration. Consider the following:
-
If it is the last business day of a calendar period, no proration is required.
-
If it is
not the last day of a calendar period, Vision must prorate the hours or amount accordingly. To do this, Vision divides the business days remaining in the calendar period by the total number of business days in the calendar period.
|
| Estimate at Completion
|
This option displays the Estimate at Completion hours or amount. This is the current estimate of the total that will have been worked or spent at the plan's finish.
Estimate at Completion = Job to Date + Estimate to Complete
|
| Planned Estimate at Completion
|
This option displays the variance. This is the difference between the total budget hours or amount specified in the current version of the plan and the original baseline version of the plan.
|
Billing Summary Grid
Use the Billing Summary grid to view budget numbers based on your entries on the Planning grids. As you assign, budget, or forecast amounts associated with employees, expenses, and consultants, the results display here.
To change the columns displayed on these grids, use the Billing Tab of the Summary Grid Configuration dialog box.
| Field | Description |
|---|
| Billing Summary Drop-down
|
Click the drop-down arrow on a grid header to complete any of the following actions:
- To print grid data, click
Print. On the Print Preview form, click
to send the grid data to your default printer.
- To export grid data to an Excel spreadsheet, click
Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally.
- To turn on grouping for a grid, click
Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display.
Not all options are available on all grids.
|
| Labor
|
This field displays the total hours, summarized from all Work Breakdown Structure (WBS) elements, multiplied by the hourly billing rates.
|
| Expenses
|
This field displays the total expense costs, summarized from all WBS elements, multiplied by the billing markup.
This column displays if you select the
Enable Expense Planning option on the General tab of Planning Configuration.
|
| Consultants
|
This field displays the total consultant costs, summarized from all WBS elements, multiplied by the billing markup.
This column displays if you select the
Enable Consultant Planning option on the General tab of Planning Configuration.
|
| Units
|
This field displays the total unit costs, summarized from all WBS elements.
This column displays if you select the
Enable Unit Planning option on the General tab of Planning Configuration.
|
| Total Amts
|
This field displays the total of all billing amounts.
|
| Total Hours
|
This field displays the summary of all hours for all WBS elements rolled up (for example, all hours summarized from all tasks and phases).
|
| Baseline
|
This field displays the total hours or amount estimated in the baseline version of the plan.
|
| Planned
|
This field displays the revised total hours or amount budgeted for the plan. This is like the current forecast for the full plan.
|
| Job to Date
|
This field displays the Job to Date (inception-to-date) total hours or amount. Job to Date hours are the actual hours reported as worked since the plan began. Job to Date costs are the actual cost amounts reported since the plan began.
This amount includes any historical actual data (the historical data has a date of 1/1/1990).
|
| Estimate to Complete
|
This row displays the estimate of the remaining planned hours or amount relative to tomorrow forward, including non-working days set up in your holiday calendar.
The calendar period within which today falls is important to determine any proration required by the Estimate to Complete calculation:
- If the day on which you are looking at the plan data is the last business day of a calendar period, no proration is required.
- If the day on which you are looking at the plan data is
not the last day of a calendar period, Vision must prorate the hours or amount accordingly. To do this, Vision divides the business days remaining in the calendar period by the total number of business days in the calendar period.
|
| Estimate at Completion
|
This field displays the Estimate at Completion hours or amount. This is the current estimate of the total that will have been worked or spent at the plan's finish.
Estimate at Completion = Job to Date + Estimate to Complete
|
| Planned Estimate at Completion
|
This field displays the variance. This is the difference between the total budget hours or amount specified in the current (revised) version of the plan and the original baseline version of the plan.
|
