Merchandise management device, merchandise management method, and merchandise management program

Abstract

To provide a product management device, product management method, and product management program, which enable suppression of dead stock by appropriately managing an inventory of individual items.SOLUTION: A product management device for managing an inventory of individual items to be delivered to a specific customer is provided, the device comprising a control unit configured to manage an inventory of the individual items on the basis of sales information and inventory information for each item, where the control unit comprises a first predicted stock level computation unit for estimating future stock levels of the individual items based on the sales information and inventory information.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to a merchandise management device, a merchandise management method, and a merchandise management program. [Background technology]

[0002] For example, a trading company receives an order for a product from a customer, purchases the product from a manufacturing company, and delivers the purchased product to the customer. In this case, the trading company will have inventory of the product, considering that the customer will periodically order the product. In other words, when the trading company receives another order for the product from the customer, it will deliver the product that it has been managing in inventory to the customer. An example of an application related to inventory management is described in Patent Document 1. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Application Laid-Open No. 2011-211870 Summary of the Invention [Problem to be solved by the invention]

[0004] Incidentally, there are individual products that are delivered only to specific customers. Individual products are delivered in response to an order from a specific customer, and cannot be sold to other customers. Therefore, if there are no orders for individual products from specific customers, the individual products (products) remain in inventory, which creates a problem of dead stock.

[0005] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a product management device, a product management method, and a product management program that can appropriately manage inventory of individual items and thereby reduce the occurrence of defective inventory. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the objectives, the product management device of the present invention is a product management device that manages inventory of individual items to be delivered to specific customers, and is equipped with a control unit that manages inventory of the individual items based on sales information and inventory information for each of the individual items, and the control unit has a first inventory forecast quantity calculation unit that estimates future inventory quantities of the individual items based on the sales information and the inventory information.

[0007] In addition, in the product management device of the present invention, the control unit may have a second inventory forecast quantity calculation unit that estimates the future inventory quantity of the individual item based on the sales information and inventory information of the previous year.

[0008] In the product management device according to the present invention, the control unit may include a determination unit that outputs a warning when the estimated inventory amount is equal to or less than a preset threshold value.

[0009] In addition, in the product management device of the present invention, the control unit may have an inventory rate calculation unit that calculates the inventory rate of the individual item based on the sales information and the inventory information based on a first formula (end of month amount / sales amount).

[0010] In addition, in the product management device of the present invention, the control unit may have a profit margin calculation unit that calculates the profit margin of the individual item based on the sales information and the inventory information based on a second formula ((sales price - end-of-month unit price) / sales price).

[0011] In addition, the product management method of the present invention is a product management method for managing inventory of individual items to be delivered to specific customers, and includes a step of managing inventory of the individual items based on sales information and inventory information for each of the individual items, and estimating future inventory quantities of the individual items based on the sales information and the inventory information.

[0012] In addition, the product management program of the present invention is a product management program that manages inventory of individual items to be delivered to specific customers, and manages inventory of the individual items based on sales information and inventory information for each individual item, and executes a step of estimating future inventory quantities of the individual items based on the sales information and inventory information. [Effects of the Invention]

[0013] The present invention has the effect of being able to prevent the occurrence of dead stock by appropriately managing the inventory of individual items. [Brief explanation of the drawings]

[0014] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a product management device. [Figure 2] FIG. 2 is a diagram illustrating an example of a processing flow by the product management device. [Figure 3] FIG. 3 is a diagram illustrating an example of the product master. [Figure 4] FIG. 4 is a diagram showing an example of sales data of a product. [Figure 5] FIG. 5 is a diagram illustrating an example of inventory data of a product. [Figure 6] FIG. 6 is a diagram showing an example of the flow of a process for generating customer-specific inventory data by the product management device. [Figure 7] FIG. 7 is a diagram showing an example of the analysis results of customer-specific inventory data for individual items. [Figure 8] FIG. 8 is a diagram illustrating an example of the product master. [Figure 9] FIG. 9 is a diagram illustrating an example of product order data. [Figure 10] FIG. 10 is a diagram showing an example of sales data of a product. [Figure 11] FIG. 11 is a diagram illustrating an example of inventory data of a product. [Figure 12] FIG. 12 is a diagram illustrating an example of the flow of a process for generating sales inventory forecast data by the product management device. [Figure 13]FIG. 13 is a diagram showing an example of the analysis result of the sales inventory forecast data of the individual item A. In FIG. [Figure 14] FIG. 14 is a diagram showing an example of the analysis result of the sales inventory forecast data of the individual item B. In FIG. DETAILED DESCRIPTION OF THE INVENTION

