JP7064397B2 - Inventory distribution device, inventory distribution method, and inventory distribution program - Google Patents

Description

The present invention relates to an inventory distribution device, an inventory distribution method, and an inventory distribution program.

For example, with the recent spread of SNS and the like, fashion-related products are changing rapidly, and the time when the products are popular and the time when they end are often different depending on the region. Therefore, it is important to efficiently allocate product inventory to each store.

As a conventional store ordering system, for example, there is Patent Document 1. In Patent Document 1, in paragraphs [0037] to [0042], "In the example of FIG. 2A, the input holder has POS terminal flash data (destination: own store), inventory data (destination: headquarters), POS terminal date. Contains transaction data for total sales data (destination: own store), return data (destination: headquarters), and transfer data for other stores (destination: own store, other stores). In the process of updating, it is necessary to prioritize the process for the convenience of each business. It is also desirable that it can be changed appropriately on a time zone, date, weekly basis, etc. For example, the current time is within the business hours of the store. If so, since the POS terminal flash data is data indicating the current total sales of the POS terminal, the store server system quickly aggregates these data and outputs them to the console as aggregated data. POS terminal flash data is very high priority data during business hours because it is necessary to check the data and take measures such as changing the sales method for the day if the target sales are not reached. On the other hand, the POS terminal daily total sales data is the final sales data of the day and is data that should be processed within the day as a daily report, so it is low priority data. In addition, return data and transfer to other stores. Similarly, the data is low-priority data because it can be processed within the same day. Also, for example, if the current time is immediately after the store's closing time, today's sales total is the highest priority. Therefore, the POS terminal daily total sales data should be the highest priority data. And once the daily sales total is completed, it is necessary for the allocation process to order and replenish the missing products. Inventory data is the data that should have the highest priority. Thus, the processing priority of transaction data changes with time. Therefore, for example, a store server has a priority table, and each time zone By rewriting this content, it is possible to prioritize and process the transaction data that should be given the highest priority in the relevant time zone. "

Japanese Unexamined Patent Publication No. 2005-122502

However, in Patent Document 1, the number of shipping instructions is automatically determined for the sales flash report obtained from the POS, the order data from the store, and the instruction data from the headquarters, and the shipping instructions are collectively given, which is effective in terms of sales. Nothing is stated about the distribution of goods to stores.

The present invention has been made in view of the above, and an object of the present invention is to provide an inventory distribution device, an inventory distribution method, and an inventory distribution program capable of effectively distributing products to stores in terms of sales. And.

In order to solve the above-mentioned problems and achieve the object, the present invention is an inventory distribution device including a control unit and a storage unit, and the storage unit has a designated category and a priority corresponding to the designated category. A store instruction classification master registered in association with a ranking and inventory data including a product code and the number of products in stock of the product code are stored, and the control unit stores the store code and product code of each store. , And sales flash report data including the number of sales, store code from each store, product code, order classification, store order data including the number of orders, store code from the headquarters, product code, and distribution to each store. Based on the data input means for inputting the headquarters instruction data including the order data to be instructed, the sales flash report data, the store order data, and the headquarters instruction data, the instruction category is determined for each store code and product code. With reference to the store instruction classification master, the priority corresponding to the determined instruction classification is acquired, and according to the priority, the inventory data is referred to to determine the number of shipping instructions for inventory to each store. It is characterized by having a means for creating an instruction work.

Further, according to the present embodiment, the instruction categories are a customer order ordered by an order from a customer at a store, a priority order placed for replenishment of a main product at the store, and a customer order at the store. It may include normal orders other than priority, sales that are supplements of products based on sales results based on the store's preliminary information data, and distribution that is an instruction to distribute to each store from the headquarters. ..

Further, according to the present embodiment, the instruction work creating means calculates a sales transition indicating a sales transition for each store code and product code based on the preliminary report information from the store, and calculates the sales transition indicating the sales transition, and the store code and the product. For each code, the number of instructed shipments of inventory to each store may be determined based on the acquired priority and the sales transition.

Further, according to the present embodiment, the storage unit further has a product code, an instruction determination period that defines a threshold value for a continuous decrease period, and an instruction determination rate that defines a threshold value for the sales ratio to the peak sales time. A product master to be stored in association with each other is stored, and the store instruction category master further registers a sales transition determination category that specifies whether or not to determine a sales transition in association with the instruction category. The instruction work creating means calculates the sales ratio for the continuous decrease period of sales and the peak time of sales as the sales transition, and for the sales transition, the sales transition is determined from the store instruction category master using the instruction category as a key. If the category is acquired and the acquired sales transition judgment category is set to not determine the sales transition, the sales transition is not considered when determining the number of shipping instructions, and the product code is used as a key to determine the product master. The instruction judgment period and the instruction judgment rate are obtained from, and if the calculated continuous decrease period is less than or equal to the instruction judgment period and the calculated sales ratio is not more than the instruction judgment rate, it is not subject to the shipping instruction. You may.

