Audit Reports
To view a summary of any of the following audit reports, click on the report name.
- Audit Report on Fleet Fuel (#0801)
- Final Audit Follow-Up as of September 30, 2007, Fire Operations (#0802)
- Audit Follow-up as of September 30, 2007, Emergency Management (#0803)
- Audit Follow-up as of September 30, 2007, 800 MHz Radio System (#0804)
- Audit of P-Card Activity at Selected City Departments and Offices (#0805)
- Audit Follow-Up as of September 30, 2007, The City's Parking Program (#0806)
- Audit Report on Citywide Disbursements 2007 (#0807)
- Inquiry into City Hall Roof Replacement (#0808)
- Audit Report on Take Home Vehicles (#0809)
- Audit Follow-Up on Gas Infrastructure (#0810)
- Audit Follow-Up on Fleet Fuel Operations (#0811)
- Final Audit Follow-Up on Pension Investments (#0812)
- Final Audit Follow-Up on Electric Revenues (#0813)
- Final Audit Follow-Up on Emergency Management (#0814)
- Audit Follow-Up on Police Overtime (#0815)
- Final Audit Follow-Up on The City's Parking Program (#0816)
- Audit of StarMetro Staffing (#0817)
- Audit Of Automated Deposit Reporting And Verification Processes (#0818)
- Audit Follow-Up of the Purchasing Section of the Procurement Services Division (#0819)
- Audit Report on Other Postemployment Benefits (OPEB) (#0819A)
- Inquiry into Misuse of City "Sam's Club Card" (PRNA) (#0820)
Audit Report on Fleet Fuel (#0801)
During a prior Audit of Fleet Parts Operations (2003), we were unable to provide assurances over accountability for fuel due to inadequate and unreliable fuel records. The purpose of this audit was to review current fuel operations to provide assurances that: fuel is properly safeguarded and accounted for as to fuel purchased, received, dispensed, and in inventory; fuel is bought and sold internally and externally at competitive prices; and fuel purchases and operations comply with applicable laws, policies, and contracts.
We provided recommendations to further enhance fuel operations, by:
- Enhancing the monthly fuel reconciliation processes, and implementing oversight controls to compensate for the lack of segregation of duties;
- Implementing additional controls over department-specific fuel tanks not managed by Fleet;
- Implementing additional physical and logical controls over FuelMaster dispensing unit cabinet keys, and user ids and passwords; and
- Updating fuel operations procedures and implementing performance measures to evaluate fuel operations efficiencies and effectiveness.
We also provided recommendations to:
- Further enhance compliance with state fuel tax laws by filing additional returns and related amended returns to obtain eligible refunds related to diesel fuel purchased for off-road use; and
- Process contract amendments according to City policy.
Since 2003, the accounting for and safeguarding of fuel has greatly improved. Management acquired and implemented the FuelMaster® Fuel Management System (FuelMaster), implemented a monthly reconciliation process to account for the fuel inventory, and implemented improved processes to track purchased and dispensed fuel. Overall, we concluded:
- The City bought fuel at competitive prices and sold fuel at competitive prices to internal and external customers.
- The billing processes were improved to bill for fuel dispensed as recorded in the FuelMaster system.
- Fuel purchased, dispensed, and in inventory was accounted for.
- Monthly vehicle usage, cost, and mileage reports, and fuel dispensed to individuals through personal accountability keys were distributed and readily available for departments to review.
- There were adequate physical and system security controls over access to fuel pumps and tanks.
- Fuel operations complied with applicable environmental laws.
Areas where improvements were needed related to:
- The monthly reconciliation processes did not include all tanks and deliveries, and a system process was not being performed accurately.
- One person was performing too many key procedures in fuel operations resulting in a lack of segregation of duties.
- Fuel operations procedures were outdated, and the performance measures were not being used to assist in managing fuel operations.
- The City did not file all eligible fuel tax refund returns and the prior returns submitted needed to be amended. Net eligible refunds amounts are estimated to be $26,666.
- View Full 0801 Audit (PDF)
Final Audit Follow-Up as of September 30, 2007, Fire Operations (#0802)
This is the third and final follow-up on the action plan steps originating from the Fire Operations Audit (#0612) issued April 25, 2006. Applicable City departments have completed 19 of the 20 (95%) action plan steps developed to address issues identified in the audit report.
In audit report #0612, issued April 25, 2006, we identified issues related to: 1) retaining fire vehicles for longer time periods; 2) complying with volunteer fire department (VFD) mutual agreements regarding the leased fire vehicles; 3) improving the consistency and quality of hydrant testing and reporting of deficiencies, maintenance and reporting of completed repairs, and notification of newly installed hydrants; 4) ensuring that ladders and hoses are properly identified, tested, and tracked; and 5) ensuring fire trucks have the appropriate equipment in the proper location. We provided specific recommendations to address these issues.
During the period April 1, 2007, through September 30, 2007, the Fire Department (Fire) took the following actions to complete two of the three remaining action plan steps due for the audit:
- Implemented a process to update the Geographical Information System (GIS) mapping data on their mobile computers so that current hydrant information is available in the field.
- Developed and implemented a process to uniquely identify, inventory and track the acquisition, testing, and disposition of fire hoses using the Fire Report Management System.
The remaining outstanding action plan step due is for the Department of Management and Administration (DMA) to review the Fleet Management Policy and work with Fleet to ensure the vehicle replacement rate calculation meets the policy's intentions. This final action step has been turned over to management for resolution.
Audit Follow-up as of September 30, 2007, Emergency Management (#0803)
This is the second follow-up on the action plan steps originating from the Emergency Management Program Audit (#0707) issued on January 8, 2007. The Fire Department and Department of Management and Administration completed 10 of the 13 (77%) action plan steps due during the period April 1, 2007, through September 30, 2007. Two action plan steps are behind schedule and one was deleted by management. Additionally, two action plan steps will be due in the next follow-up period.
In audit report #0707, we identified issues related to the administration of the Emergency Management (EM) program and the EM planning and preparation activities. We provided specific recommendations to address these issues.
Between April 1, 2007, and September 30, 2007, the following actions have taken place:
- The EM coordinator implemented many activities to meet National Incident Management System (NIMS) requirements, including adopting NIMS, providing training for employees, and conducting periodic self-assessments.
- StarMetro developed an evacuation plan that was accepted by the County EM program for bus transportation during emergency preparation, response, and recovery.
- The City Manager and staff evaluated the organizational structure and determined that management support within the current organizational structure provides the EM coordinator with the needed responsibility and authority to effectively coordinate the EM operations in the City.
- Fire management indicated that the level of communications and effectiveness between the City and County EM personnel continues to improve.
- The EM coordinator solicited and received feedback from County EM personnel on the City's EM plan prior to the plan being presented to the City Commission for approval.
- The EM team reexamined the structure and composition of the EM teams and recruited additional members to fill team gaps. [Note: The Planning team is still in need of additional staff.]
- The EM coordinator and team members offered NIMS training to all leaders, managers, team members, and emergency response personnel. All key responders were trained in fire, police, public works, water and sewer, electric, Public Information Office, and aviation areas.
- The Radio Communications Division developed and implemented a backup communications plan for EM to ensure that there is adequate backup communications equipment available and educated users to operate the equipment should the primary communications systems be damaged and/or destroyed.
- The Assistant City Manager and staff evaluated the primary and secondary EOC locations. They feel that these locations are adequately equipped, tested, ready for fast activation (within one hour of need), and are the best locations available at this time.
- The Fire Department developed, implemented, and communicated standard operating procedure #608 that will help guide staff regarding emergency and non-emergency responses during periods of inclement and severe weather.
The two action steps behind schedule relate to: 1) periodically reevaluating the City's identified "critical applications," and prioritizing the order in which applications will be restored during a catastrophic event; and 2) evaluating and determining a cost-effective and beneficial method to identify and track costs associated with all EM associated activities.
Audit Follow-up as of September 30, 2007, 800 MHz Radio System (#0804)
In report #0614, we noted areas where improvements could be made to increase preparedness for emergencies/disasters, improve oversight of the 800 MHz radio system, and increase the physical security of the various 800 MHz radio system infrastructure and radio tower locations.
The Information Systems Services Radio Communications Division (RCD) has completed nine of the 17 action plan steps that were due as of September 30, 2007. Of the remaining eight action plan steps, seven have been amended to be completed by September 30, 2008, and one was deleted as management has accepted the risks identified in the initial audit report.
Overall, to address the action plan steps due this follow-up period, RCD has:
- conducted an assessment of the radio system which evaluated the strengths, weaknesses, opportunities, and threats of the system;
- developed a process to document the activities/projects conducted by RCD;
- conducted and documented a risk assessment of disaster planning;
- conducted an impact analysis;
- developed and documented an emergency/disaster recovery plan;
- reviewed the 800 MHz system to ensure as many parts of the system were connected to the alarm system as appropriate;
- developed a process whereby the alarm system is periodically tested and such testing is documented; and
- developed a record of the individual components and spare parts of the 800 MHz system.
While RCD has had success in completing nine of the action plan steps due, completion of several remaining steps will require direction from the Public Safety Communications Board (PSCB) that replaced the Management Oversight Committee (MOC) in July 2006.
In addition to the steps that were delayed, one step was deleted because management has decided to accept the risk the step was designed to mitigate. That step related to moisture sensors in the shelters that house components of the 800 MHz radio system infrastructure.
Audit of P-Card Activity at Selected City Departments and Offices (#0805)
This audit of P-Card activity within selected City departments was conducted as part of our 2007 annual audit plan. The purpose of the audit was to determine, for selected departments and offices, whether the City's P-Card program was operating efficiently, effectively, and according to good business practices.
The audit addressed activity during the sixteen-month period October 2005 through January 2007. P-Card activity within five separate City departments and offices was reviewed. Those five departments included NCS, UBCS, ISS, HR, and Parks and Recreation. In addition, we reviewed oversight and administrative activities performed by DMA and the Office of Treasurer-Clerk's Records Management Division (RMD).
Overall, we found that P-Card activities within the five audited departments and offices (as well as DMA and the Treasurer-Clerk's RMD) were efficient, effective, and in accordance with good business practices. For the most part, P-Cards were used only by staff to make authorized and appropriate acquisitions of goods and services. Adequate controls were generally in place. No instances of fraud were noted. However, risks were identified that increase the likelihood of (1) unauthorized purchases occurring and not being timely detected and/or (2) goods and services not being procured efficiently and in accordance with controlling rules, regulations, and guidelines. Those risks include:
- P-Card account information was not always adequately safeguarded. This included inappropriate assignment of system permissions allowing unauthorized access to account information within computer databases and not adequately securing records that contain cardholder account information.
- Management did not always adequately review P-Card purchase activity.
- Incompatible duties were not always adequately segregated.
- Cardholders did not always properly execute P-Card transactions. For instance, cardholders allowed other employees to use their P-Card to make purchases, transactions were split to circumvent transaction and spending limits, and competitive quotes were not obtained for larger purchases.
- Records were not always prepared to clearly document payment and receipt of purchased items.
- Purchases were not always accurately coded.
- Monthly cardholder statements were not always signed and dated as evidence that cardholders and their supervisors ensured the validity of charged transactions.
- Department procedures were not always updated to address current P-Card activities and controls.
Measures we recommend that management take to strengthen controls relative to the P-Card program include:
- Better restrict access to P-Card account information through modification of system permissions.
- Enhance management reviews of P-Card activity recorded in the PeopleSoft P-Card module.
- Have employees other than P-Card coders obtain and distribute monthly cardholder statements to cardholders and their supervisors (as a means to limit the coders' abilities to make unauthorized purchases without timely detection).
- Improve physical security over P-Card account numbers.
- Ensure cardholders execute transactions properly and in compliance with controlling rules, regulations, and guidelines. (This includes, for example, not allowing employees to use P-Cards of other employees to make purchases, not allowing splitting of transactions to circumvent spending or transaction limits, timely cancellation of P-Cards for terminating employees, not paying state sales taxes when possible, and procuring food only in accordance with the City Manager's Food Guidelines.)
- Better document events such as payment of invoices and receipt of items and better account for activity through more appropriate coding of transactions.
- Ensure that appropriate reviews of cardholder monthly statements are performed.
- Ensure proper and adequate support is maintained for executed transactions.
- Enhance and update existing written procedures and policies to adequately address aspects and processes relative to current P-Card activities.
To help ensure the identification and resolution of issues and risks that may exist at City departments and offices not included in the scope of this audit, we recommend that the respective Appointed Officials distribute this report to management of each City department and office for their review and follow through as applicable.
Audit Follow-Up as of September 30, 2007, The City's Parking Program (#0806)
This is the third follow-up on the action plan steps originating from the audit of the City's Parking Program (Report #0622) issued on September 8, 2006. In the original report, we identified issues and provided 16 recommendations toward developing a comprehensive and coordinated parking ticket program strategy and improving the accounting of the parking ticket inventory, management of internal controls over the parking program activities, and the integrity of computer based parking ticket information.
During the previous follow-up period, five of the 16 original action plan steps were completed and the targeted completion dates for the remaining 11 action plan steps were amended. Of the amended steps, five were due on September 30, 2007, and the six remaining steps will be due in future follow-up periods.
Our review of the five action steps due this period showed that departments completed three steps and made some progress on two steps. The following actions were completed:
- A review was performed of parking program activities and management reassigned staff to implement an adequate segregation of duties over the issuing, recording, voiding, reducing penalties associated with parking tickets, and receiving of payments.
- Criteria for when parking ticket fines and penalties should be voided or reduced was developed, documented, and implemented.
- An amendment to the Data Tickets contract to clarify terms related to the collection fee was executed.
Two action items were only partially completed:
- The Airport implemented a process to account for parking ticket stock purchased, issued, and in inventory. Police, however, still needs to develop a process to account for their parking ticket stock purchased, issued, and in inventory. Additionally, Utility Business and Customer Services (UBCS) needs to develop a process to ensure that all manually (handwritten) issued parking tickets are input into the Duncan Parking Ticket System (Duncan system).
- Police and Airport supervisors implemented a process to approve the parking tickets voided by officers and Parking Enforcement Technicians, and UBCS front-line supervisors are regularly performing first level reviews of all parking tickets voided and/or reduced. However, UBCS has not yet completed their scheduled second and third level reviews as outlined in the newly developed parking program guidelines.
During our review of the action plan steps due this period, we noted two related and continuing issues: 1) the parking program activities are not being effectively coordinated across the five departments; and 2) the lag time that occurs between when a handwritten ticket is issued and input into the Duncan system impacts citizens trying to pay the ticket on-line.
Audit Report on Citywide Disbursements 2007 (#0807)
Our audit covered the period July 1, 2006, through June 30, 2007. Total disbursements for that period, $718,233,988, were segregated, for purposes of our audit, into three broad categories: general disbursements; salary payments; and retirement benefit payments.
Generally, disbursements were proper, authorized, supported, correctly recorded, and in compliance with laws, rules, policies, and procedures. However, we did note instances where controls were not in place or operating effectively to ensure proper, timely, and efficient disbursement of City funds in accordance with City policies and procedures. Those instances included the following:
- There were no reconciliations of periodic payments to the Leon County Tax Collector for license tags and title registrations of City vehicles to the related license tags and registrations received.
- Cardholder account numbers were not always completely redacted from City purchasing card (P-Card) records stored electronically.
- Two transactions were not coded to appropriate accounts in the PeopleSoft Financials System.
- Two part-time City employees were allowed to participate in the City's health insurance program without working sufficient hours required to be eligible for that participation.
- A revised procedure used for determining a retiring employee's "best" salary for pension calculation purposes had unintended effects that resulted in some inconsistent and inequitable pension benefit determinations for some recent retirees.
Inquiry into City Hall Roof Replacement (#0808)
The purpose of this report is to communicate the results of our inquiry into assertions made in a telephone call received by the City Auditor's Office through the City's Fraud Hotline.
Audit Report on Take Home Vehicles (#0809)
This audit of take-home vehicles was conducted as part of our 2008 annual audit plan. The purpose of the audit was to identify all City vehicles that were taken home by a City employee during the audit period; identify and analyze related data including the types of vehicles; distances traveled, and associated costs; review and determine the adequacy of policies and procedures governing the taking home of vehicles by employees; including a comparison of City policies and procedures to those of other local governments; and provide options for management to consider that will create savings in commuting costs.
The audit addressed activity during the two-year period, January 1, 2006 through December 31, 2007. This audit also included all City departments that have vehicles taken home by employees.
Overall, we concluded that the policy governing take home vehicles needed to be improved. We noted:
- The criteria by which take-home vehicle decisions are made are not sufficient to determine if vehicles taken home were justified.
- Ambiguous terms that could be interpreted differently were not defined.
- There were no requirements that documentation be prepared to support the decision as to when vehicles should be taken home.
- Management's review and approval process for employees that take vehicles home needs improvement.
- Except for police, there were no limitations in the take-home vehicle policy on employee use of City vehicles that are taken home as to distance of commute or personal use. However, we did note some restrictions in other City procedures, such as the Personnel Policies and Procedures Manual.
- The responsibilities of the parties involved in the take-home vehicle process were not clearly delineated.
We have made recommendations to address the above identified issues, which include:
- Revise the criteria on which take-home vehicle decisions will be made;
- Eliminate or define terms that can be interpreted in numerous ways;
- Require documentation to support take-home vehicle decisions;
- Expand the review and approval process for take-home vehicles;
- Develop limitations on how far employees are allowed to commute with City vehicles; and
- Clearly delineate the responsibilities of all parties involved in the take-home vehicle process.
This audit analyzed the costs associated with vehicles that were reported as having been taken home by employees during the two-year audit period, January 1, 2006 through December 31, 2007.
Our analysis showed the estimated annual cost associated with employees taking vehicles home was approximately $1.4 million.
Our analysis also showed:
- There were 560 vehicles taken home by 604 employees during the two-year audit period.
- For take-home vehicles, total commuting distance for the two-year period was in excess of 4.2 million miles, of which 2.9 million miles related to the Police Department.
- Employees of the Police Department took 348 vehicles home representing 62% of all vehicles taken home and 97% of the 360 vehicles in the General Fund.
- We estimated the annual commuting cost associated with take-home vehicles to be over $1.4 million, with over $980,000 (70%) relating to the Police Department.
- Only a portion of the $1.4 million, estimated at $750,000 annually, has an immediate budgetary impact and includes the cost of fuel. The remainder of the cost is deferred until the applicable vehicles are replaced.
In light of the analysis of costs, we provided several options for consideration that would help control costs of commuting. Those options included:
- Management should prioritize the vehicles currently being taken home, taking cost and community safety into consideration.
- Limit the distance authorized for daily commuting.
- Charge employees for the use of the City vehicle for commuting purposes beyond distances established by policy.
- Employees must live within the limits of the City (County) and/or utility service area to be considered eligible for take-home vehicle responsibility.
- Require employees to leave vehicles at a secure location before they leave the City limits or utility service area.
- Replace take-home vehicles with mileage reimbursement when employees are recalled to duty during other than their normal working hours.
- Change the classes of vehicles that are used for business and take-home purposes to the most cost efficient practicable.
- Total vehicle mileage must meet City minimum vehicle utilization standards without the inclusion of commuting miles or the vehicle will be considered for elimination.
Audit Follow-Up on Gas Infrastructure (#0810)
The Gas Utility and other City departments have completed the eight action plan steps due for completion as of March 31, 2008. Six additional steps that were due subsequent to that date have also been completed.
In audit report #0727 we noted that, overall, the City has adequate and proper processes and procedures to ensure a safe and reliable infrastructure. We also noted that significant improvements and enhancements had been and were being made in regard to accounting for and tracking that infrastructure. We reported that installations of new infrastructure met federal and state requirements and that expansions and replacements were planned and funded. We reported that an effective public protection program was established. However, we also identified areas where improvements and enhancements were needed. Accordingly, recommendations were made to install an additional isolation valve, accurately designate critical valves in the Gas Utility geographic information system (GIS), develop a project management plan for refinement of the Gas Utility's GIS, protect stored pipe from environmental elements, ensure timely repair of leaks, and enhance monitoring of system pressures at a satellite utility facility. Recommendations were also made to improve documentation in several areas, including infrastructure testing and inspection, leak identification and repair, emergency notifications and responses, and other areas.
Twenty-seven action steps were developed to address the identified issues, for which eight were due for completion as of March 31, 2008. In our follow up we found that the Gas Utility (in conjunction with the Municipal Supply Center and Station 21, a satellite utility facility) has completed each of those eight steps and an additional six steps that were due for completion subsequent to that date. Actions that were completed included:
- A new isolation valve was installed at one of the gas regulating stations as prescribed by Public Service Commission (PSC) rules.
- The Gas Utility GIS was updated to properly and clearly depict critical (key and isolation) valves.
- Staff reassignments were made and management overview enhanced to ensure proper and timely testing of the cathodic protection system, and adequate tracking and timely repair of identified leaks.
- Monitoring of gas system pressures was enhanced at Station 21 through training and reestablishment of audible system alarms.
- Processes were established to ensure that dispatches of and responses to gas emergency notification are better documented and tracked.
- Updated pipe specifications and reorder points and quantities were identified and entered into the PeopleSoft Financials system.
Audit Follow-Up on Fleet Fuel Operations (#0811)
This is the first follow-up on the action plan steps originating from the audit of the City's Fleet Fuel Operations (Report #0801) issued on October 18, 2007.
During our audit, we noted that the accounting for and safeguarding of fuel had greatly improved since a prior audit conducted in 2003. Processes had been developed and implemented to better account for fuel purchased, issued, and in inventory and to better safeguard the City's fuel inventory. We also noted additional areas where improvements were needed and provided recommendations related to daily fuel operations, reconciliation processes, and fuel tax reporting. The audit report included management's action plan consisting of 15 action plan steps to address the recommendations in the audit report.
During the follow-up period October 1, 2007, through March 31, 2008, 13 action plan steps were due to be completed. Of those 13 steps, 7 have been completed and 6 were partially completed.
The seven steps completed during this period are related to:
- Incorporating all 30 tanks into the reconciliation process.
- Inputting all fuel purchases into the FuelMaster system.
- Inputting the gallons delivered per the invoice into the FuelMaster system.
- Controlling and safeguarding the master keys to the FuelMaster controller dispensing unit cabinets.
- Assigning individual user ids in the FuelMaster system.
- Determining and communicating what off-road equipment meets the eligibility for fuel tax refunds.
- Updating the fuel operations procedures to reflect current operating procedures.
The six steps partially completed during this period are related to:
- Ensuring that the calculated inventory balance and the FuelMaster system inventory balances are properly reconciled.
- Implementing a process to test the accuracy of the electronic tank monitoring system.
- Working with the Florida Department of Revenue to receive past eligible tax refunds and submit amended returns to exclude "off-road" fuel purchases on the "on-road" fuel tax returns.
- Implementing performance measures to assist in evaluating the efficiency and effectiveness of fuel operations.
- Assigning a systems administrator for the FuelMaster system different from the fuel operations supervisor.
- Implementing adequate password management controls within the FuelMaster system.
Final Audit Follow-Up on Pension Investments (#0812)
The Treasurer-Clerk's (T/C) Office and Accounting Services have completed 29 of the 32 action plan steps that were established to address issues identified in audit report #0621. T/C staff has made progress in completing the three remaining steps. Responsibility for following up to ensure completion of those three steps is turned over to T/C management.
In audit report #0621, we reviewed investment performance and activity for the City defined benefit and defined contribution pension plans. We found that, overall, the City had achieved its investment return goals and, as a result, the City's pension plans were in sound financial condition. However, areas were identified where improvements and enhancements were needed. For example:
- Adjustments and reallocations of investments were needed in a few instances to ensure pension funds are invested in compliance with state law and the City's investment policy.
- A separate investment policy was needed for the City's defined contribution plans.
- Various enhancements were needed in the monitoring and oversight functions.
Thirty-two action plan steps were established to address those issues. We found that T/C and Accounting Services staffs successfully completed 29 of those 32 steps. T/C staff has made progress in completing the three remaining steps.
Significant actions completed include:
- Transferring sufficient funds invested in international securities to domestic securities, in order to bring the City's portfolio into compliance with the 10% maximum allowed for police and firefighter plans;
- Establishing a separate investment policy for the City's defined contribution plans;
- Revising the investment policy for the City's defined benefit plan to address various issues identified in the audit;
- Measuring and evaluating investment performance net of fees as required by the investment policy for the defined benefit plan;
- Addressing investment policy benchmarks and key policy requirements in contracts with external managers;
- Preparing and retaining documentation that explains and justifies decisions made in the selection of external managers and funds;
- Enhancing reviews of custodian invoices;
- Requiring an external manager to reinvest City assets (held in unallowable securities) in allowable securities;
- Establishing and using checklists to ensure that external managers comply with key policy and contractual provisions and requirements;
- Reassigning system permissions to improve controls over wire transfers;
- Retaining all applicable contractual documents and related records;
- Resolving bank account reconciliation issues and enhancing the reconciliation process for the City's bank account;
- Providing Investment Advisory Committee (IAC) meeting minutes to T/C management and the IAC for their formal review and approval; and
- Establishing written procedures for various processes and practices.
Significant progress has been made by T/C staff on the three remaining steps. However, as of March 31, 2008, those steps had not been completed. Those three action plan steps include:
- Reconfirming authorization instructions with the custodian and third party administrator on an annual basis;
- Requiring all external managers to periodically certify that they are reconciling their records with records maintained by the City's custodian; and
- Ensuring future contracts with external managers require that the managers (1) reconcile their records and activity with that reported by the custodian, (2) report any significant unresolved errors or differences, and (3) periodically certify to the T/C that those reconciliations are being performed.
Responsibility for following up to ensure completion of those three steps is turned over to T/C management.
Final Audit Follow-Up on Electric Revenues (#0813)
Twenty-seven of the 29 action plan steps developed to address the issues identified in audit report #0602 have been completed or resolved as of March 31, 2008. Actions have been initiated but not completed for the two remaining steps. Responsibility for following up to ensure completion of those two steps is turned over to City utility management.
In audit report #0602, we concluded that, overall, electric consumption and related activities were properly billed. We also identified issues that indicated the need to better manage operations, activities, and records impacting electric consumption and related revenues. The audit also identified instances of unbilled consumption, billing errors, errors in the records used to determine the semiannual energy cost recovery rate, and errors in the application of non-consumption fees. In addition, the audit identified the need to enhance use of the PeopleSoft Customer Information System (CIS) to account for all meter activity and to enable an efficient process for identifying meters for periodic testing based on meter age and prior test dates.
Twenty-nine action plan steps were developed to address the identified issues. In our three previous follow ups on this audit, we reported that 21 of those 29 steps had been successfully completed. For this fourth and final follow up engagement, we found that:
- Six of the remaining 8 action plan steps were no longer applicable, as the City's current meters are scheduled to be replaced with new "smart" meters pursuant to the recently approved Automated Meter Infrastructure Project.
- Actions were initiated but not completed for the other two steps, which are intended to make operations more efficient for non-metered service points (i.e., area lights and cable) and to ensure accurate reflection of system data for those service points. Those two incomplete action steps are turned over to City utility management to ensure completion.
Final Audit Follow-Up on Emergency Management (#0814)
This is the third and final follow-up on the action plan steps originating from the Emergency Management Program Audit (#0707) issued on January 8, 2007. The Emergency Management Department and Department of Management and Administration has addressed all four action plan steps due during the period October 1, 2007, through April 30, 2008, by completing two steps and determining for the remaining two steps that no additional actions will be taken.
In audit report #0707, we identified issues related to the administration of the Emergency Management (EM) program and the EM planning and preparation activities. We provided specific recommendations to address these issues.
Between October 1, 2007, and April 30, 2008, the following actions have taken place:
- The EM Coordinator has reviewed the City department plans to ensure that all of the departments providing critical services have continuing operations (COOP) plans. Additionally, the EM Coordinator is continuing to seek grant funding to support the development of plans for those departments that have not yet developed a COOP plan.
- The EM Coordinator reviews COOP plans upon request for adequacy, appropriateness, and reasonableness, and coordinates periodic City exercises for the plans to be tested. To conduct more effective testing in the City, we have recommended that the EM Coordinator work with the City's Safety Coordinator to coordinate the testing of the City's emergency response activities.
For the two remaining steps, management has determined that no additional actions will be taken. The two steps are related to tracking the cost of EM planning activities, and prioritizing and sequencing a second tier of applications that would be next important to restore after a disaster.
Audit Follow-Up on Police Overtime (#0815)
Our original audit of Police overtime indicated that, overall, overtime costs were substantially valid, accurate, properly approved, and generally in compliance with City policies and procedures and Police Benevolent Association agreements. Other than a few exceptions, approval documentation existed for most of the overtime transactions sampled in our audit.
However, during the audit, we identified three areas related to the recording of overtime in the payroll system that should be improved. Management developed 11 action plan steps to address the issues in these 3 areas. All 11 action plan steps were due to be completed by March 31, 2008. Of the 11 steps, 5 steps were completed, 4 steps are partially completed, 1 step is behind schedule, and 1 step was deleted by management.
The five action steps completed included:
- Police revised its departmental procedures, updated their special event application process, and reported Police special event related activities and costs to the City Manager for FY 2007.
- The Police and Parks and Recreation Departments reviewed the Special Events policy and determined it to be sufficient. No changes were recommended.
- City management worked with Florida State University (FSU) to develop agreements for the 2007 football season. All agreed upon past due amounts were received by the City.
- The wording in the Human Resources policies and bargaining agreements regarding how overtime should be calculated on holidays was clarified.
- Training was provided to Police timekeepers regarding how to correctly calculate and input overtime worked on holidays.
The four partially completed steps are related to developing additional earn codes to better track overtime, implementing a process to periodically review payroll transactions involving overtime, and developing procedures to monitor retroactive adjustments and assure all adjustments are properly authorized and approved.
The one step behind schedule is related to addressing how Communication staff trainers are compensated and complying with the corresponding City policies.
The step deleted by management was related to reviewing past inconsistencies related to overtime pay on holidays to determine the most efficient and equitable method to address any prior discrepancies.
Final Audit Follow-Up on The City's Parking Program (#0816)
This is the third and final follow-up on the action plan steps originating from the audit of the City's Parking Program (Report #0622) issued on September 8, 2006. In the original report, we identified issues and provided 16 recommendations toward developing a comprehensive and coordinated parking ticket program strategy and improving the accounting of the parking ticket inventory, management of internal controls over the parking program activities, and the integrity of computer based parking ticket information.
To date, 13 of the 16 steps have been completed and 3 steps have been partially completed. The following five steps were completed during this period:
- The City's parking ordinance was revised introduced to the Commission at the end of June 2008.
- Final implementation of Police policies and procedures related to the accounting for parking tickets. New procedures were approved by the Police Chief to begin July 1, 2008.
- Staff evaluated and data needs for the parking program and developed procedures as to how data should be input and their status updated.
- A process was developed and implemented to purge invalid data in the Parking Ticket System.
- Accounting Services evaluated the unpaid parking tickets to determine whether the unpaid amount should be included in the City's financial statements as accounts receivable.
The three action plan steps that are in process but have not yet been fully implemented included:
- Performance measures - these have been developed, but have not yet been approved by management, accepted by the Parking Committee, or used to gauge the program's effectiveness.
- Final approval of citywide parking program policies and procedures.
- Due to change over in management, quarterly reviews by the UBCS manager will not be fully implemented until the end of the third quarter, 2008.
We are turning these partially completed action plan steps over to management for their final resolution.
Additionally, our review of parking committee meeting summaries and observations during the past two follow-up periods indicate a continuing need for coordination across the five departments in conducting City parking program activities. We recommend that the assigned Assistant City Manager meet with the parking committee to clarify the parking program's direction, goals and objectives, and resolve the outstanding issues to ensure that the parking program activities are coordinated across the City departments.
Audit of StarMetro Staffing (#0817)
This audit of StarMetro staffing of drivers and mechanics was requested by StarMetro management to assist in developing a methodology for determining staffing needs in the General Transit, Special Transportation, and Garage Divisions. Additionally, we assisted management in determining the costs of services for General Transit bus services.
The audit reviewed staffing levels for drivers and mechanics during fiscal year 2007 and costs of general transit services for fiscal years 2005 through 2007.
For General Transit, we provided recommendations related to reducing annual overtime costs by: 1) maximizing the use of temporary drivers to provide the services in addition to the regularly scheduled routes; 2) implementing more efficient routing and scheduling techniques, including automation, and accounting for all routes and known events in the regular scheduling; 3) improving budget planning and cost projections by including all scheduled routes, considering additional work, anticipated vacancy rates, and overtime paid on holidays; 4) improving StarMetro's ongoing monitoring over budgeted to actual expenditures; 5) working with the HR Safety Managers to evaluate reasons for and identify ways to minimize workers' compensation and leave without pay; and 6) implementing a method for tracking the amount of time employees are out of work due to workers' compensation and/or leave without pay.
For Special Transit, we provided recommendations toward reducing their annual overtime costs by: 1) further maximizing the use of temporary drivers to provide the services to fill the gap between scheduled drive hours and available driver hours; 2) tracking overtime on holidays by using the earn code designated for holiday overtime; 3) working with HR Safety Managers to evaluate reasons for and identify ways to minimize catastrophic leave, workers' compensation leave, and leave without pay; and 4) developing and implementing a method for tracking the amount of time employees are out of work due to workers' compensation and/or leave without pay.
For Garage, we provided recommendations to assist them in measuring mechanics' productivity levels in the future by: 1) implementing better record keeping processes to track mechanics' work time and manage operations; and 2) tracking overtime on holidays by using the earn code designated for holiday overtime.
For determining costs of General Transit services, we provided recommendations to ensure the validity and reliability of information used in management's calculations of costs of services.
For General Transit:
- We provided management with the methodology to estimate driver productivity to predict staffing needs, plan for services, and budget more effectively. For FY 2007, we estimated the driver productivity level was 82% (1,696 of total 2,080 hours for each driver).
- Overtime consistently increased over the past four years from 10% of total personnel costs in FY 2004 to 15% in FY 2007, with the majority of overtime in General Transit (81%) worked by full-time drivers.
- The FY 2007 budget for personnel services, while adjusted to include an additional 27 positions, was not sufficient to cover the actual costs.
- The three main contributing causes of overtime in FY 2007 in General Transit were: 1) 50%a of the overtime was to fill in for driver vacancies due to the time it took to fill the 27 added driver positions plus regular driver turnover; 2) filling in for other drivers taking unanticipated leave (workers' compensation and leave without pay); and 3) driving for special events, football games, charter services, and new and expanded services that were in addition to the regular fixed schedules.
For Special Transit:
- We provided management with the methodology to estimate driver productivity to predict staffing needs, plan for services, and budget more effectively. For FY 2007, we estimated the driver productivity level was 79% (1,641 of total 2,080 hours for each driver).
- Overtime increased slowly from 2% of total personnel costs in FY 2004 to 4% in FY 2006, and doubled to 8% in FY 2007 due to some unforeseen circumstances.
- The two main contributing causes of overtime in FY 2007 were: 1) covering for other drivers taking planned annual leave; and 2) filling in for other drivers taking unanticipated catastrophic leave, workers' compensation leave, and leave without pay.
For Garage:
- There was not enough reliable information to determine productivity levels for mechanics.
- Overtime has remained consistent averaging 12% of total personnel costs over the past four years.
- The three main contributing causes of overtime in FY 2007 were: 1) completing regular maintenance tasks; 2) covering for mechanics taking planned leave; and 3) providing mechanic support during extended hours of operations.
For determining costs of General Transit services, we concluded consistent processes were not performed in data collection to ensure the validity and reliability of the information used to determine costs of services.
Audit Of Automated Deposit Reporting And Verification Processes (#0818)
In December 2007, the Treasurer-Clerk requested an audit of the automated reporting and verification of deposits processes that were being implemented within the Revenue Division to provide assurances that there were adequate controls in place.
The automated reporting and verification of deposits processes included the implementation of a new collections reporting system, the Internet Payment Processing System (iPay). Staff utilizes the iPay system, the CORE cashiering system, downloaded bank deposit files, and the PeopleSoft Financials system to verify and report collections and deposits.
Our audit objectives were to determine whether there are adequate internal controls designed and in place within the new automated deposit reporting and verification processes conducted within the Treasurer-Clerk's Office to assure that all deposits reported received were accounted for (i.e., complete and accurate).
Our review included examining controls related to the automation of deposit reporting and verification processes, including selected general computer controls, application controls, and related manual activities. We identified those controls we noted were in place and those that needed to be addressed, along with the associated activities observed. For each control needing to be addressed, we provided the current status of the control and management's actions and/or plans to improve the control.
We concluded that the newly implemented automated deposit reporting and verification processes reviewed included adequate controls to assure that all deposits reported received were accounted for. Controls we noted that were in place were related to:
- Control Environment - leadership, organizational structure, and management's understanding of internal control and its impacts.
- Risk Assessment - management's identification, assessment, and mitigation of risks.
- Control Activities - data entry, transaction processing, verification of transactions and deposits, system access controls, resolution of rejected items, retention of source documentation, documented processes, and performance criteria to measure the level of success of the project.
- Information and Communication Activities - single point of data entry, availability, and ease of producing reports.
- Monitoring Activities - management's continuous review of operations.
During the audit, all identified potential issues were discussed with management for their review and timely resolution prior to the automated deposit reporting and verification processes being implemented across all City departments. There were five issues identified during the audit; two were addressed and three are in the process of being addressed.
The three issues being addressed relate to:
- 1. Eliminating the inefficiencies caused by the differences between when credit card deposits are reported by credit card companies and by City departments. Revenue management is working with the credit card companies to resolve the issue related to the credit cards and expects to have this issue resolved in October 2008.
- Recording of the "unlabeled" payments to resolve any differences between the CORE and financial systems. Revenue management is working with Accounting Services to determine the best way to record "unlabeled" payments so payments can be reconciled in CORE and the City's financial system.
- Measuring the success of the automation project. Criteria have been developed to measure the success of the automation project and management will measure the performance of the newly implemented processes over the next year.
The issues that were identified and addressed during the audit included:
- Duties needed to be segregated for two Revenue staff that have access to cash, are able to change records in the information systems, and are responsible for verifying deposits with the bank.
- All City employees with network accounts were mistakenly assigned "execute" access to the folder storing deposit information on the City's network, and other City departmental users in Accounting Services and Information System Services were mistakenly assigned update and delete access to the same network folder.
Audit Follow-Up of the Purchasing Section of the Procurement Services Division (#0819)
In audit report #0725, on the Purchasing Section of Procurement Services, we identified issues for improvement; in response, management developed 22 action plan steps to address those issues. The issues we identified broadly related to:
- The completion and issuance of procedures for the purchasing of goods and services,
- The development and implementation of departmental procedures to be followed throughout the procurement process,
- The improvement of procurement related training opportunities for City employees,
- The improvement of the perception of customer service provided by Procurement Services,
- The improvement of the document retention practices of Procurement Services,
- The improvement of the City's oversight of large sole source acquisitions, and
- The development of mechanisms for the customers of Procurement Services to provide feedback.
This is our first follow-up on the actions taken by Procurement Services in response to the audit. As of March 31, 2008, there were 16 action plan steps due to have been completed.
Our review of the 16 action plan steps due this follow-up period showed 5 steps were completed, 8 were partially completed and considered in progress, and 3 were adjusted to be completed at a later date.
Overall, during our review of the action plan steps due this period, we noted that Procurement Services is making progress in addressing the issues identified in our initial audit. For some action plan steps due, Procurement Services did not begin corrective actions until near the end of the review period.
A continuation of efforts by Procurement Services should allow the action plan steps that are currently identified as in progress to be completed before the end of the next follow-up reporting period, September 30, 2008.
Audit Report on Other Postemployment Benefits (OPEB) (#0819A)
In June 2004, the Governmental Accounting Standards Board (GASB) issued Statement No. 45 on Accounting and Financial Reporting by Employers for Postemployment Benefits Other Than Pensions. As a result, this statement became part of the body of knowledge known as generally accepted accounting principles (GAAP) and must be followed in the preparation and issuance of the City's Comprehensive Annual Financial Report for the 2007-2008 fiscal year.
Other Postemployment Benefits (OPEB) includes government healthcare, prescription drugs, and life insurance provided to employees during their retirement years. Historically, employees have been promised that in return for their services the City will pay a portion of their monthly healthcare premium when they retire. The City has made good on this promise by annually appropriating and expending current operating funds for its share of retiree healthcare premiums as they came due. This method of funding is referred to as a "pay-as-you-go" approach. As such, the City has not in the past set aside any monies to pay for future healthcare subsidies for current retirees or for employees currently working that will retire in the future.
GASB Statement No. 45 now requires recognition of OPEB costs at the time an employee provides services to the government. In other words, an accounting event has occurred and should be recognized at the time when there is an "exchange of benefits for services."
Historically, in exchange for services rendered by employees, the City has biweekly paid employees a salary and has at the same time set aside monies for its portion of the City pension to be paid employees in the future. However, the City (like many other cities nationwide) has not set aside monies for healthcare subsidies also promised employees in the future. As a result, a significant UAAL (unfunded actuarial accrued liability) now exists for current and retired employees that have rendered services in the past in exchange for future benefits.
GFOA (the Governmental Finance Officers Association) has stated that OPEB is a form of compensation and should always be considered as an integral part of an employee's total compensation package. Some have described OPEB as a form of deferred compensation.
For the year ending September 30, 2008, the City will be required to disclose the AAL (actuarial accrued liability) associated with OPEB in the notes to the City's financial statements along with a description of efforts and progress being made to fund the actuarial liability. If the City fully funds OPEB cost for the current year in an irrevocable trust, no liability will have to be recorded on the face of the financial statements. However, if the City does not establish a dedicated irrevocable trust fund and instead continues on a pay-as-you-go basis, the full amount of the ARC (Annual Required Contribution) will be reported as a liability in government-wide financial statements.
Even though not required, the City made early disclosure of the UAAL in its annual financial statement notes for the year ended September 30, 2007. Based on the actuary study at the time, on a pay-as-you-go basis the AAL would be $103,362,000; whereas, if the City had established a dedicated irrevocable trust fund for OPEB, the liability would be $60,520,000.
A July 8, 2008, updated study for the year beginning October 1, 2007, shows the AAL for an unfunded (pay-as-you-go) plan is now $123,122,000 and for a funded (a dedicated irrevocable trust) plan is now $73,688,000. The ARC for 2008 for an unfunded pay-as-you-go plan amounts to $9,975,000, and the ARC, for a funded plan where monies are placed in an irrevocable trust, amounts to $6,833,000.
The following summarizes issues relating to OPEB:
- The AAL (actuarial accrued liability) for OPEB has always been in existence; however, to date, the City has not been required to recognize or report the liability in externally issued financial reports.
- Postemployment healthcare benefits should be viewed and accounted for in the same manner as promised pension benefits. Employee salaries and benefits (including retiree pension and healthcare benefits) are earned and should be recognized at the time an "exchange of benefits for employee services" occurs regardless of when the government intends to pay for those services - even if payment is to be made several years into the future.
- Over the years, the City of Tallahassee, like the vast majority of other cities, has made a promise to employees that upon their retirement, the City will pay (contribute to) a portion of their healthcare costs. As a result, citizens at the time received employee services for which they did not help to fund. This unfunded actuarial accrued liability now conservatively amounts to in excess of $70 million dollars. As a result, current and future taxpayers will be burdened with previous cost incurred for which they will receive no service.
- As an example, if a special risk employee (police, fire, etc.) were to retire today at age 50 and select two-party healthcare coverage, over the next 35 years the cash flow for the City contribution toward the employee's healthcare would amount to approximately $125,000. For an employee not in a special risk category retiring at age 62 and eligible for Medicare coverage at age 65, the City contribution over a 20-year period would amount to over $35,000. To date, the City, like most other state and local governments, has not set aside any monies to pay for this promised healthcare contribution.
- Not funding the City portion of post retirement healthcare cost is inconsistent with the matching concept of interperiod equity - that concept is that services provided during the period should be paid for by those that received and benefited from the services during the period. Under the new standard, OPEB cost not recognized in the past shall be recognized going forward in the period in which the employee provides services.
The GFOA has said that the real issue is not the accounting requirements for OPEB, but how governments intend to finance the cost of OPEB in an environment characterized by an increasing retirement age population and escalating healthcare cost.
To address this important issue, the City has an Employee Benefits Committee made up of the City Treasurer-Clerk, the Director of Management and Administration, and the Director of Human Resources. One of the responsibilities of this Committee is to review healthcare premiums for active and retired employees. Based on their review, the Committee recommends to the City Commission, through the budget process, the portion of the premium to be paid by the City.
For the 2009 fiscal year, the proposed budget addresses OPEB by fully budgeting the enterprise fund commitment to OPEB but not fully budgeting the general fund commitment. Since neither of these commitments will go into an irrevocable trust, the City will be required to record the full amount of the OPEB liability for 2009. Regardless, there appears to be a commitment by the Committee to recommend an irrevocable trust and a commitment to address OPEB in the future.
To address this important issue, the following recommendations are made:
- If the City Commission chooses to continue to contribute to retiree healthcare, the Benefits Committee should develop a plan and funding strategy for the 2010 budget cycle and at least the following five years for Commission deliberation and direction.
- Current union agreements and current policies or practices for nonunion employees should be reviewed to determine the City's legal requirement to continue to subsidize or authority to change the City OPEB contribution.
- If City contributions are expected to continue, strong consideration should be given to the merits of a separate irrevocable trust to account for amounts received and expended.
- The Committee has indicated that a plan will be finalized for the 2010 budget to address OPEB through a cost sharing mechanism between employees and the City. The Committee should give recognition that the unfunded actuarial accrued liability that currently exists represents an exchange of benefits for services that have already been provided by employees. The Committee should seek equity in its efforts to fund OPEB through employee cost sharing.
- The Benefits Committee should look at all options and recommend to the City Commission the best short and long term course of action in light of the financial sustainability needs of the government; services promised to the community; and the desire to have a dedicated, competent, and professional workforce.
Research conducted for this report identified several options for funding and structuring a plan to address the impact of OPEB. Some of the options relate to what other state and local governments have already done to address OPEB and some options are those that deserve further consideration if it is necessary to change plan benefits. These options were discussed with and provided to the Benefits Committee for their review and consideration, and for their recommendations, as applicable, to the City Commission.
There should be recognition that the contribution the City currently makes to retiree healthcare was likely made in previous years in good faith and in recognition of valuable contributions made by employees in exchange for (or for foregone) salary increases. Any reduction in contributions by the City has the effect of reducing current and retiree salary and pensions, respectively. GFOA recommends that governments strive to avoid benefit reductions that place an undue burden on employees, or risk making the government uncompetitive as an employer.
In view of the significance of decisions to be made, the City Commission (through its Financial Viability of the Government Target Issue Committee) should give consideration to recommendations made by the Benefits Committee and the Office of the City Attorney.
Inquiry into Misuse of City "Sam's Club Card" (PRNA) (#0820)
The purpose of this report is to communicate the results of our inquiry into misuse of a City Sam's Club card by an employee of the Parks, Recreation, and Neighborhood Affairs Department (Department).
This inquiry was conducted at the request of City management after Department management determined that an employee (Wayne Funderburke) had inappropriately used a City Sam's Club card for personal benefit. The results of our inquiry showed that the employee inappropriately made 89 personal purchases totaling $5,213 during the period July 28, 2006 through July 21, 2008. Of those 89 personal purchases, 78 were for gasoline (totaling $4,221) and 11 were for other items (totaling $992). Those other items included, for example, a car battery, soft drinks, groceries, toiletries, light bulbs, shirts, and a ladder. Our analysis shows that the majority, if not all, of those purchases were charged to the City's account. We found that the City did not pay for any of those inappropriate purchases. However, the employee had not paid for a significant portion of those purchases as of the date of his resignation, July 21, 2008. As of that date, the balance owed Sam's Club on the City's account for his personal purchases totaled $2,981. In addition, whether intentional or not, some state sales taxes (i.e., $29) were not paid on those personal purchases.
Upon determination of the amount still owed on the City's account, the City paid Sam's Club the $2,981 balance on September 8, 2008 and closed the account. To obtain reimbursement from Mr. Funderburke, the City will withhold an equal amount from the funds owed Mr. Funderburke for his unused leave balances. Payment to Mr. Funderburke for the balance of any unused leave will not be made until completion of this inquiry and a determination by management that such payment is warranted.
This misuse was not initially detected by the Department because the periodic account statements were not sent to and reviewed by a person other than the employee who inappropriately charged his personal purchases to that City account.
At the request of management, we also reviewed other functions performed by the applicable employee to ascertain if any City resources (e.g., cash and revenue collections and purchased items) relating to those functions were missing or otherwise unaccounted for within the City's records. Our review of those other areas did not disclose additional instances of misuse that could be attributable to the applicable employee. However, issues were identified for which enhancements are needed to assist the Department in accurately and completely accounting for fees and activities.
We have made recommendations within this report to address all identified issues, including those pertaining to the misuses of the Sam's Club account and the other functions performed by the applicable employee.
- View Full 0820 Inquiry (PDF)




