|
Table 13. City of Pleasanton Workers Compensation Fund — Amended Budget vs.
<br />Actual
<br />Table 14. LPFD Workers Compensation Fund — FY 2019/20 Actual vs. FY 2020/21
<br />Actual2
<br />FY 2020121
<br />FY 2020121
<br />Workers' Compensation Fund
<br />Revised
<br />Actual
<br />Variance
<br />Variance %
<br />Beginning Fund Balance
<br />($4,352,437)
<br />($4,352,437)
<br />$0
<br />0.0%
<br />Plus Revenues
<br />1,077,000
<br />1,049,912
<br />(27,088)
<br />-2.5%
<br />Expenses
<br />Claims Paid
<br />(1,200,000)
<br />(962,682)
<br />237,318
<br />-19.8%
<br />Future Liability
<br />(300,000)
<br />651,343
<br />951,343
<br />-317.1%
<br />All other expenses
<br />(369,000)
<br />(335,461)
<br />33,539
<br />-9.1%
<br />Total Expenses
<br />(1,869,000)
<br />(646,800)1
<br />1,222,200
<br />-65.4%
<br />Ending Balance, June 30
<br />1 ($5,144,437)
<br />($3,949,32r))l
<br />$1,195,112
<br />1 -413.9%
<br />Table 14. LPFD Workers Compensation Fund — FY 2019/20 Actual vs. FY 2020/21
<br />Actual2
<br />All Other Operating Funds
<br />For the most part, budget variances are small for the other Operating Funds as shown
<br />in Attachment 2. As a result, staff is not recommending any budget changes.
<br />Submitted by:
<br />Tina Olson
<br />Director of Finance
<br />Approved y:
<br />Nelson Fialho
<br />City Manager
<br />2 The LPFD Workers Compensation Fund became an Agency Fund in Pleasanton's General Ledger in FY
<br />2019/20. Agency Funds do not have budgets associated with them since they are used to account for
<br />funds budgeted elsewhere, which, in this case is LPFD. Thus, Table 13 shows actual Workers
<br />Compensation expenses for FY 2019/20 and FY 2020/21.
<br />Page 13 of 14
<br />FY 2019/20
<br />FY 2020/21
<br />LPFD Workers' Compensation Fund
<br />Actual
<br />Actual
<br />Variance
<br />Variance %
<br />Beginning Fund Balance
<br />($4,847,994)
<br />($4,487,991)
<br />$360,003
<br />-7.4%
<br />Plus Revenues
<br />1,597,631
<br />4,106,427
<br />2,508,796
<br />157.0%
<br />Expenses
<br />Claims Paid
<br />(819,958)
<br />(1,199,297)
<br />(379,339)
<br />46.3%
<br />Future Liability
<br />(168,688)
<br />(104,000)
<br />64,688
<br />-38.3%
<br />All other expenses
<br />(248,981)
<br />(325,263)
<br />(76,282)
<br />30.6%
<br />Total Expenses
<br />(1,237,627)
<br />(1,628,560)
<br />(390,933)
<br />31.6%
<br />Ending Balance, June 30
<br />1 ($4,487,991)
<br />($2,010,124)1
<br />$2,477,867
<br />1 219.7%
<br />All Other Operating Funds
<br />For the most part, budget variances are small for the other Operating Funds as shown
<br />in Attachment 2. As a result, staff is not recommending any budget changes.
<br />Submitted by:
<br />Tina Olson
<br />Director of Finance
<br />Approved y:
<br />Nelson Fialho
<br />City Manager
<br />2 The LPFD Workers Compensation Fund became an Agency Fund in Pleasanton's General Ledger in FY
<br />2019/20. Agency Funds do not have budgets associated with them since they are used to account for
<br />funds budgeted elsewhere, which, in this case is LPFD. Thus, Table 13 shows actual Workers
<br />Compensation expenses for FY 2019/20 and FY 2020/21.
<br />Page 13 of 14
<br />
|