JP7456914B2 - Business support devices, business support methods, and business support programs - Google Patents

Description

The present invention relates to a business support device, a business support method, and a business support program.

In the distribution and retail industry, many companies hold exhibitions. Products ordered from customers at exhibitions and placed in stock can be reserved for regular orders other than exhibitions, so the products in stock are not the same as those for orders for exhibitions. It was necessary to make reservations while checking whether this was the case.

Note that Patent Document 1 describes an inventory management device, an inventory management method, and an inventory management program that improve operational efficiency in allocating inventory for orders.

JP2020-003942A

However, there are cases where inventory received for orders for exhibitions is allocated against regular orders, leading to trouble, or inventory received for regular orders is determined to be inventory received for orders for exhibitions. In some cases, this resulted in lost sales.

The present invention has been made in consideration of the above, and aims to provide a business support device, a business support method, and a business support program that can allocate orders for events (e.g., exhibitions) on a priority basis.

In order to solve the above-mentioned problems and achieve the purpose, a business support device according to the present invention is a business support device including a control unit, and the control unit controls the number of ordered products and inventory allocation processing. Order data that can store the reserved quantity representing the number of products for which the product has been ordered by product identification information, event identification information that identifies the event when the product was ordered by product identification information, and the current status of the product. Order data where the reserved quantity is less than the ordered quantity, based on inventory data that stores the quantity of stock for the event and the number of stock reserved for orders at the event by product identification information and event identification information. The present invention is characterized by comprising an allocation means that prioritizes order data in which event identification information is stored and executes inventory allocation processing based on the number of inventory for the event.

Further, in the business support device according to the present invention, the allocation means may select, based on the order data and the inventory data, order data in which event identification information is not stored among the order data for which the reserved quantity is less than the number of orders. A feature of the present invention is that inventory allocation processing is executed based on the current number of items in stock.

The business support device according to the present invention is also characterized in that the order data stores the order date, and the allocation means, when there are multiple order data in which the same event identification information is stored among the order data in which the allocated quantity is less than the order quantity, executes inventory allocation processing for the multiple order data in the order of the oldest order date stored in the multiple order data.

Further, the business support device according to the present invention stores, in the inventory data, the number of unallocated products representing the number of products for which inventory allocation processing has not been completed for orders at the event, for each product identification information and for each event identification information. The allocation means executes an addition update process for the reserved quantity stored in the order data, and if event identification information is stored in the order data, the current information stored in the inventory data is executed. Execute the subtraction update process for the number of warehouses, the number of stock for special events, and the number of unallocated items, and if the event identification information is not stored in the order data, perform the subtraction update process for the current number of stock stored in the inventory data. It is characterized by carrying out.

Further, in the business support device according to the present invention, when the order data in which event identification information is stored, the control unit adjusts the inventory data based on the number of orders stored in the order data. The present invention is characterized by further comprising an order receiving means that performs an addition update process on the stored unallocated quantity.

Further, in the business support device according to the present invention, the control unit stores the number of products to be ordered from a supplier by product identification information and by supplier identification information, and organizes an event when the product is ordered. an ordering means for executing an ordering process based on ordering data that can store identifying event identification information for each product identification information and for each supplier identification information, and when a product to be ordered from the supplier is received, If event identification information is stored in the ordering data, perform an addition update process of the current stock quantity stored in the inventory data and the event inventory quantity, and if event identification information is not stored in the ordering data. In this case, the present invention is characterized by further comprising: arrival input means for executing an addition update process for the current number of stocks stored in the inventory data.

Further, the business support method according to the present invention is a business support method executed by an information processing device including a control unit, and the process of determining the number of ordered products and inventory allocation, which is executed by the control unit, is completed. Order data that can store the number of reserved items representing the number of products ordered by product identification information, event identification information that identifies the event when the product was ordered, and the current inventory of the product. Based on the inventory data that stores the event inventory quantity, which indicates the number of inventory reserved for orders at the event, by product identification information and event identification information, the order data in which the reserved quantity is less than the order quantity. The present invention is characterized by including an allocation step of giving priority to order data in which event identification information is stored and executing inventory allocation processing based on the number of items in stock for the event.

