A method, system, device and storage medium for compiling a shipping freight index

Abstract

The present invention discloses a method, system, device and storage medium for compiling a ship freight index, which belongs to the technical field of freight index compilation, and solves the technical problem that the current ship freight market changes cannot be grasped in time. The method is: select key indicators in the ship lock base period database and the freight rate collection base period database; select popular routes and calculate the weights of popular routes, select cargo types and obtain popular routes of specified cargo types, calculate the month-on-month growth rate of freight rates of popular routes, and calculate the price benchmark values ​​of popular routes; calculate the average freight rates of the same routes of different companies, dynamically assign weights to the current routes, calculate the comprehensive transportation freight rates of the specified cargo types in the reporting period, calculate the freight rate index of the specified cargo types in the reporting period, and compile and output the transportation price report based on the calculation results. An index converted from transportation price statistics can reflect the fluctuations in shipping prices, which can provide a basis for industry economic analysis and industry policy formulation.

Description

Technical Field

[0001] The present invention relates to the technical field of freight index compilation, and more specifically, to a method, system, device and storage medium for compiling a ship freight index. Background Art

[0002] Shipping index is the "barometer" of shipping market and an effective carrier of shipping information. At present, there is no shipping index for river basins in China. It is impossible to grasp the changes in river freight market, there is a certain information barrier, it is impossible to make market operation transparent, it is impossible to reduce vicious low-price competition, it is impossible to protect the rights and interests of transmission and cargo owners, which brings certain troubles to the sustainable development of the market. Summary of the invention

[0003] The technical problem to be solved by the present invention is to address the above-mentioned deficiencies in the prior art. One purpose of the present invention is to provide a method for compiling a ship freight index.

[0004] The second purpose of the present invention is to provide a system for compiling a shipping freight index.

[0005] A third object of the present invention is to provide a computer device.

[0006] A fourth objective of the present invention is to provide a computer storage medium.

[0007] In order to achieve the above-mentioned first objective, the present invention provides a method for compiling a shipping freight index, comprising the following steps:

[0008] Step 1. Select indicators, and select key indicators based on key fields in the ship passing base period database and the freight rate collection base period database;

[0009] Step 2. Select popular routes, obtain one-way route data through the key fields of the ship passing base period database, and select the top M popular one-way routes based on the number of operations on each route;

[0010] Calculate the weight of popular routes and count the weight Q of each route among the top M popular one-way routes selected l , the statistical method is as follows:

[0011]

[0012] In the formula, H l is the number of operations of the lth route among the first M popular one-way routes, H ALL is the total number of operations of the first M popular one-way routes;

[0013] Select the cargo type, and obtain the one-way route and quotation of the specified cargo type through the key fields of the freight rate collection base period database; intersect the one-way route of the specified cargo type with the first M popular one-way routes, so as to obtain the popular route of the specified cargo type;

[0014] Calculate the freight rates of popular routes for the specified cargo type. Use the MAD algorithm to calculate the price of each popular route for the specified cargo type and use it as the benchmark value for the specified cargo type.

[0015] Calculate the month-on-month growth rate R of the popular routes for each specified cargo type l :

[0016]

[0017] Where P l is the price of the popular route of the specified cargo type in this period, P l-1 The prices of popular routes for the specified cargo type in the previous period;

[0018] Get the new benchmark value, take the specified date 1000 as the base period, and calculate the benchmark price JZ of the popular routes of the specified cargo type:

[0019] JZ=∑Q l ×P l ;

[0020] Step 3. Calculate the average freight rates of the first M popular one-way routes for different companies:

[0021]

[0022] In the formula, is the average freight rate of the jth route; The freight rate quotation for the i-th enterprise on the j-th route;

[0023] According to the proportion of each route's volume to the total volume of cargo passing through the lock, the weight of each route is dynamically assigned:

[0024]

[0025] Where W j is the weight of the jth route, V j is the cargo volume passing through the lock for the jth route, and V is the total cargo volume passing through the lock;

[0026] The comprehensive freight rate for the specified cargo type during the reporting period is calculated based on the average freight rate of each route and the weighted average of the route weights:

[0027]

[0028] In the formula, XSFk is the comprehensive freight rate for the transportation of the specified cargo type in period k;