Further, in order to solve the above-mentioned problems and achieve the object, the present invention is an inventory distribution method for causing an information processing apparatus provided with a control unit and a storage unit to execute the inventory distribution method, and the storage unit includes the storage unit. A store instruction category master registered in association with an instruction category and a priority corresponding to the instruction category, and inventory data including a product code and the number of products in stock of the product code are stored, and the control unit. Store code, product code, and sales flash data including the number of sales, store code from each store, product code, order classification, store order data including the number of orders, and store code from the headquarters. , Product code, and a data input step for inputting headquarters instruction data including order data for instructing distribution to each store, and a store code based on the sales flash report data, the store order data, and the headquarters instruction data. And for each product code, the instruction category is determined, the store instruction category master is referred to, the priority order corresponding to the determined instruction category is acquired, and the inventory data is referred to according to the priority order. It is characterized by including an instruction work creation step for determining the number of instructions for shipping inventory to each store.

Further, in order to solve the above-mentioned problems and achieve the object, the present invention is an inventory distribution program for causing an information processing apparatus provided with a control unit and a storage unit to execute the inventory distribution program, and the storage unit includes the storage unit.
A store instruction category master registered in association with an instruction category and a priority corresponding to the instruction category, and inventory data including a product code and the number of products in stock of the product code are stored, and the control unit. In, the store code, product code, and sales flash report data including the number of sales of each store, the store code from each store, the product code, the order classification, and the store order data including the number of orders, and the store code and products from the headquarters. The store code and the product are based on the data input step for inputting the headquarters instruction data including the code and the order data for instructing the distribution to each store, the sales flash report data, the store order data, and the headquarters instruction data. For each code, the instruction category is determined, the store instruction category master is referred to, the priority order corresponding to the determined instruction category is acquired, and according to the priority order, the inventory data is referred to to each store. It is characterized in that it is an instruction work creation step for determining the number of instructions for shipping inventory to, and an inventory distribution program for executing.

According to the present invention, it is possible to effectively distribute products to stores in terms of sales.

FIG. 1 is a diagram for explaining an outline of the present embodiment. FIG. 2 is a block diagram showing an example of the configuration of the inventory distribution device according to the present embodiment. FIG. 3 is a diagram showing a configuration example of a product master, a store instruction classification master, store bulletin data, store order data, headquarters instruction data (order data), inventory data, store inventory data, and shipping instruction work data. FIG. 4 is a diagram showing an example of data of the product master. FIG. 5 is a diagram showing a data example of the store instruction classification master. FIG. 6 is a flowchart for explaining the shipping instruction processing of the inventory distribution device according to the present embodiment. FIG. 7 is a diagram showing an example of data for explaining the outline of creating shipping instruction work data. FIG. 8 is a diagram showing an example of data for explaining an outline of creation of shipping instruction work data. FIG. 9 is a diagram for explaining a detailed calculation method of the number of shipping instructions of the shipping instruction work data. FIG. 10 is a diagram for explaining a detailed calculation method of the number of shipping instructions of the shipping instruction work data. FIG. 11 is a diagram for explaining a detailed calculation method of the number of shipping instructions of the shipping instruction work data.

Embodiments of 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]
With the recent spread of SNS and the like, for example, the fashion of fashion-related products changes quickly, and the time when the product becomes popular and the time when the product ends often differ depending on the region. In the clothing retail industry, which operates stores, it is not possible to secure a large amount of inventory in a limited inventory space, so it is possible to quickly determine the area where the products handled are popular, and lose sales opportunities due to shortages at stores in that area. The issue is how to reduce the problem.

For this reason, in addition to store-based ordering operations, it is desirable that the headquarters take the initiative in replenishing inventory in stores and speedily replenishing products sold during the day. In addition, it is desired to have a mechanism to effectively improve the turnover rate and profit of warehouse inventory products by preferentially shipping to stores with high sales opportunities.

