21R0202 - Attachment A1 Refund Calculations Report.pdf

SEA Card® Refund Report Requirements

The following requirements define how the Contractor shall produce the 1) DLA Energy SEA Card® Refund Summary report, 2) SEA Card® Fuel Transaction report and 3) SEA Card® Ancillary Transaction report. The reports are due on the fifth (5th) business day following the end of a fiscal quarter and should be sent to the individuals identified in the refund report distribution list.

SEA Card® Refund Summary Report

The Contractor shall insert the fiscal year and fiscal quarter of the refund period in the report header.

Column headers include SEA Card® Branch of Services, Ancillary Total, Fuel Total, SEA Card® Ancillary Refund per BOS, and SEA Card® Fuel Refund per BOS.

Row headers include Air Force, Army, Coast Guard, Federal Civilian Agencies, Navy and Total

The Contractor shall provide each branch of service (BOS) sale totals, which include ancillary and non-contract fuel reported in the respective row and column on the SEA Card® Refund Summary report.

The Contractor shall calculate the Total row by adding the amounts in each column.

NOTE: The example assumes the award included a half percentage basis point.

SEA Card® Refund Summary for Fiscal Year: 22 Quarter 1

SEA Card® Branch of Services

Ancillary Total Fuel Total SEA Card®Ancillary Refund per BOS

SEA Card® Fuel Refund per BOS

Air Force $5,000,000.00 $25,000,000.00 $25,000.00 $125,000.00

Army $2,000,000.00 $10,000,000.00 $10,000.00 $50,000.00

Coast Guard $200,000.00 $1,000,000.00 $1,000.00 $5,000.00

Federal Civilian Agencies

$350,000.00 $1,000,000.00 $1,750.00 $5,000.00

Navy $3,000,000.00 $5,000,000.00 $15,000.00 $25,000.00

Total $10,550,000.00 $42,000,000.00 $52,750.00 $210,000.00

SEA Card® Fuel Transaction Report

The report header is SEA Card® Fuel Transaction Report and include the date and time the report is generated.

Header2: SEA Card® Refunds for Fiscal Year: xx Quarter: x. The fiscal year and quarter should identify the fiscal year and fiscal quarter refund reporting period.

Header3: Refund period: Insert the date range of the refund period.

Column headings: Processing Date, DoDAAC, BOS, Fuel Type, Quantity, Unit of Measure, Unit Price, Total Dollar Amount, Delivery End Date, Port, Country, Order Number and Requisition Number and Transaction ID

Transaction details: Provide non-contract fuel transactions with a processing date that falls in the refund period.

Example of report:

SEA Card® Fuel Transaction Report

10/05/2022, 10:00 am ET

SEA Card® Refunds for Fiscal Year: 22 Quarter: 4 Refund period: 07/01/2022 to 09/30/2022

Processing DoDAAC BOS Fuel Type Quantity Unit of Meas Unit Price Total $ Amount Delivery End Date Port Country Order # Req # Trans ID 07/01/22 FP4477 AF MGO 20,000 GL $3.00 $60,000.00 06/01/22 Miami USA 4567 1234 3456 07/01/22 W23456 USA MGO 100 MT $400.00 $40,00.00 01/01/22 Portland USA 1234 4321 3457

SEA Card® Ancillary Transaction Report

The report header is SEA Card® Ancillary Transaction Report Header2: Provide the date report is generated.

Header3: Ancillary Transactions Header4: SEA Card® Refunds for Fiscal Year: 22 Quarter: 4. The fiscal year and quarter should identify the reporting period.

Header5: Refund period: Insert the fiscal quarter refund date range of the refund period.

Column headings: Processing Date, DoDAAC, BOS, Ancillary LOA, Ancillary Type, Quantity, Unit of Measure, Unit Price, Total Dollar Amount, Delivery End Date, Port, Country, Order Number, Requisition Number, and Transaction ID

Transaction details: Provide ancillary transactions with a processing date that falls in the refund period.

Example of report:

SEA Card® Ancillary Transaction Report

10/05/2022, 10:00 am EST

Ancillary Transactions SEA Card® Refunds for Fiscal Year: 22 Quarter: 4 Refund period: 07/01/2022 to 09/30/2022

Processing DoDAAC BOS Ancillary Ancillary Quantity Unit of Meas Unit Price Total $ Amount Delivery End Date Port Country Order # Req # Trans ID LOA Type 07/01/22 FP4477 AF 12334 Boom Fee 1 EA $3.00 $3.00 06/01/22 Miami USA 4567 1234 3456 07/01/22 W23456 USA 98765 Overtime 1 HR $100 $100.00 01/01/22 Portland USA 1234 4321 3457