Indicating processing device

Abstract

Provided is a display processing device for a sales management sheet of a business entity that can be used to improve the management of the business entity in the future. 【Solution means】The display processing device 1 displays a management sheet G10. The management sheet G10 includes a business item display column G11 for displaying business item information F1 indicating the business items of the business entity, a unit price display column G12 for displaying unit price information F2, a business provided quantity display column G13 for displaying business provided quantity information F3, an item sales amount display column G14 for displaying item sales amount information F4 indicating the business sales amount of the business items obtained based on the unit price information F2 and the business provided quantity information F3, and a total sales amount display column G15 for displaying total sales amount information F5 indicating the total sales amount of the business entity obtained based on the item sales amount information F4. The business item display column G11 can be set in multiple numbers, and the total sales amount information F5 is obtained and displayed based on the item sales amount information F4.

Description

Technical Field

[0001] The present invention relates to a display processing apparatus for a management sheet for managing the sales of a business entity during a predetermined period.

Background Art

[0002] Conventionally, for example, a display processing apparatus for displaying the total sales of business entities such as corporations and individual business owners as shown in Cited Document 1 has been widely known.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] Conventional display processing apparatuses as described above can display the total sales of a business entity and the business hours of the business entity to the user, but it is difficult for the user to grasp which business items among the business contents of the business entity contribute how much to the sales, and it was difficult to utilize for improving the management of the business entity in the future.

[0005] Therefore, an object of the present invention is to provide a display processing apparatus for a sales management sheet of a business entity that can be utilized for improving the management of the business entity in the future.

Means for Solving the Problems

[0006] In order to solve the above problems, the display processing apparatus according to the present invention displays a management sheet for managing the sales of a business entity during a predetermined period. The management sheet includes a business item display column for displaying business item information indicating the business items of the business entity set by the user, a unit price display column for displaying unit price information indicating the unit price of the business items, a business provision number display column for displaying business provision number information indicating the number of business provisions of the business items during the predetermined period, an item sales amount display column for displaying item sales amount information indicating the sales amount of the business of the business items during the predetermined period, which is obtained based on the unit price information in the unit price display column and the business provision number information in the business provision number display column, and a total sales amount display column for displaying total sales amount information indicating the total sales amount of the business entity during the predetermined period, which is obtained based on the item sales amount information displayed in the item sales amount display column. The business item display column can be set in plural, and the unit price display column, the business provision number display column, and the item sales amount display column are respectively provided in association with the plural business item display columns. The display control means is provided for obtaining the total sales amount information based on the item sales amount information of each item sales amount display column and displaying the total sales amount information in the total sales amount display column.

[0007] According to the above configuration, a plurality of business item display columns are set, and a unit price display column, a business provision quantity display column, and an item sales amount display column are respectively provided in association with these plurality of business item display columns. Therefore, the user can compare the business item information in the business item display column, the unit price information in the unit price display column, the business provision quantity information in the business provision quantity display column, and the item sales amount information in the item sales amount display column. As a result, the user can grasp, for which business item of the business entity, how much business has been provided (how many times the business has been provided to customers or how many hours of business have been conducted, etc.) and how much sales have been made during a predetermined period, and it becomes easier to propose business improvement for future sales increase. Furthermore, since the item sales amount information in the item sales amount display column is obtained based on the unit price information and the business provision quantity information, when the unit price information or the business provision quantity information is changed, the item sales amount information is automatically changed. As a result, information corresponding to the unit price information and the business provision quantity information is displayed without the user inputting the item sales amount information. Also, the total sales amount information indicating the total sales amount of the business entity during a predetermined period is obtained based on the item sales amount information displayed in the item sales amount display column and is displayed in the total sales amount display column. Therefore, appropriate information corresponding to the item sales amount information is displayed to the user without the user calculating and inputting the total sales amount of the business entity during a predetermined period, and the user can be made to grasp the total sales amount during a predetermined period.

[0008] The above business item display column may be addable and / or deletable by the operation of the user.

[0009] According to the above configuration, the business item display column can be appropriately added / deleted according to the business content of the business entity. For example, when starting a new business or quitting an existing business, the business item display column can be added or deleted flexibly. Also, for the business item display column with a large sales amount, in order to further subdivide the business items, the business item display column can be added to divide the business item display column, etc. The business item display column can be provided in the most optimal way for the user to grasp the management information according to the user's judgment. As a result, the management sheet can be made useful for the subsequent business improvement of the business entity.

[0010] In the above unit price display column, the unit price information input by the user may be displayed, and / or in the above business service quantity display column, the business service quantity information input by the user may be displayed.

