Attendance Management System Assessment and Sustainability Performance at a Telecommunication Operation Centre in Malaysia

Journal of Environmental Treatment Techniques

2020, Volume 8, Issue 1, Pages: 471-480

J. Environ. Treat. Tech.

ISSN: 2309-1185

Journal web link: http://www.jett.dormaj.com

Attendance Management System Assessment and

Sustainability Performance at a Telecommunication

Operation Centre in Malaysia

Nooramirah Najwa Borhanuddin, Roslina Mohammad , Norazli Othman and Zuritah A.Kadir

Razak Faculty of Technology and Informatics, Universiti Teknologi Malaysia

Received: 27/11/2019

Accepted: 24/01/2020

Published: 20/02/2020

Abstract

In the increasing and rapid competitive and challenging environment in the organization, the influence of attendance on the overall

performance of workers is a necessary element of business management. In this paper, the study attempts to propose an improvement of the

attendance management tool’s evaluation to track employees key-performance-indicators (KPI) at a telecommunication operation centre in

Malaysia. The revealed the primary cause for verification and assessment of attendance records and measurement of staff KPI in the

Telecommunication Operation Centre. The analysis was carried out to verify the attendance records versus the performance applied using

DMAIC with the R Studio Programming and staff handbook performance measurement. The R Studio Programming was proposed as an

automation measurement for individual workers and to improve the new staff handbook’s Telecommunication Operation Centre with an

improved attendance measurement KPI per the individual’s performance. The findings of this research will serve as a guide for many

organizations later on, in order to improve the staff’s performance handbook. Furthermore, it may additionally benefit the organization as an

effective administration tool for employee attendance in the future.

Keywords: DMAIC, Absenteeism, KPI, Performance, Attendance, Sustainability

Introduction¹

concern in across enterprise telecommunication Operation

Centres. The influence of attendance on the overall performance

of workers is a necessary element of business management, as

naturally it is not a question that attendance has a significance as.

For this study it was a necessary trouble to help decide how a good

deal is obligatory for attendance in a company. Many researchers

have found high-quality research on the importance of family

members between attendance and the overall performance in

exclusive topics at various universities and agencies [5].

Attendance analysis and performance has becoming a trend in a

business organization, as well as in education institutes which

have become necessary for checking various activities such as

student performance, their capability, interests, weaknesses which

needs consideration, faculties of performances, overall

performance branch, department and much more [6].

The telecommunication Operation Center still practices a

manual way for evaluation of the attendance records. Besides,

supervisors want to manually analyze a range of absences and

calculate the share of the current input from the attendance listing

being amassed or recorded. A total of 40 group of workers,

calculated their absenteeism manually with the aid of unique

units. This was time consuming and the result of the calculation

could possibly go wrong if the manager ignored some of the

information in the attendance record. In addition, managers need

Under Sustainability goal development [1], Goal 8: Decent

work and economic growth, it stressed and encourage on The

SDGs promote sustained economic growth, higher levels of

productivity and technological innovation. According to

Olagunju et al., 2018[2] time is money. These emphases on the

impact of time and punctuality in business. Unfortunately, time

management issues are a major problem for some individuals.

This consists of the capability to precisely measure and

manipulate the time and attendance of staff. In organisations,

attendance management systems are necessary to keep track of

the worker’s hours [3]. It can be done by using time recording

sheets, the use of spreadsheets, punch timecards, or using online

time and attendance software programs for the enterprise. These

days, due to the large number of employees, working time

monitoring machines come in a much more extensive of format,

from simple paper based formats to complicated automatic

systems. Research from RAND Europe 2017 on the frequent 12

months fee for health-related absenteeism and being present, per

corporations is estimated at RM2.7 million. Malaysia has

committed sixty-seven days per employee per year, 58.8 days of

which were due to to being present, whilst the remaining 8.2 days

had been attributed to the actual absence from work [4]. Over the

last years, employee absenteeism has emerged as a fundamental

Corresponding author: Roslina Mohammad, Razak Faculty of Technology and Informatics, Universiti Teknologi Malaysia. Email:

mroslina.kl@utm.my.

Journal of Environmental Treatment Techniques

2020, Volume 8, Issue 1, Pages: 471-480

to manually write the details of the attendance facts in the

documents when needed. The Show Cause Letter (SCL) will be

given to the workforce when the staff is late to work, for a time

greater than three times in month according to the company’s

employee attendance policy. However, all attendance statistics

need to be analyzed manually first, before the warning letter and

attendance report documents can be crammed in. All this work

increases the manager’s workload. Although there is a system that

has been established to hyperlink between the employee’s

fulfillment and the employee’s attendance, fulfillment statistics is

determined by individual, but attendance is not.

Absenteeism = Number of man days scheduled

to work X 100

(1)

The absenteeism cost can be calculated for special employees

and for distinct time intervals like month and year. The frequency

rate displays the incidence of absence and is typically expressed

as the variety of separate absence in a given period, irrespective

of the measurement of absences. The frequency cost represents

the frequent number of absences per human beings in a given

duration [9] as in equation 2 below:

Based on the previous analysis records of attendance, there

have problems on the manual verification process which is lack

of analysis records and calculation which was done by staff. No

appropriate document to justify the late arrival employees

