Article

October 26, 2026

Integrated forecasting and optimization model for field operations in the electric power sector

Rondinele Araujo Carvalho; Patrícia Belfiore Fávero

DOI: 10.22167/2675-6528-202603429

Article derived from a Course Conclusion Work (TCC), with content based on the student’s original work and adapted to the editorial format of the E&S Magazine with the support of the ResumeAI tool, an artificial intelligence solution developed by Instituto Pecege for textual synthesis and organization.

Summary

Field operations management in the electric sector faces daily challenges such as a high volume of service orders, strict regulatory constraints, and variable demand, frequently resulting in unproductivity and deadline violations. To address this issue, an integrated forecasting and optimization model was developed and evaluated for these operations. 321,781 real service orders, collected between December 2024 and April 2026, with an average of 639.7 orders per day, were used, treated in an aggregated and anonymized manner. The methodology combined exploratory data analysis, predictive modeling with SARIMA, and prescriptive prioritization and allocation strategies. The SARIMA model reduced the mean squared error (RMSE) by 48.6% compared to a moving average baseline (177.27 versus 344.66). Prospective scenario simulation demonstrated that the hybrid approach, which prioritized by regulatory deadline and optimized spatially, increased Service Level Agreement (SLA) compliance by 0.83 percentage points over the baseline scenario and reduced estimated average travel by 20%. It was concluded that the model generated simultaneous gains in regulatory compliance and logistical efficiency, replacing reactive decisions with a structured, data-driven process.

Keywords: Resource allocation; Field management; Operations research; SARIMA; Time series.

1. Introduction

Field operations management in the electric power sector represents a complex challenge, characterized by the high daily volume of service orders, the rigidity of regulatory restrictions, and highly variable demand. Utilities rely on a service delivery chain to ensure that disconnections, reconnections, new connections, and emergency services are performed with quality and within the deadlines established for millions of consumers. This dynamic is particularly demanding during the Summer Plan, a period between October and March, when intense rains increase emergency call-outs.

Historically, the decisions for allocation and prioritization of services are made reactively, based on empirical rules or the individual experience of managers. This model, although functional in smaller-scale operations, reveals fragilities in large-scale environments, with geographically dispersed teams and multiple simultaneous restrictions (Gil, 2017). The direct consequence of this approach is low productivity, unnecessary team displacement, and the risk of violating regulatory deadlines, known as Service Level Agreement (SLA), in addition to an increased risk of backlog formation and unproductivity, especially in the critical months of the Summer Plan.

To mitigate these challenges, specialized literature points to the effectiveness of quantitative techniques, such as data analysis, predictive modeling, and operational research, which demonstrate consistent results in improving efficiency and complying with regulatory requirements (Fávero; Belfiore, 2024; Hillier; Lieberman, 2015). The growing maturity of Data Science and Operational Research allows the integration of demand forecasts, geographic information, and operational constraints into more robust decision support systems. Such systems enable the anticipation of critical scenarios, structured prioritization of services, and logical organization of execution sequences, promoting proactive rather than reactive management (Santos et al., 2023). The problem of allocating and sequencing field service orders bears a close analogy to the Vehicle Routing Problems with Time Windows (VRPTW), whose combinatorial nature makes the search for optimal solutions computationally unfeasible in real operational contexts, justifying the use of heuristic approaches and structured prescriptions (Hillier; Lieberman, 2015; Arenales et al., 2007).

In this context, the research proposes an integrated forecasting and optimization model for field operations in the electricity sector. The model combines exploratory data analysis, predictive modeling using Seasonal Autoregressive Integrated Moving Average (SARIMA), and prescriptive prioritization and allocation strategies. 321,781 actual service orders were used, covering the period from December 2024 to April 2026, with an average of 639.7 service orders per day, treated in an aggregated and anonymized manner.

Given the need to improve regulatory compliance and logistical efficiency, the present work aimed to develop and evaluate an integrated forecasting and optimization model for field operations in the electric sector.

2. Material and Methods

