JP4624191B2 - Inventory replenishment amount calculation program, computer-readable recording medium recording inventory replenishment amount calculation program, and inventory replenishment system - Google Patents

Description

  BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a stock replenishment amount calculation program for replenishing stock in a stock management business, a computer-readable recording medium recording the stock replenishment amount calculation program, and a stock replenishment system. The present invention relates to a technique for determining a replenishment amount in consideration of various lot restrictions when determining a stock replenishment item.

  Traditionally, in inventory management operations, in order to respond quickly to customer needs, suppliers need to prepare inventory that includes a margin that can withstand fluctuations in demand in time for order delivery requested by customers. .

  In general, in the case of the periodic order method, the inventory reference quantity is the supply cycle to the inventory point (production frequency, transportation frequency, etc.), the supply lead time to the inventory point (lead time for planning, production, transportation, etc.), demand The theoretical value can be calculated from the speed (demand per unit period).

  In addition, the appropriate inventory base that holds the inventory includes the required lead time from when a customer requests an item (a generic term for items: products, parts, semi-finished products, work in process, raw materials, etc.) until it arrives at hand. , The inventory position where the supply lead time is equal for the supplier to deliver the item to the customer.

  As a method for setting the inventory position, there are a method for obtaining and setting the above theoretical position, and a method for setting to an arbitrary position. As a technique for setting an inventory position, for example, a technique described in Patent Document 1 is known.

  Moreover, the technique of patent document 2 is known by the technique regarding the inventory replenishment amount calculation required in order to maintain the said inventory level.

  Recently, there are a large number of items that require inventory management due to sluggish domestic demand, intensifying price competition, diversification of customer needs, shortening of product life cycle, and the like. As a result, the supply chain structure has changed to a supply chain structure that holds more inventory than the conventional supply chain structure, and excess and shortage of inventory is becoming a serious problem. Inventories also tend to increase due to restrictions on production facilities, production capacity, transportation methods, and methods, and the management man-hours required to solve these problems have become enormous, affecting corporate performance. .

  As a method for solving this problem, Patent Document 2 describes a method of replenishing a necessary amount in ascending order of hand-held safety stock ratio to optimize the inventory. However, with this method, even if the optimum replenishment amount is calculated, it is difficult to obtain a plan result that matches the reality because it cannot take into account production restrictions that can be defined by the lot size.

In Patent Document 3, it is attempted to achieve both optimization of inventory and improvement of production efficiency by accumulating fixed lot sizes.
Japanese Patent Laid-Open No. 10-194212 JP 2000-348016 A JP 2002-108439 A

  However, even in the technique described in Patent Document 3 of the above prior art, the lot size is only fixed for each item, and the economical minimum production lot size considered from the setup time and the like, and the packing state transportation lot such as pallets used for transportation It is possible to solve the problems of production and transportation of conventional assembly-type production, such as compatibility between sizes and the difficulty of replenishing multiple items within a unit period because there is no upper limit on the replenishment amount. There wasn't.

  The present invention has been made to solve the above-mentioned problems, and its purpose is to efficiently use a plurality of preset lot sizes in consideration of production and transportation constraints in order to optimize inventory. To provide an inventory replenishment amount calculation program that suppresses the occurrence of excess and deficiency, a computer-readable recording medium that records the inventory replenishment amount calculation program, and an inventory replenishment system.

  Of the inventions disclosed in the present application, the outline of typical ones will be briefly described as follows.

  The inventory replenishment amount calculation program according to the present invention provides a computer device for calculating the inventory replenishment amount for each item in a production process for producing a plurality of items, information on production capacity for producing a plurality of items, and inventory for each item. Stores information on minimum lot size, unit lot size and maximum lot size of replenishment amount, inventory reference amount for each item, information on maximum stock amount and cumulative replenishment amount, and current effective stock amount information for each item Based on the storage means and various information stored in the storage means, it functions as a processing means for calculating an inventory replenishment amount for each item.

  A computer-readable recording medium storing an inventory replenishment amount calculation program according to the present invention includes a computer device for calculating the inventory replenishment amount for each item in a production process for producing a plurality of items, and a plurality of items. Information on production capacity to be produced, information on minimum lot size, unit lot size and maximum lot size of stock replenishment amount for each item, information on stock standard amount, maximum stock amount and cumulative replenishment amount for each item, and information for each item Storage means for storing the current effective inventory quantity information, and an inventory replenishment amount calculation program that functions as a processing means for calculating the inventory replenishment quantity for each item based on various information stored in the storage means Is.

  An inventory replenishment system according to the present invention is an inventory replenishment system for calculating an inventory replenishment amount for each item in a production process for producing a plurality of items, and includes information on production capacity for producing a plurality of items, and for each item. Information on the minimum lot size, unit lot size and maximum lot size of the inventory replenishment amount, information on the stock reference amount, maximum stock amount and cumulative replenishment amount for each item, and information on the current effective stock amount for each item A storage device for storage and a processing device for calculating an inventory replenishment amount for each item based on various types of information stored in the storage device are provided.

  Among the inventions disclosed in the present application, effects obtained by typical ones will be briefly described as follows.

  According to the present invention, it is possible to suppress the occurrence of excess and shortage of inventory and level the production capacity while controlling the replenishment of the inventory with a lot size that matches the production capacity and production / transport restrictions.

  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings. Note that components having the same function are denoted by the same reference symbols throughout the drawings for describing the embodiment, and the repetitive description thereof will be omitted.

