CN1391182A - Real-time replenishment method using actual sales rate data - Google Patents

Abstract

A method for utilizing real-time data of sales rate to replenish goods in real time is used in a logistics center of circulation industry, the invention firstly inputs the total replenishment quantity Q of the goods; (B) the sale quantity a of each market of the commodity at the current date is captured_xAnd reading the current purchase quantity b of each market of the commodity_x(ii) a (C) Calculating the actual sale rate r of each market of the commodity_x(ii) a And (D) calculating the replenishment quantity q of each market of the commodity at the current period_x(ii) a Therefore, the present invention can obtain the sales information of POS system of each retail department in real time through the network, and further calculate more accurate replenishment quantity q by using the actual sales rate of each retail department_x。

Description

Real-time replenishment method using actual sales rate data

The present invention relates to a method for instant replenishment by utilizing actual sales rate data, especially a method suitable for calculating the quantity of replenishment required by each store in the circulation industry; the applicable commodities include stationery, books, publications, Daily necessities, sanitary products, food, canned food, fresh food, hardware groceries, and other commodities sold by the distribution industry.

In traditional distribution industries such as convenience stores or hypermarkets, etc., after the goods are distributed to each store, the inventory of goods must be checked every few days. If there is any shortage, the logistics center will replenish the goods to meet the operational needs. At present, most point-of-sale information systems (POS) are used to assist in recording transaction information such as product types and sales volumes that are increasingly diverse.

The replenishment method of the early logistics center was to replenish the actual arrival of goods to each store on an average basis, regardless of the sales performance of each store, and replenish goods on an equal basis.

Later, because the existing POS store system can record the sales volume of each product, the existing logistics center can use the past sales data of a certain product to divide each store into several levels, and then use this level as the basis for the quantity of replenishment. However, past sales data can only reflect past sales records, and cannot immediately reflect the current sales situation, nor can it accurately predict future sales volume; moreover, the method of replenishment that distinguishes several levels is too general, and it is still impossible for each store to obtain accurate information. Replenishment volume is very troublesome for the distribution industry.

Recently, it has been opened to store personnel to place orders directly so as to accurately grasp the replenishment quantity by themselves. However, due to lack of experience in judgment by the store staff. Or due to blindly rushing to order multiple orders, the same product is unsalable in some stores and seriously out of stock in other stores; moreover, the more stores there are, the longer the total time for uploading orders as a whole, and the replenishment time Gradually difficult to grasp, neither is very ideal.

The main purpose of the present invention is to provide a real-time replenishment method using actual sales rate data, so that real-time information can be used to calculate the replenishment quantity suitable for the current sales situation of each store.

Another object of the present invention is to provide a real-time replenishment method using actual sales rate data, so that the weighted effect of the actual sales rate of each store can be used to obtain a more accurate replenishment amount.

Another object of the present invention is to provide a method for real-time replenishment using actual sales rate data, so as to adapt to the replenishment needs of each store by adjusting the replenishment quantity of each store.

The present invention uses actual sales rate data to replenish goods in real time. It is used in a logistics center, including computer recordable media; it is used to replenish goods to a plurality of outlets, and can calculate the current replenishment of each outlet in advance. _The volume of goods is q _x ; the logistics center is connected to the POS systems of these outlets through a logistics server through the network. There is the current purchase quantity b _x of each store of the commodity; it is characterized in that, wherein, the above-mentioned replenishment method mainly includes the following steps:

(A) Enter the total replenishment quantity Q of the commodity;

(B) Retrieve the current sales volume a _x of each store of the product, and read the current purchase volume b _x of each store of the product;

(C) Calculate the current actual sales rate r _x of each store of the product according to the following formula:

r _x = a _x / b _x ; and

(D) Calculate the current replenishment quantity q _x of each store of the commodity according to the following formula: $q_x=Q*\frac{a_x*r_x}{\underset{x=1}{\overset{\mathrm{no}}{\mathrm{\Σ}}}\left({a_x*r}_x\right)}.$

The total replenishment quantity Q input in the step (A) is the actual total arrival quantity.

In the step (D), after calculating the replenishment quantity q _x of each store in the current period, the decimal place is unconditionally rounded up.

It also includes a step (E): adjusting the replenishment amount q _x of each store in the current period so that the sum is less than or equal to the total replenishment amount Q.

Wherein the step (E) is adjusted one by one according to the amount of replenishment quantity q _x of each store in the current period.

Wherein the step (E) is to decrease and adjust one by one according to the replenishment quantity q _x of each store in the current period from high to low.

