JP2022137616A - Production planning device and production planning method - Google Patents

Abstract

To provide a system and a method for planning by obtaining the absorption ability for an organization from its work results.SOLUTION: A production planning device implements planning which includes: retaining skill rank information of each operator, absorption ability information that is necessary work ability per production process of a product corresponding to a skill rank, case information per product, work amount information by product process, actual production information per product process, and product process responsible information that is information on a main responsible organization engaged in work per product process; calculating and retaining maximum performance and minimum performance absorption ability based on the main responsible organization, the overall organization and the actual production per product process, according to information related to operators constituting the main responsible organization and the overall organization, the skill rank information, and the actual production information; calculating a necessary work amount for each case from the case information and the work amount information by product process; and calculating and outputting, as production planning information, the necessary work amount by product process for producing a product related to each case, by using any of the selected absorption abilities.SELECTED DRAWING: Figure 1

Description

The present invention relates to a production planning device and a production planning method.

Industrial production of products is carried out according to a production plan formulated based on various conditions. Production plans are classified according to their time span.

According to JIS Z 8141: 2001 (3302) of the Japanese Industrial Standards (JIS), production schedules are divided into major schedules, medium schedules, and minor schedules. According to its definition, the large-scale schedule is a long-term production plan that serves as the master for the production schedule, and determines the monthly production volume. The middle schedule determines the production schedule for each department based on the long schedule. In the sub-schedule planning, a daily work schedule is determined in a shorter span.

Also, ANSI/ISA-95.00.01-2010 (IEC 62264-1 Mod) defined by the American National Standards Institute (ANSI), Marcela Vegetti and Gabriela Henning: "ISA-88 Formalization. A Step Towards its Integration with the ISA- 95 Standard", Proceedings of the 6th Workshop on Formal Ontologies meet Industry, Rio de Janeiro, Brazil, 22-SEP-2014, etc., production planning is divided into planning and scheduling. In comparison with JIS Z 8141: 2001 (3302) mentioned above, the former corresponds to the large and medium schedules, and the latter corresponds to the minor schedules.

In this specification, hereinafter, the large schedule plan and medium schedule plan will be referred to as planning, and the small schedule plan will be referred to as scheduling.

Conventionally, in carrying out a production plan, a work group was formed in a manufacturing process requiring work by workers, and the product groups and processes to be in charge of each work group were determined. When planning, the value obtained by multiplying the number of people belonging to the work team by the working hours for each day is used as the daily digestion capacity for the product group and process, and the production plan is drawn up. In addition, when scheduling, work is assigned based on the empirical knowledge of the team leader of the work team and the capabilities of the team members. The production plan has been drafted based on the digestion capacity automatically calculated from other work results.

Here, the "digestive capacity" means the ability of a specific worker or group of workers to perform a specific work such as the final assembly of the product A. When a worker with a certain capacity performs the final assembly of product A, the digestion capacity is doubled when two workers with the same capacity perform the work.

Under such circumstances, for example, in Patent Document 1, when making a production plan, in order to make it possible to make an executable production plan while considering the workplace placement of workers, when making a production plan, For production workplaces, consider the period in which production capacity is fixed at each workplace, the period in which workers can be flexible between workplaces, and the period in which production capacity does not need to be considered when hiring new personnel. It is described to create a production plan that can be executed while making adjustments (summary).

Further, in Patent Document 2, based on screw tightening work skill information of each worker in consideration of work experience and the number of work mistakes, and screw tightening work difficulty information of each work process defined quantitatively, In order to plan the allocation of screw tightening workers to each work process, screw tightening work skill information consisting of worker information, model information, work process information, parts information, work experience information, work error information, and work rank is collected. The step of generating and recording is performed by the screw tightening work skill information recording unit 10, and the generated screw tightening work skill information, the degree of difficulty in each work process of each model, the production plan of each model, and each worker The worker placement information recording unit 20 executes a step of generating worker placement information for each work process of each model whose production is planned based on the attendance status of each worker. It is described that the worker rearrangement information recording unit 30 executes a step of generating worker rearrangement information when rearrangement is required due to progress delay (abstract).

Patent Literature 1 proposes a technique capable of determining the surplus or insufficient digestion capacity of each work group and making a plan considering personnel accommodation (assistance) between work groups. Further, Patent Document 2 proposes a technique of automatically generating skill information for each worker based on work performance, and of arranging or scheduling workers based on this.

JP 2007-213294 A JP 2007-164756 A

However, planning based on work performance is not taken into consideration in the techniques described in Patent Documents 1 and 2.

In planning, unlike scheduling, each work group seeks the ability to digest the product groups and processes that the organization is in charge of as an organization, past short-term support results for other teams, and Considering the work in other teams that belonged to different skill determination methods, grasping the total digestive capacity (supportable digestive capacity) of workers in one's own organization in other organizations, and personnel accommodation between work teams It is necessary to formulate a plan that considers (support). However, the techniques described in Patent Documents 1 and 2 do not take the above into consideration.

In general, support is the lending and borrowing of personnel between organizations, and is carried out based on coordination between organization heads and the exchange of personnel expenses. As such, planning for support is done during planning, rather than scheduling, which is done a few days before manufacturing execution. At this time, if the digestive capacity of the organization is not correctly understood, the process of the own organization will be delayed due to the support from one organization to another organization, and even if the support is received, the other organization will not meet expectations. There are times when it is not possible to make effective coordination of support, such as not being able to do the work.

Accurately grasping the digestive capacity of an organization becomes difficult manually in proportion to the number of people in the organization, the diversity of work, and the lengthening of the evaluation period. In addition, it is difficult to understand the digestive capacity of an organization only by automatically collecting and analyzing individual work results, and it is possible to capture positive and negative synergistic effects such as compatibility between workers belonging to an organization that changes from moment to moment. It is necessary. In addition, if there is a deviation in the ability to be judged by analyzing work performance due to daily psychological and physical factors, it is not practical in field operations, and long-term analysis is difficult to grasp the actual state of the organization's ability. Therefore, it is necessary to automatically analyze at an appropriate time span such as monthly, and these needs are not considered in the technologies described in Patent Documents 1 and 2. Conceivable.

