Business support device, business support method, and business support program

Abstract

To fairly count sales results of a real store and sales results of a virtual store.SOLUTION: An acquisition unit registers a store location of a real store as an inventory location of a commodity sold at the real store based on sales data including sales store information of the store that sells the commodity, shipping store information of a store that ships the commodity, and a sales amount of the commodity transmitted from the real store or the virtual store, and acquires a stock place of the store indicated by shipping store information included in sales data by referring to a storage unit in which a predetermined opening place set in the virtual store is registered as a stock place of a commodity sold in the virtual store. A data generation unit generates sales data including a sales classification indicating a sales store generated based on the sales store information included in the sales data, a stock location of the shipping store indicated by the shipping store information acquired from the storage unit, and a sales amount. An output control unit outputs sales data to an output target device.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] In the retail industry, the OMO (Online Merges with Offline) strategy is often used to expand sales channels and acquire customers through both real stores that are actually located in desired locations and virtual stores that are located on a network (virtual stores on EC (Electronic Commerce) sites).In addition, companies are trying to merge online and offline by sharing their own inventory information between real and virtual stores, making it possible to sell products from real stores in virtual stores as well.

[0003] Patent Document 1 (JP 2024-029059 A) discloses an inventory management support device that makes it possible to determine the number of sales by product from inventory information at the end of a special event period and select a destination for unsold inventory. In this inventory management support device, an import unit imports sales location inventory data including the number of products in stock at the sales location after the period ends. An acquisition unit acquires candidate destinations associated with a certain sales location from the destination management master and acquires the number of products in stock included in the sales location inventory data at the acquired candidate destinations from the inventory data. An output control unit outputs to an output device a screen on which the sales location inventory data and the data acquired by the acquisition unit are displayed for each product, allowing the destination to be selected. A transfer data generation unit generates transfer data including the number of products in stock after the period ends included in the sales location inventory data as the transfer number from a certain sales location to the transfer destination selected on the screen. [Prior art documents] [Patent documents]

[0004] [Patent Document 1] Japanese Patent Application Publication No. 2024-029059 Summary of the Invention [Problem to be solved by the invention]

[0005] When a product from a real store is sold in a virtual store, the sales record is counted as the sales record of the virtual store. This method of counting sales record has the disadvantage that the sales record of the real store and the sales record of the virtual store are not counted fairly, and the sales record is biased toward the virtual store.

[0006] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a business support device, a business support method, and a business support program that enable sales results of real stores and sales results of virtual stores to be counted fairly. [Means for solving the problem]

[0007] In order to solve the above-mentioned problems and achieve the objectives, the business support device of the present invention has an acquisition unit that registers the location of the real store as an inventory location of the product sold at the real store, sets a specified store location for the virtual store, and refers to a memory unit that registers the location of the set virtual store as an inventory location of the product sold at the virtual store, based on sales data including at least sales store information of the store that sold the product, shipping store information of the store that shipped the product, and the sales amount of the product, which is sent from a real store that is a store that is actually set up in a desired location or a virtual store that is a virtual store set up on a network; a data generation unit that generates sales data based on the sales store information included in the sales data, including at least a sales category indicating whether the sale was at a real store or a virtual store, the inventory location of the shipping store indicated by the shipping store information acquired from the memory unit, and the sales amount; and an output control unit that outputs the sales data to an output target device.

[0008] In addition, in order to solve the above-mentioned problems and achieve the objectives, the business support method of the present invention includes an acquisition step in which an acquisition unit registers the location of the real store as an inventory location of the product sold at the real store, sets a specified store location for the virtual store, and refers to a memory unit that has registered the location of the set virtual store as an inventory location of the product sold at the virtual store, based on sales data sent from a real store that is an actual store located in a desired location or a virtual store that is a virtual store located on a network, the sales data including at least sales store information of the store that sold the product, shipping store information of the store that shipped the product, and the sales amount of the product; a data generation step in which a data generation unit generates sales data based on the sales store information included in the sales data, the sales data including at least a sales category indicating whether the sale was at a real store or a virtual store, the inventory location of the shipping store indicated by the shipping store information acquired from the memory unit, and the sales amount; and an output control step in which an output control unit outputs the sales data to an output target device.

[0009] In addition, in order to solve the above-mentioned problems and achieve the objective, the business support program of the present invention causes a computer to function as an acquisition unit that registers the location of the real store as an inventory location of the product sold at the real store, sets a specified store location for the virtual store, and refers to a memory unit that registers the location of the set virtual store as an inventory location of the product sold at the virtual store, based on sales data sent from a real store that is an actual store located in a desired location or a virtual store that is a virtual store located on a network, the sales data including at least sales store information of the store that sold the product, shipping store information of the store that shipped the product, and the sales amount of the product; a data generation unit that generates sales data based on the sales store information included in the sales data, the sales data including at least a sales category indicating whether the sale was at a real store or a virtual store, the inventory location of the shipping store indicated by the shipping store information acquired from the memory unit, and the sales amount; and an output control unit that outputs the sales data to an output target device. [Effects of the Invention]

[0010] The present invention can fairly count the sales results of real stores and virtual stores, thereby promoting OMO. [Brief explanation of the drawings]

