JP2002244709A - Inventory control system, method and program and recording medium therefor - Google Patents

Abstract

PROBLEM TO BE SOLVED: To quicken a will decision in an inventory control and to improve certainty by providing an inventory control system capable of rationally executing a proper inventory control in any inventory state pattern and controlling method therefor. SOLUTION: This system for controlling inventory quantity of items has an inventory related data storing part for holding data of warehousing, shipping and stocking of the items, a parameter calculating part for calculating parameters of tendencies, periodicity and dispersion specific to the items from the inventory related data, a proper quantity decision rule storing part for holding a proper quantity decision rule for deciding whether an inventory state is proper quantity or not, and an inventory state diagnostic part for generating inventory state pattern information constituted of plural kinds of prescribed codes based on the inventory related data and the parameters and diagnosing the inventory state for every item based on the inventory state pattern and the proper quantity decision rule.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a technique for controlling the stock amount of items such as parts or components, and more particularly to a system, method, and program for controlling stock such as an inventory management system and an ERP system, and the stock amount. The present invention relates to a storage medium that stores a program for implementing a control method.

[0002]

2. Description of the Related Art Conventionally, based on historical data on past inventories and data from marketing research, etc.
There has been proposed a system for controlling a stock quantity of an item such as a part or a component by performing a demand forecast and updating a stock standard such as a safety stock, an order point, and an order quantity as needed.

[0003]

The prior art has provided a system and method for controlling inventory by outputting information for suppressing / promoting storage such as a change in order quantity. However, in such a technique, a stock status pattern (for example, a change in the stock rotation period (= stock amount / outgoing amount)) that is increasing despite the suppression of stocking (for example,
The initial stock quantity is 300 pieces, and the stock quantity at that time is 30 pieces,
Assuming that the incoming volume is reduced to 0 and the outgoing volume is reduced by 5 in the future, the inventory turnover period is 300/30 = 10, (300-30) / 25 = 10.
8, (300-30-25) / 20 = 12.25, (300-30-25-20) / 15 = 15), or inventory that has already been stopped and inventory is deceased For items having status patterns, etc., accurate inventory control information is not provided to the user.

Accordingly, the present invention provides a stock control system and a control method capable of rationally executing appropriate stock control in any stock state pattern, thereby speeding up decision making in stock control and improving accuracy. As an issue.

[0005]

In order to solve the above-mentioned problems, an inventory control system according to the present invention is a system for controlling an inventory amount of an item of a part or a component. An inventory-related data storage unit for holding inventory-related data as data, and parameters of item-specific trends, periodicities, variations, average values, maximum values, minimum values, mode values, and ranges from the inventory-related data. A parameter calculation unit for calculating, an appropriate amount determination rule storage unit for holding a predetermined appropriate amount determination rule for determining whether the stock state is appropriate, and a plurality of types based on the inventory related data and parameters. And generates a stock status pattern information composed of a predetermined code, and diagnoses the stock status of each item based on the stock status pattern and the appropriate amount determination rule. Comprising a stock condition diagnosis unit, an output unit for displaying on the output device a diagnosis result for each said item.

In order to solve the above-mentioned problems, an inventory control system according to the present invention is based on inventory status information of inventory transition, inventory transition, and inventory transition illustrated based on the inventory-related data, and the inventory-related data. A batch drawing processing unit that collectively processes information that can recognize the degree of variation in the procurement lead time shown in the drawing, and an output unit that displays the processing result of each item on an output device. .

In order to solve the above-mentioned problems, an inventory control system according to the present invention comprises: an excess / deficiency amount calculating unit for calculating an excess / deficiency amount of inventory based on the diagnosis result and inventory-related data and parameters; An output unit is provided for displaying the amount of excess or deficiency for each output device.

In order to solve the above-mentioned problems, an inventory control system according to the present invention comprises a method determination rule storage unit for storing a predetermined inventory control method corresponding to the above-mentioned diagnosis result, A control method drafting unit that drafts an inventory control method corresponding to the diagnosis result based on the method determination rule stored in the method determination rule storage unit, and an output unit that displays the planning result of each item on an output device.

In order to solve the above-mentioned problems, an inventory control system according to the present invention comprises: a reference calculation constraint storage unit for storing constraint items which can be set by a user in advance; and a planning result obtained by the control method planning unit. An optimal standard calculation unit for calculating an optimal inventory standard based on conditions set by a user based on the inventory related data and the constraint items held in the standard calculation constraint storage unit; An output unit for displaying a result on an output device is provided.

In order to solve the above-mentioned problem, an inventory control method according to the present invention is a method for controlling an inventory amount of an item of a part or a component, and is data relating to entry / exit / inventory of the item. The inventory-related data is read from the inventory-related data storage unit for holding the inventory-related data, and the item-specific tendency, periodicity, variation, average value, maximum value, minimum value, mode, and range The parameters are calculated by a parameter calculation unit, and the appropriate quantity determination rule is read from an appropriate amount determination rule storage unit that holds a predetermined appropriate amount determination rule for determining whether the stock state is appropriate. Generating inventory status pattern information composed of a plurality of types of predetermined codes based on the parameters; Based on the above, the stock status of each item is diagnosed by the arithmetic processing means, and the diagnosis result of each item is displayed on the output device.

Further, in order to solve the above-mentioned problems, the inventory control method of the present invention provides a method for storing inventory status information of inventory transition, outgoing inventory transition, and incoming inventory illustrated on the basis of the inventory-related data, and the inventory-related data. Based on the information shown on the basis of which the degree of variation in the procurement lead time can be recognized, the information is processed in the form of a batch and the processing result for each item is displayed on the output device.

According to another aspect of the present invention, there is provided an inventory control method, comprising: calculating an excess or deficiency of inventory by an excess or deficiency calculation unit based on the diagnosis result and inventory related data and parameters; The excess or deficiency for each is displayed on the output device.

Further, in order to solve the above-mentioned problem, an inventory control method according to the present invention stores a method determination rule from a method determination rule storage unit which holds a method determination rule which is a relation rule of an inventory control method corresponding to a diagnosis result. An output unit that reads out, makes a control method planning unit a stock control method corresponding to the diagnosis result based on the diagnosis result and the method determination rule, and displays the planning result for each item on an output device.

