JP2018160113A - Work shift management device and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To reduce a labor of creation of an attendance shift.SOLUTION: A CPU 11 of a server 10 derives a work schedule in which excess and deficiency of workers are predicted based on assumed shift information indicating the work schedule and the number of workers required for each skill and work shift information indicating the past work schedule and the number of workers for each of the skills, and displays an operation assumed shift input screen that can discriminate the derived work schedule in which the excess and deficiency of the workers are predicted on a display 24.SELECTED DRAWING: Figure 1

Description

  The present invention relates to a work shift management device and a program.

  Traditionally, in stores that employ part-time or part-time employees, the employee's attendance shift for managing the store is created in consideration of the desired shift submitted by each employee and the skills of each employee. A system for doing this is known (see, for example, Patent Document 1).

JP 2006-268722 A

  However, with the conventional technology, even if the time shift is created in consideration of each employee's desired shift and skill, if there is a difference from the assumed shift required for store operation, the employee's convenience is considered. It was necessary to make adjustments, and it took time and effort before the final work shift was completed.

  The subject of this invention is made | formed in view of such a problem, and it aims at reducing the effort of preparation of attendance shift.

  In order to solve the above-described problem, according to one aspect of the present invention, the work shift management device includes assumed shift information indicating the work hours and the number of workers required for each skill, and past work hours. Based on work shift information indicating the number of workers for each skill, deriving means for deriving a working time zone in which worker overs and shorts are predicted, and excess or shortage of workers derived by the deriving means Display control means for causing the display means to display an assumed shift table capable of identifying the working hours during which the estimated work hours are predicted.

  Further, according to another aspect of the present invention, the program causes the computer to assume shift information indicating the working hours and the required number of workers for each skill, and the past working hours and the workers for each skill. Deriving means for deriving a working time zone in which the worker's excess or deficiency is predicted based on the work shift information indicating the number, and working hours predicted by the deriving means for the worker's excess or deficiency It is a program for causing a display control unit to display an assumed shift table capable of identifying a band on a display unit.

  According to the present invention, it is possible to reduce time and effort for creating a time shift.

It is a block diagram which shows the structure of an attendance shift management system. It is an example which shows the structure of a worker information table. It is an example which shows the structure of a management assumption shift table. It is an example which shows the structure of a desired shift table. It is an example which shows the structure of the allocated shift table. It is an example which shows the structure of an excess / deficiency table. It is an example of a management assumption shift input screen. It is an example of an allocation result screen. It is an example of a worker information screen. It is an example of a desired shift input screen. It is an example of a desired shift input screen. It is a flowchart which shows the outline | summary of operation | movement of a work shift management system. It is a flowchart which shows a management assumption shift registration process. It is a flowchart which shows a desired shift registration process. It is a flowchart which shows a shift allocation process. It is a flowchart which shows a shift adjustment process.

  Embodiments according to the present invention will be described below in detail with reference to the accompanying drawings. The present invention is not limited to the illustrated example.

[1. Configuration of work shift management system]
First, the configuration of the work shift management system of the present embodiment will be described.
FIG. 1 is a block diagram showing a work shift management system 1 according to the present embodiment.
The work shift management system 1 is a system for assisting managers such as managers of retail stores and restaurants to create work shifts for managing working days of employees including part-time workers and parts. It is.

  The work shift management system 1 includes a server 10 as a work shift management device and a plurality of terminal devices 20. Each device of the work shift management system 1 is connected to a communication network N.

  The server 10 is a server device in the cloud of the communication network N, and stores and manages information related to employee work shifts. The server 10 is configured by one unit, but is not limited to this, and may be configured by a plurality of devices.

  The terminal device 20 is a device that the administrator and each employee possess and use as a user. The terminal device 20 is a mobile terminal such as a tablet PC, a notebook PC, or a smartphone, and can be connected to the communication network N by wireless communication. For this reason, the terminal device 20 can be used anytime and anywhere by the administrator and employees.

  The communication network N is assumed to be the Internet, and may include a WAN (Wide Area Network), a LAN (Local Area Network), a dedicated line, and the like.

  In addition, in FIG. 1, although the terminal device 20 with which the work shift management system 1 was equipped is illustrated by one unit, the work shift management system 1 has a plurality of terminal devices respectively owned by an administrator and a plurality of employees. 20 and the server 10 is configured to manage the information of the manager and all employees. Further, it is assumed that an application that realizes functions such as creation of an assumed operation shift necessary for the operation of a store or the like and confirmation of the determined work shift is installed in the terminal device 20 of the manager. Also, it is assumed that an application that realizes functions such as submission of a desired work shift (desired shift) and confirmation of the determined work shift is installed in each terminal device 20 of the employee.

