JPH04364573A - Stock simulation system - Google Patents

Abstract

PURPOSE:To offer the stock simulation system which can perform efficient inventory management by reducing the generation rates of an overstock and a run-out. CONSTITUTION:This inventory stock simulation system is equipped with an order storage part 15 which is stored with order result data for a constant past period, an subtraction processing part 12 which subtracts the daily order data stored in the order storage parts 15 from the volume of inventories a certain period before as the initial volume of inventories, a production request output part 13 which outputs a production request when the volume of inventories after the subtraction process becomes less than the ordered volume of inventories, an addition processing part 14 which calculates a production request quantity by subtracting the current volume of inventories from the limit volumes of inventories and adds the production request quantity to the current volume of inventories a preset production lead time later to obtain the new volume of inventories, and a display part 16 which displays the daily volume of inventories varying by the subtraction processing of the subtraction processing part 12 and the addition processing of the addition processing part 14.

Description

[Detailed description of the invention]

The present invention relates to an inventory simulation system applied to a production line using an order point production system.

0002

[Prior art] When producing products with large shipping fluctuations,
It is necessary to have a certain amount of inventory so that even if a large number of orders are suddenly received, it can be delivered immediately. For this reason, in the past, products were manufactured using the order point production method, and safety stocks were always kept (an amount of stock that would not cause stockouts even if a sudden order was received).

[0003] In other words, the order point production system means that when the amount of inventory falls below the amount of ordered inventory preset as the order point,
It is intended to produce an appropriate amount within a range that does not exceed a preset limit stock amount.

0004

[Problems to be Solved by the Invention] As described above, in the order point production system, it is necessary to set the order inventory amount and the limit inventory amount. The out-of-stock rate can be kept low by setting the amount of ordered inventory, and the occurrence of excess inventory can be kept low by setting the marginal inventory amount. Setting the order inventory amount and marginal inventory amount relied on the experience and intuition of workers based on past data.

[0005] Therefore, even if the order inventory amount and the limit inventory amount are set, they are not optimal values, and there is a problem that the occurrence rate of excess inventory and out-of-stock items increases.

The present invention has been made in view of the above circumstances, and its purpose is to reduce excess inventory by performing simulations by changing the ordered inventory amount and marginal inventory amount based on daily orders and initial inventory data. An object of the present invention is to provide an inventory simulation system that can reduce the incidence of inventory and out-of-stock items and perform efficient inventory management.

[0007]

[Means for Solving the Problems] In order to solve the above problems, the inventory simulation system of the present invention includes an order storage means for storing order performance data for a certain period in the past, and a limit stock amount and a production order point. The ordered stock amount is arbitrarily set, and the stock amount from a certain period ago is set as the initial stock amount, and the daily orders stored in the order storage means are sequentially subtracted from this initial stock amount, and the stock amount after the subtraction is calculated. A production request output means outputs a production request when the quantity of ordered inventory is exceeded, and a production plan creation date is reached to create a production plan for a predetermined period based on the production request output from the production request output means. Sometimes, the production requirement is calculated by subtracting the day's inventory from the marginal inventory, and when a preset production lead time has elapsed, the production requirement is added to that day's inventory to create a new inventory. The present invention is configured to include an addition processing means for performing the processing as follows, and a display means for displaying the daily inventory amount that changes due to the subtraction processing by the production request outputting means and the addition processing by the addition processing means.

[0008]

[Operation] Order performance data for the past three months, for example, is stored in the order storage means. Further, the operator arbitrarily sets the limit inventory amount and the ordered inventory amount, which is the order point for production, and also sets the inventory amount from three months ago as the initial inventory amount. In addition, the operator also determines the production lead time (for example, 7 days), which is the time from inventory planning to when the actual product is made, and the production plan creation date (for example, , Tuesday and Friday, etc.)
and set.

In this state, the production request output means:
The daily orders stored in the order storage means are sequentially subtracted from the set initial inventory amount, and when the inventory amount after the subtraction is less than the ordered inventory amount, a production request is output.

[0010] The addition processing means calculates, when a production plan creation day (for example, either Tuesday or Friday) for creating a three-day production plan based on the production request output from the production request output means, , Calculate the production requirement by subtracting the day's inventory from the marginal inventory, and when the set production lead time of 7 days has passed, add the production requirement to that day's inventory and create a new inventory. Process the amount. In other words, products corresponding to the production request amount will be completed and added to inventory seven days after the production request is output.

[0011] The display means displays, for example, a line graph or the like, the daily stock amount trends that change due to the subtraction processing by the production request output means and the addition processing by the addition processing means.

