JP2018136801A - Stock allocation order setting device, stock allocation order setting method, and stock allocation order setting program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a stock allocation order setting device, a stock allocation order setting method, and a stock allocation order setting program for setting an allocation order in the case of performing stock allocation on the basis of various references, and for, even when a fraction in which the number of order placement does not match stock allocation is generated, performing distribution processing.SOLUTION: In a stock allocation order setting device 100 comprising a control unit 102 and a storage unit 106, which sets an allocation order of a stock with respect to store order placement data of merchandise from a store, the storage unit 106 stores a first master for setting an allocation unit of each merchandise with respect to a store as a setting target of the allocation order, and the control unit 102 comprises: an allocation order determination unit 102b for determining the allocation order of merchandise on the basis of the allocation unit with respect to the target store set by the first master; and a stock allocation processing unit 102c for performing stock allocation processing on the basis of the determined allocation order and the stock of merchandise to generate shipping request data 106h.SELECTED DRAWING: Figure 1

Description

  The present invention relates to an inventory allocation order setting device, an inventory allocation order setting method, and an inventory allocation order setting program.

  Claim 1 of Patent Document 1 describes an ordering instruction system for instructing an optimal stock quantity / order quantity based on an upper limit value and a lower limit value calculated using statistical theory, and in particular, an order from each store. When the required amount calculated by receiving and summing up the requested data is compared with the available warehouse stock quantity that can support the current order of the warehouse inventory quantity, and the required quantity exceeds the available warehouse inventory quantity , Subtract at least one of the distribution structure factor γ, campaign factor α, and variation response factor β that constitutes the order request data, and recalculate the required quantity to be less than the available warehouse inventory quantity. It is disclosed that the current order quantity of each store is fixed and inventory is reserved.

Japanese Patent No. 4139410

  As described above, in the ordering instruction system of Patent Document 1, it is possible to instruct the optimum stock quantity and the optimum order quantity. However, the calculation method is uniform, and various circumstances between stores are taken into consideration. There was a problem that it was difficult to respond flexibly. In addition, when there is a fraction that does not match the order quantity and the inventory allocation, there is a problem that it is not necessary to make a distribution according to the judgment of the headquarters, or it is necessary to confirm at any time about the distribution to a specific store.

  The present invention has been made in view of the above problems, and when there is a request for shipping the same product from a store, the order of allocation when performing inventory allocation can be set based on various criteria, and It is an object of the present invention to provide an inventory allocation order setting device, an inventory allocation order setting method, and an inventory allocation order setting program that enable distribution even when a fraction that does not match the number and inventory allocation occurs.

  In order to solve the above-described problems and achieve the object, an inventory allocation order setting device according to the present invention includes a control unit and a storage unit, and sets the allocation order of inventory for store order data of products from a store The storage unit stores a first master that sets an allocation unit for each product for the store for which the allocation order is to be set. A section for determining an order of allocation of the product based on an allocation unit for the target store set in the first master; and an allocation of inventory based on the determined allocation order and the inventory of the product. And inventory allocation processing means for performing processing to generate shipping request data.

  Further, in the inventory allocation order setting device according to the present invention, the first master is a management master that manages the conditions of the target store for which the allocation order is set, and the target store that is set in the management master. A product master for determining the allocation unit for each product for each of the products, and based on the target store set in the management master by the allocation order determination means and the allocation unit for each product of the product master It is characterized in that the order of allocation of merchandise in the store is determined, and the inventory allocation process is performed by the inventory allocation processing unit based on the allocation level to generate shipping request data.

  The inventory allocation order setting method according to the present invention includes a control unit and a storage unit, and the inventory allocation order executed by an inventory allocation order setting device that sets the allocation level of inventory for store order data of goods from a store. In the rank setting method, the storage unit stores a first master that sets an allocation unit for each product for the store for which the allocation rank is set, and is executed by the control unit. An allocation order determination step for determining an allocation order of the product based on an allocation unit for the target store set in the first master, and an inventory allocation based on the determined allocation order and the inventory of the product And an inventory allocation processing step of performing processing to generate shipping request data.

  An inventory allocation order setting program according to the present invention includes a control unit and a storage unit, and is executed by an inventory allocation order setting device that sets an inventory allocation order for store ordering data of goods from a store. In the allocation order setting program, the storage unit stores a first master for setting an allocation unit for each product for the store for which the allocation order is to be set. An allocation order determination step for determining an allocation order of the product based on an allocation unit for the target store set in the first master for execution, and based on the determined allocation order and the inventory of the product And an inventory allocation processing step of performing inventory allocation processing to generate shipping request data.

  According to the present invention, when there is a shipment request for the same product from a store, the order of allocation when inventory allocation is performed can be set based on various criteria, and the number of orders and inventory allocation do not match Even in this case, there is an effect that the distribution is possible.

