{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["PE","PE (2)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"PE","index":0,"n_rows":23,"n_cols":23,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,8,22,11],[12,8,13,8],[12,9,12,10],[17,9,17,10],[10,8,10,11],[16,9,16,10],[14,8,14,11],[20,8,21,8],[20,9,20,10],[21,9,21,10],[16,8,17,8],[18,8,18,11],[5,9,5,10],[4,8,5,8],[8,8,9,8],[8,9,8,10],[9,9,9,10],[7,2,7,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[3,7,6,7],[3,6,22,6],[4,2,5,3],[8,2,9,3],[16,2,17,3],[20,2,21,3],[7,7,14,7],[15,7,22,7],[1,1,1,4],[22,13,22,19],[19,2,19,3],[15,2,15,3],[21,14,21,18],[18,13,18,19],[4,14,4,16],[5,14,5,16],[8,14,8,16],[10,13,10,19],[16,13,17,13],[20,13,21,13],[13,14,13,16],[14,13,14,19],[4,13,5,13],[8,13,9,13],[16,22,17,22],[20,22,21,22],[1,7,1,11],[1,13,1,19],[1,21,1,22],[4,22,5,22],[8,22,9,22],[12,22,13,22],[4,21,5,21],[8,21,9,21],[12,21,13,21],[16,21,17,21],[20,21,21,21],[12,13,13,13],[13,9,13,10],[4,9,4,10]]}
[]
[null,"PARÂMETROS",null,null,null,null,null,"FÓRMULA PARA CÁLCULO",null,null,null,null,null,"DEMONSTRAÇÃO DO CÁLCULO",null,null,null,null,null,null,null,"META MENSAL DE VENDAS"]
[]
[null,null,null,null,null,null,"PONTO DE EQUILÍBRIO","OPERACIONAL"]
[null,null,"PARÂMETROS PARA CÁLCULOS",null,null,null,null,null,"PEO =","$ CF",null,null,null,"PEO =",{"$f":"C17","v":10000},null,null,null,null,null,null,"PEO =",{"$f":"O5/O6","v":100000}]
[null,null,null,null,null,null,null,null,null,"% MC",null,null,null,null,{"$f":"C9","v":0.1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lucro =",{"$f":"W5*Q6","v":0}]
[null,null,"MARGEM DE CONTRIBUIÇÃO",null,null,null,null,"ECONÔMICO"]
[null,null,0.1,null,null,null,null,null,"PEE =","$ CF",null,null,null,"PEE =",{"$f":"C17","v":10000},null,null,null,null,null,null,"PEE =",{"$f":"O9/(O10-Q10)","v":200000}]
[null,null,null,null,null,null,null,null,null,"% MC  -  % L",null,null,null,null,{"$f":"C9","v":0.1},"-",{"$f":"C13","v":0.05},null,null,null,null,null,{"$f":"K9","v":0}]
[null,null,null,null,null,null,null,null,"Cálculo estabelecido em % lucro",null,null,null,null,null,null,null,null,null,null,null,null,"Lucro =",{"$f":"W9*Q10","v":10000}]
[null,null,"LUCRO DESEJADO"]
[null,null,0.05,null,null,null,null,null,"PEE =","$ CF  +  $ L",null,null,null,"PEE =",{"$f":"C17","v":10000},"+",{"$f":"C14","v":8000},null,null,null,null,"PEE =",{"$f":"(O13+Q13)/O14","v":180000}]
[null,null,8000,null,null,null,null,null,null,"% MC",null,null,null,null,{"$f":"C9","v":0.1}]
[null,null,null,null,null,null,null,null,"Cálculo estabelecido em $ lucro",null,null,null,null,null,null,null,null,null,null,null,null,"Lucro =",8000]
[null,null,"CUSTOS FIXOS",null,null,null,null,"FINANCEIRO"]
[null,null,10000,null,null,null,null,null,"PEF =","$ CF  +  $ DF",null,null,null,"PEF =",{"$f":"C17","v":10000},"+",{"$f":"C21","v":2500},null,null,null,null,"PEF =",{"$f":"(O17+Q17)/(O18-Q18)","v":250000}]
[null,null,null,null,null,null,null,null,null,"% MC  -  % L",null,null,null,null,{"$f":"C9","v":0.1},"-",{"$f":"C13","v":0.05}]
[null,null,null,null,null,null,null,null,"Cálculo estabelecido em % lucro",null,null,null,null,null,null,null,null,null,null,null,null,"Lucro =",{"$f":"W17*Q18","v":12500}]
[null,null,"DESPESAS FINANCEIRAS"]
[null,null,2500,null,null,null,null,null,"PEF =","$ CF  +  $ DF  +  $ L",null,null,null,"PEF =",{"$f":"C17","v":10000},"+",{"$f":"C21","v":2500},"+",{"$f":"C14","v":8000},null,null,"PEF =",{"$f":"(O21+Q21+S21)/O22","v":205000}]
[null,null,null,null,null,null,null,null,null,"% MC",null,null,null,null,{"$f":"C9","v":0.1}]
[null,null,null,null,null,null,null,null,"Cálculo estabelecido em $ lucro",null,null,null,null,null,null,null,null,null,null,null,null,"Lucro =",8000]

{"sheet":"PE (2)","index":1,"n_rows":23,"n_cols":26,"rows_kept":23,"cut":false,"hidden":false,"merged":[[20,22,21,22],[21,25,21,26],[4,25,4,26],[8,25,8,26],[12,25,12,26],[16,25,16,26],[20,25,20,26],[5,25,5,26],[1,24,1,26],[9,25,9,26],[13,25,13,26],[16,22,17,22],[17,25,17,26],[1,21,1,22],[4,22,5,22],[8,22,9,22],[12,22,13,22],[4,21,5,21],[8,21,9,21],[12,21,13,21],[1,1,1,4],[22,13,22,19],[19,2,19,3],[15,2,15,3],[21,14,21,18],[18,13,18,19],[4,14,4,16],[5,14,5,16],[8,14,8,16],[10,13,10,19],[1,7,1,11],[1,13,1,19],[4,13,5,13],[16,21,17,21],[16,13,17,13],[20,13,21,13],[13,14,13,16],[14,13,14,19],[20,21,21,21],[8,13,9,13],[12,13,13,13],[7,2,7,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[8,9,8,10],[9,9,9,10],[8,2,9,3],[4,2,5,3],[4,9,4,10],[5,9,5,10],[4,8,5,8],[8,8,9,8],[3,7,6,7],[3,6,22,6],[13,9,13,10],[10,8,10,11],[16,9,16,10],[14,8,14,11],[20,8,21,8],[20,9,20,10],[21,9,21,10],[16,2,17,3],[20,2,21,3],[16,8,17,8],[7,7,14,7],[15,7,22,7],[18,8,18,11],[22,8,22,11],[12,8,13,8],[12,9,12,10],[17,9,17,10]]}
[]
[null,"PARÂMETROS",null,null,null,null,null,"FÓRMULA PARA CÁLCULO",null,null,null,null,null,"DEMONSTRAÇÃO DO CÁLCULO",null,null,null,null,null,null,null,"META MENSAL DE VENDAS",null,null,"METAS DIÁRIAS DE VENDAS"]
[]
[null,null,null,null,null,null,"PONTO DE EQUILÍBRIO","OPERACIONAL"]
[null,null,"PARÂMETROS PARA CÁLCULOS",null,null,null,null,null,"PEO =","$ CF",null,null,null,"PEO =",{"$f":"C17","v":0},null,null,null,null,null,null,"PEO =",{"$f":"O5/O6","v":{"$error":"#DIV/0!"}},null,"N° dias","Venda diária"]
[null,null,null,null,null,null,null,null,null,"% MC",null,null,null,null,{"$f":"C9","v":0},null,null,null,null,null,null,null,null,null,30,{"$f":"W5/Y6","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lucro =",{"$f":"W5*Q6","v":{"$error":"#DIV/0!"}}]
[null,null,"MARGEM DE CONTRIBUIÇÃO",null,null,null,null,"ECONÔMICO"]
[null,null,0,null,null,null,null,null,"PEE =","$ CF",null,null,null,"PEE =",{"$f":"C17","v":0},null,null,null,null,null,null,"PEE =",{"$f":"O9/(O10-Q10)","v":{"$error":"#DIV/0!"}},null,"N° dias","Venda diária"]
[null,null,null,null,null,null,null,null,null,"% MC  -  % L",null,null,null,null,{"$f":"C9","v":0},"-",{"$f":"C13","v":0},null,null,null,null,null,{"$f":"K9","v":0},null,{"$f":"$Y$6","v":30},{"$f":"W9/Y10","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"Cálculo estabelecido em % lucro",null,null,null,null,null,null,null,null,null,null,null,null,"Lucro =",{"$f":"W9*Q10","v":{"$error":"#DIV/0!"}}]
[null,null,"LUCRO DESEJADO"]
[null,null,0,null,null,null,null,null,"PEE =","$ CF  +  $ L",null,null,null,"PEE =",{"$f":"C17","v":0},"+",{"$f":"C14","v":0},null,null,null,null,"PEE =",{"$f":"(O13+Q13)/O14","v":{"$error":"#DIV/0!"}},null,"N° dias","Venda diária"]
[null,null,0,null,null,null,null,null,null,"% MC",null,null,null,null,{"$f":"C9","v":0},null,null,null,null,null,null,null,null,null,{"$f":"$Y$6","v":30},{"$f":"W13/Y14","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"Cálculo estabelecido em $ lucro",null,null,null,null,null,null,null,null,null,null,null,null,"Lucro =",{"$f":"C14","v":0}]
[null,null,"CUSTOS FIXOS",null,null,null,null,"FINANCEIRO"]
[null,null,0,null,null,null,null,null,"PEF =","$ CF  +  $ DF",null,null,null,"PEF =",{"$f":"C17","v":0},"+",{"$f":"C21","v":0},null,null,null,null,"PEF =",{"$f":"(O17+Q17)/(O18-Q18)","v":{"$error":"#DIV/0!"}},null,"N° dias","Venda diária"]
[null,null,null,null,null,null,null,null,null,"% MC  -  % L",null,null,null,null,{"$f":"C9","v":0},"-",{"$f":"C13","v":0},null,null,null,null,null,null,null,{"$f":"$Y$6","v":30},{"$f":"W17/Y18","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"Cálculo estabelecido em % lucro",null,null,null,null,null,null,null,null,null,null,null,null,"Lucro =",{"$f":"W17*Q18","v":{"$error":"#DIV/0!"}}]
[null,null,"DESPESAS FINANCEIRAS"]
[null,null,null,null,null,null,null,null,"PEF =","$ CF  +  $ DF  +  $ L",null,null,null,"PEF =",{"$f":"C17","v":0},"+",{"$f":"C21","v":0},"+",{"$f":"C14","v":0},null,null,"PEF =",{"$f":"(O21+Q21+S21)/O22","v":{"$error":"#DIV/0!"}},null,"N° dias","Venda diária"]
[null,null,null,null,null,null,null,null,null,"% MC",null,null,null,null,{"$f":"C9","v":0},null,null,null,null,null,null,null,null,null,{"$f":"$Y$6","v":30},{"$f":"W21/Y22","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"Cálculo estabelecido em $ lucro",null,null,null,null,null,null,null,null,null,null,null,null,"Lucro =",{"$f":"C14","v":0}]