Summary Tab of Project Planning

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 File > Print 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 File > Print 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 Configuration > Accounting > System Settings 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 Configuration > Accounting > System Settings 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 File > Print 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 File > Print 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 File > Print 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.