FIG. 1 is a block diagram illustrating an example of a configuration of an inventory allocation order setting device. FIG. 2 is a flowchart for explaining the flow from inventory allocation to the creation of shipping request data based on merchandise store ordering data. FIG. 3 is a diagram illustrating a setting example of a management master that manages a higher-level store. FIG. 4 is a diagram illustrating a setting example of a product master that determines the allocation unit for each product. FIG. 5 is a diagram illustrating an example of processing in a case where inventory allocation is performed equally for all stores based on store ordering data. FIG. 6 is a diagram illustrating an example of processing in a case where only a higher-level store reserves inventory based on store order data. FIG. 7 is a diagram illustrating an example of processing in a case where only a higher-order sales store reserves inventory based on store order data. FIG. 8 is a diagram illustrating a setting example of a merchandise master and a store master that determine whether or not to reserve inventory for each merchandise and a unit of allocation. FIG. 9 is a diagram illustrating an example of store master registration and an example of store order data when stock reservation is performed in accordance with the ranking ranking of the store master. FIG. 10 is a diagram illustrating an example in which allocation is performed by comparing the store order data image of FIG. 9 with an inventory file. FIG. 11 is a diagram illustrating an example of the allocation image and the distribution inventory quantity adjustment in FIG. FIG. 12 is a diagram illustrating an example in which the rank is calculated from the sales amount when the store rating is set. FIG. 13 is a diagram illustrating an example in which a numerical value is set from the store attribute when the store rating setting is performed. FIG. 14 is a diagram illustrating an example in which a rating ranking is set based on store attributes when store rating setting is performed. FIG. 15 is a diagram illustrating a specific example in which the sales rank is acquired from the store sales amount and the store rating is performed. FIG. 16 is a diagram illustrating a specific example of acquiring store attribute information from a store master and performing store rating. FIG. 17 is a diagram illustrating a specific example in which a store rating is calculated by setting a coefficient for each store size by input.

  Embodiments of an inventory allocation order setting device, an inventory allocation order setting method, and an inventory allocation order setting program according to the present invention will be described below in detail with reference to the drawings. In addition, this invention is not limited by this embodiment.

[1. Overview]
In the retail industry, etc., if there is a request for shipment of the same product from multiple stores to the headquarters, the inventory is reserved for the stock of the product, and when the product is shipped to the store, it is reflected in the actual stock quantity. . Here, when the number of goods in stock is insufficient for the shipping request, it is necessary to determine the priority order of the stock allocation and perform the stock allocation based on this.

  In the conventional inventory allocation in the retail industry, the allocation order is set uniformly in the system, or if a fraction occurs after allocation, no allocation is made at the headquarters judgment or allocation to a specific store There is a problem that confirmation is required from time to time.

  Therefore, in this embodiment, when there is a request for shipping the same product from the store to the headquarters, (a) store equalization, (b) up to the top ○ store, (c) sales amount of more than ¥ yen, etc. It is possible to set the allocation order by performing master management based on the above. In addition, for the allocation of “fraction” where the actual stock quantity does not match the desired number of shipment requests (number of orders), an inventory allocation order setting device, an inventory allocation order setting method, and an inventory allocation order that can be allocated by master management A setting program is provided. Hereinafter, a specific configuration and operation will be described.

