Optimization of Economic Indicators in a Carpentry Company Through Integer Programming

Abstract

This study aimed to analyze the economic feasibility of manufacturing frames in a carpentry company through two scenarios, including the production before and after modeling using operational research. The annual costs and revenues were quantified considering a horizon of 30 years. The economic analysis included the following criteria: Net Present Value (NPV), Equivalent Periodic Value (EPV) and Revenues Cost Ratio (R/C). The modeling was applied after analysis of the standard production using an objective function to maximize the company’s profit based on the quantity of each assortment to be produced. The standard production showed economic feasibility for all evaluated indicators, however implementing the operational research provided an increase of 57.54% for the NPV and EPV indicators, and 11.29% for the R/C ratio. In applying the sensitivity analysis after modeling, it was noticed that the value obtained for the NPV indicator was higher, even with a 10% increase in labor costs or in the price of wood, when compared to the standard production scenario before the modeling and without applying sensitivity analysis.