[xls] · web viewdr. c p savage sr. montezuma, ga city of montezuma 53k osage city municipal osage...

Sponsor CIP worksheet, version 1.3 (11/22/2010)

Printed: 05/08/2023, 00:12:36 File: document.xls, Instructions

How to use the Sponsor CIP Datasheet

This file was created in Office (Excel) 2003. If you are using a newer version of Excel, you need to open the file in the native 2003 format. File also needs to be saved and returned to FAA in Excel 2003 format.

In our efforts to make providing your Capital Improvement Plan (CIP) information to FAA efficient, we have created this spreadsheet. The primary purpose is to encourage your use in submitting your 5-year CIP data; which helps us plan better. Also it is intended to be simple, standard, and reduce confusion about what you are requesting.

To fill it out, a user can only fill in information in the yellow fields. All other fields are protected to reduce chance for errors.

The first field is the beginning year of your 5-year CIP. It is important that this field have data correctly entered because it affects the requested funds year pull down menu. For example, if you are submitting your 5-year CIP to FAA beginning in fiscal year (FY) 2012 to FY 2016, you should enter "2012" in the Beginning Fiscal Year field. Please note, that the pull down menu is not limited to 5 years of information. If you have additional needs identified beyond the 5 years of your CIP, please show it. The 5-year CIP is the minimum information we need.

The LOCID stands for the location identifier code. If you are not sure what the LOCID is for your your airport, you may contact your local Airports District Office, or you can look the information up on the 5010 website. The website address is below, and you can look for the airport by either Airport Name, or Associated City. If you are a State, your LOCID convention is *XXS, where the 'XX' represents the 2 letter abbreviation of your State.

AirportIQ 5010

The last of the yellow fields where you can enter your CIP data is the fund amount under the different type of funding available. The total project cost is the sum of all the funds that you have identified. That field can not be altered.

The pull down menus are for the fiscal year of the planned work, and the project selection. The project selection menu corresponds to the FAA's ACIP standard descriptions. In addition, the work has been sorted by major category. This should make it easy to select projects. If you can not find a particular work that you would like to fund, it may be ineligible, so you would need to contact your local Airports District Office.

Use the Sponsor Comments-Justification Tab to enter relevant project information such as runway end, the need for the project, etc. You do not have to re-type the project or year information, it is automatically generated based on the information you provided in the 'Form' tab.

With respect to naming convention for the datasheet, it would be easier for FAA if sponsors replaced the 'XYZ' in the file name with the appropriate LOCID or Airport Name. Also, please change the fiscal year to correspond with the first year of your CIP request. For example, Jackson Hole, WY would name the file JAC CIP beginning FY-2012.xls If you have any questions about naming the file, please do not hesitate to contact your local Airports District Office.

http://www.gcr1.com/5010WEB/


Printed: 05/08/2023, 00:12:36 File: document.xls, Form

Northwest Mountain Airport 5-Year CIP Datasheet. Beginning in Federal Fiscal Year: 2012Northwest Mountain Region

Enter Beginning Fiscal Year: 2012 Fill In Yellow Boxes, OnlyEnter LOCID: ZZZ

Airport Name: Northwest MountainLocation: Seattle, WA #VALUE!Sponsor: City of SeattleService Level: Primary

Total Requested Funds & Sources

# Requested Project Total Cost Bonds

1 $1,885,000 $800,000 $250,000 $500,000 $167,500 $167,500

2 $500,000 $500,000 ###

3 $675,000 $500,000 $175,000 ###

4 $1,000,000 $1,000,000 ###

5 $1,000,000 $1,000,000 ###

6 $0 ###

7 $0 ###

8 $0 ###

9 $0 ###

10 $0 ###

11 $0 ###

12 $0 ###

13 $0 ###

14 $0 ###

16 $0 ###

17 $0 ###

18 $0 ###

19 $0 ###

20 $0 ###

21 $0 ###

22 $0 ###

23 $0 ###

24 $0 ###

25 $0 ###$5,060,000 $3,000,000 $0 $0 $800,000 $425,000 $500,000 $0 $167,500 $167,500#VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!

*FAA Share of Federal Funds: 95% for development projects. At Large and Medium Hubs, the percentage for noise projects may vary.

Requested Fund Year

