JP4759544B2 - Inventory planning system - Google Patents

Description

The present invention relates to the planning and management of inventory for goods (distributed goods). In particular, it relates to an inventory planning system in so-called supply chain management.

  In general, the manufacturing industry can be broadly divided into two types: a build-to-order type and a prospective production type. In the case of build-to-order production, production is performed after receiving an order, so there is no need to have a stock of finished products, whereas in the case of prospective production, a certain amount of final is anticipated by forecasting in advance. Produce products and keep them in stock. The determination of these two production forms depends on the relationship between the delivery lead time requested by the customer and the production lead time. In other words, if the production lead time is in time for delivery even if production is performed after receiving an order, the production form is a build-to-order production type, and if production is performed after an order is received, it is often a prospective production type. .

  In addition, when order-made production is performed based on the confirmed information that the delivery quantity for a certain period is fixed, that is, the order quantity and the delivery date are confirmed, the delivery date indicated by the confirmed information is shown by the delivery destination. Because it is close to the point in time, the delivery date cannot be met, but undelivered unannounced information for a certain period before the confirmed information is presented from the delivery destination. There are business types that are positioned between the production-to-order type and the prospective production type, so that if a production plan is made and production is performed based on the production plan, it can be made in time for delivery.

  For example, in parts manufacturers, unordered orders that are set roughly based on a relatively long-term planned production plan in a business category that manufactures products by assembling a large number of parts called set manufacturers, and relatively short-term In many cases, a production plan is drawn up based on a two-stage order, which is a confirmed order that is determined based on a production plan determined in between.

  However, since the order quantity of the introductory information is unconfirmed compared to the confirmed information, the accuracy of the information regarding the quantity is low. In other words, there are many cases where there is actually a difference between the unordered order quantity and the confirmed order quantity, and if the parts manufacturer only produces based on the unordered order quantity, for example, if the confirmed order quantity increases rapidly, There is a high possibility of missing items. In addition, since this directly leads to a decline in the credit of the company, it is difficult for the person in charge to formulate an inventory plan and a production plan based only on the amount of orders received.

  On the other hand, the positioning of unconfirmed information as unlisted orders for parts manufacturers is less accurate in terms of the quantity than confirmed information as described above, but only for the company's forecast without considering the unordered orders. Adopting an inventory plan or production plan based on this causes a production amount that is less than the order quantity received, that is, there is a risk of a shortage, so the person in charge needs to consider the announcement.

  In other words, parts manufacturers are in a situation where missing parts are not allowed to be delivered to set manufacturers, so they are forced to take into account the amount of unlisted orders received from set manufacturers and their own prospects, making judgment difficult. Is accompanied.

  Here, in parts manufacturers that show unreserved orders, there is no theoretically established method for determining inventory and production volume considering both unreserved orders and expected demand. Although it depends on experience and intuition, such inventory planning and production planning have not only problems in reliability, but also increase the workload of the person in charge.

  In addition, inventory planning that relies on experience and intuition also causes problems such as overstocking due to anxiety about missing items. This excess inventory contributes to increased costs due to the risk of obsolescence due to the speed of new product cycles in recent years.

  Furthermore, there is a problem that a shortage is caused in delivery to business stores other than the set maker, for example, delivery to stores that sell parts to general consumers, giving priority to delivery without missing items to the set maker. In other words, this will cause a decline in the brand image and loss of sales opportunities for general consumers.

  Here, as a measure for the above problem, there is a technique described in Patent Document 1. In Patent Document 1, a production plan is first made by using the indicated order quantity and the estimated demand quantity as judgment materials, and the future inventory predicted based on the production plan is made visible to the production planner, so that the inventory does not become excessive. In this way, a technology for making it possible to review the production plan and further optimizing the inventory by using the production plan has been proposed.

  As a conventional general inventory planning method, there is an order point method. In the conventional ordering point method, the safety stock quantity is memorized from the variation in the shipment results, and the ordering point and the replenishment point that are the inventory plan reference values are memorized based on the safety stock quantity and the future demand forecast quantity. It is a technology that aims to manage.

  Here, regarding the storage of the safety stock amount, there is a technique that calculates from the variation of the difference between the expected demand of the company and the actual demand, not the variation of the shipment.

  For example, Patent Document 1 aims to provide an order management system capable of accurately delivering products and shipping and maintaining a proper inventory. In order to achieve this object, in Patent Document 1, various information such as orders 11, production requests 12, production responses 13, production results 14 and inventory results 15 stored in the storage unit 42 of the computer 3a of the control center 3 are included. Are set with ID codes associated with order information such as users, sales representatives, and product names. The output of these various types of information is controlled by the input / output control unit 43. Based on the receipt of the ID data of the order information in the input / output control unit 2e, the control center 3 identifies the information in which the ID code is set from various pieces of information stored in the storage unit 42, and stores the specific information. Transfer to the sales department 2 computer 2a.

