JP2000053218A - Inventory management device and method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To facilitate the inventory management and keep the inventory to the necessary minimum by suppressing excessive order. SOLUTION: Delivery data including a delivery sum and a delivery date of each product is inputted by a delivery result data input part 2 and is stored in a delivery result data storage part 3. CPU 1 as a management information generation means reads the delivery data from the delivery result data storage part 3 and generates the management information on the product. The same CPU 1 as a rank information adding means gives a first rank at every product according to the delivery sum and a second rank according to the number of delivery days so as to add the rank information to each management information The same CPU 1 as a display control means selects the management information of the product based on the first rank and changes the arrangement of the selected management information based on the second rank so as to display on a display means 6.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an inventory management apparatus and method for managing inventory status of products (commodities).

[0002]

2. Description of the Related Art For example, the flow of industrial products usually goes from a producer such as a manufacturer to a wholesaler, and from there to a dealer who is a retailer through wholesalers as needed. And while wholesale wholesalers must stock enough products to run out of stock so that they can be supplied to dealers at any time, stocking too many products makes management more complicated and requires a large space as a warehouse. Occurs. Therefore, it is ideal for a wholesaler to minimize product stocks, and in this sense, inventory management is a very important factor.

Conventionally, for example, inventory management of wholesalers has been performed by the following method. That is, the total shipment amount of each product for a certain period of time, for example, the latest 13 weeks, is calculated, and the total shipment amount divided by the business day, that is, the shipment quantity per business day, is calculated. Inventory management was performed using a value multiplied by a certain coefficient as a reference value. Others
Methods such as a moving average method, a weighted average method, and an exponential smoothing method have also been adopted.

[0004]

However, in such a conventional inventory management method, it is not possible to grasp how much is actually shipped on the day of shipment.
In other words, each product is not shipped on every business day, and the date of shipment varies depending on the product but is only a few of the number of business days. The average shipments made did not make much sense.

[0005] For this reason, at the site, it is not possible to rely on the stock amount, and at present, the purchaser places an order based on his / her experience and the like depending on the feeling. Therefore, such a conventional inventory management method is not only incompatible with the current situation that requires an inventory flow type of “hold when necessary”, but also causes frequent ordering or out of stock. There was a danger of doing. In addition, in the conventional inventory management method, the storage capacity of the entire distribution center is not considered so much, and the quantity required for each product is ordered based on demand forecast. Could not do.

The present invention has been made in view of the above circumstances, and sets a standard stock (maximum stock amount) of each product so as to match a set total stock target amount, and performs inventory operation at or below that level. Accordingly, an object of the present invention is to provide an inventory management apparatus and method that can facilitate inventory management, suppress unnecessary orders, and minimize the amount of inventory.

[0007]

In order to achieve the above object, the present invention has the following arrangement. That is, the inventory management device according to the present invention includes a shipping data input unit for inputting shipping data including a shipping amount and a shipping date for each product, and a shipping data storage unit for storing shipping data input from the shipping data input unit. Management information generating means for reading out the shipping data of the product from the shipping data storage unit and generating management information on the product for each product based on the shipping data; and a first information corresponding to the shipping amount for the product. Rank information adding means for assigning a second rank according to the number of days of shipment, and adding rank information representing the first and second ranks to each management information of the product; and Display means for displaying management information of the product, and management information of the product to be displayed on the display means are selected based on the first rank, and selected. Characterized by comprising a display control means, a to the display the management information on the display unit are rearranged based on the second rank.

According to this device, the management information of the product includes:
A first rank according to the shipping amount and a second rank according to the number of shipping days are added and displayed on the display means. At this time, the display control means selects the management information of the product to be displayed based on the first rank. For example, when “A”, “B”, and “C” are given as the first rank, management information of a product belonging to, for example, rank [A] is selected according to a user's instruction.

The display control means rearranges the selected management information based on the second rank and causes the display means to display the selected management information. For example, as the second rank, "1", "2",
When “3” is given, for example, the display is made in the order of rank “1” to “3”. Therefore, the management information is displayed according to the first and second ranks given to the product, and it is possible to easily grasp the stock status of the product.

