Forecasting and Data Analysis to enable Financial Planning & Analysis for a leading HVAC Manufacturer

Business Objective

Our client is a leading global provider of climate-control solutions for heating, cooling, ventilation, and refrigeration, for both commercial and residential purposes. The client’s Financial Planning & Analysis (FP&A) team deals with a large volume of data sets across revenue, margin, cost, and others.

They wanted to analyze data for three product categories to get actionable insights – Accessories (E.g., Boiler Coils, Cooling Accessories), Equipment (E.g., Dry Charge, Aire Flo), and Parts & Supply (E.g., AC covers, Bearings).

Challenges
  • Variances are calculated on the fly in the web application, which causes a delay in displaying results/charts on the application
  • User requests to add a new Dealer or Sales office have to be done manually

Solution Methodology
  • Received various files through Secure File Transfer Protocol which were processed by Talend jobs
  • Updated data in the database, which was used to calculate variances. Calculated variances on the fly (not stored in the database)
  • Delivered the following solutions to the FP&A team:
    • PVM (Price Volume Mix) Analyzer – To calculate variances based on flexible time period given by the user
    • Data Analyzer – To look at Quantity, Revenue, and Margin variances by specific groupings not available in PVM Analyzer
    • PerformanceToPlan – To compare monthly variance forecast to actuals by Product categories
    • Forecast Creator – To generate a new forecast from actuals/previous forecast
Business Impact
  • Automated notifications and report generations to aid quick turnaround time

  • Delivered accurate results to ensure the business could consume the output

  • Enabled ease of analysis by comparing any forecast/plan/actuals

Copyright © 2023 Tiger Analytics | All Rights Reserved