JPH0962738A - Physical distribution cost managing method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To more easily grasp the total physical distribution cost from a shipping place to the final delivery place to a consumer. SOLUTION: There are a plurality of transportation paths from the shipping place to the final delivery place according to individual transportation stages by ship, by trucking service, etc. It was difficult to trace transportation paths like those in order before. The figure shows that route tracing information data indicating transportation paths PA-PJ in a customer route in order, so the customer route can be shown consitently and the physical distribution costs regarding the customer route can more easily be grasped. Information based upon those data can be retrieved with a physical distribution key which makes it easy to retrieve a physical distribution department and a business key which makes it easier to retrieve a business department, so respective departments can more easily make good uses of the information.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to physical distribution cost management of a customer route constituted by a plurality of transportation paths according to a plurality of transportation stages of a transportation route of a package from a shipping source to a final delivery place of a customer. Regarding the method, especially for the transportation of the goods ordered by the sales department, to grasp the comprehensive logistics cost from the sender to the final delivery place of the customer, and to find a better customer route in terms of the logistics cost, etc. In addition to facilitating the analysis and management of information, etc., it is possible to further organize and reduce the information required for this purpose, aiming to reduce logistics costs and reduce labor and costs for managing logistics operations. The present invention relates to a logistics cost management method that can be achieved.

[0002]

2. Description of the Related Art Expenses required for transportation of products, such as products ordered by a sales department, to the final delivery place of a customer (or customer) and temporarily stored goods in the middle of a transportation route The total logistics cost including the management cost of the relay station cannot be ignored.

[0003] For example, in the steel industry, first of all, the physical distribution cost required for transporting raw materials into the factory is followed by the physical distribution cost required for receiving raw materials within the factory and transporting semi-finished products within the factory. For example, hot metal in the factory, molten steel, hot mass,
A lot of on-site transportation is required in each stage of semi-finished products and rolled products, and in the process of bringing products into the warehouse. In addition, the products carried into the warehouse are transported to a relay station located at a key location overseas or in Japan, and then transported to the final delivery place of the customer.

As described above, in the iron and steel industry, there are many physical distribution processes from the transportation of raw materials into the factory to the final delivery place of the customer, and a large physical distribution cost is required. In particular, the objects to be transported in the steel industry are heavy items, which also imposes a heavy burden on logistics costs. In addition, the products of the steel industry are also shaped like plates, rods,
There are various types such as coil. Also, the size of the product is large and small. Therefore, due to the variety of shapes and sizes, demands for transportation are also various. In order to satisfy such requirements, it is necessary to secure a wide variety of transportation handling equipment, transportation means, and personnel having special skills, which requires physical distribution costs and a lot of labor.

Further, in the process of carrying out the product from the factory warehouse and transporting the product to the final delivery place of the customer via the relay station,
There are various transportation stages (hereinafter also referred to as transportation paths), and there are multiple transportation stages such as land transportation stages such as freight cars, trucks and trailers, and sea transportation stages such as freighters and ferries. Exists.

Conventionally, all routes of transportation from the shipping source to the final delivery place of the customer (hereinafter referred to as customer routes)
Pay bills are handled at each transportation stage (each transportation path).

For example, in the process of transporting raw materials to a factory, there are a plurality of transportation stages. Also, there are various forms of transportation stages within the factory. Further, in the process of shipping from the factory to the final delivery place of the customer such as passing through a relay station, there are many transportation stages. A large number of bills for payment, including a relay station management fee, and a payment operation are handled for each of these multiple transportation stages.

[0008]

As described above, in the related art, the payment invoice is handled and the payment operation is performed at each of a plurality of transportation stages along the customer route, and it is difficult to grasp the distribution cost. was there.

In addition, during the period from the time when the raw material is brought into the factory to the time when it is finally transported to the final delivery place of the customer, the information managed by the sales department, the information managed by the factory, and the distribution department of the head office manage it. Since there are various forms of information, such as information,
It was difficult to share information on logistics costs among sales, factories, and the logistics department of the head office. For example, in these sales, factories, and head office distribution departments, the key information for identifying the transported items is often different. For example, a code number or the like that corresponds to the order type, the sales type, or the distribution type of the embodiment described later. Handling is often different from each other. Even in this respect, it is difficult to share the distribution cost information among sales departments, factories, and head office distribution departments. For example, it may not be possible to inquire the distribution cost information handled by the factory or the distribution department of the head office with a specific management key with the management key of the sales side.

For this reason, it becomes difficult to grasp the comprehensive physical distribution cost up to the final delivery place of the customer. Therefore, it becomes difficult to reduce the distribution cost company-wide by analyzing and managing the distribution cost. For example, it is difficult to provide a cheaper and more stable physical distribution by setting a customer route with stable transportation and a lower physical distribution cost as a standard route. Further, it becomes difficult to compare a new standard customer route with another standard route that has already been set, and to consider changing or improving the standard route in terms of physical distribution costs.

The present invention has been made to solve the above-mentioned conventional problems, and it is possible to reduce the total physical distribution cost of the transportation of the goods ordered by the sales department from the sender to the final delivery place of the customer. For convenience of analysis and management such as grasping and finding a better customer route in terms of logistics cost, etc., the information necessary for this can also be organized or reduced, reducing logistics cost As well as
An object of the present invention is to provide a physical distribution cost management method capable of reducing the labor and cost for managing physical distribution operations.

[0012]

First, a distribution cost management method according to the first invention of the present application is designed so that a plurality of transportation routes are provided in accordance with a plurality of transportation stages of a transportation route from a shipping source to a final delivery place of a customer. In a logistics cost management method for a customer route composed of transportation paths, transportation path data having a package identification key and a transportation path connection key for each of the transportation paths, distribution cost data, and a transportation handler are provided in advance. To create the primitive data including the payment information data used for payment and the final transportation path information data indicating whether or not the transportation path is the final transportation path to the customer and to grasp the customer route. When creating the customer route information data of, the first step is to find the final transportation path that has been delivered to the customer, and to trace the customer route leading to the final transportation path to the information tracking customer route. As a result, a transportation path in which the package identification key matches and a landing area in the front transportation path and a loading area in the rear transportation path match is connected while sequentially tracing from the final transportation path to the upstream side of the transportation path. , While creating route tracking information data of the information tracking customer route based on the source data, while collecting information on the logistics cost of the information tracking customer route from the source data, creating customer route logistics cost data, By creating customer route information data from these route tracking information data and customer route physical distribution cost data, the above-mentioned problem is achieved.

In the distribution cost management method according to the first aspect of the invention, a plurality of different customer routes for transporting the same package from the same sender to the final delivery place of the same customer are managed and designated by the customer. Meet the delivery conditions
Moreover, one of the plurality of customer routes, which has a stable transportation system for each transportation path and has a smaller total distribution cost over the entire customer route, is used as a standard customer route. When providing the customer route information data that is identified and designated according to the designation of the package identification key, the transport of the package designated from the package identification key from the shipping source to the customer is performed. By providing a plurality of the customer route information of the customer route which is the standard customer route and the customer route which is not the standard customer route, the above problem can be achieved and in terms of physical distribution cost and the like. This is for the convenience of analysis and management such as finding a good customer route.

