Cost and Time Comparison Analysis Using Microsoft Project (Case Study: Phase VII Work of the Surabaya Tanjung Perak Berlian Pier Structure Strengthening Project)

new schedule using Microsoft Project tools and the Critical Path Method (CPM). The results of this study obtained a rescheduling duration of 99 days, 22 days faster than the actual planned duration of 121 days, and a fee of IDR. 28,535,441,605 of the initial planned cost of IDR. 35,017,986,296.10.


Introduction
Construction projects are a series of sensitive work mechanisms because every aspect of a construction project influences one another [1].During the implementation of construction projects, there is often a discrepancy between the planned schedule and the realization on the ground which can result in an increase in implementation time and an increase in implementation costs so that project completion is hampered [2].The causes of delays that often occur are due to changes in the project situation, design changes, the influence of weather factors, inadequate workers, material or equipment needs, planning errors, or specifications [5].Delays in the implementation of construction projects can be overcome by accelerating the Available online at https://jurnalteknik.unisla.ac.id/index.php/CVLhttps://doi.org/10.30736/cvl.v2i2implementation to achieve the target plan [20].In this study, to be able to carry out a construction project such as the Tanjung Perak Diamond Pier Structural Strengthening Work project in Surabaya, project management is required.In a job, it is found that one of the obstacles that is often encountered in the field in the Tanjung Perak Surabaya Diamond Pier Structural Strengthening Work project is the time condition, This is because in carrying out the initial planning the planners did not consider the time calculations that would occur during project implementation.The impact caused by the short time condition is the delay in the project which increases the duration of the work and the budget for the implementation of the project.In overcoming project delays that occur due to a short time, it is necessary to reschedule the development project, to facilitate project rescheduling in carrying out each project activity, it is necessary to do it sequentially and on time [4].To start calculating project costs, you need to use software starting from Microsoft Excel, Microsoft Project, and others [3].In this study, the authors used software, namely (software) Microsoft Project, for the basis of calculations on Microsoft Project using the Critical Path Method (CPM) as a support for this research [6].
By the research background described above, this study proposes problem identification, namely calculating how much money is obtained after rescheduling with Microsoft Project using the Critical Path Method (CPM) [7].In this study, there is also a need to limit writing problems due to limited data [9].The limitations of the problem are first, rescheduling is done using special scheduling software, namely Microsoft Project 2019, for basic calculations on Microsoft Project using the Critical Path Method (CPM) [8].Second, this study only analyzes the work of stage VII kade 426 to 228 on the Tanjung Perak Diamond Pier Structure Strengthening Work project in Surabaya.And third, this research is only rescheduling to speed up project implementation [10].
From the description of the existing problem formulation, the focus of this study aims to compare the results of the total duration and final costs of implementing the project after rescheduling with the Microsoft Project [11].

Research Method
The following is a flowchart of the research implementation of the Rescheduling of the Tanjung Perak Berlian Pier Structural Strengthening Project, Surabaya using Microsoft Project.
(Source: Author, 2023) Figure 1.The flowchart above is an explanation of the research flow used to solve the research problem

Rescheduling of the Surabaya Tanjung Perak Berlian Pier Structure Strengthening Project
The following are the steps required in rescheduling: 1. Perform RAB calculations in which the volume and unit price of each job are obtained, and in rescheduling this the direct costs do not change, This is because there is no additional volume of work, and the indirect costs have changed, this is due to -costs related to indirect costs will still increase with increasing duration and schedule discrepancies.[17] The following is the initial plan for RAB recapitulation: 2. After the unit price for each job is obtained from the Budget Plan, the next step is to calculate the total cost of each job, while calculating the total cost of each job.3.After obtaining the total cost of each job and the value of the project, the next step is to calculate the weight of the work.4. The next step is to calculate the productivity of each job in a day, The Tanjung Perak Diamond Pier Structure Strengthening project in Surabaya has 8 hours of work per day, but before going further in the calculation of the previous productivity, productivity/hours is required for each each job and for the equation used for each job each is different depending on the main equipment to assist in doing the job. 5.The next step is to calculate the duration of each job.The data needed to calculate the duration of the work are the work productivity in a day and the volume of the work.6.After getting the duration of the work, it can be seen the number of variations that occur between the duration of the plan and the duration of the rescheduling results.
Rescheduling is done by putting the realization in the field in the form of a schedule to get a logical and realistic schedule.[18] In the planned schedule, the duration needed to complete the project at this stage is 90 days, and in reality, there is a delay of up to 121 days.From the two durations, a variation of 31 days is obtained, for 31 days the indirect costs will continue, therefore 8.After all the series of steps in scheduling using Microsoft Project 2019, the rescheduling stage has been completed and the following is the result of rescheduling using Microsoft Project 2019 in the form of a display of duration after rescheduling and calculating the total cost.

