JP2023090554A - Sales support system and sales support method - Google Patents

Abstract

To provide a sales support system capable of forming a sales plan in accordance with a past result, as well as determining a future sales price of a commodity or a service in accordance with actual sales quantity or sales amount.SOLUTION: A sales support system is equipped with at least one computer device, the sales support system comprising sales plan preparation means for preparing a sales plan for a commodity or a service in accordance with a sales result in a past certain period which has a predetermined correspondence relationship with a target period for the sales plan. The sales support system equipped with at least one computer device includes sales price determination means which determines a sales price of a commodity or a service to be sold after a predetermined period, on the basis of a ratio or a difference between actual sales quantity or sales amount of the commodity or the service and estimated sales quantity or estimated sales amount of the commodity or the service in the predetermined period.SELECTED DRAWING: Figure 4

Description

The present invention relates to a sales support system and a sales support method.

In retail stores, the sales of products or services may vary greatly depending on the season, day of the week, weather, and the like. Therefore, it is necessary to consider factors that affect sales of goods or services, such as season, day of the week, weather, etc., and to prepare goods or services so that they can be sold. However, it has been difficult to create a sales plan by appropriately considering these multiple factors.

Moreover, even if a sales plan is created, when the actual sales are started, the product or service may not sell as planned, and the plan needs to be revised according to the situation.

The present invention has been made to solve such problems. A first object of the present invention is to provide a sales support system capable of creating a sales plan according to past performance. A second object of the present invention is to provide a sales support system capable of determining the subsequent sales price of goods or services according to the actual number or volume of sales.

The subject of the present invention is
[1] A sales support system comprising at least one computer device, which prepares a sales plan for goods or services according to the sales performance of past periods having a predetermined correspondence relationship with the period covered by the sales plan. a sales support system comprising means for creating a sales plan;
[2] The sales plan creation means plans to sell goods or services during the target period based on the number or volume of sales of the goods or services in the past period of the same length as the target period of the sales plan. The sales support system according to [1] above, which calculates the number or planned sales volume;
[3] The sales plan creation means further calculates the planned number of sales or the planned sales volume of the product or service for the target period based on the information on the upward trend or downward trend of the sales number or sales volume of the product, The sales support system according to [2];
[4] The sales according to any one of [1] to [3] above, wherein the past period is the same day of the week before or after the same day of the previous month or the previous month of the target date of the sales plan. system;
[5] The period covered by the sales plan consists of a plurality of unit periods, and the sales plan creation means calculates the planned number of sales or the planned sales volume of the product or service for each of the plurality of unit periods. The sales support system according to any one of [1] to [4];
[6] The sales plan creation means multiplies a different coefficient for each of the plurality of unit periods to calculate the planned sales volume or sales volume of the product or service for each of the plurality of unit periods, the above [1] to [ 5] The sales support system according to any one of;
[7] A sales support method executed in a sales support system comprising at least one computer device, wherein according to the sales results of a past period having a predetermined correspondence relationship with the period targeted by the sales plan, A sales support method having a sales plan creation step of creating a service sales plan;
[8] A sales support system comprising at least one computer device, based on the ratio or difference of the actual sales number or sales volume to the planned sales number or sales volume of the product or service in a predetermined period, A sales support system comprising sales price determination means for determining the sales price of goods or services after a predetermined period of time;
[9] The period during which the product or service is sold after the predetermined period is composed of a plurality of unit periods, and the sales price determination means determines the sales price of the product or service for each unit period, [8] ] sales support system;
[10]
Correspondence storage means for storing a plurality of correspondences between ratios or differences of actual sales numbers or sales volumes to planned sales numbers or sales volumes of goods or services in a predetermined period and price determination methods, and a unit period corresponding relationship specifying means for specifying one of the plurality of corresponding relationships according to the The sales support system according to [9] above, which determines the selling price of the service;
[11] Planned sales volume calculation means for calculating the planned sales volume or planned sales volume of a product or service in a prescribed period according to the sales performance of a past period that has a prescribed corresponding relationship with the period covered by the sales plan and the sales price determination means sells goods or services after a predetermined period based on the ratio or difference of the actual sales number or sales volume to the calculated planned sales volume or sales volume of the goods or services. The sales support system according to any one of [8] to [10] above, which determines the price;
[12] Correspondence storage means for storing the ratio or difference of the actual sales quantity or sales quantity to the planned sales quantity or sales quantity of the product or service in a predetermined period, and the correspondence relationship with the discount rate or discount amount. and a correspondence identification means for identifying one correspondence from a plurality of correspondences, and a sales price determination means for determining the sales price of the product or service after a predetermined period according to the identified correspondence. , the sales support system according to any one of [8] to [11];
[13] The sales support system according to any one of [8] to [12], further comprising sales price display means for displaying the determined sales price;
[14] A sales support method executed in a sales support system comprising at least one computer device, wherein the ratio of the actual sales number or sales volume to the planned sales number or sales volume of the product or service in a predetermined period Or a sales support method having a sales price determination step of determining the sales price of a product or service after a predetermined period based on the difference;
can be achieved by

ADVANTAGE OF THE INVENTION According to this invention, the sales support system which can create a sales plan according to the past performance can be provided. A second object of the present invention is to provide a sales support system capable of determining the selling price of subsequent products or services according to the actual number or volume of sales.

1 is a block diagram showing the configuration of a sales support system according to an embodiment of the present invention; FIG. It is a block diagram showing the configuration of the store terminal according to the embodiment of the present invention. 1 is a block diagram showing the configuration of a server device according to an embodiment of the present invention; FIG. It is a figure which shows the flowchart of the sales plan display process concerning embodiment of this invention. It is a figure which shows the flowchart of the sales plan creation process concerning embodiment of this invention. It is a figure which shows the sales plan concerning embodiment of this invention. It is a figure which shows the flowchart of the selling price determination process concerning embodiment of this invention. It is a figure which shows the price determination table concerning embodiment of this invention. It is a figure which shows the pricing table and policy table concerning embodiment of this invention.

Embodiments of the present invention will be described below, but the present invention is not limited to the following embodiments as long as they do not violate the gist of the present invention. Products to be sold in the sales support system of the present invention are not particularly limited. The service to be sold in the sales support system of the present invention is also not particularly limited. Goods or services to be sold include not only those sold at stores but also those sold on websites.

FIG. 1 is a block diagram showing the configuration of a sales support system according to an embodiment of the invention. As shown in the figure, the sales support system comprises, for example, a store terminal 1, a server device 2, and a communication network 3. The shop terminal 1 can be connected for communication with the server device 2 via the communication network 3 .

The store terminal 1 is provided in a store 4, for example. The server device 2 may be provided inside the store 4 or may be provided outside the store 4 . Although the store terminal 1 and the server device 2 are described here as separate devices, a single computer device can serve as both the store terminal 1 and the server device 2 .

A store 4 is equipped with a store terminal 1 and POS registers 5a to 5z. The POS registers 5a to 5z can be connected to the store terminal 1 and/or the server device 2 for communication.

The store terminal 1 is not particularly limited as long as it is a computer device having a display screen and an input unit. The store terminal 1 may be of a stationary type or a portable type that can be carried by the user when moving. Examples of the store terminal 1 include conventional mobile phones, tablet terminals, smart phones, and desktop/notebook personal computers.

FIG. 2 is a block diagram showing the configuration of the store terminal according to the embodiment of the invention. The store terminal 1 includes a control unit 11, a main memory 12, a storage unit 13, an input device 14, a display device 15, and a communication interface 16, which are all connected by a bus.

The control unit 11 is composed of a CPU and a ROM. The control unit 11 executes programs stored in the storage unit 13 to control the store terminal 1 . A RAM, for example, is used as the main memory 12 . The main memory 12 is a work area for the control section 11 . The storage unit 13 is a storage area for storing programs and data. The control unit 11 performs arithmetic processing based on the program and data read from the main memory 12 and the data input by the input device 14 .

The display device 15 has a display screen. The control unit 11 outputs a video signal for displaying an image on the display screen according to the result of arithmetic processing. Here, the display screen may be a touch panel having a touch sensor. In this case, the touch panel functions as the input device 14 .

The communication interface 16 can be connected to the communication network 3 wirelessly or by wire, and can transmit/receive data to/from the server device 2 or the POS register 5 via the communication network 3 . Data received via the communication interface 16 is loaded into the main memory 12 and arithmetically processed by the control unit 11 .

FIG. 3 is a block diagram showing the configuration of the server device according to the embodiment of the invention. The server device 2 includes a control unit 21, a main memory 22, a storage unit 23, and a communication interface 24, which are connected by a bus.

The control unit 21 includes a CPU and a ROM, executes programs stored in the storage unit 23 , and controls the server device 2 . Also, the control unit 21 has an internal timer for measuring time. The main memory 22 is a work area for the control section 21 . The storage unit 23 is a storage area for storing programs and data. The control unit 21 reads programs and data from the main memory 22 and executes program execution processing based on information received from the store terminal 1 or the POS register 5 .

(First embodiment)
Next, sales plan display processing will be described. In the following, a case where a retail store such as a supermarket prepares a sales plan for side dishes and starts selling them according to the prepared sales plan will be mainly described. It is also applicable to

FIG. 4 is a diagram showing a flowchart of sales plan display processing according to the embodiment of the present invention. A user of the retail store operates the store terminal 1 to access the server device 2 . A user ID and password are registered for each user, and the user logs in to the sales support system by entering the user ID and password into the store terminal 1 (step S1).

Next, the user operates the store terminal 1 to send a request for creating a sales plan for a predetermined period to the server device 2 (step S2). Specifically, the user operates the store terminal 1 and selects a button for requesting creation of a sales plan. Here, the predetermined period is not particularly limited. It may be hourly, daily, weekly, monthly or yearly. A predetermined period may be set in advance depending on the type of product or service for which a sales plan is to be created, or may be selected by the user by operating the store terminal 1 . For example, if the products targeted for the sales plan are supermarket side dishes (for example, meat croquettes, vegetable croquettes, fried chicken, potato salad, etc.), the sales plan can be created for each day.

The server device 2 receives the sales plan preparation request (step S3). The server device 2 stores in advance the price of the product for which the sales plan is to be created and the past sales performance of the product, and the sales plan of the product is created based on this sales performance (step S4). .

A sales plan can be created not only for one product but also for a plurality of products. For example, for a plurality of products such as meat croquettes, vegetable croquettes, fried chicken, and potato salad, it is possible to calculate the expected number of sales or the expected sales volume of each product according to their past sales performance.

Next, the server device 2 stores the created sales plan in the storage unit 13 (step S5). Then, the created sales plan is transmitted to the store terminal 1 (step S6). When the store terminal 1 receives the sales plan (step S7), the received sales plan is displayed on the display screen of the store terminal 1 (step S8). The user purchases and prepares products according to the sales plan displayed on the display screen of the store terminal 1, and starts selling. The processing of steps S1 to S8 ends the sales plan display processing.

Next, the sales plan creation processing in step S4 will be described in more detail. FIG. 5 is a diagram showing a flowchart of sales plan creation processing according to the embodiment of the present invention. Note that the following sales plan creation processing is executed for each product or service.

First, the past sales record of the product for which the sales plan is created is extracted from the database of the server terminal 2 (step S11). At this time, the number or volume of sales of the product or service in the past period of the same length as the target period of the sales plan is extracted. In other words, based on the number of sales or sales volume of goods or services in the past period of the same length as the target period covered by the sales plan, the planned sales volume or sales volume of the goods or services during the target period is calculated. be done.

When creating a sales plan for each day, it is possible to create a sales plan based on the past sales performance for each day. For example, when creating a sales plan for October 15, 2021, you can create a sales plan based on the sales results for October 8, 2021, one week before, or create a sales plan for September 2021, one month before. The sales plan may be created based on the actual sales on the 15th of the month, or the sales plan may be created based on the actual sales on October 15, 2020, one year ago. The past period corresponding to the sales record that is the basis for creating the sales plan may be set in advance for each product or service, and can be changed as appropriate by the user's operation of the store terminal 1. good too.

The past period from which the sales plan is created is preferably the same day of the week before and after the same day in the previous year of the target period for the sales plan. For example, when creating a sales plan for October 15, 2021 (Friday), around October 15, 2020 (Thursday), which is one year before, 2020, which is the same Friday as October 15, 2021 The sales results on Friday, October 9, 2020 or Friday, October 16, 2020 are extracted in step S11.

In this case, Friday, October 9, 2020, which is the same day of the week before the same day of the previous year as the target date of the sales plan, may be extracted, and the previous year of the target period It is possible to extract Friday, October 16, 2020, which is the same day of the week after the same day of It can be closer to October 16, 2020 (Friday). Depending on the product or service, the sales volume is highly dependent on the season, month, and day of the week. A more appropriate sales plan can be created by setting the same day before and after the day of .

In addition, here, the past period from which the sales plan is created is the same day of the week before and after the same day of the previous year of the target period of the sales plan, but depending on the product or service Alternatively, the past period from which the sales plan is created may be the same day of the week before or after the same day in the month preceding the target period of the sales plan.

As the past sales record extracted in step S11, the number of products sold and purchased on that day is stored for each product. For example, if the product can be counted by the number of side dishes enclosed in a case, the number of items such as 1, 2, 3, etc. is stored as the sales performance. On the other hand, if the product is sold by weight, such as side dishes or beverages, and can be accounted for in terms of quantity, the actual sales will include weights such as 100g, 200g, and 300g, and volumes such as 100cc, 200cc, and 300cc. remembered. The same is true for services, and the number and time of sales are stored for each service.

Further, the past sales record extracted in step S11 includes information on discounts. As the information on discounts, the average sales price, average discount amount, or average discount rate of products or services sold on that day are extracted. The discount rate is the ratio of the discount amount to the list price. For example, if the product is sold at 70% of the list price, the discount rate is 30%.

Next, a sales growth rate is calculated as information relating to an upward trend or a downward trend in the number or volume of sales of the product for which the sales plan is to be created (step S12). The sales growth rate can be calculated from the past sales results stored in the server device 2 . For example, the total sales volume or total sales of the product in the period going back to a predetermined period (e.g., one month or one year) from the past period on which the sales plan is created is subject to the sales plan. The sales growth rate can be obtained by dividing the total sales volume or total sales of the product in the period going back from the period to a predetermined period (for example, one month or one year). When creating a sales plan for October 15, 2021 (Friday) based on the sales results for October 16, 2020 (Friday), products from October 16, 2019 to October 15, 2020 The sales growth rate can be calculated by dividing the total sales volume of by the total sales volume of the product from October 15, 2020 to October 14, 2021. By using such a sales growth rate, it becomes possible to reflect in the sales plan the upward or downward trend in the sales of the product due to the store's sales efforts and trends.

Therefore, the sales growth rate becomes a value larger than 1 when the sales tend to increase compared to the past, and the sales growth rate becomes a value smaller than 1 when the sales tend to decrease compared to the past.

In step S12, the sales growth rate for each product was calculated, but instead of the sales growth rate for each product, the sales growth rate was calculated based on the sales of all products handled by the store. , based on this calculated sales growth rate, it is possible to create a sales plan.

Next, based on the sales volume of the product extracted in step S11 and the sales growth rate of the product calculated in step S12, the planned sales quantity or sales volume is calculated (step S13). For example, as a past sales performance, if 35 meat croquettes were purchased on Friday, October 16, 2020, and the sales growth rate was 1.1, the sales growth rate was increased to the number of meat croquettes sold. By multiplying, the planned number of meat croquettes to be sold on Friday, October 15, 2021 can be calculated as 38.5.

Next, the planned sales quantity or the planned sales volume calculated in step S13 is corrected according to the information on the discount of the product extracted in step S11 (step S14). For example, the correspondence relationship between the average discount rate of the product and the coefficient for correction is set in advance, and the coefficient corresponding to the average discount rate is set to the planned sales quantity or the planned sales quantity calculated in step S13. By multiplying, the corrected planned sales quantity or sales quantity can be obtained. For example, when the discount rate is 0 to 5%, the coefficient is "1", when the discount rate is 5 to 10%, the coefficient is "0.9", and when the discount rate is 10 to 20% may be based on a table defining the value of the coefficient corresponding to the discount rate, such as "0.8", or may be based on a predetermined relational expression that allows the coefficient to be obtained from the discount rate.

For example, in step S13, if the planned number of meat croquettes to be sold on Friday, October 15, 2021 is calculated to be 38.5, the discount rate for meat croquettes on Friday, October 16, 2020 is 7% and the coefficient for correction is 0.9, by multiplying 38.5 by 0.9, the planned number of meat croquettes to be sold after correction can be calculated as 34.65. can. If the corrected planned sales volume includes a value below the decimal point, the decimal point may be rounded off, rounded up, or rounded down to an integer.

In step S14, instead of multiplying the planned sales quantity or the planned sales volume calculated in step S13 by a coefficient corresponding to the average discount rate, an average By subtracting the correction quantity according to the discount rate, it is possible to obtain the corrected planned sales quantity or sales quantity.

In addition, in step S14, the weather and other conditions on October 15, 2021 (Friday), which is the target of the sales plan, and October 16, 2020 (Friday), which is the past period on which the sales plan is created. It is also possible to further correct the planned number of sales or the planned sales volume according to factors other than discounts that affect sales, such as the circumstances above. These corrections may be made automatically by the sales support system, or may be made manually by the user's operation of the store terminal 1 .

In the sales support system, in addition to the planned sales volume or sales volume for the period covered by the sales plan, the planned sales volume or sales volume for the shorter period that constitutes the sales plan period is also calculated. can be calculated. In other words, not only the planned number of sales or the planned sales amount of the product in a certain day that is the target of the sales plan, A planned amount can be calculated. In step S14, when the planned sales volume or sales volume for the day targeted for the sales plan is obtained, the planned sales volume or sales volume for each hour constituting the day is calculated (step S15). .

The calculation method in step S15 is not particularly limited. For example, it is possible to simply divide the planned number of sales per day or the planned amount of sales calculated in step S14 by the number of hours from opening time to closing time to obtain the planned number of sales per hour. . If the planned number of sales per day is 100, and the store opens at 8:00 and closes at 20:00, it can be calculated as 100/12=8.33. Round off, round up, or round down to an integer after the decimal point.

As the calculation method in step S15, a calculation method that considers the difference in sales at each time can be adopted. For example, a different coefficient (sales index) is determined for each time from the opening time to the closing time, and this coefficient is used to calculate the planned number of sales or the planned sales amount calculated in step S14 from the opening time to the closing time. By multiplying the planned number of sales per hour or the planned amount of sales obtained by dividing by the number of hours, the planned number of sales or the planned amount of sales for each hour can be obtained. The hourly sales index can be determined according to past sales performance, for example, the number of hourly sales during a predetermined period in the past.

For example, if the planned number of sales per hour obtained by dividing the planned number of sales per day calculated in step S14 by the number of hours from opening time to closing time is 8.33, If the sales index from 8:00 to 9:00 is 1.1, the planned number of sales from 8:00 to 9:00 is 8.33×1.1=9.16. Round off, round up, or round down to an integer after the decimal point. For example, by rounding down, the planned number of sales from 8:00 to 9:00 can be set to 9. Similarly, if the sales index from 9:00 to 10:00 is 1.2, the planned number of sales from 9:00 to 10:00 is 8.33×1.25=10.41, which is rounded down to 10. can do.

Note that the hourly sales index can also take numbers smaller than one. For example, in retail stores such as supermarkets that mainly sell food and beverages, the number of customers is small during the period from 14:00 to 16:00, and the sales index tends to be less than 1.

Through steps S11 to S15, for each product, the planned sales volume or sales volume for the day targeted by the sales plan, and the planned sales volume or sales volume for each time period from the opening time to the closing time amount can be calculated. In steps S11 to S15, the planned daily sales quantity or sales quantity for each product and the hourly planned sales quantity or sales quantity are prepared as a sales plan, and the sales plan preparation process ends. The created sales plan is stored in the storage unit 13 in step S5 and transmitted to the store terminal 1 in step S6.

