The director of a nonprofit ballet company in a medium sized U. S. city is planning its next fundraising campaign. In recent years, the program has found the following percentages of donors and gift levels:

Develop a spreadsheet model to calculate the total amount donated based on this information if the number of the company contacts 1000 potential donors to donate at the $ 100 level or below.

Transcribed Image Text:

Average Number of Gifts 3 10 25 Gift Level Benefactor Philanthropist Producer's Circle Director's Circle Principal Soloist Amount $10,000 $5,000 $1,000 $500 50 $100 550 7% of solicitations 12% of solicitations