Personnel planning support system, personnel planning support method, and computer program

Abstract

There is a need for technology that can efficiently carry out workforce planning tasks within an organization. [Solution] The disclosed personnel planning support system creates a personnel planning sheet for each department, which has input fields for inputting personnel planning information related to personnel planning. The system outputs the personnel planning sheet in a state that allows each department's terminal to input information into the personnel planning sheet, and can collect the completed personnel planning sheets that have been entered by each department's terminal. The system may also include saving the personnel planning information in each input field of the completed personnel planning sheet as tagged input information to which a tag for saving collected values ​​indicating the nature of the personnel planning information is attached.

Description

Technical Field

[0001] The present disclosure relates to a personnel planning support system, a personnel planning support method, and a computer program.

Background Art

[0002] In organizations such as enterprises, personnel planning is carried out on a regular basis in order to appropriately assign human resources (personnel) according to their respective skills and the requirements of each work unit.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

[0004] Personnel planning itself is generally carried out on a per-work-unit basis, but tasks such as requesting the preparation of the personnel plan itself and compiling the results may be undertaken by an administrative department such as the human resources department. As an organization grows larger, the operational burden on this administrative department increases. As a result, an increase in indirect operational burdens related to personnel planning can become a challenge.

[0005] Accordingly, a technology capable of efficiently executing personnel planning operations in an organization is desired.

[0006] The disclosed technology may include a processor that executes operations including: creating a personnel planning sheet having input fields for inputting personnel planning information related to personnel planning for each department, outputting the personnel planning sheet in a state where a terminal of each of the departments can input data to the personnel planning sheet, collecting the completed personnel planning sheets that have been input by the terminals of the respective departments, and storing the personnel planning information in each of the input fields of the completed personnel planning sheet as tagged input information to which a collected value storage tag indicating the nature of the personnel planning information is assigned.

[0007] One aspect of the disclosure, the method for supporting workforce planning, may include creating a workforce planning sheet for each department, having input fields for inputting workforce planning information; outputting the workforce planning sheet in a format that allows each department's terminal to input information into the workforce planning sheet; collecting the completed workforce planning sheets entered by each department's terminal; and saving the workforce planning information in each input field of the completed workforce planning sheet as tagged input information to which a tag for saving collected values ​​indicating the nature of the workforce planning information is attached.

[0008] Another aspect of this disclosure is a computer program which can be made to perform the following operations: create a personnel planning sheet for each department having input fields for inputting personnel planning information relating to personnel planning; output the personnel planning sheet in a state in which each department's terminal can input information into the personnel planning sheet; collect the completed personnel planning sheet that has been entered by each department's terminal; and save the personnel planning information in each input field of the completed personnel planning sheet as tagged input information to which a tag for saving collected values ​​indicating the nature of the personnel planning information has been attached.

[0009] Further details will be described in the embodiments below. [Brief explanation of the drawing]

[0010] [Figure 1] Figure 1 shows a network configuration diagram including the personnel planning support system according to the embodiment. [Figure 2] Figure 2 is a flowchart illustrating the tasks related to workforce planning performed by HR personnel within an organization. [Figure 3] Figure 3 shows an example of a personnel planning sheet. [Figure 4] Figure 4 is a flowchart illustrating the workforce planning support process performed by the workforce planning support system. [Figure 5] Figure 5 shows an example of the display screen for the personnel planning sheet list. [Figure 6] Figure 6 shows an example of the display of the settings screen for collected values. [Figure 7] Figure 7 shows an example of the display of the reference value setting screen. [Figure 8] Figure 8 shows an example of the layout settings screen for the personnel planning sheet. [Figure 9] Figure 9 shows an example of the layout settings screen after the collected and aggregated values ​​have been set. [Figure 10] Figure 10 shows an example of a submission format. [Figure 11] Figure 11 shows an example of the display of the submission sheet list screen. [Figure 12] Figure 12 shows an example of the output of the generated summary sheet. [Figure 13] Figure 13 shows an example of data compiled by a human resources staff member based on a summary sheet. [Modes for carrying out the invention]

[0011] <1. Overview of the workforce planning support system, workforce planning support method, and computer program>

