JP2015185006A - Inventory management apparatus - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an inventory management apparatus capable of supporting an inventory manager.SOLUTION: An inventory management apparatus 1 has a control section that controls to set a regression line 110 which has a predetermined angle on a coordinate axis constituted of first parameter featuring the inventory state of a product and a second parameter featuring the inventory state of the product; to set a rectangular selection area 120 separated away from the regression line 110 by a distance 0 or more; and to display the set regression line 110, the selection area 120 and a plotted scatter diagram on a display section.

Description

  The present invention relates to a product inventory management apparatus.

  Companies that operate businesses such as manufacturing, logistics, and retail manage inventory of a very large number of products (eg, thousands or tens of thousands). In inventory management, problems such as excess inventory or inventory shortages can occur, and such problems need to be discovered and resolved early. However, since problems related to inventory management occur for each product, it is necessary to determine a procedure for solving such problems for each product. However, since there are so many types of products that are managed in stock, determination of such procedures requires enormous effort and time.

  Japanese Patent Application Laid-Open No. 2004-228561 describes a technique for supporting a discovery of a problem in inventory management related to a specific product by displaying a scatter diagram plotted for each product.

JP 2011-180677 A

  However, in a specific field, there is a case where it is necessary to select an oblique rectangle with respect to the screen area, so there is still room for improvement in support for those who perform inventory management.

  Therefore, an object of the present invention is to strengthen support for those who perform inventory management in order to solve the above-described problems.

  In order to solve the above problems, an inventory management apparatus according to the present invention provides a plurality of types of products on a coordinate axis composed of a first parameter that characterizes the inventory status of a product and a second parameter that characterizes the inventory status of the product. Comprising a display unit that displays a scatter diagram in which points corresponding to are plotted, and is a stock management device that supports decision making of product stock management, wherein the control unit of the stock management device sets a predetermined angle on the coordinate axis. The regression line is set and a classification range for classifying the plotted scatter diagram is set as the rectangular selection region in a direction deviating from the regression line, and the set regression line and the rectangular selection region are plotted. Control which displays a scatter diagram on the said display part is performed.

  ADVANTAGE OF THE INVENTION According to this invention, the assistance to the person who performs inventory management can be strengthened.

It is a software block diagram of the inventory management apparatus which concerns on embodiment of this invention. It is a figure which shows an example of the data structure of the product master T1 of the inventory management apparatus which concerns on the said embodiment. It is a figure which shows the database which has registered the track record information which shows the operation track record of the stock management of the product of the stock management apparatus which concerns on the said embodiment. It is a figure which shows the specific example of the production performance of the inventory management apparatus which concerns on the said embodiment, a sales performance, and an inventory performance. It is a figure which shows the example of a display of the scatter diagram of the inventory management apparatus which concerns on the said embodiment. It is a figure explaining the area | region selection on the scatter diagram of the inventory control apparatus which concerns on the said embodiment. It is a figure explaining the effectiveness of the area | region selection on the scatter diagram of the inventory management apparatus which concerns on the said embodiment. It is a figure explaining the auxiliary | assistant function of the area | region selection on the scatter diagram of the inventory management apparatus which concerns on the said embodiment. It is a figure explaining the reference line calculation of the area | region selection on the scatter diagram of the inventory management apparatus which concerns on the said embodiment. It is a figure which shows the scatter diagram in the analysis example 1 of the inventory management apparatus which concerns on the said embodiment. It is a figure which shows the scatter diagram in the example 2 of an analysis of the inventory management apparatus which concerns on the said embodiment. It is a figure which shows the scatter diagram in the example 3 of an analysis of the inventory management apparatus which concerns on the said embodiment. It is a figure which shows the scatter diagram in the example 4 of analysis of the inventory management apparatus which concerns on the said embodiment. It is a figure which shows the scatter diagram in the example 5 of an analysis of the inventory management apparatus which concerns on the said embodiment. It is a figure which shows the scatter diagram in the example 6 of analysis of the inventory management apparatus which concerns on the said embodiment.

  Hereinafter, a mode for carrying out the present invention (referred to as “the present embodiment”) will be described in detail with reference to the drawings. Further, in all the drawings for explaining the present embodiment, the same parts are denoted by the same reference numerals in principle, and the repeated explanation thereof is omitted.

