Budget to Actuals_6.22.26.xlsx

	A	B	C	D	E	F	G	H	I	J	K
1	Account Id	Account Description	Prior Rev/Expd	Anticipated/Budgeted	Current Rev/Expd	YTD Rev/Expd	Cancel	Balance/Excess/Deficit	%Expd/%Real

2	6-01-20-100-000	ADMINISTRATOR'S OFFICE	0	0	0	0	0	0	0	TRUE	TRUE
3	6-01-20-100-100	SALARIES & WAGES	0	0	0	0	0	0	0	TRUE	TRUE
4	6-01-20-100-101	FULL-TIME	1,982,139.17	828,016.00	145,424.16	832,686.87	0	-4,670.87	100.5600	TRUE	TRUE
5	6-01-20-100-102	PART-TIME	42,024.00	0.00	0	0	0	0.00	0	TRUE	TRUE
6	6-01-20-100-103	OVERTIME	481.31	16,000.00	25.76	1,293.77	0	14,706.23	8.0900	TRUE	TRUE
7	6-01-20-100-104	UNION ALLOWANCES	450.00	450.00	0	450.00	0	0.00	100.0000	TRUE	TRUE
8	6-01-20-100-105	OUT-OF-TITLE	19,123.60	40,696.00	0	40,696.00	0	0.00	100.0000	TRUE	TRUE
9	6-01-20-100-107	SEASONAL	15,215.00	0.00	0	0	0	0.00	0	TRUE	TRUE
10	6-01-20-100-108	RETIREMENT & LUMP SUM PAY	12,117.99	5,838.00	0	0.00	0	5,838.00	0.0000	TRUE	TRUE
11	6-01-20-100-199	TEMPORARY BUDGET	0	100,000.00	0	0.00	0	100,000.00	0.0000	TRUE	TRUE
12	6-01-20-100-200	OTHER EXPENSES	0	0	0	0	0	0	0	TRUE	TRUE
13	6-01-20-100-201	OFFICE SUPPLIES	4,801.53	1,272.00	29.79	668.50	0	603.50	52.5600	TRUE	TRUE
14	6-01-20-100-204	PRINTING SUPPLIES	3,122.75	510.00	329.00	329.00	0	181.00	64.5100	TRUE	TRUE
15	6-01-20-100-205	FOOD	0	10,640.87	-8,140.87	0.00	0	10,640.87	0.0000	TRUE	TRUE
16	6-01-20-100-212	REC & EDUCATION MATERIALS	3,422.80	0.00	0	0	0	0.00	0	TRUE	TRUE
17	6-01-20-100-217	AC-DATA PROCESSING SUPPL	0	395.00	0	0	0	395.00	0.0000	TRUE	TRUE
18	6-01-20-100-305	PRINTING & ADVERTISING	1,086.76	0.00	0	0	0	0.00	0	TRUE	TRUE
19	6-01-20-100-306	DUES & SUBSCRIPTIONS	5,096.87	144.00	0	0	0	144.00	0.0000	TRUE	TRUE
20	6-01-20-100-309	CATERING & FOOD	2,790.21	3,859.13	0	0	0	3,859.13	0.0000	TRUE	TRUE
21	6-01-20-100-312	PROFESSIONAL SERVICES	20,800.00	0.00	0	0	0	0.00	0	TRUE	TRUE
22	6-01-20-100-316	DI - DUES & SUBSCRIPTIONS	50.07	0.00	0	0	0	0.00	0	TRUE	TRUE
23	6-01-20-100-328	AC- MILEAGE ALLOWANCE	67.05	0.00	0	0	0	0.00	0	TRUE	TRUE
24	6-01-20-100-399	PETTY CASH	192.96	0.00	0	0	0	0.00	0	TRUE	TRUE
25	6-01-20-100-401	FURNITURE & FURNISHINGS	0.40	0.00	0	0	0	0.00	0	TRUE	TRUE
26	6-01-20-100-449	DI- FOOD & MEAL EXPENSES	0.10	0.00	0	0	0	0.00	0	TRUE	TRUE
27	6-01-20-100-999	TEMPORARY BUDGET	0	6,179.00	0	0	0	6,179.00	0.0000	TRUE	TRUE
28		100 ADMINISTRATOR'S OFFICE	2,112,982.57	1,014,000.00	137,667.84	876,124.14	0.00	137,875.86		FALSE	FALSE
29	6-01-20-101-000	MANAGEMENT & BUDGET	0	0	0	0	0	0	0	TRUE	TRUE
30	6-01-20-101-100	SALARIES & WAGES	0	0	0	0	0	0	0	TRUE	TRUE
31	6-01-20-101-101	FULL-TIME	890,047.63	436,506.00	74,296.31	473,653.22	0	-37,147.22	108.5100	TRUE	TRUE
32	6-01-20-101-103	OVERTIME	63.22	6,000.00	0	0.00	0	6,000.00	0.0000	TRUE	TRUE
33	6-01-20-101-199	TEMPORARY BUDGET	0	69,494.00	0	0	0	69,494.00	0.0000	TRUE	TRUE
34	6-01-20-101-200	OTHER EXPENSES	0	0	0	0	0	0	0	TRUE	TRUE
35	6-01-20-101-201	OFFICE SUPPLIES	585.12	176.00	0	175.58	0	0.42	99.7600	TRUE	TRUE
36	6-01-20-101-999	MISCELLANEOUS CREDITS	0	224.00	0	0	0	224.00	0.0000	TRUE	TRUE
37		101 MANAGEMENT & BUDGET	890,695.97	512,400.00	74,296.31	473,828.80	0.00	38,571.20		FALSE	FALSE
38	6-01-20-102-000	PURCHASING & CENTRAL SVCS	0	0	0	0	0	0	0	TRUE	TRUE
39	6-01-20-102-100	SALARIES & WAGES	0	0	0	0	0	0	0	TRUE	TRUE
40	6-01-20-102-101	FULL-TIME	846,593.16	379,350.00	60,274.78	408,432.30	0	-29,082.30	107.6700	TRUE	TRUE
41	6-01-20-102-103	OVERTIME	25.11	12,285.00	0	1,100.53	0	11,184.47	8.9600	TRUE	TRUE
42	6-01-20-102-108	RETIREMENT & LUMP SUM PAY	0.00	179.00	0	0.00	0	179.00	0.0000	TRUE	TRUE
43	6-01-20-102-199	TEMPORARY BUDGET	0	85,186.00	0	0.00	0	85,186.00	0.0000	TRUE	TRUE
44	6-01-20-102-200	OTHER EXPENSES	0	0	0	0	0	0	0	TRUE	TRUE
45	6-01-20-102-201	OFFICE SUPPLIES	10,651.69	9,000.00	0	965.00	0	8,035.00	10.7200	TRUE	TRUE
46	6-01-20-102-305	PRINTING & ADVERTISING	36,336.84	15,000.00	262.32	9,684.90	0	5,315.10	64.5700	TRUE	TRUE
47	6-01-20-102-306	DUES & SUBSCRIPTIONS	5,444.05	3,000.00	0	2,325.38	0	674.62	77.5100	TRUE	TRUE
48	6-01-20-102-308	MILEAGE REIMBURSEMENT	357.87	0.00	0	0	0	0.00	0	TRUE	TRUE
49	6-01-20-102-312	PROFESSIONAL SERVICES	14,836.35	0.00	0	0	0	0.00	0	TRUE	TRUE
50	6-01-20-102-314	CONTRACTUAL SERVICES	27,552.50	30,000.00	0	0	0	30,000.00	0.0000	TRUE	TRUE
51	6-01-20-102-399	PETTY CASH	23.40	0.00	0	0	0	0.00	0	TRUE	TRUE
52	6-01-20-102-402	OFFICE EQUIPMENT	1,169.60	0.00	0	0	0	0.00	0	TRUE	TRUE
53	6-01-20-102-999	TEMPORARY BUDGET-OTHER EX	0	13,000.00	0	0	0	13,000.00	0.0000	TRUE	TRUE
54		102 PURCHASING & CENTRAL SVCS	942,990.57	547,000.00	60,537.10	422,508.11	0.00	124,491.89		FALSE	FALSE
55	6-01-20-104-000	ARCHITECTURE	0	0	0	0	0	0	0	TRUE	TRUE
56	6-01-20-104-100	SALARIES & WAGES	0	0	0	0	0	0	0	TRUE	TRUE
57	6-01-20-104-101	FULL-TIME	657,801.28	286,427.00	43,335.09	301,423.16	0	-14,996.16	105.2400	TRUE	TRUE
58	6-01-20-104-103	OVERTIME	973.69	6,038.00	21.48	293.69	0	5,744.31	4.8600	TRUE	TRUE
59	6-01-20-104-108	RETIREMENT & LUMP SUM PAY	0	1,941.00	0	0.00	0	1,941.00	0.0000	TRUE	TRUE
60	6-01-20-104-199	TEMPORARY BUDGET-SAL.& WA	0	60,594.00	0	0.00	0	60,594.00	0.0000	TRUE	TRUE
61	6-01-20-104-200	OTHER EXPENSES	0	0	0	0	0	0	0	TRUE	TRUE
62	6-01-20-104-201	OFFICE SUPPLIES	1,861.41	0.00	0	0	0	0.00	0	TRUE	TRUE
63	6-01-20-104-204	DRAFTING & PRINTING	977.50	2,000.00	0	1,573.26	0	426.74	78.6600	TRUE	TRUE
64	6-01-20-104-215	WEARING APPAREL	3,113.39	0.00	0	0	0	0.00	0	TRUE	TRUE
65	6-01-20-104-305	PRINTING & ADVERTISING	73.00	720.00	0	720.00	0	0.00	100.0000	TRUE	TRUE
66	6-01-20-104-306	DUES & SUBSCRIPTIONS	160.00	568.00	0	568.00	0	0.00	100.0000	TRUE	TRUE
67	6-01-20-104-308	MILEAGE REIMBURSEMENT	1,655.94	1,000.00	0	686.40	0	313.60	68.6400	TRUE	TRUE
68	6-01-20-104-314	CONTRACTUAL SERVICES	0	4,993.00	0	2,068.10	0	2,924.90	41.4200	TRUE	TRUE
69	6-01-20-104-401	FURNITURE & FURNISHINGS	63,023.10	10,934.00	0	3,597.80	0	7,336.20	32.9000	TRUE	TRUE
70	6-01-20-104-402	OFFICE EQUIPMENT	479.95	0.00	0	0	0	0.00	0	TRUE	TRUE
71	6-01-20-104-999	TEMPORARY BUDGET-OTHER EX	0	19,785.00	0	0	0	19,785.00	0.0000	TRUE	TRUE
72		104 ARCHITECTURE	730,119.26	395,000.00	43,356.57	310,930.41	0.00	84,069.59		FALSE	FALSE
73	6-01-20-106-000	COMMUNICATIONS	0	0	0	0	0	0	0	TRUE	TRUE
74	6-01-20-106-100	SALARIES & WAGES	0	0	0	0	0	0	0	TRUE	TRUE
75	6-01-20-106-101	FULL-TIME	607,334.47	289,425.71	56,229.45	290,917.71	0	-1,492.00	100.5200	TRUE	TRUE
76	6-01-20-106-102	PART-TIME	42,785.00	28,440.29	3,268.24	28,440.29	0	0.00	100.0000	TRUE	TRUE
77	6-01-20-106-103	OVERTIME	12,262.97	6,568.00	339.56	5,420.78	0	1,147.22	82.5300	TRUE	TRUE
78	6-01-20-106-105	OUT-OF-TITLE	1,100.00	625.00	0	625.00	0	0.00	100.0000	TRUE	TRUE
79	6-01-20-106-108	RETIREMENT & LUMP SUM PAY	0.00	433.00	432.41	432.41	0	0.59	99.8600	TRUE	TRUE
80	6-01-20-106-199	TEMPORARY BUDGET-SAL.& WA	0	17,508.00	0	0	0	17,508.00	0.0000	TRUE	TRUE
81	6-01-20-106-200	OTHER EXPENSES	0	0	0	0	0	0	0	TRUE	TRUE
82	6-01-20-106-201	OFFICE SUPPLIES	899.77	0.00	0	0	0	0.00	0	TRUE	TRUE
83	6-01-20-106-203	PHOTOGRAPHIC SUPPLIES	5,231.29	155.00	0	155.00	0	0.00	100.0000	TRUE	TRUE
84	6-01-20-106-215	WEARING APPAREL	355.00	0.00	0	0	0	0.00	0	TRUE	TRUE
85	6-01-20-106-217	DATA PROCESSING SUPPLIES	0	2,280.00	0	0	0	2,280.00	0.0000	TRUE	TRUE
86	6-01-20-106-305	PRINTING & ADVERTISING	0	2,605.00	0	0	0	2,605.00	0.0000	TRUE	TRUE
87	6-01-20-106-306	DUES & SUBSCRIPTIONS	72,004.29	27,380.00	0	14,947.76	0	12,432.24	54.5900	TRUE	TRUE
88	6-01-20-106-308	MILEAGE REIMBURSEMENT	1,199.10	629.00	430.65	627.86	0	1.14	99.8200	TRUE	TRUE
89	6-01-20-106-310	MAINTENANCE & REPAIR-EQUI	0	8,332.00	0	8,332.00	0	0.00	100.0000	TRUE	TRUE
90	6-01-20-106-401	FURNITURE & FURNISHINGS	0	1,784.00	0	790.28	0	993.72	44.3000	TRUE	TRUE
91	6-01-20-106-407	PHOTOGRAPHIC EQUIPMENT	4,585.22	5,685.00	0	1,564.00	0	4,121.00	27.5100	TRUE	TRUE
92	6-01-20-106-999	TEMPORARY BUDGET-OTHER EX	0	1,150.00	0	0	0	1,150.00	0.0000	TRUE	TRUE
93		106 COMMUNICATIONS	747,757.11	393,000.00	60,700.31	352,253.09	0.00	40,746.91		FALSE	FALSE
94	6-01-20-107-000	UTILITY MANAGEMENT	0	0	0	0	0	0	0	TRUE	TRUE
95	6-01-20-107-100	SALARIES & WAGES	0	0	0	0	0	0	0	TRUE	TRUE
96	6-01-20-107-101	FULL-TIME	56,018.34	28,380.00	4,732.49	30,441.12	0	-2,061.12	107.2600	TRUE	TRUE
97	6-01-20-107-103	OVERTIME	7,647.26	3,067.00	236.62	2,032.52	0	1,034.48	66.2700	TRUE	TRUE
98	6-01-20-107-199	TEMPORARY BUDGET-SAL.& WA	0	8,553.00	0	0	0	8,553.00	0.0000	TRUE	TRUE
99		107 UTILITY MANAGEMENT	63,665.60	40,000.00	4,969.11	32,473.64	0.00	7,526.36		FALSE	FALSE
100	6-01-20-108-000	HUMAN RESOURCES	0	0	0	0	0	0	0	TRUE	TRUE