JP7853232B2 - Set product generation device, set product generation method, and set product generation program - Google Patents

Description

This invention relates to a set product generation apparatus, a set product generation method, and a set product generation program.

Patent Document 1 discloses a technology that allows for the tracking of inventory and sales information for products sold both individually and as part of a set.

Japanese Patent Publication No. 2004-78462

Incidentally, the food and retail industries sell bundled products (hereinafter referred to as "treasure hunt products") that combine multiple items with different unit prices and grades. These treasure hunt products reduce unsold inventory by combining leftover and best-selling items into a single product, creating a game-like element where customers don't know what they'll get.

However, because treasure hunt items are sold at a uniform price, even though they contain items with varying values and costs, profits from high-priced items may not be realized, while profits from low-priced items may appear to be. Therefore, it was difficult for sellers to determine whether the treasure hunt items as a whole were profitable, making it challenging to track their overall revenue contribution.

This invention has been made in view of the above, and aims to provide a set product generation device, a set product generation method, and a set product generation program that can grasp the profit management of treasure hunt products.

To solve the aforementioned problems and achieve the objective, the set product generation device according to the present invention is a set product generation device equipped with a control unit, which can access inventory data associating product name, lot number, current inventory quantity, cost unit price, and cost amount for each product code; lot detail data associating product name, lot number, and arrival date for each product code; and sales performance data associating sales date, product name, sales quantity, sales unit price, and sales amount for each product code. The control unit includes an inventory information output unit that refers to the inventory data and lot detail data and outputs inventory information for each product code corresponding to the input reference date to a monitor; a sales performance information output unit that refers to the sales performance data and outputs sales performance information for each product code corresponding to the input reference date to a monitor; and a processing unit that combines multiple products selected by the operator from the inventory information and sales performance information to process and register them as a single set product.

Furthermore, the set product generation method according to the present invention is a set product generation method executed by a set product generation device equipped with a control unit, wherein the set product generation device has access to inventory data associating product name, lot number, current inventory quantity, cost unit price, and cost amount for each product code; lot detail data associating product name, lot number, and arrival date for each product code; and sales performance data associating sales date, product name, sales quantity, sales unit price, and sales amount for each product code. The method includes: an inventory information output step executed by the control unit, which refers to the inventory data and lot detail data and outputs inventory information for each product code corresponding to the input reference date to a monitor; a sales performance information output step, which refers to the sales performance data and outputs sales performance information for each product code corresponding to the input reference date to a monitor; and a processing step, which combines multiple products selected by an operator from the inventory information and sales performance information to process and register them as a single set product.

Furthermore, the set product generation program according to the present invention is a set product generation program to be executed by a set product generation device equipped with a control unit, wherein the set product generation device has access to inventory data associating product name, lot number, current inventory quantity, cost unit price, and cost amount for each product code; lot detail data associating product name, lot number, and arrival date for each product code; and sales performance data associating sales date, product name, sales quantity, sales unit price, and sales amount for each product code, and includes, for execution by the control unit, an inventory information output step that refers to the inventory data and the lot detail data and outputs inventory information for each product code corresponding to the input reference date to a monitor; a sales performance information output step that refers to the sales performance data and outputs sales performance information for each product code corresponding to the input reference date to a monitor; and a processing step that combines multiple products selected by the operator from the inventory information and the sales performance information to process and register them as a single set product.

According to this invention, it is possible to understand the profit management of treasure hunt goods.

Figure 1 is a schematic diagram showing an overview of an example of the configuration of a set product generation device according to the embodiment, in a block diagram. Figure 2 shows an example of an inventory data table in the inventory data 106a of the storage unit of the set product generation device according to the embodiment. Figure 3 shows an example of a lot detail data table in the lot detail data 106b of the storage unit of the set product generation device according to the embodiment. Figure 4 shows an example of a sales performance data table in the sales performance data 106c of the storage unit of the set product generation device according to the embodiment. Figure 5 shows an example of a unit price master table in the unit price master 106d of the storage unit of the set product generation device according to the embodiment. Figure 6 is a flowchart showing an overview of the process performed by the set product generation device according to the embodiment. Figure 7 shows an example of an inventory inquiry screen displayed by the monitor of the set product generation device according to the embodiment. Figure 8 shows an example of a sales performance verification screen displayed by the monitor of the set product generation device according to the embodiment. Figure 9 shows an example of a processing input screen displayed by the monitor of the set product generation device according to the embodiment. Figure 10 shows an example of a processing header data table in processing header data. Figure 11 shows an example of a processing and disbursement details data table in the processing and disbursement details data. Figure 12 shows an example of a processing acceptance details data table in the processing acceptance details data. Figure 13 shows an example of an inventory data table in the updated inventory data. Figure 14 shows an example of a unit price master table in the updated unit price master. Figure 15 shows an example of an order entry screen displayed by the monitor of the set product generation device according to the embodiment.

