JP2000168916A - Location control device and method and record medium thereof - Google Patents

Abstract

PROBLEM TO BE SOLVED: To utilize the keeping place with a limited space effectively by utilizing a flag table from a standard storage amount, giving a holding shape flag per products and making the product in which the change state of the holding shape flag is matched with a warning list to the product of a keeping place change subject. SOLUTION: A change subject extraction part 13 utilizes a flag table from a standard storage amount and gives a holding shape flag per products and the change state of the holding shape flag lists up the product matching with the warning list as the product of a keeping place change subject. A replacement list preparation part 14 makes the product which has a negative correlation on the change state of the holding shape flag of the product of the keeping place change subject listed up by the change subject extraction part 13 to the team of the product (name of article) of the replacement subject of the keeping place and the location replacement list including this is outputted. The controller of a physical distribution center changes the keeping place of the product based on the location replacement list or location moving examination list.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] 1. Field of the Invention [0002] The present invention relates to a location management apparatus and method for managing a stock location of a product (commodity) in a distribution center or the like.

[0002]

2. Description of the Related Art Generally, the flow of industrial products goes from a producer such as a manufacturer to a wholesaler, and from there to a wholesaler if necessary, to a retailer. In addition, wholesalers stock products that do not run out of stock so that they can be supplied to dealers at any time. In a distribution center, addresses of storage locations are usually set for all products, and location management is performed. On the other hand, among the products whose shipping amount has changed, the reference stock amount also changes, and the storage space up to now may not be sufficient or may be too large. Therefore, it is necessary to change the location and move to a storage location appropriate for the stock amount. Conventionally, the location was changed based on the experience of the person in charge of the distribution center.

[0003]

However, in such location management that is left to the discretion of the person in charge of the distribution center, an optimized arrangement of products is not always selected. In addition, in the conventional inventory management method, the storage capacity of the entire distribution center is not considered so much, and the quantity required for each product is ordered based on demand forecast. Could not do.

The present invention has been made in view of such circumstances, and issues a location change instruction in accordance with the change of the standard stock amount and the storage capacity, and has a stock that is suitable for shipment and has a limited space. An object of the present invention is to provide a location management device that can be effectively used.

[0005]

In order to achieve the above object, a location management apparatus according to the present invention comprises: a flag table storing a holding mode flag indicating a holding mode for each storage location; a change state of the holding mode flag; Storage means for storing flag data including a warning list indicating the relationship of a location change target, and shipping data containing the shipping status of each product, and creating a standard stock for calculating a standard stock amount for each product from the shipping data Means, and a holding form flag is assigned to each product using the flag table based on the reference stock amount created by the reference stock creating means, and a product whose change state of the holding form flag matches the warning list is stored. And a change target extracting means for setting a product to be changed in location. Therefore, according to the present invention, it is possible to automatically extract a product whose storage location is to be changed.

Further, the storage means further stores standard storage amount data including holding form information for each storage location, and the location management device creates the flag table from the standard storage amount data, Further comprising a flag creating means for creating the warning list in which a change in the holding form flag, which is changed from the combination of the changing states of the holding form flag set in the above, and the change state of the holding form flag whose change is stable is set as a storage location change target. It is characterized by having. Therefore, according to the present invention, it is possible to automatically extract a change state that is a storage location change target from the change states of the holding mode flag.

[0007] The location management device may set a storage location change target product extracted by the change target extraction means, which has a negative correlation with the change state of the holding form flag of the storage location change target product. It is characterized by further comprising a replacement list creating means. Therefore, according to the present invention, a product that is a replacement candidate can be automatically obtained. This is particularly effective when there are a large number of replacement candidates.

[0008] A location management method using a computer according to the present invention is a location management method for a location management apparatus, wherein a flag table storing a holding mode flag indicating a holding mode for each storage location and a change state of the holding mode flag are stored. Flag data including a warning list indicating the relationship of the storage location change target, a procedure for storing shipping data containing the shipping status of each product, a procedure for calculating the reference stock amount of each product from the shipping data, Using the flag table from the reference stock amount to assign a holding form flag for each product, and setting a product whose change state of the holding form flag coincides with the warning list as a product whose storage location is to be changed. It is characterized by the following.