[0012] (1) The personnel planning support system according to the embodiment may include a processor that performs the following operations: creating a personnel planning sheet for each department having input fields for inputting personnel planning information related to personnel planning; outputting the personnel planning sheet in a state that each department's terminal can input into the personnel planning sheet; collecting the completed personnel planning sheet that has been entered by each department's terminal; and saving the personnel planning information in each input field of the completed personnel planning sheet as tagged input information to which a tag for saving collected values ​​indicating the nature of the personnel planning information has been attached. In this case, the work related to personnel planning can be completed in a single system, and the complex work that spans multiple departments can be made more efficient. In addition, the reusability of the personnel planning information collected from each department can be increased.

[0013] (2) The creating of the personnel plan sheet may include determining the type of the personnel plan information to be input into the input field by allowing each of the departments to select a collected value and an aggregation axis from a plurality of options, and creating a different personnel plan sheet for each of the departments. In this case, flexibility can be provided to the creation of the personnel plan sheets, and personnel plan sheets with a high degree of freedom can be created between departments.

[0014] (3) The creating of the personnel plan sheet may include creating the personnel plan sheet having the actual values of the personnel plan information as reference values when inputting the personnel plan information into the input fields. In this case, information that serves as a reference when inputting the personnel plan information can be provided, and workability can be improved.

[0015] (4) The creating of the personnel plan sheet may include acquiring the relevant information from a database that stores information including information related to the actual values of the personnel plan information, and generating the actual values. The acquiring of the relevant information may include associating the personnel plan information input into the input fields with information preselected as information that can be acquired when generating the actual values among the information stored in the database, and acquiring the relevant information based on the association. In this case, information related to the actual values can be efficiently selected and acquired from the vast amount of information stored in the database.

[0016] (5) The creating of the personnel plan sheet includes setting the collected value storage tag in the input field, and the storing of the tagged input information may include storing the numerical value input into the input field to which the collected value storage tag is assigned. In this case, the personnel plan information input into the personnel plan sheet can be efficiently stored.

[0017] (6) The operations may further include generating aggregated data of the personnel plan information from the stored tagged collected data by allowing a plurality of selectable aggregated values and aggregation axes to be selected from a plurality of options. In this case, required aggregated data can be generated from the collected personnel plan information, which can be utilized for the execution of personnel planning operations.

[0018] (7) The plurality of options may include highlighting or independently displaying an option to which a flag indicating importance is assigned. In this case, a user can easily make a selection from the options.

[0019] (8) The personnel planning support method according to the embodiment may include: creating a personnel planning sheet having input fields for inputting personnel planning information related to personnel planning for each department, outputting the personnel planning sheet in a state where a terminal of each of the departments can input into the personnel planning sheet, collecting the completed personnel planning sheets input by the terminals of the respective departments, and storing the personnel planning information in each of the input fields of the completed personnel planning sheets as tagged input information to which a collected value storage tag indicating the nature of the personnel planning information is assigned.

[0020] (9) The computer program according to the embodiment can cause a computer to perform operations comprising: creating a personnel planning sheet having input fields for inputting personnel planning information related to personnel planning for each department, outputting the personnel planning sheet in a state where a terminal of each of the departments can input into the personnel planning sheet, collecting the completed personnel planning sheets input by the terminals of the respective departments, and storing the personnel planning information in each of the input fields of the completed personnel planning sheets as tagged input information to which a collected value storage tag indicating the nature of the personnel planning information is assigned.

[0021] The computer program according to the embodiment may be configured to cause a computer to execute the method. Further, the computer program according to the embodiment can cause a computer to function as the system. The computer program may be recorded on a computer-readable non-transitory recording medium.

[0022] <2. Examples of Personnel Planning Support System, Personnel Planning Support Method, and Computer Program> Hereinafter, the embodiments will be described in more detail with reference to the drawings.

[0023] Figure 1 shows a network configuration diagram including a workforce planning support system 1 according to an embodiment. In this embodiment, the workforce planning support system 1 will be described using an example in which it can acquire personnel-related information (personnel information) from a personnel management system 2 connected via a network 4 and perform various processes based on that personnel information. However, the workforce planning support system of this disclosure may be implemented on the same system (one or more computers) as the personnel management system, and is not limited to the example in Figure 1.

