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

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter9: Responsibility Accounting And Decentralization

Section: Chapter Questions

Problem 2EA: Consider the national nonprofit organization the American Red Cross. Assume you are the regional...

See similar textbooks

Similar questions

Edwards Center for GNP Accounting, a nonprofit organization, receives a letter from a donor that includes a promise to donate $100,000 in the next fiscal year provided the Center raise an equal amount of cash from other donors. What journal entry will be recorded when the letter is received? No journal entry would be recorded. Debit cash $100,000; credit refundable advance $100,000 Debit pledge receivable $100,000; credit contribution revenue with donor restrictions $100,000 Debit pledge receivable $100,000; credit contribution revenue without donor restrictions $100,000 Debit pledge receivable $100,000; credit refundable advance $100,000
You are the Treasurer for Short Run Sports Club and the manager asked you to prepare the financial statements for 2020 as he will need the information to apply for some grant funding. You already have the following information: Receipts and payments account as at 30 June 2020 2$ 120,000 320,000 37,600 Balance b/d Canteen creditors 145,600 46,000 22,300 Fixtures & fittings Independence fair expenses Wages for canteen staff Laundry expenses Prizes and trophies Subscription Entrance fees Rental of hall 18,000 68,000 Rental of lockers 8500 7600 8,800 9500 Canteen debtors 345 200 Independence fair 172,300 Utilities Honorarium -Admin staff 28000 Repairs Balance c/d 4200 681,600 1,021,600 1,021,600 Additional information: 1 July 2019 30 June 2020 2$ 500,000 100,000 Club house 500,000 64,000 50,000 105,000 66,000 12,000 11,500 2,000 Fixtures and Fittings Sports equipment 45000 Canteen debtors 85,000 59,000 24,000 6,700 3,400 | 2,000 Canteen creditors Canteen stock Subscription on arrears…
In July 2022, a donor promises to donate $100,000 in cash to an NFP organization if the local NFP can raise the same amount ($100,000) from other donors by December 2022. How much revenue (if any) should the NFP recognize in July 2022? (do not use $ signs, commas or decimals in your answer) In July 2022, a donor promises to donate $100,000 in cash to an NFP organization on December 1, 2022. How much revenue (if any) should the NFP recognize in July 2022? (do not use $ signs, commas or decimals in your answer)
The Seneca Children’s Fund (SCF) is a local charity that runs a summer camp for disadvantaged children. The fund’s board of directors has been working very hard over recent years to decrease the amount of overhead expenses, a major factor in how charities are rated by independent agencies. The following data show the percentage of the money SCF has raised that was spent on administrative and fund-raising expenses over the past seven years: Construct a time series plot. What type of pattern exists in the data? Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. Forecast the percentage of administrative expenses for year 8. If SCF can maintain its current trend in reducing administrative expenses, how long will it take SCF to achieve a level of 5% or less?
You are the Treasurer for Short Run Sports Club and the manager asked you to prepare the financial statements for 2020 as he will need the information to apply for some grant funding You already have the following information: Receipts and payments account as at 30 June 2020 Balance b/d 120,000 Canteen creditors 145,600 Subscription 320,000 Fixtures & fittings 46,000 Entrance fees 37,600 Independence fair expenses 22,300 Rental of hall 18,000 Wages for canteen staff 68,000 Rental of lockers 8500 Laundry expenses 7600 Canteen debtors 345 200 Prizes and trophies 8,800 Independence fair 172,300 Utilities 9500 Honorarium -Admin staff 28000 Repairs 4200 Balance c/d 681,600 1,021,600 1,021,600 Additional information: 1 July 2019 30 June 2020 Club house 500,000 500,000 Fixtures and Fittings 64,000 100,000 Sports equipment 50,000 45000 Canteen debtors 105,000 85,000 Canteen creditors 66,000 59,000 Canteen stock 12,000 24,000 Subscription un arrears 11,500 6,700 Subscription in advance 2,000…
You are the Treasurer for Short Run Sports Club and the manager asked you to prepare the financial statements for 2020 as he will need the information to apply for some grant funding. You already have the following information: Receipts and payments account as at 30 June 2020 Balance b/d Subscription Entrance fees Rental of hall Rental of lockers Canteen debtors Independence fair $ 120,000 320,000 37,600 18,000 8500 345 200 172,300 Canteen creditors Fixtures & fittings Independence fair expenses Wages for canteen staff Laundry expenses Prizes and trophies Utilities Honorarium -Admin staff Repairs Balance c/d $ 145,600 46,000 22,300 68,000 7600 8,800 9500 28000 4200 681,600 1,021,600 1,021,600 Additional information: 1 July 2019 30 June 2020 Club house Fixtures and Fittings Sports equipment Canteen debtors Canteen creditors Canteen stock Subscription un arrears…
Assume you wrote up a proposal requesting $5000 for charity. The money would be used to buy food that volunteers (employees from the company) would distribute to the homeless on Saturday. The proposal is approved and you receive the money. However, the CEO comes to you and asks, "What will be the return on the investment?" How would you reply?
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…
You conducted an outreach activity to help the needy in your community and have solicited 952,000.00. You wanted to propose a plan on how o equally divide the money and the possible relief goods that will be included. Ifyou will make a proposal what plan will you do? Show your plan by filling up the form below. OUTREACH PROPOSAL Total amount Solicited: Rational Function Model Possible number of beneficiaries, amount allocated. and relief included. Option 1 Option 2 Option 3 Number of Beneficiaries Amount Allocated per beneficiary Relief goods included and breakdown Cost of each goods Categories Budgeting Excellent (3) Excellent Fair (2) Poor (1) Some understanding Little in in creating a plan for understanding to no understanding creating a plan for spending the money creating a plan for spending the money The goal set achievable in spending the money Planning is The goal set is hard The goal set is not and to achieve achievable and not realistic realistic Accuracy of Solution The…
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 7,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. Monique Johnson, Beta Alpha Psi faculty advisor, estimates the following: Of the 7,000 phone numbers, roughly 10 percent will be wrong numbers (because alumni change addresses and phone numbers without updating State University). In that case, the student 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. Another 15 percent will be correct…
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 6,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: Of the 6,000 phone numbers, roughly 10 percent will be wrong numbers (because alumni change addresses and phone numbers without updating State University). In that case, the student 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. Another 15 percent will be correct…
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 7,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: Of the 7,000 phone numbers, roughly 10 percent will be wrong numbers (because alumni change addresses and phone numbers without updating State University). In that case, the student 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. Another 20 percent will be correct…