HomeMy WebLinkAbout[04c] Treasurers Report- Novembet Council Agenda Item 4(c)
CITY OF ST,JOSEPH
MEETING DATE: December 19,2016
AGENDA ITEM: Treasurer's Report-November 2016
SUBMITTED BY: Finance
BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A
PREVIOUS COUNCIL ACTION: None
BACKGROUND INFORMATION:
Cash/investment reconciled through November 30,2016. Budget to actual reports attached for Council
review.
The cash and investment balance increased$618,755.63 since the beginning of the year. The first half
tax/assessment proceeds and local government aid was received. In addition,bond proceeds for the
government center and Field Street projects were received. The sewer fund shows a cash deficit of
$221,854(after combining with the SAC fund). It will take time for the cash balance to recover with the
rate increase approved for the November utility bills. Also, development fees will be received in
December for the Fortitude senior housing project. Likely, a transfer will still be needed from other funds
at the end of the year,but at a lower amount with the rate increases.
The General fund spent 88%of the expenditure budget and received 70% of the revenue budget at the end
of November. Building permit revenue is over budget by$88,213 and includes fourteen new homes,
Kwik Trip,the government center and Country Manor senior housing. More activity is expected this year
with Fortitude senior facility project and CSB athletic fields.
The Enterprise funds spent 79%(without depreciation)and received 61%of the revenue budget. The
utility bills represent Jan-October usage. Expenses represent eleven months.
Finally,the last attachment is the monthly summary of the Government Center price revisions and
funding summary as of November 28th
BUDGET/FISCAL IMPACT: None—Information Only
ATTACHMENTS: Request for Council Action—Treasurer's Report
November 2016 Treasurer's Reports:
Cash Balances
Month End Revenue Summary
Month End Revenue Summary—General Fund
Month End Revenue Summary—Enterprise Funds
Month End Expenditure summary
Month End Expenditure Summary—General Fund
Month End Expense Summary—Enterprise Funds
Government Center Financial Summary
REQUESTED COUNCIL ACTION: Accept the Treasurer's Report as presented.
St. Joseph 12/08/16 1:16 PM
4111
Cash Balances Only Page 1
'` Current Period:November 2016
MTD MTD Current
FUND Descr Account Begin Yr Debit Credit Balance
Last Dim 10100
General G 101-10100 $1,441,304.52 $96,329.40 $265,911.12 $917,821.66
Employee Retirement Reserve G 102-10100 $92,558.84 $0.00 $0.00 $99,763.34
Fire Fund G 105-10100 $533,097.17 $2,093.24 $3,040.61 $600,169.98
Cable Access Fee G 108-10100 $19,692.08 $662.98 $0.00 $25,229.61
Economic Development G 150-10100 $73,708.56 $35.65 $5,314.18 $109,807.97
TIF 3-1 CMCU G 152-10100 $403.49 $0.00 $0.00 $154.37
TIF 4-1 Fortitude Senior Apts G 153-10100 $0.00 $2,500.00 $0.00 $1,168.25
TIF 2-1 Millstream G 157-10100 $17,162.21 $5.91 $0.65 $19,304.78
TIF 2-2 Meat Market G 158-10100 $242.94 $0.10 $0.01 $319.30
TIF 2-3 Bayou Blues/Alley Flat G 159-10100 $737.30 $0.00 $0.00 $75.03
State Collected Sales Tax G 200-10100 $1,212,523.90 $40,246.13 $0.00 $1,444,767.81
Park Dedication G 205-10100 $59,507.60 $45.94 $98.01 $118,048.06
Charitable Gambling G 215-10100 $2,391.38 $0.64 $0.07 $2,085.06
Lodging Tax G 220-10100 $0.00 $682.26 $0.00 $682.26
Revolving Loan Fund G 250-10100 $11,993.70 $1,204.66 $0.76 $24,739.72
2016 CIP Bonds[govt center] G 301-10100 $0.00 $642.34 $70.65 $93,778.72
2016 Street Impr[Field St] G 304-10100 $0.00 $36,490.94 $36,414.00 $76.94
2009A CrossoverRefunding Bo G 318-10100 $264,400.44 $60,115.38 $350,187.69 $88,475.21
2011A Refunding Fire Hall G 331-10100 $49,619.06 $10.32 $1.13 $11,394.79
20106 Refundin[Hill/Clover] G 333-10100 $200,060.87 $70.16 $137,231.47 $93,042.96
2011A CO Refund[Interior St] G 338-10100 $116,548.60 $15,027.94 $3.07 $62,090.74
20096 GO CIP Bonds G 343-10100 $1,481.44 $10.06 $57,926.11 -$24,897.58
20106 Street Impr[16th Ave] G 345-10100 $215,398.03 $13,320.03 $57,335.20 $185,744.70
2011A Pumper Truck Certificat G 346-10100 $2,751.90 $1.43 $0.16 -$6,749.08
2011A GO CIP Bonds[roof/gar] G 347-10100 $102.09 $0.52 $0.06 -$5,394.42
2013 Street Improve Bonds G 348-10100 $148,036.77 $48.09 $34,540.29 $123,296.51
2013 Equipment Certificates G 349-10100 $3,338.72 $9.87 $51,651.09 -$19,259.42
2014 Street Impr[ParkTerrace G 350-10100 $199,690.61 $131.82 $136,932.00 $110,609.69
2015 Street[Clinton/Northland] G 351-10100 $23,410.53 $74.96 $61,143.24 $2,198.29
2015 Equipment Certificates G 352-10100 $2,219.85 $15.01 $31,236.65 -$11,551.95
2015 Abatement Bonds[Kenne G 353-10100 $3,391.12 $39.56 $118,121.85 $11,694.43
Debt Service Relief G 390-10100 $184,349.41 $0.00 $0.00 $176,805.09
2016 Government Center G 401-10100 $0.00 $0.00 $15,514.65 $1,567,419.16
2016 Imp Field St G 404-10100 $0.00 $711,546.30 $23,198.35 $372,438.21
2011CIP Bonds[Roof/PD garag G 447-10100 $174,042.45 $0.00 $0.00 $0.00
2014 Imp Park Terrace G 450-10100 $322,466.94 $0.00 $380.90 $184,484.99
2015 Street[Clinton/Northland] G 451-10100 $166,457.50 $0.00 $35,271.66 $121,024.49
2015 Equipment Certificates G 452-10100 $93,173.99 $0.00 $1,180.00 $11,761.21
Capital Outlay G 490-10100 $258,027.64 $0.00 $1,119.20 $231,976.51
WAC Fund G 501-10100 $99.04 $4,949.57 $227,705.45 -$55,050.79
SAC Fund G 502-10100 $123.41 $2,345.36 $237,704.99 -$84,314.44
Water Fund G 601-10100 $2,353.94 $278,606.24 $646,131.49 $31,533.91
Sewer Fund G 602-10100 $750.35 $265,005.26 $184,657.53 -$137,539.87
Refuse Collection G 603-10100 $231,905.94 $19,086.35 $25,967.02 $242,208.44
Storm Water Utility G 651-10100 $229,795.98 $7,249.79 $36,154.30 $236,343.56
Street Light Utility G 652-10100 $19,742.20 $3,556.58 $4,644.98 $20,039.94
Last Dim 10100 $6,379,062.51 $1,562,160.79 $2,786,790.59 $6,997,818.14
Last Dim 10200
General G 101-10200 $275.00 $0.00 $0.00 $275.00
Last Dim 10200 $275.00 $0.00 $0.00 $275.00
St. Joseph 12/08/16 1:16 PM
0 Page 2
, Cash Balances Only
"' " " f‘01$
" Current Period:November 2016
MTD MTD Current
FUND Descr Account Begin Yr Debit Credit Balance
$6,379,337.51 $1,562,160.79 $2,786,790.59 $6,998,093.14
St. Joseph 12/08/16 1:18 PM
•
Council Month End Revenue Summary Page 1
" "'"` Current Period:November 2016
2016 November 2016
FUND FUND Descr YTD Budget 2016 Amt YTD Amt
101 General $2,559,980.00 $38,267.69 $1,795,611.36
102 Employee Retirement Reserve $34,365.00 $0.00 $34,365.00
105 Fire Fund $285,510.00 $2,037.72 $313,352.16
108 Cable Access Fee $8,155.00 $662.98 $6,539.21
150 Economic Development $123,615.00 -$2,468.27 $117,425.39
152 TIF 3-1 CMCU $0.00 $0.00 $0.00
153 TIF 4-1 Fortitude Senior Apts $0.00 $2,500.00 $17,500.00
157 TIF 2-1 Millstream $37,275.00 $5.26 $21,847.96
158 TIF 2-2 Meat Market $4,005.00 $0.09 $4,166.55
159 TIF 2-3 Bayou Blues/Alley Flat $0.00 $0.00 $0.00
200 State Collected Sales Tax $235,520.00 $40,246.13 $342,847.81
205 Park Dedication $355,600.00 $41.93 $65,602.90
215 Charitable Gambling $4,525.00 $0.57 $4,692.60
220 Lodging Tax $0.00 $682.26 $682.26
250 Revolving Loan Fund $12,855.00 $1,203.90 $12,689.34
301 2016 CIP Bonds[govt center] $0.00 $571.69 $202,684.97
304 2016 Street Impr[Field St] $0.00 $36,490.94 $36,490.94
318 2009A CrossoverRefunding Bonds $262,380.00 $60,102.69 $182,935.41
331 2011A Refunding Fire Hall $49,750.00 $9.19 $39,477.84
333 2010B Refundin[Hill/Clover] $101,400.00 $62.44 $36,668.72
338 2011A CO Refund[Interior St] $123,670.00 $15,024.87 $85,344.28
343 2009B GO CIP Bonds $65,100.00 $8.95 $34,598.20
345 20108 Street Impr[16th Ave] $44,570.00 $13,312.33 $34,379.67
346 2011A Pumper Truck Certificate $45,360.00 $1.27 $35,549.91
347 2011A GO CIP Bonds[roof/gar] $27,740.00 $0.46 $16,584.33
348 2013 Street Improve Bonds $21,335.00 $42.80 $13,588.32
349 2013 Equipment Certificates $57,300.00 $8.78 $30,352.20
350 2014 Street Impr[ParkTerrace] $129,645.00 $117.32 $73,003.32
351 2015 Street[Clinton/Northland] $61,940.00 $66.72 $45,734.99
352 2015 Equipment Certificates $32,030.00 $13.36 $18,659.46
353 2015 Abatement Bonds[Kennedy] $164,500.00 $35.21 $164,630.29
390 Debt Service Relief $0.00 $0.00 $11,999.09
401 2016 Government Center $0.00 $0.00 $4,303,942.10
404 2016 Imp Field St $0.00 $711,546.30 $711,546.30
450 2014 Imp Park Terrace $0.00 $0.00 $0.00
451 2015 Street[Clinton/Northland] $0.00 $0.00 $75,000.00
452 2015 Equipment Certificates $0.00 $0.00 $0.00
490 Capital Outlay $60,000.00 $0.00 $40,889.15
501 WAC Fund $433,400.00 $4,944.12 $172,454.45
502 SAC Fund $122,500.00 $2,340.37 $152,746.18
601 Water Fund $1,574,425.00 $306,740.59 $1,002,648.31
602 Sewer Fund $1,579,770.00 $306,947.01 $877,719.91
603 Refuse Collection $284,800.00 $16,381.61 $212,060.58
St. Joseph 12/08/16 1:18 PM
• Page 2
Council Month End Revenue Summary
`�`#°'" .pt`""` Current Period:November 2016
2016 November 2016
FUND FUND Descr YTD Budget 2016 Amt YTD Amt
651 Storm Water Utility $120,285.00 $7,240.99 $69,246.10
652 Street Light Utility $61,035.00 $3,555.86 $41,975.68
$9,084,340.00 $1,568,746.13 $11,460,233.24
St. Joseph 12/08/16 1:18 PM
Council Month End Revenue -General Fund Page 1
Current Period:November 2016
2016 November 2016
FUND FUND Descr SOURCE Descr YTD Budget 2016 Amt YTD Amt
FUND 101 General
101 General Current Ad Valorem Taxes $1,062,065.00 $0.00 $582,422.79
101 General Special Levy-City St.Joe $0.00 $0.00 $0.00
101 General State Sales Tax $0.00 -$59.10 $0.00
101 General Gas Franchise $31,070.00 $6,127.27 $21,007.23
101 General Electric Franchise $54,570.00 $11,375.19 $45,057.98
101 General Beer $1,525.00 $450.00 $1,647.50
101 General Liquor $19,760.00 $0.00 $22,669.17
101 General Outdoor Liquor Permit $2,500.00 $0.00 $1,900.00
101 General Gambling Permits $200.00 $40.00 $355.00
101 General Amusement/Hunt/Peddler/Golf $1,395.00 $840.00 $1,477.13
101 General Excavation Permit $500.00 $200.00 $900.00
101 General Cigarette License $600.00 $375.00 $406.25
101 General Cable Franchise Fee $33,385.00 $1,340.70 $26,290.58
101 General Building Permits $90,000.00 $6,863.84 $178,213.19
101 General Animal License $3,390.00 $25.00 $3,300.00
101 General Rental Housing Registration $23,000.00 $0.00 $27,170.00
101 General Federal Grants-Other $5,000.00 $2,651.11 $4,561.77
101 General State Grants and Aids $950.00 $0.00 $78.32
101 General Local Government Aid $913,700.00 $0.00 $456,850.50
101 General PERA Rate Increase Aid $1,540.00 $0.00 $770.50
101 General Police Training Reim $3,500.00 $0.00 $2,813.95
101 General State Municipal Funds Aid $48,175.00 $0.00 $49,596.00
101 General State Police Aid $55,000.00 $0.00 $61,805.42
101 General Other Grants/Aids $250.00 $0.00 $0.00
101 General Other Governmental Unit $10,000.00 $0.00 $10,000.00
101 General County Grants-Road Maint. $7,745.00 $0.00 $95,000.00
101 General Zoning and Subdivision Fee $1,000.00 $870.00 $8,369.00
101 General Land Use Deposit Fee $4,000.00 -$20,958.85 $17,541.15
101 General Sale of Maps and Publications $50.00 $2.00 $20.25
101 General Assessments Search $2,750.00 $450.00 $4,320.00
101 General Special Hearing $5,000.00 $0.00 $5,400.00
101 General Administration Reimb $14,085.00 $0.00 $1,270.56
101 General Weed Cutting $500.00 $0.00 $1,200.00
101 General Admission Fee $0.00 $0.00 $0.00
101 General Shelter/Room Rental Fees $5,500.00 $0.00 $5,230.00
101 General Ball Field Donation $250.00 $0.00 $0.00
101 General Schneider Field Rental $1,500.00 $0.00 $1,210.00
101 General Rents and Royalties $40,000.00 $3,466.98 $38,136.78
101 General Kennel Fees $700.00 $0.00 $560.00
101 General County Fines $26,000.00 $3,204.45 $25,436.02
101 General Policy Fines $14,000.00 $950.00 $9,740.01
101 General Accident Report Fee $1,200.00 $96.50 $864.25
St. Joseph 12/08/16 1:18 PM
• Page 2
Council Month End Revenue -General Fund
`" "y„i..0.0t,i`-` Current Period:November 2016
2016 November 2016
FUND FUND Descr SOURCE Descr YTD Budget 2016 Amt YTD Amt
101 General Seized Property $1,000.00 $310.10 $854.10
101 General Special Assessments $3,000.00 -$207.05 $614.35
101 General Interest Earnings $22,500.00 $442.66 $22,559.93
101 General Interest Charges $200.00 $25.17 $25.37
101 General Co-op Dividend-LMCIT $12,000.00 $198.81 $198.81
101 General Water Tower Antenna Lease $3,770.00 $314.69 $3,609.30
101 General Advertising $1,500.00 $400.00 $1,430.00
101 General Contributions-General $500.00 $2,000.00 $18,816.86
101 General Contributions-Parks $1,200.00 $6.00 $1,318.09
101 General Surplus Property $0.00 $0.00 $0.00
101 General Reimbursement $27,955.00 $327.22 $16,453.25
101 General Transfers from Other Funds $0.00 $16,140.00 $16,140.00
FUND 101 General $2,559,980.00 $38,267.69 $1,795,611.36
FUND 102 Employee Retirement Reserve
102 Employee Retirement Res Transfers from Other Funds $34,365.00 $0.00 $34,365.00
FUND 102 Employee Retirement Reserve $34,365.00 $0.00 $34,365.00
FUND 108 Cable Access Fee
108 Cable Access Fee Cable Franchise Fee $8,155.00 $662.98 $6,539.21
108 Cable Access Fee Transfers from Other Funds $0.00 $0.00 $0.00
FUND 108 Cable Access Fee $8,155.00 $662.98 $6,539.21
FUND 150 Economic Development
150 Economic Development Current Ad Valorem Taxes $122,365.00 $0.00 $56,549.31
150 Economic Development Federal Grants-Other $0.00 $0.00 $49,425.00
150 Economic Development TIF/MIF Deposit $0.00 -$2,500.00 $10,000.00
150 Economic Development DEED Housing Reimbursement $0.00 $0.00 $0.00
150 Economic Development Interest Earnings $1,250.00 $31.73 $1,451.08
150 Economic Development Transfers from Other Funds $0.00 $0.00 $0.00
FUND 150 Economic Development $123,615.00 -$2,468.27 $117,425.39
FUND 152 TIF 3-1 CMCU
152 TIF 3-1 CMCU Tax Increment $0.00 $0.00 $0.00
152 TIF 3-1 CMCU Interest Earnings $0.00 $0.00 $0.00
152 TIF 3-1 CMCU Transfers from Other Funds $0.00 $0.00 $0.00
FUND 152 TIF 3-1 CMCU $0.00 $0.00 $0.00
FUND 153 TIF 4-1 Fortitude Senior Apts
153 TIF 4-1 Fortitude Senior A Tax Increment $0.00 $0.00 $0.00
153 TIF 4-1 Fortitude Senior A TIF/MIF Deposit $0.00 $2,500.00 $17,500.00
153 TIF 4-1 Fortitude Senior A Interest Earnings $0.00 $0.00 $0.00
153 TIF 4-1 Fortitude Senior A Transfers from Other Funds $0.00 $0.00 $0.00
FUND 153 TIF 4-1 Fortitude Senior Apts $0.00 $2,500.00 $17,500.00
FUND 159 TIF 2-3 Bayou Blues/Alley Flat
159 TIF 2-3 Bayou Blues/Alley Tax Increment $0.00 $0.00 $0.00
159 TIF 2-3 Bayou Blues/Alley Interest Earnings $0.00 $0.00 $0.00
St. Joseph 12/08/16 1:18 PM
a Page 3
Council Month End Revenue -General Fund
. ' ""` Current Period:November 2016
2016 November 2016
FUND FUND Descr SOURCE Descr YTD Budget 2016 Amt YTD Amt
159 TIF 2-3 Bayou Blues/Alley Transfers from Other Funds $0.00 $0.00 $0.00
FUND 159 TIF 2-3 Bayou Blues/Alley Flat $0.00 $0.00 $0.00
$2,726,115.00 $38,962.40 $1,971,440.96
St. Joseph 12/08/16 1:17 PM
, Council Month End Expenditure - Summary Page 1
`' '" ' Current Period:November 2016
2016 November 2016
Description YTD Budget 2016 Amt YTD Amt
General $2,569,980.00 $209,277.85 $2,259,600.42
Employee Retirement Reserve $34,365.00 $0.00 $27,160.50
Fire Fund $312,525.00 $2,985.09 $197,855.16
Cable Access Fee $2,010.00 $0.00 $1,675.94
Economic Development $123,615.00 $2,810.26 $81,781.27
TIF 3-1 CMCU $795.00 $0.00 $249.12
TIF 41 Fortitude Senior Apts $0.00 $0.00 $16,331.75
TIF 2-1 Millstream $34,545.00 $0.00 $19,873.86
TIF 2-2 Meat Market $4,545.00 $0.00 $4,090.81
TIF 2-3 Bayou Blues/Alley Flat $795.00 $0.00 $662.27
State Collected Sales Tax $2,874,000.00 $0.00 $164,855.84
Park Dedication $393,700.00 $94.00 $7,281.51
Charitable Gambling $0.00 $0.00 $5,007.76
Lodging Tax $0.00 $0.00 $0.00
Revolving Loan Fund $0.00 $0.00 $0.00
2016 CIP Bonds[govt center] $0.00 $0.00 $108,906.25
2016 Street Impr[Field St] $0.00 $36,414.00 $36,414.00
2009A CrossoverRefunding Bon $360,625.00 $350,175.00 $360,350.00
2011A Refunding Fire Hall $74,750.00 $0.00 $78,000.00
2010B Refundin[Hill/Clover] $144,750.00 $137,223.75 $144,447.50
2011A CO Refund[Interior St] $142,130.00 $0.00 $142,225.00
2009B GO CIP Bonds $61,450.00 $57,925.00 $61,345.00
2010B Street Impr[16th Ave] $64,855.00 $57,327.50 $64,655.00
2011A Pumper Truck Certificate $45,360.00 $0.00 $45,160.00
2011A GO CIP Bonds[roof/gar] $22,720.00 $0.00 $22,520.00
2013 Street Improve Bonds $39,270.00 $34,535.00 $39,070.00
2013 Equipment Certificates $53,500.00 $51,650.00 $53,300.00
2014 Street Impr[ParkTerrace] $164,035.00 $136,917.50 $163,835.00
2015 Street[Clinton/Northland] $67,470.00 $61,135.00 $67,255.00
2015 Equipment Certificates $32,670.00 $31,235.00 $32,470.00
2015 Abatement Bonds[Kenned $141,435.00 $118,117.50 $156,646.65
Debt Service Relief $0.00 $0.00 $20,184.50
2016 Government Center $0.00 $15,514.65 $2,736,522.94
2016 Imp Field St $0.00 $23,198.35 $339,108.09
2011CIP Bonds[Roof/PD garag $0.00 $0.00 $174,042.45
2014 Imp Park Terrace $0.00 $380.90 $11,535.57
2015 Street[Clinton/Northland] $0.00 $35,271.66 $104,340.90
2015 Equipment Certificates $0.00 $1,180.00 $81,412.78
Capital Outlay $60,000.00 $1,119.20 $67,300.54
WAC Fund $416,500.00 $227,700.00 $227,700.00
SAC Fund $46,000.00 $237,700.00 $237,700.00
Water Fund $1,574,425.00 $674,265.84 $1,039,384.29
Sewer Fund $1,758,740.00 $226,599.28 $980,110.88
St. Joseph 12/08/16 1:17 PM
0 Page 2
Council Month End Expenditure - Summary
—.4...,,,,h,.. Current Period:November 2016
2016 November 2016
Description YTD Budget 2016 Amt YTD Amt
Refuse Collection $286,460.00 $23,262.28 $237,294.53
Storm Water Utility $214,375.00 $36,145.50 $85,665.25
Street Light Utility $69,590.00 $4,644.26 $48,759.65
$12,191,985.00 $2,794,804.37 $10,754,087.98
St. Joseph 12/08/16 1:16 PM
Council Month End Expenditure -General Fund Page 1
4, 4xi44.441" ' Current Period:November 2016
2016 November 2016
Description DEPART Descr YTD Budget 2016 Amt YTD Amt
FUND 101 General
General Council $60,725.00 $1,528.21 $45,653.84
General Legislative Committees $5,565.00 $11.73 $2,853.70
General Ordinance&Proceedings $1,600.00 $0.00 $2,691.33
General Mayor $10,985.00 $670.37 $7,980.85
General Elections $750.00 $5,600.12 $9,430.56
General General Adminstration $236,595.00 $16,280.54 $202,122.36
General Finance $127,685.00 $8,537.06 $100,610.52
General Audit Service $27,450.00 $0.00 $26,950.00
General Assessing $23,500.00 $0.00 $23,468.80
General City Attorney $16,000.00 -$832.50 $5,553.00
General Planning and Zoning $54,385.00 $4,194.41 $39,206.35
General General Government $20,675.00 $2,494.37 $17,735.76
General City Offices $33,575.00 $2,151.42 $25,773.88
General Facilites and Planning $0.00 $0.00 $0.00
General Cable Access $11,065.00 $995.31 $9,329.62
General Crime Control&Investigation $952,830.00 $60,285.26 $821,506.13
General Police Training $9,545.00 $75.00 $7,691,36
General Communication Service $10,870.00 $843.28 $9,561.23
General Automotive Services $52,200.00 $2,528.03 $32,943.86
General Building Inspec.Admistration $92,000.00 $7,500.00 $84,162.20
General Emergency Management $960.00 $7.66 $2,570.15
General Animal Control $965.00 $0.00 $274.50
General Street Maintanence $274,350.00 $95,316.32 $264,518.87
General Ice&Snow Removal $112,710.00 $1,972.49 $41,248.67
General Engineering Fee $30,000.00 -$14,622.19 $26,541.38
General Street Cleaning $13,665.00 $1,788.96 $8,436.35
General Skate Park and Ice Rink $5,240.00 $46.40 $3,079.17
General Ball Park $1,750.00 $0.00 $616.34
General Maintenance Shop $27,365.00 $1,257.25 $18,813.42
General Park Areas $218,995.00 $9,748.37 $232,717.80
General Community Center $30,920.00 $899.98 $51,538.22
General Other Financing Uses $0.00 $0.00 $31,500.00
General Fire Protection $105,060.00 $0.00 $102,520.20
FUND 101 General $2,569,980.00 $209,277.85 $2,259,600.42
FUND 102 Employee Retirement Reserve
Employee Retirement Resery General Adminstration $34,365.00 $0.00 $27,160.50
FUND 102 Employee Retirement Reserve $34,365.00 $0.00 $27,160.50
FUND 108 Cable Access Fee
Cable Access Fee Cable Access $2,010.00 $0.00 $1,675.94
FUND 108 Cable Access Fee $2,010.00 $0.00 $1,675.94
FUND 150 Economic Development
St. Joseph 12/08/16 1:16 PM
aPage 2
, Council Month End Expenditure - General Fund
"' '"- Current Period:November 2016
2016 November 2016
Description DEPART Descr YTD Budget 2016 Amt YTD Amt
Economic Development Economic Development Authority $123,615.00 $2,810.26 $81,781.27
Economic Development Other Financing Uses $0.00 $0.00 $0.00
FUND 150 Economic Development $123,615.00 $2,810.26 $81,781.27
FUND 152 TIF 3-1 CMCU
TIF 3-1 CMCU Economic Development Authority $795.00 $0.00 $249.12
TIF 3-1 CMCU Other Financing Uses $0.00 $0.00 $0.00
FUND 152 TIF 3-1 CMCU $795.00 $0.00 $249.12
FUND 153 TIF 4-1 Fortitude Senior Apts
TIF 4-1 Fortitude Senior Apts Economic Development Authority $0.00 $0.00 $16,331.75
FUND 153 TIF 4-1 Fortitude Senior Apts $0.00 $0.00 $16,331.75
FUND 159 TIF 2-3 Bayou Blues/Alley Flat
TIF 2-3 Bayou Blues/Alley Fl Economic Development Authority $795.00 $0.00 $662.27
TIF 2-3 Bayou Blues/Alley Fl Other Financing Uses $0.00 $0.00 $0.00
FUND 159 TIF 2-3 Bayou Blues/Alley Flat $795.00 $0.00 $662.27
FUND 401 2016 Government Center
2016 Government Center City Offices $0.00 $15,514.65 $2,701,074.02
2016 Government Center Other Financing Uses $0.00 $0.00 $35,448.92
FUND 401 2016 Government Center $0.00 $15,514.65 $2,736,522.94
FUND 404 2016 Imp Field St
2016 Imp Field St Street Maintanence $0.00 $23,198.35 $339,108.09
FUND 404 2016 Imp Field St $0.00 $23,198.35 $339,108.09
FUND 490 Capital Outlay
Capital Outlay General Adminstration $8,145.00 $0.00 $19,582.84
Capital Outlay Crime Control&Investigation $1,185.00 $0.00 $720.00
Capital Outlay Communication Service $5,170.00 $0.00 $5,106.10
Capital Outlay Automotive Services $14,045.00 $959.20 $30,339.28
Capital Outlay Emergency Management $1,500.00 $0.00 $0.00
Capital Outlay Street Maintanence $1,625.00 $0.00 $0.00
Capital Outlay Ice&Snow Removal $5,375.00 $160.00 $11,552.32
Capital Outlay Street Cleaning $3,750.00 $0.00 $0.00
Capital Outlay Maintenance Shop $4,125.00 $0.00 $0.00
Capital Outlay Park Areas $15,080.00 $0.00 $0.00
Capital Outlay Other Financing Uses $0.00 $0.00 $0.00
FUND 490 Capital Outlay $60,000.00 $1,119.20 $67,300.54
$2,791,560.00 $251,920.31 $5,530,392.84
St. Joseph 12/08/16 1:17 PM
Council Month End Expense - Enterprise Funds Page 1
.-,,,,,,,,f--ph",., Current Period:November 2016
2016 November 2016
Description DEPART Descr YTD Budget 2016 Amt YTD Amt
FUND 601 Water Fund
Water Fund Bond Payment(P&I) $692,345.00 $616,591.25 $680,188.50
Water Fund Other Financing Uses $38,215.00 $35,000.00 $35,715.00
Water Fund Power and Pumping $21,105.00 $408.25 $26,425.51
Water Fund Purification-Plant 1 $43,935.00 $1,196.32 $16,790.01
Water Fund Purification-Plant 2 $80,275.00 $5,445.65 $64,120.95
Water Fund Distribution $10,000.00 $0.00 $15,591.70
Water Fund Wellhead Protection $3,000.00 $0.00 $0.00
Water Fund Storage-Tower 1 $16,145.00 $2,545.55 $7,102.61
Water Fund Water Maintenance $232,210.00 $11,165.07 $166,091.12
Water Fund Administration and General $37,195.00 $1,913.75 $27,358.89
Water Fund Depredation Expense $400,000.00 $0.00 $0.00
FUND 601 Water Fund $1,574,425.00 $674,265.84 $1,039,384.29
FUND 602 Sewer Fund
Sewer Fund Bond Payment(P&I) $222,970.00 $172,308.75 $217,345.50
Sewer Fund Other Financing Uses $45,935.00 $42,000.00 $43,435.00
Sewer Fund Sanitary Sewer Maintenanc $198,560.00 $8,291.25 $130,831.88
Sewer Fund Lift Station-Baker Street $5,885.00 $225.07 $2,542.31
Sewer Fund Lift Station-Ridgewood/DBL $2,980.00 $134.59 $11,194.66
Sewer Fund Lift Station-Northland $4,365.00 $118.34 $1,392.08
Sewer Fund Lift Station-CR 121 $4,610.00 $142.79 $1,914.90
Sewer Fund Lift Station-Main $862,390.00 $1,419.44 $543,112.51
Sewer Fund Administration and General $36,045.00 $1,959.05 $28,342.04
Sewer Fund Depreciation Expense $375,000.00 $0.00 $0.00
FUND 602 Sewer Fund $1,758,740.00 $226,599.28 $980,110.88
FUND 603 Refuse Collection
Refuse Collectio Waste Collection $278,525.00 $21,122.28 $234,439.53
Refuse Collectio Other Financing Uses $1,435.00 $2,140.00 $2,855.00
Refuse Collectio Depreciation Expense $6,500.00 $0.00 $0.00
FUND 603 Refuse Collection $286,460.00 $23,262.28 $237,294.53
FUND 651 Storm Water Utility
Storm Water Uti Other Financing Uses $18,965.00 $32,250.00 $32,250.00
Storm Water Uti Administration and General $16,375.00 $920.14 $14,934.74
Storm Water Uti Storm Water Maintenance $79,035.00 $2,975.36 $38,480.51
Storm Water Uti Depreciation Expense $100,000.00 $0.00 $0.00
FUND 651 Storm Water Utility $214,375.00 $36,145.50 $85,665.25
FUND 652 Street Light Utility
Street Light Utili Street Lighting $69,590.00 $4,644.26 $48,759.65
FUND 652 Street Light Utility $69,590.00 $4,644.26 $48,759.65
$3,903,590.00 $964,917.16 $2,391,214.60
St. Joseph 12/08/16 1:17 PM
•
Council Month End Revenue -Enterprise Funds Page 1
--,4....u0.. Current Period:November 2016
FUND 2016 November 2016
FUND Descr SOURCE Descr YTD Budget 2016 Amt YTD Amt
FUND 601 Water Fund
601 Water Fund Penalties and Forfeited Disc $8,000.00 $907.46 $7,152.01
601 Water Fund Current Ad Valorem Taxes $73,500.00 $0.00 $38,705.92
601 Water Fund Transfers from Other Funds $416,500.00 $234,700.00 $234,700.00
601 Water Fund Contributed Revenue $0.00 $0.00 $0.00
601 Water Fund MDS Test Fee $11,880.00 $767.95 $8,120.19
601 Water Fund Water Meter $5,000.00 $945.00 $16,220.00
601 Water Fund Connection/Reconnection fees $200.00 $0.00 $112.00
601 Water Fund Undesignated Funds $0.00 -$4,853.19 -$10,731.93
601 Water Fund Bulk Water $1,500.00 $1,297.50 $12,805.39
601 Water Fund Special Assessments $200.00 $0.00 -$762.23
601 Water Fund Reimbursement $0.00 $0.00 $165.00
601 Water Fund Surplus Property $0.00 $0.00 $0.00
601 Water Fund State Sales Tax $0.00 $242.57 $229.19
601 Water Fund Water Tower Antenna Lease $33,985.00 $2,832.17 $32,483.24
601 Water Fund Amortization of Bond Premium $0.00 $0.00 $0.00
601 Water Fund Interest Earnings $34,140.00 $473.89 $26,081.73
601 Water Fund Rate Class One $694,985.00 $47,284.51 $432,380.30
601 Water Fund Water Line Charge $294,535.00 $22,142.73 $204,987.50
FUND 601 Water Fund $1,574,425.00 $306,740.59 $1,002,648.31
FUND 602 Sewer Fund
602 Sewer Fund Surplus Property $0.00 $0.00 $1.00
602 Sewer Fund Contributions-General $8,000.00 $0.00 $0.00
602 Sewer Fund Amortization of Bond Premium $0.00 $0.00 $0.00
602 Sewer Fund Interest Earnings $3,925.00 -$16.84 -$1,280.42
602 Sewer Fund Special Assessments $200.00 $0.00 -$16.00
602 Sewer Fund Other Grants/Aids $0.00 $0.00 $0.00
602 Sewer Fund Contributed Revenue $0.00 $0.00 $0.00
602 Sewer Fund Sanitary Sewer Service $1,063,345.00 $38,793.31 $343,349.56
602 Sewer Fund Other Governmental Unit $1,500.00 $0.00 $0.00
602 Sewer Fund Penalties and Forfeited Disc $11,750.00 $426.80 $4,416.15
602 Sewer Fund Sewer Line Charge $347,650.00 $26,583.74 $290,089.62
602 Sewer Fund Transfers from Other Funds $143,200.00 $237,700.00 $237,700.00
602 Sewer Fund Reimbursement $200.00 $3,460.00 $3,460.00
FUND 602 Sewer Fund $1,579,770.00 $306,947.01 $877,719.91
FUND 603 Refuse Collection
603 Refuse Collec Penalties and Forfeifted Disc $5,700.00 $493.53 $5,184.47
603 Refuse Collec Reimbursement $0.00 $0.00 $628.55
603 Refuse Collec Contributions-General $0.00 $0.00 $0.00
603 Refuse Collec Special Assessments $200.00 $0.00 -$20.05
603 Refuse Collec Contributed Revenue $0.00 $0.00 $0.00
603 Refuse Collec Refuse Collection Charges $258,260.00 $16,855.92 $186,871.36
603 Refuse Collec Licenses&Permits $18,140.00 $30.00 $18,390.00
603 Refuse Collec State Sales Tax $0.00 -$1,064.40 -$3,205.31
603 Refuse Collec Interest Earnings $2,500.00 $66.56 $4,211.56
FUND 603 Refuse Collection $284,800.00 $16,381.61 $212,060.58
FUND 651 Storm Water Utility
651 Storm Water Development Fee $10,000.00 $0.00 $0.00
651 Storm Water Transfers from Other Funds $0.00 $0.00 $0.00
651 Storm Water Penalties and Forfeifted Disc $2,060.00 $117.45 $1,234.73
651 Storm Water Rate Class One $101,180.00 $7,052.29 $70,275.25
St. Joseph 12/08/16 1:17 PM
aPage 2
Council Month End Revenue -Enterprise Funds
— ' ` Current Period:November 2016
FUND 2016 November 2016
FUND Descr SOURCE Descr YTD Budget 2016 Amt YTD Amt
651 Storm Water Contributed Revenue $0.00 $0.00 $0.00
651 Storm Water Reimbursement $0.00 $0.00 $0.00
651 Storm Water Special Assessments $4,795.00 $0.00 -$6,541.63
651 Storm Water Interest Earnings $2,250.00 $71.25 $4,277.75
FUND 651 Storm Water Utility $120,285.00 $7,240.99 $69,246.10
FUND 652 Street Light Utility
652 Street Light U Transfers from Other Funds $0.00 $0.00 $0.00
652 Street Light U Special Assessments $50.00 $0.00 -$2.05
652 Street Light U Interest Earnings $250.00 $5.82 -$923.57
652 Street Light U Reimbursement $0.00 $0.00 $0.00
652 Street Light U Rate Class One $60,535.00 $3,494.12 $42,295.66
652 Street Light U Penalties and Forfeited Disc $200.00 $55.92 $605.64
FUND 652 Street Light Utility $61,035.00 $3,555.86 $41,975.68
$3,620,315.00 $640,866.06 $2,203,650.58
St.Joseph Government Center
Summary of Contract Changes(Price Revisions)
Justification Increase(Decrease) Contractors Impacted
Control#
P iden'sidetvalk'and leave fire hydrant in
;SFS (852.00) C&L Excavating
place;; •
PR 1 Changed the exterior lighting $ (3,882.00) Kasella,C&L Excavating
Change the head steel header plat le
P 1,798;00 Hat,I&H Erectors,Thurnbeck
?ttatch'�dmltllat�"
PR 3 Adjust steel structure to support partition $ 103.00 Kasella,HTH,J&H Erectors,Thurnbeck
wall
Kasella,l3TH,Yamry,Mid Central Door,
Revision for ambulance area,not planned Central MN Ceilings,Floors by Beckers,
$
when plans were drafted 8,21$.13 Fransen,Breth-Zenzen,Weidener,SCR.Design,
Electric,C&L Excavating
PR 5 Removal of two smoke dampers that are $
not needed (570.00) Yamry,Mid Central Door
• changed the type.of verxteer to match(no
PR 7 Plans did not include header over
Window W3,Room 119 $ 352.00 J&11 Erectors,Thurnbeck,Reinert Drywall,
The structural still as designed did net •
PR 8 work for the Operable wall contractor $, 1,248.00 J&H Erectors,Thurnbeck,Reinert Drywall,
• (partition door).-No cost
PR 9 Reviewed door strikes adding where $ 1,610.87 Design Electric,Mid Central Door
needed.
TPR 1 : roof parapet flashing accent • $, 289,00 Roof 1
Original flag lighting was pole style and
PR 11 with the new location we are going $ 1,651.90 Design Electric
ground mount.
Omit tire 2.5 furring behind architectural.
1 12 precast but-maintainxi id insulation;(no °S HTI1,Yamry
PR 13 Dedication Plaque $ 457.00 Benton Trophy,Yamry
Addu11proof glass protection for- Yamry,ICG,Mid Central Door,American
• PR 14 $: 16,56aoo
• reception areas,' Door,East Side Glass,Reinert Drywall
PR 15 change to corner stone material to match
(no cost) $ HTH
Chan a rn radius of'dias to allow-for-
PIS 16 13 •
bullet roof te
$` , 3,870.o0 DesignElectric, ICG
pniaria1
PR 17 Modifications to hoesbib fixture at the
garage and sally port(no cost) Weidner Mechanical
Remove the casework in the meeting
P 113; " $ (2,016,00) Yamry,ICG
room 147;eotivertirig to office
PR 19 Addition of 12 brick support angles $ 1,639.00 THTH,Thurnbeck,Yamry
• lstt „Prtovideblack or t shades the"police $ 480.00 Kustom Blinds
of ice windows,
Change in roof density insulation. The
PR 21 original was a longer lead time and both $ (1,616.00) Roof 1
products are similar.
Roof 1,Fransen,Weidner,SCR,Design
PR 22 Add locker ventilation system, $ 6938..92 Electric
PR 23 Add Building Sign Address $ 375.81 North Star Signs
Add Max Lead and room occulc3'
P 24; $ 375.81 North Star Signs
ams ,
PR 25 Eliminate guides for shades in Council $ (332.00) Kustom Blinds
Chambers
Revise size •and quantity of lockers.
PR
27 Rooin4imnsiona do not support the $ (4,523.14) Mid-America(Lockers),Design Electric
;number of 24"lockers on the plan. "
PR 30 Revision to Lighting in CATV Room $ 455.08 Design Electric
St.Joseph Government Center
Summary of Contract Changes(Price Revisions)
Justification Increase(Decrease) Contractors Impacted
Control#
PR 31 Revision to storage room 118 $ 1,157.00 HTH,Yamry,Mid Central Door,Reinert
Drywall
„,,YJ?,/ 32 Sign on,l uilding $ 7,125.78 Design Electric,Scenic Sign
PR 33 Monument Sign $ 56,224.89 Design Electric,Scenic Sign
PRS/34;/Addition°A].Rin 124 % $ 864.00 Design Elec e,Reinert Drywall
PR 35 Addition of Projector,Screen Power,
Data $ 806.51 Design Electric
6 Concrete Slab for Generator%/ $ ; 750.00 Kasella Concrete,Design Electric
PR 37 Omit linear diffuser Room 119 $ (110.00) Weidner Mechanical
/, Generator � i` ' $ ./ z 56,19212 "" Design Electric
PR 38 sidewalk $ 2,974.50 Kasella Concrete,C&L Excavating
PR 39 159se wall finishes in ambulance staff rm $ 5.00 Floors by Becker,Fransen Decorating
1'R �1 ,�i to'ilia seala41 cetlt ig ;<„$” /r 45,130.00 3;; Weidner Mechanical
air transfer l�les
additionof conduit for CCTV •
1� i #iittl- $+ 747.22. Design Electric
$ 204,498.40
Contract Summary as of 11-23-16
Additional Design Fees $ 30,000.00 2016 Bond Proceeds $ 4,275,000.00
Contracts-Accepted Bids $ 3,370,302.85 2011 Bond Fund-HVAC $ 84,042.45
Construction Management $ 280,000.00 Sale of Building $ 500,000.00
Contingency $ 425,543.58 MN OSHA Grant $ 7,000.00
Architectural/Engineer $ 312,849.05 General Fund Approved $ 30,000.00
Less:Fees paid in 2014 $ (215,584.05) Total Avail Revenue $ 4,896,042.45
Architectural Reimb $ 5,000.00
Civil Engineering/Survey $ 32,199.04
Overhead job costs $ 117,135.00 Spent to date $ (3,254,661.45)
Soil Borings $ 2,700.00 Balance remaining $ 1,641,381.00
Fiber Optics $ 7,500.00
Exterior Signage Allowance $ 24,000.00
Technology Allowance $ 150,000.00
Phone System $ 65,000.00
Furniture/Appliances $ 140,000.00
Reroute Gas $ 3,904.00
Finance Costs $ 55,100.35
Building Permit $ 83,350.18
$ 4,889,000.00