[0011] With the above configuration, the user can appropriately change the unit price information and / or the business service quantity information, and grasp how the item sales amount information and the total sales amount display column change. Thereby, it becomes easier for the user to set goals for future unit prices and business hours for business items.

[0012] The business service quantity information in the above business service quantity display column may indicate the number of times the business of the business item was provided to customers during the above predetermined period or the time spent performing the business of the business item during the above predetermined period.

[0013] According to the above configuration, for business items that perform price setting according to time or price setting according to the number of provided services, item sales amount information can be preferably obtained.

[0014] The above management sheet may include a total business hours display column and an average sales amount display column. The display control means may display total business hours information indicating the total business hours of the business entity during the above predetermined period in the total business hours display column, and based on the total business hours information and the total sales amount information, obtain the average sales amount per unit time of the business entity during the above predetermined period and display it in the average sales amount display column.

[0015] According to the above configuration, it is possible to provide a display processing device for a sales management sheet of a business entity that can enable a user to grasp the quality of time performance during a predetermined period and is useful for improving the future management of the business entity.

Effect of the Invention

[0016] According to the above configuration, it is possible to provide a display processing device for a sales management sheet of a business entity that is useful for improving the future management of the business entity.

Brief Description of the Drawings

[0017]

Figure 1

Figure 2

Figure 3

Mode for Carrying Out the Invention

[0018] 〔Management Sheet Displayed on Display Screen〕 Hereinafter, a display processing device according to an embodiment to which the present invention is applied will be described with reference to FIGS. 1 and 2. FIG. 1 is a diagram showing an example of a display screen of a display processing device according to an embodiment of the present invention. FIG. 2 is a functional block diagram of a display processing device according to an embodiment of the present invention.

[0019] The display processing device 1 is an information processing device equipped with a display screen G1, and a management sheet G10 for managing the sales of a business entity during a predetermined period is displayed on this display screen G1. Note that the display processing device 1 may display the management sheet G10 on the display screen (not shown) of an external display device (not shown) without being equipped with the display screen G1. A business entity is a corporation or an individual that conducts business. In this embodiment, the predetermined period is one month, but it may be any period as long as it is a fixed period such as one day, one week, a quarter, or one year. The user of this display processing device 1 may be a member of the business entity or a management consultant or management advisor who manages the business of the business entity.

[0020] The display processing device 1 has applications such as Excel (registered trademark) and Word (registered trademark) installed together with the OS (Operating System). By executing these applications, the management sheet G10 is displayed using the document file of the management sheet G10. However, as long as the display processing device 1 can display the management sheet G10, any method may be adopted. For example, the management sheet G10 may be displayed via a browser application.

[0021] Hereinafter, with reference to FIG. 1, the configuration of the management sheet G10 will be described. The management sheet G10 registers and displays information regarding the sales of a business entity during a predetermined period (one month in this embodiment) based on an operation input from the user. In this embodiment, the display processing device 1 can switch and display the management sheets G10 for different predetermined periods according to the user's operation. More specifically, the user can switch and display the management sheet G10 for the period during which they wish to manage the business entity. For example, it is possible to switch to the management sheet G10 for January 2025 and display the management sheet G10 for February 2025. In this embodiment, a predetermined period change operator G10A is displayed below the management sheet G10, and the management sheet G10 to be displayed is changed by selecting and executing this predetermined period change operator G10A.

[0022] The management sheet G10 includes a business item display column G11, a unit price display column G12, and a business service quantity display column G13. The business item display column G11 is an area for displaying business item information F1 indicating the business items of the business entity set by the user. A business item is a classification of the business content of a business entity and can be arbitrarily set by the user. Multiple business item display columns G11 can be set, and can be added and / or deleted by the user's operation. In this embodiment, the business item display column G11 can be added in the column direction. Also, the business item display column G11 can be classified for each type of business item. In this embodiment, it is classified into three types of business item types G11A, G11B, and G11C, and nine business item display columns G11 are set. The business item type G11A corresponds to the type of business item directly related to sales (such as "work"), and the business item types G11B and G11C correspond to the types of business items not directly related to sales (such as "activities at business exchange meetings" and "others").

[0023] The unit price display column G12 is an area for displaying unit price information F2 indicating the unit price of a business item. As described above, multiple business item display columns G11 can be set in the management sheet G10, and a unit price display column G12 is provided corresponding to each of the multiple business item display columns G11. That is, the corresponding business item display column G11 and unit price display column G12 are provided in the same row. The unit price information F2 is information indicating the unit price per business service time of a unit time (for example, 1 hour) or the unit price per business service of a unit number of times (for example, 1 time). In FIG. 1, unit price information F2 of 10,000 yen is registered in the unit price display column G12 corresponding to the business item display column G11 of the business item of personal training. In this embodiment, the unit price information F2 input by the user is displayed in the unit price display column G12, but the unit price information F2 registered in advance as a fixed fee may also be displayed.