In addition, regarding the processing executed in each step of the sales plan display processing and the sales plan creation processing, the steps executed by the store terminal 1 may be executed by the server device 2 as long as there is no contradiction. Often, the steps executed by the server device 2 may be executed by the store terminal 1 . Moreover, the processing executed in each step of the sales plan display processing and the sales plan creation processing may be executed only by the store terminal 1 . In this case, it is preferable that the past sales results are stored in the store terminal 1 in advance.

FIG. 6 is a diagram showing a sales plan according to the embodiment of the invention. At step S4 (steps S11 to S15), a sales plan as shown in FIG. 6 is created, and at step S8, the sales plan as shown in FIG. In the sales plan 30, a time period 33, a planned sales quantity 34, and a sales price 35 are recorded in association with a product name 31 and a sales date 32. FIG.

Next, selling price determination processing will be described. FIG. 7 is a diagram showing a flowchart of sales price determination processing according to the embodiment of the present invention. At the store, products such as side dishes are prepared according to the sales plan. When the store opens, merchandise is sold, and payment for the merchandise is made at the POS cash register 5 (step S21), sales information indicating that the merchandise has been sold is transmitted from the POS cash register 5 to the server device 2. (Step S22). The sales information indicating that the product was sold includes, for example, the type of product sold, such as whether it is meat croquette, vegetable croquette, fried chicken, or potato salad, and the number or volume of the product sold. After the sale is started, the product is sold at the fixed price until a predetermined time, which will be described later, has passed.

The server device 2 receives the sales information indicating that the product has been sold (step S23). The server device 2 stores the number of sales or sales volume for each product in the main memory 22 or the storage unit 23 (step S24). Steps S21 to S24 are executed each time a product is purchased. In step S24, the memorized sales record of the product will be used as data for creating a sales plan in the future.

After the start of sales, when a predetermined time has elapsed since the start of sales (step S25), the planned sales quantity or sales quantity of the product and the sales quantity or sales quantity of the product stored in step S24. Based on this, the selling price after a predetermined time is determined (step S26).

The processing of steps S21 to S24 is repeated each time a product is purchased even after the predetermined time of step S25 has elapsed.

The determination of the sales price in step S26 is performed for each product based on the number of sales or sales volume for each product. For example, the sales price of meat croquettes is determined based on the number or volume of meat croquettes sold during a predetermined period of time from the start of sales. In step S25, the predetermined time is 11:00 when the store opens at 8:00 and the merchandise starts to be sold at 8:00. can be Based on the sales for three hours from 8:00 to 11:00, if the sales of the product are lower than the created sales plan, the price of the product can be reduced. For example, if the actual number of sales from 8:00 to 11:00 is about 50% of the planned number of sales, even if the sales continue at the same price after 11:00, the planned sales will continue after 11:00. There is a high possibility that sales will be around 50% of the number. By reducing the price after a predetermined time has passed since the start of sales, it is possible to encourage purchase of the product after 11:00 and reduce the number of unsold products.

Here, the predetermined time in step S25 is set to 3 hours, but the length of the time is not particularly limited. It may be shorter than 1 hour or longer than 1 hour. The length of this predetermined time may be configured to be appropriately changed by operating the store terminal 1 . Moreover, the length of this predetermined time may differ from product to product.

In step S26, the sales amount after a predetermined time is determined based on the ratio or difference of the actual sales number or sales amount of the product to the planned sales amount or sales amount calculated in step S4. may be In addition, in step S26, unlike step S4, based on the ratio or difference of the actual sales number or sales amount of the product to the calculated planned sales number or sales amount, the sales after a predetermined time are calculated. An amount may be determined.

Determination of the sales price in step S26 is executed by referring to a price determination table preset in the store terminal 1 or the server device 2, for example. FIG. 8 is a diagram showing a pricing table according to the embodiment of the invention. A price determination table 40 stores a correspondence relationship between a plan achievement rate 41 and a discount rate 42 .

Here, the planned achievement rate 40 is the ratio of the actual sales number or sales amount of the product to the planned sales number or sales amount after a predetermined time has elapsed since the start of sales. For example, if the planned sales volume from 8:00 to 11:00 is 300, and the actual sales volume or sales volume is 267, 267/300 = 0.89 and the plan achievement rate is 89%. be. Referring to the price determination table 40 shown in FIG. 8, the discount rate is 5% when the planned achievement rate is 80 to 89.9%, so the discount rate corresponding to the planned achievement rate of 89% is 5%. Therefore, if a case of meat croquettes is priced at 250 yen, the selling price after 11:00 is 237.5 yen. Decimal numbers are rounded, rounded up, or rounded down to integers. The selling price after 11:00 can be 237 yen.

A plurality of different price determination tables 40 may be registered in the store terminal 1 or server device 2 . An appropriate price determination table 40 may be automatically identified from these multiple price determination tables 40 according to the attribute of the sale date when determining the price in step S26. For example, if the sales date is Monday to Friday, pricing table A is identified; if the sales date is Saturday, Sunday, or a holiday, pricing table B is identified; C is identified.

