HomeMy WebLinkAbout08052014-packet UKIAH AIRPORT COMMISSION
OLD F.S.S. Building
1403 South State Street, Ukiah, CA
Tuesday, August 5, 2014
6:00 p.m.
AGENDA
1. CALL TO ORDER
2. PLEDGE OF ALLEGIANCE
3. APPROVAL OF MINUTES — June 3, 2014
4. COMMENTS FROM AUDIENCE ON NON-AGENDA ITEMS
The Ukiah Airport Commission welcomes input from the audience. In order for
everyone to be heard, please limit your comments to three (3) minutes per person
and not more the (10) minutes per subject. The Brown Act regulations do not allow
action to be taken on audience comments.
5. DISCUSSION / ACTION
A. Budget 2014-15 /Airport Monthly Financial Report
B. Airport Maintenance
C. Airport Commission Recording Secretary
D. Fuel Tank
E. Airport Business Plan
6. REPORTS
A. Airport Day
B. ALP Update
7. AGENDA ITEMS FOR NEXT MONTH
8. COMMISSIONER/STAFF COMMENTS
9. ADJOURNMENT
1 UKIAH REGIONAL AIRPORT COMMISSION
2 June 3, 2014
3 Minutes
4
5 COMMISSIONERS PRESENT STAFF PRESENT
6 Carl Steinmann, Chair Greg Owen, Airport Manager
7 Eric Crane Ken Ronk, Airport Assistant
8 Dottie Deerwester Cathy Elawadly, Recording Secretary
9 Don Albright
10 Gordon Elton
11
12 COMMISSIONERS ABSENT OTHERS PRESENT
13
14
15 1. CALL TO ORDER
16 The Airport Commission meeting was called to order by Chair Steinmann at 6:00 p.m. at the Ukiah
17 Regional Airport, Old Flight Service Station, 1403 South State Street, Ukiah, California. Roll Call was
18 taken with the results listed above.
19
20 2. PLEDGE OF ALLEGIANCE - Everyone recited the pledge of allegiance.
21
22 3. APPROVAL OF MINUTES— May 6, 2014
23
24 M/S Elton/Albright to approve May 6, 2014 minutes, as submitted. Motion carried by an all AYE voice
25 vote of the Commissioner's present.
26
27 4. AUDIENCE COMMENTS ON NON-AGENDA ITEMS
28
29 5. DISCUSSION/ACTION
30
31 5A. Budget 2014-15
32 Airport Manager Owen:
33 • Was hoping the new City Finance Director would be present tonight to discuss the Airport Budget
34 for FY 2014-15 and/or any budget-related questions the Commission may have but was unable
35 to do so for family reasons.
36 • City budget hearings will take place in latter June.
37 • Referred to Airport budget 2014-15 that he has presented to City Hall Administration and noted
38 there is always the likelihood some of the line items will change and go either up or down
39 depending on the budget, such as PERS retirement, Group insurance, etc.
40
41 Commissioner Elton:
42 • Was a `projected actual' prepared for this year? Sees this as a helpful tool for comparison
43 purposes from one budget year to another.
44 • Fuel sales seem high for where we are this budget year.
45 • The fuel sales report indicates the gross revenue for 2013/14 is approximately $700,000 and this
46 is for 10 months, i.e., July 2013 thru April 2014. To meet the projected annuals, is it possible for
47 the revenue to increase $300,000 more in approximately two months when Calfire is purchasing
48 fuel?
49 • Is it reasonable to expect that the Airport will go back more to the average fuel sold versus having
50 a light fuel sales year?
51 • Questioned the `averaging' methodology/strategy when reviewing the gross revenue figures for
52 past fiscal years?
53 • What mark-up figure is used to make certain of a profit margin?
54 • Related to personnel expenses, asked about how staffing is configured into the budget.
55
MINUTES of the Ukiah Airport Commission June 3, 2014
Page 1
1 Airport Manager Owen:
2 • Confirmed a projected actual was prepared for this budget year.
3 • Fuel sales figure represents an average. Talked about Jet A fuel sales comparatively for various
4 budget years and noted Jet A fuel sales in May 2014 were unusually high for this time of year.
5 May 2013 the Airport sold 7400 gallons of Jet A compared to 9900 gallons for May 2014. There
6 has been a significant increase in Jet A fuel sales for the month of May.
7 • The monthly financial statement for the Airport shows full year projections. Typically in June the
8 Airport sees $100,000 in fuel sales. In FY 2011-12, fuel sales for July and August were well over
9 $100,000 for each month. It is unlikely the Airport will see $200,000 or$300,000 in fuel sales for
10 the month of June.
11 • Noted last year's fire season was low in terms of fuel sales. Again, projections relative to fuel
12 revenue are based on the average of fuel sold and not so much on what was sold for last year
13 and/or what has been sold for this fiscal year so far.
14 • It is difficult to predict fuel sales for any given fiscal year. The Airport makes most of its revenue
15 from fuel sales. Fuel sales increase when there is a good fire season. Calfire arrived early this
16 year and this is the reason for the increase in fuel sales for the month of May.
17 • `Averaging' is also related/based on the Airport's new pricing mechanism and explained how this
18 works particularly for Calstar fuel sales. Calstar is also purchasing more fuel now than in the past.
19 Looking at the gross revenue for past fiscal years, i.e., 2011/12 and 2012/13, the `averaging'
20 methodology allows for compensation for years when sales were down
21 • The Airport is presently looking at $820,000 in fuel sales through May 2014 and anticipates
22 another $100,000 or more which will be close to the projected sales figure of $900,000 or
23 $1,000,000.
24 • Fuel mark-up is based on $.95 per gallon for Avgas and $2.10 per gallon for Jet A fuel.
25 • The budget reflects current staffing. Airport staffing includes two full-time persons, one 32-hour
26 position, and three one-thousand hour positions and this is reflected in the current budget.
27
28 There was Commission discussion concerning staffing, current status of staffing, associated benefit
29 expenses for staffing, how this works and how benefit expenses are accounted for in the budget.
30
31 Chair Steinmann asked about line item Munis#77725200, how `utilities' is accessed/assigned noting the
32 amount is the same for every budget.
33
34 Airport Manager Owen:
35 • `Utilities' expense is assigned by City Hall administration.
36
37 Commissioner Albright:
38 • Asked about the fuel mark-up and profit margins for this fiscal year.
39
40 Airport Manager:
41 • The margins are likely different when looking at the fuel revenue because Calstar now pays more
42 for fuel where the mark-up is higher.
43
44 5B. Airport Maintenance
45 Airport Manager Owen:
46 • Gave an update regarding maintenance tasks completed at the Airport in preparation for Airport
47 Day. Of significance is the abating of weeds on the runway/taxiway which has dramatically
48 improved the appearance and surface area. The riding mower as opposed to a weed eater was
49 most effective in being able to closely abate weeds in and around the runway. The procedure is
50 labor intensive and the task must be well coordinated with the other duties such as fueling that
51 must be performed on the Airport.
52
53 5C. Fuel Tank
54 Airport Manager Owen:
MINUTES of the Ukiah Airport Commission June 3, 2014
Page 2
1 • Staff has been working with Mead & Hunt consultants regarding staff's request for a proposal
2 from Mead & Hunt to provide a design and bid specifications for two different tank options.
3 • Mead & Hunt should have the RFPs completed shortly.
4 • Has reviewed the prospect of securing a loan with Caltrans Division of Aeronautics for the fuel
5 tank project and determined there is no prepayment penalty should the Airport want to pay-off the
6 loan any time. Caltrans Division of Aeronautics has loan funds available if the Airport wants to
7 take out a loan.
8
9 5D. Airport Business Plan/ Buildings
10 Airport Manager Owen:
11 • Was unable to meet with Commissioner Crane this month to discuss/review buildings on the
12 Airport so that when the information on the building inventory list is complete this information will
13 be included as part of the Airport Business Plan.
14
15 5E. Lease Recommendations
16 Airport Manager Owen:
17 • Staff is requesting the lease agreement for Northern Sky RV be approved by the Airport
18 Commission for recommendation to Council
19 • At the last meeting the Commission recommendation was that Northern Sky RV be required to
20 have an employee escort for their customers when accessing their RVs. Northern Sky RV has
21 indicated this requirement is not something they can do and have asked that this requirement be
22 taken out of the lease.
23 • Northern Sky RV does plan to have staffing/security at night after hours but having to provide
24 staffing during the day would be a problem.
25 • Asked the Commission to review the lease agreement to see if the Commissioners are willing to
26 forego that term/condition of the lease that requires an employee escort for customers accessing
27 their RVs.
28 • Northern Sky RV will be leasing the building on the site and intends to make some improvements
29 to it as well as other potential improvements, such as to the fence. Staff is not requiring Northern
30 Sky RV to replace the perimeter fencing as part of the lease agreement.
31 • Expansion of the business may be an option should Northern Sky RV outgrow the area currently
32 being leased.
33
34 Commission:
35 • Discussed the proposed use, type of operation relative to whether it would work well and be a
36 good fit for the Airport.
37 • Also discussed the lease agreement and reaffirmed since the lease is month-to-month so that if
38 the use does not work out for one reason or another, the lease can be terminated at that time.
39 • Considered whether or not to allow Northern Sky RV to provide security/escort only at night and
40 be okay with people having access to the facility via a key, combination and/or padlock.
41 • Is generally okay with having staffing/escort only at night.
42
43 M/S Deerwester/Crane to recommend City Council approve the lease agreement for Northern Sky RV
44 and to exclude that provision of the lease requiring daytime staffing.
45
46 Commissioner Albright:
47 • Asked for clarification customers of Northern Sky RV can essentially come and go at any time
48 from the site, seven days a week. Should nighttime hours be defined?
49 • Has observed there is always traffic at the intersection of Hastings Road and Commerce Drive.
50
51 Commissioner Crane:
52 • While the aforementioned is true, there is nighttime staff to assist RV owners.
53
54 Commissioner Elton:
MINUTES of the Ukiah Airport Commission June 3, 2014
Page 3
1 • In previous discussion, there was language about`normal business hours.'
2 • Is of the opinion evening hours would be more dangerous with large RVs coming to and from the
3 site and possibly conflicting with traffic flow at the intersection of Hastings Road and Commerce
4 Drive.
5
6 Commissioner Deerwester:
7 • Is of the opinion traffic congestion would not be a problem during the day because people driving
8 their RVs would not be pulling in or out on a continual basis but rather infrequently upon need.
9 Nighttime could be an issue because traffic in the area may not see a RV pulling in or out.
10 • Asked about signage?
11
12 Airport Manager Owen:
13 • We could not determine what normal business hours were. Northern Sky RV was concerned
14 about evening hours and not so much the daytime hours.
15 • Any signage would be installed on the site subject to City sign requirements.
16 • Is not concerned about setting nighttime hours. Airport users come and go on the Airport to
17 access their planes, etc., so is of the opinion this would be no different.
18 • Related to potential vandalism Northern Sky RV will be responsible for policing the site and,
19 persons renting space for storage of RVs will essentially provide their own security because they
20 will know when something is not right.
21
22 Commissioner Crane:
23 • What is the nature of the nighttime security? Is it paid security?
24
25 Airport Manager Owen:
26 • Confirmed to his knowledge Northern Sky RV will have a paid security service.
27
28 The aforementioned motion carried by an all AYE voice vote of the Commissioners present(5-0).
29
30 REPORTS
31 6A. Airport Monthly Financial Report
32 Airport Manager Owen:
33 • Referred to year-to-date fuel revenue/sales information sheet for May for comparison purposes.
34 • Related to the balance sheet for 2014 indicated the `pooled cash' balance has been declining
35 overtime. After researching the problem found it had to do with the City accounting methodology
36 and/or reconciling of the journal entries thereof and the accounting methodology by Epic
37 regarding imbursement from credit card sales. The matter is being looked.
38
39 Commissioner Elton:
40 • Addressed the aforementioned issue and noted if the checks received from Epic were recorded
41 as revenue the money should have been either in the cash account or receivable account.
42
43 Airport Manager Owen:
44 • The problem is the Airport was not regularly receiving `pooled cash' back from Epic so that it gets
45 properly recorded in the general ledger. The Airport has to ask for a check from Epic.
46 • Airport staff maintains a record of all fuel sales and these figures are compared to City Hall
47 accounting/posting of fuel sales for check and balance purposes. Acknowledged there has been
48 `a disconnect' and/or discrepancy between Airport reports and those from City Hall regarding fuel
49 sales, which mostly has to do with posting of data.
50 • Staff will determine how best to manage the accounting for credit card sales to make certain the
51 Airport is receiving payments from Epic.
52
53 Commissioner Elton:
54 • The reason is because there is 'no cash' transaction. The accounting for how the Airport receives
55 credit from credit card sales needs to be straightened out.
MINUTES of the Ukiah Airport Commission June 3, 2014
Page 4
1 6B. Airport Day
2 Airport Manager Owen:
3 • Is pleased with the plans for Airport Day.
4 • The purpose of Airport Day is to have a day all about fun.
5
6 Commissioners Deerwester and Elton:
7 • Understands while there is a lot of planning and preparation for Airport Day for it to be a
8 successful event expressed concern/questioned how vendors are managed for Airport Day and
9 would like to see the community more involved with preparation/plans for Airport Day.
10 • Asked to see a list of all the vendors.
11 • Are of the opinion no vendor should be allowed to sell the same thing and that their location
12 should be predetermined. It is not a good idea to have competing vendors since most of the
13 vendors are non-profit organizations raising money for causes.
14 • Would like the Commission to review how vendors are managed for future Airport Day events and
15 provide for better organization, structure and operational information. An event like Airport Day
16 requires a well-managed vendor operation. The concept of making Airport Day a day about
17 having `fun' is not about making it fun when it comes to the vendors. Vendors are present to
18 raise money either for profit or for a cause and not necessarily for fun.
19
20 Airport Manager Owen:
21 • Protocol for Airport Day has always been that vendors are allowed to sell what they want, free of
22 charge and their location determined by a first come basis.
23 • Does not have the vendor list readily available as the list is incomplete because people are still
24 signing up.
25 • Related to past Airport Day events, vendors selling the same item have always sold out.
26
27 Commissioners Crane and Albright and Chair Steinmann:
28 • While they appreciate having vendors disagreed with Commissioners Deerwester and Elton on
29 how vendors are managed for Airport Day and does not see there is a problem when it comes to
30 vendors. Are of the opinion Airport Day is about having a good time at the Airport enjoying the
31 planes/plane rides, looking at static displays and learning about the Airport and aircraft rather
32 than focusing on vendors and what they are doing.
33 • Willing to look at management of vendors for future Airport Days with regard to fairness and
34 possible better organization.
35 • Is of the opinion staff and/or volunteers do a great job orchestrating the Airport Day event.
36
37 6C. ALP Update
38 Airport Manager Owen has nothing new to report.
39
40 6D. Commissioner Appointments
41 Airport Manager Owen:
42 • Commissioner seats for Steinmann and Deerwester are due for reappointment in June.
43 • Has no knowledge whether or not the City Clerk has publicly noticed for recruitment of these
44 upcoming vacancies.
45
46 It was the consensus of the Commission to cancel the regular July meeting.
47
48 7. AGENDA ITEMS FOR AUGUST
49 1. Budget 2014-15
50 2. Airport Maintenance
51 3. Fuel Tank
52 4. Airport Business Plan/ Buildings
53 5. Airport Monthly Financial Report
54 6. Airport Day
55 7. ALP Update
MINUTES of the Ukiah Airport Commission June 3, 2014
Page 5
1 Commission asked about Chico Model A and when this business will be operating at the former small
2 engine repair building.
3
4 Airport Manager Owen:
5 • Chico Model A will likely begin operating in the former small engine repair building next month.
6
7 8. COMMISSIONER COMMENTS/STAFF COMMENTS
8
9 9. ADJOURNMENT
10 There being no further business, the meeting adjourned at 7:18 p.m.
11
12
13 Cathy Elawadly, Recording Secretary
14
15
MINUTES of the Ukiah Airport Commission June 3, 2014
Page 6
5. DISCUSSION/ACTION
5a. Budget 2014-15/ Airport Monthly Financial Report
Attached is the new 2014-15 budget and all financial reports.
(Attachments1-8)
5b. Airport Maintenance
Staff will give a verbal report on maintenance.
5c. Airport Commission Recording Secretary
Cathy Elawadly Recording Secretary for the Airport Commission
meetings has been promoted and given additional duties. This new
position Ms. Elawadly has taken will no longer allow her to prepare
agenda packets, post agendas/minutes/packets to City
website/Lazerfiche, attend Airport Commission meetings and take/
write the minutes of the meetings.
Staff would like to discuss the future of the Airport Commission
meeting minutes. Ms. Elawadly will attend the next few meeting
during her transition into her new position.
5d. Fuel Tank
Staff has requested a proposal from Mead & Hunt to provide a design
and bid spec for two different tank options.
5f. Airport Business Plan
Staff will discuss the business plan status.
6. REPORTS
6a. Airport Day
The Ukiah Airport Day will be held on June 7tn
6b. ALP Update
At the time of the agenda staff has no new update.
City of Ukiah Proposed Operating Budget
Airport Enterprise Fund Detail for Fiscal Year 2014/2015
Actual Actual Actual Actual Budget Projected Budget
ORG OBJ PROJECT DESCRIPTION FY 2010 FY 2011 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015
AIRPORT FUND REVENUE
77700000 44201 AIRPORT GAS&OIL SALES (601,774) (789,737) (1,142,917) (1,396,065) (1,353,991) (1,033,752) (1,062,500)
77700000 44202 AIRPORT OPERATION FEES (7,473) (8,553) (5,447) (5,124) (7,000) (7,000) (7,000)
77700000 44203 AIRPORT MISC.SALES (4,043) (3,520) (2,566) (780) (1,500) (1,500) (1,500)
77700000 44204 AIRPORT LANDING FEES (10,696) (7,800) (9,480) (26,790) (29,000) (12,000) (12,000)
77700000 46110 INTEREST ON INVESTMENTS (1,219) (1,096) (1,288) (3,239) (3,633) (3,633) (3,500)
77700000 46116 MISCELLANEOUS INCOME - - 93 (1,609) - (2,472) (1,777)
77700000 46801 AIRPORTGROUNDRENT (83,396) (105,391) (102,838) (96,113) (90,000) (90,000) (90,000)
77700000 46802 AIRPORT ADMIN BLDG RENT (8,864) (10,198) (10,367) (9,336) (9,000) (9,000) (9,000)
77700000 46803 AIRPORT HANGAR RENT (134,991) (137,487) (138,794) (127,802) (125,000) (125,000) (125,000)
77700000 46804 FAA BUILDING (13,501) (10,731) (11,281) (8,666) (8,000) (8,428) (8,244)
77700000 46805 CORPORATION YARD LAND RENTAL - - (23,000) (23,000) - (20,000) (20,000)
77700000 46806 COMMISSION ON HANGAR RENTAL - - - (157) - (1,536) (1,046)
77700000 47110 CONTRIBUTIONS&DONATIONS (1,797) 25 - - - - -
77700000 48110 MISCELLANEOUS RECEIPTS (8) - (125) (410) (210) (100) (100)
77700000 Total Airport Fund Revenue (867,762) (1,074,487) (1,448,009) (1,699,091) (1,627,334) (1,314,421) (1,341,667)
CITY COUNCIL EXPENSES
77710000 51110 REGULAR SALARIES&WAGES - - - - - - 1,060
77710000 51220 INSURANCE - - - - - - 1,268
77710000 51230 WORKERS COMP - - - - - - 101
77710000 51240 MEDICARE - - - - - - 19
77710000 51260 FICA - - - - - - 68
77710000 54101 POSTAGE - - - - - - 2
77710000 55100 TELEPHONE - - - - - - 16
77710000 57100 CONFERENCE&TRAINING - - - - - - 100
77710000 61410 RENT ALLOCATION - - - - - - 469
77710000 61420 BUILDING MAINTENANCE ALLOCATION - - - - - - 1,591
77710000 61425 ALLOCATED UTILITIES - - - - - - 357
77710000Total CityCouncilExpenses - - - - - - 5,051
CITY CLERK EXPENSES
77711100 51110 REGULAR SALARIES&WAGES - - - - - - 2,048
77711100 51210 RETIREMENT(PERS) - - - - - - 572
77711100 51220 INSURANCE - - - - - - 617
77711100 51230 WORKERS COMP - - - - - - 112
77711100 51240 MEDICARE - - - - - - 29
77711100 51250 UNEMPLOYMENT - - - - - - 28
77711100 52100 CONTRACTED SERVICES - - - - - - 616
77711100 52150 LEGALSERVICES/EXPENSES - - - - - - 380
77711100 54100 SUPPLIES - - - - - - 100
77711100 54101 POSTAGE - - - - - - 4
77711100 55100 TELEPHONE - - - - - - 14
77711100 56120 EQUIPMENT MAINTENANCE&REPAIR - - - - - - 10
77711100 57100 CONFERENCE&TRAINING - - - - - - 92
77711100 57300 MEMBERSHIPS&SUBSCRIPTIONS - - - - - - 11
77711100 61410 RENT ALLOCATION - - - - - - 158
77711100 61420 BUILDING MAINTENANCE ALLOCATION - - - - - - 533
City of Ukiah Proposed Operating Budget
Airport Enterprise Fund Detail for Fiscal Year 2014/2015
Actual Actual Actual Actual Budget Projected Budget
ORG OBJ PROJECT DESCRIPTION FY 2010 FY 2011 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015
77711100 61425 ALLOCATED UTILITIES - - - - - - 120
77711100 Total City Clerk Expenses - - - - - - 5,444
CITY MANAGER EXPENSES
77712100 51110 REGULAR SALARIES&WAGES - - - - - - 3,150
77712100 51210 RETIREMENT(PERS) - - - - - - 919
77712100 51220 INSURANCE - - - - - - 334
77712100 51230 WORKERS COMP - - - - - - 148
77712100 51240 MEDICARE - - - - - - 46
77712100 51250 UNEMPLOYMENT - - - - - - 36
77712100 51290 CELL PHONE STIPEND - - - - - - 16
77712100 52100 CONTRACTED SERVICES - - - - - - 700
77712100 54100 SUPPLIES - - - - - - 125
77712100 54101 POSTAGE - - - - - - 3
77712100 55100 TELEPHONE - - - - - - 55
77712100 55210 UTILITIES - - - - - - 30
77712100 57100 CONFERENCE&TRAINING - - - - - - 122
77712100 57300 MEMBERSHIPS&SUBSCRIPTIONS - - - - - - 76
77712100 61410 RENT ALLOCATION - - - - - - 155
77712100 61420 BUILDING MAINTENANCE ALLOCATION - - - - - - 248
77712100 61425 ALLOCATED UTILITIES - - - - - - 335
77712100 Total City Manager Expenses - - - - - - 6,498
MISC.GENERAL GOVERNMENT EXPENSES
77712400 61500 INSURANCEALLOCATION - - - - - - 6,486
77712400 Total Misc.General Government Expenses - - - - - - 6,486
ACCOUNTING EXPENSES
77713400 51110 REGULAR SALARIES&WAGES - - - - - - 12,682
77713400 51210 RETIREMENT(PERS) - - - - - - 3,451
77713400 51220 INSURANCE - - - - - - 2,338
77713400 51230 WORKERS COMP - - - - - - 632
77713400 51240 MEDICARE - - - - - - 194
77713400 51250 UNEMPLOYMENT - - - - - - 155
77713400 51290 CELL PHONE STIPEND - - - - - - 21
77713400 52100 CONTRACTED SERVICES - - - - - - 3,312
77713400 54100 SUPPLIES - - - - - - 340
77713400 54101 POSTAGE - - - - - - 104
77713400 55100 TELEPHONE - - - - - - 48
77713400 56120 EQUIPMENT MAINTENANCE&REPAIR - - - - - - 80
77713400 57100 CONFERENCE&TRAINING - - - - - - 200
77713400 57300 MEMBERSHIPS&SUBSCRIPTIONS - - - - - - 17
77713400 61200 PURCHASING ALLOCATION - - - - - - 1,565
77713400 61300 BILLING&COLLECTION ALLOCATION - - - - - - 8,029
77713400 61425 ALLOCATED UTILITIES - - - - - - 119
77713400Total AccountingExpenses - - - - - - 33,287
CITY ATTORNEY EXPENSES
City of Ukiah Proposed Operating Budget
Airport Enterprise Fund Detail for Fiscal Year 2014/2015
Actual Actual Actual Actual Budget Projected Budget
ORG OBJ PROJECT DESCRIPTION FY 2010 FY 2011 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015
77714000 52100 CONTRACTED SERVICES - - - - - - 1,800
77714000 55100 TELEPHONE - - - - - - 3
77714000 57100 CONFERENCE&TRAINING - - - - - - 12
77714000 Total City Attorney Expenses - - - - - - 1,815
TREASURY MANAGEMENT EXPENSES
77715100 51110 REGULAR SALARIES&WAGES - - - - - - 36
77715100 51220 INSURANCE - - - - - - 13
77715100 51230 WORKERS COMP - - - - - - 3
77715100 51240 MEDICARE - - - - - - 2
77715100 51260 FICA - - - - - - 3
77715100 52100 CONTRACTED SERVICES - - - - - - 800
77715100 Total Treasury Management Expenses - - - - - - 857
HUMAN RESOURCES EXPENSES
77716100 51110 REGULAR SALARIES&WAGES - - - - - - 2,271
77716100 51210 RETIREMENT(PERS) - - - - - - 611
77716100 51220 INSURANCE - - - - - - 200
77716100 51230 WORKERS COMP - - - - - - 106
77716100 51240 MEDICARE - - - - - - 34
77716100 51250 UNEMPLOYMENT - - - - - - 28
77716100 51290 CELL PHONE STIPEND - - - - - - 11
77716100 52100 CONTRACTED SERVICES - - - - - - 250
77716100 52151 AFLAC&PERSINSUR ADMIN FEES - - - - - - 60
77716100 54101 POSTAGE - - - - - - 9
77716100 54160 HR-SPECIAL SUPPLIES - - - - - - 20
77716100 54161 HR-BACKGROUND&PHYSICALS - - - - - - 100
77716100 54162 HR-ADVERTISING - - - - - - 120
77716100 54163 HR-INTERVIEW SUPPLIES - - - - - - 9
77716100 54164 HR-FORMS&OTHER DIV.EXP. - - - - - - 30
77716100 54165 HR-NEW EMPLOYEE FIN6ERPRINT - - - - - - 12
77716100 54166 HR-DOT TESTING PROGRAM - - - - - - 18
77716100 55100 TELEPHONE - - - - - - 10
77716100 57100 CONFERENCE&TRAINING - - - - - - 45
77716100 57300 MEMBERSHIPS&SUBSCRIPTIONS - - - - - - 69
77716100 61410 RENT ALLOCATION - - - - - - 17
77716100 61420 BUILDING MAINTENANCE ALLOCATION - - - - - - 59
77716100 61425 ALLOCATED UTILITIES - - - - - - 13
77716100Total Human Resources Expenses - - - - - - 4,102
INFORMATION TECHNOLOGY EXPENSES
77722900 51110 REGULAR SALARIES&WAGES - - - - - - 3,305
77722900 51120 NON-REGULAR SALARIES&WAGES - - - - - - 480
77722900 51210 RETIREMENT(PERS) - - - - - - 911
77722900 51220 INSURANCE - - - - - - 796
77722900 51230 WORKERS COMP - - - - - - 197
77722900 51240 MEDICARE - - - - - - 57
77722900 51250 UNEMPLOYMENT - - - - - - 53
City of Ukiah Proposed Operating Budget
Airport Enterprise Fund Detail for Fiscal Year 2014/2015
Actual Actual Actual Actual Budget Projected Budget
ORG OBJ PROJECT DESCRIPTION FY 2010 FY 2011 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015
77722900 51260 FICA - - - - - - 30
77722900 51290 CELLPHONE - - - - - - 24
77722900 52100 CONTRACTED SERVICES - - - - - - 2,600
77722900 54100 SUPPLIES - - - - - - 1,000
77722900 54101 POSTAGE - - - - - - 5
77722900 54320 SOFTWARE - - - - - - 2,500
77722900 55100 TELEPHONE - - - - - - 100
77722900 56120 EQUIPMENT MAINTENANCE&REPAIR - - - - - - 720
77722900 57100 CONFERENCE&TRAINING - - - - - - 350
77722900 57300 MEMBERSHIPS&SUBSCRIPTIONS - - - - - - 16
77722900 61410 RENT ALLOCATION - - - - - - 180
77722900 61420 BUILDING MAINTENANCE ALLOCATION - - - - - - 40
77722900 Total Information Technology Expenses - - - - - - 13,364
INFORMATION TECHNOLOGY FIXED ASSETS
77722900 80100 MACHINERY&EQUIPMENT - - - - - - 3,000
77722900 Total Information Technology Fixed Assets - - - - - - 3,000
AIRPORT OPERATIONS EXPENSES
77725200 51110 REGULAR SALARIES&WAGES 122,464 128,825 118,367 163,763 199,693 180,000 193,908
77725200 51120 NON-REGULAR SALARIES&WAGES 53,085 53,635 55,738 27,629 - - -
77725200 51130 OVERTIME SALARIES&WAGES 513 1,373 988 3,396 2,000 1,600 2,159
77725200 51150 ACCRUED SALARIES&BENEFITS (1,304) 1,327 (497) 4,845 - - -
77725200 51210 RETIREMENT(PERS) 20,607 24,800 31,032 38,317 41,376 41,376 53,540
77725200 51220 INSURANCE 42,993 42,056 43,937 44,421 43,244 43,244 47,780
77725200 51230 WORKERS COMP 7,236 7,588 7,573 8,718 11,310 11,310 10,030
77725200 51240 MEDICARE 2,453 2,689 2,572 2,805 2,756 2,756 2,674
77725200 51250 UNEMPLOYMENT 279 1,898 1,838 2,017 2,028 2,028 2,392
77725200 51260 FICA 2,784 2,631 2,956 2,572 2,592 2,592 -
77725200 51290 CELL PHONE STIPEND - - - 150 1,008 1,008 1,008
77725200 52100 CONTRACTED SERVICES 14,909 8,424 14,152 13,935 10,730 8,700 8,700
77725200 52528 LIABILITY INSURANCE - - - 4,830 8,000 8,000 8,000
77725200 54100 SUPPLIES 10,771 8,605 14,404 16,012 14,000 14,000 14,000
77725200 54101 POSTAGE 162 158 73 294 400 200 300
77725200 55100 TELEPHONE 2,645 2,641 2,575 2,730 2,500 2,500 2,500
77725200 55210 UTILITIES 24,762 23,019 23,602 26,117 25,000 25,000 25,000
77725200 56110 CITY GARAGE-PARTS 1,786 405 280 311 514 514 514
77725200 56111 CITY GARAGE-LABOR 10,711 10,801 7,464 8,311 13,723 13,723 13,723
77725200 56120 EQUIPMENT MAINTENANCE&REPAIR 42 - 51 240 200 200 200
77725200 56130 EXTERNAL SERVICES 5,601 7,322 5,933 7,422 4,000 4,000 400
77725200 56210 FUEL&FLUIDS 32,672 4,338 5,863 3,746 5,000 3,500 5,000
77725200 56300 BUILDING MAINT.&REPAIR 30,652 34,159 29,928 29,742 50,000 50,000 50,000
77725200 57100 CONFERENCE&TRAINING 4,317 1,398 3,643 3,227 5,000 5,000 5,000
77725200 57300 MEMBERSHIPS&SUBSCRIPTIONS 155 85 355 395 800 400 800
77725200 58401 AVIATION FUEL 492,666 599,825 787,280 1,057,383 954,800 789,511 761,500
77725200 59100 PROPERTY TAXES PAID 1,072 1,070 1,082 1,108 1,072 1,072 1,072
77725200 59101 FEES - - - - - 1,244 1,244
77725200 61100 GENERALGOVERNMENTALLOCATION 51,933 50,298 50,795 68,856 68,856 68,856 -
City of Ukiah Proposed Operating Budget
Airport Enterprise Fund Detail for Fiscal Year 2014/2015
Actual Actual Actual Actual Budget Projected Budget
ORG OBJ PROJECT DESCRIPTION FY 2010 FY 2011 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015
77725200 61200 PURCHASING ALLOCATION 2,335 1,821 1,750 2,089 1,921 1,921 -
77725200 61300 BILLING&COLLECTION ALLOCATION 12,945 11,740 10,228 11,176 12,487 12,487 -
77725200 61500 INSURANCE ALLOCATION 25,542 24,679 24,729 18,375 18,375 18,375 -
77725200 Total Airport Operations Expenses 976,786 1,057,610 1,248,688 1,574,932 1,503,385 1,315,117 1,211,444
AIRPORT OPERATIONS FIXED ASSETS
77725200 80100 13021 MACHINERY&EQUIPMENT - - - - 105,000 - 200,000
77725200 80100 13022 MACHINERY&EQUIPMENT - - - - 203,558 204,000 -
77725200 Total Airport Operations Fixed Assets - - - - 308,558 204,000 200,000
AIRPORT OPERATIONS TRANSFERS
77725200 94400 DEPRECIATION 66,053 66,053 63,169 63,252 - - -
77725200 Total Airport Operations Transfers 66,053 66,053 63,169 63,252 - - -
AIRPORT CAPITAL IMPROVEMENT FUND REVENUE
77800000 43173 13044 CALTRANS - - - - (3,750) - -
77800000 43190 STATE OTHER (18,222) - - - - - -
77800000 43291 FAA CAP IMPROVEMENT GR 3-06-26 (11,827) - - - - - -
77800000 43292 FAA CAP IMPROVEMENT GR 3-06-26 (553,859) (1) - - - - -
77800000 43299 13044 FAA GRANT - - - - (75,000) (75,000) -
77800000Total Airport Capital Improvement Fund Revenue (583,908) (1) - - (78,750) (75,000) -
FAA GRANTEXPENSES
77817411 52100 CONTRACTED SERVICES 12,486 - - - - - -
77817411 52100 13044 CONTRACTED SERVICES 587,150 - - - 83,333 83,333 -
77817411 Total FAA Grant Expenses 599,636 - - - 83,333 83,333 -
SPECIAL AVIATION FUND REVENUE
77900000 43190 STATE OTHER - - - (30,000) - - -
77900000 46110 INTERESTON INVESTMENTS 2 1 1 (113) (1) (1) -
77900000 Total Special Aviation Fund Revenue 2 1 1 (30,113) (1) (1) -
Fuel Gallons
7013/19 IETH Cal5tarletA Avgas oilquarts Oil Wnding Callout Catering TotalFUelRev CalStar GrossRevnue FuelCosi NMfuelSales Purchased Gallons5old
luly I1,08].00 3,980.00 9,421.10 5 $92.00 $20.00 $93,6]].15 $20,288.01
August 16,416.00 4,810.00 5,141.]0 9 $]8.00 $300.00 $130,383.5] $25,314.]5
September ],028.00 0,430.00 9,221.80 10 $88.00 $68,825.26 $25,313.]2
October 3,966.00 3,410.00 4,381.20 3 $28.00 $20.00 $49,148.65 $23,62331
November 3,161.00 9,065.00 3,024.90 2 $I6.00 $]5.00 $36,185.91 $1],824.96
December 2,881.00 5,132.00 2,99].90 6 $32.00 $I50.00 $34,422.61 $21,299.44
lanuary fi49.00 5,299.00 3,398.60 ] $62.00 $23,599.11 $26,603.02
Febuary 2,3]4.00 2,]41.00 1,96].60 1 $8.00 $24,831.8] $14,359.14
March 9]1.00 2,825.00 2,]51.30 5 $92.00 $]5.00 $21,512.89 $19,832.25
April 850.00 4,450.00 3,006.50 2.00 $16.00 $]5.00 $22,406.21 $24,948.53
May 9,946.00 9,5]5.00 3,394.90 1 $8.00 $]5.00 $]9.613.99 $20,290.66
lune 11,155.00 4,980.00 3,606.10 2.00 $I8.00 $]5.00 $90,994.2] $28,265.41
To[als ]1,289.00 50,69].00 42,866.60 51 $438.00 $40.00 $825.00 $6J5,581.49 $2fi2,963.80 $939,SV8.29 -$659,623.51 $280,224.]8 162,181.00 164,]9].60
- lET A CalStarletA Avgas oil9uarts Oil Wnding Callout Catering TotalFUelRev CalStar
5223.462.3]
luly 20,174.00 5,215.00 4,958.00 3 $28.00 $141,711.81
August 5],]19.00 5,660.00 ],19].00 ] $56.00 S38].364.68
September 33,943.00 4,383.00 5,682.50 6 $48.00 $234,477.89
October ],230.00 9,803.00 3,131.60 5 $90.00 $fi3,]40.21
November 1,109.00 3,525.00 2,198.80 0 $0.00 $20.00 $170.00 $19,999.85
December 3,085.00 2,0]0.00 1,898.]0 0 $0.00 $29,938.59
lanuary 2,070.00 4,865.00 2,892.30 1 $8.00 $125.00 $29,175.63
Febuary 5]8.00 3,258.00 9,152.10 4 $32.00 $26,]49.14
March 2,995.00 3,075.00 3,238.80 4 $38.00 $I50.00 $37,275.54
April 3,982.00 5,430.00 3,4]].90 1 $8.00 $41,98].18
May 7,405.00 3,795.00 5,230.00 3 $28.00 $75.00 $74.614.99
lune 10,546.00 2,885.00 9,1]2.80 li $304.00 $84.611.54
Totals 350,336.00 48,960.00 48,380.50 46 $390.00 $20.00 $350.00 $170.00 $I,ll1,647.05 $273p62•37 $1,396,039.42 -$1,026,935.00 $369,204.42 256,542.00 247,480.00
7011/12 lET A [alStarle[A Hvgas oilquar[s Oil landing Callou[ Cahring TMaIFUeIRev Ca15[ar
luly 24,601.00 9,021.00 8,388.90 18 152.00 300.00 $194,1]1.35 $20,011.89
August 19,282.00 4,275.00 6,965.70 21 348.00 300.00 $150,813.57 $20,16225
Sep[ember 10,061.00 9,555.00 9,293.00 9 ]8.00 0.00 $82.009.94 $22.039.30
October 3,273.00 3,535.00 4,124.50 12 102.00 12.00 0.00 $42,170.15 $16,592.20
November 2,0]J.30 2p65.00 2,A65.00 1 10.00 20.00 25.00 $21,226.81 $11,J94.SJ
December 869.00 3,936.00 4,220.00 4 32.00 0.00 0.00 $28.657.31 $18,634.44
lanuary 3,020.]0 3,210.00 3,020.J0 5 90.00 150.00 $22.092.95 $1G,813.91
Febuary 2,710.10 3,982.00 2,710.10 0 0.00 0.00 0.00 0.00 $90,219.69 $19,206.21
March 1,939.00 3,SJ5.00 1,636.00 J ]0.00 20.00 $20,594.36 $1],812.94
April 3,239.40 2,750.00 3,239.40 1 8.00 $23.752.38 $13,717.39
May 4,1]1.30 6,306.00 9,1]1.30 3 0 26.00 0.00 0.00 0.00 $41,4G].18 $31,606.]1
lune 7,909.70 4,621.00 7,909.70 3 0 28.00 0.00 0.00 0.00 $129,203.64 $21,569.39
To[als 82,608.30 4],231.00 52,891.80 86 692.00 52.00 ]50.00 25.00 $]96,359.33 S22],961.5� $1,025,839.83 -$]18,86].45 $306,9]2.38 185,36].00 182,]]1.10
2030/11 lET A CalStarletA Avgas oilquar[s Oil Tie Down Landing Callout ToWIFUeIRev CalStar
luly 14,070.00 4,140.00 5,589.70 2 $16.00 $204.00 $20.00 $0.00 594.956.56 $14,506.67
Au¢ust 15,925.00 9,]90.00 5,598.10 20 $156.00 $128.00 $20.00 $150.00 $10G,388.9] $1],204.84
September 9,325.00 4,285.00 5,128.20 17 $138.00 $112.00 $42.00 $75.00 $69,762.89 $15,240.46
October 4,680.00 3,195.00 3,953.60 0 $0.00 $63.00 $22.00 $0.00 $41,399.03 $11,�]3.69
November 2,432.00 3,300.00 3,152.10 5 $46.00 $70.00 $20.00 $300.00 $27.023.56 $12,444.63
December 1,629.00 2,150.00 92].90 1 $8.00 $0.00 $0.00 $0.00 $11,996.39 $8.13�.G4
lanuary 1,122.00 2,860.00 2,860.20 4 $36.00 $49.00 $0.00 $0.00 $19,180.76 $11,392.58
Febuary 1,592.00 1,626.00 2,195.50 0 $0.00 $0.00 $0.00 $50.00 $18,666.16 $6,4]8.24
March 2,113.00 1,750.00 2,293.50 2 $16.00 $72.00 $0.00 $150.00 $22.332.00 $7.453.01
April 3,00].00 3,530.00 2,]99.]0 0 $0.00 $29.00 $20.00 $0.00 $32,305.95 $16,19]A�
May 6,892.00 3,672.00 3,462.50 2 $18.00 $72.00 $0.00 $300.00 $62,537.51 $18,947.38
lune 12,013.00 9,3]9.00 ],]35.80 8 $68.00 $82.00 $0.00 $]5.00 $31],28].39 $21,60].53
To[als 74,800.00 39,627.00 45,596.80 61 $500.00 $876.00 $144.00 $1,100.00 $621,837.17 $160,676.87 $785,134.04 -5599,825.00 $185,309.04
2009/10 lET A [alStarle[A AvQas oilquar[s Oil Tie Down LandinQ [allau[ TotalFUelRev [a15[ar
luly IA,283.00 5,623.00 6,950.20 5 $36.00 $192.00 $59.50 $0.00 $88,546.81 $16,266.91
August 14,742.00 4,980.00 7,042.10 18 $194.00 $200.00 $22.00 $0.00 $94,634.09 $15,096.98
Sep[ember 13,080.00 9,0]].00 5,686.]0 6 $50.00 $136.00 $12.85 $150.00 $84,066.68 $I1,]40.8]
October 6,720.00 2,565.00 5,142.10 7 $94.00 $272.00 $0.00 $140.00 $53,331.10 $7.455.86
November 1,145.00 2,150.00 3,691.60 20 $126.00 $A0.00 $0.00 $50.55 $20,851.1] $6,891.46
December 1,089.00 2,220.00 2,609.40 3 $22.00 $32.00 $0.00 $75.00 $16,619.29 $7.155.85
lanuary 9]8.00 2,3]5.00 1,830.50 2 $I8.00 $0.00 $0.00 $0.00 $10,3]9.95 $].289.15
Febuary 1,317.00 1,800.00 2,402.10 0 $0.00 $24.00 $0.00 $0.00 $16,631.33 $5,524.40
March 1,88].00 9,435.00 3,623.90 2 $I8.00 $J2.00 $0.00 $0.00 $23.]]1.39 $14,21].]9
April 2,603.00 2,635.00 2,837.70 2 $20.00 $8.00 $60.00 $75.00 $24.668.31 $9.665.08
May 4,239.00 4,495.00 3,651.70 2 518.00 5120.00 50.00 50.00 $37,966.99 $16,470.54
lune 13,244.00 4,205.00 8,018.60 11 5100.00 556.00 50.00 50.00 $300,92638 $14,684.68
To[als ]A,82].00 A1,]60.00 53,086.60 ]8 $592.00 $1,152.00 $154.35 $490.55 $5]2,393.49 $132,459.5] $]0],241.96 -$525,33].00 $181,904.96
new approved budget
Revenues
600.0800.650.001 Airport Gas&Oil Sales 77700000 44201 1,062,500.00 51,062,500.00
600.0800.650.002 Airport Operation Fees 77700000 44202 7,000.00 $7,000.00
600.0800.650.003 Airport Misc.Sales 77700000 44203 1,500.00 $1,500.00
600.0800.650.004 Airport Landing Fees 77700000 44204 12,000.00 512,000.00
600.0700.500.000 Interest on Investments 77700000 46110 3,500.00 $3,500.00
600.0800.650.009 Airport Other Income 77700000 46116 1,777.00 $1,777.00
600.0700.505.001 Airport Ground Rent 77700000 46801 90,000.00 590,000.00
600.0700.505.002 Airport Admin bldg Rent 77700000 46802 9,000.00 $9,000.00
600.0700.505.003 Airport Hangar Rent 77700000 46803 125,000.00 $125,000.00
600.0700.505.005 FAA Building 77700000 46804 8,244.00 $8,244.00
600.0700.505.007 Corporation yard land Rent 77700000 46805 20,000.00 520,000.00
46806 1,046.00 $1,146.00
600.0900.905.001 77700000 47110
600.0900.905.000 Miscellaneous 77700000 48110 100.00 5100.00
Expenditure
600.5001.110.000 Salaries,Regular 77725200 51110 $193,000.00 $193,908.00
600.5001.111.000 Salaries,Non Regualr 77725200 51120
600.5001.115.000 Salaries,OT&Holiday 77725200 51130 $2,159.00 $2,159.00
600.5001.119.000 Salary&Benefits 77725200 51150
600.5001.141.000 Retirement,PERS 77725200 51210 $53,540.00 $53,540.00
600.5001.151.000 Group Insurance 77725200 51220 $49,060.00 $47,780.00
600.5001.152.000 Worker Comp Insurance 77725200 51230 $13,202.00 $10,030.00
600.5001.154.000 Medicare 77725200 51240 $2,651.00 $2,674.00
600.5001.155.000 Unemployment Insurance 77725200 51250 $2,404.00 $2,392.00
600.5001.156.000 FICA 77725200 51260
Cell Phone 77725200 51290 $1,008.00 $1,008.00
600.5001.250.000 Contractual Services 77725200 52100 $8,700.00 $8,700.00
600.5001.340.001 Generallnsurance 77725200 52528 $8,000.00 $8,000.00
600.5001.690.000 Supplies 77725200 54100 $14,000.00 $14,000.00
600.5001.411.000 Postage 77725200 54101 $300.00 $300.00
600.5001.220.000 Telephone 77725200 55100 $2,500.00 $25,000.00
Cell Phone 55101
600.5001.210.000 Utilities 77725200 55210 $25,000.00 $25,000.00
600.5001.303.003 Equipment Maint&Repairs 77725200 56110 $514.00 $514.00
600.5001.303.004 Equipment Maint&Repairs 77725200 56111 $13,723.00 $13,723.00
600.5001.302.000 Equipment Maint&Repairs 77725200 56120 $200.00 $200.00
600.5001.303.000 Vehicle Repair&Maint 77725200 56130 $400.00 $400.00
600.5001.450.000 Fuels&Lubricants 77725200 56210 $5,000.00 $5,000.00
600.5001.305.000 Building&Grounds Maint 77725200 56300 $50,000.00 $50,000.00
600.5001.160.000 Travel&Conference 77725200 57100 $5,000.00 $5,000.00
600.5001.260.000 Dues&Subscriptions 77725200 57300 $800.00 $800.00
600.5001.451.000 Aviation Fuels&Lubricants 77725200 58401 $761,500.00 $761,500.00
600.5001.630.000 Taxes 77725200 59100 $1,072.00 $1,072.00
59101 $1,244.00 $1,244.00
600.5001.291.000 Gen Govt Service Charges 77725200 61100 $68,856.00
City Council $5,051.00
City Clerk $5,444.00
City Manager $6,498.00
Finance $39,773.00
City Attorney $1,815.00
treasury Management $857.00
H.R/Risk Management $4,102.00
Information Technology $13,364.00
600.5001.292.000 Purchasing Dept Charges 77725200 61200 $1,921.00
600.5001.320.000 Billing&Collection Costs 77725200 61300 $12,487.00
600.5001.340.000 Generallnsurance 77725200 61500 $18,375.00
Machinery&Equipment 77725200 80100
. �� �: :��
Machinery&Equipment 77725200 80100 zoo,000.00
07/29/2014 10:38 �City of Ukiah �P 1
gowen �BALANCE SHEET FOR 2015 1 �glbalsht
FUND: 777 AIRPORT FUND /
NET CHANGE ACCOUNT
FUND: 777 AIRPORT FUND FOR PERIOD BALANCE
ASSETS
77700000 10101 POOLED CASH 151,194.07 -10,799.28
77700000 10298 MARKET VALUE ADJUSTMENT .00 -406.18
77700000 10320 PRE-PAID DEPOSITS .00 800.00
77700000 10410 ACCOUNTS RECEIVABLE -272,232.24 -242, 640.07
77700000 10481 ACCRUED INTEREST .00 1,723.36
77700000 10600 ALLOWANCE FOR BAD DEBT .00 -125.00
77700000 19010 LAND .00 271, 957.47
77700000 19015 INFRASTRUCTURE .00 1,055,147.91
77700000 19020 LAND IMPROVEMENTS .00 1,290, 900.17
77700000 19040 BUILDINGS .00 542, 676.71
77700000 19080 ROLLING EQUIPMENT .00 86,214.56
77700000 19090 MACHINERY .00 38,766.82
77700000 19515 INFRASTRUCTURE DEPRECIATION .00 -1,055,147.91
77700000 19520 DEPRECIATION-LAND IMPROVEMENTS .00 -653,306.98
77700000 19540 BUILDINGS DEPRECIATION .00 -392,141.62
77700000 19580 ROLLING EQUIPMENT DEPRECIATION .00 -75,535.96
77700000 19590 MACHINERY DEPRECIATION .00 -28, 669.42
TOTAL ASSETS -121,038.17 829,414.58
LIABILITIES
77700000 20100 ACCOUNTS PAYABLE 8,702.53 298.00
77700000 20150 AP CONTRACT RETAINAGE .00 -.01
77700000 20560 ACCRUED VACATION .00 -14,147.08
77700000 21110 CUSTOMER DEPOSITS .00 -5,400.00
TOTAL LIABILITIES 8,702.53 -19,249.09
FUND BALANCE
77700000 30001 ENCUMBRANCE CONTROL .00 902.16
77700000 30002 ENCUMBRANCES - BUDGET FB RESER .00 -902.16
77700000 30005 REVENUE CONTROL -31,273.96 -31,273.96
77700000 30006 EXPENDITURE CONTROL 143, 609.60 143, 609.60
77700000 30007 FUND BALANCE .00 158,360.62
77700000 31009 INVESTMENT IN FIXED ASSETS .00 -1,080,861.75
TOTAL FUND BALANCE 112,335.64 -810,165.49
TOTAL LIABILITIES + FUND BALANCE 121,038.17 -829,414.58
** END OF REPORT - Generated by Greg Owen **
07/29/2014 City of Ukiah PAGE 1
10:24:02 FY 2013-2014 glflxrpt
FROM 2014 O1 TO 2014 12
ACCOUNTS FOR: ORIGINAL ESTIM REV REVISED ACTUAL REMAINING PCT
777 AIRPORT FUND ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL
77700000 AIRPORT FUND
44201 AIRPORT GAS & OIL SALES -1,353,991 0 -1,353, 991 -639,545.20 -714,445.80 47.20
44202 AIRPORT OPERATION FEES -7,000 0 -7,000 -6,396.00 -604.00 91.40
44203 AIRPORT MISC. SALES -1,500 0 -1,500 .00 -1,500.00 .Oo
44204 AIRPORT LANDING FEES -29,000 0 -29,000 -10,440.00 -18,560.00 36.0%
46110 INTEREST ON INVESTMENTS -3,633 0 -3, 633 .00 -3,633.00 .Oo
46116 MISCELLANEOUS INCOME 0 0 0 -3,564.00 3,564.00 .Oo
46801 AIRPORT GROUND RENT -90,000 0 -90,000 -98,345.98 8,345.98 109.30
46802 AIRPORT ADMIN BLDG RENT -9,000 0 -9,000 -10,188.00 1,188.00 113.2%
46803 AIRPORT HANGAR RENT -125,000 0 -125,000 -149,610.21 24,610.21 119.70
46804 FAA BUILDING -8,000 0 -8,000 -11,237.52 3,237.52 140.50
46805 CORPORATION YARD LAND RENTAL 0 0 0 -23,000.00 23,000.00 .Oo
46806 COMMISSION ON HANGAR RENTAL 0 0 0 -2,048.52 2,048.52 .0%
48110 MISCELLANEOUS RECEIPTS -210 0 -210 -1,265.00 1,055.00 602.40
TOTAL AIRPORT FUND -1,627,334 0 -1, 627,334 -955,640.43 -671,693.57 58.70
77725200 AIRPORT OPERATIONS
51110 REGULAR SALARIES & WAGES 199,693 0 199, 693 198,033.48 1,659.52 99.20
51130 OVERTIME SALARIES & WAGES 2,000 0 2,000 2,563.80 -563.80 128.20
51210 RETIREMENT (PERS) 41,376 0 41,376 41,641.99 -265.99 100.60
51220 INSURANCE 43,244 0 43,244 39,239.45 4,004.55 90.7%
51230 WORKERS COMP 11,310 0 11,310 12,793.80 -1,483.80 113.10
51240 MEDICARE 2,756 0 2,756 2,764.31 -8.31 100.30
51250 UNEMPLOYMENT 2,028 0 2,028 2,339.42 -311.42 115.40
51260 FICA 2,592 0 2,592 2,385.99 206.01 92.1%
51290 CELL PHONE STIPEND 1,008 0 1,008 1,011.00 -3.00 100.30
52100 CONTRACTED SERVICES 8,700 2,030 10,730 7,236.16 2,591.54 67.40
52528 LIABILITY INSURANCE 8,000 0 8,000 7,500.00 500.00 93.80
54100 SUPPLIES 14,000 0 14,000 13,818.59 181.41 98.7%
54101 POSTAGE 400 0 400 156.17 243.83 39.Oo
55100 TELEPHONE 2,500 0 2,500 1,874.17 625.83 75.Oo
55210 UTILITIES 25,000 0 25,000 22,768.99 2,231.01 91.10
56110 CITY GARAGE - PARTS 514 0 514 513.96 .04 100.0%
56111 CITY GARAGE - LABOR 13,723 0 13,723 13,722.96 .04 100.Oo
56120 EQUIPMENT MAINTENANCE & REPAIR 200 0 200 .00 200.00 .0%
07/29/2014 City of Ukiah PAGE 2
10:24:03 FY 2013-2014 glflxrpt
FROM 2014 O1 TO 2014 12
ACCOUNTS FOR: ORIGINAL ESTIM REV REVISED ACTUAL REMAINING PCT
777 AIRPORT FUND ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL
56130 EXTERNAL SERVICES 4,000 0 4,000 5,528.42 -1,528.42 138.20
56210 FUEL & FLUIDS 5,000 0 5,000 5,233.81 -233.81 104.70
56300 BUILDING MAINT. & REPAIR 50,000 0 50,000 54,582.31 -4,582.31 109.20
57100 CONFERENCE & TRAINING 5,000 0 5,000 4,757.24 242.76 95.1%
57300 MEMBERSHIPS & SUBSCRIPTIONS 800 0 800 240.00 560.00 30.Oo
58401 AVIATION FUEL 954,800 0 954,800 662,074.17 292,725.83 69.30
59100 PROPERTY TAXES PAID 1,072 0 1,072 1,134.98 -62.98 105.90
59101 FEES 0 0 0 1,244.00 -1,244.00 .0%
61100 GENERAL GOVERNMENT ALLOCATION 68,856 0 68,856 68,856.00 .00 100.Oo
61200 PURCHASING ALLOCATION 1,921 0 1, 921 1, 920.96 .04 100.Oo
61300 BILLING & COLLECTION ALLOCATIO 12,487 0 12,487 12,486.96 .04 100.00
61500 INSURANCE ALLOCATION 18,375 0 18,375 18,375.00 .00 100.0%
80100 MACHINERY & EQUIPMENT 255,000 53,558 308,558 203,558.44 105,000.00 66.Oo
TOTAL AIRPORT OPERATIONS 1,756,355 55,588 1,811, 943 1,410,356.53 400,684.61 77.80
TOTAL AIRPORT FUND 129,021 55,588 184, 609 454,716.10 -271,008.96 246.30
TOTAL REVENUES -1,627,334 0 -1, 627,334 -955,640.43 -671,693.57
TOTAL EXPENSES 1,756,355 55,588 1,811, 943 1,410,356.53 400,684.61
07/29/2014 City of Ukiah PAGE 3
10:24:03 FY 2013-2014 glflxrpt
FROM 2014 O1 TO 2014 12
ORIGINAL ESTIM REV REVISED ACTUAL REMAINING PCT
ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL
GRAND TOTAL 129,021 55,588 184, 609 454,716.10 -271,008.96 246.30
07/29/2014 City of Ukiah PAGE 4
10:24:03 FY 2013-2014 glflxrpt
REPORT OPTIONS
Field # Total Page Break From Yr/Per: 2014/ 1
Sequence 1 1 Y Y To Yr/Per: 2014/12
Sequence 2 9 Y N Budget Year: 2014
Sequence 3 11 Y N Print totals only: Y
Sequence 4 0 N N Format type: 1
Double space: N
Report title: Suppress zero bal accts: Y
Amounts/totals exceed 999 million dollars: N
FY 2013-2014 Roll projects to object: N
Print journal detail: N
Includes accounts exceeding Oo of budget. From Yr/Per: 2014/ 1
Print Full or Short description: F To Yr/Per: 2014/ 2
Print full GL account: N Include budget entries: Y
Sort by full GL account: N Incl encumb/liq entries: Y
Print Revenues-Version headings: Y Sort by JE # or PO #: J
Print revenue as credit: Y Detail format option: 1
Print revenue budgets as zero: N Multiyear view: D
07/29/2014 10:36 �City of Ukiah �P 1
gowen �BALANCE SHEET FOR 2014 12 �glbalsht
FUND: 777 AIRPORT FUND /
NET CHANGE ACCOUNT
FUND: 777 AIRPORT FUND FOR PERIOD BALANCE
ASSETS
77700000 10101 POOLED CASH -59,039.22 -161, 993.35
77700000 10298 MARKET VALUE ADJUSTMENT .00 -406.18
77700000 10303 PRE-PAID INSURANCE -1,531.25 .00
77700000 10320 PRE-PAID DEPOSITS .00 800.00
77700000 10410 ACCOUNTS RECEIVABLE 24, 662.41 29,592.17
77700000 10481 ACCRUED INTEREST .00 1,723.36
77700000 10600 ALLOWANCE FOR BAD DEBT .00 -125.00
77700000 19010 LAND .00 271, 957.47
77700000 19015 INFRASTRUCTURE .00 1,055,147.91
77700000 19020 LAND IMPROVEMENTS .00 1,290, 900.17
77700000 19040 BUILDINGS .00 542, 676.71
77700000 19080 ROLLING EQUIPMENT .00 86,214.56
77700000 19090 MACHINERY .00 38,766.82
77700000 19515 INFRASTRUCTURE DEPRECIATION .00 -1,055,147.91
77700000 19520 DEPRECIATION-LAND IMPROVEMENTS .00 -653,306.98
77700000 19540 BUILDINGS DEPRECIATION .00 -392,141.62
77700000 19580 ROLLING EQUIPMENT DEPRECIATION .00 -75,535.96
77700000 19590 MACHINERY DEPRECIATION .00 -28, 669.42
TOTAL ASSETS -35, 908.06 950,452.75
LIABILITIES
77700000 20100 ACCOUNTS PAYABLE -8,702.53 -8,404.53
77700000 20150 AP CONTRACT RETAINAGE .00 -.01
77700000 20560 ACCRUED VACATION .00 -14,147.08
77700000 21110 CUSTOMER DEPOSITS .00 -5,400.00
TOTAL LIABILITIES -8,702.53 -27, 951.62
FUND BALANCE
77700000 30001 ENCUMBRANCE CONTROL 902.16 902.16
77700000 30002 ENCUMBRANCES - BUDGET FB RESER -902.16 -902.16
77700000 30004 APPROPRIATIONS .00 -1,811, 943.30
77700000 30005 REVENUE CONTROL -74,503.37 -955, 640.43
77700000 30006 EXPENDITURE CONTROL 119,113.96 1,410,356.53
77700000 30007 FUND BALANCE .00 -296,355.48
77700000 30009 ESTIMATED REVENUE .00 1, 627,334.00
77700000 30010 BUDGETARY FUND BALANCE UNRESER .00 184, 609.30
77700000 31009 INVESTMENT IN FIXED ASSETS .00 -1,080,861.75
TOTAL FUND BALANCE 44, 610.59 -922,501.13
TOTAL LIABILITIES + FUND BALANCE 35, 908.06 -950,452.75
** END OF REPORT - Generated by Greg Owen **
07/29/2014 City of Ukiah PAGE 1
10:31:08 FY 2012-2013 glflxrpt
FROM 2013 O1 TO 2013 12
ACCOUNTS FOR: ORIGINAL ESTIM REV REVISED ACTUAL REMAINING PCT
777 AIRPORT FUND ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL
77700000 AIRPORT FUND
44201 AIRPORT GAS & OIL SALES -1,056,000 0 -1,056,000 -1,396,065.21 340,065.21 132.20
44202 AIRPORT OPERATION FEES -7,000 0 -7,000 -5,124.00 -1,876.00 73.2%
44203 AIRPORT MISC. SALES -3,000 0 -3,000 -780.00 -2,220.00 26.Oo
44204 AIRPORT LANDING FEES -7,500 0 -7,500 -26,790.00 19,290.00 357.2%
46110 INTEREST ON INVESTMENTS -476 0 -476 -2,155.97 1,679.97 452.90
46116 MISCELLANEOUS INCOME 0 0 0 -1,609.00 1,609.00 .0%
46801 AIRPORT GROUND RENT -90,000 0 -90,000 -98,251.14 8,251.14 109.20
46802 AIRPORT ADMIN BLDG RENT -9,000 0 -9,000 -9,336.00 336.00 103.7%
46803 AIRPORT HANGAR RENT -125,000 0 -125,000 -127,802.30 2,802.30 102.20
46804 FAA BUILDING -8,000 0 -8,000 -8,666.14 666.14 108.30
46805 CORPORATION YARD LAND RENTAL 0 0 0 -23,000.00 23,000.00 .Oo
46806 COMMISSION ON HANGAR RENTAL 0 0 0 -156.98 156.98 .0%
48110 MISCELLANEOUS RECEIPTS 0 0 0 -410.00 410.00 .Oo
TOTAL AIRPORT FUND -1,305,976 0 -1,305, 976 -1,700,146.74 394,170.74 130.20
77725200 AIRPORT OPERATIONS
51110 REGULAR SALARIES & WAGES 129,464 0 129,464 163,762.64 -34,298.64 126.50
51120 NON-REGULAR SALARIES & WAGES 70,000 0 70,000 27,629.15 42,370.85 39.50
51130 OVERTIME SALARIES & WAGES 1,818 0 1,818 3,396.48 -1,578.48 186.80
51150 ACCRUED SALARIES & BENEFITS 0 0 0 4,845.04 -4,845.04 .0%
51210 RETIREMENT (PERS) 36,033 0 36,033 38,317.20 -2,284.20 106.30
51220 INSURANCE 57,100 0 57,100 44,420.67 12,679.33 77.80
51230 WORKERS COMP 10,567 0 10,567 8,717.81 1,849.19 82.50
51240 MEDICARE 2,918 0 2, 918 2,804.55 113.45 96.1%
51250 UNEMPLOYMENT 1,995 0 1, 995 2,017.03 -22.03 101.10
51260 FICA 3,472 0 3,472 2,571.70 900.30 74.10
51290 CELL PHONE STIPEND 0 0 0 150.00 -150.00 .Oo
52100 CONTRACTED SERVICES 8,700 0 8,700 13,934.80 -5,234.80 160.2%
52528 LIABILITY INSURANCE 23,116 0 23,116 4,830.00 18,286.00 20.90
54100 SUPPLIES 12,000 0 12,000 16,012.36 -4,012.36 133.40
54101 POSTAGE 400 0 400 294.09 105.91 73.50
55100 TELEPHONE 3,000 0 3,000 2,730.27 269.73 91.0%
55210 UTILITIES 25,000 0 25,000 26,117.39 -1,117.39 104.50
56110 CITY GARAGE - PARTS 9,005 -8, 668 337 311.04 25.96 92.30
07/29/2014 City of Ukiah PAGE 2
10:31:08 FY 2012-2013 glflxrpt
FROM 2013 O1 TO 2013 12
ACCOUNTS FOR: ORIGINAL ESTIM REV REVISED ACTUAL REMAINING PCT
777 AIRPORT FUND ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL
56111 CITY GARAGE - LABOR 337 8,668 9,005 8,310.96 694.04 92.30
56120 EQUIPMENT MAINTENANCE & REPAIR 200 0 200 239.54 -39.54 119.8%
56130 EXTERNAL SERVICES 4,000 0 4,000 7,422.48 -3,422.48 185.60
56210 FUEL & FLUIDS 5,000 0 5,000 3,746.26 1,253.74 74.9%
56300 BUILDING MAINT. & REPAIR 50,000 0 50,000 29,742.39 20,257.61 59.50
57100 CONFERENCE & TRAINING 5,000 0 5,000 3,227.26 1,772.74 64.5%
57300 MEMBERSHIPS & SUBSCRIPTIONS 800 0 800 395.00 405.00 49.40
58401 AVIATION FUEL 769,000 0 769,000 1,057,382.83 -288,382.83 137.5%
59100 PROPERTY TAXES PAID 1,072 0 1,072 1,107.54 -35.54 103.30
61100 GENERAL GOVERNMENT ALLOCATION 68,856 0 68,856 68,856.00 .00 100.Oo
61200 PURCHASING ALLOCATION 2,072 0 2,072 2,072.04 -.04 100.00
61300 BILLING & COLLECTION ALLOCATIO 11,457 0 11,457 11,457.00 .00 100.0%
61500 INSURANCE ALLOCATION 18,375 0 18,375 18,375.00 .00 100.Oo
80100 MACHINERY & EQUIPMENT 0 0 0 .00 .00 .0%
94400 DEPRECIATION 0 0 0 83.35 -83.35 .Oo
TOTAL AIRPORT OPERATIONS 1,330,757 0 1,330,757 1,575,279.87 -244,522.87 118.40
TOTAL AIRPORT FUND 24,781 0 24,781 -124,866.87 149,647.87-503.90
TOTAL REVENUES -1,305,976 0 -1,305, 976 -1,700,146.74 394,170.74
TOTAL EXPENSES 1,330,757 0 1,330,757 1,575,279.87 -244,522.87
07/29/2014 City of Ukiah PAGE 3
10:31:08 FY 2012-2013 glflxrpt
FROM 2013 O1 TO 2013 12
ORIGINAL ESTIM REV REVISED ACTUAL REMAINING PCT
ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL
GRAND TOTAL 24,781 0 24,781 -124,866.87 149,647.87-503.90
07/29/2014 City of Ukiah PAGE 4
10:31:09 FY 2012-2013 glflxrpt
REPORT OPTIONS
Field # Total Page Break From Yr/Per: 2013/ 1
Sequence 1 1 Y Y To Yr/Per: 2013/12
Sequence 2 9 Y N Budget Year: 2013
Sequence 3 11 Y N Print totals only: Y
Sequence 4 0 N N Format type: 1
Double space: N
Report title: Suppress zero bal accts: Y
Amounts/totals exceed 999 million dollars: N
FY 2012-2013 Roll projects to object: N
Print journal detail: N
Includes accounts exceeding Oo of budget. From Yr/Per: 2014/ 1
Print Full or Short description: F To Yr/Per: 2014/ 2
Print full GL account: N Include budget entries: Y
Sort by full GL account: N Incl encumb/liq entries: Y
Print Revenues-Version headings: Y Sort by JE # or PO #: J
Print revenue as credit: Y Detail format option: 1
Print revenue budgets as zero: N Multiyear view: D
07/29/2014 10:37 �City of Ukiah �P 1
gowen �BALANCE SHEET FOR 2013 12 �glbalsht
FUND: 777 AIRPORT FUND /
NET CHANGE ACCOUNT
FUND: 777 AIRPORT FUND FOR PERIOD BALANCE
ASSETS
77700000 10101 POOLED CASH 7,247.20 314,346.88
77700000 10298 MARKET VALUE ADJUSTMENT .00 -273.63
77700000 10303 PRE-PAID INSURANCE 10,718.71 18,375.00
77700000 10320 PRE-PAID DEPOSITS .00 800.00
77700000 10410 ACCOUNTS RECEIVABLE 13,165.93 40,195.19
77700000 10481 ACCRUED INTEREST .00 342.06
77700000 10600 ALLOWANCE FOR BAD DEBT .00 -125.00
77700000 19010 LAND .00 271, 957.47
77700000 19015 INFRASTRUCTURE .00 1,055,147.91
77700000 19020 LAND IMPROVEMENTS .00 1,290, 900.17
77700000 19040 BUILDINGS .00 542, 676.71
77700000 19080 ROLLING EQUIPMENT .00 86,214.56
77700000 19090 MACHINERY .00 38,766.82
77700000 19515 INFRASTRUCTURE DEPRECIATION .00 -1,055,147.91
77700000 19520 DEPRECIATION-LAND IMPROVEMENTS .00 -606,479.64
77700000 19540 BUILDINGS DEPRECIATION .00 -382,236.24
77700000 19580 ROLLING EQUIPMENT DEPRECIATION .00 -71, 976.43
77700000 19590 MACHINERY DEPRECIATION .00 -25,792.74
TOTAL ASSETS 31,131.84 1,517, 691.18
LIABILITIES
77700000 20100 ACCOUNTS PAYABLE -49,808.51 -50,413.01
77700000 20150 AP CONTRACT RETAINAGE .00 -.01
77700000 20550 PAYROLL PAYABLE -6,814.88 -6,814.88
77700000 20560 ACCRUED VACATION -4,845.04 -14,147.08
77700000 21110 CUSTOMER DEPOSITS -100.00 -5,200.00
TOTAL LIABILITIES -61,568.43 -76,574.98
FUND BALANCE
77700000 30004 APPROPRIATIONS .00 -1,330,757.00
77700000 30005 REVENUE CONTROL -173,328.25 -1,700,146.74
77700000 30006 EXPENDITURE CONTROL 203,764.84 1,575,279.87
77700000 30007 FUND BALANCE .00 -172,218.65
77700000 30009 ESTIMATED REVENUE .00 1,305, 976.00
77700000 30010 BUDGETARY FUND BALANCE UNRESER .00 24,781.00
77700000 31009 INVESTMENT IN FIXED ASSETS .00 -1,144,030.68
TOTAL FUND BALANCE 30,436.59 -1,441,116.20
TOTAL LIABILITIES + FUND BALANCE -31,131.84 -1,517, 691.18
** END OF REPORT - Generated by Greg Owen **