Start by creating and saving the custom Equipment Control View.
Let's review what ChassisManager is telling you about your open trips column by column and why this information is important and useful to you.
- Rental start date - this is the date your company pulled the asset from the pool and started to use it. Subtract this date from today and you get the total days out for the rental and you can quickly calculate your potential spend based on the day rate charged.
- Rental end date - you'll notice this is empty. Open rentals do not have an end date by definition. Only when you return the chassis can you have a rental end date. If you see one here, that means there may be a processing error. Contact IAS Chassis Client Services for assistance on these.
- Rental Number - this is the rental number for tracking your transaction and for service request references
- Container Number - this is the container number that the start/stop facility reported was tied to the chassis for the given trip
- Trip Number - a rental may be comprised of one or many trips. Each trip on a rental is given a number so you can determine the order and sequence in which you pulled different containers with the chassis
- Pickup date - this is the date and time the trip started as identified by a gate out event at a start/stop facility
- Return date - this is the date and time the trip completed as identified by an in gate event at a start/stop facility
- Pickup location - this is the start/stop facility where the trip started with the gate out
- Return location - this is the start/stop facility where the trip ended with the gate in.
- Bill of Lading - this is the bill of lading number reported by the start/stop facility at the gate out on the trip
- Booking number - this is the booking number reported by the start/stop facility at the gate out on the trip
- Haulage type - this indicates whether the trip has been identified by a shipping line as Carrier Haul (CH) or Empty Reposition (MT). If no haulage type is provided by a shipping line, the default value is Merchant Haul (MH).
- Shipping SCAC - this is the SCAC of the shipping line responsible for the box as reported by the start/stop facility at the gate out event
- Trip Duration - this is the number of days duration of the trip. It is important to remember that the counter starts at 1. If you gate out a unit on day 1 and return it on day 1, your days out is 1, regardless of the time duration of the usage.
- Charges - this will be blank. Open trips are not rated, but having this column in your view is useful if you plan to use the CSV export feature for further analysis
Days Out Analysis
- The first high level number that you can quickly reference to determine your exposure is on the "Trips" tab once you've run your view. In this example, we can determine very quickly that currently my organization is in possession of 238 on hire units from my chassis equipment provider
- As you work through your list of rentals, using the rental start date you can determine how many days this particular unit has been on hire
- Sum up the days out and multiply by the day rate and you can quickly get to a forecasted spend for on-hire chassis lease
- By reviewing the individual trips within these rentals the user can quickly determine
- for completed trips with a return date/time, based on the haulage type, the BN/BOL number you can multiply the trip days to determine the spend and the re-bill party for the spend
- for open trips with no return date/time, you should be able to determine if the trip is legitimately open. If it is you can quickly calculate the potential spend using haulage type, BN/BOL and shipping line SCAC. If the trip (and the rental) is not legitimately open, you can contact IAS Chassis Client Services and provide a TIR to show proof of return of the unit. Chassis Client Services will help you resolve the closure and adjust the days out so your account statement is correct when presented to you.
For more detailed analysis, it is easy to export your Equipment Control view to a CSV file which can then be manipulated in a spreadsheet program such as Microsoft Excel. To export your view, click the "Up" arrow on the toolbar. When you open the file you'll have a "flattened" view of your data as if you had not grouped your view by Rental Number on the trip viewer. Remember, this is now a TRIP view of your rentals - you'll have more trips than rentals because there can be more than 1 trip on your rental.
Some things you can do to get some useful information using spreadsheet tools:
- Calculate rental days out in Column B by adding the date function "=today()-ColumnA" (format as number with no decimals)
- Calculate the charges for the trip duration by adding a multiplier function in ColumnP "=Trip Duration X Day Rate"
- Sum Column P and you'll get a quick gross up of your forecasted exposure for these on-the-road chassis
- Average Column B and you'll get a quick average days out for the units in your possession
You can create a pivot table to break down charges by shipping line SCAC, Haulage Type, BN/BOL. This will give you a more granular breakdown of potential rebill opportunities in your work in progress.
This information is valuable for revenue forecasting or for cash flow if you elect to re-bill for open usage that you can identify early.