Business support apparatus, business support method, and business support program
The business support device and method accurately track and manage by-product waste for each product, enhancing production optimization and sustainability efforts by identifying profitable by-products and reducing waste.
Patent Information
- Application Number
- JP2024059699
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Filing Date
- 2024-04-02
- Publication Date
- 2025-10-15
AI Technical Summary
Existing systems fail to accurately recognize and manage the amount of by-products discarded for each product, making it difficult to identify profitable by-products and optimize production processes.
A business support device and method that includes a memory control unit and output control unit to store and tally manufacturing and by-product data, enabling the recognition of by-product waste for each product and calculating associated costs and profits.
Enables the identification of by-products for each product, allowing for the evaluation of product groups with the highest reduction effects in waste volume and profit, facilitating informed production decisions and contributing to sustainable development goals.
Smart Images

Figure 2025156927000001_ABST
Abstract
Description
[Technical Field]
[0001] The present invention relates to a business support device, a business support method, and a business support program. [Background technology]
[0002] Patent Document 1 (Japanese Patent Publication No. 2000-246226) discloses an industrial waste management system that enables the construction company to manage the smooth processing and disposal of industrial waste generated at construction sites, preventing illegal dumping and making it easy to follow up on illegal dumping.
[0003] Paragraph 0012 of this Patent Document 1 describes the provision of a workshop for separating industrial waste by type, focusing on construction by-products including recyclable industrial waste. Paragraph 0053 of this Patent Document 1 also describes that by calculating the cumulative amount of waste processed based on the returned manifest and making it possible to compare this with a predicted curve, it becomes possible to manage the amount of industrial waste to avoid exceeding the limit, and to smoothly control the amount of industrial waste to be disposed of in the construction process order. [Prior art documents] [Patent documents]
[0004] [Patent Document 1] Japanese Patent Application Laid-Open No. 2000-246226 Summary of the Invention [Problem to be solved by the invention]
[0005] However, it has been difficult to recognize the amount of by-products discarded for each product.
[0006] The present 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 the amount of by-product waste to be recognized for each product. [Means for solving the problem]
[0007] In order to solve the above-mentioned problems and achieve the objectives, the business support device of the present invention has a memory control unit that stores manufacturing performance data including the manufacturing date and number of manufactured products in a manufacturing performance data storage unit, and by-product performance data including the transfer date, which is the disposal date of by-products when the product is manufactured, and the transfer number, which is the number of discarded by-products, in the by-product performance data storage unit; and an output control unit that refers to the manufacturing performance data storage unit to tally up the number of manufactured products manufactured on a specified date or period, and also refers to the by-product performance data storage unit to tally up the number of discarded by-products discarded on a specified date or period, and outputs a manufacturing performance summary screen including the totaled number of manufactured products and the number of discarded by-products to an output target device.
[0008] In addition, in order to solve the above-mentioned problems and achieve the objective, the business support method of the present invention includes a storage control step in which a storage control unit stores production performance data including the production date and production quantity of manufactured products in a production performance data storage unit, and stores by-product performance data including a transfer date, which is the disposal date of by-products when the products are manufactured, and a transfer number, which is the number of discards, in the by-product performance data storage unit; and an output control step in which an output control unit refers to the production performance data storage unit and tally up the production quantity of products manufactured on a specified date or period, and also refers to the by-product performance data storage unit and tally up the discarded number of by-products discarded on a specified date or period, and outputs a production performance summary screen including the totaled production quantity of products and the discarded number of by-products to an output target device.
[0009] In addition, in order to solve the above-mentioned problems and achieve the objective, the business support program of the present invention causes a computer to function as a storage control unit that stores production performance data, including the production date and production quantity of manufactured products, in a production performance data storage unit, and by-product performance data, including the transfer date, which is the disposal date of by-products when the product is manufactured, and the transfer number, which is the number of discarded by-products, in the by-product performance data storage unit; and an output control unit that refers to the production performance data storage unit to tally up the production quantity of products manufactured on a specified date or period, and also refers to the by-product performance data storage unit to tally up the discarded number of by-products discarded on a specified date or period, and outputs a production performance summary screen, including the totaled production quantity of products and the discarded number of by-products, to an output target device. [Effects of the Invention]
[0010] The present invention can recognize the amount of by-product waste for each product. [Brief explanation of the drawings]
[0011] [Figure 1] FIG. 1 is a block diagram illustrating a hardware configuration of a task assistance device according to an embodiment. [Figure 2] FIG. 2 is a diagram illustrating an example of a product number master table provided in the business support device according to the embodiment. [Figure 3] FIG. 3 is a diagram illustrating an example of a manufacturing configuration master table provided in the business support device according to the embodiment. [Figure 4] FIG. 4 is a diagram illustrating an example of a cost unit price data storage unit provided in the business support device according to the embodiment. [Figure 5] FIG. 5 is a diagram illustrating an example of a manufacturing performance data storage unit provided in the business support device according to the embodiment. [Figure 6] FIG. 6 is a diagram illustrating an example of a by-product performance data storage unit provided in the business support device according to the embodiment. [Figure 7] FIG. 7 is a diagram illustrating an example of a transfer data storage unit provided in the business support device according to the embodiment. [Figure 8]FIG. 8 is a diagram illustrating an example of a sales data storage unit provided in the business support device according to the embodiment. [Figure 9] FIG. 9 is a diagram showing the flow of the operation of calculating the production results and sales results that reflect the cost price and disposal cost of by-products in the business support device according to the embodiment. [Figure 10] FIG. 10 is a diagram showing a master table or storage unit used in the calculation operation of the production results and sales results that reflect the cost price and disposal cost of by-products in the business support device according to the embodiment. [Figure 11] FIG. 11 is a diagram for explaining the calculation operation of the payment cost, the unit cost, and the manufacturing cost in the business support device according to the embodiment. [Figure 12] FIG. 12 is a diagram showing an example of a manufacturing performance input screen for inputting manufacturing performance. [Figure 13] FIG. 13 is a diagram showing an example of a sales input screen for inputting sales. [Figure 14] FIG. 14 is a diagram showing an example of a transfer (disposal) input screen for making a transfer (disposal) input. [Figure 15] FIG. 15 is a diagram showing an example of a manufacturing performance summary screen displaying a manufacturing performance summary result in the business support device according to the embodiment. [Figure 16] FIG. 16 is a diagram showing an example of a sales result tally screen displaying a sales result tally result in the business support device according to the embodiment. DETAILED DESCRIPTION OF THE INVENTION
[0012] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A task support device according to an embodiment of the present invention will be described in detail below with reference to the accompanying drawings. However, the present invention is not limited to the following embodiment.
[0013] (overview) Today, chemical manufacturers are working to reduce the amount of by-products they produce in line with the Sustainable Development Goals (SDGs).Until now, it has been possible to grasp the total amount of by-products generated and to grasp disposal costs from selling, general and administrative expenses in financial accounting, but it has been difficult to identify the main product that caused the by-product to be manufactured and to determine whether the by-product is a by-product that can contribute to profits.
[0014] The business support device of this embodiment associates product sales with by-product disposal, making it possible to check the amount of by-products disposed of for each item. Furthermore, by aggregating product sales data and disposal data, it is possible to grasp the gross profit of disposal costs. This makes it possible to evaluate product groups with the highest reduction effects in both waste volume and profit, and to develop measures for future product manufacturing.
[0015] (Hardware configuration) 1, a business support device 1 according to an embodiment includes a storage unit 2, a control unit 3, a communication interface unit 4, and an input / output interface unit 5. An input device 6 and an output device 7 are connected to the input / output interface unit 5. The output device 7 may be a display unit such as a monitor device (including a home television), a printing device, a speaker device, or the like.
[0016] The input device 6 may be a keyboard, a mouse, a microphone, or a monitor that functions as a pointing device in cooperation with a mouse. 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).
[0017] A storage device such as a ROM (Read Only Memory), RAM (Random Access Memory), HDD (Hard Disk Drive), or SSD (Solid State Drive) can be used as the storage unit 2. The storage unit 2 stores a business support program that enables recognition of the amount of by-product waste for each product.
[0018] The storage unit 2 also includes a product number master table 11, a manufacturing configuration master table 12, a cost unit price data storage unit 13, a manufacturing performance data storage unit 14, a by-product performance data storage unit 15, a transfer data storage unit 16, a sales data storage unit 17, and a manufacturing quantity cost unit price storage unit 18, which are storage areas.
[0019] As shown in Fig. 2, the product number master table 11 stores each manufactured product and by-product in association with the product group to which the product or by-product belongs. The example in Fig. 2 indicates that "Chemical A" belongs to "Product Group A" and "Chemical C" belongs to "Product Group B." The example in Fig. 2 also indicates that "By-product A" belongs to "Product Group A" and "By-product B" belongs to "Product Group B."
[0020] 3, the production composition master table 12 stores the names of raw materials used in producing the standard amount of each chemical as "child items," with the above-mentioned chemicals A to C as parent items, and stores the amounts required for production as "component numbers." The production composition master table 12 also stores the names of by-products produced when chemicals A to C are produced, and the quantities of the by-products produced.
[0021] The example in Figure 3 shows that to produce the parent item, Chemical A, in the standard amount of 25 kg, 10 kg of Raw Material A and 15 kg of Raw Material B are required. The example in Figure 3 also shows that to produce the parent item, Chemical C, in the standard amount of 10 kg, 7 kg of Raw Material C and 3 kg of Raw Material D are required.
[0022] Furthermore, the example in Figure 3 shows that when chemical A is produced, 5 kg of by-product A is produced, when chemical B is produced, 2 kg of by-product A is produced, and when chemical C is produced, 5 kg of by-product B is produced.
[0023] The cost unit price data storage unit 13 stores the cost unit price of each item, which is the above-mentioned raw material or by-product, as shown in Fig. 4. The example in Fig. 3 shows that the cost unit price of raw material A, which is a child item used in producing chemical product A, which is the above-mentioned parent item, is "20 yen," and the cost unit price of raw material B is "10 yen." It also shows that the cost unit price of by-product A is "10 yen," and the cost unit price of by-product B is "20 yen."
[0024] As shown in FIG. 5, the manufacturing performance data storage unit 14 stores the manufacturing performance number of the manufactured product, the item which is the parent item mentioned above, the manufacturing date, the number manufactured, the manufacturing cost, the item type indicating the product group to which the manufactured product belongs, the item to be removed which is the raw material item removed (discharged) from the warehouse when the product is manufactured, the quantity removed (discharged quantity), the cost, etc.
[0025] The example in Figure 5 shows that 20 kg of "Chemical A" belonging to "Product Group A" with production record number "S001" was manufactured on "December 9th," and the manufacturing cost was "300 yen." It also shows that during production, 10 kg of "Raw Material A" and 15 kg of "Raw Material B" were withdrawn from the warehouse, and the costs were "200 yen" and "150 yen," respectively.
[0026] The example in Figure 5 shows that 8 kg of "Chemical C," which belongs to the item type of "Product Group B" and has a production record number of "S003," was manufactured on December 15th, with a manufacturing cost of 140 yen. It also shows that during manufacturing, 7 kg of "Raw Material C" and 3 kg of "Raw Material D" were withdrawn from the warehouse, with costs of 105 yen and 75 yen, respectively.
[0027] As shown in Fig. 6, the by-product performance data storage unit 15 stores the production performance number, item, production date, quantity, by-product cost, and item type of by-products produced when a product is produced as a main product. The example in Fig. 6 shows that 5 kg of "by-product A" was produced (December 9th) when "Chemical Product A" with production performance number "S001" shown in Fig. 5 was produced as the main product. The cost of this by-product is "50 yen," indicating that it is a by-product belonging to product group A.
[0028] The example in Figure 6 also shows that 2 kg of "by-product B" was produced (December 15th) when "Chemical Product C" with production record number "S003" shown in Figure 5 was produced as the main product. The cost price of this by-product was 40 yen, which indicates that it is a by-product belonging to product group B.
[0029] The transfer data storage unit 16 stores the actual disposal record of by-products, and as shown in Figure 7, stores the transfer number, item, transfer date (disposal date), number of transfers (number of discarded items), transfer cost which is the amount required for disposal, and item type which is the product group to which the discarded by-product belongs.
[0030] The example in Figure 7 shows that "By-product A" with transfer number "I001" and belonging to "Product Group A" was disposed of in the amount of "5 kg" on "December 28th", and the transfer cost that will become the disposal fee is "50 yen." The example in Figure 7 also shows that "By-product B" with transfer number "I002" and belonging to "Product Group B" was disposed of in the amount of "2 kg" on "December 28th", and the transfer cost that will become the disposal fee is "40 yen."
[0031] The sales data storage unit 17 stores the actual sales results of each product, and as shown in Figure 8, stores the sales number, item, sales date, sales quantity, sales amount, cost of sales, gross profit, and item type. The example in Figure 8 shows that "Chemical A" belonging to "Product Group A" with sales number "U001" was sold in an amount of "6 kg" on "December 20th" and the sales amount was "200 yen." In addition, since the cost of sales in this case is "90 yen," the gross profit is shown to be "110 yen."
[0032] The example in Figure 8 also shows that 4 kg of "Chemical C" belonging to "Product Group B" with sales number "U003" was sold on "December 21st" for a sales amount of 100 yen. In this case, the cost of sales is 70 yen, so the gross profit is 30 yen.
[0033] The manufacturing unit cost unit memory 18 stores the manufacturing unit cost unit, which is the cost unit according to the number of products manufactured, as shown in Fig. 9. Specifically, the manufacturing unit cost unit is calculated by the cost calculation unit 22 using the formula "manufacturing cost / number of products manufactured", and is stored in the manufacturing unit cost unit memory 18 by the memory control unit 23.
[0034] This will be explained in detail using Figure 12. For example, if the production cost, which is the amount obtained by subtracting the by-product cost from the delivery cost obtained by multiplying the delivery quantities of raw materials A and B of chemical A by the cost unit price, is "300 yen" and "25 kg" of chemical A is produced, the production quantity cost unit price of "12 yen" is calculated by calculating "300 yen ÷ 25 kg".
[0035] Similarly, if the production cost of chemical B is "160 yen" and "8 kg" of chemical B is produced, a production unit cost of "20 yen" is calculated by calculating "160 yen ÷ 8 kg". Furthermore, if the production cost of chemical C is "140 yen" and "8 kg" of chemical C is produced, a production unit cost of "17.5 yen" is calculated by calculating "140 yen ÷ 8 kg". The production unit cost memory unit 18 stores the production unit costs calculated in this way.
[0036] (Functional configuration of business support device) Next, the control unit 3 executes the business support program stored in the storage unit 2, thereby functioning as a display control unit 21, a cost calculation unit 22, and a storage control unit 23, as shown in FIG.
[0037] The display control unit 21 is an example of an output control unit, and displays a manufacturing performance input screen, a transfer (disposal) input screen, a sales input screen, a manufacturing performance tally screen, and a sales performance tally screen, which will be described later, via the output device 7.
[0038] The memory control unit 23 stores manufacturing performance data including the manufacturing date and number of manufactured products in the manufacturing performance data memory unit 14, and stores by-product performance data including the transfer date, which is the disposal date of the by-products when the product is manufactured, and the transfer number, which is the number of discarded products, in the by-product performance data memory unit 15.
[0039] The output control unit refers to the manufacturing performance data storage unit 14 to tally up the number of products manufactured on a specified date or period, and also refers to the by-product performance data storage unit 15 to tally up the number of by-products discarded on a specified date or period.The output control unit then outputs a manufacturing performance tally screen including the totaled number of products manufactured and the number of by-products discarded to the output target device.
[0040] As described above, the display control unit 21 can be used as this output control unit, but the output control unit may also be one that controls print output or audio output. In either case, the same effects as those described below can be obtained.
[0041] The cost calculation unit 22 calculates the delivery cost of raw materials by multiplying the delivery quantity, which is the quantity of raw materials delivered when manufacturing a product, by the cost unit price, calculates the by-product cost by multiplying the by-product generation quantity, which is the number of by-products transferred, by the by-product unit price, and calculates the manufacturing cost of the product by subtracting the by-product cost from the calculated delivery cost.
[0042] The memory control unit 23 stores the calculated delivery cost of the raw materials and the manufacturing cost of the product in the manufacturing performance data memory unit 14, and stores the calculated by-product cost of the by-product in the by-product performance data memory unit 15.
[0043] The memory control unit 23 also stores the transfer date and transfer quantity of the by-products entered via the transfer input screen in the by-product actual data memory unit 15. The cost calculation unit 22 calculates the transfer unit price of the by-product by multiplying the transfer quantity by the unit price of the by-product. The output control unit then displays the calculated transfer unit price of the by-product on the transfer input screen.
[0044] In addition, the cost calculation unit 22 calculates the cost of production of the product, calculated by subtracting the by-product cost from the delivery cost, by dividing the calculated cost of production by the number of products manufactured, and calculates the cost of sales of the product by multiplying the calculated cost of production by the number of products sold.
[0045] The storage control unit 23 stores sales data including the sales date, sales quantity, sales amount, cost of sales, and gross profit of the product in the sales data storage unit 17.
[0046] The output control unit refers to the sales data storage unit 17, and tally up the number of sales and cost of goods sold of products sold on a specified date or period, and refers to the by-product actual data storage unit 15, and outputs to the output target device a sales actual summary screen including the number of discarded by-products of products discarded on a specified date or period, the amount of waste calculated by multiplying the number of discarded by the cost unit price of the discarded by-products, and the gross profit calculated by subtracting the cost of goods sold and the amount of waste from the sales amount.
[0047] (Calculation of manufacturing results and sales results reflecting by-product costs and disposal costs) Next, we will explain the operation of calculating the production results and sales results that reflect the cost price and disposal cost of by-products in the business support device 1 of this embodiment having such a configuration. Figure 10 is a diagram showing the flow of the operation of calculating the production results and sales results that reflect the cost price and disposal cost of by-products in such business support device 1. Also, Figure 11 is a diagram showing a master table or memory unit used in the operation of calculating the production results and sales results that reflect the cost price and disposal cost of by-products.
[0048] The control unit 3 of the business support device 1 executes the business support program stored in the memory unit 2, thereby functioning as a display control unit 21, a cost calculation unit 22, and a memory control unit 23, and performs calculation operations for production results and sales results that reflect the cost of by-products and disposal costs.
[0049] In this example, the display control unit 21, the cost calculation unit 22, and the storage control unit 23 are described as being realized by software based on a business support program, but some or all of the display control unit 21, the cost calculation unit 22, and the storage control unit 23 may be realized by hardware. In either case, the same effects as those described below can be obtained.
[0050] (Operations in steps S1 to S3) First, in steps S1 to S3 in Figures 10 and 11, the cost calculation unit 22 refers to the product number master table 11 and the production configuration master table 12, and calculates the production cost of the main product (product), the by-product cost of the by-products produced when the main product is produced, and the delivery cost of the raw materials delivered from the warehouse when the main product (product) is produced.
[0051] Specifically, when a product is manufactured, the person in charge specifies the display of the manufacturing performance input screen via the input device 6. When this specification operation is performed, the display control unit 21 displays the manufacturing performance input screen shown in FIG. 12 via the output device 7. The person in charge inputs the manufacturing destination, item, manufacturing quantity, and manufacturing date into this manufacturing performance input screen. The example in FIG. 12 is an example in which "Chemical Product A" that was manufactured in an amount of "25 kg" on "December 9th" is entered.
[0052] When this input is made, the cost calculation unit 22 refers to the production composition master table 12 shown in Fig. 3 and acquires the constituent quantity of "10 kg" of raw material A and the constituent quantity of "15 kg" of raw material B used in producing 25 kg of chemical A. In addition, the cost calculation unit 22 refers to the cost unit price data storage unit 13 shown in Fig. 4 and acquires the unit prices of raw material A and raw material B.
[0053] Then, the cost calculation unit 22 calculates the dispensing cost by multiplying the "dispensing quantity" which is the constituent number of the raw material A by the cost of the raw material A.
[0054] Issue cost = Issue quantity x Unit cost
[0055] Specifically, for raw material A, the delivery cost is 200 yen (10 kg x 20 yen), and for raw material B, the delivery cost is 150 yen (15 kg x 10 yen).
[0056] The display control unit 21 displays the calculated dispensing costs of the raw materials A and B in the dispensing details area of the production results input screen, together with the quantity and unit price of each raw material, as shown in FIG.
[0057] Next, the cost calculation unit 22 refers to the product number master table 11 shown in Fig. 2 based on the item of "chemical A" and detects "production group A" as the item type of "chemical A." Furthermore, the cost calculation unit 22 refers to the product number master table 11 shown in Fig. 2 based on the detected "production group A." As a result, the cost calculation unit 22 detects "by-product A" associated with "production group A."
[0058] Next, based on the detected items of "by-product A" and "chemical A," the cost calculation unit 22 refers to the manufacturing configuration master table 12 shown in Figure 3 and obtains the by-product quantity of "by-product A," which is "5 kg," produced when "chemical A" is manufactured.
[0059] Furthermore, the cost calculation unit 22 refers to the cost unit price data storage unit 13 based on the item of "by-product A" and acquires the cost unit price of "10 yen" as the cost unit price of "by-product A".
[0060] Then, the cost calculation unit 22 calculates the by-product cost by multiplying the acquired quantities of by-products generated by the unit cost.
[0061] By-product cost = quantity of by-products generated x unit cost
[0062] In this example, the cost calculation unit 22 calculates the by-product cost of the by-product produced during the production of "Chemical Product A" as "50 yen" by multiplying the quantity of by-products produced (5 kg) by the unit cost of 10 yen.
[0063] The display control unit 21 displays the by-product cost calculated in this manner in the by-product display column of the production performance input screen, along with the item (by-product A), quantity (5 kg), and cost unit price (10 yen), as shown in Figure 12.
[0064] Next, the cost calculation unit 22 calculates the manufacturing cost of chemical A by subtracting the by-product cost from the accumulated amount of the disbursement costs of raw materials A and raw materials B required to manufacture chemical A, as shown in Figure 12.
[0065] Manufacturing cost = Total cost of each raw material - Cost of by-products
[0066] In this example, the cost calculation unit 22 calculates the production cost of "300 yen" by calculating "(delivery cost of raw material A 200 yen + delivery cost of raw material B 150 yen) - by-product cost 50 yen." The display control unit 21 displays the calculated production cost of "300 yen" on the production performance input screen, as shown in Fig. 12.
[0067] The storage control unit 23 reflects the input contents of this production performance input screen in the production performance data storage unit 14 shown in Fig. 5. As a result, as shown in Fig. 5, production performance data including the item, production date, production quantity, production cost, item type, item to be paid out, quantity, and cost, together with the unique production performance number, are stored in the production performance data storage unit 14.
[0068] Furthermore, the storage control unit 23 reflects the by-product performance data in the by-product performance data storage unit 15 shown in Fig. 6 based on the input contents on the production performance input screen. As a result, the by-product performance data including the production performance number, item, quantity, by-product cost, and item type is stored in the by-product performance data storage unit 15 as shown in Fig. 6.
[0069] (Operation in step S4) 10 and 11, in step S4, the cost calculation unit 22 calculates the cost of sales. Specifically, when the manufactured product is sold, the person in charge performs a designation operation to display a sales input screen. When this designation operation is performed, the display control unit 21 displays the sales input screen shown in FIG. 13 via the output device 7.
[0070] The person in charge enters the sales date and customer on this sales input screen, and also enters the item, sales quantity, and sales amount in the sales details area. In the example of Figure 13, "Chemical A" is entered as the item of the product sold, "6 kg" is entered as the sales quantity, and "200 yen" is entered as the sales amount.
[0071] When the item, sales quantity, and sales amount are input in this manner, the cost calculation unit 22 refers to the production unit cost unit price storage unit 18 shown in Fig. 9 based on the item "chemical A" and acquires the production unit cost unit price corresponding to chemical A. In this example, the production unit cost unit price of "15 yen" is acquired from the production unit cost unit price storage unit 18.
[0072] This unit cost per unit of production is calculated by the cost calculation unit 22 by calculating "production cost ÷ production quantity" as described above, and the calculated amount is stored in the unit cost per unit of production storage unit 18. In this example, the production cost of chemical product A is "300 yen" as shown in FIG. 12. Also, the production quantity of chemical product A is "(quantity of raw material A 10 kg + quantity of raw material B 15 kg) - quantity of by-product 5 kg = 20 kg" as shown in FIG. 12. In this case, the cost calculation unit 22 calculates "production cost 300 yen ÷ production quantity 20 kg" to calculate the unit cost per unit of production of "15 yen".
[0073] Next, the cost calculation unit 22 calculates the cost of sales by calculating "sales quantity x cost per unit of production quantity." In the input example of FIG. 13, the cost calculation unit 22 calculates the cost of sales of "90 yen" by calculating "sales quantity of chemical product A 6 kg x cost per unit of production quantity 15 yen." In addition, in the input example of FIG. 13, the cost calculation unit 22 calculates a gross profit of "110 yen" by subtracting the cost of sales of 90 yen from the sales amount of 200 yen for 6 kg of chemical product A.
[0074] When such sales input is performed, the storage control unit 23 reflects the input contents on the sales input screen in the sales data storage unit 17 shown in Fig. 8. As a result, as shown in Fig. 8, the sales number, the item, sales date, sales quantity, sales amount, cost of sales, gross profit, and item type corresponding to the input contents on the sales input screen are stored in the sales data storage unit 17.
[0075] (Operation in step S5) 10 and 11, in step S5, the cost calculation unit 22 calculates a transfer cost, which is the cost of the by-product to be discarded. Specifically, when the person in charge specifies display of a transfer input screen, the display control unit 21 displays the transfer (discard) input screen shown in FIG. 14 via the output device 7.
[0076] The person in charge enters the transfer date on this transfer (disposal) input screen. The person in charge also enters the item and transfer quantity in the disposal details input field on this transfer (disposal) input screen. In the example of Figure 14, "by-product A," which is produced when manufacturing chemical A, is entered as the item, and "5 kg" is entered as the transfer quantity (quantity to be discarded).
[0077] When such a transfer (disposal) input is made, the cost calculation unit 22 references the cost unit price data storage unit 13 shown in FIG. 4 based on the input item of "by-product A" and acquires the cost unit price of "10 yen", which is the cost unit price of "by-product A". Then, the cost calculation unit 22 calculates the transfer cost by calculating "transfer quantity x cost unit price". In this example, the cost calculation unit 22 calculates the transfer cost of "50 yen" by calculating "transfer quantity 5 kg x cost unit price 10 yen".
[0078] The storage control unit 23 reflects the input contents of such a transfer (disposal) input screen in the transfer data storage unit 16 shown in Fig. 7. As a result, the transfer data storage unit 16 stores the by-product item, transfer date (disposal date), transfer quantity (disposal quantity), transfer cost, and item type together with the transfer number, as shown in Fig. 7.
[0079] (Operation in step S6) In this way, when the various data described above are stored in the manufacturing performance data storage unit 14, by-product performance data storage unit 15, transfer data storage unit 16, and sales data storage unit 17, it becomes possible to display the manufacturing performance summary results.
[0080] That is, when the person in charge specifies the desired manufacturing date and transfer date (disposal date) as extraction conditions and specifies the display of the manufacturing performance summary results, the display control unit 21 displays, via the output device 7, a manufacturing performance summary screen that displays the manufacturing date and transfer date (disposal date) according to the specified extraction conditions, as shown in Fig. 15. In the example of Fig. 15, the period "December 1st to December 31st" is specified as the manufacturing date and transfer date (disposal date).
[0081] Next, the display control unit 21 refers to the manufacturing performance data storage unit 14 shown in FIG. 5, the by-product performance data storage unit 15 shown in FIG. 6, and the transfer data storage unit 16 shown in FIG. 7, and displays on the manufacturing performance summary screen shown in FIG. 15 the item type, item, number manufactured, and number of by-products discarded for products manufactured during the period "December 1st to December 31st," as well as the total number manufactured and the total number discarded.
[0082] The example in Figure 15 shows that during the period "December 1st to December 31st," 20 kg of chemical A and 10 kg of chemical B belonging to production group A were produced, totaling 30 kg, and that a total of 7 kg of by-products were produced and discarded by producing chemicals A and B. The example in Figure 15 also shows that during the period "December 1st to December 31st," 10 kg of chemical CA belonging to production group B was produced, and that 10 kg of by-products were produced and discarded by producing chemical C.
[0083] Based on this production performance summary screen, the person in charge can grasp the amount of waste in the production performance for each product group, which allows them to consider reducing the production of by-products and reusing by-products.
[0084] In addition, by keeping the ratio of by-products to main products below a certain level, waste reduction can be used as a key performance indicator (KPI), and action plans can be created for SDG Goal 12, "Responsible Consumption and Production," and Goal 13, "Climate Action," to work on reducing by-products.
[0085] (Operation in step S7) Furthermore, once the various data described above are stored in the transfer data storage unit 16 and the sales data storage unit 17, it becomes possible to display the results of sales performance calculations.
[0086] That is, when the person in charge specifies the desired production date and transfer date (disposal date) as extraction conditions and specifies the display of the sales achievement summary results, the display control unit 21 displays, via the output device 7, a sales achievement summary screen that displays the production date and transfer date (disposal date) of the specified extraction conditions, as shown in Fig. 16. In the example of Fig. 16, the period "December 1st to December 31st" is specified as the production date and transfer date (disposal date).
[0087] Next, the display control unit 21 refers to the transfer data storage unit 16 shown in Fig. 7 and the sales data storage unit 17 shown in Fig. 8, and displays the item type, item, number of sales, sales amount, cost of sales, number of discarded by-products, and amount of discarded by-products on the sales performance summary screen shown in Fig. 16. The display control unit 21 also displays the total amount of sales, total amount of cost of sales, total amount of discarded by-products, and gross profit.
[0088] The example in Figure 16 shows that 6 kg of chemical A belonging to manufacturing group A was sold during the period "December 1st to December 31st," with sales revenue of "200 yen," of which the cost of sales was "90 yen." The example in Figure 16 also shows that 4 kg of chemical B belonging to manufacturing group A was sold during the period "December 1st to December 31st," with sales revenue of "100 yen," of which the cost of sales was "80 yen." The example in Figure 16 also shows that by manufacturing chemicals A and B, "7 kg" of by-product A was produced, and the disposal cost of this was "70 yen."
[0089] In addition, the example in Figure 16 shows that the total sales amount is "300 yen," the total cost of sales is "170 yen," and the waste amount is "70 yen," resulting in a gross profit of "60 yen."
[0090] The example in Figure 16 shows that 4 kg of chemical C belonging to manufacturing group B was sold during the period "December 1st to December 31st", with sales revenue of "100 yen", of which the cost of sales was "70 yen". The example in Figure 16 also shows that when 4 kg of chemical C was manufactured, "2 kg" of by-products were produced, and it cost "40 yen" to dispose of them.
[0091] In addition, the example in Figure 16 shows that the total sales amount for Chemical C is "100 yen," the cost of sales is "70 yen," and the amount of by-product waste is "40 yen," resulting in a gross profit of "-10 yen."
[0092] In this example of a sales performance summary screen, the gross profit of product group A exceeds that of product group B, but the amount of by-products wasted is greater. Comparing the amount of by-products wasted, product group B is less than product group A. This shows that profits can be improved by focusing on reducing the production of by-products of product group A. For this reason, displaying the sales performance summary screen can contribute to business planning, etc.
[0093] (Effects of the embodiment) As is clear from the above explanation, the business support device 1 of the embodiment can make it possible to check the amount of by-products to be discarded for each item type by linking the sales of products with the disposal of by-products.
[0094] In addition, it is possible to grasp the gross profit of disposal costs by aggregating the generated sales data and disposal data.
[0095] This allows us to evaluate product groups that have the greatest reduction effects in both waste volume and revenue, and to develop manufacturing measures for future products.
[0096] [Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This invention can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to the achievement of goals "8" and "9" of the SDGs.
[0097] Furthermore, this invention can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs goals 12, 13, and 15.
[0098] Furthermore, the present invention can contribute to strengthening control and governance, thereby contributing to the achievement of Goal 16 of the SDGs.
[0099] [Other embodiments] The present invention can be implemented in various different forms other than the above-described embodiments within the scope of the technical concept described in the claims.
[0100] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically may be performed manually, or all or part of the processes described as being performed manually may be performed automatically using a known method or the like.
[0101] Furthermore, the processing procedures, control procedures, specific names, registered data for each process, information including parameters such as search conditions, screen examples, and database configurations shown in the specification or drawings may be changed as desired unless otherwise specified.
[0102] Furthermore, the components of the business support device 1 shown in the figure are conceptual functional components and do not necessarily have to have the physical configuration shown in the figure. For example, all or any part of the processing functions of the business support device 1, particularly the processing functions performed by the control unit 3, may be realized by a program interpreted and executed by the control unit 3 (CPU: Central Processing Unit), or may be realized by hardware using wired logic.
[0103] The program is recorded on a non-transitory computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in the embodiments, and is mechanically read by the business support device 1 as needed. That is, a computer program is recorded in the storage unit 2, such as a ROM or HDD, for working with an OS (Operating System) to give instructions to a control unit 3 (CPU) and perform various processes. The computer program is loaded into RAM, expanded, and executed by the control unit 3 as appropriate.
[0104] In addition, the business support program of this business support device 1 may be stored in 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.
[0105] Furthermore, the business support program for executing the processes described in the embodiments may be stored in a non-transitory computer-readable recording medium, or may be configured as a program product.
[0106] Here, the "recording medium" can be any "portable physical medium" such as 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 Programmable Read Only Memory), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical Disk), a DVD (Digital Versatile Disk), and a Blu-ray (registered trademark) Disc.
[0107] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code.
[0108] It should be noted that a "program" is not necessarily limited to a single structure, but includes a structure that is distributed as multiple modules or libraries, and a structure that achieves its function by working together with other programs, such as an OS.
[0109] Furthermore, the specific configuration for reading the recording medium in the task support device 1 of the embodiment, the reading procedure, and the installation procedure after reading can be any known configuration or procedure.
[0110] The memory unit 2 is a storage means such as a memory device such as RAM or ROM, a fixed disk device such as a hard disk, a flexible disk, or an optical disk, and stores various programs, tables, databases, web page files, etc. used for various processes or providing websites.
[0111] The business support device 1 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as an information processing device connected to any peripheral device. The information processing device may be implemented with software (including programs or data) that realizes the processes described in the embodiments.
[0112] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the drawings, and all or part of them can be functionally or physically distributed or integrated in any unit depending on various additions or functional loads. In other words, the above-mentioned embodiments can be selectively implemented by combining them in any way. [Industrial Applicability]
[0113] The present invention is applicable to formulation-based manufacturing industries, and is particularly suitable for use in industries where by-products (waste) are generated during the manufacturing process of products, such as the chemical industry or food industry. [Explanation of symbols]
[0114] 1 Business support equipment 2 Storage section 3. Control Unit 4. Communication interface section 5 Input / output interface section 6 Input Devices 7 Output Devices 11 Part number master table 12 Manufacturing Configuration Master Table 13 Cost unit price data storage section 14 Manufacturing performance data storage unit 15 By-product performance data storage section 16 Transfer data storage unit 17 Sales data storage section 18 Manufacturing quantity cost unit price memory section 21 Display control unit 22 Cost Calculation Department 23 Memory control unit
Claims
1. a storage control unit that stores in a manufacturing performance data storage unit manufacturing performance data including the manufacturing date and the number of manufactured products, and stores in a by-product performance data storage unit by-product performance data including the transfer date, which is the disposal date of by-products when the products are manufactured, and the transfer number, which is the number of discarded by-products; an output control unit that refers to the manufacturing performance data storage unit, tallying up the number of products manufactured on a specified date or period, and also refers to the by-product performance data storage unit, tallying up the number of by-products discarded on the specified date or period, and outputs a manufacturing performance tally screen including the total number of products manufactured and the number of by-products discarded to an output target device; A business support device having the above.
2. a cost calculation unit that calculates the delivery cost of the raw materials by multiplying a delivery quantity, which is the quantity of raw materials delivered when manufacturing the product, by a cost unit price; calculates a by-product cost by multiplying a by-product generation quantity, which is the transfer number of the by-product, by the cost unit price of the by-product; and calculates the manufacturing cost of the product by subtracting the by-product cost from the calculated delivery cost; the storage control unit stores the calculated delivery cost of the raw material and the calculated manufacturing cost of the product in the manufacturing performance data storage unit, and stores the calculated by-product cost of the by-product in the by-product performance data storage unit; 2. The business support device according to claim 1, wherein:
3. the storage control unit stores the transfer date and transfer quantity of the by-products input via the transfer input screen in the by-product actual data storage unit; The cost calculation unit calculates a transfer unit price of the by-product by multiplying the transfer number by the unit price of the by-product, the output control unit displays the calculated transfer unit price of the by-product on the transfer input screen; 3. The business support device according to claim 2, wherein:
4. the cost calculation unit calculates a unit cost of production of the product by dividing the calculated manufacturing cost of the product by the number of manufactured products, subtracting the by-product cost from the delivery cost, and calculates a unit cost of production of the product by multiplying the calculated unit cost of production by the number of sales of the product; the storage control unit stores sales data including the sales date, sales quantity, sales amount, the cost of sales, and gross profit of the product in a sales data storage unit; the output control unit refers to the sales data storage unit, and tally up the number of sales and cost of goods sold of the products sold on a specified date or period; refers to the by-product actual data storage unit, and outputs to the output target device a sales actual result tally screen including the number of discarded by-products of the products discarded on a specified date or period, the amount of waste calculated by multiplying the number of discarded by the cost unit price of the discarded by-products, and the gross profit calculated by subtracting the cost of goods sold and the amount of waste from the sales amount; 4. The business support device according to claim 3, wherein:
5. a storage control step in which the storage control unit stores in the storage unit production performance data including the production date and production quantity of the manufactured product, and stores in the storage unit by-product performance data including the transfer date, which is the disposal date of the by-product when the product is manufactured, and the transfer quantity, which is the number of disposals; an output control step in which an output control unit refers to the manufacturing performance data storage unit, totals the number of products manufactured on a specified date or period, and also refers to the by-product performance data storage unit, totals the number of by-products discarded on the specified date or period, and outputs a manufacturing performance total screen including the totaled number of products manufactured and the number of by-products discarded to an output target device; A business support method having the above.
6. Computer, a storage control unit that stores in a manufacturing performance data storage unit manufacturing performance data including the manufacturing date and the number of manufactured products, and stores in a by-product performance data storage unit by-product performance data including the transfer date, which is the disposal date of by-products when the products are manufactured, and the transfer number, which is the number of discarded by-products; an output control unit that refers to the manufacturing performance data storage unit, totals the number of products manufactured on a specified date or period, and also refers to the by-product performance data storage unit, totals the number of by-products discarded on the specified date or period, and outputs a manufacturing performance total screen including the total number of products manufactured and the number of by-products discarded to an output target device; A business support program that functions as a
Citation Information
Patent Citations
Industrial waste administration system and recording medium in which program for industrial waste administration which can be driven by computer
JP2000246226A