Attachment_P7_CLIN_Breakout_(SUB).xls
XLS spreadsheet 294 KB Posted
- Attached to
- AIR-4. 11, N00421-18-R-0013 AEGIS Radio Communication System (RCS) supporting AD-4. 11. 3
- Solicitation number
- N00421-18-R-0013
About this file
P7 CLIN Breakout (SUB) Cost Spreadsheet
View the file
Other files
Show all 40
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
| Instructions | |
| Subcontractor: | |
| 1 | On Header Tab for each worksheet, insert the proposal number. The file name should be automatically populated. |
| 2 | On Footer Tab for the worksheet, insert the firm's name after colon. Insert the RFP number after the colon, if it has not been filled-in. |
| 3 | Only one worksheet should be prepared for the base year period of performance and all option year periods of performance. A summary sheet exists for both term and completion CLINs. The information in the summary tabs should automatically carry over from the other tabs. Verify that the summary sheets are correct after completing the separate tabs for both Term and Completion. Do not use separate worksheets for option years. |
| 4 | Every worksheet should have items 1 and 2 completed. |
| 5 | The worksheets of the workbook should all be formatted for printing on letter-size paper, without requiring "adjustments." It may be formatted for either landscape or portrait. DO NOT FORMAT FOR LEGAL SIZE PAPER. |
| 6 | Within the work sheet any cell colored "blue" contains a formula that should not be edited unless the Offeror deems it necessary to modify the formula to remain in compliance with their financial disclosure statement. |
| 7 | All dollar figures shall be fixed at two decimal places throughout the calculations. Values with additional decimal places shall not be used within any calculations. |
| 8 | The worksheet is arranged so the workforce being proposed for an entire period of performance is shown together, even though it will be separated by individual CLINS in Section B. When the numbers are carried to Section B, they will be the same as shown on the worksheet. |
| 9 | In column A, starting at row 5, two Government labor categories have been inserted as an example to how the contractor is to complete. The offeror shall use the labor categories identified in Section L, Part B, Paragraph 3.0, Sub-Paragraph 3.5, Paragraph 3.5.2, Table 3. The offeror shall identify the key personnel with an asterick. In column B, the Offeror can insert the title of the labor category it will be utilizing if unable to match the Government supplied labor categories. This applies to the Prime Contractor's section and those sections for its subcontractors. If necessary, insert additional rows--but ensure integrity of formulas. Also, labor categories with more than one person providing service shall be listed multiple times for each person performing work. For example, if the offeror proposes four Senior Analysts, then the labor category Senior Analyst shall be listed four times along with their applicable rates and information. |
| 10 | In column C, the Offeror should insert a "CF" if the worker will be performing at the Contractor's facility or a "O" if it will be performing onsite in Government spaces. |
| 11 | In column D, for the contractor's own workforce, the field is colored "green" indicating no input. (This reflects that the contractor is proposing its own employees or contingency hires--it does not include any subcontractors.) No input is required by the Offeror in this column. |
| 12 | In column E, for the individual subcontractor workforce, identify for the specific labor category individual whether they are full-time on this acquisition or part-time. Enter "F" for full-time or "P" for part-time. |
| 13 | In column F, enter the name of the proposed individual for that position. |
| 14 | In column G: |
| (a) Enter the unburdened labor rate for each individual (both term and completion for all 9 years) | |
| (b) In Cell G52 on the Engineering tab, G51 on the Training tab, and G47 on the Production tabs, the prime contractor should insert its fringe rate for full time, if it is not included in its overhead rate. If the fringe is included in the overhead rate, this cell should be left blank. | |
| (c) In Cell G53 on the Engineering tab, G52 on the Training tab, and G48 on the Production tabs, the subcontractor should insert its fringe rate for part-time, if it is not included in its overhead rate. If the fringe is included in the overhead rate, this cell should be left blank. If no part-time employees are proposed this should also be left blank. | |
| (d) In Cell G56 on the Engineering tab, G55 on the Training tab, and G51 on the Production tabs, the prime contractor should insert its overhead rate for work performed at the contractor's facility. | |
| (e) In Cell G57 on the Engineering tab, G56 on the Training tab, and G52 on the Production tabs, the subcontractor should insert its overhead rate for work performed at the Client/Government's facility. | |
| (f) In Cell G59 on the Engineering tab, G58 on the Training tab, and G54 on the Production tabs, the subcontractor should insert its G&A rate being applied. | |
| (g) In Cell G60 on the Engineering tab, G59 on the Training tab, and G55 on the Production tabs, the subcontractor should enter its FCCOM rate. If no FCCOM rate is being applied, the cell should be left blank. | |
| (h) In Cell G64 on the Engineering tab, G62 on the Training tab, and G59 on the Production tabs, the subcontractor should insert the fixed fee rate applied to its cost | |
| 15 | In column H, and then similarly for Columns J, L, N, P, R, T, V, and X: |
| (a) the subcontractor should enter the hours associated with individual labor category for CLIN XX00. Also make sure you plug in the hours for columns J, L, N and so on. | |
| (b) In Cell H52, J52, L52, N52, P52, R52, T52, V52 and X52 on the Engineering tab, H51, J51, L51, N51, P51, R51, T51, V51 and X51 on the Training tab, H47, J47, L47, N47, P47, R47, T47, V47 and X47 on the Production tabs, the subcontractor should insert the base its fringe rate for full time is being applied to, if it is not included in its overhead rate. If the fringe is included in the overhead rate, this cell should be left blank. | |
| (c) In Cell H53, J53, L53, N53, P53, R53, T53, V53 and X53 on the Engineering tab, H52, J52, L52, N52, P52, R52, T52, V52 and X52 on the Training tab, H48, J48 L48, N48, P48, R48, T48, V48 and X48 on the Production tabs, the prime contractor should insert the base its fringe rate for part time is being applied to, if it is not included in its overhead rate. If the fringe is included in the overhead rate, this cell should be left blank. | |
| (d) In Cell H56, J56, L56, N56, P56, R56, T56, V56 and X56 on the Engineering tab, H55, J55, L55, N55, P55, R55, T55, V55 and X55 on the Training tab, H51, J51, L51, N51, P51, R51, T51, V51 and X51 on the Production tabs, the subcontractor should insert the base its overhead rate is being applied to for work performed at the contractor's facility. | |
| (e) In Cell H57, J57, L57, N57, P57, R57, T57, V57 and X57 on the Engineering tab, H57, J57, L57, N57, P57, R57, T57, V57 and X57 on the Engineering tab, H56, J56, L56, N56, P56, R56, T56, V56 and X56 on the Training tab, H52, J52, L52, N52, P52, R52, T52, V52 and X52 on the Production tabs, the subcontractor should insert the base its overhead rate is being applied to for work performed at the Client/Government's facility. | |
| (f) In Cell H59, J59, L59, N59, P59, R59, T59, V59 and X59 on the Engineering tab, H58, J58, L58, N58, P58, R58, T58, V58 and X58 on the Training tab, and H54, J54, L54, N54, P54, R54, T54, V54 and X54 on the Production tabs, the subcontractor should insert the base its G&A rate is being applied to. | |
| (g) In cell H60, J60, L60, N60, P60, R60, T60, V60, and X60 on the Engineering tab, H59, J59, L59, N59, P59, R59, T59, V59 and X59 on the Training tab, and H55, J55, L55, N55, P55, R55, T55, V55 and X55 on the Production tabs, the subcontractor should insert the base its FCCOM rate is being applied to. If not applying a FCCOM rate, the cell should be left blank. | |
| (g) In Cell H64, J64, L64, N64, P64, R64, T64, V64 and X64 on the Engineering tab, H62, J62, L62, N62, P62, R62, T62, V62 and X62 on the Training tab, H59, J59, L59, N59, P59, R59, T59, V59 and X59 on the Production tabs, the subcontractor should insert the subcontractor labor base its fixed fee rate is being applied to. | |
| 16 | Column AD automatically calculated the total hours for all the CLINS. |
| 17 | Column AE is a summation of the costs. |
| 18 | If there is not going to be any data entry in a row or group of rows, please just hide the rows. Do not delete. |
| 19 | When submitting this file, the instructions may be deleted. |
Engineering
| Engineering | ||||||||||||||||||||||||||||||
| DO NOT TYPE IN ANY COLORED AREAS | ||||||||||||||||||||||||||||||
| Period of Performance: | 08/1/20 - 7/31/29 (Inclusive of Options) | CLINS | Base -0110 | CLIN | Opt I - 0210 | CLIN | Opt II - 0310 | CLIN | Opt III - 0410 | CLIN | Opt IV - 0510 | CLIN | Opt V - 0610 | CLIN | Opt VI - 0710 | CLIN | Opt VII - 0810 | CLIN | Opt VIII - 0910 | XX10 | CLIN | XX11 | ||||||||
| Services | Contractor | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | Hrs | ||||||
| Government Labor Category | Proposed Category | site | sub | f/p | Employee Name | Rate | Labor | Labor | Labor | SUM | Total | |||||||||||||||||||
| Program/Project Analyst, Journeyman (Onsite) | Example Category | f | John Doe | $ 5.00 | 50 | $ 250.00 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 50.0 | $ 250.00 | ||
| Program/Project Analyst, Journeyman (Contractor Facility) | Example Category | f | John Doe | $ 5.00 | 50 | $ 250.00 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 50.0 | $ 250.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 | 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 | 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 | $ - 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 | $ - 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 | 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 | 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 | $ - 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 | $ - 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 | 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 | 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 | $ - 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 | $ - 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 | 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 | 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 | $ - 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 | $ - 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 | 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 | 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 | $ - 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 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | - 0 | $ - 0 | ||||||
| $ - 0 | 0 | $ - 0 | 0 | $ 50.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 | $ 25.00 | 0 | $ 15.00 | 0 | $ 10.00 | 3 | $ 5.00 | 3 | $ 10.00 | 3 | $ 15.00 | 3 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | $ - 0 | |||||||
| $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 4 | $ - 0 | 4 | $ - 0 | 4 | $ - 0 | 4 | $ - 0 | 4 | $ - 0 | 4 | $ - 0 | $ - 0 | |||||||
| $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 5 | $ - 0 | 5 | $ - 0 | 5 | $ - 0 | 5 | $ - 0 | 5 | $ - 0 | 5 | $ - 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 | 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 | $ - 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 | $ - 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 | ||||||
| $ - 0 | 0 | $ - 0 | 10 | $ - 0 | 15 | $ - 0 | 0 | $ - 0 | 5 | $ - 0 | 5 | $ - 0 | 5 | $ - 0 | 5 | $ - 0 | 5 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 50.0 | $ - 0 | ||||||
| $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 5 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 5.0 | $ - 0 | ||||||
| subtotal | 100 | $ 500.00 | 10 | $ 50.00 | 15 | $ 25.00 | 5 | $ 15.00 | 5 | $ 10.00 | 0 | $ 5.00 | 17 | $ 10.00 | 17 | $ 15.00 | 17 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 186.0 | $ 630.00 | ||||||
| fringe fulltime | 0.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| fringe part time | 0.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| subtotal | $ 500.00 | $ 50.00 | $ 25.00 | $ 15.00 | $ 10.00 | $ 5.00 | $ 10.00 | $ 15.00 | $ - 0 | $ - 0 | $ - 0 | $ 630.00 | ||||||||||||||||||
| Overhead | Base | Base | Base | Base | Base | Base | Base | Base | Base | Base | Base | |||||||||||||||||||
| Contractor site | 0.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| OnSite Government | 0.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| subtotal | $ 500.00 | $ 50.00 | $ 25.00 | $ 15.00 | $ 10.00 | $ 5.00 | $ 10.00 | $ 15.00 | $ - 0 | $ - 0 | $ - 0 | $ 630.00 | ||||||||||||||||||
| G&A | 0.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| FCCOM | 0.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| subtotal | $ 500.00 | $ 50.00 | $ 25.00 | $ 15.00 | $ 10.00 | $ 5.00 | $ 10.00 | $ 15.00 | $ - 0 | $ - 0 | $ - 0 | $ 630.00 | ||||||||||||||||||
| Total Labor | $ 500.00 | $ 50.00 | $ 25.00 | $ 15.00 | $ 10.00 | $ 5.00 | $ 10.00 | $ 15.00 | $ - 0 | $ 630.00 | ||||||||||||||||||||
| Fee/Profit | 0.0% | $ 500.00 | $ - 0 | $ 50.00 | $ - 0 | $ 25.00 | $ - 0 | $ 15.00 | $ - 0 | $ 10.00 | $ - 0 | $ 5.00 | $ - 0 | $ 10.00 | $ - 0 | $ 15.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| Total Labor and Plus Fee/Profit | $ 500.00 | $ 50.00 | $ 25.00 | $ 15.00 | $ 10.00 | $ 5.00 | $ 10.00 | $ 15.00 | $ - 0 | -0 | $ - 0 | -0 | $ - 0 | $ 630.00 | ||||||||||||||||
| Grand Total Engineering | $ 630.00 |
&LAttachment_P7_CLIN_Breakout_Spreadsheet &RN00421-18-R-0013 -
ENGINEERING
&LKTR:(insert name)&CSource Selection Information See: FAR 2.101 and 3.104
Training
| TRAINING | ||||||||||||||||||||||||||||||
| DO NOT TYPE IN ANY COLORED AREAS | ||||||||||||||||||||||||||||||
| Period of Performance: | 08/1/20 - 7/31/29 (Inclusive of Options) | CLIN | BASE - 0160 | CLIN | OPT I - 0260 | CLIN | OPT II - 0360 | CLIN | OPT III - 0460 | CLIN | OPT IV- 0560 | CLIN | OPT V - 0660 | CLIN | OPT VI - 0760 | CLIN | OPT VII - 0860 | CLIN | OPT VIII - 0960 | CLIN | CLIN | XX11 | ||||||||
| Services | Contractor | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | Hrs | ||||||
| Government Labor Category | Proposed Category | site | sub | f/p | Employee Name | Rate | Labor | Labor | Labor | SUM | Total | |||||||||||||||||||
| Program/Project Analyst, Journeyman (Onsite) | Example Category | f | John Doe | $ 5.00 | 50 | $ 250.00 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 50.0 | $ 250.00 | ||
| Program/Project Analyst, Journeyman (Contractor Facility) | Example Category | f | John Doe | $ 5.00 | 50 | $ 250.00 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 50.0 | $ 250.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 | 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 | 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 | $ - 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 | $ - 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 | 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 | 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 | $ - 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 | $ - 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 | 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 | 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 | $ - 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 | $ - 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 | 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 | 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 | $ - 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 | $ - 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 | 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 | 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 | $ - 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 | $ - 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 | - 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 | 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 | $ - 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 | $ - 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 | ||||||
| $ - 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 | 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 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | - 0 | $ - 0 | ||||||
| subtotal | 100 | $ 500.00 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 100.0 | $ 500.00 | ||||||
| fringe fulltime | 0.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| fringe part time | 0.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| subtotal | $ 500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 500.00 | ||||||||||||||||||
| Overhead | Base | Base | Base | Base | Base | Base | Base | Base | Base | Base | Base | |||||||||||||||||||
| Contractor site | 0.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| OnSite Government | 0.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| subtotal | $ 500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 500.00 | ||||||||||||||||||
| G&A | 0.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| FCCOM | 0.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| Total Labor | $ 500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 500.00 | ||||||||||||||||||
| Fee/Profit | 0.0% | $ 500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| Total Labor and Plus Fee/Profit | $ 500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | -0 | $ - 0 | -0 | $ - 0 | $ 500.00 | ||||||||||||||||
| Capacity Increase for Services | ||||||||||||||||||||||||||||||
| CIC Cost | 10% | $ - 0 | ||||||||||||||||||||||||||||
| CIC Fixed Fee Pool | 10% | $ - 0 | ||||||||||||||||||||||||||||
| CIC Total Cost Plus Fixed Fee | 10% | hours | 0 | $ - 0 | ||||||||||||||||||||||||||
| Grand Total Training | $ 500.00 |
&LAttachment_P7_CLIN_Breakout_Spreadsheet &RN00421-18-R-0013 -
TRAINING
&LKTR:(insert name)&CSource Selection Information See: FAR 2.101 and 3.104
Production (Systems 1-9)
| PRODUCTION | ||||||||||||||||||||||||||||||
| DO NOT TYPE IN ANY COLORED AREAS | ||||||||||||||||||||||||||||||
| Period of Performance: | 08/1/20 - 7/31/29 (Inclusive of Options) | CLIN | Base - 0120 (System 1) | CLIN | Base - 0130 (System 2) | CLIN | Base - 0140 (System 3) | CLIN | Opt I - 0220 (System 4) | CLIN | Opt I - 0230 (System 5) | CLIN | Opt I - 0240 (System 6) | CLIN | Opt II -0320 (System 7) | CLIN | Opt II 0330 (System 8) | CLIN | Opt II 0340 (System 9) | CLIN | XX10 | CLIN | XX11 | Base - Opt VII (Systems 1-9) | SUBTOTAL Base - Opt II (Systems 1-9) | |||||
| Services | Contractor | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | Hrs | ||||||
| Government Labor Category | Proposed Category | site | sub | f/p | Employee Name | Rate | Labor | Labor | Labor | Labor | Labor | Labor | Labor | Labor | Labor | Subtotal | subtotal | |||||||||||||
| Program/Project Analyst, Journeyman (Onsite) | Example Category | f | John Doe | $ 5.00 | 50 | $ 250.00 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 50.0 | $ 250.00 | ||
| Program/Project Analyst, Journeyman (Contractor Facility) | Example Category | f | John Doe | $ 5.00 | 50 | $ 250.00 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 50.0 | $ 250.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 | 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 | 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 | $ - 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 | $ - 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 | 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 | 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 | $ - 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 | $ - 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 | 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 | 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 | $ - 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 | $ - 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 | 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 | 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 | $ - 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 | $ - 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 | 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 | 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 | $ - 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 | $ - 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 | - 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 | 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 | $ - 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 | $ - 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 | ||||||
| subtotal | 100 | $ 500.00 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 100.0 | $ 500.00 | ||||||
| fringe fulltime | 0.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| fringe part time | 0.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| subtotal | $ 500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 500.00 | ||||||||||||||||||
| Overhead | Base | Base | Base | Base | Base | Base | Base | Base | Base | Base | Base | |||||||||||||||||||
| Contractor site | 0.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| OnSite Government | 0.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| subtotal | $ 500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 500.00 | ||||||||||||||||||
| G&A | 0.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| FCCOM | 0.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| subtotal | $ 500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 500.00 | ||||||||||||||||||
| Total Labor | $ 500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 500.00 | |||||||||||||||||||||
| Fee / Profit | 0.0% | $ 500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| Total Labor and Plus Fee/Profit | $ 500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | -0 | $ - 0 | -0 | $ - 0 | -0 | $ - 0 | $ 500.00 | |||||||||||||||
| Capacity Increase for Services | ||||||||||||||||||||||||||||||
| CIC Cost | 10% | $ - 0 | ||||||||||||||||||||||||||||
| CIC Fixed Fee Pool | 10% | $ - 0 | ||||||||||||||||||||||||||||
| CIC Total Cost Plus Fixed Fee | 10% | hours | 0 | $ - 0 | ||||||||||||||||||||||||||
| Capacity Increase for ODCs | ||||||||||||||||||||||||||||||
| ODC CIC Cost | 10% | ` | $ - 0 | |||||||||||||||||||||||||||
| Grand Total Production (Systems 1-9) | $ 500.00 |
&LAttachment_P7_CLIN_Breakout_Spreadsheet &RN00421-18-R-0013 - PRODUCTION (Systems 1-9) &LKTR:(insert name)&CSource Selection Information See: FAR 2.101 and 3.104
Production (Systems 10-15)
| PRODUCTION | ||||||||||||||||||||||||||||||||
| DO NOT TYPE IN ANY COLORED AREAS | ||||||||||||||||||||||||||||||||
| Period of Performance: | 08/1/20 - 7/31/29 (Inclusive of Options) | CLIN | Opt III - 0420 (System 10) | CLIN | Opt III- 0430 (System 11) | CLIN | Opt III - 0440 (System 12) | CLIN | Opt IV - 0520 (System 13) | CLIN | Opt IV - 0530 (System 14) | CLIN | Opt IV - 0540 (System 15) | CLIN | CLIN | CLIN | XX09 | CLIN | XX10 | CLIN | XX11 | Opt III - Opt IV (Systems 10-15) | SUBTOTAL Opt III - Opt IV (Systems 10-15) | TOTAL All Production CLINS (Systems 1-15) | TOTAL All Production CLINs (Systems 1-15) | |||||||
| Services | Contractor | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | Hrs | Hrs | |||||||
| Government Labor Category | Proposed Category | site | sub | f/p | Employee Name | Rate | Labor | Labor | Labor | Subtotal | subtotal | Subtotal | subtotal | |||||||||||||||||||
| Program/Project Analyst, Journeyman (Onsite) | Example Category | f | John Doe | $ 5.00 | 50 | $ 250.00 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 50.0 | $ 250.00 | 100.0 | $ 500.00 | ||
| Program/Project Analyst, Journeyman (Contractor Facility) | Example Category | f | John Doe | $ 5.00 | 50 | $ 250.00 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 50.0 | $ 250.00 | 100.0 | $ 500.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 | 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 | $ - 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 | $ - 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 | 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 | 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 | $ - 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 | - 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 | 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 | $ - 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 | $ - 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 | 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 | $ - 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 | $ - 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 | 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 | 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 | $ - 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 | - 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 | 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 | $ - 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 | $ - 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 | 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 | $ - 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 | $ - 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 | 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 | ||||||
| subtotal | 100 | $ 500.00 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 100.0 | $ 500.00 | 200.0 | $ 1,000.00 | ||||||
| fringe fulltime | 0.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 | |||||||
| fringe part time | 0.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 | |||||||
| subtotal | $ 500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 500.00 | $ 1,000.00 | |||||||||||||||||||
| Overhead | Base | Base | Base | Base | Base | Base | Base | Base | Base | Base | Base | |||||||||||||||||||||
| Contractor site | 0.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 | |||||||
| OnSite Government | 0.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 | |||||||
| subtotal | $ 500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 500.00 | $ 500.00 | |||||||||||||||||||
| G&A | 0.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 | |||||||
| FCCOM | 0.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 | |||||||
| subtotal | $ 500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 500.00 | $ 500.00 | |||||||||||||||||||
| Total Cost | $ 500.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 500.00 | $ 1,000.00 | |||||||||||||||||||
| Fee / Profit | 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 | |||||||
| Total Labor and Profit | $ 1,000.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 1,000.00 | $ 1,500.00 | |||||||||||||||||||||||||
| hrs | ||||||||||||||||||||||||||||||||
| Grand Total Production (Systems 10-15) | $ 1,000.00 | |||||||||||||||||||||||||||||||
| Capacity Increase for ODCs | ||||||||||||||||||||||||||||||||
| ODC CIC Cost | 10% | ` | $ - 0 | $ - 0 | ||||||||||||||||||||||||||||
| Grand Total Production (Systems 1-15) | $ 1,500.00 |
&LAttachment_P7_CLIN_Breakout_Spreadsheet &RN00421-18-R-0013 - PRODUCTION (Systems 10-15) &LKTR:(insert name)&CSource Selection Information See: FAR 2.101 and 3.104
Summary
| SUMMARY | |||
| DO NOT TYPE IN ANY COLORED AREAS | |||
| TOTAL | |||
| Services | hrs | ||
| Engineering Labor | $ 630.00 | ||
| Training Labor | $ 500.00 | ||
| Production Labor | $ 1,000.00 | ||
| subtotal | 0 | $ 2,130.00 | |
| fringe fulltime | 0.00% | $ - 0 | $ - 0 |
| fringe part time | 0.00% | $ - 0 | $ - 0 |
| subtotal | $ 2,130.00 | ||
| Overhead | Base | ||
| Contractor site | 0.00% | $ - 0 | $ - 0 |
| Client site | 0.00% | $ - 0 | $ - 0 |
| subtotal | $ 2,130.00 | ||
| G&A | 0.00% | $ - 0 | $ - 0 |
| COM | 0.00% | $ - 0 | $ - 0 |
| subtotal | $ 2,130.00 | ||
| Total Labor | $ 2,130.00 | ||
| Fee/Profit Pool | $ - 0 | ||
| Total Labor and Fee/Profit | -0 | $ 2,130.00 | |
| Capacity Increase for Services | |||
| CIC Cost | 10% | ||
| CIC Fixed Fee Pool | 10% | ||
| CIC Total Cost Plus Fixed Fee | 10% | ||
| Capacity Increase for ODCs | |||
| ODC CIC Cost | 10% | ||
| Grand Total Services | $ 2,130.00 |
&LAttachment_P7_CLIN_Breakout_Spreadsheet &RN00421-18-R-0013 -
SUMMARY
&LKTR:(insert name)&RSource Selection Information See: FAR 2.101 and 3.104
File details come from the government source that posted it.