Case Studies

Financial Planning and Scenario Analytics, including Exogenous Factors

Posted by | Fuld & Company

The CFO of a leading lubricants manufacturing company was looking for more accurate methods of financial planning to better invest the company’s cash and reduce operational costs.

Objective

To identify cost and revenue drivers and create a forecasting model that could reduce the current prediction error (vs. actuals) from ~8% to less than 5%.

Approach

  • Conducted workshops with key client stakeholders to identify major parameters that impacted demand and sales, and understand clients’ current business models.
  • Collected internal time-series data, such as wholesale and retail sales and volume, number of active product SKUs, number of manufacturing lines, production capacity utilization, number of warehouses, warehouse utilization, inventory, product returns, and destroyed in field.
  • Collected key data related to external factors such as forex rates for USD, oil and gas prices, and other commodity prices.
  • Tested various econometric models, such as SARIMAX, VAR, and LSTM, to identify the best-fit model; produced 3-, 6-, and 12-month forecasts while minimizing RMSE.

Outcome

The company improved forecasting accuracy by better understanding the key drivers of its sales and operational costs, and reducing the prediction error rate to 3.7%.

Algorithms Used: Econometric models such as SARIMAX, VAR, and LSTM

Tools

   

Tags: , , , , ,

Related Resources

Read More

Global medical equipment company discovers a new competitor…and a new market

A leading medical equipment manufacturer was concerned about a new entrant that had moved into one of its high-value, diagnostic […]

Read More

Identifying Drug Repurposing Collaboration Partners

A top pharma company actively working in the drug repurposing sector wanted to expand its portfolio by adding new indications […]

Read More

Identifying the most effective prophylactic/therapeutic oral anti-inflammatory agents

A global FMCG leader sought to expand their current oral care product range with a line of products that had […]

Subscribe to our mailing list for our latest updates:

Wednesday, February 15

10:30 ET | 15:30 GMT

Join us to learn about:

  • Cultural nuance issues
  • Methods to mitigate bias
  • Optimizing survey design
  • Interpreting global results