[0024] The workforce planning support system 1 and the personnel management system 2 are configured as database server systems to support employees in developing workforce plans. Both the workforce planning support system 1 and the personnel management system 2 are operated by a system provider. Furthermore, the workforce planning support system 1 and the personnel management system 2 may provide workforce planning services (e.g., SaaS (Software as a Service)) to organizations (e.g., companies) that have a contract to use these systems 1 and 2.

[0025] In this embodiment, we will explain using an example in which an organization as a system user has departments A, B, C, D, ... Z, and the personnel information of these departments A, B, C, D, ... Z is managed by a person in charge of human resources (e.g., the Human Resources Department). The workforce planning support system 1 and the personnel management system 2 are mainly used by the person in charge of human resources, and can also be used by the person in charge of each department based on the requests of the person in charge of human resources.

[0026] Workforce planning is the process of planning the number, skills, and placement of personnel needed by an organization to ensure smooth operations. Securing, developing, and optimally allocating personnel is crucial for organizations to improve operational efficiency and reduce costs; therefore, workforce planning is essential for any organization. As an organization grows, the scope of workforce planning expands, and the planning process can become more complex. Consequently, the burden on HR personnel responsible for workforce planning can increase.

[0027] For example, Figure 2 is a flowchart illustrating the work related to workforce planning performed by HR personnel within an organization. Figure 2 illustrates the interaction between the HR department and each department that is subject to workforce planning.

[0028] First, the Human Resources Department prepares to collect workforce plans from each department. Specifically, each department creates a sheet for filling out its workforce plan (Step S1). The sheet is created using data editable with spreadsheet software, for example, and has input fields for entering the number of personnel, desired overtime hours, etc. One sheet is created for each department.

[0029] Next, the Human Resources Department distributes the sheets to each department and requests that they be completed (Step S2). The Human Resources Department may, for example, attach the sheet data to an email and send it, or request input via the network.

[0030] The person in charge in each department to whom the sheet is distributed (e.g., department head) fills in the required information on the sheet, such as the number of personnel and desired overtime hours (Step S3). The Human Resources Department collects the completed sheets (Step S4). The Human Resources Department may then need to download and save the sheets if they are sent by email from each department.

[0031] The Human Resources Department uses the collected sheets from each department to compile the total number of personnel and the total amount of overtime hours for the entire organization, and uses this information to formulate the personnel cost budget (Step S5). Specifically, the Human Resources Department multiplies the compiled values ​​by the unit cost of personnel expenses to create a personnel cost budget proposal. The unit cost of personnel expenses is determined by the Human Resources Department researching each unit cost and applying it to the values ​​obtained from each department (by entering them into the budget proposal sheet, etc.).

[0032] Furthermore, if the Human Resources Department determines that the number of personnel or desired overtime hours for each department are unreasonable, it will contact the relevant department or return the application form for further review. In doing so, the Human Resources Department will also refer to past performance to assess the feasibility of the plan.

[0033] As described above, the workforce planning process involves a wide range of steps, and the workload can increase proportionally with the number of departments. The workforce planning support system 1 in this embodiment supports the efficient execution of such workforce planning tasks.

[0034] As shown in Figure 1, the workforce planning support system 1 is connected to the personnel management system 2 and terminals 5 and 6 used by personnel staff and staff in each department via the network 4, enabling them to communicate with each other.

[0035] The Human Resources Management System 2 is a system designed to streamline a company's human resources operations, centrally managing employee information, payroll, attendance, recruitment and performance evaluation, and training management. The Human Resources Management System 2 has a Human Resources Information Database 3 (Human Resources Information DB3). The Human Resources Information DB3 stores information related to human resources managed by the Human Resources Management System 2 and is referenced as needed by the Workforce Planning Support System 1.

[0036] The personnel planning support system 1 can be implemented by one or more computers. The personnel planning support system 1 comprises a processor 10, a storage device 20 connected to the processor 10, and a communication unit 40.

[0037] Processor 10 is, for example, a CPU (Central Processing Unit), a GPU (Graphics Processing Unit), or another type of processor.

[0038] The storage device 20 is, for example, a primary storage device and a secondary storage device. The primary storage device is, for example, RAM (Random Access Memory). The secondary storage device is, for example, an HDD (Hard Disk Drive) or an SSD (Solid State Drive). The storage device 20 includes a computer program 21 and a database 22.