[0015] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, a product management device, a product management method, and a product management program according to the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to the present embodiment.

[0016] [Product management device] FIG. 1 is a block diagram showing an example of the configuration of a product management device.

[0017] The product management device 10 manages the inventory of individual products that are delivered by a company only to specific customers (clients). In this case, the customer (client) is another company, but it may also be a manufacturing department within the company.

[0018] The product management device 10 is constructed based on a commercially available desktop personal computer. Note that the product management device 10 is not limited to being constructed based on a stationary information processing device such as a desktop personal computer, but may also be constructed based on a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

[0019] The product management device 10 includes a control unit 11, a communication interface unit 12, a storage unit 13, and an input / output interface unit 14. The units included in the product management device 10 are connected to each other so as to be able to communicate with each other via any communication path.

[0020] The communication interface unit 12 communicatively connects the product management device 10 to the network 100 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 12 has a function of communicating data with other devices via the communication line. Here, the network 100 has a function of connecting the product management device 10 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 memory unit 13 may also be stored in the server 200, for example.

[0021] The input / output interface unit 14 is connected to an input device 21 and an output device 22. The input device 21 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with the mouse to realize a pointing device function. The output device 22 may be a monitor (including a home television), a speaker, or a printer. In the following, the input device 21 may be referred to as a keyboard or a mouse, and the output device 22 may be referred to as a monitor.

[0022] The storage unit 13 stores various databases, tables, files, etc. The storage unit 13 stores computer programs that work in cooperation with the OS (Operating System) to issue commands 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, an optical disk, etc.

[0023] The memory unit 13 stores a product master 31, order data 32, sales data 33, and inventory data 34. The product master 31 is detailed data on individual items that are products. The order data 32 is data on individual items that have been ordered by the company. The sales data 33 is sales data on individual items that have been sold by the company. The inventory data 34 is the quantity of individual items remaining in the company.

[0024] The control unit 11 is a CPU or the like that performs overall control of the product management device 10. The control unit 11 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing operations based on these stored programs.

[0025] As information processing, the control unit 11 executes inventory management processing based on various data stored in the storage unit 13. As part of the inventory management processing, the control unit 11 calculates the inventory rate, profit rate, and predicted inventory amount.

[0026] The control unit 11 manages the inventory of each item based on sales information and inventory information for each item. Here, the sales information is order data 32 and sales data 33, and the inventory information is inventory data .

[0027] The control unit 11 includes an inventory rate calculation unit 41, a profit rate calculation unit 42, a first forecast inventory amount calculation unit 43, a second forecast inventory amount calculation unit 44, and a determination unit 45.

[0028] The inventory rate calculation unit 41 calculates the inventory rate of each item based on the sales information and inventory information using the first formula (month-end amount / sales amount). The profit rate calculation unit 42 calculates the profit rate of each item based on the sales information and inventory information using the second formula ((sales price-month-end unit price) / sales price).

[0029] The first inventory forecast calculation unit 43 estimates the future inventory amount of each item based on sales information and inventory information. The second inventory forecast calculation unit 44 estimates the future inventory amount of each item based on sales information and inventory information from the previous year.

[0030] The determination unit 45 outputs a warning when the inventory amount estimated by the inventory rate or profit rate calculated by the inventory rate calculation unit 41 or profit rate calculation unit 42 is equal to or greater than a preset threshold. The determination unit 45 outputs a warning when the inventory amount estimated by the first inventory forecast amount calculation unit 43 or second inventory forecast amount calculation unit 44 is equal to or less than a preset threshold.

