JP7633364B2 - Information processing device, information processing method, and program - Google Patents

Description

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

In the retail business, sales are not only conducted in the company's own stores, but also at special events, such as a department store's limited-time end-of-year sale. After the event ends, sales staff use the point-of-sale (POS) registers at the event venue to determine the sales amount and transfer any unsold inventory to the head office.

Patent document 1 describes an inventory management device that, when managing the inventory quantity of items, can accurately grasp the current inventory quantity while grasping the existence of items that are scheduled to be moved and may be moved from the inventory.

JP 2018-112783 A

However, because the POS registers used at the event venue were not owned by the company, although the sales figures could be ascertained, sales figures for each product had to be calculated manually each day by sales staff in relation to unsold stock. In addition, even though the company had a store near the event venue, the stock information for the nearby store was not available, so unsold stock was moved to the head office instead of to the nearby store. This resulted in waste, such as having to move stock from the head office to the nearby store again.

The present invention has been made in consideration of the above, and aims to provide an inventory management support device, an inventory management support method, and an inventory management support program that, for example, when products are sold for a limited time at an event, can determine the number of sales by product from inventory information at the end of the period and select a destination for unsold inventory.

In order to solve the above-mentioned problems and achieve the object, the inventory management support device according to the present invention is an inventory management support device having a control unit, and is capable of accessing, for each sales location where a product is sold for a limited time, a transfer destination management master that manages warehouses or stores that are candidates for the transfer destination of the product after the period ends, and inventory data that manages the inventory number of the product for each warehouse or store and for each product, and the control unit is characterized by having: an import means for importing sales location inventory data including the inventory number of the product at a certain sales location after the period ends; an acquisition means for acquiring a transfer destination candidate linked to the certain sales location from the transfer destination management master and acquiring the inventory number of the product included in the sales location inventory data at the acquired transfer destination candidate from the inventory data; an output control means for outputting to an output device a screen on which the sales location inventory data and the data acquired by the acquisition means are displayed for each product in a selectable transfer destination; and a transfer data generation means for generating transfer data of the product from the certain sales location to the transfer destination selected on the screen, the transfer number including the inventory number after the period ends included in the sales location inventory data.

In the inventory management business support device according to the present invention, the sales location inventory data further includes the number of products in stock at the certain sales location before the start of a period, and the control unit further includes a calculation means for calculating the number of products sold at the certain sales location after the end of the period by subtracting the number of products in stock at the certain sales location after the end of the period from the number of products in stock at the certain sales location before the start of a period, and a sales data generation means for generating sales data including the number of products sold calculated by the calculation means.

The inventory management business support device according to the present invention is further capable of accessing shipping data for managing the products shipped to the sales location and the number of shipments for each sales location, and the control unit further includes a sales location initial inventory data generation means for acquiring the products and the number of shipments linked to the certain sales location from the shipping data, and generating sales location initial inventory data based on the acquired products and number of shipments in which the number of shipments is set as the number of products in stock at the certain sales location before the start of a period and in which the number of products in stock at the certain sales location after the end of the period can be set, and the sales location inventory data is characterized in that the number of products in stock at the certain sales location after the end of the period is set in the sales location initial inventory data.

The inventory management support method according to the present invention is an inventory management support method executed by an information processing device having a control unit, and the information processing device has access to a destination management master that manages, for each sales location where a product is sold for a limited period, a warehouse or store that is a candidate for the destination of the product after the period ends, and inventory data that manages the inventory quantity of the product for each warehouse or store and for each product. The method includes an import step executed by the control unit to import sales location inventory data including the inventory quantity of the product at a certain sales location after the period ends, an acquisition step to acquire destination candidates linked to the certain sales location from the destination management master and acquire the inventory quantity of the product included in the sales location inventory data at the acquired destination candidates from the inventory data, an output control step to output to an output device a screen on which the sales location inventory data and the data acquired in the acquisition step are displayed for each product in a selectable destination, and a movement data generation step to generate movement data of the product from the certain sales location to the destination selected on the screen, which includes the inventory quantity after the period ends and is included in the sales location inventory data.

