JP2010256959A - Inventory management device, inventory management method, and its program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To achieve quick and efficient inventory management by performing appropriate inventory management for each of selling events whose selling configurations are different. <P>SOLUTION: This inventory management device is provided with: an event information storage part for storing event information including at least the selling period, selling scheduled number and selling price of each merchandise for every selling event; a determination condition storage part for storing the determination conditions of sales situations in the selling period of each merchandise for every selling event; an inventory information storage part including an individual inventory storage part for storing the individual inventory of each merchandise for every selling event and a common inventory storage part for storing common inventory calculated by excluding the individual inventory of every selling event of each merchandise from the overall inventory of the merchandise; a sale information storage part for storing the actual sales of each merchandise for every selling event; and an inventory management part for determining the sales situations based on the actual sales and the determination conditions, and for changing the individual inventory and the common inventory stored in the inventory information storage part based on the determination result. <P>COPYRIGHT: (C)2011,JPO&INPIT

Description

  The present invention relates to a product inventory management device, a stock management method, and a program thereof for a plurality of sales events having different sales forms such as a sales period, a sales price, and a limited quantity.

  The catalog used for mail order has a normal expiration date, and inventory management is performed for each product based on the set expiration date.

  In the case of over-the-counter sales with a limited sales period, if the inventory of a product occurs after the end of the sales period, the product is sold at a discounted price. Even in the case of mail order sales using a catalog, it is preferable to conduct discount sales or the like in order to perform quick inventory processing when the inventory of goods occurs after the expiration date of the catalog.

  However, since the number of stocks is determined after the expiration date of the catalog, a catalog for discount sales is created after the number of stocks is determined, and there is a problem that it is difficult to perform quick inventory processing.

  Further, since the product price is printed in the created catalog, there is a problem that it is difficult to dynamically change the discount rate and the price in accordance with the inventory quantity.

  In order to solve such problems, it is proposed to calculate the discount rate based on the inventory quantity of the discount sale target product and the conditions of the discount sale period, and notify the user in real time with a predetermined notification means (Patent Document 1).

  Mail order sales may use multiple catalogs with different sales formats such as sales period, sales price, and limited quantity, and even for the same product, the sales format differs for each catalog. Need to do.

  In the method as described in Patent Document 1, the purpose is to adjust the discount rate of expired inventory products and sell out the products. Therefore, in the method described in Patent Document 1, it is not considered to increase profit without reducing the commodity price as much as possible. This point is based on the fact that the prior art does not consider product inventory management in the case where the same product is listed in a plurality of catalogs and the sales period, sales price, limited quantity, etc. are different for each catalog.

  Further, the method described in Patent Document 1 is configured to determine and calculate the discount rate after reaching the expiration date. For this reason, the conventional technology does not have a configuration in which appropriate inventory management is performed before the expiration date is reached and a sales method with a higher profit rate is adopted.

  This is the same problem for over-the-counter sales where multiple sales forms are implemented, such as when different discount rates are applied between branches or when special sales are carried out at specific stores. There is.

  The present invention provides an inventory management, an inventory management method, and a program thereof that perform appropriate inventory management for each sales event with different sales forms, and enable quick and efficient inventory management.

  The inventory management apparatus according to the present invention includes, for each sales event, an event information storage unit that stores event information including at least the sales period, the planned number of sales, and the sales price of each product, and the sales period of each product for each sales event. A judgment condition storage unit for storing the judgment condition of the sales situation in the inside, an individual inventory storage unit for storing the individual stock quantity of each product for each sales event, and a sales event for each product from the total stock quantity of each product A stock information storage unit including a common stock storage unit that stores a common stock number excluding the individual stock number, a sales information storage unit that stores the actual sales number of each product for each sales event, and a determination as an actual sales number An inventory management unit that determines the sales situation based on the condition and changes the individual inventory number and the common inventory number stored in the inventory information storage unit based on the determination result.

  Here, the sales event refers to a sales form in which the sales period, the planned number of sales, the sales price, etc. are set for each product or each product group. For example, a catalog with an expiration date set in mail order sales. Is an example. The sales event may be a catalog used for mail order sales or a specific sale with a special price, a specific period, a limited number, etc. set in store sales.

  According to the present invention, the number of individual stocks required for each sales event is secured, and the current sales situation is determined during the sales period to adjust the number of individual stocks and the number of common stocks. From this, it can be configured to move a predetermined number from the individual inventory number of sales events with poor sales to the common inventory number, and to replenish the individual inventory numbers of sales events whose sales exceed the schedule from the common inventory. it can. Therefore, it is possible to solve the problem of shortage of inventory at sales events where sales are strong.

