JPH09274633A - System for confirming remaining number and deciding ordering amount - Google Patents

Abstract

PROBLEM TO BE SOLVED: To decide the proper order amount of merchandise by confirming the time sequential change in the amount of sold merchandise and the number of remaining merchandise ordered on the same day of the previous week, etc., in the case of deciding the order amount of merchandise. SOLUTION: Concerning this amount deciding system, a tendency curve calculating means 105 is provided for calculating a continuous function as an approximate curve expressing the sales tendency of merchandise based on the sold result 103 of merchandise and calculating a tendency curve by correcting this calculated approximate curve based on the order/supply result 104 of merchandise weather information 102 such as weather conditions, a means 106 for calculating the number of remaining merchandise on the same day of the previous week is provided for calculating the number of remaining merchandise ordered on the same day of the previous week based on the sold result 103 of merchandise and the order/supply result 104 of merchandise, and a means 107 for deciding the order amount of merchandise is provided for deciding the amount of merchandise to be ordered this time from the tendency curve calculated by the tendency curve calculating means 105 and the number of remaining merchandise calculated by the means 106 for calculating the number of remaining merchandise on the same day of the previous week. Then, the more proper amount of ordered merchandise is decided while considering the characteristics of merchandise corresponding to the days of the week.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an order quantity determination system for determining the order quantity of a product.

[0002]

2. Description of the Related Art Conventionally, in the process of deciding the order quantity of a product, the decision is made based on the past actual sales quantity etc. based on the experience or intuition of the ordering operator. As described in Japanese Patent No. 72476, the determination is automatically made in consideration of the information such as weather information that affects the sales volume.

[0003]

In the above-mentioned conventional order quantity determination method, since the sales quantity is only captured by day, the continuity as a time series can be seen when observing the change (change) in the sales quantity. There is a problem that it cannot be captured.

Further, in the above-mentioned conventional order quantity determination method, since the order quantity is simply determined according to the sales quantity, what is the situation of the sales quantity with respect to the delivered quantity? There is a problem that it is not considered at all.

Therefore, the present invention has been made in view of the above-mentioned problems, and in the process of determining the order quantity of goods, the time series change of the sales quantity and the remaining quantity of the goods ordered on the same day of the previous week, etc. It is an object of the present invention to provide a remaining quantity confirmation order quantity determination method capable of determining an appropriate order quantity by confirming.

According to the remaining quantity confirmation order quantity determination method of the present invention, the operability in determining the order quantity can be improved, as will be described later.

[0007]

[Means for Solving the Problems] In order to achieve the above-mentioned object, the present invention provides a first calculating means for calculating a trend curve showing a sales trend of a product based on a sales record of the product, and a sales record of the product. Second calculating means for calculating the remaining number of products ordered last time based on the ordering and delivery results, the tendency curve calculated by the first calculating means, and the product calculated by the second calculating means And a means for determining the order quantity of this time based on the remaining quantity of the order, and a method for determining the order quantity for checking the remaining quantity.

Further, in the remaining number confirmation order quantity determination method of the present invention, it is preferable that the first calculating means corrects the tendency curve on the basis of the delivery record of goods and / or weather information.

Further, in the remaining quantity confirmation order quantity determination method of the present invention, the second calculating means calculates the remaining quantity of the products ordered on the same day of the previous week based on the sales record of the products and the order and delivery record. You should do it.

According to the remaining number confirmation order quantity determination method of the present invention having the above-mentioned structure, the continuous time-series change of the sales record of the product is expressed as a function based on the relative relationship with the delivery record of the product. Grasping and reflecting the weather information such as weather conditions to this function to obtain the sales trend of the product under the predetermined condition, and based on the sales record of the product and the ordering and delivery record, for example, the product ordered on the same day of the previous week Find the remaining number of. As a result, it is possible to determine the order quantity that matches the current situation while considering the day-of-the-week characteristics in the sales trend of the product, and improve the adequacy of the order quantity.

[0011]

Next, embodiments of the present invention will be described with reference to the drawings.

Referring to FIG. 1, the best mode for carrying out the present invention is to calculate a continuous approximate curve representing the sales trend of a product based on the sales record 103 of the product, and use the calculated approximate curve as a product. Of the order / delivery record 104 and the weather information 102 such as weather conditions to calculate the trend curve, the trend curve calculating means 105, the product sales record 103, and the product order / delivery record 104. The same day remaining number calculation means 106 for calculating the remaining number of products ordered on the same day of the previous week, the trend curve calculated by the trend curve calculating means 105, and the product remaining amount calculated by the same day remaining number calculation means 106 of the previous week Order quantity determination means 107 that determines the current order quantity from the number
And, the more appropriate order quantity is determined in consideration of the characteristics of the day of the week.

[0013]

Next, in order to more specifically describe the above-described embodiment of the present invention, an embodiment of the present invention will be described in detail with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of one embodiment of the present invention. As shown in FIG. 1, in one embodiment of the present invention, the weather information 1 in which weather conditions at the time of sale of a product are recorded.
02 and a sales record 103 in which the sales record of the product is recorded, and a sales registration unit 101 for updating the weather record 102, the sales record 103, and the order / delivery record 104 in which the order quantity and the delivery quantity of each product are recorded. From the trend curve calculating means 105 for calculating the time series characteristic of the sales trend of the product, the same day remaining number calculating means 106 for calculating the remaining number of products ordered on the same day of the previous week, the trend curve calculating means 105 and the same week of the previous week. It comprises an order quantity determination means 107 for determining the actual order quantity from the information calculated by the remaining day number calculation means 106.

