- Monthly corporate earnings
- Yearly project earnings
- Yearly project profit margin
- Employee productivity rate
The other worksheets within this consolidation model allow you to input your financial information relating to each project. In these tabs you can input data such as:
- Project expenses
- Salaries and benefits
- Equipment expenses
- Billable and non-billable hours
These inputs are then used to calculate your total costs, profit margin, total work hours and productivity rates.
Screenshot from the model.
Using this consolidation model will allow you to conduct a thorough analysis of each of your projects in regard to its financial and productivity performance. You will be able to unite the financial analysis of all of your projects in one dedicated dashboard that will provide and visualize all of the key financial information.
The dashboard visualizes some of the key financial information relating to all of your business' projects on both a monthly and yearly basis. It details the: