CPRG Implementation Grants Optional Budget_Table (1).xlsx
XLSX spreadsheet 78 KB Posted
- Attached to
- Climate Pollution Reduction Grants Program: Implementation Grants Competition for Tribes and Territories
- Opportunity number
- EPA-R-OAR-CPRGT-23-09
- Issued by
-
Environmental Protection Agency
About this file
This document package includes an Excel budget template and instructions for applicants to the Climate Pollution Reduction Grants Program: Implementation Grants Competition for Tribes and Territories federal grant opportunity.
The budget template contains multiple tabs for applicants to itemize costs across five discrete greenhouse gas reduction measures in their application. Instructions guide applicants on completing standardized budget tables for personnel, fringe benefits, travel, equipment, supplies, contractual services, and other direct and indirect costs for each measure over five years. A consolidated budget tab will automatically total costs. Sample budgets demonstrate how to populate the standardized tables for three hypothetical projects focusing on industrial energy efficiency, workforce development, and deployment of renewable energy and battery storage on tribal lands. If applicants have over five measures, they should add tabs and update consolidation formulas.
The related federal grant opportunity is solicited by the Environmental Protection Agency under the Climate Pollution Reduction Grants program. Tribes and territories can apply for implementation funding to reduce greenhouse gas emissions through projects such as energy efficiency, renewable energy, carbon sequestration and storage. The budget template aims to standardize cost reporting for these types of climate mitigation initiatives.
CPRG Implementation Grants Optional Budget Table
View the file
Other files
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Overview
Introduction:
This Excel Spreadsheet is provided to aid Climate Pollution Reduction Grant implementation grant applicants in developing the required budget table(s) within the budget narrative. Applicants may submit a budget spreadsheet (no page limit) with their application.
The individual worksheets are formatted for 1 page width of 8.5" x 11" landscape orientation.
Instructions:
The template contains 5 tabs (titled "Measure 1 Budget" through "Measure 5 Budget") where applicants can create budgets for up to 5 discrete GHG measures contained in their application. Applicants should leave excess tabs blank (ie, if an application is for a single GHG measure, only Tab 1 should contain any numerical entries.) The Consolidated Budget tab will automatically sum budget totals across all GHG measure Tabs. If an application includes more than 5 GHG measures, users may add duplicate tabs, but will need to manually update the formulas contained on the Consolidated Budget tab.
Measure Tab Instructions:
Below is a description of the steps an applicant should complete to finish each measure tab of the template.
- In column C, provide itemized costs descriptions in each cost category. Insert or delete rows as needed.
- In columns D through H, fill in the cost for the line item per year - personnel, fringe benefits, travel, equipment, installation, or labor supplies, contractual costs, and other direct costs (i.e., subawards, participant support costs), and indirect costs for each applicable year. Subtotals will calculate automatically.
- Column J will automatically calculate the total cost for the line item for the entire measure, including subtotals for each budget category - personnel, fringe benefits, travel, equipment, installation, or labor supplies, contractual costs, and other direct costs (i.e., subawards, participant support costs), and indirect costs.
Please check all formulas and calculations before finalizing your budget tables.
Consolidated Budget Instructions:
This table will update automatically based on the budget detail entered in the tabs for measures 1-5. If your application includes more than 5 individual measures, you will need to add additional tabs, update the formulas below, and add additional lines to the "Budget by Project" table to include the additional measures.
Consolidated Budget
| Consolidated Budget Table |
| This table will update automatically based on the budget detail entered in the tabs for measures 1-5. If your application includes more than 5 individual measures, you will need to add additional tabs, update the formulas below, and add additional lines to the "Budget by Project" table to include the additional measures. |
| BUDGET BY YEAR | |||||||
| COST-TYPE | CATEGORY | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | TOTAL |
| Direct Costs | TOTAL PERSONNEL | $0 | $0 | $0 | $0 | $0 | $0 |
| TOTAL FRINGE BENEFITS | $0 | $0 | $0 | $0 | $0 | $0 | |
| TOTAL TRAVEL | $0 | $0 | $0 | $0 | $0 | $0 | |
| TOTAL EQUIPMENT | $0 | $0 | $0 | $0 | $0 | $0 | |
| TOTAL SUPPLIES | $0 | $0 | $0 | $0 | $0 | $0 | |
| TOTAL CONTRACTUAL | $0 | $0 | $0 | $0 | $0 | $0 | |
| TOTAL OTHER | $0 | $0 | $0 | $0 | $0 | $0 | |
| TOTAL DIRECT | $0 | $0 | $0 | $0 | $0 | $0 |
TOTAL INDIRECT $0 $0 $0 $0 $0 0
TOTAL FUNDING $0 $0 $0 $0 $0 $0
| BUDGET BY PROJECT | |||
| Project Number | Project Name | Total Cost | % of Total |
| 1 | Name 1 | $0 | ERROR:#DIV/0! |
| 2 | Name 2 | $0 | ERROR:#DIV/0! |
| 3 | Name 3 | $0 | ERROR:#DIV/0! |
| 4 | Name 4 | $0 | ERROR:#DIV/0! |
| 5 | Name 5 | $0 | ERROR:#DIV/0! |
Total $0 ERROR:#DIV/0!
Measure 1 Budget
| Detailed Budget Table |
| This Excel Workbook is provided to aid applicants in developing the required budget table(s) within the budget narrative. |
| BUDGET BY YEAR | |||||||
| COST-TYPE | CATEGORY | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | TOTAL |
| Direct Costs | Personnel | ||||||
| $0 | |||||||
| $0 | |||||||
| $0 | |||||||
| TOTAL PERSONNEL | $0 | $0 | $0 | $0 | $0 | $0 | |
| Fringe Benefits | |||||||
| $0 | |||||||
| $0 | |||||||
| $0 | |||||||
| TOTAL FRINGE BENEFITS | $0 | $0 | $0 | $0 | $0 | $0 | |
| Travel | |||||||
| $0 | |||||||
| $0 | |||||||
| $0 | |||||||
| $0 | |||||||
| $0 | |||||||
| $0 | |||||||
| $0 | |||||||
| $0 | |||||||
| TOTAL TRAVEL | $0 | $0 | $0 | $0 | $0 | $0 | |
| Equipment | |||||||
| $0 | |||||||
| $0 | |||||||
| TOTAL EQUIPMENT | $0 | $0 | $0 | $0 | $0 | $0 | |
| Supplies | |||||||
| $0 | |||||||
| $0 | |||||||
| TOTAL SUPPLIES | $0 | $0 | $0 | $0 | $0 | $0 | |
| Contractual | |||||||
| $0 | |||||||
| $0 | |||||||
| $0 | |||||||
| $0 | |||||||
| TOTAL CONTRACTUAL | $0 | $0 | $0 | $0 | $0 | $0 | |
| OTHER | |||||||
| $0 | |||||||
| $0 | |||||||
| $0 | |||||||
| TOTAL OTHER | $0 | $0 | $0 | $0 | $0 | $0 | |
| TOTAL DIRECT | $0 | $0 | $0 | $0 | $0 | $0 |
| Indirect Costs | Indirect Costs | ||||||
| $0 | |||||||
| $0 | |||||||
| TOTAL INDIRECT | $0 | $0 | $0 | $0 | $0 | $0 |
TOTAL FUNDING $0 $0 $0 $0 $0 $0
Measure 2 Budget
| Detailed Budget Table |
| This Excel Workbook is provided to aid applicants in developing the required budget table(s) within the budget narrative. |
| BUDGET BY YEAR | ||||||||
| COST-TYPE | CATEGORY | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | TOTAL | |
| Direct Costs | Personnel | |||||||
| $450,000 | $0 | |||||||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL PERSONNEL | $0 | $0 | $0 | $0 | $0 | 450000 | $0 | |
| Fringe Benefits | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL FRINGE BENEFITS | $0 | $0 | $0 | $0 | $0 | 0 | $0 | |
| Travel | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| $2,000 | $0 | |||||||
| $250 | $0 | |||||||
| $2,250 | $0 | |||||||
| $1,243 | $0 | |||||||
| $225 | $0 | |||||||
| $400 | $0 | |||||||
| $1,638 | $0 | |||||||
| TOTAL TRAVEL | $0 | $0 | $0 | $0 | $0 | $0 | ||
| Equipment | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL EQUIPMENT | $0 | $0 | $0 | $0 | $0 | $0 | ||
| Supplies | ||||||||
| $5,000 | $0 | |||||||
| $0 | ||||||||
| TOTAL SUPPLIES | $0 | $0 | $0 | $0 | $0 | $0 | ||
| Contractual | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL CONTRACTUAL | $0 | $0 | $0 | $0 | $0 | $0 | ||
| OTHER | ||||||||
| $375,000 | $0 | |||||||
| $781,250 | $0 | |||||||
| $2,083,335 | $0 | |||||||
| $0 | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL OTHER | $0 | $0 | $0 | $0 | $0 | $0 | ||
| TOTAL DIRECT | $0 | $0 | $0 | $0 | $0 | $0 |
| Indirect Costs | Indirect Costs | ||||||
| $0 | |||||||
| $0 | |||||||
| TOTAL INDIRECT | $0 | $0 | $0 | $0 | $0 | $0 |
TOTAL FUNDING $0 $0 $0 $0 $0 0 $0
Measure 3 Budget
| Detailed Budget Table |
| This Excel Workbook is provided to aid applicants in developing the required budget table(s) within the budget narrative. |
| BUDGET BY YEAR | ||||||||
| COST-TYPE | CATEGORY | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | TOTAL | |
| Direct Costs | Personnel | |||||||
| $450,000 | $0 | |||||||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL PERSONNEL | $0 | $0 | $0 | $0 | $0 | 450000 | $0 | |
| Fringe Benefits | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL FRINGE BENEFITS | $0 | $0 | $0 | $0 | $0 | 0 | $0 | |
| Travel | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| $2,000 | $0 | |||||||
| $250 | $0 | |||||||
| $2,250 | $0 | |||||||
| $1,243 | $0 | |||||||
| $225 | $0 | |||||||
| $400 | $0 | |||||||
| $1,638 | $0 | |||||||
| TOTAL TRAVEL | $0 | $0 | $0 | $0 | $0 | $0 | ||
| Equipment | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL EQUIPMENT | $0 | $0 | $0 | $0 | $0 | $0 | ||
| Supplies | ||||||||
| $5,000 | $0 | |||||||
| $0 | ||||||||
| TOTAL SUPPLIES | $0 | $0 | $0 | $0 | $0 | $0 | ||
| Contractual | ||||||||
| $0 | ||||||||
| $22,500,000 | $0 | |||||||
| $75,000,000 | $0 | |||||||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL CONTRACTUAL | $0 | $0 | $0 | $0 | $0 | $0 | ||
| OTHER | ||||||||
| $375,000 | $0 | |||||||
| $781,250 | $0 | |||||||
| $2,083,335 | $0 | |||||||
| $0 | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL OTHER | $0 | $0 | $0 | $0 | $0 | $0 | ||
| TOTAL DIRECT | $0 | $0 | $0 | $0 | $0 | $0 |
| Indirect Costs | Indirect Costs | ||||||
| $0 | |||||||
| $0 | |||||||
| TOTAL INDIRECT | $0 | $0 | $0 | $0 | $0 | $0 |
TOTAL FUNDING $0 $0 $0 $0 $0 0 $0
Measure 4 Budget
| Detailed Budget Table |
| This Excel Workbook is provided to aid applicants in developing the required budget table(s) within the budget narrative. |
| BUDGET BY YEAR | ||||||||
| COST-TYPE | CATEGORY | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | TOTAL | |
| Direct Costs | Personnel | |||||||
| $450,000 | $0 | |||||||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL PERSONNEL | $0 | $0 | $0 | $0 | $0 | 450000 | $0 | |
| Fringe Benefits | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL FRINGE BENEFITS | $0 | $0 | $0 | $0 | $0 | 0 | $0 | |
| Travel | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| $2,000 | $0 | |||||||
| $250 | $0 | |||||||
| $2,250 | $0 | |||||||
| $1,243 | $0 | |||||||
| $225 | $0 | |||||||
| $400 | $0 | |||||||
| $1,638 | $0 | |||||||
| TOTAL TRAVEL | $0 | $0 | $0 | $0 | $0 | $0 | ||
| Equipment | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL EQUIPMENT | $0 | $0 | $0 | $0 | $0 | $0 | ||
| Supplies | ||||||||
| $5,000 | $0 | |||||||
| $0 | ||||||||
| TOTAL SUPPLIES | $0 | $0 | $0 | $0 | $0 | $0 | ||
| Contractual | ||||||||
| $5,106,000 | $0 | |||||||
| $22,500,000 | $0 | |||||||
| $75,000,000 | $0 | |||||||
| $0 | ||||||||
| TOTAL CONTRACTUAL | $0 | $0 | $0 | $0 | $0 | $0 | ||
| Other | ||||||||
| $375,000 | $0 | |||||||
| $781,250 | $0 | |||||||
| $2,083,335 | $0 | |||||||
| $0 | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL OTHER | $0 | $0 | $0 | $0 | $0 | $0 | ||
| TOTAL DIRECT | $0 | $0 | $0 | $0 | $0 | $0 |
| Indirect Costs | Indirect Costs | ||||||
| $0 | |||||||
| $0 | |||||||
| TOTAL INDIRECT | $0 | $0 | $0 | $0 | $0 | $0 |
TOTAL FUNDING $0 $0 $0 $0 $0 0 $0
Measure 5 Budget
| Detailed Budget Table |
| This Excel Workbook is provided to aid applicants in developing the required budget table(s) within the budget narrative. |
| BUDGET BY YEAR | ||||||||
| COST-TYPE | CATEGORY | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | TOTAL | |
| Direct Costs | Personnel | |||||||
| $450,000 | $0 | |||||||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL PERSONNEL | $0 | $0 | $0 | $0 | $0 | 450000 | $0 | |
| Fringe Benefits | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL FRINGE BENEFITS | $0 | $0 | $0 | $0 | $0 | 0 | $0 | |
| Travel | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| $2,000 | $0 | |||||||
| $250 | $0 | |||||||
| $2,250 | $0 | |||||||
| $1,243 | $0 | |||||||
| $225 | $0 | |||||||
| $400 | $0 | |||||||
| $1,638 | $0 | |||||||
| TOTAL TRAVEL | $0 | $0 | $0 | $0 | $0 | $0 | ||
| Equipment | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL EQUIPMENT | $0 | $0 | $0 | $0 | $0 | $0 | ||
| Supplies | ||||||||
| $5,000 | $0 | |||||||
| $0 | ||||||||
| TOTAL SUPPLIES | $0 | $0 | $0 | $0 | $0 | $0 | ||
| Contractual | ||||||||
| $5,106,000 | $0 | |||||||
| $22,500,000 | $0 | |||||||
| $75,000,000 | $0 | |||||||
| $0 | ||||||||
| TOTAL CONTRACTUAL | $0 | $0 | $0 | $0 | $0 | $0 | ||
| OTHER | ||||||||
| $375,000 | $0 | |||||||
| $781,250 | $0 | |||||||
| $2,083,335 | $0 | |||||||
| $0 | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL OTHER | $0 | $0 | $0 | $0 | $0 | $0 | ||
| TOTAL DIRECT | $0 | $0 | $0 | $0 | $0 | $0 |
| Indirect Costs | Indirect Costs | ||||||
| $0 | |||||||
| $0 | |||||||
| TOTAL INDIRECT | $0 | $0 | $0 | $0 | $0 | $0 |
TOTAL FUNDING $0 $0 $0 $0 $0 0 $0
Sample Budget 1 Detailed Budget Table
| BUDGET BY YEAR | |||||||
| COST-TYPE | CATEGORY | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | TOTAL |
| Direct Costs | Personnel | ||||||
| Project Manager @ $80,000/yr, .5 FTE, with salary increase | $40,000 | $42,500 | $45,000 | $47,500 | $50,000 | $225,000 | |
| Project Staff @ $60,000 .5 FTE each year with salary increase | $30,000 | $32,500 | $35,000 | $37,500 | $40,000 | $175,000 |
| TOTAL PERSONNEL | $70,000 | $75,000 | $80,000 | $85,000 | $90,000 | $400,000 |
| Fringe Benefits | ||||||
| Full-time Employees @ 17% of salary | $11,900 | $12,750 | $13,600 | $14,450 | $15,300 | $68,000 |
| $0 | ||||||
| $0 | ||||||
| TOTAL FRINGE BENEFITS | $11,900 | $12,750 | $13,600 | $14,450 | $15,300 | $68,000 |
| Travel | ||||||
| Travel for conference and workshop presentations: | ||||||
| Airfare - $400 roundtrip @ 1 roundtrip per year | $400 | $400 | $400 | $400 | $400 | $2,000 |
| Luggage Fees - $25 per flight @ 2 flights per year | $50 | $50 | $50 | $50 | $50 | $250 |
| Hotel - $150 per day @ 3 days per year | $450 | $450 | $450 | $450 | $450 | $2,250 |
| Per Diem - $71 per day @ 3.5 days per year | $248 | $248 | $248 | $248 | $248 | $1,240 |
| Taxi - $45 per year | $45 | $45 | $45 | $45 | $45 | $225 |
| Parking - $20 per day @ 4 days per year | $80 | $80 | $80 | $80 | $80 | $400 |
| Mileage for local travel (500 miles per year at $0.655/mi) | $328 | $328 | $328 | $328 | $328 | $1,640 |
| TOTAL TRAVEL | $1,601 | $1,601 | $1,601 | $1,601 | $1,601 | $8,005 |
| Equipment | ||||||
| 2 Building Thermal Imagers @ $9,000 each | $18,000 | $18,000 | ||||
| $0 | ||||||
| TOTAL EQUIPMENT | $18,000 | $0 | $0 | $0 | $0 | $18,000 |
| Supplies | ||||||
| 1 Laptop Computer @ $2,500 each | $2,500 | $0 | $0 | $0 | $0 | $2,500 |
| $0 | ||||||
| TOTAL SUPPLIES | $2,500 | $0 | $0 | $0 | $0 | $2,500 |
| Contractual | ||||||
| Contractor to perform 30 energy assessments per year at industrial facilities. Assumes 740 hours per assessment (pre-visit analysis, site visit, post-visit analysis, report with recommendations) @ $46/hr | $1,021,200 | $1,021,200 | $1,021,200 | $1,021,200 | $1,021,200 | $5,106,000 |
| Contract for 10 small or medium-scale projects per year at industrial facilities (renewable energy, energy storage, energy efficiency, electrification, or energy planning). Assumes average cost $450,000/project | $4,500,000 | $4,500,000 | $4,500,000 | $4,500,000 | $4,500,000 | $22,500,000 |
| Contract for 5 large-scale energy efficiency or decarbonization demonstration projects per year at industrial facilities (e.g., industrial heat pumps). Assumes average cost $3 million/project | $15,000,000 | $15,000,000 | $15,000,000 | $15,000,000 | $15,000,000 | $75,000,000 |
| $0 | ||||||
| TOTAL CONTRACTUAL | $20,521,200 | $20,521,200 | $20,521,200 | $20,521,200 | $20,521,200 | $102,606,000 |
| OTHER | ||||||
| Participant Support Costs: Stipends for 2 Summer Interns | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $40,000 |
| Participant Support Costs: Industrial Retrofit Rebates, 50 facilities/yr @ $200,000 each | $10,000,000 | $10,000,000 | $10,000,000 | $10,000,000 | $10,000,000 | $50,000,000 |
| $0 | ||||||
| TOTAL OTHER | $10,008,000 | $10,008,000 | $10,008,000 | $10,008,000 | $10,008,000 | $50,040,000 |
| TOTAL DIRECT | $30,633,201 | $30,618,551 | $30,624,401 | $30,630,251 | $30,636,101 | $153,142,505 |
| Indirect Costs | Indirect Costs | ||||||
| $0 | |||||||
| $0 | |||||||
| TOTAL INDIRECT | $0 | $0 | $0 | $0 | $0 | $0 |
TOTAL FUNDING $30,633,201 $30,618,551 $30,624,401 $30,630,251 $30,636,101 $153,142,505
Sample Budget 2 Detailed Budget Table
| BUDGET BY YEAR | ||||||||
| COST-TYPE | CATEGORY | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | TOTAL | |
| Direct Costs | Personnel | |||||||
| Project Manager @ $80,000/yr, .5 FTE, with salary increase | $40,000 | $42,500 | $45,000 | $47,500 | $50,000 | $450,000 | $225,000 | |
| $0 | ||||||||
| $0 | ||||||||
| TOTAL PERSONNEL | $40,000 | $42,500 | $45,000 | $47,500 | $50,000 | 450000 | $225,000 | |
| Fringe Benefits | ||||||||
| Full-time Employees @ 17% of salary | $6,800 | $7,225 | $7,650 | $8,075 | $8,500 | $38,250 | ||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL FRINGE BENEFITS | $6,800 | $7,225 | $7,650 | $8,075 | $8,500 | 0 | $38,250 | |
| Travel | ||||||||
| Workforce development program: | ||||||||
| Travel for conference and workshop presentations: | ||||||||
| Airfare - $400 roundtrip @ 1 roundtrip per year | $400 | $400 | $400 | $400 | $400 | $2,000 | $2,000 | |
| Luggage Fees - $25 per flight @ 2 flights per year | $50 | $50 | $50 | $50 | $50 | $250 | $250 | |
| Hotel - $150 per day @ 3 days per year | $450 | $450 | $450 | $450 | $450 | $2,250 | $2,250 | |
| Per Diem - $71 per day @ 3.5 days per year | $248 | $248 | $248 | $248 | $248 | $1,243 | $1,240 | |
| Taxi - $45 per year | $45 | $45 | $45 | $45 | $45 | $225 | $225 | |
| Parking - $20 per day @ 4 days per year | $80 | $80 | $80 | $80 | $80 | $400 | $400 | |
| Mileage for local travel (500 miles per year at $0.655/mi) | $328 | $328 | $328 | $328 | $328 | $1,638 | $1,640 | |
| TOTAL TRAVEL | $1,601 | $1,601 | $1,601 | $1,601 | $1,601 | $8,005 | ||
| Equipment | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL EQUIPMENT | $0 | $0 | $0 | $0 | $0 | $0 | ||
| Supplies | ||||||||
| 2 Laptop Computer @ $2,500 each | $5,000 | $0 | $0 | $0 | $0 | $5,000 | $5,000 | |
| $0 | ||||||||
| TOTAL SUPPLIES | $5,000 | $0 | $0 | $0 | $0 | $5,000 | ||
| Contractual |
| $0 | |||||||
| TOTAL CONTRACTUAL | $0 | $0 | $0 | $0 | $0 | $0 | |
| OTHER | |||||||
| Subaward for workforce ecosystem capacity building and coordination (e.g., partnerships, employer engagement, student recruitment, marketing) | $75,000 | $75,000 | $75,000 | $75,000 | $75,000 | $375,000 | $375,000 |
| Subaward for pre-apprenticeship program for 300 students (including personnel and instructors; classroom instruction, hands-on training, curriculum, supplies, supportive services for students, and mentorship program) | $125,000 | $156,250 | $156,250 | $156,250 | $156,250 | $781,250 | $750,000 |
| Subaward for registered apprenticeship program for 200 apprentices (including personnel and instructors; classroom instruction, on-the-job training, curriculum, supplies, employer incentives, supportive services for students). Note: apprenticeship wages paid by the employer in this example | $333,332 | $416,667 | $416,667 | $416,667 | $416,667 | $2,083,335 | $2,000,000 |
| $0 | |||||||
| $0 | |||||||
| $0 | |||||||
| TOTAL OTHER | $533,332 | $647,917 | $647,917 | $647,917 | $647,917 | $3,125,000 | |
| TOTAL DIRECT | $586,733 | $699,243 | $702,168 | $705,093 | $708,018 | $3,401,255 |
| Indirect Costs | Indirect Costs | ||||||
| $0 | |||||||
| $0 | |||||||
| TOTAL INDIRECT | $0 | $0 | $0 | $0 | $0 | $0 |
TOTAL FUNDING $586,733 $699,243 $702,168 $705,093 $708,018 0 $3,401,255
Sample Budget 3 Detailed Budget Table
| BUDGET BY YEAR | ||||||||
| COST-TYPE | CATEGORY | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | TOTAL | |
| Direct Costs | Personnel | |||||||
| Project Manager @ $80,000/yr, .5 FTE, with salary increases | $40,000 | $42,500 | $45,000 | $47,500 | $50,000 | $450,000 | $225,000 | |
| Project Staff @ $60,000 .5 FTE each year with salary increase | $30,000 | $32,500 | $35,000 | $37,500 | $40,000 | $175,000 | ||
| $0 | ||||||||
| TOTAL PERSONNEL | $70,000 | $75,000 | $80,000 | $85,000 | $90,000 | 450000 | $400,000 | |
| Fringe Benefits | ||||||||
| Full-time Employees @ 17% of salary | $11,900 | $12,750 | $13,600 | $14,450 | $15,300 | $68,000 | ||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL FRINGE BENEFITS | $11,900 | $12,750 | $13,600 | $14,450 | $15,300 | 0 | $68,000 | |
| Travel | ||||||||
| Workforce development program: | ||||||||
| Travel for conference and workshop presentations: | ||||||||
| Airfare - $400 roundtrip @ 1 roundtrip per year | $400 | $400 | $400 | $400 | $400 | $2,000 | $2,000 | |
| Luggage Fees - $25 per flight @ 2 flights per year | $50 | $50 | $50 | $50 | $50 | $250 | $250 | |
| Hotel - $200 per day @ 3 days per year | $600 | $600 | $600 | $600 | $600 | $2,250 | $3,000 | |
| Per Diem - $71 per day @ 3.5 days per year | $245 | $245 | $245 | $245 | $245 | $1,243 | $1,225 | |
| Taxi - $45 per year | $45 | $45 | $45 | $45 | $45 | $225 | $225 | |
| Parking - $20 per day @ 4 days per year | $80 | $80 | $80 | $80 | $80 | $400 | $400 | |
| $1,638 | $0 | |||||||
| TOTAL TRAVEL | $1,420 | $1,420 | $1,420 | $1,420 | $1,420 | $7,100 | ||
| Equipment | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL EQUIPMENT | $0 | $0 | $0 | $0 | $0 | $0 | ||
| Supplies | ||||||||
| 1 Laptop Computer @ $2,500 each | $2,500 | $0 | $0 | $0 | $0 | $5,000 | $2,500 | |
| $0 | ||||||||
| TOTAL SUPPLIES | $2,500 | $0 | $0 | $0 | $0 | $2,500 | ||
| Contractual | ||||||||
| Tribal Community Center Solar Project: 5 MW PV + 3 MW/12 MWh battery storage: | $0 | |||||||
| Storage system | $0 | $6,200,000 | $0 | $0 | $0 | $22,500,000 | $6,200,000 | |
| PV module and inverter | $0 | $3,142,000 | $0 | $0 | $0 | $75,000,000 | $3,142,000 | |
| Installation labor | $0 | $850,000 | $0 | $0 | $0 | $850,000 | ||
| PV operation & maintenance/yr | $0 | $82,100 | $82,100 | $82,100 | $82,100 | $328,400 | ||
| TOTAL CONTRACTUAL | $0 | $10,274,100 | $82,100 | $82,100 | $82,100 | $10,520,400 | ||
| OTHER | ||||||||
| Participant Support Cost: Environmental Intern @ $4000/yr summer stipend | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $375,000 | $20,000 | |
| $781,250 | $0 | |||||||
| $2,083,335 | $0 | |||||||
| $0 | ||||||||
| $0 | ||||||||
| $0 | ||||||||
| TOTAL OTHER | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $20,000 | ||
| TOTAL DIRECT | $89,820 | $10,367,270 | $181,120 | $186,970 | $192,820 | $11,018,000 |
| Indirect Costs | Indirect Costs | ||||||
| Indirect Cost Rate: 40% of full time personnel and fringe benefits | $32,760 | $35,100 | $37,440 | $39,780 | $42,120 | $187,200 | |
| $0 | |||||||
| TOTAL INDIRECT | $32,760 | $35,100 | $37,440 | $39,780 | $42,120 | $187,200 |
TOTAL FUNDING $122,580 $10,402,370 $218,560 $226,750 $234,940 0 $11,205,200
File details come from the government source that posted it. Updated .