[0010] The management information generating means may be, for example,
Extracting means for extracting shipping data within a predetermined period from the shipping data stored in the shipping data storage unit; total shipping amount calculating means for calculating a total shipping amount from the extracted shipping data; and shipping from the extracted shipping data. Counting means for counting days, and average shipping quantity calculating means for dividing the total shipping quantity by the shipping days to obtain an average shipping quantity per shipping day, wherein the rank information adding means comprises:
First sorting means for sorting the shipment data in descending order of the shipping amount, and first grouping means for grouping the sorted shipping data according to the shipping amount and assigning the first rank A second sorting unit that sorts the shipment data grouped by the first grouping unit in ascending order of shipping days for each group; and the shipping unit sorted by the second sorting unit. And a second grouping means for grouping data according to the number of shipping days for each group and assigning the second rank. Therefore, according to this management information generating means, it is possible to rearrange the shipping data in descending order of the shipping amount and to assign the first rank, and to rearrange the shipping data in descending order of the shipping days and to assign the second rank. .

Further, the management information generating unit further includes, for example, a setting unit for setting a coefficient by which the average shipment amount calculated by the average shipment amount calculation means is multiplied for each of the first groups to obtain a maximum inventory. It is characterized by having. According to this, it is possible to obtain the maximum stock for each first group.

The setting unit sets, in addition to the maximum stock, a coefficient by which an average shipment amount for determining an order point and an order unit is set for each group specified by the first grouping means. The means displays an order point and an order unit in addition to the maximum stock calculated by multiplying the average shipment amount by a coefficient. According to this, it is possible to display the maximum stock, the order point, and the order unit as the management information.

Further, the management information generating means includes, for example,
When shipping data within a certain period is extracted from the shipping data stored in the shipping data storage unit, the shipping data is updated by including new data in data to be extracted every predetermined period. Further, when the rank information adding means groups the products based on the shipping amount ranking for a certain period, the products are grouped based on the square root of the shipping amount. This allows
Numerical expressions suitable for management are possible.

[0014] In the inventory management method according to the present invention, a step of inputting shipping data including a shipping amount and a shipping date for each product, a step of storing the input shipping data, and reading out the stored shipping data. Generating management information on the product for each product based on the shipping data; assigning a first rank to the product according to the shipping amount and assigning a second rank according to the number of shipping days Adding the rank information indicating the first and second ranks to each management information of the product; selecting the management information of the product based on the first rank; and selecting the selected management information. Rearranging and displaying based on the second rank. Thereby, the management information is displayed according to the first and second ranks given to the product, and it is possible to easily grasp the stock status of the product.

[0015]

Embodiments of the present invention will be described below with reference to the drawings. FIG. 1 is a block diagram of an inventory management device according to the present invention. In FIG. 1, reference numeral 1 denotes a CPU (control device), which includes an operation unit 1 a that performs an operation described later,
It functions as management information generating means, rank information adding means, and display control means. The CPU 1 includes a shipping result data input unit 2 (shipping data input unit) for inputting product shipping result data (item, shipping amount, shipping date), and a shipping result data storage unit 3 for storing the product shipping data, respectively. (Shipping data storage unit), setting unit 4 for determining coefficients for determining the maximum stock, ordering point and ordering unit to be described later, the average shipment quantity per shipping day for each product, maximum stock, ordering point and ordering unit And a display unit 6 (display unit) for storing data such as data.

The management information generating means realized by the CPU 1 is means for extracting shipping data within a fixed period from the shipping data stored in the shipping result data storage unit 2, and the total shipping data based on the extracted shipping data. Total shipping amount calculating means for calculating the quantity, counting means for counting the shipping date from the extracted shipping data, and average shipping quantity for dividing the total shipping quantity by the shipping days to obtain an average shipping quantity per shipping day. Calculation means.

The rank information adding means also realized by the CPU 1 includes a first sorting means for sorting shipping data in descending order of the shipping amount, and a grouping means for sorting the sorted shipping data in accordance with the shipping amount. A first grouping unit that divides and assigns a shipping amount rank (first rank), and a second unit that sorts the shipping data grouped by the first grouping unit in descending order of shipping days for each group. And a second group that assigns a shipping days rank (second rank) by grouping the shipping data sorted by the second sorting means according to the number of shipping days for each group. Consisting of dividing means

