Budget Preparation
rcardoso14
Assignment2dataset1.xlsExp
| DEVELOPMENT EXPENDITURE HISTORY | |||||||||
| FY2007-08 | FY2008-09 | FY2009-10 | FY2010-11 | FY2011-12 | FY2012-13 | FY2013-14 | FY2013-14 | ||
| ACCOUNT | FUND: GENERL (101-401-4010-X-XX-XXXX) | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ADOPTED | REVISED |
| NUMBER | EXP | EXP | EXP | EXP | EXP | EXP | BUDGET | ESTIMATE | |
| 1−11−1110 | SALARIES OF REGULAR EMPLOYEES | $3,561,200 | $3,774,900 | $3,963,600 | $4,082,500 | $4,184,600 | $4,268,300 | $4,319,500 | $4,332,300 |
| 1−11−1130 | OVERTIME | 143,700 | 152,300 | 159,900 | 164,700 | 168,800 | 172,200 | 174,300 | 174,800 |
| 1−11−1120 | SCHEDULED TEMPORARIES | 95,800 | 101,500 | 106,600 | 109,800 | 112,600 | 114,800 | 116,200 | 116,500 |
| 1−11−1140 | LONGEVITY PAY | 30,700 | 32,500 | 34,100 | 35,100 | 36,000 | 36,700 | 37,200 | 37,300 |
| 1−11−1150 | BILINGUAL PAY | 4,300 | 4,600 | 4,800 | 4,900 | 5,100 | 5,200 | 5,200 | 5,200 |
| 1−12−1230 | GROUP HEALTH INSURANCE | 376,000 | 398,500 | 418,500 | 431,000 | 441,800 | 450,600 | 456,000 | 457,400 |
| 1−12−1240 | CONTRIBUTIONS TO EMPLOYEE RETIREMENT | 431,100 | 456,900 | 479,800 | 494,200 | 506,500 | 516,600 | 522,800 | 524,400 |
| 2−22−2110 | OFFICE SUPPLIES | 24,500 | 26,000 | 27,300 | 28,100 | 28,800 | 29,400 | 29,700 | 29,800 |
| 2−22−2220 | OPERATING SUPPLIES | 25,900 | 27,400 | 28,800 | 29,600 | 30,400 | 31,000 | 31,400 | 31,500 |
| 2−22−2240 | MOTOR VEHICLE FUEL | 16,800 | 17,800 | 18,700 | 19,200 | 19,700 | 20,100 | 20,300 | 20,400 |
| 2−23−2310 | MOTOR VEHICLE REPAIR | 176,300 | 186,800 | 196,200 | 202,100 | 207,100 | 211,200 | 213,800 | 214,400 |
| 2−23−2340 | MINOR EQUIPMENT | 53,200 | 56,400 | 59,200 | 60,900 | 62,500 | 63,700 | 64,500 | 64,700 |
| 3−31−3110 | TRAINING | 17,700 | 18,800 | 19,700 | 20,300 | 20,800 | 21,200 | 21,500 | 21,600 |
| 3−31−3120 | TUITION REIMBURSEMENT | 2,400 | 2,500 | 2,700 | 2,700 | 2,800 | 2,900 | 2,900 | 2,900 |
| 3−31−3150 | ENGINEERING SERVICES | 23,900 | 25,400 | 26,700 | 27,500 | 28,100 | 28,700 | 29,000 | 29,100 |
| 3−31−3160 | LEASE OF EQUIPMENT | 23,900 | 25,400 | 26,700 | 27,500 | 28,100 | 28,700 | 29,000 | 29,100 |
| 3−32−3210 | TRAVEL EXPENSES | 19,200 | 20,300 | 21,300 | 22,000 | 22,500 | 23,000 | 23,200 | 23,300 |
| 3−32−3220 | ADVERTISING AND LEGAL NOTICES | 11,500 | 12,200 | 12,800 | 13,200 | 13,500 | 13,800 | 13,900 | 14,000 |
| 3−33−3310 | TELEPHONE BASIC LINE CHARGES | 76,600 | 81,200 | 85,300 | 87,900 | 90,000 | 91,800 | 92,900 | 93,200 |
| 3−33−3320 | TELEPHONE-LONG DISTANCE | 10,100 | 10,700 | 11,200 | 11,500 | 11,800 | 12,100 | 12,200 | 12,200 |
| 3−33−3330 | CELLULAR/MOBILE PHONES | 3,400 | 3,600 | 3,700 | 3,800 | 3,900 | 4,000 | 4,100 | 4,100 |
| 3−34−3410 | BUILDING REPAIR AND MANTENANCE | 21,100 | 22,300 | 23,500 | 24,200 | 24,800 | 25,300 | 25,600 | 25,600 |
| 3−34−3420 | MACHINERY AND EQUIPMENT MAINTENANCE | 72,800 | 77,200 | 81,000 | 83,500 | 85,500 | 87,300 | 88,300 | 88,600 |
| 3−35−3510 | IT CHARGES | 35,400 | 37,600 | 39,400 | 40,600 | 41,600 | 42,500 | 43,000 | 43,100 |
| 3−35−3520 | COURT FILING FEES | 6,200 | 6,600 | 6,900 | 7,100 | 7,300 | 7,500 | 7,600 | 7,600 |
| 3−35−3560 | PROFESSIONAL LICENSES | 15,300 | 16,200 | 17,100 | 17,600 | 18,000 | 18,400 | 18,600 | 18,600 |
| 3−35−3570 | DUES AND MEMBERSHIPS | 1,000 | 1,000 | 1,100 | 1,100 | 1,100 | 1,100 | 1,200 | 1,200 |
| 3−35−3580 | MESSENGER AND MAIL | 5,300 | 5,600 | 5,900 | 6,000 | 6,200 | 6,300 | 6,400 | 6,400 |
| 3−35−3590 | OTHER CONTRACTUAL | 1,400 | 1,500 | 1,600 | 1,600 | 1,700 | 1,700 | 1,700 | 1,700 |
| 3−37−3710 | BUILDING CONSTRUCTION | 335,300 | 355,400 | 373,100 | 384,300 | 394,000 | 401,800 | 406,700 | 407,900 |
| 3−37−3720 | MOTOR VEHICLE PURCHASES | 191,600 | 203,100 | 213,200 | 219,600 | 225,100 | 229,600 | 232,400 | 233,100 |
| 3−37−3730 | OFFICE EQUIPMENT PURCHASES | 71,800 | 76,200 | 80,000 | 82,400 | 84,400 | 86,100 | 87,100 | 87,400 |
Rev
| DEVELOPMENT REVENUE HISTORY | |||||||||
| FY2007-08 | FY2008-09 | FY2009-10 | FY2010-11 | FY2011-12 | FY2012-13 | FY2013-14 | FY2013-14 | ||
| ACCOUNT | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ADOPTED | REVISED | |
| NUMBER | FUND: GENERL (101-401-4010-X-XX-XXXX) | REV | REV | REV | REV | REV | REV | BUDGET | ESTIMATE |
| 2-40-4120 | TEMP ENCROACHMEMENTS | $137,000 | $145,200 | $152,400 | $157,000 | $160,900 | $163,800 | $165,000 | $165,500 |
| 2-40-4121 | WRECKING/MOVING PMTS | $23,200 | $24,600 | $25,900 | $26,600 | $27,300 | $27,800 | $28,000 | $28,100 |
| 2-40-4122 | HOUSE MOVERS PERMITS | $2,100 | $2,200 | $2,300 | $2,400 | $2,400 | $2,500 | $2,500 | $2,500 |
| 2-40-4123 | CERTIFICATE OF OCCUPANCY | $2,500 | $2,600 | $2,800 | $2,900 | $2,900 | $3,000 | $3,000 | $3,000 |
| 2-40-4124 | GAS WELL DRILLING PERMITS | $24,900 | $26,400 | $27,700 | $28,500 | $29,300 | $29,800 | $30,000 | $30,100 |
| 2-40-4125 | PLUMBING BUS REGISTR | $51,500 | $54,500 | $57,300 | $59,000 | $60,500 | $61,600 | $62,000 | $62,200 |
| 2-40-4126 | MECH LIC & REG | $70,600 | $74,800 | $78,500 | $80,900 | $82,900 | $84,400 | $85,000 | $85,200 |
| 2-40-4127 | SIGN LIC & REG | $9,100 | $9,700 | $10,200 | $10,500 | $10,700 | $10,900 | $11,000 | $11,000 |
| 2-40-4128 | TEMP POWER PERMITS | $8,300 | $8,800 | $9,200 | $9,500 | $9,800 | $9,900 | $10,000 | $10,000 |
| 2-41-4210 | BOARD OF ADJUSTMENT | $83,700 | $88,800 | $93,200 | $96,000 | $98,400 | $100,200 | $100,900 | $101,200 |
| 2-41-4220 | ZONING COMMISSION FEE | $161,900 | $171,600 | $180,100 | $185,500 | $190,200 | $193,600 | $195,000 | $195,500 |
| 2-41-4221 | BED & BREAKFAST FEES | $800 | $900 | $900 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
| 2-41-4222 | DEV PROC MANUAL | $12,500 | $13,200 | $13,900 | $14,300 | $14,600 | $14,900 | $15,000 | $15,000 |
| 2-41-4223 | PLANNING COMMISSION | $340,300 | $360,700 | $378,800 | $390,100 | $399,900 | $407,100 | $410,000 | $411,100 |
| 2-41-4224 | BUILDING PERMITS | $3,486,000 | $3,695,200 | $3,879,900 | $3,996,300 | $4,096,200 | $4,170,000 | $4,200,000 | $4,211,700 |
| 2-41-4225 | ORDINANCE INSPECTION | $199,200 | $211,200 | $221,700 | $228,400 | $234,100 | $238,300 | $240,000 | $240,700 |
| 2-40-4129 | ELECTRICAL PERMITS | $257,300 | $272,700 | $286,400 | $295,000 | $302,300 | $307,800 | $310,000 | $310,900 |
| 2-41-4226 | ANNEXATION FEES | $2,900 | $3,100 | $3,200 | $3,300 | $3,400 | $3,500 | $3,500 | $3,500 |
| 2-40-4130 | BILLBOARD REGISTRATION | $6,200 | $6,600 | $6,900 | $7,100 | $7,300 | $7,400 | $7,500 | $7,500 |
| 2-42-4310 | ENCROACHMENT LETTERS | $1,200 | $1,300 | $1,400 | $1,400 | $1,500 | $1,500 | $1,500 | $1,500 |
| 2-40-4131 | MECHANICAL PERMITS | $91,300 | $96,800 | $101,600 | $104,700 | $107,300 | $109,200 | $110,000 | $110,300 |
| 2-40-4132 | PLUMBING PERMITS | $265,600 | $281,500 | $295,600 | $304,500 | $312,100 | $317,700 | $320,000 | $320,900 |
| 2-40-4133 | THIRD PARTY-PLUMBING | $3,700 | $4,000 | $4,200 | $4,300 | $4,400 | $4,500 | $4,500 | $4,500 |
| 2-40-4134 | THIRD PARTY-BUILDING | $564,400 | $598,300 | $628,200 | $647,000 | $663,200 | $675,100 | $680,000 | $681,900 |
| 2-41-4227 | EXAMINATION FEES | $6,600 | $7,000 | $7,400 | $7,600 | $7,800 | $7,900 | $8,000 | $8,000 |
| 2-40-4135 | SIGN PERMITS | $49,800 | $52,800 | $55,400 | $57,100 | $58,500 | $59,600 | $60,000 | $60,200 |
| 2-40-4136 | RESID REMODEL PERMIT | $14,900 | $15,800 | $16,600 | $17,100 | $17,600 | $17,900 | $18,000 | $18,000 |
| 2-41-4228 | BOARD APPEALS FEE | $4,200 | $4,400 | $4,600 | $4,800 | $4,900 | $5,000 | $5,000 | $5,000 |
| 2-42-4311 | CONST CODE BOOK SALE | $20,800 | $22,000 | $23,100 | $23,800 | $24,400 | $24,800 | $25,000 | $25,100 |
| 2-41-4229 | MOBILE HOME INSPECTION FEE | $2,500 | $2,600 | $2,800 | $2,900 | $2,900 | $3,000 | $3,000 | $3,000 |
| 2-41-4230 | REINSPECTION FEES | $5,000 | $5,300 | $5,500 | $5,700 | $5,900 | $6,000 | $6,000 | $6,000 |
| 2-41-4231 | AFTER HOURS FEE | $3,700 | $4,000 | $4,200 | $4,300 | $4,400 | $4,500 | $4,500 | $4,500 |
| 2-42-4312 | MISCELLANEOUS REVENUE | $10,000 | $10,600 | $11,100 | $11,400 | $11,700 | $11,900 | $12,000 | $12,000 |
| 2-42-4313 | MAP SALE REVENUE | $1,200 | $1,300 | $1,400 | $1,400 | $1,500 | $1,500 | $1,500 | $1,500 |
Sheet1
| FY 2013-14 | FY2013-14 | FY2014-15 | |
| Adopted Budget | Revised Estimate | Proposed Budget | |
| Total Revenues | |||
| Total Expenditures | $0 | 0 | 0 |
| Net | 0 | 0 | 0 |
