JP2007269482A - Storage component deciding device, method, and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To properly decide a component to be stored by a worker in charge of maintenance and repair of a product. <P>SOLUTION: ID of a customer engineer (CE) being a worker is obtained. Next, expected values of the number of replacement per component of the CE are calculated based on each of actual record data of component replacement work in the whole nation, actual record data of component replacement work in a region to which the CE belongs, and actual record data of component replacement work of the CE as an individual, and these expected values are integrated to prepare an expected value table of the number of replacement per component of the CE. Next, a component being unsuitable for storage by a component portable means of the CE is removed from the expected value table, and then the number of components to be stored per component is decided. The components storable in the component portable means of the CE are selected by starting from the component having the largest expected value in order, and the number of the selected component and the number of the selected components are prepared as storage component information. <P>COPYRIGHT: (C)2008,JPO&INPIT

Description

  The present invention relates to a storage part determination device that determines a part stored by an operator who performs maintenance, repair, etc. of a product.

A product sold to a customer may be regularly maintained or repaired by a manufacturer of the product.
In that case, for example, a customer engineer (CE) who is in charge of product maintenance / repair visits the customer who has the product, inspects the product, and if necessary, maintenance / repair such as replacement of parts. Do work.

  When a customer visits a customer for maintenance / repair, the CE stores in advance parts that may be replaced in case they need to be replaced. carry.

By the way, in this case, since the size of the carrying means for storing the parts is limited, it is general that all the parts that can be replaced cannot be stored.
For this reason, the CE selects parts that are likely to be replaced based on their own experience, etc., puts them in the carrying means, and stores them for maintenance and repair.
In the field of product production lines, there is an invention that determines the production model and the number of production for each production line based on the replenishment amount for each model, regardless of experience or the like (for example, see Patent Document 1). ).
JP 2004-287623 A

  However, as described above, if the parts to be stored are determined based on experience or the like, for example, inexperienced CEs often cannot perform maintenance / repair with stored parts. As a result, customers often return to the service station (SS) and return to the service station (SS) to visit the customer again, reducing the rate at which maintenance and repair can be completed in a single visit, and maintenance and repair work. Inefficient.

  Even if an experienced CE changes, for example, if the product in charge changes, it is not easy to determine which parts should be stored, and maintenance and repair can be performed with the stored parts. The ratio was low and work efficiency was poor.

  The present invention has been made in view of the above circumstances, and an object thereof is to provide a storage part determination device and the like that can appropriately determine parts stored by an operator who performs maintenance, repair, etc. of a product. And

In order to achieve the above object, a storage part determination device according to a first aspect of the present invention includes:
A storage part determination device for determining a storage part of an operator,
For each part, replacement work number acquisition means for acquiring the replacement work number of the part,
For each part, a part-used product number acquisition means for acquiring the number of products that use the part as a replacement part;
For each part, the operator obtains the number of products in charge for obtaining the number of products in charge of replacement of the parts by the worker;
For each part, based on the number of replacement work acquired by the replacement work number acquisition means, the number of products acquired by the part use product number acquisition means, and the number of products acquired by the responsible product number acquisition means, Expected value obtaining means for obtaining an expected value of the number of replacement work of the parts by the worker;
Storage part information generation means for generating storage part information in which parts up to a predetermined order are selected as storage parts of the operator in descending order of expected values obtained by the expected value acquisition means;
Is provided.

In the storage part determination device,
The expected value acquisition means includes
For each part, (“the number of replacement work acquired by the replacement work number acquisition unit” / “the number of products acquired by the part use product number acquisition unit”) × “the number of products acquired by the product number acquisition unit in charge” ”To find the expected value.
You may do it.

In the storage part determination device,
The replacement work number acquisition means includes:
For each part, in all regions divided into a plurality, the regional replacement work number acquisition means for acquiring the replacement work number of the part,
For each part, the affiliation area replacement work number acquisition means for acquiring the replacement work number of the part in the worker's affiliation area,
The part use product number acquisition means includes:
For each part, in all the regions, the number of products using all parts used to obtain the number of products using the part as a replacement part; and
For each part, it has an affiliated region part use product number acquisition means for acquiring the number of products using the part as a replacement part in the affiliated area,
The expected value acquisition means includes
For each part, the number of replacement work acquired by the all-regional replacement work number acquisition unit, the number of products acquired by the all-regional part use product number acquisition unit, the number of products acquired by the responsible product number acquisition unit, Based on the above, all-region expected value acquisition means for obtaining an expected value based on the work results of all the regions, the number of replacement work of the parts by the worker,
For each part, the number of replacement work acquired by the affiliation area replacement work number acquisition means, the number of products acquired by the affiliation area part use product number acquisition means, the number of products acquired by the assigned product number acquisition means, , Based on the work area, the number of replacement work of the part by the worker, the expected value of the affiliation area to obtain the expected value based on the work results of the affiliation area,
For each part, it has an integrated expected value acquisition unit for obtaining an expected value obtained by integrating the expected value obtained by the all region expected value acquisition unit and the expected value obtained by the belonging region expected value acquisition unit,
You may do it.

In the storage part determination device,
The integrated expected value acquisition means, for each part, adds the expected value obtained by the all region expected value acquisition means and the expected value obtained by the belonging region expected value acquisition means to obtain an integrated expected value,
You may do it.

In the storage part determination device,
The all-region replacement work number acquisition means acquires the number of replacement work cases in the first predetermined period,
The affiliation area exchange work number acquisition means acquires the number of exchange work cases in the second predetermined period,
The all-region parts-used product number acquisition means acquires the number of products in the first predetermined period,
The affiliation area part use product number acquisition means acquires the number of products in the second predetermined period;
You may do it.

In the storage part determination device,
The replacement work number acquisition means includes:
For each part, it has a personal replacement work number acquisition means for acquiring the number of replacement work of the part performed by the worker,
The expected value acquisition means includes
For each part, based on the number of replacement work acquired by the personal replacement work number acquisition means, the personal expectation value acquisition means for obtaining an expected value based on the individual work results of the number of replacement work of the part of the worker ,
The integrated expectation value acquisition means includes, for each part, the expectation value obtained by the all region expectation value acquisition means, the expectation value obtained by the belonging region expectation value acquisition means, and the expectation obtained by the individual expectation value acquisition means. To obtain the expected value that is integrated with the value,
You may do it.

In the storage part determination device,
The individual replacement work number acquisition means acquires the number of replacement work cases in a third predetermined period for each part,
The individual expected value acquisition means performs an operation of “the number of replacement work acquired by the personal replacement work number acquisition means” / “the third predetermined period” for each part to obtain an expected value.
You may do it.

In addition, the storage part determination method according to the second aspect of the present invention includes:
A storage part determination method for determining a storage part of an operator,
For each part, a replacement work number recording step for recording the number of replacement work of the part in the storage unit,
For each part, a part use product number recording step of recording the number of products using the part as a replacement part in the storage unit;
For each part, the number of products for which the operator is responsible for replacement of the part is recorded in the storage unit, the number of products in charge recording step,
For each part, from the storage unit, the number of replacement work recorded in the replacement work number recording step, the number of products recorded in the part use product number recording step, and the number of products recorded in the responsible product number recording step. And an expected value acquisition step for obtaining an expected value of the number of replacement work of the part by the worker based on the read information;
A storage part information generation step for generating storage part information in which parts up to a predetermined order are selected as storage parts of the operator in descending order of the expected value obtained in the expected value acquisition step;
Is provided.

A program according to the third aspect of the present invention is:
Computer
Replacement work number acquisition means for acquiring the replacement work number of the part for each part,
For each part, a part use product number acquisition means for acquiring the number of products using the part as a replacement part,
For each part, the number of products in charge for the operator to obtain the number of products in charge of replacement of the part,
For each part, based on the number of replacement work acquired by the replacement work number acquisition means, the number of products acquired by the part use product number acquisition means, and the number of products acquired by the responsible product number acquisition means, An expected value obtaining means for obtaining an expected value of the number of replacement work of the parts by the worker;
Storage part information generation means for generating storage part information in which parts up to a predetermined order are selected as storage parts of the operator in descending order of expected values obtained by the expected value acquisition means,
To function as.

  According to the present invention, it is possible to appropriately determine parts to be stored by an operator who performs maintenance / repair of a product.

Hereinafter, embodiments of the present invention will be described with reference to the drawings.
In this embodiment, when a customer engineer (hereinafter referred to as CE) stores parts in advance in a car, a car, etc., which is a part carrying means when visiting a customer for product maintenance / repair. As an example, a storage part determination system including a storage part determination apparatus as a component will be described.

FIG. 1 is a block diagram showing a configuration example of a storage component determination system according to an embodiment of the present invention.
As shown in the figure, the storage component determination system includes a storage component determination device 1 and a plurality of SS (service station) terminals 2. The storage component determination device 1 and the SS terminal 2 are connected via a communication network 3. It is connected.

  The storage part determination apparatus 1 is an apparatus that determines a part to be stored by a CE that performs maintenance and repair work on a product. Specifically, the storage component determination apparatus 1 determines, as storage component information, a part number that is identification information of a component to be stored and a storage number for each component for each CE.

  The SS terminal 2 is a terminal device installed in a service station (hereinafter referred to as SS) to which the CE belongs. As the SS terminal 2, a general personal computer having a communication function can be used. A plurality of SSs are provided throughout the country, and a plurality of CEs belong to each SS. Each SS is assigned a jurisdiction.

  When the CE wants to know the parts to be stored for maintenance / repair, the ID (CEID) that is the identification information of the CE is input to the SS terminal 2 provided in the SS to which the CE belongs. The SS terminal 2 transmits the input CEID to the storage component determination device 1 and receives and displays storage component information corresponding to the CEID determined by the storage component determination device 1. The CE looks at the stored part information displayed on the SS terminal 2, and stores the type (part number) of the part indicated in the stored part information and the number of each type in its own part carrying means. .

  In addition, the SS terminal 2 stores actual data of parts replacement work actually performed by the CE belonging to the SS, MIF (Machine in Field) data in the SS's jurisdiction, MIF data for each CE belonging to the SS, For example, it is periodically collected and transmitted to the storage component determination device 1.

  The communication network 3 is a computer communication network such as the Internet or a LAN (Local Area Network).

Next, a specific configuration of the storage part determination apparatus 1 will be described.
FIG. 2 is a block diagram illustrating a configuration example of the storage component determination apparatus 1.
The storage component determination apparatus 1 includes a communication unit 11, an input unit 12, an output unit 13, a storage unit 14, and a control unit 15 as illustrated.

  The communication unit 11 communicates with the SS terminal 2 via the communication network 3 and includes a communication interface and the like. For example, the communication unit 11 receives data from the SS terminal 2 and transmits the storage component information determined by the storage component determination device 1 to the SS terminal 2 based on the received data.

  The input unit 12 is used to input various information and includes an input device such as a keyboard and a mouse. For example, the input unit 12 is used when a system administrator or the like edits information in various DBs (databases) stored in the storage unit 14 described later.

  The output unit 13 outputs various information and includes a display device such as a display. For example, the output unit 13 displays information as necessary when editing a DB by a system administrator or the like.

The storage unit 14 stores various information, programs, and the like, and includes an auxiliary storage device such as a hard disk.
Further, the storage unit 14 stores various DBs such as a work performance DB 141, a regional MIFDB 142, a CE-specific MIFDB 143, a parts master DB 144, a product master DB 145, a carrying means master DB 146, and a CE master DB 147. Details of these DBs will be described later.

  The control unit 15 includes a CPU (Central Processing Unit), a ROM (Read Only Memory), a RAM (Random Access Memory), and the like. The control unit 15 performs a data calculation process and controls the entire storage component determination apparatus 1. Specifically, the arithmetic processing and control processing in the control unit 15 are performed by the CPU executing a control program stored in the ROM while temporarily storing various data using the RAM as a work area. Done.

  The control unit 15 controls the communication unit 11, the input unit 12, the output unit 13, the storage unit 14, and the like according to a program stored in the ROM or the storage unit 14, so that the storage component information in the storage component determination apparatus 1 is stored. Generation processing and the like are performed.

