JP2007004386A - Business management program and management device using the same - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a program for executing the unitary management of data relating to a necessary personnel who is in charge of a property value on business, and for performing a summarization operation on the basis of the latest data relating to the necessary personnel when requesting data for management. <P>SOLUTION: This program is configured: to make a first function 72 manage project identification information for identifying a business and group identification information showing a business execution group by associating them with each other; to make a second function 73 manage the group identification information and the necessary personnel identification information for executing the business by associating them with each other; to make a third function 74 always accept the input of the result man-hours of each necessary personnel, and manage the result man-hours and the necessary personnel identification information by associating them with each other; and to make a summarization managing function 71 read the result man-hours cooperatively with the first function, the second function and the third function on the basis of the project identification information, the group identification information or the necessary personnel identification information according to an organization range with management items as a target, and perform summarization operation corresponding to the prescribed management items when receiving the request of data for management. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to a business management program for grasping a business activity status and a management apparatus using the business management program. In particular, we always manage changes in property value or production status of property value per employee (person) who is the subject of business activities, and the activity status at that time is the organizational unit or personnel unit for each business operation. The present invention relates to a program and a device that can be aggregated and calculated and provided quickly.

  In general, the object of managing the activity status of a business is to generate property value, and the movement of a person who carries out the business, or the movement of an object (for example, a product) that is a business object can be considered. For example, the former may be the actual work status of the personnel responsible for production, and the latter may be the production status of the product or the operating status of the rental product. Sometimes say "personnel").

  Conventionally, the actual work time and the scheduled time of the worker responsible for the business (hereinafter, the work time is referred to as “man-hour”, the actual work time is referred to as “actual man-hour”, and the planned work man-hour is referred to as “scheduled man-hour”. There is a project management system (see Patent Document 1) that records a progress status for each project, each process, and each worker. The technology of Patent Document 1 is (a) a function for inputting data such as work process and work time for each individual, and (b) progress for each project, each process and each worker composed of the input data. Search and provide a list of situations. Further, (c) calculating the work man-hour consumption rate and the work completion rate from the input data, and providing it as a progress status list.

  In general, when managing the movement of a person responsible for the property value at an office, the viewpoint of managing the property value is not limited to man-hours, When there is a relationship between the work and cost and sales, a profit and loss settlement (financial management), or a relationship with working hours (labor management), etc. It is desirable to obtain the latest one immediately at that time. It is desirable to obtain reliable data. However, even if it tries to utilize the thing of patent document 1 for such a purpose, it is difficult. That is, according to Patent Document 1, as individual input data, a personal code, a work classification, a work number code, and a work time are input in a format called an individual work daily report. However, how can I calculate the progress list by calculating these values? How does the search function search? There are some points that cannot be understood.

  The technique of Patent Document 1 shows the status of business activities that generate property value in terms of man-hours. As a technique for displaying this in terms of cost or the like, there is a technique shown in Patent Document 2. However, the technique of Patent Document 2 requires actual costs after completing the production process, and is not appropriate for cost management in the production process.

JP 2000-187684 A Japanese Patent Laid-Open No. 10-171852

  Generally, in managing the property activities of a business, it is desirable to manage the personnel responsible for the activities from multiple viewpoints so that appropriate activities can be supported. Management from multiple viewpoints, process management, sales management, financial management, labor management, etc., each of them specializes in managing data, or managing each with individual computers, lacks data integrity and is the latest It is inconvenient that it is difficult to obtain the data, it may be unreasonable that the management work may be doubled, the management system may differ between departments, and the reliability may be questioned.

  The object of the present invention is to centrally manage data related to personnel responsible for business property value, and to provide aggregated calculations each time based on the latest data (data related to personnel) when requesting management data Provide a configuration program. Furthermore, a program that can perform multifaceted viewpoints such as man-hour progress management, cost management, or attendance management is provided.

  In order to achieve the above object, the present invention is configured with the following concept. In other words, the organization of general business is divided according to the division of work roles, for example, multi-layered labor organization (business organization divided into departments) such as business divisions, departments, sections, groups, workers, etc. In order to meet market demands, for example, a business project (project) of a specific product, a group that manufactures and manages the product (eg, production number management), and a multi-layered project organization such as workers who compose the group Yes, project organizations tend to exist on top of labor organizations. That is, the project organization tends to exist in response to resources from the labor organization, and the project organization and the labor organization may or may not match. However, in both organizations, it is common that the minimum unit to be managed is a unit for executing a business or project is a worker (person in charge). That is, it is important that an operator's activities and actions affect the value of the business (property value), and that the activity of the worker and / or the management of the value of the activity is important. Hereinafter, such a worker (person in charge) is referred to as “personnel”. Therefore, in the present invention, for example, business data (such as actual man-hours, etc.) related to the activities and movements of personnel at all times, for example, is associated with the identification information of the person in charge. And store and manage the information and information of higher-level organizations, for example, the relationship between groups and projects. When there is a request for management data, the latest business data for each person is searched based on these links, and the total calculation is performed each time. The reason for calculating each time is to calculate based on the latest business data. For this reason, the revision of business data is prohibited.

  Here, the main meaning or usage of main terms used will be described. “Project information” is information including project identification information, and other information including information that is common to a group that constitutes a project or that cannot be assigned to a group. The “group information” includes group identification information, and may include other information that is common to the personnel constituting the group or that cannot be allocated to the personnel. “Unit cost per man-hour” (hereinafter referred to as “unit cost”) is the cost per unit man-hour allocated, and the project is still in progress. Determined and allocated. “Unit selling price per man-hour” (hereinafter referred to as “unit selling price”) is the selling price per unit man-hour allocated to each person, for example, determined based on the selling price set for the product related to the project. Allocated. The “expense” is an expense that is not allocated to personnel, for example, required for maintaining a process in a group unit. “Processing cost” is the cumulative total of actual man-hours when actual work is performed by personnel, converted into monetary amounts at unit cost. “Scheduled sales” is the cumulative total of actual man-hours by personnel, converted into monetary amounts at unit selling prices. “Secondary cost” includes at least processing costs and expenses. “Management item” indicates, for example, the type of project to be managed, the group's secondary cost and selling price, the actual and planned man-hours by personnel, or the type of work to be managed or evaluated, such as working hours vs. actual man-hours by section. . “Attendance time” is, for example, the time in the company (time restricted by the management of the company) in the case of a company. The “actual work rate” is the ratio of actual man-hours to working hours.

  In order to solve the above-mentioned problem, as a specific means, the invention according to claim 1 relates the project information including the project identification information for identifying the business and the group identification information representing the business execution group under the project. A first function (72) that is managed, a second function (73) that manages the group information including the group identification information in association with the personnel identification information of a person who performs the business, and a business action by each individual person A third function (74) that constantly receives input of a period representing the actual man-hour and the actual man-hour and associates the actual man-hour with the personnel identification information, and requests management data for a desired period of a specific management item And a request receiving function (70) for receiving the project identification information according to a range targeted by the specific management item when the request is received. Based on the loop identification information or the personnel identification information, the actual man-hours of the desired period are read out in cooperation with the first function, the second function, the third function, or a combination thereof, and the totals according to the specific management item The computer is configured to execute a function including a total management function (71) for performing calculation.

  According to a second aspect of the present invention, in the first aspect of the invention, the first function is a project-specific information that exceeds the first link information and the business execution group for linking the project identification information and the group identification information. The second function is configured to separately manage the second link information for linking the group identification information and the personnel identification information and the group information specific to the business execution group.

  According to a third aspect of the present invention, in the first or second aspect of the present invention, the claim acceptance function accepts a request for management data for a desired aggregation period related to the progress of a business action as the specific management item. When the progress is a progress in the project, the total management function is in the order of the first function, the second function, and the third function, and in the case of the progress in an individual group, the order is the second function and the third function. In the case of progress in individual personnel, link directly to the third function, read the actual man-hours of the desired period, and based on the actual man-hours, the cumulative results for the bill by project, group or by personnel The man-hours are calculated and calculated.

  The invention according to claim 4 is the invention according to claim 3, wherein the third function determines the actual man-hours of the accepted personnel for each predetermined time, and makes it impossible to edit the confirmed man-hours, For the confirmed man-hours, an edit restriction function (74a) is provided for managing the man-hours accumulated for each person so as to be provided to the tabulation management function.

The invention according to claim 5 is the invention according to claim 3 or 4, wherein the third function manages a unit cost and a unit selling price per man-hour for each person,
Based on the accumulated actual man-hours and unit cost or unit selling price, the totaling calculation function further calculates the processing cost, the sales amount, or both according to the scope of the claim by project, group, or personnel. The configuration.

The invention according to claim 6 is the invention according to claim 1, 2, or 3, further accepting an input of expenses required for the project or group business activities by the personnel, and the expenses are regarded as the group identification information. The fifth function (75) for managing and associating
The third function manages the unit cost and unit selling price per man-hour for each personnel.
When the billing reception function accepts a request for cost management data as a specific management item, the tabulation calculation function reads and tallies the expenses of the corresponding group from the second function and the fourth function, From the function and the third function, the processing cost is calculated based on the actual man-hours and the unit cost for the corresponding personnel, and the secondary cost is calculated as the cost management data based on the calculated cost and processing cost. The configuration.

  The invention according to claim 7 is the invention according to any one of claims 1 to 6, wherein the higher organization identification information of the higher organization in the business organization consisting of a plurality of organizational layers, the intermediate organization belonging to the higher organization An organization information management function (77) for associating the organization identification information, the organization identification information of the subordinate organization belonging to the intermediate organization, and the personnel identification information of the personnel belonging to the subordinate organization in association with each other. Further, the third function always accepts and manages the input of the attendance time of the personnel in addition to the actual man-hours representing the time when the personnel performed the business act, and the claim acceptance function is managed by the organization to be managed. When the request for the actual working rate of the layer is received, the total calculation means calculates the request from the actual man-hours and attendance hours for each person of the third function, and the identification information of each organizational layer in the organizational information management function. Depending on the tissue layers of the managed upper tissue-specific, medium Org, lower tissue-specific, was calculated configured to output a production rate in any of a range of personnel by or combinations thereof.

  In the invention according to claim 8, the upper organization identification information of the upper organization in the business organization consisting of a plurality of organization layers, the intermediate organization identification information of the intermediate organization belonging to the upper organization, and the lower organization belonging to the intermediate organization In addition to the organization information management function (77) for associating the lower-level identification information and the personnel identification information of the personnel belonging to the lower-level organization and managing it as organizational information, and the actual man-hours representing the time when the personnel performed the business action, An information management function (74) for each employee that always accepts the input of the attendance time of the personnel, stores and manages the personnel identification information, the actual man-hours and the attendance time in association with each other, and the actual operation of the organization layer to be managed Claim acceptance function (70) that accepts a charge for rate, and when the claim acceptance function receives the claim, the actual man-hours and attendance hours for each person in the information management function for each person, and the organization information management function Based on the identification information of each organizational layer, the actual work rate in the range of either the upper organization, the middle organization, the lower organization, the personnel, or a combination thereof according to the organization layer to be managed in the claim. The computer is configured to execute a function including a calculation function (71) for calculating and outputting.

  The invention according to claim 9 is a project information management means (72) for managing project information including project identification information for identifying a business in association with group identification information representing a business execution group under the project, and the group Group information management means (73) for managing the group information including the identification information in association with the personnel identification information of the personnel executing the business, and always accepting the input of the period representing the business action by the individual personnel and the actual man-hours. A personnel information management means (74) for managing the actual man-hours and the personnel identification information in association with each other, a bill reception means (70) for accepting a request for management data for a desired period related to a specific management item, When receiving the request, the project identification information, the group identification, and the like according to the range covered by the specific management item. Based on the information or the personnel identification information, the actual man-hours of the desired period are read out in cooperation with the first function, the second function, the third function, or a combination thereof, and an aggregation calculation according to the specific management item is performed. And a totaling management means (71) to perform.

  According to the first and second aspects of the invention, when management data is requested, business data such as actual man-hours as originally entered is used (except for bibliographic processing, which is not secondary processed) Since it is calculated (using original data), there is reliability that the latest data can be obtained. Further, for example, when the group management data is requested, the search processing is quick because the business data for each person is accessed by linking from the group information. As a result, the latest data can be obtained quickly, so that data with high real-time characteristics can be viewed. In addition, since the data structure is composed of large organizations (eg, projects), medium organizations (groups: may be divided into multiple layers) and unit organizations, the management of each type of business organization with a multi-layer structure Applicable to.

  According to the invention of claim 2, since there is a function for linking each layer to the function for each layer and there is a function for reading the information from the upper layer, it is possible to search while narrowing down the range for reading the business data. Can do.

  According to the inventions of the fourth, fifth, sixth and seventh aspects, the progress of the process and the transition of the cost can be managed. According to the invention of claim 8, attendance management can be performed. Furthermore, according to the invention described in claim 9, since it has a structure in which various types of data are concentrated and collectively managed in the business data for each person and the business data is easily accessible, The management of each management item that has individually dealt with matters and projects can be systematized in a centralized manner.

  According to the invention of claim 4, since the business data after confirmation is made uneditable, the reliability of the data is improved. In addition, since it is possible to aggregate the business data that has been determined to be non-editable, if business data that has been confirmed in the period is included at the time of billing, it can be calculated using the aggregated business data, thus speeding up the process. it can.

  A form in which the embodiment according to the present invention is applied to a project-like organization that operates based on the above-mentioned business plan is referred to as “Embodiment 1”. A form applied to organization management will be described in “Embodiment 2”. Furthermore, it will be explained in “Embodiment 3” that both management of a project organization and management of a labor organization are possible.

Description will be made based on the drawings of the embodiments according to the invention. FIG. 1 is a diagram for explaining an embodiment of the present invention. In FIG. 1, functional blocks representing a part according to the invention as a data management server 7 for business management including production are shown. Each function of the data management server 7 represents a representative function of the management program according to the present invention. FIG. 2 is a diagram showing a hardware configuration of the data management server 7 of FIG. FIG. 3 is a diagram showing an outline of the data structure handled by each means (function) of the data management server 7 of FIG. FIG. 4 is a diagram showing an operation flow for generating management data indicating the progress status. FIG. 5 is a diagram showing an operation flow for generating a cost accounting document. FIG. 6 is a diagram showing functional blocks of the data management server 7 when attendance management is performed. FIG. 7 is a diagram showing an outline of the data structure in the functional block of FIG. FIG. 8 is a diagram showing a calculation result obtained from the actual working rate. FIG. 9 and FIG. 10 are diagrams illustrating an example in which the processing cost and the cost rate are calculated and calculated for each manpower and each product number based on the actual man-hours and the planned man-hours.
Hereinafter, description will be made based on these drawings.

“Embodiment 1”
FIG. 1 is a diagram in a case where the present invention is applied to a management apparatus for business management including production. As for the business, a business for producing and selling is generated as a project, and a plurality of production groups A and B (manufacturing numbers representing different manufacturing processes are assigned respectively) for managing a plurality of manufacturing processes under the project. In addition, there is a management group common to the groups A and B including the sales department and the finance department. Each group is made accessible to the data management server 7 via the intranet by a terminal included in each group.

  The production groups A and B and the management group include browsing terminals 1, 3, 5 (hereinafter referred to as “browsing terminal” when there is no need to distinguish) and personal terminals 2, 4 (hereinafter, when there is no need to distinguish between them). Is referred to as “personal terminal”), and the management terminal 6 is arranged, but the personal terminal is used for the personnel of the process to input the business data by personnel such as the work date, the work process, and the actual man-hours. . The management terminal 6 is a terminal for inputting data generated in production groups A and B such as data to be allocated to personnel such as unit selling price and unit cost, which will be described later, or expense data. The browsing terminal is a terminal for each administrator to charge the management data to the data management server 7 and browse. The browsing terminal, the personal terminal, and the administrator terminal 6 are all configured by a computer, and their names are categorized schematically for the sake of explanation and can also be used together. In the case of sharing, the function is switched by changing the login name or changing the program to be started. By doing so, a special terminal can be made unnecessary.

  The data management server 7 shows the function of the management program according to the present invention. The management program is divided into Web application software that constitutes a function and data portions handled by the function (for example, each database in FIG. 1). FIG. 1 is a functional representation of these together. Hereinafter, the function of the data management server 7 will be described based on the functional block of FIG. 1 and the data structure of FIG.

  The following embodiment shows an example in which a project is a plan for production / sales, and a group in which production is executed is assigned and managed by a product number (identification information for specifying a production process for the project). Therefore, hereinafter, the above group is referred to as a product number, and the group ID is referred to as a product number ID. However, this is not the case in the case of the explanation with an emphasis on the organizational structure like the production groups A and B in FIG.

  The project information management means 72 (first function) identifies the identification information for each project (hereinafter referred to as “project ID”) and information that is common to the group that constitutes the project or that cannot be assigned to the product number. The information is stored and managed as a PR database so that it can be searched by the user. Further, the project ID and the production number identification information (production number ID) for executing the project are linked and managed by having a link table A (may be put together in the PR database). (Although it may be included, it will be described in a separate configuration below.) In FIG. 3, the project information includes contract conditions with the customer such as the start date (order date, planning start date, production decision date, etc.), delivery date (or in-house completion date), or the conditions planned in-house. The contents of the contents are included. Customer identification information (customer ID), production quantity, planned selling price (per unit), planned cost (per unit), or the like may be input.

  The production number (group) information management means 73 (second function) includes a production number ID indicating a group for executing the project, a lower organization that bears the production number, a lower organization, and a personnel if the personnel belongs directly. (In the following description, it is assumed that personnel are assigned to product numbers), or information that cannot be assigned is stored and managed as a product number database so that it can be searched by product number ID as product number information. ing. Further, the production number ID and the personnel identification information (hereinafter referred to as “personnel ID”) of the person who is in charge of executing the project are linked to link table B (may be put together in the production number database). (It may be included in the product number information, but will be described in a separate configuration below). In FIG. 3, the product number information is a condition executed by the group in order to satisfy a contract condition with the customer such as a production start date, a delivery date (completion date), etc., or an in-house planned condition. The contents of along A customer ID or the like may be input.

  Personnel-specific business management means 74 (third function) stores and manages personnel-specific manhour information and personnel-specific information as personnel-specific business data as shown in FIG. The man-hour information by personnel is always received from the personal terminal for the time (construction period) representing the production activity and the actual man-hours by the personnel who execute the project, for example, the individual who performs the production related to the project, It is stored and managed in the personnel database in association with personnel identification information. The man-hour information by personnel may be managed separately for those that have been confirmed and those that have not yet been confirmed. And what was decided may be totaled like the total information according to personnel at the lower right in FIG. Confirmation, for example, determines the end of the month as the date for closing the balance, and confirms the actual man-hours related to the date up to the closing date as business information such as the actual man-hours of personnel for that month. It tends to be later than the day.) Accumulated totals of actual man-hours and the like before the latest closing date are confirmed by personnel. The data for one month after the latest closing date until the next closing date is uncertain man-hour information. In the following, “unconfirmed manpower information by personnel” means a distinction from “confirmed manpower information by personnel”, and simply “manpower information by manpower” means the whole concept including both of them. And Note that the calculation information 71b by personnel is created by the calculation means 71b, which will be described later, by counting the man-hour information for each instructed individual month after receiving a confirmation instruction from the management terminal 6 or the like. Here, the end of the month has been described as the closing date. However, the closing date may be set to a predetermined day other than the end of the month, and may be determined as business information such as the actual man-hours of the factor of the closing day.

  When the closing date comes, the editing restriction unit 74a causes the tabulation management unit 71, which will be described later for the undecided manpower information by personnel, to tabulate one month, and confirms the tabulated information by personnel. Is generated. It is stored and managed in a personnel database. And if there is an access to rewrite the man-hour information before the closing date (that is, the determined man-hour information etc.) after the closing date from the personal terminal, this is not accepted. And only the man-hour information by personnel after the closing date is accepted.

  Undecided man-hour information by personnel is input from the personal terminal. As the man-hour information for each manpower, the manpower ID, the time when the production activity related to the business (month day, that is, the work term) and the actual man-hours worked (work time) are indispensable. In addition, there are process symbols for identifying processes spent on the actual man-hours (if there are various types of large, medium, and small ones, they may be described as well), planned man-hours scheduled in advance (planned), and the like. In addition, it is advisable to enter work hours that reflect entry, departure, early departure, lateness, etc. In addition to the project organization structure, it is advisable to input the affiliation in the labor organization structure such as business divisions, departments, sections, and groups. Of these, the actual man-hours and the time between attendances are input on a personal terminal basis each time, while others can be input in advance from the management terminal or the like.

  On the other hand, the personnel-specific information is assigned based on the personnel ID, the unit cost per man-hour (for example, per hour) assigned in advance based on the work efficiency so far, and the sales plan of the business related to this project. There is a selling price per man-hour (it is a default value, and if there is actually sales as the process proceeds, it can be corrected).

  In addition, as the total information by personnel shown in FIG. 3, in addition to the accumulated man-hour information by personnel, the unit cost and the unit selling price are retrieved from the personnel specific information and inputted.

  The method of using these manpower-specific manhour information will be described later, but will be briefly described here. The actual man-hour / scheduled man-hour can be used as an index (in other words, man-hour progress) that shows the progress of the project from the viewpoint of man-hours. Actual man-hour x unit cost, so to speak, processing cost can be used as an index indicating the actual result based on the cost, and actual man-hour x unit selling price can be used as an index indicating the planned sales. The actual man-hour / working time can be used as an index for attendance management. In addition, statistical data can be aggregated and used for each indicator for each department, section, group, or for each process.

  The customer information management means 76 (fourth function) manages customer information related to sales as shown in the lower part of FIG. Sales to customers are managed together with customer IDs, and when sales are actually made, they are managed in the sales database so that they can be searched by product number ID and sales number per person). In particular, the unit set selling price per man-hour is calculated and managed for each person. The unit set selling price is used instead of the unit selling price (default value) in the man-hour information by personnel. The sales information is received from the management terminal 6 and managed.

  Various information management means 76 (fifth function) stores and manages expenses, past month cost accounting information, serial number bills, and the like. The expense is an expense required for the production number for executing the business related to the project, and is managed so as to be searchable by the production number ID. Expenses include outsourcing expenses and other expenses such as transportation expenses. Expenses are used for secondary cost calculation. In addition, the previous month's cost statement when the previous month's cost was calculated is stored and managed as information. This is because the past month cost statement uses the balance in progress of the previous month when creating a new cost statement. Further, the production number invoice information is an in-house invoice amount and an amount expected as sales. These are used to create a cost statement. The past month cost statement may be stored as it was previously costed, and the expense, serial number bill, etc. may be input from the management terminal 6 each time. In addition, the expense, the past month cost accounting information, and the bill relating to the product number may be separately managed as long as they can be accessed and searched by at least the product number ID.

  The claim accepting means 70 can select, for example, a plurality of management items desired to be browsed with respect to the viewing terminal, and ranges by project (project ID), ranges by product number (product number ID), or by personnel An input guidance screen that allows the user to specify the period of data of the desired management item is specified. Then, the management item, the range of the organization (project, serial number, personnel) to be managed, and the period of the management target are specified from the browsing terminal, and the management data request is received and notified to the tabulation management means 71.

  The aggregation management unit 71 includes a data reading unit 71a and a calculation unit 71b. If the range of the management item related to the claim received by the claim receiving unit 70 is a project ID, the data reading unit 71a accesses the project management unit 72 and links to the project ID (link). Table A), and search for the personnel ID linked to the production number ID from the production number (group) information management means 73 (using the link table B), and further access the personnel-specific business information management means 74 to Read the project information, production number information and personnel-specific business data. At that time, the data reading means 71a reads information such as unit cost from the personnel-specific information based on the personnel ID, and reads actual man-hours from the personnel man-hour information (hereinafter, the same applies when reading from personnel-specific business data). To be done). If the range of the management item related to the claim received by the claim accepting means 70 is the product number ID, the work number information managing means 73 is accessed to search for the personnel ID linked to the product number ID, and further the business according to personnel. The information management means 74 is accessed to read the production number information of the production number ID and the man-hour information by personnel of the personnel ID. If the range of the management item related to the claim received by the claim accepting means 70 is the personnel ID, the production number information management means 73 is accessed to search for the personnel ID linked to the product ID, and further the personnel-specific business. The information management means 74 is accessed to read the manpower-specific manhour information of the personnel ID. Also, when reading the man-hour information by personnel, only the information necessary for the charge management item is read. At that time, for example, when it is desired to view the actual man-hours / scheduled man-hours of the product number, the actual man-hours and the planned man-hours of the personnel are read, but the unit cost is not read. Further, the data reading means 71a determines whether or not the claimed period includes a fixed period (the deadline has passed), and for the included period, the confirmed personnel-specific aggregate information is not determined if it is an unconfirmed period. Reads man-hour information by personnel.

  The calculation means 71b has a calculation means for each item according to the management item presented by the claim receiving means 70 on the input guidance screen. For example, as described above, the calculation unit 71b calculates the progress rate = actual man-hour / scheduled man-hour, processing cost = actual man-hour × unit cost, planned sales, from the business data classified by personnel retrieved and read by the data reading unit 71a. High = actual man-hour × unit selling price, or actual work rate = actual man-hour / attendance time, etc. are calculated for the range of management data requested (by project, by product number, or by manpower) and for the period. Furthermore, it has other calculation functions such as cost calculation based on actual man-hours and expenses. Other calculation operations will be described later in Examples 1 and 2 and Embodiment 3. If the billed period already includes a confirmed period, the confirmed amount is tabulated using the tabulated information by personnel, and for the unconfirmed period, the number of man-hours by personnel that has not been confirmed. Aggregate using information.

  Examples of calculation results by the calculation means 71b are shown in FIGS. FIGS. 9 and 10 are examples used for predictive progress management (actual progress management for a schedule). FIG. 9 is an example of calculation and output for each manpower and FIG. 10 for each product number. “N month” in the column of each figure indicates a period designated as “n month” as a management target period by the billing reception means 70. This is an example in which the periods before and after “n months” and “after n months” are not charged, but the data for those periods is also aggregated. For example, the data “160” and “150” corresponding to the “Segment” schedule in the “Person A” section, the “Results” column, and the “Man-hour” column of “N Month” are shown in FIG. The total of the “scheduled man-hour” and “actual man-hour” of the man-hour information in n months is shown. Therefore, if the man-hour progress rate, the progress rate = (actual man-hour / planned man-hour) × 100 = 93, 7% is calculated (the man-hour progress rate is not shown in FIGS. 9 and 10).

  Hereinafter, an operation flow will be specifically described in the embodiment.

