JP2007026361A - Work shift timetable creation device - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To create a work shift timetable in which the operation result of every employee is considered. <P>SOLUTION: Sales prediction information on an object day for planning a work shift is acquired, two or more days in the past when sales results similar to the sales prediction of an object day for planning the work shift are achieved are extracted by referring to every past-day sales result information based on the sales prediction information, days when the employees' operation results are the optimal among days in the past are selected by referring to every-employee operation result information every extracted day in the past, the work shift timetable is created by considering employees on duty on selected days in the past as persons on duty on the object day for planning the work shift and outputted. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to a work shift plan table creation device used in retail stores, restaurants, and the like.

Conventionally, the number of visitors and sales on the day of work shift plan creation are predicted based on corus information such as days of the week, special sales, special events, weather, temperature, etc., and the attendance schedule and work hours of employees are adjusted based on the prediction results A work shift plan table creation device that creates a work shift plan table by doing so has been known (see, for example, Patent Document 1).
JP 2002-024350 A

  However, in the conventional work shift plan table creation device, the work shift plan table has not been created in consideration of the operation results of each employee. For this reason, even if it was possible to secure appropriate personnel from the sales forecast value on the day of work shift plan creation, etc., there was a case where the labor force of the employee was insufficient because there was no individual operation record.

  The present invention has been made based on such circumstances, and the purpose of the present invention is to create a work shift plan table that takes into account the actual performance of each employee, thereby improving the efficiency of store operations. It is an object of the present invention to provide a work shift plan table creation device that can perform the above.

  The present invention relates to a work shift plan table creation device for creating a work shift plan table in a store, and stores and stores the operation result information of the employee corresponding to the identification information of each employee who has worked on that day for each past day. Employee performance record information storage means, sales record information storage means for accumulating and storing the sales result information for each day in the past, sales forecast information acquisition means for acquiring the sales forecast information on the work shift planning target day, and the sales Based on the sales forecast information obtained by the forecast information acquisition means, the sales performance information similar to the sales forecast on the work shift planning date is raised with reference to the past day sales performance information stored in the sales performance information storage means. Similar past date extracting means for extracting two or more past days, and for each employee stored in the employee operation result information storage means for each past date extracted by the similar past date extracting means Optimized past date selection means to select the day with the best working performance of the employee in the past day by referring to the performance record information, and the employee who entered the business on the past date selected by this optimal past date selection means The optimum employee acquisition means that reads employee identification information from the employee operation result information storage means, and the employee identified by the identification information obtained by the optimum employee acquisition means work as a sunrise shift target employee A work shift plan table creating means for creating a shift plan table and an output means for outputting the work shift plan table are provided.

  According to the present invention in which such measures are taken, it is possible to create a work shift plan table that can create a work shift plan table that takes into account the performance of each employee, and that can improve the efficiency of store operations. it can.

