9) see pictures ### Fundraising Model AnalysisThe director of a nonprofit ballet company is planning its next fundraising campaign. In recent years, the program has identified specific percentages of donors and their corresponding gift levels. These insights were used to create a spreadsheet model to calculate the total amount donated. The table below shows how donation amounts vary with the number of solicitations received.#### Data Table: Solicitations vs. Total DonationsFill in the missing values in the one-way data table to determine how donation amounts change with varying solicitations.- **Simplify your answers. Use decimals or integers without rounding.**| Solicitations | Total Donations ||---------------|-----------------|| 500 | $ || 600 | $ || 700 | $ || 800 | $ || 900 | $ || 1000 | $ || 1100 | $ || 1200 | $ || 1300 | $ || 1400 | $ || 1500 | $ || 1600 | $ |This table allows for an exploration of donation trends relative to the number of solicitations. By analyzing the completed data, one can assess the efficacy of different solicitation volumes on fundraising performance. ## Ballet Company Fundraising Model### Gift Levels and Contributions| Gift Level | Amount | Average Number of Gifts ||----------------------|--------|-------------------------|| Benefactor | $10,000 | 2 || Philanthropist | $5,000 | 10 || Producer’s Circle | $1,000 | 23 || Director’s Circle | $500 | 45 || Principal | $100 | 8% of solicitations || Soloist | $50 | 11% of solicitations |### Summary- **Solicitations**: 1,000- **Total Donations**: $129,000### CalculationThe formula used in Excel to find the Total Donations is:\[=(B4 \times C4)+(B5 \times C5)+(B6 \times C6)+(B7 \times C7)+(B8 \times B11 \times C8)+(B9 \times B11 \times C9)\]This model represents a structured approach to understanding different levels of donations and their contributions to the total funds raised by the ballet company.

We have given the ballet company model as follows:Using the above model, we can calculate the total donations using Excel as follows: Make all values constant instead of B11 and use the corresponding solicitation value instead of B11. We get result as follows, Hence, we can conclude that the amount of total donations increases as the number of solicitations increases.