[Example 1]
An operation in the case where a request for activity number data (cost basis) for a product number and a desired period is received from the viewing terminal will be described with reference to FIG. The following step S number corresponds to the S number in FIG.
Step S1: The bill receiving means 70 presents an input screen on the viewing terminal, designates the product number and period from the viewing terminal, and records the cost-based activity results (management) for the designated period of the designated product number. There is a request for data on the event) and accept it.
Step S2: Since the designated product number is the data reading means 71a, the data reading means 71a accesses the production number information management means 73 and searches the link table B for the personnel ID corresponding to the designated product number.

Steps S3 to 6: The data reading means 71a determines whether the requested period includes a period before the current month, that is, a fixed period (steps S3 and S5). If the current month is included in the billed period, that is, if the current month is included in the billed period, that is, if there is an unconfirmed period, The actual man-hours in the unidentified man-hour man-hour information are read (step S6).
Step S7: The data reading means 71a acquires customer ID information from the product number information of the product number information management means 73.

Steps S8 to 10: Based on the acquired customer ID information, it is determined from the customer information of the customer information management means 76 whether there is a unit setting selling price per employee (step S8). If the selling price is not acquired (step S9), if not, the unit selling price is acquired from the confirmed total information by personnel or the personnel specific information for the personnel ID (step S10).
Step S11: The unit cost for the personnel ID is acquired from the business information management means 74 by personnel.

