A program that calculates and outputs regular working hours and overtime working hours for each product without using wage rates, and a computer-readable recording medium on which the program is recorded.

Abstract

This program provides a calculation and output of overtime hours etc. on a product-by-product basis in order to accurately and quickly calculate labor costs that reflect the actual labor conditions of product manufacturing without using wage rates. [Solution] Overtime hours, etc., which are calculated on a daily basis, are also calculated for each individual product manufacturing unit on that day, one record at a time, and a database is created in which three columns are added to each individual product manufacturing record on that day: a column for scheduled working hours, a column for statutory overtime hours, and a column for overtime working hours.

Description

[Technical Field]

[0001] Accurate and prompt labor cost calculation that reflects the actual labor conditions of product manufacturing without using wage rates To achieve this, we provide a program that calculates and outputs overtime hours for each product. It is something. This invention calculates and outputs the scheduled working hours, statutory overtime hours, and extra working hours by product, etc., which serve as the basis for calculating labor costs by product, construction, process, department, etc., without using wage rates. (When a company's scheduled working hours per day are less than the legal working hours (8 hours), legal overtime hours will occur.) [Background technology]

[0002] In the "Cost Accounting Standards," which are accounting standards for cost accounting, the calculation of labor costs is The wage rate (Number 1) is the labor hour unit price multiplied by the total actual working hours of the employee for each individual product when calculating the labor cost for each individual product in the case of producing multiple types of products (construction, etc.). (Formula 1) Wage rate = Total wages paid to the employee ÷ Total actual working hours for all products of the employee (Equation 2) Labor cost for each product = Total actual working hours for each product by the employee × Wage rate Substituting the wage rate in (Equation 1) into (Equation 2) and rearranging, we get Labor cost for each product = Total wages paid to the employee × (Total actual working hours for each individual product by the employee / Total actual working hours for all products by the employee) Therefore, from the above formula, we can see that the method of calculating labor costs using wage rates is a method of calculating labor costs by apportioning the total amount of wages paid based on the actual working hours used to manufacture the product (overtime hours, etc. remain unknown). Summary of the Invention [Problem to be solved by the invention]

[0003] The method of calculating labor costs using wage rates is a proportional calculation, so it does not accurately reflect the actual state of overtime work. Wage rates calculate the labor cost of each product by calculating the total actual working hours for all products and the actual working hours for each product individually, without knowing the breakdown of actual working hours for the production of the product, such as overtime (scheduled working hours, statutory overtime (which may or may not exist depending on the company. When a company's scheduled working hours per day are less than the statutory working hours (8 hours)), statutory overtime will occur), and overtime working hours. Therefore, when producing multiple types of products, the labor cost amount obtained from wage rates will lack accuracy. Furthermore, since calculation based on wage rates requires the total amount of wages paid to each employee, which is the result of wage calculations, labor costs are calculated after wage calculations have been made, which makes it less quick. The present invention provides a program for calculating overtime hours, etc. in product manufacturing, in order to accurately and quickly calculate labor costs that reflect the actual labor conditions in product manufacturing, without using wage rates. In other words, by calculating overtime hours, etc., which was previously only done on a daily basis, at the product level, there is no longer a need to use wage rates. [Means for solving the problem]

[0004] To solve the above problem in companies that manufacture multiple types of products, the program of the present invention calculates and outputs overtime hours for each individual product manufactured on that day, instead of calculating overtime hours on a daily basis. Each individual product manufactured on that day is saved as a tertiary database with three additional columns: a column for regular working hours, a column for legal overtime hours, and a column for overtime hours. Then, at the end of a certain period, the items in the three added columns can be extracted and totaled for each product and employee, and by multiplying them by the known unit price of each employee's regular working hour, statutory unit price of overtime work, and unit price of overtime work, labor costs that accurately reflect the actual overtime work can be calculated immediately without having to wait for payroll calculations. *All companies calculate overtime hours on a daily basis for the purpose of paying wages, and the present invention further allocates each actual labor H to each overtime, etc. hour for each task in each record of each individual product manufacturing unit. [Effects of the Invention]

[0005] (Regarding the effect of the invention in claim 1) In the program of claim 1, a tertiary database section, which adds four columns to the primary database, extracts and aggregates overtime hours using product numbers as the primary key and employee numbers as subkeys. The total of the results obtained by multiplying each employee's standard working hour rate, legal overtime hour rate, and overtime hour rate determines the labor cost for each product. Therefore, the program of the present invention does not use wage rates, eliminating the need to wait for wage calculations and allowing for rapid calculation of labor costs. Furthermore, by calculating overtime hours for each task involved in the manufacturing of individual products without pro rata calculations, accurate labor costs can be calculated based on the actual overtime hours. For companies using monthly settlements, if the monthly settlement period and the payroll closing period do not coincide, an adjustment calculation for that period is required. However, this invention eliminates this need. Furthermore, by extracting and aggregating overtime hours using only the employee number as the primary key, and multiplying this by the regular working hour rate, legal overtime hour rate, and overtime hour rate for each employee, it is also possible to calculate the amount of salary paid to each employee. (Regarding the effect of the invention in claim 3) With a general method that does not rely on a category value calculation function, in order to realize the first, third, and fifth functions, it is necessary to make case distinctions corresponding to the circumstances of the work start time and work end time for that product, but when a category value calculation function is used, there is no need to make case distinctions when calculating actual working hours, nor to consider whether or not there is a statutory overtime time classification, and processing can be done with a single category value calculation function, which is highly simple and versatile, and has the effect of making it easy to incorporate into the programs of other systems. [Brief explanation of the drawings]

[0006] [Figure 1]Overall view [Figure 2] Database section diagram [Figure 3] First function diagram (calculation of actual working hours) [Figure 4] Third function (calculating one day's worth of overtime, etc.) [Figure 5] Conversion diagram [Figure 6] Conversion explanation [Figure 7] Allocation of overtime hours (general method: regular working hours) [Figure 8] Allocation of overtime hours (general method, legal overtime hours) [Figure 9] Allocation of overtime hours (general method: overtime hours) [Figure 10] The domain of existence of the beginning and end [Figure 11] Upper limit candidate value [Figure 12] Lower limit candidate value [Figure 13] Start point judgment value / End point judgment value [Figure 14] Classification value calculation function (5th function) [Figure 15] Classification value calculation function 2 (5th function) DETAILED DESCRIPTION OF THE INVENTION

[0007] (1) First database section (see Figure 2) A database that records the manufacturing date, employee name, work start time, and work end time for each product (or construction project, etc.) of all employees for a certain period of time. (2) Creating a column of actual working hours: After the program for calculating the actual working hours obtained by subtracting break times from the work start time and work end time for each product manufacturing (the program for realizing the first function of claim 1) is implemented, a second database unit is created. (3) A program that calculates the scheduled working hours, statutory overtime hours, and extra working hours on a daily basis. A program that calculates the daily scheduled working hours, statutory overtime hours, and extra working hours from the total actual working hours of employees on that day. (Program for realizing the third function of claim 1) (4) Creating columns H for scheduled work, H for legal overtime, and H for overtime work: A program that calculates the actual working hours of the employee for manufacturing each product, including the scheduled working hours portion, the statutory overtime hours portion, and the extra working hours portion (a program for realizing the fifth function of claim 1). (5) Third Database Department The calculations (2) to (4) above are performed on all records, and a third database part is created in which four columns are added to the first database: the actual working hours column, the scheduled working hours subsequence, the statutory overtime hours subsequence, and the overtime working hours subsequence. [Example]

[0008] Regarding the calculation of actual working hours (first function; see Figure 3). The working hours etc. in the examples are based on the following assumptions. Working hours: 8:00 ~ 17:00 Scheduled working hours: 7.5 hours Legal overtime: 0.5 hours (7:30 - 8:00) After 8 hours of legal overtime Break time Morning break 10:00 ~ 10:15 Job Break 12:00 ~ 13:00 Afternoon Break 15:00 ~ 15:15 Actual working hours in a normal day refers to the time from the start time to the end time of work as stipulated in the work regulations, etc., minus break times. However, in the present invention, it is necessary to calculate overtime hours, etc., on a product-by-product basis, so the actual working hours in a work unit required for the present invention are the time from the start time (start time) to the end time (finish time) of work related to the manufacture of each product, minus break times between those works. In other words, Actual working hours per work unit = End time - Start time - Total break time... (Formula 1) However, when manufacturing multiple products, the start and end times of work for each product are not constant, so the break times between them cannot be determined. Therefore, in order to calculate the actual working hours for each product, it is necessary to consider the inclusion relationship between the three break categories and the work start time (start time) and end time (finish time) and to determine the break times between the start and finish times for that product's production. If the break times between these times can be determined, they can be substituted into the above formula (1) to calculate the actual working hours for that employee for each product manufacturing unit. Because the area created by the start time (P) and end time (Q) is continuous, the total break time at the reference company can only be 90 minutes, 75 minutes, 60 minutes, 15 minutes, or 0 minutes. If we divide these cases, we get the upper part of Figure 3. From Figure 3 (upper part), we can see that within a single work period, a total break time of 90 minutes is only possible in case (1) of Figure 3 (upper part), 75 minutes are possible in cases (2) and (3) of Figure 3 (upper part), 60 minutes are possible in case (4) of Figure 3 (upper part), and 15 minutes are possible in cases (5) and (6) of Figure 3 (upper part). Define the program variables for the start and end times of each break as follows: Before break S: Morning break start time Lunch break S: Lunch break start time After break S: Afternoon break start time Pre-break E: End of morning break Lunch break E: End of lunch break After-break E: End of afternoon break If we rearrange (1) to (6) in Figure 3 (upper part) in order of earliest start time (P) and latest end time (Q), and also take into account the calculation of break time in Note 1 below, we get the lower part of Figure 3. From the lower part of Figure 3, the start time (P) can be classified into four categories: (A) when it is on the outside left of the pre-break S ((1)(2)(5)(7-1) in the lower part), (B) when it is between the pre-break S and the lunch break S ((3)(4)(7-2) in the lower part), (C) when it is between the lunch break S and the post-break S ((6)(7-3) in the lower part), and (D) when it is after the post-break S (7-4). The end time (Q) from the lower part of FIG. 3 can also be classified into four cases: (a) when it is outside the right side of the post-break E (post-break E < Q) (in the lower part, (1), (3), (6), (7-4)); (b) when it is between the lunch break E and the post-break E (lunch break E < Q ≤ post-break E) (in the lower part, (2), (4), (7-3)); (c) when it is between the pre-break E and the lunch break E (pre-break E < Q ≤ lunch break E) (in the lower part, (5), (7-2)); and (d) when it is smaller than the pre-break E (in the lower part, (7-1)). Combining the above, when the total break time becomes 0, and displaying the program variables together, it will be as follows. (A) P < pre-break S and, (a) When post-break E < Q, total break time = 90 minutes (in the lower part, (1)) (b) When lunch break E < Q ≤ post-break E, total break time = 75 minutes (in the lower part, (2)) (c) When pre-break E < Q ≤ lunch break E, total break time = 15 minutes (in the lower part, (5)) (d) For other Q times (Q ≤ pre-break E), total break time = 0 minutes (in the lower part, (7-1)) (B) pre-break S ≤ P < lunch break S and, (a) When post-break E < Q, total break time = 75 minutes (in the lower part, (3)) (b) When lunch break E < Q ≤ post-break E, total break time = 60 minutes (in the lower part, (4)) (e) For other Q times (Q ≤ lunch break E), total break time = 0 minutes (in the lower part, (7-2)) (C) lunch break S ≤ P < post-break S and, (a) When post-break E < Q, total break time = 15 minutes (in the lower part, (6)) (f) For other Q times (Q ≤ post-break E), total break time = 0 minutes (in the lower part, (7-3)) (D) post-break S ≤ P (in the lower part, (7- / 4)) Let the CPU arithmetic unit read the start time and end time of a certain person's work on that day, and let the work start time P be selected in order from (A) to (D) above. When it is (A), and further let the end time Q be selected in order from (a). Then, any one of (a) to (d) can be specified. Therefore, the total break time at that time becomes the value to be substituted into the above (Equation - 1), and the first function can be realized. (Note 1) Regarding the calculation of break time. When the start time or end time is between the start line time and the end line time of each break period, it is reasonable to consider that there is no break during that break period. Therefore, when the start time or end time coincides with the start or end time of each break period, or is within the start time and end time, it is considered that there is no break in the break period where the start time or end time is located. Therefore, the dotted line parts such as the lower part (2) of FIG. 3 become parts where the original position of Q can be expanded. Also, in practice, when work encroaches on the lunch break and the lunch break time decreases, etc., in addition to the first item column such as the manufacturing date of the first database, an adjustment time column can be added, and the reduced time can be set as the adjustment time and entered in the adjustment time column. Then, the actual working hours of each product manufactured by that employee are (End time - Start time - Total break time + Adjustment time) ··· (Equation - 2) It will be obtained by. Calculation example; Refer to FIG. 5 (Reference A1). Product A; The work start time P = 8:00 and the work end time Q = 14:00. So P corresponds to (A) P < Morning break S above, and Q corresponds to (b) When Lunch break E < Q ≤ Afternoon break E. The total break time at that time is 75 minutes. Therefore, the actual working hours of Product A are Actual working hours of Product A = 14:00 - 8:00 - 1:15 = 4:45 Product B; The work start time P = 14:00 and the work end time Q = 17:15. So P corresponds to (C) Lunch break S ≤ P < Afternoon break S above, and Q corresponds to (a) When Afternoon break E < Q. The total break time at that time is 15 minutes. Therefore, the actual working hours of Product B are Actual working hours of Product B = 17:15 - 14:00 - 0:15 = 3:00 Product C; The work start time P = 17:15 and the work end time Q = 20:00. So P corresponds to (D) Afternoon break S ≤ P above. Therefore, in this case, regardless of the value of Q, the total break time at that time is 0 minutes. Therefore, the actual working hours of Product C are Actual working hours of Product C = 20:00 - 17:15 = 2:45 As a result of the above calculations, it coincides with (Reference A2) in FIG. 5.

[0009] Regarding the third function, which calculates an employee's overtime hours, etc. on a daily basis. As can be seen from Figure 4, the total actual labor H, which is the sum of each actual labor H related to the employee's daily product manufacturing, has only three work situations: when it exceeds the statutory working hours of 8 hours, when it is between 7.5 hours and 8 hours, and when it is 7.5 hours or less. In Figure 4 (1), if the total actual work hours H(α) exceed the legal working hours of 8 hours, the regular working hours portion is 7.5 hours, the legal overtime portion is 0.05 hours, and the portion is the total actual work hours H(αH) minus 8 hours (α-8H). Figure 4 (2): When the total actual work H(α) is between 7.5 and 8 hours, the scheduled working hours portion is 7.5 hours, the legal overtime hours portion is the total actual work H(αH) minus 7.5 hours (α-7.5 hours), and the overtime hours portion is naturally 0 hours. Figure 4 (3): When the total actual work H(α) is 7.5 hours or less, the scheduled working hours portion is αH, and the legal overtime hours portion and the extra working hours portion are both 0 hours. The above can be summarized as the following program code: (A) When α>8H ((1) in Figure 4) Scheduled working hours = 7.5 hours Legal overtime hours = 0.5 hours Overtime work hours = α-8H (B) When 0<α≦8H ((2) in Figure 4) Scheduled working hours = 7.5 hours Legal overtime hours = α-7.5H Overtime hours = 0 (C) When α≦7.5H ((3) in Figure 4) Scheduled working hours = αH Legal overtime hours = 0 Overtime hours = 0 The third function can be realized by having the CPU calculation unit calculate the total number of hours of actual work H for the employee in question related to the production of a product for one day, and then identifying one of the above (A), (B), or (C) from the total actual work H(α), and calculating the scheduled working hours, legal overtime hours, and extra working hours at that time. Calculation example: See Figure 5 (Reference A2). The total of each actual working time for Reference A2 is α = 10:30. Therefore, since it corresponds to the above (A) α > 8H, the calculation formula at that time is as follows: Scheduled working hours = 7.5 hours Legal overtime hours = 0.5 hours Overtime hours = α-8H = 10:30-8:00 = 2:30 This is consistent with the total in Figure 5 (Reference A4).

[0010] Before explaining the allocation of overtime and other time (the fifth function), let's talk about the "necessity of time conversion." Overtime hours are calculated from actual working hours excluding break times, but the manufacturing time for each product is not completed within a fixed time, but changes from day to day and is not constant, so naturally the actual time involved in manufacturing each product also changes. The allocation of overtime hours by product is calculated based on the total of each actual working time, which changes, so the work start and end times for each product in the first DB cannot be used as is, and must be calculated using converted times based on actual working hours. See Figure 5 For example, if the production status of each product by that person on that day is shown in Figure 5 (Reference A1), then consider it as in Figure 5 (Reference A5), and the conversion work start time for the first product manufactured, Product A, is 0:00 and the conversion work end time is 4:45, for Product B work starts at 4:45 and ends at 7:45, and for Product C work starts at 7:45 and ends at 10:30. In other words, the conversion work start time for the first product is 0:00, and the conversion work end time for the last product is the total of the person's actual working hours for that day. When the CPU calculation unit reads the work start time and work end time from the first DB, the work start time P1 for the person's first manufactured product of the day (Product A in Figure 6) is converted to 0:00. The work end time Q1 for Product A is then converted to (K1)H. Subsequently, the converted work start time for Product B's work start time P2 is (K1)H, and the converted work end time is (K1+K2)H. The converted time for the final product's work start time Pn is (K1+K2+···Kn-1)H, and the converted end time for the final product's work end time Qn is (K1+K2+···Kn-1+Kn)H. In terms of program code, K1 to Kn are repeatedly executed as shown in the lower part of Figure 6. Hereafter, the start time and end time of the work related to the following fifth function shall be conversion times.

[0011] Regarding the allocation of overtime hours (fifth function). First stage: Regarding the calculation of the regular working hours part Since the regular working hour division area starts at 0:00 and ends at 7:30, even in the work situation related to the manufacture of multiple types of products, the position of the conversion start time P is either P = 0:00 (see (1) and (2) in Figure 7), or P is within the regular working hour division area (in program variable display, 0 < P ≤ the specified HE, see (3) and (4) in Figure 7), or P is outside the right side of the regular working hour division area (in program variable display, the specified HE ≤ P, see (5) in Figure 7), and there are only three cases. The position of the conversion end time Q is either in the right outer division area of the regular working hour division area (the specified HE ≤ Q, see (1), (3), and (5) in Figure 7), or within the regular working hour division area (in program variable display, the specified 0 < Q < the specified HE, see (2) and (4) in Figure 7), and there are only two cases. Summarizing this in the variables of the program code, it is as follows. (A) When P = 0:00 (in (1) and (2) of Figure 7) and (a) When the specified HE ≤ Q, the regular working hour occupancy = 7.5H (in (1) of Figure 7) (b) When 0 < Q < the specified HE, the regular working hour occupancy = Q (in (2) of Figure 7) (B) When 0 < P ≤ the specified HE (in (3) and (4) of the lower part of Figure 7) and (c) When the specified HE ≤ Q, the regular working hour occupancy = 7.5H - P (in (3) of Figure 7) (d) When 0 < Q < the specified HE, the regular working hour occupancy = Q - P (in (4) of Figure 7) (C) When P is other than the above, the regular working hour occupancy = 0 minutes The arithmetic unit of the CPU calculates the conversion start time P and the conversion end time Q from the work start time P and the work end time Q before conversion, and selects which of the above (A), (B), and (C) P corresponds to. For example, when P is (A), further select which of (a) and (b) Q corresponds to. The predetermined labor time occupancy amount at the corresponding time is the predetermined labor time portion included in the manufacturing time of a certain product of that person on that day. Calculation example; refer to Fig. 5 (Reference A3). For Product A, P = 0:00 and Q = 4:45. Therefore, in the above (A) where P = 0:00 and (b) 0 < Q < the predetermined HE, the predetermined labor time occupancy amount corresponds to Q. Predetermined labor time for Product A = 4:45 (Q) For Product B, P = 4:45 and Q = 7:45. Therefore, in the above (B) where 0 < P ≤ the predetermined HE and (c) the predetermined HE ≤ Q, the predetermined labor time occupancy amount corresponds to 7.5H - P. Predetermined labor time for Product B = 7:30 - 4:45 = 2:45 For Product C, P = 7:45 and Q = 10:30. Therefore, P corresponds to the above (C) and there is no predetermined labor time. The result of the calculation matches the predetermined labor time column in Reference A4 of Fig. 5. Second paragraph Regarding the portion of overtime within the law The area of overtime within the law starts at 7:30 and ends at 8:00. Therefore, even in the work situation related to the manufacture of multiple types of products, the positions of the conversion start time P and the conversion end time Q can only be in three cases: outside the left side of the overtime within the law start time, within the overtime within the law division area, or outside the right side of the overtime within the law division area. Organizing this gives the following. That is, regarding the start time P (A) When P is in the area outside the left side of the overtime within the law (P ≤ the legal overtime HS, (1), (2), (3) in Fig. 8) (B) When P is within the overtime within the law (The legal overtime HS < P ≤ the legal overtime HE, (4), (5) in Fig. 8) (C) When P is in the area outside the right side of the overtime within the law (The legal overtime HE < P, (6) in Fig. 8) There are three such cases. Regarding the end time Q, (a) When Q is in the outer right region of the legal overtime hours zone (Legal overtime remaining HE ≤ Q, (1), (4), (6) of Figure 8) (b) When Q is within the legal overtime hours zone (Legal overtime remaining HS < Q ≤ Legal overtime remaining HE, (2), (5) of Figure 8) (c) When Q is in the outer left region of the legal overtime hours zone (Q ≤ Legal overtime remaining HS, (3) of Figure 8) There are three cases as above. After organizing these and adding the calculation formula for the legal overtime occupancy, it is shown in Figure 8. When representing (1) - (6) of Figure 8 with program variables, it is as follows. (A) When P ≤ Legal overtime remaining HS and Q is (a) When Legal overtime remaining HE ≤ Q (Figure 8's (1)), <00002​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​Legal overtime hours of Product A = 0 For Product B, P = 4:45 and Q = 7:45. Therefore, it falls under (A) when P ≤ legal overtime HS and (b) when legal overtime HS < Q ≤ legal overtime HE. According to the calculation formula at that time, the proportion of legal overtime hours occupied = Q - legal overtime HS Proportion of legal overtime hours occupied = Q - legal overtime HS = 7:45 - 7:30 = 0:15 For Product C, P = 7:45 and Q = 10:30. Therefore, P falls under (B) when legal overtime HS < P ≤ legal overtime HE and (a) when legal overtime HE ≤ Q. According to the calculation formula at that time Proportion of legal overtime hours occupied = legal overtime HE - P = 8:00 - 7:45 = 0:15 The calculation results of Products A to C above match the legal overtime hours column in Reference A4 of Figure 5 Third section: Regarding the overtime work hours part The overtime work hour section starts from 8:00 and ends at the total time of each actual work hour. Therefore, the position of the conversion start time P is either less than 8:00 (in program variable display, P ≤ 8:00 (Figure 9 (1)·(2))) or greater than 8:00 (in program variable display, P ≥ 8:00, Figure 9 (3)), and the end time Q is the same. (Note 2) Simply, there are a total of 4 cases. However, since P < Q, the case where 8:00 > P and Q < 8:00 is impossible, so there are the following 3 cases Summarized in program variable display (A) When P ≤ 8:00 (), and Q is (a) When 8:00 ≤ Q (Figure 9 (1)), Proportion of overtime work hours occupied = Q - overtime HS (8:00) (b) When Q < 8:00 (Figure 9 (2)) Proportion of overtime work hours occupied = 0 (B) When 8:00 < P, and Q is (a) When 8:00 ≤ Q (Figure 9 (3)), Proportion of overtime work hours occupied = Q - P The CPU calculation unit can select either (A) or (B) above from the start time P, and either (a) or (b) from the end time Q at that time, and the amount of overtime work time occupied at that specified time is the overtime work portion included in the production time for that person's product on that day. Calculation example: See Figure 5 (Reference A3). Product A P=0:00, Q=4:45 (A) This corresponds to when P≦8:00 and (b) when Q<8:00, so the calculation formula at that time is Overtime work hours occupied = 0, so there is no overtime work hours. Product B P = 4:45, Q = 7:45 (A) This corresponds to when P≦8:00 and (b) when Q<8:00, so the calculation formula at that time is Overtime work hours occupied = 0, so there is no overtime work hours. Product C P = 7:45, Q = 10:30 (A) When P ≦ 8:00, (a) when 8:00 ≦ Q, the calculation formula is: Overtime work hours occupied = Q - overtime HS Overtime work hours occupied = Q - overtime HS = 10:30-8:00 = 2:30 The calculation results for the above products A to C match the overtime hours column in Reference A4 in Figure 5.

[0012] What is a division value? When a certain time (or distance) interval is divided into multiple (N) segments, and one starts (departs) from any of the segments and ends (arrives) at any segment after the starting point, the amount of time or distance for each segment included between the starting point (the time the work begins) and the ending point (the time the work ends) is called the segment value. At this time, if we classify the positional relationship between the division (J division) sandwiched between the other divisions on both sides, which is arbitrarily selected from multiple divisions, and the fluctuation region (large and small variable) created by P (start time) and Q (end time), we can see that there are six types as shown in Figure 10. The division value at that time is (A1): When P is on the left outside of the J section and Q is on the right outside of the J section, that is, in the program variable display, When P≦JS (J-division start time) and Q≧JE (J-division end time), the division value in this case is (Formula A1) Discrimination value = JE - JS (B1): When P is outside the left of the J section and Q is inside the J section, that is, in variable display When P ≤ JS (start time of the J section) and JS < Q < JE, the discrimination value in this case is (Formula B1) Discrimination value = Q - JS (E1): When P is outside the left of the J section and Q is also outside the left of the J section, that is, in variable display When P ≤ JS and Q ≤ JS, the discrimination value in this case is (Formula E1) Discrimination value = 0 (C1): When P is inside the J section and Q is outside the right of the J section, that is, in variable display When JS < P < JE and Q ≥ JE, the discrimination value in this case is (Formula C1) Discrimination value = JE - P (D1): When P is inside the J section and Q is also inside the J section, that is, in variable display When JS < P < JE and JS < Q < JE, the discrimination value in this case is (Formula D1) Discrimination value = Q - P (E2): When both P and Q are outside the right of the J section, that is, in variable display When JE ≤ P and JE ≤ Q, the discrimination value in this case is (Formula E2) Discrimination value = 0 It becomes as follows.

[0013] Regarding the upper limit candidate value The calculation formulas of the discrimination values in the above (A1) to (D1) are subtraction calculations that subtract the smaller value (hereinafter referred to as the lower limit value) from the larger value (hereinafter referred to as the upper limit value). Therefore, in Fig. 10, when the position of the work end time (Q) is outside the right of JE, inside the J section, and outside the left of JS in order, Fig. 11 can be created. When representing (1) to (3) in Fig. 11 in variable display, (1) When Q is on the right side of JE, that is, when JE ≤ Q Upper limit value = JE (2) When Q is within the J section, that is, when P < Q < JE Upper limit value = Q (3) When Q is to the left of JS, that is, when Q ≤ JS J section value = 0 Then, when functionalizing for the case where the upper limit value exists from (1) and (2) above, (Conditional expression 1): As the upper limit candidate determination expression Upper limit candidate value = (if JS < Q < JE then Q, if Q ≥ JE then JE) can be derived.

[0014] Regarding the lower limit candidate value When organizing the position of the work start time (P) in the order of being in the left area of JS, being within the J section, and being in the right area of JE, Figure 12 can be obtained. Representing (1) to (3) in Figure 12 with variables, (1) When P is to the left of JS, that is, when P ≤ JS Lower limit value = JS (2) When P is within the J section, that is, when P < Q < JE Lower limit value = P (3) When P is to the right of JE, that is, when P ≥ JE J section value = 0 Then, when functionalizing for the case where the lower limit value exists from (1) and (2) above, (Conditional expression 2): As the lower limit candidate determination expression Lower limit candidate value = (if JS < P < JE then P, if P ≤ JS then JS) can be derived.

[0015] From Figure 11, it can be seen that the upper limit candidate value exists as a value other than 0 when Q is outside the right side (Q > JS) of the J section start time line (JS), and the upper limit candidate value becomes zero (0) when it is on the left side (Q ≤ JS) of the J section start time line (JS). That is, it shows that the section value = 0 when Q ≤ JS, and the section value can exist when Q > JS. Functionalizing this, the following equation can be introduced. (Conditional expression 3): As the end point determination expression End point determination value = 'Value 1 when Q > JS, value 0 when Q ≤ JS' Similarly, from Fig. 12, it can be seen that the lower limit candidate value exists as a value other than 0 when P is outside the left side (P < JE) of the J section end time line (JE), and the lower limit candidate value becomes zero (0) when it is on the right side (P ≥ JE) of the J section end time line (JE). That is, the time division value = 0 when P ≥ JE, and it indicates that a division value can exist when P < JE. By functionalizing this, the following equation can be introduced. (Conditional expression 4): As the start point determination formula Start point determination value = 'Value 1 when P < JE, value 0 when P ≥ JE'

[0016] The division value not being 0 means that both the upper limit candidate value and the lower limit candidate value exist. Therefore, in the above conditional expressions 3 and 4, when the upper limit candidate value can exist, 1 is given as the end point determination value, and when the lower limit candidate value can exist, 1 is given as the start point determination value. Then, when both the upper limit candidate value and the lower limit candidate value exist, it is the following equation Start point determination value × End point determination value = 1 It can be seen that this holds only when (see Fig. 13). This means that, as described in the previous section 0012, the J section in conditional expressions 1 to 4 is an arbitrarily selected section area. Therefore, which section area among the multiple section areas it is can be determined by (conditional expressions 3 and 4) By specifying the range of P < JE and Q > JS, it can be seen that the J section is specified.

[0017] That is, the division value calculation function takes the following four arguments Argument 1: Work start time (P), Argument 2: Work end time (Q), Argument 3: Start time of the section area (hereinafter referred to as JS), Argument 4: End time of the section area (hereinafter referred to as JE) Performs the following internal calculations Start point determination value = (1 if P < JE, 0 if P ≥ JE) End point determination value = (1 if Q > JS, 0 if Q ≤ JS) Upper limit candidate value = (Q if JS < Q < JE, JE if Q >= JE) Lower limit candidate value = (P if Sj < P < JE, JS if P <= JS) These four values are substituted into the following (Equation - 3) to obtain the occupied time of the corresponding section as the return value of a function (Equation - 3); The corresponding section value = start point determination value × end point determination value × {upper limit candidate value - lower limit candidate value}

[0018] Regarding the realization of the fifth function (distribution of overtime etc. time) by the section value calculation function When the converted start time and converted end time of that person on that day are on the upper side of FIG. 14, the four arguments in FIG. 15's reference B - 1 diagram for each of the products A, B, and C are read into the section value calculation function to calculate the overtime etc. time. For product A, the section value for the regular working hours part, the section value for the legal overtime hours part, and the section value for the extra - working hours part are calculated by the section value calculation function. Next, for products B and C, the same process is repeated, and the overtime etc. time for each product of that person on that day can be calculated Let JS (start time of the corresponding section) and JE (end time of the corresponding section) be used as variable displays (1) Distribution calculation of overtime etc. time for product A Regular working hours part (refer to FIG. 15's reference B - 1 diagram) Start point determination value = (1 if P < JE, 0 if P ≥ JE) From FIG. 15's reference B - 1 diagram, P = 0:00 and JE = 7:30, so P = 0:00 < JE = 7:30 → Therefore, start point determination value = 1 End point determination value = (1 if Q > JS, 那么 0 if Q ≤ JS) From FIG. 15's reference B - 1 diagram, Q = 4:45 and JS = 0:00, so Q = 4:45 > JS = 0:00 → Therefore, end point determination value = 1 Upper limit candidate value = (Q if JS < Q < JE, JE if Q >= JE) From FIG. 15's reference B - 1 diagram, JS = 0:00, Q = 4:45, and JE = 7:30, so JS = 0:00 < Q = 4:45 < JE = 7:30 → Therefore, upper limit candidate value = Q = 4:45 Lower limit candidate value = (if JS < P < JE then P, if P <= JS then JS) From the reference B-1 diagram in Figure 15, JS = 0:00, P = 0:00, JE = 7:30, so JS = 0:00 = P = 0:00 < JE = 7:30 → Therefore, lower limit candidate value = P(=JS) = 0:00 From the above, the classification value calculation function returns, according to (Equation - 3), The said classification value = starting point determination value × ending point determination value × {upper limit candidate value - lower limit candidate value}, The said classification value (predetermined working hours part) = 1 × 1 × (4:45 - 0:00) = 4:45 is returned. Overtime within the law part (refer to the reference B-1 diagram in Figure 15) Ending point determination value = (if Q > JS then 1, if Q <= JS then 0) From the reference B-1 diagram in Figure 15, JS = 7:30, Q = 4:45, so Q = 4:45 < JS = 7:30 → Therefore, ending point determination value = 0 Therefore, according to (Equation - 3), the said classification value (overtime within the law part) = 0 Overtime outside working hours part (refer to the reference B-1 diagram in Figure 15) Ending point determination value = (if Q > JS then 1, if Q <= JS then 0) From the reference B-1 diagram in Figure 15, JS = 8:00, Q = 4:45, so Q = 4:45 < JS = 8:00 → Therefore, ending point determination value = 0 Therefore, according to (Equation - 3), the said classification (value overtime outside working hours part) = 0 (2) Allocation calculation of overtime hours for Product B Predetermined working hours part (refer to the reference B-1 diagram in Figure 15) Starting point determination value = (if P < JE then 1, if P >= JE then 0) P = 4:45 < JE = 7:30 → Therefore, starting point determination value = 1 Ending point determination value = (if Q > JS then 1, if Q <= JS then 0) Q = 7:45 > JS = 0:00 → Therefore, ending point determination value = 1 Upper limit candidate value = Q if JS < Q < JE, JE if Q >= JE Q = 7:45 > JE = 7:30 → Therefore, upper limit candidate value = JE = 7:30 Lower limit candidate value = P if JS < P < JE, JS if P <= JS JS = 0:00 < P = 4:45 < JE = 7:30 → Therefore, lower limit candidate value = P = 4:45 From the above, the section value calculation function returns, as the return value, (Equation - 3)'s The said section value = start point determination value × end point determination value × {upper limit candidate value - lower limit candidate value}, The said section value (predetermined working hours portion) = 1 × 1 × (7:30 - 4:45) = 2:45 is returned. Overtime work hours within the law (refer to Reference B - 1 in Figure 15) Start point determination value = 1 if P < JE, 0 if P >= JE P = 4:45 < JE = 8:00 → Therefore, start point determination value = 1 End point determination value = 1 if Q > JS, 0 if Q <= JS Q = 7:45 > JS = 7:30 → Therefore, end point determination value = 1 Upper limit candidate value = Q if JS < Q < JE, JE if Q >= JE JS = 7:30 < Q = 7:45 < JE = 8:00 → Therefore, Upper limit candidate value = Q = 7:45 Lower limit candidate value = P if JS < P < JE, JS if P <= JS P = 4:45 < JS = 7:30 → Therefore, lower limit candidate value = JS = 7:30 From the above, the section value calculation function returns, as the return value, by (Equation - 3), The said section value = start point determination value × end point determination value × {upper limit candidate value - lower limit candidate value}, The said section value (overtime work hours within the law portion) = 1 × 1 × (7:45 - 7:30) = 0:15 is returned. Overtime work hours (refer to Reference B - 1 in Figure 15) End point determination value = 1 if Q > JS, 0 if Q <= JS Q = 7:45 < JS = 8:00 → Therefore, end point determination value = 0 Therefore, according to (Equation - 3), the classified value (overtime work hours part) = 0 (3) Allocation calculation of overtime hours for Product C Regular working hours part (refer to Reference B - 1 in Figure 15) Starting point determination value = (1 if P < JE, 0 if P ≥ JE), so P = 7:45 > JE = 7:30 → Therefore, starting point determination value = 0 Therefore, according to (Equation - 3), the classified value (regular working hours part) = 0 Statutory overtime hours part (refer to Reference B - 1 in Figure 15) Starting point determination value = (1 if P < JE, 0 if P ≥ JE), so P = 4:45 < JE = 8:00 → Therefore, starting point determination value = 1 Ending point determination value = (1 if Q > JS, 0 if Q ≤ JS), so Q = 10:30 > JS = 7:30 → Therefore, ending point determination value = 1 Upper limit candidate value = (Q if JS < Q < JE, JE if Q ≥ JE), so Q = 10:30 > JE = 8:00 → Therefore, upper limit candidate value = JE = 8:00 Lower limit candidate value = (P if JS < P < JE, JS if P ≤ JS), so JS = 7:30 < P = 7:45 < JE = 8:00 → Therefore, lower limit candidate value = P = 7:45 From the above, the classified value calculation function returns, according to (Equation - 3), the classified value = starting point determination value × ending point determination value × {upper limit candidate value - lower limit candidate value} as the classified value (statutory overtime hours part) = 1 × 1 × (8:00 - 7:45) = 0:15 is returned Overtime work hours part (refer to Reference B - 1 in Figure 15) Starting point determination value = (1 if P < JE, 0 if P ≥ JE), so P = 7:45 < JE = 10:30 → Therefore, starting point determination value = 1 Ending point determination value = (1 if Q > JS, 0 if Q ≤ JS), so Q = 10:30 > JS = 8:00 → Therefore, the end point determination value = 1 The upper limit candidate value is obtained from (if JS < Q < JE then Q, if Q >= JE then JE) JS = 8:00 < Q = 10:30 < JE = 10:30 → Therefore, The upper limit candidate value = JE(=Q) = 10:30 The lower limit candidate value is obtained from (if JS < P < JE then P, if P <= JS then JS) P = 7:45 < JS = 8:00 → Therefore, the lower limit candidate value = JS = 8:00 From the above, the boundary value calculation function returns, according to (Equation - 3), The said boundary value = start point determination value × end point determination value × {upper limit candidate value - lower limit candidate value} That is, The said boundary value (overtime work time part) = 1 × 1 × (10:30 - 8:00) = 2:30 is returned. From the above, the right - hand side figure of Figure B - 2 in Figure 15 is obtained.

[0019] Regarding the realization of the first function (calculation of actual working hours) by the boundary value calculation function. The breaks are as follows. Morning break S: Morning break start time (10:00), Morning break E: Morning break end time (10:15) Lunch break S: Lunch break start time (12:00), Lunch break E: Lunch break end time (13:00) Afternoon break S: Afternoon break start time (15:00), Afternoon break E: Afternoon break end time (15:15) Between the work start time (P) and work end time (Q) of a certain product of a certain person on that day in the first - level DB (1) Obtain the morning break time using the boundary value calculation function. Send the work start time (P) as argument 1, work end time (Q) as argument 2, morning break S (10:00) as argument 3, and morning break E (10:15) as argument 4 to the arithmetic unit of the CPU Obtain the morning break time as the return value of the boundary value calculation function. (2) Obtain the lunch break time using the boundary value calculation function. Send the work start time (P) to argument 1 of the division value calculation function, the work end time (Q) to argument 2, lunch break S (12:00) to argument 3, and lunch break E (13:00) to argument 4, and obtain the lunch break time as the return value of the division value calculation function. (3) The afternoon break time is calculated using the division value calculation function. Send the work start time (P) to argument 1 of the division value calculation function, the work end time (Q) to argument 2, the after-break S (15:00) to argument 3, and the after-break E (15:15) to argument 4, and obtain the afternoon break time as the return value of the division value calculation function. Add up the rest times obtained in (1) to (3) above to find the total rest time, and then substitute this into the formula below: The actual working hours for that work period = End time Q - Start time P - Total break time is obtained. Calculation example: See (Reference A1) in Figure 5. Reprint: Starting point judgment value = (P <JEならば1、P≧JEならば 0) End point judgment value = (1 if Q>JS, 0 if Q≦JS) Upper limit candidate value = (JS <Q<JEならばQ、Q> =JE then JE) Lower limit candidate value = (JS <P<JEならばP、P<=JSならばJS) (Formula-3); Category value = Start point judgment value × End point judgment value × {Upper limit candidate value - Lower limit candidate value} Product A Work Start H (P = 8:00) Work End H (Q = 14:00) (1) Morning break (previous break S = 10:00, previous break E = 10:15) Start point judgment value = 1 (P = 8:00 < Pre-break E = 10:15) End point judgment value = 1 (Q = 14:00 > previous break S = 10:00) Upper limit candidate value = 10:15 (Q = 14:00 > previous day E = 10:15) Lower limit candidate value = 10:00 (P = 8:00 < previous day S = 10:00) (Formula-3) Morning break time = 10:15-10:00 = 0:15 (2) Lunch break (lunch break S = 12:00, lunch break E = 13:00) Start point judgment value = 1 (P = 8:00 < Lunch break E = 13:00) End point judgment value = 1 (Q = 14:00 > Lunch break S = 12:00) Upper limit candidate value = 13:00 (Q = 14:00 > Lunch break E = 13:00) Lower limit candidate value = 12:00 (P = 8:00 < Lunch break S = 12:00) (Formula-3) Morning break time = 13:00-12:00 = 1:00 (3) Afternoon break (afternoon break S = 15:00, afternoon break E = 15:15) End point judgment value = 0 (Q = 14:00 ≦ After break E = 15:15) According to (Equation 3), afternoon break time = 0 Based on (1) to (3) above, the total break time is 1:15. Actual working hours for Product A = Q(14:00)-P(8:00)-1:15=4:45 Products B and C are calculated in the same way, resulting in Reference A2 in Figure 5.

[0020] Regarding the realization of the third function (calculation of overtime hours etc. on a daily basis) using the segment value calculation function. If the total actual work H (the total actual working hours of the person in question in one day) is α hours, (1) Scheduled working hours The following arguments are read into the division value calculation function of the CPU's calculation unit. Argument 1: Work start time (P), Argument 2: Work completion time (Q), Argument 3: Start time of the relevant area (hereinafter referred to as JS) = 0:00, Argument 4: End time of the relevant section (hereafter referred to as JE) = 7:30. The return value is the corresponding division value (prescribed working hours part) (2) Legal overtime hours The following arguments are read into the division value calculation function of the CPU's calculation unit. Argument 1: Work start time (P), Argument 2: Work completion time (Q), Argument 3: Start time of the relevant area (hereinafter referred to as JS) = 7:30, Argument 4: End time of the relevant section (hereafter referred to as JE) = 8:00. The return value is the corresponding division value (legal overtime hours). (3) Overtime work hours The following arguments are read into the division value calculation function of the CPU's calculation unit. Argument 1: Work start time (P), Argument 2: Work completion time (Q), Argument 3: Start time of the relevant area (hereinafter referred to as JS) = 8:00, Argument 4: End time of the relevant region (hereafter referred to as JE) = α:00. The return value is the corresponding segment value (overtime work time portion) The third function is realized by executing the above operations (1) to (3). Calculation example: See (Reference A2) in Figure 5. The total actual working hours for each item in Reference A2 is 10.5 hours. Therefore, α=10:30 Therefore, Argument 1; P = 0:00, Argument 2; Q = 10:30 (1) Scheduled working hours Starting point judgment value = 1 (P = 0:00 <JE=7:30より) End point judgment value = 1 (from Q=10:30>JS=0:00) Upper limit candidate value = 7:30 (from Q = 10:30 > JE = 7:30) Lower limit candidate value = 0:00 (P = 0:00 ≦ JS = 0:00) (Formula-3) Scheduled working hours = 7:30 - 0:00 = 7:30 (2) Legal overtime hours Starting point judgment value = 1 (P = 0:00 <JE=8:00より) End point judgment value = 1 (Q = 10:30 > JS = 7:30) Upper limit candidate value = 8:00 (from Q = 10:30 > JE = 8:00) Lower limit candidate value = 7:30 (P = 0:00 ≦ JS = 7:30) (Formula-3) Legal overtime hours = 8:00-7:30 = 0:30 (3) Overtime hours Starting point judgment value = 1 (P = 0:00 <JE=10:30より) End point judgment value = 1 (from Q=10:30>JS=8:00) Upper limit candidate value = 10:30 (Q = 10:30 ≧ JE = 10:30) Lower limit candidate value = 8:00 (P = 0:00 <JS=8:00より) (Formula-3) Legal overtime hours = 10:30-8:00 = 2:30 The above (1) to (3) correspond to the total column of Reference A4 in Figure 5. [Explanation of symbols]

[0021] Morning break S: Morning break start time Pre-break E: End time of morning break Lunch Break S: Lunch break start time Lunch Break E: End time of lunch break Post-break S: Afternoon break start time Afternoon break E: End time of afternoon break JS: Time of the start of the division JE: Time at which the division ends P: Work start time Q: Work completion time

Claims

1. In a computer equipped with a primary database (hereinafter referred to as the primary DB) that records the manufacturing date, employee number, product number, work start time, and work end time for multiple types of products manufactured by each employee on each day during a certain period, A first function of reading the work start time and work end time related to the manufacturing of each product in the primary DB into the arithmetic unit of the computer (hereinafter referred to as the CPU) and calculating the actual working hours related to the product; a second function that uses the output device of the CPU to add an actual working time column to the primary DB, outputs and saves the actual working time calculated by the first function in this added column, and creates a secondary DB; The actual working hours of the Kth employee for each manufactured product on that day obtained from the second DB (k1, a third function that calculates the daily scheduled working hours, statutory overtime hours, and extra working hours of the Kth employee from the total hours (k1 + k2 + . . . ki + kn) of the Kth employee (hereinafter referred to as "actual working hours H"); A fourth function temporarily stores the value calculated by the third function in a storage device. A fifth function is to read the start and end times of the employee's work related to the manufacturing of that product from the secondary DB into the calculation unit of the CPU, and calculate the scheduled working hours portion, statutory overtime hours portion, and overtime working hours portion (hereinafter referred to as overtime hours portion) that make up each actual work H based on the start and end times of the work converted into actual working hours. a sixth function of temporarily storing the value calculated by the fifth function in a storage device of the CPU; A seventh function of adding a column for regular working hours, a column for legal overtime hours, and a column for overtime working hours to the secondary database, and outputting the regular working hours, legal overtime hours, and overtime working hours from the storage device saved in these added columns by the sixth function to the secondary DB; This is executed for all employees on a daily basis, and then executed for all days for a certain period of time to create the second DB. The columns for actual working hours, scheduled working hours, legal overtime hours, and overtime hours have been added. A system for creating, saving, and outputting a third-level database. Interval calculation program.

2. In a computer equipped with a primary database (hereinafter referred to as the primary DB) that records the manufacturing date, employee number, product number, work start time, and work end time for multiple types of products manufactured by each employee on each day during a certain period, A first function of reading the work start time and work end time related to the manufacturing of each product in the primary DB into the arithmetic unit of the computer (hereinafter referred to as the CPU) and calculating the actual working hours related to the product; a second function that uses the output device of the CPU to add an actual working time column to the primary DB, outputs and saves the actual working time calculated by the first function in this added column, and creates a secondary DB; The actual working hours of the Kth employee for each manufactured product on that day obtained from the second DB (k1, a third function that calculates the daily scheduled working hours, statutory overtime hours, and extra working hours of the Kth employee from the total hours (k1 + k2 + . . . ki + kn) of the Kth employee (hereinafter referred to as "actual working hours H"); A fourth function temporarily stores the value calculated by the third function in a storage device. A fifth function is to read the start and end times of the employee's work related to the manufacturing of that product from the secondary DB into the calculation unit of the CPU, and calculate the scheduled working hours portion, statutory overtime hours portion, and overtime working hours portion (hereinafter referred to as overtime hours portion) that make up each actual work H based on the start and end times of the work converted into actual working hours. a sixth function of temporarily storing the value calculated by the fifth function in a storage device of the CPU; A seventh function of adding a column for regular working hours, a column for legal overtime hours, and a column for overtime working hours to the secondary database, and outputting the regular working hours, legal overtime hours, and overtime working hours from the storage device saved in these added columns by the sixth function to the secondary DB; This is executed for all employees on a daily basis, and then executed for all days for a certain period of time to create the second DB. The columns for actual working hours, scheduled working hours, legal overtime hours, and overtime hours have been added. A computer-readable recording medium that records an overtime calculation program characterized by having the function of creating, saving, and outputting a third-level database.

3. 2. The overtime work calculation program according to claim 1, wherein the first function, the third function, and the fifth function are realized by a division value calculation function.

4. A computer-readable recording medium having recorded thereon the overtime hours calculation program described in claim 1, characterized in that the first function, the third function, and the fifth function are realized by a division value calculation function.

Images