JP6974949B2 - Inventory allocation order setting device, inventory allocation order setting method, and inventory allocation order setting program - Google Patents

Description

The present invention relates to a store rating setting device, a store rating setting method, and a store rating setting program.

A method of registering inventory information, sales budget, and sales plan for each model, customer, and sales office for each warehouse in claim 1 and the like of Patent Document 1, and automatically updating the inventory allocation limit based on the sales plan forecast. In particular, claim 11 and the like describe that the priority allocation frame calculation is performed based on the ranking of client companies (see, for example, paragraphs 0017 and 0029).

Japanese Unexamined Patent Publication No. 2003-099507

As described above, in Patent Document 1, the inventory allocation quota is automatically updated based on the inventory information and the sales plan forecast, and the priority allocation quota calculation is performed based on the ranking of the client company. However, the inventory allocation is performed. It was difficult to perform a more detailed and objective store rating, such as combining store attribute information as a rating setting element for store priorities.

The present invention has been made in view of the above problems, and is more detailed and objective by using the store attribute information for the rating setting of the priority of the store as the inventory allocation order of the products for which the shipping request has been requested. It is an object of the present invention to provide a store rating setting device, a store rating setting method, and a store rating setting program that enable various store rating settings.

In order to solve the above-mentioned problems and achieve the object, the store rating setting device according to the present invention is provided with a storage unit and a control unit, and is used for stock allocation for store order data of products from stores. It is a store rating setting device that sets a rating order, and in the storage unit, an attribute information storage table that stores attribute information of the store and a rating that quantifies the rating of the store based on the attribute information storage table. A master, a store master that holds quantified attribute information for each store, and a store attribute master that outputs a store rating result based on a numerical value that combines the attribute information of the store master are stored. The control unit collects the attribute information of each store from the attribute information storage table, quantifies it in the rating master, stores the quantified attribute information of each store in the store master, and combines the attribute information of the store master. It is characterized in that it is provided with a store attribute information creation processing means for calculating a store rating result based on numerical values, and the calculated store rating result is used as a store rating ranking for inventory allocation.

Further, in the store rating setting device according to the present invention, the attribute information includes the store sales rank, the store area rank, the store location rank, the store employee number rank, the store manager rank, and the store floor rank. It is characterized by containing at least one.

Further, in the store rating setting device according to the present invention, the attribute information storage table stores POS sales data for each store aggregated by the POS system of the store when the attribute information is the sales rank of the store. The rating master is a sales rank master that quantifies the rating of the store based on the POS sales data.

Further, the store rating setting method according to the present invention is executed by a store rating setting device that includes a storage unit and a control unit and sets a rating order of a store that allocates inventory to store order data of products from the store. In the store rating setting method, the storage unit includes an attribute information storage table that stores attribute information of the store, a rating master that quantifies the rating of the store based on the attribute information storage table, and numerical values. A store master that holds the attribute information for each store that has been converted and a store attribute master that outputs the store rating result based on a numerical value that combines the attribute information of the store master are stored and executed by the control unit. The attribute information of each store is collected from the attribute information storage table, quantified by the rating master, the quantified attribute information of each store is stored in the store master, and the combination of the attribute information of the store master is used. It is characterized by including a store attribute information creation processing step for calculating a store rating result based on a numerical value, and using the calculated store rating result as a store rating order for inventory allocation.

Further, the store rating setting program according to the present invention is executed by a store rating setting device having a storage unit and a control unit and setting a rating order of a store that allocates inventory to store order data of products from the store. A store rating setting program for this purpose, in which the storage unit includes an attribute information storage table that stores attribute information of the store, a rating master that quantifies the rating of the store based on the attribute information storage table, and a rating master. A store master that holds digitized attribute information for each store and a store attribute master that outputs a store rating result based on a numerical value that combines the attribute information of the store master are stored, and the control unit stores the store. The attribute information of each store is collected from the attribute information storage table for execution, quantified by the rating master, and the quantified attribute information of each store is stored in the store master, and the attribute information of the store master is stored. It is characterized by including a store attribute information creation processing step for calculating a store rating result based on a numerical value by a combination, and using the calculated store rating result as a store rating ranking for inventory allocation.

According to the present invention, it is possible to set a more detailed and objective store rating by using the store attribute information for setting the priority rating of the store as the inventory allocation order of the products for which the shipment is requested. Play.