According to a fifth aspect of the present invention, there is provided a recording medium in which a location management program is recorded in a location management device, wherein a flag table storing a retention mode flag indicating a retention mode for each storage location and a change state of the retention mode flag. And a procedure for storing flag data including a warning list indicating the relationship between storage objects and storage locations, and a procedure for storing shipment data containing the shipment status of each product, and a procedure for calculating a standard stock amount of each product from the shipment data. Using the flag table to assign a holding form flag to each product from the reference stock amount, and setting a product whose change state of the holding form flag matches the warning list as a product whose storage location is to be changed. This is a computer-readable recording medium that stores a location management program to be executed by a computer. In this specification, no distinction is made between products and commodities.

[0010]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, a location management apparatus according to an embodiment of the present invention will be described with reference to the drawings. FIG. 1 is a block diagram showing a configuration of an embodiment of a location management device.

The location management device 1 includes a processing unit 2 and a storage unit 3 described below. The storage unit 3 stores data including standard storage amount data 4, master data 5, shipping data 6, reference stock data 7, flag data 8, and location management data 9.

The standard storage amount data 4 is data relating to storage capacity for each product in each storage location, and is set in advance according to criteria separately determined according to the size and equipment of the storage location. Further, the standard storage amount data 4 further includes data relating to the storage mode for each storage location. FIG. 3 shows an example of a layout of a storage location in a distribution center. In this example, the flat storage space P1, the pallet rack P2, the loose shelves (inclined racks) P3 to 5, and the loose shelves (flat shelves)
P6 and P7. In the flat storage space P1, a pallet on which a case unit of load is placed or a cargo container on which a piece (rose) unit of load is placed is placed.
The pallet rack P2 stores a pallet on which a case-by-case load is placed. The bulk shelves (inclined racks) P3 to P5 or the bulk shelves (flat shelves) P6 and P7 store and store loads in pieces (bulks). The standard storage amount data 4 includes data on storage capacity at each storage location and holding form information indicating the distinction between storage locations.

The master data 5 is data including a unit price for each product. The shipping data 6 is data including a shipping amount and a shipping date for each product.

The reference stock data 7 is data including a reference stock amount for each product. The reference stock amount (maximum stock) can be obtained by multiplying the average shipment amount per day of shipment (actual shipment amount) by the number of holding days for each rank. FIG. 6 shows an example of the reference stock data 7. In this example, "Product name", "Quantity" (number of products / package), "Shipment value rank" ranked according to the shipping amount, "Shipment date rank" ranked according to the shipping days, Maximum inventory The reference stock quantity, which is the quantity, the order point, which is the basis for ordering, the reference stock quantity, which is the maximum stock quantity of piece stock stored in pieces, and the replenishment of piece stock. It consists of fields of "supplement points (bulk shelves)" as a reference for performing.

Here, the shipping amount ranking and the shipping days ranking will be described with reference to FIG. 12, which is an example. In this example, each is divided into five stages. In the shipment value ranking, the square root of the product shipment value is used as a reference (see the VE coefficient curve in FIG. 11), and
Up to% rank "S", then 20% -40%
Is ranked “A”, the next highest amount of money 40% to 60% is ranked “B”, the next highest amount of money 60% to 80% is ranked “C”, and the others are ranked “D”.

The shipping amount ranking shown in FIG. 12 is set based on the ABC analysis shown in FIG. Here, FIG. 11 will be described. In this figure, the horizontal axis represents the quantity of commodity items, and the vertical axis represents the cumulative amount of shipment for a predetermined period. Approximately 6% of the highest shipping value of merchandise items, and approximately 6% of the total
8%, and the highest 14% of the total amount accounts for about 82% of the total shipping amount for a predetermined period. Therefore, based on the square root of the shipment value of the product items,
It is divided into five stages of "S" to "D".

In order to classify each product (article name) on the basis of the shipment amount instead of the shipment amount, the inventory ratio and the ordering unit are not uniformly set for all the products (article names), but the sales are reduced. This is to add a height to the standard. In order to classify products (product names) according to the shipping amount, the square root is used as the basis.
For example, the product name belonging to the previous rank “S” may belong to the rank “A” or the rank “B” due to a slight change in shipment, and the management may be troublesome due to excessive fluctuation, which is avoided. That's why.

In the shipping days ranking, items having a shipping days exceeding 80% of business days (shipping almost every day) are ranked "1", and items having a shipping days occupying 50% to 80% of business days (from 2 to 2 weeks). (3 shipments) rank "2", shipping days occupy 20-50% of business days (shipping once or twice a week) rank "3", shipping days occupy 5-20% of business days (Shipping once a month to once a week) is classified into rank "4", and shipments occupying less than 5% of business days (shipping once a month or less) are classified into rank "5".

