Subcontract planning system and subcontract planning method

Abstract

To select a product / step that should undergo internal production or outsourcing to achieve the accomplishment of a training plan corresponding to a skill level of an operator, for example, in a factory for producing a small amount of products of various types, or the like.SOLUTION: In an outsourcing plan system including an operation part, and a storage part, the storage part holds production plan information, work man-hour information, operator skill information, and work adaption information showing a work skill level of an operator suitable for work of each step of each product, and the operation part generates a plurality of internal production / outsourcing candidates including information showing steps and an amount of a product to undergo internal production and steps and an amount of a product to undergo outsourcing on the basis of the production plan information, and calculates a skill adaptation degree showing the degree of adaptation between a work skill of operators suitable for the steps, the man-hour and work of each step of the product to undergo internal production, and the number of persons in each work skill of operators on the basis of each internal production / outsourcing candidate.SELECTED DRAWING: Figure 2

Description

[Technical field]

[0001] The present invention relates to a system for formulating an outsourcing plan that supports a factory in determining which products and processes to produce in-house or outsource. [Background technology]

[0002] Background art is JP 2002-215220 A (Patent Document 1). This publication states, "A scheduling DB is created based on the order DB, in-house machine progress DB, parts bill DB, process schedule DB, and equipment DB, and scheduling is performed using only the in-house equipment. Next, it is determined whether the delivery dates for all orders have been secured. If there are orders for which the delivery dates are not secured, a scheduling DB is created that takes into account the outsourced equipment based on the outsourced equipment DB and outsourced progress DB, and scheduling is performed again." [Prior art documents] [Patent documents]

[0003] [Patent Document 1] JP 2002-215220 A Summary of the Invention [Problem to be solved by the invention]

[0004] Social infrastructure system products such as control panels are produced in small quantities and in a wide variety of products. Since different products require different work skills, production plans are drawn up and production is carried out by dividing personnel into several manufacturing groups. However, because orders fluctuate for each product area, the workload (time) of each group varies, which creates a problem of oversufficiency in production capacity for each group. To address this issue, the manufacturing site has made personnel adjustments between groups while drawing up training plans to develop multi-skills so that each worker can be in charge of other products and processes. If this does not resolve the oversufficiency in production capacity, the problem is addressed by utilizing outsourced manufacturers.

[0005] In response to this, Patent Document 1 describes a method for formulating production plans for in-house production and outsourcing (hereinafter also referred to as in-house / outsourced production) from the perspective of in-house production / outsourced equipment capacity and ensuring delivery dates. However, these methods determine whether to in-house or outsource production only based on the relationship between work hours and production capacity, and are unable to select products and processes to be in-house or outsourced, taking into account training plans according to the proficiency (skills) of each group of workers.

[0006] Therefore, the present invention provides an outsourcing planning system for supporting the achievement of a training plan according to the skills of workers. [Means for solving the problem]

[0007] In order to achieve at least one of the above objects, the present invention provides an outsourcing planning system having a calculation unit and a storage unit, the storage unit storing production plan information indicating the production volume of a product and the processes required for production, and Cost per unit Work man-hour information indicating the man-hours for each process, worker skill information indicating the level of work skill for each process of a plurality of workers, and work compatibility information indicating the level of work skill of workers suitable for each process of each product; training plan information indicating, for each of the processes and the workers, a target value of the time that the workers will be engaged in the work of the process in order to train the workers; The calculation unit holds: Based on the production plan information and the work man-hour information, the work man-hours for each process of the product are calculated as workload information, and based on the worker skill information and the workload information, a surplus or deficiency in production capacity of each process is determined, and when it is determined that there is a surplus or deficiency in production capacity, candidate products and processes to be produced in-house or candidate products and processes to be outsourced are selected so as to eliminate the surplus or deficiency in production capacity of each process. generating a plurality of in-house / outsourced production candidates including information indicating the process and quantity of the product to be in-house produced and the process and quantity of the product to be outsourced; A skill satisfaction level is calculated to indicate the degree of satisfaction of the total man-hours for each process to be in-house produced based on each of the in-house / out-production candidates relative to the total target working hours for each process for the multiple workers. The man-hours for the processes of the products to be in-house produced in each of the in-house / out-production candidates are tallied for each work skill value of workers suitable for the work of each process based on the production plan information and the work man-hour information. The number of the multiple workers is tallied for each process and work skill. A high degree of agreement is indicated between the ratio of the man-hours for each work skill value of workers suitable for the work of each process and the ratio of the number of the workers for each of the tallied processes and work skills. Calculate skill compatibility and determining a priority of selection of each of the in-house / outsourcing candidates used to identify products and processes to be outsourced according to the level of the skill compatibility and the skill sufficiency. The present invention is characterized by the above. Effect of the Invention

[0008] According to one aspect of the present invention, even in a factory that produces a wide variety of products in small quantities, it is possible to plan in-house and outsource production taking into account the difficulty of work according to the proficiency of the worker. As a result, even in a manufacturing site where workers with various skills are employed, it is possible to assign products and processes with a difficulty level suitable for training to the workers, and it is possible to realize efficient multi-skilling. Problems, configurations, and effects other than those described above will be made clear by the following explanation of the embodiment. [Brief description of the drawings]

[0009] [Figure 1] 1 is a flowchart illustrating an example of a process according to an embodiment of the present invention. [Diagram 2] FIG. 1 is a functional block diagram illustrating an example of a system configuration according to an embodiment of the present invention. [Diagram 3] FIG. 2 is an explanatory diagram illustrating an example of production plan information held by the outsourcing planning system according to the embodiment of the present invention. [Figure 4] FIG. 2 is an explanatory diagram illustrating an example of work man-hour information held by the outsourcing planning system according to the embodiment of the present invention. [Diagram 5] FIG. 2 is an explanatory diagram illustrating an example of subcontract planning information held by the subcontract planning system according to the embodiment of the present invention. [Figure 6] FIG. 2 is an explanatory diagram illustrating an example of worker skill information held by the outsourcing planning system according to the embodiment of the present invention. [Figure 7] FIG. 2 is an explanatory diagram illustrating an example of development plan information held by the outsourcing planning system according to the embodiment of the present invention. [Figure 8] 1 is an explanatory diagram illustrating an example of task compatibility rank information held by the outsourcing planning system according to an embodiment of the present invention. FIG. [Figure 9] 1 is an explanatory diagram illustrating an example of skill fulfillment information held by the outsourcing planning system according to an embodiment of the present invention. [Figure 10] 1 is an explanatory diagram illustrating an example of skill task compatibility information held by the outsourcing planning system according to an embodiment of the present invention. FIG. [Figure 11] 1 is an explanatory diagram illustrating an example of skill compatibility information held by the outsourcing planning system according to an embodiment of the present invention. [Figure 12] 1 is an explanatory diagram showing an example of in-house production / outsourcing determination result information held by the outsourcing planning system according to an embodiment of the present invention. FIG. [Figure 13] FIG. 2 is an explanatory diagram illustrating an example of in-house production and outsourcing instruction information held by the outsourcing planning system according to an embodiment of the present invention. [Figure 14] FIG. 2 is an explanatory diagram illustrating an example of work allocation information held by the outsourcing planning system according to the embodiment of the present invention. [Figure 15]FIG. 11 is an explanatory diagram illustrating an example of an input screen displayed by the outsourcing planning system according to the embodiment of the present invention. [Figure 16] FIG. 2 is an explanatory diagram illustrating an example of workload data generated by the outsourcing planning system according to the embodiment of the present invention. [Figure 17] 1 is an explanatory diagram illustrating an example of production capacity and surplus / deficiency information generated by the outsourcing planning system according to an embodiment of the present invention. FIG. [Figure 18] 11 is a flowchart illustrating an example of a process for calculating a skill compatibility by the outsourcing planning system according to the embodiment of the present invention. [Figure 19] 1 is an explanatory diagram illustrating an example of personnel information by skill rank generated by the outsourcing planning system according to an embodiment of the present invention. FIG. [Figure 20] FIG. 11 is an explanatory diagram illustrating an example of an output screen by the outsourcing planning system according to the embodiment of the present invention. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0010] A method for realizing the present invention will now be described with reference to the drawings.

