Filetype Excel XLSX | Posted on 15 Aug 2022 | 3 years ago
Authentication
digital resources
331x Filetype XLSX File size 1.32 MB Source: www.smartsheet.com
Sheet 1: EX - Capacity Planning Template
| CAPACITY PLANNING TEMPLATE | |||||||
| CAPACITY PLAN DASHBOARD | |||||||
| ACTION REQUIRED | RECOMMENDATION | TOTAL PROJECT DEMAND | EFFECTIVE CAPACITY | RESOURCE DEFICIENCY | |||
| Recommended addition of 7 more resource(s). | INCREASE CAPACITY | 2,182.00 | 2,002.00 | 7 | |||
| (HOURS) | (HOURS) | (PEOPLE) | |||||
| User to complete non-shaded fields only. Dashboard will populate automatically. | |||||||
| DEMAND ESTIMATE | CAPACITY OVERVIEW | ||||||
| PROJECT NAME | HOURS REQUIRED per WEEK |
TOTAL EMPLOYEES |
WORKING HOURS per WEEK |
UTILIZATION RATE ( % ) |
|||
| Project 1 | 80.00 | 77.00 | 40.00 | 65% | |||
| Project 2 | 80.00 | ||||||
| Project 3 | 120.00 | POTENTIAL WORK CAPACITY | EFFECTIVE CAPACITY |
||||
| Project 4 | 160.00 | 3,080.00 | 2,002.00 | ||||
| Project 5 | 40.00 | ||||||
| Project 6 | 32.00 | ||||||
| Project 7 | 24.00 | ||||||
| Project 8 | 50.00 | ||||||
| Project 9 | 100.00 | ||||||
| Project 10 | 100.00 | ||||||
| Project 11 | 20.00 | ||||||
| Project 12 | 200.00 | ||||||
| Project 13 | 400.00 | ||||||
| Project 14 | 40.00 | ||||||
| Project 15 | 16.00 | ||||||
| Project 16 | 240.00 | ||||||
| Project 17 | 160.00 | ||||||
| Project 18 | 80.00 | ||||||
| Project 19 | 40.00 | ||||||
| Project 20 | 200.00 | ||||||
| CLICK HERE TO CREATE IN SMARTSHEET | |||||||
| CAPACITY PLANNING TEMPLATE | |||||||
| CAPACITY PLAN DASHBOARD | |||||||
| ACTION REQUIRED | RECOMMENDATION | TOTAL PROJECT DEMAND | EFFECTIVE CAPACITY | RESOURCE DEFICIENCY | |||
| Staffing levels appear to be sufficient. | NONE | 0.00 | 0.00 | 0 | |||
| (HOURS) | (HOURS) | (PEOPLE) | |||||
| User to complete non-shaded fields only. Dashboard will populate automatically. | |||||||
| DEMAND ESTIMATE | CAPACITY OVERVIEW | ||||||
| PROJECT NAME | HOURS REQUIRED per WEEK |
TOTAL EMPLOYEES |
WORKING HOURS per WEEK |
UTILIZATION RATE ( % ) |
|||
| Project 1 | 0.00 | 0.00 | 0.00 | 0% | |||
| Project 2 | 0.00 | ||||||
| Project 3 | 0.00 | POTENTIAL WORK CAPACITY | EFFECTIVE CAPACITY |
||||
| Project 4 | 0.00 | 0.00 | 0.00 | ||||
| Project 5 | 0.00 | ||||||
| Project 6 | 0.00 | ||||||
| Project 7 | 0.00 | ||||||
| Project 8 | 0.00 | ||||||
| Project 9 | 0.00 | ||||||
| Project 10 | 0.00 | ||||||
| Project 11 | 0.00 | ||||||
| Project 12 | 0.00 | ||||||
| Project 13 | 0.00 | ||||||
| Project 14 | 0.00 | ||||||
| Project 15 | 0.00 | ||||||
| Project 16 | 0.00 | ||||||
| Project 17 | 0.00 | ||||||
| Project 18 | 0.00 | ||||||
| Project 19 | 0.00 | ||||||
| Project 20 | 0.00 |