Next, the flag data 8 includes a flag table containing a holding mode flag indicating a holding mode for each storage location,
A warning list indicating the relationship between the change state of the holding mode flag and the storage location change target is included.

FIG. 4 shows an example of the flag table. For example, the flag “CK” indicates that the reference stock amount is 51 per case.
If the number of cases is equal to or more than the case, it indicates that the product is stored in a flat place (pallet unit). Container). In this example, the case locations are flat (pallet units), pallet racks (pallet units), pallet racks (mixed (large: small number of cases, large number of cases)), pallet racks (mixed (small: type) But the number of cases is small))). The piece locations are flat (cargo containers), inclined racks (large: many frontage racks), inclined racks (small: few frontage racks), flat shelves (large: many frontage racks), Flat shelf (small: small number of racks)
Have a distinction.

FIG. 5 shows an example of the warning list (only piece stock) in the flag data 8. In this example, it is composed of a combination of flags for three weeks and a warning sign (（) corresponding to this combination. Here, a pattern in which the same flag continues for two consecutive weeks (for example, PK in the first week, P in the second week)
L, a case where the third week becomes PL, etc.) is set as a warning target (a storage location change target). Note that the warning list also includes a similar list regarding case stock.

The location management data 9 includes, for each product type and case or piece holding mode, a field for storing a holding mode flag for three weeks (last week, last week, and this week), and a storage location change target. And a field indicating a counterpart product to be replaced. FIG. 8 shows an example of the location management data 9. In this example, No. One product A (case) and N
o. No. 2 product A (piece) and 3 products B (case)
Indicates that the storage location is to be changed. No. 1 product A (case) and No. 3 indicates that the products B (cases) are exchanged with each other (however, the product A and the product B
Are products of the same category).

Next, the configuration of the processing section 2 will be described. The processing unit 2 includes a flag creation unit 10, a flag verification unit 11, a reference stock creation unit 12, a change target extraction unit 13, and a replacement list creation unit 14.

The flag creating unit 10 stores the standard storage amount data 4
A flag table 8 is created from the
The change of the holding form flag from the combination of the changing state of the holding form flag set in the above and the change state of the holding form flag (for example, PL->PM-> PM) in which the change is stable is set as a warning for changing the storage location. Create a list. Here, "change of possession mode flag" means a state in which the possession mode flag changes to a different possession mode flag, for example, PL-> PM. Further, “change is stable” means a state in which the possession mode flags change with the same possession mode flag, for example, PM → PM.

The flag verifying unit 11 calculates and outputs the moving quantity and frequency for each change pattern based on the reference stock data 7. FIG. 7 is an example of the movement quantity / frequency for each change pattern. In this example, the flag of the week (the first week) is PS, and the flags of two weeks before and one week before the week (the first week) are P
The change pattern of the flag between PK and PS is PK->PS-> P
This is the case when S is reached. Similarly, the change pattern in the second week is PS->PS-> PK, and the change pattern in the third week is PS
->PK-> PK, change pattern of the 4th week is PK-> P
It shows the transfer quantity and transfer frequency in each week (for four weeks) for each product in the case of K-> PS. In the first week, the change pattern of the flag is PK->PS-> PS, and the storage mode flag is changed and the storage mode flag is stably changed.

In the case of the product α, the quantity to be moved in the first week indicates that there are 10 packages, and in the second week, the change pattern is PS->PS-> PK, so the transport quantity is 0. Indicates that Other weeks, product β will be described similarly. In this example, the product α and the product β are shown, but actually, all the products are handled. The moving amount and the frequency of each change pattern of the possession mode flag are verified, and a setting is made such that a change pattern that is reasonable in view of the amount of work is selected as a warning target in the warning list created by the flag creating unit 10.

The reference stock creating unit 12 calculates the reference stock amount of each product from the shipping data 6, and outputs stock management information for managing the stock amount of the stock. FIG. 13 shows an example of the inventory management information output as a result of the processing by the reference inventory creating unit 12. For each rank, the number of items (number of product types), average monthly shipment value,
It has data of a standard stock value and a stock ratio (standard stock value / monthly average shipment value).

The change target extraction unit 13 assigns a holding form flag to each product from the reference stock amount using a flag table, and selects products whose change state of the holding form flag matches the warning list as a storage location change target. List as a product.

