Answer Happy

The director of a nonprofit ballet company is planning its next fundraising campaign. In recent years, the program has found the given percentages of donors and gift levels. These were used to develop a spreadsheet model to calculate the total amount donated. Use a one-way data table to show how the amount varies based on the number of solicitations. Click the icon to view the ballet company fundraising model. Solicitations 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 Total Donations $ $ $ S $ $ S $ $ $ S ballet company fundraising model A 1 Ballet Company 2 3 Gift Level 4 Benefactor 5 Philanthropist 6 Producer's Circle 7 Director's Circle 8 Principal 9 Soloist 0 11 Solicitations 12 13 Total Donations B Amount $10,000 $5,000 $1,000 $500 $100 $50 1,000 с с Average Number of Gifts 5 10 26 54 6% 12% $165,000 The Excel formula to find the Total Donations is =(B4*C4)+(B5*C5)+(B6*C6)+(B7*C7)+(B8*B11*C8)+(B9*B11*C9). D of solicitations of solicitations X