The functional block diagram of an inventory control apparatus. The flowchart of an inventory control method. The flowchart of an inventory control method. Explanatory drawing which shows an example of an inventory master. Explanatory drawing which shows an example of an event master. Explanatory drawing which shows an example of a goods master. Explanatory drawing which shows an example of the determination condition table. Explanatory drawing of the example of a stock movement result list display. Explanatory drawing of the example of a stock movement result list display.

  A detailed description will be given based on the illustrated embodiment of the present invention.

[Inventory management device]
FIG. 1 is a functional block diagram of an inventory management apparatus according to an embodiment of the present invention.

As shown in FIG. 1, the inventory management apparatus 100 includes an event information storage unit 101 and a determination condition storage unit 102.
A stock information storage unit 103, a sales information storage unit 104, a stock management unit 105, and the like.

The event information storage unit 101 stores, for each sales event, event information including at least the sales period, the planned number of sales, and the sales price of each product. For example, each sales event can correspond to one of a plurality of catalogs, the catalog expiration date corresponds to the sales period of each product, and the limited number and sales price set for each product in each catalog are each It can be configured to correspond to the planned sales volume and sales price.

The determination condition storage unit 102 stores the determination condition of the sales situation during the sales period of each product for each sales event. The determination condition can be the determination reference days for the remaining days during the sales period of each product and the sales reference rate for the actual sales number / scheduled sales number. For example, to determine whether or not the remaining number of days during the sales period has reached a predetermined number of days, and whether or not the current sales rate at that time (= actual sales number / scheduled sales number) has reached the sales standard rate Judgment conditions.

The inventory information storage unit 103 stores an individual inventory number of each product for each sales event, and a common inventory number obtained by subtracting the individual inventory number for each sales event of the product from the total inventory number of each product. The common stock storage unit 106 that stores the common stock number and the individual stock storage unit 107 that stores the individual stock number.

The sales information storage unit 104 stores the actual number of sales of each product for each sales event.
The sales information recording unit 104 is configured to update the actual sales number based on the order information when the order information is input based on the order from the user.

The inventory management unit 105 determines the sales situation based on the actual sales number and the determination condition, and changes the individual inventory number and the common inventory number stored in the inventory information storage unit based on the determination result. When the determination conditions stored in the determination condition storage unit 102 are the determination reference days for the remaining days in the sales period of each product and the sales reference rate for the actual sales / scheduled sales, the inventory management unit 105 Determine whether the number of days remaining during the sales period has reached the specified number of days, and whether the current sales rate at that time (= actual sales number / scheduled sales number) has reached the sales standard rate, and the determination result The common stock quantity and the individual stock quantity can be changed based on the above.

[Basic processing]
FIG. 2 is a flowchart of the inventory management method in one embodiment of the present invention.

In step S202, the inventory management apparatus 100 determines whether or not goods receipt information has been input. The inventory management apparatus 100 proceeds to step S204 when determining that the goods receipt information of the product has been input, and proceeds to step S206 otherwise.

In step S204, the inventory management apparatus 100 updates the data in the common inventory storage unit 106 of the inventory information storage unit 103 based on the receipt information. When the corresponding product information does not exist in the stock information storage unit 103, the stock management apparatus 100 sets the common stock storage area of the product in the common stock storage unit 106 based on the receipt information, and sets the number of goods received in the common stock. Remember as a number. Further, the inventory management apparatus 100 determines that the common inventory storage unit 106 when the corresponding product information exists in the inventory information storage unit 103.
A value obtained by adding the number of warehousing to the common stock quantity in the common stock storage area of the corresponding product is stored.

In step S206, the inventory management apparatus 100 determines whether or not event information has been input. The inventory management apparatus 100 proceeds to step S207 when determining that the event information related to the sales event has been input, and otherwise proceeds to step S208.

In step S207, the inventory management apparatus 100 accepts input of event information including at least a sales period, a planned number of sales, and a sales price, and stores the event information in the event information storage unit 101. Here, a catalog that lists a plurality of products for which an expiration date is set, a limited number of sales, a sales price, etc. is set as one sales event, and information for each product listed in the catalog may be set as event information. it can. In this case, the inventory management apparatus 100 causes the event information storage unit 101 to store event information in which the expiration date of the catalog is the sales period and the limited number and sales price set for each product are the planned sales number and sales price, respectively. It can be configured as follows. For example,
Each time a new catalog is issued, event information for a new sales event is entered.