The replacement list creating unit 14 determines a set of products for which the storage location is to be replaced with a storage location that has a negative correlation with the change state of the holding form flag of the product whose storage location is to be changed listed by the change target extracting unit 13. Then, a location replacement list including the set of products (product names) to be replaced is output. If there is no set of products to be replaced, a location transfer study list including the product (product name) set as the change target is output. The “negative correlation with the change state of the holding form flag” means that in the change pattern of the holding form flag of two products (for each storage location), the holding form flag of one product for the week and the 2 This means a state in which the holding form flags of the previous week are equal and the change pattern of the holding form flags is reversed.

More specifically, all the listed items (products) are sequentially selected two by two and the holding mode flags are compared, and the storage mode flag of the previous week and the storage mode flag of the current week are equal. Example) Product A Product B Last two weeks PL PM Last week PM PL This week PM PL The two selected products are of the same category (eg:
Toothpaste) A product that satisfies the above two conditions is selected to be a set of products whose storage locations are to be replaced.

The processing section 2 may be realized by dedicated hardware, or may be constituted by a memory and a CPU (Central Processing Unit) to realize the functions of the processing section 2. The function may be realized by loading a program into a memory and executing the program. In addition, this location management device 1 includes:
It is assumed that an input device, a display device, and the like (both not shown) are connected as peripheral devices. Here, the input device refers to an input device such as a keyboard and a mouse. The display device may be a CRT (Cathode Ray Tube), a liquid crystal display device, or the like, or a device that outputs data to the outside by a printer.

Next, the operation of the location management device 1 configured as described above will be described in order. First, the operation of the location management device 1 in the present embodiment at the time of initial setting will be described with reference to FIG.

First, the flag creating unit 10 reads the standard storage amount data 4 from the storage unit 3 (Step S21). Next, the flag creating unit 10 stores data on the storage capacity for each product in each storage location included in the standard storage amount data 4 and data on the holding form in each storage location (eg, flat storage (palette unit)). ,...) Is created (step S22). Next, the flag creating unit 10, based on the flag table 8,
A list of all combinations of three holding form flags indicating the changing patterns of the holding form flags for three weeks is listed, and a warning mark (for example, “ A warning list (e.g., FIG. 5) with "○") is created and output (step S2).
3).

Next, the flag verification unit 11 reads the reference stock data 7 (for example, FIG. 6) (Step S24). Finally, the flag verifying unit 11 calculates and outputs the moving quantity / frequency (for example, FIG. 7) for each change pattern based on the reference stock data 7 that has been created (updated weekly) (step S25). ). The movement quantity and frequency for each change pattern calculated here are as described above. Note that the flag creation unit 10 functions as a flag creation unit,
Steps S21 to S23 are executed. As described above, as the initial settings of the location management device 1, the flag table 8, the warning list, and the moving quantity / frequency for each change pattern are created.

Next, with reference to FIG. 9, an outline of the operation of the location management device 1 after the initialization has been performed will be described. Details of the operation of each unit of the location management device 1 will be described later.

First, the reference stock creating unit 12 creates the latest reference stock data 7 and stores it in the storage unit 3 (step S).
91). Next, the change target extraction unit 13 extracts a product (for each storage location) whose location is to be changed (step S92). Finally, the replacement list creation unit 14
A location replacement list is created and output (step S93).

Next, the operation of the reference stock creating unit 12 will be described in detail with reference to the flowchart shown in FIG.

First, a rank, which is a management classification of inventory management, is set based on the shipping amount ranking and the shipping days ranking (step S101). Details of the rank setting process here are as follows.

First, standard shipping data, which is a standard shipping amount, is extracted from the shipping data 6. Here "standard"
Means "small orders" and "sale" means orders exceeding the standard definition. The reason why the standard portion and the special sale portion are separated in this way is that the stock characteristics of the standard portion and the special sale portion are significantly different. The level at which the standard and special sales are separated depends on the sales situation (customers and regional characteristics) of the wholesalers. Therefore, the level at which the standard and special sales are separated is separately determined according to the circumstances of each wholesaler. As an example, one item at a time 3
Based on 0 case, the standard and special sales are separated depending on whether it is less than or greater than this value.

Next, using the standard shipping data, the shipping amounts are summed up for each product (article name) in the standard, and the square root is calculated for each. Next, according to the shipping amount,
A shipping price rank is set for each product (product name). The shipping amount rank is set based on the shipping amount ranking ("S" to "D") shown in FIG. Next, the shipping date included in the standard shipping data is counted for each product (product name), and each product (product name) is counted.
Get the shipping days for each.