The best mode for carrying out the present invention will be described below with reference to the drawings.
This embodiment is a case where the store shift control table creation function of the present invention is provided in a store controller of a POS (Point Of Sales) system constructed in a retail store, a restaurant or the like.

  FIG. 1 is a block diagram showing a POS system according to the present embodiment. A POS terminal 11 installed at an accounting place of a store and a store controller 12 functioning as a host computer are connected to a LAN (Local Area Network). The POS system is constructed by connecting through a communication line 13 such as. In addition, a printer server 15 for controlling the printer 14 for printing the work shift schedule table and the like, and a terminal device 16 such as a personal computer equipped with input / output devices such as a keyboard, a pointing device, and a display are connected to the communication line 13 Connected. Although a plurality of POS terminals 11 are shown in the figure, only one POS terminal 11 may be provided. Further, the communication line 13 is not limited to a wired line but may be wireless.

  FIG. 2 is a block diagram showing a main hardware configuration of the store controller 12. The store controller 12 includes a CPU (Central Processing Unit) 21 as a control unit body. Also, a ROM (Read Only Memory) 22 in which fixed data such as a program is stored, a RAM (Random Access Memory) 23 that stores various data in a rewritable manner, a clock unit 24 that measures the current date and time, a nonvolatile memory A hard disk drive (HDD) device 25, which is a large-capacity storage device, and a communication interface 26 for controlling data bidirectional communication with each device connected via the communication line 13. The CPU 21, ROM 22, RAM 23, clock unit 24, HDD device 25, and communication interface 26 are connected by a bus line 27 such as an address bus or a data bus. The mass storage device is not limited to the HDD device, and may be any writable large-capacity nonvolatile storage device.

  In order to realize the work shift plan table creation function according to the present invention, the store controller 12 having such a configuration, in addition to well-known information management functions such as product information management, sales information management, employee information management, etc., related to the POS system, As shown in FIG. 3, the operation day basic information database 31, the employee basic information database 32, the sales performance information database 33, the employee operation result information database 34, the predicted index value information database 35, and the evaluation index value information database 36 are stored in the HDD. It is stored in the device 25.

  As shown in FIG. 4, the sales prediction information table 41, employee evaluation information table 42, performance error information table 43, operation rate evaluation information table 44, employee prediction information table 45, and shift plan information table 46 are stored in the RAM 23. I remember it.

  Furthermore, basic information management means 51 (see FIG. 17), sales performance information management means 52 (see FIG. 18), employee operation performance information management means 53 (see FIG. 19), sales prediction means 54 (FIG. 20, FIG. 25), employee evaluation means 55 (see FIGS. 20 and 26), sales performance evaluation means 56 (see FIGS. 21 and 27), employee utilization rate evaluation means 57 (see FIGS. 22 and 28). (Refer to FIG. 23 and FIG. 29) and shift plan table creation means 59 (refer to FIG. 24 and FIG. 30) are implemented with software for the CPU 21 to implement.

  The data structure of the working day basic information database 31 is shown in the schematic diagram of FIG. As shown in the figure, the working day basic information database 31 has a year and month as a unit block, and for each day and day of the month, the scheduled start time and end of the work for employees engaged in work for the shift plan. The scheduled time, the scheduled work time that is the time from the scheduled start time to the scheduled end time, and personnel that are the number of people required for the work are stored.

  The data structure of the employee basic information database 32 is shown in the schematic diagram of FIG. As shown in the figure, the employee basic information database 32 has a year and month as one unit block, and the employee is attended by the date of the month corresponding to the employee code and name information for identifying each employee. A work attendance flag indicating whether or not it is possible is stored. Here, the attendance permission / prohibition flag is work schedule information of each employee, and the employee basic information database 32 constitutes an employee basic information storage means. In the present embodiment, the attendance availability flag indicating that attendance is possible is set to “1”, and the attendance availability flag indicating impossibility of attendance is set to “0”, and the following description is continued.

  The data structure of the sales record information database 33 is shown in the schematic diagram of FIG. As shown in the figure, the sales record information database 33 stores year and month as one unit block, and sequentially stores the sales amount and the number of customers who are the total sales of the day for each date and day of the month. Here, the sales performance information database 33 constitutes sales performance information storage means.

  The data structure of the employee operation result information database 34 is shown in the schematic diagram of FIG. As shown in the figure, the employee operation record information database 34 has a date as a unit block, and identifies the employee code for each employee code of all employees who have worked on the work shift plan on that day. The operation result information of the actual work time and the operation rate of the employee and the personal evaluation information of the work attitude and work efficiency are stored. Here, the employee operation result information database 34 constitutes an employee operation result information storage means. The operating rate is a ratio of the actual work time to the scheduled work time of the work shift planning target job on the date. Therefore, when the actual work time reaches the scheduled work time, the operation rate becomes 100%. The working attitude and work efficiency are all evaluated in three stages: “good”, “normal”, and “bad”, “good” is a double circle symbol, “normal” is a circle symbol, “Bad” is indicated by a triangular symbol.

  The data structure of the prediction index value information database 35 is shown in the schematic diagram of FIG. As shown in the figure, the prediction index value information database 35 stores the prediction index value for each date and day of the week with the year and month as one unit block. The predicted index value is the ratio of the sales performance of the corresponding day to the sales performance of the same day closest to the same day of the same month one year ago. For example, when the sales result is expected to increase 10% from the previous year, the predicted index value is 110%. Conversely, if it is expected to decrease by 5%, the predicted index value is 95%.

  The data structure of the evaluation index value information database 36 is shown in the schematic diagram of FIG. As shown in the figure, the evaluation index value information database 36 stores an evaluation score for each combination of three levels of work attitude evaluation information and work efficiency evaluation information, which are employee evaluation index values. For example, in this embodiment, when both the work attitude evaluation information and the work efficiency evaluation information are “good: double circle symbol”, the evaluation score is 10 points. When the work attitude evaluation information is “good: double circle symbol” and the work efficiency evaluation information is “normal: circle symbol”, the evaluation score is nine. Hereinafter, it is as shown in FIG.

  The area structure of the sales forecast information table 41 is shown in the schematic diagram of FIG. As shown in the figure, the sales forecast information table 41 is composed of areas for storing information on work shift planning target date, day of the week, personnel, sales forecast amount, and predicted visit number of customers.

  The area structure of the employee evaluation information table 42 is shown in the schematic diagram of FIG. As shown in the figure, the employee evaluation information table 42 is configured with an area for storing each information of work attitude evaluation information, work efficiency evaluation information, and evaluation score corresponding to an employee code for identifying each employee. Yes.

  The area structure of the performance error information table 43 is shown in the schematic diagram of FIG. As shown in the figure, the performance error information table 43 is configured with an area for storing a sales error rate, a customer number error rate, and rank information corresponding to past date date information of a certain period of sales performance. The sales error rate, customer number error rate, and rank information will be described later.

  The area structure of the operation rate evaluation information table 44 is shown in the schematic diagram of FIG. As shown in the figure, the operation rate evaluation information table 44 is composed of areas for storing information on sales performance amounts, personnel, total operation rates, total evaluation points, average operation rates, and average evaluation points for each rank information. Yes. The total operation rate, the total evaluation score, the average operation rate, and the average evaluation score will be described later.

  The area structure of the employee prediction information table 45 is shown in the schematic diagram of FIG. As shown in the figure, the employee prediction information table 45 includes an area for storing a plurality of employee codes and name information corresponding to the employee codes.

  The area structure of the shift plan information table 46 is shown in the schematic diagram of FIG. As shown in the figure, the shift plan information table 46 includes the date and day of the week for work shift planning, the number of employees required for the work shift plan work for that day, and the employee code and name information for the staff. It consists of an area that stores

  As shown in FIG. 17, the basic information management unit 51 adds, changes, and saves information stored in the working day basic information database 31 and the employee basic information database 32 based on information input via the terminal device 16. It is a means for deleting, and is realized mainly by the CPU 21.

  As shown in FIG. 18, the sales performance information management means 52 is means for adding and updating the sales amount and the number of customers for the corresponding business day in the sales performance information database 33 based on the daily sales data sent from the POS terminal 11. Yes, with the CPU 21 as the main component. By the way, in the POS terminal 11, when the daily checkout operation is executed, the sales date including the total amount (sales amount) of all products registered for sales on that day and the number of commercial transactions (number of customers) settled. The total data is transmitted to the store controller 12 via the communication line 3.

  As shown in FIG. 19, the employee operation result information management unit 53 refers to the operation day basic information database 31 based on information input via the terminal device 16, and updates the employee operation result information database 34. And is realized mainly by the CPU 21.

  That is, when the employee code, the work start time, the work end time, the work attitude evaluation information, and the work efficiency evaluation information of the employee engaged in the work for the work shift plan are input from the terminal device 16, the CPU 21 starts the work start time. And the actual work time until the work end time is calculated. If the actual work time and the work day basic information database 31 are set, the operation rate is calculated from the work time on the date. Accordingly, the employee code, actual work time, operation rate, work attitude evaluation information, and work efficiency evaluation information are added to the employee operation result information database 34 together with the date of the one business day.

  As shown in FIG. 20, the sales prediction unit 54 refers to the sales day basic information database 31, the sales performance information database 33, and the prediction index value information database 35 based on information input via the terminal device 16. A means for creating the information table 41, which is realized mainly by the CPU 21.

  That is, as shown in FIG. 25, the CPU 21 first secures an area for the sales prediction information table 41 in the RAM 23. Then, when the date information of the work shift planning target date is input from the terminal device 16, the working day basic information database 31 is searched to obtain the day of the week and the personnel of the target date, and the sales forecast is performed together with the work shift planning target date. The information is written in the shift planning target day area, day of the week area, and personnel area of the information table 41, respectively.

  Next, the CPU 21 searches the sales performance information database 33 and acquires the sales amount and the number of customers on the same day of the week as the target date on the date closest to the same day of the same month one year before the target date. Further, the prediction index value information database 35 is searched to acquire the prediction index value of the target day. Then, the sales amount of the same day of the year before is multiplied by the forecast index value to calculate the sales forecast amount of the target day, and the number of customers on the same day of the year before is multiplied by the forecast index value. The predicted number of customers visiting the target day is calculated (sales forecast information acquisition means). The predicted sales amount and the predicted number of customers to visit are written in the predicted sales amount area and the predicted number of customers to visit in the sales prediction information table 41, respectively. Thus, the sales forecast information table 41 is created in the RAM 23.

  As shown in FIG. 20, the employee evaluation unit 55 operates in conjunction with the sales prediction unit 54, and refers to the employee basic information database 32, the employee operation result information database 34, and the evaluation index value information database 36. A means for creating the employee evaluation information table 42, which is implemented mainly by the CPU 21.

  That is, as shown in FIG. 26, the CPU 21 first secures an area for the employee evaluation information table 42 in the RAM 23. Further, a block in which the year and month closest to the current date counted by the clock unit 24 is selected from the blocks stored in the employee basic information database 32. Then, the number of records stored in this block (employee code, name, daily attendance flag), that is, the number of employees is acquired.

  Next, the CPU 21 once resets the counter A to “0”, and then increments the counter A by “1” until the number of employees is exceeded. Then, each time counting up, the following processes of ST (step) 1 to ST4 are repeatedly executed.

  In ST1, among the blocks stored in the employee basic information database 32, the record (A is the value of the counter A) registered in the Ath (A is the value of the counter A) from the block in which the date closest to the current date is set. Get the employee code (employee code, name, daily attendance flag).

  In ST2, using the employee code acquired in the processing of ST1 as a search key, each block stored in the employee operation result information database 34 is displayed with the date closest to the current date counted by the clock unit 24. Search in order from the set block. If a record (employee code, actual work time, operation rate, work attitude evaluation information, work efficiency evaluation information) in which the employee code is stored is detected, the work attitude evaluation information and work efficiency evaluation information are detected from this record. Get evaluation index value. In ST3, with reference to the evaluation index value information database 36, the evaluation index value information acquired in the process of ST2 is converted into an evaluation score (evaluation score deriving means).

  In ST4, the employee code acquired in the process of ST1, the evaluation index value of the work attitude evaluation information and work efficiency evaluation information acquired in the process of ST2, and the evaluation score acquired in the process of ST3 are stored in the employee evaluation table. Write sequentially to the corresponding areas of 42. Thus, when the counter A exceeds the number of employees, the employee evaluation information table 42 is created in the RAM 23.

  As shown in FIG. 21, the sales performance evaluation means 56 operates on the condition that the sales prediction information table 41 is created by the sales prediction means 54, and stores the sales performance information database 33 based on the sales prediction information table 41. It is a means for creating the performance error information table 43 by referring to it, and is realized mainly by the CPU 21.

  That is, as shown in FIG. 27, the CPU 21 first secures an area for the record error information table 43 in the RAM 23. Also, the counter B is once reset to “0”. Next, the CPU 21 selects a block in which the date closest to the current date measured by the clock unit 24 is set from among the blocks stored in the sales record information database 33 as ST11. Then, the record with the largest sales date, that is, the record nearest to the current date (sales date, day of week, sales amount, number of customers) is acquired from this block.

  Next, the CPU 21 acquires the sales date, the sales amount, and the number of customers from the record of the sales performance information database 33 acquired in the last process as ST12. The sales error rate δm, which is the error rate of the sales amount acquired in the process of ST12 with respect to the sales prediction amount stored in ST13 as the sales prediction information table 41, and the predicted number of customers visiting the store stored in the sales prediction information table 41 The customer number error rate δc, which is the error rate of the number of customers acquired in the process of ST12, is calculated. In ST14, the sales date acquired in the process of ST12 and the sales error rate δm and the customer number error rate δc calculated in the process of ST13 are sequentially written in the corresponding area of the performance error information table 43.

