Como Calcular o Rateio de Energia na Planilha (Média Ponderada) - Precificação Industrial - Aula 49

Watch Lesson 49 of the Industrial Pricing Training (Module 6: Machine Hour) and see in practice how to use our spreadsheet to calculate the exact energy cost of each piece of equipment. If your industry buys energy on the free market, but also uses the local utility (for peak hours or contingency), a major problem arises: which tariff do you include in the cost of your product? Choosing the cheapest destroys your margin; choosing the most expensive leaves your price out of the market. In this lesson, we solve this by applying the "Weighted Average Cost" calculation. We show on screen how to cross-reference the weight of each energy supplier to find the real tariff for your factory and then apply the Load Factor and the equipment's Power to find the cost per hour of operation. What you will learn in this video: The step-by-step process for filling out the electricity allocation spreadsheet. How to calculate the Weighted Average of kWh when the factory has multiple energy contracts (e.g., combining the cost from the Free Market with the local utility to arrive at a single rate of R$ 1.21). How to apply the "Load Factor" (e.g., 70%) to correct the machine's nominal power and reflect the actual production consumption. The final result: how the R$ 1.21 per kWh translates into the exact cost of your Machine Hour (e.g., R$ 8.44/hour). 🔗 IMPORTANT LINKS: 🎁 CLASS NOTICES AND EXTRA MATERIALS: Want to download this energy calculation spreadsheet and be notified of upcoming practical classes? Sign up for our free VIP group: https://realcusto.com/treinamento-com... 👉 Want to test our software in practice and ensure that your factory's energy cost is included in every product sold? Click the link below and take the test: https://realcusto.com/teste-sistema Subscribe to the channel to follow the training and leave your questions in the comments!