DETAILED UNIT PRICE ANALYSIS
Project Name: Provision of Potable Water System
Location: Brgy. Arado, Dulag, Leyte
ITEM I :  Tap Stand
    1)    QUANTITY:                20 Units
     2               Name and Specification            Quantity      Unit    Unit Price             Total Cost
            Cement                                       64         bags          290.00                         18,560.00
    M       Coarse Sand                                   6         cu.m.     700.00       P                      4,200.00
    A       12" thk CHB                                  442         pcs.      12.00       P                      5,304.00
    T
    E       10 mm. Ø RSB                                 138         pcs.     160.00       P                     22,080.00
    R       # 16 T.W.                                     5          kls.      75.00       P                        375.00
    I
    A       Hacksaw Blade                                 4          pcs.      55.00       P                        220.00
    L
    S
            Total Materials Cost                                                               P 50,739.00
                                                        No. of      No. of   Rate per
     3                   Name and Capacity                                                          Total Cost
                                                        Units       Hours     Hour
     E
     Q
     U
     I
     P
     M
     E
     N
     T
            Total Equipment Cost                                                                  P -
                                                                    No. of   Rate per
     4              Designation of Personnel          No. of Men                                    Total Cost
                                                                    Hours     Hour
    L
    A
    B
    O
    R       Total Labor Cost                                                                   P 17,758.65
     5      TOTAL DIRECT COST                                                              P                      68,497.65
     6      Direct Cost (5/1)                                                                                     #VALUE!
     7      CONTRACTOR PROFIT (10% X 5)                                                    P                      6,849.77
     8      OCM (Overhead, Contingencies & Miscellaneous) [10% OF 4]                       P                       6,849.77
    9       Indirect Cost                                                                  P                      13,699.53
    10      VAT ((5+9) * 12%)                                                              P                       9,863.66
    11      Total Cost Item                                                                P                      92,060.84
    12      UNIT COST OF ITEM (10/1)                                                                               #VALUE!
Prepared by :                                                      Approved by:
ENGR. ALICIA A. KINTANA                                            ATTY. MILDRED JOY P. QUE, CPA
    Municipal Engineer                                                         Mayor
                              DETAILED UNIT PRICE ANALYSIS
Project Name: Provision of Potable Water System
Location:Brgy. Cabatoan, Dulag, Leyte
ITEM I : EXCAVATION
   1)    QUANTITY:        248.39 cu.m.
    2           Name and Specification      Quantity      Unit     Unit Price         Total Cost
          Total Materials Cost                                                  P -
                                             No. of       No. of   Rate per
    3             Name and Capacity                                                   Total Cost
                                             Units        Hours     Hour
    E
    Q
          Mini Back Hoe                        1          184      P   875.00    P 161,000.00
    U
    I
    P
    M
    E
    N
    T
          Total Equipment Cost                                            P 161,000.00
                                                          No. of   Rate per
    4           Designation of Personnel   No. of Men                            Total Cost
                                                          Hours     Hour
    L
    A
    B
    O
    R     Total Labor Cost                                                      P -
    5     TOTAL DIRECT COST                                                     P       161,000.00
   6      Direct Cost (5/1)                                                               #VALUE!
   7      CONTRACTOR PROFIT (10% X 5)                                           P        16,100.00
   8      OCM (Overhead, Contingencies & Miscellaneous) [10% OF 4]              P        16,100.00
   9      Indirect Cost                                                         P        32,200.00
   10     VAT ((5+9) * 12%)                                                     P        23,184.00
   11     Total Cost Item                                                       P       216,384.00
   12     UNIT COST OF ITEM (10/1)                                                         #VALUE!
Prepared by :                                           Approved by:
ENGR. ALICIA A. KINTANA                                 ATTY. MILDRED JOY P. QUE, CPA
   Municipal Engineer                                             Mayor
0.00
  0
                                 DETAILED UNIT PRICE ANALYSIS
