JP4219372B2 - Unit cost calculation device and program - Google Patents

Description

  The present invention relates to a logistics cost per unit time of a certain logistics facility, a logistics cost per unit time of a certain work process of a certain logistics facility, and a unit quantity of a certain product in a certain work process of a certain logistics facility. The present invention relates to a unit cost calculation device for calculating per-distribution costs, a unit cost calculation program for causing a computer to function as a unit cost calculation device, and a unit cost calculation method.

Calculate the cost per unit time of a logistics facility, the cost per unit time of a work process of a logistics facility, and the cost per unit quantity of a product in a work process of a logistics facility No function, a device having the function, or a method for realizing the function is provided.
For example, storage cost of one PC (the number of units of the product) at a certain logistics facility, storage cost of a car engine plug box (the number of units of the product), one carton of cigarettes (the number of units of the product) No apparatus, computer program, or method for calculating the delivery cost of the product, the delivery cost of delivering one printer from a certain logistics facility to the customer is provided.
Also, logistics costs per unit time (eg, per working day, per working time, etc.) of a certain logistics facility, and per unit time (eg, operation) of a certain work process (eg, warehousing process) of a certain logistics facility. No device, computer program or method for calculating logistics costs per day, per hour of operation, etc. is provided.
Conventionally, there are costs referred to as logistics costs, which are, for example, costs for carriages, personnel costs for employees involved in logistics operations, depreciation costs for logistics facilities, and the like.

Japanese Unexamined Patent Application Publication No. 2004-118321 (Patent Document 1) describes a technology related to an analysis server, a distribution cost analysis method, and a distribution cost analysis program for analyzing costs necessary for inventory management in a distribution center.
However, the publication discloses a cost per unit time of a certain logistics facility, a cost per unit time of a certain work process of a certain logistics facility, a unit of a certain product in a certain work process of a certain logistics facility. There is no description about the method of calculating the cost per unit quantity.

Japanese Patent Application Laid-Open No. 2004-118321.

In order to improve logistics facility operations and reduce logistics costs, it is possible to compare logistics costs per unit time (eg, per working day, per working time, etc.) between one logistics facility and another. It is necessary to do so. For this purpose, it is necessary to be able to calculate the logistics cost per unit time (eg, per working day, per working time, etc.) of a certain logistics facility.
Similarly, in order to improve a certain work process (eg, warehousing process) of a logistics facility and reduce the logistics cost, a corresponding work process of a certain logistics facility and another corresponding logistics process It is necessary to be able to compare logistics costs per unit time (eg, per working hour, per working hour, etc.). For that purpose, it is necessary to be able to calculate the logistics cost per unit time (eg, per working day, per working time, etc.) of a certain work process (eg, warehousing process) of a certain logistics facility.
In order to further reduce the cost of delivering a product to a customer, the cost of delivering the product through a certain logistics facility can be compared with the cost of delivering the product through another logistics facility. It is necessary to make it. For this purpose, it is necessary to be able to calculate the distribution cost per unit quantity of a certain product in each work process of a certain distribution facility.

  The present invention relates to a distribution cost per unit time of an arbitrary logistics facility, a logistics cost per unit time of an arbitrary work process of an arbitrary logistics facility, and a unit quantity of an arbitrary product in each operation process of an arbitrary logistics facility. An object of the present invention is to provide an apparatus, a program, and a method for calculating the physical distribution cost.

The present invention is configured as the following [1] to [ 10 ].
[1] Configuration 1:
Configurations 1 to 6 are devices for determining unit costs (facility unit costs) of a logistics facility.
Configuration 1 is configured as follows.
Profit and loss statement, balance sheet, employee table that can obtain the total number of employees, the total number of logistics workers, and the number of logistics workers at each logistics facility, and the total number of transport vehicles and standard vehicle conversion in terms of standard vehicle A storage device that holds a transport vehicle table capable of acquiring the number of transport vehicles of each logistics facility, interest rate data, and an inventory table capable of acquiring the stock amount of each logistics facility;
In the selling expenses, the expenses for the spatial and / or temporal movement of the goods are classified into the expenses for delivery of the goods and the expenses for non-delivery and are acquired from the income statement of the storage device, and the general administrative expenses From the income statement, the cost acquisition unit;
An employee data acquisition unit for acquiring the total number of employees, the total number of logistics workers, and the number of logistics workers at each logistics facility based on the data in the employee table of the storage device;
A logistics rate calculation unit that divides the total number of logistics workers acquired by the employee data acquisition unit by the total number of employees and sets the logistics rate;
The value obtained by multiplying the general management cost acquired by the cost acquisition unit by the distribution rate calculated by the distribution rate calculation unit and the non-delivery cost acquired by the cost acquisition unit is added as the total logistics operation cost. Total business cost calculation department,
An interest payment data acquisition unit that acquires the total stock from the balance sheet of the storage device, and acquires interest rate data of the storage device;
A total interest payment cost calculation unit that multiplies the total inventory acquired by the interest payment data acquisition unit by the interest data acquired by the interest payment data acquisition unit to obtain a total amount of logistics interest payments,
A vehicle cost acquisition unit for acquiring the total number of transport vehicles in terms of standard vehicle grades and the number of transport vehicles in each logistics facility in terms of standard vehicle grades based on data in the transport vehicle table of the storage device;
A vehicle rate calculating unit that divides the number of transport vehicles of any physical distribution facility acquired by the vehicle cost acquisition unit by the total number of transport vehicles and sets the vehicle rate of the physical distribution facility;
A facility vehicle cost calculation unit that multiplies the delivery cost acquired by the cost acquisition unit by the vehicle rate calculated by the vehicle rate calculation unit and sets the vehicle usage annual cost of the logistics facility corresponding to the vehicle rate;
A personnel rate calculation unit that divides the number of logistics workers in any logistics facility acquired by the employee data acquisition unit by the total number of logistics workers and sets the logistics facility personnel rate;
The facility operation cost calculation unit which multiplies the logistics operation total cost calculated by the operation total cost calculation unit by the personnel rate calculated by the personnel rate calculation unit to obtain the logistics operation annual cost of the logistics facility corresponding to the personnel rate. When,
An inventory amount acquisition unit for acquiring an inventory amount of an arbitrary logistics facility based on data in an inventory table of the storage device;
An inventory rate calculation unit that divides the inventory amount acquired by the inventory amount acquisition unit by the total amount of inventory acquired by the interest payment data acquisition unit and sets the inventory rate of the logistics facility corresponding to the inventory amount;
The facility interest rate calculated as the annual interest expense of the logistics facility corresponding to the inventory rate by multiplying the total amount of logistics interest payment calculated by the total interest payment cost unit by the inventory rate calculated by the inventory rate calculation unit. Payment expense calculation part,
With respect to the same logistics facility, a facility annual cost calculation unit that adds the vehicle usage annual cost, the logistics service annual cost, and the logistics interest payment annual cost as the facility annual cost of the logistics facility;
A facility unit cost calculation unit that divides the facility year cost calculated by the facility year cost calculation unit by a predetermined value to be a facility unit cost of a unit period determined by the predetermined value;
A unit cost calculation device comprising:

Tables such as an employee table, a transport vehicle table, and an inventory table may each be configured as a single table, but are configured to perform the function of the table by linking a plurality of tables. Also good. For example, the transport vehicle table is configured by linking a truck table and a vehicle case conversion table in the embodiment described later.
A logistics worker is a person engaged in physical work. Here, the physical work means a work for moving an article (product) (moving in time and / or space). Accordingly, a person who belongs to a department not involved in the movement of goods (goods) such as development, production, accounting, general management, sales, etc. is not a logistics worker.
When a certain person is engaged in both physical work and non-physical work, the counting may be performed based on the ratio of working hours of both work of the certain person. For example, 70% of the working hours are counted as “0.7 people” who are engaged in physical work. Further, instead of this method, a method of belonging to a task having a larger work time ratio may be employed. For example, a person whose physical work is more than half of the working hours is counted as a logistics worker, and a person who is less than half is counted as a non-logistics worker.
As the delivery cost, a delivery charge is used in the embodiment described later. In addition, as non-delivery costs, in the embodiments described later, acceptance charges, outsourcing charges, and other charges are used. These are merely examples, and for example, when the costs related to delivery are large among the outsourced items, the outsourced items may be handled as the costs for delivery.
Examples of the predetermined value used by the facility unit cost calculation unit include the same period as the settlement period, the number of operating months during the settlement period, the number of working days during the settlement period, and the number of operating hours during the settlement period. The unit periods in that case are the settlement period, January, 1st, and 1 hour, respectively.

[2] Configuration 2:
Configuration 2 is a configuration that is simplified from Configuration 1 by omitting each requirement related to interest payment. That is, it is configured as follows.
Profit and loss statement, employee table that can obtain the total number of employees, the total number of logistics workers, and the number of logistics workers at each logistics facility, and the total number of transport vehicles in terms of standard vehicles and each logistics facility in terms of standard vehicles A transport vehicle table capable of acquiring the number of transport vehicles, and a storage device holding the transport vehicle table,
In the selling expenses, the expenses for the spatial and / or temporal movement of the goods are classified into the expenses for delivery of the goods and the expenses for non-delivery and are acquired from the income statement of the storage device, and the general administrative expenses From the income statement, the cost acquisition unit;
An employee data acquisition unit for acquiring the total number of employees, the total number of logistics workers, and the number of logistics workers at each logistics facility based on the data in the employee table of the storage device;
A logistics rate calculation unit that divides the total number of logistics workers acquired by the employee data acquisition unit by the total number of employees and sets the logistics rate;
The value obtained by multiplying the general management cost acquired by the cost acquisition unit by the distribution rate calculated by the distribution rate calculation unit and the non-delivery cost acquired by the cost acquisition unit is added as the total logistics operation cost. Total business cost calculation department,
A vehicle cost acquisition unit for acquiring the total number of transport vehicles in terms of standard vehicle grades and the number of transport vehicles in each logistics facility in terms of standard vehicle grades based on data in the transport vehicle table of the storage device;
A vehicle rate calculating unit that divides the number of transport vehicles of any physical distribution facility acquired by the vehicle cost acquisition unit by the total number of transport vehicles and sets the vehicle rate of the physical distribution facility;
A facility vehicle cost calculation unit that multiplies the delivery cost acquired by the cost acquisition unit by the vehicle rate calculated by the vehicle rate calculation unit and sets the vehicle usage annual cost of the logistics facility corresponding to the vehicle rate;
A personnel rate calculation unit that divides the number of logistics workers in any logistics facility acquired by the employee data acquisition unit by the total number of logistics workers and sets the logistics facility personnel rate;
The facility operation cost calculation unit which multiplies the logistics operation total cost calculated by the operation total cost calculation unit by the personnel rate calculated by the personnel rate calculation unit to obtain the logistics operation annual cost of the logistics facility corresponding to the personnel rate. When,
With respect to the same logistics facility, a facility annual cost calculation unit that adds the annual cost of using the vehicle and the annual cost of the logistics business to determine the facility annual cost of the logistics facility;
A facility unit cost calculation unit that divides the facility year cost calculated by the facility year cost calculation unit by a predetermined value to be a facility unit cost of a unit period determined by the predetermined value;
A unit cost calculation device comprising:

[3] Configuration 3:
Configuration 3 is a configuration in which the handling of the transportation vehicle is simplified in configuration 1. That is, it is configured as follows.
Profit and loss statement, balance sheet, employee table that can obtain the total number of employees, total number of logistics workers and number of logistics workers at each logistics facility, total number of transportation vehicles and number of transportation vehicles at each logistics facility can be obtained A storage device that holds a transport vehicle table, interest rate data, and an inventory table from which the stock amount of each logistics facility can be acquired;
In the selling expenses, the expenses for the spatial and / or temporal movement of the goods are classified into the expenses for delivery of the goods and the expenses for non-delivery and are acquired from the income statement of the storage device, and the general administrative expenses From the income statement, the cost acquisition unit;
An employee data acquisition unit for acquiring the total number of employees, the total number of logistics workers, and the number of logistics workers at each logistics facility based on the data in the employee table of the storage device;
A logistics rate calculation unit that divides the total number of logistics workers acquired by the employee data acquisition unit by the total number of employees and sets the logistics rate;
The value obtained by multiplying the general management cost acquired by the cost acquisition unit by the distribution rate calculated by the distribution rate calculation unit and the non-delivery cost acquired by the cost acquisition unit is added as the total logistics operation cost. Total business cost calculation department,
An interest payment data acquisition unit that acquires the total stock from the balance sheet of the storage device, and acquires interest rate data of the storage device;
A total interest payment cost calculation unit that multiplies the total inventory acquired by the interest payment data acquisition unit by the interest data acquired by the interest payment data acquisition unit to obtain a total amount of logistics interest payments,
A vehicle cost acquisition unit for acquiring the total number of transport vehicles and the number of transport vehicles at each logistics facility based on the transport vehicle table data of the storage device;
A vehicle rate calculating unit that divides the number of transport vehicles of any physical distribution facility acquired by the vehicle cost acquisition unit by the total number of transport vehicles and sets the vehicle rate of the physical distribution facility;
A facility vehicle cost calculation unit that multiplies the delivery cost acquired by the cost acquisition unit by the vehicle rate calculated by the vehicle rate calculation unit and sets the vehicle usage annual cost of the logistics facility corresponding to the vehicle rate;
A personnel rate calculation unit that divides the number of logistics workers in any logistics facility acquired by the employee data acquisition unit by the total number of logistics workers and sets the logistics facility personnel rate;
The facility operation cost calculation unit which multiplies the logistics operation total cost calculated by the operation total cost calculation unit by the personnel rate calculated by the personnel rate calculation unit to obtain the logistics operation annual cost of the logistics facility corresponding to the personnel rate. When,
An inventory amount acquisition unit for acquiring an inventory amount of an arbitrary logistics facility based on data in an inventory table of the storage device;
An inventory rate calculation unit that divides the inventory amount acquired by the inventory amount acquisition unit by the total amount of inventory acquired by the interest payment data acquisition unit and sets the inventory rate of the logistics facility corresponding to the inventory amount;
The facility interest rate calculated as the annual interest expense of the logistics facility corresponding to the inventory rate by multiplying the total amount of logistics interest payment calculated by the total interest payment cost unit by the inventory rate calculated by the inventory rate calculation unit. Payment expense calculation part,
With respect to the same logistics facility, a facility annual cost calculation unit that adds the vehicle usage annual cost, the logistics service annual cost, and the logistics interest payment annual cost as the facility annual cost of the logistics facility;
A facility unit cost calculation unit that divides the facility year cost calculated by the facility year cost calculation unit by a predetermined value to be a facility unit cost of a unit period determined by the predetermined value;
A unit cost calculation device comprising:

[4] Configuration 4:
Configuration 4 is a configuration in which each requirement related to interest payment in Configuration 1 is omitted and handling of the transportation vehicle is simplified. That is, it is configured as follows.
Income statement, employee table that can obtain the total number of employees, total number of logistics workers and the number of logistics workers at each logistics facility, transportation vehicle table that can obtain the total number of transportation vehicles and the number of transportation vehicles at each logistics facility, A storage device holding
In the selling expenses, the expenses for the spatial and / or temporal movement of the goods are classified into the expenses for delivery of the goods and the expenses for non-delivery and are acquired from the income statement of the storage device, and the general administrative expenses From the income statement, the cost acquisition unit;
An employee data acquisition unit for acquiring the total number of employees, the total number of logistics workers, and the number of logistics workers at each logistics facility based on the data in the employee table of the storage device;
A logistics rate calculation unit that divides the total number of logistics workers acquired by the employee data acquisition unit by the total number of employees and sets the logistics rate;
The value obtained by multiplying the general management cost acquired by the cost acquisition unit by the distribution rate calculated by the distribution rate calculation unit and the non-delivery cost acquired by the cost acquisition unit is added as the total logistics operation cost. Total business cost calculation department,
A vehicle cost acquisition unit for acquiring the total number of transport vehicles and the number of transport vehicles at each logistics facility based on the transport vehicle table data of the storage device;
A vehicle rate calculating unit that divides the number of transport vehicles of any physical distribution facility acquired by the vehicle cost acquisition unit by the total number of transport vehicles and sets the vehicle rate of the physical distribution facility;
A facility vehicle cost calculation unit that multiplies the delivery cost acquired by the cost acquisition unit by the vehicle rate calculated by the vehicle rate calculation unit and sets the vehicle usage annual cost of the logistics facility corresponding to the vehicle rate;
A personnel rate calculation unit that divides the number of logistics workers in any logistics facility acquired by the employee data acquisition unit by the total number of logistics workers and sets the logistics facility personnel rate;
The facility operation cost calculation unit which multiplies the logistics operation total cost calculated by the operation total cost calculation unit by the personnel rate calculated by the personnel rate calculation unit to obtain the logistics operation annual cost of the logistics facility corresponding to the personnel rate. When,
With respect to the same logistics facility, a facility annual cost calculation unit that adds the annual cost of using the vehicle and the annual cost of the logistics business to determine the facility annual cost of the logistics facility;
A facility unit cost calculation unit that divides the facility year cost calculated by the facility year cost calculation unit by a predetermined value to be a facility unit cost of a unit period determined by the predetermined value;
A unit cost calculation device comprising:

[5] Configuration 5:
Income statement, employee table that can obtain the total number of employees, total number of logistics workers and the number of logistics workers at each logistics facility, transportation vehicle table that can obtain the total number of transportation vehicles and the number of transportation vehicles at each logistics facility, A storage device holding
In the selling expenses, the expenses for the spatial and / or temporal movement of the goods are classified into the expenses for delivery of the goods and the expenses for non-delivery and are acquired from the income statement of the storage device, and the general administrative expenses From the income statement, the cost acquisition unit;
Costs related to logistics operations are determined based on the total number of logistics workers and the total number of employees in the general management costs acquired by the cost acquisition unit, and the calculated costs and non-delivery costs acquired by the cost acquisition unit Total operation cost calculation department with the sum of
Of the delivery costs acquired by the cost acquisition unit, a cost to be allocated to a certain logistics facility is obtained based on the number of transport vehicles and the total number of transport vehicles of the logistics facility, and the obtained cost is determined by the vehicle of the logistics facility. Facility vehicle cost calculation part to be used as the annual cost of use,
Of the logistics business costs calculated by the business cost calculation unit, a cost to be allocated to a certain logistics facility is obtained based on the number of logistics workers in the logistics facility and the total number of logistics workers, and the obtained cost is The facility operation cost calculation section, which is the annual logistics operation cost of the facility,
A facility unit cost calculation unit that divides the sum of the vehicle use annual cost and the logistics service annual cost related to the same logistics facility by a predetermined value and sets the unit cost of the unit period determined by the predetermined value;
A unit cost calculation device comprising:

[6] Configuration 6:
In configuration 5,
The storage device further holds a balance sheet, interest rate data, and an inventory table from which the inventory amount of each logistics facility can be acquired,
Further, among the total amount of logistics interest payments obtained by multiplying the total inventory of the balance sheet held by the storage device by the interest rate determined by the interest rate data, the cost to be allocated to a certain logistics facility is the inventory amount of the logistics facility. And a facility interest payment cost calculation unit that determines the calculated cost as the annual cost of logistics interest payment of the logistics facility,
The facility unit cost calculation unit divides the sum of the vehicle use annual cost, the logistics service annual cost and the logistics interest payment annual cost for the same logistics facility by a predetermined value, and the facility unit cost for a unit period determined by the predetermined value, To
A unit cost calculation device characterized by that.

[7] Configuration 7:
The configuration 7 has a function of obtaining a unit cost of the work process (process unit cost) in addition to the unit cost of the logistics facility (facility unit cost). That is, it is configured as follows.
In Configuration 2, Configuration 4, or Configuration 5,
The storage device is further capable of acquiring facility year work hours, which is the sum of work hours for each logistics facility in the settlement period, for each logistics facility, and for each logistics facility in the settlement period and excluding the delivery process. We have a work performance table that can obtain the process year work time, which is the sum of other work hours, by logistics facility and by work process excluding the delivery process,
further,
The cost to be allocated to a certain work process excluding the delivery process in the distribution work annual cost of a certain logistics facility calculated by the facility work cost calculation unit, the process year work time of the work process and the facility of the logistics facility A process annual cost calculation unit that calculates the calculated cost based on the annual work hours,
A process unit cost calculation unit that divides the process annual cost calculated by the process cost calculation unit by a predetermined value to be a process unit cost of a unit period determined by the predetermined value;
A delivery process unit cost calculation unit configured to divide a vehicle use year cost of a certain logistics facility calculated by the facility vehicle cost calculation unit by a predetermined value and set a delivery process unit cost for a unit period determined by the predetermined value;
A unit cost calculation device comprising:

[8] Configuration 8:
The configuration 7 has a function of obtaining a unit cost of the work process (process unit cost) in addition to the unit cost of the logistics facility (facility unit cost). That is, it is configured as follows.
In Configuration 1, Configuration 3, or Configuration 6,
The storage device is further capable of acquiring facility year work hours, which is the sum of work hours for each logistics facility in the settlement period, for each logistics facility, and for each logistics facility in the settlement period and excluding the delivery process. We have a work performance table that can obtain the process year work time, which is the sum of other work hours, by logistics facility and by work process excluding the delivery process,
further,
The cost to be allocated to a certain work process excluding the delivery process in the distribution work annual cost of a certain logistics facility calculated by the facility work cost calculation unit, the process year work time of the work process and the facility of the logistics facility A process annual cost calculation unit that calculates the calculated cost based on the annual work hours,
A process unit cost calculation unit that divides the process annual cost calculated by the process cost calculation unit by a predetermined value to be a process unit cost of a unit period determined by the predetermined value;
When the process unit cost calculated by the process unit cost calculation unit is a process unit cost of the storage process, a value obtained by dividing the logistics interest payment annual cost calculated by the facility interest payment cost calculation unit by the predetermined value In addition to the unit cost, the process unit cost correction part to be the process unit cost of the storage process,
A delivery process unit cost calculation unit configured to divide a vehicle use year cost of a certain logistics facility calculated by the facility vehicle cost calculation unit by a predetermined value and set a delivery process unit cost for a unit period determined by the predetermined value;
A unit cost calculation device comprising:

[9] Configuration 9:
Configuration 9 is a function for obtaining the unit cost (process product unit cost) of each product in each work process in addition to the unit cost of the logistics facility (facility unit cost) and the unit cost of each work process (process unit cost) It has. That is, it is configured as follows.
In Configuration 7 or Configuration 8,
The work performance table held by the storage device further includes the process product annual work time for each logistics facility in the settlement period, which is the sum of the work hours for each work facility and each product excluding the delivery process. And can be obtained by work process and product, excluding the delivery process,
The storage device further includes a delivery volume for each logistics facility and a delivery volume for each logistics facility and each product, a product processing quantity for each logistics facility and each work process, and each logistics facility and each work process in the settlement period. We have a product processing table that can acquire the product processing quantity for each product,
further,
The cost to be allocated to a certain product among the process year costs of a certain work process excluding the delivery process of a certain logistics facility calculated by the process year cost calculation unit is the process product year of the product in the work process. A process product annual cost calculation unit that calculates the work time and the process year work time of the work process, and sets the calculated cost as the process product annual cost of the product of the work process of the physical distribution facility;
The process product unit cost calculated by the process product annual cost calculation unit is divided by the processing quantity of the product of the work process to be the process product unit cost of the product of the work process of the physical distribution facility. The cost calculator,
The delivery process product annual cost, which is the cost to be allocated to a certain product among the vehicle use annual costs of a certain distribution facility calculated by the facility vehicle cost calculation unit, is calculated as the delivery volume of the product and the distribution in the distribution facility. The delivery process product of the product in the distribution process of the physical distribution facility is calculated based on the delivery volume of all the products of the facility, and the annual cost of the delivery process product obtained is divided by the processing quantity of the product in the delivery process. Delivery process unit cost calculation unit to be unit cost,
A unit cost calculation device comprising:

[10] Configuration 10:
A program for causing a computer to function as a unit cost calculation device according to any one of Configurations 1 to 9.

Since the unit cost computing device configuration 1 is configured as described above, the income statement, obtainable and balance sheet, total number of employees and the logistics personnel total logistics personnel number of the distribution facilities employee Staff table, transport vehicle table that can obtain the total number of transport vehicles in standard vehicle conversion and the number of transport vehicles in each logistics facility in standard vehicle conversion, interest rate data, and inventory value of each logistics facility can be acquired Based on the inventory table, the distribution cost per unit time of an arbitrary distribution facility can be obtained. For this reason, it is possible to compare logistics costs per unit time between a certain logistics facility and another certain logistics facility, which can contribute to an improvement in work of the logistics facility.
Since the unit cost calculation device of configuration 2 is configured as described above, the profit and loss statement, the employee table capable of acquiring the total number of employees, the total number of logistics workers, and the number of logistics workers at each logistics facility, and the standard vehicle Based on the transport vehicle table that can obtain the total number of transport vehicles in the case conversion and the number of transport vehicles in each distribution facility in the standard vehicle conversion, the distribution cost per unit time of any distribution facility is slightly less accurate Can be sought. For this reason, it is possible to compare logistics costs per unit time between a certain logistics facility and another certain logistics facility, which can contribute to an improvement in work of the logistics facility.
Since the unit cost calculation device of configuration 3 is configured as described above, employees who can obtain the income statement, balance sheet, total number of employees, total number of logistics workers, and the number of logistics workers at each logistics facility Based on the table, the transport vehicle table that can obtain the total number of transport vehicles and the number of transport vehicles of each logistics facility, the interest rate data, and the inventory table that can obtain the stock amount of each logistics facility The logistics cost per unit time can be calculated. For this reason, it is possible to compare logistics costs per unit time between a certain logistics facility and another certain logistics facility, which can contribute to an improvement in work of the logistics facility.
Since the unit cost calculation device of configuration 4 is configured as described above, an income statement, an employee table capable of acquiring the total number of employees, the total number of logistics workers, and the number of logistics workers at each logistics facility, and a transportation vehicle Based on the transport vehicle table from which the total number and the number of transport vehicles of each logistics facility can be obtained, the logistics cost per unit time of any logistics facility can be obtained although accuracy is inferior. For this reason, it is possible to compare logistics costs per unit time between a certain logistics facility and another certain logistics facility, which can contribute to an improvement in work of the logistics facility.

The unit cost calculation device of configuration 5 includes an income statement, an employee table capable of acquiring the total number of employees, the total number of logistics workers, and the number of logistics workers at each logistics facility, the total number of transportation vehicles, and the transportation vehicles at each logistics facility. A transportation vehicle table from which the number can be obtained, a storage device holding the table, and a cost for the spatial and / or temporal movement of the goods in the selling costs as a cost for delivering the goods and a cost for non-delivery To obtain from the profit and loss statement possessed by the storage device, and to acquire the general administrative expenses from the profit and loss statement, and related to the logistics business in the general administrative expenses obtained by the cost acquisition department A total operation cost calculation unit that calculates the total cost of distribution operations based on the total number of logistics workers and the total number of employees, and the sum of the calculated cost and the non-delivery cost acquired by the cost acquisition unit; Of the delivery costs acquired by the cost acquisition unit A facility vehicle cost calculation unit that determines a cost to be allocated to a certain logistics facility based on the number of transport vehicles and the total number of transport vehicles of the logistics facility, and uses the determined cost as a vehicle use year cost of the logistics facility; The cost to be allocated to a certain logistics facility in the logistics business cost calculated by the business cost calculation unit is obtained based on the number of logistics workers in the logistics facility and the total number of logistics workers, and the calculated cost is calculated for the logistics facility. And a facility unit cost for a unit period determined by the predetermined value obtained by dividing the sum of the vehicle use annual cost and the logistics service annual cost for the same logistics facility by a predetermined value. A facility unit cost calculation unit, an income statement, an employee table capable of acquiring the total number of employees, the total number of logistics workers, and the number of logistics workers of each logistics facility, the total number of transportation vehicles, and each logistics facility The number of transport vehicles can be acquired Based on the feed vehicle table, it is possible to determine the distribution cost per unit time of any distribution facilities. For this reason, it is possible to compare logistics costs per unit time between a certain logistics facility and another certain logistics facility, which can contribute to an improvement in work of the logistics facility.
Configuration 6 is the unit cost calculation device according to Configuration 5, wherein the storage device further holds a balance sheet, interest rate data, and an inventory table from which inventory amounts of each logistics facility can be acquired, Out of the total amount of logistics interest payments obtained by multiplying the total inventory on the balance sheet of the equipment by the interest rate determined by the interest rate data, the cost to be allocated to a certain logistics facility is the inventory amount of the logistics facility and the total inventory And a facility interest payment cost calculation unit that uses the determined cost as the distribution interest payment annual cost of the logistics facility, and the facility unit cost calculation unit includes the annual cost of using the vehicle related to the same logistics facility. And the annual cost of logistics operations and the annual interest expense of logistics are divided by a predetermined value to make the facility unit cost for a unit period determined by the predetermined value. Can ask for logistics costs . For this reason, it is possible to compare logistics costs per unit time between a certain logistics facility and another certain logistics facility, which can contribute to an improvement in work of the logistics facility.

