Loading...
HomeMy WebLinkAbout5A Staff CorrespondenceCity of Palm Springs FISCAL VEAR 2020-2021 THIRD QUARTER UPDATE/ END OF VEAR ESTIMATE APRIL 22, 2021 City of Palm Springs General Fund Budget Review Third Quarter Summary • 3rd Quarter Increased General Fund Revenue -• --• ---p .. 2 City of Palm Springs General Fund Budget Review Transient Occupancy Tax (TOT): Third Quarter Review --·----------------~ -r ---------l . ,... __ ---.....,------, I ~--------- January February TOT FY20-21 Budgeted Revenue $ 1,289,142 $ 1,345,817 TOT FY20-21 Actual Revenue $ 1,456,529 $ 975,749 Difference 167,387 $ I March I j l $ 847,102 $ 2,546,807 $ ----- Total $ 3,482,061 $ 4,979,085 • TOT budget revenue was @ below FY19-20 3rd Quarter revenue • TOT actual revenue i -40° below FY19-20 1st Quarter revenue • +$1.S million additional TOT revenue above budget . --. -.. .---_.. ------. --. . -. - . 3 -. , ... l City of Palm Springs General Fund Budget Review Transient Occu~anci Tax (TOT): Third Quarter Review TOT Taxes (1)Cash Basis (1 )Cash Basis Adopted (1 )Cash Basis FY18-19 FY19-20 FY20-21 FY20-21 Increase/ Actual Actual Budget Actual I . July 2,395,808 $ 2,425,609 $ 440,593 $ 1,205,044 $ • :.I :.I Aug 1,276,428 $ 2,145,936 $ 406,421 $ 1,471,448 $ I• I Sept 2,336,564 $ 2,006,896 $ 501,724 $ 2,973,988 $ • :.I Oct 2,169,363 $ 2,238,030 $ 727,360 $ 2,352,156 $ • :.I •• Nov 2,446,059 $ 2,488,308 $ 933,116 $ 2,958,820 $ I I :.i Dec 3,135,116 $ 3,108,906 $ 1,476,730 $ 2,879,472 $ :.i I Jan 2,830,585 $ 2,864,760 $ 1,289,142 $ 1,456,529 Feb 2,861,639 $ 2,990,705 $ 1,345,817 $ 975,749 $ (370,068 3,319,417 $ 2,414,906 $ 847,102 $ 2,546,807 $ 5,389,109 $ 2,366,740 $ 2,020,916 5,014,551 $ 888,331 $ 2,436,511 3,309,018 $ 489,882 $ 34 $ $ 18,820,012 $ 10,852,007 City of Palm Springs General Fund Budget Review Transient Occupancy Tax (TOT): Third Quarter Review • TOT 9-month actual revenue is @ of total FY 20-21 budgeted revenue • TOT 9-month revenue i 83% of FY 18-19 & FY 19-20 revenue same period • 4 th Quarter TOT Projections over budgeted TOT revenue ----. ,-----· -------. ---. . -. ---... -- 5 4. ~ • City of Palm Springs General Fund Budget Review July Aug Sept Oct Nov Dec Jan Feb $ $ $ $ $ $ $ $ $ $ $ $ $ (1 )Cash Basis FY18-19 Actual 2,395,808 1,276,428 2,336,564 2,169,363 2,446,059 3,135,116 2,830,585 2,861,639 3,319,417 5,389,109 5,014,551 3,309,018 36,483,657 $ $ $ $ $ $ $ $ $ $ $ $ $ TOT Taxes (1)Cash Basis Adopted (1 )Cash Basis FY19-20 FY20-21 FY20-21 Increase/ Actual Budget Actual 2,425,609 $ 440,593 $ 1,205,044 $ 2,145,936 $ 406,421 $ 1,471,448 $ 2,006,896 $ 501,724 $ 2,973,988 $ 2,238,030 $ 727,360 $ 2,352,156 $ 2,488,308 $ 933,116 $ 2,958,820 $ 3,108,906 $ 1,476,730 $ 2,879,472 $ 2,864,760 $ 1,289,142 $ 1,456,529 $ 2,990,705 $ 1,345,817 $ 975,749 $ 2,414,906 $ 847,102 $ 2,546,807 $ 2,366,740 $ 2,020,916 $ 4,311,287 888,331 $ 2,436,511 $ 4,011,641 489,882 $ 1,737,234 $ 2,647,214 26,429,008 29,790,15 s only. ----= -,.,_ -•------~ ~----; r ---~ -~ --...---.......--•--------_,., -• 6 . . . . -.-. ,. . .,. '. City of Palm Springs General Fund Budget Review Sales Tax (Excluding Measure J): Third Quarter Review r ----~ ---------~ l January T February 7 ------- March I Total ! I I Sales Tax FY20-21 Budgeted Revenue I r--- 1 Sales Tax FY20-21 Actual Revenue I I Difference $ 1,082,886 $ 946,265 $ 755,274 $ 2,784,425 $ 1,830,685 $ 2,327,721 $ 2,128,048 $ 6,286,454 •------------ $ 747,799 $ 1,381,456 $ 1,372,774 • Sales Tax budget revenue was -57% elow FY19-20 3 rd Quarter revenue • Sales Tax actual revenue i -4% elow FY19-20 3 rd Quarter revenue • +$3.5 million additional Sales Tax revenue above budget ----~ -----~ --------. --- 7 City of Palm Springs General Fund Budget Review Sales Tax (Excluding Measure J): Third Quarter Review Sales Taxes (1)Cash Basis (1)Cash Basis Adopted FY18-19 FY19-20 FY20-21 Actual Actual Budget $ 1,569,192 $ 2,052,175 $ 315,566 $ 1,540,406 $ 1,803,236 $ 347,069 $ 1,721,728 $ 1,735,577 $ 394,535 $ 1,608,493 $ 1,578,141 $ 554,978 $ 2,377,484 $ 1,707,623 $ 730,385 Dec $ 1,930,063 $ 1,947,694 $ 840,923 Jan $ 1,772,943 $ 1,770,364 $ 1,082,886 Feb $ 2,179,244 $ 2,648,464 $ 946,265 $ 2,196,128 $ 2,102,810 $ 755,274 $ 2,013,662 $ 1,849,644 $ 917,902 $ 2,447,740 $ 780,032 $ 909,290 $ 1,819,330 $ 1,762,940 $ 86 $ 23,176,411 $ 21,738,699 S 8,847,359 (1)Cash Basis FY20-21 Increase/ Actual Decrease $ 2,148,660 $ 1,833,094 $ 991,568 $ 644,499 $ 1,769,583 $ 1,375,048 $ 1,824,908 $ 1,269,930 $ 1,542,882 $ 812,497 $ 2,062,035 $ 1,221,112 $ 1,830,685 $ 747,799 $ 2,327,721 $ 1,381,456 $ 2,128,048 $ 1,372,774 ~-~ ~~ 10,658,209 City of Palm Springs General Fund Budget Review Sales Tax (Excluding Measure J): Third Quarter Review 9-month revenue • 4 th Quarter Sales Tax Projections 90% f FY 18-19 Sales Tax revenue = +$2.8m ver budgeted Sales Tax revenue -------• -.,.._ -.-.----• •-----•• .-,., -~-...:-T l -==--~-~-.-r,--r, ----It--..... ,-------.. • ...... .._. • • ---• ·, . 9 • • •• 1 • "'I • _. • "--. --:'...•. • l • _ • •• 1, City of Palm Springs General Fund Budget Review Sales Tax (Excluding Measure J): End of FY Projection - Sales Taxes (1)Cash Basis (1 )Cash Basis Adopted (1 )Cash Basis FY18-19 FY19-20 FY20-21 FY20-21 Increase/ Actual Actual Budget Actual July $ 1,569,192 $ 2,052,175 $ 315,566 $ 2,148,660 $ Aug $ 1,540,406 $ 1,803,236 $ 347,069 $ 991,568 $ Sept $ 1,721,728 $ 1,735,577 $ 394,535 $ 1,769,583 $ Oct $ 1,608,493 $ 1,578,141 $ 554,978 $ 1,824,908 $ Nov $ 2,377,484 $ 1,707,623 $ 730,385 $ 1,542,882 $ Dec $ 1,930,063 $ 1,947,694 $ 840,923 $ 2,062,035 $ Jan $ 1,772,943 $ 1,770,364 $ 1,082,886 $ 1,830,685 $ Feb $ 2,179,244 $ 2,648,464 $ 946,265 $ 2,327,721 $ Mar $ 2,196,128 $ 2,102,810 $ 755,274 $ 2,128,048 $ Apr $ 2,013,662 $ 1,849,644 $ 917,902 $ 1,812,295 May $ 2,447,740 $ 780,032 $ 909,290 $ 2,202,966 Jun $ 1,819,330 $ 1,762,940 $ 1 052,286 $ 1637 397 $ 23,176,411 $ 21,738,699 22,278,748 -·--.. ·-----,, ----. - 10 ' ' I • • .._4... --• ~ ._ _..,. • .., •_ --• ~ -• -- City of Palm Springs General Fund Budget Review Total General Fund Expenditure Summary Category General Government Police Fire Parks and Recreation PERS Reserve Transfers Out !Total Expenditures "--- 1. Adopted FY 20-21 1 9-Month FY 20-21 1 1 % 20 °_f 2 F 1 Y 9-Month FY 19-20 I I Budget I Expenditures I Budget Expenditures I Difference ---+-· I -----~ ~ . -- $37,678,599 $22,800,459 I 60.5% $28,160,616 ($5,360,157) ----i- $33,302,452_J__ $23,894,064 --!-71.7% $25,973,048 ($2,078,984) $17,364,889 $13,765,772 _ I 79.3%, $14,068,304 ($302,532) $7,197,380 $4,520,916 _ 1 62.8% $5,789,528 ($1,268,612) $6,000,000-i-$6,000,000 100.0%, $6,000,000 $0 $12,000,300 I $9 93 -1 78.4% $13,520,425 ($4,113,532) ...L..:: • --s -------~ .. ----,--• -· ... _ .... -· _,. -• --~. --.-• • •• • . . 11 • • I •• • .,_ • • f - 7 City of Palm Springs General Fund Budget Review American Rescue Plan Act • Palm Springs is expected to receive $11,190,000 in 2 payments of $5,595,000 each, May 2021 and May 2022 • Stimulus to replace lost revenue due to COVID-19 pandemic (FY 19-20 compared to FY 18-19) FY 18-19: FY 19-20: Loss of Revenue: $ 140,127,840 $ 112,439,828 ($ 27,688,012) --------------- 12 City of Palm Springs General Fund Budget Review Total General Fund Revenue Increase through End of FY Fees and Charges: +$911,489 Property Taxes: TOT: Sales Taxes: + 6 275 209 Projected Increase: (i$14,637,8 ® ARP Stimulus Ma 2021: + 5 595 000 Total Increase: (±$20,232,88]) -----• • ----'I' ----·-----• ,,. --• 13 -' -... _. . ~ . . City of Palm Springs General Fund Budget Review Measure J Sales Tax: Third Quarter Review ·----------------T-------------------------.,. -----------r ----- January February ! March Total i ---- MeasureJFY20-21BudgetedRevenue $ 626,222 $ 613,241 $ 526,411 $1,765,874 ------------•--------"--- Measure J FY20-21 Actual Revenue $ 1,332,028 $ 1,629,918 $ 1,482,955 $ 4,444,901 -------- Difference $ 705,806 $ 1,016,677 $ L -------------- • Measure J budget revenue was S below FY19-20 3 rd Quarter revenue • Measure J actual revenue is equal to FY19-20 3 rd Quarter revenue • +$2.7 million additional Measure J revenue above budget City of Palm Springs General Fund Budget Review Measure J Sales Tax: Third Quarter Review Measure J Sales Taxes (1 )Cash Basis (1 )Cash Basis Revised (1 )Cash Basis FY18-19 FY19-20 FY20-21 FY20-21 Increase/ Actual Actual Budget Actual Decrease i $ 1,190,015 $ 1,489,086 $ 195,554 $ 1,540,834 $ 1,345,280 $ 1,157,051 $ 1,146,909 $ 216,610 $ 853,771 $ 637,161 pt $ 921,434 $ 1,199,738 $ 282,663 $ 1,260,444 $ 977,781 ~ $ 1,225,007 $ 1,155,050 $ 426,741 $ 1,359,801 $ 933,060 $ 1,372,704 $ 1,188,251 $ 468,348 $ 1,084,702 $ 616,354 - C $ 1,394,758 $ 1,357,357 $ 819,994 $ 1,412,971 $ 592,977 [.Jan $ 1,291,276 $ 1,287,324 $ 626,222 $ 1,332,028 $ 705,806 : Feb $ 1,366,766 $ 1,756,619 $ 613,241 $ 1,629,918 $ 1,016,677 I ~Mar $ 1,540,628 $ 1,423,604 $ 526,411 $ 1,482,955 $ 956,544 ~ $ 1,449,640 $ 1,228,280 $ 473,233 $ 1,545,175 $ 588,549 $ 730,143 n $ 1,300,354 $ 1,250,141 $ 7 740 $ 15, 7 54,80!_ $ 15,070,907 5,966,900 • --• • • ~-• ~ r • .,.. 1 ~ • ...-• • • • 0 ,. • -~ -•• ,,__ • • • n • ~ • --. • 15 . . ' . ' City of Palm Springs General Fund Budget Review Measure J Sales Tax: Third Quarter Review • Measure J actual revenue i 200% f total FY 20-21 budgeted revenue • Measure J 9-month revenue is @ of FY 18-19 and @ of FY 19-20 9-month revenue • 4th Quarter Measure J Projections =@ of FY 18-19 Measure J revenue =~over budgeted Measure J revenue -----~ -~ -------~=_-------------·-~:------=------,e--~ -,-.. -.---.. -~----- . · . · .. '· . . , · . · 16 • -• , _....., c.,..i ... --'·· L •• -I ... • ~ .... ::.,.~ .-.. •• • l.r.: ' ·~· . .· -t City of Palm Springs General Fund Budget Review Measure J Sales Tax: End of FY Projection Measure J Sales Taxes (1)Cash Basis (1 )Cash Basis Revised (1 )Cash Basis FY18-19 FY19-20 FY20-21 FY20-21 Increase/ Actual Actual Budget $ 1,190,015 $ 1,489,086 $ 195,554 $ $ $ 1,157,051 $ 1,146,909 $ 216,610 $ $ $ 921,434 $ 1,199,738 $ 282,663 $ $ $ 1,225,007 $ 1,155,050 $ 426,741 $ $ Nov $ 1,372,704 $ 1,188,251 $ 468,348 $ $ Dec $ 1,394,758 $ 1,357,357 $ 819,994 $ $ Jan $ 1,291,276 $ 1,287,324 $ 626,222 $ $ Feb $ 1,366,766 $ 1,756,619 $ 613,241 $ $ Mar $ 1,540,628 $ 1,423,604 $ 526,411 $ $ Apr $ 1,449,640 $ 1,228,280 $ 473,233 $ May $ 1,545,175 $ 588,549 $ 730,143 $ Jun $ 1,300,354 $ 1,250,141 $ 40 $ $ 15,754,808 $ 15,070,907 ----------. . . --. -. I 17 . . ... ---. . . '. _.: }· _:_~__:_:__.• .1•----.!_._~.-~.-'.;~•-·,,.!_., 41---__ .,.. • _ ... ..__ .• - City of Palm Springs General Fund Budget Review Recommendations • Amend FY 20-21 Budget to increase General Fund revenues by +$20,232,881 • Cancel $2,800,000 transfer from Measure J • Amend FY 20-21 Budget to increase Measure J revenues by +$4,968,321 • Appropriate $7,800,000 for additional expenditures (+$200,000 for CV Housing First Program?) • Amend FY 20-21 Allocated Positions & Compensation Plan to fund 18 vacant positions due to reduction in force implemented FY19-20 City of Palm Springs General Fund Budget Review e -.. ----• --•--..... ~ ·•,; --···~ ---, ll--~· ,._. -~ ---I , __ --•-.. ·-,,. Salary+ · ! I Department .-Position Reason ,FT:E l!Jnit Range Benefits ·,, Development Services Planning Technician Layoff 1 GU 41 $ 133,153 Fire Clerical Assistant Layoff 1 GU 23 $ 85,396 Library Library & Public Services Manager Layoff 1 MX 49 $ 149,745 Administrative Secretary Layoff 1 MX 39 $ 117,017 Fleet Maintenance Technician II Layoff 1 GU 39 $ 126,805 Fleet Maintenance Technician IIVService Writ, Layoff 1 GU 45 $ 147,041 Maintenance & Facilities Maintenance Electrician Layoff 1 GU 45 $ 147,041 Maintenance Mechanic I Layoff 1 GU 35 $ 114,898 Maintenance Supervisor Layoff 1 MX 51 $ 157,294 Maintenance Supervisor Layoff 1 MX 51 $ 157,294 Street/Traffic Maintenance Worker, Lead Layoff 1 GU 38 $ 123,652 Community Outreach & Media Specialist Layoff 1 GU 41 $ 133,153 Police Crime Scene Technician Layoff 1 GU 44 $ 143,398 Rangemaster Layoff 1 GU 41 $ 133,153 LifeQuard Layoff 0.75 GU 20 $ 59,478 Recreation Lifeguard Layoff 1 GU 20 $ 79,304 Secretary, Senior Layoff 1 GU 33 $ 109,338 Special Programs Account Clerk II Layoff 1 GU 31 $ 104,098 ... -~' -TOTAL FJE RIFcJ?.(:)Slll~NS liPt.BEJil:JN_DEl!l 1 _ _'l.75 ·--' $2,221,258 City of Palm Springs FISCAL YEAR 2020-2021 THIRD QUARTER UPDATE / END OF YEAR ESTIMATE APRIL 22, 2021 2 Third Quarter Summary City of Palm Springs General Fund Budget Review •TOT 3 rd Quarter Revenue = +$1.5 million •Sales Tax 3rd Quarter Revenue = +3.5 million •3rd Quarter Increased General Fund Revenue = +$5 million •3rd Quarter Revenue vs. FY 19/20 = -$3.5 million •Measure J 3rd Quarter Revenue = +2.7 million C 2) ------------ 3 Transient Occupancy Tax (TOT): Third Quarter Review City of Palm Springs General Fund Budget Review •TOT budget revenue was -60% below FY19-20 3rd Quarter revenue •TOT actual revenue is -40% below FY19-20 1st Quarter revenue •+$1.5 million additional TOT revenue above budget January February March Total TOT FY20-21 Budgeted Revenue 1,289,142$ 1,345,817$ 847,102$ 3,482,061$ TOT FY20-21 Actual Revenue 1,456,529$ 975,749$ 2,546,807$ 4,979,085$ Difference 167,387$ (370,068)$ 1,699,705$ 1,497,024$ ~ ~ ----........_ '----~ t __/ 4 Transient Occupancy Tax (TOT): Third Quarter Review City of Palm Springs General Fund Budget Review (1)Cash Basis (1)Cash Basis Adopted (1)Cash Basis FY18-19 FY19-20 FY20-21 FY20-21 Increase/ Actual Actual Budget Actual Decrease July 2,395,808$ 2,425,609$ 440,593$ 1,205,044$ 764,451$ Aug 1,276,428$ 2,145,936$ 406,421$ 1,471,448$ 1,065,027$ Sept 2,336,564$ 2,006,896$ 501,724$ 2,973,988$ 2,472,264$ Oct 2,169,363$ 2,238,030$ 727,360$ 2,352,156$ 1,624,796$ Nov 2,446,059$ 2,488,308$ 933,116$ 2,958,820$ 2,025,704$ Dec 3,135,116$ 3,108,906$ 1,476,730$ 2,879,472$ 1,402,742$ Jan 2,830,585$ 2,864,760$ 1,289,142$ 1,456,529$ 167,387$ Feb 2,861,639$ 2,990,705$ 1,345,817$ 975,749$ (370,068)$ Mar 3,319,417$ 2,414,906$ 847,102$ 2,546,807$ 1,699,705$ Apr 5,389,109$ 2,366,740$ 2,020,916$ May 5,014,551$ 888,331$ 2,436,511$ Jun 3,309,018$ 489,882$ 1,737,234$ 36,483,657$ 26,429,008$ 14,162,666$ 18,820,012$ 10,852,007$ TOT Taxes v--~ > ~ ___,,,,,,_ -~ -~ -~ "" ~ "' ,,,. ~ ~'"-----~'-- 5 Transient Occupancy Tax (TOT): Third Quarter Review City of Palm Springs General Fund Budget Review •TOT 9-month actual revenue is 133%of total FY 20-21 budgeted revenue •TOT 9-month revenue is 83%of FY 18-19 &FY 19-20 revenue same period •4th Quarter TOT Projections =80%of FY 18-19 TOT revenue = +$4.8m over budgeted TOT revenue C) 0 C) 6 Transient Occupancy Tax (TOT): End of FY Projection City of Palm Springs General Fund Budget Review (1)Cash Basis (1)Cash Basis Adopted (1)Cash Basis FY18-19 FY19-20 FY20-21 FY20-21 Increase/ Actual Actual Budget Actual Decrease July 2,395,808$ 2,425,609$ 440,593$ 1,205,044$ 764,451$ Aug 1,276,428$ 2,145,936$ 406,421$ 1,471,448$ 1,065,027$ Sept 2,336,564$ 2,006,896$ 501,724$ 2,973,988$ 2,472,264$ Oct 2,169,363$ 2,238,030$ 727,360$ 2,352,156$ 1,624,796$ Nov 2,446,059$ 2,488,308$ 933,116$ 2,958,820$ 2,025,704$ Dec 3,135,116$ 3,108,906$ 1,476,730$ 2,879,472$ 1,402,742$ Jan 2,830,585$ 2,864,760$ 1,289,142$ 1,456,529$ 167,387$ Feb 2,861,639$ 2,990,705$ 1,345,817$ 975,749$ (370,068)$ Mar 3,319,417$ 2,414,906$ 847,102$ 2,546,807$ 1,699,705$ Apr 5,389,109$ 2,366,740$ 2,020,916$ 4,311,287$ 2,290,371$ May 5,014,551$ 888,331$ 2,436,511$ 4,011,641$ 1,575,130$ Jun 3,309,018$ 489,882$ 1,737,234$ 2,647,214$ 909,980$ 36,483,657$ 26,429,008$ 14,162,666$ 29,790,154$ 15,627,488$ Estimates only. TOT Taxes 7 Sales Tax (Excluding Measure J): Third Quarter Review City of Palm Springs General Fund Budget Review •Sales Tax budget revenue was -57% below FY19-20 3rd Quarter revenue •Sales Tax actual revenue is -4% below FY19-20 3rd Quarter revenue •+$3.5 million additional Sales Tax revenue above budget January February March Total Sales Tax FY20-21 Budgeted Revenue 1,082,886$ 946,265$ 755,274$ 2,784,425$ Sales Tax FY20-21 Actual Revenue 1,830,685$ 2,327,721$ 2,128,048$ 6,286,454$ Difference 747,799$ 1,381,456$ 1,372,774$ 3,502,029$ C ~ _,;' 8 Sales Tax (Excluding Measure J): Third Quarter Review City of Palm Springs General Fund Budget Review (1)Cash Basis (1)Cash Basis Adopted (1)Cash Basis FY18-19 FY19-20 FY20-21 FY20-21 Increase/ Actual Actual Budget Actual Decrease July 1,569,192$ 2,052,175$ 315,566$ 2,148,660$ 1,833,094$ Aug 1,540,406$ 1,803,236$ 347,069$ 991,568$ 644,499$ Sept 1,721,728$ 1,735,577$ 394,535$ 1,769,583$ 1,375,048$ Oct 1,608,493$ 1,578,141$ 554,978$ 1,824,908$ 1,269,930$ Nov 2,377,484$ 1,707,623$ 730,385$ 1,542,882$ 812,497$ Dec 1,930,063$ 1,947,694$ 840,923$ 2,062,035$ 1,221,112$ Jan 1,772,943$ 1,770,364$ 1,082,886$ 1,830,685$ 747,799$ Feb 2,179,244$ 2,648,464$ 946,265$ 2,327,721$ 1,381,456$ Mar 2,196,128$ 2,102,810$ 755,274$ 2,128,048$ 1,372,774$ Apr 2,013,662$ 1,849,644$ 917,902$ May 2,447,740$ 780,032$ 909,290$ Jun 1,819,330$ 1,762,940$ 1,052,286$ 23,176,411$ 21,738,699$ 8,847,359$ 16,626,090$ 10,658,209$ Sales Taxes - C "' r " r __,) ___./'----___/-'---._ 9 Sales Tax (Excluding Measure J): Third Quarter Review City of Palm Springs General Fund Budget Review •Sales Ta x actual revenue is 188%of total FY 20-21 budgeted revenue •Sales Tax FY 9-month revenue is 98%of FY 18-19 and 96%of FY 19-20 9-month revenue •4th Quarter Sales Tax Projections =90%of FY 18-19 Sales Tax revenue = +$2.8m over budgeted Sales Tax revenue C) 0 0 0 10 Sales Tax (Excluding Measure J): End of FY Projection City of Palm Springs General Fund Budget Review (1)Cash Basis (1)Cash Basis Adopted (1)Cash Basis FY18-19 FY19-20 FY20-21 FY20-21 Increase/ Actual Actual Budget Actual Decrease July 1,569,192$ 2,052,175$ 315,566$ 2,148,660$ 1,833,094$ Aug 1,540,406$ 1,803,236$ 347,069$ 991,568$ 644,499$ Sept 1,721,728$ 1,735,577$ 394,535$ 1,769,583$ 1,375,048$ Oct 1,608,493$ 1,578,141$ 554,978$ 1,824,908$ 1,269,930$ Nov 2,377,484$ 1,707,623$ 730,385$ 1,542,882$ 812,497$ Dec 1,930,063$ 1,947,694$ 840,923$ 2,062,035$ 1,221,112$ Jan 1,772,943$ 1,770,364$ 1,082,886$ 1,830,685$ 747,799$ Feb 2,179,244$ 2,648,464$ 946,265$ 2,327,721$ 1,381,456$ Mar 2,196,128$ 2,102,810$ 755,274$ 2,128,048$ 1,372,774$ Apr 2,013,662$ 1,849,644$ 917,902$ 1,812,295$ 894,393$ May 2,447,740$ 780,032$ 909,290$ 2,202,966$ 1,293,676$ Jun 1,819,330$ 1,762,940$ 1,052,286$ 1,637,397$ 585,111$ 23,176,411$ 21,738,699$ 8,847,359$ 22,278,748$ 13,431,389$ Estimates only. Sales Taxes ·- "--~ .-----1 ~ ------...., ~ -----..... ,-,-=r I~ ~~ ~ '---I I 11 Total General Fund Expenditure Summary City of Palm Springs General Fund Budget Review General Government $37,678,599 $22,800,459 60.5% $28,160,616 ($5,360,157) Police $33,302,452 $23,894,064 71.7% $25,973,048 ($2,078,984) Fire $17,364,889 $13,765,772 79.3% $14,068,304 ($302,532) Parks and Recreation $7,197,380 $4,520,916 62.8% $5,789,528 ($1,268,612) PERS Reserve $6,000,000 $6,000,000 100.0% $6,000,000 $0 Transfers Out $12,000,300 $9,406,893 78.4% $13,520,425 ($4,113,532) Total Expenditures 113,543,620$ $80,388,104 70.8% $93,511,921 ($13,123,817) Difference % of FY 20-21 Budget Category Adopted FY 20-21 Budget 9-Month FY 20-21 Expenditures 9-Month FY 19-20 Expenditures I C --__ X _______ -::::;;..~ .......... l __ _____. 12 American Rescue Plan Act City of Palm Springs General Fund Budget Review •Palm Springs is expected to receive $11,190,000 in 2 payments of $5,595,000 each,May 2021 and May 2022 •Stimulus to replace lost revenue due to COVID-19 pandemic (FY 19-20 compared to FY 18-19) FY 18-19:$140,127,840 FY 19-20:$112,439,828 Loss of Revenue:($27,688,012) 13 Total General Fund Revenue Increase through End of FY City of Palm Springs General Fund Budget Review Fees and Charges: +$911,489 Property Taxes : +$1,661,990 TOT:+$5,789,193 Sales Taxes :+$6,275,209 Projected Increase: +$14,637,881 ARP Stimulus May 2021: +$5,595,000 Total Increase: +$20,232,881 C :> C ::> C :> C ::> 14 Measure J Sales Tax: Third Quarter Review City of Palm Springs General Fund Budget Review •Measure J budget revenue was -60% below FY19-20 3rd Quarter revenue •Measure J actual revenue is equal to FY19-20 3rd Quarter revenue •+$2.7 million additional Measure J revenue above budget January February March Total Measure J FY20-21 Budgeted Revenue 626,222$ 613,241$ 526,411$ 1,765,874$ Measure J FY20-21 Actual Revenue 1,332,028$ 1,629,918$ 1,482,955$ 4,444,901$ Difference 705,806$ 1,016,677$ 956,544$ 2,679,027$ ~ __/ 0 15 Measure J Sales Tax: Third Quarter Review City of Palm Springs General Fund Budget Review (1)Cash Basis (1)Cash Basis Revised (1)Cash Basis FY18-19 FY19-20 FY20-21 FY20-21 Increase/ Actual Actual Budget Actual Decrease July 1,190,015$ 1,489,086$ 195,554$ 1,540,834$ 1,345,280$ Aug 1,157,051$ 1,146,909$ 216,610$ 853,771$ 637,161$ Sept 921,434$ 1,199,738$ 282,663$ 1,260,444$ 977,781$ Oct 1,225,007$ 1,155,050$ 426,741$ 1,359,801$ 933,060$ Nov 1,372,704$ 1,188,251$ 468,348$ 1,084,702$ 616,354$ Dec 1,394,758$ 1,357,357$ 819,994$ 1,412,971$ 592,977$ Jan 1,291,276$ 1,287,324$ 626,222$ 1,332,028$ 705,806$ Feb 1,366,766$ 1,756,619$ 613,241$ 1,629,918$ 1,016,677$ Mar 1,540,628$ 1,423,604$ 526,411$ 1,482,955$ 956,544$ Apr 1,449,640$ 1,228,280$ 473,233$ May 1,545,175$ 588,549$ 730,143$ Jun 1,300,354$ 1,250,141$ 587,740$ 15,754,808$ 15,070,907$ 5,966,900$ 11,957,424$ 7,781,640$ Measure J Sales Taxes 16 Measure J Sales Tax: Third Quarter Review City of Palm Springs General Fund Budget Review •Measure J actual revenue is 200%of total FY 20-21 budgeted revenue •Measure J 9-month revenue is 104%of FY 18-19 and 100%of FY 19-20 9-month revenue •4th Quarter Measure J Projections =95%of FY 18-19 Measure J revenue = +$2.3m over budgeted Measure J revenue C) C) C) 17 Measure J Sales Tax: End of FY Projection City of Palm Springs General Fund Budget Review (1)Cash Basis (1)Cash Basis Revised (1)Cash Basis FY18-19 FY19-20 FY20-21 FY20-21 Increase/ Actual Actual Budget Actual Decrease July 1,190,015$ 1,489,086$ 195,554$ 1,540,834$ 1,345,280$ Aug 1,157,051$ 1,146,909$ 216,610$ 853,771$ 637,161$ Sept 921,434$ 1,199,738$ 282,663$ 1,260,444$ 977,781$ Oct 1,225,007$ 1,155,050$ 426,741$ 1,359,801$ 933,060$ Nov 1,372,704$ 1,188,251$ 468,348$ 1,084,702$ 616,354$ Dec 1,394,758$ 1,357,357$ 819,994$ 1,412,971$ 592,977$ Jan 1,291,276$ 1,287,324$ 626,222$ 1,332,028$ 705,806$ Feb 1,366,766$ 1,756,619$ 613,241$ 1,629,918$ 1,016,677$ Mar 1,540,628$ 1,423,604$ 526,411$ 1,482,955$ 956,544$ Apr 1,449,640$ 1,228,280$ 473,233$ 1,377,158$ 903,925$ May 1,545,175$ 588,549$ 730,143$ 1,467,916$ 737,773$ Jun 1,300,354$ 1,250,141$ 587,740$ 1,235,337$ 647,597$ 15,754,808$ 15,070,907$ 5,966,900$ 16,037,834$ 10,070,934$ Estimates only. Measure J Sales Taxes ~ _A I(___ -....._ r -....._. ,,-=> __,t~ ~ ......___ I I I 18 Recommendations City of Palm Springs General Fund Budget Review •Amend FY 20-21 Budget to increase General Fund revenues by +$20,232,881 •Cancel $2,800,000 transfer from Measure J •Amend FY 20-21 Budget to increase Measure J revenues by +$4,968,321 •Appropriate $7,800,000 for additional expenditures (+$200,000 for CV Housing First Program?) •Amend FY 20-21 Allocated Positions & Compensation Plan to fund 18 vacant positions due to reduction in force implemented FY19-20 19 City of Palm Springs General Fund Budget Review Department Position Reason FTE Unit Range Salary + Benefits Planning Technician Layoff 1 GU 41 133,153$ Clerical Assistant Layoff 1 GU 23 85,396$ Library & Public Services Manager Layoff 1 MX 49 149,745$ Administrative Secretary Layoff 1 MX 39 117,017$ Fleet Maintenance Technician II Layoff 1 GU 39 126,805$ Fleet Maintenance Technician III/Service Write Layoff 1 GU 45 147,041$ Maintenance Electrician Layoff 1 GU 45 147,041$ Maintenance Mechanic I Layoff 1 GU 35 114,898$ Maintenance Supervisor Layoff 1 MX 51 157,294$ Maintenance Supervisor Layoff 1 MX 51 157,294$ Street/Traffic Maintenance Worker, Lead Layoff 1 GU 38 123,652$ Community Outreach & Media Specialist Layoff 1 GU 41 133,153$ Crime Scene Technician Layoff 1 GU 44 143,398$ Rangemaster Layoff 1 GU 41 133,153$ Lifeguard Layoff 0.75 GU 20 59,478$ Lifeguard Layoff 1 GU 20 79,304$ Secretary, Senior Layoff 1 GU 33 109,338$ Special Programs Account Clerk II Layoff 1 GU 31 104,098$ 17.75 2,221,258$ Library Development Services Fire Maintenance & Facilities Police Recreation TOTAL FTE RIF POSITIONS TO BE FUNDED