Identifying where cash was being spent in real time was a key priority at Sprint Nextel, especially as its accounts payable began trending above forecast.  

While the $34 billion voice and data services provider could identify spend via its regression-based forecasting process, it could not isolate where projected overspending was occurring. "It wasn't 'show me the money' so much as show me where the money is being spent," says Jennifer Dale, assistant treasurer and director of treasury services at Sprint. "We wanted real-time visibility into where spend was occurring and how this was trending compared to the budget, rather than an analysis at month-end when the books are closed."

|

Dale was tasked with developing a model with a higher degree of accuracy. The goal was to take the cash forecast AP line and expand it to the business-unit level to track cash spend against the budget and forecast. Dale identified the top 10 business units by spend category, accounting for roughly 80% of total spend. Treasury then created a database utilizing a waterfall hierarchy of identification points to track expenditures in the units.

|

Since implementation, the variance analysis for spend has improved from 5% to 10% to a 2% variance. Sprint now expects to achieve a $500 million improvement in working capital by year-end.

Complete your profile to continue reading and get FREE access to Treasury & Risk, part of your ALM digital membership.

  • Critical Treasury & Risk information including in-depth analysis of treasury and finance best practices, case studies with corporate innovators, informative newsletters, educational webcasts and videos, and resources from industry leaders.
  • Exclusive discounts on ALM and Treasury & Risk events.
  • Access to other award-winning ALM websites including PropertyCasualty360.com and Law.com.
NOT FOR REPRINT

© 2024 ALM Global, LLC, All Rights Reserved. Request academic re-use from www.copyright.com. All other uses, submit a request to [email protected]. For more information visit Asset & Logo Licensing.