KPI setting system and KPI setting program
The KPI setting system simplifies the process of setting and analyzing KPIs by displaying financial data and using interactive tools, enabling users to intuitively adjust inputs and simulate financial performance, thus improving goal setting and management efficiency.
Patent Information
- Application Number
- JP2023071649
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Filing Date
- 2023-04-25
- Publication Date
- 2024-11-07
- Estimated Expiration
- 2043-04-25
AI Technical Summary
Existing KPI setting systems are complex and require skilled management to effectively set and analyze key performance indicators, often resulting in vague targets and unclear goals for organizations.
A KPI setting system and program that allows users to easily set KPIs by displaying planned and actual financial data, calculating differences, and using color coding and spin buttons to intuitively adjust inputs, facilitating real-time simulation and analysis of financial performance.
Enables users to set appropriate KPIs with ease, providing clear insights into performance evaluation factors and allowing for real-time simulation of financial changes, thereby enhancing goal achievement and management efficiency.
Smart Images

Figure 2024157341000001_ABST
Abstract
Description
[Technical field]
[0001] The present invention relates to a KPI setting system and a KPI setting program for KPIs (key performance indicators). [Background technology]
[0002] Traditionally, it has been said that appropriate setting of KPIs (Key Performance Indicators) is essential for an organization to achieve its goals, and is an important indicator in performance evaluation. Setting KPIs makes it possible to grasp the performance of an organization and quantify and evaluate the process for achieving the goal. In other words, KPIs indicate the direction for an organization to achieve its goals, and it can be said that correct setting can promote efforts to achieve the goal. Such setting and analysis of KPIs are disclosed, for example, in Patent Document 1 and Patent Document 2. Patent Document 1 discloses a management indicator calculation system, and Patent Document 2 discloses a KPI analysis method.
[0003] By the way, although it is important to set KPIs and analyze the set KPIs, company managers are not necessarily skilled in setting and analyzing KPIs. In addition, many KPI-related systems, such as those disclosed in Patent Documents 1 and 2, involve complex operations and require skill to use. Therefore, in reality, many companies do not use the above-mentioned systems and simply set a goal for the next term, such as "10% increase in operating profit compared to the previous year," or complete their plans for the next term without clarifying how they will achieve the set goal. [Prior art documents] [Patent documents]
[0004] [Patent Document 1] JP 2005-11278 A [Patent Document 2] Patent Publication No. 2021-144701 Summary of the Invention [Problem to be solved by the invention]
[0005] Therefore, the problem that the present invention aims to disclose is to provide a KPI setting system, a KPI setting method, and a KPI setting program that enable users to set KPIs relatively easily and that enable users to set appropriate KPIs that will become important indicators in performance evaluation. [Means for solving the problem]
[0006] In order to solve the above problems, the KPI setting system according to the present invention comprises: A KPI setting system that allows a user to set a KPI (key performance indicator) for a first predetermined period, A computer having a processor and a memory device, The computer displaying a first area showing planned sales, planned variable costs, planned marginal profit, planned marginal profit rate, planned fixed costs and planned profits for a first specified period together with each of these items; Accepts input of planned sales and planned fixed costs, Accepting input of planned variable costs and / or planned marginal profit ratios, and calculating the planned variable costs or the planned marginal profit ratios based on the input values; Based on the input values, the planned marginal profit and planned profit are calculated. Each value in the first area is updated based on the entered or calculated value.
[0007] The KPI setting system preferably includes: The computer further storing the actual sales, actual variable costs, actual marginal profit, actual marginal profit rate, actual fixed costs, and actual profits for the second predetermined period; A second area displaying the actual sales amount, actual variable cost, actual marginal profit, actual marginal profit rate, actual fixed cost and actual profit for a second specified period together with the items is displayed together with the first area.
[0008] The KPI setting system preferably includes: The computer further The old planned sales, the old planned marginal profit rate, the old planned fixed costs, and the old planned profits for the second predetermined period are stored; Calculate the differences between the old planned sales, the old planned marginal profit ratio, the old planned fixed costs, and the old planned profit for the second specified period and the actual sales, the actual marginal profit ratio, the actual fixed costs, and the actual profit for the second specified period; A third area in which the calculated differences are displayed together with each specific item is displayed together with the first and second areas.
[0009] The KPI setting system preferably includes: The computer further Store the old planned sales, the old planned marginal profit rate, the old planned fixed costs, and the old planned profits for the second predetermined period; The following formulas are used to calculate the factors that will increase or decrease sales and the factors that will increase or decrease marginal profit ratio. Formula a: Sales increase / decrease factors = (actual sales for the second specified period - old planned sales) x old planned marginal profit rate Formula b: Factors for change in marginal profit ratio = (Actual marginal profit ratio for the second specified period - Old planned marginal profit ratio) x Actual sales for the second specified period Calculating the differences between the old planned fixed costs and old planned profits planned for the second specified period and the actual fixed costs and actual profits for the second specified period; A third area, which displays the calculated differences, factors causing increases or decreases in sales revenue, and factors causing increases or decreases in marginal profit ratio, together with each specific item, is displayed together with the first and second areas.
[0010] The KPI setting system preferably includes: The computer further The old planned variable costs and the old planned marginal profits for the second predetermined period are stored; A fourth area, which displays the old planned sales, old planned variable costs, old planned marginal profit, old planned marginal profit rate, old planned fixed costs and old planned profit for the second specified period along with their items, is displayed together with the first area, the second area and the third area.
[0011] The KPI setting system preferably includes: The computer further Accepts input of non-operating income and non-operating expenses, In the first area, non-operating income and non-operating expenses are further displayed, Furthermore, the planned profit is calculated based on the input non-operating income and non-operating expenses.
[0012] The KPI setting system preferably includes: The computer further storing actual non-operating income and actual non-operating expenses for a second predetermined period; storing the planned non-operating income and the planned non-operating expenses for the second predetermined period; In the second area, additionally display actual non-operating income and actual non-operating expenses, Calculating the differences between the planned non-operating income and the planned non-operating expenses for the second specified period and the actual non-operating income and the actual non-operating expenses for the second specified period; The calculated differences are further displayed in the third area together with each specific item, Planned non-operating income and planned non-operating expenses for a second predetermined period are further displayed in a fourth area.
[0013] The KPI setting system preferably includes: The computer further Each difference is displayed in a different color depending on whether it is a positive or negative number.
[0014] The KPI setting system preferably includes: The computer further storing the actual sales, actual marginal profit ratio, actual fixed costs, and actual profits for the third predetermined period; Calculate the differences between the actual sales, actual marginal profit ratio, actual fixed costs, and actual profits for the second and third specified periods, A fifth area, which displays the calculated differences together with each specific item, is displayed together with the first and second areas.
[0015] The KPI setting system preferably includes: The computer further storing the actual sales, actual marginal profit ratio, actual fixed costs, and actual profits for the third predetermined period; The following formulas are used to calculate the factors that will increase or decrease sales and the factors that will increase or decrease marginal profit ratio. Formula c: Sales increase / decrease factor = (actual sales for the second specified period - actual sales for the third specified period) x actual marginal profit rate for the third specified period Formula d: Factors for increase or decrease in marginal profit rate = (Actual marginal profit rate for second specified period - Actual marginal profit rate for third specified period) x Actual sales for second specified period Calculate the differences between the actual fixed costs and actual profits in the second and third specified periods, A fifth area, which displays the calculated differences, factors causing increases or decreases in sales revenue, and factors causing increases or decreases in marginal profit ratio along with each specific item, is displayed together with the first and second areas.
[0016] The KPI setting system preferably includes: The computer further storing the actual variable costs and actual marginal profits for the third predetermined period; A sixth area, which displays the actual sales, actual variable costs, actual marginal profit, actual marginal profit rate, actual fixed costs and actual profits for a third specified period along with their items, is displayed together with the first area, the second area and the fifth area.
[0017] The KPI setting system preferably includes: The computer further Accepts input of non-operating income and non-operating expenses, In the first area, non-operating income and non-operating expenses are further displayed, In addition, the planned profit is calculated based on the non-operating income and non-operating expenses entered. Store actual non-operating income and actual non-operating expenses for a second predetermined period; storing actual non-operating income and actual non-operating expenses for a third predetermined period; In the second area, the actual non-operating income and actual non-operating expenses are further displayed. Calculate the difference between actual non-operating income and actual non-operating expenses for the second and third specified periods; The calculated differences are further displayed in the fifth area together with the specific items, The actual non-operating income and actual non-operating expenses for the second specified period are further displayed in a sixth area.
[0018] The KPI setting system preferably includes: The computer further displays each difference in a different color depending on whether it is a positive or negative number.
[0019] The KPI setting system preferably includes: The computer further further displaying, in the first area, spin buttons for receiving inputs for each item in the first area; Input of each value using the spin button is accepted.
[0020] The KPI setting system preferably includes: The computer further Calculate the break-even ratio based on at least the planned sales, planned marginal profit rate, and planned fixed costs, The calculated break-even ratio is further displayed in the first area.
[0021] The KPI setting system preferably includes: The computer further Store the current sales amount and the current gross profit amount, Calculate the achievement rate of current sales against planned sales, Accepts input of reference period, In one plot area with the vertical axis representing the amount and the horizontal axis representing the input reference period, a graph area is generated in which the monthly gross profit and monthly sales are displayed side by side in a bar graph, and the monthly gross profit is displayed in a line graph; The generated graph area is displayed along with the percentage of current sales against planned sales.
[0022] The above KPI setting system is, for example, The computer further The monthly profit rate is calculated using the following formula: Formula e: Monthly profit margin = Monthly gross profit / Monthly sales Add percentage to the vertical axis in the plot area, The graph area to be generated is a graph area that displays a line graph of the calculated monthly profit margin instead of a line graph of monthly gross profit.
[0023] In order to solve the above problems, the KPI setting program according to the present invention is A KPI setting program for allowing a user to set a KPI (key performance indicator) for a first predetermined period, the KPI setting program being configured to include a computer having a calculation device and a storage device, displaying a first area displaying planned sales, planned variable costs, planned marginal profit, planned marginal profit rate, planned fixed costs, and planned profits for a first predetermined period together with each of these items; Accepting input of planned sales and planned fixed costs; receiving input of a planned variable cost and / or a planned marginal profit rate, and calculating the planned variable cost or the planned marginal profit rate based on the input value; Calculating the planned marginal profit and planned profit based on the input values; and updating each value in the first area with the input or calculated value. Effect of the Invention
[0024] The KPI setting system according to the present invention makes it possible to set KPIs relatively easily, and moreover makes it possible to set appropriate KPIs that will serve as important indicators in business performance evaluation. [Brief description of the drawings]
[0025] [Figure 1] 1 is an overall view of a KPI setting system according to an embodiment of the present invention. [Diagram 2] FIG. 1 is a block diagram of a computer. [Diagram 3] FIG. 1 is a diagram showing a first image. [Figure 4] FIG. [Diagram 5] FIG. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0026] Hereinafter, an embodiment of the KPI setting system and the KPI setting program of the present invention will be described with reference to the accompanying drawings.
[0027] First, some terms used in this specification will be explained. In this embodiment, the first, second, and third predetermined periods are each a business year, and each period is "one year," but this is merely an example and may be less than one year. In this embodiment, the accounting period for the business year is "September," but this is also merely an example and other months may be used as the accounting period.
[0028] Moreover, the "first specified period" refers to a desired period (business period) for setting KPIs. The "second specified period" refers to a period (business period) set by the user, which will be explained later. Moreover, the "third specified period" refers to a period (business period) of the year prior to the second specified period. Note that the first specified period and the second specified period may be the same period. Moreover, in this embodiment, the "current year" refers to the second specified period, and the "previous year" refers to the third specified period.
[0029] The "actual ordinary profit", "old planned ordinary profit" and "planned ordinary profit" correspond to the "actual profit", "old planned profit" and "planned profit" of the present invention, respectively.
[0030] <Hardware configuration> Next, the hardware configuration in this embodiment will be described. Fig. 1 is an overall view of a KPI setting system S according to this embodiment. As shown in Fig. 1, the KPI setting system S includes a computer 1, a display device 5, and an input device 6.
[0031] The computer 1 has an arithmetic unit C1 (CPU: Central Processing Unit), a storage device C2, and a memory C3. The computer 1 may be a personal computer, a smartphone, a tablet, or a so-called server computer. The computer 1 is configured to be able to communicate with a display device 5 and an input device 6 by wire or wirelessly. In addition to an OS (Operating System), a KPI setting program P is stored in the storage device C2.
[0032] The display device 5 displays information input from the computer 1. The display device 5 may be, for example, a monitor separate from the computer 1, or a monitor integrated into the computer 1, such as a smartphone or tablet, and is not particularly limited.
[0033] The input device 6 is a device for inputting values to the computer 1, and is not particularly limited and may be not only a mouse and a keyboard, but also a device such as a smartphone or tablet having a touch panel.
[0034] <Computer configuration> Next, the functional configuration of the computer 1 will be described. Fig. 2 is a block diagram of the computer 1. As shown in Fig. 2, the computer 1 has a storage unit 10, a period input unit 11, a switching input unit 12, a display unit 13, a performance value input unit 16, a marginal profit calculation unit 17, a marginal profit ratio calculation unit 18, an ordinary profit calculation unit 24, a difference calculation unit 26, an increase / decrease factor calculation unit 28, a sub-calculation output unit 30, a planned value input unit 32, a variable cost calculation unit 34, a break-even point ratio calculation unit 37, an achievement rate calculation unit 38, a reference period input unit 39, a product input unit 40, a graph generation unit 41, a report output unit 42, and a comparison calculation unit 43.
[0035] The storage unit 10 stores a first image G1, a second image G2, and a third image G3 to be displayed on the display device 5. The storage unit 10 also stores in advance product information for each product, including an identifier, a cost price, a sales quantity, and a sales destination, sales revenue for the previous year and the current year (2023 in this embodiment), gross profit for the previous year and the current year, and planned old planned sales revenue, old planned variable costs, old planned marginal profit, old planned marginal profit rate, old planned fixed costs, and old planned ordinary profit. In this embodiment, the storage unit 10 is described on the assumption that no other data is stored in advance, but the storage unit 10 may store other data in advance, and may not store sales revenue for the current year.
[0036] Furthermore, the storage unit 10 stores data directly input by a user and data calculated by the computer 1. The storage unit 10 may also store data received from another device or another storage device.
[0037] Fig. 3 shows the first image G1. As shown in Fig. 3, the first image G1 has a first area E1 (planning area for the desired year), a second area E2 (upper part of the current year's performance area), a fifth area E5 (lower part of the current year's performance area), and a sixth area E6 (previous year's performance area). The color of each item in the fifth area E5 is different from the colors of the other areas. This makes the fifth area E5 stand out more than the other areas, and increases the user's recognition of the fifth area E5.
[0038] Fig. 4 also shows the second image G2. As shown in Fig. 4, the second image G2 has a first area E1 (planning area for a desired year), a second area E2 (upper part of the current year's actual results area), a third area E3 (lower part of the current year's actual results area), and a fourth area E4 (current year's planning area). The first area E1 and the second area E2 in the first and second images G1, G2 are common areas in the first and second images G1, G2.
[0039] In this embodiment, the first and second images G1 and G2 have a period input area E7 in the upper left and an image switching area E8 in the upper left-right center. The image switching area E8 has option buttons along with the phrases "time series comparative analysis" and "plan vs. actual results comparative analysis." The first image G1 is an image corresponding to the time series comparative analysis, and the second image G2 is an image corresponding to the plan vs. actual results comparative analysis.
[0040] In addition, the first and second images G1 and G2 each have an input area for each item marked with an "*" in the drawing.
[0041] The period input unit 11 accepts the input of the current year (second predetermined period) input in the period input area E7. The period input unit 11 transmits the input data to the storage unit 10 and the display unit 13. In this embodiment, the data "2023" is displayed in the period input area E7. That is, in this embodiment, the period from October 2022 to September 2023 is the "second predetermined period", and the period from October 2021 to September 2022 is the "third predetermined period". In this embodiment, the period (first predetermined period) in the desired year plan is from October 2023 to September 2024, but may be, for example, from October 2022 to September 2023, the same as the second predetermined period, and is not necessarily limited to the year following the current year.
[0042] The switching input unit 12 accepts input of option buttons in the image switching area E8. When the user clicks any of the option buttons, the switching input unit 12 transmits to the display unit 13 which option button, "Time series comparative analysis" or "Plan vs. actual results comparative analysis", has been clicked.
[0043] The display unit 13 displays the first image G1 or the second image G2 for the corresponding period based on the period received from the period input unit 11. Also, the display unit 13 switches the image to be displayed on the display device 5 to the first image G1 or the second image G2 based on the data received from the switching input unit 12.
[0044] Furthermore, the display unit 13 causes the display device 5 to display the data input by the user in each area, the data calculated by each calculation unit, and the pre-stored data in the first and second images G1 and G2.
[0045] Next, each input unit and each calculation unit will be described with reference to Figures 2, 3, and 4. Note that the images in Figures 3 to 5 are merely sample images, and the numbers in the figures may not be consistent with each other.
[0046] The actual value input unit 16 accepts input of actual variable costs, actual fixed costs, actual non-operating income, and actual non-operating expenses for the corresponding fiscal year (2023 in this embodiment) in the second area E2. As described above, the actual sales in the second area E2 do not need to be input because the sales for the current fiscal year (2023 in this embodiment) are stored in advance. However, this is merely an example, and the actual value input unit 16 may accept input of actual sales for the current fiscal year. If actual sales are not input, the stored actual sales are displayed in the second area E2.
[0047] The actual value input unit 16 also accepts input of actual sales, actual variable costs, actual fixed costs, actual non-operating income, and actual non-operating expenses for the corresponding fiscal year in the sixth area E6. In this embodiment, since the sales for the previous fiscal year are also stored, if they are not input, the actual sales stored in the sixth area E6 will be displayed.
[0048] The performance values input in the second area E2 and the sixth area E6 are transmitted to the memory unit 10 and the display unit 13. The memory unit 10 stores the received performance values, and the display unit 13 displays the received performance values on the display device 5 in the second area E2 and the sixth area E6, as shown in Figs. 3 and 4.
[0049] The marginal profit calculation unit 17 calculates each actual marginal profit from each actual sales amount and each actual variable cost relating to the previous year's actual results and the current year's actual results using the following formula (1), and transmits the calculated values to the memory unit 10 and the display unit 13. The memory unit 10 stores each calculated actual marginal profit, and the display unit 13 displays each calculated actual marginal profit in the second area E2, the fourth area E4, and the sixth area E6. Equation (1): Marginal profit = sales - variable costs
[0050] The marginal profit ratio calculation unit 18 calculates each actual marginal profit ratio from the actual sales revenues and actual marginal profits relating to the previous year's actual results and the current year's actual results using the following formula (2), and transmits the calculated values to the memory unit 10 and the display unit 13. The memory unit 10 stores each of the calculated actual marginal profit ratios, and the display unit 13 displays each of the calculated actual marginal profit ratios in the second area E2, the fourth area E4, and the sixth area E6. Formula (2): Marginal profit ratio (%) = Marginal profit ÷ Sales x 100
[0051] The ordinary profit calculation unit 24 calculates each actual ordinary profit from the actual marginal profits, actual fixed costs, actual non-operating income, and actual non-operating expenses relating to the previous year's actual results and the current year's actual results using the following formula (3), and transmits the calculated values to the memory unit 10 and the display unit 13. The memory unit 10 stores each calculated actual ordinary profit, and the display unit 13 displays each calculated actual ordinary profit in the second area E2, the fourth area E4, and the sixth area E6. Equation (3): Operating profit = marginal profit - fixed costs + non-operating income - non-operating expenses
[0052] The difference calculation unit 26 calculates the respective differences between the actual ordinary profit, actual fixed cost, actual non-operating income, and actual non-operating expenses relating to the actual results for the current year and the previous year by the following formulas (4) to (7). The storage unit 10 stores the respective calculated differences. The display unit 13 displays the calculated actual ordinary profit difference as "ordinary profit increase / decrease amount", the difference in the actual fixed cost increase / decrease factor as "fixed cost increase / decrease factor", the difference in the actual non-operating income as "non-operating income increase / decrease factor", and the difference in the actual non-operating expenses as "non-operating expense increase / decrease factor" in the fifth area E5. In this way, the KPI setting system S allows the user to recognize the extent to which the fixed cost, non-operating income, and non-operating expenses affect the difference in the ordinary profit. Formula (4): Change in ordinary profit = current year ordinary profit - previous year ordinary profit Equation (5): Fixed cost change factor = previous year's fixed cost - current year's fixed cost Equation (6): Factors behind changes in non-operating income = current year non-operating income - previous year non-operating income Equation (7): Factors behind changes in non-operating expenses = Previous year's non-operating expenses - Current year's non-operating expenses
[0053] The increase / decrease factor calculation unit 28 calculates the sales increase / decrease factors and marginal profit rate increase / decrease factors relating to the previous year's actual results and the current year's actual results using the following formulas (8) and (9). The storage unit 10 stores the calculated sales increase / decrease factors and marginal profit rate increase / decrease factors. The display unit 13 displays the calculated sales increase / decrease factors and marginal profit rate increase / decrease factors in the lower part (fifth area E5) of the current year's actual results area of the first image G1. This allows the KPI setting system S to allow the user to recognize which of the difference in sales between the previous year and the current year and the difference in marginal profit rate between the previous year and the current year has a greater influence on the difference in ordinary profit between the previous year and the current year. Formula (8): Sales increase / decrease factor = (current year sales - previous year sales) x previous year marginal profit ratio Formula (9): Factors behind increase or decrease in marginal profit ratio = (current year marginal profit ratio - previous year marginal profit ratio) x current year sales
[0054] The sub-calculation unit 30 calculates the total of each factor (amount) by the following formula (10): The memory unit 10 stores the calculated total of each factor (amount), and the display unit 13 displays the calculated total of each factor (amount) as a "sub-total" in the third area E3. Formula (10): Subtotal = Sales increase / decrease factors + Marginal profit rate increase / decrease factors + Fixed cost increase / decrease factors + Non-operating income increase / decrease factors + Non-operating expense increase / decrease factors
[0055] The display unit 13 displays the values in the third area E3 and the fifth area E5 in different colors depending on whether they are positive or negative. In this embodiment, the display unit 13 displays positive values in green and negative values in red. This allows the KPI setting system S to allow the user to intuitively recognize which factor negatively affected the difference in operating profit and which factor positively affected the difference. Note that the colors used for color coding are merely examples, and the color coding by the display unit 13 is not limited to the colors described above.
[0056] The planned value input unit 32 accepts input of planned sales, planned marginal profit ratio, planned fixed costs, planned non-operating income, and planned non-operating expenses in the first area E1. A spin button SB is arranged adjacent to each item in the first area E1, and the planned value input unit 32 is configured to accept input by the user operating the spin button SB. Each input planned value is transmitted to the memory unit 10 and the display unit 13. The memory unit 10 stores each input planned value, and the display unit 13 displays each input planned value on the display device 5.
[0057] The marginal profit calculation unit 17 calculates the planned marginal profit from the planned sales amount and the planned marginal profit rate by the following formula (11), and transmits the calculated value to the storage unit 10 and the display unit 13. The storage unit 10 stores the calculated planned marginal profit, and the display unit 13 displays the calculated planned marginal profit in the first area E1. Formula (11): Marginal profit = sales × marginal profit ratio
[0058] The variable cost calculation unit 34 calculates the planned variable cost from the planned sales amount and the planned marginal profit by the following formula (12), and transmits the calculated value to the memory unit 10 and the display unit 13. The memory unit 10 stores the calculated planned variable cost, and the display unit 13 displays the calculated planned variable cost in the first area E1. Equation (12): Variable costs = sales - marginal profit
[0059] The break-even point ratio calculation unit 37 calculates the break-even point ratio by the following formula (13). The calculated break-even point ratio is transmitted to the memory unit 10 and the display unit 13. The memory unit 10 stores the calculated break-even point ratio, and the display unit 13 displays the calculated break-even point ratio in the first area E1 (break-even point ratio display area E9). Note that in formula (13), the break-even point ratio is calculated including non-operating income and non-operating expenses, but this is just an example, and the break-even point ratio calculation unit 37 may calculate the break-even point ratio excluding non-operating income and non-operating expenses. In this case, the formula for calculating the break-even point ratio is formula (13-1). Formula (13): Break-even ratio (%) = ((fixed costs - non-operating income + non-operating expenses) ÷ marginal profit ratio) ÷ sales x 100 Formula (13-1): Break-even ratio (%) = (fixed costs ÷ marginal profit rate) ÷ sales x 100
[0060] The ordinary profit calculation unit 24 calculates the planned ordinary profit from the planned marginal profit, the planned fixed costs, the planned non-operating income, and the planned non-operating expenses by the above formula (3), and transmits the calculated value to the memory unit 10 and the display unit 13. The memory unit 10 stores the calculated planned ordinary profit, and the display unit 13 displays the calculated planned ordinary profit in the first area E1.
[0061] Since each calculation unit calculates each planned value in real time according to the user's input of the planned value, the KPI setting system S allows the user to intuitively recognize the change in each value in real time due to the input of the planned value. More specifically, the user can intuitively recognize how much the planned ordinary profit will change due to the increase or decrease in the planned sales, planned marginal profit rate, planned fixed costs, planned non-operating income, and planned non-operating costs, and how much the variable costs and marginal profit will change due to the increase or decrease in the planned marginal profit rate.
[0062] The break-even point ratio is a financial analysis index that indicates the percentage of break-even sales when the actual sales amount is 100%. By displaying the break-even point ratio, the KPI setting system S allows the user to specify the minimum sales amount required to launch a new product or new business, and the minimum sales amount required for cost reduction and efficiency. In addition, the user can recognize how much leeway there is in management based on the level of the break-even point ratio. For example, if the break-even point ratio is high, the user can recognize that there is no leeway in management, that is, the profit margin is decreasing. Conversely, if the break-even point ratio is low, the user can recognize that the profit margin is large and safe. If the break-even point ratio exceeds 100%, the user can understand at a glance that there is a deficit. The break-even point ratio may be used to calculate the safety margin (safety margin (%) = 100 - break-even point ratio). The safety margin becomes low when the break-even point ratio is high, so the user can recognize that there is no leeway in management.
[0063] The KPI setting system S is configured to use planned ordinary profits, not planned operating profits, as the "planned profits" of the present invention. Ordinary profits indicate "profits obtained on an ordinary basis," that is, a certain amount of profit that is always desired to be secured in terms of management. Therefore, ordinary profits are an indicator of whether the company is currently making a profit as a whole. In addition, while non-operating profits and losses are sometimes treated as fixed costs, ordinary profits are easy to think of as the profit target for the entire company because they include non-operating profits and losses. On the other hand, although operating profits are good for knowing the capabilities of a company's main business, they are not an indicator of whether the company is currently making a profit as a whole because they exclude non-operating profits and losses. Furthermore, in the basic analysis table (a comparison table of excellent companies, profitable companies, and loss-making companies) provided by information service providers, ordinary profits are used for comparison, so by using ordinary profits, it is possible to confirm where the company is (excellent, profitable, loss, average).
[0064] The KPI setting system S, having the above configuration, allows the user to set KPIs while referring not only to the actual performance values of the previous year and the current year, but also to the factors that caused the increase or decrease. Specifically, the user can set KPIs while checking the following items: -What is the reason for the difference between the previous fiscal year's actual ordinary profit and the current fiscal year's actual ordinary profit? -How much and by what percentage should sales be increased in order to increase operating profits? -To what extent should the marginal profit ratio be increased in order to increase operating profit?
[0065] The storage unit 10 stores each planned value (KPI) for the desired year set in this manner in association with the desired year.
[0066] The display unit 13 displays the old planned sales, old planned variable costs, old planned marginal profit, old planned marginal profit rate, old planned fixed costs, old planned non-operating income, old planned non-operating expenses and old planned ordinary profit for the current fiscal year along with their items in the fourth area E4.
[0067] The difference calculation unit 26 calculates the differences between the actual ordinary profit, actual fixed cost, actual non-operating income, and actual non-operating expenses related to the current year actual results and the current year plan, and the old planned sales, old planned variable cost, old planned marginal profit, old planned marginal profit rate, old planned fixed cost, and old planned ordinary profit planned in the current year (second specified period) by the following formulas (14) to (17), and transmits the calculated values to the storage unit 10 and the display unit 13. The storage unit 10 stores each of the calculated differences. The display unit 13 displays the calculated ordinary profit difference as the "ordinary profit increase / decrease amount", the fixed cost increase / decrease factor difference as the "fixed cost increase / decrease factor", the non-operating income difference as the "non-operating income increase / decrease factor", and the non-operating expense difference as the "non-operating expense increase / decrease factor" in the third area E3 of the second image G2. Formula (14): Change in ordinary profit = current year ordinary profit - old planned ordinary profit Equation (15): Fixed cost change factor = old plan fixed cost - current year fixed cost Equation (16): Factors behind changes in non-operating income = current year non-operating income - previous plan non-operating income Formula (17): Factors behind changes in non-operating expenses = Previously planned non-operating expenses - Current year non-operating expenses
[0068] The increase / decrease factor calculation unit 28 calculates the sales increase / decrease factors and the marginal profit rate increase / decrease factors related to the current year's actual results and the current year's plan using the following formulas (18) and (19), and transmits the calculated values to the memory unit 10 and the display unit 13. The memory unit 10 stores the calculated sales increase / decrease factors and marginal profit rate increase / decrease factors. The display unit 13 displays the calculated sales increase / decrease factors and marginal profit rate increase / decrease factors in the third area E3. Formula (18): Sales increase / decrease factor = (current year sales - old plan sales) x old plan marginal profit ratio Formula (19): Factors behind changes in marginal profit margin = (Current year marginal profit margin - Old planned marginal profit margin) x Current year sales
[0069] The KPI setting system S, having the above configuration, allows the user to set KPIs not only by referring to each planned value and each actual value for the current year, but also by referring to the factors that caused the increase or decrease. This allows the user to set KPIs while checking the following items: -What factors account for the difference between the planned and actual ordinary profits? -How much and by what items should the discrepancy between the plan and the actual results be corrected?
[0070] Next, the configuration of the KPI setting system S will be further described with reference to FIGS.
[0071] The storage unit 10 further stores a third image G3. As shown in Fig. 5, the third image G3 has a reference period input area E10, a graph display area E11, a KPI achievement rate display area E12, a sales amount display area E13, a sales quantity display area E14, a gross profit display area E15, an inventory display area E16, a product-specific report display area E17, a sales quantity-by-region display area E18, a sales amount comparison area E19, a sales quantity comparison area E20, a gross profit comparison area E21, and a product input area E22.
[0072] The achievement rate calculation unit 38 calculates the achievement rate of the current sales amount relative to the planned sales amount based on the stored product information and the planned sales amount. The calculated achievement rate is transmitted to the memory unit 10 and the display unit 13. The memory unit 10 stores the calculated achievement rate, and the display unit 13 displays the calculated achievement rate in the KPI achievement rate display area E12. In this embodiment, the KPI achievement rate display area E12 has a gauge graph, and displays the achievement rate as the gauge graph and the numerical value in the gauge graph. This allows the KPI setting system S to allow the user to intuitively recognize the current KPI achievement rate.
[0073] The reference period input unit 39 accepts input of a reference period. The input value is transmitted to the storage unit 10 and the display unit 13. The storage unit 10 stores the input reference period, and the display unit 13 displays the input reference period in the reference period input area E10.
[0074] The product input unit 40 accepts input of a product identifier. The input product identifier is transmitted to the storage unit 10 and the display unit 13. The storage unit 10 stores the input product identifier, and the display unit 13 displays the input product identifier in the product input area E22.
[0075] The graph generating unit 41 generates a graph area that displays monthly gross profit and monthly sales amount in a bar graph in one plot area with the vertical axis representing the amount and the horizontal axis representing the inputted reference period, and also displays the trend of gross profit in a line graph. The generated graph area is transmitted to the memory unit 10 and the display unit 13. The memory unit 10 stores the generated graph area, and the display unit 13 displays the generated graph area in the graph display area E11.
[0076] The report output unit 42 outputs the sales amount, sales quantity, gross profit, and sales quantity by region corresponding to the input reference period, as well as the current inventory amount. The output values are sent to the memory unit 10 and the display unit 13. The memory unit 10 stores the output values. The display unit 13 displays the output values in the sales amount display area E13, the sales quantity display area E14, the gross profit display area E15, the sales quantity by region display area E18, and the inventory amount display area E16. The output sales amount is the sales amount of all products, the output inventory amount is the inventory amount of all products, and the output sales quantity by region is the sales amount by region for all products.
[0077] The report output unit 42 further outputs the input product identifier and the sales amount of the product corresponding to the reference period. The outputted product sales amount is transmitted to the memory unit 10 and the display unit 13. The memory unit 10 stores the outputted product sales amount, and the display unit 13 displays the outputted product sales amount in the product-specific report display area E17.
[0078] The graph generating unit 41 further generates a bar graph based on the sales amount of the product output by the report output unit 42. The generated bar graph is transmitted to the memory unit 10 and the display unit 13. The memory unit 10 stores the generated bar graph, and the display unit 13 displays the generated bar graph in the product-specific report display area E17.
[0079] The comparison calculation unit 43 calculates the percentage (%) by which the sales amount, sales quantity, and gross profit for the first month of the input reference period have increased or decreased compared to the sales amount, sales quantity, and gross profit for the corresponding month of the previous year. Each calculated percentage is transmitted to the memory unit 10 and the display unit 13. The memory unit 10 stores each calculated percentage, and the display unit 13 displays each calculated percentage in the sales amount comparison area E19, the sales quantity comparison area E20, and the gross profit comparison area E21, respectively.
[0080] By having the user refer to the third image G3, the KPI setting system S can allow the user to intuitively recognize the trends in gross profit, sales, and gross profit for the reference period by displaying the graph area, along with the KPI achievement rate, i.e., the achievement rate of current sales against planned sales.
[0081] Furthermore, the KPI setting system S allows the user to input the identifier of a product that is of particular interest to the user in the product input area E22 and display the entered sales figures for each product in the product-specific report display area E17, thereby enabling the user to recognize the sales figures for each product.
[0082] Furthermore, the KPI setting system S displays a comparison of the sales revenue, sales volume, and gross profit between the first month of the reference period and the corresponding month of the previous year, thereby allowing the user to recognize the comparison of the sales revenue, sales volume, and gross profit with the previous year on a monthly basis.
[0083] By being provided with the above configuration, the KPI setting system S has the following effects.
[0084] <Comparison between previous and current fiscal year results, and recognition of factors> The KPI setting system S can allow the user to recognize the difference in operating profit between the previous year and the current year by having the user refer to the actual results for the previous year and the current year in the second area E2 and the sixth area E6.
[0085] Also, by referring to the fifth area E5, in which negative numbers and positive numbers are colored differently, it is possible to intuitively recognize which factors are responsible for the difference in ordinary profit between the previous year and the current year. Moreover, in order to recognize the factors behind the difference in ordinary profit, the KPI setting system S does not simply show the difference between the sales and marginal profit of the previous year and the sales and marginal profit of the current year, but multiplies each difference by the previous year's marginal profit rate and the sales of the current year, respectively, using formulas (8) and (9), allowing the factors behind the difference in ordinary profit to be recognized as an increase or decrease in sales and an increase or decrease in marginal profit.
[0086] <KPI setting in the first image> The KPI setting system S then displays the fifth area E5, allowing the user to compare the previous year with the current year and recognize the factors behind the comparison, before displaying the KPI setting area (first area E1). This allows the user to set KPIs while easily recognizing the factors behind past operating profits.
[0087] Moreover, the KPI setting system S allows the user to set each value while recognizing the fluctuations in variable costs, marginal profits, and especially ordinary profits in real time by increasing or decreasing the set sales amount and other values with the spin button SB. This allows the user to simulate the ordinary profit when each value is changed.
[0088] <Comparison between current fiscal year plan and actual results, and recognition of factors> The KPI setting system S can allow the user to recognize the difference between the current year plan and the current year's actual results by having the user refer to the current year plan and the current year's actual results in the second area E2 and the fourth area E4.
[0089] Furthermore, the KPI setting system S allows the user to intuitively recognize which factors are responsible for the difference in ordinary profit between the plan and the actual results by referring to the third area E3 in which negative numbers and positive numbers are colored differently. Moreover, in order to recognize the factors behind these ordinary profit differences, the KPI setting system S does not simply show the differences between the plan and the actual results in terms of sales and marginal profit, but multiplies each difference by the old plan marginal profit rate and the current year's sales, respectively, using formulas (18) and (19), allowing the user to recognize the factors behind the difference in ordinary profit as an increase or decrease in sales and an increase or decrease in marginal profit.
[0090] <KPI setting in the second image> The KPI setting system S then displays the third area E3, and displays the KPI setting area (first area E1) while allowing the user to compare the plan with the actual results and recognize the factors behind them, thereby allowing the user to set KPIs while easily recognizing the factors behind the difference between the plan and the actual results.
[0091] Moreover, as described above, the KPI setting system S allows the user to set each value while recognizing fluctuations in variable costs, marginal profits, and especially operating profits in real time by using the spin button SB to raise and lower the set sales and other values.
[0092] <Recognition of KPI achievement rate in the third image> Furthermore, the KPI setting system S allows the user to input a reference period while displaying the current KPI achievement rate in real time in the third image G3, and allows the user to recognize the trends in sales, gross profit, and gross profit during the reference period. This allows the user to easily recognize what sales trends are the result of the current KPI achievement rate. Moreover, the KPI setting system S allows the user to recognize the differences in sales, sales volume, and gross profit between the current year and the previous year in a specified month by allowing the user to input a reference period of their choice.
[0093] In addition, the KPI setting system S allows the user to recognize the factors that affect KPI achievement rate (sales achievement rate) due to regional differences by displaying the sales volume for each region, and allows the user to recognize the factors that affect KPI achievement rate (sales achievement rate) based on the product by displaying the sales volume of a specified product.
[0094] <Update of KPI in the second image> The KPI setting system S can also set the current year and the desired year to be the same year. Therefore, after setting the KPI, the KPI setting system S can allow the user to recognize the KPI achievement rate and its progress in the third image G3, and can also allow the user to set (update) the KPI for the current year again while being aware of the KPI setting for the current year in the second image G2. This allows the user to update the KPI appropriately.
[0095] Although an embodiment of the KPI setting system S and the KPI setting program P of the present invention has been described above, the present invention is not limited to the above embodiment. For example, the KPI setting system S and the KPI setting program P of the present invention may be implemented by combining the following modified examples.
[0096] <Modification> The KPI setting system S may use operating profit instead of ordinary profit as the "planned profit", "actual profit" and "old planned profit" in the present invention by excluding non-operating income and non-operating expenses. In this case, the KPI setting system S allows the user to set the KPI related to the profit obtained from the company's normal business activities (i.e., operating profit).
[0097] The input of the sales amount, marginal profit ratio, fixed cost, non-operating income, and non-operating expenses in the first area E1 is not limited to the use of the spin buttons SB. For example, instead of using the spin buttons SB, values may be input directly or using a slider.
[0098] In the above embodiment, the marginal profit ratio is input in the first area E1, and the marginal profit calculation unit 17 and the variable cost calculation unit 34 calculate the variable cost and the marginal profit. Alternatively, the variable cost may be input, the marginal profit calculation unit 17 may calculate the marginal profit, and the marginal profit ratio calculation unit 18 may calculate the marginal profit ratio.
[0099] The sales increase / decrease factors and marginal profit rate increase / decrease factors in the fifth area E5 may simply indicate the difference between the actual sales for the previous year and the actual sales for the current year, and the difference between the actual marginal profit rate for the previous year and the actual marginal profit rate for the current year. In this case, the difference calculation unit 26 calculates the sales increase / decrease factors and marginal profit rate increase / decrease factors using the following formulas (20) and (21). This allows the KPI setting system S to allow the user to clearly recognize the difference between the actual sales and actual marginal profit rate between the previous year and the current year. Equation (20): Sales increase / decrease factor = current year sales - previous year sales Equation (21): Factors behind increase or decrease in marginal profit rate = current year marginal profit rate - previous year marginal profit rate
[0100] The factors of increase / decrease in sales and factors of increase / decrease in marginal profit rate in the third area E3 may simply indicate the difference between the old planned sales and the sales for the current year, and the difference between the old planned marginal profit for the previous year and the actual marginal profit rate for the current year. In this case, the difference calculation unit 26 calculates the factors of increase / decrease in sales and factors of increase / decrease in marginal profit rate by the following formulas (22) and (23). This allows the KPI setting system S to allow the user to clearly recognize the difference in sales and marginal profit rate between the old plan and the actual results for the current year. Equation (22): Sales increase / decrease factors = Actual sales for the current fiscal year - Previously planned sales Formula (23): Factors behind increase or decrease in marginal profit ratio = Actual marginal profit ratio for the current fiscal year - Previously planned marginal profit ratio
[0101] The second image G2 may include a graph display area E11. This allows the KPI setting system S to allow the user to set KPIs while being aware of past KPI settings, past sales figures, and trends in gross profit.
[0102] The computer may calculate the monthly profit margin using the following formula (24), add the rate to the vertical axis of the plot area in graph display area E11, and further generate a graph area that displays a line graph of the calculated monthly profit margin instead of (or in addition to) the line graph of monthly gross profit. Formula (24): Monthly profit margin (%) = Monthly gross profit ÷ Monthly sales x 100 [Explanation of symbols]
[0103] S KPI setting system C1 arithmetic unit C2 storage C3 Memory G1 1st image G2 2nd image G3 3rd image E1 1st Area (Planning area for desired year) E2 Area 2 (top of current year performance area) E3 3rd Area (lower part of the current year performance area in the 2nd image) E4 4th Area (Current Year Plan Area) E5 5th Area (lower part of the current year performance area in the first image) E6 6th Area (Previous year performance area) E7 Period input area E8 Image switching area E9 Break-even ratio display area E10 Reference period input area E11 Graph display area E12 KPI achievement rate display area E13 Sales display area E14 Sales volume display area E15 Gross profit display area E16 Inventory display area E17 Product-specific report display area E18 Sales volume display area by region E19 Sales Comparison Area E20 Sales volume comparison area E21 Gross Profit Comparison Area E22 Product input area SB Spin button P KPI Setting Program 1. Computer 10 Storage section 11 Period input section 12 Switching input section 13 Display section 16 Actual value input section 17 Marginal Profit Calculation Department 18 Marginal Profit Rate Calculation Department 24. Ordinary Profit Calculation Department 26 Difference calculation part 28 Increase / decrease factor calculation section 30 Subcalculation section 32 Plan value input section 34 Variable Cost Calculation Department 37 Break-even ratio calculation section 38 Achievement rate calculation section 39 Reference period input section 40 Product input section 41 Graph Generation Unit 42 Report output section 43 Comparison and Calculation Section 5 Display device 6 Input Devices
Claims
1. A KPI setting system that allows a user to set a KPI (key performance indicator) for a first predetermined period, A computer having a processor and a memory device, The computer includes: displaying a first area displaying the planned sales, planned variable costs, planned marginal profit, planned marginal profit rate, planned fixed costs, and planned profits for the first predetermined period together with each of these items; Accepting input of the planned sales amount and the planned fixed cost; receiving an input of the planned variable cost and / or the planned marginal profit rate, and calculating the planned variable cost or the planned marginal profit rate based on the input value; Calculating the planned marginal profit and the planned profit based on the input values; A KPI setting system that updates each value in the first area based on an input or calculated value.
2. The computer further comprises: storing the actual sales, actual variable costs, actual marginal profit, actual marginal profit rate, actual fixed costs, and actual profits for the second predetermined period; The KPI setting system of claim 1, wherein a second area displaying the actual sales, actual variable costs, actual marginal profit, actual marginal profit rate, actual fixed costs and actual profits for the second specified period together with their items is displayed together with the first area.
3. The computer further comprises: storing the old planned sales, the old planned marginal profit rate, the old planned fixed costs, and the old planned profits for the second predetermined period; Calculating the differences between the old planned sales, the old planned marginal profit rate, the old planned fixed costs, and the old planned profit planned for the second specified period and the actual sales, the actual marginal profit rate, the actual fixed costs, and the actual profit for the second specified period; The KPI setting system according to claim 2 , further comprising a third area, in which the calculated differences are displayed together with each specific item, displayed together with the first area and the second area.
4. The computer further comprises: storing the old planned sales, the old planned marginal profit rate, the old planned fixed costs, and the old planned profits for the second predetermined period; The following formulas are used to calculate the factors that will increase or decrease sales and the factors that will increase or decrease marginal profit ratio. Formula a: Sales increase / decrease factor = (the actual sales for the second specified period - the old planned sales) x the old planned marginal profit rate Formula b: Marginal profit rate increase / decrease factor=(actual marginal profit rate for the second specified period--old planned marginal profit rate)×actual sales for the second specified period Calculating the differences between the old planned fixed costs and the old planned profits planned for the second specified period and the actual fixed costs and the actual profits for the second specified period; The KPI setting system of claim 2, further comprising a third area displaying the calculated differences, the factors for increase / decrease in sales revenue, and the factors for increase / decrease in marginal profit margin together with specific items, said third area being displayed together with said first area and said second area.
5. The computer further comprises: storing the old planned variable costs and the old planned marginal profits planned for the second predetermined period; A KPI setting system as described in claim 3 or 4, wherein a fourth area displaying the old planned sales, the old planned variable costs, the old planned marginal profit, the old planned marginal profit rate, the old planned fixed costs and the old planned profit for the second specified period together with their items is displayed together with the first area, the second area and the third area.
6. The computer further comprises: Accepts input of non-operating income and non-operating expenses, further displaying the non-operating income and the non-operating expenses in the first area; The KPI setting system according to claim 5 , further comprising: calculating the planned profit based on the inputted non-operating income and non-operating expenses.
7. The computer further comprises: storing actual non-operating income and actual non-operating expenses for the second predetermined period; storing planned non-operating income and planned non-operating expenses for the second predetermined period; further displaying the actual non-operating income and the actual non-operating expenses in the second area; Calculating the differences between the planned non-operating income and the planned non-operating expenses in the second specified period and the actual non-operating income and the actual non-operating expenses in the second specified period; The calculated differences are further displayed in the third area together with the specific items; The KPI setting system according to claim 6 , further comprising: displaying in the fourth area the planned non-operating income and the planned non-operating expenses for the second predetermined period.
8. The computer further comprises:
8. The KPI setting system according to claim 7, wherein each difference is displayed in a different color depending on whether it is a positive number or a negative number.
9. The computer further comprises: storing the actual sales amount, the actual marginal profit rate, the actual fixed cost, and the actual profit during a third predetermined period; Calculating the differences between the actual sales, the actual marginal profit rate, the actual fixed costs, and the actual profits in the second and third specified periods; The KPI setting system according to claim 2 , further comprising a fifth area, in which the calculated differences are displayed together with each specific item, displayed together with the first area and the second area.
10. The computer further comprises: storing the actual sales amount, the actual marginal profit rate, the actual fixed cost, and the actual profit during a third predetermined period; The following formulas are used to calculate the factors that will increase or decrease sales and the factors that will increase or decrease marginal profit ratio. Formula c: Sales increase / decrease factor=(the actual sales for the second specified period-the actual sales for the third specified period)×the actual marginal profit rate for the third specified period Formula d: Marginal profit rate increase / decrease factor=(the actual marginal profit rate for the second specified period-the actual marginal profit rate for the third specified period)×the actual sales for the second specified period Calculating the differences between the actual fixed costs and the actual profits in the second and third predetermined periods; The KPI setting system of claim 2, wherein a fifth area is displayed together with the first area and the second area, the fifth area displaying the calculated differences, the factors for the increase / decrease in sales, and the factors for the increase / decrease in marginal profit rate together with each specific item.
11. The computer further comprises: storing the actual variable cost and the actual marginal profit in the third predetermined period; A KPI setting system as described in claim 9 or 10, wherein a sixth area displaying the actual sales, actual variable costs, actual marginal profit, actual marginal profit rate, actual fixed costs and actual profits for the third specified period together with their items is displayed together with the first area, the second area and the fifth area.
12. The computer further comprises: Accepts input of non-operating income and non-operating expenses, further displaying the non-operating income and the non-operating expenses in the first area; Furthermore, the planned profit is calculated based on the non-operating income and the non-operating expenses inputted, storing actual non-operating income and actual non-operating expenses for the second predetermined period; storing the actual non-operating income and the actual non-operating expenses for the third predetermined period; further displaying the actual non-operating income and the actual non-operating expenses in the second area; Calculating the differences between the actual non-operating income and the actual non-operating expenses for the second and third specified periods; The calculated differences are further displayed in the fifth area together with the specific items; The KPI setting system according to claim 11 , further comprising: displaying, in the sixth area, the actual non-operating income and the actual non-operating expenses for the second predetermined period.
13. The computer further comprises: The KPI setting system according to claim 12, wherein each difference is displayed in a different color depending on whether it is a positive number or a negative number.
14. The computer further comprises: further displaying, in the first area, spin buttons for receiving inputs for each item in the first area; The KPI setting system according to any one of claims 1 to 4, 9 and 10, wherein input of each value using the spin button is accepted.
15. The computer further comprises: Calculating a break-even point ratio based on at least the planned sales, the planned marginal profit rate, and the planned fixed costs; The KPI setting system according to any one of claims 1 to 4, 9 and 10, further displaying the calculated break-even point ratio in the first area.
16. The computer further comprises: Store the current sales amount and the current gross profit amount, Calculate the achievement rate of the current sales against the planned sales; Accepts input of reference period, generating a graph area that displays monthly gross profit and monthly sales amount in a bar graph in one plot area with the vertical axis representing the amount and the horizontal axis representing the input reference period, and that displays the monthly gross profit in a line graph; 11. The KPI setting system according to claim 1, further comprising: displaying the generated graph area together with the achievement rate of the current sales amount against the planned sales amount.
17. The computer further comprises: The monthly profit rate is calculated using the following formula: Formula e: Monthly profit margin = Monthly gross profit ÷ Monthly sales Add a ratio to the vertical axis in the plot area; 17. The KPI setting system according to claim 16, wherein the graph area to be generated is a graph area that displays a line graph of the calculated monthly profit margin instead of a line graph of the monthly gross profit.
18. A KPI setting program that allows a user to set a KPI (key performance indicator) for a first predetermined period, A computer having a computing device and a storage device, displaying a first area displaying the planned sales, planned variable costs, planned marginal profit, planned marginal profit rate, planned fixed costs, and planned profits for the first predetermined period together with each of these items; Accepting input of the planned sales amount and the planned fixed cost; receiving an input of the planned variable cost and / or the planned marginal profit rate, and calculating the planned variable cost or the planned marginal profit rate based on the input value; Calculating the planned marginal profit and the planned profit based on the input values; and updating each value in the first area based on the input or calculated value.
Citation Information
Patent Citations
Device for spreadsheet
JP1992058370A
Cash flow statement, account, account originating device, and data storage medium storing account originating program
JP2002073939A
System for business result determination and computer program therefor
JP2004110257A
Financial analysis system
JP2004227601A
Signal graph display device for management analysis
JP3214737U
