Mexico’s Financial ManagementFMC 2010

1

FMC 2009 Vouchering Cashiering Allowances – Payroll, ORE, Education

Allowance, Representation, IVA. Accounting – Reporting, audit

request, budget cable, special request. Regional support (New for FY2010)

2

Vouchering Number of voucher processed

2008 = 13,615 2009 to date = 13,953

44,000 strip codes a year

3

Voucher Production Reports

4

Cashiering Number of vouchers processed

2008 = 22,689 2009 to date = 24,023

MRV 40 Million pesos collected weekly ($3

Million USD) 1,040,000,000 Million pesos annually

($80 Million USD)5

Allowances IVA submissions Vouchers

2008 = 1,755 2009 to date = 2,613

Transactions 2008 = 2,600 official

300 personal 2009 = 3,000 official

350 personal 6

Process flow for IVA processing

7

8

Accounting

Support 730 USDHs and US PSCs 1,322 LES, PSAs and FMAs 44 agencies 14 Agencies supported by FMC

accounting

9

Accounting FY09 ICASS budget = $24.4 million

Traditional - $18.6 Million LGP - $1.5 Million OBO - $4.3 Million

FY09 Program budgets = $18.6 million Traditional - $15.1 Million Reimbursable (Alcohol Tobacco & Firearms,

Federal Benefits Unit , Veterans Affairs, World Security Upgrade)- $3.5 Million

10

Accounting FY09 BCC Funds = $2.2 million FY09 DS Funds = $6.3 million FY09 PD Funds = $3.7 million FY09 MRV Funds = $10 million FY09 OBO Funds = $13.2 million

11

FMC’s Customers

12

One Voice for the Mission

WHA Budget Bureau Charleston Hacienda

13

FMC’s Goals 2010 Technological usage for more

efficiency Regional Support Resource Increases for Mission

Mexico

14

FMC’s Goals 2010 Technological usage for more efficiency

E-Travel EFT Payments for local vendors Improve Utility Payments Travel Cards for FSN’s Representation Vouchers

15

FMC’s Goals 2010 Regional support

14 Consular Agencies 9 Consulates

16

Regional Support

Consulates Access Financial Information Understanding ICASS Budget Preparation Reviewing Cashier Operations

17

Regional Support

Consular agencies Internal controls Cash collection Fee collection

18

FMC’s Goals 2010

Engage WHA/ICASS on Missions Mexico’s Resource Needs.

19

Resources Increase Subscription of services done at each post Counts for 10 locations = 2,352 data points for

Mission Cost Center ICASS employees mission wide LES = 443 Time allocations for 443 LES ICASS employees Number of USDH

FY08 = 653 FY09 = 730

Number of clients = 2,052 Number of Agencies = 44 20

Mission Growth NSDD 38 Request 2008 (By agency)

Agency LES USDHOpen Source Center 1Agri Animal and Plant Inspection Service 1Drug Enforcement Administration 1OPDAT Prosecu Development Ass is tance 1Alcohol Tobacco & Fi rearms 2State Department 1 11Overseas Bui lding Operations 2State NAS 1 4Diplomatic Securi ty H&L 2 1Diplomatic Securi ty 3Citizen & Inmigration Services 1 5DHS - Customs and Border Protection 1DHS 1AID - DEVL. ASS. 1

TOTAL 7 32

New Positions

21

ICASS ─ Tracking Growth 2008Mission MexicoFY08 National Security Decision Directive (NSDD-38)SEQ NBR

AGENCY NBR

AGENCY NAMENSDD-38 CABLE

REQ NBR

NSDD-38 CABLE RES

NBRLOCATION POSITION NAME

POSITION NUMBER

INCUMBENT USDH LES EFFECTIVE

8-001 1585.0 JUSTICE ATF State 111446 FY07 Mex 05435 Mexico City Special Agent GS-14 96128 Chillcott Dewey 1 10/ 12/ 07