In step S208, the inventory management apparatus 100 executes a process of assigning the common inventory quantity stored in the common inventory storage unit 106 to the individual inventory quantity for each sales event of each product based on the input event information. . Here, the inventory management apparatus 100 determines the number of individual inventory based on the planned number of sales of each product for each sales event, and stores this in the individual inventory storage unit 107.
Since the number of goods received is considered to be at least the quantity required for the sales event, the inventory management device 100 assigns the planned number of sales of each product for each sales event as each individual stock quantity, and uses this. The individual inventory storage unit 107 stores the result, and the common inventory storage unit 106 stores the result of subtracting the total of each individual inventory number from the common inventory number.

In step S210, the inventory management apparatus 100 accepts an input of conditions for determining the sales situation during the sales period of each product for each sales event. As described above, the determination condition can be the determination reference days for the remaining days during the sales period of each product and the sales reference rate for the actual sales / scheduled sales. Based on the sales period and the planned number of sales for each sales event, the administrator determines the determination reference days and the sales reference rate, and the inventory management apparatus 100 accepts the input of the determined determination condition, and the determination condition storage unit 102 can be configured to be stored. In addition, the inventory management device 100 is based on the sales period and the planned number of sales of each product for each sales event,
It is also possible to configure to automatically determine the predetermined judgment reference days and the sales reference rate. For example, the judgment reference days is 1/4 of the sales period, and the sales reference rate is 90% of the planned sales number. can do. For the method of setting the judgment condition by the inventory management device 100,
An example is shown on description and it is not limited to the illustrated numerical value.

In step S212, the inventory management apparatus 100 determines whether or not order information has been input. The inventory management apparatus 100 proceeds to step S214 when determining that the order information has been input based on the order from the user, and proceeds to step S216 otherwise.

In step S214, the inventory management apparatus 100 executes order receiving processing. Based on the order information, the inventory management device 100 checks whether or not the inventory quantity in the inventory information storage unit 103 is sufficient for the ordered product. If the inventory quantity is insufficient, the inventory management apparatus 100 cannot accept an order. Send notifications for. Further, when the inventory management apparatus 100 determines that the inventory quantity in the inventory information storage unit 103 satisfies the order quantity in the order information, the inventory management apparatus 100 adds the order quantity to the actual sales quantity of the corresponding product in the sales information storage unit 104. This is stored, and the order quantity is subtracted from the individual inventory quantity of the corresponding product in the individual inventory storage unit 107 and stored.

In step S216, the inventory management apparatus 100 executes an inventory management process for adjusting the individual inventory quantity and the common inventory quantity. The inventory management device 100 calculates the current sales rate from the current actual sales number and the planned sales number, whether or not the number of sales days for each product has been reached for each sales event, and has reached the sales standard rate Whether or not and the number of individual stocks and the number of common stocks are adjusted based on the determination result.

In step S218, the inventory management apparatus 100 determines whether there is a sales event for which the sales period has ended. The inventory management apparatus 100 proceeds to step S220 when determining that there is a sales event for which the sales period has ended, and proceeds to step S222 otherwise.

In step S220, the inventory management apparatus 100 deletes the event information of the sales event whose sales period has ended from the event information storage unit 101. The inventory management apparatus 100 adds the individual inventory number of the corresponding sales event stored in the individual inventory storage unit 107 to the common inventory number of the common inventory storage unit 106 of the same product, and the individual inventory storage unit 107 of the corresponding product. Is released.

In step S222, the inventory management apparatus 100 determines whether to end the process. The inventory management apparatus 100 ends this process when receiving an end instruction from the operator or when it is determined that there are no more sales events to be managed, and otherwise proceeds to step S202.

[Inventory management processing]
The inventory management process in step S216 in FIG. 2 will be described.

  FIG. 3 is a flowchart illustrating an example of inventory management processing executed by the inventory management unit 105 of the inventory management apparatus 100.

  In step S302, the inventory management unit 105 calculates the current sales rate. The inventory management unit 105 calculates the current sales rate = actual sales number / sales from the actual sales number of the product stored in the sales information storage unit 104 and the planned sales number of the product stored in the event information storage unit 101. Calculate the planned number.

In step S304, the inventory management unit 105 determines that the current remaining days of the product sales period is less than the determination reference days of the product stored in the determination condition storage unit 102, and the current sales rate is less than the sales reference rate. It is determined whether or not there is. The inventory management unit 105 proceeds to step S306 when determining that this condition is satisfied, and proceeds to step S308 otherwise.

