JP4833681B2 - Parts allocation logistics management system - Google Patents

Description

  The present invention relates to a parts allocation logistics management system that can divide a piece of order information and allocate and manage parts in stock or in transit.

  In the case of a logistics system consisting of a primary supplier that produces and supplies parts and a secondary supplier that purchases parts from this primary supplier and supplies them to the distributor, the parts received from the distributor The supply from the stock of the next supplier and the portion of the stock not enough are ordered from the secondary supplier to the primary supplier. Many systems for managing the distribution of parts between the primary supplier and the secondary supplier have been developed (see, for example, Patent Document 1).

JP 2005-335870 A

  However, if the order from the seller and the part being transported from the primary supplier to the secondary supplier are not associated and managed, a new order is placed to the primary supplier even though the part is being transported. As a result, there was a problem that the inventory of secondary suppliers would increase.

  The present invention has been made in view of such problems, and divides the ordering information from the seller, and not only the inventory of the secondary supplier but also the parts being transported from the primary supplier to the secondary supplier. An object is to provide a parts allocation logistics management system that can also be allocated.

In order to solve the above-described problems, a parts allocation logistics management system according to the present invention is a part ordered by a distributor (for example, a sales agent 30 in the embodiment) from a secondary supplier who supplies parts to the dealer. Order input means (for example, the terminal device 4 in the embodiment) for inputting purchase information comprising the number of purchases (for example, the primary order information 41 in the embodiment), and order storage means for storing the purchase information (for example, in the embodiment) Order management database 52), inventory storage means (for example, inventory management database 51 in the embodiment) for storing the inventory amount of the parts held by the secondary supplier, and identification information for managing the transportation for each shipment of the parts (For example, the transport ID in the embodiment) and the part to which the identification information is given arrives at the secondary supplier from the primary supplier that manufactured the part. Production management means (for example, production control server 2 in the embodiment) for storing a lead time required until that the reads the purchase information from the order storage means, provision processing means Hikiateru parts (e.g., the embodiment In the first step (for example, step S100 in the embodiment) in which the allocation processing unit searches the inventory storage unit and allocates the stock to the purchase information. A second step (for example, step S102 in the embodiment) that searches for production management means and allocates from a part with a short lead time among the parts being transported to purchase information when there is an unallocated portion. , Split and allocate purchase information. Note that “assignment” means that parts in stock or in transit are assigned to purchase information.
In addition, it has an allocation storage unit (for example, the allocation management database 53 in the embodiment) for managing the parts allocated to the purchase information by the allocation processing unit, and the allocation processing unit has a division ID (for example, for each divided purchase information) , MID in the embodiment) is assigned, and the division ID and the identification information of the part to which the division ID is assigned are stored in the allocation storage means.

  In addition, the parts allocation logistics management system according to the present invention includes order processing means (for example, the order processing section 33 in the embodiment) for requesting the primary supplier to manufacture parts, and the allocation processing means includes the second step. It is preferable to have a third step (for example, step S104 in the embodiment) of requesting the manufacture of the part by the order processing means and dividing the purchase information when there is an unallocated portion.

  When the parts allocation logistics management system according to the present invention is configured as described above, in the allocation process of parts ordered from a distributor, not only is it allocated from the inventory held by the secondary supplier, but also manufactured by the primary supplier. By placing the parts that are being transported to this secondary supplier and placing the missing parts still in the primary supplier, there is no need to make an extra manufacturing request the primary supplier. Can be reduced.

Further, even if the allocation is divided as described above for one order from the seller, each allocation is managed by the division ID (MID), so that this order can be managed accurately. At this time, even if the allocated parts are being transported, since the division ID and the identification information (transport ID) are managed in association with the division ID in the allocation storage means (allocation management database 53), the secondary supply The person can accurately grasp the relationship between the transportation state of the parts and the order.

