JP7094712B2 - Requirement calculator, requirement calculation method, and requirement calculation program - Google Patents

Description

The present invention relates to a requirement calculation device, a requirement calculation method, and a requirement calculation program.

In Patent Document 1, hierarchical product configuration information in which part identification information and a hierarchy of parts are associated with each other is generated for each product, the parts specified by the user are set as search targets, and the parts to be searched are set as parents. A configuration is disclosed that extracts information about all unfinished parts in the lower hierarchy of the tree.

Japanese Unexamined Patent Publication No. 2012-238048

However, in the invention described in Patent Document 1, although the hierarchy of the parts constituting the product can be managed as a master, it is created because the arrangements created by the required quantity calculation process are not linked and managed. There was the problem that it was not possible to manage the relationship between the arrangements made and the arrangements from which they were made.

The present invention has been made in view of the above problems, and is a required amount that maintains the relationship between each arrangement created by the required amount calculation process and the arrangement that is the basis thereof, and manages the relationship between the arrangements. It is an object of the present invention to provide a calculation device, a requirement calculation method, and a requirement calculation program.

In order to solve the above-mentioned problems and achieve the object, the required amount calculation device according to the present invention is a required amount calculation device including a storage unit and a control unit, and the storage unit constitutes a product. A configuration storage means for storing a configuration master that sets a required quantity of an intermediate product or a part or a component that is a component of the intermediate product and a component identifier, and a manufacturing attribute that sets an ordering method for the component. The control unit includes a manufacturing attribute storage means for storing a master, and the control unit acquires product manufacturing instruction data of a product manufacturing instruction including a manufacturing quantity of the product, a product identifier, and a product manufacturing instruction identifier. And, based on the configuration master and the manufacturing attribute master, an arrangement identifier for identifying the arrangement for each component according to the product manufacturing instruction is set, and the required quantity of each component required for the manufacturing quantity is calculated. , The component requirement calculation means for creating the requirement data including the order identifier, the required quantity, and the component identifier for each component, and the ordering destination based on the configuration master and the requirement data. It is characterized in that the arrangement source creating means for creating the arrangement source data for specifying the association between the arrangement and the arrangement or the product manufacturing instruction as the arrangement source is provided.

Further, in the required quantity calculation device according to the present invention, the control unit sets the hierarchy of the product manufacturing instruction and the arrangements for the constituent products constituting the product based on the ordering source data and the required quantity data. It is further provided with a hierarchical display means for specifying and displaying the hierarchical data of the relevant hierarchy in a tree view format.

Further, in the required quantity calculation device according to the present invention, the hierarchical display means specifies the product manufacturing instruction and the hierarchical layer of each arrangement based on the ordering source data and the required quantity data, and obtains the hierarchical data. It is characterized in that the product is displayed in a forward-expanded tree view format with the product at the top.

Further, in the required quantity calculation device according to the present invention, the hierarchical display means specifies the product manufacturing instruction and the hierarchical layer of each arrangement based on the ordering source data and the required quantity data, and obtains the hierarchical data. , It is characterized in that it is displayed in a reverse expansion tree view format with any of the above components at the top.

Further, in the required quantity calculation device according to the present invention, the hierarchical data includes the product manufacturing instruction identifier corresponding to the product manufacturing instruction, the product identifier and the manufacturing quantity, and the ordering identifier corresponding to each of the arrangements. It is characterized by including the component identifier and the required quantity.

Further, in the required quantity calculation device according to the present invention, the storage unit stores an alternative storage unit that sets an alternative ratio of the alternative product of the component to the required quantity of the component constituting the product. When the predetermined component is changed to the substitute, the control unit calculates the required replacement quantity of the substitute required for the production quantity based on the substitute master, and the predetermined quantity is calculated. The order identifier, the alternative required quantity and the substitute identifier of the substitute, and / or the order identifier, the required quantity and the component identifier for each of the components other than the predetermined component. It is characterized by further provided with an alternative quantity requirement calculation means for creating alternative requirement data including.

Further, in the required quantity calculation device according to the present invention, the control unit has the product manufacturing instruction and the alternative product and / or the constituent product constituting the product based on the ordering source data and the alternative required quantity data. It is characterized by further providing an alternative hierarchical display means for specifying the hierarchy of each arrangement with respect to the above and displaying the hierarchical data of the hierarchy in a tree view format.

