JP2003295923A - Device and method for inventory control of parts and recording medium and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To realize effective use of inventory space and resultant reduction of inventory amount. <P>SOLUTION: The system comprises: a standard inventory input means 11 to enter a standard inventory amount which is an initial value of an inventory amount; a delivery information input means 12 to enter a time and an amount of parts delivered to the inventory; an inventory amount calculation means 13 to calculate how much the inventory amount has changed from the standard inventory amount based on the standard inventory amount entered by the standard inventory amount input means 11 and the time and the amount entered by the delivery information input means 12 and a display control means 14 to display the status of change of the inventory amount calculated by the inventory calculation means 13 on an output device 20. <P>COPYRIGHT: (C)2004,JPO

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a parts inventory management device, a parts inventory management method, a recording medium and a program used for parts inventory management, and more particularly to reducing the quantity of parts stored in inventory per unit time. It provides a work environment for the management method that focuses on it.

[0002]

2. Description of the Related Art Conventionally, efficient management of inventory has been discussed. For example, various methods have been proposed to deliver a considerable amount of parts at an appropriate timing in consideration of the required number of product production lines. Parts are delivered at a timing delayed with respect to the required number of production lines. In that case, the necessary parts in the inventory are out of stock, which hinders smooth product manufacturing.

On the other hand, when parts are delivered at a pace exceeding the required number of production lines, there are excessive parts that are unnecessary for the time being in manufacturing products. Parts stored in inventory, that is, work-in-progress, do not produce any added value in the state of being stored in inventory, and only produce value when they are commercialized. Therefore, rather than having excess parts in the inventory, extra work is required for inventory management, storage of parts, movement of parts, etc., which makes inventory operation uneconomical.

As a method considering the above problems, there has been proposed a method of converting parts in stock into a monetary value and adjusting this value to improve the efficiency of stock operation. As an example, calculate the ratio of the converted amount of inventory parts at the end of the month to the net production of a product in a certain month, and based on this ratio value, the rotation period of parts in inventory (hereinafter, this rotation period is the in-process rotation period. Is called), and the value of the in-process turnover period is reduced to improve the efficiency of inventory management.

To reduce the in-process rotation period,
Efforts were made to reduce parts in inventory by compressing work-in-progress. The “turn” here is expressed by a scale that goes back on a day-to-day basis from the completion of assembly of the product, and the start of work related to the parts ordered by the parts supplier (for example, the start of parts manufacturing) is the completion of the assembly. There is a “start” indicating whether it is before the date and a “complete move” indicating how many days before the completion of the assembly work (for example, completion of the delivery of the part) for the part ordered by the parts supplier. The amount of inventory depends on this "completeness", so when attempting to reduce the amount of inventory and improve the efficiency of inventory management, attempts were made to reduce the value indicated by "completeness."

[0006]

However, during the work-in-progress period, since the inventory value of only one point at the end of the month is captured and the inventory status of the entire month is evaluated, how is the inventory in the beginning of the month or during the month? The swelling will not be reflected in the figures.
Especially, when the stock situation at the end of the month is a special situation, it is difficult to say that the stock situation at that month is accurately reflected. Moreover, in the conventional inventory management by the in-process turnover period, the method of reducing the inventory amount by adjusting the numerical value of the daily unit indicated by the turn was adopted, but simply reducing the daily inventory amount It is not possible to deal with situations such as shortage of goods on the way or excessive delivery at one time. Furthermore, conventional inventory management cannot meet the demand for inventory reduction per unit time.

Further, the amount of the parts and the quantity are not in proportion to each other, and as shown in FIG. 8, the quantity of the parts whose quantity occupies 84% of the quantity of the product (here, LBP (laser beam printer)) In terms of, there are cases where the amount is only 32% of the amount of the product. In other words, although the above-mentioned method of focusing on the amount of money to reduce the amount of work in progress can improve the effective utilization of the inventory in terms of the amount of money, it is not always the method that can effectively utilize the inventory space.

The present invention has been made in view of the above problems, and makes it possible to effectively utilize an inventory space and reduce the inventory amount accordingly, a component inventory management device, a component inventory management method, and a recording medium. And to provide a program.

Further, the present invention is capable of reducing the amount of inventory and avoiding the fear that the components may be out of stock due to an unforeseen situation and the excessive delivery of the components for a period of time. An object is to provide a management device, a parts inventory management method, a recording medium, and a program.

[0010]

In order to achieve such an object, the parts inventory management apparatus according to the first aspect of the present invention is
A standard stock input means for inputting a standard stock quantity which is an initial value of the stock quantity, a delivery information input means for inputting a delivery time zone and a quantity of parts, and the standard stock quantity inputted by the standard stock input means. , An inventory amount calculating means for calculating a change situation of the inventory amount from the reference inventory amount based on the delivery time zone and the delivery amount inputted by the delivery information inputting means, and calculated by the inventory amount calculating means And a display control means for displaying the fluctuation status of the inventory quantity on the display means.

Further, according to the parts inventory management method of the second aspect of the present invention, the reference stock quantity which is the initial value of the input stock quantity, the delivery time zone of the parts, and the delivery quantity of the parts to the memory. A step of controlling storage, a step of calculating a variation status of the inventory amount from the reference inventory amount, based on the reference inventory amount stored in the memory, the delivery time zone and the delivery amount, And a step of displaying the calculated fluctuation status of the inventory quantity on a display means.

