Business support device, business support method, and business support program
The business support device and method address the challenge of accurately allocating common material costs to individual parts by using flags and reference values, enhancing cost calculation accuracy and reducing errors and workload.
Patent Information
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Filing Date
- 2024-09-26
- Publication Date
- 2026-04-07
AI Technical Summary
Existing methods struggle to accurately allocate the cost of materials commonly used in multiple parts of a product, leading to errors and increased workload in managing manufacturing costs.
A business support device and method that includes an ordering information creation unit and a cost calculation unit to allocate the cost of common materials to individual parts based on reference values, using flags to identify common materials and calculating costs accordingly.
Enables more accurate product cost calculation by automating the allocation process, reducing errors and workload, and improving cost management efficiency.
Smart Images

Figure 2026059434000001_ABST
Abstract
Description
[Technical Field]
[0001] This invention relates to a business support device, a business support method, and a business support program. [Background technology]
[0002] Patent Document 1 (Japanese Patent Application Publication No. 2020-160962) discloses a manufacturing cost management device equipped with a control unit for managing the manufacturing costs of products manufactured using materials supplied via a material supply facility.
[0003] This control unit includes a means for calculating the allocated usage quantity to calculate the manufacturing cost of one or more products, based on pre-set allocation standard information for each of the multiple material supply equipment and difference quantity information relating to the difference between the total quantity of supplied materials and the total quantity of actual usage used in the manufacture of one or more products. This allows for appropriate reflection of quantity differences arising depending on the material supply equipment used when managing the manufacturing costs of products, thereby reducing the effort required of the user in managing the manufacturing costs of products. [Prior art documents] [Patent Documents]
[0004] [Patent Document 1] Japanese Patent Publication No. 2020-160962 [Overview of the Initiative] [Problems that the invention aims to solve]
[0005] However, conventionally, the manufacturing cost (cost) of individual products was roughly calculated based on differential quantity information regarding the difference between the total quantity of materials supplied and the total quantity actually used in the manufacture of one or more products, and pre-set allocation criteria information for each of the multiple material supply facilities.
[0006] This invention has been made in view of the above-mentioned problems, and aims to provide a business support device, a business support method, and a business support program that enable more accurate calculation of product costs. [Means for solving the problem]
[0007] To solve the above-mentioned problems and achieve the objective, the business support device according to the present invention comprises: an ordering information creation unit that creates ordering information for ordering a plurality of parts and one or more materials necessary for the manufacture of a product, which includes the number of each of the plurality of parts to be ordered, a first flag indicating whether or not a common material used in two or more of the plurality of parts is to be used, a reference value for calculating the amount of the common material to be used, and the quantity of the common material to be ordered, in association with a production number indicating the product; and a cost calculation unit that, for each of the two or more parts that have the first flag indicating that they are to be used, allocates the cost of the common material to the cost of each of the two or more parts based on the reference value, and calculates the cost of the product.
[0008] Furthermore, in order to solve the above-mentioned problems and achieve the objectives, the business support method according to the present invention comprises: an ordering information creation step in which an ordering information creation unit creates ordering information for ordering a plurality of parts and one or more materials necessary for the manufacture of a product, which includes the number of each of the plurality of parts to be ordered, a first flag indicating whether or not a common material is to be used which is a material used in common by two or more of the plurality of parts, a reference value for calculating the amount of the common material to be used, and the number of the common material to be ordered, in association with a production number indicating the product; and a cost calculation step in which a cost calculation unit calculates the cost of the product by apportioning the cost of the common material to the cost of each of the two or more parts that are marked with the first flag indicating that they are to be used, based on the reference value.
[0009] Furthermore, in order to solve the above-mentioned problems and achieve the objectives, the business support program according to the present invention functions as a cost calculation unit that generates procurement information for a product, which is information for procuring a plurality of parts and one or more materials necessary for the manufacture of a product, and which includes the number of each of the plurality of parts to be procured, a first flag indicating whether or not a common material is to be used which is a material used in common by two or more of the plurality of parts, a reference value for calculating the amount of the common material to be used, and the number of the common material to be procured, in association with a production number indicating the product; and a cost calculation unit that calculates the cost of the product by apportioning the cost of the common material to the cost of each of the two or more parts, based on the reference value, for each of the two or more parts that have the first flag indicating that they are to be used. [Effects of the Invention]
[0010] This invention allows for a more accurate calculation of the cost of a product. [Brief explanation of the drawing]
[0011] [Figure 1] Figure 1 is a block diagram showing the hardware configuration of a business support system in which the business support device according to the embodiment is installed. [Figure 2] Figure 2 shows an example of an item master table. [Figure 3] Figure 3 shows an example of configuration information stored in the configuration information storage unit. [Figure 4] Figure 4 shows another example of configuration information stored in the configuration information storage unit. [Figure 5] Figure 5 shows an example of arrangement information stored in the arrangement information storage unit. [Figure 6] Figure 6 shows an example of cost performance information stored in the cost performance information storage unit. [Figure 7] Figure 7 shows an example of indirect cost information stored in the indirect cost information storage unit. [Figure 8] Figure 8 shows an example of items in the item master table when there are two or more common materials. [Figure 9] FIG. 9 is a diagram showing a form of transmission and reception of various data in a business support system in which a business support apparatus according to an embodiment is provided. [Figure 10] FIG. 10 is a diagram showing an example of a scheduling screen. [Figure 11] FIG. 11 is a diagram showing an example of processing in a cost calculation unit. [Figure 12] FIG. 12 is a diagram showing an example of calculation of the cost amount of a common material used. [Figure 13] FIG. 13 is a diagram showing an example of allocation result work data stored in an actual cost information storage unit. Embodiments for Carrying Out the Invention
[0012] Hereinafter, a business support apparatus according to an embodiment to which the present invention is applied will be described in detail based on the drawings. Note that the present invention is not limited to the following embodiments.
[0013] [Summary] Conventionally, when calculating the cost amount of a product, it has been difficult to allocate the cost of materials commonly used in a plurality of parts required for manufacturing the product according to the amount of use of the material for each individual part and perform cost calculation. Therefore, for the cost of materials commonly used in products, it is necessary to issue a production number for each order unit of the product and manage the cost individually for each production number. In addition, in the individual cost management for each production number, the cost finally transferred to expenses is managed as an expense production number, but for the cost required for dealing with troubles and claims that occurred after the delivery of the product, it is necessary to manage it linked to each order (that is, each project) of the product and finally transfer it to expenses as necessary. On the other hand, for costs such as research and development costs that are not directly related to the order (that is, project) of the product, it is necessary to transfer the cost from the work-in-process cost, and it is also necessary to transfer all the remaining work-in-process costs at the end of the month to expenses in a lump sum.
[0014] Therefore, when processing transfers, the person in charge had to distinguish between transfers for product orders (i.e., project units) and expense transfers. This not only made it easier for errors to occur due to the person's misjudgment, but also placed a burden on the person in charge.
[0015] Therefore, in this embodiment, the type of transfer is determined based on the classification of the production number, and the transfer process for product orders (projects) and the expense transfer process are performed automatically. This switches the transfer destination based on the production number classification and transfers the costs incurred in the expense production number, thereby reducing input errors and workload for the person in charge of the transfer process.
[0016] [composition] (Hardware configuration) Figure 1 is a block diagram showing the hardware configuration of a business support system 100 in which the business support device 1 according to this embodiment is installed. As shown in Figure 1, the business support device 1 of this embodiment includes a storage unit 2, a control unit 3, a communication interface unit 4, and an input / output interface unit 5.
[0017] The input / output interface unit 5 is connected to an input device 6 and an output device 7. The output device 7 may be a display unit such as a monitor device (including a home television), a printing device, or a speaker device. The input device 6 may be a keyboard device, a mouse device, a microphone device, or a monitor device that works in conjunction with a mouse device to provide a pointing device function.
[0018] The communication interface unit 4 is connected to a network such as a wide-area network like the Internet or a private network like a LAN (Local Area Network).
[0019] For the memory unit 2, a storage device such as ROM (Read Only Memory), RAM (Random Access Memory), HDD (Hard Disk Drive), or SSD (Solid State Drive) can be used. The memory unit 2 stores a business support program that enables more accurate calculation of product costs.
[0020] Furthermore, this storage unit 2 is equipped with the following storage areas: an item master table 21, a configuration information storage unit 22, a procurement information storage unit 23, a cost performance information storage unit 24, an indirect cost information storage unit 25, and a file storage unit 26.
[0021] The item master table 21 is a master table in which a second flag (hereinafter also called the common material flag) is set for each item to indicate whether or not the material of that item is a common material. A common material is a material that is used in common by two or more of the multiple parts required to manufacture a product.
[0022] The item master table 21 is created for each product, listing the parts and materials required for the manufacture of that product, and includes, for example, an item code, item name, and common material flag. The item name is the name of the part or material required for the manufacture of the product. Common materials are, for example, liquids, powders, mixtures thereof, or solids, and specifically include chemicals used for surface treatment of parts, abrasives, paints used for painting, coatings, etc.
[0023] Figure 2 shows an example of the item master table 21. In the example in Figure 2, the "paint flag" is set as a common material flag. In Figure 2, the item code is "TORYO" and the item name is "paint," and the paint flag of "1" is set to indicate that it is a common material. For other item codes, the paint flag of "0" is set to indicate that it is not a common material. By setting a common material flag in this way, during cost calculation, the cost of a material can be allocated to the cost of two or more parts that use that material, using the material with the flag indicating it is a common material as the allocation source.
[0024] The configuration information storage unit 22 stores configuration information, which is information about multiple parts necessary for the manufacture of a product, associated with the production number assigned to each product. For each of the multiple parts necessary for the manufacture of a product, the configuration information includes a configuration key that is automatically assigned, the hierarchical structure of each item, the number required to manufacture the product, a first flag indicating whether or not it is subject to the use of common materials (hereinafter also referred to as the common material allocation target flag), and a reference value for calculating the amount of common materials used (hereinafter referred to as the allocation reference value).
[0025] Figure 3 shows an example of configuration information stored in the configuration information storage unit 22. The configuration information shown in Figure 3 is one form of configuration information created by the configuration information creation unit 32, which will be described later, and is stored in the storage unit 2. The example in Figure 3 shows the configuration information for the product "belt conveyor".
[0026] This belt conveyor (level: 0) consists of a "head module," an "intermediate module 8M," and a "tail module." The head module (level: 1) is equipped with "carrier roller A" (level: 2), which consists of rollers and bearings (level: 3); the intermediate module 8M (level: 1) is equipped with "carrier roller B" (level: 2), which consists of rollers and bearings (level: 3); and the tail module (level: 1) is equipped with "carrier roller C" (level: 2), which consists of rollers and bearings (level: 3). Each product and component is assigned a configuration key.
[0027] Figure 4 shows another example of configuration information stored in the configuration information storage unit 22. In the example in Figure 4, the configuration information is stored in a table format. For example, the configuration information associates the production number "XX01" with the item code, item name, hierarchy (level), configuration key, required quantity, a paint allocation target flag indicating whether or not "paint" is used as a common material for the part, and an allocation base value. The allocation base value may be the surface area, volume, size, etc. of the part.
[0028] The procurement information storage unit 23 stores procurement information for procuring parts and materials used in the manufacture of a product. The procurement information is created by the procurement information creation unit 33 (described later) and stored in the procurement information storage unit 23. The procurement information is procured for each production number and includes the parts and materials necessary for the manufacture of the product for which the production number was issued, the procurement details, the quantity procured, and the amount.
[0029] Common materials used in multiple parts are not assigned a configuration key. The ordering details indicate whether the parts and materials will be issued from inventory, manufactured, or purchased. The amount is the amount at the time the ordering information is created (hereinafter also referred to as the ordering amount), and the amount corresponding to the ordering details is stored as ordering information. For example, if the ordering details are "inventory," the amount is the inventory amount; if the ordering details are "manufacturing," the manufacturing amount; and if the ordering details are "purchase," the purchase amount.
[0030] Figure 5 shows an example of ordering information stored in the ordering information storage unit 23. As shown in Figure 5, the ordering information for the product "belt conveyor" is linked to the production number "XX01". This ordering information includes parts and materials selected from the configuration information, and common materials (in this case, "paint") linked to the production number. No configuration key is assigned to the common materials.
[0031] The cost performance information storage unit 24 stores cost performance information, including the calculation results of the product's cost. The cost performance information includes the cost amounts for each of the multiple parts necessary for manufacturing the product, which are calculated by the cost calculation unit 34, which will be described later.
[0032] Figure 6 shows an example of cost performance information stored in the cost performance information storage unit 24. As shown in Figure 6, the cost performance information includes the component keys and cost amounts for each of the multiple parts required to manufacture the product with production number "XX01". The cost amounts for two or more parts that use common materials (in this case, parts with component keys P003, P007, and P011) are the amount obtained by adding the apportionment amount to the procurement amount included in the procurement information. The apportionment amounts for these parts are calculated based on the cost of the common materials and the apportionment base value of each individual part. The specific calculation method will be described later in the explanation of the operation of the business support device 1.
[0033] The indirect cost information storage unit 25 stores indirect cost information allocated to manufacturing overhead for each product at a specified level (for example, the entire product or at the unit level). Manufacturing overhead refers to the combined cost of indirect material costs, indirect labor costs, and indirect expenses. The indirect cost information is calculated by the cost calculation unit 34, which will be described later. The allocation rate for indirect costs is set based on the allocation base value (not shown in Figure 4) included in the configuration information. The method for setting the allocation base value and allocation rate is a conventionally known method.
[0034] Figure 7 shows an example of indirect cost information stored in the indirect cost information storage unit 25. As shown in Figure 7, the indirect cost information includes, for example, the level to which manufacturing overhead is allocated, the type of manufacturing overhead, and the cost amount. In the example in Figure 7, the indirect cost information includes information indicating that 1,000 yen in indirect labor costs is allocated to the entire apparatus, and 600 yen in indirect expenses is allocated on a unit basis.
[0035] Furthermore, the memory unit 2 may store, for each of the multiple parts and one or more materials necessary for the manufacture of the product, the inventory amount if they are in stock, the manufacturing amount if they are manufactured, and the purchase amount if they are purchased, associated with each product (by the production number). This allows, for example, the ordering information creation unit 33, described later, to refer to this data and include the amount corresponding to the ordering details in the ordering information.
[0036] Furthermore, the transfer table storage unit may also be stored in storage unit 2. For example, the transfer table storage unit stores the destination item, the source table, and the source item in association with each other.
[0037] (Functional configuration of business support equipment) Next, the control unit 3 executes the business support program stored in the memory unit 2, and functions as an acquisition unit 31, a configuration information creation unit 32, a procurement information creation unit 33, a cost calculation unit 34, and an output control unit 35, as shown in Figure 1.
[0038] In this example, the acquisition unit 31 to the output control unit 35 are described as being implemented in software based on a business support program, but all or part of the acquisition unit 31 to the output control unit 35 may be implemented in hardware. In either case, the same effects as described later can be obtained.
[0039] The acquisition unit 31 acquires instructions entered into the input device 6. These instructions include, for example, product manufacturing instructions, item registration instructions, configuration information creation or update instructions, production number issuance instructions, configuration arrangement input instructions, cost calculation instructions, or data selection instructions.
[0040] Furthermore, the acquisition unit 31 acquires the calculation results from the cost calculation unit 34, as well as information output from the design department terminal device 10, the manufacturing department terminal device 11, the cost management department terminal device 12, and the DB (database) server device 13.
[0041] The configuration information creation unit 32 creates configuration information for the product and stores the created configuration information in the configuration information storage unit 22. For example, based on the configuration information creation instruction acquired by the acquisition unit 31, the configuration information creation unit 32 creates configuration information for each of the multiple parts necessary for the manufacture of the product, including a configuration key, the number required for the manufacture of the product, a first flag indicating whether or not it is subject to the use of common materials (so-called common material allocation target flag), and a reference value (so-called allocation reference value), associated with the production number (see Figure 4).
[0042] Furthermore, the configuration information creation unit 32 updates the base value (so-called apportionment base value) based on the calculation results from the cost calculation unit 34. For example, the configuration information creation unit 32 updates the apportionment base value included in the configuration information based on the calculation results (e.g., actual cost information) acquired by the acquisition unit 31, and updates the configuration information stored in the configuration information storage unit 22.
[0043] The configuration information creation unit 32 stores the configuration information in the configuration information storage unit 22. In the example in Figure 4, the configuration information is stored in a table format, but it is not limited to a table format.
[0044] Furthermore, the configuration information creation unit 32 may create or update the item master table 21 (see Figure 2) based on the item registration instructions acquired by the acquisition unit 31. The item master table 21 is a master table in which a second flag (a so-called common material flag) indicating whether or not the material of the item is a common material is set for each item. The item master table 21 may be created for each product, or it may be created in association with the production number that indicates the product.
[0045] For example, the configuration information creation unit 32 may change some of the multiple parts and materials necessary for manufacturing the product, add or delete common materials, or, if there are two or more common materials, add two or more common material flags. The configuration information creation unit 32 stores the item master table 21 in the storage unit 2.
[0046] Figure 8 shows an example of items in the item master table 21 when there are two or more common materials. As shown in Figure 8, if there are common materials other than paint as materials necessary for the manufacture of the product, in addition to the paint flag, allocation source flag 2, allocation source flag 3, and allocation source flag 4 may be provided. Allocation source flags 2 to 4 may be assigned "1: Common material" and "0: Not a common material" similar to the paint flag, or different numbers or letters may be used depending on the allocation source flag.
[0047] Furthermore, the configuration information creation unit 32 may, for example, issue a serial number to the product for which a manufacturing instruction has been given based on the serial number issuance instruction acquired by the acquisition unit 31, and store the serial number data, which associates the serial number with the product, in the storage unit 2. The serial number data may be stored in a table format (hereinafter referred to as the serial number master table), but is not limited to this format.
[0048] The ordering information creation unit 33 creates ordering information for a product and stores it in the ordering information storage unit 23. For example, the ordering information creation unit 33 may create ordering information for a product based on the manufacturing instructions for the product acquired by the acquisition unit 31. The ordering information is information for ordering multiple parts and one or more materials necessary for the manufacture of the product.
[0049] More specifically, the ordering information creation unit 33 creates ordering information, which includes the number of orders for each of the multiple parts, a first flag (so-called common material allocation target flag) indicating whether or not a common material is used in two or more of the multiple parts, a reference value for calculating the amount of common material used (so-called allocation reference value), and the quantity of common material ordered, in association with the production number indicating the product. For example, the ordering information creation unit 33 creates ordering information (see Figure 5) based on the configuration information (see Figure 4) and the item master table 21 (see Figure 2) associated with the production number of the product.
[0050] The cost calculation unit 34, for example, based on the cost calculation instructions obtained by the acquisition unit 31, allocates the cost of the common material to the cost of each of the two or more parts, based on the allocation standard value, for each of the two or more parts that are marked with a first flag (a so-called common material allocation target flag) indicating whether or not they are subject to the use of common materials, and calculates the cost of the product.
[0051] More specifically, the cost calculation unit 34 uses a material that has been flagged with a second flag (a so-called common material flag) indicating that it is a common material among one or more materials as the allocation source, and allocates the cost of that material to the costs of the two or more parts. Then, the cost calculation unit 34 calculates the cost of the product by calculating and aggregating the costs for each component key (see Figure 6).
[0052] For example, when the output control unit 35 receives an instruction from the acquisition unit 31 to select one of the various data stored in the storage unit 2, it outputs the selected data to the output device 7.
[0053] Alternatively, for example, when the acquisition unit 31 acquires an item registration instruction, the output control unit 35 may output the item master table 21 to the output device 7 and store the information entered by the input device 6 in the item master table 21.
[0054] The output device 7 can be a display device, a printing device, or a speaker device. The output control unit 38 converts the various data stored in the storage unit 2 into display information, print information, or audio information and supplies it to each device to obtain display output, print output, or audio output corresponding to the various data. Alternatively, the output device 7 may be the storage unit 2, an external storage device, or a server device on a network.
[0055] (Business support system configuration) As shown in Figure 1, the business support device 1 comprises a design department terminal device 10, a manufacturing department terminal device 11, a cost management department terminal device 12, and a database (DB) server device 13, forming a business support system 100. Specifically, the business support device 1 is connected to the design department terminal device 10, the manufacturing department terminal device 11, the cost management department terminal device 12, and the DB server device 13 via a communication interface unit 4, which is an example of a communication unit, and a network. As the network, for example, a wide-area network such as the Internet, or a private network such as a LAN (Local Area Network) can be used.
[0056] [Operation] (Operation of the business support system) First, the operation of the business support system 100 in which the business support device 1 according to the embodiment is installed will be described. Figure 9 is a diagram showing the transmission and reception modes of various data within the business support system 100 in which the business support device 1 according to the embodiment is installed.
[0057] In the business support system 100, the P system (design department) terminal device (hereinafter referred to as the design department terminal device 10) creates the configuration information for the product when it receives an input instruction for product configuration information (see Figure 9).
[0058] More specifically, based on the instructions, the design department terminal device 10 creates configuration information for each of the multiple parts necessary for the manufacture of the product, associating it with the production number. This configuration information includes a configuration key, the number of parts required for the manufacture of the product, a first flag indicating whether or not it is subject to the use of common materials (a so-called common material allocation target flag), and an allocation standard value. The design department terminal device 10 then stores the created configuration information in the configuration information storage unit of the DB server device 13.
[0059] Next, the configuration information creation unit 32 (see Figure 1) of the purchasing department terminal device (hereinafter referred to as business support device 1) acquires product manufacturing instructions (not shown in Figure 9) via the acquisition unit 31 (see Figure 1), reads the configuration information stored in the configuration information storage unit within the DB server device 13, and stores it in the configuration information storage unit 22.
[0060] Next, when the procurement information creation unit 33 of the business support device 1 receives an input instruction for configuration procurement (see Figure 9) from the acquisition unit 31, it creates procurement information for procuring multiple parts and one or more materials necessary for the manufacture of the product, based on the instruction.
[0061] More specifically, the ordering information creation unit 33 creates ordering information, which includes the number of each of the multiple parts required for the manufacture of the product, a first flag (so-called common material allocation target flag) indicating whether or not a common material is used in two or more of the multiple parts, a reference value (so-called allocation reference value) for calculating the amount of the common material to be used, and the quantity of the common material to be ordered, in association with the production number indicating the product.
[0062] The arrangement information creation unit 33 stores the arrangement information in the arrangement information storage unit 23. At this time, the arrangement information is transmitted to the DB server device 13 via the communication interface unit 4 and the network, and stored in the arrangement information storage unit within the DB server device 13.
[0063] When the manufacturing terminal device 11 receives an input instruction for configuration ordering (see Figure 9), it may, in the same manner as the operation of the ordering information creation unit 33, create ordering information based on the instruction, store it in the storage unit of the manufacturing terminal device 11, and transmit the ordering information to the DB server device 13. The DB server device 13 stores the acquired ordering information in the ordering information storage unit.
[0064] Next, when the cost management terminal device 12 receives an instruction to execute the cost calculation process (see Figure 9), it reads the procurement information and configuration information from the DB server device 13 and stores it in the storage unit. For each of the two or more parts that are marked with the first flag (the so-called common material allocation target flag) included in the configuration information, the cost management terminal device 12 allocates the cost of the common material to the cost of each of the two or more parts based on the allocation standard value and calculates the cost of the product (see Figure 11).
[0065] More specifically, the cost management terminal device 12 allocates the cost of a material that has been marked with a second flag (a so-called common material flag) indicating that it is a common material among one or more materials, to the costs of two or more parts. The cost management terminal device 12 then calculates the cost of the product by calculating and aggregating the costs for each component key. The cost management terminal device 12 may store the calculation results of the product cost in its storage unit and may also transmit the calculation results to the DB server device 13. The DB server device 13 stores the acquired calculation results in its cost performance information storage unit.
[0066] The cost management terminal device 12 calculates the manufacturing overhead allocated to each product at a specified level. The cost management terminal device 12 stores the calculation results of the product's manufacturing overhead in its storage unit and also transmits them to the DB server device 13. The DB server device 13 stores the acquired calculation results in its overhead information storage unit.
[0067] Next, when the cost management terminal 12 receives an instruction to output cost performance information (see Figure 9), it transmits the cost performance information to the design department terminal 10. At this time, the cost management terminal 12 may also transmit indirect cost information to the design department terminal 10.
[0068] Next, the design department terminal device 10 acquires cost performance information (specifically, the calculation result of the product cost) transmitted from the cost management department terminal device 12 (see Figure 9), and then determines whether or not to update the apportionment base value included in the product configuration information based on the cost performance information.
[0069] If the design department terminal device 10 determines that the apportionment reference value should be updated, it obtains an instruction to update the configuration information of the product. In this case, the design department terminal device 10 updates the apportionment reference value included in the configuration information of the product, transmits the updated configuration information to the DB server device 13, and stores it in the configuration information storage unit.
[0070] On the other hand, the design department terminal device 10 does not update the configuration information if it determines, based on the actual cost information, that the apportionment base value should not be updated.
[0071] The business support system 100 repeats the above operation. This allows the business support system 100 to adjust the apportionment base values included in the configuration information to appropriate values, thereby enabling it to calculate costs more accurately.
[0072] It should be noted that the business support system 100 is merely an example and is not limited to the above example. For example, the hardware configuration and functional configuration of the business support device 1 may be distributed to terminal devices used by personnel in each department, according to the processing performed in the design department, purchasing department, manufacturing department, and cost management department. Alternatively, the business support device 1 may be used as a server device, and a portion of the hardware configuration and functional configuration of the server device may be used by personnel in each department via a network from their terminal devices.
[0073] (Operation of business support equipment) Next, the operation of the business support device 1 according to the embodiment will be described. The business support device 1 reads basic information such as the pre-registered item master table 21 and production number master table from the storage unit 2 and performs input processing of configuration information, procurement information, and indirect cost information. Based on this basic information and input data, the business support device 1 creates cost performance information and updates the configuration information based on the cost performance information.
[0074] (Basic information registration process) First, let's explain the process of registering basic information. For example, the person in charge registers the item code, item name, and common material flag (for example, the paint flag in Figure 2) for each of the product and the multiple parts and materials necessary for the manufacture of that product in the item master table 21 (see Figure 2).
[0075] For example, as shown in Figure 2, the person in charge enters the names of common materials (in this case, paint), the product, and several parts necessary for the manufacture of the product "belt conveyor" into the item name field. For the entered item name, they set an item code and a flag (in this case, a paint flag) indicating whether or not it is a common material.
[0076] Furthermore, for example, the person in charge assigns a serial number to the product in question and registers the serial number in a serial number master table (not shown) by associating it with the product.
[0077] Note that the basic information registration process is not limited to this example.
[0078] (Configuration information creation process) Next, the process of creating configuration information will be explained. For example, when creating configuration information for a product, if the person in charge enters the product's serial number, the configuration information creation unit 32 uses the product's item master table 21 associated with that serial number as the source data and transfers the item codes and item names of the multiple parts necessary for manufacturing that product to the configuration information table (see Figure 4). A configuration key is automatically assigned to each of the multiple parts.
[0079] Next, the person in charge inputs the hierarchy (so-called level) of the product and its parts, the number of products required for manufacturing, the flag for common material allocation (in Figure 4, the flag for paint allocation), and the allocation reference value. In the example in Figure 4, the common material is paint, and the allocation reference value is the surface area of the part.
[0080] As a result, the configuration information creation unit 32 can create configuration information for each of the multiple parts required for the manufacture of the product, including a configuration key, the number required for the manufacture of the product, a common material allocation target flag, and an allocation reference value, associated with the product's production number.
[0081] (Creation of arrangement information) Next, we will explain the process of creating order information. Figure 10 shows an example of an order screen. For example, when creating order information for a product, the person in charge opens the configuration order input screen and enters the production number, and the configuration information associated with that production number is displayed on the output device 7 (for example, the monitor).
[0082] At this time, the ordering information creation unit 33 transfers the common materials for the product (in this case, paint) from the item master table 21 as the source, and the configuration key, item code, item name, and required quantity associated with the product's production number from the configuration information storage unit 22 as the source, to the input field of the ordering information.
[0083] Next, when the person in charge enters the order details for each item displayed on the order screen, the order information creation unit 33 adds, for example, an amount corresponding to the order details (order amount) to the order information. At this time, the order amount is transferred to the order information, for example, using the outbound cost data, manufacturing cost data, and purchase cost data previously stored in the storage unit 2 as the transfer source.
[0084] As a result, the ordering information creation unit 33 creates ordering information using the item master table 21 and the configuration information storage unit 22 as the source, thereby reducing the workload of the person in charge. Furthermore, when the person in charge clicks the "Add New Order" button displayed on the ordering screen, a new ordering screen will appear, and the ordering information creation unit 33 can also create ordering information for different products.
[0085] This allows the ordering information creation unit 33 to create ordering information for two or more products in parallel, thereby streamlining the work of the person in charge.
[0086] Furthermore, when the person in charge adds a new configuration to the input field for the arrangement information and clicks the "Add New Arrangement" button, the arrangement information creation unit 33 creates arrangement information with the new item added. On the other hand, when the person in charge clicks the "Delete Arrangement" button, the arrangement information creation unit 33 deletes the arrangement information displayed on the arrangement screen, and when the person in charge selects some rows of the arrangement information and clicks the "Delete Arrangement" button, the arrangement information creation unit 33 deletes the data entered in those rows.
[0087] As a result, the arrangement information creation unit 33 can modify the arrangement information as needed according to the request of the person in charge, thereby streamlining the person in charge's work.
[0088] (Cost calculation process) Next, we will explain the cost calculation operation. For example, when the person in charge clicks the "Execute Cost Calculation Process" button displayed on the output device 7, the cost calculation unit 34 starts batch processing of cost calculation. Figure 11 shows an example of the processing in the cost calculation unit 34.
[0089] As shown in Figure 11, the cost calculation unit 34 uses "paint" (see Figure 2), which has a "paint flag" of "1" in the item master table 21, as the allocation source, and allocates the amount (i.e., cost) of "paint" to the allocation targets, which are components associated with the configuration keys "P003", "P006", and "P010", which have a "paint allocation target flag (FLG)" of "1" in the configuration information, based on the respective allocation base values.
[0090] The cost calculation unit 34 refers to the procurement information in the procurement information storage unit 23 to identify the amount of "paint" and calculates the cost of "paint" used in the parts associated with the configuration keys "P003", "P006", and "P010" (hereinafter also referred to as the cost of use).
[0091] Figure 12 shows an example of calculating the cost of use of common materials. As shown in Figure 12(a), in calculating the cost of use of "paint" (150 yen) for part "item name: carrier roller A" with item code "YU01" of configuration key "P003", the cost calculation unit 34 calculates the sum of the apportionment base values of the three parts including the part in question (120 m 2 +140m 2 +140m 2 The apportionment standard value (120m) for the said part relative to ) 2 Multiply this by the cost of the paint, which is 500 yen.
[0092] Furthermore, as shown in Figure 12(b), in calculating the cost of use (175 yen) of "paint" for the component "Item Name: Carrier Roller B" with item code "YU02" of configuration key "P006", the cost calculation unit 34 calculates the sum of the apportionment base values (120m) of the three components including the component in question. 2 +140m 2 +140m 2 The apportionment standard value (140m) for the said part relative to ) 2 Multiply this by the cost of the paint, which is 500 yen.
[0093] Also, as shown in (c) of FIG. 12, in calculating the usage cost amount (175 yen) of "paint" for the part "Item Name: Carrier Roller C" with the item code "YU03" of the configuration key "P010", the cost calculation unit 34 calculates the total of the apportionment reference values of the three parts including the part (120m 2 +140m 2 +140m 2 ), multiplies the apportionment reference value of the part (140m 2 ) by the cost of "paint" of "500 yen".
[0094] Next, the cost calculation unit 34 stores the calculation result of the above usage cost amount in the cost actual information storage unit 24 as the apportionment result work data. FIG. 13 is a diagram showing an example of the apportionment result work data stored in the cost actual information storage unit 24. As shown in FIG. 13, the cost calculation unit 34 stores the usage cost amount for each configuration key in association with the production number in the cost actual information storage unit 24.
[0095] Next, the cost calculation unit 34 refers to the apportionment result work data (see FIG. 13) and the arrangement information (see FIG. 5), and calculates the cost amounts of the parts associated with the configuration keys "P003", "P006", and "P010" included in the cost actual information shown in FIG. 6.
[0096] More specifically, the cost calculation unit 34 calculates the cost of the part by adding the usage cost amount (also referred to as the apportionment amount) of the part included in the apportionment result work data to the arrangement amount of the part included in the arrangement information.
[0097] For example, as shown in FIG. 6, the cost calculation unit 34 sets "1,150 yen", which is obtained by adding the apportionment amount of "150 yen" to the arrangement amount of "1,000 yen", as the cost amount of the part with the configuration key "P003". Also, for the part with the configuration key "P006", the cost calculation unit 34 sets "1,075 yen", which is obtained by adding the apportionment amount of "175 yen" to the arrangement amount of "900 yen", as the cost amount of the part with the configuration key "P006".
[0098] Furthermore, the cost calculation unit 34 determines that the cost amount for the component with component key "P010" is "975 yen," which is calculated by adding the pro-rata amount "150 yen" to the procurement amount "800 yen."
[0099] In this way, the cost calculation unit 34 calculates the cost of the product by calculating and aggregating the cost for each component key. Therefore, even when one common material is used for two or more parts, the cost calculation unit 34 can perform apportionment processing for each component key, thereby calculating the cost of the product more accurately.
[0100] Furthermore, manufacturing overhead is allocated to the cost of each product at a specified level (for example, the entire product or per unit) (see Figure 7).
[0101] (Data output control operation) Next, the data output control operation will be explained. When the person in charge inputs an instruction to select one of the various data stored in the storage unit 2 via the input device 6, the output control unit 35 outputs the selected data to the output device 7 based on the instruction acquired by the acquisition unit 31.
[0102] Output to output device 7 means that the data may be displayed on output device 7 (e.g., a monitor), printed by output device 7 (e.g., a printer), or converted to a PDF (Portable Document Format) file and output. Alternatively, output device 7 (e.g., a speaker) may output the selected section of the information as audio.
[0103] [Effects of the embodiment] As is clear from the above description, the business support device 1 according to the embodiment can calculate the cost of a product more accurately.
[0104] Furthermore, according to the business support device 1 of this embodiment, the cost of a product can be calculated more accurately by apportioning the cost of materials commonly used for two or more parts (so-called common materials) in relation to the amount of material used in each part necessary for the manufacture of a product.
[0105] Furthermore, according to the business support device 1 of this embodiment, when creating ordering information, the person in charge can input the production number, and the necessary data can be retrieved from the item master data and configuration information associated with the production number. This reduces the effort required for the person in charge to input the data, thereby easing the workload.
[0106] Furthermore, according to the business support device 1 of this embodiment, a configuration key is automatically assigned to the product and the multiple parts necessary for the manufacture of the product, and the data with the configuration key to be processed is referenced at the reference destination, and processing can be carried out for each configuration key, so that processing can be carried out steadily for each individual part.
[0107] Furthermore, according to the business support device 1 of this embodiment, the apportionment base value is updated as appropriate based on the cost calculation results, allowing for the use of a more appropriate apportionment base value and enabling a more accurate calculation of the product cost.
[0108] [Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This invention can contribute to improving operational efficiency and promoting appropriate management decisions by companies, and therefore can contribute to SDGs Goals 8 and 9.
[0109] Furthermore, this invention can contribute to reducing waste and promoting paperless and electronic processes, thereby contributing to SDGs Goals 12, 13, and 15.
[0110] Furthermore, this invention can contribute to strengthening control and governance, and therefore can contribute to achieving the 16 goals of the SDGs.
[0111] [Other embodiments] The present invention can be implemented in various different forms within the scope of the technical idea described in the claims, even in embodiments other than those described above.
[0112] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically may be performed manually. Alternatively, all or part of the processes described as being performed manually may be performed automatically by known methods or the like.
[0113] Furthermore, unless otherwise specified, the processing procedures, control procedures, specific names, registration data for each process, information including parameters such as search conditions, screen examples, and database configuration shown in the specification or drawings can be arbitrarily changed.
[0114] Furthermore, with respect to the business support device 1, each component shown in the diagram is a functional concept and does not necessarily have to have the physical configuration shown. For example, the processing functions of the business support device 1, particularly the processing functions performed by the control unit 3, may be implemented in whole or in any part by a program interpreted and executed by the control unit 3 (CPU: Central Processing Unit), or by hardware using wired logic.
[0115] The program is recorded on a non-temporary, computer-readable recording medium containing programmed instructions for the information processing device to execute the processes described in the embodiment, and is mechanically read by the business support device 1 as needed. In other words, the storage unit 2, such as ROM or HDD, records a computer program that works in cooperation with the OS (Operating System) to give instructions to the control unit 3 (CPU) and perform various processes. This computer program is loaded into RAM, unpacked, and executed by the control unit 3 as appropriate.
[0116] Furthermore, the business support program for this business support device 1 may be stored on another server device connected to the business support device 1 via any network, and all or part of it may be downloaded and executed as needed.
[0117] Furthermore, the business support program for executing the processes described in the embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program product.
[0118] Here, any "portable physical medium" can be used as the "recording medium," such as memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical Disks), DVDs (Digital Versatile Disks), and Blu-ray (Registered Trademark) Discs.
[0119] Furthermore, "program" refers to a data processing method written in any language or writing method, regardless of whether it is source code or binary code.
[0120] Furthermore, the term "program" is not necessarily limited to a single, monolithic entity, but also includes those that are distributed as multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions.
[0121] Furthermore, for the specific configuration, reading procedure, and post-reading installation procedure for the business support device 1 of the embodiment, well-known configurations or procedures can be used.
[0122] The storage unit 2 is a storage means such as a memory device like RAM or ROM, a fixed disk device like a hard disk, a flexible disk, and an optical disk, and stores various programs, tables, databases, and web page files used for various processing or website provision.
[0123] Furthermore, the business support device 1 may be composed of a known personal computer device or an information processing device such as a workstation, or it may be composed of an information processing device to which any peripheral devices are connected. In addition, the information processing device may be implemented by implementing software (including programs or data, etc.) that realizes the processing described in the embodiment.
[0124] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the figures, and all or part of them can be configured by functionally or physically distributing or integrating them in any unit according to various additions or functional loads. In other words, the embodiments described above can be selectively implemented by arbitrarily combining the embodiments described above. [Industrial applicability]
[0125] The present invention is suitable for application to various industries, such as manufacturing, construction, and service industries. [Explanation of Symbols]
[0126] 1 Business support equipment 2 Storage section 3. Control Unit 4. Communication Interface Section 5 Input / Output Interface Section 6 Input devices 7 Output device 10 Design Department Terminal Equipment 11. Manufacturing Department Terminal Equipment 12 Cost Management Department Terminal Device 13 DB Server Device 21 Item Master Table 22 Configuration Information Storage Unit 23 Arrangement Information Storage Unit 24 Cost Actual Information Storage Unit 25 Indirect cost information storage section 31 Acquisition Department 32 Configuration Information Creation Department 33 Arrangement Information Creation Department 34 Cost Calculation Department 35 Output control unit
Claims
1. A procurement information creation unit creates procurement information associated with a product number, which includes information for procuring multiple parts and one or more materials necessary for the manufacture of a product, a first flag indicating whether or not a common material used in two or more of the multiple parts is to be used, a reference value for calculating the amount of the common material to be used, and the quantity of the common material to be procured. A cost calculation unit calculates the cost of the product by allocating the cost of the common material to the cost of each of the two or more parts, based on the standard value, for each of the two or more parts that are marked with the first flag indicating that they are intended for use, A business support device equipped with the following features.
2. Each of the one or more materials is marked with a second flag indicating whether or not it is the common material. The business support device according to claim 1, wherein the cost calculation unit allocates the cost of the material that is marked with the second flag indicating that it is a common material from among the one or more materials to the costs of the two or more parts.
3. moreover, The business support device according to claim 1 or 2, further comprising a configuration information creation unit that creates configuration information for each of the plurality of parts, including a configuration key, the number required to manufacture the product, the first flag, and the reference value, in association with the production number.
4. The business support device according to claim 3, wherein the cost calculation unit calculates and aggregates costs for each of the component keys to calculate the cost of the product.
5. The business support device according to claim 4, wherein the configuration information creation unit updates the reference value based on the calculation result of the cost calculation unit.
6. The ordering information creation unit creates ordering information for ordering multiple parts and one or more materials necessary for the manufacture of a product, which includes the number of each of the multiple parts to be ordered, a first flag indicating whether or not a common material used in two or more of the multiple parts is to be used, a reference value for calculating the amount of the common material to be used, and the number of the common material to be ordered, and associates this ordering information with the production number indicating the product. A cost calculation step in which the cost calculation unit allocates the cost of the common material to the cost of each of the two or more parts, each of which is marked with the first flag indicating that it is the target of use, based on the standard value, and calculates the cost of the product. A business support method that has the following characteristics.
7. Computers, A procurement information creation unit creates procurement information associated with a product number, which includes information for procuring multiple parts and one or more materials necessary for the manufacture of a product, a first flag indicating whether or not a common material used in two or more of the multiple parts is subject to use, a reference value for calculating the amount of the common material to be used, and the number of the common material to be procured. For each of the two or more parts marked with the first flag indicating that they are intended for use, the cost calculation unit allocates the cost of the common material to the cost of each of the two or more parts based on the standard value, and calculates the cost of the product. A business support program designed to function as such.
Citation Information
Patent Citations
Overhead cost distribution computing system
JP2010282524A
Shared expense prorating device, shared expense prorating method, and shared expense prorating program
JP2018206007A
Cost calculation device, cost calculation method, and cost calculation program
JP2019046070A
Indirect material cost calculation device, indirect material cost calculation method, and indirect material cost calculation program
JP2019139353A
Common expense allocation device, common expense allocation method, and common expense allocation program
JP2022048324A