Further, the requirement calculation device according to the present invention is characterized in that the arrangement method is a production arrangement for arranging production inside the organization and / or a purchase arrangement for arranging purchase from outside the organization.

Further, the required quantity calculation device according to the present invention is characterized in that the product manufacturing instruction identifier and the arrangement identifier are slip numbers.

Further, in the required amount calculation device according to the present invention, the ordering source creating means has the slip number corresponding to the arrangement to be the ordering destination and the ordering source based on the configuration master and the required amount data. It is characterized in that the arrangement source data associated with the above-mentioned arrangement or the above-mentioned slip number corresponding to the above-mentioned product manufacturing instruction is created.

Further, the required quantity calculation method according to the present invention is a required quantity calculation method for causing a required quantity calculation device including a storage unit and a control unit to execute, and the storage unit is an intermediate product constituting a product or an intermediate product. A configuration storage means for storing a configuration master in which a required quantity of a component or a component that constitutes the intermediate product and a component identifier are set, and a manufacturing attribute master in which an arrangement method for the component is set are stored. A product manufacturing instruction acquisition step for acquiring product manufacturing instruction data of a product manufacturing instruction including a manufacturing quantity, a product identifier, and a product manufacturing instruction identifier of the product, which is provided with a manufacturing attribute storage means for the control unit. , The arrangement identifier that identifies the arrangement for each component according to the product manufacturing instruction is set based on the configuration master and the manufacturing attribute master, and the required quantity of each component required for the production quantity is calculated. It becomes an ordering destination based on the component requirement calculation step for creating the required quantity data including the ordering identifier, the required quantity, and the component identifier for each component, and the configuration master and the required quantity data. It is characterized by including an arrangement source creation step of creating an arrangement source data for specifying an association between the arrangement and the arrangement or the product manufacturing instruction to be an arrangement source.

Further, the requirement calculation program according to the present invention is a requirement calculation program for being executed by a requirement calculation device including a storage unit and a control unit, and the storage unit is an intermediate product constituting a product or an intermediate product. A configuration storage means for storing a configuration master in which a required quantity of a component or a component that constitutes the intermediate product and a component identifier are set, and a manufacturing attribute master in which an arrangement method for the component is set are stored. A product manufacturing instruction acquisition step for acquiring product manufacturing instruction data of a product manufacturing instruction including a manufacturing quantity of the product, a product identifier, and a product manufacturing instruction identifier in the control unit, which comprises a manufacturing attribute storage means. Based on the configuration master and the manufacturing attribute master, an arrangement identifier that identifies the arrangement for each component according to the product manufacturing instruction is set, the required quantity of each component required for the manufacturing quantity is calculated, and the required quantity of each of the components is calculated. The arrangement to be an arrangement destination based on the component requirement calculation step for creating the requirement data including the arrangement identifier, the required quantity, and the component identifier for the component, and the configuration master and the requirement data. It is characterized by executing the arrangement source creation step of creating the arrangement source data for specifying the association between the arrangement or the product manufacturing instruction which is the arrangement source.

According to the present invention, since the relationship between arrangements can be managed, it is possible to confirm the arrangement that is the bottleneck of manufacturing. Further, according to the present invention, there is an effect that the progress of the arrangement can be confirmed from the top down or the bottom up in the tree view format. Further, according to the present invention, since the arrangements are linked and managed, the arrangement contents can be flexibly changed.

FIG. 1 is a block diagram showing an example of the configuration of a requirement calculation device. FIG. 2 is a diagram showing an example of the configuration master in the present embodiment. FIG. 3 is a diagram showing an example of the configuration tree data in the present embodiment. FIG. 4 is a diagram showing an example of the configuration master in the present embodiment. FIG. 5 is a diagram showing an example of the configuration tree data in the present embodiment. FIG. 6 is a diagram showing an example of the manufacturing attribute master in the present embodiment. FIG. 7 is a flowchart showing an example of processing of the required quantity calculation device in the present embodiment. FIG. 8 is a flow chart showing an example of the required amount calculation process in the present embodiment. FIG. 9 is a diagram showing an example of an inquiry screen in the present embodiment. FIG. 10 is a diagram showing an example of an inquiry screen in the present embodiment. FIG. 11 is a flow chart showing an example of the required amount calculation process in the present embodiment. FIG. 12 is a diagram showing an example of an inquiry screen in the present embodiment.

Embodiments of the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment.

[1. Overview]
First, the outline of the present invention will be described.

