Procurement adjustment support system and procurement adjustment support method
The material procurement coordination support system addresses supply shortages during disasters by distributing orders among multiple suppliers, leveraging historical data and real-time adjustments to prevent over-concentration and ensure adequate supply distribution.
Patent Information
- Application Number
- JP2023071549
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Filing Date
- 2023-04-25
- Publication Date
- 2024-11-07
AI Technical Summary
During abnormal times, such as disasters, orders for supplies from a specific supplier are concentrated, leading to an excess of orders that the supplier cannot fulfill, resulting in shortages in affected areas.
A material procurement coordination support system that includes a control unit, storage units, and input/output units to estimate and adjust orders among multiple suppliers, preventing over-concentration of orders on a single supplier by recommending alternative suppliers and adjusting procurement plans based on historical transaction data and disaster-specific conditions.
The system effectively distributes supplies by avoiding over-ordering from a single supplier, reducing the risk of shortages in disaster-stricken areas and ensuring timely delivery of necessary materials.
Smart Images

Figure 2024157279000001_ABST
Abstract
Description
[Technical field]
[0001] The present invention relates to a system and method for supporting material procurement coordination in emergency situations. [Background technology]
[0002] When natural disasters such as earthquakes occur, activities are carried out to procure supplies to support the affected areas and deliver them to the affected areas.
[0003] Patent Document 1 discloses a material distribution support method and system described below, which aims to enable appropriate distribution of limited materials in consideration of the needs of disaster victims and the situation at evacuation shelters when a disaster occurs, and to appropriately select and determine a material supply organization that will provide the materials. The evacuation shelter device receives evacuation shelter information, such as needs information entered by the disaster victims themselves, the number of evacuees entered by the person in charge at the evacuation shelter, and the damage situation around the evacuation shelter, and transmits it to the local government device. The local government device distributes materials appropriately to each evacuation shelter based on the needs information and the stock of the material supply organization, and then distributes materials appropriately to each evacuation shelter again, taking into account the amount of materials provided in the past and the average material consumption per person at each evacuation shelter, and registers the results. The technology disclosed involves the local government's device selecting and deciding which organization will provide supplies on a priority basis based on indicators such as the distance between the evacuation shelter and the supply organization's base, the amount of supplies in stock, etc., and once the supply organization has been decided, transmitting supply arrangement information such as the address of the evacuation shelter to which the supplies will be provided and the amount required to the supply organization.
[0004] Patent Document 2 discloses a material distribution support method and system described below, which aims to provide a blanket order intermediation service that effectively compiles multiple pieces of order information individually from orderers and transmits the information to the most suitable supplier when intermediating order transactions via a network. The order intermediation server receives and collects and manages each piece of individual order information transmitted from multiple order source terminals via a network, and creates blanket order information that compiles multiple individual orders with overlapping desired delivery dates for each ordered item, based on the ordered items and their desired delivery dates contained in each piece of individual order information. The order intermediation server discloses a technique in which the order intermediation server determines the most suitable supplier based on this blanket order information, and transmits the blanket order information to the supplier terminal. [Prior art documents] [Patent documents]
[0005] [Patent Document 1] JP 2006-188331 A [Patent Document 2] JP 2003-233737 A Summary of the Invention [Problem to be solved by the invention]
[0006] In conventional technology, in the event of an emergency (such as a disaster), orders for supplies are concentrated at a particular supplier, resulting in a situation where the orders exceed the amount the supplier can supply, making it difficult to supply supplies and causing shortages in certain areas (such as disaster-stricken areas). [Means for solving the problem]
[0007] The material procurement coordination support system supports the coordination of material procurement, comprising a control unit that executes calculation processing, a memory unit accessible by the control unit, and an input / output unit, and supports a purchaser of material ordering material to a material business operator and the material business operator in supplying the material in response to the order, wherein the control unit estimates the amount of the order volume accepted by the first material business operator to be externally procured by a second material business operator based on the material business operator's trading performance in a first state which is normal times, estimates the amount of the order volume accepted by the first material business operator to be externally procured by the second material business operator based on past procurement performance in a second state different from the first state, estimates the order volume to be sent to the first material business operator based on the amount externally procured in the first state and the amount externally procured in the second state, and outputs the estimated order volume to the first material business operator. Effect of the Invention
[0008] In the event of a disaster, excessive ordering of supplies from a specific supplier is avoided, the supply of supplies is smoothly advanced, and the risk of a shortage of supplies in a specific area is reduced. Problems, configurations, and effects other than those described above will become apparent from the following description of the embodiment of the invention. [Brief description of the drawings]
[0009] [Figure 1] FIG. 13 is a diagram showing a conceptual example of a flow of material procurement coordination. [Diagram 2] FIG. 1 is a diagram illustrating an example of a system configuration of a supplies procurement coordination support system. [Figure 3A] FIG. 2 is a diagram illustrating an example of a data configuration of a procurement coordination management database. [Figure 3B] FIG. 2 is a diagram illustrating an example of a data configuration of a procurement coordination management database. [Figure 4] FIG. 13 is a diagram illustrating an example of a data configuration of a transaction performance database in normal times. [Diagram 5] FIG. 2 is a diagram illustrating an example of a data configuration of a disaster situation database. [Figure 6]FIG. 2 is a diagram illustrating an example of a data configuration of a past disaster situation database. [Figure 7A] FIG. 13 is a diagram illustrating an example of a data configuration of a procurement record database in the event of a disaster. [Figure 7B] FIG. 13 is a diagram illustrating an example of a data configuration of a procurement record database in the event of a disaster. [Figure 8] FIG. 13 is a diagram illustrating an example of a data configuration of a situation determination guideline database. [Figure 9] FIG. 13 is a diagram illustrating an example of a data configuration of an agreement management database. [Figure 10A] 13 is a flowchart of an example of a recommendation proposal presentation process. [Figure 10B] 13 is a flowchart of an example of a recommendation proposal presentation process. [Figure 11] 13 is an example of a readjustment screen. [Figure 12A] FIG. 13 is a diagram showing an example of a readjustment screen. [Figure 12B] FIG. 13 is a diagram showing an example of a readjustment screen. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0010] Hereinafter, an embodiment of the present invention will be described with reference to the drawings.
[0011] In this embodiment, an example is shown in which a materials procurement coordination support system is used to support the procurement coordination of materials carried out by the government in the event of a disaster. Specifically, when a local government such as a prefecture or the national government uses the materials procurement coordination support system to simultaneously place orders for procurement of materials with materials businesses, the actual order amount to the materials business is visualized. In conjunction with this visualization, an example is shown in which the materials procurement coordination support system presents the materials business with a recommendation such as a proposal to cancel the order or a proposal to place an order with another alternative materials business. This prevents orders from multiple ordering sources from concentrating on a specific materials business, causing an over-order to the materials business, which leads to a stagnation in the supply of materials.
[0012] The supplies procurement coordination support system of this embodiment is a supplies procurement coordination support system that mainly supports the coordination of procurement of supplies in a situation where orders for supplies are concentrated, such as during a disaster. The details of this embodiment will be described with reference to Figures 1 to 12. However, the present invention is not limited to this embodiment, and the present invention is applicable to any situation for supporting the coordination of procurement of supplies.
[0013] Before describing the details of the embodiment, an overview of the embodiment will be described with reference to Fig. 1. In this embodiment, a local government such as the national government or a prefecture issues an order to a material business for procuring materials. Fig. 1 is a diagram showing a conceptual example showing the flow of material procurement coordination. Fig. 1 shows a conceptual diagram 100 as a conceptual example.
[0014] The conceptual diagram 100 is composed of item / delivery date 101, which is a column showing the item and delivery date of the material, a legend 102 showing how to read the diagram, and other components. Here, the delivery date is exemplified as the desired arrival date. The legend 102 is composed of an arrow showing the request / order flow, another arrow showing the flow of materials, a dashed line showing the flow estimated by materials procurement coordination support system 200, and a double line showing a recommendation from materials procurement coordination support system 200.
[0015] Other components of the conceptual diagram 100 are an order source 111, a supplier (retail) 112, a supplier (manufacturer) 113, and a supply destination 114. Here, it is shown that the order source 111 orders materials from the supplier (retail) 112 and the supplier (manufacturer) 113, the supplier (retail) 112 orders materials from the supplier (manufacturer) 113, and the supplier (retail) 112 and the supplier (manufacturer) 113 supply materials to the supply destination 114. In Fig. 1, each column of the order source 111, the supplier (retail) 112, the supplier (manufacturer) 113, and the supply destination 114 indicates that the horizontal arrangement corresponds to each column. The supplier (retail) 112 and the supplier (manufacturer) 113 correspond to material business operators.
[0016] Next, the flow of ordering and supplying goods in this embodiment will be specifically described. The ordering source 111 is prefecture X 121, which is a local government that responds to the disaster in the disaster area, and ministry K1 122 and ministry K2 123, which are government ministries responsible for goods that provide goods support to the disaster area. The supply source (retailer) 112 is company a1 124, company a2 125, company a3 126, etc. The supply source (manufacturer) 113 is company b1 127, company b2 128, company b3 129, etc. The supply destination 114 is prefecture X goods base 130, etc., which is used as a goods warehouse for the local government in the disaster area. In this embodiment, a case where a disaster occurs in prefecture X will be described as an example.
[0017] Here, first, prefecture X 121, which is a local government in the disaster area, places an order 131 with company b1 127, a supplier with which it has an agreement, and company b1 127 supplies 132 supplies to prefecture X supply base 130 in the disaster area. The agreement here is, for example, an agreement concluded between orderer 111 and supplier (manufacturer) 113, which specifies mutual responses in the event of an emergency such as a disaster.
[0018] On the other hand, when the disaster-stricken prefecture X 121 requests material support from the government, the prefecture X first makes a request 133 to the prefecture N 120, which oversees the government. This request 133 includes a request for material support. Next, the prefecture N 120 makes a request 134 to the province K1 122 for procurement of materials.
[0019] Having received this request, Ministry K1 122 places an order 135 for supplies with Company b2 128, and also places an order 136 for supplies with Company b3 129. In response, Company b2 128 supplies 137 supplies to the X Prefecture supply base 130 in the disaster area, and Company b3 129 also supplies 138 supplies to the X Prefecture supply base 130.
[0020] Similarly, N prefecture 120 also makes a request 139 for procurement of supplies to K2 province 123. K2 province 123 places an order 140 for supplies to a1 company 124, an order 141 for supplies to a2 company 125, and an order 142 for supplies to a3 company 126. In response to this, a1 company 124, a2 company 125, and a3 company 126 each supply supplies to X prefecture supply base 130 in the disaster area. Here, a3 company 126 has the manufacturing capacity for supplies, and can directly supply 143 to X prefecture supply base 130. On the other hand, since a1 company 124 and a2 company 125 do not have the manufacturing capacity of supplies and have little inventory, a1 company 124 places an order 150 to b3 company 129, and a2 company 125 similarly places an order 150 to b3 company 129, and b3 company 129 responds to the procurement of supplies by supplying 138 supplies to the X prefecture supply base 130 in the disaster area. The supply 138 includes the supplies ordered in order 136, order 150, and order 151.
[0021] At this time, the order 150 from a1 company 124 to b3 company 129 and the order 151 from a2 company 125 to b3 company 129 cannot be grasped by K2 Ministry 123, which is the original order source, and is not registered in the supplies procurement coordination support system 200, so they are estimated and supplemented by the supplies procurement coordination support system 200. There are two estimation methods: an estimation method 160 that estimates that the actual supplier will be b3 company 129 based on the transaction record of the supplier (retail) 112 and the supplier (manufacturer) 113 in peacetime, and an estimation method 161 that estimates that the actual supplier will be b3 company 129 based on the procurement record of the supplier (retail) 112 and the supplier (manufacturer) 113 in the past during disasters. The estimation methods 160 and 161 include cases where they are estimated individually and cases where the results of each estimation are integrated to produce a single estimation result. In addition, as alternatives corresponding to the estimation results, a recommended proposal 152 for recommending the cancellation of ordering and a recommended proposal 153 for recommending ordering to another alternative supplier are shown. In this example, when it is estimated in advance that orders will be concentrated at a specific supplier and an over-order will occur, as alternatives to this, a proposal 162 for recommending the cancellation of ordering to the supplier where the over-order will occur and a proposal 163 for recommending ordering to another alternative supplier are shown as examples.
[0022] 2 is a diagram showing an example of the system configuration of a supplies procurement coordination support system 200. The configuration of the supplies procurement coordination support system 200 will be described with reference to FIG.
[0023] The supplies procurement coordination support system 200 has a control unit 230 that executes calculation processing, a main memory unit 210, an auxiliary memory unit 220, a communication unit 231, and an input / output unit 232. These are interconnected by a bus.
[0024] The auxiliary storage unit 220 stores a procurement coordination management database 221, a peacetime transaction record database 222, a disaster situation database 223, a past disaster situation database 224, a procurement record database in the event of a disaster 225, a situation judgment guideline database 226, and an agreement management database 227. In Fig. 2, these databases are abbreviated as "DB".
[0025] The main memory unit 210 stores the programs that operate the materials procurement coordination support system 200 according to this embodiment. The procurement coordination support unit 211, order quantity estimation unit 212, and readjustment recommendation unit 213 can be configured as programs. Hereinafter, when the subject is described as "a unit...", it means that the control unit 230 can read each program from the auxiliary memory unit 220, load it into the main memory unit 210, and realize the function of each program. The function of each program will be described in detail later.
[0026] The supply procurement coordination support system 200 is a system that supports the government in placing an order to a supply business operator for the procurement of supplies, for example, so that the government can provide supply support to local governments in disaster-stricken areas. The government-prefecture cooperation system 250 is a system that supports evacuation shelter management and supply procurement for municipalities that respond to disasters in disaster-stricken areas. Specifically, for example, the system handles requests for support from a disaster-stricken prefecture to the government. The system supports requests from local governments to the government for supply support, and the government determines the amount of supplies to be supplied to the local government in response to the request. The government-prefecture cooperation system 250 handles the range described above from the order source 111 in the conceptual diagram 100 of FIG. 1. The government-prefecture cooperation system 250 is a system that does not involve private supply businesses, as handled by the supply procurement coordination support system 200. Here, the government-prefecture cooperation system 250 is a system configured using a general computer, and can communicate with the supply procurement coordination support system 200 via a communication line 240.
[0027] As the communication line 240, various networks can be adopted, such as a LAN (Local Area Network), a dedicated line, a WAN (Wide Area Network), a power line network, a wireless network, a public line network, a mobile phone network, a satellite communication line, etc. When a public communication line such as a public line network is adopted, a virtual private network (VPN) technology may be used to conceal the contents of communication and make it a pseudo dedicated line.
[0028] 2, supplies procurement coordination support system 200 is configured to perform input and output independently, but it may be configured to be connected to another terminal via communication line 240 and to input and output information using the input / output unit of that terminal. Also, supplies procurement coordination support system 200 may be a subsystem of government-prefecture collaboration system 250, or may be a subsystem of a system that includes both supplies procurement coordination support system 200 and government-prefecture collaboration system 250.
[0029] The programs executed by the control unit 230 are provided to the supplies procurement coordination support system 200 via removable media (CD-ROM, flash memory, etc.) or a network, and are stored in the auxiliary storage unit 220, which is a non-transitory storage medium. For this reason, the supplies procurement coordination support system 200 should preferably have an interface for reading data from removable media.
[0030] The supplies procurement coordination support system 200 is a computer system configured on one physical computer, or on multiple logically or physically configured computers, and may run on a virtual computer constructed on multiple physical computer resources. For example, multiple programs that realize the functions of the supplies procurement coordination support system 200 may each run on a separate physical or logical computer, or multiple programs may be combined to run on a single physical or logical computer.
[0031] Here, the database used in the materials procurement coordination support system 200 will be described in detail.
[0032] 3A and 3B are diagrams showing an example of the data configuration of the procurement coordination management database 221. The configuration of the procurement coordination management database 221 will be described with reference to Figs. 3A and 3B.
[0033] Procurement coordination management database 221 stores prefecture-to-nation request management table 300 shown in FIG. 3A and current procurement status table 310 shown in FIG. 3B.
[0034] 3A, data indicating the contents of requests for material support from local governments to the national government is stored. Here, data indicating the contents of the requests for material support that were sent from the national government-prefectural collaboration system 250 to the material procurement coordination support system 200 via the communication line 240 can be stored. This information may be input from the input / output unit 232 of the material procurement coordination support system 200.
[0035] Prefecture-to-nation request management table 300 shows an example composed of disaster ID 301, request ID 302, request date and time 303, request origin 304, request destination 305, item 306, quantity 307, delivery date 308, and delivery destination (supply destination) 309. In prefecture-to-nation request management table 300, each row of the table may constitute a record. The keys for identifying each record are disaster ID 301 and request ID 302. In prefecture-to-nation request management table 300, information surrounded by a thick frame indicates the key for identifying each record. Similarly, in the following explanation of the database, information surrounded by a thick frame indicates the key for identifying each record.
[0036] Disaster ID 301 is an identifier for uniquely identifying a disaster, and is assigned by the national government-prefecture cooperation system. Note that the numbering may be assigned by the supplies procurement coordination support system 200 that detects the disaster information. Request ID 302 is an identifier for uniquely identifying a request for supply support from a local government to the national government, and is assigned by the national government-prefecture cooperation system. Note that the request ID 302 may be assigned by the supplies procurement coordination support system 200 that detects the request for supply support.
[0037] Request date and time 303 indicates the date and time when the request for request ID 302 was made by a local government. Request origin 304 indicates the local government that made the request for request ID 302. Request recipient 305 indicates the request recipient of request ID 302, which in this example is N prefecture. Item 306 indicates which supplies the request for request ID 302 relates to. Quantity 307 indicates the quantity of the request for request ID 302. Delivery date 308 indicates the delivery date of the request for request ID 302. Delivery destination (supply destination) 309 indicates the delivery destination of the request for request ID 302, which is synonymous with the supply destination here.
[0038] Next, the current procurement status table 310 shown in Fig. 3B stores data showing the current status of procurement of materials by local governments and national governments to material businesses. The current procurement status table 310 includes data on the available supply amount of materials as responded to by the material business operators in response to inquiries from the local government or national government about the available supply amount of materials. The current procurement status table 310 also includes data on the work details registered by the local government or national government and material business operators when the local government or national government orders materials in response to the responses from the material business operators.
[0039] The current procurement status table 310 is shown as an example consisting of disaster ID 311, request ID 312, order origin 313, order destination 314, supplier 315, item 316, order date and time 317, delivery date 318, delivery destination (supply destination) 319, available supply amount 320, order amount 321, supply origin city / town / village ID 322, and delivery date 323. The keys for identifying each record are disaster ID 311, request ID 312, order origin 313, order destination 314, supplier 315, item 316, order date and time 317, delivery date 318, and delivery destination (supply destination) 319.
[0040] Disaster ID 311 is an identifier for uniquely identifying a disaster, similar to disaster ID 301. Request ID 312 is an identifier for uniquely identifying a request for material support from a local government to the national government, similar to request ID 302. Order source 313 indicates an order source that places an order for material procurement in relation to the request of request ID 312, and corresponds to a local government or the national government in this case. Order destination 314 indicates an order destination in the record to which the order destination belongs, and corresponds to a material business in this case. Supplier 315 indicates a supplier of materials arranged by supplier 314 in an order in the record to which the order source belongs, and corresponds to a warehouse or factory that is the base of supplier 314. Supplier 315 also corresponds to a warehouse or factory that is the base of a material business that is an external supplier of materials from supplier 314. Item 316 indicates which material is related to the order in the record to which the item belongs. In many cases, item 316 matches the item in request ID 312, but they may not match if a different item is substituted due to a shortage of materials, etc. Order date and time 317 indicates the date and time when the order for the record to which the order date and time belongs was placed by order source 313. Delivery date 318 indicates the delivery date of the order. Delivery destination (supply destination) 319 indicates the delivery destination of the order for the record to which the delivery date belongs, and is synonymous with the supply destination here.
[0041] Available supply quantity 320 indicates the quantity that the supplier 314 can supply to the orderer 313 before placing an order, in relation to the order in the record to which the available supply quantity belongs. Order quantity 321 indicates the quantity in the order in the record to which the order quantity belongs. Supply source city / town / village ID 322 is an identifier for uniquely identifying the city / town / village where the supplier 315 is located. Delivery date 323 indicates the due date of delivery in the order in the record to which the delivery date belongs.
[0042] 4 is a diagram showing an example of the data structure of the normal time transaction performance database 222. The structure of the normal time transaction performance database 222 will be described with reference to FIG.
[0043] In the peacetime transaction record database 222, a peacetime transaction record table 400 as shown in FIG. 4 is stored. This is data showing the amount of material traded between material businesses during peacetime when no disaster occurs. Here, the material business transaction management system 251 can be configured to store data transmitted to the material procurement coordination support system 200 via the communication line 240. The material business transaction management system 251 is a system that constantly accumulates information on what kind of transactions are being conducted at private businesses, such as orders and receipts, and information on the inventory status at private businesses. The material business transaction management system 251 accumulates information on the transaction record at private businesses. This information may be input from the input / output unit 232 of the material procurement coordination support system 200. Also, data transmitted from each system of the material business to the material procurement coordination support system 200 via the communication line 240 may be stored. Also, instead of such data, the amount of material traded between material businesses may be expressed as a ratio between material businesses, and the data may be stored.
[0044] The normal transaction performance table 400 is composed of an order origin 401, an order recipient 402, a supplier 403, an item 404, an order date and time 405, a delivery date 406, a delivery destination (supply destination) 407, an order amount 408, and a delivery date 409. The keys for identifying each record are the order origin 401, the order recipient 402, the supplier 403, the item 404, the order date and time 405, the delivery date 406, and the delivery destination (supply destination) 407.
[0045] Order source 401, like order source 313, indicates the source of an order for procuring materials. Order destination 402, like order destination 314, indicates the destination of an order in the record to which the order destination belongs. Supplier 403, like supply source 315, indicates the source of the materials arranged by order source 401 in the order in the record to which the supplier belongs. Item 404, like item 316, indicates which material the order in the record to which the item belongs to. Order date and time 405, like order date and time 317, indicates the date and time when the order was placed by order source 401 in the record to which the order date and time belongs. Delivery date 406, like delivery date 318, indicates the delivery date in the order in the record to which the delivery date belongs. Delivery destination (supply destination) 407, like delivery destination (supply destination) 319, indicates the delivery destination in the order in the record to which the delivery destination (supply destination) belongs. Order quantity 408 indicates the quantity in the order in the record to which the order quantity belongs, similar to order quantity 321. Delivery date 409 indicates the due date of delivery in the order in the record to which the delivery date belongs, similar to delivery date 323.
[0046] 5 is a diagram showing an example of the data structure of the disaster situation database 223. The disaster situation database 223 will be described with reference to FIG.
[0047] In the disaster status database 223 illustrated in FIG. 5, a current disaster status table 500 (FIG. 5) is stored. Data indicating the status of a disaster currently occurring is stored in the current disaster status table 500. In this example, data transmitted from the disaster information sharing system 252 to the supplies procurement coordination support system 200 via the communication line 240 is stored. The disaster information sharing system 252 is a system for sharing disaster information within the country in the event of a disaster, and is a system that accumulates and provides information such as information on locations where landslides have occurred, information on locations where evacuation shelters have been established, and information on roads that are closed to traffic. This information may be input from the input / output unit 232 of the supplies procurement coordination support system 200. Data transmitted from each system monitoring the disaster status to the supplies procurement coordination support system 200 via the communication line 240 may also be stored.
[0048] 5 is composed of a disaster ID 501, a disaster type 502, a city / town / village ID 503, a city / town / village name 504, a date 505, and a disaster scale 506. The keys for identifying each record are the disaster ID 501, the disaster type 502, and the city / town / village ID 503.
[0049] The disaster ID 501 is an identifier for uniquely identifying a disaster, similar to the disaster ID 301. The disaster type 502 indicates the type of disaster of the disaster ID 501, such as an earthquake or a wind or flood disaster. The city / town / village ID 503 is an identifier for uniquely identifying a city / town / village.
[0050] The city / town / village name 504 is the name of the city / town / village indicated by the city / town / village ID 503. The date 505 indicates the date when the disaster of the disaster ID 501 occurred. The disaster scale 506 indicates the scale of the disaster of the disaster ID 501.
[0051] 6 is a diagram showing an example of the data configuration of the past disaster situation database 224. The past disaster situation database 224 will be described with reference to FIG.
[0052] 6, a past disaster situation database 224 stores a past disaster situation table 600. The past disaster situation table 600 stores data indicating the situations of disasters that have occurred in the past. Here, the data in the past disaster situation table 600 is stored by copying data from the disaster situation database 223 after a disaster has been dealt with. This information may be configured to be input from the input / output unit 232 of the supplies procurement coordination support system 200.
[0053] The past disaster situation table 600 is composed of a disaster ID 601, a disaster type 602, a city / town / village ID 603, a city / town / village name 604, a date 605, and a disaster scale 606. The disaster ID 601, the disaster type 602, and the city / town / village ID 603 are keys for identifying each record.
[0054] Disaster ID 601, like disaster ID 301, is an identifier for uniquely identifying a disaster. Disaster type 602, like disaster type 502, indicates the type of disaster that disaster ID 601 corresponds to. City / town / village name 604 where the disaster of disaster ID 601 occurred, like city / town / village name 504, is the name of the city / town / village indicated by city / town / village ID 603. Date 605, like date 505, indicates the date when the disaster of disaster ID 601 occurred. Disaster scale 606, like disaster scale 506, indicates the scale of the disaster of disaster ID 601.
[0055] 7A and 7B are diagrams showing an example of the data configuration of the disaster procurement record database 225. The disaster procurement record database 225 will be described with reference to FIG.
[0056] The disaster procurement record database 225 stores a prefecture-to-nation request management table 700 shown in FIG. 7A, and a past procurement record table 710 shown in FIG. 7B.
[0057] 7A shows an example of prefecture-to-nation request management table 700, which stores data showing the contents of past requests for material support from local governments to the national government. Here, it is assumed that the data in prefecture-to-nation request management table 300 in procurement coordination management database 221 is copied and stored after a disaster response. This information may be input from input / output unit 232 of material procurement coordination support system 200.
[0058] Prefecture-to-nation request management table 700, like prefecture-to-nation request management table 300, is composed of a disaster ID 701, a request ID 702, a request date and time 703, a request source 704, a request destination 705, an item 706, a quantity 707, a delivery date 708, and a delivery destination (supply destination) 709. The keys for identifying each record are the disaster ID 701 and the request ID 702.
[0059] The disaster ID 701 is an identifier for uniquely identifying a disaster, similar to the disaster ID 301. The request ID 702 is an identifier for uniquely identifying a request for material support from a local government to the national government, similar to the request ID 302.
[0060] The request date and time 703 indicates the date and time when the request for request ID 702 was made by the local government, similar to the request date and time 303. The request originator 704 indicates the local government that made the request for request ID 702, similar to the request originator 304. The request destination 705 indicates the destination of the request for request ID 302, similar to the request destination 305. The item 706 indicates which supplies the request for request ID 702 relates to, similar to the item 306. The quantity 707 indicates the quantity of the request for request ID 702, similar to the quantity 307. The delivery date 708 indicates the delivery date of the request for request ID 702, similar to the delivery date 308. The delivery destination (supply destination) 709 indicates the delivery destination of the request for request ID 702, similar to the delivery destination (supply destination) 309.
[0061] Next, in the past procurement record table 710 illustrated in Fig. 7B, data indicating the procurement record of supplies that local governments and national governments have made to supply businesses in the past is stored, similar to the current procurement status table 310. The past procurement record table 710 is composed of disaster ID 711, request ID 712, order origin 713, order destination 714, supplier 715, item 716, order date and time 717, delivery date 718, delivery destination (supply destination) 719, available supply amount 720, order amount 721, supplier city / town / village ID 722, and delivery date 723. The keys for identifying each record are disaster ID 711, request ID 712, order origin 713, order destination 714, supplier 715, item 716, order date and time 717, delivery date 718, and delivery destination (supply destination) 719.
[0062] Disaster ID 711 is an identifier for uniquely identifying a disaster, similar to disaster ID 301. Request ID 712 is an identifier for uniquely identifying a request for material support from a local government to the national government, similar to request ID 302. Order source 713, similar to order source 313, indicates an order source that places an order for procurement of materials in relation to the request of request ID 712. Order destination 714, similar to order destination 314, indicates the order destination of the order in the record to which the order destination belongs. Supplier 715, similar to supply source 315, indicates the supplier of materials arranged by the order destination 714 in the order in the record to which the supplier belongs. Item 716, similar to item 316, indicates which materials the order in the record to which the item belongs relates to. Order date and time 717, similar to order date and time 317, indicates the date and time when the order in the record to which the order date and time belongs was placed by order source 713. Delivery date 718 indicates the delivery date of the order in the record to which the delivery date belongs, similar to delivery date 318. Delivery destination (supply destination) 719 indicates the delivery destination of the order in the record to which the delivery destination (supply destination) belongs, similar to delivery destination (supply destination) 319.
[0063] Similar to available supply amount 320, available supply amount 720 indicates the quantity that the supplier 714 can supply to the orderer 713 before placing an order, in relation to the order in the record to which the available supply amount belongs. Similar to order amount 321, order amount 721 indicates the quantity in the order in the record to which the order amount belongs. Similar to supplier city / town / village ID 322, supplier city / town / village ID 722 is an identifier for uniquely identifying the city / town / village in which the supplier 715 is located. Similar to delivery date 323, delivery date 723 indicates the due date of delivery in the order in the record to which the delivery date belongs.
[0064] 8 is a diagram showing an example of the data structure of the situation determination guideline database 226. The situation determination guideline database 226 will be described with reference to FIG.
[0065] In the situation judgment guideline database 226, a judgment index table 800 is stored. This is data showing to what extent the supplyable amount of materials reported by the supplier is actually reduced due to the deterioration of the surrounding environment as illustrated in FIG. 8, such as road damage and power outages caused by disasters. In other words, the judgment index table 800 is information on the reduction in the supply of materials due to disasters. The causes of the reduction in the supply of materials include not only road damage and power outages caused by the disasters described above, but also various cases such as a shortage of personnel and transportation means involved in the supply of materials. Here, it is assumed that a user of the materials procurement coordination support system 200 inputs the relevant information from the input / output unit 232 of the materials procurement coordination support system 200. Note that this information may be configured to be stored by the government-prefecture cooperation system 250, the materials business transaction management system 251, the disaster information sharing system 252, etc., which transmit data to the materials procurement coordination support system 200 via the communication line 240.
[0066] The judgment index table 800 is composed of a disaster type 801, a disaster scale 802, and an index 803. The disaster type 801 and the disaster scale 802 are keys for identifying each record.
[0067] Disaster type 801 indicates the type of disaster, similar to disaster type 502. Disaster scale 802 indicates the scale of the disaster, similar to disaster scale 506. When disaster type 801 and disaster scale 802 are respectively set, index 803 indicates the degree, expressed as a percentage, of the actual decrease in the supplyable amount of goods reported by the supplier due to deterioration of the surrounding environment, such as road damage or power outages, caused by the disaster.
[0068] 9 is a diagram showing an example of the data structure of the agreement management database 227. The agreement management database 227 will be described with reference to FIG.
[0069] In the agreement management database 227, an agreement table 900 as shown in FIG. 9 is stored. This is an agreement on the content of support in the event of a disaster, which is determined in advance between local governments and supply businesses, or between the government and supply businesses, in peacetime before a disaster occurs, so that local governments and the government in the affected area can smoothly provide support such as supply support and lifesaving to the affected area when a disaster occurs. Here, it is assumed that a user of the supply procurement coordination support system 200 inputs information from the input / output unit 232 of the supply procurement coordination support system 200. Note that this information may be stored as data transmitted to the supply procurement coordination support system 200 via the communication line 240 by the government-prefecture cooperation system 250, the supply business transaction management system 251, the disaster information sharing system 252, etc.
[0070] The agreement table 900 is composed of an agreement ID 901, an agreement type 902, a support recipient 903, a supporter 904, a planned support date 905, a support target 906, and a support amount upper limit 907. The keys for identifying each record are the agreement ID 901, the agreement type 902, the support recipient 903, the supporter 904, and the planned support date 905.
[0071] The agreement ID 901 is an identifier for uniquely identifying the support content, such as an agreement that preliminarily determines the support content at the time of a disaster, and one support content includes a wide range of items such as material support, rescue of human lives, and support at evacuation shelters. The type of agreement 902 indicates the type of the support content, such as material support, rescue of human lives, and support at evacuation shelters, as a subitem of the support content. The recipient 903 indicates the person who receives support, and in the case of material support, it corresponds to a local government or the government. The supporter 904 indicates the person who provides support, and in the case of material support, it corresponds to a material business operator. The support target 906 indicates the specific content regarding the agreement type 902, and in the case of the agreement type 902, it indicates the type of the material item, such as food or daily necessities. The support amount upper limit 907 indicates the upper limit amount that corresponds to the effort obligation of the supporter with respect to the support target 906 in the agreement type 902, and corresponds to cases where no upper limit is set, or where the upper limit is set to 50% of the supporter's 904 inventory on the day. For example, in the support amount limit 907, "no questions asked" indicates that the supporter can support all of the stock he / she owns. In the support amount limit 907, "50% of the stock at that time" indicates that the supporter can support up to 50% of the stock he / she owns.
[0072] 10A and 10B are flowcharts of a recommended proposal presentation process example. In this flowchart, when a local government such as a prefecture or the national government simultaneously procures supplies from a material business, the material procurement coordination support system 200 visualizes the actual order amount to the material business and presents a recommended proposal for handling the order of materials, such as canceling the order to the material business or placing an order with an alternative material business. The processing flow shown in FIG. 10A and FIG. 10B will be explained below. In the following explanation, unless otherwise specified, the user refers to the user of the material procurement coordination support system 200. In this embodiment, the users of the material procurement coordination support system 200 are typically the Nth government office, the person in charge of the local government such as a prefecture and the ministry that is the order source 111, the person in charge of the supplier (retailer) 112 and the supplier (manufacturer), and the person in charge of the supply destination 114. These users can access the material procurement coordination support system 200 using the input / output unit 232 provided in their own department.
[0073] In step S1000, the control unit 230 of the supplies procurement coordination support system 200 starts the process flow, and then the process proceeds to step S1001.
[0074] In process S1001, in response to a request from the supplies procurement coordination support system 200 to the government-prefecture cooperation system 250, the government-prefecture cooperation system 250 transmits a request for supplies support from the local government, which is accepted by the procurement coordination support unit 211 of the supplies procurement coordination support system 200. The procurement coordination support unit 211 registers the contents of the request in the prefecture-to-nation request management table 300 in the procurement coordination management database 221.
[0075] Next, the process in step S1002 will be described. A user in N prefecture inputs trigger information for procurement coordination, including the start of procurement coordination and allocation of items of relief supplies to the government agencies responsible for supplies, from the input / output unit 232. Based on the input of the trigger information, procurement coordination of supplies can be started in the procurement coordination support unit 211. Note that this trigger information may be, for example, a procurement coordination start command input by a user in N prefecture from the input / output unit 232, or may be information that gives other triggers.
[0076] The procurement coordination support unit 211 copies and stores the values of the relevant sections of prefecture-to-nation request management table 300 into disaster ID 311, request ID 312, item 316, delivery date 318, and delivery destination (supply destination) 319 in current procurement status table 310 of procurement coordination management database 221. Here, the ministry or agency having jurisdiction over materials included in the trigger information entered by N prefecture is stored as order source 313. If there are multiple order sources 313, for example because different ministries or agencies have jurisdiction over materials for different item types, records are created and stored according to the number of order sources 313.
[0077] A user of a ministry or agency refers to the order origin 313 by the input / output unit 232, and provisionally registers the order destination 314 and the order amount 321 from the input / output unit 232 for a record in which a value indicating the ministry or agency is stored in the order origin 313. The procurement coordination support unit 211 stores the provisionally registered values in a database. A user of the supplier of materials registers the supplyable amount 320 indicating the amount that can be supplied using the company or an external supplier from the input / output unit 232 for a record in which a value indicating the supplier of materials is stored in the order origin 314. If it is determined which of the company's warehouse or factory or the external supplier will be used for supply, the user registers the location, and if it is not yet determined which source will be used for supply, the user provisionally registers a provisional value such as the company's head office in the supplier 315. The procurement coordination support unit 211 stores the registered values and the provisionally registered values in a database.
[0078] The ministry or agency user checks available supply amount 320 using input / output unit 232 and confirms supplier 314 and order amount 321, and accordingly, procurement coordination support unit 211 stores the confirmed values in supplier 314 and order amount 321, and stores the date and time of confirmation in order date and time 317. In addition, as soon as the supplier user confirms the values of supplier 315 and delivery date 323, he or she updates and registers the values using input / output unit 232, and procurement coordination support unit 211 stores the data in supplier 315 and delivery date 323.
[0079] At this time, the procurement status of the local government is notified together with the request for material support from the local government, and is continuously transmitted thereafter from the national and prefectural cooperation system 250 for information sharing. The procurement coordination support unit 211 stores the transmitted information in the current procurement status table 310 each time.
[0080] In process S1003, the order quantity estimation unit 212 of the supplies procurement coordination support system 200 obtains normal-time transaction records from the normal-time transaction record database 222 and determines the transaction relationship in normal times. Here, if there are multiple suppliers 403 for a certain orderer 401, the order quantities 408 for each supplier 403 are totaled, and the total of the order quantities 408 from the orderer 401 is also calculated. Next, the ratio of each total value to the calculated total value is calculated for each supplier 403. The calculation result is temporarily stored in the auxiliary storage unit 220 as the normal-time transaction ratio of the supplier 403 to that orderer 401. The process described above is repeated for each orderer 401 that may have multiple suppliers 403.
[0081] In step S1004, if the normal trading ratio is temporarily stored in the auxiliary storage unit 220 in step S1003, the order quantity estimation unit 212 determines that there is normal trading and proceeds to step S1005. If there is no normal trading ratio, the order quantity estimation unit 212 determines that there is no normal trading and proceeds to step S1006.
[0082] In process S1005, the order quantity estimation unit 212 calculates the order quantity corresponding to the supplier material business operator (its warehouse or factory) apportioned based on the normal transaction ratio temporarily stored in the auxiliary storage unit 220 in process S1003. That is, for the supplier 314 in the current procurement status table 310 in the procurement adjustment management database 221, the order quantity 321 to the supplier 314 is apportioned for each supplier material business operator (its warehouse or factory) using the normal transaction ratio temporarily stored in the auxiliary storage unit 220. In this way, the order quantity to the supplier material business operator (its warehouse or factory) as a result of the apportionment is calculated. Here, the calculation process is performed assuming that the supplier 314 externally procures materials.
[0083] The order quantity calculated by this apportionment corresponds to a substantial increase in the order quantity to the material business operator (its warehouse or factory) that receives the order. Therefore, the amount calculated by this apportionment is temporarily stored in the auxiliary storage unit 220 as a substantial increase based on the transaction ratio in normal times with respect to the order quantity 321 to the supplier 315 that matches the material business operator (its warehouse or factory). Since the order quantity calculated by the apportionment described above is not directly grasped at the level of the order source 111, this substantial increase in the order quantity is estimated as a substantial increase, and is expected as an increase. In this way, a substantial increase in the order quantity based on the transaction ratio in normal times can be estimated.
[0084] As mentioned above, the process here can calculate, or estimate, the amount of orders that a certain material business operator, i.e., a certain trading business operator, will outsource to another material business operator, out of the order volume that the certain material business operator has accepted, based on the trading performance of the certain material business operator in peacetime. Here, the "certain material business operator" can be called the "first material business operator," and the "different material business operator" can be called the "second material business operator."
[0085] In process S1006, the order quantity estimation unit 212 performs a similarity judgment using data on past disasters to determine whether a disaster similar to the current disaster has occurred in the past. First, the current disaster situation is obtained from the disaster situation database 223, and the past disaster situation is obtained from the past disaster situation database 224, and the two are compared. In the similarity judgment, the judgment is made based on the similarity of the disaster type, the similarity of the disaster scale, the similarity of the location based on the city / town / village ID, the similarity of the time based on the date, etc. In the similarity judgment, it may be judged that there is a similarity when there is a perfect match, or it may be judged that there is a similarity when there is a partial match. Various known methods can be used to judge the similarity. For example, a method can be used in which the distance between the two is calculated based on a distance using Euclidean distance, and the distance is compared with a preset threshold value to determine the similarity. The method of judging the similarity is the same in the judgment of similarity that follows.
[0086] For example, if the cities, towns, and villages are different but are in the same prefecture, it may be determined that there is a partial match and there is a similarity, and if the cities, towns, and villages or prefectures are different but are in the same region (Kyushu region, Chugoku region, etc.), it may be determined that there is a partial match and there is a similarity. In addition, regarding the similarity of the time period based on the year, month, and day, it may be determined that there is a similarity if it is the same season or the same month, or it may be determined that there is a similarity if it is the 5th or 10th of the month even if the months are not the same, or it may be determined that there is a similarity if it is the same day of the week, or it may be determined that there is a similarity if it is a weekday or a holiday by distinguishing between weekdays and holidays. In addition, regarding the scale of the disaster, for example, in the case of earthquakes, it may be determined that there is a similarity if the seismic intensity is the same, or it may be determined that there is a similarity if the seismic intensity is 5 or more, or in the case of wind and flood damage, it may be determined that there is a similarity if the precipitation is 100 mm / hour or more, or it may be determined that there is a similarity with a range like this. It should be noted that, with regard to the date and time, not only the date but also the time and the time period such as morning, evening, night, or late night may be stored, and the similarity of the time period may be added to the judgment criteria.
[0087] In process S1007, if the order quantity estimation unit 212 determines in process S1006 that a similar disaster has occurred in the past, it determines that there is a similarity, acquires the disaster ID 601, and proceeds to process S1008. If no similar disaster has been found in the past, it determines that there is no similarity, and proceeds to process S1009.
[0088] In process S1008, the order quantity estimation unit 212 acquires the disaster ID 601 acquired as the similar disaster in process S1007, as well as the disaster ID 701 and the request ID 702. The disaster ID 701 and the request ID 702 acquired here are the disaster ID 701 and the request ID 702 of the narrowed-down record obtained by narrowing down the records in which the disaster ID 701 and the item 706 match from the prefecture-to-nation request management table 700 in the disaster procurement record database 225 for the item for which the order quantity is to be estimated in this process (process S1008). For this disaster ID 701 and request ID 702, the past procurement record table 710 is narrowed down to records in which the disaster ID 711 and the request ID 712 match, and the matching record is acquired as the procurement record for a similar disaster.
[0089] Here, in the case where a certain supplier 714 has multiple suppliers 715, the order quantities 721 are summed up for each supplier 715, and the total of the order quantities 721 to the supplier 714 is also calculated. Next, the ratio of each total value to the calculated total value is calculated for each supplier 715. The ratio is calculated for each supplier as the ratio of each external procurement source to the order quantity received by the supplier 714. This calculation result is temporarily stored in the auxiliary storage unit 220 as the transaction ratio of the supplier 715 to the supplier 714 in the event of a disaster. The above-mentioned process is repeated for a supplier 714 that may have multiple suppliers 715. Note that normal times can be called the first state, and times of disaster can be called the second state. The second state is different from the first state.
[0090] Here, the order amount estimation unit 212 calculates the order amount corresponding to the supplier material business (its warehouse or factory) which is apportioned based on the transaction ratio at the time of the disaster temporarily stored in the auxiliary storage unit 220. That is, for the supplier 314 in the current procurement status table 310 in the procurement adjustment management database 221, the order amount 321 to the supplier 314 is apportioned for each supplier material business (its warehouse or factory) using the transaction ratio at the time of the disaster temporarily stored in the auxiliary storage unit 220. In this way, the order amount to the supplier material business (its warehouse or factory) is calculated as the result of the apportionment. Here, the calculation process is performed on the assumption that the supplier 314 will externally procure materials. The process here calculates, that is, estimates, the amount of the order amount accepted by a certain material business that will be externally procured by a material business other than the supplier, based on the past transaction performance of the trading business such as the material business at the time of the disaster. Here, the "certain material business operator" can be referred to as the "first material business operator," and the "material business operator different from that business operator" can be referred to as the "second material business operator." Here, the "certain material business operator" and the "material business operator different from that business operator" may be the same as or different from the "certain material business operator" and the "material business operator different from that business operator" when making an estimate based on the trading performance of a trading business operator such as a material business operator in peacetime as described above.
[0091] The order quantity calculated by apportionment in this way corresponds to a substantial increase in the order quantity to the material business operator (its warehouse or factory) that is the external supplier receiving the order. Therefore, the amount calculated by apportionment in this way is temporarily stored in the auxiliary storage unit 220 as a substantial increase based on the transaction ratio at the time of the disaster with respect to the order quantity 321 to the supplier 315 that corresponds to the material business operator (its warehouse or factory). Since the order quantity calculated by apportionment as described above is not directly grasped at the level of the order source 111, this substantial increase in the order quantity is estimated as an increase. This allows the substantial increase in the order quantity based on the transaction ratio at the time of the disaster to be estimated.
[0092] As mentioned above, based on past procurement records of the same or similar items during disasters, it is possible to estimate the amount of orders accepted by a certain materials supplier that will be procured externally from a different materials supplier during a disaster.
[0093] In process S1009, the disaster type 502 and disaster scale 506 for each city / town / village ID 503 are obtained from the current disaster situation table 500 in the disaster situation database 223. In addition, a record in which the supplier city / town / village ID 322 in the current procurement status table 310 in the procurement coordination management database 221 matches the city / town / village ID 503 is obtained from the current procurement status table 310, and the disaster type 502 and disaster scale 506 obtained in process S1009 described above are associated with that record. This association is temporarily stored in the auxiliary memory unit 220.
[0094] Next, if the disaster type 801 and disaster scale 802 in the judgment indicator table 800 of the situation judgment guideline database 226 match the disaster type 502 and disaster scale 506, an indicator 803 is obtained, and in process S1009, the supply source city / town / village ID 322 is associated with the record whose city / town / village ID matches the city / town / village ID 503, and this association is temporarily stored in the auxiliary memory unit 220.
[0095] In process S1010, if the order quantity estimation unit 212 finds that the record temporarily stored in the auxiliary storage unit 220 is associated with the index 803, it determines that the surrounding environment of the supplier has deteriorated, and proceeds to process S1011. If there is no association, it determines that the surrounding environment of the supplier has not deteriorated, and proceeds to process S1012. If there is no association, it temporarily stores the available supply amount 320 in the auxiliary storage unit 220 as the actual available supply amount, and proceeds to process S1012. Therefore, in this case, the actual available supply amount is equal to the available supply amount 320.
[0096] In process S1011, the order quantity estimation unit 212 multiplies the supply quantity 320 of the record based on the record and the index 803, and calculates the result as the actual supply quantity, assuming that the supply quantity 320 of the record is substantially decreased due to the deterioration of the surrounding environment such as road damage and power outage caused by the disaster. This actual supply quantity is the supply quantity in which the supply of materials is restricted due to the disaster. The index 803 is information indicating the degree to which the supply of materials is reduced due to the disaster. This calculated result is temporarily stored in the auxiliary storage unit 220 in association with the record. Note that in process S1011, the order quantity estimation unit 212 may use the supply quantity 720 instead of the above-mentioned supply quantity 320 to calculate the actual supply quantity. Alternatively, the supply quantity in peacetime may be acquired and stored in the peacetime transaction record database 222 of the auxiliary storage unit 220, and the supply quantity in peacetime may be used instead of the above-mentioned supply quantity 320.
[0097] As described above, a process is performed to estimate the available supply amount of supplies when the supply of supplies is restricted due to a disaster, based on information regarding a reduction in the supply of supplies due to a disaster.
[0098] In process S1012, the actual order quantity is estimated. That is, the order quantity estimation unit 212 adds the actual increase in the order quantity based on the transaction ratio during normal times, which was temporarily stored in the auxiliary storage unit 220 in process S1005, and the actual increase in the order quantity based on the transaction ratio during a disaster, which was temporarily stored in the auxiliary storage unit 220 in process S1008, to the order quantity 321 of the supplier 315 in the current procurement status table 310 of the procurement adjustment management database 221. This addition process estimates the actual order quantity to the supplier 315. The value estimated here is temporarily stored in the auxiliary storage unit 220 as the actual order quantity to the supplier 315, in association with the corresponding record in the current procurement status table 310.
[0099] Here, both the actual increase based on the trading ratio during peacetime and the actual increase based on the trading ratio during a disaster are added to the order quantity 321 to estimate the actual order quantity, but only the actual increase based on the trading ratio during peacetime may be added to estimate. Alternatively, only the actual increase based on the trading ratio during a disaster may be added to estimate. Alternatively, the actual increase based on the trading ratio during peacetime and the actual increase based on the trading ratio during a disaster may be weighted based on a ratio defined in advance by the user and integrated, and the integrated increase may be added to estimate.
[0100] In process S1013, the order quantity estimation unit 212 compares the actual order quantity estimated in process S1012 and the actual supplyable quantity estimated in process S1011 among the data temporarily stored in the auxiliary storage unit 220. As a result, if the actual order quantity exceeds the actual supplyable quantity, it is determined that an over-order has occurred in the supply source 315 of the record temporarily stored in the auxiliary storage unit 220 in process S1012, and the process proceeds to process S1014. If it does not exceed the actual order quantity, it is determined that an over-order has not occurred, and the process proceeds to process S1015. The actual order quantity is the data temporarily stored in the auxiliary storage unit 220 described above. That is, if the index 803 is not associated with the record temporarily stored in the auxiliary storage unit 220, the actual order quantity is the supplyable quantity 320 that is temporarily stored in the auxiliary storage unit 220 as the actual supplyable quantity. Furthermore, when the indicator 803 is associated with the record temporarily stored in the auxiliary storage unit 220, the actual order quantity is the value estimated in process S1012, associated with the corresponding record in the current procurement status table 310, and temporarily stored in the auxiliary storage unit 220. In process S1013, the comparison made by the order quantity estimation unit 212 can also use the available supply quantity 320 or the available supply quantity 720 instead of the actual available supply quantity estimated in the above-mentioned process S1011. Alternatively, the available supply quantity in normal times can be obtained and stored in the normal time transaction performance database 222 or the like of the auxiliary storage unit 220, and the available supply quantity in normal times can be used instead of the above-mentioned actual available supply quantity.
[0101] In the process S1014, various recommended proposals can be presented to the user of the order source. That is, the readjustment recommendation unit 213 can present a proposal to recommend the suspension of orders for the supply source 315 itself or for orders for other material businesses that use the supply source 315 as an external supplier (wherein the supplier 314 is a material business different from the supply source 315) for which the supply source 315 is determined to be over-ordered in the process S1013. Furthermore, as a replacement for the suspended portion, a proposal to recommend another material business that is not over-ordered as an alternative supplier can be presented to the user of the order source from the input / output unit 232 together with the actual order amount to each supply source (see FIG. 11, FIG. 12A, and FIG. 12B). Here, the recommended replacement order may be one that replaces a part of the order amount that was suspended. Also, the recommended replacement order may be made up of a plurality of orders. Also, in the above explanation, the suspension of orders in the recommended proposal may include a case where a part of a certain order is suspended, that is, the order amount is reduced. In addition, in the above explanation, the proposal to recommend another material business operator who is not over-ordering as an alternative supplier to replace the canceled portion may be a proposal to recommend another material business operator who is not over-ordering as an alternative supplier to replace a portion of the canceled portion. Note that the recommendation of canceling the order and recommending an alternative supplier for the canceled portion may only recommend canceling the order.
[0102] In addition, with regard to an order in which the supplier 314 is a material business operator different from the supplier 315, rather than canceling the order itself, it may be recommended to reduce the order quantity by only the order quantity 321 related to the supplier 315 in question, so as to encourage the supplier 314 to cancel only external procurement from the supplier 315 in question.
[0103] At this time, the agreement table 900 in the agreement management database 227 is referenced, and for records where the agreement type 902 is material support, if the orderer and the recipient 903 of the material support match, and there is no discrepancy between the material item and the support target 906, then another supporter 904 is recommended to the orderer as an alternative supplier. Here, whether or not there is a discrepancy between the material item and the support target 906 may be determined by having the user define a classification table for material items separately, and having the materials procurement coordination support system 200 compare the classification table with the items of the support target 906.
[0104] Here, supporters 904 related to other support recipients 903 in the agreements table 900 may be recommended to the orderer. In this case, all supporters 904 stored in the agreements table 900 may be recommended to the orderer, or the relationships between the support recipients 903 may be defined separately, and supporters 904 related to the support recipients 903 who have a high relationship with the orderer may be recommended to the orderer.
[0105] Next, the user can proceed to step S1002 to make readjustments based on the recommended proposal.
[0106] In process S1015, the readjustment recommendation unit 213 calculates the total amount of the actual order quantities temporarily stored in the auxiliary storage unit 220 in process S1012 as the actual total order quantity. Next, in the prefecture-to-nation request management table 300 in the procurement adjustment management database 221, the total amount of quantities 307 for the disaster ID 301 and request ID 302 being handled in process S1002 is calculated as the total request quantity. Next, the actual total order quantity and the total request quantity are compared.
[0107] If the actual total order quantity is insufficient for the total requested quantity, the process can proceed to step S1002 to make additional procurement adjustments. On the other hand, if the difference between the actual total order quantity and the total requested quantity is greater than or equal to a separately determined threshold, it is determined that a surplus has occurred, and the process can proceed to step S1016. On the other hand, if the actual total order quantity is not insufficient for the total requested quantity, and the difference between the actual total order quantity and the total requested quantity is within a separately determined threshold, it is determined that the total requested quantity and the actual total order quantity are balanced, and the process can proceed to step S1017.
[0108] In process S1016, the readjustment recommendation unit 213 recommends a proposal to the user of the ordering source to stop placing an order or reallocate the order to another supply destination for the surplus amount obtained by subtracting the total request amount from the actual total order amount when compared in process S1015, together with the actual total order amount and the total request amount, via the input / output unit 232. Next, the user can proceed to process S1002 to perform readjustment based on the recommended proposal.
[0109] As described above, the materials procurement coordination support system 200 compares material orders and material business supply, and provides information for coordinating material orders and material business supply.
[0110] In process S1017, the control unit 230 ends the process flow.
[0111] Next, a readjustment screen that supports adjustment of ordering of materials and the like will be described. FIG. 11 is an example of the readjustment screen. In this example screen, in process S1014 of FIG. 10B, the actual order amount to the material business is visualized for the user of the ministry or agency that is the orderer via the input / output unit 232. Furthermore, the recommendation proposals such as reducing the order amount to the material business, canceling the order to the material business, and ordering to an alternative material business are output from the input / output unit 232 and visualized and displayed. Also, FIGS. 12A and 12B are enlarged views of a part of FIG. 11. FIGS. 12A and 12B are diagrams showing an example of the readjustment screen. Here, the orders that are the subject of these recommendations may be orders that have already been placed, and may also be orders that will be placed in the future.
[0112] The readjustment screen shown in Fig. 11 is composed of a conceptual diagram 1100, a detailed table 1160, and a recommended plan 1170. Examples of the configurations of the detailed table 1160 and the recommended plan 1170 are shown in Fig. 12A and Fig. 12B, respectively. The information presented in the conceptual diagram 1100, the detailed table 1160, and the recommended plan 1170 may be displayed at any time in the flowcharts shown in Fig. 10A and Fig. 10B, and may be displayed, for example, in process S1014 or process S1016.
[0113] 11 is composed of item / delivery date 1101 indicating the item and delivery date of the material, a legend 1102 for explaining how to read the diagram, and other components. The legend 1102 is composed of an arrow indicating the flow of requests / orders, another arrow indicating the flow of materials, a dashed line indicating the flow estimated by materials procurement coordination support system 200, and a double line indicating a recommendation from materials procurement coordination support system 200.
[0114] Other components of the conceptual diagram 1100 are an order source 1111, a supplier (retail) 1112, a supplier (manufacturer) 1113, and a supply destination 1114. Here, the order source 1111 indicates ordering materials from the supplier (retail) 1112 or the supplier (manufacturer) 1113. The supplier (retail) 1112 indicates ordering materials from the supplier (manufacturer) 1113, and supplying the materials from the supplier (retail) 1112 or the supplier (manufacturer) 1113 to the supply destination 1114. In FIG. 11, the columns of the order source 1111, the supplier (retail) 1112, the supplier (manufacturer) 1113, and the supply destination 1114 indicate that their horizontal arrangement corresponds to each column.
[0115] Next, the flow of ordering and supply of these supplies will be specifically shown. The ordering source 1111 is prefecture X 1121, which is a local government responsible for disaster response in the affected area, and ministry K1 1122 and ministry K2 1123, which are government ministries responsible for supplies that provide support to the affected area. The suppliers (retailers) 1112 are company a1 1124, company a2 1125, and company a3 1126. The suppliers (manufacturers) 1113 are company b1 1127, company b2 1128, and company b3 1129. The supply destination 1114 is prefecture X supply base 1130, which is used as a supply warehouse for the local government in the affected area.
[0116] Here, prefecture X 1121, which is a local government in the disaster area, first places an order 1131 with company b1 1127, a supplier with which the prefecture has an agreement, and company b1 1127 supplies 1132 supplies to prefecture X's supply base 1130 in the disaster area.
[0117] On the other hand, when a disaster-stricken area, X Prefecture 1121, requests material support from the government, it first submits a request 1133 to N Prefecture 1120, which oversees the government, and then N Prefecture 1120 makes a request 1134 to K1 Ministry 1122 for the procurement of materials.
[0118] Having received the request, Ministry K1 1122 places an order 1135 for supplies to b2 company 1128, and places an order 1136 for supplies to b3 company 1129. In response, b2 company 1128 supplies 1137 supplies to the X prefecture supply base 1130 in the disaster area, and b3 company 1129 also supplies 1138 supplies to the X prefecture supply base 1130.
[0119] Similarly, N prefecture 1120 also makes a request 1139 for procurement of supplies to K2 province 1123. K2 province 1123 places an order 1140 for supplies to a1 company 1124, an order 1141 for supplies to a2 company 1125, and an order 1142 for supplies to a3 company 1126. In response to this, a1 company 1124, a2 company 1125, and a3 company 1126 supply supplies to X prefecture supply base 1130 in the disaster area. Here, a3 company 1126 has the capacity to manufacture supplies, and directly supplies 1143 to the X prefecture supply base 1130. On the other hand, since a1 company 1124 and a2 company 1125 do not have the manufacturing capacity for supplies and have little inventory, a1 company 1124 places an order 1150 to b3 company 1129, and a2 company 1125 similarly places an order 1151 to b3 company 1129, and b3 company 1129 responds by supplying supplies 1138 to the X prefecture supply base 1130 in the disaster area. The supply 1138 of supplies includes the supply corresponding to the order 1150 and the order 1151, and the supply corresponding to the order 1136 mentioned above.
[0120] At this time, the order 1150 from company A1 1124 to company B3 1129 and the order 1151 from company A2 1125 to company B3 1129 are information that is not registered in the supplies procurement coordination support system 200, so they are estimated and supplemented by the supplies procurement coordination support system 200. The results of this supplementation are order 1150 and order 1151.
[0121] Here, because such an order increases the actual order amount to b3 company 1129, the supplies procurement coordination support system 200 estimates and supplements the actual order amount and the resulting actual surplus or shortage in supply, and shows this to the user in a detailed table 1160. An example of the detailed table 1160 shown in FIG. 12A will be described later. In addition, for such an order, the supplies procurement coordination support system 200 presents to the user, as alternatives, a recommended proposal 1152 recommending cancellation of the order and a recommended proposal 1153 recommending placing an order with an alternative supplier. The specific content of this recommended proposal is shown to the user in a recommended proposal 1170. An example of the recommended proposal 1170 shown in FIG. 12B will be described later. The user can readjust the procurement adjustment based on the recommended proposal.
[0122] On the other hand, the actual order amount and the like are shown in detail in a detailed table 1160, and the recommended plan is specifically shown in a recommended plan 1170. Examples of these are shown in Figs. 12A and 12B.
[0123] 12A visualizes information such as the actual order amount and the available supply amount. The detailed table 1160 is composed of a material business operator 1161, an available supply amount 1162, an order amount to the business operator 1163, an actual order amount to the business operator 1164, an actual supply amount from the business operator 1165, an actual corresponding business operator and an actual supply amount 1166, and an excess or shortage amount 1167 of the actual supply amount relative to the actual order amount.
[0124] The material business operator 1161 indicates a material business operator who has received an order from a local government or the government, and is responsible for supplying materials to disaster-stricken areas. The available supply amount 1162 is a response from the material business operator 1161 in response to an inquiry from the local government or the government, and indicates the amount of materials that can be supplied using the company or external suppliers. The order amount 1163 to the relevant business operator indicates the amount of materials ordered from the material business operator 1161, which is determined by the local government or the government based on the available supply amount 1162.
[0125] The actual order amount 1164 to the business in question indicates the actual order amount placed by the local government or government to the material business 1161, or the order amount placed by the local government or government to another material business 1161, which then places orders with the material business 1161 as an external supplier. This latter amount (the order amount that the other material business 1161 places with the material business 1161 in question as an external supplier) is estimated by the material procurement coordination support system 200. In the conceptual diagram 1100, this corresponds to orders 1150 and 1151. The actual order amount 1164 to the business in question shows such order amounts broken down by order source, and also shows the total.
[0126] The actual supply volume 1165 from the supplier indicates the volume that the supplier 1161 can actually supply. This is estimated by the materials procurement coordination support system 200 from the available supply volume 1162 and the actual order volume 1164 to the supplier. If it is estimated that the supplier 1161 will place an order with an external supplier, the quantity is estimated as 0 since the material will not be supplied from the supplier 1161 (this process is omitted in the explanation of the process flow in Figures 10A and 10B above because the calculation is simple).
[0127] The actual supplier and actual supply amount 1166 is displayed when the materials procurement coordination support system 200 estimates that the materials supplier 1161 will place an order with an external supplier, and shows the name of the materials supplier from which the materials will be ordered and the amount of materials to be supplied from there.
[0128] The actual supply quantity surplus / shortage 1167 with respect to the actual order quantity indicates how much of a surplus / shortage occurs with respect to the quantity to be supplied by the material supplier 1161. This can indicate the difference obtained by subtracting the actual order quantity 1164 to the supplier from the quantity obtained by adding up the actual supply quantity 1165 from the supplier and the actual corresponding supplier and actual supply quantity 1166, which is calculated by the material procurement coordination support system 200 (since the calculation of this process is simple, it is omitted in the explanation of the process flow of Figures 10A and 10B described above). This can also indicate the difference obtained by subtracting the actual order quantity 1164 to the supplier from the actual supply quantity 1165 from the supplier. Note that, although an example in which the supplyable quantity 1162 is presented in the detailed table 1160 has been shown, the actual supplyable quantity estimated in process S1011 can also be presented in place of the supplyable quantity 1162 to make a detailed table created by presenting the actual supplyable quantity estimated in process S1011.
[0129] 12B is composed of individual recommendations. In the example screen of FIG. 12B, the recommendation 1170 is composed of a recommendation 1171 for K2 Province and a recommendation 1172 for X Prefecture.
[0130] Each of the recommendation proposal 1171 to Province K2 and the recommendation proposal 1172 to Prefecture X is composed of a target 1173 indicating the person to whom the recommendation proposal is presented, a scope 1174 indicating which material business the recommendation is for, and a content 1175 indicating the specific recommendation content. In this example, it is recommended that Province K2 stop placing a partial order with Company a2 (for 3,000 masks) and that Company a3 place a partial additional order (for 3,000 masks). It is also recommended that Prefecture X place a new order with Company b2 (for 3,000 masks). Figure 12B shows examples of these recommendations.
[0131] In the above description, the process flow of FIG. 10A and FIG. 10B has been described from the start of process S1000 to the end of process S1017. The person who starts this process flow may be, for example, a user of the Nth office or ministry in the government or a user of a local government such as a prefecture, as described in the embodiment. Alternatively, this process flow may return to the start of process S1000 after reaching the end of process S1017, and may operate continuously until an instruction such as stopping execution due to an interrupt or the like is received. In this process flow, the contents of each database in the auxiliary storage unit 220 may be updated from time to time from the government-prefecture cooperation system 250, the supply business transaction management system 251, the disaster information sharing system 252, and the input / output unit 232. In addition, in this process flow, the contents of each database in the auxiliary storage unit 220 may be updated from time to time by a request from the supply procurement coordination support system 200 to the government-prefecture cooperation system 250, the supply business transaction management system 251, and the disaster information sharing system 252. In the above explanation, the first state is normal and the second state is disaster, but the second state is not limited to disaster, and the present system can be used in abnormal states such as a state where a failure occurs, and has an advantageous effect. In other words, a state that is not the second state can be called the first state, i.e., normal.
[0132] It should be noted that the present invention is not limited to the above-described embodiments, and includes various modifications and equivalent configurations within the spirit of the appended claims. For example, the above-described embodiments have been described in detail to clearly explain the present invention, and the present invention is not necessarily limited to those having all of the configurations described. Also, a part of the configuration of one embodiment may be replaced with the configuration of another embodiment. Also, the configuration of one embodiment may be added to the configuration of another embodiment.
[0133] In the above-described embodiment, the materials procurement coordination support system 200 has been described using examples in which the ordering of materials is carried out by government agencies and local government agencies, but the ordering of materials is not limited to these, and may also be carried out by agencies that perform similar functions to government agencies and local government agencies.
[0134] In addition, some of the configurations of each embodiment may be added to, deleted from, or replaced with other configurations. In addition, the above-mentioned configurations, functions, processing units, processing means, etc. may be realized in part or in whole by hardware, for example, by designing them as integrated circuits, or may be realized by software, by a processor interpreting and executing a program that realizes each function.
[0135] Information such as programs, tables, and files that realize each function can be stored in a storage device such as a memory, a hard disk, or an SSD (Solid State Drive), or in a recording medium such as an IC card, an SD card, or a DVD. In addition, the control lines and information lines shown are those considered necessary for explanation, and do not necessarily show all the control lines and information lines necessary for implementation. In reality, it can be considered that almost all configurations are interconnected. [Explanation of symbols]
[0136] 200 Material Procurement Coordination Support System 210 Main memory 211 Procurement Coordination Support Department 212 Order quantity estimation unit 213 Readjustment recommendation section 220 Auxiliary storage section 221 Procurement Coordination Management Database 222 Peacetime trading performance database 223 Disaster Status Database 224 Past Disaster Situation Database 225 Database of procurement records during disasters 226 Situation Judgment Guideline Database 227 Agreement Management Database 230 Control Unit 231 Communications Department 232 Input / output section 240 communication lines 250 Government-Prefecture Collaboration System 251 Material Business Transaction Management System 252 Disaster Information Sharing System
Claims
1. A supplies procurement coordination support system that supports coordination of procurement of supplies, A control unit that executes arithmetic processing, a storage unit accessible by the control unit, and an input / output unit, The service provides support to the material purchaser when ordering materials from a material supplier and the material supplier supplies the materials in response to the order, The control unit: Based on the transaction record of the material business operator in a first state, which is a normal time, an amount of the order accepted by the first material business operator that will be externally procured by a second material business operator is estimated; Based on a past procurement record in a second state different from the first state, an amount of the order accepted by the first material business operator that will be externally procured by the second material business operator is estimated; estimating an order amount to be placed with the first material business operator based on the amount procured externally in the first state and the amount procured externally in the second state; A materials procurement coordination support system characterized by outputting the estimated order quantity to the first materials business operator.
2. 2. The material procurement coordination support system according to claim 1, The control unit: based on the supplyable amount of the first material business operator in the second state acquired from the first material business operator and information indicating a decrease in the supply of the material in the second state, estimating an actual supplyable amount of the first material business operator in the second state in which the supply of the material is restricted; A materials procurement coordination support system that outputs the estimated actual supplyable amount.
3. 3. The material procurement coordination support system according to claim 2, A materials procurement coordination support system characterized in that the control unit calculates the difference between the estimated actual supply available amount and the estimated order amount to the first materials business operator, and outputs the calculated difference.
4. 3. The material procurement coordination support system according to claim 2, A materials procurement coordination support system characterized in that the control unit outputs information recommending the cancellation of the order to the materials business operator if the estimated order quantity is greater than the estimated actual supplyable quantity.
5. 5. The material procurement coordination support system according to claim 4, A materials procurement coordination support system characterized in that the control unit outputs a recommendation for ordering from an alternative materials supplier when an order to the materials supplier is canceled.
6. 2. The material procurement coordination support system according to claim 1, The control unit acquires a supplyable amount of the first material supplier in the second state from the first material supplier, estimating an order amount of the material when the purchaser places an order with the material business operator based on the amount procured from outside in the first state and the amount procured from outside in the second state; A materials procurement coordination support system that outputs the estimated order amount of the materials and the acquired supply amount of the materials business operator.
7. 7. The material procurement coordination support system according to claim 6, A materials procurement coordination support system characterized in that the control unit calculates the difference between the acquired supply amount of the materials business operator and the estimated order amount of the materials, and outputs the calculated difference.
8. 7. The material procurement coordination support system according to claim 6, A material procurement coordination support system characterized in that the control unit outputs information recommending the cancellation of the order to the material supplier when the estimated order quantity of the material is greater than the amount that the material supplier can supply as obtained.
9. 9. The material procurement coordination support system according to claim 8, A materials procurement coordination support system characterized in that the control unit outputs a recommendation for ordering from an alternative materials supplier when an order to the materials supplier is canceled.
10. 2. The material procurement coordination support system according to claim 1, A supplies procurement coordination support system, characterized in that the purchasers include national agencies and local governments.
11. A materials procurement coordination support method in which a materials procurement coordination support system supports coordination of materials procurement, comprising: The material procurement coordination support system comprises: A control unit that executes arithmetic processing, a storage unit that can be accessed by the control unit, and an input / output unit, The service provides support to the material purchaser when ordering materials from a material supplier and the material supplier supplies the materials in response to the order, The material procurement coordination support method includes: The control unit estimates an amount of an order volume accepted by the first material business operator to be externally procured by a second material business operator based on a transaction record of the material business operator in a first state, which is a normal time; The control unit estimates an amount of the order quantity accepted by the first material business operator to be externally procured by the second material business operator based on the same or similar past procurement record in a second state different from the first state, The control unit estimates an order amount to be placed with the first material business operator based on an external procurement amount in the first state and an external procurement amount in the second state; A materials procurement coordination support method, characterized in that the control unit outputs the estimated order quantity to the first material business operator.
Citation Information
Patent Citations
Ordering support device and ordering system
JP2011008431A
Storage and supply management device, storage and supply management method and storage and supply management program
JP2014191793A
Commodity transaction mediation system and method
JP2003233737A
Method and system for supporting article distribution
JP2006188331A