Wherein the reduction adjustment in the step (E) is to reduce the quantity by 1 one by one.

A computer-readable recording medium of the present invention is used in the method of instant replenishment using actual sales rate data described in claim 1, and is used in a control computer of a logistics center. The recording medium is loaded with a software program, the software The program is used to replenish goods to a plurality of outlets, and can calculate the replenishment quantity q _x of each outlet in advance; the logistics center is connected to the POS system of these outlets through a logistics server through the network, and each The POS system of a store stores the current sales volume a _x of the product it sells, and the logistics center stores the current purchase volume b _x of each store of the product; the feature is that the above-mentioned software program mainly includes:

The first program code is used to accept and input the total replenishment quantity Q of the commodity;

The second program code is used to retrieve the current sales volume a _x of each store of the product;

The third program code is used to read the current purchase quantity b _x of each store of the commodity;

The fourth program code can calculate the actual sales rate r _x = a _x /b _x for each store of the commodity according to the following formula; and

The fifth program code can calculate the current replenishment quantity of each store of the commodity according to the following formula $q_x=Q*\frac{{a_x*r}_x}{\underset{x=1}{\overset{\mathrm{no}}{\mathrm{\Σ}}}(a_x*r_x)}.$

It also includes a sixth program code, which is used to adjust the current replenishment quantity _qx of each store so that the sum is less than or equal to the total replenishment quantity Q.

Among them, the fifth program code can unconditionally round up the decimal place of the replenishment quantity q _x of each store in the current period, and the sixth program code is based on the quantity of replenishment q _x in each store in the current period from high to low Decrease the quantity by 1 one by one to adjust.

The recording medium can be a hard disk, a floppy disk, an optical disc, ZIP, MO, an IC chip, or any article that includes the recording medium that can be used by those skilled in the art, preferably it is loaded into a random access memory in RAM for easy access to execute.

Because the present invention has a novel structure, can provide industrial utilization, and has indeed enhanced effects, it applies for an invention patent according to law.

For further illustrating structure and feature thereof of the present invention, below in conjunction with accompanying drawing, the present invention is described in further detail, wherein:

FIG. 1 is a system block diagram of a preferred embodiment of the present invention.

Fig. 2 is a flowchart of the operation of the preferred embodiment of the present invention.

FIG. 1 shows that in this example, the logistics server 11 of the logistics center 1 and a plurality of retail POS systems A ₁ , A ₂ , A ₃ , A ₄ . . . are connected by an Internet 2 (Internet). However, other wired networks such as Intranet, wireless networks such as WAP networks, or other equivalent networks can also be used for connection.

Wherein, the system structures of the POS systems A1, A2, A3, A4... of each store are roughly the same, and each is a local area network (LAN). In this example, the store POS system A2 is equipped with three barcode machines 321, 331, 341, which can respectively input the product numbers and 7 or product names of various commodities into the cash register 32, 33, 34 and transmit them to the POS background computer 30, It can temporarily store transaction information such as the product number and/or product name, sales volume, transaction total amount, etc. in the storage device 31 via the local area network.

In addition to the logistics server 11 in the logistics center 1, there is a database 12 for storing the transaction information of the POS systems A1, A2, A3, A4... of the whole store, and a control computer 13 to monitor the operation of the logistics server 11.

Usually, those who are familiar with the replenishment procedures in the circulation industry are accustomed to first conducting a trial calculation with an estimated total replenishment quantity Q ₁ , and after confirming that the estimated replenishment quantity of each store is correct, use the estimated total replenishment quantity Q ₁ ; first place an order with the manufacturer, so that when the manufacturer delivers the goods, then use the actual total arrival quantity Q ₁ ; calculate the actual replenishment quantity of each store in the current period to replenish the goods one by one. In fact, the scope of application of the present invention includes both the estimated total replenishment quantity Q ₁ and the actual total arrival quantity Q _2. For the convenience of explanation, this example takes the calculation process of the actual total arrival quantity Q ₂ as an example To illustrate. In addition, after the distributors distribute and deliver various commodities to each store through the logistics system, each store can start selling goods. However, since the content of the initial distribution operation is not within the scope of the present invention, it is not necessary to repeat it.

The key point of the present invention is the replenishment operation after the initial distribution. Taking the publication "Money Magazine" as an example, the initial distribution operation before each replenishment operation, or after the previous replenishment operation, has been recorded in the logistics center. Storehouse 12 retains the current purchase volume b ₁ , b ₂ , b ₃ , b ₄ ... data of each store (b ₁ represents the current purchase volume of A ₁ store, and so on), and is stored in each store During the sales process, the above-mentioned POS system has already obtained the sales volume a ₁ , a ₂ , a ₃ , a ₄ of the commodity "Money Magazine" in the current period... data (a ₁ represents the purchase volume of the current period in store A ₁ , and the rest and so on) are temporarily stored in its storage device.