8-002 1900.0 STATE Mex 4930 FY07 Mex 05542 Mexico City Scientific & Tech Adv, SFS 92454000 Aguasvivas Ana -1 10/ 22/ 078-002 1900.0 STATE Mex 4930 FY07 Mex 05542 Mexico City Off. Mgmt Spec FS-06 92433000 Wagner David -1 10/ 22/ 07

8-003 1585.0 JUSTICE ATF State 137263 FY07 Mex 05582 Monterrey Special Agents GS-13 96124 Penate Harry 1 10/ 24/ 078-003 1585.0 JUSTICE ATF State 137263 FY07 Mex 05582 Monterrey Special Agents GS-13 96130 Smith Lamont 1 10/ 24/ 07

8-004 1932.9 STATE H&L DS State 146446 Mex 05781 Guadalajara Asst. Regional Security Officer FS - 3 56199999 Gallagher David 1 11/ 08/ 078-004 1932.9 STATE H&L DS State 148155 Mex 05781 Matamoros Asst. Regional Security Officer FS - 3 56189999 Lebow Dennis 1 11/ 08/ 07

8-005 1930.0 STATE NAS State 08909 Mex 006183 Mexico City NAS Management Officer 96008 Selbin Susan 1 12/ 14/ 07

8-006 1930.0 STATE NAS State 163351 Mex 00391 Mexico City NAS Control Officer 10634000 Garcia Thomas -1 02/ 12/ 08

8-007 1900.0 STATE State 015193 Mex 000682 Ciudad Juarez Information Management Spec 55118002 Francis Ruddy 1 03/ 07/ 08

8-008 1930.0 STATE NAS State 020412 Mex 001405 Mexico City PSC Dep Prog Coordinator 96002 Vacant 1 05/ 09/ 08

8-009 1942.0 STATE - DS State 011063 Mex 00670 Merida Regional Security Officer 56444444 Cabrera Marcos 1 03/ 07/ 08

8-010 1510.0 JUSTICE DEA State 024868 Mex 001556 Mexico City Regional Accountant GS-13 96696 Vacant 1 05/ 21/ 08

8-011 1900.0 STATE NAS State 026998 Mex 001405 Mexico City PSC Policy Advisor FS- 02 96004 Vacant 1 05/ 09/ 08

8-012 7005.3 DHS CIS State 031324 Mex 001407 Ciudad Juarez Immigration Officer GS- 12 96716 Vacant 1 05/ 09/ 088-012 7005.3 DHS CIS State 031324 Mex 001407 Ciudad Juarez Adjudications Officer GS-13 96717 Vacant 1 05/ 09/ 088-012 7005.3 DHS CIS State 031324 Mex 001407 Ciudad Juarez Locally-recruited DH Pos 96719 Vacant 1 05/ 09/ 08

8-013 7005.3 DHS CIS State 031355 Mex 001407 Mexico City Locally-recruited DH Pos 96734 Vacant 1 05/ 09/ 088-013 7005.3 DHS CIS State 031355 Mex 001407 Monterrey Immigration Office GS-13 96736 Vacant 1 05/ 09/ 08

8-014 1515.3 OPDAT RLA State 022564 Mex 00892 Mexico City Intermittent Legal Advisor 96500 Vacant 1 03/ 28/ 08

8-015 7005.3 DHS CIS State 039138 Mex 001301 Tijuana Sup Adjudications Off GS-14 96701 Martinez Lidia -1 04/ 29/ 088-015 7005.3 DHS CIS State 039138 Mex 001301 Tijuana Admin Assistant - -̀ -1 04/ 29/ 08

8-016 1900.0 STATE H&L CA State 032909 Mex 001157 Mexico City Consular Officer 30303034 Wu Nelson 1 04/ 30/ 088-016 1900.0 STATE H&L CA State 032909 Mex 001157 Ciudad Juarez Consular Officer 30303032 Vacant 1 04/ 30/ 088-016 1900.0 STATE H&L CA State 032909 Mex 001157 Guadalajara Consular Officer 30303033 Vacant 1 04/ 30/ 088-016 1900.0 STATE H&L CA State 032909 Mex 001157 Monterrey Consular Officer 30303030 Cannon Leanne 1 04/ 30/ 088-016 1900.0 STATE H&L CA State 032909 Mex 001157 Monterrey Consular Officer 30303037 Vacant 1 04/ 30/ 088-016 1900.0 STATE H&L CA State 032909 Mex 001157 Nuevo Laredo Consular Officer 30303031 Vacant 1 04/ 30/ 0422