JP 2001-350969 A

  However, the technique described in Patent Document 1 is intended for inventory planning that depends on production planning. In other words, because the stock quantity fluctuates as a result of the production volume, if there is a difference between the order volume received and the final order volume, the production plan cannot be reviewed (especially a sudden review), so the order will not be accepted. There is a high possibility of being out of stock and overstocking.

  In addition, when planning a production plan based on the estimated demand and unordered orders, it is up to the planner to determine whether the inventory is appropriate. This can lead to misjudgment in production planning, resulting in a shortage and excess inventory.

  In addition, the conventional order point method is often used for inventory planning in the prospective production type. In this case, the ordering point method predicts demand based on past results, but it is difficult to predict the most recent rapid increase or decrease in demand, so there is a possibility of missing items or excess inventory. .

  Furthermore, in the conventional ordering point method, when the safety stock quantity is calculated, the variation in the shipping record is used. For example, when the variation in the shipping record is large, the safety inventory quantity is likely to increase.

  In addition, even when the difference between the company's expected demand and actual shipments is used when calculating the safety inventory, the company's expected demand has low accuracy of information and sudden demand growth cannot be predicted. Therefore, there is a high possibility that the variation becomes large. Therefore, in this case as well, there is a high possibility that the safety stock quantity will increase as in the case of using the variation in the shipment results.

  Incidentally, in the business conditions in which the inscription is presented and the shortage is not permitted, the operation by the order point method, which uses only the estimated demand amount, is unsuitable for making an inventory plan, and the order point method has not been used.

  The present invention has been made in view of the above-mentioned problems, and it is necessary to carry out an inventory plan based on the indication presented from the delivery destination. Further, although there is a difference between the indicated order quantity and the confirmed order quantity. Inventory that can control the inventory of its own warehouse by reducing the judgment of the person in charge and reducing in-house predictions, determining the timing and quantity of orders to the factory warehouse, in a business situation where shortages are not allowed The purpose is to provide technology related to inventory planning such as a planning system and a method using the planning system.

  In the present invention, in order to solve the above-described problem, the order point is calculated using the accuracy information indicating the degree of confirmation of the order. More specifically, in the inventory planning system for planning the inventory of goods using the supplier's unofficial information, for each order received from the supplier, the confirmation information indicating the order quantity and the degree of confirmation of the order. Stock storage lead time that is a required number of days from when the product is ordered to when it is replenished by calculating a period demand amount per unit period by processing according to the fixed information and a storage unit that stores the associated information An order that is an inventory planning reference value that indicates that the product needs to be ordered using the period demand, the inventory replenishment lead time, and the inventory replenishment lead time. An inventory planning system comprising processing means for calculating points.

  Further, according to the present invention, in the inventory planning system, the confirmation information is either unification information indicating that the delivery amount of the product is unconfirmed or accuracy information indicating that the delivery amount of the product is confirmed. And the processing means acquires the unordered order period indicating the unordered order quantity and the number of days of the delivery period from the storage unit, if the unordered information is the unordered order quantity, The daily demand amount is calculated from the unreserved order quantity and the unreserved order period, and if it is the confirmed information, the unreserved order quantity indicating the unreserved order quantity and the number of days of the delivery period is obtained from the storage unit and obtained. Also included is an inventory planning system that calculates daily demand from the unordered order quantity and the unlisted order period.

  Furthermore, in these inventory planning systems, the present invention also includes an inventory planning system in which the period demand is a daily demand for each day.

