I. Worksheet Questions 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 vear 2012 is as shown below 02 35,000 04 of Re "Pledged" Contributions 0,000 25,000 35,000 375,000 Federal Grants 250,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 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) . Your answer should clearly show r Ca Pledged" Contributions deral Grants 2. (30 Points) Doctors Without Borders (DWB) operates health programs around the world. It has a central general administrative management staff, and direct country staff (that directly administer the world-wide programs/mission. DWB's mission is to administer medical treatment free-of-charge to local country populations. DWB has the following costs, with the following specific characteristics, for 2010: Central General Management Staff Sabries Central HR General Management Saaries Atghanistan Clinic Supplies Kenyan Clinic Directors Sahries Depreciation, Central Office Employee Benefts-Kema Staff Emplbyee Benefits-Centra 360,000 750,000 60,000 34,000 62,000 Staff Administration 220,000 Automobiles for Country nics n Afica 124,000 Doctors Sabres, Per Dem St Tmts, St. Jola Country Clic Coutry Clnc Rental Costs Depreciation, Kenyan Clncs Program Management Sabries (time studies support a level ofefrt of20% General Management and 80% Dict ProgramLocal Country Program 340,000 258,000 9250,000 Allocate the costs outlined above between "DWB Program Activities" and " information and cost characteristics provided above. Please us the following format (set-up this spreadsheet in Excel): Management & General" based on the 21. 21 hrsicias Salaries Traagerta What percentage of every dollar is allocated to DWB's: Program Activities Management & General Costs 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 91 92 93 04 25,000 35,000 5,000 Pledged" Contributions 50,000 Federal Grants 250,000 75,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) Medged" Centributions Federal Grants 92 35,000 03 01 25,000 04 Source of Revenue "Pledged" Contributions 35,000 50,000 350,000 Federal Grants 250,000 375,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 vear 2012. Your ans w wer should clearly sho 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) "Pledged" Contributions Federal Grants I. Worksheet Questions 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 vear 2012 is as shown below 02 35,000 04 of Re "Pledged" Contributions 0,000 25,000 35,000 375,000 Federal Grants 250,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 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) . Your answer should clearly show r Ca Pledged" Contributions deral Grants 2. (30 Points) Doctors Without Borders (DWB) operates health programs around the world. It has a central general administrative management staff, and direct country staff (that directly administer the world-wide programs/mission. DWB's mission is to administer medical treatment free-of-charge to local country populations. DWB has the following costs, with the following specific characteristics, for 2010: Central General Management Staff Sabries Central HR General Management Saaries Atghanistan Clinic Supplies Kenyan Clinic Directors Sahries Depreciation, Central Office Employee Benefts-Kema Staff Emplbyee Benefits-Centra 360,000 750,000 60,000 34,000 62,000 Staff Administration 220,000 Automobiles for Country nics n Afica 124,000 Doctors Sabres, Per Dem St Tmts, St. Jola Country Clic Coutry Clnc Rental Costs Depreciation, Kenyan Clncs Program Management Sabries (time studies support a level ofefrt of20% General Management and 80% Dict ProgramLocal Country Program 340,000 258,000 9250,000 Allocate the costs outlined above between "DWB Program Activities" and " information and cost characteristics provided above. Please us the following format (set-up this spreadsheet in Excel): Management & General" based on the 21. 21 hrsicias Salaries Traagerta What percentage of every dollar is allocated to DWB's: Program Activities Management & General Costs 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 91 92 93 04 25,000 35,000 5,000 Pledged" Contributions 50,000 Federal Grants 250,000 75,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) Medged" Centributions Federal Grants 92 35,000 03 01 25,000 04 Source of Revenue "Pledged" Contributions 35,000 50,000 350,000 Federal Grants 250,000 375,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 vear 2012. Your ans w wer should clearly sho 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) "Pledged" Contributions Federal Grants