Profit inquiry device, profit inquiry method, and profit inquiry program

Abstract

For companies with both B2B and B2C sales systems, calculating gross profit for both B2B and B2C sales using the same criteria. [Solution] The profit inquiry device according to this embodiment includes a product master in which products, cost of goods sold, B2B unit price (wholesale price), B2C unit price (retail price), and virtual expenses are registered in association with each other, a customer master in which the customer is registered in association with the customer, and a customer classification specifying "wholesale" or "store", and a profit inquiry means that, when outputting virtual gross profit, refers to the product master using the product as the key for sales data that matches the specified extraction conditions, calculates the profit for customers whose customer classification is "wholesale" as B2B sales - cost of goods sold × quantity + virtual expenses × quantity, and for customers whose customer classification is "store" as B2C sales - cost of goods sold × quantity.

Description

Technical Field

[0001] The present invention relates to a profit inquiry device, a profit inquiry method, and a profit inquiry program.

Background Art

[0002] For example, there is a company that has both BtoB and BtoC sales systems. Conventionally, as a system for conducting both BtoB and BtoC sales, for example, there is Patent Document 1.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] However, in the case of a company that has both BtoB and BtoC sales systems, since the meaning of the selling price is different from the perspective of sales, there is a problem that it is impossible to perform sales analysis on the same basis even when comparing the gross profits of BtoB and BtoC.

[0005] The present invention has been made in view of the above, and an object thereof is to provide a profit inquiry device, a profit inquiry method, and a profit inquiry program capable of calculating the gross profits of BtoB and BtoC on the same basis in a company that has both BtoB and BtoC sales systems.

Means for Solving the Problems

[0006] To solve the above-mentioned problems and achieve the objective, the present invention provides a profit inquiry device equipped with a control unit, wherein the control unit is configured to access a product master, which is registered by associating products, cost of goods sold, B2B unit price (wholesale price), B2C unit price (retail price), and virtual expenses, and a customer master, which is registered by associating customer, customer classification specifying "wholesale" or "store", and the customer can access sales number, customer, sales date, product, quantity, customer classification obtained from the customer master using product as the key, B2B unit price obtained from the product master using product as the key, B2C The system is characterized by having a sales input means for inputting sales data including unit price, B2B sales calculated as B2B unit price × quantity, and B2C sales calculated as B2C unit price × quantity, and a profit inquiry means that, when outputting virtual gross profit in response to the operator's operation on the inquiry screen, refers to the product master with the product as the key for sales data that matches the specified extraction conditions, and calculates the profit for items with a billing destination category of "wholesale" as B2B sales - cost of goods sold × quantity + virtual expenses × quantity, and for items with a billing destination category of "store" as B2C sales - cost of goods sold.

[0007] Furthermore, according to one aspect of the present invention, when the profit inquiry means outputs virtual operating profit in response to the operator's operation on the inquiry screen, it may refer to the product master with the product as the key for sales data that falls under the specified extraction conditions, and calculate the profit for items with a billing destination category of "wholesale" as B2B sales - cost of goods sold × quantity, and for items with a billing destination category of "store" as B2C sales - cost of goods sold × quantity - virtual cost × quantity.

[0008] Furthermore, according to one aspect of the present invention, the inquiry screen may be configured to allow the user to select between outputting virtual gross profit and outputting virtual operating profit.

[0009] Furthermore, according to one aspect of the present invention, the extraction conditions may include the sales date and the product.

[0010] Furthermore, in order to solve the above-mentioned problems and achieve the objectives, the present invention provides a profit inquiry method executed by an information processing device equipped with a control unit, wherein the control unit is configured to be able to access a product master, which is registered by associating products, cost of goods sold, B2B unit price (wholesale price), B2C unit price (retail price), and virtual expenses, and a customer master, which is registered by associating customer, customer classification specifying "wholesale" or "store", and the method executed by the control unit involves obtaining sales number, customer, sales date, product, quantity, customer classification obtained from the customer master using product as the key, and product obtained from the product master using product as the key. The system is characterized by including a sales input process that inputs sales data including B2B unit price, B2C unit price, B2B sales calculated by B2B unit price × quantity, and B2C sales calculated by B2C unit price × quantity, and a profit inquiry process that, when outputting virtual gross profit in response to the operator's operation on the inquiry screen, refers to the product master with the product as the key for sales data that matches the specified extraction conditions, and calculates the profit for items with a billing destination category of "Wholesale" as B2B sales - cost of goods sold × quantity + virtual expenses × quantity, and for items with a billing destination category of "Store" as B2C sales - cost of goods sold × quantity.

