08_Monthly CDRL spdsht example.xlsx

XLSX spreadsheet 21 KB Posted

Attached to
Flight Program Participant Pilot Training Services Federal contract opportunity
Solicitation number
6973GH-20-D-00069
Issued by
Department of Transportation Federal Aviation Administration Non-Franchise Acquisition Services

About this file

This document includes an example monthly cost summary report and flight program schedule for a federal aviation contract. The report outlines labor rates, aircraft rental fees, pilot tracking, and event scheduling for aviation safety training services. It provides a template for the contractor to track costs by CLIN, labor hours, flight hours by aircraft type, personnel assignments, and event completion percentages. The related federal contract opportunity is a solicitation from the Federal Aviation Administration seeking aviation safety training and currency/proficiency services for flight program participants. Responses are due within 12 calendar days, and the award may be split between a Part 141 pilot school and separate contract support. The NAICS code is 611512 and it is set aside for small businesses with a size standard of $27.5 million. The contractor must provide management, instructor pilots, administrative support, flight dispatch, and aircraft to support flight training and currency services at Fort Worth Alliance Airport.

View the file

Other files for this federal contract opportunity

Other files attached to Flight Program Participant Pilot Training Services, newest first.
File Type Posted
6973GH-20-R-00069 Amendment 0003.pdf PDF
03_PWS 5Yr BE - Admin LH 20200629.pdf PDF
03_PWS 5Yr BE - Admin LH 20200629 CHANGES HIGHLIGHTED.pdf PDF
6973GH-20-R-00069 Amendment 0002.pdf PDF
02_PWS 5Yr 141 Cert 20200629.pdf PDF
12_Expanded 141 Hr Chart Final.pdf PDF
13_QUESTIONS AND ANSWERS.pdf PDF
02_PWS 5Yr 141 Cert 20200629 CHANGES HIGHLIGHTED.pdf PDF
11_Past Performance Questionaire 6973GH-20-R-00069.doc DOC document
6973GH-20-R-00069-0001.pdf PDF
07_CDRL 4 141 Cert.pdf PDF
01_Attachment 1 - Schedule B Table.doc DOC document
05_CDRL 2 Mtg Min Report.pdf PDF
10_Wage Determination 2015-5232v15_20191223.pdf PDF
06_CDRL 3 Phase Out Plan.pdf PDF
6973GH-20-R-00069.pdf PDF
03_PWS 5Yr BE - Admin LH 20200430.pdf PDF
02_PWS 5Yr 141 Cert 20200430.pdf PDF
09_TRAVEL AUTHORIZATION FORM.xlsx XLSX spreadsheet
04_CDRL 1 Monthly Report Form.pdf PDF
Show all 20

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

Funds Status

Monthly Cost Summary Report Example
Vendor Name:Contract #:Reporting Period:
DescriptionCLINTotal ValueMonthly CostCurrent CostFunded AmountExpended Amount / Total BilledFunds Remaining% Expended
LABORHourly RateHours for Current MonthCurrent Month Cost
Task 2A is FFP IPs, DOS, Admin. & PM for Phase In- Prior to Contract Full Start0001
Labor Hour:

Contract Pilots $_____/hr.

Admin $_____/hr.0002
Task 1 & 2B is 141 FFP IPs, DOS, & PM pd mthly. (Task 2 Phase Out is NSP but part of last month cost)0003AA
LABOR HOUR - O&A
141 Contractor Pilots - Not to Exceed 960 hrs.0003AB
Rental Fee (FFP)CLINSHourly FFP RateHours for Current MonthCurrent Month Cost
Single-Engine Piston Fixed Wing Rental Fee-
i.e. Cessna 172-G1000 $____/ mth (est. 1500 events annually)0004AA
Multi-Engine Piston Fixed Wing Rental Fee-Hourly FFP RateHours for Current MonthCurrent Month Cost
i.e. Piper PA-44-G1000 $____/ mth (est. 453 events annually)0004AB
i.e. Piper PA-44-G500 $____/ mth (est. 1141 events annually)0004AC
i.e. Piper PA-44-G500 $____/ mth (est. 90 events annually)0004AD
LTR Course 0129 i.e. Piper PA-44-G1000 $____/ mth (est. 100 events annually)0004AE
Single-Engine Turbine Helicopter Rental Fee-Hourly FFP RateHours for Current MonthCurrent Month Cost
i.e. Bell 206B3 @ $____/ mth (est. 330 events annually)0004AF
Helo Recurrent Course 0095 i.e. Bell 206B3 $____/ mth (est. 90 events annually)0004AG
Single-Engine Piston Helicopter Rental Fee-Hourly FFP RateHours for Current MonthCurrent Month Cost
R-44 $____/ mth (est. 112 events annually)0004AH
Rental Fee- Dry CostHourly FFP RateHours for Current MonthCurrent Month Cost
i.e. Cessna 172-G1000 @ $_____/hr0004AI
i.e. Piper PA-44-G1000 @ $_____/hr0004AJ
i.e. Piper PA-44-G500 @ $_____/hr0004AK
i.e. Bell 206B3 @ $_____/hr for an est. 120 hrs annually paid mthly as flown0004AL
R-44 @ $_____/hr0004AM

