JP5866909B2 - Allocation management device, allocation management method, and allocation management program - Google Patents

Description

  The present invention relates to an allocation management device, an allocation management method, and an allocation management program.

  2. Description of the Related Art Conventionally, for example, in the manufacturing field and the distribution field, there is a technique for allocating inventory in order to manage the inventory of goods in various warehouses. For example, in this technology, when an order for a product is received from a customer, the customer's desired delivery date and the inventory status of the product in each warehouse are taken into consideration, and inventory managed in a certain warehouse is allocated.

  However, the above-described prior art has a problem that it is not always adequately allocated. For example, the number of stocks fluctuates from day to day, for example, the number of stocks that can be allocated increases or decreases due to changes in orders, or the stocks that are allocated due to cancellations of orders are released (released). For this reason, for example, stock appropriately allocated at the time of receiving an order is not always appropriately allocated at the time of shipping. In other words, taking into account daily fluctuations in inventory, the allocated inventory was not necessarily adequately allocated.

  The disclosed technology has been made in view of the above, and an object thereof is to provide an allocation management device, an allocation management method, and an allocation management program that can allocate appropriately.

In order to solve the above-described problems and achieve the object, the present invention provides a reserve resource including a physical inventory indicating the quantity of goods existing in a warehouse and a warehousing plan indicating the quantity of goods received in the warehouse. Extracting means for extracting one or a plurality of orders relating to a predetermined product existing in a predetermined warehouse from one or a plurality of received orders, and releasing the allocation resources allocated to the orders extracted by the extracting means The physical inventory and the goods receipt among the allocation resources of the warehouse including the allocation resources released by the release means according to the characteristics of the order for the orders extracted by the release means and the extraction means in favor of one of the planned allowance, the orders reservable reserve funds are present as a reserve already, the reservable reserve funds are not present orders as reserve pending vs. the orders provision already Provisions have been reserve funds running reserve reviewing process to review the Te, and provision unit for executing a hold provision process to reserve the provision funds to the order of provision pending, by extracting the orders to the extraction means, the extraction A process of causing the release means to release the allocation resources allocated to the order extracted by the means, and allowing the allocation means to allocate the allocation resources released by the release means to the order extracted by the extraction means. And a control means for repeatedly executing at an arbitrary timing.

Further, the present invention is, among one or more orders that have been allocated a reserve resource including a physical inventory indicating the quantity of goods existing in the warehouse and a warehousing plan indicating the quantity of the goods received in the warehouse, An extraction process for extracting one or a plurality of orders related to a predetermined product existing in a predetermined warehouse, a release process for releasing the allocated resources allocated to the orders extracted by the extraction process, and an order extracted by the extraction process In response to the characteristics of the order, the physical reserve and the warehousing plan are preferentially allocated from the allocation resources of the warehouse including the allocation resources released in the release step , Reassessment of provisions that have been allocated to the orders that have been allocated, with the orders for which there are possible reserve resources existing as reserved and the orders for which there are no reserve resources available for allocation as reserve pending Processing is executed, the provision funds to the order of the provision pending and a provision step of executing the pending provision process of allowance, repeatedly and the extraction step at an arbitrary timing, and said releasing step, and the provision step It is characterized by performing.

Further, the present invention is, among one or more orders that have been allocated a reserve resource including a physical inventory indicating the quantity of goods existing in the warehouse and a warehousing plan indicating the quantity of the goods received in the warehouse, An extraction step for extracting one or a plurality of orders related to a predetermined product existing in a predetermined warehouse, a release step for releasing the allocated resources allocated to the orders extracted by the extraction step, and an order extracted by the extraction step relative, depending on the characteristics of the orders, among the reserve funds of the warehouse including provision funds that have been released by said release step, and reserve in favor of one of the physical inventory and the warehousing plan provision Provisions reserved for the orders that have been allocated, with the orders for which there is a possible reserve resource set as reserved and the orders for which there is no reserve resource available for allocation as reserve pending Run the provision reviewing process to review the capital to execute the reserve executing a hold provision process reserves funds for provision to the orders of the provision pending repeated computer at any time.

  According to one aspect of the technology disclosed in the present application, there is an effect that it is possible to appropriately reserve.