The following describes in detail, with reference to the drawings, embodiments of the set product generation apparatus, set product generation method, and set product generation program according to the present invention. However, the present invention is not limited to these embodiments.

[1. Structure]
An example of the configuration of the set product generation device according to this embodiment will be described with reference to Figure 1, etc. Figure 1 is a schematic diagram showing an overview of an example of the configuration of the set product generation device in a block diagram.

The set product generation device 100 shown in Figure 1 is a commercially available desktop personal computer. However, the set product generation device 100 is not limited to stationary information processing devices such as desktop personal computers; it may also be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

The set product generation device 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input/output interface unit 108. Each component of the set product generation device 100 is connected via an arbitrary communication path for communication.

The communication interface unit 104 connects the set product generation 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 the function of communicating data with other devices via the communication line. Here, the network 300 has the function of connecting the set product generation 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 storage unit 106 may, for example, be stored in the server 200.

The input/output interface unit 108 is connected to an input device 112 and an output device 114. The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, mouse, microphone, or a monitor that works in conjunction with the mouse to provide pointing device functionality. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 as the keyboard 112 or mouse 112.

The storage unit 106 stores various databases, tables, and files. The storage unit 106 also stores computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) for various processing tasks. The storage unit 106 can be, for example, a memory device such as RAM (Random Access Memory) or ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. The storage unit 106 stores inventory data 106a, lot detail data 106b, sales performance data 106c, and a unit price master 106d.

Inventory data 106a stores the warehouse code, warehouse name, product name, lot number, current inventory, cost per unit, and total cost for each product code.

Figure 2 shows an example of an inventory data table in inventory data 106a. The first row of inventory data table T1 in Figure 2 stores the following information associated with the product code "0001": warehouse code "SO001", warehouse name "Center Warehouse", product name "French Red Wine, 2022 Vintage", lot number "LOT1001", current inventory "5", cost unit price "1,600", and cost amount "8,000".

Lot detail data 106b stores the product name, lot number, and arrival date associated with each product code.

Figure 3 shows an example of a lot detail data table in lot detail data 106b. The first row of lot detail data table T2 shown in Figure 3 stores the product code "0001," the product name "French Red Wine, 2022 Vintage," the lot number "LOT1001," and the arrival date "2022/5/14" associated with each other.

Sales performance data 106c stores the sales date, product name, quantity sold, unit price, and total sales amount for each product code.

Figure 4 shows an example of a sales performance data table in sales performance data 106c. The first row of sales performance data table T3 shown in Figure 4 stores the following information associated with the product code "0002": sales date "2022/11/1", product name "Spanish Red Wine, 2020 Vintage", quantity sold "1", unit price "1,500", and sales amount "1,500".

The unit price master 106d stores the product name and unit price associated with each product code.

Figure 5 shows an example of a unit price master table in unit price master 106d. The first row of the unit price master table T4 shown in Figure 5 stores the product code "0001," the product name "French Red Wine, 2022 Vintage," and the unit price "1,800."

Returning to Figure 1, we will continue the explanation of the configuration of the set product generation device 100.
The control unit 102 is a CPU or the like that comprehensively controls the set product generation device 100. The control unit 102 has an internal memory for storing control programs such as the OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs. The control unit 102 includes an inventory information output unit 102a, a sales performance information output unit 102b, a processing unit 102c, and an order input unit 102d.

The inventory information output unit 102a refers to the inventory data 106a and lot detail data 106b, and performs inventory reconciliation processing to output inventory information for each product code corresponding to the input reference date to the monitor 114.

The sales performance information output unit 102b refers to the sales performance data 106c and performs a sales performance verification process to display sales performance information for each product code on the monitor 114 according to the input reference date.

