Financial Recap of Administrative Services FY22 & Budget FY23

Summary of the FY22 financial recap and FY23 budget for Administrative Services, highlighting total revenues and expenditures, personnel payroll details, operating expenses, and net profit/loss. The data includes a breakdown of general funds, tuition, special funds, and projected revenue/appropriation for the upcoming fiscal year.

• Finance
• Budget
• Administrative Services
• Financial Recap
• FY23

deria Follow

Uploaded on Sep 30, 2024 | 0 Views

Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

Presentation Transcript

1. Administrative Services Recap of FY22 Budget FY23

2. Summary of General Funds and Tuition and Special Funds TOTAL YTD FY2022: SUMMARY OF GF & TFSF 2021 2022 JULY AUGUST 211,531.00 SEPTEMBER 129,811.69 OCTOBER (8,162.00) NOVEMBER (2,557.00) DECEMBER 684,676.94 JANUARY 155,207.00 FEBRUARY 236,788.00 MARCH 123,166.12 - APRIL MAY JUNE 128,056.68 13,313,057.93 TOTAL EXPECTED REVENUE/APPROPRIATIONS 13,009,358.00 (1,354,818.50) TOTAL EXPENDITURES PERSONNEL REGULAR EMPLOYEES REGULAR PAYROLL CB- Collective Bargaining VACATION ASSESSMENT WORKER'S COMP/UIC OVERTIME OVERLOAD LECTURER Lecturer Payroll CB- Collective Bargaining Teaching Equivalent Adjustment - STUDENT HELP Student Help Payroll OTHER PERSONNEL (Non-Regular) Other Personnel Payroll OTHER EXPENDITURES UTILITIES SCHOLARSHIPS Scholarships Grant in Aid, Tuition (obj 6510,6514) - Scholarships - Hawaii Promise *OPERATING EXPENSES R&M (31XX) R&M (58XX) Other Current Expenses Equipment NET PROFIT / (LOSS) 1,056,919.94 898,347.37 890,711.45 869,453.23 1,122,536.26 848,406.30 838,557.92 825,585.19 988,727.62 840,359.06 794,444.67 789,407.46 1,117,256.19 912,593.36 800,437.28 792,124.42 1,012,031.30 903,820.55 800,229.32 791,861.18 1,015,645.94 901,219.09 797,966.24 784,420.34 1,091,444.57 887,590.73 786,765.33 769,373.23 1,056,665.33 885,903.21 782,338.93 767,622.40 1,085,617.49 914,329.99 805,819.96 774,243.66 1,009,773.86 903,606.50 797,107.62 765,652.20 929,052.18 914,270.64 804,794.39 770,006.80 930,543.93 12,416,214.61 857,744.40 10,668,191.20 800,351.37 766,696.01 - - 9,871.30 23,784.06 9,699,524.48 9,466,446.12 - - - - - - - - - - - - - - - - - - - - - - - - - 6,418.74 6,553.99 4,962.33 74.88 6,418.74 1,894.12 6,342.99 2,025.15 11,314.84 2,231.06 11,080.95 6,311.15 6,715.91 8,000.62 7,390.24 24,186.06 7,671.30 23,784.12 11,003.53 23,784.06 89,190.87 130,779.50 13,107.99 852,336.98 852,336.98 8,150.23 13,107.99 - - - - - - - - - - - - - - - - - - 36,276.88 36,276.88 105,726.42 105,726.42 94,921.21 94,921.21 95,053.04 95,053.04 91,006.10 91,006.10 95,675.59 95,675.59 96,773.94 96,773.94 94,111.13 94,111.13 96,531.98 96,531.98 46,260.69 46,260.69 - - - - - - - - - - - - - - - - - - - - - - 7,635.92 7,635.92 9,848.38 9,848.38 9,637.51 9,637.51 6,429.66 6,429.66 8,670.02 8,670.02 8,199.81 8,199.81 5,932.48 5,932.48 3,886.82 3,886.82 203,853.84 53,942.68 124,035.75 47,875.00 3,832.56 3,832.56 4,056.13 4,056.13 170,762.12 41,888.53 34,655.50 34,655.50 4,287.56 4,287.56 7,448.53 7,448.53 171,287.50 40,928.58 49,881.45 3,700.50 4,598.94 4,598.94 7,788.81 7,788.81 106,167.36 52,517.69 9,053.00 9,053.00 5,383.21 5,383.21 7,561.06 7,561.06 14,781.54 49,681.05 (95,310.51) - 134,094.56 - 4,676.74 4,676.74 6,455.60 6,455.60 72,799.53 5,649.96 79,132.79 79,132.79 37,196.95 37,196.95 1,748,023.41 568,312.56 425,384.19 332,365.56 - - - - - - - - - - - - 158,572.57 117,116.56 274,129.96 1,196.77 196,307.00 80,900.00 148,368.56 46,685.19 13,981.00 2,957.00 204,662.83 55,286.85 85,757.75 13,950.00 - 108,210.75 49,593.38 1,843.25 114,426.85 53,825.32 5,180.00 5,180.00 - - - - - - - - - - - - - - - 115,407.00 76,626.19 11,024.00 87,702.37 14,722.30 43,016.13 29,963.94 71,807.75 63,618.23 3,023.23 10,752.25 49,842.75 1,843.25 - 56,774.12 5,525.48 12,808.50 38,440.14 76,160.75 - 25,875.41 421.71 3,361.19 22,092.51 46,180.95 - 80,477.47 6,805.56 24,083.70 49,588.21 (229,405.07) - 60,411.00 4,846.12 9,909.64 45,655.24 93,018.63 754,326.66 65,109.26 148,200.04 541,017.36 41,456.01 55,421.53 4,911.84 9,922.46 40,587.23 94,218.09 11,844.12 18,235.05 64,138.92 44,596.67 4,778.40 4,051.35 35,766.92 67,149.57 8,230.50 12,059.77 46,859.30 - - - - 41,456.01 76,626.19 - - - - - - - - - - - - - 11,952,438.06 (911,005.26) (858,915.93) (1,125,418.19) (1,014,588.30) (330,969.00) (936,237.57) (819,877.33) (962,451.37) (1,009,773.86) (2,283,870.68) (802,487.25) 896,843.32