The unit cost calculation device of Configuration 7 is the unit cost calculation device of Configuration 2 or Configuration 4 or Configuration 5, and the storage device is a facility year that is the sum of work hours for each logistics facility in the settlement period. Work time can be acquired for each logistics facility, and the annual work time, which is the sum of the work hours for each logistics facility and for each work process excluding the delivery process in the settlement period, is classified for each logistics facility and for each work process excluding the delivery process. A work performance table that can be acquired is held, and the cost to be allocated to a certain work process excluding the delivery process in the logistics work annual cost of a certain logistics facility calculated by the facility work cost calculation unit. A process year cost calculation unit for determining the cost based on the process year work time of the work facility and the facility year work time of the logistics facility, and setting the obtained cost as the process year cost of the work process of the logistics facility; Process cost A process unit cost calculation unit that divides the process annual cost calculated by the calculation unit by a predetermined value to obtain a process unit cost for a unit period determined by the predetermined value, and a vehicle at a certain logistics facility calculated by the facility vehicle cost calculation unit The unit cost calculation device having the configuration 2, 4, or 5 has a distribution process unit cost calculation unit that divides the usage year cost by a predetermined value and sets the delivery process unit cost for a unit period determined by the predetermined value. In addition to the effect, there is an effect that the distribution cost per unit time of an arbitrary work process in an arbitrary distribution facility can be obtained. For this reason, it is possible to compare the logistics cost per unit time of a certain work process of a certain logistics facility and the corresponding work process of another certain logistics facility, which contributes to the improvement of the work process of the logistics facility. be able to.
The unit cost calculation device of configuration 8 is the unit cost calculation device of configuration 1 or configuration 3 or configuration 6, and the storage device is a facility year that is a total of work hours for each distribution facility in the settlement period. Work time can be acquired for each logistics facility, and the annual work time, which is the sum of the work hours for each logistics facility and for each work process excluding the delivery process in the settlement period, is classified for each logistics facility and for each work process excluding the delivery process. A work performance table that can be acquired is held, and the cost to be allocated to a certain work process excluding the delivery process in the logistics work annual cost of a certain logistics facility calculated by the facility work cost calculation unit. A process year cost calculation unit for determining the cost based on the process year work time of the work facility and the facility year work time of the logistics facility, and setting the obtained cost as the process year cost of the work process of the logistics facility; Process cost A process unit cost calculation unit that divides the process annual cost calculated by the calculation unit by a predetermined value to obtain a process unit cost for a unit period determined by the predetermined value, and the process unit cost calculated by the process unit cost calculation unit is a storage process And the unit cost of the storage process is added to the process unit cost by adding the value obtained by dividing the logistics interest payment annual cost calculated by the facility interest payment cost calculation unit by the predetermined value to the process unit cost. A process unit cost correction unit that performs the distribution process unit cost for a unit period determined by dividing the vehicle use year cost of a certain distribution facility calculated by the facility vehicle cost calculation unit by a predetermined value Since it has a cost calculation unit, in addition to the effect produced by the unit cost calculation device of Configuration 1, 3 or 6, it is possible to obtain the logistics cost per unit time for any work process in any logistics facility There is. For this reason, it is possible to compare the logistics cost per unit time of a certain work process of a certain logistics facility and the corresponding work process of another certain logistics facility, which contributes to the improvement of the work process of the logistics facility. be able to.

  The unit cost calculation device of configuration 9 is the unit cost calculation device of configuration 7 or configuration 8, and the work performance table held by the storage device is further classified by distribution facility and delivery process in the settlement period. It is possible to obtain a process product year work time, which is the sum of work hours for each work process and product, for each work process and product for each distribution facility and delivery process. It is possible to obtain the delivery volume by logistics facility, the delivery volume by logistics facility and product, the product processing quantity by logistics facility and work process, and the product processing quantity by logistics facility and work process by product. Further, a cost to be allocated to a certain product in a process year cost of a certain work process excluding a delivery process of a certain logistics facility calculated by the process year cost calculation unit is stored. , The work concerned The process product is determined based on the process product year work time of the product and the process year work time of the work process, and the calculated cost is the process product annual cost of the product of the work process of the logistics facility. By dividing the process product annual cost calculated by the annual cost calculation unit and the process product annual cost calculation unit by the processing quantity of the product of the work process, the process product unit of the product of the work process of the physical distribution facility A process product unit cost calculation unit as a cost, and a delivery process product annual cost, which is a cost to be allocated to a product, among the vehicle use annual costs of a certain logistics facility calculated by the facility vehicle cost calculation unit, Calculated based on the delivery volume of the product in the logistics facility and the delivery volume of all the products in the logistics facility, and divides the obtained delivery process product annual cost by the processing quantity of the product in the delivery process, The quotient of the facility delivery process In addition to the effects produced by the unit cost calculation device of the configuration 7 or 8, in addition to the effect of the unit cost calculation unit of the configuration process 7 There is an effect that it is possible to obtain the distribution cost per unit quantity of the product. For this reason, it is possible to compare the cost of delivering a certain product via a certain logistics facility to a customer or another logistics facility with the cost of delivering the product via another certain logistics facility. Can be further reduced.

  Since the configuration 10 is a program for causing a computer to function as any one of the unit cost calculation devices in the configurations 1 to 9, the function of the unit cost calculation device in any one of the configurations 1 to 9 is set in the computer. There is an effect that can be realized.

[A] Overview of system configuration and functions:
FIG. 1 shows a computer system according to an embodiment of the present invention, that is, a computer system having a function 11 as a unit cost calculation device. The illustrated system includes a function 11 as a unit cost calculation device, a function 12 as a total cost calculation device, a function 15 as a required travel time calculation device, a function 16 as a time map display device, and a delivery availability analysis device. And a function 18 as a forward link / display device.
The illustrated system includes a control device 10, an auxiliary storage device (such as a hard disk) 20, a main storage device (memory (such as a RAM)) 30 used for work, a display device (such as a CRT display or a liquid crystal display) 51, and a printing device. (Laser printer or inkjet printer) 53, input device (keyboard, mouse, etc.) 55, communication device (NCU etc.) 57. Although FIG. 1 shows a stand-alone configuration, the present invention may be configured by a plurality of computers connected by a LAN (Local Area Network) or the like. For example, the configuration may be such that a database DB having various tables and the like is provided in another computer having a server function. In short, any system configuration may be used as long as each function provided by the apparatus of the present invention can be realized by one or more computers.

Control device 10:
The control device 10 is configured by a known device such as a CPU or an interface. The control device 10 cooperates with each of the above-described peripheral devices by executing a processing procedure to be described later, so that the unit cost calculation device, the total cost calculation device, the travel time calculation device, the time map display device, and the delivery possibility analysis Functions as a device and a forward link / display device are realized.
The control device 10 also functions to control each of the devices (auxiliary storage device 20, main storage device 30, display device 51, printing device 53, input device 55, communication device 57) connected to the control device 10. Also play. Since this function is well-known, description is abbreviate | omitted.

The control device 10 reads and executes an appropriate application program on the hard disk 20 and reads / writes appropriate data in the database DB onto the memory 30 at the time of execution, so that the function as the unit cost calculation device and the total amount are calculated. Various functions such as a function as a cost calculation device, a function as a required travel time calculation device, a function as a time map display device, a function as a delivery availability analysis device, a function as a route connection / display device, and the like are realized. Recording / reproduction of data on the hard disk 20 is controlled by a disk recording / reproduction control 20a. Further, writing / reading of data to / from the memory 30 is controlled by a memory writing / reading control 30a.
Each of the functions described above will be described in detail later, but here the outline is briefly described.

  The unit cost calculation function uses data such as profit and loss statements and balance sheet data, each employee's work performance and product processing results, etc. to calculate the cost per unit time of a certain logistics facility, certain logistics facility A function for calculating the cost per unit time of a certain work process and the cost per unit quantity of a certain product in a certain work process of a certain logistics facility is calculated, respectively. This is a function of recording in the corresponding item of the process product unit cost table.

The aggregate cost calculation function is the unit cost calculated by the unit cost calculation function for the cost of delivering any product from any logistics facility to any customer via another optional logistics facility as required. Is used to change the distribution facility and / or change the work process of the distribution facility to calculate and display each. Here, as the transit facilities, only distribution facilities that can deliver the product to the customer are selected as candidates for selection based on the calculation results of the following deliverability analysis function and route connection / display function.
For example, when an arbitrary product is delivered from a logistics facility B to a customer X via a logistics facility B, if it is delivered from a logistics facility B through a logistics facility B, Sometimes you want to know if the total cost will be reduced. The total cost calculation function is a function that can answer such a request.
In addition, for example, when an arbitrary product is received / stored / shipped at the B logistics facility and delivered to the customer X after being received / stored / shipped at the A logistics facility, When the work process is set to PtoP or the holding process, there is a case where it is desired to know whether or not the total cost is reduced. The total cost calculation function is a function that can answer such a request.
In addition, there is a demand for comparing a certain work process in a certain distribution facility with the same work process in another distribution facility to reduce waste and reduce costs. To that end, it is necessary to compare costs when handling the same product. The total cost calculation function is a function that can meet such a request.

The delivery possibility analysis function determines whether or not a certain product can be delivered from a certain logistics facility to a certain customer and, if possible, handles the certain product, a certain customer, and a certain logistics facility. This is a function for recording in a predetermined table (delivery path table; FIG. 20A) of the database DB. Further, the delivery possibility analysis function determines whether or not a certain product can be replenished from a certain distribution facility (supplement source) to a certain distribution facility (supplement destination). This is a function for associating a certain distribution facility (supplement source) and a certain distribution facility (supplement destination) and recording them in a predetermined table (supplement route table; FIG. 20B) in the database DB.
For example, when an arbitrary product is delivered from a logistics facility to a customer named X, instead, it is desired to know whether the product can be delivered from the logistics facility within the time allowed for the product. There is. The delivery availability analysis function is a function that can answer such a request.