Conventionally, when products and intermediate units are manufactured in-house and the power supply devices, cases, and parts used are purchased from other companies as purchased products, the stock of each manufactured product / purchased product is in stock at the time of the required quantity calculation process. If not, the required quantity calculation process calculates the number of used products corresponding to the manufacturing instructions based on the product configuration master, and arranges the used products that are out of stock (intermediate unit → manufacturing arrangement / parts). Etc. → Purchasing arrangements), and when manufacturing arrangements are made, the products used are calculated further from their own configuration information, and a series of arrangements are made until the manufacturing arrangements disappear, but the relationship between the arrangements is managed. There wasn't.

Therefore, in the present embodiment, when the required quantity calculation process for lower-level expansion is performed based on the arrangement data, by creating the associative data between the upper-level arrangement and the lower-level arrangement, a substitute product and a lower-level expansion inquiry can be made. It is possible.

[2. Constitution]
An example of the configuration of the required quantity calculation device 100 according to the present embodiment will be described with reference to FIGS. 1 to 6. FIG. 1 is a block diagram showing an example of the configuration of the required quantity calculation device 100.

The requirement calculation device 100 is a commercially available desktop personal computer. The required amount calculation device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a portable notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, a tablet personal computer, or the like on the market. It may be a type information processing device.

The required quantity calculation device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the requirement calculation device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the required quantity calculation device 100 to the network 300 so as to be communicable via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the requirement calculation device 100 and the server 200 so as to be communicable with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like.

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving an instruction to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) / ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used. The storage unit 106 includes a configuration master 106a, a manufacturing attribute master 106b, an alternative master 106c, and a required quantity calculation file 106d.

The configuration master 106a is a master in which a required quantity of an intermediate product or a part constituting a product, or a constituent product which is a component constituting the intermediate product, and a component identifier are set. Here, the product identifier may be set in the configuration master 106a. Further, the intermediate product may be an intermediate unit or the like. Further, the product identifier and the component identifier may be an item code and / or an item name or the like. Further, the configuration master 106a uses the item code (parent item code and / or child item code) and / or item name (parent item name and / or child item name) for associating the parent item and the child item. It may be set. Further, the configuration master 106a may store hierarchical data that specifies the hierarchy of the components that make up the product, and / or hierarchical data that specifies the components that make up the intermediate product.

Here, an example of the configuration master 106a in the present embodiment will be described with reference to FIGS. 2 to 5. 2 and 4 are diagrams showing an example of the configuration master 106a in the present embodiment. 3 and 5 are diagrams showing an example of the configuration tree data in the present embodiment.

As shown in FIG. 2, in the configuration master 106a of the present embodiment, the product X, which is a mechanical device, is set to be composed of an intermediate unit 1, an intermediate unit 2, a power supply device 1, and a case 1. The intermediate unit 1 is set to be composed of the component 1, the component 2, and the component 3, and the intermediate unit 2 is set to be composed of the component 3, the component 4, and the component 5. Further, as shown in FIG. 3, the configuration master 106a in the present embodiment may store hierarchical data (configuration tree data) that specifies the hierarchy of the components constituting the product X shown in FIG. 2.

Further, as shown in FIG. 4, in the configuration master 106a in the present embodiment, the product Y, which is a mechanical device, is set to be composed of an intermediate unit 3, a power supply device 1, and a case 2. It is set that the component 3 is composed of the component 1, the component 6, and the component 7. Further, as shown in FIG. 5, the configuration master 106a in the present embodiment may store hierarchical data (configuration tree data) that specifies the hierarchy of the components constituting the product Y shown in FIG.

Returning to FIG. 1, the manufacturing attribute master 106b is a master in which an arrangement method for the components constituting the product is set. Here, the arranging method may be a manufacturing arrangement for arranging the production inside the organization and / or a purchasing arrangement for arranging the purchase from outside the organization. Further, the item code or the like may be set in the manufacturing attribute master 106b.

Here, an example of the manufacturing attribute master 106b in the present embodiment will be described with reference to FIG. FIG. 6 is a diagram showing an example of the manufacturing attribute master 106b in the present embodiment.

As shown in FIG. 6, in the manufacturing attribute master 106b in the present embodiment, the item code of each component constituting the product X or the product Y, and the manufacturing arrangement or the purchase arrangement are set as the arrangement method for each component. ing.