The present invention also includes the following aspects. In the present invention, for the order information presented from the delivery destination, the delivery quantity for a certain period is unconfirmed or the delivery quantity for a certain period is fixed. The confirmation flag for determining whether the order is confirmed information is obtained from the storage device (storage unit), and it is determined whether the order quantity obtained from the storage device is the indicated order quantity or the confirmed order quantity. In this case, the unordered order quantity indicating the unordered order quantity and the number of days of the delivery period is obtained from the storage device, the daily demand quantity is calculated from the unofficial order quantity and the unofficial order period, and the ordered quantity is the confirmed order quantity. In this case, the fixed order period indicating the fixed order quantity and the number of days of the delivery period is acquired from the storage device, the daily demand quantity is calculated from the fixed order quantity and the fixed order period, and the replenishment is performed after placing an order from the storage unit. Inventory replenishment lead, which is the number of days required before To acquire the safety stock quantity required to cope with the uncertainties of unannounced information and the daily demand quantity and safety stock quantity, inventory replenishment lead time, and replenishment planning Based on the cycle time, an order point which is an inventory plan reference value indicating that an order is necessary is calculated and stored.

  Judgment orders or final orders are determined, daily demand is calculated, and the order point is calculated and stored using the daily demand, so that the order point changes according to future information updates. Is possible. That is, in the present invention, inventory planning is performed using future information with higher accuracy than in the past.

  The inventory planning system according to the present invention can devise an inventory plan according to the accuracy of information by using the introductory information and the fixed information in the order point method.

  Hereinafter, embodiments of the present invention will be described with reference to FIGS. Here, an inventory transition image of the present system, an overall overview of the system applied to the present embodiment, the contents of the master, a rough processing flow, and a specific processing flow will be described in order. In the present embodiment, an inventory plan for each delivery destination and each product is assumed, but the present invention is not limited to this assumption. For example, inventory plans for each company warehouse and each product are also included in the present invention. In addition, for example, auto parts manufacturers usually ship daily quantities from their own warehouses based on kanban information, which is order information different from unlisted orders and confirmed orders. In many cases, however, fixed information and kanban information generally have a small quantitative difference, and thus are not particularly mentioned in the present embodiment.

Hereinafter, an inventory transition image of this system will be described.
FIG. 2 shows an image of inventory transition in this system. In the present invention, for example, a parts maker can update the safety stock quantity, the ordering point, and the replenishment point when the introductory information is presented from the delivery destination, and the ordering point and the replenishment point when the confirmation information is presented. That is, the inventory plan reference value that more closely follows the demand and the accuracy of information is stored. As a result, for example, even if the latest demand is rapidly increasing due to the confirmation information, the order information can be stored using the confirmation information, and the order processing can be performed accordingly. Can be reduced. On the other hand, in the conventional order point method in which the plan reference value is not updated according to the confirmed information, the order point may not be cut because the order point is not cut, and as a result, there is a high possibility that a shortage will occur. Similarly, excess inventory can be suppressed when the latest demand is decreasing rapidly.

  As described above, the present embodiment is a system capable of suppressing shortage and excess inventory by realizing an inventory plan that varies the inventory plan reference value according to the accuracy of information.

