{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["RESUMO","Posto Diurno Recife","Posto Noturno Recife","Mat e Equip - Uniformes"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"RESUMO","index":0,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[[6,1,6,10],[6,11,6,13],[4,2,4,7],[4,9,4,10],[4,12,4,13],[5,1,5,10],[5,11,5,13],[1,1,1,13],[2,2,2,7],[2,9,2,10],[2,12,2,13],[3,2,3,7],[3,9,3,10],[3,12,3,13]]}
[]
[null,"QUADRO RESUMO"]
[null,"ITEM","DESCRIÇÃO",{"$nulls":5},"Nº de Postos (A)","PREÇO MENSAL DO POSTO (B)",null,"PREÇO MENSAL TOTAL (R$) (C)=(AXB)","PREÇO GLOBAL (D)=C x 6"]
[null,1,"Posto de Vigilância 12 horas diurnas, de segunda-feira a domingos, envolvendo 02 (dois) vigilantes em turnos de 12 (doze) x 36 (trinta e seis) horas.",{"$nulls":5},1,{"$f":"SUM('Posto Diurno Recife'!J135:K135)","v":13592.03},null,{"$f":"J4*I4","v":13592.03},{"$f":"L4*'Posto Diurno Recife'!H9","v":81552.179999999993}]
[null,2,"Posto de Vigilância 12 horas noturnas, de segunda-feira a domingos, envolvendo 02 (dois) vigilantes em turnos de 12 (doze) x 36 (trinta e seis) horas. ",{"$nulls":5},1,{"$f":"'Posto Noturno Recife'!J135:K135","v":15758.34},null,{"$f":"J5*I5","v":15758.34},{"$f":"L5*'Posto Noturno Recife'!H9","v":94550.04}]
[null,"VALOR MENSAL TOTAL",{"$nulls":9},{"$f":"SUM(L4:L5)","v":29350.37}]
[null,"VALOR GLOBAL TOTAL",{"$nulls":9},{"$f":"SUM(M4:N5)","v":176102.22}]

{"sheet":"Posto Diurno Recife","index":1,"n_rows":135,"n_cols":12,"rows_kept":135,"cut":false,"hidden":false,"merged":[[133,1,133,8],[133,9,133,10],[134,0,134,8],[134,9,134,10],[135,0,136,10],[11,0,12,2],[11,3,12,10],[126,1,126,8],[126,9,126,10],[127,1,127,8],[127,9,127,10],[128,1,128,8],[128,9,128,10],[129,1,129,8],[129,9,129,10],[130,1,130,8],[130,9,130,10],[122,1,122,6],[122,7,122,8],[122,9,122,10],[123,0,123,8],[123,9,123,10],[124,0,124,10],[125,0,125,10],[132,0,132,8],[132,9,132,10],[117,1,117,10],[118,1,118,6],[118,7,118,8],[118,9,118,10],[119,1,119,6],[119,7,119,8],[119,9,119,10],[120,1,120,10],[121,1,121,10],[131,1,131,8],[131,9,131,10],[114,1,114,6],[114,7,114,8],[114,9,114,10],[115,1,115,6],[115,7,115,8],[115,9,115,10],[116,1,116,6],[116,7,116,8],[116,9,116,10],[102,0,102,6],[102,7,102,8],[102,9,102,10],[98,0,98,10],[111,0,111,10],[112,0,112,10],[113,1,113,6],[113,7,113,8],[113,9,113,10],[110,0,110,10],[109,1,109,7],[109,8,109,10],[108,1,108,4],[108,5,108,6],[108,8,108,10],[104,0,104,10],[105,0,105,10],[106,1,106,4],[106,5,106,6],[106,8,106,10],[107,1,107,4],[107,5,107,6],[107,8,107,10],[91,0,91,6],[91,7,91,8],[91,9,91,10],[100,1,100,6],[100,7,100,8],[100,9,100,10],[101,1,101,6],[101,7,101,8],[101,9,101,10],[99,0,99,10],[96,1,96,4],[96,5,96,6],[96,8,96,10],[97,8,97,10],[97,0,97,7],[95,1,95,4],[95,5,95,6],[95,8,95,10],[93,0,93,10],[94,0,94,10],[92,0,92,10],[87,1,87,6],[87,7,87,8],[88,1,88,6],[88,7,88,8],[89,1,89,6],[89,7,89,8],[90,1,90,6],[90,7,90,8],[90,9,90,10],[88,9,88,10],[89,9,89,10],[87,9,87,10],[39,9,39,10],[48,9,48,10],[49,1,49,6],[49,7,49,8],[49,9,49,10],[64,0,64,10],[68,9,68,10],[50,7,50,8],[86,9,86,10],[84,0,84,10],[85,1,85,6],[85,7,85,8],[85,9,85,10],[86,1,86,6],[86,7,86,8],[80,0,80,6],[80,7,80,8],[34,0,34,10],[35,0,35,10],[36,1,36,6],[36,7,36,8],[36,9,36,10],[69,0,69,6],[69,7,69,8],[69,9,69,10],[37,1,37,6],[37,7,37,8],[37,9,37,10],[38,1,38,6],[38,7,38,8],[38,9,38,10],[39,0,39,6],[39,7,39,8],[76,1,76,6],[76,7,76,8],[76,9,76,10],[77,1,77,6],[78,1,78,6],[78,7,78,8],[78,9,78,10],[79,1,79,6],[79,7,79,8],[79,9,79,10],[77,7,77,8],[77,9,77,10],[73,1,73,6],[73,7,73,8],[41,0,41,10],[42,0,42,10],[43,1,43,6],[43,7,43,8],[43,9,43,10],[44,1,44,6],[44,7,44,8],[44,9,44,10],[45,1,45,6],[45,7,45,8],[45,9,45,10],[46,1,46,6],[46,7,46,8],[46,9,46,10],[47,1,47,6],[47,7,47,8],[47,9,47,10],[48,1,48,6],[48,7,48,8],[63,1,63,7],[63,8,63,10],[50,1,50,6],[50,9,50,10],[51,1,51,6],[51,7,51,8],[51,9,51,10],[52,0,52,6],[52,7,52,8],[52,9,52,10],[59,8,59,10],[60,1,60,4],[60,5,60,6],[60,8,60,10],[61,1,61,4],[61,5,61,6],[61,8,61,10],[62,1,62,4],[62,5,62,6],[62,8,62,10],[83,0,83,10],[80,9,80,10],[81,0,81,10],[82,0,82,10],[65,0,65,10],[66,1,66,6],[66,7,66,8],[66,9,66,10],[67,1,67,6],[67,7,67,8],[71,0,71,10],[72,0,72,10],[73,9,73,10],[74,1,74,6],[74,7,74,8],[74,9,74,10],[75,1,75,6],[75,7,75,8],[75,9,75,10],[31,1,31,7],[31,8,31,10],[32,0,32,10],[33,0,33,10],[55,0,55,10],[56,1,56,4],[56,5,56,6],[56,8,56,10],[54,0,54,10],[40,0,40,10],[53,0,53,10],[70,0,70,10],[57,1,57,4],[57,5,57,6],[57,8,57,10],[58,1,58,4],[58,5,58,6],[58,8,58,10],[59,1,59,4],[59,5,59,6],[67,9,67,10],[68,1,68,6],[68,7,68,8],[28,1,28,4],[28,5,28,6],[28,8,28,10],[29,1,29,4],[29,5,29,6],[29,8,29,10],[30,1,30,4],[30,5,30,6],[30,8,30,10],[23,0,23,10],[24,0,24,10],[25,0,25,10],[26,1,26,4],[26,5,26,6],[26,8,26,10],[27,1,27,4],[27,5,27,6],[27,8,27,10],[17,0,17,10],[18,1,18,10],[19,1,19,7],[19,8,19,10],[20,1,20,7],[20,8,20,10],[21,1,21,7],[21,8,21,10],[22,1,22,7],[22,8,22,10],[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,10],[4,0,4,6],[5,1,5,6],[5,7,5,10],[6,1,6,6],[6,7,6,10],[15,0,15,10],[16,0,16,10],[7,1,7,6],[7,7,7,10],[8,1,8,6],[8,7,8,10],[9,0,9,10],[10,0,10,10],[13,0,13,2],[13,3,13,10],[14,0,14,10]]}
["CODEVASF RECIFE"]
["PLANILHA DE CUSTOS E FORMAÇÃO DE PREÇOS"]
["N° Processo: 59501.000532/2025-13"]
["Licitação N° "]
["Discriminação dos Serviços (dados referentes à contratação)"]
["A","Data de apresentação da proposta (dia/mês/ano)"]
["B","Município/UF",{"$nulls":5},"Recife/PE"]
["C","Ano Acordo, Convenção ou Sentença Normativa em Dissídio Coletivo",{"$nulls":5},2025]
["D","Nº de meses de execução contratual",{"$nulls":5},6]
[]
["IDENTIFICAÇÃO DO SERVIÇO"]
["Tipo de Serviço",null,null,"Unidade de Medida"]
[]
["Vigilância Patrimonial",null,null,"POSTO DE SERVIÇO"]
[]
[" Mão-de-obra"]
[]
["Dados a contratação dos custos referente à mão-de-obra"]
[1,"Tipo de serviço (mesmo serviço com características distintas)"]
[2,"Salário Normativo da Categoria Profissional",{"$nulls":6},1699.46]
[3,"Categoria profissional (vinculada à execução contratual)",{"$nulls":6},"Vigilância Armada 12 Horas Diurna"]
[null,"Classificação Brasileira de Ocupações (CBO)",{"$nulls":6}," CBO 5173-30"]
[4,"Data base da categoria (dia/mês/ano)",{"$nulls":6},"2025-01-01"]
[]
["MÓDULO 1 - Composição da remuneração"]
[]
[1,"Remuneração",null,null,null,"Valor Unitário",null,null,"Valor (R$)"]
["A","Salário Base",null,null,null,{"$f":"I20","v":1699.46},null,2,{"$f":"F28*H28","v":3398.92}]
["B","Adicional de Periculosidade",null,null,null,{"$f":"F28*30%","v":509.84},null,2,{"$f":"F29*H29","v":1019.68}]
["C","Adicional Noturno",null,null,null,0,null,2,0]
["D","Hora Noturna Reduzida",null,null,null,0,null,2,0]
[null,"Total da Remuneração",{"$nulls":6},{"$f":"SUM(I28:K31)","v":4418.6000000000004}]
[]
["MÓDULO 2 - Encargos e Benefícios Anuais, Mensais e Diários"]
["Submódulo 2.1 - 13° (décimo terceiro) Salário, Férias e Adicional de Férias"]
[]
["2.1","13° Salário, Férias e Adicional de Férias",{"$nulls":5},"%",null,"Valor (R$)"]
["A","13° Salário",{"$nulls":5},8.3299999999999999E-2,null,{"$f":"$I$32*H38","v":368.07}]
["B","Férias e Adicional de Férias",{"$nulls":5},0.1111,null,{"$f":"$I$32*H39","v":490.91}]
["TOTAL",{"$nulls":6},{"$f":"SUM(H38:I39)","v":0.19439999999999999},null,{"$f":"SUM(J38:K39)","v":858.98}]
[]
["Submódulo 2.2 - Encargos previdenciários, FGTS e outras contribuições"]
[]
["2.2","Encargos previdenciários, FGTS e outras contribuições",{"$nulls":5},"%",null,"Valor (R$)"]
["A","INSS",{"$nulls":5},0.2,null,{"$f":"($I$32+$J$40)*H45","v":1055.52}]
["B","SESI ou SESC",{"$nulls":5},1.4999999999999999E-2,null,{"$f":"($I$32+$J$40)*H46","v":79.16}]
["C","SENAI ou SENAC",{"$nulls":5},0.01,null,52.78]
["D","INCRA",{"$nulls":5},2E-3,null,10.56]
["E","Salário Educação",{"$nulls":5},2.5000000000000001E-2,null,131.94]
["F","FGTS",{"$nulls":5},0.08,null,422.21]
["G","Seguro Acidente do Trabalho",{"$nulls":5},0.03,null,158.33000000000001]
["H","SEBRAE",{"$nulls":5},6.0000000000000001E-3,null,31.67]
["TOTAL",{"$nulls":6},{"$f":"SUM(H45:I52)","v":0.36799999999999999},null,{"$f":"SUM(J45:K52)","v":1942.17}]
[]
["Submódulo 2.3 - Benefícios Mensais e Diários"]
[]
["2.3","Benefícios Mensais e Diários",null,null,null,"Valor Unitário",null,null,"Valor (R$)"]
["A","Transporte",null,null,null,{"$f":"(15*2*4.3)-(F28*6%)","v":27.03},null,2,{"$f":"F58*H58","v":54.06}]
["B","Auxílio Alimentação (R$ 39,53 por dia)",null,null,null,{"$f":"(40.53-1)*15","v":592.95000000000005},null,2,{"$f":"F59*H59","v":1185.9000000000001},null,null,"cláusula décima quarta"]
["C","Beneficios Sociais",null,null,null,67.319999999999993,null,2,134.63999999999999,null,null,"parágrafo segundo da cláusula décima sexta"]
["D","Seguro de Vida, invalidez e funeral",null,null,null,{"$f":"((26*I20)+(52*I20))*0.0078%+3000*0.00955%","v":10.63},null,2,{"$f":"F61*H61","v":21.26},null,null,"((26xsal normativo)+(52xsal normativo))x0,0078%+3000*0,00955%  por vigilante (Fórmula definida no subitem 5.3.5 - Seguro de vida, invalidez e funeral - do Caderno de Logística Prestação de Serviços de Vigilância Patrimonial - MPOG/SLTI, de abril/2014)"]
["E","Assiduidade",null,null,null,80,null,2,160,null,null,"cláusula décima segunda"]
["F","Jovem Aprendiz",null,null,null,141.04,null,2,282.08,null,null,"cláusula vigésima sexta"]
[null,"Total de Benefícios mensais e diários",{"$nulls":6},{"$f":"SUM(I58:K63)","v":1837.94}]
[]
["QUADRO-RESUMO - Módulo 2 - Encargos e Benefícios Anuais, Mensais e Diários"]
["2.1","13° Salário, Férias e Adicional de Férias",{"$nulls":5},{"$f":"H40","v":0.19439999999999999},null,{"$f":"J40","v":858.98}]
["2.2","Encargos previdenciários, FGTS e outras contribuições",{"$nulls":5},{"$f":"H53","v":0.36799999999999999},null,{"$f":"J53","v":1942.17}]
["2.3","Benefícios Mensais e Diários",{"$nulls":7},{"$f":"I64","v":1837.94}]
["TOTAL",{"$nulls":8},{"$f":"SUM(J67:K69)","v":4639.09}]
[]
["MÓDULO 3 - Provisão para Rescisão"]
[]
[3,"Provisão para Rescisão",{"$nulls":5},"%",null,"Valor (R$)"]
["A","Aviso prévio indenizado",{"$nulls":5},4.1999999999999997E-3,null,{"$f":"$I$32*H75","v":18.559999999999999}]
["B","Incidência do FGTS sobre o aviso prévio indenizado",{"$nulls":5},{"$f":"H50*H75","v":2.9999999999999997E-4},null,{"$f":"$I$32*H76","v":1.33}]
["C","Multa sobre FGTS sobre o aviso prévio indenizado",{"$nulls":5},8.0000000000000002E-3,null,35.35]
["D","Aviso prévio trabalhado",{"$nulls":5},1.9400000000000001E-2,null,85.72]
["E","Incidência dos encargos do submódulo 4.1 sobre aviso prévio trabalhado",{"$nulls":5},{"$f":"H53*H78","v":7.1000000000000004E-3},null,31.37]
["F","Multa sobre FGTS sobre o aviso prévio trabalhado",{"$nulls":5},3.2000000000000001E-2,null,141.4]
["TOTAL",{"$nulls":6},{"$f":"SUM(H75:I80)","v":7.0999999999999994E-2},null,{"$f":"SUM(J75:K80)","v":313.73}]
[]
["MÓDULO 4 - Custo de Reposição do Profissional Ausente e Intrajornada"]
["Submódulo 4.1 - Custo de Reposição do Profissional Ausente"]
[]
["4.1","Custo de Reposição do Profissional Ausente",{"$nulls":5},"%",null,"Valor (R$)"]
["A","Férias",{"$nulls":5},8.3299999999999999E-2,null,{"$f":"($I$32+$J$70+$J$81)*H87","v":780.64}]
["B","Ausências por doença",{"$nulls":5},7.0000000000000001E-3,null,{"$f":"($I$32+$J$70+$J$81)*H88","v":65.599999999999994}]
["C","Licença Paternidade",{"$nulls":5},5.0000000000000001E-3,null,46.86]
["D","Ausências legais",{"$nulls":5},3.0000000000000001E-3,null,28.11]
["E","Ausência por Acidente de Trabalho",{"$nulls":5},3.0000000000000001E-3,null,28.11]
["TOTAL",{"$nulls":6},{"$f":"SUM(H87:I91)","v":0.1013},null,{"$f":"SUM(J87:K91)","v":949.32}]
[]
["Submódulo 4.2 - Intrajornada"]
[]
["4.2","Intrajornada",null,null,null,"Valor Unitário",null,null,"Valor (R$)"]
["A","Intrajornada Diurna",null,null,null,{"$f":"(((SUM(F28:G31)/220)*1.5)*(30/2))","v":225.95},null,2,{"$f":"F97*H97","v":451.9}]
["TOTAL",{"$nulls":7},{"$f":"I97","v":451.9}]
[]
["QUADRO-RESUMO - Módulo 4 - Custo de Reposição do Profissional Ausente e Intrajornada"]
["4.1","Custo de Reposição do Profissional Ausente",{"$nulls":5},{"$f":"H92","v":0.1013},null,{"$f":"J92","v":949.32}]
["4.2","Intrajornada",{"$nulls":7},{"$f":"I97","v":451.9}]
["TOTAL",{"$nulls":8},{"$f":"SUM(J101:K102)","v":1401.22}]
[]
["MÓDULO 5 - Insumos Diversos"]
[]
[5,"Insumos Diversos",null,null,null,"Valor Unitário",null,null,"Valor (R$)"]
["A","Materiais e Equipamentos",null,null,null,{"$f":"'Mat e Equip - Uniformes'!F13","v":65.930000000000007},null,2,{"$f":"F108*H108","v":131.86000000000001}]
["B","Uniformes",null,null,null,{"$f":"'Mat e Equip - Uniformes'!B23","v":32.119999999999997},null,2,{"$f":"F109*H109","v":64.239999999999995}]
[null,"Total de Insumos Diversos",{"$nulls":6},{"$f":"SUM(I108:K109)","v":196.1}]
[]
["MÓDULO 6 - Custos indiretos, tributos e lucros"]
[]
[6,"Custos indiretos, tributos e lucros",{"$nulls":5},"%",null,"Valor (R$)"]
["A","Custos Indiretos",{"$nulls":5},0.06,null,{"$f":"J133*H115","v":658.12}]
["B","Lucros",{"$nulls":5},6.7900000000000002E-2,null,{"$f":"(J115+J133)*H116","v":789.46}]
["C","Tributos",{"$nulls":5},{"$f":"H119+H120+H123","v":8.6499999999999994E-2},null,{"$f":"J119+J120+J123","v":1175.71}]
[null,"B.1 Tributos Federais"]
[null,"COFINS",{"$nulls":5},0.03,null,{"$f":"(L119/(1-H117))*H119","v":407.76},null,{"$f":"J133+J115+J116","v":12416.32}]
[null,"PIS",{"$nulls":5},6.4999999999999997E-3,null,{"$f":"(L119/(1-H117))*H120","v":88.35}]
[null,"B.2 Tributos Estaduais"]
[null,"B.3 Tributos Municipais"]
[null,"ISS",{"$nulls":5},0.05,null,{"$f":"(L119/(1-H117))*H123","v":679.6}]
["TOTAL",{"$nulls":8},{"$f":"J115+J117+J116","v":2623.29}]
[]
["Anexo III - B - Quadro-resumo do Custo por Posto de Serviço"]
[null,"Mão-de-obra vinculada à execução contratual (valor por empregado)",{"$nulls":7},"(R$)"]
["A","Módulo 1 - Composição da Remuneração",{"$nulls":7},{"$f":"I32","v":4418.6000000000004}]
["B","Módulo 2 - Encargos e Benefícios Anuais, Mensais e Diários",{"$nulls":7},{"$f":"J70","v":4639.09}]
["C","Módulo 3 - Provisão para Rescisão",{"$nulls":7},{"$f":"J81","v":313.73}]
["D","Módulo 4 - Custo de Reposição do Profissional Ausente e Intrajornada",{"$nulls":7},{"$f":"J103","v":1401.22}]
["E","Módulo 5 - Insumos Diversos",{"$nulls":7},{"$f":"I110","v":196.1}]
["Subtotal (A + B + C + D + E)",{"$nulls":8},{"$f":"SUM(J128:K132)","v":10968.74}]
["F","Módulo 6 - Custos indiretos, tributos e lucro",{"$nulls":7},{"$f":"J124","v":2623.29}]
["Valor total do Posto de Vigilância 12 horas diurnas com 02 vigilantes",{"$nulls":8},{"$f":"SUM(J133:K134)","v":13592.03}]

{"sheet":"Posto Noturno Recife","index":2,"n_rows":135,"n_cols":12,"rows_kept":135,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,10],[4,0,4,6],[5,1,5,6],[5,7,5,10],[9,0,9,10],[10,0,10,10],[11,0,12,2],[11,3,12,10],[13,0,13,2],[13,3,13,10],[6,1,6,6],[6,7,6,10],[7,1,7,6],[7,7,7,10],[8,1,8,6],[8,7,8,10],[20,1,20,7],[20,8,20,10],[21,1,21,7],[21,8,21,10],[22,1,22,7],[22,8,22,10],[14,0,14,10],[15,0,15,10],[16,0,16,10],[17,0,17,10],[18,1,18,10],[19,1,19,7],[19,8,19,10],[27,1,27,4],[27,5,27,6],[27,8,27,10],[28,1,28,4],[28,5,28,6],[28,8,28,10],[23,0,23,10],[24,0,24,10],[25,0,25,10],[26,1,26,4],[26,5,26,6],[26,8,26,10],[31,1,31,7],[31,8,31,10],[32,0,32,10],[33,0,33,10],[34,0,34,10],[35,0,35,10],[29,1,29,4],[29,5,29,6],[29,8,29,10],[30,1,30,4],[30,5,30,6],[30,8,30,10],[38,1,38,6],[38,7,38,8],[38,9,38,10],[39,0,39,6],[39,7,39,8],[39,9,39,10],[36,1,36,6],[36,7,36,8],[36,9,36,10],[37,1,37,6],[37,7,37,8],[37,9,37,10],[44,1,44,6],[44,7,44,8],[44,9,44,10],[45,1,45,6],[45,7,45,8],[45,9,45,10],[40,0,40,10],[41,0,41,10],[42,0,42,10],[43,1,43,6],[43,7,43,8],[43,9,43,10],[48,1,48,6],[48,7,48,8],[48,9,48,10],[49,1,49,6],[49,7,49,8],[49,9,49,10],[46,1,46,6],[46,7,46,8],[46,9,46,10],[47,1,47,6],[47,7,47,8],[47,9,47,10],[52,0,52,6],[52,7,52,8],[52,9,52,10],[53,0,53,10],[54,0,54,10],[55,0,55,10],[50,1,50,6],[50,7,50,8],[50,9,50,10],[51,1,51,6],[51,7,51,8],[51,9,51,10],[58,1,58,4],[58,5,58,6],[58,8,58,10],[59,1,59,4],[59,5,59,6],[59,8,59,10],[56,1,56,4],[56,5,56,6],[56,8,56,10],[57,1,57,4],[57,5,57,6],[57,8,57,10],[62,1,62,4],[62,5,62,6],[62,8,62,10],[63,1,63,7],[63,8,63,10],[64,0,64,10],[60,1,60,4],[60,5,60,6],[60,8,60,10],[61,1,61,4],[61,5,61,6],[61,8,61,10],[68,1,68,6],[68,7,68,8],[68,9,68,10],[69,0,69,6],[69,7,69,8],[69,9,69,10],[65,0,65,10],[66,1,66,6],[66,7,66,8],[66,9,66,10],[67,1,67,6],[67,7,67,8],[67,9,67,10],[74,1,74,6],[74,7,74,8],[74,9,74,10],[75,1,75,6],[75,7,75,8],[75,9,75,10],[70,0,70,10],[71,0,71,10],[72,0,72,10],[73,1,73,6],[73,7,73,8],[73,9,73,10],[78,1,78,6],[78,7,78,8],[78,9,78,10],[79,1,79,6],[79,7,79,8],[79,9,79,10],[76,1,76,6],[76,7,76,8],[76,9,76,10],[77,1,77,6],[77,7,77,8],[77,9,77,10],[84,0,84,10],[85,1,85,6],[85,7,85,8],[85,9,85,10],[86,1,86,6],[86,7,86,8],[86,9,86,10],[80,0,80,6],[80,7,80,8],[80,9,80,10],[81,0,81,10],[82,0,82,10],[83,0,83,10],[89,1,89,6],[89,7,89,8],[89,9,89,10],[90,1,90,6],[90,7,90,8],[90,9,90,10],[87,1,87,6],[87,7,87,8],[87,9,87,10],[88,1,88,6],[88,7,88,8],[88,9,88,10],[95,1,95,4],[95,5,95,6],[95,8,95,10],[96,1,96,4],[96,5,96,6],[96,8,96,10],[91,0,91,6],[91,7,91,8],[91,9,91,10],[92,0,92,10],[93,0,93,10],[94,0,94,10],[101,1,101,6],[101,7,101,8],[101,9,101,10],[102,0,102,6],[102,7,102,8],[102,9,102,10],[97,0,97,7],[97,8,97,10],[98,0,98,10],[99,0,99,10],[100,1,100,6],[100,7,100,8],[100,9,100,10],[108,1,108,4],[108,5,108,6],[108,8,108,10],[109,1,109,7],[109,8,109,10],[110,0,110,10],[104,0,104,10],[105,0,105,10],[106,1,106,4],[106,5,106,6],[106,8,106,10],[107,1,107,4],[107,5,107,6],[107,8,107,10],[115,1,115,6],[115,7,115,8],[115,9,115,10],[116,1,116,6],[116,7,116,8],[116,9,116,10],[111,0,111,10],[112,0,112,10],[113,1,113,6],[113,7,113,8],[113,9,113,10],[114,1,114,6],[114,7,114,8],[114,9,114,10],[120,1,120,10],[121,1,121,10],[122,1,122,6],[122,7,122,8],[122,9,122,10],[123,0,123,8],[123,9,123,10],[117,1,117,10],[118,1,118,6],[118,7,118,8],[118,9,118,10],[119,1,119,6],[119,7,119,8],[119,9,119,10],[128,1,128,8],[128,9,128,10],[129,1,129,8],[129,9,129,10],[130,1,130,8],[130,9,130,10],[124,0,124,10],[125,0,125,10],[126,1,126,8],[126,9,126,10],[127,1,127,8],[127,9,127,10],[134,0,134,8],[134,9,134,10],[135,0,136,10],[131,1,131,8],[131,9,131,10],[132,0,132,8],[132,9,132,10],[133,1,133,8],[133,9,133,10]]}
["CODEVASF RECIFE"]
["PLANILHA DE CUSTOS E FORMAÇÃO DE PREÇOS"]
["N° Processo: 59501.000532/2025-13"]
["Licitação N° "]
["Discriminação dos Serviços (dados referentes à contratação)"]
["A","Data de apresentação da proposta (dia/mês/ano)"]
["B","Município/UF",{"$nulls":5},"Recife/PE"]
["C","Ano Acordo, Convenção ou Sentença Normativa em Dissídio Coletivo",{"$nulls":5},2025]
["D","Nº de meses de execução contratual",{"$nulls":5},6]
[]
["IDENTIFICAÇÃO DO SERVIÇO"]
["Tipo de Serviço",null,null,"Unidade de Medida"]
[]
["Vigilância Patrimonial",null,null,"POSTO DE SERVIÇO"]
[]
[" Mão-de-obra"]
[]
["Dados a contratação dos custos referente à mão-de-obra"]
[1,"Tipo de serviço (mesmo serviço com características distintas)"]
[2,"Salário Normativo da Categoria Profissional",{"$nulls":6},1699.46]
[3,"Categoria profissional (vinculada à execução contratual)",{"$nulls":6},"Vigilância Armada 12 Horas Noturna"]
[null,"Classificação Brasileira de Ocupações (CBO)",{"$nulls":6}," CBO 5173-30"]
[4,"Data base da categoria (dia/mês/ano)",{"$nulls":6},"2025-01-01"]
[]
["MÓDULO 1 - Composição da remuneração"]
[]
[1,"Remuneração",null,null,null,"Valor Unitário",null,null,"Valor (R$)"]
["A","Salário Base",null,null,null,{"$f":"I20","v":1699.46},null,2,{"$f":"F28*H28","v":3398.92}]
["B","Adicional de Periculosidade",null,null,null,{"$f":"F28*30%","v":509.84},null,2,{"$f":"F29*H29","v":1019.68}]
["C","Adicional Noturno",null,null,null,{"$f":"((F28+F29)/220)*20%*(60/52.5)*7*15","v":241.01},null,2,482.02]
["D","Hora Noturna Reduzida",null,null,null,{"$f":"((F29+F28+F30)/220)*1.2*15","v":200.48},null,2,400.96]
[null,"Total da Remuneração",{"$nulls":6},{"$f":"SUM(I28:K31)","v":5301.58}]
[]
["MÓDULO 2 - Encargos e Benefícios Anuais, Mensais e Diários"]
["Submódulo 2.1 - 13° (décimo terceiro) Salário, Férias e Adicional de Férias"]
[]
["2.1","13° Salário, Férias e Adicional de Férias",{"$nulls":5},"%",null,"Valor (R$)"]
["A","13° Salário",{"$nulls":5},8.3299999999999999E-2,null,{"$f":"$I$32*H38","v":441.62}]
["B","Férias e Adicional de Férias",{"$nulls":5},0.1111,null,{"$f":"$I$32*H39","v":589.01}]
["TOTAL",{"$nulls":6},{"$f":"SUM(H38:I39)","v":0.19439999999999999},null,{"$f":"SUM(J38:K39)","v":1030.6300000000001}]
[]
["Submódulo 2.2 - Encargos previdenciários, FGTS e outras contribuições"]
[]
["2.2","Encargos previdenciários, FGTS e outras contribuições",{"$nulls":5},"%",null,"Valor (R$)"]
["A","INSS",{"$nulls":5},0.2,null,{"$f":"($I$32+$J$40)*H45","v":1266.44}]
["B","SESI ou SESC",{"$nulls":5},1.4999999999999999E-2,null,{"$f":"($I$32+$J$40)*H46","v":94.98}]
["C","SENAI ou SENAC",{"$nulls":5},0.01,null,63.32]
["D","INCRA",{"$nulls":5},2E-3,null,12.66]
["E","Salário Educação",{"$nulls":5},2.5000000000000001E-2,null,158.31]
["F","FGTS",{"$nulls":5},0.08,null,506.58]
["G","Seguro Acidente do Trabalho",{"$nulls":5},0.03,null,189.97]
["H","SEBRAE",{"$nulls":5},6.0000000000000001E-3,null,37.99]
["TOTAL",{"$nulls":6},{"$f":"SUM(H45:I52)","v":0.36799999999999999},null,{"$f":"SUM(J45:K52)","v":2330.25}]
[]
["Submódulo 2.3 - Benefícios Mensais e Diários"]
[]
["2.3","Benefícios Mensais e Diários",null,null,null,"Valor Unitário",null,null,"Valor (R$)"]
["A","Transporte",null,null,null,{"$f":"(15*2*4.3)-(F28*6%)","v":27.03},null,2,{"$f":"F58*H58","v":54.06}]
["B","Auxílio Alimentação (R$ 39,53 por dia)",null,null,null,{"$f":"(40.53-1)*15","v":592.95000000000005},null,2,{"$f":"F59*H59","v":1185.9000000000001},null,null,"cláusula décima quarta"]
["C","Beneficios Sociais",null,null,null,67.319999999999993,null,2,134.63999999999999,null,null,"parágrafo segundo da cláusula décima sexta"]
["D","Seguro de Vida, invalidez e funeral",null,null,null,{"$f":"((26*I20)+(52*I20))*0.0078%+3000*0.00955%","v":10.63},null,2,21.26,null,null,"((26xsal normativo)+(52xsal normativo))x0,0078%+3000*0,00955%  por vigilante (Fórmula definida no subitem 5.3.5 - Seguro de vida, invalidez e funeral - do Caderno de Logística Prestação de Serviços de Vigilância Patrimonial - MPOG/SLTI, de abril/2014)"]
["E","Assiduidade",null,null,null,80,null,2,160,null,null,"cláusula décima segunda"]
["F","Jovem Aprendiz",null,null,null,141.04,null,2,282.08,null,null,"cláusula vigésima sexta"]
[null,"Total de Benefícios mensais e diários",{"$nulls":6},{"$f":"SUM(I58:K63)","v":1837.94}]
[]
["QUADRO-RESUMO - Módulo 2 - Encargos e Benefícios Anuais, Mensais e Diários"]
["2.1","13° Salário, Férias e Adicional de Férias",{"$nulls":5},{"$f":"H40","v":0.19439999999999999},null,{"$f":"J40","v":1030.6300000000001}]
["2.2","Encargos previdenciários, FGTS e outras contribuições",{"$nulls":5},{"$f":"H53","v":0.36799999999999999},null,{"$f":"J53","v":2330.25}]
["2.3","Benefícios Mensais e Diários",{"$nulls":7},{"$f":"I64","v":1837.94}]
["TOTAL",{"$nulls":8},{"$f":"SUM(J67:K69)","v":5198.82}]
[]
["MÓDULO 3 - Provisão para Rescisão"]
[]
[3,"Provisão para Rescisão",{"$nulls":5},"%",null,"Valor (R$)"]
["A","Aviso prévio indenizado",{"$nulls":5},4.1999999999999997E-3,null,{"$f":"$I$32*H75","v":22.27}]
["B","Incidência do FGTS sobre o aviso prévio indenizado",{"$nulls":5},{"$f":"H50*H75","v":2.9999999999999997E-4},null,{"$f":"$I$32*H76","v":1.59}]
["C","Multa sobre FGTS sobre o aviso prévio indenizado",{"$nulls":5},8.0000000000000002E-3,null,42.41]
["D","Aviso prévio trabalhado",{"$nulls":5},1.9400000000000001E-2,null,102.85]
["E","Incidência dos encargos do submódulo 4.1 sobre aviso prévio trabalhado",{"$nulls":5},{"$f":"H53*H78","v":7.1000000000000004E-3},null,37.64]
["F","Multa sobre FGTS sobre o aviso prévio trabalhado",{"$nulls":5},3.2000000000000001E-2,null,169.65]
["TOTAL",{"$nulls":6},{"$f":"SUM(H75:I80)","v":7.0999999999999994E-2},null,{"$f":"SUM(J75:K80)","v":376.41}]
[]
["MÓDULO 4 - Custo de Reposição do Profissional Ausente e Intrajornada"]
["Submódulo 4.1 - Custo de Reposição do Profissional Ausente"]
[]
["4.1","Custo de Reposição do Profissional Ausente",{"$nulls":5},"%",null,"Valor (R$)"]
["A","Férias",{"$nulls":5},8.3299999999999999E-2,null,{"$f":"($I$32+$J$70+$J$81)*H87","v":906.04}]
["B","Ausências por doença",{"$nulls":5},7.0000000000000001E-3,null,{"$f":"($I$32+$J$70+$J$81)*H88","v":76.14}]
["C","Licença Paternidade",{"$nulls":5},5.0000000000000001E-3,null,54.38]
["D","Ausências legais",{"$nulls":5},3.0000000000000001E-3,null,32.630000000000003]
["E","Ausência por Acidente de Trabalho",{"$nulls":5},3.0000000000000001E-3,null,32.630000000000003]
["TOTAL",{"$nulls":6},{"$f":"SUM(H87:I91)","v":0.1013},null,{"$f":"SUM(J87:K91)","v":1101.82}]
[]
["Submódulo 4.2 - Intrajornada"]
[]
["4.2","Intrajornada",null,null,null,"Valor Unitário",null,null,"Valor (R$)"]
["A","Intrajornada Noturna",null,null,null,{"$f":"(((SUM(F28:G31)/220)*1.5)*(30/2))","v":271.10000000000002},null,2,{"$f":"F97*H97","v":542.20000000000005}]
["TOTAL",{"$nulls":7},{"$f":"I97","v":542.20000000000005}]
[]
["QUADRO-RESUMO - Módulo 4 - Custo de Reposição do Profissional Ausente e Intrajornada"]
["4.1","Custo de Reposição do Profissional Ausente",{"$nulls":5},{"$f":"H92","v":0.1013},null,{"$f":"J92","v":1101.82}]
["4.2","Intrajornada",{"$nulls":7},{"$f":"I97","v":542.20000000000005}]
["TOTAL",{"$nulls":8},{"$f":"SUM(J101:K102)","v":1644.02}]
[]
["MÓDULO 5 - Insumos Diversos"]
[]
[5,"Insumos Diversos",null,null,null,"Valor Unitário",null,null,"Valor (R$)"]
["A","Materiais e Equipamentos",null,null,null,{"$f":"'Mat e Equip - Uniformes'!F13","v":65.930000000000007},null,2,{"$f":"F108*H108","v":131.86000000000001}]
["B","Uniformes",null,null,null,{"$f":"'Mat e Equip - Uniformes'!B23","v":32.119999999999997},null,2,{"$f":"F109*H109","v":64.239999999999995}]
[null,"Total de Insumos Diversos",{"$nulls":6},{"$f":"SUM(I108:K109)","v":196.1}]
[]
["MÓDULO 6 - Custos indiretos, tributos e lucros"]
[]
[6,"Custos indiretos, tributos e lucros",{"$nulls":5},"%",null,"Valor (R$)"]
["A","Custos Indiretos",{"$nulls":5},0.06,null,{"$f":"J133*H115","v":763.02}]
["B","Lucros",{"$nulls":5},6.7900000000000002E-2,null,{"$f":"(J115+J133)*H116","v":915.29}]
["C","Tributos",{"$nulls":5},{"$f":"H119+H120+H123","v":8.6499999999999994E-2},null,{"$f":"J119+J120+J123","v":1363.1}]
[null,"B.1 Tributos Federais"]
[null,"COFINS",{"$nulls":5},0.03,null,{"$f":"(L119/(1-H117))*H119","v":472.75},null,{"$f":"J133+J115+J116","v":14395.24}]
[null,"PIS",{"$nulls":5},6.4999999999999997E-3,null,{"$f":"(L119/(1-H117))*H120","v":102.43}]
[null,"B.2 Tributos Estaduais"]
[null,"B.3 Tributos Municipais"]
[null,"ISS",{"$nulls":5},0.05,null,{"$f":"(L119/(1-H117))*H123","v":787.92}]
["TOTAL",{"$nulls":8},{"$f":"J115+J117+J116","v":3041.41}]
[]
["Anexo III - B - Quadro-resumo do Custo por Posto de Serviço"]
[null,"Mão-de-obra vinculada à execução contratual (valor por empregado)",{"$nulls":7},"(R$)"]
["A","Módulo 1 - Composição da Remuneração",{"$nulls":7},{"$f":"I32","v":5301.58}]
["B","Módulo 2 - Encargos e Benefícios Anuais, Mensais e Diários",{"$nulls":7},{"$f":"J70","v":5198.82}]
["C","Módulo 3 - Provisão para Rescisão",{"$nulls":7},{"$f":"J81","v":376.41}]
["D","Módulo 4 - Custo de Reposição do Profissional Ausente e Intrajornada",{"$nulls":7},{"$f":"J103","v":1644.02}]
["E","Módulo 5 - Insumos Diversos",{"$nulls":7},{"$f":"I110","v":196.1}]
["Subtotal (A + B + C + D + E)",{"$nulls":8},{"$f":"SUM(J128:K132)","v":12716.93}]
["F","Módulo 6 - Custos indiretos, tributos e lucro",{"$nulls":7},{"$f":"J124","v":3041.41}]
["Valor total do Posto de Vigilância 12 horas noturnas com 02 vigilantes",{"$nulls":8},{"$f":"SUM(J133:K134)","v":15758.34}]