[0031] [Processing method using product management device] FIG. 2 is a diagram illustrating an example of a processing flow by the product management device.

[0032] As shown in Figure 2, a company enters into contracts with specific customers for various items. In other words, it finalizes the specifications of individual items, confirms the expected shipping volume of each item, and sets the transaction price for each item. It also sets the transaction period for each item and sets price reviews for each item. Here, the transaction period for each item is set to determine the purchase of inventory at the end of the transaction period. The price reviews for each item are set to determine price increases due to rising costs of materials and raw materials, etc.

[0033] When an employee of the company uses input device 21 to input order information for an individual item into product management device 10, product management device 10 rewrites the order information and inventory information in storage unit 13. When an employee uses input device 21 to input sales information for an individual item into product management device 10, product management device 10 rewrites the sales information and inventory information in storage unit 13. When an employee uses input device 21 to input purchasing information for an individual item into product management device 10, product management device 10 rewrites the purchasing information and inventory information in storage unit 13. When an employee uses input device 21 to input product master data for an individual item into product management device 10, product management device 10 rewrites the product master data in storage unit 13. Then, control unit 11 of product management device 10 analyzes various pieces of information for each customer based on the various pieces of information stored in storage unit 13.

[0034] [How to analyze inventory data by customer] Fig. 3 is a diagram showing an example of a product master. As shown in Fig. 3, the product master 31 of an individual product as a product has a product code, a product name, a product category, a customer code, a customer name, a product code, a product name, an optimum inventory value (upper limit), and an optimum inventory value (lower limit).

[0035] Fig. 4 is a diagram showing an example of sales data for a product. As shown in Fig. 4, sales data 33 for an individual product as a product includes a sales number, a row number, a sales date, a customer code, a customer name, a product code, a product name, a sales quantity, a sales price, and a sales amount.

[0036] Fig. 5 is a diagram showing an example of inventory data for a product. As shown in Fig. 5, inventory data 34 for an individual product as a product includes the accounting year and month, product code, product name, quantity at the beginning of the month, unit price at the beginning of the month, amount at the beginning of the month, number of items shipped, number of items received, quantity at the end of the month, unit price at the end of the month, and amount at the end of the month.

[0037] 6 is a diagram showing an example of the flow of the process of generating customer-specific inventory data by the product management device. As shown in FIGS. 1 and 6, the inventory rate calculation unit 41 and profit rate calculation unit 42, which are part of the control unit 11, link the product codes in the product master 31 with the product codes in the inventory data 34, link the product codes in the product master 31 with the product codes in the sales data 33, combine the data by month on a sales date basis, and output the customer-specific inventory data. The output customer-specific inventory data includes the product code, product name, accounting year and month, month-end unit price, month-end quantity, month-end amount, sales price, sales amount, etc.

[0038] FIG. 7 is a diagram showing an example of the analysis results of customer-specific inventory data for individual items.

[0039] As shown in FIGS. 1 and 7, the inventory rate calculation unit 41 and the profit rate calculation unit 42 constituting the control unit 11 perform analysis based on the sales data 33 and the inventory data 34, and output the results to a display from the output device 22 (see FIG. 1). The output device 22 displays the accounting year and month, customer code, product code, and product type code as a header section (condition specification) on the display, and displays data for individual item A001 and individual item A002. The output device 22 also displays the product code, product name, end-of-month unit price, end-of-month quantity, unit sales price, sales amount, inventory rate, and profit rate as detail sections on the display. Here, the output device 22 displays inventory data by customer for the previous month, October 2022, and inventory data by customer for the current previous month, November 2022. Note that although the output device 22 displays data for two months here, data for one month or data for three months or more may be used.

[0040] Here, the stock rate calculation unit 41 calculates the stock rate of the individual item using the first formula. Inventory rate = (month-end amount / sales amount) x 100 Therefore, the inventory rates for individual items A001 and A002 in October and November are as follows: Inventory rate for individual item A001 in October = (120 / 120) x 100 = 100.0 (%) Inventory rate for individual item A001 in November = (540 / 120) x 100 = 450.0 (%) Inventory rate for individual item A002 in October = (700 / 300) x 100 = 233.3 (%) November inventory rate for individual item A002 = (350 / 750) x 100 = 53.3 (%)

