Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Authentication
digital resources
172x Filetype XLSX File size 0.04 MB Source: www.aphis.usda.gov
Sheet 1: Cooperator Instructions
| Cooperator Instructions for Completing the Worksheet | |||
| Please enter the lead investigator's name, name of cooperative institution, and the project title beginning in cells A2 through C2 of this Excel sheet. | |||
| An example of a filled-in table is provided on the "Example" tab. | |||
| When populating the budget table, please be as detailed in the narrative as possible, ensure sub totals add up to the total budget amount, and list both domestic and international travel. | |||
| To insert additional rows, right-click on the row desired to expand and select "Insert" from the list. | |||
| Choose a row normally used for data entry, not a row containing a subtotal calculation. This ensures preservation of the Excel formula. |
|||
| Always double check calculations when the table is completed, even if the formulas are correct. | |||
| The table below provides instructions to guide the lead investigator when preparing the budget table located on the "Worksheet" tab. | |||
| ITEM | ITEM DETAILS | NARRATIVE | AMOUNT |
| Salary | List title and how much time each position will contribute to the agreement. | Briefly describe the role of each personnel need for this project. | |
| Salary Total ($) = | $0 | ||
| Benefits | List benefits as a percentage of salary. | ||
| Benefits Total ($) = | $0 | ||
| Equipment | List equipment that will be purchased to perform the work. Include major items with a value of $5,000 or more. Items you would identify as equipment but have a value of less than $5,000 should be listed under supplies. Identify all information technology equipment, e.g., computers (considered supplies if under $5000), and their ancillary components, regardless of value. | Briefly describe why the equipment is needed to support this project. This narrative should clearly link to the methods section. | |
| Equipment Total ($) = | $0 | ||
| Supplies | Identify supplies needed for this project. Computers are considered supplies if they are under $5000. | Briefly describe why the supplies are needed to support this project. This narrative should clearly link to the methods section. | |
| Supplies Total ($) = | $0 | ||
| Travel | All expected travel required to conduct/support this project must be listed in detail. This would include local travel to work sites and extended overnight travel. Estimated Cost: We understand the exact cost cannot always be provided at the time the work plan is finalized. Please provide the best estimate you can currently provide. **Foreign travel must be listed separately from domestic travel** |
Clearly explain how the requested travel directly supports this project. If you are requesting travel to conferences/meetings, you MUST clearly explain how it benefits the project/PPQ/stakeholders. If you are requesting multiple people to attend any conference/meetings, you MUST explain the benefit of sending each person. Foreign Travel: Foreign travel will only be authorized if necessary to meet the objectives of the award. Any foreign travel not included in this table will not be authorized without prior approval. All international travel must be justified in the following format: Purpose: Provide a purpose statement that explains why the travel is necessary to meet the objectives of the award. If you are requesting travel to conferences/meetings, you MUST clearly explain how it benefits the project/PPQ/stakeholders. Destination: Provide planned destination of travel. |
|
| Domestic Travel: MUST include a cost breakdown of the estimated cost of the travel for each planned trip. Transportation cost: Airfare and and/or mileage. Lodging: (Number of nights in each location and cost per night) Meals and Incidental Cost: (Per day MI&E cost) Other: (Other costs not outlined above) |
|||
| International Travel: MUST include a cost breakdown of the estimated cost of the travel for each planned trip. Transportation cost: (Airfare and in country cost) Lodging: (number of nights in each location and cost per night) Meals and Incidental Cost: (Per day M&IE cost) Other: (Other costs not outlined above) |
|||
| Travel Total ($) | $0 | ||
| Contracts or Sub awards | List any plans for contracts or sub-agreements. Do not list contractors by name unless the cooperator has already successfully bid for the work or they are the sole source. You will need to provide justification. | Briefly explain how the contract or sub-agreement will be used in this agreement. | |
| Contracts/Sub awards Total ($) | $0 | ||
| Other | List any other resources needed for this project not included in the above categories | Briefly explain why each specified resource is needed to support this project. | |
| Contracts/Sub awards Total ($) | $0 | ||
| Total direct costs | $0 | ||
| Enter percentage of indirect cost | 15.0% | ||
| Total Budget | $0 |
| NAME | INSTITUTION | PROJECT TITLE | |
| APHIS PPQ S&T | Bad Bug Survey Tool development | ||
| ITEM | ITEM DETAILS | NARRATIVE | AMOUNT |
| Salary | Principal Investigator (0.2 FTE) | Lead the program execution, oversee the testing of the Survey Tool, and oversee the scientific analysis behind the Survey Tool research and development. Work with APHIS employees to design and execute the field studies. Document and prepare all reports. | $42,301 |
| Staff Scientist (1.0 FT) | Primarily responsible for carrying out the survey tool testing and data collection throughout the project. | $61,000 | |
| Project Manager (0.1 FT) | Primarily responsible for managing sub-contract and all financial paperwork and adhering to reporting deadlines. | $9,237 | |
| Salary Total | $112,538 | ||
| Benefits | Principal Investigator (0.2 FTE) | Benefits as 30% of salary | $12,690 |
| Staff Scientist (1.0 FT) | $18,300 | ||
| Project Manager (0.1 FT) | $2,771 | ||
| Benefits Total | 33761.4 | ||
| Equipment | Survey Tool operating system package | Purchasing the operating system package is necessary to program the Survey Tool. | $15,050 |
| Printer | Purchase of a printer is necessary to print out navigation maps that can be brought into the field during the testing phase. | $250 | |
| Equipment Total | 15300 | ||
| Supplies | Lures, traps, seniors, framing material, samples bags | Supplies are needed to build Survey Tool and carry out the field testing. | $4,000 |
| Supplies Total | 4000 | ||
| Travel | Domestic Travel: 4 trips to field site to test Survey Tool for 2 people (PI and Staff Scientist) (Cost per 1 person per trip = $Airfare: $350; 2 night hotel: $200; 2 days of per diem: $120) |
The first 2 trips are required to test the Survey Tool in the field to carry out objective 1. The second 2 trips are needed to develop and test the field kit to carry out objective 2. | $5,360 |
| International Travel: 1 trip to attend Survey Tool conference in Italy for 1 person (PI) (Cost per 1 trip = Airfare: $2,500; 4 nights hotel: $800; 4 days of per diem: $240) |
Purpose: Attending the Survey Tool conference supports this project in the following ways: 1) Symposium will discuss methods for building and employing similar Survey Tools. The information gained from attending these sessions could improve our Survey Tool design. Specifically we will be meeting with a group of collaborators to discuss programming designs to optimize our approach. 2) We will present our findings at this meeting to obtain feedback from the larger community on how we can improve the project. Destination: Sicily, Italy |
$3,540 | |
| Travel Total | $8,900 | ||
| Contracts or Sub awards | Contract for sensors | A contract will be executed to develop the sensors for the Survey Tool. | $5,000 |
| Total for Contracts or Sub awards | $5,000 | ||
| Other | Rent | Cooperator personnel supporting this project and some computer equipment requiring secure accommodations in offices off-campus. | $5,240 |
| Total, Other | $5,240 | ||
| Total direct costs | $184,739 | ||
| Enter percentage of indirect cost | 10.0% | ||
| Total Budget | $203,213 |
| NAME | INSTITUTION | PROJECT TITLE | |
| Lead Investigator | Name of Institution | Enter project title | |
| ITEM | ITEM DETAILS | NARRATIVE | AMOUNT |
| Salary | |||
| Salary Total | 0 | ||
| Benefits | |||
| Benefits Total | 0 | ||
| Equipment | |||
| Equipment Total | 0 | ||
| Supplies | |||
| Supplies Total | 0 | ||
| Travel | |||
| Travel Total | 0 | ||
| Contracts or Sub awards | |||
| Total for Contracts or Sub awards | 0 | ||
| Other | |||
| Total, Other | 0 | ||
| Total direct costs | $0 | ||
| *Enter percentage of indirect cost | 0.000% | ||
| Total Indirect Costs | $0 | ||
| Total Budget | $0 | ||
| *For PPA-7721 cooperative agreements - enter 17.647 to calculate indirect costs as 15% of total award; or enter NICRA if lower | |||
| Budget Summary Table | |||
| Total Main Program | |||
| Total Crop Governance Admin (if applicable) | |||
| Total Outreach (if applicable) | |||
| TOTAL AGREEMENT BUDGET | $0 |
no reviews yet
Please Login to review.
