REPORTING, ANALYSIS AND PLANNING SYSTEM

1. REPORTING, ANALYSIS AND PLANNING SYSTEM RAPS Budgeting User Forum January 20, 2012

2. Agenda • Welcome • FY13 Budgeting Current Topics • Support Update – Pam Fournie • Most frequent support topics – Jean Shuler • FY14 Budget Development Status • Revenue & Expense – Eva Ostrow • Compensation Budgeting - Jean Shuler • Q & A

3. FY13 Budgeting Support statistics

4. FY13 Budgeting Top support topics • Installing the RAPS Planning Client • How do I budget and source employees who receive fringes but no salary? • How to exclude an existing employee from the budget? • How do I add a LC-Dept-Fund for a General Operating or Carry Forward account that is not available in the sourcing drop-down list? • How to set up an account during the budget process, and when is it not necessary to do so. • How do I convert/export a report to Excel?

5. FY13 Budgeting • Installing the RAPS Planning Client • If you are new or you are using a different PC, the java component will need to be downloaded the first time you access the models. • Do this under your id, not that of an administrator. • Instructions are on the home page of RAPS.wustl.edu under Getting Started, RAPS Planning Client Installation Instructions • OR you can just following the prompts: • Once you click on a node a button will pop up that says “Install Now.” (A message will also display to close your browser for the changes to take effect.) • Next a File Download window will appear. You can simply select the “Run” button. • After allowing a few minutes, close your browser, then navigate back. A message that the Contributor app is updating will appear. After the message has closed, the installation is complete.

6. FY13 Budgeting • How do I budget and source employees who receive fringes but no salary? • The easiest way to accomplish this is to budget $1 for salary. • Primary Jobs – Enter $1 for the Tot Sal w/o FTE Change field. If the job has zero FTE then the Job Salary Override field can be used to enter the $1 salary, but there should be Total FTE in order to calculate H&O and Dependent Tuition fringe. • Secondary Jobs - Enter $1 for the Job Sal w/o FTE Change field. • New Jobs – For a transferring employee, enter $1 in the Proposed Job Salary field. Also update the Proposed Total and Proposed Job FTE. Note: H&O and Dependent Tuition Fringes are based on the relationship between Proposed Total FTE and Job FTE. If both FTE’s are equal to 1, the model will calculate a full health allowance and dependent tuition rate.

7. FY13 Budgeting • How to exclude an existing employee from the budget? • Enter “Y” in the Exclude from budget row in primary or secondary tabs. • In addition, zero out the following rows for the employee: • Merit % • Proposed Total FTE in the Primary tab • Proposed Job FTE in both Primary and Secondary tabs • Navigate to the source tab, remove any pre-loaded lines of sourcing. Note: Tool tips are available to help with this process.

8. FY13 Budgeting • How do I add a LC-Dept-Fund for a General Operating or Carry Forward account that is not available in the sourcing drop-down list? • Use the New LC12-Dept-Fund tab. • Enter the new account using one of the available 12-dddd-Newxx slots. • On the source tab, use the corresponding 12-dddd-Newxx for the account being added. Note: You will still need to have the account set up in AIS. Once it is the 12-dddd-Newxx will be replaced in the datamart by the account you have requested. It will not be changed in the model.

9. FY13 Budgeting • How to set up an account during the budget process, and when is it not necessary to do so. • Departments must fill out a New Account Request form and forward to their Department's Senior Budget Analyst. • Senior Budget Analyst will set up the new account in AIS and then forward the new account request form to RAPS Support. • RAPS Support will add the new account to your Department's RAPS model. There will be a 24 hour turn-around time for accounts set up during the process. • Please visit the School of Medicine Finance page for more information: http://aladdin.wustl.edu/medadmin/fis/finance.nsf/ • If the account is not needed immediately in the General Operating model, then the New Account Request form need not be sent to RAPS Support. The account will get added during the monthly load process once it has been established as a “new” AIS account.

10. FY13 Budgeting • How do I convert/export a report to Excel? • To export a report to Excel, after you have run the report in RAPS, click the down arrow to the right of the View in PDF Format button in the upper right hand corner of your report toolbar. • From the options, select “View in Excel,” then choose the applicable Excel version. • For more detailed instructions a tutorial is available by selecting RAPS Helpful Tips, Converting a Report to Excel from the Home page under Getting Started.

11. FY14 Revenue & Expense Three advantages of the upgraded software are: • Enhanced performance • Faster results and reports • General Operating and Specific Purpose funds are in the same model

12. FY14 Revenue & Expense FY13 General Operating Revenue and Expense model is shown for reference • Department funds are within the organization structure in the e-list • Department funds are typically opened individually

13. FY14 Revenue & Expense Planned FY 14 Revenue and Expense model • A roll-up can include both General Operating and Specific Purpose funds

14. FY14 Revenue & Expense The Medical Education roll-up is opened as an example • Opening a roll-up will open all department funds within that roll-up simultaneously. • Historic data will be available as it is currently. • All Medical School applications will have tabs that reflect department fund groupings including: Gen Oper 93xxx Endowment Gift funds SP Aggregate • The PRB application will have an additional two tabs: Initiatives Initiative summary

15. FY14 Revenue & Expense • A dynamic subset gives users ability to choose more or fewer column categories. • FY13 Bud is chosen as an example.

16. FY14 Revenue & Expense • Results are individual column categories for all department funds within a fund group.

17. FY14 Revenue & Expense Additional planned features • All applications will have an Allocations tab. • Margin entries can be added for total budget results. • A summary tab will combine data for all General Operating and Specific Purpose department funds within a roll-up. • A Sandbox can be used while working on what-if budgeting scenarios. • Sandboxes are private views or scenarios.

18. FY14 Compensation Budgeting • Simplifying the Compensation Budgeting Model • Primary, Secondary, Other Jobs and HR Data tabs will be combined. Title only Jobs will be removed. • The end user will enter the job amount and that will apply to the total employee, in the case of Primary Jobs. • The nodes will continue to be structured by Academic, Staff and Other Employees. Working towards having additional nodes for displaying of Financial Sourcing where it pertains. • Pool checks section is eliminated, but a new % is being added to account for additional % guideline allowed that is not merit %. • Prime Appts tab will be eliminated. • For Jobs that are budgeted as positions instead of named a new view would be available for Staff Zero-Standard Hour employees. • New Jobs and Monthly Budget will be handled very similarly to how they are handled today.

19. FY14 Compensation Budgeting • Simplifying the Compensation Budgeting Model • The Fellow Health & Other Fringe calculation will be improved or support an override capability. • Source tab selection of valid accounts can be made more selective. • New add accounts feature will be available. May still need to go through RAPS Support initially, but will not work like the New LC-D-F feature works. • Aggregates will flow through Monthly Budget and Source tabs like any other job. No sourcing on the aggregates tab. • Subclass 10 will be elevated to work as a regular subclass. The work-around will be gone. • The Sourced Budget tab will display sourcing from outside your node when sourced to the department/node. • A view will be supplied for easier identification of To Be Sourced amounts.

20. Wrap UP Q & A Next forum Monday, April 16 1:30 pm