Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 varios based on the number of solicitations Click the icon to view the ballet company fundraising model. w Fill in the missing values from the one-way data table to show how the amount Varios based on the number of solicitations. (Simplify your answers. Typo integers or decimals. Do not round.) Solicitations Total Donations 500 600 700 800 900 1000 1100 1200 5 $ 1300 1400 1500 1600 B. D A 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 Average Number of Gifts 4 12 23 46 6% 10% of solicitations of solicitations 1,000 $157,000 The Excel formula to find the Total Donations is =(B4*C4)+(B5*C5)+(B6*C6)+(87*C7)+(B8*B11*C8)+(B9*B11*09). Print Done
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started