Fop Ay Roll Budget
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Fop Ay Roll Budget as PDF for free.
More details
- Words: 2,416
- Pages: 8
NEW HOTEL & RESORT ROOMS DIVISION OVER HEAD Manning & Payroll Budget Proposal Year 2008 29
31
30
31
30
18600
17400
18600
18000
18600
18000
PAID ROOMS
20%
100%
50%
50%
50%
50%
ROOM OCCUPIED
3720
17400
9300
9000
9300
9000
5
3300 16,500.00
TOTAL
Jan-08
Jun-08
3 MONTH OVER HEAD
May-08
Apr-08
Mar-08
Feb-08
Jan-08
Adjustment
Increment
Ttl Payroll
Average Head
No Staff
Department Head
6 MONTH OVER HEAD BUDGET
Mar-08
ROOMS
31
Feb-08
DAY
TOTAL
825.00 17,325.00
16,500.00
16,500.00
16,500.00
16,500.00
16,500.00
16,500.00
99,000.00
13,200.00
13,200.00
13,200.00
$39,600.00
Manager
10
2800 28,000.00 1,400.00 29,400.00
28,000.00
28,000.00
28,000.00
28,000.00
28,000.00
28,000.00
168,000.00
22,400.00
22,400.00
22,400.00
$67,200.00
Executive
12
2200 26,400.00 1,320.00 27,720.00
26,400.00
26,400.00
26,400.00
26,400.00
26,400.00
26,400.00
158,400.00
26,400.00
26,400.00
26,400.00
$79,200.00
Supervisor
19
930.00 19,530.00
18,600.00
18,600.00
18,600.00
18,600.00
18,600.00
18,600.00
111,600.00
12,000.00
12,000.00
12,000.00
$36,000.00
Associate
62
623 38,650.00 1,932.50 40,582.50
38,650.00
38,650.00
38,650.00
38,650.00
38,650.00
38,650.00
231,900.00
52,150.00
27,400.00
27,400.00
$106,950.00
978.95 18,600.00
$$$$$$Bellman
$328,950.00 108
Total Rooms Department Basic
$
9902.33
128150
6407.5
134557.5
128150
128150
128150
128150
128150
128150
768,900.00
126150
101400
101400
0
$328,950.00
%
$768,900.00
61.79
128,150.00
128,150.00
128,150.00
128,150.00
128,150.00
128,150.00
768,900.00
128,150.00
128,150.00
128,150.00
128,150.00
$512,600.00
Overtime 5%
38,445.00
3.09
6,407.50
6,407.50
6,407.50
6,407.50
6,407.50
6,407.50
38,445.00
6,407.50
6,407.50
6,407.50
6,407.50
$25,630.00
EPF 11%
84,579.00
6.80
14,096.50
14,096.50
14,096.50
14,096.50
14,096.50
14,096.50
84,579.00
14,096.50
14,096.50
14,096.50
14,096.50
$56,386.00
SOCSO 2%
15,378.00
1.24
2,563.00
2,563.00
2,563.00
2,563.00
2,563.00
2,563.00
15,378.00
2,563.00
2,563.00
2,563.00
2,563.00
$10,252.00
HRDF 1%
7,689.00
0.62
1,281.50
1,281.50
1,281.50
1,281.50
1,281.50
1,281.50
7,689.00
1,281.50
1,281.50
1,281.50
1,281.50
$5,126.00
Allowance $3.00/P
1,642.50
0.13
273.75
273.75
273.75
273.75
273.75
273.75
1,642.50
273.75
273.75
273.75
273.75
$1,095.00
118,260.00
9.50
19,710.00
19,710.00
19,710.00
19,710.00
19,710.00
19,710.00
118,260.00
19,710.00
19,710.00
19,710.00
19,710.00
$78,840.00
Training
3,000.00
0.24
500.00
500.00
500.00
500.00
500.00
500.00
3,000.00
500.00
500.00
500.00
500.00
$2,000.00
Medical
19,440.00
1.56
3,240.00
3,240.00
3,240.00
3,240.00
3,240.00
3,240.00
19,440.00
3,240.00
3,240.00
3,240.00
3,240.00
$12,960.00
Meals
Insurance Uniform Bonus 2% Payroll & Benefit
882.00
0.07
147.00
147.00
147.00
147.00
147.00
147.00
882.00
147.00
147.00
147.00
147.00
$588.00
32,400.00
2.60
5,400.00
5,400.00
5,400.00
5,400.00
5,400.00
5,400.00
32,400.00
5,400.00
5,400.00
5,400.00
5,400.00
$21,600.00
153,780.00
12.36
25,630.00
25,630.00
25,630.00
25,630.00
25,630.00
25,630.00
153,780.00
25,630.00
25,630.00
25,630.00
25,630.00
$102,520.00
$1,244,395.50
100.00
$207,399.25
$207,399.25
$207,399.25
$207,399.25
$207,399.25
$1,244,395.50
$207,399.25
$207,399.25
$207,399.25
$207,399.25
$829,597.00
$207,399.25###
NEW HOTEL & RESORT Front Office Department Manning & Payroll Budget Proposal Year 2008 DAY ROOMS
31
29
31
30
31
30
18600
17400
18600
18000
18600
18000
PAID ROOMS
20%
100%
50%
50%
50%
50%
ROOM OCCUPIED
3720
17400
9300
9000
9300
9000
Increment
Ttl Payroll
Basic Sal
Mar-08
Apr-08
May-08
Jun-08
Jan-08
Feb-08
Mar-08
Front Office Manager
1 3,300.00
3,300.00
165.00
3,465.00
3,300.00
3,300.00
3,300.00
3,300.00
3,300.00
3,300.00
19,800.00
3,300.00
3,300.00
3,300.00
9,900.00
Asst Front Office Manager
2 2,800.00
5,600.00
280.00
5,880.00
5,600.00
5,600.00
5,600.00
5,600.00
5,600.00
5,600.00
33,600.00
5,600.00
5,600.00
5,600.00
16,800.00
Front Office Executive
3 2,200.00
6,600.00
330.00
6,930.00
6,600.00
6,600.00
6,600.00
6,600.00
6,600.00
6,600.00
39,600.00
6,600.00
6,600.00
6,600.00
19,800.00
GSA Supervisor
4
750.00
3,000.00
150.00
3,150.00
3,000.00
3,000.00
3,000.00
3,000.00
3,000.00
3,000.00
18,000.00
3,000.00
3,000.00
3,000.00
9,000.00
15
550.00
8,250.00
412.50
8,662.50
8,250.00
8,250.00
8,250.00
8,250.00
8,250.00
8,250.00
49,500.00
8,250.00
8,250.00
8,250.00
24,750.00
25 9,600.00 26,750.00 1,337.50 28,087.50
26,750.00
26,750.00
26,750.00
26,750.00
26,750.00
26,750.00
160,500.00
26,750.00
26,750.00
26,750.00
160,500.00
26,750.00
26,750.00
26,750.00
26,750.00
26,750.00
26,750.00
160,500.00
26,750.00
26,750.00
26,750.00
80,250.00
8,025.00
1,337.50
1,337.50
1,337.50
1,337.50
1,337.50
1,337.50
8,025.00
1,337.50
1,337.50
1,337.50
4,012.50
17,655.00
2,942.50
2,942.50
2,942.50
2,942.50
2,942.50
2,942.50
17,655.00
2,942.50
2,942.50
2,942.50
8,827.50
SOCSO 2%
3,210.00
535.00
535.00
535.00
535.00
535.00
535.00
3,210.00
535.00
535.00
535.00
1,605.00
HRDF 1%
1,605.00
267.50
267.50
267.50
267.50
267.50
267.50
1,605.00
267.50
267.50
267.50
802.50
Allowance $3.00/P
41,062.50
6,843.75
6,843.75
6,843.75
6,843.75
6,843.75
6,843.75
41,062.50
6,843.75
6,843.75
6,843.75
20,531.25
Meals
GSA
TOTAL
Apr-05
Feb-08
3 MONTH OVER HEAD
Jan-08
No Staff
Adjustment
6 MONTH OVER HEAD BUDGET
TOTAL
80,250.00 0.00
80,250.00
Total Rooms Department Basic Overtime 5% EPF 11%
27,375.00
4,562.50
4,562.50
4,562.50
4,562.50
4,562.50
4,562.50
27,375.00
4,562.50
4,562.50
4,562.50
13,687.50
Training
3,000.00
500.00
500.00
500.00
500.00
500.00
500.00
3,000.00
500.00
500.00
500.00
1,500.00
Medical
4,500.00
750.00
750.00
750.00
750.00
750.00
750.00
4,500.00
750.00
750.00
750.00
2,250.00
450.00
75.00
75.00
75.00
75.00
75.00
75.00
450.00
75.00
75.00
75.00
225.00
7,500.00
1,250.00
1,250.00
1,250.00
1,250.00
1,250.00
1,250.00
7,500.00
1,250.00
1,250.00
1,250.00
3,750.00
32,100.00
5,350.00
5,350.00
5,350.00
5,350.00
5,350.00
5,350.00
32,100.00
5,350.00
5,350.00
5,350.00
16,050.00
$306,982.50
$51,163.75
$51,163.75
$51,163.75
$51,163.75
$51,163.75
$306,982.50
$51,163.75
$51,163.75
$51,163.75
Insurance Uniform Bonus 2% Payroll & Benefit
$51,163.75 ###
$-
$153,491.25
NEW HOTEL & RESORT RESERVATION DEPARTMENT Manning & Payroll Budget Proposal Year 2008 DAY ROOMS
31
29
31
30
31
30
18600
17400
18600
18000
18600
18000
PAID ROOMS
20%
100%
50%
50%
50%
50%
ROOM OCCUPIED
3720
17400
9300
9000
9300
9000
Increment
Ttl Payroll
Basic Sal
Feb-08
Mar-08
Apr-08
May-08
Jun-08
Jan-08
Feb-08
Mar-08
3 MONTH OVER HEAD
Jan-08
No Staff
Adjustment
6 MONTH OVER HEAD BUDGET
Reservation Manager
1 3,300.00
3,300.00
165.00
3,465.00
3,300.00
3,300.00
3,300.00
3,300.00
3,300.00
3,300.00
19,800.00
3,300.00
3,300.00
3,300.00
$9,900.00
Asst Reservation Manager
2 2,800.00
5,600.00
280.00
5,880.00
5,600.00
5,600.00
5,600.00
5,600.00
5,600.00
5,600.00
33,600.00
5,600.00
5,600.00
5,600.00
$16,800.00
Reservation Executive
3 2,200.00
6,600.00
330.00
6,930.00
6,600.00
6,600.00
6,600.00
6,600.00
6,600.00
6,600.00
39,600.00
6,600.00
6,600.00
6,600.00
$19,800.00
Reservation Supervisor
4
750.00
3,000.00
150.00
3,150.00
3,000.00
3,000.00
3,000.00
3,000.00
3,000.00
3,000.00
18,000.00
3,000.00
3,000.00
3,000.00
$9,000.00
Reservation
9
550.00
4,950.00
247.50
5,197.50
4,950.00
4,950.00
4,950.00
4,950.00
4,950.00
4,950.00
29,700.00
4,950.00
4,950.00
4,950.00
$14,850.00
19 9,600.00 23,450.00 1,172.50 24,622.50
23,450.00
23,450.00
23,450.00
23,450.00
23,450.00
23,450.00
140,700.00
23,450.00
23,450.00
23,450.00
140,700.00
23,450.00
23,450.00
23,450.00
23,450.00
23,450.00
23,450.00
140,700.00
23,450.00
23,450.00
23,450.00
$70,350.00
7,035.00
1,172.50
1,172.50
1,172.50
1,172.50
1,172.50
1,172.50
7,035.00
1,172.50
1,172.50
1,172.50
$3,517.50
15,477.00
2,579.50
2,579.50
2,579.50
2,579.50
2,579.50
2,579.50
15,477.00
2,579.50
2,579.50
2,579.50
$7,738.50
SOCSO 2%
2,814.00
469.00
469.00
469.00
469.00
469.00
469.00
2,814.00
469.00
469.00
469.00
$1,407.00
HRDF 1%
1,407.00
234.50
234.50
234.50
234.50
234.50
234.50
1,407.00
234.50
234.50
234.50
$703.50
Allowance $3.00/P
31,207.50
5,201.25
5,201.25
5,201.25
5,201.25
5,201.25
5,201.25
31,207.50
5,201.25
5,201.25
5,201.25
$15,603.75
Meals
TOTAL
TOTAL
$70,350.00 0.00
$70,350.00
Total Rooms Department Basic Overtime 5% EPF 11%
20,805.00
3,467.50
3,467.50
3,467.50
3,467.50
3,467.50
3,467.50
20,805.00
3,467.50
3,467.50
3,467.50
$10,402.50
Training
3,000.00
500.00
500.00
500.00
500.00
500.00
500.00
3,000.00
500.00
500.00
500.00
$1,500.00
Medical
3,420.00
570.00
570.00
570.00
570.00
570.00
570.00
3,420.00
570.00
570.00
570.00
$1,710.00
882.00
147.00
147.00
147.00
147.00
147.00
147.00
882.00
147.00
147.00
147.00
$441.00
5,700.00
950.00
950.00
950.00
950.00
950.00
950.00
5,700.00
950.00
950.00
950.00
$2,850.00
28,140.00
4,690.00
4,690.00
4,690.00
4,690.00
4,690.00
4,690.00
28,140.00
4,690.00
4,690.00
4,690.00
$14,070.00
$260,587.50
$43,431.25
$43,431.25
$43,431.25
$43,431.25
$43,431.25
$260,587.50
$43,431.25
$43,431.25
$43,431.25
Insurance Uniform Bonus 2% Payroll & Benefit
$43,431.25 ###
$-
$130,293.75
NEW HOTEL & RESORT CONCIERGE DEPARTMENT Manning & Payroll Budget Proposal Year 2008 DAY ROOMS
31
29
31
30
31
30
18600
17400
18600
18000
18600
18000
PAID ROOMS
20%
100%
50%
50%
50%
50%
ROOM OCCUPIED
3720
17400
9300
9000
9300
9000
Increment
Ttl Payroll
Basic Sal
Feb-08
Mar-08
Apr-08
May-08
Jun-08
Jan-08
Feb-08
Mar-08
3 MONTH OVER HEAD
Jan-08
No Staff
Adjustment
6 MONTH OVER HEAD BUDGET
Concierge Manager
1 3,300.00 3,300.00 165.00 3,465.00
3,300.00
3,300.00
3,300.00
3,300.00
3,300.00
3,300.00
19,800.00
3,300.00
3,300.00
3,300.00
$9,900.00
Asst Concierge Manager
2 2,800.00 5,600.00 280.00 5,880.00
5,600.00
5,600.00
5,600.00
5,600.00
5,600.00
5,600.00
33,600.00
5,600.00
5,600.00
5,600.00
$16,800.00
Concierge Executive
3 2,200.00 6,600.00 330.00 6,930.00
6,600.00
6,600.00
6,600.00
6,600.00
6,600.00
6,600.00
39,600.00
6,600.00
6,600.00
6,600.00
$19,800.00
Concierge Supervisor
4
750.00 3,000.00 150.00 3,150.00
3,000.00
3,000.00
3,000.00
3,000.00
3,000.00
3,000.00
18,000.00
3,000.00
3,000.00
3,000.00
$9,000.00
Concierge
9
550.00 4,950.00 247.50 5,197.50
4,950.00
4,950.00
4,950.00
4,950.00
4,950.00
4,950.00
29,700.00
4,950.00
4,950.00
4,950.00
$14,850.00
Car Jockey
3 1,800.00 5,400.00 270.00 5,670.00
5,400.00
5,400.00
5,400.00
5,400.00
5,400.00
5,400.00
32,400.00
5,400.00
5,400.00
5,400.00
$16,200.00
Bellman
7
3,850.00
3,850.00
3,850.00
3,850.00
3,850.00
3,850.00
23,100.00
3,850.00
3,850.00
3,850.00
32700
32700
32700
32700
32700
32700
196200
32,700.00
32,700.00
32,700.00
$98,100.00
$196,200.00
32,700.00
32,700.00
32,700.00
32,700.00
32,700.00
32,700.00
196,200.00
32,700.00
32,700.00
32,700.00
$98,100.00
9,810.00
1,635.00
1,635.00
1,635.00
1,635.00
1,635.00
1,635.00
9,810.00
1,635.00
1,635.00
1,635.00
$4,905.00
21,582.00
3,597.00
3,597.00
3,597.00
3,597.00
3,597.00
3,597.00
21,582.00
3,597.00
3,597.00
3,597.00
$10,791.00
SOCSO 2%
3,924.00
654.00
654.00
654.00
654.00
654.00
654.00
3,924.00
654.00
654.00
654.00
$1,962.00
HRDF 1%
1,962.00
327.00
327.00
327.00
327.00
327.00
327.00
1,962.00
327.00
327.00
327.00
$981.00
Allowance $3.00/P
47,632.50
7,938.75
7,938.75
7,938.75
7,938.75
7,938.75
7,938.75
47,632.50
7,938.75
7,938.75
7,938.75
$23,816.25
Meals
550.00 3,850.00 192.50 4,042.50
TOTAL
TOTAL
$86,550.00 29
11950
32700
1635
34335
Total Rooms Department Basic Overtime 5% EPF 11%
31,755.00
5,292.50
5,292.50
5,292.50
5,292.50
5,292.50
5,292.50
31,755.00
5,292.50
5,292.50
5,292.50
$15,877.50
Training
3,000.00
500.00
500.00
500.00
500.00
500.00
500.00
3,000.00
500.00
500.00
500.00
$1,500.00
Medical
5,220.00
870.00
870.00
870.00
870.00
870.00
870.00
5,220.00
870.00
870.00
870.00
$2,610.00
522.00
87.00
87.00
87.00
87.00
87.00
87.00
522.00
87.00
87.00
87.00
$261.00
8,700.00
1,450.00
1,450.00
1,450.00
1,450.00
1,450.00
1,450.00
8,700.00
1,450.00
1,450.00
1,450.00
$4,350.00
39,240.00
6,540.00
6,540.00
6,540.00
6,540.00
6,540.00
6,540.00
39,240.00
6,540.00
6,540.00
6,540.00
$19,620.00
$369,547.50
$61,591.25
$61,591.25
$61,591.25
$61,591.25
$61,591.25
$369,547.50
$61,591.25
$61,591.25
$61,591.25
Insurance Uniform Bonus 2% Payroll & Benefit
$61,591.25 ###
$-
$184,773.75
NEW HOTEL & RESORT PABX DEPARTMENT Manning & Payroll Budget Proposal Year 2008 DAY ROOMS
31
29
31
30
31
30
18600
17400
18600
18000
18600
18000
PAID ROOMS
20%
100%
50%
50%
50%
50%
ROOM OCCUPIED
3720
17400
9300
9000
9300
9000
Mar-08
Apr-08
May-08
Jun-08
PABX Manager
1 3,300.00 3,300.00 165.00 3,465.00
3,300.00
3,300.00
3,300.00
3,300.00
3,300.00
3,300.00
19,800.00
3300
3300
3300
$9,900.00
Asst PABX Manager
2 2,800.00 5,600.00 280.00 5,880.00
5,600.00
5,600.00
5,600.00
5,600.00
5,600.00
5,600.00
33,600.00
5600
5600
5600
$16,800.00
PABX Executive
3 2,200.00 6,600.00 330.00 6,930.00
6,600.00
6,600.00
6,600.00
6,600.00
6,600.00
6,600.00
39,600.00
6600
6600
6600
$19,800.00
PABX Supervisor
4
750.00 3,000.00 150.00 3,150.00
3,000.00
3,000.00
3,000.00
3,000.00
3,000.00
3,000.00
18,000.00
3000
3000
3000
$9,000.00
15
550.00 8,250.00 412.50 8,662.50
8,250.00
8,250.00
8,250.00
8,250.00
8,250.00
8,250.00
49,500.00
8250
8250
8250
$24,750.00
26750
26750
26750
26750
26750
26750
160500
26750
26750
26750
$160,500.00
26,750.00
26,750.00
26,750.00
26,750.00
26,750.00
26,750.00
160,500.00
26,750.00
26,750.00
26,750.00
$80,250.00
8,025.00
1,337.50
1,337.50
1,337.50
1,337.50
1,337.50
1,337.50
8,025.00
1,337.50
1,337.50
1,337.50
$4,012.50
17,655.00
2,942.50
2,942.50
2,942.50
2,942.50
2,942.50
2,942.50
17,655.00
2,942.50
2,942.50
2,942.50
$8,827.50
SOCSO 2%
3,210.00
535.00
535.00
535.00
535.00
535.00
535.00
3,210.00
535.00
535.00
535.00
$1,605.00
HRDF 1%
1,605.00
267.50
267.50
267.50
267.50
267.50
267.50
1,605.00
267.50
267.50
267.50
$802.50
Allowance $3.00/P
41,062.50
6,843.75
6,843.75
6,843.75
6,843.75
6,843.75
6,843.75
41,062.50
6,843.75
6,843.75
6,843.75
$20,531.25
Meals
Operator
Apr-05
Feb-08
Jan-08
TOTAL
Mar-08
Feb-08
3 MONTH OVER HEAD
Jan-08
Adjustment
Increment
No Staff
Basic Sal
Ttl Payroll
6 MONTH OVER HEAD BUDGET
TOTAL
$80,250.00 25
9600
26750 1337.5
28087.5
0
$80,250.00
Total Rooms Department Basic Overtime 5% EPF 11%
27,375.00
4,562.50
4,562.50
4,562.50
4,562.50
4,562.50
4,562.50
27,375.00
4,562.50
4,562.50
4,562.50
$13,687.50
Training
3,000.00
500.00
500.00
500.00
500.00
500.00
500.00
3,000.00
500.00
500.00
500.00
$1,500.00
Medical
4,500.00
750.00
750.00
750.00
750.00
750.00
750.00
4,500.00
750.00
750.00
750.00
$2,250.00
450.00
75.00
75.00
75.00
75.00
75.00
75.00
450.00
75.00
75.00
75.00
$225.00
7,500.00
1,250.00
1,250.00
1,250.00
1,250.00
1,250.00
1,250.00
7,500.00
1,250.00
1,250.00
1,250.00
$3,750.00
32,100.00
5,350.00
5,350.00
5,350.00
5,350.00
5,350.00
5,350.00
32,100.00
5,350.00
5,350.00
5,350.00
$16,050.00
$306,982.50
$51,163.75
$51,163.75
$51,163.75
$51,163.75
$51,163.75
$306,982.50
$51,163.75
$51,163.75
$51,163.75
$153,491.25
Insurance Uniform Bonus 2% Payroll & Benefit
$51,163.75 ###
NEW HOTEL & RESORT Business center Manning & Payroll Budget Proposal Year 2008 DAY ROOMS
31
29
31
30
31
30
18600
17400
18600
18000
18600
18000
PAID ROOMS
20%
100%
50%
50%
50%
50%
ROOM OCCUPIED
3720
17400
9300
9000
9300
9000
Feb-08
Mar-08
Apr-08
May-08
Jun-08
Jan-08
Feb-08
Mar-08
3 MONTH OVER HEAD
Jan-08
Adjustment
Increment
No Staff
Basic Sal
Ttl Payroll
6 MONTH OVER HEAD BUDGET
Business Center Manager
1 3,300.00
3,300.00 165.00
3,465.00
3,300.00
3,300.00
3,300.00
3,300.00
3,300.00
3,300.00
19,800.00
3,300.00
3,300.00
3,300.00
$9,900.00
Asst Business Center Manager
2 2,800.00
5,600.00 280.00
5,880.00
5,600.00
5,600.00
5,600.00
5,600.00
5,600.00
5,600.00
33,600.00
5,600.00
5,600.00
5,600.00
$16,800.00
Business Center Supervisor
3 2,200.00
6,600.00 330.00
6,930.00
6,600.00
6,600.00
6,600.00
6,600.00
6,600.00
6,600.00
39,600.00
6,600.00
6,600.00
6,600.00
$19,800.00
Business Center Clerk
4
3,000.00 150.00
3,150.00
3,000.00
3,000.00
3,000.00
3,000.00
3,000.00
3,000.00
18,000.00
3,000.00
3,000.00
3,000.00
$9,000.00
10 9,050.00 18,500.00 925.00 19,425.00
18,500.00
18,500.00
18,500.00
18,500.00
18,500.00
18,500.00
111,000.00
18,500.00
18,500.00
18,500.00
$111,000.00
18,500.00
18,500.00
18,500.00
18,500.00
18,500.00
18,500.00
111,000.00
18,500.00
18,500.00
18,500.00
$55,500.00
5,550.00
925.00
925.00
925.00
925.00
925.00
925.00
5,550.00
925.00
925.00
925.00
$2,775.00
12,210.00
2,035.00
2,035.00
2,035.00
2,035.00
2,035.00
2,035.00
12,210.00
2,035.00
2,035.00
2,035.00
$6,105.00
SOCSO 2%
2,220.00
370.00
370.00
370.00
370.00
370.00
370.00
2,220.00
370.00
370.00
370.00
$1,110.00
HRDF 1%
1,110.00
185.00
185.00
185.00
185.00
185.00
185.00
1,110.00
185.00
185.00
185.00
$555.00
Allowance $3.00/P
16,425.00
2,737.50
2,737.50
2,737.50
2,737.50
2,737.50
2,737.50
16,425.00
2,737.50
2,737.50
2,737.50
$8,212.50
Meals
750.00
TOTAL
TOTAL
$55,500.00 0.00
$55,500.00
Total Rooms Department Basic Overtime 5% EPF 11%
10,950.00
1,825.00
1,825.00
1,825.00
1,825.00
1,825.00
1,825.00
10,950.00
1,825.00
1,825.00
1,825.00
$5,475.00
Training
3,000.00
500.00
500.00
500.00
500.00
500.00
500.00
3,000.00
500.00
500.00
500.00
$1,500.00
Medical
1,800.00
300.00
300.00
300.00
300.00
300.00
300.00
1,800.00
300.00
300.00
300.00
$900.00
180.00
30.00
30.00
30.00
30.00
30.00
30.00
180.00
30.00
30.00
30.00
$90.00
3,000.00
500.00
500.00
500.00
500.00
500.00
500.00
3,000.00
500.00
500.00
500.00
$1,500.00
22,200.00
3,700.00
3,700.00
3,700.00
3,700.00
3,700.00
3,700.00
22,200.00
3,700.00
3,700.00
3,700.00
$11,100.00
$189,645.00
$31,607.50
$31,607.50
$31,607.50
$31,607.50
$31,607.50
$189,645.00
$31,607.50
$31,607.50
$31,607.50
$94,822.50
Insurance Uniform Bonus 2% Payroll & Benefit
$31,607.50 ###
ROOMS DIVISION CAPEX 2008 Capital Expenditure
No.
Item
Unit
Propose Qty
Oper Required
Cost
Total
Purpose
1 Walkie Talkie Codless (Head Gear)
26
26
26
2,200.00
57,200.00 Communication
2 Desk Top Computer
21
21
21
2,500.00
52,500.00 Administration Back of The House
7
7
7
2,500.00
17,500.00 Operational
4 Administration Desk
38
32
32
800.00
25,600.00 Administration Back of The House
5 Filing Rack
26
20
20
500.00
10,000.00 Guest facilities
6 Wheel Chair
30
30
30
1,500.00
1
1
1
250,000.00
76
76
76
250.00
1
1
1
50,000.00
10 Magnetic Door Card Master
3
3
3
2,000.00
6,000.00 Key Door
11 Information Stand Board
5
5
5
1,200.00
6,000.00 In House Activities Information
3 Concierge Trolly/Cart
7 PABX System 8 LCD Phone Receiver 9 Paging System
12 Concierge Desk 13 Safety Box 14 Information Center Desk
1
1
1
2,500.00
600
600
600
450.00
45,000.00 Guest facilities 250,000.00 Telecommunication 19,000.00 Direct Communication 50,000.00 Emergency
2,500.00 Admin Operation 270,000.00 Guest unit
1
1
1
1,200.00
15 Office Desk
12
12
12
1,200.00
14,400.00 Workstation
1,200.00 Manager on Duty
16 Laptop
15
15
15
3,500.00
52,500.00 mobalize Work Station
879,400.00
Operational Equipment
No.
Item
Present Qlty Propose Qlty
Cost
Total
Purpose
31
30
31
30
18600
17400
18600
18000
18600
18000
PAID ROOMS
20%
100%
50%
50%
50%
50%
ROOM OCCUPIED
3720
17400
9300
9000
9300
9000
5
3300 16,500.00
TOTAL
Jan-08
Jun-08
3 MONTH OVER HEAD
May-08
Apr-08
Mar-08
Feb-08
Jan-08
Adjustment
Increment
Ttl Payroll
Average Head
No Staff
Department Head
6 MONTH OVER HEAD BUDGET
Mar-08
ROOMS
31
Feb-08
DAY
TOTAL
825.00 17,325.00
16,500.00
16,500.00
16,500.00
16,500.00
16,500.00
16,500.00
99,000.00
13,200.00
13,200.00
13,200.00
$39,600.00
Manager
10
2800 28,000.00 1,400.00 29,400.00
28,000.00
28,000.00
28,000.00
28,000.00
28,000.00
28,000.00
168,000.00
22,400.00
22,400.00
22,400.00
$67,200.00
Executive
12
2200 26,400.00 1,320.00 27,720.00
26,400.00
26,400.00
26,400.00
26,400.00
26,400.00
26,400.00
158,400.00
26,400.00
26,400.00
26,400.00
$79,200.00
Supervisor
19
930.00 19,530.00
18,600.00
18,600.00
18,600.00
18,600.00
18,600.00
18,600.00
111,600.00
12,000.00
12,000.00
12,000.00
$36,000.00
Associate
62
623 38,650.00 1,932.50 40,582.50
38,650.00
38,650.00
38,650.00
38,650.00
38,650.00
38,650.00
231,900.00
52,150.00
27,400.00
27,400.00
$106,950.00
978.95 18,600.00
$$$$$$Bellman
$328,950.00 108
Total Rooms Department Basic
$
9902.33
128150
6407.5
134557.5
128150
128150
128150
128150
128150
128150
768,900.00
126150
101400
101400
0
$328,950.00
%
$768,900.00
61.79
128,150.00
128,150.00
128,150.00
128,150.00
128,150.00
128,150.00
768,900.00
128,150.00
128,150.00
128,150.00
128,150.00
$512,600.00
Overtime 5%
38,445.00
3.09
6,407.50
6,407.50
6,407.50
6,407.50
6,407.50
6,407.50
38,445.00
6,407.50
6,407.50
6,407.50
6,407.50
$25,630.00
EPF 11%
84,579.00
6.80
14,096.50
14,096.50
14,096.50
14,096.50
14,096.50
14,096.50
84,579.00
14,096.50
14,096.50
14,096.50
14,096.50
$56,386.00
SOCSO 2%
15,378.00
1.24
2,563.00
2,563.00
2,563.00
2,563.00
2,563.00
2,563.00
15,378.00
2,563.00
2,563.00
2,563.00
2,563.00
$10,252.00
HRDF 1%
7,689.00
0.62
1,281.50
1,281.50
1,281.50
1,281.50
1,281.50
1,281.50
7,689.00
1,281.50
1,281.50
1,281.50
1,281.50
$5,126.00
Allowance $3.00/P
1,642.50
0.13
273.75
273.75
273.75
273.75
273.75
273.75
1,642.50
273.75
273.75
273.75
273.75
$1,095.00
118,260.00
9.50
19,710.00
19,710.00
19,710.00
19,710.00
19,710.00
19,710.00
118,260.00
19,710.00
19,710.00
19,710.00
19,710.00
$78,840.00
Training
3,000.00
0.24
500.00
500.00
500.00
500.00
500.00
500.00
3,000.00
500.00
500.00
500.00
500.00
$2,000.00
Medical
19,440.00
1.56
3,240.00
3,240.00
3,240.00
3,240.00
3,240.00
3,240.00
19,440.00
3,240.00
3,240.00
3,240.00
3,240.00
$12,960.00
Meals
Insurance Uniform Bonus 2% Payroll & Benefit
882.00
0.07
147.00
147.00
147.00
147.00
147.00
147.00
882.00
147.00
147.00
147.00
147.00
$588.00
32,400.00
2.60
5,400.00
5,400.00
5,400.00
5,400.00
5,400.00
5,400.00
32,400.00
5,400.00
5,400.00
5,400.00
5,400.00
$21,600.00
153,780.00
12.36
25,630.00
25,630.00
25,630.00
25,630.00
25,630.00
25,630.00
153,780.00
25,630.00
25,630.00
25,630.00
25,630.00
$102,520.00
$1,244,395.50
100.00
$207,399.25
$207,399.25
$207,399.25
$207,399.25
$207,399.25
$1,244,395.50
$207,399.25
$207,399.25
$207,399.25
$207,399.25
$829,597.00
$207,399.25###
NEW HOTEL & RESORT Front Office Department Manning & Payroll Budget Proposal Year 2008 DAY ROOMS
31
29
31
30
31
30
18600
17400
18600
18000
18600
18000
PAID ROOMS
20%
100%
50%
50%
50%
50%
ROOM OCCUPIED
3720
17400
9300
9000
9300
9000
Increment
Ttl Payroll
Basic Sal
Mar-08
Apr-08
May-08
Jun-08
Jan-08
Feb-08
Mar-08
Front Office Manager
1 3,300.00
3,300.00
165.00
3,465.00
3,300.00
3,300.00
3,300.00
3,300.00
3,300.00
3,300.00
19,800.00
3,300.00
3,300.00
3,300.00
9,900.00
Asst Front Office Manager
2 2,800.00
5,600.00
280.00
5,880.00
5,600.00
5,600.00
5,600.00
5,600.00
5,600.00
5,600.00
33,600.00
5,600.00
5,600.00
5,600.00
16,800.00
Front Office Executive
3 2,200.00
6,600.00
330.00
6,930.00
6,600.00
6,600.00
6,600.00
6,600.00
6,600.00
6,600.00
39,600.00
6,600.00
6,600.00
6,600.00
19,800.00
GSA Supervisor
4
750.00
3,000.00
150.00
3,150.00
3,000.00
3,000.00
3,000.00
3,000.00
3,000.00
3,000.00
18,000.00
3,000.00
3,000.00
3,000.00
9,000.00
15
550.00
8,250.00
412.50
8,662.50
8,250.00
8,250.00
8,250.00
8,250.00
8,250.00
8,250.00
49,500.00
8,250.00
8,250.00
8,250.00
24,750.00
25 9,600.00 26,750.00 1,337.50 28,087.50
26,750.00
26,750.00
26,750.00
26,750.00
26,750.00
26,750.00
160,500.00
26,750.00
26,750.00
26,750.00
160,500.00
26,750.00
26,750.00
26,750.00
26,750.00
26,750.00
26,750.00
160,500.00
26,750.00
26,750.00
26,750.00
80,250.00
8,025.00
1,337.50
1,337.50
1,337.50
1,337.50
1,337.50
1,337.50
8,025.00
1,337.50
1,337.50
1,337.50
4,012.50
17,655.00
2,942.50
2,942.50
2,942.50
2,942.50
2,942.50
2,942.50
17,655.00
2,942.50
2,942.50
2,942.50
8,827.50
SOCSO 2%
3,210.00
535.00
535.00
535.00
535.00
535.00
535.00
3,210.00
535.00
535.00
535.00
1,605.00
HRDF 1%
1,605.00
267.50
267.50
267.50
267.50
267.50
267.50
1,605.00
267.50
267.50
267.50
802.50
Allowance $3.00/P
41,062.50
6,843.75
6,843.75
6,843.75
6,843.75
6,843.75
6,843.75
41,062.50
6,843.75
6,843.75
6,843.75
20,531.25
Meals
GSA
TOTAL
Apr-05
Feb-08
3 MONTH OVER HEAD
Jan-08
No Staff
Adjustment
6 MONTH OVER HEAD BUDGET
TOTAL
80,250.00 0.00
80,250.00
Total Rooms Department Basic Overtime 5% EPF 11%
27,375.00
4,562.50
4,562.50
4,562.50
4,562.50
4,562.50
4,562.50
27,375.00
4,562.50
4,562.50
4,562.50
13,687.50
Training
3,000.00
500.00
500.00
500.00
500.00
500.00
500.00
3,000.00
500.00
500.00
500.00
1,500.00
Medical
4,500.00
750.00
750.00
750.00
750.00
750.00
750.00
4,500.00
750.00
750.00
750.00
2,250.00
450.00
75.00
75.00
75.00
75.00
75.00
75.00
450.00
75.00
75.00
75.00
225.00
7,500.00
1,250.00
1,250.00
1,250.00
1,250.00
1,250.00
1,250.00
7,500.00
1,250.00
1,250.00
1,250.00
3,750.00
32,100.00
5,350.00
5,350.00
5,350.00
5,350.00
5,350.00
5,350.00
32,100.00
5,350.00
5,350.00
5,350.00
16,050.00
$306,982.50
$51,163.75
$51,163.75
$51,163.75
$51,163.75
$51,163.75
$306,982.50
$51,163.75
$51,163.75
$51,163.75
Insurance Uniform Bonus 2% Payroll & Benefit
$51,163.75 ###
$-
$153,491.25
NEW HOTEL & RESORT RESERVATION DEPARTMENT Manning & Payroll Budget Proposal Year 2008 DAY ROOMS
31
29
31
30
31
30
18600
17400
18600
18000
18600
18000
PAID ROOMS
20%
100%
50%
50%
50%
50%
ROOM OCCUPIED
3720
17400
9300
9000
9300
9000
Increment
Ttl Payroll
Basic Sal
Feb-08
Mar-08
Apr-08
May-08
Jun-08
Jan-08
Feb-08
Mar-08
3 MONTH OVER HEAD
Jan-08
No Staff
Adjustment
6 MONTH OVER HEAD BUDGET
Reservation Manager
1 3,300.00
3,300.00
165.00
3,465.00
3,300.00
3,300.00
3,300.00
3,300.00
3,300.00
3,300.00
19,800.00
3,300.00
3,300.00
3,300.00
$9,900.00
Asst Reservation Manager
2 2,800.00
5,600.00
280.00
5,880.00
5,600.00
5,600.00
5,600.00
5,600.00
5,600.00
5,600.00
33,600.00
5,600.00
5,600.00
5,600.00
$16,800.00
Reservation Executive
3 2,200.00
6,600.00
330.00
6,930.00
6,600.00
6,600.00
6,600.00
6,600.00
6,600.00
6,600.00
39,600.00
6,600.00
6,600.00
6,600.00
$19,800.00
Reservation Supervisor
4
750.00
3,000.00
150.00
3,150.00
3,000.00
3,000.00
3,000.00
3,000.00
3,000.00
3,000.00
18,000.00
3,000.00
3,000.00
3,000.00
$9,000.00
Reservation
9
550.00
4,950.00
247.50
5,197.50
4,950.00
4,950.00
4,950.00
4,950.00
4,950.00
4,950.00
29,700.00
4,950.00
4,950.00
4,950.00
$14,850.00
19 9,600.00 23,450.00 1,172.50 24,622.50
23,450.00
23,450.00
23,450.00
23,450.00
23,450.00
23,450.00
140,700.00
23,450.00
23,450.00
23,450.00
140,700.00
23,450.00
23,450.00
23,450.00
23,450.00
23,450.00
23,450.00
140,700.00
23,450.00
23,450.00
23,450.00
$70,350.00
7,035.00
1,172.50
1,172.50
1,172.50
1,172.50
1,172.50
1,172.50
7,035.00
1,172.50
1,172.50
1,172.50
$3,517.50
15,477.00
2,579.50
2,579.50
2,579.50
2,579.50
2,579.50
2,579.50
15,477.00
2,579.50
2,579.50
2,579.50
$7,738.50
SOCSO 2%
2,814.00
469.00
469.00
469.00
469.00
469.00
469.00
2,814.00
469.00
469.00
469.00
$1,407.00
HRDF 1%
1,407.00
234.50
234.50
234.50
234.50
234.50
234.50
1,407.00
234.50
234.50
234.50
$703.50
Allowance $3.00/P
31,207.50
5,201.25
5,201.25
5,201.25
5,201.25
5,201.25
5,201.25
31,207.50
5,201.25
5,201.25
5,201.25
$15,603.75
Meals
TOTAL
TOTAL
$70,350.00 0.00
$70,350.00
Total Rooms Department Basic Overtime 5% EPF 11%
20,805.00
3,467.50
3,467.50
3,467.50
3,467.50
3,467.50
3,467.50
20,805.00
3,467.50
3,467.50
3,467.50
$10,402.50
Training
3,000.00
500.00
500.00
500.00
500.00
500.00
500.00
3,000.00
500.00
500.00
500.00
$1,500.00
Medical
3,420.00
570.00
570.00
570.00
570.00
570.00
570.00
3,420.00
570.00
570.00
570.00
$1,710.00
882.00
147.00
147.00
147.00
147.00
147.00
147.00
882.00
147.00
147.00
147.00
$441.00
5,700.00
950.00
950.00
950.00
950.00
950.00
950.00
5,700.00
950.00
950.00
950.00
$2,850.00
28,140.00
4,690.00
4,690.00
4,690.00
4,690.00
4,690.00
4,690.00
28,140.00
4,690.00
4,690.00
4,690.00
$14,070.00
$260,587.50
$43,431.25
$43,431.25
$43,431.25
$43,431.25
$43,431.25
$260,587.50
$43,431.25
$43,431.25
$43,431.25
Insurance Uniform Bonus 2% Payroll & Benefit
$43,431.25 ###
$-
$130,293.75
NEW HOTEL & RESORT CONCIERGE DEPARTMENT Manning & Payroll Budget Proposal Year 2008 DAY ROOMS
31
29
31
30
31
30
18600
17400
18600
18000
18600
18000
PAID ROOMS
20%
100%
50%
50%
50%
50%
ROOM OCCUPIED
3720
17400
9300
9000
9300
9000
Increment
Ttl Payroll
Basic Sal
Feb-08
Mar-08
Apr-08
May-08
Jun-08
Jan-08
Feb-08
Mar-08
3 MONTH OVER HEAD
Jan-08
No Staff
Adjustment
6 MONTH OVER HEAD BUDGET
Concierge Manager
1 3,300.00 3,300.00 165.00 3,465.00
3,300.00
3,300.00
3,300.00
3,300.00
3,300.00
3,300.00
19,800.00
3,300.00
3,300.00
3,300.00
$9,900.00
Asst Concierge Manager
2 2,800.00 5,600.00 280.00 5,880.00
5,600.00
5,600.00
5,600.00
5,600.00
5,600.00
5,600.00
33,600.00
5,600.00
5,600.00
5,600.00
$16,800.00
Concierge Executive
3 2,200.00 6,600.00 330.00 6,930.00
6,600.00
6,600.00
6,600.00
6,600.00
6,600.00
6,600.00
39,600.00
6,600.00
6,600.00
6,600.00
$19,800.00
Concierge Supervisor
4
750.00 3,000.00 150.00 3,150.00
3,000.00
3,000.00
3,000.00
3,000.00
3,000.00
3,000.00
18,000.00
3,000.00
3,000.00
3,000.00
$9,000.00
Concierge
9
550.00 4,950.00 247.50 5,197.50
4,950.00
4,950.00
4,950.00
4,950.00
4,950.00
4,950.00
29,700.00
4,950.00
4,950.00
4,950.00
$14,850.00
Car Jockey
3 1,800.00 5,400.00 270.00 5,670.00
5,400.00
5,400.00
5,400.00
5,400.00
5,400.00
5,400.00
32,400.00
5,400.00
5,400.00
5,400.00
$16,200.00
Bellman
7
3,850.00
3,850.00
3,850.00
3,850.00
3,850.00
3,850.00
23,100.00
3,850.00
3,850.00
3,850.00
32700
32700
32700
32700
32700
32700
196200
32,700.00
32,700.00
32,700.00
$98,100.00
$196,200.00
32,700.00
32,700.00
32,700.00
32,700.00
32,700.00
32,700.00
196,200.00
32,700.00
32,700.00
32,700.00
$98,100.00
9,810.00
1,635.00
1,635.00
1,635.00
1,635.00
1,635.00
1,635.00
9,810.00
1,635.00
1,635.00
1,635.00
$4,905.00
21,582.00
3,597.00
3,597.00
3,597.00
3,597.00
3,597.00
3,597.00
21,582.00
3,597.00
3,597.00
3,597.00
$10,791.00
SOCSO 2%
3,924.00
654.00
654.00
654.00
654.00
654.00
654.00
3,924.00
654.00
654.00
654.00
$1,962.00
HRDF 1%
1,962.00
327.00
327.00
327.00
327.00
327.00
327.00
1,962.00
327.00
327.00
327.00
$981.00
Allowance $3.00/P
47,632.50
7,938.75
7,938.75
7,938.75
7,938.75
7,938.75
7,938.75
47,632.50
7,938.75
7,938.75
7,938.75
$23,816.25
Meals
550.00 3,850.00 192.50 4,042.50
TOTAL
TOTAL
$86,550.00 29
11950
32700
1635
34335
Total Rooms Department Basic Overtime 5% EPF 11%
31,755.00
5,292.50
5,292.50
5,292.50
5,292.50
5,292.50
5,292.50
31,755.00
5,292.50
5,292.50
5,292.50
$15,877.50
Training
3,000.00
500.00
500.00
500.00
500.00
500.00
500.00
3,000.00
500.00
500.00
500.00
$1,500.00
Medical
5,220.00
870.00
870.00
870.00
870.00
870.00
870.00
5,220.00
870.00
870.00
870.00
$2,610.00
522.00
87.00
87.00
87.00
87.00
87.00
87.00
522.00
87.00
87.00
87.00
$261.00
8,700.00
1,450.00
1,450.00
1,450.00
1,450.00
1,450.00
1,450.00
8,700.00
1,450.00
1,450.00
1,450.00
$4,350.00
39,240.00
6,540.00
6,540.00
6,540.00
6,540.00
6,540.00
6,540.00
39,240.00
6,540.00
6,540.00
6,540.00
$19,620.00
$369,547.50
$61,591.25
$61,591.25
$61,591.25
$61,591.25
$61,591.25
$369,547.50
$61,591.25
$61,591.25
$61,591.25
Insurance Uniform Bonus 2% Payroll & Benefit
$61,591.25 ###
$-
$184,773.75
NEW HOTEL & RESORT PABX DEPARTMENT Manning & Payroll Budget Proposal Year 2008 DAY ROOMS
31
29
31
30
31
30
18600
17400
18600
18000
18600
18000
PAID ROOMS
20%
100%
50%
50%
50%
50%
ROOM OCCUPIED
3720
17400
9300
9000
9300
9000
Mar-08
Apr-08
May-08
Jun-08
PABX Manager
1 3,300.00 3,300.00 165.00 3,465.00
3,300.00
3,300.00
3,300.00
3,300.00
3,300.00
3,300.00
19,800.00
3300
3300
3300
$9,900.00
Asst PABX Manager
2 2,800.00 5,600.00 280.00 5,880.00
5,600.00
5,600.00
5,600.00
5,600.00
5,600.00
5,600.00
33,600.00
5600
5600
5600
$16,800.00
PABX Executive
3 2,200.00 6,600.00 330.00 6,930.00
6,600.00
6,600.00
6,600.00
6,600.00
6,600.00
6,600.00
39,600.00
6600
6600
6600
$19,800.00
PABX Supervisor
4
750.00 3,000.00 150.00 3,150.00
3,000.00
3,000.00
3,000.00
3,000.00
3,000.00
3,000.00
18,000.00
3000
3000
3000
$9,000.00
15
550.00 8,250.00 412.50 8,662.50
8,250.00
8,250.00
8,250.00
8,250.00
8,250.00
8,250.00
49,500.00
8250
8250
8250
$24,750.00
26750
26750
26750
26750
26750
26750
160500
26750
26750
26750
$160,500.00
26,750.00
26,750.00
26,750.00
26,750.00
26,750.00
26,750.00
160,500.00
26,750.00
26,750.00
26,750.00
$80,250.00
8,025.00
1,337.50
1,337.50
1,337.50
1,337.50
1,337.50
1,337.50
8,025.00
1,337.50
1,337.50
1,337.50
$4,012.50
17,655.00
2,942.50
2,942.50
2,942.50
2,942.50
2,942.50
2,942.50
17,655.00
2,942.50
2,942.50
2,942.50
$8,827.50
SOCSO 2%
3,210.00
535.00
535.00
535.00
535.00
535.00
535.00
3,210.00
535.00
535.00
535.00
$1,605.00
HRDF 1%
1,605.00
267.50
267.50
267.50
267.50
267.50
267.50
1,605.00
267.50
267.50
267.50
$802.50
Allowance $3.00/P
41,062.50
6,843.75
6,843.75
6,843.75
6,843.75
6,843.75
6,843.75
41,062.50
6,843.75
6,843.75
6,843.75
$20,531.25
Meals
Operator
Apr-05
Feb-08
Jan-08
TOTAL
Mar-08
Feb-08
3 MONTH OVER HEAD
Jan-08
Adjustment
Increment
No Staff
Basic Sal
Ttl Payroll
6 MONTH OVER HEAD BUDGET
TOTAL
$80,250.00 25
9600
26750 1337.5
28087.5
0
$80,250.00
Total Rooms Department Basic Overtime 5% EPF 11%
27,375.00
4,562.50
4,562.50
4,562.50
4,562.50
4,562.50
4,562.50
27,375.00
4,562.50
4,562.50
4,562.50
$13,687.50
Training
3,000.00
500.00
500.00
500.00
500.00
500.00
500.00
3,000.00
500.00
500.00
500.00
$1,500.00
Medical
4,500.00
750.00
750.00
750.00
750.00
750.00
750.00
4,500.00
750.00
750.00
750.00
$2,250.00
450.00
75.00
75.00
75.00
75.00
75.00
75.00
450.00
75.00
75.00
75.00
$225.00
7,500.00
1,250.00
1,250.00
1,250.00
1,250.00
1,250.00
1,250.00
7,500.00
1,250.00
1,250.00
1,250.00
$3,750.00
32,100.00
5,350.00
5,350.00
5,350.00
5,350.00
5,350.00
5,350.00
32,100.00
5,350.00
5,350.00
5,350.00
$16,050.00
$306,982.50
$51,163.75
$51,163.75
$51,163.75
$51,163.75
$51,163.75
$306,982.50
$51,163.75
$51,163.75
$51,163.75
$153,491.25
Insurance Uniform Bonus 2% Payroll & Benefit
$51,163.75 ###
NEW HOTEL & RESORT Business center Manning & Payroll Budget Proposal Year 2008 DAY ROOMS
31
29
31
30
31
30
18600
17400
18600
18000
18600
18000
PAID ROOMS
20%
100%
50%
50%
50%
50%
ROOM OCCUPIED
3720
17400
9300
9000
9300
9000
Feb-08
Mar-08
Apr-08
May-08
Jun-08
Jan-08
Feb-08
Mar-08
3 MONTH OVER HEAD
Jan-08
Adjustment
Increment
No Staff
Basic Sal
Ttl Payroll
6 MONTH OVER HEAD BUDGET
Business Center Manager
1 3,300.00
3,300.00 165.00
3,465.00
3,300.00
3,300.00
3,300.00
3,300.00
3,300.00
3,300.00
19,800.00
3,300.00
3,300.00
3,300.00
$9,900.00
Asst Business Center Manager
2 2,800.00
5,600.00 280.00
5,880.00
5,600.00
5,600.00
5,600.00
5,600.00
5,600.00
5,600.00
33,600.00
5,600.00
5,600.00
5,600.00
$16,800.00
Business Center Supervisor
3 2,200.00
6,600.00 330.00
6,930.00
6,600.00
6,600.00
6,600.00
6,600.00
6,600.00
6,600.00
39,600.00
6,600.00
6,600.00
6,600.00
$19,800.00
Business Center Clerk
4
3,000.00 150.00
3,150.00
3,000.00
3,000.00
3,000.00
3,000.00
3,000.00
3,000.00
18,000.00
3,000.00
3,000.00
3,000.00
$9,000.00
10 9,050.00 18,500.00 925.00 19,425.00
18,500.00
18,500.00
18,500.00
18,500.00
18,500.00
18,500.00
111,000.00
18,500.00
18,500.00
18,500.00
$111,000.00
18,500.00
18,500.00
18,500.00
18,500.00
18,500.00
18,500.00
111,000.00
18,500.00
18,500.00
18,500.00
$55,500.00
5,550.00
925.00
925.00
925.00
925.00
925.00
925.00
5,550.00
925.00
925.00
925.00
$2,775.00
12,210.00
2,035.00
2,035.00
2,035.00
2,035.00
2,035.00
2,035.00
12,210.00
2,035.00
2,035.00
2,035.00
$6,105.00
SOCSO 2%
2,220.00
370.00
370.00
370.00
370.00
370.00
370.00
2,220.00
370.00
370.00
370.00
$1,110.00
HRDF 1%
1,110.00
185.00
185.00
185.00
185.00
185.00
185.00
1,110.00
185.00
185.00
185.00
$555.00
Allowance $3.00/P
16,425.00
2,737.50
2,737.50
2,737.50
2,737.50
2,737.50
2,737.50
16,425.00
2,737.50
2,737.50
2,737.50
$8,212.50
Meals
750.00
TOTAL
TOTAL
$55,500.00 0.00
$55,500.00
Total Rooms Department Basic Overtime 5% EPF 11%
10,950.00
1,825.00
1,825.00
1,825.00
1,825.00
1,825.00
1,825.00
10,950.00
1,825.00
1,825.00
1,825.00
$5,475.00
Training
3,000.00
500.00
500.00
500.00
500.00
500.00
500.00
3,000.00
500.00
500.00
500.00
$1,500.00
Medical
1,800.00
300.00
300.00
300.00
300.00
300.00
300.00
1,800.00
300.00
300.00
300.00
$900.00
180.00
30.00
30.00
30.00
30.00
30.00
30.00
180.00
30.00
30.00
30.00
$90.00
3,000.00
500.00
500.00
500.00
500.00
500.00
500.00
3,000.00
500.00
500.00
500.00
$1,500.00
22,200.00
3,700.00
3,700.00
3,700.00
3,700.00
3,700.00
3,700.00
22,200.00
3,700.00
3,700.00
3,700.00
$11,100.00
$189,645.00
$31,607.50
$31,607.50
$31,607.50
$31,607.50
$31,607.50
$189,645.00
$31,607.50
$31,607.50
$31,607.50
$94,822.50
Insurance Uniform Bonus 2% Payroll & Benefit
$31,607.50 ###
ROOMS DIVISION CAPEX 2008 Capital Expenditure
No.
Item
Unit
Propose Qty
Oper Required
Cost
Total
Purpose
1 Walkie Talkie Codless (Head Gear)
26
26
26
2,200.00
57,200.00 Communication
2 Desk Top Computer
21
21
21
2,500.00
52,500.00 Administration Back of The House
7
7
7
2,500.00
17,500.00 Operational
4 Administration Desk
38
32
32
800.00
25,600.00 Administration Back of The House
5 Filing Rack
26
20
20
500.00
10,000.00 Guest facilities
6 Wheel Chair
30
30
30
1,500.00
1
1
1
250,000.00
76
76
76
250.00
1
1
1
50,000.00
10 Magnetic Door Card Master
3
3
3
2,000.00
6,000.00 Key Door
11 Information Stand Board
5
5
5
1,200.00
6,000.00 In House Activities Information
3 Concierge Trolly/Cart
7 PABX System 8 LCD Phone Receiver 9 Paging System
12 Concierge Desk 13 Safety Box 14 Information Center Desk
1
1
1
2,500.00
600
600
600
450.00
45,000.00 Guest facilities 250,000.00 Telecommunication 19,000.00 Direct Communication 50,000.00 Emergency
2,500.00 Admin Operation 270,000.00 Guest unit
1
1
1
1,200.00
15 Office Desk
12
12
12
1,200.00
14,400.00 Workstation
1,200.00 Manager on Duty
16 Laptop
15
15
15
3,500.00
52,500.00 mobalize Work Station
879,400.00
Operational Equipment
No.
Item
Present Qlty Propose Qlty
Cost
Total
Purpose
Related Documents
Fop Ay Roll Budget
May 2020 1
Ay
August 2019 43
Ay
April 2020 28
Fop 01
May 2020 3
Fop Letter 3.14.01
November 2019 3