Therefore, when the manufacturer ships the product "Money Magazine", the control computer 13 of the logistics center 1 calculates the current replenishment quantity q ₁ and q ₂ of each store based on the actual total arrival quantity Q ₂ according to the following steps , q ₃ , q ₄ ..., please refer to Figure 2:

(step SA) the actual total arrival quantity _Q2 is input by the control computer 13;

(Step SB) The control computer 13 connects to the Internet via the logistics server 11 and retrieves the current sales volume a ₁ , a ₂ stored in the POS system A1, A2, A3, A4... storage device of each store. , a ₃ , a ₄ ...; control the computer 13 and read the current purchase quantity b ₁ , b ₂ , 6 ₃ , b ₄ ... of each store stored in its database 12;

(step SC) the control computer 13 first calculates the current actual sales rate r _x = a _x / b _x (actual sales ratio) of each store, x=1, 2, 3, ... n, wherein the current actual sales The meaning of the rate r _x is to represent the weighted value of the sales of each store in the current period;

(step SD) the control computer 13 calculates the actual current replenishment quantity of each store $q_x={\mathrm{<figure-callout\; id="2"\; label="Q"\; filenames="A0111876300101.png"\; state="\{\{state\}\}">Q</figure-callout>}}_2*\frac{a_x*r_x}{\underset{x=1}{\overset{\mathrm{no}}{\mathrm{\&Sigma;}}}(a_x*r_x)},$ x=1,2,3,...,n, where $\frac{a_x*r_x}{\underset{x=1}{\overset{\mathrm{no}}{\mathrm{\&Sigma;}}}(a_x*r_x)}$

The meaning of is to express the weighted relationship of each store's current sales capacity relative to the overall sales capacity.

Therefore, the present invention can directly retrieve the real-time sales volume a ₁ , a ₂ , a ₃ , a ₄ , etc. information (step SB), and use the weighted value of the current sales of each store (step SC) and the weighted relationship of sales capacity (step SD) to calculate the replenishment quantity q ₁ , q ₂ , q of each store in the current period ₃ , q ₄ ..., so it is possible to calculate more accurate replenishment data that is more in line with the real-time sales situation of replenishment in each store.

In the above example, (step SB) the control computer 13 is to capture the current sales volume a ₁ , a ₂ , a ₃ , a ₄ ... of each store in a real-time manner, and it can also be changed to a specific time (for example, PM23:00 every day) ) or at regular intervals _{( for example} , 12 hours) store the current sales volume _{a 1} , a ₂ , a ₃ , a ₄ ... The data is pre-stored in the database 12 of the logistics center 1 so that it can be read by the control computer 13 during calculation. There is a time difference between the time points of quantity q _x (or the time when the goods are actually delivered to the store), during which the sales volume may change again, so it is recommended to adjust it with an adjustment factor so as to better meet the actual needs .

The replenishment quantity q ₁ , q ₂ , q ₃ , q ₄ ... of each store calculated by the present invention (step SD) can be unconditionally rounded up to an integer, so the sum may be greater than the actual total Arrival quantity Q ₂ . In order to solve this problem, the present invention can be adjusted again by (step SE), and the adjustment method is as follows: first, according to the replenishment quantity q ₁ , q ₂ , q ₃ , q ₄ of each store in the current period from high to low Arrange in descending power, and then adjust the quantity by 1 in batches one by one in order from high to low, so that the sum is less than or equal to the actual total arrival quantity Q ₂ .

In (step SD), the decimal place of each store's current replenishment quantity q ₁ , q ₂ , q ₃ , q ₄ ... can be unconditionally rounded off, and (step SE) the current replenishment quantity of each store q ₁ , q ₂ , q ₃ , q ₄ ...Arranged from low to high in ascending power, and then increase the number 1 in batches one by one from low to high, or increase the number 1 in batches one by one from high to low way, adjust until the sum is less than or equal to the actual total arrival quantity Q ₂ . Or round up the first decimal place, or round up..., or change the actual sales rate r _x of each store in the current period to make ascending or descending powers, or reduce or increase the number of batches Change it to 2, 3... equal integer quantity, the above all depends on the ideas of the distributors to change to meet the replenishment needs of various commodities or different stores.