<System configuration of inventory replenishment system>
A system configuration of an inventory replenishment system according to an embodiment of the present invention will be described with reference to FIG. FIG. 1 is a diagram showing a system configuration of an inventory replenishment system according to an embodiment of the present invention.

  In the present embodiment, the inventory replenishment system 200 is configured by a plurality of subsystems such as a terminal a201 and a terminal b202 connected via a network 203, and various functions described below are performed by the plurality of subsystems. Each is distributed. In the example shown in FIG. 1, a terminal a201 is a terminal that inputs parameters, and a terminal b202 is a terminal that calculates inventory replenishment amount. In this case, for example, the terminal a201 is configured as a client, and the terminal b202 is configured as a server.

  The machine of the inventory replenishment system 200 is an information processing machine that controls the replenishment of inventory by integrating and managing plan information, performance information, and various parameters.

  Note that the inventory replenishment system according to the present embodiment is not limited to a form in which centralized processing is performed by one machine, but may be realized by a form in which distributed processing is performed by each machine. Also, a part of each machine function may be rearranged, subdivided, or combined. In the present embodiment, the inventory replenishment system is described as a system that performs centralized processing with one machine, but the present invention is not limited to this. It is also conceivable that the present invention is configured to be incorporated in another information processing system and function as a part thereof.

<Hardware configuration of inventory replenishment system>
Next, the hardware configuration of the inventory replenishment system according to the embodiment of the present invention will be described with reference to FIG. FIG. 2 is a diagram showing a hardware configuration of the inventory replenishment system according to the embodiment of the present invention.

  In FIG. 2, each information processing machine, which is a computer device of the terminal a201 and the terminal b202, executes an input device 301 such as a keyboard and a mouse, an output device 302 such as a display, an auxiliary storage device 304, and a stock replenishment amount calculation program. Device 303.

  The processing device 303 includes an interface 3031, a central processing unit (hereinafter referred to as CPU) 3032, and a main storage device 3033, and is connected to the input device 301, the output device 302, and the auxiliary storage device 304 via the interface 3031.

  In the present embodiment, the processing result of the inventory replenishment amount calculation program is stored in a storage area secured in the main storage device 3033. The inventory replenishment amount calculation program is stored in advance in the auxiliary storage device 304 and read into the main storage device 3033, and the CPU 3032 executes the program to realize various functions.

  In this embodiment, the case where the inventory replenishment system is realized by a general-purpose information processing apparatus and software will be described as an example. For example, hardware including hard-wired logic or such hardware is programmed in advance. It may be realized by a general-purpose information processing apparatus.

<Positioning function of inventory replenishment system>
Here, the positioning of the inventory replenishment system according to the embodiment of the present invention will be described.

  Recently, a supply chain planning system (hereinafter referred to as SCP) is an information system that has begun to be used in enterprises. Its main functions are demand planning, supply planning, delivery date response and scheduling, which tend to be very large. Other systems include an enterprise resource planning system (hereinafter referred to as ERP). It has functions such as inventory management, but it is mainly performance management and it must be said that the planning function is weak.

  The inventory replenishment system in the present embodiment is a mechanism that is used to balance supply and demand with a relatively small system instead of the SCP, and that the result is linked to ERP and executed.