A procedure for determining a base stock value when setting the maximum stock, order point, and order unit will be described with reference to the flowchart shown in FIG. In advance, the user operates the shipping data input unit 2 to input shipping data of each product to this device. This shipment data is stored in the shipment result data storage unit 3 for each product name.

Step S1: First, the CPU 1 stores the product names of the past 13 weeks based on the present time among the stored data in the product shipment result data storage unit 3 inputted and stored from the shipment result data input unit 2, Shipping quantity, shipping amount,
Read shipping result data such as shipping date and notification destination (extraction means). Step S2: It is determined whether or not the file is completed. If the file is completed, the process ends. If not, the process proceeds to step S3.

Step S3: When the shipment amount of the numerical value stored in the data is, for example, 30 or more and is not a standard value (step S3: NO), the process returns to step S1. That is, in this case, for example, for a sales promotion, it is treated as a special case (a special sale) that is stacked and sold near a register of a retail store such as a supermarket, and is shipped per day as described later. Will not be used as data when calculating the average shipment volume of This is because if such data is handled as data, an average value cannot be calculated.

In this step S3, when the shipment amount is, for example, 30 or more, and the shipment amount is not the standard amount, the process returns to the step S1, but at what level the standard amount and the special sale amount are separated. Since the level differs depending on the sales situation (customers and regional characteristics) of the wholesalers, the level at which the standard and special sales are separated may be set according to the circumstances of each wholesaler.

Step S4: If the shipment amount is less than, for example, 30 packages, the process proceeds to step S4, where the shipment amounts are summed up by product name, and the square root is determined for each. The meaning of obtaining the square root will be described later in detail. Step S5: Next, the shipping date recorded in the shipping result data is counted for each product name (counting means), and the number of shipping days for each product name is obtained.

Step S6: Next, the actual shipment / day is calculated for each product name. That is, as described above, the total shipment amount is obtained from the data read for the last 13 weeks for each product name (total shipment amount calculation means), and the result is divided by the number of shipping days to obtain the average shipping amount per shipping day (average shipment amount). Shipping amount calculation means).

More specifically, as shown in FIG. 4, for example, if the total shipping amount in the last 13 weeks is 120 and the shipping days are 30 days, the shipping amount per shipping day is 4 days. Becomes Incidentally, the one shown in the lower column of the figure shows an example in the case where the conventional shipping average number is calculated for comparison. According to this example, the shipping amount is changed from 120 to 60 ( Days) to obtain 2 shipments per business day.

Step S7: Next, the maximum shipment amount / day is calculated for each product name. Step S8: Next, a file for each product name (amount of shipment per shipment date per product name and a square root of the shipping amount)
Write out. As described above, the base value for obtaining the maximum stock, order point, and order unit described below is determined.

Next, a procedure for obtaining the maximum stock and the order point will be described with reference to the flowchart shown in FIG. Step S10: First, an inventory target amount is set.
Hereinafter, inventory management is performed at a level lower than the level of the inventory management target amount. Step S <b> 11: The number of days of holding the product name for each rank and the coefficient of the order point (number of days) are set via the setting unit 4. These values are set based on the money amount ranking ("S" to "D") as shown in FIGS.

For example, the calculated average shipping amount per shipping day per day, for example, 4 times the number of holding days represents the standard stock, that is, the maximum stock. In addition, shipping date 1
The average shipment quantity per day, for example, 4 times the ordering point (for 3 days) is the ordering point, and indicates that an order must be made when the inventory decreases to this quantity.

Steps S12 and S13: Sort the files by product name in ascending order of the value of the square root of the shipping amount calculated in step 4 (first sorting means). Then, the file is read for each product name. Steps S14 and S15: It is determined whether or not the reading of the file has been completed. If the reading has been completed, it is next determined whether or not the file meets the inventory target amount. If it does not match the stock target amount, the process returns to step 11, and if it does, the process ends. If it is determined that the file does not end, the process proceeds to step S16.

Step S16: Next, the total of the square root of the calculated shipping amount is obtained, and the shipping amount rank (first order) is calculated.
Settings). In other words, as shown in FIG.
The ranking is set based on the analysis.

