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.

Fill in the missing values from the one-way data table to show how the amount varies based on the number of solicitations

Solicitations Total Donations

500 ????

600 ??????

700 ??????

800 ?????

900 ??????

1000 ??????

1100 ??????

1200 ?????

1300 ??????

1400 ?????

1500 ??????

1600 ?????

he amoy ballet company fundraising model A 1 Ballet Company Average Number of Gifts 3 Gift Level 4 Benefactor 5 Philanthropist 6 Producer's Circle 7 Director's Circle 8 Principal 9 Soloist Amount $10,000 $5,000 $1,000 $500 $100 $50 26 50 9% of solicitations of solicitations 11% 0 1,000 11 Solicitations 12 13 Total Donations $150,500 The Excel formula to find the Total Donations is =(B4*C4)+(B5*C5)+(B6*C6)+(B7*C7)+(B8*B11*08)+(B9*B11*09). Print Done