according to the company’s employee attendance policy is

available. The indicator for measuring the absenteeism rate per

employee is not used as reference. Furthermore, the rate

represents the average number of absences per workers which are

not standardized.

Frequency Rate = Total number of man days scheduled

to work X 100

(2)

An immoderate severity rate shows that the worker is absent

for longer periods each and every time. High frequency and

severity costs point out that the worker is absent for much larger

frequencies and for longer lengths every time, which results in

excessive absenteeism even in absolute phases. The severity rate

can be calculated as shown in equation 3:

Currently, the staff handbook measurement for KPI

competency only measure the staff performance per individual

based on the completion of the task competency. It is critical for

the attendance performance due to the productivity measurement

per individual staff that impacts the whole team’s morale.

Otherwise, it is encouraging that the employee’s productivity and

attendance performance records are managed well.

푆푒푣푒푟ꢀ푡푦 푅푎푡푒

푇표푡푎푙 푛푢푚푏푒푟 표푓 푑푎푦푠 푎푏푠푒푛푡 푑푢푟ꢀ푛푔 푎 푝푒푟ꢀ표푑

푇표푡푎푙 푛푢푚푏푒푟 표푓 푡ꢀ푚푒푠 푎푏푠푒푛푡 푑푢푟ꢀ푛푔 푡ℎ푎푡 푝푒푟ꢀ표푑

100 (3)

Data from a three year’s record from NOC 1 and NOC 2 for

The monitoring of employee performance for attendance

management is not been performed by the organization.

Generally, management performance for attendance is checked

using the unit division report attendance, not only for the

employee’s performance KPI competency. The measurement of

attendance is not in standard value for it to be used as an indicator

for performance competency. It is does not manage the

employee’s attendance performance according to the staff

handbook KPI performance.

the Malaysian Telecommunication operation Centre is gathered

and calculated. Figure 1 and 2 showed the absenteeism rate for

the year 2016 to 2018. The highest of absenteeism rate was 2.458

rate for year 2017, compared to the previous year in 2016, only

.403 for NOC 1. In the year 2018 up to September 2018, the

absenteeism rate had a high record in July 2018 at 2.105. For NOC

, the highest rate was 1.875, 2.6, 2.458 for 2016, 2017 and 2018

respectively.

It showed some boundaries in the sense that common absence

Table 1 showed the late arrival record in 2016 and 2017 for

this organization. It showed that at least once a month, there was

a late arrival recorded. There has been a tremendous increase of

late arrival for NOC 1 for the year 2017. The company’s aim is to

reduce the trend line was in line to reduce the impact to cost and

increase the overall operational performance.

price can relate to fewer absences over a much longer duration, or

various shorter absences. Storage of attendance administration

data can divulge lots of facts on making use of exclusive

evaluation techniques.

ABSENTEEISM (RATE) 3 YEARS

RECORD - NOC 1

Table 1: Late arrival record years 2016 and 2017 at Malaysian

Telecommunication Operation Centre

Year

Unit/

2.403

.458

2.105

Month

016

017

NOC 1

NOC2

NOC 1

NOC2

Low morale employees with a high absence price will affect

2016

2017

2018

the overall success of the organisation’s goals and their

profitability in the market [7]. This calculation of the absenteeism

rate provides the average organisational ailing depart absence

charge or proportion of working time inside a business enterprise,

which has been misplaced due to absence. The number of Man-

day lost complies with the formulas [8] as in equation 1 below:

Figure 1: Absenteeism rate for NOC 1 team as percentage of working

time per annum, 2016-2018

Journal of Environmental Treatment Techniques

2020, Volume 8, Issue 1, Pages: 471-480

are required to manipulate extra workloads is also well

documented.

ABSENTEEISM (RATE) 3 YEARS

RECORD - NOC 2

In the Basic Conditions of Employment Act, an employee is

entitled to 30/36 working days’ unwell leave over the course of 3-

years (this is dependent on whether an employee works a 5 or 6-

day week) [15]. If the entire workforce interior a business

company collectively, takes their full entitlement, the company’s

absenteeism rate will run at about 4%. It is commonly believed

that if a cost falls inside this, then the absenteeism figures are best

and no in additional action is required. By correctly analysing

absenteeism, organizations can make financial savings in

operational efficiency.

2.458

.875

Based on research by [16] evaluating in opposition to a

national average is one way to find out if workers may have an

absenteeism problem. However, it is no longer a comparison, due

to the fact that health problem absence varies significantly

depending on matters like enterprise measurement and industry

as follow: (a) median sickness absence for Public sector: 7% and

(b) median sickness absence for Private sector: 2.2%. Over an

average duration, and other charges quoted here, this typically

refers to arithmetic means. The dilemma of the mean price is that

the weight is given to each occurrence is according to its

magnitude. Thus, extreme values are emphasised over centre

values. This is particularly important in the absence of statistics

considering the tendency for this to be skewed, that is, large

numbers of humans have only a few days absence, whilst small

numbers have very long absences [17]. Some observers

recommend the use of the median value to summarise absence

information sets. The median is calculated by putting the

observed values in an ascending or descending order of

magnitude, and then finding the central cost of these.

This version splits down even in terms of addition when

showing a specific industry. For example, the median time

