EXHIBIT Q 




EXHIBIT R 


Exhibit 1B

OPERATING EXPENSE DETAIL--INDIRECT COSTSanta Monica Municipal Airport(For Fiscal Years Ending June 30)EXPENDITURES - ADMIN INDIRECT FY 2012-2013 BUDGET 

 Admin Indirect 

Plan Year 

FY 2012-2013 Airfield Non-airfield Total Airfield 

PUBLIC WORKS 33431.544340

Indirect Cost Allocation $ 864,611 n/a n/a

City Council - Legislative Services 4,283 0.0% 100 0% 100% 

City Council - City Council Staff Svcs 0.0% 100 0% 3,625 100% City Council - Intergovernmental Rel 0.0% 100 0% 1,126 100% City Council - Public Information 0.0% 100 0% 534 100% City Manager Admin - City Administration 0.0% 100 0% 8,081 100% City Manager Admin - City Council Staff Supp 2,132 10.0% 90 0% 100% City Manager Admin - Intergovernmental Rel 0.0% 100 0% 634 100% City Manager Admin - Public Information 10.0% 90 0% 1,107 100% City Manager Admin - Special Projects 10.0% 90 0% 59,953 100% Community Information - Public Information 0.0% 100 0% 2,193 100% IS- Web Development - GIS Services 10.0% 90 0% 5,603 100% IS - Systems Networks - Svr admin + Network Support 10.0% 90 0% 9,881 100% IS - Systems Networks - Telecommunications Support 1,380 43.6% 56.4% 100% IS Software Systems - Application Develop/Supp. 22,048 0.0% 100 0% 100% IS Support Services - Help Desk /Training Svcs 5,797 0.0% 100 0% 100% Rec & Elect Svcs - Admin- City Council Support 2,718 0.0% 100 0% 100% R&E Support Services- City Council Support 0.0% 100 0% 120 100% R&E Support Services - Mail Services 20.0% 80 0% 6,388 100% R&E Support Services - Printing Services 0.0% 100 0% 8,543 100% Finance Admin & Budget - City Administration 1,984 5.0% 95 0% 100% Finance Admin & Budget - Purchasing Services 8,275 5.0% 95 0% 100% Financial Operations - General Accounting 5.0% 95 0% 10,334 100% Financial Operations - Payroll Services 43.6% 56.4% 4,016 100% Financial Operations - Accounts Payables 0.0% 100 0% 2,982 100% Financial Operations - Budget Prep/Support 5.0% 95 0% 345 100% Financial Operations - Financial System Support 1,060 5.0% 95 0% 100% Finance - Budget - Budget Prep / Support 5.0% 95 0% 6,018 100% Fin BRO - Cash receipts 5.0% 95 0% 8,418 100% Fin BRO - Cash mgmt/invest. 5.0% 95 0% 327 100% Fin BRO - Budget Prep 5.0% 95 0% 591 100% Finance - Internal Audit 5.0% 95 0% 2,213 100% City Attorney - Dept Legal Services 10.0% 90 0% 187,431 100% 

1

HR Admin- Recruit Select Staff 43.6% 56.4% 917 100% HR Admin- Benefit Adm - Perm Empl 43.6% 56.4% 231 100% HR Admin - Labor Negotiations 43.6% 56.4% 945 100% HR Admin - Employee Training 43.6% 56.4% 783 100% Employment and Org Dev - Recruit, Select Staff 4,042 43.6% 56.4% 100% Employment and Org Dev - Labor negotiations 43.6% 56.4% 108 100% Employment and Org Dev - Employee Training 1,789 43.6% 56.4% 100% Employment and Org Dev - Class & Comp Study 946 43.6% 56.4% 100% Employee Rel + Benefits - Recruit, Select Staff 43.6% 56.4% 179 100% Employee Rel + Benefit - Benefit Adm. - Perm Empl. 2,593 43.6% 56.4% 100% Employee Rel + Benefit - Labor Negotiations 43.6% 56.4% 226 100% Employee Rel + Benefit - Employee Training 43.6% 56.4% 88 100% Employee Rel + Benefit - Class & Comp Study 43.6% 56.4% 35 100% CCS Public Landscape Admin - Landscape Maint 1,564 0.0% 100 0% 100% PW Admin - Admin Services 25.0% 75 0% 34,894 100% PW Fac Maint - Admin 20.0% 80 0% 120 100% PW Fac Maint - Fac Maint Mgmt 20.0% 80 0% 5,574 100% 