On the other hand, the physical distribution cost management method according to the second invention of the present application has a plurality of routes according to a plurality of transportation stages of a route for transporting a package ordered by the sales department from the sender to the final delivery place of the customer. In a logistics cost management method for a customer route composed of transportation paths, transportation path data having a package identification key and a transportation path connection key for each of the transportation paths, distribution cost data, and a transportation handler are provided in advance. Along with creating the primitive data, including the payment information data used for payment and the final transportation path information data indicating the final transportation path that has been delivered to the customer, from the original data,
While reducing the payment information data, a logistics management database having a logistics key for the convenience of the information retrieval of the logistics operator, a sales key for the convenience of the information retrieval of the sales operator, and a transportation pass connection key Moreover, since the information indicating the type of the transported object is created while being reduced, the above-mentioned problem can be achieved, and a logistics cost management method in which necessary information is more organized and reduced or reduced is provided. It was done.

In the distribution cost management method according to the second aspect of the present invention, considering a relay station in the middle of a customer route that transports a package from a shipping source to a final delivery place of a customer, from the shipping source to the relay station. With the primary transportation and the secondary transportation from the relay station to the final delivery place of the customer, the physical distribution key,
By achieving common use of the sales key and the transportation path connection key, the above-mentioned problem can be achieved and
This is to further organize and reduce or reduce necessary information.

The operation of the first invention and the operation of the second invention will be described below in this order.

First, according to the first aspect of the present invention, a route for transporting a package from a shipping source to a final delivery place of a consumer,
It is possible to consistently provide information on all customer routes and, at the same time, provide information on physical distribution costs of the customer routes.

Conventionally, each transportation path is handled,
There are transportation path data having a transportation item identification key and a transportation path connection key, distribution cost data, payment information data used for payment to a transportation operator, and the like. This is because, conventionally, a bill for payment of transportation cost is managed and a payment operation is performed for each transportation path. In the first aspect of the present invention, with respect to such various data for each transportation path, a final transportation path that indicates whether or not the transportation path is the final transportation path that is completely delivered to the customer. Information data is added to make it primitive data. That is, data including final transportation path information data in addition to the transportation path data, physical distribution cost data, and payment information data described above is referred to as original data.

Here, the above-mentioned package identification key is for identifying a package. In the package identification key,
For example, a physical distribution key and a sales key are included as in the embodiment described later.

For example, the physical distribution key, which will be described later, includes information for identifying a factory, information for identifying a physical distribution type for identifying a package, and information for indicating a final delivery place of the package, and for identifying the type of package. Not only this, but also the same kind of packages in the transportation process can be distinguished from each other, for example, by the difference in the delivery place.

As will be described later, the sales key is provided with information about the customer, information called a business type indicating the type of the package, and information indicating the sales window where the package was ordered. As with the physical distribution key mentioned above, not only can you identify the type of the target package, but you can also distinguish packages of the same type in the process of transportation from each other based on information about customers and sales windows. it can.

The above-mentioned transportation path connection key is information indicating the connection relationship of individual transportation paths constituting the customer route.
As described above, the customer route is composed of a plurality of transportation paths, for example, transportation paths of various transportation stages such as a transportation path of a land transportation by a truck and a transportation path of a sea transportation by a cargo ship. The transportation path connection key indicates the connection relationship of such individual transportation paths. For example, in the embodiment described later, the individual transportation paths PA to PJ in the route tracking information data of FIGS. 7 and 8. It is like the information of the transportation path connection key shown by.

The information of the transportation path connection keys of the transportation paths PA to PJ of this embodiment is information regarding the outgoing flight, information regarding the loading place, information regarding the landing place, and whether the transportation is the primary transportation or the secondary transportation. And information regarding the classification of "direct sales" or "manufacturing". For example, the connection relationship with another transportation path adjacent on the customer route can be grasped from the information about the loading place and the information about the landing place.

The above-mentioned physical distribution cost data is information indicating the physical distribution cost in each transportation path. This physical distribution cost may include the cost to be paid to the carrier or the cost incurred within the company, or a transit relay for temporarily storing the package during the process from the sender to the final delivery place of the customer. Costs for maintaining the base may be included.

The above-mentioned payment information data is information for actually paying the physical distribution cost incurred to the transportation operator.
The payment information data includes, for example, information indicating a payment form and the like.

Here, in the first aspect of the present invention, the customer route information data for grasping the customer route for transporting the packaged goods from the sender to the consumer, that is, the customer route can be grasped consistently as described above. When creating the information to be presented to the customer, first, the final transportation path information data is used to find the transportation path (final transportation path) that has been delivered to the customer. Here, the customer route leading to the final transportation path is defined as an information tracking customer route. Next, a transportation path satisfying the following two conditions is set as a final transportation path, and the transportation path is connected to the upstream side of the transportation route while being sequentially traced. Further, the transportation paths are connected while sequentially connecting in this way, and the route trace information data of the customer route is created based on the above-mentioned original data.

(1) First condition: This package identification key matches. For example, in the embodiment described later, the physical distribution key and the sales key match.

(2) Second condition: The landing place of the front transportation path and the loading land of the rear transportation path coincide with each other.

Next, in the first invention, the customer route physical distribution cost data is created while collecting the information on the physical distribution cost of the information tracking customer route as described above from the original data as described above.

Further, customer route information data is created from the above-mentioned route tracking information data and this customer route distribution cost data. If such customer route information data is obtained, not only can a consistent customer route be grasped, such as what kind of transportation path is used over all customer routes to the final delivery place of the customer, Information on physical distribution costs related to the customer route can also be provided. Therefore, it becomes easier to grasp the comprehensive physical distribution cost for such an entire customer route.

Therefore, for the transportation of the goods ordered by the sales department, the comprehensive logistics cost from the shipping source to the final delivery place of the customer is grasped, and a better customer route is found in terms of the logistics cost and the like. For convenience of analysis and management of
Therefore, it is possible to further organize and reduce the information necessary for this purpose, and it is possible to reduce the distribution cost as well as the labor and cost for managing the distribution operation.

Although the first invention is not limited to this, the concept of a standard customer route may be introduced. That is, a plurality of different customer routes for transporting the same package from the same sender to the final delivery place of the same customer are managed. Further, among such a plurality of customer routes, a customer route satisfying the following conditions is identified as a standard customer route.

(1) First condition: The delivery condition specified by the customer can be satisfied.

(2) Second condition: The transportation system of the transportation paths forming the customer route is stably established.

(3) Third condition: The total of physical distribution costs over the customer route is smaller or smaller than that of other customer routes.

Introducing the concept of such a standard customer route, when providing the customer route information data as described above, that is, when providing the customer route information data which is made in accordance with the designation by the package identification key. Is a plurality of customer routes for transportation from the sender of the packaged goods to the customer specified by the packaged goods identification key, in particular, the above-mentioned standard customer route and the above-mentioned customer route. We try to serve non-standard customer routes.