[0011] Fig. 1 is a flowchart showing an example of processing in an embodiment of the present invention, Fig. 2 is a functional block diagram showing an example of a system configuration of the embodiment of the present invention.

[0012] In FIG. 2, the outsourcing planning system 10 is a device including a PC (Personal Computer) such as a server or a terminal, and software installed in the PC, and is provided with an input / output unit 100, a storage unit 200, and a calculation unit 300.

[0013] The input / output unit 100 is used to obtain data required for processing by the calculation unit 300 and display the processing results, and is configured with, for example, input devices such as a keyboard and mouse, a communication device for communicating with the outside, a recording / playback device for disk-type storage media, and an output device such as a CRT or LCD monitor.

[0014] The storage unit 200 includes input information 210 used in the processing of the calculation unit 300 and output information 220 for storing the processing results, and is configured as a storage device such as a hard disk drive or memory.

[0015] The input information 210 includes production plan information 211, work man-hour information 212, outsourcing plan information 213, worker skill information 214, training plan information 215, and work suitability rank information 216, which will be described below.

[0016] FIG. 3 is an explanatory diagram showing an example of the production plan information 211 held by the outsourcing planning system 10 according to the embodiment of the present invention.

[0017] The production plan information 211 is information for managing the production plan of products and processes, and is composed of information such as a product ID 301, production quantity 302, product classification 303, process 304, start date 305, and end date 306, as shown in Fig. 3. In the production plan information 211 in Fig. 3, for example, the information in the first two lines indicates that the product identified by the product ID "P100" corresponds to the product classification "X", and the production quantity "2" is planned to be produced by carrying out the processes "sheet metal" and "assembly" from "10 / 1 to 10 / 5" and "10 / 6 to 10 / 15", respectively.

[0018] FIG. 4 is an explanatory diagram showing an example of the work man-hour information 212 held by the outsourcing planning system 10 according to the embodiment of the present invention.

[0019] The work man-hour information 212 is information for managing the man-hours required for each product, and is composed of information on product classification 401, process 402, and work man-hours 403, as shown in Fig. 4. In the work man-hour information 212 in Fig. 4, for example, the information in the first row indicates that work man-hours "70 (h)" are required for the process "sheet metal" of product classification "X".

[0020] FIG. 5 is an explanatory diagram showing an example of the outsourcing plan information 213 held by the outsourcing plan system 10 according to the embodiment of the present invention.

[0021] The outsourcing plan information 213 is information for managing outsourcing plans for products and processes, and for example, as shown in Fig. 5, is composed of information such as product ID 501, production quantity 502, product category 503, process 504, subcontractor 505, start date 506, and end date 507. In the outsourcing plan information 213 in Fig. 5, for example, the first row indicates that product ID "P120" corresponds to product category "X", and for production quantity "1", the plan is to outsource the "sheet metal" process to subcontractor "Company x1" for the period "10 / 1 to 10 / 5".

[0022] FIG. 6 is an explanatory diagram showing an example of the worker skill information 214 held by the outsourcing planning system 10 according to the embodiment of the present invention.

[0023] The worker skill information 214 is information for managing the skill rank of each worker for each process, and is composed of information on a worker ID 601, a process 602, and a skill rank 603, as shown in Fig. 6. In the worker skill information 214 in Fig. 6, for example, the first line indicates that a worker with a worker ID of "M100" has a skill rank of "A" for the "sheet metal" process. In this embodiment, an example is shown in which skill ranks are managed in three stages, A, B, and C, with the order of A, B, and C indicating the order of the level of the skills possessed for the corresponding process.

[0024] FIG. 7 is an explanatory diagram showing an example of the development plan information 215 held by the outsourcing plan system 10 according to the embodiment of the present invention.

[0025] The training plan information 215 is information for managing a plan of the time required for skill training for an arbitrary period and process for each worker, and is composed of information such as a worker ID 701, a start date 702, an end date 703, a process 704, and a target working time 705. In the training plan information 215 of Fig. 7, for example, the first line indicates that the worker with the worker ID "X100" aims to work for "140 (h)" in order to master the skills of the "sheet metal" process during the period "10 / 1 to 10 / 31".

[0026] FIG. 8 is an explanatory diagram showing an example of the task suitability rank information 216 held by the outsourcing planning system 10 according to the embodiment of the present invention.

[0027] Work compatibility rank information 216 is information for managing the difficulty of work for each process of each product (in other words, the level of skill required of a worker to perform that work), and for example, as shown in Fig. 8, is made up of information on product classification 801, process 802, and work compatibility rank 803. In work compatibility rank information 216 in Fig. 8, for example, the top row indicates that the work compatibility rank, which indicates the difficulty of the "sheet metal" process of product classification "X", is "A".

[0028] In this embodiment, an example is shown in which the task suitability rank is managed in three stages, A, B, and C, similarly to the worker skill information 214, and the order of A, B, and C indicates the order of the skill required for the task in the corresponding process. The task suitability rank is determined in advance, but may be based on any one of the following, or a combination of two or more of them: the ratio of the standard task time and the actual task time in each process of each product (the longer the actual task time is compared to the standard task time, the higher the difficulty of the product / process), the frequency of appearance of the parts to be worked on (the lower the frequency, the fewer the opportunities to experience the task and the higher the difficulty), and the number of processing processes per part (the more processing processes there are, the more complex the task and the higher the difficulty).

[0029] The output information 220 includes skill sufficiency information 221, skill-task compatibility information 222, skill compatibility information 223, in-house / outsourced production determination result information 224, in-house / outsourced production instruction information 225, and work allocation information 226, each of which will be described below.

[0030] FIG. 9 is an explanatory diagram illustrating an example of the skill sufficiency information 221 held by the outsourcing planning system 10 according to the embodiment of the present invention.

[0031] The skill fulfillment information 221 is information for managing the fulfillment of the workload (time) for the training plan information 215 when in-house production and outsourcing are performed based on the results of the outsourcing planning system 10, and is composed of information such as an in-house / outsourcing ID 901, a process 902, a start date 903, an end date 904, a target working time 905, a post-in-house / outsourcing workload 906, and a skill fulfillment 907, as shown in Fig. 9. In the skill fulfillment information 221 in Fig. 9, for example, the first row indicates that when the outsourcing plan specified by the in-house / outsourcing ID "G100" is executed, the post-in-house / outsourcing workload will be "5200 (h)" for the target working time "5600 (h)" of the training plan for the "sheet metal" process from "10 / 1 to 10 / 31", and the skill fulfillment will be "0.93 (93%)". The in-house / outsourced production ID is information that identifies the created in-house / outsourced production candidate (i.e., a candidate plan that indicates which process of which product is to be outsourced and the rest is to be in-house produced). In this embodiment, the skill sufficiency level takes a value in the range of "0" to "1", and the higher the value, the better. The method of calculating the skill sufficiency level will be described later.

