arnel quotation

Upload: royce-marc-luistro

Post on 07-Apr-2018

220 views

Category:

Documents


0 download

TRANSCRIPT

  • 8/4/2019 Arnel Quotation

    1/17

    2 2 2 2 2 2 2 142

    2

    2

    2

    2

    2

    2

    2

  • 8/4/2019 Arnel Quotation

    2/17

    REDL ENTERPRISES CORP

    Date : JAN. 22, 2011 Control # : _______

    Customer : BUREU OF INTERNAL REVENUE

    Address : Bldg. 313, Sen. Gil Puyat Ave., Makati City

    Subject : Installation of nine(9) units, ( 2- 5TR, ceiling mntd, 2- 3TR, ceiling mntd, 2-3TR, floor mntd

    2-2TR, ceiling mntd, 1- 2.0 hp window type Aircondition units

    Materials Breakdown

    ITEMS Total

    No. Description 5TR 5TR 3TR 3TR 3TR 3TR 2TR 2TR WT Qty

    1 Circuit breaker, NEMA 3, 60A, 1 1 2

    230V, 3ph, bolt -on, weather- 0

    proof enclosure. 0

    2 Circuit breaker, NEMA 3, 40A, 1 1 1 1 4

    230V, 1ph, bolt -on, weather- 0

    proof enclosure. 0

    3 Circuit breaker, NEMA 3, 30A 1 1 2

    230V, 1ph, bolt -on, weather- 0

    proof enclosure. 0

    4 Circuit breaker, 20A, 230V, 1ph 1 1

    bolt -on 0

    5 Electl. Wire, 8.0mm2/#8, 36 114 150

    strd, THHN 0

    6 Electl. Wire, 5.5mm2/#10, 12 54 50 50 166

    strd, THHN 0

    7 Electl. Wire, 3.5mm2/#12 27 56 60 45 35 55 100 150 108 636

    strd, THHN 0

    8 Electl. Wire indl. #14, strd 45 30 120 27 20 60 24 80 406

    9 Electl. Tape 2 2 1 1 1 1 1 1 1 11

    10 PVC conduit, orange, 1"dia x 3 7 10

    10' 0

    11 PVC conduit, orange, 3/4"dia 4 2 3 1.5 5 2 6 23.5

    x 10' 0

    12 PVC conduit elbow, orange 5 4 2 3 5 2 3 24

    3/4"dia 0

    A.C.U's

  • 8/4/2019 Arnel Quotation

    3/17

    13 PVC conduit, orange,1/2"dia 6 6 6 2 7 4 12

    x 10'

    14 PVC conduit elbow, orange 5 2 3 2 3 3 4

    1/2"dia

    15 PVC conduit elbow, orange 5 5

    1"dia

    16 PVC connector,orange, 7 7 2 2 7 3 9

    3/4"dia w/ lock nut bushg

    17 PVC connector,orange, 7 7 7 2 10 3 14

    1/2"dia w/ lock nut bushg

    18 Clamp, orange, 1"dia 8 8

    19 Clamp, orange, 3/4" 8 6 4 6 3 12 12 9

    20 Clamp, orange, 1/2" 8 8 6 6 12

    21 Utility box, orange

    22 Junction box, orange,w/ cover 4 4 2 5 3 9 6 5 7

    23 Plastic Moulding, 3/4" x 10'

    24 Liquid tight conduit, 1"dia 1 1

    25 Liquid tight conduit, 3/4"dia 1 1 2 1 1

    26 Liquid tight conduit, 1/2"dia 1 1

    27 Angle connector, liquid tight 2 2

    1"dia. w/ lock nut bushing

    28 Angle connector, liquid tight 2 2 2 2 2 2

    3/4"dia w/ lock nut bushg

    29 Angle connector, liquid tight

    1/2"dia w/ lock nut bushg

    30 Angle bar, 3/16"t x 1 1/2" x 2 2 3 3 2 2 2 2 2

    1 1/2" x 20'

    31 Angle bar, 3/16"t x 1" x 1" 0.8 0.6 0.6 0.45 0.3 1.2 1.6 1.3 3

    x 20'

    32 Flat bar, 1/4"t x 1 1/2" x 20' 3 4 3 3 2 4 3 6 6

    33 Plain round bar, 1/2"dia x 20' 2 2 2 2 2 2 2 2 2

    34 B.I. pipe, 1"dia x 20' 4 5 6 8 2

    35 Cement

    36 White sand

    37 Machine bolt, w/ nuts,lock & 4 4 4 4 4 4 4 4

    flat washeres, 12mm x 50mm

    38 U bolt w/ nuts, lock & flat 8 5 4 3 2 8 11 9

  • 8/4/2019 Arnel Quotation

    4/17

    washers, 1/4"dia thread, x

    6"dia clamp, x 8"dia depth

    39 Dyna-bolt, 5/16"dia x 2" 4 4 4 4

    40 G,I, wire, # 16

    41 Welding rod, 1/8"dia, wip arc 0.75 0.75 0.5 0.5 0.5 0.5 0.5 0.5 1

    42 Expansion shield w/ bolt, 4 4 4

    lock washers, 1/4"dia x 1"

    43 Expansion shield w/ bolt, 6 6 4 4 4 4 4 4 4

    lock washers, 5/16"dia x 2"

    44 Copper pipe, (hd) 1 1/8"dia 2 1

    45 Copper pipe, (hd) 5/8"dia 2 1

    46 Copper pipe, (hd) 3/4"dia 3 2 1 3

    47 Coppere pipe,(hd) 1/2"dia 3 2 1 3 1 3

    48 Copper pipe,(hd) 3/8"dia 1 3

    49 Copper elbow, long radius, 5 4

    1 1/8"dia

    50 Copper elbow, long radius,

    3/4"dia 6 4 5 6

    51 Copper elbow, long radius, 5 4

    5/8"dia

    52 Copper elbow, long radius, 6 4 5 6 4 5

    1/2"dia

    53 Copper elbow, long radius, 4 5

    3/8"dia

    54 Full thread round bar, w/ nut 8 6 4 3 6 12 11 9

    & washers, 5/16"dia x 1m

    55 Rubber insulation, 1/2"t, x 7 4

    1 1/8"dia I.D. x 6', aeroflex

    56 Rubber insulation, 1/2"t, x 10 5 3 10

    3/4"dia I.D. x 6' aereoflex

    57 Rubber insulation, 1/2"t, x 7 4

    5/8"dia I.D. x 6' aeroflex

    58 Rubber insulation, 1/2"t, x 10 5 3 10 4 10

    1/2"dia I.D. x 6' aeroflex

    59 Rubber insulation, 1/2"t, x 4 10

    3/8"dia I.D. x 6' aeroflex

    60 Polyethylene plastic, 2" 5 3 5 3 2 5 2 5

  • 8/4/2019 Arnel Quotation

    5/17

    61 Ever sealer 0.5 0.5 0.25 0.25 0.25 0.25 0.25 0.25

    62 PVC pipe, blue, NELTEX,1"dia 3 2

    X 20'

    63 PVC pipe, blue, NELTEX 2 2 2 2

    3/4"dia x 20'

    64 PVC pipe, blue, NELTEX 1 2

    1/2"dia x 20'

    65 PVC elbow, NELTEX, 1"dia 4 3

    66 PVC elbow, NELTEX, 3/4"dia 2 3 2 3

    67 PVC elbow, NELTEX, 1/2"dia 3 3

    68 PVC cement

    69 R-22 5 5 4 3 3 4 3 3

    70 Nitrogen

    71 Oxy & Ace

    72 Silver rod 6 6 5 4 4 5 3 4

    73 Flux

    74 Filter drier, solder type, 1 1

    5/8"dia

    75 Filter drier, solder type, 1 1 1 1

    1/2"dia

    76 Filter drier, solder type, 1 1

    3/8"dia

    77 Red lead paint

    78 Paint thinner

    79 Paint Brush 2"

    80 Fan Grille of condenser 1 1

    Koppel, 3TR, 220V, 60h, 1ph

    Total Materials Cost ----------- -------- -------- ------- -------- --------

    Total Labor Cost ---------------------------------------------------

    Hauling Cost ---------------------------------------------------

    Dismantling Cost --------------------------------------------------- Php 1,000.00/ TR.(28TR)

    Co. Profit ---------------------------------------- 15%

  • 8/4/2019 Arnel Quotation

    6/17

    VAT 12%

    CONTRACT PRICE -----------------------------------------

    Prepared By : ________________ Noted By : ______________

    Labor Cost:Steel work ------------------------------------- 8 working days

    Electl works ------------------------------------ 5 working days

    A.C. Installation works ----------------------- 10 working days

    Masonry works -------------------------------- 4 working days

    Manpower breakdown

    1 Steel fabricator -- 2

    2 Helper -- 4

    3. A.C. Techn. --2

    4. Helper --4

    5.Masonry --4

    6. Electn. --2

    7. Electrn helper --2

    Hauling Cost ------ Php 4,000.00/ Trip

    Dismantling Cost ------ Php 4,000.00/ Unit

    Note: Addition Charges on the part that we found out required to replace in the units

  • 8/4/2019 Arnel Quotation

    7/17

  • 8/4/2019 Arnel Quotation

    8/17

  • 8/4/2019 Arnel Quotation

    9/17

  • 8/4/2019 Arnel Quotation

    10/17

  • 8/4/2019 Arnel Quotation

    11/17

    REDL ENTERPRISES CORP

    Date : , 2011 Control # : __________

    Customer :

    Address : PR/PO# _____________

    Subject :

    Materials Breakdown

    ITEMS Total Unit Unit Total unit 30%

    No. Description 0 Qty QTY Price Cost unit cost

    1 Circuit breaker, NEMA 3, 60A, 0 0 lot 3,070.00 6,140.00 1,842.00 7,982.00

    230V, 3ph, bolt -on, weather- 0 0.00 0.00 0.00

    proof enclosure. 0 0.00 0.00 0.00

    2 Circuit breaker, NEMA 3, 40A, 0 lot 2,640.0 10,560.00 3,168.00 13,728.00

    230V, 1ph, bolt -on, weather- 0 0.00 0.00 0.00

    proof enclosure. 0 0.00 0.00 0.00

    3 Circuit breaker, NEMA 3, 30A 0 lot 2,130.0 4,260.00 1,278.00 5,538.00

    230V, 1ph, bolt -on, weather- 0 0.00 0.00 0.00proof enclosure. 0 0.00 0.00 0.00

    4 Circuit breaker, 20A, 230V, 1ph 0 lot 2,130.0 2,130.00 639.00 2,769.00

    bolt -on 0 0.00 0.00 0.00

    5 Electl. Wire, 8.0mm2/#8, 0 0 mtrs 62 9,300.00 2,790.00 12,090.00

    strd, THHN 0 0.00 0.00 0.00

    6 Electl. Wire, 5.5mm2/#10, 0 mtrs 35 5,810.00 1,743.00 7,553.00

    strd, THHN 0 0.00 0.00 0.00

    7 Electl. Wire, 3.5mm2/#12 0 0 mtrs 30 19,080.00 5,724.00 24,804.00

    strd, THHN 0 0.00 0.00 0.00

    8 Electl. Wire indl. #14, strd 0 0 mtrs 15 6,090.00 1,827.00 7,917.00

    9 Electl. Tape 0 0 rolls 25 275.00 82.50 357.50

    10 PVC conduit, orange, 1"dia x 0 0 L 95 950.00 285.00 1,235.00

    10' 0 0.00 0.00 0.00

    11 PVC conduit, orange, 3/4"dia 0 0 L 88 2,068.00 620.40 2,688.40

    x 10' 0 0.00 0.00 0.00

    12 PVC conduit elbow, orange 0 0 pcs 15 360.00 108.00 468.00

    3/4"dia 0 0.00 0.00 0.00

    A.C.U's 30% Cont. of total

  • 8/4/2019 Arnel Quotation

    12/17

    13 PVC conduit, orange,1/2"dia 0 L 60 2,580.00 774.00 3,3

    x 10' 0 0.00 0.00 0

    14 PVC conduit elbow, orange 0 pcs 10 220.00 66.00 28

    1/2"dia 0 0.00 0.00 0

    15 PVC conduit elbow, orange 0 0 pcs 35 350.00 105.00 45

    1"dia 0 0.00 0.00 0

    16 PVC connector,orange, 0 0 pcs 15 555.00 166.50 72

    3/4"dia w/ lock nut bushg 0 0.00 0.00 0

    17 PVC connector,orange, 0 pcs 12 600.00 180.00 78

    1/2"dia w/ lock nut bushg 0 0.00 0.00 0

    18 Clamp, orange, 1"dia 0 0 pcs 3 48.00 14.40 62

    19 Clamp, orange, 3/4" 0 0 pcs 2.5 150.00 45.00 19

    20 Clamp, orange, 1/2" 0 pcs 2 80.00 24.00 10

    21 Utility box, orange 0 pcs 20 0.00 0.00 0

    22 Junction box, orange,w/ cover 0 0 pcs 28 1,260.00 378.00 1,6

    23 Plastic Moulding, 3/4" x 10' 0 L 0.00 0.00 0

    24 Liquid tight conduit, 1"dia 0 0 mtrs 48 96.00 28.80 12

    25 Liquid tight conduit, 3/4"dia 0 mtrs 69 414.00 124.20 53

    26 Liquid tight conduit, 1/2"dia 0 mtrs 55 110.00 33.00 14

    27 Angle connector, liquid tight 0 0 pcs 50 200.00 60.00 26

    1"dia. w/ lock nut bushing 0 0.00 0.00 0

    28 Angle connector, liquid tight 0 sets 50 600.00 180.00 78

    3/4"dia w/ lock nut bushg 0 0.00 0.00 0

    29 Angle connector, liquid tight 0 sets 22 0.00 0.00 0

    1/2"dia w/ lock nut bushg 0 0.00 0.00 0

    30 Angle bar, 3/16"t x 1 1/2" x 0 0 L 450 9,000.00 2,700.00 11,7

    1 1/2" x 20' 0 0.00 0.00 0

    31 Angle bar, 3/16"t x 1" x 1" 0 0 L 450 4,432.50 1,329.75 5,7

    x 20' 0 0.00 0.00 0

    32 Flat bar, 1/4"t x 1 1/2" x 20' 0 0 L 200 6,800.00 2,040.00 8,8

    33 Plain round bar, 1/2"dia x 20' 0 0 L 115 2,070.00 621.00 2,6

    34 B.I. pipe, 1"dia x 20' 0 0 L 0.00 0.00 0

    35 Cement 0 bags 197 0.00 0.00 0

    36 White sand 0 bags 70 0.00 0.00 0

    37 Machine bolt, w/ nuts,lock & 0 0 sets 18.55 593.60 178.08 77

    flat washeres, 12mm x 50mm 0 0.00 0.00 0

    38 U bolt w/ nuts, lock & flat 0 0 sets 21.3 1,065.00 319.50 1,3

  • 8/4/2019 Arnel Quotation

    13/17

    washers, 1/4"dia thread, x 0 0.00 0.00 0

    6"dia clamp, x 8"dia depth 0 0.00 0.00 0

    39 Dyna-bolt, 5/16"dia x 2" 0 0 pairs 0.00 0.00 0

    40 G,I, wire, # 16 0 kls 90 0.00 0.00 0

    41 Welding rod, 1/8"dia, wip arc 0.00 0 kls 30 165.00 49.50 21

    42 Expansion shield w/ bolt, 0 sets 14 168.00 50.40 21

    lock washers, 1/4"dia x 1" 0 0.00 0.00 0

    43 Expansion shield w/ bolt, 0 0 sets 20 800.00 240.00 1,0

    lock washers, 5/16"dia x 2" 0 0.00 0.00 0

    44 Copper pipe, (hd) 1 1/8"dia 0 0 L 3,410 10,230.00 3,069.00 13,2

    45 Copper pipe, (hd) 5/8"dia 0 0 L 1400 4,200.00 1,260.00 5,4

    46 Copper pipe, (hd) 3/4"dia 0 L 2000 18,000.00 5,400.00 23,4

    47 Coppere pipe,(hd) 1/2"dia 0 L 1000 13,000.00 3,900.00 16,9

    48 Copper pipe,(hd) 3/8"dia 0 L 781 3,124.00 937.20 4,0

    49 Copper elbow, long radius, 0 0 pcs 81 729.00 218.70 94

    1 1/8"dia 0 0.00 0.00 0

    50 Copper elbow, long radius, 0 pcs 54 0.00 0.00 0

    3/4"dia 0 pcs 0.00 0.00 0

    51 Copper elbow, long radius, 0 0 pcs 30 270.00 81.00 35

    5/8"dia 0 0.00 0.00 0

    52 Copper elbow, long radius, 0 pcs 11 330.00 99.00 42

    1/2"dia 0 0.00 0.00 0

    53 Copper elbow, long radius, 0 pcs 50 450.00 135.00 58

    3/8"dia 0 0.00 0.00 0

    54 Full thread round bar, w/ nut 0 0 sets 30 1,770.00 531.00 2,3

    & washers, 5/16"dia x 1m 0 0.00 0.00 0

    55 Rubber insulation, 1/2"t, x 0 0 L 141 1,551.00 465.30 2,0

    1 1/8"dia I.D. x 6', aeroflex 0 0.00 0.00 0

    56 Rubber insulation, 1/2"t, x 0 L 400 11,200.00 3,360.00 14,5

    3/4"dia I.D. x 6' aereoflex 0 0.00 0.00 0

    57 Rubber insulation, 1/2"t, x 0 0 L 50 550.00 165.00 71

    5/8"dia I.D. x 6' aeroflex 0 0.00 0.00 0

    58 Rubber insulation, 1/2"t, x 0 L 80 3,360.00 1,008.00 4,3

    1/2"dia I.D. x 6' aeroflex 0 0.00 0.00 0

    59 Rubber insulation, 1/2"t, x 0 L 35 490.00 147.00 63

    3/8"dia I.D. x 6' aeroflex 0 0.00 0.00 0

    60 Polyethylene plastic, 2" 0 0 rolls 150 4,500.00 1,350.00 5,8

  • 8/4/2019 Arnel Quotation

    14/17

    61 Ever sealer 0 0 rolls 130 325.00 97.50 42

    62 PVC pipe, blue, NELTEX,1"dia 0 0 L 110 550.00 165.00 71

    X 20' 0 0.00 0.00 0

    63 PVC pipe, blue, NELTEX 0 L 88 704.00 211.20 91

    3/4"dia x 20' 0 0.00 0.00 0

    64 PVC pipe, blue, NELTEX 0 L 60 180.00 54.00 23

    1/2"dia x 20' 0 0.00 0.00 0

    65 PVC elbow, NELTEX, 1"dia 0 0 pcs 15 105.00 31.50 13

    66 PVC elbow, NELTEX, 3/4"dia 0 pcs 12 120.00 36.00 15

    67 PVC elbow, NELTEX, 1/2"dia 6 pcs 10 60.00 18.00 78

    68 PVC cement 0 cans 75 0.00 0.00 0

    69 R-22 0 0 kls 180 5,400.00 1,620.00 7,0

    70 Nitrogen 0 cyl 0.00 0.00 0

    71 Oxy & Ace 0 pairs 800 0.00 0.00 0

    72 Silver rod 0 0 pcs 10 370.00 111.00 48

    73 Flux 0 cans 100 0.00 0.00 0

    74 Filter drier, solder type, 0 0 pcs 450 900.00 270.00 1,1

    5/8"dia 0 0.00 0.00 0

    75 Filter drier, solder type, 0 pcs 580 2,320.00 696.00 3,0

    1/2"dia 0 0.00 0.00 0

    76 Filter drier, solder type, 0 pcs 450 900.00 270.00 1,1

    3/8"dia 0 0.00 0.00 0

    77 Red lead paint 0 gals 750 0.00 0.00 0

    78 Paint thinner 0 gals 550 0.00 0.00 0

    79 Paint Brush 2" 0 pcs 119.75 0.00 0.00 0

    80 Fan Grille of condenser 0 0 pcs 1800 3,600.00 1,080.00 4,6

    Koppel, 3TR, 220V, 60h, 1ph 0 0.00 0.00 0

    0 0.00 0.00 0

    0 0.00 0.00 0

    0 0.00 0.00 0

    Total Materials Cost ----------- -------- -------- ------- -------- --------

    Total Labor Cost ---------------------------------------------------

    Hauling Cost ---------------------------------------------------

    Dismantling Cost --------------------------------------------------- Php 1,000.00/ TR.(28TR)

    Co. Profit ---------------------------------------- 15%

  • 8/4/2019 Arnel Quotation

    15/17

    412,676.27

    VAT 12% 49,521.15

    CONTRACT PRICE ----------------------------------------- 462,197.42

    Prepared By : ________________ Noted By : ______________

    Labor Cost:Steel work ------------------------------------- 8 working days

    Electl works ------------------------------------ 5 working days

    A.C. Installation works ----------------------- 10 working days

    Masonry works -------------------------------- 4 working days

    Manpower breakdown

    1 Steel fabricator -- 2

    2 Helper -- 4

    3. A.C. Techn. --2

    4. Helper --4

    5.Masonry --4

    6. Electn. --2

    7. Electrn helper --2

    Hauling Cost ------ Php 4,000.00/ Trip

    Dismantling Cost ------ Php 4,000.00/ Unit

    Note: Addition Charges on the part that we found out required to replace in the units

  • 8/4/2019 Arnel Quotation

    16/17

    REDL ENTERPRISES CORP.

    Date : _____________

    Customer Name : ___________________________________________

    Subject : ___________________________________________________

    MATERIALS BREAKDOWN

    No. Item/s Description Qty. Unit Unit Price Total Price REMARKS

    Prepared By : __________________

    Noted : _______________________

  • 8/4/2019 Arnel Quotation

    17/17

    Compatibility Report for Matrials Breakdown Form.xls

    The following features in this workbook are not supported by earlier versions of

    Excel. These features may be lost or degraded when you save this workbook in

    an earlier file format.

    Minor loss of fidelity # of occurrences

    Some cells or styles in this workbook contain formatting that is not supported

    by the selected file format. These formats will be converted to the closest

    format available.

    2