Congratulations. Our organization was awarded a grant for a total of $200,000 on November 1, 2020. This grant can pay for costs associated with our Education program including much needed supplies for students, computer equipment for a new computer lab and will allow for 10% of indirect costs. Given the following information, please complete the tasks below. Fiscal Year: July 1, 2020 through June 30, 2021 . Staff: Marty Manager has a salary of $52,000. He does not participate in the agency's health and dental plan. A portion of his salary is also covered (25%) in the Employment program. Emily Employee has a salary of $35,000. She participates in the agency's health and dental plan with family coverage. A portion of her salary is also covered (50%) in the Health program A new employee (John Jobseeker) will be hired to work on this grant. The job has not been posted, but we expect the employee to be hired at a salary range between $30,0000 to $35,000 Fringe Benefits: The agency offers Single coverage at a cost to the employee of $200 per month and Family Coverage at $400 per month. This includes health and dental. The agency pays 70% of the cost. All other employment taxes can be included as fringe benefits. . Fixed costs: Rent - $2,000 per month . Utilities - $500 per month Telecommunications - $250 per month Please complete the following: 1. Using Microsoft Excel, please create a budget for the amount awarded. Use the information provided and list any assumptions made based on information that may not be provided. 2. Your budget has been approved by the funder and it is time to submit your first voucher (request for reimbursement). What documentation would you gather to submit with your expenses? 3. It is now January 1, 2021 and it doesn't look like Marty Manager has hired John Jobseeker and you are in danger of not meeting your budget. Write a short narrative giving your recommendation to Marty Manager on what he should do to ensure that we are able to spend the entire budget for the fiscal year. Congratulations. Our organization was awarded a grant for a total of $200,000 on November 1, 2020. This grant can pay for costs associated with our Education program including much needed supplies for students, computer equipment for a new computer lab and will allow for 10% of indirect costs. Given the following information, please complete the tasks below. Fiscal Year: July 1, 2020 through June 30, 2021 . Staff: Marty Manager has a salary of $52,000. He does not participate in the agency's health and dental plan. A portion of his salary is also covered (25%) in the Employment program. Emily Employee has a salary of $35,000. She participates in the agency's health and dental plan with family coverage. A portion of her salary is also covered (50%) in the Health program A new employee (John Jobseeker) will be hired to work on this grant. The job has not been posted, but we expect the employee to be hired at a salary range between $30,0000 to $35,000 Fringe Benefits: The agency offers Single coverage at a cost to the employee of $200 per month and Family Coverage at $400 per month. This includes health and dental. The agency pays 70% of the cost. All other employment taxes can be included as fringe benefits. . Fixed costs: Rent - $2,000 per month . Utilities - $500 per month Telecommunications - $250 per month Please complete the following: 1. Using Microsoft Excel, please create a budget for the amount awarded. Use the information provided and list any assumptions made based on information that may not be provided. 2. Your budget has been approved by the funder and it is time to submit your first voucher (request for reimbursement). What documentation would you gather to submit with your expenses? 3. It is now January 1, 2021 and it doesn't look like Marty Manager has hired John Jobseeker and you are in danger of not meeting your budget. Write a short narrative giving your recommendation to Marty Manager on what he should do to ensure that we are able to spend the entire budget for the fiscal year
