JPH04342064A - System and device for automatically ordering commodity - Google Patents

Abstract

PURPOSE:To provide an automatic optimum ordering system for the commodity management of commodities except perishable foods, etc. CONSTITUTION:A minimum stock predictive number and a predictive stock number on the previous day of the delivery of this-time order are compared from the delivery day of this-time order commodities, and the predictive stock number on the previous day of the delivery for next-time order and necessary irreducible minimum exhibition number are compared. When the minimum stock predictive number is larger than the predictive stock number on the previous day of the delivery of this-time order or when the minimum exhibition number is larger than the predictive stock number on the previous day of the delivery for the next-time order, an order command is issued. Difference between the maximum stock predictive number from the delivery day of this-time order commodities and the predictive stock number on the previous day of the delivery of this-time order is calculated and the larger one of these conclusions is selected. The difference between the maximum exhibition number and the predictive stock number on the previous day of the delivery for this-time order is calculated and the order command is issued by setting the value on condition that it does not exceed the conclusion as an order quantity.

Description

[Detailed description of the invention]

0001

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an automatic product ordering system and an automatic product ordering device, and more particularly to an automatic ordering system that is optimal for product management of products other than fresh foods and the like.

0002

2. Description of the Related Art Supermarkets and the like handle an extremely large number of products, and replenishment orders are frequently placed. Efforts have been made to promptly and accurately provide sales information for these replenishment orders by introducing a POS system.

0003

[Problem to be solved by the invention] However, the conventional P
Since the OS system focuses on collecting sales information, there is a problem in that it is not possible to fully physically utilize the huge amount of single item data for specific merchandising actions. That is, by simply providing product information, it is not possible to actually place replenishment orders, which is product inventory control, resulting in lost sales opportunities and a large amount of defective inventory.

[0004] Therefore, it is necessary to develop an automatic product ordering system and an automatic product ordering device that can not only save labor and improve efficiency at the operational level through a simple POS system, but also automatically place replenishment orders in consideration of fluctuations in sales. It was strongly desired.

[0005]

[Means for Solving the Problems] The present invention has been devised in view of the above-mentioned problems, and it is possible to calculate the minimum predicted stock quantity from the delivery date of the product ordered this time and the predicted stock quantity on the day before the delivery date of the currently ordered product. A first step of comparing, a second step of comparing the predicted stock quantity on the day before the delivery date for the next order and the required minimum display quantity;
The process consists of a third process in which orders are issued based on the conclusions compared in the first process and the conclusions compared in the second process. If the number is greater than the predicted inventory on the day before the delivery date of the current order, or if the conclusion of the second process is that the minimum display quantity is greater than the predicted inventory on the day before the delivery date for the next order, issue an ordering command. It is characterized by

[0006] The present invention also includes a first step of calculating the difference between the predicted maximum stock quantity from the delivery date of the currently ordered product and the predicted stock quantity on the day before the delivery date of the currently ordered product; a second process that calculates the difference between the predicted inventory quantity on the day before the delivery date for the ordered quantity; a third process that selects the larger value of the conclusion of the first process and the conclusion of the second process; The fourth step is to calculate the difference between the number of items on display and the predicted stock amount on the day before the delivery date for the current order, and the third step is to
It is characterized by comprising a fifth step of issuing an ordering command using the value of the process as the order quantity.

[0007]Furthermore, the present invention includes a first step of comparing the predicted minimum inventory quantity from the day before the delivery date of the product ordered this time with the predicted inventory quantity from the day before the delivery date of the current order; A second process that compares the predicted stock quantity for the day and the required minimum display quantity, and a third process that issues an order order based on the results compared in the first process and the second process. In the third step, the conclusion of the first step is that the minimum predicted inventory quantity is greater than the predicted inventory quantity on the day before the delivery date of the current order, or the conclusion of the second step is that the minimum display quantity will be higher next time. If the number of items in stock is larger than the predicted inventory on the day before the delivery date for the ordered item, an ordering command will be issued, and based on the ordering command in the third process,
The predicted maximum inventory quantity from the day before the delivery date of the product ordered this time,
A fourth step of calculating the difference between the predicted stock quantity on the day before the delivery date of the current order, a fifth process of calculating the difference between the minimum display quantity and the predicted stock quantity on the day before the delivery date of the next order, and The 6th process selects the larger value of the conclusions of the 4th process and the 5th process, and the 6th process calculates the difference between the maximum display quantity and the predicted stock quantity on the day before the delivery date for the current order. It is characterized by consisting of 7 steps and an 8th step in which the order amount is issued using the value of the 6th step under the condition that the value of the conclusion of the 7th step is not exceeded.

Furthermore, the eighth step of the automatic product ordering system may be configured to display the order amount prior to instructing the order amount, and to issue the order amount after confirmation by the user.

[0009] Furthermore, in the eighth step of the automatic product ordering system, the order quantity is displayed before the order quantity is instructed, and the order quantity is displayed after the user's confirmation or in the absence of the user's confirmation. It can also be configured to issue commands.

[0010] According to the present invention, the predicted stock quantity on the day before the delivery date for the next order is calculated by adding the stock quantity on the previous day of the current order date and the scheduled delivery quantity, and from this added value, calculates the predicted stock quantity on the day before the delivery date for the next order from the order date. It may also be calculated by subtracting the cumulative predicted sales numbers up to the day before.

