JP4964067B2 - Standard inventory management device - Google Patents

Description

  The present invention relates to a reference inventory management apparatus that calculates a reference inventory quantity in product inventory management, and more particularly to a reference inventory management apparatus that calculates an appropriate reference inventory quantity for a mass-production product that performs prospective production. is there.

  Conventionally, the minimum number of inventory (basic inventory) that does not cause excess inventory or out of stock in mass-produced products that carry out prospective production is set based on the experience and intuition of the person in charge of past shipment results, It was calculated using statistical methods described in the literature.

  As a technique relating to a conventional method for calculating a reference stock using a statistical method, for example, there is Patent Literature 1. In Patent Document 1, a demand forecast data set that is the basis of production plan data is generated, a product number that allows a shortage of production is determined, a production plan simulation is executed, and each product number is produced for the number of trials. Technology that generates production plan data including planned quantities and product shortages, statistically processes all production shortages as necessary stock quantities, and determines appropriate stock quantities for each product number based on preset inventory management standards Is disclosed.

JP 2004-118429 A

  However, in the prior art described in Patent Document 1, since the reference inventory is calculated by statistical processing, a numerical value deviating from the actual situation may be calculated, and a mass-produced product that performs all expected production However, there was a problem that an appropriate inventory amount could not be calculated.

  Factors for calculating numerical values that deviate from the actual situation include cases in which the variation in demand is not in a normal distribution or that it is difficult to set parameters necessary for the mathematical formula used for the calculation. For this reason, the determination of the reference stock is finally set and operated based on the experience and intuition of the person in charge, and the experience and ability of the person in charge are greatly influenced by the occurrence of excess inventory and out of stock.

  The present invention has been made in view of the above, and it is possible to calculate a reference stock number for each product of a mass-production product that performs prospective production without depending on the experience and ability of a person in charge. The purpose is to obtain a management device.

  In order to solve the above-described problems and achieve the object, the present invention includes a daily production performance data table in which the number of shipments and the number of stocks of each product are registered for each date, and the number of shipments of each product for each month. The actual production data table that stores the monthly production result data table in which the number of stocks are registered, the order date data table that stores the delivery date at the time of ordering for the product and the actual delivery date when delivery is completed, and the month for each product A plan data storage unit for storing a plan data table in which the number of production plans for each is registered, and a delivery date of the order result data table is within a predetermined data extraction period and is associated with the delivery date When the actual delivery date exceeds the delivery date, the out-of-stock date identifying processing unit that identifies the delivery date as the out-of-stock date and the abnormal actual date based on a predetermined abnormality judgment condition are identified and specified. An abnormal value exclusion processing unit for excluding out-of-stock dates specified by the actual date and the out-of-stock date specifying processing unit from the data extraction period, and a data extraction period in which the abnormal actual date and out-of-stock date are excluded by the abnormal value exclusion processing unit A marginal inventory extraction unit that extracts the minimum inventory quantity among the inventory quantities of the product in the daily production performance data table associated with the date in the list as the limited inventory quantity of the product, and predetermined shipping plan accuracy Based on the number of monthly shipments in the period plan data table and the number of monthly shipments in the monthly production results data, the absolute value of the difference between the number of monthly shipments and the number of monthly shipments is calculated. The average of the shipping plan accuracy period of the value divided by is calculated as the monthly average shipping plan accuracy, and the calculated monthly average shipping plan accuracy is the month of the monthly production result data table for the shipping plan accuracy period. The shipment plan accuracy share inventory calculation unit that calculates the planned accuracy share quantity by multiplying the monthly average shipment result, which is the average value of the shipment quantity, and the shipment plan accuracy to the limit inventory number extracted by the limit inventory extraction unit A reference inventory calculation unit that calculates the reference inventory number by adding the planned accuracy-based inventory numbers calculated by the distribution inventory calculation unit.

  According to the present invention, the shortest out of stock date for which delivery was delayed from the delivery date at the time of order and the abnormal actual date satisfying the abnormality determination condition are excluded from the data extraction period, and the minimum value is set as the limit stock quantity. Ask. In addition, the average of the shipping plan accuracy period, which is the value obtained by dividing the absolute value of the difference between the number of shipment plans per month and the number of shipments per month by the number of shipments per month, is calculated as the monthly average shipment plan accuracy. The inventory quantity for the planned accuracy is calculated by multiplying the shipping plan accuracy by the monthly average shipment result which is the average value of the number of shipments per month of the monthly production result data in the shipment plan accuracy period. Then, the reference inventory quantity is obtained by adding the inventory quantity for the planned accuracy to the limit inventory quantity. Thus, there is an effect that it is possible to obtain a reference inventory management device that can calculate the reference inventory number for each product of mass production products that perform prospective production without depending on the experience and ability of the person in charge.

  Embodiments of a reference inventory management apparatus according to the present invention will be described below in detail with reference to the drawings. Note that the present invention is not limited to the embodiments.

  An embodiment of the present invention will be described with reference to FIGS. FIG. 1 is a diagram showing an example of the configuration of a production / inventory management system to which a reference inventory management device according to the present invention is applied. In FIG. 1, a production / inventory management system is connected to a reference inventory management apparatus 1 for managing reference inventory of various products that are expected to be produced, and a reference inventory management apparatus 1 through a network 3 such as the Internet or an intranet. 1 to a plurality of (in this case, two) terminals 5 (indicated by 5-1 and 5-2) that can access 1 and a reference inventory management device 1 connected to a reference inventory management device 1 by a network different from the network And a production plan management device 7 for managing production plans and results based on the reference stock managed by No. 1 and registering the production results in the reference stock management device 1. The reference inventory management device 1 and the production plan management device 7 may be connected by the network 3.

  The reference inventory management device 1 includes a product information master storage unit 10, a performance data storage unit 11, a plan data storage unit 12, a parameter storage unit 13, a reference inventory calculation processing unit 14, a reference inventory calculation result storage unit 15, and a warning transmission reference value. A storage unit 16, a statistical data storage unit 17, a workflow processing unit 18, and an analysis / correction reason storage unit 19 are provided.

  The product information master storage unit 10 stores a product information master 101 in which information related to products managed by the reference inventory management device 1 is registered. FIG. 2 is a diagram illustrating an example of registration items registered in the product information master 101. In FIG. 2, as the registration items of the product information master 101, the product classification associated with the product name and the product classification indicated by the product name registered in the product name is registered, and the product name registered in the product name is indicated. The production line where the line identifier for identifying the line where the product is produced is registered, the person who manages the person who manages the product indicated by the product name registered in the product name, and the person registered The address of the person in charge where the mail address of the person in charge is registered is listed. Here, the product name is used as the product identifier for identifying the product. However, the product code is assigned to the product without being limited to the product name, and this product code is used instead of the product name as the product identifier. It doesn't matter.

  Returning to FIG. 1, the performance data storage unit 11 includes a daily production performance data table 111 in which the daily production performance of the product is registered, and a monthly production performance data table 112 in which the monthly production performance of the product is registered. And an order record data table 113 in which delivery information for product orders is registered.

  FIG. 3 is a diagram showing an example of registration items registered in the daily production record data table 111 shown in FIG. In FIG. 3, as the registration items of the daily production result data table 111, the product name for identifying the product is registered in association with the date, the product name for which the product is registered, and the product name for the date registered on the date. The number of productions in which the number of products indicated by the product name is registered, the number of shipments in which the number of products shipped in the product name registered in the product name registered on the date is registered, and the date registered in the date The number of products in stock indicated by the product name registered in the product name is listed as the number of stocks to be registered.

  FIG. 4 is a diagram showing an example of registration items registered in the monthly production performance data table 112 shown in FIG. In FIG. 4, as the registration items of the monthly production result data table 112, the product name for identifying the product is registered in association with the year and month, and the product name of the month registered in the month is registered. The number of products registered with the product number indicated by the product name, the number of products registered with the product name registered in the product name registered in the month registered in the month, and the number of shipments registered in the month. The number of products in stock indicated by the product name registered in the product name is listed as the number of stocks to be registered.

  FIG. 5 is a diagram showing an example of registration items registered in the order record data table 113 shown in FIG. In FIG. 5, as registration items of the order record data table 113, a product name for registering a product name for identifying a product in association with a date, and a product name registered for a product name of a date registered for the date. The order number in which the order number of the product indicated by is registered, the number of orders in which the product order indicated by the product name registered in the product name registered on the date is registered, the product name on the date registered on the date The delivery date when the delivery date at the time of ordering the product indicated by the product name registered in is registered, and the delivery status of the product indicated by the product registered with the product name registered on the date are listed Yes. Here, if the date (actual delivery date when the product has been delivered) is registered in the state, it means that the product has been delivered, and the status has a code different from the date ("-" in FIG. 5). Means that the item has not been delivered.

  Returning to FIG. 1, the plan data storage unit 12 stores a plan data table 121 in which a shipment plan for each product is registered. FIG. 6 is a diagram illustrating an example of registration items registered in the plan data table 121 illustrated in FIG. 1. In FIG. 6, as the registration items of the plan data table 121, a product name in which a product name for identifying a product is registered and the number of products planned to be shipped indicated by the product name registered in the product name are listed. The number of shipping plans is registered every month.

  Returning to FIG. 1, the parameter storage unit 13 stores parameters used by the reference stock calculation processing unit 14 to calculate the reference stock quantity. The parameters are the cycle that is the calculation timing of the standard inventory quantity, the data extraction period that is the period for extracting the data used to calculate the standard inventory quantity, the required delivery date that is the allowable range of delivery delay due to inventory placement, and the extracted data An abnormal value determination period used when excluding abnormal values, a variation determination value used for determining data variation, and a shipping plan accuracy period which is a period of shipping plan accuracy.

  The reference inventory calculation processing unit 14 includes various parameters stored in the parameter storage unit 13, a daily production result data table 111 stored in the result data storage unit 11, a monthly production result data table 112, an order result data table 113, and Based on the plan data table 121 stored in the plan data storage unit 12, the reference stock quantity for each product is calculated. That is, the reference stock calculation processing unit 14 calculates the reference stock number for each product based on the past plan and actual results.

  The reference stock calculation processing unit 14 is specified by the out-of-stock date specifying processing unit 141 that specifies the out-of-stock date of the product based on the order result data table 113 and the out-of-stock date specifying processing unit 141 based on the daily production result data table 111. An abnormal value exclusion processing unit 142 that excludes abnormal values from the out-of-stock date, the out-of-stock date from which abnormal values have been excluded by the abnormal value exclusion processing unit 142, and the minimum number that does not cause out-of-stock dates based on the order record data table 113 (limit A shipping plan that calculates the shipping plan accuracy based on the shipping plan accuracy by calculating the shipping plan accuracy based on the limit stock extraction unit 143 that extracts the stock quantity), the plan data table 121, and the monthly production result data table 112. The limit inventory number and output extracted by the accuracy inventory calculation unit 144 and the limit inventory extraction unit 143 And a standard inventory calculation unit 145 for calculating the number of reference stock on the basis of the planning accuracy component inventory calculation section 144 delivery schedule accuracy component inventory calculated by.

  The reference inventory calculation result storage unit 15 stores the reference inventory calculation result calculated by the reference inventory calculation processing unit 14. FIG. 7 shows an example of registration items of the reference inventory calculation result. In FIG. 7, the registration items of the reference stock calculation result are the product name in which the product name for identifying the product is registered, and the reference stock calculation processing unit 14 for the product indicated by the product name registered in the product name. The latest base stock number calculated is registered in the current base stock number and the product indicated by the product name registered in the product name is the base stock calculated one time before the base stock number registered in the current base stock number. The previous reference stock number in which the reference stock number calculated by the processing unit 14 is registered, and the approval flag in which information indicating whether the reference stock number registered in the current reference stock number has been approved are listed.

  Returning to FIG. 1, the warning transmission reference value storage unit 16 stores a parameter that is a transmission reference used to determine whether or not the warning transmission processing unit 183 of the workflow processing unit 18 transmits a warning. The parameters serving as transmission standards are a ratio threshold value, a requested delivery date compliance rate upper limit value and a requested delivery date compliance rate lower limit value that are upper and lower limits of compliance with the requested delivery date.

  The statistical data storage unit 17 registers a product name in which a product name for identifying a product is registered, and a delivery date compliance rate in which a delivery date compliance rate for a product indicated by the product name registered in the product name is registered. Store statistical data table.

  The workflow processing unit 18 performs an approval process for the reference inventory calculation result (calculated by the reference inventory calculation processing unit 14) stored in the reference inventory calculation result storage unit 15. The workflow processing unit 18 includes a user authentication unit 181, a registration unit 182, a warning transmission processing unit 183, a calculation result analysis / correction processing unit 184, and an approval unit 185.

  The user authentication unit 181 performs authentication processing for users who access the reference inventory management apparatus 1 using the terminal 5. The registration unit 182 uses the terminal 5 to register parameters input by the inventory manager in the parameter storage unit 13 or the warning transmission reference value storage unit 16. The calculation result analysis / correction processing unit 184 registers the data input by the person in charge of the product using the terminal 5 in the reference inventory calculation result or the analysis / correction reason storage unit 19 stored in the reference inventory calculation result storage unit 15. The approval unit 185 performs an approval process for the reference inventory number of the reference inventory calculation result stored in the reference inventory calculation result storage unit 15.

  The analysis / correction reason storage unit 19 stores an analysis / correction reason registration table 191 in which information related to the analysis / correction reason of the reference stock calculated by the reference stock calculation processing unit 14 is registered. FIG. 8 is a diagram showing an example of registration items in the analysis / modification reason registration table 191 shown in FIG. In FIG. 8, as registered items in the analysis / correction reason registration table 191, the product name for identifying the product is registered, and the analysis result of the standard stock quantity of the product indicated by the product name registered in the product name. Analysis / correction reason for which the reason for correction is registered, the number of changes for which the number of changes in the standard stock number of the product indicated by the product registered in the product name is registered, the base stock for the product indicated by the product name registered in the product name The person in charge of the person who has changed the number is registered, and the date when the reference stock quantity of the product indicated by the product registered in the product name is changed is listed.

  Next, the operation of the production / inventory management system to which the reference stock management apparatus 1 according to the present invention is applied will be described. The operation of the production / inventory management system is divided into a registration process for registering various parameters in the standard inventory management apparatus 1 and a standard inventory calculation / approval process for calculating / approving the standard inventory quantity.

  First, the operation of the registration process of the production / inventory management system will be described with reference to the flowchart of FIG. This registration process is executed when the person in charge of inventory management (the person in charge of inventory management) in the production / inventory management system accesses the reference inventory management apparatus 1 using the terminal 5 and selects the parameter registration process. Here, it is assumed that the person in charge of inventory management accesses the reference inventory management apparatus 1 using the terminal 5-1.

  Upon receiving access from the terminal 5-1, the user authentication unit 181 of the reference inventory management device 1 executes user authentication processing for determining whether or not the user requesting access is a user registered in advance. (Step S100).

  For example, the inventory operation manager inputs authentication information such as a user name and a password to the terminal 5-1, and the terminal 5-1 transmits the input authentication information to the reference inventory management apparatus 1. The user authentication unit 181 of the reference inventory management device 1 compares the received authentication information with one or more authentication information registered in advance in itself, and the authentication information included in the authentication information response is registered in advance 1 It is determined whether or not any of the plurality of authentication information matches. When the authentication information included in the authentication information response matches any one of a plurality of authentication information registered in advance in the authentication information response, the user authentication unit 181 responds to the inventory management person using the terminal 5-1. If access to the reference inventory management device 1 is permitted and the authentication information included in the authentication information response does not match any of one to a plurality of authentication information registered in advance, the terminal 5-1 is used. The authentication information is requested from the terminal 5-1 without permitting the person in charge of inventory management to access the reference inventory management apparatus 1.

  When access to the reference inventory management device 1 is permitted by the user authentication unit 181, the inventory manager inputs to the terminal 5-1 to set various parameters, and the terminal 5-1 sets various parameters. The request is transmitted to the reference inventory management device 1.

  Upon receiving various parameter setting requests from the terminal 5-1, the registration unit 182 of the reference inventory management device 1 transmits a parameter value request including parameter value request display screen information for requesting various parameter values to the terminal 5-1. To do. Here, the various parameters are parameters used for calculation of the standard inventory quantity (cycle, data extraction period, required delivery date, abnormal value determination period, variation determination value, and shipping plan accuracy period), and parameters used for warning transmission processing (Ratio threshold value, required delivery date compliance rate upper limit value, and required delivery date compliance rate lower limit value).

  The terminal 5-1 displays on the display means a display screen for requesting various parameters based on the parameter value request display screen information. The inventory management operator inputs various parameter values according to the display screen. Here, the inventory management operator determines the value of the cycle, the value of the data extraction period, the number of days required for delivery, the value of the abnormal value determination period immediately after product release (immediately after abnormal value determination period) (the start date and end date of the period) ), Abnormal value determination period (immediate previous abnormal value determination period) value (period start date and end date) immediately before the sale of the product, variation determination value, shipment plan accuracy period value, ratio threshold value, request Enter the value for the upper limit of the delivery date compliance rate and the value for the lower limit of the required delivery date compliance rate. The terminal 5-1 transmits a parameter setting value response including the value of the parameter associated with the input various parameters to the reference inventory management device 1.

  The registration unit 182 of the reference stock management apparatus 1 extracts various parameters for calculating the reference stock included in the parameter set value response, and registers the extracted various parameters in the parameter storage unit 13 (step S101). Here, the registration unit 182 determines the value of the cycle, the value of the data extraction period, the value of the requested delivery date, the value of the immediately following abnormal value determination period, the value of the immediately preceding abnormal value determination period, the value of the variation determination value, the shipping plan accuracy The value of the period is registered in the parameter storage unit 13.

  The registration unit 182 extracts various parameters (warning transmission reference value) related to warning transmission included in the parameter setting value response, and registers the extracted warning transmission reference value in the warning transmission reference value storage unit 16 (step S102). Here, since the ratio threshold value, the required delivery date compliance rate upper limit value, and the requested delivery date compliance rate lower limit value are used as the warning transmission reference value, the registration unit 182 has the ratio threshold value, the requested delivery date compliance rate upper limit value, The value of the required delivery date compliance rate lower limit value is registered in the warning transmission reference value storage unit 16.

  Here, in order to simplify the explanation, the description has been made assuming that the values of the various parameters are one, but the values of the various parameters may be set for each product.

  Next, the operation of the reference stock calculation / approval process of the production / stock management system will be described with reference to the flowchart of FIG. Here, it is assumed that the person in charge of inventory operation accesses the reference inventory management apparatus 1 using the terminal 5-1, and the person in charge of the product accesses the reference inventory management apparatus 1 using the terminal 5-2. In addition, data relating to each registration item of the product information master 101, the daily production result data table 111, the monthly production result data table 112, the order result data table 113, and the statistical data table is registered in advance by the production plan management device 7. It shall be.

  This reference inventory calculation / approval process is executed for each cycle registered in the parameter storage unit 13. This cycle may be measured by a time measuring function in an apparatus (not shown).

  When the execution time of the reference inventory calculation / approval process is reached, the reference inventory calculation processing unit 14 executes the reference inventory calculation process for calculating the inventory of each product registered in the product information master 101 (step S200). The detailed operation of the reference inventory calculation process will be described with reference to the flowchart of FIG.

  The out-of-stock date specification processing unit 141 selects one of the unprocessed product names as the processing target product from the product names registered in the product name of the product information master 101 (step S300). The out-of-stock date processing unit 141 determines the date (out-of-stock date) on which an order that is delayed in delivery date has occurred based on the order results in the data extraction period for the processing target product based on the data extraction period, the required delivery date, and the order result data table 113. Extract (step S301).

  Specifically, the out-of-stock date specification processing unit 141 matches the product name registered in the product name of the order record data table 113 with the product name of the processing target product, and the order record data table associated with the product name. All the combinations of the delivery date satisfying the condition that the date (delivery date) registered in the delivery date 113 is within the data extraction period and the date (actual delivery date) registered in the state of the order record data table 113 are extracted.

  The out-of-stock date processing unit 141 compares the delivery date with the actual delivery date for each of the extracted sets, and if the actual delivery date has passed the date of adding the requested delivery date, the delivery date. The date is determined to be an out-of-stock date, and if the actual delivery date is within the date obtained by adding the requested delivery date, the delivery date is determined not to be an out-of-stock date. In other words, a delivery delay that exceeds the required delivery date from the delivery date is determined to be a delivery delay due to lack of inventory, and a delivery delay within the requested delivery date from the delivery date is not a delivery delay due to inventory shortage. It is determined that the delivery date is delayed due to the problem of the inventory placement in the case of a product that places the stock on. The out-of-stock date processing unit 141 notifies the abnormal value exclusion processing unit 142 of the out-of-stock date.

  The abnormal value exclusion processing unit 142 excludes the out-of-stock date from the daily inventory results of the data extraction period regarding the processing target product based on the data extraction period, the out-of-stock date, and the daily production result data table 111 (step S302).

  Specifically, the abnormal value exclusion processing unit 142 sets a combination of each date of the data extraction period and the number of stocks on the day indicated by the date as the daily stock record, and excludes the out-of-stock date from the daily stock record. That is, the abnormal value exclusion processing unit 142 determines that the date of the daily production result data table 111 is within the data extraction period and the product name registered in the product name of the order result data table 113 is the product name of the processing target product. The inventory quantity registered in the inventory quantity of the daily production performance data table 111 that satisfies the condition of matching with each other is acquired for each date. The abnormal value exclusion processing unit 142 excludes the daily stock performance on the out-of-stock date from the daily stock performance that is a set of each acquired date and the stock quantity on that date.

  The abnormal value exclusion processing unit 142 excludes the abnormal actual result date from the daily inventory results excluding the out-of-stock date in the data extraction period based on the immediately subsequent abnormal value determination period, the immediately previous abnormal value determination period, and the variation determination value (step S303).

  The abnormal value exclusion processing unit 142 sets the date in the immediately following abnormal value determination period and the previous abnormal value determination period as the abnormal actual result date, and excludes the abnormal actual result date and the number of stocks on the abnormal actual result date from the daily inventory actual results. To do.

  Further, the abnormal value exclusion processing unit 142 calculates the variation in demand of the product from the daily inventory actual shipment number excluding the out-of-stock date in the data extraction period of the daily production actual data table 111 stored in the actual data storage unit 11. Calculate with standard deviation. The abnormal value exclusion processing unit 142 compares the calculated standard deviation with the variation determination threshold, sets the date when the calculated standard deviation is equal to or greater than the variation determination threshold as an abnormal actual date, and stores the abnormal actual date and the inventory of the abnormal actual date. The number is excluded from the daily inventory results.

  The limit stock extraction unit 143 extracts the data regarding the processing target product from the minimum number of stocks, that is, the daily production results data table 111, from the stock numbers of other stock results from which the abnormal result date is excluded by the abnormal value exclusion processing unit 142. The minimum value of the daily inventory results obtained by excluding the stock numbers of out-of-stock dates and abnormal performance dates from the daily inventory results indicating the daily inventory numbers within the period is extracted as the limit inventory (step S304).

  FIG. 12 shows the daily inventory results (daily inventory quantity) extracted from the daily production result data table 111 when the data extraction period is “10 days” and the product name “A” is selected as the processing target product. It is a figure which shows quantity. In FIG. 12, the current date is April 11, and the stock quantity and out-of-stock quantity for the past 10 days (from April 1 to April 10) from the previous day are shown. The stock quantity on April 1 is “1000”, out of stock quantity is “0”, stock quantity on April 2 is “800”, out of stock quantity is “0”, stock quantity on April 3 is “900”, out of stock quantity is “0”, 4 The stock quantity on April 4 is “700”, the stock quantity is “0”, the stock quantity on April 5 is “500”, the stock quantity is “10”, and the stock quantity on April 6 is “450”. The quantity is “20”, the inventory quantity on April 7 is “400”, the quantity out of stock is “30”, the quantity in stock on April 8 is “600”, the quantity is out of stock “0”, the inventory on April 9 The quantity is “700”, the out-of-stock quantity is “0”, the stock quantity on April 10 is “750”, and the out-of-stock quantity is “0”. Here, the out-of-stock quantity is not “0”, and April 5 to April 7 is the out-of-stock date, and the out-of-stock date processing unit 141 excludes abnormal values with April 5 to April 7 as the out-of-stock date. Notify the processing unit 142.

  FIG. 13 is a graph showing the daily inventory quantity shown in FIG. In FIG. 13, since there is no abnormal result date, the abnormal value exclusion processing unit 142 excludes only the number of stocks on the out-of-stock date from the daily stock results. That is, April 1 to April 10 to April 5 to April 7 are excluded. Then, the limit inventory extraction unit 143 has the inventory numbers “1000”, “800”, “900”, “700”, “600” from April 1 to April 4, April 8 to April 10. , “700”, “750”, and “600” that is the minimum value is extracted as the limit inventory.

  Returning to FIG. 11, the shipment calculation accuracy inventory unit 144 determines the monthly shipment plan of the shipment plan accuracy period for the processing target product based on the shipment plan accuracy period, the plan data table 121, and the monthly production result data table 112. The shipping plan accuracy is calculated from the monthly shipping results (step S305).

  Specifically, the inventory calculation unit 144 for the shipping plan accuracy is the within the shipping plan accuracy period from the number of shipment plans associated with the product name in the plan data table 121 in which the product name that matches the processing target product is registered. Get the number of planned shipments per month. The shipment plan accuracy inventory calculation unit 144 selects the number of shipments associated with the product name in the monthly production performance data table 112 in which the product name that matches the processing target product is registered, for each month within the shipment plan accuracy period. Get the number of shipments.