Next, according to the number of shipping days, each product (product name)
Set the shipping days rank for each. That is, a shipping days rank is assigned according to the shipping days. Thereby, the products to which the shipping amount rank is given are further classified according to the number of shipping days. The shipping days rank is shown in FIG.
Are set based on the shipping date ranking ("1" to "5") shown in FIG. The above is the details of the rank setting process.

Next, the number of days for holding the order point and the number of days for holding the standard stock are set (S102). The details of the processing here are as follows. First, the details of the process of setting the number of days for holding an order point will be described.

First, the actual shipment amount and the maximum shipment amount per day are calculated for each product (article name) from the standard shipment data. The actual shipment amount / day is obtained as the average shipment amount per day of the shipment date by calculating the total shipment amount from the standard shipment data for the last 13 weeks for each product (product name) and dividing the total shipment amount by the number of shipment days. Further, the maximum shipment amount / day is obtained as a shipment amount at which the standard shipment per day becomes the maximum in the last 13 weeks.

Next, an average index (maximum shipment amount / actual shipment amount) is calculated for each product (product name). Then, the average value of the average index is calculated for each product group classified by the shipping amount rank and the shipping days rank. That is, the sum of the average indices for each product included in each rank (shipping amount and shipping days) is calculated by dividing by the number of items. Here, the “number of items” is the number of products (type) in each rank. Next, it is determined whether the number of shipping days rank is higher (the number of days rank is 1 or 2) for each product (article name) (determination A).

If it is determined in the determination A that the shipping days rank is higher, the average value of the average index in each rank (shipping amount and shipping days) is determined as the ordering point holding days by a predetermined lead time (from order to arrival). ) Is added to the inventory management information. For example, the ordering point holding days in the section (S1) in which the shipping amount rank is “S” and the shipping days rank is “1” are, for example, 1 (lead time 1) in the average value of the average index “3.81 (example)”. Day)
And rounded up to 5 days. It should be noted that (1) the bargain sale, which is an abnormal value, is removed from the processing target. (2) Empirically, the value obtained by adding the lead time is a value close to the appropriate number of days for holding the order point. (3) By being corrected by a correction process described later,
The risk of excess inventory is reduced. Therefore, even if the lead time is added, it is unlikely that excess inventory will be caused.

If it is determined in the judgment A that the shipping days rank is not higher, the value obtained by rounding the average value of the average index for each rank (shipping amount and shipping days) is set in the inventory management information as the ordering point holding days. I do. Here, the lead time is not added to the order point holding days. This is because it is not necessary to keep inventory in the same way as the top rank, in terms of both the importance of selling and the frequency of shipment. The number of shipping days rank itself is low, and the possibility of subsequent shipments is low. Therefore, addition for the lead time is unnecessary, and the average value of the average index is used as it is. More than,
It is the details of the setting process of the ordering point holding days.

The details of the process for setting the standard stock holding days will be described below. In the processing described below, items with a high sales contribution (high-ranked item-S, A) and items with a high shipping frequency (high-ranked day-item-1,
2) gives priority to avoiding out-of-stock, and reduces inventory of items with low sales contribution (lower rank items -B, C, D) and items with low shipping frequency (lower rank products-3, 4, 5). Has priority.

First, it is determined for each product (product name) whether the shipping days rank is higher (shipping days rank is 1 or 2) (determination B).

When it is determined in the judgment B that the shipping days rank is higher, the value obtained by adding 2 to the ordering point holding days of the rank is set as the reference stock holding days in the inventory management information. In the case of products with a high rank in the shipping days rank, since products are shipped more than half a week to every day, if the difference between the standard stock and the ordering point is only one day, the same product is frequently ordered and received in small quantities. It is likely to be. Therefore, the default value of the standard stock holding days is set to the ordering point holding days of that rank + 2 days.

If it is determined in the determination B that the number of days rank is not higher, a value obtained by adding 1 to the ordering point holding days of the rank is set in the inventory management information as the reference stock holding days. The default value is set to the number of days of the ordering point plus one day for the lower rank items of the shipping days rank from the viewpoint of the priority of inventory reduction and the low ordering frequency. By multiplying the average number of shipments per day (actual shipment amount) by the number of holding days for each rank, a reference stock amount (maximum stock) can be obtained. Further, the reference stock amount for each rank is included in the reference stock data 7 and stored in the storage unit 3. The above is the details of the setting processing of the standard stock holding days.

