1 / 12

Budgeting Module

Budgeting Module. Adding snazzy stats and cool calculations to your presentations. Cassie Bevis. Sr. Regional Financial Mgr , BC Transit. Performance Data. More than just $’s Key Performance Indicators Cost per hour ($/ Hr ) Revenue per passenger ($/ Psgr ) Kilometres per hour (Km/ Hr )

adrianan
Download Presentation

Budgeting Module

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Budgeting Module Adding snazzy stats and cool calculations to your presentations Cassie Bevis Sr. Regional Financial Mgr, BC Transit

  2. Performance Data • More than just $’s • Key Performance Indicators • Cost per hour ($/Hr) • Revenue per passenger ($/Psgr) • Kilometres per hour (Km/Hr) • Mix of $ and #

  3. Performance Data - THEN • Excel based reporting

  4. Performance Data - THEN • Financials in JDEdwards • Need trained Reporting Writer • Other extraction (Crystal) • Non-financials from various spreadsheet sources • Easy to get • Hard to keep accurate

  5. Performance Data - NOW • Financials in JDEdwards available in Hubble • Non-financials input into Hubble • From multiple users • Required Budgeting Contributor Licenses • Utilizes Hubble ledgers • * Requires Objects/Subsidiaries in JDE * BC Transit chosen solution (other options)

  6. Performance Data - NOW $ REVENUE $ EXPENSES # STATISTICS

  7. Performance Data - NOW • Consolidate ledgers • Calculations

  8. Performance Data - NOW • Multi-Business Units • Pivoted (and original AA & A5 ledgers hidden)

  9. Performance Data - NOW • Pivot report style • Columns become individual Calculations

  10. Calculations - DEMO • Hubble Budgeting – data input • Calculations – combine Ledgers • Calculations – ratios as column titles

More Related