[0039] The computer program 21 is a set of instructions that cause the processor 10 to execute various processes in order to operate the computer as the personnel planning support system 1 according to the embodiment. The processor 10 reads and executes the computer program 21 stored in the storage device 20. As a result, the processor 10 executes the following processes in the personnel planning support system 1, which will be described in detail later: personnel planning sheet generation process 11, personnel planning sheet output process 12, personnel planning sheet distribution / acquisition / save process 13, and summary sheet generation process 14.

[0040] Database 22 (DB22) records personnel planning sheet setting information 31, personnel information linkage tag information 32, and tagged input information 33.

[0041] The personnel planning sheet setting information 31 is the setting information required when creating a personnel planning sheet. Here, Figure 3 is a diagram showing an example of a personnel planning sheet 50. The personnel planning sheet 50 is data consisting of sheets for each department to input personnel planning information. The personnel planning sheet 50 is data configured to be displayed on the display of the terminal 6 of the person in charge in each department, for example, or a data file that can be edited with spreadsheet software.

[0042] The staffing plan sheet 50 has input fields 51 for inputting the required staffing plan information as values. In Figure 3, "Number of Personnel" and "Average Overtime Hours" are set as the values ​​to be collected. The input fields 51 also have aggregation axes for the collected values ​​in columns and rows. In Figure 3, the items displayed in the columns (horizontal axis) are set to a period of one month from January to June 2025. The items displayed in the rows (vertical axis) are set to the organizations that make up the department (Sales Headquarters) (Platform Sales Department, Special Projects Sales Section).

[0043] The personnel planning sheet configuration information 31 may include definitions for multiple items that can be set as collected values ​​(aggregated values) and aggregation axes when creating such a personnel planning sheet 50. Furthermore, the personnel planning sheet configuration information 31 may include information regarding the layout of each department's personnel planning sheet 50, which is created by selecting from these items.

[0044] The HR information linkage tag information 32 is information used to associate HR-related information stored in the HR information DB3 of the HR management system 2 with the actual values ​​of the workforce planning information entered in the input field 51. The actual values ​​of the workforce planning information, along with the collected values ​​in the workforce planning sheet 50, become reference values ​​that make up the workforce planning sheet 50.

[0045] Reference values ​​are, for example, reference information for when a department's representative enters staffing plan information into input field 51, and are based on past performance. In Figure 3, the staffing plan sheet includes the performance values ​​for the most recent six months, from July 2024 to December 2024, as reference values ​​for entering staffing plan information for the six-month period from January to June 2025.

[0046] The HR information linkage tag (see Figure 10) is information provided to obtain actual values ​​from the HR information DB3 for generating such reference values, and it is information used to identify HR information stored in the HR information DB3. It is not attached to all types of information in the HR information DB3, but only to pre-selected information that may be referenced (obtained) when generating actual values ​​for information entered as workforce planning information.

[0047] Tagged input information 33 is data generated based on the personnel plan information in each input field 51 of the completed personnel plan sheet 50. Tagged input information 33 is assigned pre-prepared tags for saving collected values ​​(see Figure 10) so that the personnel plan information in each input field 51 can be identified. The tags for saving collected values ​​consist of information such as information indicating the type of collected value (collected value information), information indicating the period to which the collected value corresponds (period information), and information indicating the name of the department / organization to which the collected value corresponds (target information).

[0048] By pre-setting tags for saving collected values ​​and assigning these tags to each value entered in the input field 51 to DB22 as tagged input information 33, the amount of data to be stored can be reduced compared to storing the workforce planning sheet 50 itself, and the reusability in subsequent workforce planning tasks can be increased, as will be described later.

[0049] The communication unit 40 transmits data to external devices, including the personnel management system 2 and terminals 5 and 6 used by personnel and departmental staff, and receives data from external sources.

[0050] Terminals 5 and 6 are connected to the personnel planning support system 1 (and the personnel management system 2) in a communicative manner. Terminals 5 and 6 are, for example, personal computers, tablets, and smartphones. Terminals 5 and 6 are equipped with display devices and input devices. The display device is a display that can display display data provided by the personnel planning support system 1. The input device is a keyboard, mouse, touch panel, etc., that receives user operations and transmits signals based on those user operations to the personnel planning support system 1.