In order to solve the above-mentioned problem, a stock control method according to the present invention reads out a constraint item from a reference calculation constraint storage unit which previously stores constraint items which can be set by a user, and executes the control method planning unit. Based on the planning result obtained by the above, the stock-related data, and the conditions set by the user, based on the conditions set by the user, the optimum stock criterion is calculated by the optimum criterion calculation unit, and the optimum criterion result for each item is output to the output device. To be displayed.

[0015] In order to achieve the above object, an inventory control program according to the present invention is an inventory control program for controlling an inventory amount of a part or component item.
Reading inventory-related data, which is data relating to entry / exit / inventory of the item, from the storage means, and from the inventory-related data, an item-specific tendency, periodicity, variation,
Calculating the average, maximum, minimum, mode, and range parameters by means of the processing means, and determining the appropriate amount based on a predetermined appropriate amount determination rule for determining whether the stock status is appropriate; Reading from the rule storage unit;
Diagnosis of inventory status of each item by generating inventory status pattern information composed of a plurality of types of predetermined codes based on the inventory related data and the parameters, and applying the inventory status pattern to an appropriate amount determination rule. And displaying the diagnostic result for each item on an output device.

[0016]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described below by taking inventory control of maintenance parts in an elevator as an example. A. 1. System Configuration (1) Hardware Configuration As shown in FIG. 1, an inventory control system 0100 of this embodiment includes an input device 0101, an output device 0102, a processing device 0103,
This is an information processing system including an auxiliary storage device 0104.

The input device 0101 is a device for receiving an input such as a keyword for extracting information or the like stored in the control information storage unit 0224, and includes a keyboard and a mouse.

The output device 0102 is a device for outputting a diagnosis result of the stock status of each maintenance part and the like, and has a display screen.

The processing device 0103 has an interface 01031
, A central processing unit (CPU) 01032, and a main storage device 0
1033. The processing device 0103 has an interface 0103
It is connected to these input device 0101 and output device 0102 via 1. The CPU 01032 is an auxiliary storage device 0104
It is connected to the. (2) Functional configuration As shown in FIG.
0201, batch drawing processing unit 0202, and stock status diagnosis unit 0203
An excess / deficiency amount calculation unit 0204, a control method planning unit 0205, an optimal standard calculation unit 0206, an inventory standard update unit 0209, an exchange count calculation unit 0216, an optimal exchange calculation unit 0207, and an assumed data creation unit 0208. , An assumed data update unit 0213 and an information disclosure determination unit 02
10, a control information search unit 0211, a control information update unit 0215,
It has an output unit 0212, an input unit 0214, and a processing result storage unit 0217.

The parameter calculation unit 0201 calculates parameters such as the tendency, periodicity, and variation unique to the maintenance part from the data stored in the stock-related data storage unit 0218.

The batch diagram processing unit 0202 processes the data stored in the stock-related data storage unit 0218 in a form in which the transition of stock, the transition of stock, the transition of stock, and the degree of variation in the procurement lead time are summarized.

The inventory status diagnosis unit 0203 determines the maintenance amount of each maintenance component from the data held in the inventory related data storage unit 0218, the parameters obtained by the parameter calculation unit 0201, and the appropriate amount determination rule stored in the appropriate amount determination rule storage unit 0219. Diagnose inventory status.

The excess / deficiency amount calculation unit 0204 calculates the excess / deficiency amount of the inventory from the data held in the inventory-related data storage unit 0218, the parameters obtained by the parameter calculation unit 0201, and the diagnosis results obtained by the inventory state diagnosis unit 0203. calculate.

The control method planning unit 0205 includes an inventory state diagnosis unit 02
Based on the diagnosis result obtained in step 03 and the method determination rule stored in the method determination rule storage unit 0220, an appropriate inventory control method is drafted.

The optimum criterion calculation unit 0206 is a control method planning unit 02
05 Planning result and inventory related data storage unit 0218
An optimal solution such as an order size and an order cycle is obtained by simulation from the conditions held by the user based on the data held in the storage unit and the constraint items held in the reference calculation constraint storage unit 0221.

The stock standard updating unit 0209 registers / updates the stock standard with the solution obtained by the optimum standard calculating unit 0206 based on the instruction from the user.

The number-of-times-of-replacement calculation unit 0216 includes an operation data storage unit
The number of replacements is calculated from the data stored in the storage unit 0226 and the life data storage unit 0226 and the conditions set by the user.

The optimum replacement calculation unit 0207 includes a replacement number calculation unit 02
Based on the number of exchanges obtained in step 16 and the constraints set by the user based on the constraint items held in the exchange calculation constraint storage unit 0222, an optimal solution on the exchange day is obtained by simulation.

The assumed data creation unit 0208 is an optimal exchange calculation unit
[0207] The optimal exchange date obtained by the above-mentioned 0207 and the assumed data constraint table 03 in the inventory related data storage unit 0218 described later.
Based on the information in 06, the outgoing quantity, order quantity, incoming quantity, and stock quantity are calculated.

The assumed data updating unit 0213 registers / updates the data relating to entry / exit / inventory / stock of the item generated by the assumed data creating unit 0208 in the stock-related data storage unit 0218 based on the user's instruction.

The information disclosure determining unit 0210 receives an input of a search condition via the input device 0101, and permits disclosure of control information based on the input information and the disclosure determination rule stored in the disclosure determination rule storage unit 0223. It is determined whether or not.

The control information search unit 0211 searches for information stored in the control information storage unit 0224 based on search conditions input by the user.

The control information update unit 0215 registers / updates part or all of the inventory control information displayed on the output unit 0212 in the control information storage unit 0224 based on an instruction from the user.

The output unit 0212 displays, on the output device 0102, inventory control information processed by each unit.

The input unit 0214 accepts a user's instruction such as a keyword for extracting information stored in the control information storage unit 0224.

The processing result storage unit 0217 temporarily stores the processing results of each unit.

In this embodiment, the processing result storage unit 0217
Is a storage area secured in the main storage device 01033. Each of the units 0201 to 0216 constituting the processing unit is provided with an auxiliary storage device 0104.
The program is realized by the CPU 01032 executing a program stored in advance in the main storage device 01033. However, the present invention is not limited to such an implementation method using a general-purpose information processing device and software. For example, it may be realized by hardware including hard-wired logic that performs processing of each unit described below, or by such hardware and a general-purpose information processing device programmed in advance.