In addition, especially for large products, not only the work of individual workers but also the work of teams is required, and it is necessary to correctly grasp not only the skills of individual workers but also the ability to digest as an organization for planning. 1, it is considered that the technology described in Patent Document 2 does not take this into account.

In addition, on-site installation and other business trips are generally coordinated during planning, such as one week before the start of work. , the process in the factory is delayed, etc., and it is not possible to make effective business trip adjustments.

In addition, without an accurate grasp of the organization's ability to digest, it is not possible to carry out sales activities based on an accurate grasp of medium- to long-term surplus capacity for product groups and processes, and for certain product groups, orders that exceed the organization's capacity are not possible. As a result, the order volume for a certain product group fell below the organization's capacity, resulting in a surplus of personnel. There is also the problem of not being able to

SUMMARY OF THE INVENTION The present invention has been made in view of these problems. One object is to provide a method.

In order to solve the above-mentioned problems, one of the inventions of the present application is a production planning apparatus having a processor and a storage device connected to the processor, wherein the storage device is used for work involved in the production of products. Skill rank information, which is an index indicating the superiority or inferiority of each worker's skill set for each worker, Digestive capacity information, which is the work capacity required for each production process of the product corresponding to the skill rank, and correspondence for each product Project information, which is information about the delivery date of the product, work amount information for each product process, which is information about the amount of work associated with each process of the product, and production results, which is information about the past production period for each process of the product. Information and product process manager information that is information of the main responsible organization engaged in work for each product process, and the processor stores information about workers who make up the main responsible organization and the entire organization engaged in production; Based on the skill rank information and the production performance information, for each product process, the digestion capacity of the main responsible organization, the digestion capacity of the entire organization, and the maximum actual digestion capacity and minimum actual digestion capacity based on the production performance information are calculated. calculating the required work amount for each item included in the item information from the item information and the work amount information for each product process; Calculate and produce the amount of work required for each product process for the production of the products related to each of the aforementioned projects using either the capacity selected from the maximum actual capacity and minimum actual capacity based on information. It is a production planning device that executes planning processing to be output as plan information.

According to the one aspect of the invention, it is possible to accurately obtain the digestive capacity of an organization from work results, and to use the digestive capacity for planning.

Problems, configurations, and effects other than those described above will be clarified by the following description of the embodiments.

FIG. 1 is a block diagram showing a configuration example of a production planning system according to one embodiment of the present invention. FIG. 2 is an explanatory diagram showing an example of the skill rank table in this embodiment. FIG. 3 is an explanatory diagram showing an example of the rank/skill definition table in this embodiment. FIG. 4 is an explanatory diagram showing an example of the item storage table in this embodiment. FIG. 5 is an explanatory diagram showing an example of the product/process master in this embodiment. FIG. 6 is an explanatory diagram showing an example of the actual production table in this embodiment. FIG. 7 is an explanatory diagram showing an example of the product group/process/group relation table in this embodiment. FIG. 8 is an explanatory diagram showing an example of a performance calculation result table in this embodiment. FIG. 9 is an explanatory diagram showing an example of a production planning table in this embodiment. FIG. 10 is an explanatory diagram showing an example of the surplus capacity table in this embodiment. FIG. 11 is an explanatory diagram showing an example of the sales candidate product table in this embodiment. FIG. 12 is an explanatory diagram showing an example of the individual ability calculation result table in this embodiment. FIG. 13 is an explanatory diagram showing an example of an input screen output by the production planning system of this embodiment. FIG. 14 is an explanatory diagram showing an example of a surplus capacity/sales candidate product calculation result output screen output by the production planning system of the present embodiment. FIG. 15 is an explanatory diagram showing an example of a load accumulation result output screen output by the production planning system of this embodiment. FIG. 16 is a flow chart showing an example of processing of a capacity calculation program in the production planning system of this embodiment. FIG. 17 is a flow chart showing an example of processing of a plan/surplus relationship main program in the production planning system of this embodiment. FIG. 18 is a flow chart showing an example of processing of the production planning program in the production planning system of this embodiment. FIG. 19 is a flow chart showing an example of processing of a product group/process-specific surplus capacity calculation program in the production planning system of the present embodiment. FIG. 20 is a flow chart showing an example of processing of a sales candidate product identification program in the production planning system of this embodiment.

An embodiment for carrying out the present invention will be described below with reference to the drawings.

<Production planning system>
First, the configuration of the production planning system according to this embodiment will be described. FIG. 1 is a block diagram showing a configuration example of a production planning system 1 according to this embodiment.

The production planning system 1 is a system for obtaining the digestion capacity as an organization based on work results and using the digestion capacity for planning. The production planning system 1 includes a production planning device 100 configured as a general computer, and communication enabling mutual communication between the production planning device 100 and other external devices 190, an intranet, the Internet, etc. It has a network 180 . The external device 190 includes another information processing device belonging to the same company or organization as the production planning system 1, a mobile terminal such as a smart phone possessed by the head of an organization engaged in production, or a worker belonging to the system.

<Production planning device>
The production planning device 100 is an information processing device that implements the main functions of the production planning system 1, and includes a storage device 110, a processor 150 composed of a central processing unit (CPU), a memory 155, an input device 160, It has an output device 165 , a recording medium reading device 170 and a communication interface 175 .

The storage device 110 is a device that obtains the digestion capacity as an organization from the work results and stores information necessary for planning in the production plan, and is composed of a storage device such as a hard disk (HDD). . The storage device 110 may be a semiconductor drive (SSD) using flash memory or the like.

