creat a program with the budget given below and fill in the excel.
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 they also need to see a budget for 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, 5. Adjusting the Budget Excel Sheet (3) - Excel View Tell me what you want to do Wrap Test Merge & Center - Number 1 DE X Copy * $ - % . Conditional Formatas Cell Formatting Table Styles - Styles Insert Delete Format - - - Alignment Number File Home Insert Page Layout Formulas Data Review a Xcut Calibri 11 AA === . Format Painter BIU. . . A Clipboard Font 15 - X for 80,000 1A B C D E F Budget Items Income Sources Original Revised Federal Budget Budget NEHF (specify) City G H I J Budget Narrative State In kind Third- Party Other Totals The indirectadministrative overhead associated with fiducia managing of funds is calculated at 10% set by the New Englan Health Foundation NEHF A&G @10% 80,000 Total Orignal Total Revised a include the estimated cost of in kind supports and give basis of estimation 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 they also need to see a budget for 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, 5. Adjusting the Budget Excel Sheet (3) - Excel View Tell me what you want to do Wrap Test Merge & Center - Number 1 DE X Copy * $ - % . Conditional Formatas Cell Formatting Table Styles - Styles Insert Delete Format - - - Alignment Number File Home Insert Page Layout Formulas Data Review a Xcut Calibri 11 AA === . Format Painter BIU. . . A Clipboard Font 15 - X for 80,000 1A B C D E F Budget Items Income Sources Original Revised Federal Budget Budget NEHF (specify) City G H I J Budget Narrative State In kind Third- Party Other Totals The indirectadministrative overhead associated with fiducia managing of funds is calculated at 10% set by the New Englan Health Foundation NEHF A&G @10% 80,000 Total Orignal Total Revised a include the estimated cost of in kind supports and give basis of estimation
