1. (15 points) You are the executive director of a community service agency in the south Bronx. Your operation is funded through a combination of cash contributions and federal grants. Your revenue budget for fiscal year 2012 is as shown below. Source of Revenue "Pledged" Contributions Federal Grants Q1 Q2 Q3 04 25,000 250,000 35,000 35,000 50,000 375,000 350,000 250,000 You know from past experience that not all of your revenue and support is collected when you earn it. Cash contributions are collected in the quarter they are pledged. Federal government grants are collected one quarter after you send the granting agency a bill. Starting with the revenue budget above, calculate the amount you can expect to collect in the fourth quarter of fiscal year 2012. Your answer should clearly show the portion of revenue from each quarter (above) that will actually be collected in the fourth quarter. You may use the following template as a guide for your answer on Excel, (so, set-up this template on Excel) I MPH-0107/MHA-1007 Accounting & Budgeting for Public Health Administration Mid-Term Exam Spring-II 2023 Fourth Quarter Cash Collections Coming from Q1 "Pledged" Contributions Federal Grants Page 1 of 6 Coming from Q2 Coming from Q3 Coming from Q4 Total Q4 Collections