Incidentally, in the present embodiment, the sales error rate δm is assumed to be m1 for the sales forecast amount and m2 for the sales amount.
(When m1 ≦ m2)
δm = [(m2−m1) / m1] × 100%
(When m1> m2)
δm = [(m1−m2) / m2] × 100%
Calculate with

The customer error rate δc is calculated by assuming that the sales forecast amount is c1 and the sales amount is c2.
(When c1 ≦ c2)
δc = [(c2-c1) / c1] × 100%
(When c1> c2)
δc = [(c1−c2) / c2] × 100%
Calculate with

  Thereafter, the CPU 21 counts up the counter B by “1” in ST15, and determines whether or not the counter B has reached a preset evaluation day (for example, 31) in ST16. Here, if the counter B has not reached the evaluation days, the CPU 21 records in the previous day the sales date from the selected block of the sales performance information database 33 as ST17 (sales date, day of week, sales amount, number of customers). To get. If the record for the previous day does not exist in the selected block, the block with the year and month set one month before the selected block is selected, and the record with the largest sales date from this block (sales date, day of week) , Sales amount, number of customers). Thereafter, the processes of ST12 to ST17 are repeatedly executed until the counter B reaches the evaluation days in ST16. If the counter B reaches the evaluation days in ST16, the CPU 21 determines each sales performance date based on the sales error rate δm and the customer number error rate δc written by date in the performance error information table 43 in ST18. The rank is determined and written in the rank area of the performance error information table 43. Thus, the actual error information table 43 is created in the RAM 23.

  Incidentally, in this embodiment, the rank (1, 2, 3,... From the top) is ranked higher when the sum of the sales error rate δm and the customer number error rate δc is smaller. In the case where the sum is the same value, the one with the smaller sales error rate δm is ranked higher. When both the sales error rate δm and the customer number error rate δc are the same value, the newer date is ranked higher.

  As shown in FIG. 22, the employee operation rate evaluation means 57 operates on the condition that the result error information table 43 is created by the sales result evaluation means 56, and the employee operation rate evaluation means 57 operates based on the result error information table 43. A means for creating an operation rate evaluation information table 44 with reference to the record information database 34 and the employee evaluation information table 42, and is realized mainly by the CPU 21.

  That is, as shown in FIG. 28, the CPU 21 first secures an area for the operation rate evaluation information table 44 in the RAM 23. Further, the counter C is once reset to “0”. Next, the CPU 21 counts up the counter C by “1” until it exceeds a preset rank number L (L is 2 or more, for example, 5). And whenever it counts up, the process of the following ST21-ST26 is repeatedly performed.

  In ST21, the sales record date with rank C (C is the value of counter C) is acquired from the record information error table 43 (similar past date extraction means). In ST22, the employee operation record information database 34 is searched, and the number of employees and the total operation rate are calculated from the record of employee operation record information stored in the block in which the date acquired in the process of ST21 is set. Incidentally, personnel is the number of records. The total operating rate is a value obtained by adding the operating rates of the records.

  In ST23, all the employee codes stored in the block are acquired from the block of the employee operation result information database 34 handled in the process of ST22. In ST24, referring to the employee evaluation information table 42, the evaluation score for each employee code acquired in the processing of ST23 is acquired, and the total value is calculated.

  In ST25, the average operating rate is calculated by dividing the total operating rate calculated in the process of ST22 by the number of personnel calculated in the same process. Further, the average evaluation score is calculated by dividing the total evaluation score calculated in the process of ST24 by the above-mentioned personnel. In ST26, in the area corresponding to rank C in the record error information table 43, the sales record date acquired in the process of ST21, the total number of personnel and the operating rate acquired in the process of ST22, and the total evaluation score acquired in the process of ST24 And the average operation rate and the average evaluation score calculated in the process of ST25 are written respectively. Thus, when the counter C exceeds the rank number L, the actual error information table 43 is created in the RAM 23.

  As shown in FIG. 23, the employee prediction unit 58 operates on the condition that the operation rate evaluation information table 44 is created by the employee operation rate evaluation unit 57. Based on the operation rate evaluation information table 44, the employee prediction unit 58 operates. A means for creating an employee prediction information table 45 by referring to the employee operation result information database 34, the employee basic information database 32, the sales prediction information table 41, and the employee evaluation information table 42, and is realized mainly by the CPU 21. .

  That is, as shown in FIG. 29, the CPU 21 first secures an area for the employee prediction information table 45 in the RAM 23. Next, based on the average operating rate and the average evaluation score stored in the operating rate evaluation information table 44 in the rank order, the reference date for the business shift planning target date is determined (optimal past date selecting means). Incidentally, in this embodiment, the average operating rate and the average evaluation score are added together as numerical values, and the sales performance date of the data having the largest combined value is determined as the reference date. When there are a plurality of data having the largest combined value, the sales performance date of the data with the higher rank is determined as the reference date.

  Next, the CPU 21 acquires the personnel P from the data of the operation rate evaluation information table 44 including the sales performance date as the reference date (past day personnel acquisition means). Then, the personnel P is compared with the personnel Q on the shift planning target date stored in the sales prediction information table 41 (manual excess / deficiency determination means).

  Here, when the staff P is larger than the staff Q, the CPU 21 searches for a block in which a reference date is set among the blocks stored in the employee operation record information database 34. Then, an employee code is acquired from each record stored in this block, and an evaluation score stored in the employee evaluation information table 42 is acquired corresponding to the employee code. Then, Q employee codes are sorted in descending order of evaluation score. Thereafter, if the name information corresponding to the employee codes for Q persons is acquired from the employee basic information database 32, the employee code and the name information are written in the employee prediction information table 45 (employee selection means) ). Thus, the employee prediction information table 45 is created in the RAM 23.

  On the other hand, when the staff P is equal to the staff Q or when the staff P is smaller than the staff Q, the CPU 21 blocks among the blocks stored in the employee operation result information database 34 that have a reference date set. Search for. The employee code is obtained from each record stored in the block, and the name information corresponding to the employee code is obtained from the employee basic information database 32. The employee code and the name information are obtained from the employee. Write to the prediction information table 45 (optimum employee acquisition means).

  Next, the CPU 21 sets the value obtained by subtracting the personnel P from the personnel Q as the initial value of the counter R. Then, when the counter R is “0”, that is, when the personnel P is equal to the personnel Q, this process is terminated. Thus, the employee prediction information table 45 is created in the RAM 23.

  When the counter R is not “0”, that is, when the personnel P is smaller than the personnel Q, the CPU 21 refers to the employee evaluation information table 42 as ST31 and uses an employee code that does not exist in the employee prediction information table 45. Get the employee code with the highest evaluation score. Next, when the name information corresponding to the employee code is acquired from the employee basic information database 32 as ST32, the employee code and the name information are written in the employee prediction information table 45 (employee addition means).

  Thereafter, the CPU 21 counts down the counter R by “1” in ST33. Then, it is determined again whether the counter R is “0”. If the counter R is not “0”, the processes of ST31 to ST33 are executed again. That is, with reference to the employee evaluation information table 42, the employee code having the maximum evaluation score with the employee code that does not exist in the employee prediction information table 45 is acquired, and the employee code and the corresponding name information are obtained. Write to the employee prediction information table 45. Then, the counter R is decremented by “1”.

  In this way, when the counter R becomes “0”, this processing is terminated. Thus, the employee prediction information table 45 is created in the RAM 23.

  As shown in FIG. 24, the shift plan table creating means 59 operates on the condition that the employee prediction information table 45 is created by the employee prediction means 58, and the employee is based on the employee prediction information table 45. A means for creating the shift plan information table 46 with reference to the basic information database 32, the sales forecast information table 41, and the employee evaluation information table 42, and is realized mainly by the CPU 21.

  That is, as shown in FIG. 30, the CPU 21 first secures an area for the shift plan information table 46 in the RAM 23. Next, the employee code stored in the employee prediction information table 45 is searched for the presence or absence of an employee code that cannot be attended on the shift planning date stored in the sales prediction information table 41. That is, a block in which the year and month of the shift planning date is set is searched from the blocks stored in the employee basic information database 32 and corresponds to each employee code in the employee prediction information table 45. The shift planning target sunrise work availability flag is checked (attendance availability determination means). Here, whenever the attendance permission / prohibition flag is “0”, that is, when an employee code that cannot be attended is detected, the CPU 21 executes the following processes of ST41 and ST42.

  In ST41, with reference to the employee basic information database 32 and the employee evaluation information table 42, the shift planning target sunrise work permission flag is set to “1” with an employee code that does not exist in the employee prediction information table 45. The employee code with the highest evaluation score and the name information are acquired (employed employee extraction means). In ST42, the employee code detected as a code that cannot be attended and the name information corresponding to the employee code are deleted from the employee prediction information table 45, and the employee code name information acquired in the process of ST41 is written instead. Employee vacancy replacement means).

  If it is confirmed that the employee code stored in the employee prediction information table 45 does not include an employee code that cannot be attended on the shift planning date stored in the sales prediction information table 41, The CPU 21 writes the shift plan planning date, day of the week, and personnel stored in the sales forecast information table 41 in the corresponding area of the shift plan information table 46. Also, each employee code stored in the employee prediction information table 45 and the corresponding name information are written in the corresponding area of the shift plan information table 46. Thus, the shift plan information table 46 is created in the RAM 23.

  Next, the CPU 21 creates image data of the shift plan table based on the information stored in the shift plan information table 46 (work shift plan table creating means). Then, this image data is output to the terminal device 16 connected via the communication line (output means). As a result, the shift schedule is displayed on the display of the terminal device 16. Thereafter, when receiving a print command command from the terminal device 16, the CPU 21 outputs the image data of the shift plan table to the printer server 15 (output means). As a result, the shift plan table is printed out on the recording paper by the printer 14.

