Homework: Homework 2 - Spreadsheet Modeling and ... Question 5, 11.6.43 HW Score: 39.79%, 39.79 of 100 points X Points: 0 of 15 Save 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. Click the icon to view the ballet company fundraising model. Fill in the missing values from the one-way data table to show how the amount varies based on the number of solicitations. (Simplify your answers. Type integers or decimals. Do not round.) Solicitations Total Donations 500 ballet company fundraising model 600 B D S $ 700 800 $ Average Number of Gifts 900 $ 1000 $ 1 Ballet Company 2 3 Gift Level 4 Benefactor 5 Philanthropist 6 Producer's Circle 7 Director's Circle 8 Principal 9 Soloist 0 11 Solicitations 12 13 Total Donations Amount $10,000 $5,000 $1,000 $500 $100 $50 1100 12 24 53 6% 14% $ 1200 of solicitations of solicitations $ 1300 $ 1,000 $ 1500 $153,500 1600 The Excel formula to find the Total Donations is =(B4*C4)+(B5*C5)+(B6*C6)+(B7*C7)+(B8*B11"C8)+(B96B11'c9). Print Done Homework: Homework 2 - Spreadsheet Modeling and ... Question 5, 11.6.43 HW Score: 39.79%, 39.79 of 100 points X Points: 0 of 15 Save 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. Click the icon to view the ballet company fundraising model. Fill in the missing values from the one-way data table to show how the amount varies based on the number of solicitations. (Simplify your answers. Type integers or decimals. Do not round.) Solicitations Total Donations 500 ballet company fundraising model 600 B D S $ 700 800 $ Average Number of Gifts 900 $ 1000 $ 1 Ballet Company 2 3 Gift Level 4 Benefactor 5 Philanthropist 6 Producer's Circle 7 Director's Circle 8 Principal 9 Soloist 0 11 Solicitations 12 13 Total Donations Amount $10,000 $5,000 $1,000 $500 $100 $50 1100 12 24 53 6% 14% $ 1200 of solicitations of solicitations $ 1300 $ 1,000 $ 1500 $153,500 1600 The Excel formula to find the Total Donations is =(B4*C4)+(B5*C5)+(B6*C6)+(B7*C7)+(B8*B11"C8)+(B96B11'c9). Print Done