Integrating Task Fragmentation and Earned Value Method Into the Last Planner System Using Spreadsheets

José L. Ponz-Tienda1, Eugenio Pellicer2, Luis F. Alarcón33 & Juan S. Rojas-Quintero4

1Assistant Professor, Dep. of Civil and Environmental Engineering. Director of Construction Engineering and Management, Universidad de Los Andes, Bogotá, Colombia, (57-1) 3324312, jl.ponz@uniandes.edu.co
2Associate Professor, School of Civil Engineering, Universitat Politécnica de València, Valencia, Spain, (34) 963879562, pellicer@upv.es
3Professor, Dept. of Construction Engineering and Management, Universidad Católica de Chile, Escuela de Ingeniería, Santiago, Chile, (56-2) 2354 4201, lalarcon@ing.puc.cl
4Instructor, Department of Civil and Environmental Engineering. Universidad de Los Andes, Bogotá, Colombia, (57-1) 3324312, js.rojas128@uniandes.edu.co

Abstract

Construction schedulers make use of several tools as project management software of general purpose and spreadsheets for applying the Last Planner System of Production Control. This widespread practice has the disadvantage of working with questionable algorithms and models difficult to adapt to the construction industry, besides having to work with disconnected and complex information to manage data. In this paper a new layout and computation of multidimensional non-cyclic directed graphs based on its adjacency matrices is presented. All the precedence relationships are considered, in addition to the optimal and discretionary fragmentation of task in real conditions with work and feeding restrictions. This approach has been implemented with Visual Basic for Excel. A new approach for the representation and computation of projects for the Last Planner System of Production Control is presented. This approach is integrated with the management of the Earned Value and ad-hoc complex optimization. LPSTM, CPM, EVM and PPC are found to be complementary, and the Zaderenko´s algorithm modified and implemented in Excel can be used to integrate them.

Keywords

Lean construction, Last Planner System, Construction Scheduling with spreadsheets.

Files

Reference

Ponz-Tienda, J.L. , Pellicer, E. , Alarcón3, L.F. & Rojas-Quintero, J.S. 2015, 'Integrating Task Fragmentation and Earned Value Method Into the Last Planner System Using Spreadsheets' In:, Seppänen, O., González, V.A. & Arroyo, P., 23rd Annual Conference of the International Group for Lean Construction. Perth, Australia, 29-31 Jul 2015. pp 63-71

Download: BibTeX | RIS Format