[0041] In the customer-specific inventory data, the appropriate range for inventory rates is 50% to 200%, and this range is the threshold value. The determination unit 45 compares the inventory rates of individual items A001 and A002 with the threshold value. That is, the determination unit 45 determines that the inventory rate for individual item A001 in November was 450.0%, which is higher than the threshold value, the inventory rate for individual item A002 in October was 233.3%, which is higher than the threshold value, and the inventory rate for individual item A002 in November was 46.7%, which is lower than the threshold value.

[0042] The determination unit 45 then issues a warning for the November inventory rate of 450.0% for individual item A001, and for the October inventory rates of 233.3% and 46.7% for individual item A002. In this case, the November inventory rate of 450.0% for individual item A001 and the October inventory rate of 233.3% for individual item A002 are too high, and there is a possibility that they will become dead stock. Therefore, the determination unit 45 displays the display position of the corresponding inventory rate in yellow. At this time, the person in charge needs to confirm the future demand plan for individual items A001 and A002 with the customer. Furthermore, the inventory rate for individual item A002 has fluctuated significantly from 233.3% in October to 46.7% in November, and there is a possibility that delivery will not be possible and opportunity losses will occur. Therefore, the determination unit 45 displays the display position of the corresponding inventory rate in red. At this time, the person in charge needs to check with the customer about the future demand plan for the individual items A001 and A002 and consider increasing the inventory.

[0043] Furthermore, the profit margin calculation unit 42 calculates the profit margin of each individual item using the second formula. Profit margin = (unit sales price - unit price at the end of the month) / unit sales price) x 100 Therefore, the profit margins for individual items A001 and A002 in October and November are as follows: Profit margin for individual item A001 in October = (600 - 60) / 600 x 100 = 50.0 (%) Profit margin for individual item A001 in November = (120-60) / 120×100=50.0(%) Profit margin for individual item A002 in October = (150 - 70) / 150 x 100 = 53.3 (%) Profit margin for individual item A002 in November = (150 - 70) / 150 x 100 = 53.3 (%)

[0044] In the inventory data by customer, the appropriate range for profit margins is 50% or more, and this range is the threshold value. The judgment unit 45 compares the profit margins of individual items A001 and A002 with the threshold value. The judgment unit 45 determines that the profit margins for individual items A001 and A002 in October and November are above the threshold value, and does not issue a warning. However, if the profit margins for individual items A001 and A002 in October and November are lower than the threshold value, a warning is issued, just like with the inventory ratio. The person in charge must then negotiate a price increase with the customer.

[0045] [How to analyze sales and inventory forecast data] Fig. 8 is a diagram showing an example of a product master. As shown in Fig. 8, the product master 31 of an individual product as a product has a product code, a product name, a product category, a customer code, a customer name, a scheduled contract expiration date, an order lot, an order point, a product type code, and a product type name.

[0046] Fig. 9 is a diagram showing an example of order data for a product. As shown in Fig. 9, order data 32 for an individual product as a product includes an order number, a line number, an order date, a projected sales date, a customer code, a customer name, a product code, a product name, an order quantity, an order price, and an order amount.

[0047] Fig. 10 is a diagram showing an example of sales data for a product. As shown in Fig. 10, sales data 33 for an individual product as a product includes a sales number, a row number, a sales date, a customer code, a customer name, a product code, a product name, a sales quantity, a sales price, and a sales amount.

[0048] Fig. 11 is a diagram showing an example of inventory data for a product. As shown in Fig. 11, inventory data 34 for an individual product as a product includes the accounting year and month, product code, product name, quantity at the beginning of the month, unit price at the beginning of the month, amount at the beginning of the month, number of items shipped, number of items received, quantity at the end of the month, unit price at the end of the month, and amount at the end of the month.