The processing unit 102c combines multiple products selected by the operator from the inventory information and sales performance information displayed on the monitor 114, processes them into a single set product, and displays a processing input screen on the monitor 114 for registration as a Treasure Hunt product. It then performs the processing input process to register the product.

The order entry unit 102d performs order entry processing, in which the operator enters the order (sale) of the treasure hunt product via the input device 112 onto the input screen displayed on the monitor 114.

[2. Processes executed by the set product generation device]
Next, we will explain the processes performed by the set product generation device 100. Figure 6 is a flowchart showing an overview of the processes performed by the set product generation device 100.

As shown in Figure 6, the inventory information output unit 102a refers to the inventory data 106a (see Figure 2) and the lot detail data 106b (see Figure 3), and performs an inventory matching process to output inventory information for each product code corresponding to the input reference date to the monitor 114 (step S1).

Figure 7 shows an example of the inventory inquiry screen displayed by the monitor 114. The inventory matching screen P1 shown in Figure 7 includes an inventory location cell H1 where the operator inputs the inventory location via the input device 112, a reference date cell K1 where the reference date is entered, and an inventory information table B1 corresponding to the inventory information for each product code based on the reference date.

As shown in Figure 7, the inventory information output unit 102a refers to the inventory data 106a and lot detail data 106b and displays the inventory information table B1 corresponding to the inventory information for each product code based on the input reference date. In this case, the inventory information output unit 102a displays the inventory information table B1 corresponding to the inventory information for each product code, associating the product name, quantity, inventory days based on the reference date and arrival date, and lot number. For example, if the product code is "0001", the inventory information output unit 102a calculates the inventory days as "200" and displays it in the inventory information table B1, since the reference date is "2022/11/30" and the arrival date is "2022/5/14" (see Figure 3).

Furthermore, the inventory information output unit 102a highlights the cells of product codes whose inventory days have exceeded a predetermined number of days, for example, 100 days or more, and displays them on the monitor 114. For example, the inventory information output unit 102a highlights the cells or text in yellow, red, etc., and displays them on the monitor 114. This allows the operator to intuitively understand which products have exceeded a predetermined number of days in stock and to predict which products are likely to remain unsold. In this case, the operator selects products with the longest inventory days from among the multiple products displayed in the inventory information table B1 via the input device 112. For example, in the case shown in Figure 7, the operator selects product codes "0001," "0002," and "0005" as treasure hunt items via the input device 112. The operator also excludes product code "0007" from the selection of treasure hunt items because, although it has a long inventory period, it has a sales record and is judged to be sellable individually.

Returning to Figure 6, we will continue the explanation from step S2 onward.
In step S2, the sales performance information output unit 102b refers to the sales performance data 106c and performs a sales performance verification process that displays sales performance information for each product code on the monitor 114 according to the input reference date.

Figure 8 shows an example of a sales performance verification screen displayed by the monitor 114. The sales performance verification screen P2 shown in Figure 8 includes sales date cells K2 and K3 where the operator inputs the sales year and month via the input device 112, a reference date cell K4 where the reference date is entered, and a sales performance table B2 corresponding to the sales performance information.

As shown in Figure 8, the sales performance information output unit 102b refers to the sales performance data 106c and displays the sales performance table B2 corresponding to the sales performance information, which associates the product name and the current month's sales quantity for each product code. For example, the sales performance information output unit 102b refers to the sales performance data 106c and displays the sales performance table B2 on the monitor 114 corresponding to the sales performance information for each product code, based on the sales date cells K2 "2022/11/1", K3 "2022/11/30", and reference date cell K4 "2022/11/30" entered by the operator via the input device 112.

Furthermore, the sales performance information output unit 102b highlights best-selling products, for example, by highlighting cells or text in yellow, red, etc., and displays them on the monitor 114. In this case, the operator selects the best-selling products for the current month from among the multiple products displayed in the sales performance table B2 via the input device 112. For example, as shown in Figure 8, the operator selects product codes "0003" and "0004" as treasure hunt items via the input device 112.

Returning to Figure 6, we will continue the explanation from step S3 onwards.
In step S3, the processing unit 102c performs a processing input process that displays a processing input screen on the monitor 114 for registering a set of products selected by the operator from the inventory information and sales performance information displayed on the monitor 114, and registering them as a treasure hunt product (step S3).