The storage device 110 includes a skill rank table 121, a rank/capability definition table 122, a product/process master 123, a case table 124, a production performance table 125, as tables for storing data used for executing planning. Product Group/Process/Group
It has at least a relationship table 126 , a capacity calculation result table 131 , a production plan table 132 , a surplus capacity table 133 , a sales candidate product table 134 and an individual capacity calculation result table 135 .

The storage device 110 also stores a capacity calculation program 141, a plan/surplus related main program 142, a production planning program 143, a surplus capacity by product group/process, as programs 140 for causing the processor 150 to execute the planning of this embodiment. It has at least a calculation program 144 and a sales candidate product identification program 145 .

The processor 150 is an arithmetic device for executing the programs described above. The processor 150 also performs management functions as a computer of the production planning apparatus 100, such as data input/output.

The memory 155 is a storage device that stores programs to be executed by the processor 150 and data necessary for executing the programs, and is composed of RAM, ROM, flash memory, and the like.

The input device 160 is a device for inputting information necessary for planning, such as a keyboard, mouse and microphone.

The output device 165 is a device for outputting an input/output interface screen or the like. be.

The recording medium reading device 170 is a device for reading information from a portable storage medium having portability. Examples of portable storage media include flexible disks, CD-ROMs, DVD-ROMs, semiconductor memories, servers, and communication paths such as LANs. The recording medium reading device 170 may be built in the production planning device 100 or may be externally attached.

The production planning device 100 may be realized by, for example, one arbitrary information processing device, or may be distributed and realized by a plurality of arbitrary information processing devices. All or part of the production planning device 100 can also be configured by a virtual computer.

Also, part or all of the production planning device 100 may be realized as hardware by means of circuits or the like.

<Program implemented in the production planning device>
Next, a program for realizing the functions of the production planning device 100 of this embodiment will be described.

The capacity calculation program 141, the plan/surplus relationship main program 142, the production planning program 143, the product group/process-specific surplus capacity calculation program 144, and the sales candidate product identification program 145 are read from the storage device 110 into the memory 155 by the processor 150. Each program is executed by the processor 150 .

16, 17, 18, 19, and 20, respectively, and will be described later. Note that the above program is, for example, an application program that can be executed on an operating system (OS) program.

The above program can be input from the communication network 180 via the communication interface 175 and installed in the storage device 110, for example.

<Table>
Next, a table for storing data used by the program 140 of the production planning apparatus 100 will be described.

・Skill rank table 121
FIG. 2 is an explanatory diagram showing an example of the skill rank table 121 in this embodiment.

The skill rank table 121 in FIG. 2, which is skill rank information, is a worker/product group automatically calculated from the work performance described in Japanese Patent Application No. 2020-028712 filed on February 21, 2020, for example. A table for registering a skill level for each process, and is composed of items such as worker ID 210, product group 220, process 230, skill rank 240, and judgment date 250. It should be noted that all of the contents disclosed in Japanese Patent Application No. 2020-028712 are incorporated herein by reference.

The worker ID 210 is information for identifying a worker belonging to an organization such as a work group. The product group 220 and the process 230 are information for identifying the product group and process that the worker with the corresponding worker ID 210 was in charge of. The skill rank 240 is automatically calculated based on some predefined criteria, for example, the working time of the relevant product group/process, or the work identified by the corresponding worker ID 210 determined and input by the head of the organization. It is information for specifying the skill rank of the person, product group and process. The determination date 250 indicates the date when the corresponding skill rank 240 was determined.

It should be noted that the skill rank table 121 is input with updated values on a monthly basis. The skill rank table 121 can be said to store automatically updated skill map information in the sense that the skill of each worker is mapped by automatic update. The data of the skill rank table 121 may be periodically input from a mobile terminal or the like held by the head of the organization.

・Rank/ability definition table 122
FIG. 3 is an explanatory diagram showing an example of the rank/skill definition table 122 in this embodiment.

The rank/ability definition table 122 in FIG. 3, which is digestive capacity information, is a table that defines digestive capacity according to the product group/process/skill rank/latest skill determination date. , digestive capacity [man-days] 340, latest skill judgment date 350, and the like. Product group 310 , process 320 , and skill rank 330 are similar to skill rank table 121 . Digestive capacity [man-day] 340 is the amount of work that can be performed by a worker having a corresponding skill rank for a specific product group/process based on past work results. In the latest skill judgment date 350, information indicating how long ago the latest judgment date 350 of the skill rank 330 is from today is registered for each corresponding product group/process. "Today" means the day on which the production planning device 100 executes planning. The older the latest skill determination date 350 is, the lower the ability to digest due to the deterioration of the skill, even if there is the same skill rank.

・Item table 124
FIG. 4 is an explanatory diagram showing an example of the case table 124 in this embodiment.

The item table 124 of FIG. 4, which is item information, is a table that stores information about items to be planned, and includes items such as item ID 410, product code 420, and delivery date 430. FIG. The item ID 410 is information for uniquely identifying the received item. The product code 420 is information for identifying a specific product such as the product group 220 included in the corresponding item. The due date 430 is information indicating the due date of the corresponding item ID 410 . From this case table 124, it is possible to obtain the amount of work that will occur in response to the product code until the delivery date for each case.

・Product/process master 123
FIG. 5 is an explanatory diagram showing an example of the product/process master 123 in this embodiment.

The product/process master 123 shown in FIG. 5, which is the work amount information for each product process, is a table storing information related to the manufacture of each product. day] 550, profit margin by product [%] 560, profit amount by product [million yen] 570,
and sales by product [million yen] 580 items. Product group 520 is information for identifying the product group that includes product code 510 . Product name 530 is information for identifying the product name corresponding to product code 510 . For each product code 510, the required processes are stored in the process 540 for each record. The amount of work required for each process is stored in the amount of work [man-days] 550 . In addition, the profit rate corresponding to each product code 510 is shown in Profit Rate by Product [%] 560, the amount of profit is shown in Profit Amount by Product [million yen] 570, and the amount of sales is shown in Sales Amount by Product [million yen] 580. Stored. The unit of calculation for each item of the amount of work 550, the profit rate by product 560, the profit amount by product 570, and the sales amount by product 580 may be appropriately determined for ease of use. The profit rate, profit amount, and sales amount corresponding to the product code 510 can be grasped as economic efficiency index information as indicators relating to the economic efficiency of manufacturing the product.