Hereinafter, preferred embodiments of the present invention will be described with reference to the drawings. First, the configuration of the parts allocation logistics management system according to the present invention will be described with reference to FIGS. In the parts allocation logistics management system 1, an overseas sales agent 30 orders parts from a local corporation (secondary supplier 20) in the country and exports from Japan (primary supplier) as necessary. 10). Here, the flow of parts from the primary supplier 10 to the sales agent 30 will be described with reference to FIG. The parts produced in the factory of the primary supplier 10 are transported to the port or airport of the export destination by ship or aircraft, and are delivered from there to the secondary supplier 20 using a railroad or a vehicle (truck etc.). Then, it is delivered from the secondary supplier 20 to the sales agent 30 by a vehicle or the like. Therefore, in the parts allocation logistics management system according to the present invention, the transportation state of the parts being transported is managed, and when the parts are ordered from the sales agent 30 to the secondary supplier 20, In addition to the inventory of the next supplier 20, it is configured to receive parts in transit.

  The parts allocation logistics management system 1 receives the terminal device 4 where the sales agent 30 places an order for parts and the primary order information 41 transmitted from the terminal device 4, and manages the inventory and transportation managed by the secondary supplier 20. The allocation management server 3 that performs the allocation process from the parts in the middle, orders the shortage to the primary supplier 10, and receives the secondary order information 42 transmitted from the allocation management server 3, It is comprised from the production management server 2 which performs management which supplies (transports) to the next supplier 20. Note that the secondary order information 42 transmitted from the allocation management server 3 to the production management server 2 is not only transmitted in response to the order from the sales agent 30, but is also made at the judgment of the secondary supplier 20. Also sent when ordering parts.

  The production management server 2 has a transportation management database 50 for producing parts to be performed based on the secondary order information 42 from the allocation management server 3 and managing until the parts are delivered to the secondary supplier 20. is doing. As shown in FIG. 3, the transport management database 50 includes a transport ID column 50a in which identification information (transport ID) for managing transport is stored every time a part is shipped, and the type (part number) of the part to be transported is The stored part number column 50b, the shipped quantity column 50c for storing the shipping quantity (for example, the number of lots), the status column 50d for storing the current transportation status of the part, and the manufacturing for storing the manufacturing date of the part. The date column 50e, the shipping date column 50f in which the date sent from the primary supplier 10 is stored, and the date when the vessel is transported to the country where the secondary supplier 20 exists by ship or aircraft and arrives at the port or airport is stored. Arrival date column 50g, date of delivery from the port or airport to the secondary supplier 20 by vehicle or train, etc., and the arrival date column 50h in which the arrival date is stored, secondary A lead time column 50i in which the lead time until arrival at the supplier 20 is stored, and an unallocated amount in which an amount not allocated to the order of the secondary supplier 20 among the shipped parts being transported is stored It consists of a quantity column 50j.

  The transportation management database 50 is configured such that the transportation state is managed by the production management server 2 and information is stored. Therefore, the production date is stored in the production date column 50e by the production management server 2 when the part is produced at the factory of the primary supplier 10. Here, the production management server 2 sends the parts to the status column 50d before the parts are shipped from the factory of the primary supplier 10 (simultaneously when the production is completed and the manufacturing date is stored in the manufacturing date column 50e). Stores “waiting for shipment”, and when a part is shipped from the primary supplier 10, the shipping date is stored in the shipping date column 50f, and the information “ship (or aircraft) is moving” is stored in the status column 50d. Is memorized. Further, when entering the port or airport of the exporting country, the production management server 2 stores the date in the port arrival date column 50g, and stores the information “in transit by land” in the status column 50d. And when it arrives at the secondary supplier 20, the production management server 2 memorize | stores the date in the acceptance date column 50h, and memorize | stores the information "acceptance" in the status column 50d. Furthermore, when the parts are managed as stocks in the inventory management database 51 in the secondary supplier 20 (this process is not shown in FIG. 1 and the like), the production management server 2 reads the corresponding transportation from the transportation management database 50. The record of ID is deleted (you may comprise so that the information "stock confirmed" may be memorize | stored in the status column 50d, without deleting). The production management server 2 stores the state in the state column 50d according to the change in the transportation state of the parts as described above. At that time, the production management server 2 reaches the secondary supplier 20 in the lead time column 50i. The required number of days required (lead time) is stored at the same time.

  The allocation management server 3 includes an inventory management database 51 that manages the inventory quantity of the secondary supplier 20 for each part, an order management database 52 that manages primary order information 41 transmitted from the sales agent 30, and primary order information. 41 has an allocation management database 53 for managing the allocation of parts. As shown in FIG. 4, the inventory management database 51 includes a part number column 51a in which a part number is stored and an inventory quantity column 51b in which the inventory quantity is stored. It is managed in correspondence. For example, in FIG. 4, a record 51c indicates that 25 parts with the part number “1311-02” are managed as inventory. In FIG. 1, the component management function is not shown.

  As shown in FIG. 5, the order management database 52 includes an order number column 52a in which information (order number) for identifying an order from the sales agent 30 is stored, and a part number column 52b in which the ordered part number is stored. The order date column 52c stores the order date, and the order quantity column 52d stores the order quantity. Thus, in the order management database 52, the order from the sales agent 30 is managed so that it can be uniquely determined by the order number and the part number. In addition, as shown in FIG. 6, the allocation management database 53 includes an order number column 53a in which the above-described order numbers are stored, a part number column 53b in which part numbers are managed, an MID column 53c in which MIDs described later are managed, A transport ID column 53d for managing the transport ID of a part being transported from the primary supplier 10 to the secondary supplier 20, an allocation state column 53e indicating a state where the managed part has been allocated, and a provision amount of the part And a delivery date response date column 53g in which the date when the secondary supplier 20 returns the delivery date for the order to the sales agent 30 is stored.

  The inventory management database 51, the order management database 52, and the allocation management database 53 are configured such that information is stored by the allocation management server 3.

  The allocation management server 3 receives the primary order information 41 transmitted from the sales agent 30 and stores it in the order management database 52, and the part management based on the order information stored in the order management database 52. An allocation processing unit 32 that performs allocation and an ordering processing unit 33 that orders the part from the primary supplier 10 when the part cannot be allocated are configured. As information stored in the order management database 52 by the order processing unit 31, for example, in FIG. 5, a record 52 e is an order identified by the order number “051001” from the sales agent 30 and has a part number “1311”. This shows that 35 parts for "-02" were received on September 30, 2005.

  Now, an allocation process for ordering parts from the sales agent 30 and an ordering process for the primary supplier 10 will be described with reference to FIG. When the primary order information 41 is stored in the order management database 52 by the order processing unit 31, the allocation processing unit 32 first searches the inventory management database 51, and orders from the inventory managed by the secondary supplier 20. It is searched whether it can be allocated to (step S100). In the case of this embodiment (record 52e in FIG. 5), when 35 parts with the part number “1311-02” are ordered, 25 parts are in stock as shown in the record 51c in FIG. Because of this, we will allocate this to this order. The allocated information is stored in the allocation management database 53 as shown in FIG.

  At this time, the number of orders from the sales agent 30 is 35, whereas the stock in the secondary supplier 20 is only 25, so the remaining 10 are parts being transported from the primary supplier 10 or new parts. It is necessary to request production from the primary supplier 10, and the secondary supplier 20 must divide orders from the sales agent 30 and deliver them. Therefore, in the parts allocation logistics management system 1 according to the present embodiment, in addition to the order number for identifying the order from the sales agent 30, a divided order serial number called MID is assigned to each divided allocation unit. Is configured to manage. Therefore, the 25 parts allocated from the inventory of the secondary supplier 20 in step S100 are, as shown in the record 53k in FIG. 001 "is stored in the MID column 53c. At this time, the allocation processing unit 32 stores “inventory” in the allocation status column 53e, stores “25” in the allocation amount column 53e, and combines the date when the parts can be delivered to the sales agent 30. Stored in the reply date column 53g. In addition, when allocated from stock, there is no information stored in the transport ID column 53d.

  Next, the allocation processing unit 32 checks whether or not there is an order that has not yet been allocated (step S101). If there is an allocation remaining, the allocation is then transported from the primary supplier 10 to the secondary supplier 20. The presence / absence of the part in question is checked, and if there is a part being transported, a process of assigning the part is performed (step S102). Specifically, the allocation processing unit 32 searches the transportation management database 50 managed by the production management server 2, and the parts close to the secondary supplier 20, that is, the contents of the unallocated amount column 50j are not 0 (assign). There is a part that can be used) and the short part of the lead time column 50i is used.

  In the case of FIG. 3, first, although the lead time is “0” day, the customer has arrived at the secondary supplier 20, but the inventory management processing has not yet been performed, and the inventory management of the secondary supplier 20 is performed. Parts that are not managed in the database 51 (record 50m stored as “accepted” in the status column 50d) are allocated. In order to allocate parts in transit, first, a new MID “002” is extracted and stored as a record 53m together with the order number and part number in the allocation database 53 that manages that the order has been allocated from the sales agent 30. Further, for this record 53m, the transport ID (R0001) of the record 50m is stored in the transport ID column 53d, and the “transport part” indicating that the part is being transported is stored in the allocation state column 53e. The amount “3” is stored in the allocation amount column 53f. Then, the allocation processing unit 32 subtracts the amount allocated this time from the unallocated amount of the allocated record 50m in the transport management database 50 (in the present embodiment, all three unallocated parts have been allocated. 0 ”) is stored in the unallocated amount column 50j (not shown in FIG. 3).

  If there is a remaining balance, the part with the next short lead time, that is, the lead time is “2” days, arrives at the port or airport, and is stored in the state column 50d as “overland transport”. The record 50n is allocated. Also in this case, the allocation processing unit 32 generates a new MID “003” and manages it as a record 53k together with the order number and the part number, and stores the transport ID (R0002) of the record 50n in the transport ID in the transport ID column 53d. “Transportation parts” is stored in the allocation status column 53e, “1” is stored as the allocation amount in the allocation amount column 53f, and at the same time, the unallocated amount of the record 50n in the transport management database 50 is set to 0 and the unallocated amount column 50j. To remember.

  Further, when there is an unreserved portion, the part having the next short lead time, that is, the lead time is “10” days, shipped from the primary supplier 10 and transported by ship, The record 50p with the transport ID “R003” stored as “moving” is allocated, and a new MID “004” is extracted and managed as the record 53p by the above-mentioned method. Two parts (transport ID “R004”) are extracted as a new MID “005” and managed as a record 53q.

  As described above, even if the inventory of the secondary supplier 20 and the parts transported from the primary supplier 10 to the secondary supplier 20 are allocated, there is still an allocation remaining (step S103), the allocation process The unit 32 extracts and stores a new MID “006” in the MID column 53c of the allocation management database 53 and manages it as a record 53r, stores “unallocated” in the allocation status column 53e of this record 53r, “3”, which is an unallocated amount, is stored in the allocated amount column 53f. At this time, the allocation processing unit 32 transmits the unassigned quantity to the primary supplier 10 as the secondary ordering information 42 by the ordering processing unit 33 and requests production. When the allocation processing unit 32 checks the allocation management database 53 at a predetermined time interval (for example, every 24 hours) and finds a record in which “unallocated” is stored in the contents of the allocation status column 53e, The transportation management database 50 or the inventory database 51 is searched by the above process, and when there is a part that can be allocated, the allocation process is performed (not shown in FIG. 7).

  The main effects achieved in the embodiment of the present invention described above can be summarized as follows. First, in the process of allocating parts ordered from the sales agent 30, the parts are not only allocated from the inventory held by the secondary supplier 20 but also manufactured by the primary supplier and transported to the secondary supplier. By placing a part in the middle and placing an order for a part that is still insufficient from the primary supplier 10, an extra manufacturing request is not made to the primary supplier 10, and the inventory of the secondary supplier 20 can be reduced.