[0011] Furthermore, the sales forecasting system of the present invention calculates the first period, which is the maximum number of inventory days added to the number of days from the order date to the day before the delivery date of the current order, and the period from the order date to the delivery date of the next order. The first step is to compare the second period and select a longer period, the second step is to set each day of the week for the period selected in the first step, and the relatively recent sales performance of the corresponding product is read. The third step and the classification including the applicable product,
It consists of a fourth step of calculating an index of annual sales trends, and a fifth step of calculating the predicted sales number of the corresponding product based on the index of the fourth step.

[0012] Furthermore, the predicted inventory quantity or cumulative predicted sales quantity can also be calculated using the above sales forecasting system.

[0013] The automatic product ordering device of the present invention includes an input means for inputting the order date, delivery date, minimum number of displayed items, maximum number of displayed items, the number of items in stock on the previous day of the order date, and the number of scheduled items to be delivered. A first calculation processing means for comparing the predicted minimum stock quantity from the delivery date of the product with the predicted stock quantity on the day before the delivery date of the current order, and the predicted stock quantity on the day before the delivery date for the next order, and the necessary and a control means for instructing order placement based on the conclusions of the first arithmetic processing means and the second arithmetic processing means. The conclusion of the first arithmetic processing means is that the minimum predicted inventory quantity is greater than the predicted inventory quantity on the day before the delivery date of the current order, or
If the conclusion of the second arithmetic processing means is that the minimum display quantity is greater than the predicted stock quantity on the day before the delivery date for the next order, an ordering command is issued, and based on the ordering command of the control means,
A third calculation processing means for calculating the difference between the predicted maximum inventory quantity from the delivery date of the product ordered this time and the predicted inventory quantity from the day before the delivery date of the current order, and the minimum display quantity and the delivery date for the next order. and a fourth arithmetic processing means for calculating the difference between the predicted inventory quantity for the day, and the control means selects the larger value of the conclusion of the third arithmetic processing means and the conclusion of the fourth arithmetic processing means. , and the value selected by the control means under the condition that the value does not exceed the conclusion of the fifth calculation processing means that calculates the difference between the maximum display quantity and the predicted stock quantity on the day before the delivery date for the current order. It is characterized by outputting a command as the order quantity.

Further, in the present invention, a display device for displaying the order quantity and an instruction input means are connected to the control means, and after the user confirms the order quantity, a signal is sent from the instruction input means. By inputting , the control means can be configured to output an order amount command.

[0015]

[Operation] The present invention configured as described above compares the predicted minimum inventory quantity from the delivery date of the product ordered this time with the predicted inventory quantity on the day before the delivery date of the current order, and then The system compares the predicted stock quantity from the previous day with the required minimum display quantity, and orders are issued based on the conclusion of these comparisons. The system is characterized in that an ordering command is issued when the quantity is larger than the stock quantity or when the minimum display quantity is larger than the predicted stock quantity on the day before the delivery date for the next order.

[0016] Furthermore, the present invention calculates the difference between the predicted maximum stock quantity from the delivery date of the product ordered this time and the predicted stock quantity on the day before the delivery date of the current order, and calculates the minimum display quantity and the quantity for the next order. Calculate the difference between the predicted stock quantity on the day before the delivery date and select the larger value from the conclusions of these calculations. The difference is calculated, and an order is issued with the selected value as the order amount, provided that the resulting value is not exceeded.

Furthermore, the automatic product ordering system can display the order amount prior to instructing the order amount, and issue the order amount after confirmation by the user.

[0018] Furthermore, the automatic product ordering system may display the order amount prior to instructing the order amount, and issue the order amount after the user's confirmation or in the absence of the user's confirmation. You can also do it.

[0019] In the present invention, the predicted stock quantity on the day before the delivery date for the next order is calculated by adding the stock quantity on the previous day of the current order date and the scheduled delivery quantity, and from this added value, the predicted stock quantity on the day before the delivery date for the next order is calculated from the order date. It can be calculated by subtracting the cumulative predicted sales numbers up to the previous day.

[0020] Furthermore, the sales forecasting system of the present invention calculates the first period by adding the maximum inventory days to the number of days from the order date to the day before the delivery date of the current order, and the period from the order date to the delivery date of the next order. Compare the second period, select a longer period, set each day of the week for the selected period, load relatively recent sales results for the relevant product, and annual sales trends for the category that includes the relevant product. The index is calculated, and based on this index, the predicted sales volume of the corresponding product is calculated.

[0021] Furthermore, the predicted inventory quantity or cumulative predicted sales quantity can also be calculated using the above sales forecasting system.

