This report presents an overview for each project to analyze delivery success and identify the areas where improvements can be made for planning future project. The report has various calculated columns that explained in details below.

Column Only time and materials within the selected period All time and material reported on the project
Budget Hours Proportion the budget according to the selected period on the activity.

E.g. an activity has a budget of 90 hrs and starts on 1 Jan and finishes 31 March.
If the report is generated for one month is will then calculate and show a budget for one third of the total budget i.e. 30 hrs.

 All budget hours on the project | activity | member
Actual Hours Hours reported on the activity during the selected period. All hours reported on the activity.
Budget Hours Cost [Budget Hours] * Cost per hour

[Cost per hour] taken from the Project Cost Model

Calculating the [Budget Hours Cost] when the project cost model is set to use either Project Member or Activity Member:

  • If the Project Activity budget is allocated to Activities Members:

    Multiple each activity members’ allocated hours with their cost per hour.

    Where the Allocated Budgets allocated to the Activity is less than the total activity budget show the value for [Budget Hours Cost] in red font.

  • If the Project Activity budget is to be shared between the team:

    Proportion the budget equally between the activity members and then multiple each activity members’ cost/hr with their budget proportion.

 [Budget Hours] * Cost per hour

[Cost per hour] taken from the Project Cost Model

Calculating the [Budget Hours Cost] when the project cost model is set to use either Project Member or Activity Member:

  • If the Project Activity budget is allocated to Activities Members:

    Multiple each activity members’ allocated hours with their cost per hour.

    Where the Allocated Budgets allocated to the Activity is less than the total activity budget show the value for [Budget Hours Cost] in red font.

  • If the Project Activity budget is to be shared between the team:

    Proportion the budget equally between the activity members and then multiple each activity members’ cost/hr with their budget proportion.
Actual Hours Cost [Actual Hours] * Cost per hour

Cost per hour taken from the Project Cost Model

 [Actual Hours] * Cost per hour
Budget Materials Cost Material Budget Costs on the project that fall with the selected period. All Material Budgets Costs on the project.
Actual Materials Cost Material Actual Costs on the project that fall with the selected period. Plus all expenses items reported during the select period. All Material Actual Costs on the project + All expenses items reported on the project.
Planned Cost [Budget Hours Cost] + [Budget Materials Cost] [Budget Hours Cost] + [Budget Materials Cost]
Actual Cost [Actual Hours Cost] + [Actual Materials Cost] [Actual Hours Cost] + [Actual Materials Cost]
Budget Hours Income
  • Non-Fixed Price Entities:

    [Budget Hours] * Price per hour WHERE hours are set to BILLABLE

    Price per hour taken from the Project Price Model.

  • Fixed Price Entities:

    Fixed Priced project/activities where the billing date falls within the selected period.
  • Non-Fixed Price Entities:

    [Budget Hours] * Price per hour WHERE hours are set to BILLABLE

    Price per hour taken from the Project Price Model.

  • Fixed Price Entities:

    Fixed Priced.
Actual Hours Income
  • Non-Fixed Price Entities:

    [Actual Hours] * Price per hour WHERE hours are set to BILLABLE

    Price per hour taken from the Project Price Model.

  • Fixed Price Entities:

    Fixed Priced project/activities where the billing date falls within the selected period.
  • Non-Fixed Price Entities:

    [Actual Hours] * Price per hour WHERE hours are set to BILLABLE

    Price per hour taken from the Project Price Model.

  • Fixed Price Entities:

    Fixed Priced.
Budget Materials Income Material Billing Income on the project that falls within the selected period.

Note: In QBIS 2.0 the field is called Billing Total.

 All Material Billing Income on the project that falls within the selected period.
Actual Materials Income Material Billing Income on the project that falls within the selected period + All expenses items marked BILLABLE reported during the select period All Material Billing Income on the project + All expenses items marked BILLABLE reported on the project
Planned Income [Budget Hours Income] + [Budget Materials Income] [Budget Hours Income] + [Budget Materials Income]
Actual Income [Actual Hours Income] + [Actual Materials Income] [Actual Hours Income] + [Actual Materials Income]
Invoiced Income Invoiced income on the project during the select period.

Note:Invoiced income are values connected to the project invoice tab

 All invoiced income on the project.
Net Income [Invoiced Income] – [Actual Materials Costs] during the selected period. All [Invoiced Income] – [Actual Materials Costs]
Planned Result [Planned Income] – [Planned Cost] [Planned Income] – [Planned Cost]
Actual Result [Actual Income] – [Actual Cost] [Actual Income] – [Actual Cost]
Invoiced Result [Invoiced Income] – [Actual Cost] [Invoiced Income] – [Actual Cost]