Next, the work shift plan table creation function of the present embodiment will be described with a specific example.
In this specific example, the business shift planning target date is July 3, 2005 (Sunday). And the principal part of the block data of the sales performance information database 33 in which the year (July 2004) one year before the target date is set is shown in FIG. 31, and the date (July 2005) of the target date is shown. FIG. 32 shows a main part of the block data of the prediction index value information database 35 in which “” is set. Further, the work day basic information database 31 has a day of the week [day], start time [13:00], end time [19:00], work time [06:00], and personnel for July 3, 2005. Assume that [5] is set.

  In this case, when the operator inputs the date information (July 3, 2005) of the work shift planning target date from the terminal device 16, the sales prediction means 54 is first executed. As a result, July 4 is selected as the Sunday one year ago closest to July 3, 2004, and the sales amount [¥ 1,500,000] and the number of customers [1, 1, 200] is acquired. Further, the predicted index value [110%] of the work shift planning target date is acquired from the predicted index value information database 35. Therefore, as shown in FIG. 33, shift planning target date [2005-07-03], day of the week [day], personnel [5], and estimated sales amount [¥ 1,650,000 (= 1,500) , 1,000 × 1.10)] and a predicted number of customers visiting the store [1,320 (= 1,200 × 1,10)] are created.

  In conjunction with this, employee evaluation means 55 is executed. Now, it is assumed that the employee evaluation information table 42 having the data contents shown in FIG.

  Next, sales performance evaluation means 56 is executed. The main part of the block data of the sales record information database 33 in which the sales record information closest to the current date is stored is shown in FIG. The set value for the evaluation days is 31. In this case, the sales record evaluation means 56 creates a record error information table 43 shown in FIG.

  For example, since the sales amount date closest to the current date (May 31, 2005) is ¥ 800,000, the error rate δm with respect to the estimated sales amount ¥ 1,650,000 is given by the following equation (1). It is calculated as 106%.