By introducing the concept of the standard customer route in this way, it is possible to more easily grasp the difference between a plurality of different customer routes that transport the same package from the same sender to the final delivery place of the same customer. You can For example, the standard customer route is normally used. Also, if a favorable customer route can be found at some occasion, if the customer route is compared with the standard customer route described above, it is possible to evaluate the found customer route, for example, in terms of physical distribution cost. The evaluation can be performed more easily. If it is determined that the evaluated customer route is superior to the standard customer route at this point, the customer route can be used as the standard customer route from the next time.

When the actual physical distribution costs when comparing a specific standard customer route with other customer routes thus vary, the physical distribution costs of these standard customer routes and other customer routes are calculated for a predetermined period. The results may be collected for a period of, for example, 3 months. Based on the result collection performed in this way, a better customer route can be selected as the standard customer route.

Next, the operation of the second invention will be described.

The second invention is not limited to this, but in the case of the first invention and the like, when presenting information over all customer routes to the final delivery place of the customer, a large amount of data is handled. There is a need. At this time, not only can such data be configured more optimally, but the unnecessary or less frequently used data can be omitted, for example, to improve the efficiency of the processing according to the first aspect of the present invention. It is possible to reduce the storage capacity of the device for performing the above.

Therefore, in the second invention, the structure of information and data used in the physical distribution cost management method is examined. In addition, in such a logistics cost management method, not only the logistics department that arranges transportation means and performs various operations related thereto, but also the sales department that ordered the package and the factory side can refer to and grasp the logistics cost. I am paying attention to the fact that is done. In addition, the contents of the original data that have been conventionally provided are also taken into consideration.

First, as generally known source data, as described in the first aspect of the invention, transportation path data having a transportation item identification key and a transportation path connection key for each transportation path, and physical distribution. There are cost data and payment information data used to make payments to shipping operators. In addition to these data, the source data including the final transportation path information data as described above is premised on the second invention.

In consideration of the frequency of use and the search efficiency, in the second aspect of the present invention, the distribution key and the sales person's information search are made from such primitive data to facilitate the information search of the distributor. Generate a convenient sales key and. In addition to these physical distribution key and sales key, a physical distribution management database having a transportation path connection key is created. Further, when the distribution management database is created, the payment information data in the original data as described above is reduced, and the information indicating the type of the transported item is further reduced.

As a result, the amount of data stored in the physical distribution management database is reduced, so that not only the storage capacity can be reduced, but also the processing speed at the time of information retrieval by a physical distribution person, a sales person or a factory person. Can be improved.

The above-mentioned information indicating the type of the transported item corresponds to "order type", "business type", "distribution type", etc. in the embodiments described later.

As described above, according to the second invention,
It is possible to configure more excellent information when implementing the physical distribution cost management method. Therefore, unnecessary information can be reduced and the storage capacity of the means for storing information can be suppressed. Furthermore, the processing efficiency in providing information can be improved. For this reason, the analysis of the comprehensive logistics cost from the shipping source to the final delivery place of the customer of the transportation of the ordered goods in the sales department and the finding of a better customer route in terms of the logistics cost etc. In addition to facilitating management, it is possible to further organize and reduce the information necessary for this purpose, and it is possible to reduce logistics costs and labor and costs for managing logistics operations. it can.

Although the second invention is not limited to this, a relay station in the middle of the customer route may be taken into consideration. This relay station is a place where the package is temporarily stored in the process of transporting the package to the final delivery place of the customer. Such a relay station is provided in each area where customers are located, or in important points during transportation.
It is placed for the purpose of ensuring delivery time to customers. In the case of providing such a relay station, generally, the factory side has jurisdiction before the relay station, and the sales department or the like may have jurisdiction after the relay station. When the jurisdiction is different as described above, the key information for retrieving the information about the package may be different. However, when considering the relay station in this way in the second aspect of the present invention, the physical distribution key described above is used for the primary transportation from the shipping source to the relay station and the secondary transportation from the relay station to the final delivery place of the customer. The sales key and the transportation path connection key may be shared. With such commonality, it is possible to easily perform both the information search for the physical distribution person and the information search for the sales person, regardless of before and after the relay station.

The second invention does not limit the above-mentioned transportation path connection key, physical distribution key, and sales key in detail. For example, the transportation pass connection key
Information indicating whether the item is "sold directly" or "manufactured", information indicating the loading point of the package, information indicating the landing point, information indicating the outgoing flight, primary transportation and secondary transportation May be configured by the information for distinguishing. For example, the above-mentioned physical distribution key may be composed of information indicating a factory to be shipped, information on a physical distribution type indicating a kind of a transported object, and information about a transportation means to be used, for example, information about a truck transportation distance or a transportation flight.
The above-mentioned sales key is also composed of information indicating the customer who ordered the package, information indicating the sales office handling the order, and information on the business type indicating the type of the package to be shipped. Good. Here, both the above-mentioned distribution type and sales type indicate the type of the target package, but they are set to be suitable for the information retrieval from the logistics department or the information retrieval from the sales department, respectively. May be.

[0049]

DETAILED DESCRIPTION OF THE INVENTION The first invention and the second invention will be described below.
An embodiment of a physical distribution cost management system to which the invention is applied will be described in detail with reference to the drawings.

First, the premise of the physical distribution cost management system of this embodiment will be described.

In recent years, the physical distribution environment has become more severe due to the problems of labor shortage and global environmental problems.
Considering how to deal with these issues, it is expected that logistics costs will increase in the future.

On the other hand, the conventional "rationalization of the inside of the distribution department for finished products" is approaching the limit of reducing the distribution cost. Therefore, it is necessary to reduce the physical distribution cost before the product is manufactured, for example, at the raw material stage of the product, and it is necessary to reduce the physical distribution cost as a whole by the sales and production departments.

In order to reduce such physical distribution costs,
It is important to work with sales and production departments to reduce distribution costs. Therefore, the purpose of the physical distribution cost management system of the present embodiment is as follows.

(1) To enable the sales department to carry out sales activities in consideration of distribution costs. To this end, the sales department should be able to easily obtain information on the distribution costs by customer route.

(2) When the distribution department formulates a profit plan, the distribution cost information can be more easily grasped at various points (types, transportation flights, transportation districts, etc.).

Here, the object of the present embodiment is physical distribution in the steel industry, which can be classified as follows.

(1) Classification according to the type of transported goods: raw material distribution, hot metal distribution, steelmaking distribution, semi-finished product distribution, product distribution, recovery distribution.

(2) Classification of distribution within the steelworks or distribution outside the steelworks: distribution within the factory and distribution outside the factory.

(3) Classification by accounting sorting: direct sales cost, manufacturing cost.

In the classification as described above, in the present embodiment, the product distribution is targeted, the distribution inside the steelworks and the distribution outside the steelworks are targeted, and the direct sales cost and the manufacturing cost can be sorted. . Here, in the classification according to the type of the transported goods, the other parts except the product distribution are managed in each factory, and the distribution cost on the site can be analyzed. Therefore, by grasping the distribution cost related to product distribution in this way, it becomes possible to manage the distribution cost common throughout the company.

