
Calculate manpower required for a project
The number of employees needed for a project has to be calculated.
To do this, enter the available time (14 days) for the project in cell
A2. Cell B2 contains the number of working hours per day (8.5).
Cell C2 shows the current number of employees. Now we can cal-
culate how many employees are needed to reduce the project
duration or change the number of daily working hours of the
employees.
4
To calculate the desired number of employees:
1. Enter different combinations of desired days in column A
and daily working hours in column B.
2. Select cell E2 and insert the formula =A2*B2*C2 to calcu-
late the total working ...