This sheet shows the percentage of demand that can be allocated to projects given their priorities. A primary objective for the management team is to get the color out of this picture.
The Project Analysis sheet is the “due diligence” report for senior (portfolio) management. There should be no extremes in degree or duration of resource shortfall in the approved projects on the portfolio.
(Proposed or pending projects should be at the bottom of the priority list and will usually show substantial shortfall.)
- The projects are sorted in priority order. Resources are allocated from the top down. Notice how there is more color as you scroll down.
- When Show Header Rows is on, the detail header shows the Portfolio Allocated % Demand and the Gantt chart for the project on the selected row.