Discussion of Data
After analyzing using Microsoft Project 2019, the following results are obtained: 1.The duration obtained after rescheduling is 99 days, starting from 08 January 2022 and ending on 18 April 2022 with 2 special days off.The realization in the field starts on January 8 and ends on May 10, 2022, with a total of 121 days.
Display of Ms. Project duration results obtained 2. Some work items do experience ups and downs in price value.This is because when rescheduling is carried out, the duration is added and also reduced to obtain a project duration that is completed on time.So the value also changes and goes up and down so that you get the results you want.The total cost of each job obtained using Microsoft Project 2019 is as shown in Table 1 below: Based on the previous explanation regarding the data that has been obtained, it appears that this rescheduling requires a shorter time when compared to its implementation in the field.This is because in carrying out rescheduling it is by the realization in the field as outlined in the form of a schedule.In the planned schedule that is realized in the field, it takes a duration of 121 days with 2 special holidays to complete the work at this stage, while for rescheduling results it only takes a duration of 99 days with 2 special holidays to complete the work project at this stage.There is a visible comparison, namely the results of rescheduling, the completion of which is 22 days faster than the actual schedule in the field.
The schedule realized in completing the 7th phase of this project which will affect the duration of completing all stages of this project which will be faster.The results of this rescheduling will also affect the amount of costs obtained in completing the 7th phase of this project to be reduced.
The total cost obtained from the rescheduling results is IDR 28,535,441,605, with details of the costs of work activities that go through the critical path of Rp. 3,489,250,680.00 and work activities that do not go through the critical path of IDR 25,046,190,925.Compared to the initial cost of the work plan in stage 7 of this project which amounted to 35,017,986,296.10, the total cost of rescheduled results is less and the use is efficient so that the project is completed more quickly.As for the indirect costs that have increased due to variations/delays in the implementation of phase 7 of the Tanjung Perak Pier Structure Strengthening project, Surabaya, this is IDR 4,280,316,240.75 consisting of 10% profit and 5% overhead from the rescheduled Project value.So the total Budget Plan is obtained from the rescheduling results of IDR 32,815,757,845.75.So the total Budget Plan from the rescheduling results is less than the total cost of the planned budget that has been added with a total indirect cost of IDR 39,122,872,467.44.The cost of rescheduling the work in stage 7 will also have an impact on the overall total project completion costs which will be reduced and also effective in completing project work so that it can be completed more quickly.

Conclusion and Suggestion 5.1 Conclusion
From the existing data, the initial plan for phase 7 work at the Berlian Tanjung Perak pier strengthening project in Surabaya, the total duration realized in the field required a duration of 121 days, while rescheduling results only required a duration of 99 days.A comparison can be seen, namely the results of the rescheduling which was completed 22 days faster than the actual schedule in the field.From the existing initial plan data, it is also known that the total cost of the RAB is IDR 35,017,986,296.10,while the result after rescheduling is IDR 28,535,441,605 so the known difference is IDR 6,482,544,691.1.There is a comparison, namely the total cost of rescheduled results is less and the use is efficient so that the project is completed more quickly.From the results of the duration and costs obtained from the rescheduling of phase 7 work on the Berlian Tanjung Perak Surabaya pier structure strengthening project compared to the existing project realization plan data it is better and more effective.

Suggestion
Contractors and consultants are advised to work together in improving project control to identify factors that hinder work and cause delays in project implementation.The aim is to conduct an earlier evaluation of these factors so that delays do not occur again in phase VIII and subsequent stages of the Tanjung Perak Surabaya Diamond Pier Structure Strengthening project.In this case, the delay also has an impact on increasing the overall costs listed in the project's Budget Plan (RAB).

Table 1 .
RAB recapitulation The next step is to calculate the amount of indirect costs incurred during the delay, The following are the calculation steps: A. Costs in construction projects are divided into two, namely Project Budget Plan and Execution Budget Plan From project data obtained Budget Plan contains information related to items needed to complete a project as a whole while the Execution Budget Plan contains information related to costs needed for resources each job.[19]B. To simplify the calculation, it will be assumed that the indirect cost is 15% according to the Regulation of the Policy Agency for Procurement of Goods or Services (LKPP) Number: 12 of 2021, Concerning Guidelines for the Implementation of Procurement of Goods/Services through Providers, that Calculation of Self-Plan costs.From the data obtained, it is known that the Budget Plan value is Rp.35,017,986,296.10 2. After obtaining the results of the Total Budget Plan calculation, we calculate the indirect costs which consist of 2 parts with the following division: Overhead (with a variation of 31 days) = IDR.3,501,798,629.61+ IDR.603,087,541.73=IDR.4,104,886,171.34Afterthe total indirect costs are obtained, the final step is to calculate the total amount of the budget plan by adding up the plan budget plus the total indirect costs.After the total indirect costs are obtained, the final step is to calculate the total amount of the budget plan by adding up the plan budget plus the total indirect costs.After obtaining the duration for each job, the next step is to continue using Microsoft Project.In doing this rescheduling using Microsoft Project 2019 with the steps mentioned in the previous chapter.
Construction Works of 15%.In this calculation, it is assumed that 15% indirect costs consist of 5% overhead from the Budget Plan and 10% profit from the Budget Plan.C. For more details, here are the steps for the calculation: 1. Knowing the amount of RAB obtained from project data, namely the total Project Value plus the indirect project costs of 10% multiplied by the Execution Budget 176 Cost and Time Comparison Analysis Using Microsoft Project (Case Study: Phase VII Work of the Surabaya Tanjung Perak Berlian Pier Structure Strengthening Project) 177 Cost and Time Comparison Analysis Using Microsoft Project (Case Study: Phase VII Work of the Surabaya Tanjung Perak Berlian Pier Structure Strengthening Project)

Table 2 .
Total Cost of Each Job Using Microsoft Project 2019 The total Budget Plan after rescheduling is IDR 28,535,441,605 of the Total Budget Plan obtained from the data for the 7th phase of the work project of IDR Rp. 35,017,986,296.10.