CPRG Implementation Grants Optional Budget_Table.xlsx
XLSX spreadsheet 78 KB Posted
- Opportunity number
- EPA-R-OAR-CPRGI-23-07
- 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 run by the Environmental Protection Agency. The budget template contains multiple tabs for itemizing costs across five measures in line item format with totals calculated automatically. It provides guidance on completing the tabs for direct and indirect costs by year along with a consolidated tab. The document also includes five sample budgets as examples for developing the required tables to include in the application budget narrative. The EPA grant opportunity aims to reduce greenhouse gas emissions and has a total annual funding amount of $3 billion allocated through the 66.046 - Climate Pollution Reduction Grants federal grant program. Successful applicants will receive funding for projects that implement strategies to lower carbon pollution such as energy efficiency upgrades, electrification, and renewable energy deployment.
CPRG 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 .