Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Any. I have to create it. so it doesn't matter. are you referring to employees, desks, furniture etc? Case Study 5: Adjusting the Budget Agency

image text in transcribed
image text in transcribed
image text in transcribed
Any. I have to create it. so it doesn't matter.
are you referring to employees, desks, furniture etc?
Case Study 5: Adjusting the Budget Agency X has been doing well financially but wants to provide more services to its clientele. They recently applied for a grant from The New England Health Foundation (NEHF) for $1,000,000 to provide these services. The Foundation has indicated that they are interested in funding AX but can only provide $850,000 of the requested funds. The want a full description of the service that will be provided and how the funds will be allocated both in terms of Personnel and Other than Personnel Services (OTP). They are requesting a detailed budget with a budget narrative by the end of the work week. NEHF has heard that there has been some mismanagement at the agency and some of the foundation's board are not assured that the money will be spent appropriately. To be sure of the veracity of Agency X in getting this money, they want to see the original budget along with an updated line by line budget showing where Agency X will get the additional $150,000 to cover the cost that the Foundation will not pay for. Assignment The type of services to be provided will be up to you, the department manager. Who your collaborators are (if any), where you get the other funding, and how you structure your program will be up to you. Be creative. You should do some research on approximate cost of items in your budget to make the budget as realistic as possible. Attach or refer to cite on a reference page) anything you used to justify your costs (e.g., Office Max for cost of a desk, Toyota Leasing for a leased vehicle, Progressive for car insurance, etc.). Some things can be estimated (e.g.. how much office supplies you will use for the year). Use the Excel spreadsheet to do your budget and narrative. The headings on the spreadsheet are suggestions, with the exception of NEHF, who are the funders for this grant. Make sure you have a narrative that does the math to show how you arrived at your cost for every item even in-kind costs. The A&G for the fiduciary's administrative cost is a fixed cost set at 10% of the budget. Check the Bureau of Labor Statistics for average salaries by industry. I need help creating a program using the budget of 850,000 using the info provided in the first picture. I have to fill in the excel spread shown in the picture | provided. I have to include how many workers would need and the cost? cost of travel and etc. below is an example of what the excel would look like. With a couple definitions. Item Funders (Sources of Revenue) Private In-Kind Medicaid Federal Grants Foundations FFS Total Budget Salary/Fringe 202,500 Personnel Services 34,476 Other than Personnel Services (OTPS) 31,000 93,000 236,976 124,000 84,500 193,531 100,000 30,000 90,000 100,000 50,000 200,000 80,000 35,000 Advocacy Education Serv. Marketing Family Group Mentoring Psych/Therapy Evaluation Mini Grants Audit Meetings Travel Rent Phones Supplies Postage A&G (Admin) Total Cost 11,000 278,031 100,000 120,000 100,000 50,000 280,000 35,000 11,000 15,000 28,000 15,000 4,000 9,000 3,000 80,000 $1.489.007 15,000 20,000 8,000 15,000 4,000 9,000 1,000 80,000 855.000 2,000 265.476 93.000 273.531 Case Study 5: Adjusting the Budget Agency X has been doing well financially but wants to provide more services to its clientele. They recently applied for a grant from The New England Health Foundation (NEHF) for $1,000,000 to provide these services. The Foundation has indicated that they are interested in funding AX but can only provide $850,000 of the requested funds. The want a full description of the service that will be provided and how the funds will be allocated both in terms of Personnel and Other than Personnel Services (OTP). They are requesting a detailed budget with a budget narrative by the end of the work week. NEHF has heard that there has been some mismanagement at the agency and some of the foundation's board are not assured that the money will be spent appropriately. To be sure of the veracity of Agency X in getting this money, they want to see the original budget along with an updated line by line budget showing where Agency X will get the additional $150,000 to cover the cost that the Foundation will not pay for. Assignment The type of services to be provided will be up to you, the department manager. Who your collaborators are (if any), where you get the other funding, and how you structure your program will be up to you. Be creative. You should do some research on approximate cost of items in your budget to make the budget as realistic as possible. Attach or refer to cite on a reference page) anything you used to justify your costs (e.g., Office Max for cost of a desk, Toyota Leasing for a leased vehicle, Progressive for car insurance, etc.). Some things can be estimated (e.g.. how much office supplies you will use for the year). Use the Excel spreadsheet to do your budget and narrative. The headings on the spreadsheet are suggestions, with the exception of NEHF, who are the funders for this grant. Make sure you have a narrative that does the math to show how you arrived at your cost for every item even in-kind costs. The A&G for the fiduciary's administrative cost is a fixed cost set at 10% of the budget. Check the Bureau of Labor Statistics for average salaries by industry. I need help creating a program using the budget of 850,000 using the info provided in the first picture. I have to fill in the excel spread shown in the picture | provided. I have to include how many workers would need and the cost? cost of travel and etc. below is an example of what the excel would look like. With a couple definitions. Item Funders (Sources of Revenue) Private In-Kind Medicaid Federal Grants Foundations FFS Total Budget Salary/Fringe 202,500 Personnel Services 34,476 Other than Personnel Services (OTPS) 31,000 93,000 236,976 124,000 84,500 193,531 100,000 30,000 90,000 100,000 50,000 200,000 80,000 35,000 Advocacy Education Serv. Marketing Family Group Mentoring Psych/Therapy Evaluation Mini Grants Audit Meetings Travel Rent Phones Supplies Postage A&G (Admin) Total Cost 11,000 278,031 100,000 120,000 100,000 50,000 280,000 35,000 11,000 15,000 28,000 15,000 4,000 9,000 3,000 80,000 $1.489.007 15,000 20,000 8,000 15,000 4,000 9,000 1,000 80,000 855.000 2,000 265.476 93.000 273.531

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Dividend Policy On Share Price Volatility In Indian Stock Market

Authors: Vijay Deswal

1st Edition

3841859623, 978-3841859624

More Books

Students also viewed these Finance questions

Question

How is IMC involved in creating social meaning for a brand?

Answered: 1 week ago