Further, the contents of the price determination table 40 can be changed by operating the store terminal 1 . Specifically, the correspondence relationship between the plan achievement rate 41 and the discount rate 42 can be changed according to the intention of the user. Therefore, the user can edit the price determination table by trial and error as to which price determination table results in higher sales and which has fewer unsold products. can.

Regarding the determination of the selling price in step S26, the case of executing with reference to the price determination table shown in FIG. 8 has been described, but instead of the price determination table shown in FIG. The selling price of the product can be determined by referring to the price determination table shown in FIG. 9B and the policy table shown in FIG. A price determination table and a policy table are preset in the store terminal 1 or the server device 2 .

A price determination table 50 in FIG. 9A stores a correspondence relationship between a plan achievement rate 51 and a price determination policy 52 . A plurality of price determination policies are preset in the price determination policy 52 . For example, as the pricing policy 52, pricing policy (i) 52a, pricing policy (ii) 52b, and pricing policy (iii) 52c are set. A discount rate is set for each plan achievement rate 51 in these price determination policies 52 . The numerical value displayed below the price determination policy 52 in FIG. 9(a) is the value of the discount rate.

For example, in the case of price determination policy (i) 52a, the discount rate is 0% when the plan achievement rate is 90% or more, the discount rate is 0% when the plan achievement rate is 80 to 89.9%, and the plan achievement rate The discount rate is 0% when it is 70 to 79.9%, the discount rate is 10% when the plan achievement rate is 60 to 69.9%, and the discount rate is 50 to 59.9%. is 15%, and so on, the discount rate increases as the plan achievement rate decreases. In the case of the price determination policy (ii) 52b, the discount rate is 0% when the plan achievement rate is 90% or more, the discount rate is 10% when the plan achievement rate is 80 to 89.9%, and the plan achievement rate The discount rate is 20% when it is 70 to 79.9%, the discount rate is 25% when the plan achievement rate is 60 to 69.9%, and the discount rate is when the plan achievement rate is 50 to 59.9%. is 30%, . Pricing policy (iii) 52c similarly increases the discount rate as the plan achievement rate decreases. In this way, the pricing policies (i) 52a to (iii) 52c have different discount rates even if they have the same plan achievement rate. Even if the plan achievement rate is the same, pricing policy (i) 52a has the lowest discount rate, pricing policy (ii) 52b has the next lowest discount rate, and pricing policy (iii) 52c has the highest discount rate. Become. Although three policies are set as the price determination policy 52 here, the number of policies set as the price determination policy 52 is not particularly limited.

In the policy table 55 of FIG. 9B, for example, which of the pricing policies (i) 52a to (iii) 52c is to be adopted is set for each hour. . In other words, in the policy table 55, the pricing policy 57 to be adopted is set in association with the time 56. FIG. For example, from 11:00 to 11:59 and from 12:00 to 12:59, the pricing policy (i) 52a is adopted, and from 13:00 to 13:59 and 14:00 From 14:59, 15:00-15:59, and 16:00-16:59, pricing policy (ii) 52b may be employed. Also, after 17:00, the pricing policy (iii) 52c can be adopted.

In step S26, the policy table 55 as shown in FIG. 9(b) is referenced to identify which price determination policy 52 is to be adopted at each time 56. Further, as shown in FIG. 9(a), By referring to the pricing table 50, the discount rate corresponding to the identified pricing policy 52 can be determined at each time 56 (ie, the price of the product can be determined). For example, when the plan achievement rate from 11:00 to 11:59 is 50 to 59%, referring to the policy table 55, it is specified that the pricing policy (i) 52a is to be adopted, and the pricing table Referring to 50, 15% is identified as the discount rate corresponding to pricing policy (i) 52a.

For example, as described above, in the policy table 55 shown in FIG. ) By changing the pricing policy adopted in the order of 52c, the discount rate is kept low in the time zone when not much time has passed since the start of sales, and sufficient time has passed since the start of sales. In the time period, it is possible to increase the discount rate. By doing so, it is possible to reduce the number of unsold products at the time of closing while suppressing discounts. In this example, the discount rate increases and the price decreases as time passes, but in the policy table, the discount rate decreases and the price increases as time passes. You can also set like this.

The correspondence relationship between the plan achievement rate 51 and the price determination policy 52 in the price determination table 50 or the correspondence relationship between the time 56 in the policy table 55 and the adopted price determination policy 57 can be determined by operating the store terminal 1. , may be editable.

The sales price determined in step S26 and/or the discount rate used in determining the sales price are stored in the main memory or storage section of the store terminal 1 or the server device 2, and may be sold in the future. It becomes the original data when creating a plan.

When the selling price is determined in step S26, which product and how the selling price has changed are displayed on a display device installed inside or outside the store 4 (step S27). This display device is connected to the store terminal 1 or the server device 2 for communication, and the information regarding the change in selling price transmitted from the store terminal 1 or the server device 2 is displayed on the display device. For example, the display device displays that the price of one case of meat croquette has been reduced from 250 yen to 237 yen. Customers inside the store 4 or outside the store 4 can confirm the contents displayed on the display device and be prompted to purchase the product. Through steps S21 to S27, the sales price determination process ends.