[0029] The comprehensive freight rate calculated on the base date is the base freight rate XSF0, and the base index is 1000;

[0030] The ratio of the comprehensive freight rate in the reporting period to the base period freight rate is multiplied by the base period index 1000 to obtain the freight rate index for the specified cargo type in the reporting period:

[0031]

[0032] Where, XSFI k is the Xijiang sand / cement freight rate index for the kth period;

[0033] Step 4. Prepare a transportation price report based on the calculation results of steps 2 and 3, and output the transportation price report.

[0034] As a further improvement, the key fields of the ship lock base period database include: primary key number, ship name, lock gate name, starting city, destination city, lock time, lock type, actual cargo weight, draft, and heading;

[0035] The key fields of the freight rate collection base period database include: route, starting city, destination city, freight material price, quotation week, quotation company, and quotation time.

[0036] Furthermore, the MAD algorithm is as follows:

[0037] 1) Calculate the median value of all elements: X median ;

[0038] 2) Calculate the absolute deviation of all elements from the median: bias = |X i -X median |;

[0039] 3) Obtain the median of absolute deviation: MAD = bias median ;

[0040] 4) After determining the parameter n, all data can be adjusted as follows:

[0041]

[0042] In order to achieve the above-mentioned second objective, the present invention provides a system for compiling a shipping freight index, comprising:

[0043] The index selection module is used to select key indicators based on key fields in the ship passing base period database and the freight rate collection base period database;

[0044] The first calculation module is used to select popular routes and cargo types, calculate the weights of popular routes, calculate the freight rates of popular routes of specified cargo types, calculate the month-on-month growth rates of the freight rates of popular routes of each specified cargo type, and calculate the price benchmark values ​​of popular routes of specified cargo types;

[0045] The second calculation module is used to calculate the average freight rates of the same routes of different enterprises on the first M popular one-way routes, dynamically assign weights to the current routes according to the proportion of the freight volume of each route to the total freight volume passing through the lock, calculate the comprehensive freight rate of the specified cargo type in the reporting period according to the average freight rate of each route and the weighted average of the route weights, and calculate the freight rate index of the specified cargo type in the reporting period;

[0046] The output module is used to compile a transportation price report based on the calculation results of the first calculation module and the second calculation module, and output the transportation price report.

[0047] In order to achieve the third objective above, the present invention provides a computer device, including a memory and a processor, wherein the memory stores a computer program, and the processor implements the above-mentioned method for compiling a shipping freight index when executing the computer program.

[0048] In order to achieve the fourth objective above, the present invention provides a computer-readable storage medium having a computer program stored thereon, and when the computer program is executed by a processor, the method for compiling a shipping freight index is implemented.

[0049] Beneficial Effects

[0050] Compared with the prior art, the present invention has the following advantages:

[0051] The present invention collects popular routes and freight rate data, and converts the transportation price of the specified cargo type into an index, which is used to reflect the fluctuation of the shipping price of the specified cargo type, and can provide a basis for industry economic analysis and industry policy formulation, and can also be used as a basis for shipping companies to design business strategies and a tool for enterprise risk management. At the same time, it can reflect the changes in the river ship freight market and the development of the industry, and can eliminate information barriers to a certain extent, make the information flow of the shipping market smoother, increase the transparency of market operations, reduce vicious low-price competition, and protect the rights and interests of shipowners and cargo owners. BRIEF DESCRIPTION OF THE DRAWINGS

[0052] Figure 1 is a flow chart of the present invention;

[0053] Figure 2 The flowchart of calculating the freight rate index in the present invention is shown in FIG. DETAILED DESCRIPTION

[0054] The present invention will be further described below with reference to the specific embodiments in the accompanying drawings.

[0055] See also Figure 1-2 A method for compiling a shipping freight index comprises the following steps 1 to 4:

[0056] Step 1. Select indicators. Select key indicators based on the key fields in the ship passing base period database and the freight rate collection base period database. The key indicators are used for the subsequent calculation model design. The key indicators are as follows:

[0057] The key fields of the ship lock base period database include: primary key number, ship name, lock gate name, starting city, destination city, lock time, lock type (such as gravel, etc.), actual cargo weight, draft depth, and course;