The auxiliary storage device 0104, as shown in FIG.
Inventory related data storage unit 0218 and appropriate amount determination rule storage unit 0219
And a method determination rule storage unit 0220 and a reference calculation constraint storage unit 02
21, exchange calculation constraint storage unit 0222, and open judgment rule storage unit
0223, a control information storage unit 0224, and an operation data storage unit 022
5, a life data storage unit 0226.

The stock-related data storage unit 0218 stores information relating to the amount of incoming / outgoing / inventory and the date and time such as the incoming amount and the incoming / outgoing date, and information indicating the management status of the maintenance parts such as the part number, order size and safety stock, and the stock reference. This is a storage area for holding.

The appropriate-quantity determination rule storage unit 0219 is a storage area that holds in advance an appropriate-quantity determination rule for determining whether the stock status is an appropriate amount.

The method determination rule storage unit 0220 is a storage area for preliminarily storing a method determination rule for determining a control method corresponding to the diagnosis result obtained by the stock status diagnosis unit 0203.

The reference calculation constraint storage unit 0221 is a storage area for holding in advance constraint items and the like that can be changed by the user in order to obtain an optimal stock reference.

The exchange calculation constraint storage unit 0222 is a storage area for preliminarily holding constraint items that can be changed by the user in order to obtain an optimum exchange date.

The disclosure determination rule storage unit 0223 stores the diagnosis result obtained by the stock status diagnosis unit 0203 and the excess / deficiency amount calculation unit 0204.
Storage control information such as excess or deficiency of inventory obtained by the above is stored in a storage area for holding rules for determining whether to permit disclosure to second parties such as business partners and customers and third parties. is there.

The control information storage unit 0224 stores the stock status diagnostic unit 02
This is a storage area for holding inventory control information such as the amount of excess or deficiency of inventory obtained by the excess or deficiency amount calculation unit 0204 as a result of the diagnosis obtained by 03.

The operation data storage unit 0225 stores the operation information of the main body of the elevator and the maintenance parts for constructing the elevator, such as the number of times of operation (such as the number of times of opening and closing) and the operation time (such as the running time), and the number of operation of the elevator. This is a storage area for holding information on an installation site where the main body is actually operating.

The life data storage unit 0226 is a storage area for holding information on the life of the elevator body and the maintenance parts. B. FIG. 3 shows a table structure of the stock-related data storage unit 0218 in the auxiliary storage device. As shown in FIG. 3, the inventory-related data storage unit 0218 stores an incoming / outgoing history table 0301, an ordering history table 0302, a parts management master table 0303, and an incoming / outgoing assumption table 0304.
And order assumption table 0305 and assumption data constraint table 0306
Is provided.

The entry / exit history table 0301 and the entry / exit assumption table 0304 include columns such as a part number column 0301, an entry / exit judgment flag column 30012, a date / time column 03013, and an amount column 30014. The part number column 03011 holds number information for specifying the part. The entry / exit determination flag column 30012 holds information for distinguishing entry and exit. The date and time column 03013 holds date and time information such as the entry and exit date and the exit date and time. The quantity column 03014 holds information indicating the incoming and outgoing quantities processed / will be processed at the date and time of the date and time column 030013. The order history table 0302 and the order assumption table 0305 include an order date / time column 0321, an order quantity column 03022,
It has columns such as a warehousing date column 03023. Parts management master table 0303 and assumed data constraint table 0306
Has columns such as an order size column 03031, a safety stock column 03032, a supplier column 03033, and an order method column 03034.

The entry / exit history table 0301 and the order history table 0302 hold data (history data) such as an incoming quantity, an outgoing quantity, and an inventories actually generated from the past to the present. On the other hand, the entry / exit assumption table 03
04 and the order assumption table 0305 include an assumption data creation section
Data (estimated data) such as the incoming amount, the outgoing amount, and the inventories generated by 0208 are held. The part management master table 0303 holds information indicating the management state of maintenance parts such as the part number currently used, the order size, and safety stock, and the stock standard. On the other hand, the assumed data constraint table 0306 holds constraints assumed by the user and used in the calculation of the assumed data creation unit 0208.

It is not necessary that the entry / exit history table 0301 and the entry / exit assumption table 0304 have the same table configuration. Similarly, order history table 0302 and order assumption table
Table configuration of 0305 and parts management master table 03
It is not necessary that the table configuration of 03 and the assumed data constraint table 0306 be the same.

FIG. 4 shows the table structure of the appropriate amount determination rule storage unit 0219. The appropriate amount determination rule storage unit 0219 includes an appropriate amount determination rule table 0401 as shown in FIG. The appropriate amount determination rule table 0401 includes columns such as an appropriate amount determination pattern column 04011 and a determination content column 40012. The numerical sequence divided every two digits in the lower diagram of FIG. 4 is information indicating an appropriate amount determination pattern, and is associated with the determination content according to the pattern. Although not shown, in order to determine the appropriate amount of inventory at the present time, a future time, or a certain period in the future, data relating to “tense” can be added. The appropriate amount can be determined. The appropriate amount determination is represented by numerical information (in FIG. 18, two-digit numerical information) generated by analysis from a plurality of viewpoints (part characteristics, outgoing tendency, inventory tendency, etc.) shown in FIG. However, there is no necessity of two digits or a numerical value), and the matching search with the determination pattern is performed. The meaning of “00”, “01”, “02”, etc. will be described later.

FIG. 5 shows the table structure of the method determination rule storage unit 0220. The method determination rule storage unit 0220 includes a method determination rule table 0501 as shown in FIG. The method determination rule table 0501 includes columns such as a method determination pattern column 0501 and an inventory control method column 50012. The numerical sequence divided every two digits in the lower diagram of FIG. 5 is information indicating a method determination pattern, and is associated with an inventory control method (qualitative method) to be dealt with in the case of the pattern. Although not shown, if data on “tense” is also added, it is possible to make a determination from the viewpoint of the user. Note that the method determination process can be performed in the same manner as the above-described pattern matching method.

FIG. 6 shows the table structure of the reference calculation constraint storage unit 0221. The reference calculation constraint storage unit 0221 includes a reference calculation constraint table 0601 as shown in FIG. The reference calculation constraint table 0601 includes columns such as a reference calculation constraint item column 0601 and a reference calculation setting condition column 60012.