Figure 9 shows an example of the processing input screen displayed by monitor 114. The processing input screen P3 shown in Figure 9 includes an inventory location cell H10 for entering the inventory location, a processing date cell K10 for entering the processing date, a payment item table B10 corresponding to payment item information, and a received item table B11 corresponding to received item information.

The processing unit 102c executes a processing input process to transfer multiple products selected by the operator via the input device 112 on the inventory verification screen P1 and the sales performance verification screen P2 to treasure hunt products. In this case, the processing unit 102c refers to the inventory data 106a, lot detail data 106b, and sales performance data 106c, and displays the payment listing table B10 corresponding to the payment listing information for each of the multiple products selected by the operator, and the received item table B11 corresponding to the received item information for the treasure hunt products, on the monitor 114.

Furthermore, the processing unit 102c generates processing header data, processing disbursement detail data, and processing receipt detail data, and updates inventory data and unit price master. In this case, the processing unit 102c aggregates the cost amounts of each of the selected items, divides this aggregated result by the quantity of the Treasure Hunt item, and registers the allocated cost of the Treasure Hunt item. Specifically, as shown in the receipt table B11 of Figure 9, the processing unit 102c divides the total of the aggregated cost amounts of each of the selected items, "46,800," by the quantity of the Treasure Hunt item, "30," to allocate (calculate) the cost of the Treasure Hunt item, "1,560," and registers it.

Figure 10 shows an example of a processing header data table in the processing header data. Figure 11 shows an example of a processing disbursement detail data table in the processing disbursement detail data. Figure 12 shows an example of a processing receipt detail data table in the processing receipt detail data. Figure 13 shows an example of an inventory data table in the updated inventory data 106a. Figure 14 shows an example of a unit price master table in the updated unit price master 106d.

The processing unit 102c processes multiple items selected by the operator via the input device 112 on the inventory verification screen P1 and the sales performance verification screen P2, adding a treasure hunt box to create a payout item, and then processes these combined treasure hunt items as a received item. In this case, the processing unit 102c generates the processing header table T10 shown in Figure 10, the processing payout details data table T11 shown in Figure 11, and the processing receipt details table T12 shown in Figure 12.

Furthermore, the processing unit 102c updates the inventory data 106a and the unit price master 106d, as shown in the inventory data table T13 in Figure 13 and the unit price master table T14 in Figure 14. For example, as shown in the 6th row of the unit price master table T14 in Figure 14, the processing unit 102c updates the unit price master 106d by writing information that associates the product code "TH009" with the product name "Treasure Hunt Product Red Wine" and the unit price "2,200".

Furthermore, as shown in the processing input screen P3 of Figure 9, the operator can intuitively grasp the sales price and gross profit on the dispensing side. This allows for simulations of pricing on the receiving side (the buyer), enabling the setting of an appropriate sales price. In other words, the operator can easily set a price for treasure hunt items that is neither too high nor too low, while still generating a profit.

Furthermore, operators can easily create treasure hunt items for campaigns (advertising effectiveness) when e-commerce sales are declining, even for unsold or non-bestselling items.

Returning to Figure 6, we will continue the explanation from step S4 onwards.
In step S4, the order entry unit 102d performs an order entry process in which the operator enters an order (sale) for a treasure hunt product on the input screen displayed on the monitor 114 via the input device 112.

Figure 15 shows an example of the order entry screen displayed by the monitor 114. As shown in Figure 15, the order entry screen P4 includes an order date cell K20 where the order date is entered, a customer cell Q20 where the customer is entered, a shipping warehouse cell Q21 where the shipping warehouse is entered, and order details information B20. The operator can ensure profitability for each transaction when treasure hunt products are sold in sets, and can intuitively grasp the profit. Furthermore, to promote profitability of treasure hunt products, the operator can prevent inventory of treasure hunt products from accumulating by soliciting reservations from consumers through advertising in advance. After step S4, the set product generation device 100 terminates this process.

According to the embodiment described above, the processing unit 102c combines multiple products selected by the operator from inventory information and sales performance information to process and register them as a single treasure hunt product, thereby enabling the management of profits for treasure hunt products.

