descriptive spreadsheet models 1 the director of a nonprofit ballet company in a mediumsized us 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 10000 3 philanthropist 5000 10 producers circle 1000 25 directors circle 500 50 principal 100 7 of solicitations soloist 50 12 of solicitations develop a spreadsheet model to calculate the total amount donated based on this information if the company contacts 1000 potential donors to donate at the 100 level or below