In step S306, the inventory management unit 105 determines that the sales status of the corresponding product is lower than the planned sales, subtracts a predetermined number from the individual inventory number, and adds the same number to the common inventory number to store the inventory information. The data is stored in the unit 103. The inventory management unit 105 calculates the actual sales number to be reached when the sales reference rate is achieved as the actual sales reference number, and subtracts the difference between the current actual sales number and the actual sales reference number from the individual inventory number. The inventory management unit 105 adds the same number subtracted from the individual inventory number to the common inventory number. The inventory management unit 105 stores the recalculated individual inventory number and the common inventory number in the inventory information storage unit 103. Thus, the inventory management unit 105 is configured to reduce the number of individual stocks of products that are less than the planned number of sales and add the same number to the common stock number.

In step S308, the inventory management unit 105 determines that the current remaining days of the product sales period is equal to or greater than the determination reference days of the product stored in the determination condition storage unit 102, and the current sales rate is equal to or greater than the sales reference rate. It is determined whether or not there is. The inventory management unit 105 proceeds to step S310 if it determines that this condition is satisfied, and proceeds to step S312 otherwise.

In step S310, the inventory management unit 105 determines that the sales status of the corresponding product exceeds the planned sales, adds a predetermined number to the individual inventory number, and subtracts the same number from the common inventory number to store the inventory information. The data is stored in the unit 103. The inventory management unit 105 calculates the actual sales number to be reached when the sales standard rate is achieved as the actual sales reference number, and adds the number of actual sales exceeding the actual sales number reference number to the individual inventory number, Subtract the same number from the common inventory. When the common inventory number is less than the difference between the actual sales number and the actual sales reference number, the number to be added to the individual inventory number can be determined within the range of the common inventory number. In addition, when the current sales rate of the same product exceeds a reference sales rate in a plurality of sales events, the number of individual stocks of sales events with a high profit rate can be preferentially added. As a result, the inventory management unit 105 is configured to increase the number of individual stocks of products that exceed the planned number of sales and to reduce the number to the common stock number.

In step S312, the inventory management unit 105 determines whether the inventory management process has been completed for all products. The inventory management unit 105 ends the process when determining that the inventory management process has been completed for all products, and otherwise proceeds to step S302.

[Data master]
Data handled by the inventory management apparatus 100 will be described.

FIG. 4 is an explanatory diagram illustrating an example of an inventory master used for inventory management processing in the inventory management apparatus 100.

  The inventory master 400 shown in FIG. 4 reflects all or part of event information, warehousing information, order information, and the like input to the inventory management apparatus 100.

  The stock master 400 includes a representative product code column 401, a product code column 402, a product name column 403, an event name column 404, a stock quantity column 405, a price column 406, and the like.

The representative product code column 401 is an area in which representative product codes of products common to sales events are stored. The product code column 402 is an area for storing a product number for each sales event.
The product name column 403 is an area for storing the product name of the corresponding product. The event name column 404 is an area in which the name of the sales event is stored. For example, a catalog name is stored.

The stock quantity column 405 is an area for storing the stock quantity allocated based on the warehousing information and the event information. The stock quantity stored in the stock quantity column 405 is subtracted from the corresponding number based on the subsequent order information, and the corresponding number is added based on the warehousing information. Furthermore, the value stored based on the adjusted common stock quantity and individual stock quantity is updated by the stock management process of the stock management unit 105.

The price column 406 is an area in which the price of the product is stored, and the product price set for each sales event is stored.

FIG. 5 is an explanatory diagram showing an example of an event master used for inventory management processing in the inventory management apparatus 100.

  The event master 500 shown in FIG. 5 reflects all or part of event information input to the inventory management apparatus 100.

  The event master 500 includes an event name field 501, an event code field 502, a sales period field 503, and the like.

The event name column 501 is an area for storing a name unique to a sales event, and can be configured to store catalog names such as “XX year-end gifts” and “XX year new year”, for example.

The event code column 502 is an area for storing a sales event code, and can be configured to store, for example, a catalog code number.

The sales period column 503 is an area for storing information related to the sales period of the sales event.
Here, it can be configured to store the expiration date of the catalog.

FIG. 6 is an explanatory diagram illustrating an example of a product master used in the inventory management process in the inventory management apparatus 100.