Further, the business support program according to the present invention is a business support program to be executed by an information processing device including a control unit, and includes an order quantity and inventory reservation process for ordered products to be executed by the control unit. Order data that can store the reserved quantity representing the number of products for which the product has been ordered by product identification information, and event identification information that identifies the event when the product was ordered by product identification information; Based on inventory data that stores the current stock quantity and the quantity of stock reserved for orders at special events for each product identification information and event identification information, orders for which the reserved quantity is less than the order quantity are received. The present invention is characterized in that it includes an allocation step of giving priority to order data in which event identification information is stored among the data and executing inventory allocation processing based on the number of items in stock for the event.

The present invention has the effect of allowing priority allocation to orders for special events.

FIG. 1 is a block diagram showing an example of the configuration of a business support device 100. FIG. 2 is a diagram showing an example of the order data 106a. FIG. 3 is a diagram showing an example of order data 106b. FIG. 4 is a diagram showing an example of inventory data 106c. FIG. 5 is a diagram showing an example of the order data 106a. FIG. 6 is a diagram illustrating an example of a flowchart regarding processing executed by the business support device 100. FIG. 7 is a diagram illustrating an example of inventory allocation processing. FIG. 8 is a diagram illustrating an example of inventory allocation processing. FIG. 9 is a diagram illustrating an example of inventory allocation processing. FIG. 10 is a diagram illustrating an example of inventory allocation processing.

Embodiments of a business support device, a business support method, and a business support program according to the present invention will be described in detail below based on the drawings. Note that the present invention is not limited to this embodiment. In particular, in this embodiment, the event will be described as an exhibition, but the present invention is not limited to this.

[1. composition]
An example of the configuration of the business support device according to this embodiment will be described with reference to FIG. 1. FIG. 1 is a block diagram showing an example of the configuration of a business support device 100.

The business support device 100 is constructed based on a commercially available desktop personal computer. Note that the business support device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable type such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer. It may be constructed based on an information processing device.

The business support device 100 includes a control section 102, a communication interface section 104, a storage section 106, and an input/output interface section 108. Each part included in the business support device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the business 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 a communication line. Here, the network 300 has a function of connecting the business 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). Note that the data stored in the storage 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 . As the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. Note that in the following description, the output device 114 may be referred to as a monitor 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112.

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for giving instructions to a CPU (Central Processing Unit) to perform various processes in cooperation with an OS (Operating System). As the storage unit 106, 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, etc. can be used.

The storage unit 106 stores order data 106a, order data 106b, inventory data 106c, and the like.

2 and 5 are diagrams showing an example of the order data 106a. The order data 106a includes the order date, customer identification information (for example, customer name, etc.), and exhibition (example of event) identification information (for example, exhibition code (hereinafter, the code will be referred to as CD). ), product identification information (for example, product CD and name), and the number of orders.

FIG. 3 is a diagram showing an example of order data 106b. The order data 106b includes an order date, supplier identification information (for example, supplier name, etc.), exhibition identification information, product identification information, and the number of orders.

FIG. 4 is a diagram showing an example of inventory data 106c. Inventory data 106c includes product identification information, current stock quantity, exhibition inventory quantity indicating the quantity of inventory reserved for orders at exhibitions, exhibition identification information, and information for orders placed at exhibitions. and an unallocated number representing the number of products for which inventory allocation processing has not been completed.

Returning to FIG. 1, the control unit 102 is a CPU or the like that centrally controls the business support device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs specifying various processing procedures, required data, etc., and performs various information processing based on these stored programs. Execute.

Functionally, the control section 102 includes an order receiving section 102a corresponding to an order receiving means of the present invention, an ordering section 102b corresponding to an ordering means of the present invention, and an arrival input section 102c corresponding to an arrival input means of the present invention. , an allocation section 102d corresponding to the allocation means of the present invention.

When the order data 106a storing exhibition identification information is registered, the order receiving unit 102a calculates the unallocated quantity stored in the inventory data 106c based on the number of orders stored in the order data 106a. Execute additive update processing.

The ordering unit 102b executes ordering processing based on the ordering data 106b.