The forward link function uses a table (delivery route table, replenishment route table; FIGS. 20 (a) and 20 (b)) created by the delivery availability analysis function, and uses a certain logistics facility ( (Delivery source) and a certain distribution facility (supplement destination) in the table having the distribution facility of the replenishment destination, and if both match, the corresponding records in both tables are associated with each other in a predetermined database DB This is a function for recording in a table (concatenated a table (FIG. 21 (a)). Further, the forward link function is replenished using a table (supplemented route table; FIG. Compare a certain distribution facility (supplement source) in the table with the original distribution facility with another distribution facility (supplement destination) in the same table, and if they match, associate both records. Database D Predetermined table (connection b table of the inner (a function of recording in FIG. 21 (b)).
For example, when an arbitrary product is delivered from the A logistics facility to the customer X through the B logistics facility, for example, the B logistics facility is supplied from the C logistics facility to the customer. Whether it can be delivered within the permissible time or within the permissible delivery time, or whether it can be delivered from the B physical distribution facility via the D physical distribution facility within the replenishment permissible time or within the permissible delivery time. I want to know. For example, it is a case where it is desired to reduce the total cost by replacing the distribution facility that handles delivery to customers and reassembling the entire delivery. The forward link function is a function that can answer such a request.

The movement time calculation function is a predetermined table group (distance time table (FIG. 15A), application type) when moving between two arbitrary points by a predetermined movement means (eg, truck). Calculated with reference to the table (FIG. 15B), road table (FIG. 16A), road piece table (FIG. 16B), logistics facility table (FIG. 17), customer table (FIG. 18)) Then, it is a function of recording in a predetermined table (travel time table (FIG. 19)) in the database DB.
The travel time calculation function is a function that can respond to a request to improve the accuracy of the delivery availability analysis function and the route connection function.

Auxiliary storage device 20:
The auxiliary storage device 20 configured by a known storage device such as a hard disk stores application programs for the control device 10 to realize the functions in cooperation with the peripheral devices. In addition, a database DB having various tables used in the functions is stored, and various data created by the functions are newly recorded in predetermined tables in the database DB.
As shown in FIG. 2, for example, a profit and loss statement, a balance sheet, interest rate data, an employee table, and a track table, as shown in FIG. , Vehicle case conversion table, product table, delivery classification table, inventory table by product by facility, work result table, product processing result table, facility cost table, process cost table, process product unit cost table, distance time table, application type table , Road table, road piece table, distribution facility table, customer table, travel time table, delivery route table, supply route table, linked a table, linked b table, and the like.

Peripheral devices:
The input device 55 is a device for a user to input data and instructions necessary for realizing the above functions.
The display device 51 is a device that displays a screen or the like necessary for realizing each function, and is controlled by a display control 51a.
The printing device 53 is a device used to print out various data generated by the above-described functions and various data necessary for realizing the above-described functions as necessary, and is controlled by the print control 53a. Is done.
The communication device 57 is a device used for communication with other computer systems (not shown) connected to the LAN, and other computer systems connected to an external network (not shown) such as the Internet. Yes, controlled by communication control 57a. For example, if the above-described database DB is placed on a server (not shown), reading and writing of data from the database DB are performed via the communication device 57.

[B] Control procedure:
Hereinafter, the function as a unit cost calculation device, the function as a delivery availability analysis device, the function as a route connection / display device, the function as a total cost calculation device, the function as a travel time calculation device and a time map display device, This will be described in order with reference to flowcharts and tables.

[B-1] Function as unit cost calculation device:
With reference to the flowcharts of FIGS. 3 to 9 and the tables of FIGS.
In step S101, the cost of each item (acceptance charges, delivery charges, outsourcing contracts, other charges) and general management costs in the income statement (FIG. 10A) are acquired from the database DB. And stored in the memory 30. Delivery costs are the movements (spatial and / or temporal movements) of goods (goods) among the expenses (sales costs) spent by companies for one year (financial period) to sell goods (goods). Expenses spent for time movement = storage). That is, a cost spent for delivering an article (product) to a customer (cost for delivery), a cost spent for receiving an article (product) from a manufacturer (non-delivery cost), and the like. Other items in sales expenses (sales activity expenses, sales promotion expenses, etc.) are not costs for moving goods, and are not used as basic data for calculating costs related to logistics. General administrative expenses include personnel expenses, office expenses, facility expenses, miscellaneous expenses, and business taxes. These are expenses that a company spends for one year (financial period) for all corporate activities, regardless of whether it is a logistics department or not. Since it is also spent for the logistics department, it will be adopted as the basic data for calculating costs related to logistics.
In addition, since the delivery charge in the delivery cost is a cost spent only for delivery from the distribution facility (delivery cost), processing described later (processing for obtaining costs related to the delivery process; S123, S161) , S189, S191, and the like) are stored in the memory as the total vehicle use cost. Regarding the outsourced charges and other charges in the delivery cost, when the proportion of expenditure for delivery from the distribution facility is large, it is possible to handle them in the same manner as the delivery charges.

In step S103, the total number of employees, the total number of logistics workers, and the number of logistics workers at each facility are obtained based on the data in the employee table in the database DB and stored in the memory 30.
In the employee table, as shown in FIG. 10C, the department classification of each employee is held. An employee whose department category is 1 is an employee who belongs to a logistics department, and an employee whose department category is 0 is an employee who belongs to a non-logistics department. Therefore, the total number of employees can be obtained by counting all employees. In addition, the total number of logistics workers can be obtained by counting the number of employees whose department category is 1. Further, by counting the number of employees whose department category is 1 for each belonging facility, the number of logistics workers in each logistics facility can be obtained.
In the above example, the total number of employees, the total number of logistics workers, and the number of logistics workers at each facility are calculated based on the employee table. In addition, the total number of employees, the total number of logistics workers, and the number of logistics workers at each logistics facility may be obtained using data that records the classification of logistics business or non-logistics business and the time spent. In that case, for example, when a certain person is engaged in logistics work for 70% of the working hours and 30% is engaged in non-logistics work, the certain person is designated as “0.7 logistics worker. Can be counted.

In step S105, the total logistics operation cost is obtained and stored in the memory 30. Logistics operations total costs are the total expenses that a company spends for logistics operations in one year (financial period), and only interest payments caused by logistics operations and delivery operations in logistics operations. It is defined as the cost that excludes the cost for
Specifically, the sum of the expenses for each item of the acceptance charges, subcontracting contracts, and other charges and the amount obtained by multiplying the general administrative expenses by the distribution rate is obtained as the total distribution work expenses. Here, the logistics rate is a value obtained by dividing the total number of logistics workers by the total number of employees. That is, the ratio of the number of logistics workers to the total number of employees. As described above, general administrative expenses are administrative expenses spent for one year (financial period) by the company for all corporate activities, regardless of whether they are in the logistics department, and are for the logistics department. It can not be separated whether it is expenditure for non-logistics sector. For this reason, it is decided to allocate the ratio of the personnel engaged in logistics operations to the employees of the entire company.

In step S107, the total stock is acquired from the balance sheet in the database DB and stored in the memory 30. Also, interest rate data is obtained from the database DB and stored in the memory 30.
In step S 109, the distribution interest payment total cost is obtained and stored in the memory 30. That is, a value obtained by multiplying the total stock amount by the interest rate is held in the memory 30 as the total distribution interest payment cost. Logistics interest payment total cost is defined as the interest payment cost caused by the logistics business.

In step S111, the total number of trucks in terms of standard vehicle grades and the number of trucks in terms of standard vehicle grades belonging to each distribution facility are obtained. There are a plurality of types of loading volumes and loading weights of trucks (an example of transportation vehicles), and as such, delivery costs cannot be accurately processed. For this reason, the number of trucks is counted after each truck is converted into the number of cars in a certain standard vehicle (for example, a 5-ton truck). This conversion is called standard car case conversion.
Specifically, the vehicle grade and the belonging facility of each truck are read from the track table (FIG. 11 (a)) in the database DB, and each standard vehicle is referenced with reference to the vehicle grade conversion table (FIG. 11 (b)). The number of cars is converted into the number of cars (standard car car value), and these are totaled for all the trucks to obtain the total number of trucks. The connection between the truck table and the vehicle case conversion table corresponds to the transport vehicle table of Configuration 1.
In the above, conversion to the standard vehicle case value is performed using the vehicle case conversion table, but instead of this, the loadable volume (or the load capacity) of the conversion target truck with respect to a predetermined standard load volume (or standard load weight) Conversion to the standard vehicle case value may be performed by multiplying the ratio of (loadable weight). For example, when the standard load capacity is 10 m ³ and the loadable capacity of the conversion target truck is 15 m ³ , the ratio 1.5 is multiplied by the standard vehicle value of the conversion target truck by 1.5. You may process as follows. The same applies when using a loadable weight.

Steps S123 to S133 are processing for obtaining the facility annual cost iy and the facility unit cost iu for the i-th logistics facility and recording them in the database DB. The facility annual cost iy is defined as the total amount of costs (logistics costs) spent for one year (financial period) by the company for the logistics operations at the logistics facility i. The facility unit cost iu is defined as a cost (distribution cost) obtained by converting the facility annual cost iy per unit time. As the unit time, for example, 1 year, 1 month, 1 day, 1 hour, etc. can be adopted. When one year is adopted as the unit time, the value of the facility year cost iy is equal to the value of the facility unit cost iu. When one day is adopted, the facility annual cost iy may be divided by the annual operating day. The same processing can be performed when one month or one hour is employed.
The processes in steps S123 to S135 are started from the first physical distribution facility and are executed in order until the processing is completed for all physical distribution facilities (S121, S137, S139).

In step S135, a process year cost ijy and a process unit cost iju are obtained for each work process (work process j) excluding the delivery process of the i-th logistics facility, and a process unit cost iHAu of the delivery process of the i-th logistics facility is obtained. This is a process of obtaining these and recording them in the database DB. The process annual cost ijy is the total cost (logistics cost) spent by the company for one year (financial period) for the logistics work in each work process (work process j) excluding the delivery process of the logistics facility i. . The process unit cost ij is defined as a cost (distribution cost) obtained by converting the process year cost ij per unit time. The same applies to the process unit cost iHAu of the delivery process, and is defined as a cost (distribution cost) obtained by converting the vehicle use annual cost i (see description of S123 described later) of the i-th logistics facility per unit time. As the unit time, for example, 1 year, 1 month, 1 day, 1 hour, etc. can be adopted. When one year is adopted as the unit time, the value of the process annual cost ijy is equal to the value of the process unit cost iju. When one day is adopted, the process annual cost ijy may be divided by the annual working day. The same processing can be performed when one month or one hour is employed.
The process of step S135 will be described later with reference to FIGS. Further, the process of step S165 (FIG. 7) executed in step S135 will be described later with reference to FIGS.

Steps S123 to S133 will be described.
In step S123, the annual vehicle usage cost i of the distribution facility i is obtained and stored in the memory 30. That is, the delivery charge (= total cost of vehicle use = delivery cost of configuration 1) held in the memory 30 in step S101 is read, multiplied by the vehicle rate i, and this multiplication result is used as the vehicle usage of the logistics facility i. Stored in memory as annual cost i.
The vehicle use year cost i is defined as the total cost (logistics cost) spent by the company for one year (financial period) for the logistics work in the distribution process of the logistics facility i.
The vehicle rate i is the ratio of the number of trucks i belonging to the logistics facility i to the total number of trucks in the entire company. That is, the value is obtained by dividing the number of trucks i belonging to the distribution facility i by the total number of trucks of the entire company. Here, as for the number of trucks, the number of cars in terms of standard car grade is used.
As described above, in step S123, the total vehicle use cost is allocated to the logistics facility i based on the number of trucks in the logistics facility i and the number of trucks in the entire company.
The vehicle use year cost i is a cost spent only for the delivery process of the distribution facility i, and thus may be referred to as a process year cost of the distribution process of the distribution facility i (see S161).

In step S125, the distribution work annual cost i of the distribution facility i is obtained and stored in the memory 30. That is, the logistics work total cost held in the memory 30 in step S105 is read out, multiplied by the personnel rate i, and the multiplication result is held in the memory 30 as the logistics work annual cost i of the logistics facility i.
The logistics work annual cost i is defined as the total cost spent for one year (financial period) for the logistics work of each work process excluding the delivery process of the logistics facility i. Note that interest payments generated at the logistics facility i due to logistics operations are not included (see the description of S105).
The personnel ratio i is a ratio of the number of logistics workers i belonging to the logistics facility i to the total number of logistics workers in the entire company. That is, the value is obtained by dividing the number of logistics workers i belonging to the logistics facility i by the total number of logistics workers of the entire company.
As described above, in step S125, the total logistics work cost is allocated to the logistics facility i based on the number of logistics workers in the logistics facility i and the total number of logistics workers in the entire company.

In step S127, the stock amount i of the distribution facility i is obtained and stored in the memory 30.
The inventory amount i of the logistics facility i multiplies the inventory quantity (the inventory quantity at the same time as the balance sheet) of each product (product k) of the logistics facility i by the unit price of the corresponding product (product k), These can be obtained by tabulating. Here, the stock quantity of each product in the distribution facility i can be obtained from the facility-specific product stock table (FIG. 12A). The unit price of each product is obtained from the product table (FIG. 11C). The connection between the facility-specific product-specific inventory table and the product table corresponds to the inventory table of Configuration 1.

In step S129, the distribution interest payment annual cost i of the distribution facility i is obtained and stored in the memory 30. That is, the logistics interest payment total cost held in the memory 30 in step S109 is read out, multiplied by the inventory rate i, and the multiplication result is held in the memory 30 as the logistics interest payment annual cost i of the logistics facility i.
The logistics interest payment annual cost i is defined as the interest payment cost generated due to the logistics business (inventory) of the logistics facility i.
The inventory rate i is the ratio of the inventory amount i of the logistics facility i to the total inventory. That is, it is a value obtained by dividing the stock amount i of the distribution facility i by the total stock amount.
In this way, in step S129, based on the inventory amount i of the logistics facility i and the total stock of the entire company, the distribution interest payment total cost is allocated to the logistics facility i, and the logistics interest payment annual cost i of the logistics facility i is allocated. It is said.

In step S131, the vehicle use annual cost i obtained in step S123, the logistics service annual cost i obtained in step S125, and the logistics interest payment annual cost i obtained in step S129 are added, and the added value is obtained as follows. As the facility annual cost iy, it is recorded in the facility cost table (FIG. 13A) of the database DB.
In step S133, the facility unit cost iu is obtained by dividing the facility annual cost iy obtained in step S131 by the predetermined time T, and is recorded in the facility cost table (FIG. 13A) of the database DB. As this predetermined time T, for example, when the number of working days in one year (financial period) is adopted, the facility unit cost iu per working day is obtained. Further, when the same value as the facility year work time iy used in step S141 is adopted as T, the facility unit cost iu per hour can be obtained. Moreover, the work in the case of processing with the total working hours becomes easy.

The “process unit cost calculation process for facility i” executed in step S135 will be described with reference to FIGS.
In step S141, the total work time (facility year work time iy) for one year (financial period) of all logistics workers belonging to the logistics facility i is obtained based on the data of the work performance table (and employee table). And stored in the memory 30. In the work performance table, as shown in FIG. 14A, the actual working time for one year (financial period) is recorded for each work process in association with each employee. Further, as shown in FIG. 10 (c), the employee table is recorded with the affiliation facility and department classification of each employee. Therefore, by using these, it is possible to obtain the total work time for one year (financial period) of all logistics workers belonging to the logistics facility i.

Steps S145 to S155 are processes for obtaining a process year cost ijy and a process unit cost iju in the database DB for the jth work process (work process j) excluding the delivery process of the distribution facility i. The process year cost ij is defined as the total cost (logistics cost) spent by the company for one year (financial period) for the logistics work in the work process j of the logistics facility i. The process unit cost ij is defined as a cost (distribution cost) obtained by converting the process year cost ij per unit time. As the unit time, for example, 1 year, 1 month, 1 day, 1 hour, etc. can be adopted. When one year is adopted as the unit time, the value of the process annual cost ijy is equal to the value of the process unit cost iju. When one day is adopted, the process annual cost ijy may be divided by the annual working day. The same processing can be performed when one month or one hour is employed.
The processes in steps S145 to S155 are started from the first work process (entry process, storage process, delivery process, holding process, PtoP process) of the distribution facility i which is the i-th distribution facility, and all the work processes are performed. The processes are executed in order until the process is completed (S143, S157, S159). The PtoP (Plat to Plat) process is an operation process in which an article (product) unloaded from a truck is placed in a predetermined place without being stored in a warehouse, and the article (product) is loaded on another truck. In addition, the holding process is an operation process in which a load is loaded from one truck to another without unloading.

  In step S145, the total work time (process year work time ijy) for one year (financial period) for the work process j of all logistics workers belonging to the logistics facility i is stored in the work performance table (and employee table). Obtained based on the data and stored in the memory 30. In the work performance table, as shown in FIG. 14A, the actual working time for one year (financial period) is recorded for each work process in association with each employee. In addition, as shown in FIG. 10C, the employee table belongs to each employee and the department classification is recorded in the employee table. Therefore, by using these, it is possible to obtain the total sum of work hours for one year (financial period) for the work process j of all logistics workers belonging to the logistics facility i.

In step S147, the process annual cost ijy of the work process j of the logistics facility i is obtained and stored in the memory 30. That is, the logistics work annual cost i of the logistics facility i obtained in step S125 is read from the memory 30, and this is multiplied by the process work time rate ij, and this multiplication result is obtained as the process year of the work process j of the logistics facility i. The cost ijy is stored in the memory 30. Here, the process work time rate ij is a value obtained by dividing the process year work time ij obtained in step S145 by the facility year work time iy obtained in step S141.
The process year cost ij is defined as the total cost (logistics cost) spent by the company for one year (financial period) for the logistics work of the work process j of the logistics facility i. The work process j does not include a delivery process. Further, the process year cost ijy of this step S147 does not include interest payments generated at the logistics facility i due to the logistics business (see explanation of S105, S125).

  In step S 149, the process unit cost ij obtained in step S 147 is divided by the predetermined time T to obtain a process unit cost ij, which is stored in the memory 30. As the predetermined time T, for example, when the number of working days for one year (financial period) is adopted, the process unit cost iju per working day is obtained. Moreover, when the same value as the process year work time ijy used at step S147 is adopted as T, the process unit cost ij per hour can be obtained. Moreover, the work in the case of processing with the total working hours becomes easy.

Step S151 is processing for determining whether or not the processing in steps S145 to S149 is processing for the storage process.
If it is the process for the storage process (YES in S151), after executing steps S153 to S155, the process proceeds to step S157.
If it is not the process for the storage process (NO in S151), steps S153 to S155 are skipped and the process proceeds to step S157.

  In step S153, the distribution interest payment unit cost ijuu of the work process j (= storage process) of the distribution facility i is obtained and stored in the memory 30. That is, the distribution interest payment unit cost ijuu is obtained by reading the distribution interest payment annual cost i of the distribution facility i obtained in step S129 from the memory 30 and dividing by the predetermined time T. As the predetermined time T, for example, when the number of working days of one year (financial period) is adopted, the distribution interest payment unit cost ijuu per working day is obtained.

In step S155, the logistics interest payment unit cost iju obtained in the latest step S153 is added to the process unit cost iju of the work process j (= storage process) of the logistics facility i obtained in the latest step S149. The value is stored in the memory 30 as the process unit cost iju of the work process j (= storage process) of the physical distribution facility i.
As described above, in the storage process, the logistics unit payment unit cost iju calculated based on the logistics interest payment annual cost i is added to the process unit cost iju calculated based on the logistics business annual cost i, and the result is added to the logistics interest rate. It is stored in the memory 30 as a pay unit cost iju. The reason is that interest payment resulting from inventory occurs only in the storage process in the work process.

When the processing of steps S145 to S157 is completed for all of the warehousing process, the storage process, the shipping process, the holding process, and the PtoP process of the distribution facility i (YES in S157), the process proceeds to step S161.
Step S161 is a step of obtaining the process unit cost iHAu of the delivery process iHA of the distribution facility i. That is, the vehicle unit annual cost i obtained in step S123 is divided by the predetermined time T to obtain the process unit cost iHAu of the delivery process and hold it in the memory 30. As the predetermined time T, for example, when the number of working days in one year (financial period) is adopted, the process unit cost iHAu per working day is obtained.

  Step S163 is a step of recording the process unit cost iju (iHAu) of each work process of the distribution facility i in the process cost table (FIG. 13B) of the database DB.

    In step S165, the process product annual cost ijky (iHAky) and the process product unit cost ijku (iHAku) for each product (product k) in each work process (work process j and delivery process HA excluding the delivery process) of the i-th logistics facility. ), And these are recorded in the database DB. Process product annual cost ijky (iHAky) means that a company spends for one year (financial period) for logistics work of product k in each work process (work process j and delivery process HA excluding delivery process) of logistics facility i It is defined as the total amount of costs (logistics costs). Further, the process product unit cost ijku (iHAku) is defined as a cost (distribution cost) obtained by converting the process product annual cost ijky (iHAku) per unit number of the product k.