Therefore, in the present embodiment, the inventory distribution instruction is collectively given to each store in response to the order from the store, the sales flash report, and the instruction from the headquarters. When giving distribution instructions, we have built a system that can handle orders such as ordering products and reservations at stores, while taking into account the sales transition status of each product at each store. As a result, products can be effectively distributed to stores in terms of sales, that is, products can be efficiently distributed to stores where sales opportunities are likely to be large, and an effective product development strategy can be assisted. Is possible.

FIG. 1 is a diagram for explaining an outline of the present embodiment. In the present embodiment, the inventory distribution device arranged on the headquarters side is the store sales flash report data from the POS terminal device arranged in each store, the store order data from the store terminal device arranged in each store, and the headquarters. Acquires headquarters instruction data (ordering data) that instructs the distribution of products from the terminal device to each store. The inventory distribution device located on the headquarters side performs shipping instruction processing to distribute the inventory of products to each store based on the store sales flash report data, store order data, and headquarters instruction data (order data), and collectively. Create shipping instruction data for issuing shipping instructions.

[2. Constitution]
An example of the configuration of the inventory distribution device according to the present embodiment will be described with reference to FIG. 1. FIG. 1 is a block diagram showing an example of an inventory distribution device 100 according to the present embodiment.

In FIG. 1, the inventory distribution 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 distribution device 100 is communicably connected via an arbitrary communication path.

The inventory distribution device 100 is, for example, a commercially available desktop personal computer. The inventory distribution device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a portable notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, a tablet personal computer, or the like on the market. It may be a type information processing device.

The communication interface unit 104 connects the inventory distribution 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 includes an inventory distribution device 100, a server 200, a plurality of POS terminal devices 400 arranged in each store, and a plurality of store terminal devices 500 arranged in each store. -It has a function of connecting the terminal device 600 for the headquarters arranged in the headquarters so as to be able to communicate with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like. As a result, the communication interface unit 104 is configured to be capable of data communication with the server 200, the plurality of POS terminal devices 400 ..., the plurality of store terminal devices 500 ..., and the headquarters terminal device 600 via the network 300. Has been done.

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. Further, the storage unit 106 includes a product master 106a, a store instruction classification master 106b, an order DB 106c, an inventory DB 106d, and a shipping DB 106e.

FIG. 3 shows a configuration example of product master 106a, store instruction classification master 106b, store preliminary report data, store order data, headquarters instruction data (order data), inventory data, store inventory data, shipping instruction work data, and shipping instruction data. It is a figure which shows. FIG. 4 is a diagram showing a data example of the product master 106a. FIG. 5 is a diagram showing a data example of the store instruction classification master 106b.

As shown in FIG. 3, the product master 106a can be composed of a table or the like in which data of a product code, a product name, an instruction determination period, and an instruction determination rate are registered in association with each other. The designated judgment period defines the threshold value for the period (number of months) in which sales have decreased. The instruction judgment rate defines a threshold value (%) of the sales ratio of each product. If the sales are on a downward trend and the sales ratio is lower than the instruction judgment rate, it will not be subject to shipping instructions.

In the example of the product master 106a shown in FIG. 4, the first line is the product code "WT001", the product name "shoes A", the instruction judgment period "2", the instruction judgment rate "60%", and the second line is the product. Code "WT002", product name "Shoes B", instruction judgment period "3", instruction judgment rate "60%", the third line is product code "WT003", product name "Shoes C", instruction judgment period "2" , The instruction judgment rate is "60%", and so on.

As shown in FIG. 3, the store instruction classification master 106b registers the data of the instruction classification (customer order, priority, normal, sales, distribution), priority, and sales transition judgment classification (whether or not) in association with each other. It can be composed of a table or the like.

The instruction category (customer order, priority, normal, sales, distribution) is the order category (normal, customer order, priority) in the case of store order data. A "customer order" is an order from the final consumer, an order for a reservation, etc. at a store. "Priority" is an order to replenish a focus product at a store. "Normal" is a normal order from a store. "Sales" is based on the sales of the store flash report data, and is, for example, product replenishment based on the sales results on the day. "Distribution" is based on the headquarters instruction data, and is, for example, distribution (orders) to each store such as company-wide focus products.

The priority order defines the priority order when inventory is distributed for each instruction category (customer order, priority, normal sales, distribution).

Whether the sales transition judgment category judges (considers) the continuous decrease period and sales ratio of the shipping instruction work data for each instruction category (customer order, priority, normal sales, distribution) when inventory distribution is performed. It stipulates whether or not to do so.

