Question: 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:
Average Number
Gift Level Amount of Gifts
Benefactor $10,000 3
Philanthropist $5,000 10
Producer's Circle $1,000 25
Director's Circle $500 50
Principal $100 7% of solicitations
Soloist $50 12% of solicitations
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.