Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Determine the sources of funds. Explain them 2. Determine the primary uses of funds and list them by the percentage used. 3. Determine the

image text in transcribedimage text in transcribedimage text in transcribed

1. Determine the sources of funds. Explain them

2. Determine the primary uses of funds and list them by the percentage used.

3. Determine the amounts set aside for capital expenditures? Identify the plans that these funds will be used for, by researching the facilities plan for COD. https://www.collegeofthedesert.edu/community/facility-plan/fmp/default.php

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
College of the Desert General Fund Summary Fiscal Year 2022-2023 Adopted Budget and Multi-Year Projection Combined Restricted and Unrestricted General Fund % Change over PY Change Unaudited % Change Adopted Projected Projected Change Projected Change Actuals over PY Actuals Actuals over PY Budget Actuals Budget over PY Budget over PY 2019-20 2020-21 2021-22 2022-23 2023-24 2024-25 Revenues Federal Revenue 4,015,595 20.6% 10,907,188 9,954,642 8.7% 3,275,255 -67.1% 3,397,972 3.7% 3,517,428 3.5% State Revenue 47,414,295 17.6% 47,626,752 52,853,559 11.0% 79,918,630 51.2% 63,132,720 -21.0% 63,601,158 0.7% Local Property Taxes 42,512,877 0.8% 43,609,000 48,014,154 10.1% 49,214,508 2.5% 50,678,778 3.0% 51,992,611 2.6% Local Fees & Revenue 7,928,543 3.2% 6,826,610 5,633,144 -17.5% 9,382,308 66.6% 7,082,867 -24.5% 7,316,122 3.3% Total Revenues 101,871,310 8.3% 108,969,550 116,455,499 .9% 141,790,701 21.8% 124,292,338 -12.3% 126,427,319 1.7% Expenditures Academic Salaries 33,326,568 7.0% 34,384,572 35,543,964 3.4% 37,556,808 5.7% 41,966,172 11.7% 44,513,187 6.1% Non-Academic Salaries 20,084,527 2.5% 21,381,013 22,234,293 4.0% 26,067,555 17.2% 27,155,970 4.2% 30,051,571 10.7% Employee Benefits 22,860,186 -2.6% 23,351,538 25,676,068 10.0% 28,321,734 10.3% 29,069,923 2.6% 30,286,488 4.2% Total Salaries & Benefits 76,271,281 2.8% 79,117,123 83,454,325 5.5% 91,946,097 10.2% 98,192,065 6.8% 104,851,246 6.8% Materials & Supplies 2,004,954 -21.9% 1,873,212 2,419,924 29.2% 5,168,615 113.6% 2,578,873 -50.1% 2,682,543 4.0% Services and Operating Expenses 9,566,414 -10.1% 10,544,018 13,957,836 32.4% 21,952,909 57.3% 16,757,288 -23.7% 15,494,227 7.5% Capital Outlay 1,244,386 -16.2% 1,136,560 2,940,130 158.7% 4,347,446 47.9% 4,104,920 -5.6% 5,485,434 33.6% Total Expenditures 89,087,035 0.2% 92,670,913 102,772,215 10.9% 123,415,067 20.1% 121,633,146 1.4% 128,513,450 5.7% Excess (Deficiency) 12,784,275 16,298,637 13,683,284 18,375,634 2,659,191 (2,086,132) Transfers & Contributions 904,320 1,309,237 1,854,160 4,127,554 5,760,002 Other Outgo 7,572,266 12,582,494 11,059,468 20,215,581 6,695,292 3,335,202 Total Other Sources & Uses (7,572,266) 201.7% (11,678,174) (9,750,231) -16.5% (18,361,421) 88.3% (2,567,738) -86.0% 2,424,801 -194.4% Change in F 5,212,009 4,620,463 3,933,053 14,213 1,454 338,669 Beginning Fund Balance 17,620,131 22,832,140 27,452,600 31,385,654 31,399,868 31,491,322 Audit Adjustments Adjusted Beginning Balance 17,620,131 22,832,140 27,452,600 31,385,654 31,399,868 31,491,322 Ending Fund Balanc 22,832,140 29.6% 27,452,602 31,385,653 14.3% 31,399,868 0.0% 31,491,322 0.3% 31,829,991 1.1% Page 1 of 4College of the Desert General Fund Summary Fiscal Year 20222023 Adopted Budget and MultiYear Projection Unrestricted General Fund % Change % over PY % "/6 Change Unaudited % Change Adopted Projected Projected Change Projected Change Actuals over PY Actuals Actuals over PY Budget Actuals Budget over FY Budget over PY 2019720 2020721 2021722 2022-23 2023724 2024725 Revenues Federal Revenue - ~ - - - - State Revenue 34,341,106 28.5% 32,934,620 33,142,374 0.6% 44,149,386 33.2% 46,121,536 4.5% 45,975,992 70.3% Local Property Taxes 42,512,877 08% 43,609,000 48,014,154 10.1% 49,214,508 25% 50,678,778 3.0% 51,992,611 2.6% Local Fees 81 Revenue 4,740,843 -1.4% 4,587,033 3,542,272 -22.8% 4,711,764 33.0% 4,879,505 3.6% 5,024,185 3.0% Total Revenues 81,594,826 10.7% 81,130,654 84,698,800 4.4% 98,075,658 15.8% 101,679,820 3.7% 102,992,788 1.3% Expenditures Academic Salaries 28,561,299 5.2% 27,622,231 29,979,411 8.5% 33,478,570 11.7% 36,048,929 7.7% 38,290,455 6.2% NonAcademic Salaries 14,972,495 0.9% 16,341,520 16,821,939 2.9% 19,861,020 18.1% 21,763,713 9.6% 24,281,855 11.6% Employee Benefits 18,862,246 18,993,146 21,354,001 12.4% 23,978,255 w 24,450,028 m 25,389,398 & Total Salaries 8: Benets 62,396,040 1.2% 62,956,897 68,155,351 8.3% 77,317,845 13.4% 82,262, 669 6.4% 87,961, 709 6.9% Materials 8: Supplies 889,390 718.4% 508,020 968,741 90.7% 1,050,816 8.5% 1,049,616 70.1% 1,091,811 4.0% Services and Operating Expenses 6,862,002 -5.1% 6,979,862 7,942,854 13.8% 11,244,043 41.6% 13,899,483 23.6% 15,071,703 8.4% Capital Outlay 304,937 26.8% 127,617 507,579 297.7% 1,714,835 237.8% 3,070,753 79.1% 4,425,413 44.1% Total Expenditures 70,452,369 0.3% 70,572,396 77,574,525 9.9% 91,327,539 17.7% 100,282,521 9.8% 108,550,635 8.2% Excess (Deficiency) 11,142,457 10,558,257 7,124,275 6,748,119 1,397,299 (5,557,847) Transfers & Contributions (1,306,549) (784,961) 33,427 149,964 2,331,672 3,891,926 Other Outgo (4,838,306) (6,723,911) (3,633,689) (6,898,083) (3,728,971) (250,438) Total Other Sources 8 Uses (6,144,855) 611.3% (7,508,873) (3,600,262) 752.1% (6,748,119) 87.4% (1,397,298) 779.3% 3,641,488 860.6% Change in Fund Balance 4,997,602 3,049,385 3,524,013 (0) 0 (1,916,359) Beginning Fund Balance 15,624,056 20,621,658 23,671,042 27,195,055 27,195,055 27,195,055 Audit Adjustments - - - - - Adjusted Beginning Balance 15,624,056 20,621,658 23,671,042 27,195,055 27,195,055 27,195,055 Ending Fund Balance 20,621,658 32.0% 23,671,042 27,195,055 14.9% 27,195,055 0.0% 27,195,055 0.0% 25,278,696 -7.0% Page 2 0f 4 College of the Desert General Fund Summary Fiscal Year 2022-2023 Adopted Budget and Multi-Year Projection Restricted General Fund % Change % over PY % Change Unaudited % Change Adopted Projected Projected Change Projected Change Actuals over PY Actuals Actuals over PY Budget Actuals Budget over PY Budget over PY 2019-20 2020-21 2021-22 2022-23 2023-24 2024-25 Revenues Federal Revenue 4,015,595 20.6% 10,907,188 9,954,642 -8.7% 3,275,255 67.1% 3,397,972 3.7% 3,517,428 3.5% State Revenue 13,073,189 .3.9% 14,692,132 19,711,185 34.2% 35,769,244 81.5% 17,011,184 -52.4% 17,625,166 3.6% Local Property Taxes Local Fees & Revenue 3,187,700 5.8% 2,239,577 2,090,873 6.6% 4,670,544 123.4% 2,203,362 -52.8% 2,291,937 4.0% Total Revenue 20,276,484 -0.2% 27,838,897 31,756,699 14.1% 43,715,04 37.7% 22,612,518 -48.3% 23,434,530 3.6% Expenditures Academic Salaries 4,765,269 19.0% 6,762,341 5,564,553 -17.7% 4,078,238 -26.7% 5,917,243 45.1% 6,222,732 5.2% Non-Academic Salaries 5,112,032 7.4% 5,039,493 5,412,354 7.4% 6,206,535 14.7% 5,392,258 13.1% 5,769,716 7.0% Employee Benefits 3,997,940 6.39 4,358,392 4,322,067 0.8 4,343,479 0.5% 4,619,896 6.4% 4,897,089 6.0% Total Salaries & Benefits 13,875,241 10.8% 16,160,226 15,298,974 -5.3% 14,628,252 -4.4% 15,929,396 8.9% 16,889,537 5.0% Materials & Supplies 1,115,564 -24.5% 1,365,192 1,451,183 6.3% 4,117,799 183.8% 1,529,257 62.9% 1,590,733 4.0% Services and Operating Expenses 2,704,412 -20.6% 3,564,156 6,014,982 68.8% 10,708,866 78.0% 2,857,805 -73.3% 422,524 -85.2% Capital Outlay 939,449 -24.6% 1,008,943 2,432,551 141.1% 2,632,611 8.2% 1,034,167 60.7% 1,060,021 2.5% Total Expenditures 18,634,666 .0.1% 22,098,517 25,197,690 14.0% 32,087,528 27.3% 21,350,625 33.5% 19,962,815 6.5% Excess (Deficiency) 1,641,818 5,740,380 6,559,010 11,627,515 1,261,893 3,471,716 Transfers & Contributions 1,306,549 1,689,281 1,275,810 1,704,196 1,795,882 1,868,076 Other Outgo (2,733,961) (5,858,583) (7,425,780) (13,317,498) (2,966,321) (3,084,763) Total Other Sources & Uses (1,427,411) -13.3% (4,169,302) (6,149,969) 47.5% (11,613,302) 88.8% (1,170,439) -89.9% (1,216,687) 4.0% Change in Fund Balance 214,407 1,571,078 409,040 14,213 91,454 2,255,028 Beginning Fund Balance 1,996,075 2,210,482 3,781,559 4,190,600 4,204,813 4,296,267 Audit Adjustments Adjusted Beginning Balance 1,996,075 2,210,482 3,781,559 4,190,600 4,204,813 4,296,267 Ending Fund Balance 2,210,482 10.7% 3,781,559 4,190,600 10.8% 4,204,813 0.3% 4,296,267 2.2% 6,551,295 52.5% Page 3 of 4College of the Desert General Fund Summary Fiscal Year 2022-2023 Adopted Budget and Multi-Year Projection Unrestricted General Fund Board Reserves % Change % over PY % % Change Unaudited % Change Adopted Projected Projected Change Projected Change Actuals over PY Actuals Actuals over PY Budget Actuals Budget over PY Budget over PY 2019-20 2020-21 2021-22 2022-23 2023-24 2024-25 Ending Fund Balance 20,621,658 32.0% 23,671,042 27,195,055 14.9% 27,195,055 0.0% 27,195,055 0.0% 25,278,696 -7.0% Components of Fund Balance Reserve for Economic Stability 4,921,055 4,788,636 5,545,563 6,332,209 7,241,516 8,122,515 Appropriation for Contingency 15,700,603 18,882,406 21,649,492 20,862,846 19,953,539 17,156,181 Other Designations: Other One-Time Designations Reserve for Workforce Development New Market Tax Credit Total Designations 20,621,658 23,671,042 27,195,055 27,195,055 27,195,055 25,278,696 Total Undesignated Page 4 of 4

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Hospitality

Authors: John Walker

7th Edition

0133800903, 9780133800906

More Books

Students also viewed these General Management questions

Question

Values: What is important to me?

Answered: 1 week ago

Question

Purpose: What do we seek to achieve with our behaviour?

Answered: 1 week ago