insumos excel tribu

Upload: omar-grimaldo-san-miguel

Post on 14-Jan-2016

226 views

Category:

Documents


0 download

DESCRIPTION

TR

TRANSCRIPT

Sheet1CdigoCdigo AlternoDescripcinUnd.CantidadPrecio S/.Parcial S/.794,118.58Auxiliar1 S/.Auxiliar2 S/.Auxiliar3 S/.Parcial Auxiliar1 S/.Parcial Auxiliar2 S/.Parcial Auxiliar3 S/.% Incidencia PrincipalIncidencia Acumulada Principal100147000032470032001TOPOGRAFOhh20.831316.91352.260.0000100147010001470101001CAPATAZhh721.016118.6013,410.900.0000100147010002470102001OPERARIOhh5,541.762416.9193,711.200.0000100147010003470103001OFICIALhh4,350.945514.3462,392.560.0000100147010004470104001PEONhh4,664.410112.9360,310.820.0000100202000007020007001ALAMBRE NEGRO RECOCIDO # 16kg3,797.09582.409,113.030.0000100202000008020008001ALAMBRE NEGRO RECOCIDO # 8kg436.99022.401,048.780.0000100202010005020105001CLAVOS PARA MADERA C/C 3"kg401.17043.141,259.680.0000100202010061020161001CLAVOS CON CABEZA DE 2 1/2", 3" Y 4"kg78.02003.14244.980.0000100202010062020162001CLAVOS PARA MADERAkg0.32503.141.020.0000100202970002029702001ACERO DE REFUERZO FY=4200 GRADO 60kg68,331.60844.75324,575.140.0000100204000000040000001ARENA FINAm389.161025.002,229.030.000000204010005040104001TIERRA DE CULTIVOm32.000035.0070.000.000000205000003050003001PIEDRA CHANCADA DE 1/2"m3214.793345.009,665.700.000000205010004050104001ARENA GRUESAm3192.689830.005,780.690.000000206050008060508001CABLE DE COBRE DESNUDO DE 16 MM2m1.00006.106.100.000000206050011060509001CABLE DE COBRE DESNUDO DE 50 MM2m17.500021.00367.500.000000206700004067003001VARILLA DE COBRE 3/4'' x 2.40 M.und1.0000237.20237.200.0000100206980001069801001CONECTOR ABund3.00004.2712.810.000000207010000070100001CABLE TW # 14 AWG 2.5 MM2m78.30000.9372.820.000000210000053100052001LIMPIEZA PERMANENTEGLB1.00001,500.001,500.000.0000100210020011100211001INODORO TQUE. BAJO NORMAL BLANCO C/A.und8.0000230.001,840.000.0000100210020019100211001URINARIO CADET BLANCO CON ACCESORIOSund4.0000150.00600.000.000000210040095100493001LAVATORIO LOSA BLANCA DE 1ERA CALIDAD 545X460MMund1.000075.0075.000.0000100210040097100490001LAVATORIO OVALIN SONET BLANCOpza8.000090.00720.000.000000210210044102144001JABONERA DE LOSA BLANCA CON ASAund9.000012.71114.390.000000210210045102145001PAPELERA DE LOSA BLANCA 15 X 15 CMund9.000014.32128.880.0000100210210047102145001DISPENSOR DE PAPEL TOALLAund3.0000135.00405.000.0000100211490005114905001CRUCETAund923.16000.0546.160.0000100212000054120048001TABLERO GENERAL CAJA METALICA INC CUCHILLASpza1.00001,300.001,300.000.000000212090004120904001CAJA RECTANG GALV 4"X2 1/8"und4.50002.9713.370.000000212090049120949001CAJA OCTOGONAL GALV. 4" X 2 1/8 "und12.60002.9737.420.000000212510018125113001ARTEFACTO FLUORESCENTE 2X36W AF (REACTOR ALPHA)und9.000055.00495.000.0000100213000006130006001ASFALTO LIQUIDO RC-250gln2.066110.3321.340.00000.000000217000028170026001LADRILLO K.K. 18 HCOS. 9X13X24 CM (TIPO IV)und4,404.27000.703,082.990.000000217010009170109001LADRILLO P/TECHO 15x30x30 CM 8 HCOS.und1,037.40001.982,054.05100217220006172205001CAJA DE MADERA PARA VALVULASund5.000013.5067.500.000000221000000210000001CEMENTO PORTLAND TIPO I (42.5KG)BOL4,507.947017.3778,303.040.0000100224000034240030001CERAMICA COLOR DE 30X30CMm260.669021.301,292.250.0000100224070016240716001LOSETA CERAMICA 20X30 CM.m280.661021.301,718.080.0000100226070065260755001CERRADURA EXTERIOR DE DOS GOLPES FORTE M-220 CON TIRADORund3.000045.00135.000.0000100226070068260755001CERRADURA DE CERROJO SIMPLEund7.000023.10161.700.0000100226800003268001001BISAGRA DE ACERO ALUMINIZADO DE 3"X3''und12.00002.3027.600.0000100226800005268001001BISAGRA DE ACERO ALUMINIZADO DE 2 1/2"X2 1/2''und14.00001.3518.900.000000229040001290401001CINTA AISLANTErll0.18002.120.380.000000229040091290491001CINTA TEFLONm16.85862.1235.740.000000230150016301516001PORCELANAkg23.04605.00115.230.000000230150019301516001PORCELANATO COLOR CLAROm24.200050.76213.190.000000230290021302921001PORCELANA BLANCAkg10.80005.0054.000.000000230460039304639001PEGAMENTO PARA PVCgln2.2120132.00291.980.000000230460041304638001PEGAMENTO PARA MAAYOLICA 25KGBOL19.205027.03519.110.000000230460042304638001PEGAMENTO PARA CERAMICABOL2.542327.0368.720.0000100230480035304833001CINTA AISLANTE 3/4''X20Mund0.45002.481.120.000000230480036304833001BANDA SEALIZADORA.m113.13750.1011.310.0000100230690006306905001FRAGUAkg0.90003.002.700.0000100230690007306905001PEGAMENTO EN BASE A CAUCHOgln1.047054.3056.850.0000100230690008306905001JEBE MICROPOROSO DE 1''X1CMpza1.1308228.20258.050.0000100230690009306905001ESPUMA PLASTICA DURA DE ALTA DENSIDAD 2X1M E=2pza2.638432.5685.910.000000230690013306905001FRAGUA COLORkg11.55605.0057.780.0000100230990007309907001CORDELm39.01000.5019.510.0000100230990056309956001CINTA TEFLONund29.00001.3739.730.0000100232010096320196001FLETE TERRESTRE DE MATERIALESGLB1.00002,000.002,000.000.00000.0000100238000000380000001HORMIGONm315.660225.00391.510.00000.000000239020071390271001COLA SINTETICAgln0.685016.1011.030.000000239020075390275001LIJA PARA MADERAund6.05001.368.230.0000100239020076390276001HIPOCLORITO DE CALCIO 70%kg0.247010.002.470.000000239020077390277001LIJA DE PAREDund42.94001.5365.700.000000239020078390275001LIJA PARA PAREDund0.15001.530.230.0000100239050000390500001AGUAm3117.54917.00822.840.0000100243010003430103001MADERA TORNILLOp212,473.77355.1564,239.930.0000100243030054430354001MADERA CEDROp2211.770010.002,117.700.000000243030055430355001RODOPLASTm43.67362.0388.660.0000100243030057430354001MADERA CEDRO CEPILLADAp29.000010.1791.530.0000100243160052431652001REGLA DE MADERAp2129.65605.40700.140.0000100244020018440215001MELAMINAm20.840055.0046.200.0000100244020019440215001PLANCHA MDF 5.5M X 2.14X2.6Mpln3.056462.00189.500.000000250020064500264001TRAMPA PVC SAL DE 2"und5.00005.6128.050.000000250020067500264001TRAMPA PVC SAL DE 4"und8.000012.0096.000.000000250020069500264001TRAMPA Y DESAGUE CROMADO PARA LAVATORIOund17.350037.67653.570.000000250020071500265001LLAVE DE LAVATORIO STANDAR L/ECO 130pza1.000045.0045.000.000000250020073500264001TRAMPA P C/REG 2'' DESAGUEund8.00005.6144.880.0000100250020077500265001LLAVE PARA LAVATORIO (MONOMANDO ECOLE)und8.000050.00400.000.0000100251200048512040001PLATINA METALICA 1''X4''X1/8''und18.00003.5063.000.000000251200049512031001ANGULO DE 1 1/4''X 1 1/4" x 1/8"X6Mm42.45003.95167.680.000000254010058540154001PINTURA LATEXgln10.735145.76491.240.0000100254110090541190001PINTURA ESMALTEgln2.282635.0079.890.000000254110102541190001TEMPLE BOLSA DE 25 KGBOL5.367821.10113.260.000000254210003542101001BASE ANTICORROSIVA ZINCROMATOgln2.207442.3793.530.000000254430002544302001THINERgln0.269614.323.860.0000100254430004544302001THOR GELkg2.000080.00160.000.000000254610001546101001SELLADORgln10.809214.41155.760.000000254610052546101001SELLADOR PARA MADERAgln0.650014.419.370.000000256020010560205001PLANCHA DE ACERO NEGRO 1/16'' (1.22MX2.4M)pln13.7538101.901,401.510.000000265050011650511001UNION UNIVERSAL DE Fo. GALV. DE 1/2"und10.00005.6856.800.000000265050020650511001UNION UNIVERSAL PVC DE 1/2"und10.00003.0530.500.000000265450059654555001NIPLE DE F GALV. DE 1/2'' A 3/4"und10.00003.3133.100.000000272010025720104001TUBERIA PVC SAP CLASE 10 SP DE 1/2''X5Mm68.34317.38504.370.000000272010027720104001TUBERIA PVC SAP CLASE 10 SP DE 3/4''X5Mm42.930410.23439.180.000000272010029720104001UNION SIMPLE PVC SAP CLASE 10 1/2'' ROSCADAund7.15401.339.510.000000272030007720307001UNION SP PVC SAP P/AGUA DE 3/4"und8.33601.3311.090.000000272030053720340001TUBERIA DE FIERRO GALVANIZADO DE 1 1/2''x6.40mm109.011612.201,329.940.000000272070010720710001TEE SP PVC SAP P/AGUA DE 1/2"und21.00001.2726.670.000000272070032720732001CODO DE 90C/R PVC SAP P/AGUA C-10 R. 1/2"und57.75001.0258.910.000000272070037720737001TEE SIMPLE PVC SAL DE 4"und16.00007.63122.080.000000272070039720718001CODO PVC SAL 2''X 45und45.50001.1652.780.000000272070040720718001CODO PVC SAL 2''X 90und60.70001.2777.090.000000272070044720718001CODO PVC SAL 4''X 45pza2.00004.458.900.000000272070045720710001TEE PVC SAP PARA AGUA CON ROSCA DE 1/2"und6.00001.277.620.0000000272070046720730001TANQUE ELEVADO ETERNIT DE 4 CAPAS 1,100 LT INC ACCESORIOSund2.0000415.17830.34100272540011725406001CODO PVC SAP P/AGUA CON ROSCA 1/2" x 90und22.00001.3028.600.000000273010029730129001TUBERIA PVC SAL 4"m59.13306.49383.770.000000273010045730129001TUBERIA PVC SAL 2" (DESAGUE)m102.21751.45148.220.000000273130024731324001TEE PVC SAL 2"X2"und2.60002.125.510.000000273160057731657001YEE PVC SAL DE 4" X 4"und2.00007.6315.260.000000273160059731659001YEE PVC SAL DE 2" X 2"und14.00002.2932.060.000000273160060731657001YEE PVC SAL DE 4" X 2"und1.00007.637.630.000000273230001732301001SOMBRERO DE VENTILACION PVC SAL 2"pza14.00003.3146.340.0000100274040003740402001CONEXION A CAJA PVC SEL 3/4"pza27.00000.308.100.0000100275010003750103001TUBO PVC SEL (E/C) 3/4" X 3.00 M.pza18.00005.80104.400.0000100275010020750103001TUBO PVC P ELECTRICO 20MMX3Mm1.00001.891.890.0000100275130005751305001CURVAS PVC SEL 3/4"pza27.00000.6016.200.0000100277080017770816001REGISTRO CON TAPA PARA POZO DE PUESTA A TIERRAund1.000067.0067.000.000000277080019770816001REGISTRO ROSCADO DE BRONCE DE 4" ROSCADOund5.000012.6363.150.0000100278600003786003001VALVULA COMPUERTA BRONCE 1"und5.000015.2076.000.0000100279010096790196001ESPEJO E=6MMp22.100045.0094.500.0000100279010102790199001VIDRIO TEMPLADO DE E=6MM GRIS INCLUYE ACCESORIOS PARA INSTALACIONm22.4500185.00453.250.0000100298010085CABLE NYY 1X10MM2m436.38757.903,447.460.0000100298010088PINTURA BARNIZgln0.325035.0011.380.0000100329040094290493001CIZALLA DE FIERRO DE CONSTRUCCION HASTA 1"hm2,008.59703.406,829.230.0000100330920002309201001TRANSPORTE DE EQUIPOS Y HERRAMIENTASGLB1.00001,500.001,500.000.0000000337010001370101001HERRAMIENTAS MANUALES%MO6,865.44100348040035480434001CAMION VOLQUETE 15 M3.hm13.4949150.002,024.240.0000100348080001480801001MOTOBOMBA A GASOLINA 3.5 HP 2"hm5.174212.0062.090.0000100349030001490301001COMPACTADOR VIBR. TIPO PLANCHA 4 HPhm185.088015.002,776.320.0000100349040012490408001CARGADOR S/LLANTAS 125-135 HP 3 YD3hm13.4948165.002,226.640.0000100349070004490704001VIBRADOR DE CONCRETO 4 HP 2.40"hm56.41938.00451.350.0000100349070006490703001VIBRADOR DE CONCRETO 4 HP 1.25"hm169.51908.001,356.150.00000.0000100349100007491007001MEZCLADORA CONCRETO TAMBOR 18HP 11P3hm127.245822.502,863.030.0000100349100014491011001MEZCLADORA CONCRETO TROMPO 9 -11P3hm120.564722.502,712.710.0000100349190001491901001TEODOLITOhm20.831310.00208.310.0000