[0051] In this embodiment, terminal 5 is a terminal used by a person in charge of human resources who is responsible for the organization's personnel management and organizational operations, and who is responsible for carrying out workforce planning tasks. Terminal 6 is a terminal used by a person (e.g., a department head) who is requested by the person in charge of workforce planning tasks to carry out the task of creating workforce plans for each department.

[0052] Next, the details of the processing performed in the personnel planning support system 1 in this embodiment will be described. Figure 4 is a flowchart illustrating the personnel planning support processing performed by the personnel planning support system 1. This personnel planning support processing is started, for example, when the processor 10 receives an instruction from a human resources person (terminal 5) to create a personnel planning sheet 50.

[0053] In step S11, the processor 10 of the workforce planning support system 1 displays a screen for creating a workforce planning sheet 50 on, for example, the terminal 5 of a human resources officer (workforce planning sheet generation process 11). Here, Figure 5 shows an example of the display of the workforce planning sheet list screen 60. When a human resources officer wants to create a new workforce planning sheet 50, they press the new creation button 61 to initiate new creation. If there is already a workforce planning sheet 50 that has been created and is being formulated, the creation process is resumed when the status button 63 in the status column 62 is pressed. In this explanation, we will use an example where the new creation button 61 is pressed.

[0054] In step S12, the processor 10 accepts the settings for the collected values, aggregation axes, and reference values ​​of the workforce planning sheet 50. This process in step S12 is a preprocessing step for laying out and creating the workforce planning sheet 50 in step S13.

[0055] Figure 6 shows an example of the display of the data collection setting screen 70. When the processor 10 receives a command to start the setting, for example from a human resources person, it displays this setting screen 70. The items to be collected can be arbitrarily set by the human resources person who creates the workforce planning sheet 50. As shown in Figure 6, the human resources person can create items to be collected by pressing the new creation button 71. In Figure 6, the name field 72 lists the names of the collected items that have already been created. Examples of collected items include average overtime hours, number of employees, and planned number of employees.

[0056] Similarly, the items used for aggregation axes and reference values ​​can be arbitrarily set, for example, by accepting input from HR personnel on their respective setting screens. For example, the aggregation axes can be the items in the leftmost column 52 and the topmost column 53, as shown in Figure 3, and could be, for example, the organization name or job title (department head, section chief, etc.). Reference values ​​are the items displayed in the reference value table 56, which is shown below the collected value table 55, as shown in Figure 3.

[0057] At this time, the reference value will serve as the reference value for the workforce planning information to be entered by each department, and is a value stored in the personnel information DB3 of the personnel management system 2. In order for the workforce planning support system 1 to obtain such reference values ​​from the personnel management system 2 without increasing the processing load, the reference value is associated with the personnel information stored in the personnel information DB3 as follows.

[0058] Figure 7 shows an example of the display of the reference value setting screen 80. The workforce planning support system 1 pre-selects information that can be used as reference values ​​from the information stored in the personnel information DB 3 and prepares it as an option for personnel personnel. Furthermore, when the personnel personnel personnel select one of the prepared pieces of information as a reference value, the workforce planning support system 1 associates it with which data in the personnel information DB 3 it corresponds to and stores it as personnel information linkage tag information 32.

[0059] As a result, the workforce planning support system 1 eliminates the need for HR personnel to read information from the vast HR information DB3, for example, by checking the identification information attached to each piece of information in the HR information DB3, and then insert it into the workforce planning sheet 50 as reference information.

[0060] In other words, when an HR person wants to retrieve HR information from the HR information DB3, they select attribute 81 and value 82 from the options provided on the reference value setting screen 80, for example, from the options provided in "Definition of Reference Value" in Figure 7. This allows the workforce planning support system 1 to read the HR information in the pre-associated HR information DB3 and retrieve it as a reference value.

[0061] The items (definitions) related to the collected values, aggregation axes, and reference values ​​set in step S12 are stored in DB22 as personnel planning sheet setting information 31.

[0062] In step S13, when the processor 10 receives an instruction to start setting the layout of the workforce planning sheet 50, it displays the layout setting screen and accepts the layout settings from the HR person. Here, Figure 8 shows an example of the display of the layout setting screen 90 for the workforce planning sheet 50. Figure 9 shows an example of the display of the layout setting screen 90 after the collected values ​​and aggregated values ​​have been set.