[Constitution]
The inventory management apparatus 1 according to the present embodiment is a computer including hardware such as an input unit, an output unit, a control unit, and a storage unit. The input unit includes, for example, an input interface and includes means operated by a user such as a pointing device. The output unit includes, for example, an output interface and includes a display unit such as a display. The control unit includes, for example, a CPU (Central Processing Unit) and a dedicated circuit. The storage unit includes, for example, a storage medium such as a random access memory (RAM), a read only memory (ROM), a hard disk drive (HDD), and a flash (registered trademark) memory. When the control unit is composed of a CPU, information processing by a computer including the control unit is realized by a program execution process by the CPU. Further, the storage unit included in the computer stores a program (including a program for inventory management) that is instructed by the CPU and implements the function of the computer. This realizes cooperation between software and hardware.

  The present embodiment can be realized by a program for executing the information processing, and the program can be provided by being stored in a computer-readable recording medium (eg, CD-ROM). The program can also be provided through a network such as the Internet.

  As shown in FIG. 1, the inventory management apparatus 1 includes software components such as an XY axis item selection unit 11, a scatter diagram generation unit 12, an item extraction unit 13, a product master T1, and performance data T2. Yes.

  The XY axis item selection means 11 selects an item defined on the horizontal axis (X axis) and an item defined on the vertical axis (Y axis) of the two-dimensional scatter diagram displayed on the display unit of the inventory management apparatus 1. This item is a parameter (first parameter, second parameter) that characterizes the stock status of the product, and includes, for example, the stock amount of the product within a predetermined period and the sales amount of the product within the predetermined period. The item selection can be realized, for example, as a GUI (Graphical User Interface) operation by the input unit of the inventory management apparatus 1.

The scatter diagram generation means 12 generates a scatter diagram composed of the horizontal axis determined by the XY axis item selection means 11 and the vertical axis. In this scatter diagram, points corresponding to all or a part of products registered in the product master T1 and the record data T2 are plotted. In other words, the scatter diagram generation means 12 refers to the value of the parameter relating to the inventory management of the product stored in the product master T1 and the actual data T2, and sets the point corresponding to the product to a predetermined position in the scatter diagram. Plot.
The scatter diagram generation means 12 sets a regression line having a predetermined angle on the coordinate axis, sets a rectangular selection area that is separated from the regression line by a distance of 0 or more, and sets the set regression line and the scatter chart plotted with the selection area. Display on the display.

  The item extraction unit 13 selects a rectangular selection region including a part of the points plotted in the scatter diagram generated by the scatter diagram generation unit 12, thereby extracting an item corresponding to the rectangular selection region. Moreover, the item extraction means 13 may extract an item by selecting one or a plurality of points on the scatter diagram by the input unit.

The product master T1 is a database that stores the actual inventory of products that are subject to inventory management. FIG. 2 is a diagram illustrating an example of a data structure of the product master T1. The product master T1 includes fields such as “SKU (Stock Keeping Unit) code”, “business group”, “category”, “brand”, “date”, “cumulative sales amount”, and “stock amount”.
The “SKU code” is an identification number of a product that is subject to inventory management (sometimes simply referred to as a product code).
“Business group” is the name of a business group such as production and sales of products subject to inventory management.
“Category” is the name of the classification when the products subject to inventory management are classified by characteristics, quality, and the like.
“Brand” is the name of a brand of a product that is subject to inventory management.