Here, FIG. 5 will be described. In this figure, the horizontal axis represents the quantity of the product item, and the vertical axis represents the accumulated shipment value for a predetermined period. 6
8%, and the highest 14% of the total amount accounts for about 82% of the total shipping amount for a predetermined period.

Here, based on the square root of the shipping amount of the merchandise item (see the VE coefficient curve in FIG. 5), the highest 0 to 20% is ranked “S”, and the next highest value is 2
0 to 40% rank "A", next highest 40 to 60
% Is classified into rank "B", the next highest 60-80% is classified into rank "C", and the last 80-100% is classified into rank "D". The reason why the product names are divided on the basis of the shipping amount rather than the shipping amount is not to make the stock ratio and ordering unit uniform for all the product names, but to add a level based on the sales amount.

In order to classify the product name according to the shipping amount, the square root is used as a reference. When the shipping amount is used directly, for example, the product name belonging to the previous rank “S” may be changed due to a slight change in shipment. This is because it may belong to “A” or belong to the rank “B”, and the management may be troublesome due to excessive fluctuation.

Step S17: Next, for the product name for which the shipping amount rank has been set, a shipping days rank (second rank) is set for each shipping amount rank. That is,
The product name files for each shipping amount rank are sorted in descending order of shipping days (second sorting means), and shipping day ranks are assigned according to shipping days. As a result, as shown in FIG. 9, the products to which the shipping amount rank has been assigned are further classified according to the number of shipping days.

In the example shown in FIG.
Those that exceed 0% are ranked "1", those whose shipping days occupy 50-80% of business days are ranked "2", and those whose shipping days occupy 20-50% of business days are rank "3", shipped. Those whose days occupy 5 to 20% of business days are classified into rank "4", and those whose shipping days occupy 5% or less of business days are classified into rank "5".

In this example, the rank "A" is further classified into the shipping date ranks "1" to "5", but the products belonging to each of the other ranks "B" to "D" are shown. Similarly, for the shipping days rank "1" to "5"
Is given. Information on the shipping amount rank and the shipping days rank is added to the management information for each product name as rank information.

Step S18: Next, the reference stock amount is set by the management information generation means realized by the CPU 1, and management information is created for each product name. Here, the reference stock amount (maximum stock) can be obtained by multiplying the average shipping amount per shipment day by the number of holding days for each rank.

More specifically, for example, as shown in FIG. 9, the rank "S
1 and rank A1 have 7 days
Day, those belonging to rank "B1" have eight days of holding, those belonging to rank "C1" have five days, and those belonging to rank "D1" have six days. The standard stock amount can be obtained by multiplying the average shipment amount per shipping day.

Note that FIG. 6 will be supplementarily explained. FIG. 6 shows the number of holding locations of products belonging to each rank.

The holding place indicates the holding place of the product name. Those belonging to the ranks "S" and "A" are:
There are two places, for example, a state of being stored in the cardboard and a so-called rose state taken out of the cardboard, and one belonging to ranks "B", "C", and "D" is one place and all Stored in roses.

Step S19: Subsequently, an order point is set. In other words, it can be obtained by multiplying the average shipment amount per shipping day by the set number of ordering days for each rank. Specifically, the number of days of the order point is, for example, as shown in FIG.
Items belonging to “1” and “A1” have five ordering days. In this way, the number of ordering days is determined for each product name as appropriate for each rank, and these are multiplied by the actual shipping date per the shipping date. Then, when the inventory decreases below the order point, an order is placed with a maker or the like.

Similarly, the order unit is set. The order unit can be obtained by converting the actual shipment amount (bulk) per day on the shipping date into a package. The actual order quantity is obtained as the product obtained by subtracting the current warehouse from the standard stock by the order unit (package or inner box) and multiplying the quotient by the order unit (that is, a multiple of the order unit).

Here, in the example of FIG. 7, the number of days for ordering is three days, but the breakdown is that safety stock is one day and lead time is two days. If the ordering unit is more than the pallet face unit, the order unit shall be set to the unit / multiple.

Steps S20 and S21: Next, after rewriting the product name file (reference stock file),
Add the stock value by product name. When the above operation is completed, the process returns to step S13, and the same process is repeated for all the files. From the above, the maximum stock, order point, and order unit are obtained.