$ 435,173 864,611 $ $ 

4

Source: City of Santa Monica Prepared by: City of Santa Monica and WJ Advisors LLC

PERCENTAGE 

Admin Indirect % 

Page 1 of 3
Exhibit 1B

OPERATING EXPENSE DETAIL--INDIRECT COSTSanta Monica Municipal Airport(For Fiscal Years Ending June 30)EXPENDITURES - ADMIN INDIRECT FY 2012-2013 BUDGET 

 Admin Indirect 

Plan Year 

FY 2012-2013 Airfield Non-airfield Total Airfield 

AIRPORT MAINT 33457 

$ 74,617 n/a n/a $ -

City Council - City Council Staff Svcs 1,054 0.0% 100 0% 100% 

City Council - Intergovernmental Rel 0.0% 100 0% 328 100% City Council - Public Information 0.0% 100 0% 155 100% City Manager Admin - City Administration 0.0% 100 0% 2,350 100% City Manager Admin - Intergovernmental Rel 0.0% 100 0% 184 100% City Manager Admin - Public Information 0.0% 100 0% 322 100% CM - Comm & Gov Rel - Public Information 0.0% 100 0% 638 100% IS- Systems & Networks - Server Admin+Network Support 1,853 0.0% 100 0% 100% IS- Systems & Networks -Telecommunications Support 690 0.0% 100 0% 100% IS Support Services - Help Desk /Training Svcs 1,087 0.0% 100 0% 100% Finance Admin - City Administration 20.0% 80 0% 577 100% Finance Admin - Purchasing Services 20.0% 80 0% 11,893 100% Financial Operations - General Accounting 20.0% 80 0% 3,006 100% Financial Operations - Payroll Services 20.0% 80 0% 2,008 100% Financial Operations - Accounts Payables 20.0% 80 0% 4,058 100% Financial Operations - Budget Prep/Support 20.0% 80 0% 100 100% Financial Operations - Financial System Support 308 20.0% 80 0% 100% Finance- Budget - Budget Prep/Support 20.0% 80 0% 1,750 100% Fin BRO - Budget Prep / Support 20.0% 80 0% 172 100% Finance - Internal Audit Services 20.0% 80 0% 644 100% HR Admin - Benefit Adm - Perm Empl 20.0% 80 0% 116 100% HR Admin - Labor Negotiations 20.0% 80 0% 473 100% HR Admin - Employee Training 20.0% 80 0% 392 100% HR Admin - Rideshare Admin 20.0% 80 0% 31 100% HR Employmt + Org Dev - Labor Negotiations 20.0% 80 0% 54 100% HR Employmt + Org Dev- Employee Training 20.0% 80 0% 894 100% HR Employmt + Org Dev - Class & Comp Study 20.0% 80 0% 473 100% HR Emp Rel + Benefits - Benefit Adm. - Perm Empl. 1,296 20.0% 80 0% 100% HR Emp Rel + Benefits - Labor Relations 20.0% 80 0% 113 100% HR Emp Rel + Benefits - Employee Training 20.0% 80 0% 44 100% HR Emp Rel + Benefits - Class & Comp Study 20.0% 80 0% 17 100% HR Emp Rel + Benefits - Rideshare Prog Admin 20.0% 80 0% 328 100% PW Admin Svcs - Admin 20.0% 80 0% 17,447 100% PW Fac Maint - Admin 20.0% 80 0% 2,682 100% PW Fac Maint - Custodial Svcs 20.0% 80 0% 12,711 100% PW Fac Maint - Fac Maintenance Mgmt 20.0% 80 0% 124,805 100% 

