Resource Value Report

The Resource Value report lists your resources and their current or depreciated value. You can generate the report for your district, a specific site type, or an individual site. Include all of your items or only items of certain resource types or status, purchased using specific funds, and/or costing over or under a specified amount.

Resource Value Report Types

  • The Current Collection Value report is a snapshot of your collection value at the time you generate the report. Destiny calculates the values from the purchase prices of the included items; however, it does not factor in depreciation.
  • The Depreciated Collection Value report is a snapshot of your collection value at the close of the selected fiscal year and includes any depreciation information for your items.
    If you chose to depreciate your items, depreciation is factored into an item's value at the end of each fiscal year. Annual depreciation represents the decrease in value of the item for each fiscal year.

To generate a report:

Important: Textbook auto-conditioning is ignored.
  1. Select Reports > Resource Reports.
  2. Under Catalog -- Resources & Items, click Resource Value.

  3. If you are running the report at the district, use the For drop-down to select the district, a site type, or an individual site.

  4. Choose to generate either a Current Collection Value or Depreciated Collection Value.

    Note: The itemized version of this report shows the acquisition date for both of these values. If no acquisition date exists, the date reflects when the item was created.

  5. If running a Depreciated Collection Value report, enter a four-digit year for the report. You can enter only a fiscal year that has closed.

    Note: If the month shown is incorrect, your Destiny Administrator can change it on the Edit District page.

  6. By default, the report includes all items in Resource Manager. To limit the report to items that are:

    • Resource Types: Of one or more types of resources, click Update.
    • Funding Source: Associated with certain funding sources, click Update.
      If you want to include resources that do not have a funding source, make sure to select the Undefined checkbox.
      You must select at least one checkbox.
    • Status: Of certain statuses, ensure the checkboxes are selected. To exclude items with certain statuses, deselect those checkboxes.
      You must leave at least one checkbox selected.

      Notes: 

      • Both the Current Collection Value and the Depreciated Collection Value reports always exclude On Order items.

      • Only the Depreciated Collection Value report includes Retired items (and only if the item was retired in the same fiscal year that it was acquired).

      • Both reports always exclude software media of any Status.

    • Purchase Price: Of a specific purchase price, select Greater than or equal to or Less than and enter an amount.
      If you select No Purchase Price, the report includes only those items without a purchase price.
  7. Use the Group by drop-down to choose how to organize the report.
  8. From the Show drop-down, select whether you want a summary or itemized report.

    Notes:

    • An itemized report shows the value and age of your resources.
    • If you are generating this report at the district, you can select Summary Only or Details.
    • The summary, itemized, and details reports are generated in both PDF and XML formats.
  9. Select the resource type subgroup level from the Roll-up Values to the drop-down.
    To verify that you selected the correct roll-up level, click Preview.
    Note: This is not available for an Itemized report.
  10. Click Run Report.
  11. When Report Manager opens, click View to open the summary. Otherwise, click the PDF or XML link in Report Manager.

Current Value Calculation

Destiny calculates the current value from the purchase prices of the included items.

For this report to accurately reflect the value of the resources in your collection, there must be data in the item record's Purchase Price field.

Destiny excludes items without data in the item record's Purchase Price field from this report. Also excluded are items with a status of On Order or Retired, as Destiny does not consider these items part of your current collection.

Depreciated Value

Destiny calculates annual depreciation using the following:

  • Salvage Value
  • Purchase Price
  • Depreciable Life

For any item record without an amount in the Salvage Value field, Destiny automatically assigns 0 (zero) to that field and assumes it has no value after being fully depreciated.

For Destiny to calculate depreciation, items must have data in the Purchase Price and Depreciable Life fields.

Note: You can add a Purchase Price and a Salvage Value for an item on the item's Edit Item page. You can define the depreciation information on the resource type's Edit Template page.

Destiny uses the following equation to determine an item's annual depreciation:

  • Purchase Price – Salvage Value / Depreciable Life = Annual Depreciation.

 

An item's value depreciates until one of the following occurs:

  • Its value reaches 0 (zero).
  • Its value equals the price entered in the Salvage Value field.
  • The item has depreciated for the number of years entered in the Depreciable Life field.
  • The item is retired.
  • The item is deleted from your collection.


Items do not realize full annual depreciation in the fiscal year they are acquired or in the fiscal year they are retired.
To accommodate this, Destiny uses a Depreciation Convention to determine the amount that items depreciate in those situations. The available conventions are:

  • Half-Year: The item's value depreciates by one half-year.
  • Mid-Quarter: The item's value depreciates by one half-quarter for the quarter that the item was acquired or retired, plus the total amount for each additional quarter that the item is active in the collection.
  • Mid-Month: The item's value depreciates by one half-month for the month that the item was acquired or retired, plus the total amount for each additional month that the item is active in the collection.

Roll-up Values

Roll-up Values let you determine the level of detail in your report. Rolling up the values to a certain level combines the values of the resources on any lower levels and reports them at the level you select. This option does not limit the items that appear on the report; it determines to which level your information rolls up.

For example, assume you have the following hierarchy for your computers:

  • Computers > Desktops
  • Computers > Desktops > Workstations
  • Computers > Portable
  • Computers > Portable > Handheld
  • Computers > Portable > Laptop
  • Computers > Server

Rolling up your values to the second level would display the total values for all Computers.

Rolling up your values to the third level would display the separate values for your Desktops, Portables, and Servers.

Summary Report Contents

The Summary Only of the Current Collection Value report contains the following:

  • Each fully qualified Resource Type (to the selected roll-up level), each Department, or each site, depending on your selection in the Group By list.
  • Its total quantity of items
  • The total purchase price of the items

The Summary Only of the Depreciated Collection Value report contains the same information as Current Collection Value, plus columns for the following:

  • Total salvage value of the items
  • Total depreciation for the selected fiscal year
  • Total accumulated depreciation
  • Total current depreciated value

At the bottom of each report are the grand totals for the quantity, price, and values.
The last page of the report lists the options you selected when generating the report.

Detailed Current Collection Value Contents

If you group by Resource Type:

  • Each fully qualified Resource Type (to the selected roll-up level)
    • The name of each site owning items of this resource type
    • Each site's total quantity of these items
    • Each site's total purchase price of these items
  • Total quantity and purchase price for this resource type

If you group by Department:

  • Department name
    • Each fully qualified Resource Type (to the selected roll-up level)
      • The name of each site having that department owning items of this resource type
      • Each site's total quantity of these items
      • Each site's total purchase price of these items
      • Total quantities and purchase prices of these resource items
  • Total quantity and purchase price for the department

If you group by Site:

  • The name of each site
    • Each fully qualified Resource Type (to the selected roll-up level)
      • The name of each department owning items of this resource type
      • Each department's total quantity of these items
      • Each department's total purchase price of these items
      • Total quantity and purchase price of these items at the site.

At the bottom of the report are the grand totals for both the quantity and purchase prices.

The last page of the report lists the options you selected when generating the report.

Itemized Report Contents

The Itemized version of the Current Collection Value report contains the following:

  • Groups for each Resource Type or department, depending on your selection in the Group by drop-down.
  • If you selected Department from the Group by drop-down, groups for each Resource Type.
  • A list of every item meeting the criteria:
    • Resource Type Description
    • Barcode number
    • Purchase price

The Itemized version of the Depreciated Collection Value report contains the same information as Current Collection Value plus the following columns for each item:

  • Salvage value
  • Depreciation for the selected fiscal year
  • Accumulated depreciation
  • Current depreciated value

At the bottom of each report are the totals for all the columns and the number of items listed.

The last page of the report lists the options you selected when generating the report.