FIG. 7 shows the table structure of the exchange calculation constraint storage unit 0222. The exchange calculation constraint storage unit 0222 includes an exchange calculation constraint table 0701 as shown in FIG. The exchange calculation constraint table 0701 includes columns such as an exchange calculation constraint item column 07011 and an exchange calculation setting condition column 70012.

FIG. 8 shows the table structure of the disclosure determination rule storage unit 0223. The disclosure determination rule storage unit 0223 includes a disclosure determination rule table 0801 as shown in FIG. The disclosure determination rule table 0801 includes columns such as an inventory control method column 08011, an inventory status diagnosis result column 08012, and a collective diagram processing result column 08013. Stock status diagnosis result column 08012,
In columns related to inventory control information, such as the collective diagram processing result column 08013, information on the permitted range of publication, such as permission to release to other departments in the company, permission to release to suppliers, and disclosure of only the material department, is held.

FIG. 9 shows the table structure of the operation data storage unit 0225. The operation data storage unit 0225 includes an operation information table 0901 and an installation information table 0902, as shown in FIG. The operation information table 0901 stores the operation information of the elevator main body and the maintenance parts for configuring the elevator, such as the number of operations (the number of times of opening and closing) and the operation time (such as the running time), for each individual (item (For each name). The installation information table 0902 holds information on the installation site where the elevator body is actually operating, such as the use environment and the operation start date. Here, the item A shown in FIG. 9 is an individual of an elevator, and means one item of a standard model of an elevator called item 1. Item 11,
Reference numeral 12 denotes a component item constituting the item 1, and items 111 and 112 have a relationship of component items constituting the item 11. The operation information is appropriately collected by a system that monitors the usage status of each item, and is stored in the operation data storage unit 0225.

The table structure of the life data storage unit 0226 is shown.
See Figure 10. The life data storage unit 0226 has a life master information table 1001 as shown in FIG. The life master information table 1001 holds information such as an item number, a measurement unit, and a life value according to a use environment. C. Processing Flow Next, the processing flow in the processing device 0103 of the present invention will be described with reference to FIGS.

When the processing unit 0103 is started, first, the instructions (part number, data type,
It is determined whether the tense, the password, etc.) are new calculation execution instructions or search execution instructions for already stored inventory control information (step 1101). If the instruction is an execution instruction, the reading of inventory-related data is started next (step 110).
2).

After the reading of the inventory-related data is completed, a process of calculating parameters such as the tendency, periodicity, and maximum and minimum values of the procurement lead time of the read parts by statistical analysis such as regression analysis is started, and the result is calculated. Main storage device 01033
(Step 1103).

Subsequently, a batch drawing process of the inventory-related data read earlier is executed (step 1104), and the result is displayed on the output device 0102 (step 1105). FIG.
This is an example of the batch display, with part number “1234567”
, A change in storage, a change in storage, and a change in inventory during a predetermined period are shown in one time series.

