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:

Gift Level Amount Average Number 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.