<Item definition>
In the following description of the present embodiment, the term item is used. This item is used as a general term for products, parts, semi-finished products, work-in-process items, raw materials, and the like corresponding to the product to be produced, and a word representing one of them.

<Production model assumed as a target of inventory replenishment system>
Next, a production model to which the inventory replenishment system according to an embodiment of the present invention is applied will be described with reference to FIG. FIG. 3 is an explanatory diagram for explaining a production model to which the inventory replenishment system according to the embodiment of the present invention is applied.

  In FIG. 3, as a production model to which the inventory replenishment system is applied, the production base α has production processes α1 and α2, and a plurality of items can be produced in each process. In addition, it can be assumed that each process has a different production system, and therefore, the amount of items that can be produced and various restrictions related to production may be different.

<Function of inventory replenishment system according to one embodiment of the present invention>
Next, functions of the inventory replenishment system according to the embodiment of the present invention will be described with reference to FIG. FIG. 4 is an explanatory diagram for explaining the function of the inventory replenishment system according to the embodiment of the present invention.

  FIG. 4 shows an example in which one information processing machine has all the functions, data, and codes of the inventory replenishment system 200.

  In the configuration as shown in FIG. 4, for example, all programs, data, and codes are stored in one information processing machine shown in FIG. This is used when a processing machine accesses this integrated management machine via a network as needed and reads out necessary programs and necessary data for distributed processing. In addition, it is conceivable that each information processing machine at each base has a configuration in which all functions, data, and codes are provided, or a configuration in which only necessary functions are provided.

  As shown in FIG. 4, the inventory replenishment system 200 implements a cumulative replenishment amount calculation function by executing each program in the processing device 303 based on various information stored in the auxiliary storage device 304. Details of processing contents for realizing each of these functions will be described later in the description of the processing flow.

  In this embodiment, the auxiliary storage device 304 is provided with a code storage unit 400 and a data storage unit 410. The code storage unit 400 stores basic data such as processing programs for realizing various functions, item codes, process codes, lot size masters, inventory standard masters, process masters, etc., whose contents are not frequently changed. . On the other hand, the data storage unit 410 holds data with a relatively high frequency of data rewrite by various processes such as inventory record data, inventory reference data, and cumulative replenishment amount data, and data input.

  Here, with reference to FIG. 5 to FIG. 10, some of the codes and data stored in the code storage unit 400 and the data storage unit 410 of the auxiliary storage device 304 will be supplemented. 5 to 10 are diagrams showing examples of codes and data stored in the code storage unit 400 and the data storage unit 410 of the auxiliary storage device 304 of the inventory replenishment system according to the embodiment of the present invention.

-Inventory actual data The table structure of the inventory actual data which shows an inventory condition in this Embodiment is shown in FIG. The table includes a process column, an item column, an effective inventory column, and the like. The process column holds the name of the process that performs the production. In the case of the production base α, the processes “α1” and “α2” are held. The item column holds the item number. For example, A, B, C, D, etc. are held. The effective stock quantity column holds the effective stock quantity of the item on the reference date. For example, when the planning date is April 6 and the process is α1, the item A is 130, the item B is 170, the item C is 165, the item D is 120, and so on.

Stock Standard Data FIG. 6 shows a table structure of stock standard data in the present embodiment. The table includes a process column, an item column, an inventory reference amount column, and the like. The process column holds the name of the process that performs the production. The item number is held in the item column. The inventory reference value column holds the target value of inventory. For example, when the planning date is April 6 and the process is α1, item A is 200, item B is 250, item C is 200, item D is 150, and so on. The inventory reference amount may be a theoretical inventory calculation formula based on inventory theory such as statistical processing of actual demand, or may be manually input such as practical experience.

-Cumulative replenishment amount data The table structure of the cumulative replenishment amount data in the present embodiment is shown in FIG. The table includes a process column, an item column, a cumulative replenishment amount column, and the like. The process column holds the name of the process that performs the production. The item number is held in the item column. In the cumulative replenishment amount column, the replenishment amount calculated this time is held for each process / item. For example, when the planning date is April 6 and the process is α1, the item A is 40, the item B is 80, the item C is 20, the item D is 50, and so on.

