CITY OF MESQUITE COMBINED CASH INVESTMENT AUGUST 31, 2015 COMBINED CASH ACCOUNTS 01-11120 CASH - WELLS FARGO CHECKING

1,792,223.56

01-11210 XPRESS DEPOSIT ACCOUNT

34,612.32

01-11310 CASH - PETTY CASH

1,710.00

01-11500 CASH - NEVADA STATE BANK MMF

4,422,681.27

01-11560 WELLS FARGO INVEST A/C

18,734,841.26

TOTAL COMBINED CASH

24,986,068.41

01-11900 TOTAL ALLOCATION TO OTHER FUND

( 24,986,068.41)

TOTAL UNALLOCATED CASH

.00

CASH ALLOCATION RECONCILIATION 10 ALLOCATION TO GENERAL FUND

5,729,498.90

11 ALLOCATION TO STREET MAINT. SPE

2,889,928.08

12 ALLOCATION TO AIRPORT SPECIAL R

304,419.23

13 ALLOCATION TO CAP. PROJ. MAINT/R

227,892.78

14 ALLOCATION TO POLICE FORFEITURE

178,551.76

15 ALLOCATION TO COURT ADMINISTRA

26,933.29

16 ALLOCATION TO SR. NUTRITION PRO

66,798.68

17 ALLOCATION TO RECREATION PROGR

316,886.45

19 ALLOCATION TO FORENSIC SERVICES

3,379.34

20 ALLOCATION TO RESID. CONSTR. TAX

1,002,114.78

21 ALLOCATION TO ENVIR. PLANNING SP

503,201.82

22 ALLOCATION TO TRANSPORTATION I 23 ALLOCATION TO MORE COPS SRF

2,119,840.59 (

25 ALLOCATION TO REDEVELOPMENT DI

169,381.75) 5,043,205.55

45 ALLOCATION TO CAPITAL PROJECT F

2,110,561.54

52 ALLOCATION TO SEWER FUND

1,790,892.18

81 ALLOCATION TO CANYON CREST SID 82 ALLOCATION TO ANTHEM AT MESQUI

97,091.25 (

517,956.65)

83 ALLOCATION TO SID ADMINISTRATIO

318,612.83

85 ALLOCATION TO G.O. BOND SERIES 20

1,422,752.14

87 ALLOCATION TO WASTE DISPOSAL D/

87,374.82

90 ALLOCATION TO TRUST & AGENCY F

616,496.19

98 ALLOCATION TO TECHNOLOGY RES/R

115,664.86

99 ALLOCATION TO VEHICLE/EQUIP REP

701,309.75

TOTAL ALLOCATIONS TO OTHER FUN

24,986,068.41

ALLOCATION FROM COMBINED CASH

( 24,986,068.41)

ZERO PROOF IF ALLOCATIONS BALAN

FOR ADMINISTRATION USE ONLY

.00

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:08PM PAGE:1

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 GENERAL FUND ASSETS 10-11900 CASH - COMBINED FUND

5,729,498.90

10-13100 DUE FROM STATE

590,000.00

10-13106 ROOM TAXES A/R

30,657.54

10-13107 OTHER RECEIVABLES

104,873.88

10-14000 PREPAID EXPENSE

398,604.09

TOTAL ASSETS

6,853,634.41

LIABILITIES AND EQUITY

LIABILITIES 10-21310 ACCOUNTS PAYABLE

923,059.64

10-21311 BANK SERVICE CHARGES PAYABLE

7,402.16

10-21500 WAGES PAYABLE

301,480.95

10-21700 UNION DUES W/H-REGULAR EE'S

2,975.00

10-21705 UNION DUES W/H POLICE

1,044.00

10-21710 UNION DUES W/H FIRE/RESCUE

220.00

10-22210 FICA PAYABLE

13,092.84

10-22220 WITHHELD INCOME TAXES

34,198.67

10-22250 WORKERS COMP PAYABLE

98,002.18

10-22300 ACCRUED STATE RETIREMENT

304,991.22

10-22400 VOLUNTARY LIFE INSURANCE W/H

926.21

10-22410 VOLUNTARY CANCER INSURANCE W/

220.58

10-22500 HEALTH INSURANCE PAYABLE

(

10-22505 ACCRUED HEALTH INS BONUS

78,065.05) 108,625.00

10-22520 FLEX SPEND INSURANCE W/H

4,472.78

10-22530 SUPPLMENTAL VOL INSURANCE W/H

1,490.61

10-22600 DEFERRED COMP - NATIONWIDE

6,577.50

10-22610 DEFERRED COMP - VOYA / ING

2,420.00

10-23100 GAMING TAX FOR CONV. AUTH.

150.00

10-23110 RM TXS COLL. FOR CONV AUTH 5/8

62,630.14

10-23120 RM TAXES COLL. FOR STATE 3/8

5,871.58

10-23130 TRANSIENT LODGING TRANSPORT.

15,657.54

10-23140 ROOM TAXES FOR SCHOOLS

25,443.48

10-23145 3% ROOM TAX (SCHOOLS 7/1/09)

46,972.61

10-23200 COURT FUNDS HELD

49,775.00

10-23240 COUNTY-TRANSPORT. DEVEL. FEES

19,262.50

10-24100 GARNISHMENTS W/H

979.01

TOTAL LIABILITIES

1,959,876.15

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 10-29800 BALANCE - BEGINNING OF YEAR

3,522,202.58

10-29810 RESERVE - RESOLUTION #777

1,908,280.00

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

(

536,724.32) 4,893,758.26

TOTAL FUND EQUITY

4,893,758.26

TOTAL LIABILITIES AND EQUITY

6,853,634.41

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:08PM PAGE:2

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

TAXES 10-31-100 PROPERTY TAXES

91,452.80

91,452.80

.00

91,452.80

3,140,000.00

3,048,547.20

2.9

10-31-110 ROAD RTC ROOM TAX

20,066.17

35,066.17

.00

35,066.17

200,000.00

164,933.83

17.5

10-31-200 ROOM TAXES

31,315.07

61,315.07

.00

61,315.07

400,000.00

338,684.93

15.3

TOTAL TAXES

142,834.04

187,834.04

.00

187,834.04

3,740,000.00

3,552,165.96

5.0

70,359.61

112,261.82

.00

112,261.82

540,000.00

427,738.18

20.8

500.00

500.00

.00

500.00

600.00

100.00

83.3

.00

55,000.00

.00

55,000.00

82,500.00

27,500.00

66.7

49,475.00

88,675.00

.00

88,675.00

130,000.00

41,325.00

68.2

50.00

161,430.00

.00

161,430.00

350,000.00

188,570.00

46.1

1,560.00

1,710.00

.00

1,710.00

5,000.00

3,290.00

34.2

52,449.11

106,289.99

.00

106,289.99

440,000.00

333,710.01

24.2

1,200.00

1,200.00

.00

1,200.00

.00

10-32-300 ANIMAL CONTROL FEES

875.00

2,176.00

.00

2,176.00

10,900.00

10-32-500 ZONE VARIANCE FEES

515.00

1,135.00

.00

1,135.00

.00

.00

.00

.00

305.77

305.77

.00

10-32-615 FRANCHISE FEES - CABLE SVCS

.00

.00

TOTAL LICENSES AND PERMITS

177,289.49

LICENSES AND PERMITS 10-32-100 BUSINESS LICENSES 10-32-102 MASSAGE PERMITS 10-32-105 MEDICAL MARIJUANA LICENSE FEES 10-32-110 LIQUOR LICENSES 10-32-120 GAMING LICENSES 10-32-160 VACATION RENTAL LICENSE 10-32-200 BUILDING PERMITS 10-32-250 STRUCTURE IMPACT FEES

10-32-505 PLAN REVIEW FEES 10-32-605 FRANCHISE FEES - TELEPHONE SVC

(

1,200.00)

.0

8,724.00

20.0

17,000.00

15,865.00

6.7

16,000.00

16,000.00

.0

305.77

85,000.00

84,694.23

.4

.00

.00

70,000.00

70,000.00

.0

530,683.58

.00

530,683.58

1,747,000.00

1,216,316.42

30.4

19.3

INTERGOVERNMENTAL REVENUE 10-33-140 LVCVA - ROOM & GAMING TAXES

173,513.30

173,513.30

.00

173,513.30

900,000.00

726,486.70

10-33-232 EMPG GRANT (FIRE)

.00

.00

.00

.00

30,000.00

30,000.00

.0

10-33-235 CCSD - SRO & ATHLETIC EVENTS

.00

.00

.00

.00

65,000.00

65,000.00

.0

10-33-240 TASK FORCE JAG GRANTS

25,849.50)

.00

25,849.50)

12,000.00

37,849.50

10-33-242 JOINING FORCES TRAFFIC GRANT

.00

.00

.00

.00

30,000.00

30,000.00

10-33-244 PD COMMUNITY EVENTS

.00

.00

.00

.00

2,000.00

2,000.00

.0

10-33-250 COUNTY GAMING LICENSES

.00

.00

.00

.00

365,000.00

365,000.00

.0

10-33-338 OTHER GRANTS (PD)

(

25,849.50) (

(

(215.4) .0

.00

.00

.00

.00

9,000.00

9,000.00

.0

633,257.28

1,223,257.28

.00

1,223,257.28

7,530,000.00

6,306,742.72

16.3

10-33-520 SILVER RIDER FUEL / R&M REIMB.

.00

1,500.00

.00

1,500.00

110,000.00

108,500.00

1.4

10-33-550 SPECIAL AD VALOREM TRANS. TAX

.00

.00

.00

.00

80,000.00

80,000.00

.0

700.00

700.00

.00

700.00

8,400.00

7,700.00

8.3

.00

.00

.00

.00

697,700.00

697,700.00

.0

781,621.08

1,373,121.08

.00

1,373,121.08

9,839,100.00

8,465,978.92

14.0

10-33-460 STATE CONSOLIDATED TAX

10-33-590 NDOT REIMB-WELCOME CENTER 10-33-600 REGIONAL FLOOD CONTROL, CL.CO. TOTAL INTERGOVERNMENTAL REVE

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:3

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

CHARGES FOR SERVICES 10-34-100 CEMETERY CHARGE AND SALES 10-34-205 BEAVER DAM DISPATCH SVC MOU

1,550.00

4,350.00

.00

4,350.00

11,250.00

6,900.00

38.7

.00

47,321.00

.00

47,321.00

47,800.00

479.00

99.0

10-34-300 PD - JAIL SERVICES

3,081.75

3,131.25

.00

3,131.25

.00

3,131.25)

.0

10-34-310 PD: INMATE HOUSING (NEW FY16)

4,165.00

5,735.00

.00

5,735.00

20,000.00

14,265.00

28.7

14,947.50

40,349.50

.00

40,349.50

172,000.00

131,650.50

23.5

5,948.00

5,948.00

.00

5,948.00

28,000.00

22,052.00

21.2

75,199.74

150,593.62

.00

150,593.62

750,000.00

599,406.38

20.1

225.00

540.00

.00

540.00

10,000.00

9,460.00

5.4

32.31

245,855.07

.00

245,855.07

957,000.00

711,144.93

25.7

10-34-400 RECREATION CHARGES 10-34-405 REC CENTER FEE INCREMENT " 10-34-500 AMBULANCE FEES 10-34-510 FIRE DEPT. FEES 10-34-610 RESID. GARBAGE SERVICE CHGS. 10-34-611 SANITATION SVC FUEL SURCHARGE 10-34-612 GARBAGE CAN RENTAL FEES 10-34-620 GARBAGE DUMP FEE 10-34-640 PW INSPECTIONS & FEES

(

1.17

5,487.95

.00

5,487.95

40,000.00

34,512.05

13.7

89.44

27,212.94

.00

27,212.94

108,000.00

80,787.06

25.2

29,990.13

29,990.13

.00

29,990.13

349,700.00

319,709.87

8.6

228.61

388.61

.00

388.61

3,000.00

2,611.39

13.0

10-34-660 SPECIAL EVENT FEES

.00

.00

.00

.00

200.00

200.00

.0

10-34-700 MUSEUM MISC. FEES

219.62

463.47

.00

463.47

3,000.00

2,536.53

15.5

135,678.27

567,366.54

.00

567,366.54

2,499,950.00

1,932,583.46

22.7

21,421.93

41,784.00

.00

41,784.00

310,000.00

268,216.00

13.5

175.00

525.00

.00

525.00

.00

525.00)

.0

21,596.93

42,309.00

.00

42,309.00

310,000.00

267,691.00

13.7

879.00

879.00

.00

879.00

3,500.00

2,621.00

25.1

879.00

879.00

.00

879.00

3,500.00

2,621.00

25.1

TOTAL CHARGES FOR SERVICES

FINES AND FORFEITURES 10-35-200 FINES AND FORFEITURES 10-35-300 MISC COURT FEES TOTAL FINES AND FORFEITURES

(

MISCELLANEOUS REVENUE 10-36-635 CC LIBRARY DISTRICT-WATER FEES TOTAL MISCELLANEOUS REVENUE

OTHER REVENUE 10-38-100 INTEREST EARNINGS

12,800.89)

.00

12,800.89)

67,500.00

80,300.89

( 19.0)

10-38-200 SIGN RENTAL

15,188.45 813.84

1,627.68

.00

1,627.68

9,600.00

7,972.32

17.0

10-38-230 FIRE / AMB COMMUNITY TRAINING

270.00

565.00

.00

565.00

2,000.00

1,435.00

28.3

.00

.00

.00

.00

15,000.00

15,000.00

.0

940.00

10,600.00

.00

10,600.00

.00

10,600.00)

.0

10-38-630 CITY SPECIAL EVENT FEES 10-38-700 CITY FACILITIES RENTAL FEES 10-38-701 CITY RENTAL EXPENSES

5,020.51)

.00

5,020.51)

.00

5,020.51

.0

8,640.14

.00

8,640.14

35,000.00

26,359.86

24.7

10-38-720 LEASEHOLD REVENUE

8,084.32

14,263.52

.00

14,263.52

164,000.00

149,736.48

8.7

220.00

276.50

.00

276.50

10,000.00

9,723.50

2.8

25,505.61

18,151.44

.00

18,151.44

303,100.00

284,948.56

6.0

FOR ADMINISTRATION USE ONLY