2

$ 195,053 74,617 $ $ 

3

Source: City of Santa Monica Prepared by: City of Santa Monica and WJ Advisors LLC

Admin Indirect % 

PERCENTAGE 

Page 2 of 3
Exhibit 1C

OPERATING EXPENSE DETAIL--INDIRECT COSTSanta Monica Municipal Airport(For Fiscal Years Ending June 30)

SALARIES & WAGES

JobDesc Division EmpName Salaries (511000) as in JDE

Retirement

as in JDE Benefits

Emp Share as in

JDE Tot Salary 

Airport Operations Admin 2030 Makrides,Stelios $ 122,349 $ 23,124 $ 23,713 $ (845) $ 16

Airport Noise/Operations Spec 2030 Gaskins,Nikolas S 68,411 12,930 13,408 (450) 9

Airport Noise/Operations Spec 2030 Hernandez,Diana V 68,590 12,963 11,332 (308) 9

Business Assistant 2030 Diaz,Stella 74,945 14,165 21,483 (845) 10

Business Assistant 2030 Mecham,Deena D 81,903 15,480 11,614 (308) 10

Staff Assistant II 2030 Ferguson,Warren M 54,751 10,348 17,128 (616) 8

Airport Services Director 2030 Trimborn,Robert D 167,653 31,686 31,390 (1,171) 22

Administrative Analyst 2030 Kate S. 82,577 14,857 18,801 (652) 11

$ 721,179 $ 135,553 $ 148,868 $ (5,196) $ 1,00

Airport Maintenance Crew Ldr 4570 Gonzalez,Jaime $ 66,621 $ 14,024 $ 22,160 $ (850) $ 10

Airport Maintenance Worker 4570 Carrillo,Richard 65,077 13,156 5,080 - 8

Airport Maintenance Worker 4570 Liu,Hung K 60,716 12,983 22,012 (850) 9

Airport Maintenance Worker 4570 Orellana,Willie 64,302 13,141 21,972 (845) 9

$ 256,716 $ 53,303 $ 71,224 $ (2,546) $ 37

PROFESSIONAL SERVICESOrder Number Or Ty Supplier Description

Amount

Committed Airfield Account Num

1494 OS 203659 PROFESSIONAL SERVICES 21,600 $ $ 21,600 33431 5550

1494 OS 203659 PROFESSIONAL SERVICES 33431 5550

1494 OS 203659 PROFESSIONAL SERVICES 33431 5550

2122 OS 336481 PROFESSIONAL SERVICES 18,460 18,460 33431 5550

2122 OS 336481 PROFESSIONAL SERVICES 33431 5550

2122 OS 336481 PROFESSIONAL SERVICES 33431 5550

2152 OS 299894 PROFESSIONAL SERVICES 20,272 20,272 33431 5550

2165 OS 280420 PROFESSIONAL SERVICES 20,675 20,675 33431 5550

2562 OS 346863 PROFESSIONAL SERVICES 37,538 37,538 33431 5550

2562 OS 346863 PROFESSIONAL SERVICES 33431 5550

9308 OS 338071 PROFESSIONAL SERVICES 33431 5550

9310 OS 338072 PROFESSIONAL SERVICES 7,162 33431 5550

9628 OS 341032 PROFESSIONAL SERVICES 198,119 33431 5550

345753 OW 236192 Advertising 285 33431 5550

345753 OW 236192 Advertising 33431 5550

345792 OW 203225 Advertising 285 33431 5550

345792 OW 203225 Advertising 33431 5550

345945 OW 287500 advertising 273 33431 5550

346767 OW 287500 Open House Ad 273 33431 5550

346767 OW 287500 Open House Ad 33431 5550346768 OW 200946 Open House Banner 120 33431 5550

346769 OW 200946 Open House Banner 131 33431 5550

346769 OW 200946 Open House Banner 33431 5550

$ 325,194 $ 118,546

36%

Source: City of Santa Monica Prepared by: City of Santa Monica and WJ Advisors LLC

Page 3 of 3