Cities Index.
Attachment 2 - Richmond 2CFR20 ICAP Narrative_FINAL Report 6.21.22 Final.pdf

Richmond City Council
April 18, 2023

Document
Attachment 2 - Richmond 2CFR20 ICAP Narrative_FINAL Report 6.21.22 Final.pdf
Meeting
April 18, 2023
Body
Richmond City Council
Pages
278
Original file
2.2 MB
Text extracted from the city's file for reading and search. Open the original on pub-richmond.escribemeetings.com. That file is the official record.

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total 0001-173- Budget/Operating
6208- SA-CIP 07B TARB BND PRCDS-HSG - 0.000% - - - - 6300- SA-DS HARBOR 98 TARB 5,077 0.002% 9 9 2 11 6304- SA-DS 2003B TARB 405,325 0.153% 745 745 152 897 6305- SA-DS 2004A TARB 2/3 327,948 0.124% 602 602 123 725 6306- SA-DS 2004A TARB -1/3 HSING 164,564 0.062% 302 302 62 364 6307- SA-DS 2004B TARB - HOUSING 37,387 0.014% 69 69 14 83 6308- SA-DS 2007/10A TARB 677,753 0.256% 1,245 1,245 254 1,499 6309- SA-DS 2007/10B TARB - HOUSING 2,672 0.001% 5 5 1 6 6401- SA-DS 2014A NON-TAXABLE BONDS 572,917 0.216% 1,053 1,053 215 1,267 6402- SA-DS 2014B TAXABLE BONDS - 0.000% - - - - 6403- SA-DS LOANS PAYABLE 585,656 0.221% 1,076 1,076 219 1,295 6404- SA-DS 2021A NON-TAXABLE BONDS is new 595,188 0.225% 1,093 1,093 223 1,316 6405- SA-DS 2021B TAXABLE BONDS is new 108,451 0.041% 199 199 41 240 6996- SUCCESSOR AGENCY - GLTDAG 394,410 0.149% 725 725 148 872 9102- CITY OF RICHMOND - GFAAG 10,428,862 3.934% 19,160 19,160 3,908 23,068 AO- ALL OTHER - 0.000% - - - - Total 265,076,821 100.000% $ 486,990 $ - $ 486,990 $ 97,272 $ 584,262 Allocation Basis: FY 20-21 Modified Total Direct Cost per Fund/Department Source of Allocation: FY20-21 Richmond Expenditure Summary_3.14.22.xlxs Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
8 - Allocations

Page 122 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-173- Budget/Operating

ALLOCABLE BUDGET UNITS
BLDG- Building Use $ - $ - EQUIP- Equipment Use - - 0001-131- City Manager's Office 1,281 1,281 0001-141- City Clerk 1,429 1,429 0001-151- City Attorney 3,218 3,218 0001-171- Finance Administration 1,017 1,017 0001-172- Accounting 2,280 2,280 0001-173- Budget/Operating 875 875 0001-174- Payroll 765 765 0001-175- Treasury/Cash Management 1,260 1,260 0001-176- Accounts Payable 547 547 0001-177- Rev Collection 1,589 1,589 0001-178- Purchasing 828 828 0001-181- Human Resources 4,436 4,436 0001-232- Facility Maintenance and Administration 18,036 18,036 0001-235- Equipment Services/Fleet Services 7,163 7,163 0001-261- Information Technology Administration 3,663 3,663 0001-262- Telecommunications 3,726 3,726 0001-263- IT/Mailroom and Duplication, GIS, ERP and Desktop 340 340 0001-907, 908- Non-Departmental 17,243 17,243 - - -
- - -
- - -
- - -
- - -

RECEIVING BUDGET UNITS
0001-101- OFFICE OF THE MAYOR 1,158 1,158 0001-105- COUNCIL/CITY COUNCIL DIV 971 971 0001-121- POLICE COMMISSION DIV 139 139 0001-132- CM-SPCIAL PROJS/ENVIRONMENTAL 8 8 0001-163- GF-PLN/CODE ENFORCEMENT (DIV) 2,661 2,661 0001-191- GF-POLICE ADMIN DIV 122,333 122,333 0001-192- GF-POLICE-PATROL/CIB 27 27 0001-193- GF-POLICE/CRIME PREVENTION 402 402 0001-194- GF-POLICE-COPS GRANT 2,335 2,335 0001-196- GF-POLICE/REGULATORY 1,386 1,386 0001-197- CAD DISPATCH SYST/COMM POL DIV 8,146 8,146 0001-199- GF-PARKING ENFORCEMENT DIV 734 734 0001-201- GF-FIRE/ADMIN DIV 1,287 1,287 0001-202- GF-FIRE/SUPRESSN DIV 61,473 61,473 0001-203- GF-FIRE PREVENTION DIV 4,644 4,644 0001-204- GF-FIRE/ SUPPORT DIV 469 469 0001-205- GF-FIRE/TRAINING DIV 845 845 0001-206- GF-FIRE/OF. OF EMS DIV 415 415 0001-211- OF. OF NB-HOOD SFTY ADMIN DIV 2,652 2,652 0001-212- OFF OF N-HOOD SFTY/GRANT ADM 713 713 0001-231- GF-PW ADMIN-DIV 3,574 3,574 0001-233- GF-PRKS&LNDSKP/PRKS (S-DIV) 9,273 9,273 0001-234- IT GIS 6,445 6,445

ALLOCATION SUMMARY
Total
Citywide
Budget
Services
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
8 - Summary

Page 123 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-173- Budget/Operating

ALLOCATION SUMMARY
Total
Citywide
Budget
Services
0001-237- GF-I&M/ABATEMENT SVCS (DIV) 4,151 4,151 0001-238- GF-I&M/CODE ENFORCEMENT (DIV) - - 0001-239- GF-I&M/PROP/ASSETS MNGT (DIV) 2 2 0001-241- GF-LIB&CL SVC/L-ADM DIV 7,095 7,095 0001-242- GF-LS/REF SVCS(S-DIV) 753 753 0001-243- GF-LIB&CL SVCS/LEAP DIV 1,753 1,753 0001-244- GF-LIB&CL SVC/P-ART DIV - - 0001-251- GF-RECREATION ADM DIV 3,793 3,793 0001-253- CM&NB/BOOKER T CTR (S-DIV) 2,120 2,120 0001-255- GF-CM TRANSPORTATN OPERATIONS 329 329 0001-254- GF-REC/SPCL EVENTS (S-DIV) 1,385 1,385 0001-256- RECREATION SVCS/AQUATICS 404 404 0001-257- RECREATION SVCS/CONVENTION CTR 792 792 0001-259- RECREATION SVCS/PLUNGE 376 376 0001-260- RECREATION SVCS/CITIES OF SRVC 593 593 0001-291- GF-ADMINISTRATIVE SERVICES - - 0001-292- GF-STREET SWEEPING - - 0001-361- GF ECON DEV/SP PRJ-ENVIRONMNTL 1,015 1,015 0001-362- GF ECON DEV/SP PRJ-ENVIRONMNTL 1,151 1,151 0001-364- GF-ECON DEV/PUBLIC ART DIV 1,328 1,328 0001-369- GF-ECON DEV/REAL ESTATE (DIV) 1,356 1,356 0001-371- INTERNAL SERVICES-ADMIN 547 547 0001-910- GF-NON-DEPT/CITY FESTIVAL - - 1001- SECURED PENSION OVERRIDE - - 1002- STATE GAS TAX 5,542 5,542 1003- TRANSPORTATION OPERATIONS 1,167 1,167 1004- ASSET SEIZURE FUND 86 86 1005- LIBRARY FUND 529 529 1006- OUTSIDE FUNDED SVCS - GRANTS 3,618 3,618 1007- EMERGENCY MED SERV 484 484 1010- N.RICHMOND WASTE 219 219 1012- HILLTOP LANDSCAPE MAINT DIST 2,720 2,720 1013- FIRE DEPT HAZMAT GRANT 576 576 1014- EDA GRANT FUND 992 992 1015- MARINA BAY LNDSCP&LIGHTDIST FD 2,340 2,340 1017- CHEVRON MODERNIZATN PROJ & CIA 12,561 12,561 1018- RENT CONTROL 4,358 4,358 1019- SBI RMRA CAP IMPROVEMENT 338 338 1050- CR-PLANNING & BUILDING 15,397 15,397 1051- CR-ENGINEERING - - 1053- CODE ENFORCEMENT-CR - - 1054- ENGINEERING GRANTS 295 295 1055- ENCROACHMENTS SVCS 1,099 1,099 1200- COR HOUSING ADMINISTRATION 820 820 1201- CDBG 77 77 1203- NEIGHBORHOOD STABILIZATION 52 52 1205- EMPLOYMENT & TRAINING 9,404 9,404 1207- NEIGHBORHOOD STAB(CITY) 33 33 1208- SUCCESSOR HOUSING AGNCY 287 287 1209- CAL-HOME 31 31 Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
8 - Summary

Page 124 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-173- Budget/Operating

ALLOCATION SUMMARY
Total
Citywide
Budget
Services
1302- HOUSNG IN LIEU FEE - DEVELOPER 79 79 1303- KIDS FIRST INITIATIVE 727 727 1304- EMERGENCY OPE & DISASTR RECVRY 2,395 2,395 2001- GENERAL CAPITAL FUND - - 2002- MEASURE J 1,584 1,584 2110- IMPACT FEE - PARK 37 37 2111- PF IMP FEES-TRAFFIC/ROAD-ENG 704 704 2113- IMPACT FEE - FIRE 165 165 2114- IMPACT FEE - POLICE 11 11 2115- IMPACT FEE - COMM/AQUATC 133 133 2116- IMPACT FEE - PARKS/OPEN 77 77 2117- IMPACT FEE - LIBRARY 29 29 2119- IMPACT FEE - STORM DRAINAGE 84 84 2120- IMPACT FEE - WASTEWATER 34 34 2125- IRON TRIANGLE/EPA PROGRAMS 441 441 2126- COR-HOUSING DEPT CIP FUND - - 3001- DS - 2005 TAXABLE POB 1,074 1,074 3002- DS - 99A PENSION OBLIG BOND 656 656 3005- DS - 2007 CIVIC CENTER 9,880 9,880 4001- PORT OF RICHMOND 12,899 12,899 4003- WASTEWATER 44,323 44,323 4005- MARINA 503 503 4006- STORM WATER 3,790 3,790 4008- KCRT - CABLE TELEVIS 1,675 1,675 4101- RHA-HSNG CHOICE VOUCHER-SEC 8 42 42 4102- RHA-HOPE 6 85 85 4201- RHA-CAPITAL FUND 579 579 4401- RHA-HACIENDA 789 789 4404- RHA-NEVIN PLAZA 3,976 3,976 4405- RHA-NYSTROM VILLAGE 1,630 1,630 4406- RHA-RICHMOND VILLAGE ONE 553 553 4407- RHA-RICHMOND VILLAGE TWO 470 470 4408- RHA-RICHMOND VILLAGE THREE 266 266 4501- RHA-CENTRAL OFFICE COST CNTR 180 180 4502- RHA-HOUSING (RAD) CORPORATION 0 0 5001- INSURANCE RESERVES 38,558 38,558 5003- EQUIPMENT SERVICES 2,439 2,439 5005- CAD DISPATCH SYSTEM - - 5006- RMS RECORDS SERVICES - - 5008- COMPENSATED ABSENCES 4,812 4,812 6001- GENERAL TRUST & AGENCY - - 6004- COMMISSION ON AGING 5 5 6005- SEAVER GALLERY TRUST FUND - - 6007- SENIOR TRUST DEPOSIT 24 24 6047- CERTBT PLAN FUND 486 486 6048- OPEB PLAN TRUST 15,755 15,755 6049- PT MOLATE PRIVATE-PURPOSE TRST 469 469 6050- GENERAL PENSION FUND 889 889 6051- POLICE & FIRE PENSION 3,285 3,285 6052- GARFIELD PENSION FUND 111 111 Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
8 - Summary

Page 125 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-173- Budget/Operating

ALLOCATION SUMMARY
Total
Citywide
Budget
Services
6058- MARINA WESTSHORE DEB 148 148 6059- COUNTRY CLUB VISTA 386 386 6060- REASSESSMENT DISTRICT 2003-1 - - 6101- SA-PROPERTY TAX TRUST FUND - - 6102- SA- ADMINISTRATION 461 461 6103- SA - CAPITAL PROJECT FUNDS 1,166 1,166 6208- SA-CIP 07B TARB BND PRCDS-HSG - - 6300- SA-DS HARBOR 98 TARB 11 11 6304- SA-DS 2003B TARB 897 897 6305- SA-DS 2004A TARB 2/3 725 725 6306- SA-DS 2004A TARB -1/3 HSING 364 364 6307- SA-DS 2004B TARB - HOUSING 83 83 6308- SA-DS 2007/10A TARB 1,499 1,499 6309- SA-DS 2007/10B TARB - HOUSING 6 6 6401- SA-DS 2014A NON-TAXABLE BONDS 1,267 1,267 6402- SA-DS 2014B TAXABLE BONDS - - 6403- SA-DS LOANS PAYABLE 1,295 1,295 6404- SA-DS 2021A NON-TAXABLE BONDS is new 1,316 1,316 6405- SA-DS 2021B TAXABLE BONDS is new 240 240 6996- SUCCESSOR AGENCY - GLTDAG 872 872 9102- CITY OF RICHMOND - GFAAG 23,068 23,068

AO- ALL OTHER - - Total $ 584,262 $ 584,262
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
8 - Summary

Page 126 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-174- Payroll
Distribution Percentage 100.00%
Expense Type $
Personnel
400002 - SALARIES & WAGES/Mgmt-Local 21 22,612$ S 22,612$ 400003 - SALARIES & WAGES/Local 1021 152,856 S 152,856
400031 - OVERTIME/General 3,964 S 3,964
400048 - OTHER PAY/Bilingual Pay 1,532 S 1,532
400050 - OTHER PAY/Medical Flex 600 S 600
400066 - OTHER PAY/Assign Diff-non-PERS 1,595 S 1,595
400103 - P-ROLL BEN/Medicare Tax-ER Shr 2,694 S 2,694
400105 - P-ROLL BEN/Health Insurance Be 43,616 S 43,616 400106 - P-ROLL BEN/Dental Insurance 4,081 S 4,081
400109 - P-ROLL BEN/Employee Assistance 98 S 98
400111 - P-ROLL BEN/Vision 477 S 477
400112 - P-ROLL BEN/Life Insurance 292 S 292
400114 - P-ROLL BEN/Long Term Disabilit 1,237 S 1,237
400116 - P-ROLL BEN/Unemployment Ins 992 S 992
400117 - P-ROLL BEN/Personal/Prof Dev 2,190 S 2,190
400118 - P-ROLL BEN/WC-Injury Appointmt 304 S 304
400121 - P-ROLL BEN/Worker Comp-Clerica 17,028 S 17,028 400122 - P-ROLL BEN/Worker Comp-Prof 2,037 S 2,037
400127 - P-ROLL BEN/OPEB 7,197 S 7,197
400149 - P-ROLL BEN/PERS-Misc 23,798 S 23,798
400151 - P-ROLL BEN/PERS-Misc (UAL) 56,770 S 56,770
Subtotal Personnel Cost 345,969$ 345,969$
Operating Services & Supplies
400592 - COST POOL/(CON)-Admin Charges (59,770)$ S (59,770)$ Subtotal Operating Cost (59,770)$ (59,770)$
Disallowed Expenses
400592 - COST POOL/(CON)-Admin Charges 59,770 [1] 59,770 Subtotal Disallowed Costs 59,770$ 59,770$
DEPARTMENTAL EXPENDITURES 345,969$ 345,969$
Reallocation of Incoming Costs
First Allocation 8,147$ 354,116$
Unallocated Costs -$ -$
Subtotal of First Allocation 8,147$ 354,116$
Second Allocation 72,493$ 72,493$
Unallocated Costs -$ -$
Subtotal of Second Allocation 72,493$ 72,493$
TOTAL FUNCTIONAL COSTS 426,609$ 426,609$
[1] Admin charges are excluded and re-established through this CAP analysis

DEPARTMENTAL EXPENSE DETAIL
Notes
Spread
Method
Citywide
Payroll
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
9 - EXP

Page 127 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-174- Payroll First Second
Allocation Allocation Total
Departmental Expenditures $ 345,969 $ 345,969 Incoming Costs
BLDG- Building Use $ - $ - $ - EQUIP- Equipment Use - - - 0001-131- City Manager's Office 1,254 270 1,525 0001-141- City Clerk 1,231 236 1,467 0001-151- City Attorney 2,786 527 3,313 0001-171- Finance Administration 1,035 259 1,294 0001-172- Accounting 1,205 183 1,387 0001-173- Budget/Operating 636 130 765 0001-174- Payroll 1,186 1,186 0001-175- Treasury/Cash Management - - 0001-176- Accounts Payable - - 0001-177- Rev Collection - - 0001-178- Purchasing - - 0001-181- Human Resources 6,363 6,363 0001-232- Facility Maintenance and Administration - - 0001-235- Equipment Services/Fleet Services 11,720 11,720 0001-261- Information Technology Administration 6,133 6,133 0001-262- Telecommunications 6,049 6,049 0001-263- IT/Mailroom and Duplication, GIS, ERP and Desktop - - 0001-907, 908- Non-Departmental 39,438 39,438 - - -
- - -
- - -
- - -
- - -
Total Incoming Costs $ 8,147 $ 72,493 $ 80,640 Total Costs to be Allocated $ 354,116 $ 72,493 $ 426,609

COSTS TO BE ALLOCATED
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
9 - Costs

Page 128 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total Citywide Payroll Services 9.1

ALLOCABLE BUDGET UNITS
BLDG- Building Use - 0.000% $ - $ - $ - EQUIP- Equipment Use - 0.000% - - - 0001-131- City Manager's Office 4 0.446% 1,581 1,581 1,581 0001-141- City Clerk 4 0.446% 1,581 1,581 1,581 0001-151- City Attorney 11 1.228% 4,347 4,347 4,347 0001-171- Finance Administration 3 0.335% 1,186 1,186 1,186 0001-172- Accounting 7 0.781% 2,767 2,767 2,767 0001-173- Budget/Operating 4 0.446% 1,581 1,581 1,581 0001-174- Payroll 3 0.335% 1,186 1,186 1,186 0001-175- Treasury/Cash Management 4 0.446% 1,581 1,581 337 1,918 0001-176- Accounts Payable 2 0.223% 790 790 169 959 0001-177- Rev Collection 5 0.558% 1,976 1,976 421 2,398 0001-178- Purchasing 2 0.223% 790 790 169 959 0001-181- Human Resources 13 1.451% 5,138 5,138 1,096 6,234 0001-232- Facility Maintenance and Administration 34 3.795% 13,437 13,437 2,866 16,303 0001-235- Equipment Services/Fleet Services 13 1.451% 5,138 5,138 1,096 6,234 0001-261- Information Technology Administration 4 0.446% 1,581 1,581 337 1,918 0001-262- Telecommunications 4 0.446% 1,581 1,581 337 1,918 0001-263- IT/Mailroom and Duplication, GIS, ERP and Desktop 1 0.112% 395 395 84 480 0001-907, 908- Non-Departmental - 0.000% - - - - - - 0.000% - - - - - - 0.000% - - - - - - 0.000% - - - - - - 0.000% - - - - - - 0.000% - - - -

RECEIVING BUDGET UNITS
0001-101- OFFICE OF THE MAYOR 3 0.335% 1,186 1,186 253 1,439 0001-105- COUNCIL/CITY COUNCIL DIV 11 1.228% 4,347 4,347 927 5,275 0001-121- POLICE COMMISSION DIV 2 0.223% 790 790 169 959 0001-132- CM-SPCIAL PROJS/ENVIRONMENTAL - 0.000% - - - - 0001-163- GF-PLN/CODE ENFORCEMENT (DIV) 6 0.670% 2,371 2,371 506 2,877 0001-191- GF-POLICE ADMIN DIV 199 22.210% 78,649 78,649 16,775 95,423 0001-192- GF-POLICE-PATROL/CIB - 0.000% - - - - 0001-193- GF-POLICE/CRIME PREVENTION 2 0.223% 790 790 169 959 0001-194- GF-POLICE-COPS GRANT 1 0.112% 395 395 84.29 480 0001-196- GF-POLICE/REGULATORY 2 0.223% 790 790 169 959 0001-197- CAD DISPATCH SYST/COMM POL DIV 26 2.902% 10,276 10,276 2,192 12,467 0001-199- GF-PARKING ENFORCEMENT DIV 1 0.112% 395 395 84 480 0001-201- GF-FIRE/ADMIN DIV 4 0.446% 1,581 1,581 337 1,918 0001-202- GF-FIRE/SUPRESSN DIV 82 9.152% 32,408 32,408 6,912 39,320 0001-203- GF-FIRE PREVENTION DIV 7 0.781% 2,767 2,767 590 3,357 0001-204- GF-FIRE/ SUPPORT DIV - 0.000% - - - - 0001-205- GF-FIRE/TRAINING DIV 1 0.112% 395 395 84 480 0001-206- GF-FIRE/OF. OF EMS DIV 2 0.223% 790 790 169 959 0001-211- OF. OF NB-HOOD SFTY ADMIN DIV 17 1.897% 6,719 6,719 1,433 8,152 0001-212- OFF OF N-HOOD SFTY/GRANT ADM - 0.000% - - - - 0001-231- GF-PW ADMIN-DIV 7 0.781% 2,767 2,767 590 3,357 0001-233- GF-PRKS&LNDSKP/PRKS (S-DIV) 36 4.018% 14,228 14,228 3,035 17,262 0001-174- Payroll
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
9 - Allocations

Page 129 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total 0001-174- Payroll
0001-234- IT GIS 29 3.237% 11,461 11,461 2,445 13,906 0001-237- GF-I&M/ABATEMENT SVCS (DIV) 16 1.786% 6,324 6,324 1,349 7,672 0001-238- GF-I&M/CODE ENFORCEMENT (DIV) 1 0.112% 395 395 84 480 0001-239- GF-I&M/PROP/ASSETS MNGT (DIV) - 0.000% - - - - 0001-241- GF-LIB&CL SVC/L-ADM DIV 40 4.464% 15,809 15,809 3,372 19,181 0001-242- GF-LS/REF SVCS(S-DIV) - 0.000% - - - - 0001-243- GF-LIB&CL SVCS/LEAP DIV 10 1.116% 3,952 3,952 843 4,795 0001-244- GF-LIB&CL SVC/P-ART DIV - 0.000% - - - - 0001-251- GF-RECREATION ADM DIV 15 1.674% 5,928 5,928 1,264 7,193 0001-253- CM&NB/BOOKER T CTR (S-DIV) 36 4.018% 14,228 14,228 3,035 17,262 0001-255- GF-CM TRANSPORTATN OPERATIONS 2 0.223% 790 790 169 959 0001-254- GF-REC/SPCL EVENTS (S-DIV) 10 1.116% 3,952 3,952 843 4,795 0001-256- RECREATION SVCS/AQUATICS 37 4.129% 14,623 14,623 3,119 17,742 0001-257- RECREATION SVCS/CONVENTION CTR 4 0.446% 1,581 1,581 337 1,918 0001-259- RECREATION SVCS/PLUNGE 1 0.112% 395 395 84 480 0001-260- RECREATION SVCS/CITIES OF SRVC 2 0.223% 790 790 169 959 0001-291- GF-ADMINISTRATIVE SERVICES 1 0.112% 395 395 84 480 0001-292- GF-STREET SWEEPING 1 0.112% 395 395 84 480 0001-361- GF ECON DEV/SP PRJ-ENVIRONMNTL 3 0.335% 1,186 1,186 253 1,439 0001-362- GF ECON DEV/SP PRJ-ENVIRONMNTL 1 0.112% 395 395 84 480 0001-364- GF-ECON DEV/PUBLIC ART DIV 1 0.112% 395 395 84 480 0001-369- GF-ECON DEV/REAL ESTATE (DIV) 2 0.223% 790 790 169 959 0001-371- INTERNAL SERVICES-ADMIN 2 0.223% 790 790 169 959 0001-910- GF-NON-DEPT/CITY FESTIVAL - 0.000% - - - - 1001- SECURED PENSION OVERRIDE - 0.000% - - - - 1002- STATE GAS TAX - 0.000% - - - - 1003- TRANSPORTATION OPERATIONS 4 0.446% 1,581 1,581 337 1,918 1004- ASSET SEIZURE FUND - 0.000% - - - - 1005- LIBRARY FUND - 0.000% - - - - 1006- OUTSIDE FUNDED SVCS - GRANTS - 0.000% - - - - 1007- EMERGENCY MED SERV - 0.000% - - - - 1010- N.RICHMOND WASTE - 0.000% - - - - 1012- HILLTOP LANDSCAPE MAINT DIST 13 1.451% 5,138 5,138 1,096 6,234 1013- FIRE DEPT HAZMAT GRANT - 0.000% - - - - 1014- EDA GRANT FUND - 0.000% - - - - 1015- MARINA BAY LNDSCP&LIGHTDIST FD 12 1.339% 4,743 4,743 1,012 5,754 1017- CHEVRON MODERNIZATN PROJ & CIA - 0.000% - - - - 1018- RENT CONTROL 13 1.451% 5,138 5,138 1,096 6,234 1019- SBI RMRA CAP IMPROVEMENT - 0.000% - - - - 1050- CR-PLANNING & BUILDING 24 2.679% 9,485 9,485 2,023 11,508 1051- CR-ENGINEERING - 0.000% - - - - 1053- CODE ENFORCEMENT-CR - 0.000% - - - - 1054- ENGINEERING GRANTS - 0.000% - - - - 1055- ENCROACHMENTS SVCS 8 0.893% 3,162 3,162 674 3,836 1200- COR HOUSING ADMINISTRATION 3 0.335% 1,186 1,186 253 1,439 1201- CDBG - 0.000% - - - - 1203- NEIGHBORHOOD STABILIZATION - 0.000% - - - - 1205- EMPLOYMENT & TRAINING 17 1.897% 6,719 6,719 1,433 8,152 1207- NEIGHBORHOOD STAB(CITY) - 0.000% - - - - 1208- SUCCESSOR HOUSING AGNCY - 0.000% - - - - 1209- CAL-HOME - 0.000% - - - - Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
9 - Allocations

Page 130 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total 0001-174- Payroll
1302- HOUSNG IN LIEU FEE - DEVELOPER - 0.000% - - - - 1303- KIDS FIRST INITIATIVE 3 0.335% 1,186 1,186 253 1,439 1304- EMERGENCY OPE & DISASTR RECVRY - 0.000% - - - - 2001- GENERAL CAPITAL FUND - 0.000% - - - - 2002- MEASURE J - 0.000% - - - - 2110- IMPACT FEE - PARK - 0.000% - - - - 2111- PF IMP FEES-TRAFFIC/ROAD-ENG - 0.000% - - - - 2113- IMPACT FEE - FIRE - 0.000% - - - - 2114- IMPACT FEE - POLICE - 0.000% - - - - 2115- IMPACT FEE - COMM/AQUATC - 0.000% - - - - 2116- IMPACT FEE - PARKS/OPEN - 0.000% - - - - 2117- IMPACT FEE - LIBRARY - 0.000% - - - - 2119- IMPACT FEE - STORM DRAINAGE - 0.000% - - - - 2120- IMPACT FEE - WASTEWATER - 0.000% - - - - 2125- IRON TRIANGLE/EPA PROGRAMS - 0.000% - - - - 2126- COR-HOUSING DEPT CIP FUND - 0.000% - - - - 3001- DS - 2005 TAXABLE POB - 0.000% - - - - 3002- DS - 99A PENSION OBLIG BOND - 0.000% - - - - 3005- DS - 2007 CIVIC CENTER - 0.000% - - - - 4001- PORT OF RICHMOND 3 0.335% 1,186 1,186 253 1,439 4003- WASTEWATER 9 1.004% 3,557 3,557 759 4,316 4005- MARINA - 0.000% - - - - 4006- STORM WATER - 0.000% - - - - 4008- KCRT - CABLE TELEVIS 4 0.446% 1,581 1,581 337 1,918 4101- RHA-HSNG CHOICE VOUCHER-SEC 8 - 0.000% - - - - 4102- RHA-HOPE 6 - 0.000% - - - - 4201- RHA-CAPITAL FUND - 0.000% - - - - 4401- RHA-HACIENDA - 0.000% - - - - 4404- RHA-NEVIN PLAZA 2 0.223% 790 790 169 959 4405- RHA-NYSTROM VILLAGE 1 0.112% 395 395 84 480 4406- RHA-RICHMOND VILLAGE ONE - 0.000% - - - - 4407- RHA-RICHMOND VILLAGE TWO - 0.000% - - - - 4408- RHA-RICHMOND VILLAGE THREE - 0.000% - - - - 4501- RHA-CENTRAL OFFICE COST CNTR 1 0.112% 395 395 84 480 4502- RHA-HOUSING (RAD) CORPORATION - 0.000% - - - - 5001- INSURANCE RESERVES 5 0.558% 1,976 1,976 421 2,398 5003- EQUIPMENT SERVICES - 0.000% - - - - 5005- CAD DISPATCH SYSTEM 1 0.112% 395 395 84 480 5006- RMS RECORDS SERVICES - 0.000% - - - - 5008- COMPENSATED ABSENCES - 0.000% - - - - 6001- GENERAL TRUST & AGENCY - 0.000% - - - - 6004- COMMISSION ON AGING - 0.000% - - - - 6005- SEAVER GALLERY TRUST FUND - 0.000% - - - - 6007- SENIOR TRUST DEPOSIT - 0.000% - - - - 6047- CERTBT PLAN FUND - 0.000% - - - - 6048- OPEB PLAN TRUST - 0.000% - - - - 6049- PT MOLATE PRIVATE-PURPOSE TRST - 0.000% - - - - 6050- GENERAL PENSION FUND 7 0.781% 2,767 2,767 590 3,357 6051- POLICE & FIRE PENSION 24 2.679% 9,485 9,485 2,023 11,508 6052- GARFIELD PENSION FUND 1 0.112% 395 395 84 480 6058- MARINA WESTSHORE DEB - 0.000% - - - - 6059- COUNTRY CLUB VISTA - 0.000% - - - - Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
9 - Allocations

Page 131 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total 0001-174- Payroll
6060- REASSESSMENT DISTRICT 2003-1 - 0.000% - - - - 6101- SA-PROPERTY TAX TRUST FUND - 0.000% - - - - 6102- SA- ADMINISTRATION - 0.000% - - - - 6103- SA - CAPITAL PROJECT FUNDS - 0.000% - - - - 6208- SA-CIP 07B TARB BND PRCDS-HSG - 0.000% - - - - 6300- SA-DS HARBOR 98 TARB - 0.000% - - - - 6304- SA-DS 2003B TARB - 0.000% - - - - 6305- SA-DS 2004A TARB 2/3 - 0.000% - - - - 6306- SA-DS 2004A TARB -1/3 HSING - 0.000% - - - - 6307- SA-DS 2004B TARB - HOUSING - 0.000% - - - - 6308- SA-DS 2007/10A TARB - 0.000% - - - - 6309- SA-DS 2007/10B TARB - HOUSING - 0.000% - - - - 6401- SA-DS 2014A NON-TAXABLE BONDS - 0.000% - - - - 6402- SA-DS 2014B TAXABLE BONDS - 0.000% - - - - 6403- SA-DS LOANS PAYABLE - 0.000% - - - - 6404- SA-DS 2021A NON-TAXABLE BONDS is new - 0.000% - - - - 6405- SA-DS 2021B TAXABLE BONDS is new - 0.000% - - - - 6996- SUCCESSOR AGENCY - GLTDAG - 0.000% - - - - 9102- CITY OF RICHMOND - GFAAG - 0.000% - - - - AO- ALL OTHER - 0.000% - - - - Total 896 100.000% $ 354,116 $ - $ 354,116 $ 72,493 $ 426,609 Allocation Basis: FY 20-21 Total FTEs per Fund/Department Source of Allocation: City Staff Roster 20-21 Pay-benefitsA.xlsx Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
9 - Allocations

Page 132 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-174- Payroll

ALLOCABLE BUDGET UNITS
BLDG- Building Use $ - $ - EQUIP- Equipment Use - - 0001-131- City Manager's Office 1,581 1,581 0001-141- City Clerk 1,581 1,581 0001-151- City Attorney 4,347 4,347 0001-171- Finance Administration 1,186 1,186 0001-172- Accounting 2,767 2,767 0001-173- Budget/Operating 1,581 1,581 0001-174- Payroll 1,186 1,186 0001-175- Treasury/Cash Management 1,918 1,918 0001-176- Accounts Payable 959 959 0001-177- Rev Collection 2,398 2,398 0001-178- Purchasing 959 959 0001-181- Human Resources 6,234 6,234 0001-232- Facility Maintenance and Administration 16,303 16,303 0001-235- Equipment Services/Fleet Services 6,234 6,234 0001-261- Information Technology Administration 1,918 1,918 0001-262- Telecommunications 1,918 1,918 0001-263- IT/Mailroom and Duplication, GIS, ERP and Desktop 480 480 0001-907, 908- Non-Departmental - - - - -
- - -
- - -
- - -
- - -

RECEIVING BUDGET UNITS
0001-101- OFFICE OF THE MAYOR 1,439 1,439 0001-105- COUNCIL/CITY COUNCIL DIV 5,275 5,275 0001-121- POLICE COMMISSION DIV 959 959 0001-132- CM-SPCIAL PROJS/ENVIRONMENTAL - - 0001-163- GF-PLN/CODE ENFORCEMENT (DIV) 2,877 2,877 0001-191- GF-POLICE ADMIN DIV 95,423 95,423 0001-192- GF-POLICE-PATROL/CIB - - 0001-193- GF-POLICE/CRIME PREVENTION 959 959 0001-194- GF-POLICE-COPS GRANT 480 480 0001-196- GF-POLICE/REGULATORY 959 959 0001-197- CAD DISPATCH SYST/COMM POL DIV 12,467 12,467 0001-199- GF-PARKING ENFORCEMENT DIV 480 480 0001-201- GF-FIRE/ADMIN DIV 1,918 1,918 0001-202- GF-FIRE/SUPRESSN DIV 39,320 39,320 0001-203- GF-FIRE PREVENTION DIV 3,357 3,357 0001-204- GF-FIRE/ SUPPORT DIV - - 0001-205- GF-FIRE/TRAINING DIV 480 480 0001-206- GF-FIRE/OF. OF EMS DIV 959 959 0001-211- OF. OF NB-HOOD SFTY ADMIN DIV 8,152 8,152 0001-212- OFF OF N-HOOD SFTY/GRANT ADM - - 0001-231- GF-PW ADMIN-DIV 3,357 3,357 0001-233- GF-PRKS&LNDSKP/PRKS (S-DIV) 17,262 17,262 0001-234- IT GIS 13,906 13,906

ALLOCATION SUMMARY
Total
Citywide Payroll
Services
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
9 - Summary

Page 133 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-174- Payroll

ALLOCATION SUMMARY
Total
Citywide Payroll
Services
0001-237- GF-I&M/ABATEMENT SVCS (DIV) 7,672 7,672 0001-238- GF-I&M/CODE ENFORCEMENT (DIV) 480 480 0001-239- GF-I&M/PROP/ASSETS MNGT (DIV) - - 0001-241- GF-LIB&CL SVC/L-ADM DIV 19,181 19,181 0001-242- GF-LS/REF SVCS(S-DIV) - - 0001-243- GF-LIB&CL SVCS/LEAP DIV 4,795 4,795 0001-244- GF-LIB&CL SVC/P-ART DIV - - 0001-251- GF-RECREATION ADM DIV 7,193 7,193 0001-253- CM&NB/BOOKER T CTR (S-DIV) 17,262 17,262 0001-255- GF-CM TRANSPORTATN OPERATIONS 959 959 0001-254- GF-REC/SPCL EVENTS (S-DIV) 4,795 4,795 0001-256- RECREATION SVCS/AQUATICS 17,742 17,742 0001-257- RECREATION SVCS/CONVENTION CTR 1,918 1,918 0001-259- RECREATION SVCS/PLUNGE 480 480 0001-260- RECREATION SVCS/CITIES OF SRVC 959 959 0001-291- GF-ADMINISTRATIVE SERVICES 480 480 0001-292- GF-STREET SWEEPING 480 480 0001-361- GF ECON DEV/SP PRJ-ENVIRONMNTL 1,439 1,439 0001-362- GF ECON DEV/SP PRJ-ENVIRONMNTL 480 480 0001-364- GF-ECON DEV/PUBLIC ART DIV 480 480 0001-369- GF-ECON DEV/REAL ESTATE (DIV) 959 959 0001-371- INTERNAL SERVICES-ADMIN 959 959 0001-910- GF-NON-DEPT/CITY FESTIVAL - - 1001- SECURED PENSION OVERRIDE - - 1002- STATE GAS TAX - - 1003- TRANSPORTATION OPERATIONS 1,918 1,918 1004- ASSET SEIZURE FUND - - 1005- LIBRARY FUND - - 1006- OUTSIDE FUNDED SVCS - GRANTS - - 1007- EMERGENCY MED SERV - - 1010- N.RICHMOND WASTE - - 1012- HILLTOP LANDSCAPE MAINT DIST 6,234 6,234 1013- FIRE DEPT HAZMAT GRANT - - 1014- EDA GRANT FUND - - 1015- MARINA BAY LNDSCP&LIGHTDIST FD 5,754 5,754 1017- CHEVRON MODERNIZATN PROJ & CIA - - 1018- RENT CONTROL 6,234 6,234 1019- SBI RMRA CAP IMPROVEMENT - - 1050- CR-PLANNING & BUILDING 11,508 11,508 1051- CR-ENGINEERING - - 1053- CODE ENFORCEMENT-CR - - 1054- ENGINEERING GRANTS - - 1055- ENCROACHMENTS SVCS 3,836 3,836 1200- COR HOUSING ADMINISTRATION 1,439 1,439 1201- CDBG - - 1203- NEIGHBORHOOD STABILIZATION - - 1205- EMPLOYMENT & TRAINING 8,152 8,152 1207- NEIGHBORHOOD STAB(CITY) - - 1208- SUCCESSOR HOUSING AGNCY - - 1209- CAL-HOME - - Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
9 - Summary

Page 134 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-174- Payroll

ALLOCATION SUMMARY
Total
Citywide Payroll
Services
1302- HOUSNG IN LIEU FEE - DEVELOPER - - 1303- KIDS FIRST INITIATIVE 1,439 1,439 1304- EMERGENCY OPE & DISASTR RECVRY - - 2001- GENERAL CAPITAL FUND - - 2002- MEASURE J - - 2110- IMPACT FEE - PARK - - 2111- PF IMP FEES-TRAFFIC/ROAD-ENG - - 2113- IMPACT FEE - FIRE - - 2114- IMPACT FEE - POLICE - - 2115- IMPACT FEE - COMM/AQUATC - - 2116- IMPACT FEE - PARKS/OPEN - - 2117- IMPACT FEE - LIBRARY - - 2119- IMPACT FEE - STORM DRAINAGE - - 2120- IMPACT FEE - WASTEWATER - - 2125- IRON TRIANGLE/EPA PROGRAMS - - 2126- COR-HOUSING DEPT CIP FUND - - 3001- DS - 2005 TAXABLE POB - - 3002- DS - 99A PENSION OBLIG BOND - - 3005- DS - 2007 CIVIC CENTER - - 4001- PORT OF RICHMOND 1,439 1,439 4003- WASTEWATER 4,316 4,316 4005- MARINA - - 4006- STORM WATER - - 4008- KCRT - CABLE TELEVIS 1,918 1,918 4101- RHA-HSNG CHOICE VOUCHER-SEC 8 - - 4102- RHA-HOPE 6 - - 4201- RHA-CAPITAL FUND - - 4401- RHA-HACIENDA - - 4404- RHA-NEVIN PLAZA 959 959 4405- RHA-NYSTROM VILLAGE 480 480 4406- RHA-RICHMOND VILLAGE ONE - - 4407- RHA-RICHMOND VILLAGE TWO - - 4408- RHA-RICHMOND VILLAGE THREE - - 4501- RHA-CENTRAL OFFICE COST CNTR 480 480 4502- RHA-HOUSING (RAD) CORPORATION - - 5001- INSURANCE RESERVES 2,398 2,398 5003- EQUIPMENT SERVICES - - 5005- CAD DISPATCH SYSTEM 480 480 5006- RMS RECORDS SERVICES - - 5008- COMPENSATED ABSENCES - - 6001- GENERAL TRUST & AGENCY - - 6004- COMMISSION ON AGING - - 6005- SEAVER GALLERY TRUST FUND - - 6007- SENIOR TRUST DEPOSIT - - 6047- CERTBT PLAN FUND - - 6048- OPEB PLAN TRUST - - 6049- PT MOLATE PRIVATE-PURPOSE TRST - - 6050- GENERAL PENSION FUND 3,357 3,357 6051- POLICE & FIRE PENSION 11,508 11,508 6052- GARFIELD PENSION FUND 480 480 Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
9 - Summary

Page 135 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-174- Payroll

ALLOCATION SUMMARY
Total
Citywide Payroll
Services
6058- MARINA WESTSHORE DEB - - 6059- COUNTRY CLUB VISTA - - 6060- REASSESSMENT DISTRICT 2003-1 - - 6101- SA-PROPERTY TAX TRUST FUND - - 6102- SA- ADMINISTRATION - - 6103- SA - CAPITAL PROJECT FUNDS - - 6208- SA-CIP 07B TARB BND PRCDS-HSG - - 6300- SA-DS HARBOR 98 TARB - - 6304- SA-DS 2003B TARB - - 6305- SA-DS 2004A TARB 2/3 - - 6306- SA-DS 2004A TARB -1/3 HSING - - 6307- SA-DS 2004B TARB - HOUSING - - 6308- SA-DS 2007/10A TARB - - 6309- SA-DS 2007/10B TARB - HOUSING - - 6401- SA-DS 2014A NON-TAXABLE BONDS - - 6402- SA-DS 2014B TAXABLE BONDS - - 6403- SA-DS LOANS PAYABLE - - 6404- SA-DS 2021A NON-TAXABLE BONDS is new - - 6405- SA-DS 2021B TAXABLE BONDS is new - - 6996- SUCCESSOR AGENCY - GLTDAG - - 9102- CITY OF RICHMOND - GFAAG - -

AO- ALL OTHER - - Total $ 426,609 $ 426,609
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
9 - Summary

Page 136 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-175- Treasury/Cash Management
Distribution Percentage 95.00% 5.00%
Expense Type $
Personnel
400002 - SALARIES & WAGES/Mgmt-Local 21 138,816$ S 131,875$ 6,941$ 400003 - SALARIES & WAGES/Local 1021 149,566 S 142,087 7,478 400031 - OVERTIME/General 953 S 906 48
400050 - OTHER PAY/Medical Flex 2,400 S 2,280 120
400103 - P-ROLL BEN/Medicare Tax-ER Shr 4,290 S 4,075 214 400105 - P-ROLL BEN/Health Insurance Be 27,312 S 25,947 1,366 400106 - P-ROLL BEN/Dental Insurance 6,184 S 5,875 309
400109 - P-ROLL BEN/Employee Assistance 149 S 141 7
400110 - P-ROLL BEN/Professional Dev-Mg 750 S 713 38
400111 - P-ROLL BEN/Vision 723 S 687 36
400112 - P-ROLL BEN/Life Insurance 736 S 699 37
400114 - P-ROLL BEN/Long Term Disabilit 2,556 S 2,429 128 400116 - P-ROLL BEN/Unemployment Ins 1,503 S 1,428 75
400117 - P-ROLL BEN/Personal/Prof Dev 2,250 S 2,138 113 400121 - P-ROLL BEN/Worker Comp-Clerica 16,662 S 15,829 833 400122 - P-ROLL BEN/Worker Comp-Prof 12,417 S 11,796 621 400127 - P-ROLL BEN/OPEB 11,787 S 11,198 589
400149 - P-ROLL BEN/PERS-Misc 38,572 S 36,644 1,929
400151 - P-ROLL BEN/PERS-Misc (UAL) 90,221 S 85,710 4,511 Subtotal Personnel Cost 507,848$ 482,456$ 25,392$
Operating Services & Supplies
400201 - PROF SVCS/Professional Svcs 61,499$ S 58,424$ 3,075$ 400246 - TRAVEL & TRNG/Registration Fee 150 S 143 8
400592 - COST POOL/(CON)-Admin Charges (97,005) S (92,155) (4,850) Subtotal Operating Cost (35,357)$ (33,589)$ (1,768)$
Disallowed Expenses / Adjustments
400592 - COST POOL/(CON)-Admin Charges 97,005$ [1] 92,155$ 4,850$ Subtotal Disallowed Costs 97,005$ 92,155$ 4,850$
DEPARTMENTAL EXPENDITURES 569,497$ 541,022$ 28,475$
Reallocation of Incoming Costs
First Allocation 14,101$ 554,418$ 29,180$
Unallocated Costs -$ -$ -$
Subtotal of First Allocation 14,101$ 554,418$ 29,180$
Second Allocation 101,174$ 96,115$ 5,059$
Unallocated Costs -$ -$ -$
Subtotal of Second Allocation 101,174$ 96,115$ 5,059$
TOTAL FUNCTIONAL COSTS 684,772$ 650,533$ 34,239$
[1] Admin charges are excluded and re-established through this CAP analysis Notes

DEPARTMENTAL EXPENSE DETAIL
Spread
Method
Citywide
Support
Investment
Managemen
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
10 - EXP

Page 137 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-175- Treasury/Cash Management First Second
Allocation Allocation Total
Departmental Expenditures $ 569,497 $ 569,497 Incoming Costs
BLDG- Building Use $ - $ - $ - EQUIP- Equipment Use - - - 0001-131- City Manager's Office 1,786 385 2,171 0001-141- City Clerk 1,746 335 2,080 0001-151- City Attorney 3,959 748 4,707 0001-171- Finance Administration 1,704 426 2,130 0001-172- Accounting 2,279 345 2,625 0001-173- Budget/Operating 1,046 213 1,260 0001-174- Payroll 1,581 337 1,918 0001-175- Treasury/Cash Management 560 560 0001-176- Accounts Payable 218 218 0001-177- Rev Collection 714 714 0001-178- Purchasing - - 0001-181- Human Resources 8,843 8,843 0001-232- Facility Maintenance and Administration - - 0001-235- Equipment Services/Fleet Services 15,627 15,627 0001-261- Information Technology Administration 8,586 8,586 0001-262- Telecommunications 8,065 8,065 0001-263- IT/Mailroom and Duplication, GIS, ERP and Desktop - - 0001-907, 908- Non-Departmental 55,770 55,770 - - -
- - -
- - -
- - -
- - -
Total Incoming Costs $ 14,101 $ 101,174 $ 115,275 Total Costs to be Allocated $ 583,598 $ 101,174 $ 684,772

COSTS TO BE ALLOCATED
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
10 - Costs

Page 138 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total Citywide Support Services 10.1

ALLOCABLE BUDGET UNITS
BLDG- Building Use - 0.000% $ - $ - $ - EQUIP- Equipment Use - 0.000% - - - 0001-131- City Manager's Office 112,454 0.366% 2,031.33 2,031.33 2,031.33 0001-141- City Clerk 235,055 0.766% 4,246 4,246 4,246 0001-151- City Attorney 105,086 0.342% 1,898.23 1,898.23 1,898.23 0001-171- Finance Administration 31,813 0.104% 575 575 575 0001-172- Accounting 3,145 0.010% 57 57 57 0001-173- Budget/Operating 62,638 0.204% 1,131.46 1,131.46 1,131.46 0001-174- Payroll - 0.000% - - - 0001-175- Treasury/Cash Management 31,004 0.101% 560 560 560 0001-176- Accounts Payable - 0.000% - - - - 0001-177- Rev Collection 214,808 0.700% 3,880 3,880 686 4,566 0001-178- Purchasing - 0.000% - - - - 0001-181- Human Resources 447,720 1.459% 8,087 8,087 1,429.12 9,517 0001-232- Facility Maintenance and Administration 1,228,687 4.003% 22,194.51 22,194.51 3,921.95 26,116.46 0001-235- Equipment Services/Fleet Services 700,541 2.282% 12,654.29 12,654.29 2,236.12 14,890.40 0001-261- Information Technology Administration 873,193 2.845% 15,773 15,773 2,787 18,560 0001-262- Telecommunications 1,176,070 3.832% 21,244.06 21,244.06 3,754 24,998 0001-263- IT/Mailroom and Duplication, GIS, ERP and Desktop 87,753 0.286% 1,585 1,585 280 1,865 0001-907, 908- Non-Departmental 1,208,995 3.939% 21,838.79 21,838.79 3,859 25,698 - - 0.000% - - - -

