Replenishment ordering auxiliary device, replenishment ordering auxiliary method, and replenishment ordering auxiliary program

Abstract

To provide a replenishment ordering auxiliary device, a replenishment ordering auxiliary method, and a replenishment ordering auxiliary program that allow replenishment ordering work of commodities to be conducted by a simple operation, regardless of an experience value of an ordering responsible person.SOLUTION: A replenishment ordering auxiliary device calculates a planned quantity of stock for an arrival scheduled date of a commodity, based on sales data, present stock data, order intake data, arrival schedule data, and tabulation data, determines whether the planned quantity of stock is a predetermined quantity or less, and calculates a replenishment proposal quantity of the commodity, based on the planned quantity of stock, if the planned quantity of stock is determined to be the predetermined quantity of stock or less.SELECTED DRAWING: Figure 1

Description

[Technical field]

[0001] The present invention relates to a replenishment ordering assistance device, a replenishment ordering assistance method, and a replenishment ordering assistance program. [Background technology]

[0002] In Patent Document 1, a certain amount of inventory is kept at the sales base, and an upper limit for inventory allocation is set; orders below the upper limit are allocated from the inventory, and orders above the upper limit and below the maximum number for which standard delivery time is applicable are handled by the predetermined standard delivery time for that product, thereby eliminating the need to hold large amounts of inventory and reducing the time required from order to delivery. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] JP 2002-29611 A Summary of the Invention [Problem to be solved by the invention]

[0004] In the distribution and retail industry, some businesses that operate in store format decide the number of items to replenish and order them from the warehouse at their own discretion. In this case, the person in charge of ordering checks whether the item is in stock or has been ordered previously before placing the replenishment order. In addition, for items with high turnover, ordering is done frequently, so ordering has to be done each time, which creates a lot of work for the ordering person.

[0005] Furthermore, there are many factors that go into deciding the number of replenishment orders, and it is necessary to take all of these factors into consideration when making a decision. For this reason, traditional replenishment order tasks require experienced ordering staff. As a result, in stores with a high turnover of staff, there was the problem that the replenishment order task became dependent on individual skills.

[0006] The present invention has been made in consideration of the above, and aims to provide a replenishment ordering assistance device, a replenishment ordering assistance method, and a replenishment ordering assistance program that enable product replenishment ordering tasks to be performed with simple operations, regardless of the experience level of the ordering staff. [Means for solving the problem]

[0007] In order to solve the above-mentioned problems and achieve the object, a replenishment order assisting device according to the present invention is a replenishment order assisting device having a control unit, and capable of accessing sales data in which store codes, stores, and sales numbers are associated with each other for each sales date, a calendar master in which store codes, stores, holiday categories, and store-closure categories are associated with each other for each date, current inventory data in which product codes and current inventory numbers are associated with each other for each store, order data in which transaction categories, scheduled shipping dates, store codes, stores, and scheduled shipping numbers are associated with each other for each slip number, and scheduled arrival data in which transaction categories, scheduled arrival dates, store codes, stores, and scheduled arrival numbers are associated with each other for each slip number, and the control unit references the sales data and the calendar master to access a replenishment order assisting device. a calculation unit that generates calculation data by calculating the sales volume and average daily sales volume for a month for a product corresponding to a product code on weekdays, Saturdays, Sundays, and holidays based on the order date, product code, and store code input by a user; a first calculation unit that calculates a planned inventory quantity for the product on the planned arrival date based on the sales data, the current stock data, the order data, the expected arrival data, and the calculation data; a determination unit that determines whether the planned inventory quantity is equal to or less than a predetermined quantity; a second calculation unit that calculates a suggested replenishment quantity for the product based on the planned inventory quantity when it is determined that the planned inventory quantity is equal to or less than the predetermined quantity; and an output control unit that outputs the suggested replenishment quantity.

[0008] Further, a replenishment order assistance method according to the present invention is a replenishment order assistance method executed by a replenishment order assistance device having a control unit, the replenishment order assistance device being able to access sales data associating store codes, stores, and sales figures for each sales date, a calendar master associating store codes, stores, holiday categories, and store closure categories for each date, current stock data associating product codes and current stock figures for each store, order data associating transaction categories, scheduled shipping dates, store codes, stores, and scheduled shipping figures for each slip number, and scheduled arrival data associating transaction categories, scheduled arrival dates, store codes, stores, and scheduled arrival figures for each slip number, and the replenishment order assistance device references the sales data and the calendar master executed by the control unit and prompts a user to a calculation step of generating aggregated data by aggregating the sales volume and average daily sales volume for each weekday, weekend, and holiday for one month for a product corresponding to the product code based on the order date, product code, and store code input by a user; a first calculation step of calculating a planned inventory quantity for the product on the planned arrival date based on the sales data, the current stock data, the order data, the expected arrival data, and the aggregated data; a determination step of determining whether the planned inventory quantity is equal to or less than a predetermined quantity; a second calculation step of calculating a suggested replenishment quantity for the product based on the planned inventory quantity if it is determined that the planned inventory quantity is equal to or less than the predetermined quantity; and an output control step of outputting the suggested replenishment quantity.

