JPH0415747A - System and device for automatic stock control - Google Patents

Abstract

PURPOSE:To improve the control efficiency of commodities by giving a command for at least one of the returns, the supplementary ordering, the correction of prices, and the transfer of commodities to other stores based on the conclusion of comparison carried out between a set sold-out date and an estimated sold-out date. CONSTITUTION:An estimated sold-out date computing part 51 computes an estimated sold-out date based on the total stock stored in a storage means 4 and the sales states of commodities. A sold-out date comparison means 52 compares a set sold-out date with an estimated one. Then a command part 53 gives a command for at least one of the returns, the supplemental ordering, the correction of prices, and the transfer of commodities to other stores based on the conclusion of the means 53 and the data inputted from a return/ supplementary ordering input means 3. Thus it is possible to completely sell out the commodities before the set sold-out date and to attain the effective control of commodities.

Description

[Detailed Description of the Invention] "Field of Industrial Application" The present invention relates to an automatic inventory management system and an automatic inventory management device, and is particularly suitable for product management of trendy products such as fashion products. This invention relates to an automatic inventory management system.

"Conventional Technology" In industries that handle trendy products such as fashion products, it is required to accurately grasp rapidly changing fashion trends and efficiently control products. In response to these demands, efforts have been made to provide early and accurate sales information by introducing POS systems. It was impossible to manage both physically and time-wise.

``Problems to be solved by the invention'' However, because conventional POS systems focus on collecting sales information, it is difficult to physically process huge amounts of single item data into concrete merchandising actions. The problem was that it could not be used effectively. In other words, simply providing product information cannot actually control product inventory (returns, replenishment orders, correct product prices, move products between stores), resulting in lost sales opportunities and large amounts of defective inventory. There was a problem that it occurred. Especially when it comes to highly fashionable products such as fashion products, managers have had to pay close attention to minimizing these losses.

Therefore, we are not limited to simply saving labor and increasing efficiency at the operational level through a POS system, but also focusing on the four elements of optimizing inventory after product introduction: returns, replenishment orders, correction of product headings, and product exchange between stores. There has been a strong desire for an automatic inventory management system that can simulate the movement of goods and support decision-making regarding product inventory control.

"Means for Solving the Problems" The present invention has been devised in view of the above problems, and includes a first step of setting a sales amount to sell out a product put on the market, and a step of determining the actual sales amount based on the sales situation of the product. a second step of estimating the sales amount; a third step of comparing the set sales amount set in the first step and the estimated sales amount estimated in the second step;
This third step is comprised of a fourth step in which, based on the comparison results, at least one command among returns, replenishment orders, price revisions, and transfer of the product to another store is given.

Furthermore, the present invention includes a first step of setting a sell-out amount for selling out a product put on the market, a second step of setting whether or not there is a possibility of returning the product and ordering replenishment, and storing inventory amount for each store. a fourth step of estimating the actual sales for each store from the sales situation of the product; and a fourth step of estimating the actual sales for each store from the sales situation of the product, and estimating the set sales set in the first step and the estimated sales estimated in the fourth step. By comparing this fifth step with the above, if the estimated sales of all stores are earlier than the set sales and replenishment orders can be placed, a replenishment order is issued. By comparing the 6th step and the 5th step, if the estimated sales of all stores are later than the set sales and a return is possible, a 7th step of instructing a return, and the 4th step. By comparison,
If the estimated sales of all stores are slower than the set sales and returns are not possible, the conclusion of the comparison between the eighth step of instructing price correction and the fourth step differs depending on the store. If so, the ninth step is to issue an instruction to move the products between stores M.

Then, the estimated sales can be estimated by dividing the number of items in stock by the average light F height per day.
9 In addition, the present invention is configured to terminate the process if the data for estimating the actual sales amount from the sales status of the product is less than one week. Ordering, price correction, product other store f\
The automatic inventory management device of the present invention can be configured to issue at least one command while displaying the contents of the command, and to display this display in a specific priority order. A setting method for inputting the sales amount for each individual product, and a return/replenishment order input for inputting whether there is a possibility of returning or replenishing this individual product. storage means for storing store-by-store inventory of the individual products; and calculation control means connected to the input means and storage means, and the calculation control means includes an estimated sales calculation unit. The estimated sell-out date calculation unit, which includes a sell-out date comparison means, and a command unit, calculates an estimated sell-out date from the inventory quantity and the sales status of the product stored in the storage means, and compares the set sell-out date with the estimated sell-out date, and based on the conclusion of the sell-out date comparison means, the data input by the return/replenishment order input means, and the product sales inventory data, the command unit , returning goods, ordering replenishment, correcting prices, and moving goods to other stores.

