Development of a demand forecast system in VBA: case study of a producer of pork derivatives

Due to the globalization in which companies are inserted today, competition is inevitable and a constant threat. In addition, customers are increasingly demanding and resources increasingly scarce. In this context, a competitive advantage is established when meeting the requirements of the clients: speed, punctuality and flexibility. Companies are increasingly attentive to customer needs and have begun investing in production management techniques to ensure the reliability of their products and services. The application of demand forecasting models has the possibility of maintaining a lean stock structure of raw materials of the organization, as well as the possibility to identify a better way to avoid wastes and deviations of the processes through some analytical models of the Operational Research. As most of the company's employees at the operational level do not have the necessary skills to handle these mathematical models, this paper aims to propose the development and implementation of a production management system through the Microsoft Visual Basic® (VBA) interface, in A company of products derived from pigs, with the purpose of reducing waste and assisting in decision making, reducing the levels of stock of raw material.