Next, the functional configuration inside the server 10 will be described.
The server 10 includes a CPU (Central Processing Unit) 11 serving as a derivation unit, a second derivation unit, a display control unit, a second display control unit, a third display control unit, a work shift creation unit, and an extraction unit, A unit 12, a RAM (Random Access Memory) 13, a display unit 14, a storage unit 15, and a communication unit 16 are provided. Each part of the server 10 is connected via a bus 17.

  The CPU 11 controls each unit of the server 10. The CPU 11 reads a designated program out of the system program and application program stored in the storage unit 15 and expands it in the RAM 13 and executes various processes in cooperation with the program.

  The operation unit 12 includes a key input unit such as a keyboard and a pointing device such as a mouse, receives key input and position input, and outputs the operation information to the CPU 11.

  The RAM 13 is a volatile memory, and forms a work area for temporarily storing various data and programs. The display unit 14 includes an LCD (Liquid Crystal Display), an EL (ElectroLuminescence) display, and the like, and performs various displays according to display information instructed by the CPU 11.

  The storage unit 15 includes a hard disk drive (HDD), a solid state drive (SSD), and the like, and is a storage unit that can write and read data and programs. In particular, the storage unit 15 includes an operation assumed shift registration program 151, a desired shift registration program 152, a shift assignment program 153, a shift adjustment program 154, an operator information table T1, an operation assumed shift table T2, which will be described later, The desired shift table T3, the allocated shift table T4, and the excess / deficiency table T5 are stored.

  The communication unit 16 is configured by a network card or the like, is connected to the communication network N, and communicates with devices on the communication network N. The CPU 11 can communicate with the terminal device 20 on the communication network N via the communication unit 16.

Next, the functional configuration of the terminal device 20 will be described.
The terminal device 20 includes a CPU 21, an operation unit 22, a RAM 23, a display unit 24, a storage unit 25, and a wireless communication unit 26. Each unit of the terminal device 20 is connected via a bus 27.

  Since the CPU 21, RAM 23, and display unit 24 are the same as the CPU 11, RAM 13, and display unit 14 of the server 10, overlapping descriptions are omitted, and different portions are mainly described.

  The CPU 21 controls each unit of the terminal device 20.

  The operation unit 22 has a touch panel provided on the display screen of the display unit 24, receives a touch input from the user, and outputs the operation information to the CPU 21.

  The storage unit 25 is configured by a flash memory, an EEPROM (Electrically Erasable Programmable ROM), or the like, and is a storage unit that can write and read data and programs.

  The wireless communication unit 26 includes an antenna, a modulation / demodulation circuit, a signal processing circuit, and the like, and transmits / receives information to / from a base station, an access point, and the like on the communication network N by radio waves. Therefore, the CPU 21 can communicate with the server 10 by the wireless communication unit 26 via a base station, an access point, etc. on the communication network N.

  Next, various tables stored in the storage unit 15 of the server 10 will be described with reference to FIGS.

FIG. 2 is a diagram illustrating a configuration of the worker information table T1.
As shown in FIG. 2, the worker information table T1 includes items of “worker name” T11, “skill (role)” T12, “telephone number” T13, and “mail” T14.
The information (worker information) of each item in the worker information table T1 is transmitted from the administrator's terminal device 20 at an arbitrary timing (for example, when the worker is officially hired), and the worker information table Registered in T1.

  “Worker name” T11 is the name of the employee. “Skill (role)” T12 is a skill held by the employee. “Telephone number” T13 is the telephone number of the employee. “Mail” T14 is an employee's mail address.

FIG. 3 is a diagram showing a configuration of the operation assumed shift table T2.
As shown in FIG. 3, the assumed operation shift table T2 has items of “day” T21, “time” T22, “skill (role)” T23, and “number of people” T24.
In addition, information (assumed shift information) of each item of the operation assumed shift table T2 is registered in the operation assumed shift table T2 by an operation assumed shift registration process described later.

  “Day” T21 is the date of the day on which work occurs (estimated operation date). “Time” T22 is a time when work occurs. “Skill (role)” T23 is a skill (role) of an operator necessary for operation. “Number of persons” T24 is the number of workers required for operation.

FIG. 4 is a diagram showing the configuration of the desired shift table T3.
As shown in FIG. 4, the desired shift table T3 includes items of “worker name” T31, “day” T32, “time” T33, “input date and time” T34, “assigned flag” T35, and “incentive flag” T36. Have
Information on each item (desired shift information and work shift information) in the desired shift table T3 is registered in the desired shift table T3 by a desired shift registration process described later.

  “Worker name” T31 is the name of the employee. “Day” T32 is a date of a work day desired by the employee. “Time” T33 is a working time desired by the employee. The “input date / time” T34 is the date / time when the desired shift information is registered. The “assigned flag” T35 is a flag indicating that the employee has already been assigned to the work shift. The “incentive flag” T36 is a flag indicating that an incentive has occurred.

FIG. 5 is a diagram illustrating a configuration of the allocated shift table T4.
As shown in FIG. 5, the allocated shift table T4 has items of “day” T41, “time” T42, “skill (role)” T43, and “worker name” T44.
Note that information (work shift information) of each item in the allocated shift table T4 is registered in the allocated shift table T4 by a shift allocation process described later.

  “Day” T41 is a date assigned to the work shift. “Time” T42 is a working time assigned to the work shift. “Skill (role)” T43 is the skill of the operator used in the assigned work shift. “Worker name” T44 is the name of the employee.