Here, the product process literally means an individual process when producing a certain product, but in the present application, the product includes not only individual products but also a product group consisting of a plurality of related products. A process also includes various resources that are input or used in the process. Resources will be discussed later.

In addition, in the product/process master 123, if the profit rate changes depending on the optional items even if the product code is the same in high-mix low-volume production or complete build-to-order production, the average value for each product code, etc. may be stored.

・Production result table 125
FIG. 6 is an explanatory diagram showing an example of the actual production table 125 in this embodiment.

The actual production table 125 shown in FIG. 6, which is the actual production information, is a table that stores the information on the actual production, and consists of items such as an item ID 610, a product code 620, a process 630, a production start date and time 640, and a production end date and time 650. be done. For each item ID 610, a product code 620 indicating the product related to the item and a process 630, which is the process in which the work was performed, are stored for each record. In addition, the manufacturing start date and time of the corresponding process are stored in the manufacturing start date and time 640, and the manufacturing end date and time are stored in the manufacturing end date and time 650, respectively. The manufacturing start date and time 640 and the manufacturing end date and time 650 can be input and recorded from a portable terminal or the like as the external device 190 in FIG. Workers can input production performance information such as manufacturing start and end dates and times in each process from their own mobile terminals, or similar production performance information can be sent to work managers such as work team leaders on their mobile terminals in a timely manner. By inputting to the production planning device 100 from an external device 190 such as a PC, the record of the production result table 125 can be updated in a timely manner.

・Product group/process/team relation table 126
FIG. 7 is an explanatory diagram showing an example of the product group/process/group relation table 126 in this embodiment.

The product group/process/team relationship table 126 in FIG. 7, which is the product process responsible information, is a master table that associates the product group/process with the main team that is the group of workers who are mainly in charge of the process. It consists of items such as group 710 , process 720 , and primary team 730 . When a team other than the main team in charge of a certain product group/process is in charge of the work, the latter team in charge is positioned as a worker group that supports the corresponding work.

・Capacity calculation result table 131
FIG. 8 is an explanatory diagram showing an example of the capacity calculation result table 131 in this embodiment.

The capacity calculation result table 131 in FIG. 8 is a table for storing the output results of the capacity calculation program 141, and includes product group 810, process 820, digestive capacity main team 830, overall digestive capacity [man-day] 840, digestion It is composed of items such as past performance_maximum [man-days] 850 and past performance_minimum [man-days] 860 of digestive capacity. For each product group/process, the digestive capacity of the main team in charge is the digestive capacity main team [man-day] 830, and the digestive capacity of the entire organization including the main team and other teams is the total digestive capacity [man-day] 840. In addition, the daily maximum and minimum digestive capacity of the product group/process calculated from the actual production results will be changed to the past actual digestive capacity_maximum [person-days] 850 and the past actual digestive capacity_minimum [person-days] 860. , respectively. Although the unit of counting for each item of digestive capacity is man-days, other units of counting may be used.

・Production plan table 132
FIG. 9 is an explanatory diagram showing an example of the production planning table 132 in this embodiment.

The production plan table 132 of FIG. 9, which is production plan information, is a table for storing the output results of the production plan formulation program 143, which is a subroutine in the plan/surplus related main program 142. Item ID 910, process 920, date It consists of items such as a day 930 and a work amount [man-day] 940 . In each record of the production planning table 132, the amount of work required on each date when the work is performed is stored as the amount of work [man-days] 940 for each product group/process for each project. Man-days are used as the counting unit for the work load item, but other counting units may be used.

・Surplus capacity table 133
FIG. 10 is an explanatory diagram showing an example of the surplus capacity table 133 in this embodiment.

The surplus capacity table 133 in FIG. 10 is a table for storing the output results of the product group/process surplus capacity calculation program 144, which is a subroutine in the plan/surplus related main program 142. The product group 1010, process 1020, period 1030, and surplus capacity [
Person days] (average) 1040 items. For each product group/process, the average surplus capacity for each period specified in advance, for example, for each week, is stored in the column of surplus capacity [man-day] (average) 1040 in units of man-days.

・Sales Candidate Product Table 134
FIG. 11 is an explanatory diagram showing an example of the sales candidate product table 134 in this embodiment.

The sales candidate product table 134 in FIG. 11 is a table for storing the output results of the sales candidate product identification program 145, which is a subroutine in the plan/surplus relationship main program 142, and includes a product group 1110, a product name 1120, and a producible quantity. 1130 and scheduled delivery date 1140. In the sales candidate product table 134, for each product specified by the product group 1110 and the product name 1120, based on the values of the surplus capacity table 133 in FIG. , and the scheduled completion date of the corresponding quantity are stored in the Producible Quantity 1130 and Scheduled Delivery Date 1140 columns, respectively.

・Individual ability calculation result table 135
FIG. 12 is an explanatory diagram showing an example of the individual ability calculation result table 135 in this embodiment.

The individual capacity calculation result table 135 of FIG. 12 is a table for storing the output results of the capacity calculation program 141, which is a subroutine in the plan/surplus relationship main program 142, and includes a group 1210, a product group 1220, a process 1230, and a person in charge type. 1240 and digestive capacity [man-day] 1250. In this way, in the individual capacity calculation result table 135, for each product group and process, for each team, whether or not the person is the main person in charge and digestion capacity [man-days] are displayed. ] 1250, and in each record, the individual digestion capacity corresponding to the product group/process in charge is recorded for each team. If a certain team is not in charge of the corresponding product group/process, "secondary" data is stored in the item of charge type 1240 . According to this table, if the digestive capacity of the worker in charge of a certain product process is insufficient, or if a worker in another organization who is not in charge of the main charge but is in charge of sub-charge is in charge of the work, that is, support is accepted in a certain product process. If you do, you can acquire the digestion ability related to that support.