RECEIVING BUDGET UNITS
0001-101- OFFICE OF THE MAYOR 1,482 0.005% 26.78 26.78 4.73 32 0001-105- COUNCIL/CITY COUNCIL DIV 9,139 0.030% 165.08 165.08 29.17 194.25 0001-121- POLICE COMMISSION DIV 66 0.000% 1.19 1.19 0.21 1.40 0001-132- CM-SPCIAL PROJS/ENVIRONMENTAL - 0.000% - - - - 0001-163- GF-PLN/CODE ENFORCEMENT (DIV) 62,697 0.204% 1,132.54 1,132.54 200.13 1,332.67 0001-191- GF-POLICE ADMIN DIV 3,354,699 10.930% 60,597.93 60,597.93 10,708.15 71,306.09 0001-192- GF-POLICE-PATROL/CIB - 0.000% - - - - 0001-193- GF-POLICE/CRIME PREVENTION - 0.000% - - - - 0001-194- GF-POLICE-COPS GRANT - 0.000% - - - - 0001-196- GF-POLICE/REGULATORY 1,337 0.004% 24.15 24.15 4.27 28.42 0001-197- CAD DISPATCH SYST/COMM POL DIV 25,392 0.083% 458.67 458.67 81.05 539.72 0001-199- GF-PARKING ENFORCEMENT DIV - 0.000% - - - - 0001-201- GF-FIRE/ADMIN DIV 6,500 0.021% 117.41 117.41 20.75 138.16 0001-202- GF-FIRE/SUPRESSN DIV - 0.000% - - - - 0001-203- GF-FIRE PREVENTION DIV 43,978 0.143% 794 794 140.38 935 0001-204- GF-FIRE/ SUPPORT DIV 76,583 0.250% 1,383 1,383 244 1,628 0001-205- GF-FIRE/TRAINING DIV 416 0.001% 8 8 1 9 0001-206- GF-FIRE/OF. OF EMS DIV 800 0.003% 14 14 3 17 0001-211- OF. OF NB-HOOD SFTY ADMIN DIV 75,047 0.245% 1,356 1,356 240 1,595 0001-212- OFF OF N-HOOD SFTY/GRANT ADM 174,387 0.568% 3,150 3,150 556.64 3,707 0001-231- GF-PW ADMIN-DIV 482,746 1.573% 8,720.13 8,720.13 1,540.92 10,261.05 0001-233- GF-PRKS&LNDSKP/PRKS (S-DIV) 314,787 1.026% 5,686 5,686 1,004.80 6,691 0001-234- IT GIS 24,954 0.081% 451 451 80 530 0001-237- GF-I&M/ABATEMENT SVCS (DIV) 25,952 0.085% 469 469 83 552 0001-238- GF-I&M/CODE ENFORCEMENT (DIV) 2,118 0.007% 38.27 38.27 6.76 45.03 0001-239- GF-I&M/PROP/ASSETS MNGT (DIV) 24,811 0.081% 448 448 79 527 0001-241- GF-LIB&CL SVC/L-ADM DIV 47,047 0.153% 849.83 849.83 150.17 1,000 0001-242- GF-LS/REF SVCS(S-DIV) 215,112 0.701% 3,886 3,886 687 4,572 0001-175- Treasury/Cash Management
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
10 - Allocations

Page 139 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total 0001-175- Treasury/Cash Management
0001-243- GF-LIB&CL SVCS/LEAP DIV 6,608 0.022% 119 119 21.09 140 0001-244- GF-LIB&CL SVC/P-ART DIV 22,994 0.075% 415 415 73.40 489 0001-251- GF-RECREATION ADM DIV 23,878 0.078% 431 431 76 508 0001-253- CM&NB/BOOKER T CTR (S-DIV) 11,453 0.037% 206.88 206.88 36.56 243.44 0001-255- GF-CM TRANSPORTATN OPERATIONS 1,243 0.004% 22 22 4 26 0001-254- GF-REC/SPCL EVENTS (S-DIV) 187 0.001% 3 3 1 4 0001-256- RECREATION SVCS/AQUATICS 2,454 0.008% 44 44 8 52 0001-257- RECREATION SVCS/CONVENTION CTR 2,738 0.009% 49 49 8.74 58 0001-259- RECREATION SVCS/PLUNGE 1,527 0.005% 28 28 4.87 32 0001-260- RECREATION SVCS/CITIES OF SRVC 30,838 0.100% 557.04 557.04 98.43 655.47 0001-291- GF-ADMINISTRATIVE SERVICES 23,166 0.075% 418.46 418.46 73.95 492.41 0001-292- GF-STREET SWEEPING 1,884 0.006% 34.03 34.03 6.01 40.04 0001-361- GF ECON DEV/SP PRJ-ENVIRONMNTL 17,614 0.057% 318 318 56 374 0001-362- GF ECON DEV/SP PRJ-ENVIRONMNTL 126,910 0.413% 2,292 2,292 405 2,698 0001-364- GF-ECON DEV/PUBLIC ART DIV 24,148 0.079% 436 436 77 513 0001-369- GF-ECON DEV/REAL ESTATE (DIV) 68,527 0.223% 1,238 1,238 219 1,457 0001-371- INTERNAL SERVICES-ADMIN 26,699 0.087% 482 482 85 568 0001-910- GF-NON-DEPT/CITY FESTIVAL - 0.000% - - - - 1001- SECURED PENSION OVERRIDE - 0.000% - - - - 1002- STATE GAS TAX 1,358,550 4.426% 24,540 24,540 4,336 28,877 1003- TRANSPORTATION OPERATIONS 44,339 0.144% 801 801 142 942 1004- ASSET SEIZURE FUND 37,811 0.123% 683 683 121 804 1005- LIBRARY FUND 28,742 0.094% 519 519 92 611 1006- OUTSIDE FUNDED SVCS - GRANTS 326,953 1.065% 5,906 5,906 1,044 6,950 1007- EMERGENCY MED SERV 53,928 0.176% 974 974 172 1,146 1010- N.RICHMOND WASTE 660 0.002% 12 12 2 14 1012- HILLTOP LANDSCAPE MAINT DIST 111,023 0.362% 2,005 2,005 354 2,360 1013- FIRE DEPT HAZMAT GRANT 19,840 0.065% 358 358 63 422 1014- EDA GRANT FUND - 0.000% - - - - 1015- MARINA BAY LNDSCP&LIGHTDIST FD 46,688 0.152% 843 843 149 992 1017- CHEVRON MODERNIZATN PROJ & CIA 785,388 2.559% 14,187 14,187 2,507 16,694 1018- RENT CONTROL 28,345 0.092% 512 512 90 602 1019- SBI RMRA CAP IMPROVEMENT 89,741 0.292% 1,621 1,621 286 1,907 1050- CR-PLANNING & BUILDING 4,338,861 14.137% 78,375 78,375 13,850 92,225 1051- CR-ENGINEERING 101,265 0.330% 1,829 1,829 323 2,152 1053- CODE ENFORCEMENT-CR 5,043 0.016% 91 91 16 107 1054- ENGINEERING GRANTS 216,561 0.706% 3,912 3,912 691 4,603 1055- ENCROACHMENTS SVCS 17,613 0.057% 318 318 56 374 1200- COR HOUSING ADMINISTRATION 34,702 0.113% 627 627 111 738 1201- CDBG 51,254 0.167% 926 926 164 1,089 1203- NEIGHBORHOOD STABILIZATION - 0.000% - - - - 1205- EMPLOYMENT & TRAINING 331,312 1.079% 5,985 5,985 1,058 7,042 1207- NEIGHBORHOOD STAB(CITY) 13,455 0.044% 243 243 43 286 1208- SUCCESSOR HOUSING AGNCY 6,213 0.020% 112 112 20 132 1209- CAL-HOME - 0.000% - - - - 1302- HOUSNG IN LIEU FEE - DEVELOPER - 0.000% - - - - 1303- KIDS FIRST INITIATIVE 151,882 0.495% 2,744 2,744 485 3,228 1304- EMERGENCY OPE & DISASTR RECVRY 457,232 1.490% 8,259 8,259 1,459 9,719 2001- GENERAL CAPITAL FUND 684,607 2.231% 12,366 12,366 2,185 14,552 2002- MEASURE J 1,080,867 3.522% 19,524 19,524 3,450 22,974 2110- IMPACT FEE - PARK 15,000 0.049% 271 271 48 319 2111- PF IMP FEES-TRAFFIC/ROAD-ENG 84,645 0.276% 1,529 1,529 270 1,799 Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
10 - Allocations

Page 140 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total 0001-175- Treasury/Cash Management
2113- IMPACT FEE - FIRE 35,977 0.117% 650 650 115 765 2114- IMPACT FEE - POLICE - 0.000% - - - - 2115- IMPACT FEE - COMM/AQUATC 245,653 0.800% 4,437 4,437 784 5,221 2116- IMPACT FEE - PARKS/OPEN 48,359 0.158% 874 874 154 1,028 2117- IMPACT FEE - LIBRARY - 0.000% - - - - 2119- IMPACT FEE - STORM DRAINAGE - 0.000% - - - - 2120- IMPACT FEE - WASTEWATER - 0.000% - - - - 2125- IRON TRIANGLE/EPA PROGRAMS 203,124 0.662% 3,669 3,669 648 4,318 2126- COR-HOUSING DEPT CIP FUND - 0.000% - - - - 3001- DS - 2005 TAXABLE POB - 0.000% - - - - 3002- DS - 99A PENSION OBLIG BOND - 0.000% - - - - 3005- DS - 2007 CIVIC CENTER - 0.000% - - - - 4001- PORT OF RICHMOND 502,969 1.639% 9,085 9,085 1,605 10,691 4003- WASTEWATER 1,433,083 4.669% 25,887 25,887 4,574 30,461 4005- MARINA - 0.000% - - - - 4006- STORM WATER 377,796 1.231% 6,824 6,824 1,206 8,030 4008- KCRT - CABLE TELEVIS 2,418 0.008% 44 44 8 51 4101- RHA-HSNG CHOICE VOUCHER-SEC 8 - 0.000% - - - - 4102- RHA-HOPE 6 - 0.000% - - - - 4201- RHA-CAPITAL FUND 99,426 0.324% 1,796 1,796 317 2,113 4401- RHA-HACIENDA - 0.000% - - - - 4404- RHA-NEVIN PLAZA 624 0.002% 11 11 2 13 4405- RHA-NYSTROM VILLAGE - 0.000% - - - - 4406- RHA-RICHMOND VILLAGE ONE - 0.000% - - - - 4407- RHA-RICHMOND VILLAGE TWO - 0.000% - - - - 4408- RHA-RICHMOND VILLAGE THREE - 0.000% - - - - 4501- RHA-CENTRAL OFFICE COST CNTR 15,767 0.051% 285 285 50 335 4502- RHA-HOUSING (RAD) CORPORATION - 0.000% - - - - 5001- INSURANCE RESERVES 2,381,121 7.758% 43,012 43,012 7,601 50,612 5003- EQUIPMENT SERVICES 2,180,511 7.104% 39,388 39,388 6,960 46,348 5005- CAD DISPATCH SYSTEM 1,200 0.004% 22 22 4 26 5006- RMS RECORDS SERVICES - 0.000% - - - - 5008- COMPENSATED ABSENCES - 0.000% - - - - 6001- GENERAL TRUST & AGENCY - 0.000% - - - - 6004- COMMISSION ON AGING 115 0.000% 2 2 0 2 6005- SEAVER GALLERY TRUST FUND - 0.000% - - - - 6007- SENIOR TRUST DEPOSIT 5,829 0.019% 105 105 19 124 6047- CERTBT PLAN FUND - 0.000% - - - - 6048- OPEB PLAN TRUST - 0.000% - - - - 6049- PT MOLATE PRIVATE-PURPOSE TRST - 0.000% - - - - 6050- GENERAL PENSION FUND - 0.000% - - - - 6051- POLICE & FIRE PENSION - 0.000% - - - - 6052- GARFIELD PENSION FUND - 0.000% - - - - 6058- MARINA WESTSHORE DEB - 0.000% - - - - 6059- COUNTRY CLUB VISTA - 0.000% - - - - 6060- REASSESSMENT DISTRICT 2003-1 - 0.000% - - - - 6101- SA-PROPERTY TAX TRUST FUND - 0.000% - - - - 6102- SA- ADMINISTRATION 50,949 0.166% 920 920 163 1,083 6103- SA - CAPITAL PROJECT FUNDS 703,253 2.291% 12,703 12,703 2,245 14,948 6208- SA-CIP 07B TARB BND PRCDS-HSG - 0.000% - - - - 6300- SA-DS HARBOR 98 TARB - 0.000% - - - - 6304- SA-DS 2003B TARB - 0.000% - - - - Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
10 - Allocations

Page 141 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total 0001-175- Treasury/Cash Management
6305- SA-DS 2004A TARB 2/3 - 0.000% - - - - 6306- SA-DS 2004A TARB -1/3 HSING - 0.000% - - - - 6307- SA-DS 2004B TARB - HOUSING - 0.000% - - - - 6308- SA-DS 2007/10A TARB - 0.000% - - - - 6309- SA-DS 2007/10B TARB - HOUSING - 0.000% - - - - 6401- SA-DS 2014A NON-TAXABLE BONDS - 0.000% - - - - 6402- SA-DS 2014B TAXABLE BONDS - 0.000% - - - - 6403- SA-DS LOANS PAYABLE - 0.000% - - - - 6404- SA-DS 2021A NON-TAXABLE BONDS is new - 0.000% - - - - 6405- SA-DS 2021B TAXABLE BONDS is new - 0.000% - - - - 6996- SUCCESSOR AGENCY - GLTDAG - 0.000% - - - - 9102- CITY OF RICHMOND - GFAAG - 0.000% - - - - AO- ALL OTHER - 0.000% - - - - Total 30,692,572 100.000% $ 554,418 $ - $ 554,418 $ 96,115 $ 650,533 Allocation Basis: FY 20-21 Total Revenues Received per Fund/Department Source of Allocation: ap017 - check register extract 7.01.21-6.30.21.xls Investment Management 10.2
Total - 0.000% $ - $ - $ - $ - $ - Allocation Basis: Not Allocated
Source of Allocation: N/A
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
10 - Allocations

Page 142 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-175- Treasury/Cash Management

ALLOCABLE BUDGET UNITS
BLDG- Building Use $ - $ - $ - EQUIP- Equipment Use - - - 0001-131- City Manager's Office 2,031 - 2,031 0001-141- City Clerk 4,246 - 4,246 0001-151- City Attorney 1,898 - 1,898 0001-171- Finance Administration 575 - 575 0001-172- Accounting 57 - 57 0001-173- Budget/Operating 1,131 - 1,131 0001-174- Payroll - - - 0001-175- Treasury/Cash Management 560 - 560 0001-176- Accounts Payable - - - 0001-177- Rev Collection 4,566 - 4,566 0001-178- Purchasing - - - 0001-181- Human Resources 9,517 - 9,517 0001-232- Facility Maintenance and Administration 26,116 - 26,116 0001-235- Equipment Services/Fleet Services 14,890 - 14,890 0001-261- Information Technology Administration 18,560 - 18,560 0001-262- Telecommunications 24,998 - 24,998 0001-263- IT/Mailroom and Duplication, GIS, ERP and Desktop 1,865 - 1,865 0001-907, 908- Non-Departmental 25,698 - 25,698 - - - - - - - - - - - - - - - - - - - -

RECEIVING BUDGET UNITS
0001-101- OFFICE OF THE MAYOR 32 - 32 0001-105- COUNCIL/CITY COUNCIL DIV 194 - 194 0001-121- POLICE COMMISSION DIV 1 - 1 0001-132- CM-SPCIAL PROJS/ENVIRONMENTAL - - - 0001-163- GF-PLN/CODE ENFORCEMENT (DIV) 1,333 - 1,333 0001-191- GF-POLICE ADMIN DIV 71,306 - 71,306 0001-192- GF-POLICE-PATROL/CIB - - - 0001-193- GF-POLICE/CRIME PREVENTION - - - 0001-194- GF-POLICE-COPS GRANT - - - 0001-196- GF-POLICE/REGULATORY 28 - 28 0001-197- CAD DISPATCH SYST/COMM POL DIV 540 - 540 0001-199- GF-PARKING ENFORCEMENT DIV - - - 0001-201- GF-FIRE/ADMIN DIV 138 - 138 0001-202- GF-FIRE/SUPRESSN DIV - - - 0001-203- GF-FIRE PREVENTION DIV 935 - 935 0001-204- GF-FIRE/ SUPPORT DIV 1,628 - 1,628 0001-205- GF-FIRE/TRAINING DIV 9 - 9 0001-206- GF-FIRE/OF. OF EMS DIV 17 - 17 0001-211- OF. OF NB-HOOD SFTY ADMIN DIV 1,595 - 1,595 0001-212- OFF OF N-HOOD SFTY/GRANT ADM 3,707 - 3,707 0001-231- GF-PW ADMIN-DIV 10,261 - 10,261 0001-233- GF-PRKS&LNDSKP/PRKS (S-DIV) 6,691 - 6,691 Investment
Management

ALLOCATION SUMMARY
Total
Citywide
Support
Services
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
10 - Summary

Page 143 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-175- Treasury/Cash Management
Investment
Management

ALLOCATION SUMMARY
Total
Citywide
Support
Services
0001-234- IT GIS 530 - 530 0001-237- GF-I&M/ABATEMENT SVCS (DIV) 552 - 552 0001-238- GF-I&M/CODE ENFORCEMENT (DIV) 45 - 45 0001-239- GF-I&M/PROP/ASSETS MNGT (DIV) 527 - 527 0001-241- GF-LIB&CL SVC/L-ADM DIV 1,000 - 1,000 0001-242- GF-LS/REF SVCS(S-DIV) 4,572 - 4,572 0001-243- GF-LIB&CL SVCS/LEAP DIV 140 - 140 0001-244- GF-LIB&CL SVC/P-ART DIV 489 - 489 0001-251- GF-RECREATION ADM DIV 508 - 508 0001-253- CM&NB/BOOKER T CTR (S-DIV) 243 - 243 0001-255- GF-CM TRANSPORTATN OPERATIONS 26 - 26 0001-254- GF-REC/SPCL EVENTS (S-DIV) 4 - 4 0001-256- RECREATION SVCS/AQUATICS 52 - 52 0001-257- RECREATION SVCS/CONVENTION CTR 58 - 58 0001-259- RECREATION SVCS/PLUNGE 32 - 32 0001-260- RECREATION SVCS/CITIES OF SRVC 655 - 655 0001-291- GF-ADMINISTRATIVE SERVICES 492 - 492 0001-292- GF-STREET SWEEPING 40 - 40 0001-361- GF ECON DEV/SP PRJ-ENVIRONMNTL 374 - 374 0001-362- GF ECON DEV/SP PRJ-ENVIRONMNTL 2,698 - 2,698 0001-364- GF-ECON DEV/PUBLIC ART DIV 513 - 513 0001-369- GF-ECON DEV/REAL ESTATE (DIV) 1,457 - 1,457 0001-371- INTERNAL SERVICES-ADMIN 568 - 568 0001-910- GF-NON-DEPT/CITY FESTIVAL - - - 1001- SECURED PENSION OVERRIDE - - - 1002- STATE GAS TAX 28,877 - 28,877 1003- TRANSPORTATION OPERATIONS 942 - 942 1004- ASSET SEIZURE FUND 804 - 804 1005- LIBRARY FUND 611 - 611 1006- OUTSIDE FUNDED SVCS - GRANTS 6,950 - 6,950 1007- EMERGENCY MED SERV 1,146 - 1,146 1010- N.RICHMOND WASTE 14 - 14 1012- HILLTOP LANDSCAPE MAINT DIST 2,360 - 2,360 1013- FIRE DEPT HAZMAT GRANT 422 - 422 1014- EDA GRANT FUND - - - 1015- MARINA BAY LNDSCP&LIGHTDIST FD 992 - 992 1017- CHEVRON MODERNIZATN PROJ & CIA 16,694 - 16,694 1018- RENT CONTROL 602 - 602 1019- SBI RMRA CAP IMPROVEMENT 1,907 - 1,907 1050- CR-PLANNING & BUILDING 92,225 - 92,225 1051- CR-ENGINEERING 2,152 - 2,152 1053- CODE ENFORCEMENT-CR 107 - 107 1054- ENGINEERING GRANTS 4,603 - 4,603 1055- ENCROACHMENTS SVCS 374 - 374 1200- COR HOUSING ADMINISTRATION 738 - 738 1201- CDBG 1,089 - 1,089 1203- NEIGHBORHOOD STABILIZATION - - - 1205- EMPLOYMENT & TRAINING 7,042 - 7,042 1207- NEIGHBORHOOD STAB(CITY) 286 - 286 Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
10 - Summary

Page 144 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-175- Treasury/Cash Management
Investment
Management

ALLOCATION SUMMARY
Total
Citywide
Support
Services
1208- SUCCESSOR HOUSING AGNCY 132 - 132 1209- CAL-HOME - - - 1302- HOUSNG IN LIEU FEE - DEVELOPER - - - 1303- KIDS FIRST INITIATIVE 3,228 - 3,228 1304- EMERGENCY OPE & DISASTR RECVRY 9,719 - 9,719 2001- GENERAL CAPITAL FUND 14,552 - 14,552 2002- MEASURE J 22,974 - 22,974 2110- IMPACT FEE - PARK 319 - 319 2111- PF IMP FEES-TRAFFIC/ROAD-ENG 1,799 - 1,799 2113- IMPACT FEE - FIRE 765 - 765 2114- IMPACT FEE - POLICE - - - 2115- IMPACT FEE - COMM/AQUATC 5,221 - 5,221 2116- IMPACT FEE - PARKS/OPEN 1,028 - 1,028 2117- IMPACT FEE - LIBRARY - - - 2119- IMPACT FEE - STORM DRAINAGE - - - 2120- IMPACT FEE - WASTEWATER - - - 2125- IRON TRIANGLE/EPA PROGRAMS 4,318 - 4,318 2126- COR-HOUSING DEPT CIP FUND - - - 3001- DS - 2005 TAXABLE POB - - - 3002- DS - 99A PENSION OBLIG BOND - - - 3005- DS - 2007 CIVIC CENTER - - - 4001- PORT OF RICHMOND 10,691 - 10,691 4003- WASTEWATER 30,461 - 30,461 4005- MARINA - - - 4006- STORM WATER 8,030 - 8,030 4008- KCRT - CABLE TELEVIS 51 - 51 4101- RHA-HSNG CHOICE VOUCHER-SEC 8 - - - 4102- RHA-HOPE 6 - - - 4201- RHA-CAPITAL FUND 2,113 - 2,113 4401- RHA-HACIENDA - - - 4404- RHA-NEVIN PLAZA 13 - 13 4405- RHA-NYSTROM VILLAGE - - - 4406- RHA-RICHMOND VILLAGE ONE - - - 4407- RHA-RICHMOND VILLAGE TWO - - - 4408- RHA-RICHMOND VILLAGE THREE - - - 4501- RHA-CENTRAL OFFICE COST CNTR 335 - 335 4502- RHA-HOUSING (RAD) CORPORATION - - - 5001- INSURANCE RESERVES 50,612 - 50,612 5003- EQUIPMENT SERVICES 46,348 - 46,348 5005- CAD DISPATCH SYSTEM 26 - 26 5006- RMS RECORDS SERVICES - - - 5008- COMPENSATED ABSENCES - - - 6001- GENERAL TRUST & AGENCY - - - 6004- COMMISSION ON AGING 2 - 2 6005- SEAVER GALLERY TRUST FUND - - - 6007- SENIOR TRUST DEPOSIT 124 - 124 6047- CERTBT PLAN FUND - - - 6048- OPEB PLAN TRUST - - - 6049- PT MOLATE PRIVATE-PURPOSE TRST - - - Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
10 - Summary

Page 145 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-175- Treasury/Cash Management
Investment
Management

