CONSTRUCTION METHODS AND

PROJECT MANAGEMENT
CE0063
ENGR. MARY GRACE M. VENTANILLA - CALILUNG
 MODULE 4
COMPUTER APPLICATION AND
CONSTRUCTION REPORTS
By: Engr. Mary Grace M. Ventanilla - Calilung
EXCEL WORKSHEET
MAKING PROGRAM OF WORKS

By: Engr. Mary Grace M. Ventanilla - Calilung

Ø All materials estimated will be considered in
canvassing the current price.
Ø All personnel / professional involved will be
considered
Ø All equipment that may be used shall be considered
ü Each material will be quantified and multiplied to its
unit price. Example of Cost Estimate:
Quantity Unit of Description Unit Price Amount
Measure
1240.00 pcs. CHB 6” 12.50 15,500.00
Based on 45.00 bags Cement Based on 230.00 10,350.00
estimate 18.50 cu.m Sand canvass 540.00 9,990.00
Material Cost 35,840.00
Labor Cost % x Material Cost
Direct Cost MC + LC
Mark - Up % x Direct Cost
Can be in
sq.m, cu.m,
VAT 12% (DC + MU)
Total Cost DC + MU + VAT
lm, pcs, sets
Unit Cost TC / Quantity of each
item of work
ONLY THE QUANTITY AND UNIT COST should be the
same with the cost estimate and summary.
Using the cost estimate and labor rate
1 Gang
1:1:2 1 CF:1SL:2UL
1:2 1 CF:2UL
Using the cost estimate and labor rate
Using the duration of activities, plot it on your bar chart
Notice to Proceed, NTP
Actual Starting Date
Contract Duration
Target Completion Date
Actual Completion Date
Suspension
Resume
Revised Target Completion Date, RTCD
Example: Given Find
Month Days
Notice to Proceed, NTP : August 24, 2020 Aug 2020 8
Actual Starting Date : August 24, 2020 Sept 2020 30
Contract Duration : 180 Calendar Days Oct 2020 31
Target Completion Date : February 19, 2020
Nov 2020 30
Actual Completion Date : January 30, 2020
Dec 2020 31
Suspension : November 8, 2020
Jan 2021 31
Resume : November 15, 2020
Revised Target Completion Date : February 26, 2021 Feb 2021 19
Total 180
Actual Accomplishment (%), AA
𝑻𝒐𝒕𝒂𝒍 𝑨𝒎𝒐𝒖𝒏𝒕 𝒄𝒐𝒏𝒔𝒖𝒎𝒆𝒅 𝒂𝒔 𝒕𝒐 𝒅𝒂𝒕𝒆
𝑨𝑨 = 𝒙 𝟏𝟎𝟎
𝑪𝒐𝒏𝒕𝒓𝒂𝒄𝒕 𝑨𝒎𝒐𝒖𝒏𝒕

Scheduled Accomplishment (%), SA

𝑵𝒐. 𝒐𝒇 𝒅𝒂𝒚𝒔 𝒄𝒐𝒏𝒔𝒖𝒎𝒆𝒅 𝒂𝒔 𝒕𝒐 𝒅𝒂𝒕𝒆
𝑺𝑨 = 𝒙 𝟏𝟎𝟎
𝑪𝒐𝒏𝒕𝒓𝒂𝒄𝒕 𝑫𝒖𝒓𝒂𝒕𝒊𝒐𝒏

Slippage, S
𝑺 = 𝑨𝑨 − 𝑺𝑨
Example 1: Given Find
Notice to Proceed, NTP : August 24, 2020 Actual Completion Date : January 30, 2021
Actual Starting Date : August 24, 2020 Contract Amount : P 13,876,922.18
Contract Duration : 180 Calendar Days
Billing is every 30 days. The amount consumed per billing is given:
Billing No. of days Amount per Billing AA SA SLIPPAGE
No. consumed (%) (%) (%)
1 30 2,345,678.90 16.90 16.67 0.23
2 60 3,122,654.27 39.40 33.33 6.07
3 90 2,110,818.18 54.62 50.00 4.62
4 120 2,099,233.17 69.74 66.67 3.07
5 150 2,965,443.26 91.11 83.33 7.78
6 160 1,233,094.40 100.00 88.89 11.11
PHP 13,876,922.18
Example 2: Given Find
Notice to Proceed, NTP : August 24, 2020 Actual Completion Date : January 30, 2021
Actual Starting Date : August 24, 2020 Contract Amount : P 13,876,922.18
Contract Duration : 180 Calendar Days
Billing is every 30th day of the month. The amount consumed per billing is given:
Billing Date No. of days Amount per Billing AA SA SLIPPAGE
No. consumed (%) (%) (%)
1 Aug. 30 ‘20 7 2,345,678.90 16.90 3.89 13.01
2 Sept. 30 ‘20 38 3,122,654.27 39.40 21.11 18.29
3 Oct. 30 ‘20 68 2,110,818.18 54.62 37.78 16.84
4 Nov. 30 ‘20 99 2,099,233,17 69.74 55.00 14.74
5 Dec. 30 ‘20 129 2,965,443.26 91.11 71.67 19.44
6 Jan. 30 ‘21 160 1,233,094.40 100.00 88.89 11.11
PHP 13,876,922.18
STATEMENT OF WORK
ACCOMPLISHED
PROGRESS BILLING

By: Engr. Mary Grace M. Ventanilla - Calilung

Progress Billing
ØMade at an interval specified in the contract
Retention
ØA guarantee against defective work to ensure that the
remaining work can be completed within the unpaid
amount of the contract
Example of Progress Billing

This Billing from Statement of Work Accomplished is

done only if you are already in the contract
(proclaimed winner in the bidding). This example is
for demonstration only.
RETENTION PAYMENT

By: Engr. Mary Grace M. Ventanilla - Calilung

Example 1: Given Find
Contract Amount : P 13,876,922.18
Billing is every 30 days. The amount consumed per billing is given:
Billing No. Amount per Billing Retention Amount Amount Due to
(This Billing) (10%) Contractor
1 2,345,678.90 234,567.89 2,111,111.01
2 3,122,654.27 312,265.43 2,810,388.84
Amount received by
3 2,110,818.18 211,081.82 1,899,736.36
the contractor every
4 2,099,233.17 209,923.32 1,889,309.85
billing
5 2,965,443.26 296,544.33 2,668,898.93
6 1,233,094.40 123,309.44 1,109,784.96
PHP 13,876,922.18 PHP 1,387,692.23 PHP 12,489,229.95

Typically collected one

month after completion
 CASH FLOW AND
PAYMENT SCHEDULE
By: Engr. Mary Grace M. Ventanilla - Calilung
Just send me your questions and / or
request for an online discussion
through canvas