Loading...
OB - Item 3A - Expenditure Updates ROSEMEAD SUCCESSOR AGENCY STAFF REPORT TO: THE HONORABLE CHAIR AND BOARD MEMBERS FROM: MATTHEW HAWKESWORTH, ASSISTANT CITY MANAGER DATE: AUGUST 13, 2012 SUBJECT: EXPENDITURE UPDATE SUMMARY As part of completing the January through June 2013 ROPS, the Successor Agency staff has developed the first six -month expenditure report for the prior period of January to June 2012 (Attachment A). It's important to keep in mind that the Successor Agency became effective February 1, 2012 so there are some expenditures related to the former redevelopment agency in January. In order to provide the Board with a more detailed report than the one required by the ROPS, the enclosed detail report will provide the background for the figures in the ROPS. To assist with the reconciliation, the detail report and the ROPS summary have been color coded. Please note that there are two detail reports: Detail Report (Attachment B) and Project Activity Report (Attachment C). The Detail Report reflects expenditures charged directly to the Successor Agency and the Project Activity Report reflects labor costs related to Successor Agency work, but initially charged the respective employee's original cost center. Staff Recommendation: No action is required. PUBLIC NOTICE PROCESS This item has been noticed through the regular agenda notification process in accordance with the Brown Act. Prepared by: Matthew E. Hawkesworth Assistant City Manager Attachments: A - ROPS Prior Period Estimates vs. Actuals B - Expenditure Detail Report — 01/01/12 to 06/30/12 C - Project Activity Report — 01/01/12 to 06/30/12 ITEM NO. 3___ L _- Name of Successor Agency: City of Rosemead County: Los Angeles Pursuant to Health and Safety Code section 34186 (a) PRIOR PERIOD ESTIMATED OBLIGATIONS vs. ACTUAL PAYMENTS RECOGNIZED OBLIGATION PAYMENT SCHEDULE (ROPS 1) January 1. 2012 throucih June 30. 2012 Attachment A Pane/Form Line Project Name / Debt Obligation Payee Description/Project cope Project Area LMIHF Bond Proceeds Reserve Balance Admin Allowance RPTTF Other Estimate Actual Estimate Actual Estimate Actual Estimate Actual Estimate Actual Estimate Actual Grand Total $ 250,632 $ 242,343 $ $ $ $ $ 210,515 $ 148,222 $ 944,852 $ 944,831 $ - $ - 1.00 1 2006A Tax Increment Bonds US Bank Tax Increment Bond Debt Service Merged F 193,486 $ 193,46563 1.00 2 20068 Tax Increment Bonds US Bank Tax Increment Bond Debt Service Merged 515,489 $ 515.468.13 1.00 3 2010 Tex Increment Bonds US Bank Tax Increment Bond Debt Service Merged 231,897 $ 231,896.88 1,00 4 Continuity Disclosure on Bonds Urban Futures Continuity Disclosure service for 2006A. 20088 Merged 5,200 10,400 1 00 5 Slate Conlrnllers' Reeurt RAMS Preperalion of Annual Report Merged 1,000 1 -00. B Bond Trustee Fees US Bank Ban fees related to the 2006A. B and 2010 B MB 2,014 2,014 1.00 7 Annual Audit RAMS Annual audit services Merged 8,076 876 1.00 8 Finances tern Bank of the West Lease Obligation for finance system Merged 5,800 5 1.00 9 Statement of Indebtedness Redevelopment Reporting Preperalion of Annual Report Merged 1.00 10 Arbitrage Calculations Willdan Preperation of arbitrage rebate calculation Merged 4,100 1.00 11 Property Tax AuchisfMciriftring HDL Monitor property tax collectons and appeal Merged 6 9,450 1.00 12 Rosemead Community Ctr. Parkin L Boghossian Engineering Community center parking lot design Merged 1.00 13 Rosemead Community Ctr. Parking Lc Widen Material testing for parking lot engineering Merged 1400 14 Zapopan Park Improvements ADA accessibility & additional parking Merged 1.00 15 Rosemead Park Improvements ADA accessibility improvements Merged 1.00 16 Rosemead Community Ctr. Parking Lot ADA accessibility, teen center & outdoor spit Merged 1.00 17 New Park at Rush & Walnut Grove Community infrastructure improvements Merged 1.00 18 Sewer S stem Expansion Sewer main replacement/upgrade on Garve Merged 1.00 19 Employee Overhead Costs CRY of Rosemead Administrative costs (staffing, audits, legal, Merged 178 119,582 1.00 20 Valley Blvd. Street Improvements Infrastructure improvements - Downtown Cc Merged 1.00 21 Rosemead Park Turf Renovations Community infrastructure improvements Merged 1.00 22 Senior Housing Land Lease - Angelus Rosemead Housind Devil Cost of annual land lease for property Merged 45,600 45,600 1.00 23 Senior Housing Operations Overhead Rosemead Housind Develc Cost of annual operations and overhead sul Merged 56,65D 56,550 1.00 24 Senior Housing Shorfall Subsidy - Ang Rosemead Housind Develc Cost to cover shortfall between rents and or Merged 8,202 8,202 1.00 25 Senior Housing Land Lease - Garvey Rosemead Housind Develc Cost of annual land lease for property Merged 46,100 46 1.00 26 Senior Housing Operations Overhead Rosemead Housind Develc Cost of annual operations and overhead sut Merged 56,550 56 1.00 27 Senior Housing Shorfall Subsidy - Gar Rosemead Housind Devel Cost to cover shortfall between rents and oN Merged 16,405 8 1.00 28 Chamber Operating Agreement Chamber of Commerce Operating Assistance for the Chamber of C4 Merged 4,000 4,000 1 00 29 Housing A gency Staff through 1/31112 City of Rosemead Administrative costs (staffing, audits, legal, Merged 21,225 21,334 Attachment B City of Rosemead, CA Detail Report Account Detail Date Range: 01/01/2012 - 06/30/2012 Account Name Beginning Balance Total Activity Ending Balance Fund: 315 - Merged Capital Projects 315- 0000 -5960 Interfund transfers out Post Date Packet Number Transaction Number Description Vendor Project Account Amount Running Balance 315 -5230 -5255 Bank fees Post Date Packet Number Transaction Number Description Vendor Project Account Amount Running Balance 315 -5230 -5930 Interest expense - 940,830.64 940,830.64 Post Date Packet Number Transaction Number Description Vendor Project Account Amount Running Balance 04M2012 - -- -- _ -- 04/01/2012 GLPK701282 - 0412-0002 - Debt service- 4/1/12 -2006A 11478.999 193,465,63 '708,933.76 06/01/2012 GLPKTO1483 0612-0002 Prin &Int payment -2010A -Jun 2012 11478 -999 231,895.88 940,830.64 Account Name Beginning Balance Total Activity Ending Balance 315- 6015 -5005 Salaries & Wages - Continued Post Date Packet Number Transaction Number Description Vendor Project Account Amount Running Balance 01/08/2012 PYPKT00082 PYPKT00082 —PPE 01- PPE 01 -08 -2012 15,392.70 192,247.34 01/22/2012 PYPKT00090 PYPKT00090 —PPE 01- PPE 01 -22 -2012 16,409.92 208,657.26 02/05/2012 PYPKT00102 PYPKT00302 —PPE 02- PPE 02 -05 -2012 979.78 209,637.04 02/19/2012 PYPKT00109 PYPKTD0109 —PPE 02 PPE 02 -19 -2012 796.07 210,433.11 03/04/2012 PYPKT00114 PYPKT00114 —PPE 03- PPE 03- 042012 857.30 211,290.41 03/18/2012 PYPKT00118 PYPKT00118 —PPE 03- PPE 03 -18 -2012 704.21 211,994.62 04/01/2012 PYPKT00120 PYPKT00120 —PPE 04- PPE 04 -01 -2012 367.42 212,362.04 04/30/2012 GLPKTO1281 0412 -047 Corr Car Allow - Success Ag. - s /bd 5125 (3,510.00) 208,852.04 315 -6015 -5010 Part-time Salaries & Wages Post Date Packet Number Transaction Number Description Vendor Project Account Amount Running Balance 01/08/2012 PYPKT00082 PYPKT00082 —PPE 01- PPE 01 -08 -2012 3,237.34 124,179.51 01/22/2012 PYPKTDD090 PYPKT00090 —PPE 01- PPE 01 -22 -2012 41002 -310 300.00 124,479.51 01/22/2012 PYPKT00090 PYPKT00090 —PPE 01 PPE 01 -22 -2012 41010 -310 150.00 124,629.51 01/22/2012 PYPKT00090 PYPKT00090 —PPE 01- PPE 01 -22 -2012 6,581.71 131,211.22 01/22/2012 PYPKT00090 PYPKT00D90 —PPE 01- PPE 01 -22 -2012 11D48 -999 327.60 131,538.82 03/18/2012 PYPKT00118 PYPKT00118 —PPE 03- PPE 03 -18 -2012 31004 -310 525.00 132,063.82 04/01/2012 PYPKT00120 PYPKT00120 —PPE 04- PPE 0401 -2012 825.00 132,888.82 04/01/2012 PYPKT00120 PYPKT00120— PPE 04- PPE 04-01 -2012 14102 -999 300.00 133,188.82 315- 6015 -5015 Stipend Post Date Packet Number Transaction Number Description Vendor Project Account Amount Running Balance 01/08/2012 PYPKT00082 PYPKT00082 —PPE 01 PPE 01 -08 -2012 375.00 4,687.50 01/22/2012 PYPKT00090 PYPKT00090 —PPE 01- PPE 01 -22 -2012 375.00 5,062.50 315 - 6015 -5025 Name Overtime Workers' compensation - Continued Post Date Packet Number Transaction Number Description Vendor Post Date Packet Number Transaction Number Description Vendor Project Account Amount Running Balance 01/08/2012 PYPKT00092 PYPKTD0D82 —PPE 01- PPE 01 -08 -2012 PYPMW82 79.67 4,280.62 01/22/2012 PYPKT00090 PYPKT00D90 —PPE 01- PPE 01 -22 -2012 01/1812012 59.11 4,339.73 02/05/2012 PYPKT00102 PYPKT00102 —PPE 02- PPE 02 -05 -2012 73,599.05 14.88 4,354.61 03/04/2012 PYPKTOO114 PYPKT00114 —PPE 03- PPE 03- 042012 445.95 24.81 4,379.42 04/01/2012 PYPKT00120 PYPKT00120 —PPE 04- PPE 04-01 -2012 31004- 301 130.52 4,509.94 315 - 6015 -5105 APPKT00419 Social Security/ Mediure UNION BANK OF CALIFORNIA 448.23 Post Date Packet Number Transaction Number Description Vendor Project Account Amount Running Balance 01/08/2012 PYPKT00082 PYPKT00082— PPE01- PPE 01-08 -2012 PYPKT00090 1,326.52 16,707.45 01/22/2012 PYPKT00090 PYPKT00090— PPE01- PPE 01 -22 -2012 02/05/2012 1,570.37 18,277.82 02/05/2012 PYPKT00102 PYPKT00302— PPE02- PPE 02 -05 -2012 80,817.93 73.98 18,351.80 02119/2012 PYPKT00109 PYPKTO0109— PPE02- PPE 02 -19 -2012 188.30 59.37 18,411.17 03/04/2012 PYPKT00114 PYPKT00114 —PPE 03- PPE 03 -04- 2012 65.58 18,476.75 03/18/2012 PYPKT00118 PYPKTO0118— PPE03- PPE 03 -18- 2012 60.16 18,536.91 04/01/2012 PYPKT00120 PYPKTO0120 —PPE 04- PPE 04-01 -2012 PYPKT00120 —PPE 04 PPE 04-01 -2012 53.26 18,590.17 Account Name 315 -6015 -5110 Workers' compensation - Continued Post Date Packet Number Transaction Number Description Vendor 01/31/2012 GIPKT008D4 0112 -014 Alloc Worker's Comp - JuHan'12- RDA Fd j3 Beginning Balance Total Activity Ending Balance Project Account Amount Running Balance 6,766.67 6,766.67 315 -6015 -5115 Retirement contributions Post Date Packet Number Transaction Number Description Vendor Project Account Amount Running Balance 01/08/2012 PYPMW82 PYPKT00082 —PPE 01- PPE 01 -08 -2012 4,749.85 73,157.22 01/1812012 APPKT00419 01 -08- 2011RCDC RETIRE ANNTY 01-08 -2012 UNION BANK OF CALIFORNIA 441.83 73,599.05 01/18/2012 APPKT00419 11- 13- 2011RCDC RETIRE ANNTY 11 -13 -2011 UNION BANK OF CALIFORNIA 445.95 74,045.00 01/18/2012 APPKT00419 11- 27- 2011RCDC RETIRE ANNTY 11 -27 -2011 UNION BANK OF CALIFORNIA 446.32 74,491.32 01/18/2012 APPKT00419 12- 11- 2011RCDC RETIRE ANNTY 22 -11 -2011 UNION BANK OF CALIFORNIA 448.23 74,93955 01/1812012 APPKT00419 12- 25- 2011RCDC RETIRE ANNTY 12 -25 -2011 UNION BANK OF CALIFORNIA 468.58 75,408.13 01/22/2012 PYPKT00090 PYPKT00090 —PPE 01- PPE 01 -22 -2012 5,158.21 80,566.34 02/05/2012 PYPKT00102 PYPKT00102 —PPE 02- PPE 02 -05- 2012 251.59 80,817.93 02/19/2012 PYPKT00109 PYPKT00109 —PPE 02- PPE 02 -19- 2012 188.30 81,006.23 03/04/2012 PYPKT00114 PYPKT00114 —PPE 03- PPE 03- 042012 222.54 81,228.77 03/18/2012 PYPKT00118 PYPKT00118 —PPE 03- PPE 03 -18 -2012 200.69 81,429.46 04101/2012 PYPKT00120 PYPKT00120 —PPE 04 PPE 04-01 -2012 172.05 81,601.51 315 -6015 -5125 Auto Allowance Post Date Packet Number Transaction Number Description Vendor Project Account Amount Running Balance 0112212012 PYPKT00090 PYPKTOOD90 —PPE 01- PPE 01 -22 -2012 700.00 6,500.00 04/30/2012 GLPKT01281 0412 -047 Corr Car Allow - Success Ag. - s /ba 5125 3,510.00 10,010.00 315 - 6015 -5130 Cafeteria benefit Post Date Packet Number Transaction Number Description Vendor Project Account Amount Running Balance 01/04/2012 APPKT00393 JANUARY 2012RCDC LIFE, L-T, S-T, AD&D/JAN 2012 PRINCIPAL FINANCIAL GROUP 554.87 38,674.90 01/08/2012 PYPKT00082 PYPKT00082 —PPE 01- PPE 01-08-2012 1,608.00 40,282.90 01/22/2012 PYPKT00090 PYPKT00090 —PPE 01- PPE 01 -22 -2012 1,608.00 41,890.90 315- 6015 -5205 Legal Post Date Packet Number Transaction Number Description Vendor Project Account Amount Running Balance 01/04/2012 APPKT00398 152246 LEGAL FEES /NOV 2011 BURKE, WILLIAMS& 1,024.00 14,060.50 01/30/2012 APPKTOD439 155356 LEGAL SVC/DECEMBER 2011 BURKE, WILLIAMS & 901.50 14,962.00 04/04/2012 APPKT00556 154206 LEGAL SVC/JANUARY 2012 BURKE, WILLIAMS St SORENSEN, LLP 11478- 999 135.00 15,097.00 04/04/2012 APPKT00556 154206 /SA LEGAL SVC /JANUARY 2012 BURKE, WILLIAMS & SORENSEN, UP 11478 -999 7,296.50 22,393.50 04/11/2012 APPKT00573 154924 LEGAL SVC /FEB 2012 BURKE, WILLIAMS & SORENSEN, LLP 11478 -999 1,13030 23,524.00 05/09/2012 APPKT00623 155928 LEGAL SVC /MARCH 2012 BURKE, WILLIAMS &SORENSEN, LIP 11478 -999 3,148.00 26,672.00 06/06/2012 APPKT00664 156832/SA LEGAL SERVICE /APRIL 2012 BURKE, WILLIAMS & SORENSEN, LLP 11478 -999 4,070.00 30,742.00 06/30/2012 APPKT00730 157760 LEGAL SERVICE /MAY 2012 BURKE, WILLIAMS & SORENSEN, LLP 11478 -999 3,992.50 34,734.50 06/30/2012 APPKT00768 210403 LEGAL FEES URBAN FUTURES, INC 11478 - 999 5,200.00 39,93450 06/30/2011. A_fPKT00781 .. _ _ _ _ P.4 & 1.F 551ONALSE�ICE URBAN FUTURES, INC 11478-999 - " - 45,134.50 06/30/2012 APPKT00808 158008 LEGAL SERVICE /JUNE 2012 BURKE, WILLIAMS &SORENSEN, LLP 11478 -999 2,283.50 47,418.00 Account Name Beginning Balance Total Activity Ending Balance 315- 6015 -5215 Accounting & auditing - Continued Post Date Packet Number Transaction Number Description Vendor Project Account Amount Running Balance 01/26/2012 APPKT00432 34091 PROF SVC/AUDIT /2010 -11 ROGERS, ANDERSON, MALLODY & SCOTT LL 876.00 5,093.49 315 -6015 -5299 Other professional/ technical services Post Date Packet Number Transaction Number Description Vendor Project Account Amount Running Balance 01/18/2012 APPKT00419 1111 -026 PROF SVC /PASS THROUGH CALCULATIONS URBAN FUTURES, INC 877.50 8,687.50 01/26/2012 APPKT00432 17681 -IN PROF SVC/PROPERTY TAX HDL OGREN &CONE 3,150.00 11,837.50 04/11/2012 APPKT00573 17909 -IN PROF SVC /PROPERTY TAX HDL COREN &CONE 11478 -999 3,150.00 14,987.50 06/06/2012 APPKT00664 18122 -IN PROF SVC /4TH QTR PROP TAX HDL COREN & CONE 11478 -999 3,150.00 38,137.50 315- 6015 -5390 Equipment rental Post Date Packet Number Transaction Number Description Vendor Project Account Amount Running Balance 01/04/2012 APPKT00393 81243 FENCING /GLENDON 50 CAL SANITATION 11043- 999 291.78 2,042.46 315- 6015 -5599 Other purchased services Post Date Packet Number Transaction Number Description Vendor Project Account Amount Running Balance 01/31/2012 GLPKTOD806 0112-00017 Record sale of Glendon Hotel, closing costs, e 12,090.80 12,090.80 315 -6015 -5605 General supplies Post Date Packet Number Transaction Number Description Vendor Project Account Amount Running Balance 01/18/2012 APPKTOD419 01 -06- 2012RCDC UTILITY SVC/GLENDON CAL -AM WATER COMPANY C/O 11043 -999 117.83 227.99 01/31/2012 GLPKTO2075 0112-00024 A/R Edison Inv- Reimb Ut Glendon -pd Succ A 11043-999 (4,558.23) (4,330.24) 315- 6015 -5720 Community contributions Post Date Packet Number Transaction Number Description Vendor Project Account Amount Running Balance 01/18/2012 APPKT00419 3287/JAN 2012 CONTRACT SVC /JANUARY 2012 RSMD CHAMBER OF COMMERCE 4,000.00 24,000.00 315 -601` -5940 Other expenditures Post Date Packet Number Transaction Number Description Vendor Project Account Amount Running Balance 01/31/2012 GLPKT00806 0112 -00013 Misc fee- tan 2012 Pac West bank acct 2.00 1,874.88 Attachment c Project Number 11478 City of Rosemead, CA Expenses Account Key 11478 -999 GL Account Number 315 - 5230 -5930 315 - 5230 -5930 315- 6015 -5205 315- 6015 -5205 Project Number 405 -5230 -5255 405 -5230 -5255 315- 6015 -5205 315- 6015 -5299 101 - 1205 -5005 101 - 1305 -5005 101-4001 -5005 215 -1205 -5005 215- 1305 -5005 225- 1305 -5005 245 -1305 -5005 260. 1305.5005 315 -5230 -5255 405 -5230 -5255 315- 6015 -5205 101 -1205 -5005 101- 1305 -5005 215 -1205 -5005 225 -1305 -5005 245- 1305 -5005 260-1305 -5005 101 - 1115 -5005 101- 1205 -5005 101- 1305 -5005 215- 1205 -5005 225- 1305 -5005 245 -1305 -5005 260-1305 -5005 315 -5230 -5930 Project Name SUCCESSOR AGENCY Account Name Expenditure GL Account Name Interest expense Interest expense Legal Legal Group Programs Category 11000- Programs - 11000 - Programs Post Date Description 4/1/2012 Debt service - 4/1/12 - 2006 A 4/1/2012 Debt service - 4 /1 /12- Series B 4/4/2012 LEGAL SVC /JANUARY 2012 4/4/2012 LEGAL SVC /JANUARY 2012 Project Name Group Bank Fees 4/4/2012 Bank Fees 4/4/2012 Legal 4/11/2012 Other profess / technical s 4/11/2012 Regular full time 5 & W 4/29/2012 Salaries & wages 4/29/2012 Salaries & Wages 4/29/2012 Salaries & wages 4/29/2012 Salaries & wages 4/29/2012 Salaries & wages 4/29/2012 Salaries & wages 4/29/2012 Salaries & wages 4/29/2012 Bank fees 4/30/2012 Bank Fees 4/30/2012 Legal 5/9/2012 Regular full time 5 & W 5/13/2012 Salaries & wages 5/13/2012 Salaries & wages 5/13/2012 Salaries & wages 5/13/2012 Salaries & wages 5/13/2012 Salaries & wages 5/13/2012 Salaries & wages 5/27/2012 Regular full time S & W 5/27/2012 Salaries & wages 5/27/2012 Salaries & wages 5/27/2012 Salaries & wages 5/27/2012 Salaries & wages 5/27/2012 Salaries & wages 5/27/2012 Interest expense 6/1/2012 ADMIN FEES /20D6A ADMIN FEES /200613 LEGAL SVC /FEB 2012 PROF SVC /PROPERTY TAX PPE 04-29 -2012 PPE 04-29 -2012 PPE 04 -29 -2012 PPE 04-29 -2012 PPE 04 -29 -2012 PPE 04-29 -2012 PPE 04-29 -2012 PPE 04-29 -2012 Trf Fund 405 & Fund 415 entries to Fund 315 Trf Fund 405 & Fund 415 entries to Fund 315 LEGAL SVC/MARCH 2012 PPE 05 -13 -2012 PPE 05 -13 -2012 PPE 05-13 -2012 PPE 05 -13 -2012 PPE 05 -13 -2012 PPE 05 -13 -2012 PPE 05 -27 -12 PPE 05 -27 -12 PPE 05 -27 -12 PPE 05 -27 -12 PPE 05 -27 -12 PPE 05 -27 -12 PPE 05 -27 -12 Prin & Int payment -2010A -Jun 2012 Project Activity Report By Project Number Report Dates: 01/01/2012 - 06/30/2012 Type Status Operating Active Total Activity 1932584.75 Vendor Name Rem Number Activity 193,465.63 515,468.13 BURKE, WILLIAMS & SORENSEN, LL 154206 135.00 BURKE, WILLIAMS & SORENSEN, LL 154206SA 7,296.50 Type Status U.S. BANK - CORPORATE TRUST 3089676 1,007.00 U.S. BANK - CORPORATE TRUST 3046920 1,007.00 BURKE, WILLIAMS & SORENSEN, U. 154924 1,130.50 HDL COREN &CONE 17909 -IN 3,150.00 4,262.03 806.16 394.00 1,065.51 230.51 3.10 3.10 50.53 2,014.00 (2,014.00) BURKE, WILLIAMS & SORENSEN, LL 155928 3,148.00 291.93 33.66 72.97 3.10 3.10 4.42 226.50 1,226.07 99.08 306.51 6.20 6.20 8.85 231,896.88 420 - 00004040 AB 1290 Pass -Thru 6/1/2012 Tax increment recd 6/1/12 742,426.94 420 -5230 -5940 Other expenditures 6/1/2012 Tax Increment rec'd 6/1/12 6,959.85 315- 6015 -5205 Legal 6/6/2012 LEGAL SERVICE/APRIL 2012 BURKE, WILLIAMS & SORENSEN, LI 1 4,070.00 315- 6015 -5299 Other professional /technical s 6/6/2012 PROF SVC /4TH QTR PROP TAX HDL COREN & CONE 18122 -IN 3,150.00 101 -1205 -5005 Regular full time S & W 6/1012012 PPE O6-10 -2012 350.31 101- 1305 -5005 Salaries & wages 6/10/2012 PPE 06 -10 -2012 109.65 215 - 1205 -5005 Salaries & wages 6/10/2012 PPE 06- 10.2012 87.57 215- 1305 -5005 Salaries & wages 6/10/2012 PPE 06-10 -2012 16.47 260.1305 -5005 Salaries & wages 6/10/2012 PPE 06 -10 -2012 3.28 101 -1205 -5005 Regular full time S &W 6/24/2012 PPE 06-24 -2012 233.53 101 - 1305 -5005 Salaries & wages 6/24/2012 PPE 06 -24- 2012 46.11 215- 1205 -5005 Salaries & wages 6/24/2012 PPE 06-24 -2012 58.39 Project Number Project Name Group Type Status 215- 1305 -5005 Salaries & wages 6/24/2012 PPE 06-24 -2012 16.47 260 -1305 -5005 Salaries & wages 6/24/2012 PPE 06-24 -2012 3.28 255 -5215 -5960 Interfund transfers out 6/25/2012 LOW /MOD /FEB -JUNE 2012 ROSEMEAD HOUSING DEVELOPME FEB -JUNE 2012 191,172.90 101 - 1205 -5005 Regular full time S & W 6/30/2012 DUAL FISCAL YEAR PAYPERIOD 11 -12 & 12 -13 298.95 101- 1305 -5005 Salaries & wages 6/30/2012 DUAL FISCAL YEAR PAYPERIOD 11 -12 & 12 -13 17.93 215- 1205 -5005 Salaries & wages 6/30/2012 DUAL FISCAL YEAR PAYPERIOD 11 -12 & 12 -13 74.74 225- 1305 -5005 Salaries & wages 6/30/2012 DUAL FISCAL YEAR PAYPERIOD 11 -12 & 12 -13 1.55 245- 1305 -5005 Salaries & wages 6/30/2012 DUAL FISCAL YEAR PAYPERIOD 11 -12 & 12 -13 1.55 260 - 1305 -5005 Salaries & wages 6/30/2012 DUAL FISCAL YEAR PAYPERIOD 11 -12 & 12 -13 1.11 315- 6015 -5205 Legal 6/30/2012 LEGAL FEES URBAN FUTURES, INC 210403 5,200.00 315- 6015 -5205 Legal 6/30/2012 LEGAL SERVICE /JUNE 2012 BURKE, WILLIAMS &SORENSEN, LI. 15800 2,283.50 315- 6015 -5205 Legal 6/30/2012 LEGAL SERVICE /MAY 2012 BURKE, WILLIAMS & SORENSEN, U. 157760 3,992.50 315- 6015 -5205 Legal 6/30/2012 PROFESSIONAL SERVICE URBAN FUTURES, INC 210403 5,200.00 Total Expenses: 1932584.75 11478TOtal: - 1161639.43