The shipment calculation accuracy part inventory calculation unit 144 calculates a monthly average shipment plan accuracy. The average monthly shipping plan accuracy is set to X months as the monthly shipping plan accuracy period, Y1, Y2,..., Yx (x = X) as the number of monthly shipments, Z1, Z2,.・ ・ Assuming Zx,
Monthly average shipping plan accuracy = ((| Monthly shipping plan-Monthly shipping results |) / Monthly shipping results) Average shipping plan accuracy period = (((| Y1-Z1 | / Z1) + (| Y2-Z2 | / Z2) + ... + | Yx-Zx | / Zx)) / X ... Formula (1)
Can be obtained.

  The shipment calculation accuracy-based inventory calculation unit 144 calculates the average value of monthly shipments (monthly average shipment results) during the shipment plan accuracy period, and calculates the monthly average shipment plan accuracy calculated by the above formula (1) by month. The inventory for the planned accuracy is calculated by multiplying the average shipment results (step S306).

  FIG. 14 is a diagram showing a monthly shipment plan, a monthly shipment result, a plan accuracy and an average value of each month of the processing target product “A” when the shipment plan accuracy period is 6 months. In FIG. 14, the monthly shipment plan is the number of monthly shipments acquired from the plan data table 121, the monthly shipment result is the number of monthly shipments acquired from the monthly production result data table 112, and the plan accuracy is This is the monthly plan accuracy. The plan accuracy is a value obtained by “(| monthly shipment plan for the month-monthly shipment result for the month | month // monthly shipment result for the month”). Moreover, since the monthly average shipment result is 2550 units and the monthly average shipment plan accuracy is 11.3%, the inventory for the planned accuracy is “2550 (units) × 11.3 (%) = 289 (units). ing.

  The reference stock calculation unit 145 calculates the reference stock of the processing target product by adding the planned accuracy part stock calculated by the shipping plan precision part stock calculation part 144 to the limit stock extracted by the limit stock extraction part 143 (step S307). ).

  As described above with reference to FIGS. 12 and 13, the limit inventory extracted by the limit inventory extraction unit 143 is 600 units, and the planned accuracy amount inventory calculated by the shipment plan accuracy amount inventory calculation unit 144 is 289 units. It is. Therefore, the reference stock of the processing target product “A” is “600 (units) +289 (units) = 889 (units)”.

  The reference stock calculation unit 145 registers the calculated reference stock in the reference stock calculation result storage unit 15. Specifically, the reference stock calculation unit 145 acquires the current reference stock number associated with the product name of the reference stock calculation result (see FIG. 7) stored in the reference stock calculation result storage unit 15 that matches the processing target product. Then, the acquired current reference stock quantity is registered as the previous reference stock quantity of the reference stock calculation result, and the approval flag is turned off (in this case, “0”). Also, the calculated reference stock is registered in the current reference stock number.

  As described above, the out-of-stock date specifying processing unit 141 selects an unprocessed product name as a processing target product from the product names registered in the product information master 101, extracts the out-of-stock date, and the abnormal value exclusion processing unit 142 The out-of-stock date and the abnormal actual date are excluded from the daily inventory results within the data extraction period, and the marginal inventory extraction unit 143 extracts the limited inventory from the daily inventory results excluding the out-of-stock date and the abnormal actual date, and the shipping plan accuracy The partial inventory calculation unit 144 calculates the shipment planned accuracy inventory, and the reference stock calculation unit 145 repeats the operation of calculating the reference inventory from the limit inventory and the shipment plan accuracy inventory until there is no unprocessed product (step S300 to S308).

  Returning to FIG. 10, when the reference stock calculation process is completed, the warning transmission processing unit 183 sets the product to which a warning should be transmitted based on the warning transmission reference value registered in the warning transmission reference value storage unit 16 (the warning transmission reference value). (Applicable product) is extracted (step S201).