Project Name:
LocatioBrgy.Cabatoan, Dulag, Leyte
ITEM II Well Casing Develoment & Distribution Plumbing System
  1) QUANTITY:       L.S.
  2)           Name and Specification       Quantity    Unit    Unit Price     Total Cost
       Tap Stand Pipes & Distribution
       1/2" Ø x 90° G.I. ST. Elbow             52.00    pcs.         38.00 P         1,976.00
       1/2" Ø Brass Nipple                     52.00    pcs.        280.00 P        14,560.00
       1/2" Ø Schd. 40 G.I. Pipe               52.00    pcs.        460.00 P        23,920.00
       1/2" Ø Ball Valve                       52.00    pcs.        350.00 P        18,200.00
       1/2" Ø 90° G.I. Elbow                  156.00    pcs.         68.00 P        10,608.00
       1/2" Ø x 90° G.I. Elbow Red             26.00    pcs.         82.00 P         2,132.00
       1/2" Ø Schd. 40 G.I. Nipple             26.00    pcs.        160.00 P         4,160.00
       1/2" Ø G.I. Coupling                    52.00    pcs.         70.00 P         3,640.00
       1/2" Ø PE Pipe (SDRII)                  26.00    mtrs         75.00 P         1,950.00
       1/2" Corporation Stop (Brass)           26.00    pcs.        360.00 P         9,360.00
       1" Ø P.E. Pipe                          53.00    mtrs         65.00 P         3,445.00
       2" Ø P.E. Pipe                         480.00    mtrs
       3" Ø P.E. Pipe                         104.00    mtrs
       4" Ø P.E. Pipe                         118.00    mtrs
       Plastic Tapping Saddle                  26.00    pcs.         70.00 P         1,820.00
       1/2" Ø Heavy Duty Faucet                26.00    pcs.        414.00 P           380.00
       1/2" Ø x 0.15 m. G.I. Nipple            26.00    pcs.        230.00 P            70.00
       1/2" Ø x 0.20 m. G.I. Nipple            26.00    pcs.        285.00 P           160.00
       1/2" Ø x 0.50 m. G.I. Nipple            26.00    pcs.        480.00 P           180.00
       Water Tank Pipes
       2" Ø x 6.0m G.I. Pipe                     6.00   pcs.      1,200.00 P         7,200.00
       2" Ø G.I. Cap Sch. 40                     1.00   pcs.        200.00 P           200.00
       2" Ø C.I.Gate Valve                       2.00   pcs.      3,000.00 P         6,000.00
       2" Ø x 90° G.I. Elbow, Sch.40             2.00   pcs.      1,300.00 P         2,600.00
       2" Ø G.I. Pipe Sch. 40                    2.00   pcs.        600.00 P         1,200.00
       2" Ø G.I. Mech Coupling Adaptor           4.00   pcs.      1,400.00 P         5,600.00
       2" Ø G.I. Union                           8.00   pcs.        350.00 P         2,800.00
  M    2" Ø 0.6m G.I. Nipple                     1.00   pcs.         75.00 P            75.00
  A
  T    2" Ø 0.5 G.I. Nipple                      1.00   pcs.         75.00 P            75.00
  E    2" Ø 0.2 m. G.I. Nipple                   4.00   pcs.         75.00 P            75.00
  R
  I    2" Ø x 2" G.I. Bushing                    2.00   pcs.        240.00 P           480.00
  A    2" Ø G.I. Elbow 90°                       8.00   pcs.        220.00 P         1,760.00
  L
  S    2" Ø G.I. Elbow 45°                       6.00   pcs.        220.00 P         1,320.00
       Teflon Tape 1"                            7.00   rolls        40.00 P           280.00
       25 mm Ø Air Release Valve (1")            1.00    pc.      7,400.00 P         7,400.00
       Blow Off
       2" Ø G.I. Tee                             4.00   pcs.        220.00 P           880.00
       2" Ø G.I. Gate Valve                      2.00   pcs.      3,000.00 P           600.00
       Teflon Tape 1"                            3.00   rolls        40.00 P           120.00
       2" Ø G. I. Cap Sch. 40                    2.00   pcs.      200.00 P            400.00
       Well Casing Pipes
       6" Ø Eslon Blue Well Casing
       GI Pipe, 1 1/4" Ø, S40, 20"               4.00 length      1,400.00 P         5,600.00
       GI Pipe, 1 1/4" Ø,France                  5.00 pcs.          150.00 P           750.00
       GI Elbow, 1 1/4" Ø                        2.00   pc.         100.00 P           200.00
       GI Nipple, 11/4" Ø                        2.00   pc.          90.00 P           180.00
       HDPE Pipe 1 1/4", SDR11                   1.00   roll      7,500.00 P         7,500.00
       1 1/4" HDPE Compression Coupling          2.00   pc.         400.00 P           800.00
       1 1/4' PE Adaptor                         2.00   pc.         300.00 P           600.00
       PVC Blue, 1 1/4"                          2.00 length        198.00 P           378.00
       PVC Blue, Male Adaptor 1 1/4"              2.00        pc           250.00 P               500.00
       PVC Blue Elbow 1 1/14''                    5.00        pc.           25.00 P               125.00
       PVC Blue Female Adaptor 1 1/4"             2.00        pc.           60.00 P               120.00
       Well Seal, for 6" Well Casing              1.00        pc.         1,000.00 P            1,000.00
       Teflon Tape Big                           10.00        pc.           45.00 P               450.00
       Nylon String, # 300                        1.00        kg.          400.00 P               400.00
       Total Materials Cost                                                    P 154,229.00
                                                             No. of   Rate per
  3)              Name and Capacity         No. of Units                                  Total Cost
                                                             Hours     Hour
  E
  Q
  U
  I
  P
  M
  E
  N
  T
       Total Equipment Cost                                                         P -
                                                             No. of   Rate per
  4)          Designation of Personnel      No. of Men                                    Total Cost
                                                             Hours     Hour
  L
  A
  B
  O
  R    Total Labor Cost                                                          P 53,980.15
  5    TOTAL DIRECT COST                                                           P       208,209.15
   6   Direct Cost (5/1)                                                                      #VALUE!
   7   CONTRACTOR PROFIT (10% X 5)                                                 P         20,820.92
   8   OCM (Overhead, Contingencies & Miscellaneous) [10% OF 5]                    P           20,820.92
   9   Indirect Cost (7+8)                                                         P           41,641.84
  10   VAT ((5+9) * 12%)                                                           P           29,982.12
  11   Total Cost Item                                                             P          279,833.11
  12   UNIT COST OF ITEM (10/1)                                                                  #VALUE!