Here, considering product distribution, it can be classified into on-site distribution, primary transportation from the factory to the relay station, and secondary transportation from the relay station to the final delivery place of the customer. Here, with respect to the on-site physical distribution portion, the data of the on-site physical distribution system (reference numeral 13 in FIG. 1) is used as the original data. On the other hand, for the off-site logistics, the data of the primary transportation cost payment system (reference numeral 15 in FIG. 1) is used as the primary data for the primary transportation, and the secondary transportation cost payment system (reference numeral 16 of the FIG. 1 is used for the secondary transportation. ) Is the source data.

There are a wide variety of domestic flights, trucks, small boats, barges, freight cars, etc., as the transportation flights targeted for the primary transportation.
The fare calculation differs depending on each transportation flight. On the other hand, as the secondary transportation, the charge is calculated for each work such as cargo handling, storage and delivery after the receipt of the relay station. Therefore, in the primary transportation cost payment system and the secondary transportation cost payment system, not only the data are dispersed in a plurality of databases, but also the handling unit of each data is different. That is, the primary transportation is an invoice unit for each transportation path at each transportation stage. For secondary transportation, it is a unit for issuing the final delivery to the final delivery place of the customer. Therefore, the handling unit is smaller in the secondary transportation data that covers the final delivery than in the primary transportation. Regarding the physical distribution on the premises, data regarding physical distribution is handled on a product-by-product basis, and this is also used in this embodiment.

Here, the basic idea of constructing the distribution cost management method of this embodiment is the following four points.

(1) 1 for inside and outside the venue, and for outside the venue
Consistently grasp product transportation including secondary transportation and secondary transportation: Actual data regarding physical distribution such as on-site, off-site primary transportation, and off-site secondary transportation have their locations dispersed. The timing of transportation is also different. In addition, the shape and product type also change when processing is performed at the destination. Therefore, it has been difficult to consistently grasp from the factory shipment to the final delivery place of the customer.

(2) Distribution cost information by customer (actual results /
Understanding standard): Conventional physical distribution cost information was known for each management key of the physical distribution department. Therefore, in order for the sales department to grasp the distribution cost for each customer, the information of the distribution department has to be processed again. In the present embodiment, for the information about the physical distribution cost to be handled, a management key for facilitating the information retrieval by the personnel of the physical distribution department (physical distribution key) and a management key for facilitating the information retrieval by the personnel of the sales department (A management key for a sales department, a group, a customer, etc., which is regarded as a sales key) is assigned. Therefore, the physical distribution cost information provided in the present embodiment can be provided to the physical distribution department and the sales department more easily and in a more suitable form.

(3) Diversification of the provision of information on the actual results of physical distribution: In order to improve the efficiency of physical distribution, it is necessary to be able to easily grasp the actual results of physical distribution such as physical distribution costs from various perspectives. . This embodiment is excellent in this point because various information provision screens (FIGS. 19 to 23 described later) are prepared.

The configuration of the physical distribution cost management system of this embodiment will be described below.

FIG. 1 is a block diagram showing the configuration of the physical distribution cost management system of this embodiment and a host system that provides original data to the physical distribution cost management system.

In FIG. 1, the first invention and the second invention are described.
Physical distribution cost management system 4 according to an embodiment to which the invention is applied
A zero configuration is shown. Further, the configuration of the host system 10 that provides the primitive data required by the physical distribution cost management system 40 is shown.

First, the physical distribution cost management system 40 includes a server computer system 42 and a large number of terminal computer systems 5.
1 to 56. The server computer system 42 and the terminal computer systems 51 to 56 are all configured on an EWS (engineering workstation),
They are mutually connected by a LAN (local area network) 43.

The LAN 43 is specifically an Ethernet which is frequently used in EWS. In some cases, six or more terminal computer systems 51 to 56 connected by the LAN 43 are provided, and the head office logistics planning department (distribution department), head office sales (sales department), each branch (mainly sales department). It is also located in the Chiba Works, Mizushima Works, Chita Works (above, factories). Here, a plurality of terminal computer systems may be placed at each placement location. For example, the head office logistics planning department may be equipped with a plurality of terminal computer systems. The terminal computer system 53 is arranged in each branch.

Next, in the server computer system 42, as shown in FIG. 1, a computer main body 60, a cost database 63 for each customer route, and a profit plan database 64.
It is composed of

The computer main body 60 is a cost database for each customer route based on the original data of the order entry system 12, the on-site physical distribution system 13, the primary transportation cost payment system 15 and the secondary transportation cost payment system 16 provided in the host system 10. The data of 63 is updated and the data of the profit plan database 64 is updated. Specifically, the download of the source data indicated by S1 is performed once (once every / 3 months), and the codes S2, S3, and S4 are used.
The source data indicated by is downloaded once (once a month) at regular intervals. The computer main body 60 updates the cost database 63 for each customer route and the profit plan database 64 based on the downloaded primitive data.

The operation of the host system 10 and the physical distribution cost management system 40 having such a configuration will be briefly described.

First, the original data in the host system 10 is periodically downloaded to the computer main body 60 of the physical distribution cost management system 40. The computer main body 60 is based on the thus downloaded primitive data, and as described later in detail, the cost database 6 for each customer route.
3 and the profit plan database 64 are created and updated. When the cost database 63 for each customer route and the profit plan database 64 are constructed in this way, in the server computer system 42, the first invention and the second invention.
An information providing system (physical distribution cost management system) to which the invention is applied is configured.

Then, the head office physical distribution planning department of the physical distribution department can use the terminal computer system 51 to obtain from the server computer system 42 the information on the desired physical distribution cost required as a physical distribution operator. The head office of the sales department uses the terminal computer system 52 for the head office sales, and the terminal computer system 53 for the branch which is also the sales department, and the server computer system 42 can obtain the information about the physical distribution cost peculiar to the sales person. Further, the Chiba Works, Mizushima Works, and Chita Works on the factory side can obtain information on the physical distribution cost peculiar to the factory from the server computer system 42 by using the terminal computer systems 54 to 56, respectively.

Next, the source data used by the physical distribution cost management system 40 included in the host system 10 will be described in more detail.

First, the source data provided in the host system 10 and particularly required by the physical distribution cost management system 40 are as follows:
In principle, the structure is shown in the table below. That is, the original data is composed of the key item KA and the data portion DA. The key item KA includes a physical distribution key KA1, a sales key KA2, a connection key KA3, and a payment key KA4, as shown in the table below. The data portion DA is composed of data DA1 including weight information and cost information.

[0079]

[Table 1]

Among the above-mentioned source data, the source data used in the physical distribution cost management system 40, especially in the primary transportation cost payment system 15, is composed of the key item KB and the data portion DB as shown in the table below. Composed. Further, the key item KB includes a physical distribution key KB1, a sales key KB2, and a connection key K as shown in the table below.
It is composed of B3 and a payment key KB4. Further, the data portion DB has a data DB 1 relating to a delivery service. Here, regarding such primitive data of the primary transportation cost payment system 15, the loading place of the connection key KB3 is the shipping place, and the landing place is the delivery place.

[0081]

[Table 2]

