292x 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 |
no reviews yet
Please Login to review.