The “process product unit cost calculation process for each work process at the facility i” in step S165 will be described with reference to FIGS.
Steps S175 to S179 are the process product annual cost ijky and the process product unit cost for the kth product (product k) that is the work target in the jth work process (work process j) excluding the delivery process of the distribution facility i. This is a process of obtaining ijku and recording it in the database DB. The process product annual cost ijky is defined as the total cost spent for one year (financial period) by the company for the logistics work related to the product k that is the work target in the work process j of the logistics facility i. . Further, the process product unit cost ijku is defined as a cost obtained by converting the process product annual cost ijky per unit time. As the unit time, for example, 1 year, 1 month, 1 day, 1 hour, etc. can be adopted. When one year is adopted as the unit time, the value of the process product annual cost ijky is equal to the value of the process product unit cost ijku. When one day is adopted, the process product annual cost ijky may be divided by the annual operating day. The same processing can be performed when one month or one hour is employed.
The processes in steps S175 to S179 are started from the first product in the first work process (entry process, storage process, delivery process, holding process, PtoP process) of the distribution facility i which is the i-th distribution facility. The processing is executed in order until the processing is completed for all the products in the work process (S171, S173, S181, S183, S185, S187).

  In step S175, the total work time (process year work time ijky) for one year (financial period) for the product k in the work process j of all logistics workers belonging to the logistics facility i is stored in the work performance table (and employee Is obtained based on the data of the employee table) and stored in the memory 30. In the work performance table, as shown in FIG. 14A, the actual working time of one year (financial period) is recorded for each work process and each product in association with each employee. In addition, as shown in FIG. 10C, the employee table belongs to each employee and the department classification is recorded in the employee table. Therefore, by using these, it is possible to obtain the sum of the work time for one year (financial period) for the goods k in the work process j of all the logistics workers belonging to the logistics facility i.

In step S177, the process product annual cost ijky for the product k in the work process j of the distribution facility i is obtained and stored in the memory 30. That is, the process year cost ijy of the work process j of the distribution facility i obtained in step S147 is read from the memory 30, and this is multiplied by the process product work time rate ijk, and the multiplication result is obtained as the work process of the distribution facility i. The process product annual cost ijky for the product k at j is held in the memory 30. Here, the process product work hour rate ijk is a value obtained by dividing the process product year work time ijky obtained in step S175 by the process year work time ijy obtained in step S145.
The process product annual cost ijky is defined as the total amount of expenses spent for one year (financial period) by the company for the logistics work of the product k in the work process j of the logistics facility i. The work process j does not include a delivery process.

In step S179, a process product unit cost ijku is obtained by dividing the process product annual cost ijky obtained in step S177 by the process product annual processing amount ijky, and is stored in the memory. The process product annual processing amount ijky is the annual processing amount (financial settlement period) of the product (product k) in the work process (work process j) of the distribution facility i, and is a product processing result table (see FIG. 14 (b)).
The process product unit cost ijku is a logistics cost per unit number of the product (product k) in the work process (work process j) of the distribution facility i.
When the process product annual cost ijky obtained in step S177 is divided by the process product annual work time ijky, the logistics per hour of the product (product k) in the work process (work process j) of the logistics facility i. You can ask for costs. Moreover, the work in the case of processing with the total working hours becomes easy.

When the processing of steps S175 to S185 is completed for all products in all work processes (= warehousing process, storage process, shipping process, holding process, PtoP process) except for the distribution process of logistics facility i (YES in S185) ), And proceeds to step S189.
Step S189 is a step of obtaining the process product annual cost iHAky of the distribution process iHA of the distribution facility i and storing it in the memory 30. That is, the process product annual cost iHAky of the distribution process iHA of the distribution facility i is obtained by multiplying the vehicle use year cost i obtained in step S123 by the product delivery volume ratio iHAk of the product k.
The product delivery volume ratio iHAk is the total volume of products k delivered from the logistics facility i in one year (financial period), the total volume of goods k issued in the year (financial period), It is a ratio with respect to the total volume (product annual issue volume i) of goods. That is, the total volume of products k delivered from the distribution facility i for one year (financial period) (the annual product delivery volume ik) is the total volume of all products delivered from the logistics facility i for one year (financial period) ( It is a value divided by the product annual issue volume i).
The product annual delivery volume ik is obtained from the product processing record table (FIG. 14B) in the database DB for the number of goods delivered from the distribution facility i for the product k per year. Obtained by multiplying the model volume of the acquired product k. It can obtain in the same way also about the total delivery volume (commodity annual delivery volume i) of all goods for one year.

Step S191 is a step in which the process product unit cost iHAku of the distribution process iHA of the distribution facility i is obtained and stored in the memory 30. That is, the process product unit cost iHAku is obtained by dividing the process product annual cost iHAky of the delivery process iHA obtained in step S189 by the process product annual processing amount iHAky.
The process product annual processing amount iHAky, which is the processing amount for one year (financial period) of the product k in the delivery process, is obtained from the product processing result table (FIG. 14B) in the database DB.

In step S193, the process product unit cost ijku (iHAku) of each product in each work process of the distribution facility i held in the memory 30 in steps S179 and S191 is stored in the process product unit cost table (FIG. 12B in FIG. 12B). )).
Next, the process proceeds to step S137 (FIG. 5).
As described above, the process for obtaining and recording the unit cost is executed.

  In the processing shown in FIGS. 3 to 9, the logistics interest payment total cost is calculated in step S109, and based on this, the logistics interest payment annual cost of the logistics facility i is calculated in step S129, and the facility annual cost iy (see S131). ) And the facility unit cost iu (see S133), but if the interest is sufficiently low, or if the total inventory is sufficiently small compared to the total logistics work cost (see S105) However, it is possible to simplify the processing by omitting each step related to the total cost of logistics interest payment.

  In the processing shown in FIGS. 3 to 9, the total number of trucks in terms of standard vehicle size and the number of trucks in each physical distribution facility are obtained in step S111, and the processing in step S123 and the like is performed based on these. The accuracy may be slightly inferior when there is no significant difference in the vehicle type of the trucks used, but the total number of trucks and the number of trucks at each logistics facility can be aggregated as they are without converting to the standard car type. A configuration that simplifies the processing is also possible.

[B-2] Delivery availability analysis function:
With reference to the flowcharts of FIGS. 23 to 24, the table of FIG. 19, and the explanatory diagrams of FIGS.
The delivery availability analysis function uses a travel required time table (FIG. 19) created by a travel required time calculation function (described later), and considers a certain product in consideration of a delivery allowable time predetermined for the product. It is determined whether or not delivery from a facility (delivery source) to a certain customer (delivery destination) is possible. If possible, the certain product, a certain customer (delivery destination), and a certain logistics facility (delivery source) Are recorded in the delivery route table (FIG. 20A). This process is a delivery path table creation process.
Further, in the delivery possibility analysis function, whether or not a certain product can be replenished from a certain distribution facility (supplement source) to a certain distribution facility (supplement destination) in consideration of a predetermined replenishment allowable time for the product. If possible, and if possible, the product, the logistics facility (supplement source), and the logistics facility (supplement destination) are associated with each other and recorded in the supply path table (FIG. 20B). This process is a supply path table creation process.

[B-2-1] Delivery route table creation processing (FIG. 23):
In the delivery route table creation process, whether or not delivery is possible is determined for various combinations of an arbitrary product, an arbitrary customer (delivery destination), and an arbitrary logistics facility (delivery source). The product, the customer, and the logistics facility combination) are added as new records to the delivery route table (FIG. 20A).
Here, the product is from the product table (FIG. 11C), the delivery allowable time of the product is from the delivery classification table (FIG. 11D) using the delivery classification as a key, and the customer is from the customer table (FIG. 18). The distribution facilities are acquired from the distribution facility table (FIG. 17).
The created delivery route table is used in the forward link / display function (described later). Specifically, it is used in the connected route configuration processing (FIG. 30) in step S607 in the distribution cost display processing for each connected route (FIG. 29).

The procedure will be described below.
First, an initial value 1 is assigned to a variable i indicating a product, a variable j indicating a logistics facility, and a variable k indicating a destination (S201). Here, the variables i, j, and k are variables that are used only in the delivery path table creation process and do not affect other processes. In the above-described unit cost calculation process and other processes described later, variables represented by i, j, etc. are used as appropriate. The same applies to those variables, and these variables are used only in the other processes. is there.

Next, the allowable delivery time Tp-i of the product i is acquired from the delivery classification table (FIG. 11D) using the delivery classification of the product table (FIG. 11C) as a key, and the acquired allowable delivery time Tp− Based on i, the delivery range prescribed time Trg-i of the product i is obtained (S211). Here, a time corresponding to the diameter of a circle whose circumference is the allowable delivery time Tp-i is adopted as the delivery range specified time Trg-i.
That is, “Trg−i = Tp−i / π” is set as the delivery range specified time.
The purpose of determining the delivery range prescribed time Trg-i as described above is to determine whether delivery is possible on the assumption that delivery with optimized truck use efficiency is performed.

The optimized delivery will be described with reference to FIGS.
In a delivery operation in which the same delivery allowable time is loaded on a truck, departs from the logistics facility C, is delivered to each customer in turn, and then returns to the starting logistics facility C, the goods are packed at the time of departure. In addition to delivering in order on the outbound route, the cargo will continue to be delivered to the customer on the return route without running empty, and the truck will be unloaded immediately before returning to the logistics facility C, and the time when it will be unloaded From the viewpoint of truck utilization efficiency, it is required to be as close as possible to the elapsed time of the allowable delivery time before the allowable delivery time has elapsed.
Furthermore, by setting one or more round trip routes as the round trip route starting from the distribution facility C, all customers located within the specified delivery range from the logistics facility C can be traced without omissions. It is requested to get.
In view of these requests, a round route is determined as in the following (a) to (c).
(A) Basic principle of circuit configuration:
Each of two points adjacent to each other on a round trip route (tracking facility C-customer, customer-customer, customer-customer, customer-logistics facility C) following a plurality of customers in order from the logistics facility C The round trip route is configured so that the total required travel time (= time distance) between them is equal to or less than the allowable delivery time Tp-i and close to the allowable delivery time Tp-i.
FIG. 26 shows an example of a one-round route configured based on this principle. In the figure, a solid line arrow is an example of an area where a customer is distributed within a relatively narrow angle range when viewed from the distribution facility C, and a broken line arrow is an example of an area where the customer is distributed within a relatively wide angle range. As shown in the figure, the former round path has a relatively long and narrow shape, and the latter round path has a shape close to a circle.
(B) One customer extraction:
It is assumed that customers in charge of the distribution facility C are distributed in a certain range centering on the distribution facility C. The certain range is a range in which the time required for movement between the distribution facility C and the customer is equal to or less than the delivery range prescribed time Trg-i (see “C2” in FIG. 25). A semi-line (= radius line R) drawn from the distribution facility C is rotationally scanned in a predetermined direction (eg, clockwise direction) around the distribution facility C, and the customers are sequentially extracted. When the total load amount reaches the track capacity, scanning is temporarily stopped. That is, the customer extraction is temporarily stopped.
(C) Evaluation and determination of a round route:
The total travel time between two points adjacent to each other on the round route that follows the extracted customer as shown in (a) above is evaluated. Adopt a route. On the other hand, when the total exceeds the allowable delivery time Tp-i, the above evaluation is repeated by decreasing the number of customers in order from the final side of the extraction in (b) above, and the total becomes less than the allowable delivery time Tp-i. Adopt a one-round route at that time.
When the one-round route is determined according to the principles (a) to (c) described above, in the region where the customers are distributed within a relatively narrow angle range when viewed from the logistics facility C, the one-round route is in the radial direction. In the region where the customer is distributed within a relatively wide angle range when viewed from the distribution facility C, the round route is formed in a shape close to a circle. For this reason, in the former, the delivery range prescribed time Trg is relatively long, and in the latter, the delivery range prescribed time Trg is relatively short. This device adopts a circle as the representative shape of the circuit route so that the customer can return to the starting point C within the allowable delivery time Trg even if the customer is distributed within a relatively wide angle range as viewed from the logistics facility C. To do. That is, a time corresponding to the diameter of a circle whose circumference is the delivery allowable time Tp-i of the product i is adopted as the delivery range specified time Trg-i of the product i.

In step S213, the jth logistics facility is acquired from the logistics facility table (FIG. 17). Note that the delivery route table creation process is a process for determining whether delivery is possible between the customer (delivery destination) and the logistics facility (delivery source). ) May be excluded.
In step S215, the kth customer is acquired from the customer table (FIG. 18).
In step S217, the required travel time Tj-k between the logistics facility j acquired in step S213 and the customer k acquired in step S215 is acquired from the required travel time table (FIG. 19). This required travel time table is a table created by a required travel time calculation function (described later).

In step S221, the required travel time Tj-k between the distribution facility j and the customer k is compared with the delivery range specified time Trg-i of the product i obtained in step S211, and the required travel time Tj-k is determined as the delivery range. If it is equal to or less than the prescribed time Trg-i (YES in S121), it may be considered that the product i can be delivered from the logistics facility j to the customer k within the delivery allowable time Tp-i of the product i. A new record having delivery source j, customer (delivery destination) k, and product i as item values is created and added to the delivery path table (FIG. 20A) (S223).
On the other hand, if the required travel time Tj-k exceeds the delivery range specified time Trg-i (NO in S221), the process jumps to step S123.

In step S231, it is checked whether or not the inspection of whether or not the product i can be delivered from the distribution facility j within the allowable delivery time of the product i has been performed for all the customers.
If all of the customers are not covered (NO in S231), the inspection object is moved to the next customer (S232), and similarly, the product i from the distribution facility j is within the allowable delivery time of the product i. It is inspected whether it can be delivered (S215-S223).