3. Kaua'i Community College Operating Budget (Draft) FY 2023 (07/01/22 to 06/30/23) General Fund & Tuition and Fees Special Fund (TFSF) Total FY23 Revenues over Expenditures Beginning Balance FY23 Revenue/Appropriation Projection GF 12,456,936 TFSF 4,801,305 1,945,585 Total 4,801,305 14,402,521 - Expenditure Projections Personnel Regular Employee Payroll Lecturer Payroll Student Help Payroll Other Personnel (Non-Regular Payroll) Subtotal Personnel Other Expenditures Utilities & Communication ** Scholarships, Tuition, Stipends & Allowances Repairs & Maintenance Other Operating Expenses Subtotal Other Total Expenditure Projection Transfer Projections (Transfer-Ins) Transfer Projections (Transfer-Outs) Projected Net Operating Income w/out One-Time Expenditures 10,988,933 1,320,576 12,309,509 143,090 116,920 75,000 335,010 11,132,023 1,320,576 116,920 75,000 12,644,519 - - - 586,953 134,095 11,026 732,074 13,041,583 1,020,161 435,514 400,000 291,290 228,021 1,541,100 2,460,411 2,795,421 605,509 474,042 (72,712) 986,953 425,385 228,021 1,552,126 3,192,485 15,837,004 1,625,670 474,042 362,802 - - Projected One-Time Expenditures *** - 645,657 645,657 Estimated Ending Balance Reserve Held Centrally 435,514 4,082,936 792,432 4,518,450 792,432 - 5% Reserve Target for FY 2024 (Executive Policy) 16% Reserve Target for FY 2024 (BOR Policy) n/a n/a 785,277 2,512,886 785,277 2,512,886