The research adopted a quantitative and applied design, according to Creswell’s (2016) guidelines, to investigate field operations management in the electric sector. The study was based on a database that gathered historical records of service orders from real operations. In compliance with confidentiality and ethical standards, the data were treated in an aggregated and anonymized manner, without any identification of institutions, people, or individual values, following the Manual of Instructions and Norms for Course Conclusion Works of USP/Esalq.

The unit of analysis consisted of 321,781 actual service orders, collected over the period from December 2024 to April 2026, with a daily average of 639.7 service orders. For each record, information was available such as the opening and execution date and time of the service order, geographic coordinates (latitude and longitude), service type, execution status, and the regulatory service level agreement (SLA).

Data preprocessing was performed in a Python environment, using the Pandas library for the steps of reading, cleaning, filtering, and transformation. Records with a null `ordem_servico` field were excluded from the analysis. The operational time variables, `duracao` (activity execution time in the field) and `tempo_de_deslocamento` (travel time between consecutive service calls), were processed to allow independent analyses of execution efficiency and logistics.

The exploratory analysis aimed to map operational behavior over the studied period. Patterns of daily volume, the distribution of orders by service type, and seasonal variations were investigated. Aggregating records by date allowed for the calculation of daily service volume and the identification of weekly seasonality, as well as the annual variation associated with the Summer Plan.

For the predictive modeling of the daily volume of service orders, the Seasonal Autoregressive Integrated Moving Average (SARIMA) model was employed, given the presence of weekly seasonality identified in the exploratory analysis (Fávero; Belfiore, 2024). SARIMA combined autoregressive, moving average, and seasonal components, suitable for series with regular cyclical patterns. A seven-day moving average was used as a baseline for performance comparison.

The performance of the SARIMA model was evaluated by the mean absolute percentage error (MAPE) and the root mean squared error (RMSE), after partitioning the data into training (80%) and testing (20%) sets, a procedure recommended for evaluating the generalization capability of predictive models (Hastie et al., 2009). The selection of SARIMA model parameters (p, d, q)(P, D, Q)[s] followed the Akaike Information Criterion (AIC), which penalizes model complexity and minimizes the risk of overfitting.

The stationarity of the series was verified by the Augmented Dickey-Fuller (ADF) test, where a p-value lower than 0.05 confirmed the absence of a unit root, dispensing with additional differencing beyond the order d = 1 already incorporated. The adequacy of the fit was validated by the Ljung-Box test on the residuals, which did not reject the hypothesis of absence of residual autocorrelation, a necessary condition for the validity of the predictions generated by the model.

The operational risk estimate was performed to capture differences in the criticality level of service orders. A risk indicator was calculated based on the historical rate of unproductivity by service type, assigning a higher weight to orders with a higher frequency of non-completion on the first attempt, influencing the prioritization process.

The prescriptive stage focused on structuring an optimization process for the allocation and prioritization of services, seeking three simultaneous objectives: maximizing compliance with regulatory deadlines (SLA), reducing geographic travel of teams, and increasing overall operational efficiency. The strategy combined explicit prioritization rules with a nearest neighbor type spatial sequencing heuristic, where orders with critical deadlines were allocated first, and the others sequenced by geographic proximity, calculated by the Euclidean distance between coordinates.

From the perspective of Operations Research, the prescriptive model was structured with decision variables (the execution sequence by team), an objective function (simultaneous maximization of SLA compliance and minimization of total travel time), and constraints (maximum service capacity per team per day, ANEEL deadlines by service type, and geographical availability of teams) (Hillier; Lieberman, 2015). Due to the combinatorial nature of the problem, which makes exact resolution unfeasible for the daily volume of service orders, a constructive heuristic approach was adopted, a consolidated practice in the operational optimization literature (Arenales et al., 2007).

To evaluate the impact of the proposed strategies in relation to current practice, three operational scenarios were simulated: (i) Base Scenario, with sequencing according to current practice and without differentiation by regulatory deadline; (ii) Efficiency Scenario, with sequencing exclusively by geographic proximity; and (iii) SLA-first (Hybrid) Scenario, where service orders with critical deadlines were allocated first, and the remaining ones sequenced by proximity. The simulation was prospective, modeling the sequential execution of up to 50 service orders per day per team, with an average time of 30 minutes per service order and 15 minutes of base travel, using parameters calibrated by real operational data, including the historical execution rate and ANEEL’s regulatory deadlines by type of service.