[0063] The layout settings screen 90 includes a blank tab 91, a list of collected value items 92, a list of aggregation axis items 93, a period setting window 94, a column setting area 95, and a row setting area 96.

[0064] The Collection Value Item List 92 is a field that displays a list of the collection value items (Figure 6, step S12) set on the Collection Value Setting Screen 70. The Aggregation Axis Item List 93 is a field that displays a list of the aggregation axis items (step S12) set on the Aggregation Axis Setting Screen. The Period Setting Window 94 is a window for setting the specific unit of the period among the aggregation axis items. In the Period Setting Window 94, the unit of the period, the start date, and the end date are set.

[0065] The column setting area 95 (items to be displayed in columns) is the area where items used as column headers in tab 91 are set as the aggregation axis (horizontal axis). The row setting area 96 (items to be displayed in rows) is the area where items used as row headers in tab 91 are set as the aggregation axis (vertical axis). Items to be placed on each aggregation axis are dragged and dropped into the column setting area 95 and the row setting area 96 from the collected value item list 92 and the aggregation axis item list 93. This allows the layout of the workforce planning sheet 50 to be set simply and intuitively, as shown in Figure 9. Similarly, the processor 10 also displays the layout setting screen for reference values ​​and accepts the layout settings. The set layout is stored in DB 22 as workforce planning sheet setting information 31.

[0066] In this way, the processor 10 can determine the type of collected values ​​(personnel planning information) to be entered into the input field 51 by allowing the user to select the collected values ​​and aggregation axes from a list of multiple options.

[0067] Furthermore, to allow HR personnel (users) to easily select from multiple options displayed in a list of collected values ​​and aggregation axes, the processor 10 may flag important (highly important) options and highlight or display the flagged options separately.

[0068] Flags indicating importance may be assigned, for example, based on settings that the personnel planning support system 1 receives in advance from users, or automatically by the processor 10. When flags are assigned by users, the system provider may assign them in advance or during maintenance. Alternatively, users may assign flags at any time they wish. When the processor 10 automatically sets flags, it may assign flags based on the user's past selection history, calculate importance by learning from selection frequency (usage trends) and assign flags based on that, or calculate importance by reflecting the past selection history and selection frequency of other users (e.g., other companies) and assign flags.

[0069] Highlighting displays an option in a way that distinguishes it from other less important options. This may include indicating importance, changing the color, or changing the font size. Standalone display shows only the most important option, hiding other less important options. The hidden options may be revealed in response to user input.

[0070] Furthermore, highlighting or displaying some of the most important options independently may also be applied to multiple options in the item setting acceptance step S12 (collected value setting screen 70 in Figure 6, reference value setting screen 80 in Figure 7) and the summary sheet layout setting step S17 in Figure 4.

[0071] Once the layout settings are complete, the processor 10 generates a submission format with tags entered in each input field 51, in order to read actual values ​​from the personnel information DB3 when generating the workforce planning sheet 50 for distribution (step S14), and as a preprocessing step for saving the input information to the input fields 51 later (step S16). Figure 10 shows an example of the submission format 100.

[0072] In the submission format 100, the collected values ​​table 105 has pre-prepared collected value saving tags 101 set in the fields corresponding to each input field in the collected values ​​table 55 of the workforce planning sheet 50 generated in step S14. In addition, the reference values ​​table 106 has personnel information linking tags 102 set in the fields corresponding to each field in the reference values ​​table 56 of the workforce planning sheet 50. The processor 10 generates the submission format 100 with the tags 101 and 102 set for saving collected values ​​and retrieving personnel information, and stores it along with the layout.

[0073] The layout of the personnel planning sheet 50 may be common to all departments, or it may be different for each department. In other words, different personnel planning sheets 50 may be created for each department. In this case, the required number of layouts (and personnel planning sheets 50) can be easily generated by performing the process in step S13 the required number of times.

[0074] In step S14, when the processor 10 receives an instruction from the HR person to output the workforce planning sheet 50, it outputs the workforce planning sheet 50 as shown in Figure 3 based on the configured layout (workforce planning sheet output process 12). The workforce planning sheet 50 is generated so that it can be displayed on the display of the terminal 6 of the person in charge of each department, for example, or it is generated as a data file that can be downloaded to the terminal 6 and edited with spreadsheet software on the terminal 6.

