• HVAC company manufacturers faces challenges in managing sales and operations planning data across 10 geographies, with the head office in the US.
• Sales and operations planning are maintained in Excel(macro).
• The U.S. team finds it difficult to understand sales data for each geography.
• Customer wanted to streamline the existing process.

Introduction

HVAC company manufacturers faces challenges in managing sales and operations planning data across 10 geographies, with the head office in the US.

Solution

• A power app is provided as per the business requirements.
• Users around different geographies uses this tool.
• Allows Monthly/Weekly submission of S&OP (Sales and Operations Planning) numbers/figures
• Finance data flow from ERP to power app hierarchy wise. An application presents a comparison between estimated and actual sales details.
• Implemented by Centre of Excellence team to consolidate business units which are scattered around different geographies.

Key Benefits

• Time savings of 29.5 hours per month.
• Authentication-based logins for enhanced security.
• Data retrieval in just 5 seconds.
• Easy navigation within the tool interface.
• VPN connectivity is not required to access the tool.