misplaced to disorder absence for the retail industry is solely

1.8%, whereas the public health employers have a sky high

excessive median of 4.2%. Unsurprisingly, the greater the

commercial enterprise company is, the worse the absence tiers

get: (a) less than 100 employees:1.8%; (b) 100-249 employees:

2.3%; (c) 250-999 employees: 2.8%; and (d) 1,000 + employees:

3.7%.

The absenteeism rate per worker is under 1 percent (unlikely

result in actual life). This will probably be the end result across

200 or more employees with no absent days, and the relaxation of

these employees with a few absenteeism days a year.Absent

employees compromise the profitability of the employer by

decreasing the usual productivity and performance of the team of

workers [18]. As shown in Table 2, the annual cost of productivity

due to absenteeism, the excessive value of misplaced

organizational productivity and the motivational factors of every

day working personnel affect the sustainability of the

organizational performance. Lost employee productivity,

leadership intimidation and abuse, and worker fitness problems

can impact worker absenteeism, which affects organizational

performance. In business, employee absenteeism is the

predominantly a cause for lost productiveness [19]. The intention

for leaders of groups is to be the center of attention on the

economic bottom line of growing profits and workplace

productivity, whilst lowering the organizational expenses.

According to a survey of 94,000 workers, by the Gallup-

Sharecare Well-Being Index, the annual price associated with

016

2017

2018

Figure 2: Absenteeism rate for NOC 2 team as percentage of working

time per annum, 2016-2018

Due to greater expectations from the administration toward

personnel, some of assessment needed to be advocated to improve

the present size of the group of worker’s performance records.

This paper attempts to propose an improvement of the attendance

management tools evaluation to the track employee’s

performance KPI at a telecommunication operation center in

Malaysia. The findings of this research will serve as a guide for

many organizations later on in order to improve the staff

performance handbook. Furthermore, it may additionally be

beneficial to the organization for the effective administration of

employee attendance in future.

According to Cucchiella [10] and Christianson [11] the

definition of absenteeism is a “habitual absence from work for

one or more days, generally justified with the aid of clinical

certificate but, actually, due to-personal hobbies and bad sense of

duty.” As an employee’s failure to document work, it was a

pattern of lacking work in which a worker is habitually and

regularly absent. Failing to manipulate employee attendance

affects the high quality with regards to excessive price in any

organization. Employee absenteeism has a direct effect on the

stage of the carrier University [12] excessive levels of

absenteeism leads to inferior satisfactory of service, misplaced

productivity, and decreased morale of co-workers. Consistent

management of attendance problems can have fairly fantastic

outcomes in the workplace. It is acknowledged that an

organization has to face this bad connotation of the phenomenon.

An ethical organization has to reflect on the consideration for the

work life balance of its employees, by respecting their free time

and by leaving ample time for the activities such as maternity and

paternity. It is handy to define the absenteeism, the research of its

motives is not effortless, because the phenomenon is rooted in

many elements of the current lifestyles [13].

Maintaining a suitable attendance file at work consists of

more than just calling in ill regularly. It additionally has the

capacity to begin job duties on time, staying on the job at some

stage in the day to complete duties accurately and attending all

scheduled meeting and appointments. Employees are the

organization’s most valuable property. Reporting late to work and

leaving before the shift can have a bad effect on the productivity

of organizations. According to [14] managing absence is a

challenge for companies as it influences productivity, customer-

service standard, morale and profits. Its strain on colleagues who

Journal of Environmental Treatment Techniques

2020, Volume 8, Issue 1, Pages: 471-480

absenteeism differs by the way of the industry, with the greatest

loss occurring across professional occupation [20].

algorithm to rely on. In this lookup, most of the facts were already

available, but the opportunity lacks information/data that may

also require obtaining the course of the research period. All the

acquired statistics for the evaluation in the literature review,

record review and commentary have been arranged in Figure 3 to

ease the lookup works. The records will analyse based on the

lookup goals (RO’s) that have been acquired from legitimate

lookup question (RQ’s) from the lookup perspective.

Table 2: The cost of lost productivity by major U.S occupations

Annual cost of lost

Occupation

productivity due to

absenteeism (in billions)

Professional

$24.2

$15.7

$8.5

$6.8

$5.6

$3.6

$3.5

$2.8

$2.0

$1.5

$1.3

$0.25

$0.16

Managers/executives

Service workers

Sales

School teachers (K-12)

Nurses

Transportation

Manufacturing/production

Business owners

Installation/repair

Construction/mining

Physicians

Farmers/foresters/fishers

Employee absenteeism has a long-term effect on decreased

workplace productiveness [21], which is asserted by the fact that

employee absenteeism minimizes the organizational earnings and

productivity because other employee has to fill in for the work

hours of absent employees. In essence, absenteeism results in

agencies being understaffed, even though the employee roster is

unchanged. Other authors [22] claimed that employee

productiveness decreases each and every day due to the fact that

managers have to hire, train, and supervise new temporary

personnel to meet business deadlines. Lost productivity prices

related to absenteeism, being present and unpaid work, are hardly

ever covered in the valuation of health-related expenses [23]. The

total loss of productiveness prices amplify due to the worker’s not

being present; a condition which requires personnel to attend

