The present invention relates to a device for assisting in determining a supply group in a supply chain.
The background art in the technical field of the present invention includes Japanese Patent Laid-open Publication No. 2006-347690 (Patent Literature 1). This publication describes “planning an optimum transport route that accomplishes a drop in logistics expense by taking the sub-assembly of parts into consideration when a new parts supplier is set and a new transport route is designed” (see Abstract).
[PTL 1] Japanese Patent Laid-open Publication No. 2006-347690
A mechanism of calculating a transport route that accomplishes milk run at a low cost by grouping suppliers that supply parts to one factory is disclosed in Patent Literature 1. However, the mechanism of Patent Literature 1 in which suppliers are grouped does not make room for management cost, which is in proportion to the number of bases included in a group, and receiving a supply of parts from another group. The mechanism is therefore incapable of supply group grouping of the entire supply chain, which requires management such as sharing information among bases within one same group and allows a group that is running short of supply to ask another group to supply.
Accordingly, a problem to be solved is how to perform overall supply group calculation for the entire supply chain that involves evaluating management cost based on the number of bases included in a supply group and allowing a supply group to receive a supply of a product from another group under a condition different from its own condition.
This application includes a plurality of means for solving the above-mentioned problem, an example of which is as follows. According to one embodiment of the present invention, there is provided a supply group determination assisting device configured to group suppliers, factories, warehouses, and markets, which are bases and for which supply plans are formulated, into supply groups, the supply group determination assisting device including: a storing unit configured to store supply information including a plurality of records each of which associates information about a shipment arrival base and information about a sender base with a transport lead time or transport cost of transportation between the shipment arrival base and the sender base; and a supply group determining unit configured to use, as an evaluation value, the transport lead time or transport cost of the supply information stored in the storing unit, and group the shipment arrival bases and the sender bases into a plurality of groups by grouping the shipment arrival bases and the sender bases in the plurality of records based on magnitude of the evaluation value.
According to the one embodiment of the present invention, a user is assisted in grouping bases in a supply chain. This enables the user to select, for example, a supply group count and supply group grouping that fulfill an objective total cost and an objective delivery delay that are set in business policies of the user's company, and, by conducting actual product supply in conformity with the supply group grouping selected by the user, to keep the actual total cost and the actual delivery delay equal to or less than the objective levels.
Now, an embodiment of the present invention is described with reference to the drawings.
In this embodiment, supply group grouping in which the supply group count is 1 to 3 is executed to evaluate total costs and delivery delays, which are displayed for comparison.
The supply group determination assisting device, which is denoted by 100, includes an input unit 110, a storing unit 120, a supply group determining unit 130, and a display unit 140. The input unit 110 reads supplement plan information, order information, supply information, product configuration information, factory information, warehouse information, base management cost information, inter-supply group supply condition information, and supply group calculation condition information, which are external data, and stores the external data in the storing unit 120.
The storing unit 120 stores the supplement plan information, the order information, the supply information, the product configuration information, the factory information, the warehouse information, the base management cost information, the inter-supply group supply condition information, and the supply group calculation condition information, which are external data.
The supply group determining unit 130 uses the supplement plan information, order information, supply information, product configuration information, factory information, warehouse information, base management cost information, inter-supply group supply condition information, and supply group calculation condition information stored in the storing unit 120 to vary the supply group count from 1 to a maximum supply group count, to determine supply group grouping for each supply group count separately, to calculate a supply plan, and to calculate a cost and a delivery delay. The display unit 140 is a user interface for displaying various operation screens, images, and the like following instructions from other function units.
The CPU 200 is a unit that executes various types of computing. The CPU 200 executes various types of processing by running a given supply group calculation program (not shown), which is loaded onto the RAM 210 from the auxiliary storage device 230.
The supply group calculation program is, for example, an application program that can be run on an operating system (OS) program. The supply group calculation program may be installed in the auxiliary storage device 230 from, for example, a portable storage medium via the media reading device 260.
The RAM 210 is a memory that stores, among others, programs executed by the CPU 200, and data necessary to execute the programs. The ROM 220 is a memory that stores, among others, a program necessary to boot up the supply group determination assisting device 100.
The auxiliary storage device 230 is a hard disk drive (HDD) or a similar device, or may be a solid state drive (SSD) that uses a flash memory or the like. The display device 240 is a CRT display, a liquid crystal display, an organic electro-luminescence (EL) display, or a similar device . The input device 250 is a keyboard, a mouse, a microphone, and/or other similar devices. The media reading device 260 is a device for reading information out of a CD-ROM and other portable storage media that can be carried around. The communication device 270 inputs and outputs data to and from an external device via a network 280.
The processing procedures (1) to (5) of
(1) External Data Reading Processing
In (1) external data reading processing 310 of
The external data reading processing 310 involves storing, in the storing unit 120, data taken in by the input unit 110 of
After the pieces of external data of
(2) Supply Group Grouping Determination Processing
In (2) supply group grouping determination processing 320 of
The supply group grouping determination processing 320 is described below with reference to
When the given supply group count is 2 or more, the supply information 600 is sorted by an evaluation value that is used as a reference for grouping. The evaluation value in this embodiment is the unit transport cost. First, the supply information 600 is sorted in the ascending order of unit transport cost that is the evaluation value. Next, grouping processing is executed sequentially from the first to the last of the sorted records.
One record of the sorted supply information 600 is selected and, in the case where a shipment arrival base in the selected record has not been assigned to a group by grouping, a new supply group is created and the shipment arrival base is assigned to the created group. A supply group to which a sender base in the selected record belongs is determined next. In the case where the sender base has already been assigned to a group by grouping, the supply group to which the sender base belongs and the supply group to which the shipment arrival base belongs are integrated into one supply group. In the case where the sender base has not been assigned to a group by grouping, the sender base is assigned to the supply group to which the shipment arrival base belongs. One record of processing is thus completed.
In the case where one record is selected, all bases have been grouped by the processing up through the one record, and when the number of supply groups generated matches the given supply group count is finished, supply group grouping is ended. After the supply group grouping, (3) supply plan calculation processing 330 is executed.
The evaluation value may use two values, the unit transport cost and the transport lead time, which are added after weighted. For example, the weight of the unit transport cost may be set to 10 so that the evaluation value is calculated by 10×unit transport cost+transport lead time. Alternatively, a capacity utilization ratio may be obtained by dividing a supplement plan by the production capacity to be used as one of evaluation values.
Bases may be grouped so that each supply group includes at least one supplier, one factory, one warehouse, and one market, which are functions of a supply chain. In this case, whether each supply group includes at least one each of the functions is checked after the supply group grouping is finished and, if there is a supply group that lacks a type of function, a supply group that has a plurality of bases of this type of function is searched for and one of those bases that has the smallest evaluation value is moved to the lacking supply group.
(3) Supply Plan Calculation Processing
Next, sequentially from Supply Group 1, a delivery quantity is subtracted from an order quantity for each warehouse at each date from the first day to the last day of calculation, in order to calculate a delivery delay in the number of pieces and in days for each order placed. When the calculated delivery delay in days is equal to or more than the inter-supply group supplement target delivery delay of the supply group calculation condition information 1200, whether or not the product in question can be supplied from another supply group on the delivery delay start day at the base in question is checked by a method described below.
The supply information 600 is searched for other supply groups in ascending order of the unit transport cost of transportation to the base in question that is experiencing a delivery delay, a record that has this base as the shipment arrival base is searched for in order to extract the sender base of this record, and a record is identified in which the stock quantity at the extracted base on a day when (delivery delay start day−transport lead time of the record) is established is equal to or more than the shortage. In the case where this record is found, a supply plan is added with the delivery delay start day set as an arrival date, the extracted sender base set as the sender base of this record, the transport means in question set as the transport means of this record, and the shortage set as a shipment quantity. Thereafter, (4) delivery delay/cost calculation processing 340 is executed.
(4) Delivery Delay/Cost Calculation Processing
In the delivery delay/cost calculation processing 340, a delivery delay and a total cost are calculated. The supply plan information 1700 and the order information 500 are used to calculate a delivery delay for each maximum supply group count. For each base, each item, and each date, an accumulated order quantity and an accumulated transport quantity from the first day are compared and, in the case where the accumulated order quantity is larger, (accumulated order quantity−accumulated transport quantity) is added as a delivery delay.
The total cost is defined as the sum of a transport expense, a base fixed expense, and a base management expense. The transport expense is calculated with the use of the supply information 600, the inter-supply group supply condition information 1100, the supply group grouping information 1600, and the supply plan information 1700. The supply plan information 1700 is searched for a record where the shipment arrival base name, the sender base name, and the transport means name match those of the supply information, and the unit transport cost of this record is identified. The shipment arrival base and the sender base in this record are used to search the supply group grouping information 1600, and, in the case where the shipment arrival base and the sender base have different supply group numbers, the unit transport cost of the record is multiplied by “1.2”, which is defined in the inter-supply group supply condition information 1100 as a difference from the unit transport cost of transportation within one same supply group. A product of the unit transport cost and the transport quantity of the supply plan information 1700 is the transport expense of the record in question. The transport expenses of the respective records are added up for each maximum supply group count, to thereby obtain the transport expense of this maximum supply group count.
The base fixed expense is calculated with the use of the factory information 800, the warehouse information 900, and the supply group grouping information 1600. First, the supply group grouping information 1600 is searched for records where the use determination 1440 is “used”, and base names are extracted from the records. The factory information 800 and the warehouse information 900 are searched for records that have the extracted base names, and in each record found, the fixed expense is multiplied by a calculation period in order to obtain a fixed expense at the base in question. For each maximum supply group count, the fixed expenses of bases that are used are added up to calculate the base fixed expense.
The base management expense is calculated with the use of the base management cost information 1000 and the supply group grouping information 1600. For each maximum supply group count and each supply group number, how many records in the supply group grouping information 1600 have “used” as the use determination 1440 is counted. The base management cost information 1000 is searched in order to identify a record whose intra-supply group base count contains the counted record count, the management cost of the identified record is multiplied by the calculation period, and the resultant value is the base management cost of a supply group that has the supply group number in question. For each maximum supply group count, the base management costs of supply groups having supply group numbers that are within the maximum supply group count are added up to obtain the base management cost of this maximum supply group count. The total cost may include labor costs and utility charges at the respective factories, material costs charged by suppliers, and the like.
The cost may include risks such as an item running out and carrying a stock, which are converted into costs to be evaluated. For example, a product running out of stock can be converted into a cost by multiplying the sales price of the product by the number of pieces of the product that have run out, and thus obtaining a missed sales amount. Overstock can be converted into a cost by multiplying a depreciation by the number of pieces of the stocked item, and thus obtaining a stock depreciation amount. The total cost may include an item running out, carrying a stock, and other risks that are converted into a cost so that bases are grouped with the total cost as an evaluation index.
While one calculation result is shown for each supply group count in
(5) Result Display Processing
In (5) result display processing 350 of
The display screen of
The present invention is not limited to the embodiment described above and covers various modification examples. For instance, the embodiment described above is a detailed description written for an easy understanding of the present invention, and the present invention is not necessarily limited to a configuration that includes all of the described components. The configuration of one embodiment may partially be replaced by the configuration of another embodiment. The configuration of one embodiment may be joined by the configuration of another embodiment. In each embodiment, a part of the configuration of the embodiment may have another configuration added thereto or removed therefrom, or may be replaced by another configuration.
Some of or all of the configurations, functions, processing units, processing means, and the like described above may be implemented by hardware by, for example, designing those as an integrated circuit. The configurations, functions, and the like described above may be implemented by software through a processor's interpretation and execution of programs for implementing the respective functions. The programs for implementing the functions and information such as tables and files can be put in a memory, in a recording device such as a hard disk or a solid state drive (SSD), or in a storage medium such as an IC card, an SD card, or a DVD.
Control lines or information lines considered necessary for description are illustrated, and not all control lines and information lines are necessarily illustrated. It may be considered that almost all configurations are actually mutually connected to each other.
100 . . . supply group determination assisting device according to the first embodiment, 110 . . . input unit, 120 . . . storing unit, 130 . . . supply group determining unit, 140 . . . display unit, 200 . . . CPU, 210 . . . RAM, 220 . . . ROM, 230 . . . auxiliary storage device, 240 . . . display device, 250 . . . input device, 260 . . . media reading device, 270 . . . communication device, 280 . . . network, S310 . . . external data reading processing, S320 . . . supply group grouping determination processing, S330 . . . supply plan calculation processing, S340 . . . delivery delay/cost calculation processing, S350 . . . result display processing, 410 . . . supplement date, 420 . . . product name, 430 . . . base name, 440 . . . supplement quantity, 510 . . . order reception date, 520 . . . product name, 530 . . . base name, 540 . . . order quantity, 610 . . . shipment arrival base name, 620 . . . sender base name, 630 . . . transport means name, 640 . . . transport lead time, 650 . . . unit transport cost, 710 . . . parent item name, 720 . . . child item name, 730 . . . per-assembly component quantity, 810 . . . base name, 820 . . . production capacity, 830 . . . fixed expense, 910 . . . base name, 920 . . . fixed expense, 1010 . . . intra-supply group base count, 1020 . . . management cost 1110 . . . intra-supply group supply condition item, 1120 . . . difference from supply within one supply group, 1210 . . . calculation condition item, 1220 . . . value, 1410 . . . supply group count, 1420 . . . supply group number, 1430 . . . base name, 1440 . . . use determination, 1610 . . . supply group count, 1620 . . . supply group number, 1630 . . . item name, 1640 . . . shipment arrival base name, 1650 . . . sender base name, 1660 . . . transport means name, 1710 . . . supply group count, 1720 . . . arrival date, 1730 . . . item name, 1740 . . . shipment arrival base name, 1750 . . . sender base name, 1760 . . . transport means name, 1770 . . . shipment quantity, 1910 . . . supply group count, 1920 . . . transport expense, 1930 . . . base fixed expense, 1940 . . . base management expense, 1950 . . . total cost, 1960 . . . delivery delay, 2000 . . . supply group calculation result screen
Filing Document | Filing Date | Country | Kind |
---|---|---|---|
PCT/JP2013/056890 | 3/13/2013 | WO | 00 |