Your professor is going on vacation. He has narrowed down a list of potential hotels, but he is still overwhelmed by the data. He loves great food and wants to do all the activities at the resort.

1. Develop two unique ways to display the data (two unique types of charts) to show him where he should stay.

2. Recommend the best way to present the data. Write a narrative summary of what hotel you recommend based on the data visualization and the tradeoffs that you observe.

The Attached report shows the performance of Hotel XYZ for 2014 and 2015. Hotel XYZ is a luxury resort with a mix of 85% Transient and 15% Group.

After looking at this report, please answer the following questions:

• What was the Total YOY( year over year) growth? Was the growth driven by Room nights? ADR? both?
• Which segment drove this growth or decline? Transient or group?
• Which sub-segment within Transient and Group drove the growth or decline? Please explain both.
• Hotel XYZ overall strategy for next year is to grow rate without significantly increasing room nights. Based on the performance of 2015 and 2014, how will you shift your segmentation in order to achieve this?

ERF Enterprises provides comprehensive AV services to institutions in the State of Colorado. Their customers fall into 3 categories - Hospitals, Schools and Hotels

ERF's Executive Vice President of Operations, Jennifer Murray, has noted that the Hotel business, while profitable, seems to take a lot of ERF's support resources

Ms. Murray has asked for your support in getting a better picture of the profitability of each of the 3 lines of business

She provides the following data on the support activities of ERF for a 12-month period

The average support-resource consumption by category is provided below:

Excluding the cost of support, the average profitability of each category is given below:

Q1. Provide Ms. Murray with a an activity-based analysis of the profitability of each category of customer

Q2. After reviewing the data and analyses, what advice may be given to service personnel to improve profitability of the category with the lowest profit (after support cost)?

Is there some unusual explanation for high activity levels which could be further investigated? What creative questions could be asked?          

Religious Rowan worked for many years for a hotel restaurant as a waitstaff person. The restaurant had a family-style menu and was closed on Sundays. The restaurant was owned and operated by the hotel and primarily served a family oriented clientele. The restaurant was acquired by a national chain that changed the dynamic of the restaurant, making it into a bar and pub that was open 7 days per week.

Religious Rowan is a devout conservative churchgoer and does not believe in working on Sundays, because that is a time for church, nor does Rowan believe in the consumption of alcohol. Rowan told the new employers that due to religious beliefs, working any Sunday shifts and/or taking orders and serving alcohol to clients would be impossible.

The employer agreed that Rowan could always have Sundays off but insisted that Rowan get certified by the state to be able to sell alcohol as that was a new requirement of the waitstaff position. Rowan refused, and because there were always several other waitstaff personnel available that could take and serve alcohol orders, the restaurant said that was fine, because Rowan was otherwise an excellent employee.

Rowan was able to serve for 3.5 years in the same role with the accommodations of not working on Sundays or being involved in selling or serving alcohol without a problem. However, a new restaurant manager came in and determined that in order for the restaurant to improve its efficiency of operations, which was a goal the new manager was hired to implement, Rowan could still skip Sunday shifts but could no longer be accommodated by not participating in the sale of alcohol to customers as that pulled other waitstaff off of their assigned tables and was not perfectly efficient. Rowan refused to get licensed to sell alcohol or to serve it and was subsequently fired for insubordination. Rowan then sued for the failure of the hotel to accommodate her religious beliefs. How should the court rule and why?

Prepare Governmental Activities Journal:

Riverside began work on an outdoor amphitheater and concession stand at the city's park. It is to be financed by a $3,500,000 bond issue and supplemented by a $500,000 General Fund transfer. The following transactions occurred in 2017:

1. The General Fund transferred $500,000 to the Park Building Capital Projects Fund.

2. A contract was signed with Restin Construction Company for the major part of the project on a bid of $2,700,000.

3. Preliminary planning and engineering costs of $69,000 were vouchered for the Great Pacific Engineering Company. (This cost had not been encumbered.)

