can you solve this question please with proper reason

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 spo. NER's 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 NER'S 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 company's 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 II). 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. Exhibiti Controller's 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 company's 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 company's reservation system (which is housed on NER's 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 help personalize customer service and to minimize transaction times for returning guests. This Information is stored on NER's only server, which is located at NER's 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 recelving 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 8., revenues, expenses, inventory, etc.). Data is processed, stored, and communicated using TS's system. Data is transferred to TS's 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 xhibit 11 Controller's 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). Bili and Betty Gettysburg privately own this hotel property. Theirasking 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 5875 per night. During the off peak season the hotet 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 11 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 590,000. The Gettysburg's were surprised to receive an additional $500,000 nayment vom Muscle to thank them for their successfulelforsan keeping the wedding det private Nil of the amounts received for the wedding are included eservation revenue on the income statement Golf Tournament . . Huntsville Heights hosted a high profile, national tournament for golfers in May 2019 and the fee received by Huntsville Heights for hosting this toumament 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 parcet of tand is undeveloped. The undeveloped land, which is tocated 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 annuat 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 111 Huntsville Heights Beach and Golf Resort Inc. Excerpts from the Balance Sheet As at December 31 (in thousands of dollars) 2019 2018 (unaudited) unaudited) Assets Cash Accounts receivable Inventory Prepaid expenses $ 453 142 220 12 877 $ 162 130 140 3 435 Property, plant and equipment (net) Investments 15465 16,657 1,000 17,657 $18.534 15465 $15.900 Liabilities Bank operating loan Accounts payable and accrued abilities 590 225 315 $ 100 166 266 Long term debt 160 475 200 466 Shareholders' Equity Common shares Retained earnings 100 100 17,959 12059 $18.534 15.434 $15.900 Huntsville Heights Beach and Golf Resort Inc. Excerpts From the Income Statement For the years ended December 31 tin thousands of dollars) naudited 2018 (unaidited $16.710 514.300 Revenues Reservations Golffres and proshop investment income Totalten 35 22195 Lenses Dotel operations including amortization Golf course grations, indarortato 10120 2870 Sito Wages and salaries Total expenses 7,200 18,865 6,675 16,355 3,930 2,430 Income before income tax 1,305 780 Income tax $2,625 $1,650 Net income 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 spo. NER's 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 NER'S 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 company's 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 II). 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. Exhibiti Controller's 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 company's 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 company's reservation system (which is housed on NER's 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 help personalize customer service and to minimize transaction times for returning guests. This Information is stored on NER's only server, which is located at NER's 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 recelving 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 8., revenues, expenses, inventory, etc.). Data is processed, stored, and communicated using TS's system. Data is transferred to TS's 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 xhibit 11 Controller's 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). Bili and Betty Gettysburg privately own this hotel property. Theirasking 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 5875 per night. During the off peak season the hotet 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 11 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 590,000. The Gettysburg's were surprised to receive an additional $500,000 nayment vom Muscle to thank them for their successfulelforsan keeping the wedding det private Nil of the amounts received for the wedding are included eservation revenue on the income statement Golf Tournament . . Huntsville Heights hosted a high profile, national tournament for golfers in May 2019 and the fee received by Huntsville Heights for hosting this toumament 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 parcet of tand is undeveloped. The undeveloped land, which is tocated 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 annuat 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 111 Huntsville Heights Beach and Golf Resort Inc. Excerpts from the Balance Sheet As at December 31 (in thousands of dollars) 2019 2018 (unaudited) unaudited) Assets Cash Accounts receivable Inventory Prepaid expenses $ 453 142 220 12 877 $ 162 130 140 3 435 Property, plant and equipment (net) Investments 15465 16,657 1,000 17,657 $18.534 15465 $15.900 Liabilities Bank operating loan Accounts payable and accrued abilities 590 225 315 $ 100 166 266 Long term debt 160 475 200 466 Shareholders' Equity Common shares Retained earnings 100 100 17,959 12059 $18.534 15.434 $15.900 Huntsville Heights Beach and Golf Resort Inc. Excerpts From the Income Statement For the years ended December 31 tin thousands of dollars) naudited 2018 (unaidited $16.710 514.300 Revenues Reservations Golffres and proshop investment income Totalten 35 22195 Lenses Dotel operations including amortization Golf course grations, indarortato 10120 2870 Sito Wages and salaries Total expenses 7,200 18,865 6,675 16,355 3,930 2,430 Income before income tax 1,305 780 Income tax $2,625 $1,650 Net income