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 belo Click the icon to view the percentages of donors and gift levels. Percentages of donors and gift levels Complete the following spreadsheet model to calculate the total amount donated. Gift Level Benefactor A 1 Gift Level B Amount $10,000 Average Number of Gifts 3 C Average Number Philanthropist $5,000 12 Amount Donations of Gifts Producer's Circle $1,000 27 2 Benefactor $10,000 3 Director's Circle $500 50 Principal $100 3 Philanthropist $5,000 12 Soloist $50 7% of solicitations 13% of solicitations 4 Producer's Circle $1,000 27 5 Director's Circle $500 50 6 Principal $100 7% Print Done 7 Soloist $50 13% 8 9 Solicitations 800 10 Total Donations =B7*C7/$B$9 =87+C7+$B$9 - X