JP2001350826A - Device for calculating reasonable inventory quantity - Google Patents

Abstract

PROBLEM TO BE SOLVED: To perform inventory control in accordance with a sales planning by calculating the reasonable inventory quantity of each store of chain stores on the basis of the sales planning of merchandise. SOLUTION: The reasonable inventory quantity calculating device 1 for calculating the number of merchandise to be supplied of each store of a store group 2 from a relation among the sales quantity and period and inventory quantity and reasonable inventory quantity of the sales planning is provided with a reasonable inventory quantity calculation processing part 6 for calculating reasonable inventory quantity from the sales planning, a inventory control processing part 7 based on POS sales data from the store group 2, a merchandise supplying part for calculating the quantity of merchandise to be supplied from the rank and sales ratio and period of the store, a merchandise supply instruction processing part 9 for instructing the shipping to a physical circulation center, and a result confirmation processing part 10 for confirming the processed result.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to product inventory management in general retailing, and more particularly, to an appropriate stock quantity of a product for efficiently performing a delivery instruction operation and an inventory management operation based on a sales plan at a chain store. The present invention relates to an apparatus for calculating and a method thereof.

[0002]

2. Description of the Related Art As disclosed in Japanese Patent Application Laid-Open No. Hei 9-218899, inventory management of each store calculates a replenishment amount based on a sales amount and a stock amount, and determines an order amount. Further, in order to make use of the characteristics of the chain stores, it is determined whether or not the shortage stock can be replenished from within the chain stores in the same area. According to Japanese Patent Application Laid-Open No. Hei 7-239885, it is described that a predicted sales number is calculated from a sales plan number and a sales result number to determine an order quantity. All of these conventional technologies determine the order quantity based on actual results,
This is a way to keep the inventory properly.

[0003] Recently, new products may be sold in a large-scale sales campaign to stimulate the interest of customers and be sold. In such a sales plan, the strategy is to cooperate with chain stores, concentrate customers during the sales period, and sell new products. Under such new products and sales strategies, sales planning and inventory management based on conventional results cannot be applied. Store ranks and sales periods based on location conditions and scale rather than actual results are factors that attract customers and increase sales, and it is inappropriate to use only sales plans based on actual results.

[0004]

The first problem is that it is difficult to calculate an appropriate stock amount from past sales performance data, and the timing of stock reduction may be delayed, resulting in an extra time. The situation that has a large stock is occurring.

[0005] The second problem is that it is impossible to calculate the appropriate stock amount of a new product by the conventional technique, and it is necessary to manually set the appropriate stock amount for each store.

[0006] The reason that these occur is that in chain stores,
This is because past sales data cannot be predicted, such as setting a sales period and mobilizing customers intensively to sell in an intensive sales campaign. In addition, it is necessary to set an appropriate stock that matches the characteristics of the chain store.

An object of the present invention is to calculate an appropriate stock according to a sales amount, a period, and a rank of a chain store based on a sale plan, instead of predicting a stock amount setting of a new product based on past sales data. It is in.

[0008]

Therefore, according to the present invention, there is provided an appropriate stock calculating apparatus for calculating the number of refills of goods sold at a chain store from the sales amount, the stock amount, and the planned sales amount. Sales plan processing means to formulate a plan, store rank setting processing means to set the store rank determined by the size and location of each store in the chain store, and total sales volume, sale period, number of stores, and store rank in the sales plan It is characterized by including means for calculating a sales quantity for each store, and proper stock calculation processing means for calculating a proper stock quantity for each store based on the sales quantity.

[0009] Further, the sales plan includes a total sales quantity determined by a product sale plan, a sales pattern that determines a sales quantity and a period based on the sale plan, and a sales rank determined by a store size and a store rank determined by the location. Ratio and
It is characterized by including.

[0010] Further, the appropriate stock amount is determined by the sales quantity during the period determined by the selling pattern, the sales ratio for each store rank, the total number of stores by store rank, and the number of days in the selling period. The quantity is multiplied by the sales ratio, divided by the total number of stores, and further divided by the number of days.

[0011] Further, the appropriate stock calculating device includes a data transmitting / receiving unit for sending and receiving POS sales data from each store and a delivery instruction to the distribution center, and an appropriate stock amount for each store based on the input sales plan. An appropriate inventory calculation processing unit to calculate, an inventory management processing unit to calculate the number of sales, an inventory amount, and an appropriate inventory amount based on the POS sales data and an appropriate inventory amount for each store; A product replenishment unit that calculates a shipping instruction amount for product replenishment, a product replenishment instruction processing unit that sends the shipping instruction amount to the distribution center, and a result confirmation processing unit that manages processing results. Features.

Further, in a proper stock calculation method for calculating a proper sales amount, a sales amount, a stock amount, a sales plan amount, and a proper stock amount based on a sales plan for each product, the total replenishment number of the goods sold at the chain store is determined. Setting the number of sales, setting the sales pattern during the sales period based on the sales plan, calculating the number of stores and the sales ratio by store rank, and calculating the daily sales quantity And a step of calculating an appropriate stock amount for each store from the daily sales volume.

According to the present invention, it is not necessary to calculate the stock amount at the time of initial shipment of merchandise for each merchandise for a merchandise whose sales period is short. Since the inventory amount is calculated based on the sales plan based on the store size and location, more accurate inventory management can be realized. Further, in a chain or the like having a large number of stores, it is possible to easily optimize the inventory amount by changing the sales plan.

[0014]

