Scribd
Upload
82 views11 pages

Monthly Budgeted Chargeable Rates

The document shows budgeted chargeable rates and leave information for 6 employees over a 12 month period. It includes the employees' names and grades. For each month it lists the budgeted chargeable rate as a percentage and details overtime hours, annual leave, public holidays, training time, and other leaves like study leave and exam leave for each employee. It also calculates total and ending leave balances.

Uploaded by

Kevin James Sedurifa Oledan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
82 views11 pages

Monthly Budgeted Chargeable Rates

The document shows budgeted chargeable rates and leave information for 6 employees over a 12 month period. It includes the employees' names and grades. For each month it lists the budgeted chargeable rate as a percentage and details overtime hours, annual leave, public holidays, training time, and other leaves like study leave and exam leave for each employee. It also calculates total and ending leave balances.

Uploaded by

Kevin James Sedurifa Oledan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

No

7
8
9
10
11
12

Name
Grade
Alejandro PalEM-N
Ms Dang Do AM- N
Ms Le Thi Ki AM- N
Ms Bui Minh S2-Y
Ms Tran Van S1-Y
Mr Le HoangA2-Y

Budgeted chargeable rate %


Jan
Feb
45%
45%
60%
60%
60%
60%
70.0%
70.0%
0.0%
0.0%
70.0%
70.0%

Mar
45%
60%
60%
70.0%
0.0%
70.0%

Apr
45%
60%
60%
70.0%
70.0%
70.0%

May
45%
60%
60%
70.0%
70.0%
70.0%

Jun
45%
60%
60%
70.0%
70.0%
70.0%

Jul
45%
60%
60%
70.0%
70.0%
70.0%

Aug
45%
60%
60%
70.0%
70.0%
70.0%

Sep
45%
60%
60%
70.0%
70.0%
70.0%

Oct
45%
60%
60%
70.0%
70.0%
70.0%

Nov
45%
60%
60%
70.0%
70.0%
70.0%

Dec Ave.
45%
45%
60%
60%
60%
60%
70.0%
70.0%
70.0%
52.5%
70.0%
70.0%

Overtime hours per month


Jan
Feb

10
10
10

10
10
10

Mar

Apr

May

Jun

Jul

Aug

10
10
10

10
10
10

10
10
10

10
10
10

10
10
10

10
10
10

Annual leave
Sep

10
10
10

Oct

10
10
10

Nov

10
10
10

Dec Total

10
10
10

0
0
0
120
120
120

Jan
8

Feb
8
8
8
16
16
16

Mar
8

Apr
8
8
8
16
16
16

May
8
8
8
8
8
8

Jun
8
8
8
24
24
24

Jul
8
8
8
8
8
8

Aug
8
8
8
16
16
16

Sep
8
8
8
16
16
16

Oct
8
8
8
16
16
16

Nov
16
8
8
16
16
16

Dec Bal
48
32
32
8
8
8

Public holidays
Jan
16
8
40
8
40
8
156
8
156
8
132
8

Feb
32
32
32
32
32
32

Mar

Apr
16
16
16
16
16
16

May
8
8
8
8
8
8

Jun

Training time
Jul

Aug

Sep
8
8
8
8
8
8

Oct

Nov

Dec Total

Jan
72
72
72
72
72
72

raining time
Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Study leave, exam leave (Co.'s policy) and other leave (uti
Oct

Nov

Dec Total

Jan
-

Feb

Mar
32

Apr
32

licy) and other leave (utilization of overtime)


May
32

Jun
40
40
40
40
40

Jul

Aug

Sep

Oct

Nov
32

Dec
0
0
40
40
40

Total
128.00
40.00
40.00
80.00
80.00
80.00

Ending Bal
(112.00)
76.00
76.00
52.00

You might also like