For example, the following conditions (1) to (3) are used as the extraction conditions for products to be alerted.
Condition (1) When the ratio of the absolute value of the difference between the current reference inventory quantity and the previous reference inventory quantity to the current reference inventory quantity is greater than or equal to the ratio threshold condition (2) The required delivery date compliance rate is less than or equal to the required delivery date compliance rate lower limit value When the current standard inventory quantity is less than or equal to the previous standard inventory quantity (3) The required delivery date compliance rate is greater than or equal to the upper limit of the required delivery date compliance rate and the current reference inventory quantity is greater than or equal to the previous reference inventory quantity

  When determining the condition (1), the warning transmission processing unit 183 selects an unprocessed product name as a processing target product from the product names of the reference inventory calculation results stored in the reference inventory calculation result storage unit 15. . The warning transmission processing unit 183 acquires the current reference stock number and the previous reference stock number registered in the current reference stock number and the previous reference stock number of the reference stock calculation result in association with the processing target product. The warning transmission processing unit 183 obtains the absolute value of the difference between the acquired current reference inventory quantity and the previous reference inventory quantity, and divides the absolute value of this difference by the current reference inventory quantity to the current reference inventory quantity. And calculate the ratio of the difference between the previous reference stock quantity. The warning transmission processing unit 183 compares the obtained ratio with the ratio threshold stored in the warning transmission reference value storage unit 16, and determines that the processing target product is the warning transmission target product when the calculated ratio is equal to or greater than the ratio threshold. If the calculated ratio is smaller than the ratio threshold, the product to be processed is determined to be a product not subject to warning transmission. The warning transmission processing unit 183 repeats the determination operation of the above condition (1) until there is no unprocessed product name among the product names of the reference stock calculation result stored in the reference stock calculation result storage unit 15.

  When performing the determination of the condition (2), the warning transmission processing unit 183 selects an unprocessed product name as a processing target product from the product names of the reference stock calculation results stored in the reference stock calculation result storage unit 15. . The warning transmission processing unit 183 registers the product name registered in the product name of the order record data table 113 with the product name of the processing target product and is registered in the delivery date of the order record data table 113 associated with the product name. All combinations of the delivery date satisfying the condition that the date (delivery date) is within the data extraction period and the date (actual delivery date) registered in the state of the order record data table 113 are extracted.

  The warning transmission processing unit 183 compares the delivery date with the actual delivery date for each of the extracted sets to determine whether or not the product has been delivered within the delivery date. You may make it determine with the delay in the request delivery date elapsed days memorize | stored in the parameter memory | storage part 13 having been delivered within the delivery date. The warning transmission processing unit 183 obtains the ratio of the number delivered within the delivery date (required delivery date compliance rate) to the number of all the extracted sets. The warning transmission processing unit 183 compares the calculated required delivery date compliance rate with the required delivery date compliance rate lower limit value stored in the warning transmission reference value storage unit 16.

  When the required delivery date compliance rate is less than or equal to the required delivery date compliance rate lower limit value, the warning transmission processing unit 183 includes the current reference stock number associated with the processing target product of the reference stock calculation result stored in the reference stock calculation result storage unit 15 and The previous reference inventory quantity is acquired, and the acquired current reference inventory quantity is compared with the previous reference inventory quantity. The warning transmission processing unit 183 determines that the product to be processed is a warning transmission target product when the current reference stock quantity is less than or equal to the previous reference stock quantity, and if the current reference stock quantity is larger than the previous reference stock quantity or the required delivery date is observed. If the rate is larger than the required delivery date compliance rate lower limit value, the product to be processed is determined to be a product not subject to warning transmission. The warning transmission processing unit 183 repeats the determination operation of the condition (2) until there is no unprocessed product name among the product names of the reference stock calculation result stored in the reference stock calculation result storage unit 15.

  When the condition (3) is determined, the warning transmission processing unit 183 selects an unprocessed product name as a processing target product from the product names of the reference inventory calculation results stored in the reference inventory calculation result storage unit 15. . The warning transmission processing unit 183 registers the product name registered in the product name of the order record data table 113 with the product name of the processing target product and is registered in the delivery date of the order record data table 113 associated with the product name. All combinations of the delivery date satisfying the condition that the date (delivery date) is within the data extraction period and the date (actual delivery date) registered in the state of the order record data table 113 are extracted.

  The warning transmission processing unit 183 compares the delivery date with the actual delivery date for each of the extracted sets to determine whether or not the product has been delivered within the delivery date. You may make it determine with the delay in the request delivery date elapsed days memorize | stored in the parameter memory | storage part 13 having been delivered within the delivery date. The warning transmission processing unit 183 obtains the ratio of the number delivered within the delivery date (required delivery date compliance rate) to the number of all the extracted sets. The warning transmission processing unit 183 compares the calculated required delivery date compliance rate with the required delivery date compliance rate upper limit value stored in the warning transmission reference value storage unit 16.

  When the required delivery date compliance rate is equal to or higher than the required delivery date compliance rate upper limit value, the warning transmission processing unit 183 includes the current reference stock number associated with the processing target product of the reference stock calculation result stored in the reference stock calculation result storage unit 15 and The previous reference inventory quantity is acquired, and the acquired current reference inventory quantity is compared with the previous reference inventory quantity. The warning transmission processing unit 183 determines that the processing target product is a warning transmission target product when the current reference stock number is greater than or equal to the previous reference stock number, and if the current reference stock number is smaller than the previous reference stock number or the required delivery date is observed If the rate is smaller than the required delivery date compliance rate upper limit value, the product to be processed is determined to be a product not subject to warning transmission. The warning transmission processing unit 183 repeats the determination operation of the condition (3) until there is no unprocessed product name among the product names of the reference stock calculation result stored in the reference stock calculation result storage unit 15.

  Note that the required delivery date compliance rate in the determination of the above conditions (2) and (3) is calculated by the out-of-stock date specification processing unit 141 in the reference stock calculation processing described in the flowchart of FIG. 11 above. You may make it carry out by the process of the comparison of the delivery date performed at the time, and an actual delivery date. In this case, the required delivery date compliance rate is registered in association with the product name of the reference stock calculation result stored in the reference stock calculation result storage unit 15. Then, the warning transmission processing unit 183 acquires the required delivery date compliance rate registered in the required delivery date compliance rate of the reference inventory calculation result, and acquires the obtained requested delivery date compliance rate and the required delivery date compliance rate lower limit value or the requested delivery date compliance rate upper limit value. Should be compared.

  When a warning transmission target product is extracted by at least one determination of the above conditions (1) to (3) (step S202, Yes), the warning transmission processing unit 183 extracts the warning transmission target product and the product information master. A warning mail is transmitted to the person in charge based on the product information master 101 stored in the storage unit 10 (step S203).

  Specifically, the warning transmission processing unit 183 extracts a product name that matches the warning transmission target product from the product names registered in the product name of the product information master 101 table, and associates the product name with the extracted product name. Get the email address registered in the person in charge address. The warning transmission processing unit 183 transmits a warning mail indicating that the reference inventory number needs to be reviewed to the acquired mail address. Thereafter, the reference inventory management device 1 waits for access from the terminal 5 (step S204).

  The person in charge receives the warning mail using the terminal 5-2, and recognizes that the reference stock needs to be reviewed by the warning mail. The person in charge accesses the reference inventory management apparatus 1 using the terminal 5-2.

  When the access from the terminal 5-2 is received (step S204, Yes), the user authentication unit 181 of the reference inventory management apparatus 1 determines whether or not the user requesting access is a user registered in advance. User authentication processing is executed (step S205). The user authentication process is substantially the same as the operation in step S100 of the registration process of the production / inventory management system described with reference to the flowchart of FIG. 9, and the difference is whether the accessing user is the inventory manager. Since it is to determine whether the person is in charge, the description thereof is omitted here.

  If it is determined that the access is from the person in charge (step S206, Yes), the user authentication unit 181 notifies the calculation result analysis / correction processing unit 184 that the access is from the person in charge. The calculation result analysis / correction processing unit 184 generates analysis / correction screen display information for displaying a screen for inputting the reference stock calculation result and the analysis correction reason stored in the reference stock calculation result storage unit 15 to generate the terminal 5-2. (Step S207).

  The terminal 5-2 displays a screen for inputting a reference inventory calculation result and an analysis / correction reason based on the received analysis / correction screen display information. The person in charge inputs the name of the product to be corrected, the person in charge, the correction value of the reference stock quantity, and the analysis / correction reason according to this screen. The terminal 5-2 transmits the inputted product name, the person in charge, the correction value of the reference stock quantity, and the correction information including the analysis / correction reason to the reference stock management apparatus 1.

  The calculation result analysis / correction processing unit 184 of the reference inventory management apparatus 1 registers the correction value and the correction reason for the reference inventory in the analysis / correction reason registration table 191 (step S208). Specifically, the calculation result analysis / correction processing unit 184 stores the product name, the person in charge, the correction value of the reference stock quantity, and the analysis / correction reason included in the correction information in the analysis / correction reason storage unit 19. The product name, person in charge, number of changes, and reason for analysis correction are registered in the analysis / correction reason registration table 191. Further, the calculation result analysis / correction processing unit 184 acquires the current date and time by a timekeeping function (not shown) in the apparatus, and registers the acquired current date and time in the date of the analysis / correction reason registration table 191.

  Also, the calculation result analysis / correction processing unit 184 registers the corrected reference stock number in the reference stock calculation result storage unit 15 (step S209). Specifically, the calculation result analysis / correction processing unit 184 sets the reference inventory number included in the correction information to the current reference inventory number of the reference inventory calculation result associated with the product name that matches the product name included in the correction information. Register the correction value.

  At a predetermined timing, the approval unit 185 transmits an approval request mail notifying that the approval of the reference stock is requested to the inventory management person (step S210). The predetermined timing is, for example, after a predetermined time has elapsed since the warning mail is transmitted, or after all corrections to the product that has transmitted the warning mail have been completed. Thereafter, the reference inventory management device 1 waits for access from the terminal 5 (step S204).

  The reference inventory management manager receives the approval request mail using the terminal 5-1, and recognizes that there is a reference stock to be approved by the approval request mail. The reference stock management manager accesses the reference stock management apparatus 1 using the terminal 5-1.

  Upon receiving access from the terminal 5-1 (step S <b> 204, Yes), the user authentication unit 181 of the reference inventory management device 1 determines whether or not the user requesting access is a user registered in advance. User authentication processing is executed (step S205). When it is determined that the access is from the reference inventory management person (No in step S206), the user authentication unit 181 notifies the approval unit 185 that the access is from the reference inventory management person.

  The approval unit 185 registers the reference stock calculation result stored in the reference stock calculation result storage unit 15 and the registration contents of the analysis / correction reason registration table 191 stored in the analysis / correction reason storage unit 19 and the reference stock calculation result. Approval screen display information for displaying a screen requesting approval of the current reference stock quantity is generated and transmitted to the terminal 5-1 (step S211).

  Based on the approval screen display information, the terminal 5-1 displays a screen for requesting approval of the reference stock calculation result and the registration contents of the analysis / correction reason registration table 191 and the current reference stock number registered in the reference stock calculation result. To do. The reference stock management manager confirms the reference stock calculation result displayed on the terminal 5-1 and the registered contents of the analysis / correction reason registration table 191, and inputs approval information for each product using the input means. The terminal 5-1 transmits the approval information associated with the product name to the reference inventory management device 1.

  The approval unit 185 of the reference inventory management device 1 registers approval information in the reference inventory calculation result storage unit 15 (step S212). Specifically, when the approval information indicates that the current reference stock quantity of the product is approved, the approval unit 185 is associated with the product name of the reference stock calculation result stored in the reference stock calculation result storage unit 15. Turn on the approval flag.

  The approval unit 185 determines whether or not all the approval flags for the reference stock calculation results are turned on, that is, whether or not all the current reference stock numbers for the reference stock calculation results have been approved (step S213). When all the current reference stock numbers of the reference stock calculation result are not approved (No in step S213), the approval unit 185 notifies the warning transmission processing unit 183 to that effect, and the warning transmission processing unit 183 is approved. A warning mail is transmitted to the person in charge of the product not present in the same manner as in step S203. Thereafter, the reference stock management apparatus 1 returns to step S204 and repeats the operations of steps S204 to S213 until all the current reference stock numbers of the reference stock calculation results are approved.

  When all the current reference inventory numbers of the reference inventory calculation result are approved (step S213, Yes), the approval unit 185 adds the product name of the reference inventory calculation result stored in the reference inventory calculation result storage unit 15 and this product name. Using the associated current reference stock quantity as a set, the production plan management apparatus 7 is notified of the current reference stock quantity of each product (step S214).

  On the other hand, if the warning transmission target product is not extracted by any of the determinations of the above conditions (1) to (3) (step S202, No), the warning transmission processing unit 183 indicates that there is no warning transmission target product. Is notified to the approval unit 185. The approval unit 185 transmits an approval request mail for notifying that the approval of the reference stock is requested to the inventory management person (step S215). Thereafter, the reference inventory management device 1 waits for access from the terminal 5 and executes the operations of steps S204 to S214 described above to store the reference inventory of each product approved by the inventory management manager in the production plan management device 7. Notice.

  The production plan management device 7 manages production plans and results based on the reference stock of each product notified from the reference stock management device 1.

  As described above, in this embodiment, the actual data storage unit 11 includes the daily production actual data table 111 in which the number of shipments, the number of inventory, and the number of production of each product are registered for each date, A monthly production result data table 112 in which the number of shipments, the number of stocks, and the number of productions of each product are registered, and an order result data table 113 in which the delivery date at the time of ordering the product and the actual delivery date when delivery is completed are registered. The plan data storage unit 12 stores a plan data table 121 in which the number of shipment plans per month is registered for each product. The out-of-stock date processing unit 141 determines the delivery date when the delivery date in the order record data table 113 is within a predetermined data extraction period and the actual delivery date associated with the delivery date has passed the delivery date. The abnormal value exclusion processing unit 142 specifies an abnormal performance date based on a predetermined abnormality determination condition, and the out-of-stock specified by the specified abnormal actual date and out-of-stock specification processing unit 141 is specified. The marginal inventory extraction unit 143 excludes the day from the data extraction period, and the abnormal stock removal processing unit 142 causes the daily production result data table 111 associated with the date in the data extraction period from which the abnormal result date and the out-of-stock date are excluded. The minimum stock quantity in the stock quantity of the product is extracted as the limit stock quantity of the product. Based on the number of shipment plans per month in the plan data table 121 for a predetermined shipment schedule accuracy period and the number of shipments per month in the monthly production performance data, the shipment calculation accuracy share inventory calculation unit 144 The average of the shipping plan accuracy period, which is the value obtained by dividing the absolute value of the difference between the number of shipments and the number of shipments per month by the number of shipments by month, is calculated as the monthly average shipment plan accuracy. The inventory quantity for the planned accuracy is calculated by multiplying the monthly average shipment results, which is the average value of the monthly shipment numbers in the monthly production result data table 112 for the period. The reference stock calculation unit 145 calculates the reference stock by adding the planned stock for the planned accuracy calculated by the shipping plan accuracy stock calculation unit 144 to the limited stock number extracted by the limit stock extraction unit 143. This makes it possible to obtain, for each product, a reference stock that does not cause excessive stock or out of stock in a mass-produced product that performs prospective production, without depending on the experience and ability of the person in charge.

  In this embodiment, the parameter used for the abnormality determination condition is an abnormal value determination period immediately after the start-up period of the new product, an immediately previous abnormal value determination period that indicates the convergence period of the old product, or variations in the number of products shipped. The abnormal value exclusion processing unit 142 determines that the date within the immediately abnormal value determination period, the date within the immediately previous abnormal value determination period, or the standard deviation of the number of shipments within the data extraction period varies. Since the date exceeding the threshold is set as the abnormal actual date, the limit inventory can be obtained by excluding abnormal values due to the number of stocks in the launch period of new products, the convergence period of old products, and fluctuations in demand, A highly accurate standard stock can be obtained.

  Furthermore, in this embodiment, the out-of-stock date specification processing unit 141 is configured to set the delivery date as the out-of-stock date when the actual delivery date has passed the date of adding the required delivery date to the delivery date. By excluding the delivery delay due to the problem of inventory placement in the case of products that are stocked in warehouses nationwide, it is possible to identify the original shortage of stock as the out-of-stock date, and to obtain a highly accurate reference stock.

  Furthermore, in this embodiment, the warning transmission processing unit 183 determines the current reference based on the current reference stock calculated by the reference stock calculation unit 145, the previous reference stock calculated immediately before, and the warning transmission condition. Judge whether the product is a warning target product that needs to be reviewed, and if it is determined that the product is a warning target product, issue a warning requesting the person in charge of the product to review the standard stock of the product Since the notification is transmitted, it is possible to review based on the experience and intuition of the person in charge, and it is possible to set a highly accurate reference stock.

  Further, in this embodiment, the warning transmission processing unit 183 has a required delivery date in which the ratio of the difference from the previous reference stock to the current reference stock is equal to or greater than the ratio threshold, and the required delivery date compliance rate of the product is determined in advance. Products whose compliance rate is lower than the lower limit and the current reference stock is lower than the previous reference stock, the required delivery date compliance rate of the product is greater than or equal to the predetermined required delivery date compliance rate upper limit, and the current reference stock is the previous reference Since a product that is over stock is determined to be a warning transmission target product, the required delivery date compliance rate can be considered.

  Further, in this embodiment, the calculation result analysis / correction processing unit 184 uses the reference inventory calculation result including the reference inventory calculated by the reference inventory calculation unit 145 and the reference inventory for the product registered in the reference inventory number calculation result. Display the registered contents of the analysis / correction reason registration table 191 in which the number of analysis / correction reasons and the person in charge of correction are registered, and the reference stock associated with the product name included in the correction information input from the outside by the person in charge The reference stock quantity of the calculation result is changed to the correction value included in the correction information, and the analysis / correction reason and the person in charge of the reference stock quantity for the product included in the correction information are registered in the analysis / correction reason registration table 191. Therefore, it is possible to refer to the reason for analysis / modification of the past standard stock, and even an inexperienced person can easily analyze and modify the standard stock. It can be.

  Further, in this embodiment, the approval unit 185 displays the reference stock calculation result and the registered contents of the analysis / correction reason registration table 191 and performs a workflow for approving the reference stock to the reference stock manager. Therefore, approval of the reference stock can be easily performed.

  Further, in this embodiment, the registration unit 182 stores the cycle input from the outside, the data extraction period for each product, the shipping plan accuracy period, the parameters used for the abnormality determination condition, and the required delivery date elapsed days as the parameter storage unit 13. Since the ratio threshold value for each product, the required delivery date compliance rate lower limit value, and the requested delivery date compliance rate upper limit value are registered in the warning transmission reference value storage unit 16 for each product, From the above, it is possible to individually set parameters for the calculation of the reference stock and the warning transmission.

  In this embodiment, the case where the above conditions (1) to (3) are used as conditions for determining whether or not the product is a warning transmission target product has been described as an example. The conditions for determining whether or not there are are not limited to the conditions (1) to (3). For example, “when the out-of-stock date continues for a predetermined number of consecutive out-of-stock days” or the like may be used as the determination condition.

  In this case, the number of consecutive days out of stock is stored in the warning transmission reference value storage unit 16, and the warning transmission processing unit 183 determines that the product name registered in the product name of the order record data table 113 is the product name of the processing target product. The date of delivery (delivery date) registered in the delivery date of the order record data table 113 that matches and is associated with the product name is registered in the delivery date and order record data table 113 condition that satisfies the condition that it is within the data extraction period. All the combinations of the specified dates (actual delivery date) are extracted.

  The warning transmission processing unit 183 compares the delivery date with the actual delivery date for every extracted set, and if the actual delivery date has passed the date obtained by adding the requested delivery elapsed days, this delivery date. Is determined to be an out-of-stock date, and if the actual delivery date is within the date obtained by adding the required delivery date to the delivery date, this delivery date is determined not to be an out-of-stock date. And when the date judged to be out of stock is continuous, the number of days with the maximum continuous days is extracted. The warning transmission processing unit 183 compares the extracted number of days with the number of consecutive days out of stock, and determines that the product is a warning transmission target product when the extracted number of days is equal to or greater than the number of consecutive days out of stock.

  In addition, the out-of-stock date processing unit 141, the abnormal value exclusion processing unit 142, the limit stock extraction unit 143, the shipping plan accuracy stock calculation unit 144, the reference stock calculation unit 145, the user authentication unit 181 and the registration unit 182 of this embodiment. The above-described functions realized by the warning transmission processing unit 183, the calculation result analysis / correction processing unit 184, and the approval unit 185 may be provided as a reference inventory management program for causing a general-purpose computer to execute the functions. In this case, the standard inventory management program is recorded in a computer-readable recording medium such as a CD-ROM, a floppy (registered trademark) disk, or a DVD in a format that can be installed on a computer or a computer-executable format. To provide. The reference inventory management program recorded on the recording medium is read from the recording medium and executed on the computer.

  In this case, the computer that executes the reference inventory management program includes at least a control device and a storage device. The control device includes an arithmetic processing device such as a CPU for controlling the entire computer and a ROM. The storage device is composed of a general RAM, and is used as a work memory when the reference inventory management program is used. Product information master 101, daily production result data table 111, monthly production result data table 112, order result data table 113, plan data table 121, reference stock calculation result, statistical data table, analysis / correction reason registration table 191, reference stock Various parameters of the calculation and warning transmission conditions are stored in an external storage device accessible by the computer. The control device reads out the reference inventory management program from the recording medium in which the reference inventory management program is recorded and executes it, so that the out-of-stock date identification processing unit 141, the abnormal value exclusion processing unit 142, the limit inventory extraction unit 143, the shipping plan As the above-described functions realized by the accuracy inventory calculation unit 144, the reference inventory calculation unit 145, the user authentication unit 181, the registration unit 182, the warning transmission processing unit 183, the calculation result analysis / correction processing unit 184, and the approval unit 185, Operate the computer.

  As described above, the reference inventory management device according to the present invention is useful when obtaining an appropriate reference inventory for each product that does not cause excessive inventory or out of stock, and in particular, the reference inventory of mass-produced Katsura products that perform prospective production. Suitable when seeking.

