Optimization Cost for Concrete Work by Solver Function

Abstract

The purposes of the study on optimization cost for concrete work by Solver Function were 1) to study the resources allocation on concrete work to reach the optimization cost, 2) to use the Solver Function in Microsoft Excel Program for cost function and decision making. This research was carried out in the form of record and observation. The data got were analyzed, determined variables and equation of objectives, and limit or scope of variables. The steps included 1) data got from record and observation, and 2) data got from Solver Function inMicrosoft Excel Program. The instrument used was observation form of Solver Function to find the optimization cost on concrete work. The sample group was 2 zones and 12 floors residence building. The research result of the Solver Function to find the optimization cost (Part 1) revealed that it was in accordance with the determined purpose of studying the resources allocation on concrete work to meet the optimization cost, and to use the Solver Function in the Microsoft Excel Program to find out more appropriate cost and decision making, and (Part 2) it was in accordance with the conditions of hypothesis, which was, using Solver Function could help make decision of resources allocation to work. To Save costs in the future and also be useful for cost planning next time.