In the example of the store instruction category master 106b shown in FIG. 5, in the case of the instruction category "normal", the priority is "3" and the sales transition judgment category is "do", and in the case of the instruction category "customer order", the priority is "". 1 ”, if the sales transition judgment category“ not ”is the instruction category“ priority ”, the priority is“ 2 ”, if the sales transition judgment category is“ not ”, and if the instruction category is“ sales ”, the priority is“ 4 ”. , When the sales transition judgment category "do" is the instruction category "distribution", the priority order "5" and the sales transition judgment category "do" are registered. In this way, the order of priority is customer note> priority> normal> sales> distribution, and the high priority "customer note" and "priority" are in the sales transition judgment category "not". ..

The order receiving DB 106c is a file for storing store breaking data, store ordering data, headquarters instruction data (ordering data), and store-specific sales record data.

As shown in FIG. 3, the store preliminary report data may include data on sales date, store code, product code, number of sales, and sales amount. The products handled by each store may be mastered, and only the products currently handled may be mastered.

The sales performance data for each store is created based on the store preliminary report data, and may include the store code, the product code, and the data of the number of sales each month as shown in FIG. The "continuous decrease period" and "sales ratio" of the shipping instruction work data are calculated based on the sales performance data for each store.

As shown in FIG. 3, the store order data may include data of order classification (usually customer order, priority), order date, store code, product code, and order quantity.

As shown in FIG. 3, the headquarters instruction data (order data) may include data of an order date, a store code, a product code, and an order quantity (distribution instruction number).

The inventory DB 106d is a DB for storing inventory data and store inventory data.

As shown in FIG. 3, the inventory data may include the warehouse code, the product code, and the data of the current inventory quantity.

As shown in FIG. 3, the store inventory data may include store code, product code, and current inventory quantity data.

The shipping DB 106e is a DB for storing shipping instruction work data and shipping instruction data.

As shown in FIG. 3, the shipping instruction work data includes instruction classification (customer order, priority, normal, sales, distribution), priority, store code, product code, warehouse inventory quantity, store inventory quantity, continuous decrease period, It may include data on the sales ratio, the number of shipping requests, and the number of shipping instructions. The shipping instruction work data is intermediate data for determining the number of shipping instructions.

The shipping instruction work data refers to the product master 106a and the store instruction classification master 106b based on the store preliminary report data (sales record data by store), store order data, headquarters instruction data, inventory data, and store inventory data. Created or updated. The instruction category is "sales" in the case of store flash report data, "distribution" in the case of headquarters instruction data, and the order category of store order data (usually customer order, priority) in the case of store order data. .. The "priority" is acquired from the store instruction division master 106b using the instruction division as a key. "Warehouse inventory quantity" is acquired from inventory data. The "store inventory quantity" is acquired from the store inventory data. The "continuous decrease period" and "sales ratio" are calculated based on the sales performance data for each store. The "number of shipping requests" is the number of orders for store order data, the number of sales for store bulletin data, and the number of orders for headquarters instruction data.

Returning to FIG. 2, the control unit 102 is a CPU or the like that collectively controls the inventory distribution 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 is functionally and conceptually provided with a data input unit 102a, a shipping instruction work creation unit 102b, a master maintenance unit 102c, and the like.

The data input unit 102a obtains sales flash report data including a store code, a product code, and the number of sales from each POS terminal device 400 ..., and a store code from each store from each store terminal device 500 ... The store order data including the product code, the order classification, and the number of orders is acquired, and the headquarters instruction data including the store code, the product code, and the number of orders (distribution number) from the terminal device 600 for the headquarters is acquired, and the order DB 106c is obtained. Store in.

The shipping instruction work creation unit 102b executes the shipping instruction processing to create the shipping instruction work data, and creates the shipping instruction data based on the shipping instruction work data. In the shipping instruction processing, the instruction category is determined based on the sales flash report data, the store order data, and the headquarters instruction data for each store code and product code, and the store instruction category master 106b is referred to to give priority to the instruction category. The order is acquired, and the number of shipping instructions for the inventory of each store is determined by referring to the inventory information according to the priority.

The instruction categories are customer orders placed by orders from customers at the store, priority orders placed to replenish the main products at the store, normal orders other than customer orders and priority at the store, and store bulletins. It may include sales that are supplements of products based on sales results based on data, and distribution that is a distribution instruction from the headquarters.

In addition, in the shipping instruction processing, sales transition (for example, a continuous decrease period, which is a period during which sales are continuously decreasing) for each store code and product code based on store preliminary report data (sales performance data by store), The sales ratio, which is the ratio of sales to the peak time) may be calculated, and the number of shipping instructions for the inventory of each store may be determined based on the acquired priority and the sales transition for each store code and product code.