Step S12: The project ID corresponding to the product number is acquired from the link table A of the project information management means 72 (since this is a request for the product number, it is not particularly necessary to acquire the project ID).
Step S13: The calculating means 71b performs the following calculation based on each business data read by the data reading means 71a. The following calculations (1) to (3) are processes based on the actual man-hours.
(1) For the personnel ID, the next accumulated actual man-hour is calculated.
Total actual man-hours = cumulative actual man-hours in the fixed period + actual man-hours in the indeterminate period
Cumulative total.
(2) The next processing cost is calculated for the personnel ID.
Machining cost = [Total number of actual man-hours x unit cost] for each personnel ID
Aggregate for all personnel involved.
(3) The next sales schedule is calculated for the personnel ID.
Sales schedule = [Total number of actual man-hours x unit selling price] for each employee ID
Calculated for all personnel related to D.

  Then, the computing means 71b further outputs a sales schedule using the cost-based activity results for the requested product number and period as the processing costs. An output example is “actual performance / planned data” at the lower right of FIG. In this output example, the actual man-hours for each process are also calculated. The output “actual result / schedule data” is stored to the extent that it can be used by the viewer, but is not made into a database. Moreover, when using it, it browses by requesting again. In other words, it is to output the latest data in which the business data classified by personnel input before re-billing is taken.