Returning to FIG. 1, the substitute master 106c is a master in which the replacement ratio of the substitute product of the component to the required quantity of the component constituting the product is set. Here, the substitute master 106c may store the required quantity of the component and the substitute required quantity of the substitute in association with each other. Further, the alternative master 106c may be set with an item code (component code and / or alternative item code, etc.) and / or item name (component name and / or alternative item name, etc.).

The requirement calculation file 106d stores data related to the requirement calculation process. Here, the required quantity calculation processing-related data is the product manufacturing instruction data, the required quantity data, the ordering source data, the hierarchical data specifying the hierarchy of the product manufacturing instruction of the product and each arrangement for the component or the substitute which constitutes the product. , And / or may include alternative requirements data and the like.

An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a touch panel). As the input device 112, a keyboard, a mouse, and a microphone, as well as a monitor that cooperates with the mouse to realize a pointing device function can be used. In the following, the output device 114 may be referred to as a monitor 114 or a printer 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112.

The control unit 102 is a CPU or the like that collectively controls the required quantity calculation device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run. The control unit 102 is functionally conceptually provided with a product manufacturing instruction acquisition unit 102a, a component requirement calculation unit 102b, an arrangement source creation unit 102c, a hierarchical display unit 102d, and a substitute product requirement calculation unit 102e. ing.

The product manufacturing instruction acquisition unit 102a acquires product manufacturing instruction data of a product manufacturing instruction including a product manufacturing quantity, a product identifier, and a product manufacturing instruction identifier. Here, the product manufacturing instruction identifier may be a slip number. Further, the product manufacturing instruction acquisition unit 102a may store the product manufacturing instruction data in the required quantity calculation file 106d.

The component requirement calculation unit 102b sets an arrangement identifier that identifies an arrangement for each component according to the product manufacturing instruction based on the configuration master 106a and the manufacturing attribute master 106b, and sets the required quantity of each component required for the manufacturing quantity. Is calculated, and the required quantity data including the order identifier, the required quantity, and the component identifier for each component is created. Here, the arrangement identifier may be a slip number. Further, the ordering identifier may be an ordering schedule number. Further, the required quantity may be a production quantity, an order quantity, or the like. Further, the arrangement may be a component manufacturing instruction, an order, or the like. Further, the required quantity data may be component manufacturing instruction data, ordering schedule data, or the like. Further, the component requirement calculation unit 102b may store the requirement data in the requirement calculation file 106d.

Based on the configuration master 106a and the required quantity data, the arranging source creation unit 102c creates arranging source data that specifies the association between the arranging destination arrangement and the arranging source arrangement or product manufacturing instruction. Here, the order source data may include a product manufacturing instruction identifier and an order identifier. Further, the arrangement source creation unit 102c links the slip number corresponding to the arrangement to be the arrangement destination and the slip number corresponding to the arrangement to be the arrangement source or the product manufacturing instruction based on the configuration master 106a and the required quantity data. You may create the attached order source data. Further, the arrangement source creation unit 102c may store the arrangement source data in the required quantity calculation file 106d.

The hierarchy display unit 102d specifies the hierarchy of each arrangement for the product manufacturing instruction and the components constituting the product based on the arrangement source data and the required quantity data, and displays the hierarchy data of the hierarchy in the tree view format. Here, the hierarchical display unit 102d specifies the hierarchy of each arrangement for the product manufacturing instruction and the components constituting the product based on the order source data, and the hierarchical data is in the positive expansion tree view format with the product at the top. It may be displayed with. Further, the hierarchical display unit 102d specifies the hierarchy of each arrangement for the product manufacturing instruction and the components constituting the product based on the order source data, and the hierarchical data is a reverse expansion tree with any component at the highest level. It may be displayed in a view format. In addition, the hierarchical data may include a product manufacturing instruction identifier, a product identifier and a manufacturing quantity corresponding to the product manufacturing instruction, and an arrangement identifier, a component identifier and a required quantity corresponding to each arrangement. Further, the hierarchical display unit 102d specifies the hierarchy of each arrangement for the product manufacturing instruction and the components and / or substitutes constituting the product based on the arrangement source data and the alternative requirement data, and the hierarchical data of the hierarchy is obtained. It may be displayed in a tree view format. Further, the hierarchical display unit 102d may store the product manufacturing instruction of the product and the hierarchical data specifying the hierarchy of each arrangement for the components constituting the product in the required quantity calculation file 106d.

