Scribd
Upload
126 views4 pages

CGAL-StaffingCost - Draft

This document provides an annual staffing cost breakdown for CGAL. It lists 6 positions - Accounting Officer, Administrative Officer, Plumber, Lifeguard, Technician, and Maintenance. For each position it provides the daily rate, monthly salary, and yearly salary based on minimum wage orders. It then calculates the salary at a breakeven point for the Accounting Officer and Administrative Officer positions. Additional allowances such as a year-end bonus and meal allowance are included. Fixed expenditures including SSS, PhilHealth, and Pag-IBIG contributions are listed. The total annual staffing cost including a 10% administrative fee, 10% service fee, and 15% contingency is over 3 million pesos.

Uploaded by

Mitchie Binarao Baylon
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
126 views4 pages

CGAL-StaffingCost - Draft

This document provides an annual staffing cost breakdown for CGAL. It lists 6 positions - Accounting Officer, Administrative Officer, Plumber, Lifeguard, Technician, and Maintenance. For each position it provides the daily rate, monthly salary, and yearly salary based on minimum wage orders. It then calculates the salary at a breakeven point for the Accounting Officer and Administrative Officer positions. Additional allowances such as a year-end bonus and meal allowance are included. Fixed expenditures including SSS, PhilHealth, and Pag-IBIG contributions are listed. The total annual staffing cost including a 10% administrative fee, 10% service fee, and 15% contingency is over 3 million pesos.

Uploaded by

Mitchie Binarao Baylon
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
You are on page 1/ 4

CGAL (draft)

Annual staffing Cost


As of February, 2023

As per minimum wage order RTWPB 02-


DW-04, 01/23 2nd Tranch
Postion Title Frequency Daily Monthly Yearly

Accounting Officer 2 840.00 25,200.00 302,400.00


Administrative Officer 1 420.00 12,600.00 151,200.00
Plumber 1 420.00 12,600.00 151,200.00
Lifeguard 1 420.00 12,600.00 151,200.00
Technician 2 840.00 25,200.00 302,400.00
Maintenance 1 420.00 12,600.00 151,200.00
SUB-TOTAL 8
TOTAL
Add:
Annual administrative fee 10%
Annual service fee (10%)
Contigency for overtime pay & etc. (15%)
GRAND TOTAL

Note:
Formula for the monthly salary at breakeven point:

Minimum wage + Average Salary /2 = Salary at breakeven point

Position: Accounting Officer

Given:
Minimum wage: 12,600.00
Average Salary: 35,000.00

So;
12,600.00 + 35,000.00 = 47,600/2 = 30,100.00

Position: Administrative Officer

Given:
Minimum wage: 12,600.00
Average Salary: 20,819.00

So;
12,600.00+20,819.00 = 33,419.00/2 = 16,709.50

Yellow filled -Internal (Hidden) for office only


COMPENSATION
Average At breakeven point

Daily Monthly Yearly Daily Monthly Yearly

2,333.33 70,000.00 840,000.00 2,006.67 60,200.00 722,400.00


693.97 20,819.00 249,828.00 556.97 16,709.50 200,514.00
533.33 16,000.00 192,000.00 476.67 14,300.00 171,600.00
600.00 18,000.00 216,000.00 510.00 15,300.00 183,600.00
1,200.00 36,000.00 432,000.00 1,020.00 30,600.00 367,200.00
566.67 17,000.00 204,000.00 493.33 14,800.00 177,600.00
2,133,828.00 1,822,914.00
STANDARD ALLOWANCE (Lumpsum) FIXED EXP
Income from salary

Year-end Meal
Daily Monthly Yearly Sub-total Pagibig
bonus Allowance
326.67 9,800.00 117,600.00 5,000.00 9,000.00 14,000.00 2,400.00
136.98 4,109.50 49,314.00 5,000.00 9,000.00 14,000.00 2,400.00
56.67 1,700.00 20,400.00 5,000.00 9,000.00 14,000.00 2,400.00
90.00 2,700.00 32,400.00 5,000.00 9,000.00 14,000.00 2,400.00
180.00 5,400.00 64,800.00 5,000.00 9,000.00 14,000.00 2,400.00
73.33 2,200.00 26,400.00 5,000.00 9,000.00 14,000.00 2,400.00
310,914.00 84,000.00
FIXED EXPENDITURES (Lumpsum)

SSS (12%) Philhealth Sub-total

100,800.00 33,600.00 136,800.00


29,979.36 9,993.12 42,372.48
23,040.00 7,680.00 33,120.00
25,920.00 8,640.00 36,960.00
51,840.00 17,280.00 71,520.00
24,480.00 8,160.00 35,040.00
355,812.48
2,573,640.48

257,364.05
257,364.05
386,046.07
3,474,414.65

You might also like