The inventory management support program according to the present invention is an inventory management support program to be executed by an information processing device having a control unit, and the information processing device has access to a destination management master that manages, for each sales location where a product is sold for a limited time, a warehouse or store that is a candidate for the destination of the product after the period ends, and inventory data that manages the inventory number of the product for each warehouse or store and for each product. The program includes an import step for importing sales location inventory data including the inventory number of the product at a certain sales location after the period ends, which is executed by the control unit; an acquisition step for acquiring destination candidates linked to the certain sales location from the destination management master and acquiring the inventory number of the product included in the sales location inventory data at the acquired destination candidates from the inventory data; an output control step for outputting to an output device a screen on which the sales location inventory data and the data acquired in the acquisition step are displayed for each product in a selectable destination; and a movement data generation step for generating movement data of the product from the certain sales location to the destination selected on the screen, which includes the inventory number after the period ends and is included in the sales location inventory data.

According to the present invention, when a product is sold for a limited time, for example at an event, the number of sales by product can be ascertained from the inventory information at the end of the period, and the destination of unsold stock can be selected.

FIG. 1 is a block diagram showing an example of the configuration of an inventory management support device 100. As shown in FIG. FIG. 2 is a diagram showing an example of the shipping data 106a. FIG. 3 is a diagram showing an example of the event inventory data 106b. FIG. 4 is a diagram showing an example of the neighboring warehouse master 106c. FIG. 5 is a diagram showing an example of the inventory data 106d. FIG. 6 is a diagram showing an example of the movement data 106e. FIG. 7 is a diagram showing an example of the sales data 106f. FIG. 8 is a diagram showing an example of a flowchart relating to the processing executed by the inventory management operation support device 100. FIG. 9 is a diagram showing an example of the special event inventory data generation processing screen MA. FIG. 10 is a diagram showing an example of the event inventory data output screen MB for entry. FIG. 11 is a diagram showing an example of the event inventory data import transfer processing screen MC.

Below, an embodiment of an inventory management support device, an inventory management support method, and an inventory management support 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 this embodiment. In particular, in this embodiment, the "sales location where products are sold for a limited time" of the present invention will be described as an "event venue," but the present invention is not limited to this.

[1. Configuration]
Here, an example of the configuration of the inventory management operation support device 100 according to the present embodiment will be described with reference to Fig. 1 etc. Fig. 1 is a block diagram showing an example of the configuration of the inventory management operation support device 100.

The inventory management support device 100 is constructed based on a commercially available desktop personal computer. Note that the inventory management support 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, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

The inventory management support device 100 includes a control unit 102, a communication interface unit 104, a memory unit 106, and an input/output interface unit 108. Each unit of the inventory management support device 100 is connected to each other so that they can communicate with each other via any communication path.

The communication interface unit 104 communicatively connects the inventory management support 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 inventory management support 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.

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 works with a mouse to provide 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.

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

The memory unit 106 stores, for example, shipping data 106a, event inventory data 106b, nearby warehouse master 106c, inventory data 106d, movement data 106e, and sales data 106f.

Figure 2 is a diagram showing an example of the shipping data 106a. The shipping data 106a includes the shipping time (e.g., indicated by the date) when the product was shipped to the event venue, shipping source warehouse identification information (e.g., the name of the shipping source warehouse) that identifies the warehouse from which the product is shipped, event venue identification information (e.g., the event venue code or event venue name), product identification information (e.g., the product code or product name) that identifies the product, and the number of products shipped to the event venue.

