Open AccessOptimal Alternatives by Controlling Time and Cost of a Multi-Level Car Park Using Excel-Solver Program
Author(s) -
Sada Abdalkhaliq Hasan
Publication year - 2019
Publication title -
xi'nan jiaotong daxue xuebao
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.308
H-Index - 21
ISSN - 0258-2724
DOI - 10.35741/issn.0258-2724.54.6.45
Subject(s) - solver , timeline , computer science , software , process (computing) , operations research , total cost , industrial engineering , engineering , operating system , mathematics , statistics , microeconomics , economics , programming language
In this research the best cost and time are identified to implement a multi-level car park. The aim of this research is to develop a time frame model, including time and cost analysis, and to find optimal alternatives for a multi-level garage project during the planning phase. The proposed model has been developed using Solver program in Excel built for combining cost and time calculations by adopting the Project Management Software (MS-Project) to facilitate optimal solution access. In future the same project can be implemented at the lowest possible cost. This research concluded that it is possible to obtain the optimal solution after analyzing the alternatives using the Solver program and then taking the results of the optimization process to perform the improvement of the timeline. The research highlights the factors such as: the estimated cost, the planned time and the alternatives available for optimum performance aimed at finding optimal solutions and thus enhancing overall performance. The research was applied to the case study of one of the projects implemented within the city and found that the results are consistent with the research objective. According application of the model, the solution shows it will reduce cost and time to about 190292 $ and 91day from the cost and time of actual project.