Further, the recording medium according to the third aspect of the present invention stores the reference stock quantity which is the initial value of the input stock quantity, the delivery time zone of the parts and the delivery quantity of the parts in the memory. A step of controlling, a step of calculating a variation status of the inventory amount from the reference inventory amount, based on the reference inventory amount stored in the memory, the delivery time zone and the delivery amount, A program for causing a computer to execute the step of displaying the fluctuation status of the inventory quantity on the display means is recorded.

Furthermore, the program according to the fourth aspect of the present invention is a standard stock quantity which is an initial value of the input stock quantity,
And a step of controlling the storage of the delivery time zone of the part and the delivery quantity of the part in the memory, the reference inventory amount stored in the memory, and the delivery time zone and the delivery quantity based on the It is characterized in that the computer is made to execute the step of calculating the fluctuation status of the stock quantity from the reference stock quantity and the step of displaying the calculated fluctuation status of the stock quantity on the display means.

[0014]

BEST MODE FOR CARRYING OUT THE INVENTION-Basic essence of the present invention-The present inventor takes a turn from the method of performing inventory management in terms of monetary value, and considers the stagnation status of parts in inventory, that is, the unit of physical quantity of stagnant parts in inventory. Focusing on the method of inventory management in time, we have devised a component inventory management device, etc. that is used for effective utilization of inventory space. The parts inventory management device 10 of the present invention is shown in FIG.
As shown in, for example, the standard inventory amount at the start of the first work of the day is input from the standard inventory input unit 11, and the delivery time zone of parts to the inventory and the delivery amount of each delivery time period are input to the delivery information input unit. Enter from 12. Here, the above-mentioned standard stock quantity is not limited to the start time of the work day, and may be the standard stock quantity at any time. Further, the delivery time zone and the delivery amount in that time zone are not limited to one set, and a plurality of sets can be input.

Next, the stock quantity calculation means 13 calculates the fluctuation status of the stock quantity from the standard stock quantity based on the above-mentioned respective information inputted from the standard stock input means 11 and the delivery information input means 12. As described above, the standard stock amount is a value indicating the stock amount in the morning, for example, and after the delivery time period, the stock status in which the delivery amount is added by the addition processing unit 132 is calculated. Further, when the parts in the inventory are used, the subtraction processing unit 131 performs an operation of decreasing the reference inventory amount with time according to the pace of use. Based on the processing by the subtraction processing unit 131 and the addition processing unit 132, the inventory amount calculation unit 13 calculates the inventory status.

By displaying the stock status on the output device 20 by the display control means 14, the user can manage the stock status in terms of physical quantity. As a result, it is possible to not only effectively utilize the stock space but also to reduce the stock amount converted from the work-in-process in the stock by improving the stagnation status in the stock. Hereinafter, preferred embodiments of the present invention will be described in detail with reference to the accompanying drawings.

-Schematic Configuration of Parts Inventory Management Device 10-FIG. 2 is a diagram showing a hardware configuration of the parts inventory management device 10 according to the embodiment of the present invention. For example, a personal computer or a general-purpose computer is applicable. Is. The bus 21 has a central processing unit (CPU, Cent
ral ProcessingUnit) 22, ROM 23, RAM 24,
A network interface 25, an input device 26, an output device 27 and an external storage device 28 are connected.

The CPU 22 performs data processing or calculation, controls various components connected via the bus 21, and functions as the above-mentioned inventory amount calculation means 13 and display control means 14. In the ROM 23, the CPU 22
The control procedure (computer program) is stored, and the CPU 22 executes the process by reading the computer program from the ROM 23.

Further, when the CPU 22 executes the processing of the computer program, the computer program is copied from the external storage device 28 to the RAM 24. The RAM 24 is used as a work memory for input / output and transmission / reception of data, and a temporary storage area of a program for controlling each component. In this way, the CPU 22
By executing the processing based on the program input from the ROM 23 and the RAM 24, the functions of the inventory amount calculating means 13 and the display controlling means 14 can be fulfilled.

The network interface 25 is an interface for connecting to an external communication network. The input device 26 is, for example, a keyboard and a mouse, and the user can input various instructions to the component inventory management device 10. The standard inventory amount, the delivery time zone, the number of deliveries, etc. are input by the operation input by the user. And functions as the standard inventory input means 11 and the delivery information input means 12. Further, in the present invention, the CPU 22 is, for example, the RO
The standard inventory quantity, delivery time zone, and delivery quantity of parts are calculated according to the predetermined conditions recorded in M23, etc., and the calculation result is once recorded in the RAM 24, and then the CPU 22 inputs each information again for processing. You can also In this case, RAM
An interface between the CPU 24 and the CPU 24 functions as the standard inventory input means 11 and the delivery information input means 12.

The output device 27 comprises a display or the like, and the display control means 1 by the CPU 22.
Various functions can be displayed by the function of 4.
The external storage device 28 is, for example, a hard disk storage device, a CD-ROM, or the like, and the stored contents are retained even when the power is turned off.

The embodiment of the present invention can be realized not only by the computer executing the program, but also by means for supplying the program to the computer, such as a CD-ROM or the like in which the program is recorded. A recording medium can also be applied to the embodiment of the present invention. As described above, the above program and recording medium are included in the scope of the present invention.

