1 / 17

REPORTING, ANALYSIS AND PLANNING SYSTEM

REPORTING, ANALYSIS AND PLANNING SYSTEM. RAPS Budgeting User Forum July 19, 2011. Agenda. FY13 Deployment Schedule – Jean Shuler FY13 Budget Enhancements Compensation Budgeting - Jean Shuler General Operating/Specific Purpose - Eva Ostrow

kass
Download Presentation

REPORTING, ANALYSIS AND PLANNING SYSTEM

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. REPORTING, ANALYSIS AND PLANNING SYSTEM RAPS Budgeting User Forum July 19, 2011

  2. Agenda • FY13 Deployment Schedule – Jean Shuler • FY13 Budget Enhancements • Compensation Budgeting - Jean Shuler • General Operating/Specific Purpose - Eva Ostrow • Progress on Performance Improvements - Tim Redmond • Focus Group Updates • Budgeting Reports Focus Group – Debbie Vasel • Simplifying the Compensation Budgeting Model for FY14 – Jean Shuler • Training Needs for FY13 – Pam Fournie • Wrap up CB = Compensation Budgeting, GO = General Operating, SP = Specific Purpose

  3. FY13 Deployment Schedule Sept 27 Deadline for new accounts (FIS Profiles) Oct 6 CB apps Internal Medicine, Center for Advancement of Medicine, Center for Health Behavior Research, Pediatrics, Radiology, Surgery, Siteman, and Central Administration (PRB) Oct 13 GO & SP apps – Departments as above Oct 17 GO & SP apps for remaining Medical School Departments Nov 23 Deadline for new accounts (FIS Profiles) Dec 7 - 12CB apps for remaining Medical School Departments **TENTATIVE** CB = Compensation Budgeting, GO = General Operating, SP = Specific Purpose

  4. FY13 Enhancements Compensation Budgeting • Ability to adjust current FTE after budget model is loaded • Importing last year’s aggregates to prior year fields • Fund category names are more consistent between CB & SP and funds roll correctly • Ability to override node on Specific purpose generic sourcing to drive expense to a different department • Functions are logic derived for real accounts and entered for SP generic funds for placement in SP model

  5. FY13 Enhancements Snapshot of dddd override on source tab CB = Compensation Budgeting, GO = General Operating, SP = Specific Purpose

  6. FY13 Enhancements Snapshot of SP Function on source tab CB = Compensation Budgeting, GO = General Operating, SP = Specific Purpose

  7. FY13 Enhancements General Operating & Specific Purpose • Credits displayed in the model as a negative • Combined Budget Input, Projections & History Tabs • Subclass Object description removed • FY12 SP Budget loaded from last year’s budget datamart

  8. FY13 Enhancements

  9. Performance Improvements in the model • Improvements on Saving • Opening is unchanged PC Dependent • Minimum recommended hardware • On RAPS home page under Getting Started: http://raps.wustl.edu • Multiple open applications will impact performance Medical School end-user performance testing • Will provide guided test plans • Strictly volunteer basis CB = Compensation Budgeting, GO = General Operating, SP = Specific Purpose

  10. Focus groups

  11. Focus groups Budgeting Reports Focus Group Enhance Existing Reports: • R&E - Departmental Budget Analysis • R&E - CFU Budget Template Report • CB – Job Salary & Fringes • CB – Source Detail by Node • CB – Source Detail by Employee • CB – Source Detail by Object Group • CB – Source Detail by SubClass • CB – Source Detail by SubClass Object • CB – Variance Compensation Report • CB – Variance Other Earnings • CB – Variance Salary & Other Earnings by SCOB or Obj Group • CB – Variance Source by Dept-Fund • CB – Variance Source by Employee CB = Compensation Budgeting, GO = General Operating, SP = Specific Purpose

  12. Focus groups Budgeting Reports Focus Group • Update CB and R&E Report Manuals which are available at http://raps.wustl.edu andhttps://raps.wustl.edu/cognos8 • Create new reports as needed • Identify key reports/data attributes that need to be potentially available real time in FY14. CB = Compensation Budgeting, GO = General Operating, SP = Specific Purpose

  13. Focus groups

  14. Focus groups Simplifying the Compensation Budgeting Model • Keep organization of employees by job within department • Support different functionality of Academic, Staff, and Other employees. Evaluate adding of zero hourly employees • Compensation data will remain static during the budget cycle and will not be reloaded • Try combining Prime, Secondary, and HR Data tabs by eliminating redundant data and HR data not needed for Salary Planning, and remove title only jobs. • Change how Pool Checks work via summarizing on another tab that shows aggregated components of the Pool CB = Compensation Budgeting, GO = General Operating, SP = Specific Purpose

  15. Focus groups Simplifying the Compensation Budgeting Model • Keep Primary History tab, but break out Bonuses to own column • Remove Primary Appts • Keep New Job tab and add additional slots CB = Compensation Budgeting, GO = General Operating, SP = Specific Purpose

  16. Training Needs for FY13 • Weekly tips • Computer Based Training modules (CBTs) are available at http://raps.wustl.edu • Webinars for ‘What’s New’ • Workshops? • New Employee training – need to identify how many to determine solution • Other needs?

  17. Wrap Up • New access or changes to security forms should be sent to RAPS Support at campus box 1110 • Proposed Agenda Items for October meeting: • Updates from Focus Groups • Tips and Techniques for FY13 Budget Process • Send proposed agenda items to pamela.fournie@wustl.edu • Q&A

More Related