Next, details of various DBs stored in the storage unit 14 of the storage component determination apparatus 1 will be described.
FIG. 3 is a diagram illustrating a data configuration example of the work performance DB 141.
The work performance DB 141 is a DB for accumulating actual data of part replacement work actually performed, and stores a work date, a work area, a CE, a part number, the number of replacements, and the like for each work as illustrated. In this work performance DB 141, the name of the prefecture where the work was performed is recorded in the work area column, the CEID of the CE that performed the work is recorded in the CE column, and the part number column is replaced. The part number that is the identification information of the part is recorded, and the number of parts of the same part number replaced in one operation is recorded in the replacement number column.

As described above, the result data is recorded for each work and for each part number. For example, when a plurality of types of parts having different part numbers are replaced in one operation, the result data is recorded for each part number. The
In each SS, when a CE to which the user belongs visits a customer and performs parts replacement work, a data input person or the like inputs work result data to the SS terminal 2. The SS terminal 2 transmits the input work performance data to the storage component determination device 1 periodically, for example, once a day. The storage component determination apparatus 1 accumulates the work result data received from the SS terminal 2 in the work result DB 141.

FIG. 4 is a diagram illustrating a data configuration example of the regional MIFDB 142.
The regional MIFDB 142 is a DB that stores monthly regional MIF data. As shown in the figure, the year, month, the model name that is the identification information of the product model, the region for each model, and the number of products marketed nationwide Remember. The number of products marketed here is, for example, the number of products sold to customers and subject to maintenance and repair by CE. The regional MIFDB 142 stores the number of products by model according to the prefecture as a region, and also stores the number of products nationwide calculated by summing the number of products by prefecture.

  In each SS, for example, the number of each model in the jurisdiction is periodically checked, and a data input person or the like inputs the product number data to the SS terminal 2 and transmits it to the storage component determination device 1. For example, at the beginning of the month, the storage component determination device 1 aggregates the product number data received from each SS terminal 2 by prefecture, and accumulates the number of products for each model in the regional MIFDB 142.

FIG. 5 is a diagram illustrating a data configuration example of the CE-specific MIFDB 143.
The CE-specific MIFDB 143 is a DB for storing monthly CE-specific MIF data. As shown in the drawing, the CE, the CEID of the CE, the model name of the product that the CE is in charge of maintenance / repair, and the CE of each model name. Memorize the number in charge.

In each SS, for example, when there is a change in the number of models in charge of the affiliated CE, a data input person or the like inputs the changed data to the SS terminal 2 and transmits it to the storage component determination device 1. For example, at the beginning of the month, the storage component determination apparatus 1 accumulates the number of products in charge for each type of assigned machine for each CE in the MIFDB 143 for each CE based on change data and the like.
This DB is also updated when there is a change or new adoption of CE.

FIG. 6 is a diagram illustrating a data configuration example of the component master DB 144.
The parts master DB 144 is a DB that stores information on all parts that may be exchanged during product maintenance and repair work. As shown in the figure, the part master DB 144 stores part numbers, volumes, quantity classifications, and the like for each part. To do.

  The volume is a unit volume of one part. The quantity category is a category defined according to the size of the part. For example, a part having a volume of 80 cubic centimeters or less is “small” in the quantity category “S”, and the volume is larger than 80 cubic centimeters and is 3,000. Parts with cubic centimeters or less are “medium” in quantity category “M”, and parts with a volume greater than 3,000 cubic centimeters and less than 30,000 cubic centimeters are “large” in quantity category “L” and have a volume greater than 30,000 cubic centimeters The part is defined as “extra large” in the quantity classification “A”.

FIG. 7 is a diagram illustrating a data configuration example of the product master DB 145.
The product master DB 145 is a DB that stores part numbers of replaceable parts for every product model that is a target of maintenance / repair work.

FIG. 8 is a diagram illustrating a data configuration example of the carrying means master DB 146.
The carrying means master DB 146 is a DB that stores information on carrying means for the CE to carry the parts and store the parts. As shown in the figure, the carrying means that is identification information of the carrying means for each carrying means. Stores name, storable volume, storable quantity classification, etc.

  Carrying means include, for example, “four wheels” indicating a four-wheeled vehicle, “two wheels” indicating a two-wheeled vehicle such as a motorcycle, “鞄” that is a CE component carrying means for visiting customers by train, bus, walking, etc. Divided.

The storable volume is the maximum volume that can be stored in the carrying means in which the parts are stored.
Further, the storable quantity classification is a quantity classification of parts suitable for storage by carrying means, and the quantity classification for each part is stored in the parts master DB 144 shown in FIG.

  In this carrying means master DB 146, the carrying means “four wheels” is suitable for storing parts of the quantity classification “L”, “M”, “S”, but suitable for storing parts of the quantity classification “A”. This means that the carrying means “motorcycle” is suitable for storing parts of the quantity classification “M” and “S”, but not suitable for storage of parts of the quantity classification “A” and “L”. It is shown that the carrying means “鞄” is only suitable for storing parts of the quantity classification “S”.

FIG. 9 is a diagram illustrating a data configuration example of the CE master DB 147.
The CE master DB 147 is a DB that stores CE information. As shown in the figure, for each CE, the CEID, the SS name to which the CE belongs, the prefecture name as the region to which the CE belongs, the CE carrying means, etc. Remember.
This DB is updated when there is a change of CE or new adoption.

Next, based on the information stored in the various DBs 141 to 147 described above, the storage component determination device 1 generates storage component information indicating the part number and the number of components to be stored by the CE. The determination process will be described.
FIG. 10 is a flowchart illustrating an example of the storage component determination process.
In this storage part determination process, for example, a CE who wants to know a part to be stored inputs his ID (CEID) to the SS terminal 2 and transmits it to the storage part determination apparatus 1, and the storage part determination apparatus 1 receives the CEID. Then it starts. In the following description of the stored part determination process, a case where the stored part information of CEa that is a specific CE is generated will be described as an example.

  First, the storage component determination apparatus 1 acquires a CEID (Step S11). For example, the control unit 15 of the storage component determination apparatus 1 acquires the CEID when the communication unit 11 receives the CEa CEID.

  Next, the storage component determination apparatus 1 performs a replacement value expectation value calculation process for each component (step S12). Specifically, the control unit 15 calculates, based on the past number of exchanges obtained from the work record data stored in the work record DB 141 for each part, the replacement number expected value that is the predicted value of the number of replacements by CEa. .

  Next, the storage component determination apparatus 1 performs a non-storage component removal process (step S13). Specifically, the control unit 15 removes parts that should not be stored in the CEa carrying means from the candidate parts to be stored based on the size of the parts.

  Next, the stored parts determination apparatus 1 performs a stored number determination process for each part (step S14). Specifically, the control unit 15 determines the number to be stored in the carrying means for each part.

  Next, the storage component determination apparatus 1 performs storage component selection processing (step S15). Specifically, the control unit 15 preferentially selects a part with a high replacement number expectation calculated in step S12 as a storage part according to the size of the CEa carrying means.