[0011] Furthermore, in order to solve the above-mentioned problems and achieve the objective, the present invention provides a profit inquiry program to be executed by an information processing device equipped with a control unit, wherein the control unit is configured to be able to access a product master, which is registered by associating the product, cost of goods sold, BtoB unit price (wholesale price), BtoC unit price (retail price), and virtual expenses, and a customer master, which is registered by associating the customer, customer classification specifying "wholesale" or "store", and the control unit is able to access the sales number, customer, sales date, product, quantity, customer classification obtained from the customer master using the product as the key, BtoB unit price obtained from the product master using the product as the key, B The profit inquiry program is characterized by a sales input process that inputs sales data including the unit price for B2C, B2B sales calculated using the unit price x quantity, and B2C sales calculated using the unit price x quantity; and a profit inquiry process that, when outputting virtual gross profit in response to the operator's operation on the inquiry screen, uses the product as the key to refer to the product master for sales data that matches the specified extraction conditions, and calculates the profit for items with a billing destination category of "Wholesale" as B2B sales - cost of goods sold x quantity + virtual expenses x quantity, and for items with a billing destination category of "Store" as B2C sales - cost of goods sold x quantity. [Effects of the Invention]

[0012] According to the present invention, a company with both B2B and B2C sales systems can calculate the gross profit for both B2B and B2C using the same criteria. [Brief explanation of the drawing]

[0013] [Figure 1] Figure 1 is a block diagram showing an example of the configuration of the profit inquiry device according to this embodiment. [Figure 2] Figure 2 shows an example of the structure of a product master. [Figure 3] Figure 3 shows an example of the configuration of the billing master. [Figure 4] Figure 4 is a diagram illustrating the overall processing flow of the control unit of the profit inquiry device in this embodiment. [Figure 5] FIG. 5 is a diagram for explaining a specific example of the processing of the control unit of the profit inquiry device in the present embodiment. [Figure 6] FIG. 6 is a diagram for explaining a specific example of the processing of the control unit of the profit inquiry device in the present embodiment. [Figure 7] FIG. 7 is a diagram for explaining a specific example of the processing of the control unit of the profit inquiry device in the present embodiment. [Figure 8] FIG. 8 is a diagram for explaining a specific example of the processing of the control unit of the profit inquiry device in the present embodiment. [Figure 9] FIG. 9 is a diagram for explaining a specific example of the processing of the control unit of the profit inquiry device in the present embodiment. MODE FOR CARRYING OUT THE INVENTION

[0014] Hereinafter, embodiments of the profit inquiry device, profit inquiry method, and profit inquiry program according to the present invention will be described in detail based on the drawings. Note that the present invention is not limited to the present embodiment.

[0015] [1. Overview] The overview of the present invention will be described in the order of [1-1. Conventional problems], [1-2. Solution method], and [1-3. Effects].

[0016] [1-1. Conventional problems] In the case of a company with both BtoB and BtoC sales systems, since the meaning of the selling price is different from the perspective of sales, it has been impossible to analyze sales on the same basis even when comparing gross profits. In the case of BtoC, since necessary expenses such as store management fees occur, it has been impossible to confirm from the perspective of operating profit.

[0017] [1-2. Solution method] In the present invention, for each product, the manufacturer's retail price (BtoC unit price), the wholesale price (BtoB unit price), and virtual expenses (such as rent and labor costs) are held in a master, and corrections from BtoB to BtoC and from BtoC to BtoB are performed. In the case of the correction from BtoB to BtoC, if it is converted to the manufacturer's retail price and the virtual expenses are added, it is possible to calculate the virtual gross profit.

[0018] On the other hand, in the case of the correction from BtoC to BtoB, if it is converted to the wholesale price and the virtual expenses are subtracted, it becomes possible to virtually grasp the operating profit within the sales system. When it is desired to confirm from the viewpoint of the quick report value of profit, it is possible to confirm by converting to the wholesale price. In addition to that, by taking into account the virtual expenses, it is also possible to confirm the operating profit.

[0019] Hereinafter, the manufacturer's retail price will be referred to as the BtoC unit price, and the wholesale price will be referred to as the BtoB unit price. Also, the virtual amount calculated this time has the meaning of a quick report value and is not a formal accounting figure.