δm = [(1650000-800000) / 800000] × 100% (1)
Since the number of customers is 800, the error rate δc for the predicted number of customers visiting the store of 1320 is calculated as 65% by the following equation (2).

δc = [(1320−800) / 800] × 100% (2)
Thereafter, the sales error rate δm and the customer number error rate δc for 31 days are calculated by going back in the past by one day, and stored in the performance error information table 43. The rank is determined for each date based on the sales error rate δm and the customer number error rate δc.

  In the case of the performance error information table 43 shown in FIG. 36, the sum of the sales error rate δm and the customer number error rate δc on May 14, 2005 is 16, which is the smallest, so rank [1]. Next, since the sum of the sales error rate δm and the customer number error rate δc on May 5 is 23, which is the next smallest, rank [2].

  In this way, when the performance error information table 43 is created, the employee utilization rate evaluation means is executed next. FIG. 37 shows the data contents of the employee operation result information database 34 in which the rank [1] of May 14, 2005 is set. In this case, the number of personnel is recognized as four. Further, since the total operation rate is 320% and the total evaluation score is 32, the average operation rate is calculated as 80.0%, and the average evaluation score is calculated as 8.0. As a result, the operation rate evaluation information table 44 includes the sales performance date [2005-05-14], personnel [5], operation rate total [320%], evaluation score total [32], as rank [1] data. The average operation rate [80.0%] and the average evaluation score [8.0] are stored.

  When the operation rate evaluation information table 44 is thus created, the employee prediction means 58 is executed next. Now, it is assumed that an operation rate evaluation information table 44 having data contents shown in FIG. 38 is created. As a result, the sum of the average operation rate and the average evaluation score obtained by quantifying the sum is rank [3], so the sales performance date [May 22, 2005] is determined as the reference date. In this case, since the number of personnel P on May 22, 2005 is five and coincides with the personnel Q on the shift planning target date, May 22, 2005 of the employee operation record information database 34 is set. The employee code and the name information corresponding to the employee code stored in the block are written in the employee prediction information table 45, and for example, the employee prediction information table 45 having the data contents shown in FIG. 39 is created.

  If rank 5 [May 5, 2005] is determined as the reference date, the number of employees P on this day is six, and the number of employees Q is greater than the number Q of shift planning dates. From the employee code for 6 persons stored in the block in which May 5th, 2005 is set in the information database 34, the evaluation score for 5 persons in descending order set in the employee evaluation information table 42 The employee codes are selected and written in the employee prediction information table 45 together with the name information corresponding to the employee codes, and the employee prediction information table 45 is created.

  Also, when rank 14 [May 14, 2005] is determined as the reference date, the number of personnel P on this day is four, which is less than the number of personnel Q on the shift planning date, so the employee performance record database In addition to the employee code for four persons stored in the block in which 34 May 2005 is set, one person with the highest evaluation score set in the employee evaluation information table 42 is used. Employee code is added. Then, the product code and the name information for these five persons are written in the employee prediction information table 45, and the employee prediction information table 45 is created.

  Thus, when the employee prediction information table 45 is created, the shift plan table creating means 59 is finally executed. Now, when the employee prediction information table 45 shown in FIG. 39 is created, the data of the block in which the date of the shift planning target date [July 3, 2005] in the employee basic information database 32 is set, If the employee's code [0006] has a flag “0” for three days of work, that is, the employee is unable to work on the shift planning date, the employee prediction information table 45 is shifted to an employee code that does not exist. Among the employee codes that are available for work on the planning target day (3 sunrise work availability flag is “1”), the employee code with the highest evaluation score is selected. The employee code and name information corresponding to the employee code are stored in place of the employee code [0006] and name information corresponding to the employee code in the employee prediction information table 45. Assume that the employee code is [0009]. In this case, a shift plan information table 46 having data contents shown in FIG. 40 is created.

  Therefore, image data of the shift plan table is generated based on the data content of the shift plan information table 46 and displayed on the terminal device 16. As a result, the operator can obtain a work shift template for the target work on July 3, 2005.

  Since this work shift plan table takes into account the operational performance of each employee, not only can the appropriate personnel be secured based on sales forecasts, etc., but also the workforce of employees is appropriate, and the efficiency of store operations Can be achieved.

  As described above, according to the present embodiment, the sales forecast information on the work shift planning target date is acquired, and the sales forecast information on the work shift planning target date is referred to based on the sales forecast information on the past day based on the sales forecast information. Extract two or more past days with similar sales results, refer to the operation result information by employee for each of the extracted past days, and select the best day for the employee's operation results. The work shift plan table was created and output as the employee who worked on this shift in the selected past days, and the work shift plan of each employee was taken into account. The obtained work shift schedule can be easily obtained.

  In addition, an evaluation score is derived for each employee based on the human evaluation information for each employee, and the operation performance information of each employee is obtained for each of the extracted past two days or more, and the evaluation score of the employee is obtained. , Select the day with the best employee performance from the past days extracted based on these employee performance information and evaluation scores, and enter work on this selected past day. The work shift plan table was created and output as a hiring worker who was the employee who was the target of work shift planning, so it was easy to create a work shift plan table that considered not only the performance of each employee but also human evaluation. Obtainable.

  Also, work schedule information is stored corresponding to each employee's identification information, and the employee's identification information of employees who can attend work on the work shift planning date is extracted with reference to the stored work schedule information by employee. As a result, employees who are not scheduled to work on the work shift planning target day can be automatically removed from the work shift plan table for the target day. Therefore, it is possible to easily obtain a work shift schedule with higher certainty.

  In addition, if the identification information of employees who are unable to attend work on the work shift planning date is extracted, the employee with the highest evaluation score among the employees who can work on the work shift planning date will be used instead. Since it is replenished, the reliability of the work shift schedule is not impaired even if there are employees who are unable to attend work.

  The present invention is not limited to the above-described embodiment as it is, and can be embodied by modifying the constituent elements without departing from the scope of the invention in the implementation stage.

  For example, in the above embodiment, the data of the work day basic information database 31, the employee basic information database 32, the sales performance information database 33, the employee performance information information database 34, the predicted index value information database 35, and the evaluation index value information database 36. Although the structure is shown in FIGS. 5 to 10, each data structure is not limited to that shown in the figure. Further, the area configurations of the sales prediction information table 41, employee evaluation information table 42, performance error information table 43, operation rate evaluation information table 44, employee prediction information table 45 and shift plan information table 46 are shown in FIGS. However, each area configuration is not limited to that shown in the figure.

  In the above embodiment, the sales forecast information acquisition means is automatically obtained based on the sales information of the same day of the year before. However, when the shift planning date is input from the terminal device 16, The prediction information may also be manually input. That is, the sales forecast information acquisition unit may be an external input information acquisition unit.

  In addition, the present invention is not limited to the store controller 12 of the POS system, and may be a general personal computer or workstation as long as the daily sales performance information can be acquired via the POS system.

  In addition, various inventions can be formed by appropriately combining a plurality of constituent elements disclosed in the embodiment. For example, some components may be deleted from all the components shown in the embodiment. Furthermore, the constituent elements over different embodiments may be combined.

