Budget Projection by Collection
The Budget Projection by Collection tool generates a projected budget breakdown by collection 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.
If you create custom roll-up collection categories, Decision Center's calculations incorporate the Average Price per Copy that you specify for each collection.
The Budget Projection by Collection 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.
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:
Collection
The collection to which the row's data applies.
The Collection names reflect the collections configured on the Collection page of the Decision Center Admin section.
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).
Avg Price per Copy
The average per-copy price of the item. The library specifies this value for each collection using the Collection Code Category roll-ups in Decision Center's administration section.
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
If you create custom roll-up collection categories, Decision Center's calculations incorporate the Average Price per Copy that you specify for each collection.
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 Collection tool has no remedy filters, but you can modify it by using the Override check box and manually entering a budgeted amount for the corresponding row.