[0020] [1-3. Effect] In the case of a company with both BtoB and BtoC sales systems, it has become possible to grasp the amount based on the virtual gross profit and the virtual operating profit. Also, data that can be used as one material for business judgment can be calculated from the sales amount.

[0021] The present invention can be used in a company that conducts both wholesaling and retailing.

[0022] [2. Configuration] The configuration of the profit inquiry device 100 according to the present embodiment will be described with reference to FIG. 1 and the like. FIG. 2 is a block diagram showing an example of the configuration of the profit inquiry device 100 of the present embodiment. In the following description, all units of amount will be "yen", and the notation may be omitted.

[0023] The profit inquiry device 100 is a commercially available desktop personal computer. However, the profit inquiry device 100 is not limited to stationary information processing devices such as desktop personal computers, but may also be portable information processing devices such as commercially available notebook personal computers, PDAs (Personal Digital Assistants), smartphones, or tablet personal computers.

[0024] As shown in Figure 1, the profit inquiry device 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the profit inquiry device 100 is connected to communicate via any communication path.

[0025] The communication interface unit 104 connects the profit inquiry device 100 to the network 300 via communication devices such as routers and wired or wireless communication lines such as dedicated lines. The communication interface unit 104 has the function of communicating data with other devices via communication lines. Here, the network 300 has the function of connecting the profit inquiry device 100 with the server 200 and customer (external sales store) terminals 400, etc., so that they can communicate with each other, and is, for example, the internet or a LAN (Local Area Network). Note that the data stored in the storage unit 106, which will be described later, may be stored in the server 200.

[0026] The input / output interface unit 108 is connected to an input device 112 and an output device 114. The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, mouse, microphone, or a monitor that works in conjunction with the mouse to provide pointing device functionality. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 as the keyboard 112 or mouse 112. "Output" includes displaying on the monitor of the output device 114 and printing with the printer of the output device 114. Furthermore, user operations on information displayed on the monitor 114 using the input device 112, etc., may be referred to as "user operation via UI".

[0027] The memory unit 106 stores various databases, tables, and files. The memory unit 106 also stores computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. As the memory unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.

[0028] The storage unit 106 also stores the product master 106a, the billing address master 106b, sales data 106c, etc. Figure 2 shows an example of the configuration of the product master 106a. Figure 3 shows an example of the configuration of the billing address master 106b.

[0029] As shown in Figure 2, the product master 106a can consist of tables that associate and register products (product code and / or product name), cost of goods sold, B2B unit price (wholesale price), B2C unit price (retail price), and virtual expenses (store expenses, personnel expenses, etc.).

[0030] The billing master 106b can consist of tables that register billing information (billing code and / or billing name) and billing category ("1: Wholesale", "2: Store").

[0031] Sales data 106c may include sales number, billing address, sales date, billing address type, product code, quantity, B2C unit price, B2C sales, B2B unit price, and B2B sales.

[0032] The control unit 102 is a CPU or similar component that comprehensively controls the profit inquiry device 100. The control unit 102 has internal memory for storing control programs such as the OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs.

[0033] The control unit 102 is configured to access the product master 106a, billing address master 106b, sales data 106c, etc., which are stored in the storage unit 106. The product master 106a, billing address master 106b, sales data 106c, etc. may be stored in another location (for example, on the server 200), as long as the control unit 102 can access them.

[0034] Functionally, the control unit 102 comprises a master maintenance unit 102a, a sales input unit 102b, a profit inquiry unit 102c, and a screen display control unit 102d.

[0035] The master maintenance unit 102a performs editing such as data input, addition, modification, and updating on the product master 106a and billing address master 106b in response to operator operations on a master maintenance screen (not shown) displayed on the monitor 114.

[0036] The sales input unit 102b inputs sales data, including sales number, customer, sales date, product, quantity, customer classification obtained from customer master 106b using product as the key, BtoB unit price, BtoC unit price obtained from product master 106a using product as the key, BtoB sales calculated as BtoB unit price × quantity, and BtoC sales calculated as BtoC unit price × quantity, in response to operator operations on a sales input screen (not shown) displayed on monitor 114, or obtained from an external source, and stores it in the storage unit 106.

[0037] For example, when the profit inquiry unit 102c outputs virtual gross profit in response to an operator's operation on the virtual profit inquiry screen displayed on the monitor 114, it refers to the product master 106a with the product as the key for sales data that matches the specified extraction conditions, and calculates the profit for items with a billing category of "wholesale" as BtoB sales - cost of goods sold × quantity + virtual expenses × quantity, and for items with a billing category of "store" as BtoC sales - cost of goods sold × quantity.