The “date” is a date for determining the actual product inventory, and the inventory transition of the product can be tracked on a daily basis. The week, month, and year may be determined according to the type of product, and tracking may be performed on a weekly, monthly, or yearly basis. For convenience of explanation, it is assumed that the product master T1 includes a record related to the daily product.
The “cumulative sales amount” indicates the total amount of actual sales when the product is sold in the market in a certain period until the date indicated by “date”. For convenience of explanation, it is shown as a monetary amount. Basically, since the unit price of the product is determined, it may be shown as the quantity of the product.
“Inventory amount” indicates the actual amount of stock when the corresponding product is stocked in a predetermined space on the same day.

In the product master T1 of FIG. 2, for example, focusing on the record in the first line, the product of the SKU code 100001 is handled by the X business GR, and belongs to the category A and has the brand α. On February 1, 2013, it has been shown that sales have been made for ¥ 40,000 so far, and there is a stock amount corresponding to the amount of ¥ 77,000,000.
Note that “business group”, “category”, and “brand” are selection candidates for classification items to be described later.
In addition, “cumulative sales amount” and “inventory amount” are the feature amounts (first feature amount, second feature amount) that become the X-axis (horizontal axis) and Y-axis (vertical axis) of the graph of the scatter diagram described later. ).
The basic information registered in the product master T1 is not limited to that shown in FIG. 2, for example, other basic information may be added, or some of the information shown in FIG. 2 may be omitted. May be.

  The performance data T2 is a database in which performance information indicating operation performance of product inventory management is registered. Referring to FIG. 3, the record data T2 includes fields such as “SKU code”, “stock record”, and “sales record”, and a record is created for each product. Moreover, the performance data T2 can be configured in a format in which a plurality of daily performance information is collected, for example, in a format in which a plurality of performance information over a predetermined period such as 1 hour, 1 month, and 1 year is combined. You can also. Further, for example, it is possible to create one-year performance information from one-day performance information by a predetermined calculation. That is, the record data T2 can register record information for an arbitrary period.

The “SKU code” is equivalent to the “SKU code” shown in FIG.
In the “inventory record”, the value of the inventory amount of the product is registered. As the value of the stock quantity, for example, it may be expressed by a quantity, or may be displayed by an amount obtained by multiplying the quantity by the unit price of the product. In addition, the product inventory amount may be the inventory amount at hand, or the inventory amount that is not at hand but can be procured immediately if there is an order.
In the “sales record”, the value of the sales volume for which the product has been sold is registered. As the value of the sales amount, for example, it may be expressed by a quantity, or may be displayed by an amount obtained by multiplying the quantity by the unit price of the product.