When changing a predetermined component to a substitute, the substitute requirement calculation unit 102e calculates the substitute required quantity of the substitute required for the production quantity based on the substitute master 106c, and arranges an identifier for the predetermined component. , Substitute requirements and alternative identifiers for alternatives, and / or create alternative requirements data including order identifiers, required quantities and component identifiers for each component other than a given component. Here, the alternative requirement calculation unit 102e may store the alternative requirement data in the requirement calculation file 106d. Further, the predetermined component may be a component for which a user has instructed to change to a substitute product via the input device 112.

[3. Concrete example]
Specific examples of this embodiment will be described with reference to FIGS. 7 to 12.

[Requirement calculation processing]
Here, an example of the required amount calculation process in the present embodiment will be described with reference to FIGS. 7 to 12. FIG. 7 is a flowchart showing an example of processing of the required amount calculation device 100 in the present embodiment.

As shown in FIG. 7, when a product manufacturing instruction for specifying a product manufacturing quantity and a product identifier is given by a user via an input device 112, the product manufacturing instruction acquisition unit 102a determines the product manufacturing quantity and the product identifier. Acquire product manufacturing instruction data including the product manufacturing instruction identifier (step SA-1).

Then, the component requirement calculation unit 102b sets an arrangement identifier that identifies the arrangement for each component according to the product manufacturing instruction based on the configuration master 106a, the manufacturing attribute master 106b, and the product manufacturing instruction data, and sets the manufacturing quantity of the product. The required quantity of each component required for each component is calculated, the required quantity data including the arrangement identifier, the required quantity, and the component identifier for each component is created, and the required quantity data is stored in the required quantity calculation file 106d (step). SA-2).

Then, based on the configuration master 106a and the required quantity data, the arrangement source creation unit 102c has an arrangement identifier corresponding to the arrangement to be the arrangement destination, an arrangement identifier corresponding to the arrangement to be the arrangement source, or a product corresponding to the product manufacturing instruction. Arrangement source data associated with the manufacturing instruction identifier is created, and the arrangement source data is stored in the required quantity calculation file 106d (step SA-3).

Then, the layer display unit 102d specifies the layer of each arrangement for the product manufacturing instruction and the components constituting the product based on the order source data and the required quantity data, and the product manufacturing instruction identifier and the product corresponding to the product manufacturing instruction. The output device 114 displays the hierarchical data of the hierarchy including the identifier and the production quantity, and the arrangement identifier, the component identifier, and the required quantity corresponding to each arrangement in the tree view format (step SA-4).

Then, the substitute product requirement calculation unit 102e determines whether or not the user has instructed the constituent products constituting the product to change to the substitute product via the input device 112 (step SA-5).

Then, when the substitute product requirement calculation unit 102e determines that the user has instructed the component component constituting the product to change to the substitute product via the input device 112 (step SA-5: Yes), the process is stepped. Move to SA-6.

Then, the substitute required quantity calculation unit 102e calculates the substitute required quantity of the substitute required for the production quantity based on the substitute master 106c, and arranges the arrangement identifier, the substitute required quantity, and the substitute product for the component to which the change instruction is given. Create alternative requirement data including the alternative identifier of, and / or the order identifier, required quantity and component identifier for each component other than the component for which the change instruction was given, and convert the alternative requirement data to the requirement calculation file. It is stored in 106d (step SA-6).

Then, the layer display unit 102d specifies the layer of each arrangement for the product manufacturing instruction and the substitute and / or the component constituting the product based on the order source data and the alternative requirement data, and corresponds to the product manufacturing instruction. Hierarchical data of the hierarchy, including product manufacturing instruction identifiers, product identifiers and manufacturing quantities, as well as ordering identifiers, component identifiers or alternative product identifiers corresponding to each arrangement, and required quantity or alternative required quantity, in tree view format. It is displayed on the output device 114, and the substitute identifier and the required replacement quantity are highlighted on the output device 114 (step SA-7), and the process is shifted to step SA-5.

On the other hand, when it is determined that the user has not instructed the component constituting the product to change to the substitute product via the input device 112 (step SA-5: No), the process ends.

Here, a specific example of the required amount calculation process in the present embodiment will be described with reference to FIGS. 8 to 10. FIG. 8 is a flow chart showing an example of the required amount calculation process in the present embodiment.