[0038] Furthermore, when the profit inquiry unit 102c outputs virtual operating profit in response to the operator's operation on the virtual profit inquiry screen, it refers to the product master 106a with the product as the key for sales data that matches the specified extraction conditions, and calculates the profit for items with a billing destination category of "Wholesale" as B2B sales - cost of goods sold × quantity, and for items with a billing destination category of "Store" as B2C sales - cost of goods sold × quantity - virtual cost × quantity.

[0039] The extraction criteria may include the sales date and product. The virtual profit inquiry screen may be configured to allow selection between outputting virtual gross profit and outputting virtual operating profit.

[0040] The screen display control unit 102d controls the display of various screens (for example, the master maintenance screen, the sales input screen, the virtual profit introduction screen, etc.) displayed on the monitor 114, and the acceptance of input on the screen.

[0041] [3. Specific examples] A specific example of the processing of the control unit 102 of the profit inquiry device 100 according to this embodiment will be described with reference to Figures 1 to 9. In the following description, all monetary units will be in "yen," and the notation may be omitted.

[0042] [3-1. Overall Processing] Figure 4 is a flowchart illustrating the overall processing flow of the control unit 102 of the profit inquiry device 100. The overall processing flow of the control unit 102 of the profit inquiry device 100 will be explained with reference to Figure 4.

[0043] In Figure 4, the master maintenance unit 102a performs product master maintenance processing (step S1). Specifically, in product master maintenance processing, the master maintenance unit 102a sets data for the product master 106a in response to operator operations on a master maintenance screen (not shown) displayed on the monitor 114.

[0044] The master maintenance unit 102a performs the billing destination master maintenance process (step S2). Specifically, in the billing destination master maintenance process, the master maintenance unit 102a sets data for the billing destination master 106b in response to the operator's operation on, for example, a master maintenance screen (not shown) displayed on the monitor 114.

[0045] The sales input unit 102b executes the sales input process (step S3). Specifically, in the sales input process, the sales input unit 102b inputs sales data, including sales number, customer, sales date, product, quantity, customer classification obtained from the customer master 106b using the product as the key, BtoB unit price and BtoC unit price obtained from the product master 106a using the product as the key, BtoB sales calculated by BtoB unit price × quantity, and BtoC sales calculated by BtoC unit price × quantity, in response to the operator's operation on the sales input screen (not shown) displayed on the monitor 114, or obtained from an external source, and stores it in the storage unit 106.

[0046] The profit inquiry unit 102c executes virtual profit inquiry processing (step S4). Specifically, in virtual profit inquiry processing, if the profit inquiry unit 102c outputs virtual gross profit in response to the operator's operation on the virtual profit inquiry screen displayed on the monitor 114, it refers to the product master 106a with the product as the key for sales data that matches the specified extraction conditions, calculates the virtual gross profit for items with a billing destination category of "wholesale" as BtoB sales - cost of goods sold × quantity + virtual expenses × quantity, and calculates the virtual gross profit for items with a billing destination category of "store" as BtoC sales - cost of goods sold × quantity.

[0047] Furthermore, when the profit inquiry unit 102c outputs virtual operating profit in response to the operator's operation on the virtual profit inquiry screen, it refers to the product master 106a with the product as the key for sales data that matches the specified extraction conditions, and calculates the profit for items with a billing destination category of "Wholesale" as B2B sales - cost of goods sold × quantity, and for items with a billing destination category of "Store" as B2C sales - cost of goods sold × quantity - virtual cost × quantity.

[0048] [3-2. Sample Data] Referring to Figures 5 to 9, a specific example of the processing of the control unit 102 of the profit inquiry device 100 will be explained. Figures 5 to 9 are diagrams illustrating a specific example of the processing of the control unit 102 of the profit inquiry device 100.

[0049] (S1: Product master data maintenance process) A specific example of the product master maintenance process will be explained with reference to Figure 5(A). The master maintenance unit 102a sets data for the product master 106a in response to the operator's operation on a master maintenance screen (not shown) displayed on the monitor 114.

[0050] During product master maintenance, the B2B unit price, B2C unit price, and virtual expenses are set in product master 106a beforehand. If there are any changes to the B2B unit price, B2C unit price, or virtual expenses, the person in charge will make the necessary changes.