Next, the storage component determination apparatus 1 generates storage component information based on the above processing data (step S16), and ends this storage component determination process. Specifically, the control unit 15 records information on the parts selected in step 15 and the number determined in step S14 for each selected part in the storage unit 14 as CEa storage part information. To do.
The storage component determination apparatus 1 transmits this storage component information to the SS terminal 2 that is the CEID transmission source. Then, the CEa grasps the parts to be stored and the number of the parts to be stored by looking at the stored parts information using the SS terminal 2.

FIG. 11 is a flowchart illustrating an example of the replacement number expected value calculation process for each part in step 12 of FIG.
First, the control unit 15 acquires the model name (model name in charge) of the product for which the CE is in charge of maintenance / repair (step S21). Specifically, the control unit 15 reads the model name in charge associated with the CEID acquired in step S11 of FIG. 10 from the data of this month stored in the CE-specific MIFDB 143. In the following description, the case where all the product model names are, for example, NC10, NC20, NC30, and NC40, and the model name in charge of CEa is NC10, NC20, and NC30 is described as an example. .

  Next, the control unit 15 creates a part number list that lists the part numbers of parts that may be replaced in the maintenance / repair work of the CE (step S22). Specifically, the control unit 15 reads out a part number associated with the model name of the model in charge of CEa from the product master DB 145, and creates a part number list. When there are a plurality of models in charge and there are duplicate part numbers among the models, only one part number is recorded in the list.

  Next, the control unit 15 performs an expected value calculation process based on the nationwide results for each part number shown in the part number list (step S23). Specifically, the control unit 15 calculates the expected number of replacements for each part number shown in the part number list based on the part replacement work result data nationwide obtained from the work result DB 141, and based on the nationwide result. Create the expected number of exchanges table.

  Next, the control unit 15 performs an expected value calculation process based on the regional performance for each part number shown in the part number list (step S24). Specifically, the control unit 15 calculates the expected number of replacements for each part number shown in the part number list based on the part replacement work result data in the region to which the CEa belongs obtained from the work result DB 141, Create an exchange value expectation value table based on actual results.

  Next, the control unit 15 performs an expected value calculation process based on the individual results for each part number shown in the part number list (step S25). Specifically, the control unit 15 calculates the expected number of replacements for each part number shown in the part number list based on the CEa individual part replacement work result data obtained from the work result DB 141, and obtains the individual result. Create the expected number of exchanges based on the table.

  Then, the control unit 15 creates an exchange number expectation value table that integrates the exchange number expectation value table based on each of the national achievements, regional achievements, and individual achievements (step S26), and calculates the replacement number expectation value for each part. The process ends. Specifically, the control unit 15 adds a replacement number expected value indicated in the replacement number expected value table based on each result for each part number to create a new replacement number expected value table.

FIG. 12 is a flowchart showing an example of expected value calculation processing based on the nationwide results in step S23 of FIG.
Here, the expected number of replacements for each part is calculated based on the performance data in “Nationwide” of “Last month” stored in the work performance DB 141.

  First, the control unit 15 reads one part number from the part number list created in step S22 of FIG. 11 (step S101). In the following description, a case where the part number α is read from the part number list will be described as an example.

  Next, the control unit 15 acquires the number of replacements nationwide last month for the part number α (step S102). Specifically, the control unit 15 counts how many pieces of actual data of part replacement work with part number α whose work date is the date of the previous month in the actual data stored in the actual work DB 141. The count number is the number of exchanges.

  Next, the control unit 15 acquires a model name (part use model name) of a product that uses the part number α as a replacement part among all the product models (step S103). Specifically, the control unit 15 reads all model names associated with the part number α from the product master DB 145. For example, in the product master DB 145, when the part number α is associated with the model names NC10, NC20, and NC40, NC10, NC20, and NC40 are read as the part use model names.

  Next, the control unit 15 obtains the number of the nationwide market for the component use model last month (step S104). Specifically, the control unit 15 reads the nationwide total number for each part use model in the last month from the regional MIFDB 142, and calculates the nationwide market number of the part use model last month by summing the read nationwide total number. To do. For example, if the part use model is NC10, NC20, NC40, the nationwide total number of NC10 last month stored in the regional MIFDB 142, the nationwide total number of NC20, and the nationwide total number of NC40 are added. Thus, the number of parts used in the country last month is calculated.

Next, the control unit 15 calculates a nationwide replacement rate of the part number α (step S105). Specifically, the control unit 15
Nationwide exchange rate for part number α = (Number of replacements for part number α nationwide last month acquired in step S102) / (Market number of models used for part number α nationwide last month obtained in step S104)
Thus, the exchange rate is calculated.

  Next, the control unit 15 acquires the model name of the CE model in charge of the part use model (part use model name) (step S106). Specifically, the control unit 15 compares the part use model name acquired in step S103 with the responsible model name acquired in step S21 of FIG. 11, and acquires a duplicate model name as the part use model name. To do. For example, if the part use model is NC10, NC20, NC40 and the CEa model is NC10, NC20, NC30, NC10 and NC20 are model parts in charge.

  Next, the control unit 15 acquires the number of CEs in charge of “this month” of the part use charge model (step S107). Specifically, the control unit 15 reads out the number of units in charge of each part-use model from the CEa data of this month in the CE-specific MIFDB 143, totals the read-out number of units in charge, and determines the CEa Calculate the number in charge. For example, if the part use models are NC10 and NC20, the number in charge of this month's CEa model NC10 and the number in charge of NC20 stored in the CE-specific MIFDB 143 are added, and this part use model is this month. The number of CEa in charge is calculated.

