|
THE CITY OF SOUTH BEND
<br />REVENUE AND EXPENDITURES -HISTORICAL COMPARISON (cash basis)
<br /> 2001 2002 2003 2003 2004 BUDGET
<br /> ACTUAL ACTUAL ACTUAL ORIGINAL 2004 -VS- 2003 °k
<br />SELF-FUNDED EMPLOYEE BENEFITS RESULTS RESULTS RESULTS BUDGET BUDGET BUDGET CHGE
<br />Revenue:
<br />Ernployer Contributions $ 5,404,166 7,037,676 6,424,714 6,219,536 9,681,840 $ 3,462
<br />304 56°~
<br />ErnployeeContribution/Reimbursement 1,060,697 1,150,275 1,390,407 1,704,810 1,922,347 ,
<br />217
<br />537 13%
<br />Investment Income 72,287 8,999 0 25,000 0 ,
<br />(25
<br />000) -100%
<br />Other Revenue 14,182 13,813 2,003,468 20,000 0 ,
<br />(20,000) -100°k
<br />Total Self-Funded Benefits Revenue 8,551,332 8,210,583 9,818,589 7,989,348 11,804,187 3,834,841 46%
<br />Expendkures:
<br />Administrative Costs 223,157 224,057 255,470 271,995 285,061 13
<br />066 5°k
<br />Service Provider Fees 647,516 773,808 670,187 997,171 792,722 ,
<br />(204,449) -21%
<br />PassThruEmployeeBenefits 372,101 397,112 460,637 489,744 483,700 (6,044) -1°~
<br />Other Employee Benefits 182,815 267,260 268,319 344,000 298,000 (46,000) -13%
<br />Flexible Benefits 472,890 451,025 536,400 525,000 525,000 0 0%
<br />Health Claims 6,063,991 6,642,828 7,713,528 5,338,537 9,200,000 3,861,463 72%
<br />Total Self-Funded Benefits Expenditures 7,962,470 8,756,090 9,904,541 7,966,447 11,584,483 3,618,036 45°k
<br />Revenue Over / (Under) Expenditures (1,411,138) (545,527) (85,952) 2,889 19,704 S 16,805
<br />Cash to Accrual Adjustment 131,907 (242,141) n/a n/a n/a
<br />Equity Balance -Beginning of Year 1,241,419 (37,812) (825,480) (825,480) (911,432)
<br />
<br />Equity Balance -End of Year $ (37,812) (825,480) (911,432) (822,581) (891,728)
<br />Self-Funded Employee BeneFts Revenue SeN-Funded Employee Benefits Expenditures
<br />^ Service
<br />~ OBier Reverwie
<br />~ Adminiatrative Crib
<br />ImresOtier,t Incgvie
<br />~ Employee
<br />Contri bulioNRe imbursert~erM
<br />~ Fltiployer Contributions
<br />Fees
<br />~ Administrative
<br />Cosb
<br />~ Pass l'Mu
<br />^ OMler
<br />Benefits
<br />~ Flexible
<br />~ Fledth
<br />Claims
<br />CENTRAL- SERVICES
<br />Revenue:
<br />Labor Charges
<br />Parts Mark-up
<br />Fuel Mark-up
<br />Print Shop Receipts
<br />Central Stores Allocation
<br />Radio Shop Allocation
<br />Other Revenue
<br />Total Central Services Revenue
<br />Expenditures:
<br />Equipment Services
<br />Central Stores
<br />Print Shop
<br />Radio Shop
<br />Total Central Services Expenditures
<br />Revenue Over ! (Under) Expenditures
<br />Cash to Accrual Adjustment
<br />Equity Balance -Beginning of Year
<br />Equity Balance -End of Year
<br />7!001 ~ 2993 1093
<br />/iC'TIW,
<br />11~11.'C8 ~.
<br />11>L~1N.1"i At~7W~L
<br />~M1nti ORIONiAL
<br />OUDOET
<br />/NT°
<br />$ 1,tt/0~0 iA90,T~p'i 4,70(1,426 1,901.035 2,010.730
<br />al+3,n~ aoe,a44 t_ 350,000 s~9,1o0
<br />34,301 20,7!0? 39.#{10 34,500 34,300
<br />142.000 440,470 144,111 10D,500 4a17l~11
<br />111,!149 113,439 110~l00 115,933 14,144
<br />2117: 243,019 7lOyT07 ~4,4~ 270,118
<br />41 _. 58,140 M
<br />._~ 2,943,8 ,~$~~~
<br />2,407,094 2,447,378
<br />119,658 130,440
<br />168,922 182,985
<br />248,838 270,763
<br />2,944,512 3,031,586
<br />(1,308) 8,795
<br />n/a n/a
<br />1,966,828 "' ""9
<br />$ 2,055,791 1,968,828 2,137,883 1,985,522 2,148,878
<br />2004 BUDGET
<br />-VS- 2003 %
<br />BUDGET CHGE
<br />$ 67,103
<br />(3,900)
<br />(200)
<br />13,524
<br />8,511
<br />24,017
<br />(11,900)
<br />97,155
<br />40,284
<br />10,782
<br />14,083
<br />21,925
<br />87,054
<br />s 10,101
<br />3°~
<br />_1 °/,
<br />-1 %
<br />8°~
<br />7%
<br />9%
<br />-21
<br />3%
<br />2%
<br />9%
<br />8%
<br />9%
<br />3%
<br />B-30
<br />
|