jagomart
digital resources
picture1_Budget List Template 40931 | Ncpn Budget Spreadsheet Template


 170x       Filetype XLSX       File size 0.04 MB       Source: www.aphis.usda.gov


File: Budget List Template 40931 | Ncpn Budget Spreadsheet Template
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 ...

icon picture XLSX Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Partial file snippet.
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

Sheet 2: Example
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

Sheet 3: Main Program
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

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet cooperator instructions for completing the worksheet please enter lead investigator s name of cooperative institution and project title beginning in cells a through c this excel an example filledin table is provided on quot tab when populating budget be as detailed narrative possible ensure sub totals add up to total amount list both domestic international travel insert additional rows rightclick row desired expand select from choose normally used data entry not containing subtotal calculation ensures preservation formula always double check calculations completed even if formulas are correct below provides guide preparing located item details salary how much time each position will contribute agreement briefly describe role personnel need benefits percentage equipment that purchased perform work include major items with value or more you would identify but have less than should listed under supplies all information technology eg computers considered their ancillary components re...

no reviews yet
Please Login to review.