Process Master FIG. 8 shows the contents of the process master stored data in the present embodiment. The table is equipped with process, production capacity and so on. The production capacity indicates a quantity that can be produced during a unit period such as one day or a plurality of days, and is set for each unit period. For example, it is registered that the production capacity of the process α1 is 200,.

  When the production efficiency differs for each target item, or when it is necessary to consider the setup time, a master configuration and calculation algorithm that takes these into consideration may be prepared.

Upper limit margin inventory rate master The contents of the stored data of the upper limit margin inventory rate master in the present embodiment are shown in FIG. The table includes a process, an item, an upper limit margin inventory rate, and the like. In the upper limit margin inventory ratio, the upper limit value of inventory is held in the form of a ratio to the inventory standard. For example, when the process is α1, it is registered that item A is 1.2, item B is 1.2, item C is 1.1, item D is 1.2,.

Lot size master FIG. 10 shows the contents of data stored in the lot size master in the present embodiment. The table includes processes, items, minimum lot size, unit lot size, maximum lot size, and the like. The minimum lot size is a minimum quantity in production in a unit period, which is derived from constraints such as production and transportation. The unit lot size is a unit quantity in the case of increasing the production amount, which is derived from packing or transportation. The maximum lot size is the maximum quantity that can be produced in a unit period such as one day or multiple days, and is set in consideration of the number of items that you want to produce in a unit period, or linked to the arrival schedule for ordering raw materials and parts. May be set.

  For example, when the process is α1, it is registered that the minimum lot size of the item A is 20, the unit lot size is 20, the maximum lot size is 100,. In the case of this setting example, the production amount in the unit period is controlled by 0, 20, 40, 60, 80, 100.

<Processing of inventory replenishment system>
Next, the processing operation of the inventory replenishment system according to the embodiment of the present invention will be described with reference to FIGS. FIG. 11 is a processing flow showing the processing operation of the inventory replenishment system according to the embodiment of the present invention, and shows processing in the configuration of the terminal a201 and the terminal b202 shown in FIG. 12 to 13 are diagrams showing examples of operation screens of the inventory replenishment system according to the embodiment of the present invention, and FIG. 14 is a diagram showing replenishment instruction data of the inventory replenishment system according to the embodiment of the present invention. .

  First, in the terminal a201, a search condition is set in order to confirm data such as actual inventory and inventory standards and various parameters. This operation is repeated one or more times as necessary. For example, the following description will be given using a lot size as an example.

  In the terminal a201, the search conditions 1201 and 1202 in the upper part of the operation screen example shown in FIG. 12 are set, and when the search button 1203 is pressed, the search conditions are transferred to the terminal b202 and search is performed (S1101). At this time, you may enable it to designate both or one of a process (1201) and an item (1202).

  The terminal b202 searches for data stored in the auxiliary storage device in accordance with the set search condition (S1102). If the data matching the condition can be extracted, the data is transferred to the terminal a201.

  The terminal a201 receives the extraction result and displays it on the lower 1204 of the operation screen example shown in FIG. 12 (S1103). Data is added or modified based on the display result. After the addition / correction, the update button 1205 is pressed to transfer the input data to the terminal b202.

  The terminal b202 registers / updates data stored in the auxiliary storage device based on the added / modified data (S1104). The processing result is transferred to the terminal a201.

  The terminal a201 receives the registration / update processing result and displays it on the lower part 1204 of the operation screen example shown in FIG. 12 (S1105). If correction / addition is to be performed again on this result, the process returns to S1103 again to continue the operation. When the work is finished, the end button 1206 is pressed to finish.

  Next, the inventory replenishment amount is calculated at a predetermined timing.

  In the terminal a201, the execution condition 1001 in the upper part of the operation screen example shown in FIG. 13 is set, and the execution button 1002 is pressed to transfer the execution condition to the terminal b202 and execute the inventory replenishment amount calculation calculation (S1111). . At this time, a plurality of steps (1001) may be set.

  Based on the execution condition, the terminal b202 reads data such as inventory record data and inventory reference data and various parameters stored in the auxiliary storage device 304 into a means for calculating the inventory replenishment amount, performs calculation processing (S1112), and performs a terminal a201. The replenishment amount calculation result data that is the update result of the replenishment instruction data as shown in FIG. 14 is transferred.

  When the process is completed, the terminal a201 displays the result on the output means (S1113). In this example, it is displayed in units of replenishment instructions, but may be totaled in item units. When continuing the work, the process returns to S1111 again. In the case of ending, the end button 1004 is pressed to end.