[0032] FIG. 10 is an explanatory diagram showing an example of the skill-task compatibility information 222 held by the outsourcing planning system 10 according to the embodiment of the present invention.

[0033] The skill work compatibility information 222 is information for managing information that compares the personnel composition by skill rank for each process and the workload composition by work compatibility rank when the outsourcing plan is executed, and for example, as shown in Fig. 10, consists of information on in-house / outsourcing ID 1001, process 1002, start date 1003, end date 1004, skill rank 1005, number of people 1006, work compatibility rank 1007, and workload 1008. In the skill work compatibility information 222 in Fig. 10, for example, the first row shows that when the outsourcing plan specified by the in-house / outsourcing ID "G100" is executed, in the "sheet metal" process from "10 / 1 to 10 / 31", the number of people with skill rank "A" is "5 (people)", and the workload of the corresponding work compatibility rank "A" is "650 (h)".

[0034] FIG. 11 is an explanatory diagram showing an example of the skill compatibility information 223 held by the outsourcing planning system 10 according to the embodiment of the present invention.

[0035] The skill compatibility information 223 is information for managing skill compatibility, which indicates the balance between the skilled personnel for each process and the work time for each work compatibility rank, based on the skill task compatibility information 222, and is composed of information on in-house / outsourcing ID 1101, process 1102, start date 1103, end date 1104, and skill compatibility 1105, as shown in FIG. 11 for example. In the skill compatibility information 223 in FIG. 11, for example, the top row indicates that when the outsourcing plan specified by the in-house / outsourcing ID "G100" is executed, the skill compatibility for the "sheet metal" process from "10 / 1 to 10 / 31" is "1.0". The skill compatibility takes any value in the range from "0" to "1", and the higher the value, the better. The method of calculating the skill compatibility will be described later.

[0036] FIG. 12 is an explanatory diagram showing an example of the in-house production / outsourcing determination result information 224 held by the outsourcing planning system 10 according to the embodiment of the present invention.

[0037] The in-house / outsourced production determination result information 224 is information for managing the results of determining the priority of products and processes to be in-house / outsourced based on the skill satisfaction information 221 and the skill suitability information 223, and is composed of information on an in-house / outsourced production ID 1201, a start date 1202, an end date 1203, and a determination result 1204, as shown in FIG. 12. In the in-house / outsourced production determination result information 224 in FIG. 12, for example, the first three rows indicate that the start dates and end dates of the outsourcing plans indicated by the in-house / outsourced production IDs "G100", "G110", and "G120" are all "10 / 1" and "10 / 31", respectively, and the respective determination results are "1.81", "1.71", and "1.78". Here, the larger the value of the determination result 1204, the better the outsourcing plan. The calculation method of the in-house / outsourced production determination result data will be described later.

[0038] FIG. 13 is an explanatory diagram showing an example of the in-house / outsourced production instruction information 225 held by the outsourcing planning system 10 according to the embodiment of the present invention.

[0039] The in-house / outsourced production instruction information 225 is information for managing information on in-house / outsourced production instructions for specific products and processes for the in-house / outsourced production determination result information 224, and for example, as shown in Fig. 13, includes information on an in-house / outsourced production ID 1301, a product ID 1302, production quantity 1303, a product classification 1304, a process 1305, a start date 1306, an end date 1307, in-house / outsourced production 1308, and work time 1309. In the in-house / outsourced production instruction information 225 in Fig. 13, for example, the first row indicates that the outsourcing plan instructed by an in-house / outsourced production ID "G100" includes outsourcing the "sheet metal" process of product ID "P100", product classification "X", and production quantity "1 (unit)" as "completed outsourcing" during the period "10 / 1 to 10 / 5" for a work time of "70 (h)". Here, outsourcing can be classified into various types, such as "completion outsourcing" which outsources all work in a given process, and "processing outsourcing" which outsources only a portion of the work. In this embodiment, "completion outsourcing" is defined as outsourcing all work hours, and "processing outsourcing" is defined as outsourcing a certain percentage of the work hours in a given process. The ratio of work hours in these outsourcing cases may be determined arbitrarily for each product and process.

[0040] FIG. 14 is an explanatory diagram showing an example of the work assignment information 226 held by the outsourcing planning system 10 according to the embodiment of the present invention.

[0041] The work allocation information 226 is information for managing the work allocation results of in-house products and processes after the outsourcing plan is executed, and for example, as shown in Fig. 14, includes information on in-house / outsourced production ID 1401, product ID 1402, process 1403, start date 1404, end date 1405, work suitability rank 1406, worker 1407, and skill rank 1408. In the work allocation information 226 in Fig. 14, for example, the top row indicates that after the outsourcing plan specified by the in-house / outsourced production ID "G100" is executed, the "sheet metal" process of the product "P100" is a work with a work suitability rank of "A" and is scheduled to be performed by worker "M100" who has skill rank "A" during the period "10 / 1 to 10 / 5".

[0042] Referring again to Fig. 2, the calculation unit 300 is for obtaining data required for calculation from the input / output unit 100 and the input information 210 of the storage unit 200, and outputting the processing result to the output information 220 of the storage unit 200, and is composed of a calculation processing unit 320 that actually performs the calculation processing, and a memory unit 310 that serves as a work area for the calculation processing in the calculation processing unit 320.

[0043] The memory unit 310 is for temporarily storing data acquired from the input / output unit 100 and the input information 210 of the storage unit 200, or the results of processing by the arithmetic processing unit 320.

[0044] The calculation processing unit 320 is composed of a data acquisition unit 321, a workload aggregation unit 322, a capacity surplus / deficiency determination unit 323, a domestic / foreign production candidate generation unit 324, a skill satisfaction calculation unit 325, a skill suitability calculation unit 326, a domestic / foreign production determination unit 327, a work allocation unit 328, and a display control unit 329.

[0045] The data acquisition unit 321 acquires information required for the processing of the calculation processing unit 320 from the input information 210 based on the information on the target period and planning unit (month, week, etc.) of the outsourcing plan input by the user from the input / output unit 100, and stores the information in the memory unit 310. The workload aggregation unit 322 calculates the products scheduled to be produced in the target period and the workload for each process from the production plan information 211 and the workload information 212, and aggregates the results by the planning unit. The capacity surplus / deficiency judgment unit 323 calculates the production capacity based on the workers for each process from the worker skill information 214, and compares the workload aggregation result to judge the excess or deficiency of the production capacity.

[0046] When a capacity surplus or deficiency is determined, the in-house / out-house production candidate generation unit 324 selects candidates for products and processes to be outsourced from the production plan information 211, or selects candidates for products and processes to be incorporated into in-house production from the outsourcing plan information 213, in order to eliminate the surplus or deficiency. The skill satisfaction calculation unit 325 calculates the ratio of the workload after in-house / out-house production to the target working time required for the skill development of the worker, from the training plan information 215. The skill suitability calculation unit 326 compares the workload by work suitability rank after in-house / out-house production with the personnel composition by worker skill rank, from the worker skill information 214 and the work suitability rank information 216.

[0047] The in-house / outsourced production determination unit 327 determines the priority of products and processes to be produced in-house or the priority of products and processes to be outsourced based on the skill sufficiency and skill suitability. The work allocation unit 328 allocates workers to products and processes to be produced in-house when in-house production and outsourcing are carried out according to the outsourcing plan, according to the work suitability rank and the level of worker skill. The display control unit 329 stores the results obtained, calculated, or determined by each of the above processing units in the output information 220, and displays them on the input / output unit 100.

