data table to show how the amount varies based on the number of solicitations. E Click the icon to view the ballet company fundraising model. 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. D 1 Ballet Company (Simplifty your answers. Type integers or decimals. Do not round.) 2 3 Gift Level 4 Benefactor 5 Philanthropist 6 Producer's Circle 7 Director's Circle 8 Principal 9 Soloist Solicitations Total Donations Average Number of Gifts Amount $10,000 S5,000 $1,000 $500 $100 $50 3 500 12 600 27 51 700 5% 12% of solicitations of solicitations 800 900 11 Solicitations 1,000 1000 12 13 Total Donations $153.500 1100 1200 The Excel formula to find the Total Donations is =(B4°C4)-(B5"C5)+(B6"C6)-(B7"C7)+(B8"B11"C8)+(B9"B11"C9). 1300 1400 1500 1600 Print Done

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
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.
E Click the icon to view the ballet company fundraising model.
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.
A
D
1 Ballet Company
(Simplify your answers. Type integers or decimals. Do not round.)
Solicitations
Total
Donations
Amount
$10,000
3 Gift Level
Average Number of Gifts
4 Benefactor
5 Philanthropist
6 Producer's Circle
7 Director's Circle
8 Principal
9 Soloist
3
$5,000
500
12
27
51
5%
12%
600
$1,000
$500
$100
$50
700
of solicitations
800
24
of solicitations
900
11 Solicitations
1,000
1000
12
13 Total Donations
$153,500
1100
24
1200
The Excel formula to find the Total Donations is
=(B4*C4)+(B5*C5)+(B6*C6)+(B7*C7)+(B8*B11*C8)+(B9*B11*C9).
1300
1400
1500
24
1600
%24
Print
Done
Transcribed Image Text: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. E Click the icon to view the ballet company fundraising model. 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. A D 1 Ballet Company (Simplify your answers. Type integers or decimals. Do not round.) Solicitations Total Donations Amount $10,000 3 Gift Level Average Number of Gifts 4 Benefactor 5 Philanthropist 6 Producer's Circle 7 Director's Circle 8 Principal 9 Soloist 3 $5,000 500 12 27 51 5% 12% 600 $1,000 $500 $100 $50 700 of solicitations 800 24 of solicitations 900 11 Solicitations 1,000 1000 12 13 Total Donations $153,500 1100 24 1200 The Excel formula to find the Total Donations is =(B4*C4)+(B5*C5)+(B6*C6)+(B7*C7)+(B8*B11*C8)+(B9*B11*C9). 1300 1400 1500 24 1600 %24 Print Done
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 5 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.