<Calculation procedure of inventory replenishment amount>
Next, the inventory replenishment amount calculation procedure of the inventory replenishment system according to the embodiment of the present invention will be described with reference to FIG. FIG. 15 is a flowchart showing a procedure for calculating the inventory replenishment amount of the inventory replenishment system according to the embodiment of the present invention. In the example of FIG. 15, the description will be made on the assumption that the target process is determined in advance. However, in an actual inventory replenishment system, there is no problem even if all the processes are sequentially calculated.

  First, symbols used in FIG. 15 will be described.

  Rm: The margin inventory ratio is a multiplication factor of the effective inventory quantity with respect to the reference inventory quantity.

  Prm: The upper limit inventory ratio is an excess inventory ratio of the upper limit inventory quantity for each item.

  CumSr: Cumulative inventory is the total value of replenishment lots for each item.

  SumSr: The total replenishment amount is the total replenishment amount of items sharing the process, and is the total value of the cumulative replenishment amount of each item.

  MinLot: The minimum lot size is an amount that needs to be replenished at a minimum in one planning period.

  MaxLot: The maximum lot size is an upper limit value that can be replenished in one planning period.

  UnitLot: The unit lot size is a unit amount for calculating the replenishment amount in one planning period.

  Cap: The production capacity is the total producible amount of all items in the target process.

  As a procedure for calculating the stock replenishment amount of the stock replenishment system, first, all items produced in the target process are selected (S501), and the cumulative replenishment amount (CumSr) of all target items is initialized. (S502).

Then, with respect to all target items, the marginal inventory rate (Rm) is calculated for each item by the following equation (1) (S503). The effective stock quantity is searched and acquired from the actual inventory data in the data storage unit 410, and the inventory reference quantity is searched from the inventory reference data in the data storage unit 410.
(Equation 1)
Marginal stock ratio (Rm) = (Effective stock quantity + cumulative replenishment quantity (CumSr)) / Inventory standard quantity And all items are sorted in ascending order in the marginal stock ratio (Rm), the first item is selected, and the following processing (S504). That is, in S504, an item having the smallest margin inventory rate (Rm) and the highest necessity for inventory replenishment is selected.

  Then, in order to determine whether the target item needs to be replenished, the excess inventory rate (Rm) is compared with the upper limit excess inventory rate (Prm) (S505). If the surplus inventory rate (Rm) is equal to or greater than the upper limit surplus inventory rate (Prm) in S505, there is no need to restock the target item, so the next item to be replenished in order to calculate the next item Is present (S514), and if there is a next item to be replenished in S514, the next item arranged in the margin inventory rate (Rm) order is selected (S506), and the process returns to S505.

  If there is no next item to be replenished in S514, in order to end the replenishment calculation, the cumulative replenishment amount (CumSr) is registered / updated in the cumulative inventory replenishment amount data for each process / item (S513).

  In S505, if the surplus stock rate (Rm) is smaller than the upper limit surplus stock rate (Prm), stock replenishment is possible for the target item. Therefore, in order to determine whether a refill amount instruction has already been calculated, the cumulative replenishment amount (CumSr) And the minimum lot size (MinLot) are compared (S507).

  If the cumulative replenishment amount (CumSr) is equal to or larger than the minimum lot size (MinLot) in S507, it is determined whether the maximum replenishment amount in the unit period has already been exceeded. ) Are compared (S509).

  If the cumulative replenishment amount (CumSr) is smaller than the minimum lot size (MinLot) in S507, the first replenishment amount instruction is issued for the target item by substituting the minimum lot size (MinLot) for the cumulative replenishment amount (CumSr) (S508). ).

  If the cumulative replenishment amount (CumSr) is equal to or larger than the maximum lot size (MaxLot) in S509, there is no need to restock the target item, so the next item to be replenished is calculated in order to calculate the next item. Whether there is a next item to be replenished in S514 is selected (S514). If there is a next item to be replenished, the next item arranged in the margin inventory rate (Rm) order is selected (S506), and the process returns to S505.

  If the cumulative replenishment amount (CumSr) is smaller than the maximum lot size (MaxLot) in S509, stock replenishment is possible for the target item. Therefore, a replenishment instruction is issued by adding the unit lot size (UnitLot) to the cumulative replenishment amount (CumSr). Add (S510).

  After the initial replenishment amount instruction for the target item in S508 or the additional replenishment amount instruction for the target item in S510, the total replenishment amount (SumSr) is calculated to calculate the total replenishment amount (SumSr). Are integrated (S511).

  Then, the production capacity (Cap) is compared with the total replenishment amount (SumSr) in order to determine whether or not the item for inventory replenishment can be produced (S512).

  If the production capacity (Cap) is larger than the total replenishment amount (SumSr) in S512, the process returns to S503 to repeat the process in order to add a replenishment instruction.

  If the production capacity (Cap) is equal to or smaller than the total replenishment amount (SumSr) in S512, the cumulative replenishment amount (CumSr) is registered / updated in the cumulative inventory replenishment amount data for each process / item in order to finish the replenishment calculation. (S513). At this time, since the total replenishment amount (SumSr) exceeds the production capacity (Cap), the cumulative replenishment amount (CumSr) immediately before the last replenishment is used. However, depending on production restrictions, there may be no problem even if the total replenishment amount (SumSr) exceeds the production capacity, and the cumulative replenishment amount (CumSr) may be used as it is. When the registration / update process is completed for all target items, the replenishment amount calculation procedure is terminated.