1 is a block diagram showing an overall configuration of a POS system according to an embodiment of the present invention. The block diagram which shows the principal part structure of the store controller in the POS system. The schematic diagram which shows the database which concerns on this invention preserve | saved at HDD apparatus of the store controller. The schematic diagram which shows the table memory which concerns on this invention memorize | stored in RAM of the store controller. The schematic diagram which shows the example of a data structure of the working day basic information database in FIG. The schematic diagram which shows the example of a data structure of the employee basic information database in FIG. The schematic diagram which shows the data structural example of the sales performance information database in FIG. The schematic diagram which shows the example of a data structure of the employee operation performance information database in FIG. The schematic diagram which shows the example of a data structure of the prediction index value information database in FIG. The schematic diagram which shows the data structural example of the evaluation index value information database in FIG. The schematic diagram which shows the data area structure of the sales forecast information table in FIG. The schematic diagram which shows the data area structure of the employee evaluation information table in FIG. The schematic diagram which shows the data area structure of the track record error information table in FIG. The schematic diagram which shows the data area structure of the operation rate evaluation information table in FIG. The schematic diagram which shows the data area structure of the employee prediction information table in FIG. The schematic diagram which shows the data area structure of the shift plan information table in FIG. The schematic diagram which shows the outline | summary of the basic information management means which CPU of the store controller implement | achieves. The schematic diagram which shows the outline | summary of the sales performance information management means which CPU of the store controller implement | achieves. The schematic diagram which shows the outline | summary of the employee operation performance information management means which CPU of the store controller implement | achieves. The schematic diagram which shows the outline | summary of the sales prediction means and employee evaluation means which CPU of the store controller implement | achieves. The schematic diagram which shows the outline | summary of the sales performance evaluation means which CPU of the store controller implement | achieves. The schematic diagram which shows the outline | summary of the employee operating rate evaluation means which CPU of the store controller implement | achieves. The schematic diagram which shows the outline | summary of the employee prediction means which CPU of the store controller implement | achieves. The schematic diagram which shows the outline | summary of the shift plan table preparation means which CPU of the store controller implement | achieves. The flowchart which shows the main processing procedures of the sales prediction means which CPU of the store controller implement | achieves. The flowchart which shows the main processing procedures of the employee evaluation means which CPU of the store controller implement | achieves. The flowchart which shows the main process sequence of the sales performance evaluation means which CPU of the store controller implement | achieves. The flowchart which shows the main processing procedures of the employee operation rate evaluation means which CPU of the store controller implement | achieves. The flowchart which shows the main processing procedures of the employee prediction means which CPU of the store controller implement | achieves. The flowchart which shows the main process sequence of the shift plan table preparation means which CPU of the store controller implement | achieves. The schematic diagram which shows one data example of a sales performance information database. The schematic diagram which shows one example of data of a prediction index value information database. The schematic diagram which shows one data example of a sales forecast information table. The schematic diagram which shows the example of 1 data of an employee evaluation information table. The schematic diagram which shows one data example of a sales performance information database. The schematic diagram which shows the example of 1 data of a performance error information table. The schematic diagram which shows one data example of an employee operation results information database. The schematic diagram which shows the example of 1 data of an operation rate evaluation information table. The schematic diagram which shows the example of 1 data of an employee prediction information table. The schematic diagram which shows the example of 1 data of a shift plan information table.

