Using the following information. create a projected budget for a ne...

  1. Home
  2. Homework Library
  3. Business
  4. Finance
  5. Using the following information. create a projected budget for a ne...

QuestionQuestion

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.

ASSIGNMENT SERVING SENIORS
You the executive 2.2 director of a social services nonprofit and have just been notified that you than one losing hundred seniors five days a week, in addition to pro- are are your funding for the Seniors Program. You serve viding lunch to them more with a program before the lunch is served. The program decide is exercise three days a week, and on the other days it is dancing. You to approach get a to attach to your grant proposal to the foundation, using following foundation to replace the funding you will be losing. Create a proposed the bud- information:
Revenue: Contributions, $122,200; in-kind services, $10,000; foundation, $130,000; and senior contributions, $1,250.
Expenses: 3 percent of the executive director's time @ $150,000; 5 percent of the program coordinator's time @ $100,000; one senior program director @ $50,000; and one senior program staff member @ $35,000. Fringe benefits are 20 percent of the PS. NPS consists of one hundred 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 fifty weeks at @ $25. The in-kind services are the kitchen for $10,000. Supplies are $10,000. The indirect cost is 10 percent.

Solution PreviewSolution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

    By purchasing this solution you'll be able to access the following files:
    Solution.xlsx.

    $48.00
    for this solution

    or FREE if you
    register a new account!

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Finance Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Decision:
    Upload a file
    Continue without uploading

    SUBMIT YOUR HOMEWORK
    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats