The director of a nonprofit ballet company in a medium sized

Last updated: 4/17/2023

The director of a nonprofit ballet company in a medium 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 below Click the icon to view the percentages of donors and gift levels 7 Soloist 8 9 Solicitations 10 Total Donations Enter the values in the model Type integers or decimals Do not round A 1 Gift Level 2 Benefactor 3 Philanthropist 4 Producer s Circle 5 Director s Circle 6 Principal 7 Soloist 8 9 Solicitations 50 B Amount 800 SUM D2 07 10 000 5 000 1 000 500 100 50 800 C 13 B7 C7 B 9 Average Number of Gifts 3 12 27 50 7 13 D Donations PRE 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 O X