[0009] A replenishment order assistance program according to the present invention is a replenishment order assistance program to be executed by a replenishment order assistance device having a control unit, the replenishment order assistance device being able to access sales data associating store codes, stores, and sales figures for each sales date, a calendar master associating store codes, stores, holiday categories, and store closure categories for each date, current stock data associating product codes and current stock figures for each store, order data associating transaction categories, scheduled shipping dates, store codes, stores, and scheduled shipping figures for each slip number, and scheduled arrival data associating transaction categories, scheduled arrival dates, store codes, stores, and scheduled arrival figures for each slip number, and the control unit is configured to refer to the sales data and the calendar master and the order date, the product code, and the store code input by the user, to generate aggregated data summarizing the sales volume and average daily sales volume for each weekday, weekend, and holiday for one month for the product corresponding to the product code; a first calculation step of calculating a planned stock quantity for the product on the planned arrival date based on the sales data, the current stock data, the order data, the planned arrival data, and the aggregated data; a determination step of determining whether the planned stock quantity is equal to or less than a predetermined quantity; a second calculation step of calculating a suggested replenishment quantity for the product based on the planned stock quantity when it is determined that the planned stock quantity is equal to or less than the predetermined quantity; and an output control step of outputting the suggested replenishment quantity. Effect of the Invention

[0010] According to the present invention, it is possible to perform a replenishment ordering task for products with simple operations, regardless of the experience level of an ordering person. [Brief description of the drawings]

[0011] [Figure 1] FIG. 1 is a schematic diagram showing an overview in a block diagram of an example of the configuration of a replenishment order assisting device according to an embodiment. [Diagram 2] FIG. 2 is a diagram showing an example of a calendar master table in the calendar master included in the replenishment order assisting device according to the embodiment. [Diagram 3] FIG. 3 is a diagram showing an example of a product master table in the product master included in the replenishment order assisting device according to the embodiment. [Figure 4] FIG. 4 is a diagram showing an example of a warehousing data table in the warehousing data provided in the replenishment order assisting device according to the embodiment. [Diagram 5] FIG. 5 is a diagram showing an example of a delivery data table in the delivery data provided in the replenishment order assisting device according to the embodiment. [Figure 6] FIG. 6 is a diagram showing an example of a sales data table in the sales data included in the replenishment order assisting device according to the embodiment. [Figure 7] FIG. 7 is a diagram showing an example of a current stock data table in the current stock data included in the replenishment order assisting device according to the embodiment. [Figure 8] FIG. 8 is a diagram showing an example of an order data table in the order data stored in the replenishment order assisting device according to the embodiment. [Figure 9] FIG. 9 is a diagram showing an example of a scheduled arrival data table in the arrival data included in the replenishment order assisting device according to the embodiment. [Figure 10] FIG. 10 is a flow chart showing an outline of the result registration process executed by the replenishment order assisting device. [Figure 11] FIG. 11 is a flowchart showing an outline of a product master registration process executed by the replenishment order assisting device according to the embodiment. [Figure 12] FIG. 12 is a diagram showing an example of the product master image screen. [Figure 13] FIG. 13 is a flowchart showing an outline of a replenishment order assisting process executed by the replenishment order assisting device according to the embodiment. [Figure 14] FIG. 14 is a diagram showing an example of the warehouse ordering screen. [Figure 15] FIG. 15 is a diagram showing an example of a method for calculating the theoretical stock of each day by the theoretical stock calculation unit included in the replenishment order assisting device according to the embodiment. [Figure 16]FIG. 16 is a diagram illustrating an example of the tabulated data generated by the tabulation unit included in the replenishment order assisting device according to the embodiment. [Figure 17] FIG. 17 is a diagram showing an example of a planned inventory inquiry screen. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0012] Hereinafter, an embodiment of a replenishment order assisting device, a replenishment order assisting method, and a replenishment order assisting program according to the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to the embodiment.

[0013] [1. Configuration] An example of the configuration of a replenishment order assisting device according to this embodiment will be described with reference to Fig. 1 etc. Fig. 1 is a schematic diagram showing an overview in a block diagram of an example of the configuration of a replenishment order assisting device.

[0014] The replenishment order assisting device 100 shown in Fig. 1 is a commercially available desktop personal computer. Note that the replenishment order assisting device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.

[0015] The replenishment order assistance device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the replenishment order assistance device 100 are communicatively connected via any communication path.

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

[0017] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0018] The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used as the storage unit 106. The storage unit 106 stores a calendar master 106a, a product master 106b, inventory data 106c, inventory outgoing data 106d, sales data 106e, current inventory data 106f, order data 106g, and arrival schedule data 106h.

[0019] The calendar master 106a stores a store code, a store name, a holiday category, and a store closure category in association with each date.

[0020] 2 is a diagram showing an example of a calendar master table in the calendar master 106a. As shown in the first row of the calendar master table T1 shown in FIG. 2, the date "2023 / 12 / 31" is stored in association with the store code "0001", the store "Nakamaru Shinjuku store", the holiday category "Saturdays, Sundays, and holidays", and the store closure category "Open". Note that in FIG. 2, in order to simplify the explanation, the case of one store is described, but the present invention is not limited to this, and the information is stored for each of multiple stores.

[0021] The product master 106b stores product codes in association with order units, product replenishment rates set by an ordering person, and maximum stock quantities.

[0022] Fig. 3 is a diagram showing an example of a product master table in the product master 106b. In the first row of the product master table T2 shown in Fig. 3, a product code "A1001" is stored in association with a unit "1 bag", a product replenishment rate "20%", and a maximum stock quantity "500". Note that in Fig. 3, the case of one product is described for the sake of simplicity, but the present invention is not limited to this, and the settings or storage may be made for multiple products.

[0023] The inventory data 106c stores a slip number in association with a transaction type, a line, an inventory date, a store code, a store, and an inventory quantity.