[0048] Next, the operation of each function in the outsourcing planning system 10 of FIG. 2 will be described with reference to the flowchart shown in FIG.

[0049] First, the user checks whether there is a surplus or shortage in production capacity based on the in-house production plan and the outsourcing plan, and if a surplus or shortage is confirmed, selects the products and processes to be produced in-house and outsourced. In order to reflect this in the outsourcing plan, the user inputs information, for example, from an input screen shown in FIG. 15, and starts processing in the outsourcing plan system 10.

[0050] FIG. 15 is an explanatory diagram showing an example of an input screen displayed by the outsourcing planning system 10 according to the embodiment of the present invention.

[0051] The input screen 1500 shown in FIG. 15 is an example of a screen displayed by the input / output unit 100 of the outsourcing planning system 10, and includes a planning period input section 1501, an outsourcing planning unit input section 1502, a production capacity surplus / deficiency threshold input section 1503, and an execute button 1504.

[0052] The user can start the processing of the outsourcing planning system 10 by inputting or selecting the planning period, the outsourcing planning unit, and the threshold for determining whether the production capacity is insufficient or not from an input screen 1500 as shown in Fig. 15, for example, and clicking an execute button 1504. In this embodiment, as shown in Fig. 15, an example will be described below in which "10 / 1-12 / 31" is input as the planning period, "monthly" is selected as the outsourcing planning unit, and the production capacity surplus / deficiency threshold is input and selected to determine whether the production capacity is insufficient when "less than 0 (h)" and to determine whether the production capacity is insufficient when "200 (h) or more" is greater.

[0053] Next, the data acquisition unit 321 acquires information contained in the input information 210 based on the plan target period and the conditions of the subcontract plan unit input by the user from the input / output unit 100 such as a terminal, and stores the information together with the conditions in the memory unit 310 (S100). In this embodiment, the following description will be given assuming that the production plan information 211, the work man-hour information 212, the subcontract plan information 213, the worker skill information 214, the training plan information 215, and the work compatibility rank information 216 shown in Figs. 3 to 8 have been acquired as the input information 210.

[0054] Next, the workload aggregation unit 322 calculates the man-hours for each product and process scheduled to be produced during the target planning period from the production plan information 211 and the man-hours information 212, aggregates them by the outsourcing plan unit, and stores them in the memory unit 310 (S110). For example, in the production plan information 211 of FIG. 3, the "sheet metal" process of the product ID "P100" is planned to be worked on "10 / 1 to 10 / 5", which is within the target planning period. Furthermore, since the product classification of the product and process is "X" and the production quantity is "2 (units)", the workload aggregation unit 322 extracts the man-hours "70 (h)" from the man-hours information 212 of FIG. 4, and calculates it as "140 (h)" for the man-hours for two units. Furthermore, since the outsourcing plan unit is "monthly", the workload aggregation unit 322 aggregates the extracted work hours as "October (10 / 1 to 10 / 31)". The following description will be given on the assumption that the above process is performed for all product IDs and processes in the production plan information 211, resulting in the generation of the workload (time) information by process and month shown in Fig. 16.

[0055] FIG. 16 is an explanatory diagram showing an example of the workload information generated by the outsourcing planning system 10 according to the embodiment of the present invention.

[0056] 16 is made up of information on a process 1601, a start date 1602, an end date 1603, and a workload 1604. The process 1601 is information that identifies the type of process for each task, the start date 1602 and the end date 1603 indicate the start date and end date of each task, and the workload 1604 indicates the load of each task (e.g., the time required).

[0057] In the workload information 1600 shown in FIG. 16, for example, the top line indicates that the workload of the "sheet metal" process for "October (10 / 1 to 10 / 31)" is "5800 (h)".

[0058] Thereafter, the capacity excess / shortage determination unit 323 calculates the production capacity based on the workers for each process from the worker skill information 214, compares it with the workload data to determine the excess / shortage of the production capacity, and stores it in the memory unit 310 (S120). For example, the capacity excess / shortage determination unit 323 refers to the worker skill information 214 in FIG. 6 and extracts information that the worker with the worker ID "M100" is in charge of the "sheet metal" process. The capacity excess / shortage determination unit 323 similarly extracts the process information of other workers and sums up the number of skilled personnel for each process. Then, the production capacity for each process and month is calculated by accumulating the number of working days for each month and the working hours per working day, and the excess / shortage of the production capacity for each process and month is calculated by taking the difference between the production capacity and the workload tabulated in S110. It is assumed that the production capacity and excess / shortage for each process and month shown in FIG. 17 are calculated by the above process.

[0059] FIG. 17 is an explanatory diagram showing an example of production capacity and surplus / deficiency information generated by the outsourcing planning system 10 according to the embodiment of the present invention.

[0060] 17 includes information on a process 1701, a start date 1702, an end date 1703, a production capacity 1704, a workload 1705, and a surplus or shortage 1706. The process 1701, the start date 1702, the end date 1703, and the workload 1705 correspond to the process 1601, the start date 1602, the end date 1603, and the workload 1604 of the workload information 1600. The production capacity 1704 is the production capacity calculated in S120, and the surplus or shortage 1706 is the value obtained by subtracting the workload 1705 from the production capacity 1704.

[0061] 17, the top row shows, for example, that the production capacity for "October (10 / 1-10 / 31)" of the "sheet metal" process is "5600 (h)", and the workload data for that process / month is "5800 (h)", so a capacity shortage of "200 (h)" has been calculated. Furthermore, the capacity surplus / shortage determination unit 323 determines whether the production capacity is insufficient or not based on the threshold value specified on the input screen.

[0062] In the input screen of Fig. 15, it was specified that the production capacity is determined to be insufficient if it is "less than 0 (h)", so in the example of Fig. 17, the capacity surplus / deficiency determination unit 323 determines that the production capacity for "October" is insufficient for the "sheet metal" and "assembly" processes. Here, if there is no surplus or deficiency in production capacity, the processing flow ends, but if there is a surplus or deficiency, the process proceeds to S130.

[0063] Next, in order to eliminate the surplus or shortage, the in-house / outsourced production candidate generating unit 324 selects candidates for products and processes to be outsourced or candidates for products and processes to be in-house produced from the products and processes included in the production plan information 211, and stores them in the memory unit 310 (S130). In this embodiment, candidates for combinations of products and processes to be outsourced are selected from the products and processes scheduled to be produced in "October" for which the surplus or shortage of production capacity has been determined in the production plan information 211.

[0064] There are various outsourcing methods, such as "complete outsourcing" in which all the work of the relevant process is outsourced to an outsourcer, and "processing outsourcing" in which only a part of the work is outsourced. For example, in the production plan information 211 of FIG. 3, when one "sheet metal" process of a product ID "P100" with a product classification of "X" is outsourced for completion, outsourcing candidate data is generated as shown in the first row of FIG. 13, which includes the work hours of one product, "70 (h)" (see the work hours information 212 of FIG. 4). Similarly, when half the work hours of two "sheet metal" processes of a product ID "P110" are outsourced for processing, "35 (h)", which is half of the work hours of one product, "70 (h)", is outsourced for two products, so outsourcing candidate data is generated as shown in the third row of FIG. 13, which includes "70 (h)", which is the work hours for two products, of "35 (h)".