The record information registered in the record data T2 is not limited to that shown in FIG. 3, for example, other record information may be added, or a part of the record information shown in FIG. 3 is omitted. May be.
In addition, the field which product master T1 and performance data T2 comprise can be used for the item which XY axis item selection means 11 selects as a horizontal axis or a vertical axis of a scatter diagram. For example, “procurement lead time”, “rank” of the product master T1 or “inventory performance” and “sales performance” of the performance data T2 can be items on the horizontal axis or the vertical axis of the scatter diagram.

  Further, a parameter that can be calculated from one item of the product master T1 or the result data T2 can also be an item selected by the XY axis item selection unit 11. For example, when the sales standard deviation of a product is obtained by statistically processing the value of “sales performance” of the performance data T2, the sales standard deviation can be set on the horizontal axis or vertical axis of the scatter diagram.

  FIG. 4 is a diagram showing specific examples of production results, sales results, and inventory results. As shown in FIG. 4A, the sales date and sales volume of a certain product are stored in the performance data T2 (see FIG. 1). As shown in FIG.4 (c), the stock quantity of a certain product is memorize | stored in performance data T2 (refer FIG. 1) with a confirmation date.

  FIG. 5 is a diagram illustrating a display example of a scatter diagram. As shown in FIG. 5, the display unit of the inventory management apparatus 1 displays a dialog d1 as a screen for inventory management. On the right side of the dialog d1, a scatter diagram display area S is arranged. In the scatter diagram display area S, a scatter diagram generated by the scatter diagram generation means 12 is displayed. 5 are plotted according to the values of the product master T1 and the actual data T2 shown in FIG. 2, for example.

  On the left side of the dialog d1, a pull-down menu b1, a pull-down menu b2, a comment button b3, and an extraction button b4 are arranged.

  The pull-down menu b1 is an input interface for selecting an X-axis item of the scatter diagram, and an XY-axis item selection means 11 is embodied. Items selected by the user operating the pull-down menu b1 constitute the X axis of the scatter diagram. In FIG. 5, when the item “total sales performance” that is the total sales performance in a certain period is selected, the X axis of the scatter diagram of the dialog d1 becomes the coordinate axis of “total sales performance”.

  The pull-down menu b2 is an input interface for selecting a Y-axis item of the scatter diagram, and XY-axis item selection means 11 is embodied. Items selected by the user by operating the pull-down menu b2 constitute the Y axis of the scatter diagram. In FIG. 5, when the item “average inventory record” that is the average value of the inventory quantity in a certain period is selected, the Y axis of the scatter diagram of the dialog d1 becomes the coordinate axis of “average inventory record”.

  The comment button b3 is an input interface for inputting a predetermined comment to the product corresponding to the point on the scatter diagram designated by the input unit of the inventory management apparatus 1. Details of comment input will be described later.

  The extraction button b4 is a product corresponding to a point included in a part of the region of the scatter diagram (a point on the boundary of the region may or may not be included, but is included in the present embodiment). It is an input interface for extracting, and the item extracting means 13 is embodied.

  In the scatter diagram of the dialog d1, a “regression line” having a predetermined angle on the coordinate axis and a rectangular “selection area” that is separated from the regression line by a distance of 0 or more are set and plotted with the set regression line and selection area. A scatter plot is displayed. The regression line and the selection area are set according to the function of the scatter diagram generation means 12.

Hereinafter, a method related to area selection on the scatter diagram of the inventory management apparatus 1 configured as described above will be described.
When selecting an object by specifying a range on the screen of a PC or smart device, the object is often selected with a rectangle parallel to the screen area. However, in a specific field, it may be necessary to select a rectangular rectangle with respect to the screen area. For example, in the analysis of a scatter diagram, when it is desired to select a plot that deviates from the regression line of the cluster by a certain distance or more, the selection of an oblique rectangle with respect to the coordinate axis is effective.

