In: Accounting
Provide an evaluation of two proposed projects, both with 5-year expected lives and identical initial outlays of $110,000. Both of thj4ese projects involve additions to Liburdi’s high highly successful hotel product line, and as a result, the required rate of return on both projects has been established at 12 percent. The expected free cash flows from each project are as follows:
|
Project A |
Project B |
|
|
Initial outlay |
-$110,000 |
-$110,000 |
|
Inflow year 1 |
20,000 |
40,000 |
|
Inflow year 2 |
30,000 |
40,000 |
|
Inflow year 3 |
40,000 |
40,000 |
|
Inflow year 4 |
50,000 |
40,000 |
|
Inflow year 5 |
70,000 |
40,000 |
In evaluating these projects, please respond to the following questions:
In: Accounting
Using Excel
Data in Travel file shows the average number of rooms in a variety of U.S cities and the average room rate and the average amount spent on entertainment. A company that run events for hotel residents wants to predict the amount spent on entertainment based on room rate and number of rooms.
Run the regression analysis. Are the coefficients statistically significant? Do we need to drop one of these variable? Which variable? Interpret the slope of the estimated regression equation?
Develop the least squares estimated regression equation. The average room rate in Chicago is $128, predict the entertainment expense per day for Chicago.
| City | Entertainment ($) | Room Rate ($) | # of rooms |
| Boston | 160 | 149 | 63 |
| Denver | 104 | 98 | 500 |
| Nashville | 100 | 90 | 460 |
| New Orleans | 141 | 111 | 300 |
| Phoenix | 101 | 91 | 650 |
| San Diego | 121 | 103 | 350 |
| San Francisco | 167 | 134 | 200 |
| San Jose | 141 | 91 | 230 |
| Tampa | 97 | 81 | 126 |
In: Statistics and Probability
1. In the following three situations, the market is initially in
equilibrium. Explain the changes in either supply or demand that
result from each event. After each event described below, does a
surplus or shortage exist at the original equilibrium price? What
will happen to the equilibrium price as a result? Demonstrate your
answer graphically.
A. 2015 was a very good year for California wine-grape growers, who
produced a lot of grapes.
B. After a hurricane, Florida hoteliers often find that many people
cancel their upcoming vacations, leaving them with empty hotel
rooms.
C. Consider the market for new snowblowers. After a heavy snowfall,
many people want to buy second-hand snowblowers at the local tool
shop.
2. Use a supply and demand model to explain how the following
occurrence is possible.
Lobster prices usually fall during the summer peak lobster harvest
season, despite the fact that people like to eat lobster during the
summer more than at any other time of year.
In: Economics
Text exercise 39 page 638. This question uses the same data as exercise 2 above, and the data is in the accompanying spreadsheet.
(a) Estimate the regression in Excel and report the regression line. [2 pts]
(b) Calculate a 95% confidence interval for the forecast of the average amount spent on entertainment at a city where the room rate is $89. [3 pts]
(b) Calculate a 90% confidence interval for the forecast of the idiosyncratic amount spent on entertainment at a city where the room rate is the average rate of $128. [3 pts]
(d) Use a t-test to test the hypothesis that there is a 1 to 1 relationship between entertainment expenses and hotel expenses. (ie test H0: β=1)
DATA:
| Data for Problem 39 p638 | |||
| city | room rate | Entertainment | |
| Boston | 148 | 161 | |
| Denver | 96 | 105 | |
| Nashville | 91 | 101 | |
| New Orleans | 110 | 142 | |
| Phoenix | 90 | 100 | |
| San Fdiego | 102 | 120 | |
| San Francisco | 136 | 167 | |
| San Jose | 90 | 140 | |
| Tampa | 82 | 98 | |
In: Statistics and Probability
[The following information applies to the questions displayed below.] The following data pertain to the Aquarius Hotel Supply Company for the year just ended. Budgeted sales revenue
|
Budgeted sales revenue |
$ |
200,000 |
|
Budgeted manufacturing overhead |
364,000 |
|
|
Budgeted machine hours (based on practical capacity) |
10,000 |
|
|
Budgeted direct-labor hours (based on practical capacity) |
20,000 |
|
|
Budgeted direct-labor rate per hour |
13 |
|
|
Actual manufacturing overhead |
338,000 |
|
|
Actual machine hours |
11,000 |
|
|
Actual direct-labor hours |
18,000 |
|
|
Actual direct-labor rate per hour |
17 |
Required: 1. Compute the firm’s predetermined overhead rate for the year using each of the following common cost drivers: a. machine hours b. direct labor hours c. direct labor dollars
2. Calculate the overapplied or underapplied overhead for the year using each of the following cost drivers. a. machine hours b. direct labor hours c. direct labor dollars
In: Accounting
Forecasting Exercise Every year the U of I hosts the Lionel Hampton Jazz Festival. Below you will find some issues that need to be forecast in order to provide the best experience possible to customers, develop effective plans, and deliver "profits" to businesses. How many schools (and students) will be attending? How many will attend Saturday night’s concert? (Lionel Hampton Jazz Festival Big Band) What will be room availability in Lewiston because of the festival? What should I charge for my hotel rooms during the busy weekend? Is there a threshold? How much more should Casa Lopez be ordering for Thursday, Friday, and Saturday? What will the economic impact be to the city of Moscow? Select two or three and write a double-spaced paper telling what you forecasted and how you came up with the forecast you made – discuss the mechanics of how you would develop your forecasts. The specific numbers are not as important as demonstrating a well thought out approach to your forecast.
In: Operations Management
The Marriott company (Marriott: Reducing Our Footprint) makes the following claim about its "sustainability strategy":
Our sustainability strategy supports business growth and reaches beyond the doors of our hotels to preserve and protect our planet’s natural resources. Marriott’s environmental goals are to:
• Further reduce energy and water consumption 20% by 2020
(Energy 20 percent per kWh/conditioned m2; Water 20 percent per
occupied room (POR). Baseline: 2007);
• Empower our hotel development partners to build green
hotels;
• Green our multi-billion dollar supply chain;
• Educate and inspire associates and guests to conserve and
preserve;
Address environmental challenges through innovative conservation initiatives including rainforest protection and water conservation.
Find statements from two other companies that detail their environmental; policy/sustainability strategy. Summarize those statements. Critically evaluate the policies/strategies - Are they good policies/strategies? Will they truly help the environment?
In: Operations Management
For this assignment, you play the role of an marketing analyst for an online travel site called GlobalTrekTravel (GTT, a fictitious online business used for this course). GTT is focused on international travelers and provides online booking tools for airfare, ground transportation, hotel and sight-seeing tours, travel insurance, language support with translation services, passport and visa document preparation, and medical immunization recommendations. In sum, GTT addresses all needs of an international business or holiday travelers to have successful journeys. GTT’s marketing focuses on this value proposition: “We give you integrated travel services for all your International business and personal travel needs, saving time and frustration. We stay current to the world’s everchanging travel conditions, reducing your travel stressors.”
Your objective is to help them better understand their customers and find ways to use digital channels and data to serve their needs. They are seeking a customer journey analysis, that will allow them to take appropriate action.
In: Operations Management
The Marriott company (Marriott: Reducing Our Footprint) makes the following claim about its "sustainability strategy":
Our sustainability strategy supports business growth and reaches beyond the doors of our hotels to preserve and protect our planet’s natural resources. Marriott’s environmental goals are to:
• Further reduce energy and water consumption 20% by 2020
(Energy 20 percent per kWh/conditioned m2; Water 20 percent per
occupied room (POR). Baseline: 2007);
• Empower our hotel development partners to build green
hotels;
• Green our multi-billion dollar supply chain;
• Educate and inspire associates and guests to conserve and
preserve;
Address environmental challenges through innovative conservation initiatives including rainforest protection and water conservation.
Find statements from two other companies that detail their environmental; policy/sustainability strategy. Summarize those statements. Critically evaluate the policies/strategies - Are they good policies/strategies? Will they truly help the environment?
In: Operations Management