[2. Constitution]
The configuration of the inventory allocation order setting device 100 according to this embodiment will be described with reference to FIG. FIG. 1 is a block diagram illustrating an example of the configuration of the inventory allocation order setting device 100.

  The inventory allocation order setting device 100 is a commercially available desktop personal computer. The inventory allocation order setting device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, tablet personal computer, or the like. It may be a portable information processing apparatus.

  As shown in FIG. 1, the inventory allocation order setting device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the inventory allocation order setting device 100 is connected to be communicable via an arbitrary communication path.

  The communication interface unit 104 communicatively connects the inventory allocation order setting device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of connecting the inventory allocation order setting device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that data stored in the storage unit 106 to be described later may be stored in the server 200.

  An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker (including a home television), a speaker, and a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that realizes a pointing device function in cooperation with the mouse can be used. In the following description, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

  The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for giving various instructions to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) and a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, and an optical disk can be used.

  The storage unit 106 includes a management master 106a and a product master 106b as a first master, a store master 106c, a store attribute master 106d, a sales rank master 106e as a rating master, store order data 106f, and an inventory file 106g. Shipping request data 106h, and POS (Point Of Sale System) sales data 106i as an attribute information storage table. Of these, the sales rank master 106e only needs to be a rating master that digitizes the rating of the store based on the attribute information of the store, and is not necessarily limited to the sales rank. The POS sales data 106i may be a table that stores store attribute information, and is not necessarily limited to the POS sales data. Further, the store order data 106f, the inventory file 106g, and the shipping request data 106h may be stored in the storage unit 106 as shown in FIG. Or shipping request data generated by performing the inventory allocation process may be directly output.

  The items including the aforementioned five masters and the aforementioned four data (files) stored in the storage unit 106 are mainly stored in FIG. 2, FIG. 3, FIG. 4, FIG. 8, FIG. Details will be described with reference to FIGS. 16 and 17. FIG. 2 is a flowchart for explaining the flow from inventory allocation to the creation of shipping request data based on merchandise store ordering data. FIG. 3 is a diagram illustrating a setting example of a management master that manages a higher-level store. FIG. 4 is a diagram illustrating a setting example of a product master that determines the allocation unit for each product. FIG. 8 is a diagram showing a setting example of a merchandise master and a store master that determine whether or not to reserve inventory for each merchandise and a unit of allocation. FIG. 10 is a diagram illustrating an example in which allocation is performed by comparing the store order data image of FIG. 9 with an inventory file. FIG. 12 is a diagram illustrating an example in which the rank is calculated from the sales amount when the store rating is set. FIG. 15 is a diagram illustrating a specific example in which the sales rank is acquired from the store sales amount and the store rating is performed. FIG. 16 is a diagram illustrating a specific example of acquiring store attribute information from a store master and performing store rating. FIG. 17 is a diagram illustrating a specific example in which a store rating is calculated by setting a coefficient for each store size by input.

  The management master 106a is a master that manages the conditions of the target store for which the inventory allocation order is set. As shown in FIGS. 2 and 3, the management master 106 a enables arbitrary setting of the allocation order when inventory allocation is performed based on store ordering data. For example, as shown in FIG. 3, the condition of the target store for which the allocation order is set is defined as “higher store” or “sales reference amount” or more. The “upper store” is a store in the management master 106a that is treated as “upper” in various forms and analysis among the managed stores, and here, the upper 50 stores are targeted. The “sales reference amount” is a reference amount that treats a store having a sales amount equal to or more than a set amount as “higher”, makes an excellent sales store, and can manage provision priority management. Here, the set amount is set to ¥ 500,000, and stores whose monthly sales exceed this amount are set as management targets.

  The product master 106b is a master that determines an allocation unit for each product for a store to be managed set in the management master 106a. As shown in FIGS. 2 and 4, in the case of “allocation FLG” for inventory allocation, the merchandise master 106b allocates all the stores that have been ordered equally by rounding down, and the fraction refers to the fraction classification “ “0: All store allocation” and the desired number of upper stores in the management master 106a are set, then “1: upper store” that reserves the remaining inventory quantity to lower stores, and monthly sales (monthly amount to store master 106c described later) “2: Sales base amount” to be allocated to the lower stores after setting the desired number of stores exceeding the reference amount. Further, as shown in FIG. 2 and FIG. 4, the product master 106 b, when “fractional allocation” for performing the fraction processing, leaves the fraction as inventory “0: leave fraction as inventory”, It is possible to select “1: allocate a fraction to a higher-level store” that reserves fractions in a store and “2: allocate a fraction in units of quantity” that allocates fractions in order of decreasing desired number in the allocation target store. .

  Further, as shown in FIG. 2 and FIG. 8, the merchandise master 106b selects “3: store rating” which quantifies the store rating setting as a master for determining the allocation unit for each product. Based on the rating of the store, the rating ranking is set. As shown in FIG. 8, the ranking is set from the sales rank master or the store master for each week registered in the store master 106c. Further, as shown in FIG. 2 and FIG. 8, the product master 106 b considers “0: no need for allocation (headquarter allocation)” as a master for determining the allocation unit for each product, and makes it unnecessary for the headquarters allocation. "1: Store priority", which is determined by maintenance, and "2: Store previous week sales ratio" in which the sales order is automatically set according to the sales ratio of the previous week of the store (in order of sales amount). .

  The store master 106c is a master that holds attribute information for each store that has been digitized. Arbitrary attribute information can be additionally set. As an example of setting attribute information, as shown in FIG. 16, an example is a store sales rank, a store area rank, a store location rank, a store employee rank, a store manager rank, and a store floor rank. However, it is not necessarily limited to this. In addition to calculating the store rating rank with the sum of the sum of the attribute information ranked, a rank coefficient is set for each store, and the rank rating coefficient is applied to the calculated attribute information sum to calculate the store rating rank. May be calculated. Further, the attribute information may be converted into a numerical value by combining them alone or appropriately, thereby determining the ranking of the stores.

  The store attribute master 106d is a master that outputs a store rating result based on numerical values obtained by combining the attribute information of the store master 106c alone or appropriately. As shown in FIGS. 16 and 17, the store attribute master 106 d can calculate the store rating as a numerical value by setting the attribute information for each store that has been digitized. In addition, as shown in FIG. 17, the store rating is calculated not only by adding the digitized store attribute information, but also by adding a coefficient other than the attribute information (here, a coefficient for each scale) as needed. The store rating may be calculated by multiplying the sum of attribute information for each store by a coefficient. Thereby, the headquarters side can also control so that a different store rating result may be obtained.

  The sales rank master 106e is one of rating masters that digitize store ratings based on an attribute information storage table (for example, POS sales data 106i) that stores store attribute information. As shown in FIGS. 12 and 15, the sales rank master 106 e totals the sales amount for each store based on the POS sales data 106 i when the attribute information is the sales rank of the store, and determines the sales rank according to the sales amount. It can be digitized (in the example of FIG. 15, sales ranks 1 to 5). As the rating master, in addition to the sales rank master 106e, an area rank master, a location rank master, an employee rank master, a store manager rank master, a floor rank master, etc. (not shown) may be provided according to the attribute information to be used. The above-described management master 106a, product master 106b, store master 106c, store attribute master 106d, sales rank master 106e, and the like can be maintained by a master maintenance unit 102e of the control unit 102 described later.

  The store order data 106f is order data for ordering products from the store to the headquarters. Store order data 106f is stored by inputting order data from a store using a terminal such as a personal computer, or by a store employee hand-transmitting order data from a handy terminal and inputting it by hand-in of store order data. .

  The inventory file 106g stores inventory information for each product on the headquarters side and is updated in real time. The inventory file 106g indicates that when the store order data of a product comes from a store and receives an order, the inventory is allocated and the number of available stocks decreases. When the product is actually shipped to the store and recorded as sales, the actual stock number Decrease. In this way, the inventory allocation is performed by comparing the order quantity with the inventory quantity in the inventory file 106g.

  The shipping request data 106h performs inventory allocation by comparing the number of products ordered by the store ordering data 106f with the number of stocks by the inventory file 106g, and the shipment of how to distribute the stocked products to each store. Generate and store data. As shown in FIG. 10, the shipping request data 106h is generated by allocating inventory to the store ordering data 106f using the store master 106c, the product master 106b, and the inventory file 106g.

  The POS sales data 106i is sales data for each store that is aggregated by the store POS system as one of the store attribute information. As shown in FIG. 12 and FIG. 15, the POS sales data 106i records the sales amount for each sales recording date of the store, and by calculating these, the sales amount in units of weeks or months for each store can be calculated. it can.

  The control unit 102 is a CPU or the like that controls the inventory allocation order setting device 100 in an integrated manner. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, and necessary data, and performs various information processing based on these stored programs. Run. Here, the control unit 102 is functionally conceptually (A) store order data capturing unit 102a, (B) an allocation order determination unit 102b as an allocation order determination unit, and (C) inventory allocation as an inventory allocation processing unit. A processing unit 102c, (D) a store attribute information creation processing unit 102d as a store attribute information creation processing unit, (E) a master maintenance unit 102e, and the like. Among these, (a) when there is a shipment request for the same product from the store to the headquarters and inventory allocation is performed in relation to the number of inventory, the store order data fetching unit 102a, the allocation order determining unit 102b, and the inventory allocation processing unit 102c sets the allocation order, performs distribution processing when a fraction occurs, creates shipping request data, and (b) stores inventory rating by the store attribute information creation processing unit 102d when inventory allocation is performed. This is divided into the process of determining the allocation priority by performing the setting, and the following [3. Specific Example of Processing] will be described in detail.

