How to Calculate the number of employees needed for a project
We were asked by one of our clients to develop a workbook that can calculate the number of employees needed for a construction project. In our example. we did this by entering the available time (60 days) for the project in cell A2. In Cell B2, we enter the number of working hours per day (6). Cell C2 will display the current number of employees. With this layout, we can calculate how many employees are needed to reduce the project duration or change the number of daily working hours of the employees. This will work in Excel 97, 2000, 2003 and 2007.
How To calculate the desired number of employees:
- You can experiment by changing the number of desired days in column A and daily working hours in column B.
- Select cell E2 and insert the formula =A2*B2*C2 to calculate the total working hours of the project.
- Select cells C4:C10 and type the following formula: =ROUNDUP(C$2*A$2*B$2/(A4*B4),0).
- Press CTRL+Enter.
- Select cells E4:E10 and type the following formula: =A4*B4*C4.
- Press CTRL+Enter
