Cities Index.
A - Cost Allocation Plan

Cupertino City Council
February 6, 2024

Document
A - Cost Allocation Plan
Meeting
February 6, 2024
Body
Cupertino City Council
Original file
4.4 MB
Text extracted from the city's file for reading and search. Open the original on legistar.granicus.com. That file is the official record.

EXPENSE
DETAIL
City Hall
MaintenanceExpen se Type Expen ses ($)
Sp
rea
d
FY24 FULL COST ALLOCATION PLAN
_____________________________________________
_________________________________________________________________________________________________________________

CITY OF CUPERTINO, CA
____________________________________________
____________________________________________

Matrix Consulting Group
_________________________________________________________________________________________________________________

____________________________________________

227
100-87-827 Bldg Maint City Hall
.

Allocation Allocated Gross Direct First Second
Units Percent Allocation Billed Allocation Allocation Total City Hall Maintenance .
.
100-10-100 City Council 4.70 5.054% 30,260$ 30,260$ 30,260$ 100-12-120 City Manager 4.90 5.269% 31,548$ 31,548$ 31,548$ 100-12-126 Office of Communications 0.90 0.968% 5,794$ 5,794$ 5,794$ 100-12-633 Disaster Preparedness 1.95 2.097% 12,555$ 12,555$ 12,555$ 100-13-130 City Clerk 2.50 2.688% 16,096$ 16,096$ 16,096$ 100-15-141 City Attorney 2.00 2.151% 12,877$ 12,877$ 12,877$ 100-31-305 Video 3.00 3.226% 19,315$ 19,315$ 19,315$ 100-32-308 Applications 2.50 2.688% 16,096$ 16,096$ 16,096$ 100-40-400 Admin Services Administration 1.40 1.505% 9,014$ 9,014$ 9,014$ 100-41-405 Accounting 7.05 7.581% 45,390$ 45,390$ 45,390$ 100-41-425 Purchasing 1.20 1.290% 7,726$ 7,726$ 7,726$ 100-41-426 Budgeting 1.95 2.097% 12,555$ 12,555$ 12,555$ 100-44-412 Human Resources 3.85 4.140% 24,788$ 24,788$ 24,788$ 100-44-417 Insurance Administration 0.15 0.161% 966$ 966$ 966$ 100-80-800 Public Works Admin 2.95 3.172% 18,993$ 18,993$ 18,993$ 100-82-806 CIP Administration 4.75 5.108% 30,582$ 30,582$ 30,582$ 100-11-131 Telecommunication Commission 0.07 0.075% 451$ 451$ 17$ 467$ 100-11-142 Fine Arts Commission 0.10 0.108% 644$ 644$ 24$ 668$ 100-11-150 Public Safety Commission 0.05 0.054% 322$ 322$ 12$ 334$ 100-11-155 Bike/Ped Safety Commission 0.15 0.161% 966$ 966$ 36$ 1,002$ 100-11-170 Planning Commission 0.06 0.065% 386$ 386$ 14$ 401$ 100-11-190 Audit Committee 0.10 0.108% 644$ 644$ 24$ 668$ 100-12-122 Sustainability Division 0.35 0.376% 2,253$ 2,253$ 84$ 2,337$ 100-12-632 Comm Outreach & Neigh Watch 1.00 1.075% 6,438$ 6,438$ 239$ 6,677$ 100-12-705 Economic Development 1.00 1.075% 6,438$ 6,438$ 239$ 6,677$ 100-41-406 Business Licenses 1.10 1.183% 7,082$ 7,082$ 263$ 7,345$ 100-70-700 Community Development Admin 0.50 0.538% 3,219$ 3,219$ 120$ 3,339$ 100-71-701 Current Planning 4.18 4.495% 26,912$ 26,912$ 999$ 27,912$ 100-71-702 Mid Long Term Planning 1.94 2.086% 12,490$ 12,490$ 464$ 12,954$ 100-73-713 General Building 2.92 3.140% 18,800$ 18,800$ 698$ 19,498$ 100-73-714 Construction Plan Check 5.90 6.344% 37,986$ 37,986$ 1,411$ 39,397$ 100-73-715 Building Inspection 5.15 5.538% 33,157$ 33,157$ 1,231$ 34,389$

ALLOCATION DETAIL
FY24 FULL COST ALLOCATION PLAN
_____________________________________________
_________________________________________________________________________________________________________________

CITY OF CUPERTINO, CA
____________________________________________
____________________________________________

Matrix Consulting Group
_________________________________________________________________________________________________________________

____________________________________________

228
100-87-827 Bldg Maint City Hall
.

Allocation Allocated Gross Direct First Second
Units Percent Allocation Billed Allocation Allocation Total

