Agenda 05/24/2011 Item #16G15/24/2011 Item 16.G.1.
EXECUTIVE SUMMARY
Approve budget amendments for $612,320 to increase budgeted revenues and budgeted expenses
for the sale and purchase of aviation fuel at Marco Island Executive Airport, Immokalee Regional
Airport, and Everglades Airpark.
OBJECTIVE: To approve budget amendments for $612,320 to increase budgeted revenues and
budgeted expenses for the sale and purchase of aviation fuel at Marco Island Executive Airport,
Immokalee Regional Airport, and Everglades Airpark.
CONSIDERATIONS: In preparing the FY 2011 budget, the unprecedented rise in fuel costs was not
anticipated. As shown in the table below, on average the current cost of a gallon of aviation fuel is more
than $1.50 higher than budgeted for FY 2011. The volume sold is not expected to be substantially
different from budgeted; however, the purchase price has increased. The budget authorization for fuel
purchases at the three County owned airports will be exhausted well before year end.
FISCAL IMPACT: The fiscal impact of these budget amendment requests net to zero. The budget for
Av Gas Fuel Expense and revenue will each be increased by $41,520 for the Everglades Airpark Cost
Center.
The budget for Av Gas Fuel Expense and revenue will each be increased by $82,560 for the Immokalee
Cost Center. The budget for Airport Jet A Fuel Expense and revenue will each be increased by $66,560
for the Immokalee Cost Center.
The budget for Av Gas Fuel Expense and revenue will each be increased by $124,320 for the Marco Cost
Center. The budget for Jet Fuel Expense and revenue will each be increased by $297,360 for the Marco
Cost Center.
LEGAL CONSIDERATIONS: This item raises no legal issues and requires majority vote for approval.
-JAK
GROWTH MANAGEMENT IMPACT: There is no Growth Management Impact associated with this
Executive Summary.
RECOMMENDATION: That the Board of County Commissioners approve budget amendments for
$612,320 for the purchase and sale of aviation fuel at Marco Island Executive Airport, Immokalee
Regional Airport, and Everglades Airpark.
Prepared by Debi Mueller, Office Manager, Collier County Airport Authority
Packet Page -1874-
Everglades
Immokalee
Marco
Av Gas
Av Gas
Jet A
Av Gas
Jet A
Budgeted Cost/Gallon
$ 3.47
$ 3.17
$
2.48
$
3.07
$
2.56
Average Cost/Gallon YTID
$ 3.75
$ 4.10
$
3.49
$
4.09
$
3.29
Current Cost (5/4/11)
$ 4.95
$ 4.91
$
3.97
$
4.93
$
3.93
Estimated Cost (5 % Increase)
$ 5.19
$ 5.16
$
4.16
$
5.18
$
4.13
Gallons to be Purchased
8,000
16,000
16,000
24,000
72,000
Cost to Purchase
$ 41,520.00
$ 82,560.00
$ 66,560.00
$ 124,320.00
$ 297,360.00
Aviation fuel is purchased in 8,000 - gallon
increments.
FISCAL IMPACT: The fiscal impact of these budget amendment requests net to zero. The budget for
Av Gas Fuel Expense and revenue will each be increased by $41,520 for the Everglades Airpark Cost
Center.
The budget for Av Gas Fuel Expense and revenue will each be increased by $82,560 for the Immokalee
Cost Center. The budget for Airport Jet A Fuel Expense and revenue will each be increased by $66,560
for the Immokalee Cost Center.
The budget for Av Gas Fuel Expense and revenue will each be increased by $124,320 for the Marco Cost
Center. The budget for Jet Fuel Expense and revenue will each be increased by $297,360 for the Marco
Cost Center.
LEGAL CONSIDERATIONS: This item raises no legal issues and requires majority vote for approval.
-JAK
GROWTH MANAGEMENT IMPACT: There is no Growth Management Impact associated with this
Executive Summary.
RECOMMENDATION: That the Board of County Commissioners approve budget amendments for
$612,320 for the purchase and sale of aviation fuel at Marco Island Executive Airport, Immokalee
Regional Airport, and Everglades Airpark.
Prepared by Debi Mueller, Office Manager, Collier County Airport Authority
Packet Page -1874-
COLLIER COUNTY
Board of County Commissioners
Item Number: 16.G.1.
5/24/2011 Item 16.G.1.
Item Summary: Approve budget amendments for $612,320 to increase budgeted
revenues and budgeted expenses for the sale and purchase of aviation fuel at Marco Island
Executive Airport, Immokalee Regional Airport, and Everglades Airpark.
Meeting Date: 5/24/2011
Prepared By
Name: BrueggemanDebra
Title: Operations Coordinator, Airport Authority
5/9/2011 1:50:40 PM
Submitted by
Title: Executive Director - Airport Authority,Airport Authority
Name: CurryChris
5/9/2011 1:50:42 PM
Approved By
Name: CurryChris
Title: Executive Director - Airport Authority,Airport Authority
Date: 5/12/20114:37:34 PM
Name: GreenwaldRandy
Title: Management/Budget Analyst,Office of Management & B
Date: 5/13/20118:13:32 AM
Name: KlatzkowJeff
Title: County Attorney,
Date: 5/13/2011 11:07:26 AM
Name: OchsLeo
Title: County Manager
Date: 5/15/2011 9:14:47 PM
Packet Page -1875-
BUDGET AMENDMENT REQUEST
495 Collier County Airport Authority
Fund No. Fund Description (type on line above)
5/24/2011 Item 16.G.1.
For Budget/Finance Use Only
BA# _
JE #
BAR#
APH Date
Date Prepared: 5/5/2011 (Attach Executive Summary)
Approved by BCC on: Item No.
Expense Budget Detail
Fund Center Title: Everglades Airpark Fund Center No.:
Funded Program (Project) Title: 5 -digit Fd Prog #:
(only one Fund Center /Funded Program should be entered into this section. If amendment is for Funded Proaram must enter Fund Center infn)
192350
Fund
Center
Funded
Program
Commit
Item
Commitment Item
Description
Increase
Decrease
Current
Budget
Revised
Budget
192350
642415
Av Gas Fuel Expense
41,520.00
49,800.00
91,320.00
Net Change to Budget $ 41,520.00
Expense Budget Detail
Fund Center Title: Fund Center No.:
Funded Program (Project) Title: 5 -digit Fd Prog #:
(only one Fund Center /Funded Program should be entered into this section. If amendment is for Funded Prnaram must enter F. and Cenrar infnl
Fund Funded
Center Program
Commit
Item
Commitment Item
Description
Increase
Decrease
Current
Bud et
Revised
Budget
Net Change to Budget $ -
Expense Budget Detail
Fund Center Title: Fund Center No.:
Funded Program (Project) Title: 5 -digit Fd Prog #:
(only one Fund Center /Funded Program should be entered into this section. If amendment is for Funded Pronram must center Punri r'entar infnl
Fund
Center
Funded
Pro ram
Commit
Item
Commitment Item Increase
Description Decrease
Current
Bud et
Revised
Budget
Net Lnange to Budget $
Packet Page -1876-
5/24/2011 Item 16.G.1.
Revenue Budget Detail
Fund Center Title: Everglades Airpark Fund Center No.:
Funded Program (Project) Title: 5 -digit Fd Prog #:
(only one Fund Center /Funded Program should be entered into this section. If amendment is for Funded Program, must enter Fund Center info)
192350
Fund
Center
Funded
Program
Commit
Item
Commitment Item
Description
Increase Current
Decrease Budget
Revised
Budget
192350
344240
Airport Av Gas Fuel
41,520.00 58,900.00
100,420.00
Net Change to Budget $ 41,520.00
EXPLANATION
Why are funds needed? (type below)
No additional funds are needed. The revenues derived from additional sales will offset the cost of additional fuel purchases.
Where are funds available? (type below)
N/A
REVIEW PROCESS
Cost Center Director": Date
Division Administrator": Date
Budget Department: Date
Agency Manager Date
Finance Department: Date
Clerk to the Board Admin: Date
Inputted by: Date
BA number (SAP)
If this is uploaded into Novus with an Executive Summary, no signatures are required from the Cost Center Director or
Division Administer.
If this is uploaded into Novus, please do NOT sent a paper copy of the Budget Amendment to the Office of Management and
Budget office, OMB will download all budget amendments from Novus and will process after the BCC meeting.
I :\ Forms\ County Forms\ Budget\ Budget Amendment Form.xls (excel format)
Packet Page -1877-
BUDGET AMENDMENT REQUEST
495
Fund No.
Date Prepared:
Approved by BCC on:
Collier County Airport Authority
Fund Description (type on line above)
5/24/2011 Item 16.G.1.
For Budget/Finance Use Only
BA#
JE #
BAR#
APH Date
5/5/2011 (Attach Executive Summary)
Expense Budget Detail
Item No.
Fund Center Title: IMM Regional Airport Fund Center No.: 192330
Funded Program (Project) Title: 5 -digit Fd Prog #:
(only one Fund Center /Funded Program should be entered into this section. If amendment is for Funded Proaram, must enter Fund Center info)
Fund
Center
Funded
Program
Commit
Item
Commitment Item
Description
Increase
Decrease
Current
Budget
Revised
Budget
192330
642415
Av Gas Fuel Expense
82,560.00
64,100.00
146,660.00
192330
64216
Jet A Fuel Expense
66,560.00
170,000.00
236,560.00
Net Change to Budget $ 149,120.00
Expense Budget Detail
Fund Center Title: Fund Center No.:
Funded Program (Project) Title: 5 -digit Fd Prog #:
(only one Fund Center /Funded Program should be entered into this section. If amendment is for Funded Proaram. must enter Fund Center info)
Fund Funded
Center Program
Commit
Item
Commitment Item
Description
Increase
Decrease
Current Revised
Budget Budget
Current
Bud et
Revised
Budget
Net Change to Budget $ -
Expense Budget Detail
Fund Center Title: Fund Center No.:
Funded Program (Project) Title: 5 -digit Fd Prog #:
(only one Fund Center /Funded Program should be entered into this section. If amendment is for Funded Proaram_ must PntPr Fund CPntPr infnl
Fund
Center
Funded
Program
Commit
Item
Commitment Item
Description
Increase
Decrease
Current
Bud et
Revised
Budget
Net Change to Budget $ -
Packet Page -1878-
5/24/2011 Item 16.G.1.
Revenue Budget Detail
Fund Center Title: IMM Regional Airport Fund Center No.:
Funded Program (Project) Title: 5 -digit Fd Prog #:
(only one Fund Center /Funded Program should be entered into this section. If amendment is for Funded Program, must enter Fund Center info)
192330
Fund
Center
Funded Commit
Program Item
Commitment Item
Description
Increase
Decrease
Current
Budget
Revised
Budget
192330
344240
Airport Av Gas Fuel
82,560.00
84,100.00
166,660.00
192330
344260
Airport Jet A Fuel
66,560.00
239,300.00
305,860.00
Net Change to Budget $ 149,120.00
EXPLANATION
Why are funds needed? (type below)
No additional funds are needed. The revenues derived from additional sales will offset the cost of additional fuel purchases.
Where are funds available? (type below)
N/A
REVIEW PROCESS
Cost Center Director *: Date
Division Administrator *: Date
Budget Department: Date
Agency Manager Date
Finance Department: Date
Clerk to the Board Admin: Date
Inputted by: Date
BA number (SAP)
If this is uploaded into Novus with an Executive Summary, no signatures are required from the Cost Center Director or
Division Administer.
If this is uploaded into Novus, please do NOT sent a paper copy of the Budget Amendment to the Office of Management and
Budget office, OMB will download all budget amendments from Novus and will process after the BCC meeting.
I:\ Forms\ County Forms\ Budget\ Budget Amendment Form.xls (excel format)
Packet Page -1879-
BUDGET AMENDMENT REQUEST
495
Fund No.
Date Prepared:
Approved by BCC on:
Collier County Airport Authority
Fund Description (type on line above)
5/24/2011 Item 16.G.1.
For Budget/Finance Use Only
BA#
JE #
BAR#
APH Date
5/5/2011 (Attach Executive Summary)
Expense Budget Detail
Item No.
Fund Center Title: Marco Island Executive Airport Fund Center No.: 192370
Funded Program (Project) Title: 5 -digit Fd Prog #:
(only one Fund Center /Funded Program should be entered into this section. If amendment is for Funded Program, must enter Fund Center info)
Fund
Center
Funded
Program
Commit
Item
Commitment Item
Description
Increase
Decrease
Current
Budget
Revised
Budget
192370
642415
Av Gas Fuel Expense
124,320.00
192,100.00
316,420.00
192370
64216
Jet A Fuel Expense
297,360.00
859,600.00
1,156,960.00
Net Change to Budget
Expense Budget Detail
Fund Center Title:
Funded Program (Project) Title:
(only one Fund Center /Funded Program should be entered into this section
$ 421,680.00
Fund Center No.:
5 -digit Fd Prog #:
If nmanrimant is fnr Pi-1 ri Prnnnom .et anfar Gnnrf r`nnfnr i.,f.,l
Fund
Center
Funded
Program
Commit
Item
Commitment Item
Description
Increase
Decrease
Current
Budget
Revised
Budget
Net Change to Budget
Expense Budget Detail
Fund Center Title:
Funded Program (Project) Title:
(only one Fund Center /Funded Program should be entered into this section
Fund Center No.:
5 -digit Fd Prog #:
If nmanrimant is fnr Fi inriari Prnnrnm oct nnfnr M-1 r`—+., i.,f.,\
Fund
Center
Funded
Program
Commit
Item
Commitment Item
Description
Increase
Decrease
Current
Budget
Revised
Budget
Net Change to Budget $
Packet Page -1880-
5/24/2011 Item 16.G.1.
Revenue Budget Detail
Fund Center Title: Marco Island Executive Airport Fund Center No.:
Funded Program (Project) Title: 5 -digit Fd Prog #:
(only one Fund Center /Funded Program should be entered into this section. If amendment is for Funded Program, must enter Fund Center info)
192370
Fund
Center
Funded
Program
Commit
Item
Commitment Item
Description
Increase
Decrease
Current
Budget
Revised
Budget
192330
344240
Airport Av Gas Fuel
124,320.00
282,100.00
406,420.00
192330
344260
Airport Jet A Fuel
297,360.00
1,605,000.00
1,902,360.00
Net Change to Budget $ 421,680.00
EXPLANATION
Why are funds needed? (type below)
No additional funds are needed. The revenues derived from additional sales will offset the cost of additional fuel purchases.
Where are funds available? (type below)
N/A
REVIEW PROCESS
Cost Center Director *: Date
Division Administrator *: Date
Budget Department: Date
Agency Manager Date
Finance Department: Date
Clerk to the Board Admin: Date
Inputted by: Date
BA number (SAP)
If this is uploaded into Novus with an Executive Summary, no signatures are required from the Cost Center Director or
Division Administer.
If this is uploaded into Novus, please do NOT sent a paper copy of the Budget Amendment to the Office of Management and
Budget office, OMB will download all budget amendments from Novus and will process after the BCC meeting.
I:\ Forms\ County Forms\ Budget\ Budget Amendment Form.xls (excel format)
Packet Page -1881-