Second, even if the allocation is divided as described above for one order from the sales agent 30 (for example, the order number is “051001”), each allocation is managed by MID. , This order can be managed accurately. At this time, even if the allocated part is in transit, the MID and the transport ID are managed in association with the MID in the allocation management database 53, so that the secondary supplier has a relationship between the transport state of the part and the order. Can be grasped accurately.

It is a block diagram which shows the structure of the parts allocation physical distribution management system which concerns on this invention. It is explanatory drawing which shows the flow until parts arrive at a sales agent from a primary supplier through a secondary supplier. It is a data structure figure which shows the structure of a transportation management database. It is a data structure figure which shows the structure of an inventory management database. It is a data structure figure which shows the structure of an order management database. It is a data structure figure which shows the structure of an allocation management database. It is a flowchart which shows the allocation process of a parts allocation logistics management system.

Explanation of symbols

1 Parts allocation logistics management system 4 Terminal equipment (ordering input means)
10 Primary supplier 20 Secondary supplier 30 Distributor (Distributor)
32. Allocation processing unit (allocation processing means)
41 Primary order information (purchase information)
50 transportation management database (production management means)
51 Inventory management database (stock storage means)
52 Order management database (order storage means)
53 allocation management database (allocation storage means)

Claims (2)

An order input means for inputting purchase information consisting of the number of purchases of the parts to be ordered by a secondary supplier who supplies parts to the seller;
Order storage means for storing the purchase information;
Inventory storage means for storing an inventory quantity of the parts held by the secondary supplier;
Identification information for managing the transportation for each shipment of the part, and lead time required for the part to which the identification information is attached to arrive at the secondary supplier from the primary supplier that manufactured the part Production management means for storing
Read the purchase information from the order storage means, and allocate processing means to allocate the parts ;
And provision storage means for managing the parts allocated to the purchase information by the provision processing means ,
The allocation processing means is
A first step of searching the inventory storage means to allocate the inventory to the purchase information;
When there is an unallocated portion in the first step, the second step is to search the production management means and allocate to the purchase information from the component with short lead time among the components being transported. , Rutotomoni reserve the component by dividing the purchase information,
A part allocation logistics unit is configured to assign a division ID to each of the divided purchase information and store the division ID and the identification information of the part to which the division ID is assigned in the allocation storage unit. Management system. Order processing means for requesting the primary supplier to manufacture the part;
The allocation processing means includes a third step of requesting manufacture of the part by the ordering processing means when the allocation is left in the second step, and allocating the purchase information in a divided manner. The parts allocation logistics management system according to claim 1.

Images