[0024] FIG. 4 is a diagram showing an example of a warehousing data table in the warehousing data 106c. As shown in the first row of the warehousing data table T3 in FIG. 4, the transaction category "warehousing", row "1", warehousing date "2023 / 7 / 5", store code "0001", store "Nakamaru Shinjuku store", and warehousing quantity "180" are stored in association with the slip number "NK0001". Note that in FIG. 4, the case of one store is described for the sake of simplicity, but the present invention is not limited to this, and data is stored for each of multiple stores.

[0025] The shipping data 106d stores a slip number in association with a transaction type, a line, a shipping date, a store code, a store, and a shipping quantity.

[0026] FIG. 5 is a diagram showing an example of an outgoing data table in the outgoing data 106d. As shown in the first row of the outgoing data table T4 in FIG. 5, the transaction category "outgoing", row "1", entry date "2023 / 7 / 4", store code "0001", store "Nakamaru Shinjuku store", and outgoing quantity "30" are stored in association with the slip number "SK0001". Note that in FIG. 5, the case of one store is described for the sake of simplicity, but the present invention is not limited to this, and data is stored for each of multiple stores.

[0027] The sales data 106e stores a slip number in association with a transaction type, line, sales date, store code, store, and sales amount.

[0028] 6 is a diagram showing an example of a sales data table in the sales data 106e. As shown in the first row of the sales data table T5 in FIG. 6, the transaction category "POS sales", row "1", stocking date "2023 / 7 / 3", store code "0001", store "Nakamaru Shinjuku store", and stocking quantity "60" are stored in association with the slip number "UR0001". Note that in FIG. 6, the case of one store is described for the sake of simplicity, but the present invention is not limited to this, and data may be stored for multiple stores.

[0029] The current stock data 106f stores a store code in association with a product code and a current stock quantity.

[0030] Fig. 7 is a diagram showing an example of a current stock data table in the current stock data 106f. As shown in the first row of the current stock data table T6 shown in Fig. 7, the store code "0001" is associated with the product code "A1001" and the current stock "200" and stored. Note that in Fig. 7, the case of one product is described for the sake of simplicity, but the present invention is not limited to this, and the data is stored for each of a plurality of stores.

[0031] The order data 106g stores a slip number in association with a transaction type, a line, a scheduled shipping date, a store code, a store, and a scheduled shipping quantity.

[0032] FIG. 8 is a diagram showing an example of an order data table in the order data 106g. As shown in the first row of the order data table T7 in FIG. 8, the transaction category "scheduled shipping", row "1", stocking date "2023 / 7 / 12", store code "0001", store "Nakamaru Shinjuku store", and number of items shipped "5" are stored in association with the slip number "JU0001". Note that in FIG. 8, the case of one store is described for the sake of simplicity, but the present invention is not limited to this, and data may be stored for multiple stores.

[0033] The expected arrival data 106h stores a slip number in association with a transaction type, a line, an expected arrival date, a store code, a store, and an expected arrival quantity.

[0034] FIG. 9 is a diagram showing an example of a scheduled arrival data table in the scheduled arrival data 106h. As shown in the first row of the scheduled arrival data table T8 in FIG. 9, the transaction category "scheduled arrival", row "1", stocking date "2023 / 7 / 13", store code "0001", store "Nakamaru Shinjuku store", and number of shipments "10" are stored in association with the slip number "NY0001". Note that in FIG. 9, the case of one store is described for the sake of simplicity, but the present invention is not limited to this, and data may be stored for each of multiple stores.

[0035] Returning to FIG. 1, the description of the configuration of the replenishment order assisting device 100 will be continued. The control unit 102 is a CPU or the like that controls the replenishment order assisting device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, and the like, and executes various information processing based on these stored programs. The control unit 102 includes an incoming input unit 102a, an outgoing input unit 102b, a sales input unit 102c, a setting unit 102d, an order input unit 102e, a warehouse order input unit 102f, a theoretical stock calculation unit 102g, a counting unit 102h, a first calculation unit 102i, a determination unit 102j, a second calculation unit 102k, and an output control unit 102l.

[0036] The inventory input unit 102a executes an inventory input process to acquire inventory data 106c corresponding to a designated period based on the order date input by the ordering clerk via the input device 112. Specifically, the inventory input unit 102a acquires inventory data 106c from the past week to the order date.

[0037] The outgoing goods input unit 102b executes outgoing goods input processing to acquire outgoing goods data 106d corresponding to a designated period based on the order date input by the ordering clerk via the input device 112. Specifically, the outgoing goods input unit 102b acquires outgoing goods data 106d from the past week to the order date.

[0038] The sales input unit 102c executes a sales input process to acquire sales data 106e corresponding to a designated period based on the order date input by the orderer via the input device 112. Specifically, the sales input unit 102c acquires sales data 106e from the past week to the order date.

[0039] The setting unit 102d sets a product master 106b including the product replenishment rate, maximum stock quantity, and unit of the product linked to the product code in accordance with the input contents entered by a user such as an orderer via the input device 112, and stores the set in the memory unit 106.

[0040] The order input unit 102e executes an order input process to acquire order data based on the operation contents input by the ordering clerk via the input device 112.

[0041] When a start-up operation for starting a warehouse order screen is performed via the input device 112, the warehouse order input unit 102f displays the warehouse order screen on the monitor 114. In addition, the warehouse order input unit 102f acquires arrival schedule data 106h from the storage unit 106.

[0042] The theoretical stock calculation unit 102g executes a theoretical stock quantity calculation process to calculate the theoretical stock quantity of the product from the order date designated by the orderer up to one week prior.