FIG. 6 is a diagram showing the configuration of the excess / deficiency table T5.
As shown in FIG. 6, the excess / deficiency table T5 has items of “day” T51, “time” T52, “skill (role)” T53, “insufficient number” T54, and “surplus number” T55.
The information (work shift information) of each item in the excess / deficiency table T5 is registered in the excess / deficiency table T5 by a shift adjustment process described later. In other words, after the work shift is created (at the stage where the shift assignment process and the shift adjustment process are completed), it is registered when the number of workers is excessive or insufficient.

  “Day” T51 is a date on which there is an excess or shortage of employees. “Time” T52 is a time when there is excess or shortage of employees. “Skill (role)” T53 is a skill with excess or deficiency. The “insufficient number” T54 is the number of workers who are insufficient. “Surplus number” T55 is the number of workers who wished but did not enter the work shift.

  Next, various screens displayed on the display unit 24 of the administrator's terminal device 20 will be described with reference to FIGS.

FIG. 7A is an example of an assumed operation shift input screen G1.
The assumed operation shift input screen G1 is an input screen used by the administrator to create an assumed operation shift.

As shown in FIG. 7A, the assumed operation shift input screen G1 has a “date display field” G11 and an “assumed number of people input table” G12.
In the “date display field” G11, the date of the expected operation date is displayed.
The “assumed number of people input table” G12 has a time division field 101 on the first line, and input fields 102a, 102b, 102c, and 102d for each skill on the second and subsequent lines. In addition, reference information display columns 103a, 103b, 103c, and 103d are provided corresponding to the input columns 102a, 102b, 102c, and 102d, respectively.

  The time division column 101 shows time divisions at predetermined intervals (here, every hour).

The input fields 102a, 102b, 102c, and 102d are input fields provided corresponding to different skills, respectively, and are provided with a plurality of cells corresponding to the time segments in the time segment column 101. Each cell is assumed to be necessary for operation. The number of people is entered.
In each cell, the cell color (background color) is changed when the desired number of people has been smaller than the assumed number of people on the same day in the past (shaded area in FIG. 7A).

The reference information display columns 103a, 103b, 103c, and 103d have a plurality of cells corresponding to the cells in the input columns 102a, 102b, 102c, and 102d, and input the assumed number of people in the cells in the input columns 102a, 102b, 102c, and 102d. At this time, past data for reference is displayed.
The past data is “actual value” and “insufficient value”.
The “actual value” is an average value of the number of people as a result of shift assignment in the same day of the week and at the same time. Specifically, it is an average value of the number of workers of the same skill acquired from the same day of the week and the same time with reference to the information of the assigned shift table T4 (FIG. 5).
The “insufficient value” is an average value of the number of persons who are insufficient as a result of the shift assignment at the same time and the same time in the past. Specifically, it is an average value of the shortage numbers of workers of the same skill acquired from the same day of the week and the same time with reference to the information of the “shortage number” T54 of the excess / deficiency table T5 (FIG. 6).

  The administrator refers to the input columns 102a, 102b, 102c, and 102d while referring to the cell colors in the input columns 102a, 102b, 102c, and 102d and the data displayed in the reference information display columns 103a, 103b, 103c, and 103d. The expected number of people corresponding to the time and skill can be input.

In addition, when the values entered in the cells of the input fields 102a, 102b, 102c, and 102d are less than the number of people entered on the same day of the week and at the same time, the color of the entered character is changed. It is displayed (shown in bold in FIG. 7A).
The administrator can predict the shortage of workers based on the color of the input value.

In addition, as shown in FIG. 7B, in the reference information display fields 103a, 103b, 103c, and 103d of the assumed operation shift input screen G1, “actual value” and “over / undervalue” are displayed as past data. It can also be set as the structure to make.
The “actual value” is the same value as the “actual value” in the reference information display field 103a and the like in FIG.
The “excess / deficiency value” is an average value (insufficient value) of the number of people who became insufficient as a result of the shift assignment at the same time and the same time in the past, or an average value (surplus value) of the surplus number of people.
Specifically, the shortage value is an average value of the shortage numbers of workers of the same skill acquired from the same day of the week and the same time with reference to the information of the “shortage number” T54 in the excess / deficiency table T5 (FIG. 6). . Such a deficient value is a negative number and is displayed with the character color changed (R1 in FIG. 7B).
Further, the surplus value is an average value of surplus numbers of workers of the same skill acquired from the same day of the week and the same time with reference to the information of the “surplus number” T55 of the excess / deficiency table T5 (FIG. 6). The surplus value is displayed as a positive number (R2 in FIG. 7B).

FIG. 8 is an example of the allocation result screen G2.
The allocation result screen G2 is a screen on which the determined work shift is displayed, and is used for confirming or adjusting the work shift determined by the administrator.