When the parameter calculation processing is completed, reading of the appropriate amount determination rule described with reference to FIG. 4 is started (step 1106). After reading is completed, the item (here,
The process of diagnosing the stock status of the part number "1234567" or "7654321" (described below) is started (the process of patterning (symbolizing) the stock status of items and the process of collating with the appropriate quantity determination rule). (Step 1107) The result is stored in the main storage device 01033 and displayed on the output device 0102 (Step 1105). In the stock state diagnosis step 1107, a plurality of state analysis processes such as “parts characteristics”, “shipping tendency”, and “stock tendency” as shown in FIG. This is applied to the judgment formula shown in (1) to specify the stock status. As a result, in each state analysis process, two-digit numerical information shown in the item code of FIG. 19 is generated, and by combining these, numerical information of an “inventory state pattern” as shown in FIG. 18 is generated. FIG. 12 shows a state in which state analysis is performed sequentially and two-digit numerical information (00, 01, 02, etc.) is generated by the above-described determination formula. In the present embodiment, a detailed description will be given on the assumption that a “stock state pattern i1801” or “stock state pattern j1802” (see FIG. 18) is generated. At the stock status diagnosis step 1107,
Using the appropriate amount determination rule (FIG. 4) read in step 1106, pattern matching is performed with the stock status pattern.

When the user uses the system according to the present embodiment, (1) the stock status of the current item (part) (2) the stock status of the future item (part) (3) a predetermined period from the present to the future (4) The inventory status of items (parts) in a certain period in the future can be estimated on a tense basis. In FIG. 3 shows a display screen.

The upper diagram of FIG. 13 shows a case where the inventory diagnosis tense is “current”, and two places indicated by a thick frame of the inventory status pattern i are as follows.
Since it matches pattern No. 4 in the appropriate amount determination rule table (FIG. 4), a diagnosis of “excess inventory” is made. Also,
The middle diagram of FIG. 13 shows the case where the inventory diagnosis tense is “future”, and the two locations indicated by the thick frame of the inventory status pattern i match the pattern No. 1 of the appropriate quantity determination rule table (FIG. 4).
A qualitative diagnosis is made that “the possibility of excess inventory is high”.
The lower part of FIG. 13 shows the results of the inventory status diagnosis during the “predetermined period from now to the future”. The four locations indicated by the thick frames of the inventory status pattern i are the pattern No. q in the appropriate quantity determination rule table (FIG. 4). "Continuing excess inventory" to match
Qualitative diagnosis is output.

At the present time, the user can refer to the result of the stock status diagnosis in deciding the action to be taken. Here, it is possible to display not only the current state but also the estimation at a future point in time or a predetermined period in the future.

Although the table of FIG. 4 displays patterns for all tense, a table or database classified for each tense can be used. Subsequently, when the diagnosis result is excess or shortage, the process of calculating the excess or deficiency starts (step 1108), and the result is output to the output device.
It is displayed on the screen 0102 (step 1105). The stock status diagnosis step described above outputs a qualitative status, and in the present embodiment, a quantitative output is also possible. An example of the output is shown in FIG. FIG. 15 shows the excess stock (100 pieces) in the tense (current) shown in the upper diagram of FIG. To calculate the excess inventory, use the “history data”
(Data of the stock-related data storage unit in FIG. 3).

Subsequently, when the result of the diagnosis is an excess or shortage of inventory, reading of a method determination rule shown in FIG. 5 is started (step 1109). After reading is completed, main storage device 0103
Processing for detecting the inventory control method corresponding to the diagnosis result held in 3 starts, and the result is held in the main storage device 01033 (step 1110) and displayed on the output device 0102 (step 1105). Here, the “method determination” refers to the inventory control method of what action or countermeasure should be taken at the present time using the “inventory status pattern” indicating the inventory status of a certain item in the method determination rule table 1501. Means to search and extract from Specifically, step 11
In step 10, using the inventory state pattern (i or j) calculated earlier, the matching is performed with the judgment pattern stored in the method judgment rule table, and the matched pattern is extracted. Here, too, it is possible to estimate the control method determination according to the tense.
An example is shown in FIG. The item (4) in FIG. 16 shows the inventory control method, and the qualitative inventory control method is output and displayed to the user. Note that the inventory control method here is based on only the “history data” up to the present, and is different from the method using “assumed data” described later. Subsequently, a reference calculation constraint table is read (step 1111), an input of a constraint condition is received via the input device 0101, and a process of calculating an optimum reference is executed based on the input information (step 1112). The result is displayed on the output device 0102 (step 1105). The reference calculation constraint table shown in FIG. 6 is read from the reference calculation constraint storage unit 0221 of the auxiliary storage device. Here, based on the parts management master data 0303, for an item (part number 7654321), the order size is currently 500 pieces, and
A case where the tense is “present” and it is diagnosed as “excess inventory” will be described. First, the user sets constraint conditions based on the constraint items held in the reference calculation constraint storage unit 0221. If the component management master registration value x α (α = 0.8) is set as the “initial value of order size” in the item settings, the current component management master registration value is 500, so the initial value is It becomes 400. On the basis of this initial value, the system performs a process of diagnosing the "current" stock status again. Here, an “inventory status pattern j” is generated (see FIG. 18), and it is diagnosed as “excess inventory” by the inventory status diagnosis described above. Subsequently, if the constraint item “-10 as the change amount β of the change of the order size” is selected, the simulation is repeated by decreasing the order by −10, and when the order size reaches 100, “Inventory” "Appropriate amount" and the process ends. FIG. 20 shows the result in this case. The user can receive support for a quantitative control method in addition to the qualitative control method in the inventory control planning step 1110. Note that this reference calculation constraint table is a default value, and can be appropriately changed by the user. That is, the ordering method and the procurement lead time can be changed. For example, the ordering method can be changed from the ordering point method to the regular ordering method, and the procurement lead time can be changed from the maximum value in the past year to an average value. Next, reading of operation data (step 1113) and reading of life data (step 1114) are started. After the reading is completed, the exchange count calculation process is executed (step 1115), and the result (Fig.
23) in the main storage device 01033 and the output device 0 together with the main device.
Displayed at 102 (step 1105). Subsequently, the exchange calculation constraint items are read (step 1116), the input of the constraint conditions is received via the input device 0101, and the process of calculating the optimal exchange date based on the input information is executed (step 1116).
1117, Figure 24). The result (FIG. 25) is held in the main storage device 01033 and displayed on the output device 0102 (step 1105). Specifically, a method of calculating a replacement date of the item 11 as a component of the item 1 during the life of the item 1 will be described (see FIG. 22). The user gives an instruction to start calculation of the exchange date of “item number: 11”, and in response thereto, the system side reads items A, B... Search and extract from storage (step 111)
3). Here, taking item A as an example, from the installation information table shown in FIG. 9, “use started from December 25, 1997, and under the use environment of rank B, as of September 20, 2000, Item 11 has been used for 6,000 hours. " This operation data and life data (Fig. 10)
The number of times of replacement is calculated by the number-of-times-of-replacement calculation unit 0216 by using (step 1115). The calculation process is performed for each item by the number-of-times-of-replacement calculation unit 0216 shown in FIG. In item A, item 11 is scheduled to be exchanged a total of seven times every 7,000 hours, and each exchange date is output as shown in FIG. Here, the life of the item A itself becomes 1,800 hours after the last seventh replacement, and the last item 11 is discarded while being still usable. The above is the case where the number of exchanges and the exchange date are calculated using the maximum value of the use period according to the use state of the item and the like. In this case, the following problem may occur. That is, item 1
However, if the sales (installation) results from the sales start date (or installation start date) have the probability density distribution shown in Fig. 24, simply setting the replacement date in 7,000 hours as described above will be required after that The exchange of item 11 temporarily increases as in event 1, and in some cases, the exchange processing capacity of the manufacturer or exchange company that produces item 11 (100 in FIG. 24 per day).
), The replacement time may be delayed. Further, if the replacement date is simply determined, as shown in FIG. 22, the last item 11 is discarded after 1,800 hours of use, and there is a problem that the effective resources are wasted.

In the present embodiment, the number of exchanges and the date of exchange are set by dispersing the exchange times of the items 11 in order to reduce the above problem by using the exchange calculation constraint table shown in FIG. FIG. 25 shows one of the dispersed results (event m). According to this method, the number of exchange occurrences can be limited to a constant value, and the loss of effective resources occurring in the item 11 can be reduced. Subsequently, a process of calculating assumed data based on the optimal replacement date is executed (step 1118). The result (Figure
26 event m) is displayed on the output device 0102 (step 1105). Further, in the present embodiment, as shown in FIG. 11, upon receiving the output of step 1118, processing such as appropriate amount determination starting from step 1103 can be performed. In the above-mentioned processing such as appropriate amount determination, predetermined parameters were generated using “history data” from the past to the present, and appropriate amount determination and control methods were planned. "Assumed data" obtained from life data, the number of replacements, etc., for the present and future are used (see FIG. 26). Therefore, regardless of the tense of the inventory prediction, it is possible to perform the inventory prediction with higher accuracy than the prediction using only the “history data”. Here, since there may be a plurality of events as shown in FIG. 26 depending on the method of dispersing the exchange days, a plurality of “assumed data” can be considered. In the present embodiment,
The calculation process from step 1103 can be performed based on at least one event determined by the user or at least one event determined by the system. The lower part of FIG. 27 is an example in which a predetermined parameter is calculated based on the event m and the inventory diagnosis is performed. In the upper diagram of FIG. 27 output using the history data, the stock status pattern is “k”, and as a result of the diagnosis, the stock status is predicted to be “possible shortage of stock” on a predetermined date in the future. When the assumed data is used, the stock status pattern is predicted to be “normal” at “n”. Both are inventory predictions, but the user can generally use the latter prediction with high accuracy to perform inventory control for the item (part number 1234567). The calculation termination process after step 1105 is determined by user selection. There are five types of user selections, and one is a selection to end as it is. Another option is to end the process after the process of registering / updating the stock reference to the result output in the process of step 1112 (step 1119). The other option is to end processing after performing processing (step 1120) for registering / updating the output control information in the control information storage unit 0224. . Another one is step 11
Register the assumed data obtained in 18 in the inventory-related data storage /
This is a selection to end after the updating process (step 1121). The last one is a selection of ending after performing two or more step processes among steps 1119, 1120 and 1121.

