Executive Summary

February 02, 2026

Comparison of demand forecasting models for the electronics retail sector

Carlos Eduardo Amorim de Oliveira; Elisa Morandé Sales

Summary prepared by the ResumeAI tool, an artificial intelligence solution developed by Instituto Pecege focused on synthesis and writing.

This work develops and evaluates time series-based demand forecasting models for the IT category in a retail company, comparing statistical approaches with a focus on accuracy and applicability for inventory management. Demand forecasting is fundamental in supply chain management, especially in volatile sectors like consumer electronics. The IT category, with items such as notebooks and components, presents unique challenges: strong seasonality (Black Friday, back to school), rapid technological obsolescence, and the impact of promotional campaigns that generate abrupt fluctuations in consumption.

The absence of a robust forecasting system entails financial and operational consequences. Overestimating demand leads to excess inventory, tying up capital and increasing storage costs and obsolescence risk. Underestimating results in stockouts, which compromise revenue and customer loyalty. In this context, applying statistical models to analyze historical sales data is a strategic solution to mitigate risks. The ability to transform data into predictive intelligence is a competitive advantage (Fawcett & Provost, 2013).

Time series models are consolidated tools for sequential data analysis, based on the premise that past patterns contain information about future behavior (Morettin & Toloi, 2006). Techniques such as Holt-Winters and ARIMA (Autoregressive Integrated Moving Average) decompose a series into trend, seasonality, and noise to project future values. The advantage of these approaches is their ability to generate accurate forecasts based solely on the history of the variable of interest, which is useful when external data is scarce (Nielsen, 2020).

The application of these models in computer retail allows for the quantification of consumption patterns, offering a basis for purchasing decisions and inventory allocation. The systematic analysis of historical data enables the construction of models with greater predictive power and fosters a data-driven culture. By adjusting the models to reflect category-specific sales cycles, it is possible to anticipate demand peaks and troughs, allowing for more effective campaign planning and working capital management.

The development of an effective model requires a methodological process that begins with an exploratory data analysis, including graphical inspection, checking assumptions such as stationarity, and series decomposition to understand its structure (Hamilton, 1994). The choice of evaluation metrics aligned with business objectives is also a critical step. This study, therefore, seeks to build an analytical framework that can be understood, validated, and replicated for other product categories of the company.

The methodology adopts a quantitative approach, aligned with the principles of data science applied to business problems (Fawcett & Provost, 2013). The database used consists of the monthly sales history of the IT line, covering 30 months, from January 2023 to June 2025. The data were aggregated monthly using the Pandas library in Python (McKinney, 2018). To ensure the integrity of the series, months with no sales were filled with the value zero, reflecting the absence of demand.

Before modeling, an exploratory analysis was conducted. Each time series was decomposed into its three components: Trend, Seasonality, and Residuals (Morettin & Toloi, 2006). Subsequently, to assess the adequacy of ARIMA models, the Augmented Dickey-Fuller (ADF) Test was applied to verify the stationarity of the series, a prerequisite for many stochastic models (Fávero et al., 2014; Hamilton, 1994). A series is non-stationary when its statistical properties, such as mean and variance, change over time.

Four models with different levels of complexity were implemented, a recommended practice to avoid unnecessary complexity (Nielsen, 2020). The Naive Seasonal (SNAIVE) was used as a benchmark, predicting that the future value will be equal to that of the same period of the previous season. Simple Exponential Smoothing (SEX) was applied as a base model. The Additive Holt-Winters Method was chosen for its ability to model level, trend, and seasonality. Finally, the Auto-ARIMA approach was employed, using the auto_arima algorithm to find the combination of parameters (p,d,q)(P,D,Q) that minimizes the Akaike Information Criterion (AIC), ensuring a parsimonious model.

For validation, the series was divided into a training set (January 2023 to December 2024) and a test set (January 2025 to June 2025). The models were trained on the first period to predict the six months of the test period. Performance was evaluated by comparing predictions with actual values, using the Root Mean Squared Error (RMSE) and the Mean Absolute Percentage Error (MAPE). RMSE was prioritized for being more robust and more severely penalizing large errors, being less sensitive to demand values close to zero. MAPE can present inflated values in series with low demand, a common phenomenon in retail (Makridakis et al., 1998).

The application of the methodology revealed significant heterogeneity in the behavior of product families. The ADF Stationarity Test showed that, of the seven families analyzed, only two (“CORE I5” and “CORE I7”) were stationary (p-value ≤ 0.05), while the remaining five (“ACCESSORIES”, “GAMER NOTEBOOK”, “MONITOR”, “CORE I3”, and “PRINTERS”) were non-stationary. This result validated the need for models such as Auto-ARIMA and Holt-Winters, capable of handling non-stationarity (Hamilton, 1994). The decomposition of the aggregated series confirmed the presence of a growth trend and strong annual seasonality.

The quantitative evaluation of the models’ performance showed that none stood out as universally superior. The MAPE metric proved unstable, exceeding 100% for categories such as “PRINTERS” and “GAMER NOTEBOOK”. This behavior occurs when the mean absolute error is greater than the average actual value, a common artifact in low-volume series that makes MAPE an unreliable indicator. The RMSE distribution, in contrast, was more stable, reinforcing the decision to prioritize it as the main evaluation metric (Nielsen, 2020).