[0049] 12 is a diagram showing an example of the flow of a process for generating customer-specific inventory data by the product management device. As shown in FIGS. 1 and 12, the first inventory forecast quantity calculation unit 43 and the second inventory forecast quantity calculation unit 44 constituting the control unit 11 link the product codes in the product master 31 with the product codes in the inventory data 34, and link the product codes in the product master 31 with the product codes in the sales data 33. , Sell The data is combined by month based on the sales date and the expected sales date, and sales inventory forecast data is output. The output sales inventory forecast data includes product code, product name, expected contract end date, order lot, order point, accounting year and month, etc. The first inventory forecast calculation unit 43 and second inventory forecast calculation unit 44 then output the inventory quantity, sales quantity, expected sales quantity, previous year's sales quantity, inventory forecast plan, and last year's actual and forecast inventory forecasts.

[0050] FIG. 13 is a diagram showing an example of the analysis result of the sales inventory forecast data of the individual item A. In FIG.

[0051] As shown in FIGS. 1 and 13, the first inventory forecast calculation unit 43 and the second inventory forecast calculation unit 44, which are components of the control unit 11, perform analysis based on the order data 32, sales data 33, and inventory data 34, and output the results to a display from the output device 22 (see FIG. 1). The output device 22 displays the accounting year and month, product code, and product type code as a header section (condition specification) on the display, and displays data for individual item A001 and individual item A002. The output device 22 also displays the product code, product name, expected contract expiration date, order lot, and order point as detail sections, as well as the inventory quantity, sales quantity, expected sales quantity, previous year's sales quantity, expected inventory forecast, and last year's inventory forecast. Here, the output device 22 displays sales and inventory forecast data for the current month, November 2022, and sales and inventory forecast data for December 2022, the contract expiration month. If the expected contract expiration date is earlier than the specified period, the display will extend up to the expected contract expiration date.

[0052] Here, the inventory quantity for November is the actual quantity, and is the inventory quantity at the end of the month on the specified start date. The inventory quantity for December is the forecast quantity, and is the inventory quantity obtained by adding the planned sales quantity to the actual quantity. The sales quantity is the sales quantity per month. The planned sales quantity is the order quantity (unassigned quantity) per month. The previous year's sales quantity is the sales quantity per month for the same month last year. The planned inventory forecast is the quantity obtained by subtracting the sales quantity from the inventory quantity and adding the planned sales quantity. The inventory forecast last year is the quantity obtained by subtracting the previous year's sales quantity from the inventory quantity and adding the previous year's sales quantity.

[0053] In the sales inventory forecast data, 0 is the appropriate value and threshold value for the inventory forecast plan and inventory forecast last year at the end of the contract. In the sales inventory forecast data, inventory forecast plan 4 is higher than the threshold value, indicating that individual item A001 will be in stock at the end of the contract, and the determination unit 45 determines that there is a high possibility that it will become dead stock. Also, in the sales inventory forecast data, inventory forecast last year 2 is higher than the threshold value, indicating that individual item A001 will be in stock at the end of the contract, and the determination unit 45 determines that there is a high possibility that it will become dead stock. Therefore, the determination unit 45 displays the corresponding inventory forecast plan 4 and inventory forecast last year 2 in yellow. At this time, the person in charge needs to inform the customer that there will likely be remaining inventory of individual item A001 and suggest that the customer promptly develop a plan to use individual item A001.

[0054] FIG. 14 is a diagram showing an example of the analysis result of the sales inventory forecast data of the individual item B. In FIG.

[0055] As shown in FIGS. 1 and 14, the first inventory forecast calculation unit 43 and the second inventory forecast calculation unit 44, which constitute the control unit 11, perform analysis based on the order data 32, sales data 33, and inventory data 34, and output the results to a display from the output device 22 (see FIG. 1). The output device 22 displays the accounting year and month, product code, and product type code as a header section (condition specification) on the display, and displays data for individual item B001. The output device 22 also displays the product code, product name, expected contract expiration date, order lot, and order point as detail sections, as well as the inventory quantity, sales quantity, expected sales quantity, previous year's sales quantity, expected inventory forecast, and last year's inventory forecast. Here, the output device 22 displays sales and inventory forecast data for the current month, November 2022, and sales and inventory forecast data for multiple months (five months in this embodiment) from December 2022 onwards.