FIG. 1 is a block diagram showing an example of the configuration of the inventory allocation order setting device. FIG. 2 is a flow chart illustrating a flow from inventory allocation to creation of shipping request data based on store order data of products. FIG. 3 is a diagram showing a setting example of a management master that manages higher-level stores. FIG. 4 is a diagram showing an example of setting one of the product masters for determining the allocation unit for each product. FIG. 5 is a diagram showing an example of processing in the case of evenly allocating inventory to all stores based on store order data. FIG. 6 is a diagram showing an example of processing in the case where inventory allocation is performed only for higher-ranking stores based on store order data. FIG. 7 is a diagram showing an example of processing in the case where inventory allocation is performed only for the top sales stores based on the store order data. FIG. 8 is a diagram showing a setting example of a product master and a store master that determines the presence / absence of inventory allocation for each product and the unit of allocation. FIG. 9 is a diagram showing an example of store master registration and an example of a store order data image in the case of inventory allocation according to the rating order of the store master. FIG. 10 is a diagram showing an example of comparing the store order data image of FIG. 9 with the inventory file and making an allocation. FIG. 11 is a diagram showing an example of adjustment of the allocation image and the distribution inventory number in FIG. FIG. 12 is a diagram showing an example of calculating a rank from a sales amount when setting a store rating. FIG. 13 is a diagram showing an example of setting a numerical value from a store attribute when setting a store rating. FIG. 14 is a diagram showing an example of setting a rating order from a store attribute when setting a store rating. FIG. 15 is a diagram showing a specific example of acquiring a sales rank from a store sales amount and performing a store rating. FIG. 16 is a diagram showing a specific example of acquiring store attribute information from the store master and performing store rating. FIG. 17 is a diagram showing a specific example of calculating a store rating by setting a coefficient for each store size by input.

Hereinafter, embodiments of the store rating setting device, the store rating setting method, and the store rating setting program according to the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment.

[1. Overview]
In the retail industry, etc., as inventory allocation when the headquarters receives requests to ship the same product from multiple stores, for example, the allocation order is determined by the ranking of sales results of the previous week, etc. When deciding the allocation order based on other store attribute information, it was necessary for the headquarters to check and make adjustments at any time.

Therefore, in the present embodiment, it is possible to set a general-purpose rating of the priority of stores, such as the order of inventory allocation of the same products by store. For example, by arbitrarily combining general-purpose store attribute information such as store sales, store personnel, store location, and store area, and quantifying the rating of each store, inventory control on the headquarters side can be performed in more detail. .. In this way, by combining the store attribute information, the store rating is set, and the inventory allocation order setting device, the inventory allocation order setting method, and the inventory allocation order setting program capable of performing inventory allocation processing according to the order are provided. There is. Hereinafter, a specific configuration and operation will be described.

[2. composition]
The configuration of the inventory allocation order setting device 100 according to the present embodiment including the present invention will be described with reference to FIG. FIG. 1 is a block diagram showing 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 Assistants), smartphone, tablet personal computer, or the like. It may be a portable information processing device.

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 part of the inventory allocation order setting device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the inventory allocation order setting device 100 to the network 300 so as to be communicable 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 another device 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 as to be communicable with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like. The data stored in the storage unit 106, which will 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 or a printer can be used in addition to a monitor (including a home television). As the input device 112, a keyboard, a mouse, and a microphone, as well as a monitor that cooperates with the mouse to realize a pointing device function can be used. In the following, the output device 114 may be referred to as a monitor 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112.

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving an instruction to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) / ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like 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. It also includes 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 may be any rating master that quantifies the rating of the store based on the attribute information of the store, and is not necessarily limited to the sales rank. Further, the POS sales data 106i may be any table as long as it stores the attribute information of the store, 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. 1, but the store order data and the inventory information are taken in each time and the inventory allocation process is performed. Or you may directly output the shipping request data generated by performing inventory allocation processing.

Each item including the above-mentioned five masters and the above-mentioned four data (files) stored in the storage unit 106 is mainly described in FIGS. 2, 3, 4, 4, 8, 10, 12, and 15. , 16 and 17 will be described in detail. FIG. 2 is a flow chart illustrating a flow from inventory allocation to creation of shipping request data based on store order data of products. FIG. 3 is a diagram showing a setting example of a management master that manages higher-level stores. FIG. 4 is a diagram showing an example of setting one of the product masters for determining the allocation unit for each product. Further, FIG. 8 is a diagram showing an example of setting one of the product master and the store master, which determines the presence / absence of inventory allocation for each product and the unit of allocation. FIG. 10 is a diagram showing an example of comparing the store order data image of FIG. 9 with the inventory file and making an allocation. FIG. 12 is a diagram showing an example of calculating a rank from a sales amount when setting a store rating. FIG. 15 is a diagram showing a specific example of acquiring a sales rank from a store sales amount and performing a store rating. FIG. 16 is a diagram showing a specific example of acquiring store attribute information from the store master and performing store rating. FIG. 17 is a diagram showing a specific example of calculating a store rating by setting a coefficient for each store size by input.