3. Results and Discussion

The research revealed an integrated forecasting and optimization model capable of transforming field operations management in the electric sector, replacing reactive approaches with a structured, data-driven process. The findings demonstrate significant gains in regulatory compliance and logistical efficiency, validating the application of data analysis and operations research techniques. Initial exploratory analysis provided an in-depth understanding of demand behavior, while predictive modeling with SARIMA offered robust anticipation capabilities. Finally, scenario simulation confirmed the effectiveness of prescriptive prioritization and allocation strategies, highlighting the superiority of the proposed hybrid approach.

Exploratory data analysis

The exploratory data analysis revealed significant variability in the daily volume of service calls throughout the studied period. The database comprised a total of 321,781 service order records, collected between December 2024 and April 2026, with an overall average of 639.7 orders per day. The majority of these service calls were concentrated in essential services such as cutting, reconnection, and new connections, reflecting the critical nature of field operations in the electricity sector. This initial characterization was fundamental to understanding the operational dynamics and the challenges inherent in daily management.

A relevant seasonal variation was identified, especially between October and March, a period known as the Summer Plan. During this interval, which coincides with a higher incidence of rain and emergency activations, the daily average of service calls decreased to 550.4 service orders per day, in contrast to the average of 689.1 orders per day observed in the regular period, from April to September. This decrease in service capacity during the Summer Plan indicates a significant operational restriction and a high risk of backlog formation, particularly in activities with shorter regulatory deadlines, which underscores the need for proactive strategies.

The distribution of operational statuses of service orders also pointed to a considerable portion of services that were not concluded on the first contact. This unproductive rate, which varied according to the type of service and the time of year, showed higher rates during the Summer Plan. This finding reinforced the importance of incorporating the historical non-completion rate as a fundamental criterion in the prioritization process of services, aiming to mitigate the risks of non-compliance with regulatory deadlines and optimize resource allocation.

Demand Forecasting Results

To predict the daily volume of service orders, the Seasonal Autoregressive Integrated Moving Average (SARIMA) model was developed and compared to a seven-day moving average baseline. After daily aggregation of service orders, the data were split into 402 days for training and 101 days for testing. The Mean squared error (RMSE) was the primary evaluation metric, as the Mean Absolute Percentage Error (MAPE) was discarded due to the presence of days with zero volume, which would distort the results by division by zero.

The SARIMA model demonstrated superior performance, achieving an RMSE of 177.27, compared to the 344.66 RMSE of the moving average baseline. This performance represents a 48.6% reduction in error, indicating a significantly greater ability to anticipate the daily volume of service orders. The selection of SARIMA model parameters was guided by the Akaike Information Criterion (AIC), and the stationarity of the series was confirmed by the Augmented Dickey-Fuller test, with a p-value less than 0.05, validating the absence of a unit root.

The adequacy of the model fit was further validated by the Ljung-Box test on the residuals, which did not reject the hypothesis of absence of residual autocorrelation, an essential condition for the reliability of forecasts. SARIMA proved particularly effective in capturing the seasonal drop in demand characteristic of the December to February quarter, a period when the volume of emergencies tends to increase due to rainfall. This forecasting accuracy is crucial for management, allowing for proactive adjustment of team allocation and reduction of the risk of non-compliance with regulatory deadlines, as highlighted by Silver (2012).

Prescriptive optimization

The prescriptive optimization stage was structured to achieve three simultaneous objectives: maximizing regulatory deadline compliance (SLA), reducing teams’ geographical displacements, and increasing overall operational efficiency. To this end, a set of explicit prioritization rules was combined with a *nearest neighbor* type spatial sequencing heuristic. Service orders with critical deadlines were prioritized and allocated first, while the others were sequenced based on geographical proximity, calculated by the Euclidean distance between coordinates.

The criticality of the service orders was determined by a risk indicator based on the historical rate of unproductivity by service type. Orders with a higher frequency of non-completion on the first attempt received a higher weight in the prioritization process, ensuring that resources were directed primarily to the most sensitive services. This systematic approach contrasts with the reactive decisions historically adopted, which often resulted in unproductivity and inefficient dispatch.