When a product to be ordered from a supplier is received, the arrival input unit 102c inputs the current inventory quantity stored in the inventory data 106c and information for the exhibition if exhibition identification information is stored in the order data 106b. Addition and update processing of the inventory quantity is executed, and if exhibition identification information is not stored in the order data 106b, addition and update processing of the current inventory quantity stored in the inventory data 106c is executed.

Based on the order data 106a and the inventory data 106c, the reservation unit 102d prioritizes the order data 106a in which exhibition identification information is stored among the order data 106a for which the reserved quantity is less than the number of orders, and stores the exhibition inventory. Inventory allocation processing is executed based on the number, and inventory allocation processing for order data 106a in which exhibition identification information is not stored is executed based on the current inventory number. In addition, if there is a plurality of order data 106a in which the same exhibition identification information is stored among the order data 106a for which the reserved quantity is less than the number of orders, the order date stored in the plurality of order data 106a is Inventory allocation processing is executed for the plurality of order data 106a in order of oldest order. Furthermore, the process adds and updates the reserved quantity stored in the order data 106a, and if exhibition identification information is stored in the order data 106a, the current inventory quantity stored in the inventory data 106c, the exhibition Executes a subtraction update process for the number of inventory for the event and the number of unallocated items, and if exhibition identification information is not stored in the order data 106a, executes a subtraction update process for the current inventory quantity stored in the inventory data 106c. .

A specific example of the processing executed by each processing unit constituting the control unit 102 will be described in detail below.

[2. Specific example of processing]
Here, a specific example of processing executed by the business support device 100 will be described with reference to FIG. 6 and the like.

First, the operator registers an order received at an exhibition as order data in the order data 106a. In the description of this specific example, it is assumed that the order data 106a1 and the order data 106a2 shown in FIG. 2 are registered in the order data 106a.

When the order data 106a1 and the order data 106a2 are registered in the order data 106a, the order receiving unit 102a executes an addition update process for the unallocated quantity of the inventory data 102c (step S1). Specifically, based on "30" which is the sum of the quantity "10" in the order data 106a1 and the quantity "20" in the order data 106a2, the number of unallocated exhibition orders in the inventory data 106c becomes "30". will be added. Changes in the numerical values of the inventory data 106c before and after order registration are as shown in FIG.

Next, the ordering unit 106b creates ordering data 106b based on the ordering data 106a, and executes product ordering processing based on the ordering data 106b (step S2). Since the order data 106a1 and the order data 106a2 shown in FIG. 2 store the same exhibition CD and product CD, the ordering unit 106b creates the order data 106b shown in FIG. Execute.

Next, when the ordered products are received, the arrival input unit 102c executes an addition update process for each stock quantity in the inventory data 106c (step S3). Specifically, the current inventory number "0" of the inventory data 106c is added to "30", and the exhibition inventory "0" is added to "30". Changes in the numerical values of the inventory data 106c before and after input of arrival are as shown in FIG. 4.

For the sake of convenience in the following explanation of the inventory allocation process, in this specific example, it is assumed that the order data 106a3 shown in FIG. 5 was also registered in the order data 106a as a regular order that is not for an exhibition, before the inventory allocation process was executed. Since this is a regular order that is not for an exhibition, as shown in FIG. 5, the exhibition CD is not stored in the order data 106a3. Furthermore, the inventory allocation process is executed without creating additional order data or restocking the product due to the registration of the order data 106a3.

Next, the allocation unit 102d executes inventory allocation processing for unallocated orders, giving priority to order data that stores exhibition CDs (step S4), and also executes inventory allocation processing for orders that have not been allocated (step S4). An addition update process of the number and a subtraction update process of each stock quantity and unallocated quantity of inventory data are executed (step S5).

Figure 7 is a diagram showing an example of inventory allocation processing. As shown in Figures 2 and 5, order data 106a1, order data 106a2, and order data 106a3 are all unallocated order data because the allocated quantity is less than the order quantity. Of these three order data, the allocation unit 102d prioritizes inventory allocation processing for order data 106a1 and order data 106a2, which store the exhibition CD "20SS." The change in the numerical value of inventory data 106c before and after inventory allocation is as shown in Figure 4. When inventory allocation processing for order data 106a1 and order data 106a2 is completed, all inventory will be depleted, so inventory allocation processing for order data 106a3 is not executed.