As shown in FIG. 8, the allocation result screen G2 includes a “date display field” G21 and a “work shift table” G22.
The “date display field” G21 displays the date of the expected operation date.
The “work shift table” G22 is a table showing the work schedule of the worker for each time and skill. The “work shift table” G22 has a time division column 201 at the top thereof and skill division columns 202a to 202d at the left portion thereof.

  The time division column 201 indicates a time division at a predetermined interval (here, every hour).

Skill classification columns 202a to 202d indicate the classification of skills (role).
The skill classification column 202a indicates the classification of “store manager” that does not require shift creation.
Skill classification columns 202b to 202d indicate the categories of “cooking”, “checkout”, and “hole” that require shift creation. Note that the skill classification is merely an example, and is not limited to this.

  In the skill category columns 202b to 202d, items of “person in charge” 203, “personnel difference” 204, “following candidate” 205, “addition request candidate” 206, and “surplus personnel” 207 are provided.

“Person in charge” 203 indicates a worker who performs the work of the skill.
The “personnel difference” 204 indicates the number of persons that is less than the assumed number. If there is no shortage, it is blank.
“Follow candidate” 205 indicates a worker who holds the skill but works with other skills.
“Additional request candidate” 206 indicates a worker who is a candidate for requesting additional work because he / she has not entered the work shift. The worker name input to the “addition request candidate” 207 is set with information for displaying a worker information screen G3 (to be described later) on the screen by clicking.
“Surplus personnel” 207 indicates a worker who has made a desired shift but has not entered a work shift.

FIG. 9 is an example of the worker information screen G3.
The worker information screen G3 is a screen used when the administrator makes a request to add work, and by clicking on the worker name of the “addition request candidate” 206 on the assignment result screen G2, the worker information screen G3 is displayed. Pop up on top.
As shown in FIG. 9, the worker information screen G3 includes items of “worker name” 301, “contact (phone)” 302, “contact (mail address)” 303, and “skill to hold” 304. doing.

  Next, various screens displayed on the display unit 24 of the employee terminal device 20 will be described with reference to FIGS. 10 and 11.

FIG. 10 is an example of the desired shift input screen G4.
The desired shift input screen G4 is a screen used when an employee submits a desired shift.

  As shown in FIG. 10, the desired shift input screen G4 includes a “date display field” 401, an “operator name display field” 402, a “desired time input field” 403, and a “stamp display field” 404.

The “date display field” 401 displays the date of the day on which the desired shift is input.
The “worker name display field” 402 displays the name of the employee who has logged into the desired shift input screen G4.
The “desired time input field” 403 includes cells divided by time, and a desired date is input by attaching a stamp to each cell.

The “stamp display field” 404 includes a “◯ mark” stamp 404a, a “Δ mark” stamp 404b, an “X mark” stamp 404c, and a save button 404d.
As an example of usage, the employee touches, for example, the “O” stamp 404a among the “O” stamp 404a, the “△” stamp 404b, and the “X” stamp 404c via the operation unit 22. By doing so, the stamp marked with a circle is selected.
Then, when the employee touches, for example, a frame (stamp pasting area) of the desired time “13” via the operation unit 22, a display of a state in which a stamp with a circle is pasted in the frame is displayed. Thus, the desired shift information indicating the desired working time is input.
The “Δ mark” stamp 404b indicates that the schedule is unconfirmed, and the “x mark” stamp 404c indicates that it is not desired (unavailable).

Further, as shown in FIG. 11, the desired shift input screen G4 displays a plurality of worker names in the “worker name display field” 402, and corresponds to each worker name in the “desired time input field” 403. It is also possible to use a list form in which the desired time is displayed.
The desired shift input screen G4 in FIG. 11 is a screen used when personal authentication is not performed.

In such a desired shift input screen G4, the cell of the “desired time input field” 403 is a place where a shortage of workers is expected (a place where the administrator wants a shift) (the lower right hatched portion in FIG. 10) ), And where the manager does not shift the skill held by the worker at the corresponding time (a place where the worker is likely not to be able to work even if the worker shifts) ) Background color has been changed.
Therefore, the employee can input to the desired shift input screen G4 while considering whether or not he / she can easily hope.

[2. Operation of work shift management system]
Next, the operation of the work shift management system 1 will be described.
<Overview of work shift management system operation>
FIG. 12 is a flowchart showing an outline of the operation of the work shift management system 1.
As a premise of such operation, the storage unit 15 of the server 10 stores a worker information table T1 (FIG. 2) in which worker information is registered.

As shown in FIG. 12, first, the CPU 11 of the server 10 registers the assumed operation shift information transmitted from the administrator's terminal device 20 in the assumed operation shift table T2 (FIG. 3). (FIG. 13) is executed (step S100).
Next, the CPU 11 executes a desired shift registration process (FIG. 14) for registering the desired shift information transmitted from the employee terminal device 20 in the desired shift table T3 (FIG. 4) (step S200).
Next, the CPU 11 executes a shift assignment process (FIGS. 15 and 16) for assigning a work shift in accordance with an instruction transmitted from the terminal device 20 of the administrator (step S300), and ends this process.
Details of each process will be described below.

