October 19, 2026
Integrated use of Microsoft 365 for schedule management and on-time control in the assembly of electrical panels
Integrated Use of Microsoft 365 for Schedule Management and Control in the Assembly Deadline of Electrical Panels
Roberta Paquer Bueno; Paula Regina Fortes
DOI: 10.22167/2675-6528-202601384
Article prepared by the ResumeAI tool, an artificial intelligence solution developed by the Pecege Institute focused on synthesis and writing.
Summary
A study was developed to demonstrate the integrated application of Microsoft 365 tools in project schedule management, aiming to improve the deadline control for assembling electrical panels in an industrial company in Campinas, São Paulo. The investigation was conducted through a qualitative case study, which analyzed the planning, monitoring, and control processes of material logistics and assembly execution. Initially, limitations in manual methods and low integration between areas were identified. As an alternative, tools from the Microsoft 365 platform, such as Microsoft Forms, Lists, SharePoint, Planner, and Power Automate, were evaluated and applied to structure planning, record tasks, automate information flows, and monitor project progress. The results indicated that the integrated use of these tools contributed to information centralization, improved communication between areas, and increased the reliability of data related to deadline compliance. Greater agility in updating activity status and better support for decision-making in schedule control were observed. The implementation of the digital solution provided greater visibility of activities and synchronization between teams, reducing inconsistencies in monitoring. After approximately eight months of use, the development of a key performance indicator (KPI) focused on the delivery deadline began, allowing for bottleneck identification and exception analysis. It was concluded that the use of Microsoft 365 represents a viable and efficient alternative for improving project management practices, promoting a more integrated, agile, and quality-oriented work model, with greater predictability and support for corrective actions.
Keywords: Flow automation; Collaboration; Operational efficiency; Digital tools; Process optimization.
1. Introduction
In the contemporary industrial scenario, the pursuit of efficiency, quality, and safety drives the continuous optimization of production processes. The assembly of electrical panels, in particular, is configured as critical infrastructure, essential for the integration of control and energy distribution systems in automated environments (Silva; Oliveira, 2021). This intrinsically complex process demands technical expertise, compliance with standards, and meticulous time management. Delays in panel delivery can trigger production interruptions, contractual penalties, and reputational damage. Schedule management is a fundamental pillar of project management (PMI, 2021), and industry data indicates that poor deadline management can lead to a cost increase of up to twenty percent and a ten percent reduction in productivity (Kerzner, 2017). The complexity of projects with multiple interdependent stages requires robust approaches to ensure predictability and effective control of deliveries.
Schedule management transcends the mere creation of a calendar; it encompasses detailed planning, continuous monitoring, and rigorous control of the execution time for each task. According to PMI (2021), effective management involves defining activities, sequencing, estimating durations, developing and controlling the schedule, optimizing the workflow. In manufacturing environments, the absence of efficient deadline control results in operational bottlenecks, costly rework, and a significant increase in costs (Kerzner, 2017). The fragmentation of information and ineffective communication between logistics, planning, and production teams often exacerbate these challenges, hindering visibility of actual progress and proactive identification of deviations. The transition to integrated digital solutions has shown promise in overcoming such limitations, promoting agility and reliability in the management of complex projects.
In this context of growing digitalization, collaboration and productivity platforms, such as Microsoft 365, emerge as strategic tools to enhance project management. The suite offers an ecosystem of integrable applications to create automated workflows and centralize information, facilitating team coordination and data-driven decision-making. Tools like Microsoft Forms, Lists, SharePoint, Planner, and Power Automate enable standardized collection, recording, organization, visual tracking, and automation of repetitive processes, such as notifications and status updates (Microsoft, 2023). The adoption of these collaborative digital solutions is recognized for its potential to transform operational efficiency, promote transparency, and strengthen the culture of continuous improvement across various industries, providing a holistic project view and synchronizing team actions.
Despite the recognized benefits of digital tools, the integrated application of solutions like Microsoft 365 in managing the schedule of specific projects, such as the assembly of electrical panels in an industrial environment, often lacks practical demonstrations of its effectiveness and the real impacts of its implementation. There is a gap between the theoretical potential of these platforms and their optimization in real-world scenarios, where manual methods and low integration between areas still represent significant challenges. Given this problem, the present investigation is justified by the need to offer a practical and validated model to improve deadline control and operational efficiency. The study contributes to the literature by exploring the synergistic application of multiple Microsoft 365 tools, providing insights into how information centralization, workflow automation, and improved communication can be achieved. Thus, the objective of this work is to demonstrate the integrated application of Microsoft 365 tools in project schedule management, aiming to improve the deadline control for the assembly of electrical panels in an industrial company.
2. Material and Methods
The present study was characterized as an applied research, with the primary purpose of proposing practical improvements in schedule management, specifically in the process of assembling electrical panels. The methodological approach adopted was qualitative, focusing on an in-depth analysis of processes, operational practices, and information flows. Statistical methods were not employed for data treatment, prioritizing the understanding of the phenomenon within its organizational context, according to the precepts of Gil (2008).
Regarding technical procedures, the choice was made to conduct a case study, a method that allowed for the detailed investigation of a contemporary phenomenon embedded in its real environment. This methodological choice proved suitable for analyzing schedule management associated with material logistics and the execution of electrical panel assembly, especially when the boundaries between the phenomenon and the context were not clearly defined (Gil, 2008). The descriptive objective of the research aimed to improve a new tool for use in panel assembly, seeking to reduce errors.
The work was developed in a company located in the Campinas region, in the state of São Paulo, which operates in the industrial energy and technology sector. The object of study corresponded to the assembly process of electrical panels, covering the stages of activity planning, materials management, assembly execution, and project schedule control. The research was conducted in line with consolidated practices of project management and organizational integration, as highlighted by Kerzner (2017).
The unit of analysis focused on the planning, monitoring, and control processes of activities related to material logistics and the execution of electrical panel assembly. There was no population or sample in the statistical sense, but rather an analysis of the workflow and interactions among the multiple teams involved, such as the Logistics, Planning, and Factory teams, who actively participated in the collaborative environment and diagnostic meetings.
In the initial phase of the research, data collection was based on direct extraction from SAP system reports, direct observations, and meetings held with the multiple teams involved. The purpose of this stage was to identify the limitations of the previously adopted method, which was characterized by the use of manual controls, low integration between areas, and reduced visibility of activity progress in relation to the project schedule.
As an alternative to existing practices, tools from the Microsoft 365 platform were evaluated and applied, serving as the main instruments for the development of the solution. The tools used included Microsoft Forms, Lists, SharePoint, Planner, and Power Automate. These resources were employed to structure activity planning, record task execution, automate information flows, and enable continuous monitoring of project progress.
For the development of the study, the concepts of schedule management described by the Project Management Institute (PMI, 2021) were used as a basis. Initially, the project management approach adopted by the company was identified, considering the predictive, hybrid, and adaptive models. The Project Breakdown Structure (WBS) was used to organize the scope of the electrical panel assembly project, aligning with PMI’s best practices (2021).
It is important to note that the WBS was not created manually by the author, but rather predetermined. The report extracted from SAP already provided this hierarchical composition, segmenting the complete panel into deliverables and sub-deliverables according to the company’s operational logic. This approach ensured adherence to the real process and avoided conceptual interpretations or data fabrication, reflecting the true industrial process.
After the identification and collection of initial information, the analysis and structuring of the project activity schedule was carried out. This phase was based on the schedule management concepts proposed by PMI (2021), contemplating the logical sequencing of activities for the electrical panel assembly process and the application of the new digital tool based on SharePoint integrated with Power Automate.
In the sequencing of activities, Finish-to-Start (FS) and Finish-to-Finish (FF) precedence relationships were predominantly identified and applied, according to the PMI (2021) guidelines. The FS relationship was used when the start of an activity depended on the completion of another, while the FF relationship was applied to activities executed in parallel, but whose completion was conditioned by the end of a predecessor activity.
The use of SharePoint as a central repository for information allowed the schedule to be structured in a standardized way, ensuring the registration of activities, responsible parties, and deadlines defined by the Planning team. Complementarily, the integration with Power Automate enabled the automation of information flows, allowing for automatic updates of activity status and the sending of notifications to stakeholders via Microsoft Teams, according to the schedule’s progress.
The initial schedule for the analysis and evaluation of the developed tool was set at six months, a period established to allow observation of the behavior of activities, the interaction between the involved areas, and the effectiveness of the automated flows. During this period, the schedule was continuously monitored, allowing for observation of adherence to the established dependencies and the effectiveness of the new tool in controlling deadlines.
To ensure information consistency, it was defined that the input and validation of the schedule data would remain under the exclusive responsibility of the Planning team. This team was in charge of defining dates, risk management, and critical path analysis of the project. The analysis of the collected data was qualitative and descriptive in nature, focusing on understanding the improvements and challenges observed in the application of the tools.
Statistical methods were not employed for data processing, and the analysis focused on describing the improvements provided by the new tools and understanding the impacts within the organizational context. Ethical procedures were not explicitly detailed in the original TCC. A methodological limitation identified was the preliminary nature of the results, as the tool’s testing period was still ongoing, requiring continued monitoring for the consolidation of analyses.
3. Results and Discussion
The Results and Discussion section details the findings obtained from applying schedule management practices and implementing digital tools in the assembly process of electrical panels at the studied company. The findings are presented in three main stages: the analysis of data collection, the structuring of the activity schedule, and the implementation of the tool, culminating in the discussion of observed improvements and challenges. The qualitative and descriptive analysis, according to Gil’s (2008) methodology, allowed for an in-depth understanding of the phenomena within their organizational context, without the use of statistical methods, focusing on the description of impacts and enhancements.
Initially, the data collection stage revealed a significant bottleneck in the previously used digital tool, which combined Microsoft Power Apps and Microsoft Lists. As illustrated in Figure 1, the Power Apps interface was used to indicate the status of dashboards, but the integration with Microsoft Lists, where records were stored, presented a critical limitation of up to 2,000 entries. This restriction, which had already been surpassed in the company’s environment, forced the team to resort to manual controls, such as using emails, to manage part of the deliveries. Such a practice, as widely recognized in project management, introduces a high risk of information loss, record duplication, and inconsistencies in activity tracking (PMI, 2021). The reliance on manual processes to compensate for the deficiencies of digital systems is a common challenge in organizations seeking to optimize their workflows, but which, paradoxically, end up undermining data efficiency and reliability.
Source: Elaborated by the author
Figure 1. Power apps screen indicating which panel by customer name and which step it is in (logistics/planning or finished)
The direct consequence of this limitation was the low visibility of the actual progress of activities. It was observed that several activities remained registered as “open” in the logistics stage within Microsoft Lists, even after the materials had already been physically sent to the factory for assembly. Figure 2 exemplifies this situation, showing activities with outdated status, which severely compromised the Planning team’s ability to have an accurate view of the project’s progress. This discrepancy between the registered status and the operational reality rendered the reports extracted from the SAP system invalid for monitoring and decision-making purposes. The lack of reliable and up-to-date data is a fundamental obstacle to effective schedule management, as it prevents the early identification of deviations and the adequate allocation of resources, as emphasized by Kerzner (2017) when discussing the importance of timely and integrated information. Project management literature reiterates that data integrity is the foundation for any performance analysis and for the formulation of corrective strategies, and its absence generates a cycle of uncertainty and inefficiency.
Source: Elaborated by the author.
Figure 2. The activities in Microsoft list were erroneously left open
The data collection technique, which included direct extraction from SAP reports, direct observations, and meetings with the Logistics, Planning, and Factory teams, was crucial for diagnosing these limitations. The meetings allowed for an understanding of the perceptions and dissatisfactions of the teams involved, revealing that the persistence of open activities in the system did not reflect the real delivery situation for the factory. This disconnection between the system and the actual operation not only generated rework through manual verification but also undermined confidence in existing digital tools. The need for a practical solution to the problems faced in panel assembly, which would resolve systemic and physical errors, was the main driver for seeking a new approach, as detailed in Table 1, which summarizes the research’s methodological choice.
Table 1. Methodological choice of the research
|
Research Classification |
Methodological choice |
Foundation |
Relationship with context |
|
Nature |
Case study |
Develop a practical solution for problems faced in panel assembly |
Solve the systemic and physical errors of the panels |
|
Approach |
Qualitative |
Analysis of the perceptions and dissatisfactions of the factory and logistics team |
Need to understand impacts |
|
Research Objective |
Descriptive |
To register the phenomena |
Describe the improvements of the new tools |
|
Technical Procedures |
Meetings, SAP report analysis, and direct observation |
Use of theories for updating and practical intervention and data collection |
Improve new tool for use in panel assembly aiming at error reduction |
Source: Original research data.
Table 1, or Figure 1 in the original document, highlights the applied and qualitative nature of the study, with the descriptive objective of improving a new tool for panel assembly aiming at error reduction. The methodological foundation points to the need to develop a practical solution for systemic and physical problems, analyze team perceptions, and describe improvements in new tools. This approach aligns with the premise of Gil (2008), who advocates for the case study as an effective method for investigating contemporary phenomena in their real environment, especially when the boundaries between the phenomenon and the context are not clearly defined. The research, by focusing on understanding impacts and describing improvements, adopts a perspective that values the depth of analysis over statistical generalization.
In response to the identified challenges, the project’s activity schedule was analyzed and structured, based on the schedule management concepts proposed by the Project Management Institute (PMI, 2021). This phase not only encompassed the logical sequencing of activities for the electrical panel assembly process but also integrated the new digital tool based on SharePoint and Power Automate as a support solution. PMI (2021) emphasizes that activity sequencing is a fundamental process for defining necessary dependencies and ensuring the effective completion of deliverables. In this context, Finish-to-Start (FS) and Finish-to-Finish (FF) precedence relationships were predominantly applied. The FS relationship was used when the start of an activity depended on the completion of another, ensuring a logical and uninterrupted sequence. On the other hand, the FF relationship was crucial for activities executed in parallel, whose completion was conditioned by the termination of a predecessor activity, allowing for greater flexibility and time optimization.
The use of SharePoint as a central repository for information represented a significant advancement. This platform allowed for the standardization of the schedule, ensuring consistent recording of activities, responsible parties, and deadlines defined by the Planning team. Data standardization and information centralization are critical elements for project management, as they reduce ambiguity and facilitate communication among stakeholders (Rabechini Junior & Carvalho, 2015). Unlike the previous model, which relied on manual controls and emails, SharePoint offers a collaborative environment where multiple users can work simultaneously, updating different activities in parallel, without interference or sequential dependency. This functionality is vital in complex industrial environments, where the interdependence between the Logistics, Planning, and Factory teams requires fluid, real-time coordination. Figure 3 illustrates the new layout of the tool in SharePoint, demonstrating the organization and clarity provided by the platform.
Source: Elaborated by the author.
Figure 3. New layout of how the SharePoint tool works.
The integration with Power Automate complemented SharePoint, enabling the automation of information flows. This automation allowed for the automatic updating of activity status and the sending of notifications to stakeholders via Microsoft Teams, as the schedule progressed. The ability to automate these communication flows is a strategic differentiator, as it reduces the need for manual intervention, minimizes errors, and accelerates the dissemination of critical information. Kerzner (2017) emphasizes that effective and timely communication is one of the pillars for effective project control, and the automation of notifications ensures that all involved parties are always aware of the current status of activities, facilitating the identification of bottlenecks and managerial decision-making. The agility in the information flow, especially due to automatic notifications, allowed stakeholders to be informed more quickly and accurately about the status of activities, reducing response time and improving alignment between Planning, Logistics, and the Factory.
The initial schedule for the tool’s analysis and evaluation was set at six months, a period defined to allow continuous observation of activity behavior, interaction between areas, and the effectiveness of automated workflows. During this period, constant monitoring allowed for verification of adherence to established dependencies and the effectiveness of the new tool in controlling deadlines. To ensure information consistency, the responsibility for inputting and validating schedule data remained exclusively with the Planning team, which was also tasked with defining dates, risk management, and project critical path analysis. This centralization of responsibility ensured that information was managed by specialists, minimizing the probability of errors and inconsistencies.
The preliminary results obtained so far indicate that the application of the testing schedule, associated with the new digital tool, has enabled greater visibility of the progress of activities, better synchronization between the involved areas, and reduction of inconsistencies in schedule monitoring. The greater clarity on the sequencing of activities allowed the teams to easily identify at which stage (step) each deliverable was, contributing directly to improved communication and reduced inconsistencies. This enhanced visibility is one of the main benefits of a well-implemented project management system, as it allows managers and operational teams to make informed and proactive decisions.
In SharePoint, the use of filters stood out as a differential, enabling the identification of urgent activities compared to those that follow the standard flow. This functionality allowed for more efficient prioritization of demands, eliminating the need for manual analysis or cross-referencing of information between systems. The ability to filter and prioritize tasks is essential in production environments with multiple ongoing projects, where resource allocation and managerial attention need to be directed to the most critical points. This functionality, by reducing manual workload, frees up time for teams to focus on higher value-added activities, aligning with the principles of operational efficiency and continuous improvement (Campos, 2004).
The implementation of the tool also resulted in faster processes and better synchronization between activities, with a notable reduction in task overlap, especially in situations where activities occur in parallel. This behavior is directly related to the effective application of Finish-to-Finish (FF) precedence relationships in the schedule, which allows activities to advance simultaneously, but with adequate control over their completions. The schedule’s structure, with each deliverable and sub-deliverable directly associated with the TI and FF dependencies defined by the PMI (2021), ensured that all information originated from real records extracted from SAP, avoiding the use of fictitious data and guaranteeing adherence to the true industrial process. This approach ensures that the interpretations made in the research reflect the company’s operational reality, a crucial aspect for the validity and applicability of the results.
The facilitation of bottleneck identification was another notable benefit, allowing for the comparison of planned deliveries with stages that presented status inconsistencies or delays in schedule tracking. This real-time monitoring and comparison capability is fundamental for proactive project management, enabling quick interventions before deviations become major problems. The improvement in communication between areas and the increased reliability in activity tracking directly reflect operational efficiency. The implemented solution provided greater organization of information, which is a prerequisite for any process improvement initiative.
After approximately eight months of use, the tool demonstrated its consolidation, elevating process control to a more structured level. During this period, it was possible to begin implementing a Key Performance Indicator (KPI) focused on delivery time. This KPI allows for the identification of bottlenecks, analysis of exceptions, and understanding of non-standard variations, transforming raw data into actionable intelligence. The ability to monitor performance through clear indicators is a pillar of modern management, providing objective metrics to assess the success of interventions and identify areas that require continuous attention. This advancement significantly expands management capacity, providing greater predictability, support for decision-making, and direction for more assertive corrective actions.
In summary, the application of Microsoft 365 tools met the proposed objective of improving schedule management in the electrical panel assembly process. The digital solution not only resolved the limitations of previous tools but also strengthened the culture of continuous improvement within the organization, consolidating a more integrated, agile, and quality-oriented work model. The transition from manual controls and decentralized information to an integrated and automated system resulted in tangible gains in terms of clarity, agility, and information reliability. Although the results are preliminary, the observed trend points to a positive transformation in the company’s project management, aligning it with industry best practices and the demands of an increasingly complex and competitive industrial environment (Silva; Oliveira, 2021). The continuity of monitoring and the consolidation of analyses in the final stages of the study will be crucial to fully validate the long-term impact of the tool.
4. Conclusion
It is concluded that the objective was achieved, demonstrating the integrated application of Microsoft 365 tools in project schedule management, with a focus on improving the control of the assembly deadline for electrical panels in an industrial company. The implementation of the solution based on SharePoint and Power Automate, replacing previous systems with registration limitations, provided significant gains. A substantial improvement was observed in the visibility of activity progress, greater synchronization between the Planning, Logistics, and Factory teams, and a notable reduction in inconsistencies in schedule tracking. The automation of information flows and the ability to filter urgent activities contributed to more agile processes and more effective communication, culminating in the consolidation of the tool and the beginning of the implementation of a Key Performance Indicator (KPI) to monitor the delivery deadline.
However, it is essential to acknowledge the limitations of this study. The results presented are preliminary, as the tool’s testing period is still ongoing, requiring continued monitoring for the full consolidation of the analyses. Furthermore, as this is a case study in a specific industrial environment, the generalization of findings to other contexts may be limited. For future studies, long-term validation of the tool’s impacts is suggested, with the collection of quantitative data on the reduction of deadlines and costs. It is also recommended to apply the methodology in different industrial sectors or companies of various sizes, as well as to explore other integrations and functionalities of the Microsoft 365 ecosystem or other digital platforms, in order to broaden the robustness and applicability of the results.
Bibliographic References
CAMPOS, V. F. (2004). TQC: Controle da Qualidade Total. 5. ed. Belo Horizonte: INDG.
GIL, A. C. (2008). Métodos e técnicas de pesquisa social. 6. ed. São Paulo: Atlas.
KERZNER, H. (2017). Gestão de projetos: as melhores práticas. 3. ed. Porto Alegre: Bookman.
Microsoft, 2023 [Referência completa não encontrada no documento original]
PROJECT MANAGEMENT INSTITUTE. (2021). A guide to the project management body of knowledge (PMBOK® Guide). 7. ed. Newtown Square, PA: Project Management Institute.
RABECHINI JUNIOR, R.; CARVALHO, M. M. de. (2015). Gestão de projetos na prática. São Paulo: Atlas.
SILVA, J.; OLIVEIRA, M. (2021). Montagem de Painéis Elétricos Industriais: Normas e Boas Práticas. São Paulo: Érica.
Article originating from the Final Course Project of the Specialization in Project Management of the MBA USP/Esalq
To learn more about the course, click here and access the MBX Academy platform