The management master 106a is a master that manages the conditions of the target stores for which the inventory allocation order is set. As shown in FIGS. 2 and 3, the management master 106a enables arbitrary setting of the allocation order when inventory allocation is performed based on the store order data. For example, as shown in FIG. 3, the condition of the target store for which the allocation order is set is defined as "high-ranking store" or "sales standard amount" or more. The "upper store" is to set the store treated as "upper" in various forms and analysis among the managed stores in the management master 106a, and here, the upper 50 stores are targeted. In addition, the "sales standard amount" is a standard amount that treats stores with sales of a set amount or more as "higher rank", treats them as excellent sales stores, and manages allocation priority management. Here, the set amount is set to 500,000 yen, and the stores whose monthly sales exceed this amount are managed.

The product master 106b is a master that determines the allocation unit for each product for the store to be managed set in the management master 106a. As shown in FIGS. 2 and 4, in the case of the “allocation FLG” that allocates inventory, the product master 106b allocates all the stores that have placed an order by rounding down evenly, and the fraction refers to the fraction classification. "0: All store allocation" and "1: Upper store" that allocates the remaining stock quantity to the lower store after setting the desired number of the upper store of the management master 106a, and monthly sales (monthly amount to the store master 106c described later) (Holding sales), but after setting the desired number of stores that exceed this standard amount, you can select "2: Sales standard amount" to be allocated to lower stores. Further, as shown in FIGS. 2 and 4, in the case of the “allocated fraction” for which the fraction processing is performed, the product master 106b leaves the fraction as inventory “0: leaves the fraction as inventory”, which is higher in the allocation target store. You can select "1: Allocate fractions to higher-ranking stores" that allocates fractions to stores, and "2: Allocate fractions by quantity" that allocates fractions in descending order of desired number in the stores to be allocated. ..

Further, as shown in FIGS. 2 and 8, when “3: store rating” for quantifying the store rating setting is selected as the master for determining the allocation unit for each product, the product master 106b is used as the attribute information of the store. Based on this, the store's rating is quantified and the rating ranking is set. As shown in FIG. 8, this rating rank is set from the sales rank master and the store master registered in the store master 106c on a weekly basis. Further, as shown in FIGS. 2 and 8, the product master 106b is considered by the headquarters side as "0: No allocation required (headquarters allocation)", which makes the allocation unnecessary by the headquarters allocation as a master for determining the allocation unit for each product. You can select "1: Store priority", which is prioritized by maintenance, and "2: Sales ratio of the previous week of the store", which automatically sets the sales order according to the sales ratio of the previous week (in order of sales amount). ..

The store master 106c is a master that holds digitized attribute information for each store. It is possible to additionally set arbitrary attribute information. As an example of setting attribute information, as shown in FIG. 16, an example includes a store sales rank, a store area rank, a store location rank, a store employee number rank, a store manager rank, and a store floor rank. Can be listed as, but is not necessarily limited to this. In addition to calculating the store rating ranking based on the total sum of the ranked attribute information, a rank coefficient is set for each store, and the calculated sum of the attribute information is multiplied by the rank coefficient to calculate the store rating ranking. May be calculated. Further, the attribute information may be used alone or in combination as appropriate to quantify the rating of the store.

The store attribute master 106d is a master that outputs a store rating result based on a numerical value 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 106d can calculate the store rating as a numerical value by setting the quantified attribute information for each store. In addition, as shown in FIG. 17, in the calculation of the store rating, not only the quantified attribute information of the store is added, but also the coefficient other than the attribute information (here, the coefficient by scale) is added to the headquarters side as necessary. The store rating may be calculated by multiplying the sum of the attribute information for each store by a coefficient. As a result, the headquarters can control so that different store rating results can be obtained.

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

The store order data 106f is order data for ordering products from the store to the headquarters. The store order data 106f is stored by inputting the order data from the store using a terminal such as a personal computer, and by the store employee handy transmitting the order data from the handy terminal and inputting the store order data by handy import. ..

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

The shipping request data 106h compares the number of ordered products based on the store order data 106f with the number of stocks based on the inventory file 106g, allocates inventory, and distributes and ships the stocked products to each store. Generate and store data. As for the shipping request data 106h, as shown in FIG. 10, the shipping request data 106h is generated by allocating inventory to the store order 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 aggregated by the POS system of the store as one of the attribute information of the store. As shown in FIGS. 12 and 15, the POS sales data 106i records the sales amount for each store sales recording date, and by aggregating these, the weekly or monthly sales amount for each store can be calculated. can.