Prepared by :                                              Approved by:
ENGR. ALICIA A. KINTANA                                    ATTY. MILDRED JOY P. QUE, CPA
   Municipal Engineer                                                Mayor
                                        DETAILED UNIT PRICE ANALYSIS
Project Name: Rehabilitation of Barangay Hall
Location: Brgy. Arado, Dulag Leyte
ITEM III : Water Tank
     1)    QUANTITY:
     2)                      Name and Specification     Quantity      Unit        Unit Price        Total Cost
                Portland Cement                           176       bags             285.00     P    50,160.00
                Sand                                       10       cu.m.            720.00     P     7,200.00
                Gravel                                     20       cu.m.          1,200.00     P    24,000.00
                20 mm. x 6m. RSB Grade 40                  56        pcs.            653.00     P    36,568.00
                18 mm. x 6m. RSB Grade 40                  22        pcs.            432.00     P     9,504.00
                16 mm. x 6m. RSB Grade 40                 115        pcs.            425.00     P    48,875.00
                12 mm. x 6m. RSB Grade 40                 192        pcs.             18.00     P     3,456.00
     M          2" x 2" x 12' Coco Lumber                 475       bd.ft.            29.00     P    13,775.00
     A          2" x 3" x 12' Coco Lumber                  49       bd.ft.            29.00     P     1,421.00
     T
     E          2" x 4" 12' Coco Lumber                   663       bd.ft.            29.00     P    19,227.00
     R          1/4" x 4' x 8' Marine Plywood              12        pcs.            460.00     P     5,520.00
     I
     A          1/2" x 4' x 8' Marine Plywood              15        pcs.            780.00     P    11,700.00
     L          10 mm. Ø x 6m. RSB                         8         pcs.            163.00     P     1,304.00
     S
                # 16 G.I. Tie Wire                         32        kls.             70.00     P     2,240.00
                C.W. Nails (Assorted)                      17        kls.             75.00     P     1,275.00
                Dumbbel Type Water Stopper                 1         pc.              10.00     P        15.00
                4" CHB ( for valve box)                    26        pcs.             12.00     P       312.00
                50 mm. x 50 mm. x 6 m. Angle bar           5         pcs.          1,150.00     P     5,750.00
                (for stair)
                Welding Rod                                 2         kls.           148.00 P      296.00
                Total Materials Cost                                                   P 242,598.00
                                                         No. of
     3)                       Name and Capacity                    No. of Day Rate per Da y         Total Cost
                                                         Units
     E
     Q
                1-Bagger Mixer                              1          5      P      1,300.00 P        6,500.00
     U
     I
     P
                Bar Cutter                                  1          5      P      1,700.00 P        8,500.00
                                                                                     1,100.00 P        5,500.00
     M
     E          Concrete Vibrator                           1          5      P
     N
     T
                Total Equipment Cost                                                     P 20,500.00
                                                         No. of      No. of       Rate per
     4)                  Designation of Personnel                                               Total Cost
                                                          Men        Hours         Hours
                Foreman                                     1        120      P       62.50     P      7,500.00
     L          Mason                                       1        120      P       50.00     P      6,000.00
     A          Carpenter                                   1        120      P       50.00     P      6,000.00
     B
     O          Steelman                                    1        120      P       50.00     P      6,000.00
     R          Laborer                                     6        120      P       32.50     P      7,800.00
                Total Labor Cost                                                         P 84,909.30
     5          TOTAL DIRECT COST                                                             P 348,007.30
     6          Direct Cost (5/1)                                                                    #DIV/0!
     7          CONTRACTOR PROFIT (10% X 5)                                                     P     34,800.73
     8          OCM (Overhead, Contingencies & Miscellaneous) [10% OF 5]                        P     34,800.73
      9         Indirect Cost (7+8)                                                             P     69,601.46
     10         VAT ((5+9) * 12%)                                                               P     50,113.05
     11         Total Cost Item                                                                 P    467,721.81
     12         UNIT COST OF ITEM (10/1)                                                                 #DIV/0!