work when ill, which effects in accelerated worker absenteeism.

In particular, [23] cited that the manager’s failure to deliver

information personnel and apprehend the effect of absenteeism

and being present on the business enterprise would be a probable

result in the persisted misplaced productivity.

The lookup is all about the Effect of Absenteeism on the

student’s performance [24], the end result of the findings show

that there are three foremost elements or symptoms which are

badly affected by the means of absenteeism i.e. class participation

coordination of college students with teachers and peers and the

third is the Grades of students. Attendance policy makers ought

to provide incentives or rewards to encourage the students to meet

the required attendance as a result of the academic outcomes of

the students and the corporation which can become outstanding.

Figure 3: DMAIC Research

DMAIC is a data-driven first-class method used to enhance

processes. It is an integral section of a Six Sigma initiative, but is

widely wide-spread and can be applied as a standalone

enchantment method or as part of another method improvement

initiative such as lean [25,26,27].

.1 Identify

The research seeks to identify the current practice of

attendance verification records processes. By determining the

problem of the issue and of the new approach or existing one is

effective. From the current process given in Figure 4, an employee

captures the daily attendance using the current system’s

attendance management in the Telecommunication Operation

Centre. The attendance records as an auto data pushed into the

server. Every month the attendance data extracts from the server

and customizes the report manually. The validation approval by

the manager will be presented as an attendance performance

report at the top management meeting. Furthermore, the author

will focus in the green area and discuss the root cause using the

fishbone method.

.2 Analyze

Methodology

The target of population was 40 staff of the

In this study, Qualitative lookup was used as a collection data

Telecommunication Operation Centre located in Kuala Lumpur,

Malaysia. The qualitative research methods using the verification

attendance records, will be using two years of attendance

management records that were extract from the data server.

Further, authors will have collected via observation on site over

approximately 8 months. The data random 2 team in NOC 1 and

NOC 2 will help to analyze of early arrival and late arrival “time-

in”. The analysis data using the R Studio programming for each

individual attendance measure, in order to accumulate qualitative

method and the theories were developed based on that data. The

problem statement asks, “What are the root causes and solutions

to improve the verification of attendance to all employee that can

used as standard tools and attendance performance in the staff

handbook KPI?”. Several researchers recommended that a

modern-day practice of attendance verification documents that a

quasi-experimental lookup sketch is most fabulous when it lacks

the key ingredient, test variables, or no strong fundamental of

Journal of Environmental Treatment Techniques

2020, Volume 8, Issue 1, Pages: 471-480

data statistical, the place of the employee’s attendance document

databases statistics mining evaluation the use of R Programming

method to report the result. It can impact the result if it is not clear

and valid. The fourth bones are material root because which

causes the process to analyze manually every attendance excel file

and identify the number of absenteeism for all employees. Every

unit needs to be counted and the percentage calculated for all staff

using the excel formula.

(

R Studio) tools. R Studio is a statistical computing language and

tool which is environmentally friendly to operate data evaluation

5].