Next, the control unit 15 calculates the expected replacement number of the part number α (step S108). Specifically, the control unit 15
Expected number of replacements for part number α = (Nationwide replacement rate for part number α calculated in step S105) × (Number of parts in charge of CEa for this month of the part-use model acquired in step S107)
To calculate the expected number of parts replacements based on nationwide results.
Based on the expected number of replacements, it is possible to predict the number of replacements for the part number α of this month in CEa that reflects the recent nationwide component replacement trend.

  Next, the control unit 15 determines whether or not all the part numbers have been read from the part number list (step S109). If there is a part number that has not been read yet (step S109; No). Returning to step S101, a new part number is read out, and the expected number of exchanges for the read part number is calculated by performing the processing of steps S102 to S108.

  On the other hand, when all the part numbers have been read from the part number list (step S109; Yes), the control unit 15 expects the number of exchanges calculated in step S108 for each part number indicated in the part number list. An “expected number of exchange value expectation value table based on the nationwide record” is created (step S110), and the expected value calculation process based on this nationwide record is finished.

FIG. 13 is a flowchart illustrating an example of an expected value calculation process based on the regional performance in step S24 of FIG.
Here, the expected number of replacements for each part is calculated based on the actual data in the “CE affiliation area” of “the latest past June” stored in the work result DB 141.
In this process, the detailed description of the same part as the process shown in FIG. 12 is omitted.

  First, the control unit 15 acquires the name of the region to which the CE belongs (step S201). Specifically, the control unit 15 reads the affiliation area name associated with the CEa CEID from the CE master DB 147. In the following description, the case where the CEa belongs to the X prefecture will be described as an example.

  Next, the control unit 15 reads one part number from the part number list created in step S22 of FIG. 11 (step S202). In the following description, a case where the part number α is read from the part number list will be described as an example.

  Next, the control unit 15 acquires the number of exchanges in the region to which the part number α belongs in the past June (step S203). Specifically, the control unit 15 includes, in the result data stored in the work result DB 141, the work date is the date from the month six months ago to the last month and the work area is X prefecture, part number α. The number of actual parts replacement work data is counted, and the counted number is the number of replacements.

  Next, the control unit 15 acquires the model name (part use model name) of a product that uses the part number α as a replacement part among all the product models (step S204).

  Next, the control unit 15 acquires the total number of marketed parts in the past 6 months of the part use model (step S205). Specifically, the control unit 15 first reads out the market number of the X prefecture for each part use model in the previous month from the regional MIFDB 142 and adds up the read market quantity of the part use model in the previous month of the X prefecture. Calculate the market volume. Further, the control unit 15 performs the same process for each month from February to June, and calculates the market number of the part use model in X prefecture for each month. Then, the total market numbers of each month from the previous month to June before are calculated, and the total market number of the part use models in the past June in X prefecture is calculated.

Next, the control unit 15 calculates a replacement rate in the region to which the part number α belongs (step S206). Specifically, the control unit 15
Exchange rate of region belonging to part number α = (number of exchanges of part number α in the past month acquired in step S203) / (model used in part number α in the past month acquired in step S205) Market total)
Thus, the exchange rate is calculated.

Next, the control unit 15 acquires the model name of the CE model in charge of the part use model (part use model name) (step S207).
Next, the control unit 15 acquires the number of CEs in charge of “this month” of the part use model (step S208).

Next, the control unit 15 calculates the expected replacement number of the part number α (step S209). Specifically, the control unit 15
Expected number of replacements of part number α = (exchange rate of the region to which part number α belongs calculated in step S206) × (number of parts in charge of CEa of this month for the part-use model acquired in step S208)
Thus, the expected number of replacement parts based on the local performance is calculated.
With this expected number of replacements, it is possible to predict the number of replacements for the current part number α in CEa, which reflects the part replacement characteristics of the region to which CEa belongs.

  Next, the control unit 15 determines whether or not all the part numbers have been read from the part number list (step S210). If there is a part number that has not been read yet (step S210; No). Returning to step S202, a new part number is read out, and the processing of steps S203 to S209 is performed to calculate the expected number of exchanges for the read part number.

  On the other hand, when all the part numbers are read from the part number list (step S210; Yes), the control unit 15 expects the number of exchanges calculated in step S209 for each part number shown in the part number list. An “exchange number expected value table based on regional results” in which values are recorded is created (step S211), and the expected value calculation processing based on the regional results is terminated.

FIG. 14 is a flowchart illustrating an example of an expected value calculation process based on the individual performance in step S25 of FIG.
Here, the expected number of replacements for each part is calculated based on the “CE individual” record data of “the most recent past December” stored in the work record DB 141.

  First, the control unit 15 reads one part number from the part number list created in step S22 of FIG. 11 (step S301). In the following description, a case where the part number α is read from the part number list will be described as an example.

  Next, the control unit 15 acquires the number of CE replacements in the past December for the part number α (step S302). Specifically, the control unit 15 includes a part number in which the work date is the date from the month 12 months ago to the last month and the CEID of CEa is recorded in the result data stored in the work result DB 141. Count how many actual data of α parts replacement work is, and use the counted number as the number of replacements.

Next, the control unit 15 calculates the expected number of replacements for the part number α (step S303). Specifically, the control unit 15
Expected number of replacements for part number α = (number of replacements for part number α of CEa in the past December acquired in step S302) / 12
Thus, the expected number of replacement parts based on the individual results is calculated. Note that “12” in the denominator of the formula for calculating the expected number of exchanges is the number of months of the actual data used for counting the number of exchanges.
Based on this expected number of replacements, it is possible to predict the number of replacements for the part number α of this month in CEa, which reflects the parts replacement tendency unique to CE.

  Next, the control unit 15 determines whether or not all the part numbers have been read from the part number list (step S304), and if there is a part number that has not been read yet (step S304; No). Returning to step S301, a new part number is read out, and the expected number of exchanges for the read part number is calculated by performing the processing of steps S302 and S303.

  On the other hand, when all the part numbers have been read from the part number list (step S304; Yes), the control unit 15 expects the number of exchanges calculated in step S303 for each part number indicated in the part number list. An “exchange value expected value table based on individual results” in which values are recorded is created (step S305), and the expected value calculation processing based on this individual results is terminated.

  In step S26 of FIG. 11, the “exchange number expectation value table based on nationwide results”, “exchange number expectation value table based on regional results”, and “exchange number expectation value table based on individual results” created in this way. ”And the expected number of exchanges recorded for each part number, and the expected number of exchanges for each part number indicating the expected number of exchanges taking into account all of the national, regional, and individual results. A table is created.

  With this integrated exchange number expectation value table, for example, even if there is no CE individual work performance data due to a change in CE, new recruitment, etc., the expected number of exchanges can be calculated based on the nationwide results and regional results. Obtainable. Then, by determining the stored parts based on the expected number of replacements, it is possible to know the parts to be stored even if the CE is newly transferred or newly adopted.