[0022] In the automatic product ordering device of the present invention, the input means inputs the order date, the delivery date, the minimum number of displays, the maximum number of displays, the number of stocks on the day before the order date, and the number of scheduled deliveries, and performs the first calculation process. The means compares the minimum predicted stock quantity from the delivery date of the product ordered this time with the predicted stock quantity on the day before the delivery date of the current order,
The second arithmetic processing means compares the predicted stock quantity on the day before the delivery date for the next order with the required minimum display quantity, and the control means:
Based on the conclusions of the first arithmetic processing means and the second arithmetic processing means,
The control means is configured to issue an ordering command, and the control means determines whether the conclusion of the first arithmetic processing means is that the minimum predicted stock quantity is greater than the predicted stock quantity on the day before the delivery date of the current order, or the second arithmetic processing means If the conclusion of the means is that the minimum display quantity is greater than the predicted stock quantity on the day before the delivery date for the next order, an ordering command is issued, and the third calculation means, based on the ordering command of the control means, The fourth calculation means calculates the difference between the predicted maximum inventory quantity from the delivery date of the product ordered this time and the predicted inventory quantity from the day before the delivery date of the current order, and calculates the minimum display quantity and the delivery date for the next order. The control means calculates the difference between the predicted inventory quantity for the day and
The larger value is selected between the conclusion of the arithmetic processing means and the conclusion of the fourth arithmetic processing means, and the maximum number of displays and
The control means outputs a command with the selected value as the order quantity under the condition that the result of the fifth calculation processing means that calculates the difference between the predicted stock quantity on the day before the delivery date for the current order is not exceeded. It has become.

Furthermore, in the present invention, the display device connected to the control means displays the order amount, and after the user confirms the order amount,
The control means outputs an order quantity command based on a signal input from the user's instruction input means.

[0024]

[Calculation of sales forecast]

[0025] Here, the calculation of the predicted number of sales will be explained.

First, the number of days from the current order date to the day before the delivery date of the current order and the maximum inventory days are added together to define the number of days in the first period. Then, the number of days from the current order date to the delivery date of the next order is defined as the number of days in the second period. The number of days in the first period and the number of days in the second period are compared, the larger one is taken as the number of days in the period, and each day of the week is determined.

Next, based on the data on the number of sales for each day of the week, the number of sales for the days of the week until the delivery date of the next order is predicted. That is, the predicted number is calculated by indexing the sales amount at the company-wide/category level based on data for each of the past 56 weeks. This prediction method will be explained in detail based on a specific example.

As shown in FIG. 5, the sales of the products to be predicted (for each individual product) for the most recent week are investigated. Next, sales trends are calculated for each subcategory from the annual data. Here, the subclassification is a category subclassification that includes the prediction target product. In this example, the sales increase from 1.80 to 1.92 for the corresponding 52nd week before and 53rd week before. If we calculate this sales trend, we get (1.92/
1.80=1.067), and the index is 1.067. Therefore, for the sales for each day of the week in the most recent week,
Multiply this index to predict sales for each day of the week. For example, the sales on the most recent Monday is 10, so this 10
Multiplying by the index 1.067 gives 10.67, and by rounding this value, the expected number of sales for Monday is 1.
It becomes 1. If the expected sales for each day of the week are calculated using this method, the result will be as shown in FIG.

[0029] What should be noted in this prediction calculation is:

00
30] (1) If the prediction target day is a substitute holiday, or if the prediction target day is Monday to Friday but is a public holiday, the previous week's actual result is set to Sunday. This is because substitute holidays and holidays are holidays, so sales trends are extremely different.
This is because it should be based on Sunday sales.

(2) If the prediction target days are from Monday to Friday and the previous week's performance is a substitute holiday or holiday, the previous week is taken as the previous week's performance, and the trend value is also determined from that week. Similarly, data for holidays should not be used for weekdays.

(3) If the prediction target day is a store holiday, the predicted value is set to zero.

(4) If the previous week's performance is a store holiday, the previous week's performance is further used, and the trend value is also determined based on that week.

(5) If the previous week's performance is a sale day, the previous week's performance is further used, and the trend value is also determined based on that week. This is because sales trends vary greatly on sale days.

(6) If the previous week's performance is a unique day, the previous week's performance is further used, and the trend value is also determined based on that week. Here, an unusual day is a case where sales fluctuate abnormally due to a typhoon or the like. Special days can also be set by the person in charge for each store.

0036 “Handling of new stores and closed stores”

0
(1) When a new store opens

(a)
For the week in which a new store occurs, it is necessary to correct the actual results as follows.

[0038] Corrected performance = (all store sales - new store sales) x (existing store small category composition ratio/100) Here, all store sales are the sum of all stores and all categories,
New store sales are the total of all categories at new stores. In addition, the existing store small category composition ratio indicates the composition ratio of all category sales only for stores that have had a track record in the past 56 weeks.

(b) For the week following the opening of a new store, the actual results are corrected as follows.

[0040] Corrected performance = (all stores sales - new store sales) x (all stores small category composition ratio/100).

(2) When a store closes down

[0042] Corrected performance = Total store sales x ((Total store sales in the month before store closures – Closing store sales in the month before store closures) / Total store sales in the month before store closures) × (All store small category composition ratio/100) shall be.

[0043]

[Example] An example of the present invention will be explained.

First, the minimum number of days in stock, the maximum number of days in stock, the minimum display standard, and the maximum display standard are registered for each store and product. However, the minimum display standard and the maximum display standard are for correction purposes and are not necessarily set, and the maximum display standard is generally not set.

Next, the sales forecast calculation described above is performed and the order amount is calculated.