When the selling price is determined in step S26, information about the product and the determined selling price is transmitted from the server device 2 to the store terminal 1 or the POS cash register 5, and the store terminal 1 or the POS cash register 5 , the product and the new sales price can also be output by printing. The printed sheet can be posted in front of the corresponding product in the side dish corner where the product is sold in the store.

As for the sales price determined in step S26, the example of price reduction was given above. If the number or sales volume is greater, the selling price may be determined so as to raise the price in the subsequent time period.

In addition, if the plan achievement rate improves due to the price reduction after 11:00, the reduced price will be returned to the fixed price, or the middle price between the reduced price and the fixed price at 11:00 can do. In this case, the plan achievement rate 40 is calculated from the ratio of the actual product sales volume or sales volume to the planned sales volume or sales volume from the start of sales to this point, and the calculated plan achievement Based on the rate, the price determination table 40 can be referenced to determine the rate of price reduction after the plan achievement rate is improved.

Regarding the processing executed in each step of the selling price determination process, the steps executed by the store terminal 1 may be executed by the server device 2 as long as there is no contradiction. The executed steps may be executed by the store terminal 1 . Also, the processing executed in each step of the selling price determination processing may be executed only by the store terminal 1 .

(Second embodiment)
In the first embodiment, the product is mainly a side dish, a sales plan for one day is created, sales of the product are started based on the created sales plan, and the sales of the product after one hour are determined. However, it can also be applied to seasonal products such as swimwear. Also in the second embodiment, the same processes as the sales plan display process, the sales plan creation process, and the sales price determination process described in the first embodiment are performed by the store terminal 1 and/or the server. Executed in device 2 . Also, the second embodiment may have the same configuration as the sales plan 30 and price determination table 40 described in the first embodiment.

For example, based on the number of sales of swimwear in the previous year, the same processing as the sales plan creation processing described above is performed to create a sales plan for each day from June 1st to August 31st of the year. can be calculated. In this case as well, when creating a sales plan, it is preferable that the days before and after the same day of the previous year of the target period of the sales plan are the same day of the week. For example, when creating a sales plan for June 1, 2022 (Wednesday), around June 1, 2021 (Tuesday), which is one year before that, the same Wednesday as June 1, 2022, 2021 The sales performance on June 2nd (Wednesday) is extracted. For example, based on the number of swimwear sales on June 2, 2021 (Wednesday), the sales growth rate, and the average price reduction rate of swimwear in 2021, the planned number of sales can be calculated. The sales growth rate can be calculated based on the ratio of sales in 2020 and 2021 for all products handled at stores. A sales plan can be calculated by calculating the number of swimsuits to be sold from June 2, 2022 to August 31, 2022 in the same manner as for June 1, 2022.

In the server device 2, sales are scheduled to start on June 1, 2022, and when a predetermined period of time (for example, two weeks) has passed, the planned number of sales or scheduled sales until a predetermined period of time has passed since the start of sales. The plan achievement rate is calculated from the ratio of the number or volume of actual product sales to the volume. Then, based on the calculated plan achievement rate, the price determination table can be referenced to determine the price after the lapse of a predetermined period of time. In this way, by reducing the price after the lapse of the predetermined period, it is possible to encourage the purchase of the product after the lapse of the predetermined period and reduce the number of unsold products.

According to the present invention, since a sales plan for a product or service is created according to the sales performance of a past period that has a predetermined correspondence relationship with the target period of the sales plan, deviation from actual sales is less likely to occur. Can create a sales plan.

According to the present invention, based on the number of sales or the sales volume of the product or service in the past period of the same length as the target period of the sales plan, the planned sales volume or sales of the product or service in the target period Since the planned quantity is calculated, it is possible to create a sales plan that is less likely to deviate from actual sales.

According to the present invention, based on the information on the upward or downward trend of the sales number or sales volume of the product, in order to calculate the planned sales volume or sales volume of the product or service in the target period, the store's sales efforts and You can create a sales plan that takes into consideration the influence of trends, etc.

According to the present invention, the past period is the same day of the week before and after the same day of the previous year of the target period of the sales plan, so that the day of the week affects the sales. , it is possible to create a sales plan that is less likely to diverge from actual sales.

According to the present invention, the target period for the sales plan is composed of a plurality of unit periods. It is possible to create a sales plan that is less likely to diverge from actual sales for each item. It is preferable to calculate the planned number of sales or the planned sales volume of the product or service for each of the plurality of unit periods by multiplying a different coefficient for each of the plurality of unit periods.

According to the present invention, the sales price of a product or service after a predetermined period is determined based on the ratio of the actual sales volume or sales volume to the planned sales volume or sales volume of the product or service during the predetermined period. Therefore, the selling price of the product or service can be determined based on the actual sales.

According to the present invention, the period during which the product or service is sold after the predetermined period consists of a plurality of unit periods, and the selling price of the product or service can be determined for each unit period.

