The Cylinder report generates a spreadsheet to show the cylinder
usage information by customer site for the selected date range,
captured from the completed transactions Closed in Cylinder Entry.
The report respects the Divisional Restricted
Views assigned to the operator.
Only rental products in a Group identified
to Use Cylinders are included.
The spreadsheet shows the number of cylinders rented by each
Group, if the Group is flagged as Use Cylinders in Groups.
This can be useful to provide visibility on how many cylinders are
being used by a customer in comparison to the equipment
rentals.
e.g. Propane cylinders out to service the Heaters:
If many cylinders are going out to service few heaters, then it
could be that the customer is acquiring the heaters from a
different source.
This could be a concern as it is the rentals that generate the
major revenue.
The formulas used on the spreadsheet for the consumable Sales Product such as propane, and their containers such as cylinders, include:
Qty Contained = Qty of 'Consumable Sales Products' sold on Cylinder Invoices
Revenue = Revenue of 'Consumable Sales Products' sold on Cylinder Invoices
Rental Rev. = Rental Revenue from Containers rented
Cylinder Turns = Container Qty / Avg Cyl
Cylinder to Group Ratio = Avg Cyl / Total Containers on Rent
Revenue per Cylinder = Rental Rev / Avg Cyl
Note: A maximum of 150 Groups can be reported in this analysis.
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |