JP2012053583A - Information processor and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an information processor and a program capable of easily performing sales of commodities at discount prices.SOLUTION: An information processor includes storage means, sales pace calculation means, sales price selection means and notification means. The storage means stores a plurality of sales paces for selling commodities and each sales price which can achieve each sales pace in association with each other for each sales time zone. Upon starting discounting of the price of a commodity, the sales pace calculation means calculates a sales pace with which the number of the commodity to be sold can reach a target number, using the current number of the commodity sold and the target number of the commodity to be sold at the time of finishing selling the commodity. The sales price selection means selects the sales price corresponding most closely to the sales pace calculated by the sales pace calculation means from the storage means. The notification means notifies customers of the sales price selected by the sales price selection means.

Description

  Embodiments described herein relate generally to an information processing apparatus and a program.

  In stores such as supermarkets, in order to reduce the amount of discarded products such as fresh foods and side dishes, close-up sales are carried out for the purpose of selling out these processed products during the day. In the part-time sales, discount sales are performed to reduce unsold items as the store's closing time approaches. For unsold items, the store clerk affixes a discount label indicating the discount amount and discount rate one by one, and a discount display such as “All Items ○ Discount” is installed in the sales corner. Or

  For example, Patent Document 1 discloses a technique related to a label printer that prints a discount label, and a store clerk affixes the printed discount label to a product and sells the product at a discount.

  By the way, it is desirable that the discount amount and discount rate of the product are set according to the remaining number of products and the remaining time before the store closing time so that the profit loss due to the discount sales is minimized. However, at present, the discount timing and discount amount are determined based on the store clerk in consideration of the remaining time and the remaining number, so the discount amount is set so that the sales profit and the number of discarded products are optimal. There is a problem that it is difficult to set.

  Conventionally, every time the closing time approaches and the discount amount is increased, it is necessary for the store clerk to reapply a discount label for the new discount amount or to correct the discount display. There is.

  The information processing apparatus according to the embodiment includes storage means, sales pace calculation means, sales price selection means, and notification means. The storage means stores a plurality of sales paces for selling a product and a sales price at which the sales pace can be obtained in association with each sales time zone. The sales pace calculating means uses the sales number of the product at the present time and the target sales number at the sales end time of the product when the time for discounting is reached, and the sales that can reach the target sales number Calculate the pace. The selling price selecting means selects the selling price most corresponding to the selling pace calculated by the selling pace calculating means from the storage means. The notifying means notifies the customer of the selling price selected by the selling price selecting means.

  Further, the program according to the embodiment is a computer in an information processing apparatus including a storage unit that stores a plurality of sales paces for selling a product and a sales price for obtaining the sales pace in association with each sales time zone. Are made to function as sales pace calculation means, sales price selection means, and notification means. The sales pace calculating means uses the sales number of the product at the present time and the target sales number at the sales end time of the product when the time for discounting is reached, and the sales that can reach the target sales number Calculate the pace. The selling price selecting means selects the selling price most corresponding to the selling pace calculated by the selling pace calculating means from the storage means. The notifying means notifies the customer of the selling price selected by the selling price selecting means.

FIG. 1 is a block diagram showing a configuration of a price display system according to the present embodiment. FIG. 2 is a diagram illustrating an example of a display device installed on a merchandise display shelf. FIG. 3 is a diagram illustrating an example of a display device that displays a discount price. FIG. 4 is a block diagram showing a hardware configuration of the POS terminal. FIG. 5 is a functional block diagram showing a functional configuration of the POS terminal. FIG. 6 is a block diagram illustrating a hardware configuration of the management server. FIG. 7 is a diagram for explaining the product master. FIG. 8 is a graph showing the number of products sold with respect to sales time. FIG. 9 is a graph showing the expected number of products sold for each selling price. FIG. 10 is a diagram illustrating an example of a sales pace database. FIG. 11 is a functional block diagram illustrating a functional configuration of the management server. FIG. 12 is a flowchart for explaining a discount processing procedure performed by the management server.

  FIG. 1 is a block diagram showing a configuration of a price display system 1 according to the present embodiment. As shown in FIG. 1, a price display system 1 includes a display device 3 that performs display related to product discounts and other displays on a management server 2 as an information processing device according to the present embodiment, and a POS (Point Of Sales) terminal 4 is connected by a LAN 44.

  The management server 2 is a server that controls the entire price display system 1 and manages in-store sales data and sales data sent from the POS terminal 4. Further, the management server 2 performs a discount process for the product according to the remaining number of the product, the remaining time until the closing time, etc., and causes the display device 3 to display the sales price after the discount.

  The display device 3 is composed of a liquid crystal display, electronic paper, or the like, and is installed on a merchandise display shelf 6 provided in a store as shown in FIG. Then, the display device 3 displays the product name, sales price, sales promotion message, and the like of the product 7 such as lunch boxes and side dishes displayed on the product display shelf 6 under the control of the management server 2. A so-called electronic shelf label may be used as the display device 3.

  For example, as shown in FIG. 2, when selling the product 7 at a fixed price, the management server 2 causes the display device 3 to display “price ginger grilled lunch 600 yen” and the like and the price of the product 7. In addition, as shown in FIG. 3, when the product 7 is sold at a discount, the management server 2 displays a discounted sales price on the display device 3 such as “Price of discounted pork ginger grilled lunch ¥ 600”. Is displayed.

  In this way, by displaying the sales price of the product 7 on the display device 3, a label printed with “580 yen” as the sales price after the discount, a discount such as “50 yen discount”, “1 discount”, etc. It is not necessary to affix a label or the like on which information is printed to the product 7 one by one, and the work load on the store clerk can be reduced.

  In addition, it is desirable that a label printed with “automatic discount target product” or the like is attached to the product 7 as a label indicating that the product is automatically discounted in conjunction with the display device 3.

  The POS terminal 4 registers the sale of the product and transmits the number of products sold to the management server 2.

  FIG. 4 is a block diagram showing a hardware configuration of the POS terminal 4. As shown in FIG. 4, the POS terminal 4 includes a CPU (Central Processing Unit) 30, a ROM (Read Only Memory) 35, a RAM (Random Access Memory) 36, a communication I / F 37, a keyboard 38, and a clerk. Main display 39, customer display 40, printer 41, and scanner 42, which are connected by a bus 43. The POS terminal 4 can communicate with the management server 2 connected via the LAN 44 (see FIG. 1) via the communication I / F 37.

  The ROM 35 stores various programs executed by the CPU 30 and various data. The RAM 36 temporarily stores data and programs when the CPU 30 executes various programs. The CPU 30 generates a control unit 31 (see FIG. 5) that controls the entire system of the POS terminal 4 by developing and executing various programs stored in the ROM 35 on the RAM 36.

  FIG. 5 is a functional block diagram showing a functional configuration of the POS terminal 4. As shown in FIG. 5, the control unit 31 includes an input reception unit 32, a sales registration unit 33, and a transmission unit 34.

  The input receiving unit 32 receives an input of a product code included in the barcode by scanning the barcode attached to the product with the scanner 42.

  The sales registration unit 33 reads the product information such as the product name and the sales price of the product for the product code received by the input receiving unit 32 from the product master M (see FIG. 7) stored in the management server 2, and reads the read product. Register the sale of the product using the information.

  The transmission unit 34 stores the sales data such as the product name and the sales quantity of the product registered by the sales registration unit 33 in the management server 2 when a current transaction key is pressed on the POS terminal 4 to end the transaction. Send.

  Next, the management server 2 will be described. FIG. 6 is a block diagram illustrating a hardware configuration of the management server 2. As shown in FIG. 6, the management server 2 includes a control device such as a CPU 20, a storage device such as a ROM 12 and a RAM 13, an HDD (Hard Disk Drive) 18 and a CD drive device (not shown) for storing programs and various files. An external storage device such as a liquid crystal display and an input device such as a keyboard 15 and a mouse 16 are connected by a bus 19 and have a hardware configuration using a normal computer. The management server 2 can communicate with the POS terminal 4 connected via the LAN 44 (see FIG. 1) via the communication I / F 14.

  The HDD 18 stores a product master M and a sales pace database DB.

  FIG. 7 is a diagram for explaining the product master M. As shown in FIG. 7, the product master M associates each product code with the product name of each product, the normal price (list price) of the product, the sales price (the discount price in the case of discount sales), up to the present time. Product information such as the number of items sold and the number of items remaining is stored.

  Next, the relationship between the sales price of a product and the expected sales number of the product when the sales price is applied will be described with reference to FIGS. In addition, as a product, the case where the food which wants to be sold out on the day of the sales day, such as a lunch box and a side dish, is sold is demonstrated.

  FIG. 8 is a graph showing the number of products sold with respect to sales time. In FIG. 8, the vertical axis represents the number of sales (unit: piece) of a certain product, and the horizontal axis represents time (sales time).

  FIG. 8 shows an example of selling products with a fixed price of 600 yen, and 18 products are sold by 18:00. When the target number of sales during the day is set to 30, it is desirable that the remaining 12 are sold out by 21:00 of the sales end time. In such a case, the store clerk has conventionally determined a discount price as appropriate.

  In the example shown in FIG. 8, if the sales price is reduced to 580 yen, the number of sales reaches exactly 30 at the sales end time of 21:00 and the remaining number becomes zero. On the other hand, if the price is reduced to 570 yen or 560 yen, which is a lower price, sales are good, but the product is sold out within the sales time earlier than the sales end time. In this case, the discount width may be set too large, causing a profit loss on the store side. Therefore, in the example shown in FIG. 8, 580 yen is the optimal discount price.

  Therefore, the sales price (discount price) when the product is discounted and the number of products sold for each sales time zone when the sales price is applied are examined in advance, and the optimal sales are made using the relationship between the two. It is desirable to set the price.

  FIG. 9 is a graph showing the estimated number of products sold for each sales price in the sales time zone from 18:00 to 19:00. The horizontal axis of the graph shows the sales time zone, and the vertical axis of the graph shows the expected number of products sold in this sales time zone. Accordingly, the slope of the graph represents the expected number of products sold per unit time, in other words, the sales pace at which the products are sold or the sales of the products.

  That is, as shown in FIG. 9, when the selling price is set at a fixed price of 600 yen, the sales pace of the products is moderate at 2 pieces per hour. Further, when the sales price is set to 580 yen, the sales rate of the merchandise is slightly faster at 4 pieces per hour. Furthermore, when the selling price is set at 560 yen, the sales pace of the product is further increased to 8 per hour. In addition, when it is desired to sell four of these products in the sales time zone from 18:00 to 19:00, the optimal value of the sales pace is 4 / hour, and the optimal value of the sales price is 580 yen.

  Such a relationship between the sales price, the expected number of sales, and the sales pace can be obtained by examining the number of products sold for each sales time zone. A sales pace database DB shown in FIG. 10 is obtained by setting the relationship between the sales price and the sales pace for each sales time zone.

  FIG. 10 is a diagram illustrating an example of the sales pace database DB. As shown in FIG. 10, the sales pace database DB stores a plurality of sales paces for selling products and sales prices at which the sales pace can be obtained in association with each sales time zone.

  Next, the functional configuration of the management server 2 and the program of the present embodiment will be described.

  In FIG. 6, the ROM 12 stores various programs executed by the CPU 20 and various data, and the program according to the present embodiment. The RAM 13 functions as a work area for temporarily storing data and programs when the CPU 20 executes various programs. The CPU 20 reads out the program of the present embodiment from the ROM 12, develops it in the RAM 13, and executes it, thereby generating a control unit 21 (see FIG. 11) for controlling the management server 2 on the main storage device.

  The program according to the present embodiment is a file in an installable or executable format, such as a CD-ROM, a flexible disk (FD), a CD-R, a DVD (Digital Versatile Disk), or the like, which can be read by a computer. May be recorded and provided.

  Further, the program according to the present embodiment may be stored on a computer connected to a network such as the Internet and provided by being downloaded via the network. The program of this embodiment may be configured to be provided or distributed via a network such as the Internet. Further, the program of this embodiment may be configured to be provided by being incorporated in advance in a ROM or the like.

  FIG. 11 is a functional block diagram showing a functional configuration of the management server 2. As shown in FIG. 11, the control unit 21 includes a sales data receiving unit 22, a remaining number management unit 23, a sales pace calculation unit 24, a sales price selection unit 25, a display control unit 26, and a sales price registration unit. 27 mainly.

  The sales data receiving unit 22 receives sales data such as the product name and the sales quantity of the products registered for sale at the POS terminal 4 from the POS terminal 4 via the communication I / F 14.

  The remaining number management unit 23 subtracts the number of products sold by the sales data receiving unit 22 from the remaining number of products stored in the product master M (see FIG. 7), and calculates the remaining number of products at the present time. The calculated remaining number is stored in the product master M to manage the remaining number of products.

  The sales pace calculation unit 24 can reach the target sales number by using the current sales number of the product and the target sales number at the sales end time of the product when it is time to discount. Is calculated.

  It should be noted that it is desirable to provide a timing for discounting every certain time from several hours before the sales end time of the product, such as 18:00, 19:00, and 20:00, for example. In addition, the sales end time of the product may be the closing time of the store, or may be set as appropriate for each product or sales floor.

  For example, the sales pace calculation unit 24 refers to the product master M (see FIG. 7) and the current sales number of the product “Pig Ginger Grilled Bento” is 18 when the discount time reaches 18:00. Read if it is a piece. Then, as shown in FIG. 8, when the target sales number at 21:00, which is the sales end time, is 30, the sales pace calculation unit 24 calculates that the remaining number of products up to the target sales number is 12. To do. Note that in the case of a product that is desired to be sold out on the sales day, such as a lunch box or side dish, the sales pace calculation unit 24 reads the remaining number of products from the product master M, and uses this as the remaining number of products up to the target sales number It may be used.

  Further, the sales pace calculation unit 24 calculates the sales pace that can reach the target sales number by dividing the remaining number of products up to the target sales number by the remaining time until the sales end time. For example, if it is desired to sell 12 items in 3 hours from 18:00 to 21:00 as described above, it is sufficient to have a sales pace of selling 4 products in each sales period. Accordingly, the sales pace calculation unit 24 calculates the sales pace as four per hour.

  In addition, as the target number of products sold on that day, the number of products manufactured at the store on that day and the number of products received on that day can be set in the program of the present embodiment. Note that even if a product such as a bento box or a side dish is sold out during the manufacturing date, the sales of the product change from time to time depending on the weather, the day of the week, and the events of the day. In this case, the target number of items sold on that day may be changed depending on the weather, day of the week, event, or the like.

  The sales price selection unit 25 selects a sales price most corresponding to the sales pace calculated by the sales pace calculation unit 24 from the sales pace database DB. That is, the sales price selection unit 25 selects the sales pace closest to the sales pace calculated by the sales pace calculation unit 24 from the sales pace database DB (see FIG. 10), and sells the sales price corresponding to the selected sales pace. Select from the pace database DB.

  For example, as described above, when the sales pace calculation unit 24 calculates the sales pace as 4 pieces per hour (4 pieces / hour), the sales pace database DB shown in FIG. The sales price of 580 yen when the sales pace is 4 pieces / hour in the sales time zone at 19:00 is selected as the optimal sales price.

  Next, a case where the sales pace calculation unit 24 calculates the sales pace as 1.5 per hour, for example, will be described. In this case, referring to the sales pace database DB shown in FIG. 10, there are two sales paces of 1 / hour and 2 / hour, which are closest to the sales pace of 1.5 pieces / hour. Become.

  In this way, when there are a plurality of closest sales paces, the sales price selection unit 25 selects a sales price corresponding to the fastest sales pace as an example. In other words, in the example shown in FIG. 10, 580 yen with a sales pace of 2 pieces / hour is selected as the sales price. Thereby, the sales of goods can be improved and unsold goods can be reduced more reliably.

  Alternatively, as another selection method, the sales price selection unit 25 may select the sales price so that the sales price becomes the highest. That is, in the example shown in FIG. 10, 600 yen may be set as the sales price at a sales pace of 1 piece / hour.

  The display control unit 26 functions as a notification unit, and displays the sales price selected by the sales price selection unit 25 on the display device 3 as shown in FIGS. Notify the sales price.

  The sales price registration unit 27 registers the sales price selected by the sales price selection unit 25 in the product master M (see FIG. 7). As a result, the POS terminal 4 can register the sale of the product by reflecting the discount of the product. When the product is automatically discounted, the cashier clerk does not perform a new operation automatically. You can sell discounts.

  Next, a discount processing procedure performed by the management server 2 will be described with reference to FIG. FIG. 12 is a flowchart for explaining a discount processing procedure performed by the management server 2.

  First, the sales data receiving unit 22 determines whether or not sales data such as a product name and a sales quantity of a product registered for sale has been received from the POS terminal 4 (step S1). If not received (step S1: No), the process proceeds to step S3. When the sales data is received (step S1: Yes), the remaining number management unit 23 calculates the remaining number of products based on the received sales data, and stores the calculated remaining number in the product master M (step S2). ).

  Then, the sales pace calculating unit 24 determines whether or not it is time to discount (step S3), and if it is not time to discount (step S3: No), the process returns to step S1. On the other hand, when it is time to discount (step S3: Yes), the sales pace calculation unit 24 refers to the product master M and calculates a sales pace that can reach the target sales number (step S4). .

  The sales price selection unit 25 selects the sales price most corresponding to the sales pace calculated in step S4 from the sales pace database DB (step S5).

  The display control unit 26 causes the display device 3 to display the sales price selected in step S5 (step S6). Further, the sales price registration unit 27 registers the sales price selected in step S5 in the product master M (step S7).

  The control unit 21 determines whether or not the sale end time of the product has been reached (step S8). If it is not the sales end time (step S8: No), the process returns to step S1 and continues the processing of steps S1 to S8 until the sales end time is reached, and the sales price of the product according to the remaining number of products. Is changed in stages, and the process of displaying on the display device 3 is continued. When the sales end time is reached in step 8 (step S8: Yes), the control unit 21 ends the discount process.

  As described above, according to the present embodiment, for each sales period, the sales pace that can reach the target sales number is calculated according to the remaining number of products, and the product is sold at a sales price that can obtain this sales pace. Therefore, it is possible to easily determine the sales price at the time of discount sales while considering the balance between the sales profit and the remaining number of products without depending on the intuition of the store clerk.

  Moreover, since the sales price after the change is displayed on the display device 3, it becomes possible to omit the work of attaching the discount label by the store clerk, reduce the work load on the store clerk for the part-time sales, and reduce the sales of the product. It can be done easily.

  In the above description, the display control unit 26 displays the discount amount of the product on the display device 3 to notify the customer of the discount amount. However, the discount amount notification method is not limited to this. As another example, a speaker may be provided in the vicinity of the merchandise display shelf 6 to notify the customer of the discount amount by voice.

  In the above description, the sales price database DB stores the sales price of the product. However, a discount price (for example, “50 yen discount”), a discount rate, or the like may be stored. In this case, the display device 3 may display a discount price or discount rate, or may calculate a sales price from the discount price or discount rate and display the calculated discount price.

  In the above description, the discount process is performed when it is time to perform the discount. However, the condition for starting the discount process is not limited to this. For example, the discount may be started when the remaining number of products reaches a predetermined number.

DESCRIPTION OF SYMBOLS 1 Price display system 2 Management server 3 Display apparatus 4 POS terminal 6 Product display shelf 7 Product 22 Sales data receiving part 23 Remaining number management part 24 Sales pace calculation part 25 Sales price selection part 26 Display control part 27 Sales price registration part 44 LAN
M Product master DB Sales pace database

JP 2009-163614 A

Claims (6)

Storage means for storing a plurality of sales paces for selling products and a sales price for obtaining the sales pace in association with each sales time zone;
Sales pace that calculates the sales pace that can reach the target sales number by using the current sales number of the product and the target sales number at the sales end time of the product when it is time to discount A calculation means;
Sales price selection means for selecting the sales price most corresponding to the sales pace calculated by the sales pace calculation means from the storage means;
A notifying means for notifying a customer of the selling price selected by the selling price selecting means;
An information processing apparatus comprising: The sales price selection means selects the sales pace closest to the sales pace calculated by the sales pace calculation means from the storage means, and most corresponds to the sales price corresponding to the selected sales pace. Selecting from the storage means as the selling price;
The information processing apparatus according to claim 1.   The selling price selecting means, when a plurality of the most corresponding selling prices are stored in the storage means, selecting the selling price corresponding to the fastest selling pace. The information processing apparatus according to claim 1 or 2. The notifying means notifying the customer of the selling price by displaying on a display device provided on a merchandise display shelf for displaying the merchandise;
The information processing apparatus according to any one of claims 1 to 3. A sales price registration means for registering the sales price selected by the sales price selection means in a storage means for storing product information;
The information processing apparatus according to any one of claims 1 to 4, wherein In an information processing apparatus comprising a storage means for storing a plurality of sales paces for selling a product and a sales price for obtaining the sales pace in association with each sales time zone
Computer
Sales pace that calculates the sales pace that can reach the target sales number by using the current sales number of the product and the target sales number at the sales end time of the product when it is time to discount A calculation means;
Sales price selection means for selecting the sales price most corresponding to the sales pace calculated by the sales pace calculation means from the storage means;
A notifying means for notifying a customer of the selling price selected by the selling price selecting means;
Program to make it function.

Images