[

Figure 5: Fishbone Diagram

Figure 4: Current Process for Attendance verification in

Telecommunication Operation Centre

3.2 Design

The motion lookup format used is to be decided for this

lookup study. This used to be deliberated to become aware of the

staff’s punctuality time in or late arrival time in. Eight-month

intervention cycles were used to be deliberate for the identified

employees. Triangulation in data series were used and applied

with the aid of opting for qualitative and quantitative modes of

information series and tools.

.3 Improvement

All collected data will be key-in using R Studio programming

software. Researchers will use the attendance excel records to

import the R Studio programming using the computing language

in the command in the editor view. The measurement of the

analysis refers to the formula in previous research works and

modified using the author code editor. Furthermore, all the key-

in data will be tabulated based on the sections of the research

questions. All the collected data will be prepared for qualitative

data analysis.

.2.1 Participants

The observation checklist was designed to record the data of

employees in the Telecommunication Operation Centre. The first

tool devised by the researchers was to attain quantitative data

from the attendance record server. The second tool was designed

in order to gather qualitative data where the employees time in

their attendance using attendance system management at Level 29

located office.

Results and Discussion

.1 Identify the Problem

A fishbone diagram, also referred to as a motive and effect

graph or Ishikawa diagram as shown in Figure 5, was a

visualization device for categorizing the potential reasons of a

trouble in order to become aware of its root cause [25]. To define

the issue of current verification and assessment of the attendance

records and measurement of staff KPI using the fishbone tool. The

first bone representing “Man”. Identifying a problem’s root cause

under competency “bone”, it is lack of verification of attendance.

It is because of the remarks of justification which were given and

were not confident enough to make decisions. Furthermore, no

appropriate document to justify the absences for the workers. As

referred to in figure 3.2, the process of verification and validation

will make the records a repeatable process and reviewed by the

manager. The second bone was “Machine”. Identifying a root

cause in second bones are limitation of the privilege. The

limitation for attendance record view and access attendance

server’s records. Employees’ KPI performance only can be

measured by the competency of the initiative working level on a

yearly basis. For the present, the measurement for the attendance

absenteeism rate uses the manual calculation basis.

.2.2 Data Analysis

The data list on site was analyzed to explore if there were any

significant times when the employee’s arrival was late for worki.

This experience will help researchers to understand the trends of

working time.

Based on the Telecommunication Policy clause 9 - working

hours [28], starts at 8:30am every Monday until Friday. From the

NOC 1 graph in figure 6, a total of 18 staff arrived at 08:00am,

and the total of 12 staff showed up on-time at 08:30am. Late

arrivals were recorded at 09:00am with a total of 16 staff. Perhaps

the most fact was that the character episodes of being late can be

contagious to others and contributes to a counterproductive

organizational attendance culture. Although there is a constrained

lookup on early departure, it was possible to acquire undesirable

penalties for oneself, co-workers, and the agency compared to

sequences of being late to work [26]. In figure 7 from the NOC 2

team analysis data collection, the data showed that for on-time

arrival or early arrival at 08:30am, a total of 19 staff compared

with that of the NOC 1 result. Meanwhile, for late time-in at

The third bone representing “Method”. In the third bones

method, the root cause of verifying attendance is not through

standardization as there are no indicator tools to measure the

attendance absenteeism rate. Furthermore, staff use their own

9:00am the result was only 9 staff. Experiments were performed

to understand the large records of employees. Using two year’s

records to analysis the absenteeism rate measurement by manual

Journal of Environmental Treatment Techniques

2020, Volume 8, Issue 1, Pages: 471-480

assessments is difficult to perform. For the scope of the research,

a set of 40 registered employee records were selected.

it, and recapitulate the recognized relationships. It helps with

finding correlations or patterns along with dozens of fields in

massive relational databases [5].

.2.3 Data Mining

Analyzing statistics provides a unique point of view. Mining

allows the user to analyze facts from many dimensions, classify

30-Aug-18

24-Jul-18

18-May-18

11-Apr-18

12-Mar-18

4-Jan-18

29-Aug-18

23-Jul-18

17-May-18

10-Apr-18

9-Feb-18

3-Jan-18

28-Aug-18

22-Jun-18

16-May-18

9-Apr-18

8-Feb-18

2-Jan-18

27-Aug-18

21-Jun-18

15-May-18

16-Mar-18

7-Feb-18

27-Jul-18

20-Jun-18

14-May-18

15-Mar-18

6-Feb-18

26-Jul-18

19-Jun-18

13-Apr-18

14-Mar-18

5-Feb-18

25-Jul-18

18-Jun-18

12-Apr-18

13-Mar-18

5-Jan-18

1-Jan-18

NOC 1

08:30am 25 minit 20 minit 15 minit 10 minit 5 minit 08:00am 5 minit 10 minit 15 minit 20minit 25minit 09:00am

early

Minutes

Figure 6: NOC 1 graph time arrival

0-Aug-18

4-Jul-18

8-May-18

1-Apr-18

2-Mar-18

29-Aug-18

23-Jul-18

17-May-18

10-Apr-18

9-Feb-18

28-Aug-18

22-Jun-18

16-May-18

9-Apr-18

8-Feb-18

27-Aug-18

21-Jun-18

15-May-18

16-Mar-18

7-Feb-18

27-Jul-18

20-Jun-18

14-May-18

15-Mar-18

6-Feb-18

26-Jul-18

19-Jun-18

13-Apr-18

14-Mar-18

5-Feb-18

25-Jul-18

18-Jun-18

12-Apr-18

13-Mar-18

5-Jan-18

NOC 2

08:30am 25 minit 20 minit 15 minit 10 minit 5 minit 08:00am 5 minit 10 minit 15 minit 20minit 25minit 09:00am

early

Minutes

Figure 7: NOC 2 graph time arrival

Journal of Environmental Treatment Techniques

2020, Volume 8, Issue 1, Pages: 471-480

.2.4 Data Analysis using R Studio Programming

As the records were collected, we processed the attendance

NOC 2 Absenteeism Rate Vs % Work Effort

data, analyzed it and deduced the following perception out of it:

7.44%

6.16

68.00%

67.00%

(Steps)

)

Total Days count in two years

Attendance status

Total Working Days count (present)

Total Non-Working Days count (Leave, holidays,

Optional Holidays, weekly Off days).

Percentage of Working Days

Total Working Hours

Maximum Working Effort (count in Hours) in a single

day

6.00%

5.00%

64.00%

63.00%

62.00%

61.00%

60.00%

2.18

62.52%

)

Minimum Working Effort (count in Hours) in a single

day

)

Statistical info – Mean, Median, Mode

Absenteeism Rate

Percentage of work effort

0) Histogram and Density Plot of Attendance Data

Figure 9: NOC 2 Absenteeism Rate vs % work effort graph

The result of the individual sampling from NOC 1 and NOC

for a total of 40 staff will refer to figures 8 and figure 9 below,

The research analysis using R Studio measurement

tools performed individual result as shown in table 3 and table 4

below. The coding method using previous researcher findings for

absence measure formula and measure of attendance working

hour. Research code editor using the author’s own coding

performed the factor analysis with the R tool for checking the

result with the best possibility.

which shows an increase in attendance rating which will also

increase the productive performance. Meanwhile, the low

absenteeism rate will have an effect on the excessive proportion

of staff work effort. Figure 8 shows that the employee’s have a

4.75% higher work effort that was because the score of

