Inventory management system, inventory management method, and recording medium
By designing a delivery period calculation device, calculating the supplier's follow-up rate and the purchase of goods, the problem of reduced delivery period accuracy in the prior art is solved, and more accurate delivery period calculation is achieved.
Patent Information
- Application Number
- CN202180012039.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Priority Date
- 2020-02-07
- Filing Date
- 2021-01-25
- Publication Date
- 2025-02-14
- Estimated Expiration
- 2041-01-25
AI Technical Summary
The prior art does not consider changes in the supply period of parts when calculating the delivery period, resulting in a reduction in the accuracy of the delivery period.
A delivery period calculation device is designed, including a follow-up rate calculation unit, a change rate calculation unit, an adequacy rate calculation unit, a delivery period calculation unit and a delivery period display unit. By calculating the supplier's follow-up rate and the rate of change of purchases, the item's adequacy rate is calculated, and the delivery period is calculated based on the adequacy rate.
Improve the accuracy of the delivery period of the customer, ensure that the delivery period is closer to the actual situation, and reduce the delivery period delay caused by component shortages.
Smart Images

Figure CN115023718B_ABST
Abstract
Description
Technical Field
[0001] The present disclosure relates to a delivery period calculation device, a delivery period calculation method, and a program. Background Art
[0002] In order to comply with the delivery dates required by customers, manufacturers of products need to improve the accuracy of their responses to customers regarding delivery dates, and the use of information processing systems including computer devices is indispensable.
[0003] As an example of such an information processing system, Patent Document 1 discloses a delivery period management system including a business terminal operated by a person in charge of business, a delivery period management terminal operated by a person in charge of managing the delivery period of a product, and a component procurement management terminal operated by a person in charge of component procurement. In the delivery period management system described in Patent Document 1, when the business terminal determines that the delivery period received from the delivery period management terminal is appropriate, the order information is sent to the delivery period management terminal, and the order is accepted based on the order information received by the delivery period management terminal. In addition, in the delivery period management system described in Patent Document 1, when the delivery period management terminal receives a survey request for the delivery period from the business terminal, the delivery period is calculated based on the component procurement answer received from the component procurement management terminal. In addition, in Patent Document 1, as an answer to the component procurement, the purchase period of the component with the longest purchase period is exemplified.
[0004] Prior art literature
[0005] Patent Literature
[0006] Patent Document 1: Japanese Patent Application Publication No. 2002-73936 Summary of the invention
[0007] The delivery date management system described in Patent Document 1 calculates the delivery date based on the delivery date of the parts when the delivery date survey is requested, and does not take into account changes in the delivery date of the parts after the delivery date survey is requested. Therefore, for example, after an order is confirmed, if the total order quantity increases due to other orders, the required quantity of parts increases, and the supply of parts from suppliers cannot keep up, and there is a possibility that the delivery date will be extended, there is a problem that the accuracy of the calculated delivery date becomes low.
[0008] The present disclosure has been made in view of the above-mentioned circumstances, and an object of the present disclosure is to improve the accuracy of answering customers about delivery dates.
[0009] In order to achieve the above-mentioned purpose, the delivery period calculation device involved in the present disclosure comprises a follow-up rate calculation unit, a change rate calculation unit, a sufficient rate calculation unit, a delivery period calculation unit and a delivery period display unit. When the quantity of items required from a supplier changes due to a change in a plan, the follow-up rate calculation unit calculates a follow-up rate representing the ratio of the quantity supplied by the supplier to the changed quantity based on the supplier's delivery performance. The change rate calculation unit calculates the change rate of the quantity of purchased items based on the quantity of purchased items in the current plan and the quantity of purchased items in the previous plan of the current plan. The sufficient rate calculation unit calculates the sufficient rate of the items in the current plan based on the follow-up rate calculated by the follow-up rate calculation unit and the change rate calculated by the change rate calculation unit. The delivery period calculation unit calculates the delivery period of the product using the items based on the sufficient rate calculated by the sufficient rate calculation unit. The delivery period display unit displays the delivery period information representing the delivery period calculated by the delivery period calculation unit.
[0010] According to the present disclosure, it is possible to calculate the availability of items based on the supplier's follow-up rate to the plan change and the change rate of the quantity of purchased items, and calculate the delivery date of the product using the item based on the calculated availability of the item. As a result, it is possible to improve the accuracy of the delivery date given to the customer. BRIEF DESCRIPTION OF THE DRAWINGS
[0011] Figure 1 It is a diagram showing a functional structure of a delivery period calculation device according to an embodiment of the present disclosure.
[0012] Figure 2 This is a block diagram showing the hardware configuration of the delivery date calculation device according to the present embodiment.
[0013] Figure 3A It is a diagram showing a display example of order information for receiving orders according to the present embodiment.
[0014] Figure 3B It is a diagram showing a display example of product master information according to the present embodiment.
[0015] Figure 3C It is a diagram showing a display example of the article master information according to the present embodiment.
[0016] Figure 4A It is a diagram showing a display example of product inventory information according to the present embodiment.
[0017] Figure 4B It is a diagram showing a display example of item inventory information according to the present embodiment.
[0018] Figure 4C It is a diagram showing a display example of order remaining information according to the present embodiment.
[0019] Figure 4D It is a diagram showing a display example of delivery performance information according to the present embodiment.
[0020] Figure 5A It is a diagram showing a display example of the production plan information involved in this embodiment.
[0021] Figure 5B It is a diagram showing a display example of procurement plan information according to the present embodiment.
[0022] Figure 5C It is a diagram showing a display example of assembly plan information according to the present embodiment.
[0023] Fig. 6A It is a diagram showing a display example of the assembly sufficiency rate information according to the present embodiment.
[0024] Figure 6B It is a diagram showing a display example of the item abundance ratio information according to the present embodiment.
[0025] Figure 6C It is a diagram showing a display example of input information according to the present embodiment.
[0026] Figure 7 This is a graph showing the relationship between the change in the purchase quantity and the supply quantity due to the change in the plan according to the present embodiment.
[0027] Figure 8 It is a diagram showing a display example of the delivery period calculation result screen according to the present embodiment.
[0028] Fig. 9 This is a flowchart showing the flow of the following rate calculation process according to the present embodiment.
[0029] Fig.10 This is a flowchart showing the flow of the plan change process according to the present embodiment.
[0030] Fig.11 This is a flowchart showing the flow of the delivery period calculation process according to the present embodiment.
[0031] (Explanation of symbols)
[0032] 50: internal bus; 51: control unit; 52: main storage unit; 53: external storage unit; 54: operation unit; 55: display unit; 56: sending and receiving unit; 59: control program; 100: delivery period calculation device; 110: storage unit; 111: order acceptance information storage unit; 112: product master information storage unit; 113: item master information storage unit; 114: inventory information storage unit; 115: order surplus information storage unit; 116: delivery performance information storage unit; 117: plan information storage unit; 118: sufficiency information storage unit; 119: input information storage unit; 120: follow-up rate calculation unit; 130: change rate calculation unit; 140: sufficiency rate calculation unit; 150: plan change unit; 160: delivery period calculation unit; 170: delivery period display unit; 180: input unit. DETAILED DESCRIPTION
[0033] Hereinafter, a delivery period calculation device, a delivery period calculation method, and a program for implementing the embodiment of the present disclosure will be described in detail with reference to the accompanying drawings. In addition, in the drawings, the same or corresponding parts are denoted by the same reference numerals.
[0034] The delivery period calculation device, delivery period calculation method and program involved in the embodiment of the present disclosure calculate the delivery period of the product that the manufacturer accepts the order from the customer. In addition, in this embodiment, the delivery period calculation device, delivery period calculation method and program calculate the delivery period when the procurement status of the items used in the product changes every day, under the premise that the equipment and personnel used to assemble the product are fully ensured and there are no problems in their working conditions.
[0035] Figure 1 2 is a diagram showing the functional structure of a delivery period calculation device according to an embodiment of the present disclosure. Figure 1 As shown, the delivery period calculation device 100 involved in this embodiment is, for example, an electronic computer such as a personal computer or a server. The delivery period calculation device 100 includes a storage unit 110 for storing information, and a follow-up rate calculation unit 120 for calculating the follow-up rate of the supplier of the items used in the product to the change in plan. Here, "items" include not only the parts and materials constituting the product, but also all items used in the manufacture of the product, and the state of the items can be any of solid, liquid, and gas. In addition, the follow-up rate to the change in plan specifically refers to the ratio of the quantity supplied by the supplier in accordance with the requirements to the quantity of items that are changed due to the change in the plan.
[0036] The delivery period calculation device 100 includes a change rate calculation unit 130 that calculates the change rate of the quantity of purchased items due to the change in the plan, a sufficient rate calculation unit 140 that calculates the sufficient rate of the items, and a plan change unit 150 that changes the plan. The delivery period calculation device 100 includes a delivery period calculation unit 160 that calculates the delivery period, a delivery period display unit 170 that displays delivery period information indicating the delivery period, and an input unit 180 that accepts information input from a user.
[0037] Figure 2 This is a block diagram showing the hardware configuration of the delivery date calculation device according to the present embodiment. Figure 1 The delivery period calculation device 100 shown is composed of Figure 2 The hardware structure shown in the figure is as follows. Figure 2 As shown, the delivery period calculation device 100 includes a control unit 51 , a main storage unit 52 , an external storage unit 53 , an operation unit 54 , a display unit 55 , and a transmission / reception unit 56 .
[0038] The control unit 51 performs processing according to the control program 59. The control unit 51 includes a CPU (Central Processing Unit). The control unit 51 functions as the following rate calculation unit 120, the change rate calculation unit 130, the sufficiency rate calculation unit 140, the plan change unit 150, and the delivery period calculation unit 160 of the delivery period calculation device 100 according to the control program 59. For example, the control unit 51 performs the following rate calculation step performed by the following rate calculation unit 120. In addition, the control unit 51 performs the change rate calculation step performed by the change rate calculation unit 130 and the sufficiency rate calculation step performed by the sufficiency rate calculation unit 140. In addition, the control unit 51 performs the sufficiency rate calculation step performed by the plan change unit 150 and the delivery period calculation step performed by the delivery period calculation unit 160.
[0039] The main storage unit 52 includes a RAM (Random-Access Memory) and is used as a working area of the control unit 51 by loading a control program 59 .
[0040] The external storage unit 53 stores the control program 59 in advance. The external storage unit 53 supplies the data stored in the program to the control unit 51 according to the instruction of the control unit 51, and stores the data supplied from the control unit 51. The external storage unit 53 has a non-volatile memory such as a flash memory, a HDD (Hard Disk Drive), and a SSD (Solid State Dive). The external storage unit 53 functions as the storage unit 110.
[0041] The operation unit 54 supplies input information to the control unit 51 . The operation unit 54 includes information input means such as a keyboard, a mouse, a touch panel, and operation buttons. The operation unit 54 functions as the input unit 180 .
[0042] The display unit 55 displays information inputted via the operation unit 54 , information outputted from the control unit 51 , and the like. The display unit 55 includes a display device such as an LCD (Liquid Crystal Display) or an organic EL (Electro-Luminescence) display. The display unit 55 functions as a delivery date display unit 170 .
[0043] The transmission and reception unit 56 transmits and receives information. The transmission and reception unit 56 includes information communication means such as a network terminal device and a wireless communication device connected to the network.
[0044] In the delivery period calculation device 100 , a main storage unit 52 , an external storage unit 53 , an operation unit 54 , a display unit 55 , and a transmission / reception unit 56 are connected to a control unit 51 via an internal bus 50 .
[0045] Figure 1 The delivery period calculation device 100 shown uses the main storage unit 52, the external storage unit 53, the operation unit 54, the display unit 55 and the sending and receiving unit 56 as resources through the control unit 51 to realize the functions of the storage unit 110, the follow-up rate calculation unit 120, the change rate calculation unit 130, the sufficiency rate calculation unit 140, the plan change unit 150, the delivery period calculation unit 160, the delivery period display unit 170, and the input unit 180.
[0046] Back to Figure 1 The storage unit 110 includes an order receiving information storage unit 111 for storing order receiving information indicating an order received from a customer, and a product master information storage unit 112 for storing product master information as basic information of a product. The storage unit 110 also includes an item master information storage unit 113 for storing item master information as basic information of an item, an inventory information storage unit 114 for storing inventory information indicating inventory of products and items, and an order remaining information storage unit 115 for storing order remaining information indicating order remaining of items. The storage unit 110 also includes a delivery performance information storage unit 116 for storing delivery performance information indicating actual delivery performance of a supplier, and a plan information storage unit 117 for storing plan information indicating a plan related to the manufacture of a product. The storage unit 110 also includes an adequacy information storage unit 118 for storing adequacy information indicating adequacy of items used for assembly, and an input information storage unit 119 for storing input information from a user.
[0047] Figure 3AFIG. 1 is a diagram showing an example of displaying order information for receiving orders according to the present embodiment. Figure 3A The information is displayed in the form of a table as shown. The order acceptance information includes information corresponding to each item such as the "order acceptance number" indicating the identification number of the order that the manufacturer accepts the order from the customer, the "customer name" indicating the name of the customer, the "product number" indicating the identification number of the product accepted for order, the "quantity" indicating the quantity of the products accepted for order, the "amount" indicating the total amount of the products accepted for sale, and the "delivery date" indicating the delivery date of the products accepted for order to the customer. For example, in the order acceptance number ON0001, the customer name is CL01, the product numbers of the two products are P01 and P02, the quantities of the two products are N01 and N02, the total amount is M01, and the delivery date is Ya / Ma / Da. That is, Figure 1 The received order information storage unit 111 shown stores information such as customer name, product number, quantity, amount, and delivery date for each received order as received order information. In addition, when receiving an order from a customer, the received order information storage unit 111 updates information on items other than the delivery date through input by a sales representative who is a user to the input unit 180. In addition, when the delivery date calculation unit 160 calculates the delivery date, the received order information storage unit 111 updates information on the delivery date.
[0048] Figure 3B 2 is a diagram showing an example of displaying the product master information according to the present embodiment. Figure 3B The information is displayed in the form of a table as shown. The product master information includes information corresponding to each item, such as the "product number" indicating the product identification number, the "product series" indicating the product series name, the "unit price" indicating the unit price of the product, the "used items" indicating the items used in the product, and the "assembly line" indicating the assembly line for assembling the product. For example, in a product with a product number of P01, the product series is PS01, the unit price is MP01, the items used in the product are IN01, IN02, ..., and the assembly lines of the product are L01, L02, .... That is, Figure 1 The product master information storage unit 112 shown stores information such as product series, unit price, used items, assembly line, etc. for each product as product master information. In addition, the product master information storage unit 112 updates information through input to the input unit 180 by a manufacturing manager as a user, for example, when deciding to start manufacturing of a product.
[0049] Figure 3C FIG. 2 is a diagram showing an example of displaying the item master information according to the present embodiment. Figure 3C The information is displayed in the form of a table as shown. The item master information includes information corresponding to each item, such as the "item code" indicating the identification number of the item, the "item name" indicating the name of the item, the "item group" indicating the group of the item, the "supplier" indicating the name of the supplier providing the item, the "purchase LT" indicating the purchase order period of the item, and the "purchase unit price" indicating the unit price when the item is purchased. For example, in a product with an item code of I01, the item name is IN01, the item group is IG01, the supplier is IS01, the purchase order period is ILT01, and the purchase unit price is MI01. That is, Figure 1 The item master information storage unit 113 shown stores, for each item, information such as the item name, item group, supplier, purchase order period, and purchase price as item master information. In addition, the item master information storage unit 113 updates information by inputting to the input unit 180 by a manufacturing manager who is a user, for example, when the start of manufacturing of a product is determined.
[0050] Figure 4A FIG. 2 is a diagram showing an example of displaying product inventory information according to the present embodiment. Figure 1 The inventory information storage unit 114 shown in the figure stores product inventory information indicating the inventory of products and item inventory information indicating the inventory of items as inventory information. The product inventory information is, for example, in the form of Figure 4A The information is displayed in the form of a table as shown. The product inventory information includes information corresponding to each item such as "product number", "total inventory quantity" indicating the total quantity of inventory of the product, "guaranteed inventory quantity" indicating the quantity of inventory of the product for which an order has been received, "unguaranteed inventory quantity" indicating the quantity of inventory of the product for which an order has not been received, and "update date" indicating the update date of the product inventory information. For example, in the product with product number P01, the total inventory quantity is TP01, the guaranteed inventory quantity is TPA01, the unguaranteed inventory quantity is TPB01, and the update date is Yc / Mc / Dc. That is, the inventory information storage unit 114 stores information such as the total inventory quantity, the guaranteed inventory quantity, the unguaranteed inventory quantity, and the update date as product inventory information for each product. In addition, the inventory information storage unit 114 updates the information by inputting to the input unit 180 by the inventory manager as a user, for example, when inventory management starts after the product is manufactured, when the inventory of the product for which an order has been received is guaranteed, etc.
[0051] Figure 4B 2 is a diagram showing an example of displaying the item inventory information according to the present embodiment. Figure 4BThe information is displayed in the form of a table as shown. The item inventory information includes information corresponding to each item such as "item code", "total inventory quantity" indicating the total inventory quantity of items, "guaranteed inventory quantity" indicating the inventory quantity of items assembled with guaranteed products, "unguaranteed inventory quantity" indicating the inventory quantity of items assembled with unguaranteed products, and "update date" indicating the update date of the item inventory information. For example, in the item with item code I01, the total inventory quantity is TI01, the guaranteed inventory quantity is TIA01, the unguaranteed inventory quantity is TIB01, and the update date is Ye / Me / De. That is, Figure 1 The inventory information storage unit 114 shown stores information such as the total inventory quantity, the guaranteed inventory quantity, the unguaranteed inventory quantity, and the update date for each item as item inventory information. In addition, the inventory information storage unit 114 updates information by inputting to the input unit 180 by the inventory manager as a user, for example, when inventory management starts after the purchase of items or when inventory is guaranteed for assembly of products.
[0052] Figure 4C 2 is a diagram showing an example of displaying the remaining order information according to the present embodiment. Figure 4C The remaining order information includes information corresponding to the following items: "Order Number" indicating the identification number of the order, "Item Code", "Order Date" indicating the order date, "Latest Scheduled Delivery Date" indicating the latest scheduled delivery date, "Scheduled Delivery Date before Delivery Date Change" indicating the scheduled delivery date before the delivery date is changed, "Latest Scheduled Delivery Quantity" indicating the latest scheduled delivery quantity, "Scheduled Delivery Quantity before Delivery Date Change" indicating the scheduled delivery quantity before the delivery date is changed, "Latest Scheduled Delivery Amount" indicating the latest scheduled delivery amount, "Scheduled Number of Deliveries" indicating the scheduled number of deliveries, and "Delivery Date Change History" indicating the delivery date change history. For example, in an order with order number HN0001, the item code is I01, the order date is Yg / Mg / Dg, the latest scheduled delivery date is Yh / Mh / Dh, the scheduled delivery date before the delivery date change is Yi / Mi / Di, the latest scheduled delivery quantity is N11, the scheduled delivery quantity before the delivery date change is N12, the latest scheduled delivery amount is M11, the scheduled number of deliveries is N13, and the delivery date change history is HH01, HH02, etc. That is, Figure 1The order remaining information storage unit 115 shown stores, for each order, information such as the item code, order date, latest scheduled delivery date, scheduled delivery date before delivery date change, latest scheduled delivery quantity, scheduled delivery quantity before delivery date change, latest scheduled delivery amount, scheduled number of deliveries, and delivery date change history as order remaining information. In addition, the order remaining information storage unit 115 updates the information by inputting to the input unit 180 the ordering person in charge as a user when ordering items from a supplier or when there is a change in the scheduled delivery date, scheduled delivery quantity, scheduled delivery amount, and scheduled number of deliveries after the order is placed.
[0053] Figure 4D 1 is a diagram showing an example of displaying the delivery performance information according to the present embodiment. Figure 4D The information is displayed in the form of a table as shown. The delivery performance information includes information corresponding to each item such as the "delivery number" which is the identification number of the delivery, the "order number", the "article code", the "delivery date" which indicates the delivery date, the "delivery quantity" which indicates the quantity delivered, and the "number of deliveries" which indicates the number of deliveries. For example, in the order with the delivery number NN0001, the order number is HN0001, the article code is I01, the delivery date is Ym / Mm / Dm, the delivery quantity is N11, and the number of deliveries is N13. That is, Figure 1 The delivery performance information storage unit 116 shown stores the order number, article code, delivery date, delivery quantity, delivery frequency, and other information for each delivery as delivery performance information. In addition, the delivery performance information storage unit 116 updates the information through input to the input unit 180 by the ordering person who is the user, for example, when there is a delivery by the supplier.
[0054] Figure 5A FIG. 2 is a diagram showing an example of displaying production plan information according to the present embodiment. Figure 1 The plan information storage unit 117 shown in FIG. 1 stores production plan information indicating a production plan for a product, purchase plan information indicating a purchase plan for an item, and assembly plan information indicating an assembly plan for a product as plan information. The production plan information is, for example, in the form of Figure 5A The information is displayed in the form of a table as shown. The production plan information includes information corresponding to each item such as "Plan Change Date" indicating the change date of the production plan, "Product Number", and "Plan Date" indicating the production date of the production plan. For example, in a production plan with a plan change date of Yo / Mo / Do, the product number is P01 and the plan date is Yp / Mp / Dp. That is, the plan information storage unit 117 stores information such as the product number and the plan date as production plan information for each plan change date. In addition, although not shown in the figure, in the production plan information, for each plan change date, the scheduled production quantity of the product on each scheduled production day is also stored.
[0055] Figure 5B 2 is a diagram showing an example of displaying the procurement plan information according to the present embodiment. Figure 5B The information is displayed in the form of a table as shown. The procurement plan information includes information corresponding to each item such as "update date" indicating the update date of the procurement plan, "item code", "purchase quantity" indicating the number of purchased items, and "target date" indicating the target date for evaluation of the procurement quantity. For example, in a procurement plan with an update date of Yr / Mr / Dr, the item code is I01, the purchase quantity is N31, and the target date is Ys / Ms / Ds. That is, Figure 1 The plan information storage unit 117 shown stores information such as article codes, purchase quantities, and target dates as purchase plan information for each update date.
[0056] Figure 5C 1 is a diagram showing an example of displaying assembly plan information according to the present embodiment. Figure 5C The information is displayed in the form of a table as shown. The assembly plan information includes information corresponding to each item such as "assembly number" representing the identification number of the assembly plan, "latest assembly scheduled date" representing the latest assembly scheduled date, "last assembly scheduled date" representing the last assembly scheduled date, "assembly product number" representing the identification number of the product to be assembled, "assembly quantity" representing the quantity of assembly, "assembly line", "assembly execution probability" representing the execution probability of assembly, and "update date" representing the update date of the assembly plan. For example, in the assembly plan with assembly number A01, the latest assembly scheduled date is Yu / Mu / Du, the last assembly scheduled date is Yv / Mv / Dv, the assembly product number is P01,..., the assembly quantity is N41, the assembly line is L01, the assembly execution probability is AS01, and the update date is Yw / Mw / Dw. That is, Figure 1 The plan information storage unit 117 shown stores the latest scheduled assembly date, the last scheduled assembly date, the assembly product number, the assembly quantity, the assembly line, the assembly execution probability, the update date, and other information as assembly plan information for each assembly. In addition, the plan information storage unit 117 stores information by inputting to the input unit 180 by a manufacturing manager as a user when making a production plan, and updates the information when the plan is changed by the plan change unit 150. In addition, the assembly number is assigned a larger number as the scheduled assembly date is delayed.
[0057] Fig. 6A FIG. 2 is a diagram showing an example of displaying assembly sufficiency rate information according to the present embodiment. Figure 1The sufficiency information storage unit 118 shown in FIG. 1 stores, as sufficiency information, assembly sufficiency information indicating the sufficiency of all items used for assembly and item sufficiency information indicating the sufficiency of each item used for assembly. The assembly sufficiency information is, for example, in the form of Fig. 6A The information is displayed in the form of a table as shown. The assembly adequacy rate information includes information corresponding to each item such as "assembly number", "follow-up rate" indicating the follow-up rate of the supplier of all items used for assembly to the plan, and "adequacy rate" indicating the adequacy rate of all items used for assembly. For example, in the assembly with assembly number A01, the follow-up rate is AF01 and the adequacy rate is AS01. That is, Figure 1 The shown sufficient rate information storage unit 118 stores information such as a follow-up rate and sufficient rate for each assembly as assembly sufficient rate information.
[0058] Figure 6B 1 is a diagram showing an example of displaying item abundance information according to the present embodiment. Figure 6B The information is displayed in the form of a table as shown. The item sufficiency information includes information corresponding to each item such as "item code", "follow-up rate" indicating the follow-up rate of the supplier of the supplied item to the plan change, "sufficiency rate" indicating the sufficiency rate of the item, and "update date" indicating the update date of the item sufficiency information. For example, for an item with item code I01, the follow-up rate is IF01, the sufficiency rate is IS01, and the update date is Yw / Mw / Dw. That is, Figure 1 The shown availability information storage unit 118 stores information such as the following rate, availability, and update date for each item as item availability information. The availability information storage unit 118 updates the information when the following rate calculation unit 120 calculates the following rate or the availability calculation unit 140 calculates the availability.
[0059] Figure 6C 2 is a diagram showing an example of displaying input information according to the present embodiment. Figure 6C The information is displayed in the form of a table as shown. The input information includes two types, "evaluation period" and "threshold value", and includes information corresponding to each item such as the value of these input information, the updater, and the update date, "value", "updater", and "update date". That is, Figure 1 The input information storage unit 119 shown stores information on the evaluation period and the value of the threshold, the updater, and the update date as input information. For example, in Yw / Mw / Dw as the update date, the value of the evaluation period is updated to VH01 and the value of the threshold is updated to VS01 by inputting W01 as the updater. In addition, the input information storage unit 119 updates information by inputting, for example, an input to the input unit 180 by a manufacturing manager as a user.
[0060] Figure 1 The following rate calculation unit 120 shown calculates the following rate based on the supplier's delivery performance information stored in the storage unit 110 .
[0061] The following rate calculation unit 120 first refers to the input information stored in the input information storage unit 119 to obtain the value of the evaluation period. Figure 6C VH01 is shown as the value of the evaluation period. Here, the value of the evaluation period is the value of the update period of the procurement plan determined by the manufacturing manager. For example, if the manufacturing manager determines the update period of the procurement plan to be a one-week period, and if a one-week period is an actual working period of 5 days, the value of the evaluation period becomes 5. Return to Figure 1 Next, the following rate calculation unit 120 refers to the item master information stored in the item master information storage unit 113 and selects an item to be evaluated for the following rate. For example, the following rate calculation unit 120 selects Figure 4B Items shown have item code I01.
[0062] Back to Figure 1 Next, the follow-up rate calculation unit 120 refers to the purchase plan information stored in the plan information storage unit 117 to obtain the purchase quantity of the selected item during the current evaluation period and the purchase quantity during the previous evaluation period. Figure 5B If the Ys / Ms / Ds as the target date is within the previous or current evaluation period, the follow-up rate calculation unit 120 obtains N31 as the purchase quantity and obtains all purchase quantities within the previous or current evaluation period for which the target date is the target date. Figure 1 Next, the following rate calculation unit 120 calculates a quantity obtained by subtracting a quantity obtained by accumulating the purchase quantity in the previous evaluation period day by day from a quantity obtained by accumulating the purchase quantity in the current evaluation period day by day.
[0063] In addition, as described above, the evaluation period is an update period of the procurement plan, so the follow-up rate calculation unit 120 obtains the planned procurement quantity of this time and the planned procurement quantity of the previous time, and calculates the planned change quantity as the difference between the quantity obtained by accumulating the planned procurement quantity of this time and the quantity obtained by accumulating the planned procurement quantity of the previous time. Specifically, when the evaluation period is set to T, the selected item is set to m, the natural number from 1 to T is set to t (1≦t≦T), the procurement quantity in the current evaluation period is set to N (m, t), and the procurement quantity in the previous evaluation period is set to O (m, t), the planned change quantity is a value calculated by the formula shown in the following formula 1.
[0064] [Formula 1]
[0065]
[0066] Next, the follow-up rate calculation unit 120 refers to the delivery performance information stored in the delivery performance information storage unit 116 to obtain the supply quantity supplied from the supplier during the current evaluation period. Figure 4D If the Ym / Mm / Dm of the delivery date shown is within the previous or current evaluation period, the follow-up rate calculation unit 120 obtains N11 as the delivery quantity and obtains the total delivery quantity with the delivery date within the previous or current evaluation period. Figure 1 Next, the following rate calculation unit 120 calculates the number obtained by subtracting the number obtained by accumulating the purchase quantity during the previous evaluation period from the number obtained by accumulating the supply quantity during the current evaluation period day by day. Therefore, the following rate calculation unit 120 calculates the following change quantity as the difference between the number obtained by accumulating the supply quantity supplied by the supplier following the increased purchase quantity due to the change from the previous plan to the current plan and the number obtained by accumulating the purchase quantity of the previous plan. Specifically, when the supply quantity during the current evaluation period is set to R(m, t), the following change quantity is a value calculated by the formula shown in the following formula 2.
[0067] [Formula 2]
[0068]
[0069] In addition, the follow-up rate calculation unit 120 calculates the follow-up rate by calculating the ratio of the follow-up change quantity to the planned change quantity, and stores the calculated follow-up rate as the follow-up rate of the item sufficiency rate information in the sufficiency rate information storage unit 118. Specifically, when the follow-up rate is set to T(m, t), the follow-up rate T(m, t) is a value calculated by the formula shown in the following formula 3. In addition, let N(m, 0) be the minimum value of the purchase quantity for which N(m, t) = R(m, t), and let O(m, 0) be the minimum value of the purchase quantity for which N(m, 0) = R(m, 0) is established in the previous evaluation.
[0070] [Formula 3]
[0071]
[0072] Figure 7 This is a graph showing the relationship between the change in the purchase quantity and the supply quantity due to the change in the plan involved in this embodiment. In addition, the follow-up rate T(m, t) does not become a negative value, and always becomes a value in the range of 0% to 100%. That is, with respect to the follow-up rate T(m, t), 0≦T(m, t)≦1 always holds. For example, in Figure 7In the graph shown, the planned purchase quantity last time is O(m, 0) = 0, O(m, 1) = 20, O(m, 2) = 40, O(m, 3) = 60, O(m, 4) = 80, O(m, 5) = 100. In addition, the planned purchase quantity this time is N(m, 0) = 0, N(m, 1) = 40, N(m, 2) = 60, N(m, 3) = N(m, 4) = N(m, 5) = 100. In addition, the planned supply quantity this time is R(m, 0) = 0, R(m, 1) = 20, R(m, 2) = 40, R(m, 3) = 80, R(m, 4) = R(m, 5) = 100. In this case, the following rate T(m, t) becomes T(m, t) = {(0-0)+(20-20)+(40-40)+(80-60)+(100-80)+(100-100) / (0-0)+(40-20)+(60-40)+(100-60)+(100-80)+(100-100)} = 40 / 100 = 0.4.
[0073] Back to Figure 1 The following rate calculation unit 120 repeatedly selects items and calculates the following rate until the following rates of all items to be evaluated are calculated.
[0074] Here, as the meaning of the formula shown in the above formula 3, when defining the supplier's ability to follow a new plan, the difference in the period required to follow the supply quantity R(m, t) as the new plan and the change in quantity caused by the change in plan are used as evaluation materials. For example, regarding the period, the value of the follow-up rate T(m, t) becomes larger in the case of faster follow-up. In addition, for example, regarding the quantity, even if it is impossible to follow completely, it is expected to infer the ability to supply goods by observing the degree of partial follow-up. For example, in Figure 7 In the graph shown, at t = 3, the purchase quantity increases as O(m, 3) = 60 and N(m, 3) = 100, whereas R(m, 3) = 80. Therefore, it is estimated that the system has the capability to follow only 20 increments out of 40 increments.
[0075] In addition, the above-mentioned follow-up capability can be interpreted as, for example, the capability of maintaining or operating the inventory of each item in the supplier, the delivery order period, the capability of the equipment for assembly, etc. Therefore, by observing the follow-up rate T(m, t), the delivery period calculation device 100 can, for example, estimate the tendency of the follow-up capability of each supplier common to all items, or estimate the tendency of the follow-up capability of each component common to all suppliers. As a result, in the delivery period calculation device 100, by observing the follow-up rate T(m, t), various situations applicable to changes in the procurement plan can also be expected. Therefore, the delivery period calculation device 100 can also adopt a method of storing and accumulating information representing the calculated follow-up rate T(m, t) for each evaluation period in order to be used for the estimation of the adequacy rate of the inventory described later.
[0076] In this case, when the follow-up rate calculation unit 120 statistically estimates the supplier's ability to follow, for example, the reliability of the estimation result increases as the number of samples used in the estimation increases, and ultimately the accuracy of the delivery date of the answer can be expected to increase. Therefore, when estimating the follow-up rate, the follow-up rate calculation unit 120 can also estimate the follow-up amount of the new plan based on the follow-up rate in each evaluation period calculated by tracing back to multiple evaluation periods in the past. For example, when n is set as a natural number, the follow-up rate calculation unit 120 calculates the follow-up rate for each evaluation period of t=0, -T, -2T, ..., -nT according to the formula shown in Formula 3, and calculates the average value of the calculated (n+1) follow-up rates as the follow-up rate of the new plan. That is, the following rate calculation unit 120 may also calculate the following rate of the new plan by taking the first following rate calculated based on the sample of the first period corresponding to t=0, the second following rate calculated based on the sample of the second period corresponding to t=-T, the third following rate calculated based on the sample of the third period corresponding to t=-2T, ..., the average of the (n+1)th following rate calculated based on the sample of the (n+1)th period corresponding to t=-nT.
[0077] Here, the reliability of the estimation result increases as the number of samples increases, so it is preferable that the value of n is statistically large. However, due to changes in the capabilities provided by the supplier, such as the addition of equipment, changes in the method of holding inventory, etc., the above-mentioned follow-up capabilities may be greatly changed. In this case, when estimating the above-mentioned follow-up capabilities, it is not appropriate for the follow-up rate calculation unit 120 to use the performance information before the change in the capabilities provided by the supplier.
[0078] Here, for example, consider a case where the average value of the following rate for a group of t=0, -T, ..., -nT and the average value of the following rate for a group of t=-nT, -(n+1)T, ..., -2nT are considered to have an intentional difference as an example of a predetermined relationship. In this case, the following rate calculation unit 120 can estimate that the following ability has changed in the evaluation period before and after t=-nT. Therefore, the following rate calculation unit 120 can also adjust the past evaluation period when the average value is calculated by calculating the following rate using the minimum n for which the above estimation is performed.
[0079] For example, when n=2, there is a case where the absolute value of the difference between the average value of the first follow-up rate and the second follow-up rate and the average value of the second follow-up rate and the third follow-up rate exceeds a predetermined threshold. In this case, the follow-up rate calculation unit 120 may calculate only the average value of the first follow-up rate and the second follow-up rate as the new planned follow-up rate. Thus, compared with a delivery period calculation device that calculates the average value of the first follow-up rate, the second follow-up rate, and the third follow-up rate as the new planned follow-up rate, the delivery period calculation device 100 can calculate an appropriate follow-up rate based on the performance information after the capacity change provided by the supplier.
[0080] In addition, in the detection of the difference in the mean values of the following rates of the above two groups, for example, the conventionally known t-test can also be used. Here, the t-test refers to a statistical test that is performed using the conventionally known t-distribution in which the test statistic calculated based on the sample extracted does not depend on the mean and variance of the parent group of the sample when the valueless hypothesis, that is, the null hypothesis, is correct. In the t-test, if the calculated test statistic is a value included in the range of 5% or less, which is the significance level of the t-distribution, the null hypothesis is not adopted and the opposite hypothesis that is opposite to the null hypothesis is adopted. Therefore, in the delivery period calculation device 100, for example, the assumption that the difference in the mean values of the following rates of the above two groups is less than a threshold is set as the null hypothesis. If the test statistic calculated based on the difference in the mean values of the following rates of the two groups becomes a value within the range of 5% or less of the t-distribution, the null hypothesis is not adopted, so it is considered that there is a significant difference in the mean values of the following rates of the two groups.
[0081] Therefore, in the delivery period calculation device 100, for example, the range of n may be set to 10 to 100, and the average values of the follow-up rates of the two groups may be repeatedly calculated from the minimum value of 10 to the maximum value of 100 to perform a t-test, and the value of n at which the probability that no significant difference occurs in the average values of the follow-up rates of the two groups is minimized may be adopted. Specifically, the value of n at which the absolute value of the test statistic is the largest among the values of n in the range where the test statistic is less than 5% of the t-distribution may be adopted. By estimating the above-mentioned follow-up capability based on the value of n selected in this way, it is possible to calculate an appropriate follow-up rate based on the performance information after the capability supplied by the supplier has changed.
[0082] Back to Figure 1 The change rate calculation unit 130 calculates the change rate between the current planned purchase quantity and the last planned purchase quantity of the item to be evaluated. The change rate calculation unit 130 calculates the change rate by calculating the ratio of the number obtained by accumulating the planned purchase quantity of this time to the number obtained by accumulating the planned purchase quantity of the last time for the selected item. Specifically, when the change rate is set to U(m, t), the change rate U(m, t) is a value calculated by the formula shown in the following formula 4.
[0083] [Formula 4]
[0084]
[0085] In addition, the rate of change U(m, t) does not become a negative value, and 0≦U(m, t) always holds true for the rate of change U(m, t). Figure 7 In the graph shown, the rate of change U(m, t) is U(m, t)=(40+60+100+100+100 / 20+40+60+80+100}=400 / 300≈1.33.
[0086] Back to Figure 1 The sufficiency rate calculation unit 140 calculates the sufficiency rate of the items used in the assembly of this plan based on the follow-up rate calculated by the follow-up rate calculation unit 120 and the change rate calculated by the change rate calculation unit 130. In addition, the sufficiency rate becomes an indicator for determining whether the inventory quantity of an item on a specific day exceeds the quantity used in the assembly of that day. Specifically, first, the sufficiency rate calculation unit 140 refers to the assembly plan information stored in the plan information storage unit 117 and selects the assembly to be evaluated for the sufficiency rate. For example, the sufficiency rate calculation unit 140 selects Figure 5C The assembly shown is assembly number A01.
[0087] Back to Figure 1Next, the sufficiency rate calculation unit 140 refers to the product master information stored in the product master information storage unit 112 and the item master information stored in the item master information storage unit 113 to select the items used in the selected assembly. Figure 5C P01 shown as the assembly part number is the same as Figure 3B The product number P01 shown in FIG. 1 is consistent with that in FIG. 1 , so the sufficiency calculation unit 140 selects the product number P01 that matches that in FIG. Figure 3B IN01 shown as the item to be used corresponds to Figure 3C An item with I01 as the item code is shown.
[0088] Back to Figure 1 Next, the sufficiency calculation unit 140 refers to the item inventory information stored in the inventory information storage unit 114, the purchase plan information stored in the plan information storage unit 117, and the order surplus information stored in the order surplus information storage unit 115 to determine whether the inventory quantity of the item selected during assembly is insufficient. For example, the sufficiency calculation unit 140 refers to the item inventory information using the item code I01 as identification information to obtain Figure 4B TI01, TIA01, and TIB01 are shown as the inventory quantities. In addition, the sufficiency calculation unit 140 refers to the procurement plan information using the item code I01 as identification information. Figure 5B The Ys / Ms / Ds shown as the target day are Figure 5C If the purchase quantity N31 is obtained before the latest scheduled assembly date Yu / Mu / Du, the sufficiency calculation unit 140 uses the item code I01 as identification information and refers to the order surplus information. Figure 4C If the latest scheduled delivery date Yh / Mh / Dh is before the latest scheduled assembly date Yu / Mu / Du, the latest scheduled delivery quantity N11 is obtained, and other latest scheduled delivery quantities before the latest scheduled assembly date are also obtained. Then, the sufficiency calculation unit 140 determines whether the inventory quantity that can be assembled with the assembly quantity N41 can be secured on the latest scheduled assembly date Yu / Mu / Du based on these quantities.
[0089] Back to Figure 1 Next, if the inventory quantity of the item selected during assembly is not insufficient, the sufficiency rate calculation unit 140 calculates the sufficiency rate of the selected item as 100%, and stores the calculated sufficiency rate as the sufficiency rate of the item sufficiency rate information in the sufficiency rate information storage unit 118. On the other hand, if the inventory quantity of the item selected during assembly is insufficient, the sufficiency rate calculation unit 140 causes the change rate calculation unit 130 to calculate the change rate, and calculates the sufficiency rate by multiplying the calculated change rate and the follow-up rate calculated by the follow-up rate calculation unit 120, that is, accumulating them. For example, Figure 7 In the graph shown, regarding the change rate U(m, t) and the following rate T(m, t), since U(m, t)≈1.33 and T(m, t)=0.4 hold, the sufficiency ratio becomes U(m, t)×T(m, t)≈0.53.
[0090] Back to Figure 1 Next, the sufficiency calculation unit 140 calculates the sufficiency of all items used in the selected assembly, and stores the follow-up rate and sufficiency of the item with the smallest sufficiency as assembly sufficiency information in the sufficiency information storage unit 118. In addition, the sufficiency calculation unit 140 stores the sufficiency of the item with the smallest sufficiency as the assembly execution probability of the assembly plan information in the plan information storage unit 117. This is because even if one of the items used in the selected assembly is missing, the assembly cannot be performed, so the sufficiency of the item with the smallest sufficiency becomes the sufficiency of the entire items used in the assembly, and also becomes the assembly execution probability. Moreover, the sufficiency calculation unit 140 repeatedly performs the selection of assemblies, the selection of items, and the calculation of sufficiency until the sufficiency of each item is calculated for all assemblies that are the evaluation objects of sufficiency.
[0091] When the sufficiency rate calculated by the sufficiency rate calculation unit 140 does not exceed the predetermined threshold, the plan change unit 150 changes the current plan. Specifically, first, the plan change unit 150 refers to the assembly plan information stored in the plan information storage unit 117 and the input information stored in the input information storage unit 119, and selects assemblies whose assembly execution probability is below the threshold, starting from the assembly with a small assembly number, that is, the assembly with the earliest scheduled date. For example, if Figure 5C AS01 shown as the probability of assembly execution is Figure 6C If the value of VS01 as the threshold value shown in FIG. 1 is less than VS01, the plan change unit 150 selects the assembly with the assembly number A01. Figure 7 In the graph shown, when the sufficiency ratio is about 0.53, if 0.9 is input as the threshold value, the assembly execution probability becomes equal to or less than the threshold value.
[0092] Back to Figure 1Next, the plan change unit 150 determines whether the candidate day on which the assembly execution probability of the selected assembly exceeds the threshold is the target period of this plan. For example, the plan change unit 150 causes the sufficiency rate calculation unit 140 to calculate the assembly execution probability when the assembly is delayed day by day from the latest scheduled assembly date, that is, the sufficiency rate, and uses the day on which the calculated sufficiency rate exceeds the threshold as the candidate day to determine whether the candidate day is the target period of this plan. Next, if the candidate day is not the target period of this plan, the plan change unit 150 determines that the selected assembly will be performed after the next plan, and sets the non-illustrated out-of-target flag to ON for the selected assembly.
[0093] On the other hand, if the candidate day is the target period of this plan, the plan change unit 150 selects an assembly whose assembly execution probability exceeds the threshold even if the assembly exchange schedule is selected from the assembly whose assembly execution probability exceeds the threshold on the latest assembly scheduled day after the calculated candidate day, and exchanges the schedule among the selected assemblies. For example, the plan change unit 150 causes the sufficiency rate calculation unit 140 to calculate the sufficiency rate when the latest assembly scheduled day is advanced to the latest assembly scheduled day of the selected assembly whose assembly execution probability is below the threshold for the assembly whose latest assembly scheduled day becomes the candidate day. In addition, the plan change unit 150 calculates the sufficiency rate when advanced in the order of the latest assembly scheduled day from early to late, and determines whether the calculated sufficiency rate exceeds the threshold. Moreover, if the calculated sufficiency rate exceeds the threshold, the plan change unit 150 selects an assembly whose assembly execution probability exceeds the threshold even if the schedule is exchanged, and exchanges the schedule among the selected assemblies. In addition, if it is not determined that the assembly whose calculated sufficiency rate exceeds the threshold, the plan change unit 150 does not exchange the selected assembly with the subsequent assembly, but only changes the latest assembly scheduled day to the candidate day.
[0094] Furthermore, the plan change unit 150 repeatedly selects, replaces, or postpones all assemblies that are the subject of the current plan until the assembly execution probability exceeds the threshold, and changes the assembly plan information, and stores the changed assembly plan information as the assembly plan information of the new plan in the plan information storage unit 117. In addition, the plan change unit 150 generates new production plan information for the plan change date based on the changed assembly plan information, and stores the generated new production plan information in the plan information storage unit 117.
[0095] The delivery period calculation unit 160 calculates the product's delivery period by referring to the production plan information stored in the plan information storage unit 117 and calculating the product's available shipment date based on the production schedule quantity of each production schedule date. Specifically, first, the delivery period calculation unit 160 refers to the order information stored in the order information storage unit 111 and selects an order that answers the delivery period. For example, the delivery period calculation unit 160 selects Figure 3A The order acceptance number ON0001 shown in the order acceptance order determines that the quantity of the product with the order product number P01 is N01, and the quantity of the product with the order product number P02 is N02.
[0096] Back to Figure 1 Next, the delivery date calculation unit 160 selects the product to be the object of the selected order acceptance in the order of product numbers. For example, the delivery date calculation unit 160 selects Figure 3A The product number is P01. Next, the delivery period calculation unit 160 refers to the product inventory information of the inventory information storage unit 114 to determine whether the unsecured inventory quantity exceeds the accepted order quantity, thereby determining whether the inventory quantity is insufficient. For example, the delivery period calculation unit 160 refers to the product inventory information with P01 as the product number as identification information to determine whether the unsecured inventory quantity exceeds the accepted order quantity. Figure 4A Does TPB01, which is the unsecured inventory quantity, exceed N01, which is the quantity of the product that has been ordered?
[0097] Back to Figure 1 Next, if the inventory quantity is not insufficient, the delivery period calculation unit 160 calculates the available shipment date of the selected product as the current day. On the other hand, if the inventory quantity is insufficient, the delivery period calculation unit 160 determines the production scheduled quantity for each production scheduled day of the selected product by referring to the production plan information stored in the plan information storage unit 117, and calculates the day when the cumulative number of the production scheduled quantity exceeds the insufficient quantity, that is, the production completion scheduled day, thereby calculating the available shipment date. For example, the delivery period calculation unit 160 calculates the cumulative number by referring to the production plan information using P01 as the product number as identification information, and summing up the production scheduled quantity after the day after the current date day by day. In addition, when the calculated cumulative quantity exceeds the insufficient quantity, that is, (N01-TPB01), the delivery period calculation unit 160 calculates the available shipment date by adding the total number of days for the production scheduled quantity to the current date. If the cumulative production quantity does not exceed the shortage quantity even when accumulated until the last production scheduled date, the delivery date calculation unit 160 determines that the product cannot be shipped and sets the unshipment flag (not shown) to ON for the selected order.
[0098] Next, the delivery date calculation unit 160 temporarily stores the calculated available date for shipment, and repeats the selection of products and the calculation of available date for shipment for all products that are the subject of the order acceptance until the available date for shipment is calculated. Furthermore, the delivery date calculation unit 160 calculates the delivery date based on the latest date among the calculated available dates for shipment of all products, and stores the calculated delivery date as the delivery date answer date of the order acceptance information in the order acceptance information storage unit 111.
[0099] Figure 8 1 is a diagram showing an example of a display of a delivery time calculation result screen according to the present embodiment. The delivery time display unit 170 displays delivery time information indicating the delivery time calculated by the delivery time calculation unit 160. In the delivery time display unit 170, as an example of the delivery time information, Figure 8 The delivery period calculation result screen shown. The delivery period calculation result screen displays, for example, a text image such as "The calculated delivery period answer date is as follows" and text images indicating the names of items such as "Order number", "Customer name", "Product number", "Quantity", and "Delivery period answer date". In addition, the delivery period calculation result screen displays, for example, text images indicating the values of the above items such as "ON0001", "CL01", "P01, P02", "N01, N02", and "Ya / Ma / Da".
[0100] The input unit 180 receives input of, for example, an evaluation period and a threshold value from a manufacturing manager as input information. In addition, the input unit 180 receives input of, for example, product master information, item master information, and plan information from a manufacturing manager. In addition, the input unit 180 receives input of, for example, order acceptance information from a sales person in charge, inventory information from an inventory manager, delivery performance information from an ordering person in charge, and order surplus information.
[0101] Next, the operation of the delivery period calculation device 100 will be described. The delivery period calculation device 100 calculates the follow-up rate of each item in the batch processing performed at night, i.e., the night batch processing, and makes changes to the plan, while the input information storage unit 119 stores the input information such as the evaluation period and threshold value input by the user. For example, the delivery period calculation device 100 performs the follow-up capacity calculation processing and the plan change processing described below at 0:00 a.m. every day. In addition, the delivery period calculation device 100 calculates the delivery period when the user inputs the intention of answering the delivery period for the designated acceptance order. For example, the delivery period calculation device 100 performs the delivery period calculation processing described below when the sales person inputs the intention of answering the delivery period for the designated acceptance order to the customer.
[0102] Fig. 9 is a flowchart showing the flow of the following rate calculation process involved in this embodiment. Fig. 9 The flowchart shown in FIG. 1 illustrates the following rate calculation process performed by the following rate calculation unit 120. The following rate calculation process is a process for calculating the supplier's following rate when the quantity of the requested items to the supplier changes due to a change in the plan based on the supplier's delivery performance. The following rate calculation unit 120 starts the following capacity calculation process in the night batch processing performed every day.
[0103] When the following ability calculation process is started, first, the following rate calculation unit 120 obtains the value of the evaluation period, and selects an item to be evaluated for the following rate based on the value of the evaluation period (step S101). Figure 4B Items shown have item code I01.
[0104] Back to Fig. 9 After selecting an item, the follow-up rate calculation unit 120 obtains the current planned purchase quantity and the previous planned purchase quantity of the selected item, and calculates the planned change quantity by subtracting the previous planned purchase quantity from the current planned purchase quantity (step S102). Figure 5B The target date shown is the total purchase quantity within the previous or current evaluation period, and the value calculated using the formula shown in the above formula 1 is calculated.
[0105] Back to Fig. 9 After calculating the planned change quantity, the following rate calculation unit 120 obtains the supply quantity of the selected item from the supplier in this plan, and calculates the following change quantity by subtracting the accumulated purchase quantity in the previous evaluation period from the accumulated supply quantity of the purchase quantity in this plan (step S103). Figure 4D The delivery date shown is the total number of deliveries within the previous or current evaluation period, and the value calculated using the formula shown in the above formula 2 is calculated.
[0106] Back to Fig. 9 After calculating the number of follow-up changes, the follow-up rate calculation unit 120 calculates the follow-up rate by calculating the ratio of the number of follow-up changes to the number of planned changes, and stores the calculated follow-up rate in the sufficiency rate information storage unit 118 (step S104). For example, the follow-up rate calculation unit 120 calculates the follow-up rate T(m, t) calculated by the formula shown in the above formula 3, and stores the calculated value T(m, t) in the sufficiency rate information storage unit 118.
[0107] After calculating the following rate, the following rate calculation unit 120 determines whether the following rate of all items that are the evaluation targets of the following rate has been calculated based on the value of the evaluation period (step S105). If the following rate calculation unit 120 has not calculated the following rate of all items (step S105; "No"), the following rate calculation unit 120 repeats the processing of steps S101 to S105 until the following rate of all items is calculated. On the other hand, if the following rate of all items has been calculated (step S105; "Yes"), the following ability calculation processing ends.
[0108] Fig.10 This is a flowchart showing the process of plan change processing involved in this embodiment. Fig.10 The flowchart shown in FIG. 1 illustrates the plan change process performed by the sufficiency rate calculation unit 140 and the plan change unit 150. The plan change process is a process for changing the current plan if the sufficiency rate of each item calculated based on the follow-up rate calculated in the follow-up capacity calculation process is below a threshold value. The sufficiency rate calculation unit 140 starts the plan change process during the night batch process performed every day.
[0109] When the plan change process is started, first, the sufficiency calculation unit 140 selects an assembly to be evaluated for sufficiency (step S201), and selects an item used in the selected assembly (step S202). Figure 5C The assembly number shown is A01. At this time, the sufficiency calculation unit 140 calculates the number of the assembly product corresponding to the assembly, P01, and Figure 3B The product number is P01, so select Figure 3B IN01 shown as the item to be used corresponds to Figure 3C Items shown have item code I01.
[0110] Back to Fig.10 After selecting the item, for example, the sufficiency rate calculation unit 140 determines whether the inventory quantity of the item selected during assembly is insufficient (step S203). Figure 4B TI01, TIA01, TIB01, Figure 5B as well as Figure 4C The purchase quantity before the latest scheduled assembly date and the latest scheduled delivery quantity shown are used to determine whether the assembly quantity is the inventory quantity required for assembly of N41.
[0111] Back to Fig.10, when the inventory quantity of the selected item at the time of assembly is insufficient (step S203; "Yes"), the sufficiency calculation unit 140 causes the change rate calculation unit 130 to calculate the multiple of the quantity obtained by accumulating the planned purchase quantity of this time relative to the quantity obtained by accumulating the planned purchase quantity of the previous time, that is, the change rate (step S204). For example, the change rate calculation unit 130 calculates the change rate U(m, t) calculated by the formula shown in the above formula 4. After calculating the change rate, the sufficiency calculation unit 140 calculates the sufficiency by multiplying the calculated change rate and the follow-up rate calculated by the follow-up rate calculation unit 120 (step S205). For example, the sufficiency calculation unit 140 calculates the sufficiency calculated by U(m, t)×T(m, t). On the other hand, when the inventory quantity of the selected item at the time of assembly is not insufficient (step S203; "No"), the sufficiency calculation unit 140 calculates the sufficiency of the selected item as 100% (step S206).
[0112] After calculating the sufficiency rate, the sufficiency rate calculation unit 140 stores the calculated sufficiency rate in the sufficiency rate information storage unit 118 (step S207), and determines whether the sufficiency rates of all the items that are the target, that is, all the items used in the selected assembly, are calculated (step S208). If the sufficiency rate calculation unit 140 has not calculated the sufficiency rate of all the items that are the target (step S208; "No"), it repeats the processing of steps S202 to S208 until the sufficiency rate of all the items is calculated. On the other hand, if the sufficiency rate of all the items that are the target is calculated (step S208; "Yes"), the sufficiency rate calculation unit 140 stores the minimum value of the sufficiency rates of all the items that are the target as the sufficiency rate of the items used in the selected assembly in the sufficiency rate information storage unit 118 (step S209).
[0113] After storing the sufficiency ratio, the sufficiency ratio calculation unit 140 determines whether the sufficiency ratio of the items used in all assemblies that are the evaluation targets of the sufficiency ratio has been calculated (step S210). If the sufficiency ratio of the items used in all assemblies has not been calculated (step S210; "No"), the sufficiency ratio calculation unit 140 repeats the processing of steps S201 to S210 until the sufficiency ratio of the items used in all assemblies is calculated.
[0114] On the other hand, when the availability of items used in all assemblies is calculated (step S210; "Yes"), the plan change unit 150 selects assemblies whose availability, i.e., assembly execution probability, is below the threshold from among assemblies with smaller assembly numbers and earlier latest assembly schedules (step S211). Figure 5C AS01 shown as the probability of assembly execution is Figure 6CIf the value of the threshold value VS01 shown is equal to or less than VS01, the plan changing unit 150 selects the assembly with the assembly number A01.
[0115] Back to Fig.10 After selecting an assembly, the plan change unit 150 determines whether the candidate day on which the assembly execution probability of the selected assembly exceeds the threshold is the target period of this plan (step S212). For example, the plan change unit 150 determines whether the candidate day on which the sufficiency rate calculated by the sufficiency rate calculation unit 140 by delaying the latest assembly scheduled date by one day exceeds the threshold is the target period of this plan. When the candidate day is the target period of this plan (step S212; "yes"), the plan change unit 150 determines whether there is an assembly whose sufficiency rate exceeds the threshold even if the assembly selected from the assembly whose sufficiency rate exceeds the threshold on the latest assembly scheduled date after the candidate day is replaced (step S213). For example, the plan change unit 150 causes the sufficiency rate calculation unit 140 to calculate the sufficiency rate when the schedule is replaced to the candidate day in the order of the assembly number from small to large, and repeats the selection of the assembly and the calculation of the sufficiency rate until the calculated sufficiency rate exceeds the threshold.
[0116] If there is an assembly whose sufficiency rate exceeds the threshold even if the schedule is changed (step S213; "Yes"), the plan change unit 150 changes the schedule of the assembly with the selected assembly (step S214). On the other hand, if there is no assembly whose sufficiency rate exceeds the threshold even if the schedule is changed (step S213; "No"), the plan change unit 150 performs a schedule extension process of changing the latest assembly scheduled date to a candidate date without changing the selected assembly (step S215). In addition, if the candidate date is not a target period of the current plan (step S212; "No"), the plan change unit 150 determines that the selected assembly will be performed after the next plan, and performs a schedule extension process of setting the out-of-target flag to ON for the selected assembly (step S215).
[0117] After the schedule is replaced or postponed, the plan change unit 150 determines whether the sufficiency rate of items used in all assemblies that are the evaluation object exceeds the threshold value (step S216). If the sufficiency rate of items used in all assemblies does not exceed the threshold value (step S216; "No"), the plan change unit 150 repeats the processing of steps S211 to S216 until the sufficiency rate of items used in all assemblies exceeds the threshold value. On the other hand, if the sufficiency rate of items used in all assemblies exceeds the threshold value (step S216; "Yes"), the plan change unit 150 stores the new plan changed due to the replacement or postponement of the assembly in the plan information storage unit 117 (step S217), and ends the plan change processing.
[0118] Fig.11 This is a flowchart showing the flow of the delivery period calculation process involved in this embodiment. Fig.11 The flowchart shown in FIG. 1 illustrates a delivery period calculation process performed by the delivery period calculation unit 160. The delivery period calculation process is a process for calculating the delivery period of a product by calculating the available shipment date of the product based on the scheduled production quantity of each scheduled production date of the product determined from the new plan changed in the plan change process. The delivery period calculation unit 160 starts the delivery period calculation process when a delivery period for calculating a designated order is input.
[0119] When the delivery period calculation process starts, first, the delivery period calculation unit 160 selects a purchase order for which a delivery period is to be answered based on the input from the user (step S301), and selects the product to be the object of the selected purchase order in the order of product numbers (step S302). Figure 3A The order number for the order received is ON0001, and the product number for the product is P01.
[0120] Back to Fig.11 After selecting a product, the delivery period calculation unit 160 determines whether the inventory quantity of the selected product is insufficient (step S303). Figure 4A Does the displayed unsecured inventory quantity TPB01 exceed the quantity N01 of the product that has been ordered? Fig.11 , when the inventory quantity is insufficient (step S303; "yes"), the delivery period calculation unit 160 determines the production scheduled quantity for each production scheduled day of the selected product, calculates the day when the cumulative number of the production scheduled quantity exceeds the insufficient number, that is, the shipment date (step S304), and determines whether the shipment date cannot be calculated (step S305). For example, the delivery period calculation unit 160 totals the production scheduled quantity after the next day. When the cumulative number exceeds the insufficient number, that is, (N01-TPB01), the shipment date is calculated by adding the total number of days for the production scheduled quantity to the current date. In addition, if the number accumulated to the production scheduled quantity on the last production scheduled day does not exceed the insufficient number, the delivery period calculation unit 160 determines that the shipment date cannot be calculated.
[0121] When the delivery period calculation unit 160 cannot calculate the available date for shipment (step S305; "Yes"), the available date for shipment is set in the next plan and thereafter, so a decision is made in the current plan that the product cannot be shipped, and the unavailable date flag is set to ON, thereby terminating the delivery period calculation process. On the other hand, when the delivery period calculation unit 160 can calculate the available date for shipment (step S305; "No"), the calculated available date for shipment is temporarily stored (step S307). In addition, when the inventory quantity is not insufficient (step S303; "No"), the delivery period calculation unit 160 calculates the available date for shipment of the selected product as the current day (step S306), and temporarily stores the calculated available date for shipment (step S307).
[0122] After temporary storage, the delivery period calculation unit 160 determines whether the available shipping date has been calculated for all products that are the subject of the order (step S308). If the available shipping date has not been calculated for all products (step S308; "No"), the delivery period calculation unit 160 repeats the processing of steps S302 to S308 until the available shipping date is calculated for all products. On the other hand, if the available shipping date has been calculated for all products (step S308; "Yes"), the delivery period calculation unit 160 calculates the delivery period based on the latest date among the calculated available shipping dates for all products (step S309). After calculating the delivery period, the delivery period calculation unit 160 displays the delivery period display unit 170 based on the calculated delivery period. Figure 8 The delivery period calculation result screen shown is displayed, and the calculated delivery period is stored in the order receiving information storage unit 111 (step S310), and the delivery period calculation processing is terminated.
[0123] As described above, according to the delivery date calculation device 100 of the present embodiment, the follow-up rate calculation unit 120 calculates the follow-up rate as an example of the supplier's follow-up ability when the number of items required for manufacturing the ordered product changes due to a change in the plan based on the supplier's delivery performance. In addition, the delivery date calculation unit 160 calculates the delivery date of the ordered product from the new plan changed according to the follow-up rate calculated by the follow-up rate calculation unit 120. In addition, the delivery date display unit 170 displays the calculated delivery date by displaying the delivery date calculation result screen.
[0124] Thus, the delivery date calculation device 100 according to the present embodiment can calculate the supplier's follow-up capability based on the supplier's actual delivery performance, and calculate the delivery date of the product using the item based on the calculated supplier's follow-up capability. As a result, the delivery date calculation device 100 according to the present embodiment can improve the accuracy of the delivery date answered to the customer, compared with a delivery date calculation device that does not calculate the supplier's follow-up capability based on the supplier's actual delivery performance or calculates the delivery date of the product using the item based on the calculated supplier's follow-up capability. In addition, thus, the delivery date calculation device 100 according to the present embodiment can improve the accuracy when the purchase quantity of the item is newly set based on the calculated follow-up capability. As a result, the delivery date calculation device 100 according to the present embodiment can reduce the time and work load required for setting or adjusting the purchase quantity and inventory quantity of the item, or make the order to the supplier appropriate to reduce the excess inventory quantity and purchase quantity.
[0125] Here, for manufacturers of mass-produced products, providing stable supply of products to customers is one of the most important responsibilities. In order to comply with the delivery date agreed with customers, it is extremely important to improve the accuracy of answering customers' delivery dates. In the previous delivery date answering method, there is a method of guaranteeing the inventory of products after accepting the ordered products, and referring to the production plan associated with the product to answer the available date for shipment for the shortage. However, in such a method, the impact of delays in purchasing parts from suppliers is not taken into account, so there is a problem that the assembly schedule is delayed due to parts shortage, resulting in a delay in delivery to customers.
[0126] In particular, according to the product model, there are models in which there are many types / specifications of products, parts cannot be standardized and the types of parts increase, and the procurement and ordering period of parts is long. With respect to such a product model, if the inventory quantity of parts determined to be safe and required is statistically calculated, there is a tendency that the inventory quantity will increase no matter what. On the other hand, manufacturers recently hope to reduce inventory, and there are many cases where they strive to suppress the inventory quantity of parts to the necessary minimum. With respect to such manufacturers, the delivery date is adjusted in detail by responding to the supplier who supplies parts in accordance with the latest procurement plan with the desired delivery date. Therefore, if the adjustment fails, the inventory will be gone, which will directly lead to a shortage of parts. Therefore, it is extremely important to formulate plans such as production plans, procurement plans, assembly plans, etc. that take into account the delivery date and delivery quantity of parts from suppliers and respond to customers about the delivery date in order to improve the delivery date compliance rate.
[0127] The delivery date calculation device was developed in view of such a situation. It is a device for improving the accuracy of the delivery date given to the customer based on the purchase plan of the goods, the production plan of the product, etc., and reducing the delay of the delivery date to the customer. However, in the previous delivery date calculation device, when an order is accepted from a customer, the inventory quantity of the product on the manufacturer side, the scheduled date of production completion, etc. are confirmed, but there is a problem that the inventory quantity and the scheduled delivery date of the parts are not taken into account. In addition, in the procurement of parts, due to the relationship between the purchase order period, there are cases where the purchase quantity in the new procurement plan is increased compared to the procurement plan at the time of ordering, and there are cases where the delivery date is advanced compared to the time of ordering when negotiating with the supplier. However, if the supplier cannot follow the changes in the procurement plan, it is inevitable that there will be a shortage of parts, and the production plan will not be achieved.
[0128] In contrast, the delivery date calculation device 100 according to the present embodiment can calculate a follow-up rate, which is the supplier's ability to follow up when a procurement plan is changed, based on the supplier's delivery performance, and calculate the delivery date of the ordered product based on the calculated follow-up rate.
[0129] Therefore, the delivery date calculation device 100 according to the present embodiment can calculate the delivery date taking into account the inventory quantity of the parts, the scheduled delivery date, etc., based on the follow-up rate of the supplier's changes to the procurement plan, and the calculated delivery date is closer to the actual situation than the delivery date calculated by the conventional delivery date calculation device. As a result, the delivery date calculation device 100 according to the present embodiment can improve the accuracy of the delivery date answered to the customer and improve the delivery date compliance rate.
[0130] In addition, in this embodiment, the delivery period calculation device 100 limits the main reason for the delay in delivery of the items used in the product to the change in the purchase plan of the items, calculates the supplier's follow-up ability based on the change in the purchase quantity of the items, and calculates the delivery period, but the present invention is not limited to this. For example, the delivery period calculation device 100 may also consider not only the change in the purchase quantity of the items, but also the change in the working conditions of the equipment used to assemble the product, the working conditions of the personnel, etc. to calculate the supplier's follow-up ability and calculate the delivery period. That is, the delivery period calculation device 100 may also consider the change in plans other than the purchase plan to calculate the delivery period.
[0131] In addition, according to the delivery period calculation device 100 involved in this embodiment, the change rate calculation unit 130 calculates the change rate of the purchase quantity of the item based on the number obtained by accumulating the purchase quantity of the item in the current plan and the number obtained by accumulating the purchase quantity of the item in the previous plan. In addition, the sufficiency calculation unit 140 multiplies the follow-up rate calculated by the follow-up rate calculation unit 120 and the change rate calculated by the change rate calculation unit 130 to calculate the sufficiency rate of each item in the current plan. Moreover, the delivery period calculation unit 160 calculates the delivery period of the ordered product from the new plan changed according to the sufficiency rate calculated by the sufficiency calculation unit.
[0132] Thus, the delivery date calculation device 100 according to the present embodiment can calculate the availability rate of the items in the current plan based on the follow-up rate of the supplier's change to the plan and the rate of change of the quantity of the purchased items, and calculate the delivery date based on the calculated availability rate. As a result, the delivery date calculation device 100 according to the present embodiment improves the accuracy of the delivery date given to the customer compared to a delivery date calculation device that does not calculate the availability rate of the item based on the calculated follow-up rate and rate of change or calculates the delivery date of the product using the item based on the calculated availability rate.
[0133] In addition, as described in this embodiment, in order to improve the accuracy of the calculated delivery period, the delivery period calculation device 100 preferably calculates the abundance rate of the item and calculates the delivery period based on the calculated abundance rate, but is not limited to this. For example, the delivery period calculation device 100 may not calculate the abundance rate of the item, and may not calculate the delivery period based on the calculated abundance rate.
[0134] Furthermore, according to the delivery period calculation device 100 according to the present embodiment, the plan changing unit 150 changes the plan when the sufficiency rate calculated by the sufficiency rate calculation unit 140 becomes equal to or less than a predetermined threshold value.
[0135] Thus, the delivery date calculation device 100 according to the present embodiment can change to a new plan according to the abundance rate of the item, and can calculate the delivery date of the product using the item according to the changed new plan. As a result, the delivery date calculation device 100 according to the present embodiment can improve the accuracy of the delivery date given to the customer compared to a delivery date calculation device that does not calculate the delivery date of the product ordered according to the new plan changed according to the abundance rate of the item.
[0136] In addition, as described in the present embodiment, the delivery period calculation device 100 preferably changes to a new plan based on the abundance rate of the item in order to improve the accuracy of the calculated delivery period, but is not limited to this, and may not change to a new plan based on the abundance rate of the item. For example, the delivery period calculation device 100 may also change to a new plan based on the follow-up rate of the item. Furthermore, the delivery period calculation device 100 preferably changes to a new plan before calculating the delivery period, but is not limited to this, and may not change to a new plan before calculating the delivery period as long as the delivery period is calculated based on the follow-up rate of the supplier.
[0137] Furthermore, according to the delivery period calculation device 100 of the present embodiment, the delivery period calculation unit 160 calculates the product delivery period by calculating the available shipping date based on the scheduled production quantity for each scheduled production date of the ordered product determined from the new plan after the change.
[0138] Therefore, the delivery date calculation device 100 involved in this embodiment can improve the accuracy of the delivery date answered to the customer compared with the delivery date calculation device that does not calculate the available shipping date based on the production scheduled quantity for each production scheduled date of the accepted product determined from the new plan after the change.
[0139] In addition, in this embodiment, the delivery date calculation device 100 calculates the ready-to-ship date based on the scheduled production quantity of each of the above-mentioned scheduled production dates in order to improve the accuracy of the calculated delivery date, but it is also possible not to calculate the ready-to-ship date based on the scheduled production quantity of each of the above-mentioned scheduled production dates. For example, the delivery date calculation device 100 may also calculate the ready-to-ship date based on the change in the inventory quantity of the product that has been ordered after the day after the current date.
[0140] In addition, according to the delivery period calculation device 100 involved in the present embodiment, the following rate calculation unit 120 calculates the planned change quantity by subtracting the number obtained by integrating the number of planned item purchases last time from the number obtained by integrating the number of items purchased this time. In addition, the following rate calculation unit 120 calculates the following change quantity by subtracting the number obtained by integrating the number of items purchased last time from the number obtained by integrating the number of supplies supplied by suppliers following the planned item purchases this time. Furthermore, the following rate calculation unit 120 calculates the following rate by calculating the ratio of the following change quantity to the planned change quantity.
[0141] Therefore, the delivery date calculation device 100 according to this embodiment can calculate the following rate more accurately than a delivery date calculation device that does not calculate the following rate by calculating the ratio of the following change quantity to the planned change quantity, and can improve the accuracy of the delivery date given to the customer.
[0142] In addition, in this embodiment, the delivery period calculation device 100 calculates the ratio of the follow-up change quantity to the planned change quantity as the follow-up rate, but the calculation method of the follow-up rate is not limited to this. For example, the delivery period calculation device 100 may also store the ratio of the follow-up change quantity to the planned change quantity calculated in the follow-up rate calculation process, and calculate the average value of all stored ratios as the follow-up rate.
[0143] Furthermore, according to the delivery period calculation device 100 of the present embodiment, the variation rate calculation unit 130 calculates the variation rate by calculating the ratio of the current planned item purchase quantity accumulated to the previous planned item purchase quantity accumulated.
[0144] Therefore, the delivery date calculation device 100 according to the present embodiment can calculate the variation rate with higher accuracy than a delivery date calculation device that does not calculate the variation rate by calculating the above-mentioned magnification, and can improve the accuracy of the delivery date given to the customer.
[0145] In addition, in this embodiment, the delivery period calculation device 100 calculates the ratio of the number obtained by accumulating the number of planned items purchased this time to the number obtained by accumulating the number of planned items purchased last time as the change rate, but the calculation method of the change rate is not limited to this. For example, the delivery period calculation device 100 may also calculate the ratio of the number of planned items purchased this time to the number of planned items purchased last time during the evaluation period day by day, and calculate the average value of the calculated ratios as the change rate.
[0146] (Change Example)
[0147] In addition, in this embodiment, the delivery period calculation device 100 is described as calculating the delivery period of the product that the manufacturer receives an order from the customer, but the structure of the delivery period calculation device 100 performing the ordering of items, the change of the purchase quantity, etc. is not described. However, there may be a device or system that includes not only the above-mentioned functions of the delivery period calculation device 100, but also the functions of performing the ordering of items, the change of the purchase quantity, etc. For example, the functions of the delivery period calculation device 100 may be embedded in the conventionally known MRP (Material Requirements Planning) system.
[0148] Here, as an example of the above-mentioned device and system, consider an inventory management system that manages information indicating a reference quantity of inventory of an item, information indicating an actual quantity of inventory of an item, and information indicating a required planned quantity of an item, and automatically orders to replenish the item when the inventory of the item is insufficient. In this case, the inventory management system may also automatically calculate the quantity of replenishment based on the difference quantity when the required planned quantity of the item is updated and the difference quantity obtained by subtracting the updated quantity from the actual quantity of inventory of the item is less than the reference quantity, and automatically order from the trading partner.
[0149] In addition, for example, when the non-follow-up rate, which is the ratio of the supplier's supply failing to follow the procurement plan, is set to S(m, t), the reference quantity of the inventory of the item can be calculated as the value obtained by multiplying the non-follow-up rate S(m, t) by the initial procurement quantity O(m, t). Specifically, the reference value of the inventory of the item is a value calculated by the formula shown in the following formula 5.
[0150] [Formula 5]
[0151]
[0152] Here, the non-following rate S(m, t) can also be interpreted as the ratio of the purchase quantity to be replenished by maintaining the inventory of the factory's articles according to the formula shown in Formula 5. In addition, S(m, t) = 1-T(m, t) holds, so the non-following rate S(m, t) can be calculated based on the following rate T(m, t) calculated by the following rate calculation unit 120. For example, if the following rate T(m, t) is 0.4, S(m, t) becomes 0.6 (1-0.4 = 0.6).
[0153] As a result, the inventory management system may include an inventory reference quantity calculation unit that calculates the reference quantity of the inventory of the item based on the non-follow-up rate based on the follow-up rate calculated by the follow-up rate calculation unit 120 and the originally planned purchase quantity of the item. In addition, the inventory management system may include an inventory replenishment quantity calculation unit that calculates the quantity of the inventory of the item to be replenished based on the difference quantity when the difference quantity obtained by subtracting the purchase quantity of the item from the actual quantity of the inventory of the item is less than the reference quantity of the inventory of the item calculated by the inventory reference quantity calculation unit. Furthermore, the inventory management system may include an order information transmission unit that transmits order information as information indicating an intention to order the number of items calculated by the inventory replenishment quantity calculation unit to the supplier.
[0154] Thus, the inventory management system can suppress a decrease in the sufficient rate of items by supplementing the shortage of the tracking capacity in the inventory of items based on the calculated reference quantity of the inventory of items, and can expect to eliminate delays in delivery.
[0155] Furthermore, even when estimating the base quantity of the inventory of the item statistically, as in the case of estimating the supplier's follow-up capability, the reliability of the estimation result increases as the number of samples increases, and ultimately the accuracy of the delivery date of the answer can be expected to be improved. Therefore, when estimating the base quantity of the inventory of the item, the base quantity of the inventory of the item in the new plan can be estimated based on the base quantity of the inventory of the item in each evaluation period calculated by tracing back to multiple evaluation periods in the past. For example, the base quantity of each evaluation period of t=0, -T, -2T, ..., -nT can be calculated according to the formula shown in Formula 5, and the average of the calculated (n+1) base quantities can be calculated as the base quantity of the inventory of the item in the new plan. That is, the inventory base quantity calculation unit can also calculate the first base quantity calculated based on the sample of the first period corresponding to t=0, the second base quantity calculated based on the sample of the second period corresponding to t=-T, ..., and the average of the (n+1)th base quantity calculated based on the sample of the (n+1)th period corresponding to t=-nT as the base quantity of the inventory of the new item.
[0156] In addition, in the present embodiment, the delivery period calculation device 100 calculates the following rate, change rate, and sufficient rate of each item, but is not limited to this. For example, the following rate, change rate, and sufficient rate of each item group may also be calculated. In this case, for example, the delivery period calculation device 100 may also calculate the following rate, change rate, and sufficient rate by grouping together the components that change by 1000 units and the change by 1 unit that is difficult to identify, for products with an electronic substrate component with an order batch number of 1000 units and a large component with an order batch number of 1 unit. Thus, the delivery period calculation device 100 can easily evaluate the probability of assembly execution with good accuracy, for example, even when the number of each component changes but the total number of components as a whole does not change.
[0157] In addition, in the present embodiment, the delivery date calculation device 100 implements the functions of the storage unit 110, the follow-up rate calculation unit 120, the change rate calculation unit 130, the sufficiency rate calculation unit 140, the plan change unit 150, the delivery date calculation unit 160, the delivery date display unit 170, and the input unit 180 using a single computer, but the present invention is not limited thereto. For example, the delivery date calculation device 100 may implement the function of the storage unit 110 using a database server different from the delivery date calculation device 100. In addition, for example, the delivery date calculation device 100 may implement the function of the plan change unit 150 using a computer different from the delivery date calculation device 100. In addition, for example, the delivery date calculation device 100 may implement the function of the input unit 180 using a portable terminal of each user different from the delivery date calculation device 100. That is, in the present disclosure, only the configuration in which the delivery date calculation device 100 has the above functions is disclosed, but the present invention is not limited thereto, and the configuration of the delivery date calculation system in which the above functions are respectively provided in a plurality of computers may also be provided. In this case, the delivery date calculation system requires the sending and receiving units 56 of a plurality of computers to send and receive information via a network.
[0158] The present disclosure can realize various embodiments and variations without departing from the broad spirit and scope of the present disclosure. In addition, the above-mentioned embodiments are used to illustrate the present disclosure and do not limit the scope of the present disclosure. That is, the scope of the present disclosure is not shown by the embodiments, but by the claims. Moreover, various variations implemented within the scope of the claims and the equivalent disclosed meanings are considered to be within the scope of the present disclosure.
[0159] This application is based on Japanese Patent Application No. 2020-019460 filed on February 7, 2020. The entire specification, claims, and drawings of Japanese Patent Application No. 2020-019460 are incorporated herein by reference.
Claims
1. An inventory management system having: An input unit receives order information including the quantity of the ordered product and inventory information including the inventory quantity of the product; A follow-up rate calculation unit that calculates a follow-up rate indicating a ratio of the quantity supplied by the supplier to the changed quantity based on the actual delivery performance of the supplier when the quantity of the item used in the product requested from the supplier changes due to a change in plan; a change rate calculation unit, which calculates a change rate of the quantity of the purchased item based on the quantity of the purchased item in the current plan and the quantity of the purchased item in the plan before the current plan; a sufficient rate calculation unit that calculates the sufficient rate of the item in the current plan based on the following rate calculated by the following rate calculation unit and the change rate calculated by the change rate calculation unit; a plan changing unit that changes the current plan when the sufficiency rate calculated by the sufficiency rate calculating unit does not exceed a predetermined threshold value; a delivery period calculation unit, in response to an input of an intention to answer a delivery period for a designated order acceptance, selecting an order acceptance for which a delivery period is to be answered, selecting a product to be the subject of the selected order acceptance, determining whether the inventory quantity of the selected product exceeds the quantity of the order acceptance product, thereby determining whether the inventory quantity of the product is insufficient, and if the inventory quantity of the product is insufficient, calculating a delivery period for a product using the product by calculating a production schedule for each production schedule of the product determined from the plan; a delivery period display unit that displays delivery period information indicating the delivery period calculated by the delivery period calculation unit; a stock reference quantity calculation unit that calculates a stock reference quantity of the article based on a non-follow-up rate based on the follow-up rate calculated by the follow-up rate calculation unit and an initially planned purchase quantity of the article; a stock replenishment quantity calculation unit for calculating the quantity of the stock to be replenished of the item based on the difference quantity when a difference quantity obtained by subtracting the purchase quantity of the item from the actual stock quantity of the item is less than the reference quantity of the stock of the item calculated by the reference stock quantity calculation unit; as well as The order information transmitting unit transmits order information as information indicating an intention to order the articles of the quantity calculated by the stock replenishment quantity calculating unit from a supplier.
2. The inventory management system according to claim 1, wherein: The follow-up rate calculation unit calculates the planned change quantity and the follow-up change quantity, and calculates the follow-up rate by calculating the ratio of the follow-up change quantity to the planned change quantity, wherein the planned change quantity is the quantity obtained by subtracting the quantity of the items purchased in the previous plan from the quantity of the items purchased in the current plan, and the follow-up change quantity is the quantity obtained by subtracting the quantity of the items purchased in the previous plan from the quantity supplied by the supplier in a follow-up manner.
3. The inventory management system according to claim 1, wherein: The change rate calculation unit calculates the change rate by calculating a ratio of the quantity of the items purchased in the current plan to the quantity of the items purchased in the previous plan.
4. The inventory management system according to claim 1, wherein: The following rate calculation unit calculates a new following rate based on a first following rate that is the following rate calculated in a first period and a second following rate that is the following rate calculated in a second period, wherein the second period is a period before the first period.
5. The inventory management system according to claim 4, wherein: The following rate calculation unit is capable of calculating the new following rate based on the first following rate, the second following rate and the following rate calculated in a third period, i.e., an average of the third following rate, wherein the third period is a period before the second period, and on the other hand, when the average of the first following rate and the second following rate and the average of the second following rate and the third following rate are in a predetermined relationship, the new following rate is calculated based on the average of the first following rate and the second following rate.
6. An inventory management method comprising: The step of receiving, by a computer, order information including the quantity of the product to be ordered and inventory information including the inventory quantity of the product; A follow-up rate calculation step, in which, when the quantity of items used in the product required from the supplier changes due to a change in plan, the computer calculates the follow-up rate representing the ratio of the quantity supplied by the supplier to the changed quantity based on the actual delivery performance of the supplier; a change rate calculation step, wherein the computer calculates the change rate of the quantity of the purchased item based on the quantity of the purchased item in the current plan and the quantity of the purchased item in the plan before the current plan; a sufficiency rate calculation step, wherein the computer calculates the sufficiency rate of the item in the current plan based on the following rate calculated by the following rate calculation step and the change rate calculated by the change rate calculation step; a plan changing step, wherein the computer changes the current plan when the sufficiency rate calculated by the sufficiency rate calculating step does not exceed a predetermined threshold value; a delivery period calculation step, wherein the computer selects an order acceptance order for which a delivery period is to be answered in response to an input of an intention to answer a delivery period for a designated order acceptance order, selects a product to be the subject of the selected order acceptance order, determines whether the inventory quantity of the selected product exceeds the quantity of the order acceptance product, thereby determining whether the inventory quantity of the product is insufficient, and if the inventory quantity of the product is insufficient, calculates a delivery date for the product based on the scheduled production quantity for each scheduled production day of the product determined from the plan, thereby calculating a delivery period for a product using the item; a step of displaying, on the computer, delivery period information indicating the delivery period calculated in the delivery period calculation step; a stock reference quantity calculation step, wherein the computer calculates a stock reference quantity of the item based on a non-follow-up rate based on the follow-up rate calculated in the follow-up rate calculation step and an initially planned purchase quantity of the item; a stock replenishment quantity calculation step, wherein the computer calculates the quantity of the stock to be replenished for the item based on the difference quantity when the difference quantity obtained by subtracting the purchase quantity of the item from the actual stock quantity of the item is less than the stock reference quantity of the item calculated by the stock reference quantity calculation step; as well as An order information sending step in which the computer sends order information as information indicating an intention to order the goods of the quantity calculated in the stock replenishment quantity calculating step from a supplier.
7. A computer-readable recording medium having a program recorded thereon, the program causing a computer to function as follows: An input unit receives order information including the quantity of the ordered product and inventory information including the inventory quantity of the product; A follow-up rate calculation unit that calculates a follow-up rate indicating a ratio of the quantity supplied by the supplier to the changed quantity based on the actual delivery performance of the supplier when the quantity of the item used in the product requested from the supplier changes due to a change in plan; a change rate calculation unit, which calculates a change rate of the quantity of the purchased item based on the quantity of the purchased item in the current plan and the quantity of the purchased item in the plan before the current plan; a sufficient rate calculation unit that calculates the sufficient rate of the item in the current plan based on the following rate calculated by the following rate calculation unit and the change rate calculated by the change rate calculation unit; a plan changing unit that changes the current plan when the sufficiency rate calculated by the sufficiency rate calculating unit does not exceed a predetermined threshold value; a delivery period calculation unit, in response to an input of an intention to answer a delivery period for a designated order acceptance, selecting an order acceptance for which a delivery period is to be answered, selecting a product to be the subject of the selected order acceptance, determining whether the inventory quantity of the selected product exceeds the quantity of the order acceptance product, thereby determining whether the inventory quantity of the product is insufficient, and if the inventory quantity of the product is insufficient, calculating a delivery period for a product using the product by calculating a production schedule for each production schedule of the product determined from the plan; a delivery period display unit that displays delivery period information indicating the delivery period calculated by the delivery period calculation unit; a stock reference quantity calculation unit that calculates a stock reference quantity of the article based on a non-follow-up rate based on the follow-up rate calculated by the follow-up rate calculation unit and an initially planned purchase quantity of the article; a stock replenishment quantity calculation unit for calculating the quantity of the stock to be replenished of the item based on the difference quantity when a difference quantity obtained by subtracting the purchase quantity of the item from the actual stock quantity of the item is less than the reference quantity of the stock of the item calculated by the reference stock quantity calculation unit; as well as The order information transmitting unit transmits order information as information indicating an intention to order the articles of the quantity calculated by the stock replenishment quantity calculating unit from a supplier.
Citation Information
Patent Citations
Delivery date management method and system
JP2002073936A
Snow accumulation preventing device of railway vehicle
JP2020019460A
Production planning apparatus and production planning method
CN106022552A
Back order management system
CN1578936A