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

The business support device automates royalty calculations by using a standard total quantity and rate detection units to address the challenge of varying sales formats, ensuring quick and accurate royalty determination and profit simulation for effective management.

JP2025142605APending Publication Date: 2025-10-01OBIC CO LTD
View PDF 1 Cites 0 Cited by

Patent Information

Application Number
JP2024042053
Authority / Receiving Office
JP · JP
Patent Type
Applications
Current Assignee / Owner
Filing Date
2024-03-18
Publication Date
2025-10-01

AI Technical Summary

Technical Problem

Existing systems face challenges in quickly calculating royalty amounts based on varying sales formats, leading to cumbersome calculations and delayed visualization of income and expenditures, which hinders effective management decision-making.

Method used

A business support device and method that includes a standard total quantity calculation unit, a rate detection unit, and a royalty calculation unit to automatically determine royalty amounts by referencing a royalty calculation master table, enabling quick and accurate calculations regardless of sales format.

Benefits of technology

Enables rapid calculation of royalty amounts, facilitating quick visualization of income and expenditures, and allows for profit simulation, thereby enhancing management decision-making and maximizing profits.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure 2025142605000001_ABST
    Figure 2025142605000001_ABST
Patent Text Reader

Abstract

To enable rapid calculation of royalty amounts corresponding to sales amounts or the like of commercial transaction objects.SOLUTION: A reference total quantity calculation unit performs a multiplication process of multiplying a reference quantity serving as a commercial transaction unit of a commercial transaction object by a quantity of the commercial transaction object that has been sold or the quantity of the commercial transaction object that is planned to be sold, and calculates a reference total quantity of the commercial transaction object. A rate detection unit refers to a royalty calculation master table in which royalty rates are stored for each right holder of the royalty and each reference total quantity, and detects a royalty rate corresponding to the calculated reference total quantity of the commercial transaction object. A royalty calculation unit performs a multiplication process of multiplying the detected royalty rate by a total sales amount of the commercial transaction object that has been sold or by a planned total sales amount of the commercial transaction object that is to be sold, thereby calculating a royalty amount corresponding to the total sales amount of the commercial transaction object that has been sold or the planned total sales amount of the commercial transaction object that is to be sold. An output control unit outputs the calculated royalty amount to an output target device.SELECTED DRAWING: Figure 1
Need to check novelty before this filing date? Find Prior Art

Description

[Technical Field]

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

[0002] Patent Document 1 (Japanese Patent No. 7446022) discloses a method for implementing effective marketing strategies based on art work transactions. Paragraph 0017 of this patent document discloses a method for calculating revenue based on the unit price of the art work, the number of editions offered corresponding to ownership rights, and the number sold: unit price x number of offers x (number of sales / number of offers) x royalty income (e.g., the platform operator's revenue share is 20%). Furthermore, for secondary distribution of art works, a method for calculating revenue based on the auction winning bid price (sales price in the case of direct transactions) and royalty income (e.g., the platform operator's revenue share is 6%) is disclosed.

[0003] Furthermore, paragraph 0044 states that the user's hobbies and preferences are inferred based on the artworks purchased by the user, and customer loyalty is inferred from the purchase price and / or number of purchases, and users are selected for marketing measures. [Prior art documents] [Patent documents]

[0004] [Patent Document 1] Patent No. 7446022 Summary of the Invention [Problem to be solved by the invention]

[0005] In commercial transactions, a predetermined royalty amount may be set based on the sales amount of the commercial transaction. In this case, calculating the royalty amount is important for quickly visualizing income and expenditures and making management decisions.

[0006] The present invention has been made in view of the above-mentioned problems, and aims to provide a business support device, a business support method, and a business support program that enable quick calculation of royalty amounts relative to sales amounts, etc. of commercial transactions. [Means for solving the problem]

[0007] In order to solve the above-mentioned problems and achieve the object, the business support device of the present invention has a standard total quantity calculation unit that calculates a standard total quantity of transaction objects by multiplying the quantity of transaction objects that have already been sold or the quantity of transaction objects that are to be sold by a standard quantity that is the transaction unit for the transaction objects; a rate detection unit that refers to a royalty calculation master table in which royalty rates are stored for each royalty right holder and for each standard total quantity, and detects a royalty rate that corresponds to the calculated standard total quantity of transaction objects; a royalty calculation unit that calculates a royalty amount for the total sales amount of transaction objects that have already been sold or the total projected sales amount of transaction objects that are to be sold by multiplying the detected royalty rate by the total sales amount of transaction objects that have already been sold or the total projected sales amount of transaction objects that are to be sold; and an output control unit that outputs the calculated royalty amount to an output target device.