ALLOCATION SUMMARY
Total
Citywide
Support
Services
6050- GENERAL PENSION FUND - - - 6051- POLICE & FIRE PENSION - - - 6052- GARFIELD PENSION FUND - - - 6058- MARINA WESTSHORE DEB - - - 6059- COUNTRY CLUB VISTA - - - 6060- REASSESSMENT DISTRICT 2003-1 - - - 6101- SA-PROPERTY TAX TRUST FUND - - - 6102- SA- ADMINISTRATION 1,083 - 1,083 6103- SA - CAPITAL PROJECT FUNDS 14,948 - 14,948 6208- SA-CIP 07B TARB BND PRCDS-HSG - - - 6300- SA-DS HARBOR 98 TARB - - - 6304- SA-DS 2003B TARB - - - 6305- SA-DS 2004A TARB 2/3 - - - 6306- SA-DS 2004A TARB -1/3 HSING - - - 6307- SA-DS 2004B TARB - HOUSING - - - 6308- SA-DS 2007/10A TARB - - - 6309- SA-DS 2007/10B TARB - HOUSING - - - 6401- SA-DS 2014A NON-TAXABLE BONDS - - - 6402- SA-DS 2014B TAXABLE BONDS - - - 6403- SA-DS LOANS PAYABLE - - - 6404- SA-DS 2021A NON-TAXABLE BONDS is new - - - 6405- SA-DS 2021B TAXABLE BONDS is new - - - 6996- SUCCESSOR AGENCY - GLTDAG - - - 9102- CITY OF RICHMOND - GFAAG - - -

AO- ALL OTHER - - - Total $ 650,533 $ - $ 650,533 Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
10 - Summary

Page 146 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-176- Accounts Payable
Distribution Percentage 100.00%
Expense Type $
Personnel
400003 - SALARIES & WAGES/Local 1021 133,152$ S 133,152$ 400103 - P-ROLL BEN/Medicare Tax-ER Shr 1,957 S 1,957
400105 - P-ROLL BEN/Health Insurance Be 18,154 S 18,154 400106 - P-ROLL BEN/Dental Insurance 3,477 S 3,477
400109 - P-ROLL BEN/Employee Assistance 84 S 84
400111 - P-ROLL BEN/Vision 406 S 406
400112 - P-ROLL BEN/Life Insurance 200 S 200
400114 - P-ROLL BEN/Long Term Disabilit 887 S 887
400116 - P-ROLL BEN/Unemployment Ins 845 S 845
400117 - P-ROLL BEN/Personal/Prof Dev 1,794 S 1,794
400121 - P-ROLL BEN/Worker Comp-Clerica 14,833 S 14,833 400127 - P-ROLL BEN/OPEB 5,461 S 5,461
400149 - P-ROLL BEN/PERS-Misc 17,867 S 17,867
400151 - P-ROLL BEN/PERS-Misc (UAL) 48,359 S 48,359
Subtotal Personnel Cost 247,478$ 247,478$
Operating Services & Supplies
400592 - COST POOL/(CON)-Admin Charges (46,986)$ S (46,986)$ Subtotal Operating Cost (46,986)$ (46,986)$
Disallowed Expenses
400592 - COST POOL/(CON)-Admin Charges 46,986$ [1] 46,986$ Subtotal Disallowed Costs 46,986$ 46,986$
DEPARTMENTAL EXPENDITURES 247,478$ 247,478$
Reallocation of Incoming Costs
First Allocation 6,433$ 253,911$
Unallocated Costs -$ -$
Subtotal of First Allocation 6,433$ 253,911$
Second Allocation 47,348$ 47,348$
Unallocated Costs -$ -$
Subtotal of Second Allocation 47,348$ 47,348$
TOTAL FUNCTIONAL COSTS 301,259$ 301,259$
[1] Admin charges are excluded and re-established through this CAP analysis

DEPARTMENTAL EXPENSE DETAIL
Notes
Spread
Method
Citywide
Accounts
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
11 - EXP

Page 147 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-176- Accounts Payable First Second
Allocation Allocation Total
Departmental Expenditures $ 247,478 $ 247,478 Incoming Costs
BLDG- Building Use $ - $ - $ - EQUIP- Equipment Use - - - 0001-131- City Manager's Office 854 184 1,038 0001-141- City Clerk 837 160 997 0001-151- City Attorney 1,895 358 2,254 0001-171- Finance Administration 740 185 926 0001-172- Accounting 862 131 992 0001-173- Budget/Operating 455 93 547 0001-174- Payroll 790 169 959 0001-175- Treasury/Cash Management - - - 0001-176- Accounts Payable - - 0001-177- Rev Collection - - 0001-178- Purchasing - - 0001-181- Human Resources 4,372 4,372 0001-232- Facility Maintenance and Administration - - 0001-235- Equipment Services/Fleet Services 7,813 7,813 0001-261- Information Technology Administration 2,453 2,453 0001-262- Telecommunications 4,033 4,033 0001-263- IT/Mailroom and Duplication, GIS, ERP and Desktop - - 0001-907, 908- Non-Departmental 27,397 27,397 - - -
- - -
- - -
- - -
- - -
Total Incoming Costs $ 6,433 $ 47,348 $ 53,781 Total Costs to be Allocated $ 253,911 $ 47,348 $ 301,259

COSTS TO BE ALLOCATED
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
11 - Costs

Page 148 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total Citywide Accounts Payable Services 11.1

ALLOCABLE BUDGET UNITS
BLDG- Building Use - 0.000% $ - $ - $ - EQUIP- Equipment Use - 0.000% - - - 0001-131- City Manager's Office 139 0.443% 1,125 1,125 1,125 0001-141- City Clerk 174 0.555% 1,408 1,408 1,408 0001-151- City Attorney 147 0.469% 1,190 1,190 1,190 0001-171- Finance Administration 149 0.475% 1,206 1,206 1,206 0001-172- Accounting 9 0.029% 73 73 73 0001-173- Budget/Operating 10 0.032% 81 81 81 0001-174- Payroll - 0.000% - - - 0001-175- Treasury/Cash Management 27 0.086% 218 218 218 0001-176- Accounts Payable - 0.000% - - - 0001-177- Rev Collection 43 0.137% 348 348 66 414 0001-178- Purchasing 8 0.025% 65 65 12 77 0001-181- Human Resources 299 0.953% 2,420 2,420 461 2,880 0001-232- Facility Maintenance and Administration 5,380 17.147% 43,538 43,538 8,292 51,830 0001-235- Equipment Services/Fleet Services 2,264 7.216% 18,321 18,321 3,489 21,811 0001-261- Information Technology Administration 177 0.564% 1,432 1,432 273 1,705 0001-262- Telecommunications 1,033 3.292% 8,360 8,360 1,592 9,952 0001-263- IT/Mailroom and Duplication, GIS, ERP and Desktop 86 0.274% 696 696 133 829 0001-907, 908- Non-Departmental 6,578 20.965% 53,233 53,233 10,138 63,371 - - 0.000% - - - - - - 0.000% - - - - - - 0.000% - - - - - - 0.000% - - - - - - 0.000% - - - -

RECEIVING BUDGET UNITS
0001-101- OFFICE OF THE MAYOR 18 0.057% 146 146 28 173 0001-105- COUNCIL/CITY COUNCIL DIV 145 0.462% 1,173 1,173 223 1,397 0001-121- POLICE COMMISSION DIV 7 0.022% 57 57 11 67 0001-132- CM-SPCIAL PROJS/ENVIRONMENTAL - 0.000% - - - - 0001-163- GF-PLN/CODE ENFORCEMENT (DIV) 112 0.357% 906 906 173 1,079 0001-191- GF-POLICE ADMIN DIV 1,734 5.527% 14,032 14,032 2,672 16,705 0001-192- GF-POLICE-PATROL/CIB - 0.000% - - - - 0001-193- GF-POLICE/CRIME PREVENTION 32 0.102% 259 259 49 308 0001-194- GF-POLICE-COPS GRANT - 0.000% - - - - 0001-196- GF-POLICE/REGULATORY 6 0.019% 49 49 9 58 0001-197- CAD DISPATCH SYST/COMM POL DIV 18 0.057% 146 146 28 173 0001-199- GF-PARKING ENFORCEMENT DIV - 0.000% - - - - 0001-201- GF-FIRE/ADMIN DIV 13 0.041% 105 105 20 125 0001-202- GF-FIRE/SUPRESSN DIV - 0.000% - - - - 0001-203- GF-FIRE PREVENTION DIV 138 0.440% 1,117 1,117 213 1,329 0001-204- GF-FIRE/ SUPPORT DIV 203 0.647% 1,643 1,643 313 1,956 0001-205- GF-FIRE/TRAINING DIV 11 0.035% 89 89 17 106 0001-206- GF-FIRE/OF. OF EMS DIV 10 0.032% 81 81 15 96 0001-211- OF. OF NB-HOOD SFTY ADMIN DIV 106 0.338% 858 858 163 1,021 0001-212- OFF OF N-HOOD SFTY/GRANT ADM 98 0.312% 793 793 151 944 0001-231- GF-PW ADMIN-DIV 169 0.539% 1,368 1,368 260 1,628 0001-233- GF-PRKS&LNDSKP/PRKS (S-DIV) 1,148 3.659% 9,290 9,290 1,769 11,060 0001-176- Accounts Payable
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
11 - Allocations

Page 149 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total 0001-176- Accounts Payable
0001-234- IT GIS 260 0.829% 2,104 2,104 401 2,505 0001-237- GF-I&M/ABATEMENT SVCS (DIV) 153 0.488% 1,238 1,238 236 1,474 0001-238- GF-I&M/CODE ENFORCEMENT (DIV) 8 0.025% 65 65 12 77 0001-239- GF-I&M/PROP/ASSETS MNGT (DIV) 22 0.070% 178 178 34 212 0001-241- GF-LIB&CL SVC/L-ADM DIV 129 0.411% 1,044 1,044 199 1,243 0001-242- GF-LS/REF SVCS(S-DIV) 623 1.986% 5,042 5,042 960 6,002 0001-243- GF-LIB&CL SVCS/LEAP DIV 18 0.057% 146 146 28 173 0001-244- GF-LIB&CL SVC/P-ART DIV 13 0.041% 105 105 20 125 0001-251- GF-RECREATION ADM DIV 163 0.520% 1,319 1,319 251 1,570 0001-253- CM&NB/BOOKER T CTR (S-DIV) 256 0.816% 2,072 2,072 395 2,466 0001-255- GF-CM TRANSPORTATN OPERATIONS 24 0.076% 194 194 37 231 0001-254- GF-REC/SPCL EVENTS (S-DIV) 73 0.233% 591 591 113 703 0001-256- RECREATION SVCS/AQUATICS 59 0.188% 477 477 91 568 0001-257- RECREATION SVCS/CONVENTION CTR 14 0.045% 113 113 22 135 0001-259- RECREATION SVCS/PLUNGE 35 0.112% 283 283 54 337 0001-260- RECREATION SVCS/CITIES OF SRVC 39 0.124% 316 316 60 376 0001-291- GF-ADMINISTRATIVE SERVICES 40 0.127% 324 324 62 385 0001-292- GF-STREET SWEEPING 39 0.124% 316 316 60 376 0001-361- GF ECON DEV/SP PRJ-ENVIRONMNTL 38 0.121% 308 308 59 366 0001-362- GF ECON DEV/SP PRJ-ENVIRONMNTL 30 0.096% 243 243 46 289 0001-364- GF-ECON DEV/PUBLIC ART DIV 21 0.067% 170 170 32 202 0001-369- GF-ECON DEV/REAL ESTATE (DIV) 31 0.099% 251 251 48 299 0001-371- INTERNAL SERVICES-ADMIN 24 0.076% 194 194 37 231 0001-910- GF-NON-DEPT/CITY FESTIVAL - 0.000% - - - - 1001- SECURED PENSION OVERRIDE - 0.000% - - - - 1002- STATE GAS TAX 249 0.794% 2,015 2,015 384 2,399 1003- TRANSPORTATION OPERATIONS 79 0.252% 639 639 122 761 1004- ASSET SEIZURE FUND 9 0.029% 73 73 14 87 1005- LIBRARY FUND 176 0.561% 1,424 1,424 271 1,696 1006- OUTSIDE FUNDED SVCS - GRANTS 109 0.347% 882 882 168 1,050 1007- EMERGENCY MED SERV 76 0.242% 615 615 117 732 1010- N.RICHMOND WASTE 7 0.022% 57 57 11 67 1012- HILLTOP LANDSCAPE MAINT DIST 237 0.755% 1,918 1,918 365 2,283 1013- FIRE DEPT HAZMAT GRANT 10 0.032% 81 81 15 96 1014- EDA GRANT FUND - 0.000% - - - - 1015- MARINA BAY LNDSCP&LIGHTDIST FD 272 0.867% 2,201 2,201 419 2,620 1017- CHEVRON MODERNIZATN PROJ & CIA 193 0.615% 1,562 1,562 297 1,859 1018- RENT CONTROL 160 0.510% 1,295 1,295 247 1,541 1019- SBI RMRA CAP IMPROVEMENT 23 0.073% 186 186 35 222 1050- CR-PLANNING & BUILDING 826 2.633% 6,684 6,684 1,273 7,957 1051- CR-ENGINEERING 213 0.679% 1,724 1,724 328 2,052 1053- CODE ENFORCEMENT-CR 1 0.003% 8 8 2 10 1054- ENGINEERING GRANTS 49 0.156% 397 397 76 472 1055- ENCROACHMENTS SVCS 43 0.137% 348 348 66 414 1200- COR HOUSING ADMINISTRATION 61 0.194% 494 494 94 588 1201- CDBG 9 0.029% 73 73 14 87 1203- NEIGHBORHOOD STABILIZATION - 0.000% - - - - 1205- EMPLOYMENT & TRAINING 583 1.858% 4,718 4,718 899 5,616 1207- NEIGHBORHOOD STAB(CITY) 2 0.006% 16 16 3 19 1208- SUCCESSOR HOUSING AGNCY 3 0.010% 24 24 5 29 1209- CAL-HOME - 0.000% - - - - Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
11 - Allocations

Page 150 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total 0001-176- Accounts Payable
1302- HOUSNG IN LIEU FEE - DEVELOPER - 0.000% - - - - 1303- KIDS FIRST INITIATIVE 38 0.121% 308 308 59 366 1304- EMERGENCY OPE & DISASTR RECVRY 585 1.864% 4,734 4,734 902 5,636 2001- GENERAL CAPITAL FUND 34 0.108% 275 275 52 328 2002- MEASURE J 82 0.261% 664 664 126 790 2110- IMPACT FEE - PARK 1 0.003% 8 8 2 10 2111- PF IMP FEES-TRAFFIC/ROAD-ENG 19 0.061% 154 154 29 183 2113- IMPACT FEE - FIRE 6 0.019% 49 49 9 58 2114- IMPACT FEE - POLICE - 0.000% - - - - 2115- IMPACT FEE - COMM/AQUATC 8 0.025% 65 65 12 77 2116- IMPACT FEE - PARKS/OPEN 1 0.003% 8 8 2 10 2117- IMPACT FEE - LIBRARY 5 0.016% 40 40 8 48 2119- IMPACT FEE - STORM DRAINAGE 6 0.019% 49 49 9 58 2120- IMPACT FEE - WASTEWATER 2 0.006% 16 16 3 19 2125- IRON TRIANGLE/EPA PROGRAMS 8 0.025% 65 65 12 77 2126- COR-HOUSING DEPT CIP FUND - 0.000% - - - - 3001- DS - 2005 TAXABLE POB - 0.000% - - - - 3002- DS - 99A PENSION OBLIG BOND - 0.000% - - - - 3005- DS - 2007 CIVIC CENTER - 0.000% - - - - 4001- PORT OF RICHMOND 279 0.889% 2,258 2,258 430 2,688 4003- WASTEWATER 803 2.559% 6,498 6,498 1,238 7,736 4005- MARINA - 0.000% - - - - 4006- STORM WATER 116 0.370% 939 939 179 1,118 4008- KCRT - CABLE TELEVIS 111 0.354% 898 898 171 1,069 4101- RHA-HSNG CHOICE VOUCHER-SEC 8 - 0.000% - - - - 4102- RHA-HOPE 6 12 0.038% 97 97 18 116 4201- RHA-CAPITAL FUND 32 0.102% 259 259 49 308 4401- RHA-HACIENDA 52 0.166% 421 421 80 501 4404- RHA-NEVIN PLAZA 742 2.365% 6,005 6,005 1,144 7,148 4405- RHA-NYSTROM VILLAGE 560 1.785% 4,532 4,532 863 5,395 4406- RHA-RICHMOND VILLAGE ONE - 0.000% - - - - 4407- RHA-RICHMOND VILLAGE TWO - 0.000% - - - - 4408- RHA-RICHMOND VILLAGE THREE - 0.000% - - - - 4501- RHA-CENTRAL OFFICE COST CNTR 315 1.004% 2,549 2,549 485 3,035 4502- RHA-HOUSING (RAD) CORPORATION - 0.000% - - - - 5001- INSURANCE RESERVES 216 0.688% 1,748 1,748 333 2,081 5003- EQUIPMENT SERVICES 86 0.274% 696 696 133 829 5005- CAD DISPATCH SYSTEM 16 0.051% 129 129 25 154 5006- RMS RECORDS SERVICES - 0.000% - - - - 5008- COMPENSATED ABSENCES - 0.000% - - - - 6001- GENERAL TRUST & AGENCY - 0.000% - - - - 6004- COMMISSION ON AGING 3 0.010% 24 24 5 29 6005- SEAVER GALLERY TRUST FUND 1 0.003% 8 8 2 10 6007- SENIOR TRUST DEPOSIT 15 0.048% 121 121 23 145 6047- CERTBT PLAN FUND - 0.000% - - - - 6048- OPEB PLAN TRUST - 0.000% - - - - 6049- PT MOLATE PRIVATE-PURPOSE TRST - 0.000% - - - - 6050- GENERAL PENSION FUND - 0.000% - - - - 6051- POLICE & FIRE PENSION - 0.000% - - - - 6052- GARFIELD PENSION FUND - 0.000% - - - - 6058- MARINA WESTSHORE DEB - 0.000% - - - - 6059- COUNTRY CLUB VISTA - 0.000% - - - - Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
11 - Allocations

Page 151 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total 0001-176- Accounts Payable
6060- REASSESSMENT DISTRICT 2003-1 - 0.000% - - - - 6101- SA-PROPERTY TAX TRUST FUND - 0.000% - - - - 6102- SA- ADMINISTRATION 156 0.497% 1,262 1,262 240 1,503 6103- SA - CAPITAL PROJECT FUNDS 91 0.290% 736 736 140 877 6208- SA-CIP 07B TARB BND PRCDS-HSG - 0.000% - - - - 6300- SA-DS HARBOR 98 TARB - 0.000% - - - - 6304- SA-DS 2003B TARB - 0.000% - - - - 6305- SA-DS 2004A TARB 2/3 - 0.000% - - - - 6306- SA-DS 2004A TARB -1/3 HSING - 0.000% - - - - 6307- SA-DS 2004B TARB - HOUSING - 0.000% - - - - 6308- SA-DS 2007/10A TARB - 0.000% - - - - 6309- SA-DS 2007/10B TARB - HOUSING - 0.000% - - - - 6401- SA-DS 2014A NON-TAXABLE BONDS - 0.000% - - - - 6402- SA-DS 2014B TAXABLE BONDS - 0.000% - - - - 6403- SA-DS LOANS PAYABLE - 0.000% - - - - 6404- SA-DS 2021A NON-TAXABLE BONDS is new - 0.000% - - - - 6405- SA-DS 2021B TAXABLE BONDS is new - 0.000% - - - - 6996- SUCCESSOR AGENCY - GLTDAG - 0.000% - - - - 9102- CITY OF RICHMOND - GFAAG - 0.000% - - - - AO- ALL OTHER 982 3.130% 7,947 7,947 1,513 9,460 Total 31,376 100.000% $ 253,911 $ - $ 253,911 $ 47,348 $ 301,259 Allocation Basis: FY 20-21 Total Accounts Payable Invoices per Fund/Department Source of Allocation: FY 20-21 ap101- invoices by date by org code.xlsx Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
11 - Allocations

Page 152 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-176- Accounts Payable

ALLOCABLE BUDGET UNITS
BLDG- Building Use $ - $ - EQUIP- Equipment Use - - 0001-131- City Manager's Office 1,125 1,125 0001-141- City Clerk 1,408 1,408 0001-151- City Attorney 1,190 1,190 0001-171- Finance Administration 1,206 1,206 0001-172- Accounting 73 73 0001-173- Budget/Operating 81 81 0001-174- Payroll - - 0001-175- Treasury/Cash Management 218 218 0001-176- Accounts Payable - - 0001-177- Rev Collection 414 414 0001-178- Purchasing 77 77 0001-181- Human Resources 2,880 2,880 0001-232- Facility Maintenance and Administration 51,830 51,830 0001-235- Equipment Services/Fleet Services 21,811 21,811 0001-261- Information Technology Administration 1,705 1,705 0001-262- Telecommunications 9,952 9,952 0001-263- IT/Mailroom and Duplication, GIS, ERP and Desktop 829 829 0001-907, 908- Non-Departmental 63,371 63,371 - - -
- - -
- - -
- - -
- - -

RECEIVING BUDGET UNITS
0001-101- OFFICE OF THE MAYOR 173 173 0001-105- COUNCIL/CITY COUNCIL DIV 1,397 1,397 0001-121- POLICE COMMISSION DIV 67 67 0001-132- CM-SPCIAL PROJS/ENVIRONMENTAL - - 0001-163- GF-PLN/CODE ENFORCEMENT (DIV) 1,079 1,079 0001-191- GF-POLICE ADMIN DIV 16,705 16,705 0001-192- GF-POLICE-PATROL/CIB - - 0001-193- GF-POLICE/CRIME PREVENTION 308 308 0001-194- GF-POLICE-COPS GRANT - - 0001-196- GF-POLICE/REGULATORY 58 58 0001-197- CAD DISPATCH SYST/COMM POL DIV 173 173 0001-199- GF-PARKING ENFORCEMENT DIV - - 0001-201- GF-FIRE/ADMIN DIV 125 125 0001-202- GF-FIRE/SUPRESSN DIV - - 0001-203- GF-FIRE PREVENTION DIV 1,329 1,329 0001-204- GF-FIRE/ SUPPORT DIV 1,956 1,956 0001-205- GF-FIRE/TRAINING DIV 106 106 0001-206- GF-FIRE/OF. OF EMS DIV 96 96 0001-211- OF. OF NB-HOOD SFTY ADMIN DIV 1,021 1,021 0001-212- OFF OF N-HOOD SFTY/GRANT ADM 944 944 0001-231- GF-PW ADMIN-DIV 1,628 1,628 0001-233- GF-PRKS&LNDSKP/PRKS (S-DIV) 11,060 11,060 0001-234- IT GIS 2,505 2,505

ALLOCATION SUMMARY
Total
Citywide
Accounts
Payable
Services
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
11 - Summary

Page 153 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-176- Accounts Payable

