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 hasfound the percentages of donors and gift levels given in the accompanying table. Develop a spreadsheet model to calculate the total amount donated based on thisinformation 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 Numberof Gifts1 Gift LevelAmountDonations2 Benefactor$10,0003 Philanthropist$5,000114 Producer's Circie$1,000255 Director's Circle$500496 Principal$1008%7 Soloist$5014%9 Solicitations90010 Total DonationsBAPrHelp me solve thisView an exampleGet more help-Clear allCheck answer - XPercentages of donors and gift levelsGift LevelAmountAverage Number of GiftsBenefactor$10,000Philanthropist$5,00011Producer's Circle$1,00025Director's Circle$50049Principal$1008% of solicitationsSoloist$5014% of solicitationsPrintDoneClear allView an exampleGet more help -

The sum of money given by a individual, for any charitable purpose is called a donation. The total…

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

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

See similar textbooks

Similar questions

answer in text form please (without image)
A volunteer has been asked to drop off some supplies at a facility housing victims of a hurricane evacuation. The volunteer would like to bring at least 240 bottles of water, 117 first aid kits, and 83 security blankets on his visit. The relief organization has a standing agreement with two companies that provide victim packages. Company A can provide packages of 21 water bottles, 9 first aid kits, and 7 security blankets at a cost of $2. Company B can provide packages of 8 water bottles, 5 first aid kits, and 3 security blankets at a cost of $1.50. How many of each package should the volunteer pick up to minimize the cost? What amount does the relief organization pay? Answer Enter the value in the first box and the ordered pair in the second box. Minimum Cost of S Minimum Cost at Tables Keypad Keyboard Shortcuts
sity in Philadelphia used a biplane to pull a sign promoting its evening program, and one in Mississippi you 5-38 Advertising Expenditures and Nonprofit Organizations Many colleges and universities have been extensively advertising their services. For example, a upiu sity in Philadelphia used a biplane to pull a sign promoting its evening program, and one in Mississin designed bumper stickers and slogans as well as innovative programs. Suppose Hilliard College charges a comprehensive annual fee of $14,800 for tuition, To and board, and it has capacity for 2,000 students. The admissions department predicts enrollmento 1,700 students for 20X1. Costs per student for the 20X1 academic year are as follows: Variable Fixed Total Educational programs $5,200 $ 3,900 $ 9,100 Room 1,100 2,300 3,400 Board 2,500 500 3,000 $8,800 $ 6,700" $15,500 *Based on 1,700-2,000 students for the year. The assistant director of admissions has proposed a 2-month advertising campaign using radio and television…
The School of Accounting (SOA) at State University is planning its annual fundraising campaign for accounting alumni. This year, the SOA is planning a call-a-thon and will ask Beta Alpha Psi members to volunteer to make phone calls to a list of 5,000 alumni. The Dean’s office has agreed to let Beta Alpha Psi use their offices from 6 p.m. to 9 p.m. each weekday so that they will have access to phones. Each volunteer will be provided with a phone and a script with an introduction and suggested responses to various questions that had been asked in the past.Carol Johnson, Beta Alpha Psi faculty advisor, estimates the following:1. Of the 5,000 phone numbers, roughly 10 percent will be wrong numbers (because alumni change addresses and phone numbers without updating State University). In that case, thestudent is instructed to apologize to the answering party, hang up, and move on to the next phone number. Each of these calls takes about three minutes.2. Another 15 percent will be correct…
Show all work using Excel formulas (you must submit an Excel worksheet showing your work) FPPT Clinic offers Family Practice and Physical Therapy services at its location. The Family Practice Department generates $4,000,000 in revenue per year and the Physical Therapy Department generates $850,000 in revenue per year. The Family Practice Department occupies 80,000 square feet and the Physical Therapy Department occupies 40,000 square feet. Expenses for the departments are: Salaries/Wages & Benefits Other Expenses Family Practice $1,885,000 $1,226,000 Physical Therapy $400,000 $261,111 The Clinic is supported by three cost centers - Human Resources, Accounting, and Housekeeping services. Cost for those services are: Human Resources: $100,000 Accounting: $100,000 Housekeeping: $75,000 Allocate the costs for each of the three cost centers to the Family Practice Department and Physical Therapy Department. For each cost center, select a driver that you think is fair and allocate the cost…
Shiigi Urban Diner is a charity supported by donations that provides free meals to the homeless. The diner's budget for May is to be based on 3,360 meals. The diner's director has provided the following cost data to use in the budget: groceries, $4.40 per meal; kitchen operations, $4,660 per month plus $2.75 per meal; administrative expenses, $3,860 per month plus $1.00 per meal; and fundraising expenses, $1,760 per month. Required: Prepare the diner's budget for the month of May. The budget will only contain the costs listed above; no revenues will be on the budget. Shiigl Urban Diner Planning Budget For the Month Ended May 31 Budgeted meals Groceries Kitchen operations Administrative expenses Fundraising expenses Total expense 3,360
the book I use for study: Horngren's Cost Accounting: A Managerial Emphasis, 16th edition, Global Edition. Questions in image Request Compute: direct method and step method