Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Art3_Rialto_FY17_BikePed_CedarXing_Inv1_APPROVED_200827_GK
-1- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 RESOLUTION NO. 7250 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF RIALTO, CALIFORNIA, ACCEPTING SAN BERNARDINO COUNTY TRANSPORTATION AUTHORITY (SBCTA) TRANSPORTATION DEVELOPMENT ACT ARTICLE 3 GRANT FOR THE CONSTRUCTION OF THE CEDAR AVENUE SIDEWALK CONSTRUCTION AND RAILROAD CROSSING IMPROVEMENTS AND AMENDING THE FISCAL YEAR 2017- 2018 BUDGET AND CAPITAL IMPROVEMENT PROGRAM. WHEREAS, the budget for fiscal year 2017-2018 of the City of Rialto has been adopted by this Council in its original form, and said budget will need to be amended at times to fulfill the goals of the City; and WHEREAS, the City departments may not exceed their appropriations by character of expense, with character of expense being defined as personnel services, services and supplies, capital outlay, debt service and transfers, without the consent of the City Administrator; and WHEREAS, the City Administrator may transfer appropriations, between departments and within their respective funds, as long as those appropriations do not excee d their fund total unless approved by Council. WHEREAS, the City Council of the City of Rialto requires a five-year Capital Improvement Program (CIP), which is updated annually NOW, THEREFORE, THE CITY COUNCIL OF THE CITY OF RIALTO DOES HEREBY FIND, DETERMINE, AND RESOLVE AS FOLLOWS: Section 1: Accept the SBCTA Transportation Development Act Article 3 grant for the construction of the Cedar Avenue sidewalk construction and railroad crossing improvements. Section 2: Approve an increase in estimated revenues in the amount of $250,000 to the Grants TDA Article 3 Fund, Account Number 204-400-7326-7536-130808-30; and Section 3: Authorize the appropriation of $250,000 from Grants TDA Article 3 Fund, Account Number; 204-500-7326-3001-130808-22 for $250,000 for the construction of the DocuSign Envelope ID: A42D7DB8-8FBA-4086-ABFC-816742C6B46C -2- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Cedar Avenue sidewalk construction and Railroad Crossing improvements project expenditures; and Section 4: The City of Rialto hereby amends the 20 14-2018 Capital Improvement Program (CIP) to include the construction of the Cedar Avenue sidewalk construction and Railroad Crossing improvements project. \\\\ DocuSign Envelope ID: A42D7DB8-8FBA-4086-ABFC-816742C6B46C -3- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 PASSED APPROVED AND ADOPTED this 28th day of November, 2017. ______________________________ DEBORAH ROBERTSON, Mayor ATTEST: ______________________________ BARBARA McGEE, City Clerk APPROVED AS TO FORM: ______________________________ FRED GALANTE , City Attorney DocuSign Envelope ID: A42D7DB8-8FBA-4086-ABFC-816742C6B46C -4- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 STATE OF CALIFORNIA ) COUNTY OF SAN BERNARDINO ) ss CITY OF RIALTO ) I, Barbara McGee, City Clerk of the City of Rialto, do hereby certify that the foregoing Resolution No. 7250 was duly passed and adopted at a regular meeting of the City Council of the City of Rialto held on the 28th day of November, 2017. Upon motion of Council Member Scott, seconded by Council Member Baca Jr., the foregoing Resolution No. 7250 was duly passed and adopted. Vote on the motion: AYES: Mayor Robertson, Council Members: Scott, Baca Jr., Trujillo, Carrizales NOES: None ABSENT: None IN WITNESS WHEREOF, I have hereunto set my hand and the Official Seal of the City of Rialto this 12th day of December, 2017. ____________________________________ BARBARA McGEE, CITY CLERK DocuSign Envelope ID: A42D7DB8-8FBA-4086-ABFC-816742C6B46C SCRRA Estimate: PROJECT COST ESTIMATE Project Name: Design Level: Last Updated: ITEM QUANTITY UNIT COST TOTAL COST NOTES Emergency Notification Signage $500 Railroad Signal Modifications $205,000 Crossing Panel Addition and Replacement and Track Surfacing $210,000 SUB-TOTAL: CONSTRUCTION COSTS $415,500 % CONSTRUCTION CONTINGENCY DPM 10% $41,550 S&C DESIGN SUPPORT DURING CONST.DPM 2% $8,310 CONSTRUCTION MANAGEMENT DPM 4% $16,620 FLAGGING DPM 6% $24,930 AGENCY COSTS DPM 10% $41,550 MAINTENANCE OF WAY TRACK/STRUCT. MAINTENANCE SUPPORT S&C MAINTENANCE SUPPORT 5% $20,775 Includes PTC Coordination SUB-TOTAL: PROJECT RELATED OVERHEAD COSTS $153,735 PROJECT RESERVE 5%$7,687 $576,922 Final Design (100%) Cedar Ave Crossing Safety Improvement DESCRIPTION TOTAL PROJECT COST: 6/6/2018 1 of 3 SCRRA-METROLINK INVOICE DETAIL PROJECT NAME(s): RIALTO-PED XING & SIDEWLK PROJ PROJECT NUMBER(s): 860851 GRANT NAME(s): 130808, CITY OF RIALTO SCRRA AWD#(s): 992461 PA GL UNBILLED COST Thru Mar-20 UNBILLED COST FROM 03/28/2019 To 03/21/2020 Net to zero Grant Name(s)Values 130808, CITY OF RIALTO Type Project#Proj Name Employee/Vendor Invoice#PO#Task#Expenditure Type Expenditure Description Item Date Check#Qty Billable$Alloc %Total Cost Ref AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ BALFOUR BEATTY INFRASTRUCTURE, INC MS260A-16-033 MS260A-16-30 7.4 CONSTRUCTION - SIGNAL MS260A-16 -OCTOBER 2019 10/31/2019 248162 (blank)652.09 100.00%$652.09 1 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ BALFOUR BEATTY INFRASTRUCTURE, INC MS260A-16-034 MS260A-16-30 7.4 CONSTRUCTION - SIGNAL MS260A-16 -NOV 2019 11/30/2019 248655 (blank)23,283.54 100.00%$23,283.54 2 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ BALFOUR BEATTY INFRASTRUCTURE, INC MS260A-16-035 MS260A-16-30 7.4 CONSTRUCTION - SIGNAL MS260A-16 DEC 2019 12/29/2019 249176 (blank)31,868.45 100.00%$31,868.45 3 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ BALFOUR BEATTY INFRASTRUCTURE, INC MS260A-16-031 MS260A-16-30 7.4 CONSTRUCTION - SIGNAL MS260A-16 07/29/2019-09/01/2019 9/1/2019 247203 (blank)45,322.89 100.00%$45,322.89 4 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ BALFOUR BEATTY INFRASTRUCTURE, INC MS260A-16-032 MS260A-16-30 7.4 CONSTRUCTION - SIGNAL MS260A-16 -SEP 2019 9/29/2019 247688 (blank)46,072.76 100.00%$46,072.76 5 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ FASTENAL COMPANY CARAC64746 PO405-19-015 7.4 MATL PROCUREMENT - SIGNAL PO405-19-015 -CUST#CARAC1761 4/5/2019 249433 (blank)243.59 100.00%$243.59 6 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ GRAYBAR ELECTRIC CO., INC.9309797578 PO511-19-052 7.4 MATL PROCUREMENT - SIGNAL PO511-19-052 ACC# 282184 367532256 4/25/2019 246190 (blank)162.50 100.00%$162.50 7 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ MASS ELECTRIC CORP.MS222-09R-119 MS222-09R-19-20 7.4 MAINTENANCE SUPPORT MS222-09R - 9/30/2019 - 10/27/2019 10/27/2019 248573 (blank)787.20 100.00%$787.20 8 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ PACIFIC RAILWAY ENTERPRISES, INC.2019518 E742A-16-039 7.4 DESIGN - SIGNAL E742A-16 - NOVEMBER 2019 11/30/2019 248712 (blank)76.74 100.00%$76.74 9 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ PACIFIC RAILWAY ENTERPRISES, INC.2019518 E742A-16-071 7.4 CONSTRUCTION MANAGEMENT E742A-16 - NOVEMBER 2019 11/30/2019 248712 (blank)3,746.15 100.00%$3,746.15 10 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ PACIFIC RAILWAY ENTERPRISES, INC.2019440 E742A-16-071 7.4 CONSTRUCTION MANAGEMENT E742A-16 - SEPTEMBER 2019 9/28/2019 247626 (blank)4,591.32 100.00%$4,591.32 11 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ PACIFIC RAILWAY ENTERPRISES, INC.2019401 E742A-16-071 7.4 CONSTRUCTION MANAGEMENT E742A-16 - 7/28/2019 - 8/31/2019 8/31/2019 247168 (blank)5,487.00 100.00%$5,487.00 12 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ PACIFIC RAILWAY ENTERPRISES, INC.2020163 E742A-16-071 7.4 CONSTRUCTION MANAGEMENT E742A-16 - 12/29/2020 - 2/1/2020 1/31/2020 249687 (blank)8,917.35 100.00%$8,917.35 13 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ PACIFIC RAILWAY ENTERPRISES, INC.2020124 E742A-16-071 7.4 CONSTRUCTION MANAGEMENT E742A-16 - 12/1/2019 - 12/28/2019 12/28/2019 249236 (blank)4,350.30 100.00%$4,350.30 14 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ PACIFIC RAILWAY ENTERPRISES, INC.2020209 E742A-16-071 7.4 CONSTRUCTION MANAGEMENT E742A-16 - 2/2/2020 - 2/29/2020 2/29/2020 249900 (blank)6,048.06 100.00%$6,048.06 15 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ PACIFIC RAILWAY ENTERPRISES, INC.2019481 E742A-16-071 7.4 CONSTRUCTION MANAGEMENT E742A-16 - 9/29/2019 - 10/26/2019 10/26/2019 248204 (blank)55.61 100.00%$55.61 16 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ SAF-T-CO SUPPLY 544997-00 MTL2003258 7.4 MATL PROCUREMENT - SIGNAL 011741 - MTL2003258 8/26/2019 246866 (blank)1,130.94 100.00%$1,130.94 17 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ SCRRA A/R CUSTOMERS AP2008-011 INVENTORY ISSUANCES AUG 19 (blank)7.4 MATL PROCUREMENT - SIGNAL AP2008-011 - TO RECORD INVENTORY ISSUANCES FOR AUG 19 8/31/2019 99003481 (blank)2,417.95 100.00%$2,417.95 18 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ SCRRA A/R CUSTOMERS AP2002-019 INVENTORY ISSUANCES FEB 2020 (blank)7.4 MATL PROCUREMENT - SIGNAL AP2002-019 - TO RECORD INVENTORY ISSUANCES FOR FEB 20 2/29/2020 (blank)(blank)5,362.12 100.00%$5,362.12 19 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ SCRRA A/R CUSTOMERS AP2010-021 INVENTORY ISSUANCES OCT 19 (blank)7.4 MATL PROCUREMENT - SIGNAL AP2010-021 10/31/2019 99003481 (blank)6,138.31 52.82%$11,620.29 20 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ SCRRA A/R CUSTOMERS AP2009-019 INVENTORY ISSUANCES SEP 19 (blank)7.4 MATL PROCUREMENT - SIGNAL AP2009-019 - TO RECORD INVENTORY ISSUANCES FOR SEP 19 9/30/2019 99003481 (blank)1,288.24 100.00%$1,288.24 21 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ SCRRA A/R CUSTOMERS AP2011-022 INVENTORY ISSUANCES NOV 19 (blank)7.4 MATL PROCUREMENT - SIGNAL AP2011-022 11/30/2019 (blank)(blank)2,934.21 100.00%$2,934.21 22 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ SIEMENS MOBILITY, INC.5610162588 PO368-19X 7.4 MATL PROCUREMENT - SIGNAL 30536186 - PO368-19X-29 PO UNIT PRICE 3/28/2019 246890 (blank)134.63 100.00%$134.63 23 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ SIEMENS MOBILITY, INC.5610198132 PO368-20X 7.4 MATL PROCUREMENT - SIGNAL 30536186 - PO368-20X-7 11/21/2019 248217 (blank)26,568.75 91.49%$29,038.86 24 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ SIEMENS MOBILITY, INC.5610172850 PO368-19X 7.4 MATL PROCUREMENT - SIGNAL 30536186 - PO368-19X-29 6/7/2019 246890 (blank)9,663.95 100.00%$9,663.95 25 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ SIEMENS MOBILITY, INC.5610162590 PO368-19X 7.4 MATL PROCUREMENT - SIGNAL PO368-19X-29 -3/28/2019 246890 (blank)392.83 100.00%$392.83 26 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ STATE BOARD OF EQUALIZATION FY20-QTR1 (blank)7.4 MATL PROCUREMENT - SIGNAL WIRE- USE TAX FOR THE QUARTER ENDED SEP 2019 10/7/2019 54200776 (blank)15.00 100.00%$15.00 27 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ TRANSDEV RAIL, INC. (VTMI)0125 MS214-09-18-19 7.1 MAINTENANCE SUPPORT MS214-09-18-19 - MAY 2019 MOW & STRUCTURE SERVICES 5/31/2019 93056250 (blank)17,425.76 100.00%$17,425.76 28 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ TRANSDEV RAIL, INC. (VTMI)FY19 ACCR - 0126 (blank)7.1 MAINTENANCE SUPPORT AP1906-045 FY2019 Expense Accruals 6/30/2019 (blank)(blank)0.00 #DIV/0!$0.00 n/a AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ TRANSDEV RAIL, INC. (VTMI)FY19 ACCRUAL - 0126 (blank)7.1 MAINTENANCE SUPPORT AP1906-050 FY2019 Expense Accruals 6/30/2019 99003384 (blank)0.00 #DIV/0!$0.00 n/a AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ TRANSDEV RAIL, INC. (VTMI)0124 MS214-09-18-19 7.1 MAINTENANCE SUPPORT MS214-09-18-19 - APRIL 2019 MOW & STRUCTURE SERVICES 4/28/2019 93055315 (blank)26,478.69 100.00%$26,478.69 29 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ TRANSDEV RAIL, INC. (VTMI)0126 MS214-09-18-19 7.1 MAINTENANCE SUPPORT MS214-09-18-19 - JUNE 2019 MOW & STRUCTURE SERVICES 6/30/2019 93056232 (blank)276.38 100.00%$276.38 30 AP Invoice 860851 RIALTO-PED XING & SIDEWLK PROJ WESTERN CULLEN HAYES RSI049955 PO346-20 7.4 MATL PROCUREMENT - SIGNAL PO346-20-2 - RSO109737 8/21/2019 246650 (blank)283.80 100.00%$283.80 31 AP Invoice Total $282,177.11 97.26%$290,129.20 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED FRINGE BENEFITS 08/10/2019 FRINGE BENEFIT 34.89%8/10/2019 (blank)3.5 149.70 100.00%$149.70 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED FRINGE BENEFITS 08/10/2019 FRINGE BENEFIT 34.89%8/10/2019 (blank)-3.5 (74.85)100.00%($74.85) Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED FRINGE BENEFITS 09/07/2019 FRINGE BENEFIT 34.89%9/7/2019 (blank)0.5 11.25 100.00%$11.25 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED FRINGE BENEFITS 09/21/2019 FRINGE BENEFIT 34.89%9/21/2019 (blank)2 45.02 100.00%$45.02 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED FRINGE BENEFITS 12/14/2019 FRINGE BENEFIT 34.89%12/14/2019 (blank)9 202.59 100.00%$202.59 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED FRINGE BENEFITS 02/08/2020 FRINGE BENEFIT 34.89%2/8/2020 (blank)3.5 78.78 100.00%$78.78 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED FRINGE BENEFITS 10/05/2019 FRINGE BENEFIT 34.89%10/5/2019 (blank)2 45.02 100.00%$45.02 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED FRINGE BENEFITS 01/11/2020 FRINGE BENEFIT 34.89%1/11/2020 (blank)2 45.02 100.00%$45.02 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED FRINGE BENEFITS 11/02/2019 FRINGE BENEFIT 34.89%11/2/2019 (blank)1.5 33.76 100.00%$33.76 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED FRINGE BENEFITS 07/13/2019 FRINGE BENEFIT 34.89%7/13/2019 (blank)2.5 53.47 100.00%$53.47 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED FRINGE BENEFITS 11/30/2019 FRINGE BENEFIT 34.89%11/30/2019 (blank)7 157.57 100.00%$157.57 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED FRINGE BENEFITS 03/07/2020 FRINGE BENEFIT 34.89%3/7/2020 (blank)18.5 416.43 100.00%$416.43 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED FRINGE BENEFITS 10/19/2019 FRINGE BENEFIT 34.89%10/19/2019 (blank)0.5 11.25 100.00%$11.25 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED FRINGE BENEFITS 11/16/2019 FRINGE BENEFIT 34.89%11/16/2019 (blank)12.5 281.37 100.00%$281.37 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED FRINGE BENEFITS 07/27/2019 FRINGE BENEFIT 34.89%7/27/2019 (blank)6.5 139.01 100.00%$139.01 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED FRINGE BENEFITS 12/28/2019 FRINGE BENEFIT 34.89%12/28/2019 (blank)1 22.51 100.00%$22.51 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED FRINGE BENEFITS 03/21/2020 FRINGE BENEFIT 34.89%3/21/2020 (blank)6 135.06 100.00%$135.06 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED FRINGE BENEFITS 01/25/2020 FRINGE BENEFIT 34.89%1/25/2020 (blank)2.5 56.27 100.00%$56.27 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED FRINGE BENEFITS 02/22/2020 FRINGE BENEFIT 34.89%2/22/2020 (blank)2.5 56.27 100.00%$56.27 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 SCRRA WAGES & SALARIES 07/13/2019 PAYROLL ALLOCATION 7/13/2019 (blank)2.5 153.24 100.00%$153.24 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 SCRRA WAGES & SALARIES 07/27/2019 PAYROLL ALLOCATION 7/27/2019 (blank)6.5 398.43 100.00%$398.43 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 SCRRA WAGES & SALARIES 10/05/2019 PAYROLL ALLOCATION 10/5/2019 (blank)2 129.03 100.00%$129.03 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 SCRRA WAGES & SALARIES 12/28/2019 PAYROLL ALLOCATION 12/28/2019 (blank)1 64.51 100.00%$64.51 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 SCRRA WAGES & SALARIES 02/22/2020 PAYROLL ALLOCATION 2/22/2020 (blank)2.5 161.29 100.00%$161.29 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 SCRRA WAGES & SALARIES 03/07/2020 PAYROLL ALLOCATION 3/7/2020 (blank)18.5 1,193.55 100.00%$1,193.55 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 SCRRA WAGES & SALARIES 08/10/2019 PAYROLL ALLOCATION 8/10/2019 (blank)3.5 429.08 100.00%$429.08 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 SCRRA WAGES & SALARIES 08/10/2019 PAYROLL ALLOCATION 8/10/2019 (blank)-3.5 (214.54)100.00%($214.54) Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 SCRRA WAGES & SALARIES 11/02/2019 PAYROLL ALLOCATION 11/2/2019 (blank)1.5 96.77 100.00%$96.77 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 SCRRA WAGES & SALARIES 01/11/2020 PAYROLL ALLOCATION 1/11/2020 (blank)2 129.03 100.00%$129.03 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 SCRRA WAGES & SALARIES 10/19/2019 PAYROLL ALLOCATION 10/19/2019 (blank)0.5 32.25 100.00%$32.25 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 SCRRA WAGES & SALARIES 11/16/2019 PAYROLL ALLOCATION 11/16/2019 (blank)12.5 806.45 100.00%$806.45 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 SCRRA WAGES & SALARIES 02/08/2020 PAYROLL ALLOCATION 2/8/2020 (blank)3.5 225.80 100.00%$225.80 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 SCRRA WAGES & SALARIES 11/30/2019 PAYROLL ALLOCATION 11/30/2019 (blank)7 451.61 100.00%$451.61 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 SCRRA WAGES & SALARIES 12/14/2019 PAYROLL ALLOCATION 12/14/2019 (blank)9 580.64 100.00%$580.64 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 SCRRA WAGES & SALARIES 01/25/2020 PAYROLL ALLOCATION 1/25/2020 (blank)2.5 161.29 100.00%$161.29 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 SCRRA WAGES & SALARIES 09/07/2019 PAYROLL ALLOCATION 9/7/2019 (blank)0.5 32.25 100.00%$32.25 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 SCRRA WAGES & SALARIES 03/21/2020 PAYROLL ALLOCATION 3/21/2020 (blank)6 387.09 100.00%$387.09 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 SCRRA WAGES & SALARIES 09/21/2019 PAYROLL ALLOCATION 9/21/2019 (blank)2 129.03 100.00%$129.03 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 07/27/2019 PTO ACCRUAL ALLOCATION 22.87%7/27/2019 (blank)6.5 91.12 100.00%$91.12 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 10/05/2019 PTO ACCRUAL ALLOCATION 22.87%10/5/2019 (blank)2 29.51 100.00%$29.51 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 02/22/2020 PTO ACCRUAL ALLOCATION 22.87%2/22/2020 (blank)2.5 36.89 100.00%$36.89 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 03/07/2020 PTO ACCRUAL ALLOCATION 22.87%3/7/2020 (blank)18.5 272.96 100.00%$272.96 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 08/10/2019 PTO ACCRUAL ALLOCATION 22.87%8/10/2019 (blank)3.5 98.14 100.00%$98.14 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 08/10/2019 PTO ACCRUAL ALLOCATION 22.87%8/10/2019 (blank)-3.5 (49.07)100.00%($49.07) Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 11/16/2019 PTO ACCRUAL ALLOCATION 22.87%11/16/2019 (blank)12.5 184.44 100.00%$184.44 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 01/25/2020 PTO ACCRUAL ALLOCATION 22.87%1/25/2020 (blank)2.5 36.89 100.00%$36.89 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 02/08/2020 PTO ACCRUAL ALLOCATION 22.87%2/8/2020 (blank)3.5 51.64 100.00%$51.64 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 01/11/2020 PTO ACCRUAL ALLOCATION 22.87%1/11/2020 (blank)2 29.51 100.00%$29.51 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 09/21/2019 PTO ACCRUAL ALLOCATION 22.87%9/21/2019 (blank)2 29.51 100.00%$29.51 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 10/19/2019 PTO ACCRUAL ALLOCATION 22.87%10/19/2019 (blank)0.5 7.38 100.00%$7.38 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 12/28/2019 PTO ACCRUAL ALLOCATION 22.87%12/28/2019 (blank)1 14.75 100.00%$14.75 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 11/02/2019 PTO ACCRUAL ALLOCATION 22.87%11/2/2019 (blank)1.5 22.13 100.00%$22.13 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 11/30/2019 PTO ACCRUAL ALLOCATION 22.87%11/30/2019 (blank)7 103.28 100.00%$103.28 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 12/14/2019 PTO ACCRUAL ALLOCATION 22.87%12/14/2019 (blank)9 132.79 100.00%$132.79 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 03/21/2020 PTO ACCRUAL ALLOCATION 22.87%3/21/2020 (blank)6 88.53 100.00%$88.53 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 07/13/2019 PTO ACCRUAL ALLOCATION 22.87%7/13/2019 (blank)2.5 35.05 100.00%$35.05 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 09/07/2019 PTO ACCRUAL ALLOCATION 22.87%9/7/2019 (blank)0.5 7.38 100.00%$7.38 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ COUSART, M (blank)(blank)8 ALLOCATED FRINGE BENEFITS 08/24/2019 FRINGE BENEFIT 34.89%8/24/2019 (blank)1 14.22 100.00%$14.22 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ COUSART, M (blank)(blank)8 SCRRA WAGES & SALARIES 08/24/2019 PAYROLL ALLOCATION 8/24/2019 (blank)1 40.75 100.00%$40.75 T:\Third Party Agreements\Project Reconciliations\860851 - City of Rialto Cedar Ped Xing\860851 Inv#TBD $300,241.80 03-31-2020 Award 992461\860851 Inv#TBD $300,241.80 03-31-2020 Award 992461\Billing Template 2 of 3 SCRRA-METROLINK INVOICE DETAIL PROJECT NAME(s): RIALTO-PED XING & SIDEWLK PROJ PROJECT NUMBER(s): 860851 GRANT NAME(s): 130808, CITY OF RIALTO SCRRA AWD#(s): 992461 PA GL UNBILLED COST Thru Mar-20 UNBILLED COST FROM 03/28/2019 To 03/21/2020 Net to zero Grant Name(s)Values 130808, CITY OF RIALTO Type Project#Proj Name Employee/Vendor Invoice#PO#Task#Expenditure Type Expenditure Description Item Date Check#Qty Billable$Alloc %Total Cost Ref Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ COUSART, M (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 08/24/2019 PTO ACCRUAL ALLOCATION 22.87%8/24/2019 (blank)1 9.32 100.00%$9.32 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ FERNANDEZ, KELLY (blank)(blank)8 ALLOCATED FRINGE BENEFITS 07/27/2019 FRINGE BENEFIT 34.89%7/27/2019 (blank)1 20.51 100.00%$20.51 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ FERNANDEZ, KELLY (blank)(blank)8 SCRRA WAGES & SALARIES 07/27/2019 PAYROLL ALLOCATION 7/27/2019 (blank)1 58.78 100.00%$58.78 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ FERNANDEZ, KELLY (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 07/27/2019 PTO ACCRUAL ALLOCATION 22.87%7/27/2019 (blank)1 13.44 100.00%$13.44 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ FREEMAN, ANITA (blank)(blank)8 ALLOCATED FRINGE BENEFITS 08/24/2019 FRINGE BENEFIT 34.89%8/24/2019 (blank)0.25 4.19 100.00%$4.19 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ FREEMAN, ANITA (blank)(blank)8 ALLOCATED FRINGE BENEFITS 07/13/2019 FRINGE BENEFIT 34.89%7/13/2019 (blank)0.5 7.90 100.00%$7.90 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ FREEMAN, ANITA (blank)(blank)8 ALLOCATED FRINGE BENEFITS 10/19/2019 FRINGE BENEFIT 34.89%10/19/2019 (blank)0.25 4.40 100.00%$4.40 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ FREEMAN, ANITA (blank)(blank)8 SCRRA WAGES & SALARIES 07/13/2019 PAYROLL ALLOCATION 7/13/2019 (blank)0.5 22.64 100.00%$22.64 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ FREEMAN, ANITA (blank)(blank)8 SCRRA WAGES & SALARIES 08/24/2019 PAYROLL ALLOCATION 8/24/2019 (blank)0.25 12.01 100.00%$12.01 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ FREEMAN, ANITA (blank)(blank)8 SCRRA WAGES & SALARIES 10/19/2019 PAYROLL ALLOCATION 10/19/2019 (blank)0.25 12.60 100.00%$12.60 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ FREEMAN, ANITA (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 08/24/2019 PTO ACCRUAL ALLOCATION 22.87%8/24/2019 (blank)0.25 2.75 100.00%$2.75 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ FREEMAN, ANITA (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 10/19/2019 PTO ACCRUAL ALLOCATION 22.87%10/19/2019 (blank)0.25 2.88 100.00%$2.88 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ FREEMAN, ANITA (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 07/13/2019 PTO ACCRUAL ALLOCATION 22.87%7/13/2019 (blank)0.5 5.18 100.00%$5.18 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ NAVARRO, JOEL (blank)(blank)8 OVERTIME PAY PREMIUM 07/27/2019 PAYROLL ALLOCATION 7/27/2019 (blank)2 91.64 100.00%$91.64 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ SANCHEZ, VENUS (blank)(blank)8 ALLOCATED FRINGE BENEFITS 02/08/2020 FRINGE BENEFIT 34.89%2/8/2020 (blank)1 18.14 100.00%$18.14 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ SANCHEZ, VENUS (blank)(blank)8 ALLOCATED FRINGE BENEFITS 10/05/2019 FRINGE BENEFIT 34.89%10/5/2019 (blank)1 18.14 100.00%$18.14 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ SANCHEZ, VENUS (blank)(blank)8 ALLOCATED FRINGE BENEFITS 01/11/2020 FRINGE BENEFIT 34.89%1/11/2020 (blank)2 36.28 100.00%$36.28 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ SANCHEZ, VENUS (blank)(blank)8 ALLOCATED FRINGE BENEFITS 11/02/2019 FRINGE BENEFIT 34.89%11/2/2019 (blank)0.5 9.07 100.00%$9.07 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ SANCHEZ, VENUS (blank)(blank)8 SCRRA WAGES & SALARIES 10/05/2019 PAYROLL ALLOCATION 10/5/2019 (blank)1 51.98 100.00%$51.98 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ SANCHEZ, VENUS (blank)(blank)8 SCRRA WAGES & SALARIES 11/02/2019 PAYROLL ALLOCATION 11/2/2019 (blank)0.5 25.99 100.00%$25.99 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ SANCHEZ, VENUS (blank)(blank)8 SCRRA WAGES & SALARIES 01/11/2020 PAYROLL ALLOCATION 1/11/2020 (blank)2 103.97 100.00%$103.97 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ SANCHEZ, VENUS (blank)(blank)8 SCRRA WAGES & SALARIES 02/08/2020 PAYROLL ALLOCATION 2/8/2020 (blank)1 51.98 100.00%$51.98 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ SANCHEZ, VENUS (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 10/05/2019 PTO ACCRUAL ALLOCATION 22.87%10/5/2019 (blank)1 11.89 100.00%$11.89 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ SANCHEZ, VENUS (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 02/08/2020 PTO ACCRUAL ALLOCATION 22.87%2/8/2020 (blank)1 11.89 100.00%$11.89 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ SANCHEZ, VENUS (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 01/11/2020 PTO ACCRUAL ALLOCATION 22.87%1/11/2020 (blank)2 23.78 100.00%$23.78 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ SANCHEZ, VENUS (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 11/02/2019 PTO ACCRUAL ALLOCATION 22.87%11/2/2019 (blank)0.5 5.94 100.00%$5.94 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ WILLIAMS, MARY LOU (blank)(blank)8 ALLOCATED FRINGE BENEFITS 10/19/2019 FRINGE BENEFIT 34.89%10/19/2019 (blank)1 27.32 100.00%$27.32 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ WILLIAMS, MARY LOU (blank)(blank)8 SCRRA WAGES & SALARIES 10/19/2019 PAYROLL ALLOCATION 10/19/2019 (blank)1 78.31 100.00%$78.31 Agency Cost 860851 RIALTO-PED XING & SIDEWLK PROJ WILLIAMS, MARY LOU (blank)(blank)8 ALLOCATED PAID TIME ACCRUAL 10/19/2019 PTO ACCRUAL ALLOCATION 22.87%10/19/2019 (blank)1 17.91 100.00%$17.91 Agency Cost Total $9,250.93 100.00%$9,250.93 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)99 ALLOCATED OVERHEAD 07/27/2019 INDIRECT COST ALLOC @ 149.45% (TPA)7/27/2019 (blank)6.5 595.45 100.00%$595.45 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)99 ALLOCATED OVERHEAD 08/10/2019 INDIRECT COST ALLOC @ 149.45% (TPA)8/10/2019 (blank)3.5 641.26 100.00%$641.26 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)99 ALLOCATED OVERHEAD 08/10/2019 INDIRECT COST ALLOC @ 149.45% (TPA)8/10/2019 (blank)-3.5 (320.63)100.00%($320.63) Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)99 ALLOCATED OVERHEAD 09/07/2019 INDIRECT COST ALLOC @ 149.45% (TPA)9/7/2019 (blank)0.5 48.20 100.00%$48.20 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)99 ALLOCATED OVERHEAD 10/19/2019 INDIRECT COST ALLOC @ 149.45% (TPA)10/19/2019 (blank)0.5 48.20 100.00%$48.20 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)99 ALLOCATED OVERHEAD 11/02/2019 INDIRECT COST ALLOC @ 149.45% (TPA)11/2/2019 (blank)1.5 144.62 100.00%$144.62 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)99 ALLOCATED OVERHEAD 11/16/2019 INDIRECT COST ALLOC @ 149.45% (TPA)11/16/2019 (blank)12.5 1,205.24 100.00%$1,205.24 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)99 ALLOCATED OVERHEAD 01/25/2020 INDIRECT COST ALLOC @ 149.45% (TPA)1/25/2020 (blank)2.5 241.05 100.00%$241.05 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)99 ALLOCATED OVERHEAD 02/22/2020 INDIRECT COST ALLOC @ 149.45% (TPA)2/22/2020 (blank)2.5 241.05 100.00%$241.05 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)99 ALLOCATED OVERHEAD 03/21/2020 INDIRECT COST ALLOC @ 149.45% (TPA)3/21/2020 (blank)6 578.51 100.00%$578.51 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)99 ALLOCATED OVERHEAD 07/13/2019 INDIRECT COST ALLOC @ 149.45% (TPA)7/13/2019 (blank)2.5 229.02 100.00%$229.02 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)99 ALLOCATED OVERHEAD 09/21/2019 INDIRECT COST ALLOC @ 149.45% (TPA)9/21/2019 (blank)2 192.84 100.00%$192.84 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)99 ALLOCATED OVERHEAD 02/08/2020 INDIRECT COST ALLOC @ 149.45% (TPA)2/8/2020 (blank)3.5 337.46 100.00%$337.46 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)99 ALLOCATED OVERHEAD 10/05/2019 INDIRECT COST ALLOC @ 149.45% (TPA)10/5/2019 (blank)2 192.84 100.00%$192.84 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)99 ALLOCATED OVERHEAD 12/28/2019 INDIRECT COST ALLOC @ 149.45% (TPA)12/28/2019 (blank)1 96.41 100.00%$96.41 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)99 ALLOCATED OVERHEAD 01/11/2020 INDIRECT COST ALLOC @ 149.45% (TPA)1/11/2020 (blank)2 192.84 100.00%$192.84 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)99 ALLOCATED OVERHEAD 03/07/2020 INDIRECT COST ALLOC @ 149.45% (TPA)3/7/2020 (blank)18.5 1,783.76 100.00%$1,783.76 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)99 ALLOCATED OVERHEAD 11/30/2019 INDIRECT COST ALLOC @ 149.45% (TPA)11/30/2019 (blank)7 674.93 100.00%$674.93 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ BRANDT, MARIA (blank)(blank)99 ALLOCATED OVERHEAD 12/14/2019 INDIRECT COST ALLOC @ 149.45% (TPA)12/14/2019 (blank)9 867.77 100.00%$867.77 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ COUSART, M (blank)(blank)99 ALLOCATED OVERHEAD 08/24/2019 INDIRECT COST ALLOC @ 149.45% (TPA)8/24/2019 (blank)1 60.90 100.00%$60.90 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ FERNANDEZ, KELLY (blank)(blank)99 ALLOCATED OVERHEAD 07/27/2019 INDIRECT COST ALLOC @ 149.45% (TPA)7/27/2019 (blank)1 87.85 100.00%$87.85 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ FREEMAN, ANITA (blank)(blank)99 ALLOCATED OVERHEAD 10/19/2019 INDIRECT COST ALLOC @ 149.45% (TPA)10/19/2019 (blank)0.25 18.83 100.00%$18.83 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ FREEMAN, ANITA (blank)(blank)99 ALLOCATED OVERHEAD 08/24/2019 INDIRECT COST ALLOC @ 149.45% (TPA)8/24/2019 (blank)0.25 17.95 100.00%$17.95 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ FREEMAN, ANITA (blank)(blank)99 ALLOCATED OVERHEAD 07/13/2019 INDIRECT COST ALLOC @ 149.45% (TPA)7/13/2019 (blank)0.5 33.84 100.00%$33.84 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ NAVARRO, JOEL (blank)(blank)99 ALLOCATED OVERHEAD 07/27/2019 INDIRECT COST ALLOC @ 149.45% (TPA)7/27/2019 (blank)2 136.96 100.00%$136.96 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ SANCHEZ, VENUS (blank)(blank)99 ALLOCATED OVERHEAD 11/02/2019 INDIRECT COST ALLOC @ 149.45% (TPA)11/2/2019 (blank)0.5 38.84 100.00%$38.84 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ SANCHEZ, VENUS (blank)(blank)99 ALLOCATED OVERHEAD 02/08/2020 INDIRECT COST ALLOC @ 149.45% (TPA)2/8/2020 (blank)1 77.68 100.00%$77.68 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ SANCHEZ, VENUS (blank)(blank)99 ALLOCATED OVERHEAD 10/05/2019 INDIRECT COST ALLOC @ 149.45% (TPA)10/5/2019 (blank)1 77.68 100.00%$77.68 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ SANCHEZ, VENUS (blank)(blank)99 ALLOCATED OVERHEAD 01/11/2020 INDIRECT COST ALLOC @ 149.45% (TPA)1/11/2020 (blank)2 155.38 100.00%$155.38 Overhead 860851 RIALTO-PED XING & SIDEWLK PROJ WILLIAMS, MARY LOU (blank)(blank)99 ALLOCATED OVERHEAD 10/19/2019 INDIRECT COST ALLOC @ 149.45% (TPA)10/19/2019 (blank)1 117.03 100.00%$117.03 Overhead Total $8,813.76 100.00%$8,813.76 Total $300,241.80 97.42%$308,193.89 T:\Third Party Agreements\Project Reconciliations\860851 - City of Rialto Cedar Ped Xing\860851 Inv#TBD $300,241.80 03-31-2020 Award 992461\860851 Inv#TBD $300,241.80 03-31-2020 Award 992461\Billing Template 3 of 3 SCRRA-METROLINK INVOICE DETAIL PROJECT NAME(s): RIALTO-PED XING & SIDEWLK PROJ PROJECT NUMBER(s): 860851 GRANT NAME(s): 130808, CITY OF RIALTO SCRRA AWD#(s): 992461 PA GL UNBILLED COST Thru Mar-20 UNBILLED COST FROM 03/28/2019 To 03/21/2020 Net to zero Grant Name(s)Values 130808, CITY OF RIALTO Type Project#Proj Name Employee/Vendor Invoice#PO#Task#Expenditure Type Expenditure Description Item Date Check#Qty Billable$Alloc %Total Cost Ref RECEIPTS (With Remaining Balance) SCRRA REF#Check/Wire REF DATE Receipt$Invoiced$Balance$ 902752 197415-112417 11/24/2017 ($96,275.47)($96,275.47) 1005305 9/25/2018 $23,646.41 ($72,629.06) 903928 203649-122018 12/20/2018 ($576,922.00)($649,551.06) 1006453 8/8/2019 $38,437.40 ($611,113.66) this invoice $300,241.80 ($310,871.86) ($310,871.86) ($310,871.86) ($310,871.86) SUBTOTAL RECEIPTS:($673,197.47)$362,325.61 ($310,871.86) T:\Third Party Agreements\Project Reconciliations\860851 - City of Rialto Cedar Ped Xing\860851 Inv#TBD $300,241.80 03-31-2020 Award 992461\860851 Inv#TBD $300,241.80 03-31-2020 Award 992461\Billing Template Acct #Project Phase Phase Title Project Title Description Period Doc Date Tran_Type Amount 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-1050 OCT-DEC 2015 6 12/31/2015 GJ -11.37 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-1050 OCT-DEC 2015 6 12/31/2015 GJ -0.46 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-1050 OCT-DEC 2015 6 12/31/2015 GJ 0.46 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-1050 OCT-DEC 2015 6 12/31/2015 GJ 11.37 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 11 5/14/2016 LD 25.61 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 11 5/14/2016 LD 1.32 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 11 5/14/2016 LD 1.01 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Wages 11 5/14/2016 LD 86.7 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 11 5/28/2016 LD 29.87 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 11 5/28/2016 LD 1.54 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 11 5/28/2016 LD 1.17 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Wages 11 5/28/2016 LD 101.14 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 12 6/11/2016 LD 169.62 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 12 6/11/2016 LD 8.73 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 12 6/11/2016 LD 7.44 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Wages 12 6/11/2016 LD 574.52 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-1050-APR-JUN 2016 12 6/30/2016 GJ -225.1 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-1050-APR-JUN 2016 12 6/30/2016 GJ -9.62 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-1050-APR-JUN 2016 12 6/30/2016 GJ 9.62 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-1050-APR-JUN 2016 12 6/30/2016 GJ 225.1 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 6 12/23/2017 LD 45.06 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 6 12/23/2017 LD 5.95 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 6 12/23/2017 LD 6.21 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Wages 6 12/23/2017 LD 427.73 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 OCT-DEC 2017 6 12/31/2017 GJ -135.18 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 OCT-DEC 2017 6 12/31/2017 GJ -17.85 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 OCT-DEC 2017 6 12/31/2017 GJ -104.95 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 OCT-DEC 2017 6 12/31/2017 GJ 135.18 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 OCT-DEC 2017 6 12/31/2017 GJ 17.85 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 OCT-DEC 2017 6 12/31/2017 GJ 104.95 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 9 3/3/2018 LD 45.06 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 9 3/3/2018 LD 5.95 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 9 3/3/2018 LD 49.37 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Wages 9 3/3/2018 LD 427.73 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 9 3/17/2018 LD 48.03 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 9 3/17/2018 LD 6.39 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 9 3/17/2018 LD 6.6 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Wages 9 3/17/2018 LD 459.59 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 9 3/31/2018 LD 45.06 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 9 3/31/2018 LD 5.95 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 9 3/31/2018 LD 49.37 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Wages 9 3/31/2018 LD 427.73 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 9 3/31/2018 GJ -138.15 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 9 3/31/2018 GJ -18.29 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 9 3/31/2018 GJ -105.34 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 9 3/31/2018 GJ 18.29 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 9 3/31/2018 GJ 105.34 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 9 3/31/2018 GJ 138.15 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 10 4/28/2018 LD 45.06 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 10 4/28/2018 LD 5.95 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 10 4/28/2018 LD 49.37 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Wages 10 4/28/2018 LD 427.73 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 11 5/12/2018 LD 45.06 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 11 5/12/2018 LD 5.95 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 11 5/12/2018 LD 6.21 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Wages 11 5/12/2018 LD 427.73 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 11 5/26/2018 LD 45.06 Acct #Project Phase Phase Title Project Title Description Period Doc Date Tran_Type Amount 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 11 5/26/2018 LD 5.95 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 11 5/26/2018 LD 49.37 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Wages 11 5/26/2018 LD 427.73 223-500-4427-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Wages 12 6/9/2018 LD 427.73 223-500-4427-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 12 6/9/2018 LD 6.21 223-500-4427-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 12 6/9/2018 LD 5.95 223-500-4427-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 12 6/9/2018 LD 45.06 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Wages 12 6/23/2018 LD 459.59 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 12 6/23/2018 LD 48.03 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 12 6/23/2018 LD 6.39 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 12 6/23/2018 LD 6.67 223-500-4427-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 APR-JUN 2018 12 6/30/2018 GJ 5.95 223-500-4427-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 APR-JUN 2018 12 6/30/2018 GJ 6.21 223-500-4427-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 APR-JUN 2018 12 6/30/2018 GJ 45.06 223-500-4427-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 APR-JUN 2018 12 6/30/2018 GJ -6.21 223-500-4427-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 APR-JUN 2018 12 6/30/2018 GJ -5.95 223-500-4427-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 APR-JUN 2018 12 6/30/2018 GJ -45.06 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 APR-JUN 2018 12 6/30/2018 GJ 111.62 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 APR-JUN 2018 12 6/30/2018 GJ 24.24 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 APR-JUN 2018 12 6/30/2018 GJ 183.21 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 APR-JUN 2018 12 6/30/2018 GJ -183.21 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 APR-JUN 2018 12 6/30/2018 GJ -24.24 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 APR-JUN 2018 12 6/30/2018 GJ -111.62 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Wages 2 8/4/2018 LD 63.72 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 2 8/4/2018 LD 6.18 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 2 8/4/2018 LD 0.83 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 2 8/4/2018 LD 0.78 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 JUL-SEP 2018 3 9/30/2018 GJ 6.18 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 JUL-SEP 2018 3 9/30/2018 GJ 0.78 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 JUL-SEP 2018 3 9/30/2018 GJ 0.83 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 JUL-SEP 2018 3 9/30/2018 GJ -6.18 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 JUL-SEP 2018 3 9/30/2018 GJ -0.83 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 JUL-SEP 2018 3 9/30/2018 GJ -0.78 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Wages 5 11/10/2018 LD 33.46 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 5 11/10/2018 LD 3.24 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 5 11/10/2018 LD 0.43 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 5 11/10/2018 LD 0.4 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 OCT-DEC 2018 6 12/31/2018 GJ 0.43 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 OCT-DEC 2018 6 12/31/2018 GJ 3.24 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 OCT-DEC 2018 6 12/31/2018 GJ 0.4 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 OCT-DEC 2018 6 12/31/2018 GJ -3.24 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 OCT-DEC 2018 6 12/31/2018 GJ -0.43 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 OCT-DEC 2018 6 12/31/2018 GJ -0.4 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Wages 7 1/19/2019 LD 184.78 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 7 1/19/2019 LD 20.15 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 7 1/19/2019 LD 2.4 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 7 1/19/2019 LD 2.69 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Wages 9 3/30/2019 LD 461.94 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 9 3/30/2019 LD 50.36 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 9 3/30/2019 LD 6.01 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 9 3/30/2019 LD 7.34 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 JAN-MAR 2019 9 3/31/2019 GJ 70.51 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 JAN-MAR 2019 9 3/31/2019 GJ 8.41 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 JAN-MAR 2019 9 3/31/2019 GJ 10.03 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 JAN-MAR 2019 9 3/31/2019 GJ -70.51 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 JAN-MAR 2019 9 3/31/2019 GJ -8.41 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-40-50 JAN-MAR 2019 9 3/31/2019 GJ -10.03 Acct #Project Phase Phase Title Project Title Description Period Doc Date Tran_Type Amount 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Wages 12 6/22/2019 LD 461.94 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 12 6/22/2019 LD 50.36 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 12 6/22/2019 LD 6.01 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 12 6/22/2019 LD 6.71 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-1040-1050 APR-JUN 20 12 6/30/2019 GJ 50.36 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-1040-1050 APR-JUN 20 12 6/30/2019 GJ 6.01 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-1040-1050 APR-JUN 20 12 6/30/2019 GJ 6.71 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-1040-1050 APR-JUN 20 12 6/30/2019 GJ -50.36 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-1040-1050 APR-JUN 20 12 6/30/2019 GJ -6.01 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS RCLS 1030-1040-1050 APR-JUN 20 12 6/30/2019 GJ -6.71 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Wages 2 8/17/2019 LD 461.94 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 2 8/17/2019 LD 52.99 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 2 8/17/2019 LD 9.43 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 2 8/17/2019 LD 6.71 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Wages 3 9/28/2019 LD 461.94 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 3 9/28/2019 LD 52.99 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 3 9/28/2019 LD 9.43 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 3 9/28/2019 LD 7.34 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS SR2S-CYCLE 10 CEDAR IMPROVEMEN 3 9/30/2019 GJ 105.98 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS SR2S-CYCLE 10 CEDAR IMPROVEMEN 3 9/30/2019 GJ 14.05 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS SR2S-CYCLE 10 CEDAR IMPROVEMEN 3 9/30/2019 GJ 18.86 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS SR2S-CYCLE 10 CEDAR IMPROVEMEN 3 9/30/2019 GJ -105.98 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS SR2S-CYCLE 10 CEDAR IMPROVEMEN 3 9/30/2019 GJ -18.86 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS SR2S-CYCLE 10 CEDAR IMPROVEMEN 3 9/30/2019 GJ -14.05 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Wages 4 10/12/2019 LD 461.95 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 4 10/12/2019 LD 52.99 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 4 10/12/2019 LD 9.43 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 4 10/12/2019 LD 6.71 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Wages 5 11/9/2019 LD 75.88 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 5 11/9/2019 LD 7.78 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 5 11/9/2019 LD 1.55 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 5 11/9/2019 LD 0.94 223-500-4420-3001 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Wages 5 11/23/2019 LD 461.94 223-500-4420-1030 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 5 11/23/2019 LD 52.99 223-500-4420-1040 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 5 11/23/2019 LD 9.43 223-500-4420-1050 130808 04 ADMINISTRATION: DESIGN SR2S-CYCLE 10 CEDAR IMPROVEMENTS Benefits/Contributions 5 11/23/2019 LD 6.72 9198.06