[0051] Figure 5(A) shows an example of data in product master 106a. Product master 106a includes fields for product code, product name, cost of goods sold, B2B unit price, B2C unit price, and virtual expenses (store expenses, etc.). Virtual expenses are not values ​​calculated by the system for the product being set, but are calculated and set by the person in charge outside of the system.

[0052] In the example shown in the diagram, the first row contains product code "H001", product name "Product A", cost of goods sold "300", B2B unit price "700", B2C unit price "1000", and virtual expenses (store expenses, etc.) "300". The second row contains product code "H002", product name "Product B", cost of goods sold "100", B2B unit price "600", B2C unit price "800", and virtual expenses (store expenses, etc.) "200".

[0053] (S2: Billing master data maintenance process) Referring to Figure 5(B), a specific example of the billing master maintenance process will be explained. The master maintenance unit 102a sets data for the billing master 106b in response to the operator's operation on a master maintenance screen (not shown) displayed on the monitor 114.

[0054] In the billing master maintenance process, a billing category is established in the billing master 106b, and it is set whether to use the "wholesale" or "store" unit price when recording sales.

[0055] Figure 5(B) shows an example of data in the billing master 106b. The billing master 106b has fields for billing address, billing address name, and billing address category ("1: Wholesale", "2: Store"). In the example shown in the figure, the first row has billing address "S001", billing address name "Department Store A", and billing address category "1: Wholesale", and the second row has billing address "S002", billing address name "Directly Managed Store 1", and billing address category "2: Store".

[0056] (S3: Sales entry processing) A specific example of the sales input process will be explained with reference to Figure 6. The sales input unit 102b inputs sales data, including sales number, customer, sales date, product, quantity, customer classification obtained from the customer master 106b using the product as the key, BtoB unit price, BtoC unit price obtained from the product master 106a using the product as the key, BtoB sales calculated as BtoB unit price × quantity, and BtoC sales calculated as BtoC unit price × quantity, in response to the operator's operation on the sales input screen (not shown) displayed on the monitor 114, or obtained from an external source, and stores it in the storage unit 106.

[0057] As shown in Figure 6, the sales data includes the following fields: sales number, customer code, sales date, customer category, product code, quantity, B2C unit price, B2C sales, B2B unit price, and B2B sales. First, the sales number, customer, sales date, product code, and quantity are entered into the sales data. Using the product code as the key, the customer category is retrieved from the customer master 106b and set as the "customer category". The B2B unit price and B2C unit price are retrieved from the product master 106a and set as the "B2B unit price" and "B2C unit price". Furthermore, "B2B sales" is calculated and set by multiplying "B2B unit price" by quantity, and "B2C sales" is set by multiplying "B2C unit price" by quantity.

[0058] Figure 6(A) shows an example of sales data for department store A. Department stores have a billing category of "1: Wholesale". In the example shown in the figure, the first row shows sales number "U0001", billing code "S001", sales date "2024 / 10 / 7", billing category "1: Wholesale", product code "H001", quantity "2", BtoC unit price "1000", BtoC sales "2000", BtoB unit price "700", BtoB sales "1400", and product code "H002", quantity "3", BtoC unit price "800", BtoC sales "2400", BtoB unit price "600", BtoB sales "1800".

[0059] Figure 6(B) shows an example of sales data for directly managed store 1. Directly managed stores have a billing category of "2: Store". In the example shown in the figure, the first row shows sales number "U0002", billing category "S002", sales date "2024 / 10 / 7", billing category "2: Store", product code "H001", quantity "2", BtoC unit price "1000", BtoC sales "2000", BtoB unit price "700", BtoB sales "1400", and also product code "H002", quantity "3", BtoC unit price "800", BtoC sales "2400", BtoB unit price "600", BtoB sales "1800".

[0060] (S4: Virtual profit inquiry processing) Refer to Figures 7 to 9 to explain a specific example of the virtual profit inquiry process. On the virtual profit inquiry screen, it is possible to select to inquire about virtual gross profit and virtual operating profit. For example, when the profit inquiry unit 102c outputs virtual gross profit in response to the operator's operation on the virtual profit inquiry screen displayed on the monitor 114, it refers to the product master 106a with the product as the key for sales data that matches the specified extraction conditions, and calculates it as BtoB sales - cost of goods sold × quantity + virtual expenses × quantity for items with a billing destination category of "wholesale", and as BtoC sales - cost of goods sold × quantity for items with a billing destination category of "store".