From the perspective of Operations Research, the prescriptive model was formally structured with decision variables that define the execution sequence of orders by each field team. The objective function sought the simultaneous maximization of SLA compliance and the minimization of total travel time. The constraints included the maximum service capacity per team per day, ANEEL’s regulatory deadlines by service type, and the geographic availability of the teams (Hillier; Lieberman, 2015). The combinatorial complexity of solving this model exactly for a daily volume of approximately 640 service orders and dozens of teams justified the adoption of a constructive heuristic approach, which sacrifices global optimality in favor of viable and computationally efficient solutions (Arenales et al., 2007).

SLA constraint scenario simulation

To evaluate the impact of the proposed strategies in relation to current practice, three distinct operational scenarios were simulated. The Base Scenario represented the current practice, without differentiation by regulatory deadline. The Efficiency Scenario focused on sequencing exclusively by geographic proximity. Finally, the SLA-first, or Hybrid, Scenario prioritized service orders with critical deadlines and sequenced the remaining ones by proximity. The simulation parameters were calibrated with real operational data, including a historical execution rate of 50.93% and ANEEL’s regulatory deadlines for different types of service, such as 4 hours for reconnection/emergency, 8 hours for disconnection, 48 hours for new connection, and 72 hours for metering.

The prospective simulation modeled the sequential execution of up to 50 service orders per team per day, considering an average time of 30 minutes per service order and 15 minutes of base travel time. The resulting indicators revealed that the SLA-first Scenario presented the highest deadline compliance, reaching 39.80% of SLA met, which represents a gain of 0.83 percentage points over the Base Scenario, which recorded 38.97%. The Efficiency Scenario, in turn, achieved 39.70% of SLA met, with a gain of 0.73 percentage points compared to the base scenario.

In terms of logistical efficiency, both optimization scenarios, Efficiency and SLA-first, resulted in a significant reduction in the teams’ average daily travel. Total travel was reduced by 20%, from 750 minutes per day in the Base Scenario to 600 minutes per day in the optimized scenarios. This 20% reduction in travel time has direct and substantial economic implications, as in operations with multiple active teams, each minute saved per team per day translates into accumulated gains in fuel costs, fleet depreciation, and team hours freed up for additional productive service calls (Lima, 2023).

Although the absolute gain in SLA compliance is modest, reflecting the operational capacity bottleneck imposed by the combination of short regulatory deadlines (4 to 8 hours for 55% of service orders) and the time required for sequential execution, the hybrid strategy proved to be the most effective. The comparison between the Efficiency Scenario and the SLA-first Scenario confirmed that prioritization by regulatory urgency should precede spatial sequencing, as the hybrid approach achieved slightly superior SLA performance. Structured SLA prioritization also contributes to reducing contractual exposure to regulatory penalties, mitigating operational risks arising from non-compliance with ANEEL deadlines.

The results obtained are in line with the specialized literature, which points to the effectiveness of combining structured prioritization with logistical criteria in promoting simultaneous improvements in compliance and efficiency (Hillier; Lieberman, 2015; Santos et al., 2023). The research also showed that the main limitation to SLA compliance is team service capacity, suggesting that future extensions of the model could incorporate workforce sizing decisions. From a managerial perspective, even an initial version of the integrated model, with relatively simple heuristics, is capable of generating immediate operational value, allowing for anticipation of workforce adjustments and increasing regulatory compliance and team productivity.

In summary, the integrated forecasting and optimization model demonstrated its ability to generate simultaneous gains in regulatory compliance and logistical efficiency in the field operations of the electric sector. Exploratory analysis detailed seasonality and operational challenges, the SARIMA model provided demand forecasts with a 48.6% reduction in RMSE, and scenario simulation confirmed that the hybrid approach of prioritizing by regulatory deadline and spatial optimization increased SLA compliance by 0.83 percentage points and reduced average travel by 20%. These findings validate the replacement of reactive decisions with a structured, data-driven process, promoting more proactive and efficient management.