Before calculating the order amount, it is determined whether or not to place an order.

0047 “Ordering conditions”

(a) Minimum predicted inventory quantity from the day before the delivery date of the current order>Predicted inventory quantity from the day before the delivery date of the current order. (1st formula)

(b) Minimum display number > (Inventory quantity on the day before the current order date + Scheduled delivery quantity - Cumulative sales forecast from the current order date to the day before the delivery date of the next order) (2nd formula)

[
##EQU1## If the condition (a) or (b) is satisfied, the ordering condition is satisfied.

Note that the predicted minimum inventory quantity in (a) is calculated by adding the predicted daily sales quantity for each number of days from the calculation reference date. The numbers below the decimal point are calculated by multiplying the predicted number of sales on the last forecast day by the value below the decimal point. Condition (a) is when the predicted stock quantity is less than the minimum stock quantity on the day before the delivery date, and condition (b) is when the forecast stock quantity on the day before the delivery date for the next order is less than the minimum display quantity. This is the case when the amount becomes smaller.

0052 “Order quantity calculation”

[0053] When the above ordering conditions are met, the order amount is calculated.

(c) Maximum predicted stock quantity from the delivery date of the product ordered this time - predicted stock quantity on the day before the delivery date of the current order
(3rd formula)

(d) Minimum display number - (Inventory quantity on the day before the current order date + Expected delivery quantity - Cumulative sales forecast from the current order date to the day before the next order delivery date) (Formula 4)

[
(e) Calculate (c) and (d) above, select the larger one, and this value is

[0057] The order quantity is calculated so as not to exceed the value of maximum display number - (inventory quantity on the day before the current order date + scheduled delivery quantity - cumulative sales forecast from the current order date to the day before the current order delivery date). .

[0058] That is, in principle, of (c) or (d),
The order quantity is the larger one, and if it exceeds the value of maximum display quantity - (inventory quantity on the day before the current order date + expected delivery quantity - cumulative sales forecast from the current order date to the day before the current order delivery date), The value is taken as the limit value and the order quantity.

[0059] Here, (inventory quantity on the day before the current order date + expected delivery quantity - predicted cumulative sales from the current order date to the day before the current order delivery date) is the predicted inventory on the day before the delivery date for the current order. It is a number. Further, in (c), the predicted maximum inventory quantity until the delivery date of the currently ordered product is calculated by adding the predicted daily sales quantity for each number of days from the calculation reference date. The numbers below the decimal point are calculated by multiplying the predicted number of sales on the last forecast day by the value below the decimal point.

Next, specific calculations of this embodiment will be explained based on the drawings. Figure 1 shows the prerequisite conditions for calculating the order quantity. In this example, for the three products ■, ■, and ■, the order date, delivery date, minimum number of stock days, maximum number of stock days, minimum number of displays, maximum number of displays, number of stocks on the day before the current order date, and delivery schedule are determined. It will be done.

FIG. 2 shows the results of the above-mentioned predicted sales calculation for the product shown in FIG. Furthermore, the minimum stock quantity from the current order delivery date and the maximum stock quantity from the current order delivery date are calculated. For convenience, ■products are calculated as if they were ordered on Monday.

0062 “Minimum predicted inventory quantity from the current order delivery date”

First, the predicted minimum stock quantity from the current order delivery date is calculated.

[0064] Since the delivery dates for the item (■) are Wednesday and Saturday, adding up the four days and totaling the predicted sales from Wednesday to Saturday shown in Figure 2 is 14+16+11+
21 becomes 62.

[0065] Therefore, the minimum predicted inventory quantity from the current order delivery date is 62.

[0066] Next, the predicted stock quantity of the item (2) is calculated. The predicted inventory quantity is

[0067] Forecast inventory quantity = (Inventory quantity on the day before the current order date + Scheduled delivery quantity) - (Sales forecast from the current order date to the day before the current order delivery date) (Formula 5)

006
8], read the previous day's stock quantity and scheduled delivery quantity from Figure 1, and read this sales forecast from Figure 2, as ■The order date for the product is Monday and the day before the delivery date is Tuesday. ,

[0069] Forecast inventory quantity = (80 + 5) - (11 + 13
)=61.

Therefore, the minimum inventory quantity (62) from the current order delivery date is greater than the predicted inventory quantity (61).

[0071] Similarly, if we calculate for the products ■ and ■, we get

■For the product, the minimum stock quantity from the current order delivery date = (0 + 0), the predicted stock quantity = (5 + 3 - 0), and the minimum stock quantity from the current order delivery date (0) < predicted stock quantity (8) becomes.

■The minimum stock quantity for the product from the current order delivery date = (100 + 100), and the predicted stock quantity = (5 + 3).
-0), and the minimum stock quantity from the current order delivery date (20
0)<Predicted inventory quantity (0).

[0074] Furthermore, if the sales forecast from the current order date to the day before the current order delivery date is greater than the inventory quantity on the day before the current order date + scheduled delivery quantity, the sales forecast from the current order date to the day before the current order delivery date is greater than the inventory quantity on the day before the current order date + scheduled delivery quantity.
The expected number of deliveries is the predicted number of sales.

0075 “Maximum predicted stock quantity from the current order delivery date”