Explanation of symbols

  DESCRIPTION OF SYMBOLS 11 ... POS terminal, 12 ... Store controller, 14 ... Printer, 15 ... Printer server, 16 ... Terminal device, 21 ... CPU, 22 ... ROM, 23 ... RAM, 24 ... Clock part, 25 ... HDD apparatus, 26 ... Communication interface 31 ... Workday basic information database, 32 ... Employee basic information database, 33 ... Sales performance information database, 34 ... Employee operation performance information database, 35 ... Predicted index value information database, 36 ... Evaluation index value information database, 41 ... Sales forecast information table, 42 ... Employee evaluation information table, 43 ... Performance error information table, 44 ... Operation rate evaluation information table, 45 ... Employee forecast information table, 46 ... Shift plan information table, 51 ... Basic information management means 52 ... Sales result information management means 53 ... Employee operation result information management means 54 ... sales forecasting means, 55 ... employee evaluation means, 56 ... sales performance evaluation means, 57 ... employee utilization rate evaluation means, 58 ... employee prediction means, 59 ... shift plan table creation means.

Claims (7)

In the work shift plan table creation device that creates the work shift plan table in the store,
Employee operation result information storage means for accumulating and storing the operation result information of the employee corresponding to the identification information of each employee who worked on the day for each past day,
Sales performance information storage means for accumulating and storing sales performance information for the day for each past day;
Sales forecast information acquisition means for acquiring sales forecast information on a work shift planning target day;
Based on the sales forecast information obtained by the sales forecast information acquisition means, referring to the past day sales record information stored in the sales record information storage means, sales results similar to the sales forecast on the work shift planning target date A similar past date extracting means for extracting two or more days in the past,
For each past day extracted by the similar past date extraction means, the operation result information by employee stored in the employee operation result information storage means is referred to, and the operation result of the employee is the best in the past days. An optimal past date selection means for selecting
Optimal employee acquisition means for reading out identification information of employees who have worked on the past day selected by the optimal past date selection means from the employee operation result information storage means,
A work shift plan table creating means for creating a work shift plan table with the employee identified by the identification information obtained by the optimum employee acquisition means as a work shift planning target sunrise worker;
An output means for outputting the work shift schedule table;
A work shift plan table creation device characterized by comprising: In the work shift plan table creation device that creates the work shift plan table in the store,
Employee operation result information storage means for accumulating and storing the operation result information and human evaluation information of the employee corresponding to the identification information of each employee who worked on that day for each past day;
Sales performance information storage means for accumulating and storing sales performance information for the day for each past day;
Sales forecast information acquisition means for acquiring sales forecast information on a work shift planning target day;
Based on the sales forecast information obtained by the sales forecast information acquisition means, referring to the past day sales record information stored in the sales record information storage means, sales results similar to the sales forecast on the work shift planning target date A similar past date extracting means for extracting two or more days in the past,
Evaluation score deriving means for deriving an evaluation score for each employee based on the human evaluation information for each employee stored in the employee operation result information storage means;
For each past date extracted by the similar past date extraction means, the operation result information of each employee stored in the employee operation result information storage means is acquired and the evaluation derived by the evaluation score deriving means for the employee is obtained. Optimal past day selection that acquires points and selects the day with the best operating results of employees among the past days extracted by the similar past date extraction means based on the operating performance information and evaluation scores for each employee Means,
Optimal employee acquisition means for reading out identification information of employees who have worked on the past day selected by the optimal past date selection means from the employee operation result information storage means,
A work shift plan table creating means for creating a work shift plan table with the employee identified by the identification information obtained by the optimum employee acquisition means as a work shift planning target sunrise worker;
An output means for outputting the work shift schedule table;
A work shift plan table creation device characterized by comprising: Employee basic information storage means for storing work schedule information corresponding to identification information of each employee;
Referring to the work schedule information by employee stored in the employee basic information storage means, identification of employees who can attend work on the work shift planning target day among the identification information obtained by the optimum employee acquisition means And an attending employee extracting means for extracting information,
The work shift plan table creation means creates a work shift plan table with the employee identified by the identification information extracted by the attendance employee extraction means as the work shift planning target sunrise worker. The work shift plan table preparation apparatus according to claim 1 or 2. Employee basic information storage means for storing work schedule information corresponding to identification information of each employee;
Employees who are unable to attend the work shift planning target date in the identification information obtained by the optimum employee acquisition means with reference to the work schedule information by employee stored in the basic employee information storage means Attendance determination means for determining whether or not the identification information of
If it is determined by the attendance determination means that there is employee identification information that cannot be attended, the identification information obtained by the optimum employee acquisition means is excluded by the number of employee identification information that cannot be attended. Employee vacancy supplementing means for selecting employee identification information having a high evaluation score calculated by the evaluation score deriving means among identification information of employees who can attend work on the work shift planning target day;
Further comprising
The work shift plan table creation means sets the employee identified by the identification information extracted by the attendance employee extraction means and the identification information selected by the employee vacancy supplement means as the sunrise worker to be the work shift planning target. 3. The work shift plan table creation apparatus according to claim 2, wherein a work shift plan table is created. In the work shift plan table creation device that creates the work shift plan table in the store,
Employee operation result information storage means for accumulating and storing the operation result information and human evaluation information of the employee corresponding to the identification information of each employee who worked on that day for each past day;
Sales performance information storage means for accumulating and storing sales performance information for the day for each past day;
Sales forecast information acquisition means for acquiring sales forecast information and necessary personnel for the work shift planning date,
Based on the sales forecast information obtained by the sales forecast information acquisition means, referring to the past day sales record information stored in the sales record information storage means, sales results similar to the sales forecast on the work shift planning target date A similar past date extracting means for extracting two or more days in the past,
Evaluation score deriving means for deriving an evaluation score for each employee based on the human evaluation information for each employee stored in the employee operation result information storage means;
For each past date extracted by the similar past date extraction means, the operation result information of each employee stored in the employee operation result information storage means is acquired and the evaluation derived by the evaluation score deriving means for the employee is obtained. Optimal past day selection that acquires points and selects the day with the best operating results of employees among the past days extracted by the similar past date extraction means based on the operating performance information and evaluation scores for each employee Means,
Optimal employee acquisition means for reading out identification information of employees who have worked on the past day selected by the optimal past date selection means from the employee operation result information storage means,
Past day personnel acquisition means for acquiring a past day personnel selected by the optimum past day selection means based on the employee identification information obtained by the optimum employee acquisition means;
Personnel excess / deficiency determination means for comparing the number of employees on the past day obtained by the previous day personnel acquisition means with the necessary personnel on the work shift planning target date obtained by the sales prediction information acquisition means, When,
It is identified by the identification information obtained by the optimum employee acquisition unit on the condition that the past day's personnel are determined to be more than the necessary personnel on the work shift planning target date by the personnel excess / deficiency determination unit. Comparing the evaluation score derived by the evaluation score deriving means of each employee, and selecting employee identification information up to the necessary personnel in order of the evaluation score,
It is identified by the identification information obtained by the optimum employee acquisition means on the condition that the number of employees on the past day is determined to be less than the required personnel on the work shift planning target date by the employee excess / deficiency determination means. An employee adding means for comparing the evaluation scores derived by the evaluation score deriving means for employees other than the employee, and selecting employee identification information for the shortage in descending order of evaluation scores;
If it is determined that there is no excess or deficiency of personnel by the personnel excess / deficiency determination means, the employee identified by the identification information obtained by the optimum employee acquisition means is the sunrise shift worker for the work shift planning, If it is determined that the number of employees on the past day is greater than the required personnel on the work shift planning date, the employee identified by the identification information selected by the employee selection means is assigned to the work shift planning date. When it is determined that the number of employees on the past day is less than the required personnel on the work shift planning target day, the employee identified by the identification information obtained by the optimum employee acquisition means and the employee A work shift plan table creating means for creating a work shift plan table with the employee identified by the identification information selected by the employee addition means as the sunrise worker who is the work shift planning target;
An output means for outputting the work shift schedule table;
A work shift plan table creation device characterized by comprising: Employee basic information storage means for storing work schedule information corresponding to identification information of each employee;
Referring to the work schedule information for each employee stored in the basic employee information storage means, the identification information obtained by the optimum employee acquisition means includes information on the employees who can attend the work shift planning date. And an attending employee extracting means for extracting identification information,
The past day personnel acquisition means acquires the past day personnel selected by the optimum past day selection means based on the employee identification information extracted by the attendance employee extraction means,
The employee addition means is obtained by the optimum employee acquisition means on the condition that the employee excess / deficiency determination means determines that the number of employees on the past day is less than the required personnel on the work shift planning target date. Compare the evaluation scores derived by the evaluation score deriving means for employees who are not identified by the identified identification information and are able to work on the work shift planning target day, 6. The work shift plan table creating apparatus according to claim 5, wherein the employee identification information is selected.   The similar past date extraction means includes an error for each of the sales forecast amount obtained as sales forecast information, the sales amount obtained as sales performance information, the predicted number of customers visited as sales forecast information, and the number of store customers obtained as sales performance information. The work shift plan table creation device according to any one of claims 1 to 6, wherein the similar past days are extracted in ascending order of error.

Images