[0056] Here, the inventory quantity for November is the actual quantity, and is the inventory quantity at the end of the month of the specified start date. The inventory quantity from December onwards is the forecast quantity, and is the inventory quantity that takes into account the actual quantity and the planned sales quantity. The sales quantity, planned sales quantity, last year's sales quantity, planned inventory forecast, and last year's inventory forecast are the same as those described above.

[0057] In the sales inventory forecast data, for the planned inventory forecast from December onwards and the inventory forecast last year, reorder point 5 is the appropriate value and serves as the threshold value. In the sales inventory forecast data, planned inventory forecast 4 from January 2023 onwards indicates that it is lower than the threshold value, and the determination unit 45 determines that there is a high possibility that there will be an inventory shortage of individual item A001. Also, in the sales inventory forecast data, planned inventory forecast last year 4 and inventory forecast last year 1 from January 2023 onwards indicate that they are lower than the threshold value, and the determination unit 45 determines that there is a high possibility that there will be an inventory shortage of individual item A001. Therefore, the determination unit 45 displays the display positions of the corresponding multiple planned inventory forecast 4, inventory forecast last year 2, and inventory forecast last year 1 in yellow.

[0058] Furthermore, in the sales inventory forecast data, inventory forecast last year 14 and inventory forecast last year 15 for March 2023 and beyond indicate that they are even lower than the threshold value, and the determination unit 45 determines that there is an even higher possibility that inventory of individual item A001 will be insufficient. In this case, a value lower than the order point 5 is set as the threshold value. Therefore, the determination unit 45 displays the display positions of the corresponding inventory forecast last year -4 and inventory forecast last year -5 in red. At this time, the person in charge notifies the customer that inventory of individual item B001 is running low, checks with the customer whether or not there has been an additional order for individual item A001, and plans to increase the inventory quantity of individual item A001 in response to the customer's request.

[0059] [Effects of this embodiment] The product management device 10 of this embodiment is a product management device 10 that manages inventory of individual items to be delivered to specific customers, and is equipped with a control unit 11 that manages inventory of individual items based on sales information and inventory information for each individual item, and the control unit 11 has a first inventory forecast quantity calculation unit 43 that estimates future inventory quantities of individual items based on the sales information and inventory information.

[0060] The product management device 10 of this embodiment estimates the future inventory amount of individual products based on sales information and inventory information, and therefore can appropriately manage the inventory of individual products to prevent the occurrence of dead stock.

[0061] In other words, the product management device 10 allows inventory management for each customer by assigning a customer to each product for individual items destined for a specific customer. The product management device 10 adds analysis items such as customer information, contract period, and order point to the product master 31, and performs inventory management analysis by combining information from order data 32, sales data 33, and inventory data 34. This allows inventory management for each customer to be grasped. If there is inventory, it is possible to request the customer to buy back the inventory or to change the contract to include the purchase of inventory when renewing the contract. On the other hand, if the shipment of individual items is progressing smoothly as planned or even better than planned, the product management device 10 can propose increasing the inventory of the individual items held, thereby managing appropriate shippable inventory to prevent stockouts. As a result, the risk of obsolete inventory can be reduced and service can be improved to prevent stockouts.

[0062] In the product management device 10 of this embodiment, the control unit 11 has a second inventory forecast calculation unit 44 that estimates the future inventory amount of individual items based on sales information and inventory information from the previous year. Therefore, by comparing the sales information and inventory information from the previous year, the future inventory amount of individual items can be estimated with high accuracy.

[0063] In the product management device 10 of this embodiment, the control unit 11 has a determination unit 45 that outputs a warning when the estimated inventory amount is equal to or less than a preset threshold value, allowing the person in charge to easily grasp the inventory surplus or shortage status of individual items.

[0064] In the product management device 10 of this embodiment, the control unit 11 has an inventory rate calculation unit 41 that calculates the inventory rate of individual items based on sales information and inventory information using formula 1 (month-end amount / sales amount). Therefore, by understanding the inventory rate of individual items, it is possible to take measures against the inventory of individual items at an early stage.