In addition, the sales transition includes the continuous decrease period, which is the period during which sales are continuously decreasing, and the sales ratio, which is the ratio of sales to the peak time. When the sales transition judgment category of 106b is set to not judge the sales transition, the corresponding instruction judgment period of the product master 106a is not taken into consideration when determining the number of shipping instructions, and the product code is used as a key. And if the instruction judgment rate is acquired, the continuous decrease period is less than the instruction judgment period, and the sales ratio is not more than the instruction judgment rate, the shipping instruction is not dealt with (it is not subject to automatic distribution). good.

The master maintenance unit 102f edits data input / addition / change of the product master 106a and the store instruction classification master 106b in response to an operation by an administrator or the like on a master maintenance screen (not shown) displayed on the monitor 114. Is for doing.

[3. Concrete example]
A specific example of the processing of the inventory distribution device 100 according to the present embodiment will be described with reference to FIGS. 2 and 6 to 11. FIG. 6 is a flowchart for explaining the shipping instruction processing of the inventory distribution device according to the present embodiment.

With reference to FIG. 6, an example of an outline of the shipping instruction processing of the inventory distribution device 100 according to the present embodiment will be described. In FIG. 6, target store order data, store preliminary report data, and headquarters instruction data (order data) are extracted from the order DB 106c (steps S11 to S13). The store inventory quantity is extracted with reference to the store inventory data stored in the inventory DB 106d (step S14). Further, the warehouse inventory quantity is extracted with reference to the warehouse inventory data stored in the inventory DB 106d (step S15).

The continuous decrease period is calculated based on the sales performance data for each store (step S16). The continuous decrease period is a material for determining whether or not sales are on a downward trend.

The sales ratio is calculated based on the sales performance data for each store (step S17). The sales ratio is a quantification of how much the sales have decreased with respect to the peak sales (month).

The shipping instruction work data is created based on the processes of S11 to S18 (step S19).

Using the instruction category as a key, it is determined whether or not the store instruction category master 106b has a sales transition determination (step S19). If there is no sales transition determination, automatic inventory distribution (determination of the number of shipping instructions) is executed without using (considering) the sales transition (sales continuous decrease period, sales ratio) (step S22).

If the sales transition judgment is "Yes", the sales transition judgment is performed (step S20), it is determined whether or not the automatic distribution target is present (step S21), and if it is the automatic distribution target, the automatic distribution is executed. (Step S22). If it is not the target of automatic distribution, it returns to S20 and moves to the next record.

(1. Data example of shipping instruction work data)
A data example of the shipping instruction work data will be described in detail with reference to FIGS. 7 to 11.

(1-1. Creation of shipping instruction work data)
7 and 8 are data examples for explaining the outline of the creation of the shipping instruction work data. FIG. 7 is a diagram for explaining the “instruction classification”, “warehouse inventory quantity”, “store inventory quantity”, and “shipment request quantity” of the shipping instruction work data.

In FIG. 7, the store order data includes the order category “normal”, the order date “2018/02/28”, the store code “0610”, the product code “WT001”, the number of orders “1”, and the order category “customer order”. , Order date "2018/02/28", store code "0610", product code "WT002", order quantity "2", order classification "priority", order date "2018/02/28", store code "0610" , The product code "WT003", the number of orders received "1", and so on.

The store bulletin data includes sales date "2018/03/01", store code "610", product code "WT001", number of sales "1", sales amount "¥ 4,900", and sales date "2018/03 /". 01 ”, store code“ 610 ”, product code“ WT002 ”, number of sales“ 1 ”, sales amount“ ¥ 5,900 ”, sales date“ 2018/03/01 ”, store code“ 610 ”, product code“ WT003 ”, the number of sales“ 1 ”, and the sales amount“ ¥ 6,900 ”.

Headquarters instruction data includes order date "2018/02/28", store code "610", product code "WT001", order quantity "2", order date "2018/02/028", store code "611", The product code is "WT001", the number of orders is "2", the order date is "2018/02/028", the store code is "612", the product code is "WT001", the number of orders is "2", and so on.

The current warehouse data is warehouse code "0902", product code "WT001", current warehouse number "9", warehouse code "0902", product code "WT002", current warehouse number "4", and warehouse code "0902". , The product code is "WT003", the current number of warehouses is "2", and so on.

The store inventory data includes the store code "610", the product code "WT001", the current number of warehouses "1", the store code "610", the product code "WT002", the current number of warehouses "0", and the store code "610". , The product code is "WT003", the current number of stocks is "1", and so on.