If the inspection of whether or not the product i can be delivered from the logistics facility j within the allowable delivery time of the product i is performed for all customers (YES in S231), the delivery of the product i is permitted. It is checked whether or not the inspection covering all of the customers about whether or not delivery can be made from any distribution facility within the time is performed covering all of the distribution facilities (S233).
If not all of the distribution facilities are covered (NO in S233), the inspection object is moved to the next distribution facility (S234), and for the next distribution facility, the product i is the same as above. Whether or not the product i can be delivered within the allowable delivery time is comprehensively inspected for all customers (S215 to S223).

When the inspection that covers all of the customers about whether or not the product i can be delivered from the distribution facility j within the allowable delivery time of the product i is performed for all the distribution facilities (YES in S233) ), Covering all of the products, covering all of the customers about whether or not the products i can be delivered from any logistics facility within the delivery allowable time of the products i and covering all of the logistics facilities Then, it is checked whether or not this has been done (S235).
If all of the products are not covered (NO in S235), the inspection object is moved to the next product in the order (S236), and the product i is changed to the product i in the same manner as described above for the next product. All customers are inspected to see if they can be delivered within the allowable delivery time (S215 to S223).

  The inspection that covers all of the customers and whether or not all of the distribution facilities can be delivered within the allowable delivery time of the product i from all of the distribution facilities j covers all the products. If YES (YES in S235), the delivery path table creation process ends.

[B-2-2] Supply path table creation process (Fig. 24):
In the replenishment route table creation processing, whether or not delivery (delivery for replenishment) is determined for each combination of goods, distribution facility (supplement destination), and distribution facility (supplement source), and if it is determined that delivery is possible The combination (combination of goods, distribution facility (supplement destination) and distribution facility (supplement source)) is added as a new record to the replenishment route table (FIG. 20B).
Whereas the delivery route table creation process described above is a process for determining whether delivery between a customer (delivery destination) and a logistics facility (delivery source) is possible by comparing with a delivery range stipulated time based on a delivery allowance time. The replenishment route table creation process is a process for determining whether delivery between the distribution facility (replenishment destination) and the distribution facility (replenishment source) is possible by comparing it with the replenishment range specified time based on the replenishment allowable time. The replenishment path table creation process is the same as the delivery path table creation process described above, and a description thereof will be omitted. The allowable replenishment time is acquired from the delivery classification table (FIG. 11D) from the product table (FIG. 11C) using the delivery classification as a key. In the example shown in the figure, the allowable delivery time and the allowable supply time are different, but this is an example, and depending on the product, there may be the same case.

[B-3] Forward link / display function:
With reference to the flowcharts of FIGS. 27 to 28, the tables of FIGS. 20 to 21, and the explanatory diagram of FIG. 22, the function as a forward link / display device will be described.
In the forward link function, a distribution facility (delivery source) of a certain record in the delivery route table (FIG. 20 (a)) and a distribution facility (replenishment destination) of a certain record in the replenishment route table (FIG. 20 (b)). ), And if they match, both records are associated and recorded in the linked a table (FIG. 21 (a)). This process is a delivery path / supply path connection process. As a result, in the connected route configuration process (S607) in the connected route specific distribution cost display process (FIG. 29) described later, the relevant product passes from the distribution facility (supplement source) to the distribution facility (supplement destination = delivery source). It is possible to display candidate connections that can be delivered to the customer.
In the forward link function, the distribution facility (supplement source) of a certain record in the replenishment route table (FIG. 20 (b)) and another record in the same replenishment route table (FIG. 20 (b)). When the distribution facility (supplement destination) is compared and the two match, both records are associated and recorded in the linked b table (FIG. 21B). This process is a supply path / supply path connection process. As a result, in the connected route configuration processing (S607) in the connected route-specific distribution cost display processing (FIG. 29), which will be described later, from the distribution facility (supplement source) to the distribution facility (supplement destination = supplement source at the next stage). It is possible to display candidate connected routes that can supply the product to the distribution facility (supplement destination).

[B-3-1] Delivery / Supply Route Connection Processing (Figure 27):
In the delivery route / supply route connection process, when a logistics facility capable of delivering a product to a customer is also a logistics facility capable of delivering the product from another logistics facility, a delivery route table ( Record of the product / customer / distribution facility (delivery source) in FIG. 20A and the product / distribution facility (supplement destination = delivery source) / distribution facility in the supply path table (FIG. 20B) The record of (supplement source) is associated and recorded as a new record in the linked a table (FIG. 21A). When this association is used, in the total cost calculation / display function (described later), a candidate for a connection route from the distribution facility (supplement source) to the customer through the distribution facility (supplement destination = delivery source) is displayed to the user. It is possible to select.

The procedure will be described below.
First, an initial value 1 is assigned to a variable i that sequentially indicates records in the delivery path table and a variable j that sequentially indicates records in the supply path table (S401).

In step S411, the value of the facility ID (delivery source) item of the i-th record in the delivery route table is acquired.
Similarly, in step S421, the value of the facility ID (supply destination) item of the jth record in the supply path table is acquired.

  Next, in step S431, it is checked whether or not the physical distribution facility (delivery source) acquired in step S411 and the physical distribution facility (supplement destination) acquired in step S421 are the same physical distribution facility. In other words, it is checked whether the i-th record in the delivery route table and the j-th record in the supply route table are records to be associated with each other.

If the result of the check is the same (YES in S431), the i-th record in the delivery route table and the j-th record in the supply route table are associated with each other and recorded as a new record in the linked a table ( S433).
As a result, in the total cost calculation / display function (described later), it is displayed as a candidate for a connected route from the distribution facility (supplement source) to the customer through the distribution facility (supplement destination = delivery source) and allowed to be selected by the user. Is possible.
If the result of the check in step S431 is not the same (NO in S431), the process proceeds to step S441.

In step S441, it is checked whether the j-th record in the supply route table can be associated with the i-th record in the delivery route table covering all the records in the supply route table. To do.
As a result, when all the records in the supply path table are not covered (NO in S441), the inspection object is moved to the next record in the supply path table (S442), and the processes in steps S421 to S433 are repeated. .
As a result of the check in step S441, if all the records in the supply path table have been inspected (YES in S441), the process proceeds to step S443.

In step S443, whether or not the j-th record in the supply route table can be associated with the i-th record in the delivery route table covers all the records in the supply route table is checked. Check whether it was done for all records in.
As a result, if the check that covers all the records in the supply path table is not performed for all the records in the delivery path table (NO in S443), the inspection target is set to the next record in the delivery path table. (S444) and repeat the processing of steps S421 to S433.
As a result of the check in step S443, if all records in the supply route table are checked for all records in the supply route table (YES in S443), the delivery route / supply route connection process is performed. Exit.

[B-3-2] Supply path / supply path connection processing (FIG. 28):
In the supply route / supply route connection process, a distribution facility (supplement source) capable of delivering a certain product to a certain distribution facility (supplement destination) delivers the product from another distribution facility (previous supply source). If it is also a distribution facility (supplement destination) that can be used, the same replenishment route as the record of the product / distribution facility (supplement destination) / distribution facility (supplement source) in the replenishment route table (FIG. 20B) New records are added to the linked b table (FIG. 21 (b)) by associating records of the product / distribution facility (supplement source = supplement destination) / distribution facility (previous supply source) in the table (FIG. 20 (b)). Record as a record. If this association is used, candidate connected routes that can replenish the product from the distribution facility (previous supply source) via the distribution facility (supplement destination = next supply source) to the distribution facility (next supply destination) It can be displayed.

The above-mentioned delivery route / replenishment route connection processing links the record between the customer (delivery destination) and the distribution facility (delivery source) and the record between the distribution facility (delivery source = supplement destination) and the distribution facility (supplement source). The handling route constitutes a connected route that can deliver the product to the customer (delivery destination) from the logistics facility (supplement source) through the logistics facility (supplement destination = delivery source), while the supply route・ Supply route connection processing is performed between a record between a logistics facility (supplement destination) and a logistics facility (supplement source) and between a logistics facility (supplement source at the next stage = supplement destination at the previous stage) and a logistics facility (supplement source at the previous stage). By handling record concatenation, the product can be delivered from the distribution facility (previous supply source) to the distribution facility (next supply source) via the distribution facility (previous supply destination = next supply source). Processing procedure for replenishment route / replenishment route connection processing except that it constitutes a regular route Since the delivery path, replenishment path connecting process is substantially the same, description thereof will be omitted.
FIG. 23 shows an example of a connection route configured based on the delivery route table, the replenishment route table, the connection a table, and the connection b table created as described above. The connection route in FIG. 23 can be appropriately displayed on the display device 51 in accordance with a display instruction from the user. FIG. 23 simply shows the connection state with the facility. For example, the location data (latitude / longitude) of the distribution facility table (FIG. 17) and the customer table (FIG. 8) are referred to and displayed on the map. May be. Note that the connecting route shown in FIG. 23 relates to a product whose product ID is G151.

[B-4] Total cost calculation function (Figures 29-31):
With reference to the flowcharts of FIGS. 29 to 31, the tables of FIGS. 20 to 21, and the explanatory diagram of FIG. 22, the function as the total cost calculation device will be described.
In the total cost calculation function, the cost (total cost) when the product selected by the user is delivered to the customer selected by the user through the connection route selected by the user is the respective cost in the connection route for the product. It is calculated based on the unit cost of the part (each logistics facility and each work process constituting the connection route) and the quantity to be delivered to the customer.

That is, when the user selects a desired customer and product, all of the connection routes that can deliver the product to the customer are the delivery route table (FIG. 20A) and the supply route table (FIG. 20B). ), The linked a table (FIG. 21A), and the linked b table (FIG. 21B), and are displayed as candidates for selection by the user.
In addition, when the user selects a desired connection route from among candidates displayed as selectable by an operation input, the cost for delivering the product to the customer through the selected connection route is calculated as a process product unit cost table ( It is calculated using the data read from FIG. 12B and displayed on the screen of the display device 51. As the display mode, for example, in the route display as shown in FIG. 22 (which may be displayed on a map), the selected route is highlighted, and the product and the cost are shown beside it. A display mode is conceivable.
In addition, when the user selects another connection route from among the displayed selectable routes, the cost for delivering the product to the customer via the other connection route is calculated in the same manner as above and selected first. Displayed along with the cost of the selected connection route or instead of the cost of the previously selected connection route.
Thereafter, when the user confirms any connection route by an operation input from the input device 55, the connection route is determined as a connection route for delivering the product to the customer, and a predetermined table (not shown). Registered in

Hereinafter, description will be made with reference to FIGS. 29 to 31.
When the combined route total cost display function is activated in response to a user input or the like, first, a customer and product selection screen is displayed on the display 51 (S601).
Next, the process proceeds to step S603, and merchandise and customers are displayed as candidates for user selection in each predetermined column in the screen displayed in step S601. In addition, it may replace with a candidate display or you may comprise so that a user can input arbitrary goods and a customer with a keyboard with a candidate display. The above candidate display can be performed based on the data of the product table (FIG. 10C) and the customer table (FIG. 18) in the database DB. When candidates are displayed, it is naturally possible to perform normal narrowing performed by imposing desired conditions on products and customers.

  The user selects a desired product and customer from those displayed in the screen for selecting the customer and the product (S605). Alternatively, the user inputs an arbitrary product and / or customer using the keyboard (S605). In the case of arbitrary input, if a customer or product not registered in the customer table or product table is input, a display to that effect is returned.

When a product and a customer are selected or designated by the user, a connected route configuration process (S607) is executed.
In the connection route configuration process (S607), a connection route that can deliver the selected product (S605) to the selected customer (S605), a delivery route table (FIG. 20A), and a supply route table (FIG. b)), a process that is configured based on data in the linked a table (FIG. 21A) and the linked b table (FIG. 21B) and is displayed so as to be selectable by user input.

The connection route configuration process (S607) will be described with reference to FIG.
First, the delivery route ID of a record having a customer and a product that matches the user selection is acquired from the delivery route table (S611). When there are a plurality of records having customers and products that match the user selection in the delivery route table, they are acquired in order and the following processing is executed in order.

  Next, a record having the delivery route ID acquired in step S611 in the “delivery route ID (supplement destination)” item is searched from the linked a table, and the value of the “supplement route ID (supplement source)” item is obtained. (S613). In the case where there are a plurality of records having the delivery route ID acquired in step S611 in the “delivery route ID (replenishment destination)” item in the linked a table, they are obtained in order and the following processing is executed in order.

  Next, a record having the replenishment route ID acquired in step S613 in the “replenishment route ID (replenishment destination)” item is searched from the linked b table, and the value of the “replenishment route ID (replenishment source)” item is obtained. (S615). When there are a plurality of records having the replenishment path ID acquired in step S613 in the “replenishment path ID (supplement destination)” item in the linked b table, they are acquired in order.

  When there are a plurality of corresponding records as described in the explanations of steps S611, S613, and S615, steps S611 to S615 are performed until all delivery route IDs and supply route IDs based on the user selection are acquired. Execute the process.

  Next, the delivery route ID acquired in steps S611, S613, and S615, the supply route ID associated with the delivery route ID (linked a table), and the supply route ID associated with the supplied route ID (linked b table). ), The associated delivery source facility ID, supply source facility ID, and supply source facility ID are acquired from the delivery route table and the supply route table (S621).

Next, based on the data acquired in association with each other in step S621 (the facility ID of the delivery source, the facility ID of the supply source, the facility ID of the supply source,...) Each of the connecting routes to the customer selected by the user through the distribution facility (next-stage supply source) and further through the distribution facility (terminal delivery source) is configured (S623). Note that the number of distribution facilities is not necessarily multi-stage, and there may be a distribution facility without a supply source.
As is clear from the above, each connected route constituted by this process is a set of associated facility IDs.
Thus, data that provides each connection route that can deliver the user-selected product to the user-selected customer is configured on the memory 30.
When the connected route configuration process ends, the process returns to the connected route total cost display process (FIG. 29), and proceeds to step S701.

In step S701, a connection route selection screen is displayed.
Next, it progresses to step S703. In step S703, the data of each connected route configured on the memory by the above-described connected route configuration process (S607) (direction of mutual distribution (the logistics facility reaching the customer at the bottom end and the logistics facility starting at the top end). ), The one or more connected routes that can be used to deliver the product to the customer are displayed in a selectable manner. The display may be performed, for example, as shown in FIG. 22, but may be a display in which the facilities constituting the connection route are entered in the same row (or the same column) as a list.

  When the user selects a desired connection route (S705), the process proceeds to “cost calculation / display processing (S707)” in which the total cost in the connection route is calculated and displayed.

  The cost calculation / display process (S707) is a know-how to calculate and display the cost for delivering the product selected by the user to the customer selected by the user using the connection route selected by the user.

The cost calculation / display process (S707) will be described with reference to FIG.
First, each facility ID of the connected route selected by the user in step S705 is acquired (S711).