The control unit 102 is a CPU or the like that collectively controls the inventory allocation order setting device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run. Here, the control unit 102 functionally conceptually includes (A) a store order data acquisition unit 102a, (B) an allocation order determination unit 102b as an allocation order determination means, and (C) an inventory allocation as an inventory allocation processing means. It includes a processing unit 102c, (D) a store attribute information creation processing unit 102d as a store attribute information creation processing means, (E) a master maintenance unit 102e, and the like. Of these, (a) when the store requests the headquarters to ship the same product and inventory allocation is performed in relation to the number of inventories, the store order data acquisition unit 102a, the allocation order determination unit 102b, and the inventory allocation processing unit According to 102c, the store rating is set by the store attribute information creation processing unit 102d when the allocation order is set, the distribution process is performed when a fraction is generated to create the shipping request data, and (b) the inventory allocation is performed. It is divided into the process of determining the allocation priority by setting, and the following [3. Specific examples of processing] will be described in detail.

[3. Specific example of processing]
Specific examples of the processing according to the present embodiment will be described in detail with reference to FIGS. 2 to 17. FIG. 5 is a diagram showing an example of processing in the case of evenly allocating inventory to all stores based on store order data. FIG. 6 is a diagram showing an example of processing in the case where inventory allocation is performed only for higher-ranking stores based on store order data. FIG. 7 is a diagram showing an example of processing in the case where inventory allocation is performed only for the top sales stores based on the store order data. FIG. 9 is a diagram showing an example of store master registration and an example of a store order data image in the case of inventory allocation according to the rating order of the store master. FIG. 11 is a diagram showing an example of adjustment of the allocation image and the distribution inventory number in FIG. FIG. 13 is a diagram showing an example of setting a numerical value from a store attribute when setting a store rating. FIG. 14 is a diagram showing an example of setting a rating order from a store attribute when setting a store rating.

(B) Setting of allocation order and fractional distribution processing in the case of inventory allocation in response 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, in the retail industry or the like, when there is a shipping request (store order data) for the same product from an affiliated store to the headquarters, inventory allocation is performed for inventory. Inventory allocation is a work of confirming the available inventory, and each time there is a shipping request, the number of available inventory decreases, and when the number of available inventory becomes "0", no more shipments can be made, and an order is awaited. In addition, when a plurality of stores request the headquarters to ship products and the number of orders exceeds the number of stocks, how to distribute the stock products to each store becomes a problem. Until now, the allocation criteria for inventory allocation have been ambiguous, such as uniform distribution on the system or distribution at the discretion of the headquarters. Therefore, in the present embodiment, some allocation criteria are patterned so that the allocation 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 receives a store order input from a personal computer or the like and a handy transmission from a handy terminal as a product shipping request from the store. The order data from the store is taken into the store order data 106f from the store order data acquisition unit 102a via the network 300 and the communication interface unit 104.

[Inventory allocation processing]
As shown in FIGS. 3 and 4, the inventory allocation order determination unit 102b of the inventory allocation order setting device 100 determines the inventory allocation order by using the management master 106a and the product master 106b. For example, if the allocation FLG of the product master 106b is set to "0: allocation for all stores", as shown in FIG. 4, all stores for which an order has been placed are evenly rounded down, and the fractions refer to the fraction classification. The inventory allocation process for all-store allocation will be specifically described with reference to FIG.

(In the case of all-store allocation)
Assuming that the allocation FLG of the product master 106b is "0: all-store allocation", the allocation order determination unit 102b makes an order request to the product 1 from (1) four stores A to D, as shown in FIG. If there is (the total order request is "22") and the inventory quantity of the inventory file 106g is "20", all the stores that have ordered are evenly rounded down. That is, the number of order requests for each store in the example of FIG. 5 is
A store 5
B store 3
C store 10
D store 4
Since the total number of order requests is "22" and the number of inventories is "20", the inventory is insufficient.

Therefore, in order to evenly allocate inventory to all stores, the inventory allocation processing unit 102c allocates inventory evenly to all stores. Therefore, as shown in FIG. 5 (2), the ratio of the number of order requests of each store to the total order request "22". Is calculated.
Store A 5 ÷ 22 × 100 ≒ 22.7%
B store 3 ÷ 22 × 100 ≒ 13.6%
C store 10 ÷ 22 × 100 ≒ 45.5%
D store 4 ÷ 22 × 100 ≒ 18.2%
Then, if the inventory quantity "20" is evenly rounded down at this ratio,
Store A 20 x 22.7 ÷ 100 = 4.54 → 4
Store B 20 x 13.6 ÷ 100 = 2.72 → 2
C store 20 x 45.5 ÷ 100 = 9.1 → 9
D store 20 × 18.2 ÷ 100 = 3.64 → 3
The number of allocations is "18" and the fraction is "2".

Since the handling of fractions refers to the fraction classification of the product master 106b, as shown in FIG. 4, if "0: Keep fractions as inventory" is selected, the fraction "2" is not allocated. In addition, keep it in stock. If "1: Allocate the fraction to the upper store" is selected, as shown in FIG. 5 (3), the upper store in the store to be allocated (here, the lower store is in order from the A store). In order to allocate fractions to (become), one is allocated to each store A and one to B.
A store 5
B store 3
C store 9
D store 3
Will be.