[0024] The service provision number display column G13 is an area for displaying service provision number information F3 indicating the number of services provided for service items during a predetermined period (January 2025 in FIG. 1). The service provision number information F3 indicates the number of times the service of a service item was provided to customers during the predetermined period or the time taken to perform the service of the service item during the predetermined period. As described above, a plurality of service item display columns G11 can be set in the management sheet G10, and a service provision number display column G13 is provided in association with each of the plurality of service item display columns G11. That is, the corresponding service item display column G11 and the service provision number display column G13 are provided in the same row. In FIG. 1, service provision number information F3 indicating a provision number of 40 is registered in the service provision number display column G13 corresponding to the service item display column G11 of the personal training service item.

[0025] In addition, in the management sheet G10, in association with a plurality of service item display columns G11, a display column G16A for business hours information F6A indicating the business hours of the service item, a display column G16B for service provision time information F6B indicating the time taken to perform the service of the service item during the predetermined period, and a display column G16C for total time information F6C indicating the total time of the business hours information F6A and the service provision time information F6B are provided. When the service provision number information F3 indicates the time taken to perform the service of the service item during the predetermined period, the service provision time information F6B and the service provision number information F3 have the same content. Also, in the management sheet G10, a display column G13I for indicating the total business hours of the service item of the service item type G11A during the predetermined period and a display column G132 for indicating the total business hours of the service item of the service item type G11B during the predetermined period are provided.

[0026] Furthermore, the management sheet G10 includes an item sales amount display column G14 and a total sales amount display column G15. The item sales amount display column G14 is an area for displaying item sales amount information F4 indicating the sales amount of a business item during a predetermined period of the business. As described above, a plurality of business item display columns G11 can be set in the management sheet G10, and the item sales amount display column G14 is provided corresponding to each of the plurality of business item display columns G11 (in the same row). This enables the user to grasp the sales amount corresponding to the business of the business item information F1 in the business item display column G11. The item sales amount information F4 is automatically calculated and obtained based on the unit price information F2 in the unit price display column G12 and the business provided quantity information F3 in the business provided quantity display column G13. Thus, when the unit price information F2 or the business provided quantity information F3 is changed, the item sales amount information F4 is automatically changed. Therefore, information corresponding to the unit price information F2 and the business provided quantity information F3 is displayed without the user inputting the item sales amount information F4.

[0027] The total sales amount display column G15 is an area for displaying total sales amount information F5 indicating the total sales amount of the business entity during a predetermined period. The total sales amount information F5 is automatically calculated and obtained based on the item sales amount information F4 displayed in the item sales amount display column G14. More specifically, it is obtained by adding up the item sales amount information F4 of all the item sales amount information F4 in the management sheet G10. This enables the user to be displayed with appropriate information corresponding to the item sales amount information F4 without calculating and inputting the total sales amount of the business entity during a predetermined period, and enables the user to grasp the total sales amount during a predetermined period.

[0028] In addition, the management sheet G10 includes a total working hours display column G17 which is a display area for total working hours information F7 indicating the total working hours of the business entity during a predetermined period, and an average sales amount display column G18 which is a display area for average sales amount information F8 indicating the average sales amount per unit time (for example, per hour) of the business entity during a predetermined period. The total working hours information F7 is automatically calculated and acquired based on the service provision time information F6B in the display column G16B. Specifically, it is calculated by adding up the service provision time information F6B in all the display columns G16B. However, when the service provision number information F3 in the service provision number display column G13 indicates the time for performing the services of the business items during a predetermined period, it may be calculated based on the service provision number information F3. The average sales amount information F8 is automatically calculated and acquired based on the total working hours information F7 and the total sales amount information F5. Specifically, it is calculated by dividing the total sales amount information F5 by the total working hours information F7. Thereby, it is possible to provide a display processing device for a sales management sheet of a business entity that enables the user to grasp the time performance during a predetermined period and utilize it for improving the management of the business entity in the future.

[0029] Furthermore, the management sheet G10 includes a display column G19 which is a display area for the actual working hours per day input by the user, a display column G20 which is a display area for the number of working days (labor days) during a predetermined period input by the user, and a display column G21 for the working hours during a predetermined period calculated based on the input information in the display column G19 and the display column G20. Thereby, it is possible to make the user compare the display column G21 with the total working hours display column G17 and grasp the difference between the working hours during a predetermined period grasped by the user and the total working hours of the business entity during the predetermined period indicated by the total working hours information F7 which should be close to the fact.