FIG. 15 is a flowchart illustrating an example of the non-storage component removal process in step S13 of FIG.
First, the control part 15 acquires the carrying means name of CE (step S31). Specifically, the control unit 15 reads the carrying means name associated with the CEa CEID from the CE master DB 147. In the following description, a case where the CEa carrying means is a “two-wheel” will be described as an example.

  Next, the control unit 15 acquires the storable quantity classification of the carrying means (step S32). Specifically, the control unit 15 reads out the storable quantity category associated with the carrying means name acquired in step S31 from the carrying means master DB 146. For example, when the carrying means is “motorcycle”, “M” and “S” are read from the carrying means master DB 146 as the storable quantity categories.

Next, the control unit 15 reads one part number from the exchange number expectation value table created in step S26 of FIG. 11 (step S33).
Next, the control unit 15 acquires the quantity classification of the part specified by the read part number (step S34). Specifically, the control unit 15 reads the quantity category associated with the part number read in step S33 from the component master DB 144.

  Next, the control unit 15 determines whether or not the acquired quantity category is included in the storable quantity category acquired in Step S32 (Step S35), and if not included (Step S35; No) ) The data of the part specified by the part number read in step S33 is deleted from the replacement number expected value table (step S36). Specifically, the part number and the exchange number expected value of the part number are deleted from the exchange number expected value table.

  On the other hand, if it is determined in step S35 that the quantity category is included in the storable quantity category (step S35; Yes), the process of step S36 is skipped.

Next, the control unit 15 determines whether or not all the part numbers have been read from the exchange number expected value table (step S37), and if there is a part number that has not yet been read (step S37; No), returning to step S33, reading out a new part number, and performing the processes of steps S34 to S36, the data of the parts of the quantity category not included in the storable quantity category is deleted from the exchange number expected value table.
On the other hand, when all the part numbers have been read from the replacement number expected value table (step S37; Yes), this non-storage part removal process is terminated.

By this non-storage part removal process, it is possible to remove a part having a size that is not suitable for storage by the CE carrying means from among the candidate parts to be stored by the CE.
For example, when the carrying means of the CE is “motorcycle”, the storable quantity categories are “M” and “S”, so the quantity categories “A” (extra large) and “L” are obtained from the exchange number expectation value table. The part number of the (big) part and its expected number of replacements are deleted. As a result, in the replacement number expected value table, the part numbers of the parts of the quantity classification “M” (medium item) and “S” (small item) and the expected number of replacement number are indicated.

FIG. 16 is a flowchart showing an example of the stored number determination process for each part in step S14 of FIG.
First, the control unit 15 reads one part number from the replacement number expectation value table that has been subjected to the above-described non-storage part removal process (step S41). In the following description, a case where the part number α is read from the exchange number expected value table will be described as an example.

  Next, the control unit 15 acquires the most frequent replacement number of the part number α in the past six months (step S42). Specifically, the control unit 15 obtains the most frequently replaced number of parts of part number α per work based on the work result data of part number α in the work result DB 141. For this purpose, the control unit 15 refers to the “replacement number” in the work result data of the part number α of the date from the month six months ago to the previous month, and determines the number of work items (work result data for each replacement number value). Count) and count. Then, the replacement number with the largest number of work is acquired as the most frequent replacement number of the part number α. If there are the same number of replacements with the largest number of work, the larger replacement number is set as the most frequent replacement number.

  Next, the control unit 15 records the acquired most frequently exchanged number in the exchange number expectation value table as the stored number of the part number α (step S43).

Next, the control unit 15 determines whether or not all the part numbers have been read from the exchange number expected value table (step S44), and if there is a part number that has not been read yet (step S44; No), returning to step S41, a new part number is read, and the processing of steps S42 and S43 is performed to record the stored number of the read part number in the exchange number expectation value table.
On the other hand, when all the part numbers have been read from the replacement number expectation value table (step S44; Yes), the part-by-part storage number determination process ends.

In addition, the storage number determination processing for each part is executed for every part number stored in the part master DB 144, for example, every month, and the most frequently exchanged number for each part number is recorded in the part master DB 144. You may make it update in the next. In such a case, it is possible to determine the number of parts to be stored for each part simply by referring to the part master DB 144, and to reduce the CPU processing load at the time of determining the number of stored parts.
In step S42, the most frequently exchanged number in the most recent six months is acquired, but another period may be used.

FIG. 17 is a flowchart illustrating an example of the storage component selection process in step S15 of FIG.
First, the control unit 15 acquires the storable volume of the carrying means of the CE (Step S51). Specifically, the control unit 15 reads the storable volume associated with the carrying means name acquired in step S31 of FIG. 15 from the carrying means master DB 146. For example, when the carrying means of CEa is “two wheels”, 30,000 cubic centimeters is read from the carrying means master DB 146 as the storable volume.

  Next, the control unit 15 sorts the part numbers recorded in the replacement number expected value table that has been subjected to the above-described storage number determining process for each part in descending order of the replacement number expected value (step S52). Further, the control unit 15 adds the rank number to the part numbers sorted in descending order of the replacement number expected value and records it in the replacement number expected value table.

  Next, the control unit 15 sets the variable n to 0 (step S53) and increments the value of n (step S54). Then, the part number of the rank n is read from the sorted exchange number expectation value table (step S55).

  Next, the control unit 15 acquires the volume of the read part number (step S56). Specifically, the control unit 15 reads the volume associated with the part number from the component master DB 144 and records it in the replacement number expected value table as a unit volume of the component.

Next, the control unit 15 obtains a storage volume that is a volume considering the number of stored parts (step S57). Specifically, the control unit 15
The storage volume of the part number part read in step S55 is calculated from storage volume = unit volume × storage number, and recorded in the replacement number expected value table.