-Physical Distribution Coefficient-First, before explaining the operation of the embodiment of the present invention, a physical quantity unit is defined. In the following embodiments, the concept of "physical distribution coefficient" is introduced. The "physical distribution coefficient" is the ratio of parts to the pallet loading capacity when one part is loaded on one pallet. This physical distribution coefficient is a value obtained by the following equation 1. However, the loading capacity of one pallet is a constant value. Logistics coefficient = 1 / x (SNP) · y (number of boxes stacked) (Equation 1) where "SNP" indicates the number of parts in a single-part storage box, and "number of boxes stacked" is per pallet Indicates the number of loaded component storage boxes. This distribution coefficient is stored in advance in ROM for each part type.
23 and the like, the CPU 22 reads out the physical distribution coefficient from the ROM 23 as necessary and executes the processing.

<First Embodiment> Next, a first embodiment of the present invention will be described. FIG. 3 is a flowchart showing a flow of operations of the parts inventory management device 10 according to the first embodiment. When the CPU 22 calculates and inputs information indicating the standard inventory amount, the number of deliveries, and the delivery time zone (step S31), the information is recorded in the RAM 24 (step S32). In the present embodiment, for example, according to the number of products produced per day, that is, the number of parts used (if N parts are used for one product, the number of products produced per day × N). Since it is assumed that parts are delivered, and parts of equal quantity are delivered at each delivery, when the information indicating the number of deliveries is input, the quantity of parts delivered at one time is calculated. Further, as another method of setting the delivered amount, it is possible to individually set the delivered amount instead of calculating the delivered amount from the number of deliveries.

Next, the CPU 22 sets t to 0 (step S33), and adds 1 to t (step S3).
4). Next, the CPU 22 compares t (here, t = 1) with a predetermined value T (for example, 8), and determines whether t and T are equal values (step S35). For example, t indicates a time that elapses in units of 1 hour, and T indicates a working time per day (here, 8 hours). Where t
Is 1, the process proceeds from step S35 to step S36.

Next, the CPU 22 reads out the standard stock quantity from the RAM 24 and subtracts the quantity of parts used per unit time (step S36). The amount of material used per unit time is a value that can be calculated by the following equation 2,
It is set in the ROM 23 or the like in advance. For example, the daily production volume of products that use certain parts is 2301.
(Unit), the distribution coefficient of the part is 0.0156, the standard inventory is 18 (PL), and the working time is 8 (h), the production quantity of the product per hour is 2301 according to the following formula 2. (Unit) / 8 (h) ≈287.6 (Unit / h) ... (Formula 2) The number of used parts for the product is 1
In the case of the number of pieces (hereinafter, in the case of showing an example, the number of the relevant parts used for the relevant product is always assumed to be one), the quantity of the relevant parts used per hour is calculated by using the following formula 3 .6 (unit / h) × 0.0156 × 1≈4.5 (PL) (Equation 3) t = 1, that is, the physical quantity in inventory when one hour has passed from the start time is calculated by the following equation 4 as follows: Standard inventory 18 (PL) −4.5 (PL) = 13.5 (PL). 4)

Next, the CPU 22 reads the delivery time zone stored in the RAM 24, and the delivery time zone is t (=
It is determined whether it is equal to 1) (step S37). If the delivery time zone is equal to t, it is determined that there is delivery in this time zone (step S37 / YES), the delivery quantity is added to each inventory quantity in the time zone after that, and the t is further increased by 1 Is added (step S34). On the other hand,
If the delivery time is not equal to t, the CPU 22
Judges that there is no delivery in this time zone (step S37).
/ NO), the process proceeds to step S34, and 1 is further added to the t.

The above processing is repeated until it is determined in step S34 that t and T are equal. This gives 1
It is possible to calculate the amount of inventory that changes over time. The calculated inventory quantity in each time zone is recorded in the RAM 24.

Next, the above processing is executed until the values of t and T become equal to each other, and when the inventory quantity in each time zone is calculated, C
The PU 22 detects the maximum inventory amount from the inventory amount of each time zone recorded in the RAM 24 (step S39), and calculates the number of days of stagnant parts based on the maximum inventory amount (step S40). Here, the number of days of stagnation refers to the longest period from the delivery of a part to the introduction to the production line, and is an index representing the maximum amount of stagnation of the part in inventory in days.

At this time, the daily usage quantity of the part is 3
Since it is 264 (units), when the quantity used is converted into physical quantity, the following formula 5 gives 3264 (units) × 0.0156≈51.0 (PL) (Formula 5), which is 51. A quantity of 0 (PL) is used. Then, in this case, the maximum inventory amount of the part is 23.
Since it is 6 (PL), the number of stagnation days of the quantity is calculated by the following formula 6
Thus, 23.6 (PL) /51.0 (PL) ≈0.50 ... (Equation 6) is obtained.

Next, it is determined whether the number of days of stagnation calculated in step S40 is within a first predetermined value (step S41). An appropriate upper limit quantity is set to this first predetermined value in order to prevent excessive delivery of parts into the inventory, and when the number of days of stagnation exceeds the first predetermined value (step S41 / NO). In the step S31, there is a time zone in which the standard inventory amount, the number of deliveries, and the delivery time period input this time are excessive inventory amounts. Therefore, a screen for re-entering the standard inventory amount, the number of deliveries, and the delivery time period is displayed. The display prompts (step S42). On the other hand, when the number of days of stagnation is within the first predetermined value (step S41 / YES), the process ends. The first predetermined value is the ROM 23 or RA.
It is stored in advance in a recording medium such as M24, or is input from the input device by the user when this processing is started.

Further, in the present embodiment, after the number of days of stagnation in step S41 is determined to be within the first predetermined value, the lower limit quantity representing the possibility of running out of stock may be set as the second predetermined value. it can. That is, in the determination of step S41, the number of stagnation days falls within the first predetermined value, and after avoiding the fear of becoming an excessive inventory quantity, the number of stagnation days is further compared with the second predetermined value. Then, if the number of days of stagnation is determined to be equal to or greater than the second predetermined value, there is no risk of running out of stock, and the production line can be operated in a stable state.