The processes executed by the business support device 100 have been described above, but below, the inventory allocation process when the settings of inventory data or order data are changed will be explained.

FIG. 8 is a diagram illustrating an example of inventory allocation processing when there is sufficient inventory for orders received for an exhibition. In this case, even if the inventory allocation process for the order data 106a1 and 106a2, which are orders for the exhibition, is completed, there is still inventory, so some inventory allocation processing for the order data 106a3, which is a normal order, is also performed. do.

FIG. 9 is a diagram illustrating an example of inventory allocation processing when the number of inventories is insufficient for orders received for an exhibition. In this case, there is not enough inventory to perform inventory allocation processing for all orders, so of the order data 106a1 and 106a2 that store the same exhibition CD, the stored order date is older. The inventory allocation process for the order data 106a1 is executed preferentially, and then the inventory allocation process for the order data 106a2 is partially executed. Since the inventory will be completely exhausted when the inventory allocation process for the order data 106a1 and the order data 106a2 is completed, the inventory allocation process for the order data 106a3 is not executed.

FIG. 10 is a diagram showing an example of inventory allocation processing when a normal order (order data 106a4 instead of order data 106a3) is registered before an order for an exhibition. In this case as well, the inventory allocation process for the orders for the exhibition is executed with priority, so the inventory allocation process for the order data 106a1 and the order data 106a2 in which the exhibition CD is stored is executed with priority. Furthermore, among the order data 106a1 and the order data 106a2 that store the same exhibition CD, inventory allocation processing is performed preferentially for the order data 106a1 whose stored order date is older, and then the order data 106a2 Executes part of the inventory reservation process. Since the inventory will be completely exhausted when the inventory allocation process for the order data 106a1 and the order data 106a2 is completed, the inventory allocation process for the order data 106a4 is not executed.

[3. summary]
As a result of the above processing, the inventory generated due to the arrival of goods for exhibitions can be strictly reserved for orders received for exhibitions, and troubles with customers and lost sales of products can be prevented in advance.

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

For example, among the processes described in the embodiments, all or part of the processes described as being 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, unless otherwise specified, information including processing procedures, control procedures, specific names, parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings are included. It can be changed arbitrarily.

Further, regarding the business support device 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions provided in the business support device 100, especially each processing function 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. Alternatively, it may be implemented as hardware using wired logic. Note that the program is recorded on a non-temporary computer-readable recording medium that includes programmed instructions for causing the information processing device to execute the processing described in this embodiment. Machine read to 100. That is, a storage unit such as a ROM or an HDD (Hard Disk Drive) stores a computer program that cooperates with an OS to give instructions to a CPU and perform various processes. This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU.

Further, this computer program may be stored in an application program server connected to the business support device 100 via an arbitrary network, and it is also possible to download all or part of it as necessary. be.

In addition, the program for executing the processing described in this embodiment may be stored in 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.

Further, a "program" is a data processing method written in any language or writing method, and does not matter in the form of source code or binary code. Note that a "program" is not necessarily limited to a unitary structure, but may be distributed as multiple modules or libraries, or may work together with separate programs such as an OS to achieve its functions. Including things. Note that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, and the installation procedure after reading.

The various databases stored in the storage 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 are used for various processing and website provision. Stores programs, tables, databases, web page files, etc.

Further, the business 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. Further, the business support device 100 may be implemented by installing software (including programs, data, etc.) that causes the device to implement 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.

The present invention is particularly useful in the retail distribution industry.

100 Business support device 102 Control unit
102a Order department
102b Order department
102c Arrival input section
102d Allocation section 104 Communication interface section 106 Storage section
106a Order data
106b Order data
106c Inventory data 108 Input/output interface section 112 Input device 114 Output device 200 Server 300 Network

Claims (7)