4. Conclusion

This work sought to develop and evaluate an integrated forecasting and optimization model for field operations in the electricity sector, with the objective of improving regulatory compliance and logistical efficiency. It was found that the SARIMA model demonstrated superior predictive capability, reducing the mean squared error (RMSE) by 48.6% compared to the moving average baseline, which allowed for robust anticipation of the daily volume of service orders. Prospective scenario simulation showed that the hybrid approach, which combined prioritization by regulatory deadline with spatial optimization, increased Service Level Agreement (SLA) compliance by 0.83 percentage points over the base scenario and reduced the estimated average team travel by 20%. These findings confirm the feasibility of replacing reactive decisions with a structured, data-driven process, generating simultaneous gains in regulatory compliance and logistical efficiency, in addition to offering immediate managerial value by allowing proactive workforce adjustments and mitigating risks of regulatory penalties.

Despite the observed gains, it was identified that the main limitation to SLA compliance lies in the operational capacity of team service, influenced by the combination of short regulatory deadlines and the time required for sequential order execution. As future extensions, it is suggested to incorporate workforce sizing decisions into the model, explore more sophisticated predictive algorithms, such as Random Forest and XGBoost, to capture non-linear relationships, and include ANEEL’s financial and regulatory indicators in the scenario evaluation. It is also recommended to evolve towards a real-time decision support system, integrated with operational databases, which would broaden the model’s applicability to other distributors and regions.

Bibliographic References

Arenales, M.; Armentano, V.; Morabito Neto, R.; Yanasse, H. 2007. Pesquisa operacional. Elsevier, Rio de Janeiro, RJ, Brasil.

Creswell, J.W. 2016. Projeto de pesquisa: métodos qualitativo, quantitativo e misto. 5ed. Penso, Porto Alegre, RS, Brasil.

Fávero, L.P.; Belfiore, P. 2024. Análise de dados: estatística e modelagem multivariada com Excel, SPSS, Stata, R e Python. 2ed. GEN | LTC, Rio de Janeiro, RJ, Brasil.

Gil, A.C. 2017. Métodos e técnicas de pesquisa social. 7ed. Atlas, São Paulo, SP, Brasil.

Hastie, T.; Tibshirani, R.; Friedman, J. 2009. The elements of statistical learning: data mining, inference, and prediction. 2ed. Springer, New York, NY, USA.

Hillier, F.S.; Lieberman, G.J. 2015. Introduction to operations research. 10ed. McGraw-Hill Education, New York, NY, USA.

Lima, F.G. 2023. Análise de riscos. 3ed. Atlas, São Paulo, SP, Brasil.

Santos, M.; Gomes, C.F.S.; Moreira, M.A.L.; Costa, I.P.A. 2023. Ferramentas computacionais de apoio à tomada de decisão. 1ed. Atlas, São Paulo, SP, Brasil.

Silver, N. 2012. The signal and the noise: why so many predictions fail but some don’t. Penguin Press, New York, NY, USA.

Article originating from the Final Course Project of the Specialization in Data Science and Analytics of the MBA USP/Esalq

To learn more about the course, click here and access the MBX Academy platform

You may also like

November 17, 2026

Detection and Diagnosis of Diseases in Corn and Rice in Mozambique with Deep Learning

Mozambican agriculture depends on corn and rice, fundamental crops for food security, but their productivity is strongly affected by phytosanitary diseases, whose early and accurate identification remains a challenge in resource-limited contexts. The study aimed to develop and compare Deep Learning-based models for the automatic detection and diagnosis of diseases in corn and rice leaves in Mozambique. Three approaches were used: a classic Convolutional Neural Network (CNN) developed from scratch, and two transfer learning models, ResNet50 and MobileNetV2. The dataset consisted of images from public databases and collected in the field, which underwent cleaning, balancing, and artificial augmentation steps. The models were trained and evaluated with standard performance metrics, including accuracy, precision, recall, F1-score, Log Loss, and Cohen’s Kappa. The classic CNN presented the best overall performance, with 94% precision, recall, and F1-score, and 93% accuracy and Cohen’s Kappa. MobileNetV2 achieved 91% F1-score and 90% accuracy, standing out for its lower Log Loss (0.30) and training time (6h32min59s). ResNet50 reached 80% F1-score and 79% accuracy. It was concluded that Deep Learning techniques have high potential to support phytopathological diagnosis in real agricultural contexts, contributing to faster and more accurate decisions in the management of corn and rice diseases.