[0065] The in-house / outsourced production candidate generation unit 324 assigns the in-house / outsourced production IDs shown in the first column of Fig. 13 to these combinations of completion outsourcing and processing outsourcing, and manages them. Note that in this embodiment, a method of generating only outsourcing candidate data for insufficient production capacity has been shown, but for excess production capacity, candidate data for products and processes to be in-house produced can be similarly generated from the outsourcing plan information 213. Hereinafter, the data generated here will also be referred to as in-house / outsourced production candidate data.

[0066] In S130, data such as that shown in each row of Figure 13 is generated, but at this point these are candidates for in-house production or outsourcing plans and have not yet been stored in the in-house / outsourced production instruction information 225.

[0067] Next, the skill satisfaction calculation unit 325 calculates the skill satisfaction level by taking the ratio of the workload after internal and external production to the target working time required for the worker's skill development from the internal and external production candidate data and the development plan information 215, and stores the skill satisfaction level in the memory unit 310 (S140).

[0068] For example, in the training plan information 215 shown in Fig. 7, it can be seen that the training goal for the worker with worker ID "X100" is to work "140 (h)" in the "sheet metal" process during the target period of the outsourcing plan, "10 / 1 to 10 / 31". Similarly, by summing up the target working hours for "October" in each of the "sheet metal" and "assembly" processes, the target working hours for each process and month can be calculated.

[0069] On the other hand, the workload after in-house / outsourced production can be calculated by subtracting the work hours of the outsourced products and processes generated in the process of S130 from the monthly workload of each process tallied in the process of S110.Then, the skill satisfaction level is calculated by calculating the ratio of the workload after in-house / outsourced production to the monthly target working hours of each process.The following explanation assumes that the monthly skill satisfaction level of each process shown in Figure 9 has been calculated by the above process.

[0070] For example, in the combination of outsourcing candidates shown in Figure 9 with the in-house / outsourced production ID "G100," the target working hours for skill development in the "sheet metal" process from "10 / 1 to 10 / 31" is "5600 (h)," while the workload after in-house / outsourced production is "5200 (h)," so the ratio of these, "0.93 (93%)," is calculated as the skill sufficiency. Note that if the workload after in-house / outsourced production is greater than the target working hours required for skill development, the skill sufficiency is "1.0 (100%)." Therefore, skill sufficiency is defined as a value between 0 and 1.

[0071] Thereafter, the skill suitability calculation unit 326 calculates skill suitability by comparing the workload for each task suitability rank after in-house / outsourced production and the personnel composition for each worker skill rank from the worker skill information 214 and task suitability rank information 216, and stores the calculated skill suitability in the memory unit 310 (S150). The skill suitability is an index that indicates whether the workload for each task suitability rank, which indicates the task difficulty of each process of each product, matches the personnel composition ratio for each skill rank, which indicates the level of the worker's skill.

[0072] FIG. 18 is a flowchart showing an example of a process for calculating skill compatibility by the outsourcing planning system 10 according to the embodiment of the present invention.

[0073] The method of calculating the skill compatibility will be described in detail with reference to FIG.

[0074] First, the skill compatibility calculation unit 326 counts the number of workers by skill rank with reference to the worker skill information 214 (S1500). Here, the following description will be given on the assumption that the number of worker IDs is counted by process and skill rank shown in the worker skill information 214 of Fig. 6, and the data shown in Fig. 19 is obtained.

[0075] FIG. 19 is an explanatory diagram showing an example of personnel information by skill rank generated by the outsourcing planning system 10 according to the embodiment of the present invention.

[0076] For example, personnel information by skill rank 1900 shown in Fig. 19 includes information on a process 1901, a start date 1902, an end date 1903, a skill rank 1904, and a number of people 1905. For example, the first to third rows of personnel information by skill rank 1900 shown in Fig. 19 indicate that the number of workers with skill ranks "A", "B", and "C" in the "sheet metal" process from "10 / 1 to 10 / 31" is "5 (people)", "15 (people)", and "20 (people)", respectively.

[0077] Next, the skill suitability calculation unit 326 reads candidate data of products and processes to be produced in-house and outsourced for each in-house production ID generated by the in-house / outsourced production candidate generation unit 324 (S1510). Here, an example of reading the data of the in-house / outsourced production candidates shown in FIG. 13 will be described.

[0078] Then, the skill suitability calculation unit 326 judges whether all the in-house / outside production IDs have been read, and if so, ends this processing flow, and if not, proceeds to processing of S1530 (S1520). Here, the first in-house / outside production ID "G100" has been read from the in-house / outside production candidate data in Figure 13, and since the others have not yet been read, proceeds directly to the next processing.

[0079] Thereafter, the skill suitability calculation unit 326 tabulates the workload by task suitability rank based on the in-house / outsourced production candidate data, the production plan information 211, the task man-hour information 212, and the task suitability rank information 216 (S1530). Here, the tasks of "complete outsourcing" and "processing outsourcing" in the in-house / outsourced production candidate data shown in Fig. 13 are subtracted from the production plan information 211 shown in Fig. 3. On the other hand, when the outsourcing plan is changed back to in-house production, the tasks are added.

[0080] For example, in the in-house / outsourcing candidate data in FIG. 13, one unit of the "sheet metal" process for product ID "P100" in in-house / outsourcing ID "G100" is to be sent to "completed outsourcing", so in the production plan information 211 in FIG. 3, it is determined that only one unit of the two units to be produced for the product and process will be produced in-house. Next, for the product and process, the work hours "70 (h)" are obtained from the work hours information 212 shown in FIG. 4, and the work suitability rank "A" is obtained from the work suitability rank information 216 shown in FIG. 8. These processes are performed for all products and processes of the in-house / outsourcing ID, and the workload is tallied by work suitability rank. The following explanation assumes that the workload by work suitability rank for the "sheet metal" process shown in the first to third rows of FIG. 10 is tallied by this process.

[0081] Here, it is assumed that the skill ranks of workers "A, B, C" correspond to the task suitability ranks "A, B, C", respectively. That is, for example, a task suitability rank of "A" for a certain process of a certain product indicates that the skill of a worker with skill rank "A" is suitable for the difficulty of that process of that product. This indicates, for example, that it has been determined that assigning a worker with skill rank "A" to the task of that process of that product is desirable for the training of that worker (for example, for improving skills).

[0082] Next, the skill compatibility calculation unit 326 calculates the skill compatibility for the in-house / outside production ID by calculating the composition ratio of the number of workers by skill rank and the workload by work compatibility rank (S1540). In this embodiment, the number of workers by skill rank and the workload by work compatibility rank are expressed as vectors, and an example of calculating the skill compatibility by the inner product of these is described. First, the personnel composition vector of the skill rank and the workload vector of the work compatibility rank are expressed by the following formulas (1) and (2), respectively.

[0083]

number