The product master 600 includes a product code field 601, a product name field 602, an event code field 603, and a price field 604.
The customer code field 605 is provided.

The product code column 601 is an area for storing a product code for each sales event, and can be configured to store a product code posted in a catalog. The product name column 602 is an area for storing the product name of the corresponding product, and can be configured to store the product name listed in the catalog.

The event code column 603 is an area for storing a code number assigned to a sales event, and can be configured to store, for example, a catalog code number.

The price column 604 is an area for storing the product price set for each sales event, and can be configured to store the sales price posted in the catalog.

  The supplier code column 605 is an area in which the supplier code of the supplier of the product is stored.

  The stock master 400, the event master 500, and the product master 600 store data of each record based on event information, warehousing information, order information, and the like input to the stock management apparatus 100. Data in each item May be stored redundantly in multiple masters.

FIG. 7 is an explanatory diagram of an example of a determination condition table indicating correspondence between event information input to the inventory management apparatus 100 and determination conditions set for each product.

7 includes an event code field 701, a product code field 702, a sales period field 703, a sales price field 704, a planned sales number field 705, a sales reference rate field 706, a reference day number field 707, and the like. Yes.

The event code column 701 is an area for storing a code number assigned to a sales event, and can be configured to store, for example, a catalog code number.

The product code column 702 is an area for storing a product code for each sales event, and can be configured to store a product code posted in a catalog.

The sales period column 703 is an area for storing information related to the sales period of the sales event.
Here, it can be configured to store the expiration date of the catalog.

The sales price column 704 is an area for storing the price of the product, and stores the product price set for each sales event.

The planned sales number column 705 is an area for storing the planned sales number set for the corresponding product in the sales event, and can be configured to store a limited quantity or the like posted in the catalog.

The sales reference rate column 706 and the reference days column 707 are areas for storing the sales reference rate and the reference days, which are determination conditions for determining the current sales situation of the product. Whether the remaining days in the sales period are less than the reference days stored in the reference days column 707 and the current sales ratio calculated by the actual sales / scheduled sales, Depending on whether or not the sales reference rate stored in the sales reference rate 706 has been reached, it is used as a determination condition for determining the current sales situation. For example, by setting 1/4 of the number of days in the sales period as the base number of days and setting 90% of the planned sales as the sales reference rate, the actual number of sales will be sold when there are enough remaining days in the sales period. It is possible to determine when the number exceeds the number or when the actual number of sales is less than the planned number of sales when the remaining number of days in the sales period decreases.

〔Example〕
The inventory management device 100 as described above is a predetermined personal computer including a storage device such as a CPU, ROM, RAM, and hard disk, an input device including a keyboard and a mouse, a display device such as a display, and a communication interface. This can be realized by cooperation of application software.

A specific example in the case where inventory management is performed for a plurality of catalogs having different sales periods as sales events in such an inventory management apparatus 100 will be described.

Consider a case where catalogs A to D exist as sales events in the inventory master 400, the event master 500, the product master 600, and the determination condition table 700 as described above.

FIG. 8 is an explanatory diagram of a stock movement result list display example in the case where the process of returning the inventory quantity from the individual inventory quantity to the common inventory quantity as a result of the inventory management process by the inventory management unit 105 is performed.

The inventory movement result list 800 includes a catalog name field 801, a product code field 802, a sales period field 803, a sales price field 804, a planned sales number field 805, a sales reference rate field 806, a judgment standard days field 807, and a remaining sales days judgment field. 808, an order quantity field 809, an inventory quantity field 810, a return quantity field 811 and an inventory quantity field 812 after reflection is provided.

  The catalog names of catalogs A to D are “2008 year-end gifts”, “2009 New Year issue”, “2009 New Year items” and “2008 winter issue”, respectively. : 2008/12/25, 2008/12/1: 2009/1/31, 2008/12/1: 2009/1/31, 2008/11/1: 2008/12/27 is there.

As one of the products common to these catalogs, let us consider an inventory management process for a product whose representative product code is “CD0001” and whose product name is “Seasoning (XX production)”. Assume that the product codes in catalogs A to D are “CD0001A”, “CD0001B”, “CD0001C”, and “CD0001D”, respectively. The inventory movement result list 800 includes data lines for managing individual inventory numbers corresponding to the product codes “CD0001A”, “CD0001B”, “CD0001C”, and “CD0001D” as individual inventory lines 821 to 824, respectively. A data line for managing the number of stocks is provided as a common stock line 825.

  The sales price column 804 and the planned sales number column 805 store the sales price and the planned sales number based on the input event information. In addition, in the sales reference rate column 806 and the determination reference days column 807, input determination conditions are stored.

