Purchase History.xlsx
XLSX spreadsheet 20 KB Posted
- Solicitation number
- S-25700-00017306
- Issued by
- Oregon
About this file
This is a Purchase History file documenting Oregon State Police badge procurement activities. The file tracks historical purchases of uniform badges (domed), wallet badges, and hat badges available in both silver and gold finishes, along with related badge items that support the agency's uniform and identification requirements. The purchase history provides a baseline of past ordering patterns and quantities to inform the price agreement solicitation for future procurement needs.
The document serves as a reference for establishing realistic pricing and volume expectations for the price agreement. By analyzing previous purchase quantities and frequencies, Oregon State Police and potential bidders can develop pricing structures that reflect actual demand patterns and operational needs. This historical data is essential for the RFQ process to ensure the negotiated price agreement terms are competitive and aligned with the agency's typical consumption rates for these specialized items.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Sample Price Agreement~22.pdf | ||
| Siver_OSP_Wallet_Badge_Picture.jpg | JPG image | |
| OSP_Gold_Dome_Badge_Picture.jpg | JPG image | |
| SilverOSP_Dome_Badge_Picture.jpg | JPG image | |
| OSP_Gold_Hat_Badge_Picture.jpg | JPG image |
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
Sheet1
| CW Nielsen Mfg. Corp — Purchase Order & Spend History | |||||
| Oregon State Police (Agency 257) · prepared for badge price-agreement re-solicitation | |||||
| Vendor: CW Nielsen Mfg. Corp | OregonBuys Vendor # V00002823 | SFMA Vendor No 1910870653 | Price agreement 257-1628-16 | |||||
| Scope: term of agreement 257-1628-16 (July 12, 2016 – present). OSP badges only; Oregon State Fire Marshal (OSFM) badges excluded. | |||||
| Headline (OSP badge purchases, contract term) | |||||
| Period covered | July 12, 2016 – June 2026 | ||||
| Total purchase orders | 261 | ||||
| Total units (badges & insignia) | 3,141 | ||||
| Total value | $91,078.48 | ||||
| Typical annual volume (full-year avg, 2017–2025) | ~27 orders · ~304 units · ~$9,320 per year | ||||
| Most recent full year (2025) | 21 orders · 445 units · $17,000 | ||||
| SFMA paid invoices, FY2026 (Jul 2025–May 2026) | 22 payments · $7,980.00 | ||||
| Annual history (2016–2026) | |||||
| Year | Orders | Units | Value ($) | ||
| 2016 | 13 | 392 | $6,281.42 | ||
| 2017 | 27 | 156 | $2,909.32 | ||
| 2018 | 29 | 361 | $6,566.58 | ||
| 2019 | 24 | 255 | $6,260.16 | ||
| 2020 | 20 | 327 | $6,896.50 | ||
| 2021 | 22 | 412 | $8,495.00 | ||
| 2022 | 41 | 234 | $9,268.50 | ||
| 2023 | 37 | 400 | $17,880.00 | ||
| 2024 | 22 | 144 | $8,605.00 | ||
| 2025 | 21 | 445 | $17,000.00 | ||
| 2026 | 5 | 15 | $916.00 | ||
| Order cadence — bulk vs. individual (all 261 POs) | |||||
| Order size | Orders | % of orders | Units | % of units | Value ($) |
| Individual (1-2 units) | 174 | 67% | 211 | 7% | $8,638.34 |
| Small batch (3-10 units) | 38 | 15% | 163 | 5% | $7,074.96 |
| Bulk restock (11+ units) | 49 | 19% | 2,767 | 88% | $75,365.18 |
| Item mix (by units) | |||||
| Item type | Units | Value ($) | |||
| Tie tack / tie bar | 1,033 | $11,613.50 | |||
| Uniform / dome badge | 769 | $33,818.66 | |||
| Hat/cap badge | 700 | $22,481.96 | |||
| Wallet badge | 520 | $20,509.50 | |||
| Badge (other) | 48 | $1,051.50 | |||
| Other insignia | 46 | $882.00 | |||
| Badge holder / clip | 24 | $691.86 | |||
| Retirement / plaque badge | 1 | $29.50 | |||
| Notes & methodology | |||||
| Scope: limited to the term of CW Nielsen price agreement 257-1628-16, July 12, 2016 to present. | |||||
| Oregon State Fire Marshal (OSFM) badges are excluded. OSFM became a separate agency in 2023, so its historical badge | |||||
| purchases are not indicative of future OSP demand; all OSFM/State Fire Marshal items were removed at the line level. | |||||
| Sources combined into one continuous history (no double-counting): | |||||
| • Legacy purchasing system — CW Nielsen line-item export, Jul 2016 – Jul 2024. | |||||
| • OregonBuys — formal POs from Aug 2024 onward; the legacy system's last CW Nielsen order (Jul 16, 2024) and | |||||
| OregonBuys' first (Aug 22, 2024) meet cleanly, so the two do not overlap. | |||||
| • Rejected and cancelled orders excluded; boilerplate/terms lines (qty 0) excluded. | |||||
| SFMA/R*STARS invoice payments are shown separately (FY2026 only on hand) and are NOT added to the PO totals, because a | |||||
| PO that is paid also appears in SFMA; the register captures additional small badge purchases paid directly by invoice. | |||||
| Cadence is by total units per PO: Individual (1-2), Small batch (3-10), Bulk restock (11+). Pattern: ~67% of orders are | |||||
| 1-2 badges (individual reissues), while bulk stockroom restocks (11+ units) are ~19% of orders but ~88% of total units. | |||||
| Projected annual demand: roughly 300 units and ~$8,000–$9,000 per year on average, with year-to-year variation driven by | |||||
| the timing of bulk restocks (2023 and 2025 were higher). | |||||
| Data Source & Accuracy Disclaimer | |||||
| This purchase order and spend history was compiled with the assistance of an artificial intelligence (AI) tool from raw data exports drawn from the agency's available purchasing and financial systems, including OregonBuys, the SFMA/R*STARS financial system, and a legacy purchasing system. The information is provided for general informational and estimating purposes only. | |||||
| The Oregon State Police does not warrant or guarantee the accuracy, completeness, or reliability of this information. The underlying exports may contain omissions, duplications, coding inconsistencies, or other errors, and the figures have not been individually audited or reconciled to official financial records. Coverage varies by system and time period, and some transactions may not be captured. | |||||
| Historical quantities and spend are not a representation, commitment, or guarantee of future purchasing volume, which may be higher or lower. Prospective offerors should rely on their own review and judgment in preparing any response and should not rely solely on this information. |
File details come from the government source that posted it. Updated .