JP7754867B2 - Merchandise management device, merchandise management method, and merchandise management program - Google Patents

Description

The present invention relates to a product management device, a product management method, and a product management program.

For example, a trading company receives product orders from customers, purchases products from manufacturers, and delivers the purchased products to the customers. Given that the trading company receives regular product orders from customers, product inventory is generated. In other words, when the trading company receives another product order from a customer, it delivers the product from its inventory management to the customer. Patent Document 1, for example, is an example of an application related to inventory management.

JP 2011-211870 A

By the way, 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 is no order for an individual product from a specific customer, the individual product (goods) will remain in inventory, which can lead to the issue of dead stock.

The present invention was 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 the inventory of individual items and reduce the occurrence of dead stock.

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 the inventory of individual items to be delivered to specific customers, and is equipped with a control unit that manages the 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 calculation unit that estimates the future inventory amount of the individual items based on the sales information and the inventory information.

In the product management device according to the present invention, the control unit may also include a second inventory forecast calculation unit that estimates the future inventory amount of the individual item based on the sales information and inventory information from the previous year.

In addition, 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.

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

In addition, in the product management device according to 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 using a second formula ((unit sales price - unit price at the end of the month) / unit sales price).

The product management method according to the present invention is a product management method for managing inventory of individual items to be delivered to specific customers, and includes steps of managing inventory of the individual items based on sales information and inventory information for each of the individual items, and estimating future inventory levels of the individual items based on the sales information and inventory information.

The product management program of the present invention is a product management program that manages the inventory of individual items delivered to specific customers, and executes a step of managing the inventory of the individual items based on sales information and inventory information for each of the individual items, and estimating future inventory levels of the individual items based on the sales information and inventory information.

The present invention has the effect of reducing the occurrence of dead stock by properly managing the inventory of individual items.

FIG. 1 is a block diagram showing an example of the configuration of a product management device. FIG. 2 is a diagram illustrating an example of a processing flow by the product management device. FIG. 3 is a diagram illustrating an example of the product master. FIG. 4 is a diagram showing an example of product sales data. FIG. 5 is a diagram showing an example of inventory data of products. 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. FIG. 7 is a diagram showing an example of the analysis results of customer-specific inventory data for individual items. FIG. 8 is a diagram illustrating an example of the product master. FIG. 9 is a diagram showing an example of product order data. FIG. 10 is a diagram showing an example of product sales data. FIG. 11 is a diagram showing an example of inventory data of a product. FIG. 12 is a diagram showing an example of the flow of a process for generating sales inventory forecast data by the product management device. FIG. 13 is a diagram showing an example of the analysis results of the sales inventory forecast data for individual item A. FIG. 14 is a diagram showing an example of the analysis results of the sales inventory forecast data for individual item B.

Embodiments of a product management device, a product management method, and a product management program according to the present invention are described in detail below with reference to the accompanying drawings. Note that the present invention is not limited to these embodiments.

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

The product management device 10 manages the inventory of individual products that a company delivers only to specific customers (clients). In this case, the customer (client) is another company, but it could also be the company's own manufacturing department, etc.

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

The product management device 10 comprises a control unit 11, a communication interface unit 12, a memory unit 13, and an input/output interface unit 14. Each unit of the product management device 10 is connected to each other so that they can communicate with each other via any communication path.

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 the function of communicating data with other devices via the communication line. Here, the network 100 has the 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.

The input/output interface unit 14 is connected to an input device 21 and an output device 22. The input device 21 can be a keyboard, mouse, microphone, or a monitor that functions as a pointing device in conjunction with the mouse. The output device 22 can be a monitor (including a home television), speaker, or printer. Note that below, the input device 21 may be referred to as a keyboard or mouse, and the output device 22 may be referred to as a monitor.

The memory unit 13 stores various databases, tables, files, etc. The memory unit 13 stores computer programs that work in conjunction with the OS (Operating System) to issue commands to the CPU (Central Processing Unit) to perform various processes. The memory 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 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 products. The order data 32 is data on individual products ordered by the company. The sales data 33 is sales data on individual products sold by the company. The inventory data 34 is the quantity of individual products remaining in the company.

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

As information processing, the control unit 11 performs inventory management processing based on various data stored in the memory unit 13. As part of the inventory management processing, the control unit 11 calculates the inventory rate, profit margin, and predicted inventory amount.

The control unit 11 manages inventory for individual items based on sales information and inventory information for each individual item. Here, sales information is order data 32 and sales data 33, and inventory information is inventory data 34.

The control unit 11 has an inventory rate calculation unit 41, a profit margin calculation unit 42, a first inventory forecast amount calculation unit 43, a second inventory forecast amount calculation unit 44, and a determination unit 45.

The inventory rate calculation unit 41 calculates the inventory rate of individual items 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 individual items based on the sales information and inventory information using the second formula ((sales price - month-end price)/sales price).