[0084] where m 1 ,m 2 ,m 3are the number of workers with skill ranks A, B, and C, respectively, and w 1 ,w 2 ,w 3 are the workload values ​​for task suitability ranks A, B, and C, respectively. For example, in the "sheet metal" process of the internal / external production ID "G100" in Figure 10, the number of people with skill ranks A, B, and C is 5, 15, and 20, respectively, so (m 1 =5,m 2 =15,m 3 In addition, the workloads of the task compatibility ranks A, B, and C are 650h, 1950h, and 2600h, respectively, so (w 1 =650,w 2 =1950,w 3 = 2600). The skill compatibility Sa is defined as being calculated by normalizing these vectors and taking the inner product, and is expressed by the following formula (3).

[0085]

number

[0086] As a result, the skill compatibility Sa takes values ​​between 0 and 1, and the closer it is to 1, the better the match between the personnel composition ratio by skill rank and the workload composition ratio by work compatibility rank, indicating that it is possible to allocate work necessary for skill development. For example, when calculating the skill compatibility for the "sheet metal" process of the in-house / outsourced production ID "G100" in Figure 10 above, Sa = 1.0. This is because the personnel composition ratio by skill rank (5:15:20 = 1:3:4) and the workload composition ratio by work compatibility rank (650:1950:2600 = 1:3:4) for that product / process match.

[0087] The skill compatibility Sa is an index of the degree of agreement between the personnel composition ratio by skill rank and the composition ratio of the workload (i.e., man-hours) by task compatibility rank. The above-mentioned inner product of normalized vectors is one example of a method for calculating the degree of agreement, and the degree of agreement may be calculated by another method.

[0088] Thereafter, the skill suitability calculation unit 326 returns to the process of S1510, acquires the next in-house / outsourced production ID, and reads the candidate data for the product and process to be in-house / outsourced. Similarly, the following description will be given on the assumption that the process of S1510 to S1540 is executed for all in-house / outsourced production IDs of the in-house / outsourced production candidate data shown in Fig. 13, resulting in the data on the number of people by skill rank and the workload by task suitability rank shown in Fig. 10, and the calculation result of the skill suitability shown in Fig. 11.

[0089] Next, returning to the processing flow of FIG. 1, the in-house / outsourced production determination unit 327 determines the priority of the products and processes to be in-house / outsourced based on the skill sufficiency and the skill suitability, and stores the determined priority in the memory unit 310 (S160). In this processing, the in-house / outsourced production determination unit 327 calculates the priority of the products and processes to be in-house / outsourced production candidates by calculating the product of the skill sufficiency and the skill suitability for each in-house / outsourced production ID and process, and aggregating the results by in-house / outsourced production ID. This priority is the priority when each in-house / outsourced production candidate is adopted as an actual outsourcing plan. For example, the highest priority may be assigned to the in-house / outsourced production candidate with the largest sum of the product of the skill sufficiency and the skill suitability. In this case, an outsourcing plan to be actually applied may be generated according to the in-house / outsourced production candidate to which the highest priority is assigned.

[0090] For example, in the skill satisfaction level in Fig. 9 and the skill suitability level in Fig. 11, in the "sheet metal" process of the in-house / outsourced production ID "G100", the skill satisfaction level is "0.93" and the skill suitability level is "1.0", so the in-house / outsourced production determination unit 327 calculates the product of these as "0.93". Similarly, in the "assembly" process, the skill satisfaction level is "0.98" and the skill suitability level is "0.90", so the in-house / outsourced production determination unit 327 calculates the product of these as "0.88".

[0091] The domestic / foreign production determination unit 327 then sums these values ​​to calculate the domestic / foreign production determination result for the domestic / foreign production ID "G100" as "1.81." The following explanation assumes that a similar process is performed for other domestic / foreign production IDs, and the domestic / foreign production determination result data shown in Figure 12 is obtained.

[0092] Next, the task allocation unit 328 allocates workers to in-house products and processes in the case of in-house / out-sourced production according to the task suitability rank and the level of worker skill, and stores the allocation in the memory unit 310 (S170). In this process, the task allocation unit 328 first extracts candidates for products and processes to be in-house produced or outsourced for each in-house / out-sourced production ID from the in-house / out-sourced production candidate data in FIG. 13, and adds the products and processes to the production plan information 211 (FIG. 3) if they are to be changed from outsourcing to in-house production, and subtracts them from the production plan information 211 if they are to be outsourced. Then, the task allocation unit 328 allocates workers to products and processes in the production plan information 211 in the order of the highest rank based on the task suitability rank information 216 in FIG. 8 and the skill rank of the worker skill information 214 shown in FIG. 6. The following description is based on the assumption that the task allocation result data shown in FIG. 14 is obtained by the above process.

[0093] Finally, the display control unit 329 stores the respective data stored in the memory unit 310, namely the skill satisfaction level, the workload by work suitability rank, the skill suitability level, the in-house / outsourcing determination result, the in-house / outsourcing candidates, and the work allocation result, in skill satisfaction level information 221, skill work suitability information 222, skill suitability information 223, in-house / outsourcing determination result information 224, in-house / outsourcing instruction information 225, and work allocation information 226, and displays them on the input / output unit 100 (S180).

[0094] FIG. 20 is an explanatory diagram showing an example of an output screen by the outsourcing planning system 10 according to the embodiment of the present invention.

[0095] The in-house / outsourcing determination result display section 2001 at the top of the output screen 2000 displays in table form, for each in-house / outsourcing ID, the skill sufficiency by process in the skill sufficiency information 221 in Fig. 9, the skill suitability by process in the skill suitability information 223 in Fig. 11, and the determination result in the in-house / outsourcing determination result information 224 in Fig. 12. This screen displays a list by in-house / outsourcing ID, but has the function of sorting and filtering according to the skill sufficiency, skill suitability, and in-house / outsourcing determination result (total column) of each process. This makes it possible to check in-house / outsourcing plans in descending order of the determination result, or to check only in-house / outsourcing plans with skill sufficiency or skill sufficiency above a certain value, thereby enabling efficient outsourcing plan judgment.

[0096] Next, the skill satisfaction display section 2003 on the left side of the second row of this screen displays a graph of the ratio of the target working time for each process and the workload after in-house / outside production in the skill satisfaction information 221 of Fig. 9. Furthermore, the skill suitability display section 2004 on the right side of the second row displays a graph of the personnel composition ratio by skill rank and the workload ratio by work suitability rank in the skill / work suitability information 222 of Fig. 10, compared by process. This screen shows a state in which the in-house / outside production ID "G100" is selected in the in-house / outside production judgment result displayed in the in-house / outside production judgment result display section 2001 and the "display details" button 2002 is operated. This makes it possible to visually confirm the skill satisfaction and skill suitability, making it easier to understand the relationship between personnel and workload after in-house / outside production planning.

[0097] In addition, the in-house / outsourced production instruction list display section 2005 in the third row of this screen displays a list of the data of the in-house / outsourced production instruction information 225 in Fig. 13. This enables the user to grasp the products and processes that should be produced in-house and the products and processes that should be outsourced, and to give instructions as a specific outsourcing plan.

[0098] Finally, the task allocation result display section 2006 on the fourth row of this screen displays a list of the data of the task allocation information 226 in Fig. 14. This enables the user to grasp the task allocation results according to the skill ranks of the workers for the in-house products and processes, and to give instructions as a specific production plan.

[0099] In this embodiment, when calculating the production capacity in the process of S120, the production capacity is calculated based on the working hours per working day regardless of the worker skill rank, but the working hours may be corrected depending on the process and skill rank. For example, in the worker skill information 214 of FIG. 6, the personnel with skill ranks "A", "B", and "C" in the "sheet metal" process may be counted as 1.1, 1.0, and 0.9 people's production capacity, respectively, and the personnel with skill ranks "A", "B", and "C" in the "assembly" process may be counted as 1.2, 1.0, and 0.8 people's production capacity, respectively. This makes it possible to define a production capacity that is closer to the actual situation, and to accurately determine whether the production capacity is excessive or insufficient.

[0100] In this embodiment, the allocation results of products, processes, and work to be produced in-house or outsourced are displayed in a list in the process of S180, but these results may be automatically reflected as the production plan information 211 and the outsourcing plan information 213. This makes it possible to formulate and correct production and outsourcing plans in a timely manner, leading to improved accuracy of these plans.

[0101] In this embodiment, the priority of the products and processes as candidates for in-house / outsourced production is calculated based on the skill sufficiency and skill suitability, but the priority may be calculated without using the skill sufficiency. For example, the in-house / outsourced production determination unit 327 may calculate the priority of the products and processes as candidates for in-house / outsourced production by tallying up the skill suitability for each in-house / outsourced production ID.

[0102] The system according to the embodiment of the present invention may be configured as follows, for example.

[0103] (1) An outsourcing planning system (e.g., outsourcing planning system 10) having a calculation unit (e.g., calculation unit 300) and a storage unit (e.g., storage unit 200), in which the storage unit stores production plan information (e.g., production plan information 211) indicating a production volume of a product and a process required for production, work man-hour information (e.g., work man-hour information 212) indicating the man-hours of work for each process for the production volume of each product, worker skill information (e.g., worker skill information 214) indicating the level of work skill for each process of a plurality of workers, and work suitability rank information (e.g., work suitability rank 803) indicating the level of work skill of workers suitable for work for each process of each product. The calculation unit holds compatibility information (e.g., work compatibility rank information 216), and generates multiple in-house / out-sourcing candidates (e.g., multiple in-house / out-sourcing candidates included in outsourcing plan information 213) based on the production plan information, including information indicating the process and quantity of products to be produced in-house and the process and quantity of products to be outsourced (e.g., S130), and calculates skill compatibility (e.g., skill compatibility 1105 included in skill compatibility information 223) indicating the degree of compatibility between the process, labor hours, and work skills of workers that are suitable for the work of each process of the products to be produced in-house, and the number of workers for each work skill, based on each in-house / out-sourcing candidate (e.g., S150).

[0104] This makes it possible to plan in-house and outsource production that takes into account the degree of difficulty of tasks according to the skill level of workers, even in factories that produce a wide variety of products in small quantities. As a result, even in manufacturing sites where workers have a wide range of skills, it becomes possible to assign workers to products and processes with a level of difficulty that is appropriate for their training, making it possible to efficiently realize multi-skilled workers.

[0105] (2) In the above (1), the calculation unit identifies the product and process to be outsourced based on the in-house / outsourced production candidate with the highest skill suitability.

[0106] This makes it possible to plan in-house and outsourced production taking into account the difficulty of the work based on the skill level of the workers.

[0107] (3) In the above (1), the calculation unit determines the priority of the selection of each in-house / outsourced production candidate used to identify the products and processes to be outsourced according to the level of skill compatibility (e.g., S160).

[0108] This makes it possible to plan in-house and outsourced production taking into account the difficulty of the work based on the skill level of the workers.

[0109] (4) In (1) above, the calculation unit, based on the production plan information and work man-hour information, aggregates the man-hours for the processes of products to be produced in-house for each candidate for in-house / outsourced production for each work skill value of workers suitable for the work of each process (e.g., S1530), aggregates the number of multiple workers for each process and work skill (e.g., S1500), and calculates skill compatibility so that the higher the match between the ratio of man-hours for each work skill value of workers suitable for the work of each aggregated process and the ratio of the number of workers for each aggregated process and work skill, the higher the skill compatibility (e.g., S1540).

[0110] This allows the degree of match between the worker's skill level and the difficulty of the work for each candidate for in-house or out-sourcing to be appropriately evaluated.

[0111] (5) In (1) above, the memory unit further retains training plan information (e.g., training plan information 215) for each process and worker that indicates the target value of the time that a worker will be engaged in work for the process in order to train the worker, and the calculation unit calculates a skill satisfaction level that indicates the degree of satisfaction of the total work hours of each process to be in-house produced based on each in-house / outsourcing candidate relative to the total of the target engagement times for each process for multiple workers (e.g., S140), and determines the selection priority of each in-house / out-sourcing candidate to be used to identify products and processes to be outsourced depending on the level of skill suitability and skill satisfaction level (e.g., S160).

[0112] This makes it possible to create plans for in-house and out-sourcing that take into account both the work time required to achieve the worker training plan and the level of difficulty of the work according to the worker's level of proficiency, even in factories that produce a wide variety of products in small quantities.As a result, even in manufacturing sites where workers have a wide range of skills, it becomes possible to assign workers to products and processes with a level of difficulty appropriate for their training, making it possible to efficiently realize multi-skilled workers.

[0113] (6) In (5) above, the calculation unit calculates the skill satisfaction so that when the sum of the work hours for each process based on each internal or external work candidate is not smaller than the sum of the target engagement times for each process for multiple workers, the skill satisfaction level becomes maximum, and when the sum of the work hours for each process based on each internal or external work candidate is smaller than the sum of the target engagement times for each process for multiple workers, the higher the ratio of the sum of the work hours for each process based on each internal or external work candidate to the sum of the target engagement times for each process for multiple workers, the closer the skill satisfaction level becomes to the maximum value.

[0114] This makes it possible to appropriately evaluate the degree to which each candidate for in-house or out-house production has enough working hours to achieve the worker training plan.

[0115] (7) In (5) above, the calculation unit calculates the product of the skill suitability and skill sufficiency for each process, and determines the selection priority of each in-house / outsourced production candidate used to identify the product and process to be outsourced so that the higher the sum of the products of the skill suitability and skill sufficiency of each process of the product to be in-house produced among the in-house / outsourced production candidates, the higher the priority.

[0116] This makes it possible to create plans for in-house and outsourced production that take into account both the amount of work time required to achieve the worker training plan and the degree of difficulty of the work based on the worker's level of skill.

[0117] (8) In (1) above, the calculation unit identifies products and processes to be produced in-house based on the skill suitability, and assigns workers having work skills at a level suitable for the identified products and processes to be produced in-house (e.g., S170).

[0118] This makes it possible to appropriately assign tasks to workers, taking into consideration both the task time required to achieve the worker's training plan and the task difficulty according to the worker's level of skill.

[0119] (9) In the above (1), the calculation unit generates work compatibility information based on at least one of the difference between the standard work time and the actual work time in each process of each product, the frequency of appearance of parts, and the number of machining processes per part.

[0120] This allows the difficulty of the task to be appropriately evaluated according to the worker's level of skill.

[0121] (10) In (9) above, the calculation unit generates work compatibility information so that when the actual work time for each process of each product is longer than the standard work time, the work skill of a suitable worker will be higher; the lower the frequency of appearance of a part, the higher the work skill of a suitable worker will be; and the more processing processes there are per part, the higher the work skill of a suitable worker will be.

[0122] This allows the difficulty of the task to be appropriately evaluated according to the worker's level of skill.

[0123] The present invention is not limited to the above-mentioned embodiment, and various modifications are included. For example, the above-mentioned embodiment has been described in detail for better understanding of the present invention, and is not necessarily limited to those having all the configurations described. Also, it is possible to replace a part of the configuration of one embodiment with the configuration of another embodiment, and it is also possible to add the configuration of another embodiment to the configuration of one embodiment. Also, it is possible to add, delete, or replace a part of the configuration of each embodiment with another configuration.

[0124] In addition, the above-mentioned configurations, functions, processing units, processing means, etc. may be realized in part or in whole by hardware, for example, by designing them as integrated circuits. In addition, the above-mentioned configurations, functions, etc. may be realized in software by a processor interpreting and executing a program that realizes each function. Information such as programs, tables, files, etc. that realize each function can be stored in a storage device such as a non-volatile semiconductor memory, a hard disk drive, or an SSD (Solid State Drive), or in a computer-readable non-transitory data storage medium such as an IC card, an SD card, or a DVD.

[0125] In addition, the control lines and information lines are those considered necessary for the explanation, and not all control lines and information lines in the product are necessarily shown. In reality, it can be considered that almost all components are connected to each other. [Explanation of symbols]

[0126] 10 Outsourcing Planning System 100 Input / output section 200 Storage section 210 Input information 211 Production planning information 212 Work Hours Information 213 Subcontract planning information 214 Worker Skills Information 215 Development Plan Information 216 Work Compatibility Rank Information 220 Output Information 221 Skills sufficiency information 222 Skill Work Compatibility Information 223 Skill compatibility information 224 Internal and external production judgment result information 225 Internal and external production instruction information 226 Work Allocation Information 300 Arithmetic section 310 Memory 320 Processing Unit 321 Data Acquisition Department 322 Workload Tabulation Unit 323 Ability Excess / Deficiency Judgment Department 324 Internal and external production candidate generation unit 325 Skills Fulfillment Calculation Department 326 Skill Compatibility Calculation Department 327 Domestic and Foreign Production Judging Department 328 Work Allocation Department 329 Display control section

Claims

1. An outsourcing planning system having a calculation unit and a storage unit, the storage unit holds production plan information indicating the production volume of products and the processes required for production, work man-hour information indicating the man-hours required for each process of each product, worker skill information indicating the level of work skill for each process of a plurality of workers, work compatibility information indicating the level of work skill of workers suitable for each process of each product, and training plan information indicating, for each process and each worker, a target value for the time that the worker will be engaged in the work of the process in order to train the worker, The calculation unit is Calculating the man-hours of each process of the product as workload information based on the production plan information and the man-hours information; determining whether the production capacity of each process is insufficient or excessive based on the worker skill information and the workload information; When it is determined that there is a production capacity surplus or deficiency, by selecting candidates for products and processes to be produced in-house or candidates for products and processes to be outsourced so as to eliminate the production capacity surplus or deficiency of each process, a plurality of in-house / outsourced production candidates including information indicating the process and quantity of the product to be produced in-house and the process and quantity of the product to be outsourced are generated; Calculating a skill satisfaction level indicating a degree of satisfaction of a total of work man-hours for each process to be in-house produced based on each of the in-house / out-work candidates with respect to a total of target working hours for each process of the plurality of workers; Based on the production plan information and the work man-hour information, the man-hours of the processes of the products to be produced in-house in each of the in-house / outsourced production candidates are tallied for each value of the work skill of the worker suitable for the work of each of the processes; The number of the plurality of workers is counted for each of the processes and work skills; Calculating a skill compatibility level indicating a degree of agreement between the ratio of the man-hours for each of the aggregated work skill values ​​of the workers suitable for each of the processes and the ratio of the number of workers for each of the aggregated processes and work skills; An outsourcing planning system characterized by determining the priority of selection of each of the in-house and outsourcing candidates used to identify products and processes to be outsourced depending on the level of the skill suitability and the skill sufficiency.

2. The outsourcing planning system according to claim 1, The outsourcing planning system is characterized in that the calculation unit determines the priority of selection of each of the in-house and outsourcing candidates used to identify products and processes to be outsourced based on the level of skill suitability.

3. The outsourcing planning system according to claim 1, The calculation unit is When the total of the work man-hours of each process based on each of the in-house and out-of-house production candidates is not smaller than the total of the target working hours of each process of the plurality of workers, the skill satisfaction degree becomes a maximum value, An outsourcing planning system characterized in that, when the total amount of work hours for each process based on each of the in-house / outsourced production candidates is smaller than the total amount of target working hours for each process for the multiple workers, the skill satisfaction level is calculated so that the higher the ratio of the total amount of work hours for each process based on each of the in-house / outsourced production candidates to the total amount of target working hours for each process for the multiple workers, the closer the skill satisfaction level is to the maximum value.

4. The outsourcing planning system according to claim 1, The outsourcing planning system is characterized in that the calculation unit calculates the product of the skill suitability and the skill sufficiency for each process, and determines the priority of selection of each of the in-house / outsourced production candidates used to identify products and processes to be outsourced so that the priority is higher the larger the sum of the products of the skill suitability and the skill sufficiency of each process of the products to be in-house produced among the in-house / outsourced production candidates.

5. The outsourcing planning system according to claim 1, The calculation unit is Identifying products and processes to be produced in-house based on the skill compatibility; An outsourcing planning system characterized by assigning to the identified in-house products and processes, the workers having the work skills level appropriate for the products and processes.

6. The outsourcing planning system according to claim 1, The calculation unit generates the work compatibility information based on at least one of the difference between standard work time and actual work time in each process of each product, the frequency of appearance of parts, and the number of processing processes per part.

7. The outsourcing planning system according to claim 6, The calculation unit is When the actual work time is longer than the standard work time in each process of each product, the work skill of the suitable worker is high, The lower the frequency of appearance of the part, the higher the work skill of the suitable worker; An outsourcing planning system, characterized in that the work compatibility information is generated so that the greater the number of machining processes per part, the higher the work skill of the suitable worker.

8. An outsourcing planning method executed by a computer system having a calculation unit and a storage unit, comprising: the storage unit holds production plan information indicating the production volume of products and the processes required for production, work man-hour information indicating the man-hours required for each process of each product, worker skill information indicating the level of work skill for each process of a plurality of workers, work compatibility information indicating the level of work skill of workers suitable for each process of each product, and training plan information indicating, for each process and each worker, a target value for the time that the worker will be engaged in the work of the process in order to train the worker, The outsourcing planning method includes: a step in which the calculation unit calculates a work-hour for each process of a product as workload information based on the production plan information and the work-hour information; a step of the calculation unit determining whether the production capacity of each process is insufficient or excessive based on the worker skill information and the workload information; a step of generating a plurality of in-house / out-house production candidates including information indicating the process and quantity of the product to be in-house produced and the process and quantity of the product to be outsourced by the calculation unit, when it is determined that there is a surplus or deficiency in production capacity, by selecting candidates for products and processes to be in-house produced or candidates for products and processes to be outsourced so as to eliminate the surplus or deficiency in production capacity of each of the processes; a step of the calculation unit calculating a skill satisfaction degree indicating a degree of satisfaction of a total of work man-hours of each process to be in-house produced based on each of the in-house / out-house production candidates with respect to a total of target working hours of each process of the plurality of workers; The calculation unit counts the man-hours of processes of products to be produced in-house for each of the candidates for in-house / outsourced production based on the production plan information and the man-hour information, for each value of the work skill of a worker suitable for each of the processes; a step in which the calculation unit counts the number of the plurality of workers for each of the processes and work skills; a step of the calculation unit calculating a skill compatibility degree indicating a degree of agreement between the ratio of the man-hours for each of the collected work skill values ​​of the workers suitable for each of the processes and the ratio of the number of the workers for each of the collected processes and work skills; and a step of determining a priority of selection of each of the in-house / outsourced production candidates used to identify products and processes to be outsourced based on the level of the skill suitability and the level of the skill sufficiency, by the calculation unit.

Images