[0011] [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 sales department master table provided in the business support device according to the embodiment. [Figure 3] FIG. 3 is a diagram illustrating an example of an inventory location master table provided in the business support device according to the embodiment. [Figure 4] FIG. 4 is a diagram illustrating an example of a product master table provided in the business support device according to the embodiment. [Figure 5]FIG. 5 is a diagram illustrating an example of sales data generated by the business support device according to the embodiment. [Figure 6] Figure 6 shows an example of a sales performance inquiry screen by sales and marketing group, displayed on the business support device of the embodiment, showing the sales amount for each inventory location in each real store and the total sales amount calculated by aggregating the sales amounts of all virtual stores. [Figure 7] Figure 7 shows an example of a sales performance inquiry screen by inventory management sales group, displayed on the business support device of the embodiment, which shows the total sales amount of each real store and virtual store where the inventory location of the product is the same inventory location. DETAILED DESCRIPTION OF THE INVENTION

[0012] Hereinafter, an example in which the present invention is applied to a business support device that tally up sales data for each store in a sales system that sells products at real stores that are stores that are actually set up in desired locations and virtual stores that are virtual stores set up on a network will be described in detail with reference to the drawings. Note that the present invention is not limited to the following embodiments.

[0013] (System Configuration) First, as shown in Fig. 1, the sales system includes a business support device 1 according to an embodiment of the present invention, one or more server devices 51 that operate a virtual store, and one or more real store terminal devices 52 installed in a real store. The business support device 1, the server device 51, and the real store terminal devices 52 are interconnected so as to be able to communicate with each other via a network 50. The business support device 1 acquires sales data corresponding to sales of products in the virtual store from the server device 51 via the network 50. The business support device 1 also acquires sales data corresponding to sales of products in the real store from the real store terminal devices 52 via the network 50.

[0014] (Hardware configuration of business support device) 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 achieve a pointing device function. The communication interface unit 4 is connected to a network 50, for example, a wide area network such as the Internet or a private network such as a LAN (Local Area Network).

[0015] The storage unit 2 may be, for example, a read-only memory (ROM), a random access memory (RAM), a hard disk drive (HDD), or a solid state drive (SSD). The storage unit 2 stores a business support program that enables the sales results of real stores and virtual stores to be counted fairly. The storage unit 2 also includes a sales department master table 11, an inventory location master table 12, a product master table 13, and a sales data storage unit 14, each of which is a storage area.

[0016] In the sales department master table 11, as shown in Fig. 2, sales group codes and sales group names are stored in association with each other. In the example of Fig. 2, "A001" indicates the sales group code of the real store "Ginza Store," and "A002" indicates the sales group code of the real store "Shinjuku Store." In addition, in the example of Fig. 2, "A003" indicates the sales group code of the virtual store of the e-commerce site operated by the server device 51.

[0017] As shown in Figure 3, the inventory location master table 12 stores inventory location codes, which are assigned to each real store and each virtual store as if they were inventory locations for products, and inventory management sales group codes for the inventory management sales groups that manage inventory at the inventory locations of each inventory location code, in association with each other. The example in Figure 3 shows that the Ginza store, a real store, is assigned an inventory location code of "T001," and the inventory at the Ginza store with the inventory location code of "T001" is managed by the inventory management sales group with the inventory management sales group code of "A001."

[0018] As can be seen from FIGS. 2 and 3, the "Ginza store" is assigned a sales business group code of "A001" and an inventory management business group code of the same "A001."

[0019] The example in Figure 3 also shows that the Shinjuku store (main building), a brick-and-mortar store, has an inventory location code of "T002-1," and that the inventory at the Shinjuku store (main building) with an inventory location code of "T002-1" is managed by the inventory management sales group with an inventory management sales group code of "A002." The example in Figure 3 also shows that the Shinjuku store (branch building), a brick-and-mortar store, has an inventory location code of "T002-2," and that the inventory at the Shinjuku store (branch building) with an inventory location code of "T002-2" is managed by the inventory management sales group with an inventory management sales group code of "A002."

[0020] As can be seen from FIGS. 2 and 3, the "Shinjuku store (main building and branch)" is assigned the sales group code "A002" and the inventory management group code "A002".

[0021] Additionally, the virtual store's EC Warehouse West Japan Center is assigned an inventory location code of "S003-1," indicating that the inventory at this EC Warehouse West Japan Center with an inventory location code of "S003-1" is managed by the inventory management sales group with an inventory management sales group code of "A003." Additionally, the virtual store's EC Warehouse East Japan Center is assigned an inventory location code of "S003-2," indicating that the inventory at this EC Warehouse East Japan Center with an inventory location code of "S003-2" is managed by the inventory management sales group with an inventory management sales group code of "A003."

[0022] As can be seen from Figures 2 and 3, the "EC site and EC warehouse" (for the virtual store) is assigned the sales sales group code "A003" and the inventory management sales group code "A003".

[0023] In the product master table 13, the product code, product name, unit sales price, standard cost, and inventory management category of each product are stored in association with each other, as shown in Fig. 4. In the example of Fig. 4, product "1" is assigned a product code of "SH001," its unit sales price is "5,000 yen," its standard cost is "2,500 yen," and the inventory management category, which indicates whether or not inventory management is performed, is set to "yes (= inventory management is performed)." In addition, in the example of Fig. 4, product "3" is assigned a product code of "SH003," its unit sales price is "7,000 yen," its standard cost is "3,900 yen," and the inventory management category is set to "yes (= inventory management is performed)."

[0024] 5 shows an example of sales data generated by the data generation unit 22 and stored in the sales data storage unit 14 based on the sales data of each virtual store transmitted from the server device 51 and the sales data of each real store transmitted from each real store terminal device 52. As shown in this Fig. 5, the data generation unit 22 generates sales data including the sales slip number, sales date, sales category, sales group code, inventory location code, line number, product code, sales price, sales quantity, sales amount, and return slip number based on the sales data transmitted from each store.

[0025] The "sales category" is "store sales" for sales made in a real store, and "e-commerce sales" for sales made in a virtual store. If a discount is applied at the time of sale, sales data is generated with this "sales category" set to "sales discount." If a sold product is returned, sales data is generated with this "sales category" set to "sales returns."

[0026] The "inventory location code" is the code of the inventory location from which the sold product was shipped. In the example of Figure 5, the sales data with the sales slip number "UR001" indicates that the product was sold at the "Ginza Store" and the product was delivered from the inventory at the Ginza Store, which is the inventory location with the inventory location code "T001." Similarly, the sales data with the sales slip number "UR003" indicates that the product was sold at the "EC Site," a virtual store, and the product was shipped from the inventory at the West Japan Center of the EC Warehouse, which is the inventory location with the inventory location code "S003-1."

[0027] In contrast, sales data with sales slip number "UR004" indicates that a product was sold at the "EC site," a virtual store, but was shipped from inventory at the "Ginza store," which has an inventory location code of "T001." Similar to sales data with sales slip number "UR005," sales data indicates that a product was sold at the "EC site," a virtual store, but was shipped from inventory at the "Shinjuku store (annex)," which has an inventory location code of "T002-2." Sales data with sales slip number "UR007" indicates that a product with the above-mentioned sales slip number "UR004," sold at the "EC site," a virtual store, and shipped from inventory at the "Ginza store," which has an inventory location code of "T001," was returned.

[0028] The "Sales Group Code" indicates both the "Sales Sales Group Code" explained using Figure 2 and the "Inventory Management Sales Group Code" explained using Figure 3. That is, in Figure 5, the "Sales Sales Group Code" and the "Inventory Management Sales Group Code" are collectively shown as the "Sales Group Code."

[0029] Specifically, the sales data for the real store "Ginza Store" with sales slip number "UR001" in Figure 5 is assigned "A001" as the sales sales group code and inventory management sales group code. Also, the sales data for the real store "Shinjuku Store (Main Building and Annex)" with sales slip number "UR002" in Figure 5 is assigned "A002" as the sales sales group code and inventory management sales group code. Also, the sales data for the virtual stores of the "EC Site" with sales slip numbers "UR003" to "UR008" in Figure 5 is assigned "A003" as the sales sales group code and inventory management sales group code.

[0030] In the sales data for "UR004" and "UR005," the inventory location code is the code for the real store, even though the product was sold at a virtual store on the "EC site." This is because, as mentioned above, the product was sold at a virtual store on the "EC site" and shipped from the real store.

[0031] As explained with reference to FIG. 4, the "product code" is a code assigned to each product. The "unit sales price" is the price per product. As shown in FIG. 5, the sales data includes the sales quantity. The calculation unit 24 calculates the sales amount by multiplying the unit sales price by the sales quantity. The data generation unit 22 generates sales data including the calculated sales amount and stores it in the sales data storage unit 14.

[0032] Furthermore, when a discount is applied to a sale, the data generation unit 22 generates sales data including a discount amount, for example, "-1,000 yen," as shown in the sales data for the sales category "Sales Discount" in Fig. 5. Furthermore, when a product is returned, the data generation unit 22 generates sales data including a return amount, for example, "-7,000 yen," as shown in the sales data for the sales category "Sales Returns" in Fig. 5, and also including the sales slip number of the returned product, such as "UR004."

[0033] (Functional configuration of business support device) Next, the control unit 3 executes the business support program stored in the memory unit 2, and thereby functions as an acquisition unit 21, a data generation unit 22, an output control unit 23, a calculation unit 24, and a display control unit 25, as shown in FIG. 1.

[0034] The acquisition unit 21 registers the location of the real store as an inventory location for the products sold at the real store, sets a predetermined location for the virtual store, and acquires the inventory location of the store indicated by the shipping store information included in the sales data, based on sales data including at least sales store information for the store that sold the product, shipping store information for the store that shipped the product, and the sales amount of the product, which is sent from a real store (real store terminal device 52) that is a store that is actually located in the desired location or a virtual store (server device 51) that is a virtual store that has located on the network 50, and sets a predetermined location for the virtual store, and acquires the inventory location of the store indicated by the shipping store information included in the sales data, based on the sales data including at least sales store information for the store that sold the product,

[0035] The data generation unit 22 generates sales data (sales data in Figure 5) based on the sales store information included in the sales data, and includes at least a sales category indicating whether the sale was at a real store or a virtual store, the inventory location of the shipping store indicated by the shipping store information obtained from the memory unit (inventory location master table 12 in Figure 3), and the sales amount.

[0036] The output control unit 23 outputs the sales data to the output target device. As an example, if the output target device is a display unit, the output control unit 23 supplies the sales data to the display unit for display. If the output target device is a printer, the output control unit 23 supplies the sales data to the printer to obtain a printed output. If the output target device is a speaker device, the output control unit 23 supplies the sales data to the speaker device to obtain an audio output. If the output target device is a storage device such as the memory unit 2, an external memory unit, or a server device, the sales data is supplied to the storage device for storage.

[0037] The storage unit (stock location master table 12 in FIG. 3) also stores, in association with each stock location, the sales group code of the sales group in charge of the real store or virtual store of each stock location.

[0038] The calculation unit 24 refers to the sales data based on the sales group code and calculates the sales addition amount by adding up the sales amounts of each real store or each virtual store at each inventory location that each sales group is responsible for.

[0039] The data generating unit 22 generates sales performance inquiry screen data by sales group including the calculated sales addition amount, and the output control unit 23 outputs this sales performance inquiry screen data by sales group to the output target device.

[0040] The calculation unit 24 also calculates the net sales amount obtained by subtracting the discount amount and the returned goods amount from the sales amount, the gross profit amount obtained by multiplying the standard cost of the sold goods by the sales quantity and subtracting it from the net sales amount, and the gross profit rate which is the ratio of the gross profit to the net sales amount. The data generation unit 22 generates sales performance inquiry screen data by sales and marketing group including the calculated net sales amount, gross profit amount, and gross profit rate.

[0041] In addition, the storage unit (inventory location master table 12 in Figure 3) stores, in association with each inventory location, the inventory management sales group code of the inventory management sales group that manages inventory at the real store or virtual store of each inventory location.

[0042] The calculation unit 24 refers to the sales data based on the inventory management sales group code and calculates the inventory management sales surcharge amount by adding up the sales amounts of each real store or each virtual store at each inventory location where each inventory management sales group manages inventory.

[0043] The data generation unit 22 generates inventory management sales group sales performance inquiry screen data including the calculated inventory management sales addition amount, and the output control unit 23 outputs the inventory management sales group sales performance inquiry screen data to the output target device.

[0044] The calculation unit 24 also calculates the net sales amount obtained by subtracting the discount amount and the return amount from the sales amount, the gross profit amount obtained by multiplying the standard cost of the sold goods by the sales quantity and subtracting it from the net sales amount, and the gross profit rate, which is the ratio of the gross profit amount to the net sales amount.

[0045] The data generating unit 22 generates inventory management sales group sales performance inquiry screen data including the calculated net sales amount, gross profit amount, and gross profit rate.

[0046] (Sales management operation with each store as an inventory location) Next, a sales management operation in which each store is regarded as an inventory location in the business support device 1 of the embodiment will be described. First, the acquisition unit 21 refers to the inventory location master table 12 shown in Fig. 3 based on the sales data of the virtual store transmitted from the server device 51 and the sales data of the real store transmitted from the real store terminal device 52. Then, the acquisition unit 21 acquires the inventory location code corresponding to the store indicated in the shipping store information included in the sales data.

[0047] Based on the sales store information included in the sales data, the data generation unit 22 generates sales data including a sales category indicating whether the sale was made at a real store or a virtual store, an inventory location code corresponding to the store obtained from the inventory location master table 12, and a sales amount. Figure 5 is a diagram showing an example of this sales data.

[0048] As shown in Figure 5, the data generation unit 22 generates sales data including the sales category, inventory location code, and sales amount, as well as the sales slip number, line number, sales date, sales group code, product code, sales price, sales quantity, and return slip number, and stores the data in the sales data storage unit 14.

[0049] This sales data is output via the output control unit 23 to the output target device so that it can be recognized visually or audibly. This makes it possible to recognize the store where the product was sold based on the "sales category," and the store corresponding to the inventory location from which the product was shipped based on the inventory location code. Furthermore, the sales amount makes it possible to recognize the sales amount of the product shipped from the inventory location indicated by the inventory location code.

[0050] Therefore, by outputting this sales data to the output target device, sales at each store can be counted as sales by inventory location, preventing the inconvenience of sales at a real store being counted as sales at a virtual store on an EC site. In other words, sales at both the virtual store on an EC site and the real store can be counted fairly and sales at both can be managed.

[0051] [Display behavior of sales performance inquiry screen by sales group] Next, the business support device 1 according to the embodiment is capable of displaying a sales performance inquiry screen by "sales business group" or "inventory management business group" based on such sales data.

[0052] (Display behavior of sales performance inquiry screen by sales group) First, the operator selects either the "by sales group" or "by inventory management group" inquiry category, specifies the desired target year and month, and commands the display of the sales performance inquiry screen. In this example, the target year and month is "November 2023," and the display of the "by sales group" sales performance inquiry screen is specified.

[0053] When the display of the sales performance inquiry screen by sales sales group is specified, the calculation unit 24 aggregates the sales amounts of the sales data for the specified target year and month for each sales sales group code, and also aggregates the sales amounts of the sales data for the specified target year and month for each inventory management sales group, for the sales data shown in Figure 5. Furthermore, the calculation unit 24 aggregates the sales amounts of the sales data for the specified target year and month for each inventory location code based on the inventory management sales group code set in the inventory location master table 12 as the smallest aggregation unit.

[0054] The calculation unit 24 performs the above calculations by aggregating the sales amounts of products that are subject to inventory management and whose inventory management classification is "Yes" in the product master table 13 shown in FIG.

[0055] The data generating unit 22 generates sales performance inquiry screen data for each sales sales group that reflects the tabulation results. The display control unit 25 displays the sales performance inquiry screen for each sales sales group, as shown in Fig. 6, via the output device 7, based on the generated sales performance inquiry screen data for each sales sales group.

[0056] That is, the calculation unit 24 calculates the total sales amount for each sales sales group, the total sales amount for the inventory management sales group, and the total sales amount for the inventory location based on the sales data for the same sales sales group code and the same inventory location code, and the display control unit 25 displays these on the sales performance inquiry screen for each sales sales group.

[0057] Specifically, the two sales data for the sales slip number "UR001" shown in Figure 5 have a sales group code of "A001" and an inventory location code of "T001" indicating the "Ginza store." This sales format indicates a regular store sale, as the sales category is "store sales" and the inventory location code is "T001" and "Ginza store."

[0058] The calculation unit 24 adds the sales amounts of the two sales data with the sales slip number "UR001" to calculate "16,000 yen (10,000 yen + 6,000 yen)" as the total sales amount of the sales sales group with the sales sales group code "A001."

[0059] Furthermore, since "A001" is also the inventory management sales group code of the inventory management sales group, the calculation unit 24 calculates the total sales amount of "16,000 yen" as the total sales amount of the inventory management sales group with the inventory management sales group code of "A001."

[0060] Furthermore, the calculation unit 24 calculates "16,000 yen (10,000 yen + 6,000 yen)" as the total sales amount of the sales data for the inventory location code "Ginza store" of "T001" with the sales sales group code "A001". This makes it possible to calculate the total sales amount for the "Ginza store" with the inventory location code "T001" that is in charge of the sales group with the sales sales group code "A001".

[0061] The data generation unit 22 generates sales performance inquiry screen data for each sales sales group that reflects these total sales amounts. Based on the generated sales performance inquiry screen data for each sales sales group, the display control unit 25 displays the sales performance inquiry screen for each sales sales group, as shown in Fig. 6, via the output device 7. As a result, as shown in Fig. 6, the total sales amount of the sales sales group with the sales sales group code of "A001", the total sales amount of the inventory management sales group with the inventory management sales group code of "A001", and the total sales amount of the "Ginza store" with the inventory location code of "T001" can be displayed on the sales performance inquiry screen for each sales sales group.

[0062] The calculation unit 24 also calculates the gross profit amount for the total sales amount of the sales sales group with the sales sales group code "A001", which is "7,500 yen" in this example, by calculating "net sales amount - (standard cost of the product shown in FIG. 4 x sales quantity)". The calculation unit 24 also calculates the gross profit rate of "46.9%" for the sales sales group with the sales sales group code "A001" by calculating "gross profit amount 7,500 yen ÷ net sales amount 16,000 yen x 100 ≒ 46.9%".

[0063] Similarly, the calculation unit 24 calculates the gross profit amount (7,500 yen) and gross profit rate (46.9%) for the total sales amount of the inventory management sales group with the inventory management sales group code of "A001." It also calculates the gross profit amount (7,500 yen) and gross profit rate (46.9%) for the total sales amount of the "Ginza store" with the inventory location code of "T001."

[0064] The data generation unit 22 generates sales performance inquiry screen data for each sales sales group that reflects the gross profit amount and gross profit rate. The display control unit 25 displays the gross profit amount and gross profit rate on the sales performance inquiry screen based on the generated sales performance inquiry screen data for each sales sales group, as shown in Figure 6.

[0065] Next, of the two sales data for the sales slip number "UR002" shown in Figure 5, one is sales data for the sales category "store sales" and the other is sales data for the sales category "sales discount." Therefore, based on the sales data for the sales category "store sales," the calculation unit 24 calculates "21,000 yen" as the total sales amount for the sales sales group with the sales sales group code "A002."

[0066] Furthermore, since "A002" is also the inventory management sales group code of the inventory management sales group, the calculation unit 24 calculates the total sales amount of "21,000 yen" as the total sales amount of the inventory management sales group with the inventory management sales group code of "A002."

[0067] Furthermore, the calculation unit 24 calculates "21,000 yen" as the total sales amount of the sales data for the inventory location code "Shinjuku store (main building)" of "T002-1" with the sales sales group code of "A002". This makes it possible to calculate the total sales amount of the "Shinjuku store (main building)" with the inventory location code of "T002-1" that is handled by the sales sales group with the sales sales group code of "A002".

[0068] The data generation unit 22 generates sales performance inquiry screen data for each sales sales group that reflects these total sales amounts. Based on the generated sales performance inquiry screen data for each sales sales group, the display control unit 25 displays the sales performance inquiry screen for each sales sales group, as shown in Fig. 6, via the output device 7. As a result, as shown in Fig. 6, the total sales amount of the sales sales group with the sales sales group code of "A002", the total sales amount of the inventory management sales group with the inventory management sales group code of "A002", and the total sales amount of "Shinjuku Store (Main Building)" with the inventory location code of "T002-1" can be displayed on the sales performance inquiry screen for each sales sales group.

[0069] Furthermore, the calculation unit 24 calculates the gross profit amount by calculating "net sales amount - (standard cost of the product shown in Figure 4 x sales quantity)", but of the sales slips with the sales slip number "UR002" shown in Figure 5, the other sales slip has a sales category of "sales discount" and a discount of "1,000 yen". Therefore, the calculation unit 24 subtracts "1,000 yen", which is the "sales discount", from the total sales amount of "21,000 yen" of the sales sales group with the sales sales group code of "A002", and calculates the net sales amount relative to the total sales amount of the sales sales group with the sales sales group code of "A002", which is "20,000 yen".

[0070] Furthermore, the calculation unit 24 calculates a gross profit amount of "11,700 yen" as the gross profit amount of the sales sales group with the sales sales group code of "A002" by calculating "standard cost (see FIG. 4) × sales quantity = 3,900 yen × 3" for the product code "SH003" from the net sales amount of "20,000 yen (discounted)". Furthermore, the calculation unit 24 calculates a gross profit rate of "58.5%" as the gross profit amount of the sales sales group with the sales sales group code of "A002" by calculating "gross profit amount of 11,700 yen ÷ net sales amount of 20,000 yen × 100 ≒ 58.5%".

[0071] Similarly, the calculation unit 24 calculates the gross profit amount (11,700 yen) and gross profit rate (58.5%) for the total sales amount of the inventory management sales group with the inventory management sales group code of "A002". Similarly, the calculation unit 24 calculates the gross profit amount (11,700 yen) and gross profit rate (58.5%) for the total sales amount of "Shinjuku Store (Main Building)" with the inventory location code of "T002-1" which is handled by the sales sales group with the sales sales group code of "A002".

[0072] The data generation unit 22 generates sales performance inquiry screen data for each sales sales group that reflects the gross profit amount, gross profit rate, and the discount amount described above. The display control unit 25 displays the gross profit amount, gross profit rate, and discount amount on the sales performance inquiry screen as shown in Figure 6 based on the generated sales performance inquiry screen data for each sales sales group.

[0073] Next, the calculation unit 24 calculates the total sales amount of "92,000 yen" by adding up the sales amounts of the sales category "EC sales" corresponding to the sales sales group with the sales sales group code of "A003" based on the sales data of the sales slip numbers "UR003" to "UR008" shown in Figure 5.

[0074] 5, the sales slip with the sales slip number "UR0007" has a sales category of "returned sales" and indicates that a product with a product code of "SH003" was returned to the "Ginza store" with an inventory location code of "T001", resulting in a sales amount of "-7,000 yen." Therefore, the calculation unit 24 calculates the net sales amount of "85,000 yen" by subtracting "7,000 yen" for the product returned to the Ginza store from the total sales amount of "92,000 yen" of the sales sales group with the sales sales group code of "A003."

[0075] In addition, the calculation unit 24 subtracts the amount (product cost x sales quantity = 50,900 yen) of each product sold at the virtual store on the EC site from the net sales amount (85,000 yen (after returns processing)) to calculate the gross profit amount of the sales sales group with the sales sales group code of "A003" as "34,100 yen."

[0076] In addition, the calculation unit 24 divides the gross profit amount of "34,100 yen" by the net sales amount of "85,000 yen (after returns processing)" to calculate "40.1%" as the gross profit rate of the sales sales group of the sales sales group code.

[0077] Similarly, the calculation unit 24 calculates the total sales amount (41,000 yen) of the "Ginza Store" with the inventory location code "T001" managed by the inventory management sales group with the inventory management sales group code "A001", the net sales amount of "34,000 yen" reflecting the returned amount of "7,000 yen", the gross profit amount of "14,900 yen", and the gross profit rate of "43.8%".

[0078] Similarly, the calculation unit 24 calculates the total sales amount (41,000 yen) of the "Ginza store" with inventory location code "T001", the net sales amount of "34,000 yen" reflecting the returned amount of "7,000 yen", the gross profit amount of "14,900 yen", and the gross profit rate of "43.8%".

[0079] The data generation unit 22 generates sales performance inquiry screen data for each sales group that reflects the total sales amount (92,000 yen), net sales amount (85,000 yen), gross profit amount (34,100 yen), gross profit rate (40.1%), and discount amount (-7,000 yen) calculated in this manner for the sales group with the sales group code "A003."

[0080] Based on the generated sales performance inquiry screen data by sales sales group, the display control unit 25 displays the total sales amount (92,000 yen), net sales amount (85,000 yen), gross profit amount (34,100 yen), gross profit rate (40.1%), and discount amount (-7,000 yen) of the sales sales group with the sales sales group code "A003" on the sales performance inquiry screen by sales sales group, as shown in Figure 6.

[0081] Here, the sales data for each sales slip number "UR003," "UR006," and "UR008" shown in Figure 5 each have a sales category of "EC sales," and the inventory location code is either "EC Warehouse West Japan Center" with an inventory location code of "S003-1" or "EC Warehouse East Japan Center" with an inventory location code of "S003-2," indicating the inventory location of the EC site. Therefore, it can be seen that the sales data for each sales slip number "UR003," "UR006," and "UR008" are sales data that constitute normal EC sales, generated when products are sold on the EC site and shipped from the EC site's inventory location.

[0082] In this case, the calculation unit 24 calculates "36,000 yen", which is the sum of the sales amounts of the sales data of "UR003" and "UR006", as the amount of regular EC sales incurred due to shipping from the "EC Warehouse West Japan Center" with inventory location code "S003-1". Similarly, the calculation unit 24 calculates "5,000 yen", which is the sales amount of the sales data of "UR008", as the amount of regular EC sales incurred due to shipping from the "EC Warehouse East Japan Center" with inventory location code "S003-2".

[0083] Then, the calculation unit 24 adds together the sales amount of "36,000 yen" of the "EC Warehouse West Japan Center" whose inventory location code is "S003-1" and the sales amount of "5,000 yen" of the "EC Warehouse East Japan Center" whose inventory location code is "S003-2", to calculate "41,000 yen", as the sales amount of the virtual store of the EC site managed by the inventory management sales group whose inventory management sales group code is "A003".

[0084] In addition, by performing the above-mentioned calculations based on the sales amount of "41,000 yen," the calculation unit 24 calculates the net sales amount (no discounts or returns) of "41,000 yen," the gross profit amount of "18,100 yen," and the gross profit rate of "44.1%" for the virtual store on the EC site managed by the inventory management sales group "A003."

[0085] The data generation unit 22 and the display control unit 25 display the total sales amount (41,000 yen), net sales amount (41,000 yen: no discounts or returns), gross profit amount (18,100 yen), and gross profit rate (44.1%) of the virtual store on the EC site managed by the inventory management sales group "A003" calculated in this manner on the sales performance inquiry screen by sales sales group shown in Figure 6.

[0086] Furthermore, the calculation unit 24 performs the above-mentioned calculations based on the sales amount of "36,000 yen", to calculate the net sales amount of "36,000 yen", the gross profit amount of "15,600 yen", and the gross profit rate of "43.3%" for the "EC Warehouse West Japan Center" whose inventory location code is "S003-1". Furthermore, the calculation unit 24 performs the above-mentioned calculations based on the sales amount of "5,000 yen", to calculate the net sales amount of "5,000 yen", the gross profit amount of "2,500 yen", and the gross profit rate of "50.0%" for the "EC Warehouse East Japan Center" whose inventory location code is "S003-2".

[0087] The data generation unit 22 and the display control unit 25 display the net sales amount of "36,000 yen", the gross profit amount of "15,600 yen", and the gross profit rate of "43.3%" calculated in this way for the "EC Warehouse West Japan Center" whose inventory location code is "S003-1", and the net sales amount of "5,000 yen", the gross profit amount of "2,500 yen", and the gross profit rate of "50.0%" calculated in this way for the "EC Warehouse East Japan Center" whose inventory location code is "S003-2", on the sales performance inquiry screen by sales and marketing group shown in FIG. 6.

[0088] This makes it possible to recognize the sales amount of the "EC Warehouse West Japan Center" with inventory location code "S003-1" and the sales amount of the "EC Warehouse East Japan Center" with inventory location code "S003-2" in a normal EC sales format.

[0089] Next, the two sales data items with the sales slip number "UR004" shown in Figure 5 have a sales category of "EC sales" but an inventory location code of "T001" for the "Ginza store." This indicates that the product was sold at a virtual store on the EC site, but was shipped from the real store, the "Ginza store."

[0090] Furthermore, the sales data for the sales slip number "UR007" shown in Figure 5 shows that the sales category is "returned sales," the inventory location code is "T001" for the "Ginza store," and the return slip is "UR004." This indicates that a product sold at a virtual store on the e-commerce site and shipped from the "Ginza store" was returned to the "Ginza store" (sales amount: -7,000 yen).

[0091] In this case, the calculation unit 24 calculates "41,000 yen" by adding up the sales amounts of each sales data of "UR004", as the sales amount of the "Ginza Store" managed by the inventory management sales group with the inventory management sales group code of "A001", which was generated by selling the product at the virtual store on the EC site and shipping it from the "Ginza Store" with the inventory location code of "T001".

[0092] In addition, the calculation unit 24 calculates the net sales amount of "34,000 yen" for the "Ginza Store" managed by the inventory management sales group "A001" by subtracting the return amount of "7,000 yen" for the returned products from the sales amount of "41,000 yen."

[0093] Furthermore, the calculation unit 24 performs the above-mentioned calculation based on the net sales amount of "34,000 yen" to calculate the gross profit amount of "14,900 yen" and the gross profit rate of "43.8%".

[0094] The data generation unit 22 and the display control unit 25 display the calculated sales amount (41,000 yen), net sales amount (34,000 yen), gross profit amount (14,900 yen), and gross profit rate (43.8%) of the "Ginza Store" managed by the inventory management sales group "A001" on the sales performance inquiry screen by sales sales group shown in Figure 6.

[0095] In addition, the calculation unit 24 performs the above-mentioned calculations based on the sales amount of "41,000 yen" to calculate the net sales amount of "34,000 yen", the gross profit amount of "14,900 yen", and the gross profit rate of "43.8%" for the "Ginza store" whose inventory location code is "T001".

[0096] The data generation unit 22 and the display control unit 25 display the net sales amount of "34,000 yen", the gross profit amount of "14,900 yen", the gross profit rate of "43.8%", and the discount amount of "-7,000 yen" for the "Ginza store" whose inventory location code is "T001" calculated in this way on the sales performance inquiry screen by sales business group shown in Figure 6.

[0097] This means that even if a sale is made at a virtual store on an e-commerce site and the product is shipped from the real "Ginza Store," the sales amount can be recognized as the sales amount of the "Ginza Store."

[0098] Next, the sales data for the sales slip number "UR005" shown in Figure 5 has a sales category of "EC sales," but the inventory location code is "T002-2" for "Shinjuku store (branch)." This indicates that the product was sold at a virtual store on the EC site, but was shipped from the real store, "Shinjuku store (branch)."

[0099] In this case, the calculation unit 24 calculates the sales amount of "10,000 yen" in the sales data of "UR005" as the sales amount of "Shinjuku Store (Branch)" managed by the inventory management sales group with the inventory management sales group code of "A002", which was generated by selling the product at the virtual store on the EC site and shipping it from "Shinjuku Store (Branch)" with the inventory location code of "T002-2".

[0100] Furthermore, since there are no returns or discounts, the calculation unit 24 calculates the sales amount of "10,000 yen" as the net sales amount. Furthermore, the calculation unit 24 performs the above-mentioned calculation based on this "10,000 yen" as the net sales amount, thereby calculating the gross profit amount of "5,000 yen" and the gross profit rate of "50.0%".

[0101] The data generation unit 22 and the display control unit 25 display the sales amount (10,000 yen), net sales amount (10,000 yen), gross profit amount (5,000 yen), and gross profit rate (50.0%) of the "Shinjuku Store (Branch)" managed by the inventory management sales group "A002" calculated in this manner on the sales performance inquiry screen by sales sales group shown in Figure 6.

[0102] In addition, the calculation unit 24 performs the above-mentioned calculations based on the sales amount of "10,000 yen" to calculate the net sales amount of "10,000 yen", the gross profit amount of "5,000 yen", and the gross profit rate of "50.0%" for "Shinjuku Store (Branch)" whose inventory location code is "T002-2".

[0103] The data generation unit 22 and the display control unit 25 display the net sales amount of "10,000 yen", the gross profit amount of "5,000 yen", and the gross profit of "50.0%" calculated in this way for "Shinjuku Store (Branch)" whose inventory location code is "T002-2" on the sales performance inquiry screen by sales and marketing group shown in Figure 6.

[0104] This means that even if a sale is made at a virtual store on an e-commerce site and the product is shipped from the real store, "Shinjuku Store (Branch)," the sales amount can be recognized as the sales amount of "Shinjuku Store (Branch)."

[0105] (Display behavior of sales performance inquiry screen by inventory management sales group) Next, the operator specifies the target year and month as "November 2023" and specifies the display of the sales performance inquiry screen "by inventory management sales group."

[0106] When the display of the sales performance inquiry screen by inventory management sales group is specified, the calculation unit 24 aggregates the sales amounts of the sales data for the specified target year and month for each inventory management sales group code for the sales data shown in Figure 5, and also aggregates the sales amounts of the sales data for the specified target year and month for each sales sales group. Furthermore, the calculation unit 24 aggregates the sales amounts of the sales data for the specified target year and month for each inventory location code based on the inventory management sales group code set in the inventory location master table 12 as the smallest aggregation unit.

[0107] The calculation unit 24 performs the above calculations by aggregating the sales amounts of products that are subject to inventory management and whose inventory management classification is "Yes" in the product master table 13 shown in FIG.

[0108] The data generation unit 22 generates sales performance inquiry screen data for each inventory management sales group that reflects the aggregation results. The display control unit 25 displays the sales performance inquiry screen for each inventory management sales group, as shown in Fig. 7, via the output device 7, based on the generated sales performance inquiry screen data for each inventory management sales group.

[0109] That is, the calculation unit 24 calculates the total sales amount for each inventory management sales group, the total sales amount for the sales sales group, and the total sales amount for each inventory location based on the sales data for the same inventory management sales group code and the same inventory location code, and the display control unit 25 displays these on the sales performance inquiry screen for each inventory management sales group.

[0110] Specifically, the calculation unit 24 aggregates the sales data for the "Ginza store" with inventory location code "T001" that is managed by the inventory management sales group with inventory management sales group code "A001" from the sales data with sales categories of "store sales" and "EC sales" shown in Fig. 5. As a result, the total sales amount of "57,000 yen (10,000 yen + 6,000 yen + 6,000 yen + 35,000 yen)" can be calculated as the total sales amount for the "Ginza store" with inventory location code "T001" that is managed by the inventory management sales group with inventory management sales group code "A001".

[0111] In the case of the Ginza store, a sales amount of "-7,000 yen" has been generated under the sales slip number "UR007." Therefore, the calculation unit 24 subtracts the returned amount of "7,000 yen" from the total sales amount of "57,000 yen" for the "Ginza store" to calculate the net sales amount of "50,000 yen" for the "Ginza store."

[0112] The calculation unit 24 also calculates the gross profit amount for the total sales amount of the "Ginza Store" managed by the inventory management sales group with the inventory management sales group code of "A001", which is "22,400 yen" in this example, by calculating "net sales amount - (standard cost of the product shown in FIG. 4 x sales quantity)". The calculation unit 24 also calculates the gross profit rate of "44.8%" for the "Ginza Store" managed by the inventory management sales group with the inventory management sales group code of "A001" by calculating "gross profit amount of 22,400 yen ÷ net sales amount of 50,000 yen x 100 ≒ 44.8%".

[0113] The data generation unit 22 generates sales performance inquiry screen data for each inventory management sales group that reflects these gross profit amounts and gross profit rates. Based on the generated sales performance inquiry screen data for each inventory management sales group, the display control unit 25 displays the total sales amount (57,000 yen), net sales amount (50,000 yen), gross profit amount (22,400 yen), and gross profit rate (44.8%) of the "Ginza store" managed by the inventory management sales group with the inventory management sales group code "A001" on the sales performance inquiry screen, as shown in Fig. 7.

[0114] Next, the calculation unit 24 calculates the sales amount of "16,000 yen (10,000 yen + 6,000 yen)" as the sales amount for the "Ginza Store" with inventory location code "T001" which is handled by the sales and marketing group "A001." In this example, the seller of the returned "7,000 yen" product is a virtual store on the e-commerce site. In this case, the calculation unit 24 recognizes "no returns" and "no discount," and calculates the sales amount of "16,000 yen" as the net sales amount.

[0115] Furthermore, the calculation unit 24 calculates the gross profit amount of "7,500 yen" and the gross profit rate of "46.9%" by the above-mentioned calculation based on the net sales amount of "16,000 yen".

[0116] The data generation unit 22 and the display control unit 25 display the calculated sales amount (16,000 yen), net sales amount (16,000 yen), gross profit amount (7,500 yen), and gross profit rate (46.9%) of the "Ginza Store" which is handled by the sales group with the sales group code "A001" on the sales performance inquiry screen.

[0117] Next, the calculation unit 24 calculates the sales amount of "16,000 yen (10,000 yen + 6,000 yen)" as the sales amount of "Ginza Store" with inventory location code "T001". In this example, the seller of the returned "7,000 yen" product is a virtual store on the EC site. In this case, the calculation unit 24 recognizes "no returns" and "no discount" and calculates the sales amount of "16,000 yen" as the net sales amount.

[0118] Furthermore, the calculation unit 24 calculates the gross profit amount of "7,500 yen" and the gross profit rate of "46.9%" by the above-mentioned calculation based on the net sales amount of "16,000 yen".

[0119] The data generation unit 22 and the display control unit 25 display the sales amount (16,000 yen), net sales amount (16,000 yen), gross profit amount (7,500 yen), and gross profit rate (46.9%) of the Ginza store calculated in this manner on the sales performance inquiry screen.

[0120] Next, the calculation unit 24 calculates the sales amount of "41,000 yen (6,000 yen + 35,000 yen)" as the sales amount of the "Ginza Store" with inventory location code "T001" that is handled by the sales and marketing group "A003." In addition, in this example, products sold at the virtual store on the e-commerce site have been returned (return amount = 7,000 yen). Therefore, the calculation unit 24 calculates the net sales amount of "34,000 yen" by subtracting the return amount of "7,000 yen" from the sales amount of "41,000 yen." Furthermore, based on the net sales amount of "34,000 yen," the calculation unit 24 calculates the gross profit amount of "14,900 yen" and the gross profit rate of "43.8%" by the above-mentioned calculation.

[0121] The data generation unit 22 and the display control unit 25 display the calculated sales amount (41,000 yen), net sales amount (34,000 yen), gross profit amount (14,900 yen), and gross profit rate (43.8%) of the "EC site virtual store" managed by the sales sales group with the sales sales group code "A003" on the sales performance inquiry screen, together with the returned goods amount of "7,000 yen."

[0122] Next, the calculation unit 24 calculates the sales amount of "41,000 yen (6,000 yen + 35,000 yen)" as the sales amount of the products sold at the virtual store of the EC site and shipped from the "Ginza Store" with the inventory location code of "T001." In addition, in this example, the products sold at the virtual store of the EC site have been returned (return amount = 7,000 yen). Therefore, the calculation unit 24 calculates the net sales amount of "34,000 yen" by subtracting the return amount of "7,000 yen" from the sales amount of "41,000 yen." Furthermore, based on the net sales amount of "34,000 yen," the calculation unit 24 calculates the gross profit amount of "14,900 yen" and the gross profit rate of "43.8%" by the above-mentioned calculation.

[0123] The data generation unit 22 and the display control unit 25 display the calculated sales amount (41,000 yen), net sales amount (34,000 yen), gross profit amount (14,900 yen) and gross profit rate (43.8%) of the sales format sold at the virtual store of the EC site and shipped from the "Ginza store" with the inventory location code of "T001" on the sales performance inquiry screen, together with the returned amount of "7,000 yen."

[0124] Next, the calculation unit 24 aggregates the sales data for the "Shinjuku store (main building and annex)" with inventory location codes "T002-1" and "T002-2" that are managed by the inventory management sales group with inventory management sales group code "A002". As a result, the total sales amount of "31,000 yen (21,000 yen + 10,000 yen)" can be calculated as the total sales amount for the "Shinjuku store (main building and annex)" with inventory location codes "T002-1" and "T002-2" that are managed by the inventory management sales group with inventory management sales group code "A002".

[0125] In the case of the Shinjuku store, a discount of "-1,000 yen" has occurred for the sales slip number "UR002." Therefore, the calculation unit 24 subtracts the discount amount of "1,000 yen" from the sales amount of "31,000 yen" for the "Shinjuku store" to calculate the net sales amount of "30,000 yen" for the "Shinjuku store (main building and branch)."

[0126] Furthermore, the calculation unit 24 calculates "13,300 yen" as the gross profit amount for the sales amount of the "Shinjuku store" managed by the inventory management sales group with the inventory management sales group code of "A002" by calculating "net sales amount - (standard cost of the product shown in FIG. 4 x sales quantity)" in this example. Furthermore, the calculation unit 24 calculates "gross profit amount 13,300 yen ÷ net sales amount 30,000 yen x 100 ≒ 44.3%" to calculate a gross profit rate of "44.3%" for the "Shinjuku store (main building and branch building)" managed by the inventory management sales group with the inventory management sales group code of "A002".

[0127] The data generation unit 22 generates sales performance inquiry screen data for each inventory management sales group that reflects these gross profit amounts and gross profit rates. Based on the generated sales performance inquiry screen data for each inventory management sales group, the display control unit 25 displays the sales amount (31,000 yen), net sales amount (30,000 yen), gross profit amount (13,300 yen), and gross profit rate (44.3%) of the "Shinjuku store (main building and branch building)" managed by the inventory management sales group with the inventory management sales group code "A002", along with the discount amount of "-1,000 yen", on the performance inquiry screen for each inventory management sales group, as shown in Fig. 7.

[0128] Next, the calculation unit 24 calculates the sales amount of "21,000 yen" as the sales amount for "Shinjuku Store (Main Building)" with inventory location code "T002-1" which is handled by the sales and marketing group "A002". In addition, in this example, a discount of "1,000 yen" was applied to the sales at "Shinjuku Store (Main Building)". Therefore, the calculation unit 24 calculates the net sales amount of "20,000 yen" by subtracting the discount amount of "1,000 yen" from the sales amount of "21,000 yen".

[0129] Furthermore, the calculation unit 24 calculates the gross profit amount of "9,300 yen" and the gross profit rate of "46.5%" by the above-mentioned calculation based on the net sales amount of "20,000 yen".

[0130] The data generation unit 22 and the display control unit 25 display the calculated sales amount (21,000 yen), net sales amount (20,000 yen), gross profit amount (9,300 yen), and gross profit rate (46.5%) of the "Shinjuku Store (Main Building)" which is handled by the sales group with the sales group code "A002" on the sales performance inquiry screen.

[0131] Next, the calculation unit 24 calculates the sales amount of "21,000 yen" as the sales amount of "Shinjuku Store (Main Building)" with the inventory location code of "T002-1". In this example, a discount of "1,000 yen" was applied to the sale at "Shinjuku Store (Main Building)". Therefore, the calculation unit 24 calculates the net sales amount of "20,000 yen" by subtracting the discount amount of "1,000 yen" from the sales amount of "21,000 yen".

[0132] Furthermore, the calculation unit 24 calculates the gross profit amount of "9,300 yen" and the gross profit rate of "46.5%" by the above-mentioned calculation based on the net sales amount of "20,000 yen".

[0133] The data generation unit 22 and the display control unit 25 display the calculated sales amount (21,000 yen), net sales amount (20,000 yen), gross profit amount (9,300 yen), and gross profit rate (46.5%) for the Shinjuku store (main building) on ​​the sales performance inquiry screen.

[0134] Next, the sales slip "UR0005" shown in Figure 5 shows a sales model in which the sale was made at a virtual store on an e-commerce site managed by the sales and marketing group "A003," and the goods were shipped from the real store "Shinjuku Store (Branch)," which has an inventory location code of "T002-2."

[0135] Therefore, the calculation unit 24 calculates the sales amount of "10,000 yen" as the sales amount of the virtual store of the EC site managed by the sales and marketing group "A003." Also, in this example, a discount of "1,000 yen" was applied to the sale at the "Shinjuku Store (Main Building)," but no discount was applied to the products shipped from the "Shinjuku Store (Annex)" when they were sold on the EC site. Therefore, the calculation unit 24 calculates the sales amount of "10,000 yen" as the net sales amount as is.

[0136] Furthermore, the calculation unit 24 calculates the gross profit amount of "5,000 yen" and the gross profit rate of "50.0%" by the above-mentioned calculation based on the net sales amount of "10,000 yen".

[0137] The data generation unit 22 and the display control unit 25 display on the sales performance inquiry screen the sales amount (10,000 yen), net sales amount (10,000 yen), gross profit amount (5,000 yen), and gross profit rate (50.0%) of the products sold at the virtual store on the EC site managed by the sales sales group with the sales sales group code "A003" and shipped via "Shinjuku Store (Annex)" calculated in this way.

[0138] Next, the calculation unit 24 calculates the sales amount of "10,000 yen" as the sales amount for "Shinjuku Store (Annex)" with the inventory location code of "T002-2". Also, in this example, a discount of "1,000 yen" was applied to the sale at "Shinjuku Store (Main Building)", but no discount was applied to the products shipped from "Shinjuku Store (Annex)" when they were sold on the EC site. Therefore, the calculation unit 24 calculates the sales amount of "10,000 yen" as the net sales amount as is.

[0139] Furthermore, the calculation unit 24 calculates the gross profit amount of "5,000 yen" and the gross profit rate of "50.0%" by the above-mentioned calculation based on the net sales amount of "10,000 yen".

[0140] The data generation unit 22 and the display control unit 25 display the calculated sales amount (10,000 yen), net sales amount (10,000 yen), gross profit amount (5,000 yen), and gross profit rate (50.0%) for the "Shinjuku Store (Annex)" on the sales performance inquiry screen.

[0141] Next, the calculation unit 24 calculates the sales amount of "41,000 yen" as the sales amount of "EC Warehouse West Japan Center" of "S003-1" and "EC Warehouse East Japan Center" of "S003-2", which are handled by the inventory management sales group of "A003". In addition, in this example, since no discounts or returns have been made, the calculation unit 24 calculates the sales amount of "41,000 yen" as the net sales amount as is.

[0142] Furthermore, the calculation unit 24 calculates the gross profit amount of "18,100 yen" and the gross profit rate of "44.1%" by the above-mentioned calculation based on the net sales amount of "41,000 yen".

[0143] The data generation unit 22 and the display control unit 25 display on the sales performance inquiry screen the sales amount (41,000 yen), net sales amount (41,000 yen), gross profit amount (18,100 yen), and gross profit rate (44.1%) calculated in this manner for the "EC Warehouse West Japan Center" "S003-1" and the "EC Warehouse East Japan Center" "S003-2", which are handled by the inventory management sales group with the inventory management sales group code "A003".

[0144] Next, the calculation unit 24 calculates the sales amount of "41,000 yen" as the sales amount of "EC Warehouse West Japan Center" of "S003-1" and "EC Warehouse East Japan Center" of "S003-2", which are handled by the sales and marketing group of "A003". In addition, in this example, since no discounts or returns have been made, the calculation unit 24 calculates the sales amount of "41,000 yen" as the net sales amount as is.

[0145] Furthermore, the calculation unit 24 calculates the gross profit amount of "18,100 yen" and the gross profit rate of "44.1%" by the above-mentioned calculation based on the net sales amount of "41,000 yen".

[0146] The data generation unit 22 and the display control unit 25 display on the sales performance inquiry screen the sales amount (41,000 yen), net sales amount (41,000 yen), gross profit amount (18,100 yen), and gross profit rate (44.1%) calculated in this manner for the "EC Warehouse West Japan Center" of "S003-1" and the "EC Warehouse East Japan Center" of "S003-2", which are handled by the sales sales group with the sales sales group code of "A003".

[0147] Next, the calculation unit 24 calculates the sales amount of "36,000 yen" as the sales amount of "EC Warehouse West Japan Center" with the inventory location code of "S003-1." In addition, in this example, since no discounts or returns have been made, the calculation unit 24 calculates the sales amount of "36,000 yen" as the net sales amount as is.

[0148] Furthermore, the calculation unit 24 calculates the gross profit amount of "15,600 yen" and the gross profit rate of "43.3%" by the above-mentioned calculation based on the net sales amount of "36,000 yen".

[0149] The data generation unit 22 and the display control unit 25 display the sales amount (36,000 yen), net sales amount (36,000 yen), gross profit amount (15,600 yen), and gross profit rate (43.3%) of the "EC Warehouse West Japan Center" calculated in this manner on the sales performance inquiry screen.

[0150] Next, the calculation unit 24 calculates the sales amount of "5,000 yen" as the sales amount of "EC Warehouse East Japan Center" with the inventory location code of "S003-2." In addition, in this example, since no discounts or returns have been made, the calculation unit 24 calculates the sales amount of "5,000 yen" as the net sales amount as is.

[0151] Furthermore, the calculation unit 24 calculates the gross profit amount of "2,500 yen" and the gross profit rate of "50.0%" by the above-mentioned calculation based on the net sales amount of "5,000 yen".

[0152] The data generation unit 22 and the display control unit 25 display the sales amount (5,000 yen), net sales amount (5,000 yen), gross profit amount (2,500 yen), and gross profit rate (50.0%) of the "EC Warehouse East Japan Center" calculated in this manner on the sales performance inquiry screen.

[0153] This allows sales to be recognized as sales from the Shinjuku Branch, even if the product is sold at a virtual store on an e-commerce site and shipped from the real Shinjuku Branch. It also allows accurate sales figures to be recognized based on the shipping status of each inventory location.

[0154] In addition, by associating a sales sales group and an inventory management sales group with each inventory location, it is possible to display the sales results of the store that sold the product and the sales sales group in charge, as well as the sales results of the inventory management sales group that manages the inventory of each store, making it possible to consider sales results.

[0155] (Effects of the embodiment) As is clear from the above explanation, the business support device 1 of the embodiment sets the virtual store on the EC site and the actual real store as inventory locations of products, and treats store sales as sales by inventory location.

[0156] This prevents the inconvenience of sales from a real store being counted as sales from a virtual store on an EC site, and allows sales from both the virtual store on an EC site and the real store to be counted fairly and sales from both stores to be managed.

[0157] Therefore, it is possible to prevent the inconvenience of biased performance evaluations hindering the promotion of OMO, and to formulate KPIs (Key Performance Indicators).

[0158] [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.

[0159] 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.

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

[0161] [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.

[0162] 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.

[0163] 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.

[0164] 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.

[0165] 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.

[0166] 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.

[0167] 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.

[0168] 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.

[0169] 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.

[0170] 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.

[0171] 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.

[0172] 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.

[0173] 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.

[0174] 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]

[0175] The present invention is suitable for application to sales performance management in industries such as the clothing industry, where products are sold in real stores and virtual stores. [Explanation of symbols]

[0176] 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 Sales Department Master Table 12 Inventory Location Master Table 13 Product Master Table 14 Sales data storage section 21 Acquisition Department 22 Data Generation Unit 23 Output control section 24 Calculation section 25 Display control unit 50 Network 51 Server equipment (virtual store) 52 Real store terminal device

Claims

1. an acquisition unit that, based on sales data transmitted from a real store that is an actual store located in a desired location or a virtual store that is a virtual store located on a network, includes at least sales store information of the store that sold the product, shipping store information of the store that shipped the product, and the sales amount of the product, registers the location of the real store as an inventory location of the product sold at the real store, sets a predetermined store location for the virtual store, and refers to a storage unit that registers the location of the set virtual store as an inventory location of the product sold at the virtual store, and acquires the inventory location of the store indicated by the shipping store information included in the sales data; a data generation unit that generates sales data based on the sales store information included in the sales data, the sales data including at least a sales category indicating whether the sales were made at the real store or the virtual store, an inventory location of the shipping store indicated by the shipping store information acquired from the storage unit, and the sales amount; an output control unit that outputs the sales data to an output target device; A business support device having the above.

2. The storage unit stores a sales sales group code of a sales sales group in charge of the real store or the virtual store of each of the inventory locations, in association with each of the inventory locations; a calculation unit that refers to the sales data based on the sales group code and calculates a sales addition amount by adding up the sales amounts of each of the real stores or each of the virtual stores of each of the inventory locations that each sales group is responsible for, the data generation unit generates sales performance inquiry screen data by sales group including the calculated sales addition amount; the output control unit outputs the sales performance inquiry screen data by sales sales group to an output target device; 2. The business support device according to claim 1, wherein:

3. the calculation unit calculates a net sales amount obtained by subtracting the discount amount and the returned goods amount from the sales amount, a gross profit amount obtained by multiplying the standard cost of the sold goods by the sales quantity and subtracting the amount from the net sales amount, and a gross profit rate which is the ratio of the gross profit amount to the net sales amount; the data generation unit generates sales performance inquiry screen data by sales business group, including the net sales amount, the gross profit amount, and the gross profit rate; 3. The business support device according to claim 2, wherein:

4. The storage unit stores an inventory management sales group code of an inventory management sales group that manages inventory of the real store or the virtual store at each of the inventory locations, the inventory management sales group code being associated with each of the inventory locations; The calculation unit refers to the sales data based on the inventory management sales group code, and calculates an inventory management sales addition amount by adding up the sales amounts of each of the real stores or each of the virtual stores at each of the inventory locations where each inventory management sales group manages inventory, the data generation unit generates inventory management sales group sales performance inquiry screen data including the calculated inventory management sales surcharge amount; the output control unit outputs the inventory management sales group sales performance inquiry screen data to an output target device; 4. The business support device according to claim 2 or 3, wherein:

5. the calculation unit calculates a net sales amount obtained by subtracting the discount amount and the returned goods amount from the sales amount, a gross profit amount obtained by multiplying the standard cost of the sold goods by the sales quantity and subtracting the amount from the net sales amount, and a gross profit rate which is the ratio of the gross profit amount to the net sales amount; the data generation unit generates inventory management sales group sales performance inquiry screen data including the net sales amount, the gross profit amount, and the gross profit rate; 5. The business support device according to claim 4, wherein:

6. an acquisition step in which an acquisition unit registers the location of a real store that is an actual store located in a desired location or a virtual store that is a virtual store located on a network as an inventory location of an item sold at the real store based on sales data including at least sales store information of a store that sold the item, shipping store information of a store that shipped the item, and sales amount of the item, and sets a predetermined store location for the virtual store, and refers to a memory unit that has registered the location of the set virtual store as an inventory location of an item sold at the virtual store, and acquires the inventory location of the store indicated by the shipping store information included in the sales data; a data generation step in which a data generation unit generates sales data based on the sales store information included in the sales data, the sales data including at least a sales category indicating whether the sales were made at the real store or the virtual store, an inventory location of the shipping store indicated by the shipping store information acquired from the storage unit, and the sales amount; an output control step in which an output control unit outputs the sales data to an output target device; A business support method having the above.

7. Computer, an acquisition unit that, based on sales data transmitted from a real store that is an actual store located in a desired location or a virtual store that is a virtual store located on a network, includes at least sales store information of the store that sold the product, shipping store information of the store that shipped the product, and the sales amount of the product, registers the location of the real store as an inventory location of the product sold at the real store, sets a predetermined store location for the virtual store, and refers to a storage unit that registers the location of the set virtual store as an inventory location of the product sold at the virtual store, and acquires the inventory location of the store indicated by the shipping store information included in the sales data; a data generation unit that generates sales data based on the sales store information included in the sales data, the sales data including at least a sales category indicating whether the sales were made at the real store or the virtual store, an inventory location of the shipping store indicated by the shipping store information acquired from the storage unit, and the sales amount; an output control unit that outputs the sales data to an output target device; A business support program that functions as a

Images