[0061] Furthermore, when the profit inquiry unit 102c outputs virtual operating profit in response to the operator's operation on the virtual profit inquiry screen, it refers to the product master 106a with the product as the key for sales data that matches the specified extraction conditions, and calculates the profit for items with a billing destination category of "Wholesale" as B2B sales - cost of goods sold × quantity, and for items with a billing destination category of "Store" as B2C sales - cost of goods sold × quantity - virtual cost × quantity.

[0062] Figure 7 shows an image of the virtual profit inquiry screen 400. It includes a header area 401 for specifying inquiry conditions such as profit selection (virtual gross profit or virtual operating profit), sales date, and product, and an inquiry result display area 402 for displaying inquiry results that match the inquiry conditions.

[0063] In the inquiry result display area 402, the product code, product name, sales date, quantity, and virtual gross profit or virtual operating profit are displayed. If "virtual gross profit" is selected in the profit selection, the virtual gross profit is displayed. If "virtual operating profit" is selected in the profit selection, the virtual operating profit is displayed.

[0064] The following explanation describes the case where "Sales Date: 2024 / 10 / 7", products "H001: Product A ~ H002: Product B" are specified, and "Virtual Gross Profit" and "Virtual Operating Profit" are selected for profit selection.

[0065] <Virtual Gross Profit> For virtual gross profit, convert to B2B. Calculate virtual gross profit based on sales data. If "Virtual Gross Profit" is selected on the virtual profit inquiry screen and the billing category is "1: Wholesale," add virtual expenses.

[0066] Figure 8(A) shows an example of sales data for department store A. The calculation of hypothetical gross profit for department store A will now be explained.

[0067] Cost of goods sold is calculated from product master 106a by multiplying quantity by cost of goods sold. Virtual expenses are calculated from product master by multiplying quantity by virtual expenses. In the case of department store A, the billing category is "1: wholesale", so virtual expenses are added.

[0068] For product code H001, the calculation would be B2B sales "1400" - cost of goods sold "600 (=300 x 2)" + virtual expenses "600 (=300 x 2)" = 1400.

[0069] For product code H002, the calculation would be B2B sales "1800" - cost of goods sold "300 (=100 x 3)" + virtual expenses "600 (=200 x 3)" = 2100.

[0070] Figure 8(B) shows an example of sales data for directly managed store 1. The calculation of the hypothetical gross profit for directly managed store 1 will now be explained.

[0071] In the case of directly managed store 1, the billing category is "2: Store," so virtual expenses are not added.

[0072] For product code H001, BtoC sales "2000" - cost of goods sold "600 (=300 x 2)" = 1400.

[0073] For product code H002, the calculation would be BtoC sales "2400" - cost of goods sold "300 (=100 x 3)" = 2100.

[0074] Figure 8(C) shows the query results. In the example shown in the figure, the first row shows product code "H001", product name "Product A", sales date "10 / 7", quantity "4", and virtual gross profit "2800", and the second row shows product code "H002", product name "Product B", sales date "10 / 7", quantity "6", and virtual gross profit "4200". Virtual gross profit can be checked on a per-product basis, and clicking on the details will expand and display the details for each product. Figure 8(D) shows an example of details for each product, displaying product code, product name, sales date, billing category, quantity, BtoC unit price, BtoB unit price, various sales, cost of goods sold, virtual expenses, and virtual gross profit. Various sales are calculated by various unit prices × quantity.

[0075] <Virtual Operating Profit> In the case of virtual operating profit, convert it to B2C. Calculate virtual operating profit based on sales data. If "Virtual Operating Profit" is selected on the virtual profit inquiry screen and the billing category is "2: Store", subtract virtual expenses.

[0076] Figure 9(A) shows an example of sales data for department store A. The calculation of hypothetical operating profit for department store A will now be explained.

[0077] Cost of goods sold is calculated from product master 106a, by multiplying quantity by cost of goods sold. Virtual expenses are calculated from product master, by multiplying quantity by virtual expenses. In the case of department store A, the billing category is "1: wholesale," so virtual expenses are not subtracted.

[0078] For product code H001, the B2B sales would be "1400" - cost of goods sold "600 (=300 x 2)" = 800.

[0079] For product code H002, the calculation would be B2B sales "1800" - cost of goods sold "300 (=100 x 3)" = 1500.

[0080] Figure 9(B) shows an example of sales data for directly managed store 1. The calculation of the hypothetical gross profit for directly managed store 1 will be explained.

[0081] In the case of directly managed store 1, the billing category is "2: Store," so the virtual expense is subtracted.

