The present invention relates to a technique of calculating a safety inventory amount of a component that is used commonly in a plurality of products.
Speeding-up of computers has allowed development of an apparatus for calculating a safety inventory amount of a component according to a certain method even in the case where a product is composed of a large number of components.
For example, Patent Document 1 describes a method in which a computer system is used to calculate a required-amount standard deviation concerning time variation of a required amount of each component for each product on the basis of a demand standard deviation concerning time variation of demand for each product and components configuration information of each product, and to calculate a safety inventory amount by using the obtained required-amount standard deviations, safety coefficients and the like.
Patent Document 1: Japanese Unexamined Patent Application Laid-Open No. 2007-128225
It is certain that the technique described in the above Patent Document 1 can obtain a safety inventory amount of a component with some degree of accuracy. Nevertheless, a manufacturer that produces a product always desires to obtain a more accurate safety inventory amount of a component so as to reduce excess or deficiency of the component as far as possible.
Thus, to respond to this request, an object of the present invention is to provide a technique of obtaining a safety inventory amount of a component more accurately. Means to achieve the object
To achieve the above object, the present invention is characterized in executing the following (1)-(5) so as to calculate a safety inventory amount of a common component used commonly in a plurality of products.
Here, when the integrated required-amount standard deviation is obtained (3), it is favorable to execute the following (3-1)-(3-4).
Demands for a plurality of products have some mutual relationship between them. For example, a sale of a product (a main unit) has often a certain correlation with a sale of an option (an optional product) of that product. In that case, it can be said that there is a positive correlation between demands for these products. On the contrary, there is a case where, when one product in the group sells well, sales of the other products in the group come down. In that case, it can be said that there is a negative correlation between demands for these products.
As for a safety inventory amount of a common component used in a plurality of products having such a correlation, a relatively small amount of safety inventory is sufficient in the case where demands for the products have a negative correlation, because amounts of the used component tend to vary in the reverse direction to each other. On the other hand, in the case where demands for the products have a positive correlation, amounts of the component used becomes larger. Accordingly, if a correlation between demands for a plurality of goods is not taken into consideration, risk of occurrence of excess or deficiency of a component becomes higher. In contrast, the present invention considers a correlation between demands for a plurality of products in order to obtain a safety inventory amount of a common component used in the products. Thus, it is possible to obtain an accurate safety inventory amount of a common component, and as a result excess or deficiency of the component can be kept to the minimum.
[FIG 1] A block diagram showing a configuration of a component safety inventory amount calculation device as an embodiment of the present invention.
[
[
[
[
[
[
[
[
[
[
[
Now, an embodiment of a component safety inventory amount calculation device according to the present invention will be described referring to drawings.
As shown in
The auxiliary storage unit 140 stores: a product demand standard deviation table 141 for storing, for each product, a demand standard deviation concerning time variation in the past; a component configuration information table 142 for storing component configuration information for each product; a demand record information table 143 for storing past demand record information for each product; a safety inventory source information table 144 for storing safety inventory source information (a component inventory safety coefficient, a component procurement lead time, and a component order cycle), i.e. parameters required for obtaining a safety inventory amount of a component; and a safety inventory amount table 145 for storing a safety inventory amount of a component. Further, the auxiliary storage unit 140 stores a safety inventory calculation program 149 for obtaining a safety inventory amount of a component. As for the safety inventory calculation program 149, it is possible that the program 149 stored in a portable storage medium D is reproduced by the storage/reproduction unit 150 and stored in the auxiliary storage unit 140. Or, the safety inventory calculation program 149 may be obtained from the outside through a communication device (not shown in the figure) and then stored in the auxiliary storage unit 140. Further, the product demand standard deviation table 141, the component configuration information table 142, the demand record information table 143 and the safety inventory source information table 144 may be stored in the RAM 120.
The CPU 110 functionally comprises: a required-amount deviation calculating section 111 for obtaining a required-amount standard deviation of a component of each product by using a demand standard deviation and the like of the product; an integrated required-amount deviation calculating section 112 for obtaining an integrated required-amount standard deviation by integrating respective required-amount standard deviations of a common component to products; a safety inventory amount calculating section 116 for obtaining a safety inventory amount of the common component by using the integrated required-amount standard deviation and the like; and an input/output control section 117. The integrated required-amount deviation calculating section 112 comprises: a correlation coefficient calculating block 113 for obtaining a correlation coefficient indicating a correlation between amounts of the common component required respectively for two products; a primary integrated required-amount deviation calculating block 114 for integrating required-amount standard deviations of the common component to two products; and a processing control block 115 for controlling processing in the correlation coefficient calculating block 113 and the primary integrated required-amount deviation calculating block 115.
Each of the functional sections 111-117 operates when the CPU 110 reads the safety inventory calculation program 149 from the auxiliary storage unit 140, loads the program 149 into the RAM 120, and executes the program 149.
Next, operation of the above-described component safety inventory amount calculation device 100 will be described referring to the flowcharts shown in
First, the input/output control section 117 receives the demand standard deviation of each product, the component configuration information of each product, the demand record information of each product, and the safety inventory source information of each component. Then, the input/output control section 117 stores these pieces of information respectively in the product demand standard deviation table 141, the component configuration information table 142, the demand record information table 143, and the safety inventory source information table 144 (S11). Here, as an input means for each piece of information, the input unit 160 such as a keyboard is shown as an example. This input means may be storage/reproduction unit 150 or a communication device (not shown). That is to say, various types of information stored in a portable storage medium D may be reproduced by the storage/reproduction unit 150 so that the input/output control section 117 may receive those various types of information. Or, various types of information may be received through a communication device so that the input/output control section 117 receives those various types of information.
As shown in
As shown in
Here, for easier comprehension of the following description, it is assumed that: products under consideration are three kinds of products having respective IDs “A”, “B” and “C”; components used in some one of these products are four kinds of components having respective IDs “a”, “b”, “c” and “x”; and the component having ID “x” is the only component used commonly in these products. Further, in the following, a safety inventory amount of the common component “x” is obtained.
As shown in
As shown in
Here, the inventory safety coefficient means a in a variable z defined by a·σ (σ: standard deviation) with respect to a normal distribution of an inventory amount. For example, an inventory safety coefficient required for obtaining an inventory out-of-stock rate of 5% is 1.65, because the variable z is 1.65·σ for attaining an inventory existence rate of 95%.
Further, the procurement lead time of a component means a time (day) elapsing from an order of the component to its delivery, and the order cycle of a component means a time (day) between an order of the component and its next order.
Next, the required-amount deviation calculating section 111 extracts a common component “x” common to all the products “A”, “B” and “C” from the component configuration information table 142 (
Then, the required-amount deviation calculating section 111 calculates, for each product, a standard deviation of a required-amount of the common component “x” (S13).
Here, details of the required-amount standard deviation calculation process (S13) will be described referring to the flowchart shown in
First, from the component configuration information table 142 (
Next, the required-amount deviation calculating section 111 extracts, from the product demand standard deviation table 141 (
Last, the required-amount deviation calculating section 111 multiplies the demand standard deviation of each product by the relevant number of the common component “x”, to obtain the required-amount standard deviations “3”, “10” and “2” of the common component “x” in these products, and arranges these required-amount standard deviations “3”, “10” and “2” 123 in the RAM 120, associating them with the respective product IDs arranged previously in the RAM 120 (S133). For example, as shown in
This ends the required-amount standard deviation calculation process (S13).
Description will be given, returning again to the flowchart shown in
When the required-amount standard deviation calculation process (S13) ends, the integrated required-amount deviation calculating section 112 integrates the required-amount standard deviations of the respective common component “x” regarding all the products “A”, “B” and “C” using the common component “x”, to calculate a required-amount standard deviation of the common component “x” regarding all the products, i.e. an integrated required-amount standard deviation (S14).
Here, details of the integrated required-amount standard deviation calculation process (S14) will be described referring to the flowchart shown in
First, the processing control block 115 of the integrated required-amount deviation calculating section 112 selects arbitrary two products as one group out of all the products “A”, “B” and “C” using the common component “x”. In other words, out of a combination of the common component “x” and the product “A”, a combination of the common component “x” and the product “B” and a combination of the common component “x” and the product “C”, arbitrary two combinations are selected as one group (S141). Here, it is assumed that the processing control block 115 selects two combinations, the combination of the common component “x” and the product “A” and the combination of the common component “x” and the product “B”, as one group.
Next, the correlation coefficient calculating block 113 of the integrated required-amount deviation calculating section 112 calculates a correlation coefficient that indicates a correlation between the required amounts of the common component of the two products (S142).
Here, details of the correlation coefficient calculation process (S142) will be described referring to the flowchart shown in
First, the correlation coefficient calculating block 113 of the integrated required-amount deviation calculating section 112 extracts the respective numbers of the common component “x” used in the products in the group from the component configuration information table 142 (
Next, the correlation coefficient calculating block 113 extracts the demand records of (i.e. actual demands for) each product in the group, and arranges these demand records 126 in the RAM 120, associating them with the respective product IDs arranged previously in the RAM 120 (S1422).
Next, for each product in the group, the correlation coefficient calculating block 113 multiplies a demand record of the product by the number of the common component “x” used in the product in order to calculate a required-amount record of the common component “x” in this product. And, as shown in
Last, using the required-amount records of the common component “x” regarding the products in the group, the correlation coefficient calculating block 113 calculates a correlation coefficient K of the common component “x” between the products “A” and “B” in the group according to the following [Equation 1], and arranges the correlation coefficient K 128 in the RAM 120 as shown in
Here:
xi: a required-amount record of one of the two products in each period;
xa: an arithmetic mean of the required-amount records of that one product in the periods concerned;
yi: a required-amount record of the other product in each period; and
ya: an arithmetic mean of the required-amount records of the other product in the periods concerned.
Referring to the flowchart shown in
When the correlation coefficient calculation process (S142) ends, the primary integrated required-amount deviation calculating block 114 of the integrated required-amount deviation calculating section 112 calculates a primary integrated required-amount standard deviation σS of the common component “x”, which is a required-amount standard deviation of the common component “x” calculated by integrating the two combinations in the group according to the following [Equation 2] using the correlation coefficient K in the group and the respective required-amount standard deviations σx and σy of the common component “x” for the products in the group. Then, as shown in
[Equation 2]
σs=√{square root over (σx2σy2+2 K×σx×σy)} (2)
Next, the processing control block 115 of the integrated required-amount deviation calculating section 112 virtually unites the two combinations in the group into one combination. In other words, the two products “A” and “B” in the group are virtually taken as one product “A-B” (S144).
Next, the processing control block 115 judges whether there remains only one combination of the common component “x” and a product (S145). When it is judged that only one combination remains, then it is judged that the integration of the required-amount standard deviations of the common component “x” for the products has been ended, and the integrated required-amount standard deviation calculation process (S14) is ended. On the other hand, when it is judged that two or more combinations remain, then the processing returns to the step S141. At this stage in the present embodiment, two combinations, i.e. the combination of the common component “x” and the product “C” and the combination of the common component “x” and the product “A-B”, exist as combinations using the common component “x”, and thus the processing returns to the step S141.
Returning to the step S141, the processing control block 115 selects a group of any two combinations out of the remaining combinations of the common component “x” and a product. In the case of the present embodiment, the remaining combinations of the common component “x” and a product are only two, i.e. the combination of the common component “x” and the product “C” and the combination of the common component “x” and the product “A-B”. Thus these two combinations are selected as a group.
Next, the coefficient correlation calculating block 113 of the integrated required-amount deviation calculating section 112 calculates a correlation coefficient that indicates a correlation between the respective required amounts of the common component “x” for the two products “C” and “A-B” (S142).
Here again, the second round of correlation coefficient calculation process (S142) will be described referring to the flowchart shown in
First, in this correlation coefficient calculation process (S142) too, the correlation coefficient calculating block 113 of the integrated required-amount deviation calculating section 112 extracts the number of the common component “x” used in each product in the group from the component configuration information table 142 (
Next, the correlation coefficient calculating block 113 extracts the respective demand records of the products in the group, and arranges in the RAM 120 these demand records 126a, associating them with the respective product IDs arranged previously in the RAM 120 as shown in
Next, for each product in the group, the correlation coefficient calculating block 113 multiplies the demand record of the product with the number of the common component “x” used in the product in order to calculate the required-amount record of the common component “x” in this product. And as shown in
Last, using the required-amount records of the common component “x” regarding the products in the group, the correlation coefficient calculating block 113 calculates a correlation coefficient K of the common component “x” between the products “C” and “A-B” in the group according to the above [Equation 1], and arranges the correlation coefficient K 128a in the RAM 120 as shown in
This ends the second round of correlation coefficient calculation process (S142).
Again, description will be given referring to the flowchart shown in
When the second round of correlation coefficient calculation process (S142) ends, the primary integrated required-amount deviation calculating block 114 of the integrated required-amount deviation calculating section 112 calculates a primary integrated required-amount standard deviation σS of the common component “x” by integrating the two combinations in the group according to the above [Equation 2] using the correlation coefficient K in the group and the respective required-amount standard deviations σx and σy of the common component “x” for the products in the group. Then, as shown in
Next, the processing control block 115 of the integrated required-amount deviation calculating section 112 virtually unites the two combinations in the group into one combination. In other words, here the two products “C” and “A-B” in the group are virtually taken as one product “A-B-C” (S144).
Next, the processing control block 115 judges whether there remains only one combination of the common component “x” and a product (S145). At this stage in the present embodiment, only one combination, i.e. the combination of the common component “x” and the product “A-B-C”, exists as a combination using the common component “x”. Thus, the finally-obtained primary integrated required-amount standard deviation “13.4” is taken as the required-amount standard deviation of the common component “x” regarding all the products, i.e. the integrated required-amount standard deviation σI, and this integrated required-amount standard deviation calculation process (S14) is ended.
Again, description will be given referring to the flowchart shown in
When the integrated required-amount standard deviation calculation process (S14) ends, a safety inventory amount of the common component “x” is calculated (S15).
Here, details of the safety inventory amount calculation process (S15) will be described referring to the flowchart shown in
First, the safety inventory amount calculating section 116 extracts the inventory safety coefficient kS of the common component “x”, its procurement lead time T and its order cycle S from the safety inventory source information table 144 (
Next, the safety inventory amount calculating section 116 calculates the safety inventory amount SS according to the following [Equation 3], using the integrated required-amount standard deviation σI calculated in the step S14, and the inventory safety coefficient kS, the procurement lead time T and the order cycle S of the common component “x”, which were extracted in the step S151 (S152). In the present embodiment, the safety inventory amount SS becomes “89”.
[Equation 3]
S
S
=k
s×σI×√{square root over (T×S)} (3)
Last, the safety inventory amount calculating section 116 stores the calculated safety inventory amount SS in the safety inventory amount table 145, associating the safety inventory amount SS with the ID “x” of the common component (S153)
This ends the safety inventory amount calculation process (S15).
Again, description will be given referring to the flowchart shown in
When the safety inventory amount calculation process (S15) ends, the required-amount deviation calculating section 111 judges whether there remains a common component that has not been dealt with (S16). If there remains a common component that has not been dealt with, the processing returns to the step S12 to extract a remaining common component. On the other hand, if there does not remain a common component that has not been dealt with, the input/output control section 117 extracts the safety inventory amount for each common component ID from the safety inventory amount table 145, and, as shown in
This is the end of a series of operation of the component safety inventory amount calculation device 100.
Demands for a plurality of products have some mutual relationship between them. For example, a sale of a product (a main unit) has often a certain correlation with a sale of an option (an optional product) of that product. In that case, it can be said that there is a positive correlation between demands for these products. On the contrary, there is a case where, when one product in the group sells well, sales of the other products in the group come down. In that case, it can be said that there is a negative correlation between demands for these products.
As for a safety inventory amount of a common component used in a plurality of products having such a correlation, a relatively small amount of safety inventory is sufficient in the case where demands for the products have a negative correlation, because amounts of the used component tend to vary in the reverse direction to each other. On the other hand, in the case where demands for the products have a positive correlation, amounts of the component used becomes larger. Accordingly, if a correlation between demands for a plurality of goods is not taken into consideration, risk of occurrence of excess or deficiency of a component becomes higher. In contrast, the present embodiment considers a correlation between demands for a plurality of products in order to obtain a safety inventory amount of a common component used in the products. Thus, it is possible to obtain an accurate safety inventory amount of a common component, and as a result excess or deficiency of the component can be kept to the minimum. Thus, it is possible to reduce work burden of adjusting the safety inventory amount in a manufacturer of the products.
Hereinabove, the present invention has been described in relation to the embodiment as an example. It will be obvious to persons skilled in the art that many substitutes, modifications and variations can be realized. Thus, the above-described embodiment of the present invention is intended to give an example not to limit the scope of the present invention.
For example, in the above-described embodiment of the present invention, a standard deviation of each product, which is stored in the demand standard deviation storage section, is not data for each period. In practice, however, a safety inventory amount may be calculated as data for each data.
Filing Document | Filing Date | Country | Kind | 371c Date |
---|---|---|---|---|
PCT/JP2008/073305 | 12/22/2008 | WO | 00 | 12/5/2011 |