Next, the control unit 15 obtains a cumulative storage volume obtained by summing up the storage volumes of the part numbers from rank 1 to rank n (step S58). Specifically, when n = 1, the control unit 15 records the storage volume as the cumulative storage volume as it is in the replacement number expectation value table, and when n is other than 1, the control unit 15 stores the rank n−1. The storage volume of the part number of rank n is added to the cumulative storage volume of No., and the cumulative storage volume is calculated and recorded in the replacement number expected value table.
FIG. 18 shows an example of the replacement number expected value table recorded up to the cumulative storage volume in this way.

Next, the control unit 15 determines whether or not the accumulated storage volume is larger than the storable volume acquired in Step S51 (Step S59).
If the accumulated storage volume is less than or equal to the storable volume (step S59; No), the process returns to step S54, and the control unit 15 increments n and obtains the accumulated storage volume for the part number having a lower priority.

If the accumulated storage volume is larger than the storable volume (step S59; Yes), the parts up to rank n cannot be stored in the carrying means, so the parts up to rank n-1 are selected as parts to be stored in the carrying means. (Step S60), the storage component selection process is terminated.
If all the part numbers are read from the replacement number expected value table before the cumulative storage capacity exceeds the storable volume, the parts of all part numbers shown in the replacement number expected value table are stored parts. Choose as.

  This storage component selection process will be described using the replacement number expected value table shown in FIG. 18. When the carrying means is, for example, “two wheels”, the storage capacity of 30,000 cubic centimeters is set in step S51 of FIG. Since it has been acquired, the parts up to the 29th rank in which the accumulated storage volume is 30,000 cubic centimeters or less are selected as the storage parts.

In step S16 of FIG. 10, the part number of the selected part and the number of parts stored for each part number are read out from the replacement number expected value table shown in FIG. 18, and stored in the storage unit 14 as CEa stored part information. Remember.
In the storage component selection process shown in FIG. 17, the selection is performed in consideration of the volume of the component. However, the selection may be performed in consideration of the external size and weight of the component.

As described above, in the present embodiment, the parts replacement work results nationwide, the parts replacement work results in the CE's affiliation region, and the CE individual parts replacement work results are reflected in the CE's charge model, and Calculate the expected number of replacements for each part. Then, the parts to be stored are selected in descending order of the number of replacement expectation values.
Therefore, according to the present embodiment, for each CE, a component that is highly likely to be replaced in the component replacement operation can be appropriately determined as a component to be stored.

  Although the embodiments of the present invention have been described above, the present invention can be modified and applied in various forms and is not limited to the above embodiments.

  For example, in the above-described embodiment, the storage component determination device 1 has been described as storing various DBs. However, for example, a DB server for DB storage is installed on the communication network 3 to store the storage component determination device 1. However, if necessary, the information may be read by accessing the DB server.

  In the above embodiment, after acquiring the CEID, the parts to be stored by the CE specified by the CEID are determined. For example, the storage parts for all the CEs are determined periodically such as once a month. In addition, it may be stored in a dedicated storage parts information DB or the like. In this case, a CE who wants to know a stored part can access the stored part information DB and obtain his own stored part information.

  Furthermore, in the case where the stored parts information is created in a lump in this way, for example, the replacement rates in all regions of all the parts stored in the parts master DB 144 are obtained in advance, You may make it obtain | require the replacement number expectation value according to components for every CE.

  Further, the order of the processes in the flowcharts described in the above embodiments is not limited to the order, and can be arbitrarily changed without departing from the spirit of the present invention. For example, the sort processing of the exchange number expected value table may be performed when the exchange number expected value table is created in step S12 of FIG. Further, for example, the expected value calculation processing based on the results of steps S23 to S25 in FIG. 11 may be performed in any order.

  Further, in the expected value calculation process based on the results of Steps S23 to S25 in FIG. 11, the period of the result data used for the process has been described as last month, the past June, and the past December, but is not limited thereto. Instead, it may be changed in consideration of the number of data and the age of the data.

  Further, in step S26 of FIG. 11, the expected value based on each result is added to create an integrated replacement number expected value table, and the expected value is used to determine the priority order of the parts to be stored. For this reason, not only the added value but also an average number or maximum value may be obtained and an exchange number expected value table integrated may be created.

  In addition, the storage component determination apparatus 1 according to the above embodiment can be realized by dedicated hardware or by a normal computer system.

  For example, in the above-described embodiment, the storage part determination device 1 has been described assuming that the operation program is stored in advance in a memory or the like. However, a program for executing the above-described processing operation is recorded on a computer-readable recording medium such as a flexible disk, a CD-ROM (Compact Disk Read-Only Memory), a DVD (Digital Versatile Disk), or an MO (Magneto-Optical disk). An apparatus that executes the above-described processing operation may be configured by storing and distributing the program in a medium and installing the program in a computer.

Further, the program may be stored in a disk device or the like included in a predetermined server device on a communication network such as the Internet, and may be downloaded onto a computer by being superimposed on a carrier wave, for example. Furthermore, the above-described processing can also be achieved by starting and executing a program while transferring it via a communication network.
In addition, when the above functions are realized by sharing an OS (Operating System), or when the functions are realized by cooperation between the OS and an application, only the part other than the OS may be stored in a medium and distributed. Alternatively, it may be downloaded to a computer.

It is a block diagram which shows the structural example of the storage component determination system which concerns on embodiment of this invention. It is a block diagram which shows the structural example of the storage component determination apparatus. It is a figure which shows the example of a data structure of work performance DB. It is a figure which shows the data structural example of MIFDB classified by area. It is a figure which shows the data structural example of MIFDB classified by CE. It is a figure which shows the example of a data structure of components master DB. It is a figure which shows the example of a data structure of product master DB. It is a figure which shows the data structural example of carrying means master DB. It is a figure which shows the data structural example of CE master DB. It is a flowchart which shows the example of a storage component determination process. It is a flowchart which shows the example of the replacement number expectation value calculation process according to parts. It is a flowchart which shows the example of the expected value calculation process based on a national performance. It is a flowchart which shows the example of the expected value calculation process based on a local performance. It is a flowchart which shows the example of the expected value calculation process based on an individual performance. It is a flowchart which shows the example of a non-storage component removal process. It is a flowchart which shows the example of the storage number determination process according to components. It is a flowchart which shows the example of a storage component selection process. It is a figure which shows the example of a data structure of an exchange number expectation value table.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Storage component determination apparatus 2 SS terminal 3 Communication network 11 Communication part 12 Input part 13 Output part 14 Storage part 15 Control part 141 Work results DB
142 MIFDB by region
143 MIFDB by CE
144 Parts master DB
145 Product Master DB
146 Carrying means master DB
147 CE Master DB

