BETA — This tool is in active development. Data and calculations should be independently verified before use in official documents or submissions. Feedback welcome at cocanojm@yahoo.com
?Number of weeks displayed in the heatmap and allocation views. More weeks gives a wider planning horizon.?Load a realistic sample dataset with 10 staff, 4 projects, and 17 assignments to explore the tool.
0
Total Staff ?Number of active staff members in the roster.
0%
Avg Utilization ?Average utilization across all active staff for the current view window. Utilization = assigned hours / available hours.
0
Overloaded ?Staff members assigned more than their weekly available hours in any week of the current window.
0
On Bench ?Staff with zero assignments in the current view window. Available for new project work.
0 hrs
Capacity Available ?Total unassigned hours across all staff for the current view window.
?Save: Downloads your resource plan as a JSON file.
Load: Opens a previously saved resource plan JSON file. Replaces current data.
?Export the utilization heatmap as a PNG image. Choose a size multiplier for higher resolution output suitable for printing or presentations.?Export staff roster as a CSV file for use in Excel or other spreadsheet tools.?Export weekly utilization data for all staff as a CSV file with one column per week.?Import project data from the Schedule Builder tool (loads from localStorage key 'aph_schedule'). Creates a project entry if one does not already exist.
Utilization Heatmap ?Canvas-rendered heatmap showing weekly utilization for each staff member. Rows are grouped by department. Colors: white (0%), blue (1-50%), green (51-79%), yellow (80-99%), orange (100%), red (>100%). Each cell shows assigned hours.
Staff Roster ?Manage your team. Click any cell to edit inline. Add or remove staff members as needed. Use filters to narrow by department or status.
?Add a new staff member to the roster with default values. Edit their details inline after adding.
Name ?Full name of the staff member.
Role ?Job title or role (e.g., Project Manager, Engineer, Planner).
Department ?Department or team grouping. Used for heatmap row grouping.
Hrs/Wk ?Weekly available hours (typically 40 for full-time). Part-time staff can have fewer.
Cost Rate ?Hourly cost rate (salary + benefits + overhead) used for cost projections.
Bill Rate ?Hourly billing rate charged to clients. Used for revenue projections.
Skills ?Comma-separated list of skills, certifications, or specialties.
Status ?Active (available for assignments), On Leave (temporarily unavailable), or Inactive (no longer with firm).
Actions
Project Allocations ?View and manage staff assignments per project. Each project shows its team, hours gauge, and assignment details. Add or remove team members as needed.
?Add a new project to the plan. Edit details through the project edit modal.
Backlog Aging ?Shows remaining contract value (backlog) for each active project. Color-coded by completion: red (<50%), yellow (50-89%), green (90%+). Click column headers to sort.
Project ?Project name. Click to sort.
Client ?Client or agency name.
Contract Value ?Total contract value including amendments.
Billed ?Amount invoiced to date.
Remaining ?Contract Value minus Billed. This is the project backlog.
% Complete ?Billed / Contract Value as a percentage.
End Date ?Projected or contractual end date.
Months Left ?Calendar months from today to end date.
Backlog by Fiscal Year ?Bar chart showing total remaining backlog grouped by fiscal year. The dashed red line shows the annual revenue goal for comparison.
Workforce Planning Calculator ?Calculates staffing needs based on revenue goal, utilization target, and billing rates. Shows whether you need to hire or can release staff.
18-Month Burn Rate ?Projects monthly revenue (blue), cost (red), and margin (green fill) over the next 18 months based on current assignments and rates. Yellow dashed line shows the monthly revenue target.
Firm Settings ?Configure firm-wide financial targets and rates. These settings drive the workforce planning calculator, revenue projections, and backlog analysis.
PM Consolidator ?Leadership rollup tool. Import resource plans from multiple project managers, detect conflicts (staff assigned >40 hrs/week across PMs), and merge into a single view.
📂 Drag & drop PM resource plan JSON files here, or click to browse
?Combines all imported PM files into a single merged dataset. Detects staff assigned >40 hours/week across multiple PMs and flags conflicts for resolution.?Download the merged dataset as a JSON file for archiving or further analysis.?Download the merged staff and assignment data as a CSV file for use in Excel.