As another output mode, in addition to the above (1) to (3), the following calculations (4) to (7) may be performed, and the results may be output in the items shown in FIGS. it can. 9 and 10 are described in a simulated manner for explanation.
(4) The next scheduled man-hour accumulation is calculated for the personnel ID.
Cumulative total man-hours = cumulative man-hours in the fixed period + planned man-hours in the unconfirmed period
Cumulative total.
(5) The next processing cost is calculated for the personnel ID.
Scheduled processing cost = [All scheduled man-hours x Unit cost] of each personnel ID concerned
Aggregated for all personnel involved in ID.
(6) The next sales schedule is calculated for the personnel ID.
Sales plan = [Scheduled total number of man-hours x unit selling price] for each employee ID
Calculated for all personnel related to D.
(7) Cost ratio for the actual number of man-hours = processing cost of (2) / sales plan of (3)
(Corresponding to the cost rate in “Actual” of “Category” in FIG. 3)
Cost ratio to total planned man-hours = processing cost of (5) / sales plan of (6)
(Corresponding to the cost rate in "Schedule" in "Category" in Fig. 3)
The above calculation results are shown in FIGS.

[Example 2]
The operation when a request for a cost statement of a desired product number is received from the viewing terminal will be described with reference to FIG. The following step S number corresponds to the S number in FIG.
Step S20: The claim accepting means 70 presents an input screen on the viewing terminal, and there is a request for the costing document of the desired product number from the viewing terminal and accepts it. At the same time, if there is a work-in-progress replacement and a work-in-progress balance, the input thereof is also accepted. You may receive these from a management terminal.
Step S21: Since there is a data aggregation / processing target year called the current month, which is set in the data management server 7, the data reading means 71 acquires the latest processing month (current month).
Step S22: The data reading means 71a retrieves the personnel ID related to the desired desired product number from the link table B of the group information management means 73, and the corresponding personnel ID from the determined personnel total information of the business information management means 74 by personnel. Acquire the accumulated actual man-hours, unit cost, and unit selling price.

