Attachment 2 - Pricing Spreadsheet.xlsx
XLSX spreadsheet 65 KB Posted
- Attached to
- Window Blinds – Mecho Shade Bands
- Solicitation number
- RFQMSB52024
About this file
This document appears to be a pricing spreadsheet template provided as an attachment to a federal contract solicitation. The template requires offerors to complete various fields, including labor rates, labor hours, material/ODC/travel costs, and subcontractor pricing, in order to calculate a Total Evaluated Price (TEP). The solicitation is for the Federal Bureau of Investigation (FBI) to procure Brand Specific Mecho Shade Window Blinds, which is a Total Small Business Set-Aside. The spreadsheet provides instructions for properly completing the pricing template, with sample data that must be replaced with the offeror's proposal details. Offerors are responsible for the mathematical accuracy of their pricing and for ensuring their proposal is submitted in accordance with the provided instructions.
View the file
Other files
Show all 16
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:
| (1) Quoters are required to complete all fields highlighted in Orange on the "Total Price by CLIN_Year" tab. Cells not highlighted in orange contain formulas and will self-populate. |
| (a) Enter a labor rate, inclusive of any proposed discounts, for all proposed labor categories for all performance years. |
| (b) Enter the proposed labor hours applicable to each labor category for all performance years. |
| (c) Enter Material/ODC/Travel "plug" amounts provided in the solitication, as applicable. If "plug" amounts are not provided, enter discreetly proposed estimates. |
| (d) Subcontractor/Interagency proposals must be provided in support of proposed Prime subcontract cost. |
| (e) If discreetly proposed direct material cost is included, Offerors shall add a worksheet tab containing a detailed bill of material (BOM). |
| (f) If an indirect burden is not applicable, enter 0% in the rate cell. |
| (2) All data highlighted in red font is sample data. All sample data must be removed and replaced with Quoter's proposal data, as applicable. |
| (3) Quoters are responsible for the mathematical accuracy of their proposed price. |
| (4) Total Evaluated Price (TEP) |
(a) This tab self populates based on data contained in the "Total Price by CLIN_Year" tab.
(b) Quoters are responsible for editing columns and formulas on all tabs to accurately calculate their proposed TEP.
(5) Additional Instructional Notes:
(a) Do not password protect any Price Proposal Microsoft Excel spreadsheets.
(b) Quoters are expected to use their customary formats and calculations consistent with their normal accounting practices to develop the proposed costs and Total Evaluated Price (TEP)
(c) Failure to propose in accordance with provided instructions will render the proposal incomplete.
Total Price by CLIN_Year Total Price by CLIN_Year
| FEDERAL BUREAU OF INVESTIGATION |
| Offeror Name: |
| Date: |
| When submitting a proposal for this requirement, the offeror is responsible for accuracy. Offerors must add columns and edit/update formulas to calculate costs in accordance with their respective accounting procedures. | |||||
| Data highlighted in red font is sample data only and must be removed and replaced with Offeror's proposal data. | |||||
| Base Year | Total | ||||
| Labor: | |||||
| Labor Category | Hours | Labor Rate | Cost | Hours | Cost |
| LCAT1 | 1 | $10.00 | $10 | 1 | $10 |
| $0 | 0 | $0 | |||
| $0 | 0 | $0 | |||
| $0 | 0 | $0 | |||
| $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 Fully Burdened Labor | 1 | $10 | 1 | $10 |
| Subcontract/Material: | Base | Rate | Cost | |
| Subcontract & Direct Material | $100 | |||
| Subcontract/Material Handling | $100 | 2.00% | $2 | |
| G&A | $2 | 3.00% | $0 | |
| Total Subcontract/Material | $102 | $102 |
| Base | Rate | Cost | ||
| Profit on Proposed Material Cost | $102 | 2.00% | $2 | $2 |
Total Proposed $114 $114
Total Evaluated Price (TEP) Proposed Total Evaluated Price
| FEDERAL BUREAU OF INVESTIGATION |
| Offeror Name: |
| Date: |
| When submitting a proposal for this requirement, the offeror is responsible for accuracy. Offerors must edit/update formulas to accurately calculate costs. | |||||
| CLIN Number | CLIN Description | Contract Type | CLIN Amount | Math Check | |
| 0001 | Labor and Material - Base Year | ||||
| Includes all contractor normal working hours and materials. The contractor shall perform all the required services in accordance with Section 3 - Statement of Work | Firm Fixed Price (FFP) | $114 | |||
| TOTAL EVALUATED PRICE | $114 | $114 |
File details come from the government source that posted it. Updated .