BPS allows you to simulate different budget scenarios with 3 distinct budget versions (A, B, & C). Version A is considered the official version and will be routed accordingly for budget review/approval in the workflow process. Versions B&C are working copies; you can simulate different scenarios of your budget as needed. Copy functions facilitate copying data between the different versions. Please be careful when running these functions, as the copy functions will overwrite any existing data that is contained in the version that is being copied to.
Actuals will be updated in BPS on a monthly basis during the budget development process. Fall and spring year-end projections will be updated around November 20th and February 19th, respectively.
The payroll data loaded into BPS will be updated through the month of November. Beginning December 1st, you will need to manually update for any changes to payroll (e.g. rate increases, new hires, terminations, etc.) that occur during the budget development process. The position management number will be used to link the position budgets in BPS to the SAP July salary setting tool.
New positions that were created last year in BPS were assigned a BPS-only position number that began with the number 9. Valid position numbers begin with the number 5, and are assigned by SAP when the position is created in HR. There is no link between the 9xx BPS-only position number and the 5xx position number that is created in SAP. However, each management center attempted to synch up the new 9xx BPS-only positions with the new 5xx positions that have been created since last year’s budget development cycle. In those instances where the new position could be identified, the position budget from the 9xx BPS-only position was loaded to the current year budget for the new 5xx position. If establishing the link was not possible, there will be no current year position budget on your newly created 5xx position numbers. If a position was created last year in BPS and has not yet been created in SAP, you will have to re-create that position in BPS again this year if the position is still desired.
The position budgets for biweekly employees will be calculated in BPS by multiplying the Current Hourly Rate x FTE % x 2,080 hours.
Fringes are set globally in BPS and calculate automatically for G/L accounts 610000, 610100, and 619900. The fringe benefit rates for FY 10/11 are as follows:
Applied To
All Funds 6100
Applied To
Non-Govt. 6101
Total
Faculty/Staff
24.0
1.9
25.9
Biweekly
22.9
0.8
23.7
House Staff
17.3
-
17.3
Graduate
8.4
-
8.4
Students
7.7
-
7.7
The attrition provision of 2.5%, and associated fringes, calculates automatically when your biweekly payroll G/L accounts total $80,000 or greater. For information on how to restore the attrition provision, please contact your management center.
Distributed and general and administrative expenses (G/L accounts 900100-901200) have not been pre-loaded for FY 10/11. While we don’t anticipate the overall costs for G&A and distributeds (e.g. police, housekeeping, groundskeeping, etc.) to increase, we do anticipate an increase in the costs of utilities. For more specific help on how these will impact space rent you can contact the Office of Budgets & Analysis.
Projected FY10/11 endowment income distributions have been pre-loaded into the recipient funds on G/L account 310100. The pre-loaded amounts for non-financial aid endowments are based on current units in the LTP as of 10/1/09 and reflect the projected income to be distributed on June 30, 2010 for spend in FY 10/11. For financial aid endowments, the pre-loaded amounts are based on current units in the LTP as of 10/1/09 and reflect the projected income to be distributed in FY10/11.
Job code ranges are not loaded in BPS. Please reference the following HR website for job code pay ranges.
BUDGET SPECIFICS
Please note the following:
Service Center Recharge Rates Federal reimbursement regulations require us to follow very specific guidelines for administering Service Centers and related pricing/charge-back mechanisms. For more information, please refer to Attachment C.
All Funds
As in the past, departments are required to budget operating activity across all funds, which include: current unrestricted (1xx), restricted (3xx), allocated (4xx), quasi-endowment (66X), and plant funds used for operating activities (i.e. capital renewal (74x), indebtedness (769x) funds). Other plant fund activity, e.g. construction projects (72X) and deferred maintenance (75X) should be budgeted separately as part of the capital budgeting process. Departments are not required to build the budgets for their non-current unrestricted activity on each individual fund, rather an aggregate approach is allowed. However, please remember the board reports are consolidated at the G/L account summary level. The all funds budgets should be built with this in mind, in order to ensure the consolidated financial reports are as accurate as possible.
For your convenience, a set of all funds board reports are included in the summary reports section in BPS. These printer friendly (Cognos) reports are in the same format as the financial reports distributed to the Board of Trustees. These reports should be utilized to help consolidate and analyze your budgets in the same format as will be done at your Management Center budget offices.
Appropriations And Transfers
Please remember to consider all sides of your appropriations and transfers as you prepare your operating budget. Offsets should be entered on the Spreads and Appropriation Offsets tab in BPS. As we continue to analyze and report on an all funds budget for the institution, it's critical that we capture both sides of all intra-company transfers so that we can eliminate the impact of any such transfers on a consolidated basis for the University.
Spread Codes
Budget spread codes are included in BPS and are based on current year spreads. The use of the ACT and 3YR spread codes in BPS will result in a spread of 1/12th in BPS, since the current fiscal year is still in progress. The budget spreads will be recalibrated once the fiscal year ends and the corresponding budgets will be re-loaded into SAP at that time.
Multi Year Plans
BPS has been set up to allow all departments to complete up to 10 years of out year planning. Although multi-year planning is not an institutional requirement, it is required for some departments. (Please refer to your management center instructions for specific information.)
Inflation Assumptions Based on the current economic conditions, cautious prudence should be followed when considering inflationary increases for all non payroll related budgets. Overall, we anticipate that current cost savings initiatives should result in lower non-personnel expenses.
Salary Information
Please note the following:
Proper Use of G/L Accounts in Budgeting Employee Effort Federal OMB Circular A-21 requires precise assignment of G/L accounts in order to properly define each employee’s effort. Please ensure that employee salary and wages are budgeted on the appropriate G/L account. For specific help, refer to the appropriate G/L account.
Salary Pool For University Employees
The recommended salary pool for both exempt and non-exempt (non-bargaining unit) employees is under consideration. We will communicate the pool as soon as information is available. For bargaining unit employees, please refer to the current bargaining unit agreements.
Salary Ranges Changes to existing pay ranges for FY 10/11 are under consideration. We will communicate any such changes as soon as information is available.
Undergraduate Students
Payroll for undergraduate students (and any associated fringe benefits, if applicable) should be budgeted on the Student tab in BPS. Fringe benefits for students should be budgeted on G/L account 610500. Fringe benefits (FICA at 7.7%) should only be budgeted on Duke Students working during the summer term who are not registered for classes. For non-Duke students (G/L account 609700), fringe benefits should be budgeted whether they are in class elsewhere or not.
Graduate Students
As in the current year, fringe benefits will be calculated for salaries budgeted on the g/l accounts used to pay RA’s and TA’s – 601200 and 601400, respectively. Any amounts budgeted on these G/L accounts will be charged an 8.4% fringe benefit rate. The fringes will be automatically calculated in BPS and posted to G/L account 610700 for all effected cost objects.
Salary Setting
Position budgets are loaded into the SAP July salary setting tool based on the position management number; however, position master data updates will stop on November 30. Please keep this in mind when budgeting for new positions in BPS. If you are creating a salary line item for a new position and you know the position management number, please enter the position management number into the ‘Notes’ field on the salary line item.
