The Stock Variance Report provides a statistical inventory price variance and deviation analysis view within TUHUND.
The report is designed to help organisations analyse variation in inventory pricing, evaluate pricing consistency and identify products with significant value deviations across inventory transactions. The analysis may be performed using either financial value or actual cost calculations.
The report can be accessed through:
Inventory → Reports → Variance
Purpose of the Report
The report is used to analyse inventory price variation, evaluate pricing consistency and identify products with abnormal or significant valuation deviations.
It is commonly used by inventory teams, finance teams, procurement teams and management personnel for inventory valuation analysis and pricing variance monitoring.
Report Interface
The report interface contains the following sections:
|
Section |
Description |
|
Entity Selection |
Filters report by organisation, company or branch |
|
Show Selector |
Filters inventory categories |
|
Analyse Selector |
Defines variance calculation basis |
|
Sort By Selector |
Defines statistical sorting configuration |
|
A–Z / Z–A |
Controls sorting order |
|
Period Selector |
Defines reporting period |
|
Minimum Filters |
Filters statistical deviation ranges |
|
Category Selector |
Filters inventory categories |
|
Search Box |
Searches inventory records |
|
Report Grid |
Displays statistical variance analysis |
|
Export Button |
Exports report data |
The ENTIRE ORGANIZATION selector functions similarly to other reports and allows users to generate variance analysis reports across accessible organisations, companies or branches.
Filtering and Analysis Options
The Show selector supports:
-
Only Products
-
Only Spares & Accessories
-
Virtual Products
The Analyse selector supports:
-
Financial Value
-
Actual Cost
Financial Value represents the actual inventory transaction value or price-tag value associated with the item.
Actual Cost represents the total inventory cost including additional operational expenses such as transportation charges, commissions, repair costs or related inventory expenses.
The report also supports category filtering, variance range filtering and inventory search functionality.
Statistical Analysis Options
The Sort By selector supports multiple statistical and inventory analysis parameters including deviation calculations, amplitude analysis, pricing ranges, central tendency measurements such as mean, median and mode, inventory quantities and product-related fields like product name, model, brand, attributes and country of origin.
These options allow users to analyse inventory price behaviour and valuation consistency using different statistical perspectives.
Report Structure
The report is displayed as a structured statistical variance analysis grid where each row represents a product or inventory item.
Depending on the selected configuration, the report may display product information, quantity, minimum and maximum values, mean value, range, median, mode, amplitude values, relative deviation and standard deviation.
The report statistically analyses inventory pricing variation across transaction records and helps organisations identify abnormal pricing patterns or inconsistent inventory valuations.
Statistical Interpretation
The report uses statistical variance calculations to evaluate inventory pricing consistency.
Minimum and Maximum values represent the lowest and highest recorded inventory valuation for the selected product.
Mean, Median and Mode represent central pricing tendencies across inventory transactions.
Range and Amplitude values represent the spread of pricing variation, while Relative Deviation and Standard Deviation indicate the degree of pricing inconsistency or volatility within inventory records.
These calculations help organisations evaluate pricing stability, procurement consistency and inventory valuation behaviour.
Export Functionality
The Export button exports the currently displayed variance analysis data in Microsoft Excel (.xlsx) format.
The exported report reflects the selected filters, variance calculation basis, sorting structure and reporting period.
Data Representation
The report supports statistical inventory valuation analysis, pricing deviation visibility and inventory variance monitoring across products, spares, accessories and virtual products.
Displayed information varies depending on the selected filters, statistical configuration, valuation basis and reporting period. Where no data exists, corresponding fields may remain empty or display zero values.
Summary
The Stock Variance Report provides a consolidated statistical inventory variance and pricing analysis view within TUHUND.
By combining statistical deviation calculations, configurable valuation methods and inventory-level variance visibility, the report enables organisations to analyse pricing consistency, identify abnormal inventory valuation patterns and evaluate inventory pricing behaviour across products and operational inventory categories.
