SOW Attachment V - Monthly Activity Reports - 04-27-2021.xlsx
XLSX spreadsheet 3 MB Posted
- Solicitation number
- AAQ5B0-Print-SIR
View the file
Other files
Show all 15
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
Definitions and Attributes
| Suggested Office Supply Report headers, Definitions, and Attributes | ||
| Header Name | Definition | Attribute |
| Contract Number | Contract Number Assigned at Award | Text |
| Vendor | Contractor | Text |
| Order Date | Date Order was Placed | Date |
| Billed Date | Date Oder was Billed | Date |
| Method of Payment | Purchase Card or Purchase Order | Text |
| SOT Order | Designate if this was a SOT Order | |
| Task Order Number | If transaction was through a Purchase Order | Text |
| Contract Line Item Number (CLIN) | Identify the CLIN used for the items purchased | Text |
| Order Number | Unique order number assigned by contractor | Text |
| Category | (Contract Defined Categories) | Text |
| Dept | self-explanatory | Text |
| Sub Category | (Contract Defined Subcategories) | Text |
| Class | self-explanatory | Text |
| Mfr. Name | self-explanatory | Text |
| OEM/Mfg Part Number | Manufacturer OEM or Part Number | Text |
| Supplier Product Code (SKU) | Contractor's SKU/Product Code | Text |
| Item Description | Description of item purchased | Text |
| Unit Issue | Unit of issue, i.e., EA, DZ, BOX, etc. | Text |
| Quantity | Quantity of item purchased | Number |
| List Price | Manufacturer List price | Currency |
| Contract Price | Negotiated contract price | Currency |
| Extended Price | Quantity x Contract Price | Currency |
| DOT Operating Administration (OA) | DOT OA, i.e., FAA, FHWA, OST, etc. | Text |
| OA Office Designator | OA internal office designation, i.e., LOB, Program Office, etc. (CO to provide approved list) | Text |
| Order Placed By Name | Name of person placing order | Text |
| Order Placed By Phone | Phone number of person placing order | Number |
| Shipping Location Street Address | self-explanatory | Text |
| Shipping Location City | self-explanatory | Text |
| Shipping Location State | self-explanatory | Text |
| Shipping Location Zip | self-explanatory | Number |
| OA Region Code | OA Defined | Text |
| Ability One / Unicor | Is item Ability One or Unicor mandatory purchase | Text |
| Meets EO 13101 Guidelines | The Contractor will track FAA's procurement and recycled content purchases and provide annual data for EO 13101 annual report as part of the nationwide office supply contract. Resource Conservation and Recovery Act Report (RCMA) and Executive Order (EO) 12873 Annual Report (Section H.2) | Text |
| Recycled/ Non-Recycled | self-explanatory | Text |
| Discount Off List | Negotiated percent discount of List price | Percent |
| CPG | The contractor must provide products that conform to VPG, when applicable. (Section C.4.2.2) | Text |
| Energy Star | The contractor must provide ENERGY STAR qualified and FEMP-designated products meeting the perfomrance criteria as required by the Energy Policy Act of 2005 (P.L. 109-58). See http://www.epeat.net for a list of products that meet these performance criteria. (section C4.2.6). | Text |
| 508 Compliant | Identify if the item purchased is 508 Compliant (yes, no or N/A) | Text |
| Unfilled/Cancelled Orders | The contractor must indiicate which orders are unfilled/cancelled orders. (setion C4.6.1) | Text |
| Late Deliveries | The contractor must indicate which orders are late deliveries. (more than 2 business days)(Section C.4.6.1) | Text |
| On-Time Deliveries | C.4.5.2 Contractor must deliver orders in good condition within 2 business days of order placement for items delivered within the 48 contiguous states and the District of Columbia. (Section 4.5.2) | Text |
Pick Lists
| PICK LISTS | |||
| FAA Lines of Business | FAA Organizational Office/Region | ||
| LOB | Title | ORG | Shipping Method |
| AAE | Audit and Evaluation | AC - Aeronautical Center | Standard |
| ABA | Financial Services | AL - Alaskan Region | 2nd Day |
| ACE | Materials & Services | CE - Central Region | Overnight |
| ACQ | Acquisition and Business Services | CT - Technical Center | Other (Specify) |
| ACR | Civil Rights | EA - Eastern Region | |
| AEP | Policy, Planning and Environment | EU - International Area Offices | Service Type |
| AFN | Finance and Management | GL - Great Lakes Region | 1 -- Request for quote acknowleged (Two (2) business hrs) |
Melanie Morones: Melanie Morones:
Send FAA personnel email reply - "Acknowledged"
| AGC | Chief Counsel | NE - New England Region | 2 -- Completed quote returned (within two (2) business days) |
| AGI | Government & Industry | NM - Northwest Mountain Region | 3 -- |
| AHR | Human Resource Management | SO - Southern Region | 4 -- |
| AIO | Information Services | SW - Southwest Region | 5 -- |
| AIT | Administrator for Information and Technology | WA - FAA Washington HQ | |
| ANG | NextGen | WP - Western-Pacific Region | |
| AOA | Administrator | ||
| AOA/ADA-1 | Deputy Administrator | ||
| AOC | Communications | ||
| API | International Aviation | ||
| APL | Policy, International Affairs & Environment | * Note: To see a depiction of FAA regions/states, please click here: | |
| ARC | Regions and Center Operations | https://www.faa.gov/about/office_org/headquarters_offices/arc/ | |
| ARP | Airports | ||
| ASH | Security & Hazardous Materials | ||
| AST | Commercial Space Transportation | ||
| ATO/AJC | Communications Services | ||
| ATO/AJE | En Route & Oceanic Services | ||
| ATO/AJF | Director of IT Operations Office | ||
| ATO/AJG | Management Services | ||
| ATO/AJI | Safety & Technical Training | ||
| ATO/AJM | Program Management Organization | ||
| ATO/AJO | Chief Operating Officer (ATO) | ||
| ATO/AJP | Planning & Development Services | ||
| ATO/AJR | System Ops. Services | ||
| ATO/AJR-B | Flight Services | ||
| ATO/AJS | Safety Incvestigation and Evaluation Services | ||
| ATO/AJT | Air Traffic Services | ||
| ATO/AJV | Mission Support | ||
| ATO/AJW | Technical Operations Services | ||
| AVS/AAM | Federal Air Surgeon | ||
| AVS/AFS | Flight Standards Service | ||
| AVS/AIR | Aircraft Certification Service | ||
| AVS/AOV | Air Traffic Oversight | ||
| AVS/AQS | Quality, Integration, Exec. Services | ||
| AVS/ARM | Rulemaking | ||
| AVS/AVP | Accident Investigation | ||
| AVS-1 | Aviation Safety | ||
| [Others are TBD due to ongoing FAA re-organization] |
https://www.faa.gov/about/office_org/headquarters_offices/arc/ Financial & Data Report Line Item Ordered Date Order Number Ship To Name Address 1 Address 2 City State Zip Code Description CLIN LOB ORG Manufacturer Part Number OEM Part Number Item Code (SKU) Qty List Price (MSRP) Melanie Morones: Melanie Morones:
Manufacture Suggested Retail Price (MSRP) Unit Cost Melanie Morones: Melanie Morones:
If order is not placed, enter zero (0). Do not enter text. Please enter the reason in the Order Number field. Ext Cost Shipping Total Cost Melanie Morones: Melanie Morones:
Extended cost plus shipping cost.
Delivery Report Line Item Ordered Date Vendor Order Number Required Delivery Date Melanie Morones: Melanie Morones:
| The projected date based on order date plus six business day. | Ship To Name | Address 1 | Address 2 | City | State | Zip Code | Actual Delivery Date | Shipping Method |
| Melanie Morones: Melanie Morones: Carrier used - UPS, Fedex, DHL, internal transport services, etc. | Shipper Tracking # |
Melanie Morones: Melanie Morones:
Carrier tracking number and hyperlink Recipient signature
Person who signs for package Location delivered Conus/Oconus
Quote Discrepancies Line Item Ship To Name Address 1 Address 2 City State Zip Code Description Manufacturer Part Number OEM Part Number Item Code Qty List Price (MSRP) Unit cost Ext cost Shipping Total Cost Order Number Delivery date Tracking Info Reason for discrepancy Corrective action taken
Invalid Melanie Morones: Melanie Morones:
Reason for item not being placed.
| Not available |
| Backordered |
| Discontinued |
| Item # not valid |
| Restricted |
| Item not available |
| N/A |
SOT Short-Pay Report
| Contract # | PO # | POP Start | POP End | Invoice Date | Invoice # | Amount Invoiced | Discrepancy Amount | Amount Paid | Date Payment Received |
| DTFACT-16-D-000XX | 692M15-21-F-XXXXX |
Sample PO # subject to change to final award 5/16/2021 5/31/2021 5/31/21 11618152R $ 176,961.00 $ 4,664.51 $ 172,296.49 <--EXAMPLE of invoice payment history
Invoice Discrepancies Line Item Order Number Ship To Name Product Description Part Number Qty Vendor Qty Qty Variance Contract Price
This is the negotiated price with FAA. Unit Cost Vendor Unit Cost Unit Cost Variance Ext Cost SOT Remarks NEW ORDER NUMBER NEW DELIVERY DATE
Service Log
| Service Type (1,2,3,4,5) | Customer Name | Date/Time Received (m/d/yyyy hh:mm) | Date/Time Responded (m/d/yyyy hh:mm) | Comments | |
| 3 | John Smith | 3/31/2021 10:00 | 3/31/2021 13:00 | <-- Example of vendor response time |
Customer Service Report Name Phone Email Description Melanie Morones: Melanie Morones:
| Specific projects - Long term projects, Shipping delays, Repeated invoice discrepancies. Please provide regular updates. | Date | Summary | Current Status | |||||
| John Smith | 405-555-1212 | john.smith@faa.gov | On time Oconus deliveries | 3/31/21 | Deliveries are taking excessive amount of time to be delivered. | In progress, investigating, resolved | <-- Example of long term issue. |
mailto:john.smith@faa.gov ANNUAL Resource_Conservation
| RESOURCE CONSERVATION/RECYCLING | FY21 | FY22 | FY23 | FY24 |
| 1. Total dollar amount of toner cartridges purchased in FY 202__? | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 2. Total dollar amount of recycled toner cartridges purchased in FY 202__? | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
File details come from the government source that posted it. Updated .