[0043] The aggregation unit 102h executes an average sales calculation process to generate aggregated data by aggregating the sales figures for weekdays, Saturdays, Sundays, and holidays and the average daily sales figures for a month for a product corresponding to a product code, based on the calendar master 106a, the sales data 106e, and the order date, product code, and store code selected by the user.

[0044] The first calculation unit 102i calculates the expected stock quantity of the product on the expected arrival date based on the sales data 106e, the current stock data 106f, the order data 106g, the expected arrival data 106h, and the aggregated data.

[0045] The determining unit 102j determines whether the expected inventory quantity calculated by the first calculating unit 102i is equal to or less than a predetermined value. Here, the predetermined value can be appropriately set by an orderer, a store manager, a system manager, or the like, and can be set to 0 in a small store and 10 in a large store, for example.

[0046] The second calculation unit 102k executes a predicted inventory quantity calculation process to calculate a predicted inventory quantity for the day after the order date specified by the orderer. The second calculation unit 102k executes a replenishment proposal quantity calculation process to calculate a replenishment proposal quantity by referring to the product master 106b. Here, the replenishment proposal quantity is a quantity that is estimated to be the quantity for which it is better to prepare for inventory replenishment at the store by calculating a predicted inventory shortage quantity by taking into account receipts and payments or average sales volume scheduled after the order date.

[0047] The output control unit 102l displays on the monitor 114 a planned inventory inquiry screen including information based on forecast numbers including the planned inventory number calculated by the first calculation unit 102i and the replenishment proposal number and forecasted inventory number calculated by the second calculation unit 102k, and information based on actual numbers including the theoretical inventory number calculated by the theoretical inventory calculation unit 102g.

[0048] [2. Recording process executed by the replenishment order assistance device] Next, the result registration process executed by the replenishment order assistance device 100 will be described. FIG. 10 is a flow chart showing an outline of the result registration process executed by the replenishment order assistance device 100. Note that FIG. 10 describes the contents of acquiring data from the past week up to the present day (July 10th) based on July 10th (hereinafter simply referred to as "the present day"), which is specified as the ordering date by the ordering person in the replenishment order assistance process described below. Also, in the following explanation, for the sake of simplicity, a single product will be described. Furthermore, while FIG. 10 describes the result registration process for a single product, the result registration process is executed for each product according to the operation of the ordering person.

[0049] As shown in Fig. 10, first, the inventory input unit 102a executes an inventory input process (step S101) to acquire inventory data 106c (see inventory data table T3 in Fig. 4) corresponding to a designated period based on the order date input by the ordering clerk via the input device 112. In this case, as shown in the inventory data table T3 in Fig. 4, the inventory input unit 102a acquires inventory data 106c from the past week to the current day (July 10th).

[0050] Next, the outgoing order input unit 102b executes outgoing order input processing to acquire outgoing order data 106d (see outgoing order data table T4 in FIG. 5) corresponding to a designated period based on the order date input by the ordering clerk via the input device 112 (step S102). In this case, as shown in the outgoing order data table T4 in FIG. 5, the outgoing order input unit 102b acquires outgoing order data 106d from the past week to the present day (July 10).

[0051] Thereafter, the sales input unit 102c executes a sales input process to acquire sales data 106e (see sales data table T5 in FIG. 6) corresponding to a designated period based on the order date input by the orderer via the input device 112 (step S103). In this case, as shown in the sales data table T5 in FIG. 6, the sales input unit 102c acquires sales data 106e from the past week to the current day (July 10th). After step S103, the replenishment order assistance device 100 ends this process.

[0052] [3. Product master registration process executed by the replenishment order assistance device] Next, a description will be given of the product master registration process executed by the replenishment order assistance device 100. Fig. 11 is a flow chart showing an outline of the product master registration process executed by the replenishment order assistance device 100. Note that Fig. 11 describes one product master registration process, but the product master 106b is set for each product.

[0053] As shown in FIG. 11, first, the setting unit 102d displays a product master image screen on the monitor 114 (step S201). FIG. 12 is a diagram showing an example of the product master image screen. The product master image screen P1 shown in FIG. 12 includes an input cell A1 for inputting a product code, a product name cell A2 for displaying the product name linked to the product code, a unit cell A3 linked to the product code, a product replenishment rate cell A4 in which a product replenishment rate can be input, and a maximum stock quantity cell A5 in which a maximum stock quantity can be input. Here, the product replenishment rate is a value for ordering not only the shortage of products but also the excess stock of products.

[0054] Next, the setting unit 102d sets the product master 106b including the product replenishment rate, maximum stock quantity, and unit of the product linked to the product code according to the contents of each cell entered by the user via the input device 112 (step S202). In this case, the setting unit 102d sets the product master table T2 of Fig. 3 described above and stores it in the storage unit 106. After step S202, the replenishment order assistance device 100 ends this process.

[0055] [4. Replenishment order assistance process executed by the replenishment order assistance device] Next, a description will be given of a replenishment order assisting process executed by the replenishment order assisting device 100. Fig. 13 is a flow chart showing an outline of the replenishment order assisting process executed by the replenishment order assisting device 100.

[0056] As shown in FIG. 13, first, the order input unit 102e executes an order input process to acquire the order data 106g based on the operation contents input by the ordering clerk via the input device 112 (step S301).

[0057] Next, when a start-up operation for starting a warehouse order screen is performed via the input device 112, the warehouse order input unit 102f displays the warehouse order screen on the monitor 114 (step S302). In this case, the warehouse order input unit 102f acquires the arrival schedule data 106h (for example, see the arrival schedule data table T8 in FIG. 9) from the storage unit 106.