The analysis of the decomposition of each series, crossed with the RMSE results, revealed the main finding of the study: the best forecasting model is directly correlated with the series’ demand pattern, a pillar of data science applied to business (Fawcett & Provost, 2013). Three patterns emerged. The first was that of series dominated by a strong growth trend, such as the “CORE I5” family. For this, the Auto-ARIMA model presented the lowest RMSE (895.6), as its structure robustly captures and projects growth trajectories.

The second pattern was that of series dominated by strong seasonality, with a less defined trend, such as the “GAMER NOTEBOOK” family. The decomposition showed clear and recurring sales peaks. In this scenario, the Seasonal Naive (SNAIVE) model, despite its simplicity, had the best performance, with an RMSE of 584.1. SNAIVE’s premise that the previous year’s pattern will repeat itself aligned with the cyclical nature of demand, outperforming more complex models. This highlights that the suitability to the data pattern, rather than model complexity, is the determining factor.

The third product segment was that of intermittent or sporadic demand. The “PRINTERS” family was the main example, with a time series characterized by very low sales, many periods with zero value, and an absence of a clear trend or seasonality pattern. As a consequence, none of the traditional models managed to generate accurate predictions. The best result, obtained by Simple Exponential Smoothing, still presented a MAPE of 344.7% and an RMSE of 272.3. This result is not a modeling failure, but a crucial analytical finding: classic time series techniques are ineffective for intermittent demand data.

The discovery that different demand patterns require different modeling approaches has strategic implications. Instead of seeking a single model for the entire portfolio, the analysis points to the need for a segmented forecasting strategy. Business value lies in the ability to intelligently allocate modeling resources: apply simple models like SNAIVE for seasonal products; concentrate complex models like Auto-ARIMA on strategic products with a strong trend; and recognize intermittent demand products, which should be managed by other inventory policies, such as reorder points.

The results partially corroborate studies such as Simanungkalit (2024), which highlight the effectiveness of ARIMA models for series with a trend. However, this work advances by proposing a segmented strategy based on a prior diagnosis of the series pattern. Furthermore, it highlights the limitation of traditional models in scenarios of intermittent demand, paving the way for the exploration of more suitable models for this type of data, such as the Croston method, or the incorporation of exogenous variables.

This work demonstrated that the diagnostic and exploratory data analysis stage is as important as, or more important than, predictive modeling. Time series decomposition was the tool that revealed the portfolio’s heterogeneity, showing that it is divided into segments with distinct demand patterns: dominated by trend, by seasonality, and intermittent. This finding explains why no single model performed best in all scenarios. The study’s main contribution is not the identification of a superior algorithm, but the proposition of a two-phase analytical process — diagnose the series pattern and then select the appropriate model — as the most robust approach for demand forecasting in retail. The implementation of this framework allows the company to optimize resources, applying simple models where they are effective, complex ones where they are necessary, and recognizing cases where traditional forecasting is inadequate. It is concluded that the objective was achieved: it was demonstrated that the most effective approach for demand forecasting in the IT category is a segmented strategy, in which the choice of the predictive model is conditioned by the specific demand pattern of each product family, overcoming the search for a single, universal model.

References:
Favero, L. P.; Belfiore, P.; Silva, F. L.; Chan, B. L. 2014. Manual de Análise de Dados. 1ed. Elsevier, Rio de Janeiro, RJ, Brasil.
Fawcett, T.; Provost, F. 2013. Data Science for Business: What You Need to Know about Data Mining and Data-Analytic Thinking. O’Reilly Media, Sebastopol, CA, USA.
Hamilton, J. D. 1994. Time Series Analysis. 1ed. Princeton University Press, Princeton, NJ, USA.
Lazzeri, F. 2020. Machine Learning for Time Series Forecasting with Python. 1ed. Wiley, Hoboken, NJ, USA.
Makridakis, S.; Wheelwright, S. C.; Hyndman, R. J. 1998. Forecasting: Methods and Applications. 3ed. John Wiley & Sons, New York, NY, USA.
Mckinney, W. 2018. Python para Análise de Dados: tratamento de dados com Pandas, NumPy e IPython. 2ed. Novatec Editora, São Paulo, SP, Brasil.
Morettin, P. A.; Toloi, C. M. C. 2006. Análise de Séries Temporais. 2ed. Edgard Blücher, São Paulo, SP, Brasil.
Nielsen, A. 2020. Análise Prática de Séries Temporais: Predição com Estatística e Aprendizado de Máquina. 1ed. O’Reilly Media, Sebastopol, CA, USA.
Simanungkalit, E. 2024. Evaluation of ARIMA model performance in projecting future sales: case study on electronic products. Journal of Intelligent Decision Support System 7(4): 309-317.
Singer, C. D. P.; Motta, J. 2020. Análise de dados categorizados. 1ed. Edgard Blücher, São Paulo, SP, Brasil.


Executive summary from the Final Course Work of the Specialization in Data Science and Analytics of the MBA USP/Esalq

Learn more about the course; click here:

Who edited this article

Most recent

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.