Step S23: The computing means 71b totals the acquired total accumulated man-hours, processing costs, and sales schedules by desired product number. (Calculation similar to (1), (2), (3) above)
Step S24: The data reading means 71a acquires the expense of the desired product number from the expense information of the various information management means 75.
Step S25: The data reading means 71a acquires the billing amount relating to the bill of the desired production number from the bill information of the various information management means 75.
Step S26: The data reading means 71a obtains the previous month work in progress from the past month cost statement of the various information management means 75.

Step S27: The calculation means 71b creates the cost statement information shown in FIG. 5 based on the total accumulated man-hours, expenses, billing amount, previous month work in progress balance, and work in progress transfer for the desired desired product number. At that time, calculation of main items is performed as follows. In the present invention, in addition to the above-mentioned retrieval of the actual man-hours, the cumulative total, etc., the calculation of the secondary cost including the processing cost, the sales amount, and the processing cost and the cost can be performed among the following calculations. However, it depends on the user what kind of items are included in the secondary cost in addition to the processing cost and the cost.
(A) Machining cost = [Total number of actual man-hours x unit cost] of each personnel ID is related to the desired product ID
Aggregate all personnel.
(B) Sales amount = [cumulative total man-hours × (unit selling price)] for each personnel ID
Aggregate + billed amount for all personnel involved in D.
(C) The secondary cost is variously calculated depending on conditions. For example, the following example
The
$ 1: If it is less than the preset cost,
Secondary cost = previous month's work in process balance + processing cost + expense (* 1) + work in progress
$ 2: If it is more than the preset cost,
Secondary cost = previous month work in process balance + processing cost + expense + work in progress (d) Work in progress balance = previous month work in process + processing cost + expense + work in progress-secondary cost (Note 2)-transfer Note 1: Expense = subcontracting Costs + other expenses such as transportation expenses Note 2: Adopted secondary cost of $ 1 or $ 2 above