<Operational shift registration process>
FIG. 13 is a flowchart showing an assumed operation shift registration process.
First, in the terminal device 20 of the administrator, an input form for logging in to an operation for creating an assumed operation shift and inputting an expected operation date is displayed on the display unit 24. The administrator designates the expected operation date via the input form and transmits it to the server 10.
In the server 10, the CPU 11 reads from the storage unit 15 and appropriately stores it in the RAM 13, triggered by the communication unit 16 receiving the expected operation date transmitted from the administrator terminal device 20 via the input form. The assumed operation shift registration process is executed in cooperation with the developed operation assumed shift registration program 151.

  As shown in FIG. 13, first, the CPU 11 receives the date of expected operation date input by the administrator's terminal device 20 (step S <b> 101).

As the reply, the CPU 11 displays the assumed operation shift input screen G1 on the display unit 24 of the administrator's terminal device 20.
At this time, the date received in step S101 is displayed in the “date display field” G11 on the assumed operation shift input screen G1. The “assumed number of people input table” G12 displays “actual value” and “insufficient value” in the reference information display fields 103a, 103b, 103c, and 103d, the input fields 102a, 102b, 102c, and 102d are blank, and the background. The color is not colored.

  Next, the CPU 11 selects a combination of the time and skill of one cell in the input field 102a of the “assumed number of people input table” G12 (step S102).

  Next, the CPU 11 refers to the excess / deficiency table T5 (FIG. 6) and determines whether or not the same time and skill combination exists on the same day in the past (date obtained by subtracting 7 from the date) (step). S103), if not present (step S103: No), the process proceeds to step S105 described later.

  On the other hand, if the same combination of time and skill exists (step S103: Yes), the CPU 11 changes the background color of the cell in the “expected number of people input table” G12 (step S104).

Next, the CPU 11 determines whether or not there is an unprocessed cell (step S105), and when there is an unprocessed cell (step S105: No), the CPU 11 proceeds to step S102.
On the other hand, when there is no unprocessed cell (step S105: Yes), it transfers to below-mentioned step S106.

As a result, in the assumed operation shift input screen G1, the “expected number of people input table” G12 has the input fields 102a, 102b, 102c, and 102d blank, and the desired cell (a combination of time and skill is desired). If the number of people is smaller than the assumed number of people), the background color is colored.
Here, the administrator inputs the assumed number of people in each cell of the input fields 102a, 102b, 102c, and 102d of the “assumed number of people input table” G12.

  Next, the CPU 11 receives the number of people for each time and skill (for each cell) input by the terminal device 20 of the administrator (step S106).

  Next, the CPU 11 acquires the combination of the time and skill of the cell in which the assumed number of persons is input, and the date of the “assumed number input table” G12 having the cell (step S107).

  Next, the CPU 11 acquires all workers having the skill acquired in step S107 from the worker information table T1 (FIG. 2) (step S108).

Next, the CPU 11 refers to the desired shift table T3 (FIG. 4), and acquired in step S108 at the same time in the past on the same day of the week (date minus 7) from the predetermined period in the past. The number of records corresponding to the worker is acquired (step S109).
Note that an average value of the number of records may be calculated for each predetermined period.
That is, the number of applicants who were able to work at the same time within a predetermined period in the past is acquired.

  Next, the CPU 11 determines whether or not the number acquired in step S109 is less than the number of persons received in step S106 (the number of persons input in the “expected number of persons input table” G12) (step S110). When the number is equal to or greater than the number of received persons (step S110: No), the process proceeds to step S112 described later.

  On the other hand, when the acquired number is smaller than the received number of people (step S110: Yes), the CPU 11 changes the color of the characters input in the “expected number of people input table” G12 (step S111).

  Next, the CPU 11 registers the assumed shift information in the assumed operation shift table T2 (FIG. 3) (step S112), and ends this process.

<Preferred shift registration process>
FIG. 14 is a flowchart showing the desired shift registration process.
First, in the employee's terminal device 20, an input form for inputting a desired work day date is displayed on the display unit 24 by logging in to the desired shift submission application. The employee designates a desired work day date via the input form and transmits it to the server 10.
In the server 10, the CPU 11 reads out from the storage unit 15 and appropriately stores it in the RAM 13, triggered by reception of the desired work day date transmitted from the employee terminal device 20 via the input form by the communication unit 16. A desired shift registration process is executed in cooperation with the developed desired shift registration program 152.

  As shown in FIG. 14, first, the CPU 11 receives a desired work day date input by the terminal device 20 of the employee (step S <b> 201).

  Next, the CPU 11 displays on the display unit 24 of the employee's terminal device 20 a desired shift input screen G4 corresponding to the worker name of the logged-in employee and the input date of the desired work day (step S202).

  Next, the CPU 11 acquires the skill held by the worker from the worker information table T1 (FIG. 2) (step S203).