[0082] For product code H001, BtoC sales "2000" - cost of goods sold "600 (=300 x 2)" - virtual expenses "600 (=300 x 2)" = 800.

[0083] For product code H002, the calculation would be: BtoC sales "2400" - cost of goods sold "300 (=100 x 3)" - virtual expenses "600 (=200 x 3)" = 1500.

[0084] Figure 9(C) shows the query results. In the example shown in this figure, the first row shows product code "H001", product name "Product A", sales date "10 / 7", quantity "4", and virtual operating profit "1600", and the second row shows product code "H002", product name "Product B", sales date "10 / 7", quantity "6", and virtual operating profit "3000". Virtual operating profit can be checked on a per-product basis, and clicking on the details will expand and display the details for each product. Figure 9(D) shows an example of details for each product, displaying product code, product name, sales date, billing category, quantity, BtoC unit price, BtoB unit price, various sales, cost of goods sold, virtual expenses, and virtual operating profit. Various sales are calculated by various unit prices × quantity.

[0085] Various sales figures are calculated by multiplying the unit price by the quantity. By choosing between virtual gross profit and operating profit, it is possible to equalize and capture the figures even when wholesale and retail prices differ.

[0086] As described above, according to this embodiment, a product master 106a is registered by associating the product, cost of goods sold, B2B unit price (wholesale price), B2C unit price (retail price), and virtual expenses; a customer master 106b is registered by associating the customer, customer category specifying "wholesale" or "store"; and sales data includes sales number, customer, sales date, product, quantity, customer category obtained from the customer master using the product as the key, B2B unit price obtained from the product master using the product as the key, B2C unit price, B2B sales calculated as B2B unit price × quantity, and B2C sales calculated as B2C unit price × quantity. The system includes a sales input unit 102b for inputting sales data, and a profit inquiry unit 102c that, in response to operator operations on the inquiry screen, outputs virtual gross profit by referring to the product master 106a with the product as the key for sales data that matches the specified extraction conditions, calculating B2B sales - cost of goods sold × quantity + virtual expenses × quantity for items with a billing destination category of "wholesale", and B2C sales - cost of goods sold × quantity for items with a billing destination category of "store". Therefore, in companies with both B2B and B2C sales systems, it is possible to calculate B2B and B2C gross profit using the same criteria.

[0087] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving operational efficiency and promoting appropriate management decisions within companies, thereby enabling contributions to SDGs Goals 8 and 9.

[0088] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.

[0089] Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.

[0090] [5. Other Embodiments] In addition to the embodiments described above, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

[0091] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically by known methods.

[0092] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configuration shown in this specification and in the drawings may be changed at will unless otherwise specified.

[0093] Furthermore, with respect to the profit inquiry device 100, each component shown in the illustration is a functional concept and does not necessarily need to be physically configured as shown.

[0094] For example, the processing functions of the profit inquiry device 100, particularly those performed by the control unit 102, may be implemented in whole or in part by a CPU and a program interpreted and executed by the CPU, or they may be implemented as wired logic hardware. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for the information processing device to execute the processing described in this embodiment, and is mechanically read by the profit inquiry device 100 as needed. That is, a storage unit such as ROM or HDD (Hard Disk Drive) records a computer program that works in cooperation with the OS to give instructions to the CPU and perform various processing. This computer program is executed by being loaded into RAM and works in cooperation with the CPU to constitute the control unit.

[0095] Furthermore, this computer program may be stored on an application program server connected to the profit inquiry device 100 via any network, and it is possible to download all or part of it as needed.

[0096] Furthermore, the program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program product. Here, "recording medium" includes any "portable physical medium" such as memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical disks), DVDs (Digital Versatile Disks), and Blu-ray (Registered Trademark) Discs.

[0097] Furthermore, "program" refers to a data processing method described in any language or writing method, regardless of its format, such as source code or binary code. Note that "program" is not necessarily limited to a single, monolithic structure; it also includes distributed structures consisting of multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions. Regarding the specific configuration and reading procedures for reading the recording medium in each device shown in the embodiments, as well as the installation procedures after reading, well-known configurations and procedures can be used.

[0098] The various databases stored in the memory unit 106 include memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0099] Furthermore, the profit inquiry device 100 may be configured as an information processing device such as a known personal computer or workstation, or as an information processing device to which any peripheral devices are connected. Alternatively, the profit inquiry device 100 may be implemented by installing software (including programs or data, etc.) that enables the processing described in this embodiment onto the device.

