Budget Projection by Subject
The Budget Projection by Subject tool generates a projected budget breakdown by call number range for a specified budget amount. The resulting recommendations are based on circulation or expenditures from the selected fiscal year and for the accounting unit assigned to the user's login.
The Budget Projection by Subject 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.
Call Number Range Table
The Call Number Range Table filter options reflect the statistical categories (SCAT) tables configured by your library system. The data is limited to the tables you select. You can select any number of available tables, but you must select at least one to run the tool. The default is All Call Number Range Tables.
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:
Call Number Range
The associated call number range.
Call Number Ranges
Call number ranges reflect data from your library's statistical categories (SCAT) tables. These tables group call numbers in up to 9,999 different categories. Each category consists of one or more range(s) of call numbers (for example, 200 - 299 or PS1100 - PS3500). Note that call numbers can be numeric (Dewey) or alphanumeric (Library of Congress).
Each library creates its own SCAT tables so that tools provide the call number breakdown that the library wants. For more information on the SCAT table, see the Sierra WebHelp or the Millennium Innovative Guide & Reference.
Selected Year's Circulations
The total number of circulations (checkouts and renewals) during the specified prior fiscal year for the corresponding call number range.
% of Total Circulations
The item's circulation as a percentage of total circulation (checkouts and renewals).
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 to be spent based upon the tool's calculations. This amount is related to the item's relative circulation or prior expenditures, depending upon the metric you select in the Choose Metric filter.
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
You can apply the following filter to modify the results:
Choose Metric
Specifies the metric used to calculate the results- circulations or expenditures.
