Attachment D-Budget-Expenditure Template DRAFT.xlsx
XLSX spreadsheet 127 KB Posted
- Attached to
- Nationwide Public Safety Broadband Network (NPSBN) Investment, Oversight, Engagement, and Outreach Services
- Solicitation number
- Not on record
About this file
The file is a Draft Budget-Expenditure Template for a Time and Materials (T&M) contract related to the Nationwide Public Safety Broadband Network (NPSBN) Investment, Oversight, Engagement, and Outreach Services. The project spans from September 1, 2024, to August 31, 2025, with a total budget of approximately $525,000. The template details monthly labor, other direct costs (ODC), and travel expenses for various personnel including Project Managers, Data Entry specialists, Technical Assistants, and Telecommunications Engineers, with billing rates ranging from $74.07 to $202.00 per hour.
The budget breakdown shows a project execution model with actual and forecasted costs, tracking individual team members' hours and expenses across multiple tasks such as Market Engagement, Stakeholder Collaboration, Government Engagement, and Mission Leadership. The document indicates the project is currently 16.5% complete, with a cost-to-date of $14,555 and an estimated total cost of $17,400. The budget template provides granular tracking of labor hours, costs, and variances for each team member across different project tasks, offering a comprehensive view of the project's financial management and resource allocation.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment A-Performance Work Statement Draft.docx | DOCX document | |
| Attachment C-BPA Clauses Terms and Conditions Draft.docx | DOCX document | |
| NIOEOS RFQ Draft.docx | DOCX document | |
| Attachment B-Pricing Sheet Draft.xlsx | XLSX spreadsheet |
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
Budget_Execution Model
| 12345.00.6789 | Project Number | T&M | Contract Type | |
| EXAMPLE: Network Optimization | Project Name | |||
| 9/1/24 | PoP Start Date | |||
| 8/31/25 | PoP End Date | |||
| 10/31/24 | Actuals through | POP Complete: 16.5% | ||
| $525,000.00 | Funding | Plan Diff:-$510,000.00 | ||
| $2,845.00 | Cost To-Date | Cost Complete: 0.5% | ||
| $14,555.00 | Estimate to Complete | |||
| $17,400.00 | Estimate at Complete | |||
| $(507,600.00) | Over / (Under) Funding | |||
| -96.7% | Percent Variance |
| 160 | 168 | 152 | 168 | 160 | 152 | 168 | 176 | 168 | 160 | 176 | 168 | ||||||||||
| Project Plan | Bill Rate 1 | Bill Rate 1 | Bill Rate 1 | Bill Rate 1 | Bill Rate 1 | Bill Rate 1 | Bill Rate 1 | Bill Rate 1 | Bill Rate 1 | Bill Rate 1 | Bill Rate 1 | Bill Rate 1 | |||||||||
| Mission Unit | Call Order | Project | Offsite/Onsite | Individual | LCAT | Bill Rate 1 | Bill Rate 2 | Oct-24 | Nov-24 | Dec-24 | Jan-25 | Feb-25 | Mar-25 | Apr-25 | May-25 | Jun-25 | Jul-25 | Aug-25 | Sep-25 | Total | Total Cost |
| EXAMPLE: Business Management | 1 | Enterprise Strategy - Data Management | Onsite | Jane Doe | Project Manager I | $ 115.00 | $ - 0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 120.0 | $13,800.00 |
| $0.00 | |||||||||||||||||||||
| $0.00 | |||||||||||||||||||||
| - 0 | |||||||||||||||||||||
| - 0 | |||||||||||||||||||||
| - 0 | |||||||||||||||||||||
| Hours-Plan | 10.00 | 10.00 | 10.00 | 10.00 | 10.00 | 10.00 | 10.00 | 10.00 | 10.00 | 10.00 | 10.00 | 10.00 | 120.0 | ||||||||
| Cumulative Hours (Plan) | 10.0 | 20.0 | 30.0 | 40.0 | 50.0 | 60.0 | 70.0 | 80.0 | 90.0 | 100.0 | 110.0 | 120.0 | |||||||||
| Monthly Cost-Labor | $ 1,150.00 | $ 1,150.00 | $ 1,150.00 | $ 1,150.00 | $ 1,150.00 | $ 1,150.00 | $ 1,150.00 | $ 1,150.00 | $ 1,150.00 | $ 1,150.00 | $ 1,150.00 | $ 1,150.00 | $ 13,800.00 | ||||||||
| Monthly Cost-ODC | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 1,200.00 | ||||||||
| Monthly Cost-Travel | $ 105.00 | $ 105.00 | $ 105.00 | $ 105.00 | $ 105.00 | $ 105.00 | $ 105.00 | $ 105.00 | $ 105.00 | $ 105.00 | $ 105.00 | $ 1,110.00 | $ 2,265.00 | ||||||||
| Monthly Total Cost | $ 1,250.00 | $ 1,250.00 | $ 1,250.00 | $ 1,250.00 | $ 1,250.00 | $ 1,250.00 | $ 1,250.00 | $ 1,250.00 | $ 1,250.00 | $ 1,250.00 | $ 1,250.00 | $ 1,250.00 | $ 15,000.00 | ||||||||
| Cumulative Cost | $ 1,250.00 | $ 2,500.00 | $ 3,750.00 | $ 5,000.00 | $ 6,250.00 | $ 7,500.00 | $ 8,750.00 | $ 10,000.00 | $ 11,250.00 | $ 12,500.00 | $ 13,750.00 | $ 15,000.00 |
| Project Execution | Actuals | Actuals | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | |||||||||
| Mission Unit | Call Order | Project | Offsite/Onsite | Individual | LCAT | Bill Rate 1 | Bill Rate 2 | Oct-24 | Nov-24 | Dec-24 | Jan-25 | Feb-25 | Mar-25 | Apr-25 | May-25 | Jun-25 | Jul-25 | Aug-25 | Sep-25 | Total | Hrs Deviation |
| EXAMPLE: Business Management | 1 | Enterprise Strategy - Data Management | Onsite | Jane Doe | Project Manager I | $ 115.00 | $ - 0 | 10.0 | 12.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 122.0 | 2.00 |
| - 0 | |||||||||||||||||||||
| - 0 | |||||||||||||||||||||
| $ - 0 | $ - 0 | - 0 | - 0 | ||||||||||||||||||
| $ - 0 | $ - 0 | - 0 | - 0 | ||||||||||||||||||
| $ - 0 | $ - 0 | - 0 | |||||||||||||||||||
| $ - 0 | $ - 0 | - 0 | |||||||||||||||||||
| $ - 0 | $ - 0 | - 0 | |||||||||||||||||||
| $ - 0 | $ - 0 | - 0 | |||||||||||||||||||
| $ - 0 | $ - 0 | - 0 | |||||||||||||||||||
| $ - 0 | $ - 0 | - 0 | |||||||||||||||||||
| $ - 0 | $ - 0 | - 0 | |||||||||||||||||||
| $ - 0 | $ - 0 | - 0 | |||||||||||||||||||
| $ - 0 | $ - 0 | - 0 | |||||||||||||||||||
| - 0 | |||||||||||||||||||||
| Month Hours-Actual | 10.00 | 12.00 | 10.00 | 10.00 | 10.00 | 10.00 | 10.00 | 10.00 | 10.00 | 10.00 | 10.00 | 10.0 | 122.0 | ||||||||
| Month Hours Variance | - 0 | 2.0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | 2.0 | ||||||||
| Cumulative Hours-Actual | 10.0 | 22.0 | 32.0 | 42.0 | 52.0 | 62.0 | 72.0 | 82.0 | 92.0 | 102.0 | 112.0 | 122.0 | |||||||||
| Cumulative Hours Variance | - 0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | |||||||||
| Labor Cost-Actual | $ 1,150.00 | $ 1,380.00 | $ 1,150.00 | $ 1,150.00 | $ 1,150.00 | $ 1,150.00 | $ 1,150.00 | $ 1,150.00 | $ 1,150.00 | $ 1,150.00 | $ 1,150.00 | $ 1,150.00 | $ 14,030.00 | Cost Deviation | |||||||
| Monthly Cost-ODC | $ 5.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 1,105.00 | $ (95.00) | |||||||
| Monthly Cost-Travel | $ 105.00 | $ 105.00 | $ 105.00 | $ 105.00 | $ 105.00 | $ 105.00 | $ 105.00 | $ 105.00 | $ 105.00 | $ 105.00 | $ 105.00 | $ 1,110.00 | $ 2,265.00 | $ - 0 | |||||||
| Monthly Total Cost | $ 1,260.00 | $ 1,585.00 | $ 1,355.00 | $ 1,355.00 | $ 1,355.00 | $ 1,355.00 | $ 1,355.00 | $ 1,355.00 | $ 1,355.00 | $ 1,355.00 | $ 1,355.00 | $ 2,360.00 | $ 17,400.00 | $2,400.00 | |||||||
| Cumulative Cost | $ 1,260.00 | $ 2,845.00 | $ 4,200.00 | $ 5,555.00 | $ 6,910.00 | $ 8,265.00 | $ 9,620.00 | $ 10,975.00 | $ 12,330.00 | $ 13,685.00 | $ 15,040.00 | $ 17,400.00 | |||||||||
| Cumulative Cost Variance | $ 10.00 | $ 345.00 | $ 450.00 | $ 555.00 | $ 660.00 | $ 765.00 | $ 870.00 | $ 975.00 | $ 1,080.00 | $ 1,185.00 | $ 1,290.00 | $ 2,400.00 | |||||||||
| Burn Rate | $ 1,260.00 | $ 1,422.50 | $ 1,400.00 | $ 1,388.75 | $ 1,382.00 | $ 1,377.50 | $ 1,374.29 | $ 1,371.88 | $ 1,370.00 | $ 1,368.50 | $ 1,367.27 | $ 1,450.00 |
DRAFT
ODC
| Mission Unit | Call Order | Project | Project/Program | Person | Accounting Code | Description | Date | Total (Including Indirects) |
| EXAMPLE: Business Management | 1 | Graphic | 4.1.6. Communications Support Services | — | 0 | Printing | 10/1/24 | $5.00 |
DRAFT
Travel
| Mission Unit | Call Order | Project | Person | Accounting Code | Description | Date | Total (Including Indirects) |
| EXAMPLE: Business Management | 1 | Public Safety Advocacy | Jane Doe | 0 | Public Safety Conference-Reston, VA | 5/17/24 | $228.00 |
DRAFT
Contractors
| Mission Unit | Call Order | Project | Individual | LCAT | Rate | Hours | Total | Onsite/Offsite |
| Example: Market Engagement | 1 | Operations | Jane Doe | Telecommunications Engineer | $1.00 | 5.00 | $ 5 | Onsite |
| Market Engagement | Task 2 | Public Safety Engagement | Escobar, Elisabeth J. | FSS Data Entry | $ 81.71 | 127.00 | $ 10,377 | Onsite | |
| Market Engagement | Task 2 | Public Safety Engagement | LeMieux, Michael J. | FSS Program Manager | $ 197.76 | 35.00 | $ 6,922 | Onsite | |
| Market Engagement | Task 2 | Public Safety Engagement | Moccia, Lauren | FSS Program Manager | $ 197.76 | 1.00 | $ 198 | Onsite | |
| Market Engagement | Task 2 | Public Safety Engagement | Potter, Jessica L. | FSS Program Manager | $ 197.76 | 8.00 | $ 1,582 | Onsite | |
| Market Engagement | Task 2 | Public Safety Engagement | Anand, Sahna | FSS Senior Technical Assistant | $ 131.15 | 1.00 | $ 131 | Onsite | |
| Market Engagement | Task 2 | Public Safety Engagement | Bowers, Adrienne | FSS Senior Technical Assistant | $ 131.15 | 166.00 | $ 21,771 | Onsite | |
| Market Engagement | Task 2 | Public Safety Engagement | Richardson, Tara E. | FSS Senior Technical Assistant | $ 131.15 | 65.00 | $ 8,525 | Onsite | |
| Market Engagement | Task 2 | Public Safety Engagement | Payne, Mary D. | FSS Technical Assistant | $ 74.07 | 123.50 | $ 9,148 | Onsite | |
| Market Engagement | Task 2 | Public Safety Engagement | Greenwood, Sarah C. | FSS Telecommunications Engineer | $ 168.73 | 30.50 | $ 5,146 | Onsite | |
| Market Engagement | Task 2 | Stakeholder Collaboration | Escobar, Elisabeth J. | FSS Data Entry | $ 81.71 | 38.00 | $ 3,105 | Onsite | |
| Market Engagement | Task 2 | Stakeholder Collaboration | Getachew, R | FSS Data Entry | $ 81.71 | 175.50 | $ 14,340 | Onsite | |
| Market Engagement | Task 2 | Stakeholder Collaboration | Nylund, Blake J. | FSS Program Manager | $ 197.76 | 88.00 | $ 17,403 | Onsite | |
| Market Engagement | Task 2 | Stakeholder Collaboration | Anand, Sahna | FSS Senior Technical Assistant | $ 131.15 | 61.00 | $ 8,000 | Onsite | |
| Market Engagement | Task 2 | Stakeholder Collaboration | Bowers, Adrienne | FSS Senior Technical Assistant | $ 131.15 | 2.00 | $ 262 | Onsite | |
| Market Engagement | Task 2 | Stakeholder Collaboration | Payne, Mary D. | FSS Technical Assistant | $ 74.07 | 44.50 | $ 3,296 | Onsite | |
| Market Engagement | Task 2 | Stakeholder Collaboration | Manzano, Aaron J. | FSS Technical Writer | $ 93.39 | 14.00 | $ 1,307 | Onsite | |
| Market Engagement | Task 2 | Stakeholder Collaboration | Greenwood, Sarah C. | FSS Telecommunications Engineer | $ 168.73 | 131.50 | $ 22,188 | Onsite | |
| Market Engagement | Task 3 | Government Engagement | Escobar, Elisabeth J. | FSS Data Entry | $ 81.71 | 11.00 | $ 899 | Onsite | |
| Market Engagement | Task 3 | Government Engagement | Greenwood, Sarah C. | FSS Telecommunications Engineer | $ 168.73 | 0.75 | $ 127 | Onsite | |
| Market Engagement | Task 3 | Government Engagement | Zhu, Liangbi | FSS Telecommunications Engineer | $ 168.73 | 8.00 | $ 1,350 | Onsite | |
| Market Engagement | Task 4 | Industry and Academia Engagement | Greenwood, Sarah C. | FSS Telecommunications Engineer | $ 168.73 | 2.75 | $ 464 | Onsite | |
| Roadmap | Task 5 | I2 Mission Leadership | Chechile, Francesco G. | FSS Principal | $ 202.00 | 11.25 | $ 2,273 | Onsite | |
| Roadmap | Task 5 | I2 Mission Leadership | Dobie, Doug | FSS Principal | $ 202.00 | 3.00 | $ 606 | Onsite | |
| Roadmap | Task 5 | I2 Mission Leadership | Carollo Burrall, Anna | FSS Program Manager | $ 197.76 | 176.00 | $ 34,806 | Onsite | NPSBN Program Management |
| Roadmap | Task 5 | I2 Mission Leadership | Potter, Jessica L. | FSS Program Manager | $ 197.76 | 8.00 | $ 1,582 | Onsite | NPSBN Program Management |
| Roadmap | Task 5 | I2 Mission Leadership | Dobie, Jake | FSS Technical Writer | $ 93.39 | 6.00 | $ 560 | Onsite | |
| Roadmap | Task 5 | I2 Mission Leadership | Schauer, Scott | FSS Technical Writer | $ 93.39 | 6.00 | $ 560 | Onsite | |
| Roadmap | Task 5 | I2 Mission Execution/Domains | Milowic, Evan A. | FSS Administrative Services Officer | $ 76.90 | 19.50 | $ 1,500 | Onsite | |
| Roadmap | Task 5 | I2 Mission Execution/Domains | Bilsky, Alexis | FSS Data Entry | $ 81.71 | 164.50 | $ 13,441 | Onsite | |
| Roadmap | Task 5 | I2 Mission Execution/Domains | Nylund, Blake J. | FSS Program Manager | $ 197.76 | 88.00 | $ 17,403 | Onsite | |
| Roadmap | Task 5 | I2 Mission Execution/Domains | Anand, Sahna | FSS Senior Technical Assistant | $ 131.15 | 86.50 | $ 11,344 | Onsite | |
| Roadmap | Task 5 | I2 Mission Execution/Domains | Biery, Holly A. | FSS Senior Technical Assistant | $ 131.15 | 167.50 | $ 21,968 | Onsite | |
| Roadmap | Task 5 | I2 Mission Execution/Domains | Mateika, Pearson J. | FSS Senior Technical Assistant | $ 131.15 | 174.00 | $ 22,820 | Onsite | |
| Roadmap | Task 5 | I2 Mission Execution/Domains | Rankin, Ross A. | FSS Senior Technical Assistant | $ 131.15 | 170.00 | $ 22,296 | Onsite | |
| Roadmap | Task 5 | I2 Mission Execution/Domains | Mitchell, Juliana | FSS Technical Assistant | $ 74.07 | 169.00 | $ 12,518 | Onsite | |
| Roadmap | Task 5 | I2 Mission Execution/Domains | Manzano, Aaron J. | FSS Technical Writer | $ 93.39 | 107.50 | $ 10,039 | Onsite |
DRAFT
DropDown
| Formulas | ||||||||
| Task | Project | 1 | Task 2 | Task 3 | Task 4 | Task 5 | 0 | |
| Task 1 | XLOOKUP(A3,$D$2:$R$2,$D$3:$R$3)# | Operations | Public Safety Engagement | Government Engagement | Industry and Academia Engagement | I2 Mission Leadership | ||
| Stakeholder Collaboration | I2 Mission Execution/Domains | |||||||
| Onsite/Offiste | ||||||||
| Onsite | ||||||||
| Offsite |
0 0
File details come from the government source that posted it. Updated .