Further, if "2: Allocate fractions by quantity" is selected as the allocation fraction, as shown in FIG. 5 (4), the fractions are allocated in descending order of the desired number in the allocation target stores. The number of requests is large in the order of C store and A store, and one is allocated to each store.
A store 5
B store 2
C store 10
D store 3
Will be.

(In the case of high-ranking store allocation)
Assuming that the allocation FLG of the product master 106b is "1: upper store", the allocation order determination unit 102b makes an order request to the product 1 from (1) four stores A to D, as shown in FIG. If there is (the total order request is "22") and the inventory quantity of the inventory file 106g is "20", set the desired quantity "50" of the upper store of the management master 106a in FIG. Allocate to lower stores. That is, in the example of FIG. 6, the top 50 or higher stores are
A store 5 ranking 5
B store 3 rank 20
C store 10 rank 35
D store 4 rank 60
Stores A, B, and C, and store D does not make any allocation. Therefore, as shown in (2) of FIG. 6, the total number of order requests for stores A, B, and C is "18" and the number of inventories is "20". At "18", the remainder is "2".

On the other hand, when the inventory quantity of the inventory file 106 g is "15", as shown in (3) of FIG. 6, the inventory quantity is "18" for the total order request of the A, B, and C stores. Since it is "15", the inventory is insufficient, and inventory is allocated according to the ratio.
Store A 15 × 27.7 ÷ 100 ≒ 4.15 → 4
Store B 15 × 16.7 ÷ 100 ≒ 2.50 → 2
C store 15 x 55.6 ÷ 100 = 8.34 → 8
The number of allocations is "14" and the fraction is "1".

Since the handling of fractions refers to the fraction classification of the product master 106b, as shown in FIG. 4, if "0: Keep fractions as inventory" is selected, the fraction "1" is not allocated. In addition, keep it in stock. If "1: Allocate fractions to higher-ranking stores" is selected, as shown in (4) of FIG. 6, the higher-ranking stores (here, A store) in the allocation target stores are divided into fractions. The number of allocations for store A changes from "4" to "5".

Further, if "2: Allocate fractions by quantity" is selected as the allocation fraction, as shown in FIG. 6 (5), the fractions are allocated in descending order of the desired number in the allocation target stores. The number of reserves for store C changes from "8" to "9".

(In the case of sales standard judgment)
Assuming that the allocation FLG of the product master 106b is "2: sales standard amount", the allocation order determination unit 102b requests the product 1 from (1) four stores A to D as shown in FIG. If there is (the total order request is "22") and the inventory quantity of the inventory file 106g is "20", the store exceeds the sales standard amount "¥ 500,000" set in the management master 106a in FIG. After setting the desired number of items, the excess inventory amount is allocated to the lower stores. That is, the sales of each store in the example of FIG. 7 are
Store A 5 Sales ¥ 450,000
Store B 3 Sales ¥ 550,000
C store 10 Sales ¥ 350,000
D store 4 Sales ¥ 600,000
Will be. In this case, stores A and C, whose sales are 500,000 yen or less, are not allocated. Therefore, as shown in (2) of FIG. 7, since the total number of order requests for stores B and D is "7" and the number of inventories is "20", the inventory is sufficient and the number of allocations is "7". , The remainder is "13".

On the other hand, when the inventory quantity of the inventory file 106 g is "5", as shown in (3) of FIG. 7, the total number of order requests of the B store and the D store is "7" and the inventory quantity is "7". Since it is "5", the inventory will be insufficient, and inventory will be allocated according to the ratio.
B store 5 × 42.8 ÷ 100 = 2.14 → 2
D store 5 × 57.1 ÷ 100 ≒ 2.85 → 2
The number of allocations is "4" and the fraction is "1".

Since the handling of fractions refers to the fraction classification of the product master 106b, as shown in FIG. 4, if "0: Keep fractions as inventory" is selected, the fraction "1" is not allocated. In addition, keep it in stock. If "1: Allocate fractions to higher-ranking stores" is selected, the higher-ranking stores in the allocation target stores (here, D stores with high sales) as shown in FIG. 7 (4). The number of allocations for store D changes from "2" to "3" in order to allocate fractions to.

Further, if "2: Allocate fractions by quantity" is selected as the allocation fraction, as shown in FIG. 7 (5), the fractions are allocated in descending order of the desired number in the allocation target stores. The number of reserves for store D changes from "2" to "3".