(

17 % OF THE FISCAL YEAR HAS ELAPSED

(

(

2,937.08

TOTAL OTHER REVENUE

2,948.08)

(

10-38-710 COURT FACILITY RENTAL 10-38-900 MISCELLANEOUS REVENUE

(

(

09/14/2015 06:09PM PAGE:4

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

CONTRIBUTIONS AND TRANSFERS 10-39-912 TRSFR FROM #12 AIRPORT FUND

33,333.33

66,666.66

.00

66,666.66

400,000.00

333,333.34

16.7

10-39-917 TRSFR FROM SRF#17 - REC PRGM

16,666.67

33,333.34

.00

33,333.34

200,000.00

166,666.66

16.7

10-39-919 TRSFR FROM #19 FORENSIC SVCS

208.33

416.66

.00

416.66

2,500.00

2,083.34

16.7

84,725.50

169,451.00

.00

169,451.00

1,016,706.00

847,255.00

16.7

134,933.83

269,867.66

.00

269,867.66

1,619,206.00

1,349,338.34

16.7

1,420,338.25

2,990,212.34

.00

2,990,212.34

20,061,856.00

17,071,643.66

14.9

10-39-925 TRSFR FROM #25 REDEVELOPMENT TOTAL CONTRIBUTIONS AND TRANSF

TOTAL FUND REVENUE

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:5

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

MAYOR & COUNCIL 10-41-110 SALARIES

9,288.51

13,499.30

.00

13,499.30

92,328.00

78,828.70

14.6

10-41-113 LONGEVITY PAY

.00

.00

.00

.00

210.00

210.00

.0

10-41-120 OVERTIME

.00

.00

.00

.00

125.00

125.00

.0

8,212.51

15,179.72

.00

15,179.72

95,819.00

80,639.28

15.8

10-41-130 EMPLOYEE BENEFITS 10-41-210 BOOKS, SUBSCRIPTIONS & MEMBERS 10-41-230 TRAVEL & TRAINING 10-41-240 OFFICE EXPENSE & SUPPLIES 10-41-290 TELEPHONE 10-41-310 PROFESSIONAL & TECHNICAL SVCS

.00

.00

.00

.00

9,301.00

9,301.00

.0

1,922.68

1,975.55

.00

1,975.55

7,200.00

5,224.45

27.4

42.05

42.05

.00

42.05

1,500.00

1,457.95

2.8

255.18

510.24

.00

510.24

3,050.00

2,539.76

16.7 24.3

20,416.66

46,583.32

3,000.00

49,583.32

204,500.00

154,916.68

10-41-610 MISCELLANEOUS SUPPLIES

114.85

150.85

.00

150.85

4,000.00

3,849.15

3.8

10-41-620 MISCELLANEOUS SERVICE

179.63

215.62

.00

215.62

1,000.00

784.38

21.6

TOTAL MAYOR & COUNCIL

40,432.07

78,156.65

3,000.00

81,156.65

419,033.00

337,876.35

19.4

CITY MANAGER 10-43-110 SALARIES

18,508.84

26,917.25

.00

26,917.25

159,641.00

132,723.75

16.9

10-43-112 VAC/SICK BUYOUT

.00

123.15

.00

123.15

8,745.00

8,621.85

1.4

10-43-113 LONGEVITY PAY

.00

.00

.00

.00

895.00

895.00

.0

10-43-120 OVERTIME

.00

.00

.00

.00

125.00

125.00

.0

7,343.97

11,440.84

.00

11,440.84

69,783.00

58,342.16

16.4

975.00

975.00

.00

975.00

1,600.00

625.00

60.9

.00

.00

.00

.00

5,200.00

5,200.00

.0

29.37

47.31

.00

47.31

500.00

452.69

9.5

10-43-290 TELEPHONE

100.97

201.91

.00

201.91

1,230.00

1,028.09

16.4

10-43-610 MISCELLANEOUS SUPPLIES

106.49

106.49

.00

106.49

1,500.00

1,393.51

7.1

27,064.64

39,811.95

.00

39,811.95

249,219.00

209,407.05

16.0

70,860.91

10.6

123.15)

.0

10-43-130 EMPLOYEE BENEFITS 10-43-210 BOOKS, SUBSCRIPTIONS & MEMBERS 10-43-230 TRAVEL & TRAINING 10-43-240 OFFICE EXPENSE & SUPPLIES

TOTAL CITY MANAGER

CITY CLERK 10-44-110 SALARIES

5,761.81

8,435.09

.00

8,435.09

79,296.00

10-44-112 VAC/SICK BUYOUT

.00

123.15

.00

123.15

.00

10-44-113 LONGEVITY PAY

.00

.00

.00

.00

700.00

700.00

.0

1,194.38

1,972.52

.00

1,972.52

34,150.00

32,177.48

5.8

.00

75.00

.00

75.00

1,178.00

1,103.00

6.4

357.24

843.88

.00

843.88

4,000.00

3,156.12

21.1

10-44-130 EMPLOYEE BENEFITS 10-44-210 BOOKS, SUBSCRIPTIONS & MEMBERS 10-44-220 PUBLIC NOTICES 10-44-230 TRAVEL AND TRAINING 10-44-240 OFFICE EXPENSE & SUPPLIES 10-44-290 TELEPHONE

(

.00

.00

.00

.00

1,850.00

1,850.00

.0

8.24

104.22

.00

104.22

900.00

795.78

11.6

54.68)

.00

54.68)

750.00

804.68

( 7.3)

769.34

769.34

.00

769.34

8,300.00

7,530.66

9.3

10-44-330 ELECTIONS

.00

.00

.00

.00

18,000.00

18,000.00

.0

10-44-610 OTHER SERVICES/SUPPLIES

.00

.00

.00

.00

300.00

300.00

.0

8,091.01

12,268.52

.00

12,268.52

149,424.00

137,155.48

8.2

10-44-310 PROFESSIONAL & TECHNICAL SVCS

TOTAL CITY CLERK

FOR ADMINISTRATION USE ONLY

.00

(

17 % OF THE FISCAL YEAR HAS ELAPSED

(

09/14/2015 06:09PM PAGE:6

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

FINANCE 10-46-110 SALARIES

15,367.11

22,333.53

.00

22,333.53

133,182.00

110,848.47

16.8

10-46-112 VAC/SICK BUYOUT

.00

.00

.00

.00

9,698.00

9,698.00

.0

10-46-113 LONGEVITY PAY

.00

.00

.00

.00

700.00

700.00

.0

6,466.88

10,274.48

.00

10,274.48

62,623.00

52,348.52

16.4

10-46-130 EMPLOYEE BENEFITS 10-46-210 BOOKS, SUBSCRIPTIONS & MEMBERS

.00

170.00

.00

170.00

200.00

30.00

85.0

10-46-230 TRAVEL & TRAINING

.00

850.00

.00

850.00

4,750.00

3,900.00

17.9

10-46-240 OFFICE EXPENSE & SUPPLIES

.00

.00

.00

.00

300.00

300.00

.0

5,395.32

6,112.71

.00

6,112.71

47,000.00

40,887.29

13.0

.00

.00

.00

.00

600.00

600.00

.0

27,229.31

39,740.72

.00

39,740.72

259,053.00

219,312.28

15.3

10-46-310 PROFFESSIONAL & TECHNICAL SVCS 10-46-610 MISCELLANEOUS SUPPLIES TOTAL FINANCE

INFORMATION TECHNOLOGY 10-47-110 SALARIES

28,503.04

41,424.41

.00

41,424.41

247,024.00

205,599.59

16.8

10-47-112 VAC/SICK BUYOUT

.00

.00

.00

.00

10,757.00

10,757.00

.0

10-47-113 LONGEVITY PAY

.00

.00

.00

.00

3,275.00

3,275.00

.0

12,938.39

20,976.02

.00

20,976.02

128,113.00

107,136.98

16.4

.00

.00

.00

.00

5,000.00

5,000.00

.0

655.69

1,033.75

.00

1,033.75

12,300.00

11,266.25

8.4

10-47-130 EMPLOYEE BENEFITS 10-47-230 TRAVEL & TRAINING 10-47-240 OFFICE EXPENSE & SUPPLIES 10-47-290 TELEPHONE 10-47-310 PROFFESSIONAL & TECHNICAL SVCS 10-47-740 CAPITAL OUTLAY TOTAL INFORMATION TECHNOLOGY

182.91

365.73

.00

365.73

2,500.00

2,134.27

14.6

11,173.29

175,639.37

27,636.00

203,275.37

334,600.00

131,324.63

60.8

.00

.00

.00

.00

14,000.00

14,000.00

.0

53,453.32

239,439.28

27,636.00

267,075.28

757,569.00

490,493.72

35.3

PERSONNEL 10-48-110 SALARIES

7,202.40

10,467.49

.00

10,467.49

62,421.00

51,953.51

16.8

10-48-112 VAC/SICK BUYOUT

.00

.00

.00

.00

5,883.00

5,883.00

.0

10-48-113 LONGEVITY PAY

.00

.00

.00

.00

1,625.00

1,625.00

.0

3,253.44

5,273.89

.00

5,273.89

32,508.00

27,234.11

16.2

10-48-130 EMPLOYEE BENEFITS 10-48-210 BOOKS, SUBSCRIPTIONS & MEMBERS

.00

1,039.50

.00

1,039.50

1,500.00

460.50

69.3

133.29

133.29

.00

133.29

1,000.00

866.71

13.3

.00

.00

.00

.00

2,400.00

2,400.00

.0

7.91

61.87

.00

61.87

1,100.00

1,038.13

5.6

121.91

121.91

.00

121.91

650.00

528.09

18.8

.00

.00

.00

.00

1,000.00

1,000.00

.0

10-48-620 PERSONNEL COSTS

253.65

253.65

.00

253.65

2,200.00

1,946.35

11.5

TOTAL PERSONNEL

10,972.60

17,351.60

.00

17,351.60

112,287.00

94,935.40

15.5

10-48-220 PUBLIC NOTICES 10-48-230 TRAVEL & TRAINING 10-48-240 OFFICE EXPENSE & SUPPLIES 10-48-290 TELEPHONE 10-48-310 PROFESSIONAL & TECHNICAL SVCS

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:7

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

NON-DEPARTMENTAL 10-49-130 BENEFITS ADJUSTMENT 10-49-240 OFFICE EXPENSE & SUPPLIES 10-49-250 EQUIPMENT SUPPLIES & MAINT NC

.00 (

265.20)

(

815.20

.00

776.08)

.00

(

815.20

15,000.00

14,184.80

5.4

776.08)

6,500.00

7,276.08

( 11.9)

2,771.00

8,592.40

.00

8,592.40

46,250.00

37,657.60

18.6

.00

1,227.41

.00

1,227.41

35,000.00

33,772.59

3.5

10-49-280 UTILITIES

5,818.44

7,504.44

.00

7,504.44

1,002,000.00

994,495.56

.8

10-49-290 TELEPHONE

3,795.77

7,195.93

.00

7,195.93

45,300.00

38,104.07

15.9

10-49-510 INSURANCE

23,776.90

48,423.80

.00

48,423.80

387,500.00

339,076.20

12.5

177.71

199.66

.00

199.66

1,500.00

1,300.34

13.3

.00

.00

.00

.00

3,525.00

7,050.00

.00

7,050.00

10-49-270 UTILITIES (CITY SANITATION)

10-49-610 SERVICE, SUPPLIES & OTHER 10-49-690 EXP DISTRIBUTION TO OTHER DEPT 10-49-691 DISTR EXP: FACILITIES MAINT 10-49-692 DIST EXP: SOLID WASTE

( 1,026,890.00) ( 1,026,890.00) 42,300.00

35,250.00

.0 16.7

91.67

183.34

.00

183.34

1,100.00

916.66

16.7

10-49-693 DIST EXP: VEHICLE MAINT

883.33

1,766.66

.00

1,766.66

10,600.00

8,833.34

16.7

10-49-695 BANK/ CREDIT CARD CHARGES

834.59

2,137.50

.00

2,137.50

13,500.00

11,362.50

15.8

41,409.21

84,320.26

.00

84,320.26

579,660.00

495,339.74

14.6

TOTAL NON-DEPARTMENTAL

CITY ATTORNEY 10-50-110 SALARIES

19,563.45

28,278.72

.00

28,278.72

165,160.00

136,881.28

17.1

10-50-112 VAC/SICK BUYOUT

.00

.00

.00

.00

4,644.00

4,644.00

.0

10-50-113 LONGEVITY PAY

.00

.00

.00

.00

2,000.00

2,000.00

.0

8,706.09

15,730.09

.00

15,730.09

93,705.00

77,974.91

16.8

536.64

546.64

.00

546.64

8,375.00

7,828.36

6.5

39.76

763.48

.00

763.48

4,000.00

3,236.52

19.1

10-50-130 EMPLOYEE BENEFITS 10-50-210 BOOKS, SUBSCRIPTIONS & MEMBERS 10-50-230 TRAVEL & TRAINING 10-50-240 OFFICE EXPENSE & SUPPLIES

42.30

102.65

.00

102.65

600.00

497.35

17.1

10-50-290 TELEPHONE

60.97

121.91

.00

121.91

1,800.00

1,678.09

6.8

741.00

741.00

.00

741.00

8,700.00

7,959.00

8.5

29,690.21

46,284.49

.00

46,284.49

288,984.00

242,699.51

16.0

10-50-310 PROFESSIONAL & TECHNICAL SVCS TOTAL CITY ATTORNEY

JUDICIAL / MUNICIPAL COURT 10-51-110 SALARIES

17,940.13

26,278.78

.00

26,278.78

163,138.00

136,859.22

16.1

10-51-112 VAC/SICK BUYOUT

.00

.00

.00

.00

9,827.00

9,827.00

.0

10-51-113 LONGEVITY PAY

.00

.00

.00

.00

5,700.00

5,700.00

.0

152.19

152.19

.00

152.19

1,200.00

1,047.81

12.7

10-51-130 EMPLOYEE BENEFITS

8,740.05

14,380.21

.00

14,380.21

91,200.00

76,819.79

15.8

10-51-210 BOOKS, SUBSCRIPTIONS & MEMBERS

6,000.00

6,000.00

.00

6,000.00

100.00

10-51-120 OVERTIME

10-51-240 OFFICE EXPENSE & SUPPLIES 10-51-310 PROFESSIONAL & TECHNICAL SVCS 10-51-610 MISCELLANEOUS SUPPLIES

(

5,900.00) 6000.0

83.74

465.19

.00

465.19

2,800.00

2,334.81

16.6

3,077.98

4,386.98

.00

4,386.98

38,580.00

34,193.02

11.4

73.18

73.18

.00

73.18

750.00

676.82

9.8

10-51-691 DISTR EXP: FACILITIES MAINT

495.83

991.66

.00

991.66

5,950.00

4,958.34

16.7

10-51-695 BANK / CREDIT CARD CHARGES

654.20

652.26

.00

652.26

5,000.00

4,347.74

13.1

37,217.30

53,380.45

.00

53,380.45

324,245.00

270,864.55

16.5

TOTAL JUDICIAL / MUNICIPAL COURT

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:8

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

POLICE 10-54-110 SALARIES

187,149.02

275,693.10

.00

275,693.10

1,744,195.00

1,468,501.90

10-54-112 VAC/SICK BUYOUT

3,051.20

3,051.20

.00

3,051.20

118,896.00

115,844.80

2.6

10-54-113 LONGEVITY PAY

2,150.00

5,275.00

.00

5,275.00

34,000.00

28,725.00

15.5

.00

2,000.00

.00

2,000.00

40,000.00

38,000.00

5.0

1,350.00

2,250.00

.00

2,250.00

11,050.00

8,800.00

20.4

10-54-115 UNIFORM ALLOWANCE 10-54-116 EDUCATION ASSISTANCE PAY 10-54-120 OVERTIME

15.8

17,347.01

21,334.48

.00

21,334.48

80,000.00

58,665.52

26.7

113,186.90

231,313.55

.00

231,313.55

1,156,032.00

924,718.45

20.0

.00

.00

.00

.00

1,500.00

1,500.00

.0

10-54-230 TRAVEL & TRAINING

2,943.07

5,310.25

.00

5,310.25

24,000.00

18,689.75

22.1

10-54-240 OFFICE EXPENSES & SUPPLIES

1,103.28

1,288.05

.00

1,288.05

8,700.00

7,411.95

14.8

755.35

1,158.35

.00

1,158.35

17,800.00

16,641.65

6.5

.00

.00

.00

.00

11,050.00

11,050.00

.0

75.12

126.31

.00

126.31

1,200.00

1,073.69

10.5

10-54-130 EMPLOYEE BENEFITS 10-54-210 BOOKS, SUBSCRIPTIONS & MEMBERS

10-54-250 EQUIPMENT SUPPLIES & MAIN NC 10-54-260 EQUIPMENT (NON-CAPITALIZED) 10-54-280 UTILITIES 10-54-290 TELEPHONE

1,159.78

2,319.02

.00

2,319.02

18,200.00

15,880.98

12.7

10-54-310 PROFESSIONAL & TECHNICAL SVCS

1,691.10

10,527.46

.00

10,527.46

38,900.00

28,372.54

27.1

10-54-320 GENERAL HEALTH SERVICES

1,617.68

2,067.68

.00

2,067.68

16,175.00

14,107.32

12.8

10-54-610 MISCELLANEOUS SUPPLIES

2,037.10

3,761.80

.00

3,761.80

35,650.00

31,888.20

10.6

1,050.00

12.5

10-54-620 MISC SERVICES 10-54-625 GRANT EXPENDITURES 10-54-691 DISTR EXP: FACILITIES MAINT 10-54-692 DIST EXP: SOLID WASTE

150.00

150.00

.00

150.00

1,200.00

19,254.32

21,893.99

.00

21,893.99

.00

1,966.67

3,933.34

.00

3,933.34

23,600.00

(

21,893.99)

.0

19,666.66

16.7

114.58

229.16

.00

229.16

1,375.00

1,145.84

16.7

11,625.00

23,250.00

.00

23,250.00

139,500.00

116,250.00

16.7

6,336.23

8,716.75

.00

8,716.75

82,530.00

73,813.25

10.6

950.00

950.00

.00

950.00

.00

4,622.95

4,622.95

.00

4,622.95

.00

.00

.00

.00

380,636.36

631,222.44

.00

631,222.44

42,182.14

61,500.04

.00

3,058.40

3,058.40

.00

10-55-113 LONGEVITY PAY

.00

.00

.00

.00

10-55-115 UNIFORM ALLOWANCE

.00

.00

.00

.00

375.00

625.00

.00

625.00

3,250.00

10-54-693 DIST EXP: VEHICLE MAINT 10-54-694 DIST EXP: WATER/POWER/SANI 10-54-700 ARRA / CLV JAG EXPENDITURES 10-54-740 CAPITAL OUTLAY 10-54-799 TRSFR TO VEH/EQUIP REPL FUND TOTAL POLICE

950.00)

.0

129,074.00

124,451.05

3.6

129,074.00) (

129,074.00)

.0

3,605,553.00

2,974,330.56

17.5

61,500.04

438,573.00

377,072.96

14.0

3,058.40

11,759.00

8,700.60

26.0

8,425.00

8,425.00

.0

14,000.00

14,000.00

.0

2,625.00

19.2

(

(

PD - CORRECTIONS DIVISION 10-55-110 SALARIES 10-55-112 VAC/SICK BUYOUT

10-55-116 EDUCATION ASSISTANCE PAY 10-55-120 OVERTIME

2,394.36

3,204.25

.00

3,204.25

15,000.00

11,795.75

21.4

10-55-130 EMPLOYEE BENEFITS

28,785.31

46,686.77

.00

46,686.77

314,892.00

268,205.23

14.8

10-55-230 TRAVEL & TRAINING

96.00

96.00

.00

96.00

1,500.00

1,404.00

6.4

10-55-240 OFFICE EXPENSE & SUPPLIES

42.47

42.47

.00

42.47

500.00

457.53

8.5

5,000.00

5,000.00

.00

5,000.00

8,150.00

3,150.00

61.4

.00

.00

.00

.00

4,075.00

4,075.00

.0

77.88

408.51

.00

408.51

16,100.00

15,691.49

2.5

4,290.05

9,264.47

.00

9,264.47

35,400.00

26,135.53

26.2

129.17

258.34

.00

258.34

1,550.00

1,291.66

16.7

62.50

125.00

.00

125.00

750.00

625.00

16.7

3,922.03

5,498.61

.00

5,498.61

40,900.00

35,401.39

13.4

90,415.31

135,767.86

.00

135,767.86

914,824.00

779,056.14

14.8

10-55-310 PROFESSIONAL & TECHINICAL SVCS 10-55-320 PROFESSIONAL & TECHNICAL SVCS 10-55-610 MISC SUPP - C & C PRISONERS 10-55-620 MISC SVCS - C & C OF PRISONERS 10-55-691 DISTR EXP: FACILITIES MAINT 10-55-692 DIST EXP: SOLID WASTE 10-55-694 DIST EXP: WATER/POWER/SANI TOTAL PD - CORRECTIONS DIVISION

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:9

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

PD - DISPATCH DIVISION 10-56-110 SALARIES

36,122.08

52,061.22

.00

52,061.22

379,522.00

327,460.78

10-56-112 VAC/SICK BUYOUT

.00

.00

.00

.00

6,520.00

6,520.00

.0

10-56-113 LONGEVITY PAY

.00

.00

.00

.00

10,975.00

10,975.00

.0

8,717.98

13,104.09

.00

13,104.09

45,000.00

31,895.91

29.1

20,613.52

32,855.43

.00

32,855.43

237,712.00

204,856.57

13.8

10-56-120 OVERTIME 10-56-130 EMPLOYEE BENEFITS 10-56-230 TRAVEL & TRAINING 10-56-310 PROFESSIONAL & TECHNICAL SVCS 10-56-610 MISCELLANOUS SUPPLIES TOTAL PD - DISPATCH DIVISION

.00

1,010.00

.00

1,010.00

3,400.00

1,081.36

1,081.36

.00

1,081.36

.00

.00

.00

.00

.00

66,534.94

100,112.10

.00

13.7

2,390.00

29.7

1,081.36)

.0

4,000.00

4,000.00

.0

100,112.10

687,129.00

587,016.90

14.6

(

FIRE / RESCUE 10-57-110 SALARIES

174,415.34

258,761.50

.00

258,761.50

1,746,698.00

1,487,936.50

14.8

10-57-112 VAC/SICK BUYOUT

7,938.09

7,938.09

.00

7,938.09

27,589.00

19,650.91

28.8

10-57-113 LONGEVITY PAY

3,500.00

6,125.00

.00

6,125.00

23,525.00

17,400.00

26.0

.00

3,630.00

.00

3,630.00

.00

27,987.30

35,964.56

.00

35,964.56

115,098.81

192,041.31

.00

377.25

471.05

.00

312.30)

1,061.88

73.60

10-57-115 UNIFORM ALLOWANCE

3,630.00)

.0

196,503.00

160,538.44

18.3

192,041.31

1,166,369.00

974,327.69

16.5

471.05

6,000.00

5,528.95

7.9

.00

1,061.88

97,500.00

96,438.12

1.1

146.26

.00

146.26

3,500.00

3,353.74

4.2

6,263.61

9,835.97

14,045.00

23,880.97

82,600.00

58,719.03

28.9

.00

.00

.00

.00

13,500.00

13,500.00

.0

515.14

1,024.73

.00

1,024.73

11,200.00

10,175.27

9.2

7,077.80

7,116.70

.00

7,116.70

71,470.00

64,353.30

10.0

208.00

208.00

.00

208.00

14,000.00

13,792.00

1.5

10-57-610 MISCELLANOUS SUPPLIES

1,050.13

1,497.46

.00

1,497.46

25,750.00

24,252.54

5.8

10-57-615 EMS SUPPLIES

3,346.27

9,179.39

.00

9,179.39

61,000.00

51,820.61

15.1

.00

.00

.00

.00

1,200.00

1,200.00

.0

825.00

1,650.00

.00

1,650.00

9,900.00

8,250.00

16.7

10-57-120 OVERTIME 10-57-130 EMPLOYEE BENEFITS 10-57-210 BOOKS, SUBSCRIPTIONS & MEMBERS 10-57-230 TRAVEL & TRAINING 10-57-240 OFFICE EXPENSE & SUPPLIES 10-57-250 EQUIPMENT SUPPLIES & MAINT NC 10-57-280 UTILITIES - AMERIGAS, ETC 10-57-290 TELEPHONE 10-57-310 PROFESSIONAL & TECHNICAL SVCS 10-57-320 GENERAL HEALTH SERVICES

10-57-620 MISC SERVICES 10-57-691 DISTR EXP: FACILITIES MAINT 10-57-692 DIST EXP: SOLID WASTE

(

(

174.17

348.34

.00

348.34

2,090.00

1,741.66

16.7

10-57-693 DIST EXP: VEHICLE MAINT

5,808.33

11,616.66

.00

11,616.66

69,700.00

58,083.34

16.7

10-57-694 DIST EXP: WATER/POWER/SANI

3,448.25

4,155.53

.00

4,155.53

38,430.00

34,274.47

10.8

10-57-695 BANK/ CREDIT CARD CHARGES

622.19

1,212.62

.00

1,212.62

5,400.00

4,187.38

22.5

27,584.52

27,584.52

300.00

27,884.52

30,000.00

2,115.48

93.0

386,001.50

581,569.57

14,345.00

595,914.57

3,703,924.00

3,108,009.43

16.1

10-57-703 EMPG GRANT EXPENDITURES TOTAL FIRE / RESCUE

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:10

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

PUBLIC WORKS 10-60-110 SALARIES

9,174.55

13,333.68

.00

13,333.68

79,513.00

66,179.32

16.8

10-60-112 VAC/SICK BUYOUT

.00

.00

.00

.00

5,166.00

5,166.00

.0

10-60-113 LONGEVITY PAY

.00

.00

.00

.00

1,481.00

1,481.00

.0

10-60-115 UNIFORM ALLOWANCE

.00

37.50

.00

37.50

38.00

.50

98.7

10-60-120 OVERTIME

.00

.00

.00

.00

1,000.00

1,000.00

.0

10-60-130 EMPLOYEE BENEFITS

3,843.46

5,908.75

.00

5,908.75

37,504.00

31,595.25

15.8

10-60-230 TRAVEL & TRAINING

.00

.00

.00

.00

200.00

200.00

.0

10-60-260 EQUIPMENT

.00

.00

.00

.00

1,000.00

1,000.00

.0

298.65

482.47

.00

482.47

2,100.00

1,617.53

23.0

10-60-310 PROFESSIONAL & TECHNICAL SVCS 10-60-320 GRNERAL HEALTH SERVICES 10-60-610 MISCELLANOUS SUPPLIES

(

TOTAL PUBLIC WORKS

.00

.00

.00

.00

500.00

500.00

.0

593.95)

316.01

.00

316.01

1,600.00

1,283.99

19.8

12,722.71

20,078.41

.00

20,078.41

130,102.00

110,023.59

15.4

27,328.64

40,684.80

.00

40,684.80

241,685.00

201,000.20

16.8

1,709.32

1,709.32

.00

1,709.32

13,141.00

11,431.68

13.0

DEVELOPMENT SERVICES 10-61-110 SALARIES 10-61-112 VAC/SICK BUYOUT 10-61-113 LONGEVITY PAY 10-61-120 OVERTIME 10-61-130 EMPLOYEE BENEFITS

.00

.00

.00

.00

7,310.00

7,310.00

.0

188.46

188.46

.00

188.46

500.00

311.54

37.7

12,406.19

20,091.12

.00

20,091.12

123,736.00

103,644.88

16.2

10-61-210 BOOKS, SUBSCRIPTIONS & MEMBERS

.00

.00

.00

.00

2,540.00

2,540.00

.0

10-61-220 PUBLIC NOTICES

.00

.00

.00

.00

2,000.00

2,000.00

.0

10-61-230 TRAVEL & TRAINING

.00

443.22)

.00

443.22)

670.00

1,113.22

( 66.2)

10-61-240 OFFICE EXPENSE & SUPPLIES 10-61-290 TELEPHONE 10-61-310 PROFFESSIONAL & TECHNICAL SVCS 10-61-610 MISCELLANEOUS SUPPLIES TOTAL DEVELOPMENT SERVICES

(

(

133.49

305.21

.00

305.21

3,500.00

3,194.79

8.7

84.21

168.36

.00

168.36

1,200.00

1,031.64

14.0

.00

.00

.00

.00

3,150.00

3,150.00

.0

114.75

114.75

.00

114.75

5,300.00

5,185.25

2.2

41,965.06

62,818.80

.00

62,818.80

404,732.00

341,913.20

15.5

FACILITY MAINTENANCE 10-63-110 SALARIES

19,987.46

29,140.97

.00

29,140.97

174,994.00

145,853.03

16.7

10-63-112 VAC/SICK BUYOUT

.00

.00

.00

.00

6,052.00

6,052.00

.0

10-63-113 LONGEVITY PAY

.00

.00

.00

.00

7,325.00

7,325.00

.0

10-63-115 UNIFORM ALLOWANCE

.00

1,200.00

.00

1,200.00

1,200.00

.00

100.0

479.64

479.64

.00

479.64

2,800.00

2,320.36

17.1

9,343.40

15,228.43

.00

15,228.43

94,523.00

79,294.57

16.1

.00

.00

.00

.00

800.00

800.00

.0

4,297.00

4,986.53

.00

4,986.53

45,000.00

40,013.47

11.1

10-63-120 OVERTIME 10-63-130 EMPLOYEE BENEFITS 10-63-230 TRAVEL & TRAINING 10-63-250 EQUIPMENT SUPPLIES & MAINT NC 10-63-280 UTILITIES

.00

.00

.00

.00

18,000.00

18,000.00

.0

111.94

226.43

.00

226.43

1,350.00

1,123.57

16.8

10-63-310 PROFESSIONAL & TECHNICAL SVCS

13,184.30

15,977.20

.00

15,977.20

73,500.00

57,522.80

21.7

10-63-610 MISCELLANEOUS SUPPLIES

12,173.84

16,340.80

.00

16,340.80

72,000.00

55,659.20

22.7

16,129.17) (

32,258.34)

.00

10-63-290 TELEPHONE

10-63-690 EXP DISTRIBUTION TO OTHER DEPT

(

(

32,258.34) (

193,550.00) (

161,291.66) ( 16.7)

10-63-693 DIST EXP: VEHICLE MAINT

383.33

766.66

.00

766.66

4,600.00

3,833.34

16.7

10-63-694 DIST EXP: WATER/POWER/SANI

189.53

189.53

.00

189.53

450.00

260.47

42.1

44,021.27

52,277.85

.00

52,277.85

309,044.00

256,766.15

16.9

TOTAL FACILITY MAINTENANCE

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:11

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

STREETS & DRAINAGE 10-65-110 SALARIES

41,797.28

60,689.53

.00

60,689.53

325,306.00

264,616.47

10-65-112 VAC/SICK BUYOUT

.00

.00

.00

.00

13,867.00

13,867.00

.0

10-65-113 LONGEVITY PAY

.00

.00

.00

.00

10,700.00

10,700.00

.0 100.0

10-65-115 UNIFORM ALLOWANCE 10-65-120 OVERTIME 10-65-130 EMPLOYEE BENEFITS 10-65-230 TRAVEL & TRAINING 10-65-250 EQUIPMENT SUPPLIES & MAINT NC 10-65-280 ELECTRICITY - STREET LIGHTS 10-65-290 TELEPHONE 10-65-480 DRAINAGE MAINTENANCE

18.7

.00

2,400.00

.00

2,400.00

2,400.00

.00

84.36

114.73

.00

114.73

2,500.00

2,385.27

4.6

17,491.88

28,828.15

.00

28,828.15

173,428.00

144,599.85

16.6

.00

58.25

.00

58.25

1,500.00

1,441.75

3.9

3,915.25

4,812.76

.00

4,812.76

35,000.00

30,187.24

13.8

18,113.01

18,113.01

.00

18,113.01

256,000.00

237,886.99

7.1

101.94

203.82

.00

203.82

1,200.00

996.18

17.0 62.9

406,195.58

407,935.58

19,700.00

427,635.58

679,700.00

252,064.42

10-65-610 MISCELLANEOUS SUPPLIES

4,655.06

5,059.06

.00

5,059.06

23,000.00

17,940.94

22.0

10-65-615 LOCAL DRAINAGE MAINTENANCE

3,010.00

3,010.00

.00

3,010.00

18,000.00

14,990.00

16.7

10-65-691 DISTR EXP: FACILITIES MAINT

316.67

633.34

.00

633.34

3,800.00

3,166.66

16.7

10-65-692 DIST EXP: SOLID WASTE

258.33

516.66

.00

516.66

3,100.00

2,583.34

16.7

10-65-693 DIST EXP: VEHICLE MAINT

3,608.33

7,216.66

.00

7,216.66

43,300.00

36,083.34

16.7

10-65-694 DIST EXP: WATER/POWER/SANI

2,074.07

2,503.58

.00

2,503.58

14,275.00

11,771.42

17.5

501,621.76

542,095.13

19,700.00

561,795.13

1,607,076.00

1,045,280.87

35.0

99,128.99

16.0

1,408.54)

.0

TOTAL STREETS & DRAINAGE

VEHICLE MAINTENANCE 10-66-110 SALARIES

12,923.05

18,907.01

.00

18,907.01

118,036.00

10-66-112 VAC/SICK BUYOUT

.00

1,408.54

.00

1,408.54

.00

10-66-113 LONGEVITY PAY

.00

.00

.00

.00

1,700.00

1,700.00

.0

10-66-115 UNIFORM ALLOWANCE

.00

300.00

.00

300.00

300.00

.00

100.0

10-66-120 OVERTIME

(

30.36

230.90

.00

230.90

1,000.00

769.10

23.1

10-66-130 EMPLOYEE BENEFITS

6,817.81

13,322.79

.00

13,322.79

75,871.00

62,548.21

17.6

10-66-230 TRAVEL & TRAINING

.00

.00

.00

.00

1,000.00

1,000.00

.0

10-66-240 OFFICE EXPENSES & SUPPLIES

.00

14.79

.00

14.79

1,000.00

985.21

1.5

10-66-250 VEHICLE MAINTENANCE

14,540.88

17,450.21

.00

17,450.21

104,200.00

86,749.79

16.8

10-66-255 FUEL

38,589.84

29,668.62

.00

29,668.62

260,000.00

230,331.38

11.4

10-66-260 EQUIPMENT

.00

.00

.00

.00

1,000.00

1,000.00

.0

10-66-310 PROFESSIONAL & TECHNICAL SVCS

.00

.00

.00

.00

3,000.00

3,000.00

.0

10-66-480 VEH MAINT & FUEL-SILVER RIDER

9,215.70

17,072.68

.00

17,072.68

110,000.00

92,927.32

15.5

10-66-610 SERVICES AND SUPPLIES

1,556.99

1,852.33

.00

1,852.33

12,000.00

10,147.67

15.4

10-66-690 EXP DISTRIBUTION TO OTHER DEPT 10-66-691 DISTR EXP: FACILITIES MAINT 10-66-692 DIST EXP: SOLID WASTE 10-66-694 DIST EXP: WATER/POWER/SANI TOTAL VEHICLE MAINTENANCE

FOR ADMINISTRATION USE ONLY

(

29,075.00) (

58,150.00)

.00

58,150.00) (

348,900.00) (

200.00

400.00

.00

400.00

2,400.00

2,000.00

16.7

75.00

150.00

.00

150.00

900.00

750.00

16.7

224.50

697.51

.00

697.51

16,735.00

16,037.49

4.2

55,099.13

43,325.38

.00

43,325.38

360,242.00

316,916.62

12.0

17 % OF THE FISCAL YEAR HAS ELAPSED

(

290,750.00) ( 16.7)

09/14/2015 06:09PM PAGE:12

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

ANIMAL CONTROL 10-70-110 SALARIES

13,065.08

19,617.37

.00

19,617.37

126,015.00

106,397.63

15.6

10-70-112 VAC/SICK BUYOUT

.00

.00

.00

.00

5,975.00

5,975.00

.0

10-70-113 LONGEVITY PAY

.00

.00

.00

.00

1,875.00

1,875.00

.0

2,000.00

2,000.00

.00

2,000.00

.00

168.93

168.93

.00

168.93

10-70-115 UNIFORM ALLOWANCE 10-70-120 OVERTIME 10-70-130 EMPLOYEE BENEFITS

(

2,000.00)

.0

4,000.00

3,831.07

4.2

6,007.52

9,933.64

.00

9,933.64

62,459.00

52,525.36

15.9

10-70-210 BOOKS, SUBSCRIPTIONS & MEMBERS

.00

.00

.00

.00

650.00

650.00

.0

10-70-230 TRAVEL & TRAINING

.00

.00

.00

.00

1,375.00

1,375.00

.0

109.34

217.43

.00

217.43

1,300.00

1,082.57

16.7 8.7

10-70-290 TELEPHONE 10-70-310 PROFESSIONAL & TECHNICAL SVCS 10-70-610 SERVICES AND SUPPLIES 10-70-691 DISTR EXP: FACILITIES MAINT 10-70-692 DIST EXP: SOLID WASTE

551.92

1,131.17

.00

1,131.17

13,000.00

11,868.83

1,639.90

1,198.22

.00

1,198.22

19,830.00

18,631.78

6.0

100.00

200.00

.00

200.00

1,200.00

1,000.00

16.7

64.58

129.16

.00

129.16

775.00

645.84

16.7

10-70-693 DIST EXP: VEHICLE MAINT

791.67

1,583.34

.00

1,583.34

9,500.00

7,916.66

16.7

10-70-694 DIST EXP: WATER/POWER/SANI

634.78

735.18

.00

735.18

7,800.00

7,064.82

9.4

25,133.72

36,914.44

.00

36,914.44

255,754.00

218,839.56

14.4

499.51

590.49

.00

590.49

2,000.00

1,409.51

29.5

.00

.00

.00

.00

807,300.00

807,300.00

.0

11,454.71

11,454.71

12,902.50

24,357.21

69,400.00

45,042.79

35.1

28,000.00

28,000.00

.0

38,540.00) (

32,116.66) ( 16.7)

TOTAL ANIMAL CONTROL

LANDFILL/SOLID WASTE 10-73-250 EQUIPMENT SUPPLIES & MAINT NC 10-73-260 SOLID WASTE COLLECTION EXPENSE 10-73-310 PROFESSIONAL & TECHNICAL SVCS 10-73-610 MISCELLANEOUS SUPPLIES 10-73-690 EXP DISTRIBUTION TO OTHER DEPT TOTAL LANDFILL/SOLID WASTE

.00 (

.00

.00

6,423.34)

.00

8,742.55

5,621.86

12,902.50

18,524.36

868,160.00

849,635.64

2.1

3,211.67)

(

.00 (

6,423.34)

(

PARKS/GROUNDS MAINT. 10-76-110 SALARIES

43,474.70

62,045.77

.00

62,045.77

399,936.00

337,890.23

15.5

10-76-112 VAC/SICK BUYOUT

.00

.00

.00

.00

12,145.00

12,145.00

.0

10-76-113 LONGEVITY PAY

.00

.00

.00

.00

9,375.00

9,375.00

.0

10-76-115 UNIFORM ALLOWANCE

.00

3,200.00

.00

3,200.00

3,600.00

400.00

88.9

10-76-120 OVERTIME

401.13

412.60

.00

412.60

10,000.00

9,587.40

4.1

10-76-130 EMPLOYEE BENEFITS

21,483.84

35,957.01

.00

35,957.01

236,633.00

200,675.99

15.2

10-76-230 TRAVEL & TRAINING

.00

.00

.00

.00

800.00

800.00

.0

10-76-250 EQUIPMENT SUPPLIES MAINT NC

.00

576.37

.00

576.37

12,000.00

11,423.63

4.8

10-76-290 TELEPHONE

121.94

243.97

.00

243.97

1,300.00

1,056.03

18.8

5,232.90

8,346.85

5,200.00

13,546.85

67,228.00

53,681.15

20.2

31,170.30

49,289.98

43,592.50

92,882.48

147,500.00

54,617.52

63.0

10-76-691 DISTR EXP: FACILITIES MAINT

1,370.83

2,741.66

.00

2,741.66

16,450.00

13,708.34

16.7

10-76-692 DIST EXP: SOLID WASTE

1,875.00

3,750.00

.00

3,750.00

22,500.00

18,750.00

16.7

10-76-693 DIST EXP: VEHICLE MAINT

4,500.00

9,000.00

.00

9,000.00

54,000.00

45,000.00

16.7

57,293.28

109,680.27

.00

109,680.27

498,900.00

389,219.73

22.0

10-76-740 CAPITAL OUTLAY

.00

.00

.00

.00

10-76-799 TRSFR TO VEH/EQUIP REPL FUND

.00

.00

.00

.00

TOTAL PARKS/GROUNDS MAINT.

166,923.92

285,244.48

48,792.50

334,036.98

10-76-310 PROFESSIONAL & TECHNICAL SVCS 10-76-610 MISCELLANEOUS SUPPLIES

10-76-694 DIST EXP: WATER/POWER/SANI

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

(

25,000.00

25,000.00

.0

25,000.00) (

25,000.00)

.0

1,158,330.02

22.4

1,492,367.00

09/14/2015 06:09PM PAGE:13

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

LEISURE SERVICES 10-81-110 SALARIES

42,942.48

64,007.58

.00

64,007.58

404,120.00

340,112.42

15.8

10-81-112 VAC/SICK BUYOUT

.00

.00

.00

.00

20,052.00

20,052.00

.0

10-81-113 LONGEVITY PAY

.00

.00

.00

.00

8,775.00

8,775.00

.0

10-81-120 OVERTIME

.00

.00

.00

.00

5,000.00

5,000.00

.0

16,939.97

29,605.19

.00

29,605.19

164,467.00

134,861.81

18.0 .0

10-81-130 EMPLOYEE BENEFITS 10-81-210 BOOKS, SUBSCRIPTIONS & MEMBERS

.00

.00

.00

.00

600.00

600.00

10-81-230 TRAVEL & TRAINING

.00

.00

.00

.00

7,000.00

7,000.00

.0

293.78

293.78

.00

293.78

6,500.00

6,206.22

4.5 15.1

10-81-240 OFFICE EXPENSE & SUPPLIES 10-81-250 EQUIPMENT SUPPLIES & MAINT NC

1,618.56

4,690.75

.00

4,690.75

31,000.00

26,309.25

10-81-280 UTILITIES

872.73

950.65

.00

950.65

11,000.00

10,049.35

8.6

10-81-290 TELEPHONE

152.91

505.96

.00

505.96

1,500.00

994.04

33.7

10-81-310 PROFESSIONAL & TECHNICAL SVCS 10-81-480 ATHLETIC MARKETING 10-81-485 PRESCHOOL 10-81-490 CITY SPONSORED EVENTS 10-81-610 MISCELLANEOUS SUPPLIES

(

119.70

179.55

.00

179.55

720.00

540.45

24.9

1,083.00

1,083.00

.00

1,083.00

47,000.00

45,917.00

2.3

354.00)

.00

.00

.00

.00

.00

.0

.00

215.45

.00

215.45

12,500.00

12,284.55

1.7 37.9

3,081.40

10,032.74

.00

10,032.74

26,500.00

16,467.26

10-81-620 MISCELLANEOUS SERVICE

.00

.00

.00

.00

2,500.00

2,500.00

.0

10-81-650 REC FEE INCREMENT SPENDING *

.00

.00

.00

.00

34,091.00

34,091.00

.0

5,416.67

10,833.34

.00

10,833.34

65,000.00

54,166.66

16.7

241.67

483.34

.00

483.34

2,900.00

2,416.66

16.7

10-81-691 DISTR EXP: FACILITIES MAINT 10-81-692 DIST EXP: SOLID WASTE 10-81-693 DIST EXP: VEHICLE MAINT

416.67

833.34

.00

833.34

5,000.00

4,166.66

16.7

20,849.66

27,424.11

.00

27,424.11

266,750.00

239,325.89

10.3

93,675.20

151,138.78

.00

151,138.78

1,122,975.00

971,836.22

13.5

10-82-110 SALARIES

3,631.70

5,351.81

.00

5,351.81

31,931.00

26,579.19

16.8

10-82-130 EMPLOYEE BENEFITS

1,669.76

2,966.32

.00

2,966.32

20,769.00

17,802.68

14.3

10-82-210 BOOKS, SUBSCRIPTIONS & MEMBER

.00

.00

.00

.00

150.00

150.00

.0

10-82-230 TRAVEL & TRAINING

.00

.00

.00

.00

600.00

600.00

.0

10-81-694 DIST EXP: WATER/POWER/SANI TOTAL LEISURE SERVICES

MUSEUM

10-82-240 OFFICE EXPENSE AND SUPPLIES 10-82-610 SERVICES AND SUPPLIES

.00

.00

.00

.00

300.00

300.00

.0

12.29

30.79

.00

30.79

3,400.00

3,369.21

.9

10-82-620 MISCELLANEOUS SERVICES

475.90

497.85

.00

497.85

1,200.00

702.15

41.5

10-82-691 DISTR EXP: FACILITIES MAINT

125.00

250.00

.00

250.00

1,500.00

1,250.00

16.7

10-82-692 DIST EXP: SOLID WASTE 10-82-694 DIST EXP: WATER/POWER/SANI TOTAL MUSEUM

16.67

33.34

.00

33.34

200.00

166.66

16.7

313.41

482.03

.00

482.03

4,020.00

3,537.97

12.0

6,244.73

9,612.14

.00

9,612.14

64,070.00

54,457.86

15.0

16.7

TRANSFERS 10-90-113 CAP PROJECTS R & M FUND 10-90-116 SR. NUTRITION S/R FUND 10-90-121 TRSFR TO ENVIRONMENTAL FUND 21

8,333.33

16,666.66

.00

16,666.66

100,000.00

83,333.34

17,808.33

35,616.66

.00

35,616.66

213,700.00

178,083.34

16.7

416.67

833.34

.00

833.34

5,000.00

4,166.66

16.7

10-90-123 MORE COPS FUND #23

11,666.67

23,333.34

.00

23,333.34

140,000.00

116,666.66

16.7

10-90-185 G O BONDS 2002 SERIES

84,725.50

169,451.00

.00

169,451.00

1,016,706.00

847,255.00

16.7

6,241.25

12,482.50

.00

12,482.50

74,895.00

62,412.50

16.7

129,191.75

258,383.50

.00

258,383.50

1,550,301.00

1,291,917.50

16.7

10-90-187 WASTE DISPOSAL D/S FUND TOTAL TRANSFERS

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:14

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 GENERAL FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

CONTINGENCY 10-99-200 G/F CONTINGENCY TOTAL CONTINGENCY

TOTAL FUND EXPENDITURES

NET REVENUE OVER EXPENDITURES

FOR ADMINISTRATION USE ONLY

(

.00

.00

.00

.00

200,000.00

200,000.00

.0

.00

.00

.00

.00

200,000.00

200,000.00

.0

2,284,489.58

3,526,936.66

126,376.00

3,653,312.66

20,415,727.00

16,762,414.34

17.9

353,871.00)

309,229.32

864,151.33) (

536,724.32) (

17 % OF THE FISCAL YEAR HAS ELAPSED

126,376.00) (

663,100.32) (

09/14/2015 06:09PM PAGE:15

(187.4)

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 STREET MAINT. SPEC. REV. FUND ASSETS 11-11900 CASH-COMBINED FUND

2,889,928.08

TOTAL ASSETS

2,889,928.08

LIABILITIES AND EQUITY

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 11-29800 BALANCE - BEGINNING OF YEAR

2,887,265.93

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

2,662.15 2,889,928.08

TOTAL FUND EQUITY

2,889,928.08

TOTAL LIABILITIES AND EQUITY

2,889,928.08

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:16

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 STREET MAINT. SPEC. REV. FUND PER. ACTUAL

11-32-100 UTILITY R.O.W. FEES

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

.00

.00

.00

.00

395,000.00

395,000.00

.0

.00

.00

.00

.00

395,000.00

395,000.00

.0

1,000.00

1,000.00

.00

1,000.00

71,000.00

70,000.00

1.4

.00

.00

.00

.00

850,000.00

850,000.00

.0

2,908.15

2,908.15

.00

2,908.15

221,550.00

218,641.85

1.3

TOTAL STREETS INTERGOV'TL REVE

3,908.15

3,908.15

.00

3,908.15

1,142,550.00

1,138,641.85

.3

TOTAL FUND REVENUE

3,908.15

3,908.15

.00

3,908.15

1,537,550.00

1,533,641.85

.3

TOTAL SOURCE 32

STREETS INTERGOV'TL REVENUE 11-33-100 GAS TAX (COUNTY) 11-33-120 REG'L TRANS COMM - COUNTY 11-33-500 GAS TAX - STATE

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:17

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 STREET MAINT. SPEC. REV. FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

STREETS & DRAINAGE 11-65-700 STREET MAINTENANCE

1,246.00

1,246.00

282,619.13

283,865.13

400,000.00

116,134.87

71.0

.00

.00

.00

.00

865,000.00

865,000.00

.0

TOTAL STREETS & DRAINAGE

1,246.00

1,246.00

282,619.13

283,865.13

1,265,000.00

981,134.87

22.4

TOTAL FUND EXPENDITURES

1,246.00

1,246.00

282,619.13

283,865.13

1,265,000.00

981,134.87

22.4

NET REVENUE OVER EXPENDITURES

2,662.15

2,662.15

282,619.13) (

279,956.98)

272,550.00

552,506.98

(102.7)

11-65-740 CAPITAL OUTLAY

FOR ADMINISTRATION USE ONLY

(

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:18

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 AIRPORT SPECIAL REVENUE FUND ASSETS 12-11900 CASH - COMBINED FUND

304,419.23

12-13102 DUE FROM OTHER GOVT'S

22,240.00

12-13107 ACCOUNTS RECEIVABLE - AVFUEL

97,633.74

12-13115 AVIATION FUEL INVENTORY

52,723.28

TOTAL ASSETS

477,016.25

LIABILITIES AND EQUITY

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 12-29800 BALANCE - BEGINNING OF YEAR

507,007.21

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

(

29,990.96) 477,016.25

TOTAL FUND EQUITY

477,016.25

TOTAL LIABILITIES AND EQUITY

477,016.25

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:19

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 AIRPORT SPECIAL REVENUE FUND PER. ACTUAL

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

AIRPORT INTERGOV'TL REVENUE 12-33-225 FEDERAL FAA GRANT TOTAL AIRPORT INTERGOV'TL REVEN

.00

.00

.00

.00

300,000.00

300,000.00

.0

.00

.00

.00

.00

300,000.00

300,000.00

.0

CHARGES FOR SERVICES 12-34-600 AVIATION FUEL/OIL SALES

22,936.89

61,687.02

.00

61,687.02

500,000.00

438,312.98

12.3

12-34-605 AIRPORT LEASES

16,664.52

20,124.91

.00

20,124.91

77,000.00

56,875.09

26.1

.00

.00

.00

.00

15,400.00

15,400.00

.0

TOTAL CHARGES FOR SERVICES

39,601.41

81,811.93

.00

81,811.93

592,400.00

510,588.07

13.8

TOTAL FUND REVENUE

39,601.41

81,811.93

.00

81,811.93

892,400.00

810,588.07

9.2

12-34-610 OTHER LEASES

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:20

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 AIRPORT SPECIAL REVENUE FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

AIRPORT 12-87-210 CONTRACTED SERVICES

.00

.00

.00

.00

540.00

540.00

.0

12-87-250 EQUIPMENT SUPPLIES & MAINT NC

.00

.00

.00

.00

2,700.00

2,700.00

.0

12-87-255 FUEL

.00

17,618.05

.00

17,618.05

375,000.00

357,381.95

4.7

12-87-260 EQUIPMENT (NON CAPITALIZED)

.00

.00

.00

.00

1,200.00

1,200.00

.0

6,547.51

14,981.48

.00

14,981.48

83,000.00

68,018.52

18.1

12-87-310 PROFESSIONAL & TECHNICAL SVCS 12-87-480 RUNWAY MISCELLANEOUS SUPPLIES

.00

.00

.00

.00

5,000.00

5,000.00

.0

12-87-510 INSURANCE

.00

.00

.00

.00

7,100.00

7,100.00

.0

12-87-610 MISCELLANEOUS SUPPLIES 12-87-691 DISTR EXP: FACILITIES MAINT 12-87-692 DIST EXP: SOLID WASTE

44.97

320.13

.00

320.13

5,700.00

5,379.87

5.6

358.33

716.66

.00

716.66

4,300.00

3,583.34

16.7

12.50

25.00

.00

25.00

150.00

125.00

16.7

316.67

633.34

.00

633.34

3,800.00

3,166.66

16.7

12-87-694 DIST EXP: WATER/POWER/SANI

2,173.13

2,480.13

.00

2,480.13

19,600.00

17,119.87

12.7

12-87-695 BANK/ CREDIT CARD CHARGES

47.19

361.44

.00

361.44

5,000.00

4,638.56

7.2

8,000.00

8,000.00

297,307.00

305,307.00

320,000.00

14,693.00

95.4

17,500.30

45,136.23

297,307.00

342,443.23

833,090.00

490,646.77

41.1

12-90-010 TRSFR TO GEN FUND #10

33,333.33

66,666.66

.00

66,666.66

400,000.00

333,333.34

16.7

TOTAL DEPARTMENT 90

33,333.33

66,666.66

.00

66,666.66

400,000.00

333,333.34

16.7

TOTAL FUND EXPENDITURES

50,833.63

111,802.89

297,307.00

409,109.89

1,233,090.00

823,980.11

33.2

297,307.00) (

327,297.96) (

12-87-693 DIST EXP: VEHICLE MAINT

12-87-740 CAPITAL OUTLAY TOTAL AIRPORT

DEPARTMENT 90

NET REVENUE OVER EXPENDITURES

FOR ADMINISTRATION USE ONLY

(

11,232.22) (

29,990.96)

(

17 % OF THE FISCAL YEAR HAS ELAPSED

340,690.00) (

13,392.04) ( 96.1)

09/14/2015 06:09PM PAGE:21

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 CAP. PROJ. MAINT/REPAIRS FUND ASSETS 13-11900 CASH-COMBINED FUND

227,892.78

TOTAL ASSETS

227,892.78

LIABILITIES AND EQUITY

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 13-29800 BALANCE - BEGINNING OF YEAR

238,774.00

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

(

10,881.22) 227,892.78

TOTAL FUND EQUITY

227,892.78

TOTAL LIABILITIES AND EQUITY

227,892.78

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:22

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 CAP. PROJ. MAINT/REPAIRS FUND PER. ACTUAL

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

CONTRIBUTIONS AND TRANSFERS 13-39-960 TRANSFER FROM G/F

8,333.33

16,666.66

.00

16,666.66

100,000.00

83,333.34

16.7

TOTAL CONTRIBUTIONS AND TRANSF

8,333.33

16,666.66

.00

16,666.66

100,000.00

83,333.34

16.7

TOTAL FUND REVENUE

8,333.33

16,666.66

.00

16,666.66

100,000.00

83,333.34

16.7

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:23

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 CAP. PROJ. MAINT/REPAIRS FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

MAINTENANCE/REPAIRS 13-40-210 CONTRACTED SERVICES

.00

.00

.00

.00

750.00

750.00

.0

13-40-450 MAINTENANCE/REPAIRS

19,622.00

20,587.59

2,660.00

23,247.59

53,900.00

30,652.41

43.1

6,960.29

6,960.29

.00

6,960.29

40,000.00

33,039.71

17.4

TOTAL MAINTENANCE/REPAIRS

26,582.29

27,547.88

2,660.00

30,207.88

94,650.00

64,442.12

31.9

TOTAL FUND EXPENDITURES

26,582.29

27,547.88

2,660.00

30,207.88

94,650.00

64,442.12

31.9

18,248.96) (

10,881.22)

13,541.22)

5,350.00

18,891.22

(253.1)

13-40-625 REPAIRS & REMODELS

NET REVENUE OVER EXPENDITURES

FOR ADMINISTRATION USE ONLY

(

(

17 % OF THE FISCAL YEAR HAS ELAPSED

2,660.00)

(

09/14/2015 06:09PM PAGE:24

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 POLICE FORFEITURE FUND ASSETS 14-11900 CASH - COMBINED FUND

178,551.76

TOTAL ASSETS

178,551.76

LIABILITIES AND EQUITY

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 14-29800 BALANCE - BEGINNING OF YEAR

173,017.04

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

5,534.72 178,551.76

TOTAL FUND EQUITY

178,551.76

TOTAL LIABILITIES AND EQUITY

178,551.76

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:25

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 POLICE FORFEITURE FUND PER. ACTUAL

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

FINES AND FORFEITURES 14-35-240 FORFEITURES (FEDERAL)

.00

5,534.72

.00

5,534.72

.00

(

5,534.72)

.0

TOTAL FINES AND FORFEITURES

.00

5,534.72

.00

5,534.72

.00

(

5,534.72)

.0

TOTAL FUND REVENUE

.00

5,534.72

.00

5,534.72

.00

(

5,534.72)

.0

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:26

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 POLICE FORFEITURE FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

POLICE 14-54-740 CAPITAL OUTLAY

.00

.00

25,728.00

25,728.00

.00

(

25,728.00)

.0

TOTAL POLICE

.00

.00

25,728.00

25,728.00

.00

(

25,728.00)

.0

TOTAL FUND EXPENDITURES

.00

.00

25,728.00

25,728.00

.00

(

25,728.00)

.0

NET REVENUE OVER EXPENDITURES

.00

5,534.72

25,728.00) (

20,193.28)

.00

20,193.28

.0

FOR ADMINISTRATION USE ONLY

(

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:27

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 COURT ADMINISTRATIVE ASSESS. ASSETS 15-11900 CASH - COMBINED FUND

26,933.29

TOTAL ASSETS

26,933.29

LIABILITIES AND EQUITY

LIABILITIES 15-21310 ACCOUNTS PAYABLE

(

4,500.00)

TOTAL LIABILITIES

(

4,500.00)

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 15-29800 BALANCE - BEGINNING OF YEAR

26,099.10

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

5,334.19 31,433.29

TOTAL FUND EQUITY

31,433.29

TOTAL LIABILITIES AND EQUITY

26,933.29

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:28

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 COURT ADMINISTRATIVE ASSESS. PER. ACTUAL

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

FINES AND FORFEITURES 15-35-100 ADMINISTRATIVE ASSESSMENTS

(

9,695.00)

2,425.00

.00

2,425.00

23,000.00

20,575.00

15-35-300 DUI SPECIALTY COURT FEE

(

300.00)

.00

.00

.00

.00

.00

.0

15-35-400 AA FEE - DNA

(

456.00)

12.00)

.00

12.00)

.00

12.00

.0

(

10,451.00)

2,413.00

.00

2,413.00

23,000.00

20,587.00

10.5

300.00

712.50

.00

712.50

.00

(

712.50)

.0

300.00

712.50

.00

712.50

.00

(

712.50)

.0

10,151.00)

3,125.50

.00

3,125.50

23,000.00

19,874.50

13.6

TOTAL FINES AND FORFEITURES

(

(

10.5

SOURCE 36 15-36-100 COURT COLLECTION FEES TOTAL SOURCE 36

TOTAL FUND REVENUE

FOR ADMINISTRATION USE ONLY

(

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:29

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 COURT ADMINISTRATIVE ASSESS. PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

COURT ADMIN COSTS 15-51-110 SALARIES

.00

265.47

.00

265.47

3,172.00

2,906.53

8.4

15-51-130 EMPLOYEE BENEFITS

.00

20.30

.00

20.30

300.00

279.70

6.8

15-51-230 TRAVEL & TRAINING

.00

15-51-310 PROFESSIONAL & TECHNICAL SVCS

29.27

15-51-620 SUPPLIES & EQUIPMENT 15-51-630 COURT COLLECTION COSTS

(

.00

.00

4,441.46)

.00

(

.00

2,000.00

2,000.00

4,441.46)

2,000.00

6,441.46 (

.0 (222.1)

1,947.00

1,947.00

.00

1,947.00

1,000.00

947.00)

194.7

.00

.00

.00

.00

2,000.00

2,000.00

.0

TOTAL COURT ADMIN COSTS

1,976.27

(

2,208.69)

.00

(

2,208.69)

10,472.00

12,680.69

( 21.1)

TOTAL FUND EXPENDITURES

1,976.27

(

2,208.69)

.00

(

2,208.69)

10,472.00

12,680.69

( 21.1)

5,334.19

.00

5,334.19

12,528.00

7,193.81

42.6

NET REVENUE OVER EXPENDITURES

FOR ADMINISTRATION USE ONLY

(

12,127.27)

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:30

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 SR. NUTRITION PROGRAM ASSETS 16-11900 CASH - COMBINED FUND

66,798.68

TOTAL ASSETS

66,798.68

LIABILITIES AND EQUITY

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 16-29800 BALANCE - BEGINNING OF YEAR

69,342.73

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

(

2,544.05) 66,798.68

TOTAL FUND EQUITY

66,798.68

TOTAL LIABILITIES AND EQUITY

66,798.68

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:31

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 SR. NUTRITION PROGRAM PER. ACTUAL

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

INTERGOVERNMENTAL REVENUE 16-33-220 TITLE III, C-1, CONGR. MEALS

.00

.00

.00

.00

72,000.00

72,000.00

.0

16-33-230 TITLE III, C-2, HOME MEALS

.00

.00

.00

.00

129,000.00

129,000.00

.0

16-33-245 EQUIPMENT GRANT 16-33-265 OTHER GRANTS - NSIP 16-33-270 GRANT - CLARK COUNTY OAG TOTAL INTERGOVERNMENTAL REVE

.00

.00

.00

.00

6,000.00

33,493.00

33,493.00

.00

33,493.00

28,000.00

6,000.00

.0

5,493.00)

119.6

.00

.00

.00

.00

30,000.00

30,000.00

.0

33,493.00

33,493.00

.00

33,493.00

265,000.00

231,507.00

12.6

14.7

(

CHARGES FOR SERVICES 3,989.80

8,548.04

.00

8,548.04

58,000.00

49,451.96

16-34-410 OTHER INCOME

16-34-400 PATRON DONATIONS

175.00

368.00

.00

368.00

6,000.00

5,632.00

6.1

16-34-415 INMATE MEALS

1,453.50

3,440.25

.00

3,440.25

24,000.00

20,559.75

14.3

5,618.30

12,356.29

.00

12,356.29

88,000.00

75,643.71

14.0

TOTAL CHARGES FOR SERVICES

OTHER REVENUE 16-38-120 DONATIONS

.00

.00

.00

.00

5,000.00

150.00

350.00

.00

350.00

300.00

150.00

350.00

.00

350.00

17,808.33

35,616.66

.00

TOTAL TRANSFERS

17,808.33

35,616.66

TOTAL FUND REVENUE

57,069.63

81,815.95

16-38-150 FACILITIES / SPACE RENTAL TOTAL OTHER REVENUE

5,000.00

.0

50.00)

116.7

5,300.00

4,950.00

6.6

35,616.66

213,700.00

178,083.34

16.7

.00

35,616.66

213,700.00

178,083.34

16.7

.00

81,815.95

572,000.00

490,184.05

14.3

(

TRANSFERS 16-39-960 TRANSFER FROM G/F

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:32

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 SR. NUTRITION PROGRAM PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

SR. NUTRITION EXPENSES 16-71-110 SALARIES

18,777.79

27,093.45

.00

27,093.45

179,603.00

152,509.55

15.1

16-71-112 VAC/SICK BUYOUT

.00

.00

.00

.00

6,679.00

6,679.00

.0

16-71-113 LONGEVITY PAY

.00

.00

.00

.00

5,200.00

5,200.00

.0

16-71-120 OVERTIME

.00

.00

.00

.00

1,500.00

1,500.00

.0

10,146.10

17,342.59

.00

17,342.59

108,752.00

91,409.41

16.0

16-71-130 EMPLOYEE BENEFITS 16-71-210 CONTRACTED SERVICES

.00

.00

.00

.00

500.00

500.00

.0

16-71-230 TRAVEL & TRAINING

.00

.00

.00

.00

800.00

800.00

.0

16-71-240 OFFICE EXPENSE & SUPPLIES 16-71-250 EQUIPMENT SUPPLIES & MAINT NC

22.00

22.00

.00

22.00

900.00

878.00

2.4

140.00

318.00

.00

318.00

700.00

382.00

45.4

16-71-280 UTILITIES

.00

.00

.00

.00

468.00

468.00

.0

16-71-290 TELEPHONE

.00

.00

.00

.00

650.00

650.00

.0

16-71-310 PROFESSIONAL & TECHNICAL SVCS

77.80

116.70

.00

116.70

1,500.00

1,383.30

7.8

15,029.59

28,981.86

.00

28,981.86

174,000.00

145,018.14

16.7

16-71-610 MISCELLANEOUS SUPPLIES

174.71

1,377.31

.00

1,377.31

6,500.00

5,122.69

21.2

16-71-620 MISCELLANEOUS SERVICES

137.87

200.77

.00

200.77

6,500.00

6,299.23

3.1

1,300.00

2,600.00

.00

2,600.00

15,600.00

13,000.00

16.7

16-71-480 FOOD/COMMODITY SUPPLIES

16-71-691 DISTR EXP: FACILITIES MAINT 16-71-692 DIST EXP: SOLID WASTE

225.00

450.00

.00

450.00

2,700.00

2,250.00

16.7

16-71-693 DIST EXP: VEHICLE MAINT

741.67

1,483.34

.00

1,483.34

8,900.00

7,416.66

16.7

2,853.78

4,373.98

.00

4,373.98

36,500.00

32,126.02

12.0

.00

.00

.00

.00

11,000.00

11,000.00

.0

TOTAL SR. NUTRITION EXPENSES

49,626.31

84,360.00

.00

84,360.00

568,952.00

484,592.00

14.8

TOTAL FUND EXPENDITURES

49,626.31

84,360.00

.00

84,360.00

568,952.00

484,592.00

14.8

2,544.05)

.00

2,544.05)

3,048.00

5,592.05

16-71-694 DIST EXP: WATER/POWER/SANI 16-71-740 CAPITAL OUTLAY

NET REVENUE OVER EXPENDITURES

FOR ADMINISTRATION USE ONLY

7,443.32

(

17 % OF THE FISCAL YEAR HAS ELAPSED

(

09/14/2015 06:09PM PAGE:33

( 83.5)

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 RECREATION PROGRAMS ASSETS 17-11900 CASH - COMBINED FUND

316,886.45

TOTAL ASSETS

316,886.45

LIABILITIES AND EQUITY

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 17-29800 BALANCE - BEGINNING OF YEAR

381,996.91

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

(

65,110.46) 316,886.45

TOTAL FUND EQUITY

316,886.45

TOTAL LIABILITIES AND EQUITY

316,886.45

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:34

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 RECREATION PROGRAMS PER. ACTUAL

17-33-270 GRANT - CLARK COUNTY OAG

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

.00

.00

.00

.00

30,000.00

30,000.00

.0

.00

.00

.00

.00

30,000.00

30,000.00

.0

16,776.13

29,937.63

.00

29,937.63

190,000.00

160,062.37

15.8

2,661.01

4,165.51

.00

4,165.51

70,000.00

65,834.49

6.0

17-34-410 EVENTS FEES

2.00

92.00

.00

92.00

18,000.00

17,908.00

.5

17-34-415 DONATIONS

.00

.00

.00

.00

2,580.00

2,580.00

.0

TOTAL CHARGES FOR SERVICES

19,439.14

34,195.14

.00

34,195.14

280,580.00

246,384.86

12.2

TOTAL FUND REVENUE

19,439.14

34,195.14

.00

34,195.14

310,580.00

276,384.86

11.0

TOTAL SOURCE 33

CHARGES FOR SERVICES 17-34-400 RECREATION CHARGES 17-34-405 FIELD RENTAL

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:35

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 RECREATION PROGRAMS PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

RECREATION PROGRAM COSTS 17-80-110 SALARIES

24,265.35

35,837.91

.00

35,837.91

144,090.00

108,252.09

24.9

17-80-112 VAC/SICK BUYOUT

.00

.00

.00

.00

573.00

573.00

.0

17-80-113 LONGEVITY PAY

.00

.00

.00

.00

600.00

600.00

.0

17-80-115 UNIFORM ALLOWANCE

.00

400.00

.00

400.00

400.00

.00

100.0

17-80-130 EMPLOYEE BENEFITS

4,598.77

7,629.90

.00

7,629.90

42,104.00

34,474.10

18.1

17-80-310 PROFFESSIONAL & TECHNICAL SVCS

9,208.00

12,958.75

.00

12,958.75

66,000.00

53,041.25

19.6 46.6

17-80-485 PRE-SCHOOL COSTS

842.24

2,796.37

.00

2,796.37

6,000.00

3,203.63

1,908.48

4,002.81

.00

4,002.81

46,000.00

41,997.19

8.7

641.52

641.52

.00

641.52

6,000.00

5,358.48

10.7

1,705.00

1,705.00

16,668.00

18,373.00

.00

18,373.00)

.0

43,169.36

65,972.26

16,668.00

82,640.26

311,767.00

229,126.74

26.5

16,666.67

33,333.34

.00

33,333.34

200,000.00

166,666.66

16.7

TOTAL TRANSFERS

16,666.67

33,333.34

.00

33,333.34

200,000.00

166,666.66

16.7

TOTAL FUND EXPENDITURES

59,836.03

99,305.60

16,668.00

115,973.60

511,767.00

395,793.40

22.7

40,396.89) (

65,110.46)

201,187.00) (

119,408.54) ( 40.7)

17-80-610 MISCELLANEOUS SUPPLIES 17-80-695 BANK/ CREDIT CARD CHARGES 17-80-740 CAPITAL OUTLAY TOTAL RECREATION PROGRAM COST

(

TRANSFERS 17-90-109 TRANSFER TO GEN. FUND

NET REVENUE OVER EXPENDITURES

FOR ADMINISTRATION USE ONLY

(

(

17 % OF THE FISCAL YEAR HAS ELAPSED

16,668.00) (

81,778.46) (

09/14/2015 06:09PM PAGE:36

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 FORENSIC SERVICES ASSETS 19-11900 CASH - COMBINED FUND

3,379.34

TOTAL ASSETS

3,379.34

LIABILITIES AND EQUITY

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 19-29800 BALANCE - BEGINNING OF YEAR

3,436.00

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

(

56.66) 3,379.34

TOTAL FUND EQUITY

3,379.34

TOTAL LIABILITIES AND EQUITY

3,379.34

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:37

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 FORENSIC SERVICES PER. ACTUAL

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

FINES AND FORFEITURES 19-35-200 ANALYSIS FEE, DUI NRS484.3798

120.00

360.00

.00

360.00

500.00

140.00

72.0

.00

.00

.00

.00

2,000.00

2,000.00

.0

TOTAL FINES AND FORFEITURES

120.00

360.00

.00

360.00

2,500.00

2,140.00

14.4

TOTAL FUND REVENUE

120.00

360.00

.00

360.00

2,500.00

2,140.00

14.4

19-35-300 ANALYSIS FEE, DRUGS NRS453.575

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:38

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 FORENSIC SERVICES PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

TRANSFERS 19-90-109 TRANSFER TO GEN. FUND

208.33

416.66

.00

416.66

2,500.00

2,083.34

16.7

TOTAL TRANSFERS

208.33

416.66

.00

416.66

2,500.00

2,083.34

16.7

TOTAL FUND EXPENDITURES

208.33

416.66

.00

416.66

2,500.00

2,083.34

16.7

56.66)

.00

56.66)

.00

56.66

.0

NET REVENUE OVER EXPENDITURES

FOR ADMINISTRATION USE ONLY

(

88.33)

(

17 % OF THE FISCAL YEAR HAS ELAPSED

(

09/14/2015 06:09PM PAGE:39

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 RESID. CONSTR. TAX PARK FUND ASSETS 20-11900 CASH - COMBINED FUND

1,002,114.78

TOTAL ASSETS

1,002,114.78

LIABILITIES AND EQUITY

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 20-29800 BALANCE - BEGINNING OF YEAR

957,744.58

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

44,370.20 1,002,114.78

TOTAL FUND EQUITY

1,002,114.78

TOTAL LIABILITIES AND EQUITY

1,002,114.78

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:40

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 RESID. CONSTR. TAX PARK FUND PER. ACTUAL

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

LICENSES AND PERMITS 20-32-210 BUILDING PARK FEES TOTAL LICENSES AND PERMITS

25,000.00

53,000.00

.00

53,000.00

180,000.00

127,000.00

29.4

25,000.00

53,000.00

.00

53,000.00

180,000.00

127,000.00

29.4

.00

.00

.00

.00

200,000.00

200,000.00

.0

.00

.00

.00

.00

200,000.00

200,000.00

.0

25,000.00

53,000.00

.00

53,000.00

380,000.00

327,000.00

14.0

GRANT REVENUE 20-33-110 CDBG GRANT TOTAL GRANT REVENUE

TOTAL FUND REVENUE

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:41

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 RESID. CONSTR. TAX PARK FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

PARKS/GROUNDS MAINT. 20-76-751 PARK REPAIRS/IMPROVEMENTS

.00

8,629.80

.00

8,629.80

200,000.00

20-76-803 PIONEER PARK-CONCESSION CEMENT

.00

.00

31,229.50

31,229.50

.00

20-76-806 HAFEN PARK-RUBBERIZED SURFACE

.00

.00

36,031.00

36,031.00

TOTAL PARKS/GROUNDS MAINT.

.00

8,629.80

67,260.50

TOTAL FUND EXPENDITURES

.00

8,629.80

25,000.00

44,370.20

NET REVENUE OVER EXPENDITURES

FOR ADMINISTRATION USE ONLY

(

17 % OF THE FISCAL YEAR HAS ELAPSED

191,370.20 (

4.3

31,229.50)

.0

200,000.00

163,969.00

18.0

75,890.30

400,000.00

324,109.70

19.0

67,260.50

75,890.30

400,000.00

324,109.70

19.0

67,260.50) (

22,890.30) (

20,000.00)

2,890.30

09/14/2015 06:09PM PAGE:42

(114.5)

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 ENVIR. PLANNING SPEC.REV. FUND ASSETS 21-11900 CASH - COMBINED FUND

503,201.82

TOTAL ASSETS

503,201.82

LIABILITIES AND EQUITY

LIABILITIES 21-23215 VRHCP IMPACT FEES COLLECTIONS

442,329.37

21-25501 DEFERRED INC - TOWN WASH MITIG

47,575.50

21-25502 DEFERRED INC - PULTE

12,872.51

TOTAL LIABILITIES

502,777.38

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 21-29800 BALANCE - BEGINNING OF YEAR

23,536.64

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

(

23,112.20) 424.44

TOTAL FUND EQUITY

424.44

TOTAL LIABILITIES AND EQUITY

FOR ADMINISTRATION USE ONLY

503,201.82

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:09PM PAGE:43

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 ENVIR. PLANNING SPEC.REV. FUND PER. ACTUAL

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

GRANT REVENUE 21-33-267 HABITAT GRADING PERMIT FEES

.00

.00

.00

.00

170,000.00

170,000.00

.0

21-33-275 DVLPER MITIG FEES-TOWN WASH

.00

.00

.00

.00

29,000.00

29,000.00

.0

.00

.00

.00

.00

199,000.00

199,000.00

.0

416.67

833.34

.00

833.34

5,000.00

4,166.66

16.7

TOTAL OTHER FINANCING SOURCES

416.67

833.34

.00

833.34

5,000.00

4,166.66

16.7

TOTAL FUND REVENUE

416.67

833.34

.00

833.34

204,000.00

203,166.66

.4

TOTAL GRANT REVENUE

OTHER FINANCING SOURCES 21-39-960 TRANSFER FROM G/F

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:44

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 ENVIR. PLANNING SPEC.REV. FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

EXPENDITURES 21-85-110 SALARIES 21-85-112 VAC/SICK BUYOUT 21-85-113 LONGEVITY PAY

10,829.14

15,738.35

.00

15,738.35

108,462.00

92,723.65

14.5

732.56

732.56

.00

732.56

6,236.00

5,503.44

11.8

1,225.00

.0

.00

.00

.00

.00

1,225.00

64.08

64.08

.00

64.08

.00

21-85-130 EMPLOYEE BENEFITS

4,598.54

7,410.55

.00

7,410.55

51,379.00

21-85-216 EXIT 118 MITIGATION

.00

.00

31,395.00

31,395.00

.00

21-85-220 PUBLIC NOTICES

.00

.00

.00

.00

2,000.00

2,000.00

.0

21-85-310 PROFESSIONAL & TECHNICAL SVCS

.00

.00

.00

.00

29,000.00

29,000.00

.0

21-85-311 PROFESSIONAL & TECHNICAL FWS

.00

.00

414,826.40

414,826.40

.00

(

414,826.40)

.0

TOTAL EXPENDITURES

16,224.32

23,945.54

446,221.40

470,166.94

198,302.00

(

271,864.94)

237.1

TOTAL FUND EXPENDITURES

16,224.32

23,945.54

446,221.40

470,166.94

198,302.00

(

271,864.94)

237.1

15,807.65) (

23,112.20)

446,221.40) (

469,333.60)

5,698.00

475,031.60

(8236.

21-85-120 OVERTIME

NET REVENUE OVER EXPENDITURES

FOR ADMINISTRATION USE ONLY

(

(

17 % OF THE FISCAL YEAR HAS ELAPSED

( (

64.08)

.0

43,968.45

14.4

31,395.00)

.0

09/14/2015 06:10PM PAGE:45

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 TRANSPORTATION IMPACT FEE FUND ASSETS 22-11900 CASH-COMBINED FUND

2,119,840.59

TOTAL ASSETS

2,119,840.59

LIABILITIES AND EQUITY

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 22-29800 BALANCE - BEGINNING OF YEAR

2,117,112.91

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

2,727.68 2,119,840.59

TOTAL FUND EQUITY

2,119,840.59

TOTAL LIABILITIES AND EQUITY

2,119,840.59

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:46

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 TRANSPORTATION IMPACT FEE FUND PER. ACTUAL

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

LICENSES AND PERMITS 22-32-210 TRANSPORT. IMPACT FEES

1,458.78

2,727.68

.00

2,727.68

9,500.00

6,772.32

28.7

TOTAL LICENSES AND PERMITS

1,458.78

2,727.68

.00

2,727.68

9,500.00

6,772.32

28.7

TOTAL FUND REVENUE

1,458.78

2,727.68

.00

2,727.68

9,500.00

6,772.32

28.7

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:47

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 TRANSPORTATION IMPACT FEE FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

STREETS & DRAINAGE 22-65-744 SIGNAL- PIONEER / TURTLEBACK

.00

.00

.00

.00

350,000.00

350,000.00

.0

TOTAL STREETS & DRAINAGE

.00

.00

.00

.00

350,000.00

350,000.00

.0

TOTAL FUND EXPENDITURES

.00

.00

.00

.00

350,000.00

350,000.00

.0

1,458.78

2,727.68

.00

2,727.68

340,500.00) (

343,227.68)

.8

NET REVENUE OVER EXPENDITURES

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

(

09/14/2015 06:10PM PAGE:48

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 MORE COPS SRF ASSETS 23-11900 CASH COMBINED FUND

(

23-13107 OTHER RECEIVABLES

169,381.75) 120,000.00

TOTAL ASSETS

(

49,381.75)

TOTAL FUND EQUITY

(

49,381.75)

TOTAL LIABILITIES AND EQUITY

(

49,381.75)

LIABILITIES AND EQUITY

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 23-29800 BALANCE BEGINNING YEAR

(

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

FOR ADMINISTRATION USE ONLY

49,586.70) 204.95 (

49,381.75)

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:49

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 MORE COPS SRF PER. ACTUAL

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

INTERGOVERNMENTAL REVENUES 23-33-255 MORE COPS GRANT-1/4% SALES TAX

60,000.00

120,000.00

.00

120,000.00

785,000.00

665,000.00

15.3

60,000.00

120,000.00

.00

120,000.00

785,000.00

665,000.00

15.3

.00

.00

.00

.00

100.00

100.00

.0

.00

.00

.00

.00

100.00

100.00

.0

11,666.67

23,333.34

.00

23,333.34

140,000.00

116,666.66

16.7

TOTAL OTHER FINANCING SOURCES

11,666.67

23,333.34

.00

23,333.34

140,000.00

116,666.66

16.7

TOTAL FUND REVENUE

71,666.67

143,333.34

.00

143,333.34

925,100.00

781,766.66

15.5

TOTAL INTERGOVERNMENTAL REVE

OTHER REVENUE 23-38-100 INTEREST INCOME TOTAL OTHER REVENUE

OTHER FINANCING SOURCES 23-39-960 TRANSFER FROM G/F

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:50

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 MORE COPS SRF PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

EXPENDITURES 23-85-110 SALARIES

48,284.80

71,642.78

.00

71,642.78

476,212.00

404,569.22

15.0

23-85-112 VAC/SICK BUYOUT

2,180.00

2,180.00

.00

2,180.00

17,734.00

15,554.00

12.3

23-85-113 LONGEVITY PAY

2,500.00

2,500.00

.00

2,500.00

5,250.00

2,750.00

47.6

.00

.00

.00

.00

14,000.00

14,000.00

.0

750.00

1,250.00

.00

1,250.00

6,500.00

5,250.00

19.2

23-85-115 UNIFORM ALLOWANCE 23-85-116 EDUCATION ASSISTANCE PAY 23-85-120 OVERTIME

6,422.33

8,453.51

.00

8,453.51

25,000.00

16,546.49

33.8

32,042.24

52,519.90

.00

52,519.90

328,989.00

276,469.10

16.0

2,111.50

4,582.20

.00

4,582.20

55,400.00

50,817.80

8.3

TOTAL EXPENDITURES

94,290.87

143,128.39

.00

143,128.39

929,085.00

785,956.61

15.4

TOTAL FUND EXPENDITURES

94,290.87

143,128.39

.00

143,128.39

929,085.00

785,956.61

15.4

22,624.20)

204.95

.00

204.95

4,189.95)

5.1

23-85-130 EMPLOYEE BENEFITS 23-85-250 EQUIPMENT SUPPLIES & MAINT NC

NET REVENUE OVER EXPENDITURES

FOR ADMINISTRATION USE ONLY

(

17 % OF THE FISCAL YEAR HAS ELAPSED

(

3,985.00)

(

09/14/2015 06:10PM PAGE:51

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 REDEVELOPMENT DISTRICT ASSETS 25-11900 CASH - COMBINED FUND

5,043,205.55

25-12100 CASH - NEVADA ST BANK(BOND $$)

622,561.61

25-13110 NOTE RECEIVABLE

25.00

TOTAL ASSETS

5,665,792.16

LIABILITIES AND EQUITY

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 25-29800 BALANCE - BEGINNING OF YEAR

5,837,044.10

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

(

171,251.94) 5,665,792.16

TOTAL FUND EQUITY

5,665,792.16

TOTAL LIABILITIES AND EQUITY

5,665,792.16

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:52

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 REDEVELOPMENT DISTRICT PER. ACTUAL

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

TAXES 25-31-100 PROPERTY TAXES TOTAL TAXES

90,590.50

90,590.50

.00

90,590.50

2,100,000.00

2,009,409.50

4.3

90,590.50

90,590.50

.00

90,590.50

2,100,000.00

2,009,409.50

4.3

.00

.00

.00

.00

50,000.00

50,000.00

.0

.00

.00

.00

.00

50,000.00

50,000.00

.0

INTERGOVERNMENTAL REVENUE 25-33-230 NDOT GRANTS-ROADS/HIGHWAYS TOTAL INTERGOVERNMENTAL REVE

OTHER REVENUE 25-38-100 INTEREST REVENUE 25-38-110 LEASE REV-COMMUNITY SIGNS TOTAL OTHER REVENUE

TOTAL FUND REVENUE

FOR ADMINISTRATION USE ONLY

96.31

205.75

.00

205.75

1,600.00

660.00

1,320.00

.00

1,320.00

.00

756.31

1,525.75

.00

1,525.75

91,346.81

92,116.25

.00

92,116.25

17 % OF THE FISCAL YEAR HAS ELAPSED

1,394.25

12.9

1,320.00)

.0

1,600.00

74.25

95.4

2,151,600.00

2,059,483.75

4.3

(

09/14/2015 06:10PM PAGE:53

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 REDEVELOPMENT DISTRICT PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

SPECIAL APPROPRIATIONS 25-85-110 SALARIES

8,734.33

12,729.35

.00

12,729.35

75,612.00

62,882.65

16.8

25-85-112 VAC/SICK BUYOUT

.00

246.30

.00

246.30

3,152.00

2,905.70

7.8

25-85-113 LONGEVITY PAY

.00

.00

.00

.00

830.00

830.00

.0

25-85-120 OVERTIME

.00

.00

.00

.00

250.00

250.00

.0

3,827.92

6,227.20

.00

6,227.20

38,967.00

32,739.80

16.0 ( 5.0)

25-85-130 EMPLOYEE BENEFITS 25-85-210 BOOKS, SUBSCRIPTIONS & MEMBERS

50.00)

.00

50.00)

1,000.00

1,050.00

25-85-230 TRAVEL & TRAINING

(

.00

10.00

.00

10.00

4,000.00

3,990.00

.3

25-85-240 OFFICE EXPENSE & SUPPLIES

.00

.00

.00

.00

2,000.00

2,000.00

.0

25-85-620 MISCELLANEOUS SERVICES

50.00)

(

(

310.00

560.00

4,550.00

5,110.00

50,000.00

44,890.00

10.2

25-85-653 DISTRICT SUPPORT SERVICES

.00

.00

.00

.00

150,000.00

150,000.00

.0

25-85-700 LAND PURCHASES

.00

.00

.00

.00

200,000.00

200,000.00

.0

25-85-740 C/P-STREETSCAPES

.00

.00

.00

.00

400,000.00

400,000.00

.0

25-85-754 COMMUNITY SIGNS

.00

.00

.00

.00

3,000.00

3,000.00

.0

25-85-756 TOWN SQUARE MEMORIAL PARK

.00

.00

.00

.00

600,000.00

600,000.00

.0

990.00

990.00

128,770.00

129,760.00

100,000.00

29,760.00)

129.8

13,812.25

20,712.85

133,320.00

154,032.85

1,628,811.00

1,474,778.15

9.5

25-85-757 HISTORIC BUILDING RESTORATION TOTAL SPECIAL APPROPRIATIONS

(

TRANSFERS 25-90-101 TRSFR - DEBT SVC FUND #85

36,602.17

73,204.34

.00

73,204.34

439,226.00

366,021.66

16.7

25-90-109 TRANSFER TO GEN. FUND

84,725.50

169,451.00

.00

169,451.00

1,016,706.00

847,255.00

16.7

TOTAL TRANSFERS

121,327.67

242,655.34

.00

242,655.34

1,455,932.00

1,213,276.66

16.7

TOTAL FUND EXPENDITURES

135,139.92

263,368.19

133,320.00

396,688.19

3,084,743.00

2,688,054.81

12.9

171,251.94) (

133,320.00) (

304,571.94) (

NET REVENUE OVER EXPENDITURES

FOR ADMINISTRATION USE ONLY

(

43,793.11) (

17 % OF THE FISCAL YEAR HAS ELAPSED

933,143.00) (

628,571.06) ( 32.6)

09/14/2015 06:10PM PAGE:54

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 CAPITAL PROJECT FUND ASSETS 45-11900 CASH - COMBINED FUND

2,110,561.54

TOTAL ASSETS

2,110,561.54

LIABILITIES AND EQUITY

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 45-29800 BEGINNING OF YEAR

2,129,419.51

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

(

18,857.97) 2,110,561.54

TOTAL FUND EQUITY

2,110,561.54

TOTAL LIABILITIES AND EQUITY

2,110,561.54

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:55

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 CAPITAL PROJECT FUND PER. ACTUAL

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

INTERGOVERNMENTAL REVENUE 45-33-255 CC - REGIONAL FLOOD CONTROL

.00

.00

.00

.00

184,000.00

184,000.00

.0

45-33-257 HIGHWAY GRANT - RTC (EXIT 118)

.00

.00

.00

.00

10,500,000.00

10,500,000.00

.0

TOTAL INTERGOVERNMENTAL REVE

.00

.00

.00

.00

10,684,000.00

10,684,000.00

.0

TOTAL FUND REVENUE

.00

.00

.00

.00

10,684,000.00

10,684,000.00

.0

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:56

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 CAPITAL PROJECT FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

EXPENDITURES 45-40-100 COST OF LAND SALES

.00

2,422.30

.00

2,422.30

.00

2,422.30)

.0

45-40-800 CEMETERY

1,934.00

1,934.00

331,100.00

333,034.00

500,000.00

(

166,966.00

66.6

45-40-805 E. FIRST SOUTH TO DAIRY LANE

18.3

2,376.67

2,376.67

25,000.00

27,376.67

150,000.00

122,623.33

45-40-807 MSEC CAPITAL IMPROVEMENTS (HQ,

.00

.00

.00

.00

100,000.00

100,000.00

.0

45-40-811 VIRGIN RIVER/E. MESQUITE BLVD.

.00

.00

.00

.00

184,000.00

184,000.00

.0

11,610.00

12,125.00

319,120.88

331,245.88

10,500,000.00

10,168,754.12

3.2

TOTAL EXPENDITURES

15,920.67

18,857.97

675,220.88

694,078.85

11,434,000.00

10,739,921.15

6.1

TOTAL FUND EXPENDITURES

15,920.67

18,857.97

675,220.88

694,078.85

11,434,000.00

10,739,921.15

6.1

15,920.67) (

18,857.97)

675,220.88) (

694,078.85) (

45-40-812 EXIT 118 - CONSTRUCTION

NET REVENUE OVER EXPENDITURES

FOR ADMINISTRATION USE ONLY

(

(

17 % OF THE FISCAL YEAR HAS ELAPSED

750,000.00) (

55,921.15) ( 92.5)

09/14/2015 06:10PM PAGE:57

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 SEWER FUND ASSETS 52-11800 CASH-BK OF NEVADA WASTE BONDS

147,941.70

52-11900 CASH - COMBINED FUND

1,790,892.18

52-13102 OTHER RECEVABLES

332.88

52-13109 SALES TAXES REC'BLE

45,000.00

52-13110 ACCOUNTS RECEIVABLE

16,796.12

52-14000 PREPAID EXPENSE

127,083.34

52-16300 LAND

174,756.00

52-16310 SEWER SYSTEM

36,278,286.34

52-16315 UTILITY LINES

32,022,428.98

52-16350 LAND EASEMENTS

25,300.00

52-16510 MACHINERY AND EQUIPMENT

715,658.60

52-16610 AUTOMOBILE AND TRUCKS

508,262.88

52-17500 ACCUMULATED DEPRECIATION

( 16,683,730.89)

TOTAL ASSETS

55,169,008.13

LIABILITIES AND EQUITY

LIABILITIES 52-21315 ACCRUED INTEREST

78,250.00

52-21325 ACCRUED VACATION

98,345.39

52-21500 CURRENT PORTION - L/T DEBT

967,840.23

52-25103 BONDS PAYABLE - NEVADA, 2.863%

15,673,915.10

TOTAL LIABILITIES

16,818,350.72

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 52-29800 BEGINNING OF YEAR

32,507,322.96

52-29805 CONTRIBUTED CAPITAL, NET

5,676,978.00

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

166,356.45 38,350,657.41

TOTAL FUND EQUITY

38,350,657.41

TOTAL LIABILITIES AND EQUITY

55,169,008.13

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:58

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 SEWER FUND PER. ACTUAL

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

TAXES 52-31-102 SALES TAX (HALF .25%) TOTAL TAXES

50,203.32

95,203.32

.00

95,203.32

569,000.00

473,796.68

16.7

50,203.32

95,203.32

.00

95,203.32

569,000.00

473,796.68

16.7

OPERATING REVENUE 52-37-100 SEWER SERVICES 52-37-200 CONNECTION FEES TOTAL OPERATING REVENUE

1,132.61

607,482.94

.00

607,482.94

2,451,950.00

1,844,467.06

24.8

54,910.00

108,300.00

.00

108,300.00

380,000.00

271,700.00

28.5

56,042.61

715,782.94

.00

715,782.94

2,831,950.00

2,116,167.06

25.3

OTHER REVENUE 52-38-100 INTEREST EARNINGS 52-38-900 MISCELLANEOUS TOTAL OTHER REVENUE

TOTAL FUND REVENUE

FOR ADMINISTRATION USE ONLY

.00

.00

.00

.00

500.00

500.00

.0

13,664.68

13,649.68

.00

13,649.68

188,500.00

174,850.32

7.2

13,664.68

13,649.68

.00

13,649.68

189,000.00

175,350.32

7.2

119,910.61

824,635.94

.00

824,635.94

3,589,950.00

2,765,314.06

23.0

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:59

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 SEWER FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

EXPENDITURES 52-40-110 SALARIES AND WAGES

75,101.76

111,778.01

.00

111,778.01

646,170.00

534,391.99

17.3

52-40-112 VAC/SICK BUYOUT

16,127.26

16,127.26

.00

16,127.26

22,792.00

6,664.74

70.8

.00

.00

.00

.00

11,844.00

11,844.00

.0

400.00

2,512.50

.00

2,512.50

2,913.00

400.50

86.3

52-40-113 LONGEVITY PAY 52-40-115 UNIFORM ALLOWANCE 52-40-120 OVERTIME 52-40-130 EMPLOYEE BENEFITS 52-40-230 TRAVEL & TRAINING 52-40-240 OFFICE EXPENSE & SUPPLIES 52-40-250 EQUIPMENT SUPPLIES & MAINT NC 52-40-260 EQUIPMENT 52-40-280 UTILITIES 52-40-290 TELEPHONE 52-40-310 PROFESSIONAL & TECHNICAL SVCS 52-40-480 CHEMICAL SUPPLIES 52-40-510 INSURANCE 52-40-535 DEPRECIATION

1,373.67

1,832.81

.00

1,832.81

10,000.00

8,167.19

18.3

33,146.41

53,705.32

.00

53,705.32

350,952.00

297,246.68

15.3

.00

240.00

.00

240.00

3,500.00

3,260.00

6.9

414.94

605.06

.00

605.06

12,000.00

11,394.94

5.0

7,976.25

11,966.43

.00

11,966.43

44,300.00

32,333.57

27.0

329.54

826.60

.00

826.60

5,500.00

4,673.40

15.0

26,728.20

26,728.20

.00

26,728.20

306,000.00

279,271.80

8.7

528.20

868.04

.00

868.04

4,000.00

3,131.96

21.7

11,409.51

14,923.92

27,302.63

42,226.55

155,000.00

112,773.45

27.2

6,202.00

12,537.54

59,065.00

71,602.54

117,000.00

45,397.46

61.2

12,708.33

25,416.66

.00

25,416.66

172,500.00

147,083.34

14.7

135,250.00

270,500.00

.00

270,500.00

1,623,000.00

1,352,500.00

16.7

52-40-610 MISCELLANEOUS SUPPLIES

3,451.60

14,721.67

.00

14,721.67

68,000.00

53,278.33

21.7

52-40-620 MISCELLANOUES SERVICES

593.00

1,049.50

.00

1,049.50

75,000.00

73,950.50

1.4

52-40-695 BANK/CREDIT CARD FEES

2,106.97

2,106.97

.00

2,106.97

12,700.00

10,593.03

16.6

52-40-740 SEWER CAPITAL OUTLAY

11,583.00

11,583.00

.00

11,583.00

289,000.00

277,417.00

4.0

52-40-750 LATERAL CONS.FEE REIM.

.00

.00

.00

.00

10,000.00

10,000.00

.0

52-40-820 DEBT SERVICE - INTEREST

39,125.00

78,250.00

.00

78,250.00

487,883.00

409,633.00

16.0

TOTAL EXPENDITURES

384,555.64

658,279.49

86,367.63

744,647.12

4,430,054.00

3,685,406.88

16.8

TOTAL FUND EXPENDITURES

384,555.64

658,279.49

86,367.63

744,647.12

4,430,054.00

3,685,406.88

16.8

264,645.03)

166,356.45

86,367.63)

79,988.82

920,092.82)

9.5

NET REVENUE OVER EXPENDITURES

FOR ADMINISTRATION USE ONLY

(

(

17 % OF THE FISCAL YEAR HAS ELAPSED

(

840,104.00) (

09/14/2015 06:10PM PAGE:60

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 CANYON CREST SID DSF ASSETS 81-11900 CASH - COMBINED FUND

97,091.25

81-12100 LGIP (MESQSID) - CONSTR FUNDS

383,183.21

81-12500 CASH - WF TRUST#18326100

5,596.13

81-13120 ASSESSMTS REC'BLE-CANYON CREST

2,641,753.67

81-13500 CASH - WF DSRF TRUST#18326101

389,869.36

81-13550 WELLS FARGO-ACCT #804-5040295

253,909.07

TOTAL ASSETS

3,771,402.69

LIABILITIES AND EQUITY

LIABILITIES 81-21450 DEVELOPER DEPOSIT - TOUSA

163,467.73

81-24100 CANYON CREST -CUST OVERPAYMEN

3,542.80

81-25120 DEFERRED REVENUE-CANYON CREST

2,641,753.67

TOTAL LIABILITIES

2,808,764.20

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 81-29800 BEGINNING OF YEAR

1,267,917.99

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

(

305,279.50) 962,638.49

TOTAL FUND EQUITY

962,638.49

TOTAL LIABILITIES AND EQUITY

FOR ADMINISTRATION USE ONLY

3,771,402.69

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:61

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 CANYON CREST SID DSF PER. ACTUAL

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

SID ASSESSMENT REVENUE 81-31-115 PRINCIPLE ASSESS-CANYON CREST

8,490.02

17,150.88

.00

17,150.88

198,000.00

180,849.12

8.7

81-31-215 INTEREST ASSESS - CANYON CREST

316.04

795.65

.00

795.65

171,500.00

170,704.35

.5

.00

.00

.00

.00

6,500.00

6,500.00

.0

8,806.06

17,946.53

.00

17,946.53

376,000.00

358,053.47

4.8

27.1

81-31-220 INTEREST INC - ASSESSMNT FNDS TOTAL SID ASSESSMENT REVENUE

OTHER SID INCOME 81-38-100 INTEREST INCOME 81-38-120 CANYON CREST - LATE FEES 81-38-125 CANYON CREST - OTHER INCOME TOTAL OTHER SID INCOME

TOTAL FUND REVENUE

FOR ADMINISTRATION USE ONLY

71.25

135.54

.00

135.54

500.00

364.46

.00

103.93

.00

103.93

4,000.00

3,896.07

2.6

86.00

172.00

.00

172.00

3,000.00

2,828.00

5.7

157.25

411.47

.00

411.47

7,500.00

7,088.53

5.5

8,963.31

18,358.00

.00

18,358.00

383,500.00

365,142.00

4.8

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:62

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 CANYON CREST SID DSF PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

SID DEBT SVC EXPENDITURES 81-40-801 BOND PMT- PRIN: CANYON CREST

245,000.00

245,000.00

.00

245,000.00

200,000.00

45,000.00)

122.5

73,887.50

73,887.50

.00

73,887.50

152,388.00

78,500.50

48.5

.00

.00

.00

.00

4,000.00

4,000.00

.0

318,887.50

318,887.50

.00

318,887.50

356,388.00

37,500.50

89.5

81-90-083 TRSFR TO SID ADMIN SRF #83

2,375.00

4,750.00

.00

4,750.00

28,500.00

23,750.00

16.7

TOTAL TRANSFERS

2,375.00

4,750.00

.00

4,750.00

28,500.00

23,750.00

16.7

321,262.50

323,637.50

.00

323,637.50

384,888.00

61,250.50

84.1

312,299.19) (

305,279.50)

.00

1,388.00)

303,891.50

(21994

81-40-803 BOND PMT-INT: CANYON CREST 81-40-850 BNDHOLDER PREPAY PREM TOTAL SID DEBT SVC EXPENDITURES

(

TRANSFERS

TOTAL FUND EXPENDITURES

NET REVENUE OVER EXPENDITURES

FOR ADMINISTRATION USE ONLY

(

17 % OF THE FISCAL YEAR HAS ELAPSED

(

305,279.50) (

09/14/2015 06:10PM PAGE:63

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 ANTHEM AT MESQUITE SID DSF ASSETS 82-11900 TOTAL ALLOCATION TO OTHER FUND

(

517,956.65)

82-12000 LGIP (MESQAN) - ADMIN FUND

424,582.65

82-12100 LGIP (MESQAN) - CONST FUNDS

264,919.05

82-12300 CASH- WF DS RESERVE FUND #9301

1,041,124.06

82-13100 SID ASSESSMENTS RECEIVABLE

11,116,229.12

82-13550 WELLS FARGO-ACCT #804-5040295

576,862.21

TOTAL ASSETS

12,905,760.44

LIABILITIES AND EQUITY

LIABILITIES 82-24100 ANTHEM - CUSTOMER OVERPAYMEN

12,348.44

82-25100 DEFERRED REVENUE - ANTHEM SID

11,116,229.12

TOTAL LIABILITIES

11,128,577.56

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 82-29800 BALANCE - BEGINNING OF YEAR

2,594,527.21

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

(

817,344.33) 1,777,182.88

TOTAL FUND EQUITY

1,777,182.88

TOTAL LIABILITIES AND EQUITY

FOR ADMINISTRATION USE ONLY

12,905,760.44

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:64

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 ANTHEM AT MESQUITE SID DSF PER. ACTUAL

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

SID ASSESSMENT REVENUE 82-31-115 PRINCIPLE ASSESS - ANTHEM

23,635.27

30,250.02

.00

30,250.02

224,000.00

193,749.98

13.5

82-31-215 INTEREST ASSESS - ANTHEM

1,106.89

2,091.65

.00

2,091.65

807,500.00

805,408.35

.3

24,742.16

32,341.67

.00

32,341.67

1,031,500.00

999,158.33

3.1

82-38-100 INTEREST INCOME

131.01

246.69

.00

246.69

850.00

603.31

29.0

82-38-120 ANTHEM - LATE FEES

326.70

931.44

.00

931.44

5,000.00

4,068.56

18.6

82-38-125 ANTHEM - OTHER INCOME

724.12

904.21

.00

904.21

13,000.00

12,095.79

7.0

TOTAL OTHER SID INCOME

1,181.83

2,082.34

.00

2,082.34

18,850.00

16,767.66

11.1

25,923.99

34,424.01

.00

34,424.01

1,050,350.00

1,015,925.99

3.3

TOTAL SID ASSESSMENT REVENUE

OTHER SID INCOME

TOTAL FUND REVENUE

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:65

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 ANTHEM AT MESQUITE SID DSF PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

SID DEBT SVC EXPENDITURES 82-40-801 BOND PMT- PRIN: ANTHEM SID

480,000.00

480,000.00

.00

480,000.00

255,000.00

225,000.00)

188.2

82-40-803 BOND PMT-INT: ANTHEM SID

347,085.00

347,085.00

.00

347,085.00

717,701.00

370,616.00

48.4

4,600.00

4,600.00

.00

4,600.00

10,000.00

5,400.00

46.0

831,685.00

831,685.00

.00

831,685.00

982,701.00

151,016.00

84.6

82-90-083 TRSFR TO SID ADMIN SRF #83

10,041.67

20,083.34

.00

20,083.34

120,500.00

100,416.66

16.7

TOTAL TRANSFERS

10,041.67

20,083.34

.00

20,083.34

120,500.00

100,416.66

16.7

841,726.67

851,768.34

.00

851,768.34

1,103,201.00

251,432.66

77.2

815,802.68) (

817,344.33)

.00

52,851.00)

764,493.33

(1546.

82-40-805 BNDHOLDER PREPAY PREMIUM TOTAL SID DEBT SVC EXPENDITURES

(

TRANSFERS

TOTAL FUND EXPENDITURES

NET REVENUE OVER EXPENDITURES

FOR ADMINISTRATION USE ONLY

(

17 % OF THE FISCAL YEAR HAS ELAPSED

(

817,344.33) (

09/14/2015 06:10PM PAGE:66

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 SID ADMINISTRATION FUND ASSETS 83-11900 TOTAL ALLOCATION TO OTHER FUND

318,612.83

TOTAL ASSETS

318,612.83

LIABILITIES AND EQUITY

LIABILITIES 83-21311 BANK SERVICE CHARGES PAYABLE

157.31

TOTAL LIABILITIES

157.31

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 83-29800 BEGINNING OF YEAR

306,900.05

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

11,555.47 318,455.52

TOTAL FUND EQUITY

318,455.52

TOTAL LIABILITIES AND EQUITY

318,612.83

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:67

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 SID ADMINISTRATION FUND PER. ACTUAL

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

TRSFR FROM CANYON CREST SID 83-30-115 TRSFR FROM CANYON CREST SID

2,375.00

4,750.00

.00

4,750.00

28,500.00

23,750.00

16.7

114.22

350.40

.00

350.40

2,800.00

2,449.60

12.5

2,489.22

5,100.40

.00

5,100.40

31,300.00

26,199.60

16.3

10,041.67

20,083.34

.00

20,083.34

120,500.00

100,416.66

16.7

212.12

650.75

.00

650.75

4,000.00

3,349.25

16.3

TOTAL TRSFR FROM ANTHEM SID

10,253.79

20,734.09

.00

20,734.09

124,500.00

103,765.91

16.7

TOTAL FUND REVENUE

12,743.01

25,834.49

.00

25,834.49

155,800.00

129,965.51

16.6

83-30-200 INT INCOME - CANYON CREST TOTAL TRSFR FROM CANYON CREST

TRSFR FROM ANTHEM SID 83-32-115 TRSFR FROM ANTHEM SID 83-32-200 INT INCOME - ANTHEM

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:68

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 SID ADMINISTRATION FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

CANYON CREST ADMIN EXPENSES 83-81-010 CANYON CREST - PROF SVCS

3,039.37

3,039.37

.00

3,039.37

23,000.00

19,960.63

13.2

83-81-110 CANYON CREST - SALARIES

1,723.35

2,504.61

.00

2,504.61

15,921.00

13,416.39

15.7

83-81-130 CANYON CREST - EMPLOYEE BENS

662.25

1,041.99

.00

1,041.99

6,500.00

5,458.01

16.0

83-81-610 SERVICE AND SUPPLIES

301.92

818.30

.00

818.30

4,600.00

3,781.70

17.8

5,726.89

7,404.27

.00

7,404.27

50,021.00

42,616.73

14.8

TOTAL CANYON CREST ADMIN EXPEN

ANTHEM SID ADMIN EXPENSES 83-82-010 ANTHEM - PROFESSION SVCS

2,231.90

2,231.90

.00

2,231.90

38,500.00

36,268.10

5.8

83-82-110 ANTHEM - SALARIES

1,723.35

2,504.61

.00

2,504.61

15,921.00

13,416.39

15.7

83-82-130 ANTHEM - EMPLOYEE BENS

662.20

1,041.93

.00

1,041.93

6,500.00

5,458.07

16.0

83-82-610 ANTHEM - SERVICE & SUPPLIES

420.59

1,096.31

.00

1,096.31

6,700.00

5,603.69

16.4

5,038.04

6,874.75

.00

6,874.75

67,621.00

60,746.25

10.2

10,764.93

14,279.02

.00

14,279.02

117,642.00

103,362.98

12.1

1,978.08

11,555.47

.00

11,555.47

38,158.00

26,602.53

30.3

TOTAL ANTHEM SID ADMIN EXPENSE

TOTAL FUND EXPENDITURES

NET REVENUE OVER EXPENDITURES

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:69

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 G.O. BOND SERIES 2002 ASSETS 85-11900 CASH-COMBINED FUND

1,422,752.14

TOTAL ASSETS

1,422,752.14

LIABILITIES AND EQUITY

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 85-29800 BALANCE - BEGINNING OF YEAR

1,180,096.80

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

242,655.34 1,422,752.14

TOTAL FUND EQUITY

1,422,752.14

TOTAL LIABILITIES AND EQUITY

1,422,752.14

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:70

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 G.O. BOND SERIES 2002 PER. ACTUAL

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

CONTRIBUTIONS AND TRANSFERS 85-39-960 TRANSFER FROM RE-DEV

36,602.17

73,204.34

.00

73,204.34

439,226.00

366,021.66

16.7

85-39-961 TRANSFER FROM G/F

84,725.50

169,451.00

.00

169,451.00

1,016,706.00

847,255.00

16.7

TOTAL CONTRIBUTIONS AND TRANSF

121,327.67

242,655.34

.00

242,655.34

1,455,932.00

1,213,276.66

16.7

TOTAL FUND REVENUE

121,327.67

242,655.34

.00

242,655.34

1,455,932.00

1,213,276.66

16.7

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:71

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 G.O. BOND SERIES 2002 PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

MAINTENANCE/REPAIRS 85-40-813 RDA SERIES 2012 DEBT SVC -PRIN

.00

.00

.00

.00

377,100.00

377,100.00

.0

85-40-814 RDA SERIES 2014 DEBT SVC-PRIN

.00

.00

.00

.00

805,000.00

805,000.00

.0

85-40-824 RDA SERIES 2012 - DEBT SVC INT

.00

.00

.00

.00

62,126.00

62,126.00

.0

85-40-825 RDA SERIES 2014 - DEBT SVC INT

.00

.00

.00

.00

211,706.00

211,706.00

.0

TOTAL MAINTENANCE/REPAIRS

.00

.00

.00

.00

1,455,932.00

1,455,932.00

.0

TOTAL FUND EXPENDITURES

.00

.00

.00

.00

1,455,932.00

1,455,932.00

.0

121,327.67

242,655.34

.00

242,655.34

.00

242,655.34)

.0

NET REVENUE OVER EXPENDITURES

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

(

09/14/2015 06:10PM PAGE:72

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 WASTE DISPOSAL D/S FUND ASSETS 87-11900 CASH - COMBINED FUND

87,374.82

TOTAL ASSETS

87,374.82

LIABILITIES AND EQUITY

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 87-29800 BALANCE - BEGINNING OF YEAR

93,616.17

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

(

6,241.35) 87,374.82

TOTAL FUND EQUITY

87,374.82

TOTAL LIABILITIES AND EQUITY

87,374.82

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:73

CITY OF MESQUITE REVENUES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 WASTE DISPOSAL D/S FUND PER. ACTUAL

ACTUAL YTD

ENCUMB.

TOTAL

BUDGET

VARIANCE

%

CONTRIBUTIONS AND TRANSFERS 87-39-960 TRANSFER FROM G/F

6,241.25

12,482.50

.00

12,482.50

74,895.00

62,412.50

16.7

TOTAL CONTRIBUTIONS AND TRANSF

6,241.25

12,482.50

.00

12,482.50

74,895.00

62,412.50

16.7

TOTAL FUND REVENUE

6,241.25

12,482.50

.00

12,482.50

74,895.00

62,412.50

16.7

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:74

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 WASTE DISPOSAL D/S FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

EXPENDITURES 87-40-810 PRINCIPAL EXPENSE

.00

11,435.00

.00

11,435.00

46,648.00

35,213.00

24.5

87-40-820 INTEREST EXPENSE

.00

7,288.85

.00

7,288.85

28,247.00

20,958.15

25.8

TOTAL EXPENDITURES

.00

18,723.85

.00

18,723.85

74,895.00

56,171.15

25.0

TOTAL FUND EXPENDITURES

.00

18,723.85

.00

18,723.85

74,895.00

56,171.15

25.0

6,241.35)

.00

6,241.35)

.00

6,241.35

.0

NET REVENUE OVER EXPENDITURES

FOR ADMINISTRATION USE ONLY

6,241.25

(

17 % OF THE FISCAL YEAR HAS ELAPSED

(

09/14/2015 06:10PM PAGE:75

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 TRUST & AGENCY FUND ASSETS 90-11310 PETTY CASH - JAIL COMMISSARY

100.00

90-11320 BANK OF NEVADA

(

90-11900 CASH AND COMBINED FUND

6,373.44) 616,496.19

TOTAL ASSETS

610,222.75

LIABILITIES AND EQUITY

LIABILITIES 90-26100 CONTRACTOR DEPOSIT

581,146.18

90-26103 VETERANS MEMORIAL DEPOSITS

216.51

90-26105 POLICE YOUTH PROGRAMS

1,315.22

90-26109 MESQUITE NARCOTICS TASK FORCE

(

16,473.44)

90-26110 ASSET FORFEITURE TASK FORCE

(

13,728.69)

90-26113 INMATE COMMISSARY FUND 90-26115 VETERANS DAY PARADE 90-26117 POLICE - GRAD NITE OUT PARTY 90-26118 POLICE - SHOP W/ A COP 90-26119 POLICE - NAT'L NIGHT OUT

10,732.38 66.50 3,683.60 23,227.32 3,000.00

90-26121 POLICE DEPT DONATIONS

663.09

90-26122 MESQUITE ENERGY FAIR

785.59

90-26124 COMMUNITY THEATRE - R&M 90-26125 SCENIC COMM TOWER R&M FUND 90-26126 HERITAGE MUSEUM DONATIONS 90-26127 CERT PGM CONTRIBS / EXPESNSES 90-26128 LEASES - SECURITY DEPOSITS

814.92 9,000.00 614.76 58.81 5,100.00

TOTAL LIABILITIES

610,222.75

TOTAL FUND EQUITY

.00

TOTAL LIABILITIES AND EQUITY

FOR ADMINISTRATION USE ONLY

610,222.75

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:76

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 GENERAL FIXED ASSETS ASSETS 91-16110 LAND

12,876,471.69

91-16210 BUILDINGS & IMPROVEMENTS

48,332,981.86

91-16310 IMPROVE.OTHER THAN BUILDINGS

23,742,421.42

91-16410 OFFICE FURNITURE AND EQUIPMENT

8,892,882.80

91-16610 AUTOMOBILES AND TRUCKS

7,041,837.24

91-16620 WORK IN PROGRESS

2,310,503.79

91-16710 STORM DRAINS & INLETS

12,514,633.95

91-16810 STREETS & SIDEWALKS

94,362,885.94

TOTAL ASSETS

210,074,618.69

LIABILITIES AND EQUITY

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 91-29800 BEGINNING OF YEAR

205,033,677.25

91-29850 ADDITIONS - CURRENT YEAR

5,040,941.44

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

210,074,618.69

TOTAL FUND EQUITY

210,074,618.69

TOTAL LIABILITIES AND EQUITY

210,074,618.69

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:77

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 TECHNOLOGY RES/REPLACMNT FUND ASSETS 98-11900 CASH - COMBINED FUND

115,664.86

TOTAL ASSETS

115,664.86

LIABILITIES AND EQUITY

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 98-29800 BALANCE - BEGINNING OF YEAR

156,438.52

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

(

40,773.66) 115,664.86

TOTAL FUND EQUITY

115,664.86

TOTAL LIABILITIES AND EQUITY

115,664.86

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:78

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 TECHNOLOGY RES/REPLACMNT FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

DEPARTMENT 40 98-40-047 IT - TECHNOLOGY EXPENDITURES

40,773.66

40,773.66

26,478.17

67,251.83

77,000.00

9,748.17

87.3

TOTAL DEPARTMENT 40

40,773.66

40,773.66

26,478.17

67,251.83

77,000.00

9,748.17

87.3

TOTAL FUND EXPENDITURES

40,773.66

40,773.66

26,478.17

67,251.83

77,000.00

9,748.17

87.3

40,773.66) (

40,773.66)

26,478.17) (

67,251.83) (

77,000.00) (

9,748.17)

( 87.3)

NET REVENUE OVER EXPENDITURES

FOR ADMINISTRATION USE ONLY

(

(

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:79

CITY OF MESQUITE BALANCE SHEET AUGUST 31, 2015 VEHICLE/EQUIP REPLACEMNT FUND ASSETS 99-11900 CASH - COMBINED FUND

701,309.75

TOTAL ASSETS

701,309.75

LIABILITIES AND EQUITY

FUND EQUITY

UNAPPROPRIATED FUND BALANCE: 99-29800 BALANCE - BEGINNING OF YEAR

701,309.75

REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE

701,309.75

TOTAL FUND EQUITY

701,309.75

TOTAL LIABILITIES AND EQUITY

701,309.75

FOR ADMINISTRATION USE ONLY

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:80

CITY OF MESQUITE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 2 MONTHS ENDING AUGUST 31, 2015 VEHICLE/EQUIP REPLACEMNT FUND PER. ACTUAL

YTD ACTUAL

EMCUMB.

TOTAL

BUDGET

VARIANCE

%

CAPITAL EXPENDITURES 99-40-054 POLICE

.00

.00

.00

.00

129,074.00

129,074.00

.0

99-40-076 PARKS & GROUNDS MAINTENANCE

.00

.00

21,525.36

21,525.36

25,000.00

3,474.64

86.1

TOTAL CAPITAL EXPENDITURES

.00

.00

21,525.36

21,525.36

154,074.00

132,548.64

14.0

TOTAL FUND EXPENDITURES

.00

.00

21,525.36

21,525.36

154,074.00

132,548.64

14.0

NET REVENUE OVER EXPENDITURES

.00

.00

21,525.36) (

21,525.36) (

154,074.00) (

132,548.64) ( 14.0)

FOR ADMINISTRATION USE ONLY

(

17 % OF THE FISCAL YEAR HAS ELAPSED

09/14/2015 06:10PM PAGE:81

2 - August 2015 Financial Statement.pdf

1:00 PM Pole Vault 14G Pad 1. 3:00 PM High Jump 9G Pads 1, 2 & 3. Long Jump 13B Pit 1 & 2. Shot Put 15-16G Rings 1 & 2. Shot Put 11B Rings 3 & 4. Discus 14B. FINAL SCHEDULE AS OF 07/24/17. Page 3 of 81. 2 - August 2015 Financial Statement.pdf. 2 - August 2015 Financial Statement.pdf. Open. Extract. Open with.

186KB Sizes 1 Downloads 165 Views

Recommend Documents

August 2015 Calendar.pdf
Politics at the Heart of the Catholic Church”, by John. Thavis, Monday, August 3, 6:45pm All are welcome to. come and join in the discussion, and get first shot at ...

August 2015 Newsletter.pdf
Summer Greetings from CHS! I hope this newsletter .... sample to meet the Essential Skill requirement for graduation in 2016. .... August 2015 Newsletter.pdf.

August 2015 Preview.pdf
drills that will help kick up the calorie burn and build muscle. (T, F). PumpFit A fat-burning circuit training class that involves muscle endurance and high intensity ...

Adds From August 1 - August 31, 2015.pdf
Aug 31, 2015 - There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item.

Central Point August 2015.pdf
... Venturing website has numerous tools and information to help your crew, district,. Crew Membership Chairman. Page 3 of 7. Central Point August 2015.pdf.

MIS Report - August 2015.pdf
MIS Report - August 2015.pdf. MIS Report - August 2015.pdf. Open. Extract. Open with. Sign In. Main menu. Displaying MIS Report - August 2015.pdf.

August 2015 Newsletter Web version.pdf
August 2015 Newsletter Web version.pdf. August 2015 Newsletter Web version.pdf. Open. Extract. Open with. Sign In. Main menu. Displaying August 2015 ...

Best Drones For August 2015
•Supports the GoPro hero line which can provide an amazing picture (and upgrade potential). •Looks amazing and is always being improved. •Occasional bugs ...

SAOB AUGUST 2015.pdf
50211010 00 Legal Services 200,000.00 104,000.00 96,000.00 52. 50211030 00 Consultancy Services - 25,000.00 .... Health Facilities Development Bureau CONAP - Kapit Bisig Para sa Kalusugan. Pangkalahatan (KB Para sa KP) and National Hospital ... SAOB

August 5, 2015 cancel notice.pdf
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. August 5, 2015 ...

New & Noteworthy - August 2015.pdf
Page 1 of 3. August. 2015. One Love One Heart – Updates and New Projects. 1. Thank you again to everyone who. generously donated school supplies to.

August 14 2015 Board Mtg.pdf
Larry Wormington, Tom Parrish, Henry Ramirez, Linda Kowalski and Charles Campbell. Absent: Melissa. Hardgrave. Guest: Bill Harlien. Ouorum established. {} ) BijSINESS. Minutes from 7/17/15 read by Tom Parrish. ... Shelly Mark will continue to update

August 7th -20st 2015.pdf
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. August 7th -20st ...

MIS Report - August 2015.pdf
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. MIS Report ...

August 2015 Village Voice.pdf
Page 1 of 4. August 2015. THE VILLAGE VOICE. COMMUNITY EVENTS AT THE VILLAGE SQUARE. 1198VANKOUGHNETROAD. 705-645-7548. Guess Who's Coming for Dinner! Saturday, September 26th, 2015. 5:00 p.m. – 6:00 p.m. Appetizers. 6:15 p.m. – 7:45 p.m. Dine at

The Patch August 2015.pdf
South Africa but returned to England in 1948 when the. company folded. He did not seriously fly again but took. over the family farming interest in Lincolnshire ...

Bulletin August 23, 2015.pdf
For more details and to register see http:// centeringprayerstl.org/programs/introduction-to-centering- prayer/ or call Contemplative Outreach of St. Louis at 314-.

2015 August 5 Minutes.pdf
session, Trustee Wilson made a motion to authorize legal counsel to pursue the pending. motions and to take no further action with regards to the Auler Lawsuit. Trustee. McCrone seconded. Motion approved. 7.10 Closed Session to Discuss Nuisance Viola

Ubqari August 2015.pdf
Page 2 of 3. المادة : الرياضيات. المستوى : الثالثة ثانوي إعدادي. زاوية مركزية. نشاط تمهيدي1 : في هذا الشكل الزاوية BÔAرأسها هومركز الدائرة (C). و [OA] Ù

Minutes 3 August 2015 .pdf
Page 1 of 4. Hoe Tonga Pacifica Waka Ama Association. COMMITTEE MEETING MINUTES. Date: 3 August 2015. Where: Policy College Porirua. Time: 6.30pm – 8pm. Whakataka te hau ki te uru. Whakataka te hau ki te tonga. Kia makinakina i uta. Kia mataratara

August 25, 2015 Minutes.pdf
... Pugh and seconded by William Campbell to. adjourn the meeting. Motion carried 6-0. Katie Daniel, Secretary. Page 2 of 2. August 25, 2015 Minutes.pdf.

JD National Coordinator_01 August - 31 December 2015
Aug 1, 2015 - The United Nations Industrial Development Organization (UNIDO) is a ... and Technology Services Branch of the Programme development and ...

Bond 2015 Presentation to Valley City Council August 2015.pdf ...
Page 2 of 12. Facility Needs. ¡ Fire Code Updates for safety and prevention. ¡ Hardened areas for shelter during severe weather. ¡ Handicapped accessibility in ...

cpu august 2015.pdf
Prices of intel skylake s processors leaked techfrag. Best cpus of 2016. top picks for gaming and performance. Whoops! There was a problem loading this page.