Automatización de los costos de producción en gallinas ponedoras comerciales en la Granja Avícola San Alfonso.

Abstract

Automation of production costs in commercial poultry production is essential to improve operational efficiency and financial management in a competitive environment. Lack of automated systems results in inaccurate data collection and inadequate budget planning, which negatively affects profitability and competitiveness. The objective of this research was to automate production costs in commercial laying hens at San Alfonso Granja. The methodology included the collection of financial data, the creation and organization of Excel spreadsheets, the implementation of automatic formulas and the systematization of data coding through macros. Graphs and pivot tables are also generated for better visualization of costs and trends. Before implementation, all functions are thoroughly validated and tested to ensure accuracy. The economic analysis of the farm shows fixed costs of $29,431.80, variable costs of $178,983.78, and a total cost of $208,415.58. The unit cost of production is $709.77, with a unit profitability of $21,717.85 and a total profitability of $99,348.97, the Profit/Cost ratio is $115.52. In this context, it is concluded that automation positions the farm as a profitable production model in the poultry sector, ensuring continuous management based on decision-making based on the results obtained. It is recommended that the application be fed with information on a continuous basis, thus ensuring the management when making decisions based on the results obtained.