2.01 Attachment 2 - J-024 Reporting Requirement Templates.xlsx
XLSX spreadsheet 383 KB Posted
- Attached to
- DOD CIO Wireless and Telecommunications Services Federal contract opportunity
- Solicitation number
- N00244-24-R-0003
About this file
This document contains templates and reporting requirements for a federal wireless and telecommunications services contract. The templates include data reports, spend usage reports, and order point of contact reports. Required data includes account and billing information, device and plan details, spend amounts by period of performance, and invoice reviews. The related opportunity is a solicitation from the Department of the Navy for a follow-on IDIQ contract covering mobility and telecommunication services for military members and federal civilians. The services will cover usage in the United States, territories, and internationally. The base period is one year with nine one-year option periods. Proposals are due by the closing date in accordance with Addendum 52.212-1. The NAICS code is 517112 and offerors must register in SAM to receive award.
View the file
Other files for this federal contract opportunity
Show all 30
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
J-024A Data Report
| Contractor Name: |
| Contract Number: |
Profile ID Billing/Vendor Account # Task Order/P-Card , UIC Number UIC Customer Name TOTAL Amount of Billed Spend Recurring Monthly Plan Costs Taxes, Gov't Surcharges & Fees International Travel Roaming
| Costs | Domestic Overages | Accessory Costs | "D" ELIN |
| Equipment Costs | Data Only Costs | Other Services Costs (M2M, IoT, 5G, Telematics, etc.) | TOTAL Data |
| Used GB | Number of days in billing cycle in month | Pay as you go | |
| Usage (GB) | 6 Month | ||
| Zero Use Smartphone Devices | 6 Month | ||
| Zero Use Data Only Devices | 6 Month | ||
| Zero Use Smartphone Dollars | 6 Month | ||
| Zero Use Data Only Dollars | Number of Smartphones | ||
| (iOS) | Number of Smartphones | ||
| (Android) | Number of Smartphones | ||
| (Other, i.e Windows) | Number of Feature/Cell | ||
| Phones (Voice/PTT) | Number of Tablets | ||
| (iOS-iPads) | Number of Tablets | ||
| (Android) | Number of Tablets | ||
| (Other) | Number of Data Cards/MiFi/Hotspots | Number of "Other" | |
| Devices | TOTAL | ||
| Devices | Agency |
(Air Force, Army, Marines, Navy, Other)
J-024A Report Notes Profile ID Billing/Vendor Account # Task Order/P-Card, UIC Number UIC Customer Name TOTAL Amount of Billed Spend Recurring Monthly Plan Costs Taxes, Gov't Surcharges & Fees International Travel Roaming
| Costs | Domestic Overages | Accessory Costs | "D" ELIN |
| Equipment Costs | Data Only Costs | Other Services Costs (M2M, IoT, 5G, Telematics, etc.) | TOTAL Data |
| Used GB | Number of days in billing cycle in month | Pay as you go | |
| Usage (GB) | 6 Month | ||
| Zero Use Smartphone Devices | 6 Month | ||
| Zero Use Data-Only Devices | 6 Month | ||
| Zero Use Smartphone Dollars | 6 Month | ||
| Zero Use Data-Only Dollars | Number of Smartphones | ||
| (iOS) | Number of Smartphones | ||
| (Android) | Number of Smartphones | ||
| (Other, i.e Windows) | Number of Feature/Cell | ||
| Phones (Voice/PTT) | Number of Tablets | ||
| (iOS-iPads) | Number of Tablets | ||
| (Android) | Number of Tablets | ||
| (Other) | Number of Data Cards/MiFi/Hotspots | Number of "Other" | |
| Devices | TOTAL | ||
| Devices | Agency |
(Air Force, Army, Marines, Navy, Other)
a. Profile ID
b. Billing/Vendor Account #
c. Task Order/GP-Card UIC Number
d. Customer UIC
e. Customer Organization Name
f. Total Amount of Monthly Bill including ALL accrued costs for the month (MRC additional equipment, overages, and other costs)
g. Regular Monthly Recurring Plan Costs
h. Taxes, Government Surcharges and Fees
i. International Roaming Costs
j. Other Domestic Overages
k. Device Accessory Costs
l. Other Wireless Equipment Costs purchased (new current market offering (not one-generation behind)) devices, tablets, other within scope equipment
m. Data Only Costs
n. All other Non-Standard ELIN Service Plan costs
o. Total data used
p. Number of days in billing cycle each month
q. Actual Pay As You Go Data Usage
r. Number of smartphone devices not used in 6-months
s. Number of data-only devices (i.e. MiFi devices, tablets, etc.) not used in 6-months
t. Costs of smartphone devices not used in 6-months
u. Costs of data-only devices (i.e. MiFi devices, tablets, etc.) not used in 6-months
v. - ad. Customer Device Type Inventory Numbers
ae. Total Number of Devices Per Account/Customer
af. DoD Customer Agency Information (Army, Air Force, Navy, Marines, 4th Estate) ae.
af.
ag.
J-024B Spend Usage Report
| Contractor Name: |
| Contract Number: |
| ACCOUNT INFORMATION | CUSTOMER (END USER) | ORDERING OFFICER | INVOICE PRIMARY TASK ORDER POC | SECONDARY TASK ORDER | WIRELESS MANAGER, CONTRACT SPECIALIST AND/OR CONTRACTING OFFICER, NOTIFICATION (60-80%) | BASE PERIOD | OPTION 1 PERIOD | OPTION 2 PERIOD | OPTION 3 PERIOD | OPTION 4 PERIOD | ||||||||||
| PROFILE ID | WAWF | |||||||||||||||||||
| YES/NO | TASK ORDERS # GCPC PURCHASE | UIC | CONTRACT #/ | |||||||||||||||||
| ACCOUNT NUMBER | COMPANY NAME | NAME | PHONE NUMBER | EMAIL ADDRESS | NAME | PHONE NUMBER | EMAIL ADDRESS | |||||||||||||
| POC FOR INVOICES | AGENCY | NAME (60-80%) | PHONE NUMBER | |||||||||||||||||
| (60-80%) | EMAIL ADDRESS | |||||||||||||||||||
| (60-80%) | SECONDARY POC EMAIL ADDRESS | THIRD POC EMAIL ADDRESS | AWARD DATE | POP START DATE | POP END DATE | OBLIGATED / AWARD AMOUNT | MODIFICATION AMOUNTS | CURRENT TOTAL | EXERCISE DATE | POP START DATE | POP END DATE | AWARD AMOUNT (ON BASIC AWARD) | AMOUNT OBLIGATED ON OPTION EXERCISE | MODIFICATION AMOUNTS | CURRENT TOTAL |
watsoki: TOTAL AMOUNT (INCLUDES AMOUNT ON BASE + AMOUNT OBLIGATED + MOD AMOUNT) EXERCISE DATE POP START DATE POP END DATE AWARD AMOUNT (ON BASIC AWARD) AMOUNT OBLIGATED ON OPTION EXERCISE MODIFICATION AMOUNTS CURRENT TOTAL watsoki: TOTAL AMOUNT (INCLUDES AMOUNT ON BASE + AMOUNT OBLIGATED + MOD AMOUNT) EXERCISE DATE POP START DATE POP END DATE AWARD AMOUNT (ON BASIC AWARD) AMOUNT OBLIGATED ON OPTION EXERCISE MODIFICATION AMOUNTS CURRENT TOTAL watsoki: TOTAL AMOUNT (INCLUDES AMOUNT ON BASE + AMOUNT OBLIGATED + MOD AMOUNT) EXERCISE DATE POP START DATE POP END DATE AWARD AMOUNT (ON BASIC AWARD) AMOUNT OBLIGATED ON OPTION EXERCISE MODIFICATION AMOUNTS CURRENT TOTAL watsoki: TOTAL AMOUNT (INCLUDES AMOUNT ON BASE + AMOUNT OBLIGATED + MOD AMOUNT) CURRENT CONTRACT VALUE OR SPEND TO DATE (ALL Tos and GCPC) halltw: GRAND TOTAL AMOUNT LISTED ON THE TASK ORDER THAT INCLUDES BASE, OPTION PERIODS AND 6 MONTH. (FORMULA INCLUDES ALL OPTION YEARS BUT THE BASE YEAR IS SUBTRACTED OUT COLUMN "AM" - AMOUNT BASE YEAR ON THE OPTION YEAR TO ENSURE ACCURATE TOTALS ) THIS IS TO AVOID DUPLICATE CACULATIONS AS BASE YEAR AMOUNT IS CACULATED FROM COLUMN "AH"
Fleming, Brittanie: Fleming, Brittanie:
LOI, but no doc to exercise Option Year 2 watsoki: TOTAL AMOUNT (INCLUDES AMOUNT ON BASE + AMOUNT OBLIGATED + MOD AMOUNT)
Fleming, Brittanie: Fleming, Brittanie:
PO Closed Gotwalt, Tricia: Gotwalt, Tricia:
unable to read last name on document watsoki: TOTAL AMOUNT (INCLUDES AMOUNT ON BASE + AMOUNT OBLIGATED + MOD AMOUNT)
Fleming, Brittanie: Fleming, Brittanie:
Error opening Option Year 2 funding Fleming, Brittanie: Fleming, Brittanie:
PO Closed Fleming, Brittanie: Fleming, Brittanie:
Option Year document will not load Fleming, Brittanie: Fleming, Brittanie:
MOD 3 doc is missing which may account for missing monie watsoki: TOTAL AMOUNT (INCLUDES AMOUNT ON BASE + AMOUNT OBLIGATED + MOD AMOUNT)
Fleming, Brittanie: Fleming, Brittanie:
Only quote is loaded, and not actual PO document Fleming, Brittanie: Fleming, Brittanie:
No PO doc attached in EPOD. Only quote watsoki: TOTAL AMOUNT (INCLUDES AMOUNT ON BASE + AMOUNT OBLIGATED + MOD AMOUNT) halltw: GRAND TOTAL AMOUNT LISTED ON THE TASK ORDER THAT INCLUDES BASE, OPTION PERIODS AND 6 MONTH. (FORMULA INCLUDES ALL OPTION YEARS BUT THE BASE YEAR IS SUBTRACTED OUT COLUMN "AM" - AMOUNT BASE YEAR ON THE OPTION YEAR TO ENSURE ACCURATE TOTALS ) THIS IS TO AVOID DUPLICATE CACULATIONS AS BASE YEAR AMOUNT IS CACULATED FROM COLUMN "AH" Fleming, Brittanie: Fleming, Brittanie:
Option Year doc not loaded Fleming, Brittanie: Fleming, Brittanie:
Option Year 2 doc would not load
J-024B Report Notes
| a. | List the total amount of spend to date. Specify timeframe of spend data (for example: from "this date" to "that date") include both Order and GPC purchase information, as appropriate for the order include total spend for Order or GPC purchase inclusive of any modifications as appropriate |
| b. | List devices customers are acquiring specify timeframe (for example: from "this date" to "that date") of devices purchased list totals for each device to include model/type info (# of Voice Phones, #Smartphones, #Tablets, # of Data cards, # of other devices) list number of free devices acquired (quantity and model that are free or with each plan) list number of devices purchased outside the plan offering by device type, include total dollars |
| c. | List number of plans ordered and Identify timeframe of data (for example: from "this date" to "that date") ordered and list dollars obligated per item |
| d. | List ordered items on the Other Plan and the International Plan by item, unique number specify timeframe of data (for example: from "this date" to "that date") list total quantities and dollars obligated by item (plans & devices) |
| e. | Total amount of overages dollars specify timeframe (for example: from "this date" to "that date") |
| f. | Trend analysis and optimization recommendations at the Order Level |
| g. | Totals by Period of Performance Info list obligated amount per order period of performance list the Period of Performance per order identify if Option Periods are included in basic Order and the Period of Performance (e.g. from "this date" to "that date") |
| h. | Invoice Reviews list invoices by Order number or GPC number list Order award/obligated amounts, amounts added or deducted via modification, current order value, amount previously invoiced, current invoice amount and remaining amount (to be invoiced) |
J-024C Order POC Report
| Contractor Name: |
| Contract Number: |
GPC Indicator Task Order # Customer Company Name BAN UIC Status Begin Date End Date Option Period Contact Name Contact Email
File details come from the government source that posted it. Updated .