[Embodiment 2]
The first embodiment is an example of managing the activity results in the project organization structure, but this example focuses on the management form in the labor structure composed of divisions, departments, sections, groups, and personnel layers. explain. In the following, management of attendance related to salary and the like will be described, but other labor-related matters such as health and human resources may be used. Although the basic configuration is shown in FIG. 6, the configuration is the same as that in FIG. 1, but the organization and information to be applied are different. Accordingly, the difference in configuration from FIG. 1 is shown in FIG. 7 shows. However, FIG. 6 shows the organization below the department and omits the upper organization beyond it.
In FIG. 6, the same reference numerals as those in FIG. 1 indicate the same functions.

  The section management means 72a in FIG. 6 stores and manages information as a section information DB so that information that is common to each section or that cannot be assigned to each section can be searched by section ID.

  The section management means 73a in FIG. 6 associates section identification information (hereinafter referred to as “section ID”) with the section ID of the section to which the section belongs, and is common to each group or distributed to each group. Information is stored and managed as a section information DB (DB: an abbreviation of database) so that it can be searched by section ID. Similarly, the group management means 73b associates the group identification information (hereinafter referred to as “team ID”) with the department to which the group belongs, the section ID of the section, and the section ID, and information common to each member. Information is stored and managed as a group information DB that can be searched by group ID.

  As shown in FIG. 7, the organization information management unit 77 stores and manages the personnel ID, the department ID to which the personnel belong, the section ID, and the group ID as a database so that the personnel ID can be searched. It is possible to access information on departments, sections, and groups to which personnel belong from the organization information. In other words, organization information also serves as link information.

  The personnel-specific business information management means 74 is functionally the same as the personnel-specific business information management means 74 (both are denoted by the same reference numerals), and the information is also personnel information including attendance time information in FIG. However, in addition to the man-hour information shown in FIG. 1, the same operation can be performed even in a configuration in which attendance time information is newly added and stored in the personnel database. The attendance information (working time) is always input from the personal terminal or / and the management terminal 6 and managed as attendance time information. As the attendance time information, as shown in the upper left of FIG. 7, the lead time for entering and leaving the office by the time recorder, the correction time by late and early leaving, the overtime hours, and the like are managed. These are classified and managed according to differences that affect salary.

  FIG. 7 shows the data structure of each management means and the output information. As shown in FIG. 7, the difference from FIG. 1 is that the information is changed according to the difference of the organizations to be managed by the department management means 72a, the section management means 73a, and the group management means 73b, and the personnel and each organization. The attendance time information of the information and personnel information management means 74 means that the information is linked with the organization information, and that the attendance time information is added to the personnel business information management means 74.

  If the request for the management data received by the claim receiving means 70 is part-time management, the data reading means 71a refers to the organization information and refers to the employee ID of the employee to which he belongs, attendance time information for a desired period, desired period Search for actual man-hours. Similarly, in the case of attendance management of a section or a group, the personnel ID of personnel belonging to each, the attendance time information of a desired period, and the actual man-hours of the desired period are retrieved from the organization information. If it is attendance management according to personnel, the personnel-specific business information management means 74b is directly searched.