Hereinafter, the overall configuration of the present embodiment will be described.
As illustrated in FIG. 1, the present embodiment includes a CPU 102, a main memory 107, a storage device 113, an input device 101, and an output device 106. The main memory 107, that is, the processing means, is configured by a daily processing unit 109 and a processing unit 108 by introductory order period, and the processing of the present invention is executed by the CPU 102. The unrepresentation here is information in which the amount is uncertain but the period during which the unrestriction is valid is definite. That is, the processing unit 108 for each unordered order period is a processing unit that performs processing for each period during which the unlisted is valid.

  Further, in the main memory 107 in the present embodiment, the daily processing unit 109 includes an order point calculation processing unit 111 (a), a replenishment point calculation processing unit 111 (b), and an order quantity calculation processing unit 112. For example, the process is repeatedly performed every working day. The unordered order period processing unit 108 includes a safety stock quantity calculation processing unit 110, and repeatedly executes processing for each period during which the unlisting is valid.

  Furthermore, the storage device 113 of the present invention stores a record information master 117, an inventory information master 114, an order information master 115, an order information master 118, and an inventory plan index master 116. The system, for example, the ordering system 103 and the order receiving system 104 can be referred to as needed.

  Furthermore, an input device 101 and an output device 106 are provided, and for example, reference and change by an inventory planner can be made at any time.

  Here, the master used in the present embodiment will be described with reference to FIGS.

  As shown in FIG. 7, the record information master 117 is composed of a product code 701, a date 702, a customer code 703, an unordered order record 704, and a shipment record 705, that is, for each delivery period, Shipment results 705 and unordered order results 704 are tabulated and stored for each product. Here, for example, when the period during which the unannouncement is valid is on a monthly basis, the shipment results 705 are aggregated in the month in which the shipment was made, and the unlisted order record 704 is the month of the unlisted target This is the actual received order value.

  As shown in FIG. 8, the inventory information master 114 is composed of a product code 801, a date 802, a customer code 803, a current stock quantity 804, and a remaining order 805. The current stock quantity 804 stocked in the warehouse and the remaining order 805 are stored. The current storage amount 804 is updated as needed by other systems.

  Here, the remaining order 805 is the quantity of products that have been ordered but have not yet been delivered from the factory warehouse to the company warehouse.

  As shown in FIG. 9, the order information master 115 includes a product code 901, a date 902, a customer code 903, an unordered order quantity 904, an unsigned order valid period 905, an unordered order period 906, a confirmed order quantity 907, and a confirmed order valid period. 908, a confirmed order period 909, and a confirmed flag 910, that is, a daily order by delivery destination and a product, an unordered order quantity 904, an unordered order valid period 905, an unofficial order period 906, a confirmed order quantity 907, and a confirmed order valid period 908 A fixed order period 909 and a fixed flag 910 are stored. It should be noted that all information included in the order information master 115 as described above is added and stored in the order information master 115 as needed by the order receiving system 104 when order information is received from the delivery destination.

  Here, the unordered order quantity 904 is an order quantity whose delivery quantity for a certain period is uncertain as described above. On the other hand, the confirmed order quantity 907 is the order quantity for which the delivery quantity for a certain period is fixed. In addition, the difference between the unordered order quantity 904 and the confirmed order quantity 907 is that there are cases where the amounts indicated differ, and the unordered order quantity 904 is presented from the delivery destination in time before the confirmed order quantity 907. There are two points. That is, the unordered order quantity 904 has a feature that the accuracy as information is lower than the confirmed order quantity 907, but the information is received earlier.

  Also, the unlisted order valid period 905 indicates a deliverable period related to the delivery date when the unlisted order is presented. The unordered order period 906 is the number of days of delivery period of the unordered order quantity, That is, the number of working days or the number of deliverable days in the delivery order valid period 906. Similarly, the fixed order valid period 908 indicates a possible delivery period related to the delivery date when a fixed order is presented, and the fixed order period 909 is the number of days in the delivery period of the fixed order quantity. That is, it is the number of working days or the number of deliverable days in the delivery destination in the fixed order valid period 908.

  For example, if it is assumed that 500 unlisted orders were received for November 2006 and the monthly work day is 20 days, the unordered order quantity 904 for this month is 500, the unordered order period 906 is 20, and the unlisted order is valid. The period 905 is from 2006/11/1 to 2006/11/30. That is, an input with an unordered order is accepted, and the above calculation process is executed according to this. Similarly, for example, if it is assumed that 200 confirmed orders are received from the delivery destination for 11/13 to 11/16 minutes, which is the working day of the third week of November 2006, the confirmed order quantity 907 is 200. The period 909 is 5, and the confirmed order valid period 908 is 2006/11/13 to 2006/11/16. Further, the confirmation flag 910 that is information indicating the accuracy is stored as 1 when the information is determined information, and is stored as 0 when the information is not determined, that is, when the information is introductory information.

  As shown in FIG. 10, the inventory planning index master 116 includes a product code 1001, a date 1002, a customer code 1003, a safety stock quantity 1004, an order point 1005, a replenishment point 1006, a replenishment planning cycle time 1007, and an inventory replenishment lead time 1008. , Actual production cycle time 1009 and immediate delivery coefficient 1010, that is, inventory replenishment lead time 1008 for each delivery destination by product, replenishment planning cycle time 1007, actual production cycle time 1009, immediate delivery coefficient 1010, order point 1005 , A replenishment point 1006 and a safety stock quantity 1004 are stored.

  Here, the inventory replenishment lead time 1008 and the replenishment planning cycle time 1007 are the number of days required from when an order is placed until it is replenished. That is, the inventory replenishment lead time 1008 is the time from when order processing is performed to the factory warehouse until it is replenished to the company warehouse. For example, if it takes 3 days from ordering to a factory warehouse until it is replenished to its own warehouse, the inventory replenishment lead time 1008 is 3. Therefore, it fluctuates due to the influence of holidays in the company warehouse and the factory warehouse. Therefore, in order to avoid complications of work, when storing the lead time in another system, it is preferable that it is automatically calculated and stored by reading a calendar or the like. The replenishment planning cycle time 1007 is a cycle in which the replenishment plan can be reviewed. For example, if it can be reviewed every day, the replenishment planning cycle time is 1.

  The actual production cycle time 1009 is a cycle in which production is performed within the order period for the product. For example, if the order period is 20th of the monthly working day and the plan is to be performed five times during that period, 4 (= 20/5).

  The immediate delivery coefficient 1010 is an index that indicates the ratio of immediate delivery to the delivery destination when an order is placed, that is, an index that indicates the probability of delivery of the product to the delivery destination without missing items at the time of inventory planning. In many cases, it is determined statistically based on a normal distribution. This immediate delivery coefficient 1010 is sometimes called a service coefficient. For example, if it is desired to deliver without missing items with a probability of 99%, the immediate delivery coefficient 1010 is statistically 2.33.

  The order point 1005 is an inventory plan reference value indicating that an order is required. In other words, this information is important when determining the ordering timing.

  The replenishment point 1006 is an inventory plan reference value indicating how much the inventory is to be made. In other words, this information is important when determining the order quantity.

  Furthermore, the safety stock quantity 1004 is information necessary for dealing with the uncertainty of the inside information. In other words, since the amount of unofficial information is unconfirmed, the amount may be changed depending on the confirmed information. Even if the amount is changed, the risk of shortage can be obtained by holding an extra statistically calculated inventory. It is information that can be reduced. Here, when planning in advance, the planning should be done in units that have different characteristics of shipment variations such as by delivery destination and product, that is, by delivery destination and product by unit, as in this master. Is desirable. However, if the planned unit is already determined by product or product category, etc., it is preferable to aggregate the unordered order record 704 and the shipment record 705 and store them in the record information master 117. .

  As shown in FIG. 11, the order information master 118 includes a product code 1101, a date 1102, a customer code 1103, and an order flag 1105. That is, an order quantity 1104 and an order flag 1105 are stored for each delivery destination and each product. ing. If an order is placed on a specific day, the order quantity 1104 on that day is a value larger than 0. If no order is placed, the order quantity 1104 is 0. The order flag 1105 represents the timing of ordering. The order flag 1105 is 1 on the date of ordering by delivery destination and product, and 0 on the date of no ordering.

