Assume you are an SMC Hotel Manager for and an Interview has been conducted for You

Answer the following questions in Brief

4. State and explain any three (3) significant errors you identified during the audit of SMC hotel?

5. Discuss any 2 situations in which the auditor can be sued or liable?

6. State and explain any 3 qualities of an auditor?

7. Explain how you used interviews and listening skills during your audit of SMC hotel?

Ada Hotel sells two room tpes: standard rooms and deluxe rooms. Average daily rate (ADR) and variable costs (VC) of the two room types are provided in the table below: (Hint: Treat two room types as two different products.)                      
                      
   ADR ($)   Variable Cost ($)              
Standard rooms    394.50   256.43              
Deluxe rooms   631.20   366.10              
                      
                      
The Mock Hotel's fixed costs for a month is = =       252480              
Sales mix (contribution of each room type to total room revenue) of the hotel is:                      
                      
Deluxe rooms   66%                  
Standard rooms    34%                  
                      
Required:                      
Using the information provided above, answer the following questions:                      
a. What is the break-even room nights (number) for the the hotel given the sales mix of the two room packages?                      
b. What must be the room revenue for the hotel to make a profit of $50,000 a month?                      
c. If the hotel is considering an advertisement campaign for its rooms with a cost $5,000, hom much in room revenue should be generated to cover this extra cost?                      

On average, 90 patrons arrive per hour at a hotel lobby (interarrival times are exponential) waiting to check in. At present there are five clerks, and patrons wait in a single line for the first available clerk. The average time for a clerk to service a patron is three minutes (exponentially distributed). Clerks earn $10 per hour, and the hotel assesses a waiting time cost of $20 for each hour that a patron waits in line. If needed, round your answers to the nearest cent. a. Compute the expected cost per hour of the current system. $ b. The hotel is considering replacing one clerk with an Automatic Clerk Machine (ACM). Management estimates that 20% of all patrons will use an ACM. An ACM takes an average of one minute to service a patron. It costs $48 per day (one day equals eight hours) to operate an ACM. Should the hotel install the ACM? Assume that all customers who are willing to use the ACM wait in a separate queue. The hotel replace the clerk with an ACM, as the total hourly cost would to $ .

3) A stock market analyst wants to determine if the recent Hotel C upgrade to 4 starts has changed the distribution of shares of the hotel market. The current market share for the existing 3 hotels is shown in table below. The analyst collects data from a random sample of 200 investors. The table below shows the observed investors’ share holdings (f_i ). When using this random sample the analyst needs to be 90% confident of test results. The hypothesis to be tested follows:

H₀ : P_a =0.25; P_b =0.45; P_c =0.30 ; market shares have remained same

H_a : P_a ≠0.25; P_b ≠0.45; P_c ≠0.30 ; market shares have changed

1. Compute the test statistic

B. Has the recent upgrade of Hotel C to 5 stars changed the hotel market composition? Why?

Question 2

Suppose there is enough room for a maximum of three (3) cars to park around a fire hydrant. The harm resulting to society rises as additional cars park around the fire hydrant. This is because as more cars park, it becomes more costly for firefighters to navigate their water hoses around the stationary vehicles. The total (not marginal) cost to society as a function of the number of parked cars around a fire hydrant is as follows:

a. If each driver’s gain from parking a car around the fire hydrant is constant at $20, how many cars should park around the fire hydrant from an economic perspective? (Hint: you need to find the marginal cost to society to answer this part.)

b. What is the maximum level of total surplus resulting from parking around the fire hydrant? How many cars should park around the fire hydrant from an economic perspective?

​(Replacement chains​) Destination Hotels currently owns an older hotel on the best beachfront property on Hilton Head​ Island, and it is considering either remodeling the hotel or tearing it down and building a new convention​ hotel, but because both hotels would occupy the same physical​ location, the company can only choose one project-that ​is, these are mutually exclusive projects. Both of these projects have the same initial outlay of $ 1,800,000. The first​ project, since it is a remodel of an existing​ hotel, has an expected life of 9 years and will provide free cash flows of $ 400,000 at the end of each year for all 9 years. In​ addition, this project can be repeated at the end of 9 years at the same cost and with the same set of future cash flows. The proposed new convention hotel has an expected life of 18 years and will produce cash flows of $ 280,000 per year. The required rate of return on both of these projects is 9 percent. Calculate the NPV using replacement chains to compare these two projects.

5. The United Nations Human Development Index (HDI) uses information about a country’s life expectancy at birth (health), expected years of schooling and mean years of schooling (education), and Gross National Income per capita (standard of living) to create a measure that ranges from 1 (very high) to 0 (very low). For 2017, the United States had a value of 0.924, compared to 0.926 for Canada and 0.922 for the United Kingdom – very similar values, although not the highest of all countries.

Suppose a developing country (such as Eritrea with a value of 0.440 or Haiti with a value of 0.498) asks for your advice on which country it should try to emulate in order to increase its level of development and economic growth. Which of the three countries above would you choose? Explain what additional information about each country would be important to making this assessment.

The United Nations Human Development Index (HDI) uses information about a country’s life expectancy at birth (health), expected years of schooling and mean years of schooling (education), and Gross National Income per capita (standard of living) to create a measure that ranges from 1 (very high) to 0 (very low). For 2017, the United States had a value of 0.924, compared to 0.926 for Canada and 0.922 for the United Kingdom – very similar values, although not the highest of all countries

Suppose a developing country (such as Eritrea with a value of 0.440 or Haiti with a value of 0.498) asks for your advice on which country it should try to emulate in order to increase its level of development and economic growth. Which of the three countries above would you choose? Explain what additional information about each country would be important to making this assessment.

This is t a relational database please write SQL queries to solve the listed questions.

The database is a variation of the “Movie Database” . There are several differences in it, so look it over carefully before writing your SQL queries

Notes:

• TheaterNum, MovieNum, and ActorNum are numeric primary key fields in their respective tables. Movie and actor names are not assumed to be unique unless specified otherwise in a question.
• In the THEATER table, Capacity is the number of seats in a theater.
• In the MOVIE table, Year is the year a movie was filmed.
• The ACTED IN table lists all of the actors who acted in a movie. The Star field can have the values Y (yes) or N (no). Assume there is only one star in each movie.

CITY

THEATER

MOVIE

SHOWINGS

DIRECTOR

PRODUCER

ACTOR

PREVIOUSJOB

ACTEDIN

NEWSPAPER

REVIEWER

REVIEW

Questions

Remember to follow all of the instructions listed on the first page.

1. Which theater(s) in Tennessee have the largest capacity?

2. How many reviews were written for each movie directed by John Carter that were filmed in the period 2014 to 2019

3. List the phone number of every theater in Tennessee. Order the results by theater number.

4. What was the total revenue generated by movies made in 2015 that were both directed by James Smith and produced by Mary Jones?

5. Assume there is only one movie titled, “The Matrix.” Who reviewed it?

6. List the cities in Tennessee that have theaters with capacities of at least 200 seats. List the cities in alphabetic order.

7. Which movies have generated more revenue than the movie directed by John Carter in 2010 that generated the most revenue of the movies he directed that year?

8. Which theaters in Tennessee, Arkansas, or Mississippi (you may use 2-letter abbreviations) showed movies whose titles began with any of the letters R, S, or T? List the theaters in numeric order.

9. Who is the oldest actor who starred in a movie made between 1995 and 2005 that was both directed by James Smith and produced by Mary Jones?

10. What was the total revenue generated by movies produced by each producer from 2010 to 2018 that starred an actor who is currently under 40 years of age? Only include producers whose movies generated more than a total of $75,000,000.