The first inventory forecast calculation unit 43 estimates the future inventory quantity of individual items based on sales information and inventory information. The second inventory forecast calculation unit 44 estimates the future inventory quantity of individual items based on sales information and inventory information from the previous year.

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.

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

As shown in Figure 2, our company enters into contracts with specific customers for various items. That is, we finalize the specifications of each item, confirm the expected shipping quantity of each item, and set the transaction price for each item. We also set the transaction period for each item and set 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.

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

[How to analyze inventory data by customer]
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 includes 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).

Figure 4 shows an example of product sales data. As shown in Figure 4, sales data 33 for an individual 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.

Figure 5 shows an example of inventory data for a product. As shown in Figure 5, inventory data 34 for an individual 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.

Figure 6 is a diagram showing an example of the flow of the process for generating customer-specific inventory data by the product management device. As shown in Figures 1 and 6, the inventory rate calculation unit 41 and profit rate calculation unit 42, which constitute 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 customer-specific inventory data. The output customer-specific inventory data includes the product code, product name, accounting year and month, end-of-month unit price, end-of-month quantity, end-of-month amount, sales price, sales amount, etc.

Figure 7 shows an example of the analysis results of inventory data by customer for individual items.

As shown in Figures 1 and 7, the inventory rate calculation unit 41 and profit rate calculation unit 42, which constitute the control unit 11, perform analysis based on the sales data 33 and inventory data 34, and output the results to a display from the output device 22 (see Figure 1). The output device 22 displays the accounting year and month, customer code, product code, and variety code as header sections (condition specifications) 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, sales unit 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 while the output device 22 displays data for two months here, it may also display data for one month, or data for three months or more.

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 (%)
Inventory rate for individual item A002 in November = (350/750) x 100 = 53.3 (%)

In customer-specific inventory data, the appropriate range for inventory rates is 50% to 200%, and this range serves as 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 November inventory rate for individual item A001 is 450.0%, which is higher than the threshold value, the October inventory rate for individual item A002 is 233.3%, which is higher than the threshold value, and the November inventory rate for individual item A002 is 46.7%, which is lower than the threshold value.

Then, the judgment unit 45 issues a warning for the November inventory rate of 450.0% for individual item A001, and also issues a warning for the October inventory rate of 233.3% and the November inventory rate of 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 may result in dead stock. Therefore, the judgment unit 45 displays the corresponding inventory rate display position in yellow. At this time, the person in charge needs to confirm the customer's future demand plan for individual items A001 and A002. Furthermore, the inventory rate for individual item A002 has fluctuated significantly from 233.3% in October to 46.7% in November, which may result in an opportunity loss due to inability to deliver the product. Therefore, the judgment unit 45 displays the corresponding inventory rate display position in red. At this time, the person in charge needs to check with the customer about future demand plans for individual items A001 and A002 and consider increasing inventory levels.

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 x 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 (%)

In inventory data by customer, a profit margin of 50% or more is in the appropriate range, and this range serves as the threshold. The judgment unit 45 compares the profit margins of individual items A001 and A002 with the threshold. The judgment unit 45 determines that the profit margins for individual items A001 and A002 in October and November are above the threshold, 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, a warning is issued, just like with inventory rates. The person in charge must then negotiate a price increase with the customer.

[How to analyze sales and inventory forecast data]
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 includes 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.

Figure 9 shows an example of product order data. As shown in Figure 9, order data 32 for an individual 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.

Figure 10 shows an example of product sales data. As shown in Figure 10, sales data 33 for an individual 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.

Figure 11 shows an example of inventory data for a product. As shown in Figure 11, inventory data 34 for an individual 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.

FIG. 12 illustrates an example of the flow of customer-specific inventory data generation processing by the product management device. As shown in FIGS. 1 and 12 , the first inventory forecast calculation unit 43 and the second inventory forecast calculation unit 44, which are components 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 based on sales dates and projected sales dates, and output sales inventory forecast data. The output sales inventory forecast data includes product codes, product names, projected contract expiration dates, order lots, order points, accounting years and months, and so on. The first inventory forecast calculation unit 43 and the second inventory forecast calculation unit 44 then output the inventory quantity, sales quantity, projected sales quantity, sales quantity for the previous year, projected inventory forecast, and last year's actual and projected inventory forecasts.

Figure 13 shows an example of the analysis results of sales inventory forecast data for individual item A.

As shown in Figures 1 and 13, 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 Figure 1). The output device 22 displays the accounting year and month, product code, and variety code as header sections (condition specifications) 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 end 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 end month. If the expected contract end date is earlier than the specified period, the display will extend up to the expected contract end date.

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

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

Figure 14 shows an example of the analysis results of sales inventory forecast data for individual item B.

