The present application claims priority from Japanese application JP2020-090440, filed on May 25, 2020, the contents of which is hereby incorporated by reference into this application.
The present invention relates to a plan coordination apparatus and a plan coordination method for swiftly drafting a production plan involving a plurality of business operators and making an alteration to the production plan.
In manufacturing sector, a plurality of management organizations are often involved in production processes of products, and an alteration made to one plan of a management organization may result in affecting other plans.
For example, in the case where a request is made from a distributor to increase product supplies in response to an increase in demand, an assembler is required not only to adjust its own assembly schedule but also make adjustments with a component manufacturer that receives component supplies from other company before giving a delivery date. Further, the component manufacturer gives a reply as to whether it can alter the schedule by making adjustments with other component manufacturers that supply subordinate components to itself, which is time-consuming and makes it difficult to give a delivery date swiftly.
In order to solve the above problem, PCT Patent Publication No. WO2015/068231 recites: “Proposed is a plan coordination system that allows to perform a process of achieving consistency between plans in an efficient and swift manner while simultaneously maintaining information confidentiality as appropriate among different organizations managing plans coordinated with each other. The plan coordination system includes an arithmetic unit executing: a process of creating public data from definition data of each plan, accepting, among process steps indicated by this public data, a user definition of information to be coordinated between the plans, applying the user definition to definition data of a corresponding plan, and preparing a plan coordination model; a process of giving a notification of the data to a management apparatus for other plan to coordinate with in the coordination relation when an alteration event occurs regarding the definition data, altering the plan coordination model on the basis of a preparation result of other plan reflecting the alteration event, and giving a notification of the altered data to the management apparatus for other plan having the coordination relation with the plan that has been altered as a result of the alteration; and a process of outputting preparation results of respective plans when the all plans are complete.”
PCT Patent Publication No. WO2015/068231 describes a planning model for business operators whose plans are directly linked and does not take into consideration about coordination between a plurality of business operators or coordination between non-linked business operators.
PCT Patent Publication No. WO2015/068231 is premised on the fact that real-time data is available at the time of plan coordination. In the case where a data quality and a data acquisition frequency or cycle are not as anticipated, a departure from a current status may occur.
PCT Patent Publication No. WO2015/068231 does not describe any processes to be performed in the case where an event occurs that prevents coordination (there is no solution to fulfill the plan).
In light of the foregoing, the present invention provides plan coordination means that, when a business operator faces a request to alter a production plan, not only swiftly judging whether a supplier having a track record of product order placement/receipt-relation to or from the business operator can alter a plan, but also identifying even a supplier having no track record of product order placement/receipt-relation to or from the business operator as an alternative business operator by using reliability based on a track record of product order placement/receipt-relation to or from other business operator as a judgement criterion for coordination.
In a preferred example of the present invention, a plan coordination apparatus includes a first database, a second database, a third database, value chain management means, and scheduling means. The first database registers each business operator to be managed as a node having a business operator type and product information and stores value chain data that connects the nodes to each other by using an edge that is assigned a reliability index value for order placement/receipt-relation in association with a track record of order placement/receipt-relation between the business operators. The second database stores components included in a new product and quantities of the components as product data in BOM format, the components and quantities of the components being reported by each of the business operators before a production plan of the new product is drafted. The third database stores plan data disclosing a product delivery plan between the business operators and automatically adjustable volumes indicating a maximum possible increase in production volume in addition to a scheduled production volume, the product delivery plan and the automatically adjustable volumes being reported by each of the business operators when a schedule is drafted to produce and deliver (e.g., transport) a product. The value chain management means prepare value chain data, recalculate reliability of order placement/receipt-relation between the business operators each time a new track record of product order placement/receipt-relation is collected, updates the reliability, and assign the reliability to the edge. The scheduling means accept a plan alteration request from one of the business operators to be managed, refer to automatically adjustable volumes of the product data, the value chain data, and the plan data from the respective databases, judge whether a related business operator can alter the plan, identify an alternative business operator, give a notification of the alteration of the plan to the business operator, and alter the plan data in the third database.
As another feature of the present invention, the value chain management means of the plan coordination apparatus register each of the business operators to be managed in a node information table of the first database together with final product ID of each of the business operators, are activated at a cycle at which track record data is collected, define, in a case where a new track record of product order placement/receipt-relation between the business operators is collected, a new edge connecting the nodes of the two business operators to each other in an edge information table of the first database, and recalculate reliability of order placement/receipt-relation between the business operators on the basis of the track record data, update the reliability, and assign the reliability to the edge in the case where a new track record of order placement/receipt-relation is collected between existing business operators.
The plan coordination apparatus of the present invention has an advantageous effect of allowing a highly reliable plan to be drafted with minimal calculations even in the case where a plan cannot be fulfilled between related business operators having a track record.
A plan coordination apparatus and a plan coordination method for realizing the present invention will be described below with reference to drawings.
The value chain management means 1011 of the plan coordination apparatus of the present embodiment register each business operator to be managed in a node information table 1111 of the value chain data DB 111 together with its final product ID. The product data acceptance means 1014 accept a quantity of a component included in a product as product data in BOM (Bill Of Material) format and register the product data in the product data DB 114 when a new product is planned by each business operator.
The schedule data acceptance means 1013 accept a schedule data report from each business operator when the business operator drafts a schedule to produce and deliver (e.g., transport) a product (or component and the like), and record the report to a schedule data table 1131 and an automatically adjustable data table 1132 of the schedule data DB 113.
The track record collection means 1012 collect track record data related to order placement/receipt-relation between business operators at a specified cycle, and record the track record data to the track record data DB 112. The value chain management means 1011 refer to the track record data in the track record DB 112 and define, in the case where a new track record of product order placement/receipt-relation between business operators is collected, an edge connecting nodes of the two business operators to each other in an edge information table 1112 of the value chain data DB 111. Reliability of order placement/receipt-relation between the business operators is calculated and assigned to each edge of the edge information table 1112. The reliability is recalculated and updated each time new track record data is collected.
The scheduling means 1021 accept a plan alteration request from a certain business operator to be managed, refer to automatically adjustable volumes of target product data, value chain data, and schedule data, judge whether the plan can be altered, identify an alternative business operator, give a notification of the plan alteration to each business operator, and alter the schedule data.
The communication unit 207 is connected to the planning apparatuses 40 and the display apparatuses 20 of the respective target business operators to be managed, the display apparatus 30 of the manager, and the like via a network 70 such as a wired network or wireless network.
The main control unit 201 realizes each functional unit illustrated in
A call source node represents a source node in a directed graph connected by an edge and corresponds to a business operator that delivers (e.g., transports) a product (or component and the like). A call destination node represents a destination node in a directed graph connected by an edge and corresponds to a business operator to which a product (or component and the like) is delivered (e.g., transported).
The reliability is calculated as an index for assessing the extent to which the demand of the call destination node business operator has been fulfilled on the basis of track record data of past product (or component and the like) deliveries (e.g., transports) to the call destination node business operator. The reliability calculation formula is defined by the following formula:
Reliability=c1×(Delivery date-meeting level)+c2×(Defect rate)+c3×(Data update level) (Formula 1)
where the delivery date-meeting level represents the ratio of deliveries (e.g., transports) of products (or components and the like) meeting the delivery dates made by the call source node business operator in the past. (For example, this value is normalized such that it falls within a zero-to-one range).
The defect rate represents the ratio of inclusions of defects found as a result of quality inspection performed by the call destination node business operator following reception of products (or components and the like) delivered (transported) in the past. The rate may be increased by the number of defects. (For example, this value is normalized such that it falls within a zero-to-one range).
The data update level is calculated to be a value dependent upon the number of track records of deliveries (e.g., transports) of products (or components and the like) made by the call source node business operator to the call destination node business operator in the past. (For example, this value is normalized such that it falls within a zero-to-one range).
c1, c2, and c3 are factors equivalent to weights corresponding to respective elements of the reliability calculation process.
A reliability is calculated for each product (or component and the like), as many reliabilities as the number of combinations of a call source node business operator and a call destination node business operator are calculated and assigned to each edge. The data record 1112e in a first row of the edge information table 1112 is edge information that includes “E1” as the edge ID, “N1” as the call source node ID, “N2” supplier as the call destination node ID, and “10” as the reliability.
The track record collection means 1012 collect a track record of product order placement/receipt-relation between business operators every specified update cycle, and record the data to the track record data DB 112. In order to calculate reliability of order placement/receipt-relation between the business operators, the track record collection means 1012 collect delivery date-meeting information, defect rate information, placed/received order counts, and other data, and record such data together with past history.
The automatically adjustable volume 1132e indicates a maximum possible increase in production (or transport) volume in addition to a scheduled production (or transport) volume and is disclosed by each business operator by self-declaration in schedule data reported to the plan coordination apparatus 10 when a schedule is drafted to produce and deliver (e.g., transport) a product (or component and the like).
A data record 1132f in a second row of the automatically adjustable data table 1132 is plan data that includes “A” as the business operator name, “Component D” as the product name, “1/5” as the delivery date, “20” as the scheduled production volume, and “5” as the automatically adjustable volume meaning the production volume can be increased up to “5.”
The product data acceptance means 1014 of the plan coordination apparatus 10 accept a report of quantities of components included in a product as product data in BOM (Bill Of Material) format and register the report in the product data DB 114 when each business operator drafts a production plan to produce a new product.
Although not illustrated, product data stored in the product data DB 114 is in a list form depicting a total count of each component included in the product to be shipped from each business operator as a final product. A data record of each component has, as data items, an article name (product name and product ID), a model, a manufacturer name (business operator name and business operator ID), and a volume.
For example, for a supplier supplying a component, the component is a final product of that supplier. Therefore, the supplier (business operator) reports product data of the component (product). The product data acceptance means 1014 register the product data in a product data table 1141 of the product data DB 114. For example, the product data is in BOM format including subordinate components.
In step S101, the value chain management means 1011 activate the track record collection means 1012, and the track record collection means 1012 collect track record information by inquiring the provision source node ID business operator and the provision destination node ID business operator having the data update cycle about track record information.
In step S102, the value chain management means 1011 judge that there is a new node coordination if the track record data collected in step S101 has a new combination of a provision source node ID, a provision destination node ID, and a product ID, and proceeds to step S103. The value chain management means 1011 proceed to step S104 if the track record data has a hitherto existing node coordination.
In step S103, the value chain management means 1011 create a data record of new edge information in the edge information table 1112 of the value chain data DB 111 from the track record data judged as having a new node coordination in step S102. The value chain management means 1011 create a new edge ID in a field of the edge ID (1112a) of the new data record and enter the provision source node ID value in a field of the call source node ID (1112b) and the provision destination node ID value in a field of the call destination node ID (1112c).
In step S104, the value chain management means 1011 judge whether different and new track record data has been added by comparing, on the basis of the track record data collected in step S101, the newly collected track record data with track record data required to calculate Formula (1) including a delivery date-meeting level, a defect rate, and a data update level. In the absence of new track record data, the reliability remains unchanged. As a result, the value chain management means 1011 do not perform the calculation. In the presence of new track record data, the value chain management means 1011 calculate the reliability by including past track record data.
It should be noted that in the case where the value chain management means 1011 judge that there is a new node coordination, there is no previously calculated reliability. As a result, the value chain management means 1011 calculate a reliability on the basis of newly collected track record data.
In step S105, the value chain management means 1011 write the calculated reliability value to the field of the reliability 1112d in the data record of the edge ID of the edge information table 1112 of the value chain data DB 111 for update in the case where the reliability has been calculated in step S104.
In step S201, the scheduling means 1021 receive a plan alteration request of a business operator requesting a plan alteration in light of the schedule data stored in the schedule data DB 113.
In step S202, the scheduling means 1021 identify the node ID (1111a) of the business operator requesting a plan alteration on the node information table 1111 of the value chain data DB.
In step S203, assuming, for example, that an assembler A made an alteration request in step S203 and that this alteration is to produce five more products B, it becomes clear, with reference to the product data of the product B of the business operator A registered in the product data DB 114, that it is necessary to place an additional order of five pieces of each component included in the product B.
Each business operator (supplier) delivering each component included in the product B to the business operator A can be found by searching the track record data 1121. Therefore, the scheduling means 1021 search the automatically adjustable data table 1132 of the schedule data DB 113 for plans of the respective business operators (suppliers) to produce respective components included in the product B, thus confirming the business operator name, the delivery date in the data record of the product name, and the automatically adjustable volume. As a result of search for automatically adjustable data of the business operator D (supplier D) delivering a certain component C included in the product B to the business operator A, if its delivery date and automatically adjustable volume meet both the delivery date and the additional order volume, i.e., five additional pieces of the component C, resulting from a plan alteration of the business operator A, the scheduling means 1021 judge that the plan can be altered.
Alternatively, in the case where a plurality of business operators (suppliers), not just the business operator D (supplier D), deliver the component C included in the product B to the business operator A, and if the total of the automatically adjustable volumes by the respective business operators (suppliers) meets the additional order volume, i.e., five additional pieces of the component C, resulting from a plan alteration of the business operator A, and if the delivery date is met at the same time, the scheduling means 1021 judge that the plan can be altered.
As described above, the scheduling means 1021 judge, for each component included in the product B, whether the total of the automatically adjustable volumes by the respective business operators (suppliers) delivering the respective components to the business operator A meets the additional order volume, i.e., five additional pieces of the component C, resulting from a plan alteration of the business operator A, and whether the delivery date is met (the plan can be altered) or not (the plan cannot be altered).
In step S204, the scheduling means 1021 proceed to step S205 if there is even one component whose schedule cannot be altered and proceeds to step S209 when the schedules of all the components can be altered as a result of a judgment made for each component included in the product B in step S203 as to whether the plan can be altered.
In step S205, as a result of a judgment made for each component included in the product B in step S203 as to whether the schedule can be altered, the scheduling means 1021 perform the following processes on a component E (normally, there are a plurality of component types) whose schedule has been judged as unalterable.
The scheduling means 1021 make a list of the business operators capable of manufacturing the component E from the node information table 1111 of value chain data and identifies, among these business operators, a business operator F (a plurality of business operators may be identified) whose past track record of delivery to the business operator A (the fact that the business operator F is a linked node) has been confirmed from the edge information table 1112 of value chain data although a most recent track record of delivery is not discovered from the track record data table 1121. If one or more business operators F are identified, these business operators are identified, in order of decreasing reliability in edge information table 1112, as candidates for alternative nodes to which an additional order of five pieces of the component E can be placed.
As described above, the scheduling means 1021 judge, for all the components E, whether the business operator F is available as a candidate for alternative node and selects one or more business operators F identified as candidates for alternative nodes.
In step S206, the scheduling means 1021 proceed to step S208 if the business operators F have been identified as candidates for alternative nodes for all the components E in step S205 and proceeds to step S207 if no business operator F has been identified as a candidate for alternative node in step S205.
In step S207, the scheduling means 1021 perform the following processes on a component G (normally, there are a plurality of component types) for which no business operator F has been identified as a candidate for alternative node.
The scheduling means 1021 make a list of the business operators capable of manufacturing the component G from the node information table 1111 of value chain data and identifies, among these business operators, a business operator H (a plurality of business operators may be identified) whose track record of delivery of the component G to other business operators has been confirmed from the edge information table 1112 of value chain data although the business operator H has no past track record of delivery to the business operator A (the fact that the business operator H is a non-linked node). If one or more business operators H are identified, these business operators are identified, in order of decreasing reliability in edge information table 1112, as candidates for alternative nodes to which an additional order of five pieces of the component G can be placed.
As described above, the scheduling means 1021 judge, for all the components G, whether the business operator H is available as a candidate for alternative node and selects one or more business operators H identified as candidates for alternative nodes.
In step S208, the scheduling means 1021 determine, as business operators for the plan alteration, the business operator D whose schedule has been judged in step S203 as alterable within the bounds of the automatically adjustable volume for an additional order of the component C, the business operator F identified in step S205 as a candidate for alternative node to which an additional order of the component E can be placed, and the business operator H identified in step S207 as a candidate for alternative node to which an additional order of the component G can be placed.
In step S209, the scheduling means 1021 notify the business operator A that has requested a plan alteration that the plan can be altered and a request to send data about an altered plan, and notify the planning apparatuses 40 of the business operators judged in step S203 as capable of altering the plan, of a request to alter the plan for an additional order within the bounds of the automatically adjustable volume.
The scheduling means 1021 also notify the business operators selected in steps S205 and S207 as candidates for alternative nodes to which an additional order can be placed, of a request to send newly drafted plan data.
In step S210, the scheduling means 1021 accept plan data from the planning apparatuses 40 of the respective business operators notified, in step S209, of a request to send altered plan data or newly drafted plan data, and alter data records in the schedule data table 1131 and the automatically adjustable data table 1132 of the schedule data DB 113 or newly record the plan data, for plan alteration.
In step S211, the scheduling means 1021 write the most recent automatically adjustable volume reported from each business operator to the field of the automatically adjustable volume 1132e of the automatically adjustable data table 1132, according to the plan data accepted from each business operator in step S210, thus terminating its processes.
Number | Date | Country | Kind |
---|---|---|---|
JP2020-090440 | May 2020 | JP | national |
Number | Name | Date | Kind |
---|---|---|---|
20040107125 | Guheen | Jun 2004 | A1 |
20060059253 | Goodman | Mar 2006 | A1 |
20100161366 | Clemens | Jun 2010 | A1 |
20100205044 | Scheer | Aug 2010 | A1 |
20110295722 | Reisman | Dec 2011 | A1 |
20160267417 | Tomiyama et al. | Sep 2016 | A1 |
20170323403 | Johnson | Nov 2017 | A1 |
20190207807 | Mikhail | Jul 2019 | A1 |
20200134560 | Mclinden | Apr 2020 | A1 |
20200134745 | Mclinden | Apr 2020 | A1 |
20210173711 | Crabtree | Jun 2021 | A1 |
Number | Date | Country |
---|---|---|
2015068231 | May 2015 | WO |
Entry |
---|
Raza, Muhammad, System Reliability & Availability Calculations, Oct. 9, 2019, BMC Blogs, https://www.bmc.com/blogs/system-reliability-availability-calculations/, p. 1-23. (Year: 2019). |
Number | Date | Country | |
---|---|---|---|
20210365858 A1 | Nov 2021 | US |