Further, in the present invention, it is determined by the sell-out date comparison means that the estimated light-cut date of all stores is earlier than the set sell-out date, and the input data from the return/replenishment order input means enables replenishment ordering. If the sold-out date is later than the set sold-out date, the command department issues a replenishment order order, and the sold-out date comparison means determines that the estimated sold-out date for all stores is later than the set sold-out date. - If the input data from the replenishment order input means indicates that returns are possible, the command unit issues a return command, and the sell-out date comparison means sets the estimated sell-out date for all stores. It is determined that the sale date is later than the sell-out date, and
If the input data from the return/replenishment order input means indicates that returns are not possible, the command unit instructs the price to be revised, and the decision by the sell-out date comparison means is made by the store. If there is a difference, a command is issued to move the product between stores.

The present invention also includes a display device for displaying at least one instruction among the following: return, replenishment order, price correction, and transfer of the product to another store, and the display device is arranged in a specific priority order. It can also be configured to be displayed.

"Operation" The present invention configured as described above sets a sell-off date for selling out a product put on the market, estimates the actual sell-out date from the sales status of the product, and estimates the set sell-off date. The product is compared with the sell-out date, and based on the conclusion of the comparison, at least one of the following commands is performed: return, replenishment order, price adjustment, and transfer of the product to another store.

In addition, the present invention sets a sell-off date for a product put on the market, sets whether or not there is a possibility of returning the product and placing a replenishment order, and further stores inventory information for each store, and stores the sales status of the product. Estimate the actual sell-out date for each store. Then, the set sell-out date and estimated sell-out date are compared, and if the estimated sell-out date for all stores is earlier than the set sell-out date and replenishment orders can be placed, a replenishment order order is issued. Furthermore, if the estimated sell-out date of all stores is later than the set sell-off date and a return is possible, a return instruction will be issued9. If this is not possible, a price adjustment order will be issued. Further, if the above judgment differs depending on the store, a command is issued to move the product between stores.

Note that the estimated sell-out date can also be estimated by dividing the number of items in stock by the average sales amount per day.

According to the present invention, if the data for estimating the actual sell-out date from the sales status of the product is less than one week,
The process is now terminated.

In the automatic inventory management device of the present invention, the setting sell-off date input means inputs the sell-off date for each individual product when the product put on the market is sold out, and the return/replenishment order input means inputs the sell-off date for each individual product. and whether or not there is a possibility of replenishment order, and the storage means,
Stores sales and inventory of individual products by store. The arithmetic control means includes an estimated sell-out date calculation section, a sell-out date comparison means, and a command section. This estimated sell-out date calculation unit calculates the inventory quantity and product sales status stored in the storage means;
The estimated sell-out date is calculated, and the sell-out date comparison means compares the set sell-off date with the estimated sell-out date, and compares the conclusion of the sell-out date comparison means with the data input by the return/replenishment order input means. Based on the
At least one command can be given to move the product to another store. In addition, when the input data from the return/replenishment order input means indicates that replenishment ordering is possible, the command section issues a replenishment ordering command, and the sellout date comparison means compares all stores. If it is determined that the estimated sell-out date is later than the set sell-out date, and the input data from the return/replenishment order input means indicates that returns are possible, the command unit issues a return command. If the estimated light cutter of all stores is determined to be slower than the set sellable cutter by the sold cutter comparison means, and the input data from the return/replenishment order input means indicates that returns are not possible. In this case, the command unit issues a command to correct the price, and if the judgment made by the sales comparison means differs depending on the store, the command unit issues a command to move the product between stores. be able to.

"Example" An embodiment of the present invention will be described based on the drawings.

FIG. 1 is a diagram illustrating an overview of a product management system according to an embodiment. In step 1 (hereinafter abbreviated as SL), the input port and the setting cut-off mill are set and master registration is performed. Here, the input port is the date on which the product to be managed is introduced into the market.