<Specific example of calculation formula and calculation procedure of inventory replenishment amount>
Next, with reference to FIGS. 5 to 10, 14, and 16 to 19, specific examples of the calculation formula and calculation procedure for the inventory replenishment amount according to the flowchart shown in FIG. FIGS. 16-19 is a figure which shows an example of the replenishment amount calculation of the inventory replenishment system which concerns on one embodiment of this invention.

  The following procedure for calculating the inventory replenishment amount will be described with reference to FIGS. 14 and 16 to 19, taking as an example the case where the input data shown in FIGS.

(Procedure 1) The result of calculating the margin inventory rate (Rm) based on S0503 to S0504 shown in FIG. 15 is shown in the margin inventory rate calculation result of FIG. 16 (first replenishment calculation). For example, from FIG. 5 and FIG. 6, the effective stock amount of item A is 130, the stock reference amount is 200, and since stock replenishment is not performed, the cumulative replenishment amount is 0, and the marginal stock rate is As shown in the following formula 2, it becomes 0.65. Similarly, four items are calculated, and as a result, as shown in FIG.
(Equation 2)
Marginal stock ratio (Rm) = (effective stock quantity + cumulative replenishment quantity (CumSr)) / stock standard quantity
= (130 + 0) / 200
= 0.65
(Procedure 2) By using S0505 shown in FIG. 15, for the item A to be replenished, the margin inventory rate (Rm): 0.65 is compared with the upper limit margin inventory rate (Prm): 1.2 shown in FIG. Since the inventory rate (Rm) is small, the replenishment calculation is performed.

  (Procedure 3) Since the cumulative replenishment amount (CumSr): 0 is compared with the minimum lot size (MinLot): 20 for the item A to be replenished by S507 shown in FIG. 15, the cumulative replenishment amount (CumSr) is small. In S508 of FIG. 15, 20 as the minimum lot size is set as the replenishment amount.

  (Procedure 4) In S511 of FIG. 15, 20 which is the sum of the cumulative replenishment amount (CumSr) of all items is substituted for the total replenishment amount (SumSr). The results so far are shown in the replenishment amount calculation result of FIG. 16 (first replenishment calculation).

  (Procedure 5) Similarly, procedure 1 is executed as the second replenishment calculation. As a result, as shown in the margin inventory rate calculation result of FIG. 17 (second replenishment calculation), item B becomes a replenishment target.

  (Procedure 6) The procedure 2 to procedure 4 are repeated for the item B, and as a result, the replenishment amount calculation result of FIG. 17 (second replenishment calculation) can be obtained.

  (Procedure 7) Similarly, when the production capacity (Cap), which is the condition of S512 shown in FIG. 15, is advanced to just before the total replenishment amount (SumSr) is exceeded, FIG.

  (Procedure 8) If the calculation is further advanced, FIG. 19 (seventh replenishment calculation) can be obtained. In this state, the total replenishment amount (SumSr) 210 exceeds the production capacity (Cap) 200, and S513 of FIG. 15 is executed by the condition determination of S512 of FIG.

  (Procedure 9) By S513 in FIG. 15, the last (seventh) replenishment calculation result exceeding the production capacity is removed, and replenishment instruction data is created. The result of reflecting the replenishment amount in the replenishment instruction data is shown in FIG. Thereby, it is possible to perform inventory replenishment in consideration of the minimum lot size, the maximum lot size, the unit lot size, the process / item production capacity of each item.

  As described above, in the present embodiment, by efficiently using a plurality of lot sizes, inventory reference quantities, and maximum inventory quantities set in advance in consideration of production and transportation constraints, occurrence of excess or shortage of inventory is suppressed. This makes it possible to formulate an inventory replenishment plan with high feasibility.

  As mentioned above, the invention made by the present inventor has been specifically described based on the embodiment. However, the present invention is not limited to the embodiment, and various modifications can be made without departing from the scope of the invention. Needless to say.

  The present invention relates to a stock replenishment amount calculation program for stock replenishment in a stock management operation, a computer-readable recording medium recording the stock replenishment amount calculation program, and a stock replenishment system. In particular, the present invention can be applied to a system that determines a replenishment amount that takes into account the constraints of various lots when determining a stock replenishment item based on a surplus inventory rate.