As shown in FIG. 8, in the present embodiment, when a product manufacturing instruction is given for the 10 products X shown in FIG. 2, a detail number (No), a parent item (product) code, and a parent item (product) name are given. And use including detail number (No), child item (component) code, child item (component) name and required quantity based on the finished product detail data including the number of manufactured products and the configuration master 106a and the product manufacturing instruction data. Acquire the item detail data (step SB-1). Here, the detail number of the manufacturing instruction detail may be a detail line number.

Then, as shown in FIG. 8, in the present embodiment, the manufacturing arrangement or the purchasing arrangement for each component of the product X is executed based on the manufacturing attribute master 106b, and the intermediate unit 1 and the intermediate unit 1 corresponding to each manufacturing arrangement are executed. The component manufacturing instruction data of the intermediate unit 2 and the order schedule data corresponding to each purchase arrangement are created (step SB-2).

Further, as shown in FIG. 8, in the present embodiment, the component manufacturing instructions for the intermediate unit 1 and the intermediate unit 2 are subordinated, and purchase arrangements for the components of the intermediate unit 1 and the intermediate unit 2 are executed. , Order schedule data corresponding to each purchase arrangement is created (step SB-3). Here, in the present embodiment, since the component 3 is used in each of the intermediate unit 1 and the intermediate unit 2, 90 + 60 = 150 may be arranged in one slip. As described above, in the present embodiment, the arrangement of the component manufacturing instruction 2 slip and the order schedule 7 slip is created.

Then, as shown in FIG. 8, in the present embodiment, based on the configuration master 106a, the component manufacturing instruction data, and the ordering schedule data, the slip number corresponding to the arrangement to be the arrangement destination and the arrangement or the arrangement to be the arrangement source are made. Arrangement source data associated with the slip number corresponding to the product manufacturing instruction is created (step SB-4), and the process is completed. As described above, in the present embodiment, the order source data can also be created in the required quantity calculation process for creating the lower order data from the product manufacturing instruction data (slip number SZ000000001).

Here, an example of the inquiry screen in the present embodiment will be described with reference to FIGS. 9 and 10. 9 and 10 are diagrams showing an example of the inquiry screen in the present embodiment.

As shown in FIG. 9, in the present embodiment, when the user specifies a hierarchical display instruction with the slip number SZ00000001 as the highest level, a positive development image with the product X as the highest level is displayed. Further, as shown in FIG. 10, in the present embodiment, when the user specifies a hierarchical display instruction with the slip number HA00000005 at the highest level, a reverse expansion image with the component 3 at the highest level is displayed. It is possible to confirm how the product X is created from the component 3. As described above, in the present embodiment, since the relationship between the upper and lower levels of each arrangement can be understood from the arrangement source data, the normal expansion tree view format and the reverse expansion tree view format from the arrangement number (slip number) specified by the user can be used. Can be displayed. Further, in the past, since the data was displayed while being specified based on the configuration master, there was a problem in the response until the display. However, in the present embodiment, by holding the arrangement source data, the data specification time It became possible to display at high speed without applying.

Further, an example of the alternative product requirement calculation process in the present embodiment will be described with reference to FIGS. 11 and 12. FIG. 11 is a flow chart showing an example of the required amount calculation process in the present embodiment. FIG. 12 is a diagram showing an example of an inquiry screen in the present embodiment.

As shown in FIG. 11, in the present embodiment, when it is necessary to change the part 2 (50 pieces) to the part 9 due to a missing part or the like after the arrangement data is created, it is based on the alternative master 106c. Then, the replacement required quantity (40 pieces) of the substitute product (part 9) required for the production quantity is calculated, and the arrangement identifier (slip number HA00000004) for the component for which the change instruction is given, the replacement required quantity, and the replacement product of the substitute product. Identifiers (“BHN0009” and “Part 9”) and / or alternative requirement data (planned order data) including order identifiers, required quantities and component identifiers for each component other than the component for which the change instruction was instructed. Creating. As described above, in the present embodiment, since the associating information is retained based on the actually created arrangement number, it is possible to replace the parts while retaining the associating information. That is, in the past, since the component configuration of the product was only linked to the master information and held, there was a problem that it could not be managed if a substitute product was used at the time of manufacturing the product. Even if it is necessary to temporarily change the component configuration, it is not necessary to change the configuration master 106a, so that the missing component can be temporarily replaced with a substitute and an order can be placed promptly.

