Excel Capstone Project

xlsx

School

Arizona State University *

*We aren’t endorsed by this school

Course

105

Subject

Medicine

Date

Feb 20, 2024

Type

xlsx

Pages

Uploaded by enr2267736

Superior Family Medical Clinic Annual Operation Funds Analysus Sources 1st Qrt 2nd Qrt 3rd Qrt Patients Fees $ 671,443 $ 724,686 $ 647,628 Fund Raising 73,142 103,486 99,342 United Way 20,732 18,650 18,290 City of Lake Forest 80,626 130,067 80,304 City of Edgecombe 53,982 52,584 51,652 Forest County 25,660 27,151 20,880 Federal Grants 345,818 543,751 690,072 Other Grants 225,000 180,500 143,500 Total $ 1,496,403 $ 1,780,875 $ 1,751,668 Highest $ 671,443 $ 724,686 $ 690,072 Lowest $ 20,732 $ 18,650 $ 18,290

4th Qrt Total Operation Funds $ 709,100 $ 2,752,857 43.2% 64,743 340,713 5.3% 27,371 85,043 1.3% 120,931 411,928 6.5% 48,389 206,607 3.2% 30,134 103,825 1.6% 276,287 1,855,928 29.1% 68,000 617,000 9.7% $ 1,344,955 $ 6,373,901 $ 709,100 $ 27,371 Percentage of total

Percent Change 2.5% Operation Funds Trend Next Year Operations Funds $ 2,821,678 349,231 239,964,083,340 143,858,367,209 49,578,259,366,890,800 14,936,094,975,536,700 92,013,679,750,274,900,000,000 9,215,570,599,906,160,000,000 $ 101,229,314,864,919,000,000,000

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

1 2 3 4 5 6 7 $- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 Annual Revenue Distribution 1st Qrt 2nd Qrt 3rd Qrt 4th Qrt

Patients Fees Fund Raising United Way City of Lake Forest City of Edgecombe Forest Country Federal Grants Other Grants Revenue by Sources

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Excel Capstone Project

Related Documents