A Study on Optimizing the Production Planning and Control at Renault Nissan Automotive India Pvt Ltd, Oragadam, Chennai

This study investigates strategic integration of Excel macros to automate the MS No 4 process within Renault Nissan Automotive India Pvt Limited's production planning and control framework. Excel macros, renowned for their versatility in automating repetitive tasks, are employed to optimize various aspects of the MS No 4 process, thereby enhancing operational efficiency. The implementation of macros enables the company to streamline data management, report generation, and task scheduling, leading to significant time and resource savings. Furthermore, by ensuring data accuracy and consistency, the macros contribute to improved decision-making processes within the organization. Through a comprehensive case study, this research elucidates the specific functionalities and applications of Excel macros in the context of production planning and control. By leveraging Excel macros to automate the MS No 4 process, Renault Nissan Automotive India Pvt Limited not only enhances operational efficiency but also fosters a culture of continuous improvement and innovation. This research underscores the significance of embracing technological advancements to meet the evolving demands of the industry and achieve sustainable growth. Through the successful deployment of Excel macros, the company demonstrates its commitment to leveraging cutting-edge tools to drive excellence in production planning and control, positioning itself as a leader in the automotive manufacturing landscape.