In the determination in step S105 described later,
When it is determined that it is necessary to correct the order point holding days and the standard stock holding days, the order point holding days and the standard stock holding days are corrected. The correction process here is as follows.

If the reference total inventory amount is larger than the target inventory amount range, one of the processing loops determined by step S105 is performed.
The first time refers to the D5 rank, which is the lowest rank, and the second and subsequent times refer to the higher rank in order, and decrement the reference stock holding days and order point holding days of the referenced rank by one. Here, the reason why the reference stock holding days and the order point holding days are decreased by 1 in order from the lowest rank is that the lower the rank, the lower the importance. The reason why both the reference stock holding days and the order point holding days are decreased by 1 is that if the reference stock holding days and the order point holding days approach each other, frequent ordering occurs, which is not preferable.

When the reference total inventory amount is smaller than the range of the target inventory amount, the first time of the processing loop determined in step S105 refers to the highest rank S1 rank, and 2
After that time, refer to the lower rank in order,
The reference stock holding days of the referenced rank is increased by one. Here, the reason why the reference stock holding days are increased by 1 in order from the highest rank is that higher ranks have higher importance. Also, to increase only the standard inventory holding days by 1,
This is because the more the reference stock holding days and the ordering point holding days are apart, the more the number of orders is reduced, which is preferable. The above is the details of the correction processing.

Next, the standard inventory amount calculated by multiplying the actual shipment amount / day by the standard inventory holding days for each product, and the actual shipment amount /
The ordering point calculated by multiplying the day by the ordering point holding days is calculated, included in the reference stock data 7, and stored in the storage unit 3 (S1).
03). The ordering point is obtained by multiplying the actual shipment amount / day of each product (commodity) by the number of days the ordering point is held, and indicates that an order must be made when the inventory decreases to this amount. The order point and the standard stock amount for each rank are included in the standard stock data 7 and stored in the storage unit 3.

Then, for all the products, a reference stock amount is calculated by multiplying the product unit price included in the master data 5 by the reference stock amount included in the reference stock data 7, and the reference stock amounts are totaled. The reference stock amount total is calculated (S104).

Then, it is determined whether or not it is necessary to modify the ordering point holding days and the standard stock holding days set in step S102.
If it is determined that it is necessary, return to step S102,
If it is not necessary, the process proceeds to the next process (step S105).
The determination here is made based on, for example, whether or not the total reference stock amount falls within a range of a separately determined stock target amount (for example, a range of 0.9 to 1.1 times the stock target amount). In addition, the reference | standard stock preparation part 12 functions as a reference | standard stock preparation means, and performs step S101-S105. The above is the operation of the reference stock creating unit 12. In addition,
In the above description of the operation, the money rank is “S”, “A”
Are stored in two forms, case stock and piece stock, and those of other ranks are stored only in piece stock.

Next, the operation of the change object extraction unit 13 will be described in detail with reference to the flowchart shown in FIG.

First, by comparing the flag table included in the flag data 8 with the reference stock amount included in the reference stock data 7 updated weekly, three weeks of each product (by storage location) included in the location management data 9 are compared. The minute flag is updated (step S141). The example shown in FIG.
(Case)), the holding status flags (CK, CL) of the last two weeks and last week are changed to the holding status flags (CL, CL, last week and this week).
CL), and the holding mode flag (for example, CK) corresponding to the reference stock amount of this week is set as the holding mode flag of this week. Next, a product (for each storage location) whose location is to be changed is extracted by comparing the updated location management data 9 with the warning list included in the flag data 8. Then, the product (for each storage location) whose location is to be changed in the location management data 9 is set as a change target and output to the output device (step S1).
42). Specifically, referring to FIG. 8, “product A (case)”, “product A (piece)”, “product A (piece)”, in which the holding mode flag changes and the changing pattern of the holding mode flag is stable. “Product B (case)” is set as a change target (indicated by a circle). Note that the change target extraction unit 13 functions as a change target extraction unit, and performs steps S141 to S1
Step 42 is executed. The above is the operation of the change target extraction unit 13.

Next, the operation of the replacement list creating section 14 will be described in detail with reference to the flowchart shown in FIG.