On the other hand, when it is determined that the number of days of stagnation is less than the second predetermined value, it is considered that there is a possibility that the standard inventory amount, the number of deliveries, and the delivery time period input this time may be out of stock, and each of those information Prompt re-input by screen display. Note that the second predetermined value is the same as the first predetermined value in the ROM 2
3 or a recording medium such as the RAM 24 in advance, or is input from the input device by the user when this process is started.

The re-input of the standard inventory amount, the number of deliveries, and the delivery time zone is performed by prompting the user to re-enter information on the output device as described above and causing the user to re-input from the input device. The CPU 22 may be the ROM 23 or the R
Another numerical value corresponding to each piece of information may be read from the recording medium such as the AM 24 and the processing from step S31 may be automatically executed again. It is also possible to repeat the same re-input process a predetermined number of times, specify the reference inventory amount, the number of deliveries, and the delivery time zone in which the maximum inventory amount is the lowest, and calculate the inventory status based on these pieces of information. This makes it possible to formulate an inventory management plan that provides the optimal number of days of stagnation.

-Method of Determining Standard Inventory Quantity, Number of Delivery and Delivery Time Zone-Next, a method of determining the standard inventory amount, delivery frequency and delivery time zone according to this embodiment will be described. The standard inventory amount, the number of deliveries, and the delivery time zone are determined by constraint conditions such as the efficiency of loading parts such as trucks that transport parts, the number of products produced per day, and the deliverable time zone of the parts supplier.

The constraint conditions concerning the component loading efficiency and the deliverable time zone are determined by the agreement with the component supplier,
The constraint condition related to the number of products produced is determined by the required number of production lines. The user may input and specify an appropriate standard inventory amount, the number of deliveries, and a delivery time zone based on these constraint conditions, or the CPU 22 may determine an appropriate standard inventory amount, the number of deliveries, and delivery based on these constraint conditions. The time zone may be automatically calculated.

Here, as an example of a suitable method for determining the standard stock quantity, if the number of parts deliveries is expected to be large as long as the constraint condition relating to the deliverable time zone allows, the stock quantity may be out of stock even if the standard stock quantity is set low. There is no fear, the maximum quantity can be lowered accordingly, and the number of days of stagnation can be reduced.

Further, as an example of a suitable method of determining the number of deliveries, if the load capacity of the truck is expected to be high as long as the constraint condition relating to the loading efficiency of parts such as trucks allows, the number of deliveries can be set to a small value for a period of time. It is possible to avoid the concern that trucks will be crowded and the truck yard will run short.

As for the delivery time zone, the delivery time zone is determined within the range permitted by the constraints of the deliverable time zone. After the delivery time period is set, the parts inventory management device 10 will not deliver the delivery time until a large number of trucks are temporarily crowded in the truck yard as described above. Repeat the band setting. At this time,
The component inventory management device 10 may be configured to prompt the user to re-enter the delivery time zone by a screen display and to make the user reset the delivery time when a predetermined number or more of delivery instructions are set in a certain time zone. . When the standard inventory quantity, the number of deliveries and the delivery time zone are determined as described above, the inventory quantity in each time zone is calculated according to the process shown in the flowchart of FIG.

-Specific Example of Inventory Adjustment- FIGS. 4A to 4C are graphs in which the horizontal axis represents the time zone and the vertical axis represents the inventory quantity in each time zone. In FIG. 4A, the standard inventory amount is 20 (PL), the number of deliveries is 1, and the delivery time zone is 1.
The change of the stock amount in the case of 7:00 to 18:00 is shown. The number of parts stored in the inventory at the start of work (here, 8:00) is 2.5 (PL) per unit time (2 hours) and gradually decreases. Since the physical quantity of 20 (PL) is delivered during the time period from 17:00 to 18:00, 20 (PL) is added to the stock amount of 10 (PL) at 17:00.

However, in the example of FIG. 4 (a), depending on the stock capacity, the stock quantity 30 (PL) from 17:00 to 18:00 is treated as a large quantity, which may result in inefficient stock utilization. In such a case, it is preferable that the stock amount from 17:00 to 18:00 exceeds the first predetermined value and that the standard stock amount, the number of deliveries, and the delivery time zone are prompted to be re-input.

In FIG. 4B, the standard stock amount is 10 (P
L), the number of deliveries is one, and the transition of the inventory quantity when the delivery time zone is 17:00 to 18:00 is shown. The number of parts stored in inventory at the start of work decreases by 2.5 (PL) used per unit time, and the quantity of 20 (PL) is delivered when the time period from 17:00 to 18:00, so at 17:00 20 (PL) is added to the stock quantity 0 (PL) at the time.

However, in the example of FIG. 4B, from 17:00 to 18
There is a fear that the product will be out of stock due to a delay in the delivery time or the like. Therefore, the previous time zone (16
It is preferable to display that the standard inventory amount, the number of deliveries, and the delivery time zone are re-entered, assuming that the inventory amount 2.5 (PL) from 17:00 to 17:00) is below the second predetermined value.

