Optimizing Project Portfolio Schedules Under Financial Constraints: A Practical Tool for Cash Flow Management

This master’s degree thesis introduces a tool for managing portfolio schedule with financial constraints. The objective is to develop a model which helps organizations schedule their whole portfolio avoiding any negative cash flow balance while getting the highest profit possible. The tool operates...

Descripción completa

Detalles Bibliográficos
Autor: Vallery Haryanto, Valentine
Tipo de recurso: tesis de maestría
Fecha de publicación:2025
País:España
Institución:Universidad de Valladolid
Repositorio:UVaDOC. Repositorio Documental de la Universidad de Valladolid
OAI Identifier:oai:uvadoc.uva.es:10324/76910
Acceso en línea:https://uvadoc.uva.es/handle/10324/76910
Access Level:acceso abierto
Palabra clave:Portfolio Management
Multi-Project Scheduling
Financial-Constraints
Optimization
5311 Organización y Dirección de Empresas
Descripción
Sumario:This master’s degree thesis introduces a tool for managing portfolio schedule with financial constraints. The objective is to develop a model which helps organizations schedule their whole portfolio avoiding any negative cash flow balance while getting the highest profit possible. The tool operates within Excel and allows users to input the organization’s financial data and gives a real time preview of their finance condition. To better understand organization´s scheduling performance, this model lets users explore different scenarios and instantly see how each changes affect cash flow and profitability. Its intuitive design makes it easy to spot overhead costs and adjust project schedule. With its real-time adaptability, users can make explore schedules that help balance resources and reduce financial risks. The tool is designed to guide users and provide insights for making strategic decisions.