Book Value Report

This program can be used to generate an inventory Book Value report for Rental equipment listing the current inventory value, or calculating the value as of a prior date.
It does not apply to sales parts.

The report sorts the rental inventory by Product Class Number and within each Product Class, the products are listed either in product number order or by product description.
Costs for Bulk items are not date adjusted.

The Status with Description returned on the spreadsheet is the Current 'Product Status' regardless of the reporting date.

To use this report to balance the inventory value to the G/L always use the "Owning Location" for the Select By option, and the "Tag/Product Detail" for the Detail To Print.

Note: For Bulk equipment the report can only be run effectively by "Owning Location" as this version of the report calculates the values for each Fixed Asset Tag based on the quantity and location associated with that tag.
The "Inventory Location" option cannot be run for Bulk products because the physical location count does not necessarily equal the tag location count, meaning that the cost values on the tag cannot be matched accurately to the physical location.

The prompts to generate the report are:

PRODUCTS TO INCLUDE

Select one of the following product options:

• Select Bulk Products to print the report for only the Bulk items in the selected range, and only on the report by "Owning Location".
• Select Non-Bulk Products to print the report for only the Non-Bulk items in the selected range, for either of the "Owning Location" or "Inventory Location" reports.
• Select Bulk and Non-Bulk Products to include all rental products in the range, and only on the report by "Owning Location".

FROM PRODUCT CLASS

Leave this field blank to include all rental classes, or enter the desired starting Product Class for the reporting range, or select one from the Product Class Search window.

TO PRODUCT CLASS

Leave this field blank to include all rental classes, or enter the desired ending Product Class for the range.

FROM DEPRECIATION CLASS

Leave this field blank to include all depreciation classes or select a starting class for the report from the drop-down list.
The classes are setup in Depreciation Classes and assigned to each product on the Fixed Asset Tag in Rental Inventory.

TO DEPRECIATION CLASS

Leave this field blank to include all depreciation classes or select an ending class for the report from the drop-down list.

ACQUIRED DATE CUT-OFF

The date used by this cut-off date filter, is the Acquired Date defined on each Fixed Asset Tag of the rental products.
Accept today's date, or enter a preferred acquired cut-off date for the report, so that products purchased later than this date are excluded from the output.

PRINT AS OF PRIOR DATE

Uncheck this box to generate the output as a 'snapshot' of the information currently captured on the Fixed Asset Tags.
To include a product the Original Quantity on the Tag and the Quantity On Hand on the Tag cannot currently be zero.
When the prior-date option is not selected, the Depreciation Class & description are only printed on the detailed spreadsheet, and even if the Depreciation Class is used as a selection filter, because of space restrictions it does not print out on the report output.

Check this box to recalculate the report values as of an earlier date.

PRIOR DATE CUT-OFF

Enter the preferred prior date for the report calculations.
To include a product the quantities on the Tag cannot be zero as of this cut-off date.

Note: When the report is generated for a prior date, the detailed report is always printed by Owning Location, and the Alternate Depreciation option is disabled.

Prior Date Calculation Formulas:

• Quantity on the Tag at the time of the Prior Date Cut-off and is reconstructed as follows:
  Current tag quantity - (warehouse receipts after cut-off date) + (rental to sale transfers after cut-off date) + (branch transfers after cut-off date) - (sale to rental transfers after cut-off date) + (disposals after cut-off date)
• Unit Cost is obtained from the cost adjustment records (RSCA) which include additions by cut-off date, or the current average cost if there are no cost adjustment records.
  
  • For non-bulk and non-multiple tag bulk products, the current average cost is the average cost on the product file (RSPF).
  • For multiple tag bulk products the current average cost is obtained from the tag by the following formula:
    Current cost = (net original cost) / (current on hand) = (original cost - accumulated disposals - accumulated transfers + accumulated additions) / (original quantity - quantity sold - quantity transferred)
