Product Usage Reporting

At a high level, this feature will allow our customers to create reports outlining the amount of certain components (often for gases) that go into the products that they sell. In the current design, components are being tracked at the Product Code level.

For example, Product Code A represents gas cylinders that get filled with 1200 SCF (standard cubic feet) of Argon and 75 SCF of Helium. If we know that Location XYZ filled 10 cylinders of Product Code A last month, we can calculate that they should have used 1200 x 10 = 12,000 SCF of argon and 75 x 10 = 750 SCF of Helium. These numbers can then be used by the client to compare against the raw materials that Location XYZ took in over that same time frame (i.e. bulk argon, helium, oxygen, etc.) and begin to calculate how much product might be getting lost in storage and/or the fill process.

Summary Reporting

The summary version of the Product Usage Report is currently hosted on a page within the website called 'Product Usage Summary'. The page allows you to enter a date range (maximum of 31 days), choose a location (or all locations), and a single component.

The columns for this report are built dynamically using the Asset Families belonging to a special Asset Family Collection. The Asset Family Collection must be named 'Product Usage Rollup Categories'.

Within that collection, one or more Asset Families need to be defined. The Asset Families within this collection can be setup using any combination of Asset Category, Group, Type, and Product Code values needed. In this way, our clients are free to create arbitrary groupings of their assets and have those groupings appear as separate columns on the report.

Detailed Reporting

The detailed version of the Product Usage report functions similarly to the Summary report, but the Asset Families do not come into play. Instead, the detailed report presents a breakdown of each component at the product code level. The columns for this report are created dynamically, with one column for each component defined in the database.

The following columns are displayed in the detailed report:

  • Location

  • Category

  • Group

  • Type

  • Product Code

  • Product Code Description

  • Quantity (indicates the quantity of that product code that was filled)

  • Total Volume (sum of all of the components filled for that product code)