[0058] Fig. 14 is a diagram showing an example of a warehouse ordering screen. The warehouse ordering screen P2 shown in Fig. 14 includes a store input cell A10 in which a store can be input, an order date cell A11 in which an order date can be input, a warehouse cell A12 in which a warehouse for ordering products can be input, and a details screen B1. Furthermore, the details screen B1 includes a planned inventory inquiry start icon A20 that accepts input of an instruction signal instructing a planned inventory inquiry.

[0059] Returning to FIG. 13, steps S303 and after will be described. In step S303, the determination unit 102j determines whether or not the ordering clerk has pressed the desired planned stock inquiry launch icon A20 via the input device 112. If the determination unit 102j determines that the ordering clerk has pressed the desired planned stock inquiry launch icon A20 via the input device 112 (step S303: Yes), the replenishment order assistance device 100 proceeds to step S304, which will be described later. On the other hand, if the determination unit 102j determines that the ordering clerk has not pressed the desired planned stock inquiry launch icon A20 via the input device 112 (step S303: No), the replenishment order assistance device 100 returns to the above-mentioned step S302.

[0060] In step S304, the theoretical stock calculation unit 102g executes a theoretical stock quantity calculation process to calculate the theoretical stock quantity of the product from July 10th specified by the orderer until one week before.

[0061] Fig. 15 is a diagram showing an example of a method for the theoretical inventory calculation unit 102g to calculate the theoretical inventory for each day. As shown in Fig. 15, first, the theoretical inventory calculation unit 102g calculates the theoretical inventory quantity of the product on July 9th designated by the ordering person. Specifically, the theoretical inventory calculation unit 102g calculates the theoretical inventory quantity of the product on July 9th using the following formula (1) based on the data for July 10th in the current inventory data 106f, the sales data 106e, the outgoing inventory data 106d, and the incoming inventory data 106c. Theoretical inventory quantity = current inventory quantity + today's sales quantity + today's shipment quantity - today's arrival quantity (1) Therefore, as shown in FIG. 15, in the case of July 9, the theoretical stock calculation unit 102g calculates the theoretical stock quantity as follows, using the above-mentioned formula (1). 200=200+150+50-200

[0062] 15, the theoretical inventory calculation unit 102g calculates the theoretical inventory quantity for each day from July 8 to July 3 based on the above-mentioned formula (1) and the sales data 106e, shipment data 106d, and arrival data 106c for each of July 9 to July 4. In this case, the theoretical inventory calculation unit 102g calculates the theoretical inventory quantity by sequentially using the sales data 106e, shipment data 106d, and arrival data 106c up to July 9, based on the date for calculating each theoretical inventory quantity.

[0063] For example, as shown in FIG. 15, when calculating the theoretical inventory quantity on July 8th, the theoretical inventory calculation unit 102g calculates the theoretical inventory quantity on July 8th using the data (200, 150, 50) of sales data 106e, shipment data 106d, and inventory data 106c for July 10th, and the data (280, 0, 450) of sales data 106e, shipment data 106d, and inventory data 106c for July 9th.

[0064] In this way, the theoretical stock calculation unit 102g calculates the theoretical stock quantity for each day from July 8 to July 3 based on the above-mentioned formula (1) and the sales data 106e, the shipment data 106d, and the arrival data 106c for each of July 9 to July 4. After step S304, the replenishment order assistance device 100 proceeds to step S305, which will be described later.

[0065] Returning to FIG. 13, the description of step S305 and subsequent steps will be continued. In step S305, the aggregation unit 102h executes an average sales calculation process to generate aggregated data by aggregating the sales figures and average daily sales figures for weekdays, Saturdays, Sundays, and holidays for one month for the product corresponding to the product code, based on the calendar master 106a, the sales data 106e, and the order date, product code, and store code selected by the user.

[0066] FIG. 16 is a diagram showing an example of the aggregated data generated by the aggregation unit 102h. As shown in FIG. 16, the aggregation unit 102h generates an aggregated data table T10 of aggregated data obtained by aggregating the sales numbers and average daily sales numbers for weekdays, Saturdays, Sundays, and holidays for one month (from July 9 to June 10) for a product corresponding to a product code based on the calendar master table T1 of the calendar master 106a, the sales data table T5 of the sales data 106e, and the order date, product code, and store code selected by the user. In this case, the aggregation unit 102h aggregates the sales numbers and average daily sales numbers for weekdays, Saturdays, Sundays, and holidays based on the business days of the store. After step S305, the replenishment order assisting device 100 proceeds to step S306, which will be described later.

[0067] Returning to FIG. 13, the description of step S306 and subsequent steps will be continued. In step S306, the first calculation unit 102i executes a planned inventory quantity calculation process to calculate the planned inventory quantity on the expected arrival date of the product based on the sales data 106e, the current stock data 106f, the order data 106g, the expected arrival data 106h, and the aggregated data. Specifically, the first calculation unit 102i calculates the planned inventory quantity for the day following the order date specified by the ordering clerk using the following formula (2). Expected inventory quantity = current inventory quantity - expected shipment quantity on the day - expected arrival quantity on the day - average sales quantity on the day - Next day shipping quantity + Next day arrival quantity - Next day average sales quantity (2) Therefore, in the case of July 11, the first calculation unit 102i calculates the planned inventory quantity as follows, using the above-mentioned formula (2). -50=200-50-0-100-0+0-100