[0075] At this time, the tag 101 for saving collected values, which is set in the column of Table 105 of the submitted format 100 described above, is not visible on the workforce planning sheet 50, and the input field 51 is blank. Also, the processor 10 retrieves the necessary personnel information from the personnel information DB3 based on the personnel information linkage tag 102 set in the column of Table 106 of the reference values, and as actual values ​​are obtained, the column 57 is filled with a value as a reference value.

[0076] The workforce planning sheet 50 is generated and output for each department that is required to submit a workforce plan. In the case of multiple workforce planning sheet 50 layouts, the layout of the workforce planning sheet 50 is set for each department before the workforce planning sheet 50 is generated and output.

[0077] In step S15, when the processor 10 receives an instruction from the HR person to distribute the workforce planning sheet 50 to the department person, it performs a distribution process to make the workforce planning sheet 50 generated in step S14 available for department person input on the terminal 6 (workforce planning sheet distribution, acquisition, and saving process 13). For example, the processor 10 may send a notification to each terminal 6 prompting them to download the workforce planning sheet 50 from the workforce planning support system 1 and input the data. Alternatively, the HR person may individually send the downloaded workforce planning sheet 50 from the terminal 5. Alternatively, the data on the workforce planning support system 1 may be displayed on the terminal 6 for input.

[0078] The workforce planning sheets 50 entered by each department are collected by the workforce planning support system 1 by uploading them, for example, from each department's terminal 6 or the HR staff's terminal 5. The workforce planning support system 1 manages whether or not the sheets have been submitted and may display a list so that HR staff can check the progress of submissions. Here, Figure 11 shows an example of the display of the submitted sheet list screen 110. In this way, HR staff can check whether or not the sheets have been submitted using the workforce planning support system 1, so even if there are many departments, the progress of submission of workforce planning sheets 50 can be managed centrally, and reminders can be easily sent to departments that have not yet submitted their sheets.

[0079] In step S16, the processor 10 saves the input information entered in the input fields 51 of the staffing plan sheet 50 submitted by each department as tagged input information 33 in DB22. The tagged input information 33 is information to which the collected value saving tags 101 provided in the submission format 100 in Figure 10 have been attached. In other words, the processor 10 saves the submitted staffing plan sheet 50 as tagged input information 33 rather than saving the sheet itself, thereby reducing the data volume and allowing the data to be reused for later generation of summary sheets.

[0080] After the workforce planning sheet 50 is submitted, a summary sheet is generated by the HR personnel to review the number of personnel, labor costs, etc., based on the workforce planning information submitted from each department. When the processor 10 receives an instruction to generate a summary sheet, it accepts the layout settings for the summary sheet in step S17 (summary sheet generation process 14). That is, the processor 10 generates aggregated data of workforce planning information from the saved tagged input information 33 by allowing the user to select from multiple selectable aggregate values ​​and aggregation axes (accepting selections). The layout settings for the summary sheet are almost the same as in step S13, so a detailed explanation is omitted here. Also, the definition of the aggregate values ​​may be the same as the definition of the collected values ​​set in step S12.

[0081] In step S18, the processor 10 generates a summary sheet 120 based on the configured layout. Figure 12 shows an example of the output of the generated summary sheet 120. In this summary sheet 120, for example, the items to be displayed in each column are set to the period by month, and the items to be displayed in each row are set to the department. Such a summary sheet 120 can be easily generated by obtaining the required tagged input information 33 using the collected value storage tag 101 and aggregating it. The summary sheet 120 is output as a data file that can be edited with, for example, spreadsheet software.

[0082] Human resources personnel can edit the output summary sheet 120 for budget planning. For example, Figure 13 shows an example of data (personnel cost plan values) edited by human resources personnel based on the summary sheet 120. Human resources personnel can calculate the personnel costs for each department using the summary sheet 120 output from the personnel planning support system 1 by multiplying the personnel cost unit price they have by the number of personnel.