absenteeism rate was low at a rate of 4.51 as showed in table 3.

Meanwhile, for employee with lower percentage of work effort,

this was at 62.52% due to absenteeism rates being at 6.16 as

showed in table 4.

Table 3: 20 staff NOC 1 result analysis using R Studio

Programming

Total Working

Total Working Absenteeism

Percentage of

work effort

Employee ID

Days (within 2

years)

463

NOC 1 Absenteeism Rate Vs % Work Effort

Hours

Rate

6.18

66.00%

65.00%

64.00%

63.00%

62.00%

61.00%

60.00%

59.00%

Employee 1

Employee 2

Employee 3

Employee 4

Employee 5

Employee 6

Employee 7

Employee 8

Employee 9

Employee 10

Employee 11

Employee 12

Employee 13

Employee 14

Employee 15

Employee 16

Employee 17

Employee 18

Employee 19

Employee 20

4421.45 hours

4432.93 hours

4482.74 hours

4452.46 hours

4419.11 hours

4409.79 hours

4428.79 hours

4358.4 hours

4463.35 hours

4495.67 hours

4447.37 hours

4471.63 hours

4482.43 hours

4459.42 hours

4448.22 hours

4492.49 hours

4499.99 hours

4369.2 hours

4446.91 hours

4409.79 hours

5.33

4.65

5.06

5.47

5.19

6.18

5.06

4.51

5.19

4.92

4.78

5.06

63.34%

63.47%

64.15%

63.75%

63.33%

63.20%

63.47%

61.25%

64.02%

64.75%

63.74%

64.02%

64.15%

63.88%

63.61%

64.29%

64.43%

62.65%

63.61%

63.20%

4.75%

464

4.51

469

466

463

61.25%

462

464

457

468

471

466

468

Absenteeism Rate

Percentage of work effort

469

467

Figure 8: NOC 1 Absenteeism Rate vs % work effort graph

466

470

4.65

4.37

6.02

5.2

Figure 9 shows that employee 10 that 67.44% higher of the

471

work effort that was because the score of absenteeism rate was

only at 2.81. Compared to the result from employee 14d, with

lowe percentage work effort 62.52% have higher values on

absenteeism rate result at 6.16.

458

465

462

5.47

Journal of Environmental Treatment Techniques

2020, Volume 8, Issue 1, Pages: 471-480

Table 4: 20 staff NOC 2 result analysis using R Studio

absenteeism_rate

Programming

Total Working

Result:

Total Working Absenteeism

Percentage of

work effort

Employee ID

Days (within 2

years)

475

Hours

Rate

Employee 1a

Employee 2b

Employee 3c

Employee 4d

Employee 5e

Employee 6f

Employee 7g

Employee 8h

Employee 9i

Employee 10j

Employee 11a

Employee 12b

Employee 13c

Employee 14d

Employee 15e

Employee 16f

Employee 17g

Employee 18h

Employee 19i

Employee 20j

4537.12 hours

4535.52 hours

4446.91 hours

4413.88 hours

4567.19 hours

4574.26 hours

4645.27 hours

4369.2 hours

4439.43 hours

4693.28 hours

4432.93 hours

4459.42 hours

4369.2 hours

4358.4 hours

4428.79 hours

4369.2 hours

4439.43 hours

4495.67 hours

4645.27 hours

4492.49 hours

4.1

64.98%

63.61%

63.20%

65.52%

65.80%

66.75%

62.65%

63.61%

67.44%

63.47%

63.88%

62.65%

62.52%

63.47%

62.65%

63.61%

64.43%

66.75%

64.29%

Step 4: To measure Non-working hour within 2 years’ record

Total Non-Work Days in these 2 years

Non_Working_Hours<-length(Non_Working_Hours)

Non_Working_Hours

475

3.83

5.2

465

462

5.33

3.29

3.28

2.6

479

481

488

Result:

458

6.02

5.19

2.18

5.33

5.06

6.02

6.16

5.19

6.02

5.19

4.51

2.6

465

493

Step 5: To measure percentage of work effort – working days

464

#Percentage of Work Effort

467

Percentage_Working_Days<-(Working_Days/All_days)*100

Percentage_Working_Days

458

457

464

458

Result:

465

471

488

Step 6: To calculate Total Working Hours

470

4.65

Total Working Hours

Total_Working_Hours<-sum(Working_Hours)

Total_Working_Hours

The computing language command were defined with the

following steps: (running sampling from employee 17 in NOC 1

team)

Result:

Step 1: To find the various attendance record file

Attendance Data form APR16-MAR18 (2 years)

Step 7: To identify maximum working hour in a single day

attendance_data<-"attendancedata_employee17.cvs"

attendance_Data<-