<Input/output interface of production planning device>
Next, an input/output interface that allows a user to input information and present information to the user via the input device 160 and the output device 165 of the production planning apparatus 100 will be described.

・Input screen 2000
FIG. 13 is an explanatory diagram showing an example of an input screen 2000 output by the production planning device 100 of this embodiment.

An input screen 2000 in FIG. 13 is a screen displayed by the output device 165 of the production planning apparatus 100, for example, in order to accept input of parameters for planning by the user of the production planning apparatus 100. FIG. The input screen 2000 includes a production planning button 2001 and a close button 2002 . When the production planning button 2001 is operated (for example, pressed using a mouse or a touch sensor), the plan/surplus related main program 142, which will be described later, is executed based on the information input to the input screen 2000. FIG. When the close button 2002 is operated, the input screen 2000 is closed.

Also displayed on the input screen 2000 are a capacity line selection section 2010, a sales candidate product identification threshold value setting section 2020, and a sales candidate product identification order setting section 2030 that receive input of parameters for planning. The performance line selection unit 2010 and the sales candidate product specific order setting unit 2030 operate the input device 160 by the user who refers to the input screen 2000, and operate, for example, a radio button from the displayed options. One parameter can be selected. The sales candidate product specific threshold value setting unit 2020 allows the user who refers to the input screen 2000 to operate the input device 160 to input a numerical value, for example, an integer. How to use these parameters will be described later with respect to the description of the capacity calculation program 141 and sales candidate product identification program 145 .

Here, the capacity line is a concept that serves as an indicator of what kind of premises are used to set the digestion capacity for a certain product group/process. In this embodiment, there are 4 levels of digestion capacity corresponding to the maximum and minimum in the past work results, digestion capacity when the main team in charge is working, and digestion capacity when the entire upper organization including the main team is involved in the work. It is configured so that it can be selected from types. As for the capacity line selection unit 2010, for example, in the planning of work in the initial stage or several months ahead, past performance_minimum is selected for planning, thereby underestimating the digestion capacity and managing risk. If this occurs, we can think of ways to plan according to the situation, such as selecting past results_maximum for planning. Also, as a result of planning, if there is a delay in the delivery of the corresponding project with the ability of only the main team in charge to handle it, it is possible to select the entire organization and make a plan.

・Surplus Capacity/Sales Candidate Product Calculation Result Output Screen 3000
FIG. 14 is an explanatory diagram showing an example of a surplus capacity/sales candidate product calculation result output screen 3000 output by the production planning apparatus 100 of this embodiment.

A surplus capacity/sales candidate product calculation result output screen 3000 in FIG. It consists of elements such as a button 3002 and a close button 3003 . When the print button 3002 is operated, the contents of the output screen are printed in a predetermined format via the output device 165 . When the close button 3003 is operated, the surplus capacity/sales candidate product calculation result output screen 3000 is closed.

Each item of the product group/process/period surplus capacity calculation result column and the sales candidate product column, which are the message display portion, corresponds to the data stored in the surplus capacity table 133 and the sales candidate product table 134, respectively. That is, the data stored in the product group 3010, process 3015, period 3020, and surplus capacity [man-days] (average) 3025 of the surplus capacity table 133 correspond to the product group 1010, process 1020, period 1030, and surplus capacity. [person-days] (average)
In columns 1040, the data stored in the product group 3050, product name 3055, producible quantity 3060, and scheduled delivery date 3065 of the sales candidate product table 134 are the product group 1110, product name 1120, producible quantity 1130, and and the columns of the scheduled delivery date 1140 are output.

・Load accumulation result output screen 3100
FIG. 15 is an explanatory diagram showing an example of a load accumulation result output screen 3100 output by the production planning device 100 of this embodiment.

A load accumulation result output screen 3100 in FIG. 15 is a screen displayed for outputting the execution result of the production planning program 143, and is composed of elements such as a print button 3102 and a close button 3103. FIG. When the print button 3002 is operated, the output contents of the load accumulation result output screen 3100 are printed in a predetermined format via the output device 165 . When the close button 3003 is operated, the load accumulation result output screen 3100 is closed.

A parameter display portion 3110 displays selection items in the performance line selection portion 2010 of the input screen 2000 . The load heap graph display unit 3120 displays the load (required work volume) due to orders for each day of the planning period in a bar graph, and various capacity lines are identified by line types such as solid lines and dashed lines. Various capacity lines may be distinguished by using colors. In the present embodiment, for the sake of simplicity of explanation, the parameter display section 3110 displays the load accumulation result for each product group/process. is input or used, the parameter display section 3110 may be configured to output load accumulation results for each product group/process/resource or for each product group/resource. A combination of resources and processes for a single product may be adopted instead of a product group. Here, resources are equipment and facilities such as machine tools required to carry out work in each process, areas used for work, organizations engaged in work, workers, and work used Electricity, water, various gases, etc. are included.

<Data processing by production planning device>
Data processing executed by the production planning apparatus 100 using various tables and programs provided in the production planning apparatus 100 described above will be described below.

Data processing by the production planning device 100 includes a capacity calculation program 141, a plan/surplus relationship main program 142, a production planning program 143, a product group/process-specific surplus capacity calculation program 144, and a sales candidate product specification program shown in FIG. 145 is executed by the processor 150 using data stored in various tables. Data processing by each program will be described below with reference to flowcharts.