ALLOCATION SUMMARY
Total
Citywide
Accounts
Payable
Services
0001-237- GF-I&M/ABATEMENT SVCS (DIV) 1,474 1,474 0001-238- GF-I&M/CODE ENFORCEMENT (DIV) 77 77 0001-239- GF-I&M/PROP/ASSETS MNGT (DIV) 212 212 0001-241- GF-LIB&CL SVC/L-ADM DIV 1,243 1,243 0001-242- GF-LS/REF SVCS(S-DIV) 6,002 6,002 0001-243- GF-LIB&CL SVCS/LEAP DIV 173 173 0001-244- GF-LIB&CL SVC/P-ART DIV 125 125 0001-251- GF-RECREATION ADM DIV 1,570 1,570 0001-253- CM&NB/BOOKER T CTR (S-DIV) 2,466 2,466 0001-255- GF-CM TRANSPORTATN OPERATIONS 231 231 0001-254- GF-REC/SPCL EVENTS (S-DIV) 703 703 0001-256- RECREATION SVCS/AQUATICS 568 568 0001-257- RECREATION SVCS/CONVENTION CTR 135 135 0001-259- RECREATION SVCS/PLUNGE 337 337 0001-260- RECREATION SVCS/CITIES OF SRVC 376 376 0001-291- GF-ADMINISTRATIVE SERVICES 385 385 0001-292- GF-STREET SWEEPING 376 376 0001-361- GF ECON DEV/SP PRJ-ENVIRONMNTL 366 366 0001-362- GF ECON DEV/SP PRJ-ENVIRONMNTL 289 289 0001-364- GF-ECON DEV/PUBLIC ART DIV 202 202 0001-369- GF-ECON DEV/REAL ESTATE (DIV) 299 299 0001-371- INTERNAL SERVICES-ADMIN 231 231 0001-910- GF-NON-DEPT/CITY FESTIVAL - - 1001- SECURED PENSION OVERRIDE - - 1002- STATE GAS TAX 2,399 2,399 1003- TRANSPORTATION OPERATIONS 761 761 1004- ASSET SEIZURE FUND 87 87 1005- LIBRARY FUND 1,696 1,696 1006- OUTSIDE FUNDED SVCS - GRANTS 1,050 1,050 1007- EMERGENCY MED SERV 732 732 1010- N.RICHMOND WASTE 67 67 1012- HILLTOP LANDSCAPE MAINT DIST 2,283 2,283 1013- FIRE DEPT HAZMAT GRANT 96 96 1014- EDA GRANT FUND - - 1015- MARINA BAY LNDSCP&LIGHTDIST FD 2,620 2,620 1017- CHEVRON MODERNIZATN PROJ & CIA 1,859 1,859 1018- RENT CONTROL 1,541 1,541 1019- SBI RMRA CAP IMPROVEMENT 222 222 1050- CR-PLANNING & BUILDING 7,957 7,957 1051- CR-ENGINEERING 2,052 2,052 1053- CODE ENFORCEMENT-CR 10 10 1054- ENGINEERING GRANTS 472 472 1055- ENCROACHMENTS SVCS 414 414 1200- COR HOUSING ADMINISTRATION 588 588 1201- CDBG 87 87
1203- NEIGHBORHOOD STABILIZATION - - 1205- EMPLOYMENT & TRAINING 5,616 5,616 1207- NEIGHBORHOOD STAB(CITY) 19 19 1208- SUCCESSOR HOUSING AGNCY 29 29 1209- CAL-HOME - - Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
11 - Summary

Page 154 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-176- Accounts Payable

ALLOCATION SUMMARY
Total
Citywide
Accounts
Payable
Services
1302- HOUSNG IN LIEU FEE - DEVELOPER - - 1303- KIDS FIRST INITIATIVE 366 366 1304- EMERGENCY OPE & DISASTR RECVRY 5,636 5,636 2001- GENERAL CAPITAL FUND 328 328 2002- MEASURE J 790 790 2110- IMPACT FEE - PARK 10 10 2111- PF IMP FEES-TRAFFIC/ROAD-ENG 183 183 2113- IMPACT FEE - FIRE 58 58 2114- IMPACT FEE - POLICE - - 2115- IMPACT FEE - COMM/AQUATC 77 77 2116- IMPACT FEE - PARKS/OPEN 10 10 2117- IMPACT FEE - LIBRARY 48 48 2119- IMPACT FEE - STORM DRAINAGE 58 58 2120- IMPACT FEE - WASTEWATER 19 19 2125- IRON TRIANGLE/EPA PROGRAMS 77 77 2126- COR-HOUSING DEPT CIP FUND - - 3001- DS - 2005 TAXABLE POB - - 3002- DS - 99A PENSION OBLIG BOND - - 3005- DS - 2007 CIVIC CENTER - - 4001- PORT OF RICHMOND 2,688 2,688 4003- WASTEWATER 7,736 7,736 4005- MARINA - - 4006- STORM WATER 1,118 1,118 4008- KCRT - CABLE TELEVIS 1,069 1,069 4101- RHA-HSNG CHOICE VOUCHER-SEC 8 - - 4102- RHA-HOPE 6 116 116 4201- RHA-CAPITAL FUND 308 308 4401- RHA-HACIENDA 501 501 4404- RHA-NEVIN PLAZA 7,148 7,148 4405- RHA-NYSTROM VILLAGE 5,395 5,395 4406- RHA-RICHMOND VILLAGE ONE - - 4407- RHA-RICHMOND VILLAGE TWO - - 4408- RHA-RICHMOND VILLAGE THREE - - 4501- RHA-CENTRAL OFFICE COST CNTR 3,035 3,035 4502- RHA-HOUSING (RAD) CORPORATION - - 5001- INSURANCE RESERVES 2,081 2,081 5003- EQUIPMENT SERVICES 829 829 5005- CAD DISPATCH SYSTEM 154 154 5006- RMS RECORDS SERVICES - - 5008- COMPENSATED ABSENCES - - 6001- GENERAL TRUST & AGENCY - - 6004- COMMISSION ON AGING 29 29 6005- SEAVER GALLERY TRUST FUND 10 10 6007- SENIOR TRUST DEPOSIT 145 145 6047- CERTBT PLAN FUND - - 6048- OPEB PLAN TRUST - - 6049- PT MOLATE PRIVATE-PURPOSE TRST - - 6050- GENERAL PENSION FUND - - 6051- POLICE & FIRE PENSION - - 6052- GARFIELD PENSION FUND - - Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
11 - Summary

Page 155 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-176- Accounts Payable

ALLOCATION SUMMARY
Total
Citywide
Accounts
Payable
Services
6058- MARINA WESTSHORE DEB - - 6059- COUNTRY CLUB VISTA - - 6060- REASSESSMENT DISTRICT 2003-1 - - 6101- SA-PROPERTY TAX TRUST FUND - - 6102- SA- ADMINISTRATION 1,503 1,503 6103- SA - CAPITAL PROJECT FUNDS 877 877 6208- SA-CIP 07B TARB BND PRCDS-HSG - - 6300- SA-DS HARBOR 98 TARB - - 6304- SA-DS 2003B TARB - - 6305- SA-DS 2004A TARB 2/3 - - 6306- SA-DS 2004A TARB -1/3 HSING - - 6307- SA-DS 2004B TARB - HOUSING - - 6308- SA-DS 2007/10A TARB - - 6309- SA-DS 2007/10B TARB - HOUSING - - 6401- SA-DS 2014A NON-TAXABLE BONDS - - 6402- SA-DS 2014B TAXABLE BONDS - - 6403- SA-DS LOANS PAYABLE - - 6404- SA-DS 2021A NON-TAXABLE BONDS is new - - 6405- SA-DS 2021B TAXABLE BONDS is new - - 6996- SUCCESSOR AGENCY - GLTDAG - - 9102- CITY OF RICHMOND - GFAAG - - AO- ALL OTHER 9,460 9,460
Total $ 301,259 $ 301,259
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
11 - Summary

Page 156 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-177- Rev Collection
Distribution Percentage 100.00%
Expense Type $
Personnel
400002 - SALARIES & WAGES/Mgmt-Local 21 119,412$ S 119,412$ 400003 - SALARIES & WAGES/Local 1021 153,120 S 153,120
400031 - OVERTIME/General 4,564 S 4,564
400048 - OTHER PAY/Bilingual Pay 4,334 S 4,334
400103 - P-ROLL BEN/Medicare Tax-ER Shr 4,132 S 4,132
400105 - P-ROLL BEN/Health Insurance Be 73,618 S 73,618 400106 - P-ROLL BEN/Dental Insurance 7,709 S 7,709
400109 - P-ROLL BEN/Employee Assistance 186 S 186
400110 - P-ROLL BEN/Professional Dev-Mg 750 S 750
400111 - P-ROLL BEN/Vision 901 S 901
400112 - P-ROLL BEN/Life Insurance 794 S 794
400114 - P-ROLL BEN/Long Term Disabilit 2,501 S 2,501
400116 - P-ROLL BEN/Unemployment Ins 1,874 S 1,874
400117 - P-ROLL BEN/Personal/Prof Dev 2,388 S 2,388
400121 - P-ROLL BEN/Worker Comp-Clerica 17,229 S 17,229 400122 - P-ROLL BEN/Worker Comp-Prof 10,669 S 10,669
400127 - P-ROLL BEN/OPEB 11,200 S 11,200
400149 - P-ROLL BEN/PERS-Misc 37,024 S 37,024
400151 - P-ROLL BEN/PERS-Misc (UAL) 107,232 S 107,232
Subtotal Personnel Cost 559,637$ 559,637$
Operating Services & Supplies
400201 - PROF SVCS/Professional Svcs 142,254$ S 142,254$ 400261 - DUES & PUB/Membership & Dues 125 S 125
400290 - ADM EXP/Courier-Delivery Svcs 16,554 S 16,554
400592 - COST POOL/(CON)-Admin Charges (274,333) S (274,333) Subtotal Operating Cost (115,401)$ (115,401)$
Disallowed Expenses
400592 - COST POOL/(CON)-Admin Charges 274,333$ [1] 274,333$ Subtotal Disallowed Costs 274,333$ 274,333$
DEPARTMENTAL EXPENDITURES 718,569$ 718,569$
Reallocation of Incoming Costs
First Allocation 23,621$ 742,191$
Unallocated Costs -$ -$
Subtotal of First Allocation 23,621$ 742,191$
Second Allocation 121,857$ 121,857$
Unallocated Costs -$ -$
Subtotal of Second Allocation 121,857$ 121,857$
TOTAL FUNCTIONAL COSTS 864,048$ 864,048$
[1] Admin charges are excluded and re-established through this CAP analysis

DEPARTMENTAL EXPENSE DETAIL
Spread
Method
Citywide
Revenue
Collection
Notes
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
12 - EXP

Page 157 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-177- Rev Collection First Second
Allocation Allocation Total
Departmental Expenditures $ 718,569 $ 718,569 Incoming Costs
BLDG- Building Use $ - $ - $ - EQUIP- Equipment Use - - - 0001-131- City Manager's Office 2,240 483 2,723 0001-141- City Clerk 2,189 419 2,608 0001-151- City Attorney 4,964 938 5,902 0001-171- Finance Administration 2,150 538 2,688 0001-172- Accounting 4,554 689 5,243 0001-173- Budget/Operating 1,320 269 1,589 0001-174- Payroll 1,976 421 2,398 0001-175- Treasury/Cash Management 3,880 686 4,566 0001-176- Accounts Payable 348 66 414 0001-177- Rev Collection 4,950 4,950 0001-178- Purchasing - - 0001-181- Human Resources 10,474 10,474 0001-232- Facility Maintenance and Administration - - 0001-235- Equipment Services/Fleet Services 19,533 19,533 0001-261- Information Technology Administration 7,360 7,360 0001-262- Telecommunications 10,081 10,081 0001-263- IT/Mailroom and Duplication, GIS, ERP and Desktop - - 0001-907, 908- Non-Departmental 64,949 64,949 - - -
- - -
- - -
- - -
- - -
Total Incoming Costs $ 23,621 $ 121,857 $ 145,478 Total Costs to be Allocated $ 742,191 $ 121,857 $ 864,048

COSTS TO BE ALLOCATED
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
12 - Costs

Page 158 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total Citywide Revenue Collection Services 12.1

ALLOCABLE BUDGET UNITS
BLDG- Building Use - 0.000% $ - $ - $ - EQUIP- Equipment Use - 0.000% - - - 0001-131- City Manager's Office 112,454 0.349% 2,591 2,591 2,591 0001-141- City Clerk 235,055 0.730% 5,416 5,416 5,416 0001-151- City Attorney 105,086 0.326% 2,422 2,422 2,422 0001-171- Finance Administration 31,813 0.099% 733 733 733 0001-172- Accounting 3,145 0.010% 72 72 72 0001-173- Budget/Operating 62,638 0.194% 1,443 1,443 1,443 0001-174- Payroll - 0.000% - - - 0001-175- Treasury/Cash Management 31,004 0.096% 714 714 714 0001-176- Accounts Payable - 0.000% - - - 0001-177- Rev Collection 214,808 0.667% 4,950 4,950 4,950 0001-178- Purchasing - 0.000% - - - - 0001-181- Human Resources 447,720 1.390% 10,317 10,317 1,737 12,054 0001-232- Facility Maintenance and Administration 1,228,687 3.815% 28,313 28,313 4,766 33,080 0001-235- Equipment Services/Fleet Services 700,541 2.175% 16,143 16,143 2,718 18,861 0001-261- Information Technology Administration 873,193 2.711% 20,121 20,121 3,387 23,509 0001-262- Telecommunications 1,176,070 3.651% 27,101 27,101 4,562 31,663 0001-263- IT/Mailroom and Duplication, GIS, ERP and Desktop 87,753 0.272% 2,022 2,022 340 2,363 0001-907, 908- Non-Departmental 1,208,995 3.754% 27,860 27,860 4,690 32,550 - - 0.000% - - - -

RECEIVING BUDGET UNITS -
0001-101- OFFICE OF THE MAYOR 1,482 0.005% 34 34 6 40 0001-105- COUNCIL/CITY COUNCIL DIV 9,139 0.028% 211 211 35 246 0001-121- POLICE COMMISSION DIV 66 0.000% 2 2 0 2 0001-132- CM-SPCIAL PROJS/ENVIRONMENTAL - 0.000% - - - - 0001-163- GF-PLN/CODE ENFORCEMENT (DIV) 62,697 0.195% 1,445 1,445 243 1,688 0001-191- GF-POLICE ADMIN DIV 3,354,699 10.416% 77,304 77,304 13,014 90,318 0001-192- GF-POLICE-PATROL/CIB - 0.000% - - - - 0001-193- GF-POLICE/CRIME PREVENTION - 0.000% - - - - 0001-194- GF-POLICE-COPS GRANT - 0.000% - - - - 0001-196- GF-POLICE/REGULATORY 1,337 0.004% 31 31 5 36 0001-197- CAD DISPATCH SYST/COMM POL DIV 25,392 0.079% 585 585 99 684 0001-199- GF-PARKING ENFORCEMENT DIV - 0.000% - - - - 0001-201- GF-FIRE/ADMIN DIV 6,500 0.020% 150 150 25 175 0001-202- GF-FIRE/SUPRESSN DIV - 0.000% - - - - 0001-203- GF-FIRE PREVENTION DIV 43,978 0.137% 1,013 1,013 171 1,184 0001-204- GF-FIRE/ SUPPORT DIV 76,583 0.238% 1,765 1,765 297 2,062 0001-205- GF-FIRE/TRAINING DIV 416 0.001% 10 10 2 11 0001-206- GF-FIRE/OF. OF EMS DIV 800 0.002% 18 18 3 22 0001-211- OF. OF NB-HOOD SFTY ADMIN DIV 75,047 0.233% 1,729 1,729 291 2,020 0001-212- OFF OF N-HOOD SFTY/GRANT ADM 174,387 0.541% 4,019 4,019 677 4,695 0001-231- GF-PW ADMIN-DIV 482,746 1.499% 11,124 11,124 1,873 12,997 0001-233- GF-PRKS&LNDSKP/PRKS (S-DIV) 314,787 0.977% 7,254 7,254 1,221 8,475 0001-234- IT GIS 24,954 0.077% 575 575 97 672 0001-237- GF-I&M/ABATEMENT SVCS (DIV) 25,952 0.081% 598 598 101 699 0001-238- GF-I&M/CODE ENFORCEMENT (DIV) 2,118 0.007% 49 49 8 57 0001-239- GF-I&M/PROP/ASSETS MNGT (DIV) 24,811 0.077% 572 572 96 668 0001-177- Rev Collection
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
12 - Allocations

Page 159 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total 0001-177- Rev Collection
0001-241- GF-LIB&CL SVC/L-ADM DIV 47,047 0.146% 1,084 1,084 183 1,267 0001-242- GF-LS/REF SVCS(S-DIV) 215,112 0.668% 4,957 4,957 834 5,791 0001-243- GF-LIB&CL SVCS/LEAP DIV 6,608 0.021% 152 152 26 178 0001-244- GF-LIB&CL SVC/P-ART DIV 22,994 0.071% 530 530 89 619 0001-251- GF-RECREATION ADM DIV 23,878 0.074% 550 550 93 643 0001-253- CM&NB/BOOKER T CTR (S-DIV) 11,453 0.036% 264 264 44 308 0001-255- GF-CM TRANSPORTATN OPERATIONS 1,243 0.004% 29 29 5 33 0001-254- GF-REC/SPCL EVENTS (S-DIV) 187 0.001% 4 4 1 5 0001-256- RECREATION SVCS/AQUATICS 2,454 0.008% 57 57 10 66 0001-257- RECREATION SVCS/CONVENTION CTR 2,738 0.008% 63 63 11 74 0001-259- RECREATION SVCS/PLUNGE 1,527 0.005% 35 35 6 41 0001-260- RECREATION SVCS/CITIES OF SRVC 30,838 0.096% 711 711 120 830 0001-291- GF-ADMINISTRATIVE SERVICES 23,166 0.072% 534 534 90 624 0001-292- GF-STREET SWEEPING 1,884 0.006% 43 43 7 51 0001-361- GF ECON DEV/SP PRJ-ENVIRONMNTL 17,614 0.055% 406 406 68 474 0001-362- GF ECON DEV/SP PRJ-ENVIRONMNTL 126,910 0.394% 2,924 2,924 492 3,417 0001-364- GF-ECON DEV/PUBLIC ART DIV 24,148 0.075% 556 556 94 650 0001-369- GF-ECON DEV/REAL ESTATE (DIV) 68,527 0.213% 1,579 1,579 266 1,845 0001-371- INTERNAL SERVICES-ADMIN 26,699 0.083% 615 615 104 719 0001-910- GF-NON-DEPT/CITY FESTIVAL - 0.000% - - - - 1001- SECURED PENSION OVERRIDE - 0.000% - - - - 1002- STATE GAS TAX 1,358,550 4.218% 31,306 31,306 5,270 36,576 1003- TRANSPORTATION OPERATIONS 44,339 0.138% 1,022 1,022 172 1,194 1004- ASSET SEIZURE FUND 37,811 0.117% 871 871 147 1,018 1005- LIBRARY FUND 28,742 0.089% 662 662 112 774 1006- OUTSIDE FUNDED SVCS - GRANTS 326,953 1.015% 7,534 7,534 1,268 8,803 1007- EMERGENCY MED SERV 53,928 0.167% 1,243 1,243 209 1,452 1010- N.RICHMOND WASTE 660 0.002% 15 15 2.56 18 1012- HILLTOP LANDSCAPE MAINT DIST 111,023 0.345% 2,558 2,558 431 2,989 1013- FIRE DEPT HAZMAT GRANT 19,840 0.062% 457 457 77 534 1014- EDA GRANT FUND - 0.000% - - - - 1015- MARINA BAY LNDSCP&LIGHTDIST FD 46,688 0.145% 1,076 1,076 181 1,257 1017- CHEVRON MODERNIZATN PROJ & CIA 785,388 2.438% 18,098 18,098 3,047 21,145 1018- RENT CONTROL 28,345 0.088% 653 653 110 763 1019- SBI RMRA CAP IMPROVEMENT 89,741 0.279% 2,068 2,068 348 2,416 1050- CR-PLANNING & BUILDING 4,338,861 13.471% 99,983 99,983 16,832 116,815 1051- CR-ENGINEERING 101,265 0.314% 2,334 2,334 393 2,726 1053- CODE ENFORCEMENT-CR 5,043 0.016% 116 116 20 136 1054- ENGINEERING GRANTS 216,561 0.672% 4,990 4,990 840.10 5,830 1055- ENCROACHMENTS SVCS 17,613 0.055% 406 406 68 474 1200- COR HOUSING ADMINISTRATION 34,702 0.108% 800 800 135 934 1201- CDBG 51,254 0.159% 1,181 1,181 199 1,380 1203- NEIGHBORHOOD STABILIZATION - 0.000% - - - - 1205- EMPLOYMENT & TRAINING 331,312 1.029% 7,635 7,635 1,285 8,920 1207- NEIGHBORHOOD STAB(CITY) 13,455 0.042% 310 310 52 362 1208- SUCCESSOR HOUSING AGNCY 6,213 0.019% 143 143 24 167 1209- CAL-HOME - 0.000% - - - - 1302- HOUSNG IN LIEU FEE - DEVELOPER - 0.000% - - - - 1303- KIDS FIRST INITIATIVE 151,882 0.472% 3,500 3,500 589 4,089 1304- EMERGENCY OPE & DISASTR RECVRY 457,232 1.420% 10,536 10,536 1,774 12,310 2001- GENERAL CAPITAL FUND 684,607 2.126% 15,776 15,776 2,656 18,432 Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
12 - Allocations

Page 160 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total 0001-177- Rev Collection
2002- MEASURE J 1,080,867 3.356% 24,907 24,907 4,193 29,100 2110- IMPACT FEE - PARK 15,000 0.047% 346 346 58 404 2111- PF IMP FEES-TRAFFIC/ROAD-ENG 84,645 0.263% 1,951 1,951 328 2,279 2113- IMPACT FEE - FIRE 35,977 0.112% 829 829 140 969 2114- IMPACT FEE - POLICE - 0.000% - - - - 2115- IMPACT FEE - COMM/AQUATC 245,653 0.763% 5,661 5,661 953 6,614 2116- IMPACT FEE - PARKS/OPEN 48,359 0.150% 1,114 1,114 188 1,302 2117- IMPACT FEE - LIBRARY - 0.000% - - - - 2119- IMPACT FEE - STORM DRAINAGE - 0.000% - - - - 2120- IMPACT FEE - WASTEWATER - 0.000% - - - - 2125- IRON TRIANGLE/EPA PROGRAMS 203,124 0.631% 4,681 4,681 788 5,469 2126- COR-HOUSING DEPT CIP FUND - 0.000% - - - - 3001- DS - 2005 TAXABLE POB - 0.000% - - - - 3002- DS - 99A PENSION OBLIG BOND - 0.000% - - - - 3005- DS - 2007 CIVIC CENTER - 0.000% - - - - 4001- PORT OF RICHMOND 502,969 1.562% 11,590 11,590 1,951 13,541 4003- WASTEWATER 1,433,083 4.449% 33,023 33,023 5,559 38,583 4005- MARINA - 0.000% - - - - 4006- STORM WATER 377,796 1.173% 8,706 8,706 1,466 10,171 4008- KCRT - CABLE TELEVIS 2,418 0.008% 56 56 9 65 4101- RHA-HSNG CHOICE VOUCHER-SEC 8 - 0.000% - - - - 4102- RHA-HOPE 6 - 0.000% - - - - 4201- RHA-CAPITAL FUND 99,426 0.309% 2,291 2,291 386 2,677 4401- RHA-HACIENDA - 0.000% - - - - 4404- RHA-NEVIN PLAZA 624 0.002% 14 14 2 17 4405- RHA-NYSTROM VILLAGE - 0.000% - - - - 4406- RHA-RICHMOND VILLAGE ONE - 0.000% - - - - 4407- RHA-RICHMOND VILLAGE TWO - 0.000% - - - - 4408- RHA-RICHMOND VILLAGE THREE - 0.000% - - - - 4501- RHA-CENTRAL OFFICE COST CNTR 15,767 0.049% 363 363 61 424 4502- RHA-HOUSING (RAD) CORPORATION - 0.000% - - - - 5001- INSURANCE RESERVES 2,381,121 7.393% 54,869 54,869 9,237 64,107 5003- EQUIPMENT SERVICES 2,180,511 6.770% 50,247 50,247 8,459 58,706 5005- CAD DISPATCH SYSTEM 1,200 0.004% 28 28 5 32 5006- RMS RECORDS SERVICES - 0.000% - - - - 5008- COMPENSATED ABSENCES - 0.000% - - - - 6001- GENERAL TRUST & AGENCY - 0.000% - - - - 6004- COMMISSION ON AGING 115 0.000% 3 3 0 3 6005- SEAVER GALLERY TRUST FUND - 0.000% - - - - 6007- SENIOR TRUST DEPOSIT 5,829 0.018% 134 134 23 157 6047- CERTBT PLAN FUND - 0.000% - - - - 6048- OPEB PLAN TRUST - 0.000% - - - - 6049- PT MOLATE PRIVATE-PURPOSE TRST - 0.000% - - - - 6050- GENERAL PENSION FUND - 0.000% - - - - 6051- POLICE & FIRE PENSION - 0.000% - - - - 6052- GARFIELD PENSION FUND - 0.000% - - - - 6058- MARINA WESTSHORE DEB - 0.000% - - - - 6059- COUNTRY CLUB VISTA - 0.000% - - - - 6060- REASSESSMENT DISTRICT 2003-1 - 0.000% - - - - 6101- SA-PROPERTY TAX TRUST FUND - 0.000% - - - - 6102- SA- ADMINISTRATION 50,949 0.158% 1,174 1,174 198 1,372 6103- SA - CAPITAL PROJECT FUNDS 703,253 2.183% 16,205 16,205 2,728 18,934 Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
12 - Allocations

