The director of a nonprofit ballet company in a medium-sized city in a certain country is planning its next fundraising campaign. In recent years, the program has found the percentages of donors and gift levels given in the accompanying table. Develop a spreadsheet model to calculate the total amount donated based on this information if the company contacts 800 potential donors to donate at the $100 level or below. Click the icon to view the percentages of donors and gift levels. 7 Soloist 8 9 Solicitations 10 Total Donations Enter the values in the model. $50 13% =B7*C7*$B$9 800 =SUM(D2:D7) Percentages of donors and gift levels (Type integers or decimals. Do not round.) A B C D Gift Level Benefactor Amount $10,000 Average Number of Gifts 3 g 1 Gift Level Amount Average Number Donations Philanthropist $5,000 12 of Gifts Producer's Circle $1,000 27 2 Benefactor $10,000 3 Director's Circle $500 50 3 Philanthropist $5,000 12 Principal $100 7% of solicitations 4 Producer's Circle $1,000 27 Soloist $50 13% of solicitations 5 Director's Circle $500 50 6 Principal $100 7% 7 Soloist 8 9 Solicitations $50 13% Print Done 800 X