{"product_id":"planilha-de-calculo-para-formacao-do-frete-peso-fracionado","title":"Planilha de Cálculo para Formação do Frete Peso Fracionado em Excel","description":"\u003cp\u003e\u003ca class=\"btn product-add free-test\"\u003eTestar grátis\u003c\/a\u003e\u003c\/p\u003e\u003cp\u003e\u003cspan style=\"font-size: 12pt;\"\u003ePreocupados em disponibilizar uma ferramenta que possibilite as empresas de transportes Rodoviário de cargas uma apuração dos custos tecnicamente corretos trazendo subsídios para enfrentar os desafios impostos pelo mercado, a VIZUAL PLANILHAS EMPRESARIAIS, coloca à disposição e venda a mais nova Planilha de custos para formação do Frete Peso. Destacamos a introdução do Cálculo do Custo Fixo e Variável, bem como o cálculo das despesas indiretas para a correta formação do frete peso.\u003c\/span\u003e\u003c\/p\u003e\u003ch3 class=\"spr-header-title\"\u003e\u003cspan style=\"color: #3366ff;\"\u003e\u003cspan style=\"color: #6699ff;\"\u003e\u003cspan style=\"color: #5b9bd5;\"\u003eCustos fixos e variáveis\u003c\/span\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/h3\u003e\u003cp\u003e\u003cspan style=\"font-size: 12pt;\"\u003eA planilha vem com uma tabela detalhando a descrição dos custos fixos e variáveis, essa é uma parte bem cautelosa – as respostas precisam ser precisas para que o cálculo saia o mais correto e preciso possível. Tudo é feito automaticamente, será necessário informar apenas os valores nos campos correspondentes.\u003c\/span\u003e\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003cspan style=\"font-size: 12pt;\"\u003eQuanto custa os veículos automotores de cargas novo?\u003c\/span\u003e\u003cbr\u003e\u003cbr\u003e\u003cspan style=\"font-size: 12pt;\"\u003e Qual o preço de revenda do veículo automotor de cargas?\u003c\/span\u003e\u003cbr\u003e\u003cbr\u003e\u003cspan style=\"font-size: 12pt;\"\u003e Quantos anos possui o veículo, considerando a data atual e o ano de fabricação\u003c\/span\u003e\u003cbr\u003e\u003cbr\u003e\u003cspan style=\"font-size: 12pt;\"\u003e Quanto custo o implemento novo?\u003c\/span\u003e\u003cbr\u003e\u003cbr\u003e\u003cspan style=\"font-size: 12pt;\"\u003e Qual é o preço de revenda do implemento?\u003c\/span\u003e\u003cbr\u003e\u003cbr\u003e\u003cspan style=\"font-size: 12pt;\"\u003e Quantos anos possui o implemento, considerando a data atual e o ano de fabricação?\u003c\/span\u003e\u003cbr\u003e\u003cbr\u003e\u003cspan style=\"font-size: 12pt;\"\u003e Qual foi o rendimento da poupança no último mês?\u003c\/span\u003e\u003cbr\u003e\u003cbr\u003e\u003cspan style=\"font-size: 12pt;\"\u003e Qual é o percentual de encargos sociais pagos sobre o salário do motorista?\u003c\/span\u003e\u003cbr\u003e\u003cbr\u003e\u003cspan style=\"font-size: 12pt;\"\u003e Qual é o valor do salário pago ao motorista?\u003c\/span\u003e\u003cbr\u003e\u003cbr\u003e\u003cspan style=\"font-size: 12pt;\"\u003e Quantos motoristas são empregados por veículo?\u003c\/span\u003e\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003cspan style=\"font-size: 12pt;\"\u003eDentre outras perguntas...\u003c\/span\u003e\u003c\/p\u003e\u003cp\u003e\u003ca class=\"btn product-add free-test\"\u003eTestar grátis\u003c\/a\u003e\u003c\/p\u003e\u003ch3 class=\"spr-header-title\"\u003e\u003cspan style=\"color: #3366ff;\"\u003e\u003cspan style=\"color: #6699ff;\"\u003e\u003cspan style=\"color: #5b9bd5;\"\u003eDespesas indiretas\u003c\/span\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/h3\u003e\u003cp\u003e\u003cspan style=\"font-size: 12pt;\"\u003eA Planilha também vem com uma tabela detalhando a descrição das despesas indiretas – também conhecidas como despesas administrativas e de terminais (DAT); essas são aquelas despesas que não estão relacionadas diretamente com a operação do veículo. Não variam, portanto, com a quilometragem rodada, mas sim com a tonelagem movimentada.\u003c\/span\u003e\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003cspan style=\"font-size: 12pt;\"\u003eIsso é tudo é calculado e feito de forma automática, bastando apenas inserir os valores, alguns campos a serem respondidos são:\u003c\/span\u003e\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003cspan style=\"font-size: 12pt;\"\u003eSalários, ordenados e honorários de diretoria\u003c\/span\u003e\u003cbr\u003e\u003cbr\u003e\u003cspan style=\"font-size: 12pt;\"\u003e Aluguéis\u003c\/span\u003e\u003cbr\u003e\u003cbr\u003e\u003cspan style=\"font-size: 12pt;\"\u003e Tarifas de serviços públicos\u003c\/span\u003e\u003cbr\u003e\u003cbr\u003e\u003cspan style=\"font-size: 12pt;\"\u003e Serviços profissionais\u003c\/span\u003e\u003cbr\u003e\u003cbr\u003e\u003cspan style=\"font-size: 12pt;\"\u003e Impostos e taxas\u003c\/span\u003e\u003cbr\u003e\u003cbr\u003e\u003cspan style=\"font-size: 12pt;\"\u003e Depreciações\u003c\/span\u003e\u003cbr\u003e\u003cbr\u003e\u003cspan style=\"font-size: 12pt;\"\u003e Outros custos\u003c\/span\u003e\u003c\/p\u003e\u003ch3 class=\"spr-header-title\"\u003e\u003cspan style=\"color: #3366ff;\"\u003e\u003cspan style=\"color: #6699ff;\"\u003e\u003cspan style=\"color: #5b9bd5;\"\u003eTabela de frete peso por KM Rodado\u003c\/span\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/h3\u003e\u003cp\u003e\u003cspan style=\"font-size: 12pt;\"\u003eAutomaticamente a planilha é formada ao inserir as faixas por KM Rodado e o peso fracionado, assista aos vídeos para um melhor entendimento.\u003c\/span\u003e\u003c\/p\u003e\u003ch3 class=\"spr-header-title\"\u003e\u003cspan style=\"color: #3366ff;\"\u003e\u003cspan style=\"color: #6699ff;\"\u003e\u003cspan style=\"color: #5b9bd5;\"\u003eTabela de frete peso por cidades\u003c\/span\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/h3\u003e\u003cp\u003e\u003cspan style=\"font-size: 12pt;\"\u003eDa mesma forma que no KM Rodado a planilha é formada automaticamente ao inserir as cidades origem e cidades destinos, também assista aos vídeos para um melhor entendimento.\u003c\/span\u003e\u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cp\u003e\u003cspan style=\"font-size: 12pt;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003e\u003cspan style=\"text-decoration: underline;\"\u003e\u003cspan style=\"color: #000000; text-decoration: underline;\"\u003eDeseja falar conosco ao vivo? é só clicar\u003c\/span\u003e\u003c\/span\u003e \u003cstrong\u003e\u003cspan style=\"color: #ff0000;\"\u003e\u003ca style=\"color: #ff0000;\" href=\"https:\/\/tawk.to\/chat\/594bc23ce9c6d324a4736cb9\/default\" target=\"_blank\" rel=\"noopener noreferrer\"\u003eaqui!\u003c\/a\u003e\u003c\/span\u003e\u003c\/strong\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/p\u003e\u003cp\u003e\u003cspan style=\"font-size: 12pt;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003e\u003cstrong\u003e\u003cspan style=\"color: #ff0000;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003e\u003cstrong\u003e\u003cspan style=\"color: #ff0000;\"\u003e\u003cspan style=\"font-size: 18px;\"\u003e\u003cstrong\u003e\u003cspan style=\"color: #b22222;\"\u003e→ Para um melhor funcionamento da planilha recomendamos utilizar Office 2013 em diante\u003c\/span\u003e\u003c\/strong\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/strong\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/strong\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cp\u003e\u003cspan style=\"font-size: 18px;\"\u003e\u003cstrong\u003e\u003cspan style=\"color: #b22222;\"\u003e\u003cspan style=\"font-size: 18px;\"\u003e\u003cstrong\u003e\u003cspan style=\"color: #b22222;\"\u003e\u003cspan style=\"font-size: 18px;\"\u003e\u003cstrong\u003e\u003cspan style=\"color: #b22222;\"\u003e→ \u003cspan style=\"color: #000080;\"\u003eAssista ao vídeo de atualização da planilha para entender suas mudanças na versão 5.0\u003c\/span\u003e\u003cbr\u003e\u003c\/span\u003e\u003c\/strong\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/strong\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/strong\u003e\u003c\/span\u003e\u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cp\u003e\u003cspan style=\"font-size: 12pt;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003e\u003cstrong\u003e\u003cspan style=\"color: #ff0000;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003e\u003cspan style=\"font-size: 12pt;\"\u003e\u003cstrong\u003e\u003cspan style=\"color: #ff0000;\"\u003e\u003cspan style=\"font-size: 18px;\"\u003e\u003cstrong\u003e\u003cspan style=\"color: #b22222;\"\u003e\u003cspan style=\"font-size: 18px;\"\u003e\u003cstrong\u003e\u003cspan style=\"color: #b22222;\"\u003e\u003cspan style=\"font-size: 18px;\"\u003e\u003cstrong\u003e\u003cspan style=\"color: #b22222;\"\u003e\u003ciframe src=\"\/\/www.youtube.com\/embed\/mImQNwHr7Fo\" width=\"642\" height=\"360\" allowfullscreen=\"allowfullscreen\"\u003e\u003c\/iframe\u003e\u003c\/span\u003e\u003c\/strong\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/strong\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/strong\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/strong\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/strong\u003e\u003c\/span\u003e\u003c\/span\u003e\u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cp\u003e\u003ciframe src=\"\/\/www.youtube.com\/embed\/2C9SimsGrqk\" width=\"640\" height=\"360\" allowfullscreen=\"allowfullscreen\"\u003e\u003c\/iframe\u003e\u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cp\u003e\u003ciframe src=\"\/\/www.youtube.com\/embed\/q8HALI-zI9k\" width=\"640\" height=\"360\" allowfullscreen=\"allowfullscreen\"\u003e\u003c\/iframe\u003e\u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cp\u003e\u003ciframe src=\"\/\/www.youtube.com\/embed\/N5Yjv3_4igE\" width=\"640\" height=\"360\" allowfullscreen=\"allowfullscreen\"\u003e\u003c\/iframe\u003e\u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cp\u003e\u003ciframe src=\"\/\/www.youtube.com\/embed\/VoB3W-ImNNA\" width=\"640\" height=\"360\" allowfullscreen=\"allowfullscreen\"\u003e\u003c\/iframe\u003e\u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cp\u003e\u003ciframe src=\"\/\/www.youtube.com\/embed\/Gwi1VC7Haeg\" width=\"640\" height=\"360\" allowfullscreen=\"allowfullscreen\"\u003e\u003c\/iframe\u003e\u003c\/p\u003e\u003cp\u003eTestar grátis\u003c\/p\u003e","brand":"VIZUAL PLANILHAS","offers":[{"title":"Default Title","offer_id":35647575523490,"sku":"","price":280.0,"currency_code":"PLN","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0458\/0904\/1570\/products\/AydDMSQdIk.jpg?v=1597227249","url":"https:\/\/luzdiuwi-vc.myshopify.com\/products\/planilha-de-calculo-para-formacao-do-frete-peso-fracionado","provider":"luzdiuwi.vc","version":"1.0","type":"link"}