Next, (1) calculate the maximum stock quantity of the product from the current order delivery date. Calculate by substituting the sales forecast in Figure 2. In other words, since the delivery dates of the product (■) are Wednesday and Saturday, adding 5 days' worth of items will result in the predicted maximum inventory quantity from the current delivery date to be (14+16+11+21+32). Furthermore, the predicted stock quantity is (80 + 5 - 11 - 13) from formula 5, so (maximum predicted stock quantity from the delivery date of the product ordered this time - predicted stock quantity on the day before the delivery date of the current order) = (14 +
16+11+21+32)-(80+5-11-13)
=31.

[0077] Here, the maximum predicted stock quantity from the delivery date of the product ordered this time - the predicted stock quantity on the day before the delivery date of the current order = M
Defining the AX inventory standard, the MAX inventory standard for the product ■ is,

MAX inventory standard=(0+0+0)-(8-
0)=-8→→→0

[0079] The MAX inventory standard for the product ■ is as follows:

0080
]MAX=(100+100+50)-(8-100)
=250 0

[0081]

“Minimum display standards”

Next, the minimum display standards will be explained. First, it is necessary to obtain a cumulative sales forecast from the current order date to the current order delivery date. Furthermore, it is necessary to obtain and add the cumulative sales forecast from the current order delivery date to the day before the next order delivery date.

[0084] If the sum of the inventory quantity and the scheduled delivery quantity on the day before the current order date is smaller than the sales forecast number, the sales forecast from the current order date to the day before the delivery date of the current order is used as the first sales forecast number. shall be.

[0085] That is,

[0086] First sales forecast number = cumulative sales forecast from the current order date to the day before the delivery date of the current order,

0087
]Second sales forecast number = Accumulation of sales forecasts from the current order delivery date to the day before the next order delivery date.

[0088] Then, the sales forecast is

[0089] Cumulative sales forecast = 1st sales forecast + 2nd sales forecast

0090, and the minimum display standards are:

[0091] Minimum display standard = Minimum number of displays - (Inventory quantity on the day before the current order date + Scheduled delivery quantity - Cumulative sales forecast)
(7th formula)

0
092].

[0093] Regarding the above products ■, ■, ■,
Let us perform some concrete calculations. Regarding the product ■, the first sales forecast is that the order date is Monday and the day before the delivery date is Tuesday.

[0094] First sales forecast = 11 + 13 = 24

009
5] Since the delivery date is Wednesday and the day before the delivery date of the next order is Friday, the second sales forecast = 14 + 16 + 11 = 38

[0096] Therefore, cumulative sales forecast=24+38=62.

[0097] From the seventh formula, the minimum display standard is

0098
]Minimum display standard=10-(80+5-62)=-13
→→0

[0099]

[0100] In the same way, ■ If you calculate the minimum display standards for the product,

[0101] Minimum display standard=10-(5+3-0)=2

[0102]

[0103]Furthermore, ■Calculating the minimum display standards for the product:
In this case, the sum of the inventory quantity and the scheduled delivery quantity on the day before the current order date is 8, which is smaller than the sales forecast number 100, so the first sales forecast is set to 8 and the second sales forecast is set to 100. As a result, the cumulative sales forecast is 108,

Minimum display standard=10-(5+3-108)=110.

0105 “Maximum display standards”

Next, calculate the maximum display criterion.

[0107] The cumulative sales forecast from the current order date to the day before the current order delivery date is calculated.

[0108] That is,

[0109] Maximum display standard = Maximum number of displays - (Inventory quantity on the day before the current order date + Scheduled delivery quantity + Cumulative sales forecast from the current order date to the day before the current order delivery date) (Formula 8)

0110
] Calculate as. In addition, the number of items in stock on the day before the order date +
Scheduled delivery quantity - If the cumulative sales forecast from the current order date to the day before the current order delivery date is negative, it will be set to zero.

[0111] Specifically, for the product ■, the cumulative sales number = 11 + 14 = 24, and by substituting it into the 8th equation,

[0112] Maximum display standard = 200 - (80 + 5 - 24) = 139

[
[0113]

[0114] Similarly, the product ■ is

[0115] Maximum display standard=20-(5+3-0)=1
2

[0116] Furthermore, the products marked with ■ are:

[0117] Maximum display standard = 20 - (5 + 3 - 100) = 20

01
18] becomes 0.

[0119] If the inventory quantity on the day before the current order date is negative, it is calculated as 0.

0120] “Order quantity calculation”

[0121] In other words, the fourth formula corresponds to the minimum display standard, so the order quantity calculation is as follows:

(c) Maximum predicted stock quantity until the delivery date of the product ordered this time - predicted stock quantity on the day before the delivery date of the current order = MA
X inventory standard (3rd formula)

(d) Minimum display standards
(4th formula)

(e) Above (c) and (
d) is calculated, the larger of the MAX inventory standard and the minimum display standard is selected, and the order quantity is determined within a range where this value does not exceed the maximum display standard.

[0125] Therefore, in the case of the product (■), the predicted maximum inventory quantity is 94 and the predicted inventory quantity is 61, so when calculating the third formula, MAX inventory standard = (94-61) = 33, Furthermore, since the minimum display standard is 0, the larger 33 is selected, and since the maximum display standard of 139 is not exceeded, the number of orders is set to 33.

