Attachment_5_-_Pricing_Matrix.xlsx
XLSX spreadsheet 29 KB Posted
- Attached to
- USAF Office Seating II Program Federal contract opportunity
- Solicitation number
- FA8003-18-R-0004
About this file
Amended Attachment 5 - Pricing Matrix 27 JUN 18
View the file
Other files for this federal contract opportunity
Show all 24
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
| Instructions for completing the AF Office Seating Pricing Matrix |
| * Please complete all required cells because an incomplete pricing spreadsheet could make an offer ineligible for award. Instructions in red font indicate sections that you must fill out. Black font instructions are informational and explain calculations. Do not attempt to alter formulas or copy cells as it may corrupt calculations and render your offer ineligible for award. |
| ** PLEASE READ CAREFULLY BEFORE COMPLETING THE MATRIX ** |
| "TEP Calculations" Tab: |
| - This tab shows the estimated purchase percentage for each chair type by Fiscal Year (FY). These percentages are the anticipated demand for each chair type and they are based on historical data from the prior Air Force (AF) Office Seating Program. This tab also provides the estimated number of units that will be purchased in each chair type by FY. The estimated number of units bought in each chair type was obtained by multiplying the FY Total Units Purchased number by the estimated purchase percentage for each chair type. Since chairs must be a whole unit, these calculations were rounded up to the next whole number. Note: The purchase percentage for each chair type and the number of units purchased for each chair type are projections done by AF personnel. The actual numbers could end up being above or below our projections. |
| "Year 1-5" Tabs: |
| - Column A: Insert an image of your proposed chair in this location. |
| - Column B: Identifies the chair type. |
| - Column C: AF Line Item Number (LIN) that identifies specific chair type. These LINs will be used at the Call Level. |
| - Column D: Fill in the Serial/Part Number for the corresponding cells from Column B. |
| - Column E: Fill in the Chair Name proposed in these cells. |
| - Column F: Fill in the GSA Price/Chair for the Year 1, Year 2, Year 3, Year 4, and Year 5 tabs with your lowest price available on your GSA schedule (including maximum volume discount prices) for each chair type. Cell fill color starts red, but should NOT be red when you submit your offer. If it is red, it means your GSA price is equal to or less than your proposed price in BPA NTE Price/Chair Column G. Any red cells may result in your offer being ineligible for award. |
| - Column G: Fill in the BPA NTE Price/Chair for the Year 1, Year 2, Year 3, Year 4, and Year 5 tabs for each chair type. Note that these are Not-To-Exceed (NTE) prices for the applicable ordering periods. Dollar values MUST be entered in these cells or your offer could be deemed incomplete and ineligible for award. Contractors are allowed to build price escalation into their quoted prices as they deem necessary. Please note that Government Purchase Card (GPC) transactions are expected to be the majority of sales in this program. Since these prices will ultimately be the basis for BPA award, we expect these NTE prices to stay in effect for the duration of the program. If a substantial event occurs which requires pricing changes, the AF will review/discuss with the BPA holder at that time, prior to incorporating any changes. When a local base issues an RFQ under this program, BPA holders will be able to further discount these prices at their discretion to compete for individual Calls. |
| - Column H: Total Evaluated Price (TEP) will be calculated in this column. It is calculated by multiplying Contractor's proposed price from "BPA NTE Price/Chair" cell by the corresponding "Estimated Units Purchased" cell on "TEP Calculations" tab. (Example from Year 1 Tab: H2 = G2 x 'TEP Calculations!'B9) |
TEP Calculations
| Fiscal Year | ESTIMATED FY TOTAL UNITS PURCHASED | EX.UU ESTIMATED PURCHASE % | EX.LL ESTIMATED PURCHASE % | T.MU ESTIMATED PURCHASE % | T.UU ESTIMATED PURCHASE % | CR.MU ESTIMATED PURCHASE % | CR.UU ESTIMATED PURCHASE % | GS.MU ESTIMATED PURCHASE % | GS.UU ESTIMATED PURCHASE % |
| 2019 | 25,000 | 2.61% | 1.60% | 42.23% | 9.30% | 20.77% | 8.25% | 9.18% | 6.06% |
| 2020 | 27,000 | 2.61% | 1.60% | 42.23% | 9.30% | 20.77% | 8.25% | 9.18% | 6.06% |
| 2021 | 38,500 | 2.61% | 1.60% | 42.23% | 9.30% | 20.77% | 8.25% | 9.18% | 6.06% |
| 2022 | 53,000 | 2.61% | 1.60% | 42.23% | 9.30% | 20.77% | 8.25% | 9.18% | 6.06% |
| 2023 | 56,500 | 2.61% | 1.60% | 42.23% | 9.30% | 20.77% | 8.25% | 9.18% | 6.06% |
| Fiscal Year | EX.UU ESTIMATED UNITS PURCHASED | EX.LL ESTIMATED UNITS PURCHASED | T.MU ESTIMATED UNITS PURCHASED | T.UU ESTIMATED UNITS PURCHASED | CR.MU ESTIMATED UNITS PURCHASED | CR.UU ESTIMATED UNITS PURCHASED | GS.MU ESTIMATED UNITS PURCHASED | GS.UU ESTIMATED UNITS PURCHASED |
| 2019 | 653 | 400 | 10,558 | 2,325 | 5,193 | 2,063 | 2,295 | 1,515 |
| 2020 | 705 | 432 | 11,403 | 2,511 | 5,608 | 2,228 | 2,479 | 1,637 |
| 2021 | 1,005 | 616 | 16,259 | 3,581 | 7,997 | 3,177 | 3,535 | 2,334 |
| 2022 | 1,384 | 848 | 22,382 | 4,929 | 11,009 | 4,373 | 4,866 | 3,212 |
| 2023 | 1,475 | 904 | 23,860 | 5,255 | 11,736 | 4,662 | 5,187 | 3,424 |
Year 1
| Chair Image | Chair Type | AF Line Item Number | Serial/Part Number | Chair Name | GSA Price / Chair | BPA NTE Price / Chair | Total Evaluated Price (TEP) |
| Executive - Upholstered Back and Upholstered Seat | EX.UU | $0.00 | |||||
| Executive - Leather Back and Leather Seat | EX.LL | $0.00 | |||||
| Task - Mesh Back and Upholstered Seat | T.MU | $0.00 | |||||
| Task - Upholstered Back and Upholstered Seat | T.UU | $0.00 | |||||
| Conference Room - Mesh Back and Upholstered Seat | CR.MU | $0.00 | |||||
| Conference Room - Upholstered Back and Upholstered Seat | CR.UU | $0.00 | |||||
| Guest/Side - Mesh Back and Upholstered Seat | GS.MU | $0.00 | |||||
| Guest/Side - Upholstered Back and Upholstered Seat | GS.UU | $0.00 | |||||
| TEP Year 1 Total | $0.00 |
Year 2
| Chair Image | Chair Type | AF Line Item Number | Serial/Part Number | Chair Name | GSA Price / Chair | BPA NTE Price / Chair | Total Evaluated Price (TEP) |
| Executive - Upholstered Back and Upholstered Seat | EX.UU | $0.00 | |||||
| Executive - Leather Back and Leather Seat | EX.LL | $0.00 | |||||
| Task - Mesh Back and Upholstered Seat | T.MU | $0.00 | |||||
| Task - Upholstered Back and Upholstered Seat | T.UU | $0.00 | |||||
| Conference Room - Mesh Back and Upholstered Seat | CR.MU | $0.00 | |||||
| Conference Room - Upholstered Back and Upholstered Seat | CR.UU | $0.00 | |||||
| Guest/Side - Mesh Back and Upholstered Seat | GS.MU | $0.00 | |||||
| Guest/Side - Upholstered Back and Upholstered Seat | GS.UU | $0.00 | |||||
| TEP Year 2 Total | $0.00 |
Year 3
| Chair Image | Chair Type | AF Line Item Number | Serial/Part Number | Chair Name | GSA Price / Chair | BPA NTE Price / Chair | Total Evaluated Price (TEP) |
| Executive - Upholstered Back and Upholstered Seat | EX.UU | $0.00 | |||||
| Executive - Leather Back and Leather Seat | EX.LL | $0.00 | |||||
| Task - Mesh Back and Upholstered Seat | T.MU | $0.00 | |||||
| Task - Upholstered Back and Upholstered Seat | T.UU | $0.00 | |||||
| Conference Room - Mesh Back and Upholstered Seat | CR.MU | $0.00 | |||||
| Conference Room - Upholstered Back and Upholstered Seat | CR.UU | $0.00 | |||||
| Guest/Side - Mesh Back and Upholstered Seat | GS.MU | $0.00 | |||||
| Guest/Side - Upholstered Back and Upholstered Seat | GS.UU | $0.00 | |||||
| TEP Year 3 Total | $0.00 |
Year 4
| Chair Image | Chair Type | AF Line Item Number | Serial/Part Number | Chair Name | GSA Price / Chair | BPA NTE Price / Chair | Total Evaluated Price (TEP) |
| Executive - Upholstered Back and Upholstered Seat | EX.UU | $0.00 | |||||
| Executive - Leather Back and Leather Seat | EX.LL | $0.00 | |||||
| Task - Mesh Back and Upholstered Seat | T.MU | $0.00 | |||||
| Task - Upholstered Back and Upholstered Seat | T.UU | $0.00 | |||||
| Conference Room - Mesh Back and Upholstered Seat | CR.MU | $0.00 | |||||
| Conference Room - Upholstered Back and Upholstered Seat | CR.UU | $0.00 | |||||
| Guest/Side - Mesh Back and Upholstered Seat | GS.MU | $0.00 | |||||
| Guest/Side - Upholstered Back and Upholstered Seat | GS.UU | $0.00 | |||||
| TEP Year 4 Total | $0.00 |
Year 5
| Chair Image | Chair Type | AF Line Item Number | Serial/Part Number | Chair Name | GSA Price / Chair | BPA NTE Price / Chair | Total Evaluated Price (TEP) |
| Executive - Upholstered Back and Upholstered Seat | EX.UU | $0.00 | |||||
| Executive - Leather Back and Leather Seat | EX.LL | $0.00 | |||||
| Task - Mesh Back and Upholstered Seat | T.MU | $0.00 | |||||
| Task - Upholstered Back and Upholstered Seat | T.UU | $0.00 | |||||
| Conference Room - Mesh Back and Upholstered Seat | CR.MU | $0.00 | |||||
| Conference Room - Upholstered Back and Upholstered Seat | CR.UU | $0.00 | |||||
| Guest/Side - Mesh Back and Upholstered Seat | GS.MU | $0.00 | |||||
| Guest/Side - Upholstered Back and Upholstered Seat | GS.UU | $0.00 | |||||
| TEP Year 5 Total | $0.00 |
Total Overall TEP $0.00
File details come from the government source that posted it.