• Total Cost = Quantity * Unit Cost
• Accumulated Depreciation is the amount of depreciation at the time of the cut-off date so that any Depreciation after the cut-off date is ignored.
• Accumulated Additions is the value of additions at the time of the cut-off date, and any Additions after the cut-off date are ignored.
• Book Value = Total Cost - Accumulated Depreciation

SELECT BY

Select one of the following product location options:

• Select Owning Division to select and sort products using the division on each Fixed Asset Tag, as opposed to the physical inventory location.
  This is useful when balancing inventory value to the G/L inventory accounts.
  • For Non-Bulk items, the tag number and serial number will print, with the associated cost and accumulated depreciation from that fixed asset tag as defined in Rental Inventory.

  • For Bulk items, each tag will list separately showing the quantity on the tag, the cost and accumulated depreciation on that tag.

    ("Qty" * "Avg Cost") less "Total Accum Depreciation" = "Total Book Value"

• Select Inventory Division to select and sort Non-Bulk products by the actual physical location

  • For Non-Bulk items, the tag number and serial number will print, with the associated cost and accumulated depreciation from that fixed asset tag as defined in Rental Inventory.

  • This reporting selection is not available for Bulk products, as the cost values on the tags cannot be accurately matched to the quantities for the inventory locations.

  • This option is not provided when using the Print as of Prior Date calculation.

DETAIL TO PRINT

Select one of the following report options:

• Select Tag/Product Detail to print report details.
  • If the report is to be printed by 'Owning Location', the details for each product are printed from the Fixed Asset Tag information.
  • If the report is to be printed by 'Inventory Location', the details are printed from the product.

• Select No Detail to just print the summary for each Product Class.

DIVISION, "ALL" OR "SEL"

• Type ALL to include all divisions in the report.
• To print the report for a single division, leave this field blank for the Head Office Division, or enter a specific division code, or select a division from the drop-down list.
• Type SEL to select several specific divisions or divisions by inventory region to include in the report, as outlined in Division Select By Region.

On the Report output, each division will print on a new page with division totals.
On the Excel output, printing each division on a new tab of the spreadsheet is controlled by the One Sheet Per Division selection option below.

Note: Only locations for which the operator has access as determined by Divisional Restricted Views assigned to the operator, will be allowed.

NEW PAGE PER CLASS

Check this box to start a new page for each new Product Class with a sub-total for each Product Class.
Uncheck this box to continue printing all Product Classes together with a sub-total for each Product Class.

This option only applies if Tag/Product Detail is to be printed.

SORT OPTIONS

Select one of the following sort options:

• Select Product Number to list the products by product # order within each Product Class.
• Select Description to list the products alphabetically by description within each Product Class.

ALTERNATE DEPRECIATION METHOD

Uncheck this box to use the standard Depreciation stored on the Fixed Asset Tags in Rental Inventory.
Check this box to use the Alternate Depreciation stored on the Fixed Asset Tags in Rental Inventory.

This option is not provided when using the Print as of Prior Date calculation.

INCLUDE NON-INVENTORY ITEMS

Check this box to include equipment that is flagged as NOT Inventory in Rental Inventory.
Uncheck this box to only include equipment that is flagged as rental inventory in Rental Inventory.

YEARLY TOTALS BY DEPRECIATION CLASS

Check this box to also print a separate report with the yearly subtotals for equipment purchased in the last four years, for each depreciation class.
Uncheck this box to suppress the yearly subtotals.

REPORT OPTIONS

This value defaults to the operator preference as defined in Operators.
Select one of the output options to Print a report or export the data to Excel as outlined in Report Options.

ONE SHEET PER DIVISION

This option only applies to the Excel output.

Check this box to print data for each division on a new tab of the spreadsheet.
Uncheck this box to generate the data on one spreadsheet to enable easier company-wide consolidation of totals.

This option does not apply to the Report output, as each division will print on a new page with division totals.

Finished?

Click the ACCEPT button to begin printing the report, or CANCEL to abort.