read.csv(("C:/Users/TM33604/Documents/Data_Analysis/attend

ancedata_employee17.csv"), header = TRUE)

DateRecords<-as.Date(attendance_Data$Date, format ="%d-%b-

Maximum effort in a Single day

maximum_Working_Hours<- max(Working_Hours)

maximum_Working_Hours

Result:

y")

Attendance

Step 8: To identify minimum working hour in a single day

#Minimum effort in a Single day

minimum_Working_Hours<- min(Working_Hours)

minimum_Working_Hours

Attendance<-subset(attendance_Data$Total.Attendance.Hours,

attendance_Data$Total.Attendance.Hours >= 0)

Total Days in these 2 years

All_days <- length(Attendance)

All_days

Result:

Step 9: To find Statistic information (Mean, Median, Mode)

Statistical Informations

Step 2: To find Individual status

Mean<- mean(Working_Hours, 2)

Mean

Median<- median(Working_Hours, 2)

Median

finding Individual Attendance Status (current storage not appear

status of staff no thumbprint)

Attendance_Status<- table(attendance_Data$Status)

Attendance_Status

Mode<- as.numeric(names(sort(-table(Working_Hours)))[1])

Mode

Result:

Results:

Step 3: To measure Absenteeism Rate

absenteeism rate

absenteeism_rate<-(earned_Days/All_days)*100

Journal of Environmental Treatment Techniques

2020, Volume 8, Issue 1, Pages: 471-480

Step 10: Finally, to plot the Histogram per individual result

standard_deviation<- sd(Working_Hours)

standard_deviation

handbook in figure 10 and the new improvement proposed in

figure 11 and figure 12 below.

Histogram and Density Plot of Working Effort

hist(Working_Hours, prob = TRUE, col = "gold", breaks = 100,

ylab = "Frequency", xlab = "Working Hours", main = "Working

Hours[APR16-MAR18]")

Density Plot

lines(density(Working_Hours), lwd = 1, col ="red")

Indicating Mean, Median, Mode Lines in the Histogram

abline(v c(Mean,Median,Mode), col

c("brown","green","blue"),lwd = c( 1,1,1))

Including Legend in the historgram

legend(x ="topright",

Plot","Mean","Median","Mode"),

col = c("red","brown","green","blue"), lwd = c(1,1,1,1))

c("Density

Figure 11: Current Staff Handbook view

In new the improvement staff handbook KPI competency, the

finding analysis showed that the data mining of the attendance

helped cover our goal to utilize large data records in the

organization. Using these records, several measurement analysis

and performance can be performed for percentage of attendance

work effort on an individual basis.

Result:

Figure 5: Histogram and Density plot of attendance data – sampling

employee17

.3 Improvement

The process from the current verification will help

managers to validate the measurement attendance using R Studio

Tools. Furthermore, it will help to improve new processes for

attendance verification in the Telecommunication Operation

Centre.

Figure 12: New Staff Handbook view

Conclusion

The study revealed the cause of the issue in verifying and

assessing attendance records and measurement of staff KPI in the

Telecommunication Operation Centre. The analysis of the

verification attendance records versus performance was applied

with DMAIC with the R Studio Programming and the staff

handbook performance measurement. The

Studio

Programming was proposed as an automation measurement for

individual workers and to improve new staff handbook

Telecommunication Operation Centres with improved attendance

measurement KPI per individual performance. It was

recommended for future studies to explore:

Figure 10: New process for Attendance verification in

Telcommunication Operation Centre

The research has proposed an improvement staff handbook

with attendance measurement KPIs for the Telecommunication

Operation Centre [28, 29]. The new staff handbook shows the

new additional sub table for NOC productivity attendance

measurement for staff competency as referred to the current staff

The relationship between attendance and performance

assessment of the employee which is fairly and positively

correlated as it influences productivity performance.

Journal of Environmental Treatment Techniques

2020, Volume 8, Issue 1, Pages: 471-480

An increase in attendance score will also increase

productivity performance, while low absenteeism rates will

impact high percentage of work staff efforts.

Attendance records will help management and researchers to

identify other factors affecting the staff’s productivity

performance and discipline in the organization.

[9] Oghuvbu, E. P. Attendance and academic performance of students in

secondary schools: A correlational approach. Studies on Home and

Community Science; 2010, 4(1), 21-25.

[

10] Cucchiella, F., Gastaldi, M., & Ranieri, L. Managing absenteeism in

the workplace: the case of an Italian multiutility company. Procedia-

Social and Behavioral Sciences; 2014, 150, 1157-1166.

[

11] Christianson, L. K. Defining a Model to Reduce and Prevent

Absenteeism in the Workplace. The College of St. Scholastica, 2018.

12] Manitoba, U. O. Attendance Management Program. University of

Manitoba. 2018, page 1-30)

13] Bakker, A. B., Demerouti, E., De Boer, E., & Schaufeli, W. B. Job

demands and job resources as predictors of absence duration and

frequency. Journal of vocational behavior; 2003, 62(2), 341-356.

14] Egan, G. (2011). An Investigation into the Causes of Absenteeism

in'Company X'. Dublin, National College of Ireland, 1-10.

Aknowledgment

The authors would like to express the greatest appreciation

and utmost gratitude to the Ministry of Higher Education,

MyBrain15 MyPhD Ministry of Higher Education, UTM Razak

School of Engineering & Advanced Technology and Universiti

Teknologi Malaysia (UTM) for all the support given in making

the study a success. VOT UTM: Q.K130000.2656.16J42.

[

[15] Bydawell, M.Managing Employee Absenteeism. Available online on

016. Cited on 10 Novemeber 2019. Retrieved from

http://hrtorque.co.za/managing-employee-absenteeism-acceptable-

rate/

16] Kirwan, J.Benchmarking sickness absence: How do you compare.

Available online on 2017. Cited on 10 Novemeber 2019. Retrieved

from https://www.peoplehr.com/blog

Ethical issue

Authors are aware of, and comply with, best practice in

publication ethics specifically with regard to authorship

[

(avoidance of guest authorship), dual submission, manipulation

of figures, competing interests and compliance with policies on

research ethics. Authors adhere to publication requirements that

submitted work is original and has not been published elsewhere

in any language.

[17] Seccombe, I. J. (1995). Measuring and monitoring absence from

work: Institute for Employment Studies.

[

18] Johnson-Tate, D. R. Effective Strategies Used by Restaurant

Managers to Reduce Employee Absenteeism. 2018.

[

19] Kocakulah, Mehmet & Kelley, Ann & Mitchell, Krystal & Ruggieri,

Margaret. Absenteeism Problems And Costs: Causes, Effects And

Competing interests

The authors declare that there is no conflict of interest that

would prejudice the impartiality of this scientific work.

Cures. International Business

& Economics Research Journal

(IBER). 2016, 15(3), 89-96. Available online, DOI: 15. 89.

10.19030/iber.v15i3.9673.

[

20] Folger, J. The Causes and Costs of Absenteeism. Available online

018. Cite on 10 November 2019. Retrieved from

Authors’ contribution

All authors of this study have a complete contribution for data

collection, data analyses and manuscript writing

https://www.investopedia.com/articles/personal-

finance/070513/causes-and-costs-absenteeism.asp.

[21] Frick, B. J., Goetzen, U., & Simmons, R. The hidden costs of high-

performance work practices: Evidence from a large German steel

company. ILR Review; 2013,66(1), 198-224.

References

[22] Rost, K. M., Meng, H., & Xu, S. Work productivity loss from

depression: evidence from an employer survey. BMC health services

research; 2014, 14(1), 597.

[23] Krol, M., Brouwer, W., & Rutten, F. Productivity costs in economic

evaluations: past, present, future. Pharmacoeconomics; 2013, 31(7),

537-549.

[24] Mehmood, N. K. D. O. K. Effects of Absenteeism on Students

Performance. International Journal of Scientific and Research

Publications; 2014, 7(9), 151-168.

[25] Sutphin, P. D., Reis, S. P., McKune, A., Ravanzo, M., Kalva, S. P.,

& Pillai, A. K. Improving inferior vena cava filter retrieval rates with

the define, measure, analyze, improve, control methodology. Journal

of Vascular and Interventional Radiology; 2015, 26(4), 491-498.

e491.

[26] Nicolaides, V. C. Predicting Daily Attendance Behaviors: A Theory

of Planned Behavior Approach. (2016).

[27] Burawat, P.Productivity improvement of carton manufacturing

industry by implementation of lean six sigma, ECRS, work study, and

5S: A case study of ABC co., ltd. Journal of Environmental Treatment

Techniques, 2019, 7 (4), 785-793.

[

1] Sustainability Goal Development, United Nation Development

Program (2019). Goal 8: Decent work and economic growth. (Cited

on 11 November 2019).

2] Olagunju, M., Adeniyi, E.,

& Oladele, T. Staff Attendance

Monitoring System using Fingerprint Biometrics. International

Journal of Computer Applications; 2018, 179(21), 8-15.

3] Miao, Q., Xiao, F., Huang, H., Sun, L., Wang, R. Smart attendance