4. A payable was recorded for an $18,500 billing from the Water and Sewer enterprise fund for the cost of extending water pipes to the new concession stand.

5. An invoice in the amount of $1,000,000 was received from Restin for progress to date on the project.

6. The $3,500,000 bonds were issued at par.

7. The amount billed by the contractor (see Transaction 5) less 5 percent retainage was paid.

8. Temporary investments were purchased at a cost of $1,800,000.

Royal Park Ltd is an existing company that has issued previously 300,000 ordinary shares of $8 each and 100,000 5% preference shares of $15 each.

On 1^st January 2019, Royal Park Ltd offered to issue an additional 250,000 ordinary shares for $11, payable in two installments:

• $7 initially on application;
• $4 payable based on calls as required.

Applications for 400,000 shares were received by the closing date of 30^th January 2019.

On 10^th February 2019, shares were allotted, and a refund was made to unsuccessful applicants.

Directors announced on 30^th June 2019 a profit after tax of $900,000.

On 7^th July 2019, the board of directors during the Annual General Meeting announced that the company will pay preference dividends and ordinary dividends of 6.2 cents per fully paid equivalent share from retained earnings.

On 3^rd August 2019, payment was made for dividends declared.

Required:

a) Prepare the general journal entries to record the information above.                   

Narrations are NOT required.

Record the following transactions in the journal of Capital Project Fund and
Governmental Activities. (You must prepare the journal form using Excel)

1. A capital projects fund issued $10,000,000, 5 percent bonds for $10,100,000 to finance the
construction of a little league baseball park. Premiums received are to be used to service the
debt issue.

2. The Parks and Recreation Special Revenue Fund transferred $300,000 for use in construction.

3. A construction contract was awarded in the amount of $10,200,000.

4. A bill was received from the contractor for $5,100,000

.
5. The contractor bill is paid, and 6% retain is withheld.

6. The park renovations were completed and the final bill of $5,100,000 was received. The
contractor bill and retained are approved for payment in full. Total construction expenditures
were allocated as follows: $960,000,000 to building, and the remainder to equipment.

7. The capital projects fund temporary accounts were closed, and the capital projects fund was
closed by transferring remaining funds to the debt service fund for use in debt repayment.

Please prepare Governmental Activities Journal, not General Fund.

Riverside began work on an outdoor amphitheater and concession stand at the city's park. It is to be financed by a $3,500,000 bond issue and supplemented by a $500,000 General Fund transfer. The following transactions occurred in 2017:

1. The General Fund transferred $500,000 to the Park Building Capital Projects Fund.

2. A contract was signed with Restin Construction Company for the major part of the project on a bid of $2,700,000.

3. Preliminary planning and engineering costs of $69,000 were vouchered for the Great Pacific Engineering Company. (This cost had not been encumbered.)

4. A payable was recorded for an $18,500 billing from the Water and Sewer enterprise fund for the cost of extending water pipes to the new concession stand.

5. An invoice in the amount of $1,000,000 was received from Restin for progress to date on the project.

6. The $3,500,000 bonds were issued at par.

7. The amount billed by the contractor (see Transaction 5) less 5 percent retainage was paid.

8. Temporary investments were purchased at a cost of $1,800,000.

Case 4

When Disney opened its $4.4 billion Euro Disneyland outside Paris, concerns over the park’s impact on French culture were expressed. To begin with, the French dedicate Sundays only to family outings. In addition, they are unaccustomed to snacking and eat promptly at 12:30, which creates bottlenecks at parks and restaurants. Disney learned that French employees objected to providing the friendly greetings and smiles expected of all amusement park workers. They then hired multilingual employees from all over Europe because Disney’s goal was to attract people from all countries of Europe. A complaint of European investors was that rigid U.S. management style did not take into account the values and customs of the people it intended to attract. For example, Europeans often bring their own lunches and do not spend money at the park’s gourmet restaurants and hotels. The park initially lost money after it opened in 1992. Discuss the course of action Disney could take to accommodate the values and customs of the people it hopes to attract.

2 pages