What processes would be involved in the initial set-up of the new hotel?

What are similarities. and differences. between running a club versus running a hotel?

October 1993 Marriott Corporation announced
plans to divide its operations into two separate
businesses (spin off of hotel mgt’ business)

– Marriott International: manage Marriott’s hotel chain and receive most of the revenue

– Host Marriott: own all the company’s real estate and be responsible for servicing essentially all of the old company’s $3 billion of debt

What will happen to Marriott’s stock price and
bond price after this announcement?

You are considering a hotel purchase. The current purchase price is $ 3,000,000. The bank is willing to finance 70% of the purchase price for 20 years in quarterly installments at 8% per annum mortgage nominal rate. What is the balloon payment you will have to pay, if you want to resell the hotel after 10 years? Consider a fully amortizing fixed rate mortgage.

a)      $ 0

b)      $ 1,445,395

c)       $ 1,669,270

d)      $ 1,981,333

At year-end (December 31), Chan Company estimates its bad debts as 0.40% of its annual credit sales of $879,000. Chan records its Bad Debts Expense for that estimate. On the following February 1, Chan decides that the $440 account of P. Park is uncollectible and writes it off as a bad debt. On June 5, Park unexpectedly pays the amount previously written off. Prepare the journal entries for these transactions.

The City of Pfeiffer starts the year of 2017 with the general fund and an enterprise fund. The general fund has two activities: education and parks/recreation. For convenience, assume that the general fund holds $144,000 cash and a new school building costing $1,180,000. The city utilizes straight-line depreciation. The building has a 20-year life and no salvage value. The enterprise fund has $65,000 cash and a new $360,000 civic auditorium with a 30-year life and no salvage value. The enterprise fund monitors just one activity, the rental of the civic auditorium for entertainment and other cultural affairs.

The following transactions for the city take place during 2017. Assume that the city’s fiscal year ends on December 31.

Decides to build a municipal park and transfers $72,000 into a capital projects fund and immediately expends $20,600 for a piece of land. The creation of this fund and this transfer were made by the highest level of government authority.

Borrows $113,400 cash on a long-term bond for use in creating the new municipal park.

Assesses property taxes on the first day of the year. The assessment, which is immediately enforceable, totals $618,600. Of this amount, $525,800 will be collected during 2017 and another $51,600 is expected in the first month of 2018. The remainder is expected about halfway through 2018.

Constructs a building in the park in (b) for $40,000 cash so that local citizens can play basketball and other sports. It is put into service on July 1 and should last 10 years with no salvage value.

Builds a sidewalk around the new park for $10,000 cash and puts it into service on July 1. It should last for 10 years, but the city plans to keep it up to a predetermined quality level so that it will last almost indefinitely.

Opens the park and charges an entrance fee of only a token amount so that it records the park, therefore, in the general fund. Collections during this first year total $4,000.

Buys a new parking deck for $220,000, paying $22,000 cash and signing a long-term note for the rest. The parking deck, which is to go into operation on July 1, is across the street from the civic auditorium and is considered part of that activity. It has a 20-year life and no salvage value.

Receives a $110,000 cash grant for the city school system that must be spent for school lunches for the poor. Appropriate spending of these funds is viewed as an eligibility requirement of this grant. During the current year, $40,700 of the amount received was properly spent.

Charges students in the school system a total fee of $6,600 for books and the like. Of this amount, 90 percent is collected during 2017 with the remainder expected to be collected in the first few weeks of 2018.

Buys school supplies for $23,000 cash and uses $17,800 of them. The general fund uses the purchases method.

Receives a painting by a local artist to be displayed in the local school. It qualifies as a work of art, and officials have chosen not to capitalize it. The painting has a value of $83,700. It is viewed as inexhaustible.

Transfers $20,600 cash from the general fund to the enterprise fund as a capital contribution.

Orders a school bus for $102,000.

Receives the school bus and pays an actual cost of $105,000. The bus is put into operation on October 1 and should last for five years with no salvage value.

Pays salaries of $247,000 to school teachers. In addition, owes and will pay $30,800 during the first two weeks of 2018. Vacations worth $23,600 have also been earned but will not be taken until July 2018.