Furthermore, according to this embodiment, the processing unit 102c registers the total quantity of treasure hunt items, which is the sum of the inventory quantities of each of the multiple items selected by the operator. Therefore, inventory management from regular items to treasure hunt items can be easily managed.

Furthermore, according to this embodiment, the cost amounts of each of the multiple products selected by the processing unit 102c are totaled, and this total is divided by the quantity of treasure hunt products to allocate and register the cost of the treasure hunt products. This allows for obtaining profits from both best-selling and unsold products.

Furthermore, according to this embodiment, the processing unit 102c refers to inventory data 106a, lot detail data 106b, and sales performance data 106c, and displays the payment listing table B10 corresponding to the payment listing information for each of the multiple products selected by the operator, and the received item table B11 corresponding to the received item information for the treasure hunt products, on the monitor 114. This allows the operator to intuitively understand the products they have selected.

Furthermore, according to this embodiment, the processing unit 102c displays the gross profit of the treasure hunt items on the monitor 114, corresponding to the sales price of the treasure hunt items input. Therefore, the operator can intuitively grasp the gross profit of the treasure hunt items.

Furthermore, according to this embodiment, the inventory information output unit 102a highlights products whose inventory information has expired for a predetermined number of days based on the inventory data 106a and the reference date entered by the operator, and displays them on the monitor 114. The sales performance information output unit 102b highlights products whose sales performance information has exceeded a predetermined number based on the sales performance data 106b and the reference date entered by the operator, and displays them on the monitor 114. This allows the operator to easily identify unsold and best-selling products.

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

Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.

Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.