The calculation means 71c has, for example, calculation means related to an actual work rate during a desired period for time attendance management. For example, the calculation means 71c performs the following calculation based on each data retrieved as described above. The following departments are departments, sections, groups, or personnel themselves. It is also possible to aggregate, calculate and output by project and product number.
・ Total working hours of the desired department = All employees' total attendance hours during the desired period
Cumulatively about.
・ Total attendance hours of staff = regular working hours + late-night overtime hours + holidays regular working hours
+ Holiday late-night overtime hours-Deduction time-Total actual man-hours of the desired department = Total actual man-hours of staff members in the desired period
Accumulate.
The actual work rate = total actual man-hours / total work hours The calculation means 71c may calculate the overtime rate = total overtime hours / total work hours in addition to the actual work rate. Further, for example, a statistical chart such as a distribution of actual work rates for each section may be created.
The other configuration operations of the data management server 7a are the same as those of the data management server 7 of FIG.

  FIG. 8 shows the calculation result by the calculation means 71c. FIG. 8A shows the total results of the total actual work rates by group, and FIG. 8B shows the total results of the total actual rates by personnel.

[Embodiment 3]
The first embodiment, which is the management form of the project organization structure, and the management form 2 of the labor organization structure can be merged, and project management and labor management can be performed by the same management apparatus. As already described, in FIGS. 1 and 6, as data relating to personnel, data necessary for project management (for example, actual man-hours, unit costs, etc.) and data necessary for labor management (attendance hours, etc.) Are stored in the personnel-specific business information management means 74 as business data. Further, the project management series of the project information management means 72 and the group management means 73, the organization information management means 77 for labor management, and the department management means 72a, the section management means 73a, and the group management means linked thereto. 73b is provided in parallel with the labor management series, and the data reading means 71a is accessed from the project management series or labor management series according to the type and range of the management data to be requested, and the personnel-specific business information management means 74 is provided. The necessary data may be read out from the data, and the calculation means (71, 71c) may perform the calculation according to the type. The configuration can be simplified by merging the configuration of FIG. 1 and the configuration of FIG.

  As described above, the program according to the present invention is flexible in that it can easily retrieve data on personnel affecting the profit of the organization from various organizational configurations. And since it is the structure which acquires and calculates the newest data, the management data with high real-time property can be browsed.

It is a figure for demonstrating embodiment of this invention. The functional block showing the part which concerns on invention as the data management server 7 for business management including production is shown. Each function of the data management server 7 represents a representative function of the management program according to the present invention. It is a figure which shows the hardware constitutions of the data management server 7 of FIG. It is a figure which shows the outline | summary of the data structure which each means (function) of the data management server 7 of FIG. 1 handles. It is a figure which shows the operation | movement flow which the management data which show a progress condition produce | generate. It is a figure which shows the operation | movement flow which produces | generates a cost accounting document. It is a figure which shows the functional block of the data management server 7 when performing time management. It is a figure which shows the outline | summary of the data structure in the functional block of FIG. It is a figure which shows the example of the total calculation result of a working rate. It is a figure which shows the example which carries out aggregation calculation of the processing cost and a cost rate according to personnel based on an actual man-hour and a plan man-hour. It is a figure which shows the example which carries out aggregation calculation of the processing cost and a cost rate according to a production number based on a performance man-hour and a schedule man-hour.