The set sell-out limit specifies when a product that has been put on the market will be sold out, and is decided by the person in charge of handling the product. This set sales mortar corresponds to the in-store display limit mortar for product development, and if it is placed in the store with other products, it will not only disrupt the next product development, but also give a negative impression to the store, and furthermore, it will reduce sales efficiency. Next, in 82, it is set from the viewpoint of getting worse.
Enter whether or not it is possible to place a replenishment order for the relevant product to be managed, and whether or not it is possible to return it. This is because depending on the characteristics of the product being managed and the circumstances of the wholesaler, there are cases where it is possible to place a replenishment order and cases where it is possible to return the product. 8 more
Third, create sales and inventory files for each store and product. This is because the number of stocks differs depending on the size and sales level of each store, so it is necessary to store the number of stocks in advance for each store.Ninthly, in step 84, estimated sold-out mills are calculated for each store. This estimated sold-out mill is the f-measure of the sold-out mill based on the sales situation of the corresponding product. In this embodiment, the number of days for inventory consumption is calculated using the following formula.

Number of current inventory Number of days for inventory consumption Average number of sales per day for the previous seven days ・ ・ ・ ・ ・ (1) The average number of sales per day is not limited to the previous 7 days, but can be selected as appropriate, such as 5th, 10th, etc. can. From this number of days for inventory consumption, the estimated number of unsold mills is calculated using the following formula.

Estimated sales - current date + number of days for inventory consumption... (2) Therefore, in 84, the data for each store is (1) 2 and (2)
By substituting into the formula, it is possible to calculate the estimated sales volume for each product at each store.

Next, in step 85, a comparison is made between the set sold-out mill and the estimated sold-out mill. That is, the dates of the set sold-out mill and estimated sold-out mill are compared to determine which sold-out mill is earlier. Then, in S6, a life check is performed based on the result of the comparison between the set sold-out mill and the estimated sold-out mill in S5. This life check is to give an appropriate command based on the master registration data of Sl and S2 and the conclusion of 85. The $6 Life Check is detailed below.

First, the S2 master registration is stored as returnable.
This is a case where the estimated number of sold items for all stores is after the set number of items sold (life over).

In this case, a return command S7 is issued at the life check in S6. That is, since it is expected that all stores will have unsold products at the set sell-out H, it is necessary to issue a command to return the products.

This is the case when the master registration of St is set to replenishment order 'ii'r function, and the estimated sold-out stock of all stores is earlier than the set sold-out stock (life show l~ ).

In this case, the replenishment order command S
Do step 8. In other words, the product will be sold out at all stores before the set sell-out date, making it necessary to place replenishment orders.

Markdown〉 And the SL master registration is non-returnable.
This is a case where the estimated sold-out mills for all stores are later than the set sold-out mills. In this case, it is expected that there will be unsold products at all stores on the sell-off date set at all stores, but returns will not be possible. Therefore, it is necessary to lower the selling price and improve sales.

<Movement> In addition, the SL master registration is not returnable, and there are some stores where the estimated sell-out date is earlier than the set sell-off date and stores where the estimated sell-off date is later than the set sell-off date. be. In this case, at the life check in S6, an SIO command to move the product to another store is issued.

In other words, at stores where the estimated sell-off date is earlier than the set sell-off date, products will be sold out before the set sell-off date, but at stores where the estimated sell-off date is later than the set sell-off date, there will be unsold products on the set sell-off date. , from stores where there is a possibility of unsold products.
This is because it is necessary to move the product to a store where the product may be sold out.

Therefore, due to the conclusion of the S6 life check, S7~SI
Either O will be executed.

Next, an example in which this embodiment is applied to a product management system for fashion products will be explained based on FIG.