Data Processing by Capacity Calculation Program FIG. 16 is a flowchart showing an example of capacity calculation processing by the capacity calculation program 141 in the production planning device 100 of this embodiment.

This capacity calculation process is executed by the processor 150 according to the capacity calculation program 141 in order to calculate the digestion capacity for each organization such as a team according to a product group or process.

The performance calculation program 141 is set to be executed periodically, for example, every week, at a predefined timing. First, the processor 150 reads the skill rank table 121, the rank/ability definition table 122, the actual production table 125, and the product group/process/team relationship table 126 (S1610).

Based on the skill rank table 121, the rank/ability definition table 122, and the product group/process/team relationship table 126, the processor 150 calculates the digestion capacity [man-days] of the main team in charge for each product group/process, Digestive capacity [man-day] is calculated. The processor 150 also determines the digestion capacity [man-days] for each team/product group/process and whether or not the team is the main team in charge of the product group/process (S1620). Digestive capacity [person-days] of the main team in charge and digestive capacity of the entire organization [
[man-days] corresponds to the group in charge of digestive capacity [man-days] 830 and overall digestive capacity [man-days] 840 of the capacity calculation result table 131, respectively. In addition, the digestion capacity [man-days] for each team, product group, and process
And whether or not the product group/process is the main team in charge corresponds to the digestion capacity [person-days] 1250 and the type of charge 1240 of the individual capacity calculation result table 135, respectively.

Next, the processor 150 generates the production record table 125, the product group/process/team relationship table 1
26, the daily maximum and minimum values of the digestive capacity [man-day] for each product group and process are calculated (S1630). This is the digestive capacity past performance_maximum [man-day] 8 in the capacity calculation result table 131.
50 and Digestive Capacity Past Performance_Minimum [man-days] 860, respectively. In addition, the product group/
If the process requires a plurality of days, for example, two days, the process is proportionally divided, for example, by equal division by the number of days, and the digestion capacity is calculated as 0.5 [man-day].

Processor 150 outputs the calculation results in S1620 and S1630 to ability calculation result table 131 and individual ability calculation result table 135 (S1640).

In the data processing by the capacity calculation program 141 described above, the data used for calculating the surplus capacity later is stored in the capacity calculation result table 131 and the individual capacity calculation result table 135 .

Data Processing by Plan/Surplus Relationship Main Program 142 FIG. 17 is a flow chart showing an example of data processing by the plan/surplus relationship main program 142 in the production planning apparatus 100 of this embodiment.

This data processing should be subject to production plan planning, calculation of surplus capacity by product group/process, and products that should be produced with priority in terms of economic efficiency according to the surplus capacity, that is, order-receiving activities. Processor 150 executes according to plan/surplus relationship main program 142 to identify products. Execution of the plan/surplus relationship main program 142 is started by operating the production plan formulation button 2001 provided on the input screen 2000 illustrated in FIG.

First, processor 150 executes production planning program 143 (S1710). The production planning program 143 will be described later with reference to FIG.

Next, the processor 150 executes the product group/process surplus capacity calculation program 144 (S1720). The product group/process surplus capacity calculation program 144 will be described later with reference to FIG.

Next, processor 150 executes sales candidate product identification program 145 (S1730). The sales candidate product identification program 145 will be described later with reference to FIG.

By the processor 150 executing the above three subprograms, the user is presented with the surplus capacity/sales candidate product calculation result output screen 3000 illustrated in FIG. 14 and the accumulation result output screen 3100 illustrated in FIG. .

Data processing by each subroutine will be described below.

Data Processing by Production Planning Program 143 FIG. 18 is a flowchart showing an example of data processing by the production planning program 143 in the production planning device 100 of this embodiment.

This data processing is executed by the processor 150 according to the production planning program 143 for planning in the production plan.

When the processor 150 starts executing the production planning program 143, the input screen 2000 displays the result of the user's selection of the capacity line selection section 2010, the sales candidate product identification threshold value setting section 2020, and the sales candidate product identification order setting section 2030. is read (S1810).

Next, the processor 150 reads the case table 124, product/process master 123, and capacity calculation result table 131 (S1820).

The processor 150 performs planning based on the value of the group in charge of digestive capacity [person-days] 830 in the capacity calculation result table 131 (S1830). This corresponds to the case where the main team in charge is selected in the performance line selection section 2010 of the input screen 2000 . The reason why this process is performed prior to S1840 is that after confirming whether or not the amount of work can be digested by the main team in planning, if the main team is unable to complete the work, adjustments will be made to receive support from other teams, assuming overtime work. This is because it is common to perform operations such as re-planning with the maximum digestion capacity. The production planning device 100 of this embodiment also incorporates such general operation. As for the planning logic, the same logic as a commercially available general-purpose production planning tool may be adopted.

Next, in S1830, the processor 150 determines whether there is an item (order) that will cause a delay in delivery due to the shortage of the necessary work volume with the capacity of the main team in charge alone, or is excessive and the amount of work always falls below the digestion capacity during the planning period, planning is performed according to the capacity line selected in the capacity line selection section 2010 of the input screen 2000 (S1840). In the performance line selection unit 2010, when overall, past performance_maximum, and past performance_minimum indicating responsibility in the entire organization are selected, the overall digestion capacity [person-days] 840 in the capacity calculation result table 131, Planning is carried out based on the values of past actual digestive capacity_maximum [man-days] 850 and past actual digestive capacity_minimum [man-days] 860. In the performance line selection unit 2010, when the group in charge is selected, S1840 is omitted because there is no need to redo the planning.

In S1840, when the capacity line selection unit 2010 selects the whole group, the processor 150 selects a group having a digestion capacity that can be supported for the product group/process with insufficient capacity, according to the charge type in the individual capacity calculation result table 135. One is taken out of the records in which "secondary" is stored in the item 1240. If it is determined that the lack of digestion ability can be replenished by the selected team's digestion ability [man-day] 1250 and that the selected team will not cause a delivery delay, the amount to be supported by the team The planning result is the result of subtracting the digestion capacity [man-days] of the above from the digestion capacity of the product group/process that the group is mainly in charge of. If there is a delay in the delivery date for the above team, it is examined whether another team that can be supported can be selected to compensate for the lack of digestion ability in the same way, or whether the delivery delay will occur. Although the delivery delay does not occur for the selected team, if the shortfall cannot be compensated for by the team's digestion capacity [man-day] 1250, other teams that can be supported are added one by one and examined in the same way. . In addition, at this time, regarding the combination of the main person in charge and the sub-in-charge who will be in support, or the combination of the sub-in-charges, it is also possible to configure the program in advance so that it is not possible to combine combinations that are desirable not to be set due to the compatibility of the configuration worker. can.

Next, the processor 150 outputs the planning results of S1830 and S1840 to the production planning table 132 and ends the process (S1850).

According to the above data processing of the production planning program 143, for each product group and process included in a specific project, it is judged whether or not the digestion capacity is sufficient only by the main team, and if there is a shortage, the delivery date is delayed. Since support can be provided from other teams so that a failure does not occur, efficient planning suitable for the project is possible.

Data Processing Example by Product Group/Process Surplus Capacity Calculation Program 144 Next, a data processing example by the product group/process surplus capacity calculation program 144 will be described. FIG. 19 is a flow chart showing an example of data processing of the product group/process surplus capacity calculation program 144 in the production planning apparatus 100 of the present embodiment.

The data processing of the product group/process surplus capacity calculation program 144 is executed by the processor 150 according to the product group/process surplus capacity calculation program 144 in order to calculate the surplus capacity by product group/process.

The processor 150 calculates the necessary digestion capacity for each product group/process for a predetermined period of time, for example, up to three months from now, from the workload [man-days] 940 of the production plan storage table 132 (S1910). Specifically, the product group is determined using the product code 420 and delivery date 430 stored in the case table 124 and the work amount [man-days] 550 stored for the product code 510 in the product/process master 123 .・Calculate the required digestion capacity for each process.

Next, the processor 150 calculates the digestion capacity of the main team in charge for each product group/process for the certain period of time in the same manner as in S1910.
man-day] 830 (S1920).

