Unit 8 Integration Case Information Northern Escape Resorts (NER) is a private corporation that owns three luxury boutique hotels that are located in Niagara-on-the-Lake, Toronto, and Ottawa. The largest hotel, The Skyline Inn and Spa, is located in an upscale area of Toronto and has 200 guest rooms, a high-end restaurant, and features a full service luxury spa. NERs other hotels, The Capital in Ottawa, and The Vineyard in Niagara-on-the-Lake, both have 75 guest rooms, an on-site restaurant and an indoor pool and exercise facilities. None of the hotels have a golf course. It is now June 20, 2020. You, CA, are the assistant to Melissa Connell, who is the corporate controller of NER. This week, Melissa asks you to help her to prepare for the upcoming Board of Directors (the Board) meeting. The Board meets on a quarterly basis to review the performance of NER. For each Board meeting the accounting department prepares NERs quarterly statement of net income. Melissa is present at the Board meetings for the discussion of financial issues. The Board is not provided with any other documentation or financial information. Melissa informs you that the Board will be discussing the potential outsourcing of the companys information processing system at the upcoming meeting and she wants you to prepare a memo that describes the concerns with the current system and an assessment of the proposed outsourced system. She provides you with her notes on the current and proposed outsourced systems (Exhibit I). Another topic for discussion at this meeting is the potential acquisition of a hotel, Huntsville Heights Inc. (Huntsville Heights). Melissa provides you with her notes pertaining to this potential acquisition (Exhibit II) and excerpts from the financial statements of Huntsville Heights (Exhibit III). She asks you to use this information and prepare an analysis of this potential acquisition. Melissa also wants to improve the financial information that is provided to the Board and has asked you to provide suggestions for her consideration. Required: Prepare the memo to Melissa Connell responding to her requests. Exhibit I Controllers Notes Pertaining To The Hghtech And Outsourced Systems HghTech: The Current System NER is currently using HghTech, a formerly popular management information system. Users now find the system capabilities to be limited and the transaction processing to be slow. Bobby Gilbate, the companys former information system manager, retired in January 2020 after 10 years with NER. Instead of replacing him, NER management allocated his duties to existing NER staff. Melissa is responsible for the general ledger and accounting modules. Melissa has the expertise needed to be able to back up the system, to perform required upgrades, and to correct program coding and perform these functions when necessary. Five years ago, NER introduced an online booking system whereby potential hotel guests can access the companys reservation system (which is housed on NERs server), determine room availability and make reservations for their stay. NER stores personal information about its clients, including addresses, telephone numbers, e- mail addresses, credit card information, and travel preferences. This information is used to WWW.YORKVILLEU.CA BUSI 3443: Accounting Capstone Project: Auditing 7 WWW.YORKVILLEU.CA help personalize customer service and to minimize transaction times for returning guests. This information is stored on NERs only server, which is located at NERs head office in Toronto, and is accessible by all users of the system. Each month NER purchases a large quantity of supplies for its hotels. Suppliers invoices are directed to the accounts payable department and two of the three accounts payable employees are authorized to pay these invoices. Cheques are issued to suppliers on a weekly basis. In recent months, NER has received an increasing number of complaints from suppliers about receiving incorrect payments and unpaid invoices. Travel Systems: The Proposed Outsourced System Travel Systems (TS) is a well-known information service provider located in San Jose, California, and has worked with many prominent hotel chains in the United States. TS offers a complete information system outsourcing package to its clients. Clients use the system to record all transactions (e.g., revenues, expenses, inventory, etc.). Data is processed, stored, and communicated using TSs system. Data is transferred to TSs servers using a dedicated secure line. TS offers a number of different (daily, weekly, monthly) reporting packages and, if requested to do so, TS will report on key hotel performance indicators such as occupancy rates, average length of stay, room cancellation statistics, and future reservation information. Exhibit II Controllers Notes Pertaining to the Potential Acquisition of the Huntsville Heights Hotel Background Information NER is interested in purchasing a hotel property located in Muskoka, Ontario, Huntsville Heights Beach and Golf Resort Inc. (Huntsville Heights). Bill and Betty Gettysburg privately own this hotel property. Their asking price is $14 million for all of the shares of Huntsville Heights. Huntsville Heights is an extremely popular destination for Canadian and international travelers. The hotel is usually fully booked from June through October. Guests usually make reservations months in advance of their stay. During the peak season for 2019, the average room was $175 per night. During the off-peak season, the hotel is not usually fully booked. However, for the month of April 2019 the hotel was fully booked because of special events which resulted in $50,000 more revenue than normally earned. Muscle Wedding In June 2019, Huntsville Heights hosted the wedding and wedding reception of the daughter of a well-known actor, Martin Muscle. Muscle booked every room in the hotel for three nights which provided Huntsville Heights with revenue of $210,000. Muscle also paid a $200,000 fee to have the hotel close its golf course and hotel facilities to the public for the three day period which extended over a weekend. The golf course and pro shop would otherwise have generated revenue in the amount of $90,000. The Gettysburgs were surprised to receive an additional $500,000 payment from Muscle to thank them for their successful efforts in keeping the wedding details private. All of the amounts received for this wedding are included in reservation revenue on the income statement. Golf Tournament BUSI 3443: Accounting Capstone Project: Auditing 8 Huntsville Heights hosted a high profile, national tournament for golfers in May 2019 and the fee received by Huntsville Heights for hosting this tournament was $750,000. Huntsville Heights had to close the golf course to the public for seven days which resulted in lost revenue of $170,000. Each year, the tournament organizers seek out a different site to host the tournament. Several elite Canadian golf courses have hosted this tournament. To facilitate player and supporter accommodations, the golf courses for this tournament are usually affiliated with a large resort hotel, such as Huntsville Heights. With its 400 guest rooms and its quality golf course, Huntsville Heights met the requirements of the tournament organizers. The fee is included in golf fees and pro shop revenue on the income statement. Personal Expenses The Gettysburgs use Huntsville Heights to pay their personal expenses rather than taking a salary. During fiscal 2019, personal expenses paid by Huntsville Heights include: The purchase of a new sports car for Betty that cost $100,000, Travel costs in the amount of $225,000 to various exclusive resorts in Hawaii, Tahiti and South Africa during the winter months of 2019. Bill claims that is the best way to research new trends in the industry, and An additional $420,000 in other personal expenses. These expenditures are included in hotel operating costs on the income statement. As the Gettysburgs use the funds freely for personal use, they do not pay themselves a regular salary. Land and Investments Huntsville Heights purchased 300 acres of land at a cost of $1,000,000. Huntsville Heights was built on 200 acres of this land. The separate 100 acre parcel of land is undeveloped. The undeveloped land, which is located 40 kilometers from Huntsville Heights is estimated to be presently worth $3,000,000. The special payment of $500,000 received by Huntsville Heights from Martin Muscle along with $500,000 of additional funds was invested in July 2019 in interest-bearing and equity investments. These investments have earned $25,000 in interest and dividends which are included in investment revenue on the income statement. The market values of the investments are unchanged from their costs as at December 31, 2019. Valuation As the 2019 annual net income is likely to be representative of future earnings, and the resort is not a capital-intensive business, NER would like to value the company using a capitalized earnings approach. Melissa recently read in a trade journal that similar property investments yield a 20% return. She does not see any reason why this investment in Huntsville Heights would be any different. Exhibit III BUSI 3443: Accounting Capstone Project: Auditing 9 Huntsville Heights Beach and Golf Resort Inc. Excerpts From the Balance Sheet As at December 31 WWW.YORKVILLEU.CA Assets Cash Accounts receivable Inventory Prepaid expenses Property, plant and equipment (net) Investments Liabilities Bank operating loan Accounts payable and accrued liabilities $ 453 142 270 12 877 16,657 1,000 17,657 $18,534 $ 90 225 315 160 475 100 17,959 18,059 $18,534 $ 162 130 140 3 435 15,465 - 15,465 $15,900 $ 100 166 266 200 466 100 15,334 15,434 $15,900 (in thousands of dollars) WWW.YORKVILLEU.CA 2019 (unaudited) 2018 (unaudited) Long-term debt Shareholders Equity Common shares Retained earnings Revenues Huntsville Heights Beach and Golf Resort Inc. Excerpts From the Income Statement For the years ended December 31 (in thousands of dollars) 2019 (unaudited) 2018 (unaudited) Reservations $16,710 $14,300 4,485 - 18,785 8,870 810 Golf fees and pro shop Investment income Total revenue Expenses Hotel operations, including amortization Golf course operations, including amortization 6,060 25 22,795 10,670 995 BUSI 3443: Accounting Capstone Project: Auditing 10 WWW.YORKVILLEU.CA Wages and salaries Total expenses Income before income tax Income tax Net income 7,200 18,865 3,930 1,305 $2,625 6,675 16,355 2,430 780 $1,650