TCG Home Page

The Traffic/CIS Report Writer, part of the costed database module of the Cost Information System, includes options to extract shipment data from the costed database into a separate cost file. Once extracted, the costs may be re-calculated in order to (1) evaluate the impact of a more current cost level, (2) perform sensitivity analysis on the impact of changing characteristics of the freight, the move or the service required, (3) correct a data error or provide additional information to obtain a more accurate cost, and (4) re-rate the freight, using the Pricing/CIS module, to evaluate the impact of use of a different tariff.

The Extract option provides a number of settings which the user can change, based on the analysis to be done. They are displayed in the center box of the Report Writer Setup Screen, when the "Extract Full Data Set" report option is selected, and can be modified by clicking on that box, or on the Extract Settings button. They also appear when the "Extract from Report Criteria" report option is run.

Extract Using - The default is to extract with the Terminals and Locations (ZIP Codes / Postal Codes) as the freight moved. If major changes have been made to your service areas or terminals, use the setting for Locations Only, so the system will look up the terminals now serving the points. The final option to include run numbers is to retain the cartage run numbers at the time of the initial cost analysis, if they have subsequently changed.

Include Performance Adjustments - Each Period, the default, will pull the adjustments made to each activity, by terminal, to reconcile the monthly costing to actual expenses and performance. If major changes have been made to your system, such as introduction of a stem study or customer profile, such that the performance adjustments made in earlier periods are no longer valid, use the option to apply only those in the current period to all periods being extracted. The final option, No, is if the reconciliation adjustments are not appropriate for your analysis.

Actual P&D times - If times are being matched to shipments from actual P&D trip data, it can be pulled with the extract data. Yes constructs the total stop time for each shipment from the shipment's allocation, which, for multi-shipment stops, can sometimes show an unusual amount. This is because the allocation in the monthly costing takes all shipment characteristics making up the stop into account in the time allocation, where as the shipment cost program uses a weight-basis allocation of total stop time. Use No if you are extracting for the purpose of evaluating the impact of a change in freight or movement characteristics which would affect the P&D time.

Linehaul as Calculated - This makes use of the new CIS linehaul cost override. If set to Yes, the extract pulls the linehaul costs as calculated in the monthly costing. If you are using actual linehaul dispatch detail to cost linehaul at actual in the monthly processing, use this option to extract the actual results. Otherwise, linehaul will be re-calculated when the file is costed.

Cartage as Calculated - This, if Yes, will pull the cost of any Pickup & Delivery performed by agents as calculated in the monthly costing. Otherwise, cartage will be re-calculated when the file is costed.

Database Revenue - The Net Revenue option populates the revenue field in the CIS shipment record. The Tariff Revenue Breakdown populates the fields in the Rate Data window, including the Tariff Revenue field. The No revenue option populates the fields in the Rate Data window, except the Tariff Revenue field, which will be re-calculated when the file is auto-rated with Pricing/CIS.

Include Linehaul Low-Revenue Backhaul Adjustments - If your monthly processing uses actual linehaul dispatch costing or the Linehaul Cost Calculation option for Backhaul Adjustment, then additional adjustments can be made to backhaul freight, beyond costing the freight as if the lane were full, to shift more of the cost to headhaul due to low backhaul revenue. This further adjustment can be pulled with the Extract if this is set to Yes. Otherwise, any backhaul freight is costed as if the lane were full, displaying the operating ratio, and an operating ratio covering no backhaul cost, on the grand total report.

If this final option is set to No, then the "Linehaul as Calculated" option can't be Yes. Conversely, if the "Linehaul as Calculated" is Yes, then this option can't be No.