Store order data, store bulletin data, headquarters instruction data, current warehouse data, and store inventory data are collected, and shipping instruction work data is updated (aggregated).

The "order category (normally customer order, priority)" of the store order data is the "instruction category (normally customer order, priority)" of the shipping instruction work data. The sales of the store bulletin data shall be the "instruction category (sales)" of the shipping instruction work data. The instruction of the number of orders (the number of distribution instructions) of the headquarters instruction data shall be the "instruction classification (distribution)" of the shipping instruction work data.

The "shipping request number" of the shipping instruction work data is the "ordering number" of the store ordering data, the "sales number" of the store bulletin data, and the "ordering number" of the headquarters instruction data. Regarding the "number of sales" of the store bulletin data, if the sales date, store, and product are the same, the total value is acquired at the time of data collection.

The data of "warehouse inventory quantity" and "store inventory" of the shipping instruction work data are acquired from the current warehouse data and the store inventory data.

In the shipping instruction work data, the first record is the instruction category "normal", store code "0610", product code "WT001", warehouse inventory quantity "9", store inventory quantity "1", shipping request quantity "1", The second record is the instruction category "normal", the store code "0610", the product code "WT002", the warehouse inventory number "4", the store inventory number "0", the shipping request number "2", and the third record is the instruction. The categories are "normal", store code "0610", product code "WT003", warehouse inventory quantity "2", store inventory quantity "1", shipping request quantity "1", and so on.

FIG. 8 is a diagram for explaining the “continuous decrease period” and the “sales ratio” of the shipping instruction work data. In FIG. 8, the product master 106a and the store instruction classification master 106b are the same as the data examples of FIGS. 4 and 5.

The sales performance data by store is the store code "0610", product code "WT001", 2018/03 "1", 2018/02 "8", 2018/01 "9", 2017/12 "14" 2017/11 " 14 ”, store code“ 0610 ”, product code“ WT002 ”, 2018/03“ 1 ”, 2018/02“ 12 ”, 2018/01“ 11 ”, 2017/12“ 16 ”, 2017/11“ 15 ” And the store code "0610", the product code "WT003", 2018/03 "1", 2018/02 "9", 2018/01 "10", 2017/12 "13", 2017/11 "10", and so on. ... is.

Based on the sales performance data for each store, the "continuous decrease period" and the "sales ratio" are calculated for each store code and product code. In the example of the shipping instruction work data shown in FIG. 7A, the first record shows the store code "0610" and the product code "WT001" with a continuous decrease period of "2 months" and a sales ratio of "57%". The record is about the store code "0610" and the product code "WT002", the continuous decrease period is "0 months", the sales ratio is "80%", and the third record is about the store code "0610" and the product code "WT003". , The continuous decrease period is "2 months", the sales ratio is "69%", and so on.

FIG. 7B shows a case where the shipping instruction work data shown in FIG. 7A is sorted in the order of product codes and the number of shipping instructions is calculated. A detailed calculation method of the number of shipping instructions will be described with reference to FIGS. 9 to 11.

(1-2. Number of shipping instructions for shipping instruction work data)
9 to 11 are diagrams for explaining a detailed calculation method of the number of shipping instructions of the shipping instruction work data.

(1) Selection of data for which the sales transition is not determined In FIG. 9, the selection of data for which the sales transition (continuous decrease period, sales ratio) is not determined will be described with reference to the store instruction classification master 106b. In FIG. 9 (A), the data of the priority order and the sales transition judgment category (whether or not) are acquired from the store instruction category master 106b using the instruction category of the shipping instruction work data as a key, and are shown in FIG. 9 (B). As such, the priority is updated and the data that does not judge the sales transition is selected.

In FIG. 9B, for example, the store code "0610" and the product code "WT002" and the store code "612" and the product code "WT005" have the instruction category "customer order", so that the sales transition is determined. do not. Since the instruction category of the store code "0610" and the product code "WT003" is "customer order", the sales transition is not judged.

(2) Judgment of presence / absence of distribution of the number of shipping instructions In FIG. 10, the determination of presence / absence of distribution of the number of shipping instructions will be described with reference to the product master 106a. In FIG. 10A, using the product code of the shipping instruction work data as a key, the data of the instruction judgment period and the instruction judgment rate is acquired from the product master 106a, and as shown in FIG. 10B, the number of shipping instructions is increased. Determine if there is a distribution. If the "continuous decrease period" is less than or equal to the "instruction judgment period" and the "sales ratio (%)" is not greater than or equal to the instruction judgment rate, the sales transition is not considered when determining the number of shipping instructions.

