Loading...
HomeMy WebLinkAbout09022014-packet UKIAH AIRPORT COMMISSION OLD F.S.S. Building 1403 South State Street, Ukiah, CA Tuesday, September 2, 2014 6:00 p.m. AGENDA 1. CALL TO ORDER 2. PLEDGE OF ALLEGIANCE 3. APPROVAL OF MINUTES —August 5, 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. Mendocino County Airport Land Use Commission B. Airport Maintenance C. Airport Commission Recording Secretary D. Fuel Tank E. Airport Business Plan 6. REPORTS A. Airport Monthly Financial B. ALP Update 7. AGENDA ITEMS FOR NEXT MONTH 8. COMMISSIONER/STAFF COMMENTS 9. ADJOURNMENT 1 UKIAH REGIONAL AIRPORT COMMISSION 2 August 5, 2014 3 Minutes 4 5 COMMISSIONERS PRESENT STAFF PRESENT 6 Carl Steinmann, Chair Greg Owen, Airport Manager 7 Eric Crane Cathy Elawadly, recording Secretary 8 Gordon Elton 9 10 COMMISSIONERS ABSENT OTHERS PRESENT 11 Dottie Deerwester 12 Don Albright 13 14 1. CALL TO ORDER 15 The Airport Commission meeting was called to order by Chair Steinmann at 6:00 p.m. at the Ukiah 16 Regional Airport, Old Flight Service Station, 1403 South State Street, Ukiah, California. Roll Call was 17 taken with the results listed above. 18 19 2. PLEDGE OF ALLEGIANCE - Everyone recited the pledge of allegiance. 20 21 3. APPROVAL OF MINUTES- June 3, 2014 22 23 Commissioner Elton made the following corrections to the June 3, 2014 minutes: 24 • Page 1, line 44, revised to read: `Fuel sales seem low for where we are this budget year.' 25 • Page 1, line 46, `annuals' should read `actuals.' 26 27 M/S Crane/Elton to approve June 3, 2014 minutes, as amended. Motion carried (3-0). 28 29 4. AUDIENCE COMMENTS ON NON-AGENDA ITEMS 30 31 5. DISCUSSION/ACTION 32 33 5A. Budget 2014-15/Airport Monthly Financial Report 34 New budqet 35 Airport Manager Owen referred to financial documents provided for this agenda item and made the 36 following comments/notations: 37 • Related to his financial spreadsheet for FY 2014-15 these figures show revenues/expenditures 38 for the newly approved budget where the intent of this document is to simplify and/or provide for a 39 financial summary of Airport operating expenses and revenues for ease of understanding. 40 Additionally, 'City of Ukiah Proposed Operating Budget Airport Enterprise Fund Detail for Fiscal 41 Year 2014/2015' is a financial document that provides budget information in a changed and/or 42 different format by individually categorizing assigned expenses. For example, former assigned 43 expense 291 account (City new financial system account #77725200-61100), General 44 Government Service Charges' is now detailed/broken down where the associated expenses are 45 individually billed/charged as shown on the spreadsheet. The Airport Commission has wanted 46 City Administration to provide this type of breakdown information to show exactly what the Airport 47 allocates to the 291 account. 48 • Related to line items `General Government Allocation' and `Billing & Collection Allocation' in the 49 detailed financial budget document budget information for FY 2014 and corresponding projected 50 figures for FY 2014 is shown but not for FY budget 2015. For example, referred to `Billing & 51 Collection Allocation for Budget FY 2014, $12,487 is shown as paid where for 2015 there is no 52 budget for this line item. Acknowledged while there is a `Billing & Collection Costs' expense line 53 item as shown on the spreadsheet, related to the detail financial document `Billing & Collection 54 Allocation' is now lumped/included in Miscellaneous General Government Expenses' and is no MINUTES of the Ukiah Airport Commission August 5, 2014 Page 1 1 longer billed as a separate expense item. The Airport is still being charged for billing & collection 2 that is now less than in past fiscal years. 3 • Related to the two aforementioned budget documents, noted expense items `Billing & Collection 4 Allocation' and `Group Insurance' have gone down. 5 6 Commissioner Elton: 7 • It appears the capital expenses are not included in the summary spreadsheet formulated by staff. 8 • Related to the detail financial sheet asked about `Information Technology Fixed Assets,' 9 `Machinery & EquipmenY that indicates a $3,000 expense for equipment and requested 10 clarification this is in addition to the $13,364 IT charges (see Gen Govt Service Charges, IT = 11 $13,364). 12 • Asked about the total budget figure. 13 14 Commissioner Crane: 15 • Requested clarification regarding 'new approved budget' on the spreadsheet financial document 16 and the intent of the other column to the left. 17 • While it is good the 291 account breaks down what is allocated in this regard, it is not possible 18 moving forward to backtrack how this expense account is broken down for past fiscal budget 19 years for comparison purposes. 20 • Asked whether the old City financial accounting system is still being used. 21 22 Airport Manager Owen: 23 • Confirmed capital expenses are not included in the summary spreadsheet. Noted the summary 24 sheet does show $200,000 budgeted for 'Machinery & Equipment.' Did not include this figure in 25 the spreadsheet other than for informational purposes because staff has no knowledge how this 26 allocation will be spent. The detail sheet relative to `Airport Operations Fixed Assets' does show 27 what is budged for Machinery& Equipment. 28 • Confirmed the $3,000 is in addition to the$13,364 IT charge. 29 • 'New approved budget' is the budget Council approved for FY 2014-15. The column to the left of 30 this column is staff's budget figures that were submitted. 31 • Relative to total expenses in the budget must consider cost of new fuel tank. It may be the Airport 32 may secure a loan for all or a portion of the cost so the 'true' total expense figure is not known. 33 Confirmed the Airport budget of $1,310,848 would include the $200,000 anticipated cost for the 34 fuel tank. 35 • Has no knowledge whether or not City administration still uses the old financial system parallel 36 with the new software accounting system. City administration was using both systems 37 simultaneously. Airport staff uses the new financial software system. 38 39 Past budqet years 40 41 Airport Manager Owen: 42 • The other financial documents in the agenda packet pertain to the year-end and monthly financial 43 reports and statements. 44 • The accounting discrepancy associated with EPIC has been resolved with City Administration. 45 While there is money still to be posted, the balance sheet as of July 1 shows the Airport has 46 received money from EPIC. Pooled cash shows a balance of $151,194.07. Accounts 47 Receivables shows a negative balance of $272,232.24 and this is because receivables money 48 still needs to be posted. The Airport should not be showing a negative balance in this regard. 49 50 Commissioner Elton: 51 • Questioned whether there is really a problem with 'Accounts Receivables' that may not have 52 been fully resolved. The receivables account should be a positive rather than a negative. 53 • Would like to have a report at the next regular commission meeting about updated posting of 54 transactions to the receivables account. 55 MINUTES of the Ukiah Airport Commission August 5, 2014 Page 2 1 Airport Manager Owen: 2 • Confirmed `Accounts Receivables' account has not been updated and explained how so such that 3 according to staff's receipts gross revenue should be approximately $939,000. Confirmed the 4 receivables account should be a positive figure. Noted close out figures have not been posted. 5 Will watch the adjustments to the receivables account to make certain they are done 6 accurately/correctly. 7 • Referred to the fuel sales/revenue sheet showing data for the last five years and talked about fuel 8 sales/purchases. In terms of Avgas fuel sales, the helicopter school no longer operates at the 9 Airport such that fuel sales in June were lost in this regard. Much of the fuel sales revenue for 10 June was generated from this school. 11 • Noted net fuel sales revenue as of June 30, 2014 is $280,224.78. Drew attention to the fuel cost 12 versus the net fuel sales data as well as gallons purchased versus gallons sold for 2013/14 fiscal 13 budget year. 14 • Explained fuel cost structuring and identified specific associated costs relative to taxes and/or 15 other assigned costs that create fuel cost discrepancies. 16 • The intent of the fuel sales/revenue sheet is to show/compare fuel costs/revenue trends for last 17 five fiscal years. 18 • Cited FY 2009/10 to demonstrate the difference in net Jet A fuel sales comparatively to the 19 current fiscal year and this can be attributed to the mark-up differentials. The Airport made almost 20 $100,000 more this year in Jet A fuel sales than in past fiscal years because of the mark-up 21 differential so even though the Airport has sold less volume of fuel, the fuel revenue has 22 increased. The Airport has restructured the price of fuel so revenue has increased for all type of 23 fuel sold. Changing the mark-up price for what the Airport charges for fuel has increased net 24 revenue in this regard. The price of fuel for Calstar has also increased. 25 26 Chair Steinmann: 27 • The fuel sales/revenue data is helpful. It is easy to see when the Airport has had a better fire 28 year. 29 30 Commissioner Elton: 31 • Is the amount of fuel in the tanks tracked? 32 • Related to fuel sales/revenue data pertinent to gallons sold compared to purchases over the past 33 three years indicates the Airport has accumulated a 10,000 gallon balance and/or increase of 34 fuel in storage and finds this to be a significant increase. 35 • Asked the question, if fuel is purchased June 30th, this would be considered a June purchase. If 36 the invoice for this purchase is not received by the Airport until July 1 St for the June 30tn 37 purchase, would this be included in the June posting of data? 38 39 Airport Manager Owen: 40 • Staff does not typically track how much fuel is stored in the tanks. However, Airport operations 41 make sure there is ample fuel on hand in the tanks, particularly during fire season. Right now the 42 Airport has been selling a tank of fuel every few days. 43 • The records showing a discrepancy related to gallons of fuel on hand compared to fuel sold could 44 be the result of the Airport purchasing of fuel and how soon the Airport is billed. For instance, 45 fuel may be purchased at the end of a month, but the Airport is not charged until the next month 46 and/or fuel is not sold until the next month where the records would show an increase in gallons 47 purchased but not sold. This posting of data creates an overlap with regard to gallons sold 48 compared to purchases that is reflected on the fuel sales/revenue data. Fuel is purchased 49 according to anticipated demand and price per gallon and sold as prescribed within the 50 guidelines of the Airport's fuel pricing and mark-up policy. 51 • City Finance Department posts fuel data. 52 53 Commissioner Elton: 54 • Information relevant to figures showing fuel on hand compared to fuel sold has nothing to do with 55 City Finance. MINUTES of the Ukiah Airport Commission August 5, 2014 Page 3 1 • Finds the fuel purchases/sales report not useful information. Is of the opinion if, for instance, fuel 2 is purchased June 30t", all invoicing/billing should be associated with the purchase date rather 3 than some other date it was posted/credited to the account because the data would then show an 4 overlap and/or discrepancy. 5 • Is of the opinion Airport staff should be aware of fuel inventory at all times. The data on the fuel 6 purchases/sales reports indicate a 10,000 gallon gain in fuel inventory. How is the fuel revenue 7 budget formulated? Important to understand number of gallons of fuel on hand/purchased 8 compared to determining number of gallons sold/to be allocated. 9 10 Airport Manager Owen: 11 • Related to fuel purchases/sales report looks at when City Finance posts the information. Uses 12 fuel invoices for the year when formulating the fuel purchases/sales report. 13 • Understands Commissioner Elton's concern about posting of fuel data and how the information is 14 not accurate and will correct the issue. 15 • Related to the fuel revenue budget, looks at the averages of fuel sold for a particular fiscal year. 16 • Commented on the fuel budgets for the different fiscal years for comparison purposes, i.e., 17 revenues versus expenses. 18 • Related to anticipating how much fuel to purchase particularly during fire season is speculative. 19 20 Commissioner Crane: 21 • Will the Airport Commission revisit the fuel pricing restructuring and mark-up any time soon? 22 23 Airport Manager Owen: 24 • The pricing schedule is reviewed every five years.Will review this timeframe. 25 • Further review of financial reports specific to Airport budgets for FY 2012-13, 2013-14 and 26 balance sheets for 2014 and 2015. 27 28 Commission: 29 • Finds the financial reports/data informative/useful. 30 31 5B. Airport Maintenance 32 Airport Manager Owen: 33 • Maintenance around the Airport declined for the month of June due to a staff injury. 34 • Staff has been working on the mowing of grass on the runway. 35 36 There was Commission discussion concerning slurry seal work and possible improvements to the 37 taxiways in this regard. 38 39 Airport Manager Owen: 40 • Related to slurry seal work, going back out to bid with bid openings occurring on August 19th. The 41 plan is to slurry seal from the Ashiku hangar to include T&M Aviation, West Coast Wings, Calstar 42 area to the FEDEX building and corresponding ramp areas. 43 • Talked about tie-down materials for aircraft and the gradual conversion from nylon rope to chain. 44 Chain is more durable than rope. 45 46 5C. Airport Commission Recording Secretary 47 Airport Manager Owen: 48 • Would like Commission's input regarding replacement and/or alternative methodologies for 49 minute taking relative to the recording secretary for the Airport Commission. 50 • Recording Secretary Elawadly will be available for the next couple of Commission meetings. 51 52 Recording Secretary Elawadly: 53 • Talked about the duties associated with her function as recording secretary for the Ukiah Airport 54 Commission. 55 MINUTES of the Ukiah Airport Commission August 5, 2014 Page 4 1 Commission: 2 • Generally discussed this matter including the possibility that the minutes could be action rather 3 than summary. 4 • Would like more time to discuss replacement alternatives when all the Commissioners are 5 present. 6 7 5D. Fuel Tank 8 Airport Manager Owen gave an update concerning a requested proposal from Mead & Hunt to provide a 9 design and bid specifications for two different tank options: 10 • Mead & Hunt sent a proposal for this firm to complete a spec and the cost for this service is 11 approximately$60,000. This spec is not what the Airport was anticipating. 12 • The Airport has not been pleased with EPIC, the current fueling vendor. Customer service has 13 really declined particularly when staff requests a load of fuel and/or for some other need. 14 • Discussed about the possibility of sending a RFP for a new fuel vendor. It may be if a new fuel 15 vendor is found that this vendor could install a tank as part of the contract. The issue is while staff 16 was looking at Mead & Hunt to complete a spec for a new fuel tank the cost also includes all that 17 is associated with the project management side of the project where staff is of the opinion the 18 cost is too high for an approximate$100,000 tank. 19 • The purpose of the spec would be to make certain the aspects of the project standards comply 20 with all regulating jurisdictions, including that aspect related to project 21 managemenUadministration. 22 • Staff will make a determination what approach to take. It may be some of the specifications in the 23 Mead & Hunt RFP can be eliminated. 24 • Getting the necessary spec for the project that includes the tank and all elements involved that 25 meet with the expectation of what staff wants and at a reasonable cost is the issue. 26 27 Commission: 28 • It would appear as an alternative option to paying Mead & Hunt an exorbitant amount of money to 29 cover all project management components that a firm installing the tank would be able to do the 30 same as part of the cost of purchasing the tank. 31 32 Airport Manager Owen: 33 • The concern has been that a fuel tank business would not be able to handle all the environmental 34 issues associated with the installation of a fuel tank. 35 • Will proceed with a RFP to tank vendors to see what prospects are available and how much of 36 the project requirements such a vendor can perform and at what cost. 37 38 Commission: 39 • Supports going out to bid for a tank vendor to purchase the tank and do the installation. 40 41 There was Commission discussion about possible environmental issues that would need to be addressed 42 such as ensuring proper containment in the event of a fuel spill and/or other issues and what 43 materials/elements are necessary to comply with environmental regulations. 44 45 5E. Airport Business Plan: 46 Airport Manager Owen: 47 • Subcommittee has yet to meet to review the building inventory at the Airport that would be a 48 component of the business plan. 49 • Would like to concentrate more closely on getting the business plan completed. 50 51 REPORTS 52 6A. Airport Day 53 Airport Manager Owen: 54 • While it was very hot day, Airport Day was quite well attended and a successful event. 55 MINUTES of the Ukiah Airport Commission August 5, 2014 Page 5 1 6B. ALP Update 2 Airport Manager Owen: 3 • The FAA is in the process of reviewing the technical aspects of the ALP Update. Changes 4 requested by the FAA will be incorporated into the document. 5 6 Commissioner Crane: 7 • Does the ALP Update include the matter of possibly having to shorten the runway? Recalls one 8 particular drawing that he did not support related to the matter of shortening the runway length 9 when Mead & Hunt presented and discussed the ALP Update with the Commission. Asked about 10 the justification for shortening the runway length? How is this related to the Displaced Threshold 11 and Relocated Threshold? 12 13 Chair Steinmann: 14 • How does the Little River Airport FAA runway improvement project factor/compare to Ukiah 15 Airport's desire to maintain a 100-foot width where the FAA paid for improvements to the 100-foot 16 runway at Little River? 17 18 Airport Manager Owen: 19 • Confirmed the ALP Update document must include all FAA fundamental requirements associated 20 with the FAA Runway Improvement project. The Ukiah Airport is classified as a B2 airport and 21 currently has a runway with a 100-foot width. For a B2 airport classification the FAA will only fund 22 for runway improvements having a 75-foot width. 23 • Staff will convey to the FAA that while a 75-foot width for the runway is required, this is not what 24 the Airport wants. Understands the FAA will only pay for runway improvements relative to a 75- 25 foot width. It may be the Airport can continue to maintain a 100-foot width but would have to seek 26 funding elsewhere for the extra 25 feet of runway width. 27 • Related to the Little River Airport FAA runway improvement project, this occurred before the FAA 28 Advisory Circular was updated. The FAA Advisory Circular now requires a 75-foot runway width 29 for airports with a B2 classification. 30 • Shortening the runway length has to do with approach surfaces and/or approach coming into the 31 Airport and this is where the FAA calculates the length. Related to the Displaced Threshold the 32 FAA calls this the `In-Line Taxiway' and this pertains to essentially the end of the runway. 33 34 Commissioner Crane: 35 • Would the FAA consider labeling the `In-Line Taxiway' into something else so this section of the 36 runway can be used as it has been? How much of the runway length would be lost? 37 38 Airport Manager Owen: 39 • The FAA will not consider renaming the `In-Line Taxiway.' Does not anticipate much loss of 40 runway length. Essentially the Airport will lose approximately 500 feet of pavement associated 41 with what was formerly called the `Displaced Threshold.' As such, the Airport will gain some of the 42 runway length back. It is just a matter of how much length the Airport will get back. 43 • The Airport Commission will have an opportunity to review the ALP Update document and make 44 comments before it goes to Council for review and adoption. 45 • The plan after approval of the ALP Update is to move forward on the grant for the design aspects 46 of the FAA Runway Improvement project in 2015 with actual construction occurring in 2016. 47 48 There was discussion concerning how many layers of paving material have been applied to the existing 49 runway over the years. 50 51 There was also additional discussion about the ALP Update and feasibility of taxiways and/or allowing for 52 more space on the eastside of the Airport for future use by possibly moving the centerline of the runway 53 in either direction and would this provide more useable space on the east or west side of the Airport. 54 However, the FAA will not pay to relocate the Localizer. It would cost about $800,000 to relocate the 55 Localizer. It was determined there would be no benefit to moving the centerline because everything is MINUTES of the Ukiah Airport Commission August 5, 2014 Page 6 1 either built up to this line and/or it just would not be advantageous as a benefit to even consider because 2 of how the Airport has developed/built-out. 3 4 7. AGENDA ITEMS FOR AUGUST 5 1. Budget 2014-15/Airport Monthly Financial Report 6 2. Airport Maintenance 7 3. Airport Commission Recording Secretary 8 4. Fuel Tank 9 5. Airport Business Plan 10 6. ALP Update 11 12 8. COMMISSIONER COMMENTS/STAFF COMMENTS 13 Commission asked about the status of the new tenant in the former small engine repair shop. 14 15 There was Commission discussion about Willits hospital inviting Calstar to relocate to Willits Airport. It 16 was noted `REACH' is located at Lampson Airport in Lakeport. 17 18 9. ADJOURNMENT 19 There being no further business, the meeting adjourned at 7:40 p.m. 20 21 22 Cathy Elawadly, Recording Secretary 23 24 MINUTES of the Ukiah Airport Commission August 5, 2014 Page 7 5. DISCUSSION/ACTION 5a. Mendocino County Airport Land Use Commission The purpose of the Mendocino County Airport Land Use Commission (ALUC) is to conduct airport land use compatibility planning. ALUCs protect public health, safety, and welfare by ensuring the orderly expansion of airports and the adoption of land use measures that minimize the public's exposure to excessive noise and safety hazards within areas around public airports to the extent that these areas are not already devoted to incompatible uses. The Mendocino County Airport Land Use Commission has 7 members; 3 of the members are selected by the City Selection Committee. The committee is comprised of Mayors from the Cities of Ukiah, Willits and Little River. Currently there is vacancy in the Mendocino County Airport Land Use Commission that needs to be filled. Staff is requesting the Airport Commission make a recommendation to Council on the selection. (The Commission can chose nominate someone for this position) 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 will report on current status. 5e. Airport Business Plan Staff will discuss the business plan status. 6. REPORTS 6a. Airport Monthly Financial Report Attachments 2014 ytd, 2015 ytd, 2015 balance sheet, 2014 balance sheet 6b. ALP Update Staff will give verbal report. 08/26/2014 11:15 �City of Ukiah �P 1 gowen �BALANCE SHEET FOR 2014 2 �glbalsht FUND: 777 AIRPORT FUND / NET CHANGE ACCOUNT FUND: 777 AIRPORT FUND FOR PERIOD BALANCE ASSETS 77700000 10101 POOLED CASH -20,393.28 318,761.16 77700000 10298 MARKET VALUE ADJUSTMENT .00 -406.18 77700000 10303 PRE-PAID INSURANCE -1,531.25 15,312.50 77700000 10320 PRE-PAID DEPOSITS .00 800.00 77700000 10410 ACCOUNTS RECEIVABLE -1,573.84 1, 698.92 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 -23,498.37 1,418, 626.51 LIABILITIES 77700000 20100 ACCOUNTS PAYABLE 56, 922.29 -30,821.09 77700000 20150 AP CONTRACT RETAINAGE .00 -.01 77700000 20560 ACCRUED VACATION .00 -14,147.08 77700000 21110 CUSTOMER DEPOSITS -200.00 -5,400.00 TOTAL LIABILITIES 56,722.29 -50,368.18 FUND BALANCE 77700000 30004 APPROPRIATIONS .00 -1,756,355.00 77700000 30005 REVENUE CONTROL -143, 634.00 -238,343.05 77700000 30006 EXPENDITURE CONTROL 110,410.08 247,301.95 77700000 30007 FUND BALANCE .00 -296,355.48 77700000 30009 ESTIMATED REVENUE .00 1, 627,334.00 77700000 30010 BUDGETARY FUND BALANCE UNRESER .00 129,021.00 77700000 31009 INVESTMENT IN FIXED ASSETS .00 -1,080,861.75 TOTAL FUND BALANCE -33,223.92 -1,368,258.33 TOTAL LIABILITIES + FUND BALANCE 23,498.37 -1,418, 626.51 ** END OF REPORT - Generated by Greg Owen ** 08/26/2014 11:14 �City of Ukiah �P 1 gowen �BALANCE SHEET FOR 2014 1 �glbalsht FUND: 777 AIRPORT FUND / NET CHANGE ACCOUNT FUND: 777 AIRPORT FUND FOR PERIOD BALANCE ASSETS 77700000 10101 POOLED CASH 8,411.35 339,154.44 77700000 10298 MARKET VALUE ADJUSTMENT .00 -406.18 77700000 10303 PRE-PAID INSURANCE 16,843.75 16,843.75 77700000 10320 PRE-PAID DEPOSITS .00 800.00 77700000 10410 ACCOUNTS RECEIVABLE -36, 922.43 3,272.76 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 -11, 667.33 1,442,124.88 LIABILITIES 77700000 20100 ACCOUNTS PAYABLE -37,330.37 -87,743.38 77700000 20150 AP CONTRACT RETAINAGE .00 -.01 77700000 20550 PAYROLL PAYABLE 6,814.88 .00 77700000 20560 ACCRUED VACATION .00 -14,147.08 77700000 21110 CUSTOMER DEPOSITS .00 -5,200.00 TOTAL LIABILITIES -30,515.49 -107,090.47 FUND BALANCE 77700000 30004 APPROPRIATIONS -1,756,355.00 -1,756,355.00 77700000 30005 REVENUE CONTROL -94,709.05 -94,709.05 77700000 30006 EXPENDITURE CONTROL 136,891.87 136,891.87 77700000 30007 FUND BALANCE .00 -296,355.48 77700000 30009 ESTIMATED REVENUE 1, 627,334.00 1, 627,334.00 77700000 30010 BUDGETARY FUND BALANCE UNRESER 129,021.00 129,021.00 77700000 31009 INVESTMENT IN FIXED ASSETS .00 -1,080,861.75 TOTAL FUND BALANCE 42,182.82 -1,335,034.41 TOTAL LIABILITIES + FUND BALANCE 11, 667.33 -1,442,124.88 ** END OF REPORT - Generated by Greg Owen ** 08/26/2014 11:12 �City of Ukiah �P 1 gowen �BALANCE SHEET FOR 2015 2 �glbalsht FUND: 777 AIRPORT FUND / NET CHANGE ACCOUNT FUND: 777 AIRPORT FUND FOR PERIOD BALANCE ASSETS 77700000 10101 POOLED CASH -248,260.92 -255,890.02 77700000 10298 MARKET VALUE ADJUSTMENT .00 -406.18 77700000 10320 PRE-PAID DEPOSITS .00 800.00 77700000 10410 ACCOUNTS RECEIVABLE 8, 991.00 10,445.76 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 -239,269.92 837,409.67 LIABILITIES 77700000 20100 ACCOUNTS PAYABLE 27,895.39 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 27,895.39 -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 -45,250.62 -76,721.58 77700000 30006 EXPENDITURE CONTROL 256, 625.15 425,331.59 77700000 30007 FUND BALANCE .00 -85, 908.84 77700000 31009 INVESTMENT IN FIXED ASSETS .00 -1,080,861.75 TOTAL FUND BALANCE 211,374.53 -818,160.58 TOTAL LIABILITIES + FUND BALANCE 239,269.92 -837,409.67 ** END OF REPORT - Generated by Greg Owen ** 08/26/2014 City of Ukiah PAGE 1 11:29:14 FY 2014-2015 glflxrpt FROM 2015 O1 TO 2015 O1 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,062,500 0 -1,062,500 -1,188.75 -1,061,311.25 .10 44202 AIRPORT OPERATION FEES -7,000 0 -7,000 -574.00 -6,426.00 8.2% 44203 AIRPORT MISC. SALES -1,500 0 -1,500 .00 -1,500.00 .Oo 44204 AIRPORT LANDING FEES -12,000 0 -12,000 .00 -12,000.00 .0% 46110 INTEREST ON INVESTMENTS -3,500 0 -3,500 .00 -3,500.00 .Oo 46116 MISCELLANEOUS INCOME -1,777 0 -1,777 -261.00 -1,516.00 14.7% 46801 AIRPORT GROUND RENT -90,000 0 -90,000 -13,119.00 -76,881.00 14.60 46802 AIRPORT ADMIN BLDG RENT -9,000 0 -9,000 -849.00 -8,151.00 9.4% 46803 AIRPORT HANGAR RENT -125,000 0 -125,000 -12,692.00 -112,308.00 10.20 46804 FAA BUILDING -8,244 0 -8,244 -2,625.38 -5,618.62 31.80 46805 CORPORATION YARD LAND RENTAL -20,000 0 -20,000 .00 -20,000.00 .Oo 46806 COMMISSION ON HANGAR RENTAL -1,046 0 -1,046 -161.83 -884.17 15.5% 48110 MISCELLANEOUS RECEIPTS -100 0 -100 .00 -100.00 .Oo TOTAL AIRPORT FUND -1,341,667 0 -1,341, 667 -31,470.96 -1,310,196.04 2.30 77710000 CITY COUNCIL 51110 REGULAR SALARIES & WAGES 1,060 0 1,060 40.70 1,019.30 3.80 51220 INSURANCE 1,268 0 1,268 52.72 1,215.28 4.2% 51230 WORKERS COMP 101 0 101 3.94 97.06 3.90 51240 MEDICARE 19 0 19 .60 18.40 3.2% 51260 FICA 68 0 68 2.50 65.50 3.70 54101 POSTAGE 2 0 2 .00 2.00 .Oo 55100 TELEPHONE 16 0 16 .00 16.00 .Oo 57100 CONFERENCE & TRAINING 100 0 100 .00 100.00 .0% 61410 RENT ALLOCATION 469 0 469 .00 469.00 .Oo 61420 BUILDING MAINTENANCE ALLOCATIO 1,591 0 1,591 .00 1,591.00 .0% 61425 ALLOCATED UTILITIES 357 0 357 .00 357.00 .Oo TOTAL CITY COUNCIL 5,051 0 5,051 100.46 4,950.54 2.Oo 77711100 CITY CLERK 08/26/2014 City of Ukiah PAGE 2 11:29:14 FY 2014-2015 glflxrpt FROM 2015 O1 TO 2015 O1 ACCOUNTS FOR: ORIGINAL ESTIM REV REVISED ACTUAL REMAINING PCT 777 AIRPORT FUND ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL 51110 REGULAR SALARIES & WAGES 2,048 0 2,048 78.68 1,969.32 3.80 51210 RETIREMENT (PERS) 572 0 572 21.99 550.01 3.8% 51220 INSURANCE 617 0 617 19.26 597.74 3.10 51230 WORKERS COMP 112 0 112 4.11 107.89 3.7% 51240 MEDICARE 29 0 29 1.20 27.80 4.10 51250 UNEMPLOYMENT 28 0 28 .98 27.02 3.5% 52100 CONTRACTED SERVICES 616 0 616 .00 616.00 .Oo 52150 LEGAL SERVICES/EXPENSES 380 0 380 .00 380.00 .0% 54100 SUPPLIES 100 0 100 .00 100.00 .Oo 54101 POSTAGE 4 0 4 .00 4.00 .0% 55100 TELEPHONE 14 0 14 .00 14.00 .Oo 56120 EQUIPMENT MAINTENANCE & REPAIR 10 0 10 .00 10.00 .0% 57100 CONFERENCE & TRAINING 92 0 92 .00 92.00 .Oo 57300 MEMBERSHIPS & SUBSCRIPTIONS 11 0 11 .00 11.00 .0% 61410 RENT ALLOCATION 158 0 158 .00 158.00 .Oo 61420 BUILDING MAINTENANCE ALLOCATIO 533 0 533 .00 533.00 .0% 61425 ALLOCATED UTILITIES 120 0 120 .00 120.00 .Oo TOTAL CITY CLERK 5,444 0 5,444 126.22 5,317.78 2.30 77712100 CITY MANAGER 51110 REGULAR SALARIES & WAGES 3,150 0 3,150 121.15 3,028.85 3.80 51210 RETIREMENT (PERS) 919 0 919 35.32 883.68 3.80 51220 INSURANCE 334 0 334 12.84 321.16 3.80 51230 WORKERS COMP 148 0 148 5.65 142.35 3.8% 51240 MEDICARE 46 0 46 1.73 44.27 3.80 51250 UNEMPLOYMENT 36 0 36 1.34 34.66 3.70 51290 CELL PHONE STIPEND 16 0 16 .42 15.58 2.60 52100 CONTRACTED SERVICES 700 0 700 .00 700.00 .0% 54100 SUPPLIES 125 0 125 .00 125.00 .Oo 54101 POSTAGE 3 0 3 .00 3.00 .Oo 55100 TELEPHONE 55 0 55 .00 55.00 .Oo 55210 UTILITIES 30 0 30 .00 30.00 .0% 57100 CONFERENCE & TRAINING 122 0 122 .00 122.00 .Oo 57300 MEMBERSHIPS & SUBSCRIPTIONS 76 0 76 .00 76.00 .0% 61410 RENT ALLOCATION 155 0 155 .00 155.00 .Oo 61420 BUILDING MAINTENANCE ALLOCATIO 248 0 248 .00 248.00 .0% 61425 ALLOCATED UTILITIES 335 0 335 .00 335.00 .Oo TOTAL CITY MANAGER 6,498 0 6,498 178.45 6,319.55 2.70 08/26/2014 City of Ukiah PAGE 3 11:29:15 FY 2014-2015 glflxrpt FROM 2015 O1 TO 2015 O1 ACCOUNTS FOR: ORIGINAL ESTIM REV REVISED ACTUAL REMAINING PCT 777 AIRPORT FUND ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL 77712400 MISCELLANEOUS GENERAL GOV 61500 INSURANCE ALLOCATION 6,486 0 6,486 .00 6,486.00 .Oo TOTAL MISCELLANEOUS GENERAL GOV 6,486 0 6,486 .00 6,486.00 .Oo 77713400 ACCOUNTING 51110 REGULAR SALARIES & WAGES 12,682 0 12, 682 464.08 12,217.92 3.70 51210 RETIREMENT (PERS) 3,451 0 3,451 131.90 3,319.10 3.80 51220 INSURANCE 2,338 0 2,338 93.45 2,244.55 4.Oo 51230 WORKERS COMP 632 0 632 23.46 608.54 3.7% 51240 MEDICARE 194 0 194 6.73 187.27 3.50 51250 UNEMPLOYMENT 155 0 155 5.58 149.42 3.6% 51290 CELL PHONE STIPEND 21 0 21 .85 20.15 4.Oo 52100 CONTRACTED SERVICES 3,312 0 3,312 .00 3,312.00 .0% 54100 SUPPLIES 340 0 340 .00 340.00 .Oo 54101 POSTAGE 104 0 104 .00 104.00 .0% 55100 TELEPHONE 48 0 48 .00 48.00 .Oo 56120 EQUIPMENT MAINTENANCE & REPAIR 80 0 80 .00 80.00 .0% 57100 CONFERENCE & TRAINING 200 0 200 .00 200.00 .Oo 57300 MEMBERSHIPS & SUBSCRIPTIONS 17 0 17 .00 17.00 .0% 61200 PURCHASING ALLOCATION 1,565 0 1,565 .00 1,565.00 .Oo 61300 BILLING & COLLECTION ALLOCATIO 8,029 0 8,029 .00 8,029.00 .0% 61425 ALLOCATED UTILITIES 119 0 119 .00 119.00 .Oo TOTAL ACCOUNTING 33,287 0 33,287 726.05 32,560.95 2.20 77714000 CITY ATTORNEY 52100 CONTRACTED SERVICES 1,800 0 1,800 .00 1,800.00 .Oo 55100 TELEPHONE 3 0 3 .00 3.00 .Oo 57100 CONFERENCE & TRAINING 12 0 12 .00 12.00 .Oo TOTAL CITY ATTORNEY 1,815 0 1,815 .00 1,815.00 .Oo 77715100 TREASURY MANAGEMENT 08/26/2014 City of Ukiah PAGE 4 11:29:15 FY 2014-2015 glflxrpt FROM 2015 O1 TO 2015 O1 ACCOUNTS FOR: ORIGINAL ESTIM REV REVISED ACTUAL REMAINING PCT 777 AIRPORT FUND ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL 51110 REGULAR SALARIES & WAGES 36 0 36 1.38 34.62 3.80 51220 INSURANCE 13 0 13 .51 12.49 3.90 51230 WORKERS COMP 3 0 3 .08 2.92 2.70 51240 MEDICARE 2 0 2 .02 1.98 1.0% 51260 FICA 3 0 3 .09 2.91 3.Oo 52100 CONTRACTED SERVICES 800 0 800 .00 800.00 .Oo TOTAL TREASURY MANAGEMENT 857 0 857 2.08 854.92 .2% 77716100 HUMAN RESOURCES 51110 REGULAR SALARIES & WAGES 2,271 0 2,271 84.34 2,186.66 3.7% 51210 RETIREMENT (PERS) 611 0 611 24.27 586.73 4.Oo 51220 INSURANCE 200 0 200 7.46 192.54 3.7% 51230 WORKERS COMP 106 0 106 3.87 102.13 3.70 51240 MEDICARE 34 0 34 1.20 32.80 3.50 51250 UNEMPLOYMENT 28 0 28 .92 27.08 3.30 51290 CELL PHONE STIPEND 11 0 11 .24 10.76 2.2% 52100 CONTRACTED SERVICES 250 0 250 .00 250.00 .Oo 52151 AFLAC & PERS INSUR ADMIN FEES 60 0 60 .00 60.00 .0% 54101 POSTAGE 9 0 9 .00 9.00 .Oo 54160 HR - CITY LIABILITY & CONTRACT 20 0 20 .00 20.00 .0% 54161 HR - BACKGROUND & PHYSICALS 100 0 100 .00 100.00 .Oo 54162 HR - ADVERTISING 120 0 120 .00 120.00 .Oo 54163 HR - INTERVIEW SUPPLIES 9 0 9 .00 9.00 .Oo 54164 HR - FORMS & OTHER DIV. EXP. 30 0 30 .00 30.00 .0% 54165 HR - NEW EMPLOYEE FINGERPRINT 12 0 12 .00 12.00 .Oo 54166 HR - DOT TESTING PROGRAM 18 0 18 .00 18.00 .0% 55100 TELEPHONE 10 0 10 .00 10.00 .Oo 57100 CONFERENCE & TRAINING 45 0 45 .00 45.00 .0% 57300 MEMBERSHIPS & SUBSCRIPTIONS 69 0 69 .00 69.00 .Oo 61410 RENT ALLOCATION 17 0 17 .00 17.00 .0% 61420 BUILDING MAINTENANCE ALLOCATIO 59 0 59 .00 59.00 .Oo 61425 ALLOCATED UTILITIES 13 0 13 .00 13.00 .0% TOTAL HUMAN RESOURCES 4,102 0 4,102 122.30 3,979.70 3.Oo 77722900 INFORMATION TECHNOLOGY 08/26/2014 City of Ukiah PAGE 5 11:29:15 FY 2014-2015 glflxrpt FROM 2015 O1 TO 2015 O1 ACCOUNTS FOR: ORIGINAL ESTIM REV REVISED ACTUAL REMAINING PCT 777 AIRPORT FUND ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL 51110 REGULAR SALARIES & WAGES 3,305 0 3,305 80.70 3,224.30 2.40 51120 NON-REGULAR SALARIES & WAGES 480 0 480 51.90 428.10 10.8% 51130 OVERTIME SALARIES & WAGES 0 0 0 8.58 -8.58 .Oo 51140 STAND-BY SALARIES & WAGES 0 0 0 19.10 -19.10 .0% 51210 RETIREMENT (PERS) 911 0 911 29.27 881.73 3.20 51220 INSURANCE 796 0 796 25.68 770.32 3.20 51230 WORKERS COMP 197 0 197 7.85 189.15 4.Oo 51240 MEDICARE 57 0 57 2.25 54.75 3.9% 51250 UNEMPLOYMENT 53 0 53 1.87 51.13 3.50 51260 FICA 30 0 30 1.73 28.27 5.80 51290 CELL PHONE STIPEND 24 0 24 .94 23.06 3.90 52100 CONTRACTED SERVICES 2,600 0 2, 600 .00 2,600.00 .0% 54100 SUPPLIES 1,000 0 1,000 .00 1,000.00 .Oo 54101 POSTAGE 5 0 5 .00 5.00 .Oo 54320 SOFTWARE 2,500 0 2,500 .00 2,500.00 .Oo 55100 TELEPHONE 100 0 100 .00 100.00 .0% 56120 EQUIPMENT MAINTENANCE & REPAIR 720 0 720 .00 720.00 .Oo 57100 CONFERENCE & TRAINING 350 0 350 .00 350.00 .Oo 57300 MEMBERSHIPS & SUBSCRIPTIONS 16 0 16 .00 16.00 .Oo 61410 RENT ALLOCATION 180 0 180 .00 180.00 .0% 61420 BUILDING MAINTENANCE ALLOCATIO 40 0 40 .00 40.00 .Oo 80100 MACHINERY & EQUIPMENT 3,000 0 3,000 .00 3,000.00 .Oo TOTAL INFORMATION TECHNOLOGY 16,364 0 16,364 229.87 16,134.13 1.4% 77725200 AIRPORT OPERATIONS 51110 REGULAR SALARIES & WAGES 193,908 0 193, 908 14,334.85 179,573.15 7.40 51130 OVERTIME SALARIES & WAGES 2,159 0 2,159 28.71 2,130.29 1.30 51210 RETIREMENT (PERS) 53,540 0 53,540 2,725.11 50,814.89 5.1% 51220 INSURANCE 47,780 0 47,780 1,804.05 45,975.95 3.80 51230 WORKERS COMP 10,030 0 10,030 681.43 9,348.57 6.80 51240 MEDICARE 2,674 0 2, 674 197.24 2,476.76 7.40 51250 UNEMPLOYMENT 2,392 0 2,392 162.24 2,229.76 6.8% 51260 FICA 0 0 0 .00 .00 .Oo 51290 CELL PHONE STIPEND 1,008 0 1,008 57.00 951.00 5.70 52100 CONTRACTED SERVICES 8,700 0 8,700 4,168.11 4,531.89 47.90 52528 LIABILITY INSURANCE 8,000 0 8,000 .00 8,000.00 .0% 54100 SUPPLIES 14,000 0 14,000 27.93 13,972.07 .20 54101 POSTAGE 300 0 300 8.99 291.01 3.Oo 08/26/2014 City of Ukiah PAGE 6 11:29:16 FY 2014-2015 glflxrpt FROM 2015 O1 TO 2015 O1 ACCOUNTS FOR: ORIGINAL ESTIM REV REVISED ACTUAL REMAINING PCT 777 AIRPORT FUND ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL 55100 TELEPHONE 2,500 0 2,500 159.27 2,340.73 6.40 55210 UTILITIES 25,000 0 25,000 39.36 24,960.64 .20 56110 CITY GARAGE - PARTS 514 0 514 .00 514.00 .Oo 56111 CITY GARAGE - LABOR 13,723 0 13,723 .00 13,723.00 .0% 56120 EQUIPMENT MAINTENANCE & REPAIR 200 0 200 .00 200.00 .Oo 56130 EXTERNAL SERVICES 400 0 400 698.77 -298.77 174.70 56210 FUEL & FLUIDS 5,000 0 5,000 -720.73 5,720.73 -14.40 56300 BUILDING MAINT. & REPAIR 50,000 0 50,000 .00 50,000.00 .0% 57100 CONFERENCE & TRAINING 5,000 0 5,000 1,500.00 3,500.00 30.Oo 57300 MEMBERSHIPS & SUBSCRIPTIONS 800 0 800 .00 800.00 .Oo 58401 AVIATION FUEL 761,500 0 761,500 141,348.68 620,151.32 18.60 59100 PROPERTY TAXES PAID 1,072 0 1,072 .00 1,072.00 .0% 59101 FEES 1,244 0 1,244 .00 1,244.00 .Oo 61100 GENERAL GOVERNMENT ALLOCATION 0 0 0 .00 .00 .0% 61200 PURCHASING ALLOCATION 0 0 0 .00 .00 .Oo 61300 BILLING & COLLECTION ALLOCATIO 0 0 0 .00 .00 .0% 61500 INSURANCE ALLOCATION 0 0 0 .00 .00 .Oo 80100 MACHINERY & EQUIPMENT 200,000 0 200,000 .00 200,000.00 .Oo TOTAL AIRPORT OPERATIONS 1,411,444 0 1,411,444 167,221.01 1,244,222.99 11.8% TOTAL AIRPORT FUND 149,681 0 149, 681 137,235.48 12,445.52 91.7% TOTAL REVENUES -1,341,667 0 -1,341, 667 -31,470.96 -1,310,196.04 TOTAL EXPENSES 1,491,348 0 1,491,348 168,706.44 1,322,641.56 08/26/2014 City of Ukiah PAGE 7 11:29:16 FY 2014-2015 glflxrpt FROM 2015 O1 TO 2015 O1 ORIGINAL ESTIM REV REVISED ACTUAL REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL GRAND TOTAL 149,681 0 149, 681 137,235.48 12,445.52 91.70 08/26/2014 City of Ukiah PAGE 8 11:29:16 FY 2014-2015 glflxrpt REPORT OPTIONS Field # Total Page Break From Yr/Per: 2015/ 1 Sequence 1 1 Y Y To Yr/Per: 2015/ 1 Sequence 2 9 Y N Budget Year: 2015 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 2014-2015 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