Passenger Entitlement*

Cargo Apportioned*

Nonprimary Entitlement*

State Apportioned*

Discretionary Funds*

Passenger Facility Charge

Sponsor Match

State Match/ Other

E11

If you can not find a work item on the selection list, it may be ineligible. Please contact your local Airports District Office.


Printed: 05/08/2023, 00:12:36 Page: 3 of 10 File: document.xls, Sponsor Comments-Justification


# Requested Project Total Cost

1 2012 Noise - Mitigation measures for residences within 70 - 74 DNL $1,885,000

2 2013 Transfer Funds Out (identify sponsor funds are going to in comment field) $500,000

3 2013 Taxiway - Extend Taxiway $675,000

4 2015 Carry Over Funds $1,000,000

5 2014 Apron - Rehabilitation $1,000,000

6 Select Select Project $0










Requested Fund Year

C5





# Requested Project Total CostRequested Fund Year










$5,060,000

C5





Fill In Yellow Boxes, Only

Sponsor Comments, Justifications, and Remarks as Needed


Printed: 05/08/2023, 00:12:36 Page: 7of 10 File: document.xls, FAA Comments


Fill In Yellow Boxes, Only FAA Support

# Requested Project Total Cost FAA Comments and Remarks as Needed Yes No

1 2012 Noise - Mitigation measures for residences within 70 - 74 DNL $1,885,000

2 2013 Transfer Funds Out (identify sponsor funds are going to in comment field) $500,000

3 2013 Taxiway - Extend Taxiway $675,000

4 2015 Carry Over Funds $1,000,000

5 2014 Apron - Rehabilitation $1,000,000










Requested Fund Year

C5



Printed: 05/08/2023, 00:12:36 Page: 8of 10 File: document.xls, FAA Comments


Fill In Yellow Boxes, Only FAA Support

# Requested Project Total Cost FAA Comments and Remarks as Needed Yes NoRequested Fund Year











$5,060,000

C5



Printed: 05/08/2023, 00:12:36 File: document.xls, Funding Summary


Requested Project 2012 2013 2014 2015 2016 2017

Noise - Mitigation measures for residences within 70 - 74 DNL $1,050,000 $1,050,000 $0 $0 $0 $0 $0

Transfer Funds Out (identify sponsor funds are going to in comment field) $500,000 $0 $500,000 $0 $0 $0 $0

Taxiway - Extend Taxiway $675,000 $0 $675,000 $0 $0 $0 $0

Carry Over Funds $1,000,000 $0 $0 $0 $1,000,000 $0 $0

Apron - Rehabilitation $1,000,000 $0 $0 $1,000,000 $0 $0 $0

Select Project $0 $0 $0 $0 $0 $0 $0

Select Project $0 $0 $0 $0 $0 $0 $0

Select Project $0 $0 $0 $0 $0 $0 $0

Select Project $0 $0 $0 $0 $0 $0 $0

Select Project $0 $0 $0 $0 $0 $0 $0

Select Project $0 $0 $0 $0 $0 $0 $0

Select Project $0 $0 $0 $0 $0 $0 $0

Select Project $0 $0 $0 $0 $0 $0 $0

Select Project $0 $0 $0 $0 $0 $0 $0

Select Project $0 $0 $0 $0 $0 $0 $0

Select Project $0 $0 $0 $0 $0 $0 $0

Select Project $0 $0 $0 $0 $0 $0 $0

Select Project $0 $0 $0 $0 $0 $0 $0

Select Project $0 $0 $0 $0 $0 $0 $0

Select Project $0 $0 $0 $0 $0 $0 $0

Select Project $0 $0 $0 $0 $0 $0 $0

Select Project $0 $0 $0 $0 $0 $0 $0

Select Project $0 $0 $0 $0 $0 $0 $0

Select Project $0 $0 $0 $0 $0 $0 $0$4,225,000 $1,050,000 $1,175,000 $1,000,000 $1,000,000 $0 $0

Total AIP Requested

A5


2012 2013 2014 2015 2016 2017$0

$200,000

$400,000

$600,000

$800,000

$1,000,000

$1,200,000

Northwest MountainTotal AIP Requested

[xls] · web viewdr. c p savage sr. montezuma, ga city of montezuma 53k osage city municipal osage...

Documents