In FIG. 10B, for example, for the store code “610” and the product code “WT001”, the continuous decrease period “2” is within the instruction judgment period “2”, but the sales ratio “57%” is instructed. Since the judgment period is less than "60%", it is excluded from the distribution of shipping instructions. For the store code "611" and the product code "WT004", the continuous decrease period is "0" and the instruction judgment period is within "2", but the sales ratio "0%" is less than the instruction judgment rate "60%". Therefore, it is excluded from the distribution of shipping instructions.

(3) Execution of automatic distribution of warehouse inventory (determination of shipping instructions)
In FIG. 11, the automatic distribution of the warehouse inventory quantity will be described. In FIG. 11A, inventory of warehouse inventory data is assigned to each product code in ascending order of priority of instruction category and descending order of sales ratio. In the example shown in FIG. 11B, the product codes are sorted in ascending order of priority of the instruction category and descending order of sales ratio. Since the product code "WT001" is the inventory quantity "9", the store codes "0612", "0611", "0612" of 10, 13, 14 records are combined with the number of shipping requests "2", "2", " 2 ”are assigned, respectively, and the number of shipping instructions is“ 2 ”,“ 2 ”, and“ 2 ”.

Further, since the product code "WT002" has the inventory quantity "4", the store codes "0610" and "061" of 2, 9, and 7 records are combined with the number of shipping requests "2", "3", and "1". On the other hand, the number of shipping instructions is set to "2", "1", and "1" by allocating until the warehouse inventory is exhausted.

As described above, according to the present embodiment, the store instruction category master 106b registered in association with the instruction category and the priority corresponding to the instruction category, the product code, and the number of products in stock of the product code. Inventory data including, store code, product code, and sales flash data including the number of sales of each store, store code from each store, product code, order classification, and store order data including the number of orders, and from the headquarters. Based on the data input unit 102a for inputting the headquarters instruction data including the store code, the product code, and the data of the number of orders instructing the distribution to each store, the sales flash report data, the store order data, and the headquarters instruction data. The instruction category is determined for each store code and product code, the priority is acquired from the store instruction category master using the determined instruction category as a key, and according to the priority, the inventory data is referred to to each store. Since it is provided with a shipping instruction work creating unit 102b for determining the number of shipping instructions in stock, it is possible to effectively distribute products to stores in terms of sales.

In addition, the shipping instruction work creation unit 102b calculates the sales transition for each store code and product code based on the preliminary information from the store, and based on the acquired priority and the sales transition, the stock in each store. Since it was decided to determine the number of shipping instructions, it is possible to determine the number of shipping instructions to each store in consideration of the sales transition of the target product of each store.

In addition, the store instruction classification master is provided with a product master 106a that stores the product code, the instruction judgment period that defines the threshold value of the continuous decrease period of sales, and the instruction judgment rate that defines the threshold value of the sales ratio with respect to the peak sales time. 106b is further registered in association with a sales transition judgment category that specifies whether or not to determine sales transition in association with the instruction category, and the shipping instruction work creation unit 102b describes the continuous decrease period of sales as the sales transition. And the sales ratio to the peak time of sales is calculated, and for the sales transition, the sales transition judgment category is acquired from the store instruction category master 106b with the instruction category as the key, and the acquired sales transition judgment category does not judge the sales transition. If it is set, the sales transition is not taken into consideration when determining the number of shipping instructions, and the instruction judgment period and instruction judgment rate are acquired from the product master 106a using the product code as a key, and the calculated continuous decrease period is calculated. However, if the sales ratio is less than the instruction judgment period and the calculated sales ratio is not more than the instruction judgment rate, it is not subject to the shipping instruction. It becomes possible to effectively distribute products to stores.

