It is time to plan the 2020 Season budget. The fundraising team is hard at work on the budget and activities. They have the follow data about last year (2019) that they are using to start planning the new budget for 2020: 2019's Contributed Income Totals: Individual Giving $405,800 Grants from Foundations $600,000 Government $545,000 Events $100,000 1) In 2020, the Individuals line is expected to grow 25%, the Grants is expected to grow 5%, the Government is expect to decrease 10%, and the Events will stay flat. What is the new budget? (5 points) NEW BUDGET: Individuals Grants Government Events TOTALE 2) What is the total difference from 2019? (1 point) Total Difference 3) For Individuals, we have mix of donors giving at lots of levels. Below are the different amounts that someone can donate. Create the breakout plan of number of donors in each amount for APPROXIMATELY how the Individual goal could be reached. Keep in mind that no more that 50% of your total income can come from donors giving more than $1,000+ and you know that you do not have more than 100 donors in that group. (Note: There are multiples ways to answer this question as long as the above conditions are met. Each line below counts as 1 point each.) (6 points) : Donors giving $50 = #__ X $50 = 5 Donors giving $100 = _X $100 = $ Donors giving $500 = __X $500 = $ Donors giving $1,000 = _X $1,000 = $. Donors giving $5,000 = #_ X $5,000 = $ Donors giving $10,000 = #_ _X $10,000 = $. 4) We know the total expected Grant amount that we will get in 2020 from question #1 However, we also know that 30% of those grants are given out every other year so we will not be able to receive it again until 2022. How many grant income dollars will we get in 2020 but will not be able to apply for next year in 2021? (1 point) Answer: 5) Assume the fiscal year is the same as the calendar year and we have received award letters confirming we reached our goal of $630,000! We want to get started right away on all of the great programs but need to figure out the cash flow for grants based on the following information from the award letters: (12 points) 75% of the grant money will be paid out quarterly (4 times a year) starting in January 10% is paid evenly over the first 6 months of the year. 15% is paid in December. Jan: $_ Jul: $ Aug: $ Feb: Mar: $_ $. Sep: April: $. Oct: May: $ June: 5 Nov: 5 Dec: $. 6) What month(s) has the highest income from grants? (1 point) 7) What month(s) has the lowest income from grants? (1 point) 8) This year, the Government has a new rule that the money must be spent on specific projects for the community. The new guidelines state the following: 50% of the money must go toward ticket subsidies. 25% of the money must go towards community events. 25% of the may be spent on operating support. Figure how much we have to spend in each of these categories: (3 points) Ticket Subsidies: Community Events: $ Operating Support: $_ EXTRA CREDIT: Questions #9 and #10 are for Extra Credit: 9) The Government requires the ticket subsidies to provide half off discounted tickets AND free tickets. Our tickets cost $50. We do not want to give away more than 1,000 free tickets. How many tickets do we need to discount to half price? Fill in the following blanks to solve: (5 Extra Credit Points) Ticket Subsidies from #8 above = $_ 550 ticket price x#_ _of free tickets = $ maximum used towards free tickets $__ remaining dollars / $25 half price tickets=#_ tickets offered for half price 10) For events, we do one big gala a year. The tickets for the gala are $100 but the cost to the organization per person is 50, meaning that we can keep 550 as a donation. We also have corporate sponsorship tables of 10 we can sell for $2,000 that cost us goo, so we can keep $1,500 as a donation. How many tickets and how many corporate sponsorship tables do we need to sell to reach our goal? Keep in mind we want a good turn out of at least 750 people and the room can hold no more than 50 corporate sponsorship tables. (5 Extra Credit Points) 1 Ticket $100.550 cost = 550/person donation X # people = $__ _total 1 Table $2,000 - 5500 cost = $1,500/table donation X#_ tables = $__ total _total profit