Simulator of profitability for Projects, works or events with Excel

By Dani Granero
In Controlling Tools
Ene 5th, 2018
0 Comments
783 Views

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.

project-profitability-and-treasury-planning-with-excel

material-costs-for-projects-simulattions-with-excel

direct-labour-cost-planning-for-project-simulation-Excel

outsourcing-costs-planning-for-projects-simulations-with-excel

project-control-simulation-with-excel

projects-costs-and-sale-prices-simulations-with-excel

projects-costs-calculation-with-excel

projects-sales-price-and-margins-simulations-with-excel

projects-sales-forecast-with-excel

general-expenses-planning-for-projects-simulations-with-excel

indirect-overhead-labour-costs-allocation-for-projects-simulators-excel

projects-PL-result-simulator-with-excel

project-quotation-simulator-model-with-excel

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

Balanced Scorecard download

Free file download here  Visit here all my Excel templates

Posted by: Dani Granero

Contact information

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

Este sitio web utiliza cookies para que usted tenga la mejor experiencia de usuario. Si continúa navegando está dando su consentimiento para la aceptación de las mencionadas cookies y la aceptación de nuestra política de cookies, pinche el enlace para mayor información.plugin cookies

ACEPTAR
Aviso de cookies