It is a figure which shows the system configuration | structure of the inventory replenishment system which concerns on one embodiment of this invention. It is a figure which shows the hardware constitutions of the inventory replenishment system which concerns on one embodiment of this invention. It is explanatory drawing for demonstrating the production model to which the inventory replenishment system which concerns on one embodiment of this invention is applied. It is explanatory drawing for demonstrating the function of the inventory replenishment system which concerns on one embodiment of this invention. It is a figure which shows an example of the inventory performance data stored in the auxiliary storage device of the inventory replenishment system which concerns on one embodiment of this invention. It is a figure which shows an example of the inventory reference | standard data stored in the auxiliary storage device of the inventory replenishment system which concerns on one embodiment of this invention. It is a figure which shows an example of the accumulation replenishment amount data stored in the auxiliary storage device of the inventory replenishment system which concerns on one embodiment of this invention. It is a figure which shows an example of the process master stored in the auxiliary storage device of the inventory replenishment system which concerns on one embodiment of this invention. It is a figure which shows an example of the upper limit margin inventory rate master stored in the auxiliary storage device of the inventory replenishment system which concerns on one embodiment of this invention. It is a figure which shows an example of the lot size master stored in the auxiliary storage device of the inventory replenishment system which concerns on one embodiment of this invention. It is a processing flow which shows the processing operation of the inventory replenishment system which concerns on one embodiment of this invention. It is a figure which shows the example of an operation screen of the inventory replenishment system which concerns on one embodiment of this invention. It is a figure which shows the example of an operation screen of the inventory replenishment system which concerns on one embodiment of this invention. It is a figure which shows the replenishment instruction | indication data of the inventory replenishment system which concerns on one embodiment of this invention. It is a flowchart which shows the calculation procedure of the inventory replenishment amount of the inventory replenishment system which concerns on one embodiment of this invention. It is a figure which shows an example of the replenishment amount calculation (1st replenishment calculation) of the inventory replenishment system which concerns on one embodiment of this invention. It is a figure which shows an example of the replenishment amount calculation (2nd replenishment calculation) of the inventory replenishment system which concerns on one embodiment of this invention. It is a figure which shows an example of the replenishment amount calculation (6th replenishment calculation) of the inventory replenishment system which concerns on one embodiment of this invention. It is a figure which shows an example of the replenishment amount calculation (7th replenishment calculation) of the inventory replenishment system which concerns on one embodiment of this invention.

Explanation of symbols

  DESCRIPTION OF SYMBOLS 200 ... Inventory replenishment system, 201 ... Terminal a (client), 202 ... Terminal b (server), 203 ... Network, 301 ... Input device, 302 ... Output device, 303 ... Processing device, 3031 ... Interface, 3032 ... Central processing Device (CPU), 3033 ... main storage device, 304 ... auxiliary storage device, 400 ... code storage unit, 410 ... data storage unit, 1002 ... execution button, 1004 ... end button, 1203 ... search button, 1205 ... update button, 1206 ... End button.