Next, the source data used by the physical distribution cost management system 40 provided in the secondary transportation cost payment system 16 is composed of a key item KC and a data portion DC, as shown in the table below. The key item KC is
As shown in the table below, it comprises a distribution key KC1, a sales key KC2, a connection key KC3, and a payment key KC4. Further, the data portion DC has data DC1 showing fixed costs relating to cargo handling, storage, delivery, maintenance of relay stations, etc., as shown in the table below. In the connection key KC3 in the original data of the secondary transportation cost payment system 16, the loading point indicates the relay station and the landing point indicates the delivery place.

[0083]

[Table 3]

Next, the data stored in each database of the physical distribution cost management system 40 of the present embodiment created based on the above-mentioned source data will be described.

First, as shown in the table below, the data stored in the cost database 63 for each customer route of the physical distribution cost management system 40 of this embodiment has the following configuration. That is, the data stored in the cost database 63 for each customer route is the key item KD.
And a data portion DD. The key item KD includes a physical distribution key KD1, a sales key KD2, and a connection key KD3 as shown in the table below. The data portion DD is composed of data DD1 regarding primary transportation and data DD2 regarding secondary transportation.

[0086]

[Table 4]

Next, the data stored in the profit plan database 64 in the physical distribution cost management system 40 has the structure shown in the following table. That is, the key item KE
And a data portion DE. The key item KE is the physical distribution key KE1 as shown in the table below.
, A sales key KE2, and a connection key KE3. The data portion DE is composed of data DE1 regarding primary transportation and data DE2 regarding secondary transportation.

[0088]

[Table 5]

As described above, the data stored in the cost database 63 for each customer route and the data stored in the profit plan database 64 include the basic source data described above and the source data stored in the primary transportation cost payment system 15. ,
Unlike the original data in the secondary transportation cost payment system 16, data relating to payment, for example payment keys KA4, K
B4 and KC4 are omitted. Although there is an enormous amount of such payment-related data in the original data, the customer route cost database 63 and the profit plan database 64 do not include such payment information. In addition, the processing time required for the search can be shortened.

Further, as will be described later in detail, compared with the distribution type and the sales type in the original data, the distribution type of the data in the cost database 63 for each customer route and the profit plan database 64 of the distribution cost management system 40 of the present embodiment and the distribution type of the data. The categorization of business varieties has been made rougher. Therefore, not only can the amount of data indicating the distribution type and the sales type in the present embodiment be reduced, but the search can be performed more efficiently.

Further, as is clear from a mutual comparison between the table showing the data stored in the cost database 63 for each customer route and the table showing the data stored in the profit plan database 64, as to the primary transportation, The key and the key for secondary transportation are the same. Therefore, it is also possible to retrieve the data related to the primary transportation and the data related to the secondary transportation at once using the common key.

Next, the generation and update of the data in the cost database 63 for each customer route and the data in the profit plan database 64 in this embodiment from the original data in the host system 10 will be described.

First, FIG. 2 is a diagram showing the data generation and update of the database of this embodiment based on the original data.

In FIG. 2, the host system 10
The physical distribution cost management system 40 according to the present embodiment.
The basic source data 18 used in FIG.
Further, the cost database 63 for each customer route of the present embodiment
And the data stored in the profit plan database 64 are shown.

First, the cost database 6 for each customer route
The physical distribution key KD1 and the sales key KD2 and the connection key KD3 stored in No. 3 and the physical distribution key KE1 and the sales key KE2 and the connection key KE3 stored in the profit plan database 64 are the physical distribution key Kn1 of the original data 18, respectively.
And generated or updated based on the sales key Kn2 and the connection key Kn3. Here, n is B or C.

Next, the data portion DE1 relating to the weight information and the expense information of the profit plan database 64 is the data portion Dn relating to the weight information and the expense information of the source data 18.
It is generated or updated based on 1. On the other hand, the data regarding the weight information and the cost information of the customer route-based cost database 63 is generated based on the data portion DE1 of the profit plan database 64.

The data of the primary transportation cost payment system 15 of the host system 10 and the secondary transportation cost payment system used for generating or updating the cost database 63 for each customer route in the physical distribution cost management system 40 of this embodiment. The 16 data are as follows.

(1) Customer route information (cost database for each customer route) 1A. Information from the primary transportation cost payment system 1A1. Key item 1A1a. Logistics Key (Factory, Logistics Type, Final Delivery Location) 1A1b. Sales key (consumer, sales contact, product type) 1A1c. Connection key (departure service, loading place, landing place, where loading place is factory / outsource and landing place is delivery place. Primary / secondary transportation category, direct sales / manufacturing category) 1A2. Data part (Import data with matching distribution key / sales key / connection key from interest rate DB. However, import weight / cost as planned unit price / actual unit price) 1B. Information from the secondary transportation cost payment system 1B1. Key item 1B1a. Logistics Key (Factory, Logistics Type, Final Delivery Location) 1B1b. Sales key (consumer, sales contact, product type) 1B1c. Connection key (departure flight, loading place, landing place, where loading place is a relay station and landing place is a delivery place. Primary / secondary transportation category, direct sales / manufacturing category) 1B2. Data part (Import data that matches the distribution key, sales key, and connection key from the interest rate DB. However, for weight and cost, import as planned unit price / actual unit price.)

Further, the data of the primary transportation cost payment system 15 of the host system 10 and the secondary transportation cost payment system used for updating or generating the data of the profit plan database 64 of the physical distribution cost management system 40 of the present embodiment. The 16 data are as follows.

(2) Profit plan information (profit plan database) 2A. Information from primary transportation cost payment system 2A1. Key item 2A1a. Logistics key (factory, logistics type, final delivery location) 2A1b. Sales key (consumer, sales counter, sales type) 2A1c. Connection key (departure flight, loading place, landing place, where loading place is factory / outsourcer and landing place is delivery place. Primary / secondary transportation category, direct sales / manufacturing category) 2A2. Data portion 2A2a. Delivery service {delivery weight, delivery cost (basic cost, other cost)} 2B. Information from the secondary transportation cost payment system 2B1. Key item 2B1a. Logistics key (factory, logistics type, final delivery place) 2B1b. Sales key (customer, sales contact, sales type) 2B1c. Connection key (departure flight, loading place, landing place, where the loading place is a relay station and the landing place is a delivery place. Primary / secondary transportation category, direct sales / manufacturing category) 2B2. Data portion 2B2a. Load weight, cargo handling cost (basic cost, other cost) 2B2b. Storage weight, storage cost (basic cost, other cost) 2B2c. Delivery weight, delivery cost (basic cost, other cost) 2B2d. Fixed cost (maintenance cost of relay station)

Next, the data (code) of the order type when the data of the cost database 63 for each customer route of the physical distribution cost management system 40 of this embodiment and the data of the profit plan database 64 are generated or updated from the original data. From, data of business type and distribution type (code)
A method of generating will be described.

