Project Budget vs Planned vs Actual by Month – SQL

This portlet shows the project costs by Month. The information displayed includes:

• Start Date for project
• End Date for project
• Budgeted Cost
• Planned Cost
• Actual Hours

This provides the PM with a one shot view of the total financials/actuals for the project.

The Project name field is linked to the project properties page. In case of any adjustments, the PM can toggle b/w the portlet and the project with ease.  The user can filter on multiple projects, or projects by OBS, or by PMs, to view the data on the portlet.