Simulator of profitability for Projects, works or events with Excel

Simulator of profitability for Projects, works or events with Excel
The simulator of scenarios of profitability for projects with Excel developed by Dani Granero is a tool that allows the decision making and the strategic planning of companies that work for projects, works or events.

It allows predefining costs of materials, direct personnel costs and costs of subcontracted companies for the development of project models which, depending on the estimated cost, can apply a sales price and thus simulate the profitability of the project.

We can perform the simulation for 50 different project types and plan the monthly sales by project type.
You can also plan general expenses, general staff costs, and investments, and spread the costs for previously defined activities.

Example of activities:
Activity planning
Management of budgets
Safety training plan
Supplier Control
Purchasing Management
Management of complaints and claims
Administration
Marketing

At the same time, the projects can be classified by families and the cost of the activities allocated to each family.

In this way, with the planning of sales of the projects, the planning and distribution of overheads an analytical result account is formed that allows us to perform profitability simulations.

In the following images you can see how this tool works.

The template is open and editable so you can adapt it to your company.

Posted by: Dani Granero

Contact information