The Billing Analysis tab is a combination of user-entered fields, formulas, and results from the Planning application. All levels of the plan roll up to the top level (WBS1) to provide a quick analysis of the plan's anticipated performance and what your firm expects to be paid.
This tab displays if the
Budget Type is set to
Billing or
Cost and Billing on the Rates tab of Project Planning. It does not display if the Vision Billing application is not installed.
The data for some of these fields is populated based on entries in other areas of the Vision application. Other fields populate with data that is based on calculations that Vision performs on entries on this tab. Refer to each field description for details on how data is populated and/or calculated.
The
Refresh Analysis Compensation option displays on the Actions toolbar menu if
Compensation Values by Period is selected on the General tab of Planning Configuration. Select this option to copy the
Compensation,
Direct Consultant, and
Reimbursable Allowance amounts from the Labor tab to the Billing Analysis tab, and to recalculate the
Profit and
Variance Amount/Percent,
Planned Multiplier, and
Planned Ratio on the Billing Analysis tab. When you save, the
Planned Multiplier and
Planned Ratio are recalculated using the Fee numbers from the Billing Analysis tab instead of the summing up numbers from the Labor Tab.
Contents
| Field | Description |
|---|
| Currency
|
If your firm uses the Multicurrency feature, this field displays the currency that your company selected from the list of enabled currencies.
|
| Fee Analysis at Billing Value
|
The columns in this section provide an overview of the Contract/Fee, Planned, and Variance amounts at billing for your plan.
- Contract/Fee — The user- entered compensation or fee amounts. As you update or change these amounts, the planned and variance amounts automatically recalculate.
-
Planned — The planned amounts at billing that are pulled from different areas of Vision.
- Variance — The difference between the Contract/Fee and Planned amounts.
You can read down each row to view the contract or planned amounts for the following categories:
- Compensation — The sum of all labor and direct expense amounts, which is added to the direct consultant amount.
- Direct Consultants — The amount budgeted or spent on direct (non-reimbursable) consultants.
- Reimbursable Allowance — The reimbursable allowance includes all expenses that will be reimbursed to your company by the client, including reimbursable consultant fees.
-
Total Contract — Total of all compensation, direct consultant, and reimbursable allowance amounts.
These amounts are pulled from different areas within Vision. The columns that display depend on the project's budget source and the project's charge type (Regular, Overhead, or Promotional).
If the
Compensation Values by Period option is selected on the General tab of Planning Configuration, you can use the
Refresh Analysis Compensation option on the Actions toolbar menu to copy the Direct Labor, Direct Expense, Direct Consultant, Reimbursable Expense, and Reimbursable Consultant Fee amounts from the Labor tab to the Billing Analysis tab's corresponding fields.
|
| Planning Analysis at Billing
|
The columns in this section provide an overview of the Actual, Estimate to Complete, and Estimate at Complete amounts at billing for your plan.
- Actual — These fields display the actual amounts that are pulled from different areas of Vision.
- Estimate to Complete — These fields display the amounts remaining to complete. 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.
- Estimate at Complete — These fields display the sum of the Actual and Estimate to Complete amounts.
You can read down each row to view the actual and estimate to complete amounts for the following categories:
- Compensation — The sum of all labor and direct expense amounts, which is added to the direct consultant amount.
- Direct Consultants — The amount budgeted or spent on direct (non-reimbursable) consultants.
- Reimbursable Allowance
— The reimbursable allowance includes all expenses that will be reimbursed to your company by the client, including reimbursable consultant fees.
- Total Contract — Total of all compensation, direct consultant, and reimbursable allowance amounts.
|
Job-to-Date Actual
| Field | Description |
|---|
| Planned Ratio
|
This field displays the planned ratio, which is used to evaluate how much revenue a plan will return based on each labor billing dollar planned —
Total Contract Compensation / Total Planned Labor Cost
|
| Realization Ratio
|
This field displays the realization ratio —
Total Earned Value / Total Actual Billing Value
|
| Planned Variance $
|
This field displays the planned variance amount —
Total Contract Compensation - Total Planned Compensation
This field does not display if the project's charge type is
Overhead or
Promotional.
|
| Earned Revenue
|
This field displays the actual Job-to-Date revenue that is associated with the current period.
|
| Actual Bill Value
|
This field displays the actual Job-to-Date amount that was spent at billing that is associated with the period.
|
| Actual Variance $
|
This field displays the actual variance amount —
Total Earned Actual - Total Billing Actual
This field does not display if the project's charge type is
Overhead or
Promotional.
|
| Actual Variance %
|
This field displays the actual variance percent —
Total Variance / Total Earned
This field does not display if the project's charge type is
Overhead or
Promotional.
|
| % Complete
|
This field displays the percent of the project that is complete.
The
% Complete Formula on the General tab of Project Planning determines how the values are calculated on the Billing Analysis tab. Calculation options include:
-
User-Entered Percent Complete — This is the manual method of percent complete entry, and is good for planning at a minute level of detail. It helps you keep track of when each individual piece is complete. The calculation is: Weighted Average Amount for Labor, Expense, Consultant, and Unit divided by the Planned Amount for Labor, Expense, Consultant, and Unit.
-
(Planned - Estimate to Complete)/Planned — This is the Plan Schedule based percent complete. It displays your progress according to your schedule on the job and ignores any actual time spent. The calculation is: Planned amount minus the Total amount for the Estimate to Complete (from the Analysis tab) divided by the Planned amount.
-
Job to Date /(Job to Date + Estimate to Complete) — The
Job to Date
is the work effort based percent complete. It tells you how far along you are based on effort expended, how much of the work you have completed, and how much you should do in the future. The calculation is: Job to Date amount divided by (Job to Date amount plus the Estimate to Complete from the Analysis tab).
-
(Baseline - Estimate to Complete)/Baseline — The baseline is the client schedule based percent complete that represents where the client thinks you are on the project. The Baseline is frozen as the original schedule and budget. You can modify this percent complete to compare to where you feel you really are on the job. The calculation is: (Total Baseline amount from the Summary tab minus the Estimate to Complete from the Summary tab or from the Total on the Analysis tab) divided by the Total Baseline.
|
| % Expended Hour
|
This field displays the percent expended hours —
Total Actual Hours / Total Planned Hours
|
| % Expended $
|
This field displays the percent expended amount —
Total Actual Dollars / Total Planned Dollars
|
