The file's text, extracted by GovTribe without its formatting.
Attachment 4a
| Offeror: | | | | | |
| ATTACHMENT 4, Sample Scenario Cost-Price Workbook | | | | | |
| CLIN | DESCRIPTION | C TYPE | QUANTITY | COST | AMOUNT |
| 5 | MTC Site Survey Mission | FFP | Job | | |
| CLIN | DESCRIPTION | C TYPE | QUANTITY | UNIT PRICE | AMOUNT |
| 6 | Travel for MTC Site Survey | Cost | Job | | |
| CLIN | DESCRIPTION | C TYPE | QUANTITY | UNIT PRICE | AMOUNT |
| 7 | MTC Installation Services | FFP | Job | | |
| CLIN | DESCRIPTION | C TYPE | QUANTITY | UNIT PRICE | AMOUNT |
| 8 | MTC Equipment | FFP | Lot | | |
| CLIN | DESCRIPTION | C TYPE | QUANTITY | UNIT PRICE | AMOUNT |
| 9 | Travel for MTC Install Services | Cost | Job | | |
Attachment 4b
| Sample Scenario Price Workbook | | |
| BASE YEAR | | |
| Firm Fixed Price | | |
| CLIN | Price | CLIN AGGREGATE TOTAL |
| 5 | $0.00 | $0.00 |
| 6 | $0.00 | $0.00 |
| 7 | $0.00 | $0.00 |
| 8 | $0.00 | $0.00 |
| 9 | $0.00 | $0.00 |
| BASE YEAR TOTAL | $0.00 | |
| TOTAL EVALUATED PRICE | $0.00 |
Attachment 4c Offeror's Name:
| LABOR RATES | |
| Labor Category | Fully Burdened Labor Rates |
| Principle Management | |
| Program Analysts/Specialist | |
| Program Management | |
| Project Coordinator | |
| Project Data Management | |
| VTC Field Engineer | |
| VTC Customer Support Engineer | |
| IT Project Management | |
| AV Planning | |
| AV Installation | |
| Network Engineer | |
| Network Installation | |
| Network Planning | |
| Furniture/Interior Designer | |
| Post Design | |
| Instructions: |
| 1. Enter the Fixed Fully Burdened Labor rate from Attachment 6, Fixed Fully Burdened Labor Rate Buildup Workbook. |
Attachment 4d Offeror's Name: "Offeror"
| Cost | | | |
| Rates (and FCCM Factors) | Year 01 | Description and Calculation | Definition and Allocation Base |
| 5.00% | | This rate is a sample. |
| Labor Fringes | | | |
| Engineering Overhead | | | |
| Manufacturing Overhead | | | |
| Material Handing | | | |
| Subcontractor Handling | | | |
| G&A Expenses | | | |
| Fee/Profit | | | |
| Instructions: |
| 1. If any of the rates/factors are not used in your estimating/accounting systems, leave the yearly blocks empty and enter "Not Applicable" in the column titled "Definition and Allocation Base". |
| 2. Each Offeror shall supply their applicable rates for the Base period and a description and/or calculation of how their rates/factors were developed. |
| 3. In the " Definition and Allocation Base" column, as a minimum, include a brief comment such as (for G&A expenses): Total Cost Input, Single Element (Direct Labor Cost) or Value Added (excludes …. and … ). |
| 4. If you have additional rates/factors in your estimating/accounting systems, you can add rows as needed. |
Attachment 4e Labor Calculations for FFP CLIN
| CLIN 0005 MTC Site Survey Mission | | | |
| Labor Category | Hours | Labor Rate | Price |
Labor Subtotal
| CLIN 0007 MTC Installation Services | | | |
| Labor Category | Hours | Labor Rate | Price |
| Labor Subtotal |
| Instructions: | |
| 1. Enter the labor categroy, hours and fully burdened labor rate then calculate the proposed price for each CLIN. | |
| 2. Enter the proposed price for each CLIN in Attachment 7a and 7b | |
Attachment 4f
| Annual Software License Renewal Cost | | | | | |
| Cost | M/H | G&A | Fee/Profit | Subtotal |
| Offeror Rates | | | | | |
| CLIN | | | | | |
| 0004 | | | | | |
| RWIS | | | | | |
| Solarwinds | | | | | |
| | | | CLIN ODC Total | |
| Scenario Cost CLIN | Cost/Price | G&A | Total CLIN Cost | | |
| Offeror's Rates | | | | | |
| 0006 | $ 40,769.00 | | | | |
| | CLIN ODC Total | | | |
| Scenario FFP CLIN | Cost/Price | M/H | G&A | Fee | Total CLIN Price |
| Offeror's Rates | | | | | |
| 0008 | $ 7,932,855.00 | | | | |
| | | | CLIN ODC Total | |
| Scenario Cost CLIN | Cost/Price | G&A | Total CLIN Cost |
| Offeror's Rates | | | |
| 0009 | $ 122,307.00 | | |
| | CLIN ODC Total | |
| Instructions: |
| 1. Apply rates/factors to the provided cost/price values for each CLIN then enter the information on Attachment 7a and 7b. |
