Attachment 08 Software Line Item Pricing.xlsx
XLSX spreadsheet 41 KB Posted
- Attached to
- Aircraft Computer Maintenance Management System
- Solicitation number
- 12760426Q0005
- Issued by
-
Department of Agriculture Forest Service
About this file
This is a software line item pricing template designed for the U.S. Department of Agriculture to standardize the collection and reporting of software procurement data. The template captures comprehensive information about software purchases, including vendor details, product specifications, licensing terms, and pricing metrics. Required data fields include the USDA point of contact information, contract or BPA number, purchase and delivery dates, vendor or reseller name and contact information, software manufacturer details, product name, version numbers, and serial or license numbers. The template requires vendors to specify whether licenses are perpetual, subscription-based, or maintenance-only, along with corresponding start and end dates for subscription or maintenance agreements.
The pricing section requires submission of quantity ordered, unit price, and total price calculations, with additional fields to capture upgrade rights, downgrade rights, cross-edition rights, and metric units of measure. The template includes dropdown menus for license type selection and metric units such as concurrent access licenses (CAL), concurrent devices, concurrent users, number of processor cores, and number of processors. A field for comments is available for additional notes. The template instructions direct inquiries to James Hughes at the USDA Office of the Chief Information Officer and specify that Agency Contracting Officers' Representatives must verify accuracy before forwarding completed spreadsheets to the IT Category Management office for processing.
View the file
Other files
Show all 11
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
Software Data Template
| Yes | Perpetual | Yes | Yes | Yes | Yes | ||
| No | Subscription | No | No | No | No | ||
| Subscription | |||||||
| If you have questions regarding the completion of this worksheet please contact James Hughes at James.Hughes@ocio.usda.gov or on 202 407-1418. Questions may also be sent to ITCategoryManagement@ocio.usda.gov - Agency CORs - once you have verified that the information is complete and accurate, please forward the spreadsheet to ITCategoryManagement@ocio.usda.gov | |||||||
| USDA POC Name | USDA POC Phone |
Enter digits only
| EX: 2027209018 | USDA POC Email | Contract/BPA Number | Purchase Date |
| MM/DD/YY | Delivery Date | ||
| MM/DD/YY | Vendor / Reseller Name | Vendor / Reseller | |
| POC Name | Vendor / Reseller | ||
| POC Email | Vendor / Reseller POC Phone |
Enter digits only
| EX: 2027209018 | Part Number / | |||||
| Stock-Keeping Unit (SKU) | Software Manufacturer | Product Name (Software Title) | Version Numbers | Serial Numbers/License Numbers to be provided Y/N | GUID/UUID | Is the License Perpetual, Subscription or Maintenance? |
| Enter (P, S or M) or use dropdown menu | Subscription / Maintenance start date: |
MM/DD/YY
| Subscription / Maintenance end date: | |||||||||
| MM/DD/YY | Upgrade Rights Y/N | Is Upgrade Y/N | Downgrade Rights Y/N | Cross Edition Rights Y/N | Quantity Ordered | Metric | Unit Price | Total Price | Comments |
Field Descriptions
| Field Name | ||||
| Data Type | Required | Description | Example | |
| USDA POC Name | Text | Yes | Primary Point of Contact (POC) Full Name who performed procurement (to include first and last name) | Jon Snow |
| USDA POC Phone | Numerical | Yes | Primary Verified phone number of POC who performed procurement (include area code) | |
| USDA POC Email | Text | Yes | Primary Verified email of POC who performed procurement | jon.jones@XXXX.usda.gov |
| Contract/BPA Number | Text | Yes | Official Government or USDA contract/BPA number (use entire identification, including letters, numbers and dashes) | AG-3144-B-15-0011 (Microsoft Dynamics), Dell Federal Systems, L.P. |
| Purchase Date | Date | Yes | Date of actual purchase | 3/15/18 |
| Delivery Date | Date | Yes | Date order was shipped by vendor to customer | 6/6/18 |
| Vendor / Reseller Name | Text | Yes | Name of vendor or reseller that this software item was procured from | Alliant SB, Adobe |
| Vendor / Reseller POC Name | Text | Yes | Full Name of vendor POC (to include first and last name) | Carl Grimes |
| Vendor / Reseller POC Email | Text | Yes | Verified vendor email address | carl.grimes@XXXX.usda.gov |
| Vendor / Reseller POC Phone | Text | Yes | Verified vendor phone (office or mobile). Utilize area code for U.S. and for international include 011 (U.S. exit code) then country code then remaining extensions | 202-123-4567 or Germany example 011-49-area code-phone number |
| Part Number/Stock-Keeping Unit (SKU) | Text | Yes | A SKU is a number or string of alpha and numeric characters that uniquely identify a product. | KS944BR72 |
| Software Manufacturer | Text | Yes | The company that manufactures the software | Microsoft, Adobe, Oracle |
| Product Name (Software Title) | Text | Yes | Specific product name to include any ancillary identifiers (any separate costs per product (i.e., license, key, maintenance) should be listed as a separate line item) | Adobe Professional, Adobe Reader, Microsoft Office 2013, Pulse Secure |
| Version Numbers | Numerical | Yes | Unique number or set of numbers assigned to a specific version and release identification of a software program | 2, 4.2, 7 |
| Serial Numbers/License Numbers Y/N | Text | Yes | Indicates that Serial Numbers/License Numbers are/are not provided with the order | |
| GUID/UUID | Numerical | Yes | Globally Unique Identifier and/or Universally Unique Identifier is a 128-bit integer number used to identify resources. | |
| Perpetual, Subscription or Maintenance | Text | Yes | Indicate if perpetual (own and pay for maintenance) , subscription (leased software without maintenance costs) or maintenance (maintenance on a perpetual license) | Perpetual "P", Subscription "S" or Maintenance "M" |
| Subscription / Maintenance Start Date | Enter the date the subscription begins | |||
| Subscription / Maintenance End Date | Enter the Date the Subscription ends | |||
| Upgrade Rights Yes/No | Text | Yes | Indicates that Upgrade Rights are/are not provided with the order | |
| Is Upgrade Yes/No | Text | Yes | Indicates that this order is or is not an Upgrade | |
| Down Grade Rights Yes/No | Text | Yes | Indicates that this order contains Down Grade Rights | |
| Cross Edition Rights Yes/No | Text | Yes | Indicates that this order contains Cross Edition Rights | |
| Quantity Ordered | Numerical | Yes | Total number of software items procured | 50, 568, 5,000 |
| Metric | Text | Yes | Unit of measure to determine how the product is sold | |
| Unit Price | Numerical in US Dollars | Yes | Value paid for single software unit or item | $1.50 |
| Total Price | Numerical in US Dollars | Yes | Quantity ordered * Unit Price | 5,000*$1.50 = $4998.50 (formula identified in cell - do not alter) |
| *If Applicable | ||||
| Comments | Text | No | Provide any additional notes or comments. Supported custom field data types are: |
▪ Text
▪ Date
▪ Yes|No
▪ Digit
▪ Currency
▪ Decimal
| SOFTWARE | Root | |
| MAINTENANCE | Yes | |
| SUPPORT | No | |
| PURCHASE | ||
| ORACLE | ||
| OTHER |
mailto:jon.jones@XXXX.usda.gov Drop Downs
| Perpetual / Subscription | CAL (Client Access license) | Yes |
| Perpetual | Concurrent Devices | No |
| Subscription | Concurrent Users | |
| Maintenance | Custom Compare Value | |
| Devices | ||
| Installations | ||
| Number of processor Cores | ||
| Number of processors | ||
| PVU | ||
| Users | ||
| Other |
File details come from the government source that posted it. Updated .