[0126] Similarly, the MAX inventory standard for the item ■ is 0, the minimum display standard is 2, and the maximum display standard is 1.
2, the order quantity is 2.

[0127] And ■ The MAX inventory standard for the product is 250, the minimum display standard is 110, and the maximum display standard is 2.
0, the order amount is 2 as a result of the maximum display standard restriction.
It becomes 0.

Note that the products marked ■ and the products marked ■ satisfy the ordering conditions of the first formula, and the products marked ■ satisfy the ordering conditions of the second formula. In addition, the conclusion of the calculation is summarized as follows.
FIG.

Next, the automatic product ordering device will be explained based on FIG. 4. The automatic product ordering device of this embodiment includes an input means 1, a first arithmetic processing means 2, a second arithmetic processing means 3, a third arithmetic processing means 4, a fourth arithmetic processing means 5,
A fifth arithmetic processing means 6, a control means 7, a display means 8,
It consists of an instruction input means 9.

[0130] Input means 1 is for inputting order date, delivery date, minimum number of days in stock, maximum number of days in stock, minimum number of display items, maximum number of display items, number of items in stock on the day before the order date, number of scheduled items to be delivered, etc. . The first arithmetic processing means 2 is for comparing the predicted minimum stock quantity from the delivery date of the currently ordered product with the predicted stock quantity on the day before the delivery date of the currently ordered product. The second arithmetic processing means 3 is for comparing the predicted stock quantity for the next order on the day before the delivery date with the required minimum display quantity. Third
The calculation processing means 4 is for calculating the difference between the predicted maximum stock quantity from the delivery date of the currently ordered product and the predicted stock quantity on the day before the delivery date of the currently ordered product. The fourth calculation processing means 5 is for calculating the difference between the minimum display quantity and the predicted stock quantity on the day before the delivery date for the next order. The fifth arithmetic processing means 6 is for calculating the difference between the maximum display quantity and the predicted stock quantity on the day before the delivery date for the current order. The control means 7 issues an order order based on the conclusions of the first arithmetic processing means 2 and the second arithmetic processing means 3, and the conclusion of the first arithmetic processing means 2 indicates that the minimum predicted inventory quantity is the day before the delivery date of the current order. is larger than the predicted stock quantity, or the second arithmetic processing means 3
This is for issuing an ordering instruction when the conclusion of This is for selecting the larger value among the conclusions of the fourth arithmetic processing means 5 and outputting the selected value as an order amount under the condition that it does not exceed the value of the conclusion of the fifth arithmetic processing means 6. It is. Further, a display means 8 is connected to the control means 7, and is capable of displaying the order amount and the like. An instruction input means 9 is connected to the control means 7, and after displaying the order amount on the display means 8, a command for the order amount is outputted based on an input by the instruction input means 9, which is the user's intention to confirm. It looks like it will. This is a semi-automatic replenishment ordering operation;
It is suitable for products that have a high standard but are expensive, new products, etc., and whose sales are difficult to grasp. In addition, items with a short shelf life,
Ideal for products that would result in large losses if unsold. Furthermore, it is also possible to output the order amount completely automatically without any input from the instruction input means 9. This automatic order replenishment operation is suitable for products that are highly standard and can be sold and supplied stably. After the user confirms the order amount, it is also possible to adopt a system in which the order is not placed unless the user inputs a turnaround. This manual ordering is suitable for products that cannot be ordered without confirmation from the supplier. Furthermore, in the case of 0 sales due to a stockout, the system can be configured to switch from automatic or semi-automatic operation to manual ordering and issue a warning. Furthermore, in the semi-automatic replenishment ordering operation, if there is no input from the instruction input means 9 within a certain period of time, an arrangement may be made in which the order is automatically placed.

Note that the first arithmetic processing means 2, the second arithmetic processing means 3, the third arithmetic processing means 4, the fourth arithmetic processing means 5, the fifth arithmetic processing means 6, and the control means 7 are , may be composed of separate arithmetic processing means, but it is also possible to have a structure in which they are shared by one electronic computer.

[0132]

[Effects] The present invention configured as described above includes the first step of comparing the predicted minimum stock quantity from the delivery date of the currently ordered product with the predicted stock quantity on the day before the delivery date of the currently ordered product; The second step is to compare the predicted stock quantity on the day before the delivery date for the order and the required minimum display quantity, and the second step is to compare the results of the comparison in the first step and the second step.
The third step is to issue orders based on the results compared in the process.
The third step is whether the conclusion of the first step is that the minimum predicted stock quantity is greater than the predicted stock quantity on the day before the delivery date of the current order, or the conclusion of the second step is that the minimum display Since the system is configured to issue an ordering command when the number of items in stock is larger than the predicted stock quantity on the day before the delivery date for the next order, there is an effect that it is possible to automatically determine when a replenishment order is necessary.