Further, the number of orders sold 809 stores the actual number of sales updated based on the order information, and the number of stocks stored in the stock information storage unit 103 is reflected in the number of stocks column 810.

In the inventory management process, the inventory management unit 105 determines that the remaining sales period is the “return period” when it determines that the remaining days in the sales period has become less than the determination reference number of days. In this case, the inventory management unit 105 executes processing for returning from the individual inventory number to the common inventory number when the current sales rate is lower than the sales reference rate.

In the individual inventory row 821 for the catalog A, the value in the judgment reference days field 807 is “7”, but the current remaining sales days are 6, so the inventory management unit 105 determines the remaining sales days. Judgment result is “return period” and the value of remaining sales days determination field 808 is “return period”
And

Similarly, for the individual inventory row 824 for catalog D, the current number of remaining sales days is also less than the value in the judgment reference days column 807, so the inventory management unit 105 displays the judgment result of the number of remaining sales days as “return period”. And the value of the remaining sales days determination field 808 is set as the “return period”.

Next, the inventory management unit 105 calculates the current sales rate based on the value in the order quantity column 809 and the value in the planned sales number column 805, and compares it with the value stored in the sales reference rate column 806. As a result,
The inventory management unit 105 subtracts a predetermined number from the number of individual inventory lines determined to have a current sales rate below the sales reference rate, and adds the same number to the number of inventory in the common inventory line. Execute the process.

In the inventory management unit 105, the value of the remaining sales period determination field 808 in the individual inventory line 821 is “return period”.
However, since the current sales rate exceeds the sales reference rate, the inventory movement process is not executed. The inventory management unit 105 also displays the remaining sales period determination field 808 in the individual inventory row 824.
Since the value of is the “return period” and the current sales rate is below the sales reference rate, the predetermined number is subtracted from the value in the inventory quantity column 810, and the value in the inventory quantity column 810 of the common inventory line 825 The stock movement process is executed by adding the same number to. The inventory management unit 105 calculates the difference between the actual sales reference number that reaches the sales reference rate and the actual actual sales number stored in the order quantity column 809, and converts this from the individual inventory number to the common inventory number. The number to be moved is stored in the return number column 811.
Further, the inventory management unit 105 stores the value of the return number to be moved in the return number column 811 of the common inventory row 825. In the illustrated example, since “6” is subtracted from the value in the inventory quantity column 810 in the individual inventory line 824, “−6” is stored in the value in the return quantity column 811 of the same line. Since “6” is added to the value in the number column 810, “6” is stored in the value in the return number column 811 of the same row.

The inventory management unit 105 stores each inventory quantity after the value in the return quantity field 811 is reflected in the value in the inventory quantity field 810 and stores it in the inventory quantity field 812 after being reflected.

  Next, a case where it becomes necessary to replenish individual stock will be described.

FIG. 9 is an explanatory diagram of a stock movement result list display example in the case where the replenishment process from the common stock quantity to the individual stock quantity is performed as a result of the stock management process by the stock management unit 105.

The inventory movement result list 900 includes a catalog name field 801 and a product code field 802 as in the example of FIG.
, A sales period column 803, a sales price column 804, a planned sales number column 805, a sales reference rate column 806, a judgment reference days column 807, a remaining sales days judgment column 808, an order quantity column 809, and an inventory quantity column 810.

The inventory movement result list 900 further includes a replenishment number column 901, a stock number column 902 after replenishment reflection, a replenishment priority column 903, and the like.

  In the example shown in FIG. 9, data such as event information and determination conditions are almost the same as those in the example shown in FIG. 8, but there are some parts changed for convenience of explanation.

The inventory management unit 105 determines that the remaining sales period is the “replenishment period” when it is determined in the inventory management process that the remaining number of days in the sales period is equal to or greater than the determination reference number of days. In this case, when the current sales rate is equal to or higher than the sales reference rate, the inventory management unit 105 executes a process of replenishing the individual stock number from the common stock number.

In the individual inventory line 822 for the catalog B, the value in the judgment reference days field 807 is “10”, whereas the current remaining sales days are 42 days. Judgment result is “replenishment period”, and the value of remaining sales judgment column 808 is “replenishment period”
And