Page 161 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total 0001-177- Rev Collection
6208- SA-CIP 07B TARB BND PRCDS-HSG - 0.000% - - - - 6300- SA-DS HARBOR 98 TARB - 0.000% - - - - 6304- SA-DS 2003B TARB - 0.000% - - - - 6305- SA-DS 2004A TARB 2/3 - 0.000% - - - - 6306- SA-DS 2004A TARB -1/3 HSING - 0.000% - - - - 6307- SA-DS 2004B TARB - HOUSING - 0.000% - - - - 6308- SA-DS 2007/10A TARB - 0.000% - - - - 6309- SA-DS 2007/10B TARB - HOUSING - 0.000% - - - - 6401- SA-DS 2014A NON-TAXABLE BONDS - 0.000% - - - - 6402- SA-DS 2014B TAXABLE BONDS - 0.000% - - - - 6403- SA-DS LOANS PAYABLE - 0.000% - - - - 6404- SA-DS 2021A NON-TAXABLE BONDS is new - 0.000% - - - - 6405- SA-DS 2021B TAXABLE BONDS is new - 0.000% - - - - 6996- SUCCESSOR AGENCY - GLTDAG - 0.000% - - - - 9102- CITY OF RICHMOND - GFAAG - 0.000% - - - - AO- ALL OTHER 1,515,598 4.706% 34,925 34,925 5,879 40,804 Total $ 32,208,170 100.000% $ 742,191 $ - $ 742,191 $ 121,857 $ 864,048 Allocation Basis: FY 20-21 Total Revenues Received per Fund/Department Source of Allocation: ap017 - check register extract 7.01.21-6.30.21.xls Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
12 - Allocations

Page 162 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-177- Rev Collection

ALLOCABLE BUDGET UNITS
BLDG- Building Use $ - $ - EQUIP- Equipment Use - - 0001-131- City Manager's Office 2,591 2,591 0001-141- City Clerk 5,416 5,416 0001-151- City Attorney 2,422 2,422 0001-171- Finance Administration 733 733 0001-172- Accounting 72 72 0001-173- Budget/Operating 1,443 1,443 0001-174- Payroll - - 0001-175- Treasury/Cash Management 714 714 0001-176- Accounts Payable - - 0001-177- Rev Collection 4,950 4,950 0001-178- Purchasing - - 0001-181- Human Resources 12,054 12,054 0001-232- Facility Maintenance and Administration 33,080 33,080 0001-235- Equipment Services/Fleet Services 18,861 18,861 0001-261- Information Technology Administration 23,509 23,509 0001-262- Telecommunications 31,663 31,663 0001-263- IT/Mailroom and Duplication, GIS, ERP and Desktop 2,363 2,363 0001-907, 908- Non-Departmental 32,550 32,550 - - -
- - -
- - -
- - -
- - -

RECEIVING BUDGET UNITS
0001-101- OFFICE OF THE MAYOR 40 40 0001-105- COUNCIL/CITY COUNCIL DIV 246 246 0001-121- POLICE COMMISSION DIV 2 2 0001-132- CM-SPCIAL PROJS/ENVIRONMENTAL - - 0001-163- GF-PLN/CODE ENFORCEMENT (DIV) 1,688 1,688 0001-191- GF-POLICE ADMIN DIV 90,318 90,318 0001-192- GF-POLICE-PATROL/CIB - - 0001-193- GF-POLICE/CRIME PREVENTION - - 0001-194- GF-POLICE-COPS GRANT - - 0001-196- GF-POLICE/REGULATORY 36 36 0001-197- CAD DISPATCH SYST/COMM POL DIV 684 684 0001-199- GF-PARKING ENFORCEMENT DIV - - 0001-201- GF-FIRE/ADMIN DIV 175 175 0001-202- GF-FIRE/SUPRESSN DIV - - 0001-203- GF-FIRE PREVENTION DIV 1,184 1,184 0001-204- GF-FIRE/ SUPPORT DIV 2,062 2,062 0001-205- GF-FIRE/TRAINING DIV 11 11 0001-206- GF-FIRE/OF. OF EMS DIV 22 22 0001-211- OF. OF NB-HOOD SFTY ADMIN DIV 2,020 2,020 0001-212- OFF OF N-HOOD SFTY/GRANT ADM 4,695 4,695 0001-231- GF-PW ADMIN-DIV 12,997 12,997 0001-233- GF-PRKS&LNDSKP/PRKS (S-DIV) 8,475 8,475

ALLOCATION SUMMARY
Total
Citywide
Revenue
Collection
Services
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
12 - Summary

Page 163 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-177- Rev Collection

ALLOCATION SUMMARY
Total
Citywide
Revenue
Collection
Services
0001-234- IT GIS 672 672 0001-237- GF-I&M/ABATEMENT SVCS (DIV) 699 699 0001-238- GF-I&M/CODE ENFORCEMENT (DIV) 57 57 0001-239- GF-I&M/PROP/ASSETS MNGT (DIV) 668 668 0001-241- GF-LIB&CL SVC/L-ADM DIV 1,267 1,267 0001-242- GF-LS/REF SVCS(S-DIV) 5,791 5,791 0001-243- GF-LIB&CL SVCS/LEAP DIV 178 178 0001-244- GF-LIB&CL SVC/P-ART DIV 619 619 0001-251- GF-RECREATION ADM DIV 643 643 0001-253- CM&NB/BOOKER T CTR (S-DIV) 308 308 0001-255- GF-CM TRANSPORTATN OPERATIONS 33 33 0001-254- GF-REC/SPCL EVENTS (S-DIV) 5 5 0001-256- RECREATION SVCS/AQUATICS 66 66 0001-257- RECREATION SVCS/CONVENTION CTR 74 74 0001-259- RECREATION SVCS/PLUNGE 41 41 0001-260- RECREATION SVCS/CITIES OF SRVC 830 830 0001-291- GF-ADMINISTRATIVE SERVICES 624 624 0001-292- GF-STREET SWEEPING 51 51 0001-361- GF ECON DEV/SP PRJ-ENVIRONMNTL 474 474 0001-362- GF ECON DEV/SP PRJ-ENVIRONMNTL 3,417 3,417 0001-364- GF-ECON DEV/PUBLIC ART DIV 650 650 0001-369- GF-ECON DEV/REAL ESTATE (DIV) 1,845 1,845 0001-371- INTERNAL SERVICES-ADMIN 719 719 0001-910- GF-NON-DEPT/CITY FESTIVAL - - 1001- SECURED PENSION OVERRIDE - - 1002- STATE GAS TAX 36,576 36,576 1003- TRANSPORTATION OPERATIONS 1,194 1,194 1004- ASSET SEIZURE FUND 1,018 1,018 1005- LIBRARY FUND 774 774 1006- OUTSIDE FUNDED SVCS - GRANTS 8,803 8,803 1007- EMERGENCY MED SERV 1,452 1,452 1010- N.RICHMOND WASTE 18 18 1012- HILLTOP LANDSCAPE MAINT DIST 2,989 2,989 1013- FIRE DEPT HAZMAT GRANT 534 534 1014- EDA GRANT FUND - - 1015- MARINA BAY LNDSCP&LIGHTDIST FD 1,257 1,257 1017- CHEVRON MODERNIZATN PROJ & CIA 21,145 21,145 1018- RENT CONTROL 763 763 1019- SBI RMRA CAP IMPROVEMENT 2,416 2,416 1050- CR-PLANNING & BUILDING 116,815 116,815 1051- CR-ENGINEERING 2,726 2,726 1053- CODE ENFORCEMENT-CR 136 136 1054- ENGINEERING GRANTS 5,830 5,830 1055- ENCROACHMENTS SVCS 474 474 1200- COR HOUSING ADMINISTRATION 934 934 1201- CDBG 1,380 1,380
1203- NEIGHBORHOOD STABILIZATION - - 1205- EMPLOYMENT & TRAINING 8,920 8,920 1207- NEIGHBORHOOD STAB(CITY) 362 362 Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
12 - Summary

Page 164 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-177- Rev Collection

ALLOCATION SUMMARY
Total
Citywide
Revenue
Collection
Services
1208- SUCCESSOR HOUSING AGNCY 167 167 1209- CAL-HOME - - 1302- HOUSNG IN LIEU FEE - DEVELOPER - - 1303- KIDS FIRST INITIATIVE 4,089 4,089 1304- EMERGENCY OPE & DISASTR RECVRY 12,310 12,310 2001- GENERAL CAPITAL FUND 18,432 18,432 2002- MEASURE J 29,100 29,100 2110- IMPACT FEE - PARK 404 404 2111- PF IMP FEES-TRAFFIC/ROAD-ENG 2,279 2,279 2113- IMPACT FEE - FIRE 969 969 2114- IMPACT FEE - POLICE - - 2115- IMPACT FEE - COMM/AQUATC 6,614 6,614 2116- IMPACT FEE - PARKS/OPEN 1,302 1,302 2117- IMPACT FEE - LIBRARY - - 2119- IMPACT FEE - STORM DRAINAGE - - 2120- IMPACT FEE - WASTEWATER - - 2125- IRON TRIANGLE/EPA PROGRAMS 5,469 5,469 2126- COR-HOUSING DEPT CIP FUND - - 3001- DS - 2005 TAXABLE POB - - 3002- DS - 99A PENSION OBLIG BOND - - 3005- DS - 2007 CIVIC CENTER - - 4001- PORT OF RICHMOND 13,541 13,541 4003- WASTEWATER 38,583 38,583 4005- MARINA - - 4006- STORM WATER 10,171 10,171 4008- KCRT - CABLE TELEVIS 65 65 4101- RHA-HSNG CHOICE VOUCHER-SEC 8 - - 4102- RHA-HOPE 6 - - 4201- RHA-CAPITAL FUND 2,677 2,677 4401- RHA-HACIENDA - - 4404- RHA-NEVIN PLAZA 17 17 4405- RHA-NYSTROM VILLAGE - - 4406- RHA-RICHMOND VILLAGE ONE - - 4407- RHA-RICHMOND VILLAGE TWO - - 4408- RHA-RICHMOND VILLAGE THREE - - 4501- RHA-CENTRAL OFFICE COST CNTR 424 424 4502- RHA-HOUSING (RAD) CORPORATION - - 5001- INSURANCE RESERVES 64,107 64,107 5003- EQUIPMENT SERVICES 58,706 58,706 5005- CAD DISPATCH SYSTEM 32 32 5006- RMS RECORDS SERVICES - - 5008- COMPENSATED ABSENCES - - 6001- GENERAL TRUST & AGENCY - - 6004- COMMISSION ON AGING 3 3 6005- SEAVER GALLERY TRUST FUND - - 6007- SENIOR TRUST DEPOSIT 157 157 6047- CERTBT PLAN FUND - - 6048- OPEB PLAN TRUST - - 6049- PT MOLATE PRIVATE-PURPOSE TRST - - Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
12 - Summary

Page 165 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-177- Rev Collection

ALLOCATION SUMMARY
Total
Citywide
Revenue
Collection
Services
6050- GENERAL PENSION FUND - - 6051- POLICE & FIRE PENSION - - 6052- GARFIELD PENSION FUND - - 6058- MARINA WESTSHORE DEB - - 6059- COUNTRY CLUB VISTA - - 6060- REASSESSMENT DISTRICT 2003-1 - - 6101- SA-PROPERTY TAX TRUST FUND - - 6102- SA- ADMINISTRATION 1,372 1,372 6103- SA - CAPITAL PROJECT FUNDS 18,934 18,934 6208- SA-CIP 07B TARB BND PRCDS-HSG - - 6300- SA-DS HARBOR 98 TARB - - 6304- SA-DS 2003B TARB - - 6305- SA-DS 2004A TARB 2/3 - - 6306- SA-DS 2004A TARB -1/3 HSING - - 6307- SA-DS 2004B TARB - HOUSING - - 6308- SA-DS 2007/10A TARB - - 6309- SA-DS 2007/10B TARB - HOUSING - - 6401- SA-DS 2014A NON-TAXABLE BONDS - - 6402- SA-DS 2014B TAXABLE BONDS - - 6403- SA-DS LOANS PAYABLE - - 6404- SA-DS 2021A NON-TAXABLE BONDS is new - - 6405- SA-DS 2021B TAXABLE BONDS is new - - 6996- SUCCESSOR AGENCY - GLTDAG - - 9102- CITY OF RICHMOND - GFAAG - - AO- ALL OTHER 40,804 40,804
Total $ 864,048 $ 864,048
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
12 - Summary

Page 166 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-178- Purchasing
Distribution Percentage 100.00%
Expense Type $
Personnel
400002 - SALARIES & WAGES/Mgmt-Local 21 104,879$ S 104,879$ 400003 - SALARIES & WAGES/Local 1021 85,605 S 85,605
400031 - OVERTIME/General 230 S 230
400048 - OTHER PAY/Bilingual Pay 2,387 S 2,387
400099 - SAL & WAGES/GRNT/PRJ EXP(CON) (2,051) S (2,051) 400103 - P-ROLL BEN/Medicare Tax-ER Shr 2,822 S 2,822
400105 - P-ROLL BEN/Health Insurance Be 49,304 S 49,304 400106 - P-ROLL BEN/Dental Insurance 3,628 S 3,628
400109 - P-ROLL BEN/Employee Assistance 87 S 87
400110 - P-ROLL BEN/Professional Dev-Mg 750 S 750
400111 - P-ROLL BEN/Vision 424 S 424
400112 - P-ROLL BEN/Life Insurance 503 S 503
400114 - P-ROLL BEN/Long Term Disabilit 1,694 S 1,694
400116 - P-ROLL BEN/Unemployment Ins 882 S 882
400117 - P-ROLL BEN/Personal/Prof Dev 310 S 310
400121 - P-ROLL BEN/Worker Comp-Clerica 9,536 S 9,536
400122 - P-ROLL BEN/Worker Comp-Prof 9,360 S 9,360
400127 - P-ROLL BEN/OPEB 7,772 S 7,772
400149 - P-ROLL BEN/PERS-Misc 25,753 S 25,753
400151 - P-ROLL BEN/PERS-Misc (UAL) 50,462 S 50,462
Subtotal Personnel Cost 354,337$ 354,337$
Operating Services & Supplies
400201 - PROF SVCS/Professional Svcs 18,675$ S 18,675$
400246 - TRAVEL & TRNG/Registration Fee 570 S 570
400261 - DUES & PUB/Membership & Dues 839 S 839
400592 - COST POOL/(CON)-Admin Charges (43,668) S (43,668) Subtotal Operating Cost (23,584)$ (23,584)$
Disallowed Expenses
400592 - COST POOL/(CON)-Admin Charges 43,668$ [1] 43,668$ Subtotal Disallowed Costs 43,668$ 43,668$
DEPARTMENTAL EXPENDITURES 374,421$ 374,421$
Reallocation of Incoming Costs
First Allocation 8,096$ 382,517$
Unallocated Costs -$ -$
Subtotal of First Allocation 8,096$ 382,517$
Second Allocation 56,784$ 56,784$
Unallocated Costs -$ -$
Subtotal of Second Allocation 56,784$ 56,784$
TOTAL FUNCTIONAL COSTS 439,301$ 439,301$
Notes
[1] Admin charges are excluded and re-established through this CAP analysis

DEPARTMENTAL EXPENSE DETAIL
Spread
Method
Citywide
Purchasing
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
13 - EXP

Page 167 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-178- Purchasing First Second
Allocation Allocation Total
Departmental Expenditures $ 374,421 $ 374,421 Incoming Costs
BLDG- Building Use $ - $ - $ - EQUIP- Equipment Use - - - 0001-131- City Manager's Office 988 213 1,200 0001-141- City Clerk 959 184 1,143 0001-151- City Attorney 2,182 412 2,594 0001-171- Finance Administration 1,120 280 1,400 0001-172- Accounting 1,304 198 1,501 0001-173- Budget/Operating 688 140 828 0001-174- Payroll 790 169 959 0001-175- Treasury/Cash Management - - - 0001-176- Accounts Payable 65 12 77 0001-177- Rev Collection - - - 0001-178- Purchasing - - 0001-181- Human Resources 5,197 5,197 0001-232- Facility Maintenance and Administration - - 0001-235- Equipment Services/Fleet Services 7,813 7,813 0001-261- Information Technology Administration 3,680 3,680 0001-262- Telecommunications 4,033 4,033 0001-263- IT/Mailroom and Duplication, GIS, ERP and Desktop - - 0001-907, 908- Non-Departmental 34,453 34,453 - - -
- - -
- - -
- - -
- - -
Total Incoming Costs $ 8,096 $ 56,784 $ 64,880 Total Costs to be Allocated $ 382,517 $ 56,784 $ 439,301

COSTS TO BE ALLOCATED
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
13 - Costs

Page 168 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total Citywide Purchasing Services 13.1

ALLOCABLE BUDGET UNITS
BLDG- Building Use - 0.000% $ - $ - $ - EQUIP- Equipment Use - 0.000% - - - 0001-131- City Manager's Office 400 3.926% 15,017 15,017 15,017 0001-141- City Clerk - 0.000% - - - 0001-151- City Attorney 101 0.991% 3,792 3,792 3,792 0001-171- Finance Administration 2,114 20.748% 79,364 79,364 79,364 0001-172- Accounting - 0.000% - - - 0001-173- Budget/Operating - 0.000% - - - 0001-174- Payroll - 0.000% - - - 0001-175- Treasury/Cash Management - 0.000% - - - 0001-176- Accounts Payable - 0.000% - - - 0001-177- Rev Collection - 0.000% - - - 0001-178- Purchasing - 0.000% - - - 0001-181- Human Resources - 0.000% - - - - 0001-232- Facility Maintenance and Administration 196 1.924% 7,358 7,358 1,469 8,828 0001-235- Equipment Services/Fleet Services 246 2.414% 9,235 9,235 1,844 11,080 0001-261- Information Technology Administration 671 6.586% 25,191 25,191 5,031 30,221 0001-262- Telecommunications - 0.000% - - - - 0001-263- IT/Mailroom and Duplication, GIS, ERP and Desktop - 0.000% - - - - 0001-907, 908- Non-Departmental - 0.000% - - - - - - 0.000% - - - - - - 0.000% - - - - - - 0.000% - - - - - - 0.000% - - - - - - 0.000% - - - -

RECEIVING BUDGET UNITS
0001-101- OFFICE OF THE MAYOR - 0.000% - - - - 0001-105- COUNCIL/CITY COUNCIL DIV 59 0.579% 2,215 2,215 442 2,657 0001-121- POLICE COMMISSION DIV - 0.000% - - - - 0001-132- CM-SPCIAL PROJS/ENVIRONMENTAL - 0.000% - - - - 0001-163- GF-PLN/CODE ENFORCEMENT (DIV) - 0.000% - - - - 0001-191- GF-POLICE ADMIN DIV - 0.000% - - - - 0001-192- GF-POLICE-PATROL/CIB 48 0.471% 1,802 1,802 360 2,162 0001-193- GF-POLICE/CRIME PREVENTION 2 0.020% 75 75 15 90 0001-194- GF-POLICE-COPS GRANT 3 0.029% 113 113 22 135 0001-196- GF-POLICE/REGULATORY 3 0.029% 113 113 22 135 0001-197- CAD DISPATCH SYST/COMM POL DIV - 0.000% - - - - 0001-199- GF-PARKING ENFORCEMENT DIV - 0.000% - - - - 0001-201- GF-FIRE/ADMIN DIV - 0.000% - - - - 0001-202- GF-FIRE/SUPRESSN DIV 3 0.029% 113 113 22 135 0001-203- GF-FIRE PREVENTION DIV 14 0.137% 526 526 105 631 0001-204- GF-FIRE/ SUPPORT DIV - 0.000% - - - - 0001-205- GF-FIRE/TRAINING DIV 53 0.520% 1,990 1,990 397 2,387 0001-206- GF-FIRE/OF. OF EMS DIV - 0.000% - - - - 0001-211- OF. OF NB-HOOD SFTY ADMIN DIV - 0.000% - - - - 0001-212- OFF OF N-HOOD SFTY/GRANT ADM - 0.000% - - - - 0001-231- GF-PW ADMIN-DIV - 0.000% - - - - 0001-233- GF-PRKS&LNDSKP/PRKS (S-DIV) 3 0.029% 113 113 22 135 0001-178- Purchasing
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
13 - Allocations

Page 169 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total 0001-178- Purchasing
0001-234- IT GIS 44 0.432% 1,652 1,652 330 1,982 0001-237- GF-I&M/ABATEMENT SVCS (DIV) - 0.000% - - - - 0001-238- GF-I&M/CODE ENFORCEMENT (DIV) - 0.000% - - - - 0001-239- GF-I&M/PROP/ASSETS MNGT (DIV) - 0.000% - - - - 0001-241- GF-LIB&CL SVC/L-ADM DIV - 0.000% - - - - 0001-242- GF-LS/REF SVCS(S-DIV) 104 1.021% 3,904 3,904 780 4,684 0001-243- GF-LIB&CL SVCS/LEAP DIV - 0.000% - - - - 0001-244- GF-LIB&CL SVC/P-ART DIV 45 0.442% 1,689 1,689 337 2,027 0001-251- GF-RECREATION ADM DIV - 0.000% - - - - 0001-253- CM&NB/BOOKER T CTR (S-DIV) 120 1.178% 4,505 4,505 900 5,405 0001-255- GF-CM TRANSPORTATN OPERATIONS - 0.000% - - - - 0001-254- GF-REC/SPCL EVENTS (S-DIV) 42 0.412% 1,577 1,577 315 1,892 0001-256- RECREATION SVCS/AQUATICS 9 0.088% 338 338 67 405 0001-257- RECREATION SVCS/CONVENTION CTR 30 0.294% 1,126 1,126 225 1,351 0001-259- RECREATION SVCS/PLUNGE 28 0.275% 1,051 1,051 210 1,261 0001-260- RECREATION SVCS/CITIES OF SRVC - 0.000% - - - - 0001-291- GF-ADMINISTRATIVE SERVICES - 0.000% - - - - 0001-292- GF-STREET SWEEPING - 0.000% - - - - 0001-361- GF ECON DEV/SP PRJ-ENVIRONMNTL - 0.000% - - - - 0001-362- GF ECON DEV/SP PRJ-ENVIRONMNTL - 0.000% - - - - 0001-364- GF-ECON DEV/PUBLIC ART DIV - 0.000% - - - - 0001-369- GF-ECON DEV/REAL ESTATE (DIV) - 0.000% - - - - 0001-371- INTERNAL SERVICES-ADMIN - 0.000% - - - - 0001-910- GF-NON-DEPT/CITY FESTIVAL - 0.000% - - - - 1001- SECURED PENSION OVERRIDE - 0.000% - - - - 1002- STATE GAS TAX 127 1.246% 4,768 4,768 952 5,720 1003- TRANSPORTATION OPERATIONS 45 0.442% 1,689 1,689 337 2,027 1004- ASSET SEIZURE FUND 47 0.461% 1,764 1,764 352 2,117 1005- LIBRARY FUND 95 0.932% 3,567 3,567 712 4,279 1006- OUTSIDE FUNDED SVCS - GRANTS 444 4.358% 16,669 16,669 3,329 19,997 1007- EMERGENCY MED SERV 17 0.167% 638 638 127 766 1010- N.RICHMOND WASTE 58 0.569% 2,177 2,177 435 2,612 1012- HILLTOP LANDSCAPE MAINT DIST 36 0.353% 1,352 1,352 270 1,621 1013- FIRE DEPT HAZMAT GRANT 58 0.569% 2,177 2,177 435 2,612 1014- EDA GRANT FUND - 0.000% - - - - 1015- MARINA BAY LNDSCP&LIGHTDIST FD 29 0.285% 1,089 1,089 217 1,306 1017- CHEVRON MODERNIZATN PROJ & CIA - 0.000% - - - - 1018- RENT CONTROL - 0.000% - - - - 1019- SBI RMRA CAP IMPROVEMENT - 0.000% - - - - 1050- CR-PLANNING & BUILDING 180 1.767% 6,758 6,758 1,349 8,107 1051- CR-ENGINEERING 67 0.658% 2,515 2,515 502 3,018 1053- CODE ENFORCEMENT-CR 131 1.286% 4,918 4,918 982 5,900 1054- ENGINEERING GRANTS 37 0.363% 1,389 1,389 277 1,666 1055- ENCROACHMENTS SVCS - 0.000% - - - - 1200- COR HOUSING ADMINISTRATION 4 0.039% 150 150 30 180 1201- CDBG 141 1.384% 5,293 5,293 1,057 6,351 1203- NEIGHBORHOOD STABILIZATION 6 0.059% 225 225 45 270 1205- EMPLOYMENT & TRAINING 345 3.386% 12,952 12,952 2,587 15,539 1207- NEIGHBORHOOD STAB(CITY) - 0.000% - - - - 1208- SUCCESSOR HOUSING AGNCY - 0.000% - - - - 1209- CAL-HOME - 0.000% - - - - Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
13 - Allocations

