Attachment 1 - Schedule of Supplies.xlsx
XLSX spreadsheet 32 KB Posted
- Attached to
- Electronic Equipment Federal contract opportunity
- Solicitation number
- SP3300-25-Q-0287
- Issued by
- Defense Logistics Agency Distribution
About this file
This file is a Schedule of Supplies (Attachment 1) for a Defense Logistics Agency Distribution solicitation (SP3300-25-Q-0287) for electronic networking equipment. The document details specific networking hardware requirements including 5 Cisco Catalyst 8300 Routers, 5 Cisco Switch Modules, 10 Cisco C9200L Switches, 10 each of 10GBASE-LR and 10GBASE-SR SFP Modules, and 10 Cisco 500W Power Supplies, with all line items currently priced at $0.00.
The spreadsheet also includes extensive pricing and inflation projection data, with historical and projected unit prices for various material numbers spanning 2020-2030. The document includes inflation projections from multiple sources including CBO, OMB, and Global Insights, with projected annual inflation rates ranging between -1.32% and 4.70%. Additionally, the file contains a detailed breakdown of E Rations pricing, with unit prices for various components like boxes, pads, inserts, and heat modules, with quantities specified and total costs calculated (e.g., 32,010 boxes at $2.73 each totaling $87,387.30).
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| SP3300-25-Q-0287.docx | DOCX document |
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
ROM
| Previous Contract | Unit Prices - June, 22, 2021 | |||||||||||||||||
| CLIN | Per Bundle | |||||||||||||||||
| SP3300-20D0007 | Base | Option 1 | Option 2 | Option 3 | Option 4 | Total | 1001 | $28.88 | ||||||||||
| 1002 | $15.12 | |||||||||||||||||
| $1,357,200.00 | $1,471,200.00 | $1,471,200.00 | $1,471,200.00 | $1,471,200.00 | $7,242,000.00 | 2001 | $28.88 | |||||||||||
| 2002 | $15.12 | |||||||||||||||||
| 3001 | $28.88 | |||||||||||||||||
| New Requirement | 2025 | 2026 | 2027 | 2028 | 2029 | 3002 | $15.12 | |||||||||||
| 4001 | $28.88 | |||||||||||||||||
| Base | Option 1 | Option 2 | Option 3 | Option 4 | Total | 4002 | $15.12 | |||||||||||
| $1,505,037.60 | $1,539,653.46 | $1,575,065.49 | $1,611,292.00 | $1,648,351.72 | $7,879,400.28 | |||||||||||||
| Historical | New Requirement | |||||||||||||||||
| Inflation | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 |
CBO 4.70% 8.00% 4.10% 2.60% 2.50% 2.30% 2.20% 2.20% 2.20% 2.20%
OMB 4.60% 4.70% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30%
Schedule
| CLIN | FSC / Material # | Description | Unit of Issue | Quantity | Unit Cost | Total Cost | Yes/No | Alternate Specifications |
| 0001 | 7030 / N30000810 | Router, Similar or equal to Cisco Catalyst 8300 Router, C8300-1N1S-4T2X Router | EA | 5 | $0.00 | $0.00 | ||
| 0002 | 7025 / N30000811 | Switch Module, Similar or equal to Cisco NIM Switch Module 4-port 10G SFP/SFP+ | EA | 5 | $0.00 | $0.00 | ||
| 0003 | 7030 / N30000812 | Switch, Similar or equal to Cisco C9200L 24p PoE+, 4 x 10G, Network Essentials | EA | 10 | $0.00 | $0.00 | ||
| 0004 | 7025 / N30000964 | Module, Similar or equal to Cisco 10GBASE-LR SFP Module, TAA compliant | EA | 10 | $0.00 | $0.00 | ||
| 0005 | 7025 / N30000965 | Module, Similar or equal to Cisco 10GBASE-SR SFP Module | EA | 10 | $0.00 | $0.00 | ||
| 0006 | 6116 / N30001423 | Power Supply, Similar or equal to Cisco 500W Power Supply, PWR-CC1-500WAC | EA | 10 | $0.00 | $0.00 | ||
| Controlled by: | Offeror's Name | |||||||
| CUI Category: | SSEL | |||||||
| Distribution Controls: | FED Only | |||||||
| POC: | Quoter Name, Phone, E-Mail |
&"Arial,Bold"&12Attachment 1 - Schedule of Supplies &"Arial,Bold"SP3300-25-Q-0287
Page &P &D
Worksheet
| UGR | UNIT PRICE | ||||||
| Actual | Projected | ||||||
| 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | |
| Material Number: N00000884 | $36.12 | $37.17 | $38.02 | $38.89 | $39.79 | $40.70 | $41.64 |
Material Number: N00000885 $18.90 $19.45 $19.90 $20.36 $20.82 $21.30 $21.79
| Actual Unit Price for E Rations | |||||||
| 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | |
| Material Number: N00000957 | $4.97 |
| Material Number: N00000958 | $10.33 | |
| 2012 | ||
| Material Number: N00000959 | $0.15 |
Material Number: N00000960 $1.86
| OMB Budget Projection CPI | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 |
| Percentage Change | 2.90% | 2.30% | 2.30% | 2.30% | 2.30% | 2.30% | 2.30% |
| Global Insights Projection | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | |
| Percentage Change | -1.32% | -0.84% | 1.10% | 2.47% | 2.28% | 2.43% | ||
| Value from 100 in 1982 | 329.02 | 324.67 | 321.95 | 325.5 | 333.53 | 341.13 | 349.43 | |
| United States, Producer Price Index, Corrugated and Solid Fiber Boxes | 1980M3=100 | 430.71 | 451.23 | 447.65 | 427.43 | 433.93 | 443.31 | 452.93 |
| 4.55% | -0.80% | -4.73% | 1.50% | 2.12% | 2.12% |
E RATIONS UNIT PRICE PRICE PAID
MATERIAL NUMBER 2024 2025 2026 2027 2028 2029 2030 2012 2021 2022 2023
N00000957 $5.55 $5.68 $5.81 $5.94 $6.08 $6.22 $6.36 $4.97
N00000958 $12.41 $12.70 $12.99 $13.29 $13.60 $13.91 $14.23 $10.33
N00000959 $0.22 $0.23 $0.24 $0.25 $0.26 $0.27 $0.28 $0.15
N00000960 $2.08 $2.13 $2.18 $2.23 $2.28 $2.33 $2.38 $1.86
| New IHS Inflation Rates 10/2024 | |||||||
| Base | 1 | 2 | 3 | 4 | |||
| MATERIAL NUMBER | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 |
N00000957 $5.55 $5.80 $5.76 $5.48 $5.57 $5.68 $5.80
N00000958 $12.41 $12.97 $12.87 $12.26 $12.45 $12.71 $12.98
N00000959 $0.22 $0.23 $0.23 $0.22 $0.22 $0.23 $0.23
N00000960 $2.08 $2.17 $2.16 $2.06 $2.09 $2.13 $2.18
| 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | ||
| 8115-N00000957 | $2.73 | $2.85 | $2.83 | $2.70 | $2.74 | $2.80 | $2.86 |
| 8115-N00007266 | $0.26 | $0.27 | $0.27 | $0.26 | $0.26 | $0.27 | $0.27 |
| 8135-N00007265 | $0.22 | $0.23 | $0.23 | $0.22 | $0.22 | $0.23 | $0.23 |
| 8135-N00007267 | $0.27 | $0.28 | $0.28 | $0.27 | $0.27 | $0.28 | $0.28 |
| 8115-N00000960 | $2.05 | $2.14 | $2.13 | $2.03 | $2.06 | $2.10 | $2.14 |
8115-N00000961 $4.36 $4.56 $4.52 $4.31 $4.37 $4.47 $4.56
| N00000884 |
| N00000885 |
Last E Buy
E RATION BUY
15 Boxes per Bundle
| 0001 | 8115-N00000957 | Boxes | 32,010.00 | $2.73 | $87,387.30 |
| 0002 | 8115-N00007266 | Pad | 17,000.00 | $0.26 | $4,420.00 |
| 0003 | 8135-N00007265 | Insert | 32,000.00 | $0.22 | $7,040.00 |
| 0004 | 8135-N00007267 | Insert | 32,000.00 | $0.27 | $8,640.00 |
| 0005 | 8115-N00000960 | Heat Module | 32,000.00 | $2.05 | $65,600.00 |
| 8115-N00000961 |
| 8115-N00007265 |
| 8115-N00007266 |
| 8115-N00007267 |
File details come from the government source that posted it. Updated .