[0030] In the display processing device 1 described above, a plurality of business item display columns G11 are set, and a management sheet G10 is provided in which a unit price display column G12, a business provision number display column G13, and an item sales amount display column G14 are respectively associated with these plurality of business item display columns G11. Therefore, the user can compare the business item information F1 in the business item display column G11, the unit price information F2 in the unit price display column G12, the business provision number information F3 in the business provision number display column G13, and the item sales amount information F4 in the item sales amount display column G14. As a result, the user can grasp for which business item of the business entity, how much sales were made by providing the service to the customer a certain number of times or performing the service for a certain number of hours during a predetermined period, and it becomes easier to propose management improvements for future sales growth.

[0031] Furthermore, when the unit price information F2 or the business provision number information F3 is changed, the item sales amount information F4 in the item sales amount display column G14 and the total sales amount information F5 in the total sales amount display column G15 are automatically changed and displayed. Therefore, the user can appropriately change the unit price information F2 or the business provision number information F3 and grasp how the item sales amount information F4 and the total sales amount information F5 change. As a result, it becomes easier for the user to set future unit price and business hour targets for the business item.

[0032] 〔Configuration of Display Processing Device〕 The display processing device 1 includes an operation unit 11, a communication unit 12, a storage unit 13, a display unit 14, and a CPU 15. The operation unit 11 is for receiving instructions (operations) from the user (such as a keyboard, mouse, etc.). The communication unit 12 communicates with other information processing devices via a communication network such as the Internet, either wired and / or wirelessly. The communication unit 12 may download programs and data necessary for displaying the management sheet G10 from a server (not shown). For example, the communication unit 12 may download applications such as Excel (registered trademark) and Word (registered trademark) from a server (not shown). Also, the communication unit 12 may download the data file of the management sheet G10 from a server (not shown) or obtain it via email or the like from another information processing device. Further, when the management sheet G10 is to be displayed on the display screen G1 via a browser application, the communication unit 12 may communicate with the server (not shown) that provides the management sheet G10.

[0033] The storage unit 13 is composed of, for example, a ROM, a RAM, a flash memory, a hard disk, etc. The storage unit 13 stores display data D1 such as the data file of the management sheet G10 and a display program P1 for causing the CPU 15 to execute a display process for displaying the management sheet G10 on the display screen G1. The display program P1 may be included in applications such as Excel (registered trademark) and Word (registered trademark).

[0034] The display unit 14 includes the display screen G1 and displays the management sheet G10. The display unit 14 is, for example, a display such as a liquid crystal display or an organic EL display.

[0035] In this embodiment, the CPU 15 functions as a display control means 151 by executing the display program P1 stored in the storage unit 13, executes the display process described later, and causes the management sheet G10 to be displayed on the display screen G1 of the display unit 14. Details of the display process will be described later.

[0036] 〔Display Process〕 FIG. 3 is a flowchart showing an example of the display process executed by the display processing device 151 shown in FIG. 2. The display process is performed on the CPU 15 when the display program P1 is executed. The execution of the display program P1 is started, for example, when the data file of the management sheet G10 is selected and the user gives an execution instruction. First, the CPU 15 displays the management sheet G10 on the display screen G1 (S1).

[0037] Here, when business item information F1, unit price information F2, number of business services provided information F3, business service time information F6B, etc. are already registered in the business item display column G11, unit price display column G12, number of business services provided display column G13, and display column G16B, these registered information F1, F2, F3, F6B, etc. are displayed in the management sheet G10. Then, based on the information F1, F2, F3, F6B, etc., item sales amount information F4, total sales amount information F5, total business time information F7, average sales amount information F8, etc. are appropriately calculated and displayed in the item sales amount display column G14, total sales amount display column G15, total business time display column G17, average sales amount display column G18, etc.

[0038] When the business item information F1, unit price information F2, number of business services provided information F3, and business service time information F6B, etc. are not registered, they are displayed as blanks (empty columns). Also, the item sales amount display column G14, total sales amount display column G15, total business time display column G17, average sales amount display column G18, etc. are also displayed as blanks (empty columns).

