1. Develop a grant budget for Assignment 2.3 (Serving Seniors) in the Weikart and Chen book (starting on page 52). Include notes that summarize your assumptions (a good way to do this is to include the notes in a separate column on the right side of the budget numbers). Table 2.2 on page 31 might provide a useful template for how to set up your table. You will end up with a deficit in your budget; assume that this is the amount that you are requesting from the new foundations.

Assignment 2.3. Serving Seniors You are the executive director of a social services nonprofit and have just been notified that you are losing your funding from a local foundation for your seniors program. You serve lunch to more than 100 seniors five days a week, in addition to providing them with a program before the lunch is served. The program is exercise three days a week, and on the other days it is dancing. You decide to approach another foundation to replace the funding you will be losing. Create a proposed budget to attach to your grant proposal (do not write a proposal) to the foundation, using the following information: 1. Revenue: Contributions ($122,200), in-kind services ($10,000), foundation grant ($130,000), and senior contributions ($1,250). 2. Expenses: Executive director @ $150,000 (3% of time); program coordinator @ $100,000 (5% of time); one senior program director @ $50,000 (100% of time); and one senior program staff member @ $35,000 (100% of time). Fringe benefits for staff are 20% of their salaries. NPS consists of 100 seniors budgeted for 250 days of the year at $5 per meal. The exercise and music staff come in for one hour a day for five days each week for 50 weeks @ $25 each an hour. The in-kind services are for the kitchen @ $10,000. Supplies @ $10,000. The indirect cost is 10% of all expenses. **All calculations need to be shown on Excel**