Work support device, work support method, and work support program

Abstract

To facilitate sales analysis work for each sales channel.SOLUTION: A post-proportional-division discount amount calculation unit calculates, for each sales store and for each commercial transaction target, a post-proportional-division discount amount, which is a discount amount corresponding to each sales amount of each commercial transaction target, by multiplying each division processing result obtained by dividing each sales amount of each commercial transaction target by a total amount of each sales amount of each commercial transaction target for each sales store, based on sales data of each sales store. A post-proportional division sales amount calculation part subtracts a post-proportional division discount amount corresponding to each sales amount of each commercial transaction object from each sales amount of each commercial transaction object for each sales store, and calculates a post-proportional division sales amount reflecting the post-proportional division discount amount corresponding to each sales amount of each commercial transaction object. A data generation part generates sales detail data for each sales channel including the proportionally divided sales amount as a sales amount for each sales store and each commercial transaction object. The sales detailed data for each sales channel can facilitate sales analysis work for each sales channel.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to a business support device, a business support method, and a business support program. [Background technology]

[0002] Patent document 1 (JP Patent Publication No. 2004-094943) discloses a comprehensive management information management system that is not limited to being a system for stores, but also aims to realize efficient business management operations, support management decision-making based on the management policy or management philosophy selected by the manager, and enable comprehensive strategic mission management.

[0003] The comprehensive management information management system of Patent Document 1 contributes to the analysis of management information by implementing a personal sales analysis function that analyzes individual sales performance by product and unit price using accumulated data from the sales information master, sales performance master, and product sales performance master; a performance verification function that verifies the sales performance of each store by sales price range, customer visit area, and age; a sales customer analysis function that combines sales performance and customer information; and a best-selling analysis function that analyzes sales status on a product-by-product basis (paragraph 0051).

[0004] In addition, the management information comprehensive management system in Patent Document 1 creates a flash sales report file and outputs a daily cumulative sales table after the online service ends, based on the sales data sent from each store in sales management. It also creates a file for creating flash sales reports and sends it to a workstation at headquarters to manage information on sales from all stores (paragraph 0061).

[0005] Furthermore, the management information comprehensive management system of Patent Document 1 compiles the amounts and numbers of sales, discounts, and cancellations by item and creates a daily report file based on various data sent from each store to the sales file for that day as needed during business hours (paragraph 0062).The management information comprehensive management system of Patent Document 1 also manages the progress of each store's sales budget on a daily, weekly, monthly, and yearly basis using various business flash reports (paragraph 0064).

[0006] Furthermore, the comprehensive management information management system of Patent Document 1 outputs reports such as a list of customer numbers by store, a list of customer numbers by region, a customer list by store, a customer list by region, replacement cycles by gender and age by store, and a direct mail delivery list in order to manage customers as part of market management (paragraph 123). [Prior art documents] [Patent documents]

[0007] [Patent Document 1] Japanese Patent Application Laid-Open No. 2004-094943 Summary of the Invention [Problem to be solved by the invention]

[0008] Nowadays, in many cases, commercial transactions are conducted through multiple sales channels, such as through physical stores and virtual stores on the Internet. Furthermore, for each of these sales channels, a predetermined discount is given and commercial transactions are conducted under predetermined terms and conditions.

[0009] As described above, when commercial transactions are conducted across multiple sales channels with various discounts or transaction conditions for each sales channel, there is a problem that it becomes difficult to analyze sales for each sales channel.

[0010] The present invention has been made in view of the above-mentioned problems, and has as its object to provide a business support device, a business support method, and a business support program that can facilitate sales analysis work for each sales channel. [Means for solving the problem]

[0011] In order to solve the above-mentioned problems and achieve the object, the business support device of the present invention includes a prorated discount amount calculation unit that calculates a prorated discount amount, which is a discount amount corresponding to each sales amount of each commercial transaction object, for each sales store and for each commercial transaction object by dividing each sales amount of each commercial transaction object by the total amount of each sales amount of each commercial transaction object for each sales store based on sales data including the sales amount of each commercial transaction object and a predetermined prorated discount amount, which is acquired from each of a plurality of sales stores that sell the commercial transaction objects; The system has an apportioned sales amount calculation unit that calculates an apportioned sales amount, which is the sales amount reflecting the apportioned discount amount corresponding to each sales amount of each transaction object, for each sales store and for each transaction object by subtracting the apportioned discount amount corresponding to each sales amount of each transaction object from the sales amount of each transaction object, a data generation unit that generates sales channel sales detail data including the apportioned sales amount for each sales store and for each transaction object as the sales amount for each sales store and for each transaction object, and an output control unit that outputs the generated sales channel sales detail data to an output target device.

[0012] Furthermore, in order to solve the above-mentioned problems and achieve the object, the business support method according to the present invention includes a prorated discount amount calculation step in which a prorated discount amount calculation unit calculates, for each sales store and for each commercial transaction object, a discount amount corresponding to each sales amount of each commercial transaction object by dividing each sales amount of each commercial transaction object by the total amount of each sales amount of each commercial transaction object for each sales store based on sales data including the sales amount of each commercial transaction object and a predetermined prorated discount amount, the sales amount being acquired from each of a plurality of sales stores that sell the commercial transaction objects, and multiplying the results of the division by the prorated discount amount; The method includes an apportioned sales amount calculation step for calculating, for each sales store and each transaction object, an apportioned sales amount, which is the sales amount reflecting the apportioned discount amount corresponding to each sales amount of each transaction object, by subtracting, from each sales amount of each transaction object, the apportioned discount amount corresponding to each sales amount of each transaction object; a data generation step in which a data generation unit generates sales channel detail data including the apportioned sales amount for each sales store and each transaction object as the sales amount for each sales store and each transaction object; and an output control step in which an output control unit outputs the generated sales channel detail data to an output target device.

