3. Apple’s Worldwide Revenues from 2004 to 2019 is as follows:
Year Worldwide Revenue in Billions
2004 8.2
2005 13.9
2006 19.3
2007 24.6
2008 37.5
2009 42.9
2010 65.2
2011 108.2
2012 156.5
2013 170.9
2014 182.8
2015 233.72
2016 215.64
2017 229.23
2018 265.6
2019 260.17

a. Enter the data above into the tab labeled Apple. Graph the data in Excel and use your graph to determine what kind of time series pattern exist. Put your answer in your spreadsheet.
b. Make the following forecasts for 2020. For all of them, use Mean Squared Error to determine which of the forecasts is the best. Make sure your answers are clearly labeled.
i. Naïve forecast from one prior time period
ii. Calculate a 4-period moving average
iii. Calculate a 3-period moving average with the following weights for time t: time period t-1=0.8, t-2 = 0.15, t-3=.05
c. In the tab called Apple Smoothing, use the data from 3. to forecast 2020 using an alpha equal to 0.7, 0.8, and 0.9. Using MSE, which one offers the best estimate for 2020?
d. In the tab called Apple Regression, use the information from 3. and run a regression to determine your forecast for 2020
i. Put your regression output in F1 of the same workbook.
ii. Calculate what your forecast is for 2020 in F21.
iii. How does well does this regression equation predict revenue? Write your answer in F22. In addition, explain what your numerical answer means in words.

any have SWOT for shangrila hotel?

.

WHAT IS A LUXURY HOTEL? WHY DO THEY CHARGE A HIGHER PRICE THAN OTHER HOTELS? WHY DO CUSTOMERS PAY THIS HIGHER PRICE? WHAT IS YOUR EXPERIENCE OF A LUXURY HOTEL? DISCUSS WITH REAL LIFE EXAMPLES

WRITE AN ESSAY OF 500 - 1000 IN YOUR WORDS COVERING ALL THESE QUESTIONS AND POST YOUR ANSWER DIRECTLY ON SCHOOLOGY, THANK YOU.

A shipment of 6 television sets contains 2 defective sets. A hotel makes a random purchase of 3 of the sets. If x is the number of defective sets purchased by the hotel, find the cumulative distribution function of the random variable X representing the number of defective. Then using F(x), find

(a)P(X= 1) ;

(b)P(0< X≤2).

1-If you were the manager of a luxury hotel with 300 rooms and different types of restaurants, what functionalities would you want from the PMS? Give examples for the integration between the PMS and three other IT systems.

2-Give examples of other channels that you will use to sell the hotel and how the PMS will help you to manage those channels?

A second-hand car dealer is doing a promotion of a certain model of used truck. Due to differences in the care with which the owners used their cars, there are four possible quality levels (q1 > q2 > q3 > q4) of the trucks on sale. Suppose that the dealer knows the car’s quality (quite obvious), but buyers only know that cars for sale can be of quality q1, q2, q3 or q4. Faced with a given car, the buyers cannot identify its precise quality. However, they believe that there is a probability 0.2 that the quality is q1, a probability 0.3 that it is q2, and a probability 0.3 that it is q3. The respective values of the cars to the buyers are $20,000 for the q1 quality, $15,000 for q2, $10,000 for q3 and $5,000 for q4.

Assume that all agents (including the buyers) are risk neutral (only care about “return”) in the sense that a buyer does not want to pay more for a car than its expected worth and the car owner (the car dealer) does not wish to sell at less than what the car is worth.

a) Define adverse selection in general and in the current context.

b) If all four types of used truck are offered for sale, what is the highest price a buyer would be willing to pay for a used truck? At this price, what type(s) of truck will be offered for sale?

c) Now suppose the $20,000 trucks are no longer offered for sale but other types are (and is known to the buyers). What is the maximum price a buyer is willing to pay for a used truck? At this price, what type(s) of truck will be offered for sale? [Hint: What are the respective probabilities of the types of cars that will be offered for sale?]

d) Explain how adverse selection causes this market to a partial market breakdown (i.e., only the worst used trucks (q4 type) are traded in the market).

A city in Ohio is considering replacing its fleet of gasoline powered cars with electric cars. The manufacturer of the electric cars claims that this municipality will experience significant cost savings over the life of the fleet if it chooses to pursue this conversion. If the manufacturer is correct, the city will save about $1.5 million. If the new technology employed within the electric cars is faulty as some critics suggest, it will cost the city $675,000. A third possibility is that less serious problems will arise and the city will break even in the conversion. A consultant hired by the city estimates the probabilities of these three outcomes are 0.30, 0.30, and 0.40, respectively. The city has an opportunity to implement a pilot program that would indicate the potential cost or savings resulting from the switch to electric cars. The pilot program involves renting a small number of electric cars for three months and running them under typical conditions. This program would cost the city $75,000. The city’s consultant believes that the results of the pilot program would be significant but not conclusive. She submits the following compilation of probabilities based on the experience of other cities to support her contention.

For example, the first column of her table indicates that given that the conversion to electric cars actually results in a savings, the conditional probabilities that the pilot program will indicate that the city saves money, loses money, and breaks even are 0.6, 0.1, and 0.3. What actions should the city take to maximize its expected savings?

Solve with Decision Tree clearly in Excel

Question 1: In class, you have seen how to calculate the maximum speed for a car to go around a flat curve (with friction), and for a banked curve (without friction). Here, you will consider the general case. (For each question part below, include a free-body diagram.) a) (3 points) Explain briefly why the car can go around the banked curve safely even without friction, and why that is not the case for the flat curve. b) (5 points) Now consider a curve that is banked so that a car can safely take it at a speed of 85 km/h, even if there were no friction. Assuming the radius of the curve is 68 m, calculate the angle at which it has been built. c) (6 points) For the banked curve, calculate the maximum speed that a car can have to safely go through it if the coefficient of static friction is 0.3. What will happen if the car is faster? d) (6 points) For the same curve, calculate the minimum speed the car must have to safely make it through. What will happen if the car is slower?

In class, you have seen how to calculate the maximum speed for a car to go around a flat curve (with friction), and for a banked curve (without friction). Here, you will consider the general case. (For each question part below, include a free-body diagram.) a) (3 points) Explain briefly why the car can go around the banked curve safely even without friction, and why that is not the case for the flat curve. b) (5 points) Now consider a curve that is banked so that a car can safely take it at a speed of 85 km/h, even if there were no friction. Assuming the radius of the curve is 68 m, calculate the angle at which it has been built. c) (6 points) For the banked curve, calculate the maximum speed that a car can have to safely go through it if the coefficient of static friction is 0.3. What will happen if the car is faster? d) (6 points) For the same curve, calculate the minimum speed the car must have to safely make it through. What will happen if the car is slower?