First, as shown in FIG. 3, the sales department 6
When the order is received from the customer in step 7, the order type 67a is issued. The order type 67a is as many as 1000 types. After that, in the sales department 67, a sales type 67b for using the physical distribution cost management system 40 of the present embodiment.
Is generated from the order type 67a. This business type 67
b is about 75 types. Therefore, order type 67a
The ratio (N2: 1) of the number of products to the business product 67b is about 1
It is 3.3 (N2 is about 13.3), and the number of varieties can be reduced by more than one-third.

Then, in the distribution department 68, the order type 6
Based on 7a, a physical distribution product 68a for using the physical distribution cost management system 40 of the present embodiment is generated. This distribution type 68a is about 68 types. Therefore, the ratio of the number of product types of the order product 67a and the distribution product 68a (N1:
1) is about 14.7 (N1 is about 14.7), and the number of varieties can be reduced by 1/14 or more.

[0104] The commercial product 6 from the order product 67a
7b conversion method, or distribution type 6 from order type 67a
The conversion method of 8a is as shown in the table below.

[0105]

[Table 6]

The order type as shown in FIG. 4 has the following structure.

(1) Contract place code A code that uses one alphanumeric character and indicates a contract place outside Japan.

(2) Composition of product code Product code (3 digits) = roll classification (1 digit) + product (2
Digit) and is as shown in No. 1 and No. 2 of the table of "order type code" shown below. In addition, the code displayed immediately before each of the product names in Part 1 and Table 1 represents the following. “K”… Domestic “S”… In-house “Y”… Export “Blank”… Domestic, in-house, export common “*”… Not mechanized for order entry

(3) Serial number a. The contract G is issued when the contract is made. b. Numbers are assigned with care to avoid duplicate numbers within a short period of time. c. The "sequential number" may be divided in advance depending on the district, department, and other reasons. d. Grouping two or more types of head numbers and assigning serial numbers is not limited except for special cases.

[0110]

[Table 7]

[0111]

[Table 8]

The business type 67b converted from the order type 67a is as shown in the following table (No. 1 and No. 2 in the "business type code" table). The order type 67a has different systems for domestic, in-house, and export.

[0113]

[Table 9]

[0114]

[Table 10]

The distribution type 68a converted from the order type 67a is as shown in the following table (No. 1 and No. 2 in the "distribution type code" table).

[0116]

[Table 11]

[0117]

[Table 12]

As described above, in this embodiment, the number of product types of the business product 67b converted from the order product 67a is reduced to about one-third as compared with the order product 67a. Further, regarding the number of product types of the distribution product 68a converted from the order product 67a, the order product 67a
It is about 1/15 compared to Therefore, by reducing the number of products in this way, not only the storage capacity can be further reduced, but also the processing time required for the search can be shortened.

Next, the process of generating or updating the customer route information data performed by the physical distribution cost management system 40 of this embodiment will be described with reference to the flowchart.

FIG. 5 is a flow chart showing the process of creating or updating the customer route information data performed in the physical distribution cost management system of this embodiment.

In FIG. 5, first, at step 110, a performance collection process is performed. The performance collecting process is regularly performed on a predetermined day of every month. In the performance collection processing, downloading from the host system 10 to the physical distribution cost management system 40 as shown in FIG.
Data is distributed to and fetched from each database shown in FIG.

FIG. 6 is a block diagram showing the download of the original data from the host system to each database in the physical distribution cost management system of this embodiment.

In FIG. 6, as described above with reference to FIG. 1, the on-site physical distribution system 13, the primary transportation cost payment system 15 and the secondary transportation cost payment system 16 are provided in the host system 10. Also, on-site database 2
The first, the first ship database 24, the first truck database 25, the first other flight database 26 and the second database 28 are the physical distribution cost management system 4 of the present embodiment.
It is provided in the computer main body 60 of the server computer system 42 of 0.

Further, the original data of the on-site physical distribution system 13 is downloaded to the on-site database 21 and taken in. The primary data of the primary transportation cost payment system 15 is
The data is downloaded to the computer main body 60 in the server computer system 42, distributed to any of the primary ship database 24, the primary truck database 25, and the primary other flight database 26 and taken in. The source data of the secondary transportation cost payment system 16 is downloaded and loaded into the secondary database 28.

Further, in this step 110, based on the original data thus downloaded and taken in,
Key information of the cost database 63 for each customer route and the profit plan database 64, that is, transportation distribution identification key information data shown in FIGS. 7 and 8 to be described later is generated, and particularly the customer route shown in FIGS. 7 and 8 is generated. As part of the information data.

Subsequently, in step 114, it is determined whether or not the process is performed once every three months. If this determination is “Y”, it means that it is determined to execute the process that should be performed once every three months, and the process proceeds to step 142. If "N" is determined in step 114, it means that the process to be performed once a month is determined to be executed, and the process proceeds to step 118.

Subsequently, in step 142, the master file of the standard customer route is searched, and whether the customer route for transportation is the standard customer route or not, and the leftmost "standard / non-standard route" in FIGS. 7 and 8 is checked. Judgment is made based on the item "category data". In the following step 146, the profit plan database 6
Create 4.

On the other hand, if "N" is determined in the above step 114, route result information is created in step 118. This is the primary ship database 2 shown in FIG.
4, while using the data stored in the primary truck database 25, the primary other flight database 26, and the secondary database 28, from the data of the final transportation path that has been delivered to the customer to the upstream side of the transportation route ( The data of the transportation path is connected while sequentially tracking to the factory side), and finally the data of the transportation path departing from the factory is also connected. Such a process of connecting while sequentially tracking is to sequentially connect the data of the transportation path in the reverse order to the flow of the transportation physical distribution. Such a connection condition targets a transportation path in which the key information, that is, the physical distribution key and the sales key match, and the loading location of the front transportation path and the loading location of the rear transportation path match, and connects while sequentially tracking. . By such processing, the route tracking information data shown in FIGS. 7 and 8 is obtained.

Following this step 118 is a step 12
In step 8, it is judged whether or not it is a target for collecting results of the standard customer route or the non-standard customer route. When it is determined that there is the same route in the past and it is the target of such achievement collection, the process proceeds to step 130. On the other hand, if it is determined that it is not the target of the performance collection, the process proceeds to step 124,
It will be the next data collection target and the next performance collection target.

Here, in step 152 after the above-mentioned step 146, the process of adding the planned unit price is performed. Alternatively, when it is determined in step 128 that the target is the result collection target and the process proceeds to step 130, the process of adding the actual unit price and the actual amount is performed.

Here, these steps 152 and 130
Then, the key information, that is, the distribution key and the sales key are used as search keys, and the route configuration items (flight, loading place, landing place, 1
The next transportation or secondary transportation category, the direct sales or the production category) is used as a search key, and the on-site database 21, the primary ship database 24, the primary truck database 25, and the primary other flight database 26 or 2 shown in FIG. The next database 28 is searched to obtain the unit price and weight data of each transportation pass. The editing destination of the acquired information (unit price, weight) is determined from the category of courier, primary transportation or secondary transportation, and direct sales or manufacturing.

Here, the planned unit price is obtained by calculating the average of the actual unit prices in 3 months for one set of routes of loading and unloading, that is, one transportation pass. This is 3
It is calculated by dividing the total cost collected over the months by the amount collected over the same three months.