First of all, in SL, when ordering a product, you can select Life (
(corresponds to the set sell-off date). This life may be set by date or season.

The reason why life is set for each region is because the climate differs depending on the region, resulting in seasonal differences and greatly affecting sales. Next, at 82, the life is printed and displayed on the tag. This life printout is automated using a computerized issuing system using a dedicated tag printer. Then, in S3, the product is introduced to the store.

Next, in 84, it is determined whether the inventory file has data for one week or more.゛If there is more than one week of data, processing will continue, but if the data is less than one week old, processing will end9.
This is because accurate predictions are impossible if it is less than a week.

Then, in S5, the life check system is activated. This life check system calculates the estimated sell-out date from the above-mentioned equations 1 and 2, and combines this estimated sell-out date with the set sell-out date (
(Life).

Next, in 86, it is determined whether or not the life is short.

Life short refers to a situation where the product is expected to be sold out earlier than the set sell-off date (set life). That is, the estimated sell-out date is earlier than the set sell-out date.

If the life is short in S6, the process advances to S7, where it is determined whether a replenishment order can be placed. If replenishment ordering is possible in S7, the process advances to S8 and replenishment ordering is performed. After placing a replenishment order in S8, the process returns to S3. Also, if life is not short in S6, or S7
If it is not possible to place a replenishment order, the process advances to S9 and it is determined whether or not the life has passed. Life over refers to the case where it is difficult to completely consume the product within the set sell-off date (set life). That is, the estimated sell-out date is later than the set sell-out date.

If the life is over in S9, proceed to S10 and SI
Use O to determine whether the lifespan is the same for all stores.9 This is because the actual lifespan often differs from store to store, and it is necessary to move all products from the lifeover store to the lifeshort store to minimize the number of days required for consumption at all stores. be. Therefore, if it is determined at SlO that the lifespan is not uniform for all stores, the process proceeds to Sll, and at S11 the product is moved from the life over store to the life short store. Then, when Sll's store opening movement is completed, the process returns to S9. In addition, it is not life over in S9,
If the life is uniform for all stores in Sl2, proceed to Sl2. S
In Step 12, it is determined whether or not all stores have reached the lifespan. If S12 is life over for all stores, the process advances to 313 and markdown (price correction) is performed in S13. In other words, if sales are still sluggish even after opening a new store, the company lowers prices as a last resort. and 813
After performing the markdown, the process returns to S12. Note that in S12, if the life is not over for all stores, the process ends.

In case of an emergency, the set sell-off date can be changed by the administrator or the like.

Next, an automatic inventory management device necessary for carrying out this embodiment will be explained.

FIG. 3 is a diagram explaining the configuration of the automatic inventory management device,
The product management device system 1 includes a set sell-off date input means 2, a return/replenishment order input means 3, a storage means 4, and an arithmetic control means 5.
It is composed of.

The set sell-out date input means 2 is for inputting a set sell-out date into the product management system 1. This includes a keyboard, a barcode reader, etc., but any input means that can input data can be used.

The return/replenishment order input means 3 is for inputting whether or not the corresponding managed product can be returned and whether or not a replenishment order can be placed.

Similar to the setting sell-out date power means 2, any input means such as a key fob can be used.

The storage means 4 is for storing the inventory of individual products by store, and is connected to the arithmetic and control means 5.

The calculation control means 5 includes an estimated sell-out date calculation section 51, a sell-out date comparison means 52, and a command section 53. The estimated sell-out date calculation unit 51 calculates the estimated sell-out date using the inventory data stored in the storage means 4 and the first and second equations described above. The means 52 compares the set sell-out date input from the set sell-out date power means 2 with the estimated sell-out date, and executes a life check.The command unit 53 compares the sell-out date Based on the conclusion of the means 52 and the data of the return/replenishment order input means, a return instruction, a replenishment order instruction, a price correction instruction (markdown),
It issues instructions to move products between stores. These commands may be displayed on a display or the like, but they may also be displayed on a terminal of a POS system connected via a communication line or the like, and furthermore, they can be output to an appropriate printer or the like.

Furthermore, when outputting the processing results, it is also possible to set and display the priority order.

For example, in the case of "returns", items can be sorted in descending order of set sell-off date, or in descending order of life gap number. Here, 'life gap' is the difference between the estimated sell-out date and the set sell-out date.

Furthermore, in the case of "replenishment orders", the items can be displayed in descending order of the number of replenishments.

In the case of "price correction", the items can be displayed in descending order of life gap.

Furthermore, in the case of "movement", the number of lifeovers and life sea! It is also possible to display the numbers in ascending order from -1 to the highest number.

When the above display is performed,! & Processes that should be prioritized can be carried out first, resulting in extremely efficient product management.

Note that the product management system of this embodiment can also be configured by combining a POS system and a host computer, and in this case, there is an effect that extremely efficient product management can be performed.

"Effects" The present invention configured as described above has two steps: a first step of setting a sell-out date for selling out a product put on the market, and a second step of estimating the actual sell-out date from the sales status of the product. and a third step for comparing the set sell-out date set in the first step with the estimated sell-out date estimated in the second step;
The process consists of a fourth process in which at least one of the following orders is given: returns, replenishment orders, price revisions, and transfers of products to other stores based on the conclusions of the comparisons made in the processes, so the products are sold out until the set sell-out date. It has the effect of being able to completely sell out the products in a matter of seconds, and being able to perform one to one roll of extremely efficient product management control.

Furthermore, the present invention includes a first step of setting a sell-out date for selling out a product put on the market, a second step of setting whether there is a possibility of returning the product and ordering replenishment, and storing inventory caps for each store. A fourth step of estimating the actual sell-out date for each store based on the sales status of the product, and estimating the set sell-out date set in the first step and the estimated sell-out date estimated in the fourth step. The fifth step is to compare the estimated sell-out date with By comparing the 6th step and the 5th step, if the estimated sales of all stores are slower than the set sales and a return is possible, a 7th step of instructing a return, and the 4th step. By comparison,
If the estimated sales of all stores are later than the set sales, and returns are impossible, the conclusion of the comparison between the eighth step of instructing price correction and the fourth step differs depending on the store. The process consists of the 9th step of instructing the movement of products between stores, so it not only collects sales information but also performs accurate product inventory control (returns, returns, etc.).
It is possible to place replenishment orders, modify product prices, and move products between stores), and has the outstanding effect of selling out products in the shortest possible time. In particular, it has the effect of minimizing opportunity loss and efficiency loss even for fashion products that are highly trendy.

In addition, the automatic right bank management device of the present invention includes a setting means for inputting a sell-out limit for each individual product to sell out the products put on the market, and a means for inputting a sell-out limit for each individual product, and a possibility of returning and replenishing this individual product. It consists of a return/replenishment order input means for inputting the presence/absence of the item, a storage means for storing store-by-store inventory of the individual product, and an arithmetic control means connected to the input means and storage means. The arithmetic control means includes an estimated sold-out mill calculation section, a sold-out mill comparison means, and a command section, and the estimated sold-out mill calculation section calculates the estimated sales from the inventory quantity and product sales status stored in the storage means. Calculates the cut mill, and the sold mill comparison means compares the set sold mill cut with the estimated sold mill, and based on the conclusion of the sold mill comparison means and the data inputted by the return/replenishment order input means. Since the command unit is configured to issue at least one command among returns, replenishment orders, price corrections, and transfer of products to other stores, the product management system can be highly automated. This has the outstanding effect of smoothing product development, increasing store sales and reducing defective inventory.

[Brief explanation of the drawing]

The figures show an embodiment of the present invention. Fig. 1 is a diagram explaining the configuration of this embodiment, Fig. 2 is a detailed explanatory diagram of this embodiment, and Fig. 3 is a diagram showing the actual 81st example. FIG. 2 is an explanatory diagram of an apparatus for execution. ■...Product management system 2...Setting sell-out date input means 3...Return/replenishment order inputting means 4...Storage means 5...Arithmetic control means 51... Estimated sold mill calculation unit 52...Sold mill comparison means 53...Command unit

Claims (9)

[Claims] (1) A first step of setting a sell-out date for selling out the product put on the market, a second step of estimating the actual sell-out date from the sales situation of the product, and settings set in the first step. A third step is to compare the sell-out date with the estimated sell-out date estimated in the second step, and based on the comparison results in this third step, returns, replenishment orders, price corrections, and other products are processed. An automatic inventory management system comprising a fourth step of issuing at least one command for movement to a store. (2) The first step is to set the sell-off date for the product put on the market, the second step is to set the possibility of returning this product and replenishment order, and the actual sales situation of the product is determined based on the sales situation of the product. a third step of estimating the sell-out date; a fourth step of comparing the set sell-out date set in the first step with the estimated sell-out date estimated in the third step; and this fourth step. By comparing the above, the estimated sell-out date is earlier than the set sell-out date, and if a replenishment order can be placed, a replenishment order is issued in the fifth step. If the estimated sell-off date is later than the set sell-off date and a return is possible, the sixth step of instructing a return is compared with the fourth step. An automatic inventory management system characterized by comprising a seventh step of instructing a price correction in such a case. (3) The first step is to set the sell-out date when the product released on the market is sold out, the second step is to set whether there is a possibility of returning or replenishing the product, and the second step is to store the inventory amount for each store. 3 steps, a 4th step of estimating the actual sell-out date for each store from the sales status of the product, and the set sell-out date set in the first step and the estimated sell-out date estimated in the 4th step. and a sixth step of issuing a replenishment order if the estimated sell-out date for all stores is earlier than the set sell-out date and replenishment orders are possible. and a comparison between the fifth step and the seventh step of instructing a return if the estimated sell-out date of all stores is later than the set sell-off date and a return is possible, and the fourth step. Therefore, if the estimated sell-out date for all stores is later than the set sell-off date and returns are not possible, the conclusion of the comparison between the eighth step of instructing price correction and the fourth step is that the store An automatic inventory management system comprising: a ninth step of issuing an instruction to move the product between stores if the product is different between stores. (4) The automatic inventory management system according to any one of claims 1 to 3, wherein the processing is terminated if the data for estimating the actual sell-out date from the sales status of the product is less than one week. (5) The automatic inventory management system according to any one of claims 1 to 3, wherein the estimated sell-out date is estimated by dividing the number of items in stock by the average sales amount per day. (6) A claim in which at least one command among returns, replenishment orders, price corrections, and movement of products to other stores is given, and the contents of the command are displayed, and this display is displayed in a specific priority order. The automatic inventory management system described in 1 to 3. (7) Set-up sell-off date input means for inputting the sell-off date for each individual product when the product released on the market is sold out, and a return function for inputting the possibility of returning and replenishing this individual product. - Consists of a replenishment order input means, a storage means for storing store-by-store inventory of the individual product, and an arithmetic control means connected to the input means and the storage means, and this arithmetic control means calculates estimated sales. It is composed of a cut-off date calculation unit, a sell-out date comparison unit, and a command unit, and the estimated sell-out date calculation unit calculates the estimated sell-out date from the inventory quantity and the sales status of the product stored in the storage unit, and The cut-off date comparison means compares the set sell-off date and the estimated sell-off date, and based on the conclusion of the sell-off date comparison means, the data input by the return/replenishment order input means, and the product sales inventory data, An automatic inventory management device characterized in that the command unit issues at least one command among returns, replenishment orders, price corrections, and movement of products to other stores. (8) Set-up sell-off date input means for inputting the sell-off date for each individual product when the product released on the market is sold out, and a return function for inputting whether there is a possibility of returning or replenishing this individual product. - Consists of a replenishment order input means, a storage means for storing store-by-store inventory of the individual product, and an arithmetic control means connected to the input means and the storage means, and this arithmetic control means calculates estimated sales. It is composed of a cut-off date calculation unit, a sell-out date comparison unit, and a command unit, and the estimated sell-out date calculation unit calculates the estimated sell-out date from the inventory quantity and the sales status of the product stored in the storage unit, and The cut-off date comparison means compares the set sell-out date and the estimated sell-out date, and this sell-out date comparison means determines that the estimated sell-out date of all stores is earlier than the set sell-off date. , and if the input data from the return/replenishment order input means indicates that a replenishment order can be placed, the command section issues a replenishment order command, and the sold-out date comparison means allows all stores to be ordered. If it is determined that the estimated sell-out date is later than the set sell-out date, and the input data from the return/replenishment order input means indicates that returns are possible, the command unit issues a return command. , the sell-out date comparison means has determined that the estimated sell-out date for all stores is later than the set sell-off date, and the input data from the return/replenishment order input means indicates that returns are not possible. If the judgment by the sell-out date comparison means differs depending on the store, the command unit issues a command to modify the price, and if the judgment by the sell-out date comparison means differs depending on the store, the command unit issues a command to move the product between stores. An automatic inventory management device characterized by: (9) Equipped with a display device for displaying at least one command among returns, replenishment orders, price corrections, and transfer of products to other stores, and this display device is displayed in a specific priority order. The automatic inventory management device according to claim 7 or 8.