[3. Specific example of processing]
Specific examples of processing according to the present embodiment will be described in detail with reference to FIGS. FIG. 5 is a diagram illustrating an example of processing in a case where inventory allocation is performed equally for all stores based on store ordering data. FIG. 6 is a diagram illustrating an example of processing in a case where only a higher-level store reserves inventory based on store order data. FIG. 7 is a diagram illustrating an example of processing in a case where only a higher-order sales store reserves inventory based on store ordering data. FIG. 9 is a diagram illustrating an example of store master registration and an example of store order data when stock reservation is performed in accordance with the ranking ranking of the store master. FIG. 11 is a diagram illustrating an example of the allocation image and the distribution inventory quantity adjustment in FIG. FIG. 13 is a diagram illustrating an example in which a numerical value is set from the store attribute when the store rating setting is performed. FIG. 14 is a diagram illustrating an example in which a rating ranking is set based on store attributes when store rating setting is performed.

(A) Setting of allocation order and fractional distribution processing when inventory is allocated to a shipping request from a store Here, an outline of processing in the present embodiment will be described. In the present embodiment, for example, when there is a request for shipping the same product from an affiliated store to the headquarters in the retail industry or the like (store ordering data), the inventory is allocated to the stock. The inventory allocation is an operation for confirming the available inventory, and the number of available inventory decreases every time there is a shipment request. When the available inventory quantity becomes “0”, it can no longer be shipped and waits for an order. In addition, when there are requests for shipment of products from a plurality of stores to the headquarters and the number of orders exceeds the number of stocks, it becomes a problem how to distribute the stock products to each store. Until now, the allocation criteria for inventory allocation have been vague, such as uniform distribution on the system or based on the judgment of the headquarters. Therefore, in the present embodiment, some provisioning criteria are patterned and the provisioning criteria can be selected according to the situation.

  First, as shown in FIGS. 1 and 2, the inventory allocation order setting device 100 according to the present embodiment has a store order input from a personal computer or the like as a shipping request for a product from a store or a handy transmission from a handy terminal. Order data from the store is taken into the store order data 106f from the store order data fetching unit 102a via the network 300 and the communication interface unit 104.