The actual unit price for 3 months obtained in this way may be used as it is as the planned unit price, but the actual unit price for 3 months is added to the cost reduction contents such as rate and efficiency. It is also possible to multiply by the ratio and use this as the planned unit price. The ratio of such content of cost reduction predicts the change in the actual unit price in the next 3 months,
This is due to consideration of discounts due to continuous orders or price increases due to some factors.

Next, the actual unit price is 1 for a set of routes of loading and unloading, that is, one transportation path.
Based on the actual collection of monthly expenses and the actual collection of monthly amounts, it is calculated as a monthly actual unit price. Specifically, the actual unit price is calculated as an average cost for one month, which is obtained by dividing the total sum of costs actually collected in one month by the total sum of amounts collected in one month.

When the processing of these steps 152 or 130 is completed, the planned unit price information data or the actual unit price weight information data is added to the customer route information data shown in FIG. 7, and the result is shown in FIG. It is possible to obtain customer route information data as described above.

The process performed in step 142 of FIG. 5 is performed as shown in FIGS. 9 to 13.
In addition, the processing performed in step 118 described above in FIG.
This is done as shown in FIGS.

First, FIG. 9 shows the original data to be processed in step 142, and the respective transportation paths are isolated. First, the first transportation path is a transportation path from N1 (factory) to N2a (relay station). The second transportation path is a transportation path from N2b (relay station) to N3a (outsourcer). The third transportation path that follows is N
It is a transportation path from 3b (outsourcer) to N4 (consumer). Here, N2a and N2b both indicate the same relay station. Further, both N3a and N3b indicate the same subcontractor.

Then, referring to FIG.
The processing of the root connection of process 1 performed in 2 is shown. This process is performed once every three months. In addition, this route connection process starts from the third transportation pass to which the data that it is the final transportation pass is added, the distribution key and the sales key match, and the landing site and the subsequent transportation pass of the previous transportation pass In this process, the transportation paths that coincide with the loading points are sequentially connected to finally reach the shipping factory. By such processing, all the transportation paths from the third transportation path to the first transportation path are connected, and the customer route consisting of these transportation paths can be grasped consistently.

FIG. 11 shows the process 2 performed in step 142, in which the standard or non-standard customer route is determined. This decision is made once every three months,
It is done regularly. Further, this determination is to determine whether the customer route that has become the actual result has passed the standard customer route or the non-standard customer route. Further, such a determination is made by comparing the customer route, which is the actual target, with the route A (standard route) shown in FIG. 11, or with the route B (non-standard route). Further, after such a comparison judgment, the transportation modes and unit prices of the standard route and the non-standard route are compared. As a result, the abnormal route is grasped.

The process 2 is to judge whether the route information created in the process 1 described above with reference to FIG. 10 is a standard route for the transportation route master in the order entry system. .

When it is determined that the route is the standard route in the process 2 of FIG. 11, the process 3a shown in FIG. 12 is performed. On the other hand, when it is determined that the route is a nonstandard route, the process 3b shown in FIG. 13 is performed.

First, the process 3a shown in FIG.
If the process 2 determines that the route is the standard route, the process is performed once every three months in step 142 of FIG. 5 described above. This process 3a is a process of adding cost information (plan unit price) to the standard route. This planned value reflects the efficiency / rate on the actual results. Further, such a planned value is data for one set of routes for loading and unloading land, that is, for each transportation path.

Next, the process 3b shown in FIG.
When it is determined that the route is a non-standard route in the process 2 described above, the process is performed once every three months in step 142 of FIG.
It is done regularly. Also, the processing of this process 3b is
This is a process of adding cost information (plan unit price) to a non-standard route. Further, this planned value reflects the efficiency / rate on the actual results. Also, this is a set of routes for loading and unloading land, that is, data for each transportation path.

Next, the processing shown in FIGS. 14 to 17 which is performed in step 118 of FIG. 5 will be described.

First, FIG. 14 is the same as the route connection processing described above with reference to FIG. 10, but is performed once a month at regular intervals. The method of this route connection and the conditions at this time are also the same as those in FIG.

Subsequently, in FIG. 15, it is judged whether the route is a standard route or a non-standard route, which is the same as the process of FIG. 11 described above. The process of FIG. 11 is performed once every three months as described above, whereas the process of FIG. 15 is performed regularly once a month. When it is determined that the route is the standard route in the process 15 of FIG. 15, the process 6a of FIG. 16 is performed. On the other hand, when it is determined that the route is a nonstandard route, the process 6b of FIG. 17 is subsequently performed.

First, in the process 6a of FIG. 16, the process of adding cost information (actual unit price) to the standard route is performed once a month on a regular basis. This is to compare the planned unit price with the actual unit price for the actual results that have passed the standard route. As a result, it is possible to find the cause of the increase in physical distribution costs. The actual value is obtained from the host system 10 every month. In addition, such a process of adding cost information (unit price) is performed on the data for each transportation path.

Subsequently, the process 6b of FIG. 17 performs the process of adding the cost information (unit cost) to the non-standard route.
It is to be done once a month on a regular basis. This is to compare the planned unit price and the actual unit price with respect to the actual result of passing through the non-standard route, and is for investigating the cause of the increase in the physical distribution cost. Also in this process 6b, the actual value is fetched from the host system 10 every month as in the process 6a described above. In addition, the process related to the cost information addition (actual unit price) that is performed is performed for each transportation path.

Next, the display screen in this embodiment will be described with reference to FIGS.

First, FIG. 18 is a flow chart showing the flow of selecting each screen shown in FIGS.

As shown in step 180 of FIG. 18, the initial screen of this embodiment is the search condition input screen shown in FIG. Based on the data input on the search condition input screen, subsequently, as shown in step 182, the customer-specific physical distribution cost inquiry key screen shown in FIG. 20 is displayed. Further, based on the input made on the customer-by-customer physical distribution cost inquiry key screen, the customer-by-customer physical distribution cost inquiry direct sales detail screen shown in FIG. 21 in step 184 or the customer-specific route information screen shown in FIG. 22 in step 186. Is displayed. Further, in response to the input on the customer-specific route information screen, the customer-specific route information sales detail screen shown in FIG. 23 in step 188 is displayed.

As described above, in the present embodiment, the customer route information data shown in FIGS. 7 and 8 can be created while applying the first invention, and a diagram based on the customer route information data can be created. Information can be provided on the screens shown in FIGS. Further, at this time, since various data are configured while applying the second invention, not only the storage capacity can be further reduced, but also the processing such as search can be performed more efficiently. . Therefore, according to the present embodiment, it is possible to grasp the comprehensive physical distribution cost from the shipping source to the final delivery place of the customer for the transportation of the ordered goods in the sales department, and to improve the distribution cost. In addition to facilitating analysis and management such as finding routes, it is possible to further reduce or reduce the information necessary for this purpose, aiming to reduce logistics costs and labor for managing logistics operations. It is possible to obtain the excellent effect that the cost can be reduced.