Similarly, for the individual inventory line 823 for catalog C, the current number of remaining sales days is equal to or greater than the value in the judgment reference days field 807, so the inventory management unit 105 displays the judgment result of the number of remaining sales days in the “replenishment period”. It is determined that there is, and the value in the remaining sales days determination field 808 is set as the “replenishment period”.

Next, the inventory management unit 105 calculates the current sales rate based on the value in the order quantity column 809 and the value in the planned sales number column 805, and compares it with the value stored in the sales reference rate column 806. As a result,
The stock management unit 105 adds a predetermined number to the number of stocks for each individual stock line determined that the current sales rate is equal to or higher than the sales reference rate, and subtracts the same number from the stock number of the common stock line Execute.

The inventory management unit 105 indicates that the value of the remaining sales period determination field 808 in the individual inventory line 822 is “replenishment period”.
Since the current sales rate is equal to or higher than the sales reference rate, the difference between the actual sales number to achieve the sales reference rate and the value in the number of orders column 809, which is the actual actual sales number, is replenished And

In order to achieve the sales reference rate, the inventory management unit 105 has a value of “replenishment period” in the remaining sales period determination field 808 in the individual inventory line 823 and the current sales rate is equal to or higher than the sales reference rate. The difference between the actual sales number and the value in the order quantity column 809 that is the actual actual sales number is used as the replenishment number.

Here, since the replenishment quantity to be replenished is “10” in the individual inventory lines 822, 823, if the value in the inventory quantity column 810 of the common inventory line 825 is “20” or more, the individual inventory lines 822, 823 It can be configured such that the value in the stock quantity column 810 is replenished by “10” respectively.

The example of FIG. 9 shows a case where the value in the inventory quantity column 810 of the common inventory line 825 is less than the total number of replenishments required for both the individual inventory lines 822 and 823.

In such a case, the inventory management unit 105 determines the replenishment priority for each sales event, stores this in the replenishment priority column 903, and replenishes in order of higher priority based on this replenishment priority. Can be configured to do.

For example, in the example shown in FIG. 9, the replenishment priority is determined in descending order of sales price (in order of profit margin), the individual inventory line 823 has the highest priority, and the individual inventory line 822 has the second priority. Has become a ranking. From now on, the inventory management unit 105 first allocates the replenishment quantity “10” required in the individual inventory line 823, and then uses the remaining “6” of the inventory quantity in the common inventory line 825 as the replenishment quantity in the individual inventory line 822. Assigned. Therefore, the inventory management unit 105 stores “6” in the value of the replenishment quantity column 901 of the individual inventory line 822 and stores “10” in the value of the replenishment quantity column 901 of the individual inventory line 823. Further, the inventory management unit 105 stores the value “−16” of the replenishment quantity to be moved in the replenishment quantity column 901 of the common inventory line 825.

The stock management unit 105 stores each stock quantity after the value in the replenishment quantity field 901 is reflected in the value in the stock quantity field 810 in the stock quantity field 902 after replenishment reflection.

The inventory management unit 105 can be configured to automatically generate and display the inventory movement result lists 800 and 900 based on an operator's instruction, and an execution instruction and cancel button is provided on the display screen. It is possible to configure so as to receive an instruction as to whether or not to execute.

  The inventory movement result lists 800 and 900 can be displayed separately as described above, but the return number column, the replenishment number column, the replenishment priority column, and the reflected inventory number column are the same list. It can also be configured to display above.

[Other Embodiments]
(A) In the embodiment described above, since the sales reference rate is used as the determination condition, it is possible to set the determination condition in a batch by applying the sales reference rate to the entire products listed in the catalog. It becomes possible. Instead of this, it is also possible to set a sales reference number as a determination criterion so as to correspond to the planned sales number of each product.

(B) Replenishment priorities are determined in order of increasing sales price or increasing profit margin, but in descending order of planned sales, in order of long sales period, in order of increasing remaining days in sales period, catalog distribution It can be set based on the order in which the number of copies is large, the priority order of catalogs, or the like, and can be configured so that the operator can set it manually.

(C) The same inventory management can be applied to over-the-counter sales that specify the sales period, sales price, limited number, etc. In this case, the present invention can also be applied to a case where inventory management at a plurality of branches is managed by a distribution center.

(D) Judgment conditions are set as the judgment standard days for the remaining days in the sales period of each product and the sales standard rate for the actual sales / scheduled sales. By setting multiple judgment conditions, for example, Set the return condition and replenishment condition separately, and the remaining days are 1 month and 1
It is also possible to carry out finer inventory adjustments by setting a plurality of values in 0 days.

  It can be applied to inventory management in catalog sales and various store sales, and inventory management during the sales period can be appropriately performed.