If it is determined in step 1101 that the instruction is a search execution instruction, reading of the disclosure determination rule is started (step 1122). After the reading is completed, a process for determining whether to permit disclosure of the control information starts (step 11).
23) If it is determined to permit, a process of searching for control information is executed next (step 1124), and the result is displayed on the output device 0102 (step 1125), and the search process ends. If it is determined not to be permitted, the fact is displayed on the output device 0102 (step 1125), and the search process ends. D. Output results Examples of inventory control information displayed in step 1105 are shown in Figs.
This will be described with reference to FIGS. 16, 20, 23, 25, 26, and 21.

FIG. 13 is a schematic diagram of the stock status diagnosis result.
From this figure, information such as the diagnosed part number, the diagnosis date and time, the diagnosis tense, the diagnosis result, the inventory status pattern, and the contents of the appropriate amount determination pattern can be obtained. Here, the diagnosis tense does not necessarily need to be “present” which is the same as the diagnosis date and time. The diagnostic tense may be in the past or the future.

FIG. 14 is a schematic view showing the result of the batch drawing process.
FIG. 14 shows, in one chronological order, the transition in storage, the transition in storage, and the transition in inventory for a predetermined period of the part number “1234567”. From this figure, it is possible to acquire inventory status information such as inventory transition, inventory transition, and inventory transition, and information that can be recognized in a form in which the degree of variation in the procurement lead time is collected. Here, the degree of variation is shown by a pattern. It indicates that the procurement lead time varies as the number of patterns increases. Note that there is no need to use a pattern type as the method of identifying the degree of variation. For example, identification may be made by color.

FIG. 15 is a schematic diagram of the excess / deficiency amount calculation result.
From this figure, information such as the excess or deficiency of inventory can be obtained.

FIG. 16 is a schematic diagram showing the planning result of the inventory control method. From this figure, information on inventory control methods such as upward revision of safety stock and disposal of dead stock can be obtained.

FIG. 20 is a schematic diagram of the optimal reference result. From this figure, information on the quantitative inventory control method can be obtained.

FIG. 23 shows a schematic diagram of the result output after the number-of-replacements calculation process. From this figure, information such as the minimum number of replacements and the date of replacement can be obtained for each item name.

FIG. 25 is a schematic diagram of the result output after the optimal exchange calculation process. From this figure, information such as the optimal replacement date and the number of replacements can be obtained for each item name.

FIG. 26 is a schematic diagram of the result output after the assumed data creation processing. From this figure, it is possible to acquire transition information such as the assumed delivery amount and stock amount.

FIG. 21 is a schematic diagram showing a case where some of the inventory control information, such as the inventory diagnosis result and the batch drawing processing result, are displayed on the output device 0102 in a lump. From this figure, a plurality of pieces of inventory control information such as a diagnosis result, a transition of inventory, a transition of delivery, and an inventory control method can be obtained simultaneously. E. FIG. Start screen and end screen of various calculation processes and search processes An example of a user interface for starting various calculation processes and search processes will be described with reference to FIG. Screen 1701 is a main menu screen. The screen 1701 includes a button for executing various calculations such as a stock status diagnosis and a button for executing a process of searching for inventory control information. First, the user selects a calculation execution button or a search execution button from the screen 1701. When the calculation execution button is selected on the screen 1701, a screen 1702 is displayed next. The screen 1702 has input items such as a part number, a data type, a tense, and a warehouse name. When the user inputs necessary items in the input items and selects the execution button, the process proceeds to the next process. If a search execution button is selected on the screen 1701, a screen 1703 is displayed next. The screen 1703 has input items such as a user number, a password, and a part number to be searched. When the user inputs necessary items in the input items and selects the search execution button, the process proceeds to the next process. An example of a user interface for ending various calculation processes and search processes will be described with reference to FIG. screen
Reference numeral 2801 denotes an end screen of various calculation processes. On screen 2801,
In addition to the calculation result, there are an inventory standard update button, a control information update button, an assumed data update button, and an end button. When the user selects the end button, the calculation processing can be ended. Screen 2802 is an end screen of the search processing. The screen 2802 has an end button in addition to the search result. When the user selects the end button, the search processing can be ended. F. Effects of the present embodiment The inventory control system 0100 of the present embodiment diagnoses inventory status for each item and outputs an inventory control method rationally in accordance with the inventory status, so that the speed and accuracy of decision making in inventory control are improved. Improvement can be achieved.

Further, since part or all of the inventory control information can be displayed on an output device via a network such as the Internet, the inventory control can be performed not only by the parties but also by a second party such as a business partner or a customer and a third party. Can also do it. In other words, the publication of inventory control information on the Internet gives the second party and third parties the opportunity to purchase inventory and sell parts, and as a result, it can be expected that the second party and third parties can perform inventory control rationally. .

[0079]

By providing an inventory control system and a control method capable of rationally executing appropriate inventory control in any inventory state pattern, it is possible to speed up decision making and improve accuracy in inventory control.

[Brief description of the drawings]

FIG. 1 is a hardware configuration diagram of an inventory control system according to a first embodiment.

FIG. 2 is a functional block diagram according to the first embodiment.

FIG. 3 is a schematic diagram showing a table structure in a stock-related data storage unit.

FIG. 4 is a schematic diagram showing a table structure in an appropriate amount determination rule storage unit.

FIG. 5 is a schematic diagram illustrating a table structure in a method determination rule storage unit.

FIG. 6 is a schematic diagram showing a table structure in a reference calculation constraint storage unit.

FIG. 7 is a schematic diagram showing a table structure in an exchange calculation constraint storage unit.

FIG. 8 is a schematic diagram illustrating a table structure in a disclosure determination rule storage unit.

FIG. 9 is a schematic diagram showing a table structure in an operation data storage unit.