Next, the unit cost for each work process (process product unit cost) determined by each acquired facility ID and the product ID that matches the user selection in step S605 is stored in the process product unit cost table (FIG. 12). (B)) respectively. In the process product unit cost table, as shown in the figure, the unit cost (process product unit cost) of the product is stored in association with the facility ID, the work process, and the product.
In this example, there is no designation of the type of work process, and all work processes in the corresponding facility are acquired. However, the work process type designated by the user (work process type for warehousing / storage / shipping, PtoP It is also possible to separately obtain the unit cost of the work process type and the horizontal work process type) and calculate the distribution cost in the case of the work process type. In other words, even when going through the same logistics facility, the cost differs depending on whether it is a normal work process (entry / storage / departure), PtoP, or horizontal holding, so compare these In this case, a configuration in which a user designates a work process type and displays the work process types so that they can be compared with each other is possible.

  Next, the product quantity is acquired (S715). The product quantity may be acquired from a predetermined table (not shown) having a quantity determined by the customer and the product that match the user selection in step S605, or configured to allow the user to input an operation. May be. Moreover, you may comprise so that either can be selected. The case where the quantity is determined by the customer and the product is a case where the customer regularly purchases the product in a predetermined quantity. In such a case, the data can be automatically set in step 715 by having the data in a predetermined table.

In this way, the unit cost (process product unit cost) related to the product of each work process of each facility constituting the connection route selected by the input from the input device 55 is acquired, and the quantity of the product is acquired. For each logistics facility that constitutes the consolidated route, calculate the logistics cost for each work process for the quantity of the product, and calculate the sum of those costs to determine the logistics cost for the consolidated route. Is displayed on the display (S717).
When another connection route is selected by the user (YES in S721), the same processing is executed for the selected connection route (S711 to S717).

  When the selected connection route is confirmed by the user (YES in S721), the cost calculation / display processing (S707) is exited and the distribution cost display processing for each connection route is displayed (FIG. 29), and the determined connection route is confirmed. Are stored in a predetermined table (not shown) (S709). The predetermined table having the connection route determined for the customer can be used for, for example, cost comparison in the case where a large number of customers are handled collectively and merchandise is delivered to the many customers.

  In the above, according to the designation of the customer and the product, available connection routes are displayed as candidates, and the total cost for the selected connection route is calculated and displayed. It is not limited to a specific example. For example, when the user designates an arbitrary distribution facility (delivery source) by input from the input device 55, the customers managed by the distribution facility (delivery source) are read from a predetermined table (not shown) and collectively. It may be configured to specify. The same applies to the relationship between the distribution facility (supplement source) and the distribution facility (supplement destination).

[B-5] Travel time calculation function:
Here, with reference to the flowchart of FIG. 32, the tables of FIGS. 15 to 19 and the explanatory diagram of FIG. With this function, a travel time table (FIG. 19) can be created.

First, two points that are targets for calculating the required travel time are acquired (S901). These two points can be, for example, two points designated by the user's operation input from the input device 55. Alternatively, two points may be extracted in order from a table having data on a large number of points according to a predetermined rule. Examples of the table having data at a number of points include a customer table (FIG. 18) and a distribution facility table (FIG. 17). When two points are extracted in order from a table having data of a large number of points according to a predetermined rule, the following steps S903 to S917 are executed for each of the two points extracted in that order.
The required travel time between two points is hereinafter also referred to as a time distance between the two points.

Next, the road IDs of one or more roads that are components of the connecting road connecting the two points acquired in step S901 are acquired from the road table (FIG. 16A) (S903). A road here is a section specified by a unique road ID, and is divided at an end of a road such as an intersection or a dead end, for example, between an intersection and an intersection or between an intersection and a dead end. In addition, it is a section in the road which is expressed as a single line (straight line / curve) without branching by being divided. In addition, the connected road is one or more routes specified as a calculation target of the required travel time from one or more routes connecting the two points. As this connection road, for example, one route arbitrarily designated by the operator from the input device 55 or a relatively small number of two or more routes may be adopted, and among the many routes connecting the two points. One route narrowed down by a known method or a relatively small number of two or more routes may be adopted. When a plurality of routes are employed as the connecting road, the travel time is determined for each. Further, as the connecting road, one specific route selected by the present apparatus according to a predetermined rule from two or more routes narrowed down to a relatively small number by a known method may be adopted. Examples of the predetermined rule include a rule that selects a route that has the shortest route from routes connecting two points, a rule that excludes a toll road, a rule that includes a toll road, and the like. It may be configured so that the operator can specify from the input device 55 which rule is adopted.
Whether a certain road (end-to-end road section) and another road (end-to-end road section) can be linked when extracting a route connecting two points However, this is because either one of the A end ID and B end ID (see FIG. 16A) of the certain road is the A end of the other certain road. The determination can be made based on whether the ID matches one of the ID and the B end ID. Note that the A end is one end, and the B end is the other end.

  Next, a road having a road ID of any one of the one or more roads (one or more roads that are components of a connecting road connecting two points) from which the road ID is obtained in step S903. All the pieces are extracted from the road piece table (FIG. 16B), and the length and mesh ID of each extracted road piece are obtained from the road piece table (FIG. 16B) (S905). In other words, the length and mesh ID of each road piece, which is a component of one or more roads for which the road ID has been obtained in step S903, are obtained from the road piece table (FIG. 16B) (S905). ). A road piece is a road portion obtained by dividing the road defined above at the boundary of a mesh (unit region). Since the unit required time of the mesh can be acquired from the distance time table (FIG. 15) using the mesh ID acquired as described above as a key, it is possible to obtain the required travel time for each extracted road piece.

The relationship between the above-described unit areas, road pieces, roads, etc. will be described with reference to FIG.
In FIG. 33, ad11, ad12, ec11, etc. are road names. In the road table of FIG. 16A, road names are written as Mizuho ad11, Mizuho ad12, Mizuho ec11, and the like. The A end ID and B end ID shown in FIG. 16A are also shown in FIG. In FIG. 33, 0150121, 0150122, 0150123, etc. are road segment IDs, and each shaded area and white area are unit areas (mesh). In the unit area, the mesh ID of the unit area is shown in association with FIG. 16B, and unit area names such as a and b are also shown.

Steps S907 to S915 are processes for obtaining the time required for moving each road piece acquired in step S905 in order for each road piece.
That is, the unit required time of the mesh (unit area) to which the road piece belongs is acquired from the distance time table (FIG. 15A) using the mesh ID associated with the road piece ID as a key (S909). ) The obtained unit required time is multiplied by the length of the road piece acquired in step S905 and normalized (divided by the unit distance) (S911), thereby obtaining the required time for moving the road piece.
This process is executed in order for the road pieces for which the ID has been acquired in step S905 (S907, S913, S915), thereby obtaining the required travel time for each road piece.
When the required travel time of all the road pieces that have acquired IDs in step S905 is obtained (YES in S915), the total sum is obtained (S917). In this way, the required travel time between the two points where the point data was acquired in step S901 is obtained.

In the distance time table described above, as shown in FIG. 15A, a mesh name and unit required time are associated with a unique mesh ID, and an application type ID is further associated. This application type ID represents an applicable time zone and / or day of the week. For example, as shown in the application type table of FIG. To express. Therefore, the record having the application type ID = 2 in the distance time table (FIG. 15A) indicates that the unit required time of the mesh ID of the record is the unit required time on weekdays. Accordingly, when the time zone and / or day of the week is specified prior to the calculation of the required travel time in FIG. 32, in step S909, the mesh ID associated with the road piece ID acquired in step S905 is included and The unit time required for the record having the specified application type ID is acquired. If no time zone or day of the week is specified, the unit required time of a record having an application type ID such as the time zone and day of the week corresponding to the current time is acquired.
As described above, the required travel time between the two points A and B is obtained. When obtaining the time required for movement between a large number of two points, the same processing as described above is performed.

[B-6] Time map display function:
The concept of a time map that can be used in the above-described delivery availability analysis function or the like will be described.
A time map is a distance between any two points on the time map that is moved by means of moving between these two points (motorcycles / passenger cars / trucks, freight cars / airplanes / ships, etc.) This is a map in which two points are arranged so as to be proportional to the required travel time. Therefore, when the time required for movement between two points varies depending on the time zone, day of the week, route to be selected, etc., the time maps are also different.
However, when displaying an image, a certain point (eg, point a) is specified, and is proportional to the required travel time from the specified point a, and in the normal map orientation viewed from the point a. Each point is arranged so as to match, and this is referred to as a time map viewed from the point a. As described above, the reason for specifying and indicating the point a at the time of image display is that the distance between the points is proportional to the travel time between three or more points, and the direction between the points is a normal map. This is because it is impossible to arrange each point so as to be in the azimuth direction.

  The entity of the time map is a required travel time table illustrated in FIG. 19 in the present apparatus. This travel time table is a table created by obtaining travel time for each of a number of two points extracted from a number of points (customers, logistics facilities). The travel required time calculation process described above is used to calculate the travel required time.

The block diagram which shows the structure of the apparatus of embodiment, and the function of a control apparatus. Explanatory drawing which shows the table which the database of FIG. 1 has. A part of flowchart which shows the procedure of a unit cost calculation process. A part of flowchart which shows the procedure of a unit cost calculation process. The remainder of the flowchart which shows the procedure of a unit cost calculation process. FIG. 6 is a part of a flowchart showing a procedure of process unit cost calculation processing for a facility i called in step S135 of FIG. The remainder of the flowchart showing the procedure of the process unit cost calculation process for the facility i called in step S135 of FIG. FIG. 8 is a part of a flowchart showing a procedure of process product unit cost calculation processing of each work process of the facility i called in step S165 of FIG. 7. The remainder of the flowchart showing the procedure of the process product unit cost calculation process of each work process of the facility i called in step S165 of FIG. FIG. 1 shows a part of the table of the database B in FIG. 1, (a) shows an income statement, (b) shows a balance sheet, and (c) shows an employee table. 1 shows a part of the table of the database B in FIG. 1, (a) shows a truck table, (b) shows a car case conversion table, (c) shows a product table, and (d) shows a delivery classification table. 1 shows a part of the table of the database B in FIG. 1, (a) shows a facility-specific product inventory table, and (b) shows a process product unit cost table. 1 shows a part of the table of the database B in FIG. 1, (a) shows a facility cost table, and (b) shows a process cost table. A part of table which the database B of FIG. 1 has is shown, (a) shows a work performance table, (b) shows a product processing result table. Explanatory drawing of a distance time table (a) and an application classification table (b). Explanatory drawing of a road table (a) and a road piece table (b). Explanatory drawing of a distribution facility table. Explanatory drawing of a customer table. Explanatory drawing of a movement required time table. Explanatory drawing of a delivery route table (a) and a supply route table (b). Explanatory drawing of a connection a table (a) and a connection b table (b). Explanatory drawing which shows the example of the connected regular route. The flowchart which shows a delivery route table creation process. The flowchart which shows a supply path table preparation process. Explanatory drawing of employ | adopting time equivalent to the diameter of the circle | round | yen which makes delivery permissible time a circumference as delivery range regulation time. Explanatory drawing of employ | adopting time equivalent to the diameter of the circle | round | yen which makes delivery permissible time a circumference as delivery range regulation time. The flowchart which shows a delivery route / supplement route connection process. The flowchart which shows a supply path and supply path connection process. The flowchart which shows the total cost display process according to connection route. FIG. 30 is a flowchart showing connection route configuration processing (S607) of FIG. 29; FIG. 30 is a flowchart showing cost calculation / display processing (S707) of FIG. The flowchart which shows a movement required time calculation process. Explanatory drawing of the method of calculating the time distance (= movement required time) between the A-B points in a figure.

Explanation of symbols

10 Control device 20 Auxiliary storage device (hard disk, etc.)
30 Memory (main storage device) (RAM)
51 Display Device 53 Printing Device 55 Input Device 57 Communication Device

Claims (10)