[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 those described as being performed automatically can be performed manually, or all or part of those described as being performed manually can be performed automatically using known methods.

Furthermore, the processing procedures, control procedures, specific names, information including registration data and search conditions for each process, screen examples, and database configuration shown in this specification and in the drawings may be modified at will unless otherwise specified.

Furthermore, regarding the set product generation device 100, each component shown in the illustration is a functional concept and does not necessarily need to be physically configured as shown.

For example, the processing functions of the set product generation device 100, particularly those performed in the control unit, may be implemented entirely or partially by a CPU and a program interpreted and executed by the CPU, or they may be implemented as wired logic hardware. The program is recorded on a non-temporary, computer-readable recording medium containing programmed instructions for the information processing device to execute the processing described in this embodiment, and is mechanically read by the set product generation device 100 as needed. That is, a storage unit such as ROM or HDD (Hard Disk Drive) stores a computer program that works in cooperation with the OS to give instructions to the CPU and perform various processing tasks. This computer program is executed by being loaded into RAM and, in cooperation with the CPU, constitutes the control unit.

Furthermore, this computer program may be stored on an application program server connected to the set product generation device 100 via any network, and it is possible to download all or part of it as needed.

Furthermore, the program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program product. Here, "recording medium" refers to memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROM, EPROM (Erasable Programmable Read Only Memory), EEPROM (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile). This includes any "portable physical media" such as Blu-ray Discs and Blu-ray® Discs.

Furthermore, "program" refers to a data processing method described in any language or writing method, regardless of its format, such as source code or binary code. Note that "program" is not necessarily limited to a single, standalone structure; it also includes distributed structures consisting of multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions. Regarding the specific configuration and reading procedures for reading the recording medium in each device shown in the embodiments, as well as the installation procedures after reading, well-known configurations and procedures can be used.

The various databases stored in the memory unit are 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 used for various processes and website provision.

Furthermore, the set product generation device 100 may be configured as a known personal computer or workstation or other information processing device, or as an information processing device to which any peripheral devices are connected. Alternatively, the set product generation device 100 may be implemented by installing software (including programs or data, etc.) that realizes the processing described in this embodiment onto the device.

Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the illustration. 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-described embodiments may be implemented in any combination, or selectively.

This invention is useful in the food and retail industries.

100 Set Product Generation Device 102 Control Unit 102a Inventory Information Output Unit 102b Sales Performance Information Output Unit 102c Processing Unit 102d Order Input Unit 104 Communication Interface Unit 106 Storage Unit 106a Inventory Data 106b Lot Details Data 106c Sales Performance Data 106d Unit Price Master 108 Input/Output Interface Unit 112 Input Device 114 Output Device 200 Server 300 Network

Claims (10)

A set product generation apparatus equipped with a control unit,
For each product code, inventory data is created that associates the product name, lot number, current stock quantity, cost per unit, and total cost.
For each product code, lot details data is generated, which associates the product name, lot number, and arrival date.
Sales performance data is generated by associating the sales date, product name, quantity sold, unit price, and total sales amount for each product code.
Accessible,
The control unit,
An inventory information output unit that refers to the aforementioned inventory data and lot detail data and outputs inventory information for each product code corresponding to the input reference date to a monitor,
A sales performance information output unit that refers to the aforementioned sales performance data and outputs sales performance information for each product code corresponding to the input reference date to a monitor,
A processing unit that combines multiple products selected by the operator from the aforementioned inventory information and sales performance information to process and register them as a single set product,
Equipped with,
A device for generating set products. A set product generating apparatus according to claim 1,
The aforementioned processing section is
The quantity of the aforementioned set product is registered as the sum of the inventory quantities of each of the selected items.
A device for generating set products. A set product generating apparatus according to claim 2,
The aforementioned processing section is
Referencing the aforementioned inventory data, calculate the total cost amount by summing the cost amounts of each of the selected items, and register the amount obtained by dividing the aforementioned total amount by the quantity of the set product as the cost of the set product.
A device for generating set products. A set product generating apparatus according to claim 3,
The aforementioned processing section is
The system references the aforementioned inventory data, lot detail data, and sales performance data, and outputs information for each of the selected products and information for the set product to the monitor.
A device for generating set products. A set product generating apparatus according to claim 4,
For each product code, it is possible to access a price master that associates the product name and unit price.
The aforementioned processing section is
The gross profit of the set product, corresponding to the unit sales price of the set product entered, is output to the monitor.
A device for generating set products. A set product generating apparatus according to claim 5,
The aforementioned processing section is
The unit price master stores the sales unit price of the set product.
A device for generating set products. A set product generating apparatus according to claim 6,
The aforementioned processing section is
The inventory data is updated by replacing the quantity of each of the selected items with the quantity of the set product.
A device for generating set products. A set product generating apparatus according to claim 7,
The aforementioned inventory information output unit is:
Based on the aforementioned inventory data and the aforementioned reference date, the products in the inventory information that have been in use for a predetermined number of days are highlighted and output to the monitor.
The aforementioned sales performance information output unit is:
Based on the aforementioned sales performance data and the aforementioned reference date, the products in the sales performance information that have sold a predetermined number are highlighted and output to the monitor.
A device for generating set products. A method for generating a set product, which is performed by a set product generation device equipped with a control unit,
The aforementioned set product generating device,
For each product code, inventory data is created that associates the product name, lot number, current stock quantity, cost per unit, and total cost.
For each product code, lot details data is generated, which associates the product name, lot number, and arrival date.
Sales performance data is generated by associating the sales date, product name, quantity sold, unit price, and total sales amount for each product code.
Accessible,
The control unit executes the following:
An inventory information output step that refers to the aforementioned inventory data and lot detail data and outputs inventory information for each product code corresponding to the input reference date to the monitor,
A sales performance information output step that refers to the aforementioned sales performance data and outputs sales performance information for each product code corresponding to the input reference date to the monitor,
A processing step in which an operator combines multiple products selected from the aforementioned inventory information and sales performance information to process and register them as a single set product,
Including,
A method for generating set products characterized by the following. A set product generation program to be executed by a set product generation device equipped with a control unit,
The aforementioned set product generating device,
For each product code, inventory data is created that associates the product name, lot number, current stock quantity, cost per unit, and total cost.
For each product code, lot details data is generated, which associates the product name, lot number, and arrival date.
Sales performance data is generated by associating the sales date, product name, quantity sold, unit price, and total sales amount for each product code.
Accessible,
To be performed by the control unit,
An inventory information output step that refers to the aforementioned inventory data and lot detail data and outputs inventory information for each product code corresponding to the input reference date to the monitor,
A sales performance information output step that refers to the aforementioned sales performance data and outputs sales performance information for each product code corresponding to the input reference date to the monitor,
A processing step in which an operator combines multiple products selected from the aforementioned inventory information and sales performance information to process and register them as a single set product,
Including,
A set product generation program characterized by the following.