Page 170 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total 0001-178- Purchasing
1302- HOUSNG IN LIEU FEE - DEVELOPER - 0.000% - - - - 1303- KIDS FIRST INITIATIVE - 0.000% - - - - 1304- EMERGENCY OPE & DISASTR RECVRY - 0.000% - - - - 2001- GENERAL CAPITAL FUND 324 3.180% 12,164 12,164 2,429 14,593 2002- MEASURE J 110 1.080% 4,130 4,130 825 4,954 2110- IMPACT FEE - PARK 100 0.981% 3,754 3,754 750 4,504 2111- PF IMP FEES-TRAFFIC/ROAD-ENG 11 0.108% 413 413 82 495 2113- IMPACT FEE - FIRE 8 0.079% 300 300 60 360 2114- IMPACT FEE - POLICE 13 0.128% 488 488 97 586 2115- IMPACT FEE - COMM/AQUATC 11 0.108% 413 413 82 495 2116- IMPACT FEE - PARKS/OPEN 39 0.383% 1,464 1,464 292 1,757 2117- IMPACT FEE - LIBRARY 20 0.196% 751 751 150 901 2119- IMPACT FEE - STORM DRAINAGE - 0.000% - - - - 2120- IMPACT FEE - WASTEWATER - 0.000% - - - - 2125- IRON TRIANGLE/EPA PROGRAMS - 0.000% - - - - 2126- COR-HOUSING DEPT CIP FUND 1 0.010% 38 38 7 45 3001- DS - 2005 TAXABLE POB - 0.000% - - - - 3002- DS - 99A PENSION OBLIG BOND - 0.000% - - - - 3005- DS - 2007 CIVIC CENTER - 0.000% - - - - 4001- PORT OF RICHMOND 282 2.768% 10,587 10,587 2,114 12,701 4003- WASTEWATER 227 2.228% 8,522 8,522 1,702 10,224 4005- MARINA 4 0.039% 150 150 30 180 4006- STORM WATER 58 0.569% 2,177 2,177 435 2,612 4008- KCRT - CABLE TELEVIS 21 0.206% 788 788 157 946 4101- RHA-HSNG CHOICE VOUCHER-SEC 8 - 0.000% - - - - 4102- RHA-HOPE 6 - 0.000% - - - - 4201- RHA-CAPITAL FUND - 0.000% - - - - 4401- RHA-HACIENDA - 0.000% - - - - 4404- RHA-NEVIN PLAZA - 0.000% - - - - 4405- RHA-NYSTROM VILLAGE - 0.000% - - - - 4406- RHA-RICHMOND VILLAGE ONE - 0.000% - - - - 4407- RHA-RICHMOND VILLAGE TWO - 0.000% - - - - 4408- RHA-RICHMOND VILLAGE THREE - 0.000% - - - - 4501- RHA-CENTRAL OFFICE COST CNTR - 0.000% - - - - 4502- RHA-HOUSING (RAD) CORPORATION - 0.000% - - - - 5001- INSURANCE RESERVES 210 2.061% 7,884 7,884 1,574 9,458 5003- EQUIPMENT SERVICES 736 7.223% 27,631 27,631 5,518 33,149 5005- CAD DISPATCH SYSTEM 72 0.707% 2,703 2,703 540 3,243 5006- RMS RECORDS SERVICES 39 0.383% 1,464 1,464 292 1,757 5008- COMPENSATED ABSENCES - 0.000% - - - - 6001- GENERAL TRUST & AGENCY - 0.000% - - - - 6004- COMMISSION ON AGING - 0.000% - - - - 6005- SEAVER GALLERY TRUST FUND - 0.000% - - - - 6007- SENIOR TRUST DEPOSIT - 0.000% - - - - 6047- CERTBT PLAN FUND - 0.000% - - - - 6048- OPEB PLAN TRUST - 0.000% - - - - 6049- PT MOLATE PRIVATE-PURPOSE TRST - 0.000% - - - - 6050- GENERAL PENSION FUND - 0.000% - - - - 6051- POLICE & FIRE PENSION - 0.000% - - - - 6052- GARFIELD PENSION FUND - 0.000% - - - - 6058- MARINA WESTSHORE DEB - 0.000% - - - - 6059- COUNTRY CLUB VISTA - 0.000% - - - - Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
13 - Allocations

Page 171 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total 0001-178- Purchasing
6060- REASSESSMENT DISTRICT 2003-1 - 0.000% - - - - 6101- SA-PROPERTY TAX TRUST FUND - 0.000% - - - - 6102- SA- ADMINISTRATION 10 0.098% 375 375 75 450 6103- SA - CAPITAL PROJECT FUNDS 57 0.559% 2,140 2,140 427 2,567 6208- SA-CIP 07B TARB BND PRCDS-HSG - 0.000% - - - - 6300- SA-DS HARBOR 98 TARB - 0.000% - - - - 6304- SA-DS 2003B TARB - 0.000% - - - - 6305- SA-DS 2004A TARB 2/3 - 0.000% - - - - 6306- SA-DS 2004A TARB -1/3 HSING - 0.000% - - - - 6307- SA-DS 2004B TARB - HOUSING - 0.000% - - - - 6308- SA-DS 2007/10A TARB - 0.000% - - - - 6309- SA-DS 2007/10B TARB - HOUSING - 0.000% - - - - 6401- SA-DS 2014A NON-TAXABLE BONDS - 0.000% - - - - 6402- SA-DS 2014B TAXABLE BONDS - 0.000% - - - - 6403- SA-DS LOANS PAYABLE - 0.000% - - - - 6404- SA-DS 2021A NON-TAXABLE BONDS is new - 0.000% - - - - 6405- SA-DS 2021B TAXABLE BONDS is new - 0.000% - - - - 6996- SUCCESSOR AGENCY - GLTDAG - 0.000% - - - - 9102- CITY OF RICHMOND - GFAAG - 0.000% - - - - AO- ALL OTHER 1,631 16.007% 61,231 61,231 12,228 73,459 Total 10,189 100.000% $ 382,517 $ - $ 382,517 $ 56,784 $ 439,301 Allocation Basis: FY 20-21 Total PO's per Fund/Department Source of Allocation: fy 20-21 purchasing docs by fund by org_nbs.xlsx Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
13 - Allocations

Page 172 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-178- Purchasing

ALLOCABLE BUDGET UNITS
BLDG- Building Use $ - $ - EQUIP- Equipment Use - - 0001-131- City Manager's Office 15,017 15,017 0001-141- City Clerk - - 0001-151- City Attorney 3,792 3,792 0001-171- Finance Administration 79,364 79,364 0001-172- Accounting - - 0001-173- Budget/Operating - - 0001-174- Payroll - - 0001-175- Treasury/Cash Management - - 0001-176- Accounts Payable - - 0001-177- Rev Collection - - 0001-178- Purchasing - - 0001-181- Human Resources - - 0001-232- Facility Maintenance and Administration 8,828 8,828 0001-235- Equipment Services/Fleet Services 11,080 11,080 0001-261- Information Technology Administration 30,221 30,221 0001-262- Telecommunications - - 0001-263- IT/Mailroom and Duplication, GIS, ERP and Desktop - - 0001-907, 908- Non-Departmental - - - - -
- - -
- - -
- - -
- - -

RECEIVING BUDGET UNITS
0001-101- OFFICE OF THE MAYOR - - 0001-105- COUNCIL/CITY COUNCIL DIV 2,657 2,657 0001-121- POLICE COMMISSION DIV - - 0001-132- CM-SPCIAL PROJS/ENVIRONMENTAL - - 0001-163- GF-PLN/CODE ENFORCEMENT (DIV) - - 0001-191- GF-POLICE ADMIN DIV - - 0001-192- GF-POLICE-PATROL/CIB 2,162 2,162 0001-193- GF-POLICE/CRIME PREVENTION 90 90 0001-194- GF-POLICE-COPS GRANT 135 135 0001-196- GF-POLICE/REGULATORY 135 135 0001-197- CAD DISPATCH SYST/COMM POL DIV - - 0001-199- GF-PARKING ENFORCEMENT DIV - - 0001-201- GF-FIRE/ADMIN DIV - - 0001-202- GF-FIRE/SUPRESSN DIV 135 135 0001-203- GF-FIRE PREVENTION DIV 631 631 0001-204- GF-FIRE/ SUPPORT DIV - - 0001-205- GF-FIRE/TRAINING DIV 2,387 2,387 0001-206- GF-FIRE/OF. OF EMS DIV - - 0001-211- OF. OF NB-HOOD SFTY ADMIN DIV - - 0001-212- OFF OF N-HOOD SFTY/GRANT ADM - - 0001-231- GF-PW ADMIN-DIV - - 0001-233- GF-PRKS&LNDSKP/PRKS (S-DIV) 135 135 0001-234- IT GIS 1,982 1,982

ALLOCATION SUMMARY
Total
Citywide
Purchasing
Services
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
13 - Summary

Page 173 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-178- Purchasing

ALLOCATION SUMMARY
Total
Citywide
Purchasing
Services
0001-237- GF-I&M/ABATEMENT SVCS (DIV) - - 0001-238- GF-I&M/CODE ENFORCEMENT (DIV) - - 0001-239- GF-I&M/PROP/ASSETS MNGT (DIV) - - 0001-241- GF-LIB&CL SVC/L-ADM DIV - - 0001-242- GF-LS/REF SVCS(S-DIV) 4,684 4,684 0001-243- GF-LIB&CL SVCS/LEAP DIV - - 0001-244- GF-LIB&CL SVC/P-ART DIV 2,027 2,027 0001-251- GF-RECREATION ADM DIV - - 0001-253- CM&NB/BOOKER T CTR (S-DIV) 5,405 5,405 0001-255- GF-CM TRANSPORTATN OPERATIONS - - 0001-254- GF-REC/SPCL EVENTS (S-DIV) 1,892 1,892 0001-256- RECREATION SVCS/AQUATICS 405 405 0001-257- RECREATION SVCS/CONVENTION CTR 1,351 1,351 0001-259- RECREATION SVCS/PLUNGE 1,261 1,261 0001-260- RECREATION SVCS/CITIES OF SRVC - - 0001-291- GF-ADMINISTRATIVE SERVICES - - 0001-292- GF-STREET SWEEPING - - 0001-361- GF ECON DEV/SP PRJ-ENVIRONMNTL - - 0001-362- GF ECON DEV/SP PRJ-ENVIRONMNTL - - 0001-364- GF-ECON DEV/PUBLIC ART DIV - - 0001-369- GF-ECON DEV/REAL ESTATE (DIV) - - 0001-371- INTERNAL SERVICES-ADMIN - - 0001-910- GF-NON-DEPT/CITY FESTIVAL - - 1001- SECURED PENSION OVERRIDE - - 1002- STATE GAS TAX 5,720 5,720 1003- TRANSPORTATION OPERATIONS 2,027 2,027 1004- ASSET SEIZURE FUND 2,117 2,117 1005- LIBRARY FUND 4,279 4,279
1006- OUTSIDE FUNDED SVCS - GRANTS 19,997 19,997 1007- EMERGENCY MED SERV 766 766 1010- N.RICHMOND WASTE 2,612 2,612 1012- HILLTOP LANDSCAPE MAINT DIST 1,621 1,621 1013- FIRE DEPT HAZMAT GRANT 2,612 2,612 1014- EDA GRANT FUND - - 1015- MARINA BAY LNDSCP&LIGHTDIST FD 1,306 1,306 1017- CHEVRON MODERNIZATN PROJ & CIA - - 1018- RENT CONTROL - - 1019- SBI RMRA CAP IMPROVEMENT - - 1050- CR-PLANNING & BUILDING 8,107 8,107 1051- CR-ENGINEERING 3,018 3,018 1053- CODE ENFORCEMENT-CR 5,900 5,900 1054- ENGINEERING GRANTS 1,666 1,666 1055- ENCROACHMENTS SVCS - - 1200- COR HOUSING ADMINISTRATION 180 180 1201- CDBG 6,351 6,351
1203- NEIGHBORHOOD STABILIZATION 270 270 1205- EMPLOYMENT & TRAINING 15,539 15,539 1207- NEIGHBORHOOD STAB(CITY) - - 1208- SUCCESSOR HOUSING AGNCY - - 1209- CAL-HOME - - Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
13 - Summary

Page 174 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-178- Purchasing

ALLOCATION SUMMARY
Total
Citywide
Purchasing
Services
1302- HOUSNG IN LIEU FEE - DEVELOPER - - 1303- KIDS FIRST INITIATIVE - - 1304- EMERGENCY OPE & DISASTR RECVRY - - 2001- GENERAL CAPITAL FUND 14,593 14,593 2002- MEASURE J 4,954 4,954
2110- IMPACT FEE - PARK 4,504 4,504 2111- PF IMP FEES-TRAFFIC/ROAD-ENG 495 495 2113- IMPACT FEE - FIRE 360 360 2114- IMPACT FEE - POLICE 586 586 2115- IMPACT FEE - COMM/AQUATC 495 495 2116- IMPACT FEE - PARKS/OPEN 1,757 1,757 2117- IMPACT FEE - LIBRARY 901 901 2119- IMPACT FEE - STORM DRAINAGE - - 2120- IMPACT FEE - WASTEWATER - - 2125- IRON TRIANGLE/EPA PROGRAMS - - 2126- COR-HOUSING DEPT CIP FUND 45 45 3001- DS - 2005 TAXABLE POB - - 3002- DS - 99A PENSION OBLIG BOND - - 3005- DS - 2007 CIVIC CENTER - - 4001- PORT OF RICHMOND 12,701 12,701 4003- WASTEWATER 10,224 10,224
4005- MARINA 180 180
4006- STORM WATER 2,612 2,612
4008- KCRT - CABLE TELEVIS 946 946 4101- RHA-HSNG CHOICE VOUCHER-SEC 8 - - 4102- RHA-HOPE 6 - - 4201- RHA-CAPITAL FUND - - 4401- RHA-HACIENDA - - 4404- RHA-NEVIN PLAZA - - 4405- RHA-NYSTROM VILLAGE - - 4406- RHA-RICHMOND VILLAGE ONE - - 4407- RHA-RICHMOND VILLAGE TWO - - 4408- RHA-RICHMOND VILLAGE THREE - - 4501- RHA-CENTRAL OFFICE COST CNTR - - 4502- RHA-HOUSING (RAD) CORPORATION - - 5001- INSURANCE RESERVES 9,458 9,458 5003- EQUIPMENT SERVICES 33,149 33,149 5005- CAD DISPATCH SYSTEM 3,243 3,243 5006- RMS RECORDS SERVICES 1,757 1,757 5008- COMPENSATED ABSENCES - - 6001- GENERAL TRUST & AGENCY - - 6004- COMMISSION ON AGING - - 6005- SEAVER GALLERY TRUST FUND - - 6007- SENIOR TRUST DEPOSIT - - 6047- CERTBT PLAN FUND - - 6048- OPEB PLAN TRUST - - 6049- PT MOLATE PRIVATE-PURPOSE TRST - - 6050- GENERAL PENSION FUND - - 6051- POLICE & FIRE PENSION - - 6052- GARFIELD PENSION FUND - - Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
13 - Summary

Page 175 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-178- Purchasing

ALLOCATION SUMMARY
Total
Citywide
Purchasing
Services
6058- MARINA WESTSHORE DEB - - 6059- COUNTRY CLUB VISTA - - 6060- REASSESSMENT DISTRICT 2003-1 - - 6101- SA-PROPERTY TAX TRUST FUND - - 6102- SA- ADMINISTRATION 450 450 6103- SA - CAPITAL PROJECT FUNDS 2,567 2,567 6208- SA-CIP 07B TARB BND PRCDS-HSG - - 6300- SA-DS HARBOR 98 TARB - - 6304- SA-DS 2003B TARB - - 6305- SA-DS 2004A TARB 2/3 - - 6306- SA-DS 2004A TARB -1/3 HSING - - 6307- SA-DS 2004B TARB - HOUSING - - 6308- SA-DS 2007/10A TARB - - 6309- SA-DS 2007/10B TARB - HOUSING - - 6401- SA-DS 2014A NON-TAXABLE BONDS - - 6402- SA-DS 2014B TAXABLE BONDS - - 6403- SA-DS LOANS PAYABLE - - 6404- SA-DS 2021A NON-TAXABLE BONDS is new - - 6405- SA-DS 2021B TAXABLE BONDS is new - - 6996- SUCCESSOR AGENCY - GLTDAG - - 9102- CITY OF RICHMOND - GFAAG - - AO- ALL OTHER 73,459 73,459
Total $ 439,301 $ 439,301
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
13 - Summary

Page 176 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-181- Human Resources
Distribution Percentage 50.00% 50.00%
Expense Type $
Personnel
400001 - SALARIES & WAGES/Executive 306,843$ S 153,422 153,422$ 400002 - SALARIES & WAGES/Mgmt-Local 21 445,604 S 222,802 222,802 400003 - SALARIES & WAGES/Local 1021 62,325 S 31,163 31,163 400006 - SALARIES & WAGES/PT- Temp 74,465 S 37,232 37,232 400031 - OVERTIME/General 2,435 S 1,217 1,217
400048 - OTHER PAY/Bilingual Pay 2,405 S 1,203 1,203
400049 - OTHER PAY/Auto Allowance 700 S 350 350
400103 - P-ROLL BEN/Medicare Tax-ER Shr 13,140 S 6,570 6,570 400105 - P-ROLL BEN/Health Insurance Be 131,150 S 65,575 65,575 400106 - P-ROLL BEN/Dental Insurance 12,147 S 6,073 6,073 400109 - P-ROLL BEN/Employee Assistance 293 S 146 146
400110 - P-ROLL BEN/Professional Dev-Mg 6,895 S 3,448 3,448 400111 - P-ROLL BEN/Vision 1,420 S 710 710
400112 - P-ROLL BEN/Life Insurance 2,971 S 1,486 1,486
400114 - P-ROLL BEN/Long Term Disabilit 7,173 S 3,586 3,586 400116 - P-ROLL BEN/Unemployment Ins 3,173 S 1,586 1,586 400121 - P-ROLL BEN/Worker Comp-Clerica 6,943 S 3,471 3,471 400122 - P-ROLL BEN/Worker Comp-Prof 74,008 S 37,004 37,004 400127 - P-ROLL BEN/OPEB 33,211 S 16,605 16,605
400149 - P-ROLL BEN/PERS-Misc 109,003 S 54,502 54,502
400151 - P-ROLL BEN/PERS-Misc (UAL) 171,126 S 85,563 85,563 Subtotal Personnel Cost 1,467,427$ 733,714$ 733,714$
Operating Services & Supplies
400201 - PROF SVCS/Professional Svcs 233,525$ S 116,763$ 116,763$ 400206 - PROF SVCS/Legal Serv Cost 226,982 S 113,491 113,491 400216 - PROF SVCS/Recruitment Svcs 49,850 S 24,925 24,925 400231 - OFF EXP/Postage & Mailing 833 S 417 417
400246 - TRAVEL & TRNG/Registration Fee 2,880 S 1,440 1,440 400261 - DUES & PUB/Membership & Dues 149 S 75 75
400263 - DUES & PUB/Subscription 750 S 375 375
400271 - AD & PROMO/Advertising&Promo 7,388 S 3,694 3,694 400291 - ADM EXP/Recruitment Expenses 6,888 S 3,444 3,444 400304 - RENTAL EXP/Equipment Rental 8,758 S 4,379 4,379 400322 - MISC EXP/Misc Exp 1,754 S 877 877
400341 - OFF SUPP/Office Supplies 5,665 S 2,832 2,832
400538 - CONTRACT SVCS/Oth Cntrctl Svcs 69 S 35 35
400574 - COST POOL/(ISF)-Gen Liability 102,656 S 51,328 51,328 400592 - COST POOL/(CON)-Admin Charges (204,698) S (102,349) (102,349) Subtotal Operating Cost 443,449$ 221,725$ 221,725$

DEPARTMENTAL EXPENSE DETAIL
Spread
Method
System-wide
Support A
System-wide
Support B
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
14 - EXP

Page 177 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-181- Human Resources
Distribution Percentage 50.00% 50.00%
Expense Type $

DEPARTMENTAL EXPENSE DETAIL
Spread
Method
System-wide
Support A
System-wide
Support B
Disallowed Expenses
400271 - AD & PROMO/Advertising&Promo (7,388)$ [1] (3,694)$ (3,694)$ 400201 - PROF SVCS/Professional Svcs (4,000) [1] (2,000) (2,000) 400592 - COST POOL/(CON)-Admin Charges 204,698 [2] 102,349 102,349 Subtotal Disallowed Costs 193,310$ 96,655$ 96,655$
DEPARTMENTAL EXPENDITURES 2,104,186$ 1,052,093$ 1,052,093$ Reallocation of Incoming Costs
First Allocation 102,045$ 1,103,116$ 1,103,116$
Unallocated Costs -$ -$ -$
Subtotal of First Allocation 102,045$ 1,103,116$ 1,103,116$ Second Allocation 314,903$ 157,451$ 157,451$
Unallocated Costs -$ -$ -$
Subtotal of Second Allocation 314,903$ 157,451$ 157,451$ TOTAL FUNCTIONAL COSTS 2,521,134$ 1,260,567$ 1,260,567$ [1] Costs not allowable per Title 2 CFR part 200
[2] Admin charges are excluded and re-established through this CAP analysis Notes
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
14 - EXP

Page 178 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures 0001-181- Human Resources First Second
Allocation Allocation Total
Departmental Expenditures $ 2,104,186 $ 2,104,186 Incoming Costs
BLDG- Building Use $ - $ - $ - EQUIP- Equipment Use - - - 0001-131- City Manager's Office 5,969 1,287 7,255 0001-141- City Clerk 5,823 1,116 6,939 0001-151- City Attorney 43,347 8,701 52,047 0001-171- Finance Administration 6,000 1,502 7,501 0001-172- Accounting 11,261 1,704 12,965 0001-173- Budget/Operating 3,684 752 4,436 0001-174- Payroll 5,138 1,096 6,234 0001-175- Treasury/Cash Management 8,087 1,429 9,517 0001-176- Accounts Payable 2,420 461 2,880 0001-177- Rev Collection 10,317 1,737 12,054 0001-178- Purchasing - - - 0001-181- Human Resources 27,328 27,328 0001-232- Facility Maintenance and Administration - - 0001-235- Equipment Services/Fleet Services 50,786 50,786 0001-261- Information Technology Administration 20,852 20,852 0001-262- Telecommunications 26,212 26,212 0001-263- IT/Mailroom and Duplication, GIS, ERP and Desktop - - 0001-907, 908- Non-Departmental 169,941 169,941 - - -
- - -
- - -
- - -
- - -
Total Incoming Costs $ 102,045 $ 314,903 $ 416,948 Total Costs to be Allocated $ 2,206,232 $ 314,903 $ 2,521,134

COSTS TO BE ALLOCATED
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
14 - Costs

Page 179 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total System-wide Support A 14.1