[0068] Next, the determination unit 102j determines whether the expected stock quantity calculated by the first calculation unit 102i is equal to or less than a predetermined value (step S307). Specifically, the determination unit 102j determines whether the expected stock quantity calculated by the first calculation unit 102i is equal to or less than 0. The predetermined value is not limited to 0, and can be appropriately set by an orderer, a store manager, a system manager, or the like. For example, in a large store, the predetermined value can be set to 10. If the determination unit 102j determines that the expected stock quantity calculated by the first calculation unit 102i is equal to or less than the predetermined value (step S307: Yes), the replenishment order assistance device 100 proceeds to step S308, which will be described later. On the other hand, if the determination unit 102j determines that the expected stock quantity calculated by the first calculation unit 102i is not equal to or less than the predetermined value (step S307: No), the replenishment order assistance device 100 proceeds to step S310, which will be described later.

[0069] In step S308, the second calculation unit 102k executes a replenishment proposal quantity calculation process to calculate the replenishment proposal quantity by referring to the product master 106b (see the product master table T2 in FIG. 3). Specifically, the second calculation unit 102k calculates the replenishment proposal quantity by the following formula (3). Number of replenishment proposals = (0 - planned inventory quantity) × (1 + product replenishment rate) (3) Therefore, in the case of July 11, the second calculation unit 102k calculates the replenishment proposal quantity as follows, using the above-mentioned formula (3). 60=(0-(-50))×(1+0.2) It should be noted that the second calculation unit 102k does not calculate the replenishment proposal quantity for that day (July 10).

[0070] Next, the second calculation unit 102k executes a predicted inventory calculation process to calculate a predicted inventory quantity for the day after the order date (July 10) specified by the orderer (July 11) (step S309). Specifically, the second calculation unit 102k calculates the predicted inventory quantity by the following formula (4). Projected inventory quantity = Next day's planned inventory quantity + Replenishment proposal quantity (4) Therefore, when the judgment unit 102j judges that the planned inventory quantity calculated by the first calculation unit 102i is less than or equal to 0, on July 11th, the second calculation unit 102k calculates the predicted inventory quantity using the above-mentioned equation (4) as follows: 10=-50+60

[0071] In step S310, if the determining unit 102j determines that the planned inventory quantity calculated by the first calculating unit 102i is not equal to or less than the predetermined value, the second calculating unit 102k calculates the predicted inventory quantity for the day after the order date specified by the ordering person. In this case, since the determining unit 102j determines that the planned inventory quantity calculated by the first calculating unit 102i is not equal to or less than the predetermined value, the second calculating unit 102k does not calculate the replenishment proposal quantity, but calculates the planned inventory quantity as the predicted inventory quantity. After step S310, the replenishment order assisting device 100 proceeds to step S311.

[0072] Next, the determination unit 102j determines whether the calculation of the predicted stock quantity, the replenishment proposal quantity, and the predicted stock quantity for each day in the specified period including the order date specified by the ordering person (period from July 10 to July 16) has been completed (step S311). If the determination unit 102j determines that the calculation of the predicted stock quantity, the replenishment proposal quantity, and the predicted stock quantity for each day in the specified period including the order date specified by the ordering person has been completed (step S311: Yes), the replenishment order assistance device 100 proceeds to step S312 described below. On the other hand, if the determination unit 102j determines that the calculation of the predicted stock quantity, the replenishment proposal quantity, and the predicted stock quantity for each day in the specified period including the order date specified by the ordering person has not been completed (step S311: No), the replenishment order assistance device 100 proceeds to step S306 described above.

[0073] Here, when the judgment unit 102j judges that the calculation of the predicted inventory quantity, replenishment proposal quantity, and predicted inventory quantity for the specified period including the order date specified by the ordering person has not been completed (step S311: No), the contents calculated by the first calculation unit 102i and the second calculation unit 102k will be described in detail.

[0074] First, in the case of July 12, which is the day after July 11, the first calculation unit 102i calculates the planned inventory quantity for July 12 as follows, using the following formula (5). Planned inventory quantity = Predicted inventory quantity the day before - Planned shipment quantity the day after + Planned arrival quantity the day after - Average sales quantity the day after (5) Therefore, in the case of July 12, the first calculation unit 102i calculates the planned inventory quantity as follows, using the above-mentioned formula (5). -95=10 (projected inventory for July 11) -5 (planned shipments for July 12) +0 (expected stock on July 12) -100 (average sales on July 12)

[0075] Furthermore, in the case of July 12, when the judgment unit 102j judges that the planned inventory quantity calculated by the first calculation unit 102i is less than or equal to 0, the second calculation unit 102k calculates the replenishment proposal quantity as follows, using the above-mentioned formula (3). 114=0-(-95)×(1+0.2) Then, using the above-mentioned formula (4), the second calculation unit 102k calculates the predicted stock quantity as follows. 19 = -95 (estimated inventory on July 12) + 114

[0076] In this way, when the first calculation unit 102i and the second calculation unit 102k calculate the predicted inventory quantity, replenishment proposal number, and predicted inventory quantity for the specified period including the order date specified by the ordering person by the judgment unit 102j, they calculate the predicted inventory quantity, replenishment proposal number, and predicted inventory quantity for each calculation date using the predicted inventory quantity, replenishment proposal number, and predicted inventory quantity for the previous day, which are calculated sequentially based on the calculation date.

[0077] In step S312, the output control unit 102l displays on the monitor 114 a planned inventory inquiry screen including information based on forecast numbers including the planned inventory number calculated by the first calculation unit 102i and the replenishment proposal number and forecasted inventory number calculated by the second calculation unit 102k, and information based on actual numbers including the theoretical inventory number calculated by the theoretical inventory calculation unit 102g.