[0008] In addition, in order to solve the above-mentioned problems and achieve the object, the business support method of the present invention includes a standard total quantity calculation step in which a standard total quantity calculation unit calculates a standard total quantity of the transaction objects by multiplying the quantity of the transaction objects that have already been sold or the quantity of the transaction objects that are to be sold by a standard quantity that is the transaction unit for the transaction objects; a rate detection step in which a rate detection unit refers to a royalty calculation master table in which royalty rates are stored for each royalty right holder and for each standard total quantity, and detects a royalty rate that corresponds to the calculated standard total quantity of the transaction objects; a royalty calculation step in which the royalty calculation unit calculates a royalty amount for the total sales amount of the transaction objects that have already been sold or the total planned sales amount of the transaction objects that are to be sold by multiplying the detected royalty rate by the total sales amount of the transaction objects that have already been sold or the total planned sales amount of the transaction objects that are to be sold; and an output control step in which an output control unit outputs the calculated royalty amount 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: a standard total quantity calculation unit that calculates a standard total quantity of transaction objects by multiplying the quantity of transaction objects that have already been sold or the quantity of transaction objects that are to be sold by a standard quantity that is the transaction unit for the transaction objects; a rate detection unit that refers to a royalty calculation master table in which royalty rates are stored for each royalty right holder and for each standard total quantity, and detects a royalty rate that corresponds to the calculated standard total quantity of transaction objects; a royalty calculation unit that calculates a royalty amount for the total sales amount of transaction objects that have already been sold or the total projected sales amount of transaction objects that are to be sold by multiplying the detected royalty rate by the total sales amount of transaction objects that have already been sold or the total projected sales amount of transaction objects that are to be sold; and an output control unit that outputs the calculated royalty amount to an output target device. [Effects of the Invention]