According to the present invention, a plurality of correspondence relationships between the ratio or difference of the actual sales number or sales volume to the planned sales volume or sales volume of the product or service in a predetermined period and the price determination method are stored, and the unit In order to identify one of a plurality of correspondence relationships according to the period, and to determine the selling price of the product or service based on the identified correspondence relationship for each unit period, Different periods may use different policies to determine the selling price of goods or services.

According to the present invention, after calculating the planned number of sales or the planned sales volume of the product or service in a predetermined period according to the sales performance of the past period having a predetermined corresponding relationship with the period targeted by the sales plan, Furthermore, since the selling price of the product or service can be determined based on the actual sales, it is possible to reduce the deviation from the plan, and to suppress the unsold products and the inability to provide sufficient services. can be done.

According to the present invention, the ratio of the actual sales volume or sales volume to the planned sales volume or sales volume of the product or service in a predetermined period, and the correspondence relationship with the discount rate or discount amount are stored, Since the selling price of the product or service after a predetermined period is determined according to the corresponding relationship, the selling price can be determined according to the appropriate corresponding relationship at that time.

According to the present invention, since the determined sales price is displayed on the display device, the determined sales price can be known to customers at the store.

1 store terminal, 2 server device, 3 communication network, 4 store,
5 POS cash register 11 control unit 12 main memory 13 storage unit
14 input device, 15 display device, 16 communication interface,
21 control unit, 22 RAM, 23 storage unit, 24 communication interface,
30 Sales plan 31 Product name 32 Sales date 33 Time zone
34 planned sales quantity, 35 sales price, 40 price determination table,
41 plan achievement rate, 42 discount rate, 50 price determination table,
51 plan achievement rate 52 price determination policy 55 policy table 56 time
57 Pricing Policy Adopted

Claims (14)

A sales support system comprising at least one computing device, comprising:
1. A sales support system comprising sales plan creation means for creating a sales plan for goods or services in accordance with past sales results having a predetermined correspondence relationship with a period subject to the sales plan. Sales plan preparation means, based on the number of sales or sales volume of goods or services in the past period of the same length as the target period of the sales plan 2. The sales support system according to claim 1, which calculates a planned quantity. Claim 2, wherein the sales plan creation means further calculates the planned number of sales or the planned sales volume of the product or service for the target period based on the information on the upward trend or downward trend of the number or volume of sales of the product. Sales support system as described. 4. The sales system according to any one of claims 1 to 3, wherein the past period is the same day of the week before and after the same day of the previous year or the previous month as the target date of the sales plan. The period covered by the sales plan consists of multiple unit periods,
5. The sales support system according to any one of claims 1 to 4, wherein the sales plan creating means calculates the planned number of sales or the planned sales volume of the product or service for each of a plurality of unit periods. 6. The sales support system according to claim 5, wherein the sales plan creation means multiplies a different coefficient for each of the plurality of unit periods to calculate the planned number of sales or planned sales volume of the product or service for each of the plurality of unit periods. . A sales support method performed in a sales support system comprising at least one computer device,
1. A sales support method comprising a sales plan creation step of creating a sales plan for goods or services according to past sales results having a predetermined correspondence relationship with a period targeted by the sales plan. A sales support system comprising at least one computing device, comprising:
Selling price determination to determine the selling price of goods or services after a specified period based on the ratio or difference between the actual number of sales or sales volume and the planned number or volume of sales of the goods or services during the specified period. A sales support system comprising means. The period during which the product or service is sold after a predetermined period consists of multiple unit periods,
The sales support system according to claim 8, wherein the sales price determination means determines the sales price of the product or service for each unit period; Correspondence storage means for storing a plurality of correspondences between ratios or differences of actual sales numbers or sales volumes with respect to planned sales numbers or sales volumes of goods or services in a predetermined period and price determination methods;
Correspondence identifying means for identifying one of the plurality of correspondences according to the unit period,
10. The sales support system according to claim 9, wherein the sales price determination means determines the sales price of the product or service based on the specified correspondence relationship for each unit period; Equipped with planned sales volume calculation means for calculating the planned sales volume or planned sales volume of the product or service in a prescribed period according to the sales performance of the past period that has a prescribed correspondence relationship with the period covered by the sales plan,
Sales price determination means determines the sales price of goods or services after a predetermined period based on the ratio or difference of the actual sales volume or sales volume to the calculated planned sales volume or sales volume of the goods or services. 11. The sales support system according to any one of claims 8 to 10. Correspondence storage means for storing a correspondence relationship between the ratio or difference of the actual sales quantity or sales quantity to the planned sales quantity or sales quantity of the product or service in a predetermined period, and the discount rate or discount amount;
a correspondence identification means for identifying one correspondence from a plurality of correspondences,
12. The sales support system according to any one of claims 8 to 11, wherein the sales price determination means determines the sales price of the product or service after a predetermined period of time according to the identified correspondence relationship. 13. The sales support system according to any one of claims 8 to 12, further comprising sales price display means for displaying the determined sales price. A sales support method performed in a sales support system comprising at least one computer device,
Selling price determination to determine the selling price of goods or services after a specified period based on the ratio or difference between the actual number of sales or sales volume and the planned number or volume of sales of the goods or services during the specified period. A sales support method having steps.

Images