An external sponsor awarded the attached NOA $($Notice of Award$)$ to the Research Foundation on behalf of one of the colleges that comprises the City University of New York. As an Assistant Project Administrator, you are assigned to perform the following task:

Enter the approved budget in the excel spreadsheet provided. Complete any other information. This award has been assigned $41847-0002$ as the new RF Project #$.$

Post the following expenses to their respective categories in the current reporting period; April $2014$ and using excel formulae, perform the various calculations as needed $($including sub$-$totals and totals$).$ Complete all other columns accordingly.

a$.$ PI charged Released Time Salary of $$10,000$ and associated Fringe Benefit at $33\%.$

b$.$ Summer salary is allocated at $$7000$ plus fringe benefits @ $28\mathrm{.}9\%$

c$.$ Research Assistants' costs are $$50,000$ with fringe benefits at $38\%.$

d$.$ Equipment total $$25,000$; Travel to Albuquerque, New Mexico; $$4000$; Stipends for $10$ students @$$1000/$month each; Tuition for the same number of students at a rate of $$600$ each; Subcontract to Arizona State University $$50,000.$

e$.$ Calculate the Facilities and Administrative costs $($F&A $-$ also called Indirect or Overhead costs$)$ at $53\%$ of Modified Total Direct Costs $($MTDC$).$ Note MTDC excludes the following cost items:

a$.$ equipment,

b$.$ tuition,

c$.$ student support costs $($e$.$g$.$ student aid, stipends, scholarships, fellowship$),$

d$.$ that portion of each subcontract in excess of $$25,000.$

Part II

$($Letter must be professional and well developed. Be as creative as you wish$)$

Send an introductory letter to the PI as the RF Assistant Administrator who will be responsible along with your Project Administrator team member for post award management of the grant and offer congratulations on receipt of the new award. In addition, request further budget details concerning 'other salaries' and provide useful information regarding the terms and conditions of the award. $($Note$,$ the intent is to make a good impression about yourself and the Research Foundation$)$

Part III

Using data from the attached Trial Balance complete the invoice $($template on first tab$)$ for the current month.