JP4961640B2 - Material requirements planning processing method, material requirements planning processing system, material requirements planning processing program, and recording medium for the program - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to material requirement planning (MRP) processing technology for managing the flow, time, and productivity of material flow from material arrangement to product completion. The present invention relates to a material requirement planning processing system that can be performed.
[0002]
[Prior art]
A material requirements plan that calculates the materials required to manufacture a product and the total requirements, net requirements, and delivery times for that product from the product's configuration information, inventory information, etc. A processing system is used.
[0003]
In general, in such a material requirement planning processing system, individual items constituting a certain product are managed by data having a hierarchical structure of a tree structure.
[0004]
In the conventional typical material requirement plan (hereinafter referred to as MRP), the planning data for instructing the product arrangement is subjected to MRP expansion processing by Level by Level (Level by Level). Using the activity chain for managing the horizontal spread of the product and the level table for managing the depth of the product structure, one-stage development, chain registration, and extraction were repeated. The MRP expansion data is held in a two-dimensional table, although it is multidimensional information such as items for each order, delivery date, parent order, and final product.
[0005]
A conventional MRP expansion process will be described according to a specific example. FIG. 23 shows an example of the item configuration of the sample products A and O. The product structure is hierarchical. Products are at the highest level, and intermediate assemblies, parts, raw materials, etc. are at lower levels. The depth of the product structure is called the structure level.
[0006]
The item configuration data shown in FIG. 23 is managed by the item master shown in FIG. 24A and the configuration master shown in FIG. The low level is the lowest product level at which the item is used in the item structure. It is considered for all parts, not just one product. In the item structure shown in FIG. 23, item C exists at level 1 and level 2. Therefore, the low level of item C is “2”.
[0007]
The activity chain in the item master is blank in the initial state, and is used as a work area in the expansion process. This activity chain is used to manage the linkage of deployed items for each level in order to perform MRP level by level. The level table described later manages the depth of the product configuration, whereas the activity chain manages the horizontal spread of the product configuration. Register the activity chain when deploying subordinate items in one stage, and calculate the next item to be processed when performing MRP logic calculation (total requirement calculation, net requirement calculation, lot summary, lead time calculation) Extract from the chain.
[0008]
The basic unit in the composition master shown in FIG. 24B represents the composition quantity ratio between the parent item and the child item, the denominator represents the composition quantity of the parent item, and the numerator represents the composition quantity of the child item. That is, when the basic unit is n / m, n child items are required for m parent items.
[0009]
FIG. 25 is a flowchart of a conventional MRP expansion process. In step S100, plan data is input. FIG. 26 shows an example of plan data. The plan data indicates the production schedule, and as the plan data, information such as the company serial number, item code, number of plans, and planned delivery date is input for each product to be produced.
[0010]
In step S101, one-stage development is performed. FIG. 27 shows an example of the first one-stage development process. The level table is a management table for executing required amount calculation in order from the lowest level. Since the first item A is a planned item, only the activity chain registration process is performed here. First, the item code A is searched from the item master, and since the low level code of A is 0, the item code A is stored in the low level 0 column of the level table, and the activity chain of the item code A of the item master is included in the activity chain. , Register the initial value “*” of the level table.
[0011]
In step S102, it is determined whether the plan data has been completed. If there is unprocessed plan data, steps S100 and S101 are repeated. In the second one-stage development (S101), the process for the planned item O is performed in the same manner as the item A. When the item code O is searched from the item master, the low level of the item O is also 0. Therefore, as shown in FIG. 28, the item code O is registered in the low level 0 column of the level table and has been registered so far. Item code A is registered in the activity chain of item O.
[0012]
After processing all the plan data (production schedule), the items to be processed are extracted from the activity chain on a level-by-level basis (step S103), and MRP logic calculation (total requirement calculation, net requirement) (Calculation, lot summarization, lead time calculation) and develop one step to lower items (steps S104 to S108).
[0013]
For example, the item O currently registered in the low level 0 column of the level table is extracted (S103), the total required quantity: 150, the net required quantity: 150 (the inventory quantity is set to 0), and the start date : 2001/02/27 are calculated respectively (S105, S106). Next, a subordinate item of the item O is searched from the configuration master, and the item O is expanded to a subordinate item in one step (S107, S108).
[0014]
FIG. 29 shows an expansion image of the planned item O to the lower item P. The item code P is retrieved from the item master, and since the low level of the item P is 1, the initial value “*” registered in the low level 1 column of the level table is replaced with the activity chain of the item code P. Since the lead time of the item O is 1 day, the delivery date of the item O, that is, the delivery date of the lower item P is 2001/02/27.
[0015]
After the expansion to the item P is completed, the expansion to the item Q, which is the subordinate of the planned item O, is performed as with the item P. The item code Q is searched from the item master, and since the low level of the item Q is 1, the activity chain of the item P and the item code Q registered in the low level 1 column of the level table is exchanged. As a result, the progress of the expanded data becomes as shown in FIG.
[0016]
Thereafter, the expansion process is similarly repeated according to the flow (steps S103 to S108) shown in FIG. After the expansion processing to low level 1 is completed, the processing is repeated for low level 2 and low level 3 next. Since the low level 3 item T has no subordinate structure and the activity chain of the item T has an initial value “*” registered, after the expansion of the item T, step S104 in FIG. As a result of the determination, all the expansion processes are completed. This final state is shown in FIG.
[0017]
The developed data shown in FIG. 32A is obtained by adding necessary information such as a product number and a parent item to the developed data in the final state shown in FIG. Conventionally, for example, when creating an arrangement list of an item C from such a two-dimensional expansion data table, the item C is searched from all the expansion data shown in FIG. 32A, and the expansion result is extracted. Thus, an arrangement list of the item C as shown in FIG.
[0018]
[Problems to be solved by the invention]
In the above-described conventional material requirement plan, there is a problem that the efficiency of the expansion process is low because a join operation between a plurality of tables such as an item master, an item configuration master, and a level table must be frequently performed.
[0019]
In addition, when there is a plan change or when an abnormality in the schedule of the lower order occurs, it is necessary to restart the MRP development process from the beginning, which causes a problem that it takes time for the plan simulation.
[0020]
In addition, since the MRP expansion data is held in a two-dimensional table, there is a problem that it is necessary to re-aggregate from the two-dimensional table when referring to an item arrangement list, a product (plan) child order list, or the like. there were.
[0021]
SUMMARY OF THE INVENTION An object of the present invention is to solve the above-described problems and to efficiently execute a material requirement planning process at high speed.
[0022]
[Means for Solving the Problems]
In order to solve the above problems, the present invention sorts the parts table (item master) in advance in the low level order. That is, if the level is the same for each item, the item code is in ascending order, and if it is different, the order is assigned from the upper level to the lower level. The order given to the item is called the item ordinal number. In this way, each item that constitutes a product is assigned a number, ordinal number, and is used to link the product (planned item) to the parent item and link from the parent item to the child item. As a result, the master information necessary for the material requirement calculation can be converted into a tree-structured data structure with the highest item as a root node. Data having this new data structure is referred to herein as an integrated item configuration master. The integrated item structure master can be created from basic information necessary for material requirement planning such as product order, item master, and item structure information.
[0023]
further In the present invention, the part expansion data of the highest level item, which is the material requirement calculation source data that has been conventionally managed in a two-dimensional table format, includes the item ordinal number, the schedule, and the product number that is the product arrangement instruction data. Are stored in a multidimensional space format with each as the axis. This makes it possible to record the material requirement development data in a more realistic format, and realizes efficient calculation in the planning simulation in the material requirement calculation stage or in the process leading to the calculation result calculation. Specifically, the vertical axis (Y axis) is the item ordinal number, the horizontal axis (X axis) is the schedule (delivery date for each order), and the depth axis (Z axis) is the product number (multiple child orders with the same delivery date). To identify the number).
[0024]
The above means can be realized by a computer and a software program that is installed and executed on the computer, and the program is a computer-readable portable medium memory, semiconductor memory, hard disk, or other suitable recording medium. Can be stored.
[0025]
DETAILED DESCRIPTION OF THE INVENTION
FIG. 1 shows a configuration example of a material requirement plan processing system according to the present invention. The processing device 1 is a device composed of hardware such as a CPU and a memory, and a software program for material requirement planning processing.
[0026]
The integrated item configuration master creation processing unit 12 creates an integrated item configuration master 13 from the item master 10 and the configuration master 11. An image of the integrated item configuration possessed by the integrated item configuration master 13 is shown in FIG.
[0027]
The product structure is hierarchical. Products are at the highest level, and intermediate assemblies, parts, raw materials, etc. are at lower levels. The depth of the product structure is called the structure level. FIG. 2 (A) shows an example of the item structure of product A (item A) and product O (item O). Item A is composed of items B and C, and item B is items D and C. It is composed of. Similarly, the item O includes items P and Q. The item P includes items R and C, and the item R includes item T. The fraction n / m in the link connecting each item represents the basic unit (ratio of constituent quantities), the denominator represents the constituent quantity of the parent item, and the numerator represents the constituent quantity of the child item. That is, n child items are required for m parent items. When viewed from the depth of the hierarchy, items A and O are at level 0, items B, C, P, and Q are at level 1, items D, C, and R are at level 2, and item T is at level 3.
[0028]
The data of the item configuration shown in FIG. 2A is managed by the item master 10 shown in FIG. 3 and the configuration master 11 shown in FIG. The item master 10 manages correspondence information between the item code uniquely assigned to each item, the attribute (not shown) of the item, and the lead time. The lead time is information on the number of days and hours necessary to manufacture the item. The configuration master 11 is a table for managing the configuration information of each item, and holds data indicating what kind of child item each parent item is configured. It also holds basic unit information.
[0029]
Such a product configuration has the following characteristics.
(1) Only one configuration method is effective for one product.
(2) The same item can be used by multiple products or parent items. In other words, use as a common child item is permitted. For example, the item C is a common child item of the items A, B, and P.
(3) The composition level of common child items is not necessarily the same for all products, and varies from product to product. For example, the configuration level of item C is used at level 1 and level 2 for the product of item A, and is used at level 2 for the product of item O.
[0030]
In the prior art, the products of items A and O use separate configuration data in the format as shown in FIG. 2A even though there are common child items. Therefore, the composition level of common child items varies from product to product. Therefore, in the present invention, instead of using item configuration data for each product, integrated item configuration data as shown in FIG.
[0031]
Using the integrated item configuration data as shown in FIG. 2B has the following advantages.
(1) A unified configuration level can be used. This is called a low level. Generally, a product is at the highest level (level 0), but if the product (service parts) is used as a part of another product, the configuration level of the product should be changed to an appropriate lower level. is there. Of course, the sub-items of the product should also be changed to a lower level.
(2) Since only one item is stored as one object in the data structure, the memory usage area can be kept small.
[0032]
The integrated item configuration master 13 stores the data of the integrated item configuration shown in FIG. FIG. 5 shows an example of the data structure of the integrated item configuration master 13. As shown in FIG. 5, the integrated item configuration master 13 has a master structure that uses item ordinal numbers for defining relationships between items. That is, each item ordinal number has item code, low level, and link information using item ordinal numbers to the parent item and the child item.
[0033]
The item ordinal number is an index number uniquely assigned to each item rearranged in the item code order and the low level order. As a result, the parent-child relationship of each item can be replaced with the positional relationship of the item object, and the retrieval of the parent item and the child item in the expansion process can be performed very quickly. The item ordinal numbers may not necessarily be in the order of the item codes if they are given in the low level order. However, it is more convenient in terms of actual management to give the item codes in consideration of the order.
[0034]
The integrated item configuration master creation processing unit 12 creates an integrated item configuration master 13 as shown in FIG. 5 from the item master 10 and the configuration master 11. The processing of the integrated item configuration master creation processing unit 12 may be performed only once before the requested material requirement development.
[0035]
FIG. 6 shows a processing flowchart of the integrated item configuration master creation processing unit 12. First, in step S1, the item master 10 is collectively read and sorted in ascending order of item codes. Next, in step S2, an array of item ordinal numbers is created, and the order of item codes is set as the initial value of the item ordinal number. FIG. 7 shows an example in which the sorted item codes are associated with the array of item ordinal numbers by the processing of step S2.
[0036]
Next, in step S3, the configuration master 11 is read, and a subscript (position) in the item ordinal array of the parent item and child item of each configuration record is searched. FIG. 8 shows the state of the search.
[0037]
In step S4, the position of the child item searched in step S3 is registered in the child item list (child item ordinal number) of the parent item, and the position of the parent item is registered in the parent item list (parent item ordinal number) of the child item. In step S5, the low level of each item is calculated and set for each item. Through steps S4 and S5, master information having a new data structure as shown in FIG. 9 is created.
[0038]
In step S6, the item ordinal numbers of the data as shown in FIG. 9 are sorted again in ascending order of the low level. The result is shown in FIG.
[0039]
Finally, in step S7, the subscript of the array of item ordinal numbers stored in the parent item list and child item list of each item is updated. With the above processing, an integrated item configuration master 13 as shown in FIG. 5 is created as a final indication of the integrated item configuration as shown in FIG.
[0040]
Next, processing of the multidimensional space format expansion processing unit 14 will be described. The multi-dimensional spatial format expansion processing unit 14 is based on the integrated item configuration master 13 created by the integrated item configuration master creation processing unit 12, and at least the item ordinal number, the schedule regarding the delivery date, and the product number which is product arrangement instruction data. The material requirement expansion data in which the part data is expanded in the multi-dimensional space format with each axis as the axis is created, stored in the multi-dimensional space format expansion data storage unit 15, and the material requirement amount created in the multi-dimensional space format The requested material requirement information is output based on the expanded data.
[0041]
That is, in the conventional material requirement expansion processing, the material requirement expansion data is expanded into a two-dimensional table, whereas the multidimensional spatial format expansion processing unit 14 uses a multidimensional space format of three or more dimensions. One of the major features is to develop it. Here, as the multi-dimensional spatial format development data, the vertical axis (Y axis) is the item ordinal number, the horizontal axis (X axis) is the schedule (delivery date of each order), and the depth direction axis (Z axis) is the product number ( An example of a three-dimensional spatial format with a number for identifying multiple child orders with the same delivery date) will be explained. However, other elements such as manufacturer information and start date are added to the dimension, and the format is more than four dimensions. It is also possible to create deployment data with.
[0042]
FIG. 11 shows a processing flowchart of the multidimensional spatial format expansion processing unit 14, and FIGS. 12 to 17 show examples of expansion processing. FIG. 18 shows an example of the data structure of expanded items (elements) arranged in a multidimensional space. Hereinafter, the processing of the multidimensional spatial format expansion processing unit 14 will be specifically described with reference to these drawings.
[0043]
The multidimensional spatial format expansion processing unit 14 performs the material requirement expansion from the integrated item configuration master 13 in the order of the items. Here, as the plan data, as shown in FIG. 12, in-house product number = 001, item code = A, plan number = 100, plan delivery date = 2001/02/10, in-house product number = 002, item code = O. Suppose that the plan number = 150 and the plan delivery date = 2001/03/01.
[0044]
First, in step S10, the tree structure with each product order as a root node is initialized. Here, initialization of data in a three-dimensional space as shown in FIG. 12 is performed. Needless to say, data in the three-dimensional space can be easily managed as data in a three-dimensional array inside the computer.
[0045]
Next, steps S11 to S18 are repeated for all items (Y axis). That is, if the number of items is N, the following processing is performed in order from 0 to N-1 of the item ordinal number.
[0046]
Steps S12 to S17 are repeated for all schedules (X axis). That is, if there are T elements of the schedule array for the corresponding item, the following processing is performed from 0 to T-1 of the schedule array.
[0047]
In step S13, necessary total requirement calculation, net requirement calculation, lot summarization, lead time calculation, and the like are performed. For example, in lot summarization, when the number of production units (minimum production number) at one time is determined, the necessary number of units are produced, and the remainder is added to the inventory quantity. Since these calculation contents are well-known matters in general material requirements planning, a detailed description thereof is omitted here.
[0048]
Next, steps S14 to S16 are repeated for all the product numbers (Z-axis). That is, if there are M elements of the production number array for the relevant schedule, the following processing is performed in order from 0 to M-1 of the production number array.
[0049]
In step S15, a child order is generated as a lower node of the tree structure. Thereafter, in step S16, the loop variable z of the process relating to the production number is incremented by 1, and the steps after step S14 are repeated. In step S17, the loop variable x of the process related to the schedule is incremented by 1, and the steps after step S12 are repeated. In step S18, the loop variable y of the process relating to the item ordinal is incremented by 1 and the processes in step S11 and subsequent steps are repeated.
[0050]
In FIG. 12, in step S10, the order of each product of items A and O given as plan data is initialized as the root node of the item structure tree, the schedule is the X axis, the item ordinal is the Y axis, and the product number is A state in which the Z-axis is arranged in a three-dimensional space is shown. The node of item A is placed at the position where the schedule (delivery date) is February 10, the item ordinal is 0, and the product number is 001. The node of item O is the schedule (delivery date) is March 1 and the item ordinal is 1, the product number is arranged at the position of 002.
[0051]
FIG. 13 shows a state in which the MRP logic calculation of step S13 is performed for each schedule for the item A with the item ordinal = 0, and the child order is generated as a child node of the tree structure in step S15. If there are a plurality of product numbers in the same schedule, a child order is generated as a child node of the tree structure for each product number in step S15. At that time, the generated child order can be referred from the child item list of item ordinal = 0. In the example of FIG. 13, there is only item A with production number = 001 on schedule = 2001/02/10, but child order B (item ordinal number = 2) and child order C (item ordinal number = 6) are created.
[0052]
FIG. 14 shows a state in which the same processing as in FIG. 13 is performed on the item O with the item ordinal number = 1. For item O, child order P (item ordinal number = 3) and child order Q (item ordinal number = 4) are created.
[0053]
The above processing is repeated in the order of the item ordinal numbers. In FIG. 15, the same processing is further performed for item B with item ordinal = 2, and child order D (item ordinal = 5) and child order C (item ordinal = 6) are created for item B. Shows the state.
[0054]
The same processing is continued for the item P with the item ordinal number = 3, so that expanded data as shown in FIG. 16 is created. Next, the processing is continued for the item Q with the item ordinal = 4, but the processing is skipped because the child item list of the item Q is empty.
[0055]
FIG. 17 shows a state in which the child order T (item ordinal number = 8) is expanded for the item R having the item ordinal number = 7 after the same processing is repeated. For the item T with the item ordinal = 8, the child item list is empty, and the expansion process ends here. The expanded data created by the above processing is stored in the multidimensional spatial format expanded data storage unit 15.
[0056]
FIG. 18 shows an example of the data structure of the development items (elements arranged at each node) arranged in the multidimensional space as shown in FIG. Each expanded item expanded in a multi-dimensional space such as item A and item B is expanded item ordinal (Y axis), expanded item serial number (Z axis), link to parent item, link list to child item, number of expansions , Necessary number, number of batches, start date, completion date (X axis), etc.
[0057]
As a result of the expansion processing by the multidimensional spatial format expansion processing unit 14, the multidimensional spatial format expansion data storage unit 15 stores expansion data as shown in FIG. Various arrangement lists can be created very quickly and easily from this multidimensional spatial format. For example, when there is a request to create an arrangement list for item C, the item ordinal number of item C is calculated from integrated item configuration master 13 to obtain item ordinal number = 6. If the data of the item ordinal number (Y axis) = 6 is extracted from the development data in the multidimensional spatial format in the multidimensional spatial format development data storage unit 15, 200 items C are obtained on February 5th, and February 8th. As soon as 100 pieces and 150 pieces are needed on February 24, it is possible to create an arrangement list quickly and efficiently.
[0058]
Similarly, when creating a list of items that need to be arranged for a certain schedule or product number, data of item nodes existing in the schedule (X axis) or product number (Z axis) may be extracted.
[0059]
FIG. 19 shows an example of a display screen displayed on the output device 3 when using the present system. This system can be used by input / output via a display screen 40 as shown in FIG. The display screen 40 includes master capture, plan capture, plan discard, (MRP) logic execution, schedule adjustment, result output, plan correction, plan addition, plan deletion, expanded view, Gantt chart, plan attribute, and other icons. A button is displayed, and a plan list / item list display screen 41 and a data display screen 42 are provided below the buttons.
[0060]
FIG. 20A shows a state in which the item list is selected and displayed on the plan list / item list display screen 41. Here, by inputting an item to be searched, data such as master information and expanded data relating to the selected item is displayed on the data display screen 42 on the right side of the screen.
[0061]
FIG. 20B shows a state in which the plan list is selected and displayed on the plan list / item list display screen 41. Here, production plans are displayed by product number. Here, by inputting a product number to be searched, data such as plan data and expanded data relating to the selected product number is displayed on the data display screen 42 on the right side of the screen.
[0062]
FIG. 21 shows a display example of master information on the data display screen 42. For example, when the item A is selected in the item list shown in FIG. 20A and the display of master information is instructed, the tree structure related to the item A is changed based on the integrated item configuration master 13 shown in FIG. Is displayed.
[0063]
FIG. 22A shows an example of the plan data displayed on the data display screen 42. In this example, the plan content for 100 items A to be procured in-house is shown. By importing such a production plan, the product order described in FIG. 12 is initialized as the root node of the item configuration tree.
[0064]
FIG. 22B shows an example of the expansion result displayed on the data display screen 42. In this example, the production number 002 is selected in the plan list shown in FIG. 20B, and the development of the production number 002 is determined from the processing result of the MRP shown in FIG. 17 stored in the multidimensional spatial format development data storage unit 15. Results are extracted and displayed.
[0065]
FIG. 22C shows an example when an arrangement plan for a certain item (item C) in a certain product number (product number 001) is displayed on the data display screen 42. When the item C in the product number 001 is selected from the plan list shown in FIG. 20B, the multi-dimensional spatial format expanded data storage unit 15 is referred to using [product number 001 + item C] as a key. The item arrangement plan is displayed as shown in FIG.
[0066]
FIG. 22D shows an example when an arrangement plan for a certain item (item C) among the MRP processing results is collectively displayed on the data display screen 42. When item C is selected from the item list shown in FIG. 20 (A) and the result output is instructed, using [item C] as a key, the multi-dimensional spatial format expanded data storage unit 15 is referenced to arrange the item C. The plan is displayed as shown in FIG. Here, the fact that item C is used as a common part for items A, B, and P is displayed for each product number.
[0067]
In the display of the expansion results as shown in FIGS. 22B to 22D, the expansion data is stored in the multidimensional space format expansion data storage unit 15 in a multidimensional space format centered on the schedule, item ordinal number, and product number. Therefore, it is possible to extract data at a very high speed and instantly respond to a display request instruction.
[0068]
As is clear from the above embodiment, this system has the following features.
[0069]
(1) By introducing the concept of item ordinal number in material requirements planning, the complicated material requirement calculation process is replaced with the creation of a tree structure with the product order as the root node. Is simplified.
[0070]
By simplifying the material requirement planning process, when this process is performed on the system, the processing time can be greatly shortened compared to a system that has realized the conventional processing method. In addition, the computer resources required for this calculation process can be reduced, and work efficiency or labor saving is greatly promoted.
[0071]
(2) Since the data structure is more realistic than the conventional format, even if there is a change in the product plan in the material requirements planning, it is only necessary to update the data in the related tree structure, and the material can be processed at high speed. By calculating the required amount, the user can efficiently simulate the product plan.
[0072]
For example, when the production plan of the product O is changed after the expansion process shown in FIG. 17 is completed, it is only necessary to change the plan of the items constituting the product O following the root node of the product O. At this time, it is not necessary to re-calculate including the product A whose plan has not been changed.
[0073]
(3) In the manufacturing process or the arrangement process of subordinate items that make up a product, if a schedule abnormality such as not being in time for delivery occurs, if only the data of the related tree structure is corrected by the above data structure, the schedule Can be corrected correctly and easily. For example, in the expanded data shown in FIG. 17, when a schedule abnormality occurs in the subordinate items C and D of the product A, the schedule adjustment may be executed only for the product A, and the product O including no schedule abnormality may be reproduced. There is no need to calculate.
[0074]
Strictly speaking, in (2) and (3) above, if the number of inventory reserves for a shared item changes due to a change in the plan, it is necessary to modify the tree structure data of the subordinate items from that shared item. There is no need to redo the deployment process from the beginning for all products like technology.
[0075]
(4) When creating an arrangement list for a certain item, a child order for each delivery date can be output as it is from the item ordinal number of the corresponding item, and re-tabulation from a conventional two-dimensional table is not required. Further, when referring to a child order list of a certain product, it is only necessary to follow the tree structure of the corresponding product, and the MRP expansion result can be referred to efficiently.
[0076]
【Effect of the invention】
As described above, according to the present invention, it is not necessary to perform a join operation between masters and is suitable for high-speed material requirement planning processing. Even if there is a plan change, it is only necessary to update the data of the related tree structure (net change), so a real-time plan simulation can be performed.
[0077]
Since everything from the product to the lowest level material is linked, it is possible to easily handle production number management and full pegging functions.
[0078]
Since the MRP expansion data has a multi-dimensional data structure, when creating an arrangement list for a certain item, a child order for each delivery date can be output as it is based on the item ordinal number of the item. In addition, when referring to a child order list of a product, the tree structure of the corresponding product may be followed. In any case, since a real-time response can be expected, for example, it is possible to refer to development data from a Web browser and to provide an ASP (Application Service Provider) service of a production management system.
[Brief description of the drawings]
FIG. 1 is a diagram showing a configuration example of a material requirement plan processing system according to the present invention.
FIG. 2 is a diagram illustrating an image of an item configuration for each product and an integrated item configuration.
FIG. 3 is a diagram illustrating an example of an item master.
FIG. 4 is a diagram illustrating an example of a configuration master.
FIG. 5 is a diagram illustrating an example of a data structure of an integrated item configuration master.
FIG. 6 is a processing flowchart of an integrated item configuration master creation processing unit.
FIG. 7 is a diagram for explaining a procedure for creating an integrated item configuration master.
FIG. 8 is a diagram for explaining a procedure for creating an integrated item configuration master.
FIG. 9 is a diagram for explaining a procedure for creating an integrated item configuration master.
FIG. 10 is a diagram for explaining a procedure for creating an integrated item configuration master.
FIG. 11 is a processing flowchart of a multidimensional spatial format expansion processing unit.
FIG. 12 is a diagram for explaining an example of expansion processing by a multidimensional spatial format expansion processing unit;
FIG. 13 is a diagram for explaining an example of expansion processing by a multidimensional spatial format expansion processing unit;
FIG. 14 is a diagram for explaining an example of expansion processing by a multidimensional spatial format expansion processing unit;
FIG. 15 is a diagram for explaining an example of expansion processing by a multidimensional spatial format expansion processing unit;
FIG. 16 is a diagram for explaining an example of expansion processing by a multidimensional spatial format expansion processing unit;
FIG. 17 is a diagram for explaining an example of expansion processing by a multidimensional spatial format expansion processing unit;
FIG. 18 is a diagram illustrating an example of a data configuration of development items arranged in a multidimensional space.
FIG. 19 is a diagram showing an example of a display screen when using the present system.
FIG. 20 is a diagram showing a display example of a plan list / item list display screen.
FIG. 21 is a diagram showing a display example of master information on a data display screen.
FIG. 22 is a diagram showing a display example of plan data and development results on a data display screen.
FIG. 23 is a diagram showing an example of the item configuration of sample products A and O for explaining the prior art.
FIG. 24 is a diagram illustrating an example of an item master and a configuration master for explaining a conventional technique.
FIG. 25 is a flowchart of conventional MRP expansion processing.
FIG. 26 is a diagram showing an example of plan data for explaining a conventional technique.
FIG. 27 is a diagram for explaining an example of conventional expansion processing;
FIG. 28 is a diagram for explaining an example of a conventional expansion process.
FIG. 29 is a diagram for explaining an example of a conventional expansion process.
FIG. 30 is a diagram for explaining an example of a conventional expansion process.
FIG. 31 is a diagram for explaining an example of conventional expansion processing;
FIG. 32 is a diagram for explaining an example of conventional arrangement list creation;
[Explanation of symbols]
1 Processing device
2 input devices
3 Output device
10 Material master
11 Configuration master
12 Integrated item structure master creation processing part
13 Integrated material structure master
14 Multidimensional spatial format expansion processing unit
15 Multidimensional spatial format expansion data storage