[0100] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the figures, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit according to various additions or functional loads. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Explanation of symbols]

[0101] 100 Profit Inquiry Device 102 Control Unit 102a Master Maintenance Department 102b Sales Input Section 102c Profit Inquiry Department 102d Screen display control unit 104 Communication Interface Section 106 Storage section 106a Product Master 106b Billing Address Master 106c Sales Data 108 Input / Output Interface Section 112 Input device 114 Output device 200 servers 300 Networks

Claims

1. A profit inquiry device equipped with a control unit, The control unit, A product master database is created by associating the product, cost of goods sold, wholesale price (B2B unit price), retail price (B2C unit price), and virtual expenses. A billing address master registered with a billing address category that specifies "wholesale" or "store", It is configured to be accessible, A sales input means for inputting sales data including sales number, billing address, sales date, product, quantity, billing address category obtained from the billing address master using the product as the key, B2B unit price obtained from the product master using the product as the key, B2C unit price, B2B sales calculated by B2B unit price × quantity, and B2C sales calculated by B2C unit price × quantity. A profit inquiry device characterized by having a profit inquiry means that, in response to the operator's operation on the inquiry screen, outputs virtual gross profit, refers to the product master with the product as the key for sales data that matches the specified extraction conditions, calculates the profit for items with a billing destination category of "Wholesale" as B2B sales - cost of goods sold × quantity + virtual expenses × quantity, and calculates the profit for items with a billing destination category of "Store" as B2C sales - cost of goods sold × quantity.

2. The profit inquiry means, in response to an operator's operation on the inquiry screen, outputs virtual operating profit, and for sales data that matches the specified extraction conditions, it refers to the product master with the product as the key, and for items with a billing customer category of "Wholesale", it calculates the profit as B2B sales - cost of goods sold × quantity, and for items with a billing customer category of "Store", it calculates the profit as B2C sales - cost of goods sold × quantity - virtual cost × quantity, as described in claim 1.

3. The profit inquiry device according to claim 2, characterized in that the inquiry screen is configured to allow selection of outputting virtual gross profit and outputting virtual operating profit.

4. The profit inquiry device according to any one of claims 1 to 3, characterized in that the extraction conditions include the sales date and the product.

5. A profit inquiry method executed by an information processing device equipped with a control unit, The control unit, A product master database is created by associating the product, cost of goods sold, wholesale price (B2B unit price), retail price (B2C unit price), and virtual expenses. A billing address master registered with a billing address category that specifies "wholesale" or "store", It is configured to be accessible, The control unit is executed as follows: A sales entry process that inputs sales data including sales number, billing address, sales date, product, quantity, billing address category obtained from the billing address master using the product as the key, B2B unit price, B2C unit price obtained from the product master using the product as the key, B2B sales calculated by B2B unit price × quantity, and B2C sales calculated by B2C unit price × quantity. When outputting virtual gross profit in response to operator operations on the inquiry screen, the profit inquiry process involves the following steps: For sales data matching the specified extraction criteria, the product is used as the key, the product master is referenced, and for items with a billing category of "Wholesale," the profit is calculated as B2B sales - cost of goods sold × quantity + virtual expenses × quantity; and for items with a billing category of "Store," the profit is calculated as B2C sales - cost of goods sold × quantity. A method for inquiring about profits, characterized by including the following:

6. A profit inquiry program to be executed by an information processing device equipped with a control unit, The control unit, A product master database is created by associating the product, cost of goods sold, wholesale price (B2B unit price), retail price (B2C unit price), and virtual expenses. A billing address master registered with a billing address category that specifies "wholesale" or "store", It is configured to be accessible, The control unit, A sales entry process that inputs sales data including sales number, billing address, sales date, product, quantity, billing address category obtained from the billing address master using the product as the key, B2B unit price, B2C unit price obtained from the product master using the product as the key, B2B sales calculated by B2B unit price × quantity, and B2C sales calculated by B2C unit price × quantity. When outputting virtual gross profit in response to operator operations on the inquiry screen, the profit inquiry process involves the following steps: For sales data matching the specified extraction criteria, the product is used as the key, the product master is referenced, and for items with a billing category of "Wholesale," the profit is calculated as B2B sales - cost of goods sold × quantity + virtual expenses × quantity; and for items with a billing category of "Store," the profit is calculated as B2C sales - cost of goods sold × quantity. A profit inquiry program to execute a command.

Images