FIG. 6 is a diagram for explaining region selection on the scatter diagram of the inventory management apparatus 1. The selection of the area on the scatter diagram depends on the function of the scatter diagram generation means 12.
<Basic concept>
First, as shown in STEP 1 of FIG. 6A, the start point (A) 101 is determined in the scatter diagram display region S (see FIG. 5). For example, when “total sales performance” is taken on the X-axis of the scatter diagram and “average inventory performance” is taken on the Y-axis, the numerical values of “total sales performance” and “average inventory performance” are the smallest (0. Alternatively, the lower left position of the scatter diagram display area S is the starting point.

  Next, as shown in STEP 2 of FIG. 6B, an intermediate point (B) 102 is determined in the scatter diagram display region S (see FIG. 5). For example, in the above case, the position is the upper right position of the scatter diagram display area S where the numerical values of “total sales performance” and “average inventory performance” are the largest. The start point (A) 101 to the intermediate point (B) 102 are connected by a straight base line 110 (regression line). This baseline 110 becomes the long side of the rectangle (the length of the long side of the rectangular selection region 120) 111, which is the rectangular selection region 120 (FIG. 7) of the scatter diagram.

Next, as shown in STEP 3 of FIG. 6C, the end point (C) 103 is determined at an arbitrary position separated from the baseline 110 in the scatter diagram display region S (see FIG. 5). The length of the perpendicular line hanging from the end point (C) 103 to the base line 110 becomes the width 112 of the rectangular selection area 120. In the case of FIG. 6, the base line 110 and a straight line spaced apart from the base line 110 and parallel to the base line 110 including the end point (C) 103 form a rectangular long side 111, and the ends of the long side 111 are perpendicular to each other. The two straight lines connected to each other form a rectangular short side (width) 112, and a rectangle surrounded by the sides 111 and 112 forms a selection area (see the shaded area in FIG. 6C). In the present embodiment, a scatter diagram is effectively included in the rectangular selection area 120.
In this way, in the area selection on the scatter diagram of the inventory management apparatus 1 according to the present embodiment, as shown in FIG. 6, the “border line” to be classified is specified by first setting the baseline 110. Next, by setting the height of the end point (C) 103, the “range” to be classified is clearly indicated.

  As described above, the user can easily understand each operation purpose by the two-stage setting method. This selection method is easy for the user to specify when selecting a rectangular selection region oblique to the horizontal direction of the screen.

In the case of an operation in the case of a PC, for example, the following operation is performed.
Determination of start point: mouse down Determination of intermediate point: mouse up Determination of end point: click In the case of a tablet, for example, the following operation is performed.
Determining the start point: Touch Determining the intermediate point: Release your finger Determining the end point: Tap

<Effectiveness>
FIG. 7 is a diagram for explaining the effectiveness of area selection on the scatter diagram of the inventory management apparatus 1.
When selecting an object by specifying a range on the screen of a PC or smart device, the object is often selected with a rectangle parallel to the screen area. However, in a specific field, it may be necessary to select a rectangular area oblique to the screen area. In the case of FIG. 7, when “total sales performance” is taken on the X axis of the scatter diagram and “average inventory performance” is taken on the Y axis, the lower area of the diagonal baseline (regression line) 110 is the product. Indicates that the product is out of stock, and the upper region of the diagonal baseline (regression line) 110 indicates that the product is overstocked.

  The present inventor has found that in the analysis of a scatter diagram, when a plot that deviates from a regression line of a cluster by a certain distance (including distance: 0) or more is selected, diagonal rectangle selection is effective for the screen area. It was. In addition, as shown in FIG. 7, the scatter diagram generation means 12 takes a baseline (regression line) 110 obliquely with respect to the screen area, and displays a plot area away from the baseline (regression line) 110 by a certain distance or more. A rectangular selection area 120 is assumed. For example, in a scatter diagram in which items are plotted with sales and inventory as the coordinate axes, a plot far above the regression line of the cluster can determine that the inventory is excessive.

<Auxiliary function>
FIG. 8 is a diagram for explaining an auxiliary function for selecting an area on the scatter diagram of the inventory management apparatus 1.
FIG. 8 shows an example of the display of the scatter diagram display area S on the right side of the dialog d1 of the screen for inventory management on the display unit of the inventory management apparatus 1 shown in FIG. As shown in FIG. 8, the “item list” 201 in the selection range is displayed on the upper right side of the scatter diagram display area S in the dialog d1, and the “number of items” in the selection range is displayed on the lower right side of the scatter diagram display area S. "202" is displayed. The “item list” 201 is, for example, a name, an importance level, a sales result total, and an average inventory result for each SKU code. The “number of items” 202 is the number of items, the correlation coefficient, the total sales record, and the average inventory record for each of the whole and the selection range.

In order to assist the accurate selection operation, the item extraction means 13 (see FIG. 1) performs the following extraction during the end point determination of the selection operation STEP3 in FIG. Do. That is, the item extraction unit 13 (see FIG. 1) selects the rectangular selection region 120 including a part of the points plotted in the scatter diagram generated by the scatter diagram generation unit 12, so that the rectangular selection region 120 is selected. Extract the corresponding item. Specifically, the item list 201 in the selection range is updated during the selection operation during the end point determination indicated by the symbol a in FIG. 8 (see the symbol b in FIG. 8). In addition, the number of items in the selection range is updated during the selection operation (see symbol c in FIG. 8). Thereby, as shown in FIG. 8, the “item list” 201 and the “number of items” 202 in the selection range are displayed in real time on the scatter diagram display area S and on the upper and lower sides of the scatter diagram display region S. When it is desired to reduce the number of selected items to a certain number, there is an effect that the selection range can be determined while looking at the number of selected items.
Here, the scatter diagram generation means 12 may change (redraw) the rectangular selection area 120 by selecting the item list 201 or changing the number of items 202. In this way, it is possible to display the rectangular selection area 120, which is a more optimal classification range, according to the selection of the item list 201 or the change in the number of items 202.

<Reference line calculation>
FIG. 9 is a diagram for explaining calculation of a reference line for selecting an area on a scatter diagram of the inventory management apparatus 1.
FIG. 9 shows an example of the display of the scatter diagram display area S in the right part of the dialog d1 of the screen for inventory management on the display unit of the inventory management apparatus 1 shown in FIG. As shown in FIG. 9, a dialog box 203 for guiding the reference line calculation is displayed in the upper part of the scatter diagram display area S of the dialog d1.

Here, the reference line is a straight line that serves as a reference line for selecting a scatter diagram. The reference line is expressed by the equation y = ax + b. By setting the parameters a and b on the inventory management screen in the display unit of the inventory management apparatus 1 shown in FIG. 5, an arbitrary straight line can be displayed on the scatter diagram. For example, when displaying a 45 degree line (x = y), 1 is set to a and 0 is set to b. FIG. 9 shows an example in which a straight line y = x is displayed.
The reference line in FIG. 9 is valid in the following cases, for example. As shown in FIG. 9, a scatter plot is displayed with the sales total on the horizontal axis and the average inventory on the vertical axis. However, it is assumed that a certain company does not know the proper balance between sales and inventory, or does not have a target inventory turnover rate. At this time, the regression line shown in FIG. 9 can be used as the reference line. By using a regression line as a reference line, it is possible to assist in classifying items that are in excess inventory, out of stock (ie, relatively unbalanced), or in good stock.
Further, when the scatter diagram generation means 12 (see FIG. 1) presses the regression line button 204, the regression line formula is calculated from the cluster of the scatter diagram by the least square method, and the slope and intercept are respectively displayed in the columns a and b. Set automatically. In addition, when “Make parallel to the reference line” shown in FIG. 9 is checked, the line from the start point to the intermediate point is adjusted to be parallel to the reference line.

[Concrete example]
<Analysis example 1>
FIG. 10 is a diagram showing a scatter diagram in Analysis Example 1. The scatter diagram is displayed with the total sales performance on the horizontal axis and the average inventory on the vertical axis.
Referring to the scatter diagram in Analysis Example 1 as indicated by reference symbol a in FIG. 10, the item above the 45-degree line is “inventory> sales” and is classified as an “excess inventory” item. As shown in FIG. 10, the scatter diagram generation means 12 takes a baseline (regression line) 110 obliquely with respect to the screen area, and selects a rectangular area of the plot that is away from the baseline (regression line) 110 by a certain distance or more. Region 120 is assumed. The user can determine that the item group is subject to inventory reduction by production adjustment or inventory destruction.

<Example 2 of analysis>
FIG. 11 is a diagram illustrating a scatter diagram in Analysis Example 2. The scatter diagram is displayed with the total sales performance on the horizontal axis and the average inventory on the vertical axis.
It is empirically known that when taking measures against excess inventory, it is possible to reduce inventory more efficiently by preferentially dealing with those with large business scale (sales).
Referring to the scatter diagram in Analysis Example 2 as shown by reference symbol a in FIG. 11, the “upper right region” where sales and inventory are high is selected, not the entire upper side of the 45-degree line. As shown in FIG. 11, the scatter diagram generation means 12 takes a baseline (regression line) 110 obliquely with respect to the screen area, and selects a rectangular area of the plot that is away from the baseline (regression line) 110 by a certain distance or more. The area 120 and the rectangular selection area 120 are set centering on the “upper right area” where sales and inventory are high. As a result, the user can select only items having a certain business scale. In the present embodiment, such a limited region can also be selected.

<Analysis example 3>
FIG. 12 is a diagram showing a scatter diagram in Analysis Example 3. The scatter diagram is displayed with the total sales performance for one year on the horizontal axis and the average inventory for one year on the vertical axis.
As shown by the symbol a in FIG. 12, a straight line with y = 0.1x is displayed using the reference line function. The scatter diagram generation unit 12 sets a plot area away from the baseline (regression line) 110 by a certain distance as a rectangular selection area 120. Then, referring to the scatter diagram in Analysis Example 3, an item on the straight line y = 0.1x can be considered to have an inventory turnover rate of 10 rotations in the past year. Assuming that the target inventory turnover rate of this company is 10 revolutions, the user can determine that the item above the straight line has not reached the plan (excess inventory) and classify it as the target of inventory reduction, as shown by symbol b in FIG. can do.

<Example 4 of analysis>
FIG. 13 is a diagram illustrating a scatter diagram in Analysis Example 4. The scatter diagram is displayed with the total sales performance on the horizontal axis and the average inventory on the vertical axis.
The company does not know the proper balance between sales and inventory (there is no such thing as target inventory turnover). In such a case, as indicated by reference symbol a in FIG. 13, if the 45-degree line is used as a reference, all stocks are in excess, which is inappropriate as the reference line. Therefore, as shown by reference sign b in FIG. 13, the scatter diagram generation means 12 takes a baseline (regression line) 110 obliquely with respect to the screen area, and is a plot separated from the baseline (regression line) 110 by a certain distance or more. This area is a rectangular selection area 120. As shown by reference symbol c in FIG. 13, relatively unbalanced items (here, items in excess inventory) can be classified.

<Analysis example 5>
FIG. 14 is a diagram illustrating a scatter diagram in Analysis Example 5. The scatter diagram is displayed with the total sales performance on the horizontal axis and the total sales plan on the vertical axis.
Referring to the scatter diagram in Analysis Example 5 as indicated by reference symbol a in FIG. 14, the item above the 45-degree line is “plan> actual”, and is classified as an item “plan not achieved”. The scatter diagram generation means 12 takes a baseline (regression line) 110 obliquely with respect to the screen area, and sets a plot area away from the baseline (regression line) 110 as a rectangular selection area 120. The user can determine that the item group is a target for sales leverage, plan review, or the like.

<Analysis Example 6>
FIG. 15 is a diagram illustrating a scatter diagram in Analysis Example 6. The scatter diagram is displayed with the current stock on the horizontal axis and the safety stock on the vertical axis.
As shown by the symbol a in FIG. 15, referring to the scatter diagram in the analysis example 6, the item above the 45-degree line is classified as an item whose current stock is below the safety stock. The scatter diagram generation means 12 takes a baseline (regression line) 110 obliquely with respect to the screen area, and sets a plot area away from the baseline (regression line) 110 as a rectangular selection area 120. The user can determine that the item group may be out of stock and needs to be restocked immediately.

  In this display example, by setting the area of the plot away from the oblique baseline (regression line) 110 by a certain distance or more as the rectangular selection area 120, the product resulting from the excessive stock in the theoretical safety stock is specified. can do. That is, it can be said that the product included in the rectangular selection area 120 of the scatter diagram is a product for which a relatively large theoretical safety stock value is set in order to avoid the shortage as much as possible for the convenience of inventory management. Thus, the user can carefully monitor the inventory of such products and easily identify that the cause of excess inventory is a high theoretical safety inventory value.

  Here, the products included in the rectangular selection area 120 of the scatter diagram have a large sales standard deviation and a large fluctuation in sales. (When the safety stock count is increased), the product may have an impact that cannot be ignored. Therefore, the user can select such a method as not to lower the service level but to carefully monitor such a product and adopt, for example, an irregular unordered ordering method. The “irregular and non-quantitative ordering method” is a method for determining the ordering timing and the order quantity using prediction, and has an advantage that the management cost is high, but it can be adjusted to a desired stock quantity with high accuracy.

  As described above, in the inventory management apparatus 1 according to the present embodiment, the control unit is on the coordinate axis configured by the first parameter that characterizes the inventory status of the product and the second parameter that characterizes the inventory status of the product. In addition to setting a regression line 110 having a predetermined angle, a rectangular selection area 120 that is separated from the regression line 110 by a distance of 0 or more is set, and the set regression line 110 and the rectangular selection area 120 are plotted and a scatter plot is displayed on the display unit. Execute control to For example, a baseline for classifying the plotted scatter diagram is set as the regression line 110, and a classification range for classifying the plotted scatter diagram is set as the rectangular selection region 120 in a direction deviating from the regression line.

  As a result, when it is necessary to select a rectangle that is diagonal to the screen area (for example, when you want to select a plot that deviates more than a certain distance from the regression line of the cluster in the analysis of a scatter diagram), A rectangular selection area is displayed, a product having a problem in inventory management can be identified, and a method for solving the problem can be determined. Support for those who manage inventory can be strengthened.

  In the present embodiment, the control unit executes control to display the set item list or the number of items in the selection area in real time on the display unit, thereby reducing the number of selected items to a certain number. There is an effect that the selection range can be determined while looking at the number.

The present invention is not limited to the above-described embodiments, and includes other modifications and application examples without departing from the gist of the present invention described in the claims.
For example, in the present embodiment, an example in which the regression line 110 and the rectangular selection region 120 are set one by one for one coordinate axis has been described, but two or more of each may be set for one coordinate axis.
Further, the shape of the regression line 110 or the rectangular selection area 120 is not limited to that of the present embodiment.

Further, for the convenience of inventory management, the item set in the product master T1 may be the item of the actual data T2, and the item set in the actual data T2 may be the item of the product master T1. Furthermore, you may design one database which combined the product master T1 and the performance data T2.
In addition, features related to inventory management of products corresponding to points included in the rectangular selection area 120 may be highlighted. For example, text such as “stock excess” may be displayed, or the background color or pattern of the rectangle selection area 120 may be different from the background color or pattern of other areas.

  In the present embodiment, components realized by hardware can be realized by software, and components realized by software can be realized by hardware. Moreover, a new technique can be realized by appropriately combining the technical matters described in the present embodiment. Other specific configurations of hardware, software, database, and the like can be changed as appropriate without departing from the spirit of the present invention.

1 Inventory Management Device 11 XY Axis Item Selection Unit 12 Scatter Chart Generation Unit 13 Item Extraction Unit 110 Baseline (Regression Line)
120 Rectangle selection area 201 Item list 202 Number of items T1 Product master T2 Actual data

Claims (3)

A display unit for displaying a scatter diagram in which points corresponding to each of a plurality of types of products are plotted on a coordinate axis composed of a first parameter characterizing a product stock status and a second parameter characterizing a product stock status; An inventory management device that supports decision making of product inventory management,
The control unit of the inventory management device includes:
A regression line having a predetermined angle on the coordinate axis is set, and a classification range for classifying the plotted scatter diagram in a direction deviating from the regression line is set as the rectangular selection region.
An inventory management apparatus for executing control for displaying the set regression line, the rectangular selection region, and the plotted scatter diagram on the display unit. The controller is
When displaying the scatter chart with the sales total and the average inventory on the coordinate axis, the reference line for classifying the plotted scatter chart is set as the regression line, the state of excess inventory, the possibility of missing items The inventory management apparatus according to claim 1, wherein control is performed to support classification of items that are in a high state or in a state of appropriate stock. The controller is
Execute control to display the set item list or the number of items in the rectangular selection area on the display unit, or
3. The inventory management apparatus according to claim 1, wherein control for changing the rectangular selection area is performed by selecting the item list or changing the number of items.