[0133] The present invention also includes a first step of calculating the difference between the predicted maximum stock quantity from the delivery date of the currently ordered product and the predicted stock quantity on the day before the delivery date of the currently ordered product, the minimum display quantity, and the next a second process that calculates the difference between the predicted inventory quantity on the day before the delivery date for the ordered quantity; a third process that selects the larger value of the conclusion of the first process and the conclusion of the second process; The fourth step is to calculate the difference between the number of items on display and the predicted stock amount on the day before the delivery date for the current order, and the third step is to
Since the process includes the fifth step of issuing an ordering command using the value of the process as the ordering amount, there is an effect that the optimum replenishment ordering amount can be automatically calculated and ordering processing can be performed.

[0134] Furthermore, the automatic product ordering system can be configured to display the order quantity before issuing the order quantity command, and then issue the order quantity command after the user's confirmation. It has the advantage of being able to flexibly deal with high-priced products, new products, etc. whose sales are difficult to grasp, and ideal for products with a short shelf life or products that would result in large losses if unsold.

[0135] Furthermore, in the eighth step of the automatic product ordering system, the order quantity is displayed before the order quantity is instructed, and the order quantity is displayed after the user's confirmation or in the absence of the user's confirmation. It is also possible to configure the system to issue commands, which has the effect of preventing forgetting to place orders and reducing chance losses.

[0136] Furthermore, the sales forecasting system of the present invention calculates the first period by adding the maximum inventory days to the number of days from the order date to the day before the delivery date of the current order, and the period from the order date to the delivery date of the next order. The first step is to compare the second period and select a longer period, the second step is to set each day of the week for the period selected in the first step, and the relatively recent sales performance of the corresponding product is read. The third step and the classification including the applicable product,
It consists of a fourth step of calculating an index of annual sales trends, and a fifth step of calculating the predicted sales volume of the corresponding product based on the index of the fourth step, so sales can be predicted with simple calculations. be able to.

[0137] The automatic product ordering device of the present invention includes an input means for inputting an order date, a delivery date, a minimum number of displayed items, a maximum number of displayed items, the number of items in stock on the previous day of the ordering date, and the number of scheduled items to be delivered. A first calculation processing means for comparing the predicted minimum stock quantity from the delivery date of the product with the predicted stock quantity on the day before the delivery date of the current order, and the predicted stock quantity on the day before the delivery date for the next order, and the necessary and a control means for instructing order placement based on the conclusions of the first arithmetic processing means and the second arithmetic processing means. The conclusion of the first arithmetic processing means is that the minimum predicted inventory quantity is greater than the predicted inventory quantity on the day before the delivery date of the current order, or
If the conclusion of the second arithmetic processing means is that the minimum display quantity is greater than the predicted stock quantity on the day before the delivery date for the next order, an ordering command is issued, and based on the ordering command of the control means,
A third calculation processing means for calculating the difference between the predicted maximum inventory quantity from the delivery date of the product ordered this time and the predicted inventory quantity from the day before the delivery date of the current order, and the minimum display quantity and the delivery date for the next order. and a fourth arithmetic processing means for calculating the difference between the predicted inventory quantity for the day, and the control means selects the larger value of the conclusion of the third arithmetic processing means and the conclusion of the fourth arithmetic processing means. , and the value selected by the control means under the condition that the value does not exceed the conclusion of the fifth calculation processing means that calculates the difference between the maximum display quantity and the predicted stock quantity on the day before the delivery date for the current order. Since the system is configured to output a command using the order amount as the order amount, the order amount can be automatically calculated, which is extremely effective for products that are highly standard and can be sold and supplied stably.

Further, in the present invention, a display device for displaying the order quantity and an instruction input means are connected to the control means, and after the user confirms the order quantity, a signal is sent from the instruction input means. Since the control means is configured to output an order quantity command by inputting , it has the outstanding effect of being able to respond flexibly even to products whose sales are difficult to grasp.

[0139]

[Brief explanation of drawings]

FIG. 1 is a diagram showing conditions that are prerequisites for replenishment order calculation.

FIG. 2 is a diagram showing the results of calculating sales forecasts.

FIG. 3 is a diagram showing replenishment order calculation.

FIG. 4 is a diagram showing the configuration of an automatic product ordering device.

FIG. 5 is a diagram illustrating sales forecasting.

[Explanation of symbols]

1 Input means 2 First arithmetic processing means 3 Second arithmetic processing means 4 Third calculation processing means 5 Fourth arithmetic processing means 6 Fifth arithmetic processing means 7 Control means 8 Display means 9 Instruction input means

Claims (10)