In FIG. 4C, the standard stock amount is 20 (P
L), the number of deliveries is two, and the transition of the inventory amount when the delivery time zone is 17:00 and 26:00 is shown. The number of parts stored in stock at the start of work is 2.5 (P
L) is used and gradually decreases, and when the delivery time zone is 17:00, parts with a physical quantity of 10 (PL) are delivered.
10 (PL) is added to the stock amount 10 (PL) at the time. Also, when the delivery time is 26:00, the quantity is 10 (P
Since the component L) is further delivered, the delivered amount 10 (PL) is added to the inventory amount 10 (PL) at 26:00.

In the example of FIG. 4 (c), FIG. 4 (a), (b)
As in the example above, there is no sudden increase in the inventory amount in a certain time zone, and there is no fear of shortages in a certain time zone, so the number of days of stagnation can be reduced, the inventory space can be effectively used, and the production line can be stabilized. It becomes possible to operate.

-Stagnation Table- Next, a display example of the stagnation table will be described. Figure 5
Is the number of products produced per day, each shift (1S, 2S,
It is the figure which showed the production number allocated to 3S) and the production number of each shift per hour. "Choku" is a unit that divides one day, for example, from 8:00 to 17:00
S), 2 shifts (2S) from 17:00 to 24:00, and 3 shifts (3S) from 24:00 to the following 8:00. Figure 6
FIG. 8 is a diagram showing a stagnation table displayed on the output device 27 after the inventory quantity and the stagnation time of all time zones are calculated. In the example of FIG. 6, "1.A parts" to "10.J parts"
Is a managed component.

The stagnation table will be described by taking "1: A part" as an example. Since the SNP and the number of boxes of the part are 40 and 20, respectively, the physical distribution coefficient of the part is calculated by using the above equation 1. Is 0.0013. In addition, assuming that the component is assigned to one shift (1S), the usage quantity of the component per hour is 1350 (units). By multiplying this value by the distribution coefficient 0.0013, the amount of used material per hour is calculated. Therefore, when the amount of used material per hour is calculated, it becomes 1.755 (PL) (indicated as 1.7 in the figure), and this amount of material is changed from the standard inventory amount of 7.5 (PL) every hour. Decrease.

Further, in this example, the delivery of parts per day is divided into eight, that is, the number of times of parts delivery is eight, and individual delivery amounts are set for each part delivery. The stock amount from 8:00 to 9:00 is 5.8 (PL), which is a value obtained by subtracting 1.7 (PL) from the standard stock amount 7.5 (PL), and is displayed from 9:00 to 10
The inventory quantity at that time is 4.1 (PL), which is a value obtained by subtracting 1.7 (PL) from 5.8 (PL).

The stock quantity from 10:00 to 11:00 is obtained by subtracting 1.7 (PL) from the quantity, and the delivered quantity is 4.0 (PL).
A value obtained by adding 6.4 (PL) is displayed. 11: 00 ~
The stock amount at 12:00 is the stock amount from 10:00 to 11:00.
Subtracted 1.7 (PL) from 4 (PL) to deliver parts 2.
A value obtained by adding 0 (PL), 6.7 (PL), is displayed. Since 11:00 to 12:00 is a work rest period, 12
6.7 (PL), which is the stock amount from 13:00 to 13:00, is 1
It is treated as the stock amount from 1 o'clock to 12 o'clock.

In the afternoon work hours, the inventory quantity from 13:00 to 14:00 is the inventory quantity from 11:00 to 12:00, which is 6.7 (P).
Value obtained by subtracting 1.7 (PL) from L), 5.0 (PL)
Is displayed, and the stock quantity from 14:00 to 15:00 is from 13:00 to 14
7.3 (PL), which is a value obtained by subtracting 1.7 (PL) from 5.0 (PL) which is the stock amount at that time and adding the delivered amount of 4.0 (PL), is displayed.

The stock quantity from 15:00 to 16:00 is from 14:00 to 15
7.6 (PL), which is a value obtained by subtracting 1.7 (PL) from the inventory amount of 7.3 (PL) at that time and adding the delivered amount of 4.0 (PL), is displayed. The inventory quantity from 16:00 to 17:00 is the inventory quantity from 15:00 to 16:00 9.6 (PL)
A value obtained by subtracting 1.7 (PL) from is displayed as 7.9 (PL).

After 17:00, a production amount of 1050 units per hour of 2 shifts (2S) × a quantity coefficient of 0.0013≈an amount of material used per hour of 1.4 (PL) is used. 17-18
The stock amount at the time is 7.9 which is the stock amount from 16:00 to 17:00.
A value obtained by subtracting 1.4 (PL) from (PL), 6.5.
(PL) is displayed. Inventory quantity from 18:00 to 19:00 is 1
1.4 from 6.5 (PL), which is the inventory quantity from 7:00 to 18:00
A value obtained by subtracting (PL) and adding the delivered quantity 2.0 (PL) to that value, 7.1 (PL), is displayed.

The stock quantity from 19:00 to 20:00 is from 18:00 to 19
9.7 (PL), which is the value obtained by subtracting 1.4 (PL) from the stock amount of 7.1 (PL) at that time and adding the delivered amount of 4.0 (PL), is displayed. The inventory amount from 20:00 to 21:00 is the inventory amount from 19:00 to 20:00, which is 9.7 (PL).
1.4 (PL) is subtracted from the value, and the delivered amount is 3.0
A value obtained by adding (PL), 11.3 (PL) is displayed. During the work rest period from 21:00 to 22:00, 20:00 to 2
The same numerical value as the stock amount at 1 o'clock is displayed.