As described above, in the inventory allocation order setting device 100 according to the present embodiment, after the allocation order is determined by the allocation order determination unit 102b based on the management master 106a and the product master 106b, the inventory allocation processing unit 102c determines the inventory quantity. On the other hand, the number of allocations for each store is determined and shipping data is generated. The generated product shipping data 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 inventory allocation is performed for the shipping request from the store in (a) above, the allocation order is set and the fractions are distributed. Since the processing is managed by the master setting, it is possible to easily select the allocation order and the distribution processing of fractions according to the situation by referring to the master.

(B) Processing to determine the allocation priority at the time of inventory allocation by setting the store rating In (a) above, when performing inventory allocation, allocation processing is performed using the allocation order set in the master and fractional distribution processing. Generating shipping request data. In this (b), when the master is set, the criteria for determining the allocation order will be described. In the present embodiment, various attributes of stores are quantified and set for each store, a store rating order is calculated, and inventory allocation is performed based on the rating order.

[Store attribute information creation process]
The store attribute information creation processing unit 102d of the inventory allocation order setting device 100 quantifies various attribute information of the store, sets the attribute information for each store in the store attribute master 106d, and calculates the store rating. This calculated store rating order can be used as an inventory allocation order. Whether or not to allocate inventory for each product is determined by the allocation unit according to the product master 106b in FIG. "0: No allocation required (headquarters allocation)" when the allocation is made by the headquarters without inventory allocation, and "1: Store priority" when the inventory is allocated and the store priority is set by the headquarters. When inventory allocation is performed and the store sales ranking is automatically set in order of sales amount, set as "2: Store previous week sales ratio". When inventory allocation is performed and the store rating ranking is set on a weekly basis from the sales rank master or store master. Is "3: store rating". As described above, the store master 106c shown in FIG. 8 sets the order (rank) when inventory is allocated 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 a product whose order JANCD is "12345678901234" and a product whose order JANCD is "12345678901235". Here, in the store rating ranking of the four store numbers that ordered the product of "12345678901234" surrounded by a broken line, the allocation unit of the product master 106b is "3: store rating", and the rating ranking of the store master 106c is. In descending order, "01" (99 ○○ store (new store)), "02" (98 △△ store (new store)), "50" (01 □□ store (existing store)), "70" (02XX) Stores (existing stores)) are registered in this order. Here, when inventory allocation processing is performed for the product of "12345678901234" surrounded by a broken line, the inventory allocation processing unit 102c sets the number of orders in the store order data image and the inventory quantity of the inventory file 106g as shown in FIG. Allocation is made in comparison.

Specifically, as shown in FIG. 11, the total inventory quantity is "21" and the total order quantity is "22", which means that the order quantity is large by one. Therefore, the ratio of the order quantity of each store to the total order quantity is calculated, and the value obtained by multiplying this by the ratio to the total inventory quantity "21" is rounded off.
Stock quantity (21) x (ratio) 22.7% → (calculated stock) 4.767 → (distribution stock quantity) 5
Stock quantity (21) x (ratio) 13.6% → (calculated stock) 2.856 → (distribution stock quantity) 3
Stock quantity (21) x (ratio) 45.5% → (calculated stock) 9.555 → (distribution stock quantity) 10
Stock quantity (21) x (ratio) 18.2% → (calculated stock) 3.822 → (distribution stock quantity) 4
Since the distribution is the same as the order quantity, the distribution inventory quantity is adjusted from the products of the stores with the lower store rating (priority) so as to match the total inventory quantity. Here, since the ranking of "02XX store (existing store)" is the lowest, the number of distribution stocks here is changed from 4 to 3 for adjustment.

As described above, since the rating order registered in the store master 106c of FIG. 9 is used for the allocation order when the inventory is allocated, an example of the method for setting the rating order will be described below.

(Obtain the sales rank from the POS sales data and store it in the store attribute master)
The store attribute information creation processing unit 102d can create store attribute information, quantify the store attribute information, and set each store individually, thereby rating each store numerically. For example, as shown in FIG. 12, the store rating can be quantified by collecting the POS sales data 106i using the store POS system and ranking according to the sales amount by the sales rank master 106e. .. Specifically, if you collect POS sales data that the sales amount of "Store 01 □□ store (existing store)" is 250,000 yen and collate it with the sales rank master 106e, it corresponds to 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 XX store and the sales amount of the XX store. And are collected and totaled, and the total sales of XX stores of ¥ 46,000 and the total sales of XX stores of ¥ 28,000 are collated with the sales rank master 106e to obtain the sales rank. In the example of FIG. 15, the total sales of the XX store is ¥ 46,000 and the rank is “4”, and the total sales of the XX store is ¥ 28,000 and the rank is “3”. 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 the digitized attribute information in the store master and store it in the 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, in addition to the area rank, location rank, number of employees rank, floor information rank (floor rank) of the store, the store manager rank and the like may be set. The attribute information to be added is arbitrarily quantified and set for each store. Further, the store attribute information creation processing unit 102d not only additionally sets arbitrary attribute information digitized in the store master 106c, but also determines, for example, a store rank coefficient according to the scale of the store, and sets this store rank coefficient. The store rating may be calculated by multiplying the calculated value. When this store rank coefficient is adopted, it is possible to easily set a store that is not allocated by setting the coefficient to "0". In this way, the arbitrarily added quantified attribute information is additionally set for the above-mentioned store attribute master.

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

