SOW Attachment V Monthly Activity Report (MAR) Template.xlsx
XLSX spreadsheet 138 KB Posted
- Solicitation number
- 697DCK-25-R-00368
About this file
This is a Monthly Activity Report (MAR) template attachment for the FAA's printer consumables IDIQ contract solicitation. The template is an Excel-based form designed to track and document contractor activities on a monthly basis throughout the contract performance period. As a template document, it does not specify required products or services but rather provides the standardized format that the successful contractor must use to report monthly activities to the FAA Office of Information and Technology.
The MAR template serves as a compliance and reporting mechanism for the five-year IDIQ contract (one base year plus four one-year ordering periods) supporting the FAA's toner and printer consumable needs across approximately 750+ items. Contractors awarded under this Small Business Set-Aside solicitation (NAICS 325992, 1500-employee size standard) will be required to complete and submit the MAR according to the schedule and specifications outlined in the Statement of Work, enabling the FAA to monitor contractor performance and activity levels throughout the contract term.
View the file
Other files
Show all 23
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 .