Next, the display control means realized by the CPU 1 performs display control for displaying management information on each product on the display means 6. Specifically, the management information of the product to be displayed on the display means 6 is selected based on the shipping amount rank (first rank), and the selected management information is arranged based on the shipping days rank (second rank). Instead, the display of the display means 6 is controlled.

When displaying this management information,
The user designates a shipping amount rank to be displayed from the input unit 2 or the setting unit 4. The specification of the shipping amount rank can be performed by specifying any of the shipping amount ranks “S” to “D”, and an arbitrary plurality of shipping amount ranks can be specified. You can also specify a rank. The shipment price rank specified here is displayed.

FIG. 10 shows a display example based on only the shipping amount rank. In this example, for each rank, the number of items,
The average monthly shipping amount, the standard stock amount, and the stock ratio are displayed. That is, the number of items (number of products) belonging to rank “S” is 383, the number of items belonging to rank “A” is 752, and the number of items belonging to rank “B” is 1,25.
0 items with 2,150 items belonging to rank "C"
The total number of the products, 5,570 items belonging to the rank “D”, and the product name by product name is 10,105 items.

For the products belonging to rank "S", the standard stock amount is 86,300,000 yen, the average monthly shipping amount is 283,500,000 yen, and the stock ratio is 0.30.
It is. For the product name belonging to rank "A", the standard stock price is 53,100,000 yen and the average monthly shipping value is 1
34,100,000 yen, stock ratio of 0.40, and reference stock amount of 63,7 for product names belonging to rank "B"
00,000 yen, average monthly shipping amount is 80,600,0
For a product name belonging to "C", the reference stock amount is 82,850,000 yen, the average monthly shipping amount is 47,970,000 yen, and the stock ratio is 1.7.
3. For "D", the standard stock amount is 76,700,0
00 yen, monthly average shipping amount is 21,840,000 yen,
The stock ratio is 3.51.

Then, when the number of days of shipment per day is set as described above and the standard stock of each product is totaled, the total stock ratio is 0.64 months. This value is significantly reduced compared to the case where the number of inventories by the conventional inventory management method before adopting this method was one month or more, and despite this, almost no trouble such as out of stock has occurred It became clear.

As described above, inventory was kept low while troubles such as out-of-stocks were suppressed because the standard stock, order point and order unit were constructed based on the quantity per day on the shipping day. This is because it is possible to set the stock amount and the order amount according to the actual situation while being simple.

FIG. 9 shows a display example (specification by rank) based on the shipping amount rank and the shipping days rank. In this example, the shipping date rank is further given to the product name to which each shipping amount rank is assigned, and each product is classified by the shipping amount rank and the shipping date rank. Classified into small ranks.

The inventory by rank shown in FIG. 9 makes it possible to grasp the stock status for each shipping amount, and also to immediately grasp the shipping days. Further, by changing the designation of the shipping amount rank to be displayed, it is possible to display only a specific shipping amount rank, and unnecessary information can be organized. In addition, according to the rank-specific details shown in the figure, it is possible to grasp the stock status of the product by the number of shipping days, so that it is possible to prevent out-of-stock and to further improve the reliability of inventory management. Become.

In the above embodiment, the inventory management device of the present invention has been described by taking a wholesale store as an example. However, the present invention is not limited to a wholesale store, but may be applied to a manufacturer or a retail store. Applicable. In the above embodiment,
The sorting ranking setting for each shipment amount of products used when setting the number of days to hold and the number of order points is set based on the square root of the shipment amount, but it is not limited to this, and up to 250 product names Product is ranked "S", the next 500 products are ranked "A",
It is also possible to simply determine the order of the shipping amount.

Further, in the above embodiment, the product is divided into five stages of the shipping amount rank "S", "A", "B", "C", and "D", but the invention is not limited to this. , Three or four stages, or six or more stages. In the above embodiment, the rank “S1”,
The number of days for holding the product name belonging to "A1" is "7 days" and the ordering point is "5 days", but this is only an example,
Of course, it is of course possible to change these values so that they actually match.

