HAS TO BE SOLVED IN EXCEL

Exercise 5A–1 High-Low Method LO5–11 NEEDS to be solved and shown in excel The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days over the last year. An occupancy-day represents a room rented for one day. The hotel’s business is highly seasonal, with peaks occurring during the ski season and in the summer. Month Occupancy-Days Electrical Costs January 1,736 $  4,127 February 1,904 $4,207 March 2,356 $5,083 April 960 $2,857 May 360 $   1,871 June 744 $2,696 July 2,108 $4,670 August 2,406 $ 5,148 September 840 $   2,691 October 124 $   1,588 November 720 $2,454 December 1,364 $3,529 Required: Using the high-low method, estimate the fixed cost of electricity per month and the variable cost of electricity per occupancy-day. Round off the fixed cost to the nearest whole dollar and the variable cost to the nearest whole cent. What other factors in addition to occupancy-days are likely to affect the variation in electrical costs from month to month

The mean area of homes in a certain city built in 2009 was 2438 square feet. Assume that a simple random sample of 11 homes in the same city built in 2010 had a mean area of 2,297 square feet, with a standard deviation of 225 square feet. An insurance company wants to know if the mean area of homes built in 2010 is less than that of homes built in 2009. Compute the P-value of the test.

Write down your P-value. You will need it for the next question.

Write only a number as your answer. Round to four decimal places (for example: 0.3841).

In the last question, an insurance company wants to know if the mean area of homes built in 2010 is less than that of homes built in 2009. What is the conclusion at the 0.05 level of significance?

Question 13 options:

In the late 1970s, there was a major controversy over a dam built by the Tennessee Valley Authority called the Tellico Dam, which is located near the mouth of the Little Tennessee River. After construction was completed and almost all of the land purchases (or evictions) had been done, the Supreme Court ruled that it could not go on because of the presence in the Little Tennessee of a fish on the endangered species list called the Snail Darter. (Congress later voted to exempt the dam from the law and the dam was closed in the late fall of 1979, creating Tellico Lake.) While the economic benefits of the dam were admittedly dubious, one of the common arguments for completing the project was this: "We have spent more than $100 million to build this dam. We need to complete it because we will have wasted all this money otherwise." Please evaluate this argument from an economic point of view.

1. You decide to purchase a van to transport your hotel guests to and from the airport. This is a new service you are adding to your hotel because you have noticed from your STR reports that your competitors are having better occupancy percentages and slightly better ADRs. And after some research, you do have a very comparable product but your current guests have also put in their comment cards that they wish you would provide airport transportation. The cost of the van with the upgrades totals $75,000. You are not charging your guests anything but you have estimated that this new service, you should have an increase in your annual cash flow of $28,000 for the next 5 years. What is the IRR of this van?

20. An existing public park serving 1.8 Million visitor/year is to be improved. Initial cost is SR 2.25 Million and the annual operating and maintenance cost starts with SR 0.145 Million during the first year and increases 3%/year thereafter. The planning horizon is 20 years, the salvage value is 32% of the initial cost, and the interest rate is 10%. The minimum additional benefits/visit that will justify the facility improvement is closest to: a) SR 0.17 b) SR 0.24 c) SR 0.15 d) SR 0.3

An existing public park serving 1.8 Million visitor/year is to be improved. Initial cost is SR 2.25 Million and the annual operating and maintenance cost starts with SR 0.145 Million during the first year and increases 3%/year thereafter. The planning horizon is 20 years, the salvage value is 32% of the initial cost, and the interest rate is 15%. The minimum additional benefits/visit that will justify the facility improvement is closest to:

a) SR 0.19

b) SR 0.25

c) SR 0.16

d) SR 0.29

Question 2 – ALL CALCULATIONS MUST BE SHOWN

A local theme park is losing money. The current price of admission is $60 per person with an average daily attendance of 750 people. You are an independent consultant employed to recommend a pricing strategy. The demand schedule estimated by the consultant is shown in the table below.

a. Fill in the blanks in the table above. There are 7 empty cells [marked as 0.5 marks per cell correctly filled]. Use the point method (ΔQ/ΔP)*(P/Q) to calculate the own-price elasticity of demand. (3.5 marks)

b. As a consultant what would be your recommendation regarding pricing strategy? Should the theme park change the price from $60? Justify your answer based on the price elasticity of demand. .

c. From the information in the table write the equation for the daily demand for theme park tickets in price dependent form (P=a-bQ). (2.5 marks)

d. Use the midpoint method to calculate the price elasticity of demand from $85 to $90. Explain whether demand is price elastic or price inelastic and interpret the value of this elasticity.

e. Theme park customers are able to purchase a $15 photographic package. At the current ticket price of $60, 34% of customers purchase photographic packages. The theme park estimates that a $3 price increase in theme park tickets would result in a 20% reduction in photographic packages purchased. Provide the name of, and calculate the value of, this elasticity. Interpret its value. What does this elasticity value tell the theme park managers about the relationship between theme park ticket prices and photographic packages? How many customers would purchase the photographic packages if theme park tickets increased by $3?

Question:5

1. What is meant by the standard error of the mean?
2. What is meant by a Type I and a Type II error?
3. What is the difference between a one and two tail test?

4. In September 2019, a Travel Agent used a random sample of 36 holiday makers to find out the average cost per person of a one week holiday in Queen Elizabeth National Park. The following information was found:

September 2019

          Mean                       $372.40

         Standard deviation $26.10

         Sample size 36

In the previous year the average cost of each holiday was $356.20.

1. Test whether the cost of a one week holiday to Queen Elizabeth National Park has increased significantly since the previous year.
2. The company based its views on customer satisfaction from the letters it receives. In the previous year, 68% of the letters it received were of a positive nature.

The company wishes to adopt a more scientific approach to estimating customer satisfaction.

What sample size would be needed to estimate the proportion of customers’ views to within 2% of the true figure at the 95% confidence limit and Interval