JP 2002-24586 A

Claims (9)

For each sales event, an event information storage unit that stores event information including at least the sales period, the planned number of sales, and the sales price of each product;
For each of the sales events, a determination condition storage unit that stores a determination condition of the sales situation during the sales period of each product,
An individual inventory storage unit that stores the individual inventory number of each product for each sales event, and a common inventory that stores a common inventory number obtained by subtracting the individual inventory number of each product from the overall inventory number for each sales event An inventory information storage unit including a storage unit;
For each sales event, a sales information storage unit that stores the actual number of sales of each product;
An inventory management unit that determines the sales situation based on the actual sales number and the determination condition, and changes the individual inventory number and the common inventory number stored in the inventory information storage unit based on the determination result; Inventory management device. The determination conditions stored in the determination condition storage unit are the determination reference days for the remaining days in the sales period and the sales reference rate for the actual sales / scheduled sales,
The inventory management unit calculates a current sales rate (= actual sales number / scheduled sales number) based on the actual sales number and the planned sales number, and compares the current sales rate with the sales reference rate. The inventory management apparatus according to claim 1, wherein the number of days remaining in the sales period is compared with the number of reference days, and the common inventory number and the individual inventory number are changed based on a comparison result.   When the inventory management unit determines that the remaining days in the sales period is less than the determination reference days and the current sales rate does not reach the sales reference rate, the individual inventory of the sales event of the corresponding product The inventory management apparatus according to claim 2, wherein a predetermined number is subtracted from the number, and the same number is added to the common inventory number of the products.   When the inventory management unit determines that the remaining days in the sales period is equal to or greater than the determination reference days and the current sales rate exceeds the sales reference rate, the individual inventory of the sales event of the corresponding product The inventory management apparatus according to claim 2, wherein a predetermined number is added to the number, and the same number is subtracted from the common inventory number of the product. Storing the number of goods received in the inventory information storage unit as a common stock quantity for each product;
Storing event information including at least the sales period, the planned number of sales, and the sales price in the event information storage unit for each sales event;
Determining an individual inventory number for each sales event of each product based on the planned sales number and storing it in an inventory information storage unit;
For each sales event, based on the sales period and the planned number of sales, determining a determination condition for the sales situation during the sales period, and storing the determination condition in a determination condition storage unit;
For each sales event, based on the order information of each product, updating the actual sales number of the sales information storage unit and the individual inventory number of the inventory information storage unit;
Determining the sales situation based on the actual sales number and the determination condition, and changing the individual inventory number and the common inventory number stored in the inventory information storage unit based on the determination result;
Inventory management method The determination condition is a determination reference number of days for the remaining days in the sales period, and a sales reference rate for the actual sales / scheduled sales,
Based on the actual sales number and the planned sales number, a current sales rate (= actual sales number / scheduled sales number) is calculated, and the current sales rate and the sales reference rate are compared. The inventory management method according to claim 5, wherein the remaining number of days and the determination reference number of days are compared, and the common inventory number and the individual inventory number are changed based on a comparison result.   When it is determined that the number of days remaining during the sales period is less than the determination reference days and the current sales rate has not reached the sales reference rate, a predetermined number is calculated from the individual inventory number of sales events of the corresponding product. The inventory management method according to claim 6, wherein the same number is added to the common inventory quantity of the product by subtracting.   When it is determined that the number of days remaining during the sales period is equal to or greater than the determination reference days and the current sales rate exceeds the sales reference rate, a predetermined number is set as the individual inventory number of the sales event of the corresponding product. The inventory management method according to claim 6, wherein addition is performed and the same number is subtracted from the common inventory number of the product. Storing the number of goods received in the inventory information storage unit as a common stock quantity for each product;
Storing event information including at least the sales period, the planned number of sales, and the sales price in the event information storage unit for each sales event;
Determining an individual inventory number for each sales event of each product based on the planned sales number and storing it in an inventory information storage unit;
For each sales event, based on the sales period and the planned number of sales, determining a determination condition for the sales situation during the sales period, and storing the determination condition in a determination condition storage unit;
For each sales event, based on the order information of each product, updating the actual sales number of the sales information storage unit and the individual inventory number of the inventory information storage unit;
Determining the sales situation based on the actual sales number and the determination condition, and changing the individual inventory number and the common inventory number stored in the inventory information storage unit based on the determination result;
A program for causing a computer to execute an inventory management method.

Images