Further, in the above embodiment, the average shipment amount per day on the shipping date is obtained, multiplied by a coefficient, the maximum stock, the ordering point, and the ordering unit are obtained and displayed on the display unit 6. However, the present invention is not limited to this. Further, the stock data is input for each of the latest products, and the comparing unit compares the stock data with the order point. When the stock data decreases from the order point, the order is placed. The unit may be displayed on the display unit 6. The display unit 6 may be a display device using a screen, or a device that outputs data to the outside by a printer.

Further, in the above embodiment, the shipping days rank is set after the shipping amount rank is set. However, after the shipping amount rank is set, the display is controlled by the display control means described above. A product name to be selected may be selected, and the shipping days rank may be set only for the selected product name. As a result, it is possible to reduce the addition of the processing for setting the shipping date rank.

Furthermore, in the above embodiment, the inventory management information is displayed by specifying the shipping amount rank. However, the shipping date rank may be additionally specified. This makes it possible to display only necessary inventory management information.

Further, in the above embodiment, the ranking is performed by the shipping amount rank, and the product name of each shipping amount rank is further ranked by the shipping days rank. Conversely, the product names are ranked first by the shipping days rank. It is also possible to configure a device that ranks the product names of each shipping days rank by the shipping amount rank. Further, other ranks can be provided in place of the shipping amount rank and the shipping days rank, and other ranks can be provided in addition to the shipping amount rank and the shipping days rank.

[0058]

As described above, according to the present invention, the following effects can be obtained. That is, according to the inventory management device of claim 1 of the present invention, a first rank is assigned to a product in accordance with the shipping amount and a second rank is assigned in accordance with the number of shipping days. Rank information indicating the first and second ranks is added to each management information of the product, the management information of the product is selected based on the first rank, and the selected management information is rearranged based on the second rank. Since the information is displayed on the display, the stock status can be immediately grasped, so that the stock management becomes easy, and the unnecessary order can be suppressed to minimize the stock amount.

Further, according to the inventory management device of the second aspect of the present invention, the shipping data within a certain period is taken out from the shipping data stored in the shipping data storage unit, and the shipping data is stored on a daily basis based on the shipping data. And the shipping data is grouped according to the shipping amount and given a first rank, and the shipping data is grouped according to the number of shipping days and given a second rank. Therefore, it is possible to assign the first rank by sorting the shipping data in descending order of the shipping amount and to assign the second rank by sorting the shipping data in descending order of the shipping days.

Further, according to the inventory management device of the third aspect of the present invention, the coefficient for multiplying the calculated average shipment amount is set for each of the first groups to determine the maximum inventory, so that the management is performed. The maximum stock can be displayed as information.

Furthermore, according to the inventory management apparatus of the fourth aspect of the present invention, in addition to the maximum stock, a coefficient for multiplying the average shipment amount for determining the ordering point and the order unit by the first grouping means. The maximum inventory and the order unit are displayed for each group, as well as the maximum inventory calculated by multiplying the average shipment quantity by a coefficient, the order point and the order unit. Management becomes easy.

Further, according to the inventory management device of the present invention, when the shipment data within a certain period is taken out of the shipment data stored in the shipment data storage unit, the data to be taken out every predetermined period is used. Since the shipment data is updated including new data, inventory management based on the latest shipment data becomes possible.

Further, according to the inventory management device of the sixth aspect of the present invention, when the products are grouped based on the shipping amount ranking for a certain period, the products are grouped based on the square root of the shipping amount. So
Numerical expressions suitable for management become possible, and it becomes easy to grasp the stock status.

According to the inventory management method described in claim 7 of the present invention, a first rank is assigned to a product in accordance with the shipping amount and a second rank is assigned in accordance with the number of shipping days. Adding the rank information indicating the first and second ranks to each management information of the product, selecting the management information of the product based on the first rank, and assigning the selected management information to the second rank. Since the items are rearranged and displayed based on the order, the inventory status can be immediately grasped. Therefore, inventory management becomes easy, and unnecessary orders can be suppressed to minimize the amount of inventory.

[Brief description of the drawings]

FIG. 1 is a block diagram illustrating a configuration of an inventory management device according to an embodiment of the present invention.

FIG. 2 is a flowchart illustrating a procedure for calculating an average shipment amount per shipment day.

FIG. 3 is a flowchart showing a procedure for obtaining a maximum stock, an order point, and an order unit.

