1 / 16

An Overview of ARC’s Budget Services

An Overview of ARC’s Budget Services. Jaime Harbour Budget/Reporting Supervisor Accounts and Reports Branch . Budget Service Levels. Funds Control (Basic) Document entry and reprogrammings Maintaining system funds control SF-132 support Basic services plus MAX Reporting

kort
Télécharger la présentation

An Overview of ARC’s Budget Services

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. An Overview of ARC’s Budget Services Jaime Harbour Budget/Reporting Supervisor Accounts and Reports Branch

  2. Budget Service Levels • Funds Control (Basic) • Document entry and reprogrammings • Maintaining system funds control • SF-132 support • Basic services plus MAX Reporting • MAX A-11 Data Entry (includes appendix text and appropriation language) • Full Service

  3. Funds Control • System funds control • Document entry • Reprogrammings • Continuing Resolution (CR) calculations and entries • SF-132 support • Basic research

  4. Funds Control + MAX Services • Obligations by program activity • Calculation of outlay rates • Obligation detail breakout (Sch. O) • FTE presentation (Sch. Q) • Balancing of accounts (MAX errors) • Appendix text and appropriation language upload

  5. Full Service • Formulation of annual budgets • SF-132 preparation and submission • Quarterly reviews (payroll and non-payroll items) • Payroll cost projections • FTE analysis/monitoring • OMB data call assistance

  6. ARC Predict • Budget Tool • Assists in formulating payroll amounts for fiscal budgets • Goal – 95% accuracy • Lessens need for external spreadsheets • Can be prepared by ARC budget staff using payroll assumptions provided by customer

  7. ARC Predict • Uses the most recent Payroll data and GL balances • The tool is designed to make a projection up to one future Fiscal Year • Able to copy existing projections to quickly create multiple scenarios

  8. ARC Predict • Payroll and Personnel Files • Received from one of the four E-Payroll providers (DFAS, NFC, GSA, NBC) • High Level Assumptions • Medicare tax rate • Social Security tax rate • Social Security limit • COLA percentage • Benefits percentage

  9. ARC Predict • Detail Assumptions • Promotions • New Hires • Terminations • Lump Sum Payments • Leave Without Pay • Miscellaneous Actions

  10. ARC Predict • Discoverer Reports • Compensation and benefits totals to date • Projected compensation and benefits through the end of the projected period • Breakout of projected amounts (ex: terminations, new hires, etc)

  11. New for FY 2011 • SF-132 support • Questions on format and amounts • Review prior to OMB submission • New descriptions on SLA documents • Financial Plans and Reprogrammings • Customized templates for submitting all budget loads and reprogrammings will be provided

  12. I-Clicker Questions

  13. What is your current process like for budget formulation ? We use excel (or other) spreadsheets to compute our annual budget We use an external system to formulate our annual budget Other

  14. Would you be interested in an automated formulation system that feeds directly into Oracle? Yes No

  15. If ARC developed and maintained a formulation system, which option would you prefer? I would like ARC’s budget shop to prepare the formulation exercises and present the results to my agency I would prefer to have access to the formulation system so I could enter my own assumptions and complete the exercises myself?

  16. Questions? Jaime.Harbour@bpd.treas.gov(304) 480-8457

More Related