Budget Projection by Fund
The Budget Projection by Fund tool generates a projected budget breakdown by fund for a specified budget amount. The resulting recommendations are based on expenditures from the selected fiscal year and for the accounting unit assigned to the user's login.
The Budget Projection by Fund tool includes the following components:
Initial Filters
You can set the following filters to configure this tool:
Location
The Location filter options reflect the branch locations recognized by your library system. The data is limited to the Owning Locations you select. You can select any number of available locations, but you must select at least one to run the tool. The default is All Locations.
Locations
To determine the location, Decision Center first identifies the location code (shelf code) in the item record. The system then looks up the location code in the Locations Served file and uses the associated branch location code. (For more information on the Locations Served table, see the Sierra WebHelp or the Millennium Innovative Guide & Reference.) The descriptive name associated with the branch location code comes from the Branches file. (For more information on the Branches table, see the Sierra WebHelp or the Millennium Innovative Guide & Reference.) If the system cannot find the location code or the branch name in the Locations Served file, Decision Center displays the location code that appeared in the item record.
Physical Format
Limits the data to the physical formats you select. You can select any number of available formats, but you must select at least one to run the tool. The default is All Physical Formats.
The Physical Format filter options reflect the formats configured on the Physical Format page of the Decision Center Admin section.
Collection
Limits the data to the collections you select. You can select any number of available collections, but you must select at least one to run the tool. The default is All Collections.
The Collection filter options reflect the collections configured on the Collection page of the Decision Center Admin section.
Limits
Budget
The fiscal year budget amount applied to the results.
Calculate Based on FY Ending
A prior fiscal year to use as the template for projections. Decision Center uses the specified fiscal year for both the circulations and the expenditures metrics.
Data Columns
The following data columns appear in the results:
Fund
The name of the fund.
Fund Names
Decision Center recognizes all valid funds on your system. To determine the Funds for reports, Decision Center takes the fund code from each order record, and then finds the corresponding descriptive name in the Fixed-length Fields table. (For more information on fixed-length fields, see the Sierra WebHelp or the Millennium Innovative Guide & Reference.) If no descriptive name exists for a valid code, Decision Center uses the fund code as the column heading. If the fund code does not exist in an order record, the system uses the heading Unknown.
Selected Year's Expenditures
Total expenditures during the specified prior fiscal year for the corresponding call number range.
Expenditures Data
Decision Center uses the PAID date/date posted to calculate amounts by fiscal year. Thus, if the fiscal year begins on 1 July, payments posted on 1 July count toward the new fiscal year. Payments posted on 30 June count toward the previous fiscal year. This attribution of payments is independent of when the library performs its fiscal close procedure. In some cases, Sierra (or Millennium Acquisitions in Funds mode) might apply these payments differently. Consequently, it is possible to find discrepancies between Decision Center and your Sierra or Millennium system. To avoid such discrepancies, do not make or post any payments after the first day of the month of the new fiscal year until after you complete the fiscal close procedure.
Multiple Accounting Units
For libraries with multiple accounting units, the tool data you view reflects the accounting unit associated with your login.
% of Total Expenditures
The amount spent, for this tool row, as a percentage of total expenditures.
Suggested Budget
The amount allocated to the associated fund.
Override (check box)
Check this box to manually enter the amount (Calculated Amount) to be budgeted for the row. When you choose Recalculate, Decision Center adjusts all other recommendations to account for the override.
Remedy Filters
The Budget Projection by Fund has no remedy filters, but you can modify the results by using the Override check box and manually entering a budgeted amount for the corresponding row.