{"sheet":"Mat e Equip - Uniformes","index":3,"n_rows":79,"n_cols":7,"rows_kept":79,"cut":false,"hidden":false,"merged":[[0,0,0,5],[2,1,2,5],[4,0,4,5],[6,0,6,5],[16,0,16,1],[13,0,13,5]]}
["PLANILHA DE INSUMOS"]
[]
["Insumos","Cálculo de Valores Mensais"]
["Descrição","Aquisição [A]","Tempo de Uso (mês)[B]","Custo Mensal ","Reaproveitamento (2)","Valor Mensal "]
["Armas - considerando possibilidade de revenda"]
["Revólver calibre 38 com, no mínimo, seis tiros e cano de quatro polegadas - reaproveitamento para 2 vigilantes por posto (diurno e noturno) (1)",6116.1,60,{"$f":"((B6-(B6*0.3))/C6)*1.0125","v":72.25},2,{"$f":"D6/E6","v":36.130000000000003}]
["Materiais de Consumo - Fardas e Acessórios"]
["Apito de Metal Profissional Com Cordão (Contém 2 Unidades)",9.41,12,{"$f":"B8/C8","v":0.78},2,{"$f":"D8/E8","v":0.39},"(https://www.magazineluiza.com.br/apito-de-metal-profissional-com-cordao-contem-2-unidades-art-sport/p/bg871ck88g/es/apts/?&seller_id=m5armarinhosoficial&utm_source=google&utm_medium=cpc&utm_term=79722&utm_campaign=google_eco_per_ven_pla_es_apo_3p_bkf-es-rpf-su-csp&utm_content=&partner_id=79722&gclsrc=aw.ds&gad_source=4&gad_campaignid=22556056237&gbraid=0AAAAAD4zZmRKe5NuZBikTATuE4P97zTAp&gclid=CjwKCAjw1ozEBhAdEiwAn9qbzYM97Gx779LBMYYTxYWNKgjWtfCt65cErZyV4KmC-6gmXu-JcDGiKRoCsY4QAvD_BwE)"]
["Cinto Operacional com Coldres adequados ao armamento fornecido;",59,12,{"$f":"B9/C9","v":4.92},1,{"$f":"D9/E9","v":4.92},"(https://www.google.com/search?sca_esv=6292aac01ea52d81&sxsrf=AHTn8zrexp4oth-EbPz7MQcLMN76h93Pmw:1744116680846&q=Pre%C3%A7o+de+cinto+para+vigilante&udm=28&fbs=ABzOT_BYhiZpMrUAF0c9tORwPGlsgFXPGtsKf3UCw_95hmysCFKFTbkd4NfKHmCO2FGoL3IGIbx8nCjdW7AcSvN70Hx8_HyOg3guyT0iSvRKzFaZFsRATk-KavIgGOIp4j87AA3KRXuNVHBpxFCwwJcacYj9AYsFF1t9zRrMWUSJ71pU4ES5GJZh3blxT0p6uia6xmLuw5uwvF9kiOr0S0ZP6BIkqXKqRw&ved=1t:220175&ictx=111&biw=1920&bih=919)+(https://www.google.com/search?q=coldre+para+38+vigilante&sca_esv=6292aac01ea52d81&udm=28&biw=1920&bih=919&sxsrf=AHTn8zp-JYaCGOh5wTZr4XgONsZLvhUmEg%3A1744116685462&ei=zRv1Z4_1G6qV5OUPn4GqkQo&oq=Pre%C3%A7o+de+cinto+para+vigilante&gs_lp=Ehlnd3Mtd2l6LW1vZGVsZXNzLXNob3BwaW5nIh5QcmXDp28gZGUgY2ludG8gcGFyYSB2aWdpbGFudGUqAggDMgoQABiwAxjWBBhHMgoQABiwAxjWBBhHMgoQABiwAxjWBBhHMgoQABiwAxjWBBhHMgoQABiwAxjWBBhHMgoQABiwAxjWBBhHMgoQABiwAxjWBBhHMgoQABiwAxjWBBhHSOUuUABYAHACeAGQAQCYAQCgAQCqAQC4AQHIAQCYAgKgAgiYAwCIBgGQBgiSBwEyoAcAsgcAuAcA&sclient=gws-wiz-modeless-shopping)+(https://www.google.com/search?q=porta+balas+para+cinto+de+vigilante&sca_esv=6292aac01ea52d81&udm=28&biw=1920&bih=919&sxsrf=AHTn8zoUJerjB2rmWPS8mQ8EXgX15vdSqQ%3A1744117094181&ei=Zh31Z4zrCt-_5OUPkISFuAo&ved=0ahUKEwiMtuG-vsiMAxXfH7kGHRBCAacQ4dUDCBA&uact=5&oq=porta+balas+para+cinto+de+vigilante&gs_lp=Ehlnd3Mtd2l6LW1vZGVsZXNzLXNob3BwaW5nIiNwb3J0YSBiYWxhcyBwYXJhIGNpbnRvIGRlIHZpZ2lsYW50ZUjgygFQ_jxYm8EBcAV4AZABAJgBxgWgAbsoqgEKMC4xLjIwLjYtMbgBA8gBAPgBAZgCB6ACwQPCAgoQABiwAxjWBBhHwgIEECEYCpgDAIgGAZAGCJIHBTUuMC4yoAfkGLIHAzItMrgHsAM&sclient=gws-wiz-modeless-shopping)+(https://www.google.com/search?q=porta+lanterna+para+cinto+de+vigilante&sca_esv=6292aac01ea52d81&udm=28&biw=1920&bih=919&sxsrf=AHTn8zq0FMN2B-qC58T52tDEAaqbQtcyEw%3A1744117288269&ei=KB71Z8eYEInd5OUPp_-DiQw&ved=0ahUKEwjHzKebv8iMAxWJLrkGHaf_IMEQ4dUDCBA&uact=5&oq=porta+lanterna+para+cinto+de+vigilante&gs_lp=Ehlnd3Mtd2l6LW1vZGVsZXNzLXNob3BwaW5nIiZwb3J0YSBsYW50ZXJuYSBwYXJhIGNpbnRvIGRlIHZpZ2lsYW50ZUjMMVD5FFjbKnACeAGQAQCYAZUCoAGrEKoBAzItObgBA8gBAPgBAZgCA6ACoALCAgoQABiwAxjWBBhHwgIEECEYCpgDAIgGAZAGCJIHBTIuMC4xoAflD7IHAzItMbgHmgI&sclient=gws-wiz-modeless-shopping)"]
["Munições de calibre 38 (12 unidades);",{"$f":"(947.05/100)*12","v":113.65},36,{"$f":"B10/C10","v":3.16},1,3.16,"(https://www.cbcstore.com.br/store/pt/municoes/c/cat_municoes?q=%3Aprice-asc%3Acategory%3ACAT_MUNICOES_ARMAS_CURTAS%3Avendor%3Acbc%2523CB20%3Aclass_cb_ficha_produto_caliber%3A.38%2BSPL&text=#)"]
["Lanterna portátil com 02 (duas) pilhas ou recarregável;",8,12,0.67,1,0.67,"(https://www.google.com/search?q=laterna+com+duas+pilhas+ou+recarreg%C3%A1vel&sca_esv=6292aac01ea52d81&udm=28&biw=1920&bih=919&sxsrf=AHTn8zr1MsXcBYtooNAMtBAzscDbuooHcQ%3A1744117968237&ei=0CD1Z-mdDqDO1sQP8LPjuQw&ved=0ahUKEwjpxcXfwciMAxUgp5UCHfDZOMcQ4dUDCBA&uact=5&oq=laterna+com+duas+pilhas+ou+recarreg%C3%A1vel&gs_lp=Ehlnd3Mtd2l6LW1vZGVsZXNzLXNob3BwaW5nIihsYXRlcm5hIGNvbSBkdWFzIHBpbGhhcyBvdSByZWNhcnJlZ8OhdmVsSOK1tAFQw5yzAViNsbQBcAF4AZABAJgBpgSgAd1DqgEMMC43LjMwLjEuMC4xuAEDyAEA-AEBmAIZoALHK8ICChAAGLADGNYEGEfCAgoQABiABBhDGIoFwgIFEAAYgATCAgcQABiABBgKwgIHEAAYgAQYDcICCRAAGNYFGA0YHsICChAAGIAEGNYFGA3CAgYQABgWGB7CAgsQABjWBRgIGA0YHpgDAIgGAZAGCJIHCjEuNC4xOC4xLjGgB-OKAbIHCjAuNC4xOC4xLjG4B8Mr&sclient=gws-wiz-modeless-shopping)"]
["Colete Balístico Nível II - reaproveitamento para 2 vigilantes por posto (diurno e noturno) - Tamanho M",2479,60,{"$f":"B12/C12","v":41.32},2,{"$f":"D12/E12","v":20.66},"(http://loja.irontex.com.br/produtos/colete-extra-fit-nivel-iia-cor-preta-d4bc/)"]
["Total",{"$f":"SUM(B8:B12)+B6","v":8785.16},null,{"$f":"SUM(D8:D12)+D6","v":123.1},1,{"$f":"SUM(F8:F12)+F6","v":65.930000000000007}]
["1. Fórmula Custo Mensal: (([A]-([A]*30%))/[B])*(1+1,25%), onde 30% é o custo residual do equipamento; e 1,25% a taxa Selic (15% a.a.) mensalisada para cálculo de juros sobre o capital empregado."]
["2. Reaproveitamento: nº de compartilhamentos de equipamentos entre os vigilantes do posto de segurança."]
[]
["3. FARDAMENTO"]
["FARDA (2 conjuntos)",{"$f":"120.59*2","v":241.18},{"$nulls":4},"(https://www.google.com/search?q=uniforme+vigilante+completo&sca_esv=89bf5c8dfd0dab45&udm=28&biw=1920&bih=919&sxsrf=AHTn8zpEFpSL2T8erCTCHniR18HsK8HFlQ%3A1744123075969&ei=wzT1Z871Ou3C5OUPobSamQE&oq=pre%C3%A7o+de+uniformes+para+vigilantes+de+seguran%C3%A7a&gs_lp=Ehlnd3Mtd2l6LW1vZGVsZXNzLXNob3BwaW5nIjFwcmXDp28gZGUgdW5pZm9ybWVzIHBhcmEgdmlnaWxhbnRlcyBkZSBzZWd1cmFuw6dhKgIIADIKEAAYsAMY1gQYRzIKEAAYsAMY1gQYRzIKEAAYsAMY1gQYRzIKEAAYsAMY1gQYRzIKEAAYsAMY1gQYRzIKEAAYsAMY1gQYRzIKEAAYsAMY1gQYRzIKEAAYsAMY1gQYR0iZEFAAWABwAXgBkAEAmAEAoAEAqgEAuAEByAEAmAIBoAIDmAMAiAYBkAYIkgcBMaAHALIHALgHAA&sclient=gws-wiz-modeless-shopping)"]
["BONÉ (2 unidades)",{"$f":"2*29.7","v":59.4},{"$nulls":4},"(https://www.google.com/search?q=bon%C3%A9+vigilante+&sca_esv=89bf5c8dfd0dab45&udm=28&biw=1920&bih=919&sxsrf=AHTn8zo0XWO1W2OT5YqUqxNrYKlEzCWu6g%3A1744123167089&ei=HzX1Z4iaBbOw5OUPo4nhoQw&ved=0ahUKEwjIpcaO1ciMAxUzGLkGHaNEOMQQ4dUDCBA&uact=5&oq=bon%C3%A9+vigilante+&gs_lp=Ehlnd3Mtd2l6LW1vZGVsZXNzLXNob3BwaW5nIhBib27DqSB2aWdpbGFudGUgMgYQABgWGB5IjzdQzA1Y_DNwAngBkAEAmAHlAqAB9Q6qAQUyLTcuMbgBA8gBAPgBAZgCBKAC0QPCAgoQABiwAxjWBBhHwgILEAAY1gUYCBgNGB6YAwCIBgGQBgiSBwUyLjAuMqAHoBGyBwMyLTK4B8wD&sclient=gws-wiz-modeless-shopping)"]
["BOTAS/COTURNO (1 par)",{"$f":"1*64.9","v":64.900000000000006},{"$nulls":4},"(https://www.google.com/search?q=coturno+masculino&sca_esv=89bf5c8dfd0dab45&udm=28&biw=1920&bih=919&sxsrf=AHTn8zrEavyZNZ5fNN1S4DhM9pDO_oIg9A%3A1744123853914&ei=zTf1Z5bLN9LK5OUPydmj2Ao&oq=cuturn&gs_lp=Ehlnd3Mtd2l6LW1vZGVsZXNzLXNob3BwaW5nIgZjdXR1cm4qAggBMgcQABiABBgKMgcQABiABBgKMgcQABiABBgKMgcQABiABBgKMgcQABiABBgKMgcQABiABBgKMgcQABiABBgKMgcQABiABBgKMgcQABiABBgKMgcQABiABBgKSKg5UI0UWLofcAN4AJABAJgB2wKgAYgLqgEFMi01LjG4AQHIAQD4AQGYAgmgArYLwgIJEAAYsAMYCBgewgIKEAAYgAQYQxiKBcICBRAAGIAEmAMAiAYBkAYBkgcHMy4wLjUuMaAHqyKyBwUyLTUuMbgHsQs&sclient=gws-wiz-modeless-shopping)"]
["MEIAS (2 pares)",{"$f":"9.99*2","v":19.98},{"$nulls":4},"(https://www.google.com.br/search?q=MEIA+SOCIAL+PRETA+PAR&sca_esv=cb97f40da6f73026&udm=28&sxsrf=AE3TifMaajiS7eHzOVv1KopTD0x0xjCsdA%3A1761753518083&ei=rjkCaeTqBKuj1sQP_ofdoQY&ved=0ahUKEwjk-YGl48mQAxWrkZUCHf5DN2QQ4dUDCBE&uact=5&oq=MEIA+SOCIAL+PRETA+PAR&gs_lp=Ehlnd3Mtd2l6LW1vZGVsZXNzLXNob3BwaW5nIhVNRUlBIFNPQ0lBTCBQUkVUQSBQQVJI-gtQlARYyAdwAXgBkAEAmAHsAaABggeqAQMyLTS4AQPIAQD4AQGYAgKgAukBwgIKEAAYsAMY1gQYR8ICBRAAGIAEwgIGEAAYFhgemAMAiAYBkAYIkgcFMS4wLjGgB9QEsgcDMi0xuAfhAcIHAzItMsgHDQ&sclient=gws-wiz-modeless-shopping)"]
["Total",{"$f":"SUM(B18:B21)","v":385.46}]
["Valor mensal por empregado com previsão de uso por 12 meses",{"$f":"B22/12","v":32.119999999999997}]
[]
["Consumo: prazo previsto (cáusula 57ª CCT 2025/2025)","1 ano"]
["Armas e coletes: tempo de uso de 60 meses"]
["Munições: tempo de uso de 36 meses"]
{"$rows_empty":36}
["Convenção Coletiva:                                                                                                                                                                                                                            NÚMERO DE REGISTRO NO MTE: \t\tPE000069/2021 \nDATA DE REGISTRO NO MTE: 27/01/2021\nNÚMERO DA SOLICITAÇÃO: \t\tMR002705/2021\nNÚMERO DO PROCESSO: \t\t\t13623.100202/2021-16\nDATA DO PROTOCOLO: 25/01/2021"]
{"$rows_empty":14}
["Paulista, 18 de agosto de 2021"]