|
General Ledger Code Details
<br />Revenues
<br />GL Account Code
<br />Account Description
<br />Actual
<br />2020 2021
<br />Projected
<br />2022
<br />2022
<br />Budget
<br />2023
<br />2024
<br />FN503200-361110
<br />Investment Interest
<br />$ 8,751
<br />$ 405
<br />$ 439
<br />$ 1,000
<br />$ 500
<br />$ 500
<br />FN503200-361320
<br />Unrlzd Gain(Loss)-Investments
<br />12,880
<br />-
<br />-
<br />-
<br />-
<br />-
<br />FN503200-369700
<br />Trust Contributions -Employer
<br />254,868
<br />270,249
<br />295,755
<br />435,000
<br />350,000
<br />399,000
<br />Total Operating Revenues
<br />Prescription Claims
<br />276,499
<br />270,654
<br />296,194
<br />436,000
<br />350,500
<br />399,500
<br />FN503200-525503
<br />Vision Claims
<br />4,349
<br />4,727
<br />2,553
<br />8,000
<br />6,159
<br />6,394
<br />Total Revenues
<br />Stop Loss Reimbursements
<br />$ 276,499
<br />$ 270,654
<br />$ 296,194
<br />$ 436,000
<br />$ 350,500
<br />$ 399,500
<br />Expenses
<br />GL Account Code
<br />PW103100-511000
<br />PW103100-512000
<br />PW103100C-511000
<br />PW103100C-513000
<br />PW103800C-511000
<br />Account Description
<br />Salaries
<br />Extra Labor
<br />Salaries
<br />Overtime
<br />Salaries
<br />Actual
<br />2020 2021
<br />Projected
<br />2022
<br />2022
<br />Budget
<br />2023
<br />2024
<br />Total Salaries & Wages
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />FN503200-525500
<br />Self Insured Medical Claims
<br />92,323
<br />76,374
<br />42,727
<br />150,000
<br />129,948
<br />135,731
<br />FN503200-525501
<br />Dental Claims
<br />40,400
<br />38,883
<br />10,220
<br />50,000
<br />60,201
<br />64,505
<br />FN503200-525502
<br />Prescription Claims
<br />111,563
<br />109,852
<br />47,599
<br />140,000
<br />102,429
<br />104,478
<br />FN503200-525503
<br />Vision Claims
<br />4,349
<br />4,727
<br />2,553
<br />8,000
<br />6,159
<br />6,394
<br />FN503200-525504
<br />Stop Loss Reimbursements
<br />-
<br />3,403
<br />-
<br />-
<br />-
<br />-
<br />FN503200-525506
<br />TPA Admin Fees
<br />15,914
<br />16,106
<br />5,746
<br />18,000
<br />17,218
<br />17,734
<br />FN503200-525507
<br />Excess Loss Premiums
<br />12,369
<br />14,285
<br />5,062
<br />20,000
<br />17,341
<br />19,942
<br />FN503200-525508
<br />Long Term Care
<br />10,385
<br />11,819
<br />98,229
<br />15,000
<br />15,000
<br />15,000
<br />FN503200-525510
<br />IBNR Adjustment
<br />-
<br />-
<br />-
<br />500
<br />-
<br />-
<br />FN503200-525520
<br />Out of Pocket Costs
<br />31,297
<br />5,939
<br />8,214
<br />30,000
<br />78,000
<br />78,000
<br />FN503200-525521
<br />Medicare Plan B
<br />56,357
<br />49,684
<br />68,136
<br />48,000
<br />-
<br />-
<br />Total Personnel Benefits
<br />374,959
<br />331,071
<br />288,486
<br />479,500
<br />426,296
<br />441,784
<br />FN503200-541000
<br />Professional Services
<br />-
<br />-
<br />1,750
<br />5,000
<br />-
<br />-
<br />FN503200-541007
<br />Contracted Services
<br />-
<br />-
<br />-
<br />-
<br />5,000
<br />5,000
<br />FN503200-549000
<br />Miscellaneous Expenses
<br />-
<br />-
<br />-
<br />500
<br />-
<br />-
<br />FN503200-549999
<br />Other Miscellaneous Expenses
<br />-
<br />-
<br />-
<br />-
<br />500
<br />500
<br />Total Services & Passthrough Pmts
<br />-
<br />-
<br />1,750
<br />5,500
<br />5,500
<br />5,500
<br />FN503200-750190
<br />Transfer Out ICA
<br />-
<br />11,920
<br />12,040
<br />12,040
<br />12,642
<br />13,274
<br />Total Transfers Out
<br />-
<br />11,920
<br />12,040
<br />12,040
<br />12,642
<br />13,274
<br />Total Expenses
<br />$ 374,959
<br />$ 342,991
<br />$ 302,276
<br />$ 497,040
<br />$ 444,438
<br />$ 460,558
<br />21
<br />
|