Pays salaries of $43,000 to city auditorium workers. In addition, owes and will pay $3,500 in the first two weeks of 2018. Vacations worth $5,800 have also been earned but will not be taken until July 2018.

Charges customers $150,800 for the rental of the civic auditorium. Of this balance, collected $127,600 in cash and will collect the remainder in April 2018.

Pays $10,400 maintenance charges for the building and sidewalk in (d) and (e).

Pays $16,200 on the bond in (b) on the last day of 2017: $5,800 principal and $10,400 interest.

Accrues interest of $15,000 on the note in (g) as of the end of 2017, an amount that it will pay in June 2018.

Assumes that a museum that operates within the city is a component unit that will be discretely presented. The museum reports to city officials that it had $48,500 of direct expenses this past year and $57,700 in revenues from admission charges. The only assets that it had at year-end were cash of $27,700, building (net of depreciation) of $346,300, and a long-term liability of $242,400.

Prepare the 2017 government-wide financial statements for this city. Assume the use of the modified approach.

Prepare a statement of net position. (Amounts to be deducted should be indicatedby a minus sign.)

Beate Klingenberg manages a​ Poughkeepsie, New​ York, movie theater complex called Cinema 8. Each of the eight auditoriums plays a different​ film; the schedule staggers starting times to avoid the large crowds that would occur if all eight movies started at the same time. The theater has a single ticket booth and a cashier who can maintain an average service rate of

280 patrons per hour. Service times are assumed to follow a negative exponential distribution. Arrivals on a normally active day are Poisson distributed and average 200

per hour.

a) Find the average number of moviegoers waiting in line to purchase a ticket.
b) What percentage of the time is the cashier busy?
c) What is the average time that a customer spends in the system?
d) What is the average time spent waiting in line to get to the ticket window?
e) What is the probability that there are more than two people in the system? More than three people? More than four?

/*explain */ Select *

From Student join enrollment on student.ID = enrollment.Student_ID

            join section on section.ID = enrollment.section_ID

            join department on major = department.name

            join faculty on faculty.id = section.faculty_ID

            join address on address.id = student.address_ID

            join Course on section.course_Number = course.course_number and section.dept_id = course.dept_ID

Where

--we want to make sure we have name information for students if we want to reach out to them

Student.Name_Last Not Like ('')

-- the theater department has asked to be out of this study

and Student.Major <> 'Theater'

--no students who have failed as we're looking for passing grades

and Grade > '1.33'

--we want to make sure we only have instructors, and the theater department is not part of this study

and Faculty.job in

            (Select job

            From Faculty

            Where Job not in ('Administrative','General Services','Human Resources')

            and Dept <> 'THT')

and Section_ID >=1

--summer courses don't always reflect accurately given their tight schedule and rapid fire delivery of materials

and Semester <> 'Summer'

--we don't want bias of an adivosr giving better grades

and Student.Advisor_ID <> Section.Faculty_ID

-- we don't want bias if a student is possibly a faculty members child

and Student.Address_ID <> Faculty.Address_ID

Order by Student.Name_Last, Grade desc, Faculty.Name_Last, Major

1. Based on the output from the explain command, determine the steps you would take (building indexes on certain columns, modifying the query, both, etc.) to get the same output, but improve overall performance.
2. Execute three steps that you think would make for improvement in the performance of this query. Report their run time in the table below.

Evaluate the impact of the steps you took, what their potential benefits and setbacks may be, and what you would advise as the next steps to improve the performance of this query.

Required information

[The following information applies to the questions displayed below.]

In January 2017, Mitzu Co. pays $2,700,000 for a tract of land with two buildings on it. It plans to demolish Building 1 and build a new store in its place. Building 2 will be a company office; it is appraised at $854,000, with a useful life of 20 years and a $90,000 salvage value. A lighted parking lot near Building 1 has improvements (Land Improvements 1) valued at $427,000 that are expected to last another 14 years with no salvage value. Without the buildings and improvements, the tract of land is valued at $1,769,000. The company also incurs the following additional costs:

2. Prepare a single journal entry to record all the incurred costs assuming they are paid in cash on January 1, 2017.