Mechanical contracting company was growing and required a tool to review their current project hours for their engineers and project managers. The owners observed that all the employees were currently busy, but also needed a tool to predict the capacity the employees will have in one, two, or six months. The owners required an analysis to project when their employees were working at their maximum potential and when new employees should be hired for maximum efficiency in managing their client projects.
Man Hour Planning spreadsheet using Microsoft Excel
The company currently uses Procore for their project planning needs. The basic report features include project budgets, budgets versus actual, and actual time. Most software companies also provide specialized reporting, but require additional fees for their developers to create the reports. Depending on the company’s workload, it may take several months to receive the specialized report features. For a smaller business, this time is crucial for determining the next steps needed for their growth. An alternative tool for reporting needs is Microsoft Excel. The advantage for this project is that the tool is available on all their users’ computers, can be easily manipulated to provide the additional information to create specialized reports, and can be developed in a shorter timeframe.
The construction company now has a tool that provides them with their work hours for current employees for the upcoming 24 weeks. With this type of insight, the management now determines when they are going to have a slow down or ramp up, ensuring they are able to staff appropriately.