CITY OF MESQUITE COMBINED CASH INVESTMENT JULY 31, 2017 COMBINED CASH ACCOUNTS 01-11120 CASH - WELLS FARGO CHECKING
3,242,018.85
01-11210 XPRESS DEPOSIT ACCOUNT
388,022.72
01-11310 CASH - PETTY CASH
1,810.00
01-11400 RETURNED CHECKS - CLEARING
81.16
01-11560 WELLS FARGO INVEST A/C
21,987,575.29
01-11750 CASH CLEARING - UTILITY
81.18
TOTAL COMBINED CASH
25,619,589.20
01-11900 TOTAL ALLOCATION TO OTHER FUND
TOTAL UNALLOCATED CASH
( 25,619,608.02)
(
18.82)
CASH ALLOCATION RECONCILIATION 10 ALLOCATION TO GENERAL FUND
7,135,915.16
11 ALLOCATION TO STREET MAINT. SPE
3,367,281.98
12 ALLOCATION TO AIRPORT SPECIAL R
10,973.75
13 ALLOCATION TO CAP. PROJ. MAINT/R
630,342.41
14 ALLOCATION TO POLICE FORFEITURE
121,914.99
15 ALLOCATION TO COURT ADMINISTRA
135,884.31
16 ALLOCATION TO SR. NUTRITION PRO
88,867.40
17 ALLOCATION TO RECREATION PROGR
222,988.26
19 ALLOCATION TO FORENSIC SERVICES
2,264.33
20 ALLOCATION TO RESID. CONSTR. TAX
1,380,684.00
21 ALLOCATION TO ENVIR. PLANNING SP
545,647.31
22 ALLOCATION TO TRANSPORTATION I 23 ALLOCATION TO MORE COPS SRF
2,080,169.91 (
74,980.71)
25 ALLOCATION TO REDEVELOPMENT DI
4,430,594.10
43 ALLOCATION TO CITY MARKETING SR
269,166.73
44 ALLOCATION TO ECONOMIC DEVELO
147,335.73
45 ALLOCATION TO CAPITAL PROJECT F
123,585.68
52 ALLOCATION TO SEWER FUND
2,745,520.52
81 ALLOCATION TO CANYON CREST SID 82 ALLOCATION TO ANTHEM AT MESQUI
83,926.26 (
599,600.05)
83 ALLOCATION TO SID ADMINISTRATIO
385,400.78
85 ALLOCATION TO G.O. BOND SERIES 20
1,264,773.94
90 ALLOCATION TO TRUST & AGENCY F
369,361.42
97 ALLOCATION TO CITY SERVICES RESE
321,000.00
99 ALLOCATION TO VEHICLE/EQUIP REP
430,589.81
TOTAL ALLOCATIONS TO OTHER FUN
25,619,608.02
ALLOCATION FROM COMBINED CASH
( 25,619,608.02)
ZERO PROOF IF ALLOCATIONS BALAN
FOR ADMINISTRATION USE ONLY
.00
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:14AM PAGE:1
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 GENERAL FUND ASSETS 10-11900 CASH - COMBINED FUND
7,135,915.16
10-13100 DUE FROM STATE
613,692.58
10-13105 DUE FROM CLARK COUNTY
121,197.71
10-13106 ROOM TAXES A/R
37,809.87
10-13107 OTHER RECEIVABLES
148,580.89
10-14000 PREPAID EXPENSE
201,567.60
TOTAL ASSETS
8,258,763.81
LIABILITIES AND EQUITY
LIABILITIES 10-21310 ACCOUNTS PAYABLE
847,092.38
10-21311 BANK SERVICE CHARGES PAYABLE
5,821.68
10-21500 WAGES PAYABLE
332,169.99
10-21700 UNION DUES W/H-REGULAR EE'S
3,196.00
10-21705 UNION DUES W/H POLICE
1,152.00
10-21710 UNION DUES W/H FIRE/RESCUE
220.00
10-22210 FICA PAYABLE
15,500.46
10-22220 WITHHELD INCOME TAXES
42,622.60
10-22250 WORKERS COMP PAYABLE
(
10-22300 ACCRUED STATE RETIREMENT
42,740.00) 354,654.23
10-22400 VOLUNTARY LIFE INSURANCE W/H
946.10
10-22410 VOLUNTARY CANCER INSURANCE W/
389.26
10-22500 HEALTH INSURANCE PAYABLE
(
19,530.05)
10-22520 FLEX SPEND INSURANCE W/H
7,947.72
10-22530 SUPPLMENTAL VOL INSURANCE W/H
1,453.00
10-22540 VOLUNTARY W/H - LEGAL SHIELD
111.65
10-22600 DEFERRED COMP - NATIONWIDE
7,742.80
10-22610 DEFERRED COMP - VOYA / ING
1,835.00
10-22620 DEFERRED COMP - ALTA (403/457)
5,161.00
10-23100 GAMING TAX FOR CONV. AUTH.
5,782.50
10-23110 RM TXS COLL. FOR CONV AUTH 5/8
81,239.38
10-23115 LVCVA 0.5% ROOM TAX RATE INCR
10,154.92
10-23130 TRANSIENT LODGING TRANSPORT.
20,309.85
10-23140 ROOM TAXES FOR SCHOOLS
33,003.47
10-23220 TORTOISE FEES ST.COLLECTIONS
3,010.00
10-23240 COUNTY-TRANSPORT. DEVEL. FEES
25,022.00
10-24100 GARNISHMENTS W/H
618.63
TOTAL LIABILITIES
1,744,886.57
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 10-29800 BALANCE - BEGINNING OF YEAR
4,711,158.18
10-29810 RESERVE - RESOLUTION #777
2,013,257.00
10-29825 RESERVE - REC FEE INCREMENT
2,211.12
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
212,749.06) 6,513,877.24
TOTAL FUND EQUITY
FOR ADMINISTRATION USE ONLY
6,513,877.24
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:14AM PAGE:2
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 GENERAL FUND
TOTAL LIABILITIES AND EQUITY
FOR ADMINISTRATION USE ONLY
8,258,763.81
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:14AM PAGE:3
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 GENERAL FUND PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
TAXES 10-31-100 PROPERTY TAXES
.00
.00
.00
.00
3,360,000.00
3,360,000.00
.0
10-31-110 ROAD RTC ROOM TAX
37,809.85
37,809.85
.00
37,809.85
237,500.00
199,690.15
15.9
10-31-200 ROOM TAXES
75,619.70
75,619.70
.00
75,619.70
475,000.00
399,380.30
15.9
TOTAL TAXES
113,429.55
113,429.55
.00
113,429.55
4,072,500.00
3,959,070.45
2.8
LICENSES AND PERMITS 10-32-100 BUSINESS LICENSES
45,917.00
45,917.00
.00
45,917.00
530,000.00
484,083.00
8.7
10-32-102 MASSAGE PERMITS
.00
.00
.00
.00
1,500.00
1,500.00
.0
10-32-105 MEDICAL MARIJUANA LICENSE FEES
.00
.00
.00
.00
240,000.00
240,000.00
.0
10-32-110 LIQUOR LICENSES
47,950.00
47,950.00
.00
47,950.00
150,000.00
102,050.00
32.0
10-32-120 GAMING LICENSES
167,450.00
167,450.00
.00
167,450.00
335,000.00
167,550.00
50.0
150.00
150.00
.00
150.00
4,500.00
4,350.00
3.3
81,155.29
81,155.29
.00
81,155.29
708,000.00
626,844.71
11.5
10-32-160 VACATION RENTAL LICENSE 10-32-200 BUILDING PERMITS 10-32-300 ANIMAL CONTROL FEES
1,198.00
1,198.00
.00
1,198.00
13,000.00
11,802.00
9.2
10-32-500 ZONE VARIANCE FEES
620.00
620.00
.00
620.00
9,000.00
8,380.00
6.9
10-32-505 PLAN REVIEW FEES
800.00
800.00
.00
800.00
25,000.00
24,200.00
3.2
10-32-605 FRANCHISE FEES - TELEPHONE SVC
.00
.00
.00
.00
91,000.00
91,000.00
.0
10-32-615 FRANCHISE FEES - CABLE SVCS
.00
.00
.00
.00
100,000.00
100,000.00
.0
TOTAL LICENSES AND PERMITS
345,240.29
345,240.29
.00
345,240.29
2,207,000.00
1,861,759.71
15.6
10-33-140 LVCVA - ROOM & GAMING TAXES
.00
.00
.00
.00
860,800.00
860,800.00
.0
10-33-231 OTHER GRANTS (FIRE)
.00
.00
.00
.00
28,000.00
28,000.00
.0
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
57,000.00
57,000.00
.0
9,375.00
9,375.00
.00
9,375.00
.00
9,375.00)
.0
10-33-250 COUNTY GAMING LICENSES
.00
.00
.00
.00
315,000.00
315,000.00
.0
10-33-460 STATE CONSOLIDATED TAX
610,000.00
610,000.00
.00
610,000.00
8,120,000.00
7,510,000.00
7.5
INTERGOVERNMENTAL REVENUE
10-33-245 COUNTY OAG GRANTS (PD)
10-33-520 SILVER RIDER FUEL / R&M REIMB.
7,426.53)
.00
7,426.53)
83,000.00
90,426.53
10-33-550 SPECIAL AD VALOREM TRANS. TAX
.00
.00
.00
.00
74,500.00
74,500.00
.0
10-33-590 INTERLOCAL LANCSCAPE MAINT
.00
.00
.00
.00
18,000.00
18,000.00
.0
10-33-600 REGIONAL FLOOD CONTROL, CL.CO.
.00
.00
.00
.00
334,800.00
334,800.00
.0
611,948.47
611,948.47
.00
611,948.47
9,921,100.00
9,309,151.53
6.2
TOTAL INTERGOVERNMENTAL REVE
FOR ADMINISTRATION USE ONLY
(
7,426.53)
(
8 % OF THE FISCAL YEAR HAS ELAPSED
(
(
09/13/2017 11:14AM PAGE:4
(
9.0)
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 GENERAL FUND PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
CHARGES FOR SERVICES 10-34-100 CEMETERY CHARGE AND SALES
3,720.00
3,720.00
.00
3,720.00
25,000.00
21,280.00
14.9
10-34-200 PD - OTHER SERVICE FEES
.00
.00
.00
.00
3,500.00
3,500.00
.0
10-34-205 BEAVER DAM DISPATCH SVC MOU
.00
.00
.00
.00
47,300.00
47,300.00
.0
222.50
222.50
.00
222.50
.00
5,000.00
5,000.00
.00
5,000.00
5,000.00
325.25
325.25
.00
325.25
75,000.00
74,674.75
.4
20,613.00
20,613.00
.00
20,613.00
204,000.00
183,387.00
10.1
10-34-300 PD - JAIL SERVICES 10-34-305 PD - COURT BAILIFF SERVICES 10-34-310 PD: INMATE HOUSING (NEW FY16) 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
(
(
222.50)
.0
.00
100.0
3,335.00
3,335.00
.00
3,335.00
24,000.00
20,665.00
13.9
73,511.20
73,511.20
.00
73,511.20
1,000,000.00
926,488.80
7.4
225.00
225.00
.00
225.00
13,000.00
12,775.00
1.7
260,234.43
260,234.43
.00
260,234.43
1,073,500.00
813,265.57
24.2
3,742.60
3,742.60
.00
3,742.60
15,000.00
11,257.40
25.0
28,237.01
28,237.01
.00
28,237.01
115,800.00
87,562.99
24.4
.00
.00
.00
.00
388,500.00
388,500.00
.0
1,090.69)
.00
1,090.69)
1,500.00
2,590.69
( 72.7)
1,090.69)
(
(
10-34-660 SPECIAL EVENT FEES
35.00
35.00
.00
35.00
1,200.00
1,165.00
2.9
10-34-700 MUSEUM MISC. FEES
490.58
490.58
.00
490.58
5,200.00
4,709.42
9.4
398,600.88
398,600.88
.00
398,600.88
2,997,500.00
2,598,899.12
13.3
24,785.08
24,785.08
.00
24,785.08
300,000.00
275,214.92
8.3
250.00
250.00
.00
250.00
2,500.00
2,250.00
10.0
25,035.08
25,035.08
.00
25,035.08
302,500.00
277,464.92
8.3
10-36-120 SALES OF ASSETS
.00
.00
.00
.00
7,000.00
7,000.00
.0
10-36-510 SPORTS MARKETING REVENUE
.00
.00
.00
.00
5,000.00
5,000.00
.0
.00
.00
.00
.00
12,000.00
12,000.00
.0
14,575.07
14,575.07
.00
14,575.07
150,000.00
135,424.93
9.7
831.76
831.76
.00
831.76
10,000.00
9,168.24
8.3
.00
.00
.00
.00
1,500.00
1,500.00
.0
1,872.00
1,872.00
.00
1,872.00
22,450.00
20,578.00
8.3
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
TOTAL MISCELLANEOUS REVENUE
OTHER REVENUE 10-38-100 INTEREST EARNINGS 10-38-200 SIGN RENTAL 10-38-230 FIRE / AMB COMMUNITY TRAINING 10-38-700 CITY FACILITIES RENTAL FEES 10-38-701 CITY RENTAL EXPENSES
813.94)
.00
10-38-710 COURT FACILITY RENTAL
3,025.19
3,025.19
.00
3,025.19
37,500.00
34,474.81
8.1
10-38-720 LEASEHOLD REVENUE
7,094.02
7,094.02
.00
7,094.02
90,000.00
82,905.98
7.9
236.40
236.40
.00
236.40
2,500.00
2,263.60
9.5
26,820.50
26,820.50
.00
26,820.50
289,950.00
263,129.50
9.3
10-38-900 MISCELLANEOUS REVENUE TOTAL OTHER REVENUE
FOR ADMINISTRATION USE ONLY
(
813.94)
(
8 % OF THE FISCAL YEAR HAS ELAPSED
(
813.94)
(
24,000.00)
(
23,186.06)
09/13/2017 11:15AM PAGE:5
(
3.4)
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 GENERAL FUND PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
CONTRIBUTIONS AND TRANSFERS 10-39-919 TRSFR FROM #19 FORENSIC SVCS 10-39-925 TRSFR FROM #25 REDEVELOPMENT TOTAL CONTRIBUTIONS AND TRANSF
TOTAL FUND REVENUE
FOR ADMINISTRATION USE ONLY
291.67
291.67
.00
291.67
3,500.00
3,208.33
8.3
84,731.08
84,731.08
.00
84,731.08
1,016,773.00
932,041.92
8.3
85,022.75
85,022.75
.00
85,022.75
1,020,273.00
935,250.25
8.3
1,606,097.52
1,606,097.52
.00
1,606,097.52
20,822,823.00
19,216,725.48
7.7
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:15AM PAGE:6
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 GENERAL FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
MAYOR & COUNCIL 10-41-110 SALARIES
8,201.86
8,201.86
.00
8,201.86
96,479.00
88,277.14
8.5
10-41-113 LONGEVITY PAY
.00
.00
.00
.00
225.00
225.00
.0
10-41-120 OVERTIME
.00
.00
.00
.00
125.00
125.00
.0
10-41-130 EMPLOYEE BENEFITS
7,165.53
7,165.53
.00
7,165.53
103,020.87
95,855.34
7.0
10-41-210 BOOKS, SUBSCRIPTIONS & MEMBERS
8,820.77
8,820.77
.00
8,820.77
18,200.00
9,379.23
48.5
362.55
362.55
.00
362.55
17,000.00
16,637.45
2.1
.00
.00
.00
.00
1,000.00
1,000.00
.0
244.48
244.48
.00
244.48
3,550.00
3,305.52
6.9
17,500.00
17,500.00
.00
17,500.00
65,000.00
47,500.00
26.9
48.10
48.10
.00
48.10
4,500.00
4,451.90
1.1
10-41-620 MISCELLANEOUS SERVICE
.00
.00
.00
.00
3,000.00
3,000.00
.0
TOTAL MAYOR & COUNCIL
42,343.29
42,343.29
.00
42,343.29
312,099.87
269,756.58
13.6
12,900.32
12,900.32
.00
12,900.32
156,216.00
143,315.68
8.3
4,563.94
4,563.94
.00
4,563.94
9,138.00
4,574.06
49.9
10-43-113 LONGEVITY PAY
.00
.00
.00
.00
1,019.00
1,019.00
.0
10-43-120 OVERTIME
.00
.00
.00
.00
125.00
125.00
.0
10-43-130 EMPLOYEE BENEFITS
5,359.79
5,359.79
.00
5,359.79
65,482.93
60,123.14
8.2
10-43-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 10-41-610 MISCELLANEOUS SUPPLIES
CITY MANAGER 10-43-110 SALARIES 10-43-112 VAC/SICK BUYOUT
1,054.00
1,054.00
.00
1,054.00
1,600.00
546.00
65.9
10-43-230 TRAVEL & TRAINING
.00
.00
.00
.00
3,200.00
3,200.00
.0
10-43-240 OFFICE EXPENSE & SUPPLIES
.00
.00
.00
.00
500.00
500.00
.0
101.12
101.12
.00
101.12
1,230.00
1,128.88
8.2
18.00
18.00
.00
18.00
2,000.00
1,982.00
.9
23,997.17
23,997.17
.00
23,997.17
240,510.93
216,513.76
10.0
10-44-110 SALARIES
5,391.49
5,391.49
.00
5,391.49
65,754.00
60,362.51
8.2
10-44-130 EMPLOYEE BENEFITS
2,364.95
2,364.95
.00
2,364.95
32,870.24
30,505.29
7.2
.00
.00
.00
.00
500.00
500.00
.0
184.35
184.35
.00
184.35
6,500.00
6,315.65
2.8
10-43-290 TELEPHONE 10-43-610 MISCELLANEOUS SUPPLIES TOTAL CITY MANAGER
CITY CLERK
10-44-210 BOOKS, SUBSCRIPTIONS & MEMBERS 10-44-220 PUBLIC NOTICES 10-44-240 OFFICE EXPENSE & SUPPLIES 10-44-310 PROFESSIONAL & TECHNICAL SVCS TOTAL CITY CLERK
FOR ADMINISTRATION USE ONLY
14.83
14.83
.00
14.83
1,100.00
1,085.17
1.4
1,813.12
1,813.12
.00
1,813.12
8,075.00
6,261.88
22.5
9,768.74
9,768.74
.00
9,768.74
114,799.24
105,030.50
8.5
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:15AM PAGE:7
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 GENERAL FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
FINANCE 10-46-110 SALARIES
14,493.18
14,493.18
.00
14,493.18
187,998.00
173,504.82
7.7
10-46-112 VAC/SICK BUYOUT
.00
.00
.00
.00
12,000.00
12,000.00
.0
10-46-113 LONGEVITY PAY
.00
.00
.00
.00
1,020.00
1,020.00
.0
5,199.09
5,199.09
.00
5,199.09
94,101.32
88,902.23
5.5
10-46-210 BOOKS, SUBSCRIPTIONS & MEMBERS
170.00
170.00
.00
170.00
500.00
330.00
34.0
10-46-230 TRAVEL & TRAINING
900.00
900.00
.00
900.00
2,000.00
1,100.00
45.0
.00
.00
.00
.00
1,350.00
1,350.00
.0
595.83
595.83
.00
595.83
99,000.00
98,404.17
.6
21,358.10
21,358.10
.00
21,358.10
397,969.32
376,611.22
5.4
10-46-130 EMPLOYEE BENEFITS
10-46-240 OFFICE EXPENSE & SUPPLIES 10-46-310 PROFFESSIONAL & TECHNICAL SVCS TOTAL FINANCE
INFORMATION TECHNOLOGY 10-47-110 SALARIES
24,561.01
24,561.01
.00
24,561.01
284,380.00
259,818.99
8.6
10-47-112 VAC/SICK BUYOUT
.00
.00
.00
.00
14,601.00
14,601.00
.0
10-47-113 LONGEVITY PAY
.00
.00
.00
.00
5,325.00
5,325.00
.0
10-47-130 EMPLOYEE BENEFITS
11,270.53
11,270.53
.00
11,270.53
139,333.94
128,063.41
8.1
10-47-230 TRAVEL & TRAINING
1,497.00
1,497.00
.00
1,497.00
10,000.00
8,503.00
15.0
365.57
365.57
.00
365.57
10,000.00
9,634.43
3.7
15,946.90
15,946.90
14,550.00
30,496.90
37,000.00
6,503.10
82.4
10-47-240 OFFICE EXPENSE & SUPPLIES 10-47-260 EQUIPMENT (NON CAPITALIZED) 10-47-290 TELEPHONE 10-47-310 PROFFESSIONAL & TECHNICAL SVCS 10-47-740 CAPITAL OUTLAY TOTAL INFORMATION TECHNOLOGY
212.63
212.63
.00
212.63
2,500.00
2,287.37
8.5
239,835.86
239,835.86
4,950.00
244,785.86
391,600.00
146,814.14
62.5
.00
.00
.00
.00
69,000.00
69,000.00
.0
293,689.50
293,689.50
19,500.00
313,189.50
963,739.94
650,550.44
32.5
PERSONNEL 10-48-110 SALARIES
5,905.90
5,905.90
.00
5,905.90
74,041.00
68,135.10
8.0
10-48-112 VAC/SICK BUYOUT
.00
.00
.00
.00
7,515.00
7,515.00
.0
10-48-113 LONGEVITY PAY
.00
.00
.00
.00
1,875.00
1,875.00
.0
2,817.94
2,817.94
.00
2,817.94
36,093.13
33,275.19
7.8
10-48-130 EMPLOYEE BENEFITS 10-48-210 BOOKS, SUBSCRIPTIONS & MEMBERS
972.00
972.00
.00
972.00
1,600.00
628.00
60.8
10-48-220 PUBLIC NOTICES
.00
.00
.00
.00
1,000.00
1,000.00
.0
10-48-230 TRAVEL & TRAINING
.00
.00
.00
.00
300.00
300.00
.0
48.04
48.04
.00
48.04
300.00
251.96
16.0
10-48-240 OFFICE EXPENSE & SUPPLIES 10-48-290 TELEPHONE
51.12
51.12
.00
51.12
650.00
598.88
7.9
18,619.65
18,619.65
.00
18,619.65
22,200.00
3,580.35
83.9
10-48-620 PERSONNEL COSTS
.00
.00
.00
.00
860.00
860.00
.0
TOTAL PERSONNEL
28,414.65
28,414.65
.00
28,414.65
146,434.13
118,019.48
19.4
10-48-310 PROFESSIONAL & TECHNICAL SVCS
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:15AM PAGE:8
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 GENERAL FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
NON-DEPARTMENTAL 10-49-130 BENEFITS ADJUSTMENT
846.37
846.37
.00
846.37
10,350.00
9,503.63
8.2
10-49-240 OFFICE EXPENSE & SUPPLIES
2,131.04
2,131.04
.00
2,131.04
7,500.00
5,368.96
28.4
10-49-250 EQUIPMENT SUPPLIES & MAINT NC
4,619.56
4,619.56
.00
4,619.56
50,000.00
45,380.44
9.2
10-49-270 UTILITIES (CITY SANITATION)
1,227.72
1,227.72
.00
1,227.72
5,000.00
3,772.28
24.6
.00
.00
.00
.00
41,000.00
41,000.00
.0
1,475.00
1,475.00
.00
1,475.00
14,500.00
13,025.00
10.2
10-49-281 UTILITIES - ELECTRICITY 10-49-282 UTILITIES - WATER 10-49-290 TELEPHONE
2,073.87
2,073.87
.00
2,073.87
21,500.00
19,426.13
9.7
10-49-510 INSURANCE
23,557.00
23,557.00
.00
23,557.00
290,000.00
266,443.00
8.1
3,650.00
3,650.00
.00
3,650.00
43,800.00
40,150.00
8.3
91.67
91.67
.00
91.67
1,100.00
1,008.33
8.3
800.00
800.00
.00
800.00
9,600.00
8,800.00
8.3
1,672.72
1,672.72
.00
1,672.72
16,000.00
14,327.28
10.5
42,144.95
42,144.95
.00
42,144.95
510,350.00
468,205.05
8.3
22,806.66
22,806.66
.00
22,806.66
264,470.00
241,663.34
8.6
.00
.00
.00
.00
1,650.00
1,650.00
.0
393.05
393.05
.00
393.05
.00
9,015.94
9,015.94
.00
9,015.94
10-50-210 BOOKS, SUBSCRIPTIONS & MEMBERS
306.98
306.98
.00
10-50-230 TRAVEL & TRAINING
286.00
286.00
.00
10-50-240 OFFICE EXPENSE & SUPPLIES
277.86
277.86
10-50-290 TELEPHONE
343.02 .00
10-49-691 DISTR EXP: FACILITIES MAINT 10-49-692 DIST EXP: SOLID WASTE 10-49-693 DIST EXP: VEHICLE MAINT 10-49-695 BANK/ CREDIT CARD CHARGES TOTAL NON-DEPARTMENTAL
CITY ATTORNEY 10-50-110 SALARIES 10-50-113 LONGEVITY PAY 10-50-120 OVERTIME 10-50-130 EMPLOYEE BENEFITS
10-50-310 PROFESSIONAL & TECHNICAL SVCS TOTAL CITY ATTORNEY
(
393.05)
.0
111,251.22
102,235.28
8.1
306.98
9,772.00
9,465.02
3.1
286.00
9,000.00
8,714.00
3.2
.00
277.86
2,200.00
1,922.14
12.6
343.02
.00
343.02
1,250.00
906.98
27.4
.00
.00
.00
88,900.00
88,900.00
.0
33,429.51
33,429.51
.00
33,429.51
488,493.22
455,063.71
6.8
JUDICIAL / MUNICIPAL COURT 10-51-110 SALARIES
14,499.24
14,499.24
.00
14,499.24
199,098.00
184,598.76
7.3
10-51-112 VAC/SICK BUYOUT
.00
.00
.00
.00
11,324.00
11,324.00
.0
10-51-113 LONGEVITY PAY
.00
.00
.00
.00
6,650.00
6,650.00
.0
10-51-120 OVERTIME
.00
.00
.00
.00
1,200.00
1,200.00
.0
7,040.75
7,040.75
.00
7,040.75
96,705.81
89,665.06
7.3
.00
.00
.00
.00
100.00
100.00
.0
221.56
221.56
.00
221.56
2,800.00
2,578.44
7.9
10-51-130 EMPLOYEE BENEFITS 10-51-210 BOOKS, SUBSCRIPTIONS & MEMBERS 10-51-240 OFFICE EXPENSE & SUPPLIES 10-51-290 TELEPHONE 10-51-310 PROFESSIONAL & TECHNICAL SVCS 10-51-610 MISCELLANEOUS SUPPLIES 10-51-691 DISTR EXP: FACILITIES MAINT 10-51-695 BANK / CREDIT CARD CHARGES TOTAL JUDICIAL / MUNICIPAL COURT
FOR ADMINISTRATION USE ONLY
30.67
30.67
.00
30.67
450.00
419.33
6.8
1,029.27
1,029.27
.00
1,029.27
45,000.00
43,970.73
2.3
.00
.00
.00
.00
750.00
750.00
.0
225.00
225.00
.00
225.00
2,700.00
2,475.00
8.3
.00
.00
.00
.00
5,000.00
5,000.00
.0
23,046.49
23,046.49
.00
23,046.49
371,777.81
348,731.32
6.2
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:15AM PAGE:9
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 GENERAL FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
POLICE 10-54-110 SALARIES 10-54-112 VAC/SICK BUYOUT 10-54-113 LONGEVITY PAY 10-54-115 UNIFORM ALLOWANCE
165,075.66
165,075.66
.00
165,075.66
1,977,840.00
1,812,764.34
.00
.00
.00
.00
109,281.00
109,281.00
8.4 .0
2,050.00
2,050.00
.00
2,050.00
37,500.00
35,450.00
5.5
.00
.00
.00
.00
44,000.00
44,000.00
.0
2,250.00
2,250.00
.00
2,250.00
13,650.00
11,400.00
16.5
10-54-120 OVERTIME
16,519.32
16,519.32
.00
16,519.32
80,000.00
63,480.68
20.7
10-54-130 EMPLOYEE BENEFITS
96,933.20
96,933.20
.00
96,933.20
1,187,755.13
1,090,821.93
8.2
.00
.00
.00
.00
1,500.00
1,500.00
.0
3,642.00
3,642.00
.00
3,642.00
75,000.00
71,358.00
4.9
10-54-116 EDUCATION ASSISTANCE PAY
10-54-210 BOOKS, SUBSCRIPTIONS & MEMBERS 10-54-230 TRAVEL & TRAINING 10-54-240 OFFICE EXPENSES & SUPPLIES
848.09
848.09
.00
848.09
10,200.00
9,351.91
8.3
4,131.50
4,131.50
.00
4,131.50
52,200.00
48,068.50
7.9
10-54-260 EQUIPMENT (NON-CAPITALIZED)
.00
.00
.00
.00
11,750.00
11,750.00
.0
10-54-281 UTILITIES - ELECTRICITY
.00
.00
.00
.00
63,000.00
63,000.00
.0
334.00
334.00
.00
334.00
6,000.00
5,666.00
5.6
1,107.80
1,107.80
.00
1,107.80
4,450.00
3,342.20
24.9
56.12
56.12
.00
56.12
750.00
693.88
7.5
10-54-290 TELEPHONE
2,448.60
2,448.60
.00
2,448.60
35,700.00
33,251.40
6.9
10-54-310 PROFESSIONAL & TECHNICAL SVCS
3,320.22
3,320.22
.00
3,320.22
50,665.00
47,344.78
6.6
450.00
450.00
.00
450.00
16,175.00
15,725.00
2.8
2,232.36
2,232.36
6,480.00
8,712.36
74,650.00
65,937.64
11.7
.00
.00
.00
.00
1,750.00
1,750.00
.0
1,508.33
1,508.33
.00
1,508.33
18,100.00
16,591.67
8.3
10-54-250 EQUIPMENT SUPPLIES & MAIN NC
10-54-282 UTILITIES - WATER 10-54-283 UTILITIES - SANITATION SVC 10-54-284 UTILITIES - CABLE SVC
10-54-320 GENERAL HEALTH SERVICES 10-54-610 MISCELLANEOUS SUPPLIES 10-54-620 MISC SERVICES 10-54-691 DISTR EXP: FACILITIES MAINT 10-54-692 DIST EXP: SOLID WASTE
116.67
116.67
.00
116.67
1,400.00
1,283.33
8.3
10-54-693 DIST EXP: VEHICLE MAINT
9,500.00
9,500.00
.00
9,500.00
114,000.00
104,500.00
8.3
10-54-700 ARRA / CLV JAG EXPENDITURES
5,500.00
5,500.00
5,500.00
11,000.00
.00
11,000.00)
.0
.00
.00
.00
.00
130,000.00
130,000.00
.0
318,023.87
318,023.87
11,980.00
330,003.87
4,117,316.13
3,787,312.26
8.0
10-54-740 CAPITAL OUTLAY TOTAL POLICE
(
PD - CORRECTIONS DIVISION 10-55-110 SALARIES
38,510.08
38,510.08
.00
38,510.08
464,135.00
425,624.92
8.3
10-55-112 VAC/SICK BUYOUT
.00
.00
.00
.00
13,177.00
13,177.00
.0
10-55-113 LONGEVITY PAY
.00
.00
.00
.00
8,975.00
8,975.00
.0
10-55-115 UNIFORM ALLOWANCE
.00
.00
.00
.00
14,000.00
14,000.00
.0
375.00
375.00
.00
375.00
3,250.00
2,875.00
11.5
10-55-116 EDUCATION ASSISTANCE PAY 10-55-120 OVERTIME
2,665.12
2,665.12
.00
2,665.12
15,000.00
12,334.88
17.8
10-55-130 EMPLOYEE BENEFITS
27,023.72
27,023.72
.00
27,023.72
316,210.60
289,186.88
8.6
10-55-230 TRAVEL & TRAINING
.00
.00
.00
.00
1,500.00
1,500.00
.0
10-55-240 OFFICE EXPENSE & SUPPLIES
.00
.00
.00
.00
500.00
500.00
.0
10-55-281 UTILITIES - ELECTRICITY
.00
.00
.00
.00
29,000.00
29,000.00
.0
1,177.00
1,177.00
.00
1,177.00
27,200.00
26,023.00
4.3
412.19
412.19
.00
412.19
1,650.00
1,237.81
25.0
.00
.00
.00
.00
11,350.00
11,350.00
.0
121.00
121.00
.00
121.00
4,075.00
3,954.00
3.0
10-55-282 UTILITIES - WATER 10-55-283 UTILITIES - SANITATION SVC 10-55-310 PROFESSIONAL & TECHINICAL SVCS 10-55-320 GENERAL HEALTH SERVICES 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 TOTAL PD - CORRECTIONS DIVISION
FOR ADMINISTRATION USE ONLY
478.75
478.75
.00
478.75
16,100.00
15,621.25
3.0
3,346.39
3,346.39
.00
3,346.39
70,400.00
67,053.61
4.8
245.83
245.83
.00
245.83
2,950.00
2,704.17
8.3
62.50
62.50
.00
62.50
750.00
687.50
8.3
74,417.58
74,417.58
.00
74,417.58
1,000,222.60
925,805.02
7.4
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:15AM PAGE:10
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 GENERAL FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
PD - DISPATCH DIVISION 10-56-110 SALARIES
30,538.58
30,538.58
.00
30,538.58
458,370.00
427,831.42
6.7
10-56-112 VAC/SICK BUYOUT
.00
.00
.00
.00
7,600.00
7,600.00
.0
10-56-113 LONGEVITY PAY
.00
.00
.00
.00
9,450.00
9,450.00
.0
4,335.13
4,335.13
.00
4,335.13
50,000.00
45,664.87
8.7
10-56-130 EMPLOYEE BENEFITS
15,328.05
15,328.05
.00
15,328.05
257,806.12
242,478.07
6.0
10-56-230 TRAVEL & TRAINING
.00
.00
.00
.00
3,400.00
3,400.00
.0
10-56-610 MISCELLANOUS SUPPLIES
.00
.00
.00
.00
4,000.00
4,000.00
.0
50,201.76
50,201.76
.00
50,201.76
790,626.12
740,424.36
6.4
130,182.00
130,182.00
.00
130,182.00
1,965,077.00
1,834,895.00
6.6
.00
.00
.00
.00
47,067.00
47,067.00
.0
3,125.00
3,125.00
.00
3,125.00
26,425.00
23,300.00
11.8
10-56-120 OVERTIME
TOTAL PD - DISPATCH DIVISION
FIRE / RESCUE 10-57-110 SALARIES 10-57-112 VAC/SICK BUYOUT 10-57-113 LONGEVITY PAY 10-57-115 UNIFORM ALLOWANCE
3,630.00
3,630.00
.00
3,630.00
3,960.00
330.00
91.7
10-57-120 OVERTIME
23,601.96
23,601.96
.00
23,601.96
210,784.00
187,182.04
11.2
10-57-130 EMPLOYEE BENEFITS
88,914.03
88,914.03
.00
88,914.03
1,264,232.93
1,175,318.90
7.0
10-57-210 BOOKS, SUBSCRIPTIONS & MEMBERS
.00
.00
.00
.00
6,500.00
6,500.00
.0
10-57-230 TRAVEL & TRAINING
.00
.00
.00
.00
38,750.00
38,750.00
9.88)
.00
9.88)
3,500.00
3,509.88
6,292.97
6,292.97
.00
6,292.97
97,100.00
90,807.03
.00
.00
.00
.00
25,500.00
25,500.00
.0
10-57-282 UTILITIES - WATER
693.00
693.00
.00
693.00
9,400.00
8,707.00
7.4
10-57-283 UTILITIES - SANITATION SVC
707.46
707.46
.00
707.46
2,900.00
2,192.54
24.4
10-57-290 TELEPHONE
755.33
755.33
.00
755.33
14,800.00
14,044.67
5.1
1,838.90
1,838.90
.00
1,838.90
84,570.00
82,731.10
2.2
.00
.00
.00
.00
15,000.00
15,000.00
.0
106.60
106.60
.00
106.60
55,950.00
55,843.40
.2
10-57-615 EMS SUPPLIES
6,205.39
6,205.39
.00
6,205.39
73,200.00
66,994.61
8.5
10-57-691 DISTR EXP: FACILITIES MAINT
1,208.33
1,208.33
.00
1,208.33
14,500.00
13,291.67
8.3
195.83
195.83
.00
195.83
2,350.00
2,154.17
8.3
4,500.00
4,500.00
.00
4,500.00
54,000.00
49,500.00
8.3
506.17
506.17
.00
506.17
7,400.00
6,893.83
6.8
10-57-703 EMPG GRANT EXPENDITURES
.00
.00
.00
.00
30,000.00
30,000.00
.0
10-57-740 CAPITAL OUTLAY
.00
.00
.00
.00
695,000.00
695,000.00
.0
272,453.09
272,453.09
.00
272,453.09
4,747,965.93
4,475,512.84
5.7
10-57-240 OFFICE EXPENSE & SUPPLIES 10-57-250 EQUIPMENT SUPPLIES & MAINT NC 10-57-281 UTILITIES - ELECTRICITY
10-57-310 PROFESSIONAL & TECHNICAL SVCS 10-57-320 GENERAL HEALTH SERVICES 10-57-610 MISCELLANOUS SUPPLIES
10-57-692 DIST EXP: SOLID WASTE 10-57-693 DIST EXP: VEHICLE MAINT 10-57-695 BANK/ CREDIT CARD CHARGES
TOTAL FIRE / RESCUE
FOR ADMINISTRATION USE ONLY
(
9.88)
(
8 % OF THE FISCAL YEAR HAS ELAPSED
(
09/13/2017 11:15AM PAGE:11
.0 (
.3) 6.5
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 GENERAL FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
PUBLIC WORKS 10-60-110 SALARIES
5,829.40
5,829.40
.00
5,829.40
70,263.00
64,433.60
8.3
10-60-112 VAC/SICK BUYOUT
.00
.00
.00
.00
5,444.00
5,444.00
.0
10-60-113 LONGEVITY PAY
.00
.00
.00
.00
1,460.00
1,460.00
.0
30.00
30.00
.00
30.00
30.00
.00
100.0
10-60-115 UNIFORM ALLOWANCE 10-60-120 OVERTIME
1.78
1.78
.00
1.78
1,000.00
998.22
.2
10-60-130 EMPLOYEE BENEFITS
2,582.71
2,582.71
.00
2,582.71
32,066.39
29,483.68
8.1
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
10-60-290 TELEPHONE
147.11
147.11
.00
147.11
1,875.00
1,727.89
7.9
10-60-310 PROFESSIONAL & TECHNICAL SVCS
371.48
371.48
.00
371.48
3,800.00
3,428.52
9.8
.00
.00
.00
.00
500.00
500.00
.0
152.77
152.77
.00
152.77
2,000.00
1,847.23
7.6
9,115.25
9,115.25
.00
9,115.25
119,638.39
110,523.14
7.6
10-60-320 GRNERAL HEALTH SERVICES 10-60-610 MISCELLANOUS SUPPLIES TOTAL PUBLIC WORKS
DEVELOPMENT SERVICES 10-61-110 SALARIES
34,915.06
34,915.06
.00
34,915.06
463,324.00
428,408.94
7.5
10-61-112 VAC/SICK BUYOUT
.00
.00
.00
.00
20,787.00
20,787.00
.0
10-61-113 LONGEVITY PAY
.00
.00
.00
.00
9,600.00
9,600.00
.0
2,377.64
2,377.64
.00
2,377.64
2,000.00
377.64)
118.9
16,329.73
16,329.73
.00
16,329.73
214,962.74
198,633.01
7.6
1,099.00
1,099.00
.00
1,099.00
5,990.00
4,891.00
18.4
237.04
237.04
.00
237.04
1,500.00
1,262.96
15.8
.00
.00
.00
.00
3,000.00
3,000.00
.0
10-61-240 OFFICE EXPENSE & SUPPLIES
389.82
389.82
.00
389.82
7,500.00
7,110.18
5.2
10-61-290 TELEPHONE
10-61-120 OVERTIME 10-61-130 EMPLOYEE BENEFITS 10-61-210 BOOKS, SUBSCRIPTIONS & MEMBERS 10-61-220 PUBLIC NOTICES 10-61-230 TRAVEL & TRAINING
(
285.82
285.82
.00
285.82
2,000.00
1,714.18
14.3
10-61-310 PROFFESSIONAL & TECHNICAL SVCS
.00
.00
.00
.00
2,340.00
2,340.00
.0
10-61-610 MISCELLANEOUS SUPPLIES
.00
.00
.00
.00
20,000.00
20,000.00
.0
55,634.11
55,634.11
.00
55,634.11
753,003.74
697,369.63
7.4
TOTAL DEVELOPMENT SERVICES
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:15AM PAGE:12
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 GENERAL FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
FACILITY MAINTENANCE 10-63-110 SALARIES
18,480.76
18,480.76
.00
18,480.76
250,688.00
232,207.24
7.4
10-63-112 VAC/SICK BUYOUT
.00
.00
.00
.00
3,851.00
3,851.00
.0
10-63-113 LONGEVITY PAY
.00
.00
.00
.00
9,375.00
9,375.00
.0
1,200.00
1,200.00
.00
1,200.00
1,600.00
400.00
75.0
10-63-115 UNIFORM ALLOWANCE 10-63-120 OVERTIME
40.15
40.15
.00
40.15
4,000.00
3,959.85
1.0
10-63-130 EMPLOYEE BENEFITS
8,736.44
8,736.44
.00
8,736.44
130,019.94
121,283.50
6.7
10-63-230 TRAVEL & TRAINING
.00
.00
.00
.00
1,000.00
1,000.00
.0
411.45
411.45
.00
411.45
30,500.00
30,088.55
1.4
10-63-280 UTILITIES
.00
.00
.00
.00
19,600.00
19,600.00
.0
10-63-281 UTILITIES - ELECTRICITY
.00
.00
.00
.00
600.00
600.00
.0
112.24
112.24
.00
112.24
1,350.00
1,237.76
8.3
11,928.82
11,928.82
3,294.00
15,222.82
76,120.00
60,897.18
20.0
4,278.06
4,278.06
.00
4,278.06
84,000.00
79,721.94
15,516.67)
.00
558.33
558.33
.00
.00
.00
.00
400.00
400.00
30,629.58
10-63-250 EQUIPMENT SUPPLIES & MAINT NC
10-63-290 TELEPHONE 10-63-310 PROFESSIONAL & TECHNICAL SVCS 10-63-610 MISCELLANEOUS SUPPLIES 10-63-690 EXP DISTRIBUTION TO OTHER DEPT 10-63-691 DISTR EXP: FACILITIES MAINT 10-63-692 DIST EXP: SOLID WASTE 10-63-693 DIST EXP: VEHICLE MAINT TOTAL FACILITY MAINTENANCE
(
15,516.67)
(
(
15,516.67)
(
5.1
186,200.00) (
170,683.33) (
8.3)
558.33
6,700.00
6,141.67
8.3
.00
4,800.00
4,800.00
.0
.00
400.00
.00
400.00)
.0
30,629.58
3,294.00
33,923.58
438,003.94
404,080.36
7.8
(
STREETS & DRAINAGE 10-65-110 SALARIES
27,021.49
27,021.49
.00
27,021.49
345,454.00
318,432.51
7.8
10-65-112 VAC/SICK BUYOUT
.00
.00
.00
.00
7,022.00
7,022.00
.0
10-65-113 LONGEVITY PAY
.00
.00
.00
.00
9,200.00
9,200.00
.0
2,000.00
2,000.00
.00
2,000.00
2,400.00
400.00
83.3
10-65-115 UNIFORM ALLOWANCE 10-65-120 OVERTIME
176.23
176.23
.00
176.23
3,200.00
3,023.77
5.5
10-65-130 EMPLOYEE BENEFITS
12,571.43
12,571.43
.00
12,571.43
176,097.38
163,525.95
7.1
10-65-230 TRAVEL & TRAINING
.00
.00
.00
.00
1,500.00
1,500.00
.0
2,882.69
2,882.69
.00
2,882.69
40,000.00
37,117.31
7.2
10-65-280 ELECTRICITY - STREET LIGHTS
.00
.00
.00
.00
270,000.00
270,000.00
.0
10-65-281 UTILITIES - ELECTRICITY
.00
.00
.00
.00
10,800.00
10,800.00
.0
10-65-282 UTILITIES - WATER
673.75
673.75
.00
673.75
5,800.00
5,126.25
11.6
10-65-283 UTILITIES - SANITATION SVC
143.29
143.29
.00
143.29
600.00
456.71
23.9
10-65-290 TELEPHONE
102.24
102.24
.00
102.24
1,200.00
1,097.76
8.5
2,860.00
2,860.00
43,350.00
46,210.00
316,800.00
270,590.00
14.6
10-65-250 EQUIPMENT SUPPLIES & MAINT NC
10-65-480 DRAINAGE MAINTENANCE 10-65-610 MISCELLANEOUS SUPPLIES
562.20
562.20
.00
562.20
23,800.00
23,237.80
2.4
6,097.65
6,097.65
2,727.16
8,824.81
22,500.00
13,675.19
39.2
10-65-691 DISTR EXP: FACILITIES MAINT
420.83
420.83
.00
420.83
5,050.00
4,629.17
8.3
10-65-692 DIST EXP: SOLID WASTE
216.67
216.67
.00
216.67
2,600.00
2,383.33
8.3
3,083.33
3,083.33
.00
3,083.33
37,000.00
33,916.67
8.3
.00
.00
.00
.00
250,000.00
250,000.00
.0
58,811.80
58,811.80
46,077.16
104,888.96
1,531,023.38
1,426,134.42
6.9
10-65-615 LOCAL DRAINAGE MAINTENANCE
10-65-693 DIST EXP: VEHICLE MAINT 10-65-740 CAPITAL OUTLAY TOTAL STREETS & DRAINAGE
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:15AM PAGE:13
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 GENERAL FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
VEHICLE MAINTENANCE 10-66-110 SALARIES 10-66-115 UNIFORM ALLOWANCE 10-66-120 OVERTIME
10,628.96
10,628.96
.00
10,628.96
136,980.00
126,351.04
7.8
300.00
300.00
.00
300.00
300.00
.00
100.0
.00
.00
.00
.00
1,800.00
1,800.00
.0
10-66-130 EMPLOYEE BENEFITS
5,934.28
5,934.28
.00
5,934.28
80,063.51
74,129.23
7.4
10-66-230 TRAVEL & TRAINING
550.00
550.00
.00
550.00
1,000.00
450.00
55.0
.00
.00
.00
.00
700.00
700.00
.0
2,737.65
2,737.65
.00
2,737.65
24,500.00
21,762.35
11.2
10-66-240 OFFICE EXPENSES & SUPPLIES 10-66-245 TIRES & WHEELS 10-66-250 VEHICLE MAINTENANCE
5,642.86
5,642.86
.00
5,642.86
150,000.00
144,357.14
3.8
10,458.44
10,458.44
.00
10,458.44
170,000.00
159,541.56
6.2
10-66-260 EQUIPMENT
.00
.00
.00
.00
5,700.00
5,700.00
.0
10-66-281 UTILITIES - ELECTRICITY
.00
.00
.00
.00
10,500.00
10,500.00
.0
10-66-282 UTILITIES - WATER
199.50
199.50
.00
199.50
2,250.00
2,050.50
8.9
10-66-283 UTILITIES - SANITATION SVC
283.58
283.58
.00
283.58
1,150.00
866.42
24.7
.00
.00
.00
.00
3,500.00
3,500.00
.0
6,915.15
6,915.15
.00
6,915.15
73,800.00
66,884.85
9.4
10-66-255 FUEL
10-66-310 PROFESSIONAL & TECHNICAL SVCS 10-66-480 VEH MAINT & FUEL-SILVER RIDER 10-66-610 SERVICES AND SUPPLIES 10-66-690 EXP DISTRIBUTION TO OTHER DEPT 10-66-691 DISTR EXP: FACILITIES MAINT 10-66-692 DIST EXP: SOLID WASTE 10-66-693 DIST EXP: VEHICLE MAINT TOTAL VEHICLE MAINTENANCE
386.60 (
386.60
.00
23,116.64)
.00
100.00
100.00
.00
58.33
58.33
.00
433.33
433.33
21,512.04
23,116.64)
(
386.60 (
23,116.64)
12,000.00 (
11,613.40
3.2
277,400.00) (
254,283.36) (
8.3)
100.00
1,200.00
1,100.00
8.3
58.33
700.00
641.67
8.3
.00
433.33
5,200.00
4,766.67
8.3
21,512.04
.00
21,512.04
403,943.51
382,431.47
5.3
ANIMAL CONTROL 10-70-110 SALARIES
10,701.51
10,701.51
.00
10,701.51
145,414.00
134,712.49
7.4
10-70-112 VAC/SICK BUYOUT
.00
.00
.00
.00
8,408.00
8,408.00
.0
10-70-113 LONGEVITY PAY
.00
.00
.00
.00
2,525.00
2,525.00
.0
10-70-115 UNIFORM ALLOWANCE
2,000.00
2,000.00
.00
2,000.00
2,000.00
.00
100.0
10-70-120 OVERTIME
1,307.55
1,307.55
.00
1,307.55
4,000.00
2,692.45
32.7
10-70-130 EMPLOYEE BENEFITS
5,234.67
5,234.67
.00
5,234.67
67,523.52
62,288.85
7.8
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
10-70-281 UTILITIES - ELECTRICITY
.00
.00
.00
.00
7,250.00
7,250.00
.0
10-70-283 UTILITIES - SANITATION SVC
100.43
100.43
.00
100.43
425.00
324.57
23.6
10-70-290 TELEPHONE
153.36
153.36
.00
153.36
2,100.00
1,946.64
7.3
.00
.00
.00
.00
13,000.00
13,000.00
.0
18.95
18.95
.00
18.95
17,830.00
17,811.05
.1
491.67
491.67
.00
491.67
5,900.00
5,408.33
8.3 8.3
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 10-70-693 DIST EXP: VEHICLE MAINT 10-70-740 CAPITAL OUTLAY TOTAL ANIMAL CONTROL
FOR ADMINISTRATION USE ONLY
66.67
66.67
.00
66.67
800.00
733.33
625.00
625.00
.00
625.00
7,500.00
6,875.00
8.3
24,242.00
24,242.00
33,636.00
57,878.00
60,000.00
2,122.00
96.5
44,941.81
44,941.81
33,636.00
78,577.81
346,700.52
268,122.71
22.7
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:15AM PAGE:14
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 GENERAL FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
LANDFILL/SOLID WASTE 10-73-250 EQUIPMENT SUPPLIES & MAINT NC
.00
.00
.00
.00
2,500.00
2,500.00
10-73-260 SOLID WASTE COLLECTION EXPENSE
.00
.00
.00
.00
841,500.00
841,500.00
.0
3,049.06
3,049.06
13,400.00
16,449.06
69,900.00
53,450.94
23.5
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
.00
(
3,458.33)
(
3,458.33)
.00
(
409.27)
(
409.27)
13,400.00
12,990.73
900,900.00
887,909.27
1.4
(
3,458.33)
28,500.00
.0
(
41,500.00)
28,500.00 (
38,041.67)
.0 (
8.3)
PARKS/GROUNDS MAINT. 10-76-110 SALARIES
39,069.41
39,069.41
.00
39,069.41
483,968.00
444,898.59
8.1
10-76-112 VAC/SICK BUYOUT
.00
.00
.00
.00
14,392.00
14,392.00
.0
10-76-113 LONGEVITY PAY
.00
.00
.00
.00
11,400.00
11,400.00
.0
3,600.00
3,600.00
.00
3,600.00
3,600.00
.00
100.0
10-76-115 UNIFORM ALLOWANCE 10-76-120 OVERTIME
291.45
291.45
.00
291.45
10,000.00
9,708.55
2.9
10-76-130 EMPLOYEE BENEFITS
19,688.59
19,688.59
.00
19,688.59
259,343.38
239,654.79
7.6
10-76-230 TRAVEL & TRAINING
.00
.00
.00
.00
1,000.00
1,000.00
.0
10-76-250 EQUIPMENT SUPPLIES MAINT NC
.00
.00
.00
.00
12,000.00
12,000.00
.0
10-76-281 UTILITIES - ELECTRICITY
.00
.00
.00
.00
76,000.00
76,000.00
.0
52,389.50
52,389.50
.00
52,389.50
410,000.00
357,610.50
12.8
1,570.38
1,570.38
.00
1,570.38
6,300.00
4,729.62
24.9
56.12
56.12
.00
56.12
675.00
618.88
8.3
1,000.59
1,000.59
.00
1,000.59
12,400.00
11,399.41
8.1
18.95
18.95
24,372.75
24,391.70
70,000.00
45,608.30
34.9
10-76-610 MISCELLANEOUS SUPPLIES
5,259.76
5,259.76
11,315.60
16,575.36
170,000.00
153,424.64
9.8
10-76-691 DISTR EXP: FACILITIES MAINT
1,479.17
1,479.17
.00
1,479.17
17,750.00
16,270.83
8.3
10-76-692 DIST EXP: SOLID WASTE
2,250.00
2,250.00
.00
2,250.00
27,000.00
24,750.00
8.3
10-76-693 DIST EXP: VEHICLE MAINT
2,166.67
2,166.67
.00
2,166.67
26,000.00
23,833.33
8.3
13,300.00
13,300.00
14,810.00
28,110.00
662,000.00
633,890.00
4.3
142,140.59
142,140.59
50,498.35
192,638.94
2,273,828.38
2,081,189.44
8.5
10-76-282 UTILITIES - WATER 10-76-283 UTILITIES - SANITATION SVC 10-76-284 UTILITIES - CABLE SVC 10-76-290 TELEPHONE 10-76-310 PROFESSIONAL & TECHNICAL SVCS
10-76-740 CAPITAL OUTLAY TOTAL PARKS/GROUNDS MAINT.
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:15AM PAGE:15
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 GENERAL FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
LEISURE SERVICES 10-81-110 SALARIES
45,156.52
45,156.52
.00
45,156.52
450,095.00
404,938.48
10.0
10-81-112 VAC/SICK BUYOUT
.00
.00
.00
.00
21,988.00
21,988.00
.0
10-81-113 LONGEVITY PAY
.00
.00
.00
.00
11,250.00
11,250.00
.0
206.43
206.43
.00
206.43
5,000.00
4,793.57
4.1
10-81-120 OVERTIME 10-81-130 EMPLOYEE BENEFITS
14,413.70
14,413.70
.00
14,413.70
174,162.33
159,748.63
8.3
10-81-210 BOOKS, SUBSCRIPTIONS & MEMBERS
.00
.00
.00
.00
600.00
600.00
.0
10-81-230 TRAVEL & TRAINING
.00
.00
.00
.00
5,500.00
5,500.00
.0
149.86
149.86
.00
149.86
6,000.00
5,850.14
2.5
1,917.93
1,917.93
.00
1,917.93
35,000.00
33,082.07
5.5
.00
.00
.00
.00
202,000.00
202,000.00
.0
10-81-282 UTILITIES - WATER
3,714.00
3,714.00
.00
3,714.00
32,500.00
28,786.00
11.4
10-81-283 UTILITIES - SANITATION SVC
2,517.79
2,517.79
.00
2,517.79
10,500.00
7,982.21
24.0
83.37
83.37
.00
83.37
1,000.00
916.63
8.3
102.47
102.47
.00
102.47
2,000.00
1,897.53
5.1
81.80
81.80
.00
81.80
1,000.00
918.20
8.2
2,390.00
2,390.00
.00
2,390.00
40,000.00
37,610.00
6.0
573.90
573.90
.00
573.90
14,000.00
13,426.10
4.1
8,695.86
8,695.86
.00
8,695.86
28,000.00
19,304.14
31.1
10-81-240 OFFICE EXPENSE & SUPPLIES 10-81-250 EQUIPMENT SUPPLIES & MAINT NC 10-81-281 UTILITIES - ELECTRICITY
10-81-284 UTILITIES - CABLE SVC 10-81-290 TELEPHONE 10-81-310 PROFESSIONAL & TECHNICAL SVCS 10-81-480 ATHLETIC MARKETING 10-81-490 CITY SPONSORED EVENTS 10-81-610 MISCELLANEOUS SUPPLIES 10-81-620 MISCELLANEOUS SERVICE
.00
.00
.00
.00
3,000.00
3,000.00
.0
4,383.33
4,383.33
.00
4,383.33
52,600.00
48,216.67
8.3
10-81-692 DIST EXP: SOLID WASTE
191.67
191.67
.00
191.67
2,300.00
2,108.33
8.3
10-81-693 DIST EXP: VEHICLE MAINT
458.33
458.33
.00
458.33
5,500.00
5,041.67
8.3
.00
.00
355.00
355.00
220,000.00
219,645.00
.2
85,036.96
85,036.96
355.00
85,391.96
1,323,995.33
1,238,603.37
6.5
10-82-110 SALARIES
3,051.72
3,051.72
.00
3,051.72
35,113.00
32,061.28
8.7
10-82-130 EMPLOYEE BENEFITS
1,537.27
1,537.27
.00
1,537.27
21,465.41
19,928.14
7.2
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-82-240 OFFICE EXPENSE AND SUPPLIES
.00
.00
.00
.00
300.00
300.00
.0
10-82-281 UTILITIES - ELECTRICITY
.00
.00
.00
.00
2,400.00
2,400.00
.0
43.00
43.00
.00
43.00
625.00
582.00
6.9
10-81-691 DISTR EXP: FACILITIES MAINT
10-81-740 CAPITAL OUTLAY TOTAL LEISURE SERVICES
MUSEUM
10-82-282 UTILITIES - WATER 10-82-283 UTILITIES - SANITATION SVC
129.65
129.65
.00
129.65
525.00
395.35
24.7
10-82-290 TELEPHONE
29.63
29.63
.00
29.63
275.00
245.37
10.8
10-82-610 SERVICES AND SUPPLIES
93.72
93.72
.00
93.72
3,000.00
2,906.28
3.1
10-82-620 MISCELLANEOUS SERVICES
453.95
453.95
.00
453.95
1,200.00
746.05
37.8
10-82-691 DISTR EXP: FACILITIES MAINT
145.83
145.83
.00
145.83
1,750.00
1,604.17
8.3
12.50
12.50
.00
12.50
150.00
137.50
8.3
5,497.27
5,497.27
.00
5,497.27
67,553.41
62,056.14
8.1
10-82-692 DIST EXP: SOLID WASTE TOTAL MUSEUM
TRANSFERS 10-90-113 CAP PROJECTS R & M FUND
8,333.33
8,333.33
.00
8,333.33
100,000.00
91,666.67
8.3
10-90-116 SR. NUTRITION S/R FUND
14,583.33
14,583.33
.00
14,583.33
175,000.00
160,416.67
8.3
10-90-185 G O BONDS 2002 SERIES
84,731.08
84,731.08
.00
84,731.08
1,016,773.00
932,041.92
8.3
10-90-197 TRSFR TO CITY SVCS FUND
25,000.00
25,000.00
.00
25,000.00
300,000.00
275,000.00
8.3
132,647.74
132,647.74
.00
132,647.74
1,591,773.00
1,459,125.26
8.3
TOTAL TRANSFERS
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:15AM PAGE:16
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 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
1,818,846.58
1,818,846.58
178,740.51
1,997,587.09
24,152,668.84
22,155,081.75
8.3
212,749.06) (
212,749.06) (
8 % OF THE FISCAL YEAR HAS ELAPSED
178,740.51) (
391,489.57) (
3,329,845.84) (
2,938,356.27) ( 11.8)
09/13/2017 11:15AM PAGE:17
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 STREET MAINT. SPEC. REV. FUND ASSETS 11-11900 CASH-COMBINED FUND
3,367,281.98
11-13107 OTHER RECEIVABLES
32,488.01
TOTAL ASSETS
3,399,769.99
LIABILITIES AND EQUITY
LIABILITIES 11-21310 ACCOUNTS PAYABLE
538,396.86
11-21330 CONTRACTOR RETENTIONS PAYABLE
96,673.28
TOTAL LIABILITIES
635,070.14
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 11-29800 BALANCE - BEGINNING OF YEAR
3,599,186.09
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
834,486.24) 2,764,699.85
TOTAL FUND EQUITY
2,764,699.85
TOTAL LIABILITIES AND EQUITY
3,399,769.99
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:15AM PAGE:18
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 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
380,000.00
380,000.00
.0
.00
.00
.00
.00
380,000.00
380,000.00
.0
11-33-100 GAS TAX (COUNTY)
.00
.00
.00
.00
93,000.00
93,000.00
.0
11-33-120 REG'L TRANS COMM - COUNTY
.00
.00
.00
.00
1,800,000.00
1,800,000.00
.0
11-33-500 GAS TAX - STATE
.00
.00
.00
.00
240,000.00
240,000.00
.0 .0
TOTAL SOURCE 32
STREETS INTERGOV'TL REVENUE
11-33-530 VVWD REIMBURSEMENTS
(
127,965.56) (
127,965.56)
.00
(
127,965.56)
.00
127,965.56
TOTAL STREETS INTERGOV'TL REVE
(
127,965.56) (
127,965.56)
.00
(
127,965.56)
2,133,000.00
2,260,965.56
(
6.0)
TOTAL FUND REVENUE
(
127,965.56) (
127,965.56)
.00
(
127,965.56)
2,513,000.00
2,640,965.56
(
5.1)
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:16AM PAGE:19
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 STREET MAINT. SPEC. REV. FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
STREETS & DRAINAGE 11-65-110 SALARIES
6,185.42
6,185.42
.00
6,185.42
84,914.00
78,728.58
7.3
11-65-112 VAC/SICK BUYOUT
.00
.00
.00
.00
9,866.00
9,866.00
.0
11-65-113 LONGEVITY PAY
.00
.00
.00
.00
3,300.00
3,300.00
.0
400.00
400.00
.00
400.00
400.00
.00
100.0
3,926.90
3,926.90
.00
3,926.90
39,575.27
35,648.37
9.9
.00
.00
39,240.16
39,240.16
200,000.00
160,759.84
19.6
696,008.36
696,008.36
251,385.38
947,393.74
1,931,422.00
984,028.26
49.1
TOTAL STREETS & DRAINAGE
706,520.68
706,520.68
290,625.54
997,146.22
2,269,477.27
1,272,331.05
43.9
TOTAL FUND EXPENDITURES
706,520.68
706,520.68
290,625.54
997,146.22
2,269,477.27
1,272,331.05
43.9
834,486.24) (
834,486.24) (
290,625.54) (
1,125,111.78)
243,522.73
1,368,634.51
(462.0)
11-65-115 UNIFORM 11-65-130 EMPLOYEE BENEFITS 11-65-700 STREET MAINTENANCE 11-65-740 CAPITAL OUTLAY
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:16AM PAGE:20
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 AIRPORT SPECIAL REVENUE FUND ASSETS 12-11900 CASH - COMBINED FUND
10,973.75
12-13102 DUE FROM OTHER GOVT'S
39,891.89
12-13107 ACCOUNTS RECEIVABLE - AVFUEL
128,111.81
12-13115 AVIATION FUEL INVENTORY
31,472.88
TOTAL ASSETS
210,450.33
LIABILITIES AND EQUITY
LIABILITIES 12-21310 ACCOUNTS PAYABLE
2,821.35
TOTAL LIABILITIES
2,821.35
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 12-29800 BALANCE - BEGINNING OF YEAR
243,725.17
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
36,096.19) 207,628.98
TOTAL FUND EQUITY
207,628.98
TOTAL LIABILITIES AND EQUITY
210,450.33
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:16AM PAGE:21
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 AIRPORT SPECIAL REVENUE FUND PER. ACTUAL
ACTUAL YTD
(
(
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
AIRPORT INTERGOV'TL REVENUE 12-33-225 FEDERAL FAA GRANT
21,933.00)
.00
.00
.00
21,933.00)
.00
43,631.75
43,631.75
3,513.22
3,513.22
.00
TOTAL CHARGES FOR SERVICES
TOTAL FUND REVENUE
12-33-250 FUEL TAX - JET FUEL TOTAL AIRPORT INTERGOV'TL REVEN
21,933.00)
21,933.00)
678,656.00
700,589.00
.00
2,000.00
2,000.00
21,933.00)
680,656.00
702,589.00
.00
43,631.75
360,000.00
316,368.25
12.1
.00
3,513.22
82,600.00
79,086.78
4.3
.00
.00
.00
17,000.00
17,000.00
.0
47,144.97
47,144.97
.00
47,144.97
459,600.00
412,455.03
10.3
25,211.97
25,211.97
.00
25,211.97
1,140,256.00
1,115,044.03
2.2
.00 (
21,933.00)
(
(
(
(
3.2) .0
(
3.2)
CHARGES FOR SERVICES 12-34-600 AVIATION FUEL/OIL SALES 12-34-605 AIRPORT LEASES 12-34-610 OTHER LEASES
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:16AM PAGE:22
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 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
12-87-250 EQUIPMENT SUPPLIES & MAINT NC
.00
.00
.00
.00
2,900.00
2,900.00
.0
44,778.11
44,778.11
.00
44,778.11
250,000.00
205,221.89
17.9
12-87-260 EQUIPMENT (NON CAPITALIZED)
.00
.00
.00
.00
1,200.00
1,200.00
.0
12-87-281 UTILITIES - ELECTRICITY
.00
.00
.00
.00
17,200.00
17,200.00
.0
330.50
330.50
.00
330.50
3,900.00
3,569.50
8.5
12-87-255 FUEL
12-87-282 UTILITIES - WATER 12-87-290 TELEPHONE
.0
117.44
117.44
.00
117.44
1,750.00
1,632.56
6.7
13,317.01
13,317.01
5,250.00
18,567.01
93,100.00
74,532.99
19.9
12-87-480 RUNWAY MISCELLANEOUS SUPPLIES
.00
.00
.00
.00
47,000.00
47,000.00
.0
12-87-510 INSURANCE
.00
.00
.00
.00
7,100.00
7,100.00
.0
1,066.66
1,066.66
.00
1,066.66
50,700.00
49,633.34
2.1
12-87-691 DISTR EXP: FACILITIES MAINT
37.50
37.50
.00
37.50
450.00
412.50
8.3
12-87-692 DIST EXP: SOLID WASTE
12.50
12.50
.00
12.50
150.00
137.50
8.3
12-87-693 DIST EXP: VEHICLE MAINT
341.67
341.67
.00
341.67
4,100.00
3,758.33
8.3
12-87-695 BANK/ CREDIT CARD CHARGES
583.77
583.77
.00
583.77
2,000.00
1,416.23
29.2
12-87-740 CAPITAL OUTLAY
723.00
723.00
.00
723.00
738,900.00
738,177.00
.1
TOTAL AIRPORT
61,308.16
61,308.16
5,250.00
66,558.16
1,220,990.00
1,154,431.84
5.5
TOTAL FUND EXPENDITURES
61,308.16
61,308.16
5,250.00
66,558.16
1,220,990.00
1,154,431.84
5.5
39,387.81)
( 51.2)
12-87-310 PROFESSIONAL & TECHNICAL SVCS
12-87-610 MISCELLANEOUS SUPPLIES
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
36,096.19)
(
36,096.19)
(
8 % OF THE FISCAL YEAR HAS ELAPSED
5,250.00)
(
41,346.19)
(
80,734.00)
(
09/13/2017 11:16AM PAGE:23
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 CAP. PROJ. MAINT/REPAIRS FUND ASSETS 13-11900 CASH-COMBINED FUND
630,342.41
TOTAL ASSETS
630,342.41
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 13-29800 BALANCE - BEGINNING OF YEAR
622,009.08
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
8,333.33 630,342.41
TOTAL FUND EQUITY
630,342.41
TOTAL LIABILITIES AND EQUITY
630,342.41
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:16AM PAGE:24
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 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
8,333.33
.00
8,333.33
100,000.00
91,666.67
8.3
TOTAL CONTRIBUTIONS AND TRANSF
8,333.33
8,333.33
.00
8,333.33
100,000.00
91,666.67
8.3
TOTAL FUND REVENUE
8,333.33
8,333.33
.00
8,333.33
100,000.00
91,666.67
8.3
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:16AM PAGE:25
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 CAP. PROJ. MAINT/REPAIRS FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
MAINTENANCE/REPAIRS 13-40-450 MAINTENANCE/REPAIRS
.00
.00
3,400.00
3,400.00
119,900.00
116,500.00
2.8
13-40-625 REPAIRS & REMODELS
.00
.00
.00
.00
305,000.00
305,000.00
.0
TOTAL MAINTENANCE/REPAIRS
.00
.00
3,400.00
3,400.00
424,900.00
421,500.00
.8
TOTAL FUND EXPENDITURES
.00
.00
3,400.00
3,400.00
424,900.00
421,500.00
.8
8,333.33
8,333.33
3,400.00)
4,933.33
324,900.00) (
329,833.33)
1.5
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
8 % OF THE FISCAL YEAR HAS ELAPSED
(
09/13/2017 11:16AM PAGE:26
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 POLICE FORFEITURE FUND ASSETS 14-11900 CASH - COMBINED FUND
121,914.99
TOTAL ASSETS
121,914.99
LIABILITIES AND EQUITY
LIABILITIES 14-21310 ACCOUNTS PAYABLE
127.00
TOTAL LIABILITIES
127.00
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 14-29800 BALANCE - BEGINNING OF YEAR
121,787.99
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
121,787.99
TOTAL FUND EQUITY
121,787.99
TOTAL LIABILITIES AND EQUITY
121,914.99
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:16AM PAGE:27
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 POLICE FORFEITURE FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
POLICE 14-54-740 CAPITAL OUTLAY
.00
.00
21,549.00
21,549.00
.00
(
21,549.00)
.0
TOTAL POLICE
.00
.00
21,549.00
21,549.00
.00
(
21,549.00)
.0
TOTAL FUND EXPENDITURES
.00
.00
21,549.00
21,549.00
.00
(
21,549.00)
.0
NET REVENUE OVER EXPENDITURES
.00
.00
21,549.00)
.00
21,549.00
.0
FOR ADMINISTRATION USE ONLY
(
8 % OF THE FISCAL YEAR HAS ELAPSED
21,549.00)
(
09/13/2017 11:16AM PAGE:28
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 COURT ADMINISTRATIVE ASSESS. ASSETS 15-11900 CASH - COMBINED FUND
135,884.31
TOTAL ASSETS
135,884.31
LIABILITIES AND EQUITY
LIABILITIES 15-21310 ACCOUNTS PAYABLE
14,938.80
15-21320 A/P: STATE-AOC FEES (AA1)
643.00
15-21330 A/P - STATE: GENERAL FEES (AA5
(
35.00)
15-21340 A/P - LVMPD: DNA FEES (AAGMA)
(
21.00)
(
49.00)
15-21350 A/P-STATE: DOM VIOLENCE FEES
35.00
15-21360 A/P-STATE:SPECIALTY COURT FEES 15-21370 A/P-STATE: DUI SPEC COURT FEES
62.50
15-23200 BAIL HOLDINGS
68,150.00
TOTAL LIABILITIES
83,724.30
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 15-29800 BALANCE - BEGINNING OF YEAR
(
15-29805 FB - HABITUAL OFFENDER PGM
5,793.15
15-29810 FB - ADMIN ASSESS FEES
45,056.29
15-29815 FB - COURT COLLECTION FEES
12,198.98
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
10,000.00)
(
888.41) 52,160.01
TOTAL FUND EQUITY
52,160.01
TOTAL LIABILITIES AND EQUITY
FOR ADMINISTRATION USE ONLY
135,884.31
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:16AM PAGE:29
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 COURT ADMINISTRATIVE ASSESS. PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
HABITUAL OFFENDER PROGRAM 15-40-100 REV - BREAKING THE CYCLE GRANT 15-40-110 EXP: SALARIES & WAGES 15-40-120 REV: PGM PARTICIPANT FEES
(
15-40-320 EXP: BENEFITS
89.50
89.50
.00
89.50
.00
.00
.00
.00
100.00)
.00
100.00)
(
(
100.00)
(
8,400.00)
(
5,090.00 (
1,500.00)
8,489.50)
1.1
5,090.00 (
1,400.00)
.0 (
6.7)
.00
.00
.00
.00
348.00
348.00
.0
15-40-340 EXP: PROF & TECH SVCS
64.45
64.45
.00
64.45
3,000.00
2,935.55
2.2
15-40-350 EXP: SVCS & SUPPLIES
75.00
75.00
.00
75.00
1,520.00
1,445.00
4.9
128.95
128.95
.00
128.95
58.00
(
70.95)
222.3
16,000.00)
(
14,727.00)
TOTAL HABITUAL OFFENDER PROGR
ADMINITSTRATIVE ASSESSMENTS 15-60-100 REV - ADMIN ASSESSMENT FEES
(
1,273.00)
.00
3,040.54
3,040.54
.00
3,040.54
4,000.00
959.46
76.0
15-60-340 EXP: PROF & TECH SVCS
.00
.00
.00
.00
3,000.00
3,000.00
.0
15-60-350 EXP: SVCS & SUPPLIES
.00
.00
.00
.00
8,000.00
8,000.00
.0
15-60-740 EXP: CAPITAL OUTLAY
.00
.00
.00
.00
10,000.00
10,000.00
.0
1,767.54
1,767.54
.00
1,767.54
9,000.00
7,232.46
19.6
15-60-330 EXP: TRAVEL & TRAINING
TOTAL ADMINITSTRATIVE ASSESSME
1,273.00)
(
(
1,273.00)
(
(
8.0)
COURT COLLECTION FEES 15-70-100 REV - COLLECTION FEES
(
940.00)
.00
7,060.00)
( 11.8)
6.43
6.43
.00
6.43
3,965.00
3,958.57
.2
15-70-130 EXP: BENEFITS
.49
.49
.00
.49
470.00
469.51
.1
15-70-340 EXP: PROF & TECH SVCS
.00
.00
.00
.00
750.00
750.00
.0
15-70-350 EXP: SVCS & SUPPLIES
.00
.00
.00
.00
800.00
800.00
.0
1,081.92)
( 46.3)
15-70-110 EXP: SALARIES & WAGES
TOTAL COURT COLLECTION FEES
940.00)
(
(
940.00)
(
8,000.00)
(
(
933.08)
(
933.08)
.00
(
933.08)
(
2,015.00)
(
(
75.00)
(
75.00)
.00
(
75.00)
(
100.00)
(
.00
.00
75.00)
.00
888.41
.00
888.41)
.00
CIVIL FILING FEES 15-80-100 REV - CIVIL FILING FEES 15-80-350 EXP: SVCS & SUPPLIES TOTAL CIVIL FILING FEES
.00 (
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
75.00)
(
888.41
(
888.41)
(
8 % OF THE FISCAL YEAR HAS ELAPSED
(
(
25.00)
( 75.0)
.00
100.00
100.00
.0
75.00)
.00
75.00
.0
888.41
7,043.00
6,154.59
12.6
6,154.59)
( 12.6)
888.41)
(
7,043.00)
(
09/13/2017 11:16AM PAGE:30
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 SR. NUTRITION PROGRAM ASSETS 16-11900 CASH - COMBINED FUND
88,867.40
TOTAL ASSETS
88,867.40
LIABILITIES AND EQUITY
LIABILITIES 16-21310 ACCOUNTS PAYABLE
8,176.90
TOTAL LIABILITIES
8,176.90
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 16-29800 BALANCE - BEGINNING OF YEAR
86,883.46
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
6,192.96) 80,690.50
TOTAL FUND EQUITY
80,690.50
TOTAL LIABILITIES AND EQUITY
88,867.40
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:16AM PAGE:31
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 SR. NUTRITION PROGRAM PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
INTERGOVERNMENTAL REVENUE 16-33-220 TITLE III, C-1, CONGR. MEALS
6,651.00
6,651.00
.00
6,651.00
78,000.00
71,349.00
8.5
11,003.00
11,003.00
.00
11,003.00
136,500.00
125,497.00
8.1
16-33-245 EQUIPMENT GRANT
.00
.00
.00
.00
6,000.00
6,000.00
.0
16-33-265 OTHER GRANTS - NSIP
.00
.00
.00
.00
25,000.00
25,000.00
.0
16-33-270 GRANT - CLARK COUNTY OAG
.00
.00
.00
.00
30,000.00
30,000.00
.0
17,654.00
17,654.00
.00
17,654.00
275,500.00
257,846.00
6.4
16-33-230 TITLE III, C-2, HOME MEALS
TOTAL INTERGOVERNMENTAL REVE
CHARGES FOR SERVICES 16-34-400 PATRON DONATIONS
4,257.66
4,257.66
.00
4,257.66
56,000.00
51,742.34
7.6
16-34-410 OTHER INCOME
90.00
90.00
.00
90.00
3,000.00
2,910.00
3.0
16-34-415 INMATE MEALS
1,586.00
1,586.00
.00
1,586.00
25,000.00
23,414.00
6.3
5,933.66
5,933.66
.00
5,933.66
84,000.00
78,066.34
7.1
16-38-120 DONATIONS
.00
.00
.00
.00
6,000.00
6,000.00
.0
16-38-150 FACILITIES / SPACE RENTAL
.00
.00
.00
.00
1,500.00
1,500.00
.0
.00
.00
.00
.00
7,500.00
7,500.00
.0
14,583.33
14,583.33
.00
14,583.33
175,000.00
160,416.67
8.3
TOTAL TRANSFERS
14,583.33
14,583.33
.00
14,583.33
175,000.00
160,416.67
8.3
TOTAL FUND REVENUE
38,170.99
38,170.99
.00
38,170.99
542,000.00
503,829.01
7.0
TOTAL CHARGES FOR SERVICES
OTHER REVENUE
TOTAL OTHER REVENUE
TRANSFERS 16-39-960 TRANSFER FROM G/F
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:16AM PAGE:32
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 SR. NUTRITION PROGRAM PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
SR. NUTRITION EXPENSES 16-71-110 SALARIES
18,284.83
18,284.83
.00
18,284.83
218,326.00
200,041.17
8.4
16-71-112 VAC/SICK BUYOUT
.00
.00
.00
.00
8,003.00
8,003.00
.0
16-71-113 LONGEVITY PAY
.00
.00
.00
.00
6,350.00
6,350.00
.0
16-71-120 OVERTIME
.00
.00
.00
.00
1,200.00
1,200.00
.0
9,199.78
9,199.78
.00
9,199.78
115,699.86
106,500.08
8.0
16-71-210 CONTRACTED SERVICES
.00
.00
.00
.00
500.00
500.00
.0
16-71-230 TRAVEL & TRAINING
.00
.00
.00
.00
1,000.00
1,000.00
.0
16-71-240 OFFICE EXPENSE & SUPPLIES
.00
.00
.00
.00
1,200.00
1,200.00
.0
16-71-250 EQUIPMENT SUPPLIES & MAINT NC
.00
.00
.00
.00
1,000.00
1,000.00
.0
16-71-281 UTILITIES - ELECTRICITY
.00
.00
.00
.00
26,500.00
26,500.00
.0
340.50
340.50
.00
340.50
4,000.00
3,659.50
8.5
1,239.52
1,239.52
.00
1,239.52
5,000.00
3,760.48
24.8
278.22
278.22
.00
278.22
475.00
196.78
58.6
.00
.00
.00
.00
1,475.00
1,475.00
.0
11,764.34
11,764.34
.00
11,764.34
175,000.00
163,235.66
6.7
16-71-610 MISCELLANEOUS SUPPLIES
1,202.60
1,202.60
.00
1,202.60
4,000.00
2,797.40
30.1
16-71-620 MISCELLANEOUS SERVICES
.00
.00
.00
.00
4,000.00
4,000.00
.0
1,062.50
1,062.50
.00
1,062.50
12,750.00
11,687.50
8.3
16-71-692 DIST EXP: SOLID WASTE
183.33
183.33
.00
183.33
2,200.00
2,016.67
8.3
16-71-693 DIST EXP: VEHICLE MAINT
808.33
808.33
.00
808.33
9,700.00
8,891.67
8.3
.00
.00
.00
.00
10,000.00
10,000.00
.0
TOTAL SR. NUTRITION EXPENSES
44,363.95
44,363.95
.00
44,363.95
608,378.86
564,014.91
7.3
TOTAL FUND EXPENDITURES
44,363.95
44,363.95
.00
44,363.95
608,378.86
564,014.91
7.3
6,192.96)
.00
16-71-130 EMPLOYEE BENEFITS
16-71-282 UTILITIES - WATER 16-71-283 UTILITIES - SANITATION SVC 16-71-290 TELEPHONE 16-71-310 PROFESSIONAL & TECHNICAL SVCS 16-71-480 FOOD/COMMODITY SUPPLIES
16-71-691 DISTR EXP: FACILITIES MAINT
16-71-740 CAPITAL OUTLAY
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
6,192.96)
(
8 % OF THE FISCAL YEAR HAS ELAPSED
(
6,192.96)
(
66,378.86)
(
60,185.90)
09/13/2017 11:16AM PAGE:33
(
9.3)
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 RECREATION PROGRAMS ASSETS 17-11900 CASH - COMBINED FUND
222,988.26
17-13107 OTHER RECEIVABLES
4,000.00
TOTAL ASSETS
226,988.26
LIABILITIES AND EQUITY
LIABILITIES 17-21310 ACCOUNTS PAYABLE
5,307.29
TOTAL LIABILITIES
5,307.29
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 17-29800 BALANCE - BEGINNING OF YEAR
237,614.82
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
15,933.85) 221,680.97
TOTAL FUND EQUITY
221,680.97
TOTAL LIABILITIES AND EQUITY
226,988.26
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:16AM PAGE:34
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 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
11,080.89
11,080.89
.00
11,080.89
195,000.00
183,919.11
5.7
2,610.00
2,610.00
.00
2,610.00
60,000.00
57,390.00
4.4
17-34-415 DONATIONS
.00
.00
.00
.00
2,500.00
2,500.00
.0
17-34-420 SIGNS
.00
.00
.00
.00
48,000.00
48,000.00
.0
TOTAL CHARGES FOR SERVICES
13,690.89
13,690.89
.00
13,690.89
305,500.00
291,809.11
4.5
TOTAL FUND REVENUE
13,690.89
13,690.89
.00
13,690.89
335,500.00
321,809.11
4.1
TOTAL SOURCE 33
CHARGES FOR SERVICES 17-34-400 REC PROGRAM FEES 17-34-405 FIELD RENTAL
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:16AM PAGE:35
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 RECREATION PROGRAMS PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
RECREATION PROGRAM COSTS 17-80-110 SALARIES
15,500.55
15,500.55
.00
15,500.55
227,538.00
212,037.45
6.8
17-80-112 VAC/SICK BUYOUT
.00
.00
.00
.00
3,217.00
3,217.00
.0
17-80-113 LONGEVITY PAY
.00
.00
.00
.00
800.00
800.00
.0
400.00
400.00
.00
400.00
400.00
.00
100.0
17-80-130 EMPLOYEE BENEFITS
3,676.26
3,676.26
.00
3,676.26
60,255.91
56,579.65
6.1
17-80-310 PROFFESSIONAL & TECHNICAL SVCS
6,802.00
6,802.00
.00
6,802.00
70,000.00
63,198.00
9.7
17-80-485 PRE-SCHOOL COSTS
2,772.68
2,772.68
.00
2,772.68
6,000.00
3,227.32
46.2 1.3
17-80-115 UNIFORM ALLOWANCE
17-80-610 MISCELLANEOUS SUPPLIES
473.25
473.25
.00
473.25
36,000.00
35,526.75
17-80-695 BANK/ CREDIT CARD CHARGES
.00
.00
.00
.00
6,800.00
6,800.00
.0
17-80-740 CAPITAL OUTLAY
.00
.00
12,000.00
12,000.00
30,000.00
18,000.00
40.0
TOTAL RECREATION PROGRAM COST
29,624.74
29,624.74
12,000.00
41,624.74
441,010.91
399,386.17
9.4
TOTAL FUND EXPENDITURES
29,624.74
29,624.74
12,000.00
41,624.74
441,010.91
399,386.17
9.4
77,577.06)
( 26.5)
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
15,933.85)
(
15,933.85)
(
8 % OF THE FISCAL YEAR HAS ELAPSED
12,000.00)
(
27,933.85)
(
105,510.91) (
09/13/2017 11:16AM PAGE:36
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 FORENSIC SERVICES ASSETS 19-11900 CASH - COMBINED FUND
2,264.33
TOTAL ASSETS
2,264.33
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 19-29800 BALANCE - BEGINNING OF YEAR
2,406.00
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
141.67) 2,264.33
TOTAL FUND EQUITY
2,264.33
TOTAL LIABILITIES AND EQUITY
2,264.33
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:16AM PAGE:37
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 FORENSIC SERVICES PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
FINES AND FORFEITURES 19-35-200 ANALYSIS FEE, DUI NRS484.3798
150.00
150.00
.00
150.00
3,300.00
3,150.00
4.6
.00
.00
.00
.00
60.00
60.00
.0
TOTAL FINES AND FORFEITURES
150.00
150.00
.00
150.00
3,360.00
3,210.00
4.5
TOTAL FUND REVENUE
150.00
150.00
.00
150.00
3,360.00
3,210.00
4.5
19-35-300 ANALYSIS FEE, DRUGS NRS453.575
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:16AM PAGE:38
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 FORENSIC SERVICES PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
TRANSFERS 19-90-109 TRANSFER TO GEN. FUND
291.67
291.67
.00
291.67
3,500.00
3,208.33
8.3
TOTAL TRANSFERS
291.67
291.67
.00
291.67
3,500.00
3,208.33
8.3
TOTAL FUND EXPENDITURES
291.67
291.67
.00
291.67
3,500.00
3,208.33
8.3
141.67)
.00
140.00)
1.67
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
141.67)
(
8 % OF THE FISCAL YEAR HAS ELAPSED
(
141.67)
(
09/13/2017 11:16AM PAGE:39
(101.2)
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 RESID. CONSTR. TAX PARK FUND ASSETS 20-11900 CASH - COMBINED FUND
1,380,684.00
TOTAL ASSETS
1,380,684.00
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 20-29900 PARK AREA A
170,476.25
20-29905 PARK AREA B
356,823.86
20-29910 PARK AREA C
201,388.32
20-29915 PARK AREA D
528,407.29
20-29920 PARK AREA E
28,000.00
20-29999 PARK AREA - OTHER
65,588.28
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
30,000.00 1,380,684.00
TOTAL FUND EQUITY
1,380,684.00
TOTAL LIABILITIES AND EQUITY
1,380,684.00
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:16AM PAGE:40
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 RESID. CONSTR. TAX PARK FUND PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
LICENSES AND PERMITS 20-32-215 PARK AREA - A
2,000.00
2,000.00
.00
2,000.00
12,000.00
10,000.00
16.7
20-32-220 PARK AREA - B
.00
.00
.00
.00
50,000.00
50,000.00
.0
20-32-225 PARK AREA - C
.00
.00
.00
.00
10,000.00
10,000.00
.0
20-32-230 PARK AREA - D
17,000.00
17,000.00
.00
17,000.00
150,000.00
133,000.00
11.3
20-32-235 PARK AREA - E
6,000.00
6,000.00
.00
6,000.00
20,000.00
14,000.00
30.0
20-32-400 PARK AREA - OTHER
5,000.00
5,000.00
.00
5,000.00
.00
5,000.00)
.0
30,000.00
30,000.00
.00
30,000.00
242,000.00
212,000.00
12.4
.00
.00
.00
.00
200,000.00
200,000.00
.0
.00
.00
.00
.00
200,000.00
200,000.00
.0
30,000.00
30,000.00
.00
30,000.00
442,000.00
412,000.00
6.8
TOTAL LICENSES AND PERMITS
(
GRANT REVENUE 20-33-110 CDBG GRANT TOTAL GRANT REVENUE
TOTAL FUND REVENUE
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:16AM PAGE:41
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 RESID. CONSTR. TAX PARK FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
PARKS/GROUNDS MAINT. 20-76-751 PARK REPAIRS/IMPROVEMENTS
.00
.00
.00
.00
158,000.00
158,000.00
.0
20-76-805 PICKLEBALL COURTS (4)
.00
.00
.00
.00
200,000.00
200,000.00
.0
20-76-807 JENSEN PARK-RUBBERIZED SURFACE
.00
.00
.00
.00
75,000.00
75,000.00
.0
TOTAL PARKS/GROUNDS MAINT.
.00
.00
.00
.00
433,000.00
433,000.00
.0
TOTAL FUND EXPENDITURES
.00
.00
.00
.00
433,000.00
433,000.00
.0
30,000.00
30,000.00
.00
30,000.00
9,000.00
21,000.00)
333.3
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
(
09/13/2017 11:16AM PAGE:42
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 ENVIR. PLANNING SPEC.REV. FUND ASSETS 21-11900 CASH - COMBINED FUND
545,647.31
TOTAL ASSETS
545,647.31
LIABILITIES AND EQUITY
LIABILITIES 21-23215 VRHCP IMPACT FEES COLLECTIONS
493,940.71
21-25501 DEFERRED INC - TOWN WASH MITIG
47,575.50
21-25502 DEFERRED INC - PULTE
872.51
TOTAL LIABILITIES
542,388.72
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 21-29800 BALANCE - BEGINNING OF YEAR
3,258.59
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
3,258.59
TOTAL FUND EQUITY
3,258.59
TOTAL LIABILITIES AND EQUITY
FOR ADMINISTRATION USE ONLY
545,647.31
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:16AM PAGE:43
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 ENVIR. PLANNING SPEC.REV. FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
EXPENDITURES 21-85-216 EXIT 118 MITIGATION
.00
.00
31,395.00
31,395.00
.00
31,395.00)
.0
21-85-310 PROFESSIONAL & TECHNICAL SVCS
.00
.00
.00
.00
100,000.00
100,000.00
.0
TOTAL EXPENDITURES
.00
.00
31,395.00
31,395.00
100,000.00
68,605.00
31.4
TOTAL FUND EXPENDITURES
.00
.00
31,395.00
31,395.00
100,000.00
68,605.00
31.4
NET REVENUE OVER EXPENDITURES
.00
.00
100,000.00) (
68,605.00)
( 31.4)
FOR ADMINISTRATION USE ONLY
(
8 % OF THE FISCAL YEAR HAS ELAPSED
31,395.00)
(
31,395.00)
(
(
09/13/2017 11:16AM PAGE:44
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 TRANSPORTATION IMPACT FEE FUND ASSETS 22-11900 CASH-COMBINED FUND
2,080,169.91
TOTAL ASSETS
2,080,169.91
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 22-29800 BALANCE - BEGINNING OF YEAR
2,078,229.83
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
1,940.08 2,080,169.91
TOTAL FUND EQUITY
2,080,169.91
TOTAL LIABILITIES AND EQUITY
2,080,169.91
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:16AM PAGE:45
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 TRANSPORTATION IMPACT FEE FUND PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
LICENSES AND PERMITS 22-32-210 TRANSPORT. IMPACT FEES
1,940.08
1,940.08
.00
1,940.08
.00
(
1,940.08)
.0
TOTAL LICENSES AND PERMITS
1,940.08
1,940.08
.00
1,940.08
.00
(
1,940.08)
.0
TOTAL FUND REVENUE
1,940.08
1,940.08
.00
1,940.08
.00
(
1,940.08)
.0
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:16AM PAGE:46
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 TRANSPORTATION IMPACT FEE FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
STREETS & DRAINAGE 22-65-310 PROFESSIONAL & TECHICAL SVCS
.00
.00
.00
.00
60,000.00
60,000.00
.0
22-65-605 ADMINISTRATIVE EXPENSES
.00
.00
.00
.00
2,000.00
2,000.00
.0
22-65-742 SIGNAL - PIONEER / GRAPEVINE
.00
.00
.00
.00
500,000.00
500,000.00
.0
22-65-744 SIGNAL- PIONEER / TURTLEBACK
.00
.00
.00
.00
500,000.00
500,000.00
.0
22-65-746 TRAFFIC SIGNAL COORD - FIBER
.00
.00
.00
.00
25,000.00
25,000.00
.0
22-65-748 SIGNAL- RIVERSIDE RD /HAFEN LN
.00
.00
.00
.00
500,000.00
500,000.00
.0
TOTAL STREETS & DRAINAGE
.00
.00
.00
.00
1,587,000.00
1,587,000.00
.0
TOTAL FUND EXPENDITURES
.00
.00
.00
.00
1,587,000.00
1,587,000.00
.0
1,940.08
1,940.08
.00
1,940.08
1,587,000.00) (
1,588,940.08)
.1
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
(
09/13/2017 11:16AM PAGE:47
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 MORE COPS SRF ASSETS 23-11900 CASH COMBINED FUND
(
23-13107 OTHER RECEIVABLES
74,980.71) 215,515.65
TOTAL ASSETS
140,534.94
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 23-29800 BALANCE BEGINNING YEAR
128,307.08
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
12,227.86 140,534.94
TOTAL FUND EQUITY
140,534.94
TOTAL LIABILITIES AND EQUITY
140,534.94
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:16AM PAGE:48
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 MORE COPS SRF PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
INTERGOVERNMENTAL REVENUES 23-33-255 MORE COPS GRANT-1/4% SALES TAX
80,000.00
80,000.00
.00
80,000.00
1,000,000.00
23-33-260 CRIME PREVENTION TAX
20,000.00
20,000.00
.00
20,000.00
.00
.00
.00
.00
.00
TOTAL INTERGOVERNMENTAL REVE
100,000.00
100,000.00
.00
TOTAL FUND REVENUE
100,000.00
100,000.00
.00
23-33-265 OTHER GRANTS
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
920,000.00
8.0
20,000.00)
.0
15,000.00
15,000.00
.0
100,000.00
1,015,000.00
915,000.00
9.9
100,000.00
1,015,000.00
915,000.00
9.9
(
09/13/2017 11:16AM PAGE:49
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 MORE COPS SRF PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
EXPENDITURES 23-85-110 SALARIES 23-85-112 VAC/SICK BUYOUT 23-85-113 LONGEVITY PAY 23-85-115 UNIFORM ALLOWANCE 23-85-116 EDUCATION ASSISTANCE PAY 23-85-120 OVERTIME
48,334.16
48,334.16
.00
48,334.16
553,137.00
504,802.84
.00
.00
.00
.00
20,940.00
20,940.00
8.7 .0
1,375.00
1,375.00
.00
1,375.00
6,750.00
5,375.00
20.4
.00
.00
.00
.00
16,000.00
16,000.00
.0
696.43
696.43
.00
696.43
7,150.00
6,453.57
9.7
3,706.41
3,706.41
.00
3,706.41
25,000.00
21,293.59
14.8
30,256.38
30,256.38
.00
30,256.38
362,665.69
332,409.31
8.3
3,403.76
3,403.76
.00
3,403.76
40,000.00
36,596.24
8.5
TOTAL EXPENDITURES
87,772.14
87,772.14
.00
87,772.14
1,031,642.69
943,870.55
8.5
TOTAL FUND EXPENDITURES
87,772.14
87,772.14
.00
87,772.14
1,031,642.69
943,870.55
8.5
NET REVENUE OVER EXPENDITURES
12,227.86
12,227.86
.00
12,227.86
28,870.55)
73.5
23-85-130 EMPLOYEE BENEFITS 23-85-250 EQUIPMENT SUPPLIES & MAINT NC
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
(
16,642.69)
(
09/13/2017 11:16AM PAGE:50
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 REDEVELOPMENT DISTRICT ASSETS 25-11900 CASH - COMBINED FUND
4,430,594.10
25-12100 CASH - NEVADA ST BANK(BOND $$)
624,589.91
25-13107 OTHER RECEIVABLES
11.73
TOTAL ASSETS
5,055,195.74
LIABILITIES AND EQUITY
LIABILITIES 25-21310 ACCOUNTS PAYABLE
5,507.34
TOTAL LIABILITIES
5,507.34
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 25-29800 BALANCE - BEGINNING OF YEAR
5,151,260.80
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
101,572.40) 5,049,688.40
TOTAL FUND EQUITY
5,049,688.40
TOTAL LIABILITIES AND EQUITY
5,055,195.74
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:16AM PAGE:51
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 REDEVELOPMENT DISTRICT PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
TAXES 25-31-100 PROPERTY TAXES TOTAL TAXES
.00
.00
.00
.00
2,025,000.00
2,025,000.00
.0
.00
.00
.00
.00
2,025,000.00
2,025,000.00
.0
.00
.00
.00
.00
44,000.00
44,000.00
.0
.00
.00
.00
.00
44,000.00
44,000.00
.0
INTERGOVERNMENTAL REVENUE 25-33-235 STATE GRANT - SHPO (OLD GYM) TOTAL INTERGOVERNMENTAL REVE
OTHER REVENUE 25-38-100 INTEREST REVENUE
84.70
84.70
.00
84.70
35,000.00
34,915.30
.2
710.00
710.00
.00
710.00
9,000.00
8,290.00
7.9
TOTAL OTHER REVENUE
794.70
794.70
.00
794.70
44,000.00
43,205.30
1.8
TOTAL FUND REVENUE
794.70
794.70
.00
794.70
2,113,000.00
2,112,205.30
.0
25-38-110 LEASE REV-COMMUNITY SIGNS
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:17AM PAGE:52
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 REDEVELOPMENT DISTRICT PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
SPECIAL APPROPRIATIONS 25-85-110 SALARIES
9,167.42
9,167.42
.00
9,167.42
103,989.00
94,821.58
8.8
507.10
507.10
.00
507.10
7,605.00
7,097.90
6.7
25-85-113 LONGEVITY PAY
.00
.00
.00
.00
1,531.00
1,531.00
.0
25-85-120 OVERTIME
.00
.00
.00
.00
250.00
250.00
.0
4,101.50
4,101.50
.00
4,101.50
49,298.72
45,197.22
8.3
.00
.00
.00
.00
1,500.00
1,500.00
.0
275.00
275.00
.00
275.00
4,000.00
3,725.00
6.9
25-85-112 VAC/SICK BUYOUT
25-85-130 EMPLOYEE BENEFITS 25-85-210 BOOKS, SUBSCRIPTIONS & MEMBERS 25-85-230 TRAVEL & TRAINING 25-85-240 OFFICE EXPENSE & SUPPLIES
.00
.00
.00
.00
250.00
250.00
.0
250.00
250.00
250.00
500.00
50,000.00
49,500.00
1.0
25-85-653 DISTRICT SUPPORT SERVICES
.00
.00
.00
.00
250,000.00
250,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
500,000.00
500,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
625,000.00
625,000.00
.0
25-85-757 HISTORIC BUILDING RESTORATION
.00
.00
12,383.60
12,383.60
200,000.00
187,616.40
6.2
25-85-768 MESQ CAMPUS THEATER UPGRADE
3,335.00
3,335.00
9,540.08
12,875.08
.00
12,875.08)
.0
17,636.02
17,636.02
22,173.68
39,809.70
1,996,423.72
1,956,614.02
2.0
84,731.08
84,731.08
.00
84,731.08
1,016,773.00
932,041.92
8.3
84,731.08
84,731.08
.00
84,731.08
1,016,773.00
932,041.92
8.3
102,367.10
102,367.10
22,173.68
124,540.78
3,013,196.72
2,888,655.94
4.1
101,572.40) (
101,572.40) (
22,173.68)
25-85-620 MISCELLANEOUS SERVICES
TOTAL SPECIAL APPROPRIATIONS
(
TRANSFERS 25-90-109 TRANSFER TO GEN. FUND TOTAL TRANSFERS
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
8 % OF THE FISCAL YEAR HAS ELAPSED
(
123,746.08) (
900,196.72) (
776,450.64) ( 13.8)
09/13/2017 11:17AM PAGE:53
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 CITY MARKETING SRF ASSETS 43-11900 CASH - COMBINED FUND
269,166.73
TOTAL ASSETS
269,166.73
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 43-29800 BEGINNING OF YEAR
285,000.06
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
15,833.33) 269,166.73
TOTAL FUND EQUITY
269,166.73
TOTAL LIABILITIES AND EQUITY
269,166.73
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:17AM PAGE:54
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 CITY MARKETING SRF PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
EXPENDITURES 43-40-310 PROF & TECH SVCS
15,833.33
15,833.33
.00
15,833.33
190,000.00
174,166.67
8.3
TOTAL EXPENDITURES
15,833.33
15,833.33
.00
15,833.33
190,000.00
174,166.67
8.3
TOTAL FUND EXPENDITURES
15,833.33
15,833.33
.00
15,833.33
190,000.00
174,166.67
8.3
15,833.33)
.00
190,000.00) (
174,166.67) (
8.3)
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
15,833.33)
(
8 % OF THE FISCAL YEAR HAS ELAPSED
(
15,833.33)
(
09/13/2017 11:17AM PAGE:55
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 ECONOMIC DEVELOPMENT INCENTIVE ASSETS 44-11900 CASH - COMBINED FUNDS
147,335.73
TOTAL ASSETS
147,335.73
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 44-29800 BEGINNING OF YEAR
147,335.73
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
147,335.73
TOTAL FUND EQUITY
147,335.73
TOTAL LIABILITIES AND EQUITY
147,335.73
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:17AM PAGE:56
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 CAPITAL PROJECT FUND ASSETS 45-11900 CASH - COMBINED FUND
123,585.68
TOTAL ASSETS
123,585.68
LIABILITIES AND EQUITY
LIABILITIES 45-21310 ACCOUNTS PAYABLE
7,467.00
45-25500 DEFERRED REVENUE
31,395.00
TOTAL LIABILITIES
38,862.00
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 45-29800 BEGINNING OF YEAR
92,190.68
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
7,467.00) 84,723.68
TOTAL FUND EQUITY
84,723.68
TOTAL LIABILITIES AND EQUITY
FOR ADMINISTRATION USE ONLY
123,585.68
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:17AM PAGE:57
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 CAPITAL PROJECT FUND PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
(
7,467.00)
(
7,467.00)
.00
(
7,467.00)
1,037,000.00
1,044,467.00
(
.7)
TOTAL INTERGOVERNMENTAL REVE
(
7,467.00)
(
7,467.00)
.00
(
7,467.00)
1,037,000.00
1,044,467.00
(
.7)
TOTAL FUND REVENUE
(
7,467.00)
(
7,467.00)
.00
(
7,467.00)
1,037,000.00
1,044,467.00
(
.7)
INTERGOVERNMENTAL REVENUE 45-33-255 CC - REGIONAL FLOOD CONTROL
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:17AM PAGE:58
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 CAPITAL PROJECT FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
EXPENDITURES 45-40-210 CONTRACTED SERVICES
.00
.00
.00
.00
50,000.00
50,000.00
.0
45-40-743 MISC. STREETS
.00
.00
.00
.00
28,200.00
28,200.00
.0
45-40-800 CEMETERY
.00
.00
12,591.74
12,591.74
.00
45-40-802 CITY FACILITY PARKINGLOT REHAB
.00
.00
24,404.40
24,404.40
45-40-809 TOWN WASH, N. OF I-15 & MESA B
.00
.00
.00
45-40-811 VIRGIN RIVER/E. MESQUITE BLVD.
.00
.00
13,637.44
45-40-813 ELDORADO/CHAPARREL FLOOD CNT.
.00
.00
.00
TOTAL EXPENDITURES
.00
.00
TOTAL FUND EXPENDITURES
.00
.00
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
7,467.00)
(
7,467.00)
(
8 % OF THE FISCAL YEAR HAS ELAPSED
12,591.74)
.0
65,000.00
40,595.60
37.6
.00
298,000.00
298,000.00
.0
13,637.44
350,000.00
336,362.56
3.9
.00
389,000.00
389,000.00
.0
50,633.58
50,633.58
1,180,200.00
1,129,566.42
4.3
50,633.58
50,633.58
1,180,200.00
1,129,566.42
4.3
85,099.42)
( 40.6)
50,633.58)
(
58,100.58)
(
(
143,200.00) (
09/13/2017 11:17AM PAGE:59
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 SEWER FUND ASSETS 52-11800 CASH-BK OF NEVADA WASTE BONDS
148,832.90
52-11900 CASH - COMBINED FUND
2,745,520.52
52-13109 SALES TAXES REC'BLE
50,000.00
52-13110 ACCOUNTS RECEIVABLE
16,243.88
52-14000 PREPAID EXPENSE
30,729.17
52-16300 LAND
174,756.00
52-16310 SEWER SYSTEM
36,291,660.34
52-16315 UTILITY LINES
32,274,115.98
52-16350 LAND EASEMENTS
25,300.00
52-16510 MACHINERY AND EQUIPMENT
848,666.72
52-16610 AUTOMOBILE AND TRUCKS
508,262.88
52-16620 WORK IN PROGRESS
80,060.66
52-17500 ACCUMULATED DEPRECIATION
( 19,707,774.33)
52-18100 GASB 68 - DEFERRED OUTFLOWS
212,351.00
TOTAL ASSETS
53,698,725.72
LIABILITIES AND EQUITY
LIABILITIES 52-21310 ACCOUNTS PAYABLE
151,170.94
52-21315 ACCRUED INTEREST
34,340.00
52-21325 ACCRUED VACATION
104,159.37
52-21500 CURRENT PORTION - L/T DEBT
1,024,461.00
52-25103 BONDS PAYABLE - NEVADA, 2.863%
13,625,596.86
52-25200 GASB 68 - DEFERRED INFLOWS
207,472.00
52-25210 GASB 68: NET PENSION LIABILITY
1,363,819.00
TOTAL LIABILITIES
16,511,019.17
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 52-29800 BEGINNING OF YEAR
31,082,802.85
52-29805 CONTRIBUTED CAPITAL, NET
5,670,837.00
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
434,066.70 37,187,706.55
TOTAL FUND EQUITY
37,187,706.55
TOTAL LIABILITIES AND EQUITY
53,698,725.72
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:17AM PAGE:60
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 SEWER FUND PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
TAXES 52-31-102 SALES TAX (HALF .25%) TOTAL TAXES
50,000.00
50,000.00
.00
50,000.00
620,000.00
570,000.00
8.1
50,000.00
50,000.00
.00
50,000.00
620,000.00
570,000.00
8.1
625,690.40
625,690.40
.00
625,690.40
2,500,000.00
1,874,309.60
25.0
72,200.00
72,200.00
.00
72,200.00
475,000.00
402,800.00
15.2
697,890.40
697,890.40
.00
697,890.40
2,975,000.00
2,277,109.60
23.5
OPERATING REVENUE 52-37-100 SEWER SERVICES 52-37-200 CONNECTION FEES TOTAL OPERATING REVENUE
OTHER REVENUE 52-38-100 INTEREST EARNINGS 52-38-900 MISCELLANEOUS TOTAL OTHER REVENUE
TOTAL FUND REVENUE
FOR ADMINISTRATION USE ONLY
(
337.50)
.00
337.50)
1,000.00
1,337.50
( 33.8)
2,275.01
337.50)
(
2,275.01
.00
2,275.01
160,000.00
157,724.99
1.4
1,937.51
1,937.51
.00
1,937.51
161,000.00
159,062.49
1.2
749,827.91
749,827.91
.00
749,827.91
3,756,000.00
3,006,172.09
20.0
8 % OF THE FISCAL YEAR HAS ELAPSED
(
09/13/2017 11:17AM PAGE:61
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 SEWER FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
EXPENDITURES 52-40-110 SALARIES AND WAGES
57,336.39
57,336.39
.00
57,336.39
740,992.00
683,655.61
7.7
52-40-112 VAC/SICK BUYOUT
.00
.00
.00
.00
31,161.00
31,161.00
.0
52-40-113 LONGEVITY PAY
.00
.00
.00
.00
12,905.00
12,905.00
.0
2,520.00
2,520.00
.00
2,520.00
3,320.00
800.00
75.9
52-40-115 UNIFORM ALLOWANCE 52-40-120 OVERTIME
1,745.31
1,745.31
.00
1,745.31
12,000.00
10,254.69
14.5
52-40-130 EMPLOYEE BENEFITS
27,567.00
27,567.00
.00
27,567.00
375,468.83
347,901.83
7.3
52-40-230 TRAVEL & TRAINING
.00
.00
.00
.00
3,500.00
3,500.00
.0
291.58
291.58
.00
291.58
16,000.00
15,708.42
1.8
52-40-240 OFFICE EXPENSE & SUPPLIES 52-40-250 EQUIPMENT SUPPLIES & MAINT NC
1,149.95
1,149.95
.00
1,149.95
46,800.00
45,650.05
2.5
52-40-260 EQUIPMENT
.00
.00
.00
.00
5,500.00
5,500.00
.0
52-40-280 UTILITIES
.00
.00
.00
.00
289,000.00
289,000.00
.0
315.62
315.62
.00
315.62
4,300.00
3,984.38
7.3
34,070.85
34,070.85
28,450.24
62,521.09
135,370.00
72,848.91
46.2
4,797.65
4,797.65
69,260.35
74,058.00
106,000.00
31,942.00
69.9
13,250.83
13,250.83
.00
13,250.83
160,000.00
146,749.17
8.3
133,851.83
133,851.83
.00
133,851.83
1,606,222.00
1,472,370.17
8.3
52-40-610 MISCELLANEOUS SUPPLIES
3,588.20
3,588.20
.00
3,588.20
65,900.00
62,311.80
5.4
52-40-620 MISCELLANOUES SERVICES
936.00
936.00
9,668.00
10,604.00
88,000.00
77,396.00
12.1
52-40-695 BANK/CREDIT CARD FEES
.00
.00
.00
.00
15,200.00
15,200.00
.0
52-40-740 SEWER CAPITAL OUTLAY
.00
.00
15,800.00
15,800.00
414,500.00
398,700.00
3.8
52-40-290 TELEPHONE 52-40-310 PROFESSIONAL & TECHNICAL SVCS 52-40-480 CHEMICAL SUPPLIES 52-40-510 INSURANCE 52-40-535 DEPRECIATION
52-40-750 LATERAL CONS.FEE REIM.
.00
.00
.00
.00
15,000.00
15,000.00
.0
52-40-820 DEBT SERVICE - INTEREST
34,340.00
34,340.00
.00
34,340.00
412,047.00
377,707.00
8.3
TOTAL EXPENDITURES
315,761.21
315,761.21
123,178.59
438,939.80
4,559,185.83
4,120,246.03
9.6
TOTAL FUND EXPENDITURES
315,761.21
315,761.21
123,178.59
438,939.80
4,559,185.83
4,120,246.03
9.6
NET REVENUE OVER EXPENDITURES
434,066.70
434,066.70
123,178.59)
310,888.11
1,114,073.94)
38.7
FOR ADMINISTRATION USE ONLY
(
8 % OF THE FISCAL YEAR HAS ELAPSED
(
803,185.83) (
09/13/2017 11:17AM PAGE:62
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 CANYON CREST SID DSF ASSETS 81-11900 CASH - COMBINED FUND
83,926.26
81-12100 LGIP (MESQSID) - CONSTR FUNDS
387,454.11
81-12500 CASH - WF TRUST#18326100
353,022.17
81-13120 ASSESSMTS REC'BLE-CANYON CREST
1,978,776.54
81-13500 CASH - WF DSRF TRUST#18326101
323,658.63
81-13550 WELLS FARGO-ACCT #804-5040295
367,214.10
TOTAL ASSETS
3,494,051.81
LIABILITIES AND EQUITY
LIABILITIES 81-21450 DEVELOPER DEPOSIT - TOUSA
196,649.07
81-24100 CANYON CREST -CUST OVERPAYMEN
4,150.13
81-24105 CANYON CREST - PREPAID PRIN
153,755.26
81-25120 DEFERRED REVENUE-CANYON CREST
1,978,776.54
TOTAL LIABILITIES
2,333,331.00
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 81-29800 BEGINNING OF YEAR
1,160,689.28
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
31.53 1,160,720.81
TOTAL FUND EQUITY
1,160,720.81
TOTAL LIABILITIES AND EQUITY
3,494,051.81
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:17AM PAGE:63
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 CANYON CREST SID DSF PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
SID ASSESSMENT REVENUE 81-31-115 PRINCIPLE ASSESS-CANYON CREST
194.15
194.15
.00
194.15
204,000.00
203,805.85
.1
81-31-215 INTEREST ASSESS - CANYON CREST
676.01
676.01
.00
676.01
131,000.00
130,323.99
.5
870.16
870.16
.00
870.16
335,000.00
334,129.84
.3
81-38-100 INTEREST INCOME
477.80
477.80
.00
477.80
2,500.00
2,022.20
19.1
81-38-120 CANYON CREST - LATE FEES
178.24
178.24
.00
178.24
250.00
71.76
71.3
81-38-125 CANYON CREST - OTHER INCOME
172.00
172.00
.00
172.00
1,250.00
1,078.00
13.8
828.04
828.04
.00
828.04
4,000.00
3,171.96
20.7
1,698.20
1,698.20
.00
1,698.20
339,000.00
337,301.80
.5
TOTAL SID ASSESSMENT REVENUE
OTHER SID INCOME
TOTAL OTHER SID INCOME
TOTAL FUND REVENUE
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:17AM PAGE:64
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 CANYON CREST SID DSF PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
SID DEBT SVC EXPENDITURES 81-40-801 BOND PMT- PRIN: CANYON CREST
.00
.00
.00
.00
195,000.00
195,000.00
.0
81-40-803 BOND PMT-INT: CANYON CREST
.00
.00
.00
.00
111,000.00
111,000.00
.0
.00
.00
.00
.00
306,000.00
306,000.00
.0
81-90-083 TRSFR TO SID ADMIN SRF #83
1,666.67
1,666.67
.00
1,666.67
20,000.00
18,333.33
8.3
TOTAL TRANSFERS
1,666.67
1,666.67
.00
1,666.67
20,000.00
18,333.33
8.3
TOTAL FUND EXPENDITURES
1,666.67
1,666.67
.00
1,666.67
326,000.00
324,333.33
.5
31.53
31.53
.00
31.53
13,000.00
12,968.47
.2
TOTAL SID DEBT SVC EXPENDITURES
TRANSFERS
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:17AM PAGE:65
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 ANTHEM AT MESQUITE SID DSF ASSETS 82-11900 TOTAL ALLOCATION TO OTHER FUND
(
599,600.05)
82-12100 LGIP (MESQAN) - CONST FUNDS
267,559.30
82-12200 CASH - WF BOND FUND #9300
856,037.51
82-12350 CASH - WF BOND RESERVE #8501
716,546.65
82-13100 SID ASSESSMENTS RECEIVABLE
9,730,048.91
82-13550 WELLS FARGO-ACCT #804-5040295
757,301.74
TOTAL ASSETS
11,727,894.06
LIABILITIES AND EQUITY
LIABILITIES 82-24100 ANTHEM - CUSTOMER OVERPAYMEN
11,079.76
82-24105 ANTHEM - PREPAID PRINCIPLE
358,581.39
82-25100 DEFERRED REVENUE - ANTHEM SID
9,730,048.91
TOTAL LIABILITIES
10,099,710.06
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 82-29800 BALANCE - BEGINNING OF YEAR
1,639,325.69
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
(
11,141.69) 1,628,184.00
TOTAL FUND EQUITY
1,628,184.00
TOTAL LIABILITIES AND EQUITY
FOR ADMINISTRATION USE ONLY
11,727,894.06
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:17AM PAGE:66
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 ANTHEM AT MESQUITE SID DSF PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
SID ASSESSMENT REVENUE 82-31-115 PRINCIPLE ASSESS - ANTHEM
189.82
189.82
.00
189.82
292,000.00
291,810.18
.1
82-31-215 INTEREST ASSESS - ANTHEM
781.30
781.30
.00
781.30
520,000.00
519,218.70
.2
971.12
971.12
.00
971.12
812,000.00
811,028.88
.1
82-38-100 INTEREST INCOME
532.17
532.17
.00
532.17
2,200.00
1,667.83
24.2
82-38-120 ANTHEM - LATE FEES
441.53
441.53
.00
441.53
4,000.00
3,558.47
11.0
82-38-125 ANTHEM - OTHER INCOME
746.82
746.82
.00
746.82
13,000.00
12,253.18
5.7
TOTAL OTHER SID INCOME
1,720.52
1,720.52
.00
1,720.52
19,200.00
17,479.48
9.0
TOTAL FUND REVENUE
2,691.64
2,691.64
.00
2,691.64
831,200.00
828,508.36
.3
TOTAL SID ASSESSMENT REVENUE
OTHER SID INCOME
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:17AM PAGE:67
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 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
.00
.00
.00
.00
435,000.00
435,000.00
.0
82-40-803 BOND PMT-INT: ANTHEM SID
.00
.00
.00
.00
354,000.00
354,000.00
.0
82-40-805 BNDHOLDER PREPAY PREMIUM
.00
.00
.00
.00
6,500.00
6,500.00
.0
.00
.00
.00
.00
795,500.00
795,500.00
.0
82-90-083 TRSFR TO SID ADMIN SRF #83
13,833.33
13,833.33
.00
13,833.33
166,000.00
152,166.67
8.3
TOTAL TRANSFERS
13,833.33
13,833.33
.00
13,833.33
166,000.00
152,166.67
8.3
TOTAL FUND EXPENDITURES
13,833.33
13,833.33
.00
13,833.33
961,500.00
947,666.67
1.4
11,141.69)
.00
130,300.00) (
119,158.31) (
8.6)
TOTAL SID DEBT SVC EXPENDITURES
TRANSFERS
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
(
11,141.69)
(
8 % OF THE FISCAL YEAR HAS ELAPSED
(
11,141.69)
(
09/13/2017 11:17AM PAGE:68
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 SID ADMINISTRATION FUND ASSETS 83-11900 TOTAL ALLOCATION TO OTHER FUND
385,400.78
TOTAL ASSETS
385,400.78
LIABILITIES AND EQUITY
LIABILITIES 83-21310 ACCOUNTS PAYABLE
2,403.03
83-21311 BANK SERVICE CHARGES PAYABLE
415.17
TOTAL LIABILITIES
2,818.20
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 83-29800 BEGINNING OF YEAR
375,488.52
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
7,094.06 382,582.58
TOTAL FUND EQUITY
382,582.58
TOTAL LIABILITIES AND EQUITY
385,400.78
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:17AM PAGE:69
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 SID ADMINISTRATION FUND PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
TRSFR FROM CANYON CREST SID 83-30-115 TRSFR FROM CANYON CREST SID
1,666.67
1,666.67
.00
1,666.67
20,000.00
18,333.33
8.3
265.89
265.89
.00
265.89
2,300.00
2,034.11
11.6
1,932.56
1,932.56
.00
1,932.56
22,300.00
20,367.44
8.7
13,833.33
13,833.33
.00
13,833.33
166,000.00
152,166.67
8.3
493.79
493.79
.00
493.79
4,000.00
3,506.21
12.3
TOTAL TRSFR FROM ANTHEM SID
14,327.12
14,327.12
.00
14,327.12
170,000.00
155,672.88
8.4
TOTAL FUND REVENUE
16,259.68
16,259.68
.00
16,259.68
192,300.00
176,040.32
8.5
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
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:17AM PAGE:70
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 SID ADMINISTRATION FUND PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
CANYON CREST ADMIN EXPENSES 83-81-010 CANYON CREST - PROF SVCS
872.02
872.02
.00
872.02
20,000.00
19,127.98
4.4
1,802.50
1,802.50
.00
1,802.50
23,000.00
21,197.50
7.8
83-81-112 VAC/SICK BUYOUT
.00
.00
.00
.00
1,800.00
1,800.00
.0
83-81-113 LONGEVITY PAY
.00
.00
.00
.00
100.00
100.00
.0
83-81-130 CANYON CREST - EMPLOYEE BENS
708.59
708.59
.00
708.59
9,349.44
8,640.85
7.6
83-81-610 SERVICE AND SUPPLIES
462.55
462.55
.00
462.55
5,500.00
5,037.45
8.4
3,845.66
3,845.66
.00
3,845.66
59,749.44
55,903.78
6.4
83-82-010 ANTHEM - PROFESSION SVCS
1,531.01
1,531.01
.00
1,531.01
34,500.00
32,968.99
4.4
83-82-110 ANTHEM - SALARIES
2,249.99
2,249.99
.00
2,249.99
23,000.00
20,750.01
9.8
83-82-112 VAC/SICK BUYOUT
.00
.00
.00
.00
1,800.00
1,800.00
.0
83-82-113 LONGEVITY PAY
.00
.00
.00
.00
100.00
100.00
.0
83-82-130 ANTHEM - EMPLOYEE BENS
889.19
889.19
.00
889.19
9,349.44
8,460.25
9.5
83-82-610 ANTHEM - SERVICE & SUPPLIES
649.77
649.77
.00
649.77
9,500.00
8,850.23
6.8
TOTAL ANTHEM SID ADMIN EXPENSE
5,319.96
5,319.96
.00
5,319.96
78,249.44
72,929.48
6.8
TOTAL FUND EXPENDITURES
9,165.62
9,165.62
.00
9,165.62
137,998.88
128,833.26
6.6
NET REVENUE OVER EXPENDITURES
7,094.06
7,094.06
.00
7,094.06
54,301.12
47,207.06
13.1
83-81-110 CANYON CREST - SALARIES
TOTAL CANYON CREST ADMIN EXPEN
ANTHEM SID ADMIN EXPENSES
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:17AM PAGE:71
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 G.O. BOND SERIES 2002 ASSETS 85-11900 CASH-COMBINED FUND
1,264,773.94
TOTAL ASSETS
1,264,773.94
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 85-29800 BALANCE - BEGINNING OF YEAR
1,180,042.86
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
84,731.08 1,264,773.94
TOTAL FUND EQUITY
1,264,773.94
TOTAL LIABILITIES AND EQUITY
1,264,773.94
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:17AM PAGE:72
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 G.O. BOND SERIES 2002 PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
CONTRIBUTIONS AND TRANSFERS 85-39-961 TRANSFER FROM G/F
84,731.08
84,731.08
.00
84,731.08
1,016,773.00
932,041.92
8.3
TOTAL CONTRIBUTIONS AND TRANSF
84,731.08
84,731.08
.00
84,731.08
1,016,773.00
932,041.92
8.3
TOTAL FUND REVENUE
84,731.08
84,731.08
.00
84,731.08
1,016,773.00
932,041.92
8.3
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:17AM PAGE:73
CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 G.O. BOND SERIES 2002 PER. ACTUAL
YTD ACTUAL
EMCUMB.
TOTAL
BUDGET
VARIANCE
%
MAINTENANCE/REPAIRS 85-40-814 RDA SERIES 2014 DEBT SVC-PRIN
.00
.00
.00
.00
844,000.00
844,000.00
.0
85-40-825 RDA SERIES 2014 - DEBT SVC INT
.00
.00
.00
.00
172,774.00
172,774.00
.0
TOTAL MAINTENANCE/REPAIRS
.00
.00
.00
.00
1,016,774.00
1,016,774.00
.0
TOTAL FUND EXPENDITURES
.00
.00
.00
.00
1,016,774.00
1,016,774.00
.0
84,731.08
84,731.08
.00
84,731.08
NET REVENUE OVER EXPENDITURES
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
(
1.00)
(
84,732.08) 84731
09/13/2017 11:17AM PAGE:74
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 TRUST & AGENCY FUND ASSETS 90-11310 PETTY CASH - JAIL COMMISSARY 90-11320 BANK OF NEVADA 90-11900 CASH AND COMBINED FUND
100.00 4,270.00 369,361.42
TOTAL ASSETS
373,731.42
LIABILITIES AND EQUITY
LIABILITIES 90-21310 ACCOUNTS PAYABLE 90-26100 CONTRACTOR DEPOSIT 90-26103 VETERANS MEMORIAL DEPOSITS 90-26105 POLICE YOUTH PROGRAMS 90-26109 MESQUITE NARCOTICS TASK FORCE 90-26110 ASSET FORFEITURE TASK FORCE 90-26111 ANIMAL SHELTER DONATIONS 90-26113 INMATE COMMISSARY FUND 90-26115 VETERANS DAY PARADE 90-26117 POLICE - GRAD NITE OUT PARTY 90-26118 POLICE - SHOP W/ A COP
139.61 155,813.55 216.51 1,755.10 4,270.00 106,770.34 4,807.16 13,727.83 66.50 9,184.97 30,710.61
90-26119 POLICE - NAT'L NIGHT OUT
3,500.00
90-26121 POLICE DEPT DONATIONS
5,065.09
90-26122 MESQUITE ENERGY FAIR 90-26124 COMMUNITY THEATRE - R&M 90-26125 SCENIC COMM TOWER R&M FUND 90-26128 LEASES - SECURITY DEPOSITS 90-26129 POLICE - FINGER PRINTING FEES
785.59 814.92 15,000.00 5,100.00 16,003.64
TOTAL LIABILITIES
373,731.42
TOTAL FUND EQUITY
.00
TOTAL LIABILITIES AND EQUITY
FOR ADMINISTRATION USE ONLY
373,731.42
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:17AM PAGE:75
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 GENERAL FIXED ASSETS ASSETS 91-16110 LAND
14,245,425.78
91-16210 BUILDINGS & IMPROVEMENTS
48,293,633.86
91-16310 IMPROVE.OTHER THAN BUILDINGS
23,897,067.27
91-16410 OFFICE FURNITURE AND EQUIPMENT
8,105,732.78
91-16610 AUTOMOBILES AND TRUCKS
7,187,079.90
91-16620 WORK IN PROGRESS
4,714,349.12
91-16710 STORM DRAINS & INLETS
12,514,633.95
91-16810 STREETS & SIDEWALKS
98,348,665.01
TOTAL ASSETS
217,306,587.67
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 91-29800 BEGINNING OF YEAR
205,033,677.25
91-29850 ADDITIONS - CURRENT YEAR
12,272,910.42
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
217,306,587.67
TOTAL FUND EQUITY
217,306,587.67
TOTAL LIABILITIES AND EQUITY
217,306,587.67
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:17AM PAGE:76
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 CITY SERVICES RESERVE FUND ASSETS 97-11900 CASH ALLOCATION
321,000.00
TOTAL ASSETS
321,000.00
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 97-29800 BALANCE - BEGINNING OF YEAR
296,000.00
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
25,000.00 321,000.00
TOTAL FUND EQUITY
321,000.00
TOTAL LIABILITIES AND EQUITY
321,000.00
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:18AM PAGE:77
CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 1 MONTHS ENDING JULY 31, 2017 CITY SERVICES RESERVE FUND PER. ACTUAL
ACTUAL YTD
ENCUMB.
TOTAL
BUDGET
VARIANCE
%
TRANSFERS 97-39-010 TRSFR FROM GENERAL FUND
25,000.00
25,000.00
.00
25,000.00
300,000.00
275,000.00
8.3
TOTAL TRANSFERS
25,000.00
25,000.00
.00
25,000.00
300,000.00
275,000.00
8.3
TOTAL FUND REVENUE
25,000.00
25,000.00
.00
25,000.00
300,000.00
275,000.00
8.3
NET REVENUE OVER EXPENDITURES
25,000.00
25,000.00
.00
25,000.00
300,000.00
275,000.00
8.3
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:18AM PAGE:78
CITY OF MESQUITE BALANCE SHEET JULY 31, 2017 VEHICLE/EQUIP REPLACEMNT FUND ASSETS 99-11900 CASH - COMBINED FUND
430,589.81
TOTAL ASSETS
430,589.81
LIABILITIES AND EQUITY
FUND EQUITY
UNAPPROPRIATED FUND BALANCE: 99-29800 BALANCE - BEGINNING OF YEAR
430,589.81
REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE
430,589.81
TOTAL FUND EQUITY
430,589.81
TOTAL LIABILITIES AND EQUITY
430,589.81
FOR ADMINISTRATION USE ONLY
8 % OF THE FISCAL YEAR HAS ELAPSED
09/13/2017 11:18AM PAGE:79