[0013] In order to solve the above-mentioned problems and achieve the object, the business support program of the present invention includes a computer including a prorated discount calculation unit that calculates a prorated discount amount, which is a discount amount corresponding to each sales amount of each commercial transaction object, for each sales store and for each commercial transaction object by dividing each sales amount of each commercial transaction object by the total amount of each sales amount of each commercial transaction object for each sales store based on sales data including the sales amount of each commercial transaction object and a predetermined prorated discount amount, the sales amount being acquired from each of a plurality of sales stores that sell the commercial transaction objects. The system functions as: an apportioned sales amount calculation unit that calculates, for each sales store and for each transaction object, an apportioned sales amount, which is the sales amount reflecting the apportioned discount amount corresponding to each sales amount of each transaction object, by subtracting, from each sales amount of each transaction object, the apportioned discount amount corresponding to each sales amount of each transaction object; a data generation unit that generates sales channel sales detail data including the apportioned sales amount for each sales store and for each transaction object as the sales amount for each sales store and for each transaction object; and an output control unit that outputs the generated sales channel sales detail data to an output target device. [Effects of the Invention]

[0014] The present invention can facilitate sales analysis work for each sales channel. [Brief explanation of the drawings]

[0015] [Figure 1] FIG. 1 is a block diagram illustrating a hardware configuration of a task assistance device according to an embodiment. [Figure 2] FIG. 2 is a diagram illustrating an example of a step rate master table. [Figure 3] FIG. 3 is a diagram showing an example of sales data acquired from the terminal device of each store. [Figure 4] FIG. 4 is a diagram showing an outline of the operation of supporting a sales performance evaluation task in the task support device according to the embodiment. [Figure 5] FIG. 5 is another diagram showing an outline of the support operation of the sales performance evaluation task in the task support device according to the embodiment. [Figure 6]FIG. 6 is a diagram showing the units of storage of each factor used to calculate each amount, the calculation formula, etc. [Figure 7] FIG. 7 is a diagram showing an example of sales data acquired on a receipt-by-receipt basis. [Figure 8] FIG. 8 is a diagram showing each process when generating sales data by product for each sales channel. [Figure 9] FIG. 9 is another diagram showing each process when generating sales data by sales channel and product. [Figure 10] FIG. 10 is a diagram for explaining the operation of generating sales data by product in a sales channel. [Figure 11] FIG. 11 is a diagram showing an example of sales data by product for each sales channel. [Figure 12] FIG. 12 is a diagram showing the "retail price" for each product in each sales channel displayed in a list on the sales record inquiry screen. [Figure 13] FIG. 13 is a diagram showing the "sales amount after discount for each item" for each sales channel displayed in a list on the sales record inquiry screen. [Figure 14] FIG. 14 is a diagram showing the "post-allocation sales amount" for each product in each sales channel displayed in a list on the sales performance inquiry screen. [Figure 15] FIG. 15 is a diagram showing the "sales amount" for each product in each sales channel displayed in a list on the sales record inquiry screen. DETAILED DESCRIPTION OF THE INVENTION

[0016] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A task support device according to an embodiment of the present invention will be described in detail below with reference to the accompanying drawings. However, the present invention is not limited to the following embodiment.

[0017] [overview] The sales price to general consumers at each sales channel, such as directly managed stores, department stores (event venues), mail order stores, or online stores (e-commerce stores), is subject to discounts on a receipt-by-receipt basis, such as single item discounts, points discounts, or bulk discounts.

[0018] In such cases, sales performance management by store and by product is carried out by excluding discounts on a receipt-by-receipt basis, or by replacing point discounts and bulk discounts with a single product.

[0019] However, in the distribution and retail industry, for example, industry-specific discounts and sales channel-specific transaction conditions occur, making it difficult to analyze sales for each sales channel.

[0020] Furthermore, when sales are made at external stores such as department stores or event halls, the manager of the external store is evaluated using the final sales amount minus the discounted amount for rent, expenses, etc. This results in a difference in the final sales amount between a store manager who manages a department store or event hall, where the sales amount after discounting is the final sales amount, and a store manager who manages a directly managed store, where no discounts are applied to sales amounts, making it difficult to fairly evaluate store managers using the same standards.

[0021] The business support device of the embodiment stores sales amount information in which discounts incurred per transaction are apportioned to each transaction item, and sales amount information reflecting discounts incurred in specific sales channels, making it possible to evaluate sales performance for each sales channel using the same criteria for each transaction item and perform sales analysis. This simplifies sales analysis for each sales channel and enables fair evaluation of sales performance for each store.

[0022] Specifically, the business support device of the embodiment stores four types of sales amount information generated in commercial transactions: "list price amount," "sales amount after discount on individual items," "sales amount after allocation," and "final sales amount," thereby enabling management of amounts appropriate to the needs of information analysis.

[0023] The "list price" is obtained from the information stored in the product master as the manufacturer's suggested retail price. The "sales amount after discount for individual items" is calculated by subtracting the list price - the discount amount for individual items. The "prorated sales amount" is calculated by subtracting the discount amount that was incurred on the receipt from the "sales amount after discount for individual items" and apportioning it based on the "sales amount after discount for individual items." The "final sales amount" is calculated by subtracting the discount amount from the "sales amount after discount for individual items."

[0024] Finally, by selecting the sales amount items to be analyzed and compared in the sales inquiry process, it is possible to manage sales performance at the granularity of each product, which is an example of the subject of commercial transactions, from a standardized perspective that is not dependent on each sales channel.

[0025] (Hardware configuration) As shown in Fig. 1, the business support device 1 of the embodiment includes a storage unit 2, a control unit 3, a communication interface unit 4, and an input / output interface unit 5. An input device 6 and an output device 7 are connected to the input / output interface unit 5. The output device 7 corresponds to a display unit such as a monitor device (including a home television), a printing device, or a speaker device. The input device 6 may be a keyboard device, a mouse device, a microphone device, or a monitor device that cooperates with a mouse device to realize a pointing device function.

