Accurate prediction and forecasting of industrial products’ consumption, enables up-to-date and efficient supply, replacement of worn-out items, and prevention of resource wastage. Planning and forecasting the usage of industrial products can help often based on historical years’ performance and environmental factors, using either traditional methods or smart systems. However, the instability of some sales behavior in certain products and the lack of previous data for new products or sales offices can create problems in intelligent systems. In this paper, we present a hybrid and bi-objective model in the form of a business intelligence system that first fits an appropriate function to the products, providing a new estimated combination for the type and sales amount of all products, while taking into account the profit margin. This new intelligent system allows for flexible planning for the company, generating a special scenario for each new input strategy. Furthermore, using machine learning and based on similarity measurements and the company’s previous data, we predict the sales behavior for new products and sales offices in their first year of operation. Finally, the model announces the sales trend of each product in different time periods, separately for each sales office, taking into account the previous two stages. The current investigation outlines the integration of the proposed model into the business intelligence system of Mirab Valves Company, a reputable manufacturer of industrial valves, and its subsequent effective application as an exemplar. The model’s efficacy in forecasting sales of new products and sales offices is established at 79% and 92%, respectively.