8. 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 2 Philanthropist $5,000 5 Producer’s Circle $1,000 20 Director’s Circle $500 35 Principal $100 5% of solicitations Soloist $50 7% of solicitations Develop a spreadsheet model to calculate the total amount donated based on this information and the number of prospective donors that are solicited at the $100 level or below.