[0012] By performing the above-mentioned simulation while variously changing the ordered stock quantity and the marginal stock quantity, it is possible to determine the optimum method for reducing the incidence of excess stock and out-of-stock items from the graph of stock quantity trends displayed on the display means. It becomes possible to determine the order inventory amount and the marginal inventory amount.

[0013]

DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described below with reference to the drawings.

FIG. 1 is a block diagram showing the electrical configuration of the inventory simulation system of the present invention.

In the same figure, the output of a data input section 11 that inputs various data is led to a subtraction processing section 12, a production request output section 13, and an addition processing section 14. The connection with the section 15 is bidirectional. Further, the output of the subtraction processing section 12 is the output of the production request output section 1.
3, an addition processing section 14, and a display section 16, and the output of the production request output section 13 is led to the addition processing section 14. Then, the output of the addition processing section 14 is the output of the subtraction processing section 1
The structure is guided by 2.

The data input unit 11 inputs the marginal inventory amount, the ordered inventory amount that is the production order point, the initial inventory amount that indicates the inventory amount from a certain period of time ago, the production plan creation date for creating a production plan for a predetermined period, and Various data such as production lead time from inventory planning to actual production of the product are input. The initial inventory amount data is then given to the subtraction processing unit 12,
The order inventory amount data is produced by the production request output unit 13 and the addition processing unit 1.
4, and each data of the production plan creation date, marginal stock amount, and production lead time is given to the addition processing section 14. In this embodiment, the production planning cycle is three days, and the production planning days are Tuesdays and Fridays. Also,
The production lead time is set to 7 days.

The order storage section 15 stores order performance data for the past three months.

The subtraction processing section 12 sequentially subtracts the daily orders stored in the order storage section 15 from the initial inventory amount input from the data input section 11, and also processes the daily inventory amount data after the subtraction process. , production request output unit 13
, is output to the addition processing section 14 and the display section 16.

The production request output section 13 issues a production request to the addition processing section 14 when the inventory amount data output from the subtraction processing section 12 is less than the ordered inventory amount input from the data input section 11. It is designed to be output.

Based on the production request outputted from the production request output section 13, the addition processing section 14 calculates the amount obtained by subtracting the inventory amount for that day from the marginal inventory amount as the production request amount when the production plan creation date arrives. When the production lead time has elapsed, the calculated production request amount is added to the inventory amount for that day to obtain new inventory amount data, which is output to the subtraction processing section 12.

The display unit 16 is adapted to display the daily inventory data output from the subtraction processing unit 12, for example, as a line graph.

Next, the operation of the inventory prediction simulation system having the above configuration will be explained.

The order storage unit 15 stores order performance data for the past three months of March, April, and May, assuming that the current date is June 1st, for example. FIG. 2 shows part of the order performance data stored in the order storage unit 15.

[0024] The operator also inputs from the data input unit 11 the marginal inventory amount, the ordered inventory amount that is the point of ordering for production, the initial inventory amount that indicates the inventory amount from a certain period of time ago, and the production information that is used to create a production plan for a predetermined period. Enter various data such as planning creation date and production lead time from inventory planning to actual production of the product. In this example, the marginal stock amount is 500
250 pieces as the order inventory amount and 40 pieces as the initial inventory amount
0 pieces, 3 days as the production planning cycle, Tuesdays and Fridays as the production planning days, and 7 days as the production lead time.

The subtraction processing unit 12 calculates the order storage unit 15 from the initial stock amount of 400 items input from the data input unit 11.
The daily orders stored in are sequentially subtracted.

That is, the subtraction processing unit 12 calculates that the order for March 1st (Friday) stored in the order storage unit 15 is 50.
Therefore, the inventory amount as of March 1st is 350 pieces, which is obtained by subtracting 50 pieces for the order from the initial stock amount of 400 pieces, and then the order on March 4th (Monday) is 30 pieces, so Subtract 30 pieces for the order from these 350 pieces, which is 320 pieces, which is the inventory amount as of March 4th.Since the order on March 5th (Tuesday) is 100 pieces, subtract 100 pieces from this 320 pieces. The 220 pieces obtained are the inventory amount as of March 5th, and the next order on March 6th (Wednesday) is 60 pieces, so 60 pieces are subtracted from these 220 pieces, which is 160 pieces as of March 6th. Let the inventory amount be . The subtraction processing section 12 outputs the daily inventory amount data subjected to the sequential subtraction processing in this manner to the production request output section 13, the addition processing section 14, and the display section 16, respectively.

