Preparing Budgets and Budget Decisions

profiletnttnt
Appendix1B1C1D1Eexampleonlyforbudgetassignment.xls

Appendix 1B

City of Cambridge
Budget Summary
FY 2014-2015
General Fund Central Garage Water &Sewer Sanitation Grand Total
FUNDING SOURCE
Property Taxes $1,483,000 $0 $0 $0 $1,483,000
Insurance Taxes 885,000 - 41,500 - 926,500
Vehicle Stickers 420,000 - - - 420,000
Business Licenses 350,000 - - - 350,000
User Charges - 116,250 3,421,500 1,884,000 5,421,750
Special Assessments - - 195,000 50,000 245,000
Other & Misc. 662,779 - - - 662,779
Fund Transfers - - - - -
TOTAL Revenues $3,800,779 $116,250 $3,658,000 $1,934,000 $9,509,029
Beginning Fund 650,000 - - 50,600 700,600
TOTAL Available Funds $4,450,779 $116,250 $3,658,000 $1,984,600 $10,209,629
EXPENDITURES
General Government $1,309,454 $0 $0 $0 $1,309,454
Public Safety 2,781,100 - - - 2,781,100
Public Works 360,225 - - - 360,225
Central Garage - 116,250 - - 116,250
Sanitation - - - 1,984,600 1,984,600
Water &Sewer Oper. - - 3,658,000 - 3,658,000
Cemetery Operations - - - - -
Gas System Oper. - - - - -
Capital Expenditures - - - - -
TOTAL Expenditures $4,450,779 $116,250 $3,658,000 $1,984,600 $10,209,629
these 4 worksheets are examples only
&A
Page &P

Appendix 1C

San Pablo
Sources of Revenue
FY 2013 Est. FY 2014 Est. FY 2015 Est. Net Change % Change
BALANCE FORWARD $525,756.30 $174,868.50 $50,621.10
Sales and Use Tax $2,555,557.00 $2,715,000.00 $2,875,500.00 $160,500.00 5.91%
Income Tax-Ind. 2,095,499.10 2,299,760.00 2,472,728.00 172,968.00 7.52%
Income Tax-Corp. 496,023.90 512,000.00 512,000.00 0.00 0.00%
Other 708,760.60 657,882.90 674,568.80 16,685.90 2.54%
TOTAL Base Revenue $6,381,596.90 $6,359,511.40 $6,585,417.90 $350,153.90 5.51%
&A
Page &P

Appendix 1D

Source of Expenditures
Nowhere Mississippi (amounts in millions)
FY 2013 App. FY 2014 Request Net Change % Change
General Government $2,345.00 $2,498.00 $153.00 6.52%
Public Safety 7,129.00 7,893.00 764.00 10.72%
Health and Human Services 27,189.00 31,890.00 4,701.00 17.29%
Public Education 28,000.00 30,000.00 2,000.00 7.14%
Higher Education 13,685.00 14,589.00 904.00 6.61%
Judiciary 386.00 399.00 13.00 3.37%
Natural Resources 1,693.00 1,785.00 92.00 5.43%
Business & Economic Dev. 10,456.00 11,000.00 544.00 5.20%
Regulatory 456.00 469.00 13.00 2.85%
Article IX 721.00 732.00 11.00 1.53%
Other 250.00 255.00 5.00 2.00%
DEPARTMENT TOTAL $92,310.00 $101,510.00 $9,200.00 9.97%
&A
Page &P

Appendix 1E

City of Hardin
Fire Dept
FY 2013 Actual FY 2014 Budg. FY 2015 Est. Net Change % Change
SALARIES $658,939.00 $731,000.00 $765,000.00 $34,000.00 4.65%
Education 150.00 500.00 500.00 0.00 0.00%
Life Insurance 1,268.00 2,150.00 1,500.00 -650.00 -30.23%
Medical Insurance 110,467.00 120,000.00 120,000.00 0.00 0.00%
Social Security 51,689.00 57,500.00 57,500.00 0.00 0.00%
State Incentive 70,054.00 72,500.00 72,500.00 0.00 0.00%
Workmen's Compensation 38,660.00 36,000.00 40,000.00 4,000.00 11.11%
Kentucky Retirement 126,853.00 137,000.00 145,000.00 8,000.00 5.84%
Subtotal $1,058,080.00 $1,156,650.00 $1,202,000.00 $45,350.00 3.92%
OPERATING EXPENSES
Station II Facility $5,575.00 $3,500.00 $3,500.00 $0.00 0.00%
Fire Hydrants 23,414.00 23,500.00 24,250.00 750.00 3.19%
Water, Sewer & Gas 3,344.00 3,500.00 3,500.00 0.00 0.00%
Electricity 1,641.00 2,000.00 2,000.00 0.00 0.00%
Office Supplies 1,581.00 1,500.00 1,500.00 0.00 0.00%
Gasoline 4,854.00 5,000.00 5,000.00 0.00 0.00%
Uniforms 15,554.00 12,000.00 12,000.00 0.00 0.00%
Training School & Supplies 703.00 2,500.00 2,500.00 0.00 0.00%
Vehicle Repair and Maint. 8,514.00 15,000.00 15,000.00 0.00 0.00%
Housekeeping Supplies 1,130.00 1,000.00 1,000.00 0.00 0.00%
Travel & Meetings 1,262.00 1,500.00 1,500.00 0.00 0.00%
Dues & Subscriptions 280.00 300.00 300.00 0.00 0.00%
Miscellaneous 5,014.00 5,000.00 5,000.00 0.00 0.00%
Fire Marshall Office 3,707.00 3,500.00 3,500.00 0.00 0.00%
Reappropriations 1,223.00 1,500.00 1,500.00 0.00 0.00%
Subtotal $77,796.00 $81,300.00 $82,050.00 $750.00 0.92%
CAPITAL EXPENDITURES
Equipment $8,209.00 $39,000.00 $10,000.00 -$29,000.00 -74.36%
Fire Truck Payment 24,369.00 24,500.00 24,500.00 0.00 0.00%
Subtotal $32,578.00 $63,500.00 $34,500.00 -$29,000.00 -45.67%
TOTAL $1,168,454.00 $1,301,450.00 $1,318,550.00 $17,100.00 1.31%
&A
Page &P

Sheet12

&A
Page &P

Sheet13

&A
Page &P

Sheet14

&A
Page &P

Sheet15

&A
Page &P

Sheet16

&A
Page &P