[0058] The key fields of the freight rate collection base period database include: route, starting city, destination city, freight material price, quotation week, quotation company, and quotation time.

[0059] Step 2. Establish a computational model.

[0060] (1) Select popular routes. Obtain one-way route data through the key fields of the ship passing through the lock base period database. Select the top M popular one-way routes based on the number of operations on each route. The size of M is customized according to business requirements. As shown in Table 1, Shown are the 5 selected popular routes.

[0061]

[0062] Table 1

[0063] (2) Calculate the weight of popular routes and count the weight Q of each route among the first M popular one-way routes selected. l , the statistical method is as follows:

[0064]

[0065] In the formula, H l is the number of operations of the lth route among the first M popular one-way routes, H ALL It is the total number of operations of the first M popular one-way routes.

[0066] For example:

[0067] (3) Select the cargo type, and obtain the one-way route and quotation of the specified cargo type through the key fields of the freight rate collection base period database; take the intersection of the one-way route of the specified cargo type and the first M popular one-way routes to obtain the popular route of the specified cargo type.

[0068] In this embodiment, the route with the cargo type of sand / cement is selected. That is, the one-way route and quotation with the cargo type of sand / cement are obtained through the key fields of the freight rate collection base period database, and the one-way route with the cargo type of sand / cement is intersected with the above-mentioned popular routes, as shown in Table 2 below, so as to obtain the popular routes with the cargo type of sand / cement.

[0069]

[0070] Table 2

[0071] (4) Calculate the freight rates of the popular routes of the specified cargo type, that is, the freight rates of the popular routes (sand / cement). The MAD algorithm is used to calculate the price of each popular route of the specified cargo type and use it as the benchmark value of the specified cargo type.

[0072] The MAD algorithm is as follows:

[0073] 1) Calculate the median value of all elements: X median ;

[0074] 2) Calculate the absolute deviation of all elements from the median: bias = |X i -X median |;

[0075] 3) Obtain the median of absolute deviation: MAD = bias median ;

[0076] 4) After determining the parameter n, all data can be adjusted as follows:

[0077]

[0078] (5) Calculate the month-on-month growth rate R of the popular routes for each specified cargo type (sand / cement) l :

[0079]

[0080] Where P l is the price of the popular route of the specified cargo type in this period, P l-1 The prices for popular routes for the specified cargo type in the previous period.

[0081] (6) Obtain a new benchmark value, taking the specified date 1000 as the base period, such as January 1, 2023 1000 as the base period, and calculate the price benchmark value JZ of the popular routes of the specified cargo type (sand / cement):

[0082] JZ=∑Q l ×P l .

[0083] Step 3. Freight index calculation.

[0084] (1) Obtaining the transport price report, member companies report the freight rate every week, and the statistical period is one week (generally from the last Friday to the current Thursday). Member companies report the sand / cement transportation prices of each route during the reporting period. Freight rates that are not reported by member companies for a certain period or a certain route will be treated as blank. The reported freight rates are FIO (excluding loading and unloading charges) freight rates, using freight ton prices. For lump sum freight rates, the average price of the cargo volume is used, and the voyage charter freight rates are converted to deadweight ton unit prices. The internal transaction allocation prices and special preferential prices of the enterprise are not counted. The format of reporting freight rates is shown in Table 3 below.

[0085] course City-level departure place City-level destinations Freight (yuan / ton) Quote time Quotation Company

[0086] Table 3

[0087] (2) Calculate the average freight rate of the same route for different companies on the first M popular one-way routes. Conduct a rationality review of the freight rates submitted by different companies and eliminate unreasonable freight rates. Classify the routes according to "city-level departure point - city-level destination" and count the number of freight rate reports for each route. Sort by the number of routes, select the first M popular routes (the number of popular routes is determined according to business needs), and calculate the average freight rate of the same route for different companies. The formula for calculating the average freight rate of the same route and different companies during the reporting period is as follows:

[0088]

[0089] In the formula, is the average freight rate of the jth route; The (sand / cement) freight rate quotation of the i-th enterprise on the j-th route.

[0090] (3) Dynamic weighting of routes is based on the proportion of each route’s volume to the total volume of cargo passing through the lock. For example, the weighting of each route in the Xijiang River Basin is dynamically assigned based on the proportion of each route’s volume to the total volume of cargo passing through the Changzhou Lock:

[0091]

[0092] Where W j is the weight of the jth route, V j is the cargo volume passing through the lock for the jth route, and V is the total cargo volume passing through the lock.

[0093] (4) Calculate the comprehensive freight rate for the reporting period. The comprehensive freight rate for the transportation of the specified cargo type (sand / cement) during the reporting period is calculated based on the average freight rate of each route and the weighted average of the route weights:

[0094]

[0095] In the formula, XSF k It is the comprehensive freight rate for the transportation of the specified cargo type (sand / cement) in the kth period.

[0096] (5) Calculate the base period comprehensive freight rate. The comprehensive freight rate calculated on the base date is the base period freight rate XSF0, and the base period index is 1000.

[0097] (6) Calculate the comprehensive freight index. The ratio of the comprehensive freight rate in the reporting period to the base period freight rate is multiplied by the base period index 1000 to obtain the freight index for the specified cargo type (sand / cement) in the reporting period:

[0098]

[0099] Where, XSFI k is the Xijiang sand / cement freight rate index for the kth period.

[0100] The calculation steps of step 3 can also be shown in Table 4 below.

[0101]

[0102] Table 4

[0103] Step 4. Prepare a transportation price report based on the calculation results of steps 2 and 3, and output the transportation price report. Member companies can query the transportation price report through computers, mobile phones (APP) and other terminals.

[0104] A ship freight index compilation system, comprising:

[0105] The index selection module is used to select key indicators based on key fields in the ship passing base period database and the freight rate collection base period database;

[0106] The first calculation module is used to select popular routes and cargo types, calculate the weights of popular routes, calculate the freight rates of popular routes of specified cargo types, calculate the month-on-month growth rates of the freight rates of popular routes of each specified cargo type, and calculate the price benchmark values ​​of popular routes of specified cargo types;

[0107] The second calculation module is used to calculate the average freight rates of the same routes of different enterprises on the first M popular one-way routes, dynamically assign weights to each route according to the proportion of the freight volume of each route to the total freight volume passing through the lock, calculate the comprehensive freight rate of the specified cargo type in the reporting period according to the average freight rate of each route and the weighted average of the route weights, and calculate the freight rate index of the specified cargo type in the reporting period;

[0108] The output module is used to compile a transportation price report based on the calculation results of the first calculation module and the second calculation module, and output the transportation price report.

[0109] A computer device includes a memory and a processor. The memory stores a computer program. When the processor executes the computer program, the above-mentioned method for compiling a shipping freight index is implemented.

[0110] A computer-readable storage medium stores a computer program, which implements the above-mentioned method for compiling a shipping freight index when executed by a processor.

[0111] This embodiment collects the shipping routes and freight data of Xijiang sand and gravel, cement clinker, and uses computer software programming to compile a mathematical model according to the index calculation method of this patent, and then uses the mathematical model to calculate the freight index. The present invention is an index for the statistical conversion of the transportation prices of Xijiang sand and gravel and cement clinker, which is used to reflect the fluctuations in the shipping prices of Xijiang sand and gravel and cement clinker. It can provide a basis for industry economic analysis and industry policy formulation, and can also be used as a basis for shipping companies to design business strategies and a tool for enterprise risk management. It solves the dilemma that there is no shipping index for the Xijiang River Basin in China, and then promotes the construction of the Beibu Gulf regional international shipping center, realizes the functional upgrade and service optimization of the shipping center, and enhances the influence and popularity of the shipping center. At the same time, it can reflect the changes in the Xijiang freight market and the development of the industry, and can eliminate information barriers to a certain extent, make the information flow of the shipping market smoother, increase the transparency of market operations, reduce vicious low-price competition, and protect the rights and interests of shipowners and cargo owners.

[0112] The above are only preferred embodiments of the present invention. It should be pointed out that for those skilled in the art, several modifications and improvements can be made without departing from the structure of the present invention, which will not affect the effect of the implementation of the present invention and the practicality of the patent.

Claims