Claims (5)

A computer device for calculating an inventory replenishment amount for each item in a production process for producing a plurality of items;
Information on production capacity, which is a producible quantity for producing the plurality of items in the production process , and a minimum, which is a minimum quantity in production in a unit period of the inventory replenishment amount , based on at least a restriction on production of the item for each item Information on a lot size , a unit lot size that is a unit quantity in the case of increasing the production amount of the item based on at least restrictions on packing of the item, and a maximum lot size that is a maximum quantity that can be produced in the unit period ; Inventory reference amount that is the target value of inventory for each item, information on the upper limit margin rate that is the upper limit margin with respect to the inventory reference amount, and cumulative replenishment amount that is the cumulative value of replenishment amount, and the current for each item Storage means for storing effective inventory information that is an effective inventory quantity;
Based on the various information stored in the storage means, for each item, a margin inventory rate is calculated from information on the effective inventory amount, the cumulative replenishment amount, and the inventory reference amount, and the margin inventory rate calculated and the A range in which the inventory replenishment amount of the entire item does not exceed the production capacity based on the comparison result and the cumulative replenishment amount, the minimum lot size, the maximum lot size, and the production capacity information. The inventory replenishment amount calculation program which functions as a processing means for calculating the inventory replenishment amount. In the inventory replenishment amount calculation program according to claim 1,
The processing means, before SL on the basis of the allowance stock rate of each item, restocking amount calculation program characterized determine Teisu Rukoto the item replenishment target. A computer device for calculating an inventory replenishment amount for each item in a production process for producing a plurality of items;
Information on production capacity, which is a producible quantity for producing the plurality of items in the production process , and a minimum, which is a minimum quantity in production in a unit period of the inventory replenishment amount , based on at least a restriction on production of the item for each item Information on a lot size , a unit lot size that is a unit quantity in the case of increasing the production amount of the item based on at least restrictions on packing of the item, and a maximum lot size that is a maximum quantity that can be produced in the unit period ; Inventory reference amount that is the target value of inventory for each item, information on the upper limit margin rate that is the upper limit margin with respect to the inventory reference amount, and cumulative replenishment amount that is the cumulative value of replenishment amount, and the current for each item Storage means for storing effective inventory information that is an effective inventory quantity;
Based on the various information stored in the storage means, for each item, a margin inventory rate is calculated from information on the effective inventory amount, the cumulative replenishment amount, and the inventory reference amount, and the margin inventory rate calculated and the A range in which the inventory replenishment amount of the entire item does not exceed the production capacity based on the comparison result and the cumulative replenishment amount, the minimum lot size, the maximum lot size, and the production capacity information. in restocking amount calculation program recorded with a computer-readable recording medium to function as processing means for calculating the replenishment amount. A computer-readable recording medium which records the replenishment amount calculation program according to claim 3,
The processing means, before SL on the basis of the allowance stock rate of each item, restocking amount calculation program recorded with a computer-readable recording medium characterized determine Teisu Rukoto the item replenishment target. An inventory replenishment system for calculating an inventory replenishment amount for each item in a production process for producing a plurality of items,
Information on production capacity, which is a producible quantity for producing the plurality of items in the production process , and a minimum, which is a minimum quantity in production in a unit period of the inventory replenishment amount , based on at least a restriction on production of the item for each item Information on a lot size , a unit lot size that is a unit quantity in the case of increasing the production amount of the item based on at least restrictions on packing of the item, and a maximum lot size that is a maximum quantity that can be produced in the unit period ; Inventory reference amount that is the target value of inventory for each item, information on the upper limit margin rate that is the upper limit margin with respect to the inventory reference amount, and cumulative replenishment amount that is the cumulative value of replenishment amount, and the current for each item A storage device for storing information on an effective inventory amount that is an effective inventory amount;
Based on various information stored in the storage device, for each item, a margin inventory rate is calculated from information on the effective inventory amount, the cumulative replenishment amount, and the inventory reference amount, and the margin inventory rate calculated and the A range in which the inventory replenishment amount of the entire item does not exceed the production capacity based on the comparison result and the cumulative replenishment amount, the minimum lot size, the maximum lot size, and the production capacity information. And a processing device for calculating a stock replenishment amount.

Images