The director of a nonprofit ballet company in a medium-sized city in a certain country is planning its next fundraising campaign. In recent years, the program has found the percentages of donors and gift levels given in the accompanying table. Develop a spreadsheet model to calculate the total amount donated based on this information if the company contacts 900 potential donors to donate at the $100 level or below. H Click the icon to view the percentages of donors and gift levels. Complete the following spreadsheet model to calculate the total amount donated. 1 Gift Level Average Number of Gifts Amount Donations 2 Benefactor $10,000 3 Philanthropist $5,000 11 4 Producer's Circle $1,000 25 5 Director's Circle $500 49 6 Principal $100 8% 7 Soloist $50 14% 9 Solicitations 900 10 Total Donations

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
100%
The director of a nonprofit ballet company in a medium-sized city in a certain country is planning its next fundraising campaign. In recent years, the program has
found the percentages of donors and gift levels given in the accompanying table. Develop a spreadsheet model to calculate the total amount donated based on this
information if the company contacts 900 potential donors to donate at the $100 level or below.
E Click the icon to view the percentages of donors and gift levels.
Complete the following spreadsheet model to calculate the total amount donated.
Average Number
of Gifts
1 Gift Level
Amount
Donations
2 Benefactor
$10,000
3 Philanthropist
$5,000
11
4 Producer's Circie
$1,000
25
5 Director's Circle
$500
49
6 Principal
$100
8%
7 Soloist
$50
14%
9 Solicitations
900
10 Total Donations
BA
Pr
Help me solve this
View an example
Get more help-
Clear all
Check answer
Transcribed Image Text:The director of a nonprofit ballet company in a medium-sized city in a certain country is planning its next fundraising campaign. In recent years, the program has found the percentages of donors and gift levels given in the accompanying table. Develop a spreadsheet model to calculate the total amount donated based on this information if the company contacts 900 potential donors to donate at the $100 level or below. E Click the icon to view the percentages of donors and gift levels. Complete the following spreadsheet model to calculate the total amount donated. Average Number of Gifts 1 Gift Level Amount Donations 2 Benefactor $10,000 3 Philanthropist $5,000 11 4 Producer's Circie $1,000 25 5 Director's Circle $500 49 6 Principal $100 8% 7 Soloist $50 14% 9 Solicitations 900 10 Total Donations BA Pr Help me solve this View an example Get more help- Clear all Check answer
- X
Percentages of donors and gift levels
Gift Level
Amount
Average Number of Gifts
Benefactor
$10,000
Philanthropist
$5,000
11
Producer's Circle
$1,000
25
Director's Circle
$500
49
Principal
$100
8% of solicitations
Soloist
$50
14% of solicitations
Print
Done
Clear all
View an example
Get more help -
Transcribed Image Text:- X Percentages of donors and gift levels Gift Level Amount Average Number of Gifts Benefactor $10,000 Philanthropist $5,000 11 Producer's Circle $1,000 25 Director's Circle $500 49 Principal $100 8% of solicitations Soloist $50 14% of solicitations Print Done Clear all View an example Get more help -
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Financial Statements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education