Attachment B: Budget Guidelines

SBP Data Elements | Budget Specifics | Salary Information

SBP DATA ELEMENTS

Please note the following:

  • SBP allows you to simulate different budget scenarios with 2 distinct budget versions (A & B). Version A is considered the official version and will be routed for budget review and approval. Version B can be used to simulate different scenarios of your budget as needed. Copy/Swap functions facilitate moving data between versions A & B. Please be careful when running these functions, as the copy/swap functions will overwrite any existing data that is contained in the version that is being copied or swapped.

  • Actuals will be updated in SBP on a monthly basis during the budget development process. This update will occur after each R3 month-end close, consistent with Accounting System Administration published reporting dates. Year-end projections (fall/spring/working) will be reflected in certain SBP reports as updates are made throughout the budget development cycle.

  • Position budgets for filled positions have been pre-loaded based on the current actual salary and associated cost distribution for the incumbent. The payroll data loaded into SBP will be updated through December 4th. Subsequently, 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.

  • Changes in overtime eligibility, as announced by the U. S. Department of Labor earlier this year, will go into effect on December 1, 2016. Plans for accommodating the new rule are as follows: 

  • New positions created in SBP are assigned a budget-only position number that begins with the number 9. Officially, position numbers begin with the number 5 and are assigned by SAP when the position is created in HR. If a position was created last year in SBP and has not yet been created in SAP, you will have to re-create that position in SBP if the position is still desired. Additionally, budgets for vacant positions will need to be added manually into the layout with the associated cost distribution, FTE, and amount.

  • The position budgets for biweekly employees are calculated in SBP by multiplying the Current Hourly Rate x FTE % x 2,080 hours.

  • Fringes are set globally in SBP and calculate automatically for G/L accounts 610000, 610100, and 619900. The fringe benefit rates for FY18/19 are currently projected as follows:

Applied To
All Funds 6100
Applied To
Non-Govt. 6101
Total
Faculty/Staff
24.0
1.8
25.8
Biweekly
22.6
0.4
23.0
House Staff/Post Docs
17.5
-
17.5
Graduate
11.0
-
11.0
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.

  • Projected endowment income distributions have been pre-loaded into the recipient funds on G/L account 311100. The pre-loaded amounts are based on current units in the LTP as of 10/1/17 and reflect the projected income to be distributed for spend in FY18/19. Spending rates for financial aid endowment income distributions are projected to remain flat while non-financial aid endowment income distributions are projected to increase by 3%; however, this will not be available for spend until FY 19/20.  Also, keep in mind that the 3% one-time supplemental distribution benefitting FY 17/18 will not continue in FY 18/19.

BUDGET SPECIFICS

Please note the following:

  1. 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)). Other plant fund activity, i.e. 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 and therefore, 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, C4 (Budget Development Board Report) is included in the summary reports section of SBP. This report is in the same format as the financial reports distributed to the Board of Trustees and should be utilized to help consolidate and analyze your budgets in the same format as that which will be done by your Management Center budget offices.

  2. APPROPRIATIONS AND TRANSFERS – Please remember to consider all sides of your appropriations and transfers as you prepare your operating budget. Offsets should be entered using the “Filter Transfer/Offset” function in SBP. For additional information on how to complete this process, see the non-position section of the Budget Tool step-by-step section of the Budget Tool step-by-step guide.Recognizing that the transfer offset may occur outside of your department, management centers will confirm that both sides of all transfers are budgeted.

  3. SPREAD CODES – Budget spread codes are pre-populated in SBP and are based on current year spreads. The use of the ACT and 3YR spread codes in SBP will result in a spread that is based on the prior fiscal year close, since the current fiscal year is still in progres.

  4. MULTI YEAR PLANS – SBP 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.)

  5. SALARY INFORMATION – Please note the following:

    • SALARY POOL GUIDELINES FOR UNIVERSITY EMPLOYEES – The recommended salary pool for budget purposes for both exempt and non-exempt (non-bargaining unit) employees is 2.5%.  For bargaining unit employees, please refer to the current bargaining unit agreements, incorporating any anticipated step increases based on milestone achievements. 

    • PROPER USE OF G/L ACCOUNTS IN BUDGETING EMPLOYEE- Compliance with 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 60xxx: Payroll Costs G/L Accounts.

    • SALARY RANGES – Changes to existing pay ranges for FY18/19 are under consideration.  We will communicate range adjustments as soon as information is available.  Job code pay ranges are not loaded in SBP.  Please reference the following HR website for job code pay ranges.

    • UNDERGRADUATE STUDENTS - Payroll for undergraduate students (and any associated fringe benefits, if applicable) should be budgeted on the Student tab in SBP.  Fringe benefits for students should be manually calculated and 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 – Fringe benefits will be calculated for salaries budgeted on the g/l accounts used to pay RAs and TAs.  Any amounts budgeted on these g/l accounts will be charged an 11.0% fringe benefit rate.  Graduate student fringes will be automatically calculated and posted to g/l account 610700 in SBP.  Please contact your management center for instructions regarding budgeting tuition remission.

    • SALARY SETTING – Position budgets will be loaded into the SAP salary setting tool for use during the 7/1 salary setting process. 

  6. NON-SALARY INFLATION ASSUMPTIONS – No across the board inflationary increases are anticipated.  However, increases to general and administrative expense (g/l accounts 900200-901199) are currently targeted in the 3.5% range.  More information on space rent will be available in early January and will be communicated to rent payers accordingly.  Parking permit rates are projected to increase by 4%.  Please contact your management center with specific questions regarding any other non-salary budget inflations.

  7. SERVICE CENTER RECHARGE RATES – Rate increases may be necessary to help cover increasing costs of providing services.  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 GAP 200. 300, Service Center Administration.