Page History

Project Completion Analysis by Revenue report is used to track project progress in terms of both quantities (work done vs. estimated) and amounts (cost/revenue) against tasks and activities.

The Project Completion Analysis by Revenue report provides a detailed breakdown of project progress by comparing estimated values against actual recognized quantities and amounts. It highlights the degree of completion for each project task, expressed in both quantity and revenue terms.

...

• Project:  Description of the project
• Code WBS, Project Task: Project tasks broken down by Work Breakdown Structure (WBS)
• The Item column displays all detailed subcomponents, materials, equipment, or activities associated with a project task, providing a granular view of their associated costs or revenues.

• Quantity (Opening, For Period, Closing, Estimated, Pending) measures the physical progress of work.

  1. Opening Balance - cumulative quantity completed up to the start of the period.

  2. For Period - work done in the current reporting period.

  3. Closing Balance - cumulative quantity completed to date (Opening + For Period).

  4. Estimated - planned or target quantity for the task.

  5. Pending - remaining quantity to be executed (Estimated - Closing).

• Amounts (Opening, For Period, Closing, Estimated, Pending) reflect the financial side of progress.

  1. Opening Balance - cumulative recognized amounts from prior periods.

  2. For Period - value recorded in the current reporting period.

  3. Closing Balance - cumulative recognized value (Opening + For Period).

  4. Estimated - budgeted or planned value for the task.

  5. Pending - balance not yet recognized (Estimated - Closing).

  1. Example: if Design Fire Fighting Pump has an estimate of 31,850 but a closing balance of -3,185, pending is 35,035, showing a reversal.

• Amount Completion % shows progress in percentage terms.

  1. Formula: (Closing Balance ÷ Estimated Amount) × 100.

  2. Positive % - progress made and recognized.

  3. 0% - no progress.

  4. Negative % - reversals or corrections reduce recognized revenue below zero.

Example: Construction Scope estimated at 254,800, actual -6,370, equals -2.5% completion.

...