FIG. 3 is a diagram showing a rough processing flow in the present embodiment.
First, in the processing unit 108 by unlisted order period, the safety stock quantity calculation processing unit 110 displays the unannounced record and the shipping record 705 from the record information master 117, the inventory replenishment lead time 1008 from the inventory plan index master 116, and the replenishment plan planning cycle time. 1007, an immediate delivery coefficient 1010 is extracted. Furthermore, the safe stock quantity calculation processing unit 110 calculates the safe stock quantity 1004 based on these pieces of information and stores it in the stock plan index master 116.

  In the daily processing unit 109, the order point calculation processing unit 111 (a) and the replenishment point calculation processing unit 111 (b) receive the unordered order information and the confirmed order information from the order information master 115, and the inventory plan index master 116. The safety stock quantity 1004, the inventory replenishment lead time 1008, the replenishment planning cycle time 1007, and the actual production cycle time 1009 are extracted.

  Further, the order point calculation processing unit 111 (a) and the replenishment point calculation processing unit 111 (b) calculate the order point 1005 and the replenishment point 1006 based on these pieces of information, and store them in the inventory plan index master 116.

  Next, the order quantity calculation processing unit 112 extracts the order point 1005 and the replenishment point 1006 from the inventory plan index master 116, and the current stock quantity 804 and the remaining order 805 from the inventory information master 114. Further, the order quantity calculation processing unit 112 determines the order timing and the order quantity 1104 and stores them in the order information master 118.

  The ordering system 103, which is an external device, performs ordering processing based on the determined ordering timing and the order quantity 1104.

  In this way, according to the present invention, each processing unit sequentially performs the processing for each unordered order period and for each day, thereby determining the order timing and the order quantity 1104 and making an inventory plan.