The stock amount from 22:00 to 23:00 is from 20:00 to 21
1.4 (PL) to 11.3 (PL)
Value obtained by subtracting and adding 3.0 (PL) of delivered quantity, 1
2.9 (PL) is displayed. As the inventory amount from 23:00 to 0:00 the next day, 11.5 (PL) is displayed, which is a value obtained by subtracting 1.4 (PL) from the inventory amount of 12:00 (PL) from 22:00 to 23:00. The stock amount from 23:00 to 0:00 the next day is 0 from 23:00 to the next day.
11.5 (PL) to 1.4 (PL), which is the stock amount at the time
The value obtained by subtracting 10.1 (PL) is displayed. As described above, in the present embodiment, since the physical quantity calculated in each time zone can be displayed on the screen, it is possible to grasp the fluctuation of the daily stock amount in detail.

As another embodiment, the stock amount in the time zone from 8:00 to 9:00 is obtained by subtracting 1.7 (PL) from the reference stock amount 7.5 (PL), and the following steps are performed. By calculating 1.7 (PL) or 1.4 (PL) from the time zone, the inventory quantity for each time zone is calculated, and in the time zone when parts are delivered, the delivery quantity is added. Produces similar results. Further, in the present embodiment, the fluctuation of the stock amount is calculated on a daily basis, but the present invention is not limited to this, and the stock amount can be calculated on a unit of an arbitrary period such as a week unit. .

Among the physical quantities calculated in this way for each time period, the maximum physical quantity is the stock quantity of 12.9 between 22:00 and 23:00.
Since it is (PL), the numerical value is displayed in 501 in the figure. On the other hand, the number of products manufactured on all production lines is 1920
Since it is 0 (units), the daily quantity PL number of the part is approximately 24.0 (PL) by the same calculation as the above-mentioned equation 5. Therefore, the number of days of stagnation is calculated as 0.54 by the same calculation as Equation 6
And the numerical value is displayed in 502 in the figure.

Further, it is possible to color-code the item indicating the delivered quantity so as to distinguish the supplier of each component. In this case, when the user sets the parts supplier together with the parts delivery time zone, the color display corresponding to the parts supplier is performed, and the parts inventory management device 10 determines from the constraint condition related to the parts delivery time zone. When the parts delivery time zone is automatically set, the color display corresponding to the constraint condition related to the parts delivery time zone is displayed. As a result, the user can grasp at a glance from which parts supplier the parts are delivered.

Furthermore, according to the present invention, when the delivery time zone and delivery quantity of a part are determined by the parts supplier, the parts inventory management device 10 delivers the parts to the communication terminal of the corresponding parts supplier via a communication line such as the Internet. It is also possible to automatically notify the time zone and the delivered amount.

<Second Embodiment> In the first embodiment, the reference stock quantity is automatically set based on the constraint conditions such as the parts loading efficiency of the truck, the number of products produced and the deliverable time zone.
Although the mechanism for determining the number of deliveries and the delivery time zone has been described, as the second embodiment of the present invention, it is also possible to execute the same processing by using general-purpose spreadsheet software “Excel”. . That is, step S3 of FIG.
In 1, the user uses the input device 26 to input the reference inventory, the delivery time zone, the number of deliveries (or the delivered amount), and the like,
Subsequent processing can be realized by using the "Excel" function.

First, the CPU 22 cooperates with the program loaded in the RAM 24 to display a predetermined area (cell) on the screen of the output device 27 for prompting the user to input the reference inventory quantity.
Is displayed. When the user inputs the standard stock amount in that area, the input standard stock is stored in the RAM 24. In this way, the CPU 22 that operates according to the program and the CPU 22 are controlled to prompt the user for input, and the input value is RA.
The program stored in M24 serves as an input unit that functions to input together.