[Inventory allocation process]
As shown in FIGS. 3 and 4, the allocation order determination unit 102b of the inventory allocation order setting device 100 determines the allocation order of inventory allocation using the management master 106a and the product master 106b. For example, if the allocation FLG of the merchandise master 106b is set to “0: All stores allocation”, as shown in FIG. 4, all stores that have been ordered are allocated by rounding down evenly, and the fraction refers to the fraction classification. The inventory allocation process for all stores will be specifically described with reference to FIG.

(When all stores are reserved)
If the allocation FLG of the product master 106b is “0: all store allocation”, the allocation order determining unit 102b receives (1) an order request for the product 1 from four stores from A to D as shown in FIG. If the total number of orders in the inventory file 106g is “20” (the ordering request total is “22”), all the stores that have been ordered are allocated by rounding down evenly. In other words, the number of order requests at each store in the example of FIG.
A store 5
B store 3
C store 10
D store 4
Thus, since the total number of order requests is “22” and the inventory quantity is “20”, the inventory is insufficient.

Therefore, since the inventory allocation processing unit 102c allocates inventory equally for all stores, as shown in (2) of FIG. 5, the ratio of the number of order requests at each store to the total order request “22” Is calculated.
Store A 5 ÷ 22 × 100 ≒ 22.7%
Store B 3 ÷ 22 × 100 ≒ 13.6%
Store C 10 ÷ 22 × 100 ≒ 45.5%
Store D 4 ÷ 22 × 100 ≒ 18.2%
And if we reserve the number of stocks “20” evenly by this ratio,
Store A 20 × 22.7 ÷ 100 = 4.54 → 4
Store B 20 × 13.6 ÷ 100 = 2.72 → 2
Store C 20 × 45.5 ÷ 100 = 9.1 → 9
Store D 20 × 18.2 ÷ 100 = 3.64 → 3
Thus, the allocation number is “18” and the fraction is “2”.

Since the handling of the fraction refers to the fraction classification of the product master 106b, as shown in FIG. 4, if “0: leave fraction as inventory” is selected, the fraction “2” is not allocated. And keep it as stock. Further, if the allocation fraction “1: allocation to the upper store” is selected, as shown in (3) of FIG. 5, the upper store in the allocation target store (in this case, the lower store in order from the A store) In order to reserve the fraction, one store is allocated to each of store A and store B,
A store 5
B store 3
C store 9
D store 3
It becomes.

Also, if the allocation fraction “2: allocate fractions in quantity units” is selected, as shown in (4) of FIG. 5, since the fractions are allocated in the order of the desired number in the allocation target store, In the order of C store and A store, the number of requests is large and one is allocated to each store.
A store 5
B store 2
C store 10
D store 3
It becomes.

(In the case of high-order store allocation)
When the allocation FLG of the product master 106b is “1: upper store”, the allocation order determination unit 102b receives (1) an order request for the product 1 from the four stores from A to D as shown in FIG. If the total number of orders in the inventory file 106g is “20” and the desired number “50” of the upper store in the management master 106a in FIG. Reserve for subordinate stores. In other words, in the example of FIG.
A store 5 ranking 5
B store 3 rank 20
C store 10 rank 35
D store 4 rank 60
It becomes A, B, C store, D store does not reserve. For this reason, as shown in (2) of FIG. 6, since the total number of order requests for the stores A, B, and C is “18”, the inventory quantity is “20”. “18” and the remainder is “2”.

On the other hand, when the inventory quantity of the inventory file 106g is “15”, as shown in (3) of FIG. Since it is “15”, the situation is that the inventory is insufficient, and in order to allocate inventory according to the ratio,
Store A 15 × 27.7 ÷ 100 ≒ 4.15 → 4
Store B 15 × 16.7 ÷ 100 ≒ 2.50 → 2
Store C 15 × 55.6 ÷ 100 = 8.34 → 8
Thus, the allocation number is “14” and the fraction is “1”.

  Since the handling of the fraction refers to the fraction classification of the product master 106b, as shown in FIG. 4, if “0: leave fraction as inventory” is selected, the fraction “1” is not allocated. And keep it as stock. If the allocation fraction “1: allocate fraction to higher store” is selected, as shown in (4) of FIG. 6, a fractional amount is assigned to the upper store (store A in this case) in the allocation target store. Therefore, the allocation number of store A changes from “4” to “5”.

  In addition, if “2: allocation of fractions in units of quantity” is selected, as shown in (5) of FIG. 6, since the fractions are allocated in the order of the desired number in the allocation target store, The number of provisions for store C changes from “8” to “9”.