Keywords: Deep learning; Rice; Plant diseases; Corn; Computer vision.

November 17, 2026

Artificial intelligence in accounting operational routines and financial efficiency

The incorporation of Artificial Intelligence (AI) and automation tools has reconfigured the routines of Brazilian accounting offices, impacting productivity, error mitigation, and financial efficiency. These impacts were analyzed in a small accounting firm, specialized in serving service providers in the medical field in São Caetano do Sul, São Paulo. The research adopted a qualitative approach, with a single case study design and incorporated units of analysis. Data were collected through a structured questionnaire, applied via Google Forms between January and February 2026, to five professionals in the operational structure of the firm in a census survey. The treatment followed content analysis with a priori and emergent categories. All respondents declared the use of automated tools or tools with AI resources. The perception of reduced execution time, decreased operational errors, rework, and better use of the team’s time converged in 80% of affirmative responses and 20% partial responses. The most benefited activities were bank reconciliation, import of fiscal documents, and tax assessment, with visible gains on typing errors, duplicate entries, and incorrect classification. Human intervention remained indispensable in tax planning, scenario analysis, and verification of ancillary obligations. The overall evaluation of AI’s contribution was predominantly favorable, with moderation linked to the complexity of fiscal regulations.

Keywords: Content analysis; Process automation; Accounting 4.0; Small business; Digital transformation.

November 17, 2026

Factors influencing schedule management in sewage treatment plant “retrofit” projects

Projects involving “retrofit” in Sewage Treatment Plants (STP) are characterized by high complexity, operational restrictions, and multiple technical interfaces. The study analyzed the perception of the professionals involved regarding the management and adherence to deadlines in “retrofit” projects for sewage treatment plants, considering technical, operational, and organizational factors. The research was characterized as an applied study, with a quali-quantitative approach, designed as a field survey. Data analysis was performed using descriptive statistics and qualitative categorization, employing SWOT, risk matrix (Probability x Impact), and 5W2H action plan tools. The results indicated a high perception of clarity (77.8%) and realism of deadlines (100% agreement), evidencing consistent initial planning. However, 77.7% of respondents pointed out that rework and scope changes directly impacted deadline adherence. The integration between engineering, manufacturing, and Production Planning and Control (PPC) showed an intermediate evaluation (77.7% partial/total agreement), indicating fragility in interfunctional coordination. The risk matrix highlighted as critical: scope changes, operational limitations of the STP, and technical complexity, all with a high level. As a central improvement, the standardization of scope change control, analysis, and approval was proposed, aiming to reduce rework and increase schedule predictability.

Keywords: Performance; Integration; Planning; Rework; Risk.

November 17, 2026

B2C Acquisition in diagnostic medicine: strategic partnerships with specialized medical offices

The diagnostic medicine sector in Brazil operates with high dependence on health plan providers, which limits the financial autonomy of service providers. This study proposed and analyzed a direct patient acquisition model (B2C) for a highly complex diagnostic medicine institution, structured through partnerships with Oncology and Cardiology practices and operationalized by a personalized customer service called concierge. The investigation adopted a mixed-methods approach in three phases: a field survey with a structured questionnaire applied to 87 patients, mapping of the operational flow using “Service Blueprint”, and analysis of the conversion rate from 312 medical referrals registered in the pilot project. The results indicated that trust in medical referral achieved 92.0% agreement, establishing itself as the main factor for adherence. The convenience of performing the exam on the same day reached 78.2%, and the willingness to pay directly was 55.2%, with polarization associated with the predominance of health plan users. The “Service Blueprint” identified three critical points in the transitions between stages of the patient journey. The overall conversion rate was 51.0%, with superior performance in Oncology (58.2%) compared to Cardiology (45.0%), and the greatest loss was concentrated in the acceptance and scheduling stage (28.3%). It was concluded that the model demonstrated possible operational viability and indications of patient acceptance, conditioned by price transparency and a reduction in the interval between consultation and approach by the concierge.