Claims (4)

In material requirements planning processing method by a computer drafting planning the required amount of materials,
Sorting the items that make up the product hierarchically, at least in the low-level order of the item hierarchy;
A step of uniquely assigning an item ordinal number to each item according to the order of the sorted items;
Creating an integrated item structure master having a data structure in which a parent item list and a child item list are linked for each item using the item ordinal number as an index;
Based on the integrated item structure master, material requirement expansion that expands item data in a multidimensional space format with at least the item ordinal number, delivery schedule, and product arrangement instruction data as the product number A material requirements planning processing method comprising: a step of generating data and outputting requested material requirement information based on material requirement expansion data created in a multidimensional spatial format . In a material requirements planning processing system that plans and formulates material requirements using a computer,
The items that make up the product hierarchically are sorted at least in the low-level order in the item hierarchy, and according to the order of the sorted items, the ordinal number uniquely assigned to each item is used as an index, and the parent item for each item. An integrated item configuration master creation processing unit for creating an integrated item configuration master having a data structure in which a list and a child item list are linked;
Based on the integrated item structure master, material requirement expansion that expands item data in a multidimensional space format with at least the item ordinal number, delivery schedule, and product arrangement instruction data as the product number A material requirement characterized by comprising a multidimensional spatial format expansion processing unit that generates data and outputs the required material requirement information based on the material requirement expansion data created in the multidimensional spatial format Quantity planning processing system. A material requirements planning processing program for planning and planning material requirements using a computer,
The items that make up the product hierarchically are sorted at least in the low-level order in the item hierarchy, and according to the order of the sorted items, the ordinal number uniquely assigned to each item is used as an index, and the parent item for each item. Creating an integrated item structure master with a data structure that links the list and child item list;
Based on the integrated item structure master, material requirement expansion that expands item data in a multidimensional space format with at least the item ordinal number, delivery schedule, and product arrangement instruction data as the product number A process of generating data and outputting requested material requirement information based on the material requirement expansion data created in a multidimensional spatial format,
Material requirements planning processing program to be executed by a computer. A recording medium recording a material requirements planning processing program for planning and planning material requirements using a computer,
The items that make up the product hierarchically are sorted at least in the low-level order in the item hierarchy, and according to the order of the sorted items, the ordinal number uniquely assigned to each item is used as an index, and the parent item for each item. Creating an integrated item structure master with a data structure that links the list and child item list;
Based on the integrated item structure master, material requirement expansion that expands item data in a multidimensional space format with at least the item ordinal number, delivery schedule, and product arrangement instruction data as the product number A process of generating data and outputting requested material requirement information based on the material requirement expansion data created in a multidimensional spatial format,
A recording medium for a material requirement planning processing program characterized in that a program for causing a computer to execute is recorded.

Images