Mission Growth NSDD 38 Request 2009 (By agency)

Agency LES USDHAlcohol Tobacco & Fi rearms 4State Department 22State NAS 12Diplomatic Securi ty 2Treasury/International Affairs 1Defense/Northern Command 2Food & Drug Administration 2 2TOTAL 2 45

New Positions

23

ICASS ─ Tracking Growth 2009Mission MexicoFY09 National Security Decision Directive (NSDD-38)SEQ NBR

AGENCY NBR

AGENCY NAMENSDD-38 CABLE

REQ NBR

NSDD-38 CABLE RES

NBRLOCATION POSITION NAME

POSITION NUMBER

INCUMBENT USDH LES EFFECTIVE

9-001 1900.0 STATE Program Pending Pending Mexico City Political Officer 10-349999 Hamilton, Meredith 1 04/ 28/ 089-001 1900.0 STATE Program Pending Pending Mexico City Political Officer 10-592000 Vacant 1 08/ 29/ 089-001 1900.0 STATE Program Pending Pending Mexico City Political Officer 38-576200 Jackson, Justin 1 07/ 30/ 079-001 1900.0 STATE Program Pending Pending Monterrey Prog. Coordinator Officer 38-998900 Martinez, David 1 07/ 24/ 08

9-002 1942.0 STATE DS State 078579 Mex 002472 Guadalajara Office Management Specialist FS-7 56-086006 Vacant 1 08/ 12/ 08

9-003 1930.0 STATE NAS State 123431 Mex 003551 Mexico City Deputy Program Coordinator for IT, FS-0296-021 Vacant 1 12/ 03/ 089-003 1930.0 STATE NAS State 123431 Mex 003551 Mexico City Assistant Program Coordinator for IT, FS-0396-022 Vacant 1 12/ 03/ 089-003 1930.0 STATE NAS State 123431 Mex 003551 Mexico City INL Assistant Program Coordinator for IT, FS-0396-023 Vacant 1 12/ 03/ 089-003 1930.0 STATE NAS State 123431 Mex 003551 Mexico City Deputy Law Enforcement Coordinator, FS-0296-024 Vacant 1 12/ 03/ 089-003 1930.0 STATE NAS State 123431 Mex 003551 Mexico City Deputy Border/ POE Security Coordinator, FS-0296-025 Vacant 1 12/ 03/ 089-003 1930.0 STATE NAS State 123431 Mex 003551 Mexico City Deputy Narcotics Coordinator, FS-02 96-026 Vacant 1 12/ 03/ 089-003 1930.0 STATE NAS State 123431 Mex 003551 Mexico City Corrections Advisor, FS-02 96-027 Vacant 1 12/ 03/ 08

9-004 1900.0 STATE Program State 130327 Mex 003810 Ciudad Juarez Vice Consul, FS-04 30-015115 Vacant 1 12/ 29/ 089-004 1900.0 STATE Program State 130327 Mex 003810 Ciudad Juarez Vice Consul, FS-04 30-015116 Vacant 1 12/ 29/ 089-004 1900.0 STATE Program State 130327 Mex 003810 Ciudad Juarez Vice Consul, FS-04 30-015117 Vacant 1 12/ 29/ 089-004 1900.0 STATE Program State 130321 Mex 003810 Tijuana Vice Consul, FS-04 30-015119 Vacant 1 12/ 29/ 089-004 1900.0 STATE Program State 130321 Mex 003810 Tijuana Vice Consul, FS-04 30-015120 Vacant 1 12/ 29/ 089-004 1900.0 STATE Program State 130326 Mex 003810 Nogales Vice Consul, FS-04 30-015118 Vacant 1 12/ 29/ 08