It is a figure which shows an example of a structure of the production and inventory management system to which the reference | standard inventory management apparatus in this invention is applied. It is a figure which shows an example of the registration item registered into the product information master shown in FIG. It is a figure which shows an example of the registration item registered into the daily production performance data table shown in FIG. It is a figure which shows an example of the registration item registered into the monthly production performance data table shown in FIG. It is a figure which shows an example of the registration item registered into the order performance data table shown in FIG. It is a figure which shows an example of the registration item registered into the plan data table shown in FIG. It is a figure which shows an example of the registration item of the reference stock calculation result memorize | stored in the reference stock calculation result storage part shown in FIG. It is a figure which shows an example of the registration item of the analysis and correction reason registration table shown in FIG. It is a flowchart for demonstrating operation | movement of the registration process of a production / inventory management system. It is a flowchart for demonstrating operation | movement of the reference | standard inventory calculation and approval process of a production / inventory management system. It is a flowchart for demonstrating the detailed operation | movement of the reference | standard inventory calculation process of the flowchart of FIG. It is a figure for demonstrating the operation | movement of a reference | standard inventory calculation process. It is a figure for demonstrating the operation | movement of a reference | standard inventory calculation process. It is a figure for demonstrating the operation | movement of a reference | standard inventory calculation process.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Standard inventory management apparatus 3 Network 5-1 and 5-2 Terminal 7 Production plan management apparatus 10 Product information master memory | storage part 11 Performance data memory | storage part 12 Plan data memory | storage part 13 Parameter memory | storage part 14 Reference | standard inventory calculation process part 15 Reference | standard inventory calculation Result storage unit 16 Warning transmission reference value storage unit 17 Statistical data storage unit 18 Workflow processing unit 19 Analysis / correction reason storage unit 101 Product information master 111 Daily production result data table 112 Monthly production result data table 113 Order result data table 121 Plan Data table 141 Out-of-stock date processing unit 142 Abnormal value exclusion processing unit 143 Marginal inventory extraction unit 144 Stock plan accuracy inventory calculation unit 145 Standard inventory calculation unit 181 User authentication unit 182 Registration unit 183 Warning transmission processing unit 184 Calculation analysis / correction Processing unit 185認部 191 analysis and modification reason registration table