Then, as shown in FIG. 12, in the present embodiment, when the user specifies a hierarchical display instruction with the slip number SZ00000001 as the highest level after the substitute product requirement calculation process, 50 intermediate units 1 are configured. The positive development image with the product X at the highest level, which has been changed from the component 2 of the component 2 to the component 9 of 40, may be displayed, and the component 2 may be highlighted. In this way, in the past, since the association was held based on the master information, it was not possible to make an inquiry when a substitute product was used, but in this embodiment, even if the component configuration is temporarily changed, it cannot be inquired. You can make inquiries.

[4. Other embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

For example, of each of the processes described in the embodiments, all or part of the processes described as being automatically performed may be manually performed, or all of the processes described as being performed manually. Alternatively, a part can be automatically performed by a known method.

In addition, processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and database configurations shown in this specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the required quantity calculation device 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

For example, with respect to the processing functions included in the required quantity calculation device 100, particularly each processing function performed by the control unit 102, all or any part thereof is realized by the CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the process described in the present embodiment, and the required amount is calculated as necessary. It is read mechanically by the device 100. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with the CPU to form a control unit.

Further, this computer program may be stored in an application program server connected to the requirement calculation device 100 via an arbitrary network, and all or a part thereof can be downloaded as needed. Is.

Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Program Read Only Memory), and an EPROM (registered). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disc), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

Further, the "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium and the installation procedure after reading in each device shown in the present embodiment.

Various databases and the like stored in the storage unit 106 are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

Further, the required amount calculation device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the required quantity calculation device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the device.

Furthermore, the specific form of distribution / integration of the device is not limited to that shown in the figure, and all or part of the device may be functionally or physically in any unit according to various additions or functional loads. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

The present invention is useful in industries such as the machinery industry, where it is necessary to flexibly change the contents of arrangements.

100 Requirements calculation device 102 Control unit 102a Product manufacturing instruction acquisition unit 102b Component requirements calculation unit 102c Arrangement source creation unit 102d Hierarchical display unit 102e Alternative product requirements calculation unit 104 Communication interface unit 106 Storage unit 106a Configuration master 106b Manufacturing attributes Master 106c Alternate master 106d Requirement calculation file 108 Input / output interface 112 Input device 114 Output device 200 Server 300 Network

Claims (11)