FIG. 3 shows daily inventory amount data subjected to subtraction processing.

The production request output section 13 receives the daily inventory amount data given from the subtraction processing section 12 and the data input section 11.
Comparisons are made with the ordered stock amount input from . Then, when the inventory amount data given from the subtraction processing section 12 falls below the ordered inventory amount (250 pieces), a production request is output to the addition processing section 14.

In other words, in this embodiment, since the inventory amount falls below the ordered inventory amount (250 pieces) on March 5th (Tuesday), the production request is output at this point (that is, March 5th). do.

Based on the production request outputted from the production request output section 13, the addition processing section 14 calculates the amount obtained by subtracting the inventory amount for that day from the marginal inventory amount as the production request amount when the production plan creation date arrives. calculate.

That is, the production request is output on March 5th (Tuesday), and the production plan creation dates input from the data input section 11 are Tuesday and Friday, so the production request date and production plan creation date are day (Tuesday), the addition processing unit 14 calculates the limit inventory amount from 500 pieces to March 5th.
The required production quantity is calculated as 280 pieces by subtracting the daily inventory quantity of 220 pieces.

[0032] Also, in the addition processing unit 14, when the production lead time inputted from the data input unit 11, which is 7 days, has elapsed, the inventory amount (20 pieces) on that day (that is, Thursday, March 14th) is calculated. 300 pieces obtained by adding the requested production quantity (280 pieces) are output to the subtraction processing unit 12 as new inventory quantity data.

The subtraction processing unit 12 converts the 20 items that it had as inventory data as of March 14th into the addition processing unit 14.
Update to 300 pieces given from . Therefore, the subtraction processing unit 12 calculates the date of March 15 stored in the order storage unit 15.
Since the order for Sunday (Friday) is 20 items, the inventory amount as of March 15th is 280 items, which is obtained by subtracting the 20 items ordered from the updated inventory amount of 300 items.

The display section 16 displays the daily inventory data (data shown in FIG. 3) output from the subtraction processing section 12, for example, as a line graph. FIG. 4 shows part of the inventory amount transition data displayed on the display unit 16.

The inventory simulation system of the present invention is designed to obtain inventory amount trend data for three months by repeating the above-described process for the past three months of March, April, and May.

Furthermore, by arbitrarily changing the limit inventory quantity and ordered inventory quantity inputted from the data input section 11, various patterns of inventory quantity trend data can be obtained, so that the operator can By performing an inventory simulation, it is possible to determine the optimal marginal inventory amount and order inventory amount.

Note that the display unit 16 can display not only a line graph display of the stock amount change, but also the out-of-stock rate, average number of months in stock, etc. determined from this stock amount change data. Furthermore, if the display section 16 is provided with an output means such as a printer, it is also possible to print out the inventory amount transition data on recording paper or the like.

[0038]

Effects of the Invention: The inventory simulation system of the present invention is configured to perform inventory simulation by changing the ordered inventory amount and marginal inventory amount based on daily orders and initial inventory amount data. This has the effect that the optimal order inventory amount and marginal inventory amount that do not cause such problems can be easily determined.

[Brief explanation of drawings]

FIG. 1 is a block diagram showing the electrical configuration of an inventory simulation system of the present invention.

FIG. 2 is a diagram showing order performance data stored in an order storage unit.

FIG. 3 is a diagram showing daily inventory amount data subjected to subtraction processing in a subtraction processing section.

FIG. 4 is a line graph showing inventory amount trend data displayed on the display section.

[Explanation of symbols]

11 Data input section 12 Subtraction processing section 13 Production request output section 14 Addition processing section 15 Data storage section 16 Display section

Claims (1)

[Claims] Claim 1: Order storage means for storing order performance data for a certain period of time in the past, arbitrarily setting a limit inventory amount and an order inventory amount that is an order point for production, and setting the initial inventory amount for a certain period of time ago. Production request output means that sequentially subtracts the daily orders stored in the order storage means from this initial inventory amount as the inventory amount, and outputs a production request when the inventory amount after the subtraction is less than the ordered inventory amount. Then, when the production plan creation date for creating a production plan for a predetermined period is reached based on the production request output from the production request output means, the production request is made for the amount obtained by subtracting the inventory amount for that day from the marginal inventory amount. an addition processing means for adding the requested production amount to the inventory amount for that day to obtain a new inventory amount when a preset production lead time has elapsed; and a subtraction processing by the production request outputting means. An inventory simulation system comprising display means for displaying daily inventory amounts that change due to addition processing by the addition processing means.