[0065] In the product management device 10 of this embodiment, the control unit 11 has a profit margin calculation unit 42 that calculates the profit margin of an individual product based on the second formula ((unit sales price - unit price at the end of the month) / unit sales price) from sales information and inventory information. Therefore, it is possible to adjust prices for customers at an early stage according to the profit margin of each individual product.

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

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

[0068] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to the achievement of Goal 16 of the SDGs.

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

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

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

[0072] Furthermore, with regard to the product management device 10, the components shown in the drawings are functional concepts, and the product management device 10 does not necessarily have to be physically configured as shown in the drawings.

[0073] For example, all or any part of the processing functions of the product management device 10, particularly the processing functions performed by the control unit, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory, computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the product management device 10 as needed. That is, a computer program for providing instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). The computer program is executed by being loaded into RAM and cooperates with the CPU to form the control unit.

[0074] This computer program may also be stored in an application program server connected to the product management device 10 via any network, and all or part of it may be downloaded as needed.

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

[0076] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.

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

[0078] The product management device 10 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as an information processing device connected to any peripheral device. The product management device 10 may also be implemented by installing software (including programs, data, etc.) that causes the device to perform the processes described in this embodiment.

[0079] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Industrial Applicability]

[0080] The present invention is useful for companies that deliver individual items. [Explanation of symbols]

[0081] 10 Product management device 11 Control section 12 Communication interface section 13 Storage section 14 Input / Output Interface Section 21 Input Devices 22 Output Devices 31 Product Master 32 Order Data 33 Sales Data 34 Inventory Data 41 Inventory rate calculation section 42 Profit rate calculation department 43 First inventory forecast calculation unit 44 Second inventory forecast calculation unit 45 Judgment section 100 Network 200 servers

Claims

1. A product management device for managing inventory of individual products delivered only to specific customers, a storage unit that stores a product master having detailed information about the individual items and detailed information about the customers, sales information about the individual items, and inventory information indicating the number of remaining individual items; a control unit that links the detailed information of the individual items with the sales information and the inventory information to perform inventory management of the individual items for each customer; Equipped with The control unit includes a first inventory forecast calculation unit that estimates a future inventory amount of the individual item based on the sales information and the inventory information, and a determination unit that outputs a warning when the estimated inventory amount is equal to or less than a preset threshold value. Product management device.

2. the control unit includes a second inventory forecast quantity calculation unit that estimates a future inventory quantity of the individual item based on the sales information and the inventory information of the previous year, The product management device according to claim 1 .

3. The control unit has an inventory rate calculation unit that calculates the inventory rate of the individual item based on a first formula (month-end amount / sales amount) from the sales information and the inventory information. The product management device according to claim 1 .

4. The control unit has a profit margin calculation unit that calculates the profit margin of the individual item based on the sales information and the inventory information based on a second formula ((sales unit price - end-of-month unit price) / sales unit price). The product management device according to claim 1 .

5. A product management method for managing inventory of individual products delivered only to specific customers, comprising: a storage unit that stores a product master having detailed information about the individual items and detailed information about the customers, sales information about the individual items, and inventory information that is the number of remaining individual items; The computer executes linking the detailed information of the individual items with the sales information and the inventory information to perform inventory management of the individual items for each customer; Estimating future inventory amounts of the individual items based on the sales information and the inventory information; a step of outputting a warning when the estimated inventory amount is equal to or less than a preset threshold value; Product management method.

6. A product management program for managing inventory of individual products delivered only to specific customers, a storage unit that stores a product master having detailed information about the individual items and detailed information about the customers, sales information about the individual items, and inventory information that is the number of remaining individual items; On the computer, linking the detailed information of the individual items with the sales information and the inventory information to perform inventory management of the individual items for each customer; Estimating future inventory amounts of the individual items based on the sales information and the inventory information; Executing a step of outputting a warning when the estimated inventory amount is equal to or less than a preset threshold value; Product management program.

Images