Profit and loss statement, balance sheet, employee table that can obtain the total number of employees, the total number of logistics workers, and the number of logistics workers at each logistics facility, and the total number of transport vehicles and standard vehicle conversion in terms of standard vehicle A storage device that holds a transport vehicle table capable of acquiring the number of transport vehicles of each logistics facility, interest rate data, and an inventory table capable of acquiring the stock amount of each logistics facility;
In the selling expenses, the expenses for the spatial and / or temporal movement of the goods are classified into the expenses for delivery of the goods and the expenses for non-delivery and are acquired from the income statement of the storage device, and the general administrative expenses From the income statement, the cost acquisition unit;
An employee data acquisition unit for acquiring the total number of employees, the total number of logistics workers, and the number of logistics workers at each logistics facility based on the data in the employee table of the storage device;
A logistics rate calculation unit that divides the total number of logistics workers acquired by the employee data acquisition unit by the total number of employees and sets the logistics rate;
The value obtained by multiplying the general management cost acquired by the cost acquisition unit by the distribution rate calculated by the distribution rate calculation unit and the non-delivery cost acquired by the cost acquisition unit is added as the total logistics operation cost. Total business cost calculation department,
An interest payment data acquisition unit that acquires the total stock from the balance sheet of the storage device, and acquires interest rate data of the storage device;
A total interest payment cost calculation unit that multiplies the total inventory acquired by the interest payment data acquisition unit by the interest data acquired by the interest payment data acquisition unit to obtain a total amount of logistics interest payments,
A vehicle cost acquisition unit for acquiring the total number of transport vehicles in terms of standard vehicle grades and the number of transport vehicles in each logistics facility in terms of standard vehicle grades based on data in the transport vehicle table of the storage device;
A vehicle rate calculating unit that divides the number of transport vehicles of any physical distribution facility acquired by the vehicle cost acquisition unit by the total number of transport vehicles and sets the vehicle rate of the physical distribution facility;
A facility vehicle cost calculation unit that multiplies the delivery cost acquired by the cost acquisition unit by the vehicle rate calculated by the vehicle rate calculation unit and sets the vehicle usage annual cost of the logistics facility corresponding to the vehicle rate;
A personnel rate calculation unit that divides the number of logistics workers in any logistics facility acquired by the employee data acquisition unit by the total number of logistics workers and sets the logistics facility personnel rate;
The facility operation cost calculation unit which multiplies the logistics operation total cost calculated by the operation total cost calculation unit by the personnel rate calculated by the personnel rate calculation unit to obtain the logistics operation annual cost of the logistics facility corresponding to the personnel rate. When,
An inventory amount acquisition unit for acquiring an inventory amount of an arbitrary logistics facility based on data in an inventory table of the storage device;
An inventory rate calculation unit that divides the inventory amount acquired by the inventory amount acquisition unit by the total amount of inventory acquired by the interest payment data acquisition unit and sets the inventory rate of the logistics facility corresponding to the inventory amount;
The facility interest rate calculated as the annual interest expense of the logistics facility corresponding to the inventory rate by multiplying the total amount of logistics interest payment calculated by the total interest payment cost unit by the inventory rate calculated by the inventory rate calculation unit. Payment expense calculation part,
With respect to the same logistics facility, a facility annual cost calculation unit that adds the vehicle usage annual cost, the logistics service annual cost, and the logistics interest payment annual cost as the facility annual cost of the logistics facility;
A facility unit cost calculation unit that divides the facility year cost calculated by the facility year cost calculation unit by a predetermined value to be a facility unit cost of a unit period determined by the predetermined value;
A unit cost calculation device comprising: Profit and loss statement, employee table that can obtain the total number of employees, the total number of logistics workers, and the number of logistics workers at each logistics facility, and the total number of transport vehicles in terms of standard vehicles and each logistics facility in terms of standard vehicles A transport vehicle table capable of acquiring the number of transport vehicles, and a storage device holding the transport vehicle table,
In the selling expenses, the expenses for the spatial and / or temporal movement of the goods are classified into the expenses for delivery of the goods and the expenses for non-delivery and are acquired from the income statement of the storage device, and the general administrative expenses From the income statement, the cost acquisition unit;
An employee data acquisition unit for acquiring the total number of employees, the total number of logistics workers, and the number of logistics workers at each logistics facility based on the data in the employee table of the storage device;
A logistics rate calculation unit that divides the total number of logistics workers acquired by the employee data acquisition unit by the total number of employees and sets the logistics rate;
The value obtained by multiplying the general management cost acquired by the cost acquisition unit by the distribution rate calculated by the distribution rate calculation unit and the non-delivery cost acquired by the cost acquisition unit is added as the total logistics operation cost. Total business cost calculation department,
A vehicle cost acquisition unit for acquiring the total number of transport vehicles in terms of standard vehicle grades and the number of transport vehicles in each logistics facility in terms of standard vehicle grades based on data in the transport vehicle table of the storage device;
A vehicle rate calculating unit that divides the number of transport vehicles of any physical distribution facility acquired by the vehicle cost acquisition unit by the total number of transport vehicles and sets the vehicle rate of the physical distribution facility;
A facility vehicle cost calculation unit that multiplies the delivery cost acquired by the cost acquisition unit by the vehicle rate calculated by the vehicle rate calculation unit and sets the vehicle usage annual cost of the logistics facility corresponding to the vehicle rate;
A personnel rate calculation unit that divides the number of logistics workers in any logistics facility acquired by the employee data acquisition unit by the total number of logistics workers and sets the logistics facility personnel rate;
The facility operation cost calculation unit which multiplies the logistics operation total cost calculated by the operation total cost calculation unit by the personnel rate calculated by the personnel rate calculation unit to obtain the logistics operation annual cost of the logistics facility corresponding to the personnel rate. When,
With respect to the same logistics facility, a facility annual cost calculation unit that adds the annual cost of using the vehicle and the annual cost of the logistics business to determine the facility annual cost of the logistics facility;
A facility unit cost calculation unit that divides the facility year cost calculated by the facility year cost calculation unit by a predetermined value to be a facility unit cost of a unit period determined by the predetermined value;
A unit cost calculation device comprising: Profit and loss statement, balance sheet, employee table that can obtain the total number of employees, total number of logistics workers and number of logistics workers at each logistics facility, total number of transportation vehicles and number of transportation vehicles at each logistics facility can be obtained A storage device that holds a transport vehicle table, interest rate data, and an inventory table from which the stock amount of each logistics facility can be acquired;
In the selling expenses, the expenses for the spatial and / or temporal movement of the goods are classified into the expenses for delivery of the goods and the expenses for non-delivery and are acquired from the income statement of the storage device, and the general administrative expenses From the income statement, the cost acquisition unit;
An employee data acquisition unit for acquiring the total number of employees, the total number of logistics workers, and the number of logistics workers at each logistics facility based on the data in the employee table of the storage device;
A logistics rate calculation unit that divides the total number of logistics workers acquired by the employee data acquisition unit by the total number of employees and sets the logistics rate;
The value obtained by multiplying the general management cost acquired by the cost acquisition unit by the distribution rate calculated by the distribution rate calculation unit and the non-delivery cost acquired by the cost acquisition unit is added as the total logistics operation cost. Total business cost calculation department,
An interest payment data acquisition unit that acquires the total stock from the balance sheet of the storage device, and acquires interest rate data of the storage device;
A total interest payment cost calculation unit that multiplies the total inventory acquired by the interest payment data acquisition unit by the interest data acquired by the interest payment data acquisition unit to obtain a total amount of logistics interest payments,
A vehicle cost acquisition unit for acquiring the total number of transport vehicles and the number of transport vehicles at each logistics facility based on the transport vehicle table data of the storage device;
A vehicle rate calculating unit that divides the number of transport vehicles of any physical distribution facility acquired by the vehicle cost acquisition unit by the total number of transport vehicles and sets the vehicle rate of the physical distribution facility;
A facility vehicle cost calculation unit that multiplies the delivery cost acquired by the cost acquisition unit by the vehicle rate calculated by the vehicle rate calculation unit and sets the vehicle usage annual cost of the logistics facility corresponding to the vehicle rate;
A personnel rate calculation unit that divides the number of logistics workers in any logistics facility acquired by the employee data acquisition unit by the total number of logistics workers and sets the logistics facility personnel rate;
The facility operation cost calculation unit which multiplies the logistics operation total cost calculated by the operation total cost calculation unit by the personnel rate calculated by the personnel rate calculation unit to obtain the logistics operation annual cost of the logistics facility corresponding to the personnel rate. When,
An inventory amount acquisition unit for acquiring an inventory amount of an arbitrary logistics facility based on data in an inventory table of the storage device;
An inventory rate calculation unit that divides the inventory amount acquired by the inventory amount acquisition unit by the total amount of inventory acquired by the interest payment data acquisition unit and sets the inventory rate of the logistics facility corresponding to the inventory amount;
The facility interest rate calculated as the annual interest expense of the logistics facility corresponding to the inventory rate by multiplying the total amount of logistics interest payment calculated by the total interest payment cost unit by the inventory rate calculated by the inventory rate calculation unit. Payment expense calculation part,
With respect to the same logistics facility, a facility annual cost calculation unit that adds the vehicle usage annual cost, the logistics service annual cost, and the logistics interest payment annual cost as the facility annual cost of the logistics facility;
A facility unit cost calculation unit that divides the facility year cost calculated by the facility year cost calculation unit by a predetermined value to be a facility unit cost of a unit period determined by the predetermined value;
A unit cost calculation device comprising: Income statement, employee table that can obtain the total number of employees, total number of logistics workers and the number of logistics workers at each logistics facility, transportation vehicle table that can obtain the total number of transportation vehicles and the number of transportation vehicles at each logistics facility, A storage device holding
In the selling expenses, the expenses for the spatial and / or temporal movement of the goods are classified into the expenses for delivery of the goods and the expenses for non-delivery and are acquired from the income statement of the storage device, and the general administrative expenses From the income statement, the cost acquisition unit;
An employee data acquisition unit for acquiring the total number of employees, the total number of logistics workers, and the number of logistics workers at each logistics facility based on the data in the employee table of the storage device;
A logistics rate calculation unit that divides the total number of logistics workers acquired by the employee data acquisition unit by the total number of employees and sets the logistics rate;
The value obtained by multiplying the general management cost acquired by the cost acquisition unit by the distribution rate calculated by the distribution rate calculation unit and the non-delivery cost acquired by the cost acquisition unit is added as the total logistics operation cost. Total business cost calculation department,
A vehicle cost acquisition unit for acquiring the total number of transport vehicles and the number of transport vehicles at each logistics facility based on the transport vehicle table data of the storage device;
A vehicle rate calculating unit that divides the number of transport vehicles of any physical distribution facility acquired by the vehicle cost acquisition unit by the total number of transport vehicles and sets the vehicle rate of the physical distribution facility;
A facility vehicle cost calculation unit that multiplies the delivery cost acquired by the cost acquisition unit by the vehicle rate calculated by the vehicle rate calculation unit and sets the vehicle usage annual cost of the logistics facility corresponding to the vehicle rate;
A personnel rate calculation unit that divides the number of logistics workers in any logistics facility acquired by the employee data acquisition unit by the total number of logistics workers and sets the logistics facility personnel rate;
The facility operation cost calculation unit which multiplies the logistics operation total cost calculated by the operation total cost calculation unit by the personnel rate calculated by the personnel rate calculation unit to obtain the logistics operation annual cost of the logistics facility corresponding to the personnel rate. When,
With respect to the same logistics facility, a facility annual cost calculation unit that adds the annual cost of using the vehicle and the annual cost of the logistics business to determine the facility annual cost of the logistics facility;
A facility unit cost calculation unit that divides the facility year cost calculated by the facility year cost calculation unit by a predetermined value to be a facility unit cost of a unit period determined by the predetermined value;
A unit cost calculation device comprising: Income statement, employee table that can obtain the total number of employees, total number of logistics workers and the number of logistics workers at each logistics facility, transportation vehicle table that can obtain the total number of transportation vehicles and the number of transportation vehicles at each logistics facility, A storage device holding
In the selling expenses, the expenses for the spatial and / or temporal movement of the goods are classified into the expenses for delivery of the goods and the expenses for non-delivery and are acquired from the income statement of the storage device, and the general administrative expenses From the income statement, the cost acquisition unit;
Costs related to logistics operations are determined based on the total number of logistics workers and the total number of employees in the general management costs acquired by the cost acquisition unit, and the calculated costs and non-delivery costs acquired by the cost acquisition unit Total operation cost calculation department with the sum of
Of the delivery costs acquired by the cost acquisition unit, a cost to be allocated to a certain logistics facility is obtained based on the number of transport vehicles and the total number of transport vehicles of the logistics facility, and the obtained cost is determined by the vehicle of the logistics facility. Facility vehicle cost calculation part to be used as the annual cost of use,
Of the logistics business costs calculated by the business cost calculation unit, a cost to be allocated to a certain logistics facility is obtained based on the number of logistics workers in the logistics facility and the total number of logistics workers, and the obtained cost is The facility operation cost calculation section, which is the annual logistics operation cost of the facility,
A facility unit cost calculation unit that divides the sum of the vehicle use annual cost and the logistics service annual cost related to the same logistics facility by a predetermined value and sets the unit cost of the unit period determined by the predetermined value;
A unit cost calculation device comprising: In claim 5,
The storage device further holds a balance sheet, interest rate data, and an inventory table from which the inventory amount of each logistics facility can be acquired,
Further, among the total amount of logistics interest payments obtained by multiplying the total inventory of the balance sheet held by the storage device by the interest rate determined by the interest rate data, the cost to be allocated to a certain logistics facility is the inventory amount of the logistics facility. And a facility interest payment cost calculation unit that determines the calculated cost as the annual cost of logistics interest payment of the logistics facility,
The facility unit cost calculation unit divides the sum of the vehicle use annual cost, the logistics service annual cost and the logistics interest payment annual cost for the same logistics facility by a predetermined value, and the facility unit cost for a unit period determined by the predetermined value, To
A unit cost calculation device characterized by that. In claim 2, claim 4 or claim 5,
The storage device is further capable of acquiring facility year work hours, which is the sum of work hours for each logistics facility in the settlement period, for each logistics facility, and for each logistics facility in the settlement period and excluding the delivery process. We have a work performance table that can obtain the process year work time, which is the sum of other work hours, by logistics facility and by work process excluding the delivery process,
further,
The cost to be allocated to a certain work process excluding the delivery process in the distribution work annual cost of a certain logistics facility calculated by the facility work cost calculation unit, the process year work time of the work process and the facility of the logistics facility A process annual cost calculation unit that calculates the calculated cost based on the annual work hours,
A process unit cost calculation unit that divides the process annual cost calculated by the process cost calculation unit by a predetermined value to be a process unit cost of a unit period determined by the predetermined value;
A delivery process unit cost calculation unit configured to divide a vehicle use year cost of a certain logistics facility calculated by the facility vehicle cost calculation unit by a predetermined value and set a delivery process unit cost for a unit period determined by the predetermined value;
A unit cost calculation device comprising: In claim 1, claim 3 or claim 6,
The storage device is further capable of acquiring facility year work hours, which is the sum of work hours for each logistics facility in the settlement period, for each logistics facility, and for each logistics facility in the settlement period and excluding the delivery process. We have a work performance table that can obtain the process year work time, which is the sum of other work hours, by logistics facility and by work process excluding the delivery process,
further,
The cost to be allocated to a certain work process excluding the delivery process in the distribution work annual cost of a certain logistics facility calculated by the facility work cost calculation unit, the process year work time of the work process and the facility of the logistics facility A process annual cost calculation unit that calculates the calculated cost based on the annual work hours,
A process unit cost calculation unit that divides the process annual cost calculated by the process cost calculation unit by a predetermined value to be a process unit cost of a unit period determined by the predetermined value;
When the process unit cost calculated by the process unit cost calculation unit is a process unit cost of the storage process, a value obtained by dividing the logistics interest payment annual cost calculated by the facility interest payment cost calculation unit by the predetermined value In addition to the unit cost, the process unit cost correction part to be the process unit cost of the storage process,
A delivery process unit cost calculation unit configured to divide a vehicle use year cost of a certain logistics facility calculated by the facility vehicle cost calculation unit by a predetermined value and set a delivery process unit cost for a unit period determined by the predetermined value;
A unit cost calculation device comprising: In claim 7 or claim 8,
The work performance table held by the storage device further includes the process product annual work time for each logistics facility in the settlement period, which is the sum of the work hours for each work facility and each product excluding the delivery process. And can be obtained by work process and product, excluding the delivery process,
The storage device further includes a delivery volume for each logistics facility and a delivery volume for each logistics facility and each product, a product processing quantity for each logistics facility and each work process, and each logistics facility and each work process in the settlement period. We have a product processing table that can acquire the product processing quantity for each product,
further,
The cost to be allocated to a certain product among the process year costs of a certain work process excluding the delivery process of a certain logistics facility calculated by the process year cost calculation unit is the process product year of the product in the work process. A process product annual cost calculation unit that calculates the work time and the process year work time of the work process, and sets the calculated cost as the process product annual cost of the product of the work process of the physical distribution facility;
The process product unit cost calculated by the process product annual cost calculation unit is divided by the processing quantity of the product of the work process to be the process product unit cost of the product of the work process of the physical distribution facility. The cost calculator,
The delivery process product annual cost, which is the cost to be allocated to a certain product among the vehicle use annual costs of a certain distribution facility calculated by the facility vehicle cost calculation unit, is calculated as the delivery volume of the product and the distribution in the distribution facility. The delivery process product of the product in the distribution process of the physical distribution facility is calculated based on the delivery volume of all the products of the facility, and the annual cost of the delivery process product obtained is divided by the processing quantity of the product in the delivery process. Delivery process unit cost calculation unit to be unit cost,
A unit cost calculation device comprising:   A program for causing a computer to function as the unit cost calculation device according to any one of claims 1 to 9.

Images