As shown in Figures 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 Figure 1). The output device 22 displays the accounting year and month, product code, and variety code as header sections (condition specifications) 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, which is next month and beyond.

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 from December onwards is the forecast, and is the inventory quantity calculated by adding the planned sales quantity to the actual 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.

In the sales inventory forecast data, for the planned inventory forecast from December onwards and the inventory forecast last year, order 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 judgment unit 45 determines that there is a high possibility that there will be an inventory shortage of individual item A001. In addition, 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 judgment unit 45 determines that there is a high possibility that there will be an inventory shortage of individual item A001. Therefore, the judgment unit 45 displays the display positions of the corresponding multiple planned inventory forecasts 4, inventory forecast last year 2, and inventory forecast last year 1 in yellow.

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 judgment unit 45 determines that there is an even higher possibility of inventory shortages for individual item A001. In this case, a value lower than the order point 5 is set as the threshold value. Therefore, the judgment unit 45 displays the corresponding inventory forecast last year -4 and inventory forecast last year -5 in red. At this time, the person in charge will notify the customer that the inventory of individual item B001 is running low, confirm with the customer whether or not there has been an additional order for individual item A001, and plan to increase the inventory quantity of individual item A001 in accordance with the customer's request.

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

The product management device 10 of this embodiment estimates future inventory levels for individual items based on sales information and inventory information, thereby making it possible to appropriately manage inventory for individual items and reduce the occurrence of obsolete inventory.

In other words, by setting a customer for each product for individual items destined for a specific customer, the product management device 10 enables inventory management for each customer and product. The product management device 10 adds customer information, contract period, order point, and other analysis items 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 makes it possible to grasp inventory for each customer, and if there is inventory, it becomes 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 individual items are being shipped as planned or even better than planned, the product management device 10 can propose increasing the inventory of the individual items held, and manage appropriate shippable inventory to prevent stockouts. As a result, the risk of dead stock can be reduced and service can be improved to prevent stockouts.

In this embodiment of the product management device 10, the control unit 11 has a second inventory forecast calculation unit 44 that estimates the future inventory quantity of individual items based on sales information and inventory information from the previous year. Therefore, by comparing sales information and inventory information from the previous year, it is possible to accurately estimate the future inventory quantity of individual items.

In this embodiment of the product management device 10, the control unit 11 has a determination unit 45 that outputs a warning when the estimated inventory amount is below a preset threshold. This allows the person in charge to easily grasp the inventory surplus or shortage status of individual items.

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 early action to address the inventory of individual items.

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 item based on the second formula ((unit sales price - unit price at the end of the month) / unit sales price) using sales information and inventory information. This makes it possible to quickly adjust prices for customers according to the profit margin of each individual item.

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

Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to SDGs goals 12, 13, and 15.

Furthermore, this embodiment can contribute to strengthening control and governance, thereby contributing to Goal 16 of the SDGs.

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.

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.

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

Furthermore, with regard to the product management device 10, the components shown in the figure are functional concepts and do not necessarily have to be physically configured as shown.

For example, the processing functions of the product management device 10, particularly the processing functions performed by the control unit, may be implemented in whole or in part 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. In other words, a computer program that works in conjunction with the OS to issue commands to the CPU and perform various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and works in conjunction with the CPU to form the control unit.

This computer program may also be stored on 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.

In addition, the program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or may be configured as a program product. Here, this "recording medium" includes memory cards, USB (Universal Serial Bus) memories, 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 more. This includes any "portable physical media" such as a Blu-ray Disc (registered trademark) and a Blu-ray (registered trademark) Disc.

A "program" is a data processing method written in any language or description method, and may be in any format, such as source code or binary code. It should be noted that a "program" is not necessarily limited to a single structure, but also includes a distributed structure consisting of multiple modules or libraries, or a structure that achieves its function by working in conjunction with a separate program, such as an OS. The specific structure 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 structures and procedures.

The various databases stored in the memory unit are storage devices 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 website provision.

The product management device 10 may also be configured as an information processing device such as a known personal computer or workstation, or 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 processing described in this embodiment.

Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the figures, and all or part of them can be functionally or physically distributed and integrated in any unit depending on various additions or functional loads. In other words, the above-mentioned embodiments may be implemented in any combination, or embodiments may be implemented selectively.

This invention is useful for companies that deliver individual items.

REFERENCE SIGNS LIST 10 Product management device 11 Control unit 12 Communication interface unit 13 Storage unit 14 Input/output interface unit 21 Input device 22 Output device 31 Product master 32 Order data 33 Sales data 34 Inventory data 41 Inventory ratio calculation unit 42 Profit margin calculation unit 43 First inventory forecast amount calculation unit 44 Second inventory forecast amount calculation unit 45 Determination unit 100 Network 200 Server

Claims (6)

A product management device that manages 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. 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 . 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 . 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 . A product management method 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 quantity 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. 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 quantity 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.