[0026] The communication interface unit 4 is connected to a network 50, which may be a wide area network such as the Internet or a private network such as a local area network (LAN). Connected to the network 50 are a store A terminal device 51, a store B terminal device 52, and a store D terminal device 53, which are terminal devices of each store corresponding to each sales channel.

[0027] As an example, store A terminal device 51 is a terminal device of store A, which is a directly managed store. Store B terminal device 52 is a terminal device of store B, which is an external store such as a department store or a store at an event venue. Store D terminal device 53 is a terminal device corresponding to a mail order store or a virtual store (e-commerce store) on network 50.

[0028] The business support device 1 of the embodiment acquires sales data from the stores A, B, and D of each of these sales channels, and performs sales analysis and the like.

[0029] The storage unit 2 may be, for example, a storage device such as a read only memory (ROM), a random access memory (RAM), a hard disk drive (HDD), or a solid state drive (SSD).

[0030] The storage unit 2 stores a business support program that facilitates fair evaluation of sales performance for each sales channel and each transaction target. The storage unit 2 also includes a commission rate master table 11, a sales data storage unit 12, a sales channel / product sales storage unit 13, a prorated discount amount storage unit 14, and a sales amount storage unit 15, each of which is a storage area.

[0031] The commission rate master table 11 stores commission rates set for each store and each product, as shown in Figure 2. The example in Figure 2 shows an example in which a commission rate is set for each of products A to C sold at external store B, such as a department store or a store at an event venue, among the above-mentioned stores A, B, and D (commission rates are not set for products sold at stores B and D).

[0032] That is, in the case of external stores such as department store stores or stores at event venues, rent or space rental fees and expenses are incurred. For this reason, for external store B such as department store stores or stores at event venues, a commission rate is set for each product in order to calculate the net sales amount by subtracting the rent or space rental fees and expenses from the sales amount.

[0033] In the example shown in Figure 2, a commission rate of 90% is set for product A sold at store B, a commission rate of 95% is set for product B, and a commission rate of 80% is set for product C.

[0034] As shown in Figure 3, sales data for each receipt is acquired from each of the terminal devices 51-53 of stores A, B, and D, and stored in the sales data storage unit 12. This sales data includes sales header data shown in Figure 3(a) and sales detail data shown in Figure 3(b).

[0035] As shown in Figure 3(a), the sales header data includes the store code of each sales channel, the store name, the sales date, the receipt number, the point discount amount, and the bulk discount amount. The point discount amount is the discount amount corresponding to the points added according to the purchase amount. The bulk discount amount is the discount amount applied when a certain number of products are purchased together.