[0083] The present invention is not limited to the embodiments described above, and various modifications are possible. For example, although the workforce planning support system 1 was described using an example in which personnel information is obtained from the personnel management system 2 as actual values ​​of workforce planning information, the actual values ​​may be obtained from a database of a system other than the personnel management system 2. The system stores information related to the actual values ​​of workforce planning information, that is, information including data related to people, such as an attendance management system that stores attendance information. Furthermore, the system having this database may be provided by the provider of the workforce planning support system, provided by a party other than the provider of the workforce planning support system, or owned by the system user. [Explanation of symbols]

[0084] 1: Personnel Planning Support System 2: Human Resources Management System 3: Human Resources Information Database (DB) 4: Network 5, 6: Terminals 10: Processor 11: Personnel planning sheet generation process 12: Processing the output of the personnel plan sheet 13: Preservation process 14: Summary Sheet Generation Process 20: Storage device 21: Computer Programs 22: Database (DB) 31: Personnel Planning Sheet Settings Information 32: Tag information for linking personnel information 33: Tagged Input Information 40: Communication Unit 50: Personnel Planning Sheet 60: List display screen 61: New creation button 70: Collection Value Setting Screen 80: Reference value setting screen 90: Layout settings screen 92: List of collected value items 93: List of aggregation axis items 94: Period setting window 95: Column setting area 96: Row setting area 100: Submission format 101: Tag for saving collected values 102: Tag for linking HR information 110: Submission Sheet List Screen 120: Summary Sheet

Claims

1. A staffing plan sheet will be created for each department, which will have input fields for entering staffing plan information related to staffing plans. The aforementioned personnel planning sheet is output in a format that allows each department's terminal to input data into the personnel planning sheet. The completed personnel plan sheets entered using the terminals of each of the aforementioned departments are collected, The personnel plan information in each of the input fields of the completed personnel plan sheet is saved as tagged input information to which a tag for saving collected values ​​indicating the nature of the personnel plan information is assigned. A personnel planning support system equipped with a processor that performs operations including the following.

2. Creating the aforementioned personnel planning sheet includes determining the type of personnel planning information entered in the input fields by having each department select the collected values ​​and aggregation axes from multiple options, and creating different personnel planning sheets for each department. The personnel planning support system according to claim 1.

3. Creating the aforementioned personnel planning sheet includes creating the personnel planning sheet which contains the actual values ​​of the personnel planning information as reference values ​​when entering the personnel planning information into the input fields. The personnel planning support system according to claim 1.

4. Creating the aforementioned personnel planning sheet includes retrieving the relevant information from a database that stores information including information related to the actual values ​​of the personnel planning information, and generating the actual values, Acquiring the aforementioned related information includes associating the personnel plan information entered in the input field with information pre-selected from the information stored in the database as information that can be acquired when generating the aforementioned actual values, and acquiring the aforementioned related information based on the association. The personnel planning support system according to claim 3.

5. Creating the aforementioned personnel planning sheet includes setting the tags for saving the collected values ​​in the input fields, Saving the tagged input information includes saving the numerical values ​​entered in the input field to which the tag for saving collected values ​​has been assigned. The personnel planning support system according to claim 1.

6. The operation further includes generating aggregated data of the personnel planning information from the saved tagged input information by allowing the user to select from multiple options a plurality of aggregate values ​​and aggregation axes. The personnel planning support system according to claim 1.

7. The personnel planning support system according to claim 2 or 6, wherein the plurality of options include highlighting or displaying separately the options that are flagged to indicate their importance.

8. A staffing plan sheet will be created for each department, which will have input fields for entering staffing plan information related to staffing plans. The aforementioned personnel planning sheet is output in a format that allows each department's terminal to input data into the personnel planning sheet. The completed personnel plan sheets entered using the terminals of each of the aforementioned departments are collected, The personnel plan information in each of the input fields of the completed personnel plan sheet is saved as tagged input information to which a tag for saving collected values ​​indicating the nature of the personnel plan information is assigned. Methods for supporting staffing planning.

9. A staffing plan sheet will be created for each department, which will have input fields for entering staffing plan information related to staffing plans. The aforementioned personnel planning sheet is output in a format that allows each department's terminal to input data into the personnel planning sheet. The completed personnel plan sheets entered using the terminals of each of the aforementioned departments are collected, The personnel plan information in each of the input fields of the completed personnel plan sheet is saved as tagged input information to which a tag for saving collected values ​​indicating the nature of the personnel plan information is assigned. A computer program that causes a computer to perform an action that includes a certain condition.

Images