Claims (7)

The daily production result data table in which the number of shipments and stock of each product is registered for each date, the monthly production result data table in which the number of shipments and stock of each product is registered for each month, and the product at the time of ordering An actual result data storage unit for storing an order actual result date table in which an actual delivery date and delivery date are registered;
A plan data storage unit for storing a plan data table in which the number of production plans per month is registered for each product;
When the delivery date of the order result data table is within a predetermined data extraction period and the actual delivery date associated with the delivery date has passed the delivery date, the out-of-stock date is specified as the out-of-stock date. A day specific processing section;
An abnormal value exclusion processing unit that identifies an abnormal actual result date based on a predetermined abnormality determination condition, and excludes the specified abnormal actual result date and the out-of-stock date specified by the out-of-stock date processing unit from the data extraction period;
The minimum stock quantity in the stock quantity of the product in the daily production record data table associated with the date within the data extraction period in which the abnormal result date and the out of stock date are excluded by the abnormal value exclusion processing unit A limit inventory extractor that extracts the limit inventory number of
Based on the number of monthly shipments in the plan data table for the predetermined shipping schedule accuracy period and the monthly shipments in the monthly production performance data, the difference between the number of monthly shipments and the number of monthly shipments The average of the shipment plan accuracy period, which is the value obtained by dividing the absolute value by the number of shipments by month, is calculated as the monthly average shipment plan accuracy, and the calculated monthly average shipment plan accuracy is calculated for each month in the monthly production results data table for the shipment plan accuracy period. A shipping plan accuracy inventory calculation unit that calculates the number of planned accuracy inventory by multiplying the monthly average shipment results that are the average value of shipments of
A reference inventory calculation unit that calculates a reference inventory number by adding the planned accuracy amount of inventory calculated by the shipping plan accuracy inventory calculation unit to the limit inventory number extracted by the limit inventory extraction unit;
A standard inventory management device comprising: Parameters used for the abnormality determination condition,
Immediately after the abnormal value determination period indicating the start-up period of the new product, immediately before the abnormal value determination period indicating the convergence period of the old product, or a variation determination threshold value indicating the upper limit of the variation in the number of products shipped,
The abnormal value exclusion processing unit
A date within the immediately following abnormal value determination period, a date within the immediately preceding abnormal value determination period, or a date when the standard deviation of the number of shipments within the data extraction period is equal to or greater than the variation determination threshold,
The reference stock management apparatus according to claim 1. The out-of-stock date processing unit
Specifying the delivery date as an out-of-stock date when the actual delivery date has passed a date obtained by adding a predetermined requested delivery date to the delivery date.
The reference inventory management device according to claim 1, wherein A product information master storage unit that stores a product information master in which the email address of the person in charge of the product is registered for each product;
A reference inventory calculation result storage unit that stores a reference inventory number calculation result in which a reference inventory number calculated by the reference inventory calculation unit and a previously calculated reference inventory number are registered for each product;
It is determined whether the product is a warning transmission target product based on the standard stock number of the calculation result of the standard stock number and the previously calculated standard stock number and a predetermined warning transmission condition, and is determined as a warning transmission target product. A warning transmission processing unit that transmits a warning transmission notification requesting a review of the reference stock quantity of a product determined to be a warning transmission target product to an email address associated with the product and registered in the product information master;
The reference inventory management device according to claim 1, further comprising: The warning transmission processing unit
A product in which a ratio of a difference between the reference stock number calculated by the reference stock calculation unit and the reference stock number calculated last time with respect to the reference stock number calculated by the reference stock calculation unit is equal to or greater than a predetermined ratio threshold, Products for which the required delivery date compliance rate is less than or equal to a predetermined required delivery date compliance rate lower limit value and the reference inventory number calculated by the reference inventory calculation unit is less than or equal to the previously calculated reference inventory number, and the required delivery date compliance rate of the product Is a product that is equal to or greater than a predetermined required delivery deadline compliance rate upper limit and the standard inventory number calculated by the standard inventory calculation unit is equal to or greater than the previously calculated standard inventory number, or is continuously out of stock with a predetermined expiration date Determining that a product that has continued for more than a certain number of days as a product subject to warning transmission;
The reference inventory management device according to claim 4, wherein: An analysis / correction reason storage unit that stores an analysis / correction reason registration table in which the reason for analysis / correction of the reference stock quantity for the product registered in the reference stock quantity calculation result and the person in charge of correction are registered;
The reference inventory number calculation result and the contents of the analysis / correction reason registration table are displayed, and the reference inventory number of the reference inventory calculation result associated with the product name included in the correction information input from the outside is included in the correction information. A calculation result analysis / correction processing unit that registers the analysis / correction reason and the person in charge of the base stock quantity for the product included in the correction information in the analysis / correction reason registration table, as well as changing to a correction value;
The reference inventory calculation result corrected by the calculation result analysis / correction processing unit and the registration contents of the analysis / correction reason registration table are displayed, and the reference of the standard inventory calculation result corrected by the calculation result analysis / correction processing unit An approval department requesting approval of the stock quantity;
The reference inventory management device according to claim 4, further comprising: A parameter storage unit for storing the data extraction period for each product, the shipping plan accuracy period, the parameters used for the abnormality determination condition, and the required delivery date elapsed days;
A warning transmission reference value storage unit for storing the ratio threshold value for each product, the required delivery date compliance rate lower limit value, the requested delivery date compliance rate upper limit value, and the out-of-stock date consecutive days;
The data extraction period for each product input from the outside, the shipping plan accuracy period, the parameters used for the abnormality determination condition, and the required delivery date elapsed days are stored in the parameter storage unit, and each product input from the outside A registration unit that registers the ratio threshold value, the required delivery date compliance rate lower limit value, the required delivery date compliance rate upper limit value, and the out-of-stock date continuous number of days in the warning transmission reference value storage unit;
The reference inventory management device according to claim 5, further comprising:

Images