Hereinafter, a specific processing flow in the present embodiment will be described with reference to FIGS.
FIG. 4 shows a process for calculating and storing the safety stock quantity 1004. First, the safety stock quantity calculation processing unit 110 serving as a processing means receives a shipment record 705 for a predetermined period T from the record information master 117 using attribute information having a product code 701, a date 702, and a customer code 703 as a search key. The unordered order record 704 is extracted together with the respective time points, and the shipping error, which is the difference between the unordered order record 704 and the shipping record 705, is calculated using the following (Equation 1) (step 401).
Shipping error = | Indicated order record 704-Shipment record 705 | ... (Equation 1)
Here, the average of the T shipping errors calculated in (Equation 1) is calculated using the following (Equation 2) (step 402).
Average shipping error = (Σ shipping error) / T ... (Equation 2)
Further, a shipping error standard deviation which is a variation in shipping error is calculated by the following (Equation 3) (step 403).
Shipping error standard deviation = √ {square root of Σ (shipping error−shipping error average)} / √ (T−1) (Equation 3)
Further, from the inventory plan index information master, the replenishment plan planning cycle time 1007, the inventory replenishment lead time 1008, and the immediate delivery coefficient 1010 are extracted using the attribute information having the product code 1001, date 1002, and customer code 1003 as search keys (step 405). ), The safety stock quantity 1004 is calculated by the following (Equation 4) (step 406).
Safety stock amount 1004 = immediate delivery coefficient 1010 × standard deviation of shipping error × √ (stock replenishment lead time 1008 + replenishment planning cycle time 1007) (Equation 4)
Then, the safety stock quantity 1004 is stored in the inventory plan index master 116 (step 407).

  In this way, by calculating and storing the safe stock quantity 1004 from the difference between the shipment record 705 and the unordered order quantity 904, it is possible to carry out inventory planning using the order point method concept that could not be used conventionally with unofficial information. Yes.

  In this embodiment, the shipping error is calculated by the difference between the unofficial order record 704 and the shipping record 705. However, the shipping error may be calculated by the difference between the unordered order record 704 and the confirmed order record.

  FIG. 5 is a diagram showing a process of calculating the order point 1005 and the replenishment point 1006 and storing it in the storage device.

  First, the order point calculation processing unit 111 (a), which is a processing means, extracts a confirmation flag 910 from the order information master 115 using the attribute information having the product code 901, date 902, and customer code 903 as a search key (step 501), it is determined whether it is an indication or confirmation (step 502). Here, if the confirmation flag 910 is 0, the unordered order quantity 904 and unofficial order period 906 are extracted from the order information master 115 using the product code 901, date 902, and customer code 903 as search keys (step 503). As another demand amount, it calculates using the following (Formula 5) (step 504).

Daily demand amount = Indicated order quantity 904 / Indicated order period 906 (5)
If the confirmed flag 910 is 1, the confirmed order quantity 907 and the confirmed order period 909 are extracted from the order information master 115 using the attribute information having the product code 901, date 902 and customer code 903 as search keys (step 505), the daily demand amount is calculated using the following (Equation 6) (step 506).
Daily demand amount = Confirmed order quantity 907 / Confirmed order period 909 (Equation 6)
Here, it is possible to reflect highly accurate information in the inventory plan by repeatedly determining whether the information is the informed information or the confirmed information on a daily basis using the confirmation flag 910. Further, even when the confirmation information is not presented, the processing can be executed without any problem only by storing the confirmation flag 910 as 0 in the order information master 115. Further, it is determined whether the order is an unordered order or a confirmed order, and the daily demand amount is calculated and stored by dividing the unordered order quantity 904 and the confirmed order quantity 907 by the unreserved order period 906 and the confirmed order period 909 respectively associated with them. By doing so, highly accurate future information can be used for inventory planning.

Next, the safety stock quantity 1004, the inventory replenishment lead time 1008, and the replenishment planning cycle time 1007 are extracted from the inventory plan index information master using the product code 1001, date 1002, and customer code 1003 as search keys (step 507). The order point 1005 is calculated using the following (Equation 7) (step 508).
Reorder point 1005 = safety stock amount 1004+ (stock replenishment lead time 1008 + replenishment planning cycle time 1007) × daily demand amount (Equation 7)
Then, the order point 1005 obtained in step 508 is stored in the inventory plan index master 116 (step 509).

Further, the replenishment point calculation processing unit 111 (b) as processing means extracts the actual production cycle time 1009 from the inventory plan index information master using the product code 1001, the date 1002, and the customer code 1003 as search keys (step 510). ), The replenishment point 1006 is calculated using the following (Equation 8) (step 511).
Replenishment point 1006 = order point 1005 + actual production cycle time 1009 × daily demand amount (Equation 8)
Then, the replenishment point 1006 determined above is stored in the inventory plan index master 116 (step 512).

  Here, by calculating and storing the ordering point 1005 and the replenishment point 1006 using the safety stock amount 1004 and the daily demand amount, the ordering point 1005 can be changed according to the update of future information. Further, by repeatedly updating the ordering point 1005 and the replenishment point 1006 reflecting highly accurate information in the inventory plan every day, for example, even if the demand suddenly increases or decreases, the inventory manager can reorder the ordering point 1005 and the replenishment point. 1006 can be trusted as the inventory plan reference value.

  FIG. 6 is a diagram showing processing for calculating the order quantity 1104. The contents of the processing will be described below with reference to FIG.

