Att_L-11_O&S-CC.xlsx
XLSX spreadsheet 31 KB Posted
- Attached to
- Advanced Helicopter Training System (AHTS) TH-XX Aircraft Federal contract opportunity
- Solicitation number
- N6134019R0007
About this file
This Excel file provides inputs and calculations for estimating the variable and fixed costs of operating and supporting the L-11 aircraft over a 10-year period. Key details include: the aircraft will be owned by the government, based in Florida, and used for 89,918 flight hours per year. Variable costs are estimated based on a fuel consumption rate, fuel cost, maintenance labor rate, and lubrication costs. Fixed costs include maintenance labor and parts. No pricing, response dates, or incumbent information is included as this appears to be a cost modeling template rather than an active contract opportunity.
Attachment L-11
View the file
Other files for this federal contract opportunity
Show all 50
Advanced Helicopter Training System (AHTS) TH-XX Aircraft has more files on GovTribe.
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
Aircraft Selection
| L-11 Operation & Support - Contractor Contribution - Provided for Reference | |
| Aircraft Selection |
1 Customer: CNATRA 8 Date of Analysis:
2 Type of Operation: Government 9 Acquisition Method: Owned
| 10 | Type of Analysis: | Variable Cost | |||
| 3 | Aircraft: | ||||
| Production Years | 2010 -> | 11 | Depreciation Method: | None | |
| 4 | Current Status: | New |
| 12 | Start Month/Year: | 11/1/21 |
| 13 | Registration Number: |
| 5 | Base of Operation: | Florida | 14 | Serial Number: |
| 15 | Notes: | |||
| 6 | Gallons or Liters: | Gallons | ||
| 7 | Currency Symbol: | $ |
| Description | Input | |
| 1 | Use input provided | CNATRA |
| 2 | Use input provided | Government |
| 3 | Contractor dependent input | |
| 4 | Use input provided | New |
| 5 | Use input provided | Florida |
| 6 | Use input provided | Gallons |
| 7 | Use input provided | $ |
| 8 | Contractor dependent input | |
| 9 | Use input provided | Owned |
| 10 | Use input provided | Variable Cost |
| 11 | Use input provided | None |
| 12 | Use input provided | Nov-21 |
| 13 | Use input provided | Leave Blank |
| 14 | Use input provided | Leave Blank |
| 15 | Use input provided | Leave Blank |
Program Data
| L-11 Operation & Support - Contractor Contribution - Provided for Reference | |
| Program Data |
CNATRA
| Required Data -- Variable Cost Analysis | 18 | Block Speed | Kts | 110 | |||||
| 19 | Maintenance Labor Rate | $ | 95.00 | /MH | |||||
| 1 | Hours per Year | Avg Hours per Year | 20 | Fuel Consumption (Gallon) | /FH | ||||
| 21 | Fuel Cost | $ | 2.51 | /Gallon | |||||
| 2 | Program Length (Years) | 10 | Yrs | 22 | Lubricants | % | 3.00 | ||
| 23 | CO2 Emission (Metric Tonnes) | - 0 | /FH | ||||||
| 3 | Average Flight Hours/Yr: | 89,918.00 | /yr | 24 | CO2 Offset Cost | $ | - 0 | /Ton | |
| 4 | Cycles per Flt Hr (Airframe): | 10 | /FH | 25 | ATC & Navigation Fees | $ | - 0 | /FH | |
| 5 | Cycles per Flt Hr (Engine): | 2.5 | /FH | 26 | Landing & Parking Fees | $ | - 0 | /FH | |
| 27 | Crew Expenses | $ | - 0 | /FH | |||||
| Required Data -- Total Cost | 28 | Small Supplies/Catering | $ | - 0 | /FH | ||||
| 29 | Other Variable Cost | $ | - 0 | /FH | |||||
| Salaries/Aircraft | 30 | Hanger Cost | $ | - 0 | /Yr | ||||
| 6 | Crew/Aircraft Ratio | - 0 | 31 | Nav & Weather Service | $ | - 0 | /Yr | ||
| 7 | Pilots/Cockpit Crew | $ | - 0 | /Yr | |||||
| 8 | Flight Attendants | $ | - 0 | /Yr | 32 | Other Fixed Cost | $ | - 0 | /Yr |
| 9 | Maintenance Technicians | $ | - 0 | /Yr | 33 | Aircraft Cleaning per Month | $ | - 0 | /Mo |
| 10 | Other | $ | - 0 | /Yr | 34 | Insurance: Hull (% of Insured Value) | % | - 0 | |
| 11 | Benefits (% of Salaries) | % | - 0 | /Yr | 35 | Insurance: Liability | $ | - 0 | /Yr |
| 12 | First Year Training Cost | - 0 | 36 | Modernization | $ | - 0 | /Yr | ||
| 13 | Training Cost | $ | - 0 | /Yr | 37 | Refurbishing Cost | $ | - 0 | /Yr |
| 14 | Operations Overhead | % | - 0 | 38 | Computer Maint Mgmt System | $ | - 0 | /Yr | |
| 15 | Administrative Overhead | % | - 0 | ||||||
| 16 | Operations Overhead | $ | - 0 | /Yr | |||||
| 17 | Administrative Overhead | $ | - 0 | /Yr |
| Description | Input | |
| 1 | Use input provided | Avg Hours per Year |
| 2 | Use input provided | 10 |
| 3 | Use input provided | 89918.00 |
| 4 | Use input provided | 10 |
| 5 | Use input provided | 2.5 |
| 6 | input not needed in calculation | = 0 |
| 7 | input not needed in calculation | = 0 |
| 8 | input not needed in calculation | = 0 |
| 9 | input not needed in calculation | = 0 |
| 10 | input not needed in calculation | = 0 |
| 11 | input not needed in calculation | = 0 |
| 12 | input not needed in calculation | = 0 |
| 13 | input not needed in calculation | = 0 |
| 14 | input not needed in calculation | = 0 |
| 15 | input not needed in calculation | = 0 |
| 16 | input not needed in calculation | = 0 |
| 17 | input not needed in calculation | = 0 |
| 18 | Use input provided | 110 |
| 19 | Use input provided | 95.00 |
| 20 | input provided by C&dD | |
| 21 | Use input provided | 2.51 |
| 22 | Use input provided | 3.00 |
| 23 | input not needed in calculation | = 0 |
| 24 | input not needed in calculation | = 0 |
| 25 | input not needed in calculation | = 0 |
| 26 | input not needed in calculation | = 0 |
| 27 | input not needed in calculation | = 0 |
| 28 | input not needed in calculation | = 0 |
| 29 | input not needed in calculation | = 0 |
| 30 | input not needed in calculation | = 0 |
| 31 | input not needed in calculation | = 0 |
| 32 | input not needed in calculation | = 0 |
| 33 | input not needed in calculation | = 0 |
| 34 | input not needed in calculation | = 0 |
| 35 | input not needed in calculation | = 0 |
| 36 | input not needed in calculation | = 0 |
| 37 | input not needed in calculation | = 0 |
| 38 | input not needed in calculation | = 0 |
Financial Data
| L-11 Operation & Support - Contractor Contribution - Provided for Reference | |
| Financial Data |
CNATRA
| Owned Aircraft | |||
| 1 | Current Value | $ | - 0 |
| 2 | State Sales Tax/VAT | $ | - 0 |
| 3 | Training/Spares/Other | $ | - 0 |
| 4 | Refurb/Modification | $ | - 0 |
| 5 | Trade-in | $ | - 0 |
6 Aircraft Value: $ - 0
7 Insured Value: $ - 0
| Resale Value (Base) | 10 | Acquisition Fee: | $ | - 0 | |||||
| 8 | - with inflation | - 0 | % | 11 | Registration Fee/Yr: | $ | - 0 | ||
| - no inflation | 35 | % | 12 | State Use Tax/Yr: | - 0 | % | |||
| 9 | Brokerage Fee: | $ | - 0 | 13 | Property Tax/Yr | - 0 | % |
| Financial Data: | |||
| 14 | Inflation - General | 2.06 | %/Yr |
| 15 | Inflation - Parts | 3.50 | %/Yr |
16 100.00 %
Notes:
| Description | Input | |
| 1 | input provided by C&dD | |
| 2 | input not needed in calculation | = 0 |
| 3 | input not needed in calculation | = 0 |
| 4 | input not needed in calculation | = 0 |
| 5 | input not needed in calculation | = 0 |
| 6 | input not needed in calculation | = 0 |
| 7 | input not needed in calculation | = 0 |
| 8 | input not needed in calculation | = 0 |
| 9 | input not needed in calculation | = 0 |
| 10 | input not needed in calculation | = 0 |
| 11 | input not needed in calculation | = 0 |
| 12 | input not needed in calculation | = 0 |
| 13 | input not needed in calculation | = 0 |
| 14 | Use input provided | 2.06 |
| 15 | Use input provided | 3.50 |
| 16 | Use input provided | 100.00 |
Maintenance Data
| L-11 Operation & Support - Contractor Contribution - Provided for Reference | |
| Maintenance Data |
Maintenance (Average): 1 Parts: $ 0.00 /FH 2 Labor: 0.00 LH/FH
Warranty Years: 3 0
Maintenance: 4 Other: $ 0.00 /FH 5 0.00 /FH
Guaranteed Maintenance Plans:
6 Engine: No
7 Parts: No
8 Avionics: No
9 Aircraft: No
Notes:
| Description | Input | |
| 1 | Use input provided | Input provided by C&dD |
| 2 | Use input provided | Input provided by C&dD |
| 3 | Use input provided | Input provided by C&dD |
| 4 | Use input provided | Input provided by C&dD |
| 5 | Use input provided | Input provided by C&dD |
| 6 | Use input provided | No |
| 7 | Use input provided | No |
| 8 | Use input provided | No |
| 9 | Use input provided | No |
File details come from the government source that posted it. Updated .