Data Management and Analytics For Your Railcar Fleet

Enable your digital transformation

Can you rely on the accuracy of your reports and dashboards?  Or are these numbers created in cumbersome excel spreadsheets?  It doesn’t have to be this way.  By properly integrating and managing your data, you can leverage the immense benefits of having a streamlined organization that relies on its data.  

With the right approach, your organization can leverage a wealth of data including:

  • Customers
  • Contracts
  • Financials (GL, AR, AP, FA)
  • Billing
  • Planning
  • Fleet (UMLER)
  • Repair (BRC)
  • Diagnostics (EHMS)
  • Shops
  • CLMs
  • Telematics
  • External Data (UMLER, Waybill)

Analytics can impact your entire organization

Analytics in Marketing & Sales

Strategic Core Growth

  • Expand fleet 5X in 5 years
  • Develop a diversification strategy
  • Balance revenue potential and internal rate of return (IRR) against revenue risk
  • Involve forecasting equipment values and rates to identify right time to invest

New Market Expansion

  • Explore entry into M&R space
  • Market sizing and forecast
  • M&R shop competitive landscape
  • Fleet profiles and trend forecasts
  • Extensive customer interviews
  • Identify potential acquisition targets

Aggregate Car Market Entry

  • Planned entry into new market via fleet acquisition
  • Competitive assessment of existing rail car fleet
  • Initial contact of Top 100 producers
  • Identification of equipment supply sources and lease opportunities
  • Development of database, customer summaries & action plans

Lead Generation Platform

  • Fundamental processes often overlooked
  • Tedious market research and prospecting necessary to reach prospective customers
  • Results in creation of targeted sales leads
  • Ensures steady flow of qualified sales leads
  • Allows company’s key sales force to focus on closing deals and existing consumers
  • Leading to new customers and sales

Analytics in Operations

Supplier Rationalization

  • Who are the strategic suppliers?
  • Find where the repairs originate geographically and the capabilities of the shops
  • Measure the supplier quality and cost of repairs
  • Identify the repair volumes that can be consolidated for price negotiations

Repair Routing

  • What is the best shop to send a car considering current bad order reason, location, shop location?
  • Consider outstanding programs and potential other collateral repairs and shop capabilities
  • Consider the shop availability before routing the car

Analytics in Finance

Profitability Analytics

  • Construct a monthly P&L for every car in the fleet
  • Utilize all revenue and cost information that are available at car level
  • Allocate line items that are not available at car level
  • Bring all business dimensions such are car type, lease, type, ownership, age and mechanical info for analysis

Capital Allocation

  • Calculate car type level leverage numbers considering risk and return criteria for each product for maintaining a desired risk profile for the portfolio
  • Simulate worst case scenarios, stress testing the portfolio for given set of extreme market conditions

Analytics in Asset Management

Portfolio Strategies

  • Optimizing fleet performance
  • Balancing risk and profitability
  • Maintaining competitiveness
  • Positioning fleet for the future marketplace
  • Acquisition & remarketing strategies

Portfolio Management

  • Tactical driven car type segment strategies
  • Mix-management focus
  • Customer & industry-centric
  • Refurbishment & conversion programs
  • Portfolio acquisition support

Forecasting & Fleet Planning

  • Industry-level fleet analysis & segmentation
  • Focus on existing fleet trends, retirements, surpluses, new cars…
  • Benchmarking & competitor analysis
  • N American Fleet & Shipment Platform
  • Market research & analysis

Equipment Values & Pricing

  • Lease rates
  • FMV and new car costs
  • Car type segment level
  • Multivariable regression models
  • Comprehensive database of rail industry and equipment drivers
  • Tactical pricing decisions and portfolio acquisitions

Analytics in Risk

Portfolio Risk Policy & Metrics

  • Analytics-based process
  • Fleet segment risk triggers
  • Mitigation strategies
  • Utilization & profitability optimization
  • Standardized process & reporting
  • Controls risk exposure

Collections Optimization

  • How to improve the efficiency of the collections efforts?
  • Understand the customer delinquency behavior at a granular level
  • Understand the roll-rate behaviors in the receivables aging buckets
  • Reduce cash aging in cash applications
  • Reduce outstanding receivables and bad debt reserves and write-offs
Share This