OPERATING PLAN - SALARY PROJECTION MANAGEMENT


Within the BudCast Operating Plan a user can utilize the Salary Projection View to revise, remove, or add future forecasted salary expenses. If a position receives a pay increase/decrease, becomes vacant, or if a new position is created are examples of situations when this module could be utilized to create a more accurate projection. These forecasted salary expenses will carry through to the Projection Reports.

 Navigating to the Operating Plan. Select the  button from the module launcher screen after log-in to navigate to the Operating Plan. If you are already logged in, you can select the Operating Plan    button from the task bar located on the right-hand side of the screen.


  Select Versions>Salary Projections>Projection.  After entering the module you will arrive at the following screen. Click the  or   buttons on the tree in the selection pane to get to the level ‘Projection’. Double click on the button to open the Salary Projection Management Version.

 

   Select the View.  The user has the ability to choose four different Views from the drop down menu. Each view drives a different set of searchable data. In this example the user has selected the ‘by Employee’ View.


 Select the Employee/Department.  After selecting the View, the user can use the drop down menu to select the employee/ARSP/Cost Center from the list. To search for a specific employee instead of scrolling through the list; click the  button and type the employee name or cost center. Click on the selection to load the related data.

Note: The user will only be able to see the data for which they have access. If the user has access to the School of Social Welfare’s cost center, but an employee is split funded with the Psychology department they will only be able to see the funding associated with the School of Social Welfare.


 

 

 

 Selecting from the University Tree. For the Views by Position/Cost Center/Fund; the user may select one or multiple levels of the University Tree. In this example the user has selected the View ‘By Department/Position’. The user clicked the Search button  and searched for the Cost Center beginning with ‘2531’. 


 

 Drill Down Order. Once fully loaded the by Department/Position view in this example provides salary budget, actual, and forecast data by Position Number, Fund Code, and Cost Center.

 Expand & Collapse Data. Like all data views in BudCast, drill-down and collapse icons are available to view different levels of the data.

  1. The  button expands all rows in the selected View out to the lowest drill-down level.
  2. The button expands all rows in the View out to the next drop-down level.
  3. The  button expands the selected row out to the lowest level. An example of a row in this View would be the blue row labeled 'Allocated Salaries'.
  4. The  button drills down to the transaction level to open the transaction window in the bottom half of the screen.
  5. The  button collapses all rows in the View to the lowest level.

 White Editable Cells. To edit any salary forecasts, users must drill-down to a row/level that represents a unique Cost Center/Fund/Position Number combination. White cells are editable, while all other cells cannot be changed. If another user logged into the same worksheet first; the second user will be locked out and no white editable cells will be available.

  Pay Period Detail. Clicking on the final level of drill-down allows users to see transactions by pay period. To make manual edits to increase or decrease pay period amounts; enter these debits or credits on the second row. The first row of data is updated automatically by DEMIS.


 Anticipated Salaries.  Each unique combination of Cost Center/Fund will have a position line labeled “999999 Anticipated Salaries”. This allows users to forecast anticipated positions that may not have been entered previously into the working budget.

  1. Drill down to the Transaction Level. Click the  drill down button to drill down to the transaction level.
  1. Add a description. To edit the description of an anticipated position, double click on the highlighted cell and key a meaningful description.
  1. Enter future salary information. Enter the future salary amounts by pay period in the white editable cells.
  1. View the effect on the forecast. As forecasted salary details are entered into each pay period column, the summarized forecast amounts are populated in the Projection View Report above.

 

Note: When the position is created and the employee is officially hired in the HR-Pay system; the user will need to remove any projected expenses that have been keyed into the ‘Anticipated Salaries section to avoid duplicating the projection in both the position section and in the anticipated salary section.

 

 


 Vacant Positions.  Users are able to edit positions that have become vacant during the year to forecast if the position is re-hired. An example of this would be if a position has been vacated, but the position will be rehired in pay period 17.

  1.  Drill down to the Transaction Level. Click the drill down  button to drill down to the transaction level.
  1. Add a description. Manual edits can be made starting on the second row. To edit the description click on the highlighted cell in the second row and key a meaningful description.
  1. Enter future salary information. Enter the future salary amounts by pay period into the white editable cells. In this example the user can see that the position has become vacated in PP 08. The user believes an individual will be hired in PP 10 so on the second row they enter future salary information starting in PP 10.
  1. View the effect on the forecast. As forecasted salary details are entered into each pay period column, the summarized forecast amounts are populated in the Projection View Report above.

 

Note: When the position is created and the employee is officially hired in the HR-Pay system; the user will need to remove any projected expenses that have been keyed into the ‘Anticipated Salaries section to avoid duplicating the projection in both the position section and in the anticipated salary section.

 

 


 

 Vacant Check Box.  A vacant column allows users to identify/confirm all vacant positions that exist in the ARSP. Reports exist that allow analysis and isolation of vacancies.

 

 Adjustments.  If the user prefers, instead of entering forecasted amounts pay period by pay period, a total manual adjustment can be made in the Adjustments column.

Note: A negative number would indicate a credit or reduction of expense; inversely a positive value would equal a positive expense. In this example the user is stating that there will be a $20,000 forecasted expense.

 

 Save Payroll Projections.  When all changes are made make sure to click the  save button located on the task bar at the top of the window to save all projections. If the user forgets to save before exiting they will be prompted to save the page before navigating elsewhere.


One of 34 U.S. public institutions in the prestigious Association of American Universities
44 nationally ranked graduate programs.
—U.S. News & World Report
Top 50 nationwide for size of library collection.
—ALA
23rd nationwide for service to veterans —"Best for Vets," Military Times
KU Today