ALLOCABLE BUDGET UNITS
BLDG- Building Use - 0.000% $ - $ - $ - EQUIP- Equipment Use - 0.000% - - - 0001-131- City Manager's Office 4 0.446% 4,925 4,925 4,925 0001-141- City Clerk 4 0.446% 4,925 4,925 4,925 0001-151- City Attorney 11 1.228% 13,543 13,543 13,543 0001-171- Finance Administration 3 0.335% 3,693 3,693 3,693 0001-172- Accounting 7 0.781% 8,618 8,618 8,618 0001-173- Budget/Operating 4 0.446% 4,925 4,925 4,925 0001-174- Payroll 3 0.335% 3,693 3,693 3,693 0001-175- Treasury/Cash Management 4 0.446% 4,925 4,925 4,925 0001-176- Accounts Payable 2 0.223% 2,462 2,462 2,462 0001-177- Rev Collection 5 0.558% 6,156 6,156 6,156 0001-178- Purchasing 2 0.223% 2,462 2,462 2,462 0001-181- Human Resources 13 1.451% 16,005 16,005 16,005 0001-232- Facility Maintenance and Administration 34 3.795% 41,859 41,859 6,419 48,278 0001-235- Equipment Services/Fleet Services 13 1.451% 16,005 16,005 2,454 18,459 0001-261- Information Technology Administration 4 0.446% 4,925 4,925 755 5,680 0001-262- Telecommunications 4 0.446% 4,925 4,925 755 5,680 0001-263- IT/Mailroom and Duplication, GIS, ERP and Desktop 1 0.112% 1,231 1,231 189 1,420 0001-907, 908- Non-Departmental - 0.000% - - - - - - 0.000% - - - - - - 0.000% - - - - - - 0.000% - - - - - - 0.000% - - - - - - 0.000% - - - -

RECEIVING BUDGET UNITS
0001-101- OFFICE OF THE MAYOR 3 0.335% 3,693 3,693 566 4,260 0001-105- COUNCIL/CITY COUNCIL DIV 11 1.228% 13,543 13,543 2,077 15,619 0001-121- POLICE COMMISSION DIV 2 0.223% 2,462 2,462 378 2,840 0001-132- CM-SPCIAL PROJS/ENVIRONMENTAL - 0.000% - - - - 0001-163- GF-PLN/CODE ENFORCEMENT (DIV) 6 0.670% 7,387 7,387 1,133 8,520 0001-191- GF-POLICE ADMIN DIV 199 22.210% 245,000 245,000 37,569 282,569 0001-192- GF-POLICE-PATROL/CIB - 0.000% - - - - 0001-193- GF-POLICE/CRIME PREVENTION 2 0.223% 2,462 2,462 378 2,840 0001-194- GF-POLICE-COPS GRANT 1 0.112% 1,231 1,231 189 1,420 0001-196- GF-POLICE/REGULATORY 2 0.223% 2,462 2,462 378 2,840 0001-197- CAD DISPATCH SYST/COMM POL DIV 26 2.902% 32,010 32,010 4,909 36,919 0001-199- GF-PARKING ENFORCEMENT DIV 1 0.112% 1,231 1,231 189 1,420 0001-201- GF-FIRE/ADMIN DIV 4 0.446% 4,925 4,925 755 5,680 0001-202- GF-FIRE/SUPRESSN DIV 82 9.152% 100,955 100,955 15,481 116,436 0001-203- GF-FIRE PREVENTION DIV 7 0.781% 8,618 8,618 1,322 9,940 0001-204- GF-FIRE/ SUPPORT DIV - 0.000% - - - - 0001-205- GF-FIRE/TRAINING DIV 1 0.112% 1,231 1,231 189 1,420 0001-206- GF-FIRE/OF. OF EMS DIV 2 0.223% 2,462 2,462 378 2,840 0001-211- OF. OF NB-HOOD SFTY ADMIN DIV 17 1.897% 20,930 20,930 3,209 24,139 0001-212- OFF OF N-HOOD SFTY/GRANT ADM - 0.000% - - - - 0001-231- GF-PW ADMIN-DIV 7 0.781% 8,618 8,618 1,322 9,940 0001-233- GF-PRKS&LNDSKP/PRKS (S-DIV) 36 4.018% 44,322 44,322 6,796 51,118 0001-181- Human Resources
Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
14 - Allocations

Page 180 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total 0001-181- Human Resources
0001-234- IT GIS 29 3.237% 35,704 35,704 5,475 41,178 0001-237- GF-I&M/ABATEMENT SVCS (DIV) 16 1.786% 19,698 19,698 3,021 22,719 0001-238- GF-I&M/CODE ENFORCEMENT (DIV) 1 0.112% 1,231 1,231 189 1,420 0001-239- GF-I&M/PROP/ASSETS MNGT (DIV) - 0.000% - - - - 0001-241- GF-LIB&CL SVC/L-ADM DIV 40 4.464% 49,246 49,246 7,552 56,798 0001-242- GF-LS/REF SVCS(S-DIV) - 0.000% - - - - 0001-243- GF-LIB&CL SVCS/LEAP DIV 10 1.116% 12,312 12,312 1,888 14,199 0001-244- GF-LIB&CL SVC/P-ART DIV - 0.000% - - - - 0001-251- GF-RECREATION ADM DIV 15 1.674% 18,467 18,467 2,832 21,299 0001-253- CM&NB/BOOKER T CTR (S-DIV) 36 4.018% 44,322 44,322 6,796 51,118 0001-255- GF-CM TRANSPORTATN OPERATIONS 2 0.223% 2,462 2,462 378 2,840 0001-254- GF-REC/SPCL EVENTS (S-DIV) 10 1.116% 12,312 12,312 1,888 14,199 0001-256- RECREATION SVCS/AQUATICS 37 4.129% 45,553 45,553 6,985 52,538 0001-257- RECREATION SVCS/CONVENTION CTR 4 0.446% 4,925 4,925 755 5,680 0001-259- RECREATION SVCS/PLUNGE 1 0.112% 1,231 1,231 189 1,420 0001-260- RECREATION SVCS/CITIES OF SRVC 2 0.223% 2,462 2,462 378 2,840 0001-291- GF-ADMINISTRATIVE SERVICES 1 0.112% 1,231 1,231 189 1,420 0001-292- GF-STREET SWEEPING 1 0.112% 1,231 1,231 189 1,420 0001-361- GF ECON DEV/SP PRJ-ENVIRONMNTL 3 0.335% 3,693 3,693 566 4,260 0001-362- GF ECON DEV/SP PRJ-ENVIRONMNTL 1 0.112% 1,231 1,231 189 1,420 0001-364- GF-ECON DEV/PUBLIC ART DIV 1 0.112% 1,231 1,231 189 1,420 0001-369- GF-ECON DEV/REAL ESTATE (DIV) 2 0.223% 2,462 2,462 378 2,840 0001-371- INTERNAL SERVICES-ADMIN 2 0.223% 2,462 2,462 378 2,840 0001-910- GF-NON-DEPT/CITY FESTIVAL - 0.000% - - - - 1001- SECURED PENSION OVERRIDE - 0.000% - - - - 1002- STATE GAS TAX - 0.000% - - - - 1003- TRANSPORTATION OPERATIONS 4 0.446% 4,925 4,925 755 5,680 1004- ASSET SEIZURE FUND - 0.000% - - - - 1005- LIBRARY FUND - 0.000% - - - - 1006- OUTSIDE FUNDED SVCS - GRANTS - 0.000% - - - - 1007- EMERGENCY MED SERV - 0.000% - - - - 1010- N.RICHMOND WASTE - 0.000% - - - - 1012- HILLTOP LANDSCAPE MAINT DIST 13 1.451% 16,005 16,005 2,454 18,459 1013- FIRE DEPT HAZMAT GRANT - 0.000% - - - - 1014- EDA GRANT FUND - 0.000% - - - - 1015- MARINA BAY LNDSCP&LIGHTDIST FD 12 1.339% 14,774 14,774 2,265 17,039 1017- CHEVRON MODERNIZATN PROJ & CIA - 0.000% - - - - 1018- RENT CONTROL 13 1.451% 16,005 16,005 2,454 18,459 1019- SBI RMRA CAP IMPROVEMENT - 0.000% - - - - 1050- CR-PLANNING & BUILDING 24 2.679% 29,548 29,548 4,531 34,079 1051- CR-ENGINEERING - 0.000% - - - - 1053- CODE ENFORCEMENT-CR - 0.000% - - - - 1054- ENGINEERING GRANTS - 0.000% - - - - 1055- ENCROACHMENTS SVCS 8 0.893% 9,849 9,849 1,510 11,360 1200- COR HOUSING ADMINISTRATION 3 0.335% 3,693 3,693 566 4,260 1201- CDBG - 0.000% - - - - 1203- NEIGHBORHOOD STABILIZATION - 0.000% - - - - 1205- EMPLOYMENT & TRAINING 17 1.897% 20,930 20,930 3,209 24,139 1207- NEIGHBORHOOD STAB(CITY) - 0.000% - - - - 1208- SUCCESSOR HOUSING AGNCY - 0.000% - - - - 1209- CAL-HOME - 0.000% - - - - Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
14 - Allocations

Page 181 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total 0001-181- Human Resources
1302- HOUSNG IN LIEU FEE - DEVELOPER - 0.000% - - - - 1303- KIDS FIRST INITIATIVE 3 0.335% 3,693 3,693 566 4,260 1304- EMERGENCY OPE & DISASTR RECVRY - 0.000% - - - - 2001- GENERAL CAPITAL FUND - 0.000% - - - - 2002- MEASURE J - 0.000% - - - - 2110- IMPACT FEE - PARK - 0.000% - - - - 2111- PF IMP FEES-TRAFFIC/ROAD-ENG - 0.000% - - - - 2113- IMPACT FEE - FIRE - 0.000% - - - - 2114- IMPACT FEE - POLICE - 0.000% - - - - 2115- IMPACT FEE - COMM/AQUATC - 0.000% - - - - 2116- IMPACT FEE - PARKS/OPEN - 0.000% - - - - 2117- IMPACT FEE - LIBRARY - 0.000% - - - - 2119- IMPACT FEE - STORM DRAINAGE - 0.000% - - - - 2120- IMPACT FEE - WASTEWATER - 0.000% - - - - 2125- IRON TRIANGLE/EPA PROGRAMS - 0.000% - - - - 2126- COR-HOUSING DEPT CIP FUND - 0.000% - - - - 3001- DS - 2005 TAXABLE POB - 0.000% - - - - 3002- DS - 99A PENSION OBLIG BOND - 0.000% - - - - 3005- DS - 2007 CIVIC CENTER - 0.000% - - - - 4001- PORT OF RICHMOND 3 0.335% 3,693 3,693 566 4,260 4003- WASTEWATER 9 1.004% 11,080 11,080 1,699 12,780 4005- MARINA - 0.000% - - - - 4006- STORM WATER - 0.000% - - - - 4008- KCRT - CABLE TELEVIS 4 0.446% 4,925 4,925 755 5,680 4101- RHA-HSNG CHOICE VOUCHER-SEC 8 - 0.000% - - - - 4102- RHA-HOPE 6 - 0.000% - - - - 4201- RHA-CAPITAL FUND - 0.000% - - - - 4401- RHA-HACIENDA - 0.000% - - - - 4404- RHA-NEVIN PLAZA 2 0.223% 2,462 2,462 378 2,840 4405- RHA-NYSTROM VILLAGE 1 0.112% 1,231 1,231 189 1,420 4406- RHA-RICHMOND VILLAGE ONE - 0.000% - - - - 4407- RHA-RICHMOND VILLAGE TWO - 0.000% - - - - 4408- RHA-RICHMOND VILLAGE THREE - 0.000% - - - - 4501- RHA-CENTRAL OFFICE COST CNTR 1 0.112% 1,231 1,231 189 1,420 4502- RHA-HOUSING (RAD) CORPORATION - 0.000% - - - - 5001- INSURANCE RESERVES 5 0.558% 6,156 6,156 944 7,100 5003- EQUIPMENT SERVICES - 0.000% - - - - 5005- CAD DISPATCH SYSTEM 1 0.112% 1,231 1,231 189 1,420 5006- RMS RECORDS SERVICES - 0.000% - - - - 5008- COMPENSATED ABSENCES - 0.000% - - - - 6001- GENERAL TRUST & AGENCY - 0.000% - - - - 6004- COMMISSION ON AGING - 0.000% - - - - 6005- SEAVER GALLERY TRUST FUND - 0.000% - - - - 6007- SENIOR TRUST DEPOSIT - 0.000% - - - - 6047- CERTBT PLAN FUND - 0.000% - - - - 6048- OPEB PLAN TRUST - 0.000% - - - - 6049- PT MOLATE PRIVATE-PURPOSE TRST - 0.000% - - - - 6050- GENERAL PENSION FUND 7 0.781% 8,618 8,618 1,322 9,940 6051- POLICE & FIRE PENSION 24 2.679% 29,548 29,548 4,531 34,079 6052- GARFIELD PENSION FUND 1 0.112% 1,231 1,231 189 1,420 6058- MARINA WESTSHORE DEB - 0.000% - - - - 6059- COUNTRY CLUB VISTA - 0.000% - - - - Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
14 - Allocations

Page 182 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total 0001-181- Human Resources
6060- REASSESSMENT DISTRICT 2003-1 - 0.000% - - - - 6101- SA-PROPERTY TAX TRUST FUND - 0.000% - - - - 6102- SA- ADMINISTRATION - 0.000% - - - - 6103- SA - CAPITAL PROJECT FUNDS - 0.000% - - - - 6208- SA-CIP 07B TARB BND PRCDS-HSG - 0.000% - - - - 6300- SA-DS HARBOR 98 TARB - 0.000% - - - - 6304- SA-DS 2003B TARB - 0.000% - - - - 6305- SA-DS 2004A TARB 2/3 - 0.000% - - - - 6306- SA-DS 2004A TARB -1/3 HSING - 0.000% - - - - 6307- SA-DS 2004B TARB - HOUSING - 0.000% - - - - 6308- SA-DS 2007/10A TARB - 0.000% - - - - 6309- SA-DS 2007/10B TARB - HOUSING - 0.000% - - - - 6401- SA-DS 2014A NON-TAXABLE BONDS - 0.000% - - - - 6402- SA-DS 2014B TAXABLE BONDS - 0.000% - - - - 6403- SA-DS LOANS PAYABLE - 0.000% - - - - 6404- SA-DS 2021A NON-TAXABLE BONDS is new - 0.000% - - - - 6405- SA-DS 2021B TAXABLE BONDS is new - 0.000% - - - - 6996- SUCCESSOR AGENCY - GLTDAG - 0.000% - - - - 9102- CITY OF RICHMOND - GFAAG - 0.000% - - - - AO- ALL OTHER - 0.000% - - - - Total 896 100.000% $ 1,103,116 $ - $ 1,103,116 $ 157,451 $ 1,260,567 Allocation Basis: FY 20-21 Total FTEs per Fund/Department Source of Allocation: City Staff Roster 20-21 Pay-benefitsA.xlsx Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
14 - Allocations

Page 183 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total 0001-181- Human Resources
System-wide Support B 14.2

ALLOCABLE BUDGET UNITS
BLDG- Building Use - 0.000% $ - $ - $ - EQUIP- Equipment Use - 0.000% - - - 0001-131- City Manager's Office 529,750 0.371% 4,088 4,088 4,088 0001-141- City Clerk 692,194 0.484% 5,341 5,341 5,341 0001-151- City Attorney 1,518,683 1.062% 11,719 11,719 11,719 0001-171- Finance Administration 486,613 0.340% 3,755 3,755 3,755 0001-172- Accounting 956,087 0.669% 7,378 7,378 7,378 0001-173- Budget/Operating 425,042 0.297% 3,280 3,280 3,280 0001-174- Payroll 345,969 0.242% 2,670 2,670 2,670 0001-175- Treasury/Cash Management 507,848 0.355% 3,919 3,919 3,919 0001-176- Accounts Payable 247,478 0.173% 1,910 1,910 1,910 0001-177- Rev Collection 559,637 0.391% 4,318 4,318 4,318 0001-178- Purchasing 354,337 0.248% 2,734 2,734 2,734 0001-181- Human Resources 1,467,427 1.026% 11,323 11,323 11,323 0001-232- Facility Maintenance and Administration 4,284,339 2.997% 33,060 33,060 5,002 38,062 0001-235- Equipment Services/Fleet Services 1,864,527 1.304% 14,388 14,388 2,177 16,564 0001-261- Information Technology Administration 719,413 0.503% 5,551 5,551 840 6,391 0001-262- Telecommunications 729,627 0.510% 5,630 5,630 852 6,482 0001-263- IT/Mailroom and Duplication, GIS, ERP and Desktop 92,387 0.065% 713 713 108 821 0001-907, 908- Non-Departmental 6,901,504 4.828% 53,256 53,256 8,057 61,313 - - 0.000% - - - - - - 0.000% - - - - - - 0.000% - - - - - - 0.000% - - - - - - 0.000% - - - -

RECEIVING BUDGET UNITS
0001-101- OFFICE OF THE MAYOR 522,136 0.365% 4,029 4,029 610 4,639 0001-105- COUNCIL/CITY COUNCIL DIV 417,302 0.292% 3,220 3,220 487 3,707 0001-121- POLICE COMMISSION DIV 61,769 0.043% 477 477 72 549 0001-132- CM-SPCIAL PROJS/ENVIRONMENTAL 3,586 0.003% 28 28 4 32 0001-163- GF-PLN/CODE ENFORCEMENT (DIV) 1,123,111 0.786% 8,667 8,667 1,311 9,978 0001-191- GF-POLICE ADMIN DIV 40,412,448 28.269% 311,844 311,844 47,181 359,025 0001-192- GF-POLICE-PATROL/CIB - 0.000% - - - - 0001-193- GF-POLICE/CRIME PREVENTION 173,851 0.122% 1,342 1,342 203 1,544 0001-194- GF-POLICE-COPS GRANT 841,525 0.589% 6,494 6,494 982 7,476 0001-196- GF-POLICE/REGULATORY 500,230 0.350% 3,860 3,860 584 4,444 0001-197- CAD DISPATCH SYST/COMM POL DIV 3,640,954 2.547% 28,096 28,096 4,251 32,346 0001-199- GF-PARKING ENFORCEMENT DIV 331,443 0.232% 2,558 2,558 387 2,945 0001-201- GF-FIRE/ADMIN DIV 539,396 0.377% 4,162 4,162 630 4,792 0001-202- GF-FIRE/SUPRESSN DIV 22,897,610 16.017% 176,690 176,690 26,733 203,423 0001-203- GF-FIRE PREVENTION DIV 1,498,392 1.048% 11,562 11,562 1,749 13,312 0001-204- GF-FIRE/ SUPPORT DIV - 0.000% - - - - 0001-205- GF-FIRE/TRAINING DIV 307,742 0.215% 2,375 2,375 359 2,734 0001-206- GF-FIRE/OF. OF EMS DIV 185,584 0.130% 1,432 1,432 217 1,649 0001-211- OF. OF NB-HOOD SFTY ADMIN DIV 1,121,592 0.785% 8,655 8,655 1,309 9,964 0001-212- OFF OF N-HOOD SFTY/GRANT ADM - 0.000% - - - - 0001-231- GF-PW ADMIN-DIV 1,131,805 0.792% 8,734 8,734 1,321 10,055 0001-233- GF-PRKS&LNDSKP/PRKS (S-DIV) 2,997,274 2.097% 23,129 23,129 3,499 26,628 Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
14 - Allocations

Page 184 ends

City of Richmond
TITLE 2 CFR 200 Cost Allocation Plan
Source Cost Data from Fiscal Year 2020-2021 Actual Expenditures ALLOCATION DETAIL Allocation Allocated Gross Direct First Second Units Percent Allocation Billed Allocation Allocation Total 0001-181- Human Resources
0001-234- IT GIS 2,799,744 1.958% 21,604 21,604 3,269 24,873 0001-237- GF-I&M/ABATEMENT SVCS (DIV) 1,695,351 1.186% 13,082 13,082 1,979 15,062 0001-238- GF-I&M/CODE ENFORCEMENT (DIV) - 0.000% - - - - 0001-239- GF-I&M/PROP/ASSETS MNGT (DIV) - 0.000% - - - - 0001-241- GF-LIB&CL SVC/L-ADM DIV 3,154,575 2.207% 24,342 24,342 3,683 28,025 0001-242- GF-LS/REF SVCS(S-DIV) - 0.000% - - - - 0001-243- GF-LIB&CL SVCS/LEAP DIV 612,578 0.429% 4,727 4,727 715 5,442 0001-244- GF-LIB&CL SVC/P-ART DIV - 0.000% - - - - 0001-251- GF-RECREATION ADM DIV 1,659,548 1.161% 12,806 12,806 1,937 14,743 0001-253- CM&NB/BOOKER T CTR (S-DIV) 881,010 0.616% 6,798 6,798 1,029 7,827 0001-255- GF-CM TRANSPORTATN OPERATIONS 9,213 0.006% 71 71 11 82 0001-254- GF-REC/SPCL EVENTS (S-DIV) 592,051 0.414% 4,569 4,569 691 5,260 0001-256- RECREATION SVCS/AQUATICS 172,344 0.121% 1,330 1,330 201 1,531 0001-257- RECREATION SVCS/CONVENTION CTR 344,024 0.241% 2,655 2,655 402 3,056 0001-259- RECREATION SVCS/PLUNGE 164,457 0.115% 1,269 1,269 192 1,461 0001-260- RECREATION SVCS/CITIES OF SRVC 177,243 0.124% 1,368 1,368 207 1,575 0001-291- GF-ADMINISTRATIVE SERVICES - 0.000% - - - - 0001-292- GF-STREET SWEEPING - 0.000% - - - - 0001-361- GF ECON DEV/SP PRJ-ENVIRONMNTL 307,771 0.215% 2,375 2,375 359 2,734 0001-362- GF ECON DEV/SP PRJ-ENVIRONMNTL 352,107 0.246% 2,717 2,717 411 3,128 0001-364- GF-ECON DEV/PUBLIC ART DIV 152,769 0.107% 1,179 1,179 178 1,357 0001-369- GF-ECON DEV/REAL ESTATE (DIV) 406,554 0.284% 3,137 3,137 475 3,612 0001-371- INTERNAL SERVICES-ADMIN 219,305 0.153% 1,692 1,692 256 1,948 0001-910- GF-NON-DEPT/CITY FESTIVAL - 0.000% - - - - 1001- SECURED PENSION OVERRIDE - 0.000% - - - - 1002- STATE GAS TAX - 0.000% - - - - 1003- TRANSPORTATION OPERATIONS 431,789 0.302% 3,332 3,332 504 3,836 1004- ASSET SEIZURE FUND - 0.000% - - - - 1005- LIBRARY FUND - 0.000% - - - - 1006- OUTSIDE FUNDED SVCS - GRANTS - 0.000% - - - - 1007- EMERGENCY MED SERV - 0.000% - - - - 1010- N.RICHMOND WASTE - 0.000% - - - - 1012- HILLTOP LANDSCAPE MAINT DIST 963,351 0.674% 7,434 7,434 1,125 8,558 1013- FIRE DEPT HAZMAT GRANT - 0.000% - - - - 1014- EDA GRANT FUND - 0.000% - - - - 1015- MARINA BAY LNDSCP&LIGHTDIST FD 728,277 0.509% 5,620 5,620 850 6,470 1017- CHEVRON MODERNIZATN PROJ & CIA - 0.000% - - - - 1018- RENT CONTROL 1,776,538 1.243% 13,709 13,709 2,074 15,783 1019- SBI RMRA CAP IMPROVEMENT - 0.000% - - - - 1050- CR-PLANNING & BUILDING 3,533,155 2.472% 27,264 27,264 4,125 31,389 1051- CR-ENGINEERING - 0.000% - - - - 1053- CODE ENFORCEMENT-CR - 0.000% - - - - 1054- ENGINEERING GRANTS - 0.000% - - - - 1055- ENCROACHMENTS SVCS 492,976 0.345% 3,804 3,804 576 4,380 1200- COR HOUSING ADMINISTRATION 200,045 0.140% 1,544 1,544 234 1,777 1201- CDBG 5,717 0.004% 44 44 7 51 1203- NEIGHBORHOOD STABILIZATION 35,576 0.025% 275 275 42 316 1205- EMPLOYMENT & TRAINING 2,299,306 1.608% 17,743 17,743 2,684 20,427 1207- NEIGHBORHOOD STAB(CITY) - 0.000% - - - - 1208- SUCCESSOR HOUSING AGNCY 212,991 0.149% 1,644 1,644 249 1,892 1209- CAL-HOME 24,821 0.017% 192 192 29 221 Prepared by NBS for the City of Richmond
Fiscal Year 2022-23
14 - Allocations

Page 185 ends
← All documents from this meeting