Next, the operation of this embodiment will be described. Referring to FIG. 1, in the present embodiment, the sales registration means 1 stores the meteorological information such as weather conditions and the sales information, respectively.
By 01, it is recorded in the weather information 102 and the sales record 103. The order quantity of the product is recorded in the order / delivery record 104 separately from the sales record 103. In the order / delivery record 104, both the ordered quantity and the delivered quantity are recorded when the ordered goods are delivered and the quantity is fixed.

The trend curve calculation means 105 has a sales record of 10
A continuous function is calculated as an approximate curve based on the fragmentary sales information recorded in 3. The calculated approximate curve is corrected in accordance with factors such as weather conditions recorded in the meteorological information 102 and the delivery quantity recorded in the order / delivery record 104, and a trend curve representing the sales trend of the product is obtained. It is calculated.

The correction of the function based on the weather conditions is
For example, in the case of a product such as "ice cream", the order quantity is increased as the temperature rises, and the order quantity is decreased as the temperature drops, which is performed according to the characteristics of the ordered product. Also, the correction of the function based on the delivered quantity is performed by increasing the ordered quantity, for example, when the actual delivered quantity decreases due to returned goods due to damage or deformation, or when the actual delivered quantity decreases due to missing items. Be seen.

On the other hand, the remaining number calculation means 106 on the same day of the previous week is
In parallel with the processing by the trend curve calculation means 105, based on the sales record 103 and the ordering / delivery record 104, the ordered quantity, the delivered quantity, and the sales quantity of the products ordered on the same day of the previous week are the products ordered on the same day of the previous week. Calculate the remaining status of.

After that, the order quantity determining means 107 calculates a reasonable theoretical value as the current order quantity by using the information output by the above-mentioned tendency curve calculating means 105 and the remaining weekday remaining number calculating means 106 as input information. To do. That is,
The order quantity of the day is calculated by reflecting the remaining number of products ordered on the same day of the previous week in the time series change of the order quantity corrected by the weather information calculated by the tendency curve calculating unit 105 and the sales information.

The order quantity determined on the day calculated by the order quantity deciding means 107 can be manually corrected by the operator in the end, and the order quantity after the modification can be fixed is confirmed. It becomes the quantity. The output of the order quantity determination unit 107 is reflected in the order / delivery record 104.

Although one embodiment of the present invention has been described above, the present invention is not limited to such an embodiment, but includes various embodiments according to the principle of the present invention.

For example, in the above-described embodiment, in order to reflect the day-of-the-week characteristic of the product on the tendency curve, the previous week's same day calculation means 106 calculates the remaining number of products ordered on the same day of the previous week. The remaining number of products ordered last time may be simply reflected on the trend curve. Actually, when ordering and delivering more than once a week or when ordering and delivering once every two weeks, the remaining number of items ordered last time, not on the same day of the previous week, It will be calculated.

[0023]

As described above, according to the present invention,
Since the trend curve showing the sales trend is calculated, the sales trend can be continuously captured, and the transition of the sales volume can be easily simulated to realize an accurate forecast for the future.

Further, according to the present invention, since the tendency curve reflects the number of deliveries of the goods ordered on the same day of the previous week and the remaining quantity at that time, the trend curve is appropriately corrected to obtain a more appropriate order quantity. Can be determined.

[Brief description of drawings]

FIG. 1 is a block diagram showing a configuration of an embodiment of a remaining number confirmation order quantity determination system of the present invention.

[Explanation of symbols]

 101 Sales Registration Means 102 Meteorological Information 103 Sales Actuals 104 Ordering / Delivery Actuals 105 Trend Curve Calculating Means 106 Same Day Previous Week Remaining Number Calculating Means 107 Ordering Quantity Determining Means

Claims (5)

[Claims] 1. A first calculation means for calculating a trend curve showing a sales trend of a product based on a sales record of the product, and a remaining number of products ordered last time based on the sales record of the product and the ordering and delivery record. And a means for determining the current order quantity from the tendency curve calculated by the first calculation means and the remaining number of products calculated by the second calculation means. The remaining quantity confirmation order quantity determination method characterized by being equipped. 2. The first calculation means corrects the tendency curve based on a delivery record of a product.
The remaining quantity confirmation order quantity determination method described. 3. The remaining quantity confirmation order quantity determination system according to claim 1, wherein the first calculating means corrects the tendency curve based on weather information. 4. The second calculation means calculates the remaining number of products ordered on the same day of the previous week based on the sales record of the products and the ordering and delivery records. The remaining quantity confirmation order quantity determination method described in any one of the items. 5. In the process of ordering a certain product, based on the ordering result of the product, the delivery record for each order, and the sales record, the time series change and the same as the previous week, which are indicators of the day-of-week characteristic in the sales trend of the product, are the same. The remaining quantity confirmation order quantity determination method characterized in that the sales quantity of the goods is calculated from the remaining quantity of the goods ordered on the day of the week, and the order quantity is decided this time.