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.

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.

Select every combination of chemicals that will produce a buffer when dissolved in water.

The city of Bloomington is about to build a new water treatment plant. Once the plant is designed (D) we can select the site (S), the building contractor (C and the operating personnel (P). Once the site is selected we may erect the building (B). We can order the water treatment machine (W) and prepare the operations manual (M) only after the contractor is selected. We can begin training the operators (T) when both the operations manual and operating personnel selected are completed.  When the water treatment and building are finished, we can install the treatment machine (I). Once the treatment machine is installed and the operators are trained, we can obtain an operating license (L). The time to complete each activity is assumed to be a normal distribution and the estimated mean and standard deviation of the time (in months) needed to complete each activity is defined below:

1. Draw the PERT network for the project
2. Calculate the critical path and estimated completion time of the project
3. Using this estimated completion time, determine the probability of completing the project in (1) under 50 months and (2) over 55 months
4. Use simulation to calculate the estimated completion time and to determine the probability of completing the project in (1) under 50 months and (2) over 55 months (use a monte carlo simulation of 200 repetitions)
5. Explain why the answers to questions (b) and (c ) may differ to that determined in question (d).
6. Use simulation to estimate the probability that B, I and T are critical activities

• On January 1, 2006 the Excel Delivery Company purchased a delivery van for $65,000.
• Useful life is 5 years and it has a salvage value of $15,000
• The company expects to drive the van 125,000 miles
• The following is the actual miles driven
  • 2006 – 40,000 miles
  • 2007 – 35,000 miles
  • 2008 – 25,000 miles
  • 2009 – 21,000 miles
  • 2010 – 11,000 miles

Required – Calculate annual depreciation for the five year life of the van using each of the following methods – (round to nearest dollar):

• Straight line
• Sum of the years digits
• Double declining method
• Units of production using miles driven

1. A) Provide a graphical illustration and interpretation of peak load pricing when there are two classes of visitors to Lory State Park (say high season and low season visitors). B) Discuss two policy alternatives available to manage visitors when demand can exceed capacity at times, but not always. C) Demonstrate graphically when the alternative results in (short term, seasonal) profits to the park. D) What might be done if the Park Service is a nonprofit government agency?

In a park: a 75 kg bicyclist rides 5.8 m/s north; a 24 kg dog runs 3 m/s east chasing a 3.3 kg squirrel running 2.6 m/s the same way; 200 kg park bench remains stationary; and a 43 kg child runs 1 m/s 45^◦ south of east. What is the magnitude of the total momenta of this park system?

Report the value in kg*m/s rounded to the nearest whole number.