Figure 3 is a diagram showing an example of event inventory data 106b. Event inventory data 106b (before entry) corresponds to the initial sales location inventory data of the present invention. Event inventory data 106b (after entry) corresponds to the sales location inventory data of the present invention. Event inventory data 106b includes business establishment identification information (e.g., business establishment code or business establishment name, etc.) that identifies the establishment selling the product, the time of inventory at the event venue (e.g., indicated by the date, month, and year), event venue identification information, product identification information, and the initial inventory quantity of the product at the event venue (before the start of the period), and the inventory quantity of the product inventoryed at the event venue after the end of the sales period at the event venue (e.g., the period during which a New Year's sale is held at the event venue) can be set.

Figure 4 is a diagram showing an example of the nearby warehouse master 106c. The nearby warehouse master 106c corresponds to the destination management master of the present invention. The nearby warehouse master 106c includes event venue identification information and destination identification information (e.g., the name of the warehouse or store) that identifies warehouses or stores that are candidates for destinations of inventory items that have been inventoried at the event venue after the sales period at the event venue ends. Note that warehouses or stores near the event venue, for example, may be set as destination candidates. Furthermore, the maximum number of destination candidates that can be set is not limited to five as shown in the figure, and may be more than this.

Figure 5 is a diagram showing an example of inventory data 106d. Inventory data 106d includes warehouse identification information that identifies a warehouse or store, product identification information, and the number of products in stock at the warehouse or store.

Figure 6 is a diagram showing an example of movement data 106e. Movement data 106e includes the shipping time of the product from the event venue to the destination warehouse or store, event venue identification information, destination identification information (e.g., the code or name of the destination warehouse or store), product identification information, and the number of products moved from the event venue to the destination warehouse or store.

Figure 7 is a diagram showing an example of sales data 106f. Sales data 106f includes the sales recording time (e.g., indicated by date) when sales of products sold at the event venue were recorded, event venue identification information, product identification information, and the number of products sold.

Returning to FIG. 1, the control unit 102 is a CPU or the like that provides overall control of the inventory management support 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, etc., and executes various information processing operations based on these stored programs.

The control unit 102, in terms of its functional concept, includes an event inventory data generation unit 102a which corresponds to the sales location initial inventory data generation means of the present invention, an import unit 102b which corresponds to the import means of the present invention, an acquisition unit 102c which corresponds to the acquisition means of the present invention, a calculation unit 102d which corresponds to the calculation means of the present invention, an output control unit 102e which corresponds to the output control means of the present invention, a movement data generation unit 102f which corresponds to the movement data generation means of the present invention, and a sales data generation unit 102g which corresponds to the sales data generation means of the present invention.

The event inventory data generating unit 102a acquires the products and shipment quantities linked to the sales location X from the shipping data 106a, and generates event inventory data 106b (before entry) based on the acquired products and shipment quantities, in which the shipment quantities are set as the inventory quantities of the products at the sales location X before the start of the period and in which the inventory quantities of the products at the sales location X after the end of the period can be set. For example, the event inventory data generating unit 102a sets the event venue code entered in the event inventory data generation processing screen MA (see FIG. 9), acquires the product code, product name, and shipment quantities linked to the set event venue code from the shipping data 106a, and generates event inventory data 106b (before entry) based on the acquired product code, product name, and shipment quantities.

The import unit 102b imports the event inventory data 106b (after entry) including the number of products in stock at the sales location X after the end of the period. For example, the import unit 102b imports the event inventory data 106b (after entry) of the file name entered in the event inventory data import transfer processing screen MC (see FIG. 11).

The acquisition unit 102c acquires candidate destinations linked to the sales location X from the nearby warehouse master 106c, and acquires the inventory quantity of products included in the event inventory data 106b (after entry) at the acquired candidate destinations from the inventory data 106d. For example, the acquisition unit 102c acquires from the nearby warehouse master 106c the warehouse name or store name associated with the event venue code entered in the event inventory data import transfer processing screen MC, and acquires from the inventory data 106d the inventory quantity of each product included in the event inventory data 106b (after entry) imported by the import unit 102b at the warehouse of the acquired warehouse name or the store of the acquired store name.

The calculation unit 102d calculates the sales quantity of the product at the sales location X after the period ends by subtracting the number of products in stock at the sales location X after the period ends from the number of products in stock at the sales location X before the period starts. For example, the calculation unit 102d calculates the sales quantity of each product at the event venue identified by the event venue code entered in the event inventory data import transfer processing screen MC by subtracting the number of products returned/inventory counted for each product included in the event inventory data 106b (after entry) imported by the import unit 102b from the current number of products in stock included in the event inventory data 106b (after entry) imported by the import unit 102b.

The output control unit 102e outputs to the output device 114 a screen on which the event inventory data 106b (after entry) and the data acquired by the acquisition unit 102c are displayed for each product with the destination selectable. For example, the output control unit 102e outputs to the monitor 114 an event inventory data import and transfer processing screen MC on which the event inventory data 106b (after entry) acquired by the acquisition unit 102b and the data acquired by the acquisition unit 102c are displayed for each product with the warehouse name or store name selectable.

The movement data generating unit 102f generates movement data of goods from the sales location X to the destination selected on the screen (output by the output control unit 102e), which includes the number of stock items after the end of the period included in the event inventory data 106b (after entry) as the movement number. For example, the movement data generating unit 102f generates movement data 106e regarding the movement of each item to a warehouse or store selected on the event inventory data import movement processing screen MC, which includes the actual number of shelves for each item.

The sales data generating unit 102g generates sales data 106f including the sales figures calculated by the calculation unit 102d. For example, the sales data generating unit 102g generates sales data 106f that manages the sales figures at the event venue identified by the event venue code entered in the event inventory data import transfer processing screen MC and that includes the sales figures for each product calculated by the calculation unit 102d.

Specific examples of the processing performed by each processing unit constituting the control unit 102 are described in detail below.

2. Specific examples of processing
Here, a specific example of the process executed by the inventory management support device 100 will be described with reference to Fig. 8 etc. Fig. 8 is a diagram showing an example of a flowchart relating to the process executed by the inventory management support device 100. Note that this description is based on the premise that the shipping data 106a shown in Fig. 2, the nearby warehouse master 106c shown in Fig. 4, and the inventory data 106d shown in Fig. 5 are stored in advance in the storage unit 106.

First, the operator inputs the establishment code, inventory date, and event venue code via the input device 112 into the event inventory data generation processing screen MA, which is pre-displayed on the monitor 114. In this explanation, it is assumed that "1" has been input as the establishment code, "2020/01/31" as the inventory date, and "10010" as the event venue code, as shown in the event inventory data generation processing screen MA in FIG. 9.

Next, the operator presses the "F9: Output" button at the bottom of the event inventory data generation processing screen MA in FIG. 9. When the "F9: Output" button is pressed, the event inventory data output screen MB to be filled in is displayed on the monitor 114. The operator inputs the file name of the event inventory data to be filled in, etc., via the input device 112 into the event inventory data output screen MB to be filled in displayed on the monitor 114. In this explanation, it is assumed that the file name "Event 2020/01/31_XX Department Store_Year-End Sale.xlsx" has been input, as shown in the event inventory data output screen MB in FIG. 10.

Then, the operator presses the "OK (0)" button at the bottom of the event inventory data output screen MB in Figure 10.

[Event inventory data generation process]
Next, the event inventory data generating unit 102a sets the event venue code entered in the event inventory data generating processing screen MA shown in Fig. 9, obtains the product code, product name, and shipment quantity associated with the set event venue code from the shipping data 106a, and generates the event inventory data 106b (before entry) based on the obtained product code, product name, and shipment quantity (step S1). In this description, in addition to the event venue code "10010", the business establishment code "1" and the inventory date "2020/01/31" are also set, and the event inventory data 106b (before entry) shown in Fig. 3 is generated. Note that the "current inventory quantity" in the event inventory data 106b shown in Fig. 3 means the inventory quantity at the beginning of sales of each product at the event venue.

Next, the operator enters the number of each product that remained unsold at the event venue on the inventory date "2020/01/31" (hereinafter, may be referred to as the returned goods/inventory quantity) into the event inventory data 106b (before entry) shown in FIG. 3. In this explanation, it is assumed that the data is entered as shown in the event inventory data 106b (after entry) shown in FIG. 3. Note that the file name of the event inventory data 106b (after entry) shown in FIG. 3 is the file name "Event 2020/01/31 _____ Department Store _ Year-end Sale.xlsx" that was entered into the event inventory data output screen MB in FIG. 10.

Next, the operator enters the event venue code, the file name of the event inventory data 106b (after filling out), and the like, via the input device 112 into the event inventory data import transfer processing screen MC that is pre-displayed on the monitor 114. In this explanation, it is assumed that "10010" is entered as the event venue code and "Event 2020/01/31 _____ Department Store _End of Year Sale.xlsx" is entered as the file name, as shown in input item MC1 in the event inventory data import transfer processing screen MC in FIG. 11.

[Import process]
Next, the import unit 102b imports the event inventory data 106b (after entry) of the file name entered in the event inventory data import transfer processing screen MC (step S2). In this description, the event inventory data 106b (after entry) shown in FIG.

[Acquisition process]
Next, the acquisition unit 102c acquires from the nearby warehouse master 106c the warehouse name linked to the event venue code entered in the event inventory data import transfer processing screen MC, and acquires from the inventory data 106d the inventory quantity at the acquired warehouse name for each product included in the event inventory data 106b (after entry) imported by the import unit 102b in step S2 (step S3). In this description, the warehouse names "Head Office Warehouse", "Kanto Warehouse", "Store A", "Store B", and "Store C" linked to the event venue code "10010" are obtained from the nearby warehouse master 106c shown in FIG. 4, and the inventory quantities of the product names "Red Honey 300 ml", "Blue Honey 300 ml", "Yellow Honey 300 ml", and "Green Honey 300 ml" included in the event inventory data 106b (after filling out) shown in FIG. 3 at the warehouse names "Head Office Warehouse", "Kanto Warehouse", "Store A", "Store B", and "Store C" are obtained from the inventory data 106d shown in FIG. 5.

[Calculation Processing]
Next, the calculation unit 102d calculates the sales quantity of each product at the event venue identified by the event venue code entered in the event inventory data import movement processing screen MC (step S4), which is the current inventory quantity of each product included in the event inventory data 106b (after entry) imported by the import unit 102b in step S2 minus the returned/inventory quantity of each product included in the event inventory data 106b (after entry) imported by the import unit 102b in step S2 (step S4). In this explanation, the sales figures for each product at the event venue "XX Department Store Year-End Sale Event Venue" identified by the event venue code "10010" are calculated as the current stock quantities of the product names "Red Honey 300ml,""Blue Honey 300ml,""Yellow Honey 300ml," and "Green Honey 300ml" included in the event inventory data 106b (after filling out) shown in FIG. 3 minus the returned and inventory quantities.

[Output processing]
Next, the output control unit 102e outputs to the monitor 114 an event inventory data import transfer processing screen MC on which the event inventory data 106b (after entry) imported by the import unit 102b in step S2 and the data acquired by the acquisition unit 102c in step S3 are displayed by product with the warehouse name selectable (step S5). In this explanation, the data is output as shown in the input item MC2 in the event inventory data import transfer processing screen MC in Fig. 11. In this explanation, the "current inventory quantity" included in the event inventory data 106b (after entry) shown in Fig. 3 is displayed as the "book quantity" and the "returned goods/inventory quantity" as the "actual shelf quantity" as shown in the input item MC2 in the event inventory data import transfer processing screen MC in Fig. 11.

Next, the operator selects the warehouse to which the actual shelf count of each product will be moved in input field MC2 in the special event inventory data import and transfer processing screen MC in Figure 11. In this explanation, it is assumed that the destination warehouse has been selected, as shown in input field MC2 in the special event inventory data import and transfer processing screen MC in Figure 11.

[Movement data generation process]
Next, the transfer data generating unit 102f generates transfer data 106e, which is transfer data for each product to the warehouse selected on the event inventory data import transfer processing screen MC and includes the actual shelf number of each product (step S6). In this description, the transfer data 106e shown in Fig. 6 is generated. The actual shelf number of each product is included as "transfer number" in the transfer data 106e shown in Fig. 6.

[Sales data generation process]
Next, the sales data generating unit 102g generates sales data 106f that manages the sales volume at the event venue identified by the event venue code entered in the event inventory data import transfer processing screen MC and includes the sales volume of each product calculated by the calculation unit 102d in step S4 (step S7). In this description, the sales data 106f shown in FIG. 7 is generated.

As a result of the above processing, for example, when selling products for a limited time at an event, the sales figures for each product at the end of the period can be ascertained from the inventory information, and the destination for unsold stock can be selected. With this embodiment, when unsold stock at an event is transferred to the head office warehouse or a nearby store, the actual inventory count (the amount left unsold at the event site) can be used, which can reduce the workload. In this case, by selecting the destination for the stock transfer while checking the inventory count at nearby stores, unnecessary product transfers can be eliminated, which leads to reduced delivery costs.

[3. 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 making it possible to contribute to goals 8 and 9 of the SDGs.

In addition, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, which can contribute to the achievement of SDGs goals 12, 13, and 15.

In addition, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

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

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 a known method.

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

In addition, with regard to the inventory management support 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, the processing functions of the inventory management support 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 that contains programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the inventory management support device 100 as necessary. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to give instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM, and works with the CPU to form the control unit.

This computer program may also be stored in an application program server connected to the inventory management support device 100 via any network, and all or part of it may be downloaded as needed.

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

A "program" is a data processing method written in any language or description method, and may be in any format, 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 consisting of multiple modules or libraries, and a program that works in conjunction 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, can use well-known configurations and procedures.

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

The inventory management support device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. The inventory management support device 100 may be realized by implementing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the figures, and all or part of them can be functionally or physically distributed and integrated in any unit depending on 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.

This invention is particularly useful in the retail industry.

REFERENCE SIGNS LIST 100 Inventory management support device 102 Control unit 102a Event inventory data generation unit 102b Import unit 102c Acquisition unit 102d Calculation unit 102e Output control unit 102f Movement data generation unit 102g Sales data generation unit 104 Communication interface unit 106 Storage unit 106a Shipping data 106b Event inventory data 106c Nearby warehouse master 106d Inventory data 106e Movement data 106f Sales data 108 Input/output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (3)

An information processing device including a control unit,
Inventory data that manages the number of products in stock for each warehouse or store and each product ;
For each sales location that sells products for a limited time, shipping data is used to manage the products shipped to the sales location and the number of products shipped.
is accessible to
The control unit is
a sales location initial inventory data generating means for acquiring products and shipment quantities associated with a certain sales location from the shipping data, and generating sales location initial inventory data based on the acquired products and shipment quantities, in which the shipment quantities are set as the inventory quantities of the products at the certain sales location before a period begins and in which the inventory quantities of the products at the certain sales location after a period ends can be set;
an importing means for importing sales location inventory data, in which the end-of-period inventory quantity of the product at the certain sales location is set, into the sales location initial inventory data generated by the sales location initial inventory data generating means;
a calculation means for calculating, based on the sales location inventory data acquired by the acquisition means, a sales amount of the product at the certain sales location after the end of the period by subtracting the inventory amount of the product at the certain sales location after the end of the period from the inventory amount of the product at the certain sales location before the start of the period;
a sales data generating means for generating sales data including the sales figures calculated by the calculating means;
To have
An information processing device comprising: A control unit of an information processing device having a control unit that can access inventory data for managing the number of products in stock for each warehouse or store and for each product, and shipping data for managing the products shipped to a sales location and the number of products shipped for each sales location that sells the products for a limited time,
a sales location initial inventory data generating step of acquiring products and shipment quantities associated with a certain sales location from the shipping data, and generating sales location initial inventory data based on the acquired products and shipment quantities, in which the shipment quantities are set as the inventory quantities of the products at the certain sales location before a period starts and in which the inventory quantities of the products at the certain sales location after a period ends can be set;
an import step of importing sales location inventory data, in which the end-of-period inventory quantity of the product at the certain sales location is set, into the sales location initial inventory data generated in the sales location initial inventory data generation step;
a calculation step of calculating, based on the sales location inventory data acquired in the acquisition step, a sales amount of the product at the certain sales location after the end of the period, by subtracting a stock amount of the product at the certain sales location after the end of the period from a stock amount of the product at the certain sales location before the start of the period;
a sales data generating step of generating sales data including the sales volume calculated in the calculating step;
To carry out
An information processing method comprising: A control unit of an information processing device is provided that can access inventory data for managing the number of products in stock for each warehouse or store and for each product, and shipping data for managing the products shipped to a sales location and the number of products shipped for each sales location that sells the products for a limited time,
a sales location initial inventory data generating step of acquiring products and shipment quantities associated with a certain sales location from the shipping data, and generating sales location initial inventory data based on the acquired products and shipment quantities, in which the shipment quantities are set as the inventory quantities of the products at the certain sales location before a period starts and in which the inventory quantities of the products at the certain sales location after a period ends can be set;
an import step of importing sales location inventory data, in which the end-of-period inventory quantity of the product at the certain sales location is set, into the sales location initial inventory data generated in the sales location initial inventory data generation step;
a calculation step of calculating, based on the sales location inventory data acquired in the acquisition step, a sales amount of the product at the certain sales location after the end of the period, by subtracting the number of products in stock at the certain sales location after the end of the period from the number of products in stock at the certain sales location before the start of the period;
a sales data generating step of generating sales data including the sales volume calculated in the calculating step;
A program for executing.

Images