Attachment 08 Software Line Item Pricing.xlsx
XLSX spreadsheet 41 KB Posted
- Attached to
- Aircraft Computer Maintenance Management System
- Solicitation number
- 12760426Q0005-2
- Issued by
-
Department of Agriculture Forest Service
About this file
This is a Software Line Item Pricing Template designed for USDA procurement personnel to document and track software purchases. The template serves as a data collection instrument for recording detailed information about software acquisitions across the agency, with completed spreadsheets to be submitted to ITCategoryManagement@ocio.usda.gov for verification and processing.
The template captures comprehensive procurement and licensing data across multiple categories. Required fields include USDA and vendor points of contact information, contract/BPA numbers, purchase and delivery dates, vendor details, and product specifications such as part numbers, manufacturer, product name, and version numbers. Licensing terms are documented through fields indicating whether software is perpetual, subscription-based, or maintenance-only, with corresponding start and end dates for subscription or maintenance periods. The template also records rights associated with licenses, including upgrade rights, downgrade rights, and cross-edition rights, along with quantity ordered and associated pricing (unit price and total price). Additional optional fields accommodate serial numbers, GUIDs/UUIDs, and custom comments. The template includes dropdown menus for common software types (perpetual, subscription, CAL, concurrent devices, concurrent users, maintenance, custom) and a categorization system for root cost allocation (software, maintenance, support, purchase, oracle, other). Agencies are directed to contact James Hughes at the USDA Office of the Chief Information Officer for questions regarding completion of the worksheet.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 12760423Q0005-2 Amendment 01.pdf | ||
| Attachment 02 Bill of Materials_Revised.xlsx | XLSX spreadsheet | |
| Attachment 07 USDA Sec Lang App B.pdf | ||
| Attachment 05 ICT Accessibility Statement.pdf | ||
| Attachment 02 Bill of Materials.xlsx | XLSX spreadsheet | |
| Attachment 01 PWS CMMS.pdf | ||
| Attachment 09_Perf Mon Results Template.pdf | ||
| Attachment 03 FAMAuth Developer Guide.pdf | ||
| 12760426Q0005.pdf | ||
| Attachment 10 FS COR Designation.pdf | ||
| Attachment 06 CMMS_QASP.pdf | ||
| Attachment 04 WCF Fleet Aircraft List.xlsx | XLSX spreadsheet |
Show all 12
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 .