The instant replenishment method using actual sales rate data of the present invention can be written in a computer language for execution, and the written software program can be stored in any recording medium that can be identified and interpreted by a micro-processing unit, or an item containing the recording medium and devices. It is not limited to any form, and the article can be a hard disk, floppy disk, optical disk, ZIP, MO, IC chip, random access memory (RAM), or any article containing the recording medium available to those skilled in the art . Since the instant replenishment method using actual sales rate data of the present invention has been fully disclosed, anyone who is familiar with computer language will know how to write a software program after reading the manual of the present invention, so the details of the software program will not be repeated here.

To sum up, the present invention has features that are quite different from the prior art in terms of purpose, means and efficacy, and it is a major breakthrough in the "method for instant replenishment using actual sales rate data". However, it should be noted that the above-mentioned embodiments are examples only for convenience of description, and the scope of rights claimed by the present invention should be determined by the scope of the patent application, rather than being limited to the above-mentioned embodiments.

Claims (10)

1. A real-time replenishment method using actual sales rate data, which is used in a logistics center, including computer recordable media; it is used to replenish goods to multiple stores, and can calculate the current replenishment of each store in advance _The volume of goods is q _x ; the logistics center is connected to the POS systems of these outlets through a logistics server through the network. There is the current purchase quantity b _x of each store of the commodity; it is characterized in that, wherein, the above-mentioned replenishment method mainly includes the following steps: (A) Enter the total replenishment quantity Q of the commodity; (B) Retrieve the current sales volume a _x of each store of the product, and read the current purchase volume b _x of each store of the product; (C) Calculate the current actual sales rate r _x of each store of the product according to the following formula: r _x = a _x / b _x ; and (D) Calculate the current replenishment quantity q _x of each store of the commodity according to the following formula: $q_x=Q*\frac{a_x*r_x}{\underset{x=1}{\overset{\mathrm{no}}{\mathrm{\&Sigma;}}}(a_x*r_x)}.$ 2. The method according to claim 1, wherein the total replenishment quantity Q inputted in the step (A) is the actual total arrival quantity. 3. The method for replenishing goods in real time by utilizing actual sales rate data according to claim 1, characterized in that, after the step (D) calculates the replenishment quantity _qx of each store in the current period, the decimal place is unconditionally carry. 4. The method for replenishing goods in real time by using actual sales rate data according to claim 1, characterized in that it also includes a step (E): adjusting the current replenishment quantity _qx of each store so that the sum is less than or equal to the The total replenishment quantity Q. 5. The method according to claim 4, wherein the real-time replenishment method using actual sales rate data is characterized in that the step (E) is adjusted one by one according to the replenishment quantity _qx of each store in the current period. 6. The method according to claim 5, characterized in that, the step (E) is carried out according to the order of replenishment quantity _qx of each store in the current period from high to low Decrease and adjust one by one. 7. The method according to claim 6, characterized in that the reduction adjustment in the step (E) is to reduce the quantity by 1 one by one. 8. A computer-readable recording medium for utilizing the actual sales rate data as claimed in claim 1 in an instant replenishment method, used in a control computer of a logistics center, the recording medium is loaded with a software program, the software The program is used to replenish goods to a plurality of outlets, and can calculate the replenishment quantity q _x of each outlet in advance; the logistics center is connected to the POS system of these outlets through a logistics server through the network, and each The POS system of a store stores the current sales volume a _x of the product it sells, and the logistics center stores the current purchase volume b _x of each store of the product; the feature is that the above-mentioned software program mainly includes: The first program code is used to accept and input the total replenishment quantity Q of the commodity; The second program code is used to retrieve the current sales volume a _x of each store of the commodity; The third program code is used to read the current purchase quantity b _x of each store of the commodity; The fourth program code can calculate the actual sales rate r _x = a _x /b _x for each store of the commodity according to the following formula; and The fifth program code can calculate the current replenishment quantity q _x of each store of the commodity according to the following formula: $q_x=Q*\frac{a_x*r_x}{\underset{x=1}{\overset{\mathrm{no}}{\mathrm{\&Sigma;}}}\left({a_x*r}_x\right)}.$ 9. The recording medium according to claim 8, further comprising a sixth program code for adjusting the current replenishment quantity _qx of each store so that the sum is less than or equal to the total replenishment quantity Q. 10. The recording medium according to claim 9, wherein the fifth program code is capable of unconditionally rounding up the decimal place of the replenishment quantity _qx of each store in the current period, and the sixth program code is The replenishment quantity q _x of a store in the current period is adjusted by decreasing the quantity 1 one by one from high to low.

Images