Cost Ratio Transporter
Report Module Guide: Transporter Cost Ratio (Purchasing)
Module Location
Purchasing > Reports > Transporter Cost Ratio
Module Objective
The Transporter Cost Ratio report module within the Purchasing menu is used to generate a report that analyzes the cost ratio of inbound logistics. This report calculates the percentage of the shipping cost against the value of the goods purchased from a supplier. This is a Key Performance Indicator (KPI) for measuring the cost-efficiency of logistics and procurement.
1. Report Parameters (Filter)
The main page of this module is a form containing various parameters to customize the report that will be generated.
Here is an explanation for each parameter:
-
State / Province:
-
Filter the report by the origin area of the shipment, whether All, per Island, or Selected (Specific Province).
-
-
Expedition:
-
Select the scope of shipping services, whether All or Selected (Specific Expedition).
-
-
From WH / Destination:
-
Filter by the origin and destination warehouses.
-
-
Shipment Date:
-
Specify the From and To date range to define the goods receipt period to be analyzed (e.g., August 1, 2025, to August 31, 2025).
-
2. Steps to Generate the Report
Step 1: Set Report Parameters
Select all the parameters you need, for example, a Shipment Date range and a specific Expedition to compare efficiency.
Step 2: Generate the Report
After all parameters are set, click one of the two buttons in the bottom-left section of the page:
-
Display Report: To preview the analysis report directly on your screen.
-
Export To MS Excel: To download the report data in an Excel file format.
Tips & Important Notes
-
Use this report to compare the cost-efficiency of inbound shipping among various expedition companies.
-
Analyzing the cost ratio per shipping origin (From WH) can help in making decisions about vendor selection or purchasing logistics strategies.
-
This report is an important performance measurement tool for the Logistics and Purchasing teams.