FIG. 1 is a diagram illustrating a configuration of an allocation management apparatus according to the present embodiment. FIG. 2 is a diagram for explaining the allocation resources allocated by the allocation management apparatus. FIG. 3 is a diagram illustrating an example of an order reception table. FIG. 4 is a diagram illustrating an example of the warehousing plan table. FIG. 5 is a diagram illustrating an example of a physical inventory table. FIG. 6 is a diagram illustrating an example of the stock area determination table. FIG. 7 is a diagram illustrating an example of the upper warehouse determination table. FIG. 8 is a flowchart showing a processing procedure of order reservation processing. FIG. 9 is a flowchart showing a processing procedure of order reservation processing. FIG. 10 is a flowchart showing the processing procedure of the allocation review process. FIG. 11 is a flowchart showing the processing procedure of the reserve allocation process.

  Exemplary embodiments of an allocation management device, an allocation management method, and an allocation management program according to the present invention will be described below in detail with reference to the drawings.

  First, the configuration of the allocation management apparatus according to the present embodiment will be described. FIG. 1 is a diagram illustrating a configuration of an allocation management apparatus according to the present embodiment. The allocation management apparatus 100 performs processing for allocating inventory managed in a certain warehouse, that is, allocation resources, based on the customer's desired delivery date and the inventory status of products in each warehouse in response to an order from the customer. An information processing apparatus such as a personal computer or a server apparatus.

  Here, the reserve resources allocated by the allocation management apparatus 100 will be described. FIG. 2 is a diagram for explaining the allocation resources allocated by the allocation management apparatus. FIG. 2 shows a case where any of the reserve resources of the warehouses in each location is allocated for the order received from the customer 2a. This reserve resource includes, for example, a physical inventory indicating the quantity of goods existing in the warehouse, and a receipt plan indicating the quantity of goods received in the warehouse. The warehousing plan includes, for example, the quantity of commodities produced at the factory. As shown in FIG. 2, the reserve resources managed by the Gotemba factory 2b include a warehousing plan 2c and a physical inventory 2d. Further, the reserve resources managed by the Osaka warehouse 2e include a warehousing plan 2f and a physical inventory 2g. Further, the reserve resources managed by the Tosu warehouse 2h include a warehousing plan 2i and a physical inventory 2j. In the example shown in FIG. 2, the allocation management device 100 allocates any of the allocation resources of the warehouses in each location, and the allocation resources are delivered to the customer 2a via the work shop 2k. Note that the regional warehouse shown in FIG. 2 indicates the nearest warehouse for shipping the product to the delivery destination designated by the customer, and the upper warehouse is the next product to be shipped when delivery from the regional warehouse is not possible. A candidate warehouse is indicated, and the headquarters warehouse indicates a warehouse that is the last candidate to ship a product.

  Returning to the description of FIG. As shown in FIG. 1, the allocation management apparatus 100 includes a CPU (Central Processing Unit) 11, a ROM (Read Only Memory) 12, a RAM (Random Access Memory) 13, an input unit 14, a display unit 15, a storage unit 16, and a communication. Part 17 and the like.

  The CPU 11 comprehensively controls the operation of the allocation management apparatus 100 by cooperating with a predetermined program stored in the ROM 12 or the storage unit 16. Further, the CPU 11 realizes functions of an order allocation processing unit 111, an allocation review processing unit 112, and a pending allocation processing unit 113, which will be described later, in cooperation with a predetermined program stored in the ROM 12 or the storage unit 16.

  The ROM 12 is a non-volatile storage medium that stores various programs related to the control of the allocation management apparatus 100. The RAM 13 is a main storage device used as a work memory for the CPU 11.

  The input unit 14 is an input device such as a keyboard or a mouse, and outputs contents operated by the user to the CPU 11. For example, the input unit 14 receives input of order data from a customer or a person who has received an order from the customer (for example, a sales representative), and outputs the received order data to the CPU 11.

  The display unit 15 is a display device such as a display, and displays predetermined information (for example, UI (user interface)) according to the control of the CPU 11. For example, the display unit 15 displays various types of information stored in the storage unit 16 to be described later in response to a user operation.

  The storage unit 16 is an auxiliary storage device such as an HDD (Hard Disk Drive) or an SSD (Solid State Drive), and stores various programs executed by the CPU 11 and various setting information related to the execution of the programs. . In addition, the storage unit 16 stores information on an order reception table 161, a warehousing plan table 162, a physical inventory table 163, an inventory area determination table 164, and a higher-level warehouse determination table 165, which will be described later.

  The communication unit 17 is a network I / F that transmits / receives information to / from an external device connected to a network (not shown). For example, the communication unit 17 receives order data input to an external device by a customer or a person who has received an order from the customer, and outputs the received order data to the CPU 11.

  Next, various information stored in the allocation management apparatus 100 will be described. As shown in FIG. 1, the allocation management apparatus 100 includes, as information stored in the storage unit 16, an order reception table 161, a warehousing plan table 162, a physical inventory table 163, an inventory area determination table 164, and a higher-level warehouse determination table. 165.

  The order receipt table 161 stores order receipt data. For example, in the order reception table 161, one record is registered by the CPU 11 every time the CPU 11 accepts the order reception data. FIG. 3 is a diagram illustrating an example of an order reception table. As shown in FIG. 3, the order table 161 includes an order number, an allocation priority number, an order date, a stock area, a product, a quantity, a desired delivery date, a shipping warehouse, and a confirmed delivery for each order. The date and the situation are stored in association with each other. Among these, the order number is identification information for identifying the order data, and is numbered by the CPU 11 every time the order data is received, for example. The allocation priority number is a number assigned by the CPU 11 in accordance with the characteristics of the order. Here, the characteristic of the order indicates a characteristic specific to the corresponding order, for example, information indicating whether it is a factory kitting order, whether the order receiving channel is via the Internet, or whether the order receiving channel is a telephone. For example, in the allocation priority number, “1” is stored for factory kitting orders, “9” is stored for orders where the order channel is telephone, and default values are used for orders that do not have special order characteristics. “5” is stored. The order date indicates the date when the order data is received. The stock zone indicates the nearest warehouse for shipping the product to the delivery destination designated by the customer. The product indicates a product ordered from a customer. The quantity indicates the quantity of the product ordered from the customer. The desired delivery date indicates the delivery date of the product desired by the customer. The shipping warehouse indicates a warehouse for shipping the allocated goods. The confirmed delivery date indicates the confirmed delivery date. The status indicates the status of the corresponding order data. For example, “allocated” indicating that allocation has been made and “hold” indicating that allocation has been held are stored.

  The warehousing plan table 162 stores the warehousing plan. FIG. 4 is a diagram illustrating an example of the warehousing plan table. In FIG. 4, the warehousing plan of the goods A in a headquarters warehouse is illustrated. As illustrated in FIG. 4, the warehousing plan table 162 stores the warehousing plan number, the allocable number, and the allocated number for each date in association with each other. Of these, the planned number of receipts indicates the quantity of goods received in the warehouse. The reservable number indicates the amount that can be reserved among the number of warehousing plans. The reserved number indicates the reserved quantity among the number of warehousing plans. In other words, the planned number of warehousing is the sum of the number that can be allocated and the number that has been allocated. In the example illustrated in FIG. 4, the warehousing plan table 162 stores the warehousing plan number “10”, the allocable number “3”, and the allocated number “7” for March 31. In other words, the warehousing plan table 162 stores that there are 10 products A that are received in the headquarters warehouse on March 31, 7 of which are reserved in the order data, and 3 can be allocated. To do.

  The physical inventory table 163 stores physical inventory. FIG. 5 is a diagram illustrating an example of a physical inventory table. As illustrated in FIG. 5, the physical inventory table 163 stores a warehouse, a product, a physical inventory number, an allocation possible number, and an allocated number in association with each other. Of these, the physical inventory number indicates the quantity of the corresponding product existing in the corresponding warehouse. In other words, the actual stock quantity is the sum of the available number and the reserved number. In the example illustrated in FIG. 5, the physical inventory table 163 stores the product “A”, the physical inventory number “20”, the possible allocation number “15”, and the allocated number “5” for the headquarters warehouse. In other words, the physical inventory table 163 stores that there are 20 commodities A in the headquarters warehouse, 5 of which are allocated to the order data, and 15 can be allocated.

  The stock zone determination table 164 stores the nearest warehouse for shipping the product to the delivery destination designated by the customer. FIG. 6 is a diagram illustrating an example of the stock area determination table. As shown in FIG. 6, the stock area determination table 164 stores delivery areas, products, and stock areas in association with each other. The delivery area indicates an area including the delivery destination of the product designated by the customer. In the example illustrated in FIG. 6, the stock area determination table 164 stores the delivery area “Shizuoka Prefecture”, the product “A”, and the stock area “Headquarters warehouse” in association with each other. In other words, when the product A is delivered, the stock area determination table 164 stores that the optimal warehouse is the headquarters warehouse when the delivery destination designated by the customer is Shizuoka Prefecture.

  The higher-level warehouse determination table 165 stores a warehouse that is a candidate for shipping a product next when it cannot be delivered from a certain warehouse. FIG. 7 is a diagram illustrating an example of the upper warehouse determination table. As shown in FIG. 7, the upper warehouse determination table 165 stores the warehouse and the upper warehouse in association with each other. Of these, the higher-level warehouse indicates a warehouse that is a candidate for shipping a product next when the goods cannot be delivered from the corresponding warehouse. In the example illustrated in FIG. 7, the upper warehouse determination table 165 stores the warehouse “Osaka Warehouse” and the upper warehouse “Headquarter Warehouse” in association with each other. That is, the upper warehouse determination table 165 stores that the upper warehouse of the Osaka warehouse is the head office warehouse.

  Next, the functional configuration of the allocation management apparatus 100 will be described. Returning to FIG. 1, the allocation management apparatus 100 includes an order allocation processing unit 111, an allocation review processing unit 112, and a pending allocation processing unit 113 as functional units realized by the cooperation of the CPU 11 and a predetermined program. .

  The order allocation processing unit 111 executes an order allocation process for allocating allocation resources when an order is received. For example, when receiving the order data, the order allocation processing unit 111 allocates an allocation resource that can be allocated on the desired delivery date of the order data. For example, the order allocation processing unit 111 gives priority to the receipt plan of the headquarters warehouse, the physical inventory of the central warehouse, the receipt plan of the regional warehouse, the physical inventory of the regional warehouse, the receipt plan of the upper warehouse, and the physical inventory of the upper warehouse. Reserve. When there is a reserve resource that can be allocated on the desired delivery date, the order reservation processing unit 111 sets the status of the received order data to “allocated” and there is no reserve resource that can be allocated on the desired delivery date. The status of the received order data is “reservation pending”.

  The allocation review processing unit 112 executes an allocation review process for reviewing the allocation resources allocated to the allocated orders. For example, the allocation review processing unit 112 extracts one or a plurality of orders related to a predetermined product existing in a predetermined warehouse from one or a plurality of orders for which allocation resources have been allocated. The allocation review processing unit 112 releases (releases) the allocation resources allocated to the extracted orders. The allocation review processing unit 112 preferentially allocates either the physical inventory or the warehousing plan among the allocation resources of the predetermined warehouse including the allocated allocation resources for the extracted orders according to the characteristics of the orders. The allocation review processing unit 112 extracts one or a plurality of orders related to the predetermined product existing in the predetermined warehouse, releases the allocation resources allocated to the extracted orders, and allocates the allocated allocation resources to the extracted orders The process is repeatedly executed at an arbitrary timing.

  In addition, for example, the allocation review processing unit 112 allocates a reserve resource that can be allocated on the fixed delivery date, and outputs all orders that are allocated on the fixed delivery date when there is no reserve resource that can be allocated.

  The reserve allocation processing unit 113 executes a reserve allocation process for allocating allocation resources for an allocation-pending order. For example, the pending allocation processing unit 113 extracts allocation pending order data from the received order data. The reserve allocation processing unit 113 allocates allocation resources that can be allocated on the desired delivery date of the extracted order data. For example, the reserve allocation processing unit 113 preferentially allocates in the order of the storage plan of the regional warehouse, the actual stock of the regional warehouse, the storage plan of the upper warehouse, and the actual inventory of the upper warehouse. When there is a reserve resource that can be allocated on the desired delivery date, the hold allocation processing unit 113 sets the status of the extracted order data to “allocated” and there is no reserve resource that can be allocated on the desired delivery date. Sets the status of the extracted order data as “reservation pending”.

  Next, the processing procedure of the allocation management device 100 will be described. 8 and 9 are flowcharts showing the processing procedure of the order reservation process. As shown in FIG. 8, when order data is received (step S101; Yes), the order allocation processing unit 111 determines whether or not the desired delivery date can be observed in the warehousing plan of the headquarters warehouse (step S102). For example, on the 25th of March, the order allocation processing unit 111 receives a product “A”, a quantity “5”, a desired delivery date “April 2”, and a delivery area (such as a delivery address) “Miyazaki Prefecture. Are received as order data. Then, the order allocation processing unit 111 refers to the warehousing plan table 162 of the headquarters warehouse illustrated in FIG. 4 and can observe the desired delivery date “April 2” of the order data after calculating the number of days required for delivery. It is determined whether or not. If it is determined that the desired delivery date can be observed in the warehouse plan at the headquarters warehouse (step S102; Yes), the order acceptance processing unit 111 proceeds to step S110.

  When it is determined that the desired delivery date cannot be observed in the receipt plan of the main warehouse (step S102; No), the order reservation processing unit 111 determines whether the desired delivery date can be observed in the actual stock in the main warehouse. (Step S103). For example, the order allocation processing unit 111 refers to the physical inventory table 163 illustrated in FIG. 5, calculates the number of days required for delivery, and confirms whether the desired delivery date “April 2” of the order data can be observed. Determine. When it is determined that the desired delivery date can be observed in the actual stock in the headquarters warehouse (step S103; Yes), the order allocation processing unit 111 proceeds to step S110.

  When it is determined that the desired delivery date cannot be observed in the actual stock in the headquarters warehouse (step S103; No), the order allocation processing unit 111 determines whether the desired delivery date can be observed in the warehousing plan of the regional warehouse. (Step S104). For example, the order allocation processing unit 111 refers to the inventory area determination table 164 illustrated in FIG. 6, and determines the inventory area “Tosu Warehouse” corresponding to the delivery area “Miyazaki Prefecture ...” and the product “A” of the order data. decide. Then, the order acceptance processing unit 111 refers to the warehousing plan table 162 of the Tosu warehouse and determines whether or not the desired delivery date “April 2” of the order data can be observed after calculating the number of days required for delivery. To do. If it is determined that the desired delivery date can be observed in the warehouse plan of the regional warehouse (step S104; Yes), the order reservation processing unit 111 proceeds to step S110.

  When it is determined that the desired delivery date cannot be observed in the warehouse plan of the regional warehouse (step S104; No), the order reservation processing unit 111 determines whether the desired delivery date can be observed in the actual stock of the regional warehouse. (Step S105). For example, the order allocation processing unit 111 refers to the physical inventory table 163 illustrated in FIG. 5, calculates the number of days required for delivery, and confirms whether the desired delivery date “April 2” of the order data can be observed. Determine. If it is determined that the desired delivery date can be observed in the actual stock in the regional warehouse (step S105; Yes), the order allocation processing unit 111 proceeds to step S110.

  If it is determined that the desired delivery date cannot be observed in the actual stock in the regional warehouse (step S105; No), the order reservation processing unit 111 determines whether the desired delivery date can be observed in the warehousing plan of the upper warehouse. (Step S106). For example, the order allocation processing unit 111 refers to the upper warehouse determination table 165 illustrated in FIG. 7 and determines the upper warehouse “Yamaguchi Warehouse” corresponding to the determined regional warehouse “Tosu Warehouse”. Then, the order reservation processing unit 111 refers to the warehousing plan table 162 of the Yamaguchi warehouse, and after calculating the number of days required for delivery, determines whether or not the desired delivery date “April 2” of the order data can be observed. To do. When it is determined that the desired delivery date can be observed in the storage plan of the upper warehouse (step S106; Yes), the order reservation processing unit 111 proceeds to step S110.

  When it is determined that the desired delivery date cannot be observed in the storage plan of the upper warehouse (step S106; No), the order reservation processing unit 111 determines whether the desired delivery date can be observed in the actual stock of the upper warehouse. (Step S107). For example, the order allocation processing unit 111 refers to the physical inventory table 163 illustrated in FIG. 5, calculates the number of days required for delivery, and confirms whether the desired delivery date “April 2” of the order data can be observed. Determine. When it is determined that the desired delivery date can be observed in the actual stock in the upper warehouse (step S107; Yes), the order reservation processing unit 111 proceeds to step S110.

  When it is determined that the desired delivery date cannot be observed in the actual stock of the upper warehouse (step S107; No), the order allocation processing unit 111 determines whether the upper warehouse exists (step S108). For example, the order allocation processing unit 111 refers to the upper warehouse determination table 165 illustrated in FIG. 7 and determines the upper warehouse “Osaka Warehouse” corresponding to the determined upper warehouse “Yamaguchi Warehouse”. When it is determined that the upper warehouse exists (step S108; Yes), the order reservation processing unit 111 proceeds to step S106.

  When it is determined that there is no upper warehouse (step S108; No), as shown in FIG. 9, the order allocation processing unit 111 determines whether or not the delivery date can be determined by the warehousing plan of the regional warehouse ( Step S109). For example, the order reservation processing unit 111 refers to the warehousing plan table 162 of the stock area “Tosu Warehouse” determined in step S104, and determines whether or not the delivery date can be confirmed after calculating the number of days required for delivery. . If it is determined that the delivery date can be confirmed (step S109; Yes), the order reservation processing unit 111 proceeds to step S110.

  When it is determined that the delivery date cannot be determined (step S109; No), the order reservation processing unit 111 determines whether there is a higher warehouse (step S111). For example, the order allocation processing unit 111 refers to the upper warehouse determination table 165 illustrated in FIG. 7 and determines the upper warehouse “Yamaguchi Warehouse” corresponding to the determined regional warehouse “Tosu Warehouse”.

  When it is determined that the upper warehouse exists (step S111; Yes), the order reservation processing unit 111 determines whether or not the delivery date can be determined by the warehousing plan of the upper warehouse (step S112). For example, the order reservation processing unit 111 refers to the warehousing plan table 162 of the higher-level warehouse “Yamaguchi Warehouse” determined in step S111, and determines whether or not the delivery date can be confirmed after calculating the number of days required for delivery. . When it is determined that the delivery date cannot be determined (step S112; No), the order reservation processing unit 111 proceeds to step S111.

  If it is determined that the delivery date can be determined (step S112; Yes), the order allocation processing unit 111 allocates allocation resources to the received order data (step S110) and ends the process. For example, the order allocation processing unit 111 accepts the received order data, the determined stock area, the shipping warehouse for shipping the allocation resources, the confirmed fixed delivery date, and the status of the order data illustrated in FIG. Store in table 161. In addition, for example, the order reservation processing unit 111 updates the available allocation number and the allocated number in the warehousing plan table 162 and the physical inventory table 163. For example, when 10 in-stock inventory of the product “A” in Yamaguchi Warehouse is allocated to the order data, 10 is added to the allocated number in the actual inventory table 163 and 10 is subtracted from the available number.

  If it is determined that there is no upper warehouse (step S111; No), the order reservation processing unit 111 places the received order data on hold (step S113) and ends the process. For example, the order allocation processing unit 111 stores the received order data, the determined stock area, and the status of the order data in the order table 161 illustrated in FIG. The order allocation processing unit 111 stores “-” in the shipping warehouse and the confirmed delivery date.

  FIG. 10 is a flowchart showing the processing procedure of the allocation review process. As shown in FIG. 10, when the processing timing comes (step S201; Yes), the allocation review processing unit 112 extracts order data to be processed (step S202). For example, the allocation review processing unit 112 starts processing every day (for example, midnight). Further, for example, the allocation review processing unit 112 processes the order data related to a predetermined product allocated from a predetermined shipping warehouse among the order data of the status “allocated” in the order table 161. That is, for example, the allocation review processing unit 112 extracts all the order data corresponding to the shipping warehouse “Osaka Warehouse”, the product “A”, and the status “allocated” from the order data in the order table 161 as processing targets. . Since the allocation review process in FIG. 10 is executed for each combination of the shipping warehouse and the product, a plurality of allocation review processes may be executed in parallel. For example, an allocation review process for the shipping warehouse “Osaka Warehouse” and the product “A”, an allocation review process for the shipping warehouse “Osaka Warehouse” and the product “B”, and an allocation review for the shipping warehouse “Tosu Warehouse” and the product “A” The processing may be executed in parallel.

  The allocation review processing unit 112 releases the allocation resources allocated to the order data to be processed (step S203). For example, the allocation review processing unit 112 releases allocation resources allocated to all the extracted order data. For example, when 10 in-stock inventory of the product “A” in the Osaka warehouse is allocated to the order data to be processed, 10 is subtracted from the allocated number in the actual inventory table 163, and 10 is allocated to the allowable number. to add.

  The allocation review processing unit 112 arranges the order data to be processed by the allocation priority number (step S204). For example, the allocation review processing unit 112 arranges all the extracted order data in ascending order by allocation priority number.

  The allocation review processing unit 112 arranges the order data to be processed by order date (step S205). For example, when the order data is arranged in ascending order by the allocation priority number, the allocation review processing unit 112 arranges the order data in ascending order by the order date for each allocation priority number.

  The allocation review processing unit 112 selects one piece of order data to be processed (step S206). For example, when the order data is arranged in ascending order by the allocation priority number and the order date, the allocation review processing unit 112 selects one order data having the smallest allocation priority number and order date value.

  The allocation review processing unit 112 determines whether or not the fixed delivery date can be observed in the warehousing plan (step S207). For example, the allocation review processing unit 112 refers to the warehousing plan table 162 of the product “A” in the shipping warehouse “Osaka warehouse”, calculates the number of days required for delivery, and then confirms the confirmed delivery date “April 2” of the order data. It is determined whether or not it can be observed. When it is determined in the warehousing plan that the confirmed delivery date can be observed (step S207; Yes), the allocation review processing unit 112 proceeds to step S209.

  When it is determined in the warehousing plan that the fixed delivery date cannot be observed (step S207; No), the allocation review processing unit 112 determines whether the fixed delivery date can be observed in the actual stock (step S208). For example, the allocation review processing unit 112 refers to the physical inventory table 163 illustrated in FIG. 5, calculates the number of days required for delivery, and sets the confirmed delivery date “April 2” of the order data to the shipping warehouse “Osaka Warehouse”. It is determined whether or not compliance can be made with the actual stock of the product “A”.

  When it is determined that the confirmed delivery date can be observed in the actual stock (step S208; Yes), the allocation review processing unit 112 allocates the allocation resources (step S209). For example, the allocation review processing unit 112 associates the selected order data with the shipping warehouse for shipping the allocation resources, the confirmed confirmed delivery date, and the status of the order data in the order table 161 illustrated in FIG. Store. In addition, for example, the order reservation processing unit 111 updates the available allocation number and the allocated number in the warehousing plan table 162 and the physical inventory table 163.

  The allocation review processing unit 112 determines whether there is unselected order data (step S210). If it is determined that there is unselected order data (step S210; Yes), the allocation review processing unit 112 proceeds to step S206. If it is determined that there is no unselected order data (step S210; No), the allocation review processing unit 112 ends the process.

  When it is determined that the confirmed delivery date cannot be observed in the actual stock (step S208; No), the allocation review processing unit 112 interrupts and resets the process (step S211). Further, for example, the allocation review processing unit 112 generates a list of all received order data for which allocation resources are allocated on the fixed delivery date that could not be observed, and outputs the generated list as a warning list. Note that the warning list may be output to the display unit 15 or may be transmitted to an external device via the communication unit 17.

  FIG. 11 is a flowchart showing the processing procedure of the reserve allocation process. As shown in FIG. 11, when the processing timing comes (step S301; Yes), the reservation allocation processing unit 113 extracts order data to be processed (step S302). For example, the pending allocation processing unit 113 starts processing after the allocation review processing is executed. In addition, for example, the pending allocation processing unit 113 processes the order data related to a predetermined product allocated from a predetermined shipping warehouse among the order data of the status “reservation pending” in the order table 161. That is, for example, the pending allocation processing unit 113 extracts all the received order data corresponding to the shipping warehouse “Osaka warehouse”, the product “A”, and the situation “reserved pending” from the order data in the order table 161 as processing targets. . 11 is executed for each combination of the shipping warehouse and the merchandise, a plurality of hold allocation processes may be executed in parallel. For example, a reserve allocation process for the shipping warehouse “Osaka Warehouse” and the product “A”, a reserve allocation process for the shipping warehouse “Osaka Warehouse” and the product “B”, and a reserve allocation for the shipping warehouse “Tosu Warehouse” and the product “A”. The processing may be executed in parallel.

  The reserve allocation processing unit 113 arranges the order data to be processed according to the order date (step S303). For example, the pending allocation processing unit 113 arranges all the extracted order data in ascending order by order date.

  The reserve allocation processing unit 113 selects one piece of order data to be processed (step S304). For example, when the order data is arranged in ascending order by order date, the reservation allocation processing unit 113 selects one order data having the smallest order date value.

  The reserve allocation processing unit 113 determines whether or not the desired delivery date can be observed in the inventory plan for the inventory area (step S305). For example, the reserve allocation processing unit 113 refers to the warehousing plan table 162 of the product “B” in the inventory section “Osaka warehouse” of the selected order data, and after calculating the number of days required for delivery, the desired delivery date of the order data It is determined whether or not “April 2” can be observed. When it is determined in the warehousing plan that the desired delivery date can be observed (step S305; Yes), the suspension allocation processing unit 113 proceeds to step S310.

  If it is determined in the warehousing plan that the desired delivery date cannot be observed (step S305; No), the reserve allocation processing unit 113 determines whether the desired delivery date can be observed in the actual stock in the inventory area (step S306). ). For example, the reserve allocation processing unit 113 refers to the physical inventory table 163 illustrated in FIG. 5, calculates the number of days required for delivery, and sets the desired delivery date “April 2” in the order data to the inventory section “Osaka Warehouse”. It is determined whether or not compliance can be made with the actual stock of the product “B”. When it is determined that the desired delivery date can be observed with the actual stock (step S306; Yes), the suspension allocation processing unit 113 proceeds to step S310.

  When it is determined that the desired delivery date cannot be observed in the actual stock (step S306; No), the hold allocation processing unit 113 determines whether there is a higher-level warehouse (step S307). For example, the reserve allocation processing unit 113 refers to the upper warehouse determination table 165 illustrated in FIG. 7 and determines whether there is an upper warehouse corresponding to the determined stock area “Osaka Warehouse”. When it is determined that there is no upper warehouse (step S307; No), the reservation allocation processing unit 113 proceeds to step S311.

  If it is determined that the upper warehouse exists (step S307; Yes), the hold allocation processing unit 113 determines whether or not the desired delivery date can be observed in the warehousing plan of the upper warehouse (step S308). For example, the reserve allocation processing unit 113 refers to the warehousing plan table 162 of the product “B” of the upper warehouse “headquarter warehouse”, calculates the number of days required for delivery, and then selects the desired delivery date “April 2” of the order data. It is determined whether or not it can be observed. If it is determined in the warehousing plan that the desired delivery date can be observed (step S308; Yes), the suspension allocation processing unit 113 proceeds to step S310.

  When it is determined in the warehousing plan that the desired delivery date cannot be observed (step S308; No), the reserve allocation processing unit 113 determines whether or not the desired delivery date can be observed in the actual stock in the upper warehouse (step S309). ). For example, the reserve allocation processing unit 113 refers to the physical inventory table 163 illustrated in FIG. 5, calculates the number of days required for delivery, and sets the desired delivery date “April 2” of the order data to the upper warehouse “main warehouse It is determined whether or not compliance can be made with the actual stock of the product “B”. When it is determined that the desired delivery date cannot be observed with the actual stock (step S309; No), the suspension allocation processing unit 113 proceeds to step S307.

  When it is determined that the desired delivery date can be complied with the actual stock (step S309; Yes), the pending allocation processing unit 113 allocates allocation resources (step S310). For example, the pending allocation processing unit 113 associates the selected order data with the shipping warehouse for shipping the allocation resources, the confirmed confirmed delivery date, and the status of the order data in the order table 161 illustrated in FIG. Store.

  The reserve allocation processing unit 113 determines whether there is unselected order data (step S311). If it is determined that there is unselected order data (step S311; Yes), the hold allocation processing unit 113 proceeds to step S304. When it is determined that there is no unselected order data (step S311; No), the reservation processing unit 113 ends the process.

  Next, the effect of the allocation management device 100 will be described. The allocation management apparatus 100 extracts one or a plurality of orders relating to a predetermined product existing in a predetermined warehouse from one or a plurality of orders for which allocation resources have been allocated. The allocation management device 100 releases the allocation resources allocated to the extracted orders. The allocation management device 100 preferentially allocates either the physical inventory or the warehousing plan among the allocation resources of the predetermined warehouse including the allocated allocation resources for the extracted orders according to the characteristics of the orders. The allocation management apparatus 100 extracts one or a plurality of orders related to a predetermined product existing in a predetermined warehouse, releases allocation resources allocated to the extracted orders, and allocates allocated allocation resources to the extracted orders Are repeatedly executed at an arbitrary timing. For this reason, the allocation management apparatus 100 can appropriately allocate allocation resources in consideration of daily fluctuations in allocation resources. For example, since the allocation management apparatus 100 allocates priority to either the physical inventory or the warehousing plan according to the characteristics of the order, it is possible to appropriately allocate the allocation resources according to the characteristics of the order. For example, in the case of a factory kitting order, the allocation management apparatus 100 allocates the warehousing plan with priority, so that factory kitting can be performed efficiently. In other words, the allocation management device 100 can efficiently perform shipment after setting a product in a factory.

  In addition, for example, the allocation management apparatus 100 allocates the warehousing plan in preference to the physical inventory according to the characteristics of the order, so that it is possible to reduce intermediate logistics costs such as inter-warehouse transportation costs, cargo handling costs, and storage fees. . For this reason, since the allocation management apparatus 100 can allocate the physical inventory to the customer who hurries delivery, it is possible to reduce allocation resources reserved for emergency response.

  In addition, for example, when there is no reserve resource that can be allocated in a predetermined warehouse, the allocation management apparatus 100 determines the allocation resource in the upper warehouse of the predetermined warehouse step by step. Can be improved.

  The embodiment according to the present invention has been described above, but the present invention is not limited to this, and various changes, substitutions, additions, and the like are possible without departing from the spirit of the present invention.

  For example, in the above-described embodiment, it has been described in FIG. 10 that the allocation review processing unit 112 executes the process of step S207 in order from the order data having the smallest allocation priority number, and then executes the process of step S208. However, the present invention is not limited to this. For example, the allocation review processing unit 112 may execute the process of step S208 in order from the order data having a larger allocation priority number, and then execute the process of step S207. Further, for example, the allocation review processing unit 112 prioritizes the process of step S207 for order data having a predetermined allocation priority number, and performs the process of step S208 for order data not having the predetermined allocation priority number. Priority may be given to execution.

  In the above embodiment, the program executed on the PC is provided in a state stored in the ROM 12 or the storage unit 16. However, the present invention is not limited to this, and the program can be installed in an installable or executable format file. -It is good also as a form which records and provides on computer-readable recording media, such as ROM, flexible disk (FD), CD-R, DVD (Digital Versatile Disk).

  The program executed on the PC according to the above embodiment may be provided by being stored on a computer connected to a network such as the Internet and downloaded via the network. The program executed on the PC of the above embodiment may be provided or distributed via a network such as the Internet.

11 CPU
12 ROM
13 RAM
14 Input unit 15 Display unit 16 Storage unit 17 Communication unit 100 Allocation management device 111 Order allocation processing unit 112 Allocation review processing unit 113 Reserve allocation processing unit 161 Order reception table 162 Receipt plan table 163 Physical inventory table 164 Inventory area determination table 165 Upper warehouse Decision table

JP 2003-99507 A JP-A-10-214298 Japanese Patent Application Laid-Open No. 5-324585 JP-A-4-289967 JP 2002-251552 A JP 2003-316416 A

Claims (4)

Predetermined goods that exist in a given warehouse from one or more orders that have been allocated reserve resources, including physical inventory that indicates the quantity of goods that exist in the warehouse and a warehousing plan that indicates the quantity of the goods that are received in the warehouse Extracting means for extracting one or a plurality of orders relating to;
Release means for releasing the provision resources allocated to the order extracted by the extraction means;
For the orders extracted by the extraction means, one of the physical inventory and the warehousing plan out of the allocation resources of the predetermined warehouse including the allocation resources released by the release means according to the characteristics of the order. Is allocated, the order for which there is a reserve resource available for allocation is reserved, the order for which there is no reserve resource available for allocation is reserved, and the reserve resource allocated for the received order is allocated. An allocation means for executing a reserve review process for executing a reserve review process for reserving and reserving a reserve resource for the order that has been reserved .
The extraction means is made to extract the order, the allocation resources allocated to the order extracted by the extraction means are released to the release means, and the allocation resources released by the release means are extracted by the extraction means An allocation management apparatus comprising: a control unit that repeatedly executes the process of allowing the allocation unit to allocate an order at an arbitrary timing. The order includes a delivery date of the product,
The allocation means allocates reserve resources that can be allocated on the delivery date included in the order, and outputs all orders allocated on the delivery date when there is no reserve resource that can be allocated The allocation management device according to claim 1. An allocation management method executed by an allocation management device,
Predetermined goods that exist in a given warehouse from one or more orders that have been allocated reserve resources, including physical inventory that indicates the quantity of goods that exist in the warehouse and a warehousing plan that indicates the quantity of the goods that are received in the warehouse An extraction process for extracting one or more orders for
Releasing the allocation resources allocated to the orders extracted by the extraction step;
For the orders extracted by the extraction process, either the physical inventory or the warehousing plan among the allocation resources of the warehouse including the allocation resources released by the release process according to the characteristics of the order. Is allocated, the order for which there is a reserve resource available for allocation is reserved, the order for which there is no reserve resource available for allocation is reserved, and the reserve resource allocated for the received order is allocated. An allocation process for executing a reserve review process for executing a reserve review process for executing a reserve review process for reserving a reserve resource for the order that has been reserved ,
An allocation management method comprising repeatedly executing the extraction step, the release step, and the allocation step at an arbitrary timing. Predetermined goods that exist in a given warehouse from one or more orders that have been allocated reserve resources, including physical inventory that indicates the quantity of goods that exist in the warehouse and a warehousing plan that indicates the quantity of the goods that are received in the warehouse An extraction step of extracting one or more orders for
Releasing the allocation resources allocated to the orders extracted by the extraction step;
For the orders extracted by the extraction step, either the physical inventory or the warehousing plan among the allocation resources of the warehouse including the allocation resources released by the release step according to the characteristics of the order. Is allocated, the order for which there is a reserve resource available for allocation is reserved, the order for which there is no reserve resource available for allocation is reserved, and the reserve resource allocated for the received order is allocated. An allocation management program for executing an allocation review process for reviewing a reserve and executing a reserve allocation process for executing a reserve allocation process for allocating a reserve resource for an order with an allocation pending .

Images