Manufacturing and sales planning support device and manufacturing and sales planning support method
The manufacturing and sales planning support device optimizes supply chain plans to maximize profit while adhering to greenhouse gas emission limits, addressing the environmental impact of global supply chains.
Patent Information
- Application Number
- JP2021196818
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2021-12-03
- Publication Date
- 2024-11-08
- Estimated Expiration
- 2041-12-03
AI Technical Summary
Existing manufacturing and sales planning systems do not adequately address the environmental impact of greenhouse gas emissions, particularly in global supply chains, hindering compliance with sustainable development goals.
A manufacturing and sales planning support device and method that utilizes a processor and memory to determine product destinations, demand amounts, and emissions, incorporating a numerical model to maximize profit while keeping greenhouse gas emissions within predetermined limits, through a supply chain pattern creation and simulation process.
Supports the formulation of manufacturing and sales plans that comply with greenhouse gas emission limits, optimizing profit while minimizing environmental impact.
Smart Images

Figure 0007579774000001 
Figure 0007579774000002 
Figure 0007579774000003
Abstract
Description
[Technical field]
[0001] The present invention relates to a manufacturing and sales planning support device and a manufacturing and sales planning support method. [Background technology]
[0002] As supply chains become increasingly globalized, it is becoming increasingly important to carefully plan efficient product manufacturing and sales plans that take into account the circumstances of each country.
[0003] For example, Patent Document 1 discloses a sales plan support device that, for the purpose of confirming the feasibility of a sales plan, extracts products and planned sales quantities linked to a planned sales period and a sales representative from sales plan data, extracts products, sales quantities, and sales periods linked to the sales representative from actual sales data, calculates the planned inventory quantities of the extracted products by referring to current inventory data, order data, and production instruction data and using the extracted planned sales quantities, calculates the planned inventory quantities for the next planned sales period of the extracted products after the planned sales period of the extracted products by referring to the order data, production instruction data, and sales plan data and using the calculated planned inventory quantities, calculates the planned sales amounts of the extracted products in the planned sales period of the extracted products by referring to unit price data and using the extracted planned sales quantities, and calculates the planned sales amounts of the extracted products in the next planned sales period of the extracted products by referring to the sales plan data and unit price data, and outputs the results. [Prior art documents] [Patent documents]
[0004] [Patent Document 1] JP 2021-152869 A Summary of the Invention [Problem to be solved by the invention]
[0005] However, today, the magnitude of the impact that business activities in such supply chains have on the environment has been pointed out, particularly the impact of greenhouse gas emissions caused by business activities. In order to achieve the so-called Sustainable Development Goals (SDGs), a system is needed to realistically and effectively curb greenhouse gas emissions at the time of formulating product manufacturing and sales plans.
[0006] The present invention has been made in consideration of the above background, and its object is to provide a manufacturing and sales plan development support device and a manufacturing and sales plan development support method that are capable of supporting the development of manufacturing and sales plans that comply with greenhouse gas emission limits. [Means for solving the problem]
[0007] One of the present inventions for solving the above-mentioned problems is a manufacturing and sales planning support device having a processor and a memory, and including a numerical model storage unit that stores a numerical model that uses a sales destination of a product whose manufacturing and sales involve greenhouse gas emissions and the demand at the sales destination, and a process for manufacturing and selling the product as input values, and calculates, as output values, a maximum profit that can be obtained based on the process with greenhouse gas emissions below a predetermined upper limit, and the greenhouse gas emissions emitted by the process; a plan information acquisition unit that acquires information about the sales destination of the product and the demand at the sales destination; a supply chain pattern creation unit that creates a plurality of supply chain patterns, the information including patterns of each process in the manufacturing and sales of the product with a production amount corresponding to the demand; and a simulation execution unit that inputs each of the created supply chain patterns, together with the acquired sales destination and the production amount, into the numerical model to calculate the maximum profit that can be obtained based on each of the supply chain patterns with greenhouse gas emissions below the predetermined upper limit, and the greenhouse gas emissions emitted by the process.
[0008] Another aspect of the present invention for solving the above-mentioned problem is a manufacturing and sales planning support method in which an information processing device executes a numerical model storage process for storing a numerical model that uses as input values a sales destination of a product whose manufacturing and sales involve greenhouse gas emissions and the demand at the sales destination, and a process for manufacturing and selling the product, and calculates as output values a maximum profit that can be obtained based on the process with greenhouse gas emissions below a predetermined upper limit, and the greenhouse gas emissions emitted by the process; a plan information acquisition process for acquiring information on the sales destination of the product and the demand at the sales destination; a supply chain pattern creation process for creating a plurality of supply chain patterns, the information including patterns of each process in the manufacturing and sales of the product with a production amount corresponding to the demand; and a simulation execution process for inputting each of the created supply chain patterns, together with the acquired sales destination and the production amount, into the numerical model, to calculate the maximum profit that can be obtained based on each supply chain pattern with greenhouse gas emissions below the predetermined upper limit, and the greenhouse gas emissions emitted by the process. Effect of the Invention
[0009] According to the present invention, it is possible to assist in the creation of a manufacturing and sales plan that can comply with restrictions on greenhouse gas emissions. [Brief description of the drawings]
[0010] [Figure 1] 1 is a diagram illustrating an example of a configuration of a manufacturing and sales planning support device according to an embodiment of the present invention. [Diagram 2] FIG. 2 is a diagram illustrating an example of a data configuration of a procurement master. [Diagram 3] FIG. 13 is a diagram illustrating an example of a data configuration of a production capacity master. [Figure 4] FIG. 2 is a diagram illustrating an example of a data configuration of a BOM master. [Diagram 5] FIG. 13 is a diagram illustrating an example of a data configuration of a base cost master. [Figure 6] FIG. 13 is a diagram illustrating an example of a data configuration of a transaction master between manufacturing bases. [Figure 7] FIG. 2 is a diagram illustrating an example of a data configuration of a transportation master. [Figure 8] FIG. 2 is a diagram showing an example of a data configuration of a customs tariff master. [Figure 9] FIG. 2 is a diagram illustrating an example of a data configuration of an exchange master. [Figure 10] FIG. 2 is a diagram illustrating an example of a data configuration of a sales plan master. [Figure 11] FIG. 2 is a diagram illustrating an example of a data configuration of greenhouse gas emission upper limit master data. [Figure 12] FIG. 13 is a diagram illustrating an example of a data configuration of a country base master. [Figure 13] FIG. 2 is a diagram illustrating an example of a hardware configuration of a manufacturing and sales planning support device. [Figure 14] FIG. 11 is a flow diagram illustrating an example of a manufacturing and sales planning support process. [Figure 15] FIG. 13 is a diagram illustrating an example of a production capacity master to be registered. [Figure 16] FIG. 13 is a diagram illustrating an example of a sales plan master to be registered. [Figure 17] FIG. 13 is a diagram illustrating an example of an input screen. [Figure 18] FIG. 13 is a diagram showing an example of a simulation execution screen. [Figure 19] FIG. 11 is a flow diagram illustrating details of a simulation execution process. [Figure 20] FIG. 1 is a diagram illustrating an example of a supply chain pattern. [Figure 21] FIG. 2 is a diagram illustrating an example of a configuration of a supply chain model. [Figure 22] FIG. 13 is a diagram illustrating an example of a simulation result DB. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0011] <System configuration> 1 is a diagram showing an example of the configuration of a manufacturing and sales plan creation support device 10 according to the present embodiment. The manufacturing and sales plan creation support device 10 supports the creation of a manufacturing and sales plan for a product in a supply chain that procures materials, manufactures products using the materials, and sells the products, and proposes to the user a manufacturing and sales plan that limits the total amount of greenhouse gases generated by the manufacturing and sales of products based on each process within a predetermined upper limit.
[0012] Specifically, the manufacturing and sales plan creation support device 10 receives input of information such as demand at the sales destination of the product to be manufactured from the user (hereinafter referred to as plan information), and creates and stores a profit maximization model 5 (details will be described later) which is a numerical model that outputs information on a manufacturing and sales plan that keeps greenhouse gas emissions from the manufacturing and sales of the product below a predetermined upper limit and maximizes the profit amount from the manufacturing and sales.The manufacturing and sales plan creation support device 10 also stores each database (master) used to create the profit maximization model 5.
[0013] That is, the manufacturing and sales planning support device 10 includes a procurement master 110 that stores information on the procurement sources of the products, such as the bases from which the materials for the products are procured and the items handled.
[0014] In addition, the manufacturing and sales planning support device 10 is equipped with a manufacturing capacity master 210 that stores information on the manufacturing capacity of products (or materials (intermediate products)) at each manufacturing base, a BOM master 220 that stores information on the material composition of each product, and a base cost master 230 that stores information on manufacturing costs incurred at each manufacturing base, as information related to the product manufacturing process.
[0015] The manufacturing and sales planning support device 10 also includes a manufacturing base transaction master 310 that stores information regarding the transaction price (internal transaction price) of products between manufacturing bases, as information regarding the transportation of materials or products at each base (supplier, manufacturing base, sales base), a transportation master 320 that stores information regarding the transportation costs of materials or products between manufacturing bases, a tariff master 330 that stores information regarding tariffs on imports and exports between countries related to the bases, and an exchange master 340 that stores information regarding exchange rates between bases (countries).
[0016] The manufacturing and sales planning support device 10 also includes a sales plan master 410 that stores plan information.
[0017] In addition, the manufacturing and sales planning support device 10 is equipped with a greenhouse gas emission upper limit master 510 that stores information on the total amount of greenhouse gas that can be emitted in the manufacturing and sales process, which is set for each country or region, and a country-base master 520 that stores the correspondence between each base and the country to which it belongs.
[0018] The manufacturing and sales planning support device 10 also includes a simulation result DB 610 that stores the execution results of the profit maximization model 5. Next, the data structure of each master will be described.
[0019] (Procurement master) 2 is a diagram showing an example of the data configuration of the procurement master 110. The procurement master 110 has the following data items: procurement item 111 in which information on the material (intermediate product) item of the product is set, manufacturing base 112 in which information on the manufacturing base where the material is manufactured is set, supplier 113 in which information on the supplier (supplier) of the material is set, purchase price 114 in which the purchase price of the material is set, available supply amount 115 in which the available supply amount of the material by the supplier is set, and greenhouse gas emission amount 116 in which the greenhouse gas emission amount caused by the production per unit number of the material is set. In the profit maximization model 5, the total purchase amount of the material is calculated based on the purchase price, the parent item, the child item, and the child item usage quantity of the BOM master 220 described later.
[0020] In addition, when manufacturing a certain material (intermediate product) or product, it may be possible to manufacture the material or product using a plurality of material patterns.
[0021] (Manufacturing capacity master) 3 is a diagram showing an example of the data configuration of the manufacturing capacity master 210. The manufacturing capacity master 210 has the following data items: manufacturing base 211 in which information on a manufacturing base (such as a factory) for a product or material (an intermediate product in this case) is set, equipment name 212 in which information on equipment for manufacturing the product or material is set, manufacturing item 213 in which information on the item of the product or material is set, number of available days 214 in which information on the number of available days for the equipment is set, required time 215 in which the required manufacturing time per unit of the product or material is set, upper production limit 216 in which the upper limit of the manufacturing amount of the product or material is set, and greenhouse gas emission amount 217 in which the greenhouse gas emission amount caused by the manufacturing per unit of the product or material is set.
[0022] In addition, in the facility name 212, not only the name of the facility but also information on the type or attributes of the facility (for example, whether the facility is operated by renewable energy or not) is set. Furthermore, at the same manufacturing base, there may be multiple types of facilities capable of manufacturing the same material or product. Furthermore, there may be multiple manufacturing bases that have facilities capable of manufacturing the same material or product.
[0023] (BOM Master) FIG. 4 is a diagram showing an example of the data configuration of the BOM master 220. The BOM master 220 has data items such as a manufacturing base 221 in which information on a manufacturing base of a product or material (intermediate product in this case) is set, a parent item 222 in which information on the item of the product or material (hereinafter referred to as a parent item) is set, a child item 223 in which information on the item of the material (hereinafter referred to as a child item) constituting the product or material related to the parent item is set, a tariff code 224 in which an identification code (tariff code) of a tariff on the import of the product or material related to the parent item is set, a child item usage quantity 225 in which the number of materials used for the child item is set, and a variable cost 226 in which a variable cost related to the manufacture of the product or material related to the parent item is set. The parent item 222, the child item 223, and the child item usage quantity 225 are used to specify the item and quantity of the material constituting the product. In this embodiment, it is assumed that the combination of materials constituting each product is the same when the factory is the same. On the other hand, it is assumed that each material can be procured from multiple sources.
[0024] (Base cost master) 5 is a diagram showing an example of the data configuration of the base cost master 230. The base cost master has data items of a manufacturing base 231 in which information on the manufacturing base is set, a fixed cost 232 in which information on the fixed cost required for managing and maintaining the manufacturing base is set, and an allocated greenhouse gas emission amount 233. The allocated greenhouse gas emission amount 233 is set to the total greenhouse gas emission amount (hereinafter referred to as the allocated greenhouse gas emission amount) managed as a total amount at the manufacturing base (factory). The profit maximization model 5 can calculate the greenhouse gas emission amount for a number of units (e.g., one unit) of a product by combining the amount of allocated greenhouse gas emission amount pro rata divided by the manufacturing time per unit of the product with respect to the total production time of the manufacturing base (factory) and the greenhouse gas emission amount per unit indicated by the greenhouse gas emission amount 217 of the manufacturing capacity master 210.
[0025] (Transaction master between manufacturing bases) 6 is a diagram showing an example of the data configuration of the inter-manufacturing base transaction master 310. The inter-manufacturing base transaction master 310 has the following data items: item 311 in which information on the item of the product or material is set, dispatch origin base 312 in which information on the manufacturing base from which the product or material is dispatched is set, destination base 313 in which information on the manufacturing base to which the product or material is received is set, and internal transaction unit price 314 in which the internal transaction unit price (described later) of the product or material is set. The internal transaction unit price 314 is used in the profit maximization model 5 to calculate the amount of customs duty, which will be described later.
[0026] (Transportation master) FIG. 7 is a diagram showing an example of the data configuration of the transportation master 320. The transportation master 320 has data items such as an item 321 in which information on the item of the product or material is set, a dispatch origin base 322 in which information on the manufacturing base from which the product or material is dispatched is set, a destination base 323 in which information on the manufacturing base to which the product or material is received is set, a transportation means 324 in which information on the transportation means of the product or material is set, a transportation unit cost 325 in which the transportation unit cost (unit cost of transportation cost) of the product or material is set, and a greenhouse gas emission amount 326 in which the greenhouse gas emission amount caused by the production per unit quantity of the product or material is set. In the profit maximization model 5, the transportation cost is calculated based on the transportation unit cost and the quantity of the material or product to be transported. In addition, a different emission amount is set in the greenhouse gas emission amount 326 according to the transportation means. For example, if the transportation means is an automobile, a larger value is set, and if the transportation means is a railway, a smaller value is set.
[0027] (Customs Tariff Master) 8 is a diagram showing an example of the data configuration of the tariff master 330. The tariff master 330 has the following data items: tariff code 331 in which a tariff code related to the import / export of a product or material is set, importing country name 332 in which the name of the importing country related to the import / export is set, exporting country name 333 in which the name of the exporting country related to the import / export is set, tariff rate 334 in which the tariff rate (import tax rate) of the tariff related to the import / export is set, and export tax rate 335 in which the export tax rate of the tariff related to the import / export is set.
[0028] (Exchange Master) 9 is a diagram showing an example of the data configuration of the exchange master 340. The exchange master 340 has data items of a currency 341 in which information on each currency is set, and an exchange rate 342 in which information on exchange rates between currencies is set.
[0029] (Sales plan master) 10 is a diagram showing an example of the data configuration of the sales plan master 410. The sales plan master 410 has the following data items: item 411 in which information on the product to be manufactured is set; sales base 412 in which information on the sales base of the product is set; customer 413 in which information on the customer based on the sales base of the product is set; demand amount 414 in which the demand amount at the customer is set; sales price 415 in which the sales price of the product is set; designated manufacturing base 416 in which information on the manufacturing base designated in advance for the product is set; internal transaction selling price 417 in which the price (internal transaction selling price) that is the base price of the tariff on the product is set; and required supply amount 418 in which the required (minimum) supply amount of the product (hereinafter referred to as required supply amount) is set. Note that the setting of information in the designated manufacturing base 416 and the required supply amount 418 is optional.
[0030] (Greenhouse gas emission upper limit master) 11 is a diagram showing an example of the data configuration of greenhouse gas emission upper limit master 510. Greenhouse gas emission upper limit master 510 has data items of country 511, in which the name of the country (region) is set, and greenhouse gas emission upper limit value 512, in which the upper limit value of greenhouse gas emission in that country (region) is set. Note that the upper limit of greenhouse gas emission is, for example, an upper limit set by each business entity (manufacturer, distributor, management company, etc.).
[0031] (Country base master) 12 is a diagram showing an example of the data configuration of the country base master 520. The country base master 520 has data items of country 521 in which the name of the country (region) is set, and base 522 in which a list of suppliers, manufacturing bases, and sales bases existing in the country is set.
[0032] Next, as shown in FIG. 1, the manufacturing and sales planning support device 10 includes the following functional units (programs): a profit maximization model memory unit 11, a planning information acquisition unit 13, a supply chain model creation unit 15, a supply chain pattern creation unit 17, a simulation execution unit 19, and a result display unit 21.
[0033] The profit maximization model storage unit 11 stores the profit maximization model 5. The profit maximization model 5 takes as input values the sales destinations of a product whose production and sale involve greenhouse gas emissions and the demand at the sales destinations (sales plan master 410) and the process for production and sale of the product (other masters), and takes as output values the maximum profit that can be obtained by the production and sale of the above process with greenhouse gas emissions below a predetermined upper limit, and the amount of greenhouse gas emissions emitted by the above process.
[0034] The plan information acquisition unit 13 acquires information (plan information or sales plan master 410) on the sales destination of the product and the demand amount at the sales destination based on the user input. Note that the plan information acquisition unit 13 may automatically acquire the plan information or sales plan master 410 from another information processing device instead of from the user input.
[0035] The supply chain model creation unit 15 creates a supply chain model that is information on the relationships between each node, with material suppliers, manufacturing bases for products or intermediate products, manufacturing equipment in the manufacturing bases, and sales bases for products as nodes, and with connection information (transportation means) between these nodes as links. The profit maximization model 5 is a model based on this supply chain model.
[0036] The supply chain pattern creation unit 17 creates a plurality of supply chain patterns, which are information including patterns of each process in the manufacture and sale of products in a production volume corresponding to the demand volume.
[0037] The simulation execution unit 19 inputs each of the supply chain patterns created by the supply chain pattern creation unit 17 into the profit maximization model 5 together with the sales destinations and the production volumes acquired by the plan information acquisition unit 13, thereby calculating the maximum profit that can be obtained based on each of the supply chain patterns with greenhouse gas emissions below a specified upper limit, and also calculates the amount of greenhouse gas emissions to be emitted.
[0038] The result display unit 21 displays information on the maximum profit calculated by the profit maximization model 5, as well as information on the process for manufacturing and selling the product entered into the profit maximization model 5 (information identifying each master used).
[0039] 13 is a diagram for explaining an example of a hardware configuration of the manufacturing and sales planning support device 10. The manufacturing and sales planning support device 10 includes a processing device 31 (processor) such as a CPU (Central Processing Unit), a main storage device 32 (memory) such as a RAM (Random Access Memory) or a ROM (Read Only Memory), an auxiliary storage device 33 such as an HDD (Hard Disk Drive) or an SSD (Solid State Drive), an input device 34 including a keyboard, a mouse, a touch panel, etc., and an output device 35 for displaying information on a screen including a monitor (display), etc.
[0040] The functions of the manufacturing and sales planning support device 10 are realized by the hardware of the manufacturing and sales planning support device 10, or by the processing device 31 of the manufacturing and sales planning support device 10 reading and executing each program stored in the main storage device 32 or the auxiliary storage device 33. These programs are stored in a storage device such as a secondary storage device, a non-volatile semiconductor memory, a hard disk drive, or an SSD, or a recording medium readable by an information processing device such as an IC card, an SD card, or a DVD. The manufacturing and sales planning support device 10 may be realized in whole or in part by using virtual information processing resources provided by using a virtualization technology or a process space separation technology, such as a virtual server provided by a cloud system. The functions provided by each information processing device may be realized in whole or in part by a service provided by a cloud system via an API (Application Programming Interface), for example. Next, the process performed by the manufacturing and sales planning support device 10 will be described.
[0041] <Production and sales planning support processing> 14 is a flow diagram illustrating an example of a manufacturing and sales planning support process for supporting a manufacturing and sales plan for a product, which is a task performed by a user. The manufacturing and sales planning support process is started, for example, when a predetermined input is made to the manufacturing and sales planning support device 10 by the user.
[0042] First, the simulation execution unit 19 of the manufacturing and sales planning support device 10 stores master data necessary for constructing a supply chain model (s11).
[0043] For example, the simulation execution unit 19 starts a predetermined editing application based on a start instruction from a user. The editing application accepts input of data values of each master, such as the procurement master 110, the manufacturing capacity master 210, the BOM master 220, the base cost master 230, the manufacturing base transaction master 310, the transportation master 320, the customs tariff master 330, and the greenhouse gas emission upper limit master 510, from the user, and creates and stores data files of each master. Note that the exchange master 340 and the country base master 520 are also created as necessary.
[0044] Here, it is assumed that the user sets the data value of the greenhouse gas emission upper limit value 512 in the greenhouse gas emission upper limit master 510 to “no upper limit” (e.g., a sufficiently large value) in order to confirm how much profit would be made if there were no limit on greenhouse gas emissions.
[0045] Then, the simulation execution unit 19 receives from the user the selection of the master created in s11, and registers the selected master (s13). For example, the simulation execution unit 19 displays a predetermined input screen and receives from the user the registration of a data file of the master to be used in executing the simulation.
[0046] Furthermore, the plan information acquisition unit 13 registers the sales plan (plan information) planned by the user (s15). For example, the plan information acquisition unit 13 starts a predetermined editing application in response to a start instruction from the user. The editing application accepts input of each data value from the user, such as the item of each product to be manufactured, the sales base of each product, the sales destination of each product, the demand amount at the sales destination of each product (i.e., the planned manufacturing amount of the product), the sales price of each product, the designated manufacturing base (optional) of each product, the internal transaction selling price of each product, and the required supply amount of each product (optional), and creates and stores a data file of the sales plan master 410 having the input data values. After the above editing application is terminated, the plan information acquisition unit 13 displays a predetermined input screen (described later) and accepts registration of the data file saved by the editing application from the user.
[0047] Here, Fig. 15 is a diagram showing an example of the registered manufacturing capacity master 210. In this example, different numbers or types of manufacturing equipment are provided at each manufacturing base. Also, some of these manufacturing equipment can manufacture multiple types of products. Also, some of the same products can be manufactured using different manufacturing equipment.
[0048] 16 is a diagram showing an example of the registered sales plan master 410. In this example, sales plans for multiple products to multiple sales bases are made, and required supply amounts are set for some products. In addition, multiple manufacturing bases are set for some products.
[0049] (Input screen) 17 is a diagram showing an example of an input screen. This input screen 800 has a file import field 801 for receiving the designation of a data file of each master, a master number registration field 802 for receiving the designation of a data number of each master, and a registration field 803 for confirming the registration of the master (data file) designated in the file import field 801.
[0050] 14, the manufacturing and sales planning support device 10 executes a simulation execution process (s17) to create a profit maximization model 5 based on the masters registered in s11 to s15 and obtain each output value by executing the model (s17). The details of the simulation execution process will be described later.
[0051] As described below, the output values are, for example, the sales and profit amounts of each product for each sales base (and manufacturing base), as well as greenhouse gas emissions in each country. If there are multiple patterns (supply chain patterns) for each process of product procurement, manufacturing, and sales, the profit maximization model 5 is executed for each supply chain pattern, and only the output value for the supply chain pattern with the highest profit amount is output. These output values are output to the simulation result DB 510. The execution results of the profit maximization model 5 are also displayed on the simulation execution screen, which will be described next.
[0052] (Simulation execution screen) 18 is a diagram showing an example of a simulation execution screen. The simulation execution screen 820 includes a master display field 821 that accepts registration of each master and displays the data number of each registered master, a name setting field 822 that sets the name of the execution of the profit maximization model 5 using the master displayed in the master display field 821, an execution start field 823 for starting the execution of the profit maximization model 5, and an execution result field 824 that displays information on each execution result.
[0053] The master display field 821, which displays information about each master (master data number) used in the profit maximization model 5, enables the user to confirm the contents of the process for manufacturing and selling products when profits are maximized.
[0054] The execution result field 824 includes a master list 825 that displays a list of master data numbers registered for each execution, and a result display field 826 that displays information on the results of each execution, etc. When the result display field 826 is specified by the user, the contents of the model execution (for example, the contents of the simulation result DB 610) are displayed.
[0055] Next, as shown in FIG. 14, the supply chain pattern creation unit 17 compares the greenhouse gas emissions for each country output in s17 with the upper limit values of greenhouse gas emissions for each country set in the greenhouse gas emission upper limit master 510 (s19).
[0056] If there is a country whose greenhouse gas emissions output by the profit maximization model 5 exceed the upper limit of greenhouse gas emissions set in the greenhouse gas emission upper limit master 510 (s19: YES), the supply chain pattern creation unit 17 executes processing of s21, and if there is no country whose greenhouse gas emissions output by the profit maximization model 5 exceed the upper limit of greenhouse gas emissions set in the greenhouse gas emission upper limit master 510 (s19: NO), the supply chain pattern creation unit 17 stores the output value in s17 as result information and executes processing of s25.
[0057] In s21, the simulation execution unit 19 receives a reset registration of the upper limit of greenhouse gas emission from the user. For example, the simulation execution unit 19 starts a predetermined editing application based on a start instruction from the user. The editing application receives an input of the upper limit value of greenhouse gas emission in the greenhouse gas emission upper limit master 510 from the user.
[0058] Then, the simulation execution unit 19 executes a simulation execution process for executing the profit maximization model 5 based on the upper limit value of greenhouse gas emissions set in s21, similarly to s17 (s23).
[0059] In s25, the supply chain pattern creation unit 17 displays the final output value output by the simulation execution process on a predetermined result display screen. The user performs operations such as manufacturing and sales of the product based on the contents displayed on this result display screen. This ends the manufacturing and sales plan formulation support process. Next, the simulation execution process will be described in detail.
[0060] <Simulation execution process> FIG. 19 is a flow diagram illustrating the details of the simulation execution process.
[0061] The supply chain model creation unit 15 reads the masters registered in s13 and s15 (s51, s53).
[0062] Based on the data read in s51 and s53, the supply chain model creation unit 15 creates information on the relationships between each node (supply chain model) for each product, with the material suppliers, the manufacturing bases for the materials (intermediate products) or products, the equipment within the manufacturing bases, and the sales bases for the products as nodes, and the connection information (transportation means) between these nodes as links (s55).
[0063] For example, the supply chain model creation unit 15 generates a supply chain model by identifying the flow of a series of processes related to procurement of materials, production of materials (intermediate products) or products, and sales of products based on the country base master 520, the manufacturing bases 112 and suppliers 113 in the procurement master 110, and the manufacturing bases 211 and equipment names 212 in the manufacturing capacity master 210.
[0064] Then, the supply chain model creation unit 15 creates each piece of information, which is a constraint on the production of the product (e.g., a constraint on the supply chain model), as constraint information (s57), such as procurable items, procurable quantities, items that can be manufactured by the equipment, time during which the equipment can be manufactured, upper limit of equipment manufacturing value, possible shipping destinations, and upper limit of greenhouse gas emissions by country.
[0065] For example, the supply chain model creation unit 15 creates constraint information based on information from each record of the procurement items 111 in the procurement master 110 as procurement available items, the available supply quantities 115 in the procurement master 110 as procurement quantities, the manufactured items 213 in the manufacturing capacity master 210 as equipment manufacturable items, the number of available operating days 214 and required time 215 in the manufacturing capacity master 210 as equipment manufacturable times, the manufacturing upper limit value 216 in the manufacturing capacity master 210 as equipment manufacturing upper limit values, the shipping origin 312 and the destination 313 in the inter-manufacturing site transaction master 310 as possible shipping destinations, and the greenhouse gas emission upper limit value 512 in the greenhouse gas emission upper limit master 510 as the greenhouse gas emission upper limit value by country.
[0066] The greenhouse gas emission cap by country is the upper limit (upper limit for each country (region)) on greenhouse gas emissions generated by a series of processes related to the manufacture and transportation of products. For example, in a certain country, the total ((1) + (2) + (3)) of (1) greenhouse gas emissions generated by the manufacture of materials at the supplier, (2) greenhouse gas emissions generated by the manufacture of products (corresponding to the amount of greenhouse gases generated during the manufacture of products, or the amount of electricity required to operate equipment), and (3) greenhouse gas emissions generated by the transportation of products or materials (the amount of greenhouse gases generated during transportation) must be less than or equal to the greenhouse gas emission cap.
[0067] Next, the supply chain pattern creation unit 17 creates a supply chain pattern (s59).
[0068] That is, the supply chain pattern creation unit 17 creates each combination of items 411, sales bases 412, and sales destinations 413 in the planning information read in s53, and for each combination, creates all patterns of procurement sources, manufacturing bases, manufacturing facilities, transportation routes, and transportation means for each case in which the demand quantity (manufacturing quantity or sales quantity) is changed from 0 (minimum value) to the value (maximum value) of the demand quantity 414 read in s13.
[0069] Specifically, when the same item of finished product or intermediate product can be manufactured by different manufacturing bases or manufacturing facilities, the supply chain pattern creation unit 17 creates a supply chain pattern for each case where those manufacturing bases and manufacturing facilities are used, by referring to the supply chain model and the manufacturing capacity master 210, etc. In this case, only a part of the set production volume may be allocated to the other manufacturing bases or manufacturing facilities.
[0070] Furthermore, when it is possible to procure the same material item from a plurality of different suppliers, the supply chain pattern creation unit 17 creates a supply chain pattern for each case in which the material is procured from those suppliers by referring to the supply chain model and the procurement master 110, etc. In this case, only a portion of the set procurement amount may be allocated to the other suppliers.
[0071] Furthermore, when it is possible to transport materials or products using a plurality of different transport routes (transport routes from supplier to manufacturing base to sales destination) or transport means, the supply chain pattern creation unit 17 creates a supply chain pattern for each of the cases where those transport routes and transport means are used, by referring to the supply chain model and the transport master 300, etc. In this case, only a portion of the set production volume may be allocated to the other transport routes or transport means.
[0072] FIG. 20 is a diagram for explaining an example of a supply chain pattern. As shown in the figure, when the sales destinations of item A are country A, country J, and region E, the demands are 100t, 200t, and 150t, respectively, and there is no restriction on the manufacturing base when the sales destination is region E (reference numeral 840), the corresponding supply chain pattern 860 includes "pattern a" in which the manufacturing base when the sales destination is region E is only country J (demand amount 150t), "pattern b" in which the manufacturing bases when the sales destination is region E are country J and country C (demand amount 149t and 1t, respectively), and "pattern c" in which the manufacturing bases when the sales destination is region E are country J and country C (demand amount 50t and 150t, respectively). For each supply chain pattern, the greenhouse gas emissions related to the production of the product for each sales country and the greenhouse gas emissions in each emitting country are calculated.
[0073] 19, the simulation execution unit 19 creates a profit maximization model 5 in which the supply chain model created in s55 and the constraint information (constraint conditions) created in s57 are set. Then, the simulation execution unit 19 selects one of the supply chain patterns created in s59, inputs the selected supply chain pattern into the created profit maximization model 5, and executes the profit maximization model 5. The profit maximization model 5 outputs, corresponding to each supply chain pattern, information on the sales volume of the product, the sales profit of the product, the total amount of greenhouse gas emissions caused by the manufacture of the product, the manufacturing equipment used in the manufacture of the product, the supplier of materials necessary for the manufacture of the product, the procurement amount of materials necessary for the manufacture of the product, and the transportation means of the product or materials.
[0074] In this embodiment, the profit maximization model 5 is a model based on linear programming. For example, the profit maximization model 5 includes, as its components, a function representing a supply chain model, a function representing constraint conditions, and a function representing input values, and is an objective function that calculates the amount of profit from the manufacture and sale of a product. The simulation execution unit 19 also outputs the value of each variable when the amount of profit, which is the value of the objective function, is maximized. That is, when calculating and outputting the maximum amount of profit, the profit maximization model 5 outputs information obtained or used in the process of the calculation (for example, the amount of sales, the manufacturing equipment used, the source of procurement of materials, the amount of procurement of materials, the means of transportation, the amount of greenhouse gas emissions, etc.).
[0075] In the calculation process, the profit maximization model 5 calculates the sales amount of a product by multiplying the sales volume and sales price of the product. The profit maximization model 5 also calculates the profit of each product in each country by deducting expenses (for example, the amount of customs duties calculated based on the internal transaction unit price, the purchase amount of materials, the variable and fixed expenses at the manufacturing base, and transportation expenses) from sales, and converting the sales and expenses using the exchange rate of each country. The profit maximization model 5 also calculates the total amount of greenhouse gas emissions for each product by finding the sum of the greenhouse gas emissions caused by the procurement of the materials, the greenhouse gas emissions caused by the production of the materials or products, and the greenhouse gas emissions caused by the management and maintenance at the manufacturing base (allocated greenhouse gas emissions).
[0076] Here, Fig. 21 is a diagram for explaining an example of the configuration of a supply chain model. This supply chain model 880 stores, as nodes, a material supplier 881 (supplier), a manufacturing base 882 (a factory at a base in a country) that manufactures other materials or products from the material, manufacturing equipment 883 installed at the manufacturing base 882, and a sales base 884 (country) that is a shipping destination from the manufacturing base 882. In addition, this supply chain model 880 stores, as links, a transportation route 885 between the supplier 881, the manufacturing base 882, and the sales base 884.
[0077] In addition, this supply chain model 880 has constraint information 886 (shipping destination) regarding sales bases 884, constraint information 887 regarding manufacturing bases 882 (items that can be manufactured by the equipment, available manufacturing time for the equipment, upper limit of manufacturing value for the equipment), and constraint information 888 between the supplier 881 and manufacturing bases 882 (items that can be procured, procurement amount).
[0078] This supply chain model 880 also has constraint information 889 (maximum greenhouse gas emissions per country (region)) regarding greenhouse gas emissions generated by a series of processes including transportation between the supplier 881 and manufacturing site 882, between manufacturing sites 882, and between the manufacturing site 882 and sales site 884, as well as management, maintenance, and production at the manufacturing site 882.
[0079] 19, the simulation execution unit 19 selects one of the supply chain patterns created in s59 (s61), obtains an output value for the selected supply chain pattern by inputting the profit maximization model 5, and stores the obtained output value in the temporary storage DB (s63). Note that if the simulation execution unit 19 does not obtain an output value that satisfies the constraint conditions, it performs the process of s69, which will be described later.
[0080] The simulation execution unit 19 compares the profit amount output this time in s63 with the profit amount calculated last time in s63 (0 if s65 is executed for the first time) (s65). If the profit amount output this time is greater than the profit amount calculated last time (s65: YES), the simulation execution unit 19 sets the profit amount output this time as the maximum profit amount and stores this in the simulation result DB 610 (s67), and then performs the process of s69. On the other hand, if the profit amount output this time is less than or equal to the profit amount calculated last time (s65: NO), the simulation execution unit 19 performs the process of s69.
[0081] In s69, the simulation execution unit 19 checks whether there are other supply chain patterns, and if there are other supply chain patterns, the processing from s61 onwards is repeated for the other supply chain patterns. If there are no other supply chain patterns, the simulation execution unit 19 ends the simulation execution processing.
[0082] (Simulation results DB) 22 is a diagram showing an example of a simulation result DB 610. The simulation result DB 610 has data items of an item 611 in which information on the item of a manufactured product is set, a sales base 612 in which information on a sales base of the product is set, a sales volume 613 in which the sales volume of the product at the sales base is set, a sales price 614 in which the sales price of the product is set, a manufacturing base 615 in which information on a manufacturing base of the product sold at the sales base is set, sales 616 in which information on the sales amount of the product is set, a profit 617 in which the profit amount based on the sales of the product is set, an unmanufacturable quantity 618 in which information on the quantity of the product that could not be manufactured against the demand at the sales base is set, a manufacturing facility 619 in which information on a manufacturing facility used for manufacturing the product manufactured at the manufacturing base is set, a supplier 620 in which information on a supplier of materials for the product manufactured at the manufacturing base is set, a procurement quantity 621 in which the procurement quantity of the materials is set, a transportation means 622 in which information on a transportation means of the materials is set, and a greenhouse gas emission amount 623 in which the total amount of greenhouse gas emission generated in a series of processes in the manufacturing of the product sold at the sales base is set.
[0083] As described above, the manufacturing and sales plan development support device 10 of this embodiment inputs information (planning information) regarding the sales destinations of the product and the demand at those destinations, and multiple supply chain patterns, which are information including patterns of each process in the manufacture and sale of the product with a production volume corresponding to the demand, into the profit maximization model 5, to calculate the maximum profit that can be obtained based on each supply chain pattern with greenhouse gas emissions below a specified upper limit, and calculates the amount of greenhouse gas emissions emitted by each of the above processes.
[0084] In other words, the manufacturing and sales planning support device 10 of this embodiment can calculate the maximum profit that can be obtained without greenhouse gas emissions exceeding a specified upper limit, based on a pattern of manufacturing and selling products in quantities that correspond to demand at the sales destination.
[0085] In this way, the manufacturing and sales plan formulation support device 10 of this embodiment can support the formulation of a manufacturing and sales plan that can comply with the limits on greenhouse gas emissions.
[0086] Furthermore, the manufacturing and sales planning support device 10 of this embodiment creates multiple production volume patterns that are equal to or less than the demand amount, and inputs each of the supply chain patterns related to the created production volume patterns into the profit maximization model 5, thereby calculating the maximum profit and the greenhouse gas emissions.
[0087] This makes it possible to calculate the maximum profit when producing any amount of product while still complying with the upper limit of greenhouse gas emissions.
[0088] Moreover, the manufacturing and sales planning support device 10 of this embodiment creates a plurality of patterns of product manufacturing bases or product manufacturing facilities at the manufacturing bases as supply chain patterns.
[0089] This allows for the calculation of the maximum profit that can be obtained without exceeding a specified greenhouse gas emission limit, taking into account cases where a product can be manufactured at multiple manufacturing sites or facilities.
[0090] Moreover, the manufacturing and sales planning support device 10 of this embodiment creates a plurality of patterns of suppliers of materials necessary for manufacturing the product as supply chain patterns.
[0091] This allows the system to calculate the maximum profit that can be obtained without exceeding a certain limit on greenhouse gas emissions, taking into account multiple options for material procurement.
[0092] Furthermore, the manufacturing and sales planning support device 10 of this embodiment creates, as supply chain patterns, a plurality of patterns of transportation routes or transportation means for the product or materials required for manufacturing the product.
[0093] This makes it possible to calculate the maximum profit that can be obtained without exceeding a predetermined upper limit on greenhouse gas emissions, taking into account multiple transportation routes and means of transportation when there are multiple transportation routes and means of transportation.
[0094] In addition, the manufacturing and sales planning support device 10 of this embodiment displays information on the maximum profit calculated by the profit maximization model 5, and also displays information on the processes for manufacturing and selling the product that were input into the profit maximization model 5.
[0095] This allows the user to know the specific details of a production and sales plan that can comply with the greenhouse gas emission limits.
[0096] The above description of the embodiment is for the purpose of facilitating understanding of the present invention, and is not intended to limit the present invention. The present invention may be modified or improved without departing from the spirit of the present invention, and the present invention includes equivalents thereof.
[0097] For example, the configuration of each functional unit included in the manufacturing and sales planning support device 10 is an example, and for example, a certain functional unit may be provided in another functional unit, or multiple functional units may be integrated into one functional unit. Also, some of the functional units of the manufacturing and sales planning support device 10 may be provided in another information processing device capable of communication.
[0098] Furthermore, the data items of each master described in this embodiment are merely examples, and other items may be added or some of the items may be omitted.
[0099] Furthermore, in this embodiment, the upper limit of greenhouse gas emissions is set for each country, but it may be set for other units (for example, base, procurement, or manufacturer). [Explanation of symbols]
[0100] 5. Profit maximization model 10. Manufacturing and sales planning support device 11 Profit maximization model memory section 15 Supply Chain Modeling Department 17 Supply Chain Pattern Creation Department 19 Simulation Execution Department 21 Result display section
Claims
1. A processor and a memory, a numerical model storage unit that stores a numerical model that uses as input values a sales destination of a product whose production and sale involves greenhouse gas emissions, the demand at the sales destination, and a process for producing and selling the product, and calculates as output values a maximum profit that can be obtained based on the process with greenhouse gas emissions below a predetermined upper limit, and the amount of greenhouse gas emissions emitted by the process; A planning information acquisition unit that acquires information regarding a sales destination of the product and a demand amount at the sales destination; a supply chain pattern creation unit that creates a plurality of supply chain patterns, the supply chain patterns being information including patterns of each process in the manufacture and sale of the product in a production amount corresponding to the demand amount; a simulation execution unit that inputs each of the created supply chain patterns into the numerical model together with the acquired sales destinations and the production volume, thereby calculating the maximum profit that can be obtained based on each of the supply chain patterns with greenhouse gas emissions equal to or less than the predetermined upper limit, and the greenhouse gas emissions emitted by the process; A manufacturing and sales planning support device comprising:
2. the supply chain pattern creation unit creates a plurality of production volume patterns equal to or less than the acquired demand volume, and inputs each of the supply chain patterns relating to the created production volume patterns into the numerical model, thereby calculating the maximum profit and the greenhouse gas emission amount.
2. A manufacturing and sales planning support device according to claim 1.
3. the supply chain pattern creation unit creates, as the supply chain pattern, a plurality of patterns of a manufacturing base of the product or a manufacturing facility of the product at the manufacturing base; 2. A manufacturing and sales planning support device according to claim 1.
4. the supply chain pattern creation unit creates, as the supply chain pattern, a plurality of patterns of suppliers of materials necessary for manufacturing the product; 2. A manufacturing and sales planning support device according to claim 1.
5. the supply chain pattern creation unit creates, as the supply chain pattern, a plurality of patterns of transportation routes or transportation means for the product or materials required for manufacturing the product; 2. A manufacturing and sales planning support device according to claim 1.
6. 2. The manufacturing and sales planning support device according to claim 1, further comprising a result display unit that displays information on the maximum profit calculated by the numerical model and also displays information on the process for manufacturing and selling the product that was input into the numerical model.
7. An information processing device, a numerical model storage process for storing a numerical model that uses as input values the sales destinations and the demand at the sales destinations of a product whose production and sale involve greenhouse gas emissions, and the process for producing and selling the product, and calculates as output values the maximum profit that can be obtained based on the process with greenhouse gas emissions below a predetermined upper limit, and the greenhouse gas emissions emitted by the process; A planning information acquisition process for acquiring information regarding a sales destination of the product and a demand amount at the sales destination; a supply chain pattern creation process for creating a plurality of supply chain patterns, the supply chain patterns being information including patterns of each process in the manufacture and sale of the product in a production amount corresponding to the demand amount; a simulation execution process for calculating the maximum profit that can be obtained based on each of the supply chain patterns with greenhouse gas emissions below the predetermined upper limit and the greenhouse gas emissions emitted by the process by inputting each of the created supply chain patterns into the numerical model together with the acquired sales destinations and the production volume; A manufacturing and sales planning support method that implements the above.
8. The information processing device, In the supply chain pattern creation process, a plurality of production volume patterns equal to or less than the acquired demand volume are created, and each of the supply chain patterns relating to the created production volume patterns is input into the numerical model, thereby calculating the maximum profit and the greenhouse gas emission amount. The manufacturing and sales planning support method according to claim 7.
9. The information processing device, In the supply chain pattern creation process, a plurality of patterns of a manufacturing base of the product or a manufacturing facility of the product at the manufacturing base are created as the supply chain pattern. The manufacturing and sales planning support method according to claim 8.
10. The information processing device, In the supply chain pattern creation process, a plurality of patterns of suppliers of materials necessary for manufacturing the product are created as the supply chain patterns. The manufacturing and sales planning support method according to claim 7.
11. The information processing device, In the supply chain pattern creation process, a plurality of patterns of transportation routes or transportation means for the product or materials required for manufacturing the product are created as the supply chain pattern. The manufacturing and sales planning support method according to claim 7.
12. The information processing device, executing a result display process for displaying information on the maximum profit calculated by the numerical model and displaying information on the process for manufacturing and selling the product that was input to the numerical model; The manufacturing and sales planning support method according to claim 7.
Citation Information
Patent Citations
Decision-making support system, decision-making support method, and decision-making support simulation program for business activity involving greenhouse gas emission,
JP2005267391A
Energy facility operation planning system and energy facility operation planning method
JP2009075876A
Sales plan support device, sales plan support method and sales plan support program
JP2021152869A
Supply chain evaluation device and supply chain evaluation method
WO2017094100A1
Supply chain model generation system, supply chain model generation method, and program
WO2019139086A1