TRAVEL NOT TO EXCEED 0005 Reimb.

TOTAL

Flight Hour Totals

Monthly Flight Hour Totals
PoP:
Rental AircraftCLINSN Number

Barrett, Kadi D (FAA): (FAA):

Create a new line for each N # under each appropriate make/modelHours for Current MonthCumulatative Hrs Flown for Yr
Single-Engine Piston Fixed Wing
EBC i.e. Cessna 172-G10000004AA
Multi-Engine Piston Fixed WingN NumberHours for Current MonthCumulatative Hrs Flown for Yr
EBC i.e. Piper PA-44-G10000004AB
EBC i.e. Piper PA-44-G5000004AH
PE i.e. Piper PA-44-G5000004AD
LTR Course 0129 i.e. Piper PA-44-G10000004AE
Single-Engine Turbine HelicopterN NumberHours for Current MonthCumulatative Hrs Flown for Yr
EBC i.e. Bell 206B30004AF
Helo Recurrent Course 0095 i.e. Bell 206B30004AG
Single-Engine Piston HelicopterN NumberHours for Current MonthCumulatative Hrs Flown for Yr
R-440004AH
Dry RentalN NumberHours for Current MonthCumulatative Hrs Flown for Yr
i.e. Cessna 172-G10000004AI
i.e. Piper PA-44-G10000004AJ
i.e. Piper PA-44-G5000004AK
i.e. Bell 206B30004AL
R-440004AM

Pilot-Personnel Tracking

Pilot-Personnel Tracking
Management TeamKing AirASEL/AMELHelicopterAdministrativeGFP/ENew Hire DateTrainingPending DepartureLast Duty Day
John BrownBadge, Computer, Phone, Ipad
Jane DoeBadge, Ipad10/1/19BE completed 10/15/19
Brian SmithBadge, IpadASEL scheduled 12/1/19
Jason WrightBadge, Ipad12/15/19
Amber RobertsBadge, Computer, PhoneJanuary 2020
example provided for each position & type of tracking
can list however vendor decides is easiest for them to track all personnel & GFP/E assigned to each along with trainng required, start & departure dates.

Event Schedule %

Event Schedule %
Dates Events Performed:
ASEL FLIGHTSC-172MISSED FLIGHTSContractor Completion Percentage
COMPLETED
CTR IP
SchedCompWxMxASIIP
1080020100%
AMEL FLIGHTSPA44 G1000MISSED FLIGHTSContractor Completion Percentage
COMPLETED
CTR IP
SchedCompWxMxASIIP
7870422097%
AMEL EBC FLIGHTSPA44 G500MISSED FLIGHTSContractor Completion Percentage
COMPLETED
CTR IP
SchedCompWxMxASIIP
58561010100%
AMEL PE FLIGHTSPA44 G500MISSED FLIGHTSContractor Completion Percentage
COMPLETED
CTR IP
SchedCompWxMxASIIP
81750060100%
LTR FLIGHTSPA44 G1000MISSED FLIGHTSContractor Completion Percentage
COMPLETED
CTR IP
SchedCompWxMxASIIP
7870422097%
HEL EBC FLIGHTSBellMISSED FLIGHTSContractor Completion Percentage
COMPLETED
CTR IP
SchedCompWxMxASIIP
26260000100%
HEL Recurrent FLIGHTSBellMISSED FLIGHTSContractor Completion Percentage
COMPLETED
CTR IP
SchedCompWxMxASIIP
23230000100%
HEL Recurrent FLIGHTSR-44MISSED FLIGHTSContractor Completion Percentage
COMPLETED
CTR IP
SchedCompWxMxASIIP
1080020100%
SchedCompWxMxASIIP%
Monthly Total3643369415099%

File details come from the government source that posted it. Updated .