FIG. 11 is a diagram showing the structure of the above program. The program is an input control module (prompting the user to input various data, and inputting the data to the CPU
22 for storing in a memory in a memory), an inventory amount calculating module (a module for calculating an inventory amount by the CPU 22 based on the data stored in the memory), a stagnation day calculating module (a stagnation day for the CPU 22
And a display control module (a module that causes the CPU 22 to display various data on the display screen).

The parts inventory management device 10 (that is, the CPU
22 and the program. Same below. ) Calculates the stock amount for each time period based on the standard stock amount and the daily use amount.
Next, the user inputs the parts delivery time zone and the quantity of delivered parts by referring to the calculated inventory quantity in each time zone,
The parts inventory management device 10 adds the parts delivered quantity to the input quantity in the time zone and displays the added quantity. At the same time, the parts inventory management device 10 also calculates the number of days of stagnation and displays it on the output device 27. Figure 6 shows the calculated amount of stock and the number of days of stagnation.
It is displayed on the screen of the output device 27 in the same manner as the form shown in FIG. When the user is not satisfied with the calculated inventory amount and the number of days of stagnation, the user will re-enter the standard inventory and the like.

The input means (the CPU 22 and the input control module in the program) will be described in detail below. Figure 9
Is a window displayed on the same screen as the form when prompting the user to input the standard inventory amount. 901 is
This is a field for displaying a part name. Reference numeral 902 is an area for allowing the user to input the standard inventory amount. Reference numeral 903 denotes a window switching button for inputting a standard inventory amount of another component. When the window switch button 903 is clicked, the window switches to a window for inputting the standard stock amount of another component. 904 is a button for confirming the input standard inventory amount. A button 905 is used to cancel the input work. The input standard inventory amount is stored in the RAM 24 as described above.

FIG. 10 shows a window displayed on the same screen as the form when prompting the user to input the delivery amount. Reference numeral 1001 is a field for displaying a component name. 1002
Indicates the delivery time zone to be delivered. The user can select the delivery time zone from the pull-down menu. 1003 is an area for inputting a delivery amount in the time zone 1002. 1004 is a field for selecting a supplier. The user can select one supplier by radio button. 1005 is a button for advancing or retracting the delivery time zone. For example, if the delivery time zone is "10: 00-11: 00", clicking "Previous" will cause the delivery time zone to move backward by one and become "9: 00-10: 00". If you click "Next", the delivery time will advance by one and "1
1: 00-12: 00 ".

Reference numeral 1006 is a window switching button for inputting the delivery amount of another part. When the window switching button 1006 is clicked, the window switches to a window for inputting the standard stock amount of another component. 1007
Is a button for confirming the input delivery amount.
A button 1008 is used to cancel the input work. The input standard inventory amount is stored in the RAM 24 in association with the delivery time zone displayed at the time of input.

By providing the input window as shown in FIGS. 9 and 10, the input operation becomes easy for an inexperienced user to understand, and input errors are reduced. Further, the user can directly input the reference inventory amount and the delivery time zone / delivery amount into each area (cell) of the form in FIG. 6 (without using the input window). That is, the standard stock amount can be input to the area 503. Also,
It is possible to input the delivery amount corresponding to the delivery time zone in the line 504. It should be noted that the time period when there is no delivery is blank.

Further, the user can use the input device 26 to specify the color corresponding to the parts supplier and the item in which the target quantity of delivered parts is displayed, so that the parts supplier can be color-coded. This allows the user to (re) enter the standard inventory, the parts delivery time zone, and the quantity of delivered parts.
It is convenient because you can see at a glance which supplier is delivering at which time.

Further, the inventor of the present invention has been
Inventory at 3 locations (A inventory, B inventory, C inventory) until March, 2013
The transition of the number of stagnation days was investigated. FIG. 7 is a graph showing the survey results. Around 1998, the inventory was adjusted by the conventional "in-process turnover period",
March 2001 shows the results of a survey conducted when inventory adjustments were carried out with the introduction of the new concept of "days in stagnation." As described above, the present invention introduces a new concept of “stagnation days” and enables inventory adjustment to reduce the peak value of the in-stock amount, so the reduction of the peak value acts on the reduction of the stagnant days, Since 1999, inventory utilization has been gradually made effective.

[0069]

As is apparent from the above description, according to the present invention, the stock space fluctuation status is displayed based on the input basic stock quantity, delivery time, and delivery quantity, so that the stock space can be saved. It will be possible to make effective use of it and reduce the amount of inventory associated therewith, and by improving the utilization of inventory space, it will be possible to streamline distribution.

Further, according to the present invention, when a stock quantity exceeding or falling below a predetermined threshold value is detected from the fluctuation of the stock quantity, the basic stock quantity, the delivery time zone and the delivery quantity are prompted to be re-input, so that an unexpected The fear that parts will be out of stock due to circumstances,
It is possible to avoid excessive delivery of parts for one period.

[Brief description of drawings]

FIG. 1 is a block diagram showing a main functional configuration of a parts inventory management device of the present invention.

FIG. 2 is a diagram showing a hardware configuration of a parts inventory management device according to an embodiment of the present invention.

FIG. 3 is a flowchart showing an operation flow of the parts inventory management device in the first embodiment of the present invention.

FIG. 4 is a graph showing the time axis on the horizontal axis and the inventory quantity of each time axis on the vertical axis.

[Figure 5] Number of products produced per day, each shift (1S, 2
It is the figure which showed the production number allocated to S, 3S) and the production number per hour of each production line.

FIG. 6 is a diagram showing a stagnation table displayed after the inventory amount and the stagnation time of all time zones are calculated.

FIG. 7 is a graph showing the results of investigation of changes in the number of days of stagnation.

FIG. 8 is a diagram showing a relationship between an amount of money and an amount of goods for a product of parts.

FIG. 9 is a diagram showing a window displayed on the same screen as the form when prompting the user to input a reference inventory amount.

FIG. 10 is a diagram showing a window displayed on the same screen as the form when prompting the user to input a delivery amount.

FIG. 11 is a block diagram illustrating a computer (CP) process of the second embodiment.
It is the figure which showed the structure of the program for making U) execute.

[Explanation of symbols]

10: Parts inventory management device 11: Standard inventory input means 12: Payment information input means 13: Inventory amount calculation means 131: Subtraction processing unit 132: Addition processing unit 14: Display control means 20: Output device 21: Bus 22: CPU 23: ROM 24: RAM 25: Network interface 26: Input device 27: Output device 28: External storage device

Continued front page    (72) Inventor Kazumasa Harano             1280 Kunitomocho, Nagahama City, Shiga Prefecture             Within the corporation (72) Inventor Katsuyuki Tanji             1280 Kunitomocho, Nagahama City, Shiga Prefecture             Within the corporation F term (reference) 3C100 AA45 BB05 BB36

Claims (14)

