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

Case Study

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
Download Case Study

©2017 Tiger Analytics. All rights reserved.

Log in with your credentials

Forgot your details?