Project Planned, Billed, Remaining Hours Report

Project Planned, Billed, Remaining Hours Report

I am attempting to create a simple report that will list all active projects with the following information:
  • Project Name
  • Planned Hours (Total)
  • Billed Hours (Total)
  • Remaining Hours (Planned - Billed)
The purpose of the report is to quickly identify which projects are close to consuming Planned hours and to understand how much backlog of un-billed (Remaining) hours are in the pipeline for resource planning purposes.  Quickly understanding the backlog of un-billed (Remaining) hours can help our business understand if we should consider hiring additional resources.

Has anyone built a similar report?  Need help/guidance.  It would be nice if this was an OOB report.  I can see this information on the Dashboard for individual projects in ZoHo projects but there is no report that reflects the same information.  Frustrating.