Departmental working time analysis program
The departmental actual working time analysis program and method accurately track actual working hours and department-specific work, addressing the challenge of inefficiencies in existing systems by providing precise data for workforce planning and profitability improvements.
Patent Information
- Application Number
- JP2020050389
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2020-03-21
- Publication Date
- 2024-11-01
- Estimated Expiration
- 2040-03-21
AI Technical Summary
Existing systems fail to accurately determine the actual working hours and department-specific work of employees, making it difficult to provide effective feedback for improving profitability in retail store staffing.
A departmental actual working time analysis program and method that records and processes departmental, personnel, and scheduled data to accurately determine actual working hours and department-specific work by analyzing overlaps and adjacencies in scheduled and actual working time data.
Enables precise tracking of actual working hours and department-specific work, facilitating efficient workforce planning and profitability improvements by accurately grasping the actual working hours of each department.
Smart Images

Figure 0007576818000001 
Figure 0007576818000002 
Figure 0007576818000003
Abstract
Description
[Technical field]
[0001] The present invention relates to a department actual work time analysis program. [Background technology]
[0002] When considering the daily staffing of retail stores such as supermarkets, it is extremely important to assist in personnel adjustments and improve profitability by calculating the number of employees required in each department, relative to the number of employees required.
[0003] For example, as a technique for creating man-hour productivity, which is one index for measuring profitability, for example, Patent Document 1 below discloses a technique related to a work schedule table creation program. [Prior art documents] [Patent documents]
[0004] [Patent Document 1] JP 2001-76049 A Summary of the Invention [Problem to be solved by the invention]
[0005] However, even if a business schedule is created as described above, profitability can only be improved by taking the difference from the actual work and applying feedback to the original business schedule. However, the above technology still has problems with the feedback.
[0006] In order to actually provide feedback, it is necessary to know the actual working hours of each employee by department.
[0007] However, it is extremely difficult to know how much work each employee actually did in which department using the systems currently in general use. Specifically, the so-called time card is generally used as a means of knowing the working hours of each employee, but this time card only inputs the employee's identification and the working hours, and does not include information about how much work the employee did in which department. Therefore, it is difficult to accurately know the actual working hours for each department as described above.
[0008] In view of the above-mentioned problems, an object of the present invention is to provide a department actual working time analysis program and a department actual working time analysis method that can grasp the actual working time of each department as accurately as possible. [Means for solving the problem]
[0009] A department actual working time analysis program according to one aspect of the present invention that solves the above-mentioned problems causes a computer to execute the steps of recording multiple department data, recording personnel planning data including personnel data, scheduled working time data and scheduled working department data that correspond to the personnel data, recording actual working time data, and recording department actual working data for each department data based on the personnel planning data and the actual working time data.
[0010] Also, in this respect, although not limited thereto, it is preferable that in the step of recording department actual work data for each department data based on the personnel planning data and the actual working hour data, for any overlapping portion between the planned working hour data of the personnel planning data and the actual working hour data, the planned working department data of the overlapping portion is included in the department actual work data.
[0011] Furthermore, in the above, although not limited thereto, it is preferable that the step of recording department actual work data for each department data based on the personnel planning data and the actual working hour data, for portions where the planned working hour data of the personnel planning data and the actual working hour data do not overlap, the adjacent planned working department data of the overlapping portions of the planned working hour data of the personnel planning data and the actual working hour data is included in or removed from the department actual work data.
[0012] Furthermore, in the above, although not limited thereto, when there are two adjacent planned working department data in the overlapping portion of the planned working time data and actual working time data in the personnel planning data, it is preferable to select one of the planned working department data.
[0013] In addition, in this respect, although not limited thereto, it is preferable to have a step of displaying department actual operation data and sales data on a display device.
[0014] In addition, a department actual working time analysis method according to another aspect of the present invention includes the steps of recording a plurality of department data, recording personnel planning data including personnel data, scheduled working time data and scheduled working department data corresponding to the personnel data, recording actual working time data, and recording department actual working data for each department data based on the personnel planning data and the actual working time data. Effect of the Invention
[0015] As described above, the present invention can provide a department actual work time analysis program and a department actual work time analysis method that can grasp the actual work time for each department as accurately as possible. [Brief description of the drawings]
[0016] [Figure 1] FIG. 1 is a diagram showing an outline of a flow of a department actual working time analysis method according to an embodiment. [Diagram 2]11 is a diagram showing the relationship between department data values and corresponding departments in a specific example of a department actual working time analysis method according to an embodiment. FIG. [Diagram 3] 13 is an image diagram of personnel planning data displayed on a display device in a specific example of a department actual working time analysis method according to an embodiment. FIG. [Figure 4] 13 is an image diagram of actual work time data displayed on a display device in a specific example of a department actual work time analysis method according to the embodiment. FIG. [Diagram 5] 11 is an image diagram of one of the determination processes of the department actual working time analysis method according to the embodiment. FIG. [Figure 6] 11 is an image diagram of one of the determination processes of the department actual working time analysis method according to the embodiment. FIG. [Figure 7] 11 is an image diagram of one of the determination processes of the department actual working time analysis method according to the embodiment. FIG. [Figure 8] 13 is an image diagram showing sales and actual working hours for each department displayed by the department actual working time analysis method according to the embodiment. FIG. BEST MODE FOR CARRYING OUT THEINVENTION
[0017] Hereinafter, the embodiments of the present invention will be described in detail with reference to the drawings. However, the present invention can be embodied in many different forms, and the specific examples described in the following embodiments and examples can be appropriately modified and adjusted, and the present invention is not limited thereto.
[0018] (Departmental working time analysis program) The department actual working time analysis program according to this embodiment (hereinafter referred to as "this program") causes a computer to execute the steps of (S1) recording a plurality of department data, (S2) recording personnel planning data including personnel data, scheduled working time data and scheduled working department data corresponding to the personnel data, (S3) recording actual working time data, and (S4) recording department actual working data for each department data based on the personnel planning data and the actual working time data. Figure 1 shows an outline of the flow of the method executed by this program.
[0019] (Method of analyzing departmental actual working hours) As described above, this program is executed by an information processing device, i.e., a computer, and is specifically stored in a recording medium such as a computer's hard disk, and is read into a volatile recording medium such as a memory and executed as necessary. That is, by being executed by a computer, this program can realize a department actual work time analysis method (hereinafter, the department actual work time analysis method according to this embodiment will be simply referred to as "this method") having the steps shown in the above figure: (S1) recording a plurality of department data, (S2) recording personnel planning data including personnel data, scheduled working time data and scheduled working department data corresponding to the personnel data, (S3) recording actual working time data, and (S4) recording department actual work data for each department data based on the personnel planning data and the actual working time data.
[0020] The computer used to execute this program is not limited as long as it has the above functions, but it is preferable that the computer include, for example, a central processing unit (CPU), which is a component of a general computer, a non-volatile recording medium such as a hard disk or flash memory, a volatile recording medium such as memory, a bus connecting these, input devices such as a keyboard or mouse, and a display device such as a monitor, but is not limited to these.
[0021] Next, each step of the method executed by the program will be described in detail. The method can be effectively used in, but is not limited to, an organization such as a supermarket that manages multiple personnel in multiple departments and transfers personnel between the departments when there is a shortage or surplus of personnel. Specifically, the method is suitable for an organization that has multiple departments, each of which makes a personnel plan, while managing the attendance of employees using a device that records the time of arrival and departure such as a time recorder (time attendance recording device) (when the time attendance recording device does not input information such as which department the work was performed in). More specifically, a typical department to which the method can be applied is an organization that has a fresh fish department, a meat department, a fruit and vegetable department, a prepared food department, a grocery department, a daily necessities department, a cashier department, a daily delivery department, etc. in a supermarket, each of which employs multiple personnel, and transfers personnel between these departments when there is a shortage or surplus of personnel. However, the method is not limited to this. However, in order to make the method easier to understand, a specific example (hereinafter referred to as "this specific example") will be used to explain the method, in which a supermarket has eight departments: fresh fish, meat, vegetables, prepared foods, groceries, daily necessities, cashier, and daily necessities. Other examples of organizations that manage personnel other than the supermarket in multiple departments and accommodate personnel shortages between departments include, but are not limited to, factories, amusement parks, aquariums, zoos, and museums.
[0022] In the above context, the method includes a step of recording a plurality of department data (S1). Here, a "department" means, for example, a unit (group) divided according to its function or business content within an organization, and corresponds to a business execution unit such as the fresh fish department in the above-mentioned specific example. The "department data" is data including information on the type of the department, and exists in the same number as the number of departments that the organization has. Specifically, the type of department is specified according to the value of the "department data". In this specific example, it is possible to determine whether the department is a fresh fish department, a meat department, a fruit and vegetable department, a prepared food department, a grocery department, a daily necessities department, a cash register department, or a daily necessities department according to the value of the department data. In other words, "recording a plurality of department data" means that an organization has a plurality of departments, and data including information on the type of each of the departments is recorded. FIG. 2 shows an example of the relationship between the value of the department data and the corresponding department.
[0023] This method also includes a step of (S2) recording personnel planning data including personnel data, and scheduled working hours data and scheduled working department data that are provided in correspondence with the personnel data. An image of the planned personnel allocation data displayed on a display device is shown in FIG. 3.
[0024] In this method, "personnel" refers to employees working in an organization for which this method is implemented. Personnel may be full-time employees, part-time employees, or part-time employees, and may be part-time or part-time employees, regardless of their employment status. The "personnel data" is data including information on the above personnel, and preferably includes, for example, identification data including information for identifying individuals, such as the employee number of the personnel, and name data including information on the name. In addition, the "personnel data" may include, but is not limited to, employment status data including information on the employment status, such as whether the employee is a full-time employee, part-time employee, or part-time employee, contracted working days data including information on the number of working days and working hours if such information is set by contract, and gender data including information on gender. Furthermore, it is also preferable to include department data in the personnel data. Here, "department" refers to the department to which the employee belongs, and by including department data in the personnel data, it is possible to grasp which department the employee belongs to, and it is possible to efficiently make a personnel plan based on the department, and it is also possible to use it when allocating work that is not included in the personnel plan, as will become clear from the description below. In this diagram, Mr. Ichiro Yamada is shown as an example of a department to which he belongs, the Fresh Fish Department. Depending on the organization, it is possible that a person may be registered across multiple departments, so it is useful to set up a temporary department called the Multi-Department to which these people belong, so that they can be utilized without belonging to a specific department and can belong to multiple departments.
[0025] The number of personnel, or the number of personnel data in this method, is not limited and may be 1, but the more the number, the more effective the department actual work time analysis using this method will be. Specifically, it is preferable that the number is 10 or more, and more preferably 50 or more.
[0026] As described above, this method also includes scheduled working hours data corresponding to personnel data. "Scheduled working hours" refers to the time that a person is scheduled to work, and of course includes information regarding the date. "Scheduled working hours data" is data that includes information regarding this scheduled working hours. In the example shown in this figure, this means that Yamada Ichiro is scheduled to work from 8:00 to 12:00 and from 13:00 to 18:00.
[0027] As described above, this method includes scheduled work department data that is recorded in correspondence with personnel data. The "scheduled work department" refers to the department in this specific example where the personnel is scheduled to work, and the "scheduled work department data" is data that includes information to be transferred to this scheduled work department. In other words, by setting the scheduled work department, it is possible to set which department the personnel will work in during that working time. In the example shown in this figure, Yamada Ichiro works in his original department, the fresh fish department, from 8:00 to 12:00, and works as a helper in the meat department from 13:00 to 18:00.
[0028] It is also preferable that the scheduled work department data includes scheduled work content data. "Scheduled work content" refers to the work content, such as the type of work to be performed in that department, and scheduled work content data includes information regarding this scheduled work content. By including scheduled work content data in this way, it is possible to make more detailed personnel plans, such as which work content will be performed and to what extent. In the example shown in this figure, for example, Yamada Ichiro will be stocking the fresh fish department from 8:00 to 12:00, and will be stocking or taking inventory in the meat department from 13:00 to 18:00.
[0029] As is clear from the above configuration, the personnel planning data is data containing information on personnel allocation plans, such as which departments the personnel assigned to each department will work on and for how long when there are multiple departments in one organization. The user of this method creates and records personnel planning data as a prerequisite for implementing the department actual work time analysis method. By creating this data, it becomes possible to grasp the actual personnel allocation by referring to the actual work time data described below. In the example of this figure, attention is focused on the scheduled work content of each person, and the display is made from the perspective of how much work each person will do in each department. Depending on the organization, work content may be assigned to each department, and the display may be made to assign personnel to work on that work. In this way, for example, if a certain person works in multiple departments in a day, only a part of the work of the person is displayed, and it may be difficult to understand the entire work plan for the day at a glance. However, it goes without saying that this is simply a different display method, and there is no difference in the correspondence between the scheduled work department, the scheduled work time, and even the personnel.
[0030] This method also includes a step (S3) of recording actual working hours data. Actual working hours refer to the hours that personnel actually work, and "actual working hours data" refers to data including information on actual working hours (hours actually worked). As described above, it would be ideal for personnel planning to proceed according to the initial schedule, but it is natural that there will be excess or shortage of work in actual operations, and adjustments to working hours, such as early arrival, overtime, or early departure, will be required to accommodate such excess or shortage. By accurately understanding these adjustments, it will be possible to create more efficient personnel planning in the future.
[0031] As is clear from the above description, actual working hours data is provided for each personnel data, and actual working hours data exists corresponding to the personnel data. This allows you to understand who is actually working and how much. Figure 4 shows an image of actual working hours data displayed on a display device. In this figure, the upper part shows the personnel planning data for a specific person, and the lower part shows the actual working hours data. In the example of this figure, Ichiro Yamada was originally scheduled to work in the fresh fish department from 8:00 to 12:00 and in the meat department from 13:00 to 17:00, but in reality he came to work from 9:00, worked until 12:30, worked again from 13:00 to 15:30, took a 30-minute break, and worked until 19:00. In this way, there is often a discrepancy between the actual work and the personnel plan.
[0032] However, in this method, the actual working time data does not include data including information on the work content actually performed (actual work content data) or data including information on the department where the person actually worked (actual working department data), and these data are not provided correspondingly. The actual working time is generally obtained from the attendance record by a so-called time card device, in which the person is identified and only the start time and end time of the person's work are input. In other words, the only data that can be obtained by this time card device are the person data and the actual working time data regarding the time that the person data actually worked. It is certainly possible to obtain information on the actual working time, the actual work content (actual work content), and the department where the person actually works (actual working department) by installing a sensor or the like in the facility of the organization and identifying the person with the sensor and extracting information on the work content and the department in charge of the work. However, it is actually impossible to install such a sensor in terms of cost-effectiveness, and there are many problems in thoroughly monitoring the person. Therefore, at present, it is extremely difficult to include the actual work content data and the actual working department data in the actual working time data or to record them correspondingly.
[0033] Therefore, this method includes a step of (S4) recording department actual work data for each department data based on the personnel planning data and the actual working hours data. Here, "department actual work data" is data provided corresponding to each department data, and is data including information on how much work was actually done in the department, and more specifically, is data including information on time or man-hours.
[0034] As described above, in an organization where this method is implemented, if actual work is performed according to the personnel planning data initially created, there will be no difference between the department actual work data calculated by the personnel planning data and the department actual work data resulting from the actual work of personnel. However, as described above, in reality, work is rarely performed according to the initial personnel planning data, and deviations inevitably occur. And, as described above, currently available data are only personnel data and the corresponding actual working time data recorded, and the actual working department data does not include actual working department data or actual work content data. Therefore, in reality, it is difficult to obtain department actual work data from actual working time data. However, by using this step, department actual work data can be obtained by referring to the personnel planning data and actual working time data. A specific description will be given below.
[0035] Fig. 5 is a diagram explaining one of the processes for determining the actual working department in this step. Like the previous figure, this figure is an image diagram of the actual working hours data displayed on a display device, with the upper part showing personnel planning data for a specific person, and the lower part showing the actual working hours data.
[0036] In this determination process, first, the overlapping parts of the scheduled working time data and the actual working time data in the personnel planning data are considered, and the scheduled working department data of the overlapping parts is included in the department actual work data. Since there is no difference between this part and the actual work, there is no problem in calculating it as the department actual work data. In the specific example of this figure, for example, there are overlapping parts between the scheduled working time data and the actual working time data in the personnel planning data from 9:00 to 12:00, from 13:00 to 15:30, and from 16:00 to 18:00. And, since the scheduled working department data in the personnel planning data indicates fresh fish from 9:00 to 12:00, this overlapping time is calculated as the department actual work data of the fresh fish department. Also, since the meat department is the scheduled working department data from 13:00 to 15:30 and from 16:00 to 18:00, this is calculated as the department actual work data of the meat department. This makes it possible to first determine the department in the overlapping parts. If this process were not implemented, the work done in the department to which the employee belongs would be judged as department actual work data as it is, but the inclusion of this process has the advantage of eliminating this risk.
[0037] Next, Fig. 6 is a diagram explaining one of the processes for determining the actual working department in this step. Like the previous figure, this figure is an image diagram of actual working time data displayed on a display device, with the upper part showing personnel plan data for a specific person, and the lower part showing the actual working time data.
[0038] In this determination process, for the non-overlapping portion (non-overlapping portion) of the planned working time data of the personnel planning data and the actual working time data, the department data (scheduled working department data) determined in the adjacent portion is determined to be the department data, and the time of the actual working time data in the non-overlapping portion (non-overlapping portion) is included in the department actual work data. Specifically, while the actual working time data shows that work is actually performed between 12:00 and 12:30, that time does not exist in the personnel planning data. Therefore, as it is, it is unclear which department is working. However, since the overlapping portion adjacent to this time has already been determined to be the fresh fish department, the department at this time is also determined to be the fresh fish department, and this actual working time portion of the fresh fish department is included in the department actual work data. In addition, there is no overlap between the personnel planning data and the actual working time data from 18:00 to 19:00. However, since the portion adjacent to this actual working time data (from 16:00 to 18:00) has already been determined to be the cash register department, this portion is also determined to be the meat department, and that portion is included in the department actual work data. This makes it possible to obtain departmental actual work data using only manpower planning data and actual working hours data.
[0039] Incidentally, in the above example, there is only one adjacent part, but there is also the possibility that there are two adjacent parts. An image of such a case is shown in Figure 7. This figure shows Yamada Ichiro's personnel planning data and his actual working hours data. In the example shown in this figure, the initial personnel planning data shows that he was in the fresh fish department from 8:00 to 12:00 and the meat department from 13:00 to 17:00, but the actual working hours data shows that he worked from 8:00 to 14:00 and again from 15:00 to 17:00.
[0040] In this case, the above-mentioned determination process can be performed for the overlapping parts. On the other hand, there is no overlap between 12:00 and 13:00, and since these are consecutive shifts, the two departments are adjacent to each other: the fresh fish department, which is determined from 8:00 to 12:00, and the produce department, which is determined from 13:00 to 14:00. In such a case, it is difficult to determine which is correct, but it is preferable to select one of the departments. In this case, although not limited to this, it is generally natural to think that the work in the previous time period has been prolonged, so in the previous time period, in the example of this figure, it can be considered that the work in the fresh fish department has been prolonged, so it is determined that it is the fresh fish department, and that time portion is included in the department actual work data. This makes it possible to determine the department for either pattern.
[0041] The department performance data is then calculated for each employee and then combined to obtain the total department performance data.
[0042] Also, from this viewpoint, although not limited thereto, it is preferable to have a step of displaying department actual work data and sales data on a display device. In this way, it becomes possible to compare personnel planning data, department actual work data, and sales data, and to carry out more efficient management. An image of this case is shown in Figure 8. In this figure, the horizontal axis shows time, and the vertical axis shows department actual work data (left bar), personnel planning data (right bar), and sales, respectively.
[0043] As described above, the present invention can provide a department actual work time analysis program and a department actual work time analysis method that can grasp the actual work time for each department as accurately as possible. [Industrial Applicability]
[0044] INDUSTRIAL APPLICABILITY The present invention has industrial applicability as a department actual working time analysis program and a department actual working time analysis method.
Claims
1. On the computer, recording a plurality of department data; A step of recording personnel planning data including personnel data, scheduled working time data corresponding to the personnel data, and scheduled working department data corresponding to each time of the scheduled working time data; recording actual working time data corresponding to the personnel data; a step of recording department actual work data for each of said department data based on said manpower planning data and said actual working time data.
2. The step of recording department actual work data for each department data based on the manpower planning data and the actual working time data includes:
2. The department actual working time analysis program according to claim 1, wherein an overlapping portion between said scheduled working time data and said actual working time data of said personnel planning data is included in said department actual working data of said department data corresponding to said scheduled working department data.
3. The step of recording department actual work data for each department data based on the manpower planning data and the actual working time data includes:
3. A department actual working time analysis program as described in claim 2, wherein the non-overlapping portion of the planned working time data and the actual working time data of the personnel planning data is included in the department actual working data of the department data corresponding to the planned working department data in the overlapping portion adjacent to the non-overlapping portion.
4. The step of recording department actual work data for each department data based on the manpower planning data and the actual working time data includes:
4. A department actual work time analysis program as claimed in claim 3, wherein when there are two adjacent overlapping parts, the department data corresponding to the scheduled working department data in either one of the overlapping parts is selected and included in the department actual work data of that department data.
5. 2. The department actual work time analysis program according to claim 1, further comprising a step of displaying the department actual work data and sales data on a display device.
6. A computer comprising: recording a plurality of department data; A step of recording personnel planning data including personnel data, scheduled working time data corresponding to the personnel data, and scheduled working department data corresponding to each time of the scheduled working time data; recording actual working time data corresponding to the personnel data; a step of recording department actual work data for each of the department data based on the manpower planning data and the actual working time data.
Citation Information
Patent Citations
Recording medium recording job schedule table generation program
JP2001076049A
Attendance management system
JP2007323267A
Behavior analyzing device and IP telephone system
JP2008234184A
Work plan data creation program and work plan data creation method
JP2019133374A
Employee time entry and accounting system
US5459657A