Next, the CPU 11 changes the cell color (background color) of the “desired time input field” 403 on the desired shift input screen G4 (step S204).
Specifically, the CPU 11 obtains the time and skill of the part where the input character is changed in step S111 of the assumed operation shift registration process, and if the employee has the skill, in the “desired time input field” 403 , Change the background color of the cell at that time.
If there is a time when no data is stored in the assumed operation shift table T2 (FIG. 3) for the employee's skill, the background color of the cell at that time is changed.

  Next, the CPU 11 receives the desired working time input by the employee's terminal device 20 (step S205).

  Next, the CPU 11 registers the received desired work time in the desired shift table T3 (FIG. 4) as desired shift information, and ends this process.

<Shift assignment process>
15 and 16 are flowcharts showing the shift assignment process.
First, in the terminal device 20 of the administrator, an input form for logging in to an application for creating work shifts (assigning work shifts) and inputting a date for assigning work shifts is displayed on the display unit 24. The administrator designates a date for assigning work shifts via the input form, and transmits it to the server 10.
In the server 10, the CPU 11 reads out from the storage unit 15 as appropriate by receiving from the communication unit 16 the date for assigning work shifts transmitted from the administrator's terminal device 20 via the input form as a trigger. A shift assignment process is executed in cooperation with the shift assignment program 153 and the shift adjustment program 154 developed in the RAM 13.

  As shown in FIG. 15, first, the CPU 11 receives a date for assigning work shifts, which is input by the administrator's terminal device 20 (step S <b> 301).

  Next, the CPU 11 displays the assignment result screen G2 (FIG. 11) for the designated date on the display unit 24 of the administrator's terminal device 20 (step S302).

Next, the CPU 11 selects a skill in the “work shift table” G22 (step S303).
Skills are selected in order from the ones on the skill classification columns 202b to 202d of the “work shift table” G22.

  Next, the CPU 11 acquires the estimated number of persons per hour for the selected skill on the corresponding day from the assumed operation shift table T2 (FIG. 3) (step S304).

  Next, the CPU 11 acquires, from the desired shift table T3 (FIG. 4), “assigned flag” T35 blank, and workers having the skills selected at the corresponding date and time, from the earliest input date and time for the assumed number of people, A flag is set in the “assigned flag” T35 of the desired shift table T3 (FIG. 4) (step S305).

  Next, the CPU 11 determines whether or not the estimated number of persons could not be acquired (whether there were no applicants for the estimated number of persons) (step S306).

  If the estimated number of persons could not be acquired (step S306: Yes), the CPU 11 adds an insufficient number of persons (a value obtained by subtracting the estimated number of persons from the allocated number of persons) to the "personnel difference" 204 of the "work shift table" G22. ) (Step S307), and the process proceeds to step S310.

  On the other hand, when the expected number of persons can be acquired (step S306: No), the CPU 11 determines whether there are many applicants (step S308). When there are many applicants (step S308: Yes), the “work shift table”. The surplus applicant name is written in “surplus personnel” 207 of G22 (step S309), and the process proceeds to step S310.

  On the other hand, if there are not many applicants (step S308: No), the CPU 11 registers the worker acquired in step S305 and the skill selected in step S303 in the assigned shift table T4 (FIG. 5). (Step S310).

  Next, the CPU 11 determines whether or not there is another time during which the assumed number of persons is not acquired for the same skill selected in step S303 in the assumed operation shift table T2 (FIG. 3) (step S311). If there is another time (step S311: Yes), the process proceeds to step S304.

  On the other hand, if there is no other time (step S311: No), the CPU 11 determines whether there is another skill that is not selected in the “work shift table” G22 (step S312). When the skill exists (step S312: Yes), the process proceeds to step S303.

  On the other hand, when there is no other skill (step S312: No), the CPU 11 determines whether or not there is an item with a number in the “personnel difference” 204 of the “work shift table” G22 (step S313). .

  Then, when there is an item with a number in the “personnel difference” 204 of the “work shift table” G22 (step S313: Yes), the CPU 11 executes a shift adjustment process (step S400) and ends this process. . On the other hand, if it does not exist (step S313: No), the CPU 11 ends this process.