In particular, it is possible to refer to the information on the physical distributions of the primary transportation and the secondary transportation, which have been dispersed in the past, in a linked form as a consistent transportation route. For example, even if the product type changes before and after processing occurs, or there is a transport timing difference, it is possible to absorb the change and timing difference of these product types and sequentially trace the transport path to create a transport route. it can. Further, it is possible to more easily ascertain the physical distribution cost of the on-site product, the out-of-site primary transport cost, and the out-of-site secondary transport cost for each created transportation route.

Regarding the transportation route, the physical distribution cost can be referred to for each of the standard route and the non-standard route. Further, the sales department can grasp the distribution cost more finely. Further, in the physical distribution department, for example, the planned physical distribution cost and the actual physical distribution cost for each transportation route can be referred to more easily, and the physical distribution cost according to the transportation means, the presence / absence of a relay station, the transportation distance, etc. Since the cost breakdown can be referred to more easily, it becomes possible to more efficiently carry out logistics cost improvement activities.

[0155]

As described above, according to the first invention and the second invention, the comprehensive physical distribution of the transportation of the goods ordered by the sales department from the sender to the final delivery place of the customer. For convenience of analysis and management such as grasping the cost and finding a better customer route in terms of distribution cost, etc., the information necessary for this can be more organized and reduced or reduced. It is possible to obtain an excellent effect that it is possible to provide a physical distribution cost management method capable of reducing the labor and the cost for managing the physical distribution business.

[Brief description of drawings]

FIG. 1 is a block diagram showing a configuration of a physical distribution cost management system to which a physical distribution cost management method of the first invention and the second invention of the present application is applied, and a host system for providing source data to the physical distribution cost management system.

FIG. 2 is a block diagram showing a flow of data generation or update of a customer route cost database and a profit plan database from the original data in the embodiment.

FIG. 3 is a block diagram showing a process of generating a commercial product and a distribution product from the order product in the embodiment.

FIG. 4 is a data configuration diagram of the order type used in the embodiment.

FIG. 5 is a flowchart showing a process for creating and updating customer route information data performed in the embodiment.

FIG. 6 is a block diagram showing the configuration of each system in the host system and each database in the physical distribution cost management system from which original data is downloaded.

FIG. 7 is a data configuration diagram showing the first stage customer route information data generated in the embodiment.

FIG. 8 is a data configuration diagram showing second stage customer route information data generated in the embodiment.

FIG. 9 is a diagram showing the data of the transportation path of the original data which constitutes a certain customer route in the embodiment.

FIG. 10 is a diagram showing Process 1 of processing relating to route connection and physical distribution cost in the embodiment.

FIG. 11 is a diagram showing Process 2 of processing relating to route connection and physical distribution cost in the embodiment.

FIG. 12 is a diagram showing a process 3a of processing relating to route connection and physical distribution cost in the embodiment.

FIG. 13 is a diagram showing a process 3b of a process relating to route connection and physical distribution cost in the embodiment.

FIG. 14 is a diagram showing Process 4 of a process relating to route connection and physical distribution cost in the embodiment.

FIG. 15 is a diagram showing Process 5 of processing relating to route connection and physical distribution cost in the embodiment.

FIG. 16 is a diagram showing a process 6a of a process relating to route connection and physical distribution cost in the embodiment.

FIG. 17 is a diagram showing a process 6b of a process relating to route connection and physical distribution cost in the embodiment.

FIG. 18 is a flowchart showing selection switching of display screens in the embodiment.

FIG. 19 is a diagram showing a search condition input screen in the embodiment.

FIG. 20 is a diagram showing a distribution cost inquiry key screen for each customer in the embodiment.

FIG. 21 is a diagram showing a customer distribution cost inquiry direct sales detail screen in the embodiment.

FIG. 22 is a diagram showing a route information screen for each customer in the embodiment.

FIG. 23 is a diagram showing a route information sales direct detail screen for each customer in the embodiment.

[Explanation of symbols]

 10 ... Host system 12 ... Order entry system 13 ... On-site logistics system 15 ... Primary transportation cost payment system 16 ... Secondary transportation cost payment system 21 ... On-site database 24 ... Primary ship database 25 ... Primary truck database 26 ... Primary Other flight database 28 ... Secondary database 40 ... Logistics cost management system 42 ... Server computer system 43 ... LAN 51-56 ... Terminal computer system 60 ... Computer main body 63 ... Customer route cost database 64 ... Profit planning database 18 ... Primitive data 67 … Sales department 67a… Order product 67b… Business product 68… Logistics department 68a… Distribution product

Claims (4)

[Claims] 1. A logistics cost management method for a customer route, comprising a plurality of transportation paths according to a plurality of transportation stages, of a route for transporting a packaged product from a shipping source to a final delivery place of a customer, wherein: For each transportation path, transportation path data having a package identification key and transportation path connection key, distribution cost data, payment information data used for payment to the transportation operator, and final delivery after delivery to the customer. When creating the original data including the final transportation path information data indicating whether or not it is a transportation path and creating the customer route information data for grasping the customer route, first, The final transportation path that has been handed over is found, and the customer route leading to the final transportation path is used as an information tracking customer route. A transportation path having the same loading point as the transportation path is sequentially traced from the final transportation path to the upstream side of the transportation route and connected, and route tracking information data of the information tracking customer route is created based on the original data. At the same time, while collecting the information about the distribution cost of the information tracking customer route from the original data, the customer route distribution cost data is created, and the customer route information data is created from the route tracking information data and the customer route distribution cost data. A logistics cost management method characterized by: 2. The claim 1, wherein a plurality of different customer routes for transporting the same package from the same shipper to the final delivery place of the same customer are managed so that the delivery condition specified by the customer can be satisfied. In addition, one of the plurality of customer routes, which has a stable transportation system for each transportation path and has a smaller total distribution cost over the entire customer route, is a standard customer route. When providing the customer route information data that is specified according to the designation of the package identification key, the transportation of the package from the sender of the package specified by the package identification key to the customer is performed. A physical distribution cost management method comprising providing a plurality of pieces of customer route information of a customer route that is the standard customer route and a customer route that is not the standard customer route. 3. A logistics cost management of a customer route constituted by a plurality of transportation paths according to a plurality of transportation stages, which is a route for transporting a package ordered by a sales department from a shipping source to a final delivery place of a customer. In the method, in advance, for each transportation path, transportation path data having a package identification key and a transportation path connection key, distribution cost data, payment information data used for payment to a transportation operator, and a customer In addition to creating the original data including the final transportation path information data indicating the final transportation path for which the delivery is completed, the logistics key for the convenience of information retrieval of the logistics operator from the original data and the sales person's A logistics management database having a sales key and a transportation path connection key for the convenience of information retrieval, while reducing the payment information data,
A physical distribution cost management method characterized in that it is created while reducing the information indicating the type of package. 4. The primary transportation from the shipping source to the relay station according to claim 3, taking into consideration a relay station in the middle of the customer route that transports the packaged goods from the shipping source to the final delivery place of the customer. A physical distribution cost management method characterized in that the physical distribution key, the business key, and the transportation path connection key are commonly used for secondary transportation from a base to a final delivery place of a customer.