FIG. 4 is a diagram showing a shipping situation.

FIG. 5 is a diagram for explaining ABC analysis.

FIG. 6 is a diagram showing holding locations by product rank.

FIG. 7 is a diagram showing a relationship between a standard stock, an order point, and an order unit.

FIG. 8 is a diagram for explaining a relationship between a shipping amount rank (first rank) and a shipping days rank (second rank) according to the present invention.

FIG. 9 is a diagram showing a display example of inventory management information (by shipping amount rank and shipping days rank) by the inventory management device according to the embodiment of the present invention.

FIG. 10 is a diagram showing a display example of inventory management information (by shipment value rank) by the inventory management device according to the embodiment of the present invention.

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 1 ... CPU (control apparatus), 1a ... Operation part, 2 ... Shipment result data input part, 3 ... Shipment result data storage part, 4 ... Setting part, 5 ... File, 6 ... Display means, S1-S8, S10
~ S21 ... Step.

 ──────────────────────────────────────────────────続 き Continued on the front page F term (reference) 3F022 EE08 MM07 MM21 MM28 MM30 MM32 5B049 CC27 EE01 EE31 EE59 FF03 FF04

Claims (7)

[Claims] 1. A shipping data input unit for inputting shipping data including a shipping amount and a shipping date for each product; a shipping data storage unit for storing shipping data input from the shipping data input unit; A management information generating unit for reading out the shipment data of the product from the unit and generating management information on the product for each product based on the shipment data; and assigning a first rank to the product according to the shipping amount. A rank information adding unit that assigns a second rank according to the number of days of shipment and adds rank information indicating the first and second ranks to each management information of the product, and displays the management information of the product. Display means for selecting, based on the first rank, management information of a product to be displayed on the display means, and Inventory management apparatus characterized by comprising a display control means for displaying on the display unit are rearranged based on the ranks. 2. The management information generating unit includes: a retrieval unit that retrieves shipment data within a predetermined period from the shipment data stored in the shipment data storage unit; and a total shipment that calculates a total shipment amount from the retrieved shipment data. Quantity calculating means, counting means for counting a shipping date from the extracted shipping data, and average shipping quantity calculating means for dividing the total shipping quantity by the shipping days to obtain an average shipping quantity per shipping day. The rank information adding means, a first rearranging means for rearranging the shipping data in descending order of the shipping amount; and a grouping of the rearranged shipping data in accordance with the shipping amount, thereby forming the first rank. First grouping means for assigning, and the shipping data grouped by the first grouping means in the order of the number of shipping days for each group. A second sorting means for sorting, and a second group for assigning the second rank by grouping the shipment data sorted by the second sorting means according to the number of shipping days for each group. An inventory management device comprising: a dividing unit; 3. The management information generation unit further includes a setting unit for setting a coefficient by which the average shipment amount calculated by the average shipment amount calculation unit is multiplied for each of the first groups to obtain a maximum inventory. 3. The inventory management device according to claim 2, wherein: 4. The setting unit sets, in addition to the maximum stock, a coefficient by which an average shipment amount for determining an ordering point and an ordering unit is set for each group specified by the first grouping means. 4. The inventory management device according to claim 3, wherein the means displays an order point and an order unit in addition to the maximum inventory calculated by multiplying the average shipment amount by a coefficient. 5. The method according to claim 1, wherein said management information generating means includes a step of, when extracting shipping data within a predetermined period from the shipping data stored in said shipping data storage unit, including new data in the data extracted every predetermined period. The inventory management device according to claim 2, wherein the data is updated. 6. The method according to claim 2, wherein the rank information adding unit groups the products based on a square root of the shipping amount when the products are grouped based on the shipping amount ranking for a certain period. Inventory control device. 7. A step of inputting shipping data including a shipping amount and a shipping date for each product; a step of storing the input shipping data; reading the stored shipping data; Generating management information on the product for each product; assigning a first rank to the product in accordance with the shipping amount and assigning a second rank in accordance with the number of shipping days; Adding rank information indicating a rank of 2 to each management information of the product; selecting management information of the product based on the first rank; and selecting the selected management information based on the second rank. And displaying the information in a sorted order.