Landing forecast value management device, landing forecast value management method, and landing forecast value management program
Patent Information
- Application Number
- JP2022018212
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2022-02-08
- Publication Date
- 2025-03-11
- Estimated Expiration
- 2042-02-08
AI Technical Summary
【0013】 本発明によれば、未アサイン原価を反映させた着地予想値を算出して、正確な案件管理を行うことができるという効果を奏する。
Smart Images

Figure 0007644038000001 
Figure 0007644038000002 
Figure 0007644038000003
Abstract
Description
[Technical field]
[0001] The present invention relates to a landing forecast value management device, a landing forecast value management method, and a landing forecast value management program. [Background technology]
[0002] Today, there is a known term for SES (System Engineering Services), which is a type of contract for the development, maintenance, and operation of software or systems, in which technical personnel are provided for specific tasks.
[0003] In addition, Patent Document 1 (JP Patent Publication No. 2020-013600) discloses a business management support system that aims to reduce the user's efforts in business analysis and fully contribute to business improvement. This business management support system includes multiple user terminals used by multiple users, a relay server that communicates with the multiple user terminals, and an analysis server that communicates with the multiple user terminals and the relay server.
[0004] The user terminal transmits user information, including information on the business performance of the user's store and information on cost management of the user's store, to the relay server. The relay server transmits specific user information from the user information to the analysis server. The analysis server also analyzes the specific user information based on predetermined analysis rules to obtain business management information on the user's store and transmits the information to multiple user terminals. The user terminal then displays the business management information hierarchically based on instructions from the user.
[0005] In addition, in the business management support system of Patent Document 1, tiles show forecast values (end result forecasts) of cumulative sales, cost rate, and labor cost rate as of the end of the current month calculated in accordance with specified rules on the analysis server, and below these, an enlarged line graph is displayed showing the daily trends in actual sales up to that day against the daily trends in the sales target (sales plan) for the current month displayed in the tile.
[0006] Here, by using ERP (Enterprise Resources Planning) etc., information on inquiries based on the probability of receiving an order, or on orders for which a contract has been officially concluded, can be managed by linking it with the assignment information of the engineers in charge. In addition, by accumulating the income and expenditure of the case based on the budget for each inquiry or order, the expected value can be calculated. [Prior art documents] [Patent documents]
[0007] [Patent Document 1] JP 2020-013600 A Summary of the Invention [Problem to be solved by the invention]
[0008] However, it was difficult to reflect future orders that did not even meet the quotation and the necessary labor costs (= unassigned costs) in the final forecast, even though they were expected to occur. This resulted in inaccurate final forecasts, which hindered accurate project management.
[0009] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a forecasted final value management device, a forecasted final value management method, and a forecasted final value management program that calculate a forecasted final value that reflects unassigned costs, enabling accurate project management. [Means for solving the problem]
[0010] In order to solve the above problems and achieve the object, the landing prediction value management device according to the present invention , proposal For a specified period of time The cost entered by the business operator as a costthe unassigned cost calculation unit calculates unassigned cost, which is an expense not assigned to the project, by multiplying the unassigned labor, which is a value obtained by subtracting the planned labor force for a specified period, by the monthly average planned time and then multiplying the result by the hourly rate; a planned value generation unit generates an added value of the tentative planned value and the unassigned cost as a planned value of the project's expense for a specified period; a final forecast value calculation unit calculates the sum of the actual value of the expense confirmed for the specified period and the planned value after the actual value was confirmed as a final forecast value corresponding to the planned value of the expense for the entire period; and an output control unit outputs the final forecast value corresponding to the planned value of the expense.
[0011] In order to solve the above problems and achieve the object, the landing forecast value management method according to the present invention comprises: a tentative scheduled value generating unit , proposal For a specified period of time The cost entered by the business operator as a cost the unassigned cost calculation unit calculates unassigned cost, which is an expense not assigned to the project, by multiplying the unassigned labor, which is a value obtained by subtracting the planned labor force for a specified period, by the monthly average planned time and multiplying the result by the hourly rate; the planned value generation step, in which the planned value generation unit generates a value obtained by adding the tentative planned value and the unassigned cost as the planned value of the project for the specified period; the expected final value calculation step, in which the expected final value calculation unit calculates the sum of the actual value of the expense confirmed for the specified period and the planned value after the actual value was confirmed as the expected final value corresponding to the planned value of the expense for the entire period; and the output control step in which the output control unit outputs the expected final value corresponding to the planned value of the expense.
[0012] In order to solve the above problems and achieve the object, the landing forecast value management program according to the present invention is a program for executing a landing forecast value management program on a computer. , proposal For a specified period of time The cost entered by the business operator as a costthe unassigned cost calculation unit calculates unassigned cost, which is an expense not assigned to the project, by multiplying the unassigned labor, which is a value obtained by subtracting the planned labor force for a specified period, by the monthly average planned time and then multiplying the result by the hourly rate; the planned value generation unit generates a value obtained by adding the tentative planned value and the unassigned cost as the planned value of the project for a specified period; the final forecast value calculation unit calculates the sum of the actual value of the expense confirmed for the specified period and the planned value after the actual value was confirmed as the final forecast value corresponding to the planned value of the expense for the entire period; and Effect of the Invention
[0013] According to the present invention, it is possible to calculate a final estimated value that reflects unassigned costs, thereby enabling accurate project management. [Brief description of the drawings]
[0014] [Figure 1] FIG. 1 is a block diagram showing a hardware configuration of a service management device according to an embodiment. [Diagram 2] FIG. 2 is a diagram for explaining an overview of the predicted landing value. [Diagram 3] FIG. 3 is a diagram showing an example of a forecast table of indirect costs by organization that reflects unassigned costs against the planned indirect costs for the full year. [Figure 4] FIG. 4 is a diagram for explaining data set in various masters. [Diagram 5] FIG. 5 is a flowchart showing the flow of the operation of registering a planned budget for a virtual project. [Figure 6] FIG. 6 is a diagram showing an example of virtual PJ data. [Figure 7] FIG. 7 is a diagram showing an example of a planned budget registered in a virtual project. [Figure 8]FIG. 8 is a diagram showing a virtual PJ update process for directly associating a PJ with a virtual PJ. [Figure 9] FIG. 9 is a diagram showing an example of a predicted landing value of the measured lower limit. [Figure 10] FIG. 10 is a flowchart showing the processing flow of a direct project that is received after the virtual project is formed. [Figure 11] FIG. 11 is a diagram showing an example of direct PJ data. [Figure 12] FIG. 12 is a diagram for explaining the personnel management registration process. [Figure 13] FIG. 13 is a diagram for explaining the operation of registering budget information in the direct PJ table. [Figure 14] FIG. 14 is a diagram for explaining the configuration process of a virtual PJ in which a PJ table is directly associated with a virtual PJ table. [Figure 15] FIG. 15 is a diagram showing an example of a forecasted outcome table by organization displayed without including unassigned costs. [Figure 16] FIG. 16 is a diagram for explaining the calculation operation of the unassigned cost. [Figure 17] FIG. 17 is a diagram showing an example of a forecasted end result table by organization, which shows a state in which unassigned costs are included. [Figure 18] FIG. 18 is a flowchart showing the flow of the registration process of sales for a direct project. [Figure 19] FIG. 19 is a diagram for explaining the sales input process for a project. [Figure 20] FIG. 20 is a diagram for explaining the input process of direct costs, indirect costs, and selling and general administrative costs in the month in which sales occurred. [Figure 21] FIG. 21 is a diagram showing an example of a forecasted outcome table by organization that reflects sales data and expense data. [Figure 22] FIG. 22 is a flowchart showing the flow of operations of the business support device when a new order for a new project is received. [Figure 23] FIG. 23 is a diagram showing an example of direct PJ data of a newly received project. [Figure 24] FIG. 24 is a diagram for explaining the personnel management registration process when an order for a new project is received. [Diagram 25] FIG. 25 is a diagram for explaining the process of registering budget information of a direct project. [Figure 26] FIG. 26 is a diagram for explaining the process of registering a budget for each project. [Figure 27] FIG. 27 is a diagram for explaining the operation of generating a forecast final outcome table by organization in a state in which unassigned costs are not reflected, corresponding to a direct project with project number "P001" and a direct project with project number "P002." [Figure 28] FIG. 28 is a diagram showing an example of an extraction screen for selecting whether or not to reflect unassigned costs in the organization-by-organization forecast table. [Figure 29] FIG. 29 is a diagram for explaining how to calculate the unassigned cost corresponding to a newly received project. [Diagram 30] FIG. 30 is a diagram showing an example of a forecast final outcome table by organization, reflecting unassigned costs corresponding to a direct project with project number "P001" and a direct project with project number "P002." DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0015] A service management device according to an embodiment of the present invention will be described in detail below with reference to the drawings. Note that the present invention is not limited to this embodiment.
[0016] (Hardware configuration) 1 is a block diagram showing a hardware configuration of a service management device 1 according to an embodiment. As shown in FIG. 1, the service management device 1 includes a storage unit 2, a control unit 3, a communication interface unit 4, and an input / output interface unit 5.
[0017] An input device 6 and an output device 7 are connected to the input / output interface unit 5. As the output device 7, a display unit such as a monitor device (including a home television) can be used.
[0018] As the input device 6, in addition to a keyboard device, a mouse device, and a microphone device, a monitor device that cooperates with the mouse device to realize a pointing device function can be used.
[0019] The storage unit 2 may be, for example, a storage device such as a ROM (Read Only Memory), a RAM (Random Access Memory), a HDD (Hard Disk Drive), or a SSD (Solid State Drive). The storage unit 2 has a cost element master 11, a planned unit price master 12, a department master 13, and an employee master 14, each of which is a storage area. The storage unit 2 also has a cost element table 15, a planned unit price table 16, a department table 17, an employee table 18, a direct project table (direct PJ table) 19, a budget table 20, and a virtual PJ table 21, each of which is a storage area. The storage unit 2 also has an organization-specific expected outcome table 22, a personnel management table 23, an unassigned table 24, a sales table 25, and an expense table 26, each of which is a storage area.
[0020] (Functional configuration of the business management device) Moreover, a business management program is stored in the memory unit 2. By executing this business management program, the control unit 3 functions as a master setting unit 31, an input processing unit 32, a data generation unit 33, a memory control unit 34, a calculation unit 35, and a display control unit 36. The data generation unit 33 is an example of a tentative estimated value generation unit, an estimated value generation unit, and a planned value generation unit. Moreover, the calculation unit 35 is an example of an unassigned cost calculation unit, and an expected final value calculation unit. Moreover, the display control unit 36 is an example of an output control unit.
[0021] The master setting unit 31 sets the cost element master 11, the planned unit price master 12, the department master 13, and the employee master. The input processing unit 32 acquires commands corresponding to input operations by the business operator when setting the master. The data generation unit 33 generates planned or estimated values of income and expenditure for a project (case). The memory control unit 34 controls the storage and reading of various data for the various masters 11-14 and the various tables 15-26. The calculation unit 35 calculates estimated values reflecting unassigned costs, and estimated final values. The display control unit 36 displays the estimated final values via the output device 7, which is an example of a display unit.
[0022] (Definition of terms) Next, the following terms are primarily used in the following sense.
[0023] Planned values: Sales and cost targets for each organization planned at the beginning of the period, etc. - Planned value: Planned figures for sales and costs calculated from the sum of the execution budgets for each project, etc. · Actual Value: Actual sales and costs incurred based on sales inspection, operating hours, etc.
[0024] Personnel management registration: Assigning engineers to orders and other projects and registering the planned man-months, etc. · Assigned labor cost: Labor cost for each person assigned to a case such as an order. The amount is determined by rank or contract type. Unassigned cost: Labor costs for each person who is not assigned to a project but is expected to be incurred in the future. Costs are incurred by both company employees and partner company employees. The amount is determined by rank or contract type.
[0025] - Execution budget: A revenue and expenditure plan for each project, including sales and costs estimated at the time of the inquiry or order, - Estimated value: The estimated income and expenditure for the full fiscal year, calculated by adding up the actual values up to the current month for which the actual values have been confirmed, and the estimated values for the following month and thereafter. Direct Project (Direct PJ): Projects that actually generate sales or expenses, such as inquiries or orders, Virtual Project (Virtual PJ): Virtual projects aggregated by organization.
[0026] (Summary of expected landing value) Figure 2 is a diagram showing an overview of the estimated values. As shown in Figure 2, the estimated values calculated are the estimated value of "sales", the estimated value of "direct costs", the estimated value of "indirect costs", and the estimated value of "sales and general administrative expenses (SG&A expenses)" of the project.
[0027] For example, the estimated value of the planned value for "sales" is calculated by adding together the total amount of the planned value from the beginning of the term to the base month (= past) and the total amount of the planned value from the month following the base month to the end of the term (= future). Also, the estimated value of the planned value for "sales" is calculated by adding together the total amount of the actual sales amount from the beginning of the term to the base month (= past) and the total amount of the planned value from the month following the base month to the end of the term (= future).
[0028] In addition, in the case of the business management device 1 of the embodiment, the unassigned cost is added to the overhead cost, which will be described in detail later. Therefore, the final estimated value of the planned value in the "overhead cost" is calculated as the sum of "the sum of the actual sales amount from the beginning of the term to the base month (= past) and the unassigned cost" and "the sum of the planned value from the month following the base month to the end of the term (= future) and the unassigned cost."
[0029] As one example, it is possible to output estimated costs including the planned costs of unassigned personnel who are not registered in personnel management for labor costs (for one year from the beginning accounting month of the extraction conditions). That is, by referencing the employee master 14 at the end of the month of the base month, for example, "Tanaka-san" is detected as an unassigned personnel. Also, the department code of the department to which the person belongs, such as "System Department 1", is obtained from the employee master 14. Also, Tanaka-san's planned unit price code and Tanaka-san's average monthly working hours, such as "160 hours", are obtained from the employee master 14. Also, based on Tanaka-san's planned unit price code obtained from the employee master 14, the planned unit price master is referenced to detect an hourly rate, such as "5,000 yen".
[0030] Then, Tanaka's labor cost is calculated by multiplying Tanaka's hourly rate by his average monthly working hours (5,000 yen x 160 hours = labor cost of 800,000 yen).
[0031] Next, for each month from the month following the base month through the end of the fiscal year, the unallocated man-hours amount (unassigned cost) is calculated from the unallocated man-hours (1 - assigned man-hours) in personnel management. For example, if the base month is December, and the assigned man-hours for January are "0.7", then "labor cost 800,000 yen x (1 - 0.7) = unassigned cost 240,000 yen." Similarly, if the assigned man-hours for February are "0", then "labor cost 800,000 yen x (1 - 0) = unassigned cost 800,000 yen." Similarly, if the assigned man-hours for March are "0", then "labor cost 800,000 yen x (1 - 0) = unassigned cost 800,000 yen."
[0032] Next, the unassigned cost is added to the estimated labor cost from the month following the base month to the end of the term to calculate the employee cost (estimate). For example, if the base month is December and the direct project budget (labor cost) for January is 1.2 million yen, the unassigned cost for January, 240,000 yen, is added to this 1.2 million yen to calculate the employee cost (estimate) for January to be 1.44 million yen. Similarly, if the direct project budget (labor cost) for February is 1.4 million yen, the unassigned cost for February, 800,000 yen, is added to this 1.4 million yen to calculate the employee cost (estimate) for February to be 2.2 million yen. Similarly, if the direct project budget (labor cost) for March is 300,000 yen, the unassigned cost for March, 800,000 yen, is added to this 300,000 yen to calculate the employee cost (estimate) for March to be 1.1 million yen.
[0033] Figure 3 shows an example of a forecast table by organization that reflects unassigned costs against the planned overhead for the entire year. In the example of Figure 3, at first glance, the sales forecast is 600,000 more than planned, and the direct costs are also 150,000 more than planned, so things look good. However, in reality, an increase in the cost of unassigned engineers is expected, which will lead to an increase in overhead and selling and administrative expenses, resulting in a forecast operating profit of -900,000.
[0034] If the estimated final value is calculated without including the unassigned costs, the estimated final value of indirect costs will be less (planned indirect costs: 300,000 -> 200,000). This will result in an erroneous decision to make a profit (operating profit: 1.5 million -> 2.4 million). The business support device 1 of the embodiment calculates the estimated final value by adding the unassigned costs, thereby preventing such erroneous decisions and enabling accurate management of the project.
[0035] (Settings for various masters) Fig. 4 is a diagram for explaining data set for various masters. Of these, Fig. 4(a) is a diagram showing data set for the cost element master 11. As shown in Fig. 4(a), cost element codes and cost element names such as "G01: direct cost", "G02: indirect cost", "G90: selling and general administrative cost" are set (registered) in the cost element master 11. Note that a cost element table 15 may be provided instead of the cost element master 11, and the above-mentioned cost element codes and cost element names may be set in this cost element table 15.
[0036] Fig. 4(b) is a diagram showing data set in the planned unit price master 12. As shown in Fig. 4(b), the planned unit price master 12 is set (registered) with planned unit price codes such as "YT01" and "YT02", planned unit price names such as "director's unit price" and "section manager's unit price", cost element codes such as "G01", and hourly unit prices such as "5000 yen" and "4000 yen". Note that a planned unit price table 16 may be provided instead of the planned unit price master 12, and the planned unit price codes and hourly unit prices, etc., described above may be set in this planned unit price table 16.
[0037] Fig. 4(c) is a diagram showing data set in the department master 13. As shown in Fig. 4(c), department codes and department names, such as "S01: System 1 Department" and "S02: System 2 Department", are set (registered) in the department master 13. Note that a department table 17 may be provided instead of the department master 13, and the above-mentioned department codes and department names may be set in this department table 17.
[0038] Fig. 4(d) is a diagram showing data set in the employee master data 14. As shown in Fig. 4(d), for example, employee codes such as "SH01" and "SH02", employee names such as "Tanaka" and "Suzuki", department codes such as "S01", scheduled unit price codes such as "YT01" and "YT02", and monthly average scheduled hours such as "160 hours" are set (registered) in the employee master data 14. Note that an employee table 18 may be provided instead of the employee master data 14, and the above-mentioned employee codes and monthly average scheduled hours may be set in this employee table 14.
[0039] (Landing prediction management operation) The landing prediction management operation in the task support device 1 according to the embodiment will be described below.
[0040] (Registering organizational plan budgets at the beginning of the period) First, a planned budget is registered for a virtual PJ, which is a hypothetical project formed by organization (department), at the beginning of a term, such as April 2021. FIG. 5 is a flowchart showing the flow of the operation of registering the planned budget for this virtual PJ.
[0041] When it is time to create a virtual project, the business operator inputs the department code, department name, and period of the department in charge of the virtual project. The input processing unit 32 acquires such input data, and the data generating unit 33 generates virtual project data including a virtual project number such as "KP001" illustrated in FIG. 6, a department code such as "S01", a department name such as "System 1 Department", and a period such as "April 2021 to March 2022" based on the acquired input data. Of these, the virtual project number is automatically assigned by the business management device 1. The storage control unit 34 stores the generated virtual project data in the virtual project table 21 (step S1).
[0042] Next, the business operator inputs the elements and the budget from April, which is the start of the term, to March of the following year, which is the end of the term, in association with the virtual project number. Specifically, the budget data includes the budgets for sales, direct costs, indirect costs, selling and general administrative expenses, and operating profit for each month of the above-mentioned period. The input processing unit 32 acquires such input data, and the data generating unit 33 generates budget data such as that shown in FIG. 7 based on the acquired input data. The memory control unit 34 stores the generated budget data in the budget table 20 (step S2).
[0043] Next, the data generating unit 33 associates the direct project numbers of direct projects that have actually generated sales or expenses, such as inquiries or orders received during the above-mentioned period, with the virtual project data stored in the virtual project table 21, as shown in the example of Fig. 8 (step S3: updating the virtual project). Since no direct projects have been generated at the beginning of this period, the data generating unit 33 does not perform updating the virtual project at this point.
[0044] Next, when the business operator specifies confirmation of the virtual project's expected outcome, the calculation unit 35 calculates the total amount of the budget for each month of the planned values of sales, direct costs, indirect costs, selling and general administrative expenses, and operating profit. The data generation unit 33 stores the total amount of the budget for each month of the planned values of sales, direct costs, indirect costs, selling and general administrative expenses, and operating profit calculated by the calculation unit 35 in the organization-specific forecast table 22 as the expected outcome values of the planned values of sales, direct costs, indirect costs, selling and general administrative expenses, and operating profit. In addition, the display control unit 36 displays the organization-specific forecast outcome table reflecting the expected outcome values of the planned values of sales, direct costs, indirect costs, selling and general administrative expenses, and operating profit, the planned values for each month, and the total amount on the output device 7 as shown in FIG. 9 (step S5).
[0045] At the beginning of this period, since there are no inquiries or orders, the forecast values for the planned values and the forecast values for the actual values are not calculated, and are not displayed in the forecast value table by organization.
[0046] (Direct project order processing) Next, Fig. 10 is a flow chart showing the flow of processing of a direct project that has actually been received after the formation of a virtual project. In this case, the data generating unit 33 performs registration processing of the received direct project (step S11). Specifically, for example, if a project of "6 million yen" has been received as shown in Fig. 11, the data generating unit 33 generates direct project data based on the input of the business operator, including a project number such as "P001", a department name such as "System 1 Department", a contract amount such as "6 million yen", an order classification such as "received order", and a projected sales amount with "2 million yen" allocated for each of April to June. The storage control unit 34 stores this direct project data in the direct project table 19.
[0047] Next, a personnel management registration process is performed, which is a process for assigning employees to be in charge of the April to June projects (step S12). Specifically, the business operator selects employees to be in charge of the April to June projects by referring to the employee master 14 and the planned unit price master 12 as shown in FIG. 12. The example in FIG. 12 is an example in which "Tanaka-san" is selected as the person in charge of the April to June projects. The business operator also inputs the planned labor hours for April to June based on Tanaka-san's average monthly planned hours stored in the employee master 14. The example in FIG. 12 is an example in which "0.7 man-months" is input as Tanaka-san's labor hours for April, and "1 man-month" is input as the labor hours for May and June, respectively.
[0048] Based on the input of the business operator, the data generation unit 33 generates personnel management data including a project number such as "P001", an employee name such as "Tanaka", a month such as "April", and a planned man-hours such as "0.7 man-months" or "1 man-months", as shown in FIG. 12.
[0049] 12, the calculation unit 35 detects Tanaka's monthly average scheduled hours (=160 hours) from the employee master 14, and also detects Tanaka's hourly rate (=5000 yen). Then, the calculation unit 35 calculates the direct costs from April to June by performing the following calculation.
[0050] April: 160 hours x 0.7 man-months x 5,000 yen = 560,000 yen May: 160 hours x 1.0 man-month x 5,000 yen = 800,000 yen June: 160 hours x 1.0 man-month x 5,000 yen = 800,000 yen
[0051] The storage control unit 34 stores the direct costs for April to June calculated in this manner in the personnel management table 23 in association with the personnel management data.
[0052] Next, as shown in Fig. 13, the business operator performs a process of registering budget information for the direct project via the project-specific budget registration screen (step S13). Specifically, the business operator inputs a projected sales amount of "2 million yen" to this project-specific budget registration screen as the projected sales amount for each month of April to June, which corresponds to the above-mentioned direct project of "6 million yen". The business operator also inputs "200,000 yen" as the monthly overhead for April to June, and inputs "600,000 yen" as the total overhead amount, to the project-specific budget registration screen. The business operator also inputs "140,000 yen" as the selling and general administrative expenses for April, and "200,000 yen" as the selling and administrative expenses for May and June, to the project-specific budget registration screen.
[0053] As explained using Figure 12, the monthly direct costs for April to June of "560,000 yen," "800,000 yen," and "800,000 yen," as well as the total amount for each month (2,160,000 yen), are read from the personnel management table 23 by the memory control unit 34 and automatically entered into the case-specific budget registration screen.
[0054] Moreover, the calculation unit 35 calculates the operating profit of "1.1 million yen" for April, "800,000 yen" for May, and "800,000 yen" for June by calculating "sales - (direct costs + indirect costs + selling and general administrative costs)" for each month. The calculation unit 35 also calculates the total amount of operating profit of "2.7 million yen" by adding up the operating profits from April to June. The display control unit 34 displays the operating profits for each month and the total amount calculated by the calculation unit 35 on the project-specific budget registration screen.
[0055] The memory control unit 34 stores such budget data on sales, direct costs, indirect costs, selling and general administrative expenses, and operating profits in the budget table 20 as budget data by project.
[0056] In this way, when the registration process of the direct project data and the project-specific budget data corresponding to the received project is performed, the data generating unit 33 registers the project number (P001) of the direct project data explained using Fig. 11 to the virtual project data stored in the virtual project table 21 as shown in Fig. 14 (step S14: updating process of the virtual project). This associates the virtual project with the direct project.
[0057] Next, the business management device 1 of the embodiment can select and display a forecast final outcome table by organization that does not reflect unassigned costs, which are labor costs per person that are not assigned to the project but are expected to occur in the future, or a forecast final outcome table by organization that reflects unassigned costs.
[0058] That is, when the business operator selects to display the organization-specific forecasted outcome table in a state where the unassigned cost is not reflected, the process proceeds to step S18 via step S15 (Yes) and step S16 (No) in the flowchart of Fig. 10. Then, the display control unit 36 generates and displays the organization-specific forecasted outcome table in a state where the unassigned cost is not reflected.
[0059] Specifically, Fig. 15 is a diagram showing an example of an organization-specific forecast table generated without reflecting unassigned costs. In this case, the storage control unit 34 registers the planned values, the total value of the planned values, and the forecasted values equivalent to the total amount of the planned values of sales, direct costs, overhead costs, selling and general administrative expenses, and operating profits for April to June, which are indicated in the project-specific budget data (see Fig. 13) stored in the budget table 20, in the organization-specific forecast table 22 in which the planned values of sales, direct costs, overhead costs, selling and administrative expenses, and operating profits described using Fig. 9 are stored.
[0060] The example of Fig. 15 is an example in which "2 million yen" is registered as the planned values of sales for April to June in the organization-specific forecast table 22 in which the forecast values of planned values of sales, direct costs, indirect costs, selling and general administrative costs, and operating profits explained using Fig. 9 are stored. Also, the example of Fig. 15 is an example in which "560,000 yen", "800,000 yen", and "800,000 yen" are registered as the planned values of direct costs for April to June in the above-mentioned organization-specific forecast table 22.
[0061] 15 is an example in which "200,000 yen", "200,000 yen", and "200,000 yen" are registered as the planned values of overhead for April to June, and "140,000 yen", "200,000 yen", and "200,000 yen" are registered as the planned values of selling and general administrative expenses in the above-mentioned organization-specific final forecast table 22. Also, in the example of FIG. 15, "1,100,000 yen", "800,000 yen", and "800,000 yen" are calculated by the calculation unit 35 as the planned values of operating profit for April to June, and are registered in the above-mentioned organization-specific final forecast table 22 by the memory control unit 34.
[0062] The display control unit 36 reads out the forecast values for sales, direct costs, indirect costs, selling and general administrative expenses, and operating profit registered in the forecasted outcome table by organization 22 in this manner, generates a forecasted outcome table by organization that does not reflect unassigned costs, and displays it on the output device 7.
[0063] On the other hand, when the business operator selects to display the organization-specific forecasted outcome table in a state where the unassigned costs are reflected, the process proceeds to step S17 via step S15 (Yes) and step S16 (Yes) in the flowchart of Fig. 10. Then, the display control unit 36 displays the organization-specific forecasted outcome table in a state where the unassigned costs are reflected.
[0064] Specifically, as shown in Fig. 16, the calculation unit 35 refers to the employee master 14 and detects the monthly average scheduled hours of each employee registered in the employee master 14, for example, Tanaka, Suzuki, and Sato. The calculation unit 35 also refers to the planned unit price master 12 and detects the hourly rates of Tanaka, Suzuki, and Sato. The calculation unit 35 then calculates "unassigned labor cost (unassigned cost)" by calculating "unassigned labor × monthly average scheduled hours × hourly rate."
[0065] Specifically, as shown in FIG. 12, Tanaka's planned labor in April is "0.7 man-months". Therefore, Tanaka's unassigned labor in April is "0.3 man-months" as shown in FIG. 16. In this case, the calculation unit 35 calculates Tanaka's unassigned cost in April by calculating "0.3 man-months x 160 hours x 5000 yen = 240,000 yen". Also, as shown in FIG. 12, Tanaka's planned labor in May and June is "1 man-month". Therefore, Tanaka's unassigned labor in May and June is "0 man-months" as shown in FIG. 16. In this case, the calculation unit 35 calculates Tanaka's unassigned cost in May and June by calculating "0 man-months x 160 hours x 5000 yen = 0 yen".
[0066] Also, the direct project that has been received at this point is project "P001" that has been received for April to June as shown in FIG. 11. Therefore, Tanaka's planned man-months from July to March of the following year are "0 man-months." Therefore, the calculation unit 35 calculates Tanaka's unassigned cost from July to March of the following year by calculating "1 man-month x 160 hours x 5,000 yen = 800,000 yen."
[0067] In contrast, Suzuki's hourly rate is "4,000 yen." Therefore, the calculation unit 35 calculates Suzuki's unassigned cost from April to March of the following year by calculating "1 person-month x 160 hours x 4,000 yen = 640,000 yen." Similarly, Sato's hourly rate is "3,000 yen." Therefore, the calculation unit 35 calculates Sato's unassigned cost from April to March of the following year by calculating "1 person-month x 160 hours x 3,000 yen = 480,000 yen."
[0068] Next, the calculation unit 35 adds up the unassigned costs for Tanaka, Suzuki, and Sato for each month as shown in Fig. 16, and calculates the total amount of the unassigned costs for each month. For example, the unassigned costs for Tanaka, Suzuki, and Sato in April are "240,000 yen," "640,000 yen," and "480,000 yen," respectively. Therefore, the calculation unit 35 calculates "240,000 yen + 640,000 yen + 480,000 yen" to calculate "a total of 1,360,000 yen" as the unassigned cost for April.
[0069] Furthermore, since Tanaka's unassigned costs for May and June are "0 yen," the calculation unit 35 calculates "0 yen + 640,000 yen + 480,000 yen" to calculate "a total of 1,120,000 yen" as the unassigned costs for May and June. Furthermore, since no direct project orders have been received from July to March of the following year at this point, the calculation unit 35 calculates "a total of 1,920,000 yen" as the unassigned costs for each month from July to March of the following year by calculating "800,000 yen + 640,000 yen + 480,000 yen."
[0070] Here, if there is no order for the project and the month ends in an unassigned state, the unassigned cost is recorded as an indirect cost rather than a direct cost related to the project, so the calculation unit 35 adds the unassigned cost to the planned value of the indirect labor cost (indirect cost) of the affiliated organization, as shown by the arrow in Figure 17.
[0071] That is, when the unassigned costs are not reflected, the planned overhead costs for April to June are "200,000 yen," "200,000 yen," and "200,000 yen," respectively, totaling "600,000 yen," as shown in Fig. 15. When the unassigned costs are reflected, the calculation unit 35 adds the unassigned costs for April to June calculated as above, "1,360,000 yen," "1,120,000 yen," and "1,120,000 yen," to the planned overhead costs of "200,000 yen," "200,000 yen," and "200,000 yen."
[0072] As a result, as shown in Figure 17, the planned values of overhead costs including unassigned costs for April to June can be obtained as "200,000 yen + 1,360,000 yen = 1,560,000 yen," "200,000 yen + 1,120,000 yen = 1,320,000 yen," and "200,000 yen + 1,120,000 yen = 1,320,000 yen." In addition, the planned value of overhead costs including unassigned costs for the period from July to March of the following year, when no project has been received, can be set to "0 yen + 1,920,000 yen = 1,920,000 yen."
[0073] The calculation unit 35 calculates the total amount of the planned overhead costs, including unassigned costs, from April to March of the following year (21.48 million yen in the example of FIG. 17), and sets this total amount as the expected final value of the planned overhead costs, including unassigned costs. The calculation unit 35 also calculates the planned operating profit by adding up the planned values of sales, direct costs, overhead costs, and selling and general administrative expenses. Specifically, the planned operating profit for April is calculated as "2 million yen + 560,000 yen + (-1.56 million yen) + 140,000 yen = -260,000 yen," and the planned operating profit for May and June is calculated as "2 million yen + 800,000 yen + (-1.32 million yen) + 200,000 yen = -320,000 yen." Then, the calculation unit 35 calculates a total planned operating profit of "-1.92 million yen" by adding up the planned operating profit values for April to June, and sets this "-1.92 million yen" as the expected landing value of the planned operating profit.
[0074] The storage control unit 34 stores the forecasted end values including such unassigned costs in the organization-specific forecasted end values table 22. The display control unit 36 reads out the forecasted end values of sales, direct costs, indirect costs, selling and general administrative expenses, and operating profits registered in the organization-specific forecasted end values table 22, and displays the organization-specific forecasted end values including the unassigned costs on the output device 7, as shown in FIG.
[0075] In this way, by incorporating unassigned costs into future costs by organization and displaying them, future unassigned costs can be understood without incurring administrative costs (reducing administrative labor). This makes it possible to improve the accuracy of forecast figures, which fluctuate daily, in business plans by organization.
[0076] Also, if there is no order for a project and the month ends with the project unassigned, the costs related to the project are recorded as indirect costs, not direct costs. For this reason, in the business management device 1 of the embodiment, the unassigned costs are added to the estimated indirect labor costs (indirect costs) of the organization to which the project belongs. This makes it possible to easily grasp the ratio of direct costs / indirect costs for each organization, and not only to evaluate whether the business plan for each organization has been achieved or not, but also to analyze whether the direct costs of each project are high and the sales profit margin is poor (= there are many labor-intensive projects with low profits) even in organizations with the same sales amount and operating profit, or whether the indirect costs are high and the profits of each project are high, but the operating profit is not efficiently obtained because the assignment is not performed appropriately.
[0077] To explain again using the example of Figure 3, in the case of the example of Figure 3, the actual sales value from April to June is "900,000 yen + 900,000 yen + 900,000 yen = 2.7 million yen." If the planned sales value from July to March of the following year, "1.1 million yen x 9 months = 9.9 million yen," is added to this actual value, the total amount and the expected value is "12.6 million yen." This expected value of "12.6 million yen" is because the initial planned sales value was "1 million yen x 12 months = 12 million yen," so the expected sales value as of June is "+600,000 yen," and sales are going well. In addition, the expected direct expenses as of June are "(400,000 yen x 3 months) + (550,000 yen x 9 months) = 6.15 million yen" compared to the initially planned "6 million yen," and expenses have been incurred by "150,000 yen" more than initially planned, but this can also be said to be approximately going well.
[0078] However, while the initial planned value for overhead was 200,000 yen x 12 months = 2.4 million yen, when the actual value of 100,000 yen x 3 months = 300,000 yen is added to the planned value of 300,000 yen x 9 months = 2.7 million yen, which is the sum of unassigned costs, the expected actual value becomes 3 million yen. This means that overhead costs will be 600,000 yen more than originally planned, and it can be said that the project is not progressing smoothly as planned.
[0079] In addition, due to this increase in indirect costs, selling and administrative expenses have also increased by 750,000 yen from the original plan ((100,000 yen x 12 months) - (200,000 yen x 3 months) + (150,000 yen x 9 months)).
[0080] And because of this, if unassigned costs are included, the expected operating profit as of June is 1.5 million yen, which is 900,000 yen less than the initial plan of 2.4 million yen.
[0081] If unassigned costs are not included, the planned overhead cost will be "200,000 yen" as shown in Figure 15, which is less than the planned overhead cost including unassigned costs of "300,000 yen." For this reason, if unassigned costs are not included, the expected final operating profit will be "2.4 million yen." Therefore, if unassigned costs are not included, it will be mistakenly believed that the profit will be as originally planned.
[0082] However, if unassigned costs are included, as described above, it is possible to reflect future indirect costs and associated selling and general administrative expenses, etc., resulting in an accurate forecast value, which makes it possible to review the project plan and take corrective measures such as reducing expenses.
[0083] (Project sales recording behavior) Next, Fig. 18 is a flow chart showing the flow of the registration process of the sales for the above-mentioned direct project. For example, as shown in Fig. 19, assume that the sales amount for April of the above-mentioned received direct project is 2.5 million yen, compared to the initially planned sales amount of 2 million yen. In this case, the business operator inputs the sales amount of 2.5 million yen. The data generation unit 33 generates sales data for the sales month of April, which is 2.5 million yen. The storage control unit 34 stores this sales data in the sales table 25 (step S21).
[0084] Next, the business operator inputs the direct costs, indirect costs, and selling and general administrative costs that were actually incurred in April, as shown in Fig. 20. The example in Fig. 20 is an example in which direct costs of "600,000 yen", indirect costs of "1.3 million yen", and selling and administrative costs of "200,000 yen" were incurred in April. The data generation unit 33 generates expense data for such direct costs, indirect costs, and selling and administrative costs incurred in April. The memory control unit 34 stores this expense data in the expense table 26 (step S22).
[0085] Next, when the display of the organization-specific forecast table is designated after the expense data is stored in the expense table 26 (step S23: Yes), the display control unit 36 displays the organization-specific forecast table shown in FIG. 21, which reflects the above-mentioned sales data stored in the sales table 25 and the above-mentioned expense data stored in the expense table 26 in step S24. In the example of FIG. 21, the above-mentioned "2.5 million yen" is reflected in the actual sales value for April, and "600,000 yen", "1.3 million yen", and "200,000 yen" are reflected in the direct costs, indirect costs, and selling and general administrative costs for April, respectively. The display control unit 36 reflects "2.5 million yen", "600,000 yen", "1.3 million yen", and "200,000 yen", which are the total amounts of the actual sales, direct costs, indirect costs, and selling and administrative costs at the time when the sales for April are recorded, in the organization-specific forecast table.
[0086] The calculation unit 35 also calculates a forecast value of "24.5 million yen" by adding the planned value of "2 million yen x 11 months = 22 million yen" to the actual value of "2.5 million yen" in sales. The display control unit 36 reflects this forecast value of "24.5 million yen" in the forecast sales value by organization table.
[0087] The calculation unit 35 also calculates "3.94 million yen" by adding "1.32 million yen", which is the planned value of overhead reflecting the unassigned cost for May, and "1.32 million yen", which is the planned value of overhead reflecting the unassigned cost for June, to "1.3 million yen", which is the actual value of overhead for April. The calculation unit 35 also calculates the total amount of the planned value of overhead reflecting the unassigned cost from July to March of the following year (1.92 million yen x 9 months = 17.28 million yen). Then, it calculates "3.94 million yen + 17.28 million yen" to calculate "21.22 million yen". The display control unit 36 displays this "21.22 million yen" in the organization-by-organization forecast table as the forecast value of the actual value of overhead.
[0088] The calculation unit 35 also adds the planned value of the selling and general administrative expenses for May, "200,000 yen," and the planned value of the selling and administrative expenses for June, "200,000 yen," to the actual value of the selling and administrative expenses for April, "200,000 yen," to calculate "600,000 yen." The display control unit 36 displays this "600,000 yen" in the forecasted end result table by organization as the forecasted end result value of the selling and administrative expenses.
[0089] In this example, the calculation unit 35 calculates "-400,000 yen" as the actual value of the operating profit for April by calculating "2.5 million yen - 600,000 yen - 1.3 million yen - 200,000 yen" based on the actual values of the sales, direct costs, indirect costs, and selling and general administrative expenses for April. The display control unit 36 displays this "-400,000 yen" in the forecasted performance table by organization as the forecasted performance value of the operating profit for April.
[0090] In this example, the calculation unit 35 calculates the forecast operating profit of "480,000 yen" by calculating "24.5 million yen - 2.2 million yen - 21.22 million yen - 600,000 yen" based on the forecast values of the actual values of sales, direct costs, indirect costs, and selling and general administrative expenses. The display control unit 36 displays this "400,000 yen" in the forecast operating profit by organization table as the forecast value of the actual value of operating profit.
[0091] (Operation when receiving a new project) Next, the operation of the business management device 1 of the embodiment when a new project is newly ordered will be described with reference to the flowchart in FIG. 22. As an example, when a new project with a contract amount of "8 million yen" and an order category of "inquiry" is newly ordered as shown in FIG. 23, the process proceeds from step S31 to step S32 in the flowchart in FIG. 22. When such a new project is newly ordered, the business operator inputs a department such as "System 1 Department", a contract amount such as "8 million yen", and an order category such as "inquiry" as shown in FIG. 23. The project number such as "P002" is automatically assigned by the business support device 1.
[0092] The business operator also inputs the expected sales month and expected sales amount of the new project as shown in Fig. 23. The example in Fig. 23 shows that, of the contract amount of "8 million yen," "4 million yen" is to be sold in May, and the remaining "4 million yen" is to be sold in June.
[0093] In response to such an input operation by the business operator, the data generation unit 33 generates the direct project data shown in Fig. 23. The storage control unit 34 stores this direct project data in the direct project table 19 (step S32).
[0094] Next, the personnel management registration process is performed, which is the process of assigning employees to be in charge of the May and June projects (step S33). Specifically, the business operator selects employees to be in charge of the May and June projects by referring to the employee master 14 and the planned unit price master 12 as shown in FIG. 24. The example in FIG. 24 is an example in which "Suzuki-san" has been selected as the person in charge of the May and June projects. The business operator also inputs the planned labor hours for May and June based on Suzuki-san's average monthly planned hours stored in the employee master 14. The example in FIG. 24 is an example in which "0.8 man-months" has been input as Suzuki-san's planned labor hours for May and June.
[0095] Based on the input of the business operator, the data generation unit 33 generates personnel management data including a project number such as "P002", an employee name such as "Suzuki", a month such as "May", and a planned labor force such as "0.8 man-months", as shown in FIG. 24.
[0096] 24, the calculation unit 35 detects Suzuki's monthly average scheduled hours (=160 hours) from the employee master 14, and also detects Suzuki's hourly rate (=4000 yen).Then, the calculation unit 35 calculates the direct costs for April and June by performing the following calculations.
[0097] May: 160 hours x 0.8 man-months x 4,000 yen = 512,000 yen June: 160 hours x 0.8 man-months x 4,000 yen = 512,000 yen
[0098] The storage control unit 34 stores the direct costs for May and June calculated in this manner in the personnel management table 23 in association with the personnel management data.
[0099] Next, as shown in FIG. 25, the business operator performs a process of registering the budget information for the direct project via the project-specific budget registration screen (step S34). Specifically, the business operator inputs, into this project-specific budget registration screen, the projected sales amounts of "4 million yen" as the projected sales amounts for May and June corresponding to the above-mentioned "8 million yen" direct project. The business operator also inputs, into the project-specific budget registration screen, "200,000 yen" as the monthly overhead costs for May and June, and "400,000 yen" as the total overhead cost amount. The business operator also inputs, into the project-specific budget registration screen, "200,000 yen" as the selling and general administrative expenses for May and June.
[0100] As explained using Figure 24, the monthly direct costs for May and June, which are "512,000 yen" respectively, and the total amount for each month (1,024,000 yen) are read from the personnel management table 23 by the memory control unit 34 and automatically entered into the case-specific budget registration screen.
[0101] Moreover, the calculation unit 35 calculates the operating profit for May as "2.96 million yen" and for June as "2.96 million yen" by calculating "sales - (direct costs + indirect costs + selling and general administrative costs)" for each month. The calculation unit 35 also calculates the total operating profit amount of "5.92 million yen" by adding up the operating profits for May and June. The display control unit 34 displays the operating profit for each month and the total amount calculated by the calculation unit 35 on the project-specific budget registration screen.
[0102] The memory control unit 34 stores such budget data on sales, direct costs, indirect costs, selling and general administrative expenses, and operating profits in the budget table 20 as budget data by project.
[0103] In this way, when the registration process of the direct project data and case-specific budget data corresponding to the received project is performed, the data generation unit 33 registers the project number (P002) of the direct project data explained using Fig. 23 to the virtual project data stored in the virtual project table 21 as shown in Fig. 26 (step S35: automatic reflection process to virtual project). As a result, the direct project with the project number "P001" received previously and the direct project with the project number "P002" received this time are respectively associated with the virtual project.
[0104] Next, the business management device 1 of the embodiment can select and display a forecast final outcome table by organization that does not reflect unassigned costs, which are labor costs per person that are not assigned to the project but are expected to occur in the future, or a forecast final outcome table by organization that reflects unassigned costs.
[0105] That is, when the business operator selects to display the organization-specific forecasted outcome table in a state where the unassigned costs are not reflected, the process proceeds to step S39 via step S36 (Yes) and step S37 (No) in the flowchart of Fig. 22. Then, the display control unit 36 generates and displays the organization-specific forecasted outcome table in a state where the unassigned costs are not reflected, which corresponds to the direct PJ with the project number "P001" stored in the budget table 20a and the direct PJ with the project number "P002" stored in the budget table 20b, as shown in Fig. 27.
[0106] Specifically, whether or not to reflect unassigned costs in the organization-specific forecast table can be selected on the extraction screen shown in Fig. 28. In the case of the business management device 1 of the embodiment, this extraction screen allows the user to specify a desired base date and department code, and select orders (include / exclude), inquiries (include / exclude), and unassigned costs (include / exclude). The example of the extraction screen in Fig. 28 is an example in which orders are selected as "include", inquiries as "include", and unassigned costs as "exclude".
[0107] In this way, when unassigned costs are not included, the display control unit 36 reflects the April sales, direct costs, indirect costs, selling and general administrative expenses, and operating profits of the direct project with the project number "P001" in the forecast table by organization as they are in the forecast table by organization. As a result, the planned value, expected value, and actual value of the sales in April in the forecast table by organization are displayed as "3 million yen", "2 million yen", and "2.5 million yen", respectively. In addition, the planned value, expected value, and actual value of the direct cost in April are displayed as "1.5 million yen", "560,000 yen", and "600,000 yen", respectively. The planned value, expected value, and actual value of the indirect cost in April are displayed as "500,000 yen", "1.36 million yen", and "1.3 million yen", respectively. In addition, the planned value, expected value, and actual value of the selling and administrative expenses in April are displayed as "500,000 yen", "140,000 yen", and "200,000 yen", respectively. The planned, estimated, and actual values for operating profit for April are displayed as "500,000 yen," "-260,000 yen," and "400,000 yen," respectively.
[0108] The calculation unit 35 also performs an addition process for the May sales, direct costs, indirect costs, selling and general administrative expenses, and operating profit of the direct project with the project number "P001" shown in Fig. 27, and the May sales, direct costs, indirect costs, selling and general administrative expenses, and operating profit of the direct project with the project number "P002". The display control unit 36 displays the sum of the May sales, direct costs, indirect costs, selling and general administrative expenses, and operating profit calculated in this way as the planned values of the May sales, direct costs, indirect costs, selling and general administrative expenses, and operating profit in the organization-specific forecast table as shown in Fig. 28. As a result, "6 million yen", "1.312 million yen", "400,000 yen", "400,000 yen", and "4.76 million yen" are displayed as the planned values of the May sales, direct costs, indirect costs, selling and general administrative expenses, and operating profit in the organization-specific forecast table, respectively.
[0109] Similarly, the calculation unit 35 adds the June sales, direct costs, indirect costs, selling and general administrative expenses, and operating profit of the direct project with the project number "P001" shown in Fig. 27 to the June sales, direct costs, indirect costs, selling and general administrative expenses, and operating profit of the direct project with the project number "P002" shown in Fig. 27. The display control unit 36 displays the added amounts of the June sales, direct costs, indirect costs, selling and general administrative expenses, and operating profit calculated in this way as the planned values of the May sales, direct costs, indirect costs, selling and general administrative expenses, and operating profit in the organization-specific forecast table as shown in Fig. 28. As a result, "6 million yen", "1.312 million yen", "400,000 yen", "400,000 yen", and "4.76 million yen" are displayed as the planned values of the June sales, direct costs, indirect costs, selling and general administrative expenses, and operating profit in the organization-specific forecast table, respectively.
[0110] The calculation unit 35 also calculates a forecast value of "14.5 million yen" by adding the planned value of sales for May, "6 million yen," and the planned value of sales for June, "6 million yen," to the actual value of sales for April, "2.5 million yen." The display control unit 36 displays this forecast value of "14.5 million yen" in the forecast value of sales by organization table.
[0111] The calculation unit 35 also calculates a forecast value of "3,224,000 yen" by adding the planned value of direct costs for May, "1,312,000 yen," and the planned value of direct costs for June, "1,312,000 yen," to the actual value of direct costs for April, "600,000 yen." The display control unit 36 displays this forecast value of "3,224,000 yen" in the forecast value of direct costs by organization table.
[0112] The calculation unit 35 also adds the planned overhead cost value for May, "400,000 yen," and the planned overhead cost value for June, "400,000 yen," to the actual overhead cost value for April, "1.3 million yen," to calculate a forecasted overhead cost value of "2.1 million yen." The display control unit 36 displays this forecasted overhead cost value of "2.1 million yen" in the forecasted overhead cost value by organization table.
[0113] The calculation unit 35 also calculates a forecast value of "1 million yen" by adding the planned value of the selling and general administrative expenses for May, "400,000 yen", and the planned value of the selling and administrative expenses for June, "400,000 yen", to the actual value of the selling and administrative expenses for April, "200,000 yen". The display control unit 36 displays this forecast value of "1 million yen" in the forecast value of selling and administrative expenses by organization table.
[0114] The calculation unit 35 also subtracts the forecast values of the actual values of direct expenses, indirect expenses, and selling and general administrative expenses from the forecast value of the actual value of sales (14.5 million yen-3.224 million yen-2.1 million yen-1 million yen) to calculate a forecast value of "8.176 million yen." The display control unit 36 displays this forecast value of "8.176 million yen" in the forecast value by organization table as the forecast value of the actual value of operating profit.
[0115] On the other hand, when the business operator selects to display the organization-specific forecasted outcome table in a state where the unassigned costs are reflected, the process proceeds to step S38 via step S36 (Yes) and step S37 (Yes) in the flowchart of Fig. 22. Then, the display control unit 36 displays the organization-specific forecasted outcome table in a state where the unassigned costs are reflected.
[0116] Specifically, as shown in FIG. 29, the calculation unit 35 refers to the employee master 14 and detects the monthly average scheduled hours of each employee registered in the employee master 14, for example, Tanaka, Suzuki, and Sato. The calculation unit 35 also refers to the scheduled unit price master 12 and detects the hourly rates of Tanaka, Suzuki, and Sato. The calculation unit 35 then calculates "unassigned labor cost (unassigned cost)" for May and June by calculating "unassigned labor × monthly average scheduled hours × hourly rate." The unassigned costs for April and July to March of the following year have already been calculated when the direct project with project number "P001" was accepted (see FIG. 16).
[0117] Since Mr. Tanaka's unassigned man-hours for May and June are "0 man-months" as described above, the calculation unit 35 calculates "0 yen" as the unassigned costs for May and June, respectively.
[0118] As shown in FIG. 24, Suzuki's planned man-hours for May and June are "0.8 man-months", so the unassigned man-hours are "0.2 man-months". Therefore, the calculation unit 35 calculates "0.2 man-months x 160 hours x 4,000 yen" to calculate Suzuki's unassigned cost for May and June as "128,000 yen". Furthermore, Suzuki's planned man-hours from July onwards are "0 man-months", so the unassigned man-hours are "1 man-month". Therefore, the calculation unit 35 calculates "1 man-month x 160 hours x 4,000 yen" to calculate Suzuki's unassigned cost for July onwards as "640,000 yen".
[0119] Mr. Sato's planned labor for May and June is "0 man-month," so the unassigned labor is "1 man-month." Therefore, the calculation unit 35 calculates "1 man-month x 160 hours x 3,000 yen" to calculate "480,000 yen" as Mr. Sato's unassigned cost for May and June. Furthermore, Mr. Suzuki's planned labor from July onwards is also "0 man-month," so the unassigned labor is "1 man-month." Therefore, the calculation unit 35 calculates "1 man-month x 160 hours x 3,000 yen" to calculate "480,000 yen" as Mr. Suzuki's unassigned cost for July onwards.
[0120] Next, the calculation unit 35 calculates the total amount of unassigned costs by adding up the unassigned costs of Tanaka, Suzuki, and Sato for each month, as shown in FIG. 29. In the example of FIG. 29, the unassigned costs for Tanaka, Suzuki, and Sato for May are "0 yen", "128,000 yen", and "480,000 yen", respectively, so the calculation unit 35 adds them up and calculates "608,000 yen" as the unassigned cost for May. Similarly, the unassigned costs for Tanaka, Suzuki, and Sato for June are "0 yen", "128,000 yen", and "480,000 yen", respectively, so the calculation unit 35 adds them up and calculates "608,000 yen" as the unassigned cost for June. The total amount of unassigned costs for each month from July onwards, when no project orders have been received at this point, is "1,920,000 yen" as described above.
[0121] Next, Fig. 30 shows an example of the above-mentioned extraction screen in which the display of the organization-specific forecast table including the unassigned cost is specified, and an example of the organization-specific forecast table reflecting the unassigned cost. The storage control unit 34 stores the forecast value including the above-mentioned unassigned cost in the organization-specific forecast table 22. The display control unit 36 reads out the forecast values of sales, direct costs, indirect costs, selling and general administrative expenses, and operating profit registered in the organization-specific forecast table 22, and displays the organization-specific forecast table including the unassigned cost on the output device 7 as shown in Fig. 30.
[0122] Specifically, the calculation unit 35 calculates "1,008,000 yen" as the planned value of overhead for May by adding the unassigned cost of "608,000 yen" for May described using Figure 29 to "400,000 yen (see Figure 28)", which is the planned value of overhead for May. Similarly, the calculation unit 35 calculates "1,008,000 yen" as the planned value of overhead for June by adding the unassigned cost of "608,000 yen" for June described using Figure 29 to "400,000 yen (see Figure 28)", which is the planned value of overhead for June.
[0123] The display control unit 36 displays "1,008,000 yen" reflecting the unassigned costs as the planned overhead costs for May and June in the organization-specific forecasted outcome table, as shown in Fig. 30. The display control unit 36 also displays "1,920,000 yen (see Fig. 29)" calculated by reflecting the unassigned costs as the planned overhead costs for July and onward in the organization-specific forecasted outcome table.
[0124] The calculation unit 35 also adds "1,008,000 yen", which is the planned value of the overhead for May, and "1,008,000 yen", which is the planned value of the overhead for June, to "1,300,000 yen", which is the actual value of the overhead. The calculation unit 35 also calculates "1,920,000 yen x 9 = 17,280,000 yen", which is the planned value of the overhead for a total of nine months from July to March of the following year. Then, by performing the calculation of "1,300,000 yen + 1,008,000 yen + 1,008,000 yen + 17,280,000 yen", it calculates "20,596,000 yen" as the expected value of the actual value of the indirect value. The display control unit 36 displays this "20,596,000 yen" in the organization-by-organization expected value table as the expected value of the actual value of the indirect value reflecting the unassigned cost.
[0125] The calculation unit 35 also subtracts the actual direct cost value of "3.48 million yen", the actual indirect cost value of "20.596 million yen", and the actual selling and general administrative expenses value of "1 million yen" from the actual sales value of "14.5 million yen" to calculate a forecast operating profit value of "-10.576 million yen". The display control unit 36 displays this "-10.576 million yen" in the forecasted operating profit value by organization table as the forecast operating profit value reflecting the unassigned costs.
[0126] (Effects of the embodiment) As is clear from the above explanation, the business management device 1 of the embodiment incorporates the unassigned cost into the future cost by organization and displays it, so that the future unassigned cost can be grasped without incurring administrative costs (reducing administrative labor). This makes it possible to improve the accuracy of the final forecast figures, which fluctuate daily, in the business plans by organization.
[0127] Also, if there are no orders for projects and the month ends with no assignments, they are recorded as indirect costs, not direct costs related to the project. For this reason, the unassigned costs are added to the planned indirect labor costs (indirect costs) of the organization to which the project belongs. This makes it easy to understand the ratio of direct costs to indirect costs by organization, and not only can it be used to evaluate whether the business plans of each organization have been achieved or not, but it is also possible to analyze whether, even in organizations with the same sales amount and operating profit, the direct costs of each project are high and the sales profit margin is poor (= there are many labor-intensive projects with low profits), or whether the indirect costs are high and the profits of each project are high, but the assignment is not done properly, so operating profits cannot be obtained efficiently.
[0128] [Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, and can therefore contribute to Goals 8 and 9 of the SDGs.
[0129] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of Goals 12, 13, and 15 of the SDGs.
[0130] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.
[0131] [Other embodiments] The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.
[0132] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.
[0133] In addition, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.
[0134] Moreover, with regard to the service management device 1, the components shown in the figures are merely conceptual functional components, and the device does not necessarily have to be physically configured as shown in the figures.
[0135] For example, the processing functions of the service management device 1, particularly the control unit 3 and each processing function performed by the control unit 3, may be realized in whole or in part by a CPU (Central Processing Unit) and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded on a non-transient computer-readable recording medium including programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the service management device 1 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD. This computer program is executed by being loaded into a RAM, and constitutes the control unit 3 in cooperation with the CPU.
[0136] In addition, the service management program of this service management device 1 may be stored in another server device connected to the service management device 1 via any network, and it is also possible to download all or part of it as needed.
[0137] The business management program for executing the process described in the present embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical Disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.
[0138] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that achieves its function by working with a separate program, such as an OS. Note that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading a recording medium in the business management device 1 shown in the embodiment, as well as the installation procedure after reading.
[0139] The memory unit 2 is a storage means such as a memory device such as RAM or ROM, a fixed disk device such as a hard disk, a flexible disk, or an optical disk, and stores various programs, tables, databases, and web page files used for various processes and providing websites.
[0140] The service management device 1 may be configured as an information processing device such as a known personal computer device or a workstation, or may be configured as an information processing device connected to any peripheral device. The information processing device may be realized by implementing software (including programs or data, etc.) that realizes the processing described in this embodiment.
[0141] Furthermore, the specific form of distribution and integration of the devices is not limited to those shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or function additions. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]
[0142] The present invention is useful for, for example, operations in the IT (Information Technology) media industry that provide system engineering services. [Explanation of symbols]
[0143] 1 Business management device 2 Storage section 3. Control Unit 4. Communication Interface Section 5 Input / Output Interface Section 6 Input Devices 7 Output Devices 11 Cost Element Master 12 Planned Unit Price Master 13 Department Master 14 Employee Master 15 Cost Component Table 16 Planned unit price table 17 Department Table 18 Employee Table 19 Direct PJ Table 20 Budget Table 21 Virtual PJ Table 22 Organization-specific Landing Forecast Table 23 Personnel Management Table 24 Unassigned Table 25 Sales Table 26 Expense Table 31 Master setting section 32 Input Processing Section 33 Data Generation Division 34 Memory control unit 35 Arithmetic section 36 Display control section
Claims
1. A tentative schedule value generating unit that generates a tentative schedule value, which is a schedule value before adding unassigned costs, of the costs input by a business operator as the costs for a specified period for a case; an unassigned cost calculation unit that calculates an unassigned cost, which is an expense not assigned as an expense for the case, by multiplying an unassigned labor-time, which is a value obtained by subtracting a planned labor-time in the predetermined period, by a monthly average planned time, and multiplying the result by an hourly rate; a planned value generating unit that generates a value obtained by adding the tentative planned value and the unassigned cost as a planned value of the cost for a predetermined period of the project; a forecasted cost calculation unit that calculates a total value of the actual cost value determined in the specified period and the planned cost value after the actual cost value is determined as a forecasted cost value corresponding to the planned cost value for the entire period; an output control unit that outputs the estimated landing value corresponding to the scheduled cost value; A landing prediction value management device having the above-mentioned.
2. The estimated value calculation unit calculates the estimated value as a total value of the planned values of the expenses for each predetermined period stored in the storage unit, and as an estimated value corresponding to the planned value of the expenses for the entire period before the actual value occurs; The output control unit outputs the predicted landing value corresponding to the scheduled value of the cost and the predicted landing value corresponding to the planned value of the cost; 2. The landing prediction value management device according to claim 1,
3. the forecasted landing value calculation unit calculates the forecasted landing value for each group in charge of the case; 3. The landing prediction value management device according to claim 1 or 2, characterized in that
4. the estimated value calculation unit calculates the estimated values corresponding to the sales, direct costs, indirect costs, selling and administrative expenses, and operating profit of the project, respectively; the provisional schedule value generating unit generates the provisional schedule value based on an input of the overhead by the business operator; The unassigned cost calculation unit calculates unassigned costs corresponding to the overhead by multiplying the unassigned labor, which is a value obtained by subtracting the planned labor force in the predetermined period, by a monthly average planned time, and multiplying the result by an hourly rate; the planned value generating unit generates a value obtained by adding the tentative planned value of the overhead and the unassigned cost of the overhead as the planned value of the overhead; The landing prediction value management device according to any one of claims 1 to 3,
5. The estimated landing value calculation unit calculates the estimated landing value after adding the unassigned cost and the estimated landing value without adding the unassigned cost, the output control unit outputs a selected one of the forecasted landing value to which the unassigned cost has been added and the forecasted landing value to which the unassigned cost has not been added; 5. The landing prediction value management device according to claim 1, wherein:
6. a tentative schedule value generating step in which a tentative schedule value generating unit generates a tentative schedule value, which is a scheduled value before adding an unassigned cost, of the cost input by the business operator as the cost for a predetermined period for the case; an unassigned cost calculation step in which an unassigned cost calculation unit multiplies an unassigned labor-time, which is a value obtained by subtracting a planned labor-time in the predetermined period, by a monthly average planned time, and multiplies the result by an hourly rate to calculate an unassigned cost, which is a cost not assigned as a cost for the project; a planned value generating step in which a planned value generating unit generates a value obtained by adding the tentative planned value and the unassigned cost as a planned value of the cost for a predetermined period of the project; a forecasted cost calculation step in which a forecasted cost calculation unit calculates a total value of the actual cost value determined in the predetermined period and the planned cost value after the actual cost value is determined as a forecasted cost value corresponding to the planned cost value for the entire period; an output control step in which an output control unit outputs the estimated landing value corresponding to a scheduled value of the cost; A landing forecast value management method having the above-mentioned feature.
7. Computer, a tentative planned value generating unit that generates a tentative planned value, which is a planned value before the addition of unassigned costs, of the costs input by the business operator as the costs for a predetermined period for the case; an unassigned cost calculation unit that calculates an unassigned cost, which is an expense not assigned as an expense for the case, by multiplying an unassigned labor-time, which is a value obtained by subtracting a planned labor-time in the predetermined period, by a monthly average planned time, and multiplying the result by an hourly rate; a planned value generating unit that generates a value obtained by adding the tentative planned value and the unassigned cost as a planned value of the cost for a predetermined period of the project; a forecasted cost calculation unit that calculates a total value of the actual cost value determined in the specified period and the planned cost value after the actual cost value is determined as a forecasted cost value corresponding to the planned cost value for the entire period; functioning as an output control unit that outputs the estimated landing value corresponding to the scheduled cost value; A landing forecast management program that features:
Citation Information
Patent Citations
Estimation method and system for settlement of accounts using computer and computer readable recording medium recording settlement-of-accounts estimation program
JP1999259562A
Processing method of management accounting type financial accounting system
JP2001109834A
System for creating materials for business plan
JP2002215865A
System, program, and recording medium for household budget management
JP2007257145A
Budget / result management support system and budget / result management support method
JP2008158600A