It is a required quantity calculation device equipped with a storage unit and a control unit.
The storage unit is
A configuration storage means for storing a configuration master in which a required quantity of an intermediate product or a part constituting a product, or a component that is a component constituting the intermediate product, and a component identifier are set is stored.
A manufacturing attribute storage means for storing a manufacturing attribute master for which an arrangement method for the component is set, and a manufacturing attribute storage means.
Equipped with
The control unit
A product manufacturing instruction acquisition means for acquiring product manufacturing instruction data of a product manufacturing instruction including a product manufacturing quantity, a product identifier, and a product manufacturing instruction identifier.
Based on the configuration master and the manufacturing attribute master, an arrangement identifier for identifying the arrangement for each component according to the product manufacturing instruction is set, the required quantity of each component required for the manufacturing quantity is calculated, and the said. A component requirement calculation means for creating requirement data including the order identifier, the required quantity, and the component identifier for each component.
With the ordering source creation means for creating the ordering source data that specifies the association between the ordering destination and the ordering or product manufacturing instruction as the ordering source based on the configuration master and the required quantity data. ,
Hierarchical display that identifies the hierarchy of each arrangement for the product manufacturing instruction and the component constituting the product based on the order source data and the required quantity data, and displays the hierarchical data of the hierarchy in a tree view format. Means and
A required quantity calculation device characterized by being equipped with. The hierarchical display means
Based on the order source data and the required quantity data, the product manufacturing instruction and the hierarchy of each arrangement are specified, and the hierarchy data is displayed in a positive expansion tree view format with the product at the top. The required quantity calculation device according to claim 1 . The hierarchical display means
Based on the order source data and the required quantity data, the hierarchy of the product manufacturing instruction and each of the arrangements is specified, and the hierarchy data is displayed in a reverse expansion tree view format with any of the components at the top. The required quantity calculation device according to claim 1 , wherein the requirement calculation device is characterized by the above. The hierarchical data is
A claim comprising the product manufacturing instruction identifier corresponding to the product manufacturing instruction, the product identifier and the manufacturing quantity, and the ordering identifier, the component identifier and the required quantity corresponding to each of the arrangements. The required amount calculation device according to any one of 1 to 3 . The storage unit is
An alternative storage means for storing an alternative master in which the alternative ratio of the alternative of the component to the required quantity of the component constituting the product is set.
Further prepare
The control unit
When changing a predetermined component to a substitute, the substitute required quantity of the substitute required for the production quantity is calculated based on the substitute master, and the order identifier for the predetermined component and the substitute need are obtained. Alternative requirement to create alternative requirement data including quantity and alternative identifier of said alternative and / or said order identifier, said required quantity and said component identifier for each component other than said predetermined component. Quantitative means,
The required amount calculation device according to any one of claims 1 to 4 , further comprising. The control unit
Based on the ordering source data and the alternative requirement data, the hierarchy of the arrangement for the product manufacturing instruction and the alternative and / or the component constituting the product is specified, and the hierarchical data of the hierarchy is displayed in a tree. Alternative hierarchical display means to display in view format,
The required amount calculation device according to claim 5 , further comprising. The above arrangement method is
The requirement calculation device according to any one of claims 1 to 6 , wherein the manufacturing arrangement arranges the production inside the organization and / or the purchase arrangement arranges the purchase from outside the organization. The product manufacturing instruction identifier and the arrangement identifier are
The required quantity calculation device according to any one of claims 1 to 7 , characterized in that it is a slip number. The means for creating the arrangement source is
Based on the configuration master and the required quantity data, the slip number corresponding to the arrangement to be the arrangement destination and the slip number corresponding to the arrangement or the product manufacturing instruction to be the arrangement source are associated with each other. The required quantity calculation device according to claim 8 , wherein the arrangement source data is created. It is a required quantity calculation method for causing a required quantity calculation device having a storage unit and a control unit to execute the required quantity calculation device.
The storage unit is
A configuration storage means for storing a configuration master in which a required quantity of an intermediate product or a part constituting a product, or a component that is a component constituting the intermediate product, and a component identifier are set is stored.
A manufacturing attribute storage means for storing a manufacturing attribute master for which an arrangement method for the component is set, and a manufacturing attribute storage means.
Equipped with
It is executed by the control unit.
A product manufacturing instruction acquisition step for acquiring product manufacturing instruction data of a product manufacturing instruction including a product manufacturing quantity, a product identifier, and a product manufacturing instruction identifier, and a step of acquiring the product manufacturing instruction.
Based on the configuration master and the manufacturing attribute master, an arrangement identifier for identifying the arrangement for each component according to the product manufacturing instruction is set, the required quantity of each component required for the manufacturing quantity is calculated, and the said. A component requirement calculation step for creating requirement data including the order identifier, the required quantity, and the component identifier for each component.
Based on the configuration master and the required quantity data, the ordering source creation step for creating the ordering source data that specifies the association between the arrangement to be the ordering party and the ordering or the product manufacturing instruction to be the ordering source. ,
Hierarchical display that identifies the hierarchy of each arrangement for the product manufacturing instruction and the component constituting the product based on the order source data and the required quantity data, and displays the hierarchical data of the hierarchy in a tree view format. Steps and
A requirement calculation method characterized by including. It is a requirement calculation program to be executed by a requirement calculation device having a storage unit and a control unit.
The storage unit is
A configuration storage means for storing a configuration master in which a required quantity of an intermediate product or a part constituting a product, or a component that is a component constituting the intermediate product, and a component identifier are set is stored.
A manufacturing attribute storage means for storing a manufacturing attribute master for which an arrangement method for the component is set, and a manufacturing attribute storage means.
Equipped with
In the control unit
A product manufacturing instruction acquisition step for acquiring product manufacturing instruction data of a product manufacturing instruction including a product manufacturing quantity, a product identifier, and a product manufacturing instruction identifier, and a step of acquiring the product manufacturing instruction.
Based on the configuration master and the manufacturing attribute master, an arrangement identifier for identifying the arrangement for each component according to the product manufacturing instruction is set, the required quantity of each component required for the manufacturing quantity is calculated, and the said. A component requirement calculation step for creating requirement data including the order identifier, the required quantity, and the component identifier for each component.
Based on the configuration master and the required quantity data, the ordering source creation step for creating the ordering source data that specifies the association between the arrangement to be the ordering party and the ordering or the product manufacturing instruction to be the ordering source. ,
Hierarchical display that identifies the hierarchy of each arrangement for the product manufacturing instruction and the component constituting the product based on the order source data and the required quantity data, and displays the hierarchical data of the hierarchy in a tree view format. Steps and
Requirement calculation program to execute.

Images