23rd Annual Conference of the International Group for Lean Construction - Perth, Australia - 2015

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, [email protected]
2Associate Professor, School of Civil Engineering, Universitat Politécnica de València, Valencia, Spain, (34) 963879562, [email protected]
3Professor, Dept. of Construction Engineering and Management, Universidad Católica de Chile, Escuela de Ingeniería, Santiago, Chile, (56-2) 2354 4201, [email protected]
4Instructor, Department of Civil and Environmental Engineering. Universidad de Los Andes, Bogotá, Colombia, (57-1) 3324312, [email protected]

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


Full Text
 

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, 23rd Annual Conference of the International Group for Lean Construction , 63-71. doi.org/

Download: BibTeX | RIS Format

 

Founded in 1993, the IGLC is an international network of researchers from practice and academia in architecture, engineering, and construction (AEC) who feel that the practice, education, and research of the AEC industry have to be radically renewed in order to respond to the global challenges ahead.

2015 © All Rights Reserved.