(The rating order of the store master is set by 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 rating order of each store in the store master 106c. In this rating ranking calculation process, the information content is updated regularly by scheduling it so that the latest rating ranking is always registered. For example, as shown in FIG. 14, the store attribute information creation processing unit 102d may update the rating order of the store master 106c every week by updating the sales order of the store attribute information once a week. can. The inventory allocation processing unit 102c can perform inventory allocation processing using the store order data 106f and the rating order of the store master 106c to create the shipping request data 106h.

Further, in another embodiment similar to the above, as shown in FIG. 17, the store sales rank and the ranks of attributes 1 to 5 are set for each store in the store attribute master 106d, and here, the ranks of attributes 1 to 5 are set for each store. A scale-specific coefficient (for example, "1.2" for XX stores and "1.5" for XX stores) is set, which defines the rank coefficient for each store size. The store attribute information creation processing unit 102d can calculate the store rating by calculating the 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) x 1.5 = 22.5
Therefore, when allocating inventory for the same product, priority should be given to the XX store with the larger store rating.

As described above, according to the inventory allocation order setting device 100 according to the present embodiment, when setting the inventory allocation order of the product for which the shipping request has been made, any store attribute information can be set in the rating setting of the priority of the store. By using, it became possible to set a more detailed and objective store rating. For example, when the allocation unit of the product master 106b is a store rating and the store rating ranking is set, the attributes can be freely set by setting a numerical value of arbitrary attribute information of the store for the store master 106c. It becomes possible to set the store rating 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 ideas described in the claims.

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

In addition, 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 this specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the inventory allocation order setting device 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

For example, with respect to the processing functions included in the inventory allocation order setting device 100, particularly each processing function performed by the control unit 102, all or any part thereof is realized by the CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the process described in the present embodiment, and the inventory allocation order is required. It is read mechanically by the setting device 100. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with the CPU to form a control unit.

Further, this computer program may be stored in an application program server connected to the inventory allocation order setting device 100 via an arbitrary network, and all or a part thereof may be downloaded as needed. It is possible.

Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPROM (registration). Trademarks) (Electrically Erasable and Protocol Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disc), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

Further, the "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium and the installation procedure after reading in each device shown in the embodiment.

Various databases and the like stored in the storage unit 106 are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

Further, 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 any peripheral device is connected. Further, the inventory allocation order setting device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the information processing device.

Furthermore, the specific form of distribution / integration of the device is not limited to that shown in the figure, and all or part of the device may be functionally or physically in any unit according to various additions or the like. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

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

100 Stock allocation order setting device 102 Control unit 102a Store order data acquisition unit 102b Allocation order determination unit 102c Inventory allocation processing unit 102d Store attribute information creation processing unit 102e Master maintenance unit 104 Communication interface unit 106 Storage unit 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 I / O interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (5)