Prepared by :                                                      Approved by:
ENGR. ALICIA A. KINTANA                                            ATTY. MILDRED JOY P. QUE, CPA
   Municipal Engineer                                                        Mayor
                                     DETAILED UNIT PRICE ANALYSIS
Project Name: Provision of Solar PV Potable Water System
Location: Brgy. Arado, Dulag, Leyte
ITEM IV : Machinery ( Solar Panel, Submersible Pump and Chloronator)
    1)     QUANTITY:                        L.S.
    2)            Name and Specification           Quantity     Unit         Unit Price            Total Cost
           265 Wp Solar Panel                        4          pcs.           13,000.00 P               52,000.00
           4 x 265 Wp Mounting Structure             1          pcs.                   P
                                                                                30,000.00                30,000.00
           Stainless Nuts M8 w/ Washer               16         pcs.             15.00 P                    240.00
           Terminal Lugs 5.5-6R                      6          kls.             10.09 P                     60.54
           Submesible Pump, 1.4 kw                   1          pc.         120,000.00 P                120,000.00
           30-300VDC, 90-240VAC,Helical
             Metal Enclosure, 400 x 300mm.           1           pc.          30,000.00 P         30,000.00
           Splicing Kit                              1            kit          2,900.00 P          2,900.00
           Submersible Cable 12 AWG/3c               50          m.              405.00 P            405.00
           4mm² PV Cable - Red                      100          m.               80.00 P             80.00
           4mm² PV Cable - Black                    100          m.               80.00 P             80.00
            #12AWG THHN CABLE (3.5 SQ.MM. ) Red     100          m.               48.00 P             48.00
    M
           #12AWG THHN CABLE (3.5 SQ.MM. ) Black    100          m..              48.00 P             48.00
    A
    T
           3/4" Ø PVC Electrical Conduit             35        length            160.00 P          5,600.00
    E      3/4" Ø PVC Electrical Conduit Elbow       10         pcs.              20.00 P             20.00
    R
    I      PVC Contact Cement                        2           can             250.00 P            500.00
    A
    L      Ground Rod, 5/8"                          1           pc.           1,200.00 P          1,200.00
    S
           Ground Clamp, 5/8"                        1           pc.             400.00 P            400.00
           Cable Tie 12"                            100         pcs.               6.00 P            600.00
           Cable Tie 6"                             100         pcs.               5.00 P            500.00
           Electrical Tape                           2          pcs.              50.00 P            100.00
           Rubber Tape                               2          pcs.              80.00 P            160.00
           Float Switch                              1          pcs.             600.00 P            600.00
           Chloronator Machine                       1           unit         16,400.00 P         16,400.00
           1/2" Ø Stainless Faucet                   1            pc             560.00 P            560.00
           1/2" Ø2.0m. Upe/Polyethelene              2          pcs.              30.00 P             60.00
           1/2" Ø Adaptor                            1           pc.             225.00 P            225.00
           Water Proofing Compond                    2          pack              80.00 P            160.00
           3 HP Water Pump                           1           set          41,000.00 P         41,000.00
           Total Materials Cost                                                      P 303,946.54
                                                    No. of     No. of
    3)               Name and Capacity                                  Rate per Hour              Total Cost
                                                    Units      Hours
    E
    Q
           Sand Pump                                  1          16     P          162.50 P                2,600.00
    U
    I
    P
    M
    E
    N
    T
           Total Equipment Cost                                                            P 2,600.00
                                                    No. of     No. of
    4)           Designation of Personnel                               Rate per Hour              Total Cost
                                                     Men       Hours
    L      Foreman                                    1          40     P        500.00 P                 2,500.00
    A      Plumber                                    1          40     P        500.00 P                 2,500.00
    B
    O      Laborer                                    2          40     P        260.00 P                 2,600.00
    R      Total Labor Cost                                                               P 106,381.29
    5      TOTAL DIRECT COST                                                                 P         412,927.83
    6      Direct Cost (5/1)                                                                                #DIV/0!
    7      CONTRACTOR PROFIT (10% X 5)                                                       P           41,292.78
    8      OCM (Overhead, Contingencies & Miscellaneous) [10% OF 5]                          P           41,292.78
    9      Indirect Cost (7+8)                                                               P           82,585.57
    10     VAT ((5+9) * 12%)                                                                 P           59,461.61
    11     Total Cost Item                                                                   P          554,975.00
    12      UNIT COST OF ITEM (10/1)                                                                        #DIV/0!
