Attachment 2 - BTS Pricing Worksheet (10 Nov 21).xlsx
XLSX spreadsheet 231 KB Posted
- Attached to
- Base Telecommunication System Service, Minot AFB Federal contract opportunity
- Solicitation number
- FA452821R0010
About this file
This document contains a pricing worksheet and solicitation for base telecommunication system services at Minot Air Force Base. The solicitation seeks to provide operation and maintenance of the base telephone system, inside plant systems, outside plant systems, network, transmission systems, and associated equipment. The pricing worksheet includes cost estimates for the base period and up to four option periods, with unit prices and total proposed prices provided for two contract line items for base telecommunication system O&M and work order requirements. Escalation factors are also included to calculate option period pricing, with sample computations shown. The solicitation number is FA452821R0010 and was issued by the Department of the Air Force Global Strike Command to provide 24/7 operation of the base telecommunication system at Minot AFB.
View the file
Other files for this federal contract opportunity
Show all 33
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
New
| Solicitaion: FA452821R0010 | |||||||||||||||||||||||||
| Minot AFB Base Telecommunication Service | |||||||||||||||||||||||||
| Attachment 2: BTS Price Worksheet | |||||||||||||||||||||||||
| CLIN / SLIN # | DESCRIPTION | EST QTY FOR BASE PERIOD | BASE PERIOD (CLIN X = 0) (FY15) | (CLIN X = 0) (FY22) | EST QTY FOR OPT. 1 | OPTION PERIOD 1 (CLIN X = 1) (FY23) | EST QTY FOR OPT. 1 | OPTION PERIOD 2 (CLIN X = 2) (FY24) | EST QTY FOR OPT. 1 | OPTION PERIOD 3 (CLIN X = 3) (FY25 ) | EST QTY FOR OPT. 1 | OPTION PERIOD 4 (CLIN X = 4) (FY26) | EST QTY FOR 6-mth Option | 6th Month Extension | |||||||||||
| QTY | UOI | UNIT PRICE | TOTAL PRICE | QTY | UOI | UNIT PRICE | TOTAL PRICE | QTY | UOI | UNIT PRICE | TOTAL PRICE | QTY | UOI | UNIT PRICE | TOTAL PRICE | QTY | UOI | UNIT PRICE | TOTAL PRICE | QTY | UOI | UNIT PRICE | TOTAL PRICE | ||
| X001 | Base Telecommunications Systems (BTS) O&M | 12 | MO | $0.00 | $0.00 | 12 | MO | $0.00 | $0.00 | 12 | MO | $0.00 | $0.00 | 12 | MO | $0.00 | $0.00 | 12 | MO | $0.00 | $0.00 | 6 | MO | $0.00 | $0.00 |
| X002 | Work Order Requirements | 1 | EA | $0.00 | $0.00 | 1 | EA | $0.00 | $0.00 | 1 | EA | $0.00 | $0.00 | 1 | EA | $0.00 | $0.00 | 1 | EA | $0.00 | $0.00 | 1 | EA | $0.00 | $0.00 |
| TOTAL OF CLINS X001 THROUGH X002: | EST: | $0.00 | EST: | $0.00 | EST: | $0.00 | EST: | $0.00 | EST: | $0.00 | EST: | $0.00 | |||||||||||||
| GRAND TOTAL (ALL CLINS): | $0.00 |
Escalation Factors
| ERROR:#REF! |
| ERROR:#REF! |
| ERROR:#REF! |
| Note: The option prices on worksheet "CLINs X004-X009" are unprotected. |
| Therefore, automatically computed prices may be replaced with direct entries if desired. |
| S e c t i o n B E s c a l a t i o n F a c t o r s |
| This worksheet affects the option prices. | ||||
| Sample of Computed Prices: | ||||
| INPUT | Base Period Price | $19,224.96 | 29275.51 | |
| Escalation from the Base Period to Option 1: | 2.50% | Computed Option 1 Price | $19,705.58 | |
| Escalation from Option 1 to Option 2: | 2.50% | Computed Option 2 Price | $20,198.22 | |
| Escalation from Option 2 to Option 3: | 2.50% | Computed Option 3 Price | $20,703.18 | |
| Escalation from Option 3 to Option 4: | 2.50% | Computed Option 4 Price | $21,220.76 |
| NOTE: Enter percentages as decimals of one-hundredths. . |
| Example: 1% will be typed as ".01" |
&"Times New Roman,Regular"&12PRICING TABLE
&"Times New Roman,Regular"Attachment 1 &"Times New Roman,Regular"&P of &N &"Times New Roman,Regular"&A
File details come from the government source that posted it. Updated .