It is an inventory allocation order setting device that has a storage unit and a control unit, sets the rating order of stores that allocate inventory to store order data of products from stores, and performs inventory allocation processing according to the order. ,
In the storage unit
An attribute information storage table that stores the attribute information of the store, and
A rating master that quantifies the rating of the store based on the attribute information storage table, and
A store master that holds digitized attribute information for each store,
A store attribute master that outputs a store rating result based on a numerical value that combines the attribute information of the store master, and
A management master that manages standard values related to store rating ranking,
A product master that manages settings related to whether or not to make further allocation of inventory remaining after the initial allocation or how to determine the allocation destination store when making such further allocation.
Is stored,
The control unit
The attribute information of each store is collected from the attribute information storage table, quantified by the rating master, the quantified attribute information of each store is stored in the store master, and the numerical value is based on the combination of the attribute information of the store master. A store attribute information creation processing means that calculates a store rating result and sets the calculated store rating result as a store rating order in the store master.
From the stores that have received orders, select the store whose store rating order set in the store master meets the reference value as the store to be allocated, and the total number of orders from all the selected stores subject to allocation is in stock. A means of determining the allocation order to determine whether the number is exceeded,
1) If the total exceeds the inventory quantity, the inventory of the quantity based on the product of the ratio of the number of orders from each allocation target store to the total and the inventory quantity is allocated to each allocation target store. 2) Determine whether to allocate the fractional inventory, which is obtained by subtracting the total number of allocations to all the allocation target stores from the relevant inventory quantity, to the allocation target store according to the setting of the product master, and 3) allocate the inventory of the fraction. When doing so, the allocation target store to be the allocation destination of the inventory of the fraction is determined according to the setting of the product master, and 4) the inventory of the fraction is further allocated to the determined allocation target store, and the allocation target is determined. Update the number of store allocations, 5) Inventory allocation processing means to generate shipping request data, and
Possible to obtain Bei a,
An inventory allocation ranking setting device characterized by. The attribute information is
Include at least one of store sales rank, store area rank, store location rank, store employee number rank, store manager rank, and store floor rank,
The inventory allocation order setting device according to claim 1. The attribute information storage table is
When the attribute information is the sales rank of the store, the POS sales data for each store aggregated by the POS system of the store is stored.
The rating master is
Being a sales rank master that quantifies the rating of the store based on the POS sales data.
2. The inventory allocation order setting device according to claim 2. It is executed by an inventory allocation order setting device that has a storage unit and a control unit, sets the rating order of the store that allocates inventory to the store order data of products from the store, and performs inventory allocation processing according to the order. It is a method of setting the inventory allocation order.
In the storage unit
An attribute information storage table that stores the attribute information of the store, and
A rating master that quantifies the rating of the store based on the attribute information storage table, and
A store master that holds digitized attribute information for each store,
A store attribute master that outputs a store rating result based on a numerical value that combines the attribute information of the store master, and
A management master that manages standard values related to store rating ranking,
A product master that manages settings related to whether or not to make further allocation of inventory remaining after the initial allocation or how to determine the allocation destination store when making such further allocation.
Is stored,
Executed by the control unit,
The attribute information of each store is collected from the attribute information storage table, quantified by the rating master, the quantified attribute information of each store is stored in the store master, and the numerical value is based on the combination of the attribute information of the store master. A store attribute information creation processing step that calculates a store rating result and sets the calculated store rating result as a store rating order in the store master.
From the stores that have received orders, select the store whose store rating order set in the store master meets the reference value as the store to be allocated, and the total number of orders from all the selected stores subject to allocation is in stock. The allocation ranking determination step to determine whether the number is exceeded, and
1) If the total exceeds the inventory quantity, the inventory of the quantity based on the product of the ratio of the number of orders from each allocation target store to the total and the inventory quantity is allocated to each allocation target store. 2) Determine whether to allocate the fractional inventory, which is obtained by subtracting the total number of allocations to all the allocation target stores from the relevant inventory quantity, to the allocation target store according to the setting of the product master, and 3) allocate the inventory of the fraction. When doing so, the allocation target store to be the allocation destination of the inventory of the fraction is determined according to the setting of the product master, and 4) the inventory of the fraction is further allocated to the determined allocation target store, and the allocation target is determined. An inventory allocation process step that updates the number of store allocations and generates shipping request data,
To including it,
An inventory allocation order setting method characterized by. It is equipped with a storage unit and a control unit, and sets the rating order of the store that allocates inventory to the store order data of products from the store, and executes it with the inventory allocation order setting device that performs inventory allocation processing according to the order. Is an inventory allocation ranking setting program for
In the storage unit
An attribute information storage table that stores the attribute information of the store, and
A rating master that quantifies the rating of the store based on the attribute information storage table, and
A store master that holds digitized attribute information for each store,
A store attribute master that outputs a store rating result based on a numerical value that combines the attribute information of the store master, and
A management master that manages standard values related to store rating ranking,
A product master that manages settings related to whether or not to make further allocation of inventory remaining after the initial allocation or how to determine the allocation destination store when making such further allocation.
Is stored,
To be executed by the control unit
The attribute information of each store is collected from the attribute information storage table, quantified by the rating master, the quantified attribute information of each store is stored in the store master, and the numerical value is based on the combination of the attribute information of the store master. A store attribute information creation processing step that calculates a store rating result and sets the calculated store rating result as a store rating order in the store master.
From the stores that have received orders, select the store whose store rating order set in the store master meets the reference value as the store to be allocated, and the total number of orders from all the selected stores subject to allocation is in stock. The allocation ranking determination step to determine whether the number is exceeded, and
1) If the total exceeds the inventory quantity, the inventory of the quantity based on the product of the ratio of the number of orders from each allocation target store to the total and the inventory quantity is allocated to each allocation target store. 2) Determine whether to allocate the fractional inventory, which is obtained by subtracting the total number of allocations to all the allocation target stores from the relevant inventory quantity, to the allocation target store according to the setting of the product master, and 3) allocate the inventory of the fraction. When doing so, the allocation target store to be the allocation destination of the inventory of the fraction is determined according to the setting of the product master, and 4) the inventory of the fraction is further allocated to the determined allocation target store, and the allocation target is determined. An inventory allocation process step that updates the number of store allocations and generates shipping request data,
To including it,
An inventory allocation ranking setting program characterized by.

Images