(For sales base amount judgment)
When the allocation FLG of the product master 106b is “2: sales reference amount”, the allocation order determination unit 102b makes an order request to the product 1 from four stores (1) A to D as shown in FIG. If there is (the ordering request total is “22”) and the inventory quantity of the inventory file 106g is “20”, the store exceeding the sales base amount “¥ 500,000” set in the management master 106a of FIG. After setting the desired number, reserve the remaining inventory to the lower stores. That is, the sales of each store in the example of FIG.
Store A 5 Sales ¥ 450,000
Store B 3 Sales ¥ 550,000
Store C 10 Sales ¥ 350,000
Store D 4 Sales ¥ 600,000
It becomes. In this case, the stores A and C, which are stores with sales of ¥ 500,000 or less, do not reserve. For this reason, as shown in (2) of FIG. 7, since the total order quantity of the store B and the store D is “7”, the inventory quantity is “20”, so the inventory is sufficient, and the provision quantity is “7”. ”And the remainder becomes“ 13 ”.

On the other hand, when the inventory quantity of the inventory file 106g is “5”, as shown in (3) of FIG. In order to reserve inventory according to the percentage,
Store B 5 × 42.8 ÷ 100 = 2.14 → 2
Store D 5 × 57.1 ÷ 100 ≒ 2.85 → 2
Thus, the allocation number is “4” and the fraction is “1”.

  Since the handling of the fraction refers to the fraction classification of the product master 106b, as shown in FIG. 4, if “0: leave fraction as inventory” is selected, the fraction “1” is not allocated. And keep it as stock. Also, if the allocation fraction “1: allocate the fraction to the upper store” is selected, as shown in (4) of FIG. 7, the upper store in the allocation target store (here, the D store with a lot of sales). Since the fractional portion is reserved, the allocation number of the D store changes from “2” to “3”.

  Also, if the allocation fraction “2: allocate fractions in quantity units” is selected, as shown in (5) of FIG. 7, fractions are allocated in the order of the desired number in the allocation target store. The number of provisions at store D changes from “2” to “3”.

  As described above, the inventory allocation order setting device 100 according to the present embodiment determines the allocation order by the allocation order determination unit 102b based on the management master 106a and the product master 106b, and then determines the inventory quantity by the inventory allocation processing unit 102c. On the other hand, the number of provisions for each store is determined, and shipping data is generated. The generated shipping data of the product is stored as shipping request data 106h and used at the time of shipping.

  As described above, according to the inventory allocation order setting device 100 according to the present embodiment, when the inventory allocation is performed for the shipping request from the store in (a) above, the allocation order is set and the fraction is allocated. Since the management of the process is performed by the master setting, it is possible to easily select the allocation order and the fractional distribution process according to the situation by referring to the master.

(B) Processing for determining allocation priority at the time of inventory allocation based on store rating setting In (b) above, in performing inventory allocation, allocation processing is performed using the allocation order and fractional allocation processing set by the master, Shipment request data is generated. In (b), a description will be given of what criteria are used to determine the allocation order when setting the master. In this embodiment, various attributes of a store are digitized and set for each store, a store rating rank is calculated, and inventory allocation is performed based on the rating rank.

[Store attribute information creation process]
The store attribute information creation processing unit 102d of the inventory allocation order setting device 100 digitizes various store attribute information, sets the attribute information for each store in the store attribute master 106d, and calculates the store rating. The calculated ranking of stores can be used as an allocation order of inventory allocation. Whether or not to allocate inventory for each product is determined by the allocation unit by the product master 106b in FIG. If the allocation is based on the headquarters side without allocating inventory, “0: allocation is not required (headquarter allocation)”, and “1: store priority” is set when allocating the inventory and setting store priority on the headquarters side. When inventory allocation is performed and store sales order is automatically set in order of sales amount, “2: Store weekly sales ratio” is set, and inventory allocation is performed and store rating rank is set weekly by sales rank master or store master Is “3: Store rating”. In this way, the store master 106c shown in FIG. 8 sets the rank (rank) when inventory allocation is performed for each product in the product master 106b.

  For example, as shown in FIG. 9, the store order data 106f transmitted from a plurality of stores to the headquarters includes order data for products with an order JANCD of “12345678901234” and products with “12345678901235”. Here, the store rating ranks of the four store numbers that ordered the product “12345678901234” surrounded by a broken line are “3: store rating” as the allocation unit of the product master 106b, and the rating rank of the store master 106c is "01" (99 ○○ store (new store)), "02" (98 △△ store (new store)), "50" (01 □□ store (existing store)), "70" (02XX) Stores (existing stores)). Here, when the inventory allocation process is performed for the product “12345678901234” surrounded by the broken line, the inventory allocation processing unit 102c calculates the order quantity of the store order data image and the inventory quantity of the inventory file 106g as shown in FIG. Provisions are made in comparison.