Next, the processor 150 subtracts the overall digestive capacity by product group/process calculated in S1910 from the digestive capacity of the main team in charge by product group/process calculated in S1920. , daily average digestive capacity is calculated (S1930). This difference is the surplus capacity or insufficient digestion capacity for each product group/process during the certain period of time.

Finally, processor 150 outputs the calculation result in S1930 to surplus capacity table 133 and ends the process (S1940).

According to the above data processing of the product group/process surplus capacity calculation program 144, it is possible to accurately and quantitatively grasp the surplus digestion capacity or insufficient digestion capacity for each product group/process within a certain period from the present. .

Data Processing Example by Sales Candidate Product Identification Program 145 Next, a data processing example by the sales candidate product identification program 145 will be described. FIG. 20 is a flow chart showing an example of data processing by the sales candidate product specifying program 145 in the production planning device 100 of this embodiment.

In this process, the processor 150 calculates the individual capacity calculation result table 135 in order to specify which products should be sold for receiving orders according to the surplus capacity calculated by the product group/process surplus capacity calculation program 144 . Execute according to

When the processor 150 starts this data processing, it first refers to the surplus capacity table 133 and selects products whose surplus capacity, such as daily average, is equal to or greater than the threshold entered in the sales candidate product identification threshold setting 2020 on the input screen 2000. A group is extracted (S2010).

Next, the processor 150 refers to the product/process master 123 for the product group extracted in S2010, and specifies or orders the profit ratio, profit amount, and sales amount selected in the sales candidate product specific order setting 2030 on the input screen 2000. Enter dummy projects (orders) one by one in , do planning, and calculate when it can be completed within the capacity of the main team in charge. This is repeated for all main teams in charge of the product groups extracted in S2010 until the surplus capacity becomes 0 or less for the first time during a predefined planning period, for example, three months (S2020). The dummy project is the profit rate [%] 560 for each product code 510 stored in the product/process master 123, the profit amount [million yen] 570 for each product, and the sales amount [million yen] for each product. Based on 580 the input order is chosen.

When random is selected in the sales candidate product identification order setting 2030, the product/process master 123 is referred to for the product group extracted in S2010, and dummy projects (orders) are randomly input one by one to perform planning. Then, the calculation is repeated until the surplus capacity becomes 0 or less for the first time for all the main teams in charge of the product groups extracted in S2010. .

Finally, the processor 150 outputs the identification result in S2020 to the sales candidate product display field of the surplus capacity/sales candidate product calculation result output screen 3000, and ends the process (S2030).

According to the sales candidate product identification program 145 described above, it is possible to calculate the producible quantity of products with excellent economic indicators such as profitability based on the surplus digestive capacity obtained with high accuracy. Based on this, it is possible to develop efficient sales order activities.

As described above, the production planning device 100 of the present embodiment obtains the digestion capacity as an organization from the work results, thereby enabling effective planning, support coordination at the manufacturing site, business trip coordination, It becomes possible to support strategic sales activities.

In addition, the present invention is not limited to the above-described embodiments, and includes various modifications. For example, the above embodiments have been described in detail for better understanding of the present invention, and are not necessarily limited to those having all the configurations described.

Further, each of the above configurations, functions, processing units, processing means, and the like may be realized by hardware, for example, by designing a part or all of them using an integrated circuit. Moreover, each of the above configurations, functions, etc. may be realized by software by a processor interpreting and executing a program for realizing each function. Information such as programs, tables, files, etc. that realize each function is stored in storage devices such as non-volatile semiconductor memories, hard disk drives, SSDs (Solid State Drives), or computer-readable non-readable devices such as IC cards, SD cards, and DVDs. It can be stored on a temporary data storage medium.

