Simulator of profitability for Projects, works or events with Excel

By Admin
In Excel Tools
Mar 20th, 2017
0 Comments
374 Views

Simulator of profitability for Projects, works or events with Excel
The simulator of scenarios of profitability for projects with Excel developed by INDAWS 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.

Click on pictures to enlarge and navigate

 

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 

 

Try ERP ODOO Project managment here 

 

 

Dani Granero

Dani Granero

(ODOO Consultant and Controller)

www.indaws.es

Valencia – España

See you in Linkedin

Google+

Send me a note

Telephone: 00 34 963 81 64 34

Want to talk by skype or hangout? just contact us

Deja un comentario

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