FIG. 10 is a schematic diagram showing a table structure in a life data storage unit.

FIG. 11 is a flowchart of various processes.

FIG. 12 is a detailed flowchart of a stock status diagnosis step.

FIG. 13 is a schematic diagram showing a stock status diagnosis result.

FIG. 14 is a schematic view showing a result of a collective drawing process.

FIG. 15 is a schematic diagram showing a calculation result of excess and deficiency.

FIG. 16 is a schematic diagram showing a result of drafting an inventory control method.

FIG. 17 is an explanatory diagram showing a user interface for activating various calculation processes and search processes.

FIG. 18 is a schematic diagram showing a stock status pattern.

FIG. 19 is an explanatory diagram showing a determination formula and a code for symbolizing the stock status of an item.

FIG. 20 is a schematic diagram showing an optimal reference result.

FIG. 21 is an explanatory diagram showing a case where a plurality of inventory control information are output simultaneously.

FIG. 22 is an explanatory diagram showing calculation of the number of replacements.

FIG. 23 is a schematic diagram illustrating a result output after the number-of-replacements calculation process.

FIG. 24 is an explanatory diagram showing an optimal exchange calculation.

FIG. 25 is a schematic diagram showing a result output after the optimal exchange calculation process.

FIG. 26 is a schematic diagram illustrating a result output after the assumed data creation processing.

FIG. 27 is a schematic diagram showing a stock status diagnosis result based on assumed data.

FIG. 28 is an explanatory diagram showing a user interface for ending various calculation processes and search processes.

[Explanation of symbols]

0100 ・ ・ ・ Inventory control system, 0101 ・ ・ ・ Input device, 0102 ・ ・ ・
Output device, 0103: processing device, 0104: auxiliary storage device, 01
031 ・ ・ ・ Interface, 01032 ・ ・ ・ Central processing unit (C
PU), 01033: Main storage device, 0201: Parameter calculation unit, 0202: Batch processing unit, 0203: Inventory condition diagnosis unit,
0204: excess / deficiency amount calculation unit, 0205: control method planning unit, 0206
... Optimal reference calculation unit, 0207 ... Optimal exchange calculation unit, 0208 ...
Assumption data creation unit, 0209 ... stock standard update unit, 0210 ... information disclosure judgment unit, 0211 ... control information search unit, 0212 ... output unit, 0213 ... assumption data update unit, 0214 ..Input unit, 0215
・ Control information update unit, 0216 ・ ・ ・ Exchange number calculation unit, 0217 ・ ・ ・ Processing result storage unit, 0218 ・ ・ ・ Stock related data storage unit, 0219 ・ ・ ・
Appropriate amount determination rule storage unit, 0220 ... method determination rule storage unit, 022
1 ・ ・ ・ Reference calculation constraint storage unit, 0222 ・ ・ ・ Exchange calculation constraint storage unit, 0223 ・ ・ ・ Public judgment rule storage unit, 0224 ・ ・ ・ Control information storage unit, 0225 ・ ・ ・ Operation data storage unit, 0226 ・..Lifetime data storage unit, 0301: Entry / exit history table, 0302: Order history table, 0303: Parts management master table, 0304: Entry / exit assumed table, 0305: Order assumed table, 0306: assumed data constraint table, 03011: part number column, 03012
..Entry / exit judgment flag column, 03013 ... date / time column, 0301
4 ... Quantity column, 03021 ... Order date and time column, 03022 ... Order quantity column, 03023 ... Reception date column, 03031 ... Order size column, 03032 ... Safety stock column, 03033 ...・ Supplier column, 03034 ・ ・ ・ Ordering method column, 0401 ・ ・ ・ Appropriate amount judgment rule table, 04011 ・ ・ ・ Appropriate amount judgment pattern column, 0401
2 ... judgment contents column, 0501 ... method judgment rule table, 0
5011 ・ ・ ・ Method judgment pattern column, 05012 ・ ・ ・ Inventory control method column, 0601 ・ ・ ・ Reference calculation restriction table, 060011 ・ ・ ・ Reference calculation restriction item column, 06012 ・ ・ ・ Reference calculation setting condition column, 0701 ...・ Exchange calculation constraint table, 07011 ・ ・ ・ Exchange calculation constraint item column, 07012 ・ ・ ・ Exchange calculation setting condition column, 08
01 ・ ・ ・ Publication determination rule table, 08011 ・ ・ ・ Stock control method column, 08012 ・ ・ ・ Stock status diagnosis result column, 08013 ・ ・ ・ Batch diagram processing result column, 0901 ・ ・ ・ Operation information table, 0902 ・
..Installation information table, 1001 ... Life master information table, 1101 to 1125 ... Various processing steps, 1701 ... Main menu screen example 1702 ... Screen example displayed after selecting calculation processing button 1703 ..Screen example 1801 displayed after selecting the search processing button: stock status pattern of part number "1234567", 1802 ... stock status pattern of part number "7654321",
2801: End screen example of calculation processing, 2802: End screen example of search processing

Continued on the front page (72) Inventor Hirotaka Morita 292, Yoshida-cho, Totsuka-ku, Yokohama-shi, Kanagawa Prefecture Inside the Hitachi, Ltd. Production Technology Laboratory (72) Inventor Haruhisa Nakamura 1-6-6 Kandanishikicho, Chiyoda-ku, Tokyo, Ltd. Hitachi Building System (72) Inventor Masaki Honma 1-6-6 Kanda Nishikicho, Chiyoda-ku, Tokyo F-term in Hitachi Building System Co., Ltd. 3C100 AA45 BB36

Claims (20)