First, referring to the location management data 9, two products are sequentially selected from the products to be changed (for each storage location) extracted by the change target extracting unit 13 (step S151). Next, it is determined whether or not the change pattern of the holding form flag of the two selected products (for each storage location) is reversed (the two weekly products for which the location is to be changed have the same flag for this week and last week). If it is not the opposite, the process returns to step S151 (step S152). In the example of FIG. 8, a set of a product A (case) whose change pattern of the possession mode flag is CK->CL-> CL and a product B (case) whose change pattern is CL->CK-> CK are as follows. The change pattern of the holding form flag is reversed.

Next, in step S152, the selected 2
If it is determined that the change pattern of the holding form flag of two products (by storage location) is opposite (there is a negative correlation),
It is determined whether the two selected products (by storage location) are products of the same category, and if it is determined that they are not the same, the process returns to step S151 (step S153). The information of the category which is the product type is the master data 5
, And refer to this. If it is determined in step S153 that the two selected products (by storage location) are products of the same category, the replacement setting of the two products (by storage location) is performed in the location management data 9 (step S153). S154). Explaining specifically with reference to the example of FIG. 8, the change pattern of the possession mode flag is reversed for a set of “product A (case)” and “product B (case)”. Since the category of the two products is the same (it is assumed to be the same in this example), 3 (No. 3: product B (case)) is set as the replacement setting of “product A (case)”, and “product B (case)” is set. )) Is set to 1 (No. 1: product A (case)).

Next, in step S151, all combinations are selected for the products to be changed (for each storage location), and it is determined whether the comparison process in step S152 or S153 has been completed. The process proceeds to step S156, and if it is determined that the process has not been completed, the process returns to step S151 (step S155). In step S155, when it is determined that the above processing has been completed for all the products (by storage location) to be changed, it is determined whether there is a change target that is not set to be replaced, and when it is determined that there is no such change target. It moves to step S158 (step S156).

If it is determined in step S156 that there is a change target for which the replacement setting has not been made, the location movement study list is output to the display device (step S157). Finally, the location replacement list is output to the display device (step S158). The replacement list creation unit 14 functions as a replacement list creation unit, and executes steps S151 to S158. The above is the operation of the replacement list creation unit 14.

The manager of the distribution center changes the storage location of the product based on the location replacement list or the location transfer study list.

A program for realizing the function of the processing section of the location management device is recorded on a computer-readable recording medium, and the program recorded on this recording medium is read by a computer system and executed. Location management may be performed.

That is, this program is a location management program in the location management device, and stores a flag table storing a holding mode flag indicating a holding mode for each storage location, a change state of the holding mode flag, and a change target of the storage location. A function of storing flag data including a warning list indicating a relationship and shipping data containing the shipping status of each product, a function of calculating a standard stock amount of each product from the shipping data, A holding form flag for each product using the flag table of
The computer is provided with a function of setting a product whose change state of the holding form flag matches the warning list as a product whose storage location is to be changed.

Further, this program has a function of further storing standard storage amount data including holding form information for each storage location, and a flag table created before the standard storage amount data, and set in the flag table. A computer is provided with a function of creating a warning list in which the storage mode flag changes from the combination of the storage mode flag change states and the change state of the storage mode flag whose change is stable is set as a storage location change target.

Further, this program causes the computer to realize a replacement list creation function for setting a storage location change target product having a negative correlation with the change state of the holding form flag of a storage location replacement target product. .

The "computer system" here includes an OS and hardware such as peripheral devices. The “computer-readable recording medium” is a floppy disk, a magneto-optical disk, an RO
M, a portable medium such as a CD-ROM, and a storage device such as a hard disk built in a computer system. Further, the “computer-readable recording medium” refers to a communication line for transmitting a program via a network such as the Internet or a communication line such as a telephone line, and dynamically holds the program for a short time. thing,
In this case, a program that holds a program for a certain period of time, such as a volatile memory in a computer system serving as a server or a client, is also included. Further, the above-mentioned program may be for realizing a part of the above-mentioned functions, or may be for realizing the above-mentioned functions in combination with a program already recorded in a computer system.

The embodiment of the present invention has been described in detail with reference to the drawings. However, the specific configuration is not limited to this embodiment, and includes a design and the like within a range not departing from the gist of the present invention. It is.

[0071]

