4.23 Exhibit 3 Weekly Status Report Template.xlsx
XLSX spreadsheet 19 KB Posted
- Solicitation number
- CZ-2664-06012025
About this file
The file is a Weekly Status Report Template for a Jet Propulsion Laboratory (JPL) contract, specifically designed for tracking Subcontract Work Orders (SWOs). The template provides detailed instructions for completing weekly status reports, including guidance on reporting fully burdened values, tracking open and closed SWOs, and documenting key performance metrics such as technical completion percentage, technical and schedule status, and expenditure tracking.
The related federal contract opportunity is a Mechanical Engineering Support and Assistance (MESA) Request for Proposal (RFP) issued by JPL, which is a 100% small business set-aside. The solicitation seeks subcontractors to provide mechanical systems engineering tasks supporting non-flight and flight technology development, system engineering, hardware development, and integration and test activities. JPL intends to award both cost-type and fixed-price subcontracts to multiple small businesses, with individual task efforts directed through Subcontract Work Orders (SWOs). The NAICS code for this acquisition is 541715, with a focus on research and development in physical, engineering, and life sciences.
View the file
Other files
Show all 26
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
Instructions
| Exhibit No.: 3 | ||||
| Subcontract No.: | ||||
| Dated: 2/25 | ||||
| Total Tabs 3 | ||||
| Weekly Status Report Template - Instructions | ||||
| General instructions: | ||||
| Delete Instructions tab prior to submitting | ||||
| Reported values in Weekly Status should be fully burdened (including fee). | ||||
| SWOs should be kept on Open tab until all costs have been incured and invoiced. | ||||
| Move Closed SWOs to separate sheet | ||||
| Do not alter the column names | ||||
| Do not alter the column order | ||||
| Do not alter formatting. | ||||
| Complete fields as follows: | ||||
| Contractor: | Company Name | |||
| Contract: | 7 digit ID for MEDALS prime contract | |||
| Report Date: | End of reporting period covered by report. NOT the date the report is submitted to JPL. | |||
| SWO: | 4 digit SWO number including leading zeros | |||
| Mod: | 2 digit Mod number including leading zeros | |||
| Latest TN: | 4 digit TN | |||
| Proj/Task: | JPL Project-Task account number | |||
| SWO Title: | SWO Title | |||
| SWO Start Date: | SWO Start Date | |||
| SWO End Date: | SWO End Date | |||
| SWO Ceiling Amount: | SWO Ceiling Amount | |||
| SWO Funded Amount: | SWO Funded Amount | |||
| SWO Expenditure to Date: | SWO Expenditure to Date | |||
| Balance: | Auto-populated with formula. Do not edit. | |||
| Previous week expenditure: | Previous week expenditure | |||
| Company Lead Name: | Program Manager assigned to task | |||
| Sub-Tier: | Sub-tier doing the majority of the work. If prime is doing the work, enter name of prime. | |||
| Technical Lead: | Name of lead subcontractor engineer doing the work. | |||
| JPL Cognizant Engineer: | JPL CogE/Task Manager | |||
| Technical % Complete: | Enter your best estimate of how technically complete the task is. Do not use an equation or linearly scale using expenditure to date. | |||
| Technical Status: | Enter a letter R, Y, G. | |||
| R = there is a risk of 20%+ deviation from the proposed cost or schedule. | ||||
| Y = there is a risk of 10-20% deviation from the proposed cost or schedule. | ||||
| G = Small to negligible risk of deviation from the proposed cost or schedule. | ||||
| Schedule Status: | Auto-populated with formula. Do not edit. | |||
| Cost Status: | Auto-populated with formula. Do not edit. | |||
| Workdays till EO POP: | Auto-populated with formula. Do not edit. | |||
| Notes: | Enter an explaination of any red or yellow values in previous columns. Add any additional relevant notes. |
Open
| Contractor: | Company Name | ||||||||||||||||||||
| Contract: | XXXXXXX | ||||||||||||||||||||
| Report Date: | 12/7/25 | ||||||||||||||||||||
| SWO | Mod | Latest TN | Proj/Task | SWO Title | SWO Start Date | SWO End Date | SWO Ceiling Amount | SWO Funded Amount | SWO Expenditure to Date | Balance | Previous week expenditure | Company Lead Name | Sub-Tier | Technical Lead | JPL Cognizant Engineer | Technical % Complete | Technical Status | Schedule Status | Cost Status | Workdays till EO POP | Notes |
| XXXX | XX | XXXX | XXXXXX-XX.XX.XX | SWO title | 1/1/19 | 12/15/19 | $ 500,000 | $ 100,000 | $ 400,000 | $ (300,000) | $ 1,000 | PM | Sub-Tier | CogE | JPL CogE | 75% | G | 0.10 | 0.94 | -1560 | |
| XXXX | XX | XXXX | XXXXXX-XX.XX.XX | SWO title | 1/1/19 | 12/31/19 | $ 1,000,000 | $ 1,000,000 | $ 800,000 | $ 200,000 | $ 10,000 | PM | Sub-Tier | CogE | JPL CogE | 99% | R | 0.14 | 1.24 | -1549 | |
| XXXX | XX | XXXX | XXXXXX-XX.XX.XX | SWO title | 1/1/19 | 2/2/20 | $ 100,000 | $ 100,000 | $ 80,000 | $ 20,000 | $ 5,000 | PM | Sub-Tier | CogE | JPL CogE | 75% | Y | 0.12 | 0.94 | -1525 | |
| 7/31/20 | $ - | ERROR:#DIV/0! | ERROR:#DIV/0! | -1396 |
Closed
| Contractor: | Company Name | |||||||||||||||
| Contract: | XXXXXXX | |||||||||||||||
| Report Date: | 12/7/19 | |||||||||||||||
| SWO | Mod | Latest TN | Proj/Task | SWO Title | SWO Start Date | SWO End Date | SWO Ceiling Amount | SWO Funded Amount | SWO Expenditure to Date | Balance | Previous week expenditure | Company Lead Name | Sub-Tier | Technical Lead | JPL Cognizant Engineer | Technical % Complete |
| XXXX | XX | XXXX | XXXXXX-XX.XX.XX | SWO title | 1/1/19 | 12/15/19 | $ 500,000 | $ 500,000 | $ 500,000 | $ - | $ 1,000 | PM | Sub-Tier | CogE | JPL CogE | 100% |
| XXXX | XX | XXXX | XXXXXX-XX.XX.XX | SWO title | 1/1/19 | 12/31/19 | $ 1,000,000 | $ 1,000,000 | $ 800,000 | $ 200,000 | $ 10,000 | PM | Sub-Tier | CogE | JPL CogE | 95% |
| XXXX | XX | XXXX | XXXXXX-XX.XX.XX | SWO title | 1/1/19 | 2/2/20 | $ 100,000 | $ 100,000 | $ 100,000 | $ - | $ 5,000 | PM | Sub-Tier | CogE | JPL CogE | 100% |
File details come from the government source that posted it. Updated .