60.1K

Verified Solution

Link Copied!

Refer to Class Exercise 2.1 on p. 47 of the Weikart text. Complete a program budget in Excel for the proposed After-School Girls program based on the assumptions provided. Then, answer the following questions and explain your answers in sentence form within your Excel document or in a separate Word document 1. What percentage of revenues come from student fees? 2. What percentage of direct expenditures (i.e, exclude the indirect cost charge from the total) are related to personnel services? 3. Based on the assumptions, can the program operate on a self-sufficient basis (i.e., do revenues meet/exceed expenditures)? 4. The board wishes to reduce the student fee charge to the lowest amount possible, assuming a balanced budget and no use of reserves or debt. Based on this budget, is it possible to lower the student fee? Why or why not? If so, to what amount? 1. Revenues: Contributions ($117,000), Foundation ($150,000), Student Fees of $200 per person ($4,000), and In-Kind Services ($5,000) because the program will use some of the existing after-school program space. 2. PS Expenses: Executive Director@$150,000 (5 percent of time), Program Coordinator $100,000 (10 percent of time), After-School Girls Program Coordinator $65,000 (100 percent of time), and one staff person @ $50,000 (100 percent of time). Fringe benefits are 20 percent of salaries. 3. NPS Expenses: 20 computers @ $2,000 and 20 printers @ $800, equipment (copier and software) for $7,000, two phones @ $950, In-Kind Rent ($5,000), supplies ($10,000), and travel to eight colleges ($12,000) 4. An indirect cost of 10 percent of the total budget for utilities and administrative support

Answer & Explanation Solved by verified expert

See Answer