As described above, according to the location management apparatus and method of the present invention, the following effects can be obtained. The location management device of the present invention includes a reference stock creating means for calculating a reference stock amount, and a change target extracting unit for extracting a product to be changed in storage location from the reference stock amount using a flag according to a holding form. Therefore, it is possible to issue a location change instruction according to the transition of the reference stock amount and the storage capacity. Therefore, it is possible to effectively use a storage place with limited space while having stocks suitable for shipment.

[Brief description of the drawings]

FIG. 1 is a diagram illustrating a configuration example of a location device according to an embodiment;

FIG. 2 is a flowchart illustrating an operation of initial setting of the location management device.

FIG. 3 is a diagram for explaining standard storage amount data.

FIG. 4 is a diagram showing an example of a flag table in flag data.

FIG. 5 is a diagram illustrating an example of a warning list in flag data.

FIG. 6 is a diagram showing an example of reference stock data.

FIG. 7 is a diagram illustrating an example of a moving quantity / frequency for each change pattern.

FIG. 8 is a diagram illustrating an example of location management data.

FIG. 9 is a flowchart showing the operation of the location management device.

FIG. 10 is a flowchart showing the operation of a reference stock creation unit.

FIG. 11 is a diagram for explaining a shipping amount rank.

FIG. 12 is a diagram for explaining a shipping days rank.

FIG. 13 is a diagram showing an example of inventory management information.

FIG. 14 is a flowchart illustrating the operation of a change target extraction unit.

FIG. 15 is a flowchart illustrating the operation of a replacement list creation unit.

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 1 ... Location management apparatus 2 ... Processing part 3 ... Storage part (storage means) 4 ... Standard storage amount data 5 ... Master data 6 ... Shipment data 7 ... Standard stock data 8 ... Flag data 9 ... Location management data 10 ... Flag creation part (Flag creation unit) 11: Flag verification unit 12: Base stock creation unit (base stock creation unit) 13: Change target extraction unit (change target extraction unit) 14: Swap list creation unit (Swap list creation unit)

 ──────────────────────────────────────────────────の Continuing on the front page (72) Inventor Kenjiro Kobayashi 1-3-7 Honjo, Sumida-ku, Tokyo Inside Lion Corporation (72) Inventor Kenji Sakai 1-3-7, Honjo, Sumida-ku, Tokyo F term in Lion Corporation (reference) 3F022 AA15 MM01 MM07 MM22 MM28 MM49

Claims (5)

[Claims] 1. A flag table including a holding mode flag indicating a holding mode for each storage location, flag data including a warning list indicating a relationship between a change state of the holding mode flag and a storage location change target, and shipment of each product. Storage means for storing shipment data containing the status; reference stock creation means for calculating a reference stock quantity of each product from the shipment data; and a flag table based on the reference stock quantity created by the reference stock creation means. A change target extraction unit that assigns a possession form flag to each product using the change form and sets the product whose change state coincides with the warning list as a storage location change target product. Location management device. 2. The storage unit further stores standard storage amount data including storage form information for each storage location, the location management device creates the flag table from the standard storage amount data, Further comprising a flag creating means for creating the warning list in which a change in the holding form flag, which is changed from the combination of the changing states of the holding form flag set in the above, and the change state of the holding form flag whose change is stable is set as a storage location change target. The location management device according to claim 1, wherein: 3. The storage management device according to claim 1, wherein said location management device sets a storage location change target product having a negative correlation with a change state of a storage mode flag of the storage location change target product extracted by said change target extraction means. The location device according to claim 1 or 2, further comprising a replacement list creating means. 4. A location management method for a location management device, comprising: a flag table storing a holding mode flag indicating a holding mode for each storage location; and a warning indicating a relationship between a change state of the holding mode flag and a storage location change target. A procedure for storing flag data including a list and shipping data containing the shipping status of each product; a procedure for calculating a standard stock amount for each product from the shipping data; and using the flag table from the standard stock amount Assigning a possession mode flag to each product and setting a product whose change state of the possession mode flag matches the warning list as a product whose storage location is to be changed. . 5. A recording medium in which a location management program is recorded in a location management device, wherein a flag table containing a retention mode flag indicating a retention mode for each storage location, a change state of the retention mode flag, and a storage location change target are stored. Storing flag data including a warning list indicating the relationship, and shipping data containing the shipping status of each product; calculating the standard stock amount of each product from the shipping data; and A location management program for causing a computer to execute a procedure of assigning a possession mode flag to each product using a flag table, and setting a product whose change state of the possession mode flag matches the warning list as a product whose storage location is to be changed. A computer-readable recording medium on which is recorded.