<Shift adjustment process>
FIG. 16 is a flowchart showing the shift adjustment process.

  First, the CPU 11 acquires a skill (S0) and date / time (T0) having a “personnel difference” 204 in the “work shift table” G22 (step S401).

  Next, the CPU 11 searches the desired shift table T3 (FIG. 4) for a worker that is not assigned with the same skill (S0) (an operator assigned with another skill) (step S402).

  Next, the CPU 11 displays the workers (H1, H2,...) Searched in step S402 on the “follow candidate” 205 in the “work shift table” G22 (step S403).

  Next, the CPU 11 acquires the skill (S1) assigned by the worker (H1) of the “follow candidate” 205 at the same date (T0) (step S404).

  Next, the CPU 11 determines whether or not another worker (h1) exists in the “surplus personnel” 207 of the skill (S1) and the date and time (T0) (step S405), and if not (step S405). : No), the process proceeds to step S409 described later.

  On the other hand, when another worker (h1) exists (step S405: Yes), the CPU 11 determines whether or not the worker (h1) of the “surplus personnel” 207 is assigned at the same date and time (T0). Is determined (step S406), and if not assigned (step S406: No), the process proceeds to step S409 described later.

  On the other hand, if assigned (step S406: Yes), the worker (h1) of the “surplus personnel” 207 is assigned to the skill (S1), and the skill of the worker (H1) of the “follow candidate” 205 is assigned. The type is changed from skill (S1) to skill (S0), and the number of “personnel difference” 204 in “work shift table” G22 is set to “+1” (step S407). Note that the “personnel difference” 204 of the “work shift table” G22 is blank when it becomes “0”.

  Next, the CPU 11 determines whether there is another follow candidate in the “follow candidate” 205 and whether there is a difference in the skill (S0) and time (T0) combination (step S408). If yes (step S408: Yes), the process proceeds to step S406.

  On the other hand, when it does not exist (step S408: No), the CPU 11 stores the excess / insufficiency table T5 (FIG. 6) for all items whose numbers are entered in the “personnel difference” 204 of the “work shift table” G22. Date / time, skill, and number of deficiencies are registered, and date / time, skill, number of surpluses are registered in excess / deficiency table T5 (FIG. 6) for all items for which operator names are entered in “surplus personnel” 207. (Step S409).

  Next, the CPU 11 determines whether or not there is an item whose number is input in the “personnel difference” 204 of the “work shift table” G22 (step S410). If there is no item (step S410: NO), this processing is performed. Exit.

  On the other hand, if there is an item whose number is entered in the “personnel difference” 204 of the “work shift table” G22 (step S410: Yes), the CPU 11 acquires the corresponding skill (S0) and date and time (T0) (step S411). ).

  Next, the CPU 11 searches the worker information table T1 (FIG. 2) for a worker who is not assigned to the date and time (T0) and holds the skill (S0) (step S412).

  Next, the CPU 11 displays the worker searched in step S412 as the “addition request candidate” 206 in the “work shift table” G22 (step S413).

  Next, the CPU 11 sets information such that the worker information screen G3 can be displayed when the worker name displayed in the “addition request candidate” 206 is clicked on the assignment result screen G2 (step S414). finish.

As described above, according to the present embodiment, the CPU 11 of the server 10 includes the assumed shift information indicating the working hours and the number of workers required for each skill, the past working hours and the work for each skill. Based on work shift information indicating the number of workers, work hours that are predicted to be excessive or insufficient for workers can be derived, and work hours that are predicted to be excessive or insufficient for workers can be identified. The management assumed shift input screen G1 is displayed on the display unit 24.
For this reason, when an administrator creates an operation shift that is necessary for store operation, based on past results, the manager can recognize the working hours in which excess or shortage of workers is predicted. However, since it is possible to create a management assumed shift, it is possible to reduce the labor of creating a work shift as a result.

In addition, according to the present embodiment, the CPU 11 displays the excess / shortage of workers for each skill so as to be identifiable.
For this reason, it is possible to create an assumed operation shift while considering the excess or deficiency of workers for each skill.

Further, according to the present embodiment, the CPU 11 causes the display unit 24 to display the desired shift input screen G4 for submitting desired shift information indicating the working hours desired by the worker, and the desired shift input screen G4 The work hours where the excess or deficiency of the derived workers is predicted are displayed in an identifiable manner.
For this reason, the operator can create a desired shift while taking into account the ease with which the user wishes.

Further, according to the present embodiment, the CPU 11 indicates the assumed shift information designated on the operation assumed shift input screen G1, the desired shift information submitted on the desired shift input screen G4, and the skills held by the worker. Based on the worker information, work shift information is created, and the created work shift information is displayed on the display unit 24 as an assignment result screen G2.
For this reason, it is possible to create a work shift in which an appropriate number of workers are arranged in consideration of the operator's wishes and skills.

Further, according to the present embodiment, the CPU 11 derives a working time period in which workers are insufficient from the assumed shift information designated on the assumed operation shift input screen G1 and the created work shift information, Based on the information, a worker who makes up for the shortage of workers in the derived working hours is extracted.
For this reason, it is possible to easily adjust the work shift when there is a shortage of workers.

  In the above description, an example in which the HDD or SSD of the storage unit 15 is used as a computer-readable medium for the program according to the present invention is disclosed, but the present invention is not limited to this example. As other computer-readable media, portable recording media such as a flash memory and a CD-ROM can be applied. Further, a carrier wave (carrier wave) is also applied to the present invention as a medium for providing program data according to the present invention via a communication line.

  The description in the above embodiment is an example of the work shift management device and the program according to the present invention, and the present invention is not limited to this.

  For example, the difficulty level of adjustment may be displayed on the assumed operation shift input screen G1. That is, a time zone that has been difficult to adjust in the past may be stored and displayed in a reference information display field or the like of the assumed operation shift input screen G1 so that it can be identified. Thereby, the administrator can recognize the working hours during which adjustment is difficult.