[0039] Next, the CPU 15 determines whether it has received a modification instruction for the management sheet G10 from the user (S2). The modification instruction for the management sheet G10 includes inputs and modifications such as the business item information F1, unit price information F2, business provision quantity information F3, and business provision time information F6B. The modification instruction for the management sheet G10 also includes a change instruction for the displayed management sheet G10 by the selection and execution operation of the predetermined period change operator G10A. If it is determined that the modification instruction for the management sheet G10 has been received from the user (YES in step S2), the CPU 15 modifies the management sheet G10 based on the received change instruction for the management sheet G10 and displays it on the display screen G1 (S3). When the selection and execution operation of the predetermined period change operator G10A is received, the displayed management sheet G10 is changed to the one for the instructed predetermined period. Thereafter, the CPU 15 proceeds to step S4 with the processing.

[0040] If it is determined that the modification instruction for the management sheet G10 has not been received from the user (YES in step S2), the CPU 15 proceeds to step S4 with the processing without executing step S3 above.

[0041] The CPU 15 determines whether it has received an end instruction for the display process (an end instruction for the display of the management sheet G10) from the user (S4). This instruction can be received, for example, when the user performs a selection and execution operation on an end operator (e.g., the "×" operator provided at the upper right end of the management sheet G10 in FIG. 1) displayed on the management sheet G10. If it is determined that the end instruction for the display process has been received from the user (YES in S4), the CPU 15 ends the display process. If it is determined that the end instruction for the display process has not been received from the user (NO in S4), the CPU 15 returns the processing to step S2.

[0042] (Modification example) The configuration of the management sheet G10 displayed by the display processing apparatus 1 according to the above-described embodiment is an example and may be changed as appropriate. For example, some of the display columns of the management sheet G10 shown in FIG. 1 may not be provided, or other display columns may be provided. Further, in the present embodiment, the management sheet G10 is configured by a single sheet, but may be configured by a plurality of sheets. That is, the management sheet G10 may be divided and displayed.

[0043] Further, the business item display column G11 may be configured such that it cannot be added and / or deleted by the user's operation and only a predetermined number of them are provided. Further, the unit price display column G12 and the business provision number display column G12 may not be configured to display the unit price information F2 and the business provision number information F3 arbitrarily input by the user. For example, the unit price information F2 may be fixed information that cannot be changed, or the business provision number information F3 acquired from a time card reader may be displayed.

Explanation of Signs

[0044] 1 Display processing apparatus 151 Display control means G10 Management sheet G11 Business item display column G12 Unit price display column G13 Business provision number display column G14 Item sales amount display column G15 Total sales amount display column G17 Total business hours display column G18 Average sales amount display column F1 Business item information F2 Unit price information F3 Business provision number information F4 Item sales amount information F5 Total sales amount information F7 Total business hours information F8 Average sales amount information

Claims

1. A display processing device for displaying a management sheet for managing the sales of a business entity during a predetermined period, wherein the management sheet includes: a business item display column for displaying business item information indicating the business items of the business entity set by the user; a unit price display column for displaying unit price information indicating the unit prices of the business items; a business provision quantity display column for displaying business provision quantity information indicating the number of times the business of the business items is provided to customers or the time spent on the business of the business items during the predetermined period; an item sales amount display column for displaying item sales amount information indicating the sales amount of the business of the business items during the predetermined period, which is obtained based on the unit price information in the unit price display column and the business provision quantity information in the business provision quantity display column; a total sales amount display column for displaying total sales amount information indicating the total sales amount of the business entity during the predetermined period, which is obtained based on the item sales amount information displayed in the item sales amount display column; and the business item display column can be set in plural, and the unit price display column, the business provision quantity display column, and the item sales amount display column are respectively provided in association with the plural business item display columns, and the display control means is provided for obtaining the total sales amount information based on the item sales amount information in each item sales amount display column and displaying the total sales amount information in the total sales amount display column. A display processing device characterized by the above.

2. The business item display column can be added and / or deleted by the user's operation. The display processing device according to claim 1, characterized by the above.

3. The unit price information input by the user is displayed in the unit price display column, and / or the business provision quantity information input by the user is displayed in the business provision quantity display column. The display processing device according to claim 1, characterized by the above.

4. The business provision quantity information in the business provision quantity display column indicates the number of times the business of the business items is provided to customers during the predetermined period or the time spent on the business of the business items during the predetermined period. The display processing device according to claim 1, characterized by the above.

5. The management sheet includes a total business time display column and an average sales amount display column. The display control means: displays total business time information indicating the total business time of the business entity during the predetermined period in the total business time display column; obtains the average sales amount per unit time of the business entity during the predetermined period based on the total business time information and the total sales amount information, and displays the average sales amount per unit time in the average sales amount display column. The display processing device according to claim 1, characterized by the above.

Images