Embodiments of the present invention will be described in detail with reference to the drawings. FIG. 1 is a diagram showing an embodiment of the present invention. Appropriate inventory calculation device 1
The system includes a store group 2 forming a chain store, a distribution center 3 for delivering goods, and a sales plan data input device 4 for inputting a sales plan. The proper stock calculation device 1 calculates a proper stock amount for each sales day based on the sales plan data input from the sales plan data input device 4, and reflects the proper stock amount in the stock information. Unit 5, a data transmitting / receiving unit 5 for transmitting / receiving POS sales data from the store group 2, an inventory management processing unit 7 for reflecting the POS sales data on inventory information, and calculating a shipping instruction amount to each store in the store group 2. A product replenishment processing unit 8, a product replenishment instruction processing unit 9 for sending out a shipping instruction amount to the distribution center 3 based on a shipping instruction amount to the store group 2, and a processing result confirmation processing unit 10 for confirming the processing result And.

FIG. 2 is a flowchart showing the operation of the proper stock calculation processing section 1 in this embodiment. The appropriate stock calculation device 1 is executed by the program means. First, the total sales volume and the period based on the product sale plan are input from the sales plan data input device 4 (step 2).
1). Based on the input total sales volume, a sales ratio is created for each period, a sales pattern is set, and the sales volume for each sales pattern is calculated (step 22). The store rank of each store in the store group 2 is set according to the scale and the location conditions, and the number of stores by rank and the sales ratio by rank are set.
The setting of the store rank and the sales ratio of each store can be set for each product and can be updated (step 2).
3). An appropriate stock amount is calculated for each store rank and each sales pattern (step 24). The calculated appropriate stock amount is reflected in the daily stock information during the sales period (step 25). With the above procedure, the appropriate stock amount of each store during the selling period is automatically calculated, and detailed stock management and shipping instructions can be performed.

FIG. 3 is a specific example based on the procedure of FIG. For a total sales volume of 2 million pieces of products whose sales period is 3/1 to 4/30 in the sales plan, 10
It is an example of calculation of the appropriate stock amount for a day. First, a sales plan quantity of 2 million pieces is set (step 31). Next, three sales patterns are created by setting the sales period, and the sales plan amount for each pattern is calculated (step 3).
2, 33). Next, a store rank is determined, and a sales ratio for each store rank is determined (step 34). In store rank 1 during the sales period of sales pattern 1, the appropriate stock amount of the set store is 1,000,000，2,000 ×
When 0.6 / 10 = 30, 30 is calculated (step 35). Thereafter, the appropriate stock amount created in step 35 is reflected in the stock information.

[0017]

The first effect of the present invention is that, according to the present invention, the work efficiency of creating the number of shipping instructions for a product can be improved. The reason is that even in the case of large chains, where the number of stores is large and there is no past sales performance data due to the first shipment of new products, create a sales pattern based on the sales plan and determine the appropriate inventory amount for each store rank. Since it can be calculated, the calculation of the appropriate stock amount becomes easy.

The second effect is that more detailed control of the stock amount can be realized. The reason is that if inventory management is performed using POS sales data, products that have a short sales period may become overstocked. However, since the appropriate stock amount is calculated based on the selling plan, excess inventory is calculated. Can be prevented.

[Brief description of the drawings]

FIG. 1 is a diagram showing an embodiment of the present invention.

FIG. 2 is a flowchart showing the operation of the appropriate stock calculation device.

FIG. 3 is an example of calculating an appropriate stock amount.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Proper stock calculation device 2 Store group 3 Distribution center 4 Sales plan data input device 5 Data transmission / reception part 6 Proper stock calculation processing part 7 Inventory management processing part 8 Product replenishment processing part 9 Product replenishment instruction processing part 10 Result confirmation processing part

Claims (6)

[Claims] Claims: 1. An appropriate inventory calculating device for calculating the number of replenished products of a product to be sold at a chain store based on a sales amount, a stock amount, and a planned sales amount, a sales plan processing means for formulating a sales plan of the product, and a chain. A store rank setting processing means for setting a store rank determined by the size and location of each store in the store; a means for calculating a sales quantity for each store from the total sales quantity of the sales plan, a sale period, the number of stores, and the store rank; And a proper stock calculation processing means for calculating a proper stock quantity for each store based on the sales quantity. 2. The sales plan comprises: a total sales quantity determined by a sales plan of a product; a sales pattern that determines a sales quantity and a period based on the sales plan; and a sales determined by a store rank determined by a store size and a location. The proper stock calculation device according to claim 1, further comprising: a ratio. 3. The proper stock amount is determined by the sales quantity during the period determined by the selling pattern, the sales ratio for each store rank, the total number of stores by store rank, and the number of days in the selling period. Multiply the quantity by the sales ratio,
The apparatus according to claim 1, wherein the apparatus is obtained by dividing by the total number of stores and further dividing by the number of days. 4. The proper stock calculating device, comprising: a data transmitting / receiving unit for sending and receiving POS sales data from each store and a shipping instruction to a distribution center; and a proper stock amount for each store based on the input sales plan. A proper inventory calculation processing unit to calculate; a stock management processing unit to calculate the number of sales, a stock amount, and a proper stock amount based on the POS sales data and a proper stock amount for each store; A product replenishment unit that calculates a shipping instruction amount for replenishing the product based on the information, a product replenishment instruction processing unit that sends the shipping instruction amount to the distribution center, and a result confirmation processing unit that manages processing results. The proper inventory calculation device according to claim 1, wherein: 5. An appropriate inventory calculation method for calculating an appropriate inventory according to a sales amount, an inventory amount, a sales plan amount, and a total inventory amount based on a sales plan for each product. Setting the number of sales, setting the sales pattern during the selling period based on the selling plan, calculating the number of stores and sales ratio by store rank, and calculating the daily sales quantity And calculating a proper stock quantity for each store from daily sales quantities. 6. A computer-readable storage medium for storing a program for executing the proper stock calculation method according to claim 5.