[0036] The sales detail data is composed of, for each receipt number, a line number, product code, product name, retail price, purchase quantity, retail price, and single item discount amount. The single item discount amount is the discount amount applied for each purchase of an item. The single item discount amount is the retail price desired by the product manufacturer for one item (manufacturer's suggested retail price).

[0037] (Functional configuration of business support device) Next, the control unit 3 executes the business support program stored in the storage unit 2, thereby functioning as a calculation unit 21, a data generation unit 22, an output control unit 23, and a display control unit 24, as shown in Fig. 1. The calculation unit 21 also functions as a prorated discount amount calculation unit 25, a prorated sales amount calculation unit 26, a commission sales amount calculation unit 27, and a single item post-discount sales amount calculation unit 28.

[0038] The prorated discount calculation unit 25 divides each sales amount of each transaction object by the total amount of each sales amount of each transaction object for each sales store based on sales data including the sales amount of each transaction object and a predetermined prorated discount amount (for example, a single item discount, a point discount, a bulk discount, etc.) acquired from each of multiple sales stores that sell the transaction object (goods or services). In addition, the prorated discount calculation unit multiplies each division result by the prorated discount amount to calculate a prorated discount amount, which is a discount amount corresponding to each sales amount of each transaction object, for each sales store and for each transaction object.

[0039] The prorated sales amount calculation unit 26 subtracts the prorated discount amount corresponding to each sales amount of each transaction object from the sales amount of each transaction object for each sales store, thereby calculating the prorated sales amount, which is the sales amount reflecting the prorated discount amount corresponding to each sales amount of each transaction object, for each sales store and for each transaction object.

[0040] The data generation unit 22 generates sales channel breakdown data that includes the prorated sales amount for each sales store and each transaction target as the sales amount for each sales store and each transaction target. The output control unit 23 outputs the generated sales channel breakdown data to an output target device. As the output target device, if a display output is to be obtained, the sales channel breakdown data is output to a monitor device, which is the output device 7. If a print output is to be obtained, the sales channel breakdown data is output to a printer, which is the output device 7. If an audio output is to be obtained, the sales channel breakdown data is output to a speaker device, which is the output device 7.

[0041] The sales channel sales breakdown data may be output to and stored in the storage unit 2 or an external storage device, or may be supplied to and stored in a database on the network 50.

[0042] The commission rate sales amount calculation unit 27 refers to the commission rate master table 11 (see Figure 2) in which the commission rate for each sales store and each transaction object is stored, and calculates the commission rate sales amount, which is the sales amount for the sales store and transaction object for which the commission rate is set, by multiplying the allocated sales amount for the sales store and transaction object for which the commission rate is set by the set commission rate.

[0043] The data generation unit 22 generates sales detail data by sales channel using the prorated sales amount as the sales amount for sales stores and commercial transaction objects for which a commission rate is not set, and using the commission rate sales amount as the sales amount for sales stores and commercial transaction objects for which a commission rate is set.

[0044] The sales data also includes the sales amount, which is the retail price desired by the manufacturer or provider of the commercial transaction object, as well as a pro rata discount amount and a single item discount amount that is applied each time a commercial transaction object is purchased.

[0045] The after-discount sales amount calculation unit 28 calculates the after-discount sales amount of each item by subtracting the discount amount of each item from the retail price of each commercial transaction object.

[0046] The prorated discount calculation unit 25 divides the sales amount after discount of each item of each transaction object by the total amount of the sales amount after discount of each item of each transaction object for each sales store. In addition, the prorated discount calculation unit 25 multiplies each division result by the prorated discount amount, thereby calculating the prorated discount amount corresponding to each sales amount of each transaction object for each sales store and for each transaction object.

[0047] The sales data also includes a predetermined pro rata discount amount, which is a discount amount corresponding to points added according to the purchase amount. The pro rata discount amount calculation unit 25 divides each sales amount of each transaction object by the total amount of each sales amount of each transaction object for each sales store. The pro rata discount amount calculation unit 25 also multiplies each division result by the point discount amount to calculate a pro rata point discount amount, which is a pro rata discount amount corresponding to each sales amount of each transaction object, for each sales store and for each transaction object.

[0048] The sales data also includes a predetermined pro rata discount amount, which is a bulk discount amount applied when a predetermined number of transaction objects are purchased together. The pro rata discount amount calculation unit 25 divides each sales amount of each transaction object by the total amount of each sales amount of each transaction object for each sales store. The pro rata discount amount calculation unit 25 also multiplies each division result by the bulk discount amount to calculate a pro rata bulk discount amount, which is the pro rata discount amount corresponding to each sales amount of each transaction object, for each sales store and for each transaction object.

[0049] Furthermore, the prorated sales amount calculation unit 26 subtracts the point discount amount and the bulk discount amount, which are the prorated discount amounts corresponding to the sales amount of each transaction object, from the sales amount of each transaction object for each sales store. As a result, the prorated sales amount reflecting the point discount amount and the bulk discount amount corresponding to the sales amount of each transaction object is calculated for each sales store and for each transaction object.

[0050] The display control unit 24 displays on the display unit a sales performance inquiry screen that includes an input field for an analysis sales category for specifying any one of the retail price, the sales amount after discount for each item, the sales amount after pro rata distribution, or the total sales amount (see FIG. 12). When the retail price is specified via the input field for the analysis sales category, the display control unit 24 displays a list of the retail prices for each store and each transaction object on the display unit (see FIG. 12).

[0051] Furthermore, when the sales amount after discount for each item is specified via the input field for the analysis sales category, the display control unit 24 displays a list of the sales amount after discount for each item for each sales store and for each transaction object on the display unit (see FIG. 13). Furthermore, when the sales amount after allocation is specified via the input field for the analysis sales category, the display control unit 24 displays a list of the sales amount after allocation for each sales store and for each transaction object on the display unit (see FIG. 14). Furthermore, when the sales amount is specified via the input field for the analysis sales category, the display control unit 24 displays a list of the sales amount for each sales store and for each transaction object on the display unit (see FIG. 15).

[0052] (Summary of sales performance evaluation operation support operations) 4 and 5 show an overview of the operation of supporting the sales performance evaluation work in the business support device 1 of the embodiment. First, as shown in Fig. 4, the business support device 1 of the embodiment acquires sales data on a receipt-by-receipt basis from the terminal devices 51 to 53 of stores A, B, and D, which are the sales channels described above, via the network 50.

[0053] The calculation unit 21 calculates the point discount amount and the bulk discount amount corresponding to the sales amount after discounting the individual items, which is obtained by subtracting the individual item discount amount from the retail price, based on the acquired sales data. Furthermore, the calculation unit 21 calculates the sales amount for each sales channel and each product, which reflects the discount amount according to the retail price, by performing an operation to subtract the point discount amount and the bulk discount amount from the sales amount after discounting the individual items.

[0054] Furthermore, for products of a sales channel for which a commission rate is set in the commission rate master table 11, the calculation unit 21 multiplies the sales amount of each product reflecting the discount amount by the commission rate set in the commission rate master table 11. In this way, the calculation unit 21 calculates the sales amount reflecting the commission rate as well as the discount amount.

[0055] Figure 5 shows how the sales amount is calculated, reflecting the discount amount (individual item discount amount and pro rata discount amount) for each sales channel and each product of the directly managed store (Store A), department store (event venue: Store B), and mail order / e-commerce store (Store D).

[0056] The data generation unit 22 generates sales data by sales channel product including the retail price, sales quantity, retail price, single item discount amount, sales amount after single item discount, pro rata point discount amount, pro rata lump-sum discount amount, pro rata sales amount, commission rate, and sales amount for each sales channel and product, and stores the data in the sales data by sales channel product memory unit 13.

[0057] The display control unit 24 also displays a sales performance inquiry screen via the output device 7. When the person in charge specifies a desired analysis sales category, such as the retail price, the sales amount after discount for each item, the pro rata sales amount, or the sales amount, on this sales performance inquiry screen, the data generation unit 32 references the sales data by sales channel and product. The data generation unit 32 then extracts the retail price, the sales amount after discount for each item, the pro rata sales amount, or the sales amount for each sales channel and product, which are included in the sales data by sales channel and product.

[0058] The display control unit 24 displays the extracted retail price, sales amount after discount for each item, sales amount after allocation, or sales amount for each sales channel and each product on a list on the sales performance inquiry screen, thereby facilitating evaluation of sales performance for each sales channel and each product.

[0059] Figure 6 shows the storage units and calculation formulas for each factor used to calculate the above amounts. As shown in Figure 6, the retail price (1) is stored for each item description and calculated using the formula "retail price unit price x sales quantity." The retail price (2) is stored for each item description and is stored for each item in a product master table (not shown).

[0060] The single item discount amount (3) is the discount amount for each item and is stored for each item detail. The sales amount after discount (4) is stored for each item detail and is calculated using the formula "list price (1) - single item discount amount (3)".

[0061] The point discount amount (5) is the discount amount used for points and is stored on a receipt-by-receipt basis. The bulk discount amount (6) is the discount amount applied when a certain number of items or more are purchased and is stored on a receipt-by-receipt basis. The prorated sales amount (7) is stored on a product detail basis and is calculated using the formula "list price (1) - individual item discount amount (3) - (prorated point discount amount (5) + prorated bulk discount amount (6))."

[0062] The commission rate (8) is set for each sales channel and product as described above, as well as for each customer, type, product, etc. The commission rate amount (9) is stored for each product detail. The sales amount (10) is calculated using the formula "list price amount (1) - single item discount amount (3) - (pro rata point discount amount (5) + pro rata bulk discount amount (6))."

[0063] (Details of sales performance evaluation operation support operations) Next, a detailed description will be given of the operation of supporting the sales performance evaluation work in the work support device 1 of the embodiment. First, the sales data acquired on a receipt-by-receipt basis from the terminal devices 51 to 53 of the stores A, B, and D, which are the sales channels described above, via the network 50 has the data format shown in Fig. 7, which is an image.

[0064] That is, the sales data includes the receipt number, point discount amount, and bulk discount amount, as well as the retail price, number of items purchased, retail price (retail price x number of items purchased), and individual item discount amount for each purchased item.

[0065] When the control unit 3 of the business support device 1 of the embodiment acquires such sales data on a receipt-by-receipt basis, it functions as a calculation unit 21 to a display control unit 24 based on the business support program stored in the storage unit 2, and generates sales data by sales channel and product by executing the processes of steps S1 to S7 shown in Figures 8 and 9. Furthermore, based on the generated sales data by sales channel and product, it displays a list of amounts corresponding to the specified analysis sales category on the sales performance inquiry screen, thereby supporting the sales performance evaluation work.

[0066] In this example, the calculation unit 21 to the display control unit 24 are described as being realized by software using a business support program. However, all or part of the calculation unit 21 to the display control unit 24 may be realized by hardware. In either case, the same effects as those described below can be obtained.

[0067] The following description will be given taking as an example the case where sales data for receipt number 110 shown in FIG. 7 is acquired.

[0068] (Step S1) First, in step S1 of FIG. 8, the calculation unit 21 calculates the retail price for each product by calculating "retail price x number of purchases" based on the retail price and number of purchases included in the sales data for each receipt shown in FIG. 7.

[0069] Retail price of product A = Retail price per unit 1,080 yen x 3 units purchased = 3,240 yen Retail price of product B = Retail price 2,160 yen x Purchase quantity 2 = 4,320 yen Retail price of product C = Retail price 3,300 yen x Purchase quantity 1 = 3,300 yen

[0070] (Step S2) Next, the after-discount sales amount calculation unit 28 of the calculation unit 21 calculates the after-discount sales amount by subtracting the discount amount from the retail price, and stores the calculated amount in the sales amount storage unit 15.

[0071] Sales amount after discount for product A = retail price 3,240 yen - discount amount 100 yen = 3,140 yen Sales amount after discount for product B = retail price 4,320 yen - discount amount for product B 300 yen = 4,020 yen Sales amount after discount for product C = retail price 3,300 yen - discount amount 400 yen = 2,900 yen

[0072] (Step S3) Next, the prorated discount amount calculation unit 25 of the calculation unit 21 prorates the point discount amount of 500 yen based on the sales amount after discount for each individual item (prorated point discount amount), and stores the calculated prorated discount amount in the prorated discount amount memory unit 14.

[0073] Prorated point discount amount for product A = point discount amount 500 yen × (sales amount after discount of single item 3140 yen ÷ (sales amount after discount of single item A 3140 yen + sales amount after discount of single item B 4020 yen + sales amount after discount of single item C 2900 yen)) = 156 yen Prorated point discount amount for product B = point discount amount 500 yen × (sales amount after discount for single item 4020 yen ÷ (sales amount after discount for single item A 3140 yen + sales amount after discount for single item B 4020 yen + sales amount after discount for single item C 2900 yen)) = 200 yen Prorated point discount amount for product C = point discount amount 500 yen × (sales amount after discount for each item 2900 yen ÷ (sales amount after discount for each item A 3140 yen + sales amount after discount for each item B 4020 yen + sales amount after discount for each item C 2900 yen)) = 144 yen

[0074] (Step S4) Similarly, the prorated discount calculation unit 25 of the calculation unit 21 prorates the bulk discount amount of 250 yen based on the sales amount after individual discounts for each product (proration of the bulk discount amount), and stores the calculated prorated discount amount in the prorated discount memory unit 14.

[0075] Prorated lump-sum discount amount for product A = 250 × (sales amount after discount of individual items 3,140 yen ÷ (sales amount after discount of individual items for product A 3,140 yen + sales amount after discount of individual items for product B 4,020 yen + sales amount after discount of individual items for product C 2,900 yen)) = 78 yen Prorated lump-sum discount amount for product B = point discount amount 250 yen × (sales amount after individual discount 4,020 yen ÷ (sales amount after individual discount for product A 3,140 yen + sales amount after individual discount for product B 4,020 yen + sales amount after individual discount for product C 2,900 yen)) = 100 yen Prorated lump-sum discount amount for product C = point discount amount 250 yen x (sales amount after individual discount 2900 yen ÷ (sales amount after individual discount for product A 3140 yen + sales amount after individual discount for product B 4020 yen + sales amount after individual discount for product C 2900 yen)) = 72 yen

[0076] (Step S5) Next, in step S5 of Figure 9, the prorated sales amount calculation unit 26 of the calculation unit 21 calculates the prorated sales amount by calculating ``sales amount after individual item discount - prorated point discount amount - prorated lump-sum discount amount'' and stores it in the sales amount memory unit 15.

[0077] Prorated sales amount for product A = Single item discount date sales amount 3,140 yen - Prorated point discount amount 156 yen - Prorated bulk discount amount 78 yen = 2,906 yen Prorated sales amount for product B = Single item discount date sales amount 4,020 yen - Prorated point discount amount 200 yen - Prorated bulk discount amount 100 yen = 3,720 yen Prorated sales amount for product C = Single item discount date sales amount 2900 yen - Prorated point discount amount 144 yen - Prorated bulk discount amount 72 yen = 2684 yen

[0078] (Step S6) Next, the commission rate sales amount calculation unit 27 refers to the commission rate master table 11, calculates the commission rate sales amount for each of products A to C sold at store B of the department store where the commission rate is set, and stores the amount in the sales amount memory unit 15.

[0079] Discount sales amount for product A at department store B = Prorated sales amount 2,906 yen x commission rate 90% = 2,615 yen Discount sales amount for product B at department store B = Prorated sales amount 3,720 yen x commission rate 95% = 3,534 yen Discount sales amount for product C at department store B = Prorated sales amount 2,684 yen x commission rate 80% = 2,147 yen

[0080] (Step S7) Next, the data generation unit 22 generates sales data by product and by sales channel based on the amounts calculated in steps S1 to S6, the sales header data, and the sales detail data, and stores the data in the sales data storage unit 13 by product and by sales channel.

[0081] Specifically, as shown in Figure 10, the data generation unit 22 generates sales data by product by sales channel by inputting the sales channel, store code, sales date, store name, and receipt number from the sales header data into the sales channel, store code, sales date, store name, and receipt number fields.

[0082] In addition, as shown in Figure 10, the data generation unit 22 generates sales data by product by sales channel by inputting the line number, product code, product name, retail price, sales quantity, and single product discount amount of the sales detail data into the line number, product code, product name, retail price, sales quantity, and single product discount amount fields.

[0083] In addition, the data generation unit 22 generates sales data by product and sales channel by inputting the retail price calculated in step S1 above, the sales amount after discount on individual items calculated in step S2, and the pro rata point discount amount calculated in step S3 into the respective fields of retail price, sales amount after discount on individual items, and pro rata point discount amount.

[0084] In addition, the data generation unit 22 generates sales data by product and sales channel by inputting the prorated lump-sum discount amount calculated in step S4, the prorated sales amount calculated in step S5, and the sales amount calculated in step S6 into the respective items of prorated lump-sum discount amount, prorated sales amount, and sales amount.

[0085] The data generating unit 22 also generates sales data by product and by sales channel, in which the yield set in the yield master table 11 is entered in the yield item.

[0086] An example of the sales data by product and sales channel generated in this way is shown in Figure 11. As shown in Figure 11, the sales data by product and sales channel is composed of the following information for each sales channel and each product, on a receipt-by-receipt basis: unit price, sales quantity, retail price, single item discount amount, sales amount after single item discount, pro rata point discount amount, pro rata lump-sum discount amount, pro rata sales amount, commission rate, and sales amount.

[0087] The output control unit 23 reads out the sales data by product per sales channel from the sales data by product per sales channel storage unit 13 at a timing designated by the person in charge, and outputs the data to an output target device such as the output device 7. This allows the sales data by product per sales channel to be displayed or printed out.

[0088] (Sales record inquiry operation) Next, when the sales data by product and by sales channel is stored in the sales data by product and by sales channel storage unit 13, it becomes possible to inquire about the sales performance corresponding to the desired sales classification for analysis.

[0089] Specifically, when the person in charge specifies an inquiry about sales results, the display control unit 24 displays the sales results inquiry screen shown in Fig. 12 via the output device 7. This sales results inquiry screen has an input field for the period for which the sales results inquiry is to be made and an input field for the analyzed sales category. The person in charge inputs the period for which the sales results inquiry is to be made and the analyzed sales category for which the sales results inquiry is to be made on this sales results inquiry screen.

[0090] As an example, the following analysis sales categories can be designated: "1: Retail price," "2: Sales amount after discount on individual items," "3: Sales amount after pro rata distribution," and "4: Sales amount." When "1: Retail price" is designated as the analysis sales category, the data generation unit 22 refers to the sales data by product per sales channel stored in the sales by product per sales channel storage unit 13, and acquires (extracts) the "retail price" for each product in each sales channel.

[0091] The display control unit 24 displays a list of the "sales volume" and "retail price" for each product in each sales channel, which are acquired from the sales channel product sales storage unit 13, on the sales performance inquiry screen, as shown in Fig. 12. This allows the person in charge to analyze the "retail price" of each product sold through each sales channel.

[0092] In addition, when the analysis sales category "2: Sales amount after discount for individual items" is specified, the data generation unit 22 refers to the sales data by product by sales channel stored in the sales channel product storage unit 13, and obtains (extracts) the "sales quantity" and "sales amount after discount for individual items" for each product in each sales channel.

[0093] The display control unit 24 displays a list of the "sales volume" and "sales amount after discount for each item" for each product in each sales channel, which are acquired from the sales-by-sales-channel-product storage unit 13, on the sales performance inquiry screen, as shown in Fig. 13. This allows the person in charge to analyze the "sales amount after discount for each item" of each product sold through each sales channel.

[0094] Furthermore, when the analysis sales category "3: Sales amount after allocation" is specified, the data generation unit 22 refers to the sales data by product by sales channel stored in the sales channel product sales memory unit 13, and obtains (extracts) the "sales quantity" and "sales amount after allocation" for each product in each sales channel.

[0095] The display control unit 24 displays a list of the "sales volume" and "pro rata sales amount" for each product in each sales channel, which are acquired from the sales channel product sales storage unit 13, on the sales performance inquiry screen, as shown in Fig. 14. This allows the person in charge to analyze the "pro rata sales amount" of each product sold through each sales channel.

[0096] Furthermore, when the analysis sales category "4: Sales amount" is specified, the data generation unit 22 refers to the sales data by product by sales channel stored in the sales channel product storage unit 13, and obtains (extracts) the "sales quantity" and "sales amount" for each product in each sales channel.

[0097] The display control unit 24 displays a list of the "sales quantity" and "sales amount" for each product in each sales channel, which are acquired from the sales-by-sales-channel-product storage unit 13, on the sales performance inquiry screen, as shown in Fig. 15. This allows the person in charge to analyze the "sales amount" of each product sold through each sales channel.

[0098] (Effects of the embodiment) As is clear from the above explanation, the business support device 1 of the embodiment can store not only the retail price but also sales information in which discount information is prorated by product or sales information before and after discounts for performance evaluation by sales channel. This allows performance evaluation and analysis to be performed from various perspectives. This makes it possible to simplify sales analysis work by sales channel and by product.

[0099] [Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This invention can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to the achievement of goals "8" and "9" of the SDGs.

[0100] Furthermore, this invention can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs goals 12, 13, and 15.

[0101] Furthermore, the present invention can contribute to strengthening control and governance, thereby contributing to the achievement of Goal 16 of the SDGs.

[0102] [Other embodiments] The present invention can be implemented in various different forms other than the above-described embodiments within the scope of the technical concept described in the claims.

[0103] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically may be performed manually, or all or part of the processes described as being performed manually may be performed automatically using a known method or the like.

[0104] Furthermore, the processing procedures, control procedures, specific names, registered data for each process, information including parameters such as search conditions, screen examples, and database configurations shown in the specification or drawings may be changed as desired unless otherwise specified.

[0105] Furthermore, the components of the business support device 1 shown in the figure are conceptual functional components and do not necessarily have to have the physical configuration shown in the figure. For example, all or any part of the processing functions of the business support device 1, particularly the processing functions performed by the control unit 3, may be realized by a program interpreted and executed by the control unit 3 (CPU: Central Processing Unit), or may be realized by hardware using wired logic.

[0106] The program is recorded on a non-transitory computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in the embodiments, and is mechanically read by the business support device 1 as needed. That is, a computer program is recorded in the storage unit 2, such as a ROM or HDD, for working with an OS (Operating System) to give instructions to a control unit 3 (CPU) and perform various processes. The computer program is loaded into RAM, expanded, and executed by the control unit 3 as appropriate.

[0107] In addition, the business support program of this business support device 1 may be stored in another server device connected to the business support device 1 via any network, and all or part of it may be downloaded and executed as needed.

[0108] Furthermore, the business support program for executing the processes described in the embodiments may be stored in a non-transitory computer-readable recording medium, or may be configured as a program product.

[0109] Here, the "recording medium" can be any "portable physical medium" such as a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical Disk), a DVD (Digital Versatile Disk), and a Blu-ray (registered trademark) Disc.

[0110] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code.

[0111] It should be noted that a "program" is not necessarily limited to a single structure, but includes a structure that is distributed as multiple modules or libraries, and a structure that achieves its function by working together with other programs, such as an OS.

[0112] Furthermore, the specific configuration for reading the recording medium in the task support device 1 of the embodiment, the reading procedure, and the installation procedure after reading can be any known configuration or procedure.

[0113] The memory unit 2 is a storage means such as a memory device such as RAM or ROM, a fixed disk device such as a hard disk, a flexible disk, or an optical disk, and stores various programs, tables, databases, web page files, etc. used for various processes or providing websites.

[0114] The business support device 1 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as an information processing device connected to any peripheral device. The information processing device may be implemented with software (including programs or data) that realizes the processes described in the embodiments.

[0115] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the drawings, and all or part of them can be functionally or physically distributed or integrated in any unit depending on various additions or functional loads. In other words, the above-mentioned embodiments can be selectively implemented by combining them in any way. [Industrial Applicability]

[0116] The present invention is suitable for application to sales performance management operations for each store in the distribution retail industry, for example, where commercial transactions such as products or services are sold through multiple sales channels. [Explanation of symbols]

[0117] 1 Business support equipment 2 Storage section 3. Control Unit 4. Communication interface section 5 Input / Output Interface Section 6 Input Devices 7 Output Devices 11. Pound Master Table 12 Sales data storage section 13 Sales Channel and Product Sales Memory 14 Prorated discount amount storage section 15 Sales amount memory section 21 Calculation section 22 Data Generation Unit 23 Output control section 24 Display control unit 25 Prorated discount calculation section 26 Prorated sales amount calculation section 27 Commission sales amount calculation section 28 Single item discount sales amount calculation section 50 Network 51 Store A terminal device 52 Store B terminal device 53 Store D terminal device

Claims

1. a prorated discount calculation unit that calculates, for each sales store and for each transaction object, a prorated discount amount, which is a discount amount corresponding to each sales amount of each transaction object, by dividing each sales amount of each transaction object by the total amount of each sales amount of each transaction object for each sales store, based on sales data including the sales amount of each transaction object and a predetermined prorated discount amount, the sales amount being acquired from each of a plurality of sales stores that sell the transaction objects; and an apportioned sales amount calculation unit that calculates, for each of the sales stores and for each of the commercial transaction objects, an apportioned sales amount, which is a sales amount reflecting the apportioned discount amount corresponding to each of the sales amounts of each of the commercial transaction objects, by subtracting, from each of the sales amounts of each of the commercial transaction objects, an apportioned discount amount corresponding to each of the sales amounts of each of the commercial transaction objects; a data generating unit that generates sales detail data by sales channel, the sales amount after apportionment for each of the sales stores and each of the commercial transaction objects being included as the sales amount for each of the sales stores and each of the commercial transaction objects; an output control unit that outputs the generated sales detail data by sales channel to an output target device; A business support device having the above.

2. and a commission sales amount calculation unit that refers to a commission master table in which the commission rates for each sales store and each transaction object are stored, and calculates a commission sales amount, which is the sales amount for each sales store and each transaction object for which the commission rate is set, by multiplying the prorated sales amount for each sales store and each transaction object for which the commission rate is set by the commission rate, the data generation unit generates the sales detail data by sales channel in which, for the sales store and the commercial transaction object for which the commission rate is not set, the prorated sales amount is set as the sales amount, and, for the sales store and the commercial transaction object for which the commission rate is set, the commission rate sales amount is set as the sales amount; 2. The business support device according to claim 1, wherein:

3. The sales data includes, as the sales amount, a gross price, which is the amount desired by the manufacturer or provider of the commercial transaction object, and also includes, together with the pro rata discount amount, a single item discount amount that is discounted each time one of the commercial transaction objects is purchased, The system further includes a unit-after-discount sales amount calculation unit that calculates a unit-after-discount sales amount by subtracting the unit-after-discount amount from the retail price of each of the commercial transaction objects, the prorated discount amount calculation unit calculates the prorated discount amount corresponding to each sales amount of each of the commercial transaction objects for each of the sales stores by multiplying each division result obtained by dividing the sales amount of each of the commercial transaction objects for each of the sales stores by the total amount of the sales amount of each of the commercial transaction objects for each of the sales stores after the discount of each of the individual items, by the prorated discount amount; 3. The business support device according to claim 2, wherein:

4. The sales data includes, as the predetermined pro rata discount amount, a point discount amount, which is a discount amount corresponding to points added according to the purchase amount, the prorated discount amount calculation unit calculates, for each sales store and for each commercial transaction object, a prorated point discount amount which is the prorated discount amount corresponding to each sales amount of each of the commercial transaction objects by multiplying each division result obtained by dividing each of the sales amounts of each of the commercial transaction objects by the total amount of each of the sales amounts of each of the commercial transaction objects for each sales store by the point discount amount; 4. The business support device according to claim 3, wherein:

5. The sales data includes, as the predetermined pro rata discount amount, a bulk discount amount that is a discount amount applied when a predetermined number of the commercial transaction objects are purchased in bulk, the prorated discount amount calculation unit calculates, for each sales store and for each commercial transaction object, a prorated bulk discount amount which is the prorated discount amount corresponding to each sales amount of each of the commercial transaction objects by multiplying each division result obtained by dividing each of the sales amounts of each of the commercial transaction objects by the total amount of each of the sales amounts of each of the commercial transaction objects for each sales store by the bulk discount amount; 5. The business support device according to claim 4, wherein:

6. the prorated sales amount calculation unit calculates, for each of the sales stores, the prorated discount amounts corresponding to the sales amounts of each of the commercial transaction objects, the point discount amount and the bulk discount amount, from the sales amounts of each of the commercial transaction objects, to calculate, for each of the sales stores and for each of the commercial transaction objects, the prorated sales amount reflecting the point discount amount and the bulk discount amount corresponding to the sales amounts of each of the commercial transaction objects; 6. The business support device according to claim 5,

7. a display control unit that displays on a display unit a sales performance inquiry screen having an input field for an analysis sales category for specifying any one of the retail price, the sales amount after discount of the single item, the pro rata sales amount, or the sales amount, and that, when the retail price is specified via the input field for the analysis sales category, displays a list of the retail price for each store and for each transaction object on the display unit; when the sales amount after discount of the single item is specified via the input field for the analysis sales category, displays a list of the sales amount after discount of the single item for each store and for each transaction object on the display unit; when the pro rata sales amount is specified via the input field for the analysis sales category, displays a list of the pro rata sales amount for each store and for each transaction object on the display unit; and when the sales amount is specified via the input field for the analysis sales category, displays a list of the sales amount for each store and for each transaction object on the display unit; 7. The business support device according to claim 3, wherein:

8. a prorated discount calculation step in which the prorated discount calculation unit calculates, for each sales store and for each commercial transaction object, a prorated discount amount, which is a discount amount corresponding to each sales amount of each commercial transaction object, by dividing each sales amount of each commercial transaction object by the total amount of each sales amount of each commercial transaction object for each sales store based on sales data including the sales amount of each commercial transaction object and a predetermined prorated discount amount, each obtained from a plurality of sales stores that sell the commercial transaction objects; and an apportioned sales amount calculation step in which the prorated sales amount calculation unit calculates, for each sales store and each commercial transaction object, an apportioned sales amount, which is the sales amount reflecting the prorated discount amount corresponding to each sales amount of each commercial transaction object, by subtracting, from each sales amount of each commercial transaction object, a prorated discount amount corresponding to each sales amount of each commercial transaction object; a data generation step in which a data generation unit generates sales detail data by sales channel including the prorated sales amount for each of the sales stores and each of the commercial transaction objects as the sales amount for each of the sales stores and each of the commercial transaction objects; an output control step in which an output control unit outputs the generated sales detail data by sales channel to an output target device; A business support method having the above.

9. Computer, a prorated discount calculation unit that calculates, for each sales store and for each transaction object, a prorated discount amount, which is a discount amount corresponding to each sales amount of each transaction object, by dividing each sales amount of each transaction object by the total amount of each sales amount of each transaction object for each sales store, based on sales data including the sales amount of each transaction object and a predetermined prorated discount amount, the sales amount being acquired from each of a plurality of sales stores that sell the transaction objects; and an apportioned sales amount calculation unit that calculates, for each of the sales stores and for each of the commercial transaction objects, an apportioned sales amount, which is a sales amount reflecting the apportioned discount amount corresponding to each of the sales amounts of each of the commercial transaction objects, by subtracting, from each of the sales amounts of each of the commercial transaction objects, an apportioned discount amount corresponding to each of the sales amounts of each of the commercial transaction objects; a data generating unit that generates sales detail data by sales channel, the sales amount after apportionment for each of the sales stores and each of the commercial transaction objects being included as the sales amount for each of the sales stores and each of the commercial transaction objects; an output control unit that outputs the generated sales detail data by sales channel to an output target device; A business support program that functions as a

Images