Prepared by :                                                 Approved by:
ENGR. ALICIA A. KINTANA   ATTY. MILDRED JOY P. QUE, CPA
   Municipal Engineer     Municipal Mayor
    #VALUE!
5
                                            Republic of the Phillippines
                                                Province of Leyte
                                            MUNICIPALITY OF DULAG
                                     INDIVIDUAL PROGRAM OF WORKS
                                           VARIATION ORDER #1
Name/Location of Project:                     Appropriation
                                              Source of Fund  : DILG Fund
         Rehabilitation of Barangay Hall
           Brgy. Arado, Dulag, Leyte              Calendar Days to Complete :
                                                  Mode of Implementation : Contract
Project Category:
                                           Rehabilitation of Barangay Hall
Project Description:
                                           Rehabilitation of Barangay Hall
            Minimum Equipment Requirement                                    Technical Personnel Required
 No.                      Description                                     Description                         No.
                                   ESTIMATED COST OF PROPOSED WORK
Item                                           % of              Direct Total Cost                                Adj.
                       Description                    Qty. Unit
 No.                                           total             Total       Unit Cost                          Unit Cost
   I    Tap Stand                                   ###      20 Units        -
                                                                                    #VALUE!        #VALUE!          #VALUE!
  II    Well Casing Develoment & Distribution       ###        L.S.          -
                                                                                    #VALUE!        #VALUE!          #VALUE!
  III   Water Tank                                #DIV/0!             -      -
                                                                                    #DIV/0!         #DIV/0!         #DIV/0!
 IV Machinery ( Solar Panel, Submersible P #DIV/0!                    -   L.S.
                                                                                    #DIV/0!         #DIV/0!         #DIV/0!
                                                   #VALUE!                             #VALUE!
Prepared by :                                                                    Approved by:
ENGR. ALICIA A. KINTANA                                                          ATTY. MILDRED JOY P. QUE, CPA
Municipal Engineer                                                               Municipal Mayor
   BREAKDOWN OF ESTIMATED EXPENDITURES                % of total         AMOUNT
I. ESTIMATED COST
  A. DIRECT COST                                        #VALUE!                     #VALUE!
     1. Mobilization/Demobilization
     2. Materials                                     #VALUE!                 751,512.54
        a. Supply/Delivery
        b. Testing of Materials
     3. Labor                                         #VALUE!                 263,029.39
     4. Equipment Expenses
  B. INDIRECT COST                                    #VALUE!                 356,948.83
     1. Overhead, Contingencies, Miscellaneous        #VALUE!                  103,764.19
         ( 7% to 13% of Direct Cost)
     2. Profit                                        #VALUE!                  103,764.19
         ( 5% to 15% of Direct Cost)
     3. Comprehensive All Risk Insurance
        ( 1.5% of Direct Cost)
     4. Value Added Tax                               #VALUE!                  149,420.44
        ( 5% of (A+B.1+B.2)
                                      SUB - TOTAL    #VALUE!                   #VALUE!
II. ESTIMATED GOVERNMENT EXPENDITURES
   A. Engineering and Administratuve Overhead
      ( 3% of A1 to A4 )
   B. ROW/Site Acquisition
   C. Materials to be Accomplished by Government
III. CONTINGENCIES RESERVES
    A. Physical
       (up to 5% of the Estimated Contract Cost )
    B. Price Escalation
       (up to 5% of the Estimated Contract Cost )
TOTAL ESTIMATED PROJECT COST                                                    #VALUE!
Prepared by :                                       Approved by:
ENGR. ALICIA A. KINTANA                             ATTY. MILDRED JOY P. QUE, CPA
   Municipal Engineer                               Municipal Mayor
230049.57
   #VALUE!
                                                                               Republic of the Philippines
                                                                                   Province of Leyte
                                                                               MUNICIPALITY OF DULAG
                                                                          REHABILITATION OF BARANGAY HALL
                                                                               Brgy. Sungi, Dulag Leyte
                                                                               VARIATION ORDER NO. 1
                                        ORIGINAL BILL OF MATERIALS AND COST ESTIMATES                         VARIATION ORDER OF BILL OF MATERIALS AND COST ESTIMATES
   NAME OF PROJECT
                                 ITEM OF WORK        QUANTITY UNITS     UNIT COST     TOTAL COST            ITEM OF WORK      QUANTITY UNITS        UNIT COST TOTAL COST
                             I     CANOPY               2.00    SETS      13,472.001    26,944.00       I    CANOPY              2.00       SETS       11,548.655  23,097.31
                            II     WINDOWS              9.00    SETS      15,919.5781  143,276.20      II    WINDOWS             1.00        L.S.    153,380.32   153,380.32
  REHABILITATION OF
BRGY. HALL, Brgy. Sungi,   III     PAINTING WORKS      344.00  SQ.M.          119.48    41,102.80     III    PAINTING WORKS     344.00     SQ.M.    113.24177      38,955.17
 Dulag Leyte (Variation    IV      HANDRAILS            1.00    SET       24,676.00     24,676.00     IV     HANDRAIL            1.00        SET     20,557.15     20,557.15
      Order # 1)
                                                             PROJECT COST               235,999.01                                      PROJECT COST                235,989.95
Prepared by:                                                                                                                             Approved:
ENGR. ALICIA A. KINTANA                                                                                                                  ATTY. MILDRED JOY P. QUE
Municipal Engineer                                                                                                                       Municipal Mayor