Also, the control lines and information lines indicate those considered necessary for explanation, and not necessarily all the control lines and information lines are indicated on the product. In fact, it may be considered that almost all configurations are interconnected.

1: Production Planning System, 100: Production Planning Device, 110: Storage Device, 121: Skill Rank Table, 122: Rank/Capability Definition Table, 123: Product/Process Master, 124: Case Table, 125: Production Results Table 126: Product Group/Process/Team Relationship Table 131: Capacity Calculation Result Table 132: Production Plan Table 133: Surplus Capacity Table 134: Sales Candidate Product Table 141: Capacity Calculation Program 142: Plan/Surplus Relationship Main program, 143: Production planning program, 144: Product group/process-specific surplus capacity calculation program, 145: Sales candidate product identification program

Claims (13)

A production planning device having a processor and a storage device connected to the processor,
The storage device
Skill rank information, which is an index indicating the superiority or inferiority of each worker's skill set for each worker engaged in the production of products, and digestion capacity, which is the work capacity required for each production process of the product corresponding to the skill rank information, project information that is information related to the product delivery date associated with each product, work amount information by product process that is information on the amount of work associated with each product process, and past production for each product process Holds production performance information, which is information about the period, and product process person in charge information, which is information on the main responsible organization engaged in work for each product process,
The processor
Based on the information on workers constituting the main organization and the entire organization engaged in production, the skill rank information, and the production performance information, the digestion capacity of the organization in charge and the digestion capacity of the entire organization for each product process , calculating and holding the maximum actual production capacity and the minimum actual production capacity based on the production performance information;
Calculate the required work amount for each item included in the item information from the item information and the work amount information for each product process, and calculate the work amount required for each item included in the item information. Using either the digestion capacity selected from the actual digestion capacity and the minimum actual digestion capacity, the work amount for each product process required for the production of the product related to each case is calculated and output as production plan information. perform the planning process to
Production planning device. The skill rank information includes the latest skill rank determination date for the worker associated with the skill rank,
When the processor calculates the digestive capacity for each product process, the digestive capacity of each worker is weighted according to the information on the latest skill rank determination date.
The production planning device according to claim 1. The skill rank information is periodically updated based on the production performance information,
3. The production planning device according to claim 1 or 2. The skill rank information further holds each worker in association with a product process,
The production planning device according to claim 1. The processor displays the calculated required work amount for each item in a bar graph representing the required work amount for each work day for each product process, and the bar graph display shows the digestion capacity of the main organization in charge and the digestion capacity of the entire organization. display superimposed by line segments the level indicating the capacity, the maximum actual production capacity and the minimum actual production capacity based on the production performance information;
The production planning device according to claim 1. The product process includes processes corresponding to each product, resources corresponding to each product, resources corresponding to each product and process, processes corresponding to each product group, resources corresponding to each product group, and , which includes each resource corresponding to each product group and process,
The production planning device according to claim 1. The processor calculates, from the production plan information, the amount of work required in a predetermined period of time in the future for each product process in a predetermined time unit, and calculates the work amount in the predetermined period of time by using the digestion capacity of the main organization in charge. and calculating the difference obtained by subtracting the required work amount from the calculated digestion capacity, and outputting it as the surplus digestion capacity for each time unit in the fixed period;
The production planning device according to claim 1. economic index information including profit information related to the product is associated with the work amount information for each product process and held;
Based on the surplus digestion capacity and the work volume information for each product process, a process is executed for each product to calculate a production volume that can be produced by the surplus digestion capacity for each product, and Ranking and outputting the producible products according to the economic index information and the producible production amount,
The production planning device according to claim 7. Information on the production performance information, including information on the start and end of manufacturing of the product, is configured to be input from an external device communicably connected to the production planning device.
The production planning device according to claim 1. A production planning method executed by an information processing device having a processor and a storage device, the information processing device comprising:
Skill rank information, which is an index indicating the superiority or inferiority of each worker's skill set for each worker engaged in the production of products, and digestion capacity, which is the work capacity required for each production process of the product corresponding to the skill rank information, project information that is information related to the product delivery date associated with each product, work amount information by product process that is information on the amount of work associated with each product process, and past production for each product process Holds production performance information, which is information about the period, and product process person in charge information, which is information on the main responsible organization engaged in work for each product process,
Based on the information on workers constituting the main organization and the entire organization engaged in production, the skill rank information, and the production performance information, the digestion capacity of the organization in charge and the digestion capacity of the entire organization for each product process , calculating and holding the maximum actual production capacity and the minimum actual production capacity based on the production performance information;
Calculate the required work amount for each item included in the item information from the item information and the work amount information for each product process, and calculate the work amount required for each item included in the item information. Using either the digestion capacity selected from the actual digestion capacity and the minimum actual digestion capacity, the work amount for each product process required for the production of the product related to each case is calculated and output as production plan information. perform the planning process to
Production planning method. The product process includes processes corresponding to each product, resources corresponding to each product, resources corresponding to each product and process, processes corresponding to each product group, resources corresponding to each product group, and , which includes each resource corresponding to each product group and process,
The production planning method according to claim 10. The information processing device calculates the amount of work required in a certain future period from the production plan information by a predetermined time unit for each product process, and uses the digestion capacity of the main responsible organization to calculate the digestion capacity in the fixed period. Calculated by time unit, calculate the difference by subtracting the required work amount from the calculated digestion capacity, and output it as a surplus digestion capacity for each time unit in the fixed period;
The production planning method according to claim 10. economic index information including profit information related to the product is associated with the work amount information for each product process and held;
Based on the surplus digestion capacity and the work volume information for each product process, a process is executed for each product to calculate a production volume that can be produced by the surplus digestion capacity for each product, and Ranking and outputting the producible products according to the economic index information and the producible production amount,
The production planning method according to claim 12.

Images