Charity Navigator is America's leading independent charity evaluator. The data in the Excel Online file below show the total expenses ($), the percentage of the total budget spent on administrative expenses, the percentage spent on fundraising, and the percentage spent on program expenses for 10 supersized charities. Administrative expenses include overhead, administrative staff and associated costs, and organizational meetings. Fundraising expenses are what a charity spends to raise money, and program expenses are what the charity spends on the programs and services it exists to deliver. The sum of the three percentages does not add to 100% because of rounding. Construct a spreadsheet to answer the following questions. Charity # Charity Total Expenses ($) Administrative Expenses (%) Fundraising Expenses (%) Program Expenses (%) 1 American Red Cross 3355147520 3.8 3.9 92.1 2 World Vision 1200410940 3.8 7.6 88.4 3 Smithsonian Institution 1078888839 23.3 2.6 73.7 4 Food For the Poor 1049069977 0.7 2.2 96.7 5 American Cancer Society 1006600565 5.8 22.2 71.5 6 Volunteers of America 927343532 8.4 1.8 89.6 7 Dana-Farber Cancer Institute 876424648 13.0 1.4 85.4 8 AmeriCares 850339452 0.5 0.6 98.6 9 ALSAC - St. Jude Children's Research Hospital 830736527 9.5 16.9 73.2 10 City of Hope 736275633 13.6 2.8 83.2
Charity Navigator is America's leading independent charity evaluator. The data in the Excel Online file below show the total expenses ($), the percentage of the total budget spent on administrative expenses, the percentage spent on fundraising, and the percentage spent on program expenses for 10 supersized charities. Administrative expenses include overhead, administrative staff and associated costs, and organizational meetings. Fundraising expenses are what a charity spends to raise money, and program expenses are what the charity spends on the programs and services it exists to deliver. The sum of the three percentages does not add to 100% because of rounding. Construct a spreadsheet to answer the following questions.
Charity # | Charity | Total Expenses ($) | Administrative Expenses (%) | Fundraising Expenses (%) | Program Expenses (%) |
1 | American Red Cross | 3355147520 | 3.8 | 3.9 | 92.1 |
2 | World Vision | 1200410940 | 3.8 | 7.6 | 88.4 |
3 | Smithsonian Institution | 1078888839 | 23.3 | 2.6 | 73.7 |
4 | Food For the Poor | 1049069977 | 0.7 | 2.2 | 96.7 |
5 | American Cancer Society | 1006600565 | 5.8 | 22.2 | 71.5 |
6 | Volunteers of America | 927343532 | 8.4 | 1.8 | 89.6 |
7 | Dana-Farber Cancer Institute | 876424648 | 13.0 | 1.4 | 85.4 |
8 | AmeriCares | 850339452 | 0.5 | 0.6 | 98.6 |
9 | ALSAC - St. Jude Children's Research Hospital | 830736527 | 9.5 | 16.9 | 73.2 |
10 | City of Hope | 736275633 | 13.6 | 2.8 | 83.2 |
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 6 images