4. HEERF Expenditures as of 7/31/2022 SUMMARY: BUDGET vs ACTUAL EXPENSES CARES CRRSAA ARPA UPDATED: 7/31/2022 6109062 6110412 6110774 CARES ACT Student Aid 4/28/2020-6/30/2023 CRRSAA Student Aid 4/28/2020-6/30/2023 ARPA- Student Aid 4/28/2020-6/30/2023 TOTAL MULTI YEAR AWARD(S) Category Description REMAINING BUDGET BALANCE REMAININ G BUDGET BALANCE REMAININ G BUDGET BALANCE REMAINING BUDGET BALANCE REMAINING BUDGET BALANCE REMAINING BUDGET BALANCE ACTUAL including Encumbrances ACTUAL including Encumbrances ACTUAL including Encumbrances ACTUAL including Encumbrances ACTUAL including Encumbrances BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET ACTUAL STUDENT AID P425E201428 C100 C101 C102 C103 C105 C107 C112 C113 C115 C116 C117 CGB SAL&WAGE CGB OVERLOAD CGB CASUAL CGB STUD-REG CGB FRINGE CGB MAT&SUP CGB RENTALS CGB REPAIRS CGB STIPENDS CGB EQUIPMENT CGB OTHERS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 267,842.00 267,842.00 267,842.00 267,647.00 195.00 0.00 0.00 1,116,661.00 1,106,690.00 9,971.00 0.00 0.00 1,652,345.00 1,642,179.00 10,166.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 C990 Indirect Costs Grand Total 0.00 0.00 0.00 - 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,116,661.00 1,106,690.00 1,652,345.00 267,842.00 267,842.00 - - - 267,842.00 267,647.00 195.00 - - - 9,971.00 1,642,179.00 10,166.00 6109375 6110306 6110413 6110831 6110775 TOTAL MULTI YEAR AWARD(S) (DO NOT USE) CARES ACT HEERF (PART II) 5/5/2020-6/30/2023 CARES ACT HEERF - IDC 5/5/2020-6/30/2023 CRRSAA HEERF II 5/5/2020-6/30/2023 CRRSAA - HEERF II-Student Reengagement 5/5/2020-6/30/2023 ARPA HEERF III 5/5/2020-6/30/2023 Category Description REMAINING BUDGET BALANCE REMAININ G BUDGET BALANCE REMAININ G BUDGET BALANCE REMAINING BUDGET BALANCE REMAINING BUDGET BALANCE REMAINING BUDGET BALANCE ACTUAL including Encumbrances 9,800.00 8,000.00 2,399.04 ACTUAL including Encumbrances ACTUAL including Encumbrances ACTUAL including Encumbrances ACTUAL including Encumbrances BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET ACTUAL INSTITUTIONAL P425F200988 C100 C101 C102 C103 C105 C106 C107 C111 C112 C113 C115 C116 C117 CGB SAL&WAGE CGB OVERLOAD CGB CASUAL CGB STUD-REG CGB FRINGE CGB SVCS-FEE CGB MAT&SUP CGB UTIL&COM CGB RENTALS CGB REPAIRS CGB STIPENDS CGB EQUIPMENT CGB OTHERS 10,400.00 8,000.00 1,800.00 600.00 0.00 (599.04) 0.00 0.60 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 62,500.00 2,600.00 0.00 0.00 0.00 58.50 25,440.00 26,775.08 59,900.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 72,900.00 8,000.00 1,800.00 30,203.00 13,093.50 12,400.00 8,000.00 2,399.04 60,500.00 0.00 0.00 0.00 0.00 0.00 (599.04) 30,203.00 12,587.10 (44,065.50) 192,187.98 0.00 0.00 30,203.00 12,645.00 30,203.00 12,586.50 (25,440.00) 393,847.92 0.00 448.50 0.00 447.90 0.00 506.40 44,065.50 471,178.42 0.00 18,625.50 203,772.69 (18,625.50) (203,772.69) 0.00 230,594.35 230,594.35 12,149.05 10,036.30 2,112.75 0.00 0.00 0.00 0.00 0.00 (1,818.10) 420,623.00 663,366.40 0.00 0.00 15.70 0.00 0.00 0.00 0.00 0.00 15.70 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 15.70 0.00 60,000.00 60,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 60,000.00 15.70 217,593.00 60,000.00 0.00 0.00 0.00 38,206.06 38,206.06 179,386.94 179,376.94 179,376.94 38,216.06 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,818.10 1,424.97 (1,424.97) 794,019.00 794,019.00 794,019.00 3,243.07 790,775.93 0.00 C990 Indirect Costs Grand Total 0.00 0.00 0.00 1.56 4,434.40 16,583.45 4,326.86 16,181.26 107.54 402.19 213,879.00 838,056.06 19,001.40 75,299.95 194,877.60 762,756.11 0.00 0.00 0.00 10.00 289,817.00 1,083,836.00 74,377.03 296,775.22 215,439.97 787,060.78 508,130.40 2,369,121.00 97,705.29 818,890.36 410,425.11 1,550,230.64 251,258.55 251,256.99 179,386.94 179,376.94 6109376 (DO NOT USE) CARES ACT HEERF MSI (PART III) 6/8/2020-6/30/2023 6110307 6110308 6110985 TOTAL MULTI YEAR AWARD(S) CARES ACT HEERF MSI - IDC 6/8/2020-6/30/2023 CRRSAA - HEERF II MSI 6/8/2020-6/30/2023 ARPA HEERF III 5/5/2020-6/30/2023 Category Description REMAINING BUDGET BALANCE REMAININ G BUDGET BALANCE REMAININ G BUDGET BALANCE REMAINING BUDGET BALANCE REMAINING BUDGET BALANCE REMAINING BUDGET BALANCE ACTUAL including Encumbrances 4,986.95 ACTUAL including Encumbrances ACTUAL including Encumbrances ACTUAL including Encumbrances ACTUAL including Encumbrances BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET ACTUAL MSI P425L200169 C100 C101 C102 C103 C105 C106 C107 C108 C110 C111 C113 C115 C116 C117 CGB SAL&WAGE CGB OVERLOAD CGB CASUAL CGB STUD-REG CGB FRINGE CGB SVCS-FEE CGB MAT&SUP CGB TRAVEL CGB PRINT CGB UTIL&COM CGB REPAIRS CGB STIPENDS CGB EQUIPMENT CGB OTHERS 4,917.21 0.00 0.00 866.55 743.50 0.00 15,619.60 (69.74) 0.00 0.00 0.00 69.74 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4,003.55 0.00 0.00 4,483.05 495.43 9,258.28 117,604.41 (4,003.55) 304,058.00 69,071.86 234,986.14 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 308,975.21 78,062.36 230,912.85 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 30,000.00 6,001.45 649.80 30,000.00 1,518.40 154.37 (9,258.28) 19,877.81 1,168.00 11,802.38 30,591.90 (1,168.00) 185,314.62 166,289.10 30,000.00 203,985.00 198,274.30 1,168.00 17,151.98 31,761.09 9,258.28 632,380.31 711.30 2,903.56 212.08 28,832.00 186,833.02 166,513.21 (9,258.28) (474,778.49) (711.30) (2,903.56) (212.08) 866.55 673.76 0.00 15,619.60 197,117.00 196,881.00 0.00 0.00 0.00 0.00 0.00 137,482.22 4,500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 179,174.94 711.30 (174,674.94) (711.30) 319,981.36 (319,981.36) 157,601.82 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,533.19 0.00 0.00 45,338.00 (2,533.19) 0.00 0.00 0.00 0.00 0.00 0.00 370.37 212.08 0.00 0.00 48,384.57 4,495.00 (370.37) (212.08) 0.00 0.00 (48,384.57) 784,413.00 0.00 0.00 0.00 0.00 209,669.00 209,669.00 331.00 0.00 9,002.00 (45,007.00) 61,579.00 (61,579.00) 210,000.00 316,586.00 48,384.57 59,480.00 (106,586.00) (48,384.57) 738,430.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 9,002.00 54,985.00 (54,985.00) 788,908.00 797,910.00 C990 Indirect Costs Grand Total 0.00 0.00 0.00 0.00 66,843.67 250,310.14 49,414.85 233,130.76 17,428.82 17,179.38 256,433.00 958,989.00 126,839.21 535,923.59 129,593.79 423,065.41 287,951.00 1,076,859.00 99,755.92 473,199.30 188,195.08 603,659.70 611,227.67 2,517,974.00 276,009.98 1,474,069.51 335,217.69 1,043,904.49 231,815.86 231,815.86 - - -

