So I'm not really sure how to go about doing this exercise... I dont even think I understand what it is asking me to do. Does it just want me to put all this info into a spreadsheet? If so, how would I go about starting that? I just kind of need a jumping off point to get me started.

There is no specfic question per se, i think it just wants us to format a proposed budget. If needed for reference, the book we are using is "Budgeting and Financial Managament for Nonprofit Organizations"

CLASS EXERCISE 2.1. CREATING A PROJECTED BUDGET FOR A NEW PROGRAM Using the following information, create a projected budget for a new program, the After- School Girls Program, for twenty students at the Sojourner Truth Settlement House. Work with others in your class. Assumptions: 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