1 sized city in a certain country is planning its next
Last updated: 4/14/2023
1 sized city in a certain country is planning its next fundraising campaign In recent years the program has found the percentages of donors and gift levels given in the accompanying table Develop a spreadsheet model to calculate the total amount donated based on this information if the company contacts 800 potential donors to donate at the 100 level or belc Click the icon to view the percentages of donors and gift levels Complete the following spreadsheet model to calculate the total amount donated B Amount C Average Number of Gifts 1 Gift Level 2 Benefactor 3 Philanthropist 4 Producer s Circle 5 Director s Circle 6 Principal 7 Soloist 8 9 Solicitations 10 Total Donations A 10 000 5 000 1 000 500 100 50 800 3 12 27 50 7 13 D Donations Y Y T B7 C7 B 9 B7 C7 B 9 Percentages of donors and gift levels Gift Level Benefactor Philanthropist Producer s Circle Director s Circle Principal Soloist Amount 10 000 5 000 1 000 500 100 50 Print Average Number of Gifts 3 12 27 50 7 of solicitations 13 of solicitations Done X