First, the order quantity calculation processing unit 112 as processing means extracts the current stock quantity 804 and the remaining order 805 from the inventory information master 114 using the product code 801, date 802, and customer code 803 as search keys (step 601), Order point 1005 and replenishment point 1006 are extracted from inventory plan index master 116 using product code 1001, date 1002, and customer code 1003 as search keys (step 602). Here, it is determined whether or not the sum of the current stock amount 804 and the remaining order 805 is greater or less than the order point 1005 (step 603). The flag 1105 is set to 1 (step 604). Further, the order quantity 1104 is calculated using the following (Equation 9) (step 605).
Order quantity 1104 = replenishment point 1006- (current stock quantity 804 + order remaining 805) (Equation 9)
Next, the order flag 1105 and the order quantity 1104 are stored in the order information master 118 (step 606). Then, the ordering process is performed by the ordering system 103 connected to the outside (step 607).

  Here, it is possible to determine whether the inventory is below the ordering point 1005 using the ordering point 1005 determined according to the update of the future information, and to determine the ordering timing. Further, by determining the order quantity 1104 using the replenishment point 1006 determined in accordance with the accuracy of future information, it is possible to determine the order quantity 1104 that follows the demand. Furthermore, by performing order processing using order points 1005 and replenishment points 1006 in which highly accurate information is reflected in the inventory plan, for example, even when demand rapidly increases and decreases, inventory can be reduced by suppressing shortage and excess inventory. It is possible to control.

  The present invention is not functionally limited to the above-described embodiment, and can be embodied in a form according to product characteristics and business restrictions. For example, when seasonality is observed in the demand trend of products, consider a seasonal index for the safety stock quantity, calculate and store the estimated receipt / shipment date, and realize an earlier delivery date response than before There is.

It is a figure which shows the whole structure of this system. It is a figure which shows the stock transition image of this system. It is a figure which shows the rough flow of this system. It is a flowchart which shows a safety stock calculation process procedure. It is a flowchart which shows an order point and a supplement point calculation process procedure. It is a flowchart which shows the order amount calculation processing procedure. It is a figure which shows the example of a track record information master. It is a figure which shows the example of an inventory information master. It is a figure which shows the example of an order information master. It is a figure which shows the example of an inventory plan parameter | index master. It is a figure which shows the example of an ordering information master.

Explanation of symbols

  DESCRIPTION OF SYMBOLS 101 ... Input device, 102 ... CPU, 103 ... Ordering system, 104 ... Order receiving system, 105 ... Communication processing part, 106 ... Output device, 107 ... Main memory, 108・ ・ ・ Processing unit by unordered order period, 109... Daily processing unit, 110... Safety stock quantity calculation processing unit, 111 (a)... Order point calculation processing unit, 111 (b). Replenishment point calculation processing unit, 112 ... Order quantity calculation processing unit, 113 ... Storage device, 114 ... Inventory information master, 115 ... Order information master, 116 ... Inventory plan index master, 117 ..Result information master, 118... Order information master

Claims (9)

