PWS Attachment 4 - Cost Summary Report.xlsx

This is a Cost Summary Report template designed to track financial expenditures for rotary airlift services supporting the North Warning System (NWS) in the Canadian Arctic. The template serves as an accounting document for the NWS Rotary Airlift Service contract (Solicitation FA489026R0015) and is structured to monitor cumulative costs across multiple budget categories and contract line item numbers (CLINs).

The report template captures four primary cost categories: Main Base Fee (measured in monthly quantities and rates), Rotary Wing Flying costs (tracked by actual hours flown and monthly rates), Reimbursable Expenses (including fuel expenses, per diem, landing fees, contingency flying hours, and contingency fuel transfer, with conversion from Canadian to U.S. dollars using Bank of Canada exchange rates), and Supplemental Base Fee and Bulk Fuel Transfer costs (measured in liters moved). Each section includes columns for monthly and cumulative funding allocations, actual expenditures in USD, and percentage of funds utilized. The template is currently blank with zero values across all line items, indicating it is a reporting framework awaiting population with actual contract performance data. This document will be used to monitor financial performance and resource consumption throughout the contract period for airlift services supporting U.S. Air Force and Canadian NORAD radar maintenance operations.