In addition, on the desired shift input screen G4, the required skill type may be displayed in characters. As a result, the worker can easily recognize what skill is likely to enable work.
In addition, the desired shift input screen G4 may be configured such that it is transmitted in a state where a stamp with a mark “O” is selected in advance, and a portion where you do not want to remove the stamp with a mark “○” is colored.

As mentioned above, although several embodiment of this invention was described, the scope of the present invention is not limited to the above-mentioned embodiment, The range of the invention described in the claim is equal to the equivalent range. Including.
The invention described in the scope of claims attached to the application of this application will be added below. The item numbers of the claims described in the appendix are as set forth in the claims attached to the application of this application.

[Appendix]
<Claim 1>
Based on the assumed shift information indicating the working hours and the number of workers required for each skill, and the working shift information indicating the past working hours and the number of workers for each skill, A deriving means for deriving a working time zone in which a shortage is predicted;
Display control means for displaying on the display means an assumed shift table that can identify the working hours in which the excess or shortage of workers derived by the deriving means is predicted;
Work shift management device equipped with.
<Claim 2>
The display control means includes
The work shift management apparatus according to claim 1, wherein an excess / shortage of workers is displayed for each skill so as to be identifiable.
<Claim 3>
A second display control means for causing the display means to display a desired shift table for submitting desired shift information indicating a working time zone desired by the worker;
3. The work shift according to claim 1, wherein the second display control unit displays, in the desired shift table, a work time zone in which an excess or shortage of workers derived by the deriving unit is predicted to be identifiable. Management device.
<Claim 4>
Create work shift information based on the assumed shift information specified by the assumed shift table, the desired shift information submitted by the desired shift table, and worker information indicating skills held by the worker. Work shift creation means to
Third display control means for displaying the work shift information created by the work shift creation means on the display means as a work shift table;
A work shift management device according to claim 3.
<Claim 5>
Second derivation means for deriving a working time period in which an operator is insufficient from the assumed shift information specified by the assumed shift table and the work shift information created by the work shift creation means;
Extraction means for extracting workers who make up for the shortage of workers in the working hours derived by the second derivation means based on the worker information;
The work shift management apparatus according to claim 4, comprising:
<Claim 6>
Computer
Based on the assumed shift information indicating the working hours and the number of workers required for each skill, and the working shift information indicating the past working hours and the number of workers for each skill, Deriving means for deriving working hours where shortages are predicted,
Display control means for displaying on the display means an assumed shift table that can identify the working hours that are predicted to be excessive or insufficient of the workers derived by the deriving means;
Program to function as.

1 work shift management system 10 server 11 CPU (derivation means, second derivation means, display control means, second display control means, third display control means, work shift creation means, extraction means)
12 Operation unit 13 RAM
14 Display unit 15 Storage unit 151 Operation assumed shift registration program 152 Desired shift registration program 153 Shift assignment program 154 Shift adjustment program T1 Worker information table T2 Operation assumed shift table T3 Desired shift table T4 Allocated shift table T5 Excess / deficiency table 16 Communication Unit 17 Bus 20 Terminal device 21 CPU
22 Operation unit 23 RAM
24 Display section (display means)
G1 Assumed shift input screen G2 Assignment result screen G3 Worker information screen 25 Storage unit 26 Wireless communication unit 27 Bus N Communication network

Claims (6)

Based on the assumed shift information indicating the working hours and the number of workers required for each skill, and the working shift information indicating the past working hours and the number of workers for each skill, A deriving means for deriving a working time zone in which a shortage is predicted;
Display control means for displaying on the display means an assumed shift table that can identify the working hours in which the excess or shortage of workers derived by the deriving means is predicted;
Work shift management device equipped with. The display control means includes
The work shift management apparatus according to claim 1, wherein an excess / shortage of workers is displayed for each skill so as to be identifiable. A second display control means for causing the display means to display a desired shift table for submitting desired shift information indicating a working time zone desired by the worker;
3. The work shift according to claim 1, wherein the second display control unit displays, in the desired shift table, a work time zone in which an excess or shortage of workers derived by the deriving unit is predicted to be identifiable. Management device. Create work shift information based on the assumed shift information specified by the assumed shift table, the desired shift information submitted by the desired shift table, and worker information indicating skills held by the worker. Work shift creation means to
Third display control means for displaying the work shift information created by the work shift creation means on the display means as a work shift table;
A work shift management device according to claim 3. Second derivation means for deriving a working time period in which an operator is insufficient from the assumed shift information specified by the assumed shift table and the work shift information created by the work shift creation means;
Extraction means for extracting workers who make up for the shortage of workers in the working hours derived by the second derivation means based on the worker information;
The work shift management apparatus according to claim 4, comprising: Computer
Based on the assumed shift information indicating the working hours and the number of workers required for each skill, and the working shift information indicating the past working hours and the number of workers for each skill, Deriving means for deriving working hours where shortages are predicted,
Display control means for displaying on the display means an assumed shift table that can identify the working hours that are predicted to be excessive or insufficient of the workers derived by the deriving means;
Program to function as.

Images