5. Kauai Community College Projects CAMPUS FUNDED Tennis Courts resurfacing: $142K Currently awaiting System approval/signatures. Outdoor exercise equipment: Currently bidding process, anticipate at least $40K Title 3 upstairs library DL classroom: $500K Notice to proceed 8/01/2022 SYSTEM FUNDED Chiller replacements: $3M Closing document stage Culinary exhaust hood: $500K Closing document stage Natural Science fume hood: $600K about 50% completed, supply chain issues Bus/Nur Renovation: $5M Extended until early December, major supply chain issues OSC/OCET roof/rain gutters replacement: $600K About 60% completed PV project: $3.5M Recently agreed (indemnification). Estimated calculated reduction is about 40%. Based on ideal weather conditions. Production decrease during winter/cloudy/rainy months SYSTEM FUNDED PROJECTS IN DESIGN PHASE Automotive exhaust system: Design phase completed, awaiting construction funding Upcoming projects: Chemistry 101 fume hood, Campus fire alarm system, Campus parking & walkway lighting. Currently in review/approval process.

6. IT Upgrades Computer lab upgrades (new cpu): Classrooms scheduled for Fall 2022 use have been upgraded with: ART 101 New Station ABRP 113 New Station AMT 101A New Station AMT 101B New Station CARP 108 New Station CARP 109 New Station CCTR 102G New Station, Zoom Station Touchscreens CCTR 105D New Station, Zoom Station Touchscreens CCTR 124C Duane's classroom too small for new teacher station LRC 123 Teacher station new computer LRC 124A New Station, Zoom Station Touchscreens LRC 124B New Station, Zoom Station Touchscreens LRC 128 New Station, Zoom Station Touchscreens LRC 130 New Station, Zoom Station Touchscreens LRC 129 New Station, Zoom Station Touchscreens Carpentry 108 NSCI 101 Keeping old teacher station, replacing computer NSCI 104 Has new teacher station NSCI 110 Getting new computer OCET 106C/D New Station, Zoom Station Touchscreens SSCI 114 New Station, Zoom Station Touchscreens WELD2 101 New Station, Zoom Station Touchscreens We will continue deploying to remaining classrooms Carpentry 109 (Deploying this week) DKI 121 DKI 125 Library (New furniture just arrived, will be deploying this week) Testing Center Veterans Center OCET 104 Business and HED labs (ready to deploy when building available) Projector/Screen/Zoom in Cafeteria HED Kilohana & Haupu Annex Mic/Speaker/Amp Laptop/Docking Station desktop replacements have been deployed to all that requested upgrade.