Specifically, as shown in FIG. 11, the total order quantity is “22” with respect to the total inventory quantity “21”, and the order quantity is larger by one. For this reason, the ratio of the order quantity of each store to the total order quantity is calculated, and the value obtained by multiplying the total inventory quantity “21” by the ratio is rounded off.
Number of stocks (21) x (ratio) 22.7% → (calculated stock) 4.767 → (number of stocks allocated) 5
Number of stocks (21) x (ratio) 13.6%-> (calculated stock) 2.856-> (number of stocks allocated) 3
Stock number (21) x (ratio) 45.5% → (calculated stock) 9.555 → (sort stock quantity) 10
Number of stocks (21) x (ratio) 18.2% → (calculated stock) 3.822 → (number of stocks allocated) 4
Since the distribution is the same as the order quantity, the distribution inventory quantity is adjusted from the product of the store with a low store rating (priority order) so as to match the total inventory quantity. Here, since the ranking of “02xx store (existing store)” is the lowest, the distribution stock quantity is changed from 4 to 3 and adjusted.

  As described above, since the rating ranking registered in the store master 106c in FIG. 9 is used as the allocation ranking in performing inventory allocation, an example of a rating ranking setting method will be described below.

(Get sales rank from POS sales data and store in store attribute master)
The store attribute information creation processing unit 102d can rank each store numerically by creating store attribute information, digitizing the store attribute information, and setting the store attribute information for each store. For example, as shown in FIG. 12, the POS sales data 106i is collected using the store POS system, and the ranking according to the sales amount is performed by the sales rank master 106e, whereby the rating of the store can be quantified. . Specifically, when POS sales data with a sales amount of “store 01 □□ store (existing store)” of ¥ 250,000 is collected and collated with the sales rank master 106e, it corresponds to the rank “2”. The store rank is calculated and stored in the store attribute master 106d.

  Further, in another embodiment similar to the above, as shown in FIG. 15, the store attribute information creation processing unit 102d uses the POS sales data 106i as the sales amount of the store XX store and the sales amount of the store XX. The sales total of ¥ 46,000 of the XX store and the sales total of ¥ 28,000 of the XX store are collated with the sales rank master 106e to obtain the sales rank. In the example of FIG. 15, the rank “4” is given for the sales total of ¥ 46,000 for the XX store, and the rank “3” for the sales total of ¥ 28,000 for the XX store. Then, the store attribute information creation processing unit 102d sets the acquired sales rank as the store sales rank in the store attribute master 106d.

(Set attribute information quantified in store master and store in store attribute master)
As shown in FIG. 13, the store attribute information creation processing unit 102d can additionally set arbitrary attribute information for the store master 106c. For example, store area rank, location rank, number of employees rank, floor information rank (floor rank), store manager rank, etc. may be set. The attribute information to be added is arbitrarily digitized and set for each store. Further, the store attribute information creation processing unit 102d not only additionally sets arbitrary attribute information quantified in the store master 106c, but also determines a store rank coefficient according to the scale of the store, for example. The store rating rank may be calculated by multiplying the calculated value. When this store rank coefficient is adopted, stores that are not reserved can be easily set by setting the coefficient to “0”. In this way, arbitrarily added attribute information that has been digitized is additionally set to the store attribute master.

  In another embodiment similar to the above, as shown in FIG. 16, arbitrary attribute information quantified is additionally set in the store master 106c. Specifically, area rank (attribute 1), location rank (attribute 2), number of employees rank (attribute 3), store manager rank (attribute 4), and floor rank for XX store and XX store of store master 106c. Attribute information such as (Attribute 5) is additionally set. Then, the store attribute information creation processing unit 102d resets the store-specific attribute information additionally set in the store master 106c to the store attribute master 106d. Thereby, the store attribute master 106d can add rank information of the attributes 1 to 5 in addition to the stored store sales rank.

(Set the rating rank of the store master according to the attribute information set in the store attribute master)
The store attribute information creation processing unit 102d can calculate the store rating rank by calculating the rank set in the store attribute master 106d shown in FIG. 13 for each store. As shown in FIG. 14, this calculation result is set as the ranking of each store in the store master 106c. In this rating rank calculation process, information content is regularly updated by scheduling, so that the latest rating rank is always registered. For example, as shown in FIG. 14, the store attribute information creation processing unit 102d updates the order of sales of the store attribute information once a week, thereby updating the ranking of the store master 106c every week. it can. The inventory allocation processing unit 102c can perform the inventory allocation process using the store ordering data 106f and the ranking of the store master 106c, and can create the shipping request data 106h.

In another example similar to the above, as shown in FIG. 17, the store sales rank and the ranks of the attributes 1 to 5 are set for each store for the store attribute master 106d. A scale-specific coefficient (for example, “1.2” for XX stores and “1.5” for XX stores) that sets a rank coefficient for each store size is set. The store attribute information creation processing unit 102d can calculate a store rating by calculating a numerical value set in the store attribute master 106d for each store. For example, as shown in FIG.
○○ Store ... (4 + 2 + 1 + 3 + 4 + 5) × 1.2 = 22.8
XX store ... (3 + 3 + 1 + 5 + 2 + 1) * 1.5 = 22.5
Therefore, when allocating inventory of the same product, priority is given to XX stores having a large store rating value.

  As described above, according to the inventory allocation order setting device 100 according to the present embodiment, when setting the inventory allocation order of a product for which a shipment request has been made, arbitrary store attribute information By using, more detailed and objective store rating setting has become possible. For example, in the case where the allocation unit of the product master 106b is set as a store rating and the store rating rank is set, the attribute can be freely set by setting the store master 106c into a numerical value of arbitrary store attribute information. Store ratings can be set by combining information.