[0010] The present invention makes it possible to quickly calculate royalty amounts relative to sales amounts or the like of commercial transactions. [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 an item number management master table provided in the business support device according to the embodiment. [Figure 3] FIG. 3 is a diagram illustrating an example of a royalty calculation master table provided in the business support device according to the embodiment. [Figure 4] FIG. 4 is a diagram illustrating an example of a sales plan data storage unit provided in the business support device according to the embodiment. [Figure 5] FIG. 5 is a diagram illustrating an example of a sales data storage unit provided in the business support device according to the embodiment. [Figure 6] FIG. 6 is a diagram illustrating an example of a royalty simulation data storage unit provided in the business support device according to the embodiment. [Figure 7] FIG. 7 is a diagram illustrating an example of an expense data storage unit provided in the business support device according to the embodiment. [Figure 8] FIG. 8 is a diagram illustrating an outline of the royalty calculation operation of the business support device according to the embodiment. [Figure 9] FIG. 9 is a diagram showing an example of a royalty calculation screen for selecting a simulated calculation or an actual calculation of royalty in the business support device according to the embodiment. DETAILED DESCRIPTION OF THE INVENTION

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

[0013] [overview] In today's commercial transactions, a certain royalty amount is sometimes set based on the sales amount of the commercial transaction. In such cases, calculating the royalty amount is important for quickly visualizing income and expenditures and making management decisions.

[0014] For example, in the case of cosmetics, the same product may be sold in different sales formats, such as a single product or a set of multiple products. When the sales formats differ, royalty amounts must be calculated using a royalty rate appropriate to the sales format, which requires tedious calculations, placing a heavy burden on accounting staff and potentially delaying accounting work. This has hindered the prompt visualization of income and expenditures and management decision-making.

[0015] It was also difficult to simulate profits that took into account royalty amounts in relation to sales plans, making it difficult to maximize profits.

[0016] Therefore, the business support device 1 of the embodiment stores the base quantity of the product and the royalty rate for the base quantity in master data, and automatically and quickly calculates the royalty amount even if the base quantity differs depending on the sales format of the product. This enables quick visualization of income and expenditure and management decisions, etc.

[0017] Furthermore, it is possible to simulate profits that take royalties into account based on sales plan information, which makes it possible to grasp expected profits at the time of sales planning and maximize profits.

[0018] [Hardware configuration] As shown in FIG. 1, the business support device 1 of the embodiment includes a storage unit 2, a control unit 3, a communication interface unit 4, and an input / output interface unit 5. An input device 6 and an output device 7 are connected to the input / output interface unit 5. The output device 7 corresponds to a display unit such as a monitor device (including a home television), a printing device, or a speaker device. The input device 6 may be a keyboard device, a mouse device, a microphone device, or a monitor device that cooperates with a mouse device to achieve a pointing device function. The communication interface unit 4 is connected to a network, for example, a wide area network such as the Internet or a private network such as a LAN (Local Area Network).

[0019] A storage device such as a ROM (Read Only Memory), a RAM (Random Access Memory), an HDD (Hard Disk Drive), or an SSD (Solid State Drive) can be used as the storage unit 2. The storage unit 2 stores a business support program that enables quick calculation of royalty amounts for sales amounts of commercial transactions and supports accounting staff in their accounting work.

[0020] The memory unit 2 also has a product number management master table 11, a royalty calculation master table 12, a sales plan data memory unit 13, a sales data memory unit 14, a royalty simulation data memory unit 15, and an expense data memory unit 16, each of which is a memory area.

[0021] As shown in FIG. 2, the product number management master table 11 stores product group codes, product number codes, product number names, reference quantities, royalty calculation target categories, royalty calculation categories, etc., each associated with another.

[0022] The product group code is a unique code for the group to which the product belongs. The product number code is the unique product number for that product. In the example of Figure 2, the products with product number codes "1001," "1002," and "1003" are all products of the same "Product A," but the product with product number code "1001" indicates that it is a single product sold. In addition, the product with product number code "1002" indicates that it is a set of two products sold, and the product with product number code "1003" indicates that it is a set of six products sold.

[0023] Similarly, in the example of Figure 2, the products with product code "3001" and "3002" are the same "Product C" product, but the product with product code "3001" indicates that it is a single product sold, while the product with product code "3002" indicates that it is a set of two products sold.

[0024] The reference quantity indicates the standard trading amount when trading the product alone, such as "quantity," "length," or "weight." The example in Figure 2 is an example in which the reference quantity is "weight (unit weight: g)." In the following, as an example, the reference quantity will be explained as "weight."

[0025] In the example of Figure 2, the base quantity of product A sold individually with the product code "1001" is "50g", the base quantity of product A sold as a set of two with the product code "1002" is "100g", and the base quantity of product A sold as a set of six with the product code "1003" is "300g".

[0026] Similarly, in the example of Figure 2, the base quantity of product C sold individually with the product code "3001" is "500g," and the base quantity of product C sold as a set of two with the product code "3002" is "1000g."

[0027] The royalty calculation category is information that indicates whether or not a product is subject to royalty calculation. In the example of Figure 2, the royalty calculation category for products A and C is "1," indicating that the products are subject to royalty calculation. In contrast, the royalty calculation category for product B is "0," indicating that the product is not subject to royalty calculation. For products with a royalty calculation category of "0," royalty calculation, as described below, is not performed.

[0028] The royalty calculation category is information that indicates the rounding category and royalty multiplier rate used when calculating royalties for that product, among the rounding categories and royalty multiplier rates set for each royalty right holder and for each total quantity of the base quantity in the royalty calculation master table 12 described below. Details will be described later, but in the example of Figure 2, the royalty calculation category for product A is "1," and the royalty calculation category for product C is "3." The royalty calculation category for product B, for which royalty calculation is not performed, is "0," indicating this.

[0029] As shown in Figure 3, the royalty calculation master table 12 stores the royalty calculation category, royalty calculation category name, supplier name, expense name, rounding category, base total quantity (g), and royalty rate (%), each associated with the others.

[0030] The royalty calculation category is information that is uniquely assigned to each royalty right holder, and if the royalty right holder is "Company A," the royalty calculation category is "1," and if the royalty right holder is "Company C," the royalty calculation category is "2." Note that, as mentioned above, royalty calculations are not performed for products of "Company B," and therefore no settings are made in royalty calculation master table 12.

[0031] The royalty calculation category in the product number management master table 11 shown in FIG. 2 indicates the royalty calculation category in this royalty calculation master table 12.

[0032] In the example of Figure 3, royalty calculation categories for "Company A" are named "Basic Pattern 1-1" through "Basic Pattern 1-6." "Basic Pattern 1-1" is a rounding category that "rounds down" fractional amounts, and indicates a calculation pattern in which royalties are calculated at a royalty rate of "7%" when the base total quantity of products already sold or to be sold is "up to 10 kg."

[0033] Similarly, "Basic Pattern 1-2" is a calculation pattern in which a royalty rate of 6.8% is used to calculate royalties for products sold or to be sold in the range of 10,001g to 30kg, with a rounding classification that "rounds down" fractional amounts to the nearest integer. Similarly, "Basic Pattern 1-3" is a calculation pattern in which a royalty rate of 6.6% is used to calculate royalties for products sold or to be sold in the range of 30,001g to 50kg, with a rounding classification that "rounds down" fractional amounts to the nearest integer.

[0034] In the example of Figure 3, royalty calculation categories for "Company B" are named "Basic Pattern 2-1" to "Basic Pattern 2-4." "Basic Pattern 2-1" is a rounding category that "rounds off" fractional amounts, and indicates a calculation pattern in which royalties are calculated at a royalty rate of "6.5%" when the base total quantity of products already sold or to be sold is "up to 50 kg."

[0035] Similarly, "Basic Pattern 2-2" is a calculation pattern in which a royalty rate of "6.0%" is used to calculate royalties for products sold or to be sold in the range of 50001g to 100kg, with the rounding classification being "rounded off" to any fractional amounts. Similarly, "Basic Pattern 2-3" is a calculation pattern in which a royalty rate of "5.5%" is used to calculate royalties for products sold or to be sold in the range of 100001g to 200kg, with the rounding classification being "rounded off" to any fractional amounts.

[0036] The sales plan data storage unit 13 stores sales plan data such as the example shown in FIG. 4. This sales plan data is predicted sales forecast data for products that are planned to be sold in the future. This sales plan data includes the planned month (planned sales month), product code, product name, unit price, quantity (units), sales amount, cost price, and gross profit. Since the products have not yet been sold, the sales amount and gross profit are estimated amounts. This sales plan data is used during simulations for royalty calculations, etc.

[0037] The sales data storage unit 14 stores sales data of products actually sold, as shown in Fig. 5. This sales data includes the month of sale, product code, product name, unit price, quantity (units), sales amount, cost price, and gross profit.

[0038] The royalty simulation data storage unit 15 stores the royalty amount (payment amount) and predicted profits calculated by simulation based on the sales plan data stored in the sales plan data storage unit 13 shown in FIG.

[0039] The expense data storage unit 16 stores royalty amounts (payment amounts) relative to actual sales amounts, actual profits, etc., calculated based on sales data stored in the sales data storage unit 14 shown in FIG.

[0040] (Functional configuration of business support device) Next, the control unit 3 executes the business support program stored in the memory unit 2, and functions as a display control unit 21, a standard total quantity calculation unit 22, a rate detection unit 23, a royalty calculation unit 24, a profit calculation unit 25, and an output control unit 26, as shown in Figure 1.

[0041] The reference total quantity calculation unit 22 calculates the reference total quantity of the commercial transaction objects by multiplying the quantity of the commercial transaction objects that have already been sold or the quantity of the commercial transaction objects that are to be sold by the reference quantity that is the unit of the commercial transaction objects.

[0042] The rate detection unit 23 refers to the royalty calculation master table 12 in which royalty rates are stored for each royalty right holder and each standard total quantity, and detects the royalty rate corresponding to the calculated standard total quantity of the commercial transaction object.

[0043] The royalty calculation unit 24 calculates the royalty amount for the total sales amount of the commercial transaction items that have already been sold or the total projected sales amount of the commercial transaction items that are to be sold by multiplying the detected royalty rate by the total sales amount of the commercial transaction items that have already been sold or the total projected sales amount of the commercial transaction items that are to be sold.

[0044] The output control unit 26 outputs the calculated royalty amount to an output target device (for example, a display unit: output device 7). The output target device may be a display unit, a storage device such as the storage unit 2 or an external storage device, a printing device, or a speaker device. The output control unit 26 converts the calculated royalty amount into a data format compatible with the output target device and outputs it.

[0045] The profit calculation unit 25 calculates the sales profit amount of the commercial transaction objects that have been sold or the planned sales profit amount of the commercial transaction objects that are to be sold by subtracting the calculated royalty amount from the total gross profit amount of the commercial transaction objects that have been sold or the planned total gross profit amount of the commercial transaction objects that are to be sold. The output control unit 26 outputs the calculated sales profit amount or planned sales profit amount to the output target device.

[0046] The display control unit 21 displays a royalty calculation screen (see Figure 9) on the display unit (output device 7) that allows the user to select either a calculation of the royalty amount for a commercial transaction item that has already been sold or a simulation calculation of the royalty amount for a commercial transaction item that is scheduled to be sold.

[0047] When calculation of royalty amounts for sold transaction objects is selected via this royalty calculation screen, the standard total quantity calculation unit 22 calculates the standard total quantity of the transaction objects by multiplying the quantity of the sold transaction objects by the standard quantity. Furthermore, the multiplication rate detection unit 23 references the royalty calculation master table 12 to detect the royalty multiplication rate corresponding to the calculated standard total quantity of the transaction objects. Furthermore, the royalty calculation unit 24 calculates the royalty amount for the total sales amount of the sold transaction objects by multiplying the detected royalty multiplication rate by the total sales amount of the sold transaction objects. The output control unit 26 then outputs the calculated royalty amount for the sold transaction objects to the output target device (output device 7).

[0048] In addition, when the profit calculation unit 25 is included, the profit calculation unit 25 calculates the sales profit amount of the sold commercial transaction object by subtracting the calculated royalty amount from the total gross profit amount of the sold commercial transaction object. In this case, the output control unit 26 outputs the calculated royalty amount for the sold commercial transaction object and the sales profit amount of the sold commercial transaction object to the output target device.

[0049] On the other hand, if calculation of the royalty amount for the commercial transaction object to be sold is selected via the royalty calculation screen, the standard total quantity calculation unit 22 calculates the standard total quantity of the commercial transaction object to be sold by multiplying the quantity of the commercial transaction object to be sold by the standard quantity. Furthermore, the rate detection unit 23 references the royalty calculation master table 12 to detect the royalty rate corresponding to the calculated standard total quantity of the commercial transaction object to be sold. Furthermore, the royalty calculation unit 24 calculates the royalty amount for the total estimated sales amount of the commercial transaction object to be sold by multiplying the detected royalty rate by the total estimated sales amount of the commercial transaction object to be sold. Then, the output control unit 26 outputs the calculated royalty amount for the commercial transaction object to be sold to the output target device (output device 7).

[0050] In addition, when the profit calculation unit 25 is included, the profit calculation unit 25 calculates the planned sales profit amount of the commercial transaction object to be sold by subtracting the calculated royalty amount from the planned total gross profit amount of the commercial transaction object to be sold. In this case, the output control unit 26 outputs the calculated royalty amount for the commercial transaction object to be sold and the planned sales profit amount of the commercial transaction object to the output target device.

[0051] [Royalty amount calculation behavior] Next, the royalty amount calculation operation in the business support device 1 of the embodiment will be described. First, Fig. 8 is a diagram showing an outline of the royalty amount calculation operation in the business support device 1 of the embodiment. As shown in Fig. 8, the business support device 1 of the embodiment calculates the reference total quantity corresponding to the quantity of products actually sold, which is indicated by the sales data shown in Fig. 5, based on the reference quantity managed in the product number management master table 11.

[0052] Next, the royalty calculation master table 12 is referenced based on the royalty calculation category set for each product in the product number management master table 11 and the calculated standard total quantity, and the rounding category and royalty rate (%) corresponding to the standard total quantity of the product actually sold are detected.

[0053] The royalty rate (%) is then multiplied by the sales amount of the products actually sold to calculate the royalty amount corresponding to the sales amount. The royalty amount is then subtracted from the gross profit to calculate the sales profit amount.

[0054] The royalty amount and sales profit amount corresponding to the calculated sales amount are displayed via the output device 7 and stored in the expense data storage unit 16 shown in Fig. 7. Then, at a predetermined timing such as the end of the month, they are recorded in an accounting system (not shown) which is software, or in an accounting server device on a predetermined network.

[0055] It is also possible to simulate calculation of royalty amounts. In this case, the accounting staff inputs the sales plan data described with reference to Fig. 4 via the input device 6. The business support device 1 of the embodiment calculates the base total quantity corresponding to the quantity of products to be sold indicated in the sales plan data, based on the base quantity managed in the product number management master table 11.

[0056] Next, the royalty calculation master table 12 is referenced based on the royalty calculation category set for each product in the product number management master table 11 and the calculated standard total quantity, and the rounding category and royalty rate (%) corresponding to the standard total quantity of the products to be sold are detected.

[0057] The royalty amount corresponding to the planned sales amount is calculated by multiplying the sales amount of the products to be sold, as indicated in the sales plan data, by the royalty rate (%). The royalty amount is also subtracted from the gross profit to calculate the planned sales profit.

[0058] The royalty amount and sales profit amount corresponding to the calculated sales amount are displayed via the output device 7 and are used for business decisions, etc.

[0059] To explain in detail how the royalty amount is calculated, the accounting staff first operates the input device 6 to specify the display of the royalty calculation screen. When this specification operation is performed, the display control unit 21 displays the royalty calculation screen shown in FIG. 9 via the output device 7. This royalty calculation screen has a selection field for the processing type to select whether to perform a "simulation calculation" of the royalty amount or a "cost calculation." The royalty calculation screen also has an input field for the desired processing month for the "simulation calculation" or "cost calculation," and an input field for the supplier for which the royalty amount is to be calculated.

[0060] The accounting staff selects the desired processing category, inputs the desired processing month, and inputs the desired supplier for which the royalty amount will be calculated. The example in Figure 9 shows an example in which the "Simulation Calculation" processing category is selected, the processing month is input as "April 2023," and "Company C," which has a royalty calculation category of "2 (see Figure 3)," is input as the supplier for which the royalty amount will be calculated.

[0061] (Cost calculation) When the "cost calculation" processing category is selected, the standard total quantity calculation unit 22 calculates the standard total quantity of products actually sold by calculating "quantity of sales data x unit weight of product number management master table 11."

[0062] Specifically, assume that 40 units of product C with product code "3001" shown in Figure 2 are sold. In this case, the reference total quantity calculation unit 22 calculates "40 units x 500g = 20kg" to calculate the reference quantity of "20kg".

[0063] Similarly, assume that 70 units of product C with product code "3002" shown in Figure 2 are sold. In this case, the reference total quantity calculation unit 22 calculates "70 units x 1000g = 70kg" to calculate the reference quantity of "70kg".

[0064] Then, the standard total quantity calculation unit 22 calculates the standard total quantity of "90 kg" by adding the calculated standard quantity of "20 kg" for product C with product code "3001" and the calculated standard quantity of "70 kg" for product C with product code "3002".

[0065] Next, the markup detection unit 23 refers to the royalty calculation master table 12 shown in FIG. 3 based on the calculated base total quantity of "90 kg" and the royalty category of "2" for product C set in the product number management master table 11 shown in FIG. 2. Referring to this royalty calculation master table 12, the calculated base total quantity of "90 kg" for "Company C" corresponds to "Basic Pattern 2-2." Therefore, the markup detection unit 23 detects the fraction processing category of "round off" for "Basic Pattern 2-2" and the royalty markup of "6.0%" from the royalty calculation master table 12.

[0066] Next, the royalty calculation unit 24 calculates the royalty amount by calculating "total sales amount of product C in the sales data × royalty rate." In this example, the royalty amount is calculated as "royalty amount = 1,800,000 yen × 6.0% = 108,000 yen." The royalty calculation unit 24 stores the calculated royalty amount in the expense data storage unit 16 shown in FIG. 7.

[0067] The profit calculation unit 25 also calculates the sales profit amount by calculating "total profit of product C in the sales data - royalty amount." In this example, the sales profit amount is calculated as "sales profit amount = 360,000 yen - 108,000 yen = 252,000 yen." The royalty calculation unit 24 stores the calculated sales profit amount in the expense data storage unit 16 shown in FIG. 7.

[0068] (Simulation calculation) In contrast, when the "Simulation Calculation" processing category is selected on the royalty calculation screen, the standard total quantity calculation unit 22 calculates the standard total quantity of the products that are scheduled to be sold and that have been entered as sales plan data by calculating "quantity in sales plan data x unit weight in product number management master table 11."

[0069] Specifically, assume that sales plan data is input to plan the sale of 20 units of product C with product code "3001" shown in Fig. 2. In this case, the standard total quantity calculation unit 22 calculates "20 units x 500 g = 10 kg" to calculate the standard quantity of "10 kg."

[0070] Similarly, assume that sales plan data is input to plan the sale of 100 units of product C with product code "3002" shown in Fig. 2. In this case, the reference total quantity calculation unit 22 calculates "100 units x 1000g = 100kg" to calculate the reference quantity of "100kg".

[0071] Then, the standard total quantity calculation unit 22 calculates a standard total quantity of "110 kg" by adding the calculated standard quantity of "10 kg" for product C with product code "3001" and the calculated standard quantity of "100 kg" for product C with product code "3002".

[0072] Next, the markup detection unit 23 refers to the royalty calculation master table 12 shown in FIG. 3 based on the calculated base total quantity of "110 kg" and the royalty category of "2" for product C set in the product number management master table 11 shown in FIG. 2. Referring to this royalty calculation master table 12, the calculated base total quantity of "110 kg" for "Company C" corresponds to "Basic Pattern 2-3." Therefore, the markup detection unit 23 detects the fraction processing category of "round off" for "Basic Pattern 2-3" and the royalty markup of "5.5%" from the royalty calculation master table 12.

[0073] Next, royalty calculation unit 24 calculates the estimated royalty amount by calculating "the estimated total sales amount of product C in the sales plan data × royalty rate." In this example, the estimated royalty amount is calculated as "estimated royalty amount = 2.2 million yen × 5.5% = 121,000 yen." Royalty calculation unit 24 stores the calculated estimated royalty amount in royalty simulation data storage unit 15 shown in FIG. 6.

[0074] The profit calculation unit 25 also calculates the planned sales profit amount by calculating "total profit for product C in the sales plan data - planned royalty amount." In this example, the sales profit amount is calculated as "planned sales profit amount = 440,000 yen - 121,000 yen = 319,000 yen." The royalty calculation unit 24 stores the calculated planned sales profit amount in the expense data storage unit 16 shown in FIG. 6.

[0075] (Effects of the embodiment) As is clear from the above explanation, the business support device 1 of the embodiment can automatically and quickly calculate royalty amounts even when the standard quantity differs for each sales format of the product by mastering the standard quantity of the product and the royalty rate for the standard quantity in the product item management master table 11 and the royalty calculation master table 12. This allows income and expenditure to be quickly visualized, which can be useful for management decisions, etc.

[0076] Furthermore, by inputting sales plan information, it is possible to simulate profits that take royalties into account. This allows you to grasp expected profits at the time of sales planning, and to maximize profits.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

[0093] 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 may be selectively implemented by combining them in any way. [Industrial Applicability]

[0094] The present invention is suitable for application to accounting work in industries that involve accounting work including royalties, such as the cosmetics industry or the chemical industry. [Explanation of symbols]

[0095] 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 Part number management master table 12 Royalty Calculation Master Table 13 Sales plan data storage unit 14 Sales data storage section 15 Royalty simulation data storage unit 16 Expense data storage unit 21 Display control unit 22 Standard Total Quantity Calculation Section 23. Rate detection unit 24 Royalty Calculation Department 25 Profit calculation department 26 Output control section

Claims

1. a reference total quantity calculation unit that calculates a reference total quantity of the commercial transaction objects by multiplying the quantity of the commercial transaction objects that have already been sold or the quantity of the commercial transaction objects that are to be sold by a reference quantity that is a trading unit for the commercial transaction objects; a royalty calculation master table in which royalty rates are stored for each royalty right holder and each of the reference total quantities, and a royalty rate detection unit that detects the calculated royalty rate corresponding to the reference total quantity of the commercial transaction object; a royalty calculation unit that calculates a royalty amount for the total sales amount of the commercial transaction objects that have been sold or the total projected sales amount of the commercial transaction objects that are to be sold by multiplying the detected royalty rate by the total sales amount of the commercial transaction objects that have been sold or the total projected sales amount of the commercial transaction objects that are to be sold; an output control unit that outputs the calculated royalty amount to an output target device; A business support device having the above.

2. a profit calculation unit that calculates the sales profit amount of the commercial transaction objects that have been sold or the planned sales profit amount of the commercial transaction objects that are to be sold by subtracting the calculated royalty amount from the total gross profit amount of the commercial transaction objects that have been sold or the planned total gross profit amount of the commercial transaction objects that are to be sold, the output control unit outputs the calculated sales profit amount or the expected sales profit amount to the output target device; 2. The business support device according to claim 1, wherein:

3. a display control unit that displays on a display unit a royalty calculation screen that allows the user to select either a calculation of the royalty amount for the commercial transaction object that has already been sold or a simulation calculation of the royalty amount for the commercial transaction object that is to be sold; When calculation of the royalty amount for the sold commercial transaction objects is selected, the standard total quantity calculation unit calculates the standard total quantity of the commercial transaction objects by multiplying the quantity of the sold commercial transaction objects by the standard quantity, the rate detection unit references the royalty calculation master table to detect a royalty rate corresponding to the calculated standard total quantity of the commercial transaction objects, the royalty calculation unit calculates the royalty amount for the total sales amount of the sold commercial transaction objects by multiplying the detected royalty rate by the total sales amount of the sold commercial transaction objects, and the output control unit outputs the calculated royalty amount for the sold commercial transaction objects to the output target device, when calculation of the royalty amount for the commercial transaction object to be sold is selected, the standard total quantity calculation unit calculates the standard total quantity of the commercial transaction object to be sold by multiplying the quantity of the commercial transaction object to be sold by the standard quantity, the rate detection unit references the royalty calculation master table and detects a royalty rate corresponding to the calculated standard total quantity of the commercial transaction object to be sold, the royalty calculation unit calculates the royalty amount for the total estimated sales amount of the commercial transaction object to be sold by multiplying the detected royalty rate by the total estimated sales amount of the commercial transaction object to be sold, and the output control unit outputs the calculated royalty amount for the commercial transaction object to be sold to the output target device; 2. The business support device according to claim 1, wherein:

4. a display control unit that displays on a display unit a royalty calculation screen that allows the user to select either a calculation of the royalty amount for the commercial transaction object that has already been sold or a simulation calculation of the royalty amount for the commercial transaction object that is to be sold; when calculation of the royalty amount for the sold commercial transaction objects is selected, the standard total quantity calculation unit calculates the standard total quantity of the commercial transaction objects by multiplying the quantity of the sold commercial transaction objects by the standard quantity, the rate detection unit references the royalty calculation master table to detect a royalty rate corresponding to the calculated standard total quantity of the commercial transaction objects, the royalty calculation unit calculates the royalty amount for the total sales amount of the sold commercial transaction objects by multiplying the detected royalty rate by the total sales amount of the sold commercial transaction objects, the profit calculation unit calculates the sales profit amount of the sold commercial transaction objects by subtracting the calculated royalty amount from the total gross profit amount of the sold commercial transaction objects, and the output control unit outputs the calculated royalty amount for the sold commercial transaction objects and the sales profit amount of the sold commercial transaction objects to the output target device, when calculation of the royalty amount for the commercial transaction object to be sold is selected, the standard total quantity calculation unit calculates the standard total quantity of the commercial transaction object to be sold by multiplying the quantity of the commercial transaction object to be sold by the standard quantity, the rate detection unit references the royalty calculation master table to detect a royalty rate corresponding to the calculated standard total quantity of the commercial transaction object to be sold, the royalty calculation unit calculates the royalty amount for the total estimated sales amount of the commercial transaction object to be sold by multiplying the detected royalty rate by the total estimated sales amount of the commercial transaction object to be sold, the profit calculation unit calculates the estimated sales profit amount of the commercial transaction object to be sold by subtracting the calculated royalty amount from the total estimated gross profit amount of the commercial transaction object to be sold, and the output control unit outputs the calculated royalty amount for the commercial transaction object to be sold and the estimated sales profit amount of the commercial transaction object to be sold to the output target device; 3. The business support device according to claim 2, wherein:

5. a reference total quantity calculation step in which a reference total quantity calculation unit calculates a reference total quantity of the commercial transaction objects by multiplying the quantity of the commercial transaction objects that have already been sold or the quantity of the commercial transaction objects that are to be sold by a reference quantity that is a commercial transaction unit for the commercial transaction objects; a rate detection step in which a rate detection unit refers to a royalty calculation master table in which royalty rates are stored for each royalty right holder and for each reference total quantity, and detects a royalty rate corresponding to the calculated reference total quantity of the commercial transaction object; a royalty calculation step in which a royalty calculation unit calculates a royalty amount for the total sales amount of the commercial transaction objects that have been sold or the total projected sales amount of the commercial transaction objects that are to be sold by multiplying the detected royalty rate by the total sales amount of the commercial transaction objects that have been sold or the total projected sales amount of the commercial transaction objects that are to be sold; an output control step in which an output control unit outputs the calculated royalty amount to an output target device; A business support method having the above.

6. Computer, a reference total quantity calculation unit that calculates a reference total quantity of the commercial transaction objects by multiplying the quantity of the commercial transaction objects that have already been sold or the quantity of the commercial transaction objects that are to be sold by a reference quantity that is a trading unit for the commercial transaction objects; a royalty calculation master table in which royalty rates are stored for each royalty right holder and each of the reference total quantities, and a royalty rate detection unit that detects the calculated royalty rate corresponding to the reference total quantity of the commercial transaction object; a royalty calculation unit that calculates a royalty amount for the total sales amount of the commercial transaction objects that have been sold or the total projected sales amount of the commercial transaction objects that are to be sold by multiplying the detected royalty rate by the total sales amount of the commercial transaction objects that have been sold or the total projected sales amount of the commercial transaction objects that are to be sold; an output control unit that outputs the calculated royalty amount to an output target device; A business support program that functions as a

Citation Information

Patent Citations

  • How to implement marketing strategies

    JP7446022B1