[Claims] 1. A system for controlling an inventory amount of an item of a part or a component, comprising: an inventory-related data storage unit for holding inventory-related data that is data relating to entry / exit / inventory of the item; Item-specific trends, periodicities, variations, averages, maximums,
A parameter calculation unit for calculating parameters of a minimum value, a mode value, and a range; an appropriate amount determination rule storage unit for storing a predetermined appropriate amount determination rule for determining whether the stock state is appropriate; A stock status that generates stock status pattern information composed of a plurality of types of predetermined codes based on the stock related data and parameters, and diagnoses the stock status of each item based on the stock status pattern and the appropriate amount determination rule. An inventory control system, comprising: a diagnosis unit; and an output unit that displays a diagnosis result for each item on an output device. 2. Stock status information of a stock transition, a stock change, and a stock change shown based on the stock-related data, and information that can recognize the degree of variation in procurement lead time shown based on the stock-related data. 2. The inventory control system according to claim 1, further comprising: a collective graphic processing unit configured to perform graphic processing in a batch form; and an output unit configured to display a processing result of each item on an output device. 3. An excess / deficiency amount calculation unit for calculating an excess / deficiency amount of inventory based on the diagnosis result, inventory-related data and parameters, and an output unit for displaying the excess / deficiency amount of each item on an output device. The inventory control system according to claim 1, wherein: 4. A method judging rule storing section for storing a predetermined inventory control method corresponding to the diagnosis result, and a method judging rule stored in the method judging rule storing section. 2. The inventory control system according to claim 1, further comprising: a control method drafting unit that drafts an inventory control method corresponding to the diagnosis result; and an output unit that displays the drafting result of each item on an output device. 5. A reference calculation constraint storage unit for preliminarily storing constraint items which can be changed by a user, a planning result obtained by the control method planning unit, the stock-related data, and a reference calculation constraint storage unit. And an output unit for displaying an optimum standard result for each item on an output device, the optimum standard calculating unit calculating an optimum inventory standard based on conditions set by a user based on the restricted items. The inventory control system according to claim 4, wherein 6. An operation data storage unit for storing the actual operation results of each item that is actually managed, a life data storage unit for storing the life of each item, and restriction items that can be set and changed by a user. And the items actually managed based on the conditions set by the user based on the operation data and the life data, and the constraint items held in the exchange calculation constraint storage unit. A replacement count calculation unit for calculating a minimum replacement count for each, a replacement interval based on conditions set by a user based on the replacement counts and the life data of the items, and constraint items held in the replacement calculation constraint storage unit. An inventory control system, comprising: an optimal exchange calculator for calculating an exchange date that optimizes an item; and an output unit for displaying the optimal exchange date on an output device for each of the items actually managed. System. 7. An assumption data creation section for creating data relating to entry / exit / inventory of items based on the optimal exchange date result and stock-related data, and an output section for displaying the created assumption data on an output device. 7. The inventory control system according to claim 6, wherein: 8. The apparatus according to claim 1, wherein the inventory control information output from the output unit is transmitted to an output device connected via a network such as the Internet. Inventory control system. 9. A control information storage unit for holding inventory control information displayed by the output unit, and a control information updating unit for registering or updating the inventory control information in the control information storage unit. The inventory control system according to any one of claims 1 to 8, wherein 10. The information displayed by the output unit,
A disclosure determination rule storage unit that holds determination rules for determining whether to permit disclosure to a second party such as a business partner or a customer or a third party; an inventory control method obtained by the control method planning unit; The inventory control system according to any one of claims 4 to 8, further comprising an information disclosure determination unit that determines whether to permit disclosure of the information based on a disclosure determination rule. 11. An input section for inputting a keyword for extracting information held in the control information storage section from the control information storage section, and holding the information in the control information storage section using the keyword input to the input section. The inventory control system according to claim 9, further comprising a control information search unit that searches for the searched information. 12. An inventory standard updating unit for registering or updating an inventory standard held in said inventory-related data storage unit based on an optimal inventory standard generated by said optimal standard calculation unit. The inventory control system according to claim 5, wherein 13. An assumed data updating unit for registering or updating a part or all of the data relating to entry / exit / inventory of items generated by the assumed data creating unit in the inventory related data storage unit. The inventory control system according to claim 7, wherein: 14. A method for controlling an inventory amount of an item of a part or a component, wherein the inventory-related data storage unit for storing inventory-related data that is data relating to entry / exit / inventory of the item. Read data,
Item-specific trends, periodicities,
The parameters of variation, average value, maximum value, minimum value, mode value, and range are calculated by the parameter calculation unit, and a predetermined appropriate amount determination rule for determining whether the stock state is appropriate is held. The appropriate amount judging rule is read from the appropriate amount judging rule storage unit, and based on the inventory related data and the parameters, inventory state pattern information including a plurality of types of predetermined codes is generated. A stock control method characterized in that the stock status of each item is diagnosed by an arithmetic processing means on the basis of the above, and the diagnosis result of each item is displayed on an output device. 15. Stock status information of a stock transition, a stock change, and a stock change illustrated based on the stock related data, and information capable of recognizing a variation degree of a procurement lead time illustrated based on the stock related data. 15. The inventory control method according to claim 14, wherein the processing is illustrated in a collective form, and a processing result for each item is displayed on an output device. 16. An excess or deficiency amount of inventory is calculated by an excess or deficiency calculation unit based on the diagnosis result, inventory related data and parameters, and the excess or deficiency amount for each item is displayed on an output device. The inventory control method according to claim 14. 17. A method determination rule is read from a method determination rule storage unit that holds a method determination rule that is a relation rule of an inventory control method corresponding to a diagnosis result, and the diagnosis result is determined based on the diagnosis result and the method determination rule. 15. The inventory control method according to claim 14, further comprising: an output unit that plans an inventory control method corresponding to the item by the control method planning unit and displays a planning result for each item on an output device. 18. A restriction item is read out from a reference calculation restriction storage unit which stores in advance a restriction item which can be changed by a user, and a planning result obtained by the control method planning unit, the stock-related data, and the restriction item are also stored. 18. The inventory control according to claim 17, wherein an optimal standard is calculated by an optimal standard calculating unit based on conditions set by a user, and the optimal standard result for each item is displayed on an output device. Method. 19. A storage medium readable by a machine, wherein the storage medium stores a program for realizing the inventory control method according to any one of claims 14 to 18. 20. An inventory control program for controlling an inventory amount of an item of a part or a component, comprising: reading out inventory-related data, which is data relating to entry / exit / inventory of the item, from storage means; A step of calculating parameters of the item-specific tendency, periodicity, variation, average value, maximum value, minimum value, mode value, and range by the processing means from the data, and determining whether the stock status is appropriate; Reading a predetermined appropriate amount determination rule from the appropriate amount determination rule storage unit, and generating inventory state pattern information composed of a plurality of types of predetermined codes based on the inventory related data and the parameters. Diagnosing the inventory status of each item by applying the inventory status pattern to the appropriate quantity determination rule; Inventory control program, characterized in that to execute a step of displaying on the output device a result.