an argument that the rif is not needed this year these
play

An argument that the RIF is not needed this year These are the - PowerPoint PPT Presentation

An argument that the RIF is not needed this year These are the districts current projections, including lay-offs going into next year Multi-Year Projection Years - 2019-20 Thru 2021-22 Total General Fund 2019-2020 1 st Interim Report


  1. An argument that the RIF is not needed this year

  2. These are the district’s current projections, including lay-offs going into next year Multi-Year Projection Years - 2019-20 Thru 2021-22 Total General Fund 2019-2020 1 st Interim Report Description 2019-20 2020-21 2021-22 Beginning Fund Balance $ 40,256,224 $ 27,704,097 $ 20,512,715 Plus: Revenues/Other Sources $ 290,648,798 $ 292,828,851 $ 297,037,550 Total Available $ 330,905,022 $ 320,532,948 $ 317,550,265 Less: Expenditures/Other Uses $ 303,200,925 $ 300,020,233 $ 306,241,028 Ending Fund Balance $ 27,704,097 $ 20,512,715 $ 11,309,237 Projected Revenue Greater(Less) than Expenditure $ (12,552,127) $ (7,191,382) $ (9,203,478) Restricted "RESERVE" or Legally Restricted Balance $ 2,854,863 $ 2,140,024 $ 1,555,206 ”RESERVE” Required (3% ) $ 9,096,028 $ 9,000,607 $ 9,187,231 Note: Fund Balance Reserves - Inventories/Prepaids $ 1,687,417 $ 1,065,025 $ 180,557 Undesignated/Unappropriated $ 14,065,789 $ 8,307,059 $ 386,243 Reserve Percentage 8.20% 6.12% 3.19% 19

  3. These are the same projections, but only the essential information 2019-20 2020-21 2021-22 Beginning Reserve 40,256,224 27,704,097 20,512,715 Revenue 290,648,798 292,828,851 297,037,550 Expenditures 303,200,925 300,020,233 306,241,028 -Deficit / +Surplus -12,552,127 -7,191,382 -9,203,478 Ending Reserve 27,704,097 20,512,715 11,309,237 Reserve % 8.2 6.12 3.19 (Must be greater than 3)

  4. To start, we will focus on the current year 2019-20 2020-21 2021-22 Beginning Reserve 40,256,224 27,704,097 20,512,715 Revenue 290,648,798 292,828,851 297,037,550 Expenditures 303,200,925 300,020,233 306,241,028 -Deficit / +Surplus -12,552,127 -7,191,382 -9,203,478 Ending Reserve 27,704,097 20,512,715 11,309,237 Reserve % 8.2 6.12 3.19 (Must be greater than 3)

  5. The following are our current expenditures (actuals) as of December 31 st , 2019 (exactly halfway through the budgetary cycle of July 1 st – June 30th) General Fund 1 Budgeted Expended Encumbered Balance (Made up of funds 3, 5, and 6) Fund 3 210,435,614 104,687,486 101,218,355 4,529,773 Fund 5 53,385,173 20,565,092 21,844,168 10,975,913 Fund 6 39,380,137 9,130,050 8,716,348 21,533,739 Total 303,200,924 134,382,628 131,778,871 37,039,425

  6. The following are our current expenditures (actuals) as of December 31 st , 2019 (exactly halfway through the budgetary cycle of July 1 st – June 30th) General Fund 1 Budgeted Expended Encumbered Balance (Made up of funds 3, 5, and 6) Fund 3 210,435,614 104,687,486 101,218,355 4,529,773 Fund 5 53,385,173 20,565,092 21,844,168 10,975,913 Fund 6 39,380,137 9,130,050 8,716,348 21,533,739 Total 303,200,924 134,382,628 131,778,871 37,039,425 At the end of the year: * 7 million will be transferred from Fund 3 to fund 68 * 13 million will be “phantom” expended from Fund 6

  7. The following are our current expenditures (actuals) as of December 31 st , 2019 (exactly halfway through the budgetary cycle of July 1 st – June 30th) General Fund 1 Budgeted Expended Encumbered Balance (Made up of funds 3, 5, and 6) Fund 3 210,435,614 104,687,486 101,218,355 11,529,773 Fund 5 53,385,173 20,565,092 21,844,168 10,975,913 Fund 6 39,380,137 9,130,050 8,716,348 8,533,739 Total 303,200,924 134,382,628 131,778,871 31,039,425 At the end of the year: * 7 million will be transferred from Fund 3 to fund 68 * 13 million will be “phantom” expended from Fund 6 * The 31,039,425 reflects how much we are under projection

  8. The following 5 slides are specific examples of large projected amounts that can be reduced to reflect a more accurate expenditure amount *Encumbered represents an amount of the budget that is held in suspense for a future expenditure.

  9. Possible Over-projected Amounts (Fund 3) Codes Budgeted Expended Encumbered Balance Function 100x, 86,351,413 41,710,457 41,619,746 3,021,209 OBJECT CODE 1110 (Teacher’s salaries) OBJECT CODE 4310 -234,971 171,032 102,830 -508,834 (Classroom/office supplies) OBJECT CODE 4399 322,110 0 0 322,110 (Carry over) OBJECT CODE 5000 1,212,018 127,695 954,977 129,344 (Services and other operating expenditures) Function 210x, 71,188 0 0 71,188 OBJECT CODE 1350 (MGT Coordinator) Function 249x, 1,900,249 886,507 774,904 238,837 OBJECT CODE 1904 (Teacher on special assignment) Function 270x, 4,359,974 1,899,317 1,977,798 482,859 OBJECT CODE 2410 (Clerical personnel)

  10. More Possible Over-projected Amounts Codes Budgeted Expended Encumbered Balance Function 311x, 5,878,866 2,909,549 2,883,671 85,645 OBJECT CODE 1210 (Counselors) Function 360x, 1,855,972 837,241 781,983 236,747 OBJECT CODE 2000 (salaries) Function 390x, 212,100 10,047 0 202,052 OBJECT CODE 2910 (Hourly classified) OBJECT CODE 5000 763,710 298,789 178,365 286,555 (Services and other operating expenditures) Function 420x, 1,201,439 474,330 0 727,108 OBJECT CODE 2910 (Hourly classified) Function 770x, 1,051,469 350,705 80,375 620,388 OBJECT CODE 5000 (Services and other operating expenditures)

  11. More Possible Over-projected Amounts Codes Budgeted Expended Encumbered Balance Function 810x, 5,159,996 2,501,137 2,338,832 320,026 OBJECT CODE 2000 (salaries) OBJECT CODE 5000 7,346,394 2,451,085 4,457,818 437,490 (Services and other operating expenditures) Fund 5 Function 111x, 5,116,423 2,370,471 2,342,020 453,932 OBJECT CODE 1110 (Teacher Salaries) OBJECT CODE 1152 125,983 11,956 0 114,027 (Substitutes, Non Illness) OBJECT CODE 2113 906,728 42,001 0 864,727 (Paraeducator subs) Function 118x, 4,280,028 1,577,992 3,540,212 -838,175 OBJECT CODE 5000 (Services and other operating expenditures)

  12. More Possible Over-projected Amounts Codes Budgeted Expended Encumbered Balance Function 119x, 355,549 10,428 83,327 261,749 OBJECT CODE 5100 (Sub agreements) Function 249x, 219,571 7,004 0 212,566 OBJECT CODE 1901 (Extra time) Function 311x, 770,000 63,141 462,788 244,070 OBJECT CODE 5100 (Sub agreements) Function 312x, 641,000 108,690 194,309 338,000 OBJECT CODE 5100 (Sub agreements) Function 314x, 512,600 69,027 110,972 332,600 OBJECT CODE 5000 (Services and other operating expenditures) Function 315x, 629,280 9,460 103,810 530,493 OBJECT CODE 5000 (Services and other operating expenditures)

  13. More Possible Over-projected Amounts Codes Budgeted Expended Encumbered Balance FUND 6 Function 100x, 1,734,220 719,652 434,275 580,293 OBJECT CODE 1110 (Teacher salaries) OBJECT CODE 4000 2,366,606 425,278 316,324 1,625,003 (this one is messy) (books, materials, supplies, capital outlay, equipment) OBJECT CODE 5000 888,717 437,930 212,738 238,048 (services and other operating expenditures) Function 390x 470,896 7,089 1,734 462,072 OBJECT CODE 4310 (Classroom/office supplies) OBJECT CODE 4399 535,250 0 0 535,250 (Carry over) OBJECT CODE 5000 547,880 128,880 47,260 371,700 (services and other operating expenditures)

  14. Total from left-over balances from the specified examples: 12,999,079 Broken down by OBJECT CODE • 1000 & 2000 (salaries): 7,611,216 • 3000 (benefits): 0 • 4000 (books, materials, supplies, capital outlay, equipment): 2,435,601 • 5000 (services and other operating expenditures): 2,952,262

  15. Again, these are the district’s projections (as of the First Interim - December) including a RIF 2019-20 2020-21 2021-22 Beginning Reserve 40,256,224 27,704,097 20,512,715 Revenue 290,648,798 292,828,851 297,037,550 Expenditures 303,200,925 300,020,233 306,241,028 -Deficit / +Surplus -12,552,127 -7,191,382 -9,203,478 Ending Reserve 27,704,097 20,512,715 11,309,237 Reserve % 8.2 6.12 3.19 (Must be greater than 3)

  16. These are the revised projections for this year if you incorporate the specific examples that could be adjusted to reflect a more accurate projected expenditure amount. As you can see, the deficit goes away. 2019-20 2020-21 2021-22 Beginning Reserve 40,256,224 27,704,097 20,512,715 Revenue 290,648,798 292,828,851 297,037,550 Expenditures 290,201,846 300,020,233 306,241,028 -Deficit / +Surplus +446,952 -7,191,382 -9,203,478 Ending Reserve 40,703,176 20,512,715 11,309,237 Reserve % ~14% 6.12 3.19 (Must be greater than 3)

  17. Now, no one thinks the entire 12,999,079 will be over-projected. But, remember, the 12,999,079 only reflects a portion of the remaining balance. General Fund 1 Budgeted Expended Encumbered Balance (Made up of funds 3, 5, and 6) Fund 3 210,435,614 104,687,486 101,218,355 11,529,773 Fund 5 53,385,173 20,565,092 21,844,168 10,975,913 Fund 6 39,380,137 9,130,050 8,716,348 8,533,739 Total 303,200,924 134,382,628 131,778,871 31,039,425 12,999,079 only reflects the largest amounts of the remaining balance of 31,039,425

  18. But let’s assume that the district’s numbers are accurate for this school year (2019-2020)

  19. Here we are, again starting with the district’s projections as of December, including a RIF 2019-20 2020-21 2021-22 Beginning Reserve 40,256,224 27,704,097 20,512,715 Revenue 290,648,798 292,828,851 297,037,550 Expenditures 303,200,925 300,020,233 306,241,028 -Deficit / +Surplus -12,552,127 -7,191,382 -9,203,478 Ending Reserve 27,704,097 20,512,715 11,309,237 Reserve % 8.2 6.12 3.19 (Must be greater than 3)

Download Presentation
Download Policy: The content available on the website is offered to you 'AS IS' for your personal information and use only. It cannot be commercialized, licensed, or distributed on other websites without prior consent from the author. To download a presentation, simply click this link. If you encounter any difficulties during the download process, it's possible that the publisher has removed the file from their server.

Recommend


More recommend