[0078] FIG. 17 is a diagram showing an example of a planned inventory inquiry screen that the output control unit 102l displays on the monitor 114. The planned inventory inquiry screen P3 shown in FIG. 17 includes information D1 based on the predicted number including the planned inventory number calculated by the first calculation unit 102i, the replenishment proposal number and the predicted inventory number calculated by the second calculation unit 102k, and information D2 based on the actual number including the theoretical inventory number calculated by the theoretical inventory calculation unit 102g. This allows the ordering person to order products while checking the predicted inventory number, average sales number and replenishment proposal number on the planned inventory inquiry screen P3 regardless of the ordering experience value, so that the ordering person can perform the replenishment ordering work of products with simple operations. After step S312, the replenishment ordering assistance device 100 ends this process.

[0079] According to the embodiment described above, the output control unit 102l displays the replenishment proposal quantity calculated by the second calculation unit 102k on the monitor 114, so that the replenishment ordering work for products can be performed with simple operations regardless of the experience level of the ordering staff.

[0080] Furthermore, according to the embodiment, the second calculation unit 102k calculates the suggested replenishment quantity by multiplying the planned inventory quantity by the product replenishment rate, and therefore not only proposes a replenishment order for only the shortage, but also proposes ordering products including the surplus, making it possible to perform replenishment ordering operations that eliminate stockouts without relying on the experience of the ordering clerk.

[0081] Furthermore, according to the embodiment, the setting unit 102d sets the product master 106b including the product replenishment rate, maximum stock quantity, and unit of the product linked to the product code in accordance with the input contents entered by a user such as an ordering clerk via the input device 112, so that the product replenishment rate and the maximum stock quantity of the store can be set with a single operation.

[0082] In addition, according to the embodiment, the second calculation unit 102k further calculates the predicted stock quantity based on the planned stock quantity and the replenishment proposal quantity, and the output control unit 102l displays the predicted stock quantity on the monitor 114, so that the ordering person can intuitively grasp the predicted stock quantity.

[0083] According to the embodiment, the first calculation unit 102i calculates the planned stock quantity for each day from the day after the order date to the specified period, the second calculation unit 102k calculates the proposed replenishment quantity for each day from the day after the order date to the specified period based on the predicted stock quantity for each day from the day after the order date to the specified period, and calculates the predicted stock quantity for each day from the day after the order date to the specified period based on the planned stock quantity and the proposed replenishment quantity for each day from the day after the order date to the specified period. As a result, the ordering person can intuitively grasp the stock shortage for each day, and can intuitively grasp the proposed replenishment quantity and the predicted stock quantity.

[0084] Furthermore, according to the embodiment, the theoretical inventory calculation unit 102g calculates the theoretical inventory quantity for each past day, and the output control unit 102l outputs the theoretical inventory quantity for each day, allowing the ordering staff to grasp the movement of products for the past week, including the current day.

[0085] Furthermore, according to the embodiment, the output control unit 102l outputs the maximum stock quantity, so that the ordering staff can perform the replenishment ordering work of the products while referring to the maximum stock quantity set according to the store space, thereby preventing the ordering of more products than are necessary.

[0086] [5. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to goals 8 and 9 of the SDGs.

[0087] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0088] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

[0089] 6. Other embodiments The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0090] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

[0091] In addition, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.

[0092] Moreover, with regard to the replenishment order assisting device 100, the components shown in the figures are merely conceptual functional elements, and the device does not necessarily have to be physically configured as shown in the figures.

[0093] For example, the processing functions of the replenishment order assisting device 100, particularly the processing functions performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded on a non-transient computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the replenishment order assisting device 100 as necessary. 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 HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form the control unit.

[0094] In addition, this computer program may be stored in an application program server connected to the replenishment ordering assistance device 100 via any network, and it is also possible to download all or part of it as needed.

[0095] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.

[0096] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, may use well-known configurations and procedures.

[0097] The various databases etc. stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files etc. used for various processes and providing websites.

[0098] The replenishment order assisting device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as the information processing device to which any peripheral device is connected. The replenishment order assisting device 100 may be realized by installing software (including programs, data, etc.) that causes the device to realize the processes described in this embodiment.

[0099] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]

[0100] The present invention is useful in industries where merchandise is ordered from multiple stores, such as the retail industry. [Explanation of symbols]

[0101] 100 Replenishment aid 102 Control section 102a Stock entry section 102b Outlet input section 102c Sales input section 102d Setting section 102e Order Entry Section 102f Warehouse order input section 102g Theoretical inventory calculation section 102h Counting section 102i 1st calculation section 102j Judgment section 102k Second calculation section 102l Output control section 104 Communication interface section 106 Storage section 106a Calendar Master 106b Product master 106c Stock Data 106d Shipping Data 106e Sales Data 106f Current Stock Data 106g Order Data 106h Arrival Schedule Data 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

1. A replenishment order assist device including a control unit, Sales data that corresponds to store codes, stores, and sales figures for each sales date, A calendar master in which store codes, stores, holiday categories, and store closure categories are associated with each date; Current inventory data that associates product codes and current inventory quantities for each store, Order data that corresponds to transaction type, scheduled shipping date, store code, store, and scheduled shipping quantity for each slip number, For each slip number, transaction type, expected arrival date, store code, store, and expected number of items in stock are associated with each other. is accessible to The control unit is a counting unit that references the sales data and the calendar master, and generates count data by counting the number of sales on weekdays, Saturdays, Sundays, and holidays, and the average number of sales per day for a month for a product corresponding to a product code, based on an order date, a product code, and a store code input by a user; a first calculation unit that calculates a planned inventory quantity of the product on a planned arrival date based on the sales data, the current inventory data, the order data, the planned arrival data, and the aggregated data; A determination unit that determines whether the planned inventory quantity is equal to or less than a predetermined value; a second calculation unit that calculates a suggested replenishment quantity of the product based on the planned inventory quantity when it is determined that the planned inventory quantity is equal to or less than a predetermined value; an output control unit that outputs the number of replenishment suggestions; To have A replenishment ordering assistance device comprising:

2. 2. The replenishment order assist device according to claim 1, The system further has access to a product master in which a product replenishment rate for maintaining a margin in the inventory of the product and a maximum inventory quantity of the product that can be stocked in the store are associated with each product code; The second calculation unit, Calculating the suggested replenishment quantity based on the planned inventory quantity and the product replenishment rate; A replenishment ordering assistance device comprising:

3. 3. The replenishment order assist device according to claim 2, Further comprising a setting unit that sets the product replenishment rate based on an operation input from outside; A replenishment ordering assistance device comprising:

4. 4. The replenishment order assist device according to claim 3, The second calculation unit, Further calculating a projected inventory quantity based on the planned inventory quantity and the suggested replenishment quantity; The output control unit is further outputting the predicted inventory quantity; A replenishment ordering assistance device comprising:

5. 5. The replenishment order assist device according to claim 4, The first calculation unit, Calculate the expected inventory quantity for each day from the day after the order date until a predetermined period, The second calculation unit, Calculating the replenishment proposal quantity for each day from the day after the order date to a predetermined period based on the predicted inventory quantity for each day from the day after the order date to a predetermined period; and calculating the predicted inventory quantity for each day from the day after the order date to a specified period based on the planned inventory quantity and the proposed replenishment quantity for each day from the day after the order date to a specified period; The output control unit is outputting the planned inventory quantity for each day from the day after the order date until a predetermined period, the planned inventory quantity for each day from the day after the order date until a predetermined period, and the predicted inventory quantity for each day from the day after the order date until a predetermined period; A replenishment ordering assistance device comprising:

6. 6. The replenishment order assist device according to claim 5, The receipt data, which corresponds to the slip number, transaction type, receipt date, store code, store, and quantity received, The outgoing data, which corresponds to the slip number, transaction type, outgoing date, store code, store, and incoming quantity, is accessible to a theoretical inventory calculation unit that calculates a theoretical inventory quantity for each day in the past during a predetermined period from the order date based on the incoming data, the outgoing data, the sales data, and the current inventory data, The output control unit is outputting the theoretical inventory quantity for each past day within a predetermined period from the order date; A replenishment ordering assistance device comprising:

7. 6. The replenishment order assist device according to claim 5, The output control unit is outputting the maximum inventory quantity; A replenishment ordering assistance device comprising:

8. A replenishment order assistance method executed by a replenishment order assistance device having a control unit, The replenishment order assistance device is Sales data that corresponds to store codes, stores, and sales figures for each sales date, A calendar master in which store codes, stores, holiday categories, and store closure categories are associated with each date; Current inventory data that associates product codes and current inventory quantities for each store, Order data that corresponds to transaction type, scheduled shipping date, store code, store, and scheduled shipping quantity for each slip number, For each slip number, transaction type, expected arrival date, store code, store, and expected number of items in stock are associated with each other. is accessible to Executed by the control unit, an aggregation step of generating aggregate data by referencing the sales data and the calendar master, and aggregating the sales volume and average daily sales volume for each weekday, Saturday, Sunday, and holiday for one month for a product corresponding to the product code based on the order date, product code, and store code input by a user; a first calculation step of calculating a planned inventory quantity of the product on a planned arrival date based on the sales data, the current inventory data, the order data, the planned arrival data, and the aggregated data; a determination step of determining whether the planned inventory quantity is equal to or less than a predetermined quantity; a second calculation step of calculating a suggested replenishment quantity of the product based on the planned inventory quantity when it is determined that the planned inventory quantity is equal to or less than a predetermined quantity; an output control step of outputting the replenishment suggestion number; containing, A replenishment order assistance method comprising the steps of:

9. A replenishment order assistance program to be executed by a replenishment order assistance device having a control unit, The replenishment order assist device is Sales data that corresponds to store codes, stores, and sales figures for each sales date, A calendar master in which store codes, stores, holiday categories, and store closure categories are associated with each date; Current inventory data that associates product codes and current inventory quantities for each store, Order data that corresponds to transaction type, scheduled shipping date, store code, store, and scheduled shipping quantity for each slip number, For each slip number, transaction type, expected arrival date, store code, store, and expected number of items in stock are associated with each other. is accessible to The control unit, an aggregation step of generating aggregate data by referencing the sales data and the calendar master, and aggregating the sales volume and average daily sales volume for each weekday, Saturday, Sunday, and holiday for one month for a product corresponding to the product code based on the order date, product code, and store code input by a user; a first calculation step of calculating a planned inventory quantity of the product on a planned arrival date based on the sales data, the current inventory data, the order data, the planned arrival data, and the aggregated data; a determination step of determining whether the planned inventory quantity is equal to or less than a predetermined quantity; a second calculation step of calculating a suggested replenishment quantity of the product based on the planned inventory quantity when it is determined that the planned inventory quantity is equal to or less than a predetermined quantity; an output control step of outputting the replenishment suggestion number; A replenishment ordering assistance program to execute the above.

Images