Master Data
Project Category Workloads
Foundation DataProject Category Workloads define standard effort estimates by department.
Business Explanation
Plain-language context for planners and operations leaders.
Business Explanation
Plain-language context for planners and operations leaders.
What is this?
Project Category Workloads define the standard work expected from each department for one Project Category Template, such as Retail Store - Medium.
Why is it needed?
They turn a project type and complexity into practical planning assumptions: which departments are involved, how many standard hours each department needs, the minimum skill level needed, the usual number of people/resources to plan, and the maximum useful daily team size.
How is it used later?
When a planner creates a future project and selects its category and complexity, the system can load these workload rows as the starting estimate. Minimum Skill means at least one resource of that skill must be available for the stage to progress. Max Resources Per Day caps how many resources the simulator can use for that workload on any day.
Example Template Rows
| Project Category Template | Department | Standard Hours | Minimum Skill | Recommended Resource Count | Max Resources Per Day | Remarks |
|---|---|---|---|---|---|---|
| Retail Store - Medium | DES | 40 | M | 1 | 1 | Design estimate for this template |
| Retail Store - Medium | JOIN | 120 | SR | 4 | 4 | Joinery needs at least one senior and max four resources per day |
Filling Rules and Accepted Values
- Do not rename or remove template column headers.
- Required columns: Project Category Template, Department, Standard Hours, Minimum Skill, Recommended Resource Count, Max Resources Per Day.
- Whole-number columns: Recommended Resource Count, Max Resources Per Day.
- Decimal-number columns: Standard Hours.
- Project Category Template: PERMANENT - COMPLEX, PERMANENT - MEDIUM, PERMANENT - SIMPLE, SPAA - COMPLEX, SPAA - MEDIUM, SPAA - SIMPLE, SPAA-FIXED - COMPLEX, SPAA-FIXED - MEDIUM, plus 1 more existing values.
- Department: PPO JOINERY (PPO-JOINERY), PPO METAL (PPO-METAL), MACHINE SHOP (MACHINE-SHOP), MDF STRUCTURE PERMANENT (MDF-STR-PER), MDF STRUCTURE SPAA (MDF-STR-SPAA), METAL FAB (METAL-FAB), METAL POLISH (METAL-POLISH), PAINT (PAINT), plus 6 more existing values.
- Minimum Skill: Low (L), Medium (M), High (H).
Search and Templates
Find records or move setup data with a spreadsheet template.
Add Project Category Workloads
Maintain the setup information used by future planning.
Project Category Workloads Records
Search, edit, and activate or deactivate records for this area.
| Template ID | Department | Hours | Minimum Skill | Resources | Max / Day | Status | Actions |
|---|---|---|---|---|---|---|---|
| SPAA - COMPLEX | ACRYLIC (ACRYLIC) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - MEDIUM | ACRYLIC (ACRYLIC) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - MEDIUM | ACRYLIC (ACRYLIC) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - COMPLEX | ACRYLIC (ACRYLIC) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - SIMPLE | ACRYLIC (ACRYLIC) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - MEDIUM | ACRYLIC (ACRYLIC) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - SIMPLE | ACRYLIC (ACRYLIC) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - COMPLEX | ACRYLIC (ACRYLIC) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - SIMPLE | ACRYLIC (ACRYLIC) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - MEDIUM | ELECTRICAL (ELECTRICAL) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - COMPLEX | ELECTRICAL (ELECTRICAL) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - SIMPLE | ELECTRICAL (ELECTRICAL) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - SIMPLE | ELECTRICAL (ELECTRICAL) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - SIMPLE | ELECTRICAL (ELECTRICAL) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - COMPLEX | ELECTRICAL (ELECTRICAL) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - MEDIUM | ELECTRICAL (ELECTRICAL) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - COMPLEX | ELECTRICAL (ELECTRICAL) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - MEDIUM | ELECTRICAL (ELECTRICAL) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - MEDIUM | INSTALLATION (INSTALLATION) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - COMPLEX | INSTALLATION (INSTALLATION) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - MEDIUM | INSTALLATION (INSTALLATION) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - MEDIUM | INSTALLATION (INSTALLATION) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - COMPLEX | INSTALLATION (INSTALLATION) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - COMPLEX | INSTALLATION (INSTALLATION) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - SIMPLE | INSTALLATION (INSTALLATION) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - SIMPLE | INSTALLATION (INSTALLATION) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - SIMPLE | INSTALLATION (INSTALLATION) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - COMPLEX | MACHINE SHOP (MACHINE-SHOP) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - MEDIUM | MACHINE SHOP (MACHINE-SHOP) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - COMPLEX | MACHINE SHOP (MACHINE-SHOP) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - MEDIUM | MACHINE SHOP (MACHINE-SHOP) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - SIMPLE | MACHINE SHOP (MACHINE-SHOP) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - SIMPLE | MACHINE SHOP (MACHINE-SHOP) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - MEDIUM | MACHINE SHOP (MACHINE-SHOP) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - SIMPLE | MACHINE SHOP (MACHINE-SHOP) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - COMPLEX | MACHINE SHOP (MACHINE-SHOP) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - SIMPLE | MDF FINAL PERMANENT (MDF-FIN-PER) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - COMPLEX | MDF FINAL PERMANENT (MDF-FIN-PER) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - MEDIUM | MDF FINAL PERMANENT (MDF-FIN-PER) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - SIMPLE | MDF FINAL PERMANENT (MDF-FIN-PER) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - SIMPLE | MDF FINAL PERMANENT (MDF-FIN-PER) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - MEDIUM | MDF FINAL PERMANENT (MDF-FIN-PER) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - MEDIUM | MDF FINAL PERMANENT (MDF-FIN-PER) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - COMPLEX | MDF FINAL PERMANENT (MDF-FIN-PER) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - COMPLEX | MDF FINAL PERMANENT (MDF-FIN-PER) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - SIMPLE | MDF FINAL SPAA (MDF-FIN-SPA) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - MEDIUM | MDF FINAL SPAA (MDF-FIN-SPA) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - SIMPLE | MDF FINAL SPAA (MDF-FIN-SPA) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - COMPLEX | MDF FINAL SPAA (MDF-FIN-SPA) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - MEDIUM | MDF FINAL SPAA (MDF-FIN-SPA) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - COMPLEX | MDF FINAL SPAA (MDF-FIN-SPA) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - MEDIUM | MDF FINAL SPAA (MDF-FIN-SPA) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - SIMPLE | MDF FINAL SPAA (MDF-FIN-SPA) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - COMPLEX | MDF FINAL SPAA (MDF-FIN-SPA) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - MEDIUM | MDF STRUCTURE PERMANENT (MDF-STR-PER) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - COMPLEX | MDF STRUCTURE PERMANENT (MDF-STR-PER) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - COMPLEX | MDF STRUCTURE PERMANENT (MDF-STR-PER) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - MEDIUM | MDF STRUCTURE PERMANENT (MDF-STR-PER) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - SIMPLE | MDF STRUCTURE PERMANENT (MDF-STR-PER) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - MEDIUM | MDF STRUCTURE PERMANENT (MDF-STR-PER) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - SIMPLE | MDF STRUCTURE PERMANENT (MDF-STR-PER) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - SIMPLE | MDF STRUCTURE PERMANENT (MDF-STR-PER) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - COMPLEX | MDF STRUCTURE PERMANENT (MDF-STR-PER) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - COMPLEX | MDF STRUCTURE SPAA (MDF-STR-SPAA) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - COMPLEX | MDF STRUCTURE SPAA (MDF-STR-SPAA) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - SIMPLE | MDF STRUCTURE SPAA (MDF-STR-SPAA) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - SIMPLE | MDF STRUCTURE SPAA (MDF-STR-SPAA) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - COMPLEX | MDF STRUCTURE SPAA (MDF-STR-SPAA) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - MEDIUM | MDF STRUCTURE SPAA (MDF-STR-SPAA) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - SIMPLE | MDF STRUCTURE SPAA (MDF-STR-SPAA) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - MEDIUM | MDF STRUCTURE SPAA (MDF-STR-SPAA) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - MEDIUM | MDF STRUCTURE SPAA (MDF-STR-SPAA) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - MEDIUM | METAL FAB (METAL-FAB) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - COMPLEX | METAL FAB (METAL-FAB) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - MEDIUM | METAL FAB (METAL-FAB) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - MEDIUM | METAL FAB (METAL-FAB) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - COMPLEX | METAL FAB (METAL-FAB) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - COMPLEX | METAL FAB (METAL-FAB) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - SIMPLE | METAL FAB (METAL-FAB) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - SIMPLE | METAL FAB (METAL-FAB) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - SIMPLE | METAL FAB (METAL-FAB) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - COMPLEX | METAL POLISH (METAL-POLISH) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - SIMPLE | METAL POLISH (METAL-POLISH) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - SIMPLE | METAL POLISH (METAL-POLISH) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - COMPLEX | METAL POLISH (METAL-POLISH) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - MEDIUM | METAL POLISH (METAL-POLISH) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - MEDIUM | METAL POLISH (METAL-POLISH) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - SIMPLE | METAL POLISH (METAL-POLISH) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - MEDIUM | METAL POLISH (METAL-POLISH) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - COMPLEX | METAL POLISH (METAL-POLISH) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - MEDIUM | PAINT (PAINT) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - SIMPLE | PAINT (PAINT) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - SIMPLE | PAINT (PAINT) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - COMPLEX | PAINT (PAINT) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - COMPLEX | PAINT (PAINT) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - COMPLEX | PAINT (PAINT) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - MEDIUM | PAINT (PAINT) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - MEDIUM | PAINT (PAINT) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - SIMPLE | PAINT (PAINT) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - MEDIUM | PPO JOINERY (PPO-JOINERY) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - SIMPLE | PPO JOINERY (PPO-JOINERY) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - SIMPLE | PPO JOINERY (PPO-JOINERY) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - MEDIUM | PPO JOINERY (PPO-JOINERY) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - SIMPLE | PPO JOINERY (PPO-JOINERY) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - COMPLEX | PPO JOINERY (PPO-JOINERY) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - COMPLEX | PPO JOINERY (PPO-JOINERY) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - MEDIUM | PPO JOINERY (PPO-JOINERY) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - COMPLEX | PPO JOINERY (PPO-JOINERY) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - SIMPLE | PPO METAL (PPO-METAL) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - COMPLEX | PPO METAL (PPO-METAL) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - SIMPLE | PPO METAL (PPO-METAL) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - MEDIUM | PPO METAL (PPO-METAL) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - SIMPLE | PPO METAL (PPO-METAL) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - COMPLEX | PPO METAL (PPO-METAL) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - COMPLEX | PPO METAL (PPO-METAL) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - MEDIUM | PPO METAL (PPO-METAL) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - MEDIUM | PPO METAL (PPO-METAL) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - SIMPLE | PRINT (PRINT) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - MEDIUM | PRINT (PRINT) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - SIMPLE | PRINT (PRINT) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA - COMPLEX | PRINT (PRINT) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - MEDIUM | PRINT (PRINT) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - MEDIUM | PRINT (PRINT) | 100.00 | High (H) | 1 | 4 | Active | |
| PERMANENT - COMPLEX | PRINT (PRINT) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - COMPLEX | PRINT (PRINT) | 100.00 | High (H) | 1 | 4 | Active | |
| SPAA-FIXED - SIMPLE | PRINT (PRINT) | 100.00 | High (H) | 1 | 4 | Active |