[Claims] [Claim 1] A first step of comparing the minimum predicted inventory quantity from the delivery date of the product ordered this time with the predicted inventory quantity the day before the delivery date of the current order, and the predicted inventory quantity the day before the delivery date of the next order. The process consists of a second process in which the number is compared with the required minimum display number, and a third process in which an order is issued based on the results compared in the first process and the second process. ,
In the third step, the conclusion of the first step is that the minimum predicted stock quantity is greater than the predicted stock quantity on the day before the delivery date of the current order, or the conclusion of the second step is that the minimum display quantity is the same as the next order. An automatic product ordering system that issues an ordering command when the number of stock is larger than the predicted stock quantity on the day before the delivery date. [Claim 2] A first step of calculating the difference between the predicted maximum stock quantity from the delivery date of the currently ordered product and the predicted stock quantity on the day before the delivery date of the currently ordered product, the minimum display quantity, and the next order quantity. a second step of calculating the difference between the expected inventory quantity on the day before the delivery date;
The third step is to select the larger value between the conclusion of the first step and the conclusion of the second step, and the difference between the maximum display quantity and the predicted stock quantity on the day before the delivery date for the current order is calculated. The fourth step,
An automatic product ordering system comprising a fifth step of issuing an ordering command using the value of the third step as the order amount under conditions that the value of the conclusion of the fourth step is not exceeded. [Claim 3] A first step of comparing the predicted minimum inventory quantity from the day before the delivery date of the product ordered this time with the predicted inventory quantity from the day before the delivery date of the current order, and a prediction from the day before the delivery date for the next order. It has a second process of comparing the inventory quantity and the required minimum display quantity, and a third process of issuing an order order based on the results compared in the first process and the conclusions compared in the second process. , 3rd
The process is that the conclusion of the first process is that the predicted minimum stock quantity is greater than the predicted stock quantity on the day before the delivery date of the current order, or the conclusion of the second process is that the minimum display quantity is before the delivery date of the next order. If it is larger than the predicted stock quantity for the current day, an ordering command will be issued.Based on the ordering command in the third process, the predicted maximum stock quantity from the day before the delivery date of the product ordered this time and the delivery date of the current order will be issued. a fourth step of calculating the difference between the predicted stock quantity for the day;
A fifth step of calculating the difference between the minimum display quantity and the predicted stock quantity on the day before the delivery date for the next order, the conclusion of the fourth step, and the fifth step.
a sixth step of selecting the larger value among the conclusions of the steps;
The 7th process calculates the difference between the maximum display quantity and the predicted stock quantity on the day before the delivery date for the current order, and the value of the 6th process is used as the order quantity under the condition that the value of the conclusion of the 7th process is not exceeded. An automatic product ordering system characterized by comprising an eighth step of issuing instructions. 4. The eighth step of the automatic product ordering system according to claim 3, in which the order amount is displayed before the order amount is instructed, and the order amount is instructed after confirmation by the user. automatic product ordering system. [Claim 5] The eighth step of the automatic product ordering system according to claim 3 displays the order quantity prior to the instruction of the order quantity, and after the user's confirmation or in the absence of the user's confirmation. 4. The automatic product ordering system according to claim 3, wherein the order amount is instructed. [Claim 6] The predicted stock quantity on the day before the delivery date for the next order is calculated by adding the stock quantity on the day before the current order date and the scheduled delivery quantity,
Claims 1 and 5 calculated by subtracting the cumulative predicted sales volume from the order date to the day before the next order delivery date from this additional value.
Automatic product ordering system as described. [Claim 7] Compare a first period, which is the number of days from the order date to the day before the delivery date of the current order, plus the maximum inventory days, and a second period, which is the period from the order date to the next order delivery date, The first step is to select a long period; the second step is to set each day of the week for the period selected in the first step; the third step is to read relatively recent sales results for the corresponding product; A fourth step that calculates an index of annual sales trends for categories that include products.
A sales prediction system comprising a step and a fifth step of calculating the predicted sales number of the corresponding product based on the index of the fourth step. [Claim 8] Claim 7 for the predicted inventory quantity or cumulative predicted sales quantity.
7. The automatic product ordering system according to claim 1, wherein the automatic product ordering system is operated using a sales forecasting system. Claim 9: Input means for inputting order date, delivery date, minimum number of displays, maximum number of displays, inventory on the day before the order date, scheduled delivery quantity, and minimum inventory from the delivery date of the currently ordered product. A first arithmetic processing means for comparing the predicted quantity with the predicted stock quantity on the day before the delivery date of the current order, and the predicted stock quantity on the day before the delivery date of the next order with the required minimum display quantity. and a control means for instructing order placement based on the conclusions of the first arithmetic processing means and the second arithmetic processing means. , the minimum predicted stock quantity is greater than the predicted stock quantity on the day before the delivery date of the current order, or the conclusion of the second arithmetic processing means is that the minimum display quantity is greater than the predicted stock quantity on the day before the delivery date for the next order. Based on the ordering command of the control means, the system calculates the difference between the predicted maximum inventory quantity from the delivery date of the product ordered this time and the predicted inventory quantity the day before the delivery date of the current order. a third arithmetic processing means for calculating the difference between the minimum display quantity and the predicted stock quantity on the day before the delivery date for the next order;
the control means selects the larger value of the conclusion of the third arithmetic processing means and the conclusion of the fourth arithmetic processing means, and the control means selects the larger value of the conclusion of the third arithmetic processing means and the conclusion of the fourth arithmetic processing means, and determines the maximum number of displayed items and the current order. The control means outputs a command using the selected value as the order amount under conditions that the value does not exceed the conclusion of the fifth calculation processing means that calculates the difference between the predicted stock quantity and the predicted stock quantity on the day before the delivery date. Automatic product ordering device. 10. A display device for displaying the order quantity and an instruction input means are connected to the control means, and after the user confirms the order quantity, a signal is input from the instruction input means. 10. The automatic product ordering device according to claim 9, wherein the control means outputs an order quantity command.