The file's text, extracted by GovTribe without its formatting.
Budget Worksheet
| ATTACHMENT A | | |
| Agency: | NPS | INSTRUCTIONS: Only change the highlighted cells. First complete the cells highlighted in yellow followed by the cells highlighted in green. Completing the green |
| Recipient: | | cells involves breaking down the total project budget into the NPS and recipient funded items. The "Total Check" at the bottom of the worksheet will be 0 once |
| Title: | | all Total Project Budget dollars have been properly allocated to either NPS or the Recipient. The indirect cost rate used must be either 1) the negotiated rate with |
| Agreement #: | | the cognizant agency or 2) certified in writing by the recipients independent auditor and applied to the NPS funded costs only (also note - indirect costs are |
| Period: | FY10 | not cost share eligible). If the recipient is not able to obtain an indirect cost rate as detailed, all costs must be detailed as direct. |
| Personnel | | | Unit of Time | Qty | Cost Per Unit of Time | Total Project Budget | NPS Funded Amount | Recipient Funded Amount | COMMENTS: |
| Qty of Position | Position Description | (hour, day, week, month, % of salary, etc) | (of hours, days, weeks, months, % of salary, etc. | | | | | |
| | Position Description #1 | | | | - 0 | | | |
| | Position Description #2 | | | | - 0 | | | |
| | Position Description #3 | | | | - 0 | | | |
| | Position Description #4 | | | | - 0 | | | |
| | Position Description #5 | | | | - 0 | | | |
| | Position Description #6 | | | | - 0 | | | |
| | Position Description #7 | | | | - 0 | | | |
| | | | | Subtotal Salaries | - 0 | - 0 | - 0 | |
| Benefits | | | % of Compensation | | | | |
| 0 | Position Description #1 | | | - 0 | | |
| 0 | Position Description #2 | | | - 0 | | |
| 0 | Position Description #3 | | | - 0 | | |
| 0 | Position Description #4 | | | - 0 | | |
| 0 | Position Description #5 | | | - 0 | | |
| 0 | Position Description #6 | | | - 0 | | |
| 0 | Position Description #7 | | | - 0 | | |
| | | | Subtotal Benefits | - 0 | - 0 | - 0 |
Subtotal Personnel - 0 - 0 - 0
| | Qty | Cost Per | | | |
| Equipment (over $5k & useful life of more than 1 yr) | | | | | | |
| Equipment 1 Description | | | - 0 | | |
| Equipment 2 Description | | | - 0 | | |
| Equipment 3 Description | | | - 0 | | |
| | | Subtotal Equipment | - 0 | - 0 | - 0 |
| Supplies | | Qty | Cost Per | | | |
| Supply 1 Description | | | - 0 | | |
| Supply 2 Description | | | - 0 | | |
| Supply 3 Description | | | - 0 | | |
| Supply 4 Description | | | - 0 | | |
| | | Subtotal Supplies | - 0 | - 0 | - 0 |
| Travel | | Unit of Measure | Qty | Cost Per | | | |
| Airfare | trips | | | - 0 | | |
| Lodging | days | | | - 0 | | |
| Per Diem | days | | | - 0 | | |
| Per Diem (first & last day @ 75% rate) | days | | | - 0 | | |
| Ground Transportation | days or mileage | | | - 0 | | |
| Housing Stipend | month | | | - 0 | | |
| Transportation Stipend | week | | | - 0 | | |
| | | | Subtotal Travel | - 0 | - 0 | - 0 |
| Other | | Qty | Cost Per | | | |
| Other 1 Description | | | - 0 | | |
| Other 2 Description | | | - 0 | | |
| Other 3 Description | | | - 0 | | |
| Other 4 Description | | | - 0 | | |
| Other 5 Description | | | - 0 | | |
| Other 6 Description | | | - 0 | | |
| Other 7 Description | | | - 0 | | |
| Other 8 Description | | | - 0 | | |
| Other 9 Description | | | - 0 | | |
| Other 10 Description | | | - 0 | | |
| | | Subtotal Other | - 0 | - 0 | - 0 |
| Contractual | | Unit of Time | Qty | Cost Per | | | |
| Subcontract/Subaward 1 Descrip | | | | - 0 | | |
| Subcontract/Subaward 2 Descrip | | | | - 0 | | |
| Subcontract/Subaward 3 Descrip | | | | - 0 | | |
| | | | Total Subcontract | - 0 | - 0 | - 0 |
Total Direct Costs - 0 - 0 - 0
| Indirect Costs | | | | |
| of NPS Funded Direct Costs | - 0 | - 0 | - 0 |
Total Costs - 0 - 0 - 0
| Complete these cells as appropriate | | |
| Once yellow cells are completed, manually account for total project budget in NPS and recipient columns | | |
| as well as In-Kind Cost Share below | Total Check (s/b 0) | 0.00 |
| Cost Share Check | ERROR:#DIV/0! |
| ICR Calc Check | ERROR:#DIV/0! |
In-Kind Cost Share
| Description | Source | # of Units | Value Per Unit* | Total |
| | | | 0.00 |
| | | | 0.00 |
| | | | 0.00 |
| | | | 0.00 |
| | | | 0.00 |
| | | | 0.00 |
| | | | 0.00 |
| | | | 0.00 |
| | | | 0.00 |
| | | | 0.00 |
| TOTAL | | | | 0.00 |
| Total NPS Funded | Total Recipient Funded (including In-Kind) | Total Agreement Amount |
| Total Agreement | - 0 | - 0 | 0.00 |
* The value of a volunteer hour can be based the latest data from independentsector.org
&f &d &t
Budget Worksheet Example
| ATTACHMENT A | | |
| Agency: | NPS | INSTRUCTIONS: Only change the highlighted cells. First complete the cells highlighted in yellow followed by the cells highlighted in green. Completing the green |
| Recipient: | Non-Profit X | cells involves breaking down the total project budget into the NPS and recipient funded items. The "Total Check" at the bottom of the worksheet will be 0 once |
| Title: | Project Y | all Total Project Budget dollars have been properly allocated to either NPS or the Recipient. The indirect cost rate used must be either 1) the negotiated rate with |
| Agreement #: | J########## | the cognizant agency or 2) certified in writing by the recipients independent auditor and applied to the NPS funded costs only (also note - indirect costs are |
| Period: | FY10 | not cost share eligible). If the recipient is not able to obtain an indirect cost rate as detailed, all costs must be detailed as direct. |
| Personnel | | | Unit of Time | Qty | Cost Per Unit of Time | Total Project Budget | NPS Funded Amount | Recipient Funded Amount | COMMENTS: |
| Qty of Position | Position Description | (hour, day, week, month, % of salary, etc) | (of hours, days, weeks, months, % of salary, etc. | | | | | |
| 1 | Crew Leader | week | 8.00 | 750.00 | 6,000.00 | 6,000.00 | | |
| 2 | Assistant Crew Leader | week | 8.00 | 600.00 | 9,600.00 | 9,600.00 | | |
| 10 | Crew Members | hour | 320.00 | 10.00 | 32,000.00 | 32,000.00 | | volunteers recruited by recipient |
| 1 | Project Manager | % of salary | 0.17 | 50,000.00 | 8,333.33 | 8,333.33 | | |
| | Position Description #5 | | | | - 0 | | | |
| | Position Description #6 | | | | - 0 | | | |
| | Position Description #7 | | | | - 0 | | | |
| | | | | Subtotal Salaries | 55,933.33 | 55,933.33 | - 0 | |
| Benefits | | | % of Compensation | | | | | |
| 1 | Crew Leader | 20% | | 1,200.00 | 1,200.00 | | |
| 2 | Assistant Crew Leader | 20% | | 1,920.00 | 1,920.00 | | |
| 10 | Crew Members | 0% | | - 0 | - 0 | | crew will not receive benefits |
| 1 | Project Manager | 20% | | 1,666.67 | 1,666.67 | | |
| 0 | Position Description #5 | | | - 0 | | | |
| 0 | Position Description #6 | | | - 0 | | | |
| 0 | Position Description #7 | | | - 0 | | | |
| | | | Subtotal Benefits | 4,786.67 | 4,786.67 | - 0 | |
Subtotal Personnel 60,720.00 60,720.00 - 0
| | Qty | Cost Per | | | |
| Equipment (over $5k & useful life of more than 1 yr) | | | | | | |
| Computer Server | 1.00 | 6,000.00 | 6,000.00 | 6,000.00 | |
| Equipment 2 Description | | | - 0 | | |
| Equipment 3 Description | | | - 0 | | |
| | | Subtotal Equipment | 6,000.00 | 6,000.00 | - 0 |
| Supplies | | Qty | Cost Per | | | |
| gloves | 13.00 | 5.00 | 65.00 | | 65.00 |
| shovels | 13.00 | 10.00 | 130.00 | 65.00 | 65.00 |
| Supply 3 Description | | | - 0 | | |
| Supply 4 Description | | | - 0 | | |
| | | Subtotal Supplies | 195.00 | 65.00 | 130.00 |
| Travel | | Unit of Measure | Qty | Cost Per | | | | |
| Airfare | trips | 13.00 | 650.00 | 8,450.00 | 8,450.00 | | round trips to and from site |
| Lodging | days | 26.00 | 50.00 | 1,300.00 | 1,300.00 | | 1 night stay to and from site |
| Per Diem | days | | | - 0 | | | |
| Per Diem (first & last day @ 75% rate) | days | | | - 0 | | | |
| Ground Transportation | days or mileage | 1,300.00 | 0.50 | 650.00 | 650.00 | | mileage to and from airport to site |
| Housing Stipend | month | | | - 0 | | | |
| Transportation Stipend | week | | | - 0 | | | |
| | | | Subtotal Travel | 10,400.00 | 10,400.00 | - 0 | |
| Other | | Qty | Cost Per | | | | |
| Printing | 13.00 | 25.00 | 325.00 | | 325.00 | printing of training manuals |
| Other 2 Description | | | - 0 | | | |
| Other 3 Description | | | - 0 | | | |
| Other 4 Description | | | - 0 | | | |
| Other 5 Description | | | - 0 | | | |
| Other 6 Description | | | - 0 | | | |
| Other 7 Description | | | - 0 | | | |
| Other 8 Description | | | - 0 | | | |
| Other 9 Description | | | - 0 | | | |
| Other 10 Description | | | - 0 | | | |
| | | Subtotal Other | 325.00 | - 0 | 325.00 | |
| Contractual | | Unit of Time | Qty | Cost Per | | | | |
| Speaker | hour | 4.00 | 150.00 | 600.00 | 300.00 | 300.00 | speaker for day one training/orientation |
| Subcontract/Subaward 2 Descrip | | | | - 0 | | | |
| Subcontract/Subaward 3 Descrip | | | | - 0 | | | |
| | | | Total Subcontract | 600.00 | 300.00 | 300.00 | |
Total Direct Costs 78,240.00 77,485.00 755.00
| Indirect Costs | | | | | |
| 28.30% | of NPS Funded Total Direct Cost | 21,928.25 | 21,928.25 | - 0 |
Total Costs 100,168.26 99,413.26 755.00
| Complete these cells as appropriate | | |
| Once yellow cells are completed, manually account for total project budget in NPS and recipient columns | | |
| as well as In-Kind Cost Share below | Total Check (s/b 0) | 0.00 |
| Cost Share Check | 40.43% |
| ICR Calc Check | 28.30% |
In-Kind Cost Share
| Description | Source | # of Units | Value Per Unit* | Total |
| Volunteer Hours | recipient | 3,200 | 20.85 | 66,720.00 |
| | | | 0.00 |
| | | | 0.00 |
| | | | 0.00 |
| | | | 0.00 |
| | | | 0.00 |
| | | | 0.00 |
| | | | 0.00 |
| | | | 0.00 |
| | | | 0.00 |
| TOTAL | | | | 66,720.00 |
| Total NPS Funded | Total Recipient Funded (including In-Kind) | Total Agreement Amount |
| Total Agreement | 99,413.26 | 67,475.00 | 166,888.26 |
* The value of a volunteer hour can be based the latest data from independentsector.org
&f &d &t