In the inventory planning system that plans product inventory using the supplier's unofficial information,
For each order received from the business partner, accuracy information indicating whether the delivery amount of the product for a certain period is unconfirmed or the confirmation information that the delivery amount of the product for a certain period is confirmed ; A first storage unit for storing the unordered order quantity, the unofficial order period indicating the number of days in the delivery period, the confirmed order quantity, and the confirmed order period indicating the number of days in the delivery period in association with each other;
Information necessary for dealing with the uncertainties of the unannounced information, including a safety stock quantity indicating information related to inventory, and an inventory replenishment lead time indicating the number of days required after the order is placed and the inventory is replenished A second storage unit that stores a replenishment plan planning cycle time indicating a cycle in which the replenishment plan can be reviewed;
Determining whether the accuracy information indicates the informed information or the confirmed information;
If the accuracy information indicates the implied information by the determination, the implied order quantity and the implied order acceptance period are acquired from the first storage unit, and a first daily demand amount is calculated from the acquired information,
Obtaining the safety stock quantity, the inventory replenishment lead time and the replenishment planning cycle time from the second storage unit;
Using the acquired information and the first daily demand amount , a first order point that is an inventory plan reference value indicating that the product needs to be ordered is calculated .
An inventory planning system comprising: processing means for storing the first order point in association with the safety stock quantity, the inventory replenishment lead time, and the replenishment planning cycle time in the second storage unit. . The inventory planning system according to claim 1,
The processing means includes
When the accuracy information indicates the confirmed information by the determination, the confirmed order quantity and the confirmed order period are obtained from the first storage unit, and a second daily demand quantity is calculated from the obtained information.
Obtaining the safety stock quantity, the inventory replenishment lead time and the replenishment planning cycle time from the second storage unit;
Using the acquired information and the second daily demand amount, a second order point that is an inventory plan reference value indicating that the product needs to be ordered is calculated.
The second order point is stored in the second storage unit in association with the safety stock quantity, the inventory replenishment lead time, and the replenishment planning cycle time.
An inventory planning system characterized by that. In the inventory planning system according to claim 1 or 2 ,
The first storage unit associates attribute information indicating the attribute of the product , the accuracy information, the unordered order quantity, the unordered order period, the confirmed order quantity, and the confirmed order period. stores Te,
The second storage unit stores the attribute information, the safety stock quantity, the inventory replenishment lead time, and the replenishment planning cycle time in association with each other,
Said processing means, said accepting input of attribute information, by searching the first memory unit obtains the probability information based on the attribute information,
Determining whether the accuracy information indicates the indication information or the confirmation information;
An inventory management system, wherein the second storage unit is searched based on the attribute information to acquire the safety stock quantity, the inventory replenishment lead time, and the replenishment planning cycle time . In the inventory management system according to claim 3 ,
The inventory plan system, wherein the attribute information includes a date, a customer code, and a product code. The inventory planning system according to claim 4,
The processing means includes
When the accuracy information indicates the indication information, the first daily demand amount is calculated by (the indication order amount ÷ the indication order period), and the first order point is calculated as (the safety stock amount). + (The inventory replenishment lead time + the replenishment planning cycle time) x the first daily demand amount),
When the accuracy information indicates the confirmed information, the second daily demand amount is calculated by (the confirmed order amount ÷ the confirmed order period), and the second order point is represented by the (safety stock amount). + (The inventory replenishment lead time + the replenishment planning cycle time) × the second daily demand amount)
An inventory management system characterized by that. The inventory planning system according to claim 5 ,
A third storage unit that stores a shipment record and an unordered record record in a certain past period in association with the attribute information;
The processing means includes
Search the third storage unit using the attribute information as a search key to obtain the shipment record and the unofficial order record,
Calculate the shipping error standard deviation from the standard deviation of the difference between the acquired shipping results and the unordered order results,
And the shipping error standard deviation, and the instant delivery coefficient is an indicator that shows the percentage that can be instant delivery to the destination of delivery at the time of entering the order, said the inventory replenishment lead time, the safety stock amount using the said replenishment planning cycle time Calculate
Stock planning system and storing the safety stock quantity, the association with stock replenishment lead time and the replenishment planning cycle time in the second storage unit. The inventory planning system according to claim 6 ,
The processing means includes
Accepts the input of actual production cycle time information indicating the cycle in which production is performed,
When indicating the probability information is the unofficial information, the a first reorder point, and the first day another demand, using the actual production cycle time, the a stock planning reference value indicating an upper limit of stock 1 replenishment point is calculated, and the first replenishment point is stored in the second storage unit in association with the safety stock quantity, the inventory replenishment lead time, and the replenishment planning cycle time,
When the accuracy information indicates the confirmed information, an inventory plan reference value indicating an upper limit for inventory using the second order point, the second daily demand, and the actual production cycle time. 2 replenishment points are calculated, and the second replenishment points are stored in the second storage unit in association with the safety stock quantity, the inventory replenishment lead time, and the replenishment planning cycle time. Inventory planning system. The inventory planning system according to claim 7,
The processing means includes
When the accuracy information indicates the inside information, the first replenishment point is calculated by (the first order point + the actual production cycle time × the first daily demand amount),
When the accuracy information indicates the confirmed information, the second replenishment point is calculated by (the second order point + the actual production cycle time × the second daily demand amount).
An inventory planning system characterized by that. The inventory planning system according to claim 8,
The processing means includes
For the product , accept the input of the current stock quantity in the company's own warehouse that manages the inventory planning system, and the remaining order that indicates the quantity that has been requested but not delivered to the company's own warehouse,
When said accuracy information indicates the unofficial information, the comparison with the current stock quantity said what the plus orders remaining first order point, to determine whether to turn off the first order point, the If the first order point is cut, the order quantity is calculated by subtracting the current stock quantity and the remaining order from the first replenishment point, and indicates that the first order point is cut. Set the flag,
The calculated order quantity and the set order flag are stored in a fourth storage unit in association with the attribute information,
When said accuracy information indicates the confirmation information, the comparison with the current stock quantity and the second order point plus the ordered residue, to determine whether to turn off the second order point, the If the second order point is cut, the order quantity is calculated by subtracting the current stock quantity and the remaining order from the second replenishment point, and indicates that the second order point is cut. Set the flag,
The calculated order quantity and the set order flag are stored in a fourth storage unit in association with the attribute information,
An inventory planning system characterized by that.

Images