Explanation of symbols

1, 3, 5 Browsing terminal 2, 4 Personal terminal 6 Management terminal 7 Data management server

Claims (9)

  A first function (72) for associating and managing project information including project identification information for identifying a business and group identification information representing a business execution group under the project, group information including the group identification information, and the business The second function (73) for managing and associating the personnel identification information of the personnel to be executed, the period representing the business action by each of the personnel and the input of the actual man-hours are always accepted, and the actual man-hours and the personnel identification information A third function (74) for managing and associating, a request receiving function (70) for receiving a request for management data for a desired period related to a specific management type, and when the specific management type is received, Depending on the target range, the first function, the second function, the third function based on the project identification information, the group identification information or the personnel identification information. Business management program for causing a computer to execute a function including a total management function (71) that reads out the actual man-hours in the desired period in cooperation with a function or a combination thereof, and performs a total calculation according to the specific management type .   The first function separately manages first link information for linking the project identification information and group identification information, and project-specific information exceeding a business execution group, and the second function includes the group identification. 2. The business management program according to claim 1, wherein the second link information for linking the information with the personnel identification information and the group information specific to the business execution group are separately managed.   When the claim acceptance function accepts a request for management data for a desired aggregation period related to the progress of a business action as the specific management item, the aggregation management function is configured such that when the progress is a progress in a project, the first In the order of function, second function and third function, in the case of progress in individual groups, in the order of second function and third function, in the case of progress in individual personnel, directly linked with third function, 3. The business management according to claim 1 or 2, wherein the actual man-hours for a desired period are read out, and the cumulative man-hours related to the claim are calculated and calculated for each project, group, or personnel based on the actual man-hours. program.   The third function determines the actual man-hours for each accepted workman at every predetermined time, makes it impossible to edit the actual man-hours that have been confirmed, and provides the man-hours accumulated by manpower for the confirmed man-hours The business management program according to claim 3, further comprising an edit restriction function (74a) for enabling management. The third function manages the unit cost and unit selling price per man-hour for each of the personnel,
Based on the accumulated actual man-hours and unit cost or unit selling price, the totaling calculation function further calculates the processing cost, the sales amount, or both according to the scope of the claim by project, group, or personnel. The business management program according to claim 3 or 4, characterized in that. Further, the fifth function (75) for receiving the input of expenses required for the project or group business activities by the personnel and managing the expenses in association with the group identification information is executed.
The third function further manages the unit cost and unit selling price per man-hour for each personnel.
When the billing reception function accepts a request for cost management data as a specific management item, the tabulation calculation function reads and tallies the expenses of the corresponding group from the second function and the fourth function, From the function and the third function, the processing cost is calculated based on the actual man-hours and the unit cost for the corresponding personnel, and the secondary cost is calculated as the cost management data based on the calculated cost and processing cost. The business management program according to claim 1, 2, or 3. In the business organization consisting of a plurality of organizational layers, the upper organization identification information of the upper organization, the intermediate organization identification information of the intermediate organization belonging to the upper organization, the lower organization identification information of the lower organization belonging to the intermediate organization, and the lower organization An organization information management function (77) for associating and managing organization identification information of the personnel belonging to the organization,
Further, the third function always accepts and manages the input of the attendance time of the personnel in addition to the actual man-hours representing the time when the personnel performed the business act,
When the claim accepting function accepts a request for the actual working rate of the organization layer to be managed, the total calculation means calculates the actual man-hour and attendance time for each person of the third function, and each of the organization information management functions Based on the organizational layer identification information, the actual work rate is calculated within the range of either the upper organization, the middle organization, the lower organization, the personnel, or a combination thereof according to the organization layer to be managed in the claim. It outputs, The business management program as described in any one of Claims 1-6 characterized by the above-mentioned. In the business organization consisting of a plurality of organizational layers, the upper organization identification information of the upper organization, the intermediate organization identification information of the intermediate organization belonging to the upper organization, the lower organization identification information of the lower organization belonging to the intermediate organization, and the lower organization An organization information management function (77) for associating and managing organization identification information of personnel belonging to the organization;
In addition to the actual man-hours representing the time when the personnel performed the business, the personnel's attendance hours are always accepted, and the personnel identification information, the actual man-hours and the attendance hours are stored and managed in association with each other. Information management function (74) by personnel
A claim acceptance function (70) that accepts a request for an actual rate of utilization of an organization layer to be managed;
When the claim acceptance function receives the claim, the management target of the claim is determined from the actual man-hours and attendance hours for each person of the information management function for each person and the identification information of each organization layer in the organization information management function. A function including an aggregate calculation function (71) that calculates and outputs an actual work rate within a range of any one of a higher-level organization, a middle-level organization, a lower-level organization, personnel, or a combination thereof according to an organizational layer A business management program characterized by causing a computer to execute.   Project information management means (72) for managing project information including project identification information for identifying a business in association with group identification information representing a business execution group under the project, group information including the group identification information, and the business Group information management means (73) for managing in association with the personnel identification information of the personnel who execute the operation, the period representing the business action by each of the personnel and the input of the actual man-hours are always accepted, the actual man-hours and the personnel identification Personnel information management means (74) for managing information in association with each other, bill reception means (70) for accepting a request for management data for a desired period related to a specific management item, and when receiving the request, the specific information The project identification information, the group identification information, or the personnel identification information depending on the scope of the management item. Based on the first function, the second function, the third function, or a combination thereof, the total management means (71) that reads the actual man-hours in the desired period and performs the total calculation according to the specific management type And a business management device.

Images