system based on frequency distribution algorithm with passive RFID

tags, Tsinghua Science and Technology; 2020, 25 (2), pp. 217-226.

4] Crawford, B., Hashim, S. S. M., Prepageran, N., See, G. B., Meier,

G., Wada, K., DeRosa, M et al. Impact of Pediatric Acute Otitis

Media on Child and Parental Quality of Life and Associated

Productivity Loss in Malaysia: A Prospective Observational Study.

Drugs-real world outcomes; 2017, 4(1), 21-31.

5] Kamal, M. F., Waseem, M. A., & Mujtaba, B. G. Comparative

analysis of the effect of attendance on academic performance of

management and finance course students. World Applied Sciences

Journal; 2013, 24(12), 1651-1655.

6] Ananya Chandraker, D. G. V. Analytics and prediction over student’s

record. International Journal of Advances in Science Engineering and

Technology; 2014, 2(2), 80-83.

7] Diawati, P., Paramarta, V., Pitoyo, D., Fitrio, T., Mahrani, S.W.

Challenges of implementing an employee management system for

improving workplace management effectiveness. Journal of

Environmental Treatment Techniques, 2019, 7 (Special Issue), 1200-

[

[28] Telecommunication. (2016b). Terma

& Syarat Perkhidmatan

Pegawai Eksekutif Tahap Pengurusan dan Ke Bawah (Band 1-3).

Telecommunication Malaysia Berhad: terms and Condition.

[29] Telecommunication. (2016a). 2016 NOC Key Performance Index

Key (KPI) Staff Handbook. In. XXX Sdn Bhd: Network Operation

Centre.

203.

[

8] Srija, B. A study on employee absenteeism with special reference to

UNI Drivelines (P) Ltd., Coimbatore. EXCEL International Journal

of Multidisciplinary Management Studies; 2014, 4(1), 197-208.