Claims (9)

A storage part determination device for determining a storage part of an operator,
For each part, replacement work number acquisition means for acquiring the replacement work number of the part,
For each part, a part-used product number acquisition means for acquiring the number of products that use the part as a replacement part;
For each part, the operator obtains the number of products in charge for obtaining the number of products in charge of replacement of the parts by the worker;
For each part, based on the number of replacement work acquired by the replacement work number acquisition means, the number of products acquired by the part use product number acquisition means, and the number of products acquired by the responsible product number acquisition means, Expected value obtaining means for obtaining an expected value of the number of replacement work of the parts by the worker;
Storage part information generation means for generating storage part information in which parts up to a predetermined order are selected as storage parts of the operator in descending order of expected values obtained by the expected value acquisition means;
A storage part determination device comprising: The expected value acquisition means includes
For each part, (“the number of replacement work acquired by the replacement work number acquisition unit” / “the number of products acquired by the part use product number acquisition unit”) × “the number of products acquired by the product number acquisition unit in charge” ”To find the expected value.
The storage part determination apparatus according to claim 1, wherein the storage part determination apparatus is a storage part determination apparatus. The replacement work number acquisition means includes:
For each part, in all regions divided into a plurality, the regional replacement work number acquisition means for acquiring the replacement work number of the part,
For each part, the affiliation area replacement work number acquisition means for acquiring the replacement work number of the part in the worker's affiliation area,
The part use product number acquisition means includes:
For each part, in all the regions, the number of products using all parts used to obtain the number of products using the part as a replacement part; and
For each part, it has an affiliated region part use product number acquisition means for acquiring the number of products using the part as a replacement part in the affiliated area,
The expected value acquisition means includes
For each part, the number of replacement work acquired by the all-regional replacement work number acquisition unit, the number of products acquired by the all-regional part use product number acquisition unit, the number of products acquired by the responsible product number acquisition unit, Based on the above, all-region expected value acquisition means for obtaining an expected value based on the work results of all the regions, the number of replacement work of the parts by the worker,
For each part, the number of replacement work acquired by the affiliation area replacement work number acquisition means, the number of products acquired by the affiliation area part use product number acquisition means, the number of products acquired by the assigned product number acquisition means, , Based on the work area, the number of replacement work of the part by the worker, the expected value of the affiliation area to obtain the expected value based on the work results of the affiliation area,
For each part, it has an integrated expected value acquisition unit for obtaining an expected value obtained by integrating the expected value obtained by the all region expected value acquisition unit and the expected value obtained by the belonging region expected value acquisition unit,
The storage part determination apparatus according to claim 1, wherein the storage part determination apparatus is a storage part determination apparatus. The integrated expected value acquisition means, for each part, adds the expected value obtained by the all region expected value acquisition means and the expected value obtained by the belonging region expected value acquisition means to obtain an integrated expected value,
The storage part determination apparatus according to claim 3. The all-region replacement work number acquisition means acquires the number of replacement work cases in the first predetermined period,
The affiliation area exchange work number acquisition means acquires the number of exchange work cases in the second predetermined period,
The all-region parts-used product number acquisition means acquires the number of products in the first predetermined period,
The affiliation area part use product number acquisition means acquires the number of products in the second predetermined period;
The storage part determination apparatus according to claim 3 or 4, wherein the storage part determination apparatus is a storage part determination apparatus. The replacement work number acquisition means includes:
For each part, it has a personal replacement work number acquisition means for acquiring the number of replacement work of the part performed by the worker,
The expected value acquisition means includes
For each part, based on the number of replacement work acquired by the personal replacement work number acquisition means, the personal expectation value acquisition means for obtaining an expected value based on the individual work results of the number of replacement work of the part of the worker ,
The integrated expectation value acquisition means includes, for each part, the expectation value obtained by the all region expectation value acquisition means, the expectation value obtained by the belonging region expectation value acquisition means, and the expectation obtained by the individual expectation value acquisition means. To obtain the expected value that is integrated with the value,
The storage part determination apparatus according to claim 3, wherein the storage part determination apparatus is a storage part determination apparatus. The individual replacement work number acquisition means acquires the number of replacement work cases in a third predetermined period for each part,
The individual expected value acquisition means performs an operation of “the number of replacement work acquired by the personal replacement work number acquisition means” / “the third predetermined period” for each part to obtain an expected value.
The storage part determination apparatus according to claim 6. A storage part determination method for determining a storage part of an operator,
For each part, a replacement work number recording step for recording the number of replacement work of the part in the storage unit,
For each part, a part use product number recording step of recording the number of products using the part as a replacement part in the storage unit;
For each part, the number of products for which the operator is responsible for replacement of the part is recorded in the storage unit, the number of products in charge recording step,
For each part, from the storage unit, the number of replacement work recorded in the replacement work number recording step, the number of products recorded in the part use product number recording step, and the number of products recorded in the responsible product number recording step. And an expected value acquisition step for obtaining an expected value of the number of replacement work of the part by the worker based on the read information;
A storage part information generation step for generating storage part information in which parts up to a predetermined order are selected as storage parts of the operator in descending order of the expected value obtained in the expected value acquisition step;
A storage part determination method comprising: Computer
Replacement work number acquisition means for acquiring the replacement work number of the part for each part,
For each part, a part use product number acquisition means for acquiring the number of products using the part as a replacement part,
For each part, the number of products in charge for the operator to obtain the number of products in charge of replacement of the part,
For each part, based on the number of replacement work acquired by the replacement work number acquisition means, the number of products acquired by the part use product number acquisition means, and the number of products acquired by the responsible product number acquisition means, An expected value obtaining means for obtaining an expected value of the number of replacement work of the parts by the worker;
Storage part information generation means for generating storage part information in which parts up to a predetermined order are selected as storage parts of the operator in descending order of expected values obtained by the expected value acquisition means,
Program to function as.

Images