SOW Attachment V Monthly Activity Report (MAR) Template.xlsx
XLSX spreadsheet 138 KB Posted
- Solicitation number
- 697DCK-25-F-00368
About this file
This is a Monthly Activity Report (MAR) template for the FAA Print Consumables IDIQ contract, designed to track and document contractor performance across multiple reporting categories. The template establishes standardized data collection requirements for four primary reports: Financial & Data Report, Delivery Report, Service Log, and Customer Service Report, along with supplementary discrepancy tracking sections.
The Financial & Data Report requires documentation of all orders including ordered date, line item numbers, vendor order numbers, ship-to information, item descriptions, manufacturer details, part numbers, quantities, pricing (list price, discounts, unit cost, extended cost), and shipping charges. The Delivery Report tracks the same order information but focuses on delivery metrics, including required and actual delivery dates, shipping methods and carrier tracking information, recipient signatures, delivery locations, and CONUS/OCONUS designation. The Service Log captures customer service interactions with service type categorization (1-5 categories covering acknowledgments, quotes, customer service responses, recycling requests, and other services), timestamps for receipt and response, and comments. The template includes detailed pick lists for FAA Lines of Business (covering 50+ organizational units including aeronautical centers, regional offices, and specialized services) and shipping methods (Standard, 2nd Day, Overnight, Other). Additional sections address Quote Discrepancies and Invoice Discrepancies, documenting reasons for order placement failures and quantity or cost variances with required corrective actions and updated order information. The template supports the FAA's 750+ item printer consumables contract requiring monthly performance visibility and accountability tracking.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| SIR Attachment 2 Pricing Model Evaluation Worksheet - REVISED FINAL - 08-06-26.xlsx | XLSX spreadsheet | |
| SOW Attachment IV - Printer Consumables List.xlsx | XLSX spreadsheet | |
| SIR Attachment 3 - Past Experience Information Form 05-18-2026.docx | DOCX document | |
| SOW Attachment II CONUS Quote Response (CONUS Template).xlsx | XLSX spreadsheet | |
| SOW Attachment I Quote Request Form (CONUS and OCONUS) Template.xlsx | XLSX spreadsheet | |
| Printer Consumables SOW - 05-20-26.pdf | ||
| 06- SIR_697DCK-25-R-00368_final_08112026.pdf | ||
| SIR Attachment 4 - Past Performance Questionnaire_08112026.docx | DOCX document | |
| SIR Attachment 5 - Proposal Checklist_08112026.pdf | ||
| SOW Attachment III OCONUS Quote Response (OCONUS Template).xlsx | XLSX spreadsheet |
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 Printer Consumables Report headers, Definitions, and Attributes
| Financial & Data Report | ||
| Header Name | Definition | Attribute |
| Ordered Date | Date Order was Placed | Date |
| Line Item | SOT Line Item Order/REQ and RITM numbers assigned at by FAA | Text |
| Vendor Order Number | Unique order number assigned by contractor | Text |
| Ship To Name | self-explanatory | Text |
| Address 1 | self-explanatory | Text |
| Address 2 | self-explanatory | Text |
| City | self-explanatory | Text |
| State | self-explanatory | Text |
| Zip Code | self-explanatory | Text |
| Item Description | Description of item purchased | Text |
| Line of Business (LOB) | Identify the LOB of the buyer | Text |
| Organization or Regional Group (ORG) | Identify the ORG of the buyer | Text |
| Manufacturer | Manufacturer Brand Name | Text |
| Part Number | Vendor Part Number (if different from OEM, otherwise use OEM part number) | Text |
| OEM Part Number | Manufacturer OEM or Part Number | Text |
| Item Code (SKU) | Vendor's SKU (Stock Keeping Unit) Code | Text |
| Quantity | Quantity of item purchased | Number |
| List Price (MSRP) | Manufacturer List price | Currency |
| Discount | Negotiated percent discount of List price | Percent |
| Unit cost | Price after discount has been applied | Currency |
| Ext Cost | Quantity x Contract Price | Currency |
| Shipping | Shipping Cost | Currency |
| Total Cost | Ext Cost + Shipping | Currency |
| Delivery Report | ||
| Header Name | Definition | Attribute |
| Ordered Date | Date Order was Placed | Date |
| Line Item | SOT Line Item Order/REQ and RITM numbers assigned at by FAA | Text |
| Vendor Order Number | Unique order number assigned by contractor | Text |
| Required Delivery Date | Projected Delivery Date based on contractual requirements | Date |
| Ship To Name | self-explanatory | Text |
| Address 1 | self-explanatory | Text |
| Address 2 | self-explanatory | Text |
| City | self-explanatory | Text |
| State | self-explanatory | Text |
| Zip Code | self-explanatory | Text |
| Actual Delivery Date | Date Order was received at final destination | Text |
| Shipping Method | Shipping Service Level Utilized (See Pick List) | Text |
| Shipper Tracking # | Carrier Tracking Number and Hyperlink | Text |
| Recipient signature | Name of Person who signed for package as Proof of Delivery | Text |
| Location delivered | Identify location package was left (i.e. Front Desk, Mailroom, etc.) | Text |
| Conus/Oconus | Indicate One (CONUS=Within continental U.S. / OCONUS=Outside continental U.S.) | Text |
Pick Lists
| PICK LISTS | ||||
| FAA Lines of Business | FAA Organizational Office/Region | Shipping Method | ||
| LOB | Title | ORG | Title | Standard |
| AAE | Audit and Evaluation | AC | Aeronautical Center | 2nd Day |
| ABA | Financial Services | AL | Alaskan Region | Overnight |
| ACE | Materials & Services | CE | Central Region | Other (Specify) |
| ACQ | Acquisition and Business Services | CT | Technical Center | |
| ACR | Civil Rights | EA | Eastern Region | Service Type |
| AEP | Policy, Planning and Environment | EU | International Area Offices | 1 |
ID#AAAAQ84Pv6Y Melanie Morones (2021-10-18 14:52:01)
| Send FAA personnel email reply - "Acknowledged" | Request for quote acknowleged (Two (2) business hrs) | |||||
| AFN | Finance and Management | GL | Great Lakes Region | 2 | Completed quote returned (within two (2) business days) | |
| AGC | Chief Counsel | NE | New England Region | 3 | Customer Service (within two (2) business hrs) | |
| AGI | Government & Industry | NM | Northwest Mountain Region | 4 | Request for Recycling Return Labels/Boxes | |
| AHR | Human Resource Management | SO | Southern Region | 5 | Other | |
| AIO | Information Services | SW | Southwest Region | |||
| 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 Ordered Date Line Item Vendor Order Number Ship To Name Address 1 Address 2 City State Zip Code Description LOB ID#AAAAT7B5rK0 Faye Latzie (2022-01-06 18:51:59) empty ORG ID#AAAAT7B5rK4 Faye Latzie (2022-01-06 18:52:08) empty Manufacturer Part Number OEM Part Number ID#AAAAT7B5rK8 Faye Latzie (2022-01-06 18:52:40) empty Item Code (SKU) ID#AAAAT7B5rLA Faye Latzie (2022-01-06 18:52:45) empty Qty List Price (MSRP) ID#AAAAQ84Pv6g Melanie Morones (2021-10-18 14:52:01) Manufacture Suggested Retail Price (MSRP) Discount ID#AAAAT7B5rLE Faye Latzie (2022-01-06 18:53:23) picklist tab Unit Cost Ext Cost Shipping Total Cost ID#AAAAQ84Pv6M Melanie Morones (2021-10-18 14:52:01) Extended cost plus shipping cost.
ID#AAAAT7B5rK0 Faye Latzie (2022-01-06 18:51:59) empty ID#AAAAT7B5rK4 Faye Latzie (2022-01-06 18:52:08) empty ID#AAAAT7B5rK8 Faye Latzie (2022-01-06 18:52:40) empty ID#AAAAT7B5rLA Faye Latzie (2022-01-06 18:52:45) empty Recycled (Y or N)
Delivery Report Ordered Date Line Item Vendor Order Number Required Delivery Date ID#AAAAQ84Pv6U Melanie Morones (2021-10-18 14:52:01) The projected delivery date based on contractual requirements (order date plus six business days). Ship To Name Address 1 Address 2 City State Zip Code Actual Delivery Date Shipping Method ID#AAAAQ84Pv6Q Melanie Morones (2021-10-18 14:52:01) Melanie Morones: Carrier used - UPS, Fedex, DHL, internal transport services, etc. shipping service utilized (see Pick List) Shipper Tracking # ID#AAAAQ84Pv6o Melanie Morones (2021-10-18 14:52:01) Carrier tracking number and hyperlink Recipient signature ID#AAAAQ84Pv6k Melanie Morones (2021-10-18 14:52:01) Person who signs for package Location delivered Conus/Oconus
Service Log Service Type (1,2,3,4 or 5) Customer Name Date/Time Received (m/d/yyyy hh:mm) Date/Time Responded (m/d/yyyy hh:mm) Comments
Customer Service Report Name Phone Email Description ID#AAAAQ84Pv6I Melanie Morones (2021-10-18 14:52:01) Specific projects - Long term projects, Shipping delays, Repeated invoice discrepancies. Please provide regular updates. Date Summary Current Status
Quote Discrepancies Ordered Date Line Item Ship To Name Address 1 Address 2 City State Zip Code Description Manufacturer Part Number OEM Part Number Item Code (SKU) Qty List Price (MSRP) Discount Unit cost Ext cost Shipping Total Cost Vendor Order Number ID#AAAAQ84Pv6c
(FAA) (2021-10-18 14:52:01)
Reason Order was not placed.
1 - Backordered 2 - Discontinued 3 - Item # not Valid 4 - Item not Available 5 - Restricted 6 - N/A Delivery date Tracking Info Reason for discrepancy Corrective action taken
Invoice Discrepancies Line Item Vendor Order Number Ship To Name Product Description Part Number Qty Vendor Qty Qty Variance Unit Cost Unit Cost Variance Ext Cost SOT Remarks NEW ORDER NUMBER NEW DELIVERY DATE
File details come from the government source that posted it. Updated .