ALLOCATION DETAIL
100-73-718 Muni - Bldg Code Enforcement 0.25 0.269% 1,610$ 1,610$ 60$ 1,669$ 100-74-202 Code Enforcement 2.00 2.151% 12,877$ 12,877$ 478$ 13,355$ 100-82-804 Plan Review 2.90 3.118% 18,671$ 18,671$ 693$ 19,364$ 100-88-844 Traffic Engineering 2.40 2.581% 15,452$ 15,452$ 574$ 16,026$ 100-88-846 Safe Routes 2 School 1.00 1.075% 6,438$ 6,438$ 239$ 6,677$ 230-81-802 Non Point Source 2.60 2.796% 16,740$ 16,740$ 622$ 17,361$ 260-72-707 CDBG General Admin 0.10 0.108% 644$ 644$ 24$ 668$ 265-72-711 BMR Affordable Housing Fund 0.80 0.860% 5,151$ 5,151$ 191$ 5,342$ 270-85-821 Street Pavement Maintenance 0.75 0.806% 4,829$ 4,829$ 179$ 5,008$ 520-81-801 Resources Recovery 2.25 2.419% 14,486$ 14,486$ 538$ 15,024$ 610-30-300 Administration 0.53 0.570% 3,412$ 3,412$ 127$ 3,539$ 610-34-310 Infrastructure 3.50 3.763% 22,534$ 22,534$ 837$ 23,371$ 610-35-986 GIS 3.40 3.656% 21,890$ 21,890$ 813$ 22,703$ 620-44-418 Workers Compensation Insurance 0.20 0.215% 1,288$ 1,288$ 48$ 1,335$ Total 93.00 100.000% 598,764$ -$ 598,764$ 11,296$ 610,060$ .

Allocation Basis: FTE per City Hall Division / Program
.

Source of Allocation: City Hall Staffing
FY24 FULL COST ALLOCATION PLAN
_____________________________________________
_________________________________________________________________________________________________________________

CITY OF CUPERTINO, CA
____________________________________________
____________________________________________

Matrix Consulting Group
_________________________________________________________________________________________________________________

____________________________________________

229

ALLOCATION SUMMARY
100-10-100 City Council 30,260$ 30,260$
100-12-120 City Manager 31,548$ 31,548$
100-12-126 Office of Communications 5,794$ 5,794$ 100-12-633 Disaster Preparedness 12,555$ 12,555$ 100-13-130 City Clerk 16,096$ 16,096$
100-15-141 City Attorney 12,877$ 12,877$
100-31-305 Video 19,315$ 19,315$
100-32-308 Applications 16,096$ 16,096$
100-40-400 Admin Services Administration 9,014$ 9,014$ 100-41-405 Accounting 45,390$ 45,390$
100-41-425 Purchasing 7,726$ 7,726$
100-41-426 Budgeting 12,555$ 12,555$
100-44-412 Human Resources 24,788$ 24,788$
100-44-417 Insurance Administration 966$ 966$ 100-80-800 Public Works Admin 18,993$ 18,993$
100-82-806 CIP Administration 30,582$ 30,582$
100-11-131 Telecommunication Commission 467$ 467$ 100-11-142 Fine Arts Commission 668$ 668$ 100-11-150 Public Safety Commission 334$ 334$ 100-11-155 Bike/Ped Safety Commission 1,002$ 1,002$ 100-11-170 Planning Commission 401$ 401$ 100-11-190 Audit Committee 668$ 668$
100-12-122 Sustainability Division 2,337$ 2,337$ 100-12-632 Comm Outreach & Neigh Watch 6,677$ 6,677$ 100-12-705 Economic Development 6,677$ 6,677$ 100-41-406 Business Licenses 7,345$ 7,345$
100-70-700 Community Development Admin 3,339$ 3,339$ 100-71-701 Current Planning 27,912$ 27,912$
100-71-702 Mid Long Term Planning 12,954$ 12,954$ 100-87-827 Bldg Maint City Hall Total
City Hall
Maintenance
FY24 FULL COST ALLOCATION PLAN
_____________________________________________
_________________________________________________________________________________________________________________

CITY OF CUPERTINO, CA
____________________________________________
____________________________________________

Matrix Consulting Group
_________________________________________________________________________________________________________________

____________________________________________

230

ALLOCATION SUMMARY
100-87-827 Bldg Maint City Hall Total
City Hall
Maintenance
100-73-713 General Building 19,498$ 19,498$
100-73-714 Construction Plan Check 39,397$ 39,397$
100-73-715 Building Inspection 34,389$ 34,389$
100-73-718 Muni - Bldg Code Enforcement 1,669$ 1,669$ 100-74-202 Code Enforcement 13,355$ 13,355$
100-82-804 Plan Review 19,364$ 19,364$
100-88-844 Traffic Engineering 16,026$ 16,026$
100-88-846 Safe Routes 2 School 6,677$ 6,677$
230-81-802 Non Point Source 17,361$ 17,361$
260-72-707 CDBG General Admin 668$ 668$
265-72-711 BMR Affordable Housing Fund 5,342$ 5,342$
270-85-821 Street Pavement Maintenance 5,008$ 5,008$
520-81-801 Resources Recovery 15,024$ 15,024$
610-30-300 Administration 3,539$ 3,539$
610-34-310 Infrastructure 23,371$ 23,371$
610-35-986 GIS 22,703$ 22,703$
620-44-418 Workers Compensation Insurance 1,335$ 1,335$ Total 610,060$ 610,060$
FY24 FULL COST ALLOCATION PLAN
_____________________________________________
_________________________________________________________________________________________________________________

CITY OF CUPERTINO, CA
____________________________________________
____________________________________________

Matrix Consulting Group
_________________________________________________________________________________________________________________

____________________________________________

231

← All documents from this meeting