A business support device comprising a control unit,
The control unit includes:
The number of ordered products and the number of reserved items representing the number of products for which inventory reservation processing has been completed are stored for each product identification information, and the event identification information that identifies the event when the product was ordered is stored for each product identification information. Based on the order data that can be stored, and the inventory data that stores the number of items currently in stock and the number of inventory for events that indicates the number of inventory reserved for orders at the event, by product identification information and event identification information, Allocation means for performing inventory allocation processing based on event inventory quantity, giving priority to order data in which event identification information is stored among the order data for which the allocated quantity is less than the number of orders ;
The number of products to be ordered from a supplier is stored by product identification information and by supplier identification information, and the event identification information that identifies the event when the product was ordered is stored by product identification information and supplier identification information. an ordering means for executing order processing based on separately storable ordering data;
When the product to be ordered from the supplier is received, if event identification information is stored in the order data, add and update the current inventory quantity stored in the inventory data and the event inventory quantity. and, if event identification information is not stored in the order data, an incoming stock input unit that performs an addition update process for the current inventory quantity stored in the inventory data;
to have
A business support device featuring: The allocation means performs inventory allocation processing for order data in which event identification information is not stored among order data for which the allocated quantity is less than the number of orders, based on the current inventory quantity, based on the order data and the inventory data. to carry out,
The business support device according to claim 1, characterized in that: The order data stores the order date;
If there is a plurality of order data in which the same event identification information is stored among the order data for which the reserved quantity is less than the number of orders, the reservation means is configured to adjust the order date stored in the plurality of order data. executing inventory reservation processing for the plurality of order data in order of oldest order;
The business support device according to claim 1 or 2, characterized in that: The inventory data stores the number of unallocated products representing the number of products for which inventory allocation processing has not been completed for orders at the event, for each product identification information and event identification information,
The allocation means executes an addition update process for the reserved quantity stored in the order data, and if event identification information is stored in the order data, the current stock quantity stored in the inventory data. , executes a subtraction update process for the event stock quantity and unallocated quantity, and if event identification information is not stored in the order data, executes a subtraction update process for the current stock quantity stored in the inventory data. thing,
The business support device according to any one of claims 1 to 3, characterized in that: When order data in which event identification information is stored is registered, the control unit performs processing to add and update the number of unallocated items stored in the inventory data based on the number of orders stored in the order data. further equipping means for receiving orders;
The business support device according to any one of claims 1 to 4, characterized in that: The control unit of the information processing device
The ordered quantity of the ordered product and the reserved quantity representing the number of the product for which inventory reservation processing has been completed are stored for each product identification information, and the event identification information that identifies the event when the product was ordered is stored as the product identification information. Based on order data that can be stored separately, and inventory data that stores the current number of products in stock and the number of stock for special events, which indicates the number of stock reserved for orders at special events, by product identification information and event identification information. , a reservation step of performing inventory reservation processing based on the number of stock for special events, giving priority to order data in which special event identification information is stored among the order data for which the reserved quantity is less than the number of orders;
The number of products to be ordered from a supplier is stored by product identification information and by supplier identification information, and the event identification information that identifies the event when the product was ordered is stored by product identification information and supplier identification information. an ordering step for executing order processing based on separately storable ordering data;
When the product to be ordered from the supplier is received, if event identification information is stored in the order data, add and update the current inventory quantity stored in the inventory data and the event inventory quantity. and if event identification information is not stored in the order data, an arrival input step of performing an addition update process for the current inventory quantity stored in the inventory data;
to carry out ,
A business support method characterized by: The control unit of the information processing device,
The ordered quantity of the ordered product and the reserved quantity representing the number of the product for which inventory reservation processing has been completed are stored for each product identification information, and the event identification information that identifies the event when the product was ordered is stored as the product identification information. Based on order data that can be stored separately, and inventory data that stores the current number of products in stock and the number of stock for special events, which indicates the number of stock reserved for orders at special events, by product identification information and event identification information. , an allocation means that performs inventory allocation processing based on the event inventory quantity, giving priority to order data in which event identification information is stored among the order data for which the allocated quantity is less than the number of orders;
The number of products to be ordered from a supplier is stored by product identification information and by supplier identification information, and the event identification information that identifies the event when the product was ordered is stored by product identification information and supplier identification information. An ordering means that executes order processing based on order data that can be stored separately;
When the product to be ordered from the supplier is received, if event identification information is stored in the order data, add and update the current inventory quantity stored in the inventory data and the event inventory quantity. and, if event identification information is not stored in the order data, an incoming stock input unit that performs an addition update process for the current inventory quantity stored in the inventory data;
A business support program to function as a business support program.

Images