Summary Tab of Project Planning

Use the Summary tab to review Billing, Compensation, Cost, Revenue, and Multiplier summary grids 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. When the Print Preview form displays, 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 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 this 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 and the Billing 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 Cost Analysis tab and the Billing Analysis tab.
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 grids 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 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 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. When the Print Preview form displays, 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 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 this 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.

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. When the Print Preview form displays, 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 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 this 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.

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. When the Print Preview form displays, 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 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 this 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.
Parent Topic: Project Planning Form