Set product generation device, set product generation method, and set product generation program
The set product generation device addresses the challenge of profit determination in treasure hunt products by integrating inventory and sales data to manage and price treasure hunt products effectively, ensuring both high-value and low-value products contribute to overall profit.
Patent Information
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- OBIC CO LTD
- Filing Date
- 2023-01-12
- Publication Date
- 2026-04-28
AI Technical Summary
In the food and retail industries, treasure hunt products combining products with different values and costs are sold at a uniform price, making it difficult to determine profit margins and contribute to revenue, as high-value products' profits are not realized while low-value products' profits are overstated.
A set product generation device and method that utilizes a control unit to access inventory and sales data, allowing selection and processing of multiple products into a single treasure hunt product, with detailed profit management capabilities.
Enables accurate profit management and pricing of treasure hunt products, ensuring both high-value and low-value products contribute to overall profit, and facilitates effective inventory and sales strategies.
Smart Images

Figure 0007853232000001 
Figure 0007853232000002 
Figure 0007853232000003
Abstract
Description
Technical Field
[0001] The present invention relates to a set product generation device, a set product generation method, and a set product generation program.
Background Art
[0002] Patent Document 1 discloses a technique capable of grasping inventory information and sales information of products that are sold as single products or set products.
Prior Art Documents
Patent Documents
[0003]
Patent Document 1
Summary of the Invention
Problems to be Solved by the Invention
[0004] By the way, in the food industry and the retail industry, set products (hereinafter referred to as "treasure hunt products") combining a plurality of products with different unit prices and grades are sold. This treasure hunt product is sold as one product by combining slow-selling products and best-selling products, giving it a gamelike quality where it's not known what will be "won," while reducing the inventory of products.
[0005] However, since treasure hunt products are sold at a uniform price for products with various values and costs, the profit of the high-value products incorporated is not realized, while the profit of the low-value products is accounted for as if it were realized. For this reason, it has been difficult for sellers to grasp whether a profit is being made on the entire treasure hunt product, and it has been difficult to contribute to revenue.
[0006] The present invention has been made in view of the above, and an object thereof is to provide a set product generation device, a set product generation method, and a set product generation program capable of grasping the profit management of treasure hunt products. [Means for solving the problem]
[0007] To solve the above-mentioned 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 is able to access inventory data associated with each product code, name, lot number, current inventory quantity, cost unit price, and cost amount; lot detail data associated with each product code, name, lot number, and arrival date; and sales performance data associated with each product code, sales date, name, sales quantity, sales unit price, and sales amount. The control unit includes an inventory information output unit that refers to the inventory data and the lot detail data and outputs inventory information for each product code according 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 according 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 the sales performance information to process and register them as a single set product.
[0008] 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, and is executed by the control unit, and includes 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 a plurality of products selected by an operator from the inventory information and the sales performance information and processes and registers them as a single set product.
[0009] 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, to be executed 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 a plurality of products selected by the operator from the inventory information and the sales performance information and processes and registers them as a single set product. [Effects of the Invention]
[0010] According to the present invention, it is possible to grasp the profit management of treasure hunt goods. [Brief explanation of the drawing]
[0011] [Figure 1] 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] 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] 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] 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]FIG. 5 is a diagram showing an example of a unit price master table in the unit price master 106d in the storage unit included in the set product generation device according to the embodiment. [Figure 6] FIG. 6 is a flowchart showing an outline of processing executed by the set product generation device according to the embodiment. [Figure 7] FIG. 7 is a diagram showing an example of an inventory inquiry screen displayed on the monitor of the set product generation device according to the embodiment. [Figure 8] FIG. 8 is a diagram showing an example of a sales performance verification screen displayed on the monitor of the set product generation device according to the embodiment. [Figure 9] FIG. 9 is a diagram showing an example of a processing input screen displayed on the monitor of the set product generation device according to the embodiment. [Figure 10] FIG. 10 is a diagram showing an example of a processing header data table in the processing header data. [Figure 11] FIG. 11 is a diagram showing an example of a processing payout detail data table in the processing payout detail data. [Figure 12] FIG. 12 is a diagram showing an example of a processing receipt detail data table in the processing receipt detail data. [Figure 13] FIG. 13 is a diagram showing an example of an inventory data table in the updated inventory data. [Figure 14] FIG. 14 is a diagram showing an example of a unit price master table in the updated unit price master. [Figure 15] FIG. 15 is a diagram showing an example of an order input screen displayed on the monitor of the set product generation device according to the embodiment.
Embodiments for Carrying Out the Invention
[0012] Hereinafter, embodiments of the set product generation device, the set product generation method, and the set product generation program according to the present invention will be described in detail based on the drawings. Note that the present invention is not limited by this embodiment.
[0013] [1. Configuration] An example of the configuration of the set product generation device according to this embodiment will be described with reference to FIG. 1 and the like. FIG. 1 is a schematic diagram showing an overview of a block diagram showing an example of the configuration of the set product generation device.
[0014] The set product generation device 100 shown in FIG. 1 is a commercially available desktop personal computer. Note that the set product generation device 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, or a tablet personal computer.
[0015] The set product generation device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the set product generation device 100 is communicably connected via an arbitrary communication path.
[0016] The communication interface unit 104 communicably 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 a function of communicating data via another device and a communication line. Here, the network 300 has a function of communicably connecting the set product generation device 100 and the server 200 to 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.
[0017] 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, a mouse, a 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 may be referred to as the keyboard 112 or mouse 112.
[0018] 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) to perform various processes. 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.
[0019] 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.
[0020] Figure 2 shows an example of an inventory data table in inventory data 106a. In the first row of inventory data table T1 shown in Figure 2, the product code "0001" is associated with the warehouse code "SO001", warehouse name "Center Warehouse", product name "French Red Wine 2022", lot number "LOT1001", current inventory "5", cost unit price "1,600", and cost amount "8,000".
[0021] Lot detail data 106b stores the product name, lot number, and arrival date associated with each product code.
[0022] Figure 3 shows an example of a lot detail data table in lot detail data 106b. In the first row of lot detail data table T2 shown in Figure 3, the product code "0001" is associated with the product name "French Red Wine 2022 Vintage", lot number "LOT1001", and arrival date "2022 / 5 / 14".
[0023] Sales performance data 106c stores the sales date, product name, quantity sold, unit price, and total sales amount for each product code.
[0024] Figure 4 shows an example of a sales performance data table in sales performance data 106c. In the first row of sales performance data table T3 shown in Figure 4, the product code "0002" is associated with the sales date "2022 / 11 / 1", the product name "Spanish Red Wine 2020", the quantity sold "1", the unit price "1,500", and the sales amount "1,500".
[0025] The unit price master 106d stores the product name and unit price associated with each product code.
[0026] Figure 5 shows an example of a unit price master table in unit price master 106d. In the first row of the unit price master table T4 shown in Figure 5, the product code "0001" is associated with the product name "French Red Wine 2022" and the unit price "1,800".
[0027] 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.
[0028] The inventory information output unit 102a refers to the inventory data 106a and lot detail data 106b and performs inventory matching processing to output inventory information for each product code corresponding to the input reference date to the monitor 114.
[0029] The sales performance information output unit 102b refers to the sales performance data 106c and performs a sales performance matching process that displays sales performance information for each product code on the monitor 114 according to the input reference date.
[0030] 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, thereby executing a processing input process.
[0031] The order entry unit 102d performs order entry processing, 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.
[0032] [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.
[0033] 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).
[0034] Figure 7 shows an example of an inventory inquiry screen displayed by monitor 114. The inventory matching screen P1 shown in Figure 7 includes an inventory location cell H1 in which the operator enters the inventory location via input device 112, a reference date cell K1 in which the reference date is entered, and an inventory information table B1 corresponding to inventory information for each product code according to the reference date.
[0035] 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 according to 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, which associates the product name, quantity, number of days of inventory 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 number of days of inventory as "200" because the reference date is "2022 / 11 / 30" and the arrival date is "2022 / 5 / 14" (see Figure 3) and displays it in the inventory information table B1.
[0036] 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 characters in yellow, red, etc., and displays them on the monitor 114. This allows the operator to intuitively grasp 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 a long inventory period from among the multiple products displayed in the inventory information table B1 via the input device 112. For example, as 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 as a single item.
[0037] Returning to Figure 6, we will continue the explanation from step S2 onwards. 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.
[0038] Figure 8 shows an example of a sales performance verification screen displayed by monitor 114. The sales performance verification screen P2 shown in Figure 8 includes sales date cells K2 and K3 in which the operator enters the sales year and month via input device 112, a reference date cell K4 in which the reference date is entered, and a sales performance table B2 corresponding to the sales performance information.
[0039] 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 sales quantity for the current month 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 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, on the monitor 114.
[0040] 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.
[0041] 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).
[0042] Figure 9 shows an example of a 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.
[0043] 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 matching screen P1 and the sales performance matching 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.
[0044] Furthermore, the processing unit 102c generates processing header data, processing disbursement item details data, and processing receipt details data, and updates inventory data and unit price master. In this case, the processing unit 102c aggregates the cost amount of each of the selected items, divides this aggregated result by the quantity of the treasure hunt item, and registers the cost of the treasure hunt item apportioned. 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 apportion (calculate) and register the cost of the treasure hunt item, "1,560".
[0045] Figure 10 shows an example of a processing header data table in processing header data. Figure 11 shows an example of a processing issue detail data table in processing issue detail data. Figure 12 shows an example of a processing receipt detail data table in processing receipt detail data. Figure 13 shows an example of an inventory data table in updated inventory data 106a. Figure 14 shows an example of a unit price master table in updated unit price master 106d.
[0046] The processing unit 102c adds a treasure hunt box to multiple items selected by the operator via the input device 112 on the inventory matching screen P1 and the sales performance matching screen P2, and processes these items as a treasure hunt product, which is then received. In this case, the processing unit 102c generates the processing header table T10 in Figure 10, the processing and disbursement details data table T11 in Figure 11, and the processing and receipt details table T12 in Figure 12.
[0047] 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".
[0048] 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 issuing side, and by conducting simulations including pricing on the receiving side (the buyer), they can set an appropriate sales price. In other words, the operator can easily set a price for treasure hunt items that is not too high and also generates a profit.
[0049] 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.
[0050] Returning to Figure 6, we will continue the explanation from step S4 onwards. In step S4, the order entry unit 102d executes an order entry process in which the operator enters the order (sale) of the treasure hunt product into the input screen displayed on the monitor 114 via the input device 112.
[0051] Figure 15 shows an example of an order entry screen displayed by 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 profit for each transaction when treasure hunt products are sold in sets, and can intuitively grasp the profit. Furthermore, in order to promote profit-making for treasure hunt products, the operator can prevent the accumulation of inventory of treasure hunt products by soliciting reservations from consumers in advance through advertising, etc. After step S4, the set product generation device 100 terminates this process.
[0052] 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, making it possible to grasp the profit management of the treasure hunt product.
[0053] 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. This makes it easy to manage inventory changes from regular items to treasure hunt items.
[0054] Furthermore, according to this embodiment, the cost amount of each of the multiple products selected by the processing unit 102c is totaled, and this totaled result is divided by the quantity of treasure hunt products to allocate and register the cost of the treasure hunt products, thereby allowing profits to be obtained for both best-selling products and unsold products.
[0055] Furthermore, according to the 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.
[0056] Furthermore, according to this embodiment, the processing unit 102c displays the gross profit of the treasure hunt items on the monitor 114 according to the unit sales price of the treasure hunt items that are input, so that the operator can intuitively grasp the gross profit of the treasure hunt items.
[0057] Furthermore, according to the embodiment, the inventory information output unit 102a highlights products in the inventory information of items that have been in stock 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 in the sales performance information of items that have been sold in a predetermined quantity 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.
[0058] [3. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving operational efficiency and promoting appropriate management decisions within companies, thereby enabling contributions to SDGs Goals 8 and 9.
[0059] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.
[0060] Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.
[0061] [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.
[0062] 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 by known methods.
[0063] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configuration shown in this specification and in the drawings may be changed at will unless otherwise specified.
[0064] Furthermore, with respect to the set product generation device 100, each component shown in the illustration is a functional concept and does not necessarily have to be physically configured as shown.
[0065] 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) contains 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 works in cooperation with the CPU to constitute the control unit.
[0066] 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.
[0067] 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" includes any "portable physical medium" such as memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical disks), DVDs (Digital Versatile Disks), and Blu-ray (Registered Trademark) Discs.
[0068] 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, monolithic 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.
[0069] 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.
[0070] Furthermore, the set product generation device 100 may be configured as an information processing device such as a known personal computer or workstation, 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 enables the processing described in this embodiment onto the device.
[0071] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the figures, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit according to various additions or functional loads. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Industrial applicability]
[0072] This invention is useful in the food and retail industries. [Explanation of Symbols]
[0073] 100-set product generation device 102 Control Unit 102a Inventory Information Output Unit 102b Sales Performance Information Output Unit 102c Processing section 102d Order Entry Section 104 Communication Interface Section 106 Storage section 106a Inventory Data Lot 106b Detailed Data 106c Sales Performance Data 106d Unit Price Master 108 Input / Output Interface Section 112 Input device 114 Output device 200 servers 300 Networks
Claims
1. 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.
2. 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.
3. 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 aggregating the cost amounts of each of the selected items, and register the amount obtained by dividing the total amount by the quantity of the set product as the cost of the set product. A device for generating set products.
4. 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.
5. 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.
6. 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.
7. 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.
8. 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.
9. 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.
10. 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.
Citation Information
Patent Citations
Goods selecting device and goods selecting method
JP2004078462A
Inventory management device and inventory management program
JP2007276990A
Analysis support processing apparatus and program therefor
JP2010237900A
Ecommerce system for marketing mixed-lots of distressed inventory
US20150324877A1