9-005 7545.3 Health & Human ServicesState 089920 Mex 003725 Mexico City LA Assistant Regional Director GS-13/ 14 96-510 Vacant 1 12/ 17/ 089-005 7545.3 Food & Drug AdministrationState 089920 Mex 003725 Mexico City LA Assistant Regional Director GS-13/ 14 96-511 Vacant 1 12/ 17/ 089-005 7545.3 Food & Drug AdministrationState 089920 Mex 003725 Mexico City FDA Program Coordinator, LES-11 AFDA01 Vacant 1 12/ 17/ 089-005 7545.3 Food & Drug AdministrationState 089920 Mex 003725 Mexico City FDA Program Secretary, LES-7 AFDA02 Vacant 1 12/ 17/ 08

9-006 Treasury/ International AffairsState 135377 Mex 000022 Mexico City Treasury Department Attache GS-15 96-180 Vacant 1 01/ 06/ 09

9-007 5728.0 Defense/ Northern CommandState 004732 Mex 000465 Mexico City Logistics Management Specialist, GS-12 96-688 Vacant 1 02/ 20/ 099-007 5728.0 Defense/ Northern CommandState 004732 Mex 000465 Mexico City Counternarcotics Operations Officer, MIL O-494-689 Vacant 1 02/ 20/ 09

9-008 1930.0 STATE NAS State 011088 Mex 000441 Mexico City NAS Financial Management Advisor, FS-296-028 Vacant 1 02/ 18/ 099-008 1930.0 STATE NAS State 011088 Mex 000441 Mexico City Logistics Advisor, FS-2 96-029 Vacant 1 02/ 18/ 09

9-010 7005.3 DHS-CIS Mex 000536 Ciudad Juarez LES Inmigration Assistant 96CIS715 Abolishment -1 02/ 25/ 0924

ICASS ─ Tracking Growth 2009

AGENCY NAME EmbassyCiudad Juarez

Guadalajara Nogales Tijuana Total

Alcohol Tobacco & Firearms 2 2 4Defense/ Northern Command 2 2Diplomatic Security 2 2Food & Drug Administration 4 4State Department 10 7 1 4 22STATE NAS 12 12Treasury/ International Affairs 1 1

TOTAL 29 9 2 1 6 47

25

Mission GrowthPer the ICASS Software the following numberof positions were required:

New LES ICASS positions 2008 17 LES 2 USDH

New LES ICASS positions 2009 23 LES 3 USDH

26

Mission Growth

Actual positions added: 13 New LES Positions Added in 2008 TBD in 2009 29 ICASS positions priorities

Embassy (7) Hermosillo (3) Tijuana (3) Monterrey (2) Nuevo Laredo (3) Matamoros (3) Ciudad Juarez (2) Nogales (3) Guadalajara (3)

27

Mission Growth

ICASS Budget 2008 = $18,101,000

ICASS Budget 2009 = $18,609,800

28

Mission Growth FY09 Initial requirements

Cost of new positions 09 = $294K Cost of Wage Increase 09 = $325K Cost of Step increase 09 = $285K Cost of Price increase 09 = $306K Total = $1.2 Million

Total needed = $19.3 Million Total received = $18.6 Million Difference against received = -$701K 29

Mission Comparison

30

Country ICASS LES ICASS USDH Total ICASS

Number of customers LES & USDH

Customer ratio to ICASS Empl.

India 827 22 849 1949 2.3

China 695 60 * 755 1800 2.4

South Africa 237 18 255 880 3.5

Egypt 691 19 710 1908 2.7

Mexico 443 29 472 2052 4.3

*25 Contractors

Point Of Contacts Philip Dubois Budget & Regional Support x2101 Jerome Hoffman Allowances & Budget

x2660 Chris Helmkamp Vouchering &Cashiering

x2950 Claudia Sugiyama Allowances

x2814 Maria (Lola) Gutierrez Vouchering x2555 Cindy Rea Travel

x2765 Gerardina Guevara Allowances

x4188 Gerardo Olivares Accounting

x4179 Fernando Perez ICASS/DS x2891 Fernando De la Cruz MRV/BCC x4708 Catherine Chapman Cashiering

x2080

31

FMC Staff

Intro to FMC32

Questions?

33