How does the asset inventory schedule work? Detailed data organization and aggregation
RFID Knowledge

How does the asset inventory schedule work? Detailed data organization and aggregation

PublishedShanghai Zejie Smart Technology Co., Ltd.

The core usage of the asset inventory schedule is to register each asset in a single field, then to summarize it by department, category, location or status. The detailed record is responsible for answering “what, where and who holds each asset”, and the summary results are responsible for presenting the quantity and amount, which should be linked to the asset number.

Element 1: Harmonization of fields before registration on a case-by-case basis

The table is preceded by a calibration of the field, avoiding that the same information is written in different formats. Common fields include: asset number, name of asset, type, specification model, unit of measure, quantity, unit price, original value, date of purchase, department of use, place of deposit, custodian, status and inventory results. Asset number should be unique; if no number, it can be numbered as per internal rule on a temporary basis and then adjusted.

Fields should support follow-up checks and statistics. For example, the " repository place " is used as much as possible to the building, floor or storage level; the " use status " option is used in a uniform manner, such as for idle, maintenance, scrapping, etc., and do not mix the equivalent of " normal " available " , such as " active " . The value field indicates units, dates are in a consistent format.

Element 2: Take stock of results by “one line per row”

Each line corresponds to an asset that is independently identifiable; the same model, multiple assets in the same location, should also be subject to a management decision as to whether to register individually or batchally. If a single item needs to be traced, the responsible person or maintenance record should register individually; if a batch is managed by lot and the individual case difference does not affect management, the quantity of the batch may be recorded and the batch identifier maintained.

The number of discrepancies can be calculated by using the " physical count -- number of accounts " . When a change in location or custodian is detected, the verified information is recorded and the date of the inventory is indicated so that the original information cannot be traced if it is directly overridden.

Element 3: Reduce detail errors with filtering and verification

After entering, check whether the asset number is duplicated, and whether the number and amount are valid or not the date exceeds a reasonable range. The fixed options such as category, department, status are suitable for setting down the drop-down list; the asset number can be checked for duplicate values. If you fill out the inventory by more than one person, it is recommended that the field description and rules be harmonized and that the version and update time be agreed.

When Shanghai Select Technologies, Inc. collates such data, it can place "Definition of fields, enter rules, deal with anomalies" in the same operating note, so that the filers and reviewers are treated with the same calibre. For example, when accounts do not match directly, they retain differences and verification results to facilitate subsequent re-entry.

Element 4: Summary by management dimension and cross-checking summary calibre

Once the detailed data is sorted, it can be arranged by asset class, department, location of storage or status. The sum is aggregated using a count or sum, and the amount is aggregated using a clear field such as the original value; if there is an empty value, duplicate records or unit not in agreement, the summary results may be distorted. The matrix should indicate the statistical date, filter conditions and the amount of the amount, avoiding a comparison between different ranges.

Summarizing dimensions Elements suitable for viewing Check focus
Asset class Number and original value of assets by class Harmonization of category names
User Number and amount of departmental custody Departmental attribution by same time point
Location of storage Regional distribution of assets Whether the location field is filled in to the agreed level
Usage Status Number of active, idle, maintenance etc. Consistency of status definitions

Point 5: Once aggregated, the details are identified and the results can be traced

Once the aggregation is completed, the number of classifications is reconciled with the total amount in detail; the sum is also reconciled with the amount in the statistical field. For the category or sector where the difference is greater, the original record is checked for duplicate numbers, the missing, the filtering conditions and unit conversions are checked. Save the details version, consolidate the calibre and the discrepancy processing records, and only change in the next round of inventory counts, instead of leaving a single total.