Keywords: Direct payment; Patient journey; Supplementary health; Concierge service; Conversion rate.

November 17, 2026

The role of the school manager in promoting an inclusive culture: leadership and educational policies

The research analyzed the school manager’s performance in promoting an inclusive culture, considering the need to transform legal guidelines and pedagogical foundations into effective institutional practices. It was assumed that school inclusion requires planning, organization, and strategic leadership in the school’s daily operations. A qualitative approach of an applied nature was adopted, developed in three complementary stages: documentary analysis of Brazilian legislation on inclusive education, bibliographic review on school leadership and management, and data systematization using management tools such as SWOT analysis and the PDCA cycle. The results indicated that the school management’s performance directly influenced the consolidation of inclusive environments, especially in the organization of processes, continuous team training, and strengthening of a collaborative institutional culture respectful of diversity. Structural, pedagogical, and relational challenges that demanded planned interventions were also identified. Finally, a Practical Guide for School Managers was developed, with guidelines, protocols, and operational orientations for decision-making and the organization of inclusive processes. It was concluded that the construction of an inclusive culture depended on the management’s ability to articulate public policies, pedagogical practices, and institutional processes, consolidating inclusion as a permanent commitment in the school context.

Keywords: educational accessibility; educational equity; participatory management; strategic planning; institutional processes.

November 17, 2026

An AI artifact based on Design Thinking to support the elicitation of software requirements from user needs

The development of software oriented to user needs frequently faces challenges in requirements elicitation, stemming from ambiguities in natural language and communication failures. Given this, an intelligent artifact integrating Design Thinking and Artificial Intelligence was proposed and validated, focusing on the Empathy and Definition stages, to support the collection, interpretation, and structuring of user needs. The research, of an applied, qualitative, and exploratory nature, conducted a Proof of Concept in a controlled environment, employing hypothetical scenarios. The artifact operated through guided natural language interviews, organizing information into elements such as pain points, context, and impact, and generating traceable problem syntheses. The results indicated that the system organized unstructured reports, reduced ambiguities, and preserved the meaning of the original information in most cases. The ability to reorganize logically in complex scenarios was also observed, although with limitations in separating multiple problems and dependence on instructions. It was concluded that the artifact has potential as a support for requirements elicitation, improving the clarity and structuring of information, but requires supervision and contextual control.

Keywords: Design Thinking; Requirements Elicitation; Requirements Engineering; Artificial Intelligence; Natural Language Processing.

November 17, 2026

The Extinction of the Monophasic Tax System in the Pharmaceutical Industry in Light of the Tax Reform

The consumption Tax Reform, established by Constitutional Amendment No. 132/2023, introduced structural changes to the Brazilian tax system, with the replacement of the Social Integration Program (PIS) and the Social Security Financing Contribution (COFINS) by the Contribution on Goods and Services (CBS), in a dual Value Added Tax (VAT) model. The objective was to analyze the impacts of the extinction of the single-stage system on the pharmaceutical industry, in light of the new regulatory design and its economic and legal effects. A qualitative, exploratory research was conducted through a case study and documentary analysis of legislation and specialized doctrine. It was examined whether the end of the single-stage system would imply a relevant increase in the tax burden for the sector. The results indicated that, although the formal overcoming of the single-stage system has occurred, the material exemption of medicines has been preserved, mainly due to the application of reduced rates of 60% and, in certain cases, a zero rate of the Tax on Goods and Services (IBS) and CBS. The change in model may cause occasional variations in revenue collection, without characterizing a structural increase in the tax burden, tending towards neutrality over time. It was preliminarily concluded that the Tax Reform reorganized the taxation technique in the pharmaceutical industry, replacing a concentrated regime with more transparent exemption mechanisms. This approach proved compatible with the principles of neutrality, full non-cumulativeness, and fiscality, maintaining tax protection for essential medicines and aligning fiscal policy with the fundamental right to health.

Keywords: CBS; COFINS; IBS; Dual VAT; PIS.