CITY OF MESQUITE COMBINED CASH INVESTMENT AUGUST 31, 2015 COMBINED CASH ACCOUNTS 01-11120 CASH - WELLS FARGO CHECKING
1,792,223.56
01-11210 XPRESS DEPOSIT ACCOUNT
34,612.32
01-11310 CASH - PETTY CASH
1,710.00
01-11500 CASH - NEVADA STATE BANK MMF
4,422,681.27
01-11560 WELLS FARGO INVEST A/C
18,734,841.26
TOTAL COMBINED CASH
24,986,068.41
01-11900 TOTAL ALLOCATION TO OTHER FUND
( 24,986,068.41)
TOTAL UNALLOCATED CASH
.00
CASH ALLOCATION RECONCILIATION 10 ALLOCATION TO GENERAL FUND
5,729,498.90
11 ALLOCATION TO STREET MAINT. SPE
2,889,928.08
12 ALLOCATION TO AIRPORT SPECIAL R
304,419.23
13 ALLOCATION TO CAP. PROJ. MAINT/R
227,892.78
14 ALLOCATION TO POLICE FORFEITURE
178,551.76
15 ALLOCATION TO COURT ADMINISTRA
26,933.29
16 ALLOCATION TO SR. NUTRITION PRO
66,798.68
17 ALLOCATION TO RECREATION PROGR
316,886.45
19 ALLOCATION TO FORENSIC SERVICES
3,379.34
20 ALLOCATION TO RESID. CONSTR. TAX
1,002,114.78
21 ALLOCATION TO ENVIR. PLANNING SP
503,201.82
22 ALLOCATION TO TRANSPORTATION I 23 ALLOCATION TO MORE COPS SRF
2,119,840.59 (
25 ALLOCATION TO REDEVELOPMENT DI
169,381.75) 5,043,205.55
45 ALLOCATION TO CAPITAL PROJECT F
2,110,561.54
52 ALLOCATION TO SEWER FUND
1,790,892.18
81 ALLOCATION TO CANYON CREST SID 82 ALLOCATION TO ANTHEM AT MESQUI
97,091.25 (
517,956.65)
83 ALLOCATION TO SID ADMINISTRATIO
318,612.83
85 ALLOCATION TO G.O. BOND SERIES 20
1,422,752.14
87 ALLOCATION TO WASTE DISPOSAL D/
87,374.82
90 ALLOCATION TO TRUST & AGENCY F
616,496.19
98 ALLOCATION TO TECHNOLOGY RES/R
115,664.86
99 ALLOCATION TO VEHICLE/EQUIP REP
701,309.75
TOTAL ALLOCATIONS TO OTHER FUN
24,986,068.41
ALLOCATION FROM COMBINED CASH
( 24,986,068.41)
ZERO PROOF IF ALLOCATIONS BALAN
FOR ADMINISTRATION USE ONLY
.00
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:08PM PAGE:1
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 GENERAL FUND ASSETS 10-11900 CASH - COMBINED FUND
5,729,498.90
10-13100 DUE FROM STATE
590,000.00
10-13106 ROOM TAXES A/R
30,657.54
10-13107 OTHER RECEIVABLES
104,873.88
10-14000 PREPAID EXPENSE
398,604.09
TOTAL ASSETS
6,853,634.41
LIABILITIES AND EQUITY
LIABILITIES 10-21310 ACCOUNTS PAYABLE
923,059.64
10-21311 BANK SERVICE CHARGES PAYABLE
7,402.16
10-21500 WAGES PAYABLE
301,480.95
10-21700 UNION DUES W/H-REGULAR EE'S
2,975.00
10-21705 UNION DUES W/H POLICE
1,044.00
10-21710 UNION DUES W/H FIRE/RESCUE
220.00
10-22210 FICA PAYABLE
13,092.84
10-22220 WITHHELD INCOME TAXES
34,198.67
10-22250 WORKERS COMP PAYABLE
98,002.18
10-22300 ACCRUED STATE RETIREMENT
304,991.22
10-22400 VOLUNTARY LIFE INSURANCE W/H
926.21
10-22410 VOLUNTARY CANCER INSURANCE W/
220.58
10-22500 HEALTH INSURANCE PAYABLE
(
10-22505 ACCRUED HEALTH INS BONUS
78,065.05) 108,625.00
10-22520 FLEX SPEND INSURANCE W/H
4,472.78
10-22530 SUPPLMENTAL VOL INSURANCE W/H
1,490.61
10-22600 DEFERRED COMP - NATIONWIDE
6,577.50
10-22610 DEFERRED COMP - VOYA / ING
2,420.00
10-23100 GAMING TAX FOR CONV. AUTH.
150.00
10-23110 RM TXS COLL. FOR CONV AUTH 5/8
62,630.14
10-23120 RM TAXES COLL. FOR STATE 3/8
5,871.58
10-23130 TRANSIENT LODGING TRANSPORT.
15,657.54
10-23140 ROOM TAXES FOR SCHOOLS
25,443.48
10-23145 3% ROOM TAX (SCHOOLS 7/1/09)
46,972.61
10-23200 COURT FUNDS HELD
49,775.00
10-23240 COUNTY-TRANSPORT. DEVEL. FEES
19,262.50
10-24100 GARNISHMENTS W/H
979.01
TOTAL LIABILITIES
1,959,876.15
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 10-29800 BALANCE - BEGINNING OF YEAR
3,522,202.58
10-29810 RESERVE - RESOLUTION #777
1,908,280.00
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
536,724.32) 4,893,758.26
TOTAL FUND EQUITY
4,893,758.26
TOTAL LIABILITIES AND EQUITY
6,853,634.41
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:08PM PAGE:2
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
TAXES 10-31-100 PROPERTY TAXES
91,452.80
91,452.80
.00
91,452.80
3,140,000.00
3,048,547.20
2.9
10-31-110 ROAD RTC ROOM TAX
20,066.17
35,066.17
.00
35,066.17
200,000.00
164,933.83
17.5
10-31-200 ROOM TAXES
31,315.07
61,315.07
.00
61,315.07
400,000.00
338,684.93
15.3
TOTAL TAXES
142,834.04
187,834.04
.00
187,834.04
3,740,000.00
3,552,165.96
5.0
70,359.61
112,261.82
.00
112,261.82
540,000.00
427,738.18
20.8
500.00
500.00
.00
500.00
600.00
100.00
83.3
.00
55,000.00
.00
55,000.00
82,500.00
27,500.00
66.7
49,475.00
88,675.00
.00
88,675.00
130,000.00
41,325.00
68.2
50.00
161,430.00
.00
161,430.00
350,000.00
188,570.00
46.1
1,560.00
1,710.00
.00
1,710.00
5,000.00
3,290.00
34.2
52,449.11
106,289.99
.00
106,289.99
440,000.00
333,710.01
24.2
1,200.00
1,200.00
.00
1,200.00
.00
10-32-300 ANIMAL CONTROL FEES
875.00
2,176.00
.00
2,176.00
10,900.00
10-32-500 ZONE VARIANCE FEES
515.00
1,135.00
.00
1,135.00
.00
.00
.00
.00
305.77
305.77
.00
10-32-615 FRANCHISE FEES - CABLE SVCS
.00
.00
TOTAL LICENSES AND PERMITS
177,289.49
LICENSES AND PERMITS 10-32-100 BUSINESS LICENSES 10-32-102 MASSAGE PERMITS 10-32-105 MEDICAL MARIJUANA LICENSE FEES 10-32-110 LIQUOR LICENSES 10-32-120 GAMING LICENSES 10-32-160 VACATION RENTAL LICENSE 10-32-200 BUILDING PERMITS 10-32-250 STRUCTURE IMPACT FEES
10-32-505 PLAN REVIEW FEES 10-32-605 FRANCHISE FEES - TELEPHONE SVC
(
1,200.00)
.0
8,724.00
20.0
17,000.00
15,865.00
6.7
16,000.00
16,000.00
.0
305.77
85,000.00
84,694.23
.4
.00
.00
70,000.00
70,000.00
.0
530,683.58
.00
530,683.58
1,747,000.00
1,216,316.42
30.4
19.3
INTERGOVERNMENTAL REVENUE 10-33-140 LVCVA - ROOM & GAMING TAXES
173,513.30
173,513.30
.00
173,513.30
900,000.00
726,486.70
10-33-232 EMPG GRANT (FIRE)
.00
.00
.00
.00
30,000.00
30,000.00
.0
10-33-235 CCSD - SRO & ATHLETIC EVENTS
.00
.00
.00
.00
65,000.00
65,000.00
.0
10-33-240 TASK FORCE JAG GRANTS
25,849.50)
.00
25,849.50)
12,000.00
37,849.50
10-33-242 JOINING FORCES TRAFFIC GRANT
.00
.00
.00
.00
30,000.00
30,000.00
10-33-244 PD COMMUNITY EVENTS
.00
.00
.00
.00
2,000.00
2,000.00
.0
10-33-250 COUNTY GAMING LICENSES
.00
.00
.00
.00
365,000.00
365,000.00
.0
10-33-338 OTHER GRANTS (PD)
(
25,849.50) (
(
(215.4) .0
.00
.00
.00
.00
9,000.00
9,000.00
.0
633,257.28
1,223,257.28
.00
1,223,257.28
7,530,000.00
6,306,742.72
16.3
10-33-520 SILVER RIDER FUEL / R&M REIMB.
.00
1,500.00
.00
1,500.00
110,000.00
108,500.00
1.4
10-33-550 SPECIAL AD VALOREM TRANS. TAX
.00
.00
.00
.00
80,000.00
80,000.00
.0
700.00
700.00
.00
700.00
8,400.00
7,700.00
8.3
.00
.00
.00
.00
697,700.00
697,700.00
.0
781,621.08
1,373,121.08
.00
1,373,121.08
9,839,100.00
8,465,978.92
14.0
10-33-460 STATE CONSOLIDATED TAX
10-33-590 NDOT REIMB-WELCOME CENTER 10-33-600 REGIONAL FLOOD CONTROL, CL.CO. TOTAL INTERGOVERNMENTAL REVE
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:3
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
CHARGES FOR SERVICES 10-34-100 CEMETERY CHARGE AND SALES 10-34-205 BEAVER DAM DISPATCH SVC MOU
1,550.00
4,350.00
.00
4,350.00
11,250.00
6,900.00
38.7
.00
47,321.00
.00
47,321.00
47,800.00
479.00
99.0
10-34-300 PD - JAIL SERVICES
3,081.75
3,131.25
.00
3,131.25
.00
3,131.25)
.0
10-34-310 PD: INMATE HOUSING (NEW FY16)
4,165.00
5,735.00
.00
5,735.00
20,000.00
14,265.00
28.7
14,947.50
40,349.50
.00
40,349.50
172,000.00
131,650.50
23.5
5,948.00
5,948.00
.00
5,948.00
28,000.00
22,052.00
21.2
75,199.74
150,593.62
.00
150,593.62
750,000.00
599,406.38
20.1
225.00
540.00
.00
540.00
10,000.00
9,460.00
5.4
32.31
245,855.07
.00
245,855.07
957,000.00
711,144.93
25.7
10-34-400 RECREATION CHARGES 10-34-405 REC CENTER FEE INCREMENT " 10-34-500 AMBULANCE FEES 10-34-510 FIRE DEPT. FEES 10-34-610 RESID. GARBAGE SERVICE CHGS. 10-34-611 SANITATION SVC FUEL SURCHARGE 10-34-612 GARBAGE CAN RENTAL FEES 10-34-620 GARBAGE DUMP FEE 10-34-640 PW INSPECTIONS & FEES
(
1.17
5,487.95
.00
5,487.95
40,000.00
34,512.05
13.7
89.44
27,212.94
.00
27,212.94
108,000.00
80,787.06
25.2
29,990.13
29,990.13
.00
29,990.13
349,700.00
319,709.87
8.6
228.61
388.61
.00
388.61
3,000.00
2,611.39
13.0
10-34-660 SPECIAL EVENT FEES
.00
.00
.00
.00
200.00
200.00
.0
10-34-700 MUSEUM MISC. FEES
219.62
463.47
.00
463.47
3,000.00
2,536.53
15.5
135,678.27
567,366.54
.00
567,366.54
2,499,950.00
1,932,583.46
22.7
21,421.93
41,784.00
.00
41,784.00
310,000.00
268,216.00
13.5
175.00
525.00
.00
525.00
.00
525.00)
.0
21,596.93
42,309.00
.00
42,309.00
310,000.00
267,691.00
13.7
879.00
879.00
.00
879.00
3,500.00
2,621.00
25.1
879.00
879.00
.00
879.00
3,500.00
2,621.00
25.1
TOTAL CHARGES FOR SERVICES
FINES AND FORFEITURES 10-35-200 FINES AND FORFEITURES 10-35-300 MISC COURT FEES TOTAL FINES AND FORFEITURES
(
MISCELLANEOUS REVENUE 10-36-635 CC LIBRARY DISTRICT-WATER FEES TOTAL MISCELLANEOUS REVENUE
OTHER REVENUE 10-38-100 INTEREST EARNINGS
12,800.89)
.00
12,800.89)
67,500.00
80,300.89
( 19.0)
10-38-200 SIGN RENTAL
15,188.45 813.84
1,627.68
.00
1,627.68
9,600.00
7,972.32
17.0
10-38-230 FIRE / AMB COMMUNITY TRAINING
270.00
565.00
.00
565.00
2,000.00
1,435.00
28.3
.00
.00
.00
.00
15,000.00
15,000.00
.0
940.00
10,600.00
.00
10,600.00
.00
10,600.00)
.0
10-38-630 CITY SPECIAL EVENT FEES 10-38-700 CITY FACILITIES RENTAL FEES 10-38-701 CITY RENTAL EXPENSES
5,020.51)
.00
5,020.51)
.00
5,020.51
.0
8,640.14
.00
8,640.14
35,000.00
26,359.86
24.7
10-38-720 LEASEHOLD REVENUE
8,084.32
14,263.52
.00
14,263.52
164,000.00
149,736.48
8.7
220.00
276.50
.00
276.50
10,000.00
9,723.50
2.8
25,505.61
18,151.44
.00
18,151.44
303,100.00
284,948.56
6.0
FOR ADMINISTRATION USE ONLY
(
17 % OF THE FISCAL YEAR HAS ELAPSED
(
(
2,937.08
TOTAL OTHER REVENUE
2,948.08)
(
10-38-710 COURT FACILITY RENTAL 10-38-900 MISCELLANEOUS REVENUE
(
(
09/14/2015 06:09PM PAGE:4
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
CONTRIBUTIONS AND TRANSFERS 10-39-912 TRSFR FROM #12 AIRPORT FUND
33,333.33
66,666.66
.00
66,666.66
400,000.00
333,333.34
16.7
10-39-917 TRSFR FROM SRF#17 - REC PRGM
16,666.67
33,333.34
.00
33,333.34
200,000.00
166,666.66
16.7
10-39-919 TRSFR FROM #19 FORENSIC SVCS
208.33
416.66
.00
416.66
2,500.00
2,083.34
16.7
84,725.50
169,451.00
.00
169,451.00
1,016,706.00
847,255.00
16.7
134,933.83
269,867.66
.00
269,867.66
1,619,206.00
1,349,338.34
16.7
1,420,338.25
2,990,212.34
.00
2,990,212.34
20,061,856.00
17,071,643.66
14.9
10-39-925 TRSFR FROM #25 REDEVELOPMENT TOTAL CONTRIBUTIONS AND TRANSF
TOTAL FUND REVENUE
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:5
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
MAYOR & COUNCIL 10-41-110 SALARIES
9,288.51
13,499.30
.00
13,499.30
92,328.00
78,828.70
14.6
10-41-113 LONGEVITY PAY
.00
.00
.00
.00
210.00
210.00
.0
10-41-120 OVERTIME
.00
.00
.00
.00
125.00
125.00
.0
8,212.51
15,179.72
.00
15,179.72
95,819.00
80,639.28
15.8
10-41-130 EMPLOYEE BENEFITS 10-41-210 BOOKS, SUBSCRIPTIONS & MEMBERS 10-41-230 TRAVEL & TRAINING 10-41-240 OFFICE EXPENSE & SUPPLIES 10-41-290 TELEPHONE 10-41-310 PROFESSIONAL & TECHNICAL SVCS
.00
.00
.00
.00
9,301.00
9,301.00
.0
1,922.68
1,975.55
.00
1,975.55
7,200.00
5,224.45
27.4
42.05
42.05
.00
42.05
1,500.00
1,457.95
2.8
255.18
510.24
.00
510.24
3,050.00
2,539.76
16.7 24.3
20,416.66
46,583.32
3,000.00
49,583.32
204,500.00
154,916.68
10-41-610 MISCELLANEOUS SUPPLIES
114.85
150.85
.00
150.85
4,000.00
3,849.15
3.8
10-41-620 MISCELLANEOUS SERVICE
179.63
215.62
.00
215.62
1,000.00
784.38
21.6
TOTAL MAYOR & COUNCIL
40,432.07
78,156.65
3,000.00
81,156.65
419,033.00
337,876.35
19.4
CITY MANAGER 10-43-110 SALARIES
18,508.84
26,917.25
.00
26,917.25
159,641.00
132,723.75
16.9
10-43-112 VAC/SICK BUYOUT
.00
123.15
.00
123.15
8,745.00
8,621.85
1.4
10-43-113 LONGEVITY PAY
.00
.00
.00
.00
895.00
895.00
.0
10-43-120 OVERTIME
.00
.00
.00
.00
125.00
125.00
.0
7,343.97
11,440.84
.00
11,440.84
69,783.00
58,342.16
16.4
975.00
975.00
.00
975.00
1,600.00
625.00
60.9
.00
.00
.00
.00
5,200.00
5,200.00
.0
29.37
47.31
.00
47.31
500.00
452.69
9.5
10-43-290 TELEPHONE
100.97
201.91
.00
201.91
1,230.00
1,028.09
16.4
10-43-610 MISCELLANEOUS SUPPLIES
106.49
106.49
.00
106.49
1,500.00
1,393.51
7.1
27,064.64
39,811.95
.00
39,811.95
249,219.00
209,407.05
16.0
70,860.91
10.6
123.15)
.0
10-43-130 EMPLOYEE BENEFITS 10-43-210 BOOKS, SUBSCRIPTIONS & MEMBERS 10-43-230 TRAVEL & TRAINING 10-43-240 OFFICE EXPENSE & SUPPLIES
TOTAL CITY MANAGER
CITY CLERK 10-44-110 SALARIES
5,761.81
8,435.09
.00
8,435.09
79,296.00
10-44-112 VAC/SICK BUYOUT
.00
123.15
.00
123.15
.00
10-44-113 LONGEVITY PAY
.00
.00
.00
.00
700.00
700.00
.0
1,194.38
1,972.52
.00
1,972.52
34,150.00
32,177.48
5.8
.00
75.00
.00
75.00
1,178.00
1,103.00
6.4
357.24
843.88
.00
843.88
4,000.00
3,156.12
21.1
10-44-130 EMPLOYEE BENEFITS 10-44-210 BOOKS, SUBSCRIPTIONS & MEMBERS 10-44-220 PUBLIC NOTICES 10-44-230 TRAVEL AND TRAINING 10-44-240 OFFICE EXPENSE & SUPPLIES 10-44-290 TELEPHONE
(
.00
.00
.00
.00
1,850.00
1,850.00
.0
8.24
104.22
.00
104.22
900.00
795.78
11.6
54.68)
.00
54.68)
750.00
804.68
( 7.3)
769.34
769.34
.00
769.34
8,300.00
7,530.66
9.3
10-44-330 ELECTIONS
.00
.00
.00
.00
18,000.00
18,000.00
.0
10-44-610 OTHER SERVICES/SUPPLIES
.00
.00
.00
.00
300.00
300.00
.0
8,091.01
12,268.52
.00
12,268.52
149,424.00
137,155.48
8.2
10-44-310 PROFESSIONAL & TECHNICAL SVCS
TOTAL CITY CLERK
FOR ADMINISTRATION USE ONLY
.00
(
17 % OF THE FISCAL YEAR HAS ELAPSED
(
09/14/2015 06:09PM PAGE:6
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
FINANCE 10-46-110 SALARIES
15,367.11
22,333.53
.00
22,333.53
133,182.00
110,848.47
16.8
10-46-112 VAC/SICK BUYOUT
.00
.00
.00
.00
9,698.00
9,698.00
.0
10-46-113 LONGEVITY PAY
.00
.00
.00
.00
700.00
700.00
.0
6,466.88
10,274.48
.00
10,274.48
62,623.00
52,348.52
16.4
10-46-130 EMPLOYEE BENEFITS 10-46-210 BOOKS, SUBSCRIPTIONS & MEMBERS
.00
170.00
.00
170.00
200.00
30.00
85.0
10-46-230 TRAVEL & TRAINING
.00
850.00
.00
850.00
4,750.00
3,900.00
17.9
10-46-240 OFFICE EXPENSE & SUPPLIES
.00
.00
.00
.00
300.00
300.00
.0
5,395.32
6,112.71
.00
6,112.71
47,000.00
40,887.29
13.0
.00
.00
.00
.00
600.00
600.00
.0
27,229.31
39,740.72
.00
39,740.72
259,053.00
219,312.28
15.3
10-46-310 PROFFESSIONAL & TECHNICAL SVCS 10-46-610 MISCELLANEOUS SUPPLIES TOTAL FINANCE
INFORMATION TECHNOLOGY 10-47-110 SALARIES
28,503.04
41,424.41
.00
41,424.41
247,024.00
205,599.59
16.8
10-47-112 VAC/SICK BUYOUT
.00
.00
.00
.00
10,757.00
10,757.00
.0
10-47-113 LONGEVITY PAY
.00
.00
.00
.00
3,275.00
3,275.00
.0
12,938.39
20,976.02
.00
20,976.02
128,113.00
107,136.98
16.4
.00
.00
.00
.00
5,000.00
5,000.00
.0
655.69
1,033.75
.00
1,033.75
12,300.00
11,266.25
8.4
10-47-130 EMPLOYEE BENEFITS 10-47-230 TRAVEL & TRAINING 10-47-240 OFFICE EXPENSE & SUPPLIES 10-47-290 TELEPHONE 10-47-310 PROFFESSIONAL & TECHNICAL SVCS 10-47-740 CAPITAL OUTLAY TOTAL INFORMATION TECHNOLOGY
182.91
365.73
.00
365.73
2,500.00
2,134.27
14.6
11,173.29
175,639.37
27,636.00
203,275.37
334,600.00
131,324.63
60.8
.00
.00
.00
.00
14,000.00
14,000.00
.0
53,453.32
239,439.28
27,636.00
267,075.28
757,569.00
490,493.72
35.3
PERSONNEL 10-48-110 SALARIES
7,202.40
10,467.49
.00
10,467.49
62,421.00
51,953.51
16.8
10-48-112 VAC/SICK BUYOUT
.00
.00
.00
.00
5,883.00
5,883.00
.0
10-48-113 LONGEVITY PAY
.00
.00
.00
.00
1,625.00
1,625.00
.0
3,253.44
5,273.89
.00
5,273.89
32,508.00
27,234.11
16.2
10-48-130 EMPLOYEE BENEFITS 10-48-210 BOOKS, SUBSCRIPTIONS & MEMBERS
.00
1,039.50
.00
1,039.50
1,500.00
460.50
69.3
133.29
133.29
.00
133.29
1,000.00
866.71
13.3
.00
.00
.00
.00
2,400.00
2,400.00
.0
7.91
61.87
.00
61.87
1,100.00
1,038.13
5.6
121.91
121.91
.00
121.91
650.00
528.09
18.8
.00
.00
.00
.00
1,000.00
1,000.00
.0
10-48-620 PERSONNEL COSTS
253.65
253.65
.00
253.65
2,200.00
1,946.35
11.5
TOTAL PERSONNEL
10,972.60
17,351.60
.00
17,351.60
112,287.00
94,935.40
15.5
10-48-220 PUBLIC NOTICES 10-48-230 TRAVEL & TRAINING 10-48-240 OFFICE EXPENSE & SUPPLIES 10-48-290 TELEPHONE 10-48-310 PROFESSIONAL & TECHNICAL SVCS
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:7
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
NON-DEPARTMENTAL 10-49-130 BENEFITS ADJUSTMENT 10-49-240 OFFICE EXPENSE & SUPPLIES 10-49-250 EQUIPMENT SUPPLIES & MAINT NC
.00 (
265.20)
(
815.20
.00
776.08)
.00
(
815.20
15,000.00
14,184.80
5.4
776.08)
6,500.00
7,276.08
( 11.9)
2,771.00
8,592.40
.00
8,592.40
46,250.00
37,657.60
18.6
.00
1,227.41
.00
1,227.41
35,000.00
33,772.59
3.5
10-49-280 UTILITIES
5,818.44
7,504.44
.00
7,504.44
1,002,000.00
994,495.56
.8
10-49-290 TELEPHONE
3,795.77
7,195.93
.00
7,195.93
45,300.00
38,104.07
15.9
10-49-510 INSURANCE
23,776.90
48,423.80
.00
48,423.80
387,500.00
339,076.20
12.5
177.71
199.66
.00
199.66
1,500.00
1,300.34
13.3
.00
.00
.00
.00
3,525.00
7,050.00
.00
7,050.00
10-49-270 UTILITIES (CITY SANITATION)
10-49-610 SERVICE, SUPPLIES & OTHER 10-49-690 EXP DISTRIBUTION TO OTHER DEPT 10-49-691 DISTR EXP: FACILITIES MAINT 10-49-692 DIST EXP: SOLID WASTE
( 1,026,890.00) ( 1,026,890.00) 42,300.00
35,250.00
.0 16.7
91.67
183.34
.00
183.34
1,100.00
916.66
16.7
10-49-693 DIST EXP: VEHICLE MAINT
883.33
1,766.66
.00
1,766.66
10,600.00
8,833.34
16.7
10-49-695 BANK/ CREDIT CARD CHARGES
834.59
2,137.50
.00
2,137.50
13,500.00
11,362.50
15.8
41,409.21
84,320.26
.00
84,320.26
579,660.00
495,339.74
14.6
TOTAL NON-DEPARTMENTAL
CITY ATTORNEY 10-50-110 SALARIES
19,563.45
28,278.72
.00
28,278.72
165,160.00
136,881.28
17.1
10-50-112 VAC/SICK BUYOUT
.00
.00
.00
.00
4,644.00
4,644.00
.0
10-50-113 LONGEVITY PAY
.00
.00
.00
.00
2,000.00
2,000.00
.0
8,706.09
15,730.09
.00
15,730.09
93,705.00
77,974.91
16.8
536.64
546.64
.00
546.64
8,375.00
7,828.36
6.5
39.76
763.48
.00
763.48
4,000.00
3,236.52
19.1
10-50-130 EMPLOYEE BENEFITS 10-50-210 BOOKS, SUBSCRIPTIONS & MEMBERS 10-50-230 TRAVEL & TRAINING 10-50-240 OFFICE EXPENSE & SUPPLIES
42.30
102.65
.00
102.65
600.00
497.35
17.1
10-50-290 TELEPHONE
60.97
121.91
.00
121.91
1,800.00
1,678.09
6.8
741.00
741.00
.00
741.00
8,700.00
7,959.00
8.5
29,690.21
46,284.49
.00
46,284.49
288,984.00
242,699.51
16.0
10-50-310 PROFESSIONAL & TECHNICAL SVCS TOTAL CITY ATTORNEY
JUDICIAL / MUNICIPAL COURT 10-51-110 SALARIES
17,940.13
26,278.78
.00
26,278.78
163,138.00
136,859.22
16.1
10-51-112 VAC/SICK BUYOUT
.00
.00
.00
.00
9,827.00
9,827.00
.0
10-51-113 LONGEVITY PAY
.00
.00
.00
.00
5,700.00
5,700.00
.0
152.19
152.19
.00
152.19
1,200.00
1,047.81
12.7
10-51-130 EMPLOYEE BENEFITS
8,740.05
14,380.21
.00
14,380.21
91,200.00
76,819.79
15.8
10-51-210 BOOKS, SUBSCRIPTIONS & MEMBERS
6,000.00
6,000.00
.00
6,000.00
100.00
10-51-120 OVERTIME
10-51-240 OFFICE EXPENSE & SUPPLIES 10-51-310 PROFESSIONAL & TECHNICAL SVCS 10-51-610 MISCELLANEOUS SUPPLIES
(
5,900.00) 6000.0
83.74
465.19
.00
465.19
2,800.00
2,334.81
16.6
3,077.98
4,386.98
.00
4,386.98
38,580.00
34,193.02
11.4
73.18
73.18
.00
73.18
750.00
676.82
9.8
10-51-691 DISTR EXP: FACILITIES MAINT
495.83
991.66
.00
991.66
5,950.00
4,958.34
16.7
10-51-695 BANK / CREDIT CARD CHARGES
654.20
652.26
.00
652.26
5,000.00
4,347.74
13.1
37,217.30
53,380.45
.00
53,380.45
324,245.00
270,864.55
16.5
TOTAL JUDICIAL / MUNICIPAL COURT
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:8
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
POLICE 10-54-110 SALARIES
187,149.02
275,693.10
.00
275,693.10
1,744,195.00
1,468,501.90
10-54-112 VAC/SICK BUYOUT
3,051.20
3,051.20
.00
3,051.20
118,896.00
115,844.80
2.6
10-54-113 LONGEVITY PAY
2,150.00
5,275.00
.00
5,275.00
34,000.00
28,725.00
15.5
.00
2,000.00
.00
2,000.00
40,000.00
38,000.00
5.0
1,350.00
2,250.00
.00
2,250.00
11,050.00
8,800.00
20.4
10-54-115 UNIFORM ALLOWANCE 10-54-116 EDUCATION ASSISTANCE PAY 10-54-120 OVERTIME
15.8
17,347.01
21,334.48
.00
21,334.48
80,000.00
58,665.52
26.7
113,186.90
231,313.55
.00
231,313.55
1,156,032.00
924,718.45
20.0
.00
.00
.00
.00
1,500.00
1,500.00
.0
10-54-230 TRAVEL & TRAINING
2,943.07
5,310.25
.00
5,310.25
24,000.00
18,689.75
22.1
10-54-240 OFFICE EXPENSES & SUPPLIES
1,103.28
1,288.05
.00
1,288.05
8,700.00
7,411.95
14.8
755.35
1,158.35
.00
1,158.35
17,800.00
16,641.65
6.5
.00
.00
.00
.00
11,050.00
11,050.00
.0
75.12
126.31
.00
126.31
1,200.00
1,073.69
10.5
10-54-130 EMPLOYEE BENEFITS 10-54-210 BOOKS, SUBSCRIPTIONS & MEMBERS
10-54-250 EQUIPMENT SUPPLIES & MAIN NC 10-54-260 EQUIPMENT (NON-CAPITALIZED) 10-54-280 UTILITIES 10-54-290 TELEPHONE
1,159.78
2,319.02
.00
2,319.02
18,200.00
15,880.98
12.7
10-54-310 PROFESSIONAL & TECHNICAL SVCS
1,691.10
10,527.46
.00
10,527.46
38,900.00
28,372.54
27.1
10-54-320 GENERAL HEALTH SERVICES
1,617.68
2,067.68
.00
2,067.68
16,175.00
14,107.32
12.8
10-54-610 MISCELLANEOUS SUPPLIES
2,037.10
3,761.80
.00
3,761.80
35,650.00
31,888.20
10.6
1,050.00
12.5
10-54-620 MISC SERVICES 10-54-625 GRANT EXPENDITURES 10-54-691 DISTR EXP: FACILITIES MAINT 10-54-692 DIST EXP: SOLID WASTE
150.00
150.00
.00
150.00
1,200.00
19,254.32
21,893.99
.00
21,893.99
.00
1,966.67
3,933.34
.00
3,933.34
23,600.00
(
21,893.99)
.0
19,666.66
16.7
114.58
229.16
.00
229.16
1,375.00
1,145.84
16.7
11,625.00
23,250.00
.00
23,250.00
139,500.00
116,250.00
16.7
6,336.23
8,716.75
.00
8,716.75
82,530.00
73,813.25
10.6
950.00
950.00
.00
950.00
.00
4,622.95
4,622.95
.00
4,622.95
.00
.00
.00
.00
380,636.36
631,222.44
.00
631,222.44
42,182.14
61,500.04
.00
3,058.40
3,058.40
.00
10-55-113 LONGEVITY PAY
.00
.00
.00
.00
10-55-115 UNIFORM ALLOWANCE
.00
.00
.00
.00
375.00
625.00
.00
625.00
3,250.00
10-54-693 DIST EXP: VEHICLE MAINT 10-54-694 DIST EXP: WATER/POWER/SANI 10-54-700 ARRA / CLV JAG EXPENDITURES 10-54-740 CAPITAL OUTLAY 10-54-799 TRSFR TO VEH/EQUIP REPL FUND TOTAL POLICE
950.00)
.0
129,074.00
124,451.05
3.6
129,074.00) (
129,074.00)
.0
3,605,553.00
2,974,330.56
17.5
61,500.04
438,573.00
377,072.96
14.0
3,058.40
11,759.00
8,700.60
26.0
8,425.00
8,425.00
.0
14,000.00
14,000.00
.0
2,625.00
19.2
(
(
PD - CORRECTIONS DIVISION 10-55-110 SALARIES 10-55-112 VAC/SICK BUYOUT
10-55-116 EDUCATION ASSISTANCE PAY 10-55-120 OVERTIME
2,394.36
3,204.25
.00
3,204.25
15,000.00
11,795.75
21.4
10-55-130 EMPLOYEE BENEFITS
28,785.31
46,686.77
.00
46,686.77
314,892.00
268,205.23
14.8
10-55-230 TRAVEL & TRAINING
96.00
96.00
.00
96.00
1,500.00
1,404.00
6.4
10-55-240 OFFICE EXPENSE & SUPPLIES
42.47
42.47
.00
42.47
500.00
457.53
8.5
5,000.00
5,000.00
.00
5,000.00
8,150.00
3,150.00
61.4
.00
.00
.00
.00
4,075.00
4,075.00
.0
77.88
408.51
.00
408.51
16,100.00
15,691.49
2.5
4,290.05
9,264.47
.00
9,264.47
35,400.00
26,135.53
26.2
129.17
258.34
.00
258.34
1,550.00
1,291.66
16.7
62.50
125.00
.00
125.00
750.00
625.00
16.7
3,922.03
5,498.61
.00
5,498.61
40,900.00
35,401.39
13.4
90,415.31
135,767.86
.00
135,767.86
914,824.00
779,056.14
14.8
10-55-310 PROFESSIONAL & TECHINICAL SVCS 10-55-320 PROFESSIONAL & TECHNICAL SVCS 10-55-610 MISC SUPP - C & C PRISONERS 10-55-620 MISC SVCS - C & C OF PRISONERS 10-55-691 DISTR EXP: FACILITIES MAINT 10-55-692 DIST EXP: SOLID WASTE 10-55-694 DIST EXP: WATER/POWER/SANI TOTAL PD - CORRECTIONS DIVISION
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:9
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
PD - DISPATCH DIVISION 10-56-110 SALARIES
36,122.08
52,061.22
.00
52,061.22
379,522.00
327,460.78
10-56-112 VAC/SICK BUYOUT
.00
.00
.00
.00
6,520.00
6,520.00
.0
10-56-113 LONGEVITY PAY
.00
.00
.00
.00
10,975.00
10,975.00
.0
8,717.98
13,104.09
.00
13,104.09
45,000.00
31,895.91
29.1
20,613.52
32,855.43
.00
32,855.43
237,712.00
204,856.57
13.8
10-56-120 OVERTIME 10-56-130 EMPLOYEE BENEFITS 10-56-230 TRAVEL & TRAINING 10-56-310 PROFESSIONAL & TECHNICAL SVCS 10-56-610 MISCELLANOUS SUPPLIES TOTAL PD - DISPATCH DIVISION
.00
1,010.00
.00
1,010.00
3,400.00
1,081.36
1,081.36
.00
1,081.36
.00
.00
.00
.00
.00
66,534.94
100,112.10
.00
13.7
2,390.00
29.7
1,081.36)
.0
4,000.00
4,000.00
.0
100,112.10
687,129.00
587,016.90
14.6
(
FIRE / RESCUE 10-57-110 SALARIES
174,415.34
258,761.50
.00
258,761.50
1,746,698.00
1,487,936.50
14.8
10-57-112 VAC/SICK BUYOUT
7,938.09
7,938.09
.00
7,938.09
27,589.00
19,650.91
28.8
10-57-113 LONGEVITY PAY
3,500.00
6,125.00
.00
6,125.00
23,525.00
17,400.00
26.0
.00
3,630.00
.00
3,630.00
.00
27,987.30
35,964.56
.00
35,964.56
115,098.81
192,041.31
.00
377.25
471.05
.00
312.30)
1,061.88
73.60
10-57-115 UNIFORM ALLOWANCE
3,630.00)
.0
196,503.00
160,538.44
18.3
192,041.31
1,166,369.00
974,327.69
16.5
471.05
6,000.00
5,528.95
7.9
.00
1,061.88
97,500.00
96,438.12
1.1
146.26
.00
146.26
3,500.00
3,353.74
4.2
6,263.61
9,835.97
14,045.00
23,880.97
82,600.00
58,719.03
28.9
.00
.00
.00
.00
13,500.00
13,500.00
.0
515.14
1,024.73
.00
1,024.73
11,200.00
10,175.27
9.2
7,077.80
7,116.70
.00
7,116.70
71,470.00
64,353.30
10.0
208.00
208.00
.00
208.00
14,000.00
13,792.00
1.5
10-57-610 MISCELLANOUS SUPPLIES
1,050.13
1,497.46
.00
1,497.46
25,750.00
24,252.54
5.8
10-57-615 EMS SUPPLIES
3,346.27
9,179.39
.00
9,179.39
61,000.00
51,820.61
15.1
.00
.00
.00
.00
1,200.00
1,200.00
.0
825.00
1,650.00
.00
1,650.00
9,900.00
8,250.00
16.7
10-57-120 OVERTIME 10-57-130 EMPLOYEE BENEFITS 10-57-210 BOOKS, SUBSCRIPTIONS & MEMBERS 10-57-230 TRAVEL & TRAINING 10-57-240 OFFICE EXPENSE & SUPPLIES 10-57-250 EQUIPMENT SUPPLIES & MAINT NC 10-57-280 UTILITIES - AMERIGAS, ETC 10-57-290 TELEPHONE 10-57-310 PROFESSIONAL & TECHNICAL SVCS 10-57-320 GENERAL HEALTH SERVICES
10-57-620 MISC SERVICES 10-57-691 DISTR EXP: FACILITIES MAINT 10-57-692 DIST EXP: SOLID WASTE
(
(
174.17
348.34
.00
348.34
2,090.00
1,741.66
16.7
10-57-693 DIST EXP: VEHICLE MAINT
5,808.33
11,616.66
.00
11,616.66
69,700.00
58,083.34
16.7
10-57-694 DIST EXP: WATER/POWER/SANI
3,448.25
4,155.53
.00
4,155.53
38,430.00
34,274.47
10.8
10-57-695 BANK/ CREDIT CARD CHARGES
622.19
1,212.62
.00
1,212.62
5,400.00
4,187.38
22.5
27,584.52
27,584.52
300.00
27,884.52
30,000.00
2,115.48
93.0
386,001.50
581,569.57
14,345.00
595,914.57
3,703,924.00
3,108,009.43
16.1
10-57-703 EMPG GRANT EXPENDITURES TOTAL FIRE / RESCUE
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:10
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
PUBLIC WORKS 10-60-110 SALARIES
9,174.55
13,333.68
.00
13,333.68
79,513.00
66,179.32
16.8
10-60-112 VAC/SICK BUYOUT
.00
.00
.00
.00
5,166.00
5,166.00
.0
10-60-113 LONGEVITY PAY
.00
.00
.00
.00
1,481.00
1,481.00
.0
10-60-115 UNIFORM ALLOWANCE
.00
37.50
.00
37.50
38.00
.50
98.7
10-60-120 OVERTIME
.00
.00
.00
.00
1,000.00
1,000.00
.0
10-60-130 EMPLOYEE BENEFITS
3,843.46
5,908.75
.00
5,908.75
37,504.00
31,595.25
15.8
10-60-230 TRAVEL & TRAINING
.00
.00
.00
.00
200.00
200.00
.0
10-60-260 EQUIPMENT
.00
.00
.00
.00
1,000.00
1,000.00
.0
298.65
482.47
.00
482.47
2,100.00
1,617.53
23.0
10-60-310 PROFESSIONAL & TECHNICAL SVCS 10-60-320 GRNERAL HEALTH SERVICES 10-60-610 MISCELLANOUS SUPPLIES
(
TOTAL PUBLIC WORKS
.00
.00
.00
.00
500.00
500.00
.0
593.95)
316.01
.00
316.01
1,600.00
1,283.99
19.8
12,722.71
20,078.41
.00
20,078.41
130,102.00
110,023.59
15.4
27,328.64
40,684.80
.00
40,684.80
241,685.00
201,000.20
16.8
1,709.32
1,709.32
.00
1,709.32
13,141.00
11,431.68
13.0
DEVELOPMENT SERVICES 10-61-110 SALARIES 10-61-112 VAC/SICK BUYOUT 10-61-113 LONGEVITY PAY 10-61-120 OVERTIME 10-61-130 EMPLOYEE BENEFITS
.00
.00
.00
.00
7,310.00
7,310.00
.0
188.46
188.46
.00
188.46
500.00
311.54
37.7
12,406.19
20,091.12
.00
20,091.12
123,736.00
103,644.88
16.2
10-61-210 BOOKS, SUBSCRIPTIONS & MEMBERS
.00
.00
.00
.00
2,540.00
2,540.00
.0
10-61-220 PUBLIC NOTICES
.00
.00
.00
.00
2,000.00
2,000.00
.0
10-61-230 TRAVEL & TRAINING
.00
443.22)
.00
443.22)
670.00
1,113.22
( 66.2)
10-61-240 OFFICE EXPENSE & SUPPLIES 10-61-290 TELEPHONE 10-61-310 PROFFESSIONAL & TECHNICAL SVCS 10-61-610 MISCELLANEOUS SUPPLIES TOTAL DEVELOPMENT SERVICES
(
(
133.49
305.21
.00
305.21
3,500.00
3,194.79
8.7
84.21
168.36
.00
168.36
1,200.00
1,031.64
14.0
.00
.00
.00
.00
3,150.00
3,150.00
.0
114.75
114.75
.00
114.75
5,300.00
5,185.25
2.2
41,965.06
62,818.80
.00
62,818.80
404,732.00
341,913.20
15.5
FACILITY MAINTENANCE 10-63-110 SALARIES
19,987.46
29,140.97
.00
29,140.97
174,994.00
145,853.03
16.7
10-63-112 VAC/SICK BUYOUT
.00
.00
.00
.00
6,052.00
6,052.00
.0
10-63-113 LONGEVITY PAY
.00
.00
.00
.00
7,325.00
7,325.00
.0
10-63-115 UNIFORM ALLOWANCE
.00
1,200.00
.00
1,200.00
1,200.00
.00
100.0
479.64
479.64
.00
479.64
2,800.00
2,320.36
17.1
9,343.40
15,228.43
.00
15,228.43
94,523.00
79,294.57
16.1
.00
.00
.00
.00
800.00
800.00
.0
4,297.00
4,986.53
.00
4,986.53
45,000.00
40,013.47
11.1
10-63-120 OVERTIME 10-63-130 EMPLOYEE BENEFITS 10-63-230 TRAVEL & TRAINING 10-63-250 EQUIPMENT SUPPLIES & MAINT NC 10-63-280 UTILITIES
.00
.00
.00
.00
18,000.00
18,000.00
.0
111.94
226.43
.00
226.43
1,350.00
1,123.57
16.8
10-63-310 PROFESSIONAL & TECHNICAL SVCS
13,184.30
15,977.20
.00
15,977.20
73,500.00
57,522.80
21.7
10-63-610 MISCELLANEOUS SUPPLIES
12,173.84
16,340.80
.00
16,340.80
72,000.00
55,659.20
22.7
16,129.17) (
32,258.34)
.00
10-63-290 TELEPHONE
10-63-690 EXP DISTRIBUTION TO OTHER DEPT
(
(
32,258.34) (
193,550.00) (
161,291.66) ( 16.7)
10-63-693 DIST EXP: VEHICLE MAINT
383.33
766.66
.00
766.66
4,600.00
3,833.34
16.7
10-63-694 DIST EXP: WATER/POWER/SANI
189.53
189.53
.00
189.53
450.00
260.47
42.1
44,021.27
52,277.85
.00
52,277.85
309,044.00
256,766.15
16.9
TOTAL FACILITY MAINTENANCE
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:11
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
STREETS & DRAINAGE 10-65-110 SALARIES
41,797.28
60,689.53
.00
60,689.53
325,306.00
264,616.47
10-65-112 VAC/SICK BUYOUT
.00
.00
.00
.00
13,867.00
13,867.00
.0
10-65-113 LONGEVITY PAY
.00
.00
.00
.00
10,700.00
10,700.00
.0 100.0
10-65-115 UNIFORM ALLOWANCE 10-65-120 OVERTIME 10-65-130 EMPLOYEE BENEFITS 10-65-230 TRAVEL & TRAINING 10-65-250 EQUIPMENT SUPPLIES & MAINT NC 10-65-280 ELECTRICITY - STREET LIGHTS 10-65-290 TELEPHONE 10-65-480 DRAINAGE MAINTENANCE
18.7
.00
2,400.00
.00
2,400.00
2,400.00
.00
84.36
114.73
.00
114.73
2,500.00
2,385.27
4.6
17,491.88
28,828.15
.00
28,828.15
173,428.00
144,599.85
16.6
.00
58.25
.00
58.25
1,500.00
1,441.75
3.9
3,915.25
4,812.76
.00
4,812.76
35,000.00
30,187.24
13.8
18,113.01
18,113.01
.00
18,113.01
256,000.00
237,886.99
7.1
101.94
203.82
.00
203.82
1,200.00
996.18
17.0 62.9
406,195.58
407,935.58
19,700.00
427,635.58
679,700.00
252,064.42
10-65-610 MISCELLANEOUS SUPPLIES
4,655.06
5,059.06
.00
5,059.06
23,000.00
17,940.94
22.0
10-65-615 LOCAL DRAINAGE MAINTENANCE
3,010.00
3,010.00
.00
3,010.00
18,000.00
14,990.00
16.7
10-65-691 DISTR EXP: FACILITIES MAINT
316.67
633.34
.00
633.34
3,800.00
3,166.66
16.7
10-65-692 DIST EXP: SOLID WASTE
258.33
516.66
.00
516.66
3,100.00
2,583.34
16.7
10-65-693 DIST EXP: VEHICLE MAINT
3,608.33
7,216.66
.00
7,216.66
43,300.00
36,083.34
16.7
10-65-694 DIST EXP: WATER/POWER/SANI
2,074.07
2,503.58
.00
2,503.58
14,275.00
11,771.42
17.5
501,621.76
542,095.13
19,700.00
561,795.13
1,607,076.00
1,045,280.87
35.0
99,128.99
16.0
1,408.54)
.0
TOTAL STREETS & DRAINAGE
VEHICLE MAINTENANCE 10-66-110 SALARIES
12,923.05
18,907.01
.00
18,907.01
118,036.00
10-66-112 VAC/SICK BUYOUT
.00
1,408.54
.00
1,408.54
.00
10-66-113 LONGEVITY PAY
.00
.00
.00
.00
1,700.00
1,700.00
.0
10-66-115 UNIFORM ALLOWANCE
.00
300.00
.00
300.00
300.00
.00
100.0
10-66-120 OVERTIME
(
30.36
230.90
.00
230.90
1,000.00
769.10
23.1
10-66-130 EMPLOYEE BENEFITS
6,817.81
13,322.79
.00
13,322.79
75,871.00
62,548.21
17.6
10-66-230 TRAVEL & TRAINING
.00
.00
.00
.00
1,000.00
1,000.00
.0
10-66-240 OFFICE EXPENSES & SUPPLIES
.00
14.79
.00
14.79
1,000.00
985.21
1.5
10-66-250 VEHICLE MAINTENANCE
14,540.88
17,450.21
.00
17,450.21
104,200.00
86,749.79
16.8
10-66-255 FUEL
38,589.84
29,668.62
.00
29,668.62
260,000.00
230,331.38
11.4
10-66-260 EQUIPMENT
.00
.00
.00
.00
1,000.00
1,000.00
.0
10-66-310 PROFESSIONAL & TECHNICAL SVCS
.00
.00
.00
.00
3,000.00
3,000.00
.0
10-66-480 VEH MAINT & FUEL-SILVER RIDER
9,215.70
17,072.68
.00
17,072.68
110,000.00
92,927.32
15.5
10-66-610 SERVICES AND SUPPLIES
1,556.99
1,852.33
.00
1,852.33
12,000.00
10,147.67
15.4
10-66-690 EXP DISTRIBUTION TO OTHER DEPT 10-66-691 DISTR EXP: FACILITIES MAINT 10-66-692 DIST EXP: SOLID WASTE 10-66-694 DIST EXP: WATER/POWER/SANI TOTAL VEHICLE MAINTENANCE
FOR ADMINISTRATION USE ONLY
(
29,075.00) (
58,150.00)
.00
58,150.00) (
348,900.00) (
200.00
400.00
.00
400.00
2,400.00
2,000.00
16.7
75.00
150.00
.00
150.00
900.00
750.00
16.7
224.50
697.51
.00
697.51
16,735.00
16,037.49
4.2
55,099.13
43,325.38
.00
43,325.38
360,242.00
316,916.62
12.0
17 % OF THE FISCAL YEAR HAS ELAPSED
(
290,750.00) ( 16.7)
09/14/2015 06:09PM PAGE:12
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
ANIMAL CONTROL 10-70-110 SALARIES
13,065.08
19,617.37
.00
19,617.37
126,015.00
106,397.63
15.6
10-70-112 VAC/SICK BUYOUT
.00
.00
.00
.00
5,975.00
5,975.00
.0
10-70-113 LONGEVITY PAY
.00
.00
.00
.00
1,875.00
1,875.00
.0
2,000.00
2,000.00
.00
2,000.00
.00
168.93
168.93
.00
168.93
10-70-115 UNIFORM ALLOWANCE 10-70-120 OVERTIME 10-70-130 EMPLOYEE BENEFITS
(
2,000.00)
.0
4,000.00
3,831.07
4.2
6,007.52
9,933.64
.00
9,933.64
62,459.00
52,525.36
15.9
10-70-210 BOOKS, SUBSCRIPTIONS & MEMBERS
.00
.00
.00
.00
650.00
650.00
.0
10-70-230 TRAVEL & TRAINING
.00
.00
.00
.00
1,375.00
1,375.00
.0
109.34
217.43
.00
217.43
1,300.00
1,082.57
16.7 8.7
10-70-290 TELEPHONE 10-70-310 PROFESSIONAL & TECHNICAL SVCS 10-70-610 SERVICES AND SUPPLIES 10-70-691 DISTR EXP: FACILITIES MAINT 10-70-692 DIST EXP: SOLID WASTE
551.92
1,131.17
.00
1,131.17
13,000.00
11,868.83
1,639.90
1,198.22
.00
1,198.22
19,830.00
18,631.78
6.0
100.00
200.00
.00
200.00
1,200.00
1,000.00
16.7
64.58
129.16
.00
129.16
775.00
645.84
16.7
10-70-693 DIST EXP: VEHICLE MAINT
791.67
1,583.34
.00
1,583.34
9,500.00
7,916.66
16.7
10-70-694 DIST EXP: WATER/POWER/SANI
634.78
735.18
.00
735.18
7,800.00
7,064.82
9.4
25,133.72
36,914.44
.00
36,914.44
255,754.00
218,839.56
14.4
499.51
590.49
.00
590.49
2,000.00
1,409.51
29.5
.00
.00
.00
.00
807,300.00
807,300.00
.0
11,454.71
11,454.71
12,902.50
24,357.21
69,400.00
45,042.79
35.1
28,000.00
28,000.00
.0
38,540.00) (
32,116.66) ( 16.7)
TOTAL ANIMAL CONTROL
LANDFILL/SOLID WASTE 10-73-250 EQUIPMENT SUPPLIES & MAINT NC 10-73-260 SOLID WASTE COLLECTION EXPENSE 10-73-310 PROFESSIONAL & TECHNICAL SVCS 10-73-610 MISCELLANEOUS SUPPLIES 10-73-690 EXP DISTRIBUTION TO OTHER DEPT TOTAL LANDFILL/SOLID WASTE
.00 (
.00
.00
6,423.34)
.00
8,742.55
5,621.86
12,902.50
18,524.36
868,160.00
849,635.64
2.1
3,211.67)
(
.00 (
6,423.34)
(
PARKS/GROUNDS MAINT. 10-76-110 SALARIES
43,474.70
62,045.77
.00
62,045.77
399,936.00
337,890.23
15.5
10-76-112 VAC/SICK BUYOUT
.00
.00
.00
.00
12,145.00
12,145.00
.0
10-76-113 LONGEVITY PAY
.00
.00
.00
.00
9,375.00
9,375.00
.0
10-76-115 UNIFORM ALLOWANCE
.00
3,200.00
.00
3,200.00
3,600.00
400.00
88.9
10-76-120 OVERTIME
401.13
412.60
.00
412.60
10,000.00
9,587.40
4.1
10-76-130 EMPLOYEE BENEFITS
21,483.84
35,957.01
.00
35,957.01
236,633.00
200,675.99
15.2
10-76-230 TRAVEL & TRAINING
.00
.00
.00
.00
800.00
800.00
.0
10-76-250 EQUIPMENT SUPPLIES MAINT NC
.00
576.37
.00
576.37
12,000.00
11,423.63
4.8
10-76-290 TELEPHONE
121.94
243.97
.00
243.97
1,300.00
1,056.03
18.8
5,232.90
8,346.85
5,200.00
13,546.85
67,228.00
53,681.15
20.2
31,170.30
49,289.98
43,592.50
92,882.48
147,500.00
54,617.52
63.0
10-76-691 DISTR EXP: FACILITIES MAINT
1,370.83
2,741.66
.00
2,741.66
16,450.00
13,708.34
16.7
10-76-692 DIST EXP: SOLID WASTE
1,875.00
3,750.00
.00
3,750.00
22,500.00
18,750.00
16.7
10-76-693 DIST EXP: VEHICLE MAINT
4,500.00
9,000.00
.00
9,000.00
54,000.00
45,000.00
16.7
57,293.28
109,680.27
.00
109,680.27
498,900.00
389,219.73
22.0
10-76-740 CAPITAL OUTLAY
.00
.00
.00
.00
10-76-799 TRSFR TO VEH/EQUIP REPL FUND
.00
.00
.00
.00
TOTAL PARKS/GROUNDS MAINT.
166,923.92
285,244.48
48,792.50
334,036.98
10-76-310 PROFESSIONAL & TECHNICAL SVCS 10-76-610 MISCELLANEOUS SUPPLIES
10-76-694 DIST EXP: WATER/POWER/SANI
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
(
25,000.00
25,000.00
.0
25,000.00) (
25,000.00)
.0
1,158,330.02
22.4
1,492,367.00
09/14/2015 06:09PM PAGE:13
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
LEISURE SERVICES 10-81-110 SALARIES
42,942.48
64,007.58
.00
64,007.58
404,120.00
340,112.42
15.8
10-81-112 VAC/SICK BUYOUT
.00
.00
.00
.00
20,052.00
20,052.00
.0
10-81-113 LONGEVITY PAY
.00
.00
.00
.00
8,775.00
8,775.00
.0
10-81-120 OVERTIME
.00
.00
.00
.00
5,000.00
5,000.00
.0
16,939.97
29,605.19
.00
29,605.19
164,467.00
134,861.81
18.0 .0
10-81-130 EMPLOYEE BENEFITS 10-81-210 BOOKS, SUBSCRIPTIONS & MEMBERS
.00
.00
.00
.00
600.00
600.00
10-81-230 TRAVEL & TRAINING
.00
.00
.00
.00
7,000.00
7,000.00
.0
293.78
293.78
.00
293.78
6,500.00
6,206.22
4.5 15.1
10-81-240 OFFICE EXPENSE & SUPPLIES 10-81-250 EQUIPMENT SUPPLIES & MAINT NC
1,618.56
4,690.75
.00
4,690.75
31,000.00
26,309.25
10-81-280 UTILITIES
872.73
950.65
.00
950.65
11,000.00
10,049.35
8.6
10-81-290 TELEPHONE
152.91
505.96
.00
505.96
1,500.00
994.04
33.7
10-81-310 PROFESSIONAL & TECHNICAL SVCS 10-81-480 ATHLETIC MARKETING 10-81-485 PRESCHOOL 10-81-490 CITY SPONSORED EVENTS 10-81-610 MISCELLANEOUS SUPPLIES
(
119.70
179.55
.00
179.55
720.00
540.45
24.9
1,083.00
1,083.00
.00
1,083.00
47,000.00
45,917.00
2.3
354.00)
.00
.00
.00
.00
.00
.0
.00
215.45
.00
215.45
12,500.00
12,284.55
1.7 37.9
3,081.40
10,032.74
.00
10,032.74
26,500.00
16,467.26
10-81-620 MISCELLANEOUS SERVICE
.00
.00
.00
.00
2,500.00
2,500.00
.0
10-81-650 REC FEE INCREMENT SPENDING *
.00
.00
.00
.00
34,091.00
34,091.00
.0
5,416.67
10,833.34
.00
10,833.34
65,000.00
54,166.66
16.7
241.67
483.34
.00
483.34
2,900.00
2,416.66
16.7
10-81-691 DISTR EXP: FACILITIES MAINT 10-81-692 DIST EXP: SOLID WASTE 10-81-693 DIST EXP: VEHICLE MAINT
416.67
833.34
.00
833.34
5,000.00
4,166.66
16.7
20,849.66
27,424.11
.00
27,424.11
266,750.00
239,325.89
10.3
93,675.20
151,138.78
.00
151,138.78
1,122,975.00
971,836.22
13.5
10-82-110 SALARIES
3,631.70
5,351.81
.00
5,351.81
31,931.00
26,579.19
16.8
10-82-130 EMPLOYEE BENEFITS
1,669.76
2,966.32
.00
2,966.32
20,769.00
17,802.68
14.3
10-82-210 BOOKS, SUBSCRIPTIONS & MEMBER
.00
.00
.00
.00
150.00
150.00
.0
10-82-230 TRAVEL & TRAINING
.00
.00
.00
.00
600.00
600.00
.0
10-81-694 DIST EXP: WATER/POWER/SANI TOTAL LEISURE SERVICES
MUSEUM
10-82-240 OFFICE EXPENSE AND SUPPLIES 10-82-610 SERVICES AND SUPPLIES
.00
.00
.00
.00
300.00
300.00
.0
12.29
30.79
.00
30.79
3,400.00
3,369.21
.9
10-82-620 MISCELLANEOUS SERVICES
475.90
497.85
.00
497.85
1,200.00
702.15
41.5
10-82-691 DISTR EXP: FACILITIES MAINT
125.00
250.00
.00
250.00
1,500.00
1,250.00
16.7
10-82-692 DIST EXP: SOLID WASTE 10-82-694 DIST EXP: WATER/POWER/SANI TOTAL MUSEUM
16.67
33.34
.00
33.34
200.00
166.66
16.7
313.41
482.03
.00
482.03
4,020.00
3,537.97
12.0
6,244.73
9,612.14
.00
9,612.14
64,070.00
54,457.86
15.0
16.7
TRANSFERS 10-90-113 CAP PROJECTS R & M FUND 10-90-116 SR. NUTRITION S/R FUND 10-90-121 TRSFR TO ENVIRONMENTAL FUND 21
8,333.33
16,666.66
.00
16,666.66
100,000.00
83,333.34
17,808.33
35,616.66
.00
35,616.66
213,700.00
178,083.34
16.7
416.67
833.34
.00
833.34
5,000.00
4,166.66
16.7
10-90-123 MORE COPS FUND #23
11,666.67
23,333.34
.00
23,333.34
140,000.00
116,666.66
16.7
10-90-185 G O BONDS 2002 SERIES
84,725.50
169,451.00
.00
169,451.00
1,016,706.00
847,255.00
16.7
6,241.25
12,482.50
.00
12,482.50
74,895.00
62,412.50
16.7
129,191.75
258,383.50
.00
258,383.50
1,550,301.00
1,291,917.50
16.7
10-90-187 WASTE DISPOSAL D/S FUND TOTAL TRANSFERS
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:14
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
CONTINGENCY 10-99-200 G/F CONTINGENCY TOTAL CONTINGENCY
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
.00
.00
.00
.00
200,000.00
200,000.00
.0
.00
.00
.00
.00
200,000.00
200,000.00
.0
2,284,489.58
3,526,936.66
126,376.00
3,653,312.66
20,415,727.00
16,762,414.34
17.9
353,871.00)
309,229.32
864,151.33) (
536,724.32) (
17 % OF THE FISCAL YEAR HAS ELAPSED
126,376.00) (
663,100.32) (
09/14/2015 06:09PM PAGE:15
(187.4)
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 STREET MAINT. SPEC. REV. FUND ASSETS 11-11900 CASH-COMBINED FUND
2,889,928.08
TOTAL ASSETS
2,889,928.08
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 11-29800 BALANCE - BEGINNING OF YEAR
2,887,265.93
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
2,662.15 2,889,928.08
TOTAL FUND EQUITY
2,889,928.08
TOTAL LIABILITIES AND EQUITY
2,889,928.08
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:16
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 STREET MAINT. SPEC. REV. FUND PER. ACTUAL
11-32-100 UTILITY R.O.W. FEES
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
.00
.00
.00
.00
395,000.00
395,000.00
.0
.00
.00
.00
.00
395,000.00
395,000.00
.0
1,000.00
1,000.00
.00
1,000.00
71,000.00
70,000.00
1.4
.00
.00
.00
.00
850,000.00
850,000.00
.0
2,908.15
2,908.15
.00
2,908.15
221,550.00
218,641.85
1.3
TOTAL STREETS INTERGOV'TL REVE
3,908.15
3,908.15
.00
3,908.15
1,142,550.00
1,138,641.85
.3
TOTAL FUND REVENUE
3,908.15
3,908.15
.00
3,908.15
1,537,550.00
1,533,641.85
.3
TOTAL SOURCE 32
STREETS INTERGOV'TL REVENUE 11-33-100 GAS TAX (COUNTY) 11-33-120 REG'L TRANS COMM - COUNTY 11-33-500 GAS TAX - STATE
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:17
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 STREET MAINT. SPEC. REV. FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
STREETS & DRAINAGE 11-65-700 STREET MAINTENANCE
1,246.00
1,246.00
282,619.13
283,865.13
400,000.00
116,134.87
71.0
.00
.00
.00
.00
865,000.00
865,000.00
.0
TOTAL STREETS & DRAINAGE
1,246.00
1,246.00
282,619.13
283,865.13
1,265,000.00
981,134.87
22.4
TOTAL FUND EXPENDITURES
1,246.00
1,246.00
282,619.13
283,865.13
1,265,000.00
981,134.87
22.4
NET REVENUE OVER EXPENDITURES
2,662.15
2,662.15
282,619.13) (
279,956.98)
272,550.00
552,506.98
(102.7)
11-65-740 CAPITAL OUTLAY
FOR ADMINISTRATION USE ONLY
(
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:18
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 AIRPORT SPECIAL REVENUE FUND ASSETS 12-11900 CASH - COMBINED FUND
304,419.23
12-13102 DUE FROM OTHER GOVT'S
22,240.00
12-13107 ACCOUNTS RECEIVABLE - AVFUEL
97,633.74
12-13115 AVIATION FUEL INVENTORY
52,723.28
TOTAL ASSETS
477,016.25
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 12-29800 BALANCE - BEGINNING OF YEAR
507,007.21
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
29,990.96) 477,016.25
TOTAL FUND EQUITY
477,016.25
TOTAL LIABILITIES AND EQUITY
477,016.25
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:19
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 AIRPORT SPECIAL REVENUE FUND PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
AIRPORT INTERGOV'TL REVENUE 12-33-225 FEDERAL FAA GRANT TOTAL AIRPORT INTERGOV'TL REVEN
.00
.00
.00
.00
300,000.00
300,000.00
.0
.00
.00
.00
.00
300,000.00
300,000.00
.0
CHARGES FOR SERVICES 12-34-600 AVIATION FUEL/OIL SALES
22,936.89
61,687.02
.00
61,687.02
500,000.00
438,312.98
12.3
12-34-605 AIRPORT LEASES
16,664.52
20,124.91
.00
20,124.91
77,000.00
56,875.09
26.1
.00
.00
.00
.00
15,400.00
15,400.00
.0
TOTAL CHARGES FOR SERVICES
39,601.41
81,811.93
.00
81,811.93
592,400.00
510,588.07
13.8
TOTAL FUND REVENUE
39,601.41
81,811.93
.00
81,811.93
892,400.00
810,588.07
9.2
12-34-610 OTHER LEASES
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:20
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 AIRPORT SPECIAL REVENUE FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
AIRPORT 12-87-210 CONTRACTED SERVICES
.00
.00
.00
.00
540.00
540.00
.0
12-87-250 EQUIPMENT SUPPLIES & MAINT NC
.00
.00
.00
.00
2,700.00
2,700.00
.0
12-87-255 FUEL
.00
17,618.05
.00
17,618.05
375,000.00
357,381.95
4.7
12-87-260 EQUIPMENT (NON CAPITALIZED)
.00
.00
.00
.00
1,200.00
1,200.00
.0
6,547.51
14,981.48
.00
14,981.48
83,000.00
68,018.52
18.1
12-87-310 PROFESSIONAL & TECHNICAL SVCS 12-87-480 RUNWAY MISCELLANEOUS SUPPLIES
.00
.00
.00
.00
5,000.00
5,000.00
.0
12-87-510 INSURANCE
.00
.00
.00
.00
7,100.00
7,100.00
.0
12-87-610 MISCELLANEOUS SUPPLIES 12-87-691 DISTR EXP: FACILITIES MAINT 12-87-692 DIST EXP: SOLID WASTE
44.97
320.13
.00
320.13
5,700.00
5,379.87
5.6
358.33
716.66
.00
716.66
4,300.00
3,583.34
16.7
12.50
25.00
.00
25.00
150.00
125.00
16.7
316.67
633.34
.00
633.34
3,800.00
3,166.66
16.7
12-87-694 DIST EXP: WATER/POWER/SANI
2,173.13
2,480.13
.00
2,480.13
19,600.00
17,119.87
12.7
12-87-695 BANK/ CREDIT CARD CHARGES
47.19
361.44
.00
361.44
5,000.00
4,638.56
7.2
8,000.00
8,000.00
297,307.00
305,307.00
320,000.00
14,693.00
95.4
17,500.30
45,136.23
297,307.00
342,443.23
833,090.00
490,646.77
41.1
12-90-010 TRSFR TO GEN FUND #10
33,333.33
66,666.66
.00
66,666.66
400,000.00
333,333.34
16.7
TOTAL DEPARTMENT 90
33,333.33
66,666.66
.00
66,666.66
400,000.00
333,333.34
16.7
TOTAL FUND EXPENDITURES
50,833.63
111,802.89
297,307.00
409,109.89
1,233,090.00
823,980.11
33.2
297,307.00) (
327,297.96) (
12-87-693 DIST EXP: VEHICLE MAINT
12-87-740 CAPITAL OUTLAY TOTAL AIRPORT
DEPARTMENT 90
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
11,232.22) (
29,990.96)
(
17 % OF THE FISCAL YEAR HAS ELAPSED
340,690.00) (
13,392.04) ( 96.1)
09/14/2015 06:09PM PAGE:21
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 CAP. PROJ. MAINT/REPAIRS FUND ASSETS 13-11900 CASH-COMBINED FUND
227,892.78
TOTAL ASSETS
227,892.78
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 13-29800 BALANCE - BEGINNING OF YEAR
238,774.00
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
10,881.22) 227,892.78
TOTAL FUND EQUITY
227,892.78
TOTAL LIABILITIES AND EQUITY
227,892.78
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:22
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 CAP. PROJ. MAINT/REPAIRS FUND PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
CONTRIBUTIONS AND TRANSFERS 13-39-960 TRANSFER FROM G/F
8,333.33
16,666.66
.00
16,666.66
100,000.00
83,333.34
16.7
TOTAL CONTRIBUTIONS AND TRANSF
8,333.33
16,666.66
.00
16,666.66
100,000.00
83,333.34
16.7
TOTAL FUND REVENUE
8,333.33
16,666.66
.00
16,666.66
100,000.00
83,333.34
16.7
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:23
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 CAP. PROJ. MAINT/REPAIRS FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
MAINTENANCE/REPAIRS 13-40-210 CONTRACTED SERVICES
.00
.00
.00
.00
750.00
750.00
.0
13-40-450 MAINTENANCE/REPAIRS
19,622.00
20,587.59
2,660.00
23,247.59
53,900.00
30,652.41
43.1
6,960.29
6,960.29
.00
6,960.29
40,000.00
33,039.71
17.4
TOTAL MAINTENANCE/REPAIRS
26,582.29
27,547.88
2,660.00
30,207.88
94,650.00
64,442.12
31.9
TOTAL FUND EXPENDITURES
26,582.29
27,547.88
2,660.00
30,207.88
94,650.00
64,442.12
31.9
18,248.96) (
10,881.22)
13,541.22)
5,350.00
18,891.22
(253.1)
13-40-625 REPAIRS & REMODELS
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
(
17 % OF THE FISCAL YEAR HAS ELAPSED
2,660.00)
(
09/14/2015 06:09PM PAGE:24
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 POLICE FORFEITURE FUND ASSETS 14-11900 CASH - COMBINED FUND
178,551.76
TOTAL ASSETS
178,551.76
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 14-29800 BALANCE - BEGINNING OF YEAR
173,017.04
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
5,534.72 178,551.76
TOTAL FUND EQUITY
178,551.76
TOTAL LIABILITIES AND EQUITY
178,551.76
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:25
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 POLICE FORFEITURE FUND PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
FINES AND FORFEITURES 14-35-240 FORFEITURES (FEDERAL)
.00
5,534.72
.00
5,534.72
.00
(
5,534.72)
.0
TOTAL FINES AND FORFEITURES
.00
5,534.72
.00
5,534.72
.00
(
5,534.72)
.0
TOTAL FUND REVENUE
.00
5,534.72
.00
5,534.72
.00
(
5,534.72)
.0
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:26
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 POLICE FORFEITURE FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
POLICE 14-54-740 CAPITAL OUTLAY
.00
.00
25,728.00
25,728.00
.00
(
25,728.00)
.0
TOTAL POLICE
.00
.00
25,728.00
25,728.00
.00
(
25,728.00)
.0
TOTAL FUND EXPENDITURES
.00
.00
25,728.00
25,728.00
.00
(
25,728.00)
.0
NET REVENUE OVER EXPENDITURES
.00
5,534.72
25,728.00) (
20,193.28)
.00
20,193.28
.0
FOR ADMINISTRATION USE ONLY
(
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:27
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 COURT ADMINISTRATIVE ASSESS. ASSETS 15-11900 CASH - COMBINED FUND
26,933.29
TOTAL ASSETS
26,933.29
LIABILITIES AND EQUITY
LIABILITIES 15-21310 ACCOUNTS PAYABLE
(
4,500.00)
TOTAL LIABILITIES
(
4,500.00)
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 15-29800 BALANCE - BEGINNING OF YEAR
26,099.10
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
5,334.19 31,433.29
TOTAL FUND EQUITY
31,433.29
TOTAL LIABILITIES AND EQUITY
26,933.29
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:28
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 COURT ADMINISTRATIVE ASSESS. PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
FINES AND FORFEITURES 15-35-100 ADMINISTRATIVE ASSESSMENTS
(
9,695.00)
2,425.00
.00
2,425.00
23,000.00
20,575.00
15-35-300 DUI SPECIALTY COURT FEE
(
300.00)
.00
.00
.00
.00
.00
.0
15-35-400 AA FEE - DNA
(
456.00)
12.00)
.00
12.00)
.00
12.00
.0
(
10,451.00)
2,413.00
.00
2,413.00
23,000.00
20,587.00
10.5
300.00
712.50
.00
712.50
.00
(
712.50)
.0
300.00
712.50
.00
712.50
.00
(
712.50)
.0
10,151.00)
3,125.50
.00
3,125.50
23,000.00
19,874.50
13.6
TOTAL FINES AND FORFEITURES
(
(
10.5
SOURCE 36 15-36-100 COURT COLLECTION FEES TOTAL SOURCE 36
TOTAL FUND REVENUE
FOR ADMINISTRATION USE ONLY
(
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:29
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 COURT ADMINISTRATIVE ASSESS. PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
COURT ADMIN COSTS 15-51-110 SALARIES
.00
265.47
.00
265.47
3,172.00
2,906.53
8.4
15-51-130 EMPLOYEE BENEFITS
.00
20.30
.00
20.30
300.00
279.70
6.8
15-51-230 TRAVEL & TRAINING
.00
15-51-310 PROFESSIONAL & TECHNICAL SVCS
29.27
15-51-620 SUPPLIES & EQUIPMENT 15-51-630 COURT COLLECTION COSTS
(
.00
.00
4,441.46)
.00
(
.00
2,000.00
2,000.00
4,441.46)
2,000.00
6,441.46 (
.0 (222.1)
1,947.00
1,947.00
.00
1,947.00
1,000.00
947.00)
194.7
.00
.00
.00
.00
2,000.00
2,000.00
.0
TOTAL COURT ADMIN COSTS
1,976.27
(
2,208.69)
.00
(
2,208.69)
10,472.00
12,680.69
( 21.1)
TOTAL FUND EXPENDITURES
1,976.27
(
2,208.69)
.00
(
2,208.69)
10,472.00
12,680.69
( 21.1)
5,334.19
.00
5,334.19
12,528.00
7,193.81
42.6
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
12,127.27)
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:30
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 SR. NUTRITION PROGRAM ASSETS 16-11900 CASH - COMBINED FUND
66,798.68
TOTAL ASSETS
66,798.68
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 16-29800 BALANCE - BEGINNING OF YEAR
69,342.73
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
2,544.05) 66,798.68
TOTAL FUND EQUITY
66,798.68
TOTAL LIABILITIES AND EQUITY
66,798.68
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:31
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 SR. NUTRITION PROGRAM PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
INTERGOVERNMENTAL REVENUE 16-33-220 TITLE III, C-1, CONGR. MEALS
.00
.00
.00
.00
72,000.00
72,000.00
.0
16-33-230 TITLE III, C-2, HOME MEALS
.00
.00
.00
.00
129,000.00
129,000.00
.0
16-33-245 EQUIPMENT GRANT 16-33-265 OTHER GRANTS - NSIP 16-33-270 GRANT - CLARK COUNTY OAG TOTAL INTERGOVERNMENTAL REVE
.00
.00
.00
.00
6,000.00
33,493.00
33,493.00
.00
33,493.00
28,000.00
6,000.00
.0
5,493.00)
119.6
.00
.00
.00
.00
30,000.00
30,000.00
.0
33,493.00
33,493.00
.00
33,493.00
265,000.00
231,507.00
12.6
14.7
(
CHARGES FOR SERVICES 3,989.80
8,548.04
.00
8,548.04
58,000.00
49,451.96
16-34-410 OTHER INCOME
16-34-400 PATRON DONATIONS
175.00
368.00
.00
368.00
6,000.00
5,632.00
6.1
16-34-415 INMATE MEALS
1,453.50
3,440.25
.00
3,440.25
24,000.00
20,559.75
14.3
5,618.30
12,356.29
.00
12,356.29
88,000.00
75,643.71
14.0
TOTAL CHARGES FOR SERVICES
OTHER REVENUE 16-38-120 DONATIONS
.00
.00
.00
.00
5,000.00
150.00
350.00
.00
350.00
300.00
150.00
350.00
.00
350.00
17,808.33
35,616.66
.00
TOTAL TRANSFERS
17,808.33
35,616.66
TOTAL FUND REVENUE
57,069.63
81,815.95
16-38-150 FACILITIES / SPACE RENTAL TOTAL OTHER REVENUE
5,000.00
.0
50.00)
116.7
5,300.00
4,950.00
6.6
35,616.66
213,700.00
178,083.34
16.7
.00
35,616.66
213,700.00
178,083.34
16.7
.00
81,815.95
572,000.00
490,184.05
14.3
(
TRANSFERS 16-39-960 TRANSFER FROM G/F
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:32
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 SR. NUTRITION PROGRAM PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
SR. NUTRITION EXPENSES 16-71-110 SALARIES
18,777.79
27,093.45
.00
27,093.45
179,603.00
152,509.55
15.1
16-71-112 VAC/SICK BUYOUT
.00
.00
.00
.00
6,679.00
6,679.00
.0
16-71-113 LONGEVITY PAY
.00
.00
.00
.00
5,200.00
5,200.00
.0
16-71-120 OVERTIME
.00
.00
.00
.00
1,500.00
1,500.00
.0
10,146.10
17,342.59
.00
17,342.59
108,752.00
91,409.41
16.0
16-71-130 EMPLOYEE BENEFITS 16-71-210 CONTRACTED SERVICES
.00
.00
.00
.00
500.00
500.00
.0
16-71-230 TRAVEL & TRAINING
.00
.00
.00
.00
800.00
800.00
.0
16-71-240 OFFICE EXPENSE & SUPPLIES 16-71-250 EQUIPMENT SUPPLIES & MAINT NC
22.00
22.00
.00
22.00
900.00
878.00
2.4
140.00
318.00
.00
318.00
700.00
382.00
45.4
16-71-280 UTILITIES
.00
.00
.00
.00
468.00
468.00
.0
16-71-290 TELEPHONE
.00
.00
.00
.00
650.00
650.00
.0
16-71-310 PROFESSIONAL & TECHNICAL SVCS
77.80
116.70
.00
116.70
1,500.00
1,383.30
7.8
15,029.59
28,981.86
.00
28,981.86
174,000.00
145,018.14
16.7
16-71-610 MISCELLANEOUS SUPPLIES
174.71
1,377.31
.00
1,377.31
6,500.00
5,122.69
21.2
16-71-620 MISCELLANEOUS SERVICES
137.87
200.77
.00
200.77
6,500.00
6,299.23
3.1
1,300.00
2,600.00
.00
2,600.00
15,600.00
13,000.00
16.7
16-71-480 FOOD/COMMODITY SUPPLIES
16-71-691 DISTR EXP: FACILITIES MAINT 16-71-692 DIST EXP: SOLID WASTE
225.00
450.00
.00
450.00
2,700.00
2,250.00
16.7
16-71-693 DIST EXP: VEHICLE MAINT
741.67
1,483.34
.00
1,483.34
8,900.00
7,416.66
16.7
2,853.78
4,373.98
.00
4,373.98
36,500.00
32,126.02
12.0
.00
.00
.00
.00
11,000.00
11,000.00
.0
TOTAL SR. NUTRITION EXPENSES
49,626.31
84,360.00
.00
84,360.00
568,952.00
484,592.00
14.8
TOTAL FUND EXPENDITURES
49,626.31
84,360.00
.00
84,360.00
568,952.00
484,592.00
14.8
2,544.05)
.00
2,544.05)
3,048.00
5,592.05
16-71-694 DIST EXP: WATER/POWER/SANI 16-71-740 CAPITAL OUTLAY
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
7,443.32
(
17 % OF THE FISCAL YEAR HAS ELAPSED
(
09/14/2015 06:09PM PAGE:33
( 83.5)
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 RECREATION PROGRAMS ASSETS 17-11900 CASH - COMBINED FUND
316,886.45
TOTAL ASSETS
316,886.45
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 17-29800 BALANCE - BEGINNING OF YEAR
381,996.91
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
65,110.46) 316,886.45
TOTAL FUND EQUITY
316,886.45
TOTAL LIABILITIES AND EQUITY
316,886.45
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:34
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 RECREATION PROGRAMS PER. ACTUAL
17-33-270 GRANT - CLARK COUNTY OAG
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
.00
.00
.00
.00
30,000.00
30,000.00
.0
.00
.00
.00
.00
30,000.00
30,000.00
.0
16,776.13
29,937.63
.00
29,937.63
190,000.00
160,062.37
15.8
2,661.01
4,165.51
.00
4,165.51
70,000.00
65,834.49
6.0
17-34-410 EVENTS FEES
2.00
92.00
.00
92.00
18,000.00
17,908.00
.5
17-34-415 DONATIONS
.00
.00
.00
.00
2,580.00
2,580.00
.0
TOTAL CHARGES FOR SERVICES
19,439.14
34,195.14
.00
34,195.14
280,580.00
246,384.86
12.2
TOTAL FUND REVENUE
19,439.14
34,195.14
.00
34,195.14
310,580.00
276,384.86
11.0
TOTAL SOURCE 33
CHARGES FOR SERVICES 17-34-400 RECREATION CHARGES 17-34-405 FIELD RENTAL
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:35
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 RECREATION PROGRAMS PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
RECREATION PROGRAM COSTS 17-80-110 SALARIES
24,265.35
35,837.91
.00
35,837.91
144,090.00
108,252.09
24.9
17-80-112 VAC/SICK BUYOUT
.00
.00
.00
.00
573.00
573.00
.0
17-80-113 LONGEVITY PAY
.00
.00
.00
.00
600.00
600.00
.0
17-80-115 UNIFORM ALLOWANCE
.00
400.00
.00
400.00
400.00
.00
100.0
17-80-130 EMPLOYEE BENEFITS
4,598.77
7,629.90
.00
7,629.90
42,104.00
34,474.10
18.1
17-80-310 PROFFESSIONAL & TECHNICAL SVCS
9,208.00
12,958.75
.00
12,958.75
66,000.00
53,041.25
19.6 46.6
17-80-485 PRE-SCHOOL COSTS
842.24
2,796.37
.00
2,796.37
6,000.00
3,203.63
1,908.48
4,002.81
.00
4,002.81
46,000.00
41,997.19
8.7
641.52
641.52
.00
641.52
6,000.00
5,358.48
10.7
1,705.00
1,705.00
16,668.00
18,373.00
.00
18,373.00)
.0
43,169.36
65,972.26
16,668.00
82,640.26
311,767.00
229,126.74
26.5
16,666.67
33,333.34
.00
33,333.34
200,000.00
166,666.66
16.7
TOTAL TRANSFERS
16,666.67
33,333.34
.00
33,333.34
200,000.00
166,666.66
16.7
TOTAL FUND EXPENDITURES
59,836.03
99,305.60
16,668.00
115,973.60
511,767.00
395,793.40
22.7
40,396.89) (
65,110.46)
201,187.00) (
119,408.54) ( 40.7)
17-80-610 MISCELLANEOUS SUPPLIES 17-80-695 BANK/ CREDIT CARD CHARGES 17-80-740 CAPITAL OUTLAY TOTAL RECREATION PROGRAM COST
(
TRANSFERS 17-90-109 TRANSFER TO GEN. FUND
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
(
17 % OF THE FISCAL YEAR HAS ELAPSED
16,668.00) (
81,778.46) (
09/14/2015 06:09PM PAGE:36
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 FORENSIC SERVICES ASSETS 19-11900 CASH - COMBINED FUND
3,379.34
TOTAL ASSETS
3,379.34
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 19-29800 BALANCE - BEGINNING OF YEAR
3,436.00
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
56.66) 3,379.34
TOTAL FUND EQUITY
3,379.34
TOTAL LIABILITIES AND EQUITY
3,379.34
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:37
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 FORENSIC SERVICES PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
FINES AND FORFEITURES 19-35-200 ANALYSIS FEE, DUI NRS484.3798
120.00
360.00
.00
360.00
500.00
140.00
72.0
.00
.00
.00
.00
2,000.00
2,000.00
.0
TOTAL FINES AND FORFEITURES
120.00
360.00
.00
360.00
2,500.00
2,140.00
14.4
TOTAL FUND REVENUE
120.00
360.00
.00
360.00
2,500.00
2,140.00
14.4
19-35-300 ANALYSIS FEE, DRUGS NRS453.575
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:38
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 FORENSIC SERVICES PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
TRANSFERS 19-90-109 TRANSFER TO GEN. FUND
208.33
416.66
.00
416.66
2,500.00
2,083.34
16.7
TOTAL TRANSFERS
208.33
416.66
.00
416.66
2,500.00
2,083.34
16.7
TOTAL FUND EXPENDITURES
208.33
416.66
.00
416.66
2,500.00
2,083.34
16.7
56.66)
.00
56.66)
.00
56.66
.0
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
88.33)
(
17 % OF THE FISCAL YEAR HAS ELAPSED
(
09/14/2015 06:09PM PAGE:39
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 RESID. CONSTR. TAX PARK FUND ASSETS 20-11900 CASH - COMBINED FUND
1,002,114.78
TOTAL ASSETS
1,002,114.78
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 20-29800 BALANCE - BEGINNING OF YEAR
957,744.58
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
44,370.20 1,002,114.78
TOTAL FUND EQUITY
1,002,114.78
TOTAL LIABILITIES AND EQUITY
1,002,114.78
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:40
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 RESID. CONSTR. TAX PARK FUND PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
LICENSES AND PERMITS 20-32-210 BUILDING PARK FEES TOTAL LICENSES AND PERMITS
25,000.00
53,000.00
.00
53,000.00
180,000.00
127,000.00
29.4
25,000.00
53,000.00
.00
53,000.00
180,000.00
127,000.00
29.4
.00
.00
.00
.00
200,000.00
200,000.00
.0
.00
.00
.00
.00
200,000.00
200,000.00
.0
25,000.00
53,000.00
.00
53,000.00
380,000.00
327,000.00
14.0
GRANT REVENUE 20-33-110 CDBG GRANT TOTAL GRANT REVENUE
TOTAL FUND REVENUE
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:41
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 RESID. CONSTR. TAX PARK FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
PARKS/GROUNDS MAINT. 20-76-751 PARK REPAIRS/IMPROVEMENTS
.00
8,629.80
.00
8,629.80
200,000.00
20-76-803 PIONEER PARK-CONCESSION CEMENT
.00
.00
31,229.50
31,229.50
.00
20-76-806 HAFEN PARK-RUBBERIZED SURFACE
.00
.00
36,031.00
36,031.00
TOTAL PARKS/GROUNDS MAINT.
.00
8,629.80
67,260.50
TOTAL FUND EXPENDITURES
.00
8,629.80
25,000.00
44,370.20
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
17 % OF THE FISCAL YEAR HAS ELAPSED
191,370.20 (
4.3
31,229.50)
.0
200,000.00
163,969.00
18.0
75,890.30
400,000.00
324,109.70
19.0
67,260.50
75,890.30
400,000.00
324,109.70
19.0
67,260.50) (
22,890.30) (
20,000.00)
2,890.30
09/14/2015 06:09PM PAGE:42
(114.5)
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 ENVIR. PLANNING SPEC.REV. FUND ASSETS 21-11900 CASH - COMBINED FUND
503,201.82
TOTAL ASSETS
503,201.82
LIABILITIES AND EQUITY
LIABILITIES 21-23215 VRHCP IMPACT FEES COLLECTIONS
442,329.37
21-25501 DEFERRED INC - TOWN WASH MITIG
47,575.50
21-25502 DEFERRED INC - PULTE
12,872.51
TOTAL LIABILITIES
502,777.38
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 21-29800 BALANCE - BEGINNING OF YEAR
23,536.64
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
23,112.20) 424.44
TOTAL FUND EQUITY
424.44
TOTAL LIABILITIES AND EQUITY
FOR ADMINISTRATION USE ONLY
503,201.82
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:09PM PAGE:43
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 ENVIR. PLANNING SPEC.REV. FUND PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
GRANT REVENUE 21-33-267 HABITAT GRADING PERMIT FEES
.00
.00
.00
.00
170,000.00
170,000.00
.0
21-33-275 DVLPER MITIG FEES-TOWN WASH
.00
.00
.00
.00
29,000.00
29,000.00
.0
.00
.00
.00
.00
199,000.00
199,000.00
.0
416.67
833.34
.00
833.34
5,000.00
4,166.66
16.7
TOTAL OTHER FINANCING SOURCES
416.67
833.34
.00
833.34
5,000.00
4,166.66
16.7
TOTAL FUND REVENUE
416.67
833.34
.00
833.34
204,000.00
203,166.66
.4
TOTAL GRANT REVENUE
OTHER FINANCING SOURCES 21-39-960 TRANSFER FROM G/F
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:44
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 ENVIR. PLANNING SPEC.REV. FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
EXPENDITURES 21-85-110 SALARIES 21-85-112 VAC/SICK BUYOUT 21-85-113 LONGEVITY PAY
10,829.14
15,738.35
.00
15,738.35
108,462.00
92,723.65
14.5
732.56
732.56
.00
732.56
6,236.00
5,503.44
11.8
1,225.00
.0
.00
.00
.00
.00
1,225.00
64.08
64.08
.00
64.08
.00
21-85-130 EMPLOYEE BENEFITS
4,598.54
7,410.55
.00
7,410.55
51,379.00
21-85-216 EXIT 118 MITIGATION
.00
.00
31,395.00
31,395.00
.00
21-85-220 PUBLIC NOTICES
.00
.00
.00
.00
2,000.00
2,000.00
.0
21-85-310 PROFESSIONAL & TECHNICAL SVCS
.00
.00
.00
.00
29,000.00
29,000.00
.0
21-85-311 PROFESSIONAL & TECHNICAL FWS
.00
.00
414,826.40
414,826.40
.00
(
414,826.40)
.0
TOTAL EXPENDITURES
16,224.32
23,945.54
446,221.40
470,166.94
198,302.00
(
271,864.94)
237.1
TOTAL FUND EXPENDITURES
16,224.32
23,945.54
446,221.40
470,166.94
198,302.00
(
271,864.94)
237.1
15,807.65) (
23,112.20)
446,221.40) (
469,333.60)
5,698.00
475,031.60
(8236.
21-85-120 OVERTIME
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
(
17 % OF THE FISCAL YEAR HAS ELAPSED
( (
64.08)
.0
43,968.45
14.4
31,395.00)
.0
09/14/2015 06:10PM PAGE:45
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 TRANSPORTATION IMPACT FEE FUND ASSETS 22-11900 CASH-COMBINED FUND
2,119,840.59
TOTAL ASSETS
2,119,840.59
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 22-29800 BALANCE - BEGINNING OF YEAR
2,117,112.91
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
2,727.68 2,119,840.59
TOTAL FUND EQUITY
2,119,840.59
TOTAL LIABILITIES AND EQUITY
2,119,840.59
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:46
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 TRANSPORTATION IMPACT FEE FUND PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
LICENSES AND PERMITS 22-32-210 TRANSPORT. IMPACT FEES
1,458.78
2,727.68
.00
2,727.68
9,500.00
6,772.32
28.7
TOTAL LICENSES AND PERMITS
1,458.78
2,727.68
.00
2,727.68
9,500.00
6,772.32
28.7
TOTAL FUND REVENUE
1,458.78
2,727.68
.00
2,727.68
9,500.00
6,772.32
28.7
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:47
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 TRANSPORTATION IMPACT FEE FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
STREETS & DRAINAGE 22-65-744 SIGNAL- PIONEER / TURTLEBACK
.00
.00
.00
.00
350,000.00
350,000.00
.0
TOTAL STREETS & DRAINAGE
.00
.00
.00
.00
350,000.00
350,000.00
.0
TOTAL FUND EXPENDITURES
.00
.00
.00
.00
350,000.00
350,000.00
.0
1,458.78
2,727.68
.00
2,727.68
340,500.00) (
343,227.68)
.8
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
(
09/14/2015 06:10PM PAGE:48
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 MORE COPS SRF ASSETS 23-11900 CASH COMBINED FUND
(
23-13107 OTHER RECEIVABLES
169,381.75) 120,000.00
TOTAL ASSETS
(
49,381.75)
TOTAL FUND EQUITY
(
49,381.75)
TOTAL LIABILITIES AND EQUITY
(
49,381.75)
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 23-29800 BALANCE BEGINNING YEAR
(
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
FOR ADMINISTRATION USE ONLY
49,586.70) 204.95 (
49,381.75)
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:49
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 MORE COPS SRF PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
INTERGOVERNMENTAL REVENUES 23-33-255 MORE COPS GRANT-1/4% SALES TAX
60,000.00
120,000.00
.00
120,000.00
785,000.00
665,000.00
15.3
60,000.00
120,000.00
.00
120,000.00
785,000.00
665,000.00
15.3
.00
.00
.00
.00
100.00
100.00
.0
.00
.00
.00
.00
100.00
100.00
.0
11,666.67
23,333.34
.00
23,333.34
140,000.00
116,666.66
16.7
TOTAL OTHER FINANCING SOURCES
11,666.67
23,333.34
.00
23,333.34
140,000.00
116,666.66
16.7
TOTAL FUND REVENUE
71,666.67
143,333.34
.00
143,333.34
925,100.00
781,766.66
15.5
TOTAL INTERGOVERNMENTAL REVE
OTHER REVENUE 23-38-100 INTEREST INCOME TOTAL OTHER REVENUE
OTHER FINANCING SOURCES 23-39-960 TRANSFER FROM G/F
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:50
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 MORE COPS SRF PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
EXPENDITURES 23-85-110 SALARIES
48,284.80
71,642.78
.00
71,642.78
476,212.00
404,569.22
15.0
23-85-112 VAC/SICK BUYOUT
2,180.00
2,180.00
.00
2,180.00
17,734.00
15,554.00
12.3
23-85-113 LONGEVITY PAY
2,500.00
2,500.00
.00
2,500.00
5,250.00
2,750.00
47.6
.00
.00
.00
.00
14,000.00
14,000.00
.0
750.00
1,250.00
.00
1,250.00
6,500.00
5,250.00
19.2
23-85-115 UNIFORM ALLOWANCE 23-85-116 EDUCATION ASSISTANCE PAY 23-85-120 OVERTIME
6,422.33
8,453.51
.00
8,453.51
25,000.00
16,546.49
33.8
32,042.24
52,519.90
.00
52,519.90
328,989.00
276,469.10
16.0
2,111.50
4,582.20
.00
4,582.20
55,400.00
50,817.80
8.3
TOTAL EXPENDITURES
94,290.87
143,128.39
.00
143,128.39
929,085.00
785,956.61
15.4
TOTAL FUND EXPENDITURES
94,290.87
143,128.39
.00
143,128.39
929,085.00
785,956.61
15.4
22,624.20)
204.95
.00
204.95
4,189.95)
5.1
23-85-130 EMPLOYEE BENEFITS 23-85-250 EQUIPMENT SUPPLIES & MAINT NC
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
17 % OF THE FISCAL YEAR HAS ELAPSED
(
3,985.00)
(
09/14/2015 06:10PM PAGE:51
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 REDEVELOPMENT DISTRICT ASSETS 25-11900 CASH - COMBINED FUND
5,043,205.55
25-12100 CASH - NEVADA ST BANK(BOND $$)
622,561.61
25-13110 NOTE RECEIVABLE
25.00
TOTAL ASSETS
5,665,792.16
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 25-29800 BALANCE - BEGINNING OF YEAR
5,837,044.10
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
171,251.94) 5,665,792.16
TOTAL FUND EQUITY
5,665,792.16
TOTAL LIABILITIES AND EQUITY
5,665,792.16
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:52
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 REDEVELOPMENT DISTRICT PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
TAXES 25-31-100 PROPERTY TAXES TOTAL TAXES
90,590.50
90,590.50
.00
90,590.50
2,100,000.00
2,009,409.50
4.3
90,590.50
90,590.50
.00
90,590.50
2,100,000.00
2,009,409.50
4.3
.00
.00
.00
.00
50,000.00
50,000.00
.0
.00
.00
.00
.00
50,000.00
50,000.00
.0
INTERGOVERNMENTAL REVENUE 25-33-230 NDOT GRANTS-ROADS/HIGHWAYS TOTAL INTERGOVERNMENTAL REVE
OTHER REVENUE 25-38-100 INTEREST REVENUE 25-38-110 LEASE REV-COMMUNITY SIGNS TOTAL OTHER REVENUE
TOTAL FUND REVENUE
FOR ADMINISTRATION USE ONLY
96.31
205.75
.00
205.75
1,600.00
660.00
1,320.00
.00
1,320.00
.00
756.31
1,525.75
.00
1,525.75
91,346.81
92,116.25
.00
92,116.25
17 % OF THE FISCAL YEAR HAS ELAPSED
1,394.25
12.9
1,320.00)
.0
1,600.00
74.25
95.4
2,151,600.00
2,059,483.75
4.3
(
09/14/2015 06:10PM PAGE:53
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 REDEVELOPMENT DISTRICT PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
SPECIAL APPROPRIATIONS 25-85-110 SALARIES
8,734.33
12,729.35
.00
12,729.35
75,612.00
62,882.65
16.8
25-85-112 VAC/SICK BUYOUT
.00
246.30
.00
246.30
3,152.00
2,905.70
7.8
25-85-113 LONGEVITY PAY
.00
.00
.00
.00
830.00
830.00
.0
25-85-120 OVERTIME
.00
.00
.00
.00
250.00
250.00
.0
3,827.92
6,227.20
.00
6,227.20
38,967.00
32,739.80
16.0 ( 5.0)
25-85-130 EMPLOYEE BENEFITS 25-85-210 BOOKS, SUBSCRIPTIONS & MEMBERS
50.00)
.00
50.00)
1,000.00
1,050.00
25-85-230 TRAVEL & TRAINING
(
.00
10.00
.00
10.00
4,000.00
3,990.00
.3
25-85-240 OFFICE EXPENSE & SUPPLIES
.00
.00
.00
.00
2,000.00
2,000.00
.0
25-85-620 MISCELLANEOUS SERVICES
50.00)
(
(
310.00
560.00
4,550.00
5,110.00
50,000.00
44,890.00
10.2
25-85-653 DISTRICT SUPPORT SERVICES
.00
.00
.00
.00
150,000.00
150,000.00
.0
25-85-700 LAND PURCHASES
.00
.00
.00
.00
200,000.00
200,000.00
.0
25-85-740 C/P-STREETSCAPES
.00
.00
.00
.00
400,000.00
400,000.00
.0
25-85-754 COMMUNITY SIGNS
.00
.00
.00
.00
3,000.00
3,000.00
.0
25-85-756 TOWN SQUARE MEMORIAL PARK
.00
.00
.00
.00
600,000.00
600,000.00
.0
990.00
990.00
128,770.00
129,760.00
100,000.00
29,760.00)
129.8
13,812.25
20,712.85
133,320.00
154,032.85
1,628,811.00
1,474,778.15
9.5
25-85-757 HISTORIC BUILDING RESTORATION TOTAL SPECIAL APPROPRIATIONS
(
TRANSFERS 25-90-101 TRSFR - DEBT SVC FUND #85
36,602.17
73,204.34
.00
73,204.34
439,226.00
366,021.66
16.7
25-90-109 TRANSFER TO GEN. FUND
84,725.50
169,451.00
.00
169,451.00
1,016,706.00
847,255.00
16.7
TOTAL TRANSFERS
121,327.67
242,655.34
.00
242,655.34
1,455,932.00
1,213,276.66
16.7
TOTAL FUND EXPENDITURES
135,139.92
263,368.19
133,320.00
396,688.19
3,084,743.00
2,688,054.81
12.9
171,251.94) (
133,320.00) (
304,571.94) (
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
43,793.11) (
17 % OF THE FISCAL YEAR HAS ELAPSED
933,143.00) (
628,571.06) ( 32.6)
09/14/2015 06:10PM PAGE:54
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 CAPITAL PROJECT FUND ASSETS 45-11900 CASH - COMBINED FUND
2,110,561.54
TOTAL ASSETS
2,110,561.54
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 45-29800 BEGINNING OF YEAR
2,129,419.51
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
18,857.97) 2,110,561.54
TOTAL FUND EQUITY
2,110,561.54
TOTAL LIABILITIES AND EQUITY
2,110,561.54
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:55
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 CAPITAL PROJECT FUND PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
INTERGOVERNMENTAL REVENUE 45-33-255 CC - REGIONAL FLOOD CONTROL
.00
.00
.00
.00
184,000.00
184,000.00
.0
45-33-257 HIGHWAY GRANT - RTC (EXIT 118)
.00
.00
.00
.00
10,500,000.00
10,500,000.00
.0
TOTAL INTERGOVERNMENTAL REVE
.00
.00
.00
.00
10,684,000.00
10,684,000.00
.0
TOTAL FUND REVENUE
.00
.00
.00
.00
10,684,000.00
10,684,000.00
.0
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:56
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 CAPITAL PROJECT FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
EXPENDITURES 45-40-100 COST OF LAND SALES
.00
2,422.30
.00
2,422.30
.00
2,422.30)
.0
45-40-800 CEMETERY
1,934.00
1,934.00
331,100.00
333,034.00
500,000.00
(
166,966.00
66.6
45-40-805 E. FIRST SOUTH TO DAIRY LANE
18.3
2,376.67
2,376.67
25,000.00
27,376.67
150,000.00
122,623.33
45-40-807 MSEC CAPITAL IMPROVEMENTS (HQ,
.00
.00
.00
.00
100,000.00
100,000.00
.0
45-40-811 VIRGIN RIVER/E. MESQUITE BLVD.
.00
.00
.00
.00
184,000.00
184,000.00
.0
11,610.00
12,125.00
319,120.88
331,245.88
10,500,000.00
10,168,754.12
3.2
TOTAL EXPENDITURES
15,920.67
18,857.97
675,220.88
694,078.85
11,434,000.00
10,739,921.15
6.1
TOTAL FUND EXPENDITURES
15,920.67
18,857.97
675,220.88
694,078.85
11,434,000.00
10,739,921.15
6.1
15,920.67) (
18,857.97)
675,220.88) (
694,078.85) (
45-40-812 EXIT 118 - CONSTRUCTION
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
(
17 % OF THE FISCAL YEAR HAS ELAPSED
750,000.00) (
55,921.15) ( 92.5)
09/14/2015 06:10PM PAGE:57
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 SEWER FUND ASSETS 52-11800 CASH-BK OF NEVADA WASTE BONDS
147,941.70
52-11900 CASH - COMBINED FUND
1,790,892.18
52-13102 OTHER RECEVABLES
332.88
52-13109 SALES TAXES REC'BLE
45,000.00
52-13110 ACCOUNTS RECEIVABLE
16,796.12
52-14000 PREPAID EXPENSE
127,083.34
52-16300 LAND
174,756.00
52-16310 SEWER SYSTEM
36,278,286.34
52-16315 UTILITY LINES
32,022,428.98
52-16350 LAND EASEMENTS
25,300.00
52-16510 MACHINERY AND EQUIPMENT
715,658.60
52-16610 AUTOMOBILE AND TRUCKS
508,262.88
52-17500 ACCUMULATED DEPRECIATION
( 16,683,730.89)
TOTAL ASSETS
55,169,008.13
LIABILITIES AND EQUITY
LIABILITIES 52-21315 ACCRUED INTEREST
78,250.00
52-21325 ACCRUED VACATION
98,345.39
52-21500 CURRENT PORTION - L/T DEBT
967,840.23
52-25103 BONDS PAYABLE - NEVADA, 2.863%
15,673,915.10
TOTAL LIABILITIES
16,818,350.72
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 52-29800 BEGINNING OF YEAR
32,507,322.96
52-29805 CONTRIBUTED CAPITAL, NET
5,676,978.00
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
166,356.45 38,350,657.41
TOTAL FUND EQUITY
38,350,657.41
TOTAL LIABILITIES AND EQUITY
55,169,008.13
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:58
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 SEWER FUND PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
TAXES 52-31-102 SALES TAX (HALF .25%) TOTAL TAXES
50,203.32
95,203.32
.00
95,203.32
569,000.00
473,796.68
16.7
50,203.32
95,203.32
.00
95,203.32
569,000.00
473,796.68
16.7
OPERATING REVENUE 52-37-100 SEWER SERVICES 52-37-200 CONNECTION FEES TOTAL OPERATING REVENUE
1,132.61
607,482.94
.00
607,482.94
2,451,950.00
1,844,467.06
24.8
54,910.00
108,300.00
.00
108,300.00
380,000.00
271,700.00
28.5
56,042.61
715,782.94
.00
715,782.94
2,831,950.00
2,116,167.06
25.3
OTHER REVENUE 52-38-100 INTEREST EARNINGS 52-38-900 MISCELLANEOUS TOTAL OTHER REVENUE
TOTAL FUND REVENUE
FOR ADMINISTRATION USE ONLY
.00
.00
.00
.00
500.00
500.00
.0
13,664.68
13,649.68
.00
13,649.68
188,500.00
174,850.32
7.2
13,664.68
13,649.68
.00
13,649.68
189,000.00
175,350.32
7.2
119,910.61
824,635.94
.00
824,635.94
3,589,950.00
2,765,314.06
23.0
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:59
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 SEWER FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
EXPENDITURES 52-40-110 SALARIES AND WAGES
75,101.76
111,778.01
.00
111,778.01
646,170.00
534,391.99
17.3
52-40-112 VAC/SICK BUYOUT
16,127.26
16,127.26
.00
16,127.26
22,792.00
6,664.74
70.8
.00
.00
.00
.00
11,844.00
11,844.00
.0
400.00
2,512.50
.00
2,512.50
2,913.00
400.50
86.3
52-40-113 LONGEVITY PAY 52-40-115 UNIFORM ALLOWANCE 52-40-120 OVERTIME 52-40-130 EMPLOYEE BENEFITS 52-40-230 TRAVEL & TRAINING 52-40-240 OFFICE EXPENSE & SUPPLIES 52-40-250 EQUIPMENT SUPPLIES & MAINT NC 52-40-260 EQUIPMENT 52-40-280 UTILITIES 52-40-290 TELEPHONE 52-40-310 PROFESSIONAL & TECHNICAL SVCS 52-40-480 CHEMICAL SUPPLIES 52-40-510 INSURANCE 52-40-535 DEPRECIATION
1,373.67
1,832.81
.00
1,832.81
10,000.00
8,167.19
18.3
33,146.41
53,705.32
.00
53,705.32
350,952.00
297,246.68
15.3
.00
240.00
.00
240.00
3,500.00
3,260.00
6.9
414.94
605.06
.00
605.06
12,000.00
11,394.94
5.0
7,976.25
11,966.43
.00
11,966.43
44,300.00
32,333.57
27.0
329.54
826.60
.00
826.60
5,500.00
4,673.40
15.0
26,728.20
26,728.20
.00
26,728.20
306,000.00
279,271.80
8.7
528.20
868.04
.00
868.04
4,000.00
3,131.96
21.7
11,409.51
14,923.92
27,302.63
42,226.55
155,000.00
112,773.45
27.2
6,202.00
12,537.54
59,065.00
71,602.54
117,000.00
45,397.46
61.2
12,708.33
25,416.66
.00
25,416.66
172,500.00
147,083.34
14.7
135,250.00
270,500.00
.00
270,500.00
1,623,000.00
1,352,500.00
16.7
52-40-610 MISCELLANEOUS SUPPLIES
3,451.60
14,721.67
.00
14,721.67
68,000.00
53,278.33
21.7
52-40-620 MISCELLANOUES SERVICES
593.00
1,049.50
.00
1,049.50
75,000.00
73,950.50
1.4
52-40-695 BANK/CREDIT CARD FEES
2,106.97
2,106.97
.00
2,106.97
12,700.00
10,593.03
16.6
52-40-740 SEWER CAPITAL OUTLAY
11,583.00
11,583.00
.00
11,583.00
289,000.00
277,417.00
4.0
52-40-750 LATERAL CONS.FEE REIM.
.00
.00
.00
.00
10,000.00
10,000.00
.0
52-40-820 DEBT SERVICE - INTEREST
39,125.00
78,250.00
.00
78,250.00
487,883.00
409,633.00
16.0
TOTAL EXPENDITURES
384,555.64
658,279.49
86,367.63
744,647.12
4,430,054.00
3,685,406.88
16.8
TOTAL FUND EXPENDITURES
384,555.64
658,279.49
86,367.63
744,647.12
4,430,054.00
3,685,406.88
16.8
264,645.03)
166,356.45
86,367.63)
79,988.82
920,092.82)
9.5
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
(
17 % OF THE FISCAL YEAR HAS ELAPSED
(
840,104.00) (
09/14/2015 06:10PM PAGE:60
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 CANYON CREST SID DSF ASSETS 81-11900 CASH - COMBINED FUND
97,091.25
81-12100 LGIP (MESQSID) - CONSTR FUNDS
383,183.21
81-12500 CASH - WF TRUST#18326100
5,596.13
81-13120 ASSESSMTS REC'BLE-CANYON CREST
2,641,753.67
81-13500 CASH - WF DSRF TRUST#18326101
389,869.36
81-13550 WELLS FARGO-ACCT #804-5040295
253,909.07
TOTAL ASSETS
3,771,402.69
LIABILITIES AND EQUITY
LIABILITIES 81-21450 DEVELOPER DEPOSIT - TOUSA
163,467.73
81-24100 CANYON CREST -CUST OVERPAYMEN
3,542.80
81-25120 DEFERRED REVENUE-CANYON CREST
2,641,753.67
TOTAL LIABILITIES
2,808,764.20
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 81-29800 BEGINNING OF YEAR
1,267,917.99
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
305,279.50) 962,638.49
TOTAL FUND EQUITY
962,638.49
TOTAL LIABILITIES AND EQUITY
FOR ADMINISTRATION USE ONLY
3,771,402.69
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:61
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 CANYON CREST SID DSF PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
SID ASSESSMENT REVENUE 81-31-115 PRINCIPLE ASSESS-CANYON CREST
8,490.02
17,150.88
.00
17,150.88
198,000.00
180,849.12
8.7
81-31-215 INTEREST ASSESS - CANYON CREST
316.04
795.65
.00
795.65
171,500.00
170,704.35
.5
.00
.00
.00
.00
6,500.00
6,500.00
.0
8,806.06
17,946.53
.00
17,946.53
376,000.00
358,053.47
4.8
27.1
81-31-220 INTEREST INC - ASSESSMNT FNDS TOTAL SID ASSESSMENT REVENUE
OTHER SID INCOME 81-38-100 INTEREST INCOME 81-38-120 CANYON CREST - LATE FEES 81-38-125 CANYON CREST - OTHER INCOME TOTAL OTHER SID INCOME
TOTAL FUND REVENUE
FOR ADMINISTRATION USE ONLY
71.25
135.54
.00
135.54
500.00
364.46
.00
103.93
.00
103.93
4,000.00
3,896.07
2.6
86.00
172.00
.00
172.00
3,000.00
2,828.00
5.7
157.25
411.47
.00
411.47
7,500.00
7,088.53
5.5
8,963.31
18,358.00
.00
18,358.00
383,500.00
365,142.00
4.8
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:62
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 CANYON CREST SID DSF PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
SID DEBT SVC EXPENDITURES 81-40-801 BOND PMT- PRIN: CANYON CREST
245,000.00
245,000.00
.00
245,000.00
200,000.00
45,000.00)
122.5
73,887.50
73,887.50
.00
73,887.50
152,388.00
78,500.50
48.5
.00
.00
.00
.00
4,000.00
4,000.00
.0
318,887.50
318,887.50
.00
318,887.50
356,388.00
37,500.50
89.5
81-90-083 TRSFR TO SID ADMIN SRF #83
2,375.00
4,750.00
.00
4,750.00
28,500.00
23,750.00
16.7
TOTAL TRANSFERS
2,375.00
4,750.00
.00
4,750.00
28,500.00
23,750.00
16.7
321,262.50
323,637.50
.00
323,637.50
384,888.00
61,250.50
84.1
312,299.19) (
305,279.50)
.00
1,388.00)
303,891.50
(21994
81-40-803 BOND PMT-INT: CANYON CREST 81-40-850 BNDHOLDER PREPAY PREM TOTAL SID DEBT SVC EXPENDITURES
(
TRANSFERS
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
17 % OF THE FISCAL YEAR HAS ELAPSED
(
305,279.50) (
09/14/2015 06:10PM PAGE:63
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 ANTHEM AT MESQUITE SID DSF ASSETS 82-11900 TOTAL ALLOCATION TO OTHER FUND
(
517,956.65)
82-12000 LGIP (MESQAN) - ADMIN FUND
424,582.65
82-12100 LGIP (MESQAN) - CONST FUNDS
264,919.05
82-12300 CASH- WF DS RESERVE FUND #9301
1,041,124.06
82-13100 SID ASSESSMENTS RECEIVABLE
11,116,229.12
82-13550 WELLS FARGO-ACCT #804-5040295
576,862.21
TOTAL ASSETS
12,905,760.44
LIABILITIES AND EQUITY
LIABILITIES 82-24100 ANTHEM - CUSTOMER OVERPAYMEN
12,348.44
82-25100 DEFERRED REVENUE - ANTHEM SID
11,116,229.12
TOTAL LIABILITIES
11,128,577.56
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 82-29800 BALANCE - BEGINNING OF YEAR
2,594,527.21
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
817,344.33) 1,777,182.88
TOTAL FUND EQUITY
1,777,182.88
TOTAL LIABILITIES AND EQUITY
FOR ADMINISTRATION USE ONLY
12,905,760.44
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:64
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 ANTHEM AT MESQUITE SID DSF PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
SID ASSESSMENT REVENUE 82-31-115 PRINCIPLE ASSESS - ANTHEM
23,635.27
30,250.02
.00
30,250.02
224,000.00
193,749.98
13.5
82-31-215 INTEREST ASSESS - ANTHEM
1,106.89
2,091.65
.00
2,091.65
807,500.00
805,408.35
.3
24,742.16
32,341.67
.00
32,341.67
1,031,500.00
999,158.33
3.1
82-38-100 INTEREST INCOME
131.01
246.69
.00
246.69
850.00
603.31
29.0
82-38-120 ANTHEM - LATE FEES
326.70
931.44
.00
931.44
5,000.00
4,068.56
18.6
82-38-125 ANTHEM - OTHER INCOME
724.12
904.21
.00
904.21
13,000.00
12,095.79
7.0
TOTAL OTHER SID INCOME
1,181.83
2,082.34
.00
2,082.34
18,850.00
16,767.66
11.1
25,923.99
34,424.01
.00
34,424.01
1,050,350.00
1,015,925.99
3.3
TOTAL SID ASSESSMENT REVENUE
OTHER SID INCOME
TOTAL FUND REVENUE
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:65
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 ANTHEM AT MESQUITE SID DSF PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
SID DEBT SVC EXPENDITURES 82-40-801 BOND PMT- PRIN: ANTHEM SID
480,000.00
480,000.00
.00
480,000.00
255,000.00
225,000.00)
188.2
82-40-803 BOND PMT-INT: ANTHEM SID
347,085.00
347,085.00
.00
347,085.00
717,701.00
370,616.00
48.4
4,600.00
4,600.00
.00
4,600.00
10,000.00
5,400.00
46.0
831,685.00
831,685.00
.00
831,685.00
982,701.00
151,016.00
84.6
82-90-083 TRSFR TO SID ADMIN SRF #83
10,041.67
20,083.34
.00
20,083.34
120,500.00
100,416.66
16.7
TOTAL TRANSFERS
10,041.67
20,083.34
.00
20,083.34
120,500.00
100,416.66
16.7
841,726.67
851,768.34
.00
851,768.34
1,103,201.00
251,432.66
77.2
815,802.68) (
817,344.33)
.00
52,851.00)
764,493.33
(1546.
82-40-805 BNDHOLDER PREPAY PREMIUM TOTAL SID DEBT SVC EXPENDITURES
(
TRANSFERS
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
17 % OF THE FISCAL YEAR HAS ELAPSED
(
817,344.33) (
09/14/2015 06:10PM PAGE:66
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 SID ADMINISTRATION FUND ASSETS 83-11900 TOTAL ALLOCATION TO OTHER FUND
318,612.83
TOTAL ASSETS
318,612.83
LIABILITIES AND EQUITY
LIABILITIES 83-21311 BANK SERVICE CHARGES PAYABLE
157.31
TOTAL LIABILITIES
157.31
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 83-29800 BEGINNING OF YEAR
306,900.05
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
11,555.47 318,455.52
TOTAL FUND EQUITY
318,455.52
TOTAL LIABILITIES AND EQUITY
318,612.83
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:67
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 SID ADMINISTRATION FUND PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
TRSFR FROM CANYON CREST SID 83-30-115 TRSFR FROM CANYON CREST SID
2,375.00
4,750.00
.00
4,750.00
28,500.00
23,750.00
16.7
114.22
350.40
.00
350.40
2,800.00
2,449.60
12.5
2,489.22
5,100.40
.00
5,100.40
31,300.00
26,199.60
16.3
10,041.67
20,083.34
.00
20,083.34
120,500.00
100,416.66
16.7
212.12
650.75
.00
650.75
4,000.00
3,349.25
16.3
TOTAL TRSFR FROM ANTHEM SID
10,253.79
20,734.09
.00
20,734.09
124,500.00
103,765.91
16.7
TOTAL FUND REVENUE
12,743.01
25,834.49
.00
25,834.49
155,800.00
129,965.51
16.6
83-30-200 INT INCOME - CANYON CREST TOTAL TRSFR FROM CANYON CREST
TRSFR FROM ANTHEM SID 83-32-115 TRSFR FROM ANTHEM SID 83-32-200 INT INCOME - ANTHEM
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:68
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 SID ADMINISTRATION FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
CANYON CREST ADMIN EXPENSES 83-81-010 CANYON CREST - PROF SVCS
3,039.37
3,039.37
.00
3,039.37
23,000.00
19,960.63
13.2
83-81-110 CANYON CREST - SALARIES
1,723.35
2,504.61
.00
2,504.61
15,921.00
13,416.39
15.7
83-81-130 CANYON CREST - EMPLOYEE BENS
662.25
1,041.99
.00
1,041.99
6,500.00
5,458.01
16.0
83-81-610 SERVICE AND SUPPLIES
301.92
818.30
.00
818.30
4,600.00
3,781.70
17.8
5,726.89
7,404.27
.00
7,404.27
50,021.00
42,616.73
14.8
TOTAL CANYON CREST ADMIN EXPEN
ANTHEM SID ADMIN EXPENSES 83-82-010 ANTHEM - PROFESSION SVCS
2,231.90
2,231.90
.00
2,231.90
38,500.00
36,268.10
5.8
83-82-110 ANTHEM - SALARIES
1,723.35
2,504.61
.00
2,504.61
15,921.00
13,416.39
15.7
83-82-130 ANTHEM - EMPLOYEE BENS
662.20
1,041.93
.00
1,041.93
6,500.00
5,458.07
16.0
83-82-610 ANTHEM - SERVICE & SUPPLIES
420.59
1,096.31
.00
1,096.31
6,700.00
5,603.69
16.4
5,038.04
6,874.75
.00
6,874.75
67,621.00
60,746.25
10.2
10,764.93
14,279.02
.00
14,279.02
117,642.00
103,362.98
12.1
1,978.08
11,555.47
.00
11,555.47
38,158.00
26,602.53
30.3
TOTAL ANTHEM SID ADMIN EXPENSE
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:69
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 G.O. BOND SERIES 2002 ASSETS 85-11900 CASH-COMBINED FUND
1,422,752.14
TOTAL ASSETS
1,422,752.14
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 85-29800 BALANCE - BEGINNING OF YEAR
1,180,096.80
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
242,655.34 1,422,752.14
TOTAL FUND EQUITY
1,422,752.14
TOTAL LIABILITIES AND EQUITY
1,422,752.14
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:70
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 G.O. BOND SERIES 2002 PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
CONTRIBUTIONS AND TRANSFERS 85-39-960 TRANSFER FROM RE-DEV
36,602.17
73,204.34
.00
73,204.34
439,226.00
366,021.66
16.7
85-39-961 TRANSFER FROM G/F
84,725.50
169,451.00
.00
169,451.00
1,016,706.00
847,255.00
16.7
TOTAL CONTRIBUTIONS AND TRANSF
121,327.67
242,655.34
.00
242,655.34
1,455,932.00
1,213,276.66
16.7
TOTAL FUND REVENUE
121,327.67
242,655.34
.00
242,655.34
1,455,932.00
1,213,276.66
16.7
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:71
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 G.O. BOND SERIES 2002 PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
MAINTENANCE/REPAIRS 85-40-813 RDA SERIES 2012 DEBT SVC -PRIN
.00
.00
.00
.00
377,100.00
377,100.00
.0
85-40-814 RDA SERIES 2014 DEBT SVC-PRIN
.00
.00
.00
.00
805,000.00
805,000.00
.0
85-40-824 RDA SERIES 2012 - DEBT SVC INT
.00
.00
.00
.00
62,126.00
62,126.00
.0
85-40-825 RDA SERIES 2014 - DEBT SVC INT
.00
.00
.00
.00
211,706.00
211,706.00
.0
TOTAL MAINTENANCE/REPAIRS
.00
.00
.00
.00
1,455,932.00
1,455,932.00
.0
TOTAL FUND EXPENDITURES
.00
.00
.00
.00
1,455,932.00
1,455,932.00
.0
121,327.67
242,655.34
.00
242,655.34
.00
242,655.34)
.0
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
(
09/14/2015 06:10PM PAGE:72
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 WASTE DISPOSAL D/S FUND ASSETS 87-11900 CASH - COMBINED FUND
87,374.82
TOTAL ASSETS
87,374.82
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 87-29800 BALANCE - BEGINNING OF YEAR
93,616.17
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
6,241.35) 87,374.82
TOTAL FUND EQUITY
87,374.82
TOTAL LIABILITIES AND EQUITY
87,374.82
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:73
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 WASTE DISPOSAL D/S FUND PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
CONTRIBUTIONS AND TRANSFERS 87-39-960 TRANSFER FROM G/F
6,241.25
12,482.50
.00
12,482.50
74,895.00
62,412.50
16.7
TOTAL CONTRIBUTIONS AND TRANSF
6,241.25
12,482.50
.00
12,482.50
74,895.00
62,412.50
16.7
TOTAL FUND REVENUE
6,241.25
12,482.50
.00
12,482.50
74,895.00
62,412.50
16.7
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:74
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 WASTE DISPOSAL D/S FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
EXPENDITURES 87-40-810 PRINCIPAL EXPENSE
.00
11,435.00
.00
11,435.00
46,648.00
35,213.00
24.5
87-40-820 INTEREST EXPENSE
.00
7,288.85
.00
7,288.85
28,247.00
20,958.15
25.8
TOTAL EXPENDITURES
.00
18,723.85
.00
18,723.85
74,895.00
56,171.15
25.0
TOTAL FUND EXPENDITURES
.00
18,723.85
.00
18,723.85
74,895.00
56,171.15
25.0
6,241.35)
.00
6,241.35)
.00
6,241.35
.0
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
6,241.25
(
17 % OF THE FISCAL YEAR HAS ELAPSED
(
09/14/2015 06:10PM PAGE:75
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 TRUST & AGENCY FUND ASSETS 90-11310 PETTY CASH - JAIL COMMISSARY
100.00
90-11320 BANK OF NEVADA
(
90-11900 CASH AND COMBINED FUND
6,373.44) 616,496.19
TOTAL ASSETS
610,222.75
LIABILITIES AND EQUITY
LIABILITIES 90-26100 CONTRACTOR DEPOSIT
581,146.18
90-26103 VETERANS MEMORIAL DEPOSITS
216.51
90-26105 POLICE YOUTH PROGRAMS
1,315.22
90-26109 MESQUITE NARCOTICS TASK FORCE
(
16,473.44)
90-26110 ASSET FORFEITURE TASK FORCE
(
13,728.69)
90-26113 INMATE COMMISSARY FUND 90-26115 VETERANS DAY PARADE 90-26117 POLICE - GRAD NITE OUT PARTY 90-26118 POLICE - SHOP W/ A COP 90-26119 POLICE - NAT'L NIGHT OUT
10,732.38 66.50 3,683.60 23,227.32 3,000.00
90-26121 POLICE DEPT DONATIONS
663.09
90-26122 MESQUITE ENERGY FAIR
785.59
90-26124 COMMUNITY THEATRE - R&M 90-26125 SCENIC COMM TOWER R&M FUND 90-26126 HERITAGE MUSEUM DONATIONS 90-26127 CERT PGM CONTRIBS / EXPESNSES 90-26128 LEASES - SECURITY DEPOSITS
814.92 9,000.00 614.76 58.81 5,100.00
TOTAL LIABILITIES
610,222.75
TOTAL FUND EQUITY
.00
TOTAL LIABILITIES AND EQUITY
FOR ADMINISTRATION USE ONLY
610,222.75
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:76
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 GENERAL FIXED ASSETS ASSETS 91-16110 LAND
12,876,471.69
91-16210 BUILDINGS & IMPROVEMENTS
48,332,981.86
91-16310 IMPROVE.OTHER THAN BUILDINGS
23,742,421.42
91-16410 OFFICE FURNITURE AND EQUIPMENT
8,892,882.80
91-16610 AUTOMOBILES AND TRUCKS
7,041,837.24
91-16620 WORK IN PROGRESS
2,310,503.79
91-16710 STORM DRAINS & INLETS
12,514,633.95
91-16810 STREETS & SIDEWALKS
94,362,885.94
TOTAL ASSETS
210,074,618.69
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 91-29800 BEGINNING OF YEAR
205,033,677.25
91-29850 ADDITIONS - CURRENT YEAR
5,040,941.44
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
210,074,618.69
TOTAL FUND EQUITY
210,074,618.69
TOTAL LIABILITIES AND EQUITY
210,074,618.69
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:77
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 TECHNOLOGY RES/REPLACMNT FUND ASSETS 98-11900 CASH - COMBINED FUND
115,664.86
TOTAL ASSETS
115,664.86
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 98-29800 BALANCE - BEGINNING OF YEAR
156,438.52
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
40,773.66) 115,664.86
TOTAL FUND EQUITY
115,664.86
TOTAL LIABILITIES AND EQUITY
115,664.86
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:78
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 TECHNOLOGY RES/REPLACMNT FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
DEPARTMENT 40 98-40-047 IT - TECHNOLOGY EXPENDITURES
40,773.66
40,773.66
26,478.17
67,251.83
77,000.00
9,748.17
87.3
TOTAL DEPARTMENT 40
40,773.66
40,773.66
26,478.17
67,251.83
77,000.00
9,748.17
87.3
TOTAL FUND EXPENDITURES
40,773.66
40,773.66
26,478.17
67,251.83
77,000.00
9,748.17
87.3
40,773.66) (
40,773.66)
26,478.17) (
67,251.83) (
77,000.00) (
9,748.17)
( 87.3)
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
(
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:79
CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 VEHICLE/EQUIP REPLACEMNT FUND ASSETS 99-11900 CASH - COMBINED FUND
701,309.75
TOTAL ASSETS
701,309.75
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 99-29800 BALANCE - BEGINNING OF YEAR
701,309.75
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
701,309.75
TOTAL FUND EQUITY
701,309.75
TOTAL LIABILITIES AND EQUITY
701,309.75
FOR ADMINISTRATION USE ONLY
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:80
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 VEHICLE/EQUIP REPLACEMNT FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
CAPITAL EXPENDITURES 99-40-054 POLICE
.00
.00
.00
.00
129,074.00
129,074.00
.0
99-40-076 PARKS & GROUNDS MAINTENANCE
.00
.00
21,525.36
21,525.36
25,000.00
3,474.64
86.1
TOTAL CAPITAL EXPENDITURES
.00
.00
21,525.36
21,525.36
154,074.00
132,548.64
14.0
TOTAL FUND EXPENDITURES
.00
.00
21,525.36
21,525.36
154,074.00
132,548.64
14.0
NET REVENUE OVER EXPENDITURES
.00
.00
21,525.36) (
21,525.36) (
154,074.00) (
132,548.64) ( 14.0)
FOR ADMINISTRATION USE ONLY
(
17 % OF THE FISCAL YEAR HAS ELAPSED
09/14/2015 06:10PM PAGE:81