[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 may be performed manually, or all the processes described as being performed manually may be performed. Alternatively, a part 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 distribution 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 distribution 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 stock distribution is performed as necessary. It is read mechanically by the 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 106 such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into the RAM, and constitutes the control unit 102 in cooperation with the CPU.

Further, this computer program may be stored in an application program server connected to the inventory distribution device 100 via an arbitrary network, and all or a part thereof can be downloaded as needed. Is.

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 Probe 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 specific configurations and reading procedures for reading the recording medium in each apparatus shown in the embodiment, installation procedures after reading, and the like.

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 distribution 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 distribution 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.

100 Stock distribution device 102 Control unit 102a Data input unit 102b Shipment instruction work creation unit 102c Master maintenance unit 104 Communication interface unit 106 Storage unit 106a Product master 106b Store instruction classification master 106c Ordering DB
106d Stock DB
108 Input / output interface unit 112 Input device 114 Output device 300 Network 400 POS terminal device 500 Store terminal device 600 Headquarters terminal device

Claims (6)

An inventory distribution device equipped with a control unit and a storage unit.
In the storage unit
The store instruction category master registered by associating the instruction category with the priority corresponding to the instruction category, and
Inventory data including the product code and the number of products in stock with the product code,
Is stored,
The control unit
Store code, product code, and sales flash data including the number of sales of each store, store code, product code, order classification, and store order data including the number of orders from each store, and store code, product code, from the headquarters. And a data input means for inputting headquarters instruction data including order data for instructing distribution to each store,
Based on the sales flash report data, the store order data, and the headquarters instruction data, an instruction category is determined for each store code and product code, and the determined instruction category is supported by referring to the store instruction category master. A means for creating an instruction work that acquires a priority and determines the number of instructions for shipping inventory to each store by referring to the inventory data according to the priority.
An inventory distribution device characterized by being equipped with. The instruction categories are customer orders placed by ordering from customers at the store, priority orders placed to replenish the main products at the store, normal orders other than customer orders and priority at the store, and stores. The inventory distribution device according to claim 1, which includes sales that are supplements of products based on sales results based on the preliminary report information data of the above, and distribution that is an instruction of distribution from the headquarters to each store. .. The instruction work creating means is
Based on the preliminary information data from the store, the sales transition is calculated for each store code and product code, and the number of instructed shipments of inventory to each store is determined based on the acquired priority and the sales transition. The inventory distribution device according to claim 1 or 2, characterized in that. The storage unit further stores a product master that stores a product code, an instruction / judgment period that defines a threshold value for a continuous decrease period, and an instruction / judgment rate that defines a threshold value for the sales ratio to the peak sales time. Cage,
The store instruction category master further registers the sales transition determination category that specifies whether or not to determine the sales transition in association with the instruction category.
The instruction work creating means is
As the above-mentioned sales transition, the sales ratio to the continuous decrease period of sales and the peak time of sales is calculated.
Regarding the sales transition,
Using the instruction category as a key, the sales transition judgment category is acquired from the store instruction category master, and if the acquired sales transition determination category is set to not determine the sales transition, sales are determined when the number of shipping instructions is determined. Without considering the transition,
Using the product code as a key, the instruction judgment period and the instruction judgment rate are acquired from the product master, the calculated continuous decrease period is less than or equal to the instruction judgment period, and the calculated sales ratio is not equal to or more than the instruction judgment rate. Is the inventory distribution device according to claim 3, wherein the product is not subject to the shipping instruction. It is an inventory distribution method for causing an information processing device equipped with a control unit and a storage unit to execute.
In the storage unit
The store instruction category master registered by associating the instruction category with the priority corresponding to the instruction category, and
Inventory data including the product code and the number of products in stock with the product code,
Is stored,
It is executed by the control unit.
Store code, product code, and sales flash data including the number of sales of each store, store code, product code, order classification, and store order data including the number of orders from each store, and store code, product code, from the headquarters. And the data input step to input the headquarters instruction data including the order data to instruct the distribution to each store,
Based on the sales flash report data, the store order data, and the headquarters instruction data, an instruction category is determined for each store code and product code, and the determined instruction category is supported by referring to the store instruction category master. An instruction work creation step that acquires a priority and determines the number of instructions for shipping inventory to each store by referring to the inventory data according to the priority.
An inventory distribution method characterized by including. It is an inventory distribution program to be executed by an information processing device equipped with a control unit and a storage unit.
In the storage unit
The store instruction category master registered by associating the instruction category with the priority corresponding to the instruction category, and
Inventory data including the product code and the number of products in stock with the product code,
Is stored,
In the control unit
Store code, product code, and sales flash data including the number of sales of each store, store code, product code, order classification, and store order data including the number of orders from each store, and store code, product code, from the headquarters. And the data input step to input the headquarters instruction data including the order data to instruct the distribution to each store,
Based on the sales flash report data, the store order data, and the headquarters instruction data, an instruction category is determined for each store code and product code, and the determined instruction category is supported by referring to the store instruction category master. An instruction work creation step that acquires a priority and determines the number of instructions for shipping inventory to each store by referring to the inventory data according to the priority.
Inventory distribution program to run.

Images