[Claims] 1. A standard stock input means for inputting a standard stock quantity which is an initial value of a stock quantity, a delivery information input means for inputting a delivery time zone and a quantity of delivery of parts, and the standard stock input means. An inventory quantity calculating means for calculating a fluctuation status of the inventory quantity from the reference inventory quantity based on the reference inventory quantity, the delivery time zone and the delivery quantity input by the delivery information input means, and the inventory A parts inventory management device, comprising: display control means for displaying on the display means the fluctuation status of the inventory quantity calculated by the quantity calculation means. 2. The inventory amount calculating means subtracts a predetermined amount of inventory from the reference inventory amount for the first time and sequentially subtracts a certain amount of inventory to calculate an inventory amount at a predetermined time; 2. The parts inventory according to claim 1, wherein a variation status of the inventory amount from the reference inventory amount is calculated by executing an addition process of adding the delivery amount for each inventory amount at each predetermined time. Management device. 3. A maximum inventory detecting unit for detecting a maximum inventory amount from the fluctuation state of the inventory amount calculated by the inventory amount calculating unit, wherein the reference inventory input unit is detected by the maximum inventory detecting unit. 2. The parts inventory management device according to claim 1, wherein the reference inventory quantity that minimizes the maximum inventory quantity is input. 4. A maximum inventory detecting unit for detecting a maximum inventory amount from the fluctuation state of the inventory amount calculated by the inventory amount calculating unit, wherein the delivery information input unit is detected by the maximum inventory detecting unit. The parts inventory management device according to claim 1, wherein the delivery time zone and the delivery amount that minimize the maximum inventory amount are input. 5. A total usage amount setting means for setting a total usage amount of the parts in a predetermined period obtained by accumulating the predetermined times, and a total usage amount of the parts set by the total usage amount setting means. And a stagnation period calculating means for calculating a stagnation period of the parts in the maximum inventory amount in the inventory based on the maximum inventory amount, and the display control means is calculated by the stagnation period calculating means. The parts inventory management device according to claim 3 or 4, wherein the stagnation period is displayed on the display means. 6. A lower inventory quantity detecting means for detecting an inventory quantity that is lower than a first predetermined inventory quantity based on the fluctuation status of the inventory quantity calculated by the inventory quantity calculating means, and the reference inventory input means, When the lower limit inventory amount detecting unit detects an inventory amount that is less than the predetermined inventory amount in the fluctuation state of the inventory amount, a standard inventory amount is newly input, and the inventory amount calculating unit uses the new reference inventory amount. 2. The parts inventory management device according to claim 1, wherein the fluctuation status of the stock quantity from the standard stock quantity is calculated again based on the quantity. 7. The lower limit inventory quantity detecting means for detecting an inventory quantity that is lower than a first predetermined inventory quantity from the fluctuation status of the inventory quantity calculated by the inventory quantity calculating means, and the delivery information input means, When the lower limit inventory amount detecting unit detects an inventory amount that is less than the first predetermined inventory amount in the fluctuation state of the inventory amount, a delivery time period and a delivery amount are newly input, and the inventory amount calculating unit, 2. The parts inventory management device according to claim 1, wherein the fluctuation status of the stock quantity from the reference stock quantity is recalculated based on the respective information newly input by the delivery information input means. 8. An upper limit inventory quantity detecting means for detecting an inventory quantity that exceeds a second predetermined inventory quantity from the fluctuation status of the inventory quantity calculated by the inventory quantity calculating means, and the reference inventory input means, When the upper limit inventory amount detecting unit detects the inventory amount that exceeds the second predetermined inventory amount in the fluctuation state of the inventory amount, the reference inventory amount is newly input, and the inventory amount calculating unit sets the new inventory amount to the new inventory amount. 2. The parts inventory management device according to claim 1, wherein the fluctuation status of the stock quantity from the standard stock quantity is calculated again based on the standard stock quantity. 9. An upper limit inventory quantity detecting means for detecting an inventory quantity that exceeds a second predetermined inventory quantity from the fluctuation situation of the inventory quantity calculated by the inventory quantity calculating means, and the delivery information input means, When the upper limit inventory amount detecting means detects an inventory amount exceeding the second predetermined inventory amount in the fluctuation state of the inventory amount, the delivery time zone and the delivery amount are newly input, and the inventory amount calculating means, 2. The parts inventory management device according to claim 1, wherein the fluctuation status of the stock quantity from the reference stock quantity is recalculated based on the respective information newly input by the delivery information input means. 10. The notification means for notifying an external device of at least one of the delivery time zone and the delivery amount input by the delivery information input means. The parts inventory management device according to item 1. 11. The display control means displays the inventory quantity calculated by the inventory quantity calculation means at each of the predetermined times in a table format, according to any one of claims 1 to 9. Parts inventory management device. 12. A step of controlling storage of a reference inventory amount, which is an initial value of an input inventory amount, a delivery time zone of a component, and a delivery amount of a component in a memory, the storage being stored in the memory. A step of calculating a fluctuation situation of the stock quantity from the standard stock quantity based on the standard stock quantity, the delivery time zone and the delivery quantity; and a fluctuation status of the calculated stock quantity on the display means. And a step of displaying the parts inventory management method. 13. A step of controlling storage of a standard inventory amount, which is an initial value of an input inventory amount, a delivery time zone of a component, and a delivery amount of a component in a memory, the storage being stored in the memory. A step of calculating a fluctuation situation of the stock quantity from the standard stock quantity based on the standard stock quantity, the delivery time zone and the delivery quantity; and a fluctuation status of the calculated stock quantity on the display means. A recording medium recording a program for causing a computer to execute the displaying step. 14. A step of controlling storage of a reference inventory amount, which is an initial value of an input inventory amount, a delivery time zone of a component, and a delivery amount of a component in a memory, and the step of controlling the storage in the memory. A step of calculating a fluctuation situation of the stock quantity from the standard stock quantity based on the standard stock quantity, the delivery time zone and the delivery quantity; and a fluctuation status of the calculated stock quantity on the display means. A program that causes a computer to execute the steps for displaying.