1. A method for compiling a shipping freight index, characterized in that: The following steps are involved: Step 1. Select indicators, and select key indicators based on key fields in the ship passing base period database and the freight rate collection base period database; Step 2. Select popular routes, obtain one-way route data through the key fields of the ship passing base period database, and select the top M popular one-way routes based on the number of operations on each route; Calculate the weight of popular routes and count the weight Q of each route among the top M popular one-way routes selected l , the statistical method is as follows: In the formula, H l is the number of operations of the lth route among the first M popular one-way routes, H ALL is the total number of operations of the first M popular one-way routes; Select the cargo type, and obtain the one-way route and quotation of the specified cargo type through the key fields of the freight rate collection base period database; intersect the one-way route of the specified cargo type with the first M popular one-way routes, so as to obtain the popular route of the specified cargo type; Calculate the freight rates of popular routes for the specified cargo type. Use the MAD algorithm to calculate the price of each popular route for the specified cargo type and use it as the benchmark value for the specified cargo type. Calculate the month-on-month growth rate R of the popular routes for each specified cargo type l : Where P l is the price of the popular route of the specified cargo type in this period, P l-1 Designated for the previous period Prices on popular routes by cargo type; Get the new benchmark value, take the specified date 1000 as the base period, and calculate the benchmark price JZ of the popular routes of the specified cargo type: JZ=∑Q l ×P l ; Step 3. Calculate the average freight rates of the first M popular one-way routes for different companies: In the formula, is the average freight rate of the jth route; The freight rate quotation for the i-th enterprise on the j-th route; According to the proportion of each route's volume to the total volume of cargo passing through the lock, the weight of each route is dynamically assigned: Where W j is the weight of the jth route, V j is the cargo volume passing through the lock for the jth route, and V is the total cargo volume passing through the lock; The comprehensive freight rate for the specified cargo type during the reporting period is calculated based on the average freight rate of each route and the weighted average of the route weights: In the formula, XSF k is the comprehensive freight rate for the transportation of the specified cargo type in period k; The comprehensive freight rate calculated on the base date is the base freight rate XSF0, and the base index is 1000; The ratio of the comprehensive freight rate in the reporting period to the base period freight rate is multiplied by the base period index 1000 to obtain the freight rate index for the specified cargo type in the reporting period: Where, XSFI k is the Xijiang sand / cement freight rate index for the kth period; Step 4. Prepare a transportation price report based on the calculation results of steps 2 and 3, and output the transportation price report.

2. A method for compiling a shipping freight index according to claim 1, characterized in that: The key fields of the ship lock base period database include: primary key number, ship name, lock gate name, starting city, destination city, lock time, lock type, actual cargo weight, draft, and heading; The key fields of the freight rate collection base period database include: route, starting city, destination city, freight material price, quotation week, quotation company, and quotation time.

3. A method for compiling a shipping freight index according to claim 1, characterized in that: The MAD algorithm is as follows: 1) Calculate the median value of all elements: X median ; 2) Calculate the absolute deviation of all elements from the median: bias = |X i -X median |; 3) Obtain the median of absolute deviation: MAD = bias median ; 4) After determining the parameter n, all data can be adjusted as follows:

4. A system for compiling a shipping freight index, characterized in that: include: The index selection module is used to select key indicators based on key fields in the ship passing base period database and the freight rate collection base period database; The first calculation module is used to select popular routes and cargo types, calculate the weights of popular routes, calculate the freight rates of popular routes of specified cargo types, calculate the month-on-month growth rates of the freight rates of popular routes of each specified cargo type, and calculate the price benchmark values ​​of popular routes of specified cargo types; The second calculation module is used to calculate the average freight rates of the same routes of different enterprises on the first M popular one-way routes, dynamically assign weights to the current routes according to the proportion of the freight volume of each route to the total freight volume passing through the lock, calculate the comprehensive freight rate of the specified cargo type in the reporting period according to the average freight rate of each route and the weighted average of the route weights, and calculate the freight rate index of the specified cargo type in the reporting period; The output module is used to compile a transportation price report based on the calculation results of the first calculation module and the second calculation module, and output the transportation price report.

5. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the method for compiling a shipping freight index according to any one of claims 1 to 3 is implemented.

6. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, a method for compiling a shipping freight index as described in any one of claims 1 to 3 is implemented.

Images