Dollar Rent-A-Car
INTERNAL AUDIT REPORT LIMITED CONTRACT COMPLIANCE CMC INVESTMENTS, INC. DBA DOLLAR RENT-A-CAR JUNE 2014 – MAY 2017 ISSUE DATE: MAY 30, 2018 REPORT NO. 2018-04 CMC Investments, Inc. INTERNAL AUDIT d/b/a Dollar Rent A Car June 01, 2014 – May 31, 2017 TABLE OF CONTENTS EXECUTIVE SUMMARY .......................................................................................................................................... 3 BACKGROUND ....................................................................................................................................................... 4 AUDIT SCOPE AND METHODOLOGY ...................................................................................................................... 5 SCHEDULE OF FINDINGS AND RECOMMENDATIONS .......................................................................................... 6 APPENDIX A: RISK RATINGS.................................................................................................................................. 8 2 CMC Investments, Inc. INTERNAL AUDIT d/b/a Dollar Rent A Car June 01, 2014 – May 31, 2017 EXECUTIVE SUMMARY Internal Audit (IA) completed a rental car concession agreement audit of CMC Investments, Inc. d/b/a Dollar Rent A Car, Inc. (Concessionaire), for the period June 1, 2014 through May 31, 2017. The audit objective was to determine whether the Concessionaire complied with significant financial provisions of the concession agreement, including whether reported gross revenues and the Customer Facility Charges (CFC) paid to the Port were complete and reasonable. We concluded that the Percentage Fees paid to the Port materially complied with the terms of the Rental Car Lease and Concession Agreement. However, we determined that the Concessionaire underreported certain gross revenue items and over-reported the CFC: 1) The Concessionaire did not report $343,326 in incidental gross revenues to the Port, resulting in $34,333 in Percentage Fees owed to the Port. 2) The CFC was over-reported to the Port, by $19,596 for the audit period. This was primarily due to a mistake by Concessionaire in November 2015, which resulted in an overpayment of that month’s CFC to the Port. These two items resulted in an underpayment to the Port of approximately $14,737 for the three-year period ended May 31, 2017. Th ese issues are discussed in more detail beginning on page six of this report. We extend our appreciation to management and staff of the Aviation Commercial Management Department, the Concessionaire, and the Accounting and Financial Reporting Department for their assistance and cooperation during the audit. Glenn Fernandes, CPA Director, Internal Audit RESPONSIBLE MANAGEMENT TEAM Lance Lyttle, Managing Director Aviation Jim Schone, Director AV Commercial Management James Jennings, Sr. Manager, AV Properties Group 3 CMC Investments, Inc. INTERNAL AUDIT d/b/a Dollar Rent A Car June 01, 2014 – May 31, 2017 BACKGROUND CMC Investments, Inc. is a private company categorized under Automobile Renting and Leasing, in Mercer Island, WA. The company was established in 1987, and operates under the name Dollar-Rent-A Car at Seattle Tacoma International Airport and Portland International Airport. The terms of the agreement provide for a Minimum Annual Guarantee (MAG) of the higher of: (1) 85% of the total amount paid to the Port in the previous agreement year, or (2) the Initial MAG bid by the Concessionaire of $1,333,399. Additionally, the agreement requires a Percentage Fee equal to 10% of Concessionaire’s gross revenues, provided the fee is higher than the monthly MAG. The MAG is payable in advance, on or before the first day of each month, without notice from the Port. The Percentage Fee, if applicable, is due on or before the 20th of the following month. The agreement states that the Concessionaire must collect a Customer Facility Charge (CFC) of $6 per rental day. The table below reflects total gross revenue, concession fees, and CFC fees: REPORTED GROSS REVENUE AND CONCESSION CALCULATION CUSTOMER FACILITY CHARGE AGREEMENT REPORTED GROSS CONCESSION FEES REPORTED CFC FEES YEAR REVENUES 2014 - 2015 $16,093,271 $1,609,327 $1,943,754 2015 - 2016 16,071,679 1,607,168 2,042,244 2016 - 2017 16,555,626 1,655,563 2,207,856 TOTAL $48,720,576 $4,872,058 $6,193,854 Data Source: PeopleSoft Financials and Propworks 4 CMC Investments, Inc. INTERNAL AUDIT d/b/a Dollar Rent A Car June 01, 2014 – May 31, 2017 AUDIT SCOPE AND METHODOLOGY We conducted this audit in accordance with Generally Accepted Government Auditing Standards and the International Standards for the Professional Practice of Internal Auditing. Those standards require that we plan and perform the audit to obtain sufficient, appropriate evidence to provide a reasonable basis for our findings and conclusions based on our audit objectives. We believe that the evidence obtained provides a reasonable basis for our findings and conclusions based on our audit objectives. The period audited was June 1, 2014 – May 31, 2017. After identifying significant provisions in the Agreement, we performed the following audit procedures: Insurance & Security Deposit • Identified the insurance requirements in the agreement. • Verified the insurance certificates, as required in the agreement, were provided to the Port for the audit period. • Tested three years of insurance coverage and endorsements as required. • Identified the Security requirement in the agreement. • Verified and tested three years of Security amounts as required Customer Facility Charge (CFC) • Calculated a number of transaction (i.e., rental) days and CFC from the Concessionaire’s system reports. • Reconciled the reported amount to those certified by Concessionaire’s Controller. • Reconciled the calculated numbers to what the Concessionaire reported for the audit period. • Tested a risk-based sample of 113 closed rental agreements to determine whether the CFC calculation was based on the correct checkout and return date, and was accurate. Revenue completeness and reasonableness • Reviewed the Concessionaire’s chart of accounts, to determine whether unusual revenue accounts were included in the determination of Gross Revenue reported to the Port. • Reconciled the reported revenues to: o The Daily Business Report (DBR) GL by revenue item. Additionally, the revenue items were reviewed to determine whether all items subject to the Percentage Fee were included in the reported Gross Revenue. o The Certified Audit Statement of Gross Revenues, independently verified by a CPA. • Tested a risk-based sample of 16 closed rental agreements in the audit period to determine whether: o All revenue items on the face of the rental agreement agreed to the amount posted to the DBR. o Disallowed commercial discounts/rebates reduced reported Gross Revenues. • Analyzed Port records to determine whether payments were received in a timely manner and were complete. 5 CMC Investments, Inc. INTERNAL AUDIT d/b/a Dollar Rent A Car June 01, 2014 – May 31, 2017 SCHEDULE OF FINDINGS AND RECOMMENDATIONS 1) RATING: MEDIUM The Concessionaire did not report $343,326 in incidental Gross Revenues to the Port, resulting in $34,333 in Percentage Fees owed to the Port. This is a repeat finding from a previous audit, which the Concessionaire acknowledges and has agreed to incorporate into their monthly gross revenue reporting to the Port. The amounts cited in the table below summarize the underreported gross revenues. Year-Ended Reported Gross Audited Under May 31 Revenue Gross Revenue Reported 2015 16,093,271 16,196,832 $ 103,561 2016 16,071,679 16,184,932 113,253 2017 16,555,626 16,682,138 126,512 Concession Revenue Underreported 343,326 Concession Fees Underpaid $34,333 Data Source: CMC Investments’ DBR records, PROPworks & PeopleSoft Financials Our analysis of the Concessionaire’s financial records and ensuing detail transaction testing, determined that Gross Revenues from the following account line items were not reported to the Port: • Admin. Fees • Lost/Found Handling Fees • Pickup Fees • Cleaning Fees • Roadside Services Fees • Lost Key Charges Recommendations: 1. Seek and recover approximately $34,333 in underpaid Percentage Fees. 2. Assess the applicability of the one-time late charge and any accrued interest. 3. Communicate with the Concessionaire to assure Gross Revenues are accurately reported and that the associated Percentage Fees are collected. Management Response/Action Plan Aviation Commercial Management will seek to recover the underpaid Percentage Fees, together with any applicable late fees and interest charges. Aviation Commercial Management will also communicate both verbally and in writing that the revenues identified above, are not permitted exclusions from revenue according to the Agreement. Therefore, effectively immediately, those revenue items are required to be included in their monthly reports of gross revenues provided to the Port. Lastly, Aviation Commercial Management will advise Accounting and Financial Reporting that the Minimum Annual Guarantee under the Lease for the 2017-2018 Agreement Year should be increased to $1,417,981.73 to account for these under-reported Gross Revenues in the 2016-2017 Agreement Year. DUE DATE: 9/30/2018 6 CMC Investments, Inc. INTERNAL AUDIT d/b/a Dollar Rent A Car June 01, 2014 – May 31, 2017 2) RATING: MEDIUM The CFC was over-reported to the Port, by approximately $19,596 for the audit period. This was primarily due to a mistake by the Concessionaire in November 2015, which resulted in an overpayment of that month’s CFC to the Port. When we reviewed monthly transaction totals against CFC payment history, we also determined that the Concessionaire inconsistently collected the CFC from customers in other months. The lease agreement under Section 6.2.1 stipulates: “Concessionaire shall collect a daily CFC on all vehicle rental transactions originating at the Consolidated Rental Car Facility… Each Concessionaire must collect the CFC at the time of the first payment is made under a Rental Car Contract, and must remit the full amount of the CFC to the Port regardless of whether or not the full amount of such CFC is actually collected by the Concessionaire from the person who rented the Automobile under such Rental Car Contract.” The Concessionaire acknowledged the amounts cited in the table below, which summarizes the overreported CFC. Additionally, the Concessionaire developed enhancements to their internal controls to prevent their sales representatives from modifying the CFC. Year-Ended Under Audited CFC Reported CFC May 31 Reported 2015 $1,944,336 $1,943,754 $ 582 2016 2,020,482 2,042,244 (21,762) 2017 2,209,440 2,207,856 1,584 Total Due to the Concessionaire. $ (19,596) Data Source: CMC Investments’ Rental Agreement report & PeopleSoft Financials Recommendations 1. Refund the Concessionaire $19,596 for the CFC overpayment. Management Response/Action Plan Aviation Commercial Management will refund the overpaid CFC’s. DUE DATE: 9/30/2018 7 CMC Investments, Inc. INTERNAL AUDIT d/b/a Dollar Rent A Car June 01, 2014 – May 31, 2017 APPENDIX A: RISK RATINGS Findings identified during the course of the audit are assigned a risk rating, as outlined in the table below. The risk rating is based on the financial, operational, compliance or reputational impact the issue identified has on the Port. Items deemed “Low Risk” will be considered “Exit Items” and will not be brought to the final report. Port Rating Financial Internal Controls Compliance Public Commission/ Management Large financial High Noncompliance impact probability for Important Missing, or with applicable external audit inadequate key Federal, State, and HIGH Remiss in issues and/or Requires internal controls Local Laws, or Port responsibilities of negative immediate Policies being a custodian public attention of public trust perception Partial controls Potential for Relatively Inconsistent external audit important Not adequate to compliance with Moderate issues and/or MEDIUM identify Federal, State, and financial impact negative May or may not noncompliance or Local Laws, or Port public require immediate misappropriation Policies perception attention timely Internal controls in Low place but not probability for Generally complies consistently efficient external audit Lower significance with Federal, State Low financial or effective issues and/or LOW/ and Local Laws or impact negative May not require Exit Items Port Policies, but Implementing/enhan public immediate some minor cing controls could perception attention discrepancies exist prevent future problems 8
Limitations of Translatable Documents
PDF files are created with text and images are placed at an exact position on a page of a fixed size.
Web pages are fluid in nature, and the exact positioning of PDF text creates presentation problems.
PDFs that are full page graphics, or scanned pages are generally unable to be made accessible, In these cases, viewing whatever plain text could be extracted is the only alternative.