[4. Other Embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

  For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed can be performed manually, or all of the processes described as being performed manually are all performed. Alternatively, a part can be automatically performed by a known method.

  In addition, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and database configurations shown in the present specification and drawings, unless otherwise specified. Can be changed arbitrarily.

  Further, regarding the inventory allocation order setting device 100, each illustrated component is functionally conceptual and does not necessarily need to be physically configured as illustrated.

  For example, all or some of the processing functions provided in the inventory allocation order setting device 100, particularly the processing functions performed by the control unit 102, are realized by the CPU and a program interpreted and executed by the CPU. Alternatively, it may be realized as hardware by wired logic. The program is recorded on a non-transitory computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the processing described in this embodiment, and the inventory allocation order is set as necessary. It is mechanically read by the setting device 100. In other words, in a storage unit such as a ROM or a HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU.

  The computer program may be stored in an application program server connected to the inventory allocation order setting device 100 via an arbitrary network, and may be downloaded in whole or in part as necessary. Is possible.

  In addition, a program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the “recording medium” refers to a memory card, USB (Universal Serial Bus) memory, SD (Secure Digital) card, flexible disk, magneto-optical disk, ROM, EPROM (Erasable Programmable Read Only Memory), EEPROM (registration). Trademark) (Electrically Erasable and Program BSE Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), and DVD (Digit Digital Disc) Any “portable physical media It is intended to include.

  The “program” is a data processing method described in an arbitrary language or description method, and may be in any form such as source code or binary code. Note that the “program” is not necessarily limited to a single configuration, and functions are achieved in cooperation with a separate configuration such as a plurality of modules and libraries or a separate program represented by the OS. Including things. In addition, a well-known structure and procedure can be used about the specific structure and reading procedure for reading a recording medium in each apparatus shown to embodiment, the installation procedure after reading, etc.

  Various databases and the like stored in the storage unit 106 are storage devices such as a memory device such as a RAM and a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk. Programs, tables, databases, web page files, and the like.

  The inventory allocation order setting device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the inventory allocation order setting device 100 may be realized by installing software (including a program or data) that realizes the processing described in the present embodiment in the information processing device.

  Furthermore, the specific form of the distribution / integration of the devices is not limited to that shown in the drawings, and all or a part thereof may be functionally or physically in arbitrary units according to various additions or according to function additions. It can be configured to be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and may be selectively implemented.

  The present invention is particularly useful in fields such as the retail industry.

DESCRIPTION OF SYMBOLS 100 Inventory allocation order setting apparatus 102 Control part 102a Store order data taking-in part 102b Allocation order determination part 102c Inventory allocation process part 102d Store attribute information creation process part 102e Master maintenance part 104 Communication interface part 106 Storage part 106a Management master 106b Product master 106c Store master 106d Store attribute master 106e Sales rank master 106f Store order data 106g Stock file 106h Shipment request data 106i POS sales data 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (4)

An inventory allocation order setting device that includes a control unit and a storage unit, and sets an allocation order of inventory for store order data of products from a store,
In the storage unit,
A first master for setting an allocation unit for each product for the store for which the allocation order is set;
The controller is
An allocation order determination means for determining an allocation order of the product based on an allocation unit for the target store set in the first master;
Inventory allocation processing means for generating inventory request processing by performing inventory allocation processing based on the determined allocation order and the inventory of the product;
Providing
An inventory allocation order setting device. The first master is
A management master for managing the conditions of the target store to be set for the allocation order;
A product master that determines a provision unit for each product for the target store set in the management master;
Including
Based on the target store set in the management master by the allocation order determining means and the allocation unit for each product in the product master, the allocation order of the product of each store is determined, and the inventory allocation based on the allocation order Performing shipping allocation processing by processing means to generate shipping request data;
The inventory allocation order setting device according to claim 1. An inventory allocation order setting method executed by an inventory allocation order setting device that includes a control unit and a storage unit, and sets an allocation order of inventory for store order data of products from a store,
In the storage unit,
A first master for setting an allocation unit for each product for the store for which the allocation order is set;
Executed by the control unit,
An allocation order determination step for determining an allocation order of the product based on an allocation unit for the target store set in the first master;
An inventory allocation processing step for generating shipping request data by performing an inventory allocation process based on the determined allocation order and the inventory of the product;
Including,
An inventory allocation order setting method characterized by the above. An inventory allocation order setting program for executing by an inventory allocation order setting device that includes a control unit and a storage unit, and sets an inventory allocation order for store order data of products from a store,
In the storage unit,
A first master for setting an allocation unit for each product for the store for which the allocation order is set;
For execution by the control unit,
An allocation order determination step for determining an allocation order of the product based on an allocation unit for the target store set in the first master;
An inventory allocation processing step for generating shipping request data by performing an inventory allocation process based on the determined allocation order and the inventory of the product;
Including,
An inventory allocation order setting program characterized by

Images