|
Description: |
An Excel-based tool that can be used by a project to plan staffing resources and track actual and projected effort against the plan each month. This tool is also used to plan yearly procurement costs and track actual expenditures against the plan.
This tool allows the user to plan up to 10 years of staffing resources and procurement costs. Staffing resources can be planned and actuals tracked by staff name, role, process work, technical work, funding source, and organizational affiliation (i.e., civil servant (by Nasa Organization) and contractor (by contract)), WBS element, and skill level.
This tool generates the following charts and reports: Charts containing planned, actual, and projected staff months per month (one for project-funded staff for 18-months, one for project-funded staff for full project duration, and one for "other-funded" staff for 18 months); Chart containing cumulative planned, actual, and projected staff months by month for project-funded staff (18 month duration); Monthly Effort by Process Area (